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,
                      purview int not null,
                      primary key(username),
                      );

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

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

create table article(articleid int NOT NULL auto_increment,
                      myorothers int NOT NULL,
                      classid int NOT NULL,
                      id int NOT NULL,
                      title varchar(255) NOT NULL,
                      content text NOT NULL,
                      connection varchar(255),
                      author varchar(20) NOT NULL,
                      editor varchar(20),
                      articlefrom varchar(40),
                      hits int default 0,
                      top int,
                      state int default 0,
                      tag int NOT NULL,
                      date date,
                      time datetime,
                      primary key(articleid),
                      );

create table reply(id int not null auto_increment,
                      articleid int not null,
                      user varchar(20),
                      content varchar(100),
                      date date,
                      time datetime,
                      primary key(id),
                      );

create table usr(user varchar(20) NOT NULL,
                      passwd varchar(20) NOT NULL,
                      passwdvalidate varchar(20) NOT NULL,
                      sex int,
                      question varchar(255),
                      answer varchar(255),
                      email varchar(50),
                      qq varchar(10),
                      http varchar(30),
                      purview int,
                      loadtime datetime,
                      primary key(user),
                      );

create table popedom(gradeid int not null,
                      grade varchar(20),
                      primary key(gradeid),
                      );

create table common(counter int not null,
                    );

insert into class(classid,content) values(1,'linux');
insert into class(classid,content) values(2,'');
insert into class(classid,content) values(3,'Ӧÿ');
insert into class(classid,content) values(4,'ݿӦ');
INSERT INTO class(classid,content) VALUES(5,'ϵͳȫ');

insert into kind(id,content,classid) values(1,'windows',2);
insert into kind(id,content,classid) values(2,'linux',2);
insert into kind(id,content,classid) values(3,'unix',2);
insert into kind(id,content,classid) values(4,'jsp',3);
insert into kind(id,content,classid) values(5,'java',3);
insert into kind(id,content,classid) values(6,'xml',3);
insert into kind(id,content,classid) values(7,'delphi',3);
insert into kind(id,content,classid) values(8,'.net',3);
insert into kind(id,content,classid) values(9,'oracle',4);
insert into kind(id,content,classid) values(10,'mysql',4);
insert into kind(id,content,classid) values(11,'mssql',4);
insert into kind(id,content,classid) values(12,'ȫ',5);
insert into kind(id,content,classid) values(13,'©',5);
insert into kind(id,content,classid) values(14,'linux̳',1);
insert into kind(id,content,classid) values(15,'ѧϰʼ',1);

insert into popedom(gradeid,grade) values(3,'ƻԱ');
insert into popedom(gradeid,grade) values(2,'ƻԱ');
insert into popedom(gradeid,grade) values(1,'ͨԱ');
INSERT INTO admin(username,password,purview) VALUES('ntsky','ntsky',0);
INSERT INTO admin(username,password,purview) VALUES('yao','junlin',0);

                