-
Notifications
You must be signed in to change notification settings - Fork 1
/
dbuser.sql
32 lines (30 loc) · 1.09 KB
/
dbuser.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
/*
MySQL Data Transfer
Source Host: localhost
Source Database: dbuser
Target Host: localhost
Target Database: dbuser
Date: 2016-12-28 ÉÏÎç 08:47:20
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`_id` int(11) NOT NULL auto_increment,
`bank_id` int(11) default NULL,
`pwd` varchar(100) NOT NULL,
`idcard` varchar(100) NOT NULL,
`name` varchar(200) NOT NULL,
`money` int(11) default NULL,
`time` datetime default NULL,
PRIMARY KEY (`_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `user` VALUES ('1', '12', '234567', '441283199607254002', 'anne', '610', '2016-12-28 00:00:00');
INSERT INTO `user` VALUES ('2', '13', '234567', '441282199702114444', 'pon', '1048', '2016-12-28 00:00:00');
INSERT INTO `user` VALUES ('3', '15', '123456', '441283199603214002', 'john', '1000', null);
INSERT INTO `user` VALUES ('4', '14', '123456', '111111111111111111', 'anne', '100', null);