From 92351fad60a34b3adcf77fb0506bfe0d2f7a94a6 Mon Sep 17 00:00:00 2001 From: Baptiste Wojtkowski Date: Wed, 28 Jun 2017 14:31:14 +0000 Subject: [PATCH] Bug 18874: Add unicity constraint Signed-off-by: Lee Jamison --- .../data/mysql/atomicupdate/bug_18874_add_constaint_hollidays.sql | 3 +++ 1 file changed, 3 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_18874_add_constaint_hollidays.sql diff --git a/installer/data/mysql/atomicupdate/bug_18874_add_constaint_hollidays.sql b/installer/data/mysql/atomicupdate/bug_18874_add_constaint_hollidays.sql new file mode 100644 index 0000000..0a8b177 --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_18874_add_constaint_hollidays.sql @@ -0,0 +1,3 @@ +ALTER IGNORE TABLE special_holidays ADD CONSTRAINT UNIQUE daymonthyear (branchcode, day, month, year); +ALTER IGNORE TABLE repeatable_holidays ADD CONSTRAINT UNIQUE daymonth (branchcode, day, month); +ALTER IGNORE TABLE repeatable_holidays ADD CONSTRAINT UNIQUE weekday (branchcode, weekday); -- 2.1.4