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