MySQL建表语句

DDL1-7

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;
CREATE TABLE `7article_cats` (
  `catld` int(11) NOT NULL AUTO_INCREMENT,
  `parentld` int(11) NOT NULL DEFAULT '0',
  `catType` tinyint(4) NOT NULL DEFAULT '0',
  `isShow` tinyint(4) NOT NULL DEFAULT '1',
  `catName` varchar(20) NOT NULL,
  `catSort` int(11) NOT NULL DEFAULT '0',
  `dataFlag` tinyint(4) NOT NULL DEFAULT '1',
  `ctreate` datetime NOT NULL,
  PRIMARY KEY (`catld`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;