Edit File by line

[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: `lime681`

[11] Fix | Delete

[12] Fix | Delete

[13] Fix | Delete

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

[14] Fix | Delete

[15] Fix | Delete

[16] Fix | Delete

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

[17] Fix | Delete

[18] Fix | Delete

[19] Fix | Delete

CREATE TABLE `[[dbprefix]]answers` (

[20] Fix | Delete

`aid` int(11) NOT NULL AUTO_INCREMENT,

[21] Fix | Delete

`qid` int(11) NOT NULL,

[22] Fix | Delete

`code` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL,

[23] Fix | Delete

`sortorder` int(11) NOT NULL,

[24] Fix | Delete

`assessment_value` int(11) NOT NULL DEFAULT '0',

[25] Fix | Delete

`scale_id` int(11) NOT NULL DEFAULT '0',

[26] Fix | Delete

PRIMARY KEY (`aid`),

[27] Fix | Delete

KEY `[[dbprefix]]answers_idx` (`qid`,`code`,`scale_id`),

[28] Fix | Delete

KEY `[[dbprefix]]answers_idx2` (`sortorder`)

[29] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[30] Fix | Delete

[31] Fix | Delete

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

[32] Fix | Delete

[33] Fix | Delete

[34] Fix | Delete

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

[35] Fix | Delete

[36] Fix | Delete

[37] Fix | Delete

CREATE TABLE `[[dbprefix]]answer_l10ns` (

[38] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[39] Fix | Delete

`aid` int(11) NOT NULL,

[40] Fix | Delete

`answer` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,

[41] Fix | Delete

`language` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,

[42] Fix | Delete

PRIMARY KEY (`id`),

[43] Fix | Delete

UNIQUE KEY `[[dbprefix]]answer_l10ns_idx` (`aid`,`language`)

[44] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[45] Fix | Delete

[46] Fix | Delete

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

[47] Fix | Delete

[48] Fix | Delete

[49] Fix | Delete

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

[50] Fix | Delete

[51] Fix | Delete

[52] Fix | Delete

CREATE TABLE `[[dbprefix]]archived_table_settings` (

[53] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[54] Fix | Delete

`survey_id` int(11) NOT NULL,

[55] Fix | Delete

`user_id` int(11) NOT NULL,

[56] Fix | Delete

`tbl_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

[57] Fix | Delete

`tbl_type` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,

[58] Fix | Delete

`created` datetime NOT NULL,

[59] Fix | Delete

`properties` text COLLATE utf8mb4_unicode_ci NOT NULL,

[60] Fix | Delete

`attributes` text COLLATE utf8mb4_unicode_ci,

[61] Fix | Delete

PRIMARY KEY (`id`)

[62] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[63] Fix | Delete

[64] Fix | Delete

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

[65] Fix | Delete

[66] Fix | Delete

[67] Fix | Delete

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

[68] Fix | Delete

[69] Fix | Delete

[70] Fix | Delete

CREATE TABLE `[[dbprefix]]assessments` (

[71] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[72] Fix | Delete

`sid` int(11) NOT NULL DEFAULT '0',

[73] Fix | Delete

`scope` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL,

[74] Fix | Delete

`gid` int(11) NOT NULL DEFAULT '0',

[75] Fix | Delete

`name` text COLLATE utf8mb4_unicode_ci NOT NULL,

[76] Fix | Delete

`minimum` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,

[77] Fix | Delete

`maximum` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,

[78] Fix | Delete

`message` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,

[79] Fix | Delete

`language` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'en',

[80] Fix | Delete

PRIMARY KEY (`id`,`language`),

[81] Fix | Delete

KEY `[[dbprefix]]assessments_idx2` (`sid`),

[82] Fix | Delete

KEY `[[dbprefix]]assessments_idx3` (`gid`)

[83] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[84] Fix | Delete

[85] Fix | Delete

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

[86] Fix | Delete

[87] Fix | Delete

[88] Fix | Delete

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

[89] Fix | Delete

[90] Fix | Delete

[91] Fix | Delete

CREATE TABLE `[[dbprefix]]asset_version` (

[92] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[93] Fix | Delete

`path` text COLLATE utf8mb4_unicode_ci NOT NULL,

[94] Fix | Delete

`version` int(11) NOT NULL,

[95] Fix | Delete

PRIMARY KEY (`id`)

[96] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[97] Fix | Delete

[98] Fix | Delete

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

[99] Fix | Delete

[100] Fix | Delete

[101] Fix | Delete

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

[102] Fix | Delete

[103] Fix | Delete

[104] Fix | Delete

CREATE TABLE `[[dbprefix]]boxes` (

[105] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[106] Fix | Delete

`position` int(11) DEFAULT NULL,

[107] Fix | Delete

`url` text COLLATE utf8mb4_unicode_ci NOT NULL,

[108] Fix | Delete

`title` text COLLATE utf8mb4_unicode_ci NOT NULL,

[109] Fix | Delete

`buttontext` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[110] Fix | Delete

`ico` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[111] Fix | Delete

`desc` text COLLATE utf8mb4_unicode_ci NOT NULL,

[112] Fix | Delete

`page` text COLLATE utf8mb4_unicode_ci NOT NULL,

[113] Fix | Delete

`usergroup` int(11) NOT NULL,

[114] Fix | Delete

PRIMARY KEY (`id`)

[115] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=7 ;

[116] Fix | Delete

[117] Fix | Delete

[118] Fix | Delete

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

[119] Fix | Delete

[120] Fix | Delete

[121] Fix | Delete

INSERT INTO `[[dbprefix]]boxes` VALUES

[122] Fix | Delete

(1, 1, 'surveyAdministration/newSurvey', 'Create survey', 'Create survey', 'ri-add-line', 'Create a new survey from scratch. Or simply copy or import an existing survey.', 'welcome', -2),

[123] Fix | Delete

(2, 2, 'surveyAdministration/listsurveys', 'List surveys', NULL, 'ri-list-unordered', 'List available surveys', 'welcome', -1),

[124] Fix | Delete

(3, 3, 'admin/globalsettings', 'Global settings', 'View global settings', 'ri-settings-5-line', 'Edit global settings', 'welcome', -2),

[125] Fix | Delete

(4, 4, 'userManagement/index', 'Manage survey administrators', 'Manage administrators', 'ri-user-line', 'The user management allows you to add additional users to your survey administration.', 'welcome', -2),

[126] Fix | Delete

(5, 5, 'admin/labels/sa/view', 'Label sets', 'Edit label sets', 'ri-price-tag-3-line', 'Label sets can be used as answer options or subquestions to speed up creation of similar questions.', 'welcome', -2),

[127] Fix | Delete

(6, 6, 'themeOptions', 'Themes', 'Edit themes', 'ri-brush-line', 'The themes functionality allows you to edit survey-, admin- or question themes.', 'welcome', -2);

[128] Fix | Delete

[129] Fix | Delete

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

[130] Fix | Delete

[131] Fix | Delete

[132] Fix | Delete

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

[133] Fix | Delete

[134] Fix | Delete

[135] Fix | Delete

CREATE TABLE `[[dbprefix]]conditions` (

[136] Fix | Delete

`cid` int(11) NOT NULL AUTO_INCREMENT,

[137] Fix | Delete

`qid` int(11) NOT NULL DEFAULT '0',

[138] Fix | Delete

`cqid` int(11) NOT NULL DEFAULT '0',

[139] Fix | Delete

`cfieldname` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

[140] Fix | Delete

`method` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

[141] Fix | Delete

`value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

[142] Fix | Delete

`scenario` int(11) NOT NULL DEFAULT '1',

[143] Fix | Delete

PRIMARY KEY (`cid`),

[144] Fix | Delete

KEY `[[dbprefix]]conditions_idx` (`qid`),

[145] Fix | Delete

KEY `[[dbprefix]]conditions_idx3` (`cqid`)

[146] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[147] Fix | Delete

[148] Fix | Delete

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

[149] Fix | Delete

[150] Fix | Delete

[151] Fix | Delete

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

[152] Fix | Delete

[153] Fix | Delete

[154] Fix | Delete

CREATE TABLE `[[dbprefix]]defaultvalues` (

[155] Fix | Delete

`dvid` int(11) NOT NULL AUTO_INCREMENT,

[156] Fix | Delete

`qid` int(11) NOT NULL DEFAULT '0',

[157] Fix | Delete

`scale_id` int(11) NOT NULL DEFAULT '0',

[158] Fix | Delete

`sqid` int(11) NOT NULL DEFAULT '0',

[159] Fix | Delete

`specialtype` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

[160] Fix | Delete

PRIMARY KEY (`dvid`),

[161] Fix | Delete

KEY `[[dbprefix]]idx1_defaultvalue` (`qid`,`scale_id`,`sqid`,`specialtype`)

[162] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[163] Fix | Delete

[164] Fix | Delete

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

[165] Fix | Delete

[166] Fix | Delete

[167] Fix | Delete

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

[168] Fix | Delete

[169] Fix | Delete

[170] Fix | Delete

CREATE TABLE `[[dbprefix]]defaultvalue_l10ns` (

[171] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[172] Fix | Delete

`dvid` int(11) NOT NULL DEFAULT '0',

[173] Fix | Delete

`language` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,

[174] Fix | Delete

`defaultvalue` text COLLATE utf8mb4_unicode_ci,

[175] Fix | Delete

PRIMARY KEY (`id`),

[176] Fix | Delete

KEY `[[dbprefix]]idx1_defaultvalue_ls` (`dvid`,`language`)

[177] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[178] Fix | Delete

[179] Fix | Delete

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

[180] Fix | Delete

[181] Fix | Delete

[182] Fix | Delete

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

[183] Fix | Delete

[184] Fix | Delete

[185] Fix | Delete

CREATE TABLE `[[dbprefix]]expression_errors` (

[186] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[187] Fix | Delete

`errortime` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[188] Fix | Delete

`sid` int(11) DEFAULT NULL,

[189] Fix | Delete

`gid` int(11) DEFAULT NULL,

[190] Fix | Delete

`qid` int(11) DEFAULT NULL,

[191] Fix | Delete

`gseq` int(11) DEFAULT NULL,

[192] Fix | Delete

`qseq` int(11) DEFAULT NULL,

[193] Fix | Delete

`type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[194] Fix | Delete

`eqn` text COLLATE utf8mb4_unicode_ci,

[195] Fix | Delete

`prettyprint` text COLLATE utf8mb4_unicode_ci,

[196] Fix | Delete

PRIMARY KEY (`id`)

[197] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[198] Fix | Delete

[199] Fix | Delete

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

[200] Fix | Delete

[201] Fix | Delete

[202] Fix | Delete

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

[203] Fix | Delete

[204] Fix | Delete

[205] Fix | Delete

CREATE TABLE `[[dbprefix]]failed_emails` (

[206] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[207] Fix | Delete

`surveyid` int(11) NOT NULL,

[208] Fix | Delete

`responseid` int(11) NOT NULL,

[209] Fix | Delete

`email_type` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,

[210] Fix | Delete

`recipient` varchar(320) COLLATE utf8mb4_unicode_ci NOT NULL,

[211] Fix | Delete

`language` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'en',

[212] Fix | Delete

`error_message` text COLLATE utf8mb4_unicode_ci,

[213] Fix | Delete

`created` datetime NOT NULL,

[214] Fix | Delete

`status` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT 'SEND FAILED',

[215] Fix | Delete

`updated` datetime DEFAULT NULL,

[216] Fix | Delete

`resend_vars` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,

[217] Fix | Delete

PRIMARY KEY (`id`)

[218] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[219] Fix | Delete

[220] Fix | Delete

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

[221] Fix | Delete

[222] Fix | Delete

[223] Fix | Delete

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

[224] Fix | Delete

[225] Fix | Delete

[226] Fix | Delete

CREATE TABLE `[[dbprefix]]failed_login_attempts` (

[227] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[228] Fix | Delete

`ip` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,

[229] Fix | Delete

`last_attempt` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,

[230] Fix | Delete

`number_attempts` int(11) NOT NULL,

[231] Fix | Delete

`is_frontend` tinyint(1) NOT NULL,

[232] Fix | Delete

PRIMARY KEY (`id`)

[233] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[234] Fix | Delete

[235] Fix | Delete

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

[236] Fix | Delete

[237] Fix | Delete

[238] Fix | Delete

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

[239] Fix | Delete

[240] Fix | Delete

[241] Fix | Delete

CREATE TABLE `[[dbprefix]]groups` (

[242] Fix | Delete

`gid` int(11) NOT NULL AUTO_INCREMENT,

[243] Fix | Delete

`sid` int(11) NOT NULL DEFAULT '0',

[244] Fix | Delete

`group_order` int(11) NOT NULL DEFAULT '0',

[245] Fix | Delete

`randomization_group` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

[246] Fix | Delete

`grelevance` text COLLATE utf8mb4_unicode_ci,

[247] Fix | Delete

PRIMARY KEY (`gid`),

[248] Fix | Delete

KEY `[[dbprefix]]idx1_groups` (`sid`)

[249] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[250] Fix | Delete

[251] Fix | Delete

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

[252] Fix | Delete

[253] Fix | Delete

[254] Fix | Delete

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

[255] Fix | Delete

[256] Fix | Delete

[257] Fix | Delete

CREATE TABLE `[[dbprefix]]group_l10ns` (

[258] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[259] Fix | Delete

`gid` int(11) NOT NULL,

[260] Fix | Delete

`group_name` text COLLATE utf8mb4_unicode_ci NOT NULL,

[261] Fix | Delete

`description` mediumtext COLLATE utf8mb4_unicode_ci,

[262] Fix | Delete

`language` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,

[263] Fix | Delete

PRIMARY KEY (`id`),

[264] Fix | Delete

UNIQUE KEY `[[dbprefix]]idx1_group_ls` (`gid`,`language`)

[265] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[266] Fix | Delete

[267] Fix | Delete

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

[268] Fix | Delete

[269] Fix | Delete

[270] Fix | Delete

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

[271] Fix | Delete

[272] Fix | Delete

[273] Fix | Delete

CREATE TABLE `[[dbprefix]]labels` (

[274] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[275] Fix | Delete

`lid` int(11) NOT NULL DEFAULT '0',

[276] Fix | Delete

`code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

[277] Fix | Delete

`sortorder` int(11) NOT NULL,

[278] Fix | Delete

`assessment_value` int(11) NOT NULL DEFAULT '0',

[279] Fix | Delete

PRIMARY KEY (`id`),

[280] Fix | Delete

UNIQUE KEY `[[dbprefix]]idx5_labels` (`lid`,`code`),

[281] Fix | Delete

KEY `[[dbprefix]]idx1_labels` (`code`),

[282] Fix | Delete

KEY `[[dbprefix]]idx2_labels` (`sortorder`),

[283] Fix | Delete

KEY `[[dbprefix]]idx4_labels` (`lid`,`sortorder`)

[284] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[285] Fix | Delete

[286] Fix | Delete

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

[287] Fix | Delete

[288] Fix | Delete

[289] Fix | Delete

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

[290] Fix | Delete

[291] Fix | Delete

[292] Fix | Delete

CREATE TABLE `[[dbprefix]]labelsets` (

[293] Fix | Delete

`lid` int(11) NOT NULL AUTO_INCREMENT,

[294] Fix | Delete

`owner_id` int(11) DEFAULT NULL,

[295] Fix | Delete

`label_name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

[296] Fix | Delete

`languages` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

[297] Fix | Delete

PRIMARY KEY (`lid`),

[298] Fix | Delete

KEY `[[dbprefix]]idx1_labelsets` (`owner_id`),

[299] Fix | Delete

KEY `[[dbprefix]]idx2_labelsets` (`lid`,`owner_id`)

[300] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[301] Fix | Delete

[302] Fix | Delete

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

[303] Fix | Delete

[304] Fix | Delete

[305] Fix | Delete

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

[306] Fix | Delete

[307] Fix | Delete

[308] Fix | Delete

CREATE TABLE `[[dbprefix]]label_l10ns` (

[309] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[310] Fix | Delete

`label_id` int(11) NOT NULL,

[311] Fix | Delete

`title` text COLLATE utf8mb4_unicode_ci,

[312] Fix | Delete

`language` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'en',

[313] Fix | Delete

PRIMARY KEY (`id`)

[314] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[315] Fix | Delete

[316] Fix | Delete

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

[317] Fix | Delete

[318] Fix | Delete

[319] Fix | Delete

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

[320] Fix | Delete

[321] Fix | Delete

[322] Fix | Delete

CREATE TABLE `[[dbprefix]]map_tutorial_users` (

[323] Fix | Delete

`tid` int(11) NOT NULL,

[324] Fix | Delete

`uid` int(11) NOT NULL,

[325] Fix | Delete

`taken` int(11) DEFAULT '1',

[326] Fix | Delete

PRIMARY KEY (`uid`,`tid`)

[327] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

[328] Fix | Delete

[329] Fix | Delete

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

[330] Fix | Delete

[331] Fix | Delete

[332] Fix | Delete

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

[333] Fix | Delete

[334] Fix | Delete

[335] Fix | Delete

CREATE TABLE `[[dbprefix]]message` (

[336] Fix | Delete

`id` int(11) NOT NULL,

[337] Fix | Delete

`language` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

[338] Fix | Delete

`translation` text COLLATE utf8mb4_unicode_ci,

[339] Fix | Delete

PRIMARY KEY (`id`,`language`)

[340] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

[341] Fix | Delete

[342] Fix | Delete

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

[343] Fix | Delete

[344] Fix | Delete

[345] Fix | Delete

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

[346] Fix | Delete

[347] Fix | Delete

[348] Fix | Delete

CREATE TABLE `[[dbprefix]]notifications` (

[349] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[350] Fix | Delete

`entity` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL,

[351] Fix | Delete

`entity_id` int(11) NOT NULL,

[352] Fix | Delete

`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

[353] Fix | Delete

`message` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,

[354] Fix | Delete

`status` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'new',

[355] Fix | Delete

`importance` int(11) NOT NULL DEFAULT '1',

[356] Fix | Delete

`display_class` varchar(31) COLLATE utf8mb4_unicode_ci DEFAULT 'default',

[357] Fix | Delete

`hash` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[358] Fix | Delete

`created` datetime DEFAULT NULL,

[359] Fix | Delete

`first_read` datetime DEFAULT NULL,

[360] Fix | Delete

PRIMARY KEY (`id`),

[361] Fix | Delete

KEY `[[dbprefix]]notifications_pk` (`entity`,`entity_id`,`status`),

[362] Fix | Delete

KEY `[[dbprefix]]idx1_notifications` (`hash`)

[363] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[364] Fix | Delete

[365] Fix | Delete

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

[366] Fix | Delete

[367] Fix | Delete

[368] Fix | Delete

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

[369] Fix | Delete

[370] Fix | Delete

[371] Fix | Delete

CREATE TABLE `[[dbprefix]]participants` (

[372] Fix | Delete

`participant_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,

[373] Fix | Delete

`firstname` text COLLATE utf8mb4_unicode_ci,

[374] Fix | Delete

`lastname` text COLLATE utf8mb4_unicode_ci,

[375] Fix | Delete

`email` text COLLATE utf8mb4_unicode_ci,

[376] Fix | Delete

`language` varchar(40) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[377] Fix | Delete

`blacklisted` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL,

[378] Fix | Delete

`owner_uid` int(11) NOT NULL,

[379] Fix | Delete

`created_by` int(11) NOT NULL,

[380] Fix | Delete

`created` datetime DEFAULT NULL,

[381] Fix | Delete

`modified` datetime DEFAULT NULL,

[382] Fix | Delete

PRIMARY KEY (`participant_id`),

[383] Fix | Delete

KEY `[[dbprefix]]idx3_participants` (`language`)

[384] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

[385] Fix | Delete

[386] Fix | Delete

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

[387] Fix | Delete

[388] Fix | Delete

[389] Fix | Delete

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

[390] Fix | Delete

[391] Fix | Delete

[392] Fix | Delete

CREATE TABLE `[[dbprefix]]participant_attribute` (

[393] Fix | Delete

`participant_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,

[394] Fix | Delete

`attribute_id` int(11) NOT NULL,

[395] Fix | Delete

`value` text COLLATE utf8mb4_unicode_ci NOT NULL,

[396] Fix | Delete

PRIMARY KEY (`participant_id`,`attribute_id`)

[397] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

[398] Fix | Delete

[399] Fix | Delete

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

[400] Fix | Delete

[401] Fix | Delete

[402] Fix | Delete

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

[403] Fix | Delete

[404] Fix | Delete

[405] Fix | Delete

CREATE TABLE `[[dbprefix]]participant_attribute_names` (

[406] Fix | Delete

`attribute_id` int(11) NOT NULL AUTO_INCREMENT,

[407] Fix | Delete

`attribute_type` varchar(4) COLLATE utf8mb4_unicode_ci NOT NULL,

[408] Fix | Delete

`defaultname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

[409] Fix | Delete

`visible` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL,

[410] Fix | Delete

`encrypted` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL,

[411] Fix | Delete

`core_attribute` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL,

[412] Fix | Delete

PRIMARY KEY (`attribute_id`,`attribute_type`),

[413] Fix | Delete

KEY `[[dbprefix]]idx_participant_attribute_names` (`attribute_id`,`attribute_type`)

[414] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=4 ;

[415] Fix | Delete

[416] Fix | Delete

[417] Fix | Delete

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

[418] Fix | Delete

[419] Fix | Delete

[420] Fix | Delete

INSERT INTO `[[dbprefix]]participant_attribute_names` VALUES

[421] Fix | Delete

(1, 'TB', 'firstname', 'TRUE', 'Y', 'Y'),

[422] Fix | Delete

(2, 'TB', 'lastname', 'TRUE', 'Y', 'Y'),

[423] Fix | Delete

(3, 'TB', 'email', 'TRUE', 'Y', 'Y');

[424] Fix | Delete

[425] Fix | Delete

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

[426] Fix | Delete

[427] Fix | Delete

[428] Fix | Delete

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

[429] Fix | Delete

[430] Fix | Delete

[431] Fix | Delete

CREATE TABLE `[[dbprefix]]participant_attribute_names_lang` (

[432] Fix | Delete

`attribute_id` int(11) NOT NULL,

[433] Fix | Delete

`attribute_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,

[434] Fix | Delete

`lang` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,

[435] Fix | Delete

PRIMARY KEY (`attribute_id`,`lang`)

[436] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

[437] Fix | Delete

[438] Fix | Delete

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

[439] Fix | Delete

[440] Fix | Delete

[441] Fix | Delete

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

[442] Fix | Delete

[443] Fix | Delete

[444] Fix | Delete

CREATE TABLE `[[dbprefix]]participant_attribute_values` (

[445] Fix | Delete

`value_id` int(11) NOT NULL AUTO_INCREMENT,

[446] Fix | Delete

`attribute_id` int(11) NOT NULL,

[447] Fix | Delete

`value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,

[448] Fix | Delete

PRIMARY KEY (`value_id`)

[449] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;

[450] Fix | Delete

[451] Fix | Delete

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

[452] Fix | Delete

[453] Fix | Delete

[454] Fix | Delete

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

[455] Fix | Delete

[456] Fix | Delete

[457] Fix | Delete

CREATE TABLE `[[dbprefix]]participant_shares` (

[458] Fix | Delete

`participant_id` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,

[459] Fix | Delete

`share_uid` int(11) NOT NULL,

[460] Fix | Delete

`date_added` datetime NOT NULL,

[461] Fix | Delete

`can_edit` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL,

[462] Fix | Delete

PRIMARY KEY (`participant_id`,`share_uid`)

[463] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

[464] Fix | Delete

[465] Fix | Delete

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

[466] Fix | Delete

[467] Fix | Delete

[468] Fix | Delete

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

[469] Fix | Delete

[470] Fix | Delete

[471] Fix | Delete

CREATE TABLE `[[dbprefix]]permissions` (

[472] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[473] Fix | Delete

`entity` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,

[474] Fix | Delete

`entity_id` int(11) NOT NULL,

[475] Fix | Delete

`uid` int(11) NOT NULL,

[476] Fix | Delete

`permission` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,

[477] Fix | Delete

`create_p` int(11) NOT NULL DEFAULT '0',

[478] Fix | Delete

`read_p` int(11) NOT NULL DEFAULT '0',

[479] Fix | Delete

`update_p` int(11) NOT NULL DEFAULT '0',

[480] Fix | Delete

`delete_p` int(11) NOT NULL DEFAULT '0',

[481] Fix | Delete

`import_p` int(11) NOT NULL DEFAULT '0',

[482] Fix | Delete

`export_p` int(11) NOT NULL DEFAULT '0',

[483] Fix | Delete

PRIMARY KEY (`id`),

[484] Fix | Delete

UNIQUE KEY `[[dbprefix]]idx1_permissions` (`entity_id`,`entity`,`permission`,`uid`)

[485] Fix | Delete

) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=2 ;

[486] Fix | Delete

[487] Fix | Delete

[488] Fix | Delete

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

[489] Fix | Delete

[490] Fix | Delete

[491] Fix | Delete

INSERT INTO `[[dbprefix]]permissions` VALUES

[492] Fix | Delete

(1, 'global', 0, 1, 'superadmin', 0, 1, 0, 0, 0, 0);

[493] Fix | Delete

[494] Fix | Delete

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

[495] Fix | Delete

[496] Fix | Delete

[497] Fix | Delete

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

[498] Fix | Delete

[499] Fix | Delete

12 3