source:
contrib/davical/dba/patches/1.1.9.sql
@
3733
Revision 3733, 243 bytes checked in by gabriel.malheiros, 14 years ago (diff) |
---|
Line | |
---|---|
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.