1 CREATE SEQUENCE "bug_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
3 "bug_id" integer DEFAULT nextval('bug_pk_seq'::text) NOT NULL,
4 "group_id" integer DEFAULT '0' NOT NULL,
5 "status_id" integer DEFAULT '0' NOT NULL,
6 "priority" integer DEFAULT '0' NOT NULL,
7 "category_id" integer DEFAULT '0' NOT NULL,
8 "submitted_by" integer DEFAULT '0' NOT NULL,
9 "assigned_to" integer DEFAULT '0' NOT NULL,
10 "date" integer DEFAULT '0' NOT NULL,
14 "bug_group_id" integer DEFAULT '0' NOT NULL,
15 "resolution_id" integer DEFAULT '0' NOT NULL,
16 PRIMARY KEY ("bug_id")
18 CREATE SEQUENCE "bug_bug_dependencies_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
19 CREATE TABLE "bug_bug_dependencies" (
20 "bug_depend_id" integer DEFAULT nextval('bug_bug_dependencies_pk_seq'::text) NOT NULL,
21 "bug_id" integer DEFAULT '0' NOT NULL,
22 "is_dependent_on_bug_id" integer DEFAULT '0' NOT NULL,
23 PRIMARY KEY ("bug_depend_id")
25 CREATE SEQUENCE "bug_canned_responses_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
26 CREATE TABLE "bug_canned_responses" (
27 "bug_canned_id" integer DEFAULT nextval('bug_canned_responses_pk_seq'::text) NOT NULL,
28 "group_id" integer DEFAULT '0' NOT NULL,
31 PRIMARY KEY ("bug_canned_id")
33 CREATE SEQUENCE "bug_category_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
34 CREATE TABLE "bug_category" (
35 "bug_category_id" integer DEFAULT nextval('bug_category_pk_seq'::text) NOT NULL,
36 "group_id" integer DEFAULT '0' NOT NULL,
38 PRIMARY KEY ("bug_category_id")
40 CREATE SEQUENCE "bug_filter_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
41 CREATE TABLE "bug_filter" (
42 "filter_id" integer DEFAULT nextval('bug_filter_pk_seq'::text) NOT NULL,
43 "user_id" integer DEFAULT '0' NOT NULL,
44 "group_id" integer DEFAULT '0' NOT NULL,
45 "sql_clause" text DEFAULT '' NOT NULL,
46 "is_active" integer DEFAULT '0' NOT NULL,
47 PRIMARY KEY ("filter_id")
49 CREATE SEQUENCE "bug_group_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
50 CREATE TABLE "bug_group" (
51 "bug_group_id" integer DEFAULT nextval('bug_group_pk_seq'::text) NOT NULL,
52 "group_id" integer DEFAULT '0' NOT NULL,
53 "group_name" text DEFAULT '' NOT NULL,
54 PRIMARY KEY ("bug_group_id")
56 CREATE SEQUENCE "bug_history_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
57 CREATE TABLE "bug_history" (
58 "bug_history_id" integer DEFAULT nextval('bug_history_pk_seq'::text) NOT NULL,
59 "bug_id" integer DEFAULT '0' NOT NULL,
60 "field_name" text DEFAULT '' NOT NULL,
61 "old_value" text DEFAULT '' NOT NULL,
62 "mod_by" integer DEFAULT '0' NOT NULL,
64 PRIMARY KEY ("bug_history_id")
66 CREATE SEQUENCE "bug_resolution_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
67 CREATE TABLE "bug_resolution" (
68 "resolution_id" integer DEFAULT nextval('bug_resolution_pk_seq'::text) NOT NULL,
69 "resolution_name" text DEFAULT '' NOT NULL,
70 PRIMARY KEY ("resolution_id")
72 CREATE SEQUENCE "bug_status_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
73 CREATE TABLE "bug_status" (
74 "status_id" integer DEFAULT nextval('bug_status_pk_seq'::text) NOT NULL,
76 PRIMARY KEY ("status_id")
78 CREATE SEQUENCE "bug_task_dependencies_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
79 CREATE TABLE "bug_task_dependencies" (
80 "bug_depend_id" integer DEFAULT nextval('bug_task_dependencies_pk_seq'::text) NOT NULL,
81 "bug_id" integer DEFAULT '0' NOT NULL,
82 "is_dependent_on_task_id" integer DEFAULT '0' NOT NULL,
83 PRIMARY KEY ("bug_depend_id")
85 CREATE SEQUENCE "canned_responses_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
86 CREATE TABLE "canned_responses" (
87 "response_id" integer DEFAULT nextval('canned_responses_pk_seq'::text) NOT NULL,
88 "response_title" character varying(25),
90 PRIMARY KEY ("response_id")
92 CREATE SEQUENCE "db_images_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
93 CREATE TABLE "db_images" (
94 "id" integer DEFAULT nextval('db_images_pk_seq'::text) NOT NULL,
95 "group_id" integer DEFAULT '0' NOT NULL,
96 "description" text DEFAULT '' NOT NULL,
97 "bin_data" text DEFAULT '' NOT NULL,
98 "filename" text DEFAULT '' NOT NULL,
99 "filesize" integer DEFAULT '0' NOT NULL,
100 "filetype" text DEFAULT '' NOT NULL,
101 "width" integer DEFAULT '0' NOT NULL,
102 "height" integer DEFAULT '0' NOT NULL,
105 CREATE SEQUENCE "doc_data_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
106 CREATE TABLE "doc_data" (
107 "docid" integer DEFAULT nextval('doc_data_pk_seq'::text) NOT NULL,
108 "stateid" integer DEFAULT '0' NOT NULL,
109 "title" character varying(255) DEFAULT '' NOT NULL,
110 "data" text DEFAULT '' NOT NULL,
111 "updatedate" integer DEFAULT '0' NOT NULL,
112 "createdate" integer DEFAULT '0' NOT NULL,
113 "created_by" integer DEFAULT '0' NOT NULL,
114 "doc_group" integer DEFAULT '0' NOT NULL,
116 "language_id" integer DEFAULT '1' NOT NULL,
117 PRIMARY KEY ("docid")
119 CREATE SEQUENCE "doc_groups_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
120 CREATE TABLE "doc_groups" (
121 "doc_group" integer DEFAULT nextval('doc_groups_pk_seq'::text) NOT NULL,
122 "groupname" character varying(255) DEFAULT '' NOT NULL,
123 "group_id" integer DEFAULT '0' NOT NULL,
124 PRIMARY KEY ("doc_group")
126 CREATE SEQUENCE "doc_states_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
127 CREATE TABLE "doc_states" (
128 "stateid" integer DEFAULT nextval('doc_states_pk_seq'::text) NOT NULL,
129 "name" character varying(255) DEFAULT '' NOT NULL,
130 PRIMARY KEY ("stateid")
132 CREATE SEQUENCE "filemodule_monitor_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
133 CREATE TABLE "filemodule_monitor" (
134 "id" integer DEFAULT nextval('filemodule_monitor_pk_seq'::text) NOT NULL,
135 "filemodule_id" integer DEFAULT '0' NOT NULL,
136 "user_id" integer DEFAULT '0' NOT NULL,
139 CREATE SEQUENCE "forum_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
140 CREATE TABLE "forum" (
141 "msg_id" integer DEFAULT nextval('forum_pk_seq'::text) NOT NULL,
142 "group_forum_id" integer DEFAULT '0' NOT NULL,
143 "posted_by" integer DEFAULT '0' NOT NULL,
144 "subject" text DEFAULT '' NOT NULL,
145 "body" text DEFAULT '' NOT NULL,
146 "date" integer DEFAULT '0' NOT NULL,
147 "is_followup_to" integer DEFAULT '0' NOT NULL,
148 "thread_id" integer DEFAULT '0' NOT NULL,
149 "has_followups" integer DEFAULT '0',
150 "most_recent_date" integer DEFAULT '0' NOT NULL,
151 PRIMARY KEY ("msg_id")
153 CREATE TABLE "forum_agg_msg_count" (
154 "group_forum_id" integer DEFAULT '0' NOT NULL,
155 "count" integer DEFAULT '0' NOT NULL,
156 PRIMARY KEY ("group_forum_id")
158 CREATE SEQUENCE "forum_group_list_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
159 CREATE TABLE "forum_group_list" (
160 "group_forum_id" integer DEFAULT nextval('forum_group_list_pk_seq'::text) NOT NULL,
161 "group_id" integer DEFAULT '0' NOT NULL,
162 "forum_name" text DEFAULT '' NOT NULL,
163 "is_public" integer DEFAULT '0' NOT NULL,
165 "allow_anonymous" integer DEFAULT '0' NOT NULL,
166 "send_all_posts_to" text,
167 PRIMARY KEY ("group_forum_id")
169 CREATE SEQUENCE "forum_monitored_forums_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
170 CREATE TABLE "forum_monitored_forums" (
171 "monitor_id" integer DEFAULT nextval('forum_monitored_forums_pk_seq'::text) NOT NULL,
172 "forum_id" integer DEFAULT '0' NOT NULL,
173 "user_id" integer DEFAULT '0' NOT NULL,
174 PRIMARY KEY ("monitor_id")
176 CREATE SEQUENCE "forum_saved_place_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
177 CREATE TABLE "forum_saved_place" (
178 "saved_place_id" integer DEFAULT nextval('forum_saved_place_pk_seq'::text) NOT NULL,
179 "user_id" integer DEFAULT '0' NOT NULL,
180 "forum_id" integer DEFAULT '0' NOT NULL,
181 "save_date" integer DEFAULT '0' NOT NULL,
182 PRIMARY KEY ("saved_place_id")
184 CREATE TABLE "foundry_data" (
185 "foundry_id" integer DEFAULT '0' NOT NULL,
186 "freeform1_html" text,
187 "freeform2_html" text,
188 "sponsor1_html" text,
189 "sponsor2_html" text,
190 "guide_image_id" integer DEFAULT '0' NOT NULL,
191 "logo_image_id" integer DEFAULT '0' NOT NULL,
192 "trove_categories" text,
193 PRIMARY KEY ("foundry_id")
195 CREATE SEQUENCE "foundry_news_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
196 CREATE TABLE "foundry_news" (
197 "foundry_news_id" integer DEFAULT nextval('foundry_news_pk_seq'::text) NOT NULL,
198 "foundry_id" integer DEFAULT '0' NOT NULL,
199 "news_id" integer DEFAULT '0' NOT NULL,
200 "approve_date" integer DEFAULT '0' NOT NULL,
201 "is_approved" integer DEFAULT '0' NOT NULL,
202 PRIMARY KEY ("foundry_news_id")
204 CREATE SEQUENCE "foundry_preferred_projec_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
205 CREATE TABLE "foundry_preferred_projects" (
206 "foundry_project_id" integer DEFAULT nextval('foundry_preferred_projec_pk_seq'::text) NOT NULL,
207 "foundry_id" integer DEFAULT '0' NOT NULL,
208 "group_id" integer DEFAULT '0' NOT NULL,
209 "rank" integer DEFAULT '0' NOT NULL,
210 PRIMARY KEY ("foundry_project_id")
212 CREATE SEQUENCE "foundry_projects_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
213 CREATE TABLE "foundry_projects" (
214 "id" integer DEFAULT nextval('foundry_projects_pk_seq'::text) NOT NULL,
215 "foundry_id" integer DEFAULT '0' NOT NULL,
216 "project_id" integer DEFAULT '0' NOT NULL,
219 CREATE TABLE "frs_dlstats_agg" (
220 "file_id" integer DEFAULT '0' NOT NULL,
221 "day" integer DEFAULT '0' NOT NULL,
222 "downloads_http" integer DEFAULT '0' NOT NULL,
223 "downloads_ftp" integer DEFAULT '0' NOT NULL
225 CREATE TABLE "frs_dlstats_file_agg" (
226 "file_id" integer DEFAULT '0' NOT NULL,
227 "day" integer DEFAULT '0' NOT NULL,
228 "downloads" integer DEFAULT '0' NOT NULL
230 CREATE TABLE "frs_dlstats_filetotal_agg" (
231 "file_id" integer DEFAULT '0' NOT NULL,
232 "downloads" integer DEFAULT '0' NOT NULL,
233 PRIMARY KEY ("file_id")
235 CREATE TABLE "frs_dlstats_filetotal_agg_old" (
236 "file_id" integer DEFAULT '0' NOT NULL,
237 "downloads" integer DEFAULT '0' NOT NULL
239 CREATE TABLE "frs_dlstats_group_agg" (
240 "group_id" integer DEFAULT '0' NOT NULL,
241 "day" integer DEFAULT '0' NOT NULL,
242 "downloads" integer DEFAULT '0' NOT NULL
244 CREATE TABLE "frs_dlstats_grouptotal_agg" (
245 "group_id" integer DEFAULT '0' NOT NULL,
246 "downloads" integer DEFAULT '0' NOT NULL
248 CREATE SEQUENCE "frs_file_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
249 CREATE TABLE "frs_file" (
250 "file_id" integer DEFAULT nextval('frs_file_pk_seq'::text) NOT NULL,
252 "release_id" integer DEFAULT '0' NOT NULL,
253 "type_id" integer DEFAULT '0' NOT NULL,
254 "processor_id" integer DEFAULT '0' NOT NULL,
255 "release_time" integer DEFAULT '0' NOT NULL,
256 "file_size" integer DEFAULT '0' NOT NULL,
257 "post_date" integer DEFAULT '0' NOT NULL,
258 PRIMARY KEY ("file_id")
260 CREATE SEQUENCE "frs_filetype_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
261 CREATE TABLE "frs_filetype" (
262 "type_id" integer DEFAULT nextval('frs_filetype_pk_seq'::text) NOT NULL,
264 PRIMARY KEY ("type_id")
266 CREATE SEQUENCE "frs_package_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
267 CREATE TABLE "frs_package" (
268 "package_id" integer DEFAULT nextval('frs_package_pk_seq'::text) NOT NULL,
269 "group_id" integer DEFAULT '0' NOT NULL,
271 "status_id" integer DEFAULT '0' NOT NULL,
272 PRIMARY KEY ("package_id")
274 CREATE SEQUENCE "frs_processor_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
275 CREATE TABLE "frs_processor" (
276 "processor_id" integer DEFAULT nextval('frs_processor_pk_seq'::text) NOT NULL,
278 PRIMARY KEY ("processor_id")
280 CREATE SEQUENCE "frs_release_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
281 CREATE TABLE "frs_release" (
282 "release_id" integer DEFAULT nextval('frs_release_pk_seq'::text) NOT NULL,
283 "package_id" integer DEFAULT '0' NOT NULL,
287 "status_id" integer DEFAULT '0' NOT NULL,
288 "preformatted" integer DEFAULT '0' NOT NULL,
289 "release_date" integer DEFAULT '0' NOT NULL,
290 "released_by" integer DEFAULT '0' NOT NULL,
291 PRIMARY KEY ("release_id")
293 CREATE SEQUENCE "frs_status_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
294 CREATE TABLE "frs_status" (
295 "status_id" integer DEFAULT nextval('frs_status_pk_seq'::text) NOT NULL,
297 PRIMARY KEY ("status_id")
299 CREATE SEQUENCE "group_cvs_history_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
300 CREATE TABLE "group_cvs_history" (
301 "id" integer DEFAULT nextval('group_cvs_history_pk_seq'::text) NOT NULL,
302 "group_id" integer DEFAULT '0' NOT NULL,
303 "user_name" character varying(80) DEFAULT '' NOT NULL,
304 "cvs_commits" integer DEFAULT '0' NOT NULL,
305 "cvs_commits_wk" integer DEFAULT '0' NOT NULL,
306 "cvs_adds" integer DEFAULT '0' NOT NULL,
307 "cvs_adds_wk" integer DEFAULT '0' NOT NULL,
310 CREATE SEQUENCE "group_history_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
311 CREATE TABLE "group_history" (
312 "group_history_id" integer DEFAULT nextval('group_history_pk_seq'::text) NOT NULL,
313 "group_id" integer DEFAULT '0' NOT NULL,
314 "field_name" text DEFAULT '' NOT NULL,
315 "old_value" text DEFAULT '' NOT NULL,
316 "mod_by" integer DEFAULT '0' NOT NULL,
318 PRIMARY KEY ("group_history_id")
320 CREATE SEQUENCE "group_type_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
321 CREATE TABLE "group_type" (
322 "type_id" integer DEFAULT nextval('group_type_pk_seq'::text) NOT NULL,
324 PRIMARY KEY ("type_id")
326 CREATE SEQUENCE "groups_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
327 CREATE TABLE "groups" (
328 "group_id" integer DEFAULT nextval('groups_pk_seq'::text) NOT NULL,
329 "group_name" character varying(40),
330 "homepage" character varying(128),
331 "is_public" integer DEFAULT '0' NOT NULL,
332 "status" character(1) DEFAULT 'A' NOT NULL,
333 "unix_group_name" character varying(30) DEFAULT '' NOT NULL,
334 "unix_box" character varying(20) DEFAULT 'shell1' NOT NULL,
335 "http_domain" character varying(80),
336 "short_description" character varying(255),
337 "cvs_box" character varying(20) DEFAULT 'cvs1' NOT NULL,
338 "license" character varying(16),
339 "register_purpose" text,
340 "license_other" text,
341 "register_time" integer DEFAULT '0' NOT NULL,
342 "use_bugs" integer DEFAULT '1' NOT NULL,
344 "use_mail" integer DEFAULT '1' NOT NULL,
345 "use_survey" integer DEFAULT '1' NOT NULL,
346 "use_patch" integer DEFAULT '1' NOT NULL,
347 "use_forum" integer DEFAULT '1' NOT NULL,
348 "use_pm" integer DEFAULT '1' NOT NULL,
349 "use_cvs" integer DEFAULT '1' NOT NULL,
350 "use_news" integer DEFAULT '1' NOT NULL,
351 "use_support" integer DEFAULT '1' NOT NULL,
352 "new_bug_address" text DEFAULT '' NOT NULL,
353 "new_patch_address" text DEFAULT '' NOT NULL,
354 "new_support_address" text DEFAULT '' NOT NULL,
355 "type" integer DEFAULT '1' NOT NULL,
356 "use_docman" integer DEFAULT '1' NOT NULL,
357 "send_all_bugs" integer DEFAULT '0' NOT NULL,
358 "send_all_patches" integer DEFAULT '0' NOT NULL,
359 "send_all_support" integer DEFAULT '0' NOT NULL,
360 "new_task_address" text DEFAULT '' NOT NULL,
361 "send_all_tasks" integer DEFAULT '0' NOT NULL,
362 "use_bug_depend_box" integer DEFAULT '1' NOT NULL,
363 "use_pm_depend_box" integer DEFAULT '1' NOT NULL,
364 PRIMARY KEY ("group_id")
366 CREATE TABLE "intel_agreement" (
367 "user_id" integer DEFAULT '0' NOT NULL,
369 "is_approved" integer DEFAULT '0' NOT NULL,
370 PRIMARY KEY ("user_id")
372 CREATE SEQUENCE "mail_group_list_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
373 CREATE TABLE "mail_group_list" (
374 "group_list_id" integer DEFAULT nextval('mail_group_list_pk_seq'::text) NOT NULL,
375 "group_id" integer DEFAULT '0' NOT NULL,
377 "is_public" integer DEFAULT '0' NOT NULL,
378 "password" character varying(16),
379 "list_admin" integer DEFAULT '0' NOT NULL,
380 "status" integer DEFAULT '0' NOT NULL,
382 PRIMARY KEY ("group_list_id")
384 CREATE SEQUENCE "news_bytes_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
385 CREATE TABLE "news_bytes" (
386 "id" integer DEFAULT nextval('news_bytes_pk_seq'::text) NOT NULL,
387 "group_id" integer DEFAULT '0' NOT NULL,
388 "submitted_by" integer DEFAULT '0' NOT NULL,
389 "is_approved" integer DEFAULT '0' NOT NULL,
390 "date" integer DEFAULT '0' NOT NULL,
391 "forum_id" integer DEFAULT '0' NOT NULL,
396 CREATE SEQUENCE "patch_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
397 CREATE TABLE "patch" (
398 "patch_id" integer DEFAULT nextval('patch_pk_seq'::text) NOT NULL,
399 "group_id" integer DEFAULT '0' NOT NULL,
400 "patch_status_id" integer DEFAULT '0' NOT NULL,
401 "patch_category_id" integer DEFAULT '0' NOT NULL,
402 "submitted_by" integer DEFAULT '0' NOT NULL,
403 "assigned_to" integer DEFAULT '0' NOT NULL,
404 "open_date" integer DEFAULT '0' NOT NULL,
407 "close_date" integer DEFAULT '0' NOT NULL,
408 PRIMARY KEY ("patch_id")
410 CREATE SEQUENCE "patch_category_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
411 CREATE TABLE "patch_category" (
412 "patch_category_id" integer DEFAULT nextval('patch_category_pk_seq'::text) NOT NULL,
413 "group_id" integer DEFAULT '0' NOT NULL,
414 "category_name" text DEFAULT '' NOT NULL,
415 PRIMARY KEY ("patch_category_id")
417 CREATE SEQUENCE "patch_history_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
418 CREATE TABLE "patch_history" (
419 "patch_history_id" integer DEFAULT nextval('patch_history_pk_seq'::text) NOT NULL,
420 "patch_id" integer DEFAULT '0' NOT NULL,
421 "field_name" text DEFAULT '' NOT NULL,
422 "old_value" text DEFAULT '' NOT NULL,
423 "mod_by" integer DEFAULT '0' NOT NULL,
425 PRIMARY KEY ("patch_history_id")
427 CREATE SEQUENCE "patch_status_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
428 CREATE TABLE "patch_status" (
429 "patch_status_id" integer DEFAULT nextval('patch_status_pk_seq'::text) NOT NULL,
431 PRIMARY KEY ("patch_status_id")
433 CREATE SEQUENCE "people_job_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
434 CREATE TABLE "people_job" (
435 "job_id" integer DEFAULT nextval('people_job_pk_seq'::text) NOT NULL,
436 "group_id" integer DEFAULT '0' NOT NULL,
437 "created_by" integer DEFAULT '0' NOT NULL,
440 "date" integer DEFAULT '0' NOT NULL,
441 "status_id" integer DEFAULT '0' NOT NULL,
442 "category_id" integer DEFAULT '0' NOT NULL,
443 PRIMARY KEY ("job_id")
445 CREATE SEQUENCE "people_job_category_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
446 CREATE TABLE "people_job_category" (
447 "category_id" integer DEFAULT nextval('people_job_category_pk_seq'::text) NOT NULL,
449 "private_flag" integer DEFAULT '0' NOT NULL,
450 PRIMARY KEY ("category_id")
452 CREATE SEQUENCE "people_job_inventory_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
453 CREATE TABLE "people_job_inventory" (
454 "job_inventory_id" integer DEFAULT nextval('people_job_inventory_pk_seq'::text) NOT NULL,
455 "job_id" integer DEFAULT '0' NOT NULL,
456 "skill_id" integer DEFAULT '0' NOT NULL,
457 "skill_level_id" integer DEFAULT '0' NOT NULL,
458 "skill_year_id" integer DEFAULT '0' NOT NULL,
459 PRIMARY KEY ("job_inventory_id")
461 CREATE SEQUENCE "people_job_status_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
462 CREATE TABLE "people_job_status" (
463 "status_id" integer DEFAULT nextval('people_job_status_pk_seq'::text) NOT NULL,
465 PRIMARY KEY ("status_id")
467 CREATE SEQUENCE "people_skill_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
468 CREATE TABLE "people_skill" (
469 "skill_id" integer DEFAULT nextval('people_skill_pk_seq'::text) NOT NULL,
471 PRIMARY KEY ("skill_id")
473 CREATE SEQUENCE "people_skill_inventory_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
474 CREATE TABLE "people_skill_inventory" (
475 "skill_inventory_id" integer DEFAULT nextval('people_skill_inventory_pk_seq'::text) NOT NULL,
476 "user_id" integer DEFAULT '0' NOT NULL,
477 "skill_id" integer DEFAULT '0' NOT NULL,
478 "skill_level_id" integer DEFAULT '0' NOT NULL,
479 "skill_year_id" integer DEFAULT '0' NOT NULL,
480 PRIMARY KEY ("skill_inventory_id")
482 CREATE SEQUENCE "people_skill_level_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
483 CREATE TABLE "people_skill_level" (
484 "skill_level_id" integer DEFAULT nextval('people_skill_level_pk_seq'::text) NOT NULL,
486 PRIMARY KEY ("skill_level_id")
488 CREATE SEQUENCE "people_skill_year_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
489 CREATE TABLE "people_skill_year" (
490 "skill_year_id" integer DEFAULT nextval('people_skill_year_pk_seq'::text) NOT NULL,
492 PRIMARY KEY ("skill_year_id")
494 CREATE SEQUENCE "project_assigned_to_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
495 CREATE TABLE "project_assigned_to" (
496 "project_assigned_id" integer DEFAULT nextval('project_assigned_to_pk_seq'::text) NOT NULL,
497 "project_task_id" integer DEFAULT '0' NOT NULL,
498 "assigned_to_id" integer DEFAULT '0' NOT NULL,
499 PRIMARY KEY ("project_assigned_id")
501 CREATE TABLE "project_counts_tmp" (
504 "count" double precision
506 CREATE TABLE "project_counts_weekly_tmp" (
509 "count" double precision
511 CREATE SEQUENCE "project_dependencies_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
512 CREATE TABLE "project_dependencies" (
513 "project_depend_id" integer DEFAULT nextval('project_dependencies_pk_seq'::text) NOT NULL,
514 "project_task_id" integer DEFAULT '0' NOT NULL,
515 "is_dependent_on_task_id" integer DEFAULT '0' NOT NULL,
516 PRIMARY KEY ("project_depend_id")
518 CREATE SEQUENCE "project_group_list_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
519 CREATE TABLE "project_group_list" (
520 "group_project_id" integer DEFAULT nextval('project_group_list_pk_seq'::text) NOT NULL,
521 "group_id" integer DEFAULT '0' NOT NULL,
522 "project_name" text DEFAULT '' NOT NULL,
523 "is_public" integer DEFAULT '0' NOT NULL,
525 PRIMARY KEY ("group_project_id")
527 CREATE SEQUENCE "project_history_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
528 CREATE TABLE "project_history" (
529 "project_history_id" integer DEFAULT nextval('project_history_pk_seq'::text) NOT NULL,
530 "project_task_id" integer DEFAULT '0' NOT NULL,
531 "field_name" text DEFAULT '' NOT NULL,
532 "old_value" text DEFAULT '' NOT NULL,
533 "mod_by" integer DEFAULT '0' NOT NULL,
534 "date" integer DEFAULT '0' NOT NULL,
535 PRIMARY KEY ("project_history_id")
537 CREATE SEQUENCE "project_metric_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
538 CREATE TABLE "project_metric" (
539 "ranking" integer DEFAULT nextval('project_metric_pk_seq'::text) NOT NULL,
540 "percentile" double precision,
541 "group_id" integer DEFAULT '0' NOT NULL,
542 PRIMARY KEY ("ranking")
544 CREATE SEQUENCE "project_metric_tmp1_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
545 CREATE TABLE "project_metric_tmp1" (
546 "ranking" integer DEFAULT nextval('project_metric_tmp1_pk_seq'::text) NOT NULL,
547 "group_id" integer DEFAULT '0' NOT NULL,
548 "value" double precision,
549 PRIMARY KEY ("ranking")
551 CREATE SEQUENCE "project_metric_weekly_tm_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
552 CREATE TABLE "project_metric_weekly_tmp1" (
553 "ranking" integer DEFAULT nextval('project_metric_weekly_tm_pk_seq'::text) NOT NULL,
554 "group_id" integer DEFAULT '0' NOT NULL,
555 "value" double precision,
556 PRIMARY KEY ("ranking")
558 CREATE SEQUENCE "project_status_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
559 CREATE TABLE "project_status" (
560 "status_id" integer DEFAULT nextval('project_status_pk_seq'::text) NOT NULL,
561 "status_name" text DEFAULT '' NOT NULL,
562 PRIMARY KEY ("status_id")
564 CREATE SEQUENCE "project_task_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
565 CREATE TABLE "project_task" (
566 "project_task_id" integer DEFAULT nextval('project_task_pk_seq'::text) NOT NULL,
567 "group_project_id" integer DEFAULT '0' NOT NULL,
568 "summary" text DEFAULT '' NOT NULL,
569 "details" text DEFAULT '' NOT NULL,
570 "percent_complete" integer DEFAULT '0' NOT NULL,
571 "priority" integer DEFAULT '0' NOT NULL,
572 "hours" double precision DEFAULT '0.00' NOT NULL,
573 "start_date" integer DEFAULT '0' NOT NULL,
574 "end_date" integer DEFAULT '0' NOT NULL,
575 "created_by" integer DEFAULT '0' NOT NULL,
576 "status_id" integer DEFAULT '0' NOT NULL,
577 PRIMARY KEY ("project_task_id")
579 CREATE SEQUENCE "project_weekly_metric_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
580 CREATE TABLE "project_weekly_metric" (
581 "ranking" integer DEFAULT nextval('project_weekly_metric_pk_seq'::text) NOT NULL,
582 "percentile" double precision,
583 "group_id" integer DEFAULT '0' NOT NULL,
584 PRIMARY KEY ("ranking")
586 CREATE TABLE "session" (
587 "user_id" integer DEFAULT '0' NOT NULL,
588 "session_hash" character(32) DEFAULT '' NOT NULL,
589 "ip_addr" character(15) DEFAULT '' NOT NULL,
590 "time" integer DEFAULT '0' NOT NULL,
591 PRIMARY KEY ("session_hash")
593 CREATE SEQUENCE "snippet_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
594 CREATE TABLE "snippet" (
595 "snippet_id" integer DEFAULT nextval('snippet_pk_seq'::text) NOT NULL,
596 "created_by" integer DEFAULT '0' NOT NULL,
599 "type" integer DEFAULT '0' NOT NULL,
600 "language" integer DEFAULT '0' NOT NULL,
601 "license" text DEFAULT '' NOT NULL,
602 "category" integer DEFAULT '0' NOT NULL,
603 PRIMARY KEY ("snippet_id")
605 CREATE SEQUENCE "snippet_package_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
606 CREATE TABLE "snippet_package" (
607 "snippet_package_id" integer DEFAULT nextval('snippet_package_pk_seq'::text) NOT NULL,
608 "created_by" integer DEFAULT '0' NOT NULL,
611 "category" integer DEFAULT '0' NOT NULL,
612 "language" integer DEFAULT '0' NOT NULL,
613 PRIMARY KEY ("snippet_package_id")
615 CREATE SEQUENCE "snippet_package_item_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
616 CREATE TABLE "snippet_package_item" (
617 "snippet_package_item_id" integer DEFAULT nextval('snippet_package_item_pk_seq'::text) NOT NULL,
618 "snippet_package_version_id" integer DEFAULT '0' NOT NULL,
619 "snippet_version_id" integer DEFAULT '0' NOT NULL,
620 PRIMARY KEY ("snippet_package_item_id")
622 CREATE SEQUENCE "snippet_package_version_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
623 CREATE TABLE "snippet_package_version" (
624 "snippet_package_version_id" integer DEFAULT nextval('snippet_package_version_pk_seq'::text) NOT NULL,
625 "snippet_package_id" integer DEFAULT '0' NOT NULL,
628 "submitted_by" integer DEFAULT '0' NOT NULL,
629 "date" integer DEFAULT '0' NOT NULL,
630 PRIMARY KEY ("snippet_package_version_id")
632 CREATE SEQUENCE "snippet_version_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
633 CREATE TABLE "snippet_version" (
634 "snippet_version_id" integer DEFAULT nextval('snippet_version_pk_seq'::text) NOT NULL,
635 "snippet_id" integer DEFAULT '0' NOT NULL,
638 "submitted_by" integer DEFAULT '0' NOT NULL,
639 "date" integer DEFAULT '0' NOT NULL,
641 PRIMARY KEY ("snippet_version_id")
643 CREATE TABLE "stats_agg_logo_by_day" (
647 CREATE TABLE "stats_agg_logo_by_group" (
652 CREATE TABLE "stats_agg_pages_by_browser" (
653 "browser" character varying(8),
656 CREATE TABLE "stats_agg_pages_by_day" (
657 "day" integer DEFAULT '0' NOT NULL,
658 "count" integer DEFAULT '0' NOT NULL
660 CREATE TABLE "stats_agg_pages_by_day_old" (
664 CREATE TABLE "stats_agg_site_by_day" (
665 "day" integer DEFAULT '0' NOT NULL,
666 "count" integer DEFAULT '0' NOT NULL
668 CREATE TABLE "stats_agg_site_by_group" (
669 "day" integer DEFAULT '0' NOT NULL,
670 "group_id" integer DEFAULT '0' NOT NULL,
671 "count" integer DEFAULT '0' NOT NULL
673 CREATE TABLE "stats_agr_filerelease" (
674 "filerelease_id" integer DEFAULT '0' NOT NULL,
675 "group_id" integer DEFAULT '0' NOT NULL,
676 "downloads" integer DEFAULT '0' NOT NULL
678 CREATE TABLE "stats_agr_project" (
679 "group_id" integer DEFAULT '0' NOT NULL,
680 "group_ranking" integer DEFAULT '0' NOT NULL,
681 "group_metric" double precision DEFAULT '0.00000' NOT NULL,
682 "developers" integer DEFAULT '0' NOT NULL,
683 "file_releases" integer DEFAULT '0' NOT NULL,
684 "downloads" integer DEFAULT '0' NOT NULL,
685 "site_views" integer DEFAULT '0' NOT NULL,
686 "logo_views" integer DEFAULT '0' NOT NULL,
687 "msg_posted" integer DEFAULT '0' NOT NULL,
688 "msg_uniq_auth" integer DEFAULT '0' NOT NULL,
689 "bugs_opened" integer DEFAULT '0' NOT NULL,
690 "bugs_closed" integer DEFAULT '0' NOT NULL,
691 "support_opened" integer DEFAULT '0' NOT NULL,
692 "support_closed" integer DEFAULT '0' NOT NULL,
693 "patches_opened" integer DEFAULT '0' NOT NULL,
694 "patches_closed" integer DEFAULT '0' NOT NULL,
695 "tasks_opened" integer DEFAULT '0' NOT NULL,
696 "tasks_closed" integer DEFAULT '0' NOT NULL,
697 "help_requests" integer DEFAULT '0' NOT NULL,
698 "cvs_checkouts" integer DEFAULT '0' NOT NULL,
699 "cvs_commits" integer DEFAULT '0' NOT NULL,
700 "cvs_adds" integer DEFAULT '0' NOT NULL
702 CREATE TABLE "stats_ftp_downloads" (
703 "day" integer DEFAULT '0' NOT NULL,
704 "filerelease_id" integer DEFAULT '0' NOT NULL,
705 "group_id" integer DEFAULT '0' NOT NULL,
706 "downloads" integer DEFAULT '0' NOT NULL
708 CREATE TABLE "stats_http_downloads" (
709 "day" integer DEFAULT '0' NOT NULL,
710 "filerelease_id" integer DEFAULT '0' NOT NULL,
711 "group_id" integer DEFAULT '0' NOT NULL,
712 "downloads" integer DEFAULT '0' NOT NULL
714 CREATE TABLE "stats_project" (
715 "month" integer DEFAULT '0' NOT NULL,
716 "week" integer DEFAULT '0' NOT NULL,
717 "day" integer DEFAULT '0' NOT NULL,
718 "group_id" integer DEFAULT '0' NOT NULL,
719 "group_ranking" integer DEFAULT '0' NOT NULL,
720 "group_metric" double precision DEFAULT '0.00000' NOT NULL,
721 "developers" integer DEFAULT '0' NOT NULL,
722 "file_releases" integer DEFAULT '0' NOT NULL,
723 "downloads" integer DEFAULT '0' NOT NULL,
724 "site_views" integer DEFAULT '0' NOT NULL,
725 "subdomain_views" integer DEFAULT '0' NOT NULL,
726 "msg_posted" integer DEFAULT '0' NOT NULL,
727 "msg_uniq_auth" integer DEFAULT '0' NOT NULL,
728 "bugs_opened" integer DEFAULT '0' NOT NULL,
729 "bugs_closed" integer DEFAULT '0' NOT NULL,
730 "support_opened" integer DEFAULT '0' NOT NULL,
731 "support_closed" integer DEFAULT '0' NOT NULL,
732 "patches_opened" integer DEFAULT '0' NOT NULL,
733 "patches_closed" integer DEFAULT '0' NOT NULL,
734 "tasks_opened" integer DEFAULT '0' NOT NULL,
735 "tasks_closed" integer DEFAULT '0' NOT NULL,
736 "help_requests" integer DEFAULT '0' NOT NULL,
737 "cvs_checkouts" integer DEFAULT '0' NOT NULL,
738 "cvs_commits" integer DEFAULT '0' NOT NULL,
739 "cvs_adds" integer DEFAULT '0' NOT NULL
741 CREATE TABLE "stats_project_tmp" (
742 "month" integer DEFAULT '0' NOT NULL,
743 "week" integer DEFAULT '0' NOT NULL,
744 "day" integer DEFAULT '0' NOT NULL,
745 "group_id" integer DEFAULT '0' NOT NULL,
746 "group_ranking" integer DEFAULT '0' NOT NULL,
747 "group_metric" double precision DEFAULT '0.00000' NOT NULL,
748 "developers" integer DEFAULT '0' NOT NULL,
749 "file_releases" integer DEFAULT '0' NOT NULL,
750 "downloads" integer DEFAULT '0' NOT NULL,
751 "site_views" integer DEFAULT '0' NOT NULL,
752 "subdomain_views" integer DEFAULT '0' NOT NULL,
753 "msg_posted" integer DEFAULT '0' NOT NULL,
754 "msg_uniq_auth" integer DEFAULT '0' NOT NULL,
755 "bugs_opened" integer DEFAULT '0' NOT NULL,
756 "bugs_closed" integer DEFAULT '0' NOT NULL,
757 "support_opened" integer DEFAULT '0' NOT NULL,
758 "support_closed" integer DEFAULT '0' NOT NULL,
759 "patches_opened" integer DEFAULT '0' NOT NULL,
760 "patches_closed" integer DEFAULT '0' NOT NULL,
761 "tasks_opened" integer DEFAULT '0' NOT NULL,
762 "tasks_closed" integer DEFAULT '0' NOT NULL,
763 "help_requests" integer DEFAULT '0' NOT NULL,
764 "cvs_checkouts" integer DEFAULT '0' NOT NULL,
765 "cvs_commits" integer DEFAULT '0' NOT NULL,
766 "cvs_adds" integer DEFAULT '0' NOT NULL
768 CREATE TABLE "stats_site" (
769 "month" integer DEFAULT '0' NOT NULL,
770 "week" integer DEFAULT '0' NOT NULL,
771 "day" integer DEFAULT '0' NOT NULL,
772 "site_views" integer DEFAULT '0' NOT NULL,
773 "subdomain_views" integer DEFAULT '0' NOT NULL,
774 "downloads" integer DEFAULT '0' NOT NULL,
775 "uniq_users" integer DEFAULT '0' NOT NULL,
776 "sessions" integer DEFAULT '0' NOT NULL,
777 "total_users" integer DEFAULT '0' NOT NULL,
778 "new_users" integer DEFAULT '0' NOT NULL,
779 "new_projects" integer DEFAULT '0' NOT NULL
781 CREATE SEQUENCE "support_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
782 CREATE TABLE "support" (
783 "support_id" integer DEFAULT nextval('support_pk_seq'::text) NOT NULL,
784 "group_id" integer DEFAULT '0' NOT NULL,
785 "support_status_id" integer DEFAULT '0' NOT NULL,
786 "support_category_id" integer DEFAULT '0' NOT NULL,
787 "priority" integer DEFAULT '0' NOT NULL,
788 "submitted_by" integer DEFAULT '0' NOT NULL,
789 "assigned_to" integer DEFAULT '0' NOT NULL,
790 "open_date" integer DEFAULT '0' NOT NULL,
792 "close_date" integer DEFAULT '0' NOT NULL,
793 PRIMARY KEY ("support_id")
795 CREATE SEQUENCE "support_canned_responses_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
796 CREATE TABLE "support_canned_responses" (
797 "support_canned_id" integer DEFAULT nextval('support_canned_responses_pk_seq'::text) NOT NULL,
798 "group_id" integer DEFAULT '0' NOT NULL,
801 PRIMARY KEY ("support_canned_id")
803 CREATE SEQUENCE "support_category_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
804 CREATE TABLE "support_category" (
805 "support_category_id" integer DEFAULT nextval('support_category_pk_seq'::text) NOT NULL,
806 "group_id" integer DEFAULT '0' NOT NULL,
807 "category_name" text DEFAULT '' NOT NULL,
808 PRIMARY KEY ("support_category_id")
810 CREATE SEQUENCE "support_history_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
811 CREATE TABLE "support_history" (
812 "support_history_id" integer DEFAULT nextval('support_history_pk_seq'::text) NOT NULL,
813 "support_id" integer DEFAULT '0' NOT NULL,
814 "field_name" text DEFAULT '' NOT NULL,
815 "old_value" text DEFAULT '' NOT NULL,
816 "mod_by" integer DEFAULT '0' NOT NULL,
818 PRIMARY KEY ("support_history_id")
820 CREATE SEQUENCE "support_messages_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
821 CREATE TABLE "support_messages" (
822 "support_message_id" integer DEFAULT nextval('support_messages_pk_seq'::text) NOT NULL,
823 "support_id" integer DEFAULT '0' NOT NULL,
825 "date" integer DEFAULT '0' NOT NULL,
827 PRIMARY KEY ("support_message_id")
829 CREATE SEQUENCE "support_status_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
830 CREATE TABLE "support_status" (
831 "support_status_id" integer DEFAULT nextval('support_status_pk_seq'::text) NOT NULL,
833 PRIMARY KEY ("support_status_id")
835 CREATE SEQUENCE "supported_languages_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
836 CREATE TABLE "supported_languages" (
837 "language_id" integer DEFAULT nextval('supported_languages_pk_seq'::text) NOT NULL,
841 "language_code" character(2),
842 PRIMARY KEY ("language_id")
844 CREATE SEQUENCE "survey_question_types_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
845 CREATE TABLE "survey_question_types" (
846 "id" integer DEFAULT nextval('survey_question_types_pk_seq'::text) NOT NULL,
847 "type" text DEFAULT '' NOT NULL,
850 CREATE SEQUENCE "survey_questions_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
851 CREATE TABLE "survey_questions" (
852 "question_id" integer DEFAULT nextval('survey_questions_pk_seq'::text) NOT NULL,
853 "group_id" integer DEFAULT '0' NOT NULL,
854 "question" text DEFAULT '' NOT NULL,
855 "question_type" integer DEFAULT '0' NOT NULL,
856 PRIMARY KEY ("question_id")
858 CREATE TABLE "survey_rating_aggregate" (
859 "type" integer DEFAULT '0' NOT NULL,
860 "id" integer DEFAULT '0' NOT NULL,
861 "response" double precision DEFAULT '0' NOT NULL,
862 "count" integer DEFAULT '0' NOT NULL
864 CREATE TABLE "survey_rating_response" (
865 "user_id" integer DEFAULT '0' NOT NULL,
866 "type" integer DEFAULT '0' NOT NULL,
867 "id" integer DEFAULT '0' NOT NULL,
868 "response" integer DEFAULT '0' NOT NULL,
869 "date" integer DEFAULT '0' NOT NULL
871 CREATE TABLE "survey_responses" (
872 "user_id" integer DEFAULT '0' NOT NULL,
873 "group_id" integer DEFAULT '0' NOT NULL,
874 "survey_id" integer DEFAULT '0' NOT NULL,
875 "question_id" integer DEFAULT '0' NOT NULL,
876 "response" text DEFAULT '' NOT NULL,
877 "date" integer DEFAULT '0' NOT NULL
879 CREATE SEQUENCE "surveys_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
880 CREATE TABLE "surveys" (
881 "survey_id" integer DEFAULT nextval('surveys_pk_seq'::text) NOT NULL,
882 "group_id" integer DEFAULT '0' NOT NULL,
883 "survey_title" text DEFAULT '' NOT NULL,
884 "survey_questions" text DEFAULT '' NOT NULL,
885 "is_active" integer DEFAULT '1' NOT NULL,
886 PRIMARY KEY ("survey_id")
888 CREATE SEQUENCE "system_history_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
889 CREATE SEQUENCE "system_machines_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
890 CREATE SEQUENCE "system_news_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
891 CREATE SEQUENCE "system_services_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
892 CREATE SEQUENCE "system_status_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
893 CREATE TABLE "theme_prefs" (
894 "user_id" integer DEFAULT '0' NOT NULL,
895 "user_theme" integer DEFAULT '0' NOT NULL,
896 "body_font" character(80) DEFAULT '',
897 "body_size" character(5) DEFAULT '',
898 "titlebar_font" character(80) DEFAULT '',
899 "titlebar_size" character(5) DEFAULT '',
900 "color_titlebar_back" character(7) DEFAULT '',
901 "color_ltback1" character(7) DEFAULT '',
902 PRIMARY KEY ("user_id")
904 CREATE SEQUENCE "themes_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
905 CREATE TABLE "themes" (
906 "theme_id" integer DEFAULT nextval('themes_pk_seq'::text) NOT NULL,
907 "dirname" character varying(80),
908 "fullname" character varying(80),
909 PRIMARY KEY ("theme_id")
911 CREATE TABLE "tmp_projs_releases_tmp" (
912 "year" integer DEFAULT '0' NOT NULL,
913 "month" integer DEFAULT '0' NOT NULL,
914 "total_proj" integer DEFAULT '0' NOT NULL,
915 "total_releases" integer DEFAULT '0' NOT NULL
917 CREATE TABLE "top_group" (
918 "group_id" integer DEFAULT '0' NOT NULL,
919 "group_name" character varying(40),
920 "downloads_all" integer DEFAULT '0' NOT NULL,
921 "rank_downloads_all" integer DEFAULT '0' NOT NULL,
922 "rank_downloads_all_old" integer DEFAULT '0' NOT NULL,
923 "downloads_week" integer DEFAULT '0' NOT NULL,
924 "rank_downloads_week" integer DEFAULT '0' NOT NULL,
925 "rank_downloads_week_old" integer DEFAULT '0' NOT NULL,
926 "userrank" integer DEFAULT '0' NOT NULL,
927 "rank_userrank" integer DEFAULT '0' NOT NULL,
928 "rank_userrank_old" integer DEFAULT '0' NOT NULL,
929 "forumposts_week" integer DEFAULT '0' NOT NULL,
930 "rank_forumposts_week" integer DEFAULT '0' NOT NULL,
931 "rank_forumposts_week_old" integer DEFAULT '0' NOT NULL,
932 "pageviews_proj" integer DEFAULT '0' NOT NULL,
933 "rank_pageviews_proj" integer DEFAULT '0' NOT NULL,
934 "rank_pageviews_proj_old" integer DEFAULT '0' NOT NULL
936 CREATE SEQUENCE "trove_cat_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
937 CREATE TABLE "trove_cat" (
938 "trove_cat_id" integer DEFAULT nextval('trove_cat_pk_seq'::text) NOT NULL,
939 "version" integer DEFAULT '0' NOT NULL,
940 "parent" integer DEFAULT '0' NOT NULL,
941 "root_parent" integer DEFAULT '0' NOT NULL,
942 "shortname" character varying(80),
943 "fullname" character varying(80),
944 "description" character varying(255),
945 "count_subcat" integer DEFAULT '0' NOT NULL,
946 "count_subproj" integer DEFAULT '0' NOT NULL,
947 "fullpath" text DEFAULT '' NOT NULL,
949 PRIMARY KEY ("trove_cat_id")
951 CREATE SEQUENCE "trove_group_link_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
952 CREATE TABLE "trove_group_link" (
953 "trove_group_id" integer DEFAULT nextval('trove_group_link_pk_seq'::text) NOT NULL,
954 "trove_cat_id" integer DEFAULT '0' NOT NULL,
955 "trove_cat_version" integer DEFAULT '0' NOT NULL,
956 "group_id" integer DEFAULT '0' NOT NULL,
957 "trove_cat_root" integer DEFAULT '0' NOT NULL,
958 PRIMARY KEY ("trove_group_id")
960 CREATE SEQUENCE "trove_treesums_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
961 CREATE TABLE "trove_treesums" (
962 "trove_treesums_id" integer DEFAULT nextval('trove_treesums_pk_seq'::text) NOT NULL,
963 "trove_cat_id" integer DEFAULT '0' NOT NULL,
964 "limit_1" integer DEFAULT '0' NOT NULL,
965 "subprojects" integer DEFAULT '0' NOT NULL,
966 PRIMARY KEY ("trove_treesums_id")
968 CREATE SEQUENCE "user_bookmarks_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
969 CREATE TABLE "user_bookmarks" (
970 "bookmark_id" integer DEFAULT nextval('user_bookmarks_pk_seq'::text) NOT NULL,
971 "user_id" integer DEFAULT '0' NOT NULL,
973 "bookmark_title" text,
974 PRIMARY KEY ("bookmark_id")
976 CREATE SEQUENCE "user_diary_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
977 CREATE TABLE "user_diary" (
978 "id" integer DEFAULT nextval('user_diary_pk_seq'::text) NOT NULL,
979 "user_id" integer DEFAULT '0' NOT NULL,
980 "date_posted" integer DEFAULT '0' NOT NULL,
983 "is_public" integer DEFAULT '0' NOT NULL,
986 CREATE SEQUENCE "user_diary_monitor_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
987 CREATE TABLE "user_diary_monitor" (
988 "monitor_id" integer DEFAULT nextval('user_diary_monitor_pk_seq'::text) NOT NULL,
989 "monitored_user" integer DEFAULT '0' NOT NULL,
990 "user_id" integer DEFAULT '0' NOT NULL,
991 PRIMARY KEY ("monitor_id")
993 CREATE SEQUENCE "user_group_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
994 CREATE TABLE "user_group" (
995 "user_group_id" integer DEFAULT nextval('user_group_pk_seq'::text) NOT NULL,
996 "user_id" integer DEFAULT '0' NOT NULL,
997 "group_id" integer DEFAULT '0' NOT NULL,
998 "admin_flags" character(16) DEFAULT '' NOT NULL,
999 "bug_flags" integer DEFAULT '0' NOT NULL,
1000 "forum_flags" integer DEFAULT '0' NOT NULL,
1001 "project_flags" integer DEFAULT '2' NOT NULL,
1002 "patch_flags" integer DEFAULT '1' NOT NULL,
1003 "support_flags" integer DEFAULT '1' NOT NULL,
1004 "doc_flags" integer DEFAULT '0' NOT NULL,
1005 "cvs_flags" integer DEFAULT '1' NOT NULL,
1006 "member_role" integer DEFAULT '100' NOT NULL,
1007 "release_flags" integer DEFAULT '0' NOT NULL,
1008 PRIMARY KEY ("user_group_id")
1010 CREATE SEQUENCE "user_metric_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1011 CREATE TABLE "user_metric" (
1012 "ranking" integer DEFAULT nextval('user_metric_pk_seq'::text) NOT NULL,
1013 "user_id" integer DEFAULT '0' NOT NULL,
1014 "times_ranked" integer DEFAULT '0' NOT NULL,
1015 "avg_raters_importance" double precision DEFAULT '0.00000000' NOT NULL,
1016 "avg_rating" double precision DEFAULT '0.00000000' NOT NULL,
1017 "metric" double precision DEFAULT '0.00000000' NOT NULL,
1018 "percentile" double precision DEFAULT '0.00000000' NOT NULL,
1019 "importance_factor" double precision DEFAULT '0.00000000' NOT NULL,
1020 PRIMARY KEY ("ranking")
1022 CREATE SEQUENCE "user_metric0_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1023 CREATE TABLE "user_metric0" (
1024 "ranking" integer DEFAULT nextval('user_metric0_pk_seq'::text) NOT NULL,
1025 "user_id" integer DEFAULT '0' NOT NULL,
1026 "times_ranked" integer DEFAULT '0' NOT NULL,
1027 "avg_raters_importance" double precision DEFAULT '0.00000000' NOT NULL,
1028 "avg_rating" double precision DEFAULT '0.00000000' NOT NULL,
1029 "metric" double precision DEFAULT '0.00000000' NOT NULL,
1030 "percentile" double precision DEFAULT '0.00000000' NOT NULL,
1031 "importance_factor" double precision DEFAULT '0.00000000' NOT NULL,
1032 PRIMARY KEY ("ranking")
1034 CREATE TABLE "user_preferences" (
1035 "user_id" integer DEFAULT '0' NOT NULL,
1036 "preference_name" character varying(20),
1037 "preference_value" character varying(20),
1038 "set_date" integer DEFAULT '0' NOT NULL
1040 CREATE TABLE "user_ratings" (
1041 "rated_by" integer DEFAULT '0' NOT NULL,
1042 "user_id" integer DEFAULT '0' NOT NULL,
1043 "rate_field" integer DEFAULT '0' NOT NULL,
1044 "rating" integer DEFAULT '0' NOT NULL
1046 CREATE SEQUENCE "users_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1047 CREATE TABLE "users" (
1048 "user_id" integer DEFAULT nextval('users_pk_seq'::text) NOT NULL,
1049 "user_name" text DEFAULT '' NOT NULL,
1050 "email" text DEFAULT '' NOT NULL,
1051 "user_pw" character varying(32) DEFAULT '' NOT NULL,
1052 "realname" character varying(32) DEFAULT '' NOT NULL,
1053 "status" character(1) DEFAULT 'A' NOT NULL,
1054 "shell" character varying(20) DEFAULT '/bin/bash' NOT NULL,
1055 "unix_pw" character varying(40) DEFAULT '' NOT NULL,
1056 "unix_status" character(1) DEFAULT 'N' NOT NULL,
1057 "unix_uid" integer DEFAULT '0' NOT NULL,
1058 "unix_box" character varying(10) DEFAULT 'shell1' NOT NULL,
1059 "add_date" integer DEFAULT '0' NOT NULL,
1060 "confirm_hash" character varying(32),
1061 "mail_siteupdates" integer DEFAULT '0' NOT NULL,
1062 "mail_va" integer DEFAULT '0' NOT NULL,
1063 "authorized_keys" text,
1065 "people_view_skills" integer DEFAULT '0' NOT NULL,
1066 "people_resume" text DEFAULT '' NOT NULL,
1067 "timezone" character varying(64) DEFAULT 'GMT',
1068 "language" integer DEFAULT '1' NOT NULL,
1069 PRIMARY KEY ("user_id")
1071 CREATE SEQUENCE "unix_uid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1072 CREATE SEQUENCE "forum_thread_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1073 CREATE TABLE "trove_agg" (
1074 "trove_cat_id" integer,
1076 "group_name" character varying(40),
1077 "unix_group_name" character varying(30),
1078 "status" character(1),
1079 "register_time" integer,
1080 "short_description" character varying(255),
1081 "percentile" double precision,
1084 CREATE TABLE "activity_log" (
1085 "day" integer DEFAULT '0' NOT NULL,
1086 "hour" integer DEFAULT '0' NOT NULL,
1087 "group_id" integer DEFAULT '0' NOT NULL,
1088 "browser" character varying(8) DEFAULT 'OTHER' NOT NULL,
1089 "ver" double precision DEFAULT '0.00' NOT NULL,
1090 "platform" character varying(8) DEFAULT 'OTHER' NOT NULL,
1091 "time" integer DEFAULT '0' NOT NULL,
1093 "type" integer DEFAULT '0' NOT NULL