install.php

这是一个人才招聘网站的程序

$sql = <<<EOT

DROP TABLE IF EXISTS wsfuyibing_find_fav;
CREATE TABLE wsfuyibing_find_fav (
   id int(11) NOT NULL auto_increment,
   user_id varchar(50) NOT NULL,
   find_id varchar(12) NOT NULL,
   mem_id varchar(50) NOT NULL,
   addtime varchar(12) NOT NULL,
   sign char(2) NOT NULL,
   PRIMARY KEY (id)
);


DROP TABLE IF EXISTS wsfuyibing_findjob_chance;
CREATE TABLE wsfuyibing_findjob_chance (
   id int(12) NOT NULL auto_increment,
   username varchar(30) NOT NULL,
   job varchar(50) NOT NULL,
   puttime int(12) NOT NULL,
   losetime int(12) NOT NULL,
   contact_name varchar(10) NOT NULL,
   contact_phone varchar(30) NOT NULL,
   interest varchar(255) NOT NULL,
   well varchar(255) NOT NULL,
   jobtext text NOT NULL,
   work_address varchar(100) NOT NULL,
   sign char(2) NOT NULL,
   click int(12) NOT NULL,
   PRIMARY KEY (id)
);

DROP TABLE IF EXISTS wsfuyibing_hunter_com;
CREATE TABLE wsfuyibing_hunter_com (
   id int(12) NOT NULL auto_increment,
   username varchar(50) NOT NULL,
   job varchar(100) NOT NULL,
   job_text text NOT NULL,
   job_address varchar(255) NOT NULL,
   com varchar(100) NOT NULL,
   com_text text NOT NULL,
   com_address varchar(255) NOT NULL,
   code varchar(12) NOT NULL,
   url varchar(80) NOT NULL,
   email varchar(80) NOT NULL,
   contact_name varchar(80) NOT NULL,
   phone varchar(80) NOT NULL,
   fax varchar(80) NOT NULL,
   addtime varchar(12) NOT NULL,
   sign char(2) NOT NULL,
   click int(12) DEFAULT '1' NOT NULL,
   PRIMARY KEY (id)
);


DROP TABLE IF EXISTS wsfuyibing_hunter_info;
CREATE TABLE wsfuyibing_hunter_info (
   id int(12) NOT NULL auto_increment,
   title varchar(255) NOT NULL,
   itfrom varchar(100) NOT NULL,
   context text NOT NULL,
   addtime varchar(12) NOT NULL,
   click int(12) DEFAULT '1' NOT NULL,
   PRIMARY KEY (id)
);


DROP TABLE IF EXISTS wsfuyibing_hunter_per;
CREATE TABLE wsfuyibing_hunter_per (
   id int(12) NOT NULL auto_increment,
   username varchar(40) NOT NULL,
   truename varchar(40) NOT NULL,
   year_pay varchar(100) NOT NULL,
   industry varchar(250) NOT NULL,
   year_pay_for varchar(100) NOT NULL,
   position varchar(100) NOT NULL,
   for_position varchar(100) NOT NULL,
   mobile varchar(22) NOT NULL,
   address varchar(255) NOT NULL,
   phone varchar(20) NOT NULL,
   code varchar(12) NOT NULL,
   email varchar(100) NOT NULL,
   linktime varchar(100) NOT NULL,
   sex varchar(10) NOT NULL,
   birth varchar(40) NOT NULL,
   sidcard varchar(36) NOT NULL,
   marry varchar(20) NOT NULL,
   hukou varchar(100) NOT NULL,
   living varchar(100) NOT NULL,
   forliving varchar(100) NOT NULL,
   edu varchar(40) NOT NULL,
   graedu varchar(50) NOT NULL,
   depart varchar(40) NOT NULL,
   train text NOT NULL,
   workexp text NOT NULL,
   enable text NOT NULL,
   context text NOT NULL,
   addtime varchar(12) NOT NULL,
   sign char(2) NOT NULL,
   click int(12) DEFAULT '1' NOT NULL,
   PRIMARY KEY (id)
);


DROP TABLE IF EXISTS wsfuyibing_index_ad;
CREATE TABLE wsfuyibing_index_ad (
   id int(12) NOT NULL auto_increment,
   leixing int(3) NOT NULL,
   title varchar(50) NOT NULL,
   img varchar(100) NOT NULL,
   url varchar(100) NOT NULL,
   addtime varchar(12) NOT NULL,
   PRIMARY KEY (id)
);

