CREATE TABLE `bericht` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `server` varchar(9) NOT NULL DEFAULT '',
  `nick` varchar(27) NOT NULL DEFAULT '',
  `bericht` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `server` (`server`,`nick`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `cache` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `commando` varchar(255) NOT NULL DEFAULT '',
  `bericht` text NOT NULL,
  `verloopt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `commando` (`commando`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `gebruiker` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `server` varchar(9) NOT NULL DEFAULT '',
  `nick` varchar(27) NOT NULL DEFAULT '',
  `userhost` varchar(255) NOT NULL DEFAULT '',
  `datum` date NOT NULL DEFAULT '0000-00-00',
  `geblokt` enum('nee','nogniet','bijna','ja') NOT NULL DEFAULT 'nee',
  `wanneer` datetime DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `server` (`server`,`nick`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `lijstje` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `server` varchar(9) NOT NULL DEFAULT '',
  `nick` varchar(27) NOT NULL DEFAULT '',
  `lijstje` varchar(1023) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniek` (`server`,`nick`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `waarschuw` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `server` varchar(9) NOT NULL DEFAULT '',
  `nick` varchar(27) NOT NULL DEFAULT '',
  `wanneer` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `bericht` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uniek` (`server`,`nick`,`wanneer`,`bericht`),
  KEY `wanneer` (`wanneer`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
