2 -- SourceForge: Breaking Down the Barriers to Open Source Development
3 -- Copyright 1999-2000 (c) The SourceForge Crew
4 -- http://sourceforge.net
6 -- The values in this file must be inserted in order
7 -- and must be complete or you will have referential integrity problems
11 -- Default Data for 'groups'
13 INSERT INTO groups (group_id) VALUES (1);
15 INSERT INTO supported_languages VALUES (1,'English','English.class','English');
16 INSERT INTO supported_languages VALUES (2,'Japanese','Japanese.class','Japanese');
17 INSERT INTO supported_languages VALUES (3,'Hebrew','Hebrew.class','Hebrew');
18 INSERT INTO supported_languages VALUES (4,'Spanish','Spanish.class','Spanish');
19 INSERT INTO supported_languages VALUES (5,'Thai','Thai.class','Thai');
20 INSERT INTO supported_languages VALUES (6,'German','German.class','German');
21 INSERT INTO supported_languages VALUES (7,'French','French.class','French');
22 INSERT INTO supported_languages VALUES (8,'Italian','Italian.class','Italian');
23 INSERT INTO supported_languages VALUES (9,'Norwegian','Norwegian.class','Norwegian');
24 INSERT INTO supported_languages VALUES (10,'Swedish','Swedish.class','Swedish');
25 INSERT INTO supported_languages VALUES (11,'Chinese','Chinese.class','Chinese');
26 INSERT INTO supported_languages VALUES (12,'Dutch','Dutch.class','Dutch');
27 INSERT INTO supported_languages VALUES (13,'Esperanto','Esperanto.class','Esperanto');
28 INSERT INTO supported_languages VALUES (14,'Catalan','Catalan.class','Catalan');
31 -- Default Data for 'users'
33 INSERT INTO users (user_id, user_name, email, user_pw)
34 VALUES (100,'None','noreply@sourceforge.net','*********34343');
37 -- Default data for table 'bug_resolution'
39 INSERT INTO bug_resolution (resolution_id, resolution_name) VALUES (1,'Fixed');
40 INSERT INTO bug_resolution (resolution_id, resolution_name) VALUES (2,'Invalid');
41 INSERT INTO bug_resolution (resolution_id, resolution_name) VALUES (3,'Wont Fix');
42 INSERT INTO bug_resolution (resolution_id, resolution_name) VALUES (4,'Later');
43 INSERT INTO bug_resolution (resolution_id, resolution_name) VALUES (5,'Remind');
44 INSERT INTO bug_resolution (resolution_id, resolution_name) VALUES (6,'Works For Me');
45 INSERT INTO bug_resolution (resolution_id, resolution_name) VALUES (100,'None');
46 INSERT INTO bug_resolution (resolution_id, resolution_name) VALUES (101,'Duplicate');
49 -- Default data for table 'bug_status'
51 INSERT INTO bug_status (status_id, status_name) VALUES (1,'Open');
52 INSERT INTO bug_status (status_id, status_name) VALUES (3,'Closed');
53 INSERT INTO bug_status (status_id, status_name) VALUES (100,'None');
56 -- Default data for bug_category
58 INSERT INTO bug_category (bug_category_id, group_id, category_name) VALUES (100,1,'None');
61 -- Default data for bug_group
63 INSERT INTO bug_group (bug_group_id, group_id, group_name) VALUES (100,1,'None');
66 -- Default data for bug - required for dependent tasks/bugs
68 INSERT INTO bug (bug_id,group_id,status_id,category_id,bug_group_id,submitted_by,assigned_to,resolution_id)
69 VALUES (100,1,100,100,100,100,100,100);
70 --NOTE - if using sequences, you may have to update the bug_id sequence here
73 -- Default data for table 'patch_category'
75 INSERT INTO patch_category (patch_category_id, group_id, category_name) VALUES (100,1,'None');
78 -- Default data for table 'patch_status'
80 INSERT INTO patch_status (patch_status_id, status_name) VALUES (1,'Open');
81 INSERT INTO patch_status (patch_status_id, status_name) VALUES (2,'Closed');
82 INSERT INTO patch_status (patch_status_id, status_name) VALUES (3,'Deleted');
83 INSERT INTO patch_status (patch_status_id, status_name) VALUES (4,'Postponed');
84 INSERT INTO patch_status (patch_status_id, status_name) VALUES (100,'None');
87 -- Default values for patch
89 INSERT INTO patch (group_id,patch_status_id,patch_category_id,submitted_by,assigned_to)
90 VALUES (1,100,100,100,100);
93 -- Default data for table 'project_status'
95 INSERT INTO project_status (status_id, status_name) VALUES (1,'Open');
96 INSERT INTO project_status (status_id, status_name) VALUES (2,'Closed');
97 INSERT INTO project_status (status_id, status_name) VALUES (100,'None');
98 INSERT INTO project_status (status_id, status_name) VALUES (3,'Deleted');
101 -- Default data for project_group_list
103 INSERT INTO project_group_list (group_project_id,group_id) VALUES (1,1);
104 --NOTE - if using sequences, you may have to update the group_project_id sequence here
107 -- Default data for project_task
109 INSERT INTO project_task (group_project_id,created_by,status_id)
113 -- Default Data for 'survey_question_types'
115 INSERT INTO survey_question_types (id, type) VALUES (1,'Radio Buttons 1-5');
116 INSERT INTO survey_question_types (id, type) VALUES (2,'Text Area');
117 INSERT INTO survey_question_types (id, type) VALUES (3,'Radio Buttons Yes/No');
118 INSERT INTO survey_question_types (id, type) VALUES (4,'Comment Only');
119 INSERT INTO survey_question_types (id, type) VALUES (5,'Text Field');
120 INSERT INTO survey_question_types (id, type) VALUES (100,'None');
123 -- Default data for Support System
125 insert into support_status values('1','Open');
126 insert into support_status values('2','Closed');
127 insert into support_status values('3','Deleted');
130 -- Default data for 'support_category'
132 insert into support_category VALUES ('100','1','None');
135 -- Default data for Help Wanted System
137 INSERT INTO people_skill_year VALUES ('1','< 6 Months');
138 INSERT INTO people_skill_year VALUES ('2','6 Mo - 2 yr');
139 INSERT INTO people_skill_year VALUES ('3','2 yr - 5 yr');
140 INSERT INTO people_skill_year VALUES ('4','5 yr - 10 yr');
141 INSERT INTO people_skill_year VALUES ('5','> 10 years');
143 INSERT INTO people_skill_level VALUES ('1','Want to Learn');
144 INSERT INTO people_skill_level VALUES ('2','Competent');
145 INSERT INTO people_skill_level VALUES ('3','Wizard');
146 INSERT INTO people_skill_level VALUES ('4','Wrote The Book');
147 INSERT INTO people_skill_level VALUES ('5','Wrote It');
149 INSERT INTO people_job_category VALUES ('1','Developer');
150 INSERT INTO people_job_category VALUES ('2','Project Manager');
151 INSERT INTO people_job_category VALUES ('3','Unix Admin');
152 INSERT INTO people_job_category VALUES ('4','Doc Writer');
153 INSERT INTO people_job_category VALUES ('5','Tester');
154 INSERT INTO people_job_category VALUES ('6','Support Manager');
155 INSERT INTO people_job_category VALUES ('7','Graphic/Other Designer');
157 INSERT INTO people_job_status VALUES ('1','Open');
158 INSERT INTO people_job_status VALUES ('2','Filled');
159 INSERT INTO people_job_status VALUES ('3','Deleted');
162 -- Default data for group_type
164 INSERT INTO group_type VALUES ('1','Project');
165 INSERT INTO group_type VALUES ('2','Foundry');
168 -- Default data for new filerelease system
170 INSERT INTO frs_filetype VALUES ('1000','.deb');
171 INSERT INTO frs_filetype VALUES ('2000','.rpm');
172 INSERT INTO frs_filetype VALUES ('3000','.zip');
173 INSERT INTO frs_filetype VALUES ('3001','.bz2');
174 INSERT INTO frs_filetype VALUES ('3002','.gz');
175 INSERT INTO frs_filetype VALUES ('5000','Source .zip');
176 INSERT INTO frs_filetype VALUES ('5001','Source .bz2');
177 INSERT INTO frs_filetype VALUES ('5002','Source .gz');
178 INSERT INTO frs_filetype VALUES ('5100','Source .rpm');
179 INSERT INTO frs_filetype VALUES ('5900','Other Source File');
180 INSERT INTO frs_filetype VALUES ('8000','.jpg');
181 INSERT INTO frs_filetype VALUES ('8001','text');
182 INSERT INTO frs_filetype VALUES ('8002','html');
183 INSERT INTO frs_filetype VALUES ('8003','pdf');
184 INSERT INTO frs_filetype VALUES ('9999','Other');
186 INSERT INTO frs_status VALUES ('1','Active');
187 INSERT INTO frs_status VALUES ('3','Hidden');
189 INSERT INTO frs_processor VALUES ('1000','i386');
190 INSERT INTO frs_processor VALUES ('6000','IA64');
191 INSERT INTO frs_processor VALUES ('7000','Alpha');
192 INSERT INTO frs_processor VALUES ('8000','Any');
193 INSERT INTO frs_processor VALUES ('2000','PPC');
194 INSERT INTO frs_processor VALUES ('3000','MIPS');
195 INSERT INTO frs_processor VALUES ('4000','Sparc');
196 INSERT INTO frs_processor VALUES ('5000','UltraSparc');
197 INSERT INTO frs_processor VALUES ('9999','Other');