install.php

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

   addtime varchar(12) NOT NULL,
   click int(12) DEFAULT '1' NOT NULL,
   PRIMARY KEY (id,click)
);


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


DROP TABLE IF EXISTS wsfuyibing_jobs;
CREATE TABLE wsfuyibing_jobs (
   id int(12) NOT NULL auto_increment,
   username varchar(30) NOT NULL,
   part varchar(200) 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_links;
CREATE TABLE wsfuyibing_links (
   id int(12) NOT NULL auto_increment,
   title varchar(50) NOT NULL,
   img varchar(200) NOT NULL,
   url varchar(200) NOT NULL,
   context varchar(50) NOT NULL,
   PRIMARY KEY (id)
);

INSERT INTO wsfuyibing_links VALUES('1', 'E皖南网', 'http://www.ewannan.com/e.gif', 'http://www.ah0553.com', '皖易网络科技中心');



DROP TABLE IF EXISTS wsfuyibing_member;
CREATE TABLE wsfuyibing_member (
   id int(12) NOT NULL auto_increment,
   username varchar(50) NOT NULL,
   password varchar(50) NOT NULL,
   email varchar(100) NOT NULL,
   kind char(2) NOT NULL,
   question varchar(200) NOT NULL,
   answer varchar(200) NOT NULL,
   regtime varchar(10) NOT NULL,
   losetime int(12) NOT NULL,
   logins varchar(12) DEFAULT '1' NOT NULL,
   qyname varchar(100) NOT NULL,
   contact_name varchar(50) NOT NULL,
   contact_phone varchar(50) NOT NULL,
   PRIMARY KEY (id)
);



DROP TABLE IF EXISTS wsfuyibing_menu;
CREATE TABLE wsfuyibing_menu (
   id int(12) NOT NULL auto_increment,
   menu varchar(20) NOT NULL,
   url varchar(100) NOT NULL,
   PRIMARY KEY (id)
);




DROP TABLE IF EXISTS wsfuyibing_per_rec;
CREATE TABLE wsfuyibing_per_rec (
   id int(12) NOT NULL auto_increment,
   user_id varchar(50) NOT NULL,
   per_id varchar(50) NOT NULL,
   find_id varchar(12) NOT NULL,
   title varchar(50) NOT NULL,
   context text NOT NULL,
   addtime varchar(40) NOT NULL,
   click int(12) NOT NULL,
   PRIMARY KEY (id)
);



DROP TABLE IF EXISTS wsfuyibing_per_send;
CREATE TABLE wsfuyibing_per_send (
   id int(12) NOT NULL auto_increment,
   user_id varchar(50) NOT NULL,
   com_id varchar(50) NOT NULL,
   job_id varchar(12) NOT NULL,
   title varchar(50) NOT NULL,
   context text NOT NULL,
   addtime varchar(12) NOT NULL,
   click int(12) NOT NULL,
   PRIMARY KEY (id)
);


DROP TABLE IF EXISTS wsfuyibing_public;
CREATE TABLE wsfuyibing_public (
   id int(12) NOT NULL auto_increment,
   title varchar(100) 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_pxschool;
CREATE TABLE wsfuyibing_pxschool (
   id int(12) NOT NULL auto_increment,
   username varchar(50) NOT NULL,
   schkind char(3) NOT NULL,
   sname varchar(100) NOT NULL,
   context text NOT NULL,
   content text NOT NULL,
   sign_content text NOT NULL,
   contact_name varchar(50) NOT NULL,
   contact_phone varchar(80) NOT NULL,
   fax varchar(80) NOT NULL,
   address varchar(255) NOT NULL,
   code varchar(12) NOT NULL,
   email varchar(80) NOT NULL,
   url varchar(50) NOT NULL,
   click int(12) NOT NULL,
   PRIMARY KEY (id)
);



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

INSERT INTO wsfuyibing_pxschool_kind VALUES('1', '计算机');
INSERT INTO wsfuyibing_pxschool_kind VALUES('2', '美容美发');
INSERT INTO wsfuyibing_pxschool_kind VALUES('3', '驾驶员培训');
INSERT INTO wsfuyibing_pxschool_kind VALUES('4', '厨师培训');
INSERT INTO wsfuyibing_pxschool_kind VALUES('5', '外语培训');
INSERT INTO wsfuyibing_pxschool_kind VALUES('6', '音乐培训');
INSERT INTO wsfuyibing_pxschool_kind VALUES('7', '舞蹈培训');
INSERT INTO wsfuyibing_pxschool_kind VALUES('8', '职业技能培训');
INSERT INTO wsfuyibing_pxschool_kind VALUES('9', '其它学校');



DROP TABLE IF EXISTS wsfuyibing_re_rec;
CREATE TABLE wsfuyibing_re_rec (
   id int(12) NOT NULL auto_increment,
   mail_id varchar(12) NOT NULL,
   title varchar(100) NOT NULL,
   context text NOT NULL,
   addtime varchar(40) NOT NULL,
   PRIMARY KEY (id)
);



DROP TABLE IF EXISTS wsfuyibing_re_send;
CREATE TABLE wsfuyibing_re_send (
   id int(12) NOT NULL auto_increment,
   mail_id varchar(12) NOT NULL,
   title varchar(100) NOT NULL,
   context text NOT NULL,
   addtime varchar(40) NOT NULL,
   PRIMARY KEY (id)
);


DROP TABLE IF EXISTS wsfuyibing_send_hunter_com;
CREATE TABLE wsfuyibing_send_hunter_com (
   id int(12) NOT NULL auto_increment,
   info_id varchar(12) NOT NULL,
   rec varchar(50) NOT NULL,
   send varchar(50) NOT NULL,
   truename varchar(20) NOT NULL,
   induestry varchar(50) NOT NULL,
   edu varchar(50) NOT NULL,
   depart varchar(50) NOT NULL,
   workexp text NOT NULL,
   enable text NOT NULL,
   context text NOT NULL,
   contact_name varchar(20) NOT NULL,
   contact_phone varchar(40) NOT NULL,
   email varchar(50) NOT NULL,
   addtime varchar(12) NOT NULL,
   PRIMARY KEY (id)
);

DROP TABLE IF EXISTS wsfuyibing_send_hunter_per;
CREATE TABLE wsfuyibing_send_hunter_per (
   id int(12) NOT NULL auto_increment,
   info_id varchar(12) NOT NULL,
   rec varchar(50) NOT NULL,
   send varchar(50) NOT NULL,
   job varchar(200) NOT NULL,
   com varchar(200) NOT NULL,
   job_address varchar(255) NOT NULL,
   contact_name varchar(100) NOT NULL,
   contact_phone varchar(100) NOT NULL,
   email varchar(100) NOT NULL,
   addtime varchar(12) NOT NULL,
   PRIMARY KEY (id)
);


DROP TABLE IF EXISTS wsfuyibing_teach_find;
CREATE TABLE wsfuyibing_teach_find (
   id int(12) NOT NULL auto_increment,
   username varchar(50) NOT NULL,
   title varchar(200) NOT NULL,
   sex varchar(8) NOT NULL,
   edu varchar(20) NOT NULL,
   depart varchar(50) NOT NULL,
   content text NOT NULL,
   context text NOT NULL,
   address varchar(255) NOT NULL,
   contact_name varchar(50) NOT NULL,
   contact_phone varchar(50) NOT NULL,
   email varchar(50) NOT NULL,
   puttime int(12) NOT NULL,
   losetime int(12) NOT NULL,
   sign varchar(5) NOT NULL,
   click int(12) DEFAULT '1' NOT NULL,
   PRIMARY KEY (id)
);


DROP TABLE IF EXISTS wsfuyibing_teach_take;
CREATE TABLE wsfuyibing_teach_take (
   id int(12) NOT NULL auto_increment,
   username varchar(50) NOT NULL,
   title varchar(200) NOT NULL,
   truename varchar(20) NOT NULL,
   sex varchar(4) NOT NULL,
   edu varchar(30) NOT NULL,
   depart varchar(50) NOT NULL,
   living varchar(255) NOT NULL,
   job varchar(100) NOT NULL,
   context text NOT NULL,
   phone varchar(40) NOT NULL,
   email varchar(50) NOT NULL,
   puttime int(12) NOT NULL,
   losetime int(12) NOT NULL,
   sign varchar(5) NOT NULL,
   click int(12) DEFAULT '1' NOT NULL,
   PRIMARY KEY (id)
);


EOT;

        runquery($sql);
        $db->query("DELETE FROM {$tablepre}member");
        $regtime=time();
        $db->query("INSERT INTO {$tablepre}member (username, password, email, kind, regtime)
                VALUES ('$username', '".md5($password1)."','$email', '$kind_admin', '$regtime');");

echo"          </td>\n";
echo"        </tr>\n";
echo"        <tr>\n";
echo"          <td>\n";
echo"            <hr noshade align=\"center\" width=\"100%\" size=\"1\">\n";
echo"          </td>\n";
echo"        </tr>\n";
echo"        <tr>\n";
echo"          <td><b><font color=\"#FF0000\">&gt;</font><font color=\"#000000\"> 初始化运行目录与文件</font></b></td>\n";
echo"        </tr>\n";
echo"        <tr>\n";
echo"          <td>\n";


?>
          </td>
        </tr>
        <tr>
          <td>
            <hr noshade align="center" width="100%" size="1" color="#6699CC">
          </td>
        </tr>
        <tr>
          <td align="center">
            <font color="#FF0000"><b>恭喜您，J_Space 安装成功！</font><br>
            管理员账号：</b><?=$username?><b> 密码：</b><?=$password1?><br><br>
            <a href="../admin/index.php" target="_blank">点击这里进入后台管理</a>
          </td>
        </tr>
<?

}

?>
        <tr>
          <td>
            <hr noshade align="center" width="100%" size="1" color="#6699CC">
          </td>
        </tr>
        <tr>
          <td align="center">
            <b style="font-size: 11px">Powered by <a href="http://www.ah0553.com" target="_blank">J_Space <?=$version?></a> , &nbsp; Copyright &copy; <a href="http://www.ah0553.com" target=\"_blank\">Bati Studio</a>, 2002</b>
          </td>
        </tr>
      </table>
    </td>
  </tr>
</table>
<br>
</body>
</html>