#---------------------------------------------------------- # PHP-Fusion SQL Data Dump # Database Name: `cgeagles_invent2` # Table Prefix: `fusion_` # Date: `26/09/2006 14:10` #---------------------------------------------------------- # # Structure for Table `fusion_exchange` # DROP TABLE IF EXISTS `fusion_exchange`; CREATE TABLE `fusion_exchange` ( `exchange_id` int(11) unsigned NOT NULL auto_increment, `exchange_name` varchar(200) NOT NULL default '', `exchange_cat` int(11) NOT NULL default '0', `exchange_desc` text NOT NULL, `exchange_owner` int(11) NOT NULL default '0', `exchange_downloads` int(11) NOT NULL default '0', `exchange_views` int(11) NOT NULL default '0', `exchange_approved` tinyint(1) NOT NULL default '0', PRIMARY KEY (`exchange_id`) ) TYPE=MyISAM; # # Structure for Table `fusion_exchange_cats` # DROP TABLE IF EXISTS `fusion_exchange_cats`; CREATE TABLE `fusion_exchange_cats` ( `exchange_cat_id` int(11) unsigned NOT NULL auto_increment, `exchange_cat_name` varchar(200) NOT NULL default '', `exchange_cat_desc` text NOT NULL, `exchange_cat_sub` int(11) NOT NULL default '0', PRIMARY KEY (`exchange_cat_id`) ) TYPE=MyISAM;