POS db updates

update-pos-db.sql

--
-- Update to 1.7.9
--

ALTER TABLE `bakerloo_restful_orders` MODIFY COLUMN `json_payload` LONGTEXT;
ALTER TABLE `bakerloo_restful_orders` MODIFY COLUMN `json_payload_enc` LONGTEXT;

--
-- Table structure for table `bakerloo_restful_customprice`
--

CREATE TABLE `bakerloo_restful_customprice` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(11) unsigned NOT NULL,
  `order_increment_id` varchar(50) NOT NULL DEFAULT '',
  `admin_user` varchar(255) NOT NULL DEFAULT '',
  `store_id` smallint(5) unsigned DEFAULT NULL,
  `total_discount` decimal(12,4) DEFAULT '0.0000',
  `grand_total_before_discount` decimal(12,4) DEFAULT '0.0000',
  `grand_total_after_discount` decimal(12,4) DEFAULT '0.0000',
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Table structure for table `bakerloo_email_unsent`
--

CREATE TABLE `bakerloo_email_unsent` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int(11) unsigned NOT NULL,
  `customer_id` int(11) unsigned NOT NULL,
  `to_email` varchar(255) DEFAULT NULL,
  `attachment` varchar(255) DEFAULT NULL,
  `email_type` enum('magento','receipt','both') DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='Emails to be sent to customers.';

--
-- Update to 1.8.0
--

ALTER TABLE `bakerloo_restful_orders` ADD COLUMN `salesperson` varchar(255) NULL default NULL;

--
-- Table structure for table `bakerloo_backup_files`
--

CREATE TABLE `bakerloo_backup_files` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `device_key` varchar(50) NOT NULL DEFAULT '',
  `device_name` varchar(50) NOT NULL DEFAULT '',
  `backup_file_name` varchar(100) NOT NULL DEFAULT '',
  `storage` enum('magento','dropbox','drive') NOT NULL,
  `upload_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Backup files';


--
-- Update to 1.8.1
--

ALTER TABLE `bakerloo_restful_orders` ADD COLUMN `uses_default_customer` int(1) NULL default 0;

--
-- Table structure for table `bakerloo_payment_installments`
--

CREATE TABLE `bakerloo_payment_installments` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) unsigned NOT NULL,
  `order_id` int(11) unsigned NOT NULL,
  `order_increment_id` int(11) unsigned NOT NULL,
  `pos_order_id` int(11) unsigned NOT NULL,
  `payment_id` int(11) unsigned NOT NULL,
  `amount_paid` decimal(12,4) NOT NULL,
  `amount_refunded` decimal(12,4) NOT NULL,
  `currency` char(3) NOT NULL,
  `payment_method` varchar(255) NOT NULL,
  `created_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `updated_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`id`),
  KEY `FK_ORDER_ID` (`order_id`),
  KEY `FK_PARENT_ID` (`parent_id`),
  KEY `FK_POS_ORDER_ID` (`pos_order_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


--
-- Update to 1.8.2
--

ALTER TABLE `cataloginventory_stock_item` ADD COLUMN `updated_at` datetime NOT NULL default '0001-01-01 00:00:00';

DROP TABLE `bakerloo_restful_inventory_deltas`;