Code: Select all
CREATE TABLE `content` (
`id` int(11) NOT NULL auto_increment,
`title` text NOT NULL,
`body` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM ;
CREATE TABLE `nav` (
`id` int(11) NOT NULL auto_increment,
`menus` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM ;
CREATE TABLE `news` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`author` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`date` date NOT NULL default '0000-00-00',
`body` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM ;
CREATE TABLE `users` (
`id` int(11) NOT NULL auto_increment,
`user` varchar(50) NOT NULL default '',
`pass` varchar(255) NOT NULL default '',
`email` varchar(255) NOT NULL default '',
`race` varchar(255) NOT NULL default '', <------- this is the 'RACE'...
`first` varchar(255) default NULL,
`location` varchar(255) default NULL,
`website` varchar(255) default NULL,
`level` int(11) NOT NULL default '0',
`showemail` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM ;feyd | tweaked title to make quicker sense