ALTER TABLE `#__layout_node` CHANGE `useredit` `useredit` TINYINT UNSIGNED NOT NULL DEFAULT '0';


/* CONDITIONCOLUMNDELETE||layout_mlinks||ref_wid */ ALTER TABLE `#__layout_mlinks` DROP `ref_wid`;


/* CONDITIONCOLUMNDELETE||layout_multiforms||ref_wid */ ALTER TABLE `#__layout_multiforms` DROP `ref_wid`;


ALTER TABLE `#__currency_node` CHANGE `basic` `basic` INT UNSIGNED NOT NULL DEFAULT '0';


DELETE FROM `#__dataset_foreign` WHERE `map` LIKE 'created';
/* CONDITIONINDEX||dataset_foreign||UK_dataset_foreign_feid_dbtid_red_dbtid */ ALTER TABLE `#__dataset_foreign` DROP INDEX `UK_dataset_foreign_feid_dbtid_red_dbtid`, ADD UNIQUE `UK_dataset_foreign_dbtid_red_dbtid_map_map2` (`dbtid`, `ref_dbtid`, `map`, `map2`) USING BTREE;
/* CONDITIONINDEX||dataset_foreign||IX_dataset_foreign_publish_ref_feid */ ALTER TABLE `#__dataset_foreign` DROP INDEX `IX_dataset_foreign_publish_ref_feid`, ADD INDEX `IX_dataset_foreign_publish` (`publish`);
ALTER TABLE `#__dataset_foreign` ADD UNIQUE `UK_dataset_foreign_namekey` (`namekey`(50));
DELETE FROM `#__dataset_foreign` WHERE `namekey` = 'FK_product_pricetrans_pricetype';
DELETE FROM `#__dataset_foreign` WHERE `namekey` = 'FK_product_price_pricetype';

/* CONDITIONCOLUMN||dataset_tables||node */ ALTER TABLE `#__dataset_tables` ADD `node` VARCHAR ( 50 ) NOT NULL;


/* CONDITIONINDEX||translation_populate||IX_translation_populate_imac */ ALTER TABLE `#__translation_populate`  ADD INDEX `IX_translation_populate_imac` ( `imac` );


/* CONDITIONINDEX||members_node||IX_members_node_timezone */ ALTER TABLE `#__members_node`  ADD INDEX `IX_members_node_timezone` ( `timezone` );
