Code: Select all
-- 2.6.0
-- ALTER TABLE `#__phocagallery` ADD `imgorigsize` int(11) NOT NULL default '0' AFTER `hits` ;
-- ALTER TABLE `#__phocagallery_categories` ADD `owner_id` int(11) NOT NULL default '0' AFTER `parent_id` ;
--* ALTER TABLE `#__phocagallery` ADD `extid` varchar(255) NOT NULL default '' AFTER `hits` ;
--* ALTER TABLE `#__phocagallery` ADD `extl` varchar(255) NOT NULL default '' AFTER `hits` ;
--* ALTER TABLE `#__phocagallery` ADD `extm` varchar(255) NOT NULL default '' AFTER `hits` ;
--* ALTER TABLE `#__phocagallery` ADD `exts` varchar(255) NOT NULL default '' AFTER `hits` ;
--* ALTER TABLE `#__phocagallery` ADD `exto` varchar(255) NOT NULL default '' AFTER `hits` ;
--* ALTER TABLE `#__phocagallery` ADD `extw` varchar(255) NOT NULL default '' AFTER `hits` ;
--* ALTER TABLE `#__phocagallery` ADD `exth` varchar(255) NOT NULL default '' AFTER `hits` ;
-- ALTER TABLE `#__phocagallery_categories` ADD `extid` varchar(255) NOT NULL default '' AFTER `hits` ;
-- ALTER TABLE `#__phocagallery_categories` ADD `exta` varchar(255) NOT NULL default '' AFTER `hits` ;
-- ALTER TABLE `#__phocagallery_categories` ADD `extu` varchar(255) NOT NULL default '' AFTER `hits` ;
-- missing lines
--* ALTER TABLE `#__phocagallery` ADD `approved` tinyint(1) NOT NULL default '0' AFTER `imgorigsize`;
--* ALTER TABLE `#__phocagallery_categories` ADD `approved` tinyint(1) NOT NULL default '0' AFTER `published` ; No, does not matter.Since I am not an MySQL expert, I also discoverd that some fields in some tables had another order has in the original installation scrip.
Is this important ?
For now I will not change the upgrade script as upgrading feature will be changed in Joomla! 1.6 so I hope the upgrade feature can be used then.Perhaps you can add in the next release a script, just like in CB, which checks and fixes the tables