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
1095 CREATE TABLE "activity_log_old" (
1096 "day" integer DEFAULT '0' NOT NULL,
1097 "hour" integer DEFAULT '0' NOT NULL,
1098 "group_id" integer DEFAULT '0' NOT NULL,
1099 "browser" character varying(8) DEFAULT 'OTHER' NOT NULL,
1100 "ver" double precision DEFAULT '0.00' NOT NULL,
1101 "platform" character varying(8) DEFAULT 'OTHER' NOT NULL,
1102 "time" integer DEFAULT '0' NOT NULL,
1104 "type" integer DEFAULT '0' NOT NULL
1106 CREATE TABLE "activity_log_old_old" (
1107 "day" integer DEFAULT '0' NOT NULL,
1108 "hour" integer DEFAULT '0' NOT NULL,
1109 "group_id" integer DEFAULT '0' NOT NULL,
1110 "browser" character varying(8) DEFAULT 'OTHER' NOT NULL,
1111 "ver" double precision DEFAULT '0.00' NOT NULL,
1112 "platform" character varying(8) DEFAULT 'OTHER' NOT NULL,
1113 "time" integer DEFAULT '0' NOT NULL,
1115 "type" integer DEFAULT '0' NOT NULL
1117 CREATE INDEX "bug_group_id" on "bug" using btree ( "group_id" "int4_ops" );
1118 CREATE INDEX "bug_groupid_statusid" on "bug" using btree ( "group_id" "int4_ops", "status_id" "int4_ops" );
1119 CREATE INDEX "bug_groupid_assignedto_statusid" on "bug" using btree ( "group_id" "int4_ops", "assigned_to" "int4_ops", "status_id" "int4_ops" );
1120 CREATE INDEX "bug_bug_dependencies_bug_id" on "bug_bug_dependencies" using btree ( "bug_id" "int4_ops" );
1121 CREATE INDEX "bug_bug_is_dependent_on_task_id" on "bug_bug_dependencies" using btree ( "is_dependent_on_bug_id" "int4_ops" );
1122 CREATE INDEX "bug_canned_response_group_id" on "bug_canned_responses" using btree ( "group_id" "int4_ops" );
1123 CREATE INDEX "bug_category_group_id" on "bug_category" using btree ( "group_id" "int4_ops" );
1124 CREATE INDEX "bug_group_group_id" on "bug_group" using btree ( "group_id" "int4_ops" );
1125 CREATE INDEX "bug_history_bug_id" on "bug_history" using btree ( "bug_id" "int4_ops" );
1126 CREATE INDEX "bug_task_dependencies_bug_id" on "bug_task_dependencies" using btree ( "bug_id" "int4_ops" );
1127 CREATE INDEX "bug_task_is_dependent_on_task_i" on "bug_task_dependencies" using btree ( "is_dependent_on_task_id" "int4_ops" );
1128 CREATE INDEX "db_images_group" on "db_images" using btree ( "group_id" "int4_ops" );
1129 CREATE INDEX "doc_group_doc_group" on "doc_data" using btree ( "doc_group" "int4_ops" );
1130 CREATE INDEX "doc_groups_group" on "doc_groups" using btree ( "group_id" "int4_ops" );
1131 CREATE INDEX "filemodule_monitor_id" on "filemodule_monitor" using btree ( "filemodule_id" "int4_ops" );
1132 CREATE INDEX "forum_forumid_msgid" on "forum" using btree ( "group_forum_id" "int4_ops", "msg_id" "int4_ops" );
1133 CREATE INDEX "forum_group_forum_id" on "forum" using btree ( "group_forum_id" "int4_ops" );
1134 CREATE INDEX "forum_forumid_isfollowupto" on "forum" using btree ( "group_forum_id" "int4_ops", "is_followup_to" "int4_ops" );
1135 CREATE INDEX "forum_forumid_threadid_mostrece" on "forum" using btree ( "group_forum_id" "int4_ops", "thread_id" "int4_ops", "most_recent_date" "int4_ops" );
1136 CREATE INDEX "forum_threadid_isfollowupto" on "forum" using btree ( "thread_id" "int4_ops", "is_followup_to" "int4_ops" );
1137 CREATE INDEX "forum_forumid_isfollto_mostrece" on "forum" using btree ( "group_forum_id" "int4_ops", "is_followup_to" "int4_ops", "most_recent_date" "int4_ops" );
1138 CREATE INDEX "forum_group_list_group_id" on "forum_group_list" using btree ( "group_id" "int4_ops" );
1139 CREATE INDEX "forum_monitor_combo_id" on "forum_monitored_forums" using btree ( "forum_id" "int4_ops", "user_id" "int4_ops" );
1140 CREATE INDEX "forum_monitor_thread_id" on "forum_monitored_forums" using btree ( "forum_id" "int4_ops" );
1141 CREATE INDEX "foundry_news_foundry_approved_d" on "foundry_news" using btree ( "foundry_id" "int4_ops", "is_approved" "int4_ops", "approve_date" "int4_ops" );
1142 CREATE INDEX "foundry_news_foundry_approved" on "foundry_news" using btree ( "foundry_id" "int4_ops", "is_approved" "int4_ops" );
1143 CREATE INDEX "foundry_news_foundry" on "foundry_news" using btree ( "foundry_id" "int4_ops" );
1144 CREATE INDEX "foundrynews_foundry_date_approv" on "foundry_news" using btree ( "foundry_id" "int4_ops", "approve_date" "int4_ops", "is_approved" "int4_ops" );
1145 CREATE INDEX "foundry_project_group_rank" on "foundry_preferred_projects" using btree ( "group_id" "int4_ops", "rank" "int4_ops" );
1146 CREATE INDEX "foundry_project_group" on "foundry_preferred_projects" using btree ( "group_id" "int4_ops" );
1147 CREATE INDEX "foundry_projects_foundry" on "foundry_projects" using btree ( "foundry_id" "int4_ops" );
1148 CREATE INDEX "downloads_http_idx" on "frs_dlstats_agg" using btree ( "downloads_http" "int4_ops" );
1149 CREATE INDEX "downloads_ftp_idx" on "frs_dlstats_agg" using btree ( "downloads_ftp" "int4_ops" );
1150 CREATE INDEX "file_id_idx" on "frs_dlstats_agg" using btree ( "file_id" "int4_ops" );
1151 CREATE INDEX "day_idx" on "frs_dlstats_agg" using btree ( "day" "int4_ops" );
1152 CREATE INDEX "dlstats_file_down" on "frs_dlstats_file_agg" using btree ( "downloads" "int4_ops" );
1153 CREATE INDEX "dlstats_file_file_id" on "frs_dlstats_file_agg" using btree ( "file_id" "int4_ops" );
1154 CREATE INDEX "dlstats_file_day" on "frs_dlstats_file_agg" using btree ( "day" "int4_ops" );
1155 CREATE INDEX "stats_agr_tmp_fid" on "frs_dlstats_filetotal_agg" using btree ( "file_id" "int4_ops" );
1156 CREATE INDEX "frs_dlstats_filetotal_agg_old_f" on "frs_dlstats_filetotal_agg_old" using btree ( "file_id" "int4_ops" );
1157 CREATE INDEX "frsdlstatsgroupagg_day_dls" on "frs_dlstats_group_agg" using btree ( "day" "int4_ops", "downloads" "int4_ops" );
1158 CREATE INDEX "group_id_idx" on "frs_dlstats_group_agg" using btree ( "group_id" "int4_ops" );
1159 CREATE INDEX "frs_dlstats_group_agg_day" on "frs_dlstats_group_agg" using btree ( "day" "int4_ops" );
1160 CREATE INDEX "stats_agr_tmp_gid" on "frs_dlstats_grouptotal_agg" using btree ( "group_id" "int4_ops" );
1161 CREATE INDEX "frs_file_name" on "frs_file" using btree ( "filename" "text_ops" );
1162 CREATE INDEX "frs_file_date" on "frs_file" using btree ( "post_date" "int4_ops" );
1163 CREATE INDEX "frs_file_processor" on "frs_file" using btree ( "processor_id" "int4_ops" );
1164 CREATE INDEX "frs_file_release_id" on "frs_file" using btree ( "release_id" "int4_ops" );
1165 CREATE INDEX "frs_file_type" on "frs_file" using btree ( "type_id" "int4_ops" );
1166 CREATE INDEX "package_group_id" on "frs_package" using btree ( "group_id" "int4_ops" );
1167 CREATE INDEX "frs_release_package" on "frs_release" using btree ( "package_id" "int4_ops" );
1168 CREATE INDEX "frs_release_date" on "frs_release" using btree ( "release_date" "int4_ops" );
1169 CREATE INDEX "frs_release_by" on "frs_release" using btree ( "released_by" "int4_ops" );
1170 CREATE INDEX "group_cvs_history_group_id" on "group_cvs_history" using btree ( "group_id" "int4_ops" );
1171 CREATE INDEX "user_name_idx" on "group_cvs_history" using btree ( "user_name" "varchar_ops" );
1172 CREATE INDEX "group_history_group_id" on "group_history" using btree ( "group_id" "int4_ops" );
1173 CREATE INDEX "groups_unix" on "groups" using btree ( "unix_group_name" "varchar_ops" );
1174 CREATE INDEX "groups_type" on "groups" using btree ( "type" "int4_ops" );
1175 CREATE INDEX "groups_public" on "groups" using btree ( "is_public" "int4_ops" );
1176 CREATE INDEX "groups_status" on "groups" using btree ( "status" "bpchar_ops" );
1177 CREATE INDEX "mail_group_list_group" on "mail_group_list" using btree ( "group_id" "int4_ops" );
1178 CREATE INDEX "news_bytes_group" on "news_bytes" using btree ( "group_id" "int4_ops" );
1179 CREATE INDEX "news_bytes_approved" on "news_bytes" using btree ( "is_approved" "int4_ops" );
1180 CREATE INDEX "news_bytes_forum" on "news_bytes" using btree ( "forum_id" "int4_ops" );
1181 CREATE INDEX "news_group_date" on "news_bytes" using btree ( "group_id" "int4_ops", "date" "int4_ops" );
1182 CREATE INDEX "news_approved_date" on "news_bytes" using btree ( "is_approved" "int4_ops", "date" "int4_ops" );
1183 CREATE INDEX "patch_group_id" on "patch" using btree ( "group_id" "int4_ops" );
1184 CREATE INDEX "patch_groupid_assignedto_status" on "patch" using btree ( "group_id" "int4_ops", "assigned_to" "int4_ops", "patch_status_id" "int4_ops" );
1185 CREATE INDEX "patch_groupid_assignedto" on "patch" using btree ( "group_id" "int4_ops", "assigned_to" "int4_ops" );
1186 CREATE INDEX "patch_groupid_status" on "patch" using btree ( "group_id" "int4_ops", "patch_status_id" "int4_ops" );
1187 CREATE INDEX "patch_group_group_id" on "patch_category" using btree ( "group_id" "int4_ops" );
1188 CREATE INDEX "patch_history_patch_id" on "patch_history" using btree ( "patch_id" "int4_ops" );
1189 CREATE INDEX "people_job_group_id" on "people_job" using btree ( "group_id" "int4_ops" );
1190 CREATE INDEX "project_assigned_to_assigned_to" on "project_assigned_to" using btree ( "assigned_to_id" "int4_ops" );
1191 CREATE INDEX "project_assigned_to_task_id" on "project_assigned_to" using btree ( "project_task_id" "int4_ops" );
1192 CREATE INDEX "project_is_dependent_on_task_id" on "project_dependencies" using btree ( "is_dependent_on_task_id" "int4_ops" );
1193 CREATE INDEX "project_dependencies_task_id" on "project_dependencies" using btree ( "project_task_id" "int4_ops" );
1194 CREATE INDEX "project_group_list_group_id" on "project_group_list" using btree ( "group_id" "int4_ops" );
1195 CREATE INDEX "project_history_task_id" on "project_history" using btree ( "project_task_id" "int4_ops" );
1196 CREATE INDEX "project_metric_group" on "project_metric" using btree ( "group_id" "int4_ops" );
1197 CREATE INDEX "project_task_group_project_id" on "project_task" using btree ( "group_project_id" "int4_ops" );
1198 CREATE INDEX "projecttask_projid_status" on "project_task" using btree ( "group_project_id" "int4_ops", "status_id" "int4_ops" );
1199 CREATE INDEX "projectweeklymetric_ranking" on "project_weekly_metric" using btree ( "ranking" "int4_ops" );
1200 CREATE INDEX "project_metric_weekly_group" on "project_weekly_metric" using btree ( "group_id" "int4_ops" );
1201 CREATE INDEX "session_user_id" on "session" using btree ( "user_id" "int4_ops" );
1202 CREATE INDEX "session_time" on "session" using btree ( "time" "int4_ops" );
1203 CREATE INDEX "snippet_language" on "snippet" using btree ( "language" "int4_ops" );
1204 CREATE INDEX "snippet_category" on "snippet" using btree ( "category" "int4_ops" );
1205 CREATE INDEX "snippet_package_language" on "snippet_package" using btree ( "language" "int4_ops" );
1206 CREATE INDEX "snippet_package_category" on "snippet_package" using btree ( "category" "int4_ops" );
1207 CREATE INDEX "snippet_package_item_pkg_ver" on "snippet_package_item" using btree ( "snippet_package_version_id" "int4_ops" );
1208 CREATE INDEX "snippet_package_version_pkg_id" on "snippet_package_version" using btree ( "snippet_package_id" "int4_ops" );
1209 CREATE INDEX "snippet_version_snippet_id" on "snippet_version" using btree ( "snippet_id" "int4_ops" );
1210 CREATE INDEX "pages_by_day_day" on "stats_agg_pages_by_day" using btree ( "day" "int4_ops" );
1211 CREATE INDEX "stats_agr_filerelease_group_id" on "stats_agr_filerelease" using btree ( "group_id" "int4_ops" );
1212 CREATE INDEX "stats_agr_filerelease_filerelea" on "stats_agr_filerelease" using btree ( "filerelease_id" "int4_ops" );
1213 CREATE INDEX "project_agr_log_group" on "stats_agr_project" using btree ( "group_id" "int4_ops" );
1214 CREATE INDEX "ftpdl_group_id" on "stats_ftp_downloads" using btree ( "group_id" "int4_ops" );
1215 CREATE INDEX "ftpdl_fid" on "stats_ftp_downloads" using btree ( "filerelease_id" "int4_ops" );
1216 CREATE INDEX "ftpdl_day" on "stats_ftp_downloads" using btree ( "day" "int4_ops" );
1217 CREATE INDEX "httpdl_group_id" on "stats_http_downloads" using btree ( "group_id" "int4_ops" );
1218 CREATE INDEX "httpdl_fid" on "stats_http_downloads" using btree ( "filerelease_id" "int4_ops" );
1219 CREATE INDEX "httpdl_day" on "stats_http_downloads" using btree ( "day" "int4_ops" );
1220 CREATE INDEX "archive_project_monthday" on "stats_project" using btree ( "month" "int4_ops", "day" "int4_ops" );
1221 CREATE INDEX "project_log_group" on "stats_project" using btree ( "group_id" "int4_ops" );
1222 CREATE INDEX "archive_project_week" on "stats_project" using btree ( "week" "int4_ops" );
1223 CREATE INDEX "archive_project_day" on "stats_project" using btree ( "day" "int4_ops" );
1224 CREATE INDEX "archive_project_month" on "stats_project" using btree ( "month" "int4_ops" );
1225 CREATE INDEX "stats_project_tmp_group_id" on "stats_project_tmp" using btree ( "group_id" "int4_ops" );
1226 CREATE INDEX "project_stats_week" on "stats_project_tmp" using btree ( "week" "int4_ops" );
1227 CREATE INDEX "project_stats_month" on "stats_project_tmp" using btree ( "month" "int4_ops" );
1228 CREATE INDEX "project_stats_day" on "stats_project_tmp" using btree ( "day" "int4_ops" );
1229 CREATE INDEX "stats_site_monthday" on "stats_site" using btree ( "month" "int4_ops", "day" "int4_ops" );
1230 CREATE INDEX "stats_site_week" on "stats_site" using btree ( "week" "int4_ops" );
1231 CREATE INDEX "stats_site_day" on "stats_site" using btree ( "day" "int4_ops" );
1232 CREATE INDEX "stats_site_month" on "stats_site" using btree ( "month" "int4_ops" );
1233 CREATE INDEX "support_group_id" on "support" using btree ( "group_id" "int4_ops" );
1234 CREATE INDEX "support_groupid_assignedto" on "support" using btree ( "group_id" "int4_ops", "assigned_to" "int4_ops" );
1235 CREATE INDEX "support_groupid_assignedto_stat" on "support" using btree ( "group_id" "int4_ops", "assigned_to" "int4_ops", "support_status_id" "int4_ops" );
1236 CREATE INDEX "support_groupid_status" on "support" using btree ( "group_id" "int4_ops", "support_status_id" "int4_ops" );
1237 CREATE INDEX "support_canned_response_group_i" on "support_canned_responses" using btree ( "group_id" "int4_ops" );
1238 CREATE INDEX "support_group_group_id" on "support_category" using btree ( "group_id" "int4_ops" );
1239 CREATE INDEX "support_history_support_id" on "support_history" using btree ( "support_id" "int4_ops" );
1240 CREATE INDEX "support_messages_support_id" on "support_messages" using btree ( "support_id" "int4_ops" );
1241 CREATE INDEX "supported_languages_code" on "supported_languages" using btree ( "language_code" "bpchar_ops" );
1242 CREATE INDEX "survey_questions_group" on "survey_questions" using btree ( "group_id" "int4_ops" );
1243 CREATE INDEX "survey_rating_aggregate_type_id" on "survey_rating_aggregate" using btree ( "type" "int4_ops", "id" "int4_ops" );
1244 CREATE INDEX "survey_rating_responses_user_ty" on "survey_rating_response" using btree ( "user_id" "int4_ops", "type" "int4_ops", "id" "int4_ops" );
1245 CREATE INDEX "survey_rating_responses_type_id" on "survey_rating_response" using btree ( "type" "int4_ops", "id" "int4_ops" );
1246 CREATE INDEX "survey_responses_group_id" on "survey_responses" using btree ( "group_id" "int4_ops" );
1247 CREATE INDEX "survey_responses_user_survey_qu" on "survey_responses" using btree ( "user_id" "int4_ops", "survey_id" "int4_ops", "question_id" "int4_ops" );
1248 CREATE INDEX "survey_responses_user_survey" on "survey_responses" using btree ( "user_id" "int4_ops", "survey_id" "int4_ops" );
1249 CREATE INDEX "survey_responses_survey_questio" on "survey_responses" using btree ( "survey_id" "int4_ops", "question_id" "int4_ops" );
1250 CREATE INDEX "surveys_group" on "surveys" using btree ( "group_id" "int4_ops" );
1251 CREATE INDEX "rank_forumposts_week_idx" on "top_group" using btree ( "rank_forumposts_week" "int4_ops" );
1252 CREATE INDEX "rank_downloads_week_idx" on "top_group" using btree ( "rank_downloads_week" "int4_ops" );
1253 CREATE INDEX "pageviews_proj_idx" on "top_group" using btree ( "pageviews_proj" "int4_ops" );
1254 CREATE INDEX "rank_userrank_idx" on "top_group" using btree ( "rank_userrank" "int4_ops" );
1255 CREATE INDEX "rank_downloads_all_idx" on "top_group" using btree ( "rank_downloads_all" "int4_ops" );
1256 CREATE INDEX "parent_idx" on "trove_cat" using btree ( "parent" "int4_ops" );
1257 CREATE INDEX "root_parent_idx" on "trove_cat" using btree ( "root_parent" "int4_ops" );
1258 CREATE INDEX "version_idx" on "trove_cat" using btree ( "version" "int4_ops" );
1259 CREATE INDEX "trove_group_link_group_id" on "trove_group_link" using btree ( "group_id" "int4_ops" );
1260 CREATE INDEX "trove_group_link_cat_id" on "trove_group_link" using btree ( "trove_cat_id" "int4_ops" );
1261 CREATE INDEX "user_bookmark_user_id" on "user_bookmarks" using btree ( "user_id" "int4_ops" );
1262 CREATE INDEX "user_diary_user" on "user_diary" using btree ( "user_id" "int4_ops" );
1263 CREATE INDEX "user_diary_user_date" on "user_diary" using btree ( "user_id" "int4_ops", "date_posted" "int4_ops" );
1264 CREATE INDEX "user_diary_date" on "user_diary" using btree ( "date_posted" "int4_ops" );
1265 CREATE INDEX "user_diary_monitor_user" on "user_diary_monitor" using btree ( "user_id" "int4_ops" );
1266 CREATE INDEX "user_diary_monitor_monitored_us" on "user_diary_monitor" using btree ( "monitored_user" "int4_ops" );
1267 CREATE INDEX "user_group_group_id" on "user_group" using btree ( "group_id" "int4_ops" );
1268 CREATE INDEX "bug_flags_idx" on "user_group" using btree ( "bug_flags" "int4_ops" );
1269 CREATE INDEX "project_flags_idx" on "user_group" using btree ( "project_flags" "int4_ops" );
1270 CREATE INDEX "user_group_user_id" on "user_group" using btree ( "user_id" "int4_ops" );
1271 CREATE INDEX "admin_flags_idx" on "user_group" using btree ( "admin_flags" "bpchar_ops" );
1272 CREATE INDEX "forum_flags_idx" on "user_group" using btree ( "forum_flags" "int4_ops" );
1273 CREATE INDEX "user_metric0_user_id" on "user_metric0" using btree ( "user_id" "int4_ops" );
1274 CREATE INDEX "user_pref_user_id" on "user_preferences" using btree ( "user_id" "int4_ops" );
1275 CREATE INDEX "user_ratings_rated_by" on "user_ratings" using btree ( "rated_by" "int4_ops" );
1276 CREATE INDEX "user_ratings_user_id" on "user_ratings" using btree ( "user_id" "int4_ops" );
1277 CREATE INDEX "users_status" on "users" using btree ( "status" "bpchar_ops" );
1278 CREATE INDEX "user_user" on "users" using btree ( "status" "bpchar_ops" );
1279 CREATE INDEX "idx_users_username" on "users" using btree ( "user_name" "text_ops" );
1280 CREATE INDEX "users_user_pw" on "users" using btree ( "user_pw" "varchar_ops" );
1281 CREATE INDEX "troveagg_trovecatid" on "trove_agg" using btree ( "trove_cat_id" "int4_ops" );
1282 CREATE CONSTRAINT TRIGGER "user_group_user_id_fk" AFTER INSERT OR UPDATE ON "user_group" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('user_group_user_id_fk', 'user_group', 'users', 'FULL', 'user_id', 'user_id');
1283 CREATE CONSTRAINT TRIGGER "user_group_user_id_fk" AFTER DELETE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('user_group_user_id_fk', 'user_group', 'users', 'FULL', 'user_id', 'user_id');
1284 CREATE CONSTRAINT TRIGGER "user_group_user_id_fk" AFTER UPDATE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('user_group_user_id_fk', 'user_group', 'users', 'FULL', 'user_id', 'user_id');
1285 CREATE CONSTRAINT TRIGGER "user_group_group_id_fk" AFTER INSERT OR UPDATE ON "user_group" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('user_group_group_id_fk', 'user_group', 'groups', 'FULL', 'group_id', 'group_id');
1286 CREATE CONSTRAINT TRIGGER "user_group_group_id_fk" AFTER DELETE ON "groups" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('user_group_group_id_fk', 'user_group', 'groups', 'FULL', 'group_id', 'group_id');
1287 CREATE CONSTRAINT TRIGGER "user_group_group_id_fk" AFTER UPDATE ON "groups" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('user_group_group_id_fk', 'user_group', 'groups', 'FULL', 'group_id', 'group_id');
1288 CREATE CONSTRAINT TRIGGER "forum_posted_by_fk" AFTER INSERT OR UPDATE ON "forum" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('forum_posted_by_fk', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
1289 CREATE CONSTRAINT TRIGGER "forum_posted_by_fk" AFTER DELETE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('forum_posted_by_fk', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
1290 CREATE CONSTRAINT TRIGGER "forum_posted_by_fk" AFTER UPDATE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('forum_posted_by_fk', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
1291 CREATE CONSTRAINT TRIGGER "forum_group_forum_id_fk" AFTER INSERT OR UPDATE ON "forum" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('forum_group_forum_id_fk', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
1292 CREATE CONSTRAINT TRIGGER "forum_group_forum_id_fk" AFTER DELETE ON "forum_group_list" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('forum_group_forum_id_fk', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
1293 CREATE CONSTRAINT TRIGGER "forum_group_forum_id_fk" AFTER UPDATE ON "forum_group_list" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('forum_group_forum_id_fk', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
1294 CREATE CONSTRAINT TRIGGER "forum_group_list_group_id_fk" AFTER INSERT OR UPDATE ON "forum_group_list" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('forum_group_list_group_id_fk', 'forum_group_list', 'groups', 'FULL', 'group_id', 'group_id');
1295 CREATE CONSTRAINT TRIGGER "forum_group_list_group_id_fk" AFTER DELETE ON "groups" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('forum_group_list_group_id_fk', 'forum_group_list', 'groups', 'FULL', 'group_id', 'group_id');
1296 CREATE CONSTRAINT TRIGGER "forum_group_list_group_id_fk" AFTER UPDATE ON "groups" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('forum_group_list_group_id_fk', 'forum_group_list', 'groups', 'FULL', 'group_id', 'group_id');
1297 CREATE CONSTRAINT TRIGGER "bug_group_group_fk" AFTER INSERT OR UPDATE ON "bug_group" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('bug_group_group_fk', 'bug_group', 'groups', 'FULL', 'group_id', 'group_id');
1298 CREATE CONSTRAINT TRIGGER "bug_group_group_fk" AFTER DELETE ON "groups" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('bug_group_group_fk', 'bug_group', 'groups', 'FULL', 'group_id', 'group_id');
1299 CREATE CONSTRAINT TRIGGER "bug_group_group_fk" AFTER UPDATE ON "groups" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('bug_group_group_fk', 'bug_group', 'groups', 'FULL', 'group_id', 'group_id');
1300 CREATE CONSTRAINT TRIGGER "bug_category_group_fk" AFTER INSERT OR UPDATE ON "bug_category" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('bug_category_group_fk', 'bug_category', 'groups', 'FULL', 'group_id', 'group_id');
1301 CREATE CONSTRAINT TRIGGER "bug_category_group_fk" AFTER DELETE ON "groups" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('bug_category_group_fk', 'bug_category', 'groups', 'FULL', 'group_id', 'group_id');
1302 CREATE CONSTRAINT TRIGGER "bug_category_group_fk" AFTER UPDATE ON "groups" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('bug_category_group_fk', 'bug_category', 'groups', 'FULL', 'group_id', 'group_id');
1303 CREATE CONSTRAINT TRIGGER "bug_submitted_by_fk" AFTER INSERT OR UPDATE ON "bug" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('bug_submitted_by_fk', 'bug', 'users', 'FULL', 'submitted_by', 'user_id');
1304 CREATE CONSTRAINT TRIGGER "bug_submitted_by_fk" AFTER DELETE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('bug_submitted_by_fk', 'bug', 'users', 'FULL', 'submitted_by', 'user_id');
1305 CREATE CONSTRAINT TRIGGER "bug_submitted_by_fk" AFTER UPDATE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('bug_submitted_by_fk', 'bug', 'users', 'FULL', 'submitted_by', 'user_id');
1306 CREATE CONSTRAINT TRIGGER "bug_assigned_to_fk" AFTER INSERT OR UPDATE ON "bug" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('bug_assigned_to_fk', 'bug', 'users', 'FULL', 'assigned_to', 'user_id');
1307 CREATE CONSTRAINT TRIGGER "bug_assigned_to_fk" AFTER DELETE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('bug_assigned_to_fk', 'bug', 'users', 'FULL', 'assigned_to', 'user_id');
1308 CREATE CONSTRAINT TRIGGER "bug_assigned_to_fk" AFTER UPDATE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('bug_assigned_to_fk', 'bug', 'users', 'FULL', 'assigned_to', 'user_id');
1309 CREATE CONSTRAINT TRIGGER "bug_status_fk" AFTER INSERT OR UPDATE ON "bug" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('bug_status_fk', 'bug', 'bug_status', 'FULL', 'status_id', 'status_id');
1310 CREATE CONSTRAINT TRIGGER "bug_status_fk" AFTER DELETE ON "bug_status" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('bug_status_fk', 'bug', 'bug_status', 'FULL', 'status_id', 'status_id');
1311 CREATE CONSTRAINT TRIGGER "bug_status_fk" AFTER UPDATE ON "bug_status" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('bug_status_fk', 'bug', 'bug_status', 'FULL', 'status_id', 'status_id');
1312 CREATE CONSTRAINT TRIGGER "bug_category_fk" AFTER INSERT OR UPDATE ON "bug" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('bug_category_fk', 'bug', 'bug_category', 'FULL', 'category_id', 'bug_category_id');
1313 CREATE CONSTRAINT TRIGGER "bug_category_fk" AFTER DELETE ON "bug_category" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('bug_category_fk', 'bug', 'bug_category', 'FULL', 'category_id', 'bug_category_id');
1314 CREATE CONSTRAINT TRIGGER "bug_category_fk" AFTER UPDATE ON "bug_category" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('bug_category_fk', 'bug', 'bug_category', 'FULL', 'category_id', 'bug_category_id');
1315 CREATE CONSTRAINT TRIGGER "bug_resolution_fk" AFTER INSERT OR UPDATE ON "bug" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('bug_resolution_fk', 'bug', 'bug_resolution', 'FULL', 'resolution_id', 'resolution_id');
1316 CREATE CONSTRAINT TRIGGER "bug_resolution_fk" AFTER DELETE ON "bug_resolution" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('bug_resolution_fk', 'bug', 'bug_resolution', 'FULL', 'resolution_id', 'resolution_id');
1317 CREATE CONSTRAINT TRIGGER "bug_resolution_fk" AFTER UPDATE ON "bug_resolution" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('bug_resolution_fk', 'bug', 'bug_resolution', 'FULL', 'resolution_id', 'resolution_id');
1318 CREATE CONSTRAINT TRIGGER "bug_group_fk" AFTER INSERT OR UPDATE ON "bug" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('bug_group_fk', 'bug', 'bug_group', 'FULL', 'bug_group_id', 'bug_group_id');
1319 CREATE CONSTRAINT TRIGGER "bug_group_fk" AFTER DELETE ON "bug_group" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('bug_group_fk', 'bug', 'bug_group', 'FULL', 'bug_group_id', 'bug_group_id');
1320 CREATE CONSTRAINT TRIGGER "bug_group_fk" AFTER UPDATE ON "bug_group" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('bug_group_fk', 'bug', 'bug_group', 'FULL', 'bug_group_id', 'bug_group_id');
1321 CREATE CONSTRAINT TRIGGER "forum_posted_by_fk" AFTER INSERT OR UPDATE ON "forum" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('forum_posted_by_fk', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
1322 CREATE CONSTRAINT TRIGGER "forum_posted_by_fk" AFTER DELETE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('forum_posted_by_fk', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
1323 CREATE CONSTRAINT TRIGGER "forum_posted_by_fk" AFTER UPDATE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('forum_posted_by_fk', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
1324 CREATE CONSTRAINT TRIGGER "forum_group_forum_id_fk" AFTER INSERT OR UPDATE ON "forum" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('forum_group_forum_id_fk', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
1325 CREATE CONSTRAINT TRIGGER "forum_group_forum_id_fk" AFTER DELETE ON "forum_group_list" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('forum_group_forum_id_fk', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
1326 CREATE CONSTRAINT TRIGGER "forum_group_forum_id_fk" AFTER UPDATE ON "forum_group_list" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('forum_group_forum_id_fk', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
1327 CREATE CONSTRAINT TRIGGER "project_group_list_group_id_fk" AFTER INSERT OR UPDATE ON "project_group_list" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('project_group_list_group_id_fk', 'project_group_list', 'groups', 'FULL', 'group_id', 'group_id');
1328 CREATE CONSTRAINT TRIGGER "project_group_list_group_id_fk" AFTER DELETE ON "groups" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('project_group_list_group_id_fk', 'project_group_list', 'groups', 'FULL', 'group_id', 'group_id');
1329 CREATE CONSTRAINT TRIGGER "project_group_list_group_id_fk" AFTER UPDATE ON "groups" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('project_group_list_group_id_fk', 'project_group_list', 'groups', 'FULL', 'group_id', 'group_id');
1330 CREATE CONSTRAINT TRIGGER "project_task_group_project_id_f" AFTER INSERT OR UPDATE ON "project_task" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('project_task_group_project_id_f', 'project_task', 'project_group_list', 'FULL', 'group_project_id', 'group_project_id');
1331 CREATE CONSTRAINT TRIGGER "project_task_group_project_id_f" AFTER DELETE ON "project_group_list" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('project_task_group_project_id_f', 'project_task', 'project_group_list', 'FULL', 'group_project_id', 'group_project_id');
1332 CREATE CONSTRAINT TRIGGER "project_task_group_project_id_f" AFTER UPDATE ON "project_group_list" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('project_task_group_project_id_f', 'project_task', 'project_group_list', 'FULL', 'group_project_id', 'group_project_id');
1333 CREATE CONSTRAINT TRIGGER "project_task_created_by_fk" AFTER INSERT OR UPDATE ON "project_task" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('project_task_created_by_fk', 'project_task', 'users', 'FULL', 'created_by', 'user_id');
1334 CREATE CONSTRAINT TRIGGER "project_task_created_by_fk" AFTER DELETE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('project_task_created_by_fk', 'project_task', 'users', 'FULL', 'created_by', 'user_id');
1335 CREATE CONSTRAINT TRIGGER "project_task_created_by_fk" AFTER UPDATE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('project_task_created_by_fk', 'project_task', 'users', 'FULL', 'created_by', 'user_id');
1336 CREATE CONSTRAINT TRIGGER "project_task_status_id_fk" AFTER INSERT OR UPDATE ON "project_task" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('project_task_status_id_fk', 'project_task', 'project_status', 'FULL', 'status_id', 'status_id');
1337 CREATE CONSTRAINT TRIGGER "project_task_status_id_fk" AFTER DELETE ON "project_status" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('project_task_status_id_fk', 'project_task', 'project_status', 'FULL', 'status_id', 'status_id');
1338 CREATE CONSTRAINT TRIGGER "project_task_status_id_fk" AFTER UPDATE ON "project_status" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('project_task_status_id_fk', 'project_task', 'project_status', 'FULL', 'status_id', 'status_id');
1339 CREATE CONSTRAINT TRIGGER "patch_status_id_fk" AFTER INSERT OR UPDATE ON "patch" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('patch_status_id_fk', 'patch', 'patch_status', 'FULL', 'patch_status_id', 'patch_status_id');
1340 CREATE CONSTRAINT TRIGGER "patch_status_id_fk" AFTER DELETE ON "patch_status" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('patch_status_id_fk', 'patch', 'patch_status', 'FULL', 'patch_status_id', 'patch_status_id');
1341 CREATE CONSTRAINT TRIGGER "patch_status_id_fk" AFTER UPDATE ON "patch_status" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('patch_status_id_fk', 'patch', 'patch_status', 'FULL', 'patch_status_id', 'patch_status_id');
1342 CREATE CONSTRAINT TRIGGER "patch_category_id_fk" AFTER INSERT OR UPDATE ON "patch" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('patch_category_id_fk', 'patch', 'patch_category', 'FULL', 'patch_category_id', 'patch_category_id');
1343 CREATE CONSTRAINT TRIGGER "patch_category_id_fk" AFTER DELETE ON "patch_category" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('patch_category_id_fk', 'patch', 'patch_category', 'FULL', 'patch_category_id', 'patch_category_id');
1344 CREATE CONSTRAINT TRIGGER "patch_category_id_fk" AFTER UPDATE ON "patch_category" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('patch_category_id_fk', 'patch', 'patch_category', 'FULL', 'patch_category_id', 'patch_category_id');
1345 CREATE CONSTRAINT TRIGGER "patch_submitted_by_fk" AFTER INSERT OR UPDATE ON "patch" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('patch_submitted_by_fk', 'patch', 'users', 'FULL', 'submitted_by', 'user_id');
1346 CREATE CONSTRAINT TRIGGER "patch_submitted_by_fk" AFTER DELETE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('patch_submitted_by_fk', 'patch', 'users', 'FULL', 'submitted_by', 'user_id');
1347 CREATE CONSTRAINT TRIGGER "patch_submitted_by_fk" AFTER UPDATE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('patch_submitted_by_fk', 'patch', 'users', 'FULL', 'submitted_by', 'user_id');
1348 CREATE CONSTRAINT TRIGGER "patch_assigned_to_fk" AFTER INSERT OR UPDATE ON "patch" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('patch_assigned_to_fk', 'patch', 'users', 'FULL', 'assigned_to', 'user_id');
1349 CREATE CONSTRAINT TRIGGER "patch_assigned_to_fk" AFTER DELETE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('patch_assigned_to_fk', 'patch', 'users', 'FULL', 'assigned_to', 'user_id');
1350 CREATE CONSTRAINT TRIGGER "patch_assigned_to_fk" AFTER UPDATE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('patch_assigned_to_fk', 'patch', 'users', 'FULL', 'assigned_to', 'user_id');
1351 CREATE CONSTRAINT TRIGGER "patch_category_group_id_fk" AFTER INSERT OR UPDATE ON "patch_category" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('patch_category_group_id_fk', 'patch_category', 'groups', 'FULL', 'group_id', 'group_id');
1352 CREATE CONSTRAINT TRIGGER "patch_category_group_id_fk" AFTER DELETE ON "groups" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('patch_category_group_id_fk', 'patch_category', 'groups', 'FULL', 'group_id', 'group_id');
1353 CREATE CONSTRAINT TRIGGER "patch_category_group_id_fk" AFTER UPDATE ON "groups" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('patch_category_group_id_fk', 'patch_category', 'groups', 'FULL', 'group_id', 'group_id');
1354 CREATE CONSTRAINT TRIGGER "support_status_id_fk" AFTER INSERT OR UPDATE ON "support" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('support_status_id_fk', 'support', 'support_status', 'FULL', 'support_status_id', 'support_status_id');
1355 CREATE CONSTRAINT TRIGGER "support_status_id_fk" AFTER DELETE ON "support_status" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('support_status_id_fk', 'support', 'support_status', 'FULL', 'support_status_id', 'support_status_id');
1356 CREATE CONSTRAINT TRIGGER "support_status_id_fk" AFTER UPDATE ON "support_status" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('support_status_id_fk', 'support', 'support_status', 'FULL', 'support_status_id', 'support_status_id');
1357 CREATE CONSTRAINT TRIGGER "support_category_id_fk" AFTER INSERT OR UPDATE ON "support" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('support_category_id_fk', 'support', 'support_category', 'FULL', 'support_category_id', 'support_category_id');
1358 CREATE CONSTRAINT TRIGGER "support_category_id_fk" AFTER DELETE ON "support_category" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('support_category_id_fk', 'support', 'support_category', 'FULL', 'support_category_id', 'support_category_id');
1359 CREATE CONSTRAINT TRIGGER "support_category_id_fk" AFTER UPDATE ON "support_category" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('support_category_id_fk', 'support', 'support_category', 'FULL', 'support_category_id', 'support_category_id');
1360 CREATE CONSTRAINT TRIGGER "support_submitted_by_fk" AFTER INSERT OR UPDATE ON "support" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('support_submitted_by_fk', 'support', 'users', 'FULL', 'submitted_by', 'user_id');
1361 CREATE CONSTRAINT TRIGGER "support_submitted_by_fk" AFTER DELETE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('support_submitted_by_fk', 'support', 'users', 'FULL', 'submitted_by', 'user_id');
1362 CREATE CONSTRAINT TRIGGER "support_submitted_by_fk" AFTER UPDATE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('support_submitted_by_fk', 'support', 'users', 'FULL', 'submitted_by', 'user_id');
1363 CREATE CONSTRAINT TRIGGER "support_assigned_to_fk" AFTER INSERT OR UPDATE ON "support" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('support_assigned_to_fk', 'support', 'users', 'FULL', 'assigned_to', 'user_id');
1364 CREATE CONSTRAINT TRIGGER "support_assigned_to_fk" AFTER DELETE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('support_assigned_to_fk', 'support', 'users', 'FULL', 'assigned_to', 'user_id');
1365 CREATE CONSTRAINT TRIGGER "support_assigned_to_fk" AFTER UPDATE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('support_assigned_to_fk', 'support', 'users', 'FULL', 'assigned_to', 'user_id');
1366 CREATE CONSTRAINT TRIGGER "support_category_group_id_fk" AFTER INSERT OR UPDATE ON "support_category" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('support_category_group_id_fk', 'support_category', 'groups', 'FULL', 'group_id', 'group_id');
1367 CREATE CONSTRAINT TRIGGER "support_category_group_id_fk" AFTER DELETE ON "groups" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('support_category_group_id_fk', 'support_category', 'groups', 'FULL', 'group_id', 'group_id');
1368 CREATE CONSTRAINT TRIGGER "support_category_group_id_fk" AFTER UPDATE ON "groups" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('support_category_group_id_fk', 'support_category', 'groups', 'FULL', 'group_id', 'group_id');
1369 CREATE CONSTRAINT TRIGGER "users_languageid_fk" AFTER INSERT OR UPDATE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('users_languageid_fk', 'users', 'supported_languages', 'FULL', 'language', 'language_id');
1370 CREATE CONSTRAINT TRIGGER "users_languageid_fk" AFTER DELETE ON "supported_languages" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('users_languageid_fk', 'users', 'supported_languages', 'FULL', 'language', 'language_id');
1371 CREATE CONSTRAINT TRIGGER "users_languageid_fk" AFTER UPDATE ON "supported_languages" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('users_languageid_fk', 'users', 'supported_languages', 'FULL', 'language', 'language_id');