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: `easyappointment150`

[11] Fix | Delete

[12] Fix | Delete

[13] Fix | Delete

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

[14] Fix | Delete

[15] Fix | Delete

[16] Fix | Delete

-- Table structure for table `ea_appointments`

[17] Fix | Delete

[18] Fix | Delete

[19] Fix | Delete

CREATE TABLE `ea_appointments` (

[20] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[21] Fix | Delete

`create_datetime` datetime DEFAULT NULL,

[22] Fix | Delete

`update_datetime` datetime DEFAULT NULL,

[23] Fix | Delete

`book_datetime` datetime DEFAULT NULL,

[24] Fix | Delete

`start_datetime` datetime DEFAULT NULL,

[25] Fix | Delete

`end_datetime` datetime DEFAULT NULL,

[26] Fix | Delete

`location` text COLLATE utf8mb4_unicode_ci,

[27] Fix | Delete

`notes` text COLLATE utf8mb4_unicode_ci,

[28] Fix | Delete

`hash` text COLLATE utf8mb4_unicode_ci,

[29] Fix | Delete

`color` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT '#7cbae8',

[30] Fix | Delete

`status` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT '',

[31] Fix | Delete

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

[32] Fix | Delete

`id_users_provider` int(11) DEFAULT NULL,

[33] Fix | Delete

`id_users_customer` int(11) DEFAULT NULL,

[34] Fix | Delete

`id_services` int(11) DEFAULT NULL,

[35] Fix | Delete

`id_google_calendar` text COLLATE utf8mb4_unicode_ci,

[36] Fix | Delete

`id_caldav_calendar` text COLLATE utf8mb4_unicode_ci,

[37] Fix | Delete

PRIMARY KEY (`id`),

[38] Fix | Delete

KEY `id_users_provider` (`id_users_provider`),

[39] Fix | Delete

KEY `id_users_customer` (`id_users_customer`),

[40] Fix | Delete

KEY `id_services` (`id_services`)

[41] Fix | Delete

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

[42] Fix | Delete

[43] Fix | Delete

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

[44] Fix | Delete

[45] Fix | Delete

[46] Fix | Delete

-- Table structure for table `ea_blocked_periods`

[47] Fix | Delete

[48] Fix | Delete

[49] Fix | Delete

CREATE TABLE `ea_blocked_periods` (

[50] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[51] Fix | Delete

`create_datetime` datetime DEFAULT NULL,

[52] Fix | Delete

`update_datetime` datetime DEFAULT NULL,

[53] Fix | Delete

`name` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[54] Fix | Delete

`start_datetime` datetime DEFAULT NULL,

[55] Fix | Delete

`end_datetime` datetime DEFAULT NULL,

[56] Fix | Delete

`notes` text COLLATE utf8mb4_unicode_ci,

[57] Fix | Delete

PRIMARY KEY (`id`)

[58] Fix | Delete

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

[59] Fix | Delete

[60] Fix | Delete

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

[61] Fix | Delete

[62] Fix | Delete

[63] Fix | Delete

-- Table structure for table `ea_consents`

[64] Fix | Delete

[65] Fix | Delete

[66] Fix | Delete

CREATE TABLE `ea_consents` (

[67] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[68] Fix | Delete

`create_datetime` datetime DEFAULT NULL,

[69] Fix | Delete

`update_datetime` datetime DEFAULT NULL,

[70] Fix | Delete

`created` timestamp NULL DEFAULT NULL,

[71] Fix | Delete

`modified` timestamp NULL DEFAULT NULL,

[72] Fix | Delete

`first_name` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[73] Fix | Delete

`last_name` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[74] Fix | Delete

`email` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[75] Fix | Delete

`ip` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[76] Fix | Delete

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

[77] Fix | Delete

PRIMARY KEY (`id`)

[78] Fix | Delete

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

[79] Fix | Delete

[80] Fix | Delete

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

[81] Fix | Delete

[82] Fix | Delete

[83] Fix | Delete

-- Table structure for table `ea_migrations`

[84] Fix | Delete

[85] Fix | Delete

[86] Fix | Delete

CREATE TABLE `ea_migrations` (

[87] Fix | Delete

`version` bigint(20) NOT NULL

[88] Fix | Delete

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

[89] Fix | Delete

[90] Fix | Delete

[91] Fix | Delete

-- Dumping data for table `ea_migrations`

[92] Fix | Delete

[93] Fix | Delete

[94] Fix | Delete

INSERT INTO `ea_migrations` VALUES

[95] Fix | Delete

(59);

[96] Fix | Delete

[97] Fix | Delete

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

[98] Fix | Delete

[99] Fix | Delete

[100] Fix | Delete

-- Table structure for table `ea_roles`

[101] Fix | Delete

[102] Fix | Delete

[103] Fix | Delete

CREATE TABLE `ea_roles` (

[104] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[105] Fix | Delete

`create_datetime` datetime DEFAULT NULL,

[106] Fix | Delete

`update_datetime` datetime DEFAULT NULL,

[107] Fix | Delete

`name` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[108] Fix | Delete

`slug` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[109] Fix | Delete

`is_admin` tinyint(4) DEFAULT NULL,

[110] Fix | Delete

`appointments` int(11) DEFAULT NULL,

[111] Fix | Delete

`customers` int(11) DEFAULT NULL,

[112] Fix | Delete

`services` int(11) DEFAULT NULL,

[113] Fix | Delete

`users` int(11) DEFAULT NULL,

[114] Fix | Delete

`system_settings` int(11) DEFAULT NULL,

[115] Fix | Delete

`user_settings` int(11) DEFAULT NULL,

[116] Fix | Delete

`webhooks` int(11) DEFAULT NULL,

[117] Fix | Delete

`blocked_periods` int(11) DEFAULT NULL,

[118] Fix | Delete

PRIMARY KEY (`id`)

[119] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=5 ;

[120] Fix | Delete

[121] Fix | Delete

[122] Fix | Delete

-- Dumping data for table `ea_roles`

[123] Fix | Delete

[124] Fix | Delete

[125] Fix | Delete

INSERT INTO `ea_roles` VALUES

[126] Fix | Delete

(1, NULL, NULL, 'Administrator', 'admin', 1, 15, 15, 15, 15, 15, 15, 15, 15),

[127] Fix | Delete

(2, NULL, NULL, 'Provider', 'provider', 0, 15, 15, 0, 0, 0, 15, 0, 0),

[128] Fix | Delete

(3, NULL, NULL, 'Customer', 'customer', 0, 0, 0, 0, 0, 0, 0, 0, 0),

[129] Fix | Delete

(4, NULL, NULL, 'Secretary', 'secretary', 0, 15, 15, 0, 0, 0, 15, 0, 0);

[130] Fix | Delete

[131] Fix | Delete

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

[132] Fix | Delete

[133] Fix | Delete

[134] Fix | Delete

-- Table structure for table `ea_secretaries_providers`

[135] Fix | Delete

[136] Fix | Delete

[137] Fix | Delete

CREATE TABLE `ea_secretaries_providers` (

[138] Fix | Delete

`id_users_secretary` int(11) NOT NULL,

[139] Fix | Delete

`id_users_provider` int(11) NOT NULL,

[140] Fix | Delete

PRIMARY KEY (`id_users_secretary`,`id_users_provider`),

[141] Fix | Delete

KEY `secretaries_users_provider` (`id_users_provider`)

[142] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[143] Fix | Delete

[144] Fix | Delete

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

[145] Fix | Delete

[146] Fix | Delete

[147] Fix | Delete

-- Table structure for table `ea_services`

[148] Fix | Delete

[149] Fix | Delete

[150] Fix | Delete

CREATE TABLE `ea_services` (

[151] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[152] Fix | Delete

`create_datetime` datetime DEFAULT NULL,

[153] Fix | Delete

`update_datetime` datetime DEFAULT NULL,

[154] Fix | Delete

`name` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[155] Fix | Delete

`duration` int(11) DEFAULT NULL,

[156] Fix | Delete

`price` decimal(10,2) DEFAULT NULL,

[157] Fix | Delete

`currency` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[158] Fix | Delete

`description` text COLLATE utf8mb4_unicode_ci,

[159] Fix | Delete

`color` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT '#7cbae8',

[160] Fix | Delete

`location` text COLLATE utf8mb4_unicode_ci,

[161] Fix | Delete

`availabilities_type` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT 'flexible',

[162] Fix | Delete

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

[163] Fix | Delete

`is_private` tinyint(4) DEFAULT '0',

[164] Fix | Delete

`id_service_categories` int(11) DEFAULT NULL,

[165] Fix | Delete

PRIMARY KEY (`id`),

[166] Fix | Delete

KEY `id_service_categories` (`id_service_categories`)

[167] Fix | Delete

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

[168] Fix | Delete

[169] Fix | Delete

[170] Fix | Delete

-- Dumping data for table `ea_services`

[171] Fix | Delete

[172] Fix | Delete

[173] Fix | Delete

INSERT INTO `ea_services` VALUES

[174] Fix | Delete

(1, '[[regtime]]', '[[regtime]]', 'Service', 30, '0.00', '', NULL, '#7cbae8', NULL, 'flexible', 1, 0, NULL);

[175] Fix | Delete

[176] Fix | Delete

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

[177] Fix | Delete

[178] Fix | Delete

[179] Fix | Delete

-- Table structure for table `ea_services_providers`

[180] Fix | Delete

[181] Fix | Delete

[182] Fix | Delete

CREATE TABLE `ea_services_providers` (

[183] Fix | Delete

`id_users` int(11) NOT NULL,

[184] Fix | Delete

`id_services` int(11) NOT NULL,

[185] Fix | Delete

PRIMARY KEY (`id_users`,`id_services`),

[186] Fix | Delete

KEY `services_providers_services` (`id_services`)

[187] Fix | Delete

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

[188] Fix | Delete

[189] Fix | Delete

[190] Fix | Delete

-- Dumping data for table `ea_services_providers`

[191] Fix | Delete

[192] Fix | Delete

[193] Fix | Delete

INSERT INTO `ea_services_providers` VALUES

[194] Fix | Delete

(2, 1);

[195] Fix | Delete

[196] Fix | Delete

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

[197] Fix | Delete

[198] Fix | Delete

[199] Fix | Delete

-- Table structure for table `ea_service_categories`

[200] Fix | Delete

[201] Fix | Delete

[202] Fix | Delete

CREATE TABLE `ea_service_categories` (

[203] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[204] Fix | Delete

`create_datetime` datetime DEFAULT NULL,

[205] Fix | Delete

`update_datetime` datetime DEFAULT NULL,

[206] Fix | Delete

`name` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[207] Fix | Delete

`description` text COLLATE utf8mb4_unicode_ci,

[208] Fix | Delete

PRIMARY KEY (`id`)

[209] Fix | Delete

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

[210] Fix | Delete

[211] Fix | Delete

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

[212] Fix | Delete

[213] Fix | Delete

[214] Fix | Delete

-- Table structure for table `ea_settings`

[215] Fix | Delete

[216] Fix | Delete

[217] Fix | Delete

CREATE TABLE `ea_settings` (

[218] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[219] Fix | Delete

`create_datetime` datetime DEFAULT NULL,

[220] Fix | Delete

`update_datetime` datetime DEFAULT NULL,

[221] Fix | Delete

`name` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[222] Fix | Delete

`value` longtext COLLATE utf8mb4_unicode_ci,

[223] Fix | Delete

PRIMARY KEY (`id`)

[224] Fix | Delete

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=74 ;

[225] Fix | Delete

[226] Fix | Delete

[227] Fix | Delete

-- Dumping data for table `ea_settings`

[228] Fix | Delete

[229] Fix | Delete

[230] Fix | Delete

INSERT INTO `ea_settings` VALUES

[231] Fix | Delete

(1, NULL, NULL, 'company_working_plan', '{"monday":{"start":"09:00","end":"18:00","breaks":[{"start":"14:30","end":"15:00"}]},"tuesday":{"start":"09:00","end":"18:00","breaks":[{"start":"14:30","end":"15:00"}]},"wednesday":{"start":"09:00","end":"18:00","breaks":[{"start":"14:30","end":"15:00"}]},"thursday":{"start":"09:00","end":"18:00","breaks":[{"start":"14:30","end":"15:00"}]},"friday":{"start":"09:00","end":"18:00","breaks":[{"start":"14:30","end":"15:00"}]},"saturday":{"start":"09:00","end":"18:00","breaks":[{"start":"14:30","end":"15:00"}]},"sunday":{"start":"09:00","end":"18:00","breaks":[{"start":"14:30","end":"15:00"}]}}'),

[232] Fix | Delete

(2, NULL, NULL, 'book_advance_timeout', '30'),

[233] Fix | Delete

(3, NULL, NULL, 'google_analytics_code', ''),

[234] Fix | Delete

(4, NULL, NULL, 'customer_notifications', '1'),

[235] Fix | Delete

(5, NULL, NULL, 'date_format', 'DMY'),

[236] Fix | Delete

(6, NULL, NULL, 'require_captcha', '0'),

[237] Fix | Delete

(7, NULL, NULL, 'time_format', 'regular'),

[238] Fix | Delete

(8, NULL, NULL, 'display_cookie_notice', '0'),

[239] Fix | Delete

(9, NULL, NULL, 'cookie_notice_content', 'Cookie notice content.'),

[240] Fix | Delete

(10, NULL, NULL, 'display_terms_and_conditions', '0'),

[241] Fix | Delete

(11, NULL, NULL, 'terms_and_conditions_content', 'Terms and conditions content.'),

[242] Fix | Delete

(12, NULL, NULL, 'display_privacy_policy', '0'),

[243] Fix | Delete

(13, NULL, NULL, 'privacy_policy_content', 'Privacy policy content.'),

[244] Fix | Delete

(14, NULL, NULL, 'first_weekday', 'sunday'),

[245] Fix | Delete

(16, NULL, NULL, 'api_token', ''),

[246] Fix | Delete

(17, NULL, NULL, 'display_any_provider', '1'),

[247] Fix | Delete

(18, NULL, NULL, 'display_first_name', '1'),

[248] Fix | Delete

(19, NULL, NULL, 'require_first_name', '1'),

[249] Fix | Delete

(20, NULL, NULL, 'display_last_name', '1'),

[250] Fix | Delete

(21, NULL, NULL, 'require_last_name', '1'),

[251] Fix | Delete

(22, NULL, NULL, 'display_email', '1'),

[252] Fix | Delete

(23, NULL, NULL, 'require_email', '1'),

[253] Fix | Delete

(24, NULL, NULL, 'display_phone_number', '1'),

[254] Fix | Delete

(25, NULL, NULL, 'require_phone_number', '1'),

[255] Fix | Delete

(26, NULL, NULL, 'display_address', '1'),

[256] Fix | Delete

(27, NULL, NULL, 'require_address', '0'),

[257] Fix | Delete

(28, NULL, NULL, 'display_city', '1'),

[258] Fix | Delete

(29, NULL, NULL, 'require_city', '0'),

[259] Fix | Delete

(30, NULL, NULL, 'display_zip_code', '1'),

[260] Fix | Delete

(31, NULL, NULL, 'require_zip_code', '0'),

[261] Fix | Delete

(32, NULL, NULL, 'display_notes', '1'),

[262] Fix | Delete

(33, NULL, NULL, 'require_notes', '0'),

[263] Fix | Delete

(34, NULL, NULL, 'matomo_analytics_url', ''),

[264] Fix | Delete

(35, NULL, NULL, 'display_delete_personal_information', '0'),

[265] Fix | Delete

(36, NULL, NULL, 'disable_booking', '0'),

[266] Fix | Delete

(37, NULL, NULL, 'disable_booking_message', '<p style="text-align: center;">Thanks for stopping by!</p><p style="text-align: center;">We are not accepting new appointments at the moment, please check back again later.</p>'),

[267] Fix | Delete

(38, NULL, NULL, 'company_logo', ''),

[268] Fix | Delete

(39, NULL, NULL, 'company_color', '#ffffff'),

[269] Fix | Delete

(40, NULL, NULL, 'display_login_button', '1'),

[270] Fix | Delete

(41, NULL, NULL, 'theme', 'default'),

[271] Fix | Delete

(42, '[[regtime]]', '[[regtime]]', 'limit_customer_access', '0'),

[272] Fix | Delete

(43, NULL, NULL, 'future_booking_limit', '90'),

[273] Fix | Delete

(44, NULL, NULL, 'appointment_status_options', '["Booked", "Confirmed", "Rescheduled", "Cancelled", "Draft"]'),

[274] Fix | Delete

(45, NULL, NULL, 'display_custom_field_1', '0'),

[275] Fix | Delete

(46, NULL, NULL, 'require_custom_field_1', '0'),

[276] Fix | Delete

(47, NULL, NULL, 'label_custom_field_1', ''),

[277] Fix | Delete

(48, NULL, NULL, 'display_custom_field_2', '0'),

[278] Fix | Delete

(49, NULL, NULL, 'require_custom_field_2', '0'),

[279] Fix | Delete

(50, NULL, NULL, 'label_custom_field_2', ''),

[280] Fix | Delete

(51, NULL, NULL, 'display_custom_field_3', '0'),

[281] Fix | Delete

(52, NULL, NULL, 'require_custom_field_3', '0'),

[282] Fix | Delete

(53, NULL, NULL, 'label_custom_field_3', ''),

[283] Fix | Delete

(54, NULL, NULL, 'display_custom_field_4', '0'),

[284] Fix | Delete

(55, NULL, NULL, 'require_custom_field_4', '0'),

[285] Fix | Delete

(56, NULL, NULL, 'label_custom_field_4', ''),

[286] Fix | Delete

(57, NULL, NULL, 'display_custom_field_5', '0'),

[287] Fix | Delete

(58, NULL, NULL, 'require_custom_field_5', '0'),

[288] Fix | Delete

(59, NULL, NULL, 'label_custom_field_5', ''),

[289] Fix | Delete

(60, NULL, NULL, 'matomo_analytics_site_id', '1'),

[290] Fix | Delete

(61, NULL, NULL, 'default_language', 'english'),

[291] Fix | Delete

(62, NULL, NULL, 'default_timezone', 'America/New_York'),

[292] Fix | Delete

(63, '[[regtime]]', '[[regtime]]', 'ldap_is_active', '0'),

[293] Fix | Delete

(64, '[[regtime]]', '[[regtime]]', 'ldap_host', ''),

[294] Fix | Delete

(65, '[[regtime]]', '[[regtime]]', 'ldap_port', ''),

[295] Fix | Delete

(66, '[[regtime]]', '[[regtime]]', 'ldap_user_dn', ''),

[296] Fix | Delete

(67, '[[regtime]]', '[[regtime]]', 'ldap_password', ''),

[297] Fix | Delete

(68, '[[regtime]]', '[[regtime]]', 'ldap_base_dn', ''),

[298] Fix | Delete

(69, '[[regtime]]', '[[regtime]]', 'ldap_filter', '(&(objectClass=*)(|(cn={{KEYWORD}})(sn={{KEYWORD}})(mail={{KEYWORD}})(givenName={{KEYWORD}})(uid={{KEYWORD}})))'),

[299] Fix | Delete

(70, '[[regtime]]', '[[regtime]]', 'ldap_field_mapping', '{\n "first_name": "givenname",\n "last_name": "sn",\n "email": "mail",\n "phone_number": "telephonenumber",\n "username": "cn"\n}'),

[300] Fix | Delete

(71, '[[regtime]]', '[[regtime]]', 'company_name', '[[site_name]]'),

[301] Fix | Delete

(72, '[[regtime]]', '[[regtime]]', 'company_email', '[[admin_email]]'),

[302] Fix | Delete

(73, '[[regtime]]', '[[regtime]]', 'company_link', '[[softurl]]');

[303] Fix | Delete

[304] Fix | Delete

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

[305] Fix | Delete

[306] Fix | Delete

[307] Fix | Delete

-- Table structure for table `ea_users`

[308] Fix | Delete

[309] Fix | Delete

[310] Fix | Delete

CREATE TABLE `ea_users` (

[311] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[312] Fix | Delete

`create_datetime` datetime DEFAULT NULL,

[313] Fix | Delete

`update_datetime` datetime DEFAULT NULL,

[314] Fix | Delete

`first_name` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[315] Fix | Delete

`last_name` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[316] Fix | Delete

`email` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[317] Fix | Delete

`mobile_number` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[318] Fix | Delete

`phone_number` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[319] Fix | Delete

`address` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[320] Fix | Delete

`city` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[321] Fix | Delete

`state` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[322] Fix | Delete

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

[323] Fix | Delete

`notes` text COLLATE utf8mb4_unicode_ci,

[324] Fix | Delete

`timezone` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT 'UTC',

[325] Fix | Delete

`language` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT 'english',

[326] Fix | Delete

`custom_field_1` text COLLATE utf8mb4_unicode_ci,

[327] Fix | Delete

`custom_field_2` text COLLATE utf8mb4_unicode_ci,

[328] Fix | Delete

`custom_field_3` text COLLATE utf8mb4_unicode_ci,

[329] Fix | Delete

`custom_field_4` text COLLATE utf8mb4_unicode_ci,

[330] Fix | Delete

`custom_field_5` text COLLATE utf8mb4_unicode_ci,

[331] Fix | Delete

`is_private` tinyint(4) DEFAULT '0',

[332] Fix | Delete

`ldap_dn` text COLLATE utf8mb4_unicode_ci,

[333] Fix | Delete

`id_roles` int(11) DEFAULT NULL,

[334] Fix | Delete

PRIMARY KEY (`id`),

[335] Fix | Delete

KEY `id_roles` (`id_roles`)

[336] Fix | Delete

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

[337] Fix | Delete

[338] Fix | Delete

[339] Fix | Delete

-- Dumping data for table `ea_users`

[340] Fix | Delete

[341] Fix | Delete

[342] Fix | Delete

INSERT INTO `ea_users` VALUES

[343] Fix | Delete

(1, '[[regtime]]', '[[regtime]]', '[[admin_fname]]', '[[admin_lname]]', '[[admin_email]]', NULL, '[[store_phone]]', NULL, NULL, NULL, NULL, NULL, 'America/New_York', 'english', NULL, NULL, NULL, NULL, NULL, 0, NULL, 1),

[344] Fix | Delete

(2, '[[regtime]]', '[[regtime]]', 'Jane', 'Doe', 'jane@example.org', NULL, '+1 (000) 000-0000', NULL, NULL, NULL, NULL, NULL, 'America/New_York', 'english', NULL, NULL, NULL, NULL, NULL, 0, NULL, 2),

[345] Fix | Delete

(3, '[[regtime]]', '[[regtime]]', 'James', 'Doe', 'james@example.org', NULL, '+1 (000) 000-0000', NULL, NULL, NULL, NULL, NULL, 'UTC', 'english', NULL, NULL, NULL, NULL, NULL, 0, NULL, 3);

[346] Fix | Delete

[347] Fix | Delete

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

[348] Fix | Delete

[349] Fix | Delete

[350] Fix | Delete

-- Table structure for table `ea_user_settings`

[351] Fix | Delete

[352] Fix | Delete

[353] Fix | Delete

CREATE TABLE `ea_user_settings` (

[354] Fix | Delete

`id_users` int(11) NOT NULL,

[355] Fix | Delete

`username` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[356] Fix | Delete

`password` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[357] Fix | Delete

`salt` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[358] Fix | Delete

`working_plan` text COLLATE utf8mb4_unicode_ci,

[359] Fix | Delete

`working_plan_exceptions` text COLLATE utf8mb4_unicode_ci,

[360] Fix | Delete

`notifications` tinyint(4) DEFAULT NULL,

[361] Fix | Delete

`google_sync` tinyint(4) DEFAULT NULL,

[362] Fix | Delete

`google_token` text COLLATE utf8mb4_unicode_ci,

[363] Fix | Delete

`google_calendar` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[364] Fix | Delete

`caldav_sync` tinyint(4) DEFAULT '0',

[365] Fix | Delete

`caldav_url` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[366] Fix | Delete

`caldav_username` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[367] Fix | Delete

`caldav_password` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[368] Fix | Delete

`sync_past_days` int(11) DEFAULT '30',

[369] Fix | Delete

`sync_future_days` int(11) DEFAULT '90',

[370] Fix | Delete

`calendar_view` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT 'default',

[371] Fix | Delete

PRIMARY KEY (`id_users`)

[372] Fix | Delete

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

[373] Fix | Delete

[374] Fix | Delete

[375] Fix | Delete

-- Dumping data for table `ea_user_settings`

[376] Fix | Delete

[377] Fix | Delete

[378] Fix | Delete

INSERT INTO `ea_user_settings` VALUES

[379] Fix | Delete

(1, '[[admin_username]]', '[[admin_pass]]', '[[salt]]', NULL, NULL, 1, NULL, NULL, NULL, 0, NULL, NULL, NULL, 30, 90, 'default'),

[380] Fix | Delete

(2, 'janedoe', 'b48a587f74e28219061a434561674a768353d0b9bca6380a516d4c5e36997c42', 'b4f87385802cd09d128bb34eaa312a424bbd93d74fc28b543c9923aa4499c7d7', '{"monday":{"start":"09:00","end":"18:00","breaks":[{"start":"14:30","end":"15:00"}]},"tuesday":{"start":"09:00","end":"18:00","breaks":[{"start":"14:30","end":"15:00"}]},"wednesday":{"start":"09:00","end":"18:00","breaks":[{"start":"14:30","end":"15:00"}]},"thursday":{"start":"09:00","end":"18:00","breaks":[{"start":"14:30","end":"15:00"}]},"friday":{"start":"09:00","end":"18:00","breaks":[{"start":"14:30","end":"15:00"}]},"saturday":{"start":"09:00","end":"18:00","breaks":[{"start":"14:30","end":"15:00"}]},"sunday":{"start":"09:00","end":"18:00","breaks":[{"start":"14:30","end":"15:00"}]}}', NULL, 1, 0, NULL, NULL, 0, NULL, NULL, NULL, 30, 90, 'default');

[381] Fix | Delete

[382] Fix | Delete

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

[383] Fix | Delete

[384] Fix | Delete

[385] Fix | Delete

-- Table structure for table `ea_webhooks`

[386] Fix | Delete

[387] Fix | Delete

[388] Fix | Delete

CREATE TABLE `ea_webhooks` (

[389] Fix | Delete

`id` int(11) NOT NULL AUTO_INCREMENT,

[390] Fix | Delete

`create_datetime` datetime DEFAULT NULL,

[391] Fix | Delete

`update_datetime` datetime DEFAULT NULL,

[392] Fix | Delete

`name` varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[393] Fix | Delete

`url` text COLLATE utf8mb4_unicode_ci,

[394] Fix | Delete

`actions` text COLLATE utf8mb4_unicode_ci,

[395] Fix | Delete

`secret_token` varchar(512) COLLATE utf8mb4_unicode_ci DEFAULT NULL,

[396] Fix | Delete

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

[397] Fix | Delete

`notes` text COLLATE utf8mb4_unicode_ci,

[398] Fix | Delete

PRIMARY KEY (`id`)

[399] Fix | Delete

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

[400] Fix | Delete

[401] Fix | Delete

[402] Fix | Delete

-- Constraints for dumped tables

[403] Fix | Delete

[404] Fix | Delete

[405] Fix | Delete

[406] Fix | Delete

-- Constraints for table `ea_appointments`

[407] Fix | Delete

[408] Fix | Delete

ALTER TABLE `ea_appointments`

[409] Fix | Delete

ADD CONSTRAINT `appointments_services` FOREIGN KEY (`id_services`) REFERENCES `ea_services` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

[410] Fix | Delete

ADD CONSTRAINT `appointments_users_customer` FOREIGN KEY (`id_users_customer`) REFERENCES `ea_users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

[411] Fix | Delete

ADD CONSTRAINT `appointments_users_provider` FOREIGN KEY (`id_users_provider`) REFERENCES `ea_users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

[412] Fix | Delete

[413] Fix | Delete

[414] Fix | Delete

-- Constraints for table `ea_secretaries_providers`

[415] Fix | Delete

[416] Fix | Delete

ALTER TABLE `ea_secretaries_providers`

[417] Fix | Delete

ADD CONSTRAINT `secretaries_users_provider` FOREIGN KEY (`id_users_provider`) REFERENCES `ea_users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

[418] Fix | Delete

ADD CONSTRAINT `secretaries_users_secretary` FOREIGN KEY (`id_users_secretary`) REFERENCES `ea_users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

[419] Fix | Delete

[420] Fix | Delete

[421] Fix | Delete

-- Constraints for table `ea_services`

[422] Fix | Delete

[423] Fix | Delete

ALTER TABLE `ea_services`

[424] Fix | Delete

ADD CONSTRAINT `services_service_categories` FOREIGN KEY (`id_service_categories`) REFERENCES `ea_service_categories` (`id`) ON DELETE SET NULL ON UPDATE CASCADE;

[425] Fix | Delete

[426] Fix | Delete

[427] Fix | Delete

-- Constraints for table `ea_services_providers`

[428] Fix | Delete

[429] Fix | Delete

ALTER TABLE `ea_services_providers`

[430] Fix | Delete

ADD CONSTRAINT `services_providers_services` FOREIGN KEY (`id_services`) REFERENCES `ea_services` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,

[431] Fix | Delete

ADD CONSTRAINT `services_providers_users_provider` FOREIGN KEY (`id_users`) REFERENCES `ea_users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

[432] Fix | Delete

[433] Fix | Delete

[434] Fix | Delete

-- Constraints for table `ea_users`

[435] Fix | Delete

[436] Fix | Delete

ALTER TABLE `ea_users`

[437] Fix | Delete

ADD CONSTRAINT `users_roles` FOREIGN KEY (`id_roles`) REFERENCES `ea_roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

[438] Fix | Delete

[439] Fix | Delete

[440] Fix | Delete

-- Constraints for table `ea_user_settings`

[441] Fix | Delete

[442] Fix | Delete

ALTER TABLE `ea_user_settings`

[443] Fix | Delete

ADD CONSTRAINT `user_settings_users` FOREIGN KEY (`id_users`) REFERENCES `ea_users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

[444] Fix | Delete

[445] Fix | Delete

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

[446] Fix | Delete

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

[447] Fix | Delete

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

[448] Fix | Delete

[449] Fix | Delete