CTL.sql

CREATE TABLE IF NOT EXISTS `benutzer` (
  `Name` varchar(24) NOT NULL,
  `Passwort` varchar(64) NOT NULL,
  `Frage` varchar(128) NOT NULL,
  `Antwort` varchar(128) NOT NULL,
  `Heimat` varchar(128) NOT NULL,
  `Cash` int(128) NOT NULL,
  `Points` int(128) NOT NULL,
  `Adminlvl` int(128) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `ticket` (
  `Name` varchar(24) NOT NULL,
  `Titel` varchar(128) NOT NULL,
  `Text` varchar(128) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;