|
Lines 2743-2748
CREATE TABLE `account_offsets` (
Link Here
|
| 2743 |
CONSTRAINT `account_offsets_ibfk_t` FOREIGN KEY (`type`) REFERENCES `account_offset_types` (`type`) ON DELETE CASCADE ON UPDATE CASCADE |
2743 |
CONSTRAINT `account_offsets_ibfk_t` FOREIGN KEY (`type`) REFERENCES `account_offset_types` (`type`) ON DELETE CASCADE ON UPDATE CASCADE |
| 2744 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
2744 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; |
| 2745 |
|
2745 |
|
|
|
2746 |
-- |
| 2747 |
-- Table structure for table `cash_register_actions` |
| 2748 |
-- |
| 2749 |
|
| 2750 |
CREATE TABLE `cash_register_actions` ( |
| 2751 |
`id` int(11) NOT NULL auto_increment, -- unique identifier for each account register action |
| 2752 |
`code` varchar(24) NOT NULL, -- action code denoting the type of action recorded (enum), |
| 2753 |
`register_id` int(11) NOT NULL, -- id of cash_register this action belongs to, |
| 2754 |
`manager_id` int(11) NOT NULL, -- staff member performing the action |
| 2755 |
`amount` decimal(28,6) DEFAULT NULL, -- amount recorded in action (signed) |
| 2756 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
| 2757 |
PRIMARY KEY (`id`), |
| 2758 |
CONSTRAINT `cash_register_actions_manager` FOREIGN KEY (`manager_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 2759 |
CONSTRAINT `cash_register_actions_register` FOREIGN KEY (`register_id`) REFERENCES `cash_registers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
| 2760 |
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci; |
| 2761 |
|
| 2746 |
-- |
2762 |
-- |
| 2747 |
-- Table structure for table `action_logs` |
2763 |
-- Table structure for table `action_logs` |
| 2748 |
-- |
2764 |
-- |
| 2749 |
- |
|
|