Edit File by line
/home/barbar84/www/wp-conte.../plugins/sujqvwi/ShExBy/shex_roo.../var/softacul.../conc56
File: conc56.sql
[0] Fix | Delete
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
[1] Fix | Delete
SET time_zone = "+00:00";
[2] Fix | Delete
[3] Fix | Delete
[4] Fix | Delete
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
[5] Fix | Delete
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
[6] Fix | Delete
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
[7] Fix | Delete
/*!40101 SET NAMES utf8 */;
[8] Fix | Delete
[9] Fix | Delete
--
[10] Fix | Delete
-- Database: `conc5640`
[11] Fix | Delete
--
[12] Fix | Delete
[13] Fix | Delete
-- --------------------------------------------------------
[14] Fix | Delete
[15] Fix | Delete
--
[16] Fix | Delete
-- Table structure for table `AreaPermissionAssignments`
[17] Fix | Delete
--
[18] Fix | Delete
[19] Fix | Delete
CREATE TABLE `AreaPermissionAssignments` (
[20] Fix | Delete
`cID` int(10) unsigned NOT NULL DEFAULT '0',
[21] Fix | Delete
`arHandle` varchar(255) NOT NULL,
[22] Fix | Delete
`pkID` int(10) unsigned NOT NULL DEFAULT '0',
[23] Fix | Delete
`paID` int(10) unsigned NOT NULL DEFAULT '0',
[24] Fix | Delete
PRIMARY KEY (`cID`,`arHandle`,`pkID`,`paID`)
[25] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[26] Fix | Delete
[27] Fix | Delete
-- --------------------------------------------------------
[28] Fix | Delete
[29] Fix | Delete
--
[30] Fix | Delete
-- Table structure for table `AreaPermissionBlockTypeAccessList`
[31] Fix | Delete
--
[32] Fix | Delete
[33] Fix | Delete
CREATE TABLE `AreaPermissionBlockTypeAccessList` (
[34] Fix | Delete
`paID` int(10) unsigned NOT NULL DEFAULT '0',
[35] Fix | Delete
`peID` int(10) unsigned NOT NULL DEFAULT '0',
[36] Fix | Delete
`permission` varchar(1) NOT NULL DEFAULT '1',
[37] Fix | Delete
PRIMARY KEY (`paID`,`peID`)
[38] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[39] Fix | Delete
[40] Fix | Delete
-- --------------------------------------------------------
[41] Fix | Delete
[42] Fix | Delete
--
[43] Fix | Delete
-- Table structure for table `AreaPermissionBlockTypeAccessListCustom`
[44] Fix | Delete
--
[45] Fix | Delete
[46] Fix | Delete
CREATE TABLE `AreaPermissionBlockTypeAccessListCustom` (
[47] Fix | Delete
`paID` int(10) unsigned NOT NULL DEFAULT '0',
[48] Fix | Delete
`peID` int(10) unsigned NOT NULL DEFAULT '0',
[49] Fix | Delete
`btID` int(10) unsigned NOT NULL DEFAULT '0',
[50] Fix | Delete
PRIMARY KEY (`paID`,`peID`,`btID`)
[51] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[52] Fix | Delete
[53] Fix | Delete
-- --------------------------------------------------------
[54] Fix | Delete
[55] Fix | Delete
--
[56] Fix | Delete
-- Table structure for table `Areas`
[57] Fix | Delete
--
[58] Fix | Delete
[59] Fix | Delete
CREATE TABLE `Areas` (
[60] Fix | Delete
`arID` int(10) unsigned NOT NULL AUTO_INCREMENT,
[61] Fix | Delete
`cID` int(10) unsigned NOT NULL DEFAULT '0',
[62] Fix | Delete
`arHandle` varchar(255) NOT NULL,
[63] Fix | Delete
`arOverrideCollectionPermissions` tinyint(1) NOT NULL DEFAULT '0',
[64] Fix | Delete
`arInheritPermissionsFromAreaOnCID` int(10) unsigned NOT NULL DEFAULT '0',
[65] Fix | Delete
`arIsGlobal` int(1) unsigned NOT NULL DEFAULT '0',
[66] Fix | Delete
PRIMARY KEY (`arID`),
[67] Fix | Delete
KEY `arIsGlobal` (`arIsGlobal`),
[68] Fix | Delete
KEY `cID` (`cID`),
[69] Fix | Delete
KEY `arHandle` (`arHandle`)
[70] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
[71] Fix | Delete
[72] Fix | Delete
--
[73] Fix | Delete
-- Dumping data for table `Areas`
[74] Fix | Delete
--
[75] Fix | Delete
[76] Fix | Delete
INSERT INTO `Areas` VALUES
[77] Fix | Delete
(1, 106, 'Header', 0, 0, 0),
[78] Fix | Delete
(2, 106, 'Column 1', 0, 0, 0),
[79] Fix | Delete
(3, 106, 'Column 2', 0, 0, 0),
[80] Fix | Delete
(4, 106, 'Column 3', 0, 0, 0),
[81] Fix | Delete
(5, 106, 'Column 4', 0, 0, 0),
[82] Fix | Delete
(6, 107, 'Primary', 0, 0, 0),
[83] Fix | Delete
(7, 107, 'Secondary 1', 0, 0, 0),
[84] Fix | Delete
(8, 107, 'Secondary 2', 0, 0, 0),
[85] Fix | Delete
(9, 107, 'Secondary 3', 0, 0, 0),
[86] Fix | Delete
(10, 107, 'Secondary 4', 0, 0, 0),
[87] Fix | Delete
(11, 107, 'Secondary 5', 0, 0, 0);
[88] Fix | Delete
[89] Fix | Delete
-- --------------------------------------------------------
[90] Fix | Delete
[91] Fix | Delete
--
[92] Fix | Delete
-- Table structure for table `atAddress`
[93] Fix | Delete
--
[94] Fix | Delete
[95] Fix | Delete
CREATE TABLE `atAddress` (
[96] Fix | Delete
`avID` int(10) unsigned NOT NULL DEFAULT '0',
[97] Fix | Delete
`address1` varchar(255) DEFAULT NULL,
[98] Fix | Delete
`address2` varchar(255) DEFAULT NULL,
[99] Fix | Delete
`city` varchar(255) DEFAULT NULL,
[100] Fix | Delete
`state_province` varchar(255) DEFAULT NULL,
[101] Fix | Delete
`country` varchar(4) DEFAULT NULL,
[102] Fix | Delete
`postal_code` varchar(32) DEFAULT NULL,
[103] Fix | Delete
PRIMARY KEY (`avID`)
[104] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[105] Fix | Delete
[106] Fix | Delete
-- --------------------------------------------------------
[107] Fix | Delete
[108] Fix | Delete
--
[109] Fix | Delete
-- Table structure for table `atAddressCustomCountries`
[110] Fix | Delete
--
[111] Fix | Delete
[112] Fix | Delete
CREATE TABLE `atAddressCustomCountries` (
[113] Fix | Delete
`atAddressCustomCountryID` int(10) unsigned NOT NULL AUTO_INCREMENT,
[114] Fix | Delete
`akID` int(10) unsigned NOT NULL DEFAULT '0',
[115] Fix | Delete
`country` varchar(5) NOT NULL,
[116] Fix | Delete
PRIMARY KEY (`atAddressCustomCountryID`)
[117] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[118] Fix | Delete
[119] Fix | Delete
-- --------------------------------------------------------
[120] Fix | Delete
[121] Fix | Delete
--
[122] Fix | Delete
-- Table structure for table `atAddressSettings`
[123] Fix | Delete
--
[124] Fix | Delete
[125] Fix | Delete
CREATE TABLE `atAddressSettings` (
[126] Fix | Delete
`akID` int(10) unsigned NOT NULL DEFAULT '0',
[127] Fix | Delete
`akHasCustomCountries` int(1) NOT NULL DEFAULT '0',
[128] Fix | Delete
`akDefaultCountry` varchar(12) DEFAULT NULL,
[129] Fix | Delete
PRIMARY KEY (`akID`)
[130] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[131] Fix | Delete
[132] Fix | Delete
-- --------------------------------------------------------
[133] Fix | Delete
[134] Fix | Delete
--
[135] Fix | Delete
-- Table structure for table `atBoolean`
[136] Fix | Delete
--
[137] Fix | Delete
[138] Fix | Delete
CREATE TABLE `atBoolean` (
[139] Fix | Delete
`avID` int(10) unsigned NOT NULL,
[140] Fix | Delete
`value` tinyint(1) NOT NULL DEFAULT '0',
[141] Fix | Delete
PRIMARY KEY (`avID`)
[142] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[143] Fix | Delete
[144] Fix | Delete
--
[145] Fix | Delete
-- Dumping data for table `atBoolean`
[146] Fix | Delete
--
[147] Fix | Delete
[148] Fix | Delete
INSERT INTO `atBoolean` VALUES
[149] Fix | Delete
(20, 1),
[150] Fix | Delete
(31, 1),
[151] Fix | Delete
(34, 1),
[152] Fix | Delete
(64, 1),
[153] Fix | Delete
(65, 1),
[154] Fix | Delete
(68, 1),
[155] Fix | Delete
(69, 1),
[156] Fix | Delete
(75, 1),
[157] Fix | Delete
(109, 1),
[158] Fix | Delete
(118, 1),
[159] Fix | Delete
(119, 1),
[160] Fix | Delete
(120, 1);
[161] Fix | Delete
[162] Fix | Delete
-- --------------------------------------------------------
[163] Fix | Delete
[164] Fix | Delete
--
[165] Fix | Delete
-- Table structure for table `atBooleanSettings`
[166] Fix | Delete
--
[167] Fix | Delete
[168] Fix | Delete
CREATE TABLE `atBooleanSettings` (
[169] Fix | Delete
`akID` int(10) unsigned NOT NULL,
[170] Fix | Delete
`akCheckedByDefault` tinyint(1) NOT NULL DEFAULT '0',
[171] Fix | Delete
PRIMARY KEY (`akID`)
[172] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[173] Fix | Delete
[174] Fix | Delete
--
[175] Fix | Delete
-- Dumping data for table `atBooleanSettings`
[176] Fix | Delete
--
[177] Fix | Delete
[178] Fix | Delete
INSERT INTO `atBooleanSettings` VALUES
[179] Fix | Delete
(5, 0),
[180] Fix | Delete
(6, 0),
[181] Fix | Delete
(8, 0),
[182] Fix | Delete
(9, 0),
[183] Fix | Delete
(10, 1),
[184] Fix | Delete
(11, 1);
[185] Fix | Delete
[186] Fix | Delete
-- --------------------------------------------------------
[187] Fix | Delete
[188] Fix | Delete
--
[189] Fix | Delete
-- Table structure for table `atDateTime`
[190] Fix | Delete
--
[191] Fix | Delete
[192] Fix | Delete
CREATE TABLE `atDateTime` (
[193] Fix | Delete
`avID` int(10) unsigned NOT NULL,
[194] Fix | Delete
`value` datetime DEFAULT NULL,
[195] Fix | Delete
PRIMARY KEY (`avID`)
[196] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[197] Fix | Delete
[198] Fix | Delete
-- --------------------------------------------------------
[199] Fix | Delete
[200] Fix | Delete
--
[201] Fix | Delete
-- Table structure for table `atDateTimeSettings`
[202] Fix | Delete
--
[203] Fix | Delete
[204] Fix | Delete
CREATE TABLE `atDateTimeSettings` (
[205] Fix | Delete
`akID` int(10) unsigned NOT NULL,
[206] Fix | Delete
`akDateDisplayMode` varchar(255) DEFAULT NULL,
[207] Fix | Delete
PRIMARY KEY (`akID`)
[208] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[209] Fix | Delete
[210] Fix | Delete
-- --------------------------------------------------------
[211] Fix | Delete
[212] Fix | Delete
--
[213] Fix | Delete
-- Table structure for table `atDefault`
[214] Fix | Delete
--
[215] Fix | Delete
[216] Fix | Delete
CREATE TABLE `atDefault` (
[217] Fix | Delete
`avID` int(10) unsigned NOT NULL,
[218] Fix | Delete
`value` longtext,
[219] Fix | Delete
PRIMARY KEY (`avID`)
[220] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[221] Fix | Delete
[222] Fix | Delete
--
[223] Fix | Delete
-- Dumping data for table `atDefault`
[224] Fix | Delete
--
[225] Fix | Delete
[226] Fix | Delete
INSERT INTO `atDefault` VALUES
[227] Fix | Delete
(1, 'blog, blogging'),
[228] Fix | Delete
(2, 'icon-book'),
[229] Fix | Delete
(3, 'new blog, write blog, blogging'),
[230] Fix | Delete
(4, 'icon-pencil'),
[231] Fix | Delete
(5, 'blog drafts, composer'),
[232] Fix | Delete
(6, 'icon-book'),
[233] Fix | Delete
(7, 'pages, add page, delete page, copy, move, alias'),
[234] Fix | Delete
(8, 'pages, add page, delete page, copy, move, alias'),
[235] Fix | Delete
(9, 'icon-home'),
[236] Fix | Delete
(10, 'pages, add page, delete page, copy, move, alias, bulk'),
[237] Fix | Delete
(11, 'icon-road'),
[238] Fix | Delete
(12, 'find page, search page, search, find, pages, sitemap'),
[239] Fix | Delete
(13, 'icon-search'),
[240] Fix | Delete
(14, 'add file, delete file, copy, move, alias, resize, crop, rename, images, title, attribute'),
[241] Fix | Delete
(15, 'icon-picture'),
[242] Fix | Delete
(16, 'file, file attributes, title, attribute, description, rename'),
[243] Fix | Delete
(17, 'icon-cog'),
[244] Fix | Delete
(18, 'files, category, categories'),
[245] Fix | Delete
(19, 'icon-list-alt'),
[246] Fix | Delete
(21, 'new file set'),
[247] Fix | Delete
(22, 'icon-plus-sign'),
[248] Fix | Delete
(23, 'users, groups, people, find, delete user, remove user, change password, password'),
[249] Fix | Delete
(24, 'find, search, people, delete user, remove user, change password, password'),
[250] Fix | Delete
(25, 'icon-user'),
[251] Fix | Delete
(26, 'user, group, people, permissions, access, expire'),
[252] Fix | Delete
(27, 'icon-globe'),
[253] Fix | Delete
(28, 'user attributes, user data, gather data, registration data'),
[254] Fix | Delete
(29, 'icon-cog'),
[255] Fix | Delete
(30, 'new user, create'),
[256] Fix | Delete
(32, 'icon-plus-sign'),
[257] Fix | Delete
(33, 'new user group, new group, group, create'),
[258] Fix | Delete
(35, 'icon-plus'),
[259] Fix | Delete
(36, 'group set'),
[260] Fix | Delete
(37, 'icon-list'),
[261] Fix | Delete
(38, 'forms, log, error, email, mysql, exception, survey'),
[262] Fix | Delete
(39, 'hits, pageviews, visitors, activity'),
[263] Fix | Delete
(40, 'icon-signal'),
[264] Fix | Delete
(41, 'forms, questions, response, data'),
[265] Fix | Delete
(42, 'icon-briefcase'),
[266] Fix | Delete
(43, 'questions, quiz, response'),
[267] Fix | Delete
(44, 'icon-tasks'),
[268] Fix | Delete
(45, 'forms, log, error, email, mysql, exception, survey, history'),
[269] Fix | Delete
(46, 'icon-time'),
[270] Fix | Delete
(47, 'new theme, theme, active theme, change theme, template, css'),
[271] Fix | Delete
(48, 'icon-font'),
[272] Fix | Delete
(49, 'theme'),
[273] Fix | Delete
(50, 'page types'),
[274] Fix | Delete
(51, 'custom theme, change theme, custom css, css'),
[275] Fix | Delete
(52, 'page type defaults, global block, global area, starter, template'),
[276] Fix | Delete
(53, 'icon-file'),
[277] Fix | Delete
(54, 'page attributes, custom'),
[278] Fix | Delete
(55, 'icon-cog'),
[279] Fix | Delete
(56, 'single, page, custom, application'),
[280] Fix | Delete
(57, 'icon-wrench'),
[281] Fix | Delete
(58, 'add workflow, remove workflow'),
[282] Fix | Delete
(59, 'icon-list'),
[283] Fix | Delete
(60, 'icon-user'),
[284] Fix | Delete
(61, 'stacks, reusable content, scrapbook, copy, paste, paste block, copy block, site name, logo'),
[285] Fix | Delete
(62, 'icon-th'),
[286] Fix | Delete
(63, 'icon-lock'),
[287] Fix | Delete
(66, 'block, refresh, custom'),
[288] Fix | Delete
(67, 'icon-wrench'),
[289] Fix | Delete
(70, 'add-on, addon, ecommerce, install, discussions, forums, themes, templates, blocks'),
[290] Fix | Delete
(71, 'update, upgrade'),
[291] Fix | Delete
(72, 'concrete5.org, my account, marketplace'),
[292] Fix | Delete
(73, 'buy theme, new theme, marketplace, template'),
[293] Fix | Delete
(74, 'buy addon, buy add on, buy add-on, purchase addon, purchase add on, purchase add-on, find addon, new addon, marketplace'),
[294] Fix | Delete
(76, 'website name, title'),
[295] Fix | Delete
(77, 'logo, favicon, iphone, icon, bookmark'),
[296] Fix | Delete
(78, 'tinymce, content block, fonts, editor, content, overlay'),
[297] Fix | Delete
(79, 'translate, translation, internationalization, multilingual'),
[298] Fix | Delete
(80, 'timezone, profile, locale'),
[299] Fix | Delete
(81, 'interface, quick nav, dashboard background, background image'),
[300] Fix | Delete
(82, 'vanity, pretty url, seo, pageview, view'),
[301] Fix | Delete
(83, 'bulk, seo, change keywords, engine, optimization, search'),
[302] Fix | Delete
(84, 'traffic, statistics, google analytics, quant, pageviews, hits'),
[303] Fix | Delete
(85, 'pretty, slug'),
[304] Fix | Delete
(86, 'turn off statistics, tracking, statistics, pageviews, hits'),
[305] Fix | Delete
(87, 'configure search, site search, search option'),
[306] Fix | Delete
(88, 'cache option, change cache, override, turn on cache, turn off cache, no cache, page cache, caching'),
[307] Fix | Delete
(89, 'cache option, turn off cache, no cache, page cache, caching'),
[308] Fix | Delete
(90, 'index search, reindex search, build sitemap, sitemap.xml, clear old versions, page versions, remove old'),
[309] Fix | Delete
(91, 'editors, hide site, offline, private, public, access'),
[310] Fix | Delete
(92, 'file options, file manager, upload, modify'),
[311] Fix | Delete
(93, 'security, files, media, extension, manager, upload'),
[312] Fix | Delete
(94, 'security, actions, administrator, admin, package, marketplace, search'),
[313] Fix | Delete
(95, 'security, lock ip, lock out, block ip, address, restrict, access'),
[314] Fix | Delete
(96, 'security, registration'),
[315] Fix | Delete
(97, 'antispam, block spam, security'),
[316] Fix | Delete
(98, 'lock site, under construction, hide, hidden'),
[317] Fix | Delete
(99, 'profile, login, redirect, specific, dashboard, administrators'),
[318] Fix | Delete
(100, 'member profile, member page, community, forums, social, avatar'),
[319] Fix | Delete
(101, 'signup, new user, community'),
[320] Fix | Delete
(102, 'smtp, mail settings'),
[321] Fix | Delete
(103, 'email server, mail settings, mail configuration, external, internal'),
[322] Fix | Delete
(104, 'test smtp, test mail'),
[323] Fix | Delete
(105, 'email server, mail settings, mail configuration, private message, message system, import, email, message'),
[324] Fix | Delete
(106, 'attribute configuration'),
[325] Fix | Delete
(107, 'attributes, sets'),
[326] Fix | Delete
(108, 'attributes, types'),
[327] Fix | Delete
(110, 'overrides, system info, debug, support, help'),
[328] Fix | Delete
(111, 'errors, exceptions, develop, support, help'),
[329] Fix | Delete
(112, 'email, logging, logs, smtp, pop, errors, mysql, log'),
[330] Fix | Delete
(113, 'security, alternate storage, hide files'),
[331] Fix | Delete
(114, 'network, proxy server'),
[332] Fix | Delete
(115, 'export, backup, database, sql, mysql, encryption, restore'),
[333] Fix | Delete
(116, 'upgrade, new version, update'),
[334] Fix | Delete
(117, 'export, database, xml, starting, points, schema, refresh, custom, tables');
[335] Fix | Delete
[336] Fix | Delete
-- --------------------------------------------------------
[337] Fix | Delete
[338] Fix | Delete
--
[339] Fix | Delete
-- Table structure for table `atFile`
[340] Fix | Delete
--
[341] Fix | Delete
[342] Fix | Delete
CREATE TABLE `atFile` (
[343] Fix | Delete
`avID` int(10) unsigned NOT NULL,
[344] Fix | Delete
`fID` int(10) unsigned NOT NULL,
[345] Fix | Delete
PRIMARY KEY (`avID`)
[346] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[347] Fix | Delete
[348] Fix | Delete
-- --------------------------------------------------------
[349] Fix | Delete
[350] Fix | Delete
--
[351] Fix | Delete
-- Table structure for table `atNumber`
[352] Fix | Delete
--
[353] Fix | Delete
[354] Fix | Delete
CREATE TABLE `atNumber` (
[355] Fix | Delete
`avID` int(10) unsigned NOT NULL,
[356] Fix | Delete
`value` decimal(14,4) DEFAULT '0.0000',
[357] Fix | Delete
PRIMARY KEY (`avID`)
[358] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[359] Fix | Delete
[360] Fix | Delete
-- --------------------------------------------------------
[361] Fix | Delete
[362] Fix | Delete
--
[363] Fix | Delete
-- Table structure for table `atSelectOptions`
[364] Fix | Delete
--
[365] Fix | Delete
[366] Fix | Delete
CREATE TABLE `atSelectOptions` (
[367] Fix | Delete
`ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
[368] Fix | Delete
`akID` int(10) unsigned DEFAULT NULL,
[369] Fix | Delete
`value` varchar(255) DEFAULT NULL,
[370] Fix | Delete
`displayOrder` int(10) unsigned DEFAULT NULL,
[371] Fix | Delete
`isEndUserAdded` tinyint(1) NOT NULL DEFAULT '0',
[372] Fix | Delete
PRIMARY KEY (`ID`)
[373] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[374] Fix | Delete
[375] Fix | Delete
-- --------------------------------------------------------
[376] Fix | Delete
[377] Fix | Delete
--
[378] Fix | Delete
-- Table structure for table `atSelectOptionsSelected`
[379] Fix | Delete
--
[380] Fix | Delete
[381] Fix | Delete
CREATE TABLE `atSelectOptionsSelected` (
[382] Fix | Delete
`avID` int(10) unsigned NOT NULL,
[383] Fix | Delete
`atSelectOptionID` int(10) unsigned NOT NULL,
[384] Fix | Delete
PRIMARY KEY (`avID`,`atSelectOptionID`)
[385] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[386] Fix | Delete
[387] Fix | Delete
-- --------------------------------------------------------
[388] Fix | Delete
[389] Fix | Delete
--
[390] Fix | Delete
-- Table structure for table `atSelectSettings`
[391] Fix | Delete
--
[392] Fix | Delete
[393] Fix | Delete
CREATE TABLE `atSelectSettings` (
[394] Fix | Delete
`akID` int(10) unsigned NOT NULL,
[395] Fix | Delete
`akSelectAllowMultipleValues` tinyint(1) NOT NULL DEFAULT '0',
[396] Fix | Delete
`akSelectOptionDisplayOrder` varchar(255) NOT NULL DEFAULT 'display_asc',
[397] Fix | Delete
`akSelectAllowOtherValues` tinyint(1) NOT NULL DEFAULT '0',
[398] Fix | Delete
PRIMARY KEY (`akID`)
[399] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[400] Fix | Delete
[401] Fix | Delete
-- --------------------------------------------------------
[402] Fix | Delete
[403] Fix | Delete
--
[404] Fix | Delete
-- Table structure for table `atTextareaSettings`
[405] Fix | Delete
--
[406] Fix | Delete
[407] Fix | Delete
CREATE TABLE `atTextareaSettings` (
[408] Fix | Delete
`akID` int(10) unsigned NOT NULL DEFAULT '0',
[409] Fix | Delete
`akTextareaDisplayMode` varchar(255) DEFAULT NULL,
[410] Fix | Delete
PRIMARY KEY (`akID`)
[411] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
[412] Fix | Delete
[413] Fix | Delete
--
[414] Fix | Delete
-- Dumping data for table `atTextareaSettings`
[415] Fix | Delete
--
[416] Fix | Delete
[417] Fix | Delete
INSERT INTO `atTextareaSettings` VALUES
[418] Fix | Delete
(2, ''),
[419] Fix | Delete
(3, ''),
[420] Fix | Delete
(4, ''),
[421] Fix | Delete
(7, '');
[422] Fix | Delete
[423] Fix | Delete
-- --------------------------------------------------------
[424] Fix | Delete
[425] Fix | Delete
--
[426] Fix | Delete
-- Table structure for table `AttributeKeyCategories`
[427] Fix | Delete
--
[428] Fix | Delete
[429] Fix | Delete
CREATE TABLE `AttributeKeyCategories` (
[430] Fix | Delete
`akCategoryID` int(10) unsigned NOT NULL AUTO_INCREMENT,
[431] Fix | Delete
`akCategoryHandle` varchar(255) NOT NULL,
[432] Fix | Delete
`akCategoryAllowSets` smallint(4) NOT NULL DEFAULT '0',
[433] Fix | Delete
`pkgID` int(10) unsigned DEFAULT NULL,
[434] Fix | Delete
PRIMARY KEY (`akCategoryID`)
[435] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
[436] Fix | Delete
[437] Fix | Delete
--
[438] Fix | Delete
-- Dumping data for table `AttributeKeyCategories`
[439] Fix | Delete
--
[440] Fix | Delete
[441] Fix | Delete
INSERT INTO `AttributeKeyCategories` VALUES
[442] Fix | Delete
(1, 'collection', 1, NULL),
[443] Fix | Delete
(2, 'user', 1, NULL),
[444] Fix | Delete
(3, 'file', 1, NULL);
[445] Fix | Delete
[446] Fix | Delete
-- --------------------------------------------------------
[447] Fix | Delete
[448] Fix | Delete
--
[449] Fix | Delete
-- Table structure for table `AttributeKeys`
[450] Fix | Delete
--
[451] Fix | Delete
[452] Fix | Delete
CREATE TABLE `AttributeKeys` (
[453] Fix | Delete
`akID` int(10) unsigned NOT NULL AUTO_INCREMENT,
[454] Fix | Delete
`akHandle` varchar(255) NOT NULL,
[455] Fix | Delete
`akName` varchar(255) NOT NULL,
[456] Fix | Delete
`akIsSearchable` tinyint(1) NOT NULL DEFAULT '0',
[457] Fix | Delete
`akIsSearchableIndexed` tinyint(1) NOT NULL DEFAULT '0',
[458] Fix | Delete
`akIsAutoCreated` tinyint(1) NOT NULL DEFAULT '0',
[459] Fix | Delete
`akIsInternal` tinyint(1) NOT NULL DEFAULT '0',
[460] Fix | Delete
`akIsColumnHeader` tinyint(1) NOT NULL DEFAULT '0',
[461] Fix | Delete
`akIsEditable` tinyint(1) NOT NULL DEFAULT '0',
[462] Fix | Delete
`atID` int(10) unsigned DEFAULT NULL,
[463] Fix | Delete
`akCategoryID` int(10) unsigned DEFAULT NULL,
[464] Fix | Delete
`pkgID` int(10) unsigned DEFAULT NULL,
[465] Fix | Delete
PRIMARY KEY (`akID`),
[466] Fix | Delete
UNIQUE KEY `akHandle` (`akHandle`,`akCategoryID`)
[467] Fix | Delete
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
[468] Fix | Delete
[469] Fix | Delete
--
[470] Fix | Delete
-- Dumping data for table `AttributeKeys`
[471] Fix | Delete
--
[472] Fix | Delete
[473] Fix | Delete
INSERT INTO `AttributeKeys` VALUES
[474] Fix | Delete
(1, 'meta_title', 'Meta Title', 1, 1, 0, 0, 0, 1, 1, 1, 0),
[475] Fix | Delete
(2, 'meta_description', 'Meta Description', 1, 1, 0, 0, 0, 1, 2, 1, 0),
[476] Fix | Delete
(3, 'meta_keywords', 'Meta Keywords', 1, 1, 0, 0, 0, 1, 2, 1, 0),
[477] Fix | Delete
(4, 'icon_dashboard', 'Dashboard Icon', 1, 1, 0, 1, 0, 1, 2, 1, 0),
[478] Fix | Delete
(5, 'exclude_nav', 'Exclude From Nav', 1, 1, 0, 0, 0, 1, 3, 1, 0),
[479] Fix | Delete
(6, 'exclude_page_list', 'Exclude From Page List', 1, 1, 0, 0, 0, 1, 3, 1, 0),
[480] Fix | Delete
(7, 'header_extra_content', 'Header Extra Content', 1, 1, 0, 0, 0, 1, 2, 1, 0),
[481] Fix | Delete
(8, 'exclude_search_index', 'Exclude From Search Index', 1, 1, 0, 0, 0, 1, 3, 1, 0),
[482] Fix | Delete
(9, 'exclude_sitemapxml', 'Exclude From sitemap.xml', 1, 1, 0, 0, 0, 1, 3, 1, 0),
[483] Fix | Delete
(10, 'profile_private_messages_enabled', 'I would like to receive private messages.', 1, 1, 0, 0, 0, 1, 3, 2, 0),
[484] Fix | Delete
(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),
[485] Fix | Delete
(12, 'width', 'Width', 1, 1, 0, 0, 0, 1, 6, 3, 0),
[486] Fix | Delete
(13, 'height', 'Height', 1, 1, 0, 0, 0, 1, 6, 3, 0),
[487] Fix | Delete
(14, 'duration', 'Duration', 1, 1, 0, 0, 0, 1, 6, 3, 0);
[488] Fix | Delete
[489] Fix | Delete
-- --------------------------------------------------------
[490] Fix | Delete
[491] Fix | Delete
--
[492] Fix | Delete
-- Table structure for table `AttributeSetKeys`
[493] Fix | Delete
--
[494] Fix | Delete
[495] Fix | Delete
CREATE TABLE `AttributeSetKeys` (
[496] Fix | Delete
`akID` int(10) unsigned NOT NULL DEFAULT '0',
[497] Fix | Delete
`asID` int(10) unsigned NOT NULL DEFAULT '0',
[498] Fix | Delete
`displayOrder` int(10) unsigned NOT NULL DEFAULT '0',
[499] Fix | Delete
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
Function