SMF Support > SMF 1.1.x Support

SQL & SMF What happens

(1/2) > >>

Shadowc:
My question.

When upgrading Yabb 1.5.5 to SMF, does SMF change the tables totally, or does the yabb tables main remain intact, and only SMF specific tables get created ?

My idea is to copy my present yabb to another folder on my server, ie /forum2 then run the upgrade on the copy, after that i can fix colors, buttons etc, while my old yabb running as usual, when everything is done then i change to SMF.

Is this possible or not ?

Tom Veik:
The tables are different, you can't just copy them.

Tyris:
the tables are renamed to backup_YOUR_TABLES
then the new smf tables are created with the modified data.
Anyhow.. you should be able to do what you're suggesting. You'd just have to rename the tables back to normal... (and make sure your new tables have a new prefix...)

Tom Veik:
But it sounds like he wants to copy the old tables over the new tables after he gets his colors and such set up.  That's not going to work, the tables are different.

Old table

--- Code: ---CREATE TABLE yabbse_boards (
   ID_CAT tinyint(4) DEFAULT '0' NOT NULL,
   ID_BOARD int(11) NOT NULL auto_increment,
   name tinytext NOT NULL,
   description text,
   moderators text,
   boardOrder tinyint(4) DEFAULT '0' NOT NULL,
   numTopics int(11) DEFAULT '0' NOT NULL,
   numPosts int(11) DEFAULT '0' NOT NULL,
   isAnnouncement tinyint(4) DEFAULT '0' NOT NULL,
   notifyAnnouncements tinyint(4) DEFAULT '0' NOT NULL,
   count tinyint(4) DEFAULT '0' NOT NULL,
   ID_LAST_TOPIC int(11),
   PRIMARY KEY (ID_BOARD),
   KEY ID_CAT (ID_CAT)
);
--- End code ---

New table

--- Code: ---CREATE TABLE `smf_boards` (
  ID_BOARD smallint(5) unsigned NOT NULL auto_increment,
  ID_CAT tinyint(4) unsigned NOT NULL default 0,
  childLevel tinyint(4) unsigned NOT NULL default 0,
  ID_PARENT smallint(5) unsigned NOT NULL default 0,
  boardOrder tinyint(4) NOT NULL default 0,
  ID_LAST_MSG int(10) unsigned NOT NULL default 0,
  lastUpdated int(11) unsigned NOT NULL default 0,
  memberGroups varchar(80) NOT NULL default '-1,0',
  name tinytext NOT NULL default '',
  description text NOT NULL default '',
  numTopics mediumint(8) unsigned NOT NULL default 0,
  numPosts mediumint(8) unsigned NOT NULL default 0,
  notifyAnnouncements tinyint(4) NOT NULL default 0,
  countPosts tinyint(4) NOT NULL default 0,
  ID_THEME tinyint(4) unsigned NOT NULL default 0,
  use_local_permissions tinyint(4) unsigned NOT NULL default 0,
  PRIMARY KEY (ID_BOARD),
  UNIQUE categories (ID_CAT, ID_BOARD),
  UNIQUE children (childLevel, ID_PARENT, boardOrder, ID_BOARD),
  KEY boardOrder (boardOrder),
  KEY lastUpdated (lastUpdated),
  KEY memberGroups (memberGroups(30))
) TYPE=MyISAM;
--- End code ---

Shadowc:
Tnx for the answers, and Tom is right, my idea was just to get SMF 110% ready to go so my members should be offline for just 1 minute.

My solution was that i put up a copy of my yabb at my local sql server, that i updated to SMF, fixed all things, then updated the real yabb, and uploaded my local SMF.
Some more job but works.

Navigation

[0] Message Index

[#] Next page