grthtrhthjhtyjytjytkergtrhtrjytjerhrfh4:24 29/09/2026/* Navicat Premium Data Transfer Source Server : localhost Source Server Type : MySQL Source Server Version : 100411 Source Host : localhost:3306 Source Schema : brand Target Server Type : MySQL Target Server Version : 100411 File Encoding : 65001 Date: 26/05/2020 17:08:29 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for auth_activation_attempts -- ---------------------------- DROP TABLE IF EXISTS `auth_activation_attempts`; CREATE TABLE `auth_activation_attempts` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `ip_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `user_agent` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `token` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `created_at` datetime(0) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of auth_activation_attempts -- ---------------------------- -- ---------------------------- -- Table structure for auth_groups -- ---------------------------- DROP TABLE IF EXISTS `auth_groups`; CREATE TABLE `auth_groups` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of auth_groups -- ---------------------------- INSERT INTO `auth_groups` VALUES (1, 'site', 'سایت'); INSERT INTO `auth_groups` VALUES (2, 'brand', 'برند'); INSERT INTO `auth_groups` VALUES (3, 'station', 'جایگاه دار'); -- ---------------------------- -- Table structure for auth_groups_permissions -- ---------------------------- DROP TABLE IF EXISTS `auth_groups_permissions`; CREATE TABLE `auth_groups_permissions` ( `group_id` int(11) UNSIGNED NOT NULL DEFAULT 0, `permission_id` int(11) UNSIGNED NOT NULL DEFAULT 0, INDEX `auth_groups_permissions_permission_id_foreign`(`permission_id`) USING BTREE, INDEX `group_id_permission_id`(`group_id`, `permission_id`) USING BTREE, CONSTRAINT `auth_groups_permissions_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `auth_groups` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `auth_groups_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `auth_permissions` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of auth_groups_permissions -- ---------------------------- -- ---------------------------- -- Table structure for auth_groups_users -- ---------------------------- DROP TABLE IF EXISTS `auth_groups_users`; CREATE TABLE `auth_groups_users` ( `group_id` int(11) UNSIGNED NOT NULL DEFAULT 0, `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0, INDEX `auth_groups_users_user_id_foreign`(`user_id`) USING BTREE, INDEX `group_id_user_id`(`group_id`, `user_id`) USING BTREE, CONSTRAINT `auth_groups_users_group_id_foreign` FOREIGN KEY (`group_id`) REFERENCES `auth_groups` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `auth_groups_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of auth_groups_users -- ---------------------------- -- ---------------------------- -- Table structure for auth_logins -- ---------------------------- DROP TABLE IF EXISTS `auth_logins`; CREATE TABLE `auth_logins` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `ip_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `user_id` int(11) UNSIGNED NULL DEFAULT NULL, `date` datetime(0) NOT NULL, `success` tinyint(1) NOT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `email`(`email`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of auth_logins -- ---------------------------- INSERT INTO `auth_logins` VALUES (1, '127.0.0.1', 'zomorrodcgs@gmail.com', 1, '2020-05-11 17:59:50', 1); INSERT INTO `auth_logins` VALUES (2, '127.0.0.1', 'zomorrodcgs@gmail.com', 1, '2020-05-13 11:54:50', 1); INSERT INTO `auth_logins` VALUES (3, '127.0.0.1', 'zomorrodcgs@gmail.com', 1, '2020-05-13 13:26:23', 1); INSERT INTO `auth_logins` VALUES (4, '127.0.0.1', 'zomorrodcgs.com', NULL, '2020-05-13 13:27:48', 0); INSERT INTO `auth_logins` VALUES (5, '127.0.0.1', 'zomorrodcgs@gmail.com', 1, '2020-05-13 15:19:09', 1); INSERT INTO `auth_logins` VALUES (6, '127.0.0.1', 'zomorrodcgs@gmail.com', 1, '2020-05-13 15:24:53', 1); INSERT INTO `auth_logins` VALUES (7, '127.0.0.1', 'admin@gctest.ir', 2, '2020-05-13 15:57:02', 1); INSERT INTO `auth_logins` VALUES (8, '127.0.0.1', 'ghjgh', NULL, '2020-05-13 16:17:17', 0); INSERT INTO `auth_logins` VALUES (9, '94.183.251.193', 'admin', NULL, '2020-05-13 16:49:38', 0); INSERT INTO `auth_logins` VALUES (10, '94.183.251.193', 'admin@gctest.ir', 2, '2020-05-13 16:49:56', 1); INSERT INTO `auth_logins` VALUES (11, '198.143.178.116', 'admin@gctest.ir', 2, '2020-05-13 17:09:41', 1); INSERT INTO `auth_logins` VALUES (12, '5.126.237.110', 'admin@gctest.ir', 2, '2020-05-13 22:56:41', 1); INSERT INTO `auth_logins` VALUES (13, '94.183.251.193', 'admin@gctest.ir', 2, '2020-05-14 10:59:13', 1); INSERT INTO `auth_logins` VALUES (14, '2.180.3.203', 'admin@gctest.ir', 2, '2020-05-14 12:27:57', 1); INSERT INTO `auth_logins` VALUES (15, '94.183.251.193', 'admin@gctest.ir', 2, '2020-05-14 15:29:31', 1); INSERT INTO `auth_logins` VALUES (16, '2.180.25.16', 'admin@gctest.ir', 2, '2020-05-14 20:32:36', 1); INSERT INTO `auth_logins` VALUES (17, '5.126.215.175', 'admin@gctest.ir', 2, '2020-05-16 16:49:38', 1); INSERT INTO `auth_logins` VALUES (18, '94.183.251.193', 'admin@gctest.ir', 2, '2020-05-18 11:18:12', 1); INSERT INTO `auth_logins` VALUES (19, '94.183.251.193', 'admin@gctest.ir', 2, '2020-05-19 11:27:20', 1); INSERT INTO `auth_logins` VALUES (20, '94.183.251.193', 'admin@gctest.ir', 2, '2020-05-19 15:17:32', 1); INSERT INTO `auth_logins` VALUES (21, '94.183.251.193', 'admin@gctest.ir', 2, '2020-05-20 14:45:40', 1); INSERT INTO `auth_logins` VALUES (22, '94.183.251.193', 'admin@gctest.ir', 1, '2020-05-23 11:27:50', 1); INSERT INTO `auth_logins` VALUES (23, '94.183.251.193', 'admin@gctest.ir', 1, '2020-05-23 11:29:43', 1); INSERT INTO `auth_logins` VALUES (24, '127.0.0.1', 'admin@gctest.ir', 1, '2020-05-26 09:51:18', 1); INSERT INTO `auth_logins` VALUES (25, '127.0.0.1', 'test 1', NULL, '2020-05-26 10:26:45', 0); INSERT INTO `auth_logins` VALUES (26, '127.0.0.1', 'test1', NULL, '2020-05-26 10:26:55', 0); INSERT INTO `auth_logins` VALUES (27, '127.0.0.1', 'test1', NULL, '2020-05-26 10:27:29', 0); -- ---------------------------- -- Table structure for auth_permissions -- ---------------------------- DROP TABLE IF EXISTS `auth_permissions`; CREATE TABLE `auth_permissions` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of auth_permissions -- ---------------------------- -- ---------------------------- -- Table structure for auth_reset_attempts -- ---------------------------- DROP TABLE IF EXISTS `auth_reset_attempts`; CREATE TABLE `auth_reset_attempts` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ip_address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `user_agent` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `token` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `created_at` datetime(0) NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of auth_reset_attempts -- ---------------------------- -- ---------------------------- -- Table structure for auth_tokens -- ---------------------------- DROP TABLE IF EXISTS `auth_tokens`; CREATE TABLE `auth_tokens` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `selector` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `hashedValidator` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `user_id` int(11) UNSIGNED NOT NULL, `expires` datetime(0) NOT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `auth_tokens_user_id_foreign`(`user_id`) USING BTREE, INDEX `selector`(`selector`) USING BTREE, CONSTRAINT `auth_tokens_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of auth_tokens -- ---------------------------- -- ---------------------------- -- Table structure for auth_users_permissions -- ---------------------------- DROP TABLE IF EXISTS `auth_users_permissions`; CREATE TABLE `auth_users_permissions` ( `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0, `permission_id` int(11) UNSIGNED NOT NULL DEFAULT 0, INDEX `auth_users_permissions_permission_id_foreign`(`permission_id`) USING BTREE, INDEX `user_id_permission_id`(`user_id`, `permission_id`) USING BTREE, CONSTRAINT `auth_users_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `auth_permissions` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `auth_users_permissions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of auth_users_permissions -- ---------------------------- -- ---------------------------- -- Table structure for migrations -- ---------------------------- DROP TABLE IF EXISTS `migrations`; CREATE TABLE `migrations` ( `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, `version` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `class` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `group` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `namespace` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `time` int(11) NOT NULL, `batch` int(11) UNSIGNED NOT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of migrations -- ---------------------------- INSERT INTO `migrations` VALUES (1, '2017-11-20-223112', 'Myth\\Auth\\Database\\Migrations\\CreateAuthTables', 'default', 'Myth\\Auth', 1589201804, 1); -- ---------------------------- -- Table structure for product_capacities -- ---------------------------- DROP TABLE IF EXISTS `product_capacities`; CREATE TABLE `product_capacities` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `product_id` int(10) UNSIGNED NULL DEFAULT NULL, `volume` int(255) UNSIGNED NULL DEFAULT NULL, `status` enum('active','inactive','deleted') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'active', `created_at` datetime(0) NOT NULL DEFAULT current_timestamp(0), `updated_at` datetime(0) NOT NULL DEFAULT current_timestamp(0) ON UPDATE CURRENT_TIMESTAMP(0), `deleted_at` datetime(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `product_id`(`product_id`) USING BTREE, CONSTRAINT `product_capacities_ibfk_1` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE = InnoDB AUTO_INCREMENT = 39 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of product_capacities -- ---------------------------- INSERT INTO `product_capacities` VALUES (1, 1, 6000, 'active', '2020-05-23 14:44:46', '2020-05-23 14:44:46', NULL); INSERT INTO `product_capacities` VALUES (2, 1, 14000, 'active', '2020-05-23 14:44:46', '2020-05-23 14:44:46', NULL); INSERT INTO `product_capacities` VALUES (3, 1, 18200, 'active', '2020-05-23 14:44:46', '2020-05-23 14:44:46', NULL); INSERT INTO `product_capacities` VALUES (4, 1, 19300, 'active', '2020-05-23 14:44:46', '2020-05-23 14:44:46', NULL); INSERT INTO `product_capacities` VALUES (5, 1, 19700, 'active', '2020-05-23 14:44:46', '2020-05-23 14:44:46', NULL); INSERT INTO `product_capacities` VALUES (6, 1, 20000, 'active', '2020-05-23 14:44:46', '2020-05-23 14:44:46', NULL); INSERT INTO `product_capacities` VALUES (7, 1, 30200, 'active', '2020-05-23 14:44:46', '2020-05-23 14:44:46', NULL); INSERT INTO `product_capacities` VALUES (8, 1, 30300, 'active', '2020-05-23 14:44:46', '2020-05-23 14:44:46', NULL); INSERT INTO `product_capacities` VALUES (9, 1, 30400, 'active', '2020-05-23 14:44:46', '2020-05-23 14:44:46', NULL); INSERT INTO `product_capacities` VALUES (10, 1, 32000, 'active', '2020-05-23 14:44:46', '2020-05-23 14:44:46', NULL); INSERT INTO `product_capacities` VALUES (11, 1, 32200, 'active', '2020-05-23 14:44:46', '2020-05-23 14:44:46', NULL); INSERT INTO `product_capacities` VALUES (12, 3, 6000, 'active', '2020-05-23 14:44:46', '2020-05-23 14:44:46', NULL); INSERT INTO `product_capacities` VALUES (13, 3, 14000, 'active', '2020-05-23 14:44:46', '2020-05-23 14:44:46', NULL); INSERT INTO `product_capacities` VALUES (14, 3, 18200, 'active', '2020-05-23 14:44:46', '2020-05-23 14:44:46', NULL); INSERT INTO `product_capacities` VALUES (15, 3, 19300, 'active', '2020-05-23 14:44:46', '2020-05-23 14:44:46', NULL); INSERT INTO `product_capacities` VALUES (16, 3, 19700, 'active', '2020-05-23 14:44:46', '2020-05-23 14:44:46', NULL); INSERT INTO `product_capacities` VALUES (17, 3, 20000, 'active', '2020-05-23 14:44:46', '2020-05-23 14:44:46', NULL); INSERT INTO `product_capacities` VALUES (18, 3, 30200, 'active', '2020-05-23 14:44:46', '2020-05-23 14:44:46', NULL); INSERT INTO `product_capacities` VALUES (19, 3, 30300, 'active', '2020-05-23 14:44:46', '2020-05-23 14:44:46', NULL); INSERT INTO `product_capacities` VALUES (20, 3, 30400, 'active', '2020-05-23 14:44:46', '2020-05-23 14:44:46', NULL); INSERT INTO `product_capacities` VALUES (21, 3, 32000, 'active', '2020-05-23 14:44:46', '2020-05-23 14:44:46', NULL); INSERT INTO `product_capacities` VALUES (22, 3, 32200, 'active', '2020-05-23 14:44:46', '2020-05-23 14:44:46', NULL); INSERT INTO `product_capacities` VALUES (23, 2, 20000, 'active', '2020-05-23 14:44:46', '2020-05-23 14:44:46', NULL); INSERT INTO `product_capacities` VALUES (24, 2, 30400, 'active', '2020-05-23 14:51:26', '2020-05-23 14:51:26', NULL); INSERT INTO `product_capacities` VALUES (25, 2, 32000, 'active', '2020-05-23 14:51:40', '2020-05-23 14:51:40', NULL); INSERT INTO `product_capacities` VALUES (26, 2, 32200, 'active', '2020-05-23 14:51:48', '2020-05-23 14:51:48', NULL); INSERT INTO `product_capacities` VALUES (27, 4, 29000, 'active', '2020-05-23 14:52:26', '2020-05-23 14:52:26', NULL); INSERT INTO `product_capacities` VALUES (28, 4, 30000, 'active', '2020-05-23 14:52:31', '2020-05-23 14:52:31', NULL); INSERT INTO `product_capacities` VALUES (29, 4, 30400, 'active', '2020-05-23 14:52:43', '2020-05-23 14:52:43', NULL); INSERT INTO `product_capacities` VALUES (30, 4, 31000, 'active', '2020-05-23 14:52:48', '2020-05-23 14:52:48', NULL); INSERT INTO `product_capacities` VALUES (31, 4, 32000, 'active', '2020-05-23 14:52:57', '2020-05-23 14:52:57', NULL); INSERT INTO `product_capacities` VALUES (32, 4, 32000, 'active', '2020-05-23 14:52:58', '2020-05-23 14:52:58', NULL); INSERT INTO `product_capacities` VALUES (33, 5, 29000, 'active', '2020-05-23 14:52:26', '2020-05-23 14:52:26', NULL); INSERT INTO `product_capacities` VALUES (34, 5, 30000, 'active', '2020-05-23 14:52:31', '2020-05-23 14:52:31', NULL); INSERT INTO `product_capacities` VALUES (35, 5, 30400, 'active', '2020-05-23 14:52:43', '2020-05-23 14:52:43', NULL); INSERT INTO `product_capacities` VALUES (36, 5, 31000, 'active', '2020-05-23 14:52:48', '2020-05-23 14:52:48', NULL); INSERT INTO `product_capacities` VALUES (37, 5, 32000, 'active', '2020-05-23 14:52:57', '2020-05-23 14:52:57', NULL); INSERT INTO `product_capacities` VALUES (38, 5, 32000, 'active', '2020-05-23 14:52:58', '2020-05-23 14:52:58', NULL); -- ---------------------------- -- Table structure for products -- ---------------------------- DROP TABLE IF EXISTS `products`; CREATE TABLE `products` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `title` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `status` enum('active','inactive','deleted') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'active', `created_at` datetime(0) NOT NULL DEFAULT current_timestamp(0), `updated_at` datetime(0) NOT NULL DEFAULT current_timestamp(0) ON UPDATE CURRENT_TIMESTAMP(0), `deleted_at` datetime(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of products -- ---------------------------- INSERT INTO `products` VALUES (1, 'regular', 'بنزین معمولی', 'active', '2020-05-18 13:22:27', '2020-05-20 14:17:23', NULL); INSERT INTO `products` VALUES (2, 'super', 'بنزین سوپر', 'active', '2020-05-18 13:22:27', '2020-05-20 14:17:30', NULL); INSERT INTO `products` VALUES (3, 'euro', 'بنزین یورو', 'active', '2020-05-18 13:22:27', '2020-05-20 14:17:44', NULL); INSERT INTO `products` VALUES (4, 'gasoline', 'نفت و گاز', 'active', '2020-05-18 18:02:05', '2020-05-23 14:42:21', NULL); INSERT INTO `products` VALUES (5, 'cng', 'CNG', 'active', '2020-05-19 15:26:47', '2020-05-23 14:42:24', NULL); -- ---------------------------- -- Table structure for request_logs -- ---------------------------- DROP TABLE IF EXISTS `request_logs`; CREATE TABLE `request_logs` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `request_id` int(10) UNSIGNED NOT NULL, `description` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `status` enum('in_progress','success','failed','salled','sended') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL, `created_at` datetime(0) NOT NULL DEFAULT current_timestamp(0), `updated_at` datetime(0) NOT NULL DEFAULT current_timestamp(0) ON UPDATE CURRENT_TIMESTAMP(0), `deleted_at` datetime(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `request_id`(`request_id`) USING BTREE, CONSTRAINT `request_logs_ibfk_1` FOREIGN KEY (`request_id`) REFERENCES `requests` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE = InnoDB AUTO_INCREMENT = 56 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of request_logs -- ---------------------------- -- ---------------------------- -- Table structure for requests -- ---------------------------- DROP TABLE IF EXISTS `requests`; CREATE TABLE `requests` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'شماره درخواست', `station_id` int(10) UNSIGNED NOT NULL COMMENT 'جایگاه', `requester_user_id` int(10) UNSIGNED NOT NULL COMMENT 'کاربر سفارش دهنده', `request_count` smallint(6) NULL DEFAULT 1, `product` enum('regular','super','euro','gasoline','cng') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'regular', `request_volume` int(10) UNSIGNED NOT NULL COMMENT 'لیتراژ', `applicant_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'درخواست کننده', `request_date_time` datetime(0) NULL DEFAULT NULL COMMENT 'تاریخ درخواست', `unit_price` float NOT NULL COMMENT 'قیمت واحد', `total_price` char(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'قیمت نهایی', `financial_approval` tinyint(1) NOT NULL COMMENT 'تایید مالی', `tel` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'شماره تماس', `admin_description` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'توضیحات ادمین', `submitted_product` enum('regular','super','euro','gasoline','cng') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'regular' COMMENT 'نوع فرآورده ارسالی', `freight_number` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'شماره بارنامه', `carried_volume` int(11) NOT NULL COMMENT 'میزان حمل شده', `exit_date` datetime(0) NOT NULL COMMENT 'تاریخ خروج نفتکش', `delivery_date_time` datetime(0) NULL DEFAULT NULL COMMENT 'تاریخ و ساعت تحویل', `step4_product` enum('regular','super','euro','gasoline','cng') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'regular' COMMENT 'رسید - نوع سوخت', `step4_volume` int(11) UNSIGNED NOT NULL COMMENT 'رسید - لیتراژ', `step4_freight` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'رسید - بارنامه', `step4_enter_date` datetime(0) NOT NULL COMMENT 'رسید - تاریخ ورود به جایگاه', `step4_freight_temperature` float NOT NULL COMMENT 'رسید - درجه حرارت بارنامه (`f)', `step4_test_temperature` float NOT NULL COMMENT 'درجه حرارت آزمایش (`c)', `step4_freight_weight` float(5, 3) NOT NULL COMMENT 'رسید - وزن مخصوص بارنامه (kg/litr)', `step4_test_weight` float(5, 3) NOT NULL COMMENT 'رسید - وزن مخصوص آزمایش (kg/litr)', `step4_issue_date` date NOT NULL COMMENT 'رسید - تاریخ صدور', `step4_freight_number` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'رسید - شماره بارنامه / حواله ', `step4_origin` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'رسید - مبدا', `step4_contractor` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'رسید - نام پیمانکار', `step4_driver` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'رسید - نام راننده', `step4_tanker_number` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'رسید - شماره نفتکش', `status` enum('in_progress','success','failed','salled','sended') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'in_progress' COMMENT 'آخرین وضعیت', `created_at` datetime(0) NOT NULL DEFAULT current_timestamp(0), `updated_at` datetime(0) NOT NULL DEFAULT current_timestamp(0) ON UPDATE CURRENT_TIMESTAMP(0), `deleted_at` datetime(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `station_id`(`station_id`) USING BTREE, INDEX `user_id`(`requester_user_id`) USING BTREE, CONSTRAINT `requests_ibfk_1` FOREIGN KEY (`station_id`) REFERENCES `stations` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `requests_ibfk_2` FOREIGN KEY (`requester_user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE = InnoDB AUTO_INCREMENT = 38 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of requests -- ---------------------------- INSERT INTO `requests` VALUES (30, 1, 2, 1, 'regular', 19700, 'غلامرضا فرهنگ قهرمانی', '2020-05-17 10:01:23', 15000, '295500000', 0, '', '', '', '', 0, '0000-00-00 00:00:00', NULL, 'regular', 0, '', '0000-00-00 00:00:00', 0, 0, 0.000, 0.000, '0000-00-00', '', '', '', '', '', 'in_progress', '2020-05-26 10:15:56', '2020-05-26 10:37:29', NULL); INSERT INTO `requests` VALUES (31, 1, 2, 3, 'super', 30400, 'غلامرضا رحمان رحیمی', '2020-05-22 10:01:23', 15000, '‭1064000000‬', 0, '', '', '', '', 0, '0000-00-00 00:00:00', NULL, 'regular', 0, '', '0000-00-00 00:00:00', 0, 0, 0.000, 0.000, '0000-00-00', '', '', '', '', '', 'in_progress', '2020-05-26 10:15:56', '2020-05-26 10:44:59', NULL); INSERT INTO `requests` VALUES (34, 1, 2, 3, 'super', 30400, 'غلامرضا رحمان رحیمی', '2020-05-22 10:01:23', 15000, '‭1064000000‬', 0, '', '', '', '', 0, '0000-00-00 00:00:00', NULL, 'regular', 0, '', '0000-00-00 00:00:00', 0, 0, 0.000, 0.000, '0000-00-00', '', '', '', '', '', 'in_progress', '2020-05-26 10:15:56', '2020-05-26 10:44:59', NULL); INSERT INTO `requests` VALUES (35, 1, 2, 3, 'super', 30400, 'غلامرضا رحمان رحیمی', '2020-05-22 10:01:23', 15000, '‭1064000000‬', 0, '', '', '', '', 0, '0000-00-00 00:00:00', NULL, 'regular', 0, '', '0000-00-00 00:00:00', 0, 0, 0.000, 0.000, '0000-00-00', '', '', '', '', '', 'in_progress', '2020-05-26 10:15:56', '2020-05-26 10:44:59', NULL); INSERT INTO `requests` VALUES (36, 1, 2, 2, 'euro', 19300, 'غلامعلی رحیمی', '2020-05-26 10:01:23', 15000, '289500000', 0, '', '', '', '', 0, '0000-00-00 00:00:00', NULL, 'regular', 0, '', '0000-00-00 00:00:00', 0, 0, 0.000, 0.000, '0000-00-00', '', '', '', '', '', 'in_progress', '2020-05-26 10:15:56', '2020-05-26 10:45:49', NULL); INSERT INTO `requests` VALUES (37, 1, 2, 1, 'gasoline', 30000, 'غلامعلی رحیمی', '2020-05-26 10:01:23', 15000, '180000000', 0, '', '', '', '', 0, '0000-00-00 00:00:00', NULL, 'regular', 0, '', '0000-00-00 00:00:00', 0, 0, 0.000, 0.000, '0000-00-00', '', '', '', '', '', 'in_progress', '2020-05-26 10:15:56', '2020-05-26 10:45:52', NULL); -- ---------------------------- -- Table structure for station_balances -- ---------------------------- DROP TABLE IF EXISTS `station_balances`; CREATE TABLE `station_balances` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `station_id` int(10) UNSIGNED NULL DEFAULT NULL, `product` enum('regular','super','euro','gasoline','cng') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'regular', `price_1` double NULL DEFAULT NULL, `price_2` double NULL DEFAULT NULL, `price_3` double NULL DEFAULT NULL, `price_4` double NULL DEFAULT NULL, `status` enum('active','inactive','deleted') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'active', `created_at` datetime(0) NOT NULL DEFAULT current_timestamp(0), `updated_at` datetime(0) NOT NULL DEFAULT current_timestamp(0) ON UPDATE CURRENT_TIMESTAMP(0), `deleted_at` datetime(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `station_id`(`station_id`) USING BTREE, CONSTRAINT `station_balances_ibfk_1` FOREIGN KEY (`station_id`) REFERENCES `stations` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of station_balances -- ---------------------------- INSERT INTO `station_balances` VALUES (1, 1, 'regular', 15000, 14500, 13500, 12500, 'active', '2020-05-19 16:39:36', '2020-05-19 16:39:36', NULL); INSERT INTO `station_balances` VALUES (2, 1, 'super', 35000, 34500, 33500, 32500, 'active', '2020-05-19 16:39:36', '2020-05-19 16:39:36', NULL); INSERT INTO `station_balances` VALUES (3, 1, 'euro', 15000, 14750, 13750, 12750, 'active', '2020-05-19 16:39:36', '2020-05-19 16:39:36', NULL); -- ---------------------------- -- Table structure for station_fees -- ---------------------------- DROP TABLE IF EXISTS `station_fees`; CREATE TABLE `station_fees` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `station_id` int(10) UNSIGNED NULL DEFAULT NULL, `product` enum('regular','super','euro','gasoline','cng') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'regular', `sell_rate` double NULL DEFAULT NULL, `fee` double NULL DEFAULT NULL, `status` enum('active','inactive','deleted') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'active', `created_at` datetime(0) NOT NULL DEFAULT current_timestamp(0), `updated_at` datetime(0) NOT NULL DEFAULT current_timestamp(0) ON UPDATE CURRENT_TIMESTAMP(0), `deleted_at` datetime(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `station_id`(`station_id`) USING BTREE, CONSTRAINT `station_fees_ibfk_1` FOREIGN KEY (`station_id`) REFERENCES `stations` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of station_fees -- ---------------------------- INSERT INTO `station_fees` VALUES (1, 1, 'regular', 15000, 14500, 'active', '2020-05-19 16:39:28', '2020-05-19 16:39:28', NULL); INSERT INTO `station_fees` VALUES (2, 1, 'super', 35000, 34500, 'active', '2020-05-19 16:39:28', '2020-05-19 16:39:28', NULL); INSERT INTO `station_fees` VALUES (3, 1, 'euro', 15000, 14750, 'active', '2020-05-19 16:39:28', '2020-05-19 16:39:28', NULL); INSERT INTO `station_fees` VALUES (4, 1, 'gasoline', 6000, 5500, 'active', '2020-05-19 16:39:28', '2020-05-19 16:39:28', NULL); INSERT INTO `station_fees` VALUES (5, 1, 'cng', 8000, 7500, 'active', '2020-05-19 16:39:28', '2020-05-19 16:39:28', NULL); -- ---------------------------- -- Table structure for stations -- ---------------------------- DROP TABLE IF EXISTS `stations`; CREATE TABLE `stations` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `brand_user_id` int(10) UNSIGNED NULL DEFAULT NULL, `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `code` int(11) NULL DEFAULT NULL, `gsid` smallint(4) NULL DEFAULT NULL, `zone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `area` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `degree` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `owner_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `owner_mobile` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `tel` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `address` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `first_operator_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `first_operator_mobile` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `second_operator_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `second_operator_mobile` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `lat` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `lng` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `platforms` int(11) NULL DEFAULT NULL, `station_area` double NULL DEFAULT NULL, `construction_year` smallint(6) NULL DEFAULT NULL, `dispensers` smallint(6) NULL DEFAULT NULL, `store_distance` double NULL DEFAULT NULL, `regular_nozzle` smallint(6) NULL DEFAULT NULL, `super_nozzle` smallint(6) NULL DEFAULT NULL, `euro_nozzle` smallint(6) NULL DEFAULT NULL, `gasoline_nozzle` smallint(6) NULL DEFAULT NULL, `cng_nozzle` smallint(6) NULL DEFAULT NULL, `wind_setting` tinyint(4) NULL DEFAULT 0, `oil_change` tinyint(4) NULL DEFAULT 0, `store` tinyint(4) NULL DEFAULT 0, `cold_water` tinyint(4) NULL DEFAULT 0, `fee_payment_period` smallint(6) NULL DEFAULT 1 COMMENT 'daily', `financial_credit` double NULL DEFAULT 0, `time_credit` smallint(6) NULL DEFAULT 0, `product_deposit_id` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, `balance_deposit_id` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, `status` enum('active','inactive','deleted') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'active', `created_at` datetime(0) NOT NULL DEFAULT current_timestamp(0), `updated_at` datetime(0) NOT NULL DEFAULT current_timestamp(0) ON UPDATE CURRENT_TIMESTAMP(0), `deleted_at` datetime(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `brand_user_id`(`brand_user_id`) USING BTREE, CONSTRAINT `stations_ibfk_1` FOREIGN KEY (`brand_user_id`) REFERENCES `users` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of stations -- ---------------------------- INSERT INTO `stations` VALUES (1, 1, 'تست اول', 24, 5175, 'هشتم', 'پنج', 'ب', 'تست تستی', '09123456789', '05123456789', 'مشهد-بلوار تستی ها', 'اپراتور اول تست اول', '09123456789', 'اپراتور دوم تست اول', '09123456789', '1251421.21', '5214125.21', 5, 1486, 1380, 4, 115, 2, 2, 1, 0, 0, 0, 0, 0, 0, 1, 1000000, 1, 'Ks147845', 'Jf14215', 'active', '2020-05-17 11:31:08', '2020-05-21 11:32:50', NULL); INSERT INTO `stations` VALUES (2, 1, 'تست دوم', 45, 4175, 'هشتم', 'دو', 'الف', 'تست تستی زاده', '09123456714', '05123456714', 'مشهد-بلوار تست زاده', 'اپراتور اول تست دوم', '09123456789', 'اپراتور دوم تست دوم', '09123456789', '1251421.21', '5214125.21', 7, 1542, 1382, 6, 110, 3, 3, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 'Ks147845', 'Jf14215', 'active', '2020-05-17 11:31:08', '2020-05-21 11:32:50', NULL); INSERT INTO `stations` VALUES (3, 1, 'تست سوم', 15, 8541, 'نهم', 'چهار', 'ج', 'تست تستی نیا', '09123456771', '05123456771', 'مشهد-بلوار تستی آباد', 'اپراتور اول تست سوم', '09123456789', 'اپراتور دوم تست سوم', '09123456789', '1251421.21', '5214125.21', 8, 1752, 1374, 10, 117, 4, 3, 1, 0, 0, 0, 1, 1, 0, 1, 0, 0, 'Ks147845', 'Jf14215', 'active', '2020-05-17 11:31:08', '2020-05-21 11:32:50', NULL); INSERT INTO `stations` VALUES (4, 1, 'تست چهارم', 98, 9542, 'نهم', 'پنج', 'الف', 'تست تستی وردی', '09123456725', '05123456725', 'مشهد-بلوار تست نسب', 'اپراتور اول تست چهارم', '09123456789', 'اپراتور دوم تست چهارم', '09123456789', '1251421.21', '5214125.21', 2, 1100, 1390, 2, 54, 2, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 'Ks147845', 'Jf14215', 'active', '2020-05-17 11:31:08', '2020-05-21 11:32:50', NULL); INSERT INTO `stations` VALUES (5, 1, 'تست پنجم', 42, 3625, 'هشتم', 'سه', 'ب', 'تست تستانی', '09123456736', '0512345678936', 'مشهد-بلوار تست یار', 'اپراتور اول تست پنجم', '09123456789', 'اپراتور دوم تست پنجم', '09123456789', '1251421.21', '5214125.21', 4, 1342, 1385, 3, 114, 2, 2, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 'Ks147845', 'Jf14215', 'active', '2020-05-17 11:31:08', '2020-05-21 11:32:50', NULL); INSERT INTO `stations` VALUES (6, 1, 'تست ششم', 62, 7485, 'نهم', 'یک', 'الف', 'تست تست نسب', '09123456754', '05123456754', 'مشهد-بلوار تست', 'اپراتور اول تست ششم', '09123456789', 'اپراتور دوم تست ششم', '09123456789', '1251421.21', '5214125.21', 9, 2145, 1360, 12, 150, 4, 3, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 'Ks147845', 'Jf14215', 'active', '2020-05-17 11:31:08', '2020-05-21 11:32:50', NULL); -- ---------------------------- -- Table structure for tanks -- ---------------------------- DROP TABLE IF EXISTS `tanks`; CREATE TABLE `tanks` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `station_id` int(10) UNSIGNED NULL DEFAULT NULL, `tank_number` int(11) NULL DEFAULT NULL, `product` enum('regular','super','euro','gasoline','cng') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'regular', `tank_volume` int(11) NULL DEFAULT NULL, `status` enum('active','inactive','deleted') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'active', `created_at` datetime(0) NOT NULL DEFAULT current_timestamp(0), `updated_at` datetime(0) NOT NULL DEFAULT current_timestamp(0) ON UPDATE CURRENT_TIMESTAMP(0), `deleted_at` datetime(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `station_id`(`station_id`) USING BTREE, CONSTRAINT `tanks_ibfk_1` FOREIGN KEY (`station_id`) REFERENCES `stations` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of tanks -- ---------------------------- INSERT INTO `tanks` VALUES (1, 1, 150, 'regular', 1500, 'active', '2020-05-18 13:22:27', '2020-05-18 17:57:31', NULL); INSERT INTO `tanks` VALUES (2, 1, 124, 'regular', 1800, 'active', '2020-05-18 13:22:27', '2020-05-19 15:24:22', NULL); INSERT INTO `tanks` VALUES (3, 1, 48, 'regular', 1100, 'active', '2020-05-18 13:22:27', '2020-05-19 15:24:35', NULL); INSERT INTO `tanks` VALUES (8, 1, 145, 'regular', 1400, 'active', '2020-05-18 18:02:05', '2020-05-19 15:24:53', NULL); INSERT INTO `tanks` VALUES (9, 1, 6, 'cng', 56555, 'active', '2020-05-19 15:26:47', '2020-05-19 15:26:47', NULL); -- ---------------------------- -- Table structure for users -- ---------------------------- DROP TABLE IF EXISTS `users`; CREATE TABLE `users` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `station_id` int(10) UNSIGNED NULL DEFAULT NULL, `email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `username` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `password_hash` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `reset_hash` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `reset_at` datetime(0) NULL DEFAULT NULL, `reset_expires` datetime(0) NULL DEFAULT NULL, `activate_hash` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `status_message` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `active` tinyint(1) NOT NULL DEFAULT 0, `force_pass_reset` tinyint(1) NOT NULL DEFAULT 0, `created_at` datetime(0) NULL DEFAULT NULL, `updated_at` datetime(0) NULL DEFAULT NULL, `deleted_at` datetime(0) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `username`(`username`) USING BTREE, INDEX `users_ibfk_1`(`station_id`) USING BTREE, CONSTRAINT `users_ibfk_1` FOREIGN KEY (`station_id`) REFERENCES `stations` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of users -- ---------------------------- INSERT INTO `users` VALUES (1, NULL, 'admin@gctest.ir', 'admin', '$2y$10$mqUdvb/MVCXNmTFElaJfZ.p50gyF.gqj4MfomugX9ueeK5IJtENGK', NULL, NULL, NULL, NULL, NULL, NULL, 1, 0, '2020-05-13 15:56:07', '2020-05-13 15:56:07', NULL); INSERT INTO `users` VALUES (2, 1, '', 'test1', '$2y$10$mqUdvb/MVCXNmTFElaJfZ.p50gyF.gqj4MfomugX9ueeK5IJtENGK', NULL, NULL, NULL, '', NULL, NULL, 1, 0, '2020-05-11 17:59:24', '2020-05-11 17:59:24', NULL); INSERT INTO `users` VALUES (3, 2, '', 'test2', '$2y$10$5R5WaEyk1KkyiK..L6e1Peoj6D7iao7ylAMJywGAVFJZzGgFlADDW', NULL, NULL, NULL, '', NULL, NULL, 1, 0, '2020-05-11 17:59:24', '2020-05-11 17:59:24', NULL); INSERT INTO `users` VALUES (4, 3, '', 'test3', '$2y$10$5R5WaEyk1KkyiK..L6e1Peoj6D7iao7ylAMJywGAVFJZzGgFlADDW', NULL, NULL, NULL, '', NULL, NULL, 1, 0, '2020-05-11 17:59:24', '2020-05-11 17:59:24', NULL); INSERT INTO `users` VALUES (5, 4, '', 'test4', '$2y$10$5R5WaEyk1KkyiK..L6e1Peoj6D7iao7ylAMJywGAVFJZzGgFlADDW', NULL, NULL, NULL, '', NULL, NULL, 1, 0, '2020-05-11 17:59:24', '2020-05-11 17:59:24', NULL); INSERT INTO `users` VALUES (6, 5, '', 'test5', '$2y$10$5R5WaEyk1KkyiK..L6e1Peoj6D7iao7ylAMJywGAVFJZzGgFlADDW', NULL, NULL, NULL, '', NULL, NULL, 1, 0, '2020-05-11 17:59:24', '2020-05-11 17:59:24', NULL); INSERT INTO `users` VALUES (7, 6, '', 'test6', '$2y$10$5R5WaEyk1KkyiK..L6e1Peoj6D7iao7ylAMJywGAVFJZzGgFlADDW', NULL, NULL, NULL, '', NULL, NULL, 1, 0, '2020-05-11 17:59:24', '2020-05-11 17:59:24', NULL); SET FOREIGN_KEY_CHECKS = 1;