1 drop sequence group_type_pk_seq;
2 DROP SEQUENCE project_metric_weekly_tm_pk_seq;
3 DROP SEQUENCE system_history_pk_seq;
4 DROP SEQUENCE system_machines_pk_seq;
5 DROP SEQUENCE system_news_pk_seq;
6 DROP SEQUENCE system_services_pk_seq;
7 DROP SEQUENCE system_status_pk_seq;
10 -- getting rid of more obsolete flags
11 -- PG 7.3 will allow us to DROP all these dead columns
13 ALTER TABLE user_group RENAME COLUMN bug_flags to dead1;
14 ALTER TABLE user_group RENAME COLUMN patch_flags to dead2;
15 ALTER TABLE user_group RENAME COLUMN support_flags to dead3;
16 drop INDEX bug_flags_idx;
19 -- Change Admin user realname if it's 'Sourceforge admin'
21 UPDATE users SET realname='Local GForge Admin' where user_id=101 and realname='Sourceforge admin';
24 -- OSX Theme by Richard Offer
26 INSERT INTO themes (dirname, fullname) VALUES ('osx', 'OSX');