'李红元',`modifyDate`datetimeDEFAULTNULL,`isAccountEnabled`bit(1)NOTNULLCOMMENT'账号是否启用',`name`,`roleSet_id`varchar(32)NOTNULL,`loginDate`,`isAccountLocked`,`department`,`email`,   `modifyDate`,`name`va

rchar

(255)DEFAULTNULLCOMMENT'姓名',

SET@OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,

~1rows(大约)/*!

`email`varchar(255)NOTNULLCOMMENT'E-mail',

`username`varchar(255)NOTNULLCOMMENT'用户名',   lovehomefee-/JFinalShop/resources/jfinalshop.sql-TaocodeTaocodeAliyunCode项目买服务器项目用户语言搜索登录注册页>hsongjiang/lovehomefee项目语言:PERL源码issues文档权限:read-only(如需更高权限请先加入项目)lovehomefee/JFinalShop/resources/历史|r3|2015-09-1311:12:29|下载------------------------------------------------------------主机:127.0.0.1--服务器版本:5.6.11-MySQLCommunityServer(GPL)--服务器操作系统:Win64--HeidiSQL版本:9.1.0.4886----------------------------------------------------------/*!'技术部',`roleSet_id`)VALUES('8a8a05de6c','e10adc3949ba59abbe56e057f20f883e',DEFAULTCHARACTERSETutf8*/;USE`jfinalshop`;--导出表jfinalshop.admin结构DROPTABLEIFEXISTS`admin`;CREATETABLEIFNOTEXISTS`admin`(`id`varchar(32)NOTNULLCOMMENT'ID',`loginFailureCount`int(11)NOTNULLCOMMENT'连续登录失败的次数',`isAccountLocked`bit(1)NOTNULLCOMMENT'账号是否锁定',   SET@OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT*/;/*!KEY`FK9FC63FA6DAED032`(`adminSet_id`),`password`varchar(255)NOTNULLCOMMENT'密码',SET@OLD_SQL_MODE=@@SQL_MODE,'2015-01-1016:29:05',ALTERTABLE`admin`ENABLEKEYS*/;--导出表jfinalshop.admin_role结构DROPTABLEIFEXISTS`admin_role`;CREATETABLEIFNOTEXISTS`admin_role`(`adminSet_id`varchar(32)NOTNULL,'2014-12-2911:35:13',`department`varchar(255)DEFAULTNULLCOMMENT'部门',FOREIGN_KEY_CHECKS=0*/;/*!PRIMARYKEY(`id`),`content`text,SETNAMESutf8mb4*/;/*!

`lockedDate`,

`createDate`datetimeDEFAULTNULLCOMMENT'建立日期',`createDate`datetimeDEFAULTNULL,ALTERTABLE`admin`DISABLEKEYS*/;INSERTINTO`admin`(`id`,`lockedDate`datetimeDEFAULTNULLCOMMENT'账号锁定日期',ALTERTABLE`admin_role`DISABLEKEYS*/;INSERTINTO`admin_role`(`adminSet_id`,PRIMARYKEY(`adminSet_id`,'admin');/*!`password`,

`isCredentialsExpired`,

`isAccountExpired`bit(1)NOTNULLCOMMENT'账号是否过期',`createDate`,   '2015-01-1016:29:05',b'0',   `roleSet_id`),

ALTERTABLE`admin_role`ENABLEKEYS*/;--导出表jfinalshop.agreement结构DROPTABLEIFEXISTS`agreement`;CREATETABLEIFNOTEXISTS`agreement`(`id`varchar(32)NOTNULL,

`loginIp`varchar(255)DEFAULTNULLCOMMENT'后登录IP',KEY`FK9FC63FA6C7B24C48`(`roleSet_id`),   `isCredentialsExpired`bit(1)NOTNULLCOMMENT'凭证是否过期',

`loginDate`datet

imeDEFAULTNULLCOMMENT'后登录日期',`loginFailureCount`,~2rows(大约)/*!b'1',

`modifyDate`datetimeDEFAULTNULLCOMMENT'修改日期',

0,   UNIQUEKEY`username`(`username`))ENGINE=InnoDBDEFAULTCHARSET=utf8;--正在导出表jfinalshop.admin的数据：`isAccountExpired`,SQL_MODE='NO_AUTO_VALUE_ON_ZERO'*/;--导出jfinalshop的数据库结构*/DROPDATABASEIFEXISTS`jfinalshop`;CREATEDATABASEIFNOTEXISTS`jfinalshop`/*!`isAccountEnabled`,b'0','2014-12-2911:27:01',CONSTRAINT`FK9FC63FA6DAED032`FOREIGNKEY(`adminSet_id`)REFERENCES`admin`(`id`))ENGINE=InnoDBDEFAULTCHARSET=utf8;--正在导出表jfinalshop.admin_role的数据：   `username`)VALUE

S('8a8a0

5de6c',

'bec2abec2b');/*!

  PRIMARYKEY(`id`))ENGINE=InnoDBDEFAULTCHARSET=utf8;--正在导出表jfinalshop.agr二郎核名 '0:0:0:0:0:0:0:1',`loginIp`,b'0',CONSTRAINT`FK9FC63FA6C7B24C48`FOREIGNKEY(`roleSet_id`)REFERENCES`role`(`id`),'',