grthtrhthjhtyjytjytkergtrhtrjytjerhrfh4:24 29/09/2026/*
 Navicat Premium Data Transfer

 Source Server         : goldenco_brand
 Source Server Type    : MySQL
 Source Server Version : 100322
 Source Host           : goldenco-nezarat.ir:3306
 Source Schema         : goldenco_brand

 Target Server Type    : MySQL
 Target Server Version : 100322
 File Encoding         : 65001

 Date: 19/05/2020 19:20:59
*/

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 = 21 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);

-- ----------------------------
-- 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 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
) ENGINE = MyISAM AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- 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
) ENGINE = MyISAM AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- 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);

-- ----------------------------
-- 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,
  `station_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 `user_id`(`station_user_id`) USING BTREE
) ENGINE = MyISAM AUTO_INCREMENT = 7 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of stations
-- ----------------------------
INSERT INTO `stations` VALUES (6, 2, 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-19 14:41:11', NULL);
INSERT INTO `stations` VALUES (5, 2, 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-19 14:41:11', NULL);
INSERT INTO `stations` VALUES (3, 2, 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-19 14:41:11', NULL);
INSERT INTO `stations` VALUES (4, 2, 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-19 14:41:11', NULL);
INSERT INTO `stations` VALUES (2, 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-19 14:41:11', NULL);
INSERT INTO `stations` VALUES (1, 2, 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-19 15:12:12', 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
) ENGINE = MyISAM AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Fixed;

-- ----------------------------
-- 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,
  `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,
  UNIQUE INDEX `email`(`email`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES (1, 'zomorrodcgs@gmail.com', 'zomorrodcgs', '$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 (2, '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);

SET FOREIGN_KEY_CHECKS = 1;