|
Lines 2-17
$DBversion = 'XXX'; # will be replaced by the RM
Link Here
|
| 2 |
if ( CheckVersion($DBversion) ) { |
2 |
if ( CheckVersion($DBversion) ) { |
| 3 |
|
3 |
|
| 4 |
$dbh->do(qq{ |
4 |
$dbh->do(qq{ |
| 5 |
CREATE TABLE `cash_register_actions` ( |
5 |
CREATE TABLE IF NOT EXISTS `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 |
`manager_id` int(11) NOT NULL, -- staff member performing the action |
8 |
`register_id` int(11) NOT NULL, -- id of cash_register this action belongs to, |
| 9 |
`amount` decimal(28,6) DEFAULT NULL, -- amount recorded in action (signed) |
9 |
`manager_id` int(11) NOT NULL, -- staff member performing the action |
| 10 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
10 |
`amount` decimal(28,6) DEFAULT NULL, -- amount recorded in action (signed) |
| 11 |
PRIMARY KEY (`id`), |
11 |
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, |
| 12 |
CONSTRAINT `cash_register_actions_manager` FOREIGN KEY (`manager_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, |
12 |
PRIMARY KEY (`id`), |
| 13 |
CONSTRAINT `cash_register_actions_register` FOREIGN KEY (`register_id`) REFERENCES `cash_registers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
13 |
CONSTRAINT `cash_register_actions_manager` FOREIGN KEY (`manager_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, |
| 14 |
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci; |
14 |
CONSTRAINT `cash_register_actions_register` FOREIGN KEY (`register_id`) REFERENCES `cash_registers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE |
|
|
15 |
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci; |
| 15 |
}); |
16 |
}); |
| 16 |
|
17 |
|
| 17 |
SetVersion($DBversion); |
18 |
SetVersion($DBversion); |
| 18 |
- |
|
|