1 -- r/w of prdb_dbs || r/o prweb_vhost
4 -- All these changes were applied 3/8/2001
7 DROP SEQUENCE bug_bug_dependencies_pk_seq;--
8 DROP SEQUENCE bug_canned_responses_pk_seq;-- | sequence | tperdue
9 DROP SEQUENCE bug_category_pk_seq ;-- | sequence | tperdue
10 DROP SEQUENCE bug_filter_pk_seq ;-- | sequence | tperdue
11 DROP SEQUENCE bug_group_pk_seq ;-- | sequence | tperdue
12 DROP SEQUENCE bug_history_pk_seq ;-- | sequence | tperdue
13 DROP SEQUENCE bug_pk_seq ;-- | sequence | tperdue
14 DROP SEQUENCE bug_resolution_pk_seq ;-- | sequence | tperdue
15 DROP SEQUENCE bug_status_pk_seq ;-- | sequence | tperdue
16 DROP SEQUENCE bug_task_dependencies_pk_seq ;-- | sequence | tperdue
17 DROP SEQUENCE patch_category_pk_seq ;-- | sequence | tperdue
18 DROP SEQUENCE patch_history_pk_seq ;-- | sequence | tperdue
19 DROP SEQUENCE patch_pk_seq ;-- | sequence | tperdue
20 DROP SEQUENCE patch_status_pk_seq ;-- | sequence | tperdue
21 DROP SEQUENCE support_canned_responses_pk_seq;-- | sequence | tperdue
22 DROP SEQUENCE support_category_pk_seq ;-- | sequence | tperdue
23 DROP SEQUENCE support_history_pk_seq ;-- | sequence | tperdue
24 DROP SEQUENCE support_messages_pk_seq ;-- | sequence | tperdue
25 DROP SEQUENCE support_pk_seq ;-- | sequence | tperdue
26 DROP SEQUENCE support_status_pk_seq ;-- | sequence | tperdue
28 DROP TABLE bug ;-- | table | tperdue
29 DROP TABLE bug_bug_dependencies ;-- | table | tperdue
30 DROP TABLE bug_canned_responses ;-- | table | tperdue
31 DROP TABLE bug_category ;-- | table | tperdue
32 DROP TABLE bug_filter ;-- | table | tperdue
33 DROP TABLE bug_group ;-- | table | tperdue
34 DROP TABLE bug_history ;-- | table | tperdue
35 DROP TABLE bug_resolution ;-- | table | tperdue
36 DROP TABLE bug_status ;-- | table | tperdue
37 DROP TABLE bug_task_dependencies ;-- | table | tperdue
38 DROP TABLE patch ;-- | table | tperdue
39 DROP TABLE patch_category ;-- | table | tperdue
40 DROP TABLE patch_history ;-- | table | tperdue
41 DROP TABLE patch_status ;-- | table | tperdue
42 DROP TABLE support ;-- | table | tperdue
43 DROP TABLE support_canned_responses ;-- | table | tperdue
44 DROP TABLE support_category ;-- | table | tperdue
45 DROP TABLE support_history ;-- | table | tperdue
46 DROP TABLE support_messages ;-- | table | tperdue
47 DROP TABLE support_status ;-- | table | tperdue
49 alter table groups rename column use_bugs to dead1;
50 alter table groups rename column use_patch to dead2;
51 alter table groups rename column use_support to dead3;
52 alter table groups rename column new_bug_address to dead4;
53 alter table groups rename column new_patch_address to dead5;
54 alter table groups rename column new_support_address to dead6;
55 alter table groups rename column send_all_bugs to dead7;
56 alter table groups rename column send_all_patches to dead8;
57 alter table groups rename column send_all_support to dead9;
58 alter table groups rename column use_bug_depend_box to dead10;
59 alter table groups rename column bug_due_period to dead11;
60 alter table groups rename column patch_due_period to dead12;
61 alter table groups rename column support_due_period to dead13;
63 drop index groups_unix;
64 create unique index group_unix_uniq on groups (unix_group_name);