mirror of
https://gitlab.com/davical-project/davical.git
synced 2026-02-19 04:23:36 +00:00
13 lines
243 B
PL/PgSQL
13 lines
243 B
PL/PgSQL
|
|
-- Adding a primary key to the calendar_item table
|
|
|
|
BEGIN;
|
|
SELECT check_db_revision(1,1,8);
|
|
|
|
ALTER TABLE calendar_item ADD PRIMARY KEY (user_no, dav_name );
|
|
|
|
SELECT new_db_revision(1,1,9, 'September' );
|
|
COMMIT;
|
|
ROLLBACK;
|
|
|
|
VACUUM FULL ANALYZE; |