Attachment 97048 Details for Bug 23355 – Bug 23355: Link cash_register_actions to cash_registers by foreign key

[patch] Bug 23355: Link cash_register_actions to cash_registers by foreign key

Bug-23355-Link-cashregisteractions-to-cashregister.patch (text/plain), 2.73 KB, created by Kyle M Hall (khall) on 2020-01-08 18:12:16 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Kyle M Hall (khall)

Created: 2020-01-08 18:12:16 UTC

Size: 2.73 KB

patch

obsolete

>From 801eb9ae0c5daf02c86ee2a79e9e8017c9f506da Mon Sep 17 00:00:00 2001
>From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>Date: Fri, 13 Sep 2019 14:11:37 +0100
>Subject: [PATCH] Bug 23355: Link cash_register_actions to cash_registers by
> foreign key
>
>Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com>
>---
> .../data/mysql/atomicupdate/bug_23355.perl    | 21 ++++++++++---------
> 1 file changed, 11 insertions(+), 10 deletions(-)
>
>diff --git a/installer/data/mysql/atomicupdate/bug_23355.perl b/installer/data/mysql/atomicupdate/bug_23355.perl
>index 6517d5361c..72bca27942 100644
>--- a/installer/data/mysql/atomicupdate/bug_23355.perl
>+++ b/installer/data/mysql/atomicupdate/bug_23355.perl
>@@ -2,16 +2,17 @@ $DBversion = 'XXX';    # will be replaced by the RM
> if ( CheckVersion($DBversion) ) {
> 
>     $dbh->do(qq{
>-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),
>-  `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_register` FOREIGN KEY (`register_id`) REFERENCES `cash_registers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
>-) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
>+        CREATE TABLE  IF NOT EXISTS `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 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;
>     });
> 
>     SetVersion($DBversion);
>-- 
>2.21.0 (Apple Git-122.2)

Actions: View | Diff | Splinter Review

Attachments on bug 23355: 92941 | 92942 | 92943 | 92944 | 92945 | 92946 | 92947 | 92948 | 92949 | 92950 | 92951 | 92952 | 92953 | 97031 | 97032 | 97033 | 97034 | 97035 | 97036 | 97037 | 97038 | 97039 | 97040 | 97041 | 97043 | 97044 | 97045 | 97046 | 97047 | 97048 | 97049 | 97050 | 97051 | 97052 | 97053 | 97054 | 97077 | 97078 | 97079 | 97080 | 97081 | 97082 | 97083 | 97084 | 97085 | 97086 | 97087 | 97088 | 97089 | 97706 | 97707 | 97708 | 97709 | 97710 | 97711 | 97712 | 97713 | 97714 | 97715 | 97716 | 97784 | 97785 | 97786 | 97787 | 97788 | 97789 | 97790 | 97791 | 97792 | 97793 | 97794 | 97816 | 97817 | 97818 | 97819 | 97820 | 97821 | 97822 | 97823 | 98026 | 98027 | 98028 | 98835 | 98836 | 98837 | 98838 | 98839 | 98840 | 98841 | 98842 | 100009 | 100010 | 100011 | 100012 | 100013 | 100014 | 100015 | 100016 | 100017 | 100018 | 100019 | 100020 | 100021 | 100030 | 100090 | 101685