From the looks of it you are getting problems because somehow the required SQL queries are getting messed up as you run them, what program are you using to run the queries?
I'll list the 3 queries needed below for you, my recomendation is that you run each one sepratly using phpMyAdmin.
[sql]CREATE TABLE `vbs_chapters` (
`id` bigint(20) NOT NULL auto_increment,
`chapterid` int(11) NOT NULL default '0',
`storyid` int(11) NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`body` text NOT NULL,
`path1` varchar(100) NOT NULL default '',
`path2` varchar(100) NOT NULL default '',
`userid` int(11) NOT NULL default '0',
`dateline` int(10) NOT NULL default '0',
`display` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;[/sql]
[sql]CREATE TABLE `vbs_genres` (
`genreid` int(11) NOT NULL auto_increment,
`title` varchar(100) NOT NULL default '',
`display` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`genreid`)
) TYPE=MyISAM;[/sql]
[sql]CREATE TABLE `vbs_stories` (
`storyid` int(11) NOT NULL auto_increment,
`genreid` int(11) NOT NULL default '0',
`title` varchar(100) NOT NULL default '',
`name` varchar(100) NOT NULL default '',
`info` text NOT NULL,
`display` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`storyid`)
) TYPE=MyISAM;[/sql]
|