-
Notifications
You must be signed in to change notification settings - Fork 5
/
Copy pathuser.sql
115 lines (104 loc) · 6.57 KB
/
user.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
/*
Navicat Premium Data Transfer
Source Server : mysql
Source Server Type : MySQL
Source Server Version : 80032 (8.0.32)
Source Host : localhost:3306
Source Schema : dataset12306_test
Target Server Type : MySQL
Target Server Version : 80032 (8.0.32)
File Encoding : 65001
Date: 28/08/2023 13:57:32
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for pii
-- ----------------------------
DROP TABLE IF EXISTS `pii`;
CREATE TABLE `pii` (
`email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`account` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`idCard` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`phoneNum` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
`id` int NOT NULL AUTO_INCREMENT,
`fullName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `name_index`(`name` ASC) USING BTREE,
INDEX `fullname_index`(`fullName` ASC) USING BTREE,
INDEX `account_index`(`account` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 418907 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for pwrepresentation_frequency_general
-- ----------------------------
DROP TABLE IF EXISTS `pwrepresentation_frequency_general`;
CREATE TABLE `pwrepresentation_frequency_general` (
`id` int NOT NULL AUTO_INCREMENT,
`pwStr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`representationStructure` varchar(5000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'representation without vector.str',
`representationStructureHash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'hash of representationStructure',
`frequency` bigint NOT NULL DEFAULT 0,
PRIMARY KEY (`id`) USING BTREE,
INDEX `pwStr_index`(`pwStr` ASC) USING BTREE,
INDEX `repStruct_hash_index`(`representationStructureHash` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1640622 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for pwrepresentation_general
-- ----------------------------
DROP TABLE IF EXISTS `pwrepresentation_general`;
CREATE TABLE `pwrepresentation_general` (
`id` int NOT NULL AUTO_INCREMENT,
`pwStr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`representation` varchar(5000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'representation with vector.str',
`representationHash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'hash of representation',
`hash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'hash of pwStr+representation',
`representationStructure` varchar(5000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'representation without vector.str',
`representationStructureHash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'hash of representationStructure',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `hash_unique`(`hash` ASC) USING BTREE,
INDEX `pwStr_index`(`pwStr` ASC) USING BTREE,
INDEX `rep_hash_index`(`representationHash` ASC) USING BTREE,
INDEX `hash_index`(`hash` ASC) USING BTREE,
INDEX `rep_struct_hash_index`(`representationStructureHash` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1640622 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for pwrepresentation_unique_general
-- ----------------------------
DROP TABLE IF EXISTS `pwrepresentation_unique_general`;
CREATE TABLE `pwrepresentation_unique_general` (
`pwStr` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`representationStructure` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
`representationStructureHash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`representation` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL,
`representationHash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`hash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
`id` int NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`) USING BTREE,
UNIQUE INDEX `pwStr_unique`(`pwStr` ASC) USING BTREE,
INDEX `pwStr_index`(`pwStr` ASC) USING BTREE,
INDEX `rep_hash_index`(`representationHash` ASC) USING BTREE,
INDEX `repStruct_hash_index`(`representationStructureHash` ASC) USING BTREE,
INDEX `hash_index`(`hash` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 803541 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = 'The unique representation and structure of every password' ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for representation_frequency_base_general
-- ----------------------------
DROP TABLE IF EXISTS `representation_frequency_base_general`;
CREATE TABLE `representation_frequency_base_general` (
`frequency` bigint NOT NULL DEFAULT 0,
`representationStructureHash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'hash of representationStructure',
INDEX `repStruct_hash_index`(`representationStructureHash` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
-- ----------------------------
-- Table structure for representation_frequency_general
-- ----------------------------
DROP TABLE IF EXISTS `representation_frequency_general`;
CREATE TABLE `representation_frequency_general` (
`frequency` bigint NOT NULL DEFAULT 0,
`representationStructureHash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'hash of representationStructure',
`representationStructure` varchar(5000) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'representation without vector.str',
INDEX `repStruct_hash_index`(`representationStructureHash` ASC) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = DYNAMIC;
SET FOREIGN_KEY_CHECKS = 1;