-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `museum-visit`
--

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

--
-- Table structure for table `office_assignment`
--

CREATE TABLE `office_assignment` (
  `id` varchar(100) NOT NULL,
  `user_id` int NOT NULL,
  `office_id` varchar(100) NOT NULL,
  `active_status` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `office_assignment`
--

INSERT INTO `office_assignment` (`id`, `user_id`, `office_id`, `active_status`, `created_at`, `updated_at`, `deleted`) VALUES
('DXl1XW7gHiq8X7QFdEACFsPqIACKXD5C', 302, '1651713851400388861724', 0, '2025-01-29 01:23:09', NULL, 0),
('iccVxVt9KzIgff5AXRhOJU29tFrDrjYS', 689, '1651713866595811483368', 0, '2025-01-28 08:16:36', NULL, 1),
('Iv0CyfN_ew7zaL5zyEwlGwltP5O9Hvdm', 689, '1651713851400388861724', 0, '2025-01-28 08:17:02', NULL, 1),
('iWwySqnLzJDyFZdZmAaj8e5BXAgizXcA', 689, '1651713866595811483368', 0, '2025-01-28 08:15:53', NULL, 1),
('KkvS7uafzhAmAMgFgLZTbefmv7xvEqG6', 689, '1651713915328297614792', 0, '2025-01-28 08:16:03', NULL, 1),
('m3gdYAGFBsA6oOHUV8urtpssbLF_CK1I', 689, '1651713866595811483368', 0, '2025-01-28 07:55:20', NULL, 1),
('MtCSVgJ5JuDmcOAp4b4M9SnktTg9x-lT', 689, '1651713851400388861724', 0, '2025-01-28 08:03:25', NULL, 1),
('sIImrxQjBu1rG7gab5aRhEL6nD6ZjMOb', 683, '1651713851400388861724', 0, '2025-01-28 08:16:29', NULL, 1),
('uM99jSikQ43rNw-of4l5eAF4TvgV8YHA', 683, '1651713851400388861724', 0, '2025-01-28 08:16:09', NULL, 1),
('Wv3Vvy7ui_qLzTbOGU1quMqnFfAWS9NX', 683, '1651713851400388861724', 0, '2025-01-28 08:03:30', NULL, 1),
('xuAhcmX-tc5VB1urih9MKSRxyTENnxyG', 683, '1651713866595811483368', 0, '2025-01-28 07:55:24', NULL, 1),
('ziHFRKbkNTPjj5P6BRJS75ndWpaSpePj', 689, '1651713851400388861724', 0, '2025-01-28 08:16:49', NULL, 1);

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

--
-- Table structure for table `visitor_external_details`
--

CREATE TABLE `visitor_external_details` (
  `id` varchar(100) NOT NULL,
  `visitor_external_id` varchar(100) NOT NULL,
  `log_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `companion` tinyint NOT NULL DEFAULT '0',
  `companion_assistance` tinyint NOT NULL DEFAULT '0',
  `zero_five_male` int NOT NULL DEFAULT '0',
  `zero_five_female` int NOT NULL DEFAULT '0',
  `six_twelve_male` int NOT NULL DEFAULT '0',
  `six_twelve_female` int NOT NULL DEFAULT '0',
  `senior_male` int NOT NULL DEFAULT '0',
  `senior_female` int NOT NULL DEFAULT '0',
  `total` int NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `deleted` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `visitor_external_details`
--

INSERT INTO `visitor_external_details` (`id`, `visitor_external_id`, `log_id`, `companion`, `companion_assistance`, `zero_five_male`, `zero_five_female`, `six_twelve_male`, `six_twelve_female`, `senior_male`, `senior_female`, `total`, `created_at`, `updated_at`, `deleted`) VALUES
('15lK0dg8LqJpRAQhoihpMSLe5To71m2j', 'LE1738114613', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2025-01-29 01:36:53', NULL, 0),
('1v7usC58al-ABXuNrKfaDw7-WBQz2mj0', 'jJ1732949505', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2024-11-30 06:51:45', NULL, 0),
('1ZICpx9mPY7J1738116548', 'LE1738114613', 'rhCOo6NeLLpn1738116548', 0, 0, 0, 0, 0, 0, 0, 0, 0, '2025-01-29 02:09:08', NULL, 0),
('2axtxC18OtvpstmQpOQN8S3Q01hERVuo', 'Un1732949953', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2024-11-30 06:59:13', NULL, 0),
('3gyet4RoA5GSdfBwgyxog9HS16NkIRmw', 'L51730259923', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2024-10-30 03:45:23', NULL, 0),
('7CIKM5YTfhve7wWRwn1XLGxzMYGGT2rh', 'rJ1730191530', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2024-10-29 08:45:30', NULL, 0),
('7CJOzohko6na_if-Pswnbg0CVsi8J_EF', 'UH1732949549', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2024-11-30 06:52:29', NULL, 0),
('7yGQAWUwyPqN1726130518', 'LW1726130464', 'zNznVFzMBLlc1726130517', 0, 0, 1, 2, 0, 0, 0, 0, 3, '2024-09-12 08:41:58', NULL, 0),
('9zT_FUx8FHM_CjSZQTKfFKpauyea2HpS', '9m1732949818', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2024-11-30 06:56:58', NULL, 0),
('B1KnCusCaH6vHfHt0QTrwSs_FDMWa2aD', 'Vf1732950313', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2024-11-30 07:05:13', NULL, 0),
('c5z0yc38IHdV1738116456', 'LE1738114613', 'zuqFgGHG-LVA1738116456', 0, 0, 0, 0, 0, 0, 0, 0, 0, '2025-01-29 02:07:36', NULL, 0),
('cxOlQ9z3oqdjIHhHmugRAQtxwFAnSOPK', 'oQ1732950413', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2024-11-30 07:06:53', NULL, 0),
('DDyjWuLfV9On_9--7_5yZFqKqpQrFyoS', 'zw1734668492', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2024-12-20 04:21:32', NULL, 0),
('g6eI8Q3N3ZH41730259964', 'L51730259923', 'yIWoNmOy2utg1730259963', 0, 0, 0, 0, 0, 0, 0, 0, 0, '2024-10-30 03:46:04', NULL, 0),
('GJ8xBmp2P3_V1726130478', 'LW1726130464', 'keqzo5LGznIa1726130478', 0, 0, 1, 1, 0, 0, 0, 0, 2, '2024-09-12 08:41:18', NULL, 0),
('hcBc2MZ9SNu_mJwKY4n-UfvaBrybUAYP', 'LV1730615278', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2024-11-03 06:27:58', NULL, 0),
('HGve-bWbQQy71730259240', 'p21730255444', 'Tb4gcdd0gwJj1730259240', 0, 0, 0, 0, 0, 0, 0, 0, 0, '2024-10-30 03:34:00', NULL, 0),
('hL2V7Oxt55h74fcOzeAVKOp7ZwPdVZzS', 'CC1730260054', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2024-10-30 03:47:34', NULL, 0),
('I8ShaK6cno6ukLvNJPaIugqGmZDUzzOr', 'kD1727915766', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2024-10-03 00:36:06', NULL, 0),
('jFqC-28Mo2V5p7YLPXdj0qwUy8rka5I6', '3k1732950194', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2024-11-30 07:03:14', NULL, 0),
('k55_kfHP5T72DdZypLgTMuIEDgwuzuDe', '2C1726816507', NULL, 0, 0, 1, 0, 0, 0, 0, 0, 1, '2024-09-20 07:15:07', NULL, 0),
('LhUNRSe0qKEtpYM7-sLbuEy7SE94Vvq1', 'n21734670452', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2024-12-20 04:54:12', NULL, 0),
('LVZAaPOxcUeeK3Tpljw0i7ROjR0cIqIP', 'As1730265727', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2024-10-30 05:22:07', NULL, 0),
('M3CJVCZg2r5M1726130886', 'LW1726130464', 'yLhUFDGUPKfU1726130886', 0, 0, 1, 3, 0, 0, 0, 0, 4, '2024-09-12 08:48:06', NULL, 0),
('N2kiqsMWvMrP1730260073', 'CC1730260054', 'j34Jb0lCO4qB1730260073', 0, 0, 0, 0, 0, 0, 0, 0, 0, '2024-10-30 03:47:53', NULL, 0),
('nacHjcwtuJh9_iRKN5tl8lKrkeO_q0eM', 'LW1726130464', NULL, 0, 0, 1, 1, 0, 0, 0, 0, 2, '2024-09-12 08:41:04', NULL, 0),
('NI-A4QULy5wu6WpZtMys-bHgRs9SBHlk', 'X91732950137', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2024-11-30 07:02:17', NULL, 0),
('RcrXRNR8IM5RO5LL_BqZJst_2XEN1pol', 'M01732949709', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2024-11-30 06:55:09', NULL, 0),
('RW0Qhdn7waEZ25nYP2fc2tnZMcFlYwgM', 'Vn1732950054', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2024-11-30 07:00:54', NULL, 0),
('TCgFg8K1sQAk2kQc-ivpc8S4Ab5l5CF9', 'Lm1732949420', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2024-11-30 06:50:20', NULL, 0),
('ToEmJDG_wPWzRV9_5c2_EHcBSuyJT9Ll', 'tZ1734666650', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2024-12-20 03:50:50', NULL, 0),
('uPvIeJbK--PS1726131038', 'LW1726130464', '3UwEdFyMugWV1726131038', 0, 0, 1, 9, 0, 0, 0, 0, 10, '2024-09-12 08:50:38', NULL, 0),
('YBXdl9IZO_VmfDdT_AUL7szDfe080vyX', 'p21730255444', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2024-10-30 02:30:44', NULL, 0),
('Zuf63J1wCSB_Vu3JXrTfEXYkAX4OV5jJ', 'c51730191292', NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, '2024-10-29 08:41:32', NULL, 0);

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

--
-- Table structure for table `visitor_external_log`
--

CREATE TABLE `visitor_external_log` (
  `id` varchar(100) NOT NULL,
  `visitor_external_id` varchar(100) NOT NULL,
  `museum_id` varchar(100) NOT NULL,
  `visitation_id` varchar(100) NOT NULL,
  `log_date` date NOT NULL,
  `log_time` time NOT NULL,
  `receptionist_id` varchar(100) NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0 = accepted; 1 = declined',
  `remarks` text,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `deleted` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `visitor_external_log`
--

INSERT INTO `visitor_external_log` (`id`, `visitor_external_id`, `museum_id`, `visitation_id`, `log_date`, `log_time`, `receptionist_id`, `status`, `remarks`, `created_at`, `updated_at`, `deleted`) VALUES
('_58BPbFr1p_71738116441', 'LE1738114613', '1651713851400388861724', '2025012-000001', '2025-01-29', '10:07:21', '302', 2, NULL, '2025-01-29 02:07:21', NULL, 0),
('_mPON0M64rMF1738115971', 'LE1738114613', '1651713851400388861724', '2025012-000001', '2025-01-29', '09:59:31', '302', 2, NULL, '2025-01-29 01:59:31', NULL, 0),
('_zG80IDMwqHY1738116541', 'LE1738114613', '1651713851400388861724', '2025012-000001', '2025-01-29', '10:09:01', '302', 2, NULL, '2025-01-29 02:09:01', NULL, 0),
('00NBcIdn3hZt1738115971', 'LE1738114613', '1651713851400388861724', '2025012-000001', '2025-01-29', '09:59:31', '302', 2, NULL, '2025-01-29 01:59:31', NULL, 0),
('3UwEdFyMugWV1726131038', 'LW1726130464', '1651713851400388861724', '2024092-000001', '2024-09-12', '16:50:38', '302', 1, 'wrong qr', '2024-09-12 08:50:38', NULL, 0),
('5p0FwftfR6Yz1738116269', 'LE1738114613', '1651713851400388861724', '2025012-000001', '2025-01-29', '10:04:29', '302', 2, NULL, '2025-01-29 02:04:29', NULL, 0),
('5p2jSYYA9YaN1738116131', 'LE1738114613', '1651713851400388861724', '2025012-000001', '2025-01-29', '10:02:11', '302', 2, NULL, '2025-01-29 02:02:11', NULL, 0),
('6lXQOk55TTgT1738116131', 'LE1738114613', '1651713851400388861724', '2025012-000001', '2025-01-29', '10:02:11', '302', 2, NULL, '2025-01-29 02:02:11', NULL, 0),
('6YFfO8F7AwjJ1738116323', 'LE1738114613', '1651713851400388861724', '2025012-000001', '2025-01-29', '10:05:23', '302', 2, NULL, '2025-01-29 02:05:23', NULL, 0),
('9RWcjjcBsORi1738116214', 'LE1738114613', '1651713851400388861724', '2025012-000001', '2025-01-29', '10:03:34', '302', 2, NULL, '2025-01-29 02:03:34', NULL, 0),
('bWzJU-RALZ4p1738115854', 'LE1738114613', '1651713851400388861724', '2025012-000001', '2025-01-29', '09:57:34', '302', 2, NULL, '2025-01-29 01:57:34', NULL, 0),
('E5JSEVkuDv0U1738115996', 'LE1738114613', '1651713851400388861724', '2025012-000001', '2025-01-29', '09:59:56', '302', 2, NULL, '2025-01-29 01:59:56', NULL, 0),
('EZoQC0WiIMaJ1738116426', 'LE1738114613', '1651713851400388861724', '2025012-000001', '2025-01-29', '10:07:06', '302', 2, NULL, '2025-01-29 02:07:06', NULL, 0),
('Hl4x9N0UjAML1738116323', 'LE1738114613', '1651713851400388861724', '2025012-000001', '2025-01-29', '10:05:23', '302', 2, NULL, '2025-01-29 02:05:23', NULL, 0),
('IoqAke4yuawe1738116378', 'LE1738114613', '1651713851400388861724', '2025012-000001', '2025-01-29', '10:06:18', '302', 2, NULL, '2025-01-29 02:06:18', NULL, 0),
('j34Jb0lCO4qB1730260073', 'CC1730260054', '1651713851400388861724', '2024102-000006', '2024-10-30', '11:47:53', '5', 0, NULL, '2024-10-30 03:47:53', NULL, 0),
('keqzo5LGznIa1726130478', 'LW1726130464', '1651713851400388861724', '2024092-000001', '2024-09-12', '16:41:18', '302', 0, NULL, '2024-09-12 08:41:18', NULL, 0),
('KFri1T4xfuA71738116378', 'LE1738114613', '1651713851400388861724', '2025012-000001', '2025-01-29', '10:06:18', '302', 2, NULL, '2025-01-29 02:06:18', NULL, 0),
('lH09i24MN8A01738116269', 'LE1738114613', '1651713851400388861724', '2025012-000001', '2025-01-29', '10:04:29', '302', 2, NULL, '2025-01-29 02:04:29', NULL, 0),
('N9NkLNPOEUid1738116454', 'LE1738114613', '1651713851400388861724', '2025012-000001', '2025-01-29', '10:07:34', '302', 2, NULL, '2025-01-29 02:07:34', NULL, 0),
('qalKUE7S0czX1738116214', 'LE1738114613', '1651713851400388861724', '2025012-000001', '2025-01-29', '10:03:34', '302', 2, NULL, '2025-01-29 02:03:34', NULL, 0),
('rapxyJsTBhHX1738115854', 'LE1738114613', '1651713851400388861724', '2025012-000001', '2025-01-29', '09:57:34', '302', 2, NULL, '2025-01-29 01:57:34', NULL, 0),
('rhCOo6NeLLpn1738116548', 'LE1738114613', '1651713851400388861724', '2025012-000001', '2025-01-29', '10:09:08', '302', 1, 'Declined', '2025-01-29 02:09:08', NULL, 0),
('Tb4gcdd0gwJj1730259240', 'p21730255444', '1651713851400388861724', '2024102-000004', '2024-10-30', '11:34:00', '5', 0, NULL, '2024-10-30 03:34:00', NULL, 0),
('TEFzbbA9SmgB1738116454', 'LE1738114613', '1651713851400388861724', '2025012-000001', '2025-01-29', '10:07:34', '302', 2, NULL, '2025-01-29 02:07:34', NULL, 0),
('uSSEmjUiPyR41738115996', 'LE1738114613', '1651713851400388861724', '2025012-000001', '2025-01-29', '09:59:56', '302', 2, NULL, '2025-01-29 01:59:56', NULL, 0),
('vZTMEwR0kDwP1738116541', 'LE1738114613', '1651713851400388861724', '2025012-000001', '2025-01-29', '10:09:01', '302', 2, NULL, '2025-01-29 02:09:01', NULL, 0),
('Whsbsq9ucMKO1738116441', 'LE1738114613', '1651713851400388861724', '2025012-000001', '2025-01-29', '10:07:21', '302', 2, NULL, '2025-01-29 02:07:21', NULL, 0),
('Y_4rz5pdpt241738116426', 'LE1738114613', '1651713851400388861724', '2025012-000001', '2025-01-29', '10:07:06', '302', 2, NULL, '2025-01-29 02:07:06', NULL, 0),
('yIWoNmOy2utg1730259963', 'L51730259923', '1651713851400388861724', '2024102-000005', '2024-10-30', '11:46:04', '5', 0, NULL, '2024-10-30 03:46:04', NULL, 0),
('yLhUFDGUPKfU1726130886', 'LW1726130464', '1651713851400388861724', '2024092-000001', '2024-09-12', '16:48:06', '302', 1, 'wrong qr', '2024-09-12 08:48:06', NULL, 0),
('zNznVFzMBLlc1726130517', 'LW1726130464', '1651713851400388861724', '2024092-000001', '2024-09-12', '16:41:58', '302', 1, 'WRONG QR', '2024-09-12 08:41:58', NULL, 0),
('zuqFgGHG-LVA1738116456', 'LE1738114613', '1651713851400388861724', '2025012-000001', '2025-01-29', '10:07:36', '302', 0, NULL, '2025-01-29 02:07:36', NULL, 0);

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

--
-- Table structure for table `visitor_external_type`
--

CREATE TABLE `visitor_external_type` (
  `id` varchar(100) NOT NULL,
  `sort` varchar(1) DEFAULT NULL,
  `type` varchar(100) NOT NULL,
  `description` text NOT NULL,
  `tagalog_description` text,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `deleted` tinyint(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `visitor_external_type`
--

INSERT INTO `visitor_external_type` (`id`, `sort`, `type`, `description`, `tagalog_description`, `created_at`, `updated_at`, `deleted`) VALUES
('3acbiUFTJLAE_Xut7D-MSR096098ijYt', '7', 'Foreign Tourist', 'How many of you are Foreign Tourists?', 'Ilan sa inyo ang mga Dayuhang Turista?', '2024-04-03 07:51:18', '2024-04-26 02:00:37', 0),
('3acbiUFTJLAE_Xut7D-MSR0961uYh46S', '8', 'Senior Citizen', 'How many of you are Senior Citizens?', 'Ilan sa inyo ang mga Senior Citizen?', '2024-04-03 07:51:18', '2024-04-26 02:01:17', 0),
('3acbiUFTJLAE_Xut7D-MSR09lk68jhYz', '9', 'Toddler', 'Is/are there any kids with you? If yes, how many?', 'Mayroon ka bang kasamang mga bata? Kung mayroon, ilan?', '2024-04-03 07:52:40', '2024-04-29 06:19:13', 0),
('EquSPKsowHKXo8VlOFDfPaRdo01U09Ij', '0', 'Manila', 'How many of you lives in City of Manila?', 'Ilan sa inyo ang nakatira sa Lungsod ng Maynila?', '2024-04-04 08:05:53', '2024-04-26 02:03:44', 0),
('EquSPKsowHKXo8VlOFDfPaRdo01Uhf&3', '5', 'Foreign Student', 'How many of you are Foreign students?', 'Ilan sa inyo ang mga Estudyanteng Dayuhan?', '2024-04-03 07:37:03', '2024-04-26 02:03:41', 0),
('EquSPKsowHKXo8VlOFDfPaRdo09mnhGt', '4', 'College Student', 'How many of you are College students?', 'Ilan sa inyo ang mga mag-aaral sa Kolehiyo?', '2024-04-03 07:34:58', '2024-04-26 02:03:38', 0),
('EquSPKsowHKXo8VlOFDfPaRdo4445434', '1', 'Elementary Student', 'How many of you are Elementary students?', 'Ilan sa inyo ang mga mag-aaral sa Elementarya?', '2024-04-03 07:33:36', '2024-04-26 02:04:28', 0),
('EquSPKsowHKXo8VlOFDfPaRdo5748398', '2', 'Junior Highschool Student', 'How many of you are JR Highschool students?', 'Ilan sa inyo ang mga mag-aaral sa Junior High School?', '2024-04-03 07:33:36', '2024-04-26 02:04:50', 0),
('EquSPKsowHKXo8VlOFDfPaRdold987ug', '3', 'Senior Highschool Student', 'How many of you are SR Highscool students?', 'Ilan sa inyo ang mga mag-aaral sa Senior High School', '2024-04-03 07:34:58', '2024-04-26 02:05:26', 0),
('EquSPKsowHKXo8VlOFDfPaRdooLmdn1W', '6', 'Local Tourist', 'How many of you are Local Tourists?', 'Ilan sa inyo ang mga Lokal na Turista?', '2024-04-03 07:37:03', '2024-04-26 02:06:53', 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `office_assignment`
--
ALTER TABLE `office_assignment`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `visitor_external_details`
--
ALTER TABLE `visitor_external_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `visitor_external_log`
--
ALTER TABLE `visitor_external_log`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `visitor_external_type`
--
ALTER TABLE `visitor_external_type`
  ADD PRIMARY KEY (`id`);
COMMIT;

