Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Fetching contributors…

Cannot retrieve contributors at this time

1142 lines (1002 sloc) 68.255 kB
-- phpMyAdmin SQL Dump
-- version 3.4.5
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 16, 2012 at 10:05 PM
-- Server version: 5.5.16
-- PHP Version: 5.3.8
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: `z140`
--
-- --------------------------------------------------------
--
-- Table structure for table `admin_category`
--
DROP TABLE IF EXISTS `admin_category`;
CREATE TABLE IF NOT EXISTS `admin_category` (
`cid` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
`description` varchar(255) NOT NULL,
`sortorder` int(11) NOT NULL,
PRIMARY KEY (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
--
-- Dumping data for table `admin_category`
--
INSERT INTO `admin_category` (`cid`, `name`, `description`, `sortorder`) VALUES
(1, 'System', 'Core modules at the heart of operation of the site.', 0),
(2, 'Layout', 'Layout modules for controlling the site''s look and feel.', 0),
(3, 'Users', 'Modules for controlling user membership, access rights and profiles.', 0),
(4, 'Content', 'Modules for providing content to your users.', 0),
(5, 'Uncategorised', 'Newly-installed or uncategorized modules.', 0),
(6, 'Security', 'Modules for managing the site''s security.', 0);
-- --------------------------------------------------------
--
-- Table structure for table `admin_module`
--
DROP TABLE IF EXISTS `admin_module`;
CREATE TABLE IF NOT EXISTS `admin_module` (
`amid` int(11) NOT NULL AUTO_INCREMENT,
`mid` int(11) NOT NULL,
`cid` int(11) NOT NULL,
`sortorder` int(11) NOT NULL,
PRIMARY KEY (`amid`),
KEY `mid_cid` (`mid`,`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=19 ;
--
-- Dumping data for table `admin_module`
--
INSERT INTO `admin_module` (`amid`, `mid`, `cid`, `sortorder`) VALUES
(1, 1, 1, 1),
(2, 12, 1, 2),
(3, 13, 2, 1),
(4, 2, 4, 3),
(5, 9, 3, 0),
(6, 6, 3, 1),
(7, 3, 2, 0),
(8, 14, 3, 2),
(9, 11, 6, 0),
(10, 4, 4, 0),
(11, 15, 4, 1),
(12, 7, 1, 0),
(13, 5, 1, 4),
(14, 10, 4, 2),
(15, 18, 5, 0),
(16, 19, 5, 1),
(17, 8, 5, 2),
(18, 17, 5, 3);
-- --------------------------------------------------------
--
-- Table structure for table `blocks`
--
DROP TABLE IF EXISTS `blocks`;
CREATE TABLE IF NOT EXISTS `blocks` (
`bid` int(11) NOT NULL AUTO_INCREMENT,
`bkey` varchar(255) NOT NULL,
`title` varchar(255) NOT NULL,
`description` longtext NOT NULL,
`content` longtext NOT NULL,
`url` longtext NOT NULL,
`mid` int(11) NOT NULL,
`filter` longtext NOT NULL COMMENT '(DC2Type:array)',
`active` int(11) NOT NULL,
`collapsable` int(11) NOT NULL,
`defaultstate` int(11) NOT NULL,
`refresh` int(11) NOT NULL,
`last_update` datetime NOT NULL,
`language` varchar(30) NOT NULL,
PRIMARY KEY (`bid`),
KEY `active_idx` (`active`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `blocks`
--
INSERT INTO `blocks` (`bid`, `bkey`, `title`, `description`, `content`, `url`, `mid`, `filter`, `active`, `collapsable`, `defaultstate`, `refresh`, `last_update`, `language`) VALUES
(1, 'Extmenu', 'Main menu', 'Main menu', 'a:5:{s:14:"displaymodules";s:1:"0";s:10:"stylesheet";s:11:"extmenu.css";s:8:"template";s:17:"Block/extmenu.tpl";s:11:"blocktitles";a:2:{s:2:"de";s:9:"Main menu";s:2:"en";s:9:"Main menu";}s:5:"links";a:2:{s:2:"de";a:5:{i:0;a:7:{s:4:"name";s:4:"Home";s:3:"url";s:10:"{homepage}";s:5:"title";s:19:"Go to the home page";s:5:"level";i:0;s:8:"parentid";N;s:5:"image";s:0:"";s:6:"active";s:1:"1";}i:1;a:7:{s:4:"name";s:14:"Administration";s:3:"url";s:24:"{Admin:admin:adminpanel}";s:5:"title";s:29:"Go to the site administration";s:5:"level";i:0;s:8:"parentid";N;s:5:"image";s:0:"";s:6:"active";s:1:"1";}i:2;a:7:{s:4:"name";s:10:"My Account";s:3:"url";s:7:"{Users}";s:5:"title";s:24:"Go to your account panel";s:5:"level";i:0;s:8:"parentid";N;s:5:"image";s:0:"";s:6:"active";s:1:"1";}i:3;a:7:{s:4:"name";s:7:"Log out";s:3:"url";s:19:"{Users:user:logout}";s:5:"title";s:20:"Log out of this site";s:5:"level";i:0;s:8:"parentid";N;s:5:"image";s:0:"";s:6:"active";s:1:"1";}i:4;a:7:{s:4:"name";s:11:"Site search";s:3:"url";s:8:"{Search}";s:5:"title";s:16:"Search this site";s:5:"level";i:0;s:8:"parentid";N;s:5:"image";s:0:"";s:6:"active";s:1:"1";}}s:2:"en";a:5:{i:0;a:7:{s:4:"name";s:4:"Home";s:3:"url";s:10:"{homepage}";s:5:"title";s:19:"Go to the home page";s:5:"level";i:0;s:8:"parentid";N;s:5:"image";s:0:"";s:6:"active";s:1:"1";}i:1;a:7:{s:4:"name";s:14:"Administration";s:3:"url";s:24:"{Admin:admin:adminpanel}";s:5:"title";s:29:"Go to the site administration";s:5:"level";i:0;s:8:"parentid";N;s:5:"image";s:0:"";s:6:"active";s:1:"1";}i:2;a:7:{s:4:"name";s:10:"My Account";s:3:"url";s:7:"{Users}";s:5:"title";s:24:"Go to your account panel";s:5:"level";i:0;s:8:"parentid";N;s:5:"image";s:0:"";s:6:"active";s:1:"1";}i:3;a:7:{s:4:"name";s:7:"Log out";s:3:"url";s:19:"{Users:user:logout}";s:5:"title";s:20:"Log out of this site";s:5:"level";i:0;s:8:"parentid";N;s:5:"image";s:0:"";s:6:"active";s:1:"1";}i:4;a:7:{s:4:"name";s:11:"Site search";s:3:"url";s:8:"{Search}";s:5:"title";s:16:"Search this site";s:5:"level";i:0;s:8:"parentid";N;s:5:"image";s:0:"";s:6:"active";s:1:"1";}}}}', '', 3, 'a:0:{}', 1, 1, 1, 3600, '2012-04-08 09:27:46', ''),
(2, 'Search', 'Search box', 'Search block', 'a:2:{s:16:"displaySearchBtn";i:1;s:6:"active";a:1:{s:5:"Users";i:1;}}', '', 10, 'a:0:{}', 1, 1, 1, 3600, '2012-04-08 09:27:46', ''),
(3, 'Html', 'This site is powered by Zikula!', 'HTML block', '<p><a href="http://zikula.org/">Zikula</a> is a content management system (CMS) and application framework. It is secure and stable, and is a good choice for sites with a large volume of traffic.</p><p>With Zikula:</p><ul><li>you can customise all aspects of the site''s appearance through themes, with support for CSS style sheets, JavaScript, Flash and all other modern web development technologies;</li><li>you can mark content as being suitable for either a single language or for all languages, and can control all aspects of localisation and internationalisation of your site;</li><li>you can be sure that your pages will display properly in all browsers, thanks to Zikula''s full compliance with W3C HTML standards;</li><li>you get a standard application-programming interface (API) that lets you easily augment your site''s functionality through modules, blocks and other extensions;</li><li>you can get help and support from the Zikula community of webmasters and developers at <a href="http://www.zikula.org">zikula.org</a>.</li></ul><p>Enjoy using Zikula!</p><p><strong>The Zikula team</strong></p><p><em>Note: Zikula is Free Open Source Software (FOSS) licensed under the GNU General Public License.</em></p>', '', 3, 'a:0:{}', 1, 1, 1, 3600, '2012-04-08 09:27:46', ''),
(4, 'Login', 'User log-in', 'Login block', '', '', 14, 'a:0:{}', 1, 1, 1, 3600, '2012-04-08 09:27:46', ''),
(5, 'Extmenu', 'Top navigation', 'Theme navigation', 'a:5:{s:14:"displaymodules";s:1:"0";s:10:"stylesheet";s:11:"extmenu.css";s:8:"template";s:24:"Block/extmenu_topnav.tpl";s:11:"blocktitles";a:2:{s:2:"de";s:14:"Top navigation";s:2:"en";s:14:"Top navigation";}s:5:"links";a:2:{s:2:"de";a:3:{i:0;a:7:{s:4:"name";s:4:"Home";s:3:"url";s:10:"{homepage}";s:5:"title";s:26:"Go to the site''s home page";s:5:"level";i:0;s:8:"parentid";N;s:5:"image";s:0:"";s:6:"active";s:1:"1";}i:1;a:7:{s:4:"name";s:10:"My Account";s:3:"url";s:7:"{Users}";s:5:"title";s:24:"Go to your account panel";s:5:"level";i:0;s:8:"parentid";N;s:5:"image";s:0:"";s:6:"active";s:1:"1";}i:2;a:7:{s:4:"name";s:11:"Site search";s:3:"url";s:8:"{Search}";s:5:"title";s:16:"Search this site";s:5:"level";i:0;s:8:"parentid";N;s:5:"image";s:0:"";s:6:"active";s:1:"1";}}s:2:"en";a:3:{i:0;a:7:{s:4:"name";s:4:"Home";s:3:"url";s:10:"{homepage}";s:5:"title";s:26:"Go to the site''s home page";s:5:"level";i:0;s:8:"parentid";N;s:5:"image";s:0:"";s:6:"active";s:1:"1";}i:1;a:7:{s:4:"name";s:10:"My Account";s:3:"url";s:7:"{Users}";s:5:"title";s:24:"Go to your account panel";s:5:"level";i:0;s:8:"parentid";N;s:5:"image";s:0:"";s:6:"active";s:1:"1";}i:2;a:7:{s:4:"name";s:11:"Site search";s:3:"url";s:8:"{Search}";s:5:"title";s:16:"Search this site";s:5:"level";i:0;s:8:"parentid";N;s:5:"image";s:0:"";s:6:"active";s:1:"1";}}}}', '', 3, 'a:0:{}', 1, 1, 1, 3600, '2012-04-08 09:27:46', '');
-- --------------------------------------------------------
--
-- Table structure for table `block_placements`
--
DROP TABLE IF EXISTS `block_placements`;
CREATE TABLE IF NOT EXISTS `block_placements` (
`pid` int(11) NOT NULL,
`bid` int(11) NOT NULL,
`sortorder` int(11) NOT NULL,
PRIMARY KEY (`pid`,`bid`),
KEY `bid_pid_idx` (`bid`,`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `block_placements`
--
INSERT INTO `block_placements` (`pid`, `bid`, `sortorder`) VALUES
(1, 1, 0),
(4, 2, 0),
(3, 3, 0),
(2, 4, 0),
(7, 5, 0);
-- --------------------------------------------------------
--
-- Table structure for table `block_positions`
--
DROP TABLE IF EXISTS `block_positions`;
CREATE TABLE IF NOT EXISTS `block_positions` (
`pid` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`description` varchar(255) NOT NULL,
PRIMARY KEY (`pid`),
KEY `name_idx` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
--
-- Dumping data for table `block_positions`
--
INSERT INTO `block_positions` (`pid`, `name`, `description`) VALUES
(1, 'left', 'Left blocks'),
(2, 'right', 'Right blocks'),
(3, 'center', 'Center blocks'),
(4, 'search', 'Search block'),
(5, 'header', 'Header block'),
(6, 'footer', 'Footer block'),
(7, 'topnav', 'Top navigation block'),
(8, 'bottomnav', 'Bottom navigation block');
-- --------------------------------------------------------
--
-- Table structure for table `categories_category`
--
DROP TABLE IF EXISTS `categories`;
CREATE TABLE IF NOT EXISTS `categories` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`parent_id` int(11) NOT NULL DEFAULT '1',
`is_locked` tinyint(4) NOT NULL DEFAULT '0',
`is_leaf` tinyint(4) NOT NULL DEFAULT '0',
`name` varchar(255) NOT NULL,
`value` varchar(255) NOT NULL,
`sort_value` int(11) NOT NULL DEFAULT '2147483647',
`display_name` longtext NOT NULL,
`display_desc` longtext NOT NULL,
`path` longtext NOT NULL,
`ipath` varchar(255) NOT NULL,
`status` varchar(1) NOT NULL DEFAULT 'A',
PRIMARY KEY (`id`),
KEY `idx_categories_parent` (`parent_id`),
KEY `idx_categories_is_leaf` (`is_leaf`),
KEY `idx_categories_name` (`name`),
KEY `idx_categories_ipath` (`ipath`,`is_leaf`,`status`),
KEY `idx_categories_status` (`status`),
KEY `idx_categories_ipath_status` (`ipath`,`status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10000 ;
--
-- Dumping data for table `categories_category`
--
INSERT INTO `categories` (`id`, `parent_id`, `is_locked`, `is_leaf`, `name`, `value`, `sort_value`, `display_name`, `display_desc`, `path`, `ipath`, `status`) VALUES
(1, 0, 1, 0, '__SYSTEM__', '', 1, 's:0:"";', 's:0:"";', '/__SYSTEM__', '/1', 'A'),
(2, 1, 0, 0, 'Modules', '', 2, 'a:1:{s:2:"en";s:7:"Modules";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/Modules', '/1/2', 'A'),
(3, 1, 0, 0, 'General', '', 3, 'a:1:{s:2:"en";s:7:"General";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/General', '/1/3', 'A'),
(4, 3, 0, 0, 'YesNo', '', 4, 'a:1:{s:2:"en";s:6:"Yes/No";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/General/YesNo', '/1/3/4', 'A'),
(5, 4, 0, 1, '1 - Yes', 'Y', 5, 's:0:"";', 's:0:"";', '/__SYSTEM__/General/YesNo/1 - Yes', '/1/3/4/5', 'A'),
(6, 4, 0, 1, '2 - No', 'N', 6, 's:0:"";', 's:0:"";', '/__SYSTEM__/General/YesNo/2 - No', '/1/3/4/6', 'A'),
(10, 3, 0, 0, 'Publication Status (extended)', '', 10, 'a:1:{s:2:"en";s:29:"Publication status (extended)";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/General/Publication Status (extended)', '/1/3/10', 'A'),
(11, 10, 0, 1, 'Pending', 'P', 11, 'a:1:{s:2:"en";s:7:"Pending";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/General/Publication Status (extended)/Pending', '/1/3/10/11', 'A'),
(12, 10, 0, 1, 'Checked', 'C', 12, 'a:1:{s:2:"en";s:7:"Checked";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/General/Publication Status (extended)/Checked', '/1/3/10/12', 'A'),
(13, 10, 0, 1, 'Approved', 'A', 13, 'a:1:{s:2:"en";s:8:"Approved";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/General/Publication Status (extended)/Approved', '/1/3/10/13', 'A'),
(14, 10, 0, 1, 'On-line', 'O', 14, 'a:1:{s:2:"en";s:7:"On-line";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/General/Publication Status (extended)/On-line', '/1/3/10/14', 'A'),
(15, 10, 0, 1, 'Rejected', 'R', 15, 'a:1:{s:2:"en";s:8:"Rejected";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/General/Publication Status (extended)/Rejected', '/1/3/10/15', 'A'),
(16, 3, 0, 0, 'Gender', '', 16, 'a:1:{s:2:"en";s:6:"Gender";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/General/Gender', '/1/3/16', 'A'),
(17, 16, 0, 1, 'Male', 'M', 17, 'a:1:{s:2:"en";s:4:"Male";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/General/Gender/Male', '/1/3/16/17', 'A'),
(18, 16, 0, 1, 'Female', 'F', 18, 'a:1:{s:2:"en";s:6:"Female";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/General/Gender/Female', '/1/3/16/18', 'A'),
(19, 3, 0, 0, 'Title', '', 19, 'a:1:{s:2:"en";s:5:"Title";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/General/Title', '/1/3/19', 'A'),
(20, 19, 0, 1, 'Mr', 'Mr', 20, 'a:1:{s:2:"en";s:3:"Mr.";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/General/Title/Mr', '/1/3/19/20', 'A'),
(21, 19, 0, 1, 'Mrs', 'Mrs', 21, 'a:1:{s:2:"en";s:4:"Mrs.";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/General/Title/Mrs', '/1/3/19/21', 'A'),
(22, 19, 0, 1, 'Ms', 'Ms', 22, 'a:1:{s:2:"en";s:3:"Ms.";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/General/Title/Ms', '/1/3/19/22', 'A'),
(23, 19, 0, 1, 'Miss', 'Miss', 23, 'a:1:{s:2:"en";s:4:"Miss";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/General/Title/Miss', '/1/3/19/23', 'A'),
(24, 19, 0, 1, 'Dr', 'Dr', 24, 'a:1:{s:2:"en";s:3:"Dr.";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/General/Title/Dr', '/1/3/19/24', 'A'),
(25, 3, 0, 0, 'ActiveStatus', '', 25, 'a:1:{s:2:"en";s:15:"Activity status";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/General/ActiveStatus', '/1/3/25', 'A'),
(26, 25, 0, 1, 'Active', 'A', 26, 'a:1:{s:2:"en";s:6:"Active";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/General/ActiveStatus/Active', '/1/3/25/26', 'A'),
(27, 25, 0, 1, 'Inactive', 'I', 27, 'a:1:{s:2:"en";s:8:"Inactive";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/General/ActiveStatus/Inactive', '/1/3/25/27', 'A'),
(28, 3, 0, 0, 'Publication status (basic)', '', 28, 'a:1:{s:2:"en";s:26:"Publication status (basic)";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/General/Publication status (basic)', '/1/3/28', 'A'),
(29, 28, 0, 1, 'Pending', 'P', 29, 'a:1:{s:2:"en";s:7:"Pending";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/General/Publication status (basic)/Pending', '/1/3/28/29', 'A'),
(30, 28, 0, 1, 'Approved', 'A', 30, 'a:1:{s:2:"en";s:8:"Approved";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/General/Publication status (basic)/Approved', '/1/3/28/30', 'A'),
(31, 1, 0, 0, 'Users', '', 31, 'a:1:{s:2:"en";s:5:"Users";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/Users', '/1/31', 'A'),
(32, 2, 0, 0, 'Global', '', 32, 'a:1:{s:2:"en";s:6:"Global";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/Modules/Global', '/1/2/32', 'A'),
(33, 32, 0, 1, 'Blogging', '', 33, 'a:1:{s:2:"en";s:8:"Blogging";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/Modules/Global/Blogging', '/1/2/32/33', 'A'),
(34, 32, 0, 1, 'Music and audio', '', 34, 'a:1:{s:2:"en";s:15:"Music and audio";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/Modules/Global/Music and audio', '/1/2/32/34', 'A'),
(35, 32, 0, 1, 'Art and photography', '', 35, 'a:1:{s:2:"en";s:19:"Art and photography";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/Modules/Global/Art and photography', '/1/2/32/35', 'A'),
(36, 32, 0, 1, 'Writing and thinking', '', 36, 'a:1:{s:2:"en";s:20:"Writing and thinking";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/Modules/Global/Writing and thinking', '/1/2/32/36', 'A'),
(37, 32, 0, 1, 'Communications and media', '', 37, 'a:1:{s:2:"en";s:24:"Communications and media";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/Modules/Global/Communications and media', '/1/2/32/37', 'A'),
(38, 32, 0, 1, 'Travel and culture', '', 38, 'a:1:{s:2:"en";s:18:"Travel and culture";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/Modules/Global/Travel and culture', '/1/2/32/38', 'A'),
(39, 32, 0, 1, 'Science and technology', '', 39, 'a:1:{s:2:"en";s:22:"Science and technology";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/Modules/Global/Science and technology', '/1/2/32/39', 'A'),
(40, 32, 0, 1, 'Sport and activities', '', 40, 'a:1:{s:2:"en";s:20:"Sport and activities";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/Modules/Global/Sport and activities', '/1/2/32/40', 'A'),
(41, 32, 0, 1, 'Business and work', '', 41, 'a:1:{s:2:"en";s:17:"Business and work";}', 'a:1:{s:2:"en";s:0:"";}', '/__SYSTEM__/Modules/Global/Business and work', '/1/2/32/41', 'A');
-- --------------------------------------------------------
--
-- Table structure for table `categories_attributes`
--
CREATE TABLE IF NOT EXISTS `categories_attributes` (
`category_id` int(11) NOT NULL,
`name` varchar(80) NOT NULL,
`value` longtext NOT NULL,
PRIMARY KEY (`category_id`,`name`),
KEY `category_id` (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table `categories_attributes`
--
INSERT INTO `categories_attributes` (`category_id`, `name`, `value`) VALUES
(5, 'code', 'Y'),
(6, 'code', 'N'),
(11, 'code', 'P'),
(12, 'code', 'C'),
(13, 'code', 'A'),
(14, 'code', 'O'),
(15, 'code', 'R'),
(17, 'code', 'M'),
(18, 'code', 'F'),
(26, 'code', 'A'),
(27, 'code', 'I'),
(29, 'code', 'P'),
(30, 'code', 'A');
--
-- Table structure for table `categories_registry`
--
DROP TABLE IF EXISTS `categories_registry`;
CREATE TABLE IF NOT EXISTS `categories_registry` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`modname` varchar(60) NOT NULL,
`entityname` varchar(60) NOT NULL,
`property` varchar(60) NOT NULL,
`category_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `idx_categories_registry` (`modname`,`entityname`,`property`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `groups`
--
DROP TABLE IF EXISTS `groups`;
CREATE TABLE IF NOT EXISTS `groups` (
`gid` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`gtype` tinyint(4) NOT NULL DEFAULT '0',
`description` varchar(200) NOT NULL,
`prefix` varchar(25) NOT NULL,
`state` tinyint(4) NOT NULL DEFAULT '0',
`nbuser` int(11) NOT NULL DEFAULT '0',
`nbumax` int(11) NOT NULL DEFAULT '0',
`link` int(11) NOT NULL DEFAULT '0',
`uidmaster` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`gid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `groups`
--
INSERT INTO `groups` (`gid`, `name`, `gtype`, `description`, `prefix`, `state`, `nbuser`, `nbumax`, `link`, `uidmaster`) VALUES
(1, 'Users', 0, 'By default, all users are made members of this group.', 'usr', 0, 0, 0, 0, 0),
(2, 'Administrators', 0, 'Group of administrators of this site.', 'adm', 0, 0, 0, 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `group_applications`
--
DROP TABLE IF EXISTS `group_applications`;
CREATE TABLE IF NOT EXISTS `group_applications` (
`app_id` int(11) NOT NULL AUTO_INCREMENT,
`uid` int(11) NOT NULL DEFAULT '0',
`gid` int(11) NOT NULL DEFAULT '0',
`application` longtext NOT NULL,
`status` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`app_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `group_membership`
--
DROP TABLE IF EXISTS `group_membership`;
CREATE TABLE IF NOT EXISTS `group_membership` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`gid` int(11) NOT NULL DEFAULT '0',
`uid` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `gid_uid` (`uid`,`gid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `group_membership`
--
INSERT INTO `group_membership` (`id`, `gid`, `uid`) VALUES
(1, 1, 1),
(2, 1, 2),
(3, 2, 2);
-- --------------------------------------------------------
--
-- Table structure for table `group_perms`
--
DROP TABLE IF EXISTS `group_perms`;
CREATE TABLE IF NOT EXISTS `group_perms` (
`pid` int(11) NOT NULL AUTO_INCREMENT,
`gid` int(11) NOT NULL DEFAULT '0',
`sequence` int(11) NOT NULL DEFAULT '0',
`realm` int(11) NOT NULL DEFAULT '0',
`component` varchar(255) NOT NULL,
`instance` varchar(255) NOT NULL,
`level` int(11) NOT NULL DEFAULT '0',
`bond` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `group_perms`
--
INSERT INTO `group_perms` (`pid`, `gid`, `sequence`, `realm`, `component`, `instance`, `level`, `bond`) VALUES
(1, 2, 1, 0, '.*', '.*', 800, 0),
(2, -1, 2, 0, 'ExtendedMenublock::', '1:1:', 0, 0),
(3, 1, 3, 0, '.*', '.*', 300, 0),
(4, 0, 4, 0, 'ExtendedMenublock::', '1:(1|2|3):', 0, 0),
(5, 0, 5, 0, '.*', '.*', 200, 0);
-- --------------------------------------------------------
--
-- Table structure for table `hook_area`
--
DROP TABLE IF EXISTS `hook_area`;
CREATE TABLE IF NOT EXISTS `hook_area` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`owner` varchar(40) NOT NULL,
`subowner` varchar(40) DEFAULT NULL,
`areatype` varchar(1) NOT NULL,
`category` varchar(20) NOT NULL,
`areaname` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `areaidx` (`areaname`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
--
-- Dumping data for table `hook_area`
--
INSERT INTO `hook_area` (`id`, `owner`, `subowner`, `areatype`, `category`, `areaname`) VALUES
(1, 'Users', NULL, 's', 'ui_hooks', 'subscriber.users.ui_hooks.user'),
(2, 'Users', NULL, 's', 'ui_hooks', 'subscriber.users.ui_hooks.registration'),
(3, 'Users', NULL, 's', 'ui_hooks', 'subscriber.users.ui_hooks.login_screen'),
(4, 'Users', NULL, 's', 'ui_hooks', 'subscriber.users.ui_hooks.login_block');
-- --------------------------------------------------------
--
-- Table structure for table `hook_binding`
--
DROP TABLE IF EXISTS `hook_binding`;
CREATE TABLE IF NOT EXISTS `hook_binding` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sowner` varchar(40) NOT NULL,
`subsowner` varchar(40) DEFAULT NULL,
`powner` varchar(40) NOT NULL,
`subpowner` varchar(40) DEFAULT NULL,
`sareaid` int(11) NOT NULL,
`pareaid` int(11) NOT NULL,
`category` varchar(20) NOT NULL,
`sortorder` smallint(6) NOT NULL DEFAULT '999',
PRIMARY KEY (`id`),
KEY `sortidx` (`sareaid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `hook_provider`
--
DROP TABLE IF EXISTS `hook_provider`;
CREATE TABLE IF NOT EXISTS `hook_provider` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`owner` varchar(40) NOT NULL,
`subowner` varchar(40) DEFAULT NULL,
`pareaid` int(11) NOT NULL,
`hooktype` varchar(20) NOT NULL,
`category` varchar(20) NOT NULL,
`classname` varchar(60) NOT NULL,
`method` varchar(20) NOT NULL,
`serviceid` varchar(60) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `nameidx` (`pareaid`,`hooktype`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `hook_runtime`
--
DROP TABLE IF EXISTS `hook_runtime`;
CREATE TABLE IF NOT EXISTS `hook_runtime` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sowner` varchar(40) NOT NULL,
`subsowner` varchar(40) DEFAULT NULL,
`powner` varchar(40) NOT NULL,
`subpowner` varchar(40) DEFAULT NULL,
`sareaid` int(11) NOT NULL,
`pareaid` int(11) NOT NULL,
`eventname` varchar(100) NOT NULL,
`classname` varchar(60) NOT NULL,
`method` varchar(20) NOT NULL,
`serviceid` varchar(60) DEFAULT NULL,
`priority` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `hook_subscriber`
--
DROP TABLE IF EXISTS `hook_subscriber`;
CREATE TABLE IF NOT EXISTS `hook_subscriber` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`owner` varchar(40) NOT NULL,
`subowner` varchar(40) DEFAULT NULL,
`sareaid` int(11) NOT NULL,
`hooktype` varchar(20) NOT NULL,
`category` varchar(20) NOT NULL,
`eventname` varchar(100) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `myindex` (`eventname`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;
--
-- Dumping data for table `hook_subscriber`
--
INSERT INTO `hook_subscriber` (`id`, `owner`, `subowner`, `sareaid`, `hooktype`, `category`, `eventname`) VALUES
(1, 'Users', NULL, 1, 'display_view', 'ui_hooks', 'users.ui_hooks.user.display_view'),
(2, 'Users', NULL, 1, 'form_edit', 'ui_hooks', 'users.ui_hooks.user.form_edit'),
(3, 'Users', NULL, 1, 'validate_edit', 'ui_hooks', 'users.ui_hooks.user.validate_edit'),
(4, 'Users', NULL, 1, 'process_edit', 'ui_hooks', 'users.ui_hooks.user.process_edit'),
(5, 'Users', NULL, 1, 'form_delete', 'ui_hooks', 'users.ui_hooks.user.form_delete'),
(6, 'Users', NULL, 1, 'validate_delete', 'ui_hooks', 'users.ui_hooks.user.validate_delete'),
(7, 'Users', NULL, 1, 'process_delete', 'ui_hooks', 'users.ui_hooks.user.process_delete'),
(8, 'Users', NULL, 2, 'display_view', 'ui_hooks', 'users.ui_hooks.registration.display_view'),
(9, 'Users', NULL, 2, 'form_edit', 'ui_hooks', 'users.ui_hooks.registration.form_edit'),
(10, 'Users', NULL, 2, 'validate_edit', 'ui_hooks', 'users.ui_hooks.registration.validate_edit'),
(11, 'Users', NULL, 2, 'process_edit', 'ui_hooks', 'users.ui_hooks.registration.process_edit'),
(12, 'Users', NULL, 2, 'form_delete', 'ui_hooks', 'users.ui_hooks.registration.form_delete'),
(13, 'Users', NULL, 2, 'validate_delete', 'ui_hooks', 'users.ui_hooks.registration.validate_delete'),
(14, 'Users', NULL, 2, 'process_delete', 'ui_hooks', 'users.ui_hooks.registration.process_delete'),
(15, 'Users', NULL, 3, 'form_edit', 'ui_hooks', 'users.ui_hooks.login_screen.form_edit'),
(16, 'Users', NULL, 3, 'validate_edit', 'ui_hooks', 'users.ui_hooks.login_screen.validate_edit'),
(17, 'Users', NULL, 3, 'process_edit', 'ui_hooks', 'users.ui_hooks.login_screen.process_edit'),
(18, 'Users', NULL, 4, 'form_edit', 'ui_hooks', 'users.ui_hooks.login_block.form_edit'),
(19, 'Users', NULL, 4, 'validate_edit', 'ui_hooks', 'users.ui_hooks.login_block.validate_edit'),
(20, 'Users', NULL, 4, 'process_edit', 'ui_hooks', 'users.ui_hooks.login_block.process_edit');
-- --------------------------------------------------------
--
-- Table structure for table `modules`
--
DROP TABLE IF EXISTS `modules`;
CREATE TABLE IF NOT EXISTS `modules` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(64) NOT NULL,
`type` int(11) NOT NULL,
`displayname` varchar(64) NOT NULL,
`url` varchar(64) NOT NULL,
`description` varchar(255) NOT NULL,
`directory` varchar(255) NOT NULL,
`version` varchar(10) NOT NULL,
`capabilities` tinytext NOT NULL COMMENT '(DC2Type:array)',
`state` int(11) NOT NULL,
`securityschema` longtext NOT NULL COMMENT '(DC2Type:array)',
`core_min` varchar(10) NOT NULL,
`core_max` varchar(10) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;
--
-- Dumping data for table `modules`
--
INSERT INTO `modules` (`id`, `name`, `type`, `displayname`, `url`, `description`, `directory`, `version`, `capabilities`, `state`, `securityschema`, `core_min`, `core_max`) VALUES
(1, 'ExtensionsModule', 3, 'Extensions', 'extensions', 'Manage your modules and plugins.', 'ExtensionsModule', '3.7.10', 'a:1:{s:5:"admin";a:1:{s:7:"version";s:3:"1.0";}}', 3, 'a:1:{s:12:"Extensions::";s:2:"::";}', '', ''),
(2, 'AdminModule', 3, 'Administration panel', 'adminpanel', 'Backend administration interface.', 'AdminModule', '1.9.1', 'a:1:{s:5:"admin";a:1:{s:7:"version";s:3:"1.0";}}', 3, 'a:1:{s:7:"Admin::";s:38:"Admin Category name::Admin Category ID";}', '', ''),
(3, 'BlocksModule', 3, 'Blocks', 'blocks', 'Block administration module.', 'BlocksModule', '3.8.1', 'a:2:{s:5:"admin";a:1:{s:7:"version";s:3:"1.0";}s:4:"user";a:1:{s:7:"version";s:3:"1.0";}}', 3, 'a:4:{s:8:"Blocks::";s:30:"Block key:Block title:Block ID";s:16:"Blocks::position";s:26:"Position name::Position ID";s:23:"Menutree:menutreeblock:";s:26:"Block ID:Link Name:Link ID";s:19:"ExtendedMenublock::";s:17:"Block ID:Link ID:";}', '', ''),
(4, 'CategoriesModule', 3, 'Categories', 'categories', 'Category administration.', 'CategoriesModule', '1.2.1', 'a:2:{s:5:"admin";a:1:{s:7:"version";s:3:"1.0";}s:4:"user";a:1:{s:7:"version";s:3:"1.0";}}', 3, 'a:1:{s:20:"Categories::Category";s:40:"Category ID:Category Path:Category IPath";}', '', ''),
(5, 'ErrorsModule', 3, 'Errors', 'errors', 'Error display module.', 'ErrorsModule', '1.1.1', 'a:1:{s:4:"user";a:1:{s:7:"version";s:3:"1.0";}}', 3, 'a:1:{s:8:"Errors::";s:2:"::";}', '', ''),
(6, 'GroupsModule', 3, 'Groups', 'groups', 'User group administration module.', 'GroupsModule', '2.3.2', 'a:2:{s:5:"admin";a:1:{s:7:"version";s:3:"1.0";}s:4:"user";a:1:{s:7:"version";s:3:"1.0";}}', 3, 'a:1:{s:8:"Groups::";s:10:"Group ID::";}', '', ''),
(7, 'MailerModule', 3, 'Mailer', 'mailer', 'Mailer module, provides mail API and mail setting administration.', 'MailerModule', '1.3.2', 'a:1:{s:5:"admin";a:1:{s:7:"version";s:3:"1.0";}}', 3, 'a:1:{s:8:"Mailer::";s:2:"::";}', '', ''),
(8, 'PageLockModule', 3, 'Page lock', 'pagelock', 'Provides the ability to lock pages when they are in use, for content and access control.', 'PageLockModule', '1.1.1', 'a:0:{}', 3, 'a:1:{s:10:"PageLock::";s:2:"::";}', '', ''),
(9, 'PermissionsModule', 3, 'Permissions', 'permissions', 'User permissions manager.', 'PermissionsModule', '1.1.1', 'a:1:{s:5:"admin";a:1:{s:7:"version";s:3:"1.0";}}', 3, 'a:1:{s:13:"Permissions::";s:2:"::";}', '', ''),
(10, 'SearchModule', 3, 'Site search', 'search', 'Site search module.', 'SearchModule', '1.5.2', 'a:2:{s:5:"admin";a:1:{s:7:"version";s:3:"1.0";}s:4:"user";a:1:{s:7:"version";s:3:"1.0";}}', 3, 'a:1:{s:8:"Search::";s:13:"Module name::";}', '', ''),
(11, 'SecurityCenterModule', 3, 'Security Center', 'securitycenter', 'Manage site security and settings.', 'SecurityCenterModule', '1.4.4', 'a:1:{s:5:"admin";a:1:{s:7:"version";s:3:"1.0";}}', 3, 'a:1:{s:16:"SecurityCenter::";s:2:"::";}', '', ''),
(12, 'SettingsModule', 3, 'General settings', 'settings', 'General site configuration interface.', 'SettingsModule', '2.9.7', 'a:1:{s:5:"admin";a:1:{s:7:"version";s:3:"1.0";}}', 3, 'a:1:{s:10:"Settings::";s:2:"::";}', '', ''),
(13, 'ThemeModule', 3, 'Themes', 'theme', 'Themes module to manage site layout, render and cache settings.', 'ThemeModule', '3.4.1', 'a:2:{s:5:"admin";a:1:{s:7:"version";s:3:"1.0";}s:4:"user";a:1:{s:7:"version";s:3:"1.0";}}', 3, 'a:1:{s:7:"Theme::";s:12:"Theme name::";}', '', ''),
(14, 'UsersModule', 3, 'Users', 'users', 'Provides an interface for configuring and administering registered user accounts. Incorporates all needed functionality, but can work in close unison with the third party profile module configured in the general settings of the site.', 'UsersModule', '2.2.0', 'a:4:{s:14:"authentication";a:1:{s:7:"version";s:3:"1.0";}s:15:"hook_subscriber";a:1:{s:7:"enabled";b:1;}s:5:"admin";a:1:{s:7:"version";s:3:"1.0";}s:4:"user";a:1:{s:7:"version";s:3:"1.0";}}', 5, 'a:2:{s:7:"Users::";s:14:"Uname::User ID";s:16:"Users::MailUsers";s:2:"::";}', '1.3.0', ''),
(17, 'LegalModule', 2, 'Legal info manager', 'legalmod', 'Provides an interface for managing the site''s legal documents.', 'LegalModule', '3.0.1', 'a:1:{s:4:"user";a:1:{s:7:"version";s:3:"1.0";}}', 3, 'a:8:{s:13:"LegalModule::";s:2:"::";s:24:"LegalModule::legalnotice";s:2:"::";s:23:"LegalModule::termsofuse";s:2:"::";s:26:"LegalModule::privacypolicy";s:2:"::";s:22:"LegalModule::agepolicy";s:2:"::";s:35:"LegalModule::accessibilitystatement";s:2:"::";s:36:"LegalModule::cancellationrightpolicy";s:2:"::";s:28:"LegalModule::tradeconditions";s:2:"::";}', '1.4.0', '1.4.99'),
(19, 'ProfileModule', 2, 'Profile', 'profile', 'Provides a personal account control panel for each registered user, an interface to administer the personal information items displayed within it, and a registered users list functionality. Works in close unison with the ''Users'' module.', 'ProfileModule', '2.0.0', 'a:3:{s:7:"profile";a:1:{s:7:"version";s:3:"1.0";}s:5:"admin";a:1:{s:7:"version";s:3:"1.0";}s:4:"user";a:1:{s:7:"version";s:3:"1.0";}}', 3, 'a:6:{s:9:"Profile::";s:2:"::";s:13:"Profile::view";s:2:"::";s:13:"Profile::item";s:56:"DynamicUserData PropertyName::DynamicUserData PropertyID";s:16:"Profile:Members:";s:2:"::";s:22:"Profile:Members:recent";s:2:"::";s:22:"Profile:Members:online";s:2:"::";}', '1.4.0', '1.4.99');
-- --------------------------------------------------------
--
-- Table structure for table `module_deps`
--
DROP TABLE IF EXISTS `module_deps`;
CREATE TABLE IF NOT EXISTS `module_deps` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`modid` int(11) NOT NULL,
`modname` varchar(64) NOT NULL,
`minversion` varchar(10) NOT NULL,
`maxversion` varchar(10) NOT NULL,
`status` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
-- --------------------------------------------------------
--
-- Table structure for table `module_vars`
--
DROP TABLE IF EXISTS `module_vars`;
CREATE TABLE IF NOT EXISTS `module_vars` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`modname` varchar(64) NOT NULL,
`name` varchar(64) NOT NULL,
`value` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=229 ;
--
-- Dumping data for table `module_vars`
--
INSERT INTO `module_vars` (`id`, `modname`, `name`, `value`) VALUES
(1, '/EventHandlers', 'Extensions', 'a:2:{i:0;a:3:{s:9:"eventname";s:27:"controller.method_not_found";s:8:"callable";a:2:{i:0;s:23:"ExtensionsModule\\HookUI";i:1;s:5:"hooks";}s:6:"weight";i:10;}i:1;a:3:{s:9:"eventname";s:27:"controller.method_not_found";s:8:"callable";a:2:{i:0;s:23:"ExtensionsModule\\HookUI";i:1;s:14:"moduleservices";}s:6:"weight";i:10;}}'),
(2, 'ExtensionsModule', 'itemsperpage', 'i:25;'),
(3, 'ZConfig', 'debug', 's:1:"0";'),
(4, 'ZConfig', 'sitename', 's:9:"Site name";'),
(5, 'ZConfig', 'slogan', 's:16:"Site description";'),
(6, 'ZConfig', 'metakeywords', 's:237:"zikula, portal, portal web, open source, web site, website, weblog, blog, content management, content management system, web content management, web content management system, enterprise web content management, cms, application framework";'),
(7, 'ZConfig', 'defaultpagetitle', 's:9:"Site name";'),
(8, 'ZConfig', 'defaultmetadescription', 's:16:"Site description";'),
(9, 'ZConfig', 'startdate', 's:7:"04/2012";'),
(10, 'ZConfig', 'adminmail', 's:15:"drak@zikula.org";'),
(11, 'ZConfig', 'Default_Theme', 's:14:"Andreas08Theme";'),
(12, 'ZConfig', 'timezone_offset', 's:1:"0";'),
(13, 'ZConfig', 'timezone_server', 's:1:"0";'),
(14, 'ZConfig', 'funtext', 's:1:"1";'),
(15, 'ZConfig', 'reportlevel', 's:1:"0";'),
(16, 'ZConfig', 'startpage', 's:0:"";'),
(17, 'ZConfig', 'Version_Num', 's:9:"1.4.0-dev";'),
(18, 'ZConfig', 'Version_ID', 's:6:"Zikula";'),
(19, 'ZConfig', 'Version_Sub', 's:6:"urmila";'),
(20, 'ZConfig', 'debug_sql', 's:1:"0";'),
(21, 'ZConfig', 'multilingual', 's:1:"1";'),
(22, 'ZConfig', 'useflags', 's:1:"0";'),
(23, 'ZConfig', 'theme_change', 's:1:"0";'),
(24, 'ZConfig', 'UseCompression', 's:1:"0";'),
(25, 'ZConfig', 'siteoff', 'i:0;'),
(26, 'ZConfig', 'siteoffreason', 's:0:"";'),
(27, 'ZConfig', 'starttype', 's:0:"";'),
(28, 'ZConfig', 'startfunc', 's:0:"";'),
(29, 'ZConfig', 'startargs', 's:0:"";'),
(30, 'ZConfig', 'entrypoint', 's:9:"index.php";'),
(31, 'ZConfig', 'language_detect', 'i:0;'),
(32, 'ZConfig', 'shorturls', 'b:0;'),
(33, 'ZConfig', 'shorturlstype', 's:1:"0";'),
(34, 'ZConfig', 'shorturlsseparator', 's:1:"-";'),
(35, 'ZConfig', 'shorturlsstripentrypoint', 'b:0;'),
(36, 'ZConfig', 'shorturlsdefaultmodule', 's:0:"";'),
(37, 'ZConfig', 'profilemodule', 's:0:"";'),
(38, 'ZConfig', 'messagemodule', 's:0:"";'),
(39, 'ZConfig', 'languageurl', 'i:0;'),
(40, 'ZConfig', 'ajaxtimeout', 'i:5000;'),
(41, 'ZConfig', 'permasearch', 's:161:"À,Á,Â,Ã,Å,à,á,â,ã,å,Ò,Ó,Ô,Õ,Ø,ò,ó,ô,õ,ø,È,É,Ê,Ë,è,é,ê,ë,Ç,ç,Ì,Í,Î,Ï,ì,í,î,ï,Ù,Ú,Û,ù,ú,û,ÿ,Ñ,ñ,ß,ä,Ä,ö,Ö,ü,Ü";'),
(42, 'ZConfig', 'permareplace', 's:114:"A,A,A,A,A,a,a,a,a,a,O,O,O,O,O,o,o,o,o,o,E,E,E,E,e,e,e,e,C,c,I,I,I,I,i,i,i,i,U,U,U,u,u,u,y,N,n,ss,ae,Ae,oe,Oe,ue,Ue";'),
(43, 'ZConfig', 'language', 's:3:"eng";'),
(44, 'ZConfig', 'locale', 's:2:"en";'),
(45, 'ZConfig', 'language_i18n', 's:2:"en";'),
(46, 'ZConfig', 'idnnames', 'i:1;'),
(47, 'ThemeModule', 'modulesnocache', 's:0:"";'),
(48, 'ThemeModule', 'enablecache', 'b:0;'),
(49, 'ThemeModule', 'compile_check', 'b:1;'),
(50, 'ThemeModule', 'cache_lifetime', 'i:1800;'),
(51, 'ThemeModule', 'cache_lifetime_mods', 'i:1800;'),
(52, 'ThemeModule', 'force_compile', 'b:0;'),
(53, 'ThemeModule', 'trimwhitespace', 'b:0;'),
(54, 'ThemeModule', 'maxsizeforlinks', 'i:30;'),
(55, 'ThemeModule', 'itemsperpage', 'i:25;'),
(56, 'ThemeModule', 'cssjscombine', 'b:0;'),
(57, 'ThemeModule', 'cssjscompress', 'b:0;'),
(58, 'ThemeModule', 'cssjsminify', 'b:0;'),
(59, 'ThemeModule', 'cssjscombine_lifetime', 'i:3600;'),
(60, 'ThemeModule', 'render_compile_check', 'b:1;'),
(61, 'ThemeModule', 'render_force_compile', 'b:1;'),
(62, 'ThemeModule', 'render_cache', 'b:0;'),
(63, 'ThemeModule', 'render_expose_template', 'b:0;'),
(64, 'ThemeModule', 'render_lifetime', 'i:3600;'),
(65, 'AdminModule', 'modulesperrow', 'i:3;'),
(66, 'AdminModule', 'itemsperpage', 'i:15;'),
(67, 'AdminModule', 'defaultcategory', 'i:5;'),
(68, 'AdminModule', 'admingraphic', 'i:1;'),
(69, 'AdminModule', 'startcategory', 'i:1;'),
(70, 'AdminModule', 'ignoreinstallercheck', 'i:0;'),
(71, 'AdminModule', 'admintheme', 's:0:"";'),
(72, 'AdminModule', 'displaynametype', 'i:1;'),
(73, 'PermissionsModule', 'filter', 'i:1;'),
(74, 'PermissionsModule', 'warnbar', 'i:1;'),
(75, 'PermissionsModule', 'rowview', 'i:20;'),
(76, 'PermissionsModule', 'rowedit', 'i:20;'),
(77, 'PermissionsModule', 'lockadmin', 'i:1;'),
(78, 'PermissionsModule', 'adminid', 'i:1;'),
(79, 'GroupsModule', 'itemsperpage', 'i:25;'),
(80, 'GroupsModule', 'defaultgroup', 'i:1;'),
(81, 'GroupsModule', 'mailwarning', 'i:0;'),
(82, 'GroupsModule', 'hideclosed', 'i:0;'),
(83, 'GroupsModule', 'primaryadmingroup', 'i:2;'),
(84, 'BlocksModule', 'collapseable', 'i:0;'),
(85, 'UsersModule', 'accountdisplaygraphics', 'b:1;'),
(86, 'UsersModule', 'accountitemsperpage', 'i:25;'),
(87, 'UsersModule', 'accountitemsperrow', 'i:5;'),
(88, 'UsersModule', 'userimg', 's:11:"images/menu";'),
(89, 'UsersModule', 'anonymous', 's:5:"Guest";'),
(90, 'UsersModule', 'avatarpath', 's:13:"images/avatar";'),
(91, 'UsersModule', 'chgemail_expiredays', 'i:0;'),
(92, 'UsersModule', 'chgpass_expiredays', 'i:0;'),
(93, 'UsersModule', 'reg_expiredays', 'i:0;'),
(94, 'UsersModule', 'allowgravatars', 'b:1;'),
(95, 'UsersModule', 'gravatarimage', 's:12:"gravatar.gif";'),
(96, 'UsersModule', 'hash_method', 's:6:"sha256";'),
(97, 'UsersModule', 'itemsperpage', 'i:25;'),
(98, 'UsersModule', 'login_displayapproval', 'b:0;'),
(99, 'UsersModule', 'login_displaydelete', 'b:0;'),
(100, 'UsersModule', 'login_displayinactive', 'b:0;'),
(101, 'UsersModule', 'login_displayverify', 'b:0;'),
(102, 'UsersModule', 'loginviaoption', 'i:0;'),
(103, 'UsersModule', 'login_redirect', 'b:1;'),
(104, 'UsersModule', 'changeemail', 'b:1;'),
(105, 'UsersModule', 'minpass', 'i:5;'),
(106, 'UsersModule', 'use_password_strength_meter', 'b:0;'),
(107, 'UsersModule', 'reg_notifyemail', 's:0:"";'),
(108, 'UsersModule', 'reg_question', 's:0:"";'),
(109, 'UsersModule', 'reg_answer', 's:0:"";'),
(110, 'UsersModule', 'moderation', 'b:0;'),
(111, 'UsersModule', 'moderation_order', 'i:0;'),
(112, 'UsersModule', 'reg_autologin', 'b:0;'),
(113, 'UsersModule', 'reg_noregreasons', 's:51:"Sorry! New user registration is currently disabled.";'),
(114, 'UsersModule', 'reg_allowreg', 'b:1;'),
(115, 'UsersModule', 'reg_Illegaluseragents', 's:0:"";'),
(116, 'UsersModule', 'reg_Illegaldomains', 's:0:"";'),
(117, 'UsersModule', 'reg_Illegalusername', 's:66:"root, webmaster, admin, administrator, nobody, anonymous, username";'),
(118, 'UsersModule', 'reg_verifyemail', 'i:2;'),
(119, 'UsersModule', 'reg_uniemail', 'b:1;'),
(120, '/EventHandlers', 'Users', 'a:4:{i:0;a:3:{s:9:"eventname";s:19:"get.pending_content";s:8:"callable";a:2:{i:0;s:43:"UsersModule\\Listener\\PendingContentListener";i:1;s:22:"pendingContentListener";}s:6:"weight";i:10;}i:1;a:3:{s:9:"eventname";s:15:"user.login.veto";s:8:"callable";a:2:{i:0;s:49:"UsersModule\\Listener\\ForcedPasswordChangeListener";i:1;s:28:"forcedPasswordChangeListener";}s:6:"weight";i:10;}i:2;a:3:{s:9:"eventname";s:21:"user.logout.succeeded";s:8:"callable";a:2:{i:0;s:48:"UsersModule\\Listener\\ClearUsersNamespaceListener";i:1;s:27:"clearUsersNamespaceListener";}s:6:"weight";i:10;}i:3;a:3:{s:9:"eventname";s:25:"frontcontroller.exception";s:8:"callable";a:2:{i:0;s:48:"UsersModule\\Listener\\ClearUsersNamespaceListener";i:1;s:27:"clearUsersNamespaceListener";}s:6:"weight";i:10;}}'),
(121, 'SecurityCenterModule', 'itemsperpage', 'i:10;'),
(122, 'ZConfig', 'updatecheck', 'i:1;'),
(123, 'ZConfig', 'updatefrequency', 'i:7;'),
(124, 'ZConfig', 'updatelastchecked', 'i:1336997630;'),
(125, 'ZConfig', 'updateversion', 's:5:"1.3.3";'),
(126, 'ZConfig', 'keyexpiry', 'i:0;'),
(127, 'ZConfig', 'sessionauthkeyua', 'b:0;'),
(128, 'ZConfig', 'secure_domain', 's:0:"";'),
(129, 'ZConfig', 'signcookies', 'i:1;'),
(130, 'ZConfig', 'signingkey', 's:40:"b60e87875fbba804e6207bdd5eeba9fb22831a80";'),
(131, 'ZConfig', 'seclevel', 's:6:"Medium";'),
(132, 'ZConfig', 'secmeddays', 'i:7;'),
(133, 'ZConfig', 'secinactivemins', 'i:20;'),
(134, 'ZConfig', 'sessionstoretofile', 'i:0;'),
(135, 'ZConfig', 'sessionsavepath', 's:0:"";'),
(136, 'ZConfig', 'gc_probability', 'i:100;'),
(137, 'ZConfig', 'anonymoussessions', 'i:1;'),
(138, 'ZConfig', 'sessionrandregenerate', 'b:1;'),
(139, 'ZConfig', 'sessionregenerate', 'b:1;'),
(140, 'ZConfig', 'sessionregeneratefreq', 'i:10;'),
(141, 'ZConfig', 'sessionipcheck', 'i:0;'),
(142, 'ZConfig', 'sessionname', 's:5:"_zsid";'),
(143, 'ZConfig', 'sessioncsrftokenonetime', 'i:0;'),
(144, 'ZConfig', 'filtergetvars', 'i:1;'),
(145, 'ZConfig', 'filterpostvars', 'i:1;'),
(146, 'ZConfig', 'filtercookievars', 'i:1;'),
(147, 'ZConfig', 'outputfilter', 'i:1;'),
(148, 'ZConfig', 'htmlpurifierlocation', 's:46:"system/SecurityCenter/lib/vendor/htmlpurifier/";'),
(149, 'SecurityCenterModule', 'htmlpurifierConfig', 's:3942:"a:10:{s:4:"Attr";a:15:{s:14:"AllowedClasses";N;s:19:"AllowedFrameTargets";a:0:{}s:10:"AllowedRel";a:3:{s:8:"nofollow";b:1;s:11:"imageviewer";b:1;s:8:"lightbox";b:1;}s:10:"AllowedRev";a:0:{}s:13:"ClassUseCDATA";N;s:15:"DefaultImageAlt";N;s:19:"DefaultInvalidImage";s:0:"";s:22:"DefaultInvalidImageAlt";s:13:"Invalid image";s:14:"DefaultTextDir";s:3:"ltr";s:8:"EnableID";b:0;s:16:"ForbiddenClasses";a:0:{}s:11:"IDBlacklist";a:0:{}s:17:"IDBlacklistRegexp";N;s:8:"IDPrefix";s:0:"";s:13:"IDPrefixLocal";s:0:"";}s:10:"AutoFormat";a:10:{s:13:"AutoParagraph";b:0;s:6:"Custom";a:0:{}s:14:"DisplayLinkURI";b:0;s:7:"Linkify";b:0;s:22:"PurifierLinkify.DocURL";s:3:"#%s";s:15:"PurifierLinkify";b:0;s:33:"RemoveEmpty.RemoveNbsp.Exceptions";a:2:{s:2:"td";b:1;s:2:"th";b:1;}s:22:"RemoveEmpty.RemoveNbsp";b:0;s:11:"RemoveEmpty";b:0;s:28:"RemoveSpansWithoutAttributes";b:0;}s:3:"CSS";a:9:{s:14:"AllowImportant";b:0;s:11:"AllowTricky";b:0;s:12:"AllowedFonts";N;s:17:"AllowedProperties";N;s:13:"DefinitionRev";i:1;s:19:"ForbiddenProperties";a:0:{}s:12:"MaxImgLength";s:6:"1200px";s:11:"Proprietary";b:0;s:7:"Trusted";b:0;}s:5:"Cache";a:3:{s:14:"DefinitionImpl";s:10:"Serializer";s:14:"SerializerPath";N;s:21:"SerializerPermissions";i:493;}s:4:"Core";a:17:{s:17:"AggressivelyFixLt";b:1;s:13:"CollectErrors";b:0;s:13:"ColorKeywords";a:17:{s:6:"maroon";s:7:"#800000";s:3:"red";s:7:"#FF0000";s:6:"orange";s:7:"#FFA500";s:6:"yellow";s:7:"#FFFF00";s:5:"olive";s:7:"#808000";s:6:"purple";s:7:"#800080";s:7:"fuchsia";s:7:"#FF00FF";s:5:"white";s:7:"#FFFFFF";s:4:"lime";s:7:"#00FF00";s:5:"green";s:7:"#008000";s:4:"navy";s:7:"#000080";s:4:"blue";s:7:"#0000FF";s:4:"aqua";s:7:"#00FFFF";s:4:"teal";s:7:"#008080";s:5:"black";s:7:"#000000";s:6:"silver";s:7:"#C0C0C0";s:4:"gray";s:7:"#808080";}s:25:"ConvertDocumentToFragment";b:1;s:31:"DirectLexLineNumberSyncInterval";i:0;s:8:"Encoding";s:5:"utf-8";s:21:"EscapeInvalidChildren";b:0;s:17:"EscapeInvalidTags";b:0;s:24:"EscapeNonASCIICharacters";b:0;s:14:"HiddenElements";a:2:{s:6:"script";b:1;s:5:"style";b:1;}s:8:"Language";s:2:"en";s:9:"LexerImpl";N;s:19:"MaintainLineNumbers";N;s:17:"NormalizeNewlines";b:1;s:16:"RemoveInvalidImg";b:1;s:28:"RemoveProcessingInstructions";b:0;s:20:"RemoveScriptContents";N;}s:6:"Filter";a:6:{s:6:"Custom";a:0:{}s:27:"ExtractStyleBlocks.Escaping";b:1;s:24:"ExtractStyleBlocks.Scope";N;s:27:"ExtractStyleBlocks.TidyImpl";N;s:18:"ExtractStyleBlocks";b:0;s:7:"YouTube";b:0;}s:4:"HTML";a:26:{s:7:"Allowed";N;s:17:"AllowedAttributes";N;s:15:"AllowedElements";N;s:14:"AllowedModules";N;s:18:"Attr.Name.UseCDATA";b:0;s:12:"BlockWrapper";s:1:"p";s:11:"CoreModules";a:7:{s:9:"Structure";b:1;s:4:"Text";b:1;s:9:"Hypertext";b:1;s:4:"List";b:1;s:22:"NonXMLCommonAttributes";b:1;s:19:"XMLCommonAttributes";b:1;s:16:"CommonAttributes";b:1;}s:13:"CustomDoctype";N;s:12:"DefinitionID";N;s:13:"DefinitionRev";i:1;s:7:"Doctype";s:22:"HTML 4.01 Transitional";s:20:"FlashAllowFullScreen";b:0;s:19:"ForbiddenAttributes";a:0:{}s:17:"ForbiddenElements";a:0:{}s:12:"MaxImgLength";i:1200;s:8:"Nofollow";b:0;s:6:"Parent";s:3:"div";s:11:"Proprietary";b:0;s:9:"SafeEmbed";b:1;s:10:"SafeObject";b:1;s:6:"Strict";b:0;s:7:"TidyAdd";a:0:{}s:9:"TidyLevel";s:6:"medium";s:10:"TidyRemove";a:0:{}s:7:"Trusted";b:0;s:5:"XHTML";b:1;}s:6:"Output";a:6:{s:21:"CommentScriptContents";b:1;s:12:"FixInnerHTML";b:1;s:11:"FlashCompat";b:1;s:7:"Newline";N;s:8:"SortAttr";b:0;s:10:"TidyFormat";b:0;}s:4:"Test";a:1:{s:12:"ForceNoIconv";b:0;}s:3:"URI";a:16:{s:14:"AllowedSchemes";a:6:{s:4:"http";b:1;s:5:"https";b:1;s:6:"mailto";b:1;s:3:"ftp";b:1;s:4:"nntp";b:1;s:4:"news";b:1;}s:4:"Base";N;s:13:"DefaultScheme";s:4:"http";s:12:"DefinitionID";N;s:13:"DefinitionRev";i:1;s:7:"Disable";b:0;s:15:"DisableExternal";b:0;s:24:"DisableExternalResources";b:0;s:16:"DisableResources";b:0;s:4:"Host";N;s:13:"HostBlacklist";a:0:{}s:12:"MakeAbsolute";b:0;s:5:"Munge";N;s:14:"MungeResources";b:0;s:14:"MungeSecretKey";N;s:22:"OverrideAllowedSchemes";b:1;}}";'),
(150, 'ZConfig', 'useids', 'i:0;'),
(151, 'ZConfig', 'idsmail', 'i:0;'),
(152, 'ZConfig', 'idsrulepath', 's:32:"config/phpids_zikula_default.xml";'),
(153, 'ZConfig', 'idssoftblock', 'i:1;'),
(154, 'ZConfig', 'idsfilter', 's:3:"xml";'),
(155, 'ZConfig', 'idsimpactthresholdone', 'i:1;'),
(156, 'ZConfig', 'idsimpactthresholdtwo', 'i:10;'),
(157, 'ZConfig', 'idsimpactthresholdthree', 'i:25;'),
(158, 'ZConfig', 'idsimpactthresholdfour', 'i:75;'),
(159, 'ZConfig', 'idsimpactmode', 'i:1;'),
(160, 'ZConfig', 'idshtmlfields', 'a:1:{i:0;s:14:"POST.__wysiwyg";}'),
(161, 'ZConfig', 'idsjsonfields', 'a:1:{i:0;s:15:"POST.__jsondata";}'),
(162, 'ZConfig', 'idsexceptions', 'a:12:{i:0;s:10:"GET.__utmz";i:1;s:10:"GET.__utmc";i:2;s:18:"REQUEST.linksorder";i:3;s:15:"POST.linksorder";i:4;s:19:"REQUEST.fullcontent";i:5;s:16:"POST.fullcontent";i:6;s:22:"REQUEST.summarycontent";i:7;s:19:"POST.summarycontent";i:8;s:19:"REQUEST.filter.page";i:9;s:16:"POST.filter.page";i:10;s:20:"REQUEST.filter.value";i:11;s:17:"POST.filter.value";}'),
(163, 'ZConfig', 'summarycontent', 's:1155:"For the attention of %sitename% administration staff:\r\n\r\nOn %date% at %time%, Zikula detected that somebody tried to interact with the site in a way that may have been intended compromise its security. This is not necessarily the case: it could have been caused by work you were doing on the site, or may have been due to some other reason. In any case, it was detected and blocked. \r\n\r\nThe suspicious activity was recognised in ''%filename%'' at line %linenumber%.\r\n\r\nType: %type%. \r\n\r\nAdditional information: %additionalinfo%.\r\n\r\nBelow is logged information that may help you identify what happened and who was responsible.\r\n\r\n=====================================\r\nInformation about the user:\r\n=====================================\r\nUser name: %username%\r\nUser''s e-mail address: %useremail%\r\nUser''s real name: %userrealname%\r\n\r\n=====================================\r\nIP numbers (if this was a cracker, the IP numbers may not be the true point of origin)\r\n=====================================\r\nIP according to HTTP_CLIENT_IP: %httpclientip%\r\nIP according to REMOTE_ADDR: %remoteaddr%\r\nIP according to GetHostByName($REMOTE_ADDR): %gethostbyremoteaddr%\r\n";'),
(164, 'ZConfig', 'fullcontent', 's:1336:"=====================================\r\nInformation in the $_REQUEST array\r\n=====================================\r\n%requestarray%\r\n\r\n=====================================\r\nInformation in the $_GET array\r\n(variables that may have been in the URL string or in a ''GET''-type form)\r\n=====================================\r\n%getarray%\r\n\r\n=====================================\r\nInformation in the $_POST array\r\n(visible and invisible form elements)\r\n=====================================\r\n%postarray%\r\n\r\n=====================================\r\nBrowser information\r\n=====================================\r\n%browserinfo%\r\n\r\n=====================================\r\nInformation in the $_SERVER array\r\n=====================================\r\n%serverarray%\r\n\r\n=====================================\r\nInformation in the $_ENV array\r\n=====================================\r\n%envarray%\r\n\r\n=====================================\r\nInformation in the $_COOKIE array\r\n=====================================\r\n%cookiearray%\r\n\r\n=====================================\r\nInformation in the $_FILES array\r\n=====================================\r\n%filearray%\r\n\r\n=====================================\r\nInformation in the $_SESSION array\r\n(session information -- variables starting with PNSV are Zikula session variables)\r\n=====================================\r\n%sessionarray%\r\n";'),
(165, 'ZConfig', 'usehtaccessbans', 'i:0;'),
(166, 'ZConfig', 'extrapostprotection', 'i:0;'),
(167, 'ZConfig', 'extragetprotection', 'i:0;'),
(168, 'ZConfig', 'checkmultipost', 'i:0;'),
(169, 'ZConfig', 'maxmultipost', 'i:4;'),
(170, 'ZConfig', 'cpuloadmonitor', 'i:0;'),
(171, 'ZConfig', 'cpumaxload', 'd:10;'),
(172, 'ZConfig', 'ccisessionpath', 's:0:"";'),
(173, 'ZConfig', 'htaccessfilelocation', 's:9:".htaccess";'),
(174, 'ZConfig', 'nocookiebanthreshold', 'i:10;'),
(175, 'ZConfig', 'nocookiewarningthreshold', 'i:2;'),
(176, 'ZConfig', 'fastaccessbanthreshold', 'i:40;'),
(177, 'ZConfig', 'fastaccesswarnthreshold', 'i:10;'),
(178, 'ZConfig', 'javababble', 'i:0;'),
(179, 'ZConfig', 'javaencrypt', 'i:0;'),
(180, 'ZConfig', 'preservehead', 'i:0;'),
(181, 'ZConfig', 'filterarrays', 'i:1;'),
(182, 'ZConfig', 'htmlentities', 's:1:"1";'),
(183, 'ZConfig', 'AllowableHTML', 'a:110:{s:3:"!--";i:2;s:1:"a";i:2;s:4:"abbr";i:1;s:7:"acronym";i:1;s:7:"address";i:1;s:6:"applet";i:0;s:4:"area";i:0;s:7:"article";i:1;s:5:"aside";i:1;s:5:"audio";i:0;s:1:"b";i:1;s:4:"base";i:0;s:8:"basefont";i:0;s:3:"bdo";i:0;s:3:"big";i:0;s:10:"blockquote";i:2;s:2:"br";i:2;s:6:"button";i:0;s:6:"canvas";i:0;s:7:"caption";i:1;s:6:"center";i:2;s:4:"cite";i:1;s:4:"code";i:0;s:3:"col";i:1;s:8:"colgroup";i:1;s:7:"command";i:0;s:8:"datalist";i:0;s:2:"dd";i:1;s:3:"del";i:0;s:7:"details";i:1;s:3:"dfn";i:0;s:3:"dir";i:0;s:3:"div";i:2;s:2:"dl";i:1;s:2:"dt";i:1;s:2:"em";i:2;s:5:"embed";i:0;s:8:"fieldset";i:1;s:10:"figcaption";i:0;s:6:"figure";i:0;s:6:"footer";i:0;s:4:"font";i:0;s:4:"form";i:0;s:2:"h1";i:1;s:2:"h2";i:1;s:2:"h3";i:1;s:2:"h4";i:1;s:2:"h5";i:1;s:2:"h6";i:1;s:6:"header";i:0;s:6:"hgroup";i:0;s:2:"hr";i:2;s:1:"i";i:1;s:6:"iframe";i:0;s:3:"img";i:2;s:5:"input";i:0;s:3:"ins";i:0;s:6:"keygen";i:0;s:3:"kbd";i:0;s:5:"label";i:1;s:6:"legend";i:1;s:2:"li";i:2;s:3:"map";i:0;s:4:"mark";i:0;s:4:"menu";i:0;s:7:"marquee";i:0;s:5:"meter";i:0;s:3:"nav";i:0;s:4:"nobr";i:0;s:6:"object";i:0;s:2:"ol";i:2;s:8:"optgroup";i:0;s:6:"option";i:0;s:6:"output";i:0;s:1:"p";i:2;s:5:"param";i:0;s:3:"pre";i:2;s:8:"progress";i:0;s:1:"q";i:0;s:2:"rp";i:0;s:2:"rt";i:0;s:4:"ruby";i:0;s:1:"s";i:0;s:4:"samp";i:0;s:6:"script";i:0;s:7:"section";i:0;s:6:"select";i:0;s:5:"small";i:0;s:6:"source";i:0;s:4:"span";i:2;s:6:"strike";i:0;s:6:"strong";i:2;s:3:"sub";i:1;s:7:"summary";i:1;s:3:"sup";i:0;s:5:"table";i:2;s:5:"tbody";i:1;s:2:"td";i:2;s:8:"textarea";i:0;s:5:"tfoot";i:1;s:2:"th";i:2;s:5:"thead";i:0;s:4:"time";i:0;s:2:"tr";i:2;s:2:"tt";i:2;s:1:"u";i:0;s:2:"ul";i:2;s:3:"var";i:0;s:5:"video";i:0;s:3:"wbr";i:0;}'),
(184, 'CategoriesModule', 'userrootcat', 's:17:"/__SYSTEM__/Users";'),
(185, 'CategoriesModule', 'allowusercatedit', 'i:0;'),
(186, 'CategoriesModule', 'autocreateusercat', 'i:0;'),
(187, 'CategoriesModule', 'autocreateuserdefaultcat', 'i:0;'),
(188, 'CategoriesModule', 'userdefaultcatname', 's:7:"Default";'),
(189, 'LegalModule', 'legalNoticeActive', 'b:1;'),
(190, 'LegalModule', 'termsOfUseActive', 'b:1;'),
(191, 'LegalModule', 'privacyPolicyActive', 'b:1;'),
(192, 'LegalModule', 'accessibilityStatementActive', 'b:1;'),
(193, 'LegalModule', 'cancellationRightPolicyActive', 'b:0;'),
(194, 'LegalModule', 'tradeConditionsActive', 'b:0;'),
(195, 'LegalModule', 'legalNoticeUrl', 's:0:"";'),
(196, 'LegalModule', 'termsOfUseUrl', 's:0:"";'),
(197, 'LegalModule', 'privacyPolicyUrl', 's:0:"";'),
(198, 'LegalModule', 'accessibilityStatementUrl', 's:0:"";'),
(199, 'LegalModule', 'cancellationRightPolicyUrl', 's:0:"";'),
(200, 'LegalModule', 'tradeConditionsUrl', 's:0:"";'),
(201, 'LegalModule', 'minimumAge', 'i:13;'),
(203, 'Mailer', 'mailertype', 'i:1;'),
(204, 'Mailer', 'charset', 's:5:"utf-8";'),
(205, 'Mailer', 'encoding', 's:4:"8bit";'),
(206, 'Mailer', 'html', 'b:0;'),
(207, 'Mailer', 'wordwrap', 'i:50;'),
(208, 'Mailer', 'msmailheaders', 'b:0;'),
(209, 'Mailer', 'sendmailpath', 's:18:"/usr/sbin/sendmail";'),
(210, 'Mailer', 'smtpauth', 'b:0;'),
(211, 'Mailer', 'smtpserver', 's:9:"localhost";'),
(212, 'Mailer', 'smtpport', 'i:25;'),
(213, 'Mailer', 'smtptimeout', 'i:10;'),
(214, 'Mailer', 'smtpusername', 's:0:"";'),
(215, 'Mailer', 'smtppassword', 's:0:"";'),
(216, 'Mailer', 'smtpsecuremethod', 's:3:"ssl";'),
(217, 'Search', 'itemsperpage', 'i:10;'),
(218, 'Search', 'limitsummary', 'i:255;'),
(219, '/EventHandlers', 'Search', 'a:1:{i:0;a:3:{s:9:"eventname";s:26:"installer.module.installed";s:8:"callable";a:2:{i:0;s:35:"SearchModule\\Listener\\EventListener";i:1;s:13:"moduleInstall";}s:6:"weight";i:10;}}'),
(221, 'ProfileModule', 'memberslistitemsperpage', 'i:20;'),
(222, 'ProfileModule', 'onlinemembersitemsperpage', 'i:20;'),
(223, 'ProfileModule', 'recentmembersitemsperpage', 'i:10;'),
(224, 'ProfileModule', 'filterunverified', 'i:1;'),
(225, 'ProfileModule', 'dudregshow', 'a:5:{i:0;i:1;i:1;i:3;i:2;i:4;i:3;i:10;i:4;i:11;}');
-- --------------------------------------------------------
--
-- Table structure for table `pagelock`
--
DROP TABLE IF EXISTS `pagelock`;
CREATE TABLE IF NOT EXISTS `pagelock` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`cdate` datetime NOT NULL,
`edate` datetime NOT NULL,
`session` varchar(50) NOT NULL,
`title` varchar(100) NOT NULL,
`ipno` varchar(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `sc_intrusion`
--
DROP TABLE IF EXISTS `sc_intrusion`;
CREATE TABLE IF NOT EXISTS `sc_intrusion` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(128) NOT NULL,
`tag` varchar(40) DEFAULT NULL,
`value` longtext NOT NULL,
`page` longtext NOT NULL,
`uid` int(11) DEFAULT NULL,
`ip` varchar(40) NOT NULL,
`impact` int(11) NOT NULL DEFAULT '0',
`filters` longtext NOT NULL,
`date` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `search_result`
--
DROP TABLE IF EXISTS `search_result`;
CREATE TABLE IF NOT EXISTS `search_result` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`text` longtext,
`module` varchar(100) DEFAULT NULL,
`extra` varchar(100) DEFAULT NULL,
`created` datetime DEFAULT NULL,
`found` datetime DEFAULT NULL,
`sesid` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `title` (`title`),
KEY `module` (`module`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `search_stat`
--
DROP TABLE IF EXISTS `search_stat`;
CREATE TABLE IF NOT EXISTS `search_stat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`search` varchar(50) NOT NULL,
`scount` int(11) NOT NULL DEFAULT '0',
`date` date DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `search_stat`
--
INSERT INTO `search_stat` (`id`, `search`, `scount`, `date`) VALUES
(1, 'dfgdfg', 1, '2012-04-16'),
(2, 'Search keywords', 1, '2012-04-18');
-- --------------------------------------------------------
--
-- Table structure for table `session_info`
--
DROP TABLE IF EXISTS `session_info`;
CREATE TABLE IF NOT EXISTS `session_info` (
`sessid` varchar(40) NOT NULL,
`ipaddr` varchar(32) NOT NULL,
`lastused` datetime DEFAULT '1970-01-01 00:00:00',
`uid` int(11) DEFAULT '0',
`remember` tinyint(4) NOT NULL DEFAULT '0',
`vars` longtext NOT NULL,
PRIMARY KEY (`sessid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `session_info`
--
INSERT INTO `session_info` (`sessid`, `ipaddr`, `lastused`, `uid`, `remember`, `vars`) VALUES
('8furfefgni18g9bq17r71i7lb3ikd9mc', '837ec5754f503cfaaee0929fd48974e7', '2012-04-15 13:07:17', 2, 1, '_sf2_attributes|a:5:{s:3:"uid";s:1:"2";s:10:"rememberme";i:1;s:9:"useragent";s:40:"f3344a2f025d5337868c3f62da839797b75b1f3a";s:7:"_tokens";a:1:{s:23:"4f8aa8eb51bea2.37295370";a:2:{s:5:"token";s:92:"NGY4YWE4ZWI1MWJlYTIuMzcyOTUzNzA6YjRlYWQ4ODllODRhMDU2NTdjZTY4NzUxZGJkMTAzNmU6MTMzNDQ4NzI3NQ==";s:4:"time";i:1334487275;}}s:27:"users/authentication_method";a:2:{s:7:"modname";s:5:"Users";s:6:"method";s:5:"uname";}}_sf2_flashes|a:0:{}_sf2_meta|a:3:{s:1:"u";i:1334488034;s:1:"c";i:1334487260;s:1:"l";s:6:"604800";}'),
('hn56d5bafjct0icskjtb81ksg6htcdsu', '837ec5754f503cfaaee0929fd48974e7', '2012-04-18 11:39:20', 2, 0, '_sf2_attributes|a:3:{s:3:"uid";s:1:"2";s:7:"_tokens";a:1:{s:23:"4f8e8b83f006b9.11116200";a:2:{s:5:"token";s:92:"NGY4ZThiODNmMDA2YjkuMTExMTYyMDA6OWM1YjA5MTAyZTE0ZTc5MGRmNzIxNGQ0OThjY2NhMGQ6MTMzNDc0MTg5MQ==";s:4:"time";i:1334741891;}}s:27:"users/authentication_method";a:2:{s:7:"modname";s:5:"Users";s:6:"method";s:5:"uname";}}_sf2_flashes|a:0:{}_sf2_meta|a:3:{s:1:"u";i:1334741959;s:1:"c";i:1334730791;s:1:"l";s:6:"604800";}');
-- --------------------------------------------------------
--
-- Table structure for table `themes`
--
DROP TABLE IF EXISTS `themes`;
CREATE TABLE IF NOT EXISTS `themes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(64) NOT NULL,
`type` smallint(6) NOT NULL,
`displayname` varchar(64) NOT NULL,
`description` varchar(255) NOT NULL,
`directory` varchar(64) NOT NULL,
`version` varchar(10) NOT NULL,
`contact` varchar(255) NOT NULL,
`admin` smallint(6) NOT NULL,
`user` smallint(6) NOT NULL,
`system` smallint(6) NOT NULL,
`state` smallint(6) NOT NULL,
`xhtml` smallint(6) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `themes`
--
INSERT INTO `themes` (`id`, `name`, `type`, `displayname`, `description`, `directory`, `version`, `contact`, `admin`, `user`, `system`, `state`, `xhtml`) VALUES
(1, 'Andreas08Theme', 3, 'Andreas08', 'Based on the theme Andreas08 by Andreas Viklund and extended for Zikula with the CSS Framework ''fluid960gs''.', 'Andreas08Theme', '2.0', '', 1, 1, 0, 1, 1),
(2, 'AtomTheme', 3, 'Atom', 'The Atom theme is an auxiliary theme specially designed for rendering pages in Atom mark-up.', 'AtomTheme', '1.0', '', 0, 0, 1, 1, 0),
(3, 'PrinterTheme', 3, 'Printer', 'The Printer theme is an auxiliary theme designed specially for outputting pages in a printer-friendly format.', 'PrinterTheme', '2.0', '', 0, 0, 1, 1, 1),
(4, 'RssTheme', 3, 'RSS', 'The RSS theme is an auxiliary theme designed specially for outputting pages as an RSS feed.', 'RssTheme', '1.0', '', 0, 0, 1, 1, 0),
(5, 'SeaBreezeTheme', 3, 'SeaBreeze', 'The SeaBreeze theme is a browser-oriented theme, and was updated for the release of Zikula 1.0, with revised colours and new graphics.', 'SeaBreezeTheme', '3.2', '', 0, 1, 0, 1, 1);
-- --------------------------------------------------------
--
-- Table structure for table `userblocks`
--
DROP TABLE IF EXISTS `userblocks`;
CREATE TABLE IF NOT EXISTS `userblocks` (
`uid` int(11) NOT NULL,
`bid` int(11) NOT NULL,
`active` int(11) NOT NULL,
`last_update` datetime NOT NULL,
PRIMARY KEY (`uid`,`bid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
`uid` int(11) NOT NULL AUTO_INCREMENT,
`uname` varchar(25) NOT NULL,
`email` varchar(60) NOT NULL,
`pass` varchar(138) NOT NULL,
`passreminder` varchar(255) NOT NULL,
`activated` smallint(6) NOT NULL DEFAULT '0',
`approved_date` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
`approved_by` int(11) NOT NULL DEFAULT '0',
`user_regdate` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
`lastlogin` datetime NOT NULL DEFAULT '1970-01-01 00:00:00',
`theme` varchar(255) NOT NULL,
`ublockon` tinyint(4) NOT NULL DEFAULT '0',
`ublock` longtext NOT NULL,
`tz` varchar(30) NOT NULL,
`locale` varchar(5) NOT NULL,
PRIMARY KEY (`uid`),
KEY `uname` (`uname`),
KEY `email` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`uid`, `uname`, `email`, `pass`, `passreminder`, `activated`, `approved_date`, `approved_by`, `user_regdate`, `lastlogin`, `theme`, `ublockon`, `ublock`, `tz`, `locale`) VALUES
(1, 'guest', '', '', '', 1, '1970-01-01 00:00:00', 0, '1970-01-01 00:00:00', '1970-01-01 00:00:00', '', 0, '', '', ''),
(2, 'admin', 'drak@zikula.org', '8$GLk02$698a73cc819a22f94267b34d48bb48015ca55efc3e9f8bc3a6dd2709ec24653d', '', 1, '2012-04-08 07:27:39', 2, '2012-04-08 07:27:55', '2012-05-16 02:57:46', '', 0, '', '', '');
-- --------------------------------------------------------
--
-- Table structure for table `users_attributes`
--
DROP TABLE IF EXISTS `users_attributes`;
CREATE TABLE IF NOT EXISTS `users_attributes` (
`user_id` int(11) NOT NULL,
`name` varchar(80) NOT NULL,
`value` longtext NOT NULL,
PRIMARY KEY (`user_id`,`name`),
KEY `IDX_E6F031E4A76ED395` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
--
-- Table structure for table `users_verifychg`
--
DROP TABLE IF EXISTS `users_verifychg`;
CREATE TABLE IF NOT EXISTS `users_verifychg` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`changetype` tinyint(4) NOT NULL DEFAULT '0',
`uid` int(11) NOT NULL DEFAULT '0',
`newemail` varchar(60) NOT NULL,
`verifycode` varchar(138) NOT NULL,
`created_dt` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `user_property`
--
DROP TABLE IF EXISTS `user_property`;
CREATE TABLE IF NOT EXISTS `user_property` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`label` varchar(255) NOT NULL,
`dtype` int(11) NOT NULL DEFAULT '0',
`modname` varchar(64) NOT NULL,
`weight` int(11) NOT NULL DEFAULT '0',
`validation` longtext,
`attributename` varchar(80) NOT NULL,
PRIMARY KEY (`id`),
KEY `prop_label` (`label`),
KEY `prop_attr` (`attributename`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
--
-- Dumping data for table `user_property`
--
INSERT INTO `user_property` (`id`, `label`, `dtype`, `modname`, `weight`, `validation`, `attributename`) VALUES
(1, '_UREALNAME', 1, '', 1, 'a:5:{s:8:"required";i:0;s:6:"viewby";i:0;s:11:"displaytype";i:0;s:11:"listoptions";s:0:"";s:4:"note";s:0:"";}', 'realname'),
(2, '_UFAKEMAIL', 1, '', 2, 'a:5:{s:8:"required";i:0;s:6:"viewby";i:0;s:11:"displaytype";i:0;s:11:"listoptions";s:0:"";s:4:"note";s:0:"";}', 'publicemail'),
(3, '_YOURHOMEPAGE', 1, '', 3, 'a:5:{s:8:"required";i:0;s:6:"viewby";i:0;s:11:"displaytype";i:0;s:11:"listoptions";s:0:"";s:4:"note";s:0:"";}', 'url'),
(4, '_TIMEZONEOFFSET', 1, '', 4, 'a:5:{s:8:"required";i:0;s:6:"viewby";i:0;s:11:"displaytype";i:4;s:11:"listoptions";s:0:"";s:4:"note";s:0:"";}', 'tzoffset'),
(5, '_YOURAVATAR', 1, '', 5, 'a:5:{s:8:"required";i:0;s:6:"viewby";i:0;s:11:"displaytype";i:4;s:11:"listoptions";s:0:"";s:4:"note";s:0:"";}', 'avatar'),
(6, '_YICQ', 1, '', 6, 'a:5:{s:8:"required";i:0;s:6:"viewby";i:0;s:11:"displaytype";i:0;s:11:"listoptions";s:0:"";s:4:"note";s:0:"";}', 'icq'),
(7, '_YAIM', 1, '', 7, 'a:5:{s:8:"required";i:0;s:6:"viewby";i:0;s:11:"displaytype";i:0;s:11:"listoptions";s:0:"";s:4:"note";s:0:"";}', 'aim'),
(8, '_YYIM', 1, '', 8, 'a:5:{s:8:"required";i:0;s:6:"viewby";i:0;s:11:"displaytype";i:0;s:11:"listoptions";s:0:"";s:4:"note";s:0:"";}', 'yim'),
(9, '_YMSNM', 1, '', 9, 'a:5:{s:8:"required";i:0;s:6:"viewby";i:0;s:11:"displaytype";i:0;s:11:"listoptions";s:0:"";s:4:"note";s:0:"";}', 'msnm'),
(10, '_YLOCATION', 1, '', 10, 'a:5:{s:8:"required";i:0;s:6:"viewby";i:0;s:11:"displaytype";i:0;s:11:"listoptions";s:0:"";s:4:"note";s:0:"";}', 'city'),
(11, '_YOCCUPATION', 1, '', 11, 'a:5:{s:8:"required";i:0;s:6:"viewby";i:0;s:11:"displaytype";i:0;s:11:"listoptions";s:0:"";s:4:"note";s:0:"";}', 'occupation'),
(12, '_SIGNATURE', 1, '', 12, 'a:5:{s:8:"required";i:0;s:6:"viewby";i:0;s:11:"displaytype";i:1;s:11:"listoptions";s:0:"";s:4:"note";s:0:"";}', 'signature'),
(13, '_EXTRAINFO', 1, '', 13, 'a:5:{s:8:"required";i:0;s:6:"viewby";i:0;s:11:"displaytype";i:1;s:11:"listoptions";s:0:"";s:4:"note";s:0:"";}', 'extrainfo'),
(14, '_YINTERESTS', 1, '', 14, 'a:5:{s:8:"required";i:0;s:6:"viewby";i:0;s:11:"displaytype";i:1;s:11:"listoptions";s:0:"";s:4:"note";s:0:"";}', 'interests');
-- --------------------------------------------------------
--
-- Table structure for table `workflows`
--
DROP TABLE IF EXISTS `workflows`;
CREATE TABLE IF NOT EXISTS `workflows` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`metaid` int(11) NOT NULL DEFAULT '0',
`module` varchar(255) NOT NULL,
`schemaname` varchar(255) NOT NULL,
`state` varchar(255) NOT NULL,
`type` smallint(6) NOT NULL DEFAULT '1',
`obj_table` varchar(40) NOT NULL,
`obj_idcolumn` varchar(40) NOT NULL,
`obj_id` int(11) NOT NULL DEFAULT '0',
`busy` int(11) NOT NULL DEFAULT '0',
`debug` longtext,
PRIMARY KEY (`id`),
KEY `obj_table` (`obj_table`),
KEY `obj_idcolumn` (`obj_idcolumn`),
KEY `obj_id` (`obj_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
/*!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 */;
Jump to Line
Something went wrong with that request. Please try again.