数据库脚本.txt

新闻系统 1

CREATE TABLE `message` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `message` text,
  `title` varchar(200) DEFAULT NULL,
  `ip` varchar(50) DEFAULT NULL,
  `mail` varchar(200) DEFAULT NULL,
  `web` varchar(100) DEFAULT NULL,
  `qq` varchar(100) DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=gb2312;





CREATE TABLE `new_kind` (
  `kindid` int(11) NOT NULL AUTO_INCREMENT,
  `kindname` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`kindid`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=gb2312;




CREATE TABLE `news` (
  `newsid` bigint(20) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) DEFAULT NULL,
  `pub_time` datetime DEFAULT NULL,
  `content` text,
  `kind` varchar(100) DEFAULT NULL,
  `creator` varchar(100) DEFAULT NULL,
  `ispub` tinyint(4) DEFAULT '1',
  PRIMARY KEY (`newsid`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=gb2312;



CREATE TABLE `news_file` (
  `nfid` bigint(20) NOT NULL AUTO_INCREMENT,
  `newsid` varchar(50) NOT NULL,
  `filename1` varchar(100) DEFAULT NULL,
  `filename2` varchar(100) DEFAULT NULL,
  `filesize` bigint(20) DEFAULT NULL,
  `extension` varchar(10) DEFAULT NULL,
  `creator` varchar(100) DEFAULT NULL,
  `pub_time` datetime DEFAULT NULL,
  `filepath` varchar(250) DEFAULT NULL,
  `explain` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`nfid`)
) ENGINE=InnoDB AUTO_INCREMENT=138 DEFAULT CHARSET=gb2312;




CREATE TABLE `news_log` (
  `nlid` bigint(20) NOT NULL AUTO_INCREMENT,
  `newsid` varchar(50) NOT NULL,
  `ipadd` varchar(20) DEFAULT NULL,
  `readtime` datetime DEFAULT NULL,
  `session` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`nlid`)
) ENGINE=InnoDB AUTO_INCREMENT=541 DEFAULT CHARSET=gb2312;



CREATE TABLE `user` (
  `userID` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) DEFAULT NULL,
  `password` varchar(130) DEFAULT NULL,
  `popedom` tinyint(4) DEFAULT '1',
  PRIMARY KEY (`userID`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gb2312;