DROP TABLE IF EXISTS wsfuyibing_index_news;
CREATE TABLE wsfuyibing_index_news (
   id int(12) NOT NULL auto_increment,
   title varchar(255) NOT NULL,
   context text NOT NULL,
   addtime varchar(10) NOT NULL,
   click int(12) DEFAULT '1' NOT NULL,
   PRIMARY KEY (id)
);


DROP TABLE IF EXISTS wsfuyibing_index_news_re;
CREATE TABLE wsfuyibing_index_news_re (
   id int(12) NOT NULL auto_increment,
   news_id varchar(12) NOT NULL,
   context text NOT NULL,
   addtime varchar(12) NOT NULL,
   PRIMARY KEY (id)
);


DROP TABLE IF EXISTS wsfuyibing_jianli;
CREATE TABLE wsfuyibing_jianli (
   id int(20) NOT NULL auto_increment,
   username varchar(50) NOT NULL,
   truename varchar(20) NOT NULL,
   sex varchar(10) NOT NULL,
   mingzu varchar(30) NOT NULL,

   birth varchar(20) NOT NULL,
   hukou varchar(255) NOT NULL,
   juzhudi varchar(255) NOT NULL,
   shengfengzhen varchar(36) NOT NULL,
   marry varchar(10) NOT NULL,
   social varchar(20) NOT NULL,
   height varchar(5) NOT NULL,
   weight varchar(5) NOT NULL,
   ear varchar(10) NOT NULL,
   jobtoknow varchar(10) NOT NULL,
   money varchar(9) NOT NULL,
   graedu varchar(100) NOT NULL,
   edu varchar(100) NOT NULL,
   graedutime varchar(30) NOT NULL,
   zhuanye varchar(100) NOT NULL,
   zhuanyename varchar(50) NOT NULL,
   phone varchar(22) NOT NULL,
   handphone varchar(22) NOT NULL,
   comphone varchar(22) NOT NULL,
   email varchar(50) NOT NULL,
   qq varchar(30) NOT NULL,
   address varchar(255) NOT NULL,
   youbian varchar(12) NOT NULL,
   homepage varchar(100) NOT NULL,
   jobpro varchar(50) NOT NULL,
   formoney varchar(20) NOT NULL,
   forjob varchar(50) NOT NULL,
   jobkind varchar(50) NOT NULL,
   compro varchar(50) NOT NULL,
   jobaddress varchar(255) NOT NULL,
   forhouse varchar(20) NOT NULL,
   leavejobtime varchar(20) NOT NULL,
   workjingli text NOT NULL,
   engname varchar(20) NOT NULL,
   engnengli varchar(20) NOT NULL,
   edujingli text NOT NULL,
   zhengshu text NOT NULL,
   itable text NOT NULL,
   jiangli text NOT NULL,
   edushijian text NOT NULL,
   shijiankind varchar(100) NOT NULL,
   shijianname varchar(100) NOT NULL,
   shijianjianjie text NOT NULL,
   techang text NOT NULL,
   pingjia text NOT NULL,
   mem_img varchar(100) NOT NULL,
   sign char(2) NOT NULL,
   clicked int(12) NOT NULL,
   PRIMARY KEY (id)
);



DROP TABLE IF EXISTS wsfuyibing_jianliqy;
CREATE TABLE wsfuyibing_jianliqy (
   qyid int(12) NOT NULL auto_increment,
   qyuser varchar(50) NOT NULL,
   qyname varchar(255) NOT NULL,
   qyaddress varchar(255) NOT NULL,
   qypro varchar(40) NOT NULL,
   qykind varchar(100) NOT NULL,
   qyman varchar(12) NOT NULL,
   contact_name varchar(20) NOT NULL,
   qyphone varchar(255) NOT NULL,
   qyemail varchar(150) NOT NULL,
   qyyoubian varchar(24) NOT NULL,
   qyweb varchar(100) NOT NULL,
   qyjianjie text NOT NULL,
   qy_img varchar(100) NOT NULL,
   sign char(2) NOT NULL,
   clicked int(12) NOT NULL,
   PRIMARY KEY (qyid)
);


