Nieuw spel

CREATE TABLE `User` (
`id` int(10) NOT NULL auto_increment,
`start` datetime NOT NULL default '0000-00-00 00:00:00',
`name` varchar(20) NOT NULL default '',
`password` varchar(20) NOT NULL default '',
`email` varchar(20) NOT NULL default '',
`online` datetime NOT NULL default '0000-00-00 00:00:00',
`village` varchar(20) NOT NULL default '',
`sex` varchar(20) NOT NULL default '',
`city` varchar(20) NOT NULL default '',
`info` text NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY `name` (name)
) TYPE=MyISAM;


CREATE TABLE `Village` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(20) NOT NULL default '',
`iron` varchar(20) NOT NULL default '',
`stone` varchar(20) NOT NULL default '',
`wood` varchar(20) NOT NULL default '',
`points` varchar(20) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;


CREATE TABLE `Main` (
`village` varchar(20) NOT NULL default '',
`level` int(5) NOT NULL default '0',
`time` datetime NOT NULL default '0000-00-00 00:00:00',
) TYPE=MyISAM;


CREATE TABLE `Farm` (
`village` varchar(20) NOT NULL default '',
`level` int(5) NOT NULL default '0',
`population` int(5) NOT NULL default '0',
`time` datetime NOT NULL default '0000-00-00 00:00:00',
) TYPE=MyISAM;


CREATE TABLE `Barracks` (
`village` varchar(20) NOT NULL default '',
`level` int(5) NOT NULL default '0',
`time` datetime NOT NULL default '0000-00-00 00:00:00',
) TYPE=MyISAM;


CREATE TABLE `Storage` (
`village` varchar(20) NOT NULL default '',
`level` int(5) NOT NULL default '0',
`capacity` int(10) NOT NULL default '0',
`time` datetime NOT NULL default '0000-00-00 00:00:00',
) TYPE=MyISAM;


CREATE TABLE `Hide` (
`village` varchar(20) NOT NULL default '',
`level` int(5) NOT NULL default '0',
`time` datetime NOT NULL default '0000-00-00 00:00:00',
) TYPE=MyISAM;


CREATE TABLE `Place` (
`village` varchar(20) NOT NULL default '',
`level` int(5) NOT NULL default '0',
`time` datetime NOT NULL default '0000-00-00 00:00:00',
) TYPE=MyISAM;


CREATE TABLE `Wall` (
`village` varchar(20) NOT NULL default '',
`level` int(5) NOT NULL default '0',
`protection` int(5) NOT NULL default '0',
`time` datetime NOT NULL default '0000-00-00 00:00:00',
) TYPE=MyISAM;


CREATE TABLE `Iron` (
`village` varchar(20) NOT NULL default '',
`level` int(5) NOT NULL default '0',
`production` int(20) NOT NULL default '0',
`time` datetime NOT NULL default '0000-00-00 00:00:00',
) TYPE=MyISAM;


CREATE TABLE `Stone` (
`village` varchar(20) NOT NULL default '',
`level` int(5) NOT NULL default '0',
`production` int(20) NOT NULL default '0',
`time` datetime NOT NULL default '0000-00-00 00:00:00',
) TYPE=MyISAM;


CREATE TABLE `Wood` (
`village` varchar(20) NOT NULL default '',
`level` int(5) NOT NULL default '0',
`production` int(20) NOT NULL default '0',
`time` datetime NOT NULL default '0000-00-00 00:00:00',
) TYPE=MyISAM;


CREATE TABLE `Hash` (
`name` varchar(20) NOT NULL default '',
`hash` varchar(20) NOT NULL default '',
UNIQUE KEY `hash` (hash)
) TYPE=MyISAM;


CREATE TABLE `Position` (
`village` varchar(20) NOT NULL default '',
`x-position` int(5) NOT NULL default '0',
`y-position` int(5) NOT NULL default '0'
) TYPE=MyISAM;


CREATE TABLE `Buddy` (
`name` varchar(20) NOT NULL default '',
`buddy` varchar(20) NOT NULL default ''
) TYPE=MyISAM;


CREATE TABLE `Message` (
`id` int(10) NOT NULL auto_increment,
`time` datetime NOT NULL default '0000-00-00 00:00:00',
`from` varchar(20) NOT NULL default '',
`to` varchar(20) NOT NULL default '',
`message` varchar(20) NOT NULL default '',
`read` int(1) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;


CREATE TABLE `Built` (
`village` varchar(20) NOT NULL default '',
`main` datetime NOT NULL default '0000-00-00 00:00:00',
`farm` datetime NOT NULL default '0000-00-00 00:00:00',
`barracks` datetime NOT NULL default '0000-00-00 00:00:00',
`storage` datetime NOT NULL default '0000-00-00 00:00:00',
`hide` datetime NOT NULL default '0000-00-00 00:00:00',
`place` datetime NOT NULL default '0000-00-00 00:00:00',
`wall` datetime NOT NULL default '0000-00-00 00:00:00'
) TYPE=MyISAM;