source:
contrib/davical/dba/patches/1.1.9.sql
@
3733
Revision 3733, 243 bytes checked in by gabriel.malheiros, 14 years ago (diff) |
---|
Rev | Line | |
---|---|---|
[3733] | 1 | |
2 | -- Adding a primary key to the calendar_item table | |
3 | ||
4 | BEGIN; | |
5 | SELECT check_db_revision(1,1,8); | |
6 | ||
7 | ALTER TABLE calendar_item ADD PRIMARY KEY (user_no, dav_name ); | |
8 | ||
9 | SELECT new_db_revision(1,1,9, 'September' ); | |
10 | COMMIT; | |
11 | ROLLBACK; | |
12 | ||
13 | VACUUM FULL ANALYZE; |
Note: See TracBrowser
for help on using the repository browser.