jieqi小说-用户

-- 数据库大全：jieqi小说-用户
-- 来源：YesApi.cn
CREATE TABLE `yesapi_jieqi_system_users` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `siteid` smallint(6) NOT NULL DEFAULT '0' COMMENT '',
    `uname` varchar(30) NOT NULL COMMENT '',
    `yesapi_jieqi_system_users_name` varchar(60) NOT NULL COMMENT '',
    `pass` varchar(32) NOT NULL COMMENT '',
    `groupid` tinyint(3) NOT NULL DEFAULT '0' COMMENT '',
    `regdate` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `initial` char(1) NOT NULL COMMENT '',
    `sex` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
    `email` varchar(60) NOT NULL COMMENT '',
    `url` varchar(100) NOT NULL COMMENT '',
    `avatar` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `workid` tinyint(3) NOT NULL DEFAULT '0' COMMENT '',
    `qq` varchar(15) NOT NULL COMMENT '',
    `icq` varchar(15) NOT NULL COMMENT '',
    `msn` varchar(60) NOT NULL COMMENT '',
    `mobile` varchar(20) NOT NULL COMMENT '',
    `sign` text NOT NULL COMMENT '',
    `intro` text NOT NULL COMMENT '',
    `setting` text NOT NULL COMMENT '',
    `badges` text NOT NULL COMMENT '',
    `lastlogin` int(10) NOT NULL DEFAULT '0' COMMENT '',
    `showsign` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
    `viewemail` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
    `notifymode` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
    `adminemail` tinyint(1) NOT NULL DEFAULT '1' COMMENT '',
    `monthscore` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `weekscore` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `dayscore` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `lastscore` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `experience` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `score` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `egold` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `esilver` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `credit` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `goodnum` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `badnum` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `isvip` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
    `overtime` int(11) NOT NULL DEFAULT '0' COMMENT '',
    `state` tinyint(1) NOT NULL DEFAULT '0' COMMENT '',
    KEY `groupid` (`groupid`),
    UNIQUE KEY `email` (`email`),
    KEY `state` (`state`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'jieqi小说-用户';

复制后，到数据库执行，即可创建此数据库表。