仅作参考!
# Host: localhost Database : class# --------------------------------------------------------
#
# Table structure for table 'class_bbs'
#CREATE TABLE class_bbs (
bbs_id int(11) NOT NULL auto_increment,
bbs_title varchar(200) NOT NULL,
bbs_detail text NOT NULL,
bbs_time datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
user_name varchar(20) NOT NULL,
guest_tag tinyint(1) DEFAULT '0',
bbs_count int(11) DEFAULT '0',
bbs_replycount tinyint(4) DEFAULT '0',
bbs_lastreply varchar(20),
bbs_lasttime datetime,
class_id int(11) DEFAULT '0' NOT NULL,
bbs_icon tinyint(4),
PRIMARY KEY (bbs_id),
KEY user_name (user_name),
KEY class_id (class_id)
);
# --------------------------------------------------------
#
# Table structure for table 'class_class'
#CREATE TABLE class_class (
class_id int(11) NOT NULL auto_increment,
class_name varchar(50) NOT NULL,
school_id int(11) DEFAULT '0' NOT NULL,
class_province varchar(20),
user_id varchar(20) NOT NULL,
class_year int(4) DEFAULT '0' NOT NULL,
class_date date DEFAULT '0000-00-00',
class_url varchar(50),
user_total tinyint(4) DEFAULT '0' NOT NULL,
PRIMARY KEY (class_id, class_name),
KEY class_name (class_name, school_id)
);
# --------------------------------------------------------
#
# Table structure for table 'class_reply'
#CREATE TABLE class_reply (
reply_id int(11) NOT NULL auto_increment,
bbs_id int(11) DEFAULT '0' NOT NULL,
user_name varchar(20) NOT NULL,
bbs_detail text NOT NULL,
bbs_time datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
guest_tag tinyint(4) DEFAULT '0',
bbs_icon tinyint(4),
PRIMARY KEY (reply_id),
KEY bbs_id (bbs_id, user_name)
);
# --------------------------------------------------------
#
# Table structure for table 'class_school'
#CREATE TABLE class_school (
school_id int(11) NOT NULL auto_increment,
school_name varchar(200) NOT NULL,
school_province varchar(20) NOT NULL,
user_id varchar(20) NOT NULL,
school_url varchar(100),
school_zip varchar(10),
school_type varchar(20) DEFAULT '本科',
school_addr varchar(255),
school_time datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
PRIMARY KEY (school_id),
KEY school_id (school_id, school_name)
);
# --------------------------------------------------------
#
# Table structure for table 'class_system'
#CREATE TABLE class_system (
system_id int(11) NOT NULL auto_increment,
system_title varchar(255) NOT NULL,
system_detail varchar(255) NOT NULL,
system_time datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
system_term tinyint(4) DEFAULT '1',
user_id varchar(50) DEFAULT '站长',
system_broad varchar(255),
PRIMARY KEY (system_id),
KEY system_title (system_title)
);
# --------------------------------------------------------
#
# Table structure for table 'class_user'
#CREATE TABLE class_user (
user_id varchar(20) NOT NULL,
user_name varchar(20),
user_pass varchar(20) NOT NULL,
user_sex varchar(10) DEFAULT '男',
user_question varchar(50),
user_answer varchar(50),
user_email varchar(50),
user_homepage varchar(100),
user_icq varchar(20),
user_oicq varchar(20),
user_phone varchar(20),
user_regdate date DEFAULT '0000-00-00' NOT NULL,
user_pin varchar(20),
user_logdate date DEFAULT '0000-00-00' NOT NULL,
user_loginip varchar(20),
class_id int(11) DEFAULT '0' NOT NULL,
school_id int(11) DEFAULT '0' NOT NULL,
user_sign varchar(255),
user_portable varchar(20),
user_call varchar(100),
user_count int(10) DEFAULT '0',
user_work varchar(100),
user_addr varchar(255),
user_tag tinyint(1) DEFAULT '0',
thread_count int(11) DEFAULT '0',
user_icon varchar(255),
KEY user_id (user_id, class_id),
KEY school_id (school_id),
KEY class_id (class_id)
);
# Host: localhost Database : class# --------------------------------------------------------
#
# Table structure for table 'class_bbs'
#CREATE TABLE class_bbs (
bbs_id int(11) NOT NULL auto_increment,
bbs_title varchar(200) NOT NULL,
bbs_detail text NOT NULL,
bbs_time datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
user_name varchar(20) NOT NULL,
guest_tag tinyint(1) DEFAULT '0',
bbs_count int(11) DEFAULT '0',
bbs_replycount tinyint(4) DEFAULT '0',
bbs_lastreply varchar(20),
bbs_lasttime datetime,
class_id int(11) DEFAULT '0' NOT NULL,
bbs_icon tinyint(4),
PRIMARY KEY (bbs_id),
KEY user_name (user_name),
KEY class_id (class_id)
);
# --------------------------------------------------------
#
# Table structure for table 'class_class'
#CREATE TABLE class_class (
class_id int(11) NOT NULL auto_increment,
class_name varchar(50) NOT NULL,
school_id int(11) DEFAULT '0' NOT NULL,
class_province varchar(20),
user_id varchar(20) NOT NULL,
class_year int(4) DEFAULT '0' NOT NULL,
class_date date DEFAULT '0000-00-00',
class_url varchar(50),
user_total tinyint(4) DEFAULT '0' NOT NULL,
PRIMARY KEY (class_id, class_name),
KEY class_name (class_name, school_id)
);
# --------------------------------------------------------
#
# Table structure for table 'class_reply'
#CREATE TABLE class_reply (
reply_id int(11) NOT NULL auto_increment,
bbs_id int(11) DEFAULT '0' NOT NULL,
user_name varchar(20) NOT NULL,
bbs_detail text NOT NULL,
bbs_time datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
guest_tag tinyint(4) DEFAULT '0',
bbs_icon tinyint(4),
PRIMARY KEY (reply_id),
KEY bbs_id (bbs_id, user_name)
);
# --------------------------------------------------------
#
# Table structure for table 'class_school'
#CREATE TABLE class_school (
school_id int(11) NOT NULL auto_increment,
school_name varchar(200) NOT NULL,
school_province varchar(20) NOT NULL,
user_id varchar(20) NOT NULL,
school_url varchar(100),
school_zip varchar(10),
school_type varchar(20) DEFAULT '本科',
school_addr varchar(255),
school_time datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
PRIMARY KEY (school_id),
KEY school_id (school_id, school_name)
);
# --------------------------------------------------------
#
# Table structure for table 'class_system'
#CREATE TABLE class_system (
system_id int(11) NOT NULL auto_increment,
system_title varchar(255) NOT NULL,
system_detail varchar(255) NOT NULL,
system_time datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
system_term tinyint(4) DEFAULT '1',
user_id varchar(50) DEFAULT '站长',
system_broad varchar(255),
PRIMARY KEY (system_id),
KEY system_title (system_title)
);
# --------------------------------------------------------
#
# Table structure for table 'class_user'
#CREATE TABLE class_user (
user_id varchar(20) NOT NULL,
user_name varchar(20),
user_pass varchar(20) NOT NULL,
user_sex varchar(10) DEFAULT '男',
user_question varchar(50),
user_answer varchar(50),
user_email varchar(50),
user_homepage varchar(100),
user_icq varchar(20),
user_oicq varchar(20),
user_phone varchar(20),
user_regdate date DEFAULT '0000-00-00' NOT NULL,
user_pin varchar(20),
user_logdate date DEFAULT '0000-00-00' NOT NULL,
user_loginip varchar(20),
class_id int(11) DEFAULT '0' NOT NULL,
school_id int(11) DEFAULT '0' NOT NULL,
user_sign varchar(255),
user_portable varchar(20),
user_call varchar(100),
user_count int(10) DEFAULT '0',
user_work varchar(100),
user_addr varchar(255),
user_tag tinyint(1) DEFAULT '0',
thread_count int(11) DEFAULT '0',
user_icon varchar(255),
KEY user_id (user_id, class_id),
KEY school_id (school_id),
KEY class_id (class_id)
);
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货