Announcement

Collapse
No announcement yet.

2.2.6

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • 2.2.6

    Can someone tell me what the table structure for this version should be, number of tables and their names please.


    Joey
    Last edited by express; Sat 11th Nov '06, 9:33am.
    Real Web Host

  • #2
    I have the following ones but I need to know which ones are missing.

    access
    adminlog
    adminutil
    announcement
    attachment
    avatar
    bbcode
    calendar_events
    customavatar
    forum
    forumpermission
    icon
    moderator
    poll
    pollvote
    post
    privatemessage
    profilefield
    replacement
    replacementset
    search
    Real Web Host

    Comment


    • #3
      Install a clean copy of it to a test mySQL database and you'll have the full layout.
      vBulletin v3.8.0's Implementation of Google Adsense Should Be Avoided At All Costs - Do Your Own Adsense Implementation

      Comment


      • #4
        Yes we were thinking the same thing but vb does not offer 2.26 for download anymore, that is why I ask here.
        Real Web Host

        Comment


        • #5
          Guess no one knows from vbulletin, amazing
          Real Web Host

          Comment


          • #6
            I would have to install a test copy of 2.2.6 to tell you this for certain and I'm sorry but I don't have the time to do this right now. Since you have the files I'm sure you can do the same thing and get the answer much quicker.
            Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
            Change CKEditor Colors to Match Style (for 4.1.4 and above)

            Steve Machol Photography


            Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


            Comment


            • #7
              Steve, do not have the total 2.2.6 we are trying to restore this for a client and we did not get all of the tables so I need a 2.2.6 zip file where I can install it, if it had been in the members area I would have never written this post. I just need the complete zip file where I can compare.
              Real Web Host

              Comment


              • #8
                Kier can you have someone from vbulletin help us with this please. Email me the zip file and I will compare them.
                Real Web Host

                Comment


                • #9
                  I've copied the relevant part of the 2.2.6 install.php file into this post, hope that'll suffice:

                  Code:
                  $query[]="CREATE TABLE access (
                     userid int(10) unsigned DEFAULT '0' NOT NULL,
                     forumid smallint(5) unsigned DEFAULT '0' NOT NULL,
                     accessmask smallint(5) unsigned DEFAULT '0' NOT NULL
                  )";
                  $explain[]="Creating table access";
                  $query[]="ALTER TABLE access ADD UNIQUE (userid,forumid)";
                  $explain[]="Altering access table";
                  
                  $query[]="CREATE TABLE adminlog (
                     adminlogid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
                     userid int(10) unsigned DEFAULT '0' NOT NULL,
                     dateline int(10) unsigned DEFAULT '0' NOT NULL,
                     script char(20) NOT NULL,
                     action char(20) NOT NULL,
                     extrainfo char(200) NOT NULL,
                     ipaddress VARCHAR(15) NOT NULL,
                     PRIMARY KEY (adminlogid)
                  )";
                  $explain[]="Creating table admin log";
                  
                  $query[]="CREATE TABLE adminutil (
                      title VARCHAR (10) not null,
                      text MEDIUMTEXT not null,
                      INDEX (title)
                  )";
                  
                  $explain[] = "Creating table admin util";
                  
                  $query[]="CREATE TABLE announcement (
                     announcementid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
                     title varchar(250) NOT NULL,
                     userid int(10) unsigned DEFAULT '0' NOT NULL,
                     startdate int(10) unsigned DEFAULT '0' NOT NULL,
                     enddate int(10) unsigned DEFAULT '0' NOT NULL,
                     pagetext mediumtext NOT NULL,
                     forumid smallint(6) DEFAULT '0' NOT NULL,
                     PRIMARY KEY (announcementid),
                     KEY (forumid)
                  )";
                  $explain[]="Creating table announcement";
                  
                  $query[]="CREATE TABLE attachment (
                     attachmentid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
                     userid int(10) unsigned DEFAULT '0' NOT NULL,
                     dateline int(10) unsigned DEFAULT '0' NOT NULL,
                     filename varchar(100) NOT NULL,
                     filedata mediumtext NOT NULL,
                     visible smallint(5) unsigned DEFAULT '0' NOT NULL,
                     counter smallint(5) unsigned DEFAULT '0' NOT NULL,
                     PRIMARY KEY (attachmentid)
                  )";
                  $explain[]="Creating table attachment";
                  
                  $query[]="CREATE TABLE avatar (
                     avatarid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
                     title char(100) NOT NULL,
                     minimumposts smallint(6) DEFAULT '0' NOT NULL,
                     avatarpath char(100) NOT NULL,
                     PRIMARY KEY (avatarid)
                  )";
                  $explain[]="Creating table avatar";
                  
                  $query[]="CREATE TABLE bbcode (
                     bbcodeid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
                     bbcodetag varchar(200) NOT NULL,
                     bbcodereplacement varchar(200) NOT NULL,
                     bbcodeexample varchar(200) NOT NULL,
                     bbcodeexplanation mediumtext NOT NULL,
                     twoparams smallint(6) DEFAULT '0' NOT NULL,
                     PRIMARY KEY (bbcodeid)
                  )";
                  $explain[]="Creating table bbcode";
                  
                  $query[]="CREATE TABLE calendar_events (
                     eventid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
                     userid int(10) unsigned DEFAULT '0' NOT NULL,
                     event mediumtext NOT NULL,
                     eventdate date DEFAULT '0000-00-00' NOT NULL,
                     public smallint(5) unsigned DEFAULT '0' NOT NULL,
                     subject varchar(254) NOT NULL,
                     allowsmilies smallint(6) DEFAULT '1' NOT NULL,
                     PRIMARY KEY (eventid),
                     KEY userid (userid)
                  )";
                  $explain[]="Creating table calendar_events";
                  
                  $query[]="CREATE TABLE customavatar (
                     userid int(10) unsigned DEFAULT '0' NOT NULL,
                     avatardata mediumtext NOT NULL,
                     dateline int(10) unsigned DEFAULT '0' NOT NULL,
                     filename CHAR(100) NOT NULL,
                     PRIMARY KEY (userid)
                  )";
                  $explain[]="Creating table custom avatar";
                  
                  $query[]="CREATE TABLE forum (
                     forumid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
                     styleid smallint(5) unsigned DEFAULT '0' NOT NULL,
                     title char(100) NOT NULL,
                     description char(250) NOT NULL,
                     active smallint(6) DEFAULT '0' NOT NULL,
                     displayorder smallint(6) DEFAULT '0' NOT NULL,
                     replycount int(10) unsigned DEFAULT '0' NOT NULL,
                     lastpost int(11) DEFAULT '0' NOT NULL,
                     lastposter char(50) NOT NULL,
                     threadcount mediumint(8) unsigned DEFAULT '0' NOT NULL,
                     allowposting tinyint(4) DEFAULT '0' NOT NULL,
                     cancontainthreads smallint(6) DEFAULT '0' NOT NULL,
                     daysprune smallint(5) unsigned DEFAULT '0' NOT NULL,
                     newpostemail char(250) NOT NULL,
                     newthreademail char(250) NOT NULL,
                     moderatenew smallint(6) DEFAULT '0' NOT NULL,
                     moderateattach smallint(6) DEFAULT '0' NOT NULL,
                     allowbbcode smallint(6) DEFAULT '0' NOT NULL,
                     allowimages smallint(6) DEFAULT '0' NOT NULL,
                     allowhtml smallint(6) DEFAULT '0' NOT NULL,
                     allowsmilies smallint(6) DEFAULT '0' NOT NULL,
                     allowicons smallint(6) DEFAULT '0' NOT NULL,
                     parentid smallint(6) DEFAULT '0' NOT NULL,
                     parentlist char(250) NOT NULL,
                     allowratings smallint(6) DEFAULT '0' NOT NULL,
                     countposts smallint(6) DEFAULT '1' NOT NULL,
                     styleoverride smallint(5) DEFAULT '0' NOT NULL,
                     PRIMARY KEY (forumid)
                  )";
                  $explain[]="Creating table forum";
                  
                  $query[]="CREATE TABLE forumpermission (
                     forumpermissionid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
                     forumid smallint(5) unsigned DEFAULT '0' NOT NULL,
                     usergroupid smallint(5) unsigned DEFAULT '0' NOT NULL,
                     canview smallint(6) DEFAULT '0' NOT NULL,
                     cansearch smallint(6) DEFAULT '0' NOT NULL,
                     canemail smallint(6) DEFAULT '0' NOT NULL,
                     canpostnew smallint(6) DEFAULT '0' NOT NULL,
                     canmove smallint(6) DEFAULT '0' NOT NULL,
                     canopenclose smallint(6) DEFAULT '0' NOT NULL,
                     candeletethread smallint(6) DEFAULT '0' NOT NULL,
                     canreplyown smallint(6) DEFAULT '0' NOT NULL,
                     canreplyothers smallint(6) DEFAULT '0' NOT NULL,
                     canviewothers smallint(6) DEFAULT '0' NOT NULL,
                     caneditpost smallint(6) DEFAULT '0' NOT NULL,
                     candeletepost smallint(6) DEFAULT '0' NOT NULL,
                     canpostattachment smallint(6) DEFAULT '0' NOT NULL,
                     canpostpoll smallint(6) DEFAULT '0' NOT NULL,
                     canvote smallint(6) DEFAULT '0' NOT NULL,
                     cangetattachment SMALLINT DEFAULT '1' not null,
                     PRIMARY KEY (forumpermissionid),
                     KEY ugid_fid (usergroupid, forumid)
                  )";
                  $explain[]="Creating table forum permission";
                  
                  $query[]="CREATE TABLE icon (
                     iconid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
                     title char(100) NOT NULL,
                     iconpath char(100) NOT NULL,
                     PRIMARY KEY (iconid)
                  )";
                  $explain[]="Creating table icon";
                  
                  $query[]="CREATE TABLE moderator (
                     moderatorid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
                     userid int(10) unsigned DEFAULT '0' NOT NULL,
                     forumid smallint(6) DEFAULT '0' NOT NULL,
                     newthreademail smallint(6) DEFAULT '0' NOT NULL,
                     newpostemail smallint(6) DEFAULT '0' NOT NULL,
                     caneditposts smallint(6) DEFAULT '0' NOT NULL,
                     candeleteposts smallint(6) DEFAULT '0' NOT NULL,
                     canviewips smallint(6) DEFAULT '0' NOT NULL,
                     canmanagethreads smallint(6) DEFAULT '0' NOT NULL,
                     canopenclose smallint(6) DEFAULT '0' NOT NULL,
                     caneditthreads smallint(6) DEFAULT '0' NOT NULL,
                     caneditstyles smallint(6) DEFAULT '0' NOT NULL,
                     canbanusers smallint(6) DEFAULT '0' NOT NULL,
                     canviewprofile smallint(6) DEFAULT '0' NOT NULL,
                     canannounce smallint(6) DEFAULT '0' NOT NULL,
                     canmassmove smallint(6) DEFAULT '0' NOT NULL,
                     canmassprune smallint(6) DEFAULT '0' NOT NULL,
                     canmoderateposts smallint(6) DEFAULT '0' NOT NULL,
                     canmoderateattachments smallint(6) DEFAULT '0' NOT NULL,
                     PRIMARY KEY (moderatorid),
                     KEY userid (userid,forumid)
                  )";
                  $explain[]="Creating table moderator";
                  
                  $query[]="CREATE TABLE poll (
                     pollid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
                     question varchar(100) NOT NULL,
                     dateline int(10) unsigned DEFAULT '0' NOT NULL,
                     options text NOT NULL,
                     votes text NOT NULL,
                     active smallint(6) DEFAULT '1' NOT NULL,
                     numberoptions smallint(5) unsigned DEFAULT '0' NOT NULL,
                     timeout smallint(5) unsigned DEFAULT '0' NOT NULL,
                     multiple SMALLINT UNSIGNED DEFAULT '0' not null,
                     voters SMALLINT UNSIGNED DEFAULT '0' not null,
                     PRIMARY KEY (pollid)
                  )";
                  $explain[]="Creating table poll";
                  
                  $query[]="CREATE TABLE pollvote (
                     pollvoteid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
                     pollid int(10) unsigned DEFAULT '0' NOT NULL,
                     userid int(10) unsigned DEFAULT '0' NOT NULL,
                     votedate int(10) unsigned DEFAULT '0' NOT NULL,
                     voteoption int(10) unsigned DEFAULT '0' NOT NULL,
                     PRIMARY KEY (pollvoteid),
                     KEY userid (userid, pollid)
                  )";
                  $explain[]="Creating table pollvote";
                  
                  $query[]="CREATE TABLE post (
                     postid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
                     threadid int(10) unsigned DEFAULT '0' NOT NULL,
                     username varchar(50) NOT NULL,
                     userid int(10) unsigned DEFAULT '0' NOT NULL,
                     title varchar(100) NOT NULL,
                     dateline int(10) unsigned DEFAULT '0' NOT NULL,
                     attachmentid smallint(5) unsigned DEFAULT '0' NOT NULL,
                     pagetext mediumtext NOT NULL,
                     allowsmilie smallint(6) DEFAULT '0' NOT NULL,
                     showsignature smallint(6) DEFAULT '0' NOT NULL,
                     ipaddress varchar(16) NOT NULL,
                     iconid smallint(5) unsigned DEFAULT '0' NOT NULL,
                     visible smallint(6) DEFAULT '0' NOT NULL,
                     edituserid int(10) unsigned DEFAULT '0' NOT NULL,
                     editdate int(10) unsigned DEFAULT '0' NOT NULL,
                     PRIMARY KEY (postid),
                     KEY iconid (iconid),
                     KEY userid (userid),
                     KEY threadid (threadid, userid)
                  )";
                  $explain[]="Creating table post";
                  
                  $query[]="CREATE TABLE privatemessage (
                     privatemessageid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
                     folderid smallint(6) DEFAULT '0' NOT NULL,
                     userid int(10) unsigned DEFAULT '0' NOT NULL,
                     touserid int(10) unsigned DEFAULT '0' NOT NULL,
                     fromuserid int(10) unsigned DEFAULT '0' NOT NULL,
                     title varchar(250) NOT NULL,
                     message mediumtext NOT NULL,
                     dateline int(10) unsigned DEFAULT '0' NOT NULL,
                     showsignature smallint(6) DEFAULT '0' NOT NULL,
                     iconid smallint(5) unsigned DEFAULT '0' NOT NULL,
                     messageread smallint(6) DEFAULT '0' NOT NULL,
                     readtime INT (10) UNSIGNED DEFAULT '0' not null,
                     receipt SMALLINT (6) UNSIGNED DEFAULT '0' not null,
                     deleteprompt SMALLINT (6) UNSIGNED DEFAULT '0' not null,
                     multiplerecipients SMALLINT (6) UNSIGNED DEFAULT '0' not null,
                     PRIMARY KEY (privatemessageid),
                     KEY userid (userid)
                  )";
                  $explain[]="Creating table private message";
                  
                  $query[]="CREATE TABLE profilefield (
                     profilefieldid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
                     title char(50) NOT NULL,
                     description char(250) NOT NULL,
                     required smallint(6) DEFAULT '0' NOT NULL,
                     hidden smallint(6) DEFAULT '0' NOT NULL,
                     maxlength smallint(6) DEFAULT '250' NOT NULL,
                     size smallint(6) DEFAULT '25' NOT NULL,
                     displayorder SMALLINT(6) NOT NULL,
                     editable SMALLINT DEFAULT '1' NOT NULL,
                     PRIMARY KEY (profilefieldid)
                  )";
                  $explain[]="Creating table profile field";
                  
                  $query[]="CREATE TABLE replacement (
                     replacementid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
                     replacementsetid smallint(6) DEFAULT '0' NOT NULL,
                     findword text NOT NULL,
                     replaceword text NOT NULL,
                     PRIMARY KEY (replacementid),
                     KEY (replacementsetid)
                  )";
                  $explain[]="Creating table replacement";
                  
                  $query[]="CREATE TABLE replacementset (
                     replacementsetid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
                     title char(250) NOT NULL,
                     PRIMARY KEY (replacementsetid)
                  )";
                  $explain[]="Creating table replacement set";
                  
                  $query[]="CREATE TABLE search (
                     searchid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
                     query mediumtext NOT NULL,
                     postids mediumtext NOT NULL,
                     dateline int(10) unsigned DEFAULT '0' NOT NULL,
                     querystring varchar(200) NOT NULL,
                     showposts smallint(6) DEFAULT '0' NOT NULL,
                     userid int(10) unsigned DEFAULT '0' NOT NULL,
                     ipaddress varchar(20) NOT NULL,
                     PRIMARY KEY (searchid),
                     KEY (querystring),
                     KEY (userid)
                  )";
                  $explain[]="Creating table search";
                  
                  $query[]="CREATE TABLE searchindex (
                     wordid int(10) unsigned DEFAULT '0' NOT NULL,
                     postid int(10) unsigned DEFAULT '0' NOT NULL,
                     intitle smallint(5) unsigned DEFAULT '0' NOT NULL
                  )";
                  $explain[]="Creating table search index";
                  
                  $query[]="ALTER TABLE searchindex ADD UNIQUE (wordid,postid)";
                  $explain[]="Altering search index table";
                  
                  $query[]="CREATE TABLE session (
                     sessionhash char(32) NOT NULL,
                     userid int(10) unsigned DEFAULT '0' NOT NULL,
                     host char(50) NOT NULL,
                     useragent char(50) NOT NULL,
                     lastactivity int(10) unsigned DEFAULT '0' NOT NULL,
                     location CHAR (255) not null,
                     styleid smallint(5) unsigned DEFAULT '0' NOT NULL,
                     PRIMARY KEY (sessionhash)
                  )";
                  $explain[]="Creating table session";
                  
                  $query[]="CREATE TABLE setting (
                     settingid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
                     settinggroupid smallint(5) unsigned DEFAULT '0' NOT NULL,
                     title varchar(100) NOT NULL,
                     varname varchar(100) NOT NULL,
                     value mediumtext NOT NULL,
                     description mediumtext NOT NULL,
                     optioncode mediumtext NOT NULL,
                     displayorder smallint(5) unsigned DEFAULT '0' NOT NULL,
                     PRIMARY KEY (settingid)
                  )";
                  $explain[]="Creating table setting";
                  
                  $query[]="CREATE TABLE settinggroup (
                     settinggroupid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
                     title char(100) NOT NULL,
                     displayorder smallint(5) unsigned DEFAULT '0' NOT NULL,
                     PRIMARY KEY (settinggroupid)
                  )";
                  $explain[]="Creating table setting group";
                  
                  $query[]="CREATE TABLE smilie (
                     smilieid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
                     title char(100) NOT NULL,
                     smilietext char(10) NOT NULL,
                     smiliepath char(100) NOT NULL,
                     PRIMARY KEY (smilieid)
                  )";
                  $explain[]="Creating table smilie";
                  
                  $query[]="CREATE TABLE style (
                     styleid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
                     replacementsetid smallint(5) unsigned DEFAULT '0' NOT NULL,
                     templatesetid smallint(5) unsigned DEFAULT '0' NOT NULL,
                     title char(250) NOT NULL,
                     userselect smallint(5) unsigned DEFAULT '0' NOT NULL,
                     PRIMARY KEY (styleid)
                  )";
                  $explain[]="Creating table style";
                  
                  $query[]="INSERT INTO style VALUES (1, 1, 1, 'Default', 1)";
                  $explain[]="Inserting data into style table";
                  
                  $query[]="CREATE TABLE subscribeforum (
                     subscribeforumid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
                     userid int(10) unsigned DEFAULT '0' NOT NULL,
                     forumid smallint(5) unsigned DEFAULT '0' NOT NULL,
                     emailupdate smallint(5) unsigned DEFAULT '0' NOT NULL,
                     PRIMARY KEY (subscribeforumid),
                     KEY (userid)
                  )";
                  $explain[]="Creating table subscribed forum";
                  
                  $query[]="CREATE TABLE subscribethread (
                     subscribethreadid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
                     userid int(10) unsigned DEFAULT '0' NOT NULL,
                     threadid int(10) unsigned DEFAULT '0' NOT NULL,
                     emailupdate smallint(5) unsigned DEFAULT '0' NOT NULL,
                     PRIMARY KEY (subscribethreadid),
                     KEY (threadid)
                  )";
                  $explain[]="Creating table subscribed thread";
                  
                  $query[]="CREATE TABLE template (
                     templateid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
                     templatesetid smallint(6) DEFAULT '0' NOT NULL,
                     title varchar(100) NOT NULL,
                     template mediumtext NOT NULL,
                     PRIMARY KEY (templateid),
                     KEY title (title(30),templatesetid)
                  )";
                  $explain[]="Creating table template";
                  
                  $query[]="CREATE TABLE templateset (
                     templatesetid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
                     title char(250) NOT NULL,
                     PRIMARY KEY (templatesetid)
                  )";
                  $explain[]="Creating table template set";
                  
                  $query[]="CREATE TABLE thread (
                     threadid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
                     title varchar(100) NOT NULL,
                     lastpost int(10) unsigned DEFAULT '0' NOT NULL,
                     forumid smallint(5) unsigned DEFAULT '0' NOT NULL,
                     pollid int(10) unsigned DEFAULT '0' NOT NULL,
                     open tinyint(4) DEFAULT '0' NOT NULL,
                     replycount int(10) unsigned DEFAULT '0' NOT NULL,
                     postusername varchar(50) NOT NULL,
                     postuserid int(10) unsigned DEFAULT '0' NOT NULL,
                     lastposter varchar(50) NOT NULL,
                     dateline int(10) unsigned DEFAULT '0' NOT NULL,
                     views INT(10) UNSIGNED DEFAULT '0' NOT NULL,
                     iconid smallint(5) unsigned DEFAULT '0' NOT NULL,
                     notes varchar(250) NOT NULL,
                     visible smallint(6) DEFAULT '0' NOT NULL,
                     sticky smallint(6) DEFAULT '0' NOT NULL,
                     votenum smallint(5) unsigned DEFAULT '0' NOT NULL,
                     votetotal smallint(5) unsigned DEFAULT '0' NOT NULL,
                     attach smallint(5) unsigned DEFAULT '0' NOT NULL,
                     PRIMARY KEY (threadid),
                     KEY iconid (iconid),
                     KEY forumid (forumid, visible, sticky, lastpost)
                  )";
                  $explain[]="Creating table thread";
                  
                  $query[]="CREATE TABLE threadrate (
                     threadrateid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
                     threadid int(10) unsigned DEFAULT '0' NOT NULL,
                     userid int(10) unsigned DEFAULT '0' NOT NULL,
                     vote smallint(6) DEFAULT '0' NOT NULL,
                     ipaddress varchar(20) NOT NULL,
                     PRIMARY KEY (threadrateid),
                     KEY threadid (threadid)
                  )";
                  $explain[]="Creating table thread rate";
                  
                  $query[]="CREATE TABLE user (
                     userid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
                     usergroupid smallint(5) unsigned DEFAULT '0' NOT NULL,
                     username varchar(50) NOT NULL,
                     password varchar(50) NOT NULL,
                     email varchar(50) NOT NULL,
                     styleid smallint(5) unsigned DEFAULT '0' NOT NULL,
                     parentemail varchar(50) NOT NULL,
                     coppauser smallint(6) DEFAULT '0' NOT NULL,
                     homepage varchar(100) NOT NULL,
                     icq varchar(20) NOT NULL,
                     aim varchar(20) NOT NULL,
                     yahoo varchar(20) NOT NULL,
                     signature mediumtext NOT NULL,
                     adminemail smallint(6) DEFAULT '0' NOT NULL,
                     showemail smallint(6) DEFAULT '0' NOT NULL,
                     invisible smallint(6) DEFAULT '0' NOT NULL,
                     usertitle varchar(250) NOT NULL,
                     customtitle smallint(6) DEFAULT '0' NOT NULL,
                     joindate int(10) unsigned DEFAULT '0' NOT NULL,
                     cookieuser smallint(6) DEFAULT '0' NOT NULL,
                     daysprune smallint(6) DEFAULT '0' NOT NULL,
                     lastvisit int(10) unsigned DEFAULT '0' NOT NULL,
                     lastactivity int(10) unsigned DEFAULT '0' NOT NULL,
                     lastpost int(10) unsigned DEFAULT '0' NOT NULL,
                     posts smallint(5) unsigned DEFAULT '0' NOT NULL,
                     timezoneoffset varchar(4) NOT NULL,
                     emailnotification smallint(6) DEFAULT '0' NOT NULL,
                     buddylist mediumtext NOT NULL,
                     ignorelist mediumtext NOT NULL,
                     pmfolders mediumtext NOT NULL,
                     receivepm smallint(6) DEFAULT '0' NOT NULL,
                     emailonpm smallint(6) DEFAULT '0' NOT NULL,
                     pmpopup smallint(6) DEFAULT '0' NOT NULL,
                     avatarid smallint(6) DEFAULT '0' NOT NULL,
                     options smallint(6) DEFAULT '15' NOT NULL,
                     birthday date DEFAULT '0000-00-00' NOT NULL,
                     maxposts smallint(6) DEFAULT '-1' NOT NULL,
                     startofweek smallint(6) DEFAULT '1' NOT NULL,
                     ipaddress varchar(20) NOT NULL,
                     referrerid int(10) unsigned DEFAULT '0' NOT NULL,
                     nosessionhash smallint(6) DEFAULT '0' NOT NULL,
                     inforum SMALLINT UNSIGNED DEFAULT '0' not null,
                     PRIMARY KEY (userid),
                     KEY usergroupid (usergroupid),
                     KEY username (username),
                     INDEX (inforum)
                  )";
                  $explain[]="Creating table user";
                  
                  $query[]="CREATE TABLE userfield (
                     userid int(10) unsigned DEFAULT '0' NOT NULL,
                     field1 char(250) NOT NULL,
                     field2 char(250) NOT NULL,
                     field3 char(250) NOT NULL,
                     field4 char(250) NOT NULL,
                     PRIMARY KEY (userid)
                  )";
                  $explain[]="Creating table userfield";
                  
                  $query[]="CREATE TABLE usergroup (
                     usergroupid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
                     title char(100) NOT NULL,
                     usertitle char(100) NOT NULL,
                     cancontrolpanel smallint(6) DEFAULT '0' NOT NULL,
                     canmodifyprofile smallint(6) DEFAULT '0' NOT NULL,
                     canviewmembers smallint(6) DEFAULT '0' NOT NULL,
                     canview smallint(6) DEFAULT '0' NOT NULL,
                     cansearch smallint(6) DEFAULT '0' NOT NULL,
                     canemail smallint(6) DEFAULT '0' NOT NULL,
                     canpostnew smallint(6) DEFAULT '0' NOT NULL,
                     canmove smallint(6) DEFAULT '0' NOT NULL,
                     canopenclose smallint(6) DEFAULT '0' NOT NULL,
                     candeletethread smallint(6) DEFAULT '0' NOT NULL,
                     canreplyown smallint(6) DEFAULT '0' NOT NULL,
                     canreplyothers smallint(6) DEFAULT '0' NOT NULL,
                     canviewothers smallint(6) DEFAULT '0' NOT NULL,
                     caneditpost smallint(6) DEFAULT '0' NOT NULL,
                     candeletepost smallint(6) DEFAULT '0' NOT NULL,
                     canusepm smallint(6) DEFAULT '0' NOT NULL,
                     canpostpoll smallint(6) DEFAULT '0' NOT NULL,
                     canvote smallint(6) DEFAULT '0' NOT NULL,
                     canpostattachment smallint(6) DEFAULT '0' NOT NULL,
                     canpublicevent smallint(6) DEFAULT '0' NOT NULL,
                     canpublicedit smallint(6) DEFAULT '0' NOT NULL,
                     canthreadrate smallint(6) DEFAULT '1' NOT NULL,
                     maxbuddypm SMALLINT (6) UNSIGNED DEFAULT '5' NOT NULL,
                     maxforwardpm SMALLINT (6) UNSIGNED DEFAULT '5' NOT NULL,
                     cantrackpm SMALLINT (6) DEFAULT '1' NOT NULL,
                     candenypmreceipts SMALLINT (6) DEFAULT '1' NOT NULL,
                     canwhosonline SMALLINT (6) DEFAULT '1' NOT NULL,
                     canwhosonlineip SMALLINT (6) DEFAULT '0' NOT NULL,
                     ismoderator smallint(6) DEFAULT '0' NOT NULL,
                     showgroup SMALLINT UNSIGNED DEFAULT '0' not null,
                     cangetattachment SMALLINT DEFAULT '1' not null,
                       PRIMARY KEY (usergroupid),
                     INDEX(showgroup)
                  )";
                  $explain[]="Creating table usergroup";
                  
                  $query[]="CREATE TABLE usertitle (
                     usertitleid smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
                     minposts smallint(5) unsigned DEFAULT '0' NOT NULL,
                     title char(250) NOT NULL,
                     PRIMARY KEY (usertitleid)
                  )";
                  $explain[]="Creating table user title";
                  
                  $query[]="CREATE TABLE word (
                     wordid int(10) unsigned DEFAULT '0' NOT NULL auto_increment,
                     title char(50) NOT NULL,
                     PRIMARY KEY (wordid)
                  )";
                  $explain[]="Creating table word";
                  
                  $query[]="ALTER TABLE word ADD UNIQUE (title)";
                  $explain[]="Altering word table";
                  
                  $query[]="CREATE TABLE useractivation (
                    useractivationid INT UNSIGNED not null AUTO_INCREMENT,
                    userid INT UNSIGNED not null,
                    dateline INT UNSIGNED not null,
                    activationid CHAR(20) not null,
                    type SMALLINT UNSIGNED not null,
                    PRIMARY KEY (useractivationid),
                    INDEX (userid,type)
                  )";
                  $explain[]="Creating activation numbers' table";
                  Best Regards
                  Colin Frei

                  Please don't contact me per PM.

                  Comment


                  • #10
                    This is not working, I appreciate you postign this but no good. All I need to know is what tables should be 2.2.6 that is all nothing else. CAn someone please tell me that?
                    Real Web Host

                    Comment


                    • #11
                      Got them I think

                      access
                      access
                      adminlog
                      adminutil
                      announcement
                      attachment
                      avatar
                      bbcode
                      calendar_events
                      customavatar
                      forum
                      forumpermission
                      icon
                      moderator
                      poll
                      pollvote
                      post
                      privatemessage
                      profilefield
                      replacement
                      replacementset
                      search
                      searchindex
                      searchindex
                      session
                      setting
                      settinggroup
                      smilie
                      style
                      subscribeforum
                      subscribethread
                      template
                      templateset
                      thread
                      threadrate
                      user
                      userfield
                      usergroup
                      usertitle
                      word
                      word
                      useractivation
                      Real Web Host

                      Comment


                      • #12
                        I didn't check your list, but you can find them be looking for each line that starts with

                        $query[]="CREATE TABLE
                        Best Regards
                        Colin Frei

                        Please don't contact me per PM.

                        Comment

                        Loading...
                        Working...
                        X