ALTER TABLE `#__spsimpleportfolio_items` CHANGE `spsimpleportfolio_item_id` `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `#__spsimpleportfolio_items` CHANGE `category_id` `catid` int NOT NULL;
ALTER TABLE `#__spsimpleportfolio_items` CHANGE `spsimpleportfolio_tag_id` `tagids` text NOT NULL;
ALTER TABLE `#__spsimpleportfolio_items` CHANGE `enabled` `published` tinyint NOT NULL DEFAULT '1';
ALTER TABLE `#__spsimpleportfolio_items` CHANGE `created_on` `created` datetime NOT NULL;
ALTER TABLE `#__spsimpleportfolio_items` CHANGE `modified_on` `modified` datetime NOT NULL;
ALTER TABLE `#__spsimpleportfolio_items` CHANGE `locked_by` `checked_out` bigint NULL;
ALTER TABLE `#__spsimpleportfolio_items` CHANGE `locked_on` `checked_out_time` datetime NULL;

ALTER TABLE `#__spsimpleportfolio_tags` CHANGE `spsimpleportfolio_tag_id` `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `#__spsimpleportfolio_tags` DROP `language`;