text: -- phpMyAdmin SQL Dump
  -- version 4.8.2
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Generation Time: Jul 05, 2019 at 06:33 AM
  -- Server version: 10.1.34-MariaDB
  -- PHP Version: 7.2.7
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET AUTOCOMMIT = 0;
  START TRANSACTION;
  SET time_zone = "+00:00";
  
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8mb4 */;
  
  --
  -- Database: `fahri`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `artikels`
  --
  
  CREATE TABLE `artikels` (
    `id` int(10) UNSIGNED NOT NULL,
    `user_id` int(10) UNSIGNED NOT NULL,
    `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `body` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `excerpt` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `thumbnail` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `view` int(11) NOT NULL DEFAULT '0',
    `category_id` int(10) UNSIGNED 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 `categories`
  --
  
  CREATE TABLE `categories` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `slug` varchar(255) 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 `galeries`
  --
  
  CREATE TABLE `galeries` (
    `id` int(10) UNSIGNED NOT NULL,
    `artikel_id` int(11) NOT NULL,
    `thumbnail` 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 `migrations`
  --
  
  CREATE TABLE `migrations` (
    `id` int(10) UNSIGNED NOT NULL,
    `migration` varchar(255) 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, '2019_01_30_131818_create_categories_tabel', 1),
  (3, '2019_01_30_132835_create_artikels_tabel', 1),
  (4, '2019_02_26_140554_create_profile_table', 1),
  (5, '2019_02_26_141751_create_settings_table', 1),
  (6, '2019_02_27_151339_create_others_table', 1),
  (7, '2019_02_28_143421_create_galeries_table', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `others`
  --
  
  CREATE TABLE `others` (
    `id` int(10) UNSIGNED NOT NULL,
    `detail` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `keterangan` varchar(255) 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 `others`
  --
  
  INSERT INTO `others` (`id`, `detail`, `keterangan`, `created_at`, `updated_at`) VALUES
  (1, 'Adapun biaya jasa pengerjaan kaligrafi mulai dari harga Rp. 300.000/meter lari (tinggi maksimal 60 cm). Jika tinggi lebih dari 60 cm maka harga kami hitung Rp.400.000/meter lari. Harga tergantung dari ukuran dan tingkat kerumitan motif / konsep desain yang diinginkan. Harga di atas hanya untuk estimasi / perkiraan saja, untuk kepastian harga bisa di tentukan jika sudah ada kepastian dan ukuran dari pihak masjid, ataupun harga bisa di tentukan pada saat survey ke lokasi anda. Harga ini sudah termasuk biaya pengerjaan, peralatan, transportasi, dll. Jika di perlukan survey terlebih dahulu, kami siap berangkat ke lokasi dengan biaya survey di bebankan kepada konsumen. (Biaya survey tergantung dimana lokasi masjid tersebut).', 'ket_harga', NULL, NULL),
  (2, '‘Fahri Art’ adalah sebuah organisasi yang bergerak di jasa pembuatan kaligrafi masjid, ornamentasi mihrab, ornamentasi dinding masjid, ornamentasi kubah masjid, ornamentasi ruangan, penulisan mushaf Al-Qur’an, dan lain sebagainya pada bidang Islamic.', 'profile', NULL, NULL),
  (3, 'Teknik pengerjaan ‘Fahri Art’ secara manual oleh tangan-tangan kami yang kreatif dan professional akan memanjakan mata anda untuk melihat keindahan tulisan para dekor islam. Team kami terdiri dari seniman muslim yang sudah mengeluarkan banyak karyanya pada sebagian masjid di Indonesia.', 'pengerjaan', NULL, NULL),
  (4, '‘Fahri Art’ menyuguhkan beberapa jenis tulisan yang sesuai dengan kemauan anda yaitu, kombinasi khat tsulus, naskhi, riq’i, kufi, farisi dan diwani. Dengan teknik pengecetan yang profesional sehingga mampu menjaga kehalusan karya dan kualitas ketahanan.', 'kualitas', NULL, NULL),
  (5, 'Harga terjangkau tergantung dari ukuran dan tingkat kerumitan motif atau konsep desain yang diinginkan.', 'harga', NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `profile`
  --
  
  CREATE TABLE `profile` (
    `id` int(10) UNSIGNED NOT NULL,
    `user_id` int(11) NOT NULL,
    `first_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `phone` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `address` text COLLATE utf8mb4_unicode_ci,
    `photo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `nickname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `facebook` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `instagram` varchar(255) 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 `profile`
  --
  
  INSERT INTO `profile` (`id`, `user_id`, `first_name`, `last_name`, `phone`, `address`, `photo`, `nickname`, `facebook`, `instagram`, `created_at`, `updated_at`) VALUES
  (1, 1, 'Super', 'Admin', '81227535208', 'Cibinong, Bogor', NULL, NULL, NULL, NULL, NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `settings`
  --
  
  CREATE TABLE `settings` (
    `id` int(10) UNSIGNED NOT NULL,
    `setting_key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `setting_value` longtext 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 `settings`
  --
  
  INSERT INTO `settings` (`id`, `setting_key`, `setting_value`, `created_at`, `updated_at`) VALUES
  (1, 'Title', 'FahriART | Jasa Pembuatan Kaligrafi Masjid', NULL, NULL),
  (2, 'Description', 'Pusat pembuatan kaligrafi masjid', NULL, NULL),
  (3, 'Whatsapp', '', NULL, NULL),
  (4, 'Email', '', NULL, NULL),
  (5, 'Telphone', '', NULL, NULL),
  (6, 'Facebook', 'https://www.facebook.com/', NULL, NULL),
  (7, 'Instagram', 'https://www.instagram.com/', NULL, NULL),
  (8, 'Alamat', 'Alamat', NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `users`
  --
  
  CREATE TABLE `users` (
    `id` int(10) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `remember_token` varchar(100) 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 `users`
  --
  
  INSERT INTO `users` (`id`, `name`, `email`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
  (1, 'admin', 'admin@admin.com', '$2y$10$dPRQpGPnMKqCu0dn2yk5dOgN0ZbBOA3lJVkcBaZNCRhL1WtKBqw6W', NULL, NULL, NULL);
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `artikels`
  --
  ALTER TABLE `artikels`
    ADD PRIMARY KEY (`id`),
    ADD KEY `artikels_user_id_foreign` (`user_id`),
    ADD KEY `artikels_category_id_foreign` (`category_id`);
  
  --
  -- Indexes for table `categories`
  --
  ALTER TABLE `categories`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `galeries`
  --
  ALTER TABLE `galeries`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `migrations`
  --
  ALTER TABLE `migrations`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `others`
  --
  ALTER TABLE `others`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `profile`
  --
  ALTER TABLE `profile`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `settings`
  --
  ALTER TABLE `settings`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `users`
  --
  ALTER TABLE `users`
    ADD PRIMARY KEY (`id`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `artikels`
  --
  ALTER TABLE `artikels`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `categories`
  --
  ALTER TABLE `categories`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `galeries`
  --
  ALTER TABLE `galeries`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `migrations`
  --
  ALTER TABLE `migrations`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
  
  --
  -- AUTO_INCREMENT for table `others`
  --
  ALTER TABLE `others`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  --
  -- AUTO_INCREMENT for table `profile`
  --
  ALTER TABLE `profile`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  
  --
  -- AUTO_INCREMENT for table `settings`
  --
  ALTER TABLE `settings`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
  
  --
  -- 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 `artikels`
  --
  ALTER TABLE `artikels`
    ADD CONSTRAINT `artikels_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
    ADD CONSTRAINT `artikels_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
  COMMIT;
  
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  