SET FOREIGN_KEY_CHECKS=0;

ALTER TABLE `cpf_acl_menu` MODIFY COLUMN `id`  int(10) UNSIGNED NOT NULL FIRST ;

ALTER TABLE `cpf_acl_menu` MODIFY COLUMN `pid`  int(11) UNSIGNED NOT NULL DEFAULT 0 AFTER `id`;

ALTER TABLE `cpf_acl_menu` MODIFY COLUMN `type`  tinyint(4) UNSIGNED NOT NULL DEFAULT 1 COMMENT '0,系统 1,用户' AFTER `pid`;

ALTER TABLE `cpf_acl_menu` MODIFY COLUMN `name`  varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' AFTER `type`;

ALTER TABLE `cpf_acl_menu` MODIFY COLUMN `link`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' AFTER `name`;

ALTER TABLE `cpf_acl_menu` MODIFY COLUMN `display`  tinyint(4) UNSIGNED NOT NULL DEFAULT 1 COMMENT '0,不显示 1,显示' AFTER `link`;

ALTER TABLE `cpf_acl_menu` MODIFY COLUMN `order`  int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序' AFTER `display`;

ALTER TABLE `cpf_acl_menu` DROP COLUMN `status`;

ALTER TABLE `cpf_acl_menu` MODIFY COLUMN `id`  int(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST ;

ALTER TABLE `cpf_acl_role` MODIFY COLUMN `id`  int(10) UNSIGNED NOT NULL FIRST ;

ALTER TABLE `cpf_acl_role` MODIFY COLUMN `behavior`  mediumtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '允许的行为' AFTER `name`;

ALTER TABLE `cpf_acl_role` MODIFY COLUMN `id`  int(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST ;

CREATE TABLE `cpf_act_log` (
`id`  int(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
`name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`type`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`controller`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`action`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`params`  text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
`date`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
`ip`  varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' ,
PRIMARY KEY (`id`),
INDEX `name` (`name`) USING BTREE ,
INDEX `type` (`type`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
ROW_FORMAT=Dynamic
;

ALTER TABLE `cpf_admin` MODIFY COLUMN `id`  int(11) UNSIGNED NOT NULL FIRST ;

ALTER TABLE `cpf_admin` ADD COLUMN `nickname`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '对外显示名称' AFTER `name`;

ALTER TABLE `cpf_admin` ADD COLUMN `real_name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '真实姓名' AFTER `nickname`;

ALTER TABLE `cpf_admin` ADD COLUMN `avatar`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '头像' AFTER `real_name`;

ALTER TABLE `cpf_admin` ADD COLUMN `cellphone`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '手机号' AFTER `avatar`;

ALTER TABLE `cpf_admin` ADD COLUMN `token`  varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '授权访问时身份验证令牌' AFTER `password`;

ALTER TABLE `cpf_admin` ADD COLUMN `theme`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '主题风格名称' AFTER `token`;

ALTER TABLE `cpf_admin` ADD COLUMN `salt`  char(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `theme`;

ALTER TABLE `cpf_admin` ADD COLUMN `usc`  tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '是否允许解绑密保卡' AFTER `salt`;

ALTER TABLE `cpf_admin` ADD COLUMN `last_login_date`  datetime NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `usc`;

ALTER TABLE `cpf_admin` ADD COLUMN `last_login_ip`  varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL AFTER `last_login_date`;

ALTER TABLE `cpf_admin` MODIFY COLUMN `rid`  int(11) UNSIGNED NOT NULL DEFAULT 1 COMMENT '角色ID' AFTER `last_login_ip`;

ALTER TABLE `cpf_admin` MODIFY COLUMN `t`  tinyint(3) UNSIGNED NOT NULL DEFAULT 1 COMMENT '0,禁用 1,正常' AFTER `rid`;

CREATE INDEX `name` ON `cpf_admin`(`name`) USING BTREE ;

ALTER TABLE `cpf_admin` MODIFY COLUMN `id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT FIRST ;

CREATE INDEX `article_id` ON `cpf_articles_stand`(`article_id`) USING BTREE ;

CREATE TABLE `cpf_config` (
`id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
`group_name`  varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`key`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`value`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`ct`  timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
PRIMARY KEY (`id`),
INDEX `key` (`key`) USING BTREE ,
INDEX `group_name` (`group_name`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
ROW_FORMAT=Dynamic
;

CREATE TABLE `cpf_info` (
`id`  int(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
`nail_footer`  tinyint(4) NOT NULL DEFAULT 0 ,
`link_name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`link_url`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`is_absolute_link`  tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否绝对地址' ,
`content`  text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`sort`  int(10) UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`id`),
INDEX `link_url` (`link_url`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
ROW_FORMAT=Dynamic
;

ALTER TABLE `cpf_security_card` MODIFY COLUMN `id`  int(11) UNSIGNED NOT NULL FIRST ;

ALTER TABLE `cpf_security_card` MODIFY COLUMN `ext_time`  tinyint(4) NOT NULL DEFAULT 0 COMMENT '已过期,-1' AFTER `bind_user`;

ALTER TABLE `cpf_security_card` MODIFY COLUMN `id`  int(11) UNSIGNED NOT NULL AUTO_INCREMENT FIRST ;

SET FOREIGN_KEY_CHECKS=1;