From 56e50c3a4fbbf30a4c7d863c70192584d99c3a30 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 --- .../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.7.4