-- --------------------------------------------------------
-- Server OS:                    Win64
-- HeidiSQL Version:             10.2.0.5599
-- --------------------------------------------------------



-- Dumping database structure for rsmata
CREATE DATABASE IF NOT EXISTS `rsmata` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `rsmata`;

-- Dumping structure for table rsmata.agendas
CREATE TABLE IF NOT EXISTS `agendas` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `judul` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tempat` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tanggal` date NOT NULL,
  `waktumulai` time NOT NULL,
  `waktuakhir` time NOT NULL,
  `isi` longblob NOT NULL,
  `view` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `publish` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.agendas: ~0 rows (approximately)
DELETE FROM `agendas`;

-- Dumping structure for table rsmata.artikels
CREATE TABLE IF NOT EXISTS `artikels` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `judul` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `isi` longblob NOT NULL,
  `view` int(11) NOT NULL DEFAULT '0',
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `publish` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.artikels: ~0 rows (approximately)
DELETE FROM `artikels`;
INSERT INTO `artikels` (`id`, `judul`, `isi`, `view`, `slug`, `publish`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
	(1, 'BAGAIMANA CARA MENJAGA KESEHATAN MATA', _binary 0x[BLOB], 0, '20200520052232', 'active', 1, 1, '2020-05-19 17:58:23', '2020-05-20 05:22:32');

-- Dumping structure for table rsmata.beritas
CREATE TABLE IF NOT EXISTS `beritas` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `judul` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `publish` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
  `isi` longblob NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `view` int(11) NOT NULL DEFAULT '0',
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.beritas: ~0 rows (approximately)
DELETE FROM `beritas`;
INSERT INTO `beritas` (`id`, `judul`, `publish`, `isi`, `created_at`, `updated_at`, `view`, `slug`, `created_by`, `updated_by`) VALUES
	(1, '7 Kondisi Ini Mengharuskan Anda Menggunakan Kaca Matat', 'active', _binary 0x[BLOB], '2020-05-19 17:57:57', '2020-05-20 03:20:27', 0, '20200520032027', 1, 1);

-- Dumping structure for table rsmata.cerita_pasiens
CREATE TABLE IF NOT EXISTS `cerita_pasiens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `lasik_id` int(11) NOT NULL,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `umur` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pekerjaan` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `isi` longblob NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `publish` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.cerita_pasiens: ~4 rows (approximately)
DELETE FROM `cerita_pasiens`;
INSERT INTO `cerita_pasiens` (`id`, `lasik_id`, `nama`, `umur`, `pekerjaan`, `isi`, `slug`, `publish`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
	(1, 3, 'Satria Yudhi Saputra', '24', 'Kuli', _binary 0x3C703E54616D70696C2043616E74696B2054616E7061204B6163616D6174613C2F703E, '20200520044519', 'active', 1, NULL, '2020-05-20 04:45:19', '2020-05-20 04:45:22'),
	(2, 3, 'Satria Yudhi Saputra', '24', 'Kuli', _binary 0x3C703E54616D70696C204D656D7065736F6E612074616E7061204B6163616D6174613C2F703E, '20200520044635', 'active', 1, NULL, '2020-05-20 04:46:35', '2020-05-20 04:46:38'),
	(3, 3, 'satria yudhi saputra', '24', 'Kuli', _binary 0x3C703E54616D70696C204C7561722042696173612054616E7061204B616361636D6174613C2F703E, '20200520044828', 'active', 1, NULL, '2020-05-20 04:48:28', '2020-05-20 04:48:32'),
	(4, 3, 'satria yudhi saputra', '24', 'Kuli', _binary 0x3C703E61752061682067656C6170206D61752062656C69207472756B3C2F703E, '20200520044913', 'active', 1, NULL, '2020-05-20 04:49:13', '2020-05-20 04:49:16');

-- Dumping structure for table rsmata.daftar_lasiks
CREATE TABLE IF NOT EXISTS `daftar_lasiks` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jenis_kelamin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tanggal_lahir` date DEFAULT NULL,
  `asal` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nomor_hp` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `publish` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.daftar_lasiks: ~0 rows (approximately)
DELETE FROM `daftar_lasiks`;

-- Dumping structure for table rsmata.dokters
CREATE TABLE IF NOT EXISTS `dokters` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jeniskelamin` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `spesialis` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `jadwalpraktek` longblob NOT NULL,
  `riwayatpendidikan` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `riwayatpelatihan` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `karyailmiah` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.dokters: ~5 rows (approximately)
DELETE FROM `dokters`;
INSERT INTO `dokters` (`id`, `nama`, `jeniskelamin`, `spesialis`, `jadwalpraktek`, `riwayatpendidikan`, `riwayatpelatihan`, `karyailmiah`, `slug`, `created_at`, `updated_at`) VALUES
	(3, 'dr. Manfred Himawan', 'pria', 'Dokter Spesialis Mata', _binary 0x3C703E2D3C2F703E, '-', '<p>-</p>', '-', NULL, '2020-05-19 17:20:13', '2020-05-19 17:20:13'),
	(4, 'dr. Rinchard Arie Umboh, Sp.M', 'pria', 'Dokter Spesialis Mata', _binary 0x3C703E2D3C2F703E, '-', '<p>-</p>', '-', NULL, '2020-05-19 17:20:47', '2020-05-19 17:20:47'),
	(5, 'dr. Monalisa Pane', 'wanita', 'Dokter Umum', _binary 0x3C703E2D3C2F703E, '-', '<p>-</p>', '-', NULL, '2020-05-19 17:21:15', '2020-05-19 17:21:15'),
	(6, 'dr. Ghea Ananta', 'pria', 'Dokter Umum', _binary 0x3C703E2D3C2F703E, '-', '<p>-</p>', '-', NULL, '2020-05-19 17:22:10', '2020-05-19 17:22:10'),
	(7, 'dr. Assauk Pramusetyo Hadi, M. Kes', 'pria', 'Dokter Umum', _binary 0x3C703E2D3C2F703E, '-', '<p>-</p>', '-', NULL, '2020-05-19 17:22:40', '2020-05-19 17:22:40');

-- Dumping structure for table rsmata.dokumentasidocuments
CREATE TABLE IF NOT EXISTS `dokumentasidocuments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `publish` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.dokumentasidocuments: ~0 rows (approximately)
DELETE FROM `dokumentasidocuments`;
INSERT INTO `dokumentasidocuments` (`id`, `nama`, `slug`, `publish`, `created_at`, `updated_at`) VALUES
	(1, 'Profil Rumah Sakit', '20200519192134', 'active', '2020-05-19 19:21:34', '2020-05-19 19:21:37');

-- Dumping structure for table rsmata.dokumentasigambars
CREATE TABLE IF NOT EXISTS `dokumentasigambars` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `publish` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.dokumentasigambars: ~0 rows (approximately)
DELETE FROM `dokumentasigambars`;
INSERT INTO `dokumentasigambars` (`id`, `nama`, `slug`, `publish`, `created_at`, `updated_at`) VALUES
	(1, 'Operasi Lasik', '20200519191620', 'inactive', '2020-05-19 19:16:20', '2020-05-19 19:16:20');

-- Dumping structure for table rsmata.dokumentasivideos
CREATE TABLE IF NOT EXISTS `dokumentasivideos` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` longblob NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `publish` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.dokumentasivideos: ~0 rows (approximately)
DELETE FROM `dokumentasivideos`;
INSERT INTO `dokumentasivideos` (`id`, `nama`, `link`, `slug`, `publish`, `created_at`, `updated_at`) VALUES
	(1, 'Lasik Surgery', _binary 0x68747470733A2F2F7777772E796F75747562652E636F6D2F656D6265642F662D596B7A6766674E326B, '20200519192003', 'active', '2020-05-19 19:20:03', '2020-05-19 19:20:07');

-- Dumping structure for table rsmata.fasilitas
CREATE TABLE IF NOT EXISTS `fasilitas` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `keterangan` longblob NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `publish` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.fasilitas: ~6 rows (approximately)
DELETE FROM `fasilitas`;
INSERT INTO `fasilitas` (`id`, `nama`, `keterangan`, `slug`, `publish`, `created_at`, `updated_at`) VALUES
	(1, 'Rawat Inap', _binary 0x3C703E2D3C2F703E, '20200519174239', 'active', '2020-05-19 17:42:39', '2020-05-19 17:42:57'),
	(2, 'Rawat Jalan', _binary 0x3C703E2D3C2F703E, '20200519174314', 'active', '2020-05-19 17:43:14', '2020-05-19 17:43:19'),
	(3, 'Unit Gawat Darurat (UGD)', _binary 0x3C703E2D3C2F703E, '20200519174342', 'active', '2020-05-19 17:43:42', '2020-05-19 17:43:46'),
	(4, 'Farmasi', _binary 0x3C703E2D3C2F703E, '20200519174400', 'active', '2020-05-19 17:44:00', '2020-05-19 17:44:29'),
	(5, 'Laboratorium', _binary 0x3C703E2D3C2F703E, '20200519174421', 'active', '2020-05-19 17:44:21', '2020-05-19 17:44:33'),
	(6, 'Kamar Operasi', _binary 0x3C703E2D3C2F703E, '20200519174448', 'active', '2020-05-19 17:44:48', '2020-05-19 17:44:52'),
	(7, 'Ambulance', _binary 0x3C703E2D3C2F703E, '20200519174514', 'active', '2020-05-19 17:45:14', '2020-05-19 17:45:18');

-- Dumping structure for table rsmata.files
CREATE TABLE IF NOT EXISTS `files` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `filename` text COLLATE utf8mb4_unicode_ci,
  `extension` text COLLATE utf8mb4_unicode_ci,
  `file_type` text COLLATE utf8mb4_unicode_ci,
  `file_id` int(11) DEFAULT NULL,
  `created_at` text COLLATE utf8mb4_unicode_ci,
  `updated_at` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=285 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.files: ~30 rows (approximately)
DELETE FROM `files`;
INSERT INTO `files` (`id`, `filename`, `extension`, `file_type`, `file_id`, `created_at`, `updated_at`) VALUES
	(231, '0c98385c7cac555e9654ebf4f621928d.pdf', 'pdf', 'App\\Models\\staticdata', 1, '2020-05-02 06:17:24', '2020-05-02 06:17:24'),
	(241, '4832ed025622790e1f0889273df5f176.png', 'png', 'App\\Models\\staticdata', 9, '2020-05-09 13:13:31', '2020-05-09 13:13:31'),
	(249, 'c78ae25bbdece2422bbd5a8fbbcc5b56.jpg', 'jpg', 'App\\Models\\staticdata', 7, '2020-05-18 20:45:00', '2020-05-18 20:45:00'),
	(250, '34b3cb995d1bce86c86075e571c31d32.jpg', 'jpg', 'App\\Models\\staticdata', 8, '2020-05-18 20:45:43', '2020-05-18 20:45:43'),
	(252, '538702d14d64f4bc43dcc3e71b9f5a42.png', 'png', 'App\\Models\\staticdata', 16, '2020-05-18 23:23:41', '2020-05-18 23:23:41'),
	(253, 'd7530216d86dede50655e9fa50b8a861.png', 'png', 'App\\Models\\staticdata', 17, '2020-05-18 23:23:58', '2020-05-18 23:23:58'),
	(254, '9c128fa8dc0e679cc27c99f1c8029906.png', 'png', 'App\\Models\\mutupelayanan', 1, '2020-05-18 23:24:38', '2020-05-18 23:24:38'),
	(255, 'f443abf9b54d8a078d806b7a12efbd18.jpg', 'jpg', 'App\\Models\\lasik', 3, '2020-05-19 17:46:07', '2020-05-19 17:46:07'),
	(256, '7c957fbe108dbf33fc9b05781f6c7307.jpg', 'jpg', 'App\\Models\\lasik', 4, '2020-05-19 17:51:21', '2020-05-19 17:51:21'),
	(257, 'e26d8fd2a4f4db61c9bf0ef5dfac1117.png', 'png', 'App\\Models\\karir', 1, '2020-05-19 17:56:54', '2020-05-19 17:56:54'),
	(258, '3e44c2c3260ea29ac23e68919aef23ef.png', 'png', 'App\\Models\\pengumuman', 1, '2020-05-19 17:57:33', '2020-05-19 17:57:33'),
	(262, '32740aedf8c9054e968bb31ebb46e8ae.png', 'png', 'App\\Models\\jadwalbesuk', 1, '2020-05-19 18:00:34', '2020-05-19 18:00:34'),
	(263, '95436ba2a0dbcfc8b4a77f34c3661bde.png', 'png', 'App\\Models\\staticdata', 3, '2020-05-19 18:01:10', '2020-05-19 18:01:10'),
	(264, '5a9836ee2f5297056196b390198123af.jpg', 'jpg', 'App\\Models\\dokumentasigambar', 1, '2020-05-19 19:16:20', '2020-05-19 19:16:20'),
	(265, '62207ae3029346d094a8a4ca2e20832e.jpg', 'jpg', 'App\\Models\\dokumentasigambar', 1, '2020-05-19 19:16:31', '2020-05-19 19:16:31'),
	(266, '628289442b11670c89a40cbed74b1203.jpg', 'jpg', 'App\\Models\\dokumentasigambar', 1, '2020-05-19 19:16:32', '2020-05-19 19:16:32'),
	(267, '71ddc366f798a09863d97cb7ee92b71a.jpg', 'jpg', 'App\\Models\\dokumentasigambar', 1, '2020-05-19 19:16:32', '2020-05-19 19:16:32'),
	(268, 'a5c37146b9320e2f213d3d7497219ee9.jpg', 'jpg', 'App\\Models\\dokumentasigambar', 1, '2020-05-19 19:16:33', '2020-05-19 19:16:33'),
	(269, '9dbbd2176001c2193fa9032cde149aca.jpg', 'jpg', 'App\\Models\\dokumentasigambar', 1, '2020-05-19 19:16:33', '2020-05-19 19:16:33'),
	(270, '72e1d6ad0cd0cb81009c053ba966a052.jpg', 'jpg', 'App\\Models\\dokumentasigambar', 1, '2020-05-19 19:16:33', '2020-05-19 19:16:33'),
	(271, 'ff4d226b86796517e511312d256e61c3.doc', 'doc', 'App\\Models\\dokumentasidocument', 1, '2020-05-19 19:21:34', '2020-05-19 19:21:34'),
	(272, 'b71993aaadd355c51c9fa80ef1a11a07.jpg', 'jpg', 'App\\Models\\berita', 1, '2020-05-20 03:20:27', '2020-05-20 03:20:27'),
	(273, 'ee563fb7e1fd52c6a100e8ef771f0505.png', 'png', 'App\\Models\\staticdata', 15, '2020-05-20 03:22:52', '2020-05-20 03:22:52'),
	(274, '3edca2f05798d497f1443dec3f92b280.png', 'png', 'App\\Models\\staticdata', 18, '2020-05-20 04:40:53', '2020-05-20 04:40:53'),
	(276, '8f694136f5608402d3f8365ba8c7401c.png', 'png', 'App\\Models\\ceritaPasien', 1, '2020-05-20 04:45:19', '2020-05-20 04:45:19'),
	(277, 'e2a596dd6a18538c001ebe5cf160a2df.png', 'png', 'App\\Models\\ceritaPasien', 2, '2020-05-20 04:46:35', '2020-05-20 04:46:35'),
	(278, '19981b632ce04fc9b67f3bde1f54f7ac.png', 'png', 'App\\Models\\ceritaPasien', 3, '2020-05-20 04:48:28', '2020-05-20 04:48:28'),
	(279, 'a500cd3b54a7cb51a2247e2313b0bc9a.png', 'png', 'App\\Models\\ceritaPasien', 4, '2020-05-20 04:49:13', '2020-05-20 04:49:13'),
	(281, '3d983faab3db62b3c19e3fd823469afb.png', 'png', 'App\\Models\\staticdata', 19, '2020-05-20 05:01:29', '2020-05-20 05:01:29'),
	(283, 'd9df3cd5397a272be3ffdc9f7dd33d8e.jpg', 'jpg', 'App\\Models\\artikel', 1, '2020-05-20 05:22:32', '2020-05-20 05:22:32'),
	(284, 'b3ece780092d3f1abb893f6a02748d51.jpg', 'jpg', 'App\\Models\\staticdata', 19, '2020-05-20 06:57:57', '2020-05-20 06:57:57');

-- Dumping structure for table rsmata.jadwalbesuks
CREATE TABLE IF NOT EXISTS `jadwalbesuks` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deksripsi` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `publish` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.jadwalbesuks: ~0 rows (approximately)
DELETE FROM `jadwalbesuks`;
INSERT INTO `jadwalbesuks` (`id`, `title`, `deksripsi`, `slug`, `publish`, `created_at`, `updated_at`) VALUES
	(1, 'Jadwal Besuk', '<p>-</p>', '20200519180034', 'active', '2020-05-19 18:00:34', '2020-05-19 18:00:43');

-- Dumping structure for table rsmata.karirs
CREATE TABLE IF NOT EXISTS `karirs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deksripsi` longblob NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `publish` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.karirs: ~0 rows (approximately)
DELETE FROM `karirs`;
INSERT INTO `karirs` (`id`, `title`, `deksripsi`, `slug`, `publish`, `created_at`, `updated_at`) VALUES
	(1, 'noname', _binary 0x3C703E2D3C2F703E, '20200519175654', 'active', '2020-05-19 17:56:54', '2020-05-19 17:56:59');

-- Dumping structure for table rsmata.karyailmiahs
CREATE TABLE IF NOT EXISTS `karyailmiahs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `judul` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tahun` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `dokter_id` int(10) unsigned NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.karyailmiahs: ~0 rows (approximately)
DELETE FROM `karyailmiahs`;

-- Dumping structure for table rsmata.lasiks
CREATE TABLE IF NOT EXISTS `lasiks` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `persyaratan` longblob NOT NULL,
  `pantangan` longblob NOT NULL,
  `keterangan` longblob NOT NULL,
  `biaya` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `publish` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gambaran` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.lasiks: ~1 rows (approximately)
DELETE FROM `lasiks`;
INSERT INTO `lasiks` (`id`, `persyaratan`, `pantangan`, `keterangan`, `biaya`, `slug`, `publish`, `created_at`, `updated_at`, `nama`, `gambaran`) VALUES
	(3, _binary 0x3C703E2D3C2F703E, _binary 0x3C703E2D3C2F703E, _binary 0x3C703E2D2D3C2F703E, '11000000', '20200519174607', 'active', '2020-05-19 17:46:07', '2020-05-19 17:46:10', 'Lasik', '<p>-</p>'),
	(4, _binary 0x3C703E2D3C2F703E, _binary 0x3C703E2D3C2F703E, _binary 0x3C703E2D3C2F703E, '1000000', '20200519175121', 'active', '2020-05-19 17:51:21', '2020-05-19 17:51:25', 'Phaco Emulsifier', '<p>-</p>');

-- Dumping structure for table rsmata.migrations
CREATE TABLE IF NOT EXISTS `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.migrations: ~34 rows (approximately)
DELETE FROM `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, '2020_02_14_174952_create_beritas_table', 1),
	(4, '2020_02_16_101027_create_permission_tables', 2),
	(6, '2020_03_25_051249_create_berkas_table', 4),
	(71, '2020_05_02_002306_create_staticdatas_table', 5),
	(72, '2020_05_07_020802_create_mutupelayanans_table', 6),
	(75, '2020_05_07_122905_create_operasis_table', 7),
	(76, '2020_05_07_124950_create_polis_table', 8),
	(77, '2020_05_07_131237_create_fasilitas_table', 9),
	(78, '2020_05_07_134112_create_teknologis_table', 10),
	(79, '2020_05_07_180739_create_lasiks_table', 11),
	(80, '2020_05_08_233314_update_lasik', 12),
	(81, '2020_05_09_075712_create_dokters_table', 13),
	(82, '2020_05_09_115553_create_relasidokters_table', 14),
	(83, '2020_05_05_003940_add_beritas_column', 15),
	(84, '2020_05_05_010713_add_artikel', 15),
	(85, '2020_05_05_013509_add_pengumuman', 15),
	(86, '2020_05_05_014311_add_pengaduan', 15),
	(87, '2020_05_07_211155_create_daftar_lasik', 15),
	(88, '2020_05_07_211215_create_cerita_pasien', 15),
	(89, '2020_05_16_031618_create_riwayatpendidikans_table', 16),
	(90, '2020_05_16_031827_create_karyailmiahs_table', 16),
	(91, '2020_05_16_050243_add_column_teknologis', 17),
	(92, '2020_05_16_050810_create_karirs_table', 18),
	(94, '2020_05_16_051334_create_jadwalbesuks_table', 19),
	(95, '2020_05_16_051549_create_selayangdirekturs_table', 19),
	(96, '2020_05_16_052027_create_selayangperkembangans_table', 20),
	(98, '2020_05_16_114756_create_mitrakerjas_table', 21),
	(99, '2020_05_16_153047_create_dokumentasigambars_table', 22),
	(100, '2020_05_16_153700_create_dokumentasivideos_table', 23),
	(101, '2020_05_16_153933_create_dokumentasidocuments_table', 24),
	(102, '2020_05_16_155927_add_column_lasik', 25),
	(103, '2020_05_17_103008_add_column_staticdata', 26);

-- Dumping structure for table rsmata.mitrakerjas
CREATE TABLE IF NOT EXISTS `mitrakerjas` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deskripsi` longblob NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.mitrakerjas: ~0 rows (approximately)
DELETE FROM `mitrakerjas`;
INSERT INTO `mitrakerjas` (`id`, `title`, `deskripsi`, `status`, `slug`, `created_at`, `updated_at`) VALUES
	(1, 'puskesmas', _binary 0x3C703E5075736B65736D6173204B4172616E67204A6F616E673C2F703E, 'puskesmas', '20200519191716', '2020-05-19 19:17:16', '2020-05-19 19:17:16');

-- Dumping structure for table rsmata.model_has_permissions
CREATE TABLE IF NOT EXISTS `model_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.model_has_permissions: ~0 rows (approximately)
DELETE FROM `model_has_permissions`;

-- Dumping structure for table rsmata.model_has_roles
CREATE TABLE IF NOT EXISTS `model_has_roles` (
  `role_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.model_has_roles: ~0 rows (approximately)
DELETE FROM `model_has_roles`;
INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
	(1, 'App\\User', 1);

-- Dumping structure for table rsmata.mutupelayanans
CREATE TABLE IF NOT EXISTS `mutupelayanans` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `publish` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.mutupelayanans: ~0 rows (approximately)
DELETE FROM `mutupelayanans`;
INSERT INTO `mutupelayanans` (`id`, `nama`, `publish`, `slug`, `created_at`, `updated_at`) VALUES
	(1, 'NONAME', 'active', '20200518232425', '2020-05-18 23:24:25', '2020-05-18 23:24:28');

-- Dumping structure for table rsmata.operasis
CREATE TABLE IF NOT EXISTS `operasis` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `keterangan` longblob NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `publish` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.operasis: ~0 rows (approximately)
DELETE FROM `operasis`;

-- Dumping structure for table rsmata.pengaduans
CREATE TABLE IF NOT EXISTS `pengaduans` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `jenis_laporan` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nomor_telpon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `alamat` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deskripsi` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.pengaduans: ~0 rows (approximately)
DELETE FROM `pengaduans`;

-- Dumping structure for table rsmata.pengumumans
CREATE TABLE IF NOT EXISTS `pengumumans` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `judul` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `isi` longblob NOT NULL,
  `view` int(11) NOT NULL DEFAULT '0',
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `publish` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.pengumumans: ~0 rows (approximately)
DELETE FROM `pengumumans`;
INSERT INTO `pengumumans` (`id`, `judul`, `isi`, `view`, `slug`, `publish`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
	(1, 'noname', _binary 0x3C703E2D3C2F703E, 0, '20200519175733', 'active', 1, NULL, '2020-05-19 17:57:33', '2020-05-19 17:57:36');

-- Dumping structure for table rsmata.permissions
CREATE TABLE IF NOT EXISTS `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=350 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.permissions: ~141 rows (approximately)
DELETE FROM `permissions`;
INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(1, 'berita-index', 'web', '2020-02-16 10:40:47', '2020-02-16 10:40:47'),
	(2, 'berita-create', 'web', '2020-02-16 10:41:42', '2020-02-16 10:41:42'),
	(3, 'berita-view', 'web', '2020-02-16 10:41:52', '2020-02-16 10:41:52'),
	(4, 'berita-update', 'web', '2020-02-16 10:42:00', '2020-02-16 10:42:00'),
	(5, 'berita-delete', 'web', '2020-02-16 10:42:09', '2020-02-16 10:42:09'),
	(6, 'user-index', 'web', '2020-03-24 16:24:44', '2020-03-24 16:24:44'),
	(7, 'user-create', 'web', '2020-03-24 16:24:51', '2020-03-24 16:24:51'),
	(8, 'user-view', 'web', '2020-03-24 16:24:58', '2020-03-24 16:24:58'),
	(9, 'user-delete', 'web', '2020-03-24 16:25:08', '2020-03-24 16:25:08'),
	(10, 'user-update', 'web', '2020-03-24 16:25:16', '2020-03-24 16:25:16'),
	(11, 'file-index', 'web', '2020-03-24 16:30:36', '2020-03-24 16:30:36'),
	(12, 'role-index', 'web', '2020-03-24 16:31:16', '2020-03-24 16:31:16'),
	(13, 'role-create', 'web', '2020-03-24 16:31:27', '2020-03-24 16:31:27'),
	(14, 'role-update', 'web', '2020-03-24 16:31:33', '2020-03-24 16:31:33'),
	(15, 'role-view', 'web', '2020-03-24 16:31:40', '2020-03-24 16:31:40'),
	(16, 'role-delete', 'web', '2020-03-24 16:31:48', '2020-03-24 16:31:48'),
	(17, 'permission-index', 'web', '2020-03-24 16:32:28', '2020-03-24 16:32:28'),
	(18, 'permission-create', 'web', '2020-03-24 16:32:36', '2020-03-24 16:32:36'),
	(19, 'permission-update', 'web', '2020-03-24 16:32:44', '2020-03-24 16:32:44'),
	(20, 'permission-view', 'web', '2020-03-24 16:32:55', '2020-03-24 16:32:55'),
	(21, 'permission-delete', 'web', '2020-03-24 16:33:04', '2020-03-24 16:33:04'),
	(179, 'staticdata-index', 'web', '2020-05-02 05:14:49', '2020-05-02 05:14:49'),
	(180, 'staticdata-create', 'web', '2020-05-02 05:14:55', '2020-05-02 05:14:55'),
	(181, 'staticdata-view', 'web', '2020-05-02 05:15:01', '2020-05-02 05:15:01'),
	(182, 'staticdata-update', 'web', '2020-05-02 05:15:07', '2020-05-02 05:15:07'),
	(183, 'staticdata-delete', 'web', '2020-05-02 05:15:14', '2020-05-02 05:15:14'),
	(184, 'mutupelayanan-index', 'web', '2020-05-07 03:42:35', '2020-05-07 03:42:35'),
	(185, 'mutupelayanan-create', 'web', '2020-05-07 03:42:41', '2020-05-07 03:42:41'),
	(186, 'mutupelayanan-view', 'web', '2020-05-07 03:42:47', '2020-05-07 03:42:47'),
	(187, 'mutupelayanan-update', 'web', '2020-05-07 03:42:53', '2020-05-07 03:42:53'),
	(188, 'mutupelayanan-delete', 'web', '2020-05-07 03:43:00', '2020-05-07 03:43:00'),
	(189, 'operasi-index', 'web', '2020-05-07 12:42:35', '2020-05-07 12:42:35'),
	(190, 'operasi-create', 'web', '2020-05-07 12:42:42', '2020-05-07 12:42:42'),
	(191, 'operasi-view', 'web', '2020-05-07 12:42:48', '2020-05-07 12:42:48'),
	(192, 'operasi-update', 'web', '2020-05-07 12:42:55', '2020-05-07 12:42:55'),
	(193, 'operasi-delete', 'web', '2020-05-07 12:43:00', '2020-05-07 12:43:00'),
	(194, 'poli-index', 'web', '2020-05-07 12:52:28', '2020-05-07 12:52:28'),
	(195, 'poli-create', 'web', '2020-05-07 12:52:34', '2020-05-07 12:52:34'),
	(196, 'poli-view', 'web', '2020-05-07 12:52:40', '2020-05-07 12:52:40'),
	(197, 'poli-update', 'web', '2020-05-07 12:52:49', '2020-05-07 12:52:49'),
	(198, 'poli-delete', 'web', '2020-05-07 12:52:55', '2020-05-07 12:52:55'),
	(199, 'fasilitas-index', 'web', '2020-05-07 13:19:04', '2020-05-07 13:19:04'),
	(200, 'fasilitas-create', 'web', '2020-05-07 13:19:04', '2020-05-07 13:19:04'),
	(201, 'fasilitas-view', 'web', '2020-05-07 13:19:04', '2020-05-07 13:19:04'),
	(202, 'fasilitas-update', 'web', '2020-05-07 13:19:04', '2020-05-07 13:19:04'),
	(203, 'fasilitas-delete', 'web', '2020-05-07 13:19:04', '2020-05-07 13:19:04'),
	(204, 'teknologi-index', 'web', '2020-05-07 13:41:33', '2020-05-07 13:41:33'),
	(205, 'teknologi-create', 'web', '2020-05-07 13:41:33', '2020-05-07 13:41:33'),
	(206, 'teknologi-view', 'web', '2020-05-07 13:41:33', '2020-05-07 13:41:33'),
	(207, 'teknologi-update', 'web', '2020-05-07 13:41:33', '2020-05-07 13:41:33'),
	(208, 'teknologi-delete', 'web', '2020-05-07 13:41:33', '2020-05-07 13:41:33'),
	(209, 'lasik-index', 'web', '2020-05-07 18:42:14', '2020-05-07 18:42:14'),
	(210, 'lasik-create', 'web', '2020-05-07 18:42:14', '2020-05-07 18:42:14'),
	(211, 'lasik-view', 'web', '2020-05-07 18:42:14', '2020-05-07 18:42:14'),
	(212, 'lasik-update', 'web', '2020-05-07 18:42:14', '2020-05-07 18:42:14'),
	(213, 'lasik-delete', 'web', '2020-05-07 18:42:14', '2020-05-07 18:42:14'),
	(214, 'dokter-index', 'web', '2020-05-09 11:32:19', '2020-05-09 11:32:19'),
	(215, 'dokter-create', 'web', '2020-05-09 11:32:19', '2020-05-09 11:32:19'),
	(216, 'dokter-view', 'web', '2020-05-09 11:32:19', '2020-05-09 11:32:19'),
	(217, 'dokter-update', 'web', '2020-05-09 11:32:19', '2020-05-09 11:32:19'),
	(218, 'dokter-delete', 'web', '2020-05-09 11:32:19', '2020-05-09 11:32:19'),
	(219, 'relasidokter-index', 'web', '2020-05-09 12:02:10', '2020-05-09 12:02:10'),
	(220, 'relasidokter-create', 'web', '2020-05-09 12:02:10', '2020-05-09 12:02:10'),
	(221, 'relasidokter-view', 'web', '2020-05-09 12:02:10', '2020-05-09 12:02:10'),
	(222, 'relasidokter-update', 'web', '2020-05-09 12:02:10', '2020-05-09 12:02:10'),
	(223, 'relasidokter-delete', 'web', '2020-05-09 12:02:10', '2020-05-09 12:02:10'),
	(270, 'artikel-index', 'web', '2020-02-16 10:40:47', '2020-02-16 10:40:47'),
	(271, 'artikel-create', 'web', '2020-02-16 10:41:42', '2020-02-16 10:41:42'),
	(272, 'artikel-view', 'web', '2020-02-16 10:41:52', '2020-02-16 10:41:52'),
	(273, 'artikel-update', 'web', '2020-02-16 10:42:00', '2020-02-16 10:42:00'),
	(274, 'artikel-delete', 'web', '2020-02-16 10:42:09', '2020-02-16 10:42:09'),
	(275, 'pengumuman-index', 'web', '2020-02-16 10:40:47', '2020-02-16 10:40:47'),
	(276, 'pengumuman-create', 'web', '2020-02-16 10:41:42', '2020-02-16 10:41:42'),
	(277, 'pengumuman-view', 'web', '2020-02-16 10:41:52', '2020-02-16 10:41:52'),
	(278, 'pengumuman-update', 'web', '2020-02-16 10:42:00', '2020-02-16 10:42:00'),
	(279, 'pengumuman-delete', 'web', '2020-02-16 10:42:09', '2020-02-16 10:42:09'),
	(280, 'pengaduan-index', 'web', '2020-02-16 10:40:47', '2020-02-16 10:40:47'),
	(281, 'pengaduan-create', 'web', '2020-02-16 10:41:42', '2020-02-16 10:41:42'),
	(282, 'pengaduan-view', 'web', '2020-02-16 10:41:52', '2020-02-16 10:41:52'),
	(283, 'pengaduan-update', 'web', '2020-02-16 10:42:00', '2020-02-16 10:42:00'),
	(284, 'pengaduan-delete', 'web', '2020-02-16 10:42:09', '2020-02-16 10:42:09'),
	(285, 'daftarLasik-index', 'web', '2020-02-16 10:40:47', '2020-02-16 10:40:47'),
	(286, 'daftarLasik-create', 'web', '2020-02-16 10:41:42', '2020-02-16 10:41:42'),
	(287, 'daftarLasik-view', 'web', '2020-02-16 10:41:52', '2020-02-16 10:41:52'),
	(288, 'daftarLasik-update', 'web', '2020-02-16 10:42:00', '2020-02-16 10:42:00'),
	(289, 'daftarLasik-delete', 'web', '2020-02-16 10:42:09', '2020-02-16 10:42:09'),
	(290, 'ceritaPasien-index', 'web', '2020-05-16 03:35:29', '2020-05-16 03:35:29'),
	(291, 'ceritaPasien-create', 'web', '2020-05-16 03:35:29', '2020-05-16 03:35:29'),
	(292, 'ceritaPasien-view', 'web', '2020-05-16 03:35:29', '2020-05-16 03:35:29'),
	(293, 'ceritaPasien-update', 'web', '2020-05-16 03:35:29', '2020-05-16 03:35:29'),
	(294, 'ceritaPasien-delete', 'web', '2020-05-16 03:35:29', '2020-05-16 03:35:29'),
	(295, 'karyailmiah-index', 'web', '2020-05-16 03:35:29', '2020-05-16 03:35:29'),
	(296, 'karyailmiah-create', 'web', '2020-05-16 03:35:29', '2020-05-16 03:35:29'),
	(297, 'karyailmiah-view', 'web', '2020-05-16 03:35:29', '2020-05-16 03:35:29'),
	(298, 'karyailmiah-update', 'web', '2020-05-16 03:35:29', '2020-05-16 03:35:29'),
	(299, 'karyailmiah-delete', 'web', '2020-05-16 03:35:29', '2020-05-16 03:35:29'),
	(300, 'riwayatpendidikan-index', 'web', '2020-05-16 03:35:29', '2020-05-16 03:35:29'),
	(301, 'riwayatpendidikan-create', 'web', '2020-05-16 03:35:29', '2020-05-16 03:35:29'),
	(302, 'riwayatpendidikan-view', 'web', '2020-05-16 03:35:29', '2020-05-16 03:35:29'),
	(303, 'riwayatpendidikan-update', 'web', '2020-05-16 03:35:29', '2020-05-16 03:35:29'),
	(304, 'riwayatpendidikan-delete', 'web', '2020-05-16 03:35:29', '2020-05-16 03:35:29'),
	(305, 'karir-index', 'web', '2020-05-16 05:09:22', '2020-05-16 05:09:22'),
	(306, 'karir-create', 'web', '2020-05-16 05:09:22', '2020-05-16 05:09:22'),
	(307, 'karir-view', 'web', '2020-05-16 05:09:22', '2020-05-16 05:09:22'),
	(308, 'karir-update', 'web', '2020-05-16 05:09:22', '2020-05-16 05:09:22'),
	(309, 'karir-delete', 'web', '2020-05-16 05:09:22', '2020-05-16 05:09:22'),
	(310, 'jadwalbesuk-index', 'web', '2020-05-16 05:14:28', '2020-05-16 05:14:28'),
	(311, 'jadwalbesuk-create', 'web', '2020-05-16 05:14:28', '2020-05-16 05:14:28'),
	(312, 'jadwalbesuk-view', 'web', '2020-05-16 05:14:28', '2020-05-16 05:14:28'),
	(313, 'jadwalbesuk-update', 'web', '2020-05-16 05:14:28', '2020-05-16 05:14:28'),
	(314, 'jadwalbesuk-delete', 'web', '2020-05-16 05:14:28', '2020-05-16 05:14:28'),
	(315, 'selayangdirektur-index', 'web', '2020-05-16 05:18:24', '2020-05-16 05:18:24'),
	(316, 'selayangdirektur-create', 'web', '2020-05-16 05:18:24', '2020-05-16 05:18:24'),
	(317, 'selayangdirektur-view', 'web', '2020-05-16 05:18:24', '2020-05-16 05:18:24'),
	(318, 'selayangdirektur-update', 'web', '2020-05-16 05:18:24', '2020-05-16 05:18:24'),
	(319, 'selayangdirektur-delete', 'web', '2020-05-16 05:18:24', '2020-05-16 05:18:24'),
	(320, 'selayangperkembangan-index', 'web', '2020-05-16 05:22:04', '2020-05-16 05:22:04'),
	(321, 'selayangperkembangan-create', 'web', '2020-05-16 05:22:04', '2020-05-16 05:22:04'),
	(322, 'selayangperkembangan-view', 'web', '2020-05-16 05:22:04', '2020-05-16 05:22:04'),
	(323, 'selayangperkembangan-update', 'web', '2020-05-16 05:22:04', '2020-05-16 05:22:04'),
	(324, 'selayangperkembangan-delete', 'web', '2020-05-16 05:22:04', '2020-05-16 05:22:04'),
	(325, 'mitrakerja-index', 'web', '2020-05-16 11:53:03', '2020-05-16 11:53:03'),
	(326, 'mitrakerja-create', 'web', '2020-05-16 11:53:03', '2020-05-16 11:53:03'),
	(327, 'mitrakerja-view', 'web', '2020-05-16 11:53:03', '2020-05-16 11:53:03'),
	(328, 'mitrakerja-update', 'web', '2020-05-16 11:53:03', '2020-05-16 11:53:03'),
	(329, 'mitrakerja-delete', 'web', '2020-05-16 11:53:03', '2020-05-16 11:53:03'),
	(330, 'dokumentasigambar-index', 'web', '2020-05-16 15:31:47', '2020-05-16 15:31:47'),
	(331, 'dokumentasigambar-create', 'web', '2020-05-16 15:31:47', '2020-05-16 15:31:47'),
	(332, 'dokumentasigambar-view', 'web', '2020-05-16 15:31:47', '2020-05-16 15:31:47'),
	(333, 'dokumentasigambar-update', 'web', '2020-05-16 15:31:47', '2020-05-16 15:31:47'),
	(334, 'dokumentasigambar-delete', 'web', '2020-05-16 15:31:47', '2020-05-16 15:31:47'),
	(335, 'dokumentasivideo-index', 'web', '2020-05-16 15:37:56', '2020-05-16 15:37:56'),
	(336, 'dokumentasivideo-create', 'web', '2020-05-16 15:37:56', '2020-05-16 15:37:56'),
	(337, 'dokumentasivideo-view', 'web', '2020-05-16 15:37:56', '2020-05-16 15:37:56'),
	(338, 'dokumentasivideo-update', 'web', '2020-05-16 15:37:56', '2020-05-16 15:37:56'),
	(339, 'dokumentasivideo-delete', 'web', '2020-05-16 15:37:56', '2020-05-16 15:37:56'),
	(340, 'dokumentasidocument-index', 'web', '2020-05-16 15:41:03', '2020-05-16 15:41:03'),
	(341, 'dokumentasidocument-create', 'web', '2020-05-16 15:41:03', '2020-05-16 15:41:03'),
	(342, 'dokumentasidocument-view', 'web', '2020-05-16 15:41:03', '2020-05-16 15:41:03'),
	(343, 'dokumentasidocument-update', 'web', '2020-05-16 15:41:03', '2020-05-16 15:41:03'),
	(344, 'dokumentasidocument-delete', 'web', '2020-05-16 15:41:03', '2020-05-16 15:41:03'),
	(345, 'agenda-index', 'web', '2020-05-23 07:13:21', '2020-05-23 07:13:21'),
	(346, 'agenda-create', 'web', '2020-05-23 07:13:37', '2020-05-23 07:13:37'),
	(347, 'agenda-view', 'web', '2020-05-23 07:13:48', '2020-05-23 07:13:48'),
	(348, 'agenda-update', 'web', '2020-05-23 07:14:03', '2020-05-23 07:14:03'),
	(349, 'agenda-delete', 'web', '2020-05-23 07:14:16', '2020-05-23 07:14:16');

-- Dumping structure for table rsmata.polis
CREATE TABLE IF NOT EXISTS `polis` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `keterangan` longblob NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `publish` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.polis: ~11 rows (approximately)
DELETE FROM `polis`;
INSERT INTO `polis` (`id`, `nama`, `keterangan`, `slug`, `publish`, `created_at`, `updated_at`) VALUES
	(1, 'SICS', _binary 0x3C703E2D3C2F703E, '20200519175149', 'active', '2020-05-19 17:51:49', '2020-05-19 17:51:53'),
	(2, 'YAG LASER', _binary 0x3C703E2D3C2F703E, '20200519175208', 'active', '2020-05-19 17:52:08', '2020-05-19 17:52:15'),
	(3, 'Laser Koagulasi', _binary 0x3C703E2D3C2F703E, '20200519175233', 'active', '2020-05-19 17:52:33', '2020-05-19 17:52:37'),
	(4, 'USG Mata', _binary 0x3C703E2D3C2F703E, '20200519175250', 'active', '2020-05-19 17:52:50', '2020-05-19 17:53:38'),
	(5, 'Biometri', _binary 0x3C703E2D3C2F703E, '20200519175333', 'active', '2020-05-19 17:53:33', '2020-05-19 17:53:42'),
	(6, 'Insisi Hordeolom', _binary 0x3C703E2D3C2F703E, '20200519175400', 'active', '2020-05-19 17:54:00', '2020-05-19 17:54:05'),
	(7, 'Eksisi Kalazion', _binary 0x3C703E2D3C2F703E, '20200519175419', 'active', '2020-05-19 17:54:19', '2020-05-19 17:54:24'),
	(8, 'Epilasi', _binary 0x3C703E2D3C2F703E, '20200519175436', 'active', '2020-05-19 17:54:36', '2020-05-19 17:54:40'),
	(9, 'Irigasi Bola Mata', _binary 0x3C703E2D3C2F703E, '20200519175500', 'active', '2020-05-19 17:55:00', '2020-05-19 17:55:07'),
	(10, 'Trabeculactomy', _binary 0x3C703E2D3C2F703E, '20200519175524', 'active', '2020-05-19 17:55:24', '2020-05-19 17:55:30'),
	(11, 'Vitrektomi', _binary 0x3C703E2D3C2F703E, '20200519175549', 'active', '2020-05-19 17:55:49', '2020-05-19 17:55:56');

-- Dumping structure for table rsmata.relasidokters
CREATE TABLE IF NOT EXISTS `relasidokters` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `dokter_id` int(10) unsigned NOT NULL,
  `relasidokter_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `relasidokter_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `relasidokters_relasidokter_type_relasidokter_id_index` (`relasidokter_type`,`relasidokter_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.relasidokters: ~0 rows (approximately)
DELETE FROM `relasidokters`;

-- Dumping structure for table rsmata.riwayatpendidikans
CREATE TABLE IF NOT EXISTS `riwayatpendidikans` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `universitas` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fakultas` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tahun` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `strata` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `dokter_id` int(10) unsigned NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.riwayatpendidikans: ~0 rows (approximately)
DELETE FROM `riwayatpendidikans`;

-- Dumping structure for table rsmata.roles
CREATE TABLE IF NOT EXISTS `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.roles: ~3 rows (approximately)
DELETE FROM `roles`;
INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
	(1, 'superadmin', 'web', '2020-02-16 10:43:23', '2020-02-16 10:43:23'),
	(2, 'admin', 'web', '2020-03-24 14:53:37', '2020-03-24 14:53:37'),
	(3, 'member', 'web', '2020-03-24 14:53:47', '2020-03-24 14:53:47');

-- Dumping structure for table rsmata.role_has_permissions
CREATE TABLE IF NOT EXISTS `role_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.role_has_permissions: ~141 rows (approximately)
DELETE FROM `role_has_permissions`;
INSERT INTO `role_has_permissions` (`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),
	(179, 1),
	(180, 1),
	(181, 1),
	(182, 1),
	(183, 1),
	(184, 1),
	(185, 1),
	(186, 1),
	(187, 1),
	(188, 1),
	(189, 1),
	(190, 1),
	(191, 1),
	(192, 1),
	(193, 1),
	(194, 1),
	(195, 1),
	(196, 1),
	(197, 1),
	(198, 1),
	(199, 1),
	(200, 1),
	(201, 1),
	(202, 1),
	(203, 1),
	(204, 1),
	(205, 1),
	(206, 1),
	(207, 1),
	(208, 1),
	(209, 1),
	(210, 1),
	(211, 1),
	(212, 1),
	(213, 1),
	(214, 1),
	(215, 1),
	(216, 1),
	(217, 1),
	(218, 1),
	(219, 1),
	(220, 1),
	(221, 1),
	(222, 1),
	(223, 1),
	(270, 1),
	(271, 1),
	(272, 1),
	(273, 1),
	(274, 1),
	(275, 1),
	(276, 1),
	(277, 1),
	(278, 1),
	(279, 1),
	(280, 1),
	(281, 1),
	(282, 1),
	(283, 1),
	(284, 1),
	(285, 1),
	(286, 1),
	(287, 1),
	(288, 1),
	(289, 1),
	(290, 1),
	(291, 1),
	(292, 1),
	(293, 1),
	(294, 1),
	(295, 1),
	(296, 1),
	(297, 1),
	(298, 1),
	(299, 1),
	(300, 1),
	(301, 1),
	(302, 1),
	(303, 1),
	(304, 1),
	(305, 1),
	(306, 1),
	(307, 1),
	(308, 1),
	(309, 1),
	(310, 1),
	(311, 1),
	(312, 1),
	(313, 1),
	(314, 1),
	(315, 1),
	(316, 1),
	(317, 1),
	(318, 1),
	(319, 1),
	(320, 1),
	(321, 1),
	(322, 1),
	(323, 1),
	(324, 1),
	(325, 1),
	(326, 1),
	(327, 1),
	(328, 1),
	(329, 1),
	(330, 1),
	(331, 1),
	(332, 1),
	(333, 1),
	(334, 1),
	(335, 1),
	(336, 1),
	(337, 1),
	(338, 1),
	(339, 1),
	(340, 1),
	(341, 1),
	(342, 1),
	(343, 1),
	(344, 1),
	(345, 1),
	(346, 1),
	(347, 1),
	(348, 1),
	(349, 1);

-- Dumping structure for table rsmata.selayangdirekturs
CREATE TABLE IF NOT EXISTS `selayangdirekturs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `direkturke` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `periode` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.selayangdirekturs: ~0 rows (approximately)
DELETE FROM `selayangdirekturs`;
INSERT INTO `selayangdirekturs` (`id`, `nama`, `direkturke`, `periode`, `slug`, `created_at`, `updated_at`) VALUES
	(1, 'drg. shanty Sintessa Wulaningrum, M.Kes', '??', '2020', '20200518233635', '2020-05-18 23:36:35', '2020-05-18 23:36:35');

-- Dumping structure for table rsmata.selayangperkembangans
CREATE TABLE IF NOT EXISTS `selayangperkembangans` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tahun` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `perkembangan` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.selayangperkembangans: ~2 rows (approximately)
DELETE FROM `selayangperkembangans`;
INSERT INTO `selayangperkembangans` (`id`, `tahun`, `perkembangan`, `slug`, `created_at`, `updated_at`) VALUES
	(1, '1994', 'Pra-BKMM', '20200518233721', '2020-05-18 23:37:21', '2020-05-18 23:37:21'),
	(2, '2001', 'BKMM', '20200518233734', '2020-05-18 23:37:34', '2020-05-18 23:37:34');

-- Dumping structure for table rsmata.staticdatas
CREATE TABLE IF NOT EXISTS `staticdatas` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `detail` longblob,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'single',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.staticdatas: ~21 rows (approximately)
DELETE FROM `staticdatas`;
INSERT INTO `staticdatas` (`id`, `name`, `slug`, `detail`, `created_at`, `updated_at`, `status`) VALUES
	(1, '0. Panduan / Tata Cara Penggunaan', 'tatacara', _binary 0x3C703E496E6920446174612050616E6475616E2E266E6273703B3C2F703E, '2020-05-02 06:17:24', '2020-05-02 06:17:24', 'single'),
	(2, '1. Nama Aplikasi', 'titleapp', _binary 0x3C703E41646D696E20576562736974652052756D61682053616B6974204D6174612050726F76696E7369204B616C696D616E74616E2054696D75723C2F703E, '2020-05-02 06:18:12', '2020-05-18 19:15:06', 'single'),
	(3, '2. Logo Aplikasi', 'logoapp', _binary 0x3C703E4D6173756B616E204C6F676F204170702E3C2F703E, '2020-05-02 06:19:20', '2020-05-02 06:19:20', 'single'),
	(4, '3. Deskripsi Aplikasi', 'deskripsiapp', _binary 0x3C703E4D6173756B616E204465736B72697073692041706C696B61736920446973696E692E3C2F703E, '2020-05-02 06:19:51', '2020-05-02 06:19:51', 'single'),
	(5, '4. Visi', 'visimisi', _binary 0x[BLOB], '2020-05-09 13:05:23', '2020-05-20 03:26:58', 'single'),
	(6, '5. Sejarah', 'sejarah', _binary 0x[BLOB], '2020-05-09 13:05:41', '2020-05-18 20:44:33', 'single'),
	(7, '6. struktur', 'struktur', _binary 0x3C703E737472756B7475723C2F703E, '2020-05-09 13:06:29', '2020-05-09 13:06:29', 'single'),
	(8, '7. Alur Pelayanan', 'alurpelayanan', NULL, '2020-05-09 13:13:12', '2020-05-09 13:13:12', 'single'),
	(9, '8. Biaya Layanan', 'biayalayanan', NULL, '2020-05-09 13:13:31', '2020-05-09 13:14:16', 'single'),
	(10, '9. Kontak Alamat', 'kontakalamat', _binary 0x3C703E4A6C2E20426173756B69205261686D6174204E6F2E2030312053616D6172696E64613C2F703E, '2020-05-09 13:13:47', '2020-05-18 20:36:26', 'single'),
	(11, '10. kontak nomor telephone', 'kontaknomortelephone', _binary 0x[BLOB], '2020-05-09 13:14:43', '2020-05-18 20:46:32', 'single'),
	(12, '11. kontak instagram', 'kontakinstagram', _binary 0x[BLOB], '2020-05-09 13:15:15', '2020-05-18 20:50:06', 'single'),
	(13, '12. kontak facebook', 'kontakfacebook', _binary 0x3C703E3C6120687265663D2268747470733A2F2F7777772E66616365626F6F6B2E636F6D2F72756D61682E73616B69742E3938383337333939223E68747470733A2F2F7777772E66616365626F6F6B2E636F6D2F72756D61682E73616B69742E39383833373339393C2F613E3C62723E3C2F703E, '2020-05-09 13:15:32', '2020-05-18 21:09:46', 'single'),
	(14, '13. kontak-twitter', 'kontaktwitter', _binary 0x3C703E3C6120687265663D2268747470733A2F2F747769747465722E636F6D2F72736D61746170726F766B616C7431223E68747470733A2F2F747769747465722E636F6D2F72736D61746170726F766B616C74313C2F613E3C62723E3C2F703E, '2020-05-09 13:15:45', '2020-05-18 21:16:06', 'single'),
	(15, '14. Ibu Kepala Dinas', 'ibukepaladinas', NULL, '2020-05-12 04:51:20', '2020-05-12 04:51:20', 'single'),
	(16, '15. Indeks Kepuasan Masyarakat', 'indekskepuasan', _binary 0x3C703E31352E20496E64656B73204B6570756173616E204D6173796172616B61743C62723E3C2F703E, '2020-05-17 10:27:53', '2020-05-17 10:27:53', 'multi'),
	(17, '16. Pencehgahan HIV/AIDS', 'pencegahanhiv', _binary 0x[BLOB], '2020-05-17 10:28:20', '2020-05-17 10:28:20', 'multi'),
	(18, 'Tentang Kami', 'tentangkami', _binary 0x[BLOB], '2020-05-18 23:35:32', '2020-05-20 04:40:53', 'single'),
	(19, 'Highlight Foto', 'highlight', NULL, '2020-05-19 17:59:56', '2020-05-20 05:00:13', 'multi'),
	(20, 'Misi', 'misi', _binary 0x[BLOB], '2020-05-20 03:25:57', '2020-05-20 04:34:22', 'single'),
	(21, 'Motto', 'motto', _binary 0x[BLOB], '2020-05-20 03:26:13', '2020-05-20 03:28:19', 'single'),
	(22, 'Title Direktur', 'titledirektur', _binary 0x3C703E446972656B7475722052756D61682053616B6974204D6174613C2F703E, '2020-05-20 03:29:40', '2020-05-20 03:29:40', 'single'),
	(23, 'Nama Direktur', 'namadirektur', _binary 0x3C703E6472672E205368616E74792053696E74657373612057756C616E696E6772756D2C204D2E4B65733C2F703E, '2020-05-20 03:30:19', '2020-05-20 03:30:19', 'single'),
	(24, 'Jam Pelayanan', 'jampelayanan', _binary 0x3C703E53656E696E202D204B616D6973203A2030382E303020732F642031332E303020576974613C2F703E, '2020-05-20 05:46:37', '2020-05-20 05:46:37', 'single');

-- Dumping structure for table rsmata.teknologis
CREATE TABLE IF NOT EXISTS `teknologis` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `keterangan` longblob NOT NULL,
  `lasik_id` int(10) unsigned DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `publish` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'inactive',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `kegunaan` longblob NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table rsmata.teknologis: ~1 rows (approximately)
DELETE FROM `teknologis`;
INSERT INTO `teknologis` (`id`, `nama`, `keterangan`, `lasik_id`, `slug`, `publish`, `created_at`, `updated_at`, `kegunaan`) VALUES
	(2, 'Nidek Micro Keratomi 1.2', _binary 0x3C703E2D3C2F703E, NULL, '20200519190114', 'active', '2020-05-19 19:01:14', '2020-05-19 19:01:17', _binary 0x3C703E2D3C2F703E);

