a8qzV5tL

1-- Table structure for table `ibf_ccs_custom_database_1`
2--
3
4CREATE TABLE IF NOT EXISTS `ibf_ccs_custom_database_1` (
5  `primary_id_field` int(11) NOT NULL auto_increment,
6  `member_id` int(11) NOT NULL default '0',
7  `record_saved` varchar(13) collate latin1_general_ci NOT NULL default '0',
8  `record_updated` varchar(13) collate latin1_general_ci NOT NULL default '0',
9  `post_key` varchar(32) collate latin1_general_ci NOT NULL default '0',
10  `rating_real` smallint(6) NOT NULL default '0',
11  `rating_hits` mediumint(9) NOT NULL default '0',
12  `rating_value` mediumint(9) NOT NULL default '0',
13  `category_id` int(11) NOT NULL default '0',
14  `record_locked` tinyint(1) NOT NULL default '0',
15  `record_comments` mediumint(9) NOT NULL default '0',
16  `record_views` mediumint(9) NOT NULL default '0',
17  `record_approved` tinyint(1) NOT NULL default '0',
18  `record_pinned` tinyint(1) NOT NULL default '0',
19  `record_dynamic_furl` varchar(255) collate latin1_general_ci default NULL,
20  `record_static_furl` varchar(255) collate latin1_general_ci default NULL,
21  `record_meta_keywords` text collate latin1_general_ci,
22  `record_meta_description` text collate latin1_general_ci,
23  `record_template` int(11) NOT NULL default '0',
24  `record_topicid` int(11) NOT NULL default '0',
25  `field_1` text collate latin1_general_ci,
26  `field_2` text collate latin1_general_ci,
27  `field_3` text collate latin1_general_ci,
28  `field_4` text collate latin1_general_ci,
29  `field_5` text collate latin1_general_ci,
30  `field_6` text collate latin1_general_ci,
31  `field_7` text collate latin1_general_ci,
32  `field_8` text collate latin1_general_ci,
33  PRIMARY KEY  (`primary_id_field`),
34  KEY `record_approved` (`record_approved`),
35  KEY `record_static_furl` (`record_static_furl`),
36  KEY `record_topicid` (`record_topicid`),
37  KEY `category_id` (`category_id`)
38) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=47 ;