DDL1-6
CREATE TABLE `1wst_accreds` (
`accredld` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
`accredName` varchar(50) NOT NULL COMMENT '名称',
`accredlmg` varchar(150) NOT NULL DEFAULT '0' COMMENT '图标',
`dataFlag` tinyint(4) NOT NULL DEFAULT '1' COMMENT '删除标志',
`createTime` datetime NOT NULL COMMENT '创建时间',
PRIMARY KEY (`accredld`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `2addons` (
`addonld` int(10) NOT NULL AUTO_INCREMENT,
`name` varchar(40) NOT NULL,
`title` varchar(20) NOT NULL,
`description` text,
`status` tinyint(1) NOT NULL DEFAULT '1',
`conflg` text,
`author` varchar(40) DEFAULT NULL,
`version` varchar(20) DEFAULT NULL,
`createTime` datetime NOT NULL,
`dataFlag` tinyint(4) DEFAULT '1',
`isConflg` tinyint(4) DEFAULT '0',
`updateTime` datetime DEFAULT NULL,
PRIMARY KEY (`addonld`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `3ads` (
`adld` int(11) NOT NULL AUTO_INCREMENT,
`adPositionldI` int(11) NOT NULL DEFAULT '0',
`adFlle` varchar(150) NOT NULL,
`adName` varchar(100) NOT NULL,
`adURL` varchar(255) NOT NULL,
`adStarDate` date NOT NULL,
`adEndDate` date NOT NULL,
`adSort` int(11) NOT NULL DEFAULT '0',
`adCllckNum` int(11) NOT NULL DEFAULT '0',
`positionType` tinyint(4) DEFAULT '0',
`dataFlag` tinyint(4) NOT NULL DEFAULT '1',
`createTime` datetime NOT NULL,
`subTitle` varchar(255) DEFAULT NULL,
PRIMARY KEY (`adld`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `4ad_positions` (
`positionld` int(11) NOT NULL,
`positionType` tinyint(4) NOT NULL DEFAULT '0',
`positionName` varchar(100) NOT NULL DEFAULT '0',
`PositionWidth` int(11) NOT NULL,
`positionHeight` int(11) NOT NULL DEFAULT '0',
`dataFlag` tinyint(4) NOT NULL DEFAULT '1',
`psoitionCode` varchar(20) DEFAULT NULL,
`apSort` int(11) NOT NULL,
PRIMARY KEY (`positionld`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `5wst_areas` (
`areald` int(11) NOT NULL AUTO_INCREMENT,
`arenyld` int(11) NOT NULL,
`areaName` varchar(100) NOT NULL,
`isShow` tinyint(4) NOT NULL DEFAULT '1',
`areaSort` int(11) NOT NULL DEFAULT '0',
`areaKey` char(10) NOT NULL,
`areaType` tinyint(4) NOT NULL DEFAULT '1',
`dataFlag` tinyint(4) NOT NULL DEFAULT '1',
`createTime` datetime DEFAULT NULL,
PRIMARY KEY (`areald`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `6articles` (
`articleid` int(11) NOT NULL AUTO_INCREMENT,
`catld` int(11) NOT NULL,
`articleTitle` varchar(200) NOT NULL,
`isShow` tinyint(4) NOT NULL DEFAULT '1',
`articleContent` longtext NOT NULL,
`articleKey` varchar(200) DEFAULT NULL,
`staflld` int(11) NOT NULL,
`dataFlag` tinyint(4) NOT NULL DEFAULT '1',
`createTime` datetime NOT NULL,
`solve` int(10) DEFAULT '0',
`unsolve` int(10) DEFAULT '0',
`coverlmg` varchar(150) DEFAULT NULL,
`visitorNum` int(10) DEFAULT '0',
`TypeStatus` int(10) DEFAULT '1',
`likeNum` int(10) DEFAULT '0',
`catSort` int(11) DEFAULT '0',
`articleDese` varchar(600) NOT NULL,
`isHlde` tinyint(4) DEFAULT '0',
PRIMARY KEY (`articleid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;