CREATE TABLE `yamoney_transactions_$mid` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cid` int(11) NOT NULL,
  `invoiceId` bigint(20) NOT NULL,
  `orderSumAmount` decimal(10,2) NOT NULL,
  `orderSumCurrencyPaycash` int(11) NOT NULL,
  `orderSumBankPaycash` int(11) NOT NULL,
  `shopSumAmount` decimal(10,2) NOT NULL,
  `shopSumCurrencyPaycash` int(11) NOT NULL,
  `shopSumBankPaycash` int(11) NOT NULL,
  `paymentPayerCode` varchar(32) NOT NULL,
  `paymentDateTime` timestamp NOT NULL,
  PRIMARY KEY (`id`),
  KEY `invoiceid` (`invoiceId`)
);

ALTER TABLE `yamoney_transactions_$mid` ADD COLUMN `paymentType` VARCHAR(20) NULL;
ALTER TABLE `yamoney_transactions_$mid` ADD COLUMN `rawRequest` TEXT NULL;
ALTER TABLE `yamoney_transactions_$mid` ADD COLUMN `yandexId` VARCHAR(40), ADD INDEX (`yandexId`);
ALTER TABLE `yamoney_transactions_$mid` ADD COLUMN `paymentId` int(11) NOT NULL AFTER `paymentDateTime`;
ALTER TABLE `yamoney_transactions_$mid` ADD COLUMN `status` varchar(30) DEFAULT NULL AFTER `paymentType`;
ALTER TABLE `yamoney_transactions_$mid` CHANGE COLUMN `paymentType` `paymentType` varchar(20) DEFAULT '';
