|
Lines 2709-2714
CREATE TABLE `account_offsets` (
Link Here
|
| 2709 |
CONSTRAINT `account_offsets_ibfk_t` FOREIGN KEY (`type`) REFERENCES `account_offset_types` (`type`) ON DELETE CASCADE ON UPDATE CASCADE |
2709 |
CONSTRAINT `account_offsets_ibfk_t` FOREIGN KEY (`type`) REFERENCES `account_offset_types` (`type`) ON DELETE CASCADE ON UPDATE CASCADE |
| 2710 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2710 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 2711 |
|
2711 |
|
|
|
2712 |
-- |
| 2713 |
-- Table structure for table `cash_register_actions` |
| 2714 |
-- |
| 2715 |
|
| 2716 |
CREATE TABLE `cash_register_actions` ( |
| 2717 |
`id` int(11) NOT NULL auto_increment, -- unique identifier for each account register action |
| 2718 |
`code` varchar(24) NOT NULL, -- action code denoting the type of action recorded (enum), |
| 2719 |
`register_id` int(11) NOT NULL, -- id of cash_register this action belongs to, |
| 2720 |
`manager_id` int(11) NOT NULL, -- staff member performing the action |
| 2721 |
`amount` decimal(28,6) DEFAULT NULL, -- amount recorded in action (signed) |
| 2722 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
| 2723 |
PRIMARY KEY (`id`), |
| 2724 |
CONSTRAINT `cash_register_actions_manager` FOREIGN KEY (`manager_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 2725 |
CONSTRAINT `cash_register_actions_register` FOREIGN KEY (`register_id`) REFERENCES `cash_registers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
| 2726 |
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci; |
| 2727 |
|
| 2712 |
-- |
2728 |
-- |
| 2713 |
-- Table structure for table `action_logs` |
2729 |
-- Table structure for table `action_logs` |
| 2714 |
-- |
2730 |
-- |
| 2715 |
- |
|
|