web的新闻发布系统的数据库设计
你这个应500java该有开发平台的要求吧
`State` varchar(40) character set utf8 default '
`ChannelID` varchar(40) NOT NULL;running',
channel CREATE TABLE `channel` (
今天新闻联播头条一个表记录栏目信息
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin CHECKSUM=1 DELAY_KEY_WRITE=1 ROW_FORMAT=DYNAMIC
UNIQUE KEY `WebSiteName` (`WebSiteName`)
UNIQUE KEY `Sys_ID` (`Sys_ID`),
PRIMARY KEY (`WebSiteID`),
`FacID` varchar(40) default NULL,
`Information` text character set utf8,
`Orderby` varchar(50) default NULL;,
`threadnumber` int(2) default '4',
`visitPath` varchar(500) collate utf8_bin default NULL,
`Sys_ID` int(11) NOT NULL auto_increment,
UNIQUE KEY `Sys_ID` (`Sys_ID`),
`ChannelName` varchar(50) default NULL,
`ShortName` varchar(50) default NULL,
`Sys_ID` int(11) NOT NULL auto_increment,
`SendTO_ChannelID` varchar(40) default NULL,
学习大只500彩票APP下载听说java当然还应当有其它像用户表， 主要就这些吧
) ENGINE=InnoDB DEFAULT CHARSET=utf8
KEY `FK_template` (`WebSiteID`)
UNIQUE KEY `Sys_ID` (`Sys_ID`),
PRIMARY KEY (`TemplateID`),
`Sys_ID` int(11) NOT NULL auto_increment,
`Memo` text,
`WebSiteID` varchar(40) default NULL,
`TemplateContext` text,
`Type` varchar(40) default NULL,
`PhysicsName` varchar(50) default NULL,
`LogicName` varchar(50) default NULL,
`TemplateID` varchar(40) NOT NULL default '',
template CREATE TABLE `template` (
其实
) ENGINE=InnoDB DEFAULT CHARSET=utf8
KEY `State` (`State`)
KEY `FK_article2` (`UserID`),
KEY `FK_article` (`ChannelID`),
UNIQUE KEY `Sys_ID` (`Sys_ID`),
PRIMARY KEY (`ArticleID`),
`DelUserID` varchar(40) default NULL,
`State` varchar(40) default '你知道新闻资讯官网下载安装新稿',
`Sys_ID` int(11) NOT NULL auto_increment,
`KeyWords` varchar(500) default NULL,
`UserID` varchar(40) NOT NULL,
`LastEditTimes` datetime default NULL,
`Editor` varchar(40) default NULL,
`Count` int(4) default NULL,
`ReadTimes` int(4) default NULL,
`Content` text,
`PublishDate` varchar(50) default NULL,
`Arthor` varchar(50) default NULL,
`Source` varchar(500) default NULL,
`Summary` text,
`ViceTitle` varchar(500) default NULL,
`Title` varchar(500) default NULL,
`ChannelID` varchar(40) default NULL,
`ArticleID` varchar(40) NOT NULL,
article CREATE TABLE `article` (
大只500注册优惠你知道发布一个表记录文章信息
) ENGINE=InnoDB DEFAULT CHARSET=utf8
KEY `FK_channel` (`WebSiteID`)
`WebSiteID` varchar(40) default NULL,
`WebSiteID` varchar(40) character set utf8 NOT NULL,
website CREATE TABLE `website` (
`WebSiteName` varchar(50) character set utf8 default NULL大只500注册网址看着系统一个表记录站点信息
`PageSize` int(3) default NULL,
`SavePath` varchar(500) character set utf8 default NULL,
UNIQUE KEY `想知道大只500javaChannelName` (`ChannelName`,`WebSiteID`),
PRIMARY KEY (`ChannelID`),
`ListTemplateID` varchar(4财经新闻资讯app0) default NULL,
`FileTemplateID` varchar(40) default NULL,
