View | Details | Raw Unified | Return to bug 17705
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_17705-add_pos-terminal-syspref.sql (+4 lines)
Line 0 Link Here
1
INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES
2
('PosTerminalIP', '', NULL , 'POS Terminal IP address', 'Free'),
3
('PosTerminalPort',  '', NULL ,  'POS Terminal port',  'Integer'),
4
('PosTerminalCurrencyCode',  '', NULL ,  'POS Terminal currency code number',  'Integer');
(-)a/installer/data/mysql/atomicupdate/bug_17705-create_pos_terminal_transactions.perl (+17 lines)
Line 0 Link Here
1
$DBversion = 'XXX';
2
if( CheckVersion( $DBversion ) ) {
3
    # Create pos_terminal_transactions table:
4
    $dbh->do( "CREATE TABLE IF NOT EXISTS `pos_terminal_transactions` (
5
            `id` int(11) NOT NULL AUTO_INCREMENT,
6
            `accountlines_id` int(11) NOT NULL,
7
            `status` varchar(32) NOT NULL DEFAULT 'new',
8
            `response_code` varchar(5) DEFAULT NULL,
9
            `message_log` text,
10
            PRIMARY KEY (`id`),
11
            KEY `accountlines_id` (`accountlines_id`),
12
            CONSTRAINT `pos_terminal_transactions_ibfk1` FOREIGN KEY (`accountlines_id`) REFERENCES `accountlines` (`accountlines_id`) ON DELETE CASCADE ON UPDATE CASCADE
13
        ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci" );
14
15
    SetVersion( $DBversion );
16
    print "Upgrade to $DBversion done (Bug 17705 - Payments with cards through payment terminal)\n";
17
}
(-)a/installer/data/mysql/kohastructure.sql (+16 lines)
Lines 2748-2753 CREATE TABLE `account_offsets` ( Link Here
2748
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2748
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2749
2749
2750
--
2750
--
2751
-- Table structure for table `pos_terminal_transactions`
2752
--
2753
2754
DROP TABLE IF EXISTS `pos_terminal_transactions`
2755
CREATE TABLE `pos_terminal_transactions` (
2756
  `id` int(11) NOT NULL AUTO_INCREMENT,
2757
  `accountlines_id` int(11) NOT NULL,
2758
  `status` varchar(32) NOT NULL DEFAULT 'new',
2759
  `response_code` varchar(5) DEFAULT NULL,
2760
  `message_log` text,
2761
  PRIMARY KEY (`id`),
2762
  KEY `accountlines_id` (`accountlines_id`),
2763
  CONSTRAINT `pos_terminal_transactions_ibfk1` FOREIGN KEY (`accountlines_id`) REFERENCES `accountlines` (`accountlines_id`) ON DELETE CASCADE ON UPDATE CASCADE
2764
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2765
2766
--
2751
-- Table structure for table `action_logs`
2767
-- Table structure for table `action_logs`
2752
--
2768
--
2753
2769
(-)a/installer/data/mysql/sysprefs.sql (-1 / +3 lines)
Lines 438-443 INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` Link Here
438
('PayPalSandboxMode',  '1', NULL ,  'If enabled, the system will use PayPal''s sandbox server for testing, rather than the production server.',  'YesNo'),
438
('PayPalSandboxMode',  '1', NULL ,  'If enabled, the system will use PayPal''s sandbox server for testing, rather than the production server.',  'YesNo'),
439
('PayPalSignature',  '', NULL ,  'Your PayPal API signature',  'Free'),
439
('PayPalSignature',  '', NULL ,  'Your PayPal API signature',  'Free'),
440
('PayPalUser',  '', NULL ,  'Your PayPal API username ( email address )',  'Free'),
440
('PayPalUser',  '', NULL ,  'Your PayPal API username ( email address )',  'Free'),
441
('PosTerminalCurrencyCode',  '', NULL ,  'POS Terminal currency code number',  'Integer'),
442
('PosTerminalIP',  '', NULL ,  'POS Terminal IP address',  'Free'),
443
('PosTerminalPort',  '', NULL ,  'POS Terminal port',  'Integer'),
441
('PrefillItem','0','','When a new item is added, should it be prefilled with last created item values?','YesNo'),
444
('PrefillItem','0','','When a new item is added, should it be prefilled with last created item values?','YesNo'),
442
('previousIssuesDefaultSortOrder','asc','asc|desc','Specify the sort order of Previous Issues on the circulation page','Choice'),
445
('previousIssuesDefaultSortOrder','asc','asc|desc','Specify the sort order of Previous Issues on the circulation page','Choice'),
443
('printcirculationslips','1','','If ON, enable printing circulation receipts','YesNo'),
446
('printcirculationslips','1','','If ON, enable printing circulation receipts','YesNo'),
444
- 

Return to bug 17705