|
bobthebob01, you can find the file or simply the contents in the SVN. Heck, I'll post the contents here. Gimme a sec...
EDIT: [code:1]+------------------------------------------------+
| Fireboard 1.0.1 to 1.0.2 |
+------------------------------------------------+
CREATE TABLE `jos_fb_ranks` (
`rank_id` mediumint(8) unsigned NOT NULL auto_increment,
`rank_title` varchar(255) NOT NULL default '',
`rank_min` mediumint(8) unsigned NOT NULL default '0',
`rank_special` tinyint(1) unsigned NOT NULL default '0',
`rank_image` varchar(255) NOT NULL default '',
PRIMARY KEY (`rank_id`)
) AUTO_INCREMENT=12 ;
INSERT INTO `jos_fb_ranks` (`rank_id`, `rank_title`, `rank_min`, `rank_special`, `rank_image`) VALUES
(1, 'Fresh Boarder', 0, 0, 'rank1.gif'),
(2, 'Junior Boarder', 20, 0, 'rank2.gif'),
(3, 'Senior Boarder', 40, 0, 'rank3.gif'),
(4, 'Expert Boarder', 80, 0, 'rank4.gif'),
(5, 'Gold Boarder', 160, 0, 'rank5.gif'),
(6, 'Platinum Boarder', 320, 0, 'rank6.gif'),
(7, 'Administrator', 0, 1, 'rankadmin.gif'),
(8, 'Moderator', 0, 1, 'rankmod.gif'),
(9, 'Spammer', 0, 1, 'rankspammer.gif');
ALTER TABLE `jos_fb_users` ADD COLUMN `rank` tinyint(4) NOT NULL DEFAULT '0';
ALTER TABLE `jos_fb_categories` ADD COLUMN `id_last_msg` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `jos_fb_categories` ADD COLUMN `time_last_msg` int(11) NOT NULL DEFAULT '0';
ALTER TABLE `jos_fb_categories` ADD COLUMN `numTopics` mediumint(8) NOT NULL DEFAULT '0';
ALTER TABLE `jos_fb_categories` ADD COLUMN `numPosts` mediumint(8) NOT NULL DEFAULT '0';
ALTER TABLE `jos_fb_messages` ADD COLUMN `modified_by` int(7) NULL;
ALTER TABLE `jos_fb_messages` ADD COLUMN `modified_time` int(11) NULL;
ALTER TABLE `jos_fb_messages` ADD COLUMN `modified_reason` tinytext NULL;
ALTER TABLE `jos_fb_users` ADD COLUMN `personalText` tinytext NULL;
ALTER TABLE `jos_fb_users` ADD COLUMN `gender` tinyint(4) NOT NULL DEFAULT '0';
ALTER TABLE `jos_fb_users` ADD COLUMN `birthdate` date NOT NULL DEFAULT '0001-01-01';
ALTER TABLE `jos_fb_users` ADD COLUMN `location` varchar(50) NULL;
ALTER TABLE `jos_fb_users` ADD COLUMN `ICQ` varchar(50) NULL;
ALTER TABLE `jos_fb_users` ADD COLUMN `AIM` varchar(50) NULL;
ALTER TABLE `jos_fb_users` ADD COLUMN `YIM` varchar(50) NULL;
ALTER TABLE `jos_fb_users` ADD COLUMN `MSN` varchar(50) NULL;
ALTER TABLE `jos_fb_users` ADD COLUMN `SKYPE` varchar(50) NULL;
ALTER TABLE `jos_fb_users` ADD COLUMN `hideEmail` tinyint(1) NOT NULL DEFAULT '1';
ALTER TABLE `jos_fb_users` ADD COLUMN `showOnline` tinyint(1) NOT NULL DEFAULT '1';
+------------------------------------------------+
| Fireboard 1.0.0 to 1.0.1 |
+------------------------------------------------+
ALTER TABLE `jos_fb_attachments` ADD INDEX `mesid` (`mesid`);
ALTER TABLE `jos_fb_categories` ADD PRIMARY KEY (`id`);
ALTER TABLE `jos_fb_categories` ADD INDEX `parent` (`parent`);
ALTER TABLE `jos_fb_categories` ADD INDEX `published_pubaccess_id` (`published`,`pub_access`,`id`);
ALTER TABLE `jos_fb_categories` DROP KEY `catid`;
ALTER TABLE `jos_fb_categories` DROP KEY `catparent`;
CREATE TABLE `jos_fb_groups` (
`id` int(4) NOT NULL auto_increment,
`title` varchar(255) default NULL,
PRIMARY KEY (`id`)
);
ALTER TABLE `jos_fb_messages` ADD INDEX `time` (`time`);
ALTER TABLE `jos_fb_messages` ADD INDEX `locked` (`locked`);
ALTER TABLE `jos_fb_messages` ADD INDEX `hold_time` (`hold`,`time`);
ALTER TABLE `jos_fb_messages` DROP KEY `id`;
ALTER TABLE `jos_fb_messages_text` ADD PRIMARY KEY (`mesid`);
ALTER TABLE `jos_fb_messages_text` DROP KEY `mesid`;
ALTER TABLE `jos_fb_moderation` DROP KEY `catid`;
ALTER TABLE `jos_fb_users` ADD COLUMN `group_id` int(4) NULL DEFAULT '1';
ALTER TABLE `jos_fb_users` ADD COLUMN `uhits` int(11) NULL DEFAULT '0';
ALTER TABLE `jos_fb_users` ADD INDEX `group_id` (`group_id`);
ALTER TABLE `jos_fb_whoisonline` ADD INDEX `userid` (`userid`);
INSERT INTO `jos_fb_groups` VALUES ('1', 'Registered User');[/code:1]
|