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
105
106
107
108
109
110
111
112
113
114
|
INSERT INTO supported_languages VALUES (1,'English','English.class','English');
INSERT INTO supported_languages VALUES (2,'Japanese','Japanese.class','Japanese');
INSERT INTO supported_languages VALUES (3,'Hebrew','Hebrew.class','Hebrew');
INSERT INTO supported_languages VALUES (4,'Spanish','Spanish.class','Spanish');
INSERT INTO supported_languages VALUES (5,'Thai','Thai.class','Thai');
INSERT INTO supported_languages VALUES (6,'German','German.class','German');
INSERT INTO supported_languages VALUES (7,'French','French.class','French');
INSERT INTO supported_languages VALUES (8,'Italian','Italian.class','Italian');
INSERT INTO supported_languages VALUES (9,'Norwegian','Norwegian.class','Norwegian');
INSERT INTO supported_languages VALUES (10,'Swedish','Swedish.class','Swedish');
INSERT INTO supported_languages VALUES (11,'Chinese','Chinese.class','Chinese');
INSERT INTO supported_languages VALUES (12,'Dutch','Dutch.class','Dutch');
INSERT INTO supported_languages VALUES (13,'Esperanto','Esperanto.class','Esperanto');
INSERT INTO supported_languages VALUES (14,'Catalan','Catalan.class','Catalan');
INSERT INTO bug_resolution (resolution_id, resolution_name) VALUES (1,'Fixed');
INSERT INTO bug_resolution (resolution_id, resolution_name) VALUES (2,'Invalid');
INSERT INTO bug_resolution (resolution_id, resolution_name) VALUES (3,'Wont Fix');
INSERT INTO bug_resolution (resolution_id, resolution_name) VALUES (4,'Later');
INSERT INTO bug_resolution (resolution_id, resolution_name) VALUES (5,'Remind');
INSERT INTO bug_resolution (resolution_id, resolution_name) VALUES (6,'Works For Me');
INSERT INTO bug_resolution (resolution_id, resolution_name) VALUES (100,'None');
INSERT INTO bug_resolution (resolution_id, resolution_name) VALUES (101,'Duplicate');
INSERT INTO bug_status (status_id, status_name) VALUES (1,'Open');
INSERT INTO bug_status (status_id, status_name) VALUES (3,'Closed');
INSERT INTO bug_status (status_id, status_name) VALUES (100,'None');
INSERT INTO patch_status (patch_status_id, status_name) VALUES (1,'Open');
INSERT INTO patch_status (patch_status_id, status_name) VALUES (2,'Closed');
INSERT INTO patch_status (patch_status_id, status_name) VALUES (3,'Deleted');
INSERT INTO patch_status (patch_status_id, status_name) VALUES (4,'Postponed');
INSERT INTO patch_status (patch_status_id, status_name) VALUES (100,'None');
INSERT INTO project_status (status_id, status_name) VALUES (1,'Open');
INSERT INTO project_status (status_id, status_name) VALUES (2,'Closed');
INSERT INTO project_status (status_id, status_name) VALUES (100,'None');
INSERT INTO project_status (status_id, status_name) VALUES (3,'Deleted');
INSERT INTO survey_question_types (id, type) VALUES (1,'Radio Buttons 1-5');
INSERT INTO survey_question_types (id, type) VALUES (2,'Text Area');
INSERT INTO survey_question_types (id, type) VALUES (3,'Radio Buttons Yes/No');
INSERT INTO survey_question_types (id, type) VALUES (4,'Comment Only');
INSERT INTO survey_question_types (id, type) VALUES (5,'Text Field');
INSERT INTO survey_question_types (id, type) VALUES (100,'None');
INSERT INTO support_status values('1','Open');
INSERT INTO support_status values('2','Closed');
INSERT INTO support_status values('3','Deleted');
INSERT INTO people_skill_year VALUES ('0','< 6 Months');
INSERT INTO people_skill_year VALUES ('1','6 Mo - 2 yr');
INSERT INTO people_skill_year VALUES ('2','2 yr - 5 yr');
INSERT INTO people_skill_year VALUES ('3','5 yr - 10 yr');
INSERT INTO people_skill_year VALUES ('4','> 10 years');
INSERT INTO people_skill_level VALUES ('0','Want to Learn');
INSERT INTO people_skill_level VALUES ('1','Competent');
INSERT INTO people_skill_level VALUES ('2','Wizard');
INSERT INTO people_skill_level VALUES ('3','Wrote The Book');
INSERT INTO people_skill_level VALUES ('4','Wrote It');
INSERT INTO people_job_category VALUES ('0','Developer');
INSERT INTO people_job_category VALUES ('1','Project Manager');
INSERT INTO people_job_category VALUES ('2','Unix Admin');
INSERT INTO people_job_category VALUES ('3','Doc Writer');
INSERT INTO people_job_category VALUES ('4','Tester');
INSERT INTO people_job_category VALUES ('5','Support Manager');
INSERT INTO people_job_category VALUES ('6','Graphic/Other Designer');
INSERT INTO people_job_status VALUES ('1','Open');
INSERT INTO people_job_status VALUES ('2','Filled');
INSERT INTO people_job_status VALUES ('3','Deleted');
INSERT INTO group_type VALUES ('1','Project');
INSERT INTO group_type VALUES ('2','Foundry');
INSERT INTO frs_filetype VALUES ('1000','.deb');
INSERT INTO frs_filetype VALUES ('2000','.rpm');
INSERT INTO frs_filetype VALUES ('3000','.zip');
INSERT INTO frs_filetype VALUES ('4000','.bz2');
INSERT INTO frs_filetype VALUES ('4500','.gz');
INSERT INTO frs_filetype VALUES ('5000','Source .zip');
INSERT INTO frs_filetype VALUES ('5010','Source .bz2');
INSERT INTO frs_filetype VALUES ('5020','Source .gz');
INSERT INTO frs_filetype VALUES ('5100','Source .rpm');
INSERT INTO frs_filetype VALUES ('5900','Other Source File');
INSERT INTO frs_filetype VALUES ('8000','.jpg');
INSERT INTO frs_filetype VALUES ('9000','text');
INSERT INTO frs_filetype VALUES ('9100','html');
INSERT INTO frs_filetype VALUES ('9200','pdf');
INSERT INTO frs_filetype VALUES ('9999','Other');
INSERT INTO frs_status VALUES ('1','Active');
INSERT INTO frs_status VALUES ('3','Hidden');
INSERT INTO frs_processor VALUES ('1000','i386');
INSERT INTO frs_processor VALUES ('6000','IA64');
INSERT INTO frs_processor VALUES ('7000','Alpha');
INSERT INTO frs_processor VALUES ('8000','Any');
INSERT INTO frs_processor VALUES ('2000','PPC');
INSERT INTO frs_processor VALUES ('3000','MIPS');
INSERT INTO frs_processor VALUES ('4000','Sparc');
INSERT INTO frs_processor VALUES ('5000','UltraSparc');
INSERT INTO frs_processor VALUES ('9999','Other');
INSERT INTO themes VALUES (1, 'forged', 'Forged Metal');
INSERT INTO themes VALUES (2, 'classic', 'Classic Sourceforge');
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');
|
