ALTER TABLE  `computopcw_transaction` CHANGE  `id`  `transactionId` BIGINT( 20 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE  `computopcw_transaction` ADD  `transactionExternalId` VARCHAR( 255 ) AFTER  `transactionId`;
ALTER TABLE  `computopcw_transaction` CHANGE  `order_id`  `orderId` VARCHAR( 255 );
ALTER TABLE  `computopcw_transaction` ADD  `temporaryOrderId` VARCHAR( 255 ) AFTER  `orderId`;
ALTER TABLE  `computopcw_transaction` CHANGE  `alias_for_display`  `aliasForDisplay` VARCHAR( 255 );
ALTER TABLE  `computopcw_transaction` CHANGE  `alias_active`  `aliasActive` CHAR( 1 );
ALTER TABLE  `computopcw_transaction` ADD  `paymentMachineName` VARCHAR( 255 ) AFTER  `aliasActive`;
ALTER TABLE  `computopcw_transaction` CHANGE  `payment_method`  `paymentMethod` VARCHAR( 255 );
ALTER TABLE  `computopcw_transaction` CHANGE  `transaction_object`  `transactionObject` LONGTEXT;
ALTER TABLE  `computopcw_transaction` CHANGE  `authorization_type`  `authorizationType` VARCHAR( 255 );
ALTER TABLE  `computopcw_transaction` CHANGE  `user_id`  `customerId` VARCHAR( 255 );
ALTER TABLE  `computopcw_transaction` CHANGE  `updated_at`  `updatedOn` DATETIME;
ALTER TABLE  `computopcw_transaction` CHANGE  `created_at`  `createdOn` DATETIME;
ALTER TABLE  `computopcw_transaction` CHANGE  `payment_id`  `paymentId` VARCHAR( 255 );
ALTER TABLE  `computopcw_transaction` CHANGE  `updatable`  `updatable` CHAR( 1 );
ALTER TABLE  `computopcw_transaction` ADD  `executeUpdateOn` DATETIME AFTER  `updatable`;
ALTER TABLE  `computopcw_transaction` ADD  `authorizationAmount` DECIMAL( 20, 5 ) AFTER  `executeUpdateOn`;
ALTER TABLE  `computopcw_transaction` ADD  `authorizationStatus` VARCHAR( 255 ) AFTER  `authorizationAmount`;
ALTER TABLE  `computopcw_transaction` ADD  `paid` CHAR( 1 ) AFTER  `authorizationStatus`;
ALTER TABLE  `computopcw_transaction` ADD  `currency` VARCHAR( 255 ) AFTER  `paid`;
ALTER TABLE  `computopcw_transaction` CHANGE  `session_data`  `sessionData` LONGTEXT;
ALTER TABLE  `computopcw_transaction` ADD KEY  `transactionExternalId_orderId_paymentId` (  `transactionExternalId` ,  `orderId` ,  `paymentId` );

ALTER TABLE  `computopcw_customer_context` CHANGE  `user_id`  `customerId` VARCHAR( 255 );
ALTER TABLE  `computopcw_customer_context`  DROP PRIMARY KEY;
ALTER TABLE  `computopcw_customer_context` ADD  `contextId` BIGINT( 20 ) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;
ALTER TABLE  `computopcw_customer_context` CHANGE  `customer_context`  `context_values` LONGTEXT;
ALTER TABLE  `computopcw_customer_context` DROP  `created_at`;
ALTER TABLE  `computopcw_customer_context` DROP  `updated_at`;
ALTER TABLE  `computopcw_customer_context` ADD UNIQUE KEY  `customerId` (  `customerId` );

ALTER TABLE  `computopcw_storage` CHANGE  `key_id` `keyId` BIGINT( 20 ) NOT NULL AUTO_INCREMENT;
ALTER TABLE  `computopcw_storage` CHANGE  `key_space` `keySpace` VARCHAR( 170 );
ALTER TABLE  `computopcw_storage` CHANGE  `key_name` `keyName` VARCHAR( 170 );
ALTER TABLE  `computopcw_storage` CHANGE  `key_value` `keyValue` LONGTEXT;
