text: -- phpMyAdmin SQL Dump
  -- version 5.0.2
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Generation Time: Dec 22, 2020 at 04:29 PM
  -- Server version: 10.4.14-MariaDB
  -- PHP Version: 7.4.10
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  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: `yamaha_jabar`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `career`
  --
  
  CREATE TABLE `career` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `is_active` tinyint(1) 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 `career`
  --
  
  INSERT INTO `career` (`id`, `name`, `description`, `is_active`, `created_at`, `updated_at`) VALUES
  (1, 'Assistant Promotion Manager', '<p>We are hiring for Assistant Promotion Manager position!<br /><br />Kirim lamaran Anda ke hr.recruitment.yamahastsj@gmail.com dengan subyek &quot;Lamaran Asst. Promotion Manager&quot;<br /><br /><br />More information:<br />PT Surya Timur Sakti Jatim<br />Jl. Basuki Rahmad No. 45-47, Surabaya<br />(031) 5312121<br /><br />Check our Instagram @ yamaharecruitment for more info and other job opportunities!<br /><br /><br />Requirements:</p><ul><li>Pria/Wanita</li><li>Pendidikan min. S1 semua jurusan, usia max. 35 tahun</li><li>Pengalaman di bidang event management lebih diutamakan</li><li>Bisa memimpin tim dan bekerja sama</li><li>Mampu mengoperasikan MS. Office</li><li>Berjiwa kreatif dan inisiatif</li><li>Memiliki SIM A dan C</li></ul>', 0, '2020-12-15 02:49:43', '2020-12-15 03:24:27'),
  (2, 'Fleet/Marketing Corporate (Female)', '<p>We are hiring for Fleet/Marketing Corporate (Female) position!<br /><br />Kirim lamaran Anda ke hr.recruitment.yamahastsj@gmail.com dengan subyek &quot;Lamaran Fleet Female&quot;<br /><br /><br />More information:<br />PT Surya Timur Sakti Jatim<br />Jl. Basuki Rahmad No. 45-47, Surabaya<br />(031) 5312121<br /><br />Check our Instagram @ yamaharecruitment for more info and other job opportunities!<br /><br /><br />Requirements:</p><ul><li>Wanita</li><li>Pendidikan min. D3/S1, usia max. 30 tahun</li><li>Pengalaman min. 1 tahun di bidang penjualan</li><li>Memiliki kemampuan komunikasi dan negosiasi yang baik</li><li>Memiliki relasi di perusahaan-perusahaan potensial</li><li>Berpenampilan menarik, rambut biasa terurai, terbiasa menggunakan make-up dan sepatu hak tinggi, fashionable</li><li>Komunikatif</li><li>Dapat melakukan presentasi kepada klien</li></ul>', 1, '2020-12-15 02:58:25', '2020-12-15 02:58:25'),
  (3, 'Fleet/Marketing Corporate (Male)', '<p>We are hiring for Fleet/Marketing Corporate (Male) position!<br /><br />Kirim lamaran Anda ke hr.recruitment.yamahastsj@gmail.com dengan subyek &quot;Lamaran Fleet Corporate&quot;<br /><br /><br />More information:<br />PT Surya Timur Sakti Jatim<br />Jl. Basuki Rahmad No. 45-47, Surabaya<br />(031) 5312121<br /><br />Check our Instagram @ yamaharecruitment for more info and other job opportunities!<br /><br /><br />Requirements:</p><ul><li>Pria</li><li>Pendidikan min. D3/S1 semua jurusan, usia max. 30 tahun</li><li>Pengalaman min. 1 tahun di bidangnya</li><li>Berorientasi pada target</li><li>Memiliki relasi di perusahaan-perusahaan potensial maupun pemerintahan</li><li>Komunikatif dan memiliki kemampuan bernegosiasi</li><li>Dapat melakukan presentasi kepada klien</li><li>Good looking dan berpenampilan rapi</li><li>Memiliki SIM A lebih disukai</li></ul>', 1, '2020-12-15 02:58:39', '2020-12-15 02:58:39');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `categories`
  --
  
  CREATE TABLE `categories` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `image` 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 `categories`
  --
  
  INSERT INTO `categories` (`id`, `name`, `image`, `created_at`, `updated_at`) VALUES
  (1, 'Matic', 'images/categories/matic.png', '2020-11-23 08:47:15', '2020-11-23 08:47:15'),
  (2, 'Moped', 'images/categories/moped.png', '2020-11-23 08:47:15', '2020-11-23 08:47:15'),
  (3, 'Sport', 'images/categories/sport.png', '2020-11-23 08:47:15', '2020-11-23 08:47:15'),
  (4, 'Moto GP', 'images/categories/motogp.png', '2020-11-23 08:47:15', '2020-11-23 08:47:15');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `colors`
  --
  
  CREATE TABLE `colors` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `product_id` bigint(20) UNSIGNED NOT NULL,
    `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `image` 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 `colors`
  --
  
  INSERT INTO `colors` (`id`, `product_id`, `name`, `image`, `created_at`, `updated_at`) VALUES
  (3, 4, 'Mysterious Red', 'images/color/1606154085_771.png', '2020-11-23 10:54:45', '2020-11-23 10:54:45'),
  (4, 5, 'Hitam', 'images/color/1608021304_694.png', '2020-12-15 01:35:04', '2020-12-15 01:35:04'),
  (5, 5, 'Merah', 'images/color/1608021316_694.png', '2020-12-15 01:35:16', '2020-12-15 01:35:16');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `failed_jobs`
  --
  
  CREATE TABLE `failed_jobs` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
    `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
    `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `features`
  --
  
  CREATE TABLE `features` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `product_id` bigint(20) UNSIGNED NOT NULL,
    `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `image` 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 `features`
  --
  
  INSERT INTO `features` (`id`, `product_id`, `name`, `image`, `created_at`, `updated_at`) VALUES
  (5, 4, 'Lampu LED', 'images/feature/1606154068_629.png', '2020-11-23 10:54:28', '2020-11-23 10:54:28'),
  (6, 4, 'Answer Back System', 'images/feature/1606154077_789.png', '2020-11-23 10:54:37', '2020-11-23 10:54:37'),
  (7, 5, '.', 'images/feature/1608021286_935.png', '2020-12-15 01:34:46', '2020-12-15 01:34:46'),
  (8, 5, '.', 'images/feature/1608021295_796.png', '2020-12-15 01:34:55', '2020-12-15 01:34:55');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `messages`
  --
  
  CREATE TABLE `messages` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `company` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `phone` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `fax` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `content` 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 `messages`
  --
  
  INSERT INTO `messages` (`id`, `name`, `email`, `company`, `phone`, `fax`, `address`, `content`, `created_at`, `updated_at`) VALUES
  (1, 'nama', 'email@gmail.com', 'company', '093209', '093209', 'PT ARISTA JAYA LESTARI, Jl. Ipik Gandamanah No.176, Munjuljaya, Purwakarta, Jawa Barat 41117\r\nTlp & Wa : 0821 2399 7870\r\nfb & Ig : @promoyamahajabar', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Maecenas feugiat orci cursus, accumsan nisi a, luctus magna. Sed tempus placerat ullamcorper. Integer ut libero in lectus fermentum fermentum. Aliquam in ligula blandit, mattis elit sit amet liber', '2020-11-23 09:50:12', '2020-11-23 09:50:12'),
  (2, 'hello', 'email@email.com', NULL, NULL, NULL, 'address', 'pesan', '2020-11-23 09:50:27', '2020-11-23 09:50:27');
  
  -- --------------------------------------------------------
  
  --
  -- 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
  (11, '2014_10_12_000000_create_users_table', 1),
  (12, '2014_10_12_100000_create_password_resets_table', 1),
  (13, '2019_08_19_000000_create_failed_jobs_table', 1),
  (14, '2020_11_23_152056_create_categories_table', 1),
  (15, '2020_11_23_152115_create_regions_table', 1),
  (16, '2020_11_23_152123_create_networks_table', 1),
  (17, '2020_11_23_152219_create_messages_table', 1),
  (18, '2020_11_23_152235_create_products_table', 1),
  (19, '2020_11_23_152244_create_features_table', 1),
  (20, '2020_11_23_152257_create_colors_table', 1),
  (22, '2020_12_15_084706_create_career_table', 2);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `networks`
  --
  
  CREATE TABLE `networks` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `region_id` bigint(20) UNSIGNED NOT NULL,
    `name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `is_head_office` tinyint(1) NOT NULL DEFAULT 0,
    `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 `networks`
  --
  
  INSERT INTO `networks` (`id`, `region_id`, `name`, `address`, `phone`, `is_head_office`, `created_at`, `updated_at`) VALUES
  (1, 2, 'GONDANG LEGI INDAH', 'Jl. Raya Hayam Wuruk (Utara RSI) - Gondang Legi Malang', '879 219', 0, '2020-11-23 09:29:01', '2020-11-23 09:29:01'),
  (2, 1, 'SENTRAL YAMAHA BASRA', 'Jl. Basuki Rachmad 45-47 Surabaya', '531 5588', 1, '2020-11-23 09:29:32', '2020-11-23 09:29:32'),
  (3, 4, 'SENTRAL YAMAHA GAJAH MADA', 'Jl. Gajah Mada 296 Jember', '487 200', 0, '2020-11-23 09:30:05', '2020-11-23 09:30:05');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `password_resets`
  --
  
  CREATE TABLE `password_resets` (
    `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `token` varchar(255) 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 `products`
  --
  
  CREATE TABLE `products` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `category_id` bigint(20) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `cover` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `spec` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `tvc` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `slider` 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 `products`
  --
  
  INSERT INTO `products` (`id`, `category_id`, `name`, `cover`, `logo`, `spec`, `tvc`, `slider`, `created_at`, `updated_at`) VALUES
  (4, 1, 'Mio S - Smart Sophisticated', 'images/products/cover/1606154054_832.png', 'images/products/logo/1607354798_519.png', 'images/products/spec/1607354798_475.png', 'https://www.youtube.com/embed/Y8liMsWDC80', 'images/products/slider/1606154054_467.png', '2020-11-23 10:54:14', '2020-12-07 08:34:52'),
  (5, 2, 'Vega RR', 'images/products/cover/1608021162_328.png', 'images/products/logo/1608021162_490.png', 'images/products/spec/1608021162_224.png', NULL, 'images/products/slider/1608021162_309.png', '2020-12-15 01:32:42', '2020-12-15 01:32:42');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `regions`
  --
  
  CREATE TABLE `regions` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `name` varchar(50) 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 `regions`
  --
  
  INSERT INTO `regions` (`id`, `name`, `created_at`, `updated_at`) VALUES
  (1, 'Surabaya', '2020-11-23 09:18:35', '2020-11-23 09:18:35'),
  (2, 'Malang', '2020-11-23 09:18:40', '2020-11-23 09:18:40'),
  (4, 'Jember', '2020-11-23 09:18:59', '2020-11-23 09:18:59');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `users`
  --
  
  CREATE TABLE `users` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `username` 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`, `username`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
  (1, 'admin', '$2y$10$kl0mRGHActifGLZ4ZzC7N.3uF1NubxLVIrGFnjtO2GpNAcRa1lC0a', NULL, '2020-11-23 08:47:15', '2020-11-23 08:47:15');
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `career`
  --
  ALTER TABLE `career`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `categories`
  --
  ALTER TABLE `categories`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `colors`
  --
  ALTER TABLE `colors`
    ADD PRIMARY KEY (`id`),
    ADD KEY `colors_product_id_foreign` (`product_id`);
  
  --
  -- Indexes for table `failed_jobs`
  --
  ALTER TABLE `failed_jobs`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);
  
  --
  -- Indexes for table `features`
  --
  ALTER TABLE `features`
    ADD PRIMARY KEY (`id`),
    ADD KEY `features_product_id_foreign` (`product_id`);
  
  --
  -- Indexes for table `messages`
  --
  ALTER TABLE `messages`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `migrations`
  --
  ALTER TABLE `migrations`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `networks`
  --
  ALTER TABLE `networks`
    ADD PRIMARY KEY (`id`),
    ADD KEY `networks_region_id_foreign` (`region_id`);
  
  --
  -- Indexes for table `password_resets`
  --
  ALTER TABLE `password_resets`
    ADD KEY `password_resets_email_index` (`email`);
  
  --
  -- Indexes for table `products`
  --
  ALTER TABLE `products`
    ADD PRIMARY KEY (`id`),
    ADD KEY `products_category_id_foreign` (`category_id`);
  
  --
  -- Indexes for table `regions`
  --
  ALTER TABLE `regions`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `users`
  --
  ALTER TABLE `users`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `users_username_unique` (`username`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `career`
  --
  ALTER TABLE `career`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- AUTO_INCREMENT for table `categories`
  --
  ALTER TABLE `categories`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  
  --
  -- AUTO_INCREMENT for table `colors`
  --
  ALTER TABLE `colors`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  --
  -- AUTO_INCREMENT for table `failed_jobs`
  --
  ALTER TABLE `failed_jobs`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `features`
  --
  ALTER TABLE `features`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
  
  --
  -- AUTO_INCREMENT for table `messages`
  --
  ALTER TABLE `messages`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT for table `migrations`
  --
  ALTER TABLE `migrations`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;
  
  --
  -- AUTO_INCREMENT for table `networks`
  --
  ALTER TABLE `networks`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- AUTO_INCREMENT for table `products`
  --
  ALTER TABLE `products`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  --
  -- AUTO_INCREMENT for table `regions`
  --
  ALTER TABLE `regions`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  
  --
  -- AUTO_INCREMENT for table `users`
  --
  ALTER TABLE `users`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- Constraints for dumped tables
  --
  
  --
  -- Constraints for table `colors`
  --
  ALTER TABLE `colors`
    ADD CONSTRAINT `colors_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `features`
  --
  ALTER TABLE `features`
    ADD CONSTRAINT `features_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `networks`
  --
  ALTER TABLE `networks`
    ADD CONSTRAINT `networks_region_id_foreign` FOREIGN KEY (`region_id`) REFERENCES `regions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
  
  --
  -- Constraints for table `products`
  --
  ALTER TABLE `products`
    ADD CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE ON UPDATE 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 */;
  