sportcollege.sql

某高校的门户网站源码

create database sportcollege;

use sportcollege;
CREATE TABLE admin (
	id int(6) NOT NULL  auto_increment, 
	username varchar(50) NOT NULL  , 
	password varchar(32) NOT NULL  , 
	flag smallint(3) NOT NULL  DEFAULT '0'  ,
	PRIMARY KEY (id)	
) TYPE=MyISAM;

INSERT INTO admin VALUES(1,"admin","7FEF6171469E80D32C0559F88B377245",1);
INSERT INTO admin VALUES(2,"edit","213BF3C9C5B51F435BF9F1B6D04E578A",0);

CREATE TABLE class1 (
	id int(6) NOT NULL  auto_increment, 
	classname varchar(50) NOT NULL  , 
	parentid int(6) NOT NULL  DEFAULT '0' , 
	orders int(6) NOT NULL  DEFAULT '0'  ,
	PRIMARY KEY (id)	
) TYPE=MyISAM;

INSERT INTO class1 VALUES(1,"学院概况",1,0);
INSERT INTO class1 VALUES(2,"学院介绍",1,1);
INSERT INTO class1 VALUES(3,"机构设置",1,1);
INSERT INTO class1 VALUES(4,"场馆设施",1,1);
INSERT INTO class1 VALUES(5,"发展规划",1,1);

INSERT INTO class1 VALUES(6,"学科建设",6,0);
INSERT INTO class1 VALUES(7,"建设概况",6,6);
INSERT INTO class1 VALUES(8,"研究基地",6,6);
INSERT INTO class1 VALUES(9,"拓展中心",6,6);
INSERT INTO class1 VALUES(10,"信息中心",6,6);
INSERT INTO class1 VALUES(11,"规章制度",20,0);

INSERT INTO class1 VALUES(12,"教学科研",12,0);
INSERT INTO class1 VALUES(13,"专业教育",12,12);
INSERT INTO class1 VALUES(14,"公体教育",12,12);
INSERT INTO class1 VALUES(15,"科学研究",12,12);

INSERT INTO class1 VALUES(16,"群体竞赛",16,0);
INSERT INTO class1 VALUES(17,"群体活动",16,16);
INSERT INTO class1 VALUES(18,"训练竞赛",16,16);
INSERT INTO class1 VALUES(19,"体质测试",16,16);

INSERT INTO class1 VALUES(20,"党建工作",20,0);
INSERT INTO class1 VALUES(21,"党员发展",20,20);
INSERT INTO class1 VALUES(22,"党员教育",20,20);
INSERT INTO class1 VALUES(23,"党员风采",20,20);
INSERT INTO class1 VALUES(24,"党校在线",20,20);

INSERT INTO class1 VALUES(25,"学生天地",25,0);
INSERT INTO class1 VALUES(26,"思想教育",25,25);
INSERT INTO class1 VALUES(27,"心里教育",25,25);
INSERT INTO class1 VALUES(28,"就业导航",25,25);
INSERT INTO class1 VALUES(29,"事务管理",25,25);
INSERT INTO class1 VALUES(30,"校园文化",25,25);
INSERT INTO class1 VALUES(31,"学子风采",25,25);

INSERT INTO class1 VALUES(32,"校友往来",32,0);
INSERT INTO class1 VALUES(33,"校友联络",32,32);
INSERT INTO class1 VALUES(34,"校友风采",32,32);

INSERT INTO class1 VALUES(35,"动态消息",35,0);
INSERT INTO class1 VALUES(36,"消息公告",35,35);

CREATE TABLE news (
	id int(11) NOT NULL  auto_increment, 
	class int(6) NOT NULL  DEFAULT '0' , 
	editer varchar(50) NOT NULL  , 
	title varchar(255) NOT NULL  , 
	newsfile varchar(50) NOT NULL  , 
	date bigint(20) NOT NULL  DEFAULT '0'  ,
	PRIMARY KEY (id),
	KEY class (class)	
) TYPE=MyISAM;



create table updown(
id int(8) not null primary key auto_increment,
 
filename varchar(255) not null,

filecontent text not null

);



create table uppic(
id int(8) not null primary key auto_increment,
 
filename varchar(255) not null,

filecontent text not null,

pictype int(4) not null

);