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 */;
-- --------------------------------------------------------
-- Table structure for table `AreaPermissionAssignments`
CREATE TABLE `AreaPermissionAssignments` (
`cID` int(10) unsigned NOT NULL DEFAULT '0',
`arHandle` varchar(255) NOT NULL,
`pkID` int(10) unsigned NOT NULL DEFAULT '0',
`paID` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`cID`,`arHandle`,`pkID`,`paID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `AreaPermissionBlockTypeAccessList`
CREATE TABLE `AreaPermissionBlockTypeAccessList` (
`paID` int(10) unsigned NOT NULL DEFAULT '0',
`peID` int(10) unsigned NOT NULL DEFAULT '0',
`permission` varchar(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`paID`,`peID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `AreaPermissionBlockTypeAccessListCustom`
CREATE TABLE `AreaPermissionBlockTypeAccessListCustom` (
`paID` int(10) unsigned NOT NULL DEFAULT '0',
`peID` int(10) unsigned NOT NULL DEFAULT '0',
`btID` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`paID`,`peID`,`btID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `Areas`
`arID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`cID` int(10) unsigned NOT NULL DEFAULT '0',
`arHandle` varchar(255) NOT NULL,
`arOverrideCollectionPermissions` tinyint(1) NOT NULL DEFAULT '0',
`arInheritPermissionsFromAreaOnCID` int(10) unsigned NOT NULL DEFAULT '0',
`arIsGlobal` int(1) unsigned NOT NULL DEFAULT '0',
KEY `arIsGlobal` (`arIsGlobal`),
KEY `arHandle` (`arHandle`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
-- Dumping data for table `Areas`
INSERT INTO `Areas` VALUES
(1, 106, 'Header', 0, 0, 0),
(2, 106, 'Column 1', 0, 0, 0),
(3, 106, 'Column 2', 0, 0, 0),
(4, 106, 'Column 3', 0, 0, 0),
(5, 106, 'Column 4', 0, 0, 0),
(6, 107, 'Primary', 0, 0, 0),
(7, 107, 'Secondary 1', 0, 0, 0),
(8, 107, 'Secondary 2', 0, 0, 0),
(9, 107, 'Secondary 3', 0, 0, 0),
(10, 107, 'Secondary 4', 0, 0, 0),
(11, 107, 'Secondary 5', 0, 0, 0);
-- --------------------------------------------------------
-- Table structure for table `atAddress`
CREATE TABLE `atAddress` (
`avID` int(10) unsigned NOT NULL DEFAULT '0',
`address1` varchar(255) DEFAULT NULL,
`address2` varchar(255) DEFAULT NULL,
`city` varchar(255) DEFAULT NULL,
`state_province` varchar(255) DEFAULT NULL,
`country` varchar(4) DEFAULT NULL,
`postal_code` varchar(32) DEFAULT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `atAddressCustomCountries`
CREATE TABLE `atAddressCustomCountries` (
`atAddressCustomCountryID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`akID` int(10) unsigned NOT NULL DEFAULT '0',
`country` varchar(5) NOT NULL,
PRIMARY KEY (`atAddressCustomCountryID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `atAddressSettings`
CREATE TABLE `atAddressSettings` (
`akID` int(10) unsigned NOT NULL DEFAULT '0',
`akHasCustomCountries` int(1) NOT NULL DEFAULT '0',
`akDefaultCountry` varchar(12) DEFAULT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `atBoolean`
CREATE TABLE `atBoolean` (
`avID` int(10) unsigned NOT NULL,
`value` tinyint(1) NOT NULL DEFAULT '0',
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- Dumping data for table `atBoolean`
INSERT INTO `atBoolean` VALUES
-- --------------------------------------------------------
-- Table structure for table `atBooleanSettings`
CREATE TABLE `atBooleanSettings` (
`akID` int(10) unsigned NOT NULL,
`akCheckedByDefault` tinyint(1) NOT NULL DEFAULT '0',
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- Dumping data for table `atBooleanSettings`
INSERT INTO `atBooleanSettings` VALUES
-- --------------------------------------------------------
-- Table structure for table `atDateTime`
CREATE TABLE `atDateTime` (
`avID` int(10) unsigned NOT NULL,
`value` datetime DEFAULT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `atDateTimeSettings`
CREATE TABLE `atDateTimeSettings` (
`akID` int(10) unsigned NOT NULL,
`akDateDisplayMode` varchar(255) DEFAULT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `atDefault`
CREATE TABLE `atDefault` (
`avID` int(10) unsigned NOT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- Dumping data for table `atDefault`
INSERT INTO `atDefault` VALUES
(3, 'new blog, write blog, blogging'),
(5, 'blog drafts, composer'),
(7, 'pages, add page, delete page, copy, move, alias'),
(8, 'pages, add page, delete page, copy, move, alias'),
(10, 'pages, add page, delete page, copy, move, alias, bulk'),
(12, 'find page, search page, search, find, pages, sitemap'),
(14, 'add file, delete file, copy, move, alias, resize, crop, rename, images, title, attribute'),
(16, 'file, file attributes, title, attribute, description, rename'),
(18, 'files, category, categories'),
(23, 'users, groups, people, find, delete user, remove user, change password, password'),
(24, 'find, search, people, delete user, remove user, change password, password'),
(26, 'user, group, people, permissions, access, expire'),
(28, 'user attributes, user data, gather data, registration data'),
(30, 'new user, create'),
(33, 'new user group, new group, group, create'),
(38, 'forms, log, error, email, mysql, exception, survey'),
(39, 'hits, pageviews, visitors, activity'),
(41, 'forms, questions, response, data'),
(43, 'questions, quiz, response'),
(45, 'forms, log, error, email, mysql, exception, survey, history'),
(47, 'new theme, theme, active theme, change theme, template, css'),
(51, 'custom theme, change theme, custom css, css'),
(52, 'page type defaults, global block, global area, starter, template'),
(54, 'page attributes, custom'),
(56, 'single, page, custom, application'),
(58, 'add workflow, remove workflow'),
(61, 'stacks, reusable content, scrapbook, copy, paste, paste block, copy block, site name, logo'),
(66, 'block, refresh, custom'),
(70, 'add-on, addon, ecommerce, install, discussions, forums, themes, templates, blocks'),
(72, 'concrete5.org, my account, marketplace'),
(73, 'buy theme, new theme, marketplace, template'),
(74, 'buy addon, buy add on, buy add-on, purchase addon, purchase add on, purchase add-on, find addon, new addon, marketplace'),
(76, 'website name, title'),
(77, 'logo, favicon, iphone, icon, bookmark'),
(78, 'tinymce, content block, fonts, editor, content, overlay'),
(79, 'translate, translation, internationalization, multilingual'),
(80, 'timezone, profile, locale'),
(81, 'interface, quick nav, dashboard background, background image'),
(82, 'vanity, pretty url, seo, pageview, view'),
(83, 'bulk, seo, change keywords, engine, optimization, search'),
(84, 'traffic, statistics, google analytics, quant, pageviews, hits'),
(86, 'turn off statistics, tracking, statistics, pageviews, hits'),
(87, 'configure search, site search, search option'),
(88, 'cache option, change cache, override, turn on cache, turn off cache, no cache, page cache, caching'),
(89, 'cache option, turn off cache, no cache, page cache, caching'),
(90, 'index search, reindex search, build sitemap, sitemap.xml, clear old versions, page versions, remove old'),
(91, 'editors, hide site, offline, private, public, access'),
(92, 'file options, file manager, upload, modify'),
(93, 'security, files, media, extension, manager, upload'),
(94, 'security, actions, administrator, admin, package, marketplace, search'),
(95, 'security, lock ip, lock out, block ip, address, restrict, access'),
(96, 'security, registration'),
(97, 'antispam, block spam, security'),
(98, 'lock site, under construction, hide, hidden'),
(99, 'profile, login, redirect, specific, dashboard, administrators'),
(100, 'member profile, member page, community, forums, social, avatar'),
(101, 'signup, new user, community'),
(102, 'smtp, mail settings'),
(103, 'email server, mail settings, mail configuration, external, internal'),
(104, 'test smtp, test mail'),
(105, 'email server, mail settings, mail configuration, private message, message system, import, email, message'),
(106, 'attribute configuration'),
(107, 'attributes, sets'),
(108, 'attributes, types'),
(110, 'overrides, system info, debug, support, help'),
(111, 'errors, exceptions, develop, support, help'),
(112, 'email, logging, logs, smtp, pop, errors, mysql, log'),
(113, 'security, alternate storage, hide files'),
(114, 'network, proxy server'),
(115, 'export, backup, database, sql, mysql, encryption, restore'),
(116, 'upgrade, new version, update'),
(117, 'export, database, xml, starting, points, schema, refresh, custom, tables');
-- --------------------------------------------------------
-- Table structure for table `atFile`
`avID` int(10) unsigned NOT NULL,
`fID` int(10) unsigned NOT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `atNumber`
CREATE TABLE `atNumber` (
`avID` int(10) unsigned NOT NULL,
`value` decimal(14,4) DEFAULT '0.0000',
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `atSelectOptions`
CREATE TABLE `atSelectOptions` (
`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`akID` int(10) unsigned DEFAULT NULL,
`value` varchar(255) DEFAULT NULL,
`displayOrder` int(10) unsigned DEFAULT NULL,
`isEndUserAdded` tinyint(1) NOT NULL DEFAULT '0',
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
-- Table structure for table `atSelectOptionsSelected`
CREATE TABLE `atSelectOptionsSelected` (
`avID` int(10) unsigned NOT NULL,
`atSelectOptionID` int(10) unsigned NOT NULL,
PRIMARY KEY (`avID`,`atSelectOptionID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `atSelectSettings`
CREATE TABLE `atSelectSettings` (
`akID` int(10) unsigned NOT NULL,
`akSelectAllowMultipleValues` tinyint(1) NOT NULL DEFAULT '0',
`akSelectOptionDisplayOrder` varchar(255) NOT NULL DEFAULT 'display_asc',
`akSelectAllowOtherValues` tinyint(1) NOT NULL DEFAULT '0',
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- --------------------------------------------------------
-- Table structure for table `atTextareaSettings`
CREATE TABLE `atTextareaSettings` (
`akID` int(10) unsigned NOT NULL DEFAULT '0',
`akTextareaDisplayMode` varchar(255) DEFAULT NULL,
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- Dumping data for table `atTextareaSettings`
INSERT INTO `atTextareaSettings` VALUES
-- --------------------------------------------------------
-- Table structure for table `AttributeKeyCategories`
CREATE TABLE `AttributeKeyCategories` (
`akCategoryID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`akCategoryHandle` varchar(255) NOT NULL,
`akCategoryAllowSets` smallint(4) NOT NULL DEFAULT '0',
`pkgID` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`akCategoryID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
-- Dumping data for table `AttributeKeyCategories`
INSERT INTO `AttributeKeyCategories` VALUES
(1, 'collection', 1, NULL),
-- --------------------------------------------------------
-- Table structure for table `AttributeKeys`
CREATE TABLE `AttributeKeys` (
`akID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`akHandle` varchar(255) NOT NULL,
`akName` varchar(255) NOT NULL,
`akIsSearchable` tinyint(1) NOT NULL DEFAULT '0',
`akIsSearchableIndexed` tinyint(1) NOT NULL DEFAULT '0',
`akIsAutoCreated` tinyint(1) NOT NULL DEFAULT '0',
`akIsInternal` tinyint(1) NOT NULL DEFAULT '0',
`akIsColumnHeader` tinyint(1) NOT NULL DEFAULT '0',
`akIsEditable` tinyint(1) NOT NULL DEFAULT '0',
`atID` int(10) unsigned DEFAULT NULL,
`akCategoryID` int(10) unsigned DEFAULT NULL,
`pkgID` int(10) unsigned DEFAULT NULL,
UNIQUE KEY `akHandle` (`akHandle`,`akCategoryID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
-- Dumping data for table `AttributeKeys`
INSERT INTO `AttributeKeys` VALUES
(1, 'meta_title', 'Meta Title', 1, 1, 0, 0, 0, 1, 1, 1, 0),
(2, 'meta_description', 'Meta Description', 1, 1, 0, 0, 0, 1, 2, 1, 0),
(3, 'meta_keywords', 'Meta Keywords', 1, 1, 0, 0, 0, 1, 2, 1, 0),
(4, 'icon_dashboard', 'Dashboard Icon', 1, 1, 0, 1, 0, 1, 2, 1, 0),
(5, 'exclude_nav', 'Exclude From Nav', 1, 1, 0, 0, 0, 1, 3, 1, 0),
(6, 'exclude_page_list', 'Exclude From Page List', 1, 1, 0, 0, 0, 1, 3, 1, 0),
(7, 'header_extra_content', 'Header Extra Content', 1, 1, 0, 0, 0, 1, 2, 1, 0),
(8, 'exclude_search_index', 'Exclude From Search Index', 1, 1, 0, 0, 0, 1, 3, 1, 0),
(9, 'exclude_sitemapxml', 'Exclude From sitemap.xml', 1, 1, 0, 0, 0, 1, 3, 1, 0),
(10, 'profile_private_messages_enabled', 'I would like to receive private messages.', 1, 1, 0, 0, 0, 1, 3, 2, 0),
(11, 'profile_private_messages_notification_enabled', 'Send me email notifications when I receive a private message.', 1, 1, 0, 0, 0, 1, 3, 2, 0),
(12, 'width', 'Width', 1, 1, 0, 0, 0, 1, 6, 3, 0),
(13, 'height', 'Height', 1, 1, 0, 0, 0, 1, 6, 3, 0),
(14, 'duration', 'Duration', 1, 1, 0, 0, 0, 1, 6, 3, 0);
-- --------------------------------------------------------
-- Table structure for table `AttributeSetKeys`
CREATE TABLE `AttributeSetKeys` (
`akID` int(10) unsigned NOT NULL DEFAULT '0',
`asID` int(10) unsigned NOT NULL DEFAULT '0',
`displayOrder` int(10) unsigned NOT NULL DEFAULT '0',
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
