관리-도구

편집 파일: openb.sql

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `pubvana104`
--

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

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

CREATE TABLE `[[dbprefix]]categories` (
  `id` int(11) NOT NULL,
  `name` varchar(60) DEFAULT NULL,
  `url_name` varchar(200) DEFAULT NULL,
  `description` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `[[dbprefix]]categories` VALUES
(1, 'Uncategorized', 'uncategorized', 'Uncategorized');

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

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

CREATE TABLE `[[dbprefix]]comments` (
  `id` int(11) NOT NULL,
  `post_id` int(11) DEFAULT '0',
  `user_id` int(11) DEFAULT NULL,
  `author` varchar(50) DEFAULT NULL,
  `author_email` varchar(100) DEFAULT NULL,
  `author_ip` varchar(100) NOT NULL,
  `content` text,
  `date` datetime DEFAULT CURRENT_TIMESTAMP,
  `modded` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

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

CREATE TABLE `[[dbprefix]]contacts` (
  `id` int(11) unsigned NOT NULL,
  `name` varchar(20) NOT NULL,
  `email` varchar(50) NOT NULL,
  `sender_ip` varchar(50) NOT NULL,
  `message` varchar(200) NOT NULL,
  `send_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

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

CREATE TABLE `[[dbprefix]]groups` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `description` varchar(100) NOT NULL,
  `protected` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

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

INSERT INTO `[[dbprefix]]groups` VALUES
(1, 'admin', 'Administrator', 1),
(2, 'members', 'General User', 1),
(3, 'contributors', 'Contributor', 1),
(4, 'editors', 'Editor', 1);

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

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

CREATE TABLE `[[dbprefix]]groups_perms` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `perms_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

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

CREATE TABLE `[[dbprefix]]group_permissions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` varchar(150) NOT NULL,
  `protected` int(1) NOT NULL DEFAULT '0',
  `form_name` varchar(50) NOT NULL,
  `display_order` int(5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;

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

INSERT INTO `[[dbprefix]]group_permissions` VALUES
(1, 'users', 'Users', 1, '', 14),
(2, 'posts', 'Posts', 1, '', 9),
(3, 'pages', 'Pages', 1, '', 8),
(4, 'links', 'Links', 1, '', 5),
(5, 'social', 'Social', 1, '', 11),
(6, 'comments', 'Comments', 1, '', 3),
(7, 'navigation', 'Navigation', 1, '', 7),
(8, 'themes', 'Themes', 1, '', 12),
(9, 'settings', 'Settings', 1, '', 10),
(10, 'updates', 'Updates', 1, '', 13),
(11, 'dashboard', 'Dashboard', 1, '', 1),
(12, 'cats', 'Categories', 1, '', 2),
(13, 'lang', 'Language', 1, '', 4),
(14, 'media', 'Media', 1, '', 6),
(15, 'widgets', 'Widgets', 1, '', 15);

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

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

CREATE TABLE `[[dbprefix]]languages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `language` varchar(100) DEFAULT NULL,
  `abbreviation` varchar(7) DEFAULT NULL,
  `author` varchar(100) DEFAULT NULL,
  `author_website` varchar(255) NOT NULL,
  `is_default` enum('0','1') DEFAULT NULL,
  `is_avail` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=20 ;

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

INSERT INTO `[[dbprefix]]languages` VALUES
(1, 'english', 'en', 'Enliven Applications', 'https://pubvana.com', '1', 1),
(2, 'indonesian', 'id', 'Enliven Applications', 'https://pubvana.com', '0', 0),
(3, 'arabic', 'ar', 'Enliven Applications', 'https://pubvana.com', '0', 0),
(4, 'bulgarian', 'bg', 'Enliven Applications', 'https://pubvana.com', '0', 0),
(5, 'czech', 'cs', 'Enliven Applications', 'https://pubvana.com', '0', 0),
(6, 'french', 'fr', 'Enliven Applications', 'https://pubvana.com', '0', 1),
(7, 'hungarian', 'hu', 'Enliven Applications', 'https://pubvana.com', '0', 0),
(8, 'italian', 'it', 'Enliven Applications', 'https://pubvana.com', '0', 0),
(9, 'latvian', 'lv', 'Enliven Applications', 'https://pubvana.com', '0', 0),
(10, 'norwegian', 'no', 'Enliven Applications', 'https://pubvana.com', '0', 0),
(11, 'polish', 'pl', 'Enliven Applications', 'https://pubvana.com', '0', 0),
(12, 'portuguese', 'pt', 'Enliven Applications', 'https://pubvana.com', '0', 0),
(13, 'simplified-chinese', 'zh-hans', 'Enliven Applications', 'https://pubvana.com', '0', 0),
(14, 'slovak', 'sk', 'Enliven Applications', 'https://pubvana.com', '0', 0),
(15, 'slovenian', 'sl', 'Enliven Applications', 'https://pubvana.com', '0', 0),
(16, 'spanish', 'es', 'Enliven Applications', 'https://pubvana.com', '0', 0),
(17, 'traditional-chinese', 'zh-hant', 'Enliven Applications', 'https://pubvana.com', '0', 0),
(18, 'turkish', 'tr', 'Enliven Applications', 'https://pubvana.com', '0', 0),
(19, 'ukranian', 'uk', 'Enliven Applications', 'https://pubvana.com', '0', 0);

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

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

CREATE TABLE `[[dbprefix]]links` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `target` varchar(20) DEFAULT '_blank',
  `description` varchar(100) DEFAULT NULL,
  `visible` enum('yes','no') DEFAULT 'yes',
  `position` int(3) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

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

INSERT INTO `[[dbprefix]]links` VALUES
(1, 'Pubvana', 'http://pubvana.org', '_blank', 'Pubvana', 'yes', 3),
(2, 'Pubvana Hosting', 'http://pubvana.com', '_blank', 'Pubvana Hosting', 'yes', 2),
(3, 'Enliven Applications', 'http://enlivenapp.com', '_blank', 'Enliven Applications', 'yes', 1);

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

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

CREATE TABLE `[[dbprefix]]login_attempts` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ip_address` varchar(45) NOT NULL,
  `login` varchar(100) NOT NULL,
  `time` int(11) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE `[[dbprefix]]navigation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(50) DEFAULT NULL,
  `description` varchar(100) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `external` enum('0','1') NOT NULL DEFAULT '0',
  `position` varchar(100) DEFAULT NULL,
  `parent_id` int(5) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

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

INSERT INTO `[[dbprefix]]navigation` VALUES
(1, 'Home', 'Home', '', '0', '0', 0),
(2, 'Welcome (page)', 'Welcome Page', 'pages/', '0', '1', 0);

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

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

CREATE TABLE `[[dbprefix]]notifications` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email_address` varchar(200) NOT NULL,
  `verify_code` varchar(200) NOT NULL,
  `verified` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE `[[dbprefix]]pages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(200) DEFAULT NULL,
  `url_title` varchar(200) DEFAULT NULL,
  `author` int(11) DEFAULT '0',
  `date` date NOT NULL,
  `content` text,
  `status` enum('active','inactive') DEFAULT 'active',
  `is_home` int(1) NOT NULL DEFAULT '0',
  `meta_title` varchar(200) NOT NULL,
  `meta_keywords` varchar(200) NOT NULL,
  `meta_description` varchar(200) NOT NULL,
  `date_modified` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

INSERT INTO `[[dbprefix]]pages` VALUES
(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);

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

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

CREATE TABLE `[[dbprefix]]posts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `author` int(11) NOT NULL DEFAULT '0',
  `date_posted` date DEFAULT NULL,
  `title` varchar(200) NOT NULL,
  `url_title` varchar(200) NOT NULL,
  `excerpt` text NOT NULL,
  `content` longtext NOT NULL,
  `feature_image` varchar(255) DEFAULT NULL,
  `allow_comments` enum('0','1') NOT NULL DEFAULT '1',
  `sticky` enum('0','1') NOT NULL DEFAULT '0',
  `status` enum('draft','published') NOT NULL DEFAULT 'published',
  `meta_title` varchar(200) NOT NULL,
  `meta_keywords` varchar(200) NOT NULL,
  `meta_description` varchar(200) NOT NULL,
  `date_modified` date DEFAULT NULL,
  `post_count` int(20) DEFAULT '0',
  `featured` int(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

INSERT INTO `[[dbprefix]]posts` VALUES
(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);

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

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

CREATE TABLE `[[dbprefix]]posts_to_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `post_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

INSERT INTO `[[dbprefix]]posts_to_categories` VALUES
(1, 1, 1);

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

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

CREATE TABLE `[[dbprefix]]redirects` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `old_slug` varchar(200) NOT NULL,
  `new_slug` varchar(200) NOT NULL,
  `type` varchar(4) NOT NULL DEFAULT 'post',
  `code` varchar(3) NOT NULL DEFAULT '301',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

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

CREATE TABLE `[[dbprefix]]settings` (
  `name` varchar(255) NOT NULL,
  `value` varchar(255) NOT NULL,
  `tab` varchar(50) NOT NULL,
  `field_type` varchar(50) NOT NULL,
  `options` varchar(200) NOT NULL,
  `required` int(1) NOT NULL DEFAULT '1',
  `order_by` int(5) DEFAULT '0',
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `[[dbprefix]]settings` VALUES
('admin_email', '[[admin_email]]', 'email', 'text', '', 1, 0),
('allow_comments', '1', 'comments', 'dropdown', '1=yes|0=no', 1, 1),
('allow_registrations', 'true', 'users', 'dropdown', 'true=yes|false=no', 1, 0),
('base_controller', 'blog', 'general', 'dropdown', 'blog=blog|pages=pages', 1, 0),
('blog_description', '[[site_desc]]', 'general', 'text', '', 0, 0),
('category_list_limit', '10', 'limits', 'dropdown', '10=10|20=20|30=30', 1, 0),
('comment_system', 'local', 'comments', 'dropdown', 'local=Local|fb=Facebook', 1, 0),
('email_activation', 'true', 'users', 'dropdown', 'true=yes|false=no', 1, 0),
('facebook_id', '', 'comments', 'text', '', 0, 4),
('gAnalyticsPropId', '', 'google', 'text', '', 0, 0),
('links_per_box', '10', 'limits', 'dropdown', '10=10|20=20|30=30', 1, 0),
('mail_protocol', 'mail', 'email', 'dropdown', 'mail=mail|smtp=smtp|sendmail=sendmail', 1, 0),
('manual_activation', 'false', 'users', 'dropdown', 'true=yes|false=no', 1, 0),
('mod_non_user_comments', '1', 'comments', 'dropdown', '1=yes|0=no', 1, 2),
('mod_user_comments', '0', 'comments', 'dropdown', '1=yes|0=no', 1, 3),
('months_per_archive', '10', 'limits', 'dropdown', '10=10|20=20|30=30', 1, 0),
('posts_per_page', '10', 'limits', 'dropdown', '10=10|20=20|30=30', 1, 0),
('recaptcha_private_key', '', 'google', 'text', '', 0, 0),
('recaptcha_site_key', '', 'google', 'text', '', 0, 0),
('sendmail_path', '/usr/sbin/sendmail', 'email', 'text', '', 0, 0),
('server_email', '[[admin_email]]', 'email', 'text', '', 1, 0),
('site_name', '[[site_name]]', 'general', 'text', '', 1, 0),
('smtp_crypto', 'tls', 'email', 'dropdown', 'tls=TLS|ssl=SSL', 0, 0),
('smtp_host', '', 'email', 'text', '', 0, 0),
('smtp_pass', '', 'email', 'text', '', 0, 0),
('smtp_port', '', 'email', 'text', '', 0, 0),
('smtp_user', '', 'email', 'text', '', 0, 0),
('use_honeypot', '0', 'captcha', 'dropdown', '1=yes|0=no', 1, 0),
('use_recaptcha', '0', 'google', 'dropdown', '1=yes|0=no', 1, 0);

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

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

CREATE TABLE `[[dbprefix]]sidebar` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `file` varchar(100) NOT NULL,
  `status` enum('enabled','disabled') NOT NULL,
  `position` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

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

INSERT INTO `[[dbprefix]]sidebar` VALUES
(1, 'Search', 'search', 'enabled', '1'),
(2, 'Archive', 'archive', 'enabled', '2'),
(3, 'Categories', 'categories', 'enabled', '3'),
(4, 'Tag_cloud', 'tag_cloud', 'enabled', '4'),
(5, 'Feeds', 'feeds', 'enabled', '5'),
(6, 'Links', 'links', 'enabled', '6'),
(7, 'Other', 'other', 'enabled', '7');

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

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

CREATE TABLE `[[dbprefix]]social` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) DEFAULT NULL,
  `url` varchar(100) DEFAULT NULL,
  `enabled` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

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

INSERT INTO `[[dbprefix]]social` VALUES
(1, 'Facebook', NULL, 0),
(2, 'Twitter', NULL, 0);

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

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

CREATE TABLE `[[dbprefix]]templates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `description` varchar(200) NOT NULL,
  `author` varchar(100) DEFAULT NULL,
  `author_email` varchar(100) NOT NULL,
  `path` varchar(100) DEFAULT NULL,
  `image` varchar(100) DEFAULT NULL,
  `is_default` enum('0','1') DEFAULT '1',
  `is_active` varchar(1) NOT NULL DEFAULT '0',
  `is_admin` varchar(1) NOT NULL DEFAULT '0',
  `version` varchar(10) NOT NULL DEFAULT '1.0.0',
  `has_options` int(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

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

INSERT INTO `[[dbprefix]]templates` VALUES
(1, 'Default', 'The default theme for Pubvana', 'Enliven Applications', 'info@pubvana.org', 'default', 'default.png', '1', '1', '0', '1.0.0', 1),
(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);

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

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

CREATE TABLE `[[dbprefix]]theme_options` (
  `id` int(11) unsigned NOT NULL,
  `theme_id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  `value` varchar(200) NOT NULL,
  `type` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `[[dbprefix]]theme_options` VALUES
(1, 1, 'main_background', 'bg_suburb.jpg', 'images');

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

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

CREATE TABLE `[[dbprefix]]users` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ip_address` varchar(45) NOT NULL,
  `username` varchar(100) DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `salt` varchar(255) DEFAULT NULL,
  `email` varchar(100) NOT NULL,
  `activation_code` varchar(40) DEFAULT NULL,
  `forgotten_password_code` varchar(40) DEFAULT NULL,
  `forgotten_password_time` int(11) unsigned DEFAULT NULL,
  `remember_code` varchar(40) DEFAULT NULL,
  `created_on` int(11) unsigned NOT NULL,
  `last_login` int(11) unsigned DEFAULT NULL,
  `active` tinyint(1) unsigned DEFAULT NULL,
  `first_name` varchar(50) DEFAULT NULL,
  `last_name` varchar(50) DEFAULT NULL,
  `company` varchar(100) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

INSERT INTO `[[dbprefix]]users` VALUES
(1, '127.0.0.1', '[[admin_username]]', '[[admin_pass]]', '[[salt]]', '[[admin_email]]', NULL, NULL, NULL, NULL, [[timestamp]], [[timestamp]], 1, '[[admin_fname]]', '[[admin_lname]]', NULL, NULL);

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

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

CREATE TABLE `[[dbprefix]]users_groups` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) unsigned NOT NULL,
  `group_id` mediumint(8) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `uc_[[dbprefix]]users_groups` (`user_id`,`group_id`),
  KEY `fk_[[dbprefix]]users_groups_users1_idx` (`user_id`),
  KEY `fk_[[dbprefix]]users_groups_groups1_idx` (`group_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

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

INSERT INTO `[[dbprefix]]users_groups` VALUES
(1, 1, 1);

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

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

CREATE TABLE `[[dbprefix]]widgets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `description` varchar(200) NOT NULL,
  `author` varchar(50) NOT NULL,
  `author_email` varchar(50) NOT NULL,
  `author_website` varchar(50) NOT NULL,
  `version` varchar(50) NOT NULL,
  `slug` varchar(30) DEFAULT NULL,
  `options` text,
  `content` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

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

INSERT INTO `[[dbprefix]]widgets` VALUES
(1, 'HTML', 'Add arbitrary HTML to your site', 'Enliven Applications', 'info@pubvana.org', 'https://pubvana.com', '1.0.0', 'html', 'a:0:{}', ''),
(2, 'Pubvana Links', 'Add Links to your website. Admin -> Links', 'Enliven Applications', 'info@pubvana.org', 'https://enlivenapp.com', '1.0.0', 'pubvana_links', 'a:1:{s:8:"numlinks";a:5:{s:10:"field_type";s:8:"dropdown";s:7:"default";s:1:"5";s:5:"label";s:15:"Number of Links";s:9:"help_text";s:55:"Choose the maximum number of links to display publicly.";s:7:"options";s:18:"1|3|5|7|9|10|15|20";}}', ''),
(3, 'Pubvana Archives', 'Add Archived (Older) posts to your website.', 'Enliven Applications', 'info@pubvana.org', 'https://enlivenapp.com', '1.0.0', 'pubvana_archives', 'a:1:{s:11:"numarchives";a:5:{s:10:"field_type";s:8:"dropdown";s:7:"default";s:1:"5";s:5:"label";s:15:"Number of Links";s:9:"help_text";s:56:"Choose the maximum number of months to display publicly.";s:7:"options";s:18:"1|3|5|7|9|10|15|20";}}', ''),
(4, 'Pubvana Categories', 'Display blog categories on your website. Admin -> Categories', 'Enliven Applications', 'info@pubvana.org', 'https://enlivenapp.com', '1.0.0', 'pubvana_categories', 'a:1:{s:7:"numcats";a:5:{s:10:"field_type";s:8:"dropdown";s:7:"default";s:1:"5";s:5:"label";s:20:"Number of Categories";s:9:"help_text";s:60:"Choose the maximum number of categories to display publicly.";s:7:"options";s:18:"1|3|5|7|9|10|15|20";}}', ''),
(5, 'Pubvana Recent Posts', 'Show the most recent posts of your blog. Admin -> Posts', 'Enliven Applications', 'info@pubvana.org', 'https://enlivenapp.com', '1.0.0', 'pubvana_recent_posts', 'a:1:{s:8:"numposts";a:5:{s:10:"field_type";s:8:"dropdown";s:7:"default";s:1:"5";s:5:"label";s:15:"Number of Posts";s:9:"help_text";s:55:"Choose the maximum number of posts to display publicly.";s:7:"options";s:18:"1|3|5|7|9|10|15|20";}}', ''),
(6, 'Login Widget', 'Widget to login to your website', 'Enliven Applications', 'info@pubvana.org', 'https://enlivenapp.com', '1.0.1', 'pubvana_login', 'a:5:{s:14:"lang_login_btn";a:4:{s:10:"field_type";s:4:"text";s:7:"default";s:5:"Login";s:5:"label";s:12:"Login Button";s:9:"help_text";s:46:"Change the language used for the login button.";}s:17:"lang_remember_btn";a:4:{s:10:"field_type";s:4:"text";s:7:"default";s:11:"Remember Me";s:5:"label";s:16:"Remember Me Text";s:9:"help_text";s:50:"Change the language used for Remember Me checkbox.";}s:15:"lang_forgot_btn";a:4:{s:10:"field_type";s:4:"text";s:7:"default";s:21:"Forgot Your Password?";s:5:"label";s:25:"Forgotten Password Button";s:9:"help_text";s:57:"Change the language used for the Forgotten Password link.";}s:16:"lang_place_ident";a:4:{s:10:"field_type";s:4:"text";s:7:"default";s:15:"you@example.com";s:5:"label";s:20:"Identity Placeholder";s:9:"help_text";s:51:"Change the language used for the Email Placeholder.";}s:15:"lang_pass_ident";a:4:{s:10:"field_type";s:4:"text";s:7:"default";s:8:"Password";s:5:"label";s:20:"Password Placeholder";s:9:"help_text";s:54:"Change the language used for the Password Placeholder.";}}', ''),
(7, 'Pubvana Popular Posts', 'Show the most popular posts of your blog. Admin -> Posts', 'Enliven Applications', 'info@pubvana.org', 'https://enlivenapp.com', '1.0.0', 'pubvana_popular_posts', 'a:1:{s:8:"numposts";a:5:{s:10:"field_type";s:8:"dropdown";s:7:"default";s:1:"5";s:5:"label";s:15:"Number of Posts";s:9:"help_text";s:55:"Choose the maximum number of posts to display publicly.";s:7:"options";s:18:"1|3|5|7|9|10|15|20";}}', ''),
(8, 'Featured Post', 'Shows the featured posts of your blog. Set featured post in Admin -> Posts', 'Enliven Applications', 'info@pubvana.org', 'https://enlivenapp.com', '1.0.0', 'pubvana_featured_post', 'a:0:{}', '');

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

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

CREATE TABLE `[[dbprefix]]widget_areas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `theme_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

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

INSERT INTO `[[dbprefix]]widget_areas` VALUES
(1, 'home_left', 1),
(2, 'home_middle_left', 1),
(3, 'home_middle_right', 1),
(4, 'home_right', 1);

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

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

CREATE TABLE `[[dbprefix]]widget_instances` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `widget_area_id` int(11) NOT NULL,
  `widget_id` int(11) NOT NULL,
  `title` varchar(50) NOT NULL,
  `show_title` int(1) NOT NULL DEFAULT '1',
  `options` text,
  `content` text,
  `order` int(1) NOT NULL,
  `active` int(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `[[dbprefix]]users_groups`
--
ALTER TABLE `[[dbprefix]]users_groups`
  ADD CONSTRAINT `fk_[[dbprefix]]users_groups_groups1` FOREIGN KEY (`group_id`) REFERENCES `[[dbprefix]]groups` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_[[dbprefix]]users_groups_users1` FOREIGN KEY (`user_id`) REFERENCES `[[dbprefix]]users` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;