|
Lines 5-15
if ( CheckVersion($DBversion) ) {
Link Here
|
| 5 |
CREATE TABLE `cash_register_actions` ( |
5 |
CREATE TABLE `cash_register_actions` ( |
| 6 |
`id` int(11) NOT NULL auto_increment, -- unique identifier for each account register action |
6 |
`id` int(11) NOT NULL auto_increment, -- unique identifier for each account register action |
| 7 |
`code` varchar(24) NOT NULL, -- action code denoting the type of action recorded (enum), |
7 |
`code` varchar(24) NOT NULL, -- action code denoting the type of action recorded (enum), |
|
|
8 |
`register_id` int(11) NOT NULL, -- id of cash_register this action belongs to, |
| 8 |
`manager_id` int(11) NOT NULL, -- staff member performing the action |
9 |
`manager_id` int(11) NOT NULL, -- staff member performing the action |
| 9 |
`amount` decimal(28,6) DEFAULT NULL, -- amount recorded in action (signed) |
10 |
`amount` decimal(28,6) DEFAULT NULL, -- amount recorded in action (signed) |
| 10 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
11 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
| 11 |
PRIMARY KEY (`id`), |
12 |
PRIMARY KEY (`id`), |
| 12 |
CONSTRAINT `cash_register_actions_manager` FOREIGN KEY (`manager_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
13 |
CONSTRAINT `cash_register_actions_manager` FOREIGN KEY (`manager_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 13 |
CONSTRAINT `cash_register_actions_register` FOREIGN KEY (`register_id`) REFERENCES `cash_registers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
14 |
CONSTRAINT `cash_register_actions_register` FOREIGN KEY (`register_id`) REFERENCES `cash_registers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
| 14 |
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci; |
15 |
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci; |
| 15 |
}); |
16 |
}); |
| 16 |
- |
|
|