sql.txt

网络同学录程序

# phpMyAdmin MySQL-Dump
# http://phpwizard.net/phpMyAdmin/
#
# Host: localhost Database : class

# --------------------------------------------------------
#
# Table structure for table 'class_class'
#

DROP TABLE IF EXISTS class_class;
CREATE TABLE class_class (
   classid varchar(15) NOT NULL,
   schoolid int(11),
   classname varchar(20),
   regtime varchar(20),
   regnum int(11),
   managerid varchar(20),
   UNIQUE XPKClass (classid)
);


# --------------------------------------------------------
#
# Table structure for table 'class_classlyb'
#

DROP TABLE IF EXISTS class_classlyb;
CREATE TABLE class_classlyb (
   id int(18) DEFAULT '0' NOT NULL auto_increment,
   classid varchar(16) NOT NULL,
   dateandtime varchar(20),
   userid varchar(20),
   title varchar(20) NOT NULL,
   content varchar(255),
   UNIQUE XPKClassLYB (id, classid)
);


# --------------------------------------------------------
#
# Table structure for table 'class_classuser'
#

DROP TABLE IF EXISTS class_classuser;
CREATE TABLE class_classuser (
   userid varchar(20) NOT NULL,
   pass varchar(16),
   username varchar(10),
   folk char(1),
   birth varchar(10),
   useremail varchar(40),
   degree varchar(10),
   question varchar(40),
   answer varchar(40),
   UNIQUE XPKClassUSer (userid)
);


# --------------------------------------------------------
#
# Table structure for table 'class_photoupload'
#

DROP TABLE IF EXISTS class_photoupload;
CREATE TABLE class_photoupload (
   id int(11) DEFAULT '0' NOT NULL auto_increment,
   classid varchar(16) NOT NULL,
   dateandtime varchar(18),
   filename varchar(200) NOT NULL,
   Introduction varchar(80),
   userid varchar(20),
   PRIMARY KEY (id, classid, id, classid)
);


# --------------------------------------------------------
#
# Table structure for table 'class_school'
#

DROP TABLE IF EXISTS class_school;
CREATE TABLE class_school (
   schoolid int(11) DEFAULT '0' NOT NULL auto_increment,
   schoolname varchar(40) NOT NULL,
   schooltype varchar(20),
   schoolprovince varchar(20),
   schoolcity varchar(20),
   regtime varchar(20),
   classnum int(11),
   UNIQUE XPKSChool (schoolid)
);


# --------------------------------------------------------
#
# Table structure for table 'class_userinfo'
#

DROP TABLE IF EXISTS class_userinfo;
CREATE TABLE class_userinfo (
   userid varchar(20) NOT NULL,
   pager varchar(20),
   addr varchar(80),
   postcode varchar(6),
   mailaddr varchar(80),
   likesay varchar(200),
   other varchar(200),
   PRIMARY KEY (userid)
);


# --------------------------------------------------------
#
# Table structure for table 'class_userrelation'
#

DROP TABLE IF EXISTS class_userrelation;
CREATE TABLE class_userrelation (
   userid varchar(20),
   classid varchar(15),
   login int(11),
   lasttime varchar(18),
   regtime varchar(20)
);