· 8 years ago · Jun 16, 2018, 08:02 AM
1--
2-- Table structure for table `cp_blogs`
3--
4
5CREATE TABLE IF NOT EXISTS `cp_blogs` (
6 `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
7 `title` varchar(255) NOT NULL DEFAULT '',
8 `introtext` text NOT NULL,
9 `bodytext` text,
10 `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
11 `created_by` int(10) unsigned NOT NULL DEFAULT '0',
12 `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
13 `modified_by` varchar(30) NOT NULL DEFAULT '',
14 PRIMARY KEY (`id`)
15) ENGINE=MyISAM DEFAULT CHARSET=utf8;
16
17INSERT INTO `cp_blogs` (`id`, `title`, `introtext`, `bodytext`, `created`, `created_by`, `modified`, `modified_by`) VALUES (1, 'AdminMsg', '<h2>Blog Addon for Flux Control Panel</h2>\r\n<p>This is a front page message</p>\r\n<p style="text-align: right;"><strong><em><br /></em></strong></p>', '', '0000-00-00 00:00:00', 0, '0000-00-00 00:00:00', '');