【SQL开源代码栏目提醒】:网学会员在SQL开源代码频道为大家收集整理了新闻系统数据库及表创建脚本.sql提供大家参考,希望对大家有所帮助!
create database if not exists `nmsdb`;
CREATE TABLE `column_info` (
`column_id` int(2) NOT NULL auto_increment,
`name` varchar(20) NOT NULL default '?',
`priority` char(1) NOT NULL default '0',
`description` varchar(100) default '?',
`display_flag` char(1) NOT NULL default '1',
PRIMARY KEY (`column_id`)
) DEFAULT CHARSET=gbk;
CREATE TABLE `comment_info` (
`comment_id` int(10) NOT NULL auto_increment,
`news_id` int(10) NOT NULL default '0',
`title` varchar(30) NOT NULL default '',
`content` varchar(200) NOT NULL default '?',
`agree_num` int(10) default '0',
`oppose_num` int(10) default '0',
`add_time` date default NULL,
`author` varchar(10) default NULL,
PRIMARY KEY (`comment_id`)
) DEFAULT CHARSET=gbk;
drop table if exists `news_info`;
CREATE TABLE `news_info` (
`news_id` int(10) NOT NULL auto_increment,
`title` varchar(30) NOT NULL default '?',
`content` text,
`browse_num` bigint(20) default '0',
`column_id` int(2) NOT NULL default '0',
`add_time` date default NULL,
`quarry` varchar(20) default NULL,
`author` varchar(10) default NULL,
`display_flag` char(1) NOT NULL default '1',
PRIMARY KEY (`news_id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
CREATE TABLE `user_info` (
`user_id` varchar(10) NOT NULL default '',
`pass
word` varchar(10) default NULL,
`name` varchar(10) default NULL,
`description` varchar(100) default NULL,
PRIMARY KEY (`user_id`)
) DEFAULT CHARSET=gbk;
commit;