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 |
- |
|
|