08.08.2016, 22:58
PHP код:
new query[1024];
strcat(query, "CREATE TABLE IF NOT EXISTS `houses` (\
`ID` int(11) NOT NULL,\
`HouseName` varchar(48) NOT NULL default 'House For Sale',\
`HouseOwner` varchar(24) NOT NULL default '-',\
`HousePassword` varchar(16) NOT NULL default '-',\
`HouseX` float NOT NULL,\
`HouseY` float NOT NULL,\
`HouseZ` float NOT NULL,\
`HousePrice` int(11) NOT NULL,\
`HouseInterior` tinyint(4) NOT NULL default '0',\
`HouseLock` tinyint(4) NOT NULL default '0',\
`HouseMoney` int(11) NOT NULL default '0',"
);
strcat(query, "`LastEntered` int(11) NOT NULL,\
PRIMARY KEY (`ID`),\
UNIQUE KEY `ID_2` (`ID`),\
KEY `ID` (`ID`)\
) ENGINE=InnoDB DEFAULT CHARSET=utf8;"
);
mysql_tquery(SQLHandle, query, "", "");
mysql_tquery(SQLHandle, "CREATE TABLE IF NOT EXISTS `housefurnitures` (\
`ID` int(11) NOT NULL auto_increment,\
`HouseID` int(11) NOT NULL,\
`FurnitureID` tinyint(11) NOT NULL,\
`FurnitureX` float NOT NULL,\
`FurnitureY` float NOT NULL,\
`FurnitureZ` float NOT NULL,\
`FurnitureRX` float NOT NULL,\
`FurnitureRY` float NOT NULL,\
`FurnitureRZ` float NOT NULL,\
`FurnitureVW` int(11) NOT NULL,\
`FurnitureInt` int(11) NOT NULL,\
PRIMARY KEY (`ID`)\
) ENGINE=MyISAM DEFAULT CHARSET=utf8;", "", "");
mysql_tquery(SQLHandle, "CREATE TABLE IF NOT EXISTS `houseguns` (\
`HouseID` int(11) NOT NULL,\
`WeaponID` tinyint(4) NOT NULL,\
`Ammo` int(11) NOT NULL,\
UNIQUE KEY `HouseID_2` (`HouseID`,`WeaponID`),\
KEY `HouseID` (`HouseID`),\
CONSTRAINT `houseguns_ibfk_1` FOREIGN KEY (`HouseID`) REFERENCES `houses` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE\
) ENGINE=InnoDB DEFAULT CHARSET=utf8;", "", "");
mysql_tquery(SQLHandle, "CREATE TABLE IF NOT EXISTS `housevisitors` (\
`HouseID` int(11) NOT NULL,\
`Visitor` varchar(24) NOT NULL,\
`Date` int(11) NOT NULL\
) ENGINE=MyISAM DEFAULT CHARSET=utf8;", "", "");
mysql_tquery(SQLHandle, "CREATE TABLE IF NOT EXISTS `housekeys` (\
`HouseID` int(11) NOT NULL,\
`Player` varchar(24) NOT NULL,\
`Date` int(11) NOT NULL\
) ENGINE=MyISAM DEFAULT CHARSET=utf8;", "", "");
mysql_tquery(SQLHandle, "CREATE TABLE IF NOT EXISTS `housesafelogs` (\
`HouseID` int(11) NOT NULL,\
`Type` int(11) NOT NULL,\
`Amount` int(11) NOT NULL,\
`Date` int(11) NOT NULL\
) ENGINE=MyISAM DEFAULT CHARSET=utf8;", "", "");
mysql_tquery(SQLHandle, "CREATE TABLE IF NOT EXISTS `housesales` (\
`ID` int(11) NOT NULL AUTO_INCREMENT,\
`OldOwner` varchar(24) NOT NULL,\
`NewOwner` varchar(24) NOT NULL,\
`Price` int(11) NOT NULL,\
PRIMARY KEY (`ID`)\
) ENGINE=MyISAM DEFAULT CHARSET=utf8;", "", "");