INSERT INTO `settings` (`settingid`, `settingvalue`, `settingint`, `friendlyname`, `description`, `changeable`, `grouping`, `ordinality`, `datatype`) VALUES ('useusaepay', '0', NULL, 'Use USAEPay', '1 = yes, 0 = no', '1', '9', '1', 'number'), ('usaepaykey', '', NULL, 'USAEpay API Key', 'You can retrieve the API key from your USAEpay console.', '1', '9', '2', 'text');

INSERT INTO `settings` (`settingid`, `settingvalue`, `settingint`, `friendlyname`, `description`, `changeable`, `grouping`, `ordinality`, `datatype`) VALUES ('usaepaysandbox', '1', NULL, 'Use USAEpay Sandbox?', '1=yes, 0=no. Sandbox does not process real transactions. You will need a sandbox API key to use this.', '1', '9', '3', 'number');

INSERT INTO `settings` (`settingid`, `settingvalue`, `settingint`, `friendlyname`, `description`, `changeable`, `grouping`, `ordinality`, `datatype`) VALUES ('usaepaypin', '1234', NULL, 'USAEpay Pin Number', 'Pin required for refund/void transactions. Obtain Pin on the USAEpay Console.', '1', '9', '2', 'text');

INSERT INTO `permissions` (`id`, `permission`) VALUES (NULL, 'Station Console');
INSERT INTO `userpermissions` (`userid`, `permissionid`) VALUES ('1', '10');
INSERT INTO `typepermissions` (`usertype`, `permissionid`) VALUES ('1', '10');
INSERT INTO `typepermissions` (`usertype`, `permissionid`) VALUES ('2', '10');
ALTER TABLE `orders` ADD `isready` INT NOT NULL DEFAULT '0' AFTER `deliveryby`;
ALTER TABLE `orders` ADD `closeby` INT NOT NULL DEFAULT '0' AFTER `isready`, ADD `closetime` INT NOT NULL DEFAULT '0' AFTER `closeby`;
