annotate plugins/calendar/drivers/database/SQL/postgres/2015022700.sql @ 45:e11491f625b0
add info action, one 7.3 -> 8.4 nit
| author |
Charlie Root |
| date |
Thu, 28 Aug 2025 10:40:29 -0400 |
| parents |
f6fe4b6ae66a |
| children |
|
| rev |
line source |
|
3
|
1 -- add identifier for recurring instances and exceptions
|
|
|
2
|
|
|
3 ALTER TABLE events ADD instance character varying(16) NOT NULL;
|
|
|
4 ALTER TABLE events ADD isexception smallint NOT NULL DEFAULT '0';
|
|
|
5
|
|
|
6 -- extend alarms columns for multiple values
|
|
|
7
|
|
|
8 ALTER TABLE events ALTER COLUMN alarms TYPE text;
|
|
|
9
|