www.pudn.com > 2_15692.zip > news.sql

# 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 );