DROP TABLE IF EXISTS wsfuyibing_job_ad;
CREATE TABLE wsfuyibing_job_ad (
   id int(12) NOT NULL auto_increment,
   title varchar(50) NOT NULL,
   context text NOT NULL,
   PRIMARY KEY (id)
);



DROP TABLE IF EXISTS wsfuyibing_job_chance;
CREATE TABLE wsfuyibing_job_chance (
   id int(12) NOT NULL auto_increment,
   username varchar(30) NOT NULL,
   job varchar(200) NOT NULL,
   man varchar(20) NOT NULL,
   address varchar(255) NOT NULL,
   job_pro varchar(10) NOT NULL,
   job_time varchar(20) NOT NULL,
   age varchar(20) NOT NULL,
   sex varchar(20) NOT NULL,
   height varchar(20) NOT NULL,
   weight varchar(20) NOT NULL,
   sight varchar(20) NOT NULL,
   social varchar(10) NOT NULL,
   edu varchar(10) NOT NULL,
   eng varchar(10) NOT NULL,
   department varchar(20) NOT NULL,
   puttime int(12) NOT NULL,
   losetime int(12) NOT NULL,
   worktext text NOT NULL,
   money varchar(30) NOT NULL,
   sign char(2) NOT NULL,
   click int(12) DEFAULT '1' NOT NULL,
   PRIMARY KEY (id)
);



DROP TABLE IF EXISTS wsfuyibing_job_fav;
CREATE TABLE wsfuyibing_job_fav (
   id int(11) NOT NULL auto_increment,
   user_id varchar(50) NOT NULL,
   job_id varchar(12) NOT NULL,
   com_id varchar(50) NOT NULL,
   addtime varchar(12) NOT NULL,
   sign char(2) NOT NULL,
   PRIMARY KEY (id)
);




DROP TABLE IF EXISTS wsfuyibing_job_law;
CREATE TABLE wsfuyibing_job_law (
   id int(12) NOT NULL auto_increment,
   itfrom varchar(100) NOT NULL,
   title varchar(255) NOT NULL,
   context text NOT NULL,
   addtime varchar(12) NOT NULL,
   click int(12) DEFAULT '1' NOT NULL,
   PRIMARY KEY (id)
);



DROP TABLE IF EXISTS wsfuyibing_job_law_re;
CREATE TABLE wsfuyibing_job_law_re (
   id int(12) NOT NULL auto_increment,
   law_id varchar(12) NOT NULL,
   context text NOT NULL,
   addtime varchar(12) NOT NULL,
   PRIMARY KEY (id)
);



DROP TABLE IF EXISTS wsfuyibing_job_peixun;
CREATE TABLE wsfuyibing_job_peixun (
   id int(12) NOT NULL auto_increment,
   username varchar(50) NOT NULL,
   lesson varchar(100) NOT NULL,
   leixing varchar(50) NOT NULL,
   part varchar(100) NOT NULL,
   start_time varchar(100) NOT NULL,
   class_time varchar(100) NOT NULL,
   address varchar(255) NOT NULL,
   classs varchar(10) NOT NULL,
   teacher varchar(200) NOT NULL,
   money varchar(12) NOT NULL,
   direction text NOT NULL,
   content text NOT NULL,
   context text NOT NULL,
   contact_name varchar(20) NOT NULL,
   contact_phone varchar(50) NOT NULL,
   fax varchar(30) NOT NULL,
   email varchar(80) NOT NULL,
   url varchar(50) NOT NULL,
   puttime int(12) NOT NULL,
   losetime int(12) NOT NULL,
   click int(12) NOT NULL,
   sign int(2) NOT NULL,
   PRIMARY KEY (id)
);



DROP TABLE IF EXISTS wsfuyibing_job_peixunkind;
CREATE TABLE wsfuyibing_job_peixunkind (
   id int(12) NOT NULL,
   title varchar(50) NOT NULL
);



DROP TABLE IF EXISTS wsfuyibing_job_way;
CREATE TABLE wsfuyibing_job_way (
   id int(12) NOT NULL auto_increment,
   itfrom varchar(50) NOT NULL,
   title varchar(255) NOT NULL,
   context text NOT NULL,