1 CREATE INDEX layouts_contents_owner_idx ON layouts_contents (owner_type,owner_id);
3 ALTER TABLE users_idx ADD PRIMARY KEY (user_id);
4 ALTER TABLE groups_idx ADD PRIMARY KEY (group_id);
6 DROP INDEX artmonitor_useridartid;
7 ALTER TABLE artifact_monitor DROP COLUMN id;
8 ALTER TABLE artifact_monitor ADD FOREIGN KEY (user_id) REFERENCES users(user_id);
9 DROP SEQUENCE artifact_monitor_id_seq;
11 ALTER TABLE docdata_monitored_docman DROP COLUMN monitor_id;
12 ALTER TABLE docdata_monitored_docman ADD PRIMARY KEY (doc_id, user_id);
13 ALTER TABLE docdata_monitored_docman ADD FOREIGN KEY (user_id) REFERENCES users(user_id);
14 ALTER TABLE docdata_monitored_docman ADD FOREIGN KEY (doc_id) REFERENCES doc_data(docid);
15 DROP SEQUENCE docdata_monitored_docman_pk_seq;
17 ALTER TABLE docgroup_monitored_docman DROP COLUMN monitor_id;
18 ALTER TABLE docgroup_monitored_docman ADD PRIMARY KEY (docgroup_id, user_id);
19 ALTER TABLE docgroup_monitored_docman ADD FOREIGN KEY (user_id) REFERENCES users(user_id);
20 ALTER TABLE docgroup_monitored_docman ADD FOREIGN KEY (docgroup_id) REFERENCES doc_groups(doc_group);
21 DROP SEQUENCE docgroup_monitored_docman_pk_seq;
23 DROP INDEX forummonitoredforums_useridforumid;
24 ALTER TABLE forum_monitored_forums DROP COLUMN monitor_id;
25 ALTER TABLE forum_monitored_forums ADD FOREIGN KEY (user_id) REFERENCES users(user_id);
26 ALTER TABLE forum_monitored_forums ADD FOREIGN KEY (forum_id) REFERENCES forum_group_list(group_forum_id);
27 DROP SEQUENCE forum_monitored_forums_pk_seq;
29 DROP INDEX userdiarymon_useridmonitoredid;
30 ALTER TABLE user_diary_monitor ADD FOREIGN KEY (user_id) REFERENCES users(user_id);
31 ALTER TABLE user_diary_monitor ADD FOREIGN KEY (monitored_user) REFERENCES users(user_id);
32 ALTER TABLE user_diary_monitor DROP COLUMN monitor_id;
33 DROP SEQUENCE user_diary_monitor_pk_seq;