· 5 years ago · Jul 21, 2020, 06:02 PM
1SET NAMES utf8mb4;
2SET FOREIGN_KEY_CHECKS = 0;
3
4-- ----------------------------
5-- Table structure for users
6-- ----------------------------
7DROP TABLE IF EXISTS `users`;
8CREATE TABLE `users` (
9 `id` int(0) NOT NULL AUTO_INCREMENT,
10 `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
11 `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
12 `created_at` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP(0),
13 PRIMARY KEY (`id`) USING BTREE,
14 UNIQUE INDEX `username`(`username`) USING BTREE
15) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
16
17-- ----------------------------
18-- Records of users
19-- ----------------------------
20
21SET FOREIGN_KEY_CHECKS = 1;