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