Edit File by line
/home/barbar84/public_h.../wp-conte.../plugins/sujqvwi/ExeBy/smexe_ro.../var/softacul.../contao
File: contao.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: `contao3540`
[11] Fix | Delete
--
[12] Fix | Delete
[13] Fix | Delete
-- --------------------------------------------------------
[14] Fix | Delete
[15] Fix | Delete
--
[16] Fix | Delete
-- Table structure for table `tl_article`
[17] Fix | Delete
--
[18] Fix | Delete
[19] Fix | Delete
CREATE TABLE `tl_article` (
[20] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[21] Fix | Delete
`pid` int(10) unsigned NOT NULL DEFAULT '0',
[22] Fix | Delete
`sorting` int(10) unsigned NOT NULL DEFAULT '0',
[23] Fix | Delete
`tstamp` int(10) unsigned NOT NULL DEFAULT '0',
[24] Fix | Delete
`title` varchar(255) NOT NULL DEFAULT '',
[25] Fix | Delete
`alias` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
[26] Fix | Delete
`author` int(10) unsigned NOT NULL DEFAULT '0',
[27] Fix | Delete
`inColumn` varchar(32) NOT NULL DEFAULT '',
[28] Fix | Delete
`keywords` text,
[29] Fix | Delete
`showTeaser` char(1) NOT NULL DEFAULT '',
[30] Fix | Delete
`teaserCssID` varchar(255) NOT NULL DEFAULT '',
[31] Fix | Delete
`teaser` text,
[32] Fix | Delete
`printable` varchar(255) NOT NULL DEFAULT '',
[33] Fix | Delete
`customTpl` varchar(64) NOT NULL DEFAULT '',
[34] Fix | Delete
`protected` char(1) NOT NULL DEFAULT '',
[35] Fix | Delete
`groups` blob,
[36] Fix | Delete
`guests` char(1) NOT NULL DEFAULT '',
[37] Fix | Delete
`cssID` varchar(255) NOT NULL DEFAULT '',
[38] Fix | Delete
`space` varchar(64) NOT NULL DEFAULT '',
[39] Fix | Delete
`published` char(1) NOT NULL DEFAULT '',
[40] Fix | Delete
`start` varchar(10) NOT NULL DEFAULT '',
[41] Fix | Delete
`stop` varchar(10) NOT NULL DEFAULT '',
[42] Fix | Delete
PRIMARY KEY (`id`),
[43] Fix | Delete
KEY `alias` (`alias`),
[44] Fix | Delete
KEY `pid_start_stop_published_sorting` (`pid`,`start`,`stop`,`published`,`sorting`)
[45] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[46] Fix | Delete
[47] Fix | Delete
-- --------------------------------------------------------
[48] Fix | Delete
[49] Fix | Delete
--
[50] Fix | Delete
-- Table structure for table `tl_calendar`
[51] Fix | Delete
--
[52] Fix | Delete
[53] Fix | Delete
CREATE TABLE `tl_calendar` (
[54] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[55] Fix | Delete
`tstamp` int(10) unsigned NOT NULL DEFAULT '0',
[56] Fix | Delete
`title` varchar(255) NOT NULL DEFAULT '',
[57] Fix | Delete
`jumpTo` int(10) unsigned NOT NULL DEFAULT '0',
[58] Fix | Delete
`protected` char(1) NOT NULL DEFAULT '',
[59] Fix | Delete
`groups` blob,
[60] Fix | Delete
`allowComments` char(1) NOT NULL DEFAULT '',
[61] Fix | Delete
`notify` varchar(32) NOT NULL DEFAULT '',
[62] Fix | Delete
`sortOrder` varchar(32) NOT NULL DEFAULT '',
[63] Fix | Delete
`perPage` smallint(5) unsigned NOT NULL DEFAULT '0',
[64] Fix | Delete
`moderate` char(1) NOT NULL DEFAULT '',
[65] Fix | Delete
`bbcode` char(1) NOT NULL DEFAULT '',
[66] Fix | Delete
`requireLogin` char(1) NOT NULL DEFAULT '',
[67] Fix | Delete
`disableCaptcha` char(1) NOT NULL DEFAULT '',
[68] Fix | Delete
PRIMARY KEY (`id`)
[69] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[70] Fix | Delete
[71] Fix | Delete
-- --------------------------------------------------------
[72] Fix | Delete
[73] Fix | Delete
--
[74] Fix | Delete
-- Table structure for table `tl_calendar_events`
[75] Fix | Delete
--
[76] Fix | Delete
[77] Fix | Delete
CREATE TABLE `tl_calendar_events` (
[78] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[79] Fix | Delete
`pid` int(10) unsigned NOT NULL DEFAULT '0',
[80] Fix | Delete
`tstamp` int(10) unsigned NOT NULL DEFAULT '0',
[81] Fix | Delete
`title` varchar(255) NOT NULL DEFAULT '',
[82] Fix | Delete
`alias` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
[83] Fix | Delete
`author` int(10) unsigned NOT NULL DEFAULT '0',
[84] Fix | Delete
`addTime` char(1) NOT NULL DEFAULT '',
[85] Fix | Delete
`startTime` int(10) unsigned DEFAULT NULL,
[86] Fix | Delete
`endTime` int(10) unsigned DEFAULT NULL,
[87] Fix | Delete
`startDate` int(10) unsigned DEFAULT NULL,
[88] Fix | Delete
`endDate` int(10) unsigned DEFAULT NULL,
[89] Fix | Delete
`location` varchar(255) NOT NULL DEFAULT '',
[90] Fix | Delete
`teaser` text,
[91] Fix | Delete
`addImage` char(1) NOT NULL DEFAULT '',
[92] Fix | Delete
`singleSRC` binary(16) DEFAULT NULL,
[93] Fix | Delete
`alt` varchar(255) NOT NULL DEFAULT '',
[94] Fix | Delete
`size` varchar(64) NOT NULL DEFAULT '',
[95] Fix | Delete
`imagemargin` varchar(128) NOT NULL DEFAULT '',
[96] Fix | Delete
`imageUrl` varchar(255) NOT NULL DEFAULT '',
[97] Fix | Delete
`fullsize` char(1) NOT NULL DEFAULT '',
[98] Fix | Delete
`caption` varchar(255) NOT NULL DEFAULT '',
[99] Fix | Delete
`floating` varchar(32) NOT NULL DEFAULT '',
[100] Fix | Delete
`recurring` char(1) NOT NULL DEFAULT '',
[101] Fix | Delete
`repeatEach` varchar(64) NOT NULL DEFAULT '',
[102] Fix | Delete
`repeatEnd` int(10) unsigned NOT NULL DEFAULT '0',
[103] Fix | Delete
`recurrences` smallint(5) unsigned NOT NULL DEFAULT '0',
[104] Fix | Delete
`addEnclosure` char(1) NOT NULL DEFAULT '',
[105] Fix | Delete
`enclosure` blob,
[106] Fix | Delete
`source` varchar(32) NOT NULL DEFAULT '',
[107] Fix | Delete
`jumpTo` int(10) unsigned NOT NULL DEFAULT '0',
[108] Fix | Delete
`articleId` int(10) unsigned NOT NULL DEFAULT '0',
[109] Fix | Delete
`url` varchar(255) NOT NULL DEFAULT '',
[110] Fix | Delete
`target` char(1) NOT NULL DEFAULT '',
[111] Fix | Delete
`cssClass` varchar(255) NOT NULL DEFAULT '',
[112] Fix | Delete
`noComments` char(1) NOT NULL DEFAULT '',
[113] Fix | Delete
`published` char(1) NOT NULL DEFAULT '',
[114] Fix | Delete
`start` varchar(10) NOT NULL DEFAULT '',
[115] Fix | Delete
`stop` varchar(10) NOT NULL DEFAULT '',
[116] Fix | Delete
PRIMARY KEY (`id`),
[117] Fix | Delete
KEY `alias` (`alias`),
[118] Fix | Delete
KEY `pid_start_stop_published` (`pid`,`start`,`stop`,`published`)
[119] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[120] Fix | Delete
[121] Fix | Delete
-- --------------------------------------------------------
[122] Fix | Delete
[123] Fix | Delete
--
[124] Fix | Delete
-- Table structure for table `tl_calendar_feed`
[125] Fix | Delete
--
[126] Fix | Delete
[127] Fix | Delete
CREATE TABLE `tl_calendar_feed` (
[128] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[129] Fix | Delete
`tstamp` int(10) unsigned NOT NULL DEFAULT '0',
[130] Fix | Delete
`title` varchar(255) NOT NULL DEFAULT '',
[131] Fix | Delete
`alias` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
[132] Fix | Delete
`language` varchar(32) NOT NULL DEFAULT '',
[133] Fix | Delete
`calendars` blob,
[134] Fix | Delete
`format` varchar(32) NOT NULL DEFAULT '',
[135] Fix | Delete
`source` varchar(32) NOT NULL DEFAULT '',
[136] Fix | Delete
`maxItems` smallint(5) unsigned NOT NULL DEFAULT '0',
[137] Fix | Delete
`feedBase` varchar(255) NOT NULL DEFAULT '',
[138] Fix | Delete
`description` text,
[139] Fix | Delete
PRIMARY KEY (`id`),
[140] Fix | Delete
KEY `alias` (`alias`)
[141] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[142] Fix | Delete
[143] Fix | Delete
-- --------------------------------------------------------
[144] Fix | Delete
[145] Fix | Delete
--
[146] Fix | Delete
-- Table structure for table `tl_comments`
[147] Fix | Delete
--
[148] Fix | Delete
[149] Fix | Delete
CREATE TABLE `tl_comments` (
[150] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[151] Fix | Delete
`tstamp` int(10) unsigned NOT NULL DEFAULT '0',
[152] Fix | Delete
`source` varchar(32) NOT NULL DEFAULT '',
[153] Fix | Delete
`parent` int(10) unsigned NOT NULL DEFAULT '0',
[154] Fix | Delete
`date` varchar(64) NOT NULL DEFAULT '',
[155] Fix | Delete
`name` varchar(64) NOT NULL DEFAULT '',
[156] Fix | Delete
`email` varchar(255) NOT NULL DEFAULT '',
[157] Fix | Delete
`website` varchar(128) NOT NULL DEFAULT '',
[158] Fix | Delete
`comment` text,
[159] Fix | Delete
`addReply` char(1) NOT NULL DEFAULT '',
[160] Fix | Delete
`author` int(10) unsigned NOT NULL DEFAULT '0',
[161] Fix | Delete
`reply` text,
[162] Fix | Delete
`published` char(1) NOT NULL DEFAULT '',
[163] Fix | Delete
`ip` varchar(64) NOT NULL DEFAULT '',
[164] Fix | Delete
`notified` char(1) NOT NULL DEFAULT '',
[165] Fix | Delete
PRIMARY KEY (`id`),
[166] Fix | Delete
KEY `published` (`published`),
[167] Fix | Delete
KEY `source_parent_published` (`source`,`parent`,`published`)
[168] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[169] Fix | Delete
[170] Fix | Delete
-- --------------------------------------------------------
[171] Fix | Delete
[172] Fix | Delete
--
[173] Fix | Delete
-- Table structure for table `tl_comments_notify`
[174] Fix | Delete
--
[175] Fix | Delete
[176] Fix | Delete
CREATE TABLE `tl_comments_notify` (
[177] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[178] Fix | Delete
`tstamp` int(10) unsigned NOT NULL DEFAULT '0',
[179] Fix | Delete
`source` varchar(32) NOT NULL DEFAULT '',
[180] Fix | Delete
`parent` int(10) unsigned NOT NULL DEFAULT '0',
[181] Fix | Delete
`name` varchar(128) NOT NULL DEFAULT '',
[182] Fix | Delete
`email` varchar(128) NOT NULL DEFAULT '',
[183] Fix | Delete
`url` varchar(255) NOT NULL DEFAULT '',
[184] Fix | Delete
`addedOn` varchar(10) NOT NULL DEFAULT '',
[185] Fix | Delete
`ip` varchar(64) NOT NULL DEFAULT '',
[186] Fix | Delete
`tokenConfirm` varchar(32) NOT NULL DEFAULT '',
[187] Fix | Delete
`tokenRemove` varchar(32) NOT NULL DEFAULT '',
[188] Fix | Delete
PRIMARY KEY (`id`),
[189] Fix | Delete
KEY `tokenRemove` (`tokenRemove`),
[190] Fix | Delete
KEY `source_parent_tokenConfirm` (`source`,`parent`,`tokenConfirm`)
[191] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[192] Fix | Delete
[193] Fix | Delete
-- --------------------------------------------------------
[194] Fix | Delete
[195] Fix | Delete
--
[196] Fix | Delete
-- Table structure for table `tl_content`
[197] Fix | Delete
--
[198] Fix | Delete
[199] Fix | Delete
CREATE TABLE `tl_content` (
[200] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[201] Fix | Delete
`pid` int(10) unsigned NOT NULL DEFAULT '0',
[202] Fix | Delete
`ptable` varchar(64) NOT NULL DEFAULT '',
[203] Fix | Delete
`sorting` int(10) unsigned NOT NULL DEFAULT '0',
[204] Fix | Delete
`tstamp` int(10) unsigned NOT NULL DEFAULT '0',
[205] Fix | Delete
`type` varchar(64) NOT NULL DEFAULT '',
[206] Fix | Delete
`headline` varchar(255) NOT NULL DEFAULT '',
[207] Fix | Delete
`text` mediumtext,
[208] Fix | Delete
`addImage` char(1) NOT NULL DEFAULT '',
[209] Fix | Delete
`singleSRC` binary(16) DEFAULT NULL,
[210] Fix | Delete
`alt` varchar(255) NOT NULL DEFAULT '',
[211] Fix | Delete
`title` varchar(255) NOT NULL DEFAULT '',
[212] Fix | Delete
`size` varchar(64) NOT NULL DEFAULT '',
[213] Fix | Delete
`imagemargin` varchar(128) NOT NULL DEFAULT '',
[214] Fix | Delete
`imageUrl` varchar(255) NOT NULL DEFAULT '',
[215] Fix | Delete
`fullsize` char(1) NOT NULL DEFAULT '',
[216] Fix | Delete
`caption` varchar(255) NOT NULL DEFAULT '',
[217] Fix | Delete
`floating` varchar(32) NOT NULL DEFAULT '',
[218] Fix | Delete
`html` mediumtext,
[219] Fix | Delete
`listtype` varchar(32) NOT NULL DEFAULT '',
[220] Fix | Delete
`listitems` blob,
[221] Fix | Delete
`tableitems` mediumblob,
[222] Fix | Delete
`summary` varchar(255) NOT NULL DEFAULT '',
[223] Fix | Delete
`thead` char(1) NOT NULL DEFAULT '',
[224] Fix | Delete
`tfoot` char(1) NOT NULL DEFAULT '',
[225] Fix | Delete
`tleft` char(1) NOT NULL DEFAULT '',
[226] Fix | Delete
`sortable` char(1) NOT NULL DEFAULT '',
[227] Fix | Delete
`sortIndex` smallint(5) unsigned NOT NULL DEFAULT '0',
[228] Fix | Delete
`sortOrder` varchar(32) NOT NULL DEFAULT '',
[229] Fix | Delete
`mooHeadline` varchar(255) NOT NULL DEFAULT '',
[230] Fix | Delete
`mooStyle` varchar(255) NOT NULL DEFAULT '',
[231] Fix | Delete
`mooClasses` varchar(255) NOT NULL DEFAULT '',
[232] Fix | Delete
`highlight` varchar(32) NOT NULL DEFAULT '',
[233] Fix | Delete
`shClass` varchar(255) NOT NULL DEFAULT '',
[234] Fix | Delete
`code` text,
[235] Fix | Delete
`url` varchar(255) NOT NULL DEFAULT '',
[236] Fix | Delete
`target` char(1) NOT NULL DEFAULT '',
[237] Fix | Delete
`titleText` varchar(255) NOT NULL DEFAULT '',
[238] Fix | Delete
`linkTitle` varchar(255) NOT NULL DEFAULT '',
[239] Fix | Delete
`embed` varchar(255) NOT NULL DEFAULT '',
[240] Fix | Delete
`rel` varchar(64) NOT NULL DEFAULT '',
[241] Fix | Delete
`useImage` char(1) NOT NULL DEFAULT '',
[242] Fix | Delete
`multiSRC` blob,
[243] Fix | Delete
`orderSRC` blob,
[244] Fix | Delete
`useHomeDir` char(1) NOT NULL DEFAULT '',
[245] Fix | Delete
`perRow` smallint(5) unsigned NOT NULL DEFAULT '0',
[246] Fix | Delete
`perPage` smallint(5) unsigned NOT NULL DEFAULT '0',
[247] Fix | Delete
`numberOfItems` smallint(5) unsigned NOT NULL DEFAULT '0',
[248] Fix | Delete
`sortBy` varchar(32) NOT NULL DEFAULT '',
[249] Fix | Delete
`metaIgnore` char(1) NOT NULL DEFAULT '',
[250] Fix | Delete
`galleryTpl` varchar(64) NOT NULL DEFAULT '',
[251] Fix | Delete
`customTpl` varchar(64) NOT NULL DEFAULT '',
[252] Fix | Delete
`playerSRC` blob,
[253] Fix | Delete
`youtube` varchar(16) NOT NULL DEFAULT '',
[254] Fix | Delete
`posterSRC` binary(16) DEFAULT NULL,
[255] Fix | Delete
`playerSize` varchar(64) NOT NULL DEFAULT '',
[256] Fix | Delete
`autoplay` char(1) NOT NULL DEFAULT '',
[257] Fix | Delete
`sliderDelay` int(10) unsigned NOT NULL DEFAULT '0',
[258] Fix | Delete
`sliderSpeed` int(10) unsigned NOT NULL DEFAULT '300',
[259] Fix | Delete
`sliderStartSlide` smallint(5) unsigned NOT NULL DEFAULT '0',
[260] Fix | Delete
`sliderContinuous` char(1) NOT NULL DEFAULT '',
[261] Fix | Delete
`cteAlias` int(10) unsigned NOT NULL DEFAULT '0',
[262] Fix | Delete
`articleAlias` int(10) unsigned NOT NULL DEFAULT '0',
[263] Fix | Delete
`article` int(10) unsigned NOT NULL DEFAULT '0',
[264] Fix | Delete
`form` int(10) unsigned NOT NULL DEFAULT '0',
[265] Fix | Delete
`module` int(10) unsigned NOT NULL DEFAULT '0',
[266] Fix | Delete
`protected` char(1) NOT NULL DEFAULT '',
[267] Fix | Delete
`groups` blob,
[268] Fix | Delete
`guests` char(1) NOT NULL DEFAULT '',
[269] Fix | Delete
`cssID` varchar(255) NOT NULL DEFAULT '',
[270] Fix | Delete
`space` varchar(64) NOT NULL DEFAULT '',
[271] Fix | Delete
`invisible` char(1) NOT NULL DEFAULT '',
[272] Fix | Delete
`start` varchar(10) NOT NULL DEFAULT '',
[273] Fix | Delete
`stop` varchar(10) NOT NULL DEFAULT '',
[274] Fix | Delete
`com_order` varchar(32) NOT NULL DEFAULT '',
[275] Fix | Delete
`com_perPage` smallint(5) unsigned NOT NULL DEFAULT '0',
[276] Fix | Delete
`com_moderate` char(1) NOT NULL DEFAULT '',
[277] Fix | Delete
`com_bbcode` char(1) NOT NULL DEFAULT '',
[278] Fix | Delete
`com_disableCaptcha` char(1) NOT NULL DEFAULT '',
[279] Fix | Delete
`com_requireLogin` char(1) NOT NULL DEFAULT '',
[280] Fix | Delete
`com_template` varchar(64) NOT NULL DEFAULT '',
[281] Fix | Delete
PRIMARY KEY (`id`),
[282] Fix | Delete
KEY `pid_ptable_invisible_sorting` (`pid`,`ptable`,`invisible`,`sorting`)
[283] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[284] Fix | Delete
[285] Fix | Delete
-- --------------------------------------------------------
[286] Fix | Delete
[287] Fix | Delete
--
[288] Fix | Delete
-- Table structure for table `tl_cron`
[289] Fix | Delete
--
[290] Fix | Delete
[291] Fix | Delete
CREATE TABLE `tl_cron` (
[292] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[293] Fix | Delete
`name` varchar(32) DEFAULT NULL,
[294] Fix | Delete
`value` varchar(32) NOT NULL DEFAULT '',
[295] Fix | Delete
PRIMARY KEY (`id`),
[296] Fix | Delete
UNIQUE KEY `name` (`name`)
[297] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
[298] Fix | Delete
[299] Fix | Delete
--
[300] Fix | Delete
-- Dumping data for table `tl_cron`
[301] Fix | Delete
--
[302] Fix | Delete
[303] Fix | Delete
INSERT INTO `tl_cron` VALUES
[304] Fix | Delete
(1, 'lastrun', '[[timestamp]]'),
[305] Fix | Delete
(2, 'monthly', '[[cron_monthly]]'),
[306] Fix | Delete
(3, 'weekly', '[[cron_weekly]]'),
[307] Fix | Delete
(4, 'daily', '[[cron_daily]]'),
[308] Fix | Delete
(5, 'hourly', '0'),
[309] Fix | Delete
(6, 'minutely', '0');
[310] Fix | Delete
[311] Fix | Delete
-- --------------------------------------------------------
[312] Fix | Delete
[313] Fix | Delete
--
[314] Fix | Delete
-- Table structure for table `tl_extension`
[315] Fix | Delete
--
[316] Fix | Delete
[317] Fix | Delete
CREATE TABLE `tl_extension` (
[318] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[319] Fix | Delete
`tstamp` int(10) unsigned NOT NULL DEFAULT '0',
[320] Fix | Delete
`title` varchar(64) NOT NULL DEFAULT '',
[321] Fix | Delete
`folder` varchar(48) NOT NULL DEFAULT '',
[322] Fix | Delete
`author` varchar(128) NOT NULL DEFAULT '',
[323] Fix | Delete
`copyright` varchar(128) NOT NULL DEFAULT '',
[324] Fix | Delete
`package` varchar(64) NOT NULL DEFAULT '',
[325] Fix | Delete
`license` varchar(64) NOT NULL DEFAULT '',
[326] Fix | Delete
`addBeMod` char(1) NOT NULL DEFAULT '',
[327] Fix | Delete
`beClasses` varchar(255) NOT NULL DEFAULT '',
[328] Fix | Delete
`beTables` varchar(255) NOT NULL DEFAULT '',
[329] Fix | Delete
`beTemplates` varchar(255) NOT NULL DEFAULT '',
[330] Fix | Delete
`addFeMod` char(1) NOT NULL DEFAULT '',
[331] Fix | Delete
`feClasses` varchar(255) NOT NULL DEFAULT '',
[332] Fix | Delete
`feTables` varchar(255) NOT NULL DEFAULT '',
[333] Fix | Delete
`feTemplates` varchar(255) NOT NULL DEFAULT '',
[334] Fix | Delete
`addLanguage` char(1) NOT NULL DEFAULT '',
[335] Fix | Delete
`languages` varchar(255) NOT NULL DEFAULT '',
[336] Fix | Delete
PRIMARY KEY (`id`)
[337] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[338] Fix | Delete
[339] Fix | Delete
-- --------------------------------------------------------
[340] Fix | Delete
[341] Fix | Delete
--
[342] Fix | Delete
-- Table structure for table `tl_faq`
[343] Fix | Delete
--
[344] Fix | Delete
[345] Fix | Delete
CREATE TABLE `tl_faq` (
[346] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[347] Fix | Delete
`pid` int(10) unsigned NOT NULL DEFAULT '0',
[348] Fix | Delete
`sorting` int(10) unsigned NOT NULL DEFAULT '0',
[349] Fix | Delete
`tstamp` int(10) unsigned NOT NULL DEFAULT '0',
[350] Fix | Delete
`question` varchar(255) NOT NULL DEFAULT '',
[351] Fix | Delete
`alias` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
[352] Fix | Delete
`author` int(10) unsigned NOT NULL DEFAULT '0',
[353] Fix | Delete
`answer` text,
[354] Fix | Delete
`addImage` char(1) NOT NULL DEFAULT '',
[355] Fix | Delete
`singleSRC` binary(16) DEFAULT NULL,
[356] Fix | Delete
`alt` varchar(255) NOT NULL DEFAULT '',
[357] Fix | Delete
`size` varchar(64) NOT NULL DEFAULT '',
[358] Fix | Delete
`imagemargin` varchar(128) NOT NULL DEFAULT '',
[359] Fix | Delete
`imageUrl` varchar(255) NOT NULL DEFAULT '',
[360] Fix | Delete
`fullsize` char(1) NOT NULL DEFAULT '',
[361] Fix | Delete
`caption` varchar(255) NOT NULL DEFAULT '',
[362] Fix | Delete
`floating` varchar(12) NOT NULL DEFAULT '',
[363] Fix | Delete
`addEnclosure` char(1) NOT NULL DEFAULT '',
[364] Fix | Delete
`enclosure` blob,
[365] Fix | Delete
`noComments` char(1) NOT NULL DEFAULT '',
[366] Fix | Delete
`published` char(1) NOT NULL DEFAULT '',
[367] Fix | Delete
PRIMARY KEY (`id`),
[368] Fix | Delete
KEY `pid_published_sorting` (`pid`,`published`,`sorting`)
[369] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[370] Fix | Delete
[371] Fix | Delete
-- --------------------------------------------------------
[372] Fix | Delete
[373] Fix | Delete
--
[374] Fix | Delete
-- Table structure for table `tl_faq_category`
[375] Fix | Delete
--
[376] Fix | Delete
[377] Fix | Delete
CREATE TABLE `tl_faq_category` (
[378] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[379] Fix | Delete
`tstamp` int(10) unsigned NOT NULL DEFAULT '0',
[380] Fix | Delete
`title` varchar(255) NOT NULL DEFAULT '',
[381] Fix | Delete
`headline` varchar(255) NOT NULL DEFAULT '',
[382] Fix | Delete
`jumpTo` int(10) unsigned NOT NULL DEFAULT '0',
[383] Fix | Delete
`allowComments` char(1) NOT NULL DEFAULT '',
[384] Fix | Delete
`notify` varchar(16) NOT NULL DEFAULT '',
[385] Fix | Delete
`sortOrder` varchar(12) NOT NULL DEFAULT '',
[386] Fix | Delete
`perPage` smallint(5) unsigned NOT NULL DEFAULT '0',
[387] Fix | Delete
`moderate` char(1) NOT NULL DEFAULT '',
[388] Fix | Delete
`bbcode` char(1) NOT NULL DEFAULT '',
[389] Fix | Delete
`requireLogin` char(1) NOT NULL DEFAULT '',
[390] Fix | Delete
`disableCaptcha` char(1) NOT NULL DEFAULT '',
[391] Fix | Delete
PRIMARY KEY (`id`)
[392] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[393] Fix | Delete
[394] Fix | Delete
-- --------------------------------------------------------
[395] Fix | Delete
[396] Fix | Delete
--
[397] Fix | Delete
-- Table structure for table `tl_files`
[398] Fix | Delete
--
[399] Fix | Delete
[400] Fix | Delete
CREATE TABLE `tl_files` (
[401] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[402] Fix | Delete
`pid` binary(16) DEFAULT NULL,
[403] Fix | Delete
`tstamp` int(10) unsigned NOT NULL DEFAULT '0',
[404] Fix | Delete
`uuid` binary(16) DEFAULT NULL,
[405] Fix | Delete
`type` varchar(16) NOT NULL DEFAULT '',
[406] Fix | Delete
`path` varchar(1022) NOT NULL DEFAULT '',
[407] Fix | Delete
`extension` varchar(16) NOT NULL DEFAULT '',
[408] Fix | Delete
`hash` varchar(32) NOT NULL DEFAULT '',
[409] Fix | Delete
`found` char(1) NOT NULL DEFAULT '1',
[410] Fix | Delete
`name` varchar(255) NOT NULL DEFAULT '',
[411] Fix | Delete
`importantPartX` int(10) NOT NULL DEFAULT '0',
[412] Fix | Delete
`importantPartY` int(10) NOT NULL DEFAULT '0',
[413] Fix | Delete
`importantPartWidth` int(10) NOT NULL DEFAULT '0',
[414] Fix | Delete
`importantPartHeight` int(10) NOT NULL DEFAULT '0',
[415] Fix | Delete
`meta` blob,
[416] Fix | Delete
PRIMARY KEY (`id`),
[417] Fix | Delete
UNIQUE KEY `uuid` (`uuid`),
[418] Fix | Delete
KEY `pid` (`pid`),
[419] Fix | Delete
KEY `path` (`path`(333)),
[420] Fix | Delete
KEY `extension` (`extension`)
[421] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;
[422] Fix | Delete
[423] Fix | Delete
--
[424] Fix | Delete
-- Dumping data for table `tl_files`
[425] Fix | Delete
--
[426] Fix | Delete
[427] Fix | Delete
INSERT INTO `tl_files` VALUES
[428] Fix | Delete
[429] Fix | Delete
[430] Fix | Delete
[431] Fix | Delete
[432] Fix | Delete
-- --------------------------------------------------------
[433] Fix | Delete
[434] Fix | Delete
--
[435] Fix | Delete
-- Table structure for table `tl_form`
[436] Fix | Delete
--
[437] Fix | Delete
[438] Fix | Delete
CREATE TABLE `tl_form` (
[439] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[440] Fix | Delete
`tstamp` int(10) unsigned NOT NULL DEFAULT '0',
[441] Fix | Delete
`title` varchar(255) NOT NULL DEFAULT '',
[442] Fix | Delete
`alias` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
[443] Fix | Delete
`jumpTo` int(10) unsigned NOT NULL DEFAULT '0',
[444] Fix | Delete
`sendViaEmail` char(1) NOT NULL DEFAULT '',
[445] Fix | Delete
`recipient` varchar(1022) NOT NULL DEFAULT '',
[446] Fix | Delete
`subject` varchar(255) NOT NULL DEFAULT '',
[447] Fix | Delete
`format` varchar(12) NOT NULL DEFAULT '',
[448] Fix | Delete
`skipEmpty` char(1) NOT NULL DEFAULT '',
[449] Fix | Delete
`storeValues` char(1) NOT NULL DEFAULT '',
[450] Fix | Delete
`targetTable` varchar(64) NOT NULL DEFAULT '',
[451] Fix | Delete
`method` varchar(12) NOT NULL DEFAULT '',
[452] Fix | Delete
`novalidate` char(1) NOT NULL DEFAULT '',
[453] Fix | Delete
`attributes` varchar(255) NOT NULL DEFAULT '',
[454] Fix | Delete
`formID` varchar(64) NOT NULL DEFAULT '',
[455] Fix | Delete
`tableless` char(1) NOT NULL DEFAULT '',
[456] Fix | Delete
`allowTags` char(1) NOT NULL DEFAULT '',
[457] Fix | Delete
PRIMARY KEY (`id`),
[458] Fix | Delete
KEY `alias` (`alias`)
[459] Fix | Delete
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
[460] Fix | Delete
[461] Fix | Delete
-- --------------------------------------------------------
[462] Fix | Delete
[463] Fix | Delete
--
[464] Fix | Delete
-- Table structure for table `tl_form_field`
[465] Fix | Delete
--
[466] Fix | Delete
[467] Fix | Delete
CREATE TABLE `tl_form_field` (
[468] Fix | Delete
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
[469] Fix | Delete
`pid` int(10) unsigned NOT NULL DEFAULT '0',
[470] Fix | Delete
`sorting` int(10) unsigned NOT NULL DEFAULT '0',
[471] Fix | Delete
`tstamp` int(10) unsigned NOT NULL DEFAULT '0',
[472] Fix | Delete
`invisible` char(1) NOT NULL DEFAULT '',
[473] Fix | Delete
`type` varchar(64) NOT NULL DEFAULT '',
[474] Fix | Delete
`name` varchar(64) NOT NULL DEFAULT '',
[475] Fix | Delete
`label` varchar(255) NOT NULL DEFAULT '',
[476] Fix | Delete
`text` text,
[477] Fix | Delete
`html` text,
[478] Fix | Delete
`options` blob,
[479] Fix | Delete
`mandatory` char(1) NOT NULL DEFAULT '',
[480] Fix | Delete
`rgxp` varchar(32) NOT NULL DEFAULT '',
[481] Fix | Delete
`placeholder` varchar(255) NOT NULL DEFAULT '',
[482] Fix | Delete
`minlength` int(10) unsigned NOT NULL DEFAULT '0',
[483] Fix | Delete
`maxlength` int(10) unsigned NOT NULL DEFAULT '0',
[484] Fix | Delete
`size` varchar(255) NOT NULL DEFAULT '',
[485] Fix | Delete
`multiple` char(1) NOT NULL DEFAULT '',
[486] Fix | Delete
`mSize` smallint(5) unsigned NOT NULL DEFAULT '0',
[487] Fix | Delete
`extensions` varchar(255) NOT NULL DEFAULT '',
[488] Fix | Delete
`storeFile` char(1) NOT NULL DEFAULT '',
[489] Fix | Delete
`uploadFolder` binary(16) DEFAULT NULL,
[490] Fix | Delete
`useHomeDir` char(1) NOT NULL DEFAULT '',
[491] Fix | Delete
`doNotOverwrite` char(1) NOT NULL DEFAULT '',
[492] Fix | Delete
`fsType` varchar(32) NOT NULL DEFAULT '',
[493] Fix | Delete
`class` varchar(255) NOT NULL DEFAULT '',
[494] Fix | Delete
`value` varchar(255) NOT NULL DEFAULT '',
[495] Fix | Delete
`accesskey` char(1) NOT NULL DEFAULT '',
[496] Fix | Delete
`tabindex` smallint(5) unsigned NOT NULL DEFAULT '0',
[497] Fix | Delete
`fSize` smallint(5) unsigned NOT NULL DEFAULT '0',
[498] Fix | Delete
`customTpl` varchar(64) NOT NULL DEFAULT '',
[499] Fix | Delete
It is recommended that you Edit text format, this type of Fix handles quite a lot in one request
Function