news.sql

来自「用jsp实现的新闻管理小系统」· SQL 代码 · 共 37 行

# Dumping Table class
#
CREATE TABLE class (
	id int(4) NOT NULL  auto_increment, 
	name varchar(20) NOT NULL  , 
	master varchar(20)    ,
	PRIMARY KEY (id)	
) ;

# Dumping Table master
#
CREATE TABLE master (
	id int(4) NOT NULL  auto_increment, 
	name varchar(20) NOT NULL  , 
	pass varchar(16) NOT NULL  , 
	total int(10) NOT NULL  DEFAULT '0' , 
	joindate varchar(10) NOT NULL  DEFAULT '0000-00-00' , 
	classid int(4) NOT NULL  DEFAULT '0' , 
	loginnum int(10) NOT NULL  DEFAULT '0'  ,
	PRIMARY KEY (id)	
) ;

# Dumping Table news
#
CREATE TABLE news (
	id int(10) NOT NULL  auto_increment, 
	topic varchar(255) NOT NULL  , 
	body text NOT NULL  , 
	hits int(10) NOT NULL  DEFAULT '0' , 
	adddate varchar(30) NOT NULL  DEFAULT '0000-00-00 00:00:00' , 
	adduser varchar(20) NOT NULL  , 
	rootid int(4) NOT NULL  DEFAULT '0' , 
	pic varchar(100)    ,
	PRIMARY KEY (id)	
) ;

INSERT INTO master ( name,pass,joindate,classid ) VALUES ( "admin","admin","2003-03-08",0 );