table: slObject
DROP TABLE IF EXISTS slObject;
CREATE TABLE slObject (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
ownerId int(10) unsigned NOT NULL,
slKey varchar(37) NOT NULL,
name varchar(100) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
table: slAvatar
DROP TABLE IF EXISTS slAvatar;
CREATE TABLE slAvatar (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
slKey varchar(37) NOT NULL,
name varchar(100) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
table: slRegion
DROP TABLE IF EXISTS slRegion;
CREATE TABLE slRegion (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
name varchar(50) NOT NULL,
coordX varchar(7) NOT NULL,
coordY varchar(7) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
table: slObjectLocation
DROP TABLE IF EXISTS slObjectLocation;
CREATE TABLE slObjectLocation (
id int(10) unsigned NOT NULL AUTO_INCREMENT,
insertDateTime datetime NOT NULL,
objectId int(10) unsigned NOT NULL,
regionId int(10) unsigned NOT NULL,
posX varchar(11) NOT NULL,
posY varchar(11) NOT NULL,
posZ varchar(11) NOT NULL,
rotA varchar(9) NOT NULL,
rotB varchar(9) NOT NULL,
rotC varchar(9) NOT NULL,
rotD varchar(9) NOT NULL,
velX varchar(9) NOT NULL,
velY varchar(9) NOT NULL,
velZ varchar(9) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TRIGGER slObjectLocation BEFORE INSERT ON slObjectLocation FOR EACH ROW SET NEW.insertDateTime = now();