· 9 years ago · Dec 22, 2016, 09:30 AM
1CREATE TABLE IF NOT EXISTS `baccount` (
2 `USER_ID` varchar(50) NOT NULL DEFAULT '',
3 `pwd` varchar(50) DEFAULT NULL,
4 `nickname` varchar(50) DEFAULT NULL,
5 `sex` varchar(1) DEFAULT NULL,
6 `age` int(5) unsigned DEFAULT NULL,
7 `email` varchar(128) DEFAULT NULL,
8 `pic_base64` longtext,
9 `join_date` varchar(8) DEFAULT NULL,
10 `join_time` varchar(6) DEFAULT NULL,
11 `profile` text,
12 PRIMARY KEY (`USER_ID`)
13) ENGINE=MyISAM DEFAULT CHARSET=utf8;