View | Details | Raw Unified | Return to bug 23355
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_23355.perl (-11 / +11 lines)
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
- 

Return to bug 23355