diff options
Diffstat (limited to 'calendar/drivers/database/SQL/postgres/2015022700.sql')
-rw-r--r-- | calendar/drivers/database/SQL/postgres/2015022700.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/calendar/drivers/database/SQL/postgres/2015022700.sql b/calendar/drivers/database/SQL/postgres/2015022700.sql new file mode 100644 index 0000000..0de989e --- /dev/null +++ b/calendar/drivers/database/SQL/postgres/2015022700.sql @@ -0,0 +1,9 @@ +-- add identifier for recurring instances and exceptions + +ALTER TABLE events ADD instance character varying(16) NOT NULL; +ALTER TABLE events ADD isexception smallint NOT NULL DEFAULT '0'; + +-- extend alarms columns for multiple values + +ALTER TABLE events ALTER COLUMN alarms TYPE text; + |