-
Notifications
You must be signed in to change notification settings - Fork 0
/
users.sql
34 lines (28 loc) · 1.08 KB
/
users.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
/*
Navicat Premium Data Transfer
Source Server : www
Source Server Type : MySQL
Source Server Version : 100420
Source Host : localhost:3306
Source Schema : data
Target Server Type : MySQL
Target Server Version : 100420
File Encoding : 65001
Date: 06/08/2021 19:03:26
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`user_id` int NOT NULL AUTO_INCREMENT,
`name` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`password` varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`date_time` datetime NOT NULL,
`username` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`role` varchar(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
PRIMARY KEY (`user_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
SET FOREIGN_KEY_CHECKS = 1;