数据库加表
mysql变更格式
数据库:wiki
表名:admin_user
sql:
CREATE TABLE `admin_user` (
`admin_id` int(11) NOT NULL AUTO_INCREMENT,
`p_id` int(11) NOT NULL DEFAULT '0',
`username` varchar(40) NOT NULL,
`password` varchar(32) NOT NULL,
`salt` varchar(6) NOT NULL,
`permission` int(11) NOT NULL DEFAULT '0',
`permission_list` varchar(2500) NOT NULL DEFAULT '',
`owner_permission` varchar(2500) NOT NULL DEFAULT '[]',
`status` tinyint(2) NOT NULL DEFAULT '1',
`add_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`lastupdatetime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`admin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8