· 4 years ago · May 25, 2021, 07:38 AM
1/*
2 Navicat Premium Data Transfer
3
4 Source Server : root@docker-local
5 Source Server Type : MariaDB
6 Source Server Version : 100322
7 Source Host : localhost:3636
8 Source Schema : db_esemes
9
10 Target Server Type : MariaDB
11 Target Server Version : 100322
12 File Encoding : 65001
13
14 Date: 25/05/2021 13:59:01
15*/
16
17SET NAMES utf8mb4;
18SET FOREIGN_KEY_CHECKS = 0;
19
20-- ----------------------------
21-- Table structure for log
22-- ----------------------------
23DROP TABLE IF EXISTS `log`;
24CREATE TABLE `log` (
25 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
26 `pool_id` bigint(20) unsigned NOT NULL,
27 `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
28 `time_create` datetime NOT NULL DEFAULT current_timestamp(),
29 PRIMARY KEY (`id`) USING BTREE,
30 KEY `idx-log_pool-id` (`pool_id`) USING BTREE,
31 KEY `idx-log_status` (`status`) USING BTREE,
32 KEY `idx-log_time-create` (`time_create`) USING BTREE
33) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
34
35-- ----------------------------
36-- Records of log
37-- ----------------------------
38BEGIN;
39INSERT INTO `log` VALUES (1, 1, 'BOARDING', '2021-01-21 15:39:11');
40INSERT INTO `log` VALUES (2, 2, 'BOARDING', '2021-01-21 15:41:51');
41INSERT INTO `log` VALUES (3, 2, 'DELIVERED', '2021-01-21 15:41:59');
42INSERT INTO `log` VALUES (4, 3, 'BOARDING', '2021-01-21 15:44:16');
43INSERT INTO `log` VALUES (5, 3, 'LOST', '2021-01-21 15:45:23');
44INSERT INTO `log` VALUES (6, 4, 'BOARDING', '2021-01-21 20:45:47');
45INSERT INTO `log` VALUES (7, 4, 'REJECTED', '2021-01-21 20:45:59');
46INSERT INTO `log` VALUES (8, 5, 'BOARDING', '2021-01-21 20:46:55');
47INSERT INTO `log` VALUES (9, 5, 'OTW', '2021-01-21 20:47:03');
48INSERT INTO `log` VALUES (10, 5, 'OTW', '2021-01-21 20:47:25');
49INSERT INTO `log` VALUES (11, 6, 'ERROR_GATEWAY', '2021-01-21 20:48:29');
50COMMIT;
51
52-- ----------------------------
53-- Table structure for pool
54-- ----------------------------
55DROP TABLE IF EXISTS `pool`;
56CREATE TABLE `pool` (
57 `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
58 `msisdn` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
59 `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
60 `time_create` datetime NOT NULL DEFAULT current_timestamp(),
61 PRIMARY KEY (`id`) USING BTREE,
62 KEY `idx-pool_msisdn` (`msisdn`) USING BTREE,
63 KEY `idx-pool_time-create` (`time_create`) USING BTREE,
64 FULLTEXT KEY `idx-pool_message` (`message`)
65) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
66
67-- ----------------------------
68-- Records of pool
69-- ----------------------------
70BEGIN;
71INSERT INTO `pool` VALUES (1, '6281234567890', 'Test sms', '2021-01-21 15:38:31');
72INSERT INTO `pool` VALUES (2, '6281211223344', 'Percobaan kirim sms', '2021-01-21 15:40:04');
73INSERT INTO `pool` VALUES (3, '6285633334444', 'Apakah sms ini terkirim?', '2021-01-21 15:43:44');
74INSERT INTO `pool` VALUES (4, '62218872929', 'Status SMS saat ini adalah', '2021-01-21 20:45:33');
75INSERT INTO `pool` VALUES (5, '6281500007777', 'Seharusnya ini sudah sampai', '2021-01-21 20:46:42');
76INSERT INTO `pool` VALUES (6, '6282299889898', 'Apakah sms ini error', '2021-01-21 20:48:05');
77COMMIT;
78
79SET FOREIGN_KEY_CHECKS = 1;
80