drop database ntsky;
create database ntsky;
use ntsky;
//û(ظеû)(ظ»ظ)
create table admin(username varchar(20) NOT NULL,//û(ֻĸ)
			password varchar(20) NOT NULL,//
			passwordValidate varchar(20) NOT NULL,//֤
			name varchar(20),//ʵ(ĸ)(ȥ)
                        email varchar(20),//email
			ip varchar(20),//½IP(ȥֱʾͿ)
			loadtime datatime,//½ʱ(д)
                        purview varchar(20),//Ȩ
                        articlenumb int,//
                        primary key(username),
                     	)
//ݿȡ
create table class(id int NOT NULL,//
			classid int NOT NULL auto_increment,//
			content varchar(255),//ľ
			flag int,//־(Ӧŵչ)
                        primary key(id,classid),
			)
//·
create table article(articleid int NOT NULL auto_increment,//Զ(ԸжϣҪ߷иԭת֮)
			bigclass int NOT NULL,//
			smallclass int NOT NULL,//
			myorothers int NOT NULL,
			title varchar(255) NOT NULL,//±
			content text NOT NULL,//
			connection varchar(255),//ص
			author varchar(20) NOT NULL,//
			articlefrom varchar(40),//
                        hits int,//
                        top int,//Ƿö(0,1)
                        flag int,//ǷԷ٣
			date datetime,//ʱ
			primary key(articleid),
                        )
//ظ
create table repay(username varchar(20),//û(Чcsdn)
                   passwd varchar(20),//
		   article varchar(255),//ظ
		   content TEXT,//ظ
		   )
INSERT INTO class(id,classid,content) VALUES(1,1,'LINUX');
INSERT INTO class(id,classid,content) VALUES(1,2,'');
INSERT INTO class(id,classid,content) VALUES(1,3,'Ӧÿ');
INSERT INTO class(id,classid,content) VALUES(1,4,'ݿӦ');
INSERT INTO class(id,classid,content) VALUES(1,5,'ϵͳȫ');
INSERT INTO class(id,classid,content) VALUES(1,6,'download');

INSERT INTO class(id,classid,content) VALUES(2,1,'ϵͳԱ');//Ժ
INSERT INTO class(id,classid,content) VALUES(2,2,'Ա');
INSERT INTO class(id,classid,content,flag) VALUES(3,1,'windows',2);
INSERT INTO class(id,classid,content,flag) VALUES(3,2,'linux',2);
INSERT INTO class(id,classid,content,flag) VALUES(3,3,'unix',2);
INSERT INTO class(id,classid,content,flag) VALUES(4,1,'java',3);
INSERT INTO class(id,classid,content,flag) VALUES(4,2,'jsp',3);
INSERT INTO class(id,classid,content,flag) VALUES(5,1,'MSSQL',4);
INSERT INTO class(id,classid,content,flag) VALUES(5,2,'mysql',4);
INSERT INTO class(id,classid,content,flag) VALUES(5,3,'oracle',4);
INSERT INTO class(id,classid,content,flag) VALUES(6,1,'ȫ',5);
INSERT INTO class(id,classid,content,flag) VALUES(6,2,'©',5);
INSERT INTO admin(username,password) VALUES('ntsky','ntsky');
INSERT INTO admin(username,password) VALUES('yao','junlin');

û½Ļκû

ж߷µû½ʱһsession


ͬȨҲдݿ޸ľokˡ







