· 7 years ago · Oct 31, 2018, 04:04 PM
1CREATE TABLE IF NOT EXISTS `housefurnitures` (
2 `ID` int(11) NOT NULL auto_increment,
3 `HouseID` int(11) NOT NULL,
4 `FurnitureID` tinyint(11) NOT NULL,
5 `FurnitureX` float NOT NULL,
6 `FurnitureY` float NOT NULL,
7 `FurnitureZ` float NOT NULL,
8 `FurnitureRX` float NOT NULL,
9 `FurnitureRY` float NOT NULL,
10 `FurnitureRZ` float NOT NULL,
11 `FurnitureVW` int(11) NOT NULL,
12 `FurnitureInt` int(11) NOT NULL,
13 PRIMARY KEY (`ID`)
14 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;