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

[11] Fix | Delete

--

[12] Fix | Delete

[13] Fix | Delete

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

[14] Fix | Delete

[15] Fix | Delete

--

[16] Fix | Delete

-- Table structure for table `mycal_categories`

[17] Fix | Delete

--

[18] Fix | Delete

[19] Fix | Delete

CREATE TABLE `mycal_categories` (

[20] Fix | Delete

`ID` int(11) NOT NULL AUTO_INCREMENT,

[21] Fix | Delete

`name` varchar(48) COLLATE utf8mb4_bin NOT NULL DEFAULT '',

[22] Fix | Delete

`symbol` varchar(8) COLLATE utf8mb4_bin NOT NULL DEFAULT '',

[23] Fix | Delete

`sequence` tinyint(4) NOT NULL DEFAULT '1',

[24] Fix | Delete

`repeat` tinyint(4) NOT NULL DEFAULT '0',

[25] Fix | Delete

`noverlap` tinyint(4) NOT NULL DEFAULT '0',

[26] Fix | Delete

`olapGap` tinyint(4) NOT NULL DEFAULT '0',

[27] Fix | Delete

`olErrMsg` varchar(56) COLLATE utf8mb4_bin NOT NULL DEFAULT '',

[28] Fix | Delete

`defSlot` smallint(6) NOT NULL DEFAULT '0',

[29] Fix | Delete

`fixSlot` tinyint(4) NOT NULL DEFAULT '0',

[30] Fix | Delete

`approve` tinyint(4) NOT NULL DEFAULT '0',

[31] Fix | Delete

`dayColor` tinyint(4) NOT NULL DEFAULT '0',

[32] Fix | Delete

`color` varchar(8) COLLATE utf8mb4_bin NOT NULL DEFAULT '',

[33] Fix | Delete

`bgColor` varchar(8) COLLATE utf8mb4_bin NOT NULL DEFAULT '',

[34] Fix | Delete

`checkBx` tinyint(4) NOT NULL DEFAULT '0',

[35] Fix | Delete

`checkLb` varchar(16) COLLATE utf8mb4_bin NOT NULL DEFAULT 'approved',

[36] Fix | Delete

`checkMk` varchar(8) COLLATE utf8mb4_bin NOT NULL DEFAULT '✓',

[37] Fix | Delete

`subCats` text COLLATE utf8mb4_bin,

[38] Fix | Delete

`notList` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',

[39] Fix | Delete

`urlLink` varchar(120) COLLATE utf8mb4_bin NOT NULL DEFAULT '',

[40] Fix | Delete

`status` tinyint(1) NOT NULL DEFAULT '0',

[41] Fix | Delete

PRIMARY KEY (`ID`)

[42] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=2 ;

[43] Fix | Delete

[44] Fix | Delete

--

[45] Fix | Delete

-- Dumping data for table `mycal_categories`

[46] Fix | Delete

--

[47] Fix | Delete

[48] Fix | Delete

INSERT INTO `mycal_categories` VALUES

[49] Fix | Delete

(1, 'no cat', '', 1, 0, 0, 0, '', 0, 0, 0, 0, '', '', 0, 'approved', '✓', '[]', '', '', 0);

[50] Fix | Delete

[51] Fix | Delete

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

[52] Fix | Delete

[53] Fix | Delete

--

[54] Fix | Delete

-- Table structure for table `mycal_events`

[55] Fix | Delete

--

[56] Fix | Delete

[57] Fix | Delete

CREATE TABLE `mycal_events` (

[58] Fix | Delete

`ID` int(11) NOT NULL AUTO_INCREMENT,

[59] Fix | Delete

`type` tinyint(4) NOT NULL DEFAULT '0',

[60] Fix | Delete

`private` tinyint(4) NOT NULL DEFAULT '0',

[61] Fix | Delete

`title` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',

[62] Fix | Delete

`venue` varchar(128) COLLATE utf8mb4_bin NOT NULL DEFAULT '',

[63] Fix | Delete

`text1` text COLLATE utf8mb4_bin,

[64] Fix | Delete

`text2` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',

[65] Fix | Delete

`text3` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',

[66] Fix | Delete

`attach` text COLLATE utf8mb4_bin,

[67] Fix | Delete

`catID` mediumint(9) NOT NULL DEFAULT '1',

[68] Fix | Delete

`scatID` tinyint(4) NOT NULL DEFAULT '0',

[69] Fix | Delete

`userID` mediumint(9) NOT NULL DEFAULT '0',

[70] Fix | Delete

`editor` varchar(48) COLLATE utf8mb4_bin NOT NULL DEFAULT '',

[71] Fix | Delete

`approved` tinyint(4) NOT NULL DEFAULT '0',

[72] Fix | Delete

`checked` text COLLATE utf8mb4_bin,

[73] Fix | Delete

`notify` tinyint(4) NOT NULL DEFAULT '-1',

[74] Fix | Delete

`notRecip` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',

[75] Fix | Delete

`sDate` varchar(10) COLLATE utf8mb4_bin NOT NULL DEFAULT '',

[76] Fix | Delete

`eDate` varchar(10) COLLATE utf8mb4_bin NOT NULL DEFAULT '9999-00-00',

[77] Fix | Delete

`xDates` text COLLATE utf8mb4_bin,

[78] Fix | Delete

`sTime` varchar(5) COLLATE utf8mb4_bin NOT NULL DEFAULT '',

[79] Fix | Delete

`eTime` varchar(5) COLLATE utf8mb4_bin NOT NULL DEFAULT '99:00',

[80] Fix | Delete

`rType` tinyint(4) NOT NULL DEFAULT '0',

[81] Fix | Delete

`rInterval` tinyint(4) NOT NULL DEFAULT '0',

[82] Fix | Delete

`rPeriod` tinyint(4) NOT NULL DEFAULT '0',

[83] Fix | Delete

`rMonth` tinyint(4) NOT NULL DEFAULT '0',

[84] Fix | Delete

`rUntil` varchar(10) COLLATE utf8mb4_bin NOT NULL DEFAULT '9999-00-00',

[85] Fix | Delete

`aDateTime` varchar(16) COLLATE utf8mb4_bin NOT NULL DEFAULT '9999-00-00 00:00',

[86] Fix | Delete

`mDateTime` varchar(16) COLLATE utf8mb4_bin NOT NULL DEFAULT '9999-00-00 00:00',

[87] Fix | Delete

`status` tinyint(1) NOT NULL DEFAULT '0',

[88] Fix | Delete

PRIMARY KEY (`ID`)

[89] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=1 ;

[90] Fix | Delete

[91] Fix | Delete

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

[92] Fix | Delete

[93] Fix | Delete

--

[94] Fix | Delete

-- Table structure for table `mycal_groups`

[95] Fix | Delete

--

[96] Fix | Delete

[97] Fix | Delete

CREATE TABLE `mycal_groups` (

[98] Fix | Delete

`ID` int(11) NOT NULL AUTO_INCREMENT,

[99] Fix | Delete

`name` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',

[100] Fix | Delete

`privs` tinyint(4) NOT NULL DEFAULT '0',

[101] Fix | Delete

`vCatIDs` varchar(128) COLLATE utf8mb4_bin NOT NULL DEFAULT '0',

[102] Fix | Delete

`eCatIDs` varchar(128) COLLATE utf8mb4_bin NOT NULL DEFAULT '0',

[103] Fix | Delete

`rEvents` tinyint(4) NOT NULL DEFAULT '1',

[104] Fix | Delete

`mEvents` tinyint(4) NOT NULL DEFAULT '1',

[105] Fix | Delete

`pEvents` tinyint(4) NOT NULL DEFAULT '1',

[106] Fix | Delete

`upload` tinyint(4) NOT NULL DEFAULT '0',

[107] Fix | Delete

`tnPrivs` varchar(2) COLLATE utf8mb4_bin NOT NULL DEFAULT '00',

[108] Fix | Delete

`color` varchar(8) COLLATE utf8mb4_bin NOT NULL DEFAULT '',

[109] Fix | Delete

`status` tinyint(1) NOT NULL DEFAULT '0',

[110] Fix | Delete

PRIMARY KEY (`ID`)

[111] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=7 ;

[112] Fix | Delete

[113] Fix | Delete

--

[114] Fix | Delete

-- Dumping data for table `mycal_groups`

[115] Fix | Delete

--

[116] Fix | Delete

[117] Fix | Delete

INSERT INTO `mycal_groups` VALUES

[118] Fix | Delete

(1, 'No access', 0, '0', '0', 1, 1, 1, 0, '00', '', 0),

[119] Fix | Delete

(2, 'Admin', 9, '0', '0', 1, 1, 1, 1, '22', '', 0),

[120] Fix | Delete

(3, 'Read access', 1, '0', '0', 1, 1, 1, 0, '00', '', 0),

[121] Fix | Delete

(4, 'Post Own', 2, '0', '0', 1, 1, 1, 0, '20', '', 0),

[122] Fix | Delete

(5, 'Post All', 3, '0', '0', 1, 1, 1, 0, '21', '', 0),

[123] Fix | Delete

(6, 'Manager', 4, '0', '0', 1, 1, 1, 1, '22', '', 0);

[124] Fix | Delete

[125] Fix | Delete

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

[126] Fix | Delete

[127] Fix | Delete

--

[128] Fix | Delete

-- Table structure for table `mycal_settings`

[129] Fix | Delete

--

[130] Fix | Delete

[131] Fix | Delete

CREATE TABLE `mycal_settings` (

[132] Fix | Delete

`name` varchar(16) COLLATE utf8mb4_bin NOT NULL,

[133] Fix | Delete

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

[134] Fix | Delete

`outline` varchar(128) COLLATE utf8mb4_bin NOT NULL DEFAULT '',

[135] Fix | Delete

PRIMARY KEY (`name`)

[136] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

[137] Fix | Delete

[138] Fix | Delete

--

[139] Fix | Delete

-- Dumping data for table `mycal_settings`

[140] Fix | Delete

--

[141] Fix | Delete

[142] Fix | Delete

INSERT INTO `mycal_settings` VALUES

[143] Fix | Delete

('DMdFormat', 'WD d M', 'Date format: weekday dd month (WD:weekday d:dd, M:month)'),

[144] Fix | Delete

('DMdyFormat', 'WD d M y', 'Date format: weekday dd month yyyy (WD:weekday d:dd, M:month, y:yyyy)'),

[145] Fix | Delete

('GvWeeksToShow', '8', 'Number of weeks to show in gantt view'),

[146] Fix | Delete

('MdFormat', 'd M', 'Date format: dd month (d:dd, M:month)'),

[147] Fix | Delete

('MdyFormat', 'd M y', 'Date format: dd month yyyy (d:dd, M:month, y:yyyy)'),

[148] Fix | Delete

('MvWeeksToShow', '10', 'Number of weeks to show in month view'),

[149] Fix | Delete

('MyFormat', 'M y', 'Date format: month yyyy (M:month, y:yyyy)'),

[150] Fix | Delete

('XvWeeksToShow', '8', 'Number of weeks to show in matrix view'),

[151] Fix | Delete

('YvColsToShow', '3', 'Number of months to show per row in year view'),

[152] Fix | Delete

('YvRowsToShow', '4', 'Number of rows to show in year view'),

[153] Fix | Delete

('adminCronSum', '1', 'Send cron job summary to admin (0:no, 1:yes)'),

[154] Fix | Delete

('attTypes', '.pdf,.jpg,.gif,.png,.mp4,.avi', 'Valid types of uploaded attachments'),

[155] Fix | Delete

('backLinkUrl', '', 'Nav bar back link URL (blank: no link, url: link)'),

[156] Fix | Delete

('birthdayCal', '0', 'Display option PDF File - Birthdays in side menu (0:no, 1:yes)'),

[157] Fix | Delete

('cCodePrefix', '1', 'Country code starts with prefix + or 00 (0:no, 1:yes)'),

[158] Fix | Delete

('calMenu', '1', 'Display calendar menu in options panel (0:no, 1:yes)'),

[159] Fix | Delete

('calendarEmail', '[[admin_email]]', 'Sender of email notifications'),

[160] Fix | Delete

('calendarPhone', '', 'Sender of SMS notifications'),

[161] Fix | Delete

('calendarTitle', '[[site_name]]', 'Calendar title displayed in the top bar'),

[162] Fix | Delete

('calendarUrl', '[[softurl]]/?cal=mycal', 'Calendar link (URL)'),

[163] Fix | Delete

('catMenu', '1', 'Display category filter menu in options panel(0:no, 1:yes)'),

[164] Fix | Delete

('chgRecipList', '', 'List of notification email/SMS addresses'),

[165] Fix | Delete

('contButton', '1', 'Display Contact button in side menu (0:no, 1:yes)'),

[166] Fix | Delete

('cookieExp', '30', 'Number of days before a Remember Me cookie expires'),

[167] Fix | Delete

('dateFormat', 'd.m.y', 'Date format: yyyy-mm-dd (y:yyyy, m:mm, d:dd)'),

[168] Fix | Delete

('defRecips', '', 'Default recipients list for email and SMS notifications'),

[169] Fix | Delete

('defVenue', '', 'Default venue in the venue field of the event form'),

[170] Fix | Delete

('defViewLogL', '2', 'View large display at start-up (1:year, ... 8:changes) - logged in user'),

[171] Fix | Delete

('defViewLogS', '7', 'View small display at start-up (1:year, ... 8:changes) - logged in user'),

[172] Fix | Delete

('defViewPubL', '2', 'View large display at start-up (1:year, ... 8:changes) - public user'),

[173] Fix | Delete

('defViewPubS', '7', 'View small display at start-up (1:year, ... 8:changes) - public user'),

[174] Fix | Delete

('dwEndHour', '18', 'Day/week view end hour'),

[175] Fix | Delete

('dwStartHour', '6', 'Day/week view start hour'),

[176] Fix | Delete

('dwTimeSlot', '30', 'Day/week time slot in minutes'),

[177] Fix | Delete

('dwTsHeight', '20', 'Day/week time slot height in pixels'),

[178] Fix | Delete

('emlFootnote', '', 'Footnote text added to email reminders'),

[179] Fix | Delete

('emlService', '1', 'Email service (0:no, 1:yes)'),

[180] Fix | Delete

('emojiPicker', '1', 'Show emoji picker in Event Add/Edit window (0:no, 1:yes)'),

[181] Fix | Delete

('eventColor', '1', 'Event colors (0:no color, 1:cat color, 2:user group color)'),

[182] Fix | Delete

('eventExp', '0', 'Number of days after due when an event expires / can be deleted (0:never)'),

[183] Fix | Delete

('evtDelButton', '1', 'Display Delete button in Event window (0:no, 1:yes, 2:manager)'),

[184] Fix | Delete

('evtDrAndDr', '0', 'Event drag and drop (0:disabled, 1:enabled, 2:manager)'),

[185] Fix | Delete

('evtHeadM', '#ts #e', 'Event fields / layout template for month view'),

[186] Fix | Delete

('evtHeadW', '#ts #e', 'Event fields / layout template for week and day views'),

[187] Fix | Delete

('evtSorting', '0', 'Sort events on times or cat. seq. nr (0:times, 1:cat seq nr)'),

[188] Fix | Delete

('evtTemplGen', '12345678', 'Public user: Event fields and order in general views'),

[189] Fix | Delete

('evtTemplGen2', '12345678', 'Logged-in user: Event fields and order in general views'),

[190] Fix | Delete

('evtTemplPop', '123458', 'Public user: Event fields and order in hover box'),

[191] Fix | Delete

('evtTemplPop2', '123458', 'Logged-in user: Event fields and order in hover box'),

[192] Fix | Delete

('evtTemplUpc', '123458', 'Public user: Event fields and order in upcoming events view'),

[193] Fix | Delete

('evtTemplUpc2', '123458', 'Logged-in user: Event fields and order in upcoming events view'),

[194] Fix | Delete

('evtWinSmall', '0', 'Show reduced Event window (0:no, 1:yes)'),

[195] Fix | Delete

('groupMenu', '1', 'Display group filter menu in options panel (0:no, 1:yes)'),

[196] Fix | Delete

('icsExport', '0', 'Daily export of events in iCal format (0:no 1:yes)'),

[197] Fix | Delete

('langMenu', '0', 'Display ui-language selection menu in options panel (0:no, 1:yes)'),

[198] Fix | Delete

('language', 'English', 'Default user interface language'),

[199] Fix | Delete

('logNotices', '0', 'Log calendar notice messages (0:no, 1:yes)'),

[200] Fix | Delete

('logVisitors', '0', 'Log calendar visitors data (0:no, 1:yes)'),

[201] Fix | Delete

('logWarnings', '1', 'Log calendar warning messages (0:no, 1:yes)'),

[202] Fix | Delete

('logoHeight', '', 'Height of the login page logo image'),

[203] Fix | Delete

('logoPath', '', 'Path/name of optional left upper corner logo image'),

[204] Fix | Delete

('logoXlPath', '', 'Path/name of optional login page logo image'),

[205] Fix | Delete

('lookaheadDays', '14', 'Days to look ahead in upcoming view, todo list and RSS feeds'),

[206] Fix | Delete

('lookbackDays', '30', 'Days to look back in the todo list'),

[207] Fix | Delete

('mailServer', '1', 'Mail server (1:PHP mail, 2:SMTP mail)'),

[208] Fix | Delete

('maintMode', '0', 'Run calendar in maintenance mode (0:no, 1:yes)'),

[209] Fix | Delete

('mapViewer', 'https://maps.google.com/maps?q=', 'map viewer for the event address button'),

[210] Fix | Delete

('maxEmlCc', '10', 'Default max. number of recipients in email Cc field'),

[211] Fix | Delete

('maxLenSms', '70', 'Maximum length of SMS messages (bytes)'),

[212] Fix | Delete

('maxNoLogin', '0', 'Number of days not logged in, before deleting user account (0:never delete)'),

[213] Fix | Delete

('maxUplSize', '2', 'Max. size of uploaded attachment and thumbnail files in MBs'),

[214] Fix | Delete

('maxXsWidth', '800', 'Upper limit responsive calendar mode'),

[215] Fix | Delete

('monthInDCell', '0', 'Show in month view month for each day (0:no, 1:yes)'),

[216] Fix | Delete

('notSenderEml', '0', 'Sender of notification emails (0:calendar, 1:user)'),

[217] Fix | Delete

('notSenderSms', '0', 'Sender of notification SMSes (0:calendar, 1:user)'),

[218] Fix | Delete

('ownerTitle', '0', 'Prepend owner to event title (0:disabled 1:enabled)'),

[219] Fix | Delete

('popFieldsSbar', '12345', 'Event fields in sidebar hover box (none: no box)'),

[220] Fix | Delete

('privEvents', '1', 'Private events (0:disabled 1:enabled, 2:default, 3:always)'),

[221] Fix | Delete

('restLastSel', '1', 'Restore last session when user revisits calendar'),

[222] Fix | Delete

('rssFeed', '1', 'Display RSS feed links in footer and HTML head (0:no, 1:yes)'),

[223] Fix | Delete

('scrollDCell', '0', 'Vertical scrollbar in month view day cells (0:no, 1:yes)'),

[224] Fix | Delete

('searchAheadDays', '365', 'Defalt days to look ahead on Search page'),

[225] Fix | Delete

('searchBackDays', '365', 'Default days to look back on Search page'),

[226] Fix | Delete

('selfReg', '0', 'Self-registration (0:no, 1:yes)'),

[227] Fix | Delete

('selfRegA', '', 'Self-registration answer to selfregQ'),

[228] Fix | Delete

('selfRegGrp', '4', 'Self-registration user group ID'),

[229] Fix | Delete

('selfRegNot', '0', 'User self-reg notification to admin (0:no, 1:yes)'),

[230] Fix | Delete

('selfRegQ', '', 'Self-registration question to answer'),

[231] Fix | Delete

('showImgInMV', '0', 'Show images in month view (0:no, 1:yes)'),

[232] Fix | Delete

('showLinkInSB', '1', 'Show URL-links in sidebar (0:no, 1:yes)'),

[233] Fix | Delete

('sideBarDays', '14', 'Days to look ahead in sidebar'),

[234] Fix | Delete

('smsAddLink', '0', 'Add event report link to SMS (0:no, 1:yes)'),

[235] Fix | Delete

('smsCarrier', '', 'SMS carrier template (# = mob. phone number)'),

[236] Fix | Delete

('smsCountry', '', 'SMS country code'),

[237] Fix | Delete

('smsService', '0', 'SMS service (0:no, 1:yes)'),

[238] Fix | Delete

('smsSubject', '', 'Subject field template for SMS emails to the carrier'),

[239] Fix | Delete

('smtpAuth', '1', 'Use SMTP authentication (0:no, 1:yes)'),

[240] Fix | Delete

('smtpPass', '', 'SMTP password'),

[241] Fix | Delete

('smtpPort', '465', 'SMTP port number'),

[242] Fix | Delete

('smtpServer', '', 'SMTP mail server name'),

[243] Fix | Delete

('smtpSsl', '1', 'Use SSL (Secure Sockets Layer) (0:no, 1:yes)'),

[244] Fix | Delete

('smtpUser', '', 'SMTP username'),

[245] Fix | Delete

('spDateFixed', '0', 'Side panel date fixed (0:cD is taken, 1:date of today)'),

[246] Fix | Delete

('spImages', '', 'Show images in side panel (csv-list with views)'),

[247] Fix | Delete

('spInfoArea', '', 'Show info area in side panel (csv-list with views)'),

[248] Fix | Delete

('spMiniCal', '', 'Show mini calendar in side panel (csv-list with views)'),

[249] Fix | Delete

('timeDefault', '0', 'Time default for new events (0:time fields 1:all day 2: no time)'),

[250] Fix | Delete

('timeFormat', 'h:m', 'Time format (H:hh, h:h, m:mm, a:am|pm, A:AM|PM)'),

[251] Fix | Delete

('timeZone', 'Europe/Amsterdam', 'Calendar time zone'),

[252] Fix | Delete

('tlgService', '0', 'Telegram service (0:no, 1:yes)'),

[253] Fix | Delete

('tlgToken', '', 'Telegram token'),

[254] Fix | Delete

('tnlDelDays', '20', 'thumbnails used since last 20 days cannot be deleted'),

[255] Fix | Delete

('tnlMaxH', '120', 'Max. height of uploaded thumbnails image in pixels'),

[256] Fix | Delete

('tnlMaxW', '160', 'Max. width of uploaded thumbnails image in pixels'),

[257] Fix | Delete

('tnlTypes', '.jpg,.jpeg,.gif,.png', 'Valid types of uploaded thumbnails'),

[258] Fix | Delete

('toapList', '1', 'Display option Approve in side menu (0:no, 1:yes)'),

[259] Fix | Delete

('todoList', '1', 'Display option Todo in side menu (0:no, 1:yes)'),

[260] Fix | Delete

('topBarDate', '1', 'Show current date on top bar in calendar views (0:no, 1:yes)'),

[261] Fix | Delete

('upcoList', '1', 'Display option Upcoming in side menu (0:no, 1:yes)'),

[262] Fix | Delete

('userMenu', '1', 'Display user filter menu in options panel (0:no, 1:yes)'),

[263] Fix | Delete

('venueInput', '0', 'Venue input (0:free text 1:drop-down list, 2:both)'),

[264] Fix | Delete

('viewButsLogL', '1,2,4,7', 'View buttons on the navbar (1:year, ... 11:gantt) - logged in user, large display'),

[265] Fix | Delete

('viewButsLogS', '2,7', 'View buttons on the navbar (1:year, ... 11:gantt) - logged in user, small display'),

[266] Fix | Delete

('viewButsPubL', '2,7', 'View buttons on the navbar (1:year, ... 11:gantt) - public user, large display'),

[267] Fix | Delete

('viewButsPubS', '', 'View buttons on the navbar (1:year, ... 11:gantt) - public user, small display'),

[268] Fix | Delete

('viewMenu', '1', 'Display view menu in options panel (0:no, 1:yes)'),

[269] Fix | Delete

('viewsLogged', '1,2,3,4,5,6,7,8,9,10,11', 'Calendar views available to the logged-in users'),

[270] Fix | Delete

('viewsPublic', '1,2,3,4,5,6,7,8,9,10,11', 'Calendar views available to the public users'),

[271] Fix | Delete

('weekNumber', '1', 'Week numbers on(1) or off(0)'),

[272] Fix | Delete

('weekStart', '1', 'First day of the week (0: su - 6: sa)'),

[273] Fix | Delete

('workWeekDays', '12345', 'Working days (0: su - 6: sa)'),

[274] Fix | Delete

('xField1Label', '', 'Label optional extra event field 1'),

[275] Fix | Delete

('xField1Rights', '1', 'Extra event field 1 minimum required rights to see'),

[276] Fix | Delete

('xField2Label', '', 'Label optional extra event field 2'),

[277] Fix | Delete

('xField2Rights', '1', 'Extra event field 2 minimum required rights to see'),

[278] Fix | Delete

('yearStart', '0', 'Start month in year view (1-12 or 0, 0:current month)');

[279] Fix | Delete

[280] Fix | Delete

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

[281] Fix | Delete

[282] Fix | Delete

--

[283] Fix | Delete

-- Table structure for table `mycal_styles`

[284] Fix | Delete

--

[285] Fix | Delete

[286] Fix | Delete

CREATE TABLE `mycal_styles` (

[287] Fix | Delete

`name` varchar(8) COLLATE utf8mb4_bin NOT NULL,

[288] Fix | Delete

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

[289] Fix | Delete

PRIMARY KEY (`name`)

[290] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

[291] Fix | Delete

[292] Fix | Delete

--

[293] Fix | Delete

-- Dumping data for table `mycal_styles`

[294] Fix | Delete

--

[295] Fix | Delete

[296] Fix | Delete

INSERT INTO `mycal_styles` VALUES

[297] Fix | Delete

('BBHAR', '#96B4FF'),

[298] Fix | Delete

('BBUTS', '#FFFFFF'),

[299] Fix | Delete

('BCHBX', '#FFFFDD'),

[300] Fix | Delete

('BCONF', '#A0D070'),

[301] Fix | Delete

('BDROP', '#FFFFFF'),

[302] Fix | Delete

('BERRO', '#F0A070'),

[303] Fix | Delete

('BFFLD', '#FFFFFF'),

[304] Fix | Delete

('BGCTH', '#F2F2F2'),

[305] Fix | Delete

('BGOUT', '#FEFEFE'),

[306] Fix | Delete

('BGSEL', '#FFEEEE'),

[307] Fix | Delete

('BGTFD', '#96B4FF'),

[308] Fix | Delete

('BGTOD', '#EEEEFF'),

[309] Fix | Delete

('BGWD1', '#FFFFEE'),

[310] Fix | Delete

('BGWD2', '#FFFFDD'),

[311] Fix | Delete

('BGWE1', '#FFFFCC'),

[312] Fix | Delete

('BGWE2', '#FFFFBB'),

[313] Fix | Delete

('BGWTC', '#FFFFBB'),

[314] Fix | Delete

('BHLIT', '#FF2222'),

[315] Fix | Delete

('BHNOR', '#FFFFE0'),

[316] Fix | Delete

('BHPRI', '#CCFFCC'),

[317] Fix | Delete

('BHREP', '#FFFFE0'),

[318] Fix | Delete

('BINBX', '#FFFFEE'),

[319] Fix | Delete

('BLINK', '#FFFFFF'),

[320] Fix | Delete

('BOVBX', '#FEFEFE'),

[321] Fix | Delete

('BTBAR', '#FDFDFD'),

[322] Fix | Delete

('BWARN', '#FFF0A0'),

[323] Fix | Delete

('BXWIN', '#FFFFEE'),

[324] Fix | Delete

('BXXXX', '#E0E0E0'),

[325] Fix | Delete

('CBHAR', '#2B3856'),

[326] Fix | Delete

('CBUTS', '#2B3856'),

[327] Fix | Delete

('CCHBX', '#FF0000'),

[328] Fix | Delete

('CCONF', '#2B3856'),

[329] Fix | Delete

('CDROP', '#2B3856'),

[330] Fix | Delete

('CERRO', '#2B3856'),

[331] Fix | Delete

('CFFLD', '#2B3856'),

[332] Fix | Delete

('CGOUT', '#2B3856'),

[333] Fix | Delete

('CGSEL', '#2B3856'),

[334] Fix | Delete

('CGTFD', '#2B3856'),

[335] Fix | Delete

('CGTOD', '#2B3856'),

[336] Fix | Delete

('CGWD1', '#2B3856'),

[337] Fix | Delete

('CGWD2', '#2B3856'),

[338] Fix | Delete

('CGWE1', '#2B3856'),

[339] Fix | Delete

('CGWE2', '#2B3856'),

[340] Fix | Delete

('CGWTC', '#666666'),

[341] Fix | Delete

('CHLIT', '#2B3856'),

[342] Fix | Delete

('CHNOR', '#2B3856'),

[343] Fix | Delete

('CHPRI', '#2B3856'),

[344] Fix | Delete

('CHREP', '#2B3856'),

[345] Fix | Delete

('CINBX', '#2B3856'),

[346] Fix | Delete

('CLINK', '#C02020'),

[347] Fix | Delete

('COVBX', '#2B3856'),

[348] Fix | Delete

('CTBAR', '#2B3856'),

[349] Fix | Delete

('CWARN', '#2B3856'),

[350] Fix | Delete

('CXWIN', '#2B3856'),

[351] Fix | Delete

('CXXXX', '#2B3856'),

[352] Fix | Delete

('EBUTS', '#0080FE'),

[353] Fix | Delete

('EGSEL', '#FF0000'),

[354] Fix | Delete

('EGTOD', '#0000FF'),

[355] Fix | Delete

('EHNOR', '#808080'),

[356] Fix | Delete

('EHPRI', '#808080'),

[357] Fix | Delete

('EHREP', '#E00060'),

[358] Fix | Delete

('EOVBX', '#96B4FF'),

[359] Fix | Delete

('EXXXX', '#808080'),

[360] Fix | Delete

('FFXXX', 'arial,sans-serif'),

[361] Fix | Delete

('MBUTS', '0.9'),

[362] Fix | Delete

('MDTHD', '1.0'),

[363] Fix | Delete

('MEVTI', '1.0'),

[364] Fix | Delete

('MFFLD', '1.0'),

[365] Fix | Delete

('MOVBX', '1.0'),

[366] Fix | Delete

('MPOPU', '1.0'),

[367] Fix | Delete

('MPWIN', '1.1'),

[368] Fix | Delete

('MSMAL', '0.8'),

[369] Fix | Delete

('MSNHD', '1.0'),

[370] Fix | Delete

('MTHDM', '1.0'),

[371] Fix | Delete

('PPGTL', '14'),

[372] Fix | Delete

('PSXXX', '12'),

[373] Fix | Delete

('PTBAR', '13'),

[374] Fix | Delete

('PTHDL', '13'),

[375] Fix | Delete

('THEME', '[[site_name]]'),

[376] Fix | Delete

('sCtOf', '0'),

[377] Fix | Delete

('sTbSw', '1');

[378] Fix | Delete

[379] Fix | Delete

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

[380] Fix | Delete

[381] Fix | Delete

--

[382] Fix | Delete

-- Table structure for table `mycal_users`

[383] Fix | Delete

--

[384] Fix | Delete

[385] Fix | Delete

CREATE TABLE `mycal_users` (

[386] Fix | Delete

`ID` int(11) NOT NULL AUTO_INCREMENT,

[387] Fix | Delete

`token` varchar(165) COLLATE utf8mb4_bin NOT NULL DEFAULT '',

[388] Fix | Delete

`name` varchar(48) COLLATE utf8mb4_bin NOT NULL DEFAULT '',

[389] Fix | Delete

`password` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '',

[390] Fix | Delete

`tPassword` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '',

[391] Fix | Delete

`email` varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT '',

[392] Fix | Delete

`phone` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '',

[393] Fix | Delete

`msingID` varchar(16) COLLATE utf8mb4_bin NOT NULL DEFAULT '',

[394] Fix | Delete

`notSrvs` varchar(8) COLLATE utf8mb4_bin NOT NULL DEFAULT '',

[395] Fix | Delete

`groupID` mediumint(9) NOT NULL DEFAULT '3',

[396] Fix | Delete

`language` varchar(24) COLLATE utf8mb4_bin DEFAULT '',

[397] Fix | Delete

`expDate` varchar(10) COLLATE utf8mb4_bin NOT NULL DEFAULT '9999-00-00',

[398] Fix | Delete

`login0` varchar(10) COLLATE utf8mb4_bin NOT NULL DEFAULT '9999-00-00',

[399] Fix | Delete

`login1` varchar(10) COLLATE utf8mb4_bin NOT NULL DEFAULT '9999-00-00',

[400] Fix | Delete

`loginCnt` mediumint(9) NOT NULL DEFAULT '0',

[401] Fix | Delete

`status` tinyint(1) NOT NULL DEFAULT '0',

[402] Fix | Delete

PRIMARY KEY (`ID`)

[403] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=3 ;

[404] Fix | Delete

[405] Fix | Delete

--

[406] Fix | Delete

-- Dumping data for table `mycal_users`

[407] Fix | Delete

--

[408] Fix | Delete

[409] Fix | Delete

INSERT INTO `mycal_users` VALUES

[410] Fix | Delete

(1, '', 'Public Access', '', '', '', '', '', '', 3, '', '9999-00-00', '[[date]]', '[[date]]', 1, 0),

[411] Fix | Delete

(2, '', '[[admin_username]]', '[[admin_pass]]', '', '[[admin_email]]', '', '', '', 2, 'english', '9999-00-00', '9999-00-00', '9999-00-00', 0, 0);

[412] Fix | Delete

[413] Fix | Delete

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

[414] Fix | Delete

/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;

[415] Fix | Delete

/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

[416] Fix | Delete

[417] Fix | Delete