drop database nt;
create database nt;
use nt;
create table admin(username varchar(20) NOT NULL,
                      password varchar(20) NOT NULL,
                      passwordValidate varchar(20) NOT NULL,
                      name varchar(20),
                      email varchar(20),
                      ip varchar(20),
                      articlenumb int,
                      purview varchar(20),
                      loadtime datetime,
                      primary key(username),
                      );

create table class(id int NOT NULL,
                      classid int NOT NULL,
                      content varchar(255) NOT NULL,
                      flag int,
                      primary key(id,classid),
                      );

create table article(articleid int NOT NULL auto_increment,
                      myorothers int NOT NULL,
                      bigclass int NOT NULL,
                      smallclass 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,
                      flag int,
                      date datetime,
                      primary key(articleid),
                      );

create table repay(username varchar(20),
                      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');
                      