PMA_token |s:32:"602b353447403c76624f2e7c3366304f"; HMAC_secret |s:16:"B.*zS4*q/c%~.4GS";auth_type|s:3:"env";browser_access_time|a:1:{s:7:"default";i:1780820821;}encryption_key|s:32:"�{^5rg���=S�f�a��l�&����C�9Z��";relation|a:1:{i:1;a:41:{s:7:"version";s:5:"5.2.2";s:4:"user";N;s:2:"db";N;s:8:"bookmark";N;s:15:"central_columns";N;s:11:"column_info";N;s:17:"designer_settings";N;s:16:"export_templates";N;s:8:"favorite";N;s:7:"history";N;s:16:"navigationhiding";N;s:9:"pdf_pages";N;s:6:"recent";N;s:8:"relation";N;s:13:"savedsearches";N;s:12:"table_coords";N;s:10:"table_info";N;s:13:"table_uiprefs";N;s:8:"tracking";N;s:10:"userconfig";N;s:10:"usergroups";N;s:5:"users";N;s:12:"bookmarkwork";b:0;s:8:"mimework";b:0;s:18:"centralcolumnswork";b:0;s:8:"commwork";b:0;s:9:"menuswork";b:0;s:20:"designersettingswork";b:0;s:11:"displaywork";b:0;s:19:"exporttemplateswork";b:0;s:12:"favoritework";b:0;s:7:"navwork";b:0;s:7:"pdfwork";b:0;s:10:"recentwork";b:0;s:7:"relwork";b:0;s:17:"savedsearcheswork";b:0;s:11:"historywork";b:0;s:12:"trackingwork";b:0;s:11:"uiprefswork";b:0;s:14:"userconfigwork";b:0;s:8:"allworks";b:0;}}userconfig|a:2:{s:2:"db";a:2:{s:4:"lang";s:5:"en_GB";s:12:"Console/Mode";s:8:"collapse";}s:2:"ts";i:1780820821;}two_factor_check|b:1;cache|a:2:{s:8:"server_1";a:3:{s:15:"userprefs_mtime";i:1780820764;s:14:"userprefs_type";s:7:"session";s:12:"config_mtime";i:1758155934;}s:17:"server_1_xedaptot";a:16:{s:17:"is_create_db_priv";b:0;s:14:"is_reload_priv";b:0;s:12:"db_to_create";s:0:"";s:30:"dbs_where_create_table_allowed";a:36:{i:0;s:14:"xedaptot\_mail";i:1;s:23:"xedaptot\_mrsimple\_app";i:2;s:23:"xedaptot\_mrsimple\_bus";i:3;s:23:"xedaptot\_mrsimple\_xdt";i:4;s:26:"xedaptot\_mrsimple\_rencar";i:5;s:24:"xedaptot\_mrsimple\_vlxd";i:6;s:23:"xedaptot\_mrsimple\_cms";i:7;s:23:"xedaptot\_mrsimple\_pps";i:8;s:13:"xedaptot\_rms";i:9;s:15:"xedaptot\_xdtvn";i:10;s:25:"xedaptot\_mrsimple\_iphim";i:11;s:27:"xedaptot\_mrsimple\_partner";i:12;s:17:"xedaptot\_leeanna";i:13;s:22:"xedaptot\_mrsimple\_cv";i:14;s:22:"xedaptot\_mrsimple\_be";i:15;s:24:"xedaptot\_mrsimple\_work";i:16;s:22:"xedaptot\_mrsimple\_ms";i:17;s:13:"xedaptot\_360";i:18;s:24:"xedaptot\_mrsimple\_nani";i:19;s:23:"xedaptot\_mrsimple\_360";i:20;s:27:"xedaptot\_mrsimple\_profile";i:21;s:27:"xedaptot\_mrsimple\_barbook";i:22;s:28:"xedaptot\_mrsimple\_tracking";i:23;s:25:"xedaptot\_mrsimple\_edutg";i:24;s:25:"xedaptot\_mrsimple\_gifts";i:25;s:26:"xedaptot\_mrsimple\_hotels";i:26;s:22:"xedaptot\_mrsimple\_ag";i:27;s:23:"xedaptot\_mrsimple\_ptg";i:28;s:14:"xedaptot\_qlks";i:29;s:16:"xedaptot\_barber";i:30;s:23:"xedaptot\_mrsimple\_fnb";i:31;s:23:"xedaptot\_mrsimple\_std";i:32;s:12:"xedaptot\_ag";i:33;s:22:"xedaptot\_mrsimple\_hi";i:34;s:23:"xedaptot\_mrsimple\_hsc";i:35;s:23:"xedaptot\_mrsimple\_ccs";}s:11:"dbs_to_test";b:0;s:9:"proc_priv";b:0;s:10:"table_priv";b:0;s:8:"col_priv";b:0;s:7:"db_priv";b:0;s:11:"binary_logs";a:0:{}s:18:"menu-levels-server";a:13:{s:9:"databases";s:9:"Databases";s:3:"sql";s:3:"SQL";s:6:"status";s:6:"Status";s:6:"rights";s:5:"Users";s:6:"export";s:6:"Export";s:6:"import";s:6:"Import";s:8:"settings";s:8:"Settings";s:6:"binlog";s:10:"Binary log";s:11:"replication";s:11:"Replication";s:4:"vars";s:9:"Variables";s:7:"charset";s:8:"Charsets";s:7:"plugins";s:8:"Plug-ins";s:6:"engine";s:7:"Engines";}s:14:"menu-levels-db";a:14:{s:9:"structure";s:9:"Structure";s:3:"sql";s:3:"SQL";s:6:"search";s:6:"Search";s:5:"query";s:5:"Query";s:6:"export";s:6:"Export";s:6:"import";s:6:"Import";s:9:"operation";s:10:"Operations";s:10:"privileges";s:10:"Privileges";s:8:"routines";s:8:"Routines";s:6:"events";s:6:"Events";s:8:"triggers";s:8:"Triggers";s:8:"tracking";s:8:"Tracking";s:8:"designer";s:8:"Designer";s:15:"central_columns";s:15:"Central columns";}s:12:"is_superuser";b:0;s:14:"mysql_cur_user";s:18:"xedaptot@localhost";s:12:"is_grantuser";b:0;s:13:"is_createuser";b:0;}}tmpval|a:14:{s:14:"favoriteTables";a:1:{i:1;a:0:{}}s:12:"recentTables";a:1:{i:1;a:0:{}}s:18:"table_limit_offset";i:0;s:21:"table_limit_offset_db";s:12:"xedaptot_rms";s:5:"query";a:10:{s:32:"26684a6d8ba6babdab6270863ef06d77";a:8:{s:3:"sql";s:694:"CREATE TABLE pricing_rules (
  id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  hotel_id BIGINT UNSIGNED NOT NULL,
  name VARCHAR(255) NOT NULL,
  occupancy_min DECIMAL(6,2) NULL,
  occupancy_max DECIMAL(6,2) NULL,
  pickup_min INT NULL,
  booking_window_min INT NULL,
  booking_window_max INT NULL,
  day_of_week VARCHAR(255) NULL,
  season VARCHAR(255) NULL,
  adjustment_percent DECIMAL(6,2) NOT NULL,
  active TINYINT(1) NOT NULL DEFAULT 1,
  created_at TIMESTAMP NULL,
  updated_at TIMESTAMP NULL,
  PRIMARY KEY (id),
  CONSTRAINT pricing_rules_hotel_id_foreign FOREIGN KEY (hotel_id) REFERENCES hotels(id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"769c55c8a8ec2b67c2f0a11186efe011";a:8:{s:3:"sql";s:490:"CREATE TABLE competitors (
  id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  hotel_id BIGINT UNSIGNED NOT NULL,
  name VARCHAR(255) NOT NULL,
  rate_date DATE NOT NULL,
  competitor_rate DECIMAL(12,2) NOT NULL,
  room_type VARCHAR(255) NULL,
  created_at TIMESTAMP NULL,
  updated_at TIMESTAMP NULL,
  PRIMARY KEY (id),
  CONSTRAINT competitors_hotel_id_foreign FOREIGN KEY (hotel_id) REFERENCES hotels(id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"62d38f4ef79bdb7f128b57a3e937ae5c";a:8:{s:3:"sql";s:465:"CREATE TABLE reports (
  id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
  hotel_id BIGINT UNSIGNED NOT NULL,
  type VARCHAR(255) NOT NULL,
  period_start DATE NOT NULL,
  period_end DATE NOT NULL,
  payload JSON NOT NULL,
  created_at TIMESTAMP NULL,
  updated_at TIMESTAMP NULL,
  PRIMARY KEY (id),
  CONSTRAINT reports_hotel_id_foreign FOREIGN KEY (hotel_id) REFERENCES hotels(id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"0934f31d2a3a7133bc56c5de6f896ef2";a:8:{s:3:"sql";s:212:"INSERT INTO hotels (id, name, code, city, currency, total_rooms, gross_profit_margin, created_at, updated_at) VALUES
(1, 'Saigon Harbor Hotel', 'SAIGON-DEMO', 'Ho Chi Minh City', 'USD', 120, 38.00, NOW(), NOW());";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"33464c6c423c4ea4d712f571f781c09f";a:8:{s:3:"sql";s:513:"INSERT INTO users (id, hotel_id, name, email, role, password, created_at, updated_at) VALUES
(1, 1, 'Admin', '[email protected]', 'admin', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi.', NOW(), NOW()),
(2, 1, 'Revenue Manager', '[email protected]', 'revenue_manager', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi.', NOW(), NOW()),
(3, 1, 'Reservation Staff', '[email protected]', 'reservation_staff', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi.', NOW(), NOW());";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"951dd401736bd91d4a6aa5ab960cb541";a:8:{s:3:"sql";s:389:"INSERT INTO room_types (id, hotel_id, name, code, room_count, base_rate, min_rate, max_rate, created_at, updated_at) VALUES
(1, 1, 'Superior', 'SUP', 55, 85.00, 62.00, 140.00, NOW(), NOW()),
(2, 1, 'Deluxe', 'DLX', 35, 115.00, 82.00, 190.00, NOW(), NOW()),
(3, 1, 'Suite', 'STE', 20, 185.00, 135.00, 320.00, NOW(), NOW()),
(4, 1, 'Family', 'FAM', 10, 155.00, 110.00, 260.00, NOW(), NOW());";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"cbb103b3adfdfc92f891461a6d65f73d";a:8:{s:3:"sql";s:499:"INSERT INTO pricing_rules (hotel_id, name, occupancy_min, occupancy_max, pickup_min, booking_window_min, booking_window_max, day_of_week, season, adjustment_percent, active, created_at, updated_at) VALUES
(1, 'High Occupancy Yield', 80.00, NULL, NULL, NULL, NULL, NULL, NULL, 15.00, 1, NOW(), NOW()),
(1, 'Low Occupancy Stimulus', NULL, 40.00, NULL, NULL, NULL, NULL, NULL, -10.00, 1, NOW(), NOW()),
(1, 'Weekend Pickup Premium', NULL, NULL, 18, NULL, NULL, 'Saturday', NULL, 8.00, 1, NOW(), NOW());";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"26bb4558748f22db549f1c303cc9fb7f";a:8:{s:3:"sql";s:1345:"INSERT INTO reservations (hotel_id, room_type_id, stay_date, rooms_sold, room_revenue, total_revenue, market_segment, booked_at, created_at, updated_at) VALUES
(1, 1, CURDATE(), 44, 3960.00, 4610.00, 'Transient', DATE_SUB(CURDATE(), INTERVAL 12 DAY), NOW(), NOW()),
(1, 2, CURDATE(), 27, 3260.00, 3890.00, 'Corporate', DATE_SUB(CURDATE(), INTERVAL 18 DAY), NOW(), NOW()),
(1, 3, CURDATE(), 15, 2925.00, 3480.00, 'OTA', DATE_SUB(CURDATE(), INTERVAL 7 DAY), NOW(), NOW()),
(1, 4, CURDATE(), 8, 1320.00, 1580.00, 'Group', DATE_SUB(CURDATE(), INTERVAL 20 DAY), NOW(), NOW()),
(1, 1, DATE_SUB(CURDATE(), INTERVAL 1 DAY), 39, 3510.00, 4070.00, 'Transient', DATE_SUB(CURDATE(), INTERVAL 13 DAY), NOW(), NOW()),
(1, 2, DATE_SUB(CURDATE(), INTERVAL 1 DAY), 24, 2760.00, 3310.00, 'Corporate', DATE_SUB(CURDATE(), INTERVAL 16 DAY), NOW(), NOW()),
(1, 3, DATE_SUB(CURDATE(), INTERVAL 1 DAY), 13, 2535.00, 2990.00, 'OTA', DATE_SUB(CURDATE(), INTERVAL 8 DAY), NOW(), NOW()),
(1, 4, DATE_SUB(CURDATE(), INTERVAL 1 DAY), 7, 1120.00, 1370.00, 'Group', DATE_SUB(CURDATE(), INTERVAL 22 DAY), NOW(), NOW()),
(1, 1, DATE_SUB(CURDATE(), INTERVAL 2 DAY), 36, 3060.00, 3560.00, 'Transient', DATE_SUB(CURDATE(), INTERVAL 15 DAY), NOW(), NOW()),
(1, 2, DATE_SUB(CURDATE(), INTERVAL 2 DAY), 22, 2530.00, 3040.00, 'OTA', DATE_SUB(CURDATE(), INTERVAL 10 DAY), NOW(), NOW());";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"85ae4a5c410ff95f4fbf6c040c376f2e";a:8:{s:3:"sql";s:367:"INSERT INTO competitors (hotel_id, name, rate_date, competitor_rate, room_type, created_at, updated_at) VALUES
(1, 'Hotel Alpha', CURDATE(), 102.00, 'Deluxe', NOW(), NOW()),
(1, 'Bayfront Suites', CURDATE(), 126.00, 'Deluxe', NOW(), NOW()),
(1, 'Central Palace', CURDATE(), 111.00, 'Deluxe', NOW(), NOW()),
(1, 'Urban Nest', CURDATE(), 95.00, 'Deluxe', NOW(), NOW());";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"7eba262d9c6cf4b59fd409586a6253c0";a:8:{s:3:"sql";s:272:"INSERT INTO forecasts (hotel_id, period_start, period_end, granularity, occupancy_forecast, adr_forecast, revenue_forecast, accuracy, created_at, updated_at) VALUES
(1, CURDATE(), DATE_ADD(CURDATE(), INTERVAL 1 DAY), 'daily', 74.50, 112.80, 10090.00, 87.20, NOW(), NOW());";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}}s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;s:12:"display_blob";b:0;s:19:"hide_transformation";b:0;s:3:"pos";i:0;s:8:"max_rows";i:25;s:12:"repeat_cells";i:100;}git_location|N;is_git_revision|b:0;ConfigFile1|a:4:{s:28:"PmaNoRelation_DisableWarning";b:1;s:12:"ShowCreateDb";b:0;s:7:"Console";a:1:{s:4:"Mode";s:8:"collapse";}s:7:"Servers";a:1:{i:1;a:2:{s:7:"only_db";s:0:"";s:7:"hide_db";s:0:"";}}}debug|a:0:{}flashMessages|a:0:{}__upload_status|a:1:{s:7:"handler";s:47:"PhpMyAdmin\Plugins\Import\Upload\UploadNoplugin";}Import_message|a:2:{s:7:"message";s:215:"<div class="alert alert-success" role="alert">
  <img src="themes/dot.gif" title="" alt="" class="icon ic_s_success"> <em>Import has been successfully finished, 39 queries executed.</em> (install-cpanel.sql)
</div>
";s:11:"go_back_url";s:48:"index.php?route=/database/import&db=xedaptot_rms";}is_multi_query|b:1;sql_history|a:1:{i:0;a:3:{s:2:"db";s:12:"xedaptot_rms";s:5:"table";s:0:"";s:8:"sqlquery";s:272:"INSERT INTO forecasts (hotel_id, period_start, period_end, granularity, occupancy_forecast, adr_forecast, revenue_forecast, accuracy, created_at, updated_at) VALUES
(1, CURDATE(), DATE_ADD(CURDATE(), INTERVAL 1 DAY), 'daily', 74.50, 112.80, 10090.00, 87.20, NOW(), NOW());";}}errors|a:0:{}