-
Notifications
You must be signed in to change notification settings - Fork 0
/
mydb.sql
34 lines (27 loc) · 962 Bytes
/
mydb.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 : 192.168.206.132
Source Server Type : MySQL
Source Server Version : 50725
Source Host : 192.168.206.132:3306
Source Schema : mydb
Target Server Type : MySQL
Target Server Version : 50725
File Encoding : 65001
Date: 01/03/2019 14:21:18
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`name` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
`password` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL
) ENGINE = InnoDB CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('admin', '123456');
SET FOREIGN_KEY_CHECKS = 1;