|
Lines 2682-2687
CREATE TABLE `account_offsets` (
Link Here
|
| 2682 |
CONSTRAINT `account_offsets_ibfk_t` FOREIGN KEY (`type`) REFERENCES `account_offset_types` (`type`) ON DELETE CASCADE ON UPDATE CASCADE |
2682 |
CONSTRAINT `account_offsets_ibfk_t` FOREIGN KEY (`type`) REFERENCES `account_offset_types` (`type`) ON DELETE CASCADE ON UPDATE CASCADE |
| 2683 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2683 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 2684 |
|
2684 |
|
|
|
2685 |
-- |
| 2686 |
-- Table structure for table `cash_register_actions` |
| 2687 |
-- |
| 2688 |
|
| 2689 |
CREATE TABLE `cash_register_actions` ( |
| 2690 |
`id` int(11) NOT NULL auto_increment, -- unique identifier for each account register action |
| 2691 |
`code` varchar(24) NOT NULL, -- action code denoting the type of action recorded (enum), |
| 2692 |
`register_id` int(11) NOT NULL, -- id of cash_register this action belongs to, |
| 2693 |
`manager_id` int(11) NOT NULL, -- staff member performing the action |
| 2694 |
`amount` decimal(28,6) DEFAULT NULL, -- amount recorded in action (signed) |
| 2695 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
| 2696 |
PRIMARY KEY (`id`), |
| 2697 |
CONSTRAINT `cash_register_actions_manager` FOREIGN KEY (`manager_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 2698 |
CONSTRAINT `cash_register_actions_register` FOREIGN KEY (`register_id`) REFERENCES `cash_registers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
| 2699 |
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci; |
| 2700 |
|
| 2685 |
-- |
2701 |
-- |
| 2686 |
-- Table structure for table `action_logs` |
2702 |
-- Table structure for table `action_logs` |
| 2687 |
-- |
2703 |
-- |
| 2688 |
- |
|
|