1 insert into artifact_resolution values ('100','None');
2 select setval('artifact_resolution_id_seq',101);
3 select setval('users_pk_seq',101);
5 INSERT INTO doc_states VALUES (1,'active');
6 INSERT INTO doc_states VALUES (2,'deleted');
7 INSERT INTO doc_states VALUES (3,'pending');
8 INSERT INTO doc_states VALUES (4,'hidden');
9 INSERT INTO doc_states VALUES (5,'private');
11 drop table intel_agreement;
14 -- After 3pre5 release, sync with debian-sf database
16 DROP SEQUENCE group_cvs_history_pk_seq;
17 CREATE TABLE group_cvs_history (
19 group_id integer DEFAULT '0' NOT NULL,
20 user_name character varying(80) DEFAULT '' NOT NULL,
21 cvs_commits integer DEFAULT '0' NOT NULL,
22 cvs_commits_wk integer DEFAULT '0' NOT NULL,
23 cvs_adds integer DEFAULT '0' NOT NULL,
24 cvs_adds_wk integer DEFAULT '0' NOT NULL
27 UPDATE supported_languages SET language_code='en' where classname='English';
28 UPDATE supported_languages SET language_code='ja' where classname='Japanese';
29 UPDATE supported_languages SET language_code='iw' where classname='Hebrew';
30 UPDATE supported_languages SET language_code='es' where classname='Spanish';
31 UPDATE supported_languages SET language_code='th' where classname='Thai';
32 UPDATE supported_languages SET language_code='de' where classname='German';
33 UPDATE supported_languages SET language_code='it' where classname='Italian';
34 UPDATE supported_languages SET language_code='no' where classname='Norwegian';
35 UPDATE supported_languages SET language_code='sv' where classname='Swedish';
36 UPDATE supported_languages SET language_code='zh' where classname='Chinese';
37 UPDATE supported_languages SET language_code='nl' where classname='Dutch';
38 UPDATE supported_languages SET language_code='eo' where classname='Esperanto';
39 UPDATE supported_languages SET language_code='ca' where classname='Catalan';
40 UPDATE supported_languages SET language_code='ko' where classname='Korean';
41 UPDATE supported_languages SET language_code='bg' where classname='Bulgarian';
42 UPDATE supported_languages SET language_code='el' where classname='Greek';
43 UPDATE supported_languages SET language_code='id' where classname='Indonesian';
44 UPDATE supported_languages SET language_code='pt' where classname='Portuguese (Brazillian)';
45 UPDATE supported_languages SET language_code='pl' where classname='Polish';
46 UPDATE supported_languages SET language_code='pt' where classname='Portuguese';
47 UPDATE supported_languages SET language_code='ru' where classname='Russian';
48 UPDATE supported_languages SET language_code='fr' where classname='French';
50 ALTER TABLE trove_group_link ADD CONSTRAINT tgl_group_id_fk
51 FOREIGN KEY (group_id) REFERENCES groups(group_id) MATCH FULL;
52 ALTER TABLE trove_group_link ADD CONSTRAINT tgl_cat_id_fk
53 FOREIGN KEY (trove_cat_id) REFERENCES trove_cat(trove_cat_id) MATCH FULL;
54 ALTER TABLE trove_agg ADD CONSTRAINT trove_agg_cat_id_fk
55 FOREIGN KEY (trove_cat_id) REFERENCES trove_cat(trove_cat_id) MATCH FULL;
56 ALTER TABLE trove_agg ADD CONSTRAINT trove_agg_group_id_fk
57 FOREIGN KEY (group_id) REFERENCES groups(group_id) MATCH FULL;
58 ALTER TABLE trove_treesums ADD CONSTRAINT trove_treesums_cat_id_fk
59 FOREIGN KEY (trove_cat_id) REFERENCES trove_cat(trove_cat_id) MATCH FULL;
61 ALTER TABLE groups ADD COLUMN use_ftp integer;
62 ALTER TABLE groups ALTER COLUMN use_ftp SET DEFAULT 1;
63 UPDATE groups SET use_ftp = 1;
64 ALTER TABLE groups ADD COLUMN use_tracker integer;
65 ALTER TABLE groups ALTER COLUMN use_tracker SET DEFAULT 1;
66 UPDATE groups SET use_tracker = 1;
67 ALTER TABLE groups ADD COLUMN use_frs integer;
68 ALTER TABLE groups ALTER COLUMN use_frs SET DEFAULT 1;
69 UPDATE groups SET use_frs = 1;
70 ALTER TABLE groups ADD COLUMN use_stats integer;
71 ALTER TABLE groups ALTER COLUMN use_stats SET DEFAULT 1;
72 UPDATE groups SET use_stats = 1;
73 ALTER TABLE groups ADD COLUMN enable_pserver integer;
74 ALTER TABLE groups ALTER COLUMN enable_pserver SET DEFAULT 1;
75 UPDATE groups SET enable_pserver = 1;
76 ALTER TABLE groups ADD COLUMN enable_anoncvs integer;
77 ALTER TABLE groups ALTER COLUMN enable_anoncvs SET DEFAULT 1;
78 UPDATE groups SET enable_anoncvs = 1;
80 ALTER TABLE supported_languages RENAME TO supported_languages_old;
81 DROP SEQUENCE supported_languages_pk_seq;
82 CREATE TABLE supported_languages (
87 language_code character(5));
88 INSERT INTO supported_languages SELECT * FROM supported_languages_old;
89 SELECT SETVAL('supported_languages_language_id_seq',(select max(language_id) FROM supported_languages));
90 DROP TABLE supported_languages_old;
91 ALTER TABLE supported_languages ADD CONSTRAINT supported_languages_pkey PRIMARY KEY (language_id);
92 ALTER TABLE users ADD CONSTRAINT users_languageid_fk
93 FOREIGN KEY (language) REFERENCES supported_languages(language_id) MATCH FULL;
94 ALTER TABLE doc_data ADD CONSTRAINT docdata_languageid_fk
95 FOREIGN KEY (language_id) REFERENCES supported_languages(language_id) MATCH FULL;
96 UPDATE supported_languages SET language_code='pt_BR',
97 classname='PortugueseBrazilian', name='Pt. Brazilian',
98 filename='PortugueseBrazilian.class'
99 where classname='PortugueseBrazillian';
101 INSERT INTO artifact_resolution VALUES (102,'Accepted');
102 INSERT INTO artifact_resolution VALUES (103,'Out of Date');
103 INSERT INTO artifact_resolution VALUES (104,'Postponed');
104 INSERT INTO artifact_resolution VALUES (105,'Rejected');