sql/core_holiday.sql
authorAlan Knowles <alan@roojs.com>
Mon, 9 Nov 2020 05:57:20 +0000 (13:57 +0800)
committerAlan Knowles <alan@roojs.com>
Mon, 9 Nov 2020 05:57:20 +0000 (13:57 +0800)
sql/core_holiday.sql [new file with mode: 0644]

diff --git a/sql/core_holiday.sql b/sql/core_holiday.sql
new file mode 100644 (file)
index 0000000..f0449bb
--- /dev/null
@@ -0,0 +1,9 @@
+CREATE TABLE core_holiday (
+  id int(11)  NOT NULL auto_increment,
+  PRIMARY KEY   (id)
+);
+
+ALTER TABLE core_holiday ADD COLUMN holiday_date DATE NOT NULL DEFAULT '0000-00-00';
+ALTER TABLE core_holiday ADD COLUMN country VARCHAR(4) NOT NULL DEFAULT '';
+
+