Mercurial > hg > rc1

annotate plugins/calendar/drivers/database/SQL/postgres/2015022700.sql @ 16:165944ca08e7

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
not using these after all
author Charlie Root
date Sat, 13 Jan 2018 09:45:02 -0500
parents f6fe4b6ae66a
children
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
3
f6fe4b6ae66a calendar plugin nearly as distributed
Charlie Root
parents:
diff changeset
1 -- add identifier for recurring instances and exceptions
f6fe4b6ae66a calendar plugin nearly as distributed
Charlie Root
parents:
diff changeset
2
f6fe4b6ae66a calendar plugin nearly as distributed
Charlie Root
parents:
diff changeset
3 ALTER TABLE events ADD instance character varying(16) NOT NULL;
f6fe4b6ae66a calendar plugin nearly as distributed
Charlie Root
parents:
diff changeset
4 ALTER TABLE events ADD isexception smallint NOT NULL DEFAULT '0';
f6fe4b6ae66a calendar plugin nearly as distributed
Charlie Root
parents:
diff changeset
5
f6fe4b6ae66a calendar plugin nearly as distributed
Charlie Root
parents:
diff changeset
6 -- extend alarms columns for multiple values
f6fe4b6ae66a calendar plugin nearly as distributed
Charlie Root
parents:
diff changeset
7
f6fe4b6ae66a calendar plugin nearly as distributed
Charlie Root
parents:
diff changeset
8 ALTER TABLE events ALTER COLUMN alarms TYPE text;
f6fe4b6ae66a calendar plugin nearly as distributed
Charlie Root
parents:
diff changeset
9