text: # ************************************************************
  # Sequel Pro SQL dump
  # Version 5446
  #
  # https://www.sequelpro.com/
  # https://github.com/sequelpro/sequelpro
  #
  # Host: 127.0.0.1 (MySQL 8.0.19)
  # Database: mobile_computing
  # Generation Time: 2020-04-26 12:17:32 +0000
  # ************************************************************
  
  
  /*!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 utf8 */;
  SET NAMES utf8mb4;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  
  
  # Dump of table admins
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `admins`;
  
  CREATE TABLE `admins` (
    `id` bigint unsigned NOT NULL AUTO_INCREMENT,
    `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,
    `is_super` tinyint(1) NOT NULL DEFAULT '0',
    `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `admins_email_unique` (`email`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  LOCK TABLES `admins` WRITE;
  /*!40000 ALTER TABLE `admins` DISABLE KEYS */;
  
  INSERT INTO `admins` (`id`, `name`, `email`, `password`, `is_super`, `remember_token`, `created_at`, `updated_at`)
  VALUES
  	(1,'admin','admin@admin.com','$2y$10$3dYRabsWQOEvMAiw90mcSO0FfO6sgjBJyXh63P55PozhhdF4eLMsi',0,NULL,'2020-04-24 06:31:00','2020-04-24 06:31:00');
  
  /*!40000 ALTER TABLE `admins` ENABLE KEYS */;
  UNLOCK TABLES;
  
  
  # Dump of table categories
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `categories`;
  
  CREATE TABLE `categories` (
    `id` bigint unsigned NOT NULL AUTO_INCREMENT,
    `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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  LOCK TABLES `categories` WRITE;
  /*!40000 ALTER TABLE `categories` DISABLE KEYS */;
  
  INSERT INTO `categories` (`id`, `name`, `created_at`, `updated_at`)
  VALUES
  	(2,'Fruit','2020-04-25 09:04:10','2020-04-25 09:04:10'),
  	(3,'Vege','2020-04-26 06:35:04','2020-04-26 06:35:04'),
  	(4,'Meat','2020-04-26 08:30:12','2020-04-26 08:30:12');
  
  /*!40000 ALTER TABLE `categories` ENABLE KEYS */;
  UNLOCK TABLES;
  
  
  # Dump of table category_images
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `category_images`;
  
  CREATE TABLE `category_images` (
    `id` bigint unsigned NOT NULL AUTO_INCREMENT,
    `category_id` bigint NOT NULL,
    `category_image_location` 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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  LOCK TABLES `category_images` WRITE;
  /*!40000 ALTER TABLE `category_images` DISABLE KEYS */;
  
  INSERT INTO `category_images` (`id`, `category_id`, `category_image_location`, `created_at`, `updated_at`)
  VALUES
  	(1,2,'category_images/jpeg_1587889645.jpeg','2020-04-26 08:27:25','2020-04-26 08:27:25'),
  	(2,3,'category_images/jpeg_1587889718.jpeg','2020-04-26 08:28:38','2020-04-26 08:28:38'),
  	(3,4,'category_images/jpeg_1587889942.jpeg','2020-04-26 08:32:22','2020-04-26 08:32:22');
  
  /*!40000 ALTER TABLE `category_images` ENABLE KEYS */;
  UNLOCK TABLES;
  
  
  # Dump of table food_images
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `food_images`;
  
  CREATE TABLE `food_images` (
    `id` bigint unsigned NOT NULL AUTO_INCREMENT,
    `food_id` bigint NOT NULL,
    `food_image_location` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `index_photo` tinyint(1) NOT NULL DEFAULT '0',
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  LOCK TABLES `food_images` WRITE;
  /*!40000 ALTER TABLE `food_images` DISABLE KEYS */;
  
  INSERT INTO `food_images` (`id`, `food_id`, `food_image_location`, `index_photo`, `created_at`, `updated_at`)
  VALUES
  	(1,1,'food_images/png_1587828143.png',0,'2020-04-25 15:22:23','2020-04-25 15:22:23'),
  	(2,2,'food_images/png_1587828189.png',1,'2020-04-25 15:23:09','2020-04-25 15:23:09'),
  	(3,1,'food_images/jpeg_1587893390.jpeg',1,'2020-04-26 09:29:51','2020-04-26 09:29:51');
  
  /*!40000 ALTER TABLE `food_images` ENABLE KEYS */;
  UNLOCK TABLES;
  
  
  # Dump of table foods
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `foods`;
  
  CREATE TABLE `foods` (
    `id` bigint unsigned NOT NULL AUTO_INCREMENT,
    `category_id` bigint NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `price` double(8,2) NOT NULL,
    `weight` double(8,2) NOT NULL,
    `origin_id` bigint NOT NULL,
    `description` mediumtext COLLATE utf8mb4_unicode_ci,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  LOCK TABLES `foods` WRITE;
  /*!40000 ALTER TABLE `foods` DISABLE KEYS */;
  
  INSERT INTO `foods` (`id`, `category_id`, `name`, `price`, `weight`, `origin_id`, `description`, `created_at`, `updated_at`)
  VALUES
  	(1,2,'Orange',5.00,100.00,1,NULL,'2020-04-25 10:01:55','2020-04-25 10:01:55'),
  	(2,2,'Apple',4.00,100.00,1,NULL,'2020-04-25 10:02:31','2020-04-25 10:02:31');
  
  /*!40000 ALTER TABLE `foods` ENABLE KEYS */;
  UNLOCK TABLES;
  
  
  # Dump of table oauth_access_tokens
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `oauth_access_tokens`;
  
  CREATE TABLE `oauth_access_tokens` (
    `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_id` bigint unsigned DEFAULT NULL,
    `client_id` bigint unsigned NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `scopes` text COLLATE utf8mb4_unicode_ci,
    `revoked` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `expires_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `oauth_access_tokens_user_id_index` (`user_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  
  
  # Dump of table oauth_auth_codes
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `oauth_auth_codes`;
  
  CREATE TABLE `oauth_auth_codes` (
    `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_id` bigint unsigned NOT NULL,
    `client_id` bigint unsigned NOT NULL,
    `scopes` text COLLATE utf8mb4_unicode_ci,
    `revoked` tinyint(1) NOT NULL,
    `expires_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `oauth_auth_codes_user_id_index` (`user_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  
  
  # Dump of table oauth_clients
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `oauth_clients`;
  
  CREATE TABLE `oauth_clients` (
    `id` bigint unsigned NOT NULL AUTO_INCREMENT,
    `user_id` bigint unsigned DEFAULT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `secret` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `redirect` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `personal_access_client` tinyint(1) NOT NULL,
    `password_client` tinyint(1) NOT NULL,
    `revoked` tinyint(1) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `oauth_clients_user_id_index` (`user_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  LOCK TABLES `oauth_clients` WRITE;
  /*!40000 ALTER TABLE `oauth_clients` DISABLE KEYS */;
  
  INSERT INTO `oauth_clients` (`id`, `user_id`, `name`, `secret`, `redirect`, `personal_access_client`, `password_client`, `revoked`, `created_at`, `updated_at`)
  VALUES
  	(1,NULL,'Laravel Personal Access Client','KCeF4yHnArGe1K53wsO7C5sTzNE1684Oe4Z4g8PC','http://localhost',1,0,0,'2020-04-24 06:10:32','2020-04-24 06:10:32'),
  	(2,NULL,'Laravel Password Grant Client','nvupHzBazpj6qjX8opmtOhzFZUIj7vCer2jkBPHj','http://localhost',0,1,0,'2020-04-24 06:10:32','2020-04-24 06:10:32');
  
  /*!40000 ALTER TABLE `oauth_clients` ENABLE KEYS */;
  UNLOCK TABLES;
  
  
  # Dump of table oauth_personal_access_clients
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `oauth_personal_access_clients`;
  
  CREATE TABLE `oauth_personal_access_clients` (
    `id` bigint unsigned NOT NULL AUTO_INCREMENT,
    `client_id` bigint unsigned 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;
  
  LOCK TABLES `oauth_personal_access_clients` WRITE;
  /*!40000 ALTER TABLE `oauth_personal_access_clients` DISABLE KEYS */;
  
  INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`)
  VALUES
  	(1,1,'2020-04-24 06:10:32','2020-04-24 06:10:32');
  
  /*!40000 ALTER TABLE `oauth_personal_access_clients` ENABLE KEYS */;
  UNLOCK TABLES;
  
  
  # Dump of table oauth_refresh_tokens
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `oauth_refresh_tokens`;
  
  CREATE TABLE `oauth_refresh_tokens` (
    `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `access_token_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `revoked` tinyint(1) NOT NULL,
    `expires_at` datetime DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  
  
  # Dump of table orders
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `orders`;
  
  CREATE TABLE `orders` (
    `id` bigint unsigned NOT NULL AUTO_INCREMENT,
    `items` json NOT NULL,
    `user_id` bigint NOT NULL,
    `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `delivery_time` timestamp 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;
  
  
  
  # Dump of table origins
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `origins`;
  
  CREATE TABLE `origins` (
    `id` bigint unsigned NOT NULL AUTO_INCREMENT,
    `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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  LOCK TABLES `origins` WRITE;
  /*!40000 ALTER TABLE `origins` DISABLE KEYS */;
  
  INSERT INTO `origins` (`id`, `name`, `created_at`, `updated_at`)
  VALUES
  	(1,'United States','2020-04-25 10:01:55','2020-04-25 10:01:55');
  
  /*!40000 ALTER TABLE `origins` ENABLE KEYS */;
  UNLOCK TABLES;
  
  
  # Dump of table recipes
  # ------------------------------------------------------------
  
  DROP TABLE IF EXISTS `recipes`;
  
  CREATE TABLE `recipes` (
    `id` bigint unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `ingredient` json NOT NULL,
    `difficulty` int NOT NULL,
    `time_require` double(8,2) NOT NULL,
    `calories` double(8,2) NOT NULL,
    `method` mediumtext 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;
  
  
  
  
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!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 */;
  