text: /*
   Navicat Premium Data Transfer
  
   Source Server         : Local MySQL
   Source Server Type    : MySQL
   Source Server Version : 100417
   Source Host           : localhost:3306
   Source Schema         : store
  
   Target Server Type    : MySQL
   Target Server Version : 100417
   File Encoding         : 65001
  
   Date: 12/10/2021 16:55:29
  */
  
  SET NAMES utf8mb4;
  SET FOREIGN_KEY_CHECKS = 0;
  
  -- ----------------------------
  -- Table structure for failed_jobs
  -- ----------------------------
  DROP TABLE IF EXISTS `failed_jobs`;
  CREATE TABLE `failed_jobs`  (
    `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    `uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `connection` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `queue` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `exception` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `failed_at` timestamp(0) NOT NULL DEFAULT current_timestamp(0),
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE INDEX `failed_jobs_uuid_unique`(`uuid`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Table structure for migrations
  -- ----------------------------
  DROP TABLE IF EXISTS `migrations`;
  CREATE TABLE `migrations`  (
    `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `batch` int(11) NOT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of migrations
  -- ----------------------------
  INSERT INTO `migrations` VALUES (1, '2014_10_12_000000_create_users_table', 1);
  INSERT INTO `migrations` VALUES (2, '2014_10_12_100000_create_password_resets_table', 1);
  INSERT INTO `migrations` VALUES (3, '2016_06_01_000001_create_oauth_auth_codes_table', 1);
  INSERT INTO `migrations` VALUES (4, '2016_06_01_000002_create_oauth_access_tokens_table', 1);
  INSERT INTO `migrations` VALUES (5, '2016_06_01_000003_create_oauth_refresh_tokens_table', 1);
  INSERT INTO `migrations` VALUES (6, '2016_06_01_000004_create_oauth_clients_table', 1);
  INSERT INTO `migrations` VALUES (7, '2016_06_01_000005_create_oauth_personal_access_clients_table', 1);
  INSERT INTO `migrations` VALUES (8, '2019_08_19_000000_create_failed_jobs_table', 1);
  INSERT INTO `migrations` VALUES (9, '2019_12_14_000001_create_personal_access_tokens_table', 1);
  INSERT INTO `migrations` VALUES (10, '2021_10_12_183043_create_stores_table', 2);
  
  -- ----------------------------
  -- Table structure for oauth_access_tokens
  -- ----------------------------
  DROP TABLE IF EXISTS `oauth_access_tokens`;
  CREATE TABLE `oauth_access_tokens`  (
    `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_id` bigint(20) UNSIGNED NULL DEFAULT NULL,
    `client_id` bigint(20) UNSIGNED NOT NULL,
    `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `scopes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
    `revoked` tinyint(1) NOT NULL,
    `created_at` timestamp(0) NULL DEFAULT NULL,
    `updated_at` timestamp(0) NULL DEFAULT NULL,
    `expires_at` datetime(0) NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `oauth_access_tokens_user_id_index`(`user_id`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of oauth_access_tokens
  -- ----------------------------
  INSERT INTO `oauth_access_tokens` VALUES ('4aba51c6ea0e45ad5f7f1ffc2d867fa89e65961b1b7e4d1243d191576e0d9efe68a2c03178a36dac', 1, 1, 'LaravelPassportRestApiExample', '[]', 0, '2021-10-12 18:49:18', '2021-10-12 18:49:18', '2022-10-12 18:49:18');
  INSERT INTO `oauth_access_tokens` VALUES ('7dbef9c9338eb6cb8141b85a29c52dcd589fa07898268a1e1076570dd62d3426d1cd9798b37d414c', 1, 1, 'LaravelPassportRestApiExample', '[]', 0, '2021-10-12 18:57:17', '2021-10-12 18:57:17', '2022-10-12 18:57:17');
  INSERT INTO `oauth_access_tokens` VALUES ('ee4960d31bf83ef04daa3fc84cda02f42dc5e9d03816768ec94014b95cef7f1807555ecf33dece9b', 1, 1, 'LaravelPassportRestApiExampl', '[]', 0, '2021-10-12 18:48:48', '2021-10-12 18:48:48', '2022-10-12 18:48:48');
  
  -- ----------------------------
  -- Table structure for oauth_auth_codes
  -- ----------------------------
  DROP TABLE IF EXISTS `oauth_auth_codes`;
  CREATE TABLE `oauth_auth_codes`  (
    `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_id` bigint(20) UNSIGNED NOT NULL,
    `client_id` bigint(20) UNSIGNED NOT NULL,
    `scopes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
    `revoked` tinyint(1) NOT NULL,
    `expires_at` datetime(0) NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `oauth_auth_codes_user_id_index`(`user_id`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Table structure for oauth_clients
  -- ----------------------------
  DROP TABLE IF EXISTS `oauth_clients`;
  CREATE TABLE `oauth_clients`  (
    `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    `user_id` bigint(20) UNSIGNED NULL DEFAULT NULL,
    `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `secret` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `provider` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `redirect` text CHARACTER SET utf8mb4 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(0) NULL DEFAULT NULL,
    `updated_at` timestamp(0) NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `oauth_clients_user_id_index`(`user_id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of oauth_clients
  -- ----------------------------
  INSERT INTO `oauth_clients` VALUES (1, NULL, 'Laravel Personal Access Client', 'KjdgBvb9qt1fHK1lJj3HBqm86FCN2nBsOTEmjDlC', NULL, 'http://localhost', 1, 0, 0, '2021-10-12 18:21:44', '2021-10-12 18:21:44');
  INSERT INTO `oauth_clients` VALUES (2, NULL, 'Laravel Password Grant Client', '0tlSkBO1Qvin5gbvCdMbuWnFVbemIcCaoJafMcwR', 'users', 'http://localhost', 0, 1, 0, '2021-10-12 18:21:44', '2021-10-12 18:21:44');
  
  -- ----------------------------
  -- Table structure for oauth_personal_access_clients
  -- ----------------------------
  DROP TABLE IF EXISTS `oauth_personal_access_clients`;
  CREATE TABLE `oauth_personal_access_clients`  (
    `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    `client_id` bigint(20) UNSIGNED NOT NULL,
    `created_at` timestamp(0) NULL DEFAULT NULL,
    `updated_at` timestamp(0) NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of oauth_personal_access_clients
  -- ----------------------------
  INSERT INTO `oauth_personal_access_clients` VALUES (1, 1, '2021-10-12 18:21:44', '2021-10-12 18:21:44');
  
  -- ----------------------------
  -- Table structure for oauth_refresh_tokens
  -- ----------------------------
  DROP TABLE IF EXISTS `oauth_refresh_tokens`;
  CREATE TABLE `oauth_refresh_tokens`  (
    `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `access_token_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `revoked` tinyint(1) NOT NULL,
    `expires_at` datetime(0) NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `oauth_refresh_tokens_access_token_id_index`(`access_token_id`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Table structure for password_resets
  -- ----------------------------
  DROP TABLE IF EXISTS `password_resets`;
  CREATE TABLE `password_resets`  (
    `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp(0) NULL DEFAULT NULL,
    INDEX `password_resets_email_index`(`email`) USING BTREE
  ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Table structure for personal_access_tokens
  -- ----------------------------
  DROP TABLE IF EXISTS `personal_access_tokens`;
  CREATE TABLE `personal_access_tokens`  (
    `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    `tokenable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `tokenable_id` bigint(20) UNSIGNED NOT NULL,
    `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `abilities` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL,
    `last_used_at` timestamp(0) NULL DEFAULT NULL,
    `created_at` timestamp(0) NULL DEFAULT NULL,
    `updated_at` timestamp(0) NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE INDEX `personal_access_tokens_token_unique`(`token`) USING BTREE,
    INDEX `personal_access_tokens_tokenable_type_tokenable_id_index`(`tokenable_type`, `tokenable_id`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Table structure for stores
  -- ----------------------------
  DROP TABLE IF EXISTS `stores`;
  CREATE TABLE `stores`  (
    `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
    `user_id` bigint(20) UNSIGNED NOT NULL,
    `storename` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `storeaddress` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `storephone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `storeemail` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `storelocation` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `storeimage` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp(0) NULL DEFAULT NULL,
    `updated_at` timestamp(0) NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE,
    INDEX `stores_user_id_foreign`(`user_id`) USING BTREE,
    CONSTRAINT `stores_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
  ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of stores
  -- ----------------------------
  INSERT INTO `stores` VALUES (1, 1, 'test', 'test', '1234567', 'test@test.com', 'test', 'test', '2021-10-12 18:58:19', '2021-10-12 18:58:19');
  INSERT INTO `stores` VALUES (3, 1, 'Makro', 'La Urbina', '1234567', 'makro@makro.com', '0987654', 'test/image', '2021-10-12 20:52:15', '2021-10-12 20:52:15');
  
  -- ----------------------------
  -- Table structure for users
  -- ----------------------------
  DROP TABLE IF EXISTS `users`;
  CREATE TABLE `users`  (
    `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `email_verified_at` timestamp(0) NULL DEFAULT NULL,
    `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
    `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL,
    `created_at` timestamp(0) NULL DEFAULT NULL,
    `updated_at` timestamp(0) NULL DEFAULT NULL,
    PRIMARY KEY (`id`) USING BTREE,
    UNIQUE INDEX `users_email_unique`(`email`) USING BTREE
  ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;
  
  -- ----------------------------
  -- Records of users
  -- ----------------------------
  INSERT INTO `users` VALUES (1, 'Alcides', 'linuxionist@gmail.com', NULL, '$2y$10$gK4ljvYiD899G18wtyJN7Otvfr/0O82h2HGHmQ2fVUbyEelAsZ7XK', NULL, '2021-10-12 18:48:48', '2021-10-12 18:48:48');
  
  SET FOREIGN_KEY_CHECKS = 1;
  