@@ -, +, @@ foreign key --- installer/data/mysql/atomicupdate/bug_23355.perl | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) --- a/installer/data/mysql/atomicupdate/bug_23355.perl +++ a/installer/data/mysql/atomicupdate/bug_23355.perl @@ -5,11 +5,12 @@ if ( CheckVersion($DBversion) ) { CREATE TABLE `cash_register_actions` ( `id` int(11) NOT NULL auto_increment, -- unique identifier for each account register action `code` varchar(24) NOT NULL, -- action code denoting the type of action recorded (enum), + `register_id` int(11) NOT NULL, -- id of cash_register this action belongs to, `manager_id` int(11) NOT NULL, -- staff member performing the action `amount` decimal(28,6) DEFAULT NULL, -- amount recorded in action (signed) `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, PRIMARY KEY (`id`), - CONSTRAINT `cash_register_actions_manager` FOREIGN KEY (`manager_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE SET NULL ON UPDATE CASCADE, + CONSTRAINT `cash_register_actions_manager` FOREIGN KEY (`manager_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `cash_register_actions_register` FOREIGN KEY (`register_id`) REFERENCES `cash_registers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci; }); --