grthtrhthjhtyjytjytkergtrhtrjytjerhrfh4:24 29/09/2026/* Navicat Premium Data Transfer Source Server : goldenco_brand Source Server Type : MySQL Source Server Version : 100322 Source Host : gctest.ir:3306 Source Schema : goldenco_brand Target Server Type : MySQL Target Server Version : 100322 File Encoding : 65001 Date: 26/07/2020 09:23:49 */ 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 -- ---------------------------- INSERT INTO `auth_groups_users` VALUES (1, 1); INSERT INTO `auth_groups_users` VALUES (2, 8); INSERT INTO `auth_groups_users` VALUES (3, 2); INSERT INTO `auth_groups_users` VALUES (3, 3); INSERT INTO `auth_groups_users` VALUES (3, 4); INSERT INTO `auth_groups_users` VALUES (3, 5); INSERT INTO `auth_groups_users` VALUES (3, 6); INSERT INTO `auth_groups_users` VALUES (3, 7); -- ---------------------------- -- 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 = 120 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of auth_logins -- ---------------------------- INSERT INTO `auth_logins` VALUES (69, '94.183.251.193', 'brand@gctest.ir', 8, '2020-07-11 14:39:40', 1); INSERT INTO `auth_logins` VALUES (70, '94.183.251.193', 'brand@gctest.ir', 8, '2020-07-12 09:35:57', 1); INSERT INTO `auth_logins` VALUES (71, '5.126.47.244', 'station@gctest.ir', 2, '2020-07-13 12:29:10', 1); INSERT INTO `auth_logins` VALUES (72, '5.126.47.244', 'brand@gctest.ir', 8, '2020-07-13 12:34:21', 1); INSERT INTO `auth_logins` VALUES (73, '5.126.47.244', 'brand@gctest.ir', 8, '2020-07-13 13:11:39', 1); INSERT INTO `auth_logins` VALUES (74, '94.183.251.193', 'brand@gctest.ir', 8, '2020-07-16 08:58:00', 1); INSERT INTO `auth_logins` VALUES (75, '94.183.251.193', 'station@gctest.ir', 2, '2020-07-16 08:58:26', 1); INSERT INTO `auth_logins` VALUES (76, '94.183.251.193', 'station@gctest.ir', 2, '2020-07-16 14:09:21', 1); INSERT INTO `auth_logins` VALUES (77, '94.183.251.193', 'brand@gctest.ir', 8, '2020-07-16 14:09:43', 1); INSERT INTO `auth_logins` VALUES (78, '2.180.25.16', 'brand@gctest.ir', 8, '2020-07-16 22:56:26', 1); INSERT INTO `auth_logins` VALUES (79, '2.180.25.16', 'station@gctest.ir', 2, '2020-07-16 23:01:30', 1); INSERT INTO `auth_logins` VALUES (80, '2.180.25.16', 'station@gctest.ir', 2, '2020-07-17 14:55:50', 1); INSERT INTO `auth_logins` VALUES (81, '2.180.25.16', 'station@gctest.ir', 2, '2020-07-17 17:49:09', 1); INSERT INTO `auth_logins` VALUES (82, '2.180.25.16', 'brand@gctest.ir', 8, '2020-07-17 18:08:50', 1); INSERT INTO `auth_logins` VALUES (83, '2.180.25.16', 'station@gctest.ir', 2, '2020-07-17 20:32:15', 1); INSERT INTO `auth_logins` VALUES (84, '5.126.46.251', 'admin@gctest.ir', 1, '2020-07-17 21:39:43', 1); INSERT INTO `auth_logins` VALUES (85, '5.126.46.251', 'brand', NULL, '2020-07-17 21:42:39', 0); INSERT INTO `auth_logins` VALUES (86, '5.126.46.251', 'brand', NULL, '2020-07-17 21:42:52', 0); INSERT INTO `auth_logins` VALUES (87, '5.126.46.251', 'brand@gctest.ir', 8, '2020-07-17 21:43:05', 1); INSERT INTO `auth_logins` VALUES (88, '5.126.46.251', 'operator', NULL, '2020-07-17 21:43:23', 0); INSERT INTO `auth_logins` VALUES (89, '5.126.46.251', 'station@gctest.ir', 2, '2020-07-17 21:43:31', 1); INSERT INTO `auth_logins` VALUES (90, '2.180.25.16', 'station@gctest.ir', 2, '2020-07-18 02:51:29', 1); INSERT INTO `auth_logins` VALUES (91, '2.180.25.16', 'brand@gctest.ir', 8, '2020-07-18 02:53:53', 1); INSERT INTO `auth_logins` VALUES (92, '94.183.251.193', 'station@gctest.ir', 2, '2020-07-18 09:28:08', 1); INSERT INTO `auth_logins` VALUES (93, '94.183.251.193', 'brand@gctest.ir', 8, '2020-07-18 09:47:11', 1); INSERT INTO `auth_logins` VALUES (94, '83.123.3.251', 'brand@gctest.ir', 8, '2020-07-18 10:59:31', 1); INSERT INTO `auth_logins` VALUES (95, '83.123.3.251', 'Station1', NULL, '2020-07-18 11:00:45', 0); INSERT INTO `auth_logins` VALUES (96, '83.123.3.251', 'station@gctest.ir', 2, '2020-07-18 11:01:21', 1); INSERT INTO `auth_logins` VALUES (97, '94.183.251.193', 'brand@gctest.ir', 8, '2020-07-18 11:22:02', 1); INSERT INTO `auth_logins` VALUES (98, '5.126.15.229', 'station@gctest.ir', 2, '2020-07-18 13:20:31', 1); INSERT INTO `auth_logins` VALUES (99, '5.126.15.229', 'brand@gctest.ir', 8, '2020-07-18 13:20:52', 1); INSERT INTO `auth_logins` VALUES (100, '94.183.251.193', 'brand@gctest.ir', 8, '2020-07-18 14:20:25', 1); INSERT INTO `auth_logins` VALUES (101, '198.143.178.116', 'brand@gctest.ir', 8, '2020-07-19 03:37:48', 1); INSERT INTO `auth_logins` VALUES (102, '94.183.251.193', 'brand@gctest.ir', 8, '2020-07-19 09:45:30', 1); INSERT INTO `auth_logins` VALUES (103, '94.183.251.193', 'brand@gctest.ir', 8, '2020-07-19 12:04:18', 1); INSERT INTO `auth_logins` VALUES (104, '94.183.251.193', 'station@gctest.ir', 2, '2020-07-19 12:10:34', 1); INSERT INTO `auth_logins` VALUES (105, '94.183.251.193', 'brand@gctest.ir', 8, '2020-07-20 08:46:38', 1); INSERT INTO `auth_logins` VALUES (106, '94.183.251.193', 'station@gctest.ir', 2, '2020-07-20 09:07:50', 1); INSERT INTO `auth_logins` VALUES (107, '94.183.251.193', 'station@gctest.ir', 2, '2020-07-21 11:21:51', 1); INSERT INTO `auth_logins` VALUES (108, '5.125.40.239', 'station@gctest.ir', 2, '2020-07-21 14:01:38', 1); INSERT INTO `auth_logins` VALUES (109, '94.183.251.193', 'station@gctest.ir', 2, '2020-07-22 11:32:34', 1); INSERT INTO `auth_logins` VALUES (110, '94.183.251.193', 'brand@gctest.ir', 8, '2020-07-22 13:28:02', 1); INSERT INTO `auth_logins` VALUES (111, '5.126.16.170', 'station@gctest.ir', 2, '2020-07-23 10:21:09', 1); INSERT INTO `auth_logins` VALUES (112, '5.126.16.170', 'brand@gctest.ir', 8, '2020-07-23 10:50:53', 1); INSERT INTO `auth_logins` VALUES (113, '2.180.25.16', 'station@gctest.ir', 2, '2020-07-25 03:13:59', 1); INSERT INTO `auth_logins` VALUES (114, '2.180.25.16', 'station@gctest.ir', 2, '2020-07-25 14:52:21', 1); INSERT INTO `auth_logins` VALUES (115, '2.180.25.16', 'station@gctest.ir', 2, '2020-07-25 19:09:38', 1); INSERT INTO `auth_logins` VALUES (116, '2.180.25.16', 'brand@gctest.ir', 8, '2020-07-26 04:10:17', 1); INSERT INTO `auth_logins` VALUES (117, '190.2.131.209', 'brand@gctest.ir', 8, '2020-07-26 05:03:23', 1); INSERT INTO `auth_logins` VALUES (118, '190.2.131.209', 'station@gctest.ir', 2, '2020-07-26 05:03:42', 1); INSERT INTO `auth_logins` VALUES (119, '2.180.25.16', 'station@gctest.ir', 2, '2020-07-26 05:55:14', 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 = 2 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 balances -- ---------------------------- DROP TABLE IF EXISTS `balances`; CREATE TABLE `balances` ( `id` int(10) UNSIGNED NOT NULL, `type` enum('decade','monthly') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `product` enum('regular','super','euro','gasoline','cng') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'regular' COMMENT 'نوع فرآورده', `start_date` datetime(0) NOT NULL COMMENT 'از تاریخ', `end_date` datetime(0) NOT NULL COMMENT 'تا تاریخ', `first_inventory` double UNSIGNED NOT NULL COMMENT 'موجودی اول دوره', `with_transfer` double NULL DEFAULT 0 COMMENT 'با حواله', `from_pipeline` double NULL DEFAULT NULL COMMENT 'از خط لوله', `direct_sending` double NULL DEFAULT NULL COMMENT 'ارسال مستقیم', `revealed` double NULL DEFAULT NULL COMMENT 'مکشوفه', `from_test` double NULL DEFAULT NULL COMMENT 'برگشت از آزمایش', `with_freight` double NULL DEFAULT NULL COMMENT 'با بارنامه', `debtor_other` double NULL DEFAULT NULL COMMENT 'سایر موارد مربوط به بخش بدهکار', `addition` double NULL DEFAULT NULL COMMENT 'سرک', `debtor_total` double NOT NULL COMMENT 'جمع بدهکاری', `rate_1_price` bigint(20) UNSIGNED NULL DEFAULT NULL COMMENT 'نرخ اول', `rate_1_value` double UNSIGNED NULL DEFAULT NULL COMMENT 'مقدار نرخ اول', `rate_2_price` bigint(20) UNSIGNED NULL DEFAULT NULL COMMENT 'نرخ دوم', `rate_2_value` double UNSIGNED NULL DEFAULT NULL COMMENT 'مقدار نرخ دوم', `rate_3_price` bigint(20) UNSIGNED NULL DEFAULT NULL COMMENT 'نرخ سوم', `rate_3_value` double UNSIGNED NULL DEFAULT NULL COMMENT 'مقدار نرخ سوم', `rate_4_price` bigint(20) UNSIGNED NULL DEFAULT NULL COMMENT 'نرخ چهارم', `rate_4_value` double UNSIGNED NULL DEFAULT NULL COMMENT 'مقدار نرخ چهارم', `mix_with_water` double NULL DEFAULT NULL COMMENT 'مخلوط با آب', `infected` double NULL DEFAULT NULL COMMENT 'آلوده', `leak` double NULL DEFAULT NULL COMMENT 'نشتی', `test` double NULL DEFAULT NULL COMMENT 'آزمایش', `creditor_other` double NULL DEFAULT NULL COMMENT 'سایر موارد مربوط به بخش بدهکار', `deficit` double NULL DEFAULT NULL COMMENT 'کسری', `last_inventory` double NOT NULL COMMENT 'موجودی آخر دوره', `creditor_total` double NOT NULL COMMENT 'جمع بستانکاری', `status` enum('active','inactive','deleted') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL 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 ) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Fixed; -- ---------------------------- -- Records of balances -- ---------------------------- -- ---------------------------- -- Table structure for daily_balances -- ---------------------------- DROP TABLE IF EXISTS `daily_balances`; CREATE TABLE `daily_balances` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `station_id` int(10) UNSIGNED NOT NULL, `product` enum('regular','super','euro','gasoline','cng') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'regular' COMMENT 'نوع فرآورده', `start_date` datetime(0) NOT NULL COMMENT 'از تاریخ', `end_date` datetime(0) NOT NULL COMMENT 'تا تاریخ', `amount` bigint(20) UNSIGNED NULL DEFAULT 0 COMMENT 'مبلغ موازنه', `first_inventory` double UNSIGNED NOT NULL COMMENT 'موجودی اول دوره', `with_transfer` double NULL DEFAULT 0 COMMENT 'با حواله', `from_pipeline` double NULL DEFAULT 0 COMMENT 'از خط لوله', `direct_sending` double NULL DEFAULT 0 COMMENT 'ارسال مستقیم', `revealed` double NULL DEFAULT 0 COMMENT 'مکشوفه', `from_test` double NULL DEFAULT 0 COMMENT 'برگشت از آزمایش', `with_freight` double NULL DEFAULT 0 COMMENT 'با بارنامه', `debtor_other` double NULL DEFAULT 0 COMMENT 'سایر موارد مربوط به بخش بدهکار', `addition` double NULL DEFAULT 0 COMMENT 'سرک', `debtor_total` double NOT NULL DEFAULT 0 COMMENT 'جمع بدهکاری', `rate_1_price` bigint(20) UNSIGNED NULL DEFAULT 0 COMMENT 'نرخ اول', `rate_1_value` double UNSIGNED NULL DEFAULT 0 COMMENT 'مقدار نرخ اول', `rate_2_price` bigint(20) UNSIGNED NULL DEFAULT 0 COMMENT 'نرخ دوم', `rate_2_value` double UNSIGNED NULL DEFAULT 0 COMMENT 'مقدار نرخ دوم', `rate_3_price` bigint(20) UNSIGNED NULL DEFAULT 0 COMMENT 'نرخ سوم', `rate_3_value` double UNSIGNED NULL DEFAULT 0 COMMENT 'مقدار نرخ سوم', `rate_4_price` bigint(20) UNSIGNED NULL DEFAULT 0 COMMENT 'نرخ چهارم', `rate_4_value` double UNSIGNED NULL DEFAULT 0 COMMENT 'مقدار نرخ چهارم', `mix_with_water` double NULL DEFAULT 0 COMMENT 'مخلوط با آب', `infected` double NULL DEFAULT 0 COMMENT 'آلوده', `leak` double NULL DEFAULT 0 COMMENT 'نشتی', `test` double NULL DEFAULT 0 COMMENT 'آزمایش', `creditor_other` double NULL DEFAULT 0 COMMENT 'سایر موارد مربوط به بخش بدهکار', `deficit` double NULL DEFAULT 0 COMMENT 'کسری', `last_inventory` double NOT NULL COMMENT 'موجودی آخر دوره', `creditor_total` double NOT NULL COMMENT 'جمع بستانکاری', `refuse_reason` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `status` enum('accept','wait','refused','deleted') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'wait' 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 ) ENGINE = MyISAM AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of daily_balances -- ---------------------------- INSERT INTO `daily_balances` VALUES (3, 1, 'regular', '2020-07-25 00:00:00', '2020-07-26 00:00:00', 150000, 21400, 0, 0, 0, 0, 0, 58000, 0, 0, 79400, 15000, 0, 15010, 44329.02, 30000, 10.14, 30010, 0, 0, 0, 0, 0, 0, 760.84, 34300, 79400, '', 'wait', '2020-07-26 02:46:26', '2020-07-26 07:35:51', NULL); INSERT INTO `daily_balances` VALUES (4, 1, 'regular', '2020-07-26 00:00:00', '2020-07-27 00:00:00', 15000000, 34300, 0, 0, 1000, 0, 0, 0, 0, 0, 35300, 15000, 1500, 15010, 0, 30000, 1000, 30010, 0, 0, 0, 0, 0, 0, 22800, 10000, 35300, NULL, 'wait', '2020-07-26 05:31:47', '2020-07-26 05:31:47', NULL); -- ---------------------------- -- 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, `priority` int(10) 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, 9, 'active', '2020-05-23 14:44:46', '2020-07-19 12:29:25', NULL); INSERT INTO `product_capacities` VALUES (2, 1, 14000, 4, 'active', '2020-05-23 14:44:46', '2020-07-19 12:28:42', NULL); INSERT INTO `product_capacities` VALUES (3, 1, 18200, 5, 'active', '2020-05-23 14:44:46', '2020-07-19 12:28:48', NULL); INSERT INTO `product_capacities` VALUES (4, 1, 19300, 6, 'active', '2020-05-23 14:44:46', '2020-07-19 12:28:53', NULL); INSERT INTO `product_capacities` VALUES (5, 1, 19700, 10, 'active', '2020-05-23 14:44:46', '2020-07-19 12:31:55', NULL); INSERT INTO `product_capacities` VALUES (6, 1, 20000, 3, 'active', '2020-05-23 14:44:46', '2020-07-19 12:28:38', NULL); INSERT INTO `product_capacities` VALUES (7, 1, 30200, 11, 'active', '2020-05-23 14:44:46', '2020-07-19 12:31:57', NULL); INSERT INTO `product_capacities` VALUES (8, 1, 30300, 8, 'active', '2020-05-23 14:44:46', '2020-07-19 12:29:21', NULL); INSERT INTO `product_capacities` VALUES (9, 1, 30400, 2, 'active', '2020-05-23 14:44:46', '2020-07-19 12:28:33', NULL); INSERT INTO `product_capacities` VALUES (10, 1, 32000, 1, 'active', '2020-05-23 14:44:46', '2020-07-19 12:28:30', NULL); INSERT INTO `product_capacities` VALUES (11, 1, 32200, 7, 'active', '2020-05-23 14:44:46', '2020-07-19 12:29:07', NULL); INSERT INTO `product_capacities` VALUES (12, 3, 6000, 9, 'active', '2020-05-23 14:44:46', '2020-07-19 12:30:11', NULL); INSERT INTO `product_capacities` VALUES (13, 3, 14000, 4, 'active', '2020-05-23 14:44:46', '2020-07-19 12:29:55', NULL); INSERT INTO `product_capacities` VALUES (14, 3, 18200, 5, 'active', '2020-05-23 14:44:46', '2020-07-19 12:29:57', NULL); INSERT INTO `product_capacities` VALUES (15, 3, 19300, 6, 'active', '2020-05-23 14:44:46', '2020-07-19 12:29:59', NULL); INSERT INTO `product_capacities` VALUES (16, 3, 19700, 10, 'active', '2020-05-23 14:44:46', '2020-07-19 12:32:00', NULL); INSERT INTO `product_capacities` VALUES (17, 3, 20000, 3, 'active', '2020-05-23 14:44:46', '2020-07-19 12:29:50', NULL); INSERT INTO `product_capacities` VALUES (18, 3, 30200, 11, 'active', '2020-05-23 14:44:46', '2020-07-19 12:32:01', NULL); INSERT INTO `product_capacities` VALUES (19, 3, 30300, 8, 'active', '2020-05-23 14:44:46', '2020-07-19 12:30:07', NULL); INSERT INTO `product_capacities` VALUES (20, 3, 30400, 2, 'active', '2020-05-23 14:44:46', '2020-07-19 12:29:48', NULL); INSERT INTO `product_capacities` VALUES (21, 3, 32000, 1, 'active', '2020-05-23 14:44:46', '2020-07-19 12:29:45', NULL); INSERT INTO `product_capacities` VALUES (22, 3, 32200, 7, 'active', '2020-05-23 14:44:46', '2020-07-19 12:30:04', NULL); INSERT INTO `product_capacities` VALUES (23, 2, 20000, 1, 'active', '2020-05-23 14:44:46', '2020-07-19 12:31:23', NULL); INSERT INTO `product_capacities` VALUES (24, 2, 30400, 2, 'active', '2020-05-23 14:51:26', '2020-07-19 12:31:26', NULL); INSERT INTO `product_capacities` VALUES (25, 2, 32000, 3, 'active', '2020-05-23 14:51:40', '2020-07-19 12:31:29', NULL); INSERT INTO `product_capacities` VALUES (26, 2, 32200, 4, 'active', '2020-05-23 14:51:48', '2020-07-19 12:31:41', NULL); INSERT INTO `product_capacities` VALUES (27, 4, 29000, 1, 'active', '2020-05-23 14:52:26', '2020-07-19 12:30:29', NULL); INSERT INTO `product_capacities` VALUES (28, 4, 30000, 2, 'active', '2020-05-23 14:52:31', '2020-07-19 12:30:59', NULL); INSERT INTO `product_capacities` VALUES (29, 4, 30400, 3, 'active', '2020-05-23 14:52:43', '2020-07-19 12:31:03', NULL); INSERT INTO `product_capacities` VALUES (30, 4, 31000, 4, 'active', '2020-05-23 14:52:48', '2020-07-19 12:31:05', NULL); INSERT INTO `product_capacities` VALUES (31, 4, 32000, 5, 'active', '2020-05-23 14:52:57', '2020-07-19 12:31:06', NULL); INSERT INTO `product_capacities` VALUES (33, 5, 29000, 1, 'active', '2020-05-23 14:52:26', '2020-07-19 12:32:05', NULL); INSERT INTO `product_capacities` VALUES (34, 5, 30000, 2, 'active', '2020-05-23 14:52:31', '2020-07-19 12:32:08', NULL); INSERT INTO `product_capacities` VALUES (35, 5, 30400, 3, 'active', '2020-05-23 14:52:43', '2020-07-19 12:32:09', NULL); INSERT INTO `product_capacities` VALUES (36, 5, 31000, 4, 'active', '2020-05-23 14:52:48', '2020-07-19 12:32:09', NULL); INSERT INTO `product_capacities` VALUES (37, 5, 32000, 5, 'active', '2020-05-23 14:52:57', '2020-07-19 12:32:10', NULL); INSERT INTO `product_capacities` VALUES (38, 5, 32000, 6, 'active', '2020-05-23 14:52:58', '2020-07-19 12:32:11', 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, `user_id` int(10) UNSIGNED NULL DEFAULT NULL, `step` tinyint(4) NULL DEFAULT 1, `status` enum('wait','accepted','failed','refused','bought','delivered') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'wait', `description` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_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 ) ENGINE = InnoDB AUTO_INCREMENT = 19 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of request_logs -- ---------------------------- INSERT INTO `request_logs` VALUES (1, 1, 2, 1, 'wait', '', '2020-07-18 13:39:16', '2020-07-18 13:39:16', NULL); INSERT INTO `request_logs` VALUES (2, 1, 2, 1, 'wait', '', '2020-07-18 13:42:20', '2020-07-18 13:42:20', NULL); INSERT INTO `request_logs` VALUES (3, 1, 8, 2, 'accepted', '', '2020-07-18 13:51:35', '2020-07-18 13:51:35', NULL); INSERT INTO `request_logs` VALUES (4, 1, 8, 3, 'bought', '', '2020-07-18 13:58:35', '2020-07-18 13:58:35', NULL); INSERT INTO `request_logs` VALUES (5, 1, 2, 4, 'delivered', '', '2020-07-18 14:16:42', '2020-07-18 14:16:42', NULL); INSERT INTO `request_logs` VALUES (6, 2, 2, 1, 'wait', '', '2020-07-18 14:39:12', '2020-07-18 14:39:12', NULL); INSERT INTO `request_logs` VALUES (7, 3, 2, 1, 'wait', '', '2020-07-18 14:39:12', '2020-07-18 14:39:12', NULL); INSERT INTO `request_logs` VALUES (8, 3, 8, 2, 'accepted', '', '2020-07-18 14:45:52', '2020-07-18 14:45:52', NULL); INSERT INTO `request_logs` VALUES (9, 2, 8, 1, 'refused', '', '2020-07-18 14:47:34', '2020-07-18 14:47:34', NULL); INSERT INTO `request_logs` VALUES (10, 2, 8, 1, 'failed', '', '2020-07-18 14:55:08', '2020-07-18 14:55:08', NULL); INSERT INTO `request_logs` VALUES (11, 4, 2, 1, 'wait', '', '2020-07-19 12:11:17', '2020-07-19 12:11:17', NULL); INSERT INTO `request_logs` VALUES (12, 4, 8, 2, 'accepted', '', '2020-07-19 12:13:51', '2020-07-19 12:13:51', NULL); INSERT INTO `request_logs` VALUES (13, 4, 8, 2, 'refused', '', '2020-07-19 12:14:43', '2020-07-19 12:14:43', NULL); INSERT INTO `request_logs` VALUES (14, 3, 8, 3, 'bought', '', '2020-07-19 12:18:08', '2020-07-19 12:18:08', NULL); INSERT INTO `request_logs` VALUES (15, 3, 2, 4, 'delivered', '', '2020-07-20 09:50:38', '2020-07-20 09:50:38', NULL); INSERT INTO `request_logs` VALUES (16, 5, 2, 1, 'wait', '', '2020-07-21 14:39:51', '2020-07-21 14:39:51', NULL); INSERT INTO `request_logs` VALUES (17, 6, 2, 1, 'wait', '', '2020-07-21 14:39:51', '2020-07-21 14:39:51', NULL); INSERT INTO `request_logs` VALUES (18, 5, 2, 1, 'wait', '', '2020-07-21 14:40:33', '2020-07-21 14:40:33', NULL); -- ---------------------------- -- 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 NULL DEFAULT NULL COMMENT 'لیتراژ', `requester_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'درخواست کننده', `request_date_time` datetime(0) NULL DEFAULT NULL COMMENT 'تاریخ درخواست', `unit_price` bigint(20) NULL DEFAULT NULL COMMENT 'قیمت واحد', `total_price` bigint(20) NULL DEFAULT NULL COMMENT 'قیمت نهایی', `financial_approval` tinyint(1) NULL DEFAULT NULL COMMENT 'تایید مالی', `tel` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'شماره تماس', `admin_description` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT 'توضیحات ادمین', `submitted_product` enum('regular','super','euro','gasoline','cng') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'نوع فرآورده ارسالی', `freight_number` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'شماره بارنامه', `issue_date` datetime(0) NULL DEFAULT NULL COMMENT 'تاریخ صدور', `carried_volume` int(11) NULL DEFAULT NULL COMMENT 'میزان حمل شده', `exit_date` datetime(0) NULL DEFAULT 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 NULL DEFAULT 'regular' COMMENT 'رسید - نوع سوخت', `step4_volume` int(11) UNSIGNED NULL DEFAULT NULL COMMENT 'رسید - لیتراژ', `step4_freight` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'رسید - بارنامه', `step4_enter_date` datetime(0) NULL DEFAULT NULL COMMENT 'رسید - تاریخ ورود به جایگاه', `step4_freight_temperature` float NULL DEFAULT NULL COMMENT 'رسید - درجه حرارت بارنامه (`f)', `step4_test_temperature` float NULL DEFAULT NULL COMMENT 'درجه حرارت آزمایش (`c)', `step4_freight_weight` int(10) UNSIGNED NULL DEFAULT NULL COMMENT 'رسید - وزن مخصوص بارنامه (kg/litr)', `step4_test_weight` int(10) UNSIGNED NULL DEFAULT NULL COMMENT 'رسید - وزن مخصوص آزمایش (kg/litr)', `step4_issue_date` datetime(0) NULL DEFAULT NULL COMMENT 'رسید - تاریخ صدور', `step4_freight_number` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'رسید - شماره بارنامه / حواله ', `step4_origin` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'رسید - مبدا', `step4_contractor` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'رسید - نام پیمانکار', `step4_driver` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'رسید - نام راننده', `step4_tanker_number` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'رسید - شماره نفتکش', `refuse_reason` varchar(400) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `is_new` tinyint(1) UNSIGNED NULL DEFAULT 1, `step` tinyint(1) NULL DEFAULT 1, `status` enum('wait','accepted','failed','refused','bought','delivered') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'wait' 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 ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of requests -- ---------------------------- INSERT INTO `requests` VALUES (1, 1, 0, 1, 'regular', 32000, 'خسرو صولتی', '2020-07-18 15:00:00', 13930, 445760000, NULL, NULL, NULL, NULL, '75272725', '2020-07-18 13:57:06', NULL, NULL, NULL, 'regular', 32000, NULL, '2020-07-18 14:15:01', 60, 19, 99, 99, '2020-07-18 14:14:21', '654654', 'انبار مشهد', 'نعمتی', 'حیدری', '45465465', NULL, 0, 4, 'delivered', '2020-07-18 13:39:16', '2020-07-18 14:24:49', NULL); INSERT INTO `requests` VALUES (2, 1, 0, 1, 'regular', 18200, 'خسرو صولتی', '2020-07-18 14:38:40', 13930, 253526000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'regular', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 'failed', '2020-07-18 14:39:12', '2020-07-18 14:55:08', NULL); INSERT INTO `requests` VALUES (3, 1, 0, 1, 'regular', 18200, 'خسرو صولتی', '2020-07-18 14:38:40', 13930, 253526000, NULL, NULL, NULL, NULL, '41542151', '2020-07-08 12:18:03', NULL, NULL, NULL, 'regular', 18200, NULL, '2020-07-19 09:49:42', 10, 30, 15, 19, '2020-06-24 08:54:50', '121524/12', 'پالایشگاه', 'احمد نصرتی', 'قاسم طیرانی', '14251/41/2', NULL, 0, 4, 'delivered', '2020-07-18 14:39:12', '2020-07-20 09:55:49', NULL); INSERT INTO `requests` VALUES (4, 1, 0, 1, 'regular', 6000, 'غلامعلی رحیمی', '2020-07-20 12:11:14', 13930, 83580000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'regular', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 2, 'refused', '2020-07-19 12:00:17', '2020-07-19 12:19:07', NULL); INSERT INTO `requests` VALUES (5, 1, 0, 1, 'regular', 6000, '4kj', '2020-07-21 18:39:29', 13930, 83580000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'regular', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 'wait', '2020-07-21 14:39:51', '2020-07-21 14:40:33', NULL); INSERT INTO `requests` VALUES (6, 1, 0, 1, 'regular', 6000, '4kj', '2020-07-21 14:39:29', 13930, 83580000, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'regular', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, 'wait', '2020-07-21 14:39:51', '2020-07-23 10:51:28', 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 = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of station_balances -- ---------------------------- INSERT INTO `station_balances` VALUES (1, 1, 'regular', 15000, 15010, 30000, 30010, 'active', '2020-05-19 16:39:36', '2020-07-25 03:46:01', NULL); INSERT INTO `station_balances` VALUES (2, 1, 'super', 30000, 35010, 35000, 35010, 'active', '2020-05-19 16:39:36', '2020-07-25 04:47:09', NULL); INSERT INTO `station_balances` VALUES (3, 1, 'euro', 15000, 15010, 30000, 30010, 'active', '2020-05-19 16:39:36', '2020-07-25 03:46:23', NULL); INSERT INTO `station_balances` VALUES (4, 1, 'gasoline', 2000, 2100, 2200, 2300, 'active', '2020-07-08 12:56:40', '2020-07-08 12:56:40', 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_to_station` double NULL DEFAULT NULL, `brand_wage` double NULL DEFAULT NULL, `value_added` double NULL DEFAULT NULL, `station_wage` double NULL DEFAULT NULL, `buy_rate_for_brand` 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', 13930, 40, 87, 983, 13890, 'active', '2020-05-19 16:39:28', '2020-07-16 09:39:24', NULL); INSERT INTO `station_fees` VALUES (2, 1, 'super', 33930, 40, 79, 1100, 33890, 'active', '2020-05-19 16:39:28', '2020-07-16 09:24:36', NULL); INSERT INTO `station_fees` VALUES (3, 1, 'euro', 10000, 10000, 10000, 10000, 10000, 'active', '2020-05-19 16:39:28', '2020-06-21 09:17:19', NULL); INSERT INTO `station_fees` VALUES (4, 1, 'gasoline', 2580, 81, 29, 350, 2540, 'active', '2020-05-19 16:39:28', '2020-06-21 09:18:43', NULL); INSERT INTO `station_fees` VALUES (5, 1, 'cng', 10000, 10000, 10000, 10000, 10000, 'active', '2020-05-19 16:39:28', '2020-06-21 09:17:20', 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` bigint(20) NULL DEFAULT 0, `date_credit` datetime(0) NULL DEFAULT NULL, `fuel_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, `accepted_fuel_credit` bigint(20) NULL DEFAULT NULL, `waited_fuel_credit` bigint(20) NULL DEFAULT NULL, `accepted_balance_credit` bigint(20) NULL DEFAULT NULL, `waited_balance_credit` bigint(20) 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, 8, 'جایگاه 114', 114, 5175, 'هشتم', 'پنج', 'ب', 'تست تستی', '09123456789', '05123456789', 'مشهد-بلوار تستی ها', 'اپراتور اول تست اول', '09123456789', 'اپراتور دوم تست اول', '09123456789', '1251421.21', '5214125.21', 5, 1486, 1380, 4, 115, 2, 2, 1, 0, 0, 0, 0, 0, 0, 1, 55000000, '2020-07-21 00:00:00', '123123', 'Jf14215', 200714000, 752110000, 0, 850000, 'active', '2020-05-17 11:31:08', '2020-07-26 07:35:20', NULL); INSERT INTO `stations` VALUES (2, 8, 'جایگاه 123', 123, 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, '0000-00-00 00:00:00', 'Ks147845', 'Jf14215', 0, 0, 0, 0, 'active', '2020-05-17 11:31:08', '2020-07-18 13:33:17', NULL); INSERT INTO `stations` VALUES (3, 8, 'جایگاه سوم', 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, '2020-07-06 00:00:00', 'Ks147845', 'Jf14215', 0, 0, 0, 0, 'active', '2020-05-17 11:31:08', '2020-06-30 12:29:07', NULL); INSERT INTO `stations` VALUES (4, 8, 'جایگاه چهارم', 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, '2020-07-06 00:00:00', 'Ks147845', 'Jf14215', 0, 0, 0, 0, 'active', '2020-05-17 11:31:08', '2020-06-30 12:29:07', NULL); INSERT INTO `stations` VALUES (5, 8, 'جایگاه پنجم', 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, '2020-07-06 00:00:00', 'Ks147845', 'Jf14215', 0, 0, 0, 0, 'active', '2020-05-17 11:31:08', '2020-06-30 12:29:07', NULL); INSERT INTO `stations` VALUES (6, 8, 'جایگاه ششم', 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, '2020-07-06 00:00:00', 'Ks147845', 'Jf14215', 0, 0, 0, 0, 'active', '2020-05-17 11:31:08', '2020-06-30 12:29:07', 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-06-30 13:08:09', NULL); INSERT INTO `tanks` VALUES (9, 1, 6, 'cng', 56555, 'deleted', '2020-05-19 15:26:47', '2020-07-09 10:05:22', NULL); -- ---------------------------- -- Table structure for transactions -- ---------------------------- DROP TABLE IF EXISTS `transactions`; CREATE TABLE `transactions` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `station_id` int(10) UNSIGNED NULL DEFAULT NULL, `request_id` int(10) UNSIGNED NULL DEFAULT NULL, `type` enum('fuel','balance') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `deposit_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `document_type` enum('transfer','receipt','paia','pos','card','online','credit','request') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `transaction_type` enum('deposit','withdraw') CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `transaction_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `receiver_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `amount` bigint(20) NULL DEFAULT NULL, `depositor` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `deposit_date_time` datetime(0) NULL DEFAULT NULL, `description` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `refuse_reason` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `status` enum('success','fail','wait') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'wait', `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 `transactions_ibfk_1` FOREIGN KEY (`station_id`) REFERENCES `stations` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION ) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of transactions -- ---------------------------- INSERT INTO `transactions` VALUES (1, 1, NULL, 'fuel', '123123', 'receipt', 'deposit', '4564464', NULL, 900000000, 'حیدری', '2020-07-18 13:36:55', ' ', '', 'success', '2020-07-18 13:37:54', '2020-07-20 10:21:56', NULL); INSERT INTO `transactions` VALUES (2, 1, 1, 'fuel', '123123', NULL, 'withdraw', NULL, NULL, 445760000, NULL, NULL, NULL, NULL, 'success', '2020-07-18 13:39:16', '2020-07-20 10:21:56', NULL); INSERT INTO `transactions` VALUES (3, 1, 2, 'fuel', '123123', NULL, 'withdraw', NULL, NULL, 253526000, NULL, NULL, NULL, '', 'success', '2020-07-18 14:39:12', '2020-07-26 05:04:26', NULL); INSERT INTO `transactions` VALUES (4, 1, 3, 'fuel', '123123', NULL, 'withdraw', NULL, NULL, 150000, NULL, NULL, NULL, NULL, 'wait', '2020-07-18 14:39:12', '2020-07-26 07:35:20', NULL); INSERT INTO `transactions` VALUES (5, 1, 4, 'fuel', '123123', NULL, 'withdraw', NULL, NULL, 83580000, NULL, NULL, NULL, NULL, 'wait', '2020-07-19 12:11:17', '2020-07-20 10:21:56', NULL); INSERT INTO `transactions` VALUES (6, 1, NULL, 'fuel', '123123', 'transfer', 'deposit', '45745', NULL, 3000000, 'رحیم رحمانی', '2020-07-20 10:34:16', ' ', NULL, 'wait', '2020-07-20 10:35:10', '2020-07-20 10:35:10', NULL); INSERT INTO `transactions` VALUES (7, 1, NULL, 'fuel', '123123', 'transfer', 'deposit', '2543354', NULL, 1000000000, 'test nejad', '2020-07-21 14:38:17', ' ', NULL, 'wait', '2020-07-21 14:38:38', '2020-07-21 14:38:38', NULL); INSERT INTO `transactions` VALUES (8, 1, 5, 'fuel', NULL, NULL, 'withdraw', NULL, NULL, 83580000, NULL, NULL, NULL, NULL, 'wait', '2020-07-21 14:39:51', '2020-07-21 14:39:51', NULL); INSERT INTO `transactions` VALUES (9, 1, 6, 'fuel', NULL, NULL, 'withdraw', NULL, NULL, 83580000, NULL, NULL, NULL, NULL, 'wait', '2020-07-21 14:39:51', '2020-07-21 14:39:51', NULL); INSERT INTO `transactions` VALUES (10, 1, NULL, 'balance', 'Jf14215', 'receipt', 'deposit', '1485282', NULL, 15000000, 'تست', '2020-07-24 17:51:34', ' ', NULL, 'wait', '2020-07-25 04:52:16', '2020-07-25 04:52:16', NULL); INSERT INTO `transactions` VALUES (13, 1, 3, 'balance', NULL, NULL, 'withdraw', NULL, NULL, 150000, NULL, NULL, NULL, NULL, 'wait', '2020-07-26 02:46:26', '2020-07-26 07:35:20', NULL); INSERT INTO `transactions` VALUES (14, 1, NULL, 'balance', 'Jf14215', 'pos', 'deposit', '11', '12', 1000000, 'سیب', '2020-07-26 05:30:56', ' بیس', NULL, 'wait', '2020-07-26 05:31:36', '2020-07-26 05:31:36', NULL); INSERT INTO `transactions` VALUES (15, 1, 4, 'balance', NULL, NULL, 'withdraw', NULL, NULL, 15000000, NULL, NULL, NULL, NULL, 'wait', '2020-07-26 05:31:47', '2020-07-26 05:31:47', NULL); -- ---------------------------- -- Table structure for transactions_log -- ---------------------------- DROP TABLE IF EXISTS `transactions_log`; CREATE TABLE `transactions_log` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `transaction_id` int(10) UNSIGNED NULL DEFAULT NULL, `user_id` int(10) UNSIGNED NULL DEFAULT NULL, `ip` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `status` enum('success','fail','wait') CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'wait', `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 = 25 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of transactions_log -- ---------------------------- INSERT INTO `transactions_log` VALUES (1, 1, 2, '5.126.15.22', 'wait', '2020-07-18 13:37:54', '2020-07-18 13:37:54', NULL); INSERT INTO `transactions_log` VALUES (2, 2, 2, '5.126.15.22', 'wait', '2020-07-18 13:39:16', '2020-07-18 13:39:16', NULL); INSERT INTO `transactions_log` VALUES (3, 1, 8, '5.126.15.22', 'success', '2020-07-18 13:50:39', '2020-07-18 13:50:39', NULL); INSERT INTO `transactions_log` VALUES (4, 2, 8, '5.126.15.22', 'success', '2020-07-18 13:51:35', '2020-07-18 13:51:35', NULL); INSERT INTO `transactions_log` VALUES (5, 3, 2, '5.126.15.22', 'wait', '2020-07-18 14:39:12', '2020-07-18 14:39:12', NULL); INSERT INTO `transactions_log` VALUES (6, 4, 2, '5.126.15.22', 'wait', '2020-07-18 14:39:12', '2020-07-18 14:39:12', NULL); INSERT INTO `transactions_log` VALUES (7, 4, 8, '5.126.15.22', 'success', '2020-07-18 14:45:52', '2020-07-18 14:45:52', NULL); INSERT INTO `transactions_log` VALUES (8, 3, 8, '5.126.15.22', 'fail', '2020-07-18 14:55:08', '2020-07-18 14:55:08', NULL); INSERT INTO `transactions_log` VALUES (9, 5, 2, '94.183.251.', 'wait', '2020-07-19 12:11:17', '2020-07-19 12:11:17', NULL); INSERT INTO `transactions_log` VALUES (10, 5, 8, '94.183.251.', 'success', '2020-07-19 12:13:51', '2020-07-19 12:13:51', NULL); INSERT INTO `transactions_log` VALUES (11, 6, 2, '94.183.251.', 'wait', '2020-07-20 10:35:10', '2020-07-20 10:35:10', NULL); INSERT INTO `transactions_log` VALUES (12, 7, 2, '5.125.40.23', 'wait', '2020-07-21 14:38:38', '2020-07-21 14:38:38', NULL); INSERT INTO `transactions_log` VALUES (13, 8, 2, '5.125.40.23', 'wait', '2020-07-21 14:39:51', '2020-07-21 14:39:51', NULL); INSERT INTO `transactions_log` VALUES (14, 9, 2, '5.125.40.23', 'wait', '2020-07-21 14:39:51', '2020-07-21 14:39:51', NULL); INSERT INTO `transactions_log` VALUES (15, 10, 2, '2.180.25.16', 'wait', '2020-07-25 04:52:16', '2020-07-25 04:52:16', NULL); INSERT INTO `transactions_log` VALUES (18, 13, 2, '2.180.25.16', 'wait', '2020-07-26 02:46:26', '2020-07-26 02:46:26', NULL); INSERT INTO `transactions_log` VALUES (19, 3, 8, '190.2.131.2', 'success', '2020-07-26 05:04:26', '2020-07-26 05:04:26', NULL); INSERT INTO `transactions_log` VALUES (20, 14, 2, '190.2.131.2', 'wait', '2020-07-26 05:31:36', '2020-07-26 05:31:36', NULL); INSERT INTO `transactions_log` VALUES (21, 15, 2, '190.2.131.2', 'wait', '2020-07-26 05:31:47', '2020-07-26 05:31:47', NULL); INSERT INTO `transactions_log` VALUES (22, 4, 8, '2.180.25.16', 'success', '2020-07-26 05:54:15', '2020-07-26 05:54:15', NULL); INSERT INTO `transactions_log` VALUES (23, 4, 8, '2.180.25.16', 'fail', '2020-07-26 05:59:17', '2020-07-26 05:59:17', NULL); INSERT INTO `transactions_log` VALUES (24, 4, 8, '2.180.25.16', 'wait', '2020-07-26 06:07:01', '2020-07-26 06:07:01', 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 = 11 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, 'station@gctest.ir', 'station', '$2y$10$H6n8wnynO5COYkEuBLB22OeksbK2j8cuRAfrrxn.GBNvURkn9cSDS', NULL, NULL, NULL, '', NULL, NULL, 1, 0, '2020-05-11 17:59:24', '2020-06-28 23:00:12', NULL); INSERT INTO `users` VALUES (3, 2, '', 'station1', '$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, '', 'station2', '$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, '', 'station3', '$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, '', 'station4', '$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, '', 'station5', '$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 (8, NULL, 'brand@gctest.ir', 'brand', '$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;