table: mudObject
DROP TABLE IF EXISTS mudObject;
CREATE TABLE mudObject (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
name varchar(45) NOT NULL,
description varchar(255) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
table: mudBuilding
DROP TABLE IF EXISTS mudBuilding;
CREATE TABLE mudBuilding (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
code varchar(45) NOT NULL,
name varchar(45) NOT NULL,
description varchar(255) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
table: mudBuildingInstance
DROP TABLE IF EXISTS mudBuildingInstance;
CREATE TABLE mudBuildingInstance (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
mudBuildingId int(10) unsigned NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
table: mudRoom
DROP TABLE IF EXISTS mudRoom;
CREATE TABLE mudRoom (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
mudBuildingCode varchar(45) NOT NULL,
code varchar(45) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
table: mudObjectIsRoomLink
DROP TABLE IF EXISTS mudObjectIsRoomLink;
CREATE TABLE mudObjectIsRoomLink (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
mudObjectId int(10) unsigned NOT NULL,
mudBuildingInstanceId int(10) unsigned NOT NULL,
mudRoomId int(10) unsigned NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
table: mudDoor
DROP TABLE IF EXISTS mudDoor;
CREATE TABLE mudDoor (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
mudBuildingCode varchar(45) NOT NULL,
sourceMudRoomCode varchar(45) NOT NULL,
targetMudRoomCode varchar(45) NOT NULL,
inOpenFlag bit(1) NULL,
outOpenFlag bit(1) NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
table: mudObjectIsDoorLink
DROP TABLE IF EXISTS mudObjectIsDoorLink;
CREATE TABLE mudObjectIsDoorLink (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
mudObjectId int(10) unsigned NOT NULL,
mudBuildingInstanceId int(10) unsigned NOT NULL,
mudDoorId int(10) unsigned NOT NULL,
inOpenFlag bit(1) NULL,
outOpenFlag bit(1) NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
table: mudFunction
DROP TABLE IF EXISTS mudFunction;
CREATE TABLE mudFunction (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
code varchar(45) NOT NULL,
name varchar(45) NOT NULL,
description varchar(255) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
table: mudRoomBehavior
DROP TABLE IF EXISTS mudRoomBehavior;
CREATE TABLE mudRoomBehavior (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
mudBuildingCode varchar(45) NOT NULL,
mudRoomCode varchar(45) NOT NULL,
needRank int(10) unsigned NULL,
mudFunctionCode varchar(45) NULL,
ifMudRoomCode varchar(45) NULL,
elseMudRoomCode varchar(45) NULL,
errorMudRoomCode varchar(45) NULL,
activeFlag bit(1) NULL,
deprecatedFlag bit(1) NULL,
stopOnErrorFlag bit(1) NULL,
parameters varchar(1024) NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
table: mudActivity
DROP TABLE IF EXISTS mudActivity;
CREATE TABLE mudActivity (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
mudObjectId int(10) unsigned NOT NULL,
mudRoomId int(10) unsigned NOT NULL,
mudDoorId int(10) unsigned NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
table: mudActivityVarInt
DROP TABLE IF EXISTS mudActivityVarInt;
CREATE TABLE mudActivityVarInt (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
mudActivityId int(10) unsigned NOT NULL,
activityKey varchar(10) NOT NULL,
value int(10) NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
table: mudActivityVarBit
DROP TABLE IF EXISTS mudActivityVarBit;
CREATE TABLE mudActivityVarBit (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
mudActivityId int(10) unsigned NOT NULL,
activityKey varchar(10) NOT NULL,
value bit(1) NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
table: mudActivityVarString
DROP TABLE IF EXISTS mudActivityVarString;
CREATE TABLE mudActivityVarString (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
mudActivityId int(10) unsigned NOT NULL,
activityKey varchar(10) NOT NULL,
value varchar(1024) NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;