DDL
CREATE TABLE `cjq1` (
`accredld` int(11) NOT NULL COMMENT '自增ID',
`accredldName` varchar(50) NOT NULL COMMENT '名称',
`accredldmg` varchar(150) NOT NULL COMMENT '图标',
`dataFlag` tinyint(4) NOT NULL COMMENT '删除标志',
`createTime` datetime NOT NULL COMMENT '创建时间',
PRIMARY KEY (`accredldName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `cjq2` (
`addonld` int(10) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
`name` varchar(40) NOT NULL COMMENT '插件名称',
`title` varchar(20) NOT NULL COMMENT '插件标题',
`description` text NOT NULL COMMENT '插件描述',
`status` tinyint(1) NOT NULL COMMENT '插件状态',
`config` text NOT NULL COMMENT '插件配置参数',
`author` varchar(40) NOT NULL COMMENT '插件作者',
`varsion` varchar(20) NOT NULL COMMENT '插件版本号',
`createFag` tinyint(4) NOT NULL COMMENT '有效标识',
`create time` datetime NOT NULL COMMENT '创建时间',
`isconfig` tinyint(4) NOT NULL COMMENT '是否配置',
`updateTime` datetime NOT NULL COMMENT '修改时间',
PRIMARY KEY (`addonld`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;