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

START TRANSACTION;



--
-- Database: `_bide_backend_v3`
--

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

--
-- Table structure for table `bide_admin_models`
--

CREATE TABLE `bide_admin_models` (
  `bide_admin_id` int(10) UNSIGNED NOT NULL,
  `admin_username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `admin_password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `admin_email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bide_merchant_id` int(11) NOT NULL,
  `admin_status` int(11) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bide_admin_models`
--

INSERT INTO `bide_admin_models` (`bide_admin_id`, `admin_username`, `admin_password`, `admin_email`, `bide_merchant_id`, `admin_status`, `created_at`, `updated_at`) VALUES
(12, 'Bide Solution', '$2y$10$kd1Nnx/ZcVxtj4pG7Kt.fOxfblKejmxVJ7Hsy4TxXUtqYVKMwF4xy', 'Bide.queue.official@gmail.com', 12, 1, '2021-06-30 07:12:11', '2021-06-30 07:12:11'),
(13, 'Ferry', '$2y$10$YRYBa0PaEZBe8ZSd3gcnfONZW4uVMff9gy.VJECIyKx.t3e0jYp8K', 'ferry.sschrisnandika@gmail.com', 13, 1, '2021-07-04 11:35:26', '2021-07-04 11:35:26'),
(14, 'Angelica Santoso', '$2y$10$7sPxNNeUU1R4K5utU4Wu9uJuzBAi3yjrh59Po9A2TqBo/SbbIV7W.', 'Ferry.chrisnandika2@gmail.com', 14, 1, '2021-07-08 04:52:37', '2021-07-08 04:52:37'),
(15, 'Chandra Aditya', '$2y$10$9ZcVLd0l9w1YNPWX7H/wee/VnypMGyCBdNgHDYWNdghFLeTD9JHEe', 'Ferry.chrisnandika@gmail.com', 15, 1, '2021-07-17 12:54:59', '2021-07-17 12:54:59'),
(16, 'terra', '$2y$10$AS4KTsSHTKtcSkGflgNa3efq71QtJ5MFdLlRIUwp87Y46qqnFnvaS', 'terra@gmail.com', 16, 1, '2021-09-06 06:43:37', '2021-09-06 06:43:37'),
(17, 'Herman', '$2y$10$8foqz12LTAbCQ1hRyoCJnuMnYi07vdbB783YuE/cijnx1nz/O4yTW', 'Martindonesia2017@gmail.com', 17, 1, '2021-09-07 12:23:29', '2021-09-07 12:23:29'),
(18, 'Terra', '$2y$10$P8f4hTdc.AvsCtdRsh7b5.EMDsx4gAvcLPVybT1U/muuKom.wqqeS', 'tengku.alfarizi1@gmail.com', 18, 1, '2021-09-10 07:33:27', '2021-09-10 07:33:27'),
(19, 'DUDI ASADUDDIN', '$2y$10$sejerZ.dmQEwYUIyEJlI.e6jI8Lh5BILuOqf.mGEG10jCOHLdCXyK', 'dudi@cakralintas.net', 19, 1, '2021-09-15 08:38:08', '2021-09-15 08:38:08');

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

--
-- Table structure for table `bide_merchant_models`
--

CREATE TABLE `bide_merchant_models` (
  `bide_merchant_id` int(10) UNSIGNED NOT NULL,
  `merchant_type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `merchant_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `merchant_address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `merchant_city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `merchant_industry` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `merchant_logo_path` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT 'https://backend.bide.id/default/logo.png',
  `background_poster` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'https://backend.bide.id/default/welcome.png',
  `finish_poster` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `merchant_qr_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `fcm_token` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nik_setting` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `opening_hours` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `closing_hours` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `max_capacity` int(11) DEFAULT NULL,
  `max_queue_pax` int(11) NOT NULL DEFAULT '10',
  `promo_enable` smallint(6) NOT NULL DEFAULT '0',
  `promo_text` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Isi dengan Promo dari merchant anda'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bide_merchant_models`
--

INSERT INTO `bide_merchant_models` (`bide_merchant_id`, `merchant_type`, `merchant_name`, `merchant_address`, `merchant_city`, `merchant_industry`, `merchant_logo_path`, `background_poster`, `finish_poster`, `created_at`, `updated_at`, `merchant_qr_id`, `fcm_token`, `nik_setting`, `opening_hours`, `closing_hours`, `max_capacity`, `max_queue_pax`, `promo_enable`, `promo_text`) VALUES
(12, 'Vaccination', 'Bide Lunch', 'Palmerah', 'Jakarta', 'Food', 'https://backend.bide.id/default/logo.png', 'https://backend.bide.id/default/welcome.png', 'https://backend.bide.id/default/goodbye.png', '2021-06-30 07:12:11', '2021-06-30 07:12:11', 'QR1913', 'eSOzdSXnTXW72FkxI5TpDt:APA91bGy2Kqce_GS-huasKjSVufIvsB7Vh0z7dw-615htcrgCcHtphg0mXBIwDvG_adUNV2D_CB6VbqdZdVltjna2WJagSazPBIzRA7PVEf04_nSGVxp8t0VPDr4SiX69zR6hxFc_hGD', '1', '05:00', '22:00', 50, 5, 0, 'Isi dengan Promo dari merchant anda'),
(13, 'Reservation', 'Klinik 24 jam Parung', 'Jalan raya Parung', 'Parung', 'Clinic', 'https://backend.bide.id/default/logo.png', 'https://backend.bide.id/default/welcome.png', 'https://backend.bide.id/default/goodbye.png', '2021-07-04 11:35:26', '2021-07-04 11:35:26', 'QR7361', 'ce0gHvpMQNO0vheIau6V-y:APA91bGupaPDNKHdsghYqnmtBNbmf1zT45cSetVLHRpeNuxAwquFm6O2bdNveCeAEB4OdDRSvFtaveZQK34crOfOWcvFck3c4FGwVmrVNN1HncvybW6WtmPbOU56M9-3R23v1p_Soi7v', '0', '09:00', '18:00', 50, 5, 0, 'Isi dengan Promo dari merchant anda'),
(14, 'Payment', 'Klinik Dokter 24 Jam Cinere', 'Jalan Cinere Raya No.86', 'DKI Jakarta', 'Clinic', 'https://backend.bide.id/default/logo.png', 'https://backend.bide.id/default/welcome.png', 'https://backend.bide.id/default/goodbye.png', '2021-07-08 04:52:37', '2021-07-08 04:52:37', 'QR1553', 'ce0gHvpMQNO0vheIau6V-y:APA91bGupaPDNKHdsghYqnmtBNbmf1zT45cSetVLHRpeNuxAwquFm6O2bdNveCeAEB4OdDRSvFtaveZQK34crOfOWcvFck3c4FGwVmrVNN1HncvybW6WtmPbOU56M9-3R23v1p_Soi7v', '0', '09:00', '18:00', 50, 5, 0, 'Isi dengan Promo dari merchant anda'),
(15, 'Reservation', 'Vaksinasi Nasional', 'Bogor', 'Bogor', 'Food & Beverages', 'https://pbs.twimg.com/profile_images/1472158182/LOGO-BNPB-BOX_400x400.jpg', 'https://backend.bide.id/default/welcome.png', 'https://backend.bide.id/default/goodbye.png', '2021-07-17 12:54:59', '2021-07-28 02:10:04', 'QR3133', 'eE0QGvMjTiK_0hrVPjOWAg:APA91bGJpZK5Q3wxTnauvp3CdTqE-E9YKXH2LBTUKwLVpTn0SwTFWiON4RSYPoHTcGhcp55jO5hGDjhQDNdVwOkOpkO807wOBbXWCxTnjmdP_Rr1IXGV8yBrMWRZtxGXVr8jQ8UcRBKR', '1', '08:09', '23:56', 50, 5, 1, 'Tetap jaga protokol kesehatan selama di lokasi.\r\n\r\nYuk kita hindari COVID-19 dengan 3M.\r\n'),
(16, 'Collect Order', 'terra', 'Jakarta', 'Jakarta', 'Food', 'https://backend.bide.id/default/logo.png', 'https://backend.bide.id/default/welcome.png', 'https://backend.bide.id/default/goodbye.png', '2021-09-06 06:43:37', '2021-09-06 06:43:37', 'QR9306', 'f6q2znejQJyYWZKRy6SKNi:APA91bGvQx8LQbzbrwIHTVcPCjjXMCz6EG6qXMdVIjry9VFz9WjiKbLfBBacWmSL4Ng-w3A_atANtqO9cXAxiDb9pW0WL44LsS7ioKmsXd1eh-fsx5z7ahPaRz7yZjaegnznEs2k_3CQ', '0', '09:00', '18:00', 50, 5, 0, 'Isi dengan Promo dari merchant anda'),
(17, 'No Queue', 'IAITB', 'Itb bandung', 'Bandung', 'Service', 'https://backend.bide.id/default/logo.png', 'https://backend.bide.id/default/welcome.png', 'https://backend.bide.id/default/goodbye.png', '2021-09-07 12:23:29', '2021-09-07 12:23:29', 'QR3178', 'dPhcWQRrS2qhjUvnMQMtgg:APA91bEqdaT8TfhAiZi7D9RBusV4iTntURUzR76XVJ0-aoDMpj0mQvDzIPK0c2CV4q0JxBc6Bg6_v_b8RMtyz83ny3iJOFQPi1y7WLtoGl3L_wSh-7mEJQcGr3pCMwZjkKtPZlgdhi_d', '0', '09:00', '18:00', 50, 5, 0, 'Isi dengan Promo dari merchant anda'),
(18, 'Collect Order', 'Terra', 'Terra', 'Jakarta', 'Food', 'https://backend.bide.id/default/logo.png', 'https://backend.bide.id/default/welcome.png', 'https://backend.bide.id/default/goodbye.png', '2021-09-10 07:33:27', '2021-09-10 07:33:27', 'QR8181', 'dIyZzANUS96lkAw1sRCtsr:APA91bGHnCPI5pqLdmzjDUMFh9g8HmZZribZrX9ltjnThDWV63o-G0SsTXkaEDlRyGBiiEkD6vow6-1bJj9N8Pj-tTlJ7EqmeeN4MBETHzU58V2_e_iJx9dTfgLtYUPpPJW85aNkbOvK', '0', '09:00', '18:00', 50, 5, 0, 'Isi dengan Promo dari merchant anda'),
(19, 'Payment', 'Channel-11', 'Jl bypass ngurahrai 274x', 'Badung', 'Other', 'https://backend.bide.id/default/logo.png', 'https://backend.bide.id/default/welcome.png', 'https://backend.bide.id/default/goodbye.png', '2021-09-15 08:38:08', '2021-09-15 08:38:08', 'QR7448', 'enJIO_5iRgGYU4o4-wiFbR:APA91bFw9Gi0TNV2ZIP8dWfDVFfqPR4zbIEwVwCykN-ssfvcJ1T3Td88c4qFQVINNoedg3h68UOgeYGzZZwl6G3jkKcLos0p4Ndf5JlRxmCcMxX6uG_j0KA35oRwHI2_pV44CenYr5ft', '0', '09:00', '18:00', 50, 5, 0, 'Isi dengan Promo dari merchant anda');

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

--
-- Table structure for table `bide_merchant_type_text`
--

CREATE TABLE `bide_merchant_type_text` (
  `bide_merchant_type_text_id` tinyint(4) NOT NULL,
  `merchant_type_id` varchar(50) NOT NULL,
  `merchant_type_text` varchar(50) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bide_merchant_type_text`
--

INSERT INTO `bide_merchant_type_text` (`bide_merchant_type_text_id`, `merchant_type_id`, `merchant_type_text`, `status`) VALUES
(1, 'Reservation', 'Reservasi', 1),
(2, 'Collect Order', 'Pengambilan Pesanan', 1),
(3, 'Payment', 'Pembayaran', 1),
(4, 'No Queue', 'Masuk', 1),
(5, 'Other', ' ', 1),
(7, 'Vaccination', 'Vaksin', 1);

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

--
-- Table structure for table `bide_queue_models`
--

CREATE TABLE `bide_queue_models` (
  `bide_queue_id` int(10) UNSIGNED NOT NULL,
  `bide_admin_id` int(11) NOT NULL,
  `bide_user_id` int(11) NOT NULL,
  `queue_nik` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `queue_number` int(11) NOT NULL,
  `queue_start_timestamp` bigint(20) DEFAULT NULL,
  `queue_update_timestamp` bigint(20) DEFAULT NULL,
  `queue_date_stamp` bigint(20) DEFAULT NULL,
  `queue_status` int(11) NOT NULL DEFAULT '0' COMMENT '0:queue|1:user confirm|2:serving|3:finish',
  `pax_number` int(11) NOT NULL DEFAULT '0',
  `queue_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `queue_notes` text COLLATE utf8mb4_unicode_ci,
  `table_number` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '-',
  `call_status_number` int(11) NOT NULL DEFAULT '0' COMMENT 'number of calling',
  `queue_channel` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `queue_user_status` tinyint(4) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bide_queue_models`
--

INSERT INTO `bide_queue_models` (`bide_queue_id`, `bide_admin_id`, `bide_user_id`, `queue_nik`, `queue_number`, `queue_start_timestamp`, `queue_update_timestamp`, `queue_date_stamp`, `queue_status`, `pax_number`, `queue_name`, `queue_notes`, `table_number`, `call_status_number`, `queue_channel`, `created_at`, `updated_at`, `queue_user_status`) VALUES
(56, 15, 68, '0', 1, 1631815969, 1631815969, 1631750400, 3, 1, 'FERRY', NULL, '-', 0, 'chatbot', '2021-09-16 18:12:49', '2021-09-16 18:22:39', 0),
(57, 15, 68, '0', 2, 1631816790, 1631816790, 1631750400, 3, 1, 'FERRY', NULL, '-', 0, 'chatbot', '2021-09-16 18:26:30', '2021-09-16 18:29:20', 0),
(59, 15, 68, NULL, 3, 1631817591, 1631817591, 1631750400, 3, 1, 'FERRY', NULL, '-', 0, 'chatbot', '2021-09-16 18:39:51', '2021-09-16 18:48:44', 0);

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

--
-- Table structure for table `bide_user_models`
--

CREATE TABLE `bide_user_models` (
  `bide_user_id` int(10) UNSIGNED NOT NULL,
  `nik` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `full_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_phone_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_gender` int(11) DEFAULT NULL COMMENT 'M:Male|F:Female',
  `user_status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `user_channel` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'chatbot|apps|merchant',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `call_status` int(11) NOT NULL DEFAULT '0' COMMENT 'Call status : jumlah panggilan',
  `device_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fcm_token` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `birthday_timestamp` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `province_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bide_user_models`
--

INSERT INTO `bide_user_models` (`bide_user_id`, `nik`, `full_name`, `user_email`, `user_phone_number`, `user_gender`, `user_status`, `user_channel`, `created_at`, `updated_at`, `call_status`, `device_id`, `fcm_token`, `birthday_timestamp`, `city`, `province_id`) VALUES
(68, NULL, 'FERRY', NULL, '628119826380', 0, '1', 'chatbot', '2021-09-12 08:32:05', '2021-09-12 08:32:05', 0, NULL, NULL, NULL, NULL, NULL),
(69, NULL, 'RONALD', NULL, '6281573075194', 0, '1', 'chatbot', '2021-09-13 14:48:43', '2021-09-13 14:48:43', 0, NULL, NULL, NULL, NULL, NULL),
(70, NULL, 'TENGKU', NULL, '6285156247366', 0, '1', 'chatbot', '2021-09-14 06:58:33', '2021-09-14 06:58:33', 0, NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `data_rows`
--

CREATE TABLE `data_rows` (
  `id` int(10) UNSIGNED NOT NULL,
  `data_type_id` int(10) UNSIGNED NOT NULL,
  `field` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `browse` tinyint(1) NOT NULL DEFAULT '1',
  `read` tinyint(1) NOT NULL DEFAULT '1',
  `edit` tinyint(1) NOT NULL DEFAULT '1',
  `add` tinyint(1) NOT NULL DEFAULT '1',
  `delete` tinyint(1) NOT NULL DEFAULT '1',
  `details` text COLLATE utf8mb4_unicode_ci,
  `order` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `data_rows`
--

INSERT INTO `data_rows` (`id`, `data_type_id`, `field`, `type`, `display_name`, `required`, `browse`, `read`, `edit`, `add`, `delete`, `details`, `order`) VALUES
(1, 1, 'id', 'number', 'ID', 1, 0, 0, 0, 0, 0, NULL, 1),
(2, 1, 'name', 'text', 'Name', 1, 1, 1, 1, 1, 1, NULL, 2),
(3, 1, 'email', 'text', 'Email', 1, 1, 1, 1, 1, 1, NULL, 3),
(4, 1, 'password', 'password', 'Password', 1, 0, 0, 1, 1, 0, NULL, 4),
(5, 1, 'remember_token', 'text', 'Remember Token', 0, 0, 0, 0, 0, 0, NULL, 5),
(6, 1, 'created_at', 'timestamp', 'Created At', 0, 1, 1, 0, 0, 0, NULL, 6),
(7, 1, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, NULL, 7),
(8, 1, 'avatar', 'image', 'Avatar', 0, 1, 1, 1, 1, 1, NULL, 8),
(9, 1, 'user_belongsto_role_relationship', 'relationship', 'Role', 0, 1, 1, 1, 1, 0, '{\"model\":\"TCG\\\\Voyager\\\\Models\\\\Role\",\"table\":\"roles\",\"type\":\"belongsTo\",\"column\":\"role_id\",\"key\":\"id\",\"label\":\"display_name\",\"pivot_table\":\"roles\",\"pivot\":0}', 10),
(10, 1, 'user_belongstomany_role_relationship', 'relationship', 'Roles', 0, 1, 1, 1, 1, 0, '{\"model\":\"TCG\\\\Voyager\\\\Models\\\\Role\",\"table\":\"roles\",\"type\":\"belongsToMany\",\"column\":\"id\",\"key\":\"id\",\"label\":\"display_name\",\"pivot_table\":\"user_roles\",\"pivot\":\"1\",\"taggable\":\"0\"}', 11),
(11, 1, 'settings', 'hidden', 'Settings', 0, 0, 0, 0, 0, 0, NULL, 12),
(12, 2, 'id', 'number', 'ID', 1, 0, 0, 0, 0, 0, NULL, 1),
(13, 2, 'name', 'text', 'Name', 1, 1, 1, 1, 1, 1, NULL, 2),
(14, 2, 'created_at', 'timestamp', 'Created At', 0, 0, 0, 0, 0, 0, NULL, 3),
(15, 2, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, NULL, 4),
(16, 3, 'id', 'number', 'ID', 1, 0, 0, 0, 0, 0, NULL, 1),
(17, 3, 'name', 'text', 'Name', 1, 1, 1, 1, 1, 1, NULL, 2),
(18, 3, 'created_at', 'timestamp', 'Created At', 0, 0, 0, 0, 0, 0, NULL, 3),
(19, 3, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, NULL, 4),
(20, 3, 'display_name', 'text', 'Display Name', 1, 1, 1, 1, 1, 1, NULL, 5),
(21, 1, 'role_id', 'text', 'Role', 1, 1, 1, 1, 1, 1, NULL, 9),
(22, 5, 'bide_admin_id', 'text', 'Bide Admin Id', 1, 0, 0, 0, 0, 0, '{}', 1),
(23, 5, 'admin_username', 'text', 'Admin Username', 1, 1, 1, 1, 1, 1, '{}', 2),
(24, 5, 'admin_password', 'text_area', 'Admin Password', 1, 1, 1, 1, 1, 1, '{}', 3),
(25, 5, 'admin_email', 'text', 'Admin Email', 1, 1, 1, 1, 1, 1, '{}', 4),
(26, 5, 'bide_merchant_id', 'text', 'Bide Merchant Id', 1, 1, 1, 1, 1, 1, '{}', 5),
(27, 5, 'admin_status', 'text', 'Admin Status', 1, 1, 1, 1, 1, 1, '{}', 6),
(28, 5, 'created_at', 'timestamp', 'Created At', 0, 1, 1, 1, 0, 1, '{}', 7),
(29, 5, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, '{}', 8),
(30, 6, 'bide_merchant_id', 'text', 'Bide Merchant Id', 1, 0, 0, 0, 0, 0, '{}', 1),
(31, 6, 'merchant_type', 'text', 'Merchant Type', 1, 1, 1, 1, 1, 1, '{}', 2),
(32, 6, 'merchant_name', 'text', 'Merchant Name', 1, 1, 1, 1, 1, 1, '{}', 3),
(33, 6, 'merchant_address', 'text', 'Merchant Address', 0, 1, 1, 1, 1, 1, '{}', 4),
(34, 6, 'merchant_logo_path', 'text', 'Merchant Logo Path', 1, 1, 1, 1, 1, 1, '{}', 5),
(35, 6, 'created_at', 'timestamp', 'Created At', 0, 1, 1, 1, 0, 1, '{}', 6),
(36, 6, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, '{}', 7),
(37, 8, 'bide_user_id', 'text', 'Bide User Id', 1, 0, 0, 0, 0, 0, '{}', 1),
(38, 8, 'full_name', 'text', 'Full Name', 1, 1, 1, 1, 1, 1, '{}', 2),
(39, 8, 'user_email', 'text', 'User Email', 0, 1, 1, 1, 1, 1, '{}', 3),
(40, 8, 'user_phone_number', 'text', 'User Phone Number', 1, 1, 1, 1, 1, 1, '{}', 4),
(41, 8, 'user_gender', 'text', 'User Gender', 1, 1, 1, 1, 1, 1, '{}', 5),
(42, 8, 'user_status', 'text', 'User Status', 1, 1, 1, 1, 1, 1, '{}', 6),
(43, 8, 'user_channel', 'text', 'User Channel', 1, 1, 1, 1, 1, 1, '{}', 7),
(44, 8, 'created_at', 'timestamp', 'Created At', 0, 1, 1, 1, 0, 1, '{}', 8),
(45, 8, 'updated_at', 'timestamp', 'Updated At', 0, 0, 0, 0, 0, 0, '{}', 9),
(46, 6, 'merchant_qr_id', 'text', 'Merchant Qr Id', 1, 1, 1, 1, 1, 1, '{}', 8);

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

--
-- Table structure for table `data_types`
--

CREATE TABLE `data_types` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name_singular` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name_plural` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `model_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `policy_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `controller` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `generate_permissions` tinyint(1) NOT NULL DEFAULT '0',
  `server_side` tinyint(4) NOT NULL DEFAULT '0',
  `details` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `data_types`
--

INSERT INTO `data_types` (`id`, `name`, `slug`, `display_name_singular`, `display_name_plural`, `icon`, `model_name`, `policy_name`, `controller`, `description`, `generate_permissions`, `server_side`, `details`, `created_at`, `updated_at`) VALUES
(1, 'users', 'users', 'User', 'Users', 'voyager-person', 'TCG\\Voyager\\Models\\User', 'TCG\\Voyager\\Policies\\UserPolicy', 'TCG\\Voyager\\Http\\Controllers\\VoyagerUserController', '', 1, 0, NULL, '2020-05-04 08:10:06', '2020-05-04 08:10:06'),
(2, 'menus', 'menus', 'Menu', 'Menus', 'voyager-list', 'TCG\\Voyager\\Models\\Menu', NULL, '', '', 1, 0, NULL, '2020-05-04 08:10:06', '2020-05-04 08:10:06'),
(3, 'roles', 'roles', 'Role', 'Roles', 'voyager-lock', 'TCG\\Voyager\\Models\\Role', NULL, '', '', 1, 0, NULL, '2020-05-04 08:10:06', '2020-05-04 08:10:06'),
(5, 'bide_admin_models', 'bide-admin-models', 'Bide Admin Model', 'Bide Admin Models', 'voyager-people', 'App\\Models\\BideAdminModels', NULL, NULL, NULL, 1, 0, '{\"order_column\":null,\"order_display_column\":null,\"order_direction\":\"asc\",\"default_search_key\":null}', '2020-05-08 00:44:46', '2020-05-08 00:44:46'),
(6, 'bide_merchant_models', 'bide-merchant-models', 'Bide Merchant Model', 'Bide Merchant Models', 'voyager-company', 'App\\Models\\BideMerchantModels', NULL, NULL, NULL, 1, 0, '{\"order_column\":null,\"order_display_column\":null,\"order_direction\":\"asc\",\"default_search_key\":null,\"scope\":null}', '2020-05-08 00:59:55', '2020-06-20 10:15:07'),
(8, 'bide_user_models', 'bide-user-models', 'Bide User Model', 'Bide User Models', 'voyager-group', 'App\\Models\\BideUserModels', NULL, NULL, NULL, 1, 0, '{\"order_column\":null,\"order_display_column\":null,\"order_direction\":\"asc\",\"default_search_key\":null}', '2020-05-08 01:01:25', '2020-05-08 01:01:25');

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

--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'admin', '2020-05-04 08:10:07', '2020-05-04 08:10:07');

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

--
-- Table structure for table `menu_items`
--

CREATE TABLE `menu_items` (
  `id` int(10) UNSIGNED NOT NULL,
  `menu_id` int(10) UNSIGNED DEFAULT NULL,
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `url` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `target` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '_self',
  `icon_class` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parent_id` int(11) DEFAULT NULL,
  `order` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `route` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parameters` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menu_items`
--

INSERT INTO `menu_items` (`id`, `menu_id`, `title`, `url`, `target`, `icon_class`, `color`, `parent_id`, `order`, `created_at`, `updated_at`, `route`, `parameters`) VALUES
(1, 1, 'Dashboard', '', '_self', 'voyager-boat', NULL, NULL, 1, '2020-05-04 08:10:07', '2020-05-04 08:10:07', 'voyager.dashboard', NULL),
(2, 1, 'Media', '', '_self', 'voyager-images', NULL, NULL, 5, '2020-05-04 08:10:07', '2020-05-04 08:10:07', 'voyager.media.index', NULL),
(3, 1, 'Users', '', '_self', 'voyager-person', NULL, NULL, 3, '2020-05-04 08:10:07', '2020-05-04 08:10:07', 'voyager.users.index', NULL),
(4, 1, 'Roles', '', '_self', 'voyager-lock', NULL, NULL, 2, '2020-05-04 08:10:07', '2020-05-04 08:10:07', 'voyager.roles.index', NULL),
(5, 1, 'Tools', '', '_self', 'voyager-tools', NULL, NULL, 9, '2020-05-04 08:10:07', '2020-05-04 08:10:07', NULL, NULL),
(6, 1, 'Menu Builder', '', '_self', 'voyager-list', NULL, 5, 10, '2020-05-04 08:10:07', '2020-05-04 08:10:07', 'voyager.menus.index', NULL),
(7, 1, 'Database', '', '_self', 'voyager-data', NULL, 5, 11, '2020-05-04 08:10:07', '2020-05-04 08:10:07', 'voyager.database.index', NULL),
(8, 1, 'Compass', '', '_self', 'voyager-compass', NULL, 5, 12, '2020-05-04 08:10:07', '2020-05-04 08:10:07', 'voyager.compass.index', NULL),
(9, 1, 'BREAD', '', '_self', 'voyager-bread', NULL, 5, 13, '2020-05-04 08:10:07', '2020-05-04 08:10:07', 'voyager.bread.index', NULL),
(10, 1, 'Settings', '', '_self', 'voyager-settings', NULL, NULL, 14, '2020-05-04 08:10:07', '2020-05-04 08:10:07', 'voyager.settings.index', NULL),
(11, 1, 'Hooks', '', '_self', 'voyager-hook', NULL, 5, 13, '2020-05-04 08:10:07', '2020-05-04 08:10:07', 'voyager.hooks', NULL),
(12, 1, 'Bide Admin Models', '', '_self', 'voyager-people', NULL, NULL, 15, '2020-05-08 00:44:47', '2020-05-08 00:44:47', 'voyager.bide-admin-models.index', NULL),
(13, 1, 'Bide Merchant Models', '', '_self', 'voyager-company', NULL, NULL, 16, '2020-05-08 00:59:55', '2020-05-08 00:59:55', 'voyager.bide-merchant-models.index', NULL),
(14, 1, 'Bide User Models', '', '_self', 'voyager-group', NULL, NULL, 17, '2020-05-08 01:01:25', '2020-05-08 01:01:25', 'voyager.bide-user-models.index', NULL);

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2016_01_01_000000_add_voyager_user_fields', 1),
(4, '2016_01_01_000000_create_data_types_table', 1),
(5, '2016_05_19_173453_create_menu_table', 1),
(6, '2016_10_21_190000_create_roles_table', 1),
(7, '2016_10_21_190000_create_settings_table', 1),
(8, '2016_11_30_135954_create_permission_table', 1),
(9, '2016_11_30_141208_create_permission_role_table', 1),
(10, '2016_12_26_201236_data_types__add__server_side', 1),
(11, '2017_01_13_000000_add_route_to_menu_items_table', 1),
(12, '2017_01_14_005015_create_translations_table', 1),
(13, '2017_01_15_000000_make_table_name_nullable_in_permissions_table', 1),
(14, '2017_03_06_000000_add_controller_to_data_types_table', 1),
(15, '2017_04_21_000000_add_order_to_data_rows_table', 1),
(16, '2017_07_05_210000_add_policyname_to_data_types_table', 1),
(17, '2017_08_05_000000_add_group_to_settings_table', 1),
(18, '2017_11_26_013050_add_user_role_relationship', 1),
(19, '2017_11_26_015000_create_user_roles_table', 1),
(20, '2018_03_11_000000_add_user_settings', 1),
(21, '2018_03_14_000000_add_details_to_data_types_table', 1),
(22, '2018_03_16_000000_make_settings_value_nullable', 1),
(23, '2020_05_08_041046_create_bide_user_models_table', 2),
(24, '2020_05_08_041307_create_bide_merchant_models_table', 2),
(25, '2020_05_08_051341_create_bide_admin_models_table', 2),
(27, '2020_05_08_053838_create_bide_queue_models_table', 3),
(28, '2020_06_20_144714_add_merchant_qr_id_to_bide_merchant_models', 4),
(29, '2020_07_08_132008_add_call_status_to_tb_queue', 5),
(32, '2020_07_09_051023_add_device_id_to_bide_user_models', 6),
(33, '2020_07_27_065552_add_detail_to_bide_user', 6),
(35, '2020_07_28_034041_add_fcm_to_merchant', 7);

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

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `table_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `key`, `table_name`, `created_at`, `updated_at`) VALUES
(1, 'browse_admin', NULL, '2020-05-04 08:10:07', '2020-05-04 08:10:07'),
(2, 'browse_bread', NULL, '2020-05-04 08:10:07', '2020-05-04 08:10:07'),
(3, 'browse_database', NULL, '2020-05-04 08:10:07', '2020-05-04 08:10:07'),
(4, 'browse_media', NULL, '2020-05-04 08:10:07', '2020-05-04 08:10:07'),
(5, 'browse_compass', NULL, '2020-05-04 08:10:07', '2020-05-04 08:10:07'),
(6, 'browse_menus', 'menus', '2020-05-04 08:10:07', '2020-05-04 08:10:07'),
(7, 'read_menus', 'menus', '2020-05-04 08:10:07', '2020-05-04 08:10:07'),
(8, 'edit_menus', 'menus', '2020-05-04 08:10:07', '2020-05-04 08:10:07'),
(9, 'add_menus', 'menus', '2020-05-04 08:10:07', '2020-05-04 08:10:07'),
(10, 'delete_menus', 'menus', '2020-05-04 08:10:07', '2020-05-04 08:10:07'),
(11, 'browse_roles', 'roles', '2020-05-04 08:10:07', '2020-05-04 08:10:07'),
(12, 'read_roles', 'roles', '2020-05-04 08:10:07', '2020-05-04 08:10:07'),
(13, 'edit_roles', 'roles', '2020-05-04 08:10:07', '2020-05-04 08:10:07'),
(14, 'add_roles', 'roles', '2020-05-04 08:10:07', '2020-05-04 08:10:07'),
(15, 'delete_roles', 'roles', '2020-05-04 08:10:07', '2020-05-04 08:10:07'),
(16, 'browse_users', 'users', '2020-05-04 08:10:07', '2020-05-04 08:10:07'),
(17, 'read_users', 'users', '2020-05-04 08:10:07', '2020-05-04 08:10:07'),
(18, 'edit_users', 'users', '2020-05-04 08:10:07', '2020-05-04 08:10:07'),
(19, 'add_users', 'users', '2020-05-04 08:10:07', '2020-05-04 08:10:07'),
(20, 'delete_users', 'users', '2020-05-04 08:10:07', '2020-05-04 08:10:07'),
(21, 'browse_settings', 'settings', '2020-05-04 08:10:07', '2020-05-04 08:10:07'),
(22, 'read_settings', 'settings', '2020-05-04 08:10:07', '2020-05-04 08:10:07'),
(23, 'edit_settings', 'settings', '2020-05-04 08:10:07', '2020-05-04 08:10:07'),
(24, 'add_settings', 'settings', '2020-05-04 08:10:07', '2020-05-04 08:10:07'),
(25, 'delete_settings', 'settings', '2020-05-04 08:10:07', '2020-05-04 08:10:07'),
(26, 'browse_hooks', NULL, '2020-05-04 08:10:07', '2020-05-04 08:10:07'),
(27, 'browse_bide_admin_models', 'bide_admin_models', '2020-05-08 00:44:46', '2020-05-08 00:44:46'),
(28, 'read_bide_admin_models', 'bide_admin_models', '2020-05-08 00:44:46', '2020-05-08 00:44:46'),
(29, 'edit_bide_admin_models', 'bide_admin_models', '2020-05-08 00:44:46', '2020-05-08 00:44:46'),
(30, 'add_bide_admin_models', 'bide_admin_models', '2020-05-08 00:44:46', '2020-05-08 00:44:46'),
(31, 'delete_bide_admin_models', 'bide_admin_models', '2020-05-08 00:44:46', '2020-05-08 00:44:46'),
(32, 'browse_bide_merchant_models', 'bide_merchant_models', '2020-05-08 00:59:55', '2020-05-08 00:59:55'),
(33, 'read_bide_merchant_models', 'bide_merchant_models', '2020-05-08 00:59:55', '2020-05-08 00:59:55'),
(34, 'edit_bide_merchant_models', 'bide_merchant_models', '2020-05-08 00:59:55', '2020-05-08 00:59:55'),
(35, 'add_bide_merchant_models', 'bide_merchant_models', '2020-05-08 00:59:55', '2020-05-08 00:59:55'),
(36, 'delete_bide_merchant_models', 'bide_merchant_models', '2020-05-08 00:59:55', '2020-05-08 00:59:55'),
(37, 'browse_bide_user_models', 'bide_user_models', '2020-05-08 01:01:25', '2020-05-08 01:01:25'),
(38, 'read_bide_user_models', 'bide_user_models', '2020-05-08 01:01:25', '2020-05-08 01:01:25'),
(39, 'edit_bide_user_models', 'bide_user_models', '2020-05-08 01:01:25', '2020-05-08 01:01:25'),
(40, 'add_bide_user_models', 'bide_user_models', '2020-05-08 01:01:25', '2020-05-08 01:01:25'),
(41, 'delete_bide_user_models', 'bide_user_models', '2020-05-08 01:01:25', '2020-05-08 01:01:25');

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

--
-- Table structure for table `permission_role`
--

CREATE TABLE `permission_role` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permission_role`
--

INSERT INTO `permission_role` (`permission_id`, `role_id`) VALUES
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 1),
(7, 1),
(8, 1),
(9, 1),
(10, 1),
(11, 1),
(12, 1),
(13, 1),
(14, 1),
(15, 1),
(16, 1),
(17, 1),
(18, 1),
(19, 1),
(20, 1),
(21, 1),
(22, 1),
(23, 1),
(24, 1),
(25, 1),
(26, 1),
(27, 1),
(28, 1),
(29, 1),
(30, 1),
(31, 1),
(32, 1),
(33, 1),
(34, 1),
(35, 1),
(36, 1),
(37, 1),
(38, 1),
(39, 1),
(40, 1),
(41, 1);

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `display_name`, `created_at`, `updated_at`) VALUES
(1, 'admin', 'Administrator', '2020-05-04 08:10:07', '2020-05-04 08:10:07'),
(2, 'user', 'Normal User', '2020-05-04 08:10:07', '2020-05-04 08:10:07');

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(10) UNSIGNED NOT NULL,
  `key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `details` text COLLATE utf8mb4_unicode_ci,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `order` int(11) NOT NULL DEFAULT '1',
  `group` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `key`, `display_name`, `value`, `details`, `type`, `order`, `group`) VALUES
(1, 'site.title', 'Site Title', 'Site Title', '', 'text', 1, 'Site'),
(2, 'site.description', 'Site Description', 'Site Description', '', 'text', 2, 'Site'),
(3, 'site.logo', 'Site Logo', '', '', 'image', 3, 'Site'),
(4, 'site.google_analytics_tracking_id', 'Google Analytics Tracking ID', '', '', 'text', 4, 'Site'),
(5, 'admin.bg_image', 'Admin Background Image', '', '', 'image', 5, 'Admin'),
(6, 'admin.title', 'Admin Title', 'Voyager', '', 'text', 1, 'Admin'),
(7, 'admin.description', 'Admin Description', 'Welcome to Voyager. The Missing Admin for Laravel', '', 'text', 2, 'Admin'),
(8, 'admin.loader', 'Admin Loader', '', '', 'image', 3, 'Admin'),
(9, 'admin.icon_image', 'Admin Icon Image', '', '', 'image', 4, 'Admin'),
(10, 'admin.google_analytics_client_id', 'Google Analytics Client ID (used for admin dashboard)', '', '', 'text', 1, 'Admin');

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

--
-- Table structure for table `translations`
--

CREATE TABLE `translations` (
  `id` int(10) UNSIGNED NOT NULL,
  `table_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `column_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `foreign_key` int(10) UNSIGNED NOT NULL,
  `locale` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(10) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `avatar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT 'users/default.png',
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `settings` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `role_id`, `name`, `email`, `avatar`, `password`, `remember_token`, `settings`, `created_at`, `updated_at`) VALUES
(1, 1, 'fermyth', 'fermyth@bide_backendv3.test', 'users/default.png', '$2y$10$swoZVrCzT/q9zS359jkQBuGvXxz7a1Vy0gdmKnkOvG6shjpjy64TC', NULL, NULL, '2020-05-04 08:10:54', '2020-05-04 08:10:54');

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

--
-- Table structure for table `user_roles`
--

CREATE TABLE `user_roles` (
  `user_id` int(10) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `bide_admin_models`
--
ALTER TABLE `bide_admin_models`
  ADD PRIMARY KEY (`bide_admin_id`);

--
-- Indexes for table `bide_merchant_models`
--
ALTER TABLE `bide_merchant_models`
  ADD PRIMARY KEY (`bide_merchant_id`);

--
-- Indexes for table `bide_merchant_type_text`
--
ALTER TABLE `bide_merchant_type_text`
  ADD PRIMARY KEY (`bide_merchant_type_text_id`);

--
-- Indexes for table `bide_queue_models`
--
ALTER TABLE `bide_queue_models`
  ADD PRIMARY KEY (`bide_queue_id`);

--
-- Indexes for table `bide_user_models`
--
ALTER TABLE `bide_user_models`
  ADD PRIMARY KEY (`bide_user_id`);

--
-- Indexes for table `data_rows`
--
ALTER TABLE `data_rows`
  ADD PRIMARY KEY (`id`),
  ADD KEY `data_rows_data_type_id_foreign` (`data_type_id`);

--
-- Indexes for table `data_types`
--
ALTER TABLE `data_types`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `data_types_name_unique` (`name`),
  ADD UNIQUE KEY `data_types_slug_unique` (`slug`);

--
-- Indexes for table `menus`
--
ALTER TABLE `menus`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `menus_name_unique` (`name`);

--
-- Indexes for table `menu_items`
--
ALTER TABLE `menu_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `menu_items_menu_id_foreign` (`menu_id`);

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

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `permissions_key_index` (`key`);

--
-- Indexes for table `permission_role`
--
ALTER TABLE `permission_role`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `permission_role_permission_id_index` (`permission_id`),
  ADD KEY `permission_role_role_id_index` (`role_id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_unique` (`name`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `settings_key_unique` (`key`);

--
-- Indexes for table `translations`
--
ALTER TABLE `translations`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `translations_table_name_column_name_foreign_key_locale_unique` (`table_name`,`column_name`,`foreign_key`,`locale`);

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`),
  ADD KEY `users_role_id_foreign` (`role_id`);

--
-- Indexes for table `user_roles`
--
ALTER TABLE `user_roles`
  ADD PRIMARY KEY (`user_id`,`role_id`),
  ADD KEY `user_roles_user_id_index` (`user_id`),
  ADD KEY `user_roles_role_id_index` (`role_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `bide_admin_models`
--
ALTER TABLE `bide_admin_models`
  MODIFY `bide_admin_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `bide_merchant_models`
--
ALTER TABLE `bide_merchant_models`
  MODIFY `bide_merchant_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `bide_merchant_type_text`
--
ALTER TABLE `bide_merchant_type_text`
  MODIFY `bide_merchant_type_text_id` tinyint(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `bide_queue_models`
--
ALTER TABLE `bide_queue_models`
  MODIFY `bide_queue_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=60;

--
-- AUTO_INCREMENT for table `bide_user_models`
--
ALTER TABLE `bide_user_models`
  MODIFY `bide_user_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=71;

--
-- AUTO_INCREMENT for table `data_rows`
--
ALTER TABLE `data_rows`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;

--
-- AUTO_INCREMENT for table `data_types`
--
ALTER TABLE `data_types`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `menus`
--
ALTER TABLE `menus`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `menu_items`
--
ALTER TABLE `menu_items`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=36;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `translations`
--
ALTER TABLE `translations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `data_rows`
--
ALTER TABLE `data_rows`
  ADD CONSTRAINT `data_rows_data_type_id_foreign` FOREIGN KEY (`data_type_id`) REFERENCES `data_types` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `menu_items`
--
ALTER TABLE `menu_items`
  ADD CONSTRAINT `menu_items_menu_id_foreign` FOREIGN KEY (`menu_id`) REFERENCES `menus` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `permission_role`
--
ALTER TABLE `permission_role`
  ADD CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `users`
--
ALTER TABLE `users`
  ADD CONSTRAINT `users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`);

--
-- Constraints for table `user_roles`
--
ALTER TABLE `user_roles`
  ADD CONSTRAINT `user_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `user_roles_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

