Edit File by line

[0] Fix | Delete

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";

[1] Fix | Delete

SET time_zone = "+00:00";

[2] Fix | Delete

[3] Fix | Delete

[4] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

[5] Fix | Delete

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

[6] Fix | Delete

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

[7] Fix | Delete

/*!40101 SET NAMES utf8 */;

[8] Fix | Delete

[9] Fix | Delete

[10] Fix | Delete

-- Database: `pubvana104`

[11] Fix | Delete

[12] Fix | Delete

[13] Fix | Delete

-- --------------------------------------------------------

[14] Fix | Delete

[15] Fix | Delete

[16] Fix | Delete

-- Table structure for table `[[dbprefix]]categories`

[17] Fix | Delete

[18] Fix | Delete

[19] Fix | Delete

CREATE TABLE `[[dbprefix]]categories` (

[20] Fix | Delete

`id` int(11) NOT NULL,

[21] Fix | Delete

`name` varchar(60) DEFAULT NULL,

[22] Fix | Delete

`url_name` varchar(200) DEFAULT NULL,

[23] Fix | Delete

`description` varchar(200) DEFAULT NULL,

[24] Fix | Delete

PRIMARY KEY (`id`)

[25] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[26] Fix | Delete

[27] Fix | Delete

[28] Fix | Delete

-- Dumping data for table `[[dbprefix]]categories`

[29] Fix | Delete

[30] Fix | Delete

[31] Fix | Delete

INSERT INTO `[[dbprefix]]categories` VALUES

[32] Fix | Delete

(1, 'Uncategorized', 'uncategorized', 'Uncategorized');

[33] Fix | Delete

[34] Fix | Delete

-- --------------------------------------------------------

[35] Fix | Delete

[36] Fix | Delete

[37] Fix | Delete

-- Table structure for table `[[dbprefix]]comments`

[38] Fix | Delete

[39] Fix | Delete

[40] Fix | Delete

CREATE TABLE `[[dbprefix]]comments` (

[41] Fix | Delete

`id` int(11) NOT NULL,

[42] Fix | Delete

`post_id` int(11) DEFAULT '0',

[43] Fix | Delete

`user_id` int(11) DEFAULT NULL,

[44] Fix | Delete

`author` varchar(50) DEFAULT NULL,

[45] Fix | Delete

`author_email` varchar(100) DEFAULT NULL,

[46] Fix | Delete

`author_ip` varchar(100) NOT NULL,

[47] Fix | Delete

`content` text,

[48] Fix | Delete

`date` datetime DEFAULT CURRENT_TIMESTAMP,

[49] Fix | Delete

`modded` int(1) NOT NULL DEFAULT '1',

[50] Fix | Delete

PRIMARY KEY (`id`)

[51] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[52] Fix | Delete

[53] Fix | Delete

-- --------------------------------------------------------

[54] Fix | Delete

[55] Fix | Delete

[56] Fix | Delete

-- Table structure for table `[[dbprefix]]contacts`

[57] Fix | Delete

[58] Fix | Delete

[59] Fix | Delete

CREATE TABLE `[[dbprefix]]contacts` (

[60] Fix | Delete

`id` int(11) unsigned NOT NULL,

[61] Fix | Delete

`name` varchar(20) NOT NULL,

[62] Fix | Delete

`email` varchar(50) NOT NULL,

[63] Fix | Delete

`sender_ip` varchar(50) NOT NULL,

[64] Fix | Delete

`message` varchar(200) NOT NULL,

[65] Fix | Delete

`send_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,

[66] Fix | Delete

PRIMARY KEY (`id`)

[67] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[68] Fix | Delete

[69] Fix | Delete

-- --------------------------------------------------------

[70] Fix | Delete

[71] Fix | Delete

[72] Fix | Delete

-- Table structure for table `[[dbprefix]]groups`

[73] Fix | Delete

[74] Fix | Delete

[75] Fix | Delete

CREATE TABLE `[[dbprefix]]groups` (

[76] Fix | Delete

`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,

[77] Fix | Delete

`name` varchar(20) NOT NULL,

[78] Fix | Delete

`description` varchar(100) NOT NULL,

[79] Fix | Delete

`protected` int(1) NOT NULL DEFAULT '0',

[80] Fix | Delete

PRIMARY KEY (`id`)

[81] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

[82] Fix | Delete

[83] Fix | Delete

[84] Fix | Delete

-- Dumping data for table `[[dbprefix]]groups`

[85] Fix | Delete

[86] Fix | Delete

[87] Fix | Delete

INSERT INTO `[[dbprefix]]groups` VALUES

[88] Fix | Delete

(1, 'admin', 'Administrator', 1),

[89] Fix | Delete

(2, 'members', 'General User', 1),

[90] Fix | Delete

(3, 'contributors', 'Contributor', 1),

[91] Fix | Delete

(4, 'editors', 'Editor', 1);

[92] Fix | Delete

[93] Fix | Delete

-- --------------------------------------------------------

[94] Fix | Delete

[95] Fix | Delete

[96] Fix | Delete

-- Table structure for table `[[dbprefix]]groups_perms`

[97] Fix | Delete

[98] Fix | Delete

[99] Fix | Delete

CREATE TABLE `[[dbprefix]]groups_perms` (

[100] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[101] Fix | Delete

`perms_id` int(11) NOT NULL,

[102] Fix | Delete

`group_id` int(11) NOT NULL,

[103] Fix | Delete

PRIMARY KEY (`id`)

[104] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

[105] Fix | Delete

[106] Fix | Delete

-- --------------------------------------------------------

[107] Fix | Delete

[108] Fix | Delete

[109] Fix | Delete

-- Table structure for table `[[dbprefix]]group_permissions`

[110] Fix | Delete

[111] Fix | Delete

[112] Fix | Delete

CREATE TABLE `[[dbprefix]]group_permissions` (

[113] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[114] Fix | Delete

`name` varchar(50) NOT NULL,

[115] Fix | Delete

`description` varchar(150) NOT NULL,

[116] Fix | Delete

`protected` int(1) NOT NULL DEFAULT '0',

[117] Fix | Delete

`form_name` varchar(50) NOT NULL,

[118] Fix | Delete

`display_order` int(5) DEFAULT NULL,

[119] Fix | Delete

PRIMARY KEY (`id`)

[120] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;

[121] Fix | Delete

[122] Fix | Delete

[123] Fix | Delete

-- Dumping data for table `[[dbprefix]]group_permissions`

[124] Fix | Delete

[125] Fix | Delete

[126] Fix | Delete

INSERT INTO `[[dbprefix]]group_permissions` VALUES

[127] Fix | Delete

(1, 'users', 'Users', 1, '', 14),

[128] Fix | Delete

(2, 'posts', 'Posts', 1, '', 9),

[129] Fix | Delete

(3, 'pages', 'Pages', 1, '', 8),

[130] Fix | Delete

(4, 'links', 'Links', 1, '', 5),

[131] Fix | Delete

(5, 'social', 'Social', 1, '', 11),

[132] Fix | Delete

(6, 'comments', 'Comments', 1, '', 3),

[133] Fix | Delete

(7, 'navigation', 'Navigation', 1, '', 7),

[134] Fix | Delete

(8, 'themes', 'Themes', 1, '', 12),

[135] Fix | Delete

(9, 'settings', 'Settings', 1, '', 10),

[136] Fix | Delete

(10, 'updates', 'Updates', 1, '', 13),

[137] Fix | Delete

(11, 'dashboard', 'Dashboard', 1, '', 1),

[138] Fix | Delete

(12, 'cats', 'Categories', 1, '', 2),

[139] Fix | Delete

(13, 'lang', 'Language', 1, '', 4),

[140] Fix | Delete

(14, 'media', 'Media', 1, '', 6),

[141] Fix | Delete

(15, 'widgets', 'Widgets', 1, '', 15);

[142] Fix | Delete

[143] Fix | Delete

-- --------------------------------------------------------

[144] Fix | Delete

[145] Fix | Delete

[146] Fix | Delete

-- Table structure for table `[[dbprefix]]languages`

[147] Fix | Delete

[148] Fix | Delete

[149] Fix | Delete

CREATE TABLE `[[dbprefix]]languages` (

[150] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[151] Fix | Delete

`language` varchar(100) DEFAULT NULL,

[152] Fix | Delete

`abbreviation` varchar(7) DEFAULT NULL,

[153] Fix | Delete

`author` varchar(100) DEFAULT NULL,

[154] Fix | Delete

`author_website` varchar(255) NOT NULL,

[155] Fix | Delete

`is_default` enum('0','1') DEFAULT NULL,

[156] Fix | Delete

`is_avail` int(1) NOT NULL DEFAULT '0',

[157] Fix | Delete

PRIMARY KEY (`id`)

[158] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;

[159] Fix | Delete

[160] Fix | Delete

[161] Fix | Delete

-- Dumping data for table `[[dbprefix]]languages`

[162] Fix | Delete

[163] Fix | Delete

[164] Fix | Delete

INSERT INTO `[[dbprefix]]languages` VALUES

[165] Fix | Delete

(1, 'english', 'en', 'Enliven Applications', 'https://pubvana.com', '1', 1),

[166] Fix | Delete

(2, 'indonesian', 'id', 'Enliven Applications', 'https://pubvana.com', '0', 0),

[167] Fix | Delete

(3, 'arabic', 'ar', 'Enliven Applications', 'https://pubvana.com', '0', 0),

[168] Fix | Delete

(4, 'bulgarian', 'bg', 'Enliven Applications', 'https://pubvana.com', '0', 0),

[169] Fix | Delete

(5, 'czech', 'cs', 'Enliven Applications', 'https://pubvana.com', '0', 0),

[170] Fix | Delete

(6, 'french', 'fr', 'Enliven Applications', 'https://pubvana.com', '0', 1),

[171] Fix | Delete

(7, 'hungarian', 'hu', 'Enliven Applications', 'https://pubvana.com', '0', 0),

[172] Fix | Delete

(8, 'italian', 'it', 'Enliven Applications', 'https://pubvana.com', '0', 0),

[173] Fix | Delete

(9, 'latvian', 'lv', 'Enliven Applications', 'https://pubvana.com', '0', 0),

[174] Fix | Delete

(10, 'norwegian', 'no', 'Enliven Applications', 'https://pubvana.com', '0', 0),

[175] Fix | Delete

(11, 'polish', 'pl', 'Enliven Applications', 'https://pubvana.com', '0', 0),

[176] Fix | Delete

(12, 'portuguese', 'pt', 'Enliven Applications', 'https://pubvana.com', '0', 0),

[177] Fix | Delete

(13, 'simplified-chinese', 'zh-hans', 'Enliven Applications', 'https://pubvana.com', '0', 0),

[178] Fix | Delete

(14, 'slovak', 'sk', 'Enliven Applications', 'https://pubvana.com', '0', 0),

[179] Fix | Delete

(15, 'slovenian', 'sl', 'Enliven Applications', 'https://pubvana.com', '0', 0),

[180] Fix | Delete

(16, 'spanish', 'es', 'Enliven Applications', 'https://pubvana.com', '0', 0),

[181] Fix | Delete

(17, 'traditional-chinese', 'zh-hant', 'Enliven Applications', 'https://pubvana.com', '0', 0),

[182] Fix | Delete

(18, 'turkish', 'tr', 'Enliven Applications', 'https://pubvana.com', '0', 0),

[183] Fix | Delete

(19, 'ukranian', 'uk', 'Enliven Applications', 'https://pubvana.com', '0', 0);

[184] Fix | Delete

[185] Fix | Delete

-- --------------------------------------------------------

[186] Fix | Delete

[187] Fix | Delete

[188] Fix | Delete

-- Table structure for table `[[dbprefix]]links`

[189] Fix | Delete

[190] Fix | Delete

[191] Fix | Delete

CREATE TABLE `[[dbprefix]]links` (

[192] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[193] Fix | Delete

`name` varchar(255) DEFAULT NULL,

[194] Fix | Delete

`url` varchar(255) DEFAULT NULL,

[195] Fix | Delete

`target` varchar(20) DEFAULT '_blank',

[196] Fix | Delete

`description` varchar(100) DEFAULT NULL,

[197] Fix | Delete

`visible` enum('yes','no') DEFAULT 'yes',

[198] Fix | Delete

`position` int(3) NOT NULL,

[199] Fix | Delete

PRIMARY KEY (`id`)

[200] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

[201] Fix | Delete

[202] Fix | Delete

[203] Fix | Delete

-- Dumping data for table `[[dbprefix]]links`

[204] Fix | Delete

[205] Fix | Delete

[206] Fix | Delete

INSERT INTO `[[dbprefix]]links` VALUES

[207] Fix | Delete

(1, 'Pubvana', 'http://pubvana.org', '_blank', 'Pubvana', 'yes', 3),

[208] Fix | Delete

(2, 'Pubvana Hosting', 'http://pubvana.com', '_blank', 'Pubvana Hosting', 'yes', 2),

[209] Fix | Delete

(3, 'Enliven Applications', 'http://enlivenapp.com', '_blank', 'Enliven Applications', 'yes', 1);

[210] Fix | Delete

[211] Fix | Delete

-- --------------------------------------------------------

[212] Fix | Delete

[213] Fix | Delete

[214] Fix | Delete

-- Table structure for table `[[dbprefix]]login_attempts`

[215] Fix | Delete

[216] Fix | Delete

[217] Fix | Delete

CREATE TABLE `[[dbprefix]]login_attempts` (

[218] Fix | Delete

`id` int(11) unsigned NOT NULL AUTO_INCREMENT,

[219] Fix | Delete

`ip_address` varchar(45) NOT NULL,

[220] Fix | Delete

`login` varchar(100) NOT NULL,

[221] Fix | Delete

`time` int(11) unsigned DEFAULT NULL,

[222] Fix | Delete

PRIMARY KEY (`id`)

[223] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[224] Fix | Delete

[225] Fix | Delete

-- --------------------------------------------------------

[226] Fix | Delete

[227] Fix | Delete

[228] Fix | Delete

-- Table structure for table `[[dbprefix]]navigation`

[229] Fix | Delete

[230] Fix | Delete

[231] Fix | Delete

CREATE TABLE `[[dbprefix]]navigation` (

[232] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[233] Fix | Delete

`title` varchar(50) DEFAULT NULL,

[234] Fix | Delete

`description` varchar(100) DEFAULT NULL,

[235] Fix | Delete

`url` varchar(255) DEFAULT NULL,

[236] Fix | Delete

`external` enum('0','1') NOT NULL DEFAULT '0',

[237] Fix | Delete

`position` varchar(100) DEFAULT NULL,

[238] Fix | Delete

`parent_id` int(5) DEFAULT '0',

[239] Fix | Delete

PRIMARY KEY (`id`)

[240] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

[241] Fix | Delete

[242] Fix | Delete

[243] Fix | Delete

-- Dumping data for table `[[dbprefix]]navigation`

[244] Fix | Delete

[245] Fix | Delete

[246] Fix | Delete

INSERT INTO `[[dbprefix]]navigation` VALUES

[247] Fix | Delete

(1, 'Home', 'Home', '', '0', '0', 0),

[248] Fix | Delete

(2, 'Welcome (page)', 'Welcome Page', 'pages/', '0', '1', 0);

[249] Fix | Delete

[250] Fix | Delete

-- --------------------------------------------------------

[251] Fix | Delete

[252] Fix | Delete

[253] Fix | Delete

-- Table structure for table `[[dbprefix]]notifications`

[254] Fix | Delete

[255] Fix | Delete

[256] Fix | Delete

CREATE TABLE `[[dbprefix]]notifications` (

[257] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[258] Fix | Delete

`email_address` varchar(200) NOT NULL,

[259] Fix | Delete

`verify_code` varchar(200) NOT NULL,

[260] Fix | Delete

`verified` int(1) NOT NULL DEFAULT '0',

[261] Fix | Delete

PRIMARY KEY (`id`)

[262] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[263] Fix | Delete

[264] Fix | Delete

-- --------------------------------------------------------

[265] Fix | Delete

[266] Fix | Delete

[267] Fix | Delete

-- Table structure for table `[[dbprefix]]pages`

[268] Fix | Delete

[269] Fix | Delete

[270] Fix | Delete

CREATE TABLE `[[dbprefix]]pages` (

[271] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[272] Fix | Delete

`title` varchar(200) DEFAULT NULL,

[273] Fix | Delete

`url_title` varchar(200) DEFAULT NULL,

[274] Fix | Delete

`author` int(11) DEFAULT '0',

[275] Fix | Delete

`date` date NOT NULL,

[276] Fix | Delete

`content` text,

[277] Fix | Delete

`status` enum('active','inactive') DEFAULT 'active',

[278] Fix | Delete

`is_home` int(1) NOT NULL DEFAULT '0',

[279] Fix | Delete

`meta_title` varchar(200) NOT NULL,

[280] Fix | Delete

`meta_keywords` varchar(200) NOT NULL,

[281] Fix | Delete

`meta_description` varchar(200) NOT NULL,

[282] Fix | Delete

`date_modified` date DEFAULT NULL,

[283] Fix | Delete

PRIMARY KEY (`id`)

[284] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

[285] Fix | Delete

[286] Fix | Delete

[287] Fix | Delete

-- Dumping data for table `[[dbprefix]]pages`

[288] Fix | Delete

[289] Fix | Delete

[290] Fix | Delete

INSERT INTO `[[dbprefix]]pages` VALUES

[291] Fix | Delete

(1, 'Welcome to Pubvana', 'welcome-to-pubvana', 1, '2016-12-22', '### Welcome\r\n\r\nIf you can see this page, Pubvana was successfully installed.\r\n\r\nIf you need help, don''t hesitate and visit the Pubvana website.\r\n\r\n*Since this is just an example post, feel free to delete it.*', 'active', 1, 'Pubvana Home Page', 'Pubvana, Blog, CMS, Website, personal, small business', 'The Pubvana Homepage', NULL);

[292] Fix | Delete

[293] Fix | Delete

-- --------------------------------------------------------

[294] Fix | Delete

[295] Fix | Delete

[296] Fix | Delete

-- Table structure for table `[[dbprefix]]posts`

[297] Fix | Delete

[298] Fix | Delete

[299] Fix | Delete

CREATE TABLE `[[dbprefix]]posts` (

[300] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[301] Fix | Delete

`author` int(11) NOT NULL DEFAULT '0',

[302] Fix | Delete

`date_posted` date DEFAULT NULL,

[303] Fix | Delete

`title` varchar(200) NOT NULL,

[304] Fix | Delete

`url_title` varchar(200) NOT NULL,

[305] Fix | Delete

`excerpt` text NOT NULL,

[306] Fix | Delete

`content` longtext NOT NULL,

[307] Fix | Delete

`feature_image` varchar(255) DEFAULT NULL,

[308] Fix | Delete

`allow_comments` enum('0','1') NOT NULL DEFAULT '1',

[309] Fix | Delete

`sticky` enum('0','1') NOT NULL DEFAULT '0',

[310] Fix | Delete

`status` enum('draft','published') NOT NULL DEFAULT 'published',

[311] Fix | Delete

`meta_title` varchar(200) NOT NULL,

[312] Fix | Delete

`meta_keywords` varchar(200) NOT NULL,

[313] Fix | Delete

`meta_description` varchar(200) NOT NULL,

[314] Fix | Delete

`date_modified` date DEFAULT NULL,

[315] Fix | Delete

`post_count` int(20) DEFAULT '0',

[316] Fix | Delete

`featured` int(1) DEFAULT '0',

[317] Fix | Delete

PRIMARY KEY (`id`)

[318] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

[319] Fix | Delete

[320] Fix | Delete

[321] Fix | Delete

-- Dumping data for table `[[dbprefix]]posts`

[322] Fix | Delete

[323] Fix | Delete

[324] Fix | Delete

INSERT INTO `[[dbprefix]]posts` VALUES

[325] Fix | Delete

(1, 1, '2018-03-16', 'Welcome to Pubvana', 'welcome-to-pubvana', 'Congratulations! If you can see this page, Pubvana was successfully installed. If you need help, don''t hesitate and visit the Pubvana website.\r\n', '#### Congratulations!\r\n\r\nIf you can see this page, Pubvana was successfully installed.\r\n\r\nIf you need help, don''t hesitate and visit the Pubvana website.\r\n\r\n*Since this is just an example post, feel free to delete it.*', NULL, '1', '0', 'published', 'Pubvana Home Page', 'Pubvana, Blog, CMS, Website, personal, small business', 'The Pubvana Homepage', NULL, 0, 0);

[326] Fix | Delete

[327] Fix | Delete

-- --------------------------------------------------------

[328] Fix | Delete

[329] Fix | Delete

[330] Fix | Delete

-- Table structure for table `[[dbprefix]]posts_to_categories`

[331] Fix | Delete

[332] Fix | Delete

[333] Fix | Delete

CREATE TABLE `[[dbprefix]]posts_to_categories` (

[334] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[335] Fix | Delete

`post_id` int(11) NOT NULL,

[336] Fix | Delete

`category_id` int(11) NOT NULL,

[337] Fix | Delete

PRIMARY KEY (`id`)

[338] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

[339] Fix | Delete

[340] Fix | Delete

[341] Fix | Delete

-- Dumping data for table `[[dbprefix]]posts_to_categories`

[342] Fix | Delete

[343] Fix | Delete

[344] Fix | Delete

INSERT INTO `[[dbprefix]]posts_to_categories` VALUES

[345] Fix | Delete

(1, 1, 1);

[346] Fix | Delete

[347] Fix | Delete

-- --------------------------------------------------------

[348] Fix | Delete

[349] Fix | Delete

[350] Fix | Delete

-- Table structure for table `[[dbprefix]]redirects`

[351] Fix | Delete

[352] Fix | Delete

[353] Fix | Delete

CREATE TABLE `[[dbprefix]]redirects` (

[354] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[355] Fix | Delete

`old_slug` varchar(200) NOT NULL,

[356] Fix | Delete

`new_slug` varchar(200) NOT NULL,

[357] Fix | Delete

`type` varchar(4) NOT NULL DEFAULT 'post',

[358] Fix | Delete

`code` varchar(3) NOT NULL DEFAULT '301',

[359] Fix | Delete

PRIMARY KEY (`id`)

[360] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

[361] Fix | Delete

[362] Fix | Delete

-- --------------------------------------------------------

[363] Fix | Delete

[364] Fix | Delete

[365] Fix | Delete

-- Table structure for table `[[dbprefix]]settings`

[366] Fix | Delete

[367] Fix | Delete

[368] Fix | Delete

CREATE TABLE `[[dbprefix]]settings` (

[369] Fix | Delete

`name` varchar(255) NOT NULL,

[370] Fix | Delete

`value` varchar(255) NOT NULL,

[371] Fix | Delete

`tab` varchar(50) NOT NULL,

[372] Fix | Delete

`field_type` varchar(50) NOT NULL,

[373] Fix | Delete

`options` varchar(200) NOT NULL,

[374] Fix | Delete

`required` int(1) NOT NULL DEFAULT '1',

[375] Fix | Delete

`order_by` int(5) DEFAULT '0',

[376] Fix | Delete

PRIMARY KEY (`name`)

[377] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[378] Fix | Delete

[379] Fix | Delete

[380] Fix | Delete

-- Dumping data for table `[[dbprefix]]settings`

[381] Fix | Delete

[382] Fix | Delete

[383] Fix | Delete

INSERT INTO `[[dbprefix]]settings` VALUES

[384] Fix | Delete

('admin_email', '[[admin_email]]', 'email', 'text', '', 1, 0),

[385] Fix | Delete

('allow_comments', '1', 'comments', 'dropdown', '1=yes|0=no', 1, 1),

[386] Fix | Delete

('allow_registrations', 'true', 'users', 'dropdown', 'true=yes|false=no', 1, 0),

[387] Fix | Delete

('base_controller', 'blog', 'general', 'dropdown', 'blog=blog|pages=pages', 1, 0),

[388] Fix | Delete

('blog_description', '[[site_desc]]', 'general', 'text', '', 0, 0),

[389] Fix | Delete

('category_list_limit', '10', 'limits', 'dropdown', '10=10|20=20|30=30', 1, 0),

[390] Fix | Delete

('comment_system', 'local', 'comments', 'dropdown', 'local=Local|fb=Facebook', 1, 0),

[391] Fix | Delete

('email_activation', 'true', 'users', 'dropdown', 'true=yes|false=no', 1, 0),

[392] Fix | Delete

('facebook_id', '', 'comments', 'text', '', 0, 4),

[393] Fix | Delete

('gAnalyticsPropId', '', 'google', 'text', '', 0, 0),

[394] Fix | Delete

('links_per_box', '10', 'limits', 'dropdown', '10=10|20=20|30=30', 1, 0),

[395] Fix | Delete

('mail_protocol', 'mail', 'email', 'dropdown', 'mail=mail|smtp=smtp|sendmail=sendmail', 1, 0),

[396] Fix | Delete

('manual_activation', 'false', 'users', 'dropdown', 'true=yes|false=no', 1, 0),

[397] Fix | Delete

('mod_non_user_comments', '1', 'comments', 'dropdown', '1=yes|0=no', 1, 2),

[398] Fix | Delete

('mod_user_comments', '0', 'comments', 'dropdown', '1=yes|0=no', 1, 3),

[399] Fix | Delete

('months_per_archive', '10', 'limits', 'dropdown', '10=10|20=20|30=30', 1, 0),

[400] Fix | Delete

('posts_per_page', '10', 'limits', 'dropdown', '10=10|20=20|30=30', 1, 0),

[401] Fix | Delete

('recaptcha_private_key', '', 'google', 'text', '', 0, 0),

[402] Fix | Delete

('recaptcha_site_key', '', 'google', 'text', '', 0, 0),

[403] Fix | Delete

('sendmail_path', '/usr/sbin/sendmail', 'email', 'text', '', 0, 0),

[404] Fix | Delete

('server_email', '[[admin_email]]', 'email', 'text', '', 1, 0),

[405] Fix | Delete

('site_name', '[[site_name]]', 'general', 'text', '', 1, 0),

[406] Fix | Delete

('smtp_crypto', 'tls', 'email', 'dropdown', 'tls=TLS|ssl=SSL', 0, 0),

[407] Fix | Delete

('smtp_host', '', 'email', 'text', '', 0, 0),

[408] Fix | Delete

('smtp_pass', '', 'email', 'text', '', 0, 0),

[409] Fix | Delete

('smtp_port', '', 'email', 'text', '', 0, 0),

[410] Fix | Delete

('smtp_user', '', 'email', 'text', '', 0, 0),

[411] Fix | Delete

('use_honeypot', '0', 'captcha', 'dropdown', '1=yes|0=no', 1, 0),

[412] Fix | Delete

('use_recaptcha', '0', 'google', 'dropdown', '1=yes|0=no', 1, 0);

[413] Fix | Delete

[414] Fix | Delete

-- --------------------------------------------------------

[415] Fix | Delete

[416] Fix | Delete

[417] Fix | Delete

-- Table structure for table `[[dbprefix]]sidebar`

[418] Fix | Delete

[419] Fix | Delete

[420] Fix | Delete

CREATE TABLE `[[dbprefix]]sidebar` (

[421] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[422] Fix | Delete

`title` varchar(100) NOT NULL,

[423] Fix | Delete

`file` varchar(100) NOT NULL,

[424] Fix | Delete

`status` enum('enabled','disabled') NOT NULL,

[425] Fix | Delete

`position` varchar(100) DEFAULT NULL,

[426] Fix | Delete

PRIMARY KEY (`id`)

[427] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

[428] Fix | Delete

[429] Fix | Delete

[430] Fix | Delete

-- Dumping data for table `[[dbprefix]]sidebar`

[431] Fix | Delete

[432] Fix | Delete

[433] Fix | Delete

INSERT INTO `[[dbprefix]]sidebar` VALUES

[434] Fix | Delete

(1, 'Search', 'search', 'enabled', '1'),

[435] Fix | Delete

(2, 'Archive', 'archive', 'enabled', '2'),

[436] Fix | Delete

(3, 'Categories', 'categories', 'enabled', '3'),

[437] Fix | Delete

(4, 'Tag_cloud', 'tag_cloud', 'enabled', '4'),

[438] Fix | Delete

(5, 'Feeds', 'feeds', 'enabled', '5'),

[439] Fix | Delete

(6, 'Links', 'links', 'enabled', '6'),

[440] Fix | Delete

(7, 'Other', 'other', 'enabled', '7');

[441] Fix | Delete

[442] Fix | Delete

-- --------------------------------------------------------

[443] Fix | Delete

[444] Fix | Delete

[445] Fix | Delete

-- Table structure for table `[[dbprefix]]social`

[446] Fix | Delete

[447] Fix | Delete

[448] Fix | Delete

CREATE TABLE `[[dbprefix]]social` (

[449] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[450] Fix | Delete

`name` varchar(30) DEFAULT NULL,

[451] Fix | Delete

`url` varchar(100) DEFAULT NULL,

[452] Fix | Delete

`enabled` int(1) NOT NULL DEFAULT '0',

[453] Fix | Delete

PRIMARY KEY (`id`)

[454] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

[455] Fix | Delete

[456] Fix | Delete

[457] Fix | Delete

-- Dumping data for table `[[dbprefix]]social`

[458] Fix | Delete

[459] Fix | Delete

[460] Fix | Delete

INSERT INTO `[[dbprefix]]social` VALUES

[461] Fix | Delete

(1, 'Facebook', NULL, 0),

[462] Fix | Delete

(2, 'Twitter', NULL, 0);

[463] Fix | Delete

[464] Fix | Delete

-- --------------------------------------------------------

[465] Fix | Delete

[466] Fix | Delete

[467] Fix | Delete

-- Table structure for table `[[dbprefix]]templates`

[468] Fix | Delete

[469] Fix | Delete

[470] Fix | Delete

CREATE TABLE `[[dbprefix]]templates` (

[471] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[472] Fix | Delete

`name` varchar(100) DEFAULT NULL,

[473] Fix | Delete

`description` varchar(200) NOT NULL,

[474] Fix | Delete

`author` varchar(100) DEFAULT NULL,

[475] Fix | Delete

`author_email` varchar(100) NOT NULL,

[476] Fix | Delete

`path` varchar(100) DEFAULT NULL,

[477] Fix | Delete

`image` varchar(100) DEFAULT NULL,

[478] Fix | Delete

`is_default` enum('0','1') DEFAULT '1',

[479] Fix | Delete

`is_active` varchar(1) NOT NULL DEFAULT '0',

[480] Fix | Delete

`is_admin` varchar(1) NOT NULL DEFAULT '0',

[481] Fix | Delete

`version` varchar(10) NOT NULL DEFAULT '1.0.0',

[482] Fix | Delete

`has_options` int(1) DEFAULT '0',

[483] Fix | Delete

PRIMARY KEY (`id`)

[484] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

[485] Fix | Delete

[486] Fix | Delete

[487] Fix | Delete

-- Dumping data for table `[[dbprefix]]templates`

[488] Fix | Delete

[489] Fix | Delete

[490] Fix | Delete

INSERT INTO `[[dbprefix]]templates` VALUES

[491] Fix | Delete

(1, 'Default', 'The default theme for Pubvana', 'Enliven Applications', 'info@pubvana.org', 'default', 'default.png', '1', '1', '0', '1.0.0', 1),

[492] Fix | Delete

(2, 'Default Admin', 'The default Admin theme for Pubvana', 'Enliven Applications', 'info@pubvana.org', 'default_admin', 'default_admin.png', '1', '1', '1', '1.0.0', 0);

[493] Fix | Delete

[494] Fix | Delete

-- --------------------------------------------------------

[495] Fix | Delete

[496] Fix | Delete

[497] Fix | Delete

-- Table structure for table `[[dbprefix]]theme_options`

[498] Fix | Delete

[499] Fix | Delete