tables.sql

CREATE TABLE `lbmain` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `player` varchar(32) NOT NULL DEFAULT '-',
  `replaced` int(11) NOT NULL DEFAULT '0',
  `type` int(11) NOT NULL DEFAULT '0',
  `data` TINYINT NOT NULL DEFAULT '0',
  `x` int(11) NOT NULL DEFAULT '0',
  `y` int(11) NOT NULL DEFAULT '0',
  `z` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `coords` (`y`,`x`,`z`),
  KEY `type` (`type`),
  KEY `data` (`data`),
  KEY `replaced` (`replaced`),
  KEY `player` (`player`)
);

CREATE TABLE `lbmain-extra` (
  `id` int(11) NOT NULL,
  `extra` text,
  PRIMARY KEY (`id`)
);

 CREATE TABLE `nlbmain` (   `id` int(11) NOT NULL AUTO_INCREMENT,   `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',   `player` varchar(32) NOT NULL DEFAULT '-',   `replaced` int(11) NOT NULL DEFAULT '0',   `type` int(11) NOT NULL DEFAULT '0',   `data` TINYINT NOT NULL DEFAULT '0',   `x` int(11) NOT NULL DEFAULT '0',   `y` int(11) NOT NULL DEFAULT '0',   `z` int(11) NOT NULL DEFAULT '0',   PRIMARY KEY (`id`),   KEY `coords` (`y`,`x`,`z`),   KEY `type` (`type`),   KEY `data` (`data`),   KEY `replaced` (`replaced`),   KEY `player` (`player`) );  CREATE TABLE `nlbmain-extra` (   `id` int(11) NOT NULL,   `extra` text,   PRIMARY KEY (`id`) );