· 8 years ago · Feb 03, 2018, 12:54 AM
1CREATE TABLE IF NOT EXISTS `actors` (
2 `aID` int(11) NOT NULL AUTO_INCREMENT,
3 `aPosX` float NOT NULL,
4 `aPosY` float NOT NULL,
5 `aPosZ` float NOT NULL,
6 `aAngle` float NOT NULL,
7 `aName` varchar(24) NOT NULL,
8 `aSkin` int(3) NOT NULL,
9 `aColor` int(2) NOT NULL,
10 `aVirtual` int(5) NOT NULL,
11 `aStatus` int(1) NOT NULL,
12 PRIMARY KEY (`aID`)
13) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;