-
Notifications
You must be signed in to change notification settings - Fork 3
/
users.sql
34 lines (29 loc) · 1.05 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 MySQL Data Transfer
Source Server : bookshare
Source Server Version : 50067
Source Host : 192.168.21.157:3306
Source Database : bookshare
Target Server Type : MYSQL
Target Server Version : 50067
File Encoding : 65001
Date: 2012-03-12 16:31:21
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `users`
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` int(10) unsigned NOT NULL auto_increment,
`email` varchar(100) NOT NULL,
`active` int(10) unsigned NOT NULL default '0',
`create_time` timestamp NOT NULL default CURRENT_TIMESTAMP,
`password` varchar(45) NOT NULL,
`points` float default '0',
`locale` varchar(10) default 'en',
`account_type` varchar(50) default NULL,
`pic` varchar(500) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
INSERT INTO `users` VALUES ('1', '[email protected]', '0','2014-047-21 15:46:54','1q2w3e4r5t',0,'zh_HK','normal',null);