initdatabase.jsp

BBS系统

    if(createok) {
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>完成！</b><br><br>");
    }
    else {
       updateok=false;
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>失败！</b><br>");
       out.println("<font color=#ff0000><b>请查看服务器返回的错误信息！</b></font><br><br>");
    }
    //结束创建

    title="禁止言词表";
    //开始创建
    query="CREATE TABLE banword (id SMALLINT(4) UNSIGNED NOT NULL AUTO_INCREMENT, banword varchar(50) NOT NULL , PRIMARY KEY (id), INDEX (id))";
    out.println("<br><b>开始创建</b> <font color=#0000ff>"+title+"</font> ……<br>");
    out.println("<b>SQL语句：</b><font color=#ff0000>"+query+"</font><br>");
    createok=connect.executeUpdate(query);
    if(createok) {
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>完成！</b><br><br>");
    }
    else {
       updateok=false;
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>失败！</b><br>");
       out.println("<font color=#ff0000><b>请查看服务器返回的错误信息！</b></font><br><br>");
    }
    //结束创建

    title="论坛总分类信息表";
    //开始创建
    query="CREATE TABLE forum (id SMALLINT(4) UNSIGNED NOT NULL AUTO_INCREMENT,forum SMALLINT(4) UNSIGNED NOT NULL , forumname varchar(150) NOT NULL , forumexpand enum('1','0') not null, PRIMARY KEY (id), INDEX (id))";
    out.println("<br><b>开始创建</b> <font color=#0000ff>"+title+"</font> ……<br>");
    out.println("<b>SQL语句：</b><font color=#ff0000>"+query+"</font><br>");
    createok=connect.executeUpdate(query);
    if(createok) {
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>完成！</b><br><br>");
    }
    else {
       updateok=false;
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>失败！</b><br>");
       out.println("<font color=#ff0000><b>请查看服务器返回的错误信息！</b></font><br><br>");
    }
    //结束创建

    title="论坛的展开情况表";
    //开始创建
    query="CREATE TABLE forumexpand (id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT,authorid int(6) unsigned not null,forumid smallint(4) unsigned not null, forumexpand enum('1','0') not null, PRIMARY KEY (id), INDEX (id))";
    out.println("<br><b>开始创建</b> <font color=#0000ff>"+title+"</font> ……<br>");
    out.println("<b>SQL语句：</b><font color=#ff0000>"+query+"</font><br>");
    createok=connect.executeUpdate(query);
    if(createok) {
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>完成！</b><br><br>");
    }
    else {
       updateok=false;
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>失败！</b><br>");
       out.println("<font color=#ff0000><b>请查看服务器返回的错误信息！</b></font><br><br>");
    }
    //结束创建

    title="分类中分论坛信息表";
    //开始创建
    query="CREATE TABLE db (id SMALLINT(4) UNSIGNED NOT NULL AUTO_INCREMENT,forum SMALLINT(4) UNSIGNED NOT NULL,db SMALLINT(4) UNSIGNED NOT NULL, dbname varchar(30) NOT NULL , dbdescription varchar(100) NOT NULL ,htmlstat enum('0','1') not null,lycodestat enum('0','1') not null,privateforum enum('0','1') not null,dbpassword varchar(30) NOT NULL ,indexforum enum('0','1') not null,startnewthreads varchar(20) NOT NULL ,ratings enum('0','1') not null,dbgraphic varchar(30) NOT NULL ,teamlogo varchar(30) NOT NULL ,teamurl varchar(30) NOT NULL ,PRIMARY KEY (id), INDEX (id))";
    out.println("<br><b>开始创建</b> <font color=#0000ff>"+title+"</font> ……<br>");
    out.println("<b>SQL语句：</b><font color=#ff0000>"+query+"</font><br>");
    createok=connect.executeUpdate(query);
    if(createok) {
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>完成！</b><br><br>");
    }
    else {
       updateok=false;
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>失败！</b><br>");
       out.println("<font color=#ff0000><b>请查看服务器返回的错误信息！</b></font><br><br>");
    }
    //结束创建

    title="联盟论坛信息表";
    //开始创建
    query="CREATE TABLE allianceforum (id SMALLINT(4) UNSIGNED NOT NULL AUTO_INCREMENT, forumname varchar(80) NOT NULL , forumurl varchar(150) NOT NULL ,weblogo varchar(150) NOT NULL ,forumdescription varchar(200) NOT NULL ,PRIMARY KEY (id), INDEX (id))";
    out.println("<br><b>开始创建</b> <font color=#0000ff>"+title+"</font> ……<br>");
    out.println("<b>SQL语句：</b><font color=#ff0000>"+query+"</font><br>");
    createok=connect.executeUpdate(query);
    if(createok) {
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>完成！</b><br><br>");
       insertok=connect.executeUpdate("INSERT INTO allianceforum (forumname,forumurl,weblogo,forumdescription) VALUES ('凌云论坛','http://www.unix-now.com/lybbs','images/lylogo.gif','LyBBS『凌云论坛』大本营')");
       if(insertok)
          out.println("写数据<b>完成！</b><br><br>");
    }
    else {
       updateok=false;
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>失败！</b><br>");
       out.println("<font color=#ff0000><b>请查看服务器返回的错误信息！</b></font><br><br>");
    }
    //结束创建

    title="帖子库表";
    //开始创建
    query="CREATE TABLE posts (id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, forum smallint(4) UNSIGNED not null,db smallint(4) UNSIGNED not null,clicktimes int(6) unsigned not null,hotpost enum('0','1') not null,groupid int(10) UNSIGNED not null,orderby int(10) unsigned not null,parentid int(10) UNSIGNED not null,top enum('0','1') not null,titlelock enum('0','1') not null,titleimage varchar(20) NOT NULL ,authorid int(6) UNSIGNED not null,author varchar(30) NOT NULL ,title varchar(80) not null,content blob not null,postat datetime not null,ipfrom varchar(20) NOT NULL ,accessary enum('0','1') not null,accessaryname varchar(20) NOT NULL ,vote enum('0','1') not null,jinghua enum('0','1') not null ,PRIMARY KEY (id), INDEX (id))";
    out.println("<br><b>开始创建</b> <font color=#0000ff>"+title+"</font> ……<br>");
    out.println("<b>SQL语句：</b><font color=#ff0000>"+query+"</font><br>");
    createok=connect.executeUpdate(query);
    if(createok) {
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>完成！</b><br><br>");
    }
    else {
       updateok=false;
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>失败！</b><br>");
       out.println("<font color=#ff0000><b>请查看服务器返回的错误信息！</b></font><br><br>");
    }
    //结束创建

    title="投票系统表";
    //开始创建
    query="CREATE TABLE vote (id SMALLINT(5) UNSIGNED NOT NULL AUTO_INCREMENT, postsid int(10) unsigned not null,votetitle varchar(50) NOT NULL ,votenumber int(10) unsigned not null, PRIMARY KEY (id), INDEX (id))";
    out.println("<br><b>开始创建</b> <font color=#0000ff>"+title+"</font> ……<br>");
    out.println("<b>SQL语句：</b><font color=#ff0000>"+query+"</font><br>");
    createok=connect.executeUpdate(query);
    if(createok) {
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>完成！</b><br><br>");
    }
    else {
       updateok=false;
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>失败！</b><br>");
       out.println("<font color=#ff0000><b>请查看服务器返回的错误信息！</b></font><br><br>");
    }
    //结束创建

    title="图例信息表";
    //开始创建
    query="CREATE TABLE icon (id TINYINT(2) UNSIGNED NOT NULL AUTO_INCREMENT, onlineadmin varchar(20) NOT NULL ,onlinesmod varchar(20) NOT NULL ,onlinemod varchar(20) NOT NULL ,onlinemember varchar(20) NOT NULL ,onlineselfcolor varchar(8) NOT NULL ,onlineguest varchar(20) NOT NULL ,zg_havenew varchar(20) NOT NULL ,zg_nonew varchar(20) NOT NULL ,kf_havenew varchar(20) NOT NULL ,kf_nonew varchar(20) NOT NULL ,pl_havenew varchar(20) NOT NULL ,pl_nonew varchar(20) NOT NULL ,bm_havenew varchar(20) NOT NULL ,bm_nonew varchar(20) NOT NULL ,jh_pic varchar(20) NOT NULL ,lm_pic varchar(20) NOT NULL ,newthreadlogo varchar(20) NOT NULL ,newpolllogo varchar(20) NOT NULL ,newxzblogo varchar(20) NOT NULL ,newreplylogo varchar(20) NOT NULL ,wlogo varchar(20) NOT NULL ,nwlogo varchar(20) NOT NULL ,help_blogo varchar(20) NOT NULL ,new_blogo varchar(20) NOT NULL , PRIMARY KEY (id), INDEX (id))";
    out.println("<br><b>开始创建</b> <font color=#0000ff>"+title+"</font> ……<br>");
    out.println("<b>SQL语句：</b><font color=#ff0000>"+query+"</font><br>");
    createok=connect.executeUpdate(query);
    if(createok) {
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>完成！</b><br><br>");
       insertok=connect.executeUpdate("insert into icon (id,onlineadmin,onlinesmod,onlinemod,onlinemember,onlineselfcolor,onlineguest,zg_havenew,zg_nonew,kf_havenew,kf_nonew,pl_havenew,pl_nonew,bm_havenew,bm_nonew,jh_pic,lm_pic,newthreadlogo,newpolllogo,newxzblogo,newreplylogo,wlogo,nwlogo,help_blogo,new_blogo) values (1,'messages0.gif','messages3.gif','messages4.gif','messages1.gif','#0000FF','messages2.gif','foldernew.gif','folder.gif','folderallnew.gif','folderall.gif','follownew.gif','follow.gif','lock_l.gif','lock_b.gif','jinghua.gif','shareforum.gif','newthread.gif','newpoll.gif','newxzb.gif','newreply.gif','w.gif','nw.gif','help_b.gif','topnew.gif')");
       if(insertok)
          out.println("写数据<b>完成！</b><br><br>");
       else out.println("写数据<b><font color=#ff0000>失败！</font></b><br><br>");
    }
    else {
       updateok=false;
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>失败！</b><br>");
       out.println("<font color=#ff0000><b>请查看服务器返回的错误信息！</b></font><br><br>");
    }
    //结束创建

    title="emote对象设置表";
    //开始创建
    query="CREATE TABLE emote (id SMALLINT(4) UNSIGNED NOT NULL AUTO_INCREMENT, title varchar(20) NOT NULL ,content varchar(255) NOT NULL , PRIMARY KEY (id), INDEX (id))";
    out.println("<br><b>开始创建</b> <font color=#0000ff>"+title+"</font> ……<br>");
    out.println("<b>SQL语句：</b><font color=#ff0000>"+query+"</font><br>");
    createok=connect.executeUpdate(query);
    if(createok) {
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>完成！</b><br><br>");
    }
    else {
       updateok=false;
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>失败！</b><br>");
       out.println("<font color=#ff0000><b>请查看服务器返回的错误信息！</b></font><br><br>");
    }
    //结束创建

    title="图片管理表";
    //开始创建
    query="CREATE TABLE images (id SMALLINT(6) UNSIGNED NOT NULL AUTO_INCREMENT, imagename varchar(40) NOT NULL ,imagepath varchar(50) NOT NULL ,imagetitle varchar(50) NOT NULL , PRIMARY KEY (id), INDEX (id))";
    out.println("<br><b>开始创建</b> <font color=#0000ff>"+title+"</font> ……<br>");
    out.println("<b>SQL语句：</b><font color=#ff0000>"+query+"</font><br>");
    createok=connect.executeUpdate(query);
    if(createok) {
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>完成！</b><br><br>");
    }
    else {
       updateok=false;
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>失败！</b><br>");
       out.println("<font color=#ff0000><b>请查看服务器返回的错误信息！</b></font><br><br>");
    }
    //结束创建表";

    title="文件上传的暂存空间表";
    //开始创建
    query="CREATE TABLE uploadfile (id TINYINT(2) UNSIGNED NOT NULL, image blob, PRIMARY KEY (id), INDEX (id))";
    out.println("<br><b>开始创建</b> <font color=#0000ff>"+title+"</font> ……<br>");
    out.println("<b>SQL语句：</b><font color=#ff0000>"+query+"</font><br>");
    createok=connect.executeUpdate(query);
    if(createok) {
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>完成！</b><br><br>");
    }
    else {
       updateok=false;
       out.println("<font color=#0000ff>"+title+"</font> 创建<b>失败！</b><br>");
       out.println("<font color=#ff0000><b>请查看服务器返回的错误信息！</b></font><br><br>");
    }
    //结束创建

    title="论坛状态表";
    //开始创建
    query="CREATE TABLE boardstatus (id TINYINT(2) UNSIGNED NOT NULL,visittimes bigint(20) unsigned not null, clicktimes bigint(20) unsigned not null,maxonlinenumber smallint(5) unsigned not null,recordat datetime not null,PRIMARY KEY (id), INDEX (id))";