Sorry for late reply. Can you try uploading this to database, probably installer didn’t worked for you.
================
—
—Table structure for table `cf_banners`
—
CREATE TABLE `cf_banners` (
`banners_id` int(11) NOT NULL AUTO_INCREMENT,
`banners_title` varchar(64) NOT NULL DEFAULT ‘’,
`banners_url` varchar(255) NOT NULL DEFAULT ‘’,
`banners_image` varchar(64) NOT NULL DEFAULT ‘’,
`banners_group` varchar(255) NOT NULL DEFAULT ‘’,
`banners_html_text` text,
`expires_impressions` int(7) DEFAULT ‘0’,
`expires_clicks` int(7) DEFAULT ‘0’,
`expires_date` datetime DEFAULT NULL,
`date_scheduled` datetime DEFAULT NULL,
`date_added` datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
`date_status_change` datetime DEFAULT NULL,
`status` int(1) NOT NULL DEFAULT ‘1’,
PRIMARY KEY (`banners_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
—
—Dumping data for table `cf_banners`
—
—————————————————————————————
—
—Table structure for table `cf_banners_history`
—
CREATE TABLE `cf_banners_history` (
`banners_history_id` int(11) NOT NULL AUTO_INCREMENT,
`banners_id` int(11) NOT NULL DEFAULT ‘0’,
`banners_shown` int(5) NOT NULL DEFAULT ‘0’,
`banners_clicked` int(5) NOT NULL DEFAULT ‘0’,
`banners_history_date` datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
PRIMARY KEY (`banners_history_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
—
—Dumping data for table `cf_banners_history`
—
—————————————————————————————
—
—Table structure for table `cf_forms_groups`
—
CREATE TABLE `cf_forms_groups` (
`form_groups_id` int(11) NOT NULL AUTO_INCREMENT,
`form_groups_name` varchar(25) DEFAULT NULL,
`form_groups_identifier` varchar(35) DEFAULT NULL,
`form_groups_send_to` text,
PRIMARY KEY (`form_groups_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
—
—Dumping data for table `cf_forms_groups`
—
—————————————————————————————
—
—Table structure for table `cf_forms_items`
—
CREATE TABLE `cf_forms_items` (
`form_item_id` int(11) NOT NULL AUTO_INCREMENT,
`form_item_name` varchar(50) NOT NULL,
`form_item_label` varchar(50) NOT NULL,
`form_item_input_type` varchar(15) NOT NULL,
`form_item_validations` varchar(200) NOT NULL,
`form_item_default_value` varchar(200) NOT NULL,
`form_item_parameters` varchar(200) NOT NULL,
PRIMARY KEY (`form_item_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
—
—Dumping data for table `cf_forms_items`
—
—————————————————————————————
—
—Table structure for table `cf_forms_items_to_groups`
—
CREATE TABLE `cf_forms_items_to_groups` (
`form_groups_id` int(11) NOT NULL,
`form_item_id` int(11) NOT NULL,
`form_item_sort` int(11) NOT NULL,
KEY `form_groups_id` (`form_groups_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
—
—Dumping data for table `cf_forms_items_to_groups`
—
—————————————————————————————
—
—Table structure for table `cf_groups`
—
CREATE TABLE `cf_groups` (
`groups_id` int(11) NOT NULL AUTO_INCREMENT,
`groups_title` varchar(255) NOT NULL,
`groups_description` text NOT NULL,
`groups_sort` int(11) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (`groups_id`),
UNIQUE KEY `groups_title` (`groups_title`),
KEY `groups_sort` (`groups_sort`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
—
—Dumping data for table `cf_groups`
—
INSERT INTO `cf_groups` (`groups_id`, `groups_title`, `groups_description`, `groups_sort`) VALUES
(1, ‘Administrator’, ‘Users who have admin access rights go to this group.’, 0),
(2, ‘Public’, ‘General users go to this group.’, 1),
(3, ‘Registered User’, ‘Registered User Group.’, 2);
—————————————————————————————
—
—Table structure for table `cf_menus`
—
CREATE TABLE `cf_menus` (
`menus_id` int(11) NOT NULL AUTO_INCREMENT,
`menus_active` int(1) NOT NULL DEFAULT ‘0’,
`menus_parent_id` int(11) DEFAULT ‘0’,
`menus_link` varchar(255) DEFAULT NULL,
`menus_title` varchar(255) NOT NULL,
`menus_type` varchar(255) NOT NULL DEFAULT ‘pages’,
`menus_meta_title` varchar(70) DEFAULT NULL,
`menus_meta_keywords` varchar(200) DEFAULT NULL,
`menus_meta_description` varchar(150) DEFAULT NULL,
`menus_sort` int(11) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (`menus_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=66 ;
—
—Dumping data for table `cf_menus`
—
INSERT INTO `cf_menus` (`menus_id`, `menus_active`, `menus_parent_id`, `menus_link`, `menus_title`, `menus_type`, `menus_meta_title`, `menus_meta_keywords`, `menus_meta_description`, `menus_sort`) VALUES
(1, 1, 0, ‘http://www.codefight.org/’, ‘Home’, ‘pages’, NULL, NULL, NULL, 0),
(24, 1, 0, ‘codeigniter’, ‘Codeigniter’, ‘blog-categories’, NULL, NULL, NULL, 4),
(18, 1, 0, ‘http://www.codefight.org/page/18/35/contact-us.html’, ‘Contact Us’, ‘pages’, NULL, NULL, NULL, 10),
(40, 1, 0, ‘http://twitter.com/codefight’, ‘Twitter’, ‘favourite-links’, NULL, NULL, NULL, 2),
(41, 1, 0, ‘http://www.linkedin.com/in/codefight’, ‘Linked In’, ‘favourite-links’, NULL, NULL, NULL, 3),
(43, 1, 0, ‘http://www.tenthweb.com/forums/viewforum.php?f=49’, ‘Forum’, ‘pages’, NULL, NULL, NULL, 1),
(65, 1, 0, ‘codefight’, ‘Codefight’, ‘blog-categories’, NULL, NULL, NULL, 0);
—————————————————————————————
—
—Table structure for table `cf_ontheweb`
—
CREATE TABLE `cf_ontheweb` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) DEFAULT NULL,
`meta_title` varchar(255) DEFAULT NULL,
`meta_keywords` text,
`meta_description` text,
`link` varchar(255) DEFAULT NULL,
`link_external` varchar(255) DEFAULT NULL,
`content` text,
`views` int(11) NOT NULL DEFAULT ‘0’,
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`is_adult` varchar(1) NOT NULL DEFAULT ‘0’,
`is_locked` varchar(1) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (`id`),
KEY `timestamp` (`timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5653 ;
—
—Dumping data for table `cf_ontheweb`
—
—————————————————————————————
—
—Table structure for table `cf_pages`
—
CREATE TABLE `cf_pages` (
`pages_id` int(11) NOT NULL AUTO_INCREMENT,
`pages_active` int(11) NOT NULL,
`pages_title` varchar(255) DEFAULT NULL,
`pages_blurb` text,
`pages_blurb_length` int(11) NOT NULL,
`pages_body` text,
`menu_id` varchar(255) NOT NULL DEFAULT ‘0’,
`pages_author` varchar(255) NOT NULL,
`show_author` int(1) NOT NULL DEFAULT ‘0’,
`pages_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`pages_date_modified` datetime DEFAULT NULL,
`show_date` int(1) NOT NULL DEFAULT ‘0’,
`pages_tags` varchar(255) NOT NULL,
`allow_comments` int(1) NOT NULL DEFAULT ‘0’,
`pages_type` varchar(255) NOT NULL DEFAULT ‘pages’,
`pages_view` int(11) DEFAULT ‘0’,
`pages_meta_title` varchar(70) DEFAULT NULL,
`pages_meta_keywords` varchar(200) DEFAULT NULL,
`pages_meta_description` varchar(150) DEFAULT NULL,
`pages_sort` int(11) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (`pages_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=50 ;
—
—Dumping data for table `cf_pages`
—
INSERT INTO `cf_pages` (`pages_id`, `pages_active`, `pages_title`, `pages_blurb`, `pages_blurb_length`, `pages_body`, `menu_id`, `pages_author`, `show_author`, `pages_date`, `pages_date_modified`, `show_date`, `pages_tags`, `allow_comments`, `pages_type`, `pages_view`, `pages_meta_title`, `pages_meta_keywords`, `pages_meta_description`, `pages_sort`) VALUES
(49, 1, ‘Installation successful.’, ‘This post means you installed successfully.’, 0, ‘This post means you installed successfully.’, ‘,65,’, ‘Damodar Bashyal’, 1, ‘2009-11-21 23:33:26’, NULL, 1, ‘codefight, codefight cms, codeigniter, codeigniter cms’, 1, ‘blog’, 0, ‘Installation successful. - codefight’, ‘codefight, codefight cms, codeigniter, codeigniter cms’, ‘codefight, codefight cms, codeigniter, codeigniter cms’, 0);
—————————————————————————————
—
—Table structure for table `cf_pages_access`
—
CREATE TABLE `cf_pages_access` (
`pages_id` int(11) NOT NULL,
`groups_id` varchar(255) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (`pages_id`,`groups_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
—
—Dumping data for table `cf_pages_access`
—
INSERT INTO `cf_pages_access` (`pages_id`, `groups_id`) VALUES
(49, ‘1_2’);
—————————————————————————————
—
—Table structure for table `cf_pages_comments`
—
CREATE TABLE `cf_pages_comments` (
`pages_comments_id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`email` varchar(255) NOT NULL,
`comment` text NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`url` varchar(255) NOT NULL,
`pages_id` int(11) NOT NULL,
`pages_url` varchar(300) DEFAULT NULL,
`pages_comments_status` int(1) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (`pages_comments_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=39 ;
—
—Dumping data for table `cf_pages_comments`
—
—————————————————————————————
—
—Table structure for table `cf_pages_tags`
—
CREATE TABLE `cf_pages_tags` (
`pages_id` int(11) NOT NULL,
`tags` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
—
—Dumping data for table `cf_pages_tags`
—
INSERT INTO `cf_pages_tags` (`pages_id`, `tags`) VALUES
(49, ‘codefight’),
(49, ‘codefight-cms’),
(49, ‘codeigniter’),
(49, ‘codeigniter-cms’);
—————————————————————————————
—
—Table structure for table `cf_sessions`
—
CREATE TABLE `cf_sessions` (
`session_id` varchar(40) NOT NULL DEFAULT ‘0’,
`ip_address` varchar(16) NOT NULL DEFAULT ‘0’,
`user_agent` varchar(50) NOT NULL,
`last_activity` int(10) unsigned NOT NULL DEFAULT ‘0’,
`user_data` text NOT NULL,
PRIMARY KEY (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
—————————————————————————————
—
—Table structure for table `cf_settings`
—
CREATE TABLE `cf_settings` (
`settings_id` int(11) NOT NULL AUTO_INCREMENT,
`settings_key` varchar(50) NOT NULL,
`settings_value` varchar(300) NOT NULL,
`settings_info` varchar(100) NOT NULL,
`settings_form` varchar(25) NOT NULL,
`settings_options` varchar(250) NOT NULL,
PRIMARY KEY (`settings_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;
—
—Dumping data for table `cf_settings`
—
INSERT INTO `cf_settings` (`settings_id`, `settings_key`, `settings_value`, `settings_info`, `settings_form`, `settings_options`) VALUES
(1, ‘site_enabled’, ‘1’, ‘Site Enabled’, ‘radio’, ‘1=YES|0=NO’),
(2, ‘site_comments’, ‘0’, ‘Registration required to post comments’, ‘radio’, ‘1=YES|0=NO’),
(3, ‘meta_title’, ‘codefight.org’, ‘Default Meta Title’, ‘textbox’, ‘codefight.org’),
(4, ‘meta_keyword’, ‘codefight, code fight, content, management, system, free, php, download’, ‘Default Meta Keywords’, ‘textbox’, ‘codefight, code fight, content, management, system, free, php, download’),
(5, ‘meta_description’, ‘download free content management system built with codeigniter free php framework.’, ‘Default Meta Description’, ‘textarea’, ‘download free content management system built with codeigniter free php framework.’),
(6, ‘default_template’, ‘3columns’, ‘Default Template’, ‘select’, ‘’),
(7, ‘email_sender’, ‘noreply@codefight.org’, ‘From Email Address’, ‘textbox’, ‘noreply@codefight.org’),
(8, ‘site_name’, ‘CodeFight’, ‘Website Name’, ‘textbox’, ‘CodeFight’),
(9, ‘combine_css’, ‘1’, ‘Combine CSS Files’, ‘radio’, ‘1=YES|0=NO’),
(10, ‘minify_css’, ‘1’, ‘Minify CSS’, ‘radio’, ‘1=YES|0=NO’),
(11, ‘minify_html’, ‘1’, ‘Minify html source code’, ‘radio’, ‘1=YES|0=NO’),
(12, ‘pagination_page_links’, ‘2’, ‘Display Total Pagination Page Links’, ‘textbox’, ‘2’),
(13, ‘pagination_per_page’, ‘3’, ‘Display Total Articles Per Page’, ‘textbox’, ‘5’);
—————————————————————————————
—
—Table structure for table `cf_tags_cloud`
—
CREATE TABLE `cf_tags_cloud` (
`tag` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`count` int(11) NOT NULL DEFAULT ‘1’,
`type` varchar(15) NOT NULL DEFAULT ‘page’,
KEY `count` (`count`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
—
—Dumping data for table `cf_tags_cloud`
—
INSERT INTO `cf_tags_cloud` (`tag`, `title`, `count`, `type`) VALUES
(‘codefight’, ‘codefight’, 1, ‘page’),
(‘codefight-cms’, ’ codefight cms’, 1, ‘page’),
(‘codeigniter’, ’ codeigniter’, 1, ‘page’),
(‘codeigniter-cms’, ’ codeigniter cms’, 1, ‘page’);
—————————————————————————————
—
—Table structure for table `cf_users`
—
CREATE TABLE `cf_users` (
`users_id` int(11) NOT NULL AUTO_INCREMENT,
`active` char(1) NOT NULL DEFAULT ‘’,
`email` varchar(255) NOT NULL DEFAULT ‘’,
`password` varchar(34) NOT NULL DEFAULT ‘’,
`firstname` varchar(100) NOT NULL DEFAULT ‘’,
`lastname` varchar(100) NOT NULL DEFAULT ‘’,
`groups_id` int(11) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (`users_id`),
UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
—
—Dumping data for table `cf_users`
—
INSERT INTO `cf_users` (`users_id`, `active`, `email`, `password`, `firstname`, `lastname`, `groups_id`) VALUES
(11, ‘1’, ‘test@test.com’, ‘098f6bcd4621d373cade4e832627b4f6’, ‘test’, ‘test’, 1);
Author dbashyal has posted total 30 posts.
Date: 28-04-2010 05:14:41am