2.2.6

**express** · Sat 11 Nov '06, 9:30am

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

**conqsoft** · Sat 11 Nov '06, 9:53am

Install a clean copy of it to a test mySQL database and you'll have the full layout.

**express** · Sat 11 Nov '06, 9:54am

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

**express** · Sun 12 Nov '06, 2:11pm

Guess no one knows from vbulletin, amazing

**Steve Machol** · Sun 12 Nov '06, 2:29pm

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.

**express** · Sun 12 Nov '06, 2:51pm

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.

**express** · Mon 13 Nov '06, 12:52am

Kier can you have someone from vbulletin help us with this please. Email me the zip file and I will compare them.

**Colin F** · Mon 13 Nov '06, 3:20am

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";

**express** · Mon 13 Nov '06, 6:02am

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?

**express** · Mon 13 Nov '06, 6:07am

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

**Colin F** · Mon 13 Nov '06, 6:42am

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

$query[]="CREATE TABLE

2.2.6

2.2.6

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment