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

(-)a/installer/data/mysql/atomicupdate/bug_23355.perl (+19 lines)
Line 0 Link Here
1
$DBversion = 'XXX';    # will be replaced by the RM
2
if ( CheckVersion($DBversion) ) {
3
4
    $dbh->do(qq{
5
CREATE TABLE `cash_register_actions` (
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),
8
  `manager_id` int(11) NOT NULL, -- staff member performing the action
9
  `amount` decimal(28,6) DEFAULT NULL, -- amount recorded in action (signed)
10
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
11
  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_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
    });
16
17
    SetVersion($DBversion);
18
    print "Upgrade to $DBversion done (Bug 23355 - Add cash_register_actions table)\n";
19
}
(-)a/installer/data/mysql/kohastructure.sql (-1 / +16 lines)
Lines 2743-2748 CREATE TABLE `account_offsets` ( Link Here
2743
  CONSTRAINT `account_offsets_ibfk_t` FOREIGN KEY (`type`) REFERENCES `account_offset_types` (`type`) ON DELETE CASCADE ON UPDATE CASCADE
2743
  CONSTRAINT `account_offsets_ibfk_t` FOREIGN KEY (`type`) REFERENCES `account_offset_types` (`type`) ON DELETE CASCADE ON UPDATE CASCADE
2744
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2744
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
2745
2745
2746
--
2747
-- Table structure for table `cash_register_actions`
2748
--
2749
2750
CREATE TABLE `cash_register_actions` (
2751
  `id` int(11) NOT NULL auto_increment, -- unique identifier for each account register action
2752
  `code` varchar(24) NOT NULL, -- action code denoting the type of action recorded (enum),
2753
  `register_id` int(11) NOT NULL, -- id of cash_register this action belongs to,
2754
  `manager_id` int(11) NOT NULL, -- staff member performing the action
2755
  `amount` decimal(28,6) DEFAULT NULL, -- amount recorded in action (signed)
2756
  `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
2757
  PRIMARY KEY (`id`),
2758
  CONSTRAINT `cash_register_actions_manager` FOREIGN KEY (`manager_id`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UPDATE CASCADE,
2759
  CONSTRAINT `cash_register_actions_register` FOREIGN KEY (`register_id`) REFERENCES `cash_registers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
2760
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
2761
2746
--
2762
--
2747
-- Table structure for table `action_logs`
2763
-- Table structure for table `action_logs`
2748
--
2764
--
2749
- 

Return to bug 23355