Data Base

Query to create a database with the correct structure

CREATE TABLE IF NOT EXISTS `zones` (
  `x1` int(11) NOT NULL,
  `y1` int(11) NOT NULL,
  `z1` int(11) NOT NULL,
  `x2` int(11) NOT NULL,
  `y2` int(11) NOT NULL,
  `z2` int(11) NOT NULL,
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `world` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  KEY `ID` (`ID`)
)

Comments

Posts Quoted:
Reply
Clear All Quotes