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) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'new',
8
            `response_code` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
9
            `message_log` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
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=utf8 COLLATE=utf8_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 (-1 / +14 lines)
Lines 1362-1367 CREATE TABLE pending_offline_operations ( Link Here
1362
  PRIMARY KEY (operationid)
1362
  PRIMARY KEY (operationid)
1363
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1363
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1364
1364
1365
--
1366
-- Table structure for table `pos_terminal_transactions`
1367
--
1368
1369
CREATE TABLE `pos_terminal_transactions` (
1370
  `id` int(11) NOT NULL AUTO_INCREMENT,
1371
  `accountlines_id` int(11) NOT NULL,
1372
  `status` varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'new',
1373
  `response_code` varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
1374
  `message_log` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
1375
  PRIMARY KEY (`id`),
1376
  KEY `accountlines_id` (`accountlines_id`),
1377
  CONSTRAINT `pos_terminal_transactions_ibfk1` FOREIGN KEY (`accountlines_id`) REFERENCES `accountlines` (`accountlines_id`) ON DELETE CASCADE ON UPDATE CASCADE
1378
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1365
1379
1366
--
1380
--
1367
-- Table structure for table `printers`
1381
-- Table structure for table `printers`
1368
- 

Return to bug 17705