ntsky.txt

来自「NTsky新闻发布v1.0(提供JavaBean)」· 文本 代码 · 共 65 行

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