Samples for Scripts Database
Table Structure:
CREATE TABLE `scripts` ( `id` int(6) NOT NULL auto_increment, `userid` varchar(15) NOT NULL default '', `category` varchar(20) NOT NULL default '', `categoryid` tinyint(2) NOT NULL default '0', `subcategory` varchar(25) NOT NULL default '', `title` varchar(60) NOT NULL default '', `summary` varchar(255) NOT NULL default '', `description` text NOT NULL, `platform` varchar(30) NOT NULL default '', `filesize` varchar(10) NOT NULL default '', `price` varchar(25) NOT NULL default '0', `version` varchar(5) NOT NULL default '', `dateadded` varchar(16) NOT NULL default '', `lastupdate` varchar(16) NOT NULL default '', `author` varchar(20) NOT NULL default '', `hits` int(5) NOT NULL default '0', `rating` int(4) NOT NULL default '0', `excellent` int(4) NOT NULL default '0', `verygood` int(4) NOT NULL default '0', `good` int(4) NOT NULL default '0', `fair` int(4) NOT NULL default '0', `poor` int(4) NOT NULL default '0', `review` text NOT NULL, `homepage` varchar(255) NOT NULL default '', `download` varchar(255) NOT NULL default '', `downloadhits` int(6) NOT NULL default '0', `visible` tinyint(4) NOT NULL default '0', `featured` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`), FULLTEXT KEY `title` (`title`,`description`) ) TYPE=MyISAM AUTO_INCREMENT=20652 ;
Samples:
CREATE TABLE `scripts` ( `id` int(6) NOT NULL auto_increment, `userid` varchar(15) NOT NULL default '', `category` varchar(20) NOT NULL default '', `categoryid` tinyint(2) NOT NULL default '0', `subcategory` varchar(25) NOT NULL default '', `title` varchar(60) NOT NULL default '', `summary` varchar(255) NOT NULL default '', `description` text NOT NULL, `platform` varchar(30) NOT NULL default '', `filesize` varchar(10) NOT NULL default '', `price` varchar(25) NOT NULL default '0', `version` varchar(5) NOT NULL default '', `dateadded` varchar(16) NOT NULL default '', `lastupdate` varchar(16) NOT NULL default '', `author` varchar(20) NOT NULL default '', `hits` int(5) NOT NULL default '0', `rating` int(4) NOT NULL default '0', `excellent` int(4) NOT NULL default '0', `verygood` int(4) NOT NULL default '0', `good` int(4) NOT NULL default '0', `fair` int(4) NOT NULL default '0', `poor` int(4) NOT NULL default '0', `review` text NOT NULL, `homepage` varchar(255) NOT NULL default '', `download` varchar(255) NOT NULL default '', `downloadhits` int(6) NOT NULL default '0', `visible` tinyint(4) NOT NULL default '0', `featured` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`), FULLTEXT KEY `title` (`title`,`description`) ) TYPE=MyISAM AUTO_INCREMENT=20652 ;
Samples:



