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

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

Return to bug 23355