@@ -, +, @@ --- .../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 --- a/installer/data/mysql/atomicupdate/bug_18874_add_constaint_hollidays.sql +++ a/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); --