2 -- TOC Entry ID 2 (OID 18724)
4 -- Name: canned_responses_pk_seq Type: SEQUENCE Owner: tperdue
7 CREATE SEQUENCE "canned_responses_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
10 -- TOC Entry ID 176 (OID 18743)
12 -- Name: canned_responses Type: TABLE Owner: tperdue
15 CREATE TABLE "canned_responses" (
16 "response_id" integer DEFAULT nextval('canned_responses_pk_seq'::text) NOT NULL,
17 "response_title" character varying(25),
19 Constraint "canned_responses_pkey" Primary Key ("response_id")
23 -- TOC Entry ID 4 (OID 18774)
25 -- Name: db_images_pk_seq Type: SEQUENCE Owner: tperdue
28 CREATE SEQUENCE "db_images_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
31 -- TOC Entry ID 177 (OID 18793)
33 -- Name: db_images Type: TABLE Owner: tperdue
36 CREATE TABLE "db_images" (
37 "id" integer DEFAULT nextval('db_images_pk_seq'::text) NOT NULL,
38 "group_id" integer DEFAULT '0' NOT NULL,
39 "description" text DEFAULT '' NOT NULL,
40 "bin_data" text DEFAULT '' NOT NULL,
41 "filename" text DEFAULT '' NOT NULL,
42 "filesize" integer DEFAULT '0' NOT NULL,
43 "filetype" text DEFAULT '' NOT NULL,
44 "width" integer DEFAULT '0' NOT NULL,
45 "height" integer DEFAULT '0' NOT NULL,
46 "upload_date" integer,
48 Constraint "db_images_pkey" Primary Key ("id")
52 -- TOC Entry ID 6 (OID 18840)
54 -- Name: doc_data_pk_seq Type: SEQUENCE Owner: tperdue
57 CREATE SEQUENCE "doc_data_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
60 -- TOC Entry ID 178 (OID 18859)
62 -- Name: doc_data Type: TABLE Owner: tperdue
65 CREATE TABLE "doc_data" (
66 "docid" integer DEFAULT nextval('doc_data_pk_seq'::text) NOT NULL,
67 "stateid" integer DEFAULT '0' NOT NULL,
68 "title" character varying(255) DEFAULT '' NOT NULL,
69 "data" text DEFAULT '' NOT NULL,
70 "updatedate" integer DEFAULT '0' NOT NULL,
71 "createdate" integer DEFAULT '0' NOT NULL,
72 "created_by" integer DEFAULT '0' NOT NULL,
73 "doc_group" integer DEFAULT '0' NOT NULL,
75 "language_id" integer DEFAULT '1' NOT NULL,
76 Constraint "doc_data_pkey" Primary Key ("docid")
80 -- TOC Entry ID 8 (OID 18905)
82 -- Name: doc_groups_pk_seq Type: SEQUENCE Owner: tperdue
85 CREATE SEQUENCE "doc_groups_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
88 -- TOC Entry ID 179 (OID 18924)
90 -- Name: doc_groups Type: TABLE Owner: tperdue
93 CREATE TABLE "doc_groups" (
94 "doc_group" integer DEFAULT nextval('doc_groups_pk_seq'::text) NOT NULL,
95 "groupname" character varying(255) DEFAULT '' NOT NULL,
96 "group_id" integer DEFAULT '0' NOT NULL,
97 Constraint "doc_groups_pkey" Primary Key ("doc_group")
101 -- TOC Entry ID 10 (OID 18942)
103 -- Name: doc_states_pk_seq Type: SEQUENCE Owner: tperdue
106 CREATE SEQUENCE "doc_states_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
109 -- TOC Entry ID 180 (OID 18961)
111 -- Name: doc_states Type: TABLE Owner: tperdue
114 CREATE TABLE "doc_states" (
115 "stateid" integer DEFAULT nextval('doc_states_pk_seq'::text) NOT NULL,
116 "name" character varying(255) DEFAULT '' NOT NULL,
117 Constraint "doc_states_pkey" Primary Key ("stateid")
121 -- TOC Entry ID 12 (OID 18977)
123 -- Name: filemodule_monitor_pk_seq Type: SEQUENCE Owner: tperdue
126 CREATE SEQUENCE "filemodule_monitor_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
129 -- TOC Entry ID 181 (OID 18996)
131 -- Name: filemodule_monitor Type: TABLE Owner: tperdue
134 CREATE TABLE "filemodule_monitor" (
135 "id" integer DEFAULT nextval('filemodule_monitor_pk_seq'::text) NOT NULL,
136 "filemodule_id" integer DEFAULT '0' NOT NULL,
137 "user_id" integer DEFAULT '0' NOT NULL,
138 Constraint "filemodule_monitor_pkey" Primary Key ("id")
142 -- TOC Entry ID 14 (OID 19014)
144 -- Name: forum_pk_seq Type: SEQUENCE Owner: tperdue
147 CREATE SEQUENCE "forum_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
150 -- TOC Entry ID 182 (OID 19033)
152 -- Name: forum Type: TABLE Owner: tperdue
155 CREATE TABLE "forum" (
156 "msg_id" integer DEFAULT nextval('forum_pk_seq'::text) NOT NULL,
157 "group_forum_id" integer DEFAULT '0' NOT NULL,
158 "posted_by" integer DEFAULT '0' NOT NULL,
159 "subject" text DEFAULT '' NOT NULL,
160 "body" text DEFAULT '' NOT NULL,
161 "date" integer DEFAULT '0' NOT NULL,
162 "is_followup_to" integer DEFAULT '0' NOT NULL,
163 "thread_id" integer DEFAULT '0' NOT NULL,
164 "has_followups" integer DEFAULT '0',
165 "most_recent_date" integer DEFAULT '0' NOT NULL,
166 Constraint "forum_pkey" Primary Key ("msg_id")
170 -- TOC Entry ID 183 (OID 19080)
172 -- Name: forum_agg_msg_count Type: TABLE Owner: tperdue
175 CREATE TABLE "forum_agg_msg_count" (
176 "group_forum_id" integer DEFAULT '0' NOT NULL,
177 "count" integer DEFAULT '0' NOT NULL,
178 Constraint "forum_agg_msg_count_pkey" Primary Key ("group_forum_id")
182 -- TOC Entry ID 16 (OID 19096)
184 -- Name: forum_group_list_pk_seq Type: SEQUENCE Owner: tperdue
187 CREATE SEQUENCE "forum_group_list_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
190 -- TOC Entry ID 184 (OID 19115)
192 -- Name: forum_group_list Type: TABLE Owner: tperdue
195 CREATE TABLE "forum_group_list" (
196 "group_forum_id" integer DEFAULT nextval('forum_group_list_pk_seq'::text) NOT NULL,
197 "group_id" integer DEFAULT '0' NOT NULL,
198 "forum_name" text DEFAULT '' NOT NULL,
199 "is_public" integer DEFAULT '0' NOT NULL,
201 "allow_anonymous" integer DEFAULT '0' NOT NULL,
202 "send_all_posts_to" text,
203 Constraint "forum_group_list_pkey" Primary Key ("group_forum_id")
207 -- TOC Entry ID 18 (OID 19154)
209 -- Name: forum_monitored_forums_pk_seq Type: SEQUENCE Owner: tperdue
212 CREATE SEQUENCE "forum_monitored_forums_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
215 -- TOC Entry ID 185 (OID 19173)
217 -- Name: forum_monitored_forums Type: TABLE Owner: tperdue
220 CREATE TABLE "forum_monitored_forums" (
221 "monitor_id" integer DEFAULT nextval('forum_monitored_forums_pk_seq'::text) NOT NULL,
222 "forum_id" integer DEFAULT '0' NOT NULL,
223 "user_id" integer DEFAULT '0' NOT NULL,
224 Constraint "forum_monitored_forums_pkey" Primary Key ("monitor_id")
228 -- TOC Entry ID 20 (OID 19191)
230 -- Name: forum_saved_place_pk_seq Type: SEQUENCE Owner: tperdue
233 CREATE SEQUENCE "forum_saved_place_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
236 -- TOC Entry ID 186 (OID 19210)
238 -- Name: forum_saved_place Type: TABLE Owner: tperdue
241 CREATE TABLE "forum_saved_place" (
242 "saved_place_id" integer DEFAULT nextval('forum_saved_place_pk_seq'::text) NOT NULL,
243 "user_id" integer DEFAULT '0' NOT NULL,
244 "forum_id" integer DEFAULT '0' NOT NULL,
245 "save_date" integer DEFAULT '0' NOT NULL,
246 Constraint "forum_saved_place_pkey" Primary Key ("saved_place_id")
250 -- TOC Entry ID 187 (OID 19230)
252 -- Name: foundry_data Type: TABLE Owner: tperdue
255 CREATE TABLE "foundry_data" (
256 "foundry_id" integer DEFAULT '0' NOT NULL,
257 "freeform1_html" text,
258 "freeform2_html" text,
259 "sponsor1_html" text,
260 "sponsor2_html" text,
261 "guide_image_id" integer DEFAULT '0' NOT NULL,
262 "logo_image_id" integer DEFAULT '0' NOT NULL,
263 "trove_categories" text,
264 Constraint "foundry_data_pkey" Primary Key ("foundry_id")
268 -- TOC Entry ID 22 (OID 19268)
270 -- Name: foundry_news_pk_seq Type: SEQUENCE Owner: tperdue
273 CREATE SEQUENCE "foundry_news_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
276 -- TOC Entry ID 188 (OID 19287)
278 -- Name: foundry_news Type: TABLE Owner: tperdue
281 CREATE TABLE "foundry_news" (
282 "foundry_news_id" integer DEFAULT nextval('foundry_news_pk_seq'::text) NOT NULL,
283 "foundry_id" integer DEFAULT '0' NOT NULL,
284 "news_id" integer DEFAULT '0' NOT NULL,
285 "approve_date" integer DEFAULT '0' NOT NULL,
286 "is_approved" integer DEFAULT '0' NOT NULL,
287 Constraint "foundry_news_pkey" Primary Key ("foundry_news_id")
291 -- TOC Entry ID 24 (OID 19309)
293 -- Name: foundry_preferred_projec_pk_seq Type: SEQUENCE Owner: tperdue
296 CREATE SEQUENCE "foundry_preferred_projec_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
299 -- TOC Entry ID 189 (OID 19328)
301 -- Name: foundry_preferred_projects Type: TABLE Owner: tperdue
304 CREATE TABLE "foundry_preferred_projects" (
305 "foundry_project_id" integer DEFAULT nextval('foundry_preferred_projec_pk_seq'::text) NOT NULL,
306 "foundry_id" integer DEFAULT '0' NOT NULL,
307 "group_id" integer DEFAULT '0' NOT NULL,
308 "rank" integer DEFAULT '0' NOT NULL,
309 Constraint "foundry_preferred_projects_pkey" Primary Key ("foundry_project_id")
313 -- TOC Entry ID 26 (OID 19348)
315 -- Name: foundry_projects_pk_seq Type: SEQUENCE Owner: tperdue
318 CREATE SEQUENCE "foundry_projects_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
321 -- TOC Entry ID 190 (OID 19367)
323 -- Name: foundry_projects Type: TABLE Owner: tperdue
326 CREATE TABLE "foundry_projects" (
327 "id" integer DEFAULT nextval('foundry_projects_pk_seq'::text) NOT NULL,
328 "foundry_id" integer DEFAULT '0' NOT NULL,
329 "project_id" integer DEFAULT '0' NOT NULL,
330 Constraint "foundry_projects_pkey" Primary Key ("id")
334 -- TOC Entry ID 28 (OID 19385)
336 -- Name: frs_file_pk_seq Type: SEQUENCE Owner: tperdue
339 CREATE SEQUENCE "frs_file_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
342 -- TOC Entry ID 191 (OID 19404)
344 -- Name: frs_file Type: TABLE Owner: tperdue
347 CREATE TABLE "frs_file" (
348 "file_id" integer DEFAULT nextval('frs_file_pk_seq'::text) NOT NULL,
350 "release_id" integer DEFAULT '0' NOT NULL,
351 "type_id" integer DEFAULT '0' NOT NULL,
352 "processor_id" integer DEFAULT '0' NOT NULL,
353 "release_time" integer DEFAULT '0' NOT NULL,
354 "file_size" integer DEFAULT '0' NOT NULL,
355 "post_date" integer DEFAULT '0' NOT NULL,
356 Constraint "frs_file_pkey" Primary Key ("file_id")
360 -- TOC Entry ID 30 (OID 19446)
362 -- Name: frs_filetype_pk_seq Type: SEQUENCE Owner: tperdue
365 CREATE SEQUENCE "frs_filetype_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
368 -- TOC Entry ID 192 (OID 19465)
370 -- Name: frs_filetype Type: TABLE Owner: tperdue
373 CREATE TABLE "frs_filetype" (
374 "type_id" integer DEFAULT nextval('frs_filetype_pk_seq'::text) NOT NULL,
376 Constraint "frs_filetype_pkey" Primary Key ("type_id")
380 -- TOC Entry ID 32 (OID 19495)
382 -- Name: frs_package_pk_seq Type: SEQUENCE Owner: tperdue
385 CREATE SEQUENCE "frs_package_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
388 -- TOC Entry ID 193 (OID 19514)
390 -- Name: frs_package Type: TABLE Owner: tperdue
393 CREATE TABLE "frs_package" (
394 "package_id" integer DEFAULT nextval('frs_package_pk_seq'::text) NOT NULL,
395 "group_id" integer DEFAULT '0' NOT NULL,
397 "status_id" integer DEFAULT '0' NOT NULL,
398 Constraint "frs_package_pkey" Primary Key ("package_id")
402 -- TOC Entry ID 34 (OID 19548)
404 -- Name: frs_processor_pk_seq Type: SEQUENCE Owner: tperdue
407 CREATE SEQUENCE "frs_processor_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
410 -- TOC Entry ID 194 (OID 19567)
412 -- Name: frs_processor Type: TABLE Owner: tperdue
415 CREATE TABLE "frs_processor" (
416 "processor_id" integer DEFAULT nextval('frs_processor_pk_seq'::text) NOT NULL,
418 Constraint "frs_processor_pkey" Primary Key ("processor_id")
422 -- TOC Entry ID 36 (OID 19597)
424 -- Name: frs_release_pk_seq Type: SEQUENCE Owner: tperdue
427 CREATE SEQUENCE "frs_release_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
430 -- TOC Entry ID 195 (OID 19616)
432 -- Name: frs_release Type: TABLE Owner: tperdue
435 CREATE TABLE "frs_release" (
436 "release_id" integer DEFAULT nextval('frs_release_pk_seq'::text) NOT NULL,
437 "package_id" integer DEFAULT '0' NOT NULL,
441 "status_id" integer DEFAULT '0' NOT NULL,
442 "preformatted" integer DEFAULT '0' NOT NULL,
443 "release_date" integer DEFAULT '0' NOT NULL,
444 "released_by" integer DEFAULT '0' NOT NULL,
445 Constraint "frs_release_pkey" Primary Key ("release_id")
449 -- TOC Entry ID 38 (OID 19658)
451 -- Name: frs_status_pk_seq Type: SEQUENCE Owner: tperdue
454 CREATE SEQUENCE "frs_status_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
457 -- TOC Entry ID 196 (OID 19677)
459 -- Name: frs_status Type: TABLE Owner: tperdue
462 CREATE TABLE "frs_status" (
463 "status_id" integer DEFAULT nextval('frs_status_pk_seq'::text) NOT NULL,
465 Constraint "frs_status_pkey" Primary Key ("status_id")
469 -- TOC Entry ID 40 (OID 19707)
471 -- Name: group_cvs_history_pk_seq Type: SEQUENCE Owner: tperdue
474 CREATE SEQUENCE "group_cvs_history_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
477 -- TOC Entry ID 42 (OID 19726)
479 -- Name: group_history_pk_seq Type: SEQUENCE Owner: tperdue
482 CREATE SEQUENCE "group_history_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
485 -- TOC Entry ID 197 (OID 19745)
487 -- Name: group_history Type: TABLE Owner: tperdue
490 CREATE TABLE "group_history" (
491 "group_history_id" integer DEFAULT nextval('group_history_pk_seq'::text) NOT NULL,
492 "group_id" integer DEFAULT '0' NOT NULL,
493 "field_name" text DEFAULT '' NOT NULL,
494 "old_value" text DEFAULT '' NOT NULL,
495 "mod_by" integer DEFAULT '0' NOT NULL,
497 Constraint "group_history_pkey" Primary Key ("group_history_id")
501 -- TOC Entry ID 44 (OID 19783)
503 -- Name: group_type_pk_seq Type: SEQUENCE Owner: tperdue
506 CREATE SEQUENCE "group_type_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
509 -- TOC Entry ID 198 (OID 19802)
511 -- Name: group_type Type: TABLE Owner: tperdue
514 CREATE TABLE "group_type" (
515 "type_id" integer DEFAULT nextval('group_type_pk_seq'::text) NOT NULL,
517 Constraint "group_type_pkey" Primary Key ("type_id")
521 -- TOC Entry ID 46 (OID 19832)
523 -- Name: groups_pk_seq Type: SEQUENCE Owner: tperdue
526 CREATE SEQUENCE "groups_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
529 -- TOC Entry ID 199 (OID 19851)
531 -- Name: groups Type: TABLE Owner: tperdue
534 CREATE TABLE "groups" (
535 "group_id" integer DEFAULT nextval('groups_pk_seq'::text) NOT NULL,
536 "group_name" character varying(40),
537 "homepage" character varying(128),
538 "is_public" integer DEFAULT '0' NOT NULL,
539 "status" character(1) DEFAULT 'A' NOT NULL,
540 "unix_group_name" character varying(30) DEFAULT '' NOT NULL,
541 "unix_box" character varying(20) DEFAULT 'shell1' NOT NULL,
542 "http_domain" character varying(80),
543 "short_description" character varying(255),
544 "cvs_box" character varying(20) DEFAULT 'cvs1' NOT NULL,
545 "license" character varying(16),
546 "register_purpose" text,
547 "license_other" text,
548 "register_time" integer DEFAULT '0' NOT NULL,
550 "use_mail" integer DEFAULT '1' NOT NULL,
551 "use_survey" integer DEFAULT '1' NOT NULL,
552 "use_forum" integer DEFAULT '1' NOT NULL,
553 "use_pm" integer DEFAULT '1' NOT NULL,
554 "use_cvs" integer DEFAULT '1' NOT NULL,
555 "use_news" integer DEFAULT '1' NOT NULL,
556 "type" integer DEFAULT '1' NOT NULL,
557 "use_docman" integer DEFAULT '1' NOT NULL,
558 "new_task_address" text DEFAULT '' NOT NULL,
559 "send_all_tasks" integer DEFAULT '0' NOT NULL,
560 "use_pm_depend_box" integer DEFAULT '1' NOT NULL,
561 Constraint "groups_pkey" Primary Key ("group_id")
565 -- TOC Entry ID 48 (OID 19977)
567 -- Name: mail_group_list_pk_seq Type: SEQUENCE Owner: tperdue
570 CREATE SEQUENCE "mail_group_list_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
573 -- TOC Entry ID 201 (OID 19996)
575 -- Name: mail_group_list Type: TABLE Owner: tperdue
578 CREATE TABLE "mail_group_list" (
579 "group_list_id" integer DEFAULT nextval('mail_group_list_pk_seq'::text) NOT NULL,
580 "group_id" integer DEFAULT '0' NOT NULL,
582 "is_public" integer DEFAULT '0' NOT NULL,
583 "password" character varying(16),
584 "list_admin" integer DEFAULT '0' NOT NULL,
585 "status" integer DEFAULT '0' NOT NULL,
587 Constraint "mail_group_list_pkey" Primary Key ("group_list_id")
591 -- TOC Entry ID 50 (OID 20036)
593 -- Name: news_bytes_pk_seq Type: SEQUENCE Owner: tperdue
596 CREATE SEQUENCE "news_bytes_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
599 -- TOC Entry ID 202 (OID 20055)
601 -- Name: news_bytes Type: TABLE Owner: tperdue
604 CREATE TABLE "news_bytes" (
605 "id" integer DEFAULT nextval('news_bytes_pk_seq'::text) NOT NULL,
606 "group_id" integer DEFAULT '0' NOT NULL,
607 "submitted_by" integer DEFAULT '0' NOT NULL,
608 "is_approved" integer DEFAULT '0' NOT NULL,
609 "date" integer DEFAULT '0' NOT NULL,
610 "forum_id" integer DEFAULT '0' NOT NULL,
613 Constraint "news_bytes_pkey" Primary Key ("id")
617 -- TOC Entry ID 52 (OID 20096)
619 -- Name: people_job_pk_seq Type: SEQUENCE Owner: tperdue
622 CREATE SEQUENCE "people_job_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
625 -- TOC Entry ID 203 (OID 20115)
627 -- Name: people_job Type: TABLE Owner: tperdue
630 CREATE TABLE "people_job" (
631 "job_id" integer DEFAULT nextval('people_job_pk_seq'::text) NOT NULL,
632 "group_id" integer DEFAULT '0' NOT NULL,
633 "created_by" integer DEFAULT '0' NOT NULL,
636 "date" integer DEFAULT '0' NOT NULL,
637 "status_id" integer DEFAULT '0' NOT NULL,
638 "category_id" integer DEFAULT '0' NOT NULL,
639 Constraint "people_job_pkey" Primary Key ("job_id")
643 -- TOC Entry ID 54 (OID 20156)
645 -- Name: people_job_category_pk_seq Type: SEQUENCE Owner: tperdue
648 CREATE SEQUENCE "people_job_category_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
651 -- TOC Entry ID 204 (OID 20175)
653 -- Name: people_job_category Type: TABLE Owner: tperdue
656 CREATE TABLE "people_job_category" (
657 "category_id" integer DEFAULT nextval('people_job_category_pk_seq'::text) NOT NULL,
659 "private_flag" integer DEFAULT '0' NOT NULL,
660 Constraint "people_job_category_pkey" Primary Key ("category_id")
664 -- TOC Entry ID 56 (OID 20207)
666 -- Name: people_job_inventory_pk_seq Type: SEQUENCE Owner: tperdue
669 CREATE SEQUENCE "people_job_inventory_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
672 -- TOC Entry ID 205 (OID 20226)
674 -- Name: people_job_inventory Type: TABLE Owner: tperdue
677 CREATE TABLE "people_job_inventory" (
678 "job_inventory_id" integer DEFAULT nextval('people_job_inventory_pk_seq'::text) NOT NULL,
679 "job_id" integer DEFAULT '0' NOT NULL,
680 "skill_id" integer DEFAULT '0' NOT NULL,
681 "skill_level_id" integer DEFAULT '0' NOT NULL,
682 "skill_year_id" integer DEFAULT '0' NOT NULL,
683 Constraint "people_job_inventory_pkey" Primary Key ("job_inventory_id")
687 -- TOC Entry ID 58 (OID 20248)
689 -- Name: people_job_status_pk_seq Type: SEQUENCE Owner: tperdue
692 CREATE SEQUENCE "people_job_status_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
695 -- TOC Entry ID 206 (OID 20267)
697 -- Name: people_job_status Type: TABLE Owner: tperdue
700 CREATE TABLE "people_job_status" (
701 "status_id" integer DEFAULT nextval('people_job_status_pk_seq'::text) NOT NULL,
703 Constraint "people_job_status_pkey" Primary Key ("status_id")
707 -- TOC Entry ID 60 (OID 20297)
709 -- Name: people_skill_pk_seq Type: SEQUENCE Owner: tperdue
712 CREATE SEQUENCE "people_skill_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
715 -- TOC Entry ID 207 (OID 20316)
717 -- Name: people_skill Type: TABLE Owner: tperdue
720 CREATE TABLE "people_skill" (
721 "skill_id" integer DEFAULT nextval('people_skill_pk_seq'::text) NOT NULL,
723 Constraint "people_skill_pkey" Primary Key ("skill_id")
727 -- TOC Entry ID 62 (OID 20346)
729 -- Name: people_skill_inventory_pk_seq Type: SEQUENCE Owner: tperdue
732 CREATE SEQUENCE "people_skill_inventory_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
735 -- TOC Entry ID 208 (OID 20365)
737 -- Name: people_skill_inventory Type: TABLE Owner: tperdue
740 CREATE TABLE "people_skill_inventory" (
741 "skill_inventory_id" integer DEFAULT nextval('people_skill_inventory_pk_seq'::text) NOT NULL,
742 "user_id" integer DEFAULT '0' NOT NULL,
743 "skill_id" integer DEFAULT '0' NOT NULL,
744 "skill_level_id" integer DEFAULT '0' NOT NULL,
745 "skill_year_id" integer DEFAULT '0' NOT NULL,
746 Constraint "people_skill_inventory_pkey" Primary Key ("skill_inventory_id")
750 -- TOC Entry ID 64 (OID 20387)
752 -- Name: people_skill_level_pk_seq Type: SEQUENCE Owner: tperdue
755 CREATE SEQUENCE "people_skill_level_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
758 -- TOC Entry ID 209 (OID 20406)
760 -- Name: people_skill_level Type: TABLE Owner: tperdue
763 CREATE TABLE "people_skill_level" (
764 "skill_level_id" integer DEFAULT nextval('people_skill_level_pk_seq'::text) NOT NULL,
766 Constraint "people_skill_level_pkey" Primary Key ("skill_level_id")
770 -- TOC Entry ID 66 (OID 20436)
772 -- Name: people_skill_year_pk_seq Type: SEQUENCE Owner: tperdue
775 CREATE SEQUENCE "people_skill_year_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
778 -- TOC Entry ID 210 (OID 20455)
780 -- Name: people_skill_year Type: TABLE Owner: tperdue
783 CREATE TABLE "people_skill_year" (
784 "skill_year_id" integer DEFAULT nextval('people_skill_year_pk_seq'::text) NOT NULL,
786 Constraint "people_skill_year_pkey" Primary Key ("skill_year_id")
790 -- TOC Entry ID 68 (OID 20485)
792 -- Name: project_assigned_to_pk_seq Type: SEQUENCE Owner: tperdue
795 CREATE SEQUENCE "project_assigned_to_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
798 -- TOC Entry ID 211 (OID 20504)
800 -- Name: project_assigned_to Type: TABLE Owner: tperdue
803 CREATE TABLE "project_assigned_to" (
804 "project_assigned_id" integer DEFAULT nextval('project_assigned_to_pk_seq'::text) NOT NULL,
805 "project_task_id" integer DEFAULT '0' NOT NULL,
806 "assigned_to_id" integer DEFAULT '0' NOT NULL,
807 Constraint "project_assigned_to_pkey" Primary Key ("project_assigned_id")
811 -- TOC Entry ID 70 (OID 20522)
813 -- Name: project_dependencies_pk_seq Type: SEQUENCE Owner: tperdue
816 CREATE SEQUENCE "project_dependencies_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
819 -- TOC Entry ID 212 (OID 20541)
821 -- Name: project_dependencies Type: TABLE Owner: tperdue
824 CREATE TABLE "project_dependencies" (
825 "project_depend_id" integer DEFAULT nextval('project_dependencies_pk_seq'::text) NOT NULL,
826 "project_task_id" integer DEFAULT '0' NOT NULL,
827 "is_dependent_on_task_id" integer DEFAULT '0' NOT NULL,
828 Constraint "project_dependencies_pkey" Primary Key ("project_depend_id")
832 -- TOC Entry ID 72 (OID 20559)
834 -- Name: project_group_list_pk_seq Type: SEQUENCE Owner: tperdue
837 CREATE SEQUENCE "project_group_list_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
840 -- TOC Entry ID 213 (OID 20578)
842 -- Name: project_group_list Type: TABLE Owner: tperdue
845 CREATE TABLE "project_group_list" (
846 "group_project_id" integer DEFAULT nextval('project_group_list_pk_seq'::text) NOT NULL,
847 "group_id" integer DEFAULT '0' NOT NULL,
848 "project_name" text DEFAULT '' NOT NULL,
849 "is_public" integer DEFAULT '0' NOT NULL,
851 Constraint "project_group_list_pkey" Primary Key ("group_project_id")
855 -- TOC Entry ID 74 (OID 20614)
857 -- Name: project_history_pk_seq Type: SEQUENCE Owner: tperdue
860 CREATE SEQUENCE "project_history_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
863 -- TOC Entry ID 214 (OID 20633)
865 -- Name: project_history Type: TABLE Owner: tperdue
868 CREATE TABLE "project_history" (
869 "project_history_id" integer DEFAULT nextval('project_history_pk_seq'::text) NOT NULL,
870 "project_task_id" integer DEFAULT '0' NOT NULL,
871 "field_name" text DEFAULT '' NOT NULL,
872 "old_value" text DEFAULT '' NOT NULL,
873 "mod_by" integer DEFAULT '0' NOT NULL,
874 "date" integer DEFAULT '0' NOT NULL,
875 Constraint "project_history_pkey" Primary Key ("project_history_id")
879 -- TOC Entry ID 76 (OID 20672)
881 -- Name: project_metric_pk_seq Type: SEQUENCE Owner: tperdue
884 CREATE SEQUENCE "project_metric_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
887 -- TOC Entry ID 215 (OID 20691)
889 -- Name: project_metric Type: TABLE Owner: tperdue
892 CREATE TABLE "project_metric" (
893 "ranking" integer DEFAULT nextval('project_metric_pk_seq'::text) NOT NULL,
894 "percentile" double precision,
895 "group_id" integer DEFAULT '0' NOT NULL,
896 Constraint "project_metric_pkey" Primary Key ("ranking")
900 -- TOC Entry ID 78 (OID 20708)
902 -- Name: project_metric_tmp1_pk_seq Type: SEQUENCE Owner: tperdue
905 CREATE SEQUENCE "project_metric_tmp1_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
908 -- TOC Entry ID 216 (OID 20727)
910 -- Name: project_metric_tmp1 Type: TABLE Owner: tperdue
913 CREATE TABLE "project_metric_tmp1" (
914 "ranking" integer DEFAULT nextval('project_metric_tmp1_pk_seq'::text) NOT NULL,
915 "group_id" integer DEFAULT '0' NOT NULL,
916 "value" double precision,
917 Constraint "project_metric_tmp1_pkey" Primary Key ("ranking")
921 -- TOC Entry ID 80 (OID 20744)
923 -- Name: project_metric_weekly_tm_pk_seq Type: SEQUENCE Owner: tperdue
926 CREATE SEQUENCE "project_metric_weekly_tm_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
929 -- TOC Entry ID 82 (OID 20763)
931 -- Name: project_status_pk_seq Type: SEQUENCE Owner: tperdue
934 CREATE SEQUENCE "project_status_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
937 -- TOC Entry ID 217 (OID 20782)
939 -- Name: project_status Type: TABLE Owner: tperdue
942 CREATE TABLE "project_status" (
943 "status_id" integer DEFAULT nextval('project_status_pk_seq'::text) NOT NULL,
944 "status_name" text DEFAULT '' NOT NULL,
945 Constraint "project_status_pkey" Primary Key ("status_id")
949 -- TOC Entry ID 84 (OID 20813)
951 -- Name: project_task_pk_seq Type: SEQUENCE Owner: tperdue
954 CREATE SEQUENCE "project_task_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
957 -- TOC Entry ID 218 (OID 20832)
959 -- Name: project_task Type: TABLE Owner: tperdue
962 CREATE TABLE "project_task" (
963 "project_task_id" integer DEFAULT nextval('project_task_pk_seq'::text) NOT NULL,
964 "group_project_id" integer DEFAULT '0' NOT NULL,
965 "summary" text DEFAULT '' NOT NULL,
966 "details" text DEFAULT '' NOT NULL,
967 "percent_complete" integer DEFAULT '0' NOT NULL,
968 "priority" integer DEFAULT '0' NOT NULL,
969 "hours" double precision DEFAULT '0.00' NOT NULL,
970 "start_date" integer DEFAULT '0' NOT NULL,
971 "end_date" integer DEFAULT '0' NOT NULL,
972 "created_by" integer DEFAULT '0' NOT NULL,
973 "status_id" integer DEFAULT '0' NOT NULL,
974 Constraint "project_task_pkey" Primary Key ("project_task_id")
978 -- TOC Entry ID 86 (OID 20881)
980 -- Name: project_weekly_metric_pk_seq Type: SEQUENCE Owner: tperdue
983 CREATE SEQUENCE "project_weekly_metric_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
986 -- TOC Entry ID 219 (OID 20900)
988 -- Name: project_weekly_metric Type: TABLE Owner: tperdue
991 CREATE TABLE "project_weekly_metric" (
992 "ranking" integer DEFAULT nextval('project_weekly_metric_pk_seq'::text) NOT NULL,
993 "percentile" double precision,
994 "group_id" integer DEFAULT '0' NOT NULL
998 -- TOC Entry ID 220 (OID 20914)
1000 -- Name: session Type: TABLE Owner: tperdue
1003 CREATE TABLE "session" (
1004 "user_id" integer DEFAULT '0' NOT NULL,
1005 "session_hash" character(32) DEFAULT '' NOT NULL,
1006 "ip_addr" character(15) DEFAULT '' NOT NULL,
1007 "time" integer DEFAULT '0' NOT NULL,
1008 Constraint "session_pkey" Primary Key ("session_hash")
1012 -- TOC Entry ID 88 (OID 20934)
1014 -- Name: snippet_pk_seq Type: SEQUENCE Owner: tperdue
1017 CREATE SEQUENCE "snippet_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1020 -- TOC Entry ID 221 (OID 20953)
1022 -- Name: snippet Type: TABLE Owner: tperdue
1025 CREATE TABLE "snippet" (
1026 "snippet_id" integer DEFAULT nextval('snippet_pk_seq'::text) NOT NULL,
1027 "created_by" integer DEFAULT '0' NOT NULL,
1030 "type" integer DEFAULT '0' NOT NULL,
1031 "language" integer DEFAULT '0' NOT NULL,
1032 "license" text DEFAULT '' NOT NULL,
1033 "category" integer DEFAULT '0' NOT NULL,
1034 Constraint "snippet_pkey" Primary Key ("snippet_id")
1038 -- TOC Entry ID 90 (OID 20994)
1040 -- Name: snippet_package_pk_seq Type: SEQUENCE Owner: tperdue
1043 CREATE SEQUENCE "snippet_package_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1046 -- TOC Entry ID 222 (OID 21013)
1048 -- Name: snippet_package Type: TABLE Owner: tperdue
1051 CREATE TABLE "snippet_package" (
1052 "snippet_package_id" integer DEFAULT nextval('snippet_package_pk_seq'::text) NOT NULL,
1053 "created_by" integer DEFAULT '0' NOT NULL,
1056 "category" integer DEFAULT '0' NOT NULL,
1057 "language" integer DEFAULT '0' NOT NULL,
1058 Constraint "snippet_package_pkey" Primary Key ("snippet_package_id")
1062 -- TOC Entry ID 92 (OID 21050)
1064 -- Name: snippet_package_item_pk_seq Type: SEQUENCE Owner: tperdue
1067 CREATE SEQUENCE "snippet_package_item_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1070 -- TOC Entry ID 223 (OID 21069)
1072 -- Name: snippet_package_item Type: TABLE Owner: tperdue
1075 CREATE TABLE "snippet_package_item" (
1076 "snippet_package_item_id" integer DEFAULT nextval('snippet_package_item_pk_seq'::text) NOT NULL,
1077 "snippet_package_version_id" integer DEFAULT '0' NOT NULL,
1078 "snippet_version_id" integer DEFAULT '0' NOT NULL,
1079 Constraint "snippet_package_item_pkey" Primary Key ("snippet_package_item_id")
1083 -- TOC Entry ID 94 (OID 21087)
1085 -- Name: snippet_package_version_pk_seq Type: SEQUENCE Owner: tperdue
1088 CREATE SEQUENCE "snippet_package_version_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1091 -- TOC Entry ID 224 (OID 21106)
1093 -- Name: snippet_package_version Type: TABLE Owner: tperdue
1096 CREATE TABLE "snippet_package_version" (
1097 "snippet_package_version_id" integer DEFAULT nextval('snippet_package_version_pk_seq'::text) NOT NULL,
1098 "snippet_package_id" integer DEFAULT '0' NOT NULL,
1101 "submitted_by" integer DEFAULT '0' NOT NULL,
1102 "date" integer DEFAULT '0' NOT NULL,
1103 Constraint "snippet_package_version_pkey" Primary Key ("snippet_package_version_id")
1107 -- TOC Entry ID 96 (OID 21143)
1109 -- Name: snippet_version_pk_seq Type: SEQUENCE Owner: tperdue
1112 CREATE SEQUENCE "snippet_version_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1115 -- TOC Entry ID 225 (OID 21162)
1117 -- Name: snippet_version Type: TABLE Owner: tperdue
1120 CREATE TABLE "snippet_version" (
1121 "snippet_version_id" integer DEFAULT nextval('snippet_version_pk_seq'::text) NOT NULL,
1122 "snippet_id" integer DEFAULT '0' NOT NULL,
1125 "submitted_by" integer DEFAULT '0' NOT NULL,
1126 "date" integer DEFAULT '0' NOT NULL,
1128 Constraint "snippet_version_pkey" Primary Key ("snippet_version_id")
1132 -- TOC Entry ID 226 (OID 21200)
1134 -- Name: stats_agg_logo_by_day Type: TABLE Owner: tperdue
1137 CREATE TABLE "stats_agg_logo_by_day" (
1143 -- TOC Entry ID 227 (OID 21211)
1145 -- Name: stats_agg_pages_by_day Type: TABLE Owner: tperdue
1148 CREATE TABLE "stats_agg_pages_by_day" (
1149 "day" integer DEFAULT '0' NOT NULL,
1150 "count" integer DEFAULT '0' NOT NULL
1154 -- TOC Entry ID 228 (OID 21224)
1156 -- Name: stats_ftp_downloads Type: TABLE Owner: tperdue
1159 CREATE TABLE "stats_ftp_downloads" (
1160 "day" integer DEFAULT '0' NOT NULL,
1161 "filerelease_id" integer DEFAULT '0' NOT NULL,
1162 "group_id" integer DEFAULT '0' NOT NULL,
1163 "downloads" integer DEFAULT '0' NOT NULL
1167 -- TOC Entry ID 229 (OID 21241)
1169 -- Name: stats_http_downloads Type: TABLE Owner: tperdue
1172 CREATE TABLE "stats_http_downloads" (
1173 "day" integer DEFAULT '0' NOT NULL,
1174 "filerelease_id" integer DEFAULT '0' NOT NULL,
1175 "group_id" integer DEFAULT '0' NOT NULL,
1176 "downloads" integer DEFAULT '0' NOT NULL
1180 -- TOC Entry ID 98 (OID 21258)
1182 -- Name: supported_languages_pk_seq Type: SEQUENCE Owner: tperdue
1185 CREATE SEQUENCE "supported_languages_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1188 -- TOC Entry ID 230 (OID 21277)
1190 -- Name: supported_languages Type: TABLE Owner: tperdue
1193 CREATE TABLE "supported_languages" (
1194 "language_id" integer DEFAULT nextval('supported_languages_pk_seq'::text) NOT NULL,
1198 "language_code" character(2),
1199 Constraint "supported_languages_pkey" Primary Key ("language_id")
1203 -- TOC Entry ID 100 (OID 21310)
1205 -- Name: survey_question_types_pk_seq Type: SEQUENCE Owner: tperdue
1208 CREATE SEQUENCE "survey_question_types_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1211 -- TOC Entry ID 231 (OID 21329)
1213 -- Name: survey_question_types Type: TABLE Owner: tperdue
1216 CREATE TABLE "survey_question_types" (
1217 "id" integer DEFAULT nextval('survey_question_types_pk_seq'::text) NOT NULL,
1218 "type" text DEFAULT '' NOT NULL,
1219 Constraint "survey_question_types_pkey" Primary Key ("id")
1223 -- TOC Entry ID 102 (OID 21360)
1225 -- Name: survey_questions_pk_seq Type: SEQUENCE Owner: tperdue
1228 CREATE SEQUENCE "survey_questions_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1231 -- TOC Entry ID 232 (OID 21379)
1233 -- Name: survey_questions Type: TABLE Owner: tperdue
1236 CREATE TABLE "survey_questions" (
1237 "question_id" integer DEFAULT nextval('survey_questions_pk_seq'::text) NOT NULL,
1238 "group_id" integer DEFAULT '0' NOT NULL,
1239 "question" text DEFAULT '' NOT NULL,
1240 "question_type" integer DEFAULT '0' NOT NULL,
1241 Constraint "survey_questions_pkey" Primary Key ("question_id")
1245 -- TOC Entry ID 233 (OID 21414)
1247 -- Name: survey_rating_aggregate Type: TABLE Owner: tperdue
1250 CREATE TABLE "survey_rating_aggregate" (
1251 "type" integer DEFAULT '0' NOT NULL,
1252 "id" integer DEFAULT '0' NOT NULL,
1253 "response" double precision DEFAULT '0' NOT NULL,
1254 "count" integer DEFAULT '0' NOT NULL
1258 -- TOC Entry ID 234 (OID 21431)
1260 -- Name: survey_rating_response Type: TABLE Owner: tperdue
1263 CREATE TABLE "survey_rating_response" (
1264 "user_id" integer DEFAULT '0' NOT NULL,
1265 "type" integer DEFAULT '0' NOT NULL,
1266 "id" integer DEFAULT '0' NOT NULL,
1267 "response" integer DEFAULT '0' NOT NULL,
1268 "date" integer DEFAULT '0' NOT NULL
1272 -- TOC Entry ID 235 (OID 21450)
1274 -- Name: survey_responses Type: TABLE Owner: tperdue
1277 CREATE TABLE "survey_responses" (
1278 "user_id" integer DEFAULT '0' NOT NULL,
1279 "group_id" integer DEFAULT '0' NOT NULL,
1280 "survey_id" integer DEFAULT '0' NOT NULL,
1281 "question_id" integer DEFAULT '0' NOT NULL,
1282 "response" text DEFAULT '' NOT NULL,
1283 "date" integer DEFAULT '0' NOT NULL
1287 -- TOC Entry ID 104 (OID 21486)
1289 -- Name: surveys_pk_seq Type: SEQUENCE Owner: tperdue
1292 CREATE SEQUENCE "surveys_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1295 -- TOC Entry ID 236 (OID 21505)
1297 -- Name: surveys Type: TABLE Owner: tperdue
1300 CREATE TABLE "surveys" (
1301 "survey_id" integer DEFAULT nextval('surveys_pk_seq'::text) NOT NULL,
1302 "group_id" integer DEFAULT '0' NOT NULL,
1303 "survey_title" text DEFAULT '' NOT NULL,
1304 "survey_questions" text DEFAULT '' NOT NULL,
1305 "is_active" integer DEFAULT '1' NOT NULL,
1306 Constraint "surveys_pkey" Primary Key ("survey_id")
1310 -- TOC Entry ID 106 (OID 21542)
1312 -- Name: system_history_pk_seq Type: SEQUENCE Owner: tperdue
1315 CREATE SEQUENCE "system_history_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1318 -- TOC Entry ID 108 (OID 21561)
1320 -- Name: system_machines_pk_seq Type: SEQUENCE Owner: tperdue
1323 CREATE SEQUENCE "system_machines_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1326 -- TOC Entry ID 110 (OID 21580)
1328 -- Name: system_news_pk_seq Type: SEQUENCE Owner: tperdue
1331 CREATE SEQUENCE "system_news_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1334 -- TOC Entry ID 112 (OID 21599)
1336 -- Name: system_services_pk_seq Type: SEQUENCE Owner: tperdue
1339 CREATE SEQUENCE "system_services_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1342 -- TOC Entry ID 114 (OID 21618)
1344 -- Name: system_status_pk_seq Type: SEQUENCE Owner: tperdue
1347 CREATE SEQUENCE "system_status_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1350 -- TOC Entry ID 237 (OID 21637)
1352 -- Name: theme_prefs Type: TABLE Owner: tperdue
1355 CREATE TABLE "theme_prefs" (
1356 "user_id" integer DEFAULT '0' NOT NULL,
1357 "user_theme" integer DEFAULT '0' NOT NULL,
1358 "body_font" character(80) DEFAULT '',
1359 "body_size" character(5) DEFAULT '',
1360 "titlebar_font" character(80) DEFAULT '',
1361 "titlebar_size" character(5) DEFAULT '',
1362 "color_titlebar_back" character(7) DEFAULT '',
1363 "color_ltback1" character(7) DEFAULT '',
1364 Constraint "theme_prefs_pkey" Primary Key ("user_id")
1368 -- TOC Entry ID 116 (OID 21665)
1370 -- Name: themes_pk_seq Type: SEQUENCE Owner: tperdue
1373 CREATE SEQUENCE "themes_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1376 -- TOC Entry ID 238 (OID 21684)
1378 -- Name: themes Type: TABLE Owner: tperdue
1381 CREATE TABLE "themes" (
1382 "theme_id" integer DEFAULT nextval('themes_pk_seq'::text) NOT NULL,
1383 "dirname" character varying(80),
1384 "fullname" character varying(80),
1385 Constraint "themes_pkey" Primary Key ("theme_id")
1389 -- TOC Entry ID 239 (OID 21700)
1391 -- Name: top_group Type: TABLE Owner: tperdue
1394 CREATE TABLE "top_group" (
1395 "group_id" integer DEFAULT '0' NOT NULL,
1396 "group_name" character varying(40),
1397 "downloads_all" integer DEFAULT '0' NOT NULL,
1398 "rank_downloads_all" integer DEFAULT '0' NOT NULL,
1399 "rank_downloads_all_old" integer DEFAULT '0' NOT NULL,
1400 "downloads_week" integer DEFAULT '0' NOT NULL,
1401 "rank_downloads_week" integer DEFAULT '0' NOT NULL,
1402 "rank_downloads_week_old" integer DEFAULT '0' NOT NULL,
1403 "userrank" integer DEFAULT '0' NOT NULL,
1404 "rank_userrank" integer DEFAULT '0' NOT NULL,
1405 "rank_userrank_old" integer DEFAULT '0' NOT NULL,
1406 "forumposts_week" integer DEFAULT '0' NOT NULL,
1407 "rank_forumposts_week" integer DEFAULT '0' NOT NULL,
1408 "rank_forumposts_week_old" integer DEFAULT '0' NOT NULL,
1409 "pageviews_proj" integer DEFAULT '0' NOT NULL,
1410 "rank_pageviews_proj" integer DEFAULT '0' NOT NULL,
1411 "rank_pageviews_proj_old" integer DEFAULT '0' NOT NULL
1415 -- TOC Entry ID 118 (OID 21742)
1417 -- Name: trove_cat_pk_seq Type: SEQUENCE Owner: tperdue
1420 CREATE SEQUENCE "trove_cat_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1423 -- TOC Entry ID 240 (OID 21761)
1425 -- Name: trove_cat Type: TABLE Owner: tperdue
1428 CREATE TABLE "trove_cat" (
1429 "trove_cat_id" integer DEFAULT nextval('trove_cat_pk_seq'::text) NOT NULL,
1430 "version" integer DEFAULT '0' NOT NULL,
1431 "parent" integer DEFAULT '0' NOT NULL,
1432 "root_parent" integer DEFAULT '0' NOT NULL,
1433 "shortname" character varying(80),
1434 "fullname" character varying(80),
1435 "description" character varying(255),
1436 "count_subcat" integer DEFAULT '0' NOT NULL,
1437 "count_subproj" integer DEFAULT '0' NOT NULL,
1438 "fullpath" text DEFAULT '' NOT NULL,
1439 "fullpath_ids" text,
1440 Constraint "trove_cat_pkey" Primary Key ("trove_cat_id")
1444 -- TOC Entry ID 120 (OID 21806)
1446 -- Name: trove_group_link_pk_seq Type: SEQUENCE Owner: tperdue
1449 CREATE SEQUENCE "trove_group_link_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1452 -- TOC Entry ID 241 (OID 21825)
1454 -- Name: trove_group_link Type: TABLE Owner: tperdue
1457 CREATE TABLE "trove_group_link" (
1458 "trove_group_id" integer DEFAULT nextval('trove_group_link_pk_seq'::text) NOT NULL,
1459 "trove_cat_id" integer DEFAULT '0' NOT NULL,
1460 "trove_cat_version" integer DEFAULT '0' NOT NULL,
1461 "group_id" integer DEFAULT '0' NOT NULL,
1462 "trove_cat_root" integer DEFAULT '0' NOT NULL,
1463 Constraint "trove_group_link_pkey" Primary Key ("trove_group_id")
1467 -- TOC Entry ID 122 (OID 21847)
1469 -- Name: trove_treesums_pk_seq Type: SEQUENCE Owner: tperdue
1472 CREATE SEQUENCE "trove_treesums_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1475 -- TOC Entry ID 124 (OID 21866)
1477 -- Name: user_bookmarks_pk_seq Type: SEQUENCE Owner: tperdue
1480 CREATE SEQUENCE "user_bookmarks_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1483 -- TOC Entry ID 242 (OID 21885)
1485 -- Name: user_bookmarks Type: TABLE Owner: tperdue
1488 CREATE TABLE "user_bookmarks" (
1489 "bookmark_id" integer DEFAULT nextval('user_bookmarks_pk_seq'::text) NOT NULL,
1490 "user_id" integer DEFAULT '0' NOT NULL,
1491 "bookmark_url" text,
1492 "bookmark_title" text,
1493 Constraint "user_bookmarks_pkey" Primary Key ("bookmark_id")
1497 -- TOC Entry ID 126 (OID 21918)
1499 -- Name: user_diary_pk_seq Type: SEQUENCE Owner: tperdue
1502 CREATE SEQUENCE "user_diary_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1505 -- TOC Entry ID 243 (OID 21937)
1507 -- Name: user_diary Type: TABLE Owner: tperdue
1510 CREATE TABLE "user_diary" (
1511 "id" integer DEFAULT nextval('user_diary_pk_seq'::text) NOT NULL,
1512 "user_id" integer DEFAULT '0' NOT NULL,
1513 "date_posted" integer DEFAULT '0' NOT NULL,
1516 "is_public" integer DEFAULT '0' NOT NULL,
1517 Constraint "user_diary_pkey" Primary Key ("id")
1521 -- TOC Entry ID 128 (OID 21974)
1523 -- Name: user_diary_monitor_pk_seq Type: SEQUENCE Owner: tperdue
1526 CREATE SEQUENCE "user_diary_monitor_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1529 -- TOC Entry ID 244 (OID 21993)
1531 -- Name: user_diary_monitor Type: TABLE Owner: tperdue
1534 CREATE TABLE "user_diary_monitor" (
1535 "monitor_id" integer DEFAULT nextval('user_diary_monitor_pk_seq'::text) NOT NULL,
1536 "monitored_user" integer DEFAULT '0' NOT NULL,
1537 "user_id" integer DEFAULT '0' NOT NULL,
1538 Constraint "user_diary_monitor_pkey" Primary Key ("monitor_id")
1542 -- TOC Entry ID 130 (OID 22011)
1544 -- Name: user_group_pk_seq Type: SEQUENCE Owner: tperdue
1547 CREATE SEQUENCE "user_group_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1550 -- TOC Entry ID 245 (OID 22030)
1552 -- Name: user_group Type: TABLE Owner: tperdue
1555 CREATE TABLE "user_group" (
1556 "user_group_id" integer DEFAULT nextval('user_group_pk_seq'::text) NOT NULL,
1557 "user_id" integer DEFAULT '0' NOT NULL,
1558 "group_id" integer DEFAULT '0' NOT NULL,
1559 "admin_flags" character(16) DEFAULT '' NOT NULL,
1560 "bug_flags" integer DEFAULT '0' NOT NULL,
1561 "forum_flags" integer DEFAULT '0' NOT NULL,
1562 "project_flags" integer DEFAULT '2' NOT NULL,
1563 "patch_flags" integer DEFAULT '1' NOT NULL,
1564 "support_flags" integer DEFAULT '1' NOT NULL,
1565 "doc_flags" integer DEFAULT '0' NOT NULL,
1566 "cvs_flags" integer DEFAULT '1' NOT NULL,
1567 "member_role" integer DEFAULT '100' NOT NULL,
1568 "release_flags" integer DEFAULT '0' NOT NULL,
1569 "artifact_flags" integer,
1570 Constraint "user_group_pkey" Primary Key ("user_group_id")
1574 -- TOC Entry ID 132 (OID 22069)
1576 -- Name: user_metric_pk_seq Type: SEQUENCE Owner: tperdue
1579 CREATE SEQUENCE "user_metric_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1582 -- TOC Entry ID 246 (OID 22088)
1584 -- Name: user_metric Type: TABLE Owner: tperdue
1587 CREATE TABLE "user_metric" (
1588 "ranking" integer DEFAULT nextval('user_metric_pk_seq'::text) NOT NULL,
1589 "user_id" integer DEFAULT '0' NOT NULL,
1590 "times_ranked" integer DEFAULT '0' NOT NULL,
1591 "avg_raters_importance" double precision DEFAULT '0.00000000' NOT NULL,
1592 "avg_rating" double precision DEFAULT '0.00000000' NOT NULL,
1593 "metric" double precision DEFAULT '0.00000000' NOT NULL,
1594 "percentile" double precision DEFAULT '0.00000000' NOT NULL,
1595 "importance_factor" double precision DEFAULT '0.00000000' NOT NULL,
1596 Constraint "user_metric_pkey" Primary Key ("ranking")
1600 -- TOC Entry ID 134 (OID 22116)
1602 -- Name: user_metric0_pk_seq Type: SEQUENCE Owner: tperdue
1605 CREATE SEQUENCE "user_metric0_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1608 -- TOC Entry ID 247 (OID 22135)
1610 -- Name: user_metric0 Type: TABLE Owner: tperdue
1613 CREATE TABLE "user_metric0" (
1614 "ranking" integer DEFAULT nextval('user_metric0_pk_seq'::text) NOT NULL,
1615 "user_id" integer DEFAULT '0' NOT NULL,
1616 "times_ranked" integer DEFAULT '0' NOT NULL,
1617 "avg_raters_importance" double precision DEFAULT '0.00000000' NOT NULL,
1618 "avg_rating" double precision DEFAULT '0.00000000' NOT NULL,
1619 "metric" double precision DEFAULT '0.00000000' NOT NULL,
1620 "percentile" double precision DEFAULT '0.00000000' NOT NULL,
1621 "importance_factor" double precision DEFAULT '0.00000000' NOT NULL,
1622 Constraint "user_metric0_pkey" Primary Key ("ranking")
1626 -- TOC Entry ID 248 (OID 22163)
1628 -- Name: user_preferences Type: TABLE Owner: tperdue
1631 CREATE TABLE "user_preferences" (
1632 "user_id" integer DEFAULT '0' NOT NULL,
1633 "preference_name" character varying(20),
1634 "dead1" character varying(20),
1635 "set_date" integer DEFAULT '0' NOT NULL,
1636 "preference_value" text
1640 -- TOC Entry ID 249 (OID 22194)
1642 -- Name: user_ratings Type: TABLE Owner: tperdue
1645 CREATE TABLE "user_ratings" (
1646 "rated_by" integer DEFAULT '0' NOT NULL,
1647 "user_id" integer DEFAULT '0' NOT NULL,
1648 "rate_field" integer DEFAULT '0' NOT NULL,
1649 "rating" integer DEFAULT '0' NOT NULL
1653 -- TOC Entry ID 136 (OID 22211)
1655 -- Name: users_pk_seq Type: SEQUENCE Owner: tperdue
1658 CREATE SEQUENCE "users_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1661 -- TOC Entry ID 250 (OID 22230)
1663 -- Name: users Type: TABLE Owner: tperdue
1666 CREATE TABLE "users" (
1667 "user_id" integer DEFAULT nextval('users_pk_seq'::text) NOT NULL,
1668 "user_name" text DEFAULT '' NOT NULL,
1669 "email" text DEFAULT '' NOT NULL,
1670 "user_pw" character varying(32) DEFAULT '' NOT NULL,
1671 "realname" character varying(32) DEFAULT '' NOT NULL,
1672 "status" character(1) DEFAULT 'A' NOT NULL,
1673 "shell" character varying(20) DEFAULT '/bin/bash' NOT NULL,
1674 "unix_pw" character varying(40) DEFAULT '' NOT NULL,
1675 "unix_status" character(1) DEFAULT 'N' NOT NULL,
1676 "unix_uid" integer DEFAULT '0' NOT NULL,
1677 "unix_box" character varying(10) DEFAULT 'shell1' NOT NULL,
1678 "add_date" integer DEFAULT '0' NOT NULL,
1679 "confirm_hash" character varying(32),
1680 "mail_siteupdates" integer DEFAULT '0' NOT NULL,
1681 "mail_va" integer DEFAULT '0' NOT NULL,
1682 "authorized_keys" text,
1684 "people_view_skills" integer DEFAULT '0' NOT NULL,
1685 "people_resume" text DEFAULT '' NOT NULL,
1686 "timezone" character varying(64) DEFAULT 'GMT',
1687 "language" integer DEFAULT '1' NOT NULL,
1688 "block_ratings" integer DEFAULT 0,
1689 Constraint "users_pkey" Primary Key ("user_id")
1693 -- TOC Entry ID 138 (OID 22298)
1695 -- Name: unix_uid_seq Type: SEQUENCE Owner: tperdue
1698 CREATE SEQUENCE "unix_uid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1701 -- TOC Entry ID 140 (OID 22317)
1703 -- Name: forum_thread_seq Type: SEQUENCE Owner: tperdue
1706 CREATE SEQUENCE "forum_thread_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1709 -- TOC Entry ID 251 (OID 22336)
1711 -- Name: project_sums_agg Type: TABLE Owner: tperdue
1714 CREATE TABLE "project_sums_agg" (
1715 "group_id" integer DEFAULT 0 NOT NULL,
1716 "type" character(4),
1717 "count" integer DEFAULT 0 NOT NULL
1721 -- TOC Entry ID 142 (OID 22350)
1723 -- Name: project_metric_wee_ranking1_seq Type: SEQUENCE Owner: tperdue
1726 CREATE SEQUENCE "project_metric_wee_ranking1_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1729 -- TOC Entry ID 144 (OID 22369)
1731 -- Name: prdb_dbs_dbid_seq Type: SEQUENCE Owner: tperdue
1734 CREATE SEQUENCE "prdb_dbs_dbid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1737 -- TOC Entry ID 252 (OID 22388)
1739 -- Name: prdb_dbs Type: TABLE Owner: tperdue
1742 CREATE TABLE "prdb_dbs" (
1743 "dbid" integer DEFAULT nextval('"prdb_dbs_dbid_seq"'::text) NOT NULL,
1744 "group_id" integer NOT NULL,
1745 "dbname" text NOT NULL,
1746 "dbusername" text NOT NULL,
1747 "dbuserpass" text NOT NULL,
1748 "requestdate" integer NOT NULL,
1749 "dbtype" integer NOT NULL,
1750 "created_by" integer NOT NULL,
1751 "state" integer NOT NULL,
1752 Constraint "prdb_dbs_pkey" Primary Key ("dbid")
1756 -- TOC Entry ID 253 (OID 22425)
1758 -- Name: prdb_states Type: TABLE Owner: tperdue
1761 CREATE TABLE "prdb_states" (
1762 "stateid" integer NOT NULL,
1767 -- TOC Entry ID 254 (OID 22451)
1769 -- Name: prdb_types Type: TABLE Owner: tperdue
1772 CREATE TABLE "prdb_types" (
1773 "dbtypeid" integer NOT NULL,
1774 "dbservername" text NOT NULL,
1775 "dbsoftware" text NOT NULL,
1776 Constraint "prdb_types_pkey" Primary Key ("dbtypeid")
1780 -- TOC Entry ID 146 (OID 22481)
1782 -- Name: prweb_vhost_vhostid_seq Type: SEQUENCE Owner: tperdue
1785 CREATE SEQUENCE "prweb_vhost_vhostid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1788 -- TOC Entry ID 255 (OID 22500)
1790 -- Name: prweb_vhost Type: TABLE Owner: tperdue
1793 CREATE TABLE "prweb_vhost" (
1794 "vhostid" integer DEFAULT nextval('"prweb_vhost_vhostid_seq"'::text) NOT NULL,
1798 "group_id" integer NOT NULL,
1799 Constraint "prweb_vhost_pkey" Primary Key ("vhostid")
1803 -- TOC Entry ID 148 (OID 22533)
1805 -- Name: artifact_grou_group_artifac_seq Type: SEQUENCE Owner: tperdue
1808 CREATE SEQUENCE "artifact_grou_group_artifac_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1811 -- TOC Entry ID 256 (OID 22552)
1813 -- Name: artifact_group_list Type: TABLE Owner: tperdue
1816 CREATE TABLE "artifact_group_list" (
1817 "group_artifact_id" integer DEFAULT nextval('"artifact_grou_group_artifac_seq"'::text) NOT NULL,
1818 "group_id" integer NOT NULL,
1821 "is_public" integer DEFAULT 0 NOT NULL,
1822 "allow_anon" integer DEFAULT 0 NOT NULL,
1823 "email_all_updates" integer DEFAULT 0 NOT NULL,
1824 "email_address" text NOT NULL,
1825 "due_period" integer DEFAULT 2592000 NOT NULL,
1826 "use_resolution" integer DEFAULT 0 NOT NULL,
1827 "submit_instructions" text,
1828 "browse_instructions" text,
1829 "datatype" integer DEFAULT 0 NOT NULL,
1830 "status_timeout" integer,
1831 Constraint "artifact_group_list_pkey" Primary Key ("group_artifact_id")
1835 -- TOC Entry ID 150 (OID 22600)
1837 -- Name: artifact_resolution_id_seq Type: SEQUENCE Owner: tperdue
1840 CREATE SEQUENCE "artifact_resolution_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1843 -- TOC Entry ID 257 (OID 22619)
1845 -- Name: artifact_resolution Type: TABLE Owner: tperdue
1848 CREATE TABLE "artifact_resolution" (
1849 "id" integer DEFAULT nextval('"artifact_resolution_id_seq"'::text) NOT NULL,
1850 "resolution_name" text,
1851 Constraint "artifact_resolution_pkey" Primary Key ("id")
1855 -- TOC Entry ID 152 (OID 22649)
1857 -- Name: artifact_perm_id_seq Type: SEQUENCE Owner: tperdue
1860 CREATE SEQUENCE "artifact_perm_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1863 -- TOC Entry ID 258 (OID 22668)
1865 -- Name: artifact_perm Type: TABLE Owner: tperdue
1868 CREATE TABLE "artifact_perm" (
1869 "id" integer DEFAULT nextval('"artifact_perm_id_seq"'::text) NOT NULL,
1870 "group_artifact_id" integer NOT NULL,
1871 "user_id" integer NOT NULL,
1872 "perm_level" integer DEFAULT 0 NOT NULL,
1873 Constraint "artifact_perm_pkey" Primary Key ("id")
1877 -- TOC Entry ID 259 (OID 22701)
1879 -- Name: artifactperm_user_vw Type: VIEW Owner: tperdue
1882 CREATE VIEW "artifactperm_user_vw" as SELECT ap.id, ap.group_artifact_id, ap.user_id, ap.perm_level, users.user_name, users.realname FROM artifact_perm ap, users WHERE (users.user_id = ap.user_id);
1885 -- TOC Entry ID 260 (OID 22717)
1887 -- Name: artifactperm_artgrouplist_vw Type: VIEW Owner: tperdue
1890 CREATE VIEW "artifactperm_artgrouplist_vw" as SELECT agl.group_artifact_id, agl.name, agl.description, agl.group_id, ap.user_id, ap.perm_level FROM artifact_perm ap, artifact_group_list agl WHERE (ap.group_artifact_id = agl.group_artifact_id);
1893 -- TOC Entry ID 154 (OID 22718)
1895 -- Name: artifact_category_id_seq Type: SEQUENCE Owner: tperdue
1898 CREATE SEQUENCE "artifact_category_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1901 -- TOC Entry ID 261 (OID 22737)
1903 -- Name: artifact_category Type: TABLE Owner: tperdue
1906 CREATE TABLE "artifact_category" (
1907 "id" integer DEFAULT nextval('"artifact_category_id_seq"'::text) NOT NULL,
1908 "group_artifact_id" integer NOT NULL,
1909 "category_name" text NOT NULL,
1910 "auto_assign_to" integer DEFAULT 100 NOT NULL,
1911 Constraint "artifact_category_pkey" Primary Key ("id")
1915 -- TOC Entry ID 156 (OID 22770)
1917 -- Name: artifact_group_id_seq Type: SEQUENCE Owner: tperdue
1920 CREATE SEQUENCE "artifact_group_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1923 -- TOC Entry ID 262 (OID 22789)
1925 -- Name: artifact_group Type: TABLE Owner: tperdue
1928 CREATE TABLE "artifact_group" (
1929 "id" integer DEFAULT nextval('"artifact_group_id_seq"'::text) NOT NULL,
1930 "group_artifact_id" integer NOT NULL,
1931 "group_name" text NOT NULL,
1932 Constraint "artifact_group_pkey" Primary Key ("id")
1936 -- TOC Entry ID 158 (OID 22820)
1938 -- Name: artifact_status_id_seq Type: SEQUENCE Owner: tperdue
1941 CREATE SEQUENCE "artifact_status_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1944 -- TOC Entry ID 263 (OID 22839)
1946 -- Name: artifact_status Type: TABLE Owner: tperdue
1949 CREATE TABLE "artifact_status" (
1950 "id" integer DEFAULT nextval('"artifact_status_id_seq"'::text) NOT NULL,
1951 "status_name" text NOT NULL,
1952 Constraint "artifact_status_pkey" Primary Key ("id")
1956 -- TOC Entry ID 160 (OID 22869)
1958 -- Name: artifact_artifact_id_seq Type: SEQUENCE Owner: tperdue
1961 CREATE SEQUENCE "artifact_artifact_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1964 -- TOC Entry ID 264 (OID 22888)
1966 -- Name: artifact Type: TABLE Owner: tperdue
1969 CREATE TABLE "artifact" (
1970 "artifact_id" integer DEFAULT nextval('"artifact_artifact_id_seq"'::text) NOT NULL,
1971 "group_artifact_id" integer NOT NULL,
1972 "status_id" integer DEFAULT '1' NOT NULL,
1973 "category_id" integer DEFAULT '100' NOT NULL,
1974 "artifact_group_id" integer DEFAULT '0' NOT NULL,
1975 "resolution_id" integer DEFAULT '100' NOT NULL,
1976 "priority" integer DEFAULT '5' NOT NULL,
1977 "submitted_by" integer DEFAULT '100' NOT NULL,
1978 "assigned_to" integer DEFAULT '100' NOT NULL,
1979 "open_date" integer DEFAULT '0' NOT NULL,
1980 "close_date" integer DEFAULT '0' NOT NULL,
1981 "summary" text NOT NULL,
1982 "details" text NOT NULL,
1983 Constraint "artifact_pkey" Primary Key ("artifact_id")
1987 -- TOC Entry ID 265 (OID 22970)
1989 -- Name: artifact_vw Type: VIEW Owner: tperdue
1992 CREATE VIEW "artifact_vw" as SELECT artifact.artifact_id, artifact.group_artifact_id, artifact.status_id, artifact.category_id, artifact.artifact_group_id, artifact.resolution_id, artifact.priority, artifact.submitted_by, artifact.assigned_to, artifact.open_date, artifact.close_date, artifact.summary, artifact.details, u.user_name AS assigned_unixname, u.realname AS assigned_realname, u.email AS assigned_email, u2.user_name AS submitted_unixname, u2.realname AS submitted_realname, u2.email AS submitted_email, artifact_status.status_name, artifact_category.category_name, artifact_group.group_name, artifact_resolution.resolution_name FROM users u, users u2, artifact, artifact_status, artifact_category, artifact_group, artifact_resolution WHERE ((((((artifact.assigned_to = u.user_id) AND (artifact.submitted_by = u2.user_id)) AND (artifact.status_id = artifact_status.id)) AND (artifact.category_id = artifact_category.id)) AND (artifact.artifact_group_id = artifact_group.id)) AND (artifact.resolution_id = artifact_resolution.id));
1995 -- TOC Entry ID 162 (OID 22974)
1997 -- Name: artifact_history_id_seq Type: SEQUENCE Owner: tperdue
2000 CREATE SEQUENCE "artifact_history_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
2003 -- TOC Entry ID 266 (OID 22993)
2005 -- Name: artifact_history Type: TABLE Owner: tperdue
2008 CREATE TABLE "artifact_history" (
2009 "id" integer DEFAULT nextval('"artifact_history_id_seq"'::text) NOT NULL,
2010 "artifact_id" integer DEFAULT '0' NOT NULL,
2011 "field_name" text DEFAULT '' NOT NULL,
2012 "old_value" text DEFAULT '' NOT NULL,
2013 "mod_by" integer DEFAULT '0' NOT NULL,
2014 "entrydate" integer DEFAULT '0' NOT NULL,
2015 Constraint "artifact_history_pkey" Primary Key ("id")
2019 -- TOC Entry ID 267 (OID 23047)
2021 -- Name: artifact_history_user_vw Type: VIEW Owner: tperdue
2024 CREATE VIEW "artifact_history_user_vw" as SELECT ah.id, ah.artifact_id, ah.field_name, ah.old_value, ah.entrydate, users.user_name FROM artifact_history ah, users WHERE (ah.mod_by = users.user_id);
2027 -- TOC Entry ID 164 (OID 23048)
2029 -- Name: artifact_file_id_seq Type: SEQUENCE Owner: tperdue
2032 CREATE SEQUENCE "artifact_file_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
2035 -- TOC Entry ID 268 (OID 23067)
2037 -- Name: artifact_file Type: TABLE Owner: tperdue
2040 CREATE TABLE "artifact_file" (
2041 "id" integer DEFAULT nextval('"artifact_file_id_seq"'::text) NOT NULL,
2042 "artifact_id" integer NOT NULL,
2043 "description" text NOT NULL,
2044 "bin_data" text NOT NULL,
2045 "filename" text NOT NULL,
2046 "filesize" integer NOT NULL,
2047 "filetype" text NOT NULL,
2048 "adddate" integer DEFAULT '0' NOT NULL,
2049 "submitted_by" integer NOT NULL,
2050 Constraint "artifact_file_pkey" Primary Key ("id")
2054 -- TOC Entry ID 269 (OID 23125)
2056 -- Name: artifact_file_user_vw Type: VIEW Owner: tperdue
2059 CREATE VIEW "artifact_file_user_vw" as SELECT af.id, af.artifact_id, af.description, af.bin_data, af.filename, af.filesize, af.filetype, af.adddate, af.submitted_by, users.user_name, users.realname FROM artifact_file af, users WHERE (af.submitted_by = users.user_id);
2062 -- TOC Entry ID 166 (OID 23126)
2064 -- Name: artifact_message_id_seq Type: SEQUENCE Owner: tperdue
2067 CREATE SEQUENCE "artifact_message_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
2070 -- TOC Entry ID 270 (OID 23145)
2072 -- Name: artifact_message Type: TABLE Owner: tperdue
2075 CREATE TABLE "artifact_message" (
2076 "id" integer DEFAULT nextval('"artifact_message_id_seq"'::text) NOT NULL,
2077 "artifact_id" integer NOT NULL,
2078 "submitted_by" integer NOT NULL,
2079 "from_email" text NOT NULL,
2080 "adddate" integer DEFAULT '0' NOT NULL,
2081 "body" text NOT NULL,
2082 Constraint "artifact_message_pkey" Primary Key ("id")
2086 -- TOC Entry ID 271 (OID 23198)
2088 -- Name: artifact_message_user_vw Type: VIEW Owner: tperdue
2091 CREATE VIEW "artifact_message_user_vw" as SELECT am.id, am.artifact_id, am.from_email, am.body, am.adddate, users.user_id, users.email, users.user_name, users.realname FROM artifact_message am, users WHERE (am.submitted_by = users.user_id);
2094 -- TOC Entry ID 168 (OID 23199)
2096 -- Name: artifact_monitor_id_seq Type: SEQUENCE Owner: tperdue
2099 CREATE SEQUENCE "artifact_monitor_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
2102 -- TOC Entry ID 272 (OID 23218)
2104 -- Name: artifact_monitor Type: TABLE Owner: tperdue
2107 CREATE TABLE "artifact_monitor" (
2108 "id" integer DEFAULT nextval('"artifact_monitor_id_seq"'::text) NOT NULL,
2109 "artifact_id" integer NOT NULL,
2110 "user_id" integer NOT NULL,
2112 Constraint "artifact_monitor_pkey" Primary Key ("id")
2116 -- TOC Entry ID 170 (OID 23250)
2118 -- Name: artifact_canned_response_id_seq Type: SEQUENCE Owner: tperdue
2121 CREATE SEQUENCE "artifact_canned_response_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
2124 -- TOC Entry ID 273 (OID 23269)
2126 -- Name: artifact_canned_responses Type: TABLE Owner: tperdue
2129 CREATE TABLE "artifact_canned_responses" (
2130 "id" integer DEFAULT nextval('"artifact_canned_response_id_seq"'::text) NOT NULL,
2131 "group_artifact_id" integer NOT NULL,
2132 "title" text NOT NULL,
2133 "body" text NOT NULL,
2134 Constraint "artifact_canned_responses_pkey" Primary Key ("id")
2138 -- TOC Entry ID 274 (OID 23301)
2140 -- Name: artifact_counts_agg Type: TABLE Owner: tperdue
2143 CREATE TABLE "artifact_counts_agg" (
2144 "group_artifact_id" integer NOT NULL,
2145 "count" integer NOT NULL,
2146 "open_count" integer
2150 -- TOC Entry ID 275 (OID 23313)
2152 -- Name: stats_site_pages_by_day Type: TABLE Owner: tperdue
2155 CREATE TABLE "stats_site_pages_by_day" (
2158 "site_page_views" integer
2162 -- TOC Entry ID 469 (OID 23325)
2164 -- Name: "plpgsql_call_handler" () Type: FUNCTION Owner: tperdue
2167 CREATE FUNCTION "plpgsql_call_handler" () RETURNS opaque AS '/usr/local/pgsql/lib/plpgsql.so', 'plpgsql_call_handler' LANGUAGE 'C';
2170 -- TOC Entry ID 470 (OID 23326)
2172 -- Name: plpgsql Type: PROCEDURAL LANGUAGE Owner:
2175 CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER "plpgsql_call_handler" LANCOMPILER 'PL/pgSQL';
2178 -- TOC Entry ID 471 (OID 23327)
2180 -- Name: "forumgrouplist_insert_agg" () Type: FUNCTION Owner: tperdue
2183 CREATE FUNCTION "forumgrouplist_insert_agg" () RETURNS opaque AS '
2185 INSERT INTO forum_agg_msg_count (group_forum_id,count)
2186 VALUES (NEW.group_forum_id,0);
2189 ' LANGUAGE 'plpgsql';
2192 -- TOC Entry ID 472 (OID 23328)
2194 -- Name: "artifactgrouplist_insert_agg" () Type: FUNCTION Owner: tperdue
2197 CREATE FUNCTION "artifactgrouplist_insert_agg" () RETURNS opaque AS '
2199 INSERT INTO artifact_counts_agg (group_artifact_id,count,open_count)
2200 VALUES (NEW.group_artifact_id,0,0);
2203 ' LANGUAGE 'plpgsql';
2206 -- TOC Entry ID 473 (OID 23329)
2208 -- Name: "artifactgroup_update_agg" () Type: FUNCTION Owner: tperdue
2211 CREATE FUNCTION "artifactgroup_update_agg" () RETURNS opaque AS '
2214 -- see if they are moving to a new artifacttype
2215 -- if so, its a more complex operation
2217 IF NEW.group_artifact_id <> OLD.group_artifact_id THEN
2219 -- transferred artifacts always have a status of 1
2220 -- so we will increment the new artifacttypes sums
2222 UPDATE artifact_counts_agg SET count=count+1, open_count=open_count+1
2223 WHERE group_artifact_id=NEW.group_artifact_id;
2225 -- now see how to increment/decrement the old types sums
2227 IF NEW.status_id <> OLD.status_id THEN
2228 IF OLD.status_id = 2 THEN
2229 UPDATE artifact_counts_agg SET count=count-1
2230 WHERE group_artifact_id=OLD.group_artifact_id;
2232 -- no need to do anything if it was in deleted status
2237 -- Was already in open status before
2239 UPDATE artifact_counts_agg SET count=count-1, open_count=open_count-1
2240 WHERE group_artifact_id=OLD.group_artifact_id;
2244 -- just need to evaluate the status flag and
2245 -- increment/decrement the counter as necessary
2247 IF NEW.status_id <> OLD.status_id THEN
2248 IF new.status_id = 1 THEN
2249 UPDATE artifact_counts_agg SET open_count=open_count+1
2250 WHERE group_artifact_id=new.group_artifact_id;
2252 IF new.status_id = 2 THEN
2253 UPDATE artifact_counts_agg SET open_count=open_count-1
2254 WHERE group_artifact_id=new.group_artifact_id;
2256 IF new.status_id = 3 THEN
2257 UPDATE artifact_counts_agg SET open_count=open_count-1,count=count-1
2258 WHERE group_artifact_id=new.group_artifact_id;
2266 ' LANGUAGE 'plpgsql';
2269 -- TOC Entry ID 172 (OID 23330)
2271 -- Name: massmail_queue_id_seq Type: SEQUENCE Owner: tperdue
2274 CREATE SEQUENCE "massmail_queue_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
2277 -- TOC Entry ID 276 (OID 23349)
2279 -- Name: massmail_queue Type: TABLE Owner: tperdue
2282 CREATE TABLE "massmail_queue" (
2283 "id" integer DEFAULT nextval('"massmail_queue_id_seq"'::text) NOT NULL,
2284 "type" character varying(8) NOT NULL,
2285 "subject" text NOT NULL,
2286 "message" text NOT NULL,
2287 "queued_date" integer NOT NULL,
2288 "last_userid" integer DEFAULT 0 NOT NULL,
2289 "failed_date" integer DEFAULT 0 NOT NULL,
2290 "finished_date" integer DEFAULT 0 NOT NULL,
2291 Constraint "massmail_queue_pkey" Primary Key ("id")
2295 -- TOC Entry ID 277 (OID 23388)
2297 -- Name: frs_dlstats_file_agg Type: TABLE Owner: tperdue
2300 CREATE TABLE "frs_dlstats_file_agg" (
2308 -- TOC Entry ID 278 (OID 23401)
2310 -- Name: stats_agg_site_by_group Type: TABLE Owner: tperdue
2313 CREATE TABLE "stats_agg_site_by_group" (
2321 -- TOC Entry ID 279 (OID 23414)
2323 -- Name: stats_project_metric Type: TABLE Owner: tperdue
2326 CREATE TABLE "stats_project_metric" (
2327 "month" integer DEFAULT 0 NOT NULL,
2328 "day" integer DEFAULT 0 NOT NULL,
2329 "ranking" integer DEFAULT 0 NOT NULL,
2330 "percentile" double precision DEFAULT 0 NOT NULL,
2331 "group_id" integer DEFAULT 0 NOT NULL
2335 -- TOC Entry ID 280 (OID 23433)
2337 -- Name: stats_agg_logo_by_group Type: TABLE Owner: tperdue
2340 CREATE TABLE "stats_agg_logo_by_group" (
2348 -- TOC Entry ID 281 (OID 23446)
2350 -- Name: stats_subd_pages Type: TABLE Owner: tperdue
2353 CREATE TABLE "stats_subd_pages" (
2354 "month" integer DEFAULT 0 NOT NULL,
2355 "day" integer DEFAULT 0 NOT NULL,
2356 "group_id" integer DEFAULT 0 NOT NULL,
2357 "pages" integer DEFAULT 0 NOT NULL
2361 -- TOC Entry ID 282 (OID 23463)
2363 -- Name: stats_cvs_user Type: TABLE Owner: tperdue
2366 CREATE TABLE "stats_cvs_user" (
2367 "month" integer DEFAULT 0 NOT NULL,
2368 "day" integer DEFAULT 0 NOT NULL,
2369 "group_id" integer DEFAULT 0 NOT NULL,
2370 "user_id" integer DEFAULT 0 NOT NULL,
2371 "checkouts" integer DEFAULT 0 NOT NULL,
2372 "commits" integer DEFAULT 0 NOT NULL,
2373 "adds" integer DEFAULT 0 NOT NULL
2377 -- TOC Entry ID 283 (OID 23486)
2379 -- Name: stats_cvs_group Type: TABLE Owner: tperdue
2382 CREATE TABLE "stats_cvs_group" (
2383 "month" integer DEFAULT 0 NOT NULL,
2384 "day" integer DEFAULT 0 NOT NULL,
2385 "group_id" integer DEFAULT 0 NOT NULL,
2386 "checkouts" integer DEFAULT 0 NOT NULL,
2387 "commits" integer DEFAULT 0 NOT NULL,
2388 "adds" integer DEFAULT 0 NOT NULL
2392 -- TOC Entry ID 284 (OID 23507)
2394 -- Name: stats_project_developers Type: TABLE Owner: tperdue
2397 CREATE TABLE "stats_project_developers" (
2398 "month" integer DEFAULT 0 NOT NULL,
2399 "day" integer DEFAULT 0 NOT NULL,
2400 "group_id" integer DEFAULT 0 NOT NULL,
2401 "developers" integer DEFAULT 0 NOT NULL
2405 -- TOC Entry ID 285 (OID 23524)
2407 -- Name: stats_project Type: TABLE Owner: tperdue
2410 CREATE TABLE "stats_project" (
2411 "month" integer DEFAULT 0 NOT NULL,
2412 "day" integer DEFAULT 0 NOT NULL,
2413 "group_id" integer DEFAULT 0 NOT NULL,
2414 "file_releases" integer DEFAULT 0,
2415 "msg_posted" integer DEFAULT 0,
2416 "msg_uniq_auth" integer DEFAULT 0,
2417 "bugs_opened" integer DEFAULT 0,
2418 "bugs_closed" integer DEFAULT 0,
2419 "support_opened" integer DEFAULT 0,
2420 "support_closed" integer DEFAULT 0,
2421 "patches_opened" integer DEFAULT 0,
2422 "patches_closed" integer DEFAULT 0,
2423 "artifacts_opened" integer DEFAULT 0,
2424 "artifacts_closed" integer DEFAULT 0,
2425 "tasks_opened" integer DEFAULT 0,
2426 "tasks_closed" integer DEFAULT 0,
2427 "help_requests" integer DEFAULT 0
2431 -- TOC Entry ID 286 (OID 23567)
2433 -- Name: stats_site Type: TABLE Owner: tperdue
2436 CREATE TABLE "stats_site" (
2439 "uniq_users" integer,
2441 "total_users" integer,
2442 "new_users" integer,
2443 "new_projects" integer
2447 -- TOC Entry ID 287 (OID 23583)
2449 -- Name: activity_log_old_old Type: TABLE Owner: tperdue
2452 CREATE TABLE "activity_log_old_old" (
2453 "day" integer DEFAULT '0' NOT NULL,
2454 "hour" integer DEFAULT '0' NOT NULL,
2455 "group_id" integer DEFAULT '0' NOT NULL,
2456 "browser" character varying(8) DEFAULT 'OTHER' NOT NULL,
2457 "ver" double precision DEFAULT '0.00' NOT NULL,
2458 "platform" character varying(8) DEFAULT 'OTHER' NOT NULL,
2459 "time" integer DEFAULT '0' NOT NULL,
2461 "type" integer DEFAULT '0' NOT NULL
2465 -- TOC Entry ID 288 (OID 23624)
2467 -- Name: activity_log_old Type: TABLE Owner: tperdue
2470 CREATE TABLE "activity_log_old" (
2471 "day" integer DEFAULT '0' NOT NULL,
2472 "hour" integer DEFAULT '0' NOT NULL,
2473 "group_id" integer DEFAULT '0' NOT NULL,
2474 "browser" character varying(8) DEFAULT 'OTHER' NOT NULL,
2475 "ver" double precision DEFAULT '0.00' NOT NULL,
2476 "platform" character varying(8) DEFAULT 'OTHER' NOT NULL,
2477 "time" integer DEFAULT '0' NOT NULL,
2479 "type" integer DEFAULT '0' NOT NULL
2483 -- TOC Entry ID 289 (OID 23665)
2485 -- Name: activity_log Type: TABLE Owner: tperdue
2488 CREATE TABLE "activity_log" (
2489 "day" integer DEFAULT '0' NOT NULL,
2490 "hour" integer DEFAULT '0' NOT NULL,
2491 "group_id" integer DEFAULT '0' NOT NULL,
2492 "browser" character varying(8) DEFAULT 'OTHER' NOT NULL,
2493 "ver" double precision DEFAULT '0.00' NOT NULL,
2494 "platform" character varying(8) DEFAULT 'OTHER' NOT NULL,
2495 "time" integer DEFAULT '0' NOT NULL,
2497 "type" integer DEFAULT '0' NOT NULL
2501 -- TOC Entry ID 290 (OID 23706)
2503 -- Name: cache_store Type: TABLE Owner: tperdue
2506 CREATE TABLE "cache_store" (
2507 "name" character varying(255) NOT NULL,
2509 "indate" integer DEFAULT 0 NOT NULL,
2510 Constraint "cache_store_pkey" Primary Key ("name")
2514 -- TOC Entry ID 291 (OID 25693)
2516 -- Name: user_metric_history Type: TABLE Owner: tperdue
2519 CREATE TABLE "user_metric_history" (
2520 "month" integer NOT NULL,
2521 "day" integer NOT NULL,
2522 "user_id" integer NOT NULL,
2523 "ranking" integer NOT NULL,
2524 "metric" double precision NOT NULL
2528 -- TOC Entry ID 292 (OID 25710)
2530 -- Name: foundry_project_rankings_agg Type: TABLE Owner: tperdue
2533 CREATE TABLE "foundry_project_rankings_agg" (
2534 "foundry_id" integer,
2536 "group_name" character varying(40),
2537 "unix_group_name" character varying(30),
2539 "percentile" double precision
2543 -- TOC Entry ID 293 (OID 25728)
2545 -- Name: foundry_project_downloads_agg Type: TABLE Owner: tperdue
2548 CREATE TABLE "foundry_project_downloads_agg" (
2549 "foundry_id" integer,
2550 "downloads" integer,
2552 "group_name" character varying(40),
2553 "unix_group_name" character varying(30)
2557 -- TOC Entry ID 294 (OID 25745)
2559 -- Name: frs_dlstats_filetotal_agg Type: TABLE Owner: tperdue
2562 CREATE TABLE "frs_dlstats_filetotal_agg" (
2568 -- TOC Entry ID 295 (OID 25759)
2570 -- Name: frs_dlstats_grouptotal_agg Type: TABLE Owner: tperdue
2573 CREATE TABLE "frs_dlstats_grouptotal_agg" (
2579 -- TOC Entry ID 296 (OID 25773)
2581 -- Name: frs_dlstats_group_agg Type: TABLE Owner: tperdue
2584 CREATE TABLE "frs_dlstats_group_agg" (
2592 -- TOC Entry ID 297 (OID 25792)
2594 -- Name: stats_project_months Type: TABLE Owner: tperdue
2597 CREATE TABLE "stats_project_months" (
2600 "developers" integer,
2601 "group_ranking" integer,
2602 "group_metric" double precision,
2603 "logo_showings" integer,
2604 "downloads" integer,
2605 "site_views" integer,
2606 "subdomain_views" integer,
2607 "page_views" integer,
2608 "file_releases" integer,
2609 "msg_posted" integer,
2610 "msg_uniq_auth" integer,
2611 "bugs_opened" integer,
2612 "bugs_closed" integer,
2613 "support_opened" integer,
2614 "support_closed" integer,
2615 "patches_opened" integer,
2616 "patches_closed" integer,
2617 "artifacts_opened" integer,
2618 "artifacts_closed" integer,
2619 "tasks_opened" integer,
2620 "tasks_closed" integer,
2621 "help_requests" integer,
2622 "cvs_checkouts" integer,
2623 "cvs_commits" integer,
2628 -- TOC Entry ID 298 (OID 25834)
2630 -- Name: stats_project_all Type: TABLE Owner: tperdue
2633 CREATE TABLE "stats_project_all" (
2635 "developers" integer,
2636 "group_ranking" integer,
2637 "group_metric" double precision,
2638 "logo_showings" integer,
2639 "downloads" integer,
2640 "site_views" integer,
2641 "subdomain_views" integer,
2642 "page_views" integer,
2643 "msg_posted" integer,
2644 "msg_uniq_auth" integer,
2645 "bugs_opened" integer,
2646 "bugs_closed" integer,
2647 "support_opened" integer,
2648 "support_closed" integer,
2649 "patches_opened" integer,
2650 "patches_closed" integer,
2651 "artifacts_opened" integer,
2652 "artifacts_closed" integer,
2653 "tasks_opened" integer,
2654 "tasks_closed" integer,
2655 "help_requests" integer,
2656 "cvs_checkouts" integer,
2657 "cvs_commits" integer,
2662 -- TOC Entry ID 299 (OID 25871)
2664 -- Name: stats_project_developers_last30 Type: TABLE Owner: tperdue
2667 CREATE TABLE "stats_project_developers_last30" (
2671 "developers" integer
2675 -- TOC Entry ID 300 (OID 25884)
2677 -- Name: stats_project_last_30 Type: TABLE Owner: tperdue
2680 CREATE TABLE "stats_project_last_30" (
2684 "developers" integer,
2685 "group_ranking" integer,
2686 "group_metric" double precision,
2687 "logo_showings" integer,
2688 "downloads" integer,
2689 "site_views" integer,
2690 "subdomain_views" integer,
2691 "page_views" integer,
2692 "filereleases" integer,
2693 "msg_posted" integer,
2694 "msg_uniq_auth" integer,
2695 "bugs_opened" integer,
2696 "bugs_closed" integer,
2697 "support_opened" integer,
2698 "support_closed" integer,
2699 "patches_opened" integer,
2700 "patches_closed" integer,
2701 "artifacts_opened" integer,
2702 "artifacts_closed" integer,
2703 "tasks_opened" integer,
2704 "tasks_closed" integer,
2705 "help_requests" integer,
2706 "cvs_checkouts" integer,
2707 "cvs_commits" integer,
2712 -- TOC Entry ID 301 (OID 25924)
2714 -- Name: stats_site_pages_by_month Type: TABLE Owner: tperdue
2717 CREATE TABLE "stats_site_pages_by_month" (
2719 "site_page_views" integer
2723 -- TOC Entry ID 302 (OID 25935)
2725 -- Name: stats_site_last_30 Type: TABLE Owner: tperdue
2728 CREATE TABLE "stats_site_last_30" (
2731 "site_page_views" integer,
2732 "downloads" integer,
2733 "subdomain_views" integer,
2734 "msg_posted" integer,
2735 "bugs_opened" integer,
2736 "bugs_closed" integer,
2737 "support_opened" integer,
2738 "support_closed" integer,
2739 "patches_opened" integer,
2740 "patches_closed" integer,
2741 "artifacts_opened" integer,
2742 "artifacts_closed" integer,
2743 "tasks_opened" integer,
2744 "tasks_closed" integer,
2745 "help_requests" integer,
2746 "cvs_checkouts" integer,
2747 "cvs_commits" integer,
2752 -- TOC Entry ID 303 (OID 25967)
2754 -- Name: stats_site_months Type: TABLE Owner: tperdue
2757 CREATE TABLE "stats_site_months" (
2759 "site_page_views" integer,
2760 "downloads" integer,
2761 "subdomain_views" integer,
2762 "msg_posted" integer,
2763 "bugs_opened" integer,
2764 "bugs_closed" integer,
2765 "support_opened" integer,
2766 "support_closed" integer,
2767 "patches_opened" integer,
2768 "patches_closed" integer,
2769 "artifacts_opened" integer,
2770 "artifacts_closed" integer,
2771 "tasks_opened" integer,
2772 "tasks_closed" integer,
2773 "help_requests" integer,
2774 "cvs_checkouts" integer,
2775 "cvs_commits" integer,
2780 -- TOC Entry ID 304 (OID 25998)
2782 -- Name: stats_site_all Type: TABLE Owner: tperdue
2785 CREATE TABLE "stats_site_all" (
2786 "site_page_views" integer,
2787 "downloads" integer,
2788 "subdomain_views" integer,
2789 "msg_posted" integer,
2790 "bugs_opened" integer,
2791 "bugs_closed" integer,
2792 "support_opened" integer,
2793 "support_closed" integer,
2794 "patches_opened" integer,
2795 "patches_closed" integer,
2796 "artifacts_opened" integer,
2797 "artifacts_closed" integer,
2798 "tasks_opened" integer,
2799 "tasks_closed" integer,
2800 "help_requests" integer,
2801 "cvs_checkouts" integer,
2802 "cvs_commits" integer,
2807 -- TOC Entry ID 305 (OID 26026)
2809 -- Name: trove_agg Type: TABLE Owner: tperdue
2812 CREATE TABLE "trove_agg" (
2813 "trove_cat_id" integer,
2815 "group_name" character varying(40),
2816 "unix_group_name" character varying(30),
2817 "status" character(1),
2818 "register_time" integer,
2819 "short_description" character varying(255),
2820 "percentile" double precision,
2825 -- TOC Entry ID 174 (OID 26050)
2827 -- Name: trove_treesum_trove_treesum_seq Type: SEQUENCE Owner: tperdue
2830 CREATE SEQUENCE "trove_treesum_trove_treesum_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
2833 -- TOC Entry ID 306 (OID 26069)
2835 -- Name: trove_treesums Type: TABLE Owner: tperdue
2838 CREATE TABLE "trove_treesums" (
2839 "trove_treesums_id" integer DEFAULT nextval('"trove_treesum_trove_treesum_seq"'::text) NOT NULL,
2840 "trove_cat_id" integer DEFAULT '0' NOT NULL,
2841 "limit_1" integer DEFAULT '0' NOT NULL,
2842 "subprojects" integer DEFAULT '0' NOT NULL,
2843 Constraint "trove_treesums_pkey" Primary Key ("trove_treesums_id")
2847 -- Data for TOC Entry ID 474 (OID 18743)
2849 -- Name: canned_responses Type: TABLE DATA Owner: tperdue
2853 COPY "canned_responses" FROM stdin;
2856 -- Data for TOC Entry ID 475 (OID 18793)
2858 -- Name: db_images Type: TABLE DATA Owner: tperdue
2862 COPY "db_images" FROM stdin;
2865 -- Data for TOC Entry ID 476 (OID 18859)
2867 -- Name: doc_data Type: TABLE DATA Owner: tperdue
2871 COPY "doc_data" FROM stdin;
2874 -- Data for TOC Entry ID 477 (OID 18924)
2876 -- Name: doc_groups Type: TABLE DATA Owner: tperdue
2880 COPY "doc_groups" FROM stdin;
2883 -- Data for TOC Entry ID 478 (OID 18961)
2885 -- Name: doc_states Type: TABLE DATA Owner: tperdue
2889 COPY "doc_states" FROM stdin;
2892 -- Data for TOC Entry ID 479 (OID 18996)
2894 -- Name: filemodule_monitor Type: TABLE DATA Owner: tperdue
2898 COPY "filemodule_monitor" FROM stdin;
2901 -- Data for TOC Entry ID 480 (OID 19033)
2903 -- Name: forum Type: TABLE DATA Owner: tperdue
2907 COPY "forum" FROM stdin;
2910 -- Data for TOC Entry ID 481 (OID 19080)
2912 -- Name: forum_agg_msg_count Type: TABLE DATA Owner: tperdue
2916 COPY "forum_agg_msg_count" FROM stdin;
2919 -- Data for TOC Entry ID 482 (OID 19115)
2921 -- Name: forum_group_list Type: TABLE DATA Owner: tperdue
2925 COPY "forum_group_list" FROM stdin;
2928 -- Data for TOC Entry ID 483 (OID 19173)
2930 -- Name: forum_monitored_forums Type: TABLE DATA Owner: tperdue
2934 COPY "forum_monitored_forums" FROM stdin;
2937 -- Data for TOC Entry ID 484 (OID 19210)
2939 -- Name: forum_saved_place Type: TABLE DATA Owner: tperdue
2943 COPY "forum_saved_place" FROM stdin;
2946 -- Data for TOC Entry ID 485 (OID 19230)
2948 -- Name: foundry_data Type: TABLE DATA Owner: tperdue
2952 COPY "foundry_data" FROM stdin;
2955 -- Data for TOC Entry ID 486 (OID 19287)
2957 -- Name: foundry_news Type: TABLE DATA Owner: tperdue
2961 COPY "foundry_news" FROM stdin;
2964 -- Data for TOC Entry ID 487 (OID 19328)
2966 -- Name: foundry_preferred_projects Type: TABLE DATA Owner: tperdue
2970 COPY "foundry_preferred_projects" FROM stdin;
2973 -- Data for TOC Entry ID 488 (OID 19367)
2975 -- Name: foundry_projects Type: TABLE DATA Owner: tperdue
2979 COPY "foundry_projects" FROM stdin;
2982 -- Data for TOC Entry ID 489 (OID 19404)
2984 -- Name: frs_file Type: TABLE DATA Owner: tperdue
2988 COPY "frs_file" FROM stdin;
2991 -- Data for TOC Entry ID 490 (OID 19465)
2993 -- Name: frs_filetype Type: TABLE DATA Owner: tperdue
2997 COPY "frs_filetype" FROM stdin;
3007 5900 Other Source File
3015 -- Data for TOC Entry ID 491 (OID 19514)
3017 -- Name: frs_package Type: TABLE DATA Owner: tperdue
3021 COPY "frs_package" FROM stdin;
3024 -- Data for TOC Entry ID 492 (OID 19567)
3026 -- Name: frs_processor Type: TABLE DATA Owner: tperdue
3030 COPY "frs_processor" FROM stdin;
3042 -- Data for TOC Entry ID 493 (OID 19616)
3044 -- Name: frs_release Type: TABLE DATA Owner: tperdue
3048 COPY "frs_release" FROM stdin;
3051 -- Data for TOC Entry ID 494 (OID 19677)
3053 -- Name: frs_status Type: TABLE DATA Owner: tperdue
3057 COPY "frs_status" FROM stdin;
3062 -- Data for TOC Entry ID 495 (OID 19745)
3064 -- Name: group_history Type: TABLE DATA Owner: tperdue
3068 COPY "group_history" FROM stdin;
3071 -- Data for TOC Entry ID 496 (OID 19802)
3073 -- Name: group_type Type: TABLE DATA Owner: tperdue
3077 COPY "group_type" FROM stdin;
3082 -- Data for TOC Entry ID 497 (OID 19851)
3084 -- Name: groups Type: TABLE DATA Owner: tperdue
3088 COPY "groups" FROM stdin;
3089 1 Master Group \N 0 A sourceforge shell1 \N \N cvs1 \N \N \N 0 1 1 1 1 1 1 1 1 1 0 1
3090 2 Stats Group \N 0 A stats shell1 \N \N cvs1 \N \N \N 0 1 1 1 1 1 1 1 1 1 0 1
3091 3 News Group \N 0 A news shell1 \N \N cvs1 \N \N \N 0 1 1 1 1 1 1 1 1 1 0 1
3092 4 Peer Ratings Group \N 0 A peerrating shell1 \N \N cvs1 \N \N \N 0 1 1 1 1 1 1 1 1 1 0 1
3095 -- Data for TOC Entry ID 499 (OID 19996)
3097 -- Name: mail_group_list Type: TABLE DATA Owner: tperdue
3101 COPY "mail_group_list" FROM stdin;
3104 -- Data for TOC Entry ID 500 (OID 20055)
3106 -- Name: news_bytes Type: TABLE DATA Owner: tperdue
3110 COPY "news_bytes" FROM stdin;
3113 -- Data for TOC Entry ID 501 (OID 20115)
3115 -- Name: people_job Type: TABLE DATA Owner: tperdue
3119 COPY "people_job" FROM stdin;
3122 -- Data for TOC Entry ID 502 (OID 20175)
3124 -- Name: people_job_category Type: TABLE DATA Owner: tperdue
3128 COPY "people_job_category" FROM stdin;
3135 7 Graphic/Other Designer 0
3138 -- Data for TOC Entry ID 503 (OID 20226)
3140 -- Name: people_job_inventory Type: TABLE DATA Owner: tperdue
3144 COPY "people_job_inventory" FROM stdin;
3147 -- Data for TOC Entry ID 504 (OID 20267)
3149 -- Name: people_job_status Type: TABLE DATA Owner: tperdue
3153 COPY "people_job_status" FROM stdin;
3159 -- Data for TOC Entry ID 505 (OID 20316)
3161 -- Name: people_skill Type: TABLE DATA Owner: tperdue
3165 COPY "people_skill" FROM stdin;
3168 -- Data for TOC Entry ID 506 (OID 20365)
3170 -- Name: people_skill_inventory Type: TABLE DATA Owner: tperdue
3174 COPY "people_skill_inventory" FROM stdin;
3177 -- Data for TOC Entry ID 507 (OID 20406)
3179 -- Name: people_skill_level Type: TABLE DATA Owner: tperdue
3183 COPY "people_skill_level" FROM stdin;
3191 -- Data for TOC Entry ID 508 (OID 20455)
3193 -- Name: people_skill_year Type: TABLE DATA Owner: tperdue
3197 COPY "people_skill_year" FROM stdin;
3205 -- Data for TOC Entry ID 509 (OID 20504)
3207 -- Name: project_assigned_to Type: TABLE DATA Owner: tperdue
3211 COPY "project_assigned_to" FROM stdin;
3214 -- Data for TOC Entry ID 510 (OID 20541)
3216 -- Name: project_dependencies Type: TABLE DATA Owner: tperdue
3220 COPY "project_dependencies" FROM stdin;
3223 -- Data for TOC Entry ID 511 (OID 20578)
3225 -- Name: project_group_list Type: TABLE DATA Owner: tperdue
3229 COPY "project_group_list" FROM stdin;
3233 -- Data for TOC Entry ID 512 (OID 20633)
3235 -- Name: project_history Type: TABLE DATA Owner: tperdue
3239 COPY "project_history" FROM stdin;
3242 -- Data for TOC Entry ID 513 (OID 20691)
3244 -- Name: project_metric Type: TABLE DATA Owner: tperdue
3248 COPY "project_metric" FROM stdin;
3251 -- Data for TOC Entry ID 514 (OID 20727)
3253 -- Name: project_metric_tmp1 Type: TABLE DATA Owner: tperdue
3257 COPY "project_metric_tmp1" FROM stdin;
3260 -- Data for TOC Entry ID 515 (OID 20782)
3262 -- Name: project_status Type: TABLE DATA Owner: tperdue
3266 COPY "project_status" FROM stdin;
3273 -- Data for TOC Entry ID 516 (OID 20832)
3275 -- Name: project_task Type: TABLE DATA Owner: tperdue
3279 COPY "project_task" FROM stdin;
3280 1 1 0 0 0 0 0 100 100
3283 -- Data for TOC Entry ID 517 (OID 20900)
3285 -- Name: project_weekly_metric Type: TABLE DATA Owner: tperdue
3289 COPY "project_weekly_metric" FROM stdin;
3292 -- Data for TOC Entry ID 518 (OID 20914)
3294 -- Name: session Type: TABLE DATA Owner: tperdue
3298 COPY "session" FROM stdin;
3301 -- Data for TOC Entry ID 519 (OID 20953)
3303 -- Name: snippet Type: TABLE DATA Owner: tperdue
3307 COPY "snippet" FROM stdin;
3310 -- Data for TOC Entry ID 520 (OID 21013)
3312 -- Name: snippet_package Type: TABLE DATA Owner: tperdue
3316 COPY "snippet_package" FROM stdin;
3319 -- Data for TOC Entry ID 521 (OID 21069)
3321 -- Name: snippet_package_item Type: TABLE DATA Owner: tperdue
3325 COPY "snippet_package_item" FROM stdin;
3328 -- Data for TOC Entry ID 522 (OID 21106)
3330 -- Name: snippet_package_version Type: TABLE DATA Owner: tperdue
3334 COPY "snippet_package_version" FROM stdin;
3337 -- Data for TOC Entry ID 523 (OID 21162)
3339 -- Name: snippet_version Type: TABLE DATA Owner: tperdue
3343 COPY "snippet_version" FROM stdin;
3346 -- Data for TOC Entry ID 524 (OID 21200)
3348 -- Name: stats_agg_logo_by_day Type: TABLE DATA Owner: tperdue
3352 COPY "stats_agg_logo_by_day" FROM stdin;
3355 -- Data for TOC Entry ID 525 (OID 21211)
3357 -- Name: stats_agg_pages_by_day Type: TABLE DATA Owner: tperdue
3361 COPY "stats_agg_pages_by_day" FROM stdin;
3364 -- Data for TOC Entry ID 526 (OID 21224)
3366 -- Name: stats_ftp_downloads Type: TABLE DATA Owner: tperdue
3370 COPY "stats_ftp_downloads" FROM stdin;
3373 -- Data for TOC Entry ID 527 (OID 21241)
3375 -- Name: stats_http_downloads Type: TABLE DATA Owner: tperdue
3379 COPY "stats_http_downloads" FROM stdin;
3382 -- Data for TOC Entry ID 528 (OID 21277)
3384 -- Name: supported_languages Type: TABLE DATA Owner: tperdue
3388 COPY "supported_languages" FROM stdin;
3389 1 English English.class English en
3390 2 Japanese Japanese.class Japanese ja
3391 3 Hebrew Hebrew.class Hebrew iw
3392 4 Spanish Spanish.class Spanish es
3393 5 Thai Thai.class Thai th
3394 6 German German.class German de
3395 7 French French.class French fr
3396 8 Italian Italian.class Italian it
3397 9 Norwegian Norwegian.class Norwegian no
3398 10 Swedish Swedish.class Swedish sv
3399 12 Dutch Dutch.class Dutch nl
3400 13 Esperanto Esperanto.class Esperanto eo
3401 14 Catalan Catalan.class Catalan ca
3402 15 Polish Polish.class Polish pl
3403 11 Trad.Chinese Chinese.class Chinese zh
3404 17 Russian Russian.class Russian ru
3405 18 Portuguese Portuguese.class Portuguese pt
3406 19 Greek Greek.class Greek el
3407 20 Bulgarian Bulgarian.class Bulgarian bg
3408 21 Indonesian Indonesian.class Indonesian id
3409 16 Pt. Brazillian PortugueseBrazillian.class PortugueseBrazillian pt
3410 22 Korean Korean.class Korean ko
3411 23 Smpl.Chinese SimplifiedChinese.class SimplifiedChinese zn
3414 -- Data for TOC Entry ID 529 (OID 21329)
3416 -- Name: survey_question_types Type: TABLE DATA Owner: tperdue
3420 COPY "survey_question_types" FROM stdin;
3423 3 Radio Buttons Yes/No
3429 -- Data for TOC Entry ID 530 (OID 21379)
3431 -- Name: survey_questions Type: TABLE DATA Owner: tperdue
3435 COPY "survey_questions" FROM stdin;
3438 -- Data for TOC Entry ID 531 (OID 21414)
3440 -- Name: survey_rating_aggregate Type: TABLE DATA Owner: tperdue
3444 COPY "survey_rating_aggregate" FROM stdin;
3447 -- Data for TOC Entry ID 532 (OID 21431)
3449 -- Name: survey_rating_response Type: TABLE DATA Owner: tperdue
3453 COPY "survey_rating_response" FROM stdin;
3456 -- Data for TOC Entry ID 533 (OID 21450)
3458 -- Name: survey_responses Type: TABLE DATA Owner: tperdue
3462 COPY "survey_responses" FROM stdin;
3465 -- Data for TOC Entry ID 534 (OID 21505)
3467 -- Name: surveys Type: TABLE DATA Owner: tperdue
3471 COPY "surveys" FROM stdin;
3474 -- Data for TOC Entry ID 535 (OID 21637)
3476 -- Name: theme_prefs Type: TABLE DATA Owner: tperdue
3480 COPY "theme_prefs" FROM stdin;
3483 -- Data for TOC Entry ID 536 (OID 21684)
3485 -- Name: themes Type: TABLE DATA Owner: tperdue
3489 COPY "themes" FROM stdin;
3490 1 offsite Off Site Theme
3493 -- Data for TOC Entry ID 537 (OID 21700)
3495 -- Name: top_group Type: TABLE DATA Owner: tperdue
3499 COPY "top_group" FROM stdin;
3502 -- Data for TOC Entry ID 538 (OID 21761)
3504 -- Name: trove_cat Type: TABLE DATA Owner: tperdue
3508 COPY "trove_cat" FROM stdin;
3509 1 2000031601 0 0 audience Intended Audience The main class of people likely to be interested in this resource. 0 0 Intended Audience 1
3510 2 2000032401 1 1 endusers End Users/Desktop Programs and resources for software end users. Software for the desktop. 0 0 Intended Audience :: End Users/Desktop 1 :: 2
3511 3 2000041101 1 1 developers Developers Programs and resources for software developers, to include libraries. 0 0 Intended Audience :: Developers 1 :: 3
3512 4 2000031601 1 1 sysadmins System Administrators Programs and resources for people who administer computers and networks. 0 0 Intended Audience :: System Administrators 1 :: 4
3513 5 2000040701 1 1 other Other Audience Programs and resources for an unlisted audience. 0 0 Intended Audience :: Other Audience 1 :: 5
3514 6 2000031601 0 0 developmentstatus Development Status An indication of the development status of the software or resource. 0 0 Development Status 6
3515 7 2000040701 6 6 planning 1 - Planning This resource is in the planning stages only. There is no code. 0 0 Development Status :: 1 - Planning 6 :: 7
3516 8 2000040701 6 6 prealpha 2 - Pre-Alpha There is code for this project, but it is not usable except for further development. 0 0 Development Status :: 2 - Pre-Alpha 6 :: 8
3517 9 2000041101 6 6 alpha 3 - Alpha Resource is in early development, and probably incomplete and/or extremely buggy. 0 0 Development Status :: 3 - Alpha 6 :: 9
3518 10 2000040701 6 6 beta 4 - Beta Resource is in late phases of development. Deliverables are essentially complete, but may still have significant bugs. 0 0 Development Status :: 4 - Beta 6 :: 10
3519 11 2000040701 6 6 production 5 - Production/Stable Deliverables are complete and usable by the intended audience. 0 0 Development Status :: 5 - Production/Stable 6 :: 11
3520 12 2000040701 6 6 mature 6 - Mature This resource has an extensive history of successful use and has probably undergone several stable revisions. 0 0 Development Status :: 6 - Mature 6 :: 12
3521 13 2000031601 0 0 license License License terms under which the resource is distributed. 0 0 License 13
3522 197 2000032001 13 13 publicdomain Public Domain Public Domain. No author-retained rights. 0 0 License :: Public Domain 13 :: 197
3523 196 2000040701 13 13 other Other/Proprietary License Non OSI-Approved/Proprietary license. 0 0 License :: Other/Proprietary License 13 :: 196
3524 14 2000032401 13 13 osi OSI Approved Licenses that have been approved by OSI as approved 0 0 License :: OSI Approved 13 :: 14
3525 303 2001041701 14 13 nethack Nethack General Public License Nethack General Public License 0 0 License :: OSI Approved :: Nethack General Public License 13 :: 14 :: 303
3526 141 2000032001 136 18 clustering Clustering/Distributed Networks Tools for automatically distributing computation across a network. 0 0 Topic :: System :: Clustering/Distributed Networks 18 :: 136 :: 141
3527 139 2000032001 136 18 boot Boot Programs for bootstrapping your OS. 0 0 Topic :: System :: Boot 18 :: 136 :: 139
3528 140 2000032001 139 18 init Init Init-time programs to start system services after boot. 0 0 Topic :: System :: Boot :: Init 18 :: 136 :: 139 :: 140
3529 138 2000032001 136 18 benchmark Benchmark Programs for benchmarking system performance. 0 0 Topic :: System :: Benchmark 18 :: 136 :: 138
3530 74 2000042701 136 18 emulators Emulators Emulations of foreign operating systme and machines. 0 0 Topic :: System :: Emulators 18 :: 136 :: 74
3531 19 2000032001 136 18 archiving Archiving Tools for maintaining and searching software or document archives. 0 0 Topic :: System :: Archiving 18 :: 136 :: 19
3532 137 2000032001 19 18 backup Backup Programs to manage and sequence system backup. 0 0 Topic :: System :: Archiving :: Backup 18 :: 136 :: 19 :: 137
3533 42 2000031601 19 18 compression Compression Tools and libraries for data compression. 0 0 Topic :: System :: Archiving :: Compression 18 :: 136 :: 19 :: 42
3534 41 2000031601 19 18 packaging Packaging Tools for packing and unpacking multi-file formats. Includes data-only formats and software package systems. 0 0 Topic :: System :: Archiving :: Packaging 18 :: 136 :: 19 :: 41
3535 132 2000032001 18 18 religion Religion Programs relating to religion and sacred texts. 0 0 Topic :: Religion 18 :: 132
3536 129 2000031701 18 18 office Office/Business Software for assisting and organizing work at your desk. 0 0 Topic :: Office/Business 18 :: 129
3537 131 2000032001 129 18 suites Office Suites Integrated office suites (word processing, presentation, spreadsheet, database, etc). 0 0 Topic :: Office/Business :: Office Suites 18 :: 129 :: 131
3538 130 2000031701 129 18 scheduling Scheduling Projects for scheduling time, to include project management. 0 0 Topic :: Office/Business :: Scheduling 18 :: 129 :: 130
3539 75 2000031701 129 18 financial Financial Programs related to finance. 0 0 Topic :: Office/Business :: Financial 18 :: 129 :: 75
3540 79 2000031601 75 18 pointofsale Point-Of-Sale Point-Of-Sale applications. 0 0 Topic :: Office/Business :: Financial :: Point-Of-Sale 18 :: 129 :: 75 :: 79
3541 78 2000031601 75 18 spreadsheet Spreadsheet Spreadsheet applications. 0 0 Topic :: Office/Business :: Financial :: Spreadsheet 18 :: 129 :: 75 :: 78
3542 77 2000031601 75 18 investment Investment Programs for assisting in financial investment. 0 0 Topic :: Office/Business :: Financial :: Investment 18 :: 129 :: 75 :: 77
3543 76 2000031601 75 18 accounting Accounting Checkbook balancers and accounting programs. 0 0 Topic :: Office/Business :: Financial :: Accounting 18 :: 129 :: 75 :: 76
3544 234 2000040701 18 18 other Other/Nonlisted Topic Topic does not fit into any listed category. 0 0 Topic :: Other/Nonlisted Topic 18 :: 234
3545 156 2000032001 18 18 terminals Terminals Terminal emulators, terminal programs, and terminal session utilities. 0 0 Topic :: Terminals 18 :: 156
3546 159 2000032001 156 18 telnet Telnet Support for telnet; terminal sessions across Internet links. 0 0 Topic :: Terminals :: Telnet 18 :: 156 :: 159
3547 158 2000032001 156 18 virtual Terminal Emulators/X Terminals Programs to handle multiple terminal sessions. Includes terminal emulations for X and other window systems. 0 0 Topic :: Terminals :: Terminal Emulators/X Terminals 18 :: 156 :: 158
3548 157 2000032001 156 18 serial Serial Dialup, terminal emulation, and file transfer over serial lines. 0 0 Topic :: Terminals :: Serial 18 :: 156 :: 157
3549 115 2000031701 113 18 capture Capture/Recording Sound capture and recording. 0 0 Topic :: Multimedia :: Sound/Audio :: Capture/Recording 18 :: 99 :: 113 :: 115
3550 114 2000031701 113 18 analysis Analysis Sound analysis tools, to include frequency analysis. 0 0 Topic :: Multimedia :: Sound/Audio :: Analysis 18 :: 99 :: 113 :: 114
3551 100 2000031601 99 18 graphics Graphics Tools and resources for computer graphics. 0 0 Topic :: Multimedia :: Graphics 18 :: 99 :: 100
3552 112 2000031701 100 18 viewers Viewers Programs that can display various graphics formats. 0 0 Topic :: Multimedia :: Graphics :: Viewers 18 :: 99 :: 100 :: 112
3553 111 2000031701 100 18 presentation Presentation Tools for generating presentation graphics and slides. 0 0 Topic :: Multimedia :: Graphics :: Presentation 18 :: 99 :: 100 :: 111
3554 110 2000031701 100 18 3drendering 3D Rendering Programs which render 3D models. 0 0 Topic :: Multimedia :: Graphics :: 3D Rendering 18 :: 99 :: 100 :: 110
3555 109 2000031701 100 18 3dmodeling 3D Modeling Programs for working with 3D Models. 0 0 Topic :: Multimedia :: Graphics :: 3D Modeling 18 :: 99 :: 100 :: 109
3556 106 2000031701 100 18 editors Editors Drawing, painting, and structured editing programs. 0 0 Topic :: Multimedia :: Graphics :: Editors 18 :: 99 :: 100 :: 106
3557 108 2000031701 106 18 raster Raster-Based Raster/Bitmap based drawing programs. 0 0 Topic :: Multimedia :: Graphics :: Editors :: Raster-Based 18 :: 99 :: 100 :: 106 :: 108
3558 107 2000031701 106 18 vector Vector-Based Vector-Based drawing programs. 0 0 Topic :: Multimedia :: Graphics :: Editors :: Vector-Based 18 :: 99 :: 100 :: 106 :: 107
3559 105 2000031701 100 18 conversion Graphics Conversion Programs which convert between graphics formats. 0 0 Topic :: Multimedia :: Graphics :: Graphics Conversion 18 :: 99 :: 100 :: 105
3560 101 2000031601 100 18 capture Capture Support for scanners, cameras, and screen capture. 0 0 Topic :: Multimedia :: Graphics :: Capture 18 :: 99 :: 100 :: 101
3561 104 2000031601 101 18 screencapture Screen Capture Screen capture tools and processors. 0 0 Topic :: Multimedia :: Graphics :: Capture :: Screen Capture 18 :: 99 :: 100 :: 101 :: 104
3562 103 2000031601 101 18 cameras Digital Camera Digital Camera 0 0 Topic :: Multimedia :: Graphics :: Capture :: Digital Camera 18 :: 99 :: 100 :: 101 :: 103
3563 102 2000031601 101 18 scanners Scanners Support for graphic scanners. 0 0 Topic :: Multimedia :: Graphics :: Capture :: Scanners 18 :: 99 :: 100 :: 101 :: 102
3564 154 2000032001 18 18 printing Printing Tools, daemons, and utilities for printer control. 0 0 Topic :: Printing 18 :: 154
3565 136 2000032001 18 18 system System Operating system core and administration utilities. 0 0 Topic :: System 18 :: 136
3566 294 2001032001 136 18 shells System Shells System Shells 0 0 Topic :: System :: System Shells 18 :: 136 :: 294
3567 257 2000071101 136 18 softwaredist Software Distribution Systems software for distributing other software. 0 0 Topic :: System :: Software Distribution 18 :: 136 :: 257
3568 253 2000071101 136 18 sysadministration Systems Administration Systems Administration Software (e.g. configuration apps.) 0 0 Topic :: System :: Systems Administration 18 :: 136 :: 253
3569 289 2001032001 253 18 authentication Authentication/Directory Authentication and directory services 0 0 Topic :: System :: Systems Administration :: Authentication/Directory 18 :: 136 :: 253 :: 289
3570 291 2001032001 289 18 ldap LDAP Leightweight directory access protocol 0 0 Topic :: System :: Systems Administration :: Authentication/Directory :: LDAP 18 :: 136 :: 253 :: 289 :: 291
3571 290 2001032001 289 18 nis NIS NIS services 0 0 Topic :: System :: Systems Administration :: Authentication/Directory :: NIS 18 :: 136 :: 253 :: 289 :: 290
3572 153 2000032001 136 18 power Power (UPS) Code for communication with uninterruptible power supplies. 0 0 Topic :: System :: Power (UPS) 18 :: 136 :: 153
3573 150 2000032001 136 18 networking Networking Network configuration and administration. 0 0 Topic :: System :: Networking 18 :: 136 :: 150
3574 152 2000032001 150 18 monitoring Monitoring System monitoring, traffic analysis, and sniffers. 0 0 Topic :: System :: Networking :: Monitoring 18 :: 136 :: 150 :: 152
3575 155 2000032001 152 18 watchdog Hardware Watchdog Software to monitor and perform actions or shutdown on hardware trouble detection. 0 0 Topic :: System :: Networking :: Monitoring :: Hardware Watchdog 18 :: 136 :: 150 :: 152 :: 155
3576 151 2000032001 150 18 firewalls Firewalls Firewalls and filtering systems. 0 0 Topic :: System :: Networking :: Firewalls 18 :: 136 :: 150 :: 151
3577 148 2000032001 136 18 logging Logging Utilities for clearing, rotating, and digesting system logs. 0 0 Topic :: System :: Logging 18 :: 136 :: 148
3578 147 2000032001 136 18 setup Installation/Setup Tools for installation and setup of the operating system and other programs. 0 0 Topic :: System :: Installation/Setup 18 :: 136 :: 147
3579 146 2000032001 136 18 hardware Hardware Tools for direct, non-kernel control and configuration of hardware. 0 0 Topic :: System :: Hardware 18 :: 136 :: 146
3580 292 2001032001 146 18 drivers Hardware Drivers Hardware Drivers 0 0 Topic :: System :: Hardware :: Hardware Drivers 18 :: 136 :: 146 :: 292
3581 144 2000032001 136 18 kernels Operating System Kernels OS Kernels, patches, modules, and tools. 0 0 Topic :: System :: Operating System Kernels 18 :: 136 :: 144
3582 239 2000041301 144 18 gnuhurd GNU Hurd Kernel code and modules for GNU Hurd. 0 0 Topic :: System :: Operating System Kernels :: GNU Hurd 18 :: 136 :: 144 :: 239
3583 145 2000032001 144 18 bsd BSD Code relating to any of the BSD kernels. 0 0 Topic :: System :: Operating System Kernels :: BSD 18 :: 136 :: 144 :: 145
3584 143 2000032001 144 18 linux Linux The Linux kernel, patches, and modules. 0 0 Topic :: System :: Operating System Kernels :: Linux 18 :: 136 :: 144 :: 143
3585 142 2000032001 136 18 filesystems Filesystems Support for creating, editing, reading, and writing file systems. 0 0 Topic :: System :: Filesystems 18 :: 136 :: 142
3586 287 2001032001 80 18 boardgames Board Games Board Games 0 0 Topic :: Games/Entertainment :: Board Games 18 :: 80 :: 287
3587 268 2000082101 80 18 Puzzles Puzzle Games Puzzle Games 0 0 Topic :: Games/Entertainment :: Puzzle Games 18 :: 80 :: 268
3588 86 2000031601 80 18 mud Multi-User Dungeons (MUD) Massively-multiplayer text based games. 0 0 Topic :: Games/Entertainment :: Multi-User Dungeons (MUD) 18 :: 80 :: 86
3589 85 2000031601 80 18 simulation Simulation Simulation games 0 0 Topic :: Games/Entertainment :: Simulation 18 :: 80 :: 85
3590 84 2000031601 80 18 rpg Role-Playing Role-Playing games 0 0 Topic :: Games/Entertainment :: Role-Playing 18 :: 80 :: 84
3591 83 2000032401 80 18 turnbasedstrategy Turn Based Strategy Turn Based Strategy 0 0 Topic :: Games/Entertainment :: Turn Based Strategy 18 :: 80 :: 83
3592 82 2000031601 80 18 firstpersonshooters First Person Shooters First Person Shooters. 0 0 Topic :: Games/Entertainment :: First Person Shooters 18 :: 80 :: 82
3593 81 2000031601 80 18 realtimestrategy Real Time Strategy Real Time strategy games 0 0 Topic :: Games/Entertainment :: Real Time Strategy 18 :: 80 :: 81
3594 288 2001032001 80 18 sidescrolling Side-Scrolling/Arcade Games Arcade-style side-scrolling games 0 0 Topic :: Games/Entertainment :: Side-Scrolling/Arcade Games 18 :: 80 :: 288
3595 71 2000031601 18 18 education Education Programs and tools for educating yourself or others. 0 0 Topic :: Education 18 :: 71
3596 73 2000031601 71 18 testing Testing Tools for testing someone's knowledge on a subject. 0 0 Topic :: Education :: Testing 18 :: 71 :: 73
3597 72 2000031601 71 18 cai Computer Aided Instruction (CAI) Programs for authoring or using Computer Aided Instrution courses. 0 0 Topic :: Education :: Computer Aided Instruction (CAI) 18 :: 71 :: 72
3598 66 2000031601 18 18 database Database Front ends, engines, and tools for database work. 0 0 Topic :: Database 18 :: 66
3599 68 2000031601 66 18 frontends Front-Ends Clients and front-ends for generating queries to database engines. 0 0 Topic :: Database :: Front-Ends 18 :: 66 :: 68
3600 67 2000031601 66 18 engines Database Engines/Servers Programs that manage data and provide control via some query language. 0 0 Topic :: Database :: Database Engines/Servers 18 :: 66 :: 67
3601 63 2000032001 18 18 editors Text Editors Programs for editing code and documents. 0 0 Topic :: Text Editors 18 :: 63
3602 285 2001032001 63 18 textprocessing Text Processing Programs or libraries that are designed to batch process text documents 0 0 Topic :: Text Editors :: Text Processing 18 :: 63 :: 285
3603 70 2000031601 63 18 wordprocessors Word Processors WYSIWYG word processors. 0 0 Topic :: Text Editors :: Word Processors 18 :: 63 :: 70
3604 69 2000031601 63 18 documentation Documentation Tools for the creation and use of documentation. 0 0 Topic :: Text Editors :: Documentation 18 :: 63 :: 69
3605 65 2000031601 63 18 ide Integrated Development Environments (IDE) Complete editing environments for code, including cababilities such as compilation and code building assistance. 0 0 Topic :: Text Editors :: Integrated Development Environments (IDE) 18 :: 63 :: 65
3606 64 2000031601 63 18 emacs Emacs GNU Emacs and its imitators and tools. 0 0 Topic :: Text Editors :: Emacs 18 :: 63 :: 64
3607 125 2000031701 99 18 video Video Video capture, editing, and playback. 0 0 Topic :: Multimedia :: Video 18 :: 99 :: 125
3608 126 2000031701 125 18 capture Capture Video capture tools. 0 0 Topic :: Multimedia :: Video :: Capture 18 :: 99 :: 125 :: 126
3609 256 2000071101 125 18 nonlineareditor Non-Linear Editor Video Non-Linear Editors 0 0 Topic :: Multimedia :: Video :: Non-Linear Editor 18 :: 99 :: 125 :: 256
3610 128 2000031701 125 18 display Display Programs which display various video formats. 0 0 Topic :: Multimedia :: Video :: Display 18 :: 99 :: 125 :: 128
3611 127 2000031701 125 18 conversion Conversion Programs which convert between video formats. 0 0 Topic :: Multimedia :: Video :: Conversion 18 :: 99 :: 125 :: 127
3612 113 2000031701 99 18 sound Sound/Audio Tools for generating, editing, analyzing, and playing sound. 0 0 Topic :: Multimedia :: Sound/Audio 18 :: 99 :: 113
3613 249 2000042801 113 18 synthesis Sound Synthesis Software for creation and synthesis of sound. 0 0 Topic :: Multimedia :: Sound/Audio :: Sound Synthesis 18 :: 99 :: 113 :: 249
3614 248 2000042801 113 18 midi MIDI Software related to MIDI synthesis and playback. 0 0 Topic :: Multimedia :: Sound/Audio :: MIDI 18 :: 99 :: 113 :: 248
3615 124 2000031701 113 18 speech Speech Speech manipulation and intepretation tools. 0 0 Topic :: Multimedia :: Sound/Audio :: Speech 18 :: 99 :: 113 :: 124
3616 122 2000031701 113 18 players Players Programs to play audio files to a sound device. 0 0 Topic :: Multimedia :: Sound/Audio :: Players 18 :: 99 :: 113 :: 122
3617 123 2000031701 122 18 mp3 MP3 Programs to play MP3 audio files. 0 0 Topic :: Multimedia :: Sound/Audio :: Players :: MP3 18 :: 99 :: 113 :: 122 :: 123
3618 121 2000031701 113 18 mixers Mixers Programs to mix audio. 0 0 Topic :: Multimedia :: Sound/Audio :: Mixers 18 :: 99 :: 113 :: 121
3619 120 2000031701 113 18 editors Editors Programs to edit/manipulate sound data. 0 0 Topic :: Multimedia :: Sound/Audio :: Editors 18 :: 99 :: 113 :: 120
3620 119 2000031701 113 18 conversion Conversion Programs to convert between audio formats. 0 0 Topic :: Multimedia :: Sound/Audio :: Conversion 18 :: 99 :: 113 :: 119
3621 116 2000031701 113 18 cdaudio CD Audio Programs to play and manipulate audio CDs. 0 0 Topic :: Multimedia :: Sound/Audio :: CD Audio 18 :: 99 :: 113 :: 116
3622 88 2000031601 87 18 finger Finger The Finger protocol for getting information about users. 0 0 Topic :: Internet :: Finger 18 :: 87 :: 88
3623 118 2000031701 116 18 cdripping CD Ripping Software to convert CD Audio to other digital formats. 0 0 Topic :: Multimedia :: Sound/Audio :: CD Audio :: CD Ripping 18 :: 99 :: 113 :: 116 :: 118
3624 117 2000031701 116 18 cdplay CD Playing CD Playing software, to include jukebox software. 0 0 Topic :: Multimedia :: Sound/Audio :: CD Audio :: CD Playing 18 :: 99 :: 113 :: 116 :: 117
3625 260 2000071401 52 18 SCCS SCCS SCCS 0 0 Topic :: Software Development :: Version Control :: SCCS 18 :: 45 :: 52 :: 260
3626 54 2000031601 52 18 rcs RCS Tools for RCS (Revision Control System). 0 0 Topic :: Software Development :: Version Control :: RCS 18 :: 45 :: 52 :: 54
3627 53 2000031601 52 18 cvs CVS Tools for CVS (Concurrent Versioning System). 0 0 Topic :: Software Development :: Version Control :: CVS 18 :: 45 :: 52 :: 53
3628 50 2000031601 45 18 objectbrokering Object Brokering Object brokering libraries and tools. 0 0 Topic :: Software Development :: Object Brokering 18 :: 45 :: 50
3629 51 2000031601 50 18 corba CORBA Tools for implementation and use of CORBA. 0 0 Topic :: Software Development :: Object Brokering :: CORBA 18 :: 45 :: 50 :: 51
3630 49 2000031601 45 18 interpreters Interpreters Programs for interpreting and executing high-level languages directly. 0 0 Topic :: Software Development :: Interpreters 18 :: 45 :: 49
3631 48 2000031601 45 18 compilers Compilers Programs for compiling high-level languges into machine code. 0 0 Topic :: Software Development :: Compilers 18 :: 45 :: 48
3632 47 2000031601 45 18 debuggers Debuggers Programs for controlling and monitoring the execution of compiled binaries. 0 0 Topic :: Software Development :: Debuggers 18 :: 45 :: 47
3633 46 2000031601 45 18 build Build Tools Software for the build process. 0 0 Topic :: Software Development :: Build Tools 18 :: 45 :: 46
3634 43 2000031601 18 18 security Security Security-related software, to include system administration and cryptography. 0 0 Topic :: Security 18 :: 43
3635 44 2000031601 43 18 cryptography Cryptography Cryptography programs, algorithms, and libraries. 0 0 Topic :: Security :: Cryptography 18 :: 43 :: 44
3636 97 2000042701 18 18 scientific Scientific/Engineering Scientific applications, to include research, applied and pure mathematics and sciences. 0 0 Topic :: Scientific/Engineering 18 :: 97
3637 98 2000031601 97 18 mathematics Mathematics Software to support pure and applied mathematics. 0 0 Topic :: Scientific/Engineering :: Mathematics 18 :: 97 :: 98
3638 272 2000100501 97 18 HMI Human Machine Interfaces This applies to the Factory/Machine control/Automation fields where there are already thousands of applications and millions of installations. 0 0 Topic :: Scientific/Engineering :: Human Machine Interfaces 18 :: 97 :: 272
3639 266 2000081601 97 18 medical Medical Science Apps. Medical / BioMedical Science Apps. 0 0 Topic :: Scientific/Engineering :: Medical Science Apps. 18 :: 97 :: 266
3640 252 2000071101 97 18 bioinformatics Bio-Informatics Category for gene software (e.g. Gene Ontology) 0 0 Topic :: Scientific/Engineering :: Bio-Informatics 18 :: 97 :: 252
3641 246 2000042701 97 18 eda Electronic Design Automation (EDA) Tools for circuit design, schematics, board layout, and more. 0 0 Topic :: Scientific/Engineering :: Electronic Design Automation (EDA) 18 :: 97 :: 246
3642 135 2000032001 97 18 visualization Visualization Software for scientific visualization. 0 0 Topic :: Scientific/Engineering :: Visualization 18 :: 97 :: 135
3643 134 2000032001 97 18 astronomy Astronomy Software and tools related to astronomy. 0 0 Topic :: Scientific/Engineering :: Astronomy 18 :: 97 :: 134
3644 133 2000032001 97 18 ai Artificial Intelligence Artificial Intelligence. 0 0 Topic :: Scientific/Engineering :: Artificial Intelligence 18 :: 97 :: 133
3645 87 2000031601 18 18 internet Internet Tools to assist human access to the Internet. 0 0 Topic :: Internet 18 :: 87
3646 270 2000083101 87 18 WAP WAP Wireless Access Protocol 0 0 Topic :: Internet :: WAP 18 :: 87 :: 270
3647 245 2000042701 87 18 loganalysis Log Analysis Software to help analyze various log files. 0 0 Topic :: Internet :: Log Analysis 18 :: 87 :: 245
3648 149 2000032001 87 18 dns Name Service (DNS) Domain name system servers and utilities. 0 0 Topic :: Internet :: Name Service (DNS) 18 :: 87 :: 149
3649 90 2000031601 87 18 www WWW/HTTP Programs and tools for the World Wide Web. 0 0 Topic :: Internet :: WWW/HTTP 18 :: 87 :: 90
3650 250 2000042801 90 18 httpservers HTTP Servers Software designed to serve content via the HTTP protocol. 0 0 Topic :: Internet :: WWW/HTTP :: HTTP Servers 18 :: 87 :: 90 :: 250
3651 243 2000042701 90 18 sitemanagement Site Management Tools for maintanance and management of web sites. 0 0 Topic :: Internet :: WWW/HTTP :: Site Management 18 :: 87 :: 90 :: 243
3652 244 2000042701 243 18 linkchecking Link Checking Tools to assist in checking for broken links. 0 0 Topic :: Internet :: WWW/HTTP :: Site Management :: Link Checking 18 :: 87 :: 90 :: 243 :: 244
3653 93 2000031601 90 18 indexing Indexing/Search Indexing and search tools for the Web. 0 0 Topic :: Internet :: WWW/HTTP :: Indexing/Search 18 :: 87 :: 90 :: 93
3654 92 2000031601 90 18 dynamic Dynamic Content Common Gateway Interface scripting and server-side parsing. 0 0 Topic :: Internet :: WWW/HTTP :: Dynamic Content 18 :: 87 :: 90 :: 92
3655 96 2000031601 92 18 cgi CGI Tools/Libraries Tools for the Common Gateway Interface 0 0 Topic :: Internet :: WWW/HTTP :: Dynamic Content :: CGI Tools/Libraries 18 :: 87 :: 90 :: 92 :: 96
3656 95 2000031601 92 18 messageboards Message Boards Online message boards 0 0 Topic :: Internet :: WWW/HTTP :: Dynamic Content :: Message Boards 18 :: 87 :: 90 :: 92 :: 95
3657 94 2000031601 92 18 counters Page Counters Scripts to count numbers of pageviews. 0 0 Topic :: Internet :: WWW/HTTP :: Dynamic Content :: Page Counters 18 :: 87 :: 90 :: 92 :: 94
3658 91 2000031601 90 18 browsers Browsers Web Browsers 0 0 Topic :: Internet :: WWW/HTTP :: Browsers 18 :: 87 :: 90 :: 91
3659 89 2000031601 87 18 ftp File Transfer Protocol (FTP) Programs and tools for file transfer via FTP. 0 0 Topic :: Internet :: File Transfer Protocol (FTP) 18 :: 87 :: 89
3660 80 2000031601 18 18 games Games/Entertainment Games and Entertainment software. 0 0 Topic :: Games/Entertainment 18 :: 80
3661 18 2000031601 0 0 topic Topic Topic categorization. 0 0 Topic 18
3662 20 2000032401 18 18 communications Communications Programs intended to facilitate communication between people. 0 0 Topic :: Communications 18 :: 20
3663 27 2000031601 20 18 conferencing Conferencing Software to support real-time conferencing over the Internet. 0 0 Topic :: Communications :: Conferencing 18 :: 20 :: 27
3664 22 2000031601 20 18 chat Chat Programs to support real-time communication over the Internet. 0 0 Topic :: Communications :: Chat 18 :: 20 :: 22
3665 26 2000031601 22 18 aim AOL Instant Messanger Programs to support AOL Instant Messanger. 0 0 Topic :: Communications :: Chat :: AOL Instant Messanger 18 :: 20 :: 22 :: 26
3666 25 2000031601 22 18 talk Unix Talk Programs to support Unix Talk protocol. 0 0 Topic :: Communications :: Chat :: Unix Talk 18 :: 20 :: 22 :: 25
3667 24 2000041101 22 18 irc Internet Relay Chat Programs to support Internet Relay Chat. 0 0 Topic :: Communications :: Chat :: Internet Relay Chat 18 :: 20 :: 22 :: 24
3668 23 2000031601 22 18 icq ICQ Programs to support ICQ. 0 0 Topic :: Communications :: Chat :: ICQ 18 :: 20 :: 22 :: 23
3669 21 2000031601 20 18 bbs BBS Bulletin Board systems. 0 0 Topic :: Communications :: BBS 18 :: 20 :: 21
3670 251 2000050101 20 18 filesharing File Sharing Software for person-to-person online file sharing. 0 0 Topic :: Communications :: File Sharing 18 :: 20 :: 251
3671 241 2000050101 251 18 napster Napster Clients and servers for the Napster file sharing protocol. 0 0 Topic :: Communications :: File Sharing :: Napster 18 :: 20 :: 251 :: 241
3672 286 2001032001 251 18 gnutella Gnutella Projects based around the gnutella protocol. 0 0 Topic :: Communications :: File Sharing :: Gnutella 18 :: 20 :: 251 :: 286
3673 247 2000042701 20 18 telephony Telephony Telephony related applications, to include automated voice response systems. 0 0 Topic :: Communications :: Telephony 18 :: 20 :: 247
3674 40 2000031601 20 18 internetphone Internet Phone Software to support real-time speech communication over the Internet. 0 0 Topic :: Communications :: Internet Phone 18 :: 20 :: 40
3675 39 2000031601 20 18 usenet Usenet News Software to support USENET news. 0 0 Topic :: Communications :: Usenet News 18 :: 20 :: 39
3676 38 2000031601 20 18 hamradio Ham Radio Tools and resources for amateur radio. 0 0 Topic :: Communications :: Ham Radio 18 :: 20 :: 38
3677 37 2000031601 20 18 fido FIDO Tools for FIDOnet mail and echoes. 0 0 Topic :: Communications :: FIDO 18 :: 20 :: 37
3678 36 2000031601 20 18 fax Fax Tools for sending and receiving facsimile messages. 0 0 Topic :: Communications :: Fax 18 :: 20 :: 36
3679 28 2000031601 20 18 email Email Programs for sending, processing, and handling electronic mail. 0 0 Topic :: Communications :: Email 18 :: 20 :: 28
3680 33 2000031601 28 18 postoffice Post-Office Programs to support post-office protocols, including POP and IMAP. 0 0 Topic :: Communications :: Email :: Post-Office 18 :: 20 :: 28 :: 33
3681 35 2000031601 33 18 imap IMAP Programs to support IMAP protocol (Internet Message Access Protocol). 0 0 Topic :: Communications :: Email :: Post-Office :: IMAP 18 :: 20 :: 28 :: 33 :: 35
3682 34 2000031601 33 18 pop3 POP3 Programs to support POP3 (Post-Office Protocol, version 3). 0 0 Topic :: Communications :: Email :: Post-Office :: POP3 18 :: 20 :: 28 :: 33 :: 34
3683 32 2000031601 28 18 mta Mail Transport Agents Email transport and gatewaying software. 0 0 Topic :: Communications :: Email :: Mail Transport Agents 18 :: 20 :: 28 :: 32
3684 31 2000031601 28 18 mua Email Clients (MUA) Programs for interactively reading and sending Email. 0 0 Topic :: Communications :: Email :: Email Clients (MUA) 18 :: 20 :: 28 :: 31
3685 30 2000031601 28 18 listservers Mailing List Servers Tools for managing electronic mailing lists. 0 0 Topic :: Communications :: Email :: Mailing List Servers 18 :: 20 :: 28 :: 30
3686 29 2000031601 28 18 filters Filters Content-driven filters and dispatchers for Email. 0 0 Topic :: Communications :: Email :: Filters 18 :: 20 :: 28 :: 29
3687 301 2001041701 14 13 nosl Nokia Open Source License Nokia Open Source License 0 0 License :: OSI Approved :: Nokia Open Source License 13 :: 14 :: 301
3688 299 2001041701 14 13 iosl Intel Open Source License Intel Open Source License 0 0 License :: OSI Approved :: Intel Open Source License 13 :: 14 :: 299
3689 297 2001041701 14 13 vsl Vovida Software License Vovida Software License 0 0 License :: OSI Approved :: Vovida Software License 13 :: 14 :: 297
3690 195 2000032001 14 13 zlib zlib/libpng License zlib/libpng License 0 0 License :: OSI Approved :: zlib/libpng License 13 :: 14 :: 195
3691 194 2000032001 14 13 python Python License Python License 0 0 License :: OSI Approved :: Python License 13 :: 14 :: 194
3692 193 2000032001 14 13 ricoh Ricoh Source Code Public License Ricoh Source Code Public License 0 0 License :: OSI Approved :: Ricoh Source Code Public License 13 :: 14 :: 193
3693 192 2000032001 14 13 cvw MITRE Collaborative Virtual Workspace License (CVW) MITRE Collaborative Virtual Workspace License (CVW) 0 0 License :: OSI Approved :: MITRE Collaborative Virtual Workspace License (CVW) 13 :: 14 :: 192
3694 191 2000032001 14 13 ibm IBM Public License IBM Public License 0 0 License :: OSI Approved :: IBM Public License 13 :: 14 :: 191
3695 190 2000032001 14 13 qpl QT Public License (QPL) QT Public License 0 0 License :: OSI Approved :: QT Public License (QPL) 13 :: 14 :: 190
3696 189 2000032001 14 13 mpl Mozilla Public License (MPL) Mozilla Public License (MPL) 0 0 License :: OSI Approved :: Mozilla Public License (MPL) 13 :: 14 :: 189
3697 305 2001041701 189 13 mpl11 Mozilla Public License 1.1 Mozilla Public License 1.1 0 0 License :: OSI Approved :: Mozilla Public License (MPL) :: Mozilla Public License 1.1 13 :: 14 :: 189 :: 305
3698 199 2000032101 0 0 os Operating System What operating system the program requires to run, if any. 0 0 Operating System 199
3699 200 2000032101 199 199 posix POSIX POSIX plus standard Berkeley socket facilities. Don't list a more specific OS unless your program requires it. 0 0 Operating System :: POSIX 199 :: 200
3700 201 2000032101 200 199 linux Linux Any version of Linux. Don't specify a subcategory unless the program requires a particular distribution. 0 0 Operating System :: POSIX :: Linux 199 :: 200 :: 201
3701 202 2000032101 200 199 bsd BSD Any variant of BSD. Don't specify a subcategory unless the program requires a particular BSD flavor. 0 0 Operating System :: POSIX :: BSD 199 :: 200 :: 202
3702 203 2000041101 202 199 freebsd FreeBSD FreeBSD 0 0 Operating System :: POSIX :: BSD :: FreeBSD 199 :: 200 :: 202 :: 203
3703 204 2000032101 202 199 netbsd NetBSD NetBSD 0 0 Operating System :: POSIX :: BSD :: NetBSD 199 :: 200 :: 202 :: 204
3704 205 2000032101 202 199 openbsd OpenBSD OpenBSD 0 0 Operating System :: POSIX :: BSD :: OpenBSD 199 :: 200 :: 202 :: 205
3705 206 2000032101 202 199 bsdos BSD/OS BSD/OS 0 0 Operating System :: POSIX :: BSD :: BSD/OS 199 :: 200 :: 202 :: 206
3706 207 2000032101 200 199 sun SunOS/Solaris Any Sun Microsystems OS. 0 0 Operating System :: POSIX :: SunOS/Solaris 199 :: 200 :: 207
3707 208 2000032101 200 199 sco SCO SCO 0 0 Operating System :: POSIX :: SCO 199 :: 200 :: 208
3708 209 2000032101 200 199 hpux HP-UX HP-UX 0 0 Operating System :: POSIX :: HP-UX 199 :: 200 :: 209
3709 210 2000032101 200 199 aix AIX AIX 0 0 Operating System :: POSIX :: AIX 199 :: 200 :: 210
3710 211 2000032101 200 199 irix IRIX IRIX 0 0 Operating System :: POSIX :: IRIX 199 :: 200 :: 211
3711 212 2000032101 200 199 other Other Other specific POSIX OS, specified in description. 0 0 Operating System :: POSIX :: Other 199 :: 200 :: 212
3712 282 2000121901 18 18 Sociology Sociology Social / Informational - Family / etc. 0 0 Topic :: Sociology 18 :: 282
3713 214 2000032101 199 199 microsoft Microsoft Microsoft operating systems. 0 0 Operating System :: Microsoft 199 :: 214
3714 215 2000032101 214 199 msdos MS-DOS Microsoft Disk Operating System (DOS) 0 0 Operating System :: Microsoft :: MS-DOS 199 :: 214 :: 215
3715 216 2000032101 214 199 windows Windows Windows software, not specific to any particular version of Windows. 0 0 Operating System :: Microsoft :: Windows 199 :: 214 :: 216
3716 217 2000032101 216 199 win31 Windows 3.1 or Earlier Windows 3.1 or Earlier 0 0 Operating System :: Microsoft :: Windows :: Windows 3.1 or Earlier 199 :: 214 :: 216 :: 217
3717 218 2000032101 216 199 win95 Windows 95/98/2000 Windows 95, Windows 98, and Windows 2000. 0 0 Operating System :: Microsoft :: Windows :: Windows 95/98/2000 199 :: 214 :: 216 :: 218
3718 219 2000041101 216 199 winnt Windows NT/2000 Windows NT and Windows 2000. 0 0 Operating System :: Microsoft :: Windows :: Windows NT/2000 199 :: 214 :: 216 :: 219
3719 220 2000032101 199 199 os2 OS/2 OS/2 0 0 Operating System :: OS/2 199 :: 220
3720 221 2000032101 199 199 macos MacOS MacOS 0 0 Operating System :: MacOS 199 :: 221
3721 222 2000032101 216 199 wince Windows CE Windows CE 0 0 Operating System :: Microsoft :: Windows :: Windows CE 199 :: 214 :: 216 :: 222
3722 223 2000032101 199 199 palmos PalmOS PalmOS (for Palm Pilot) 0 0 Operating System :: PalmOS 199 :: 223
3723 224 2000032101 199 199 beos BeOS BeOS 0 0 Operating System :: BeOS 199 :: 224
3724 225 2000032101 0 0 environment Environment Run-time environment required for this program. 0 0 Environment 225
3725 226 2000041101 225 225 console Console (Text Based) Console-based programs. 0 0 Environment :: Console (Text Based) 225 :: 226
3726 227 2000032401 226 225 curses Curses Curses-based software. 0 0 Environment :: Console (Text Based) :: Curses 225 :: 226 :: 227
3727 228 2000040701 226 225 newt Newt Newt 0 0 Environment :: Console (Text Based) :: Newt 225 :: 226 :: 228
3728 229 2000040701 225 225 x11 X11 Applications Programs that run in an X windowing environment. 0 0 Environment :: X11 Applications 225 :: 229
3729 230 2000040701 225 225 win32 Win32 (MS Windows) Programs designed to run in a graphical Microsoft Windows environment. 0 0 Environment :: Win32 (MS Windows) 225 :: 230
3730 231 2000040701 229 225 gnome Gnome Programs designed to run in a Gnome environment. 0 0 Environment :: X11 Applications :: Gnome 225 :: 229 :: 231
3731 232 2000040701 229 225 kde KDE Programs designed to run in a KDE environment. 0 0 Environment :: X11 Applications :: KDE 225 :: 229 :: 232
3732 233 2000040701 225 225 other Other Environment Programs designed to run in an environment other than one listed. 0 0 Environment :: Other Environment 225 :: 233
3733 283 2000121901 282 18 History History History / Informational 0 0 Topic :: Sociology :: History 18 :: 282 :: 283
3734 235 2000041001 199 199 independent OS Independent This software does not depend on any particular operating system. 0 0 Operating System :: OS Independent 199 :: 235
3735 236 2000040701 199 199 other Other OS Program is designe for a nonlisted operating system. 0 0 Operating System :: Other OS 199 :: 236
3736 237 2000041001 225 225 web Web Environment This software is designed for a web environment. 0 0 Environment :: Web Environment 225 :: 237
3737 238 2000041101 225 225 daemon No Input/Output (Daemon) This program has no input or output, but is intended to run in the background as a daemon. 0 0 Environment :: No Input/Output (Daemon) 225 :: 238
3738 284 2000121901 282 18 Genealogy Genealogy Family History / Genealogy 0 0 Topic :: Sociology :: Genealogy 18 :: 282 :: 284
3739 240 2000041301 200 199 gnuhurd GNU Hurd GNU Hurd 0 0 Operating System :: POSIX :: GNU Hurd 199 :: 200 :: 240
3740 55 2000031601 18 18 desktop Desktop Environment Accessories, managers, and utilities for your GUI desktop. 0 0 Topic :: Desktop Environment 18 :: 55
3741 58 2000031601 55 18 gnome Gnome Software for the Gnome desktop. 0 0 Topic :: Desktop Environment :: Gnome 18 :: 55 :: 58
3742 57 2000031601 55 18 kde K Desktop Environment (KDE) Software for the KDE desktop. 0 0 Topic :: Desktop Environment :: K Desktop Environment (KDE) 18 :: 55 :: 57
3743 61 2000031601 57 18 themes Themes Themes for KDE. 0 0 Topic :: Desktop Environment :: K Desktop Environment (KDE) :: Themes 18 :: 55 :: 57 :: 61
3744 56 2000031601 55 18 windowmanagers Window Managers Programs that provide window control and application launching. 0 0 Topic :: Desktop Environment :: Window Managers 18 :: 55 :: 56
3745 59 2000031601 56 18 enlightenment Enlightenment Software for the Enlightenment window manager. 0 0 Topic :: Desktop Environment :: Window Managers :: Enlightenment 18 :: 55 :: 56 :: 59
3746 60 2000031601 59 18 themes Themes Themes for the Enlightenment window manager. 0 0 Topic :: Desktop Environment :: Window Managers :: Enlightenment :: Themes 18 :: 55 :: 56 :: 59 :: 60
3747 62 2000031601 55 18 screensavers Screen Savers Screen savers and lockers. 0 0 Topic :: Desktop Environment :: Screen Savers 18 :: 55 :: 62
3748 259 2000071401 45 18 codegen Code Generators Code Generators 0 0 Topic :: Software Development :: Code Generators 18 :: 45 :: 259
3749 52 2000031601 45 18 versioncontrol Version Control Tools for managing multiple versions of evolving sources or documents. 0 0 Topic :: Software Development :: Version Control 18 :: 45 :: 52
3750 160 2000032001 0 0 language Programming Language Language in which this program was written, or was meant to support. 0 0 Programming Language 160
3751 161 2000032001 160 160 apl APL APL 0 0 Programming Language :: APL 160 :: 161
3752 164 2000032001 160 160 c C C 0 0 Programming Language :: C 160 :: 164
3753 162 2000032001 160 160 assembly Assembly Assembly-level programs. Platform specific. 0 0 Programming Language :: Assembly 160 :: 162
3754 163 2000051001 160 160 ada Ada Ada 0 0 Programming Language :: Ada 160 :: 163
3755 165 2000032001 160 160 cpp C++ C++ 0 0 Programming Language :: C++ 160 :: 165
3756 166 2000032401 160 160 eiffel Eiffel Eiffel 0 0 Programming Language :: Eiffel 160 :: 166
3757 167 2000032001 160 160 euler Euler Euler 0 0 Programming Language :: Euler 160 :: 167
3758 168 2000032001 160 160 forth Forth Forth 0 0 Programming Language :: Forth 160 :: 168
3759 169 2000032001 160 160 fortran Fortran Fortran 0 0 Programming Language :: Fortran 160 :: 169
3760 170 2000032001 160 160 lisp Lisp Lisp 0 0 Programming Language :: Lisp 160 :: 170
3761 171 2000041101 160 160 logo Logo Logo 0 0 Programming Language :: Logo 160 :: 171
3762 172 2000032001 160 160 ml ML ML 0 0 Programming Language :: ML 160 :: 172
3763 173 2000032001 160 160 modula Modula Modula-2 or Modula-3 0 0 Programming Language :: Modula 160 :: 173
3764 174 2000032001 160 160 objectivec Objective C Objective C 0 0 Programming Language :: Objective C 160 :: 174
3765 175 2000032001 160 160 pascal Pascal Pascal 0 0 Programming Language :: Pascal 160 :: 175
3766 176 2000032001 160 160 perl Perl Perl 0 0 Programming Language :: Perl 160 :: 176
3767 177 2000032001 160 160 prolog Prolog Prolog 0 0 Programming Language :: Prolog 160 :: 177
3768 178 2000032001 160 160 python Python Python 0 0 Programming Language :: Python 160 :: 178
3769 179 2000032001 160 160 rexx Rexx Rexx 0 0 Programming Language :: Rexx 160 :: 179
3770 180 2000032001 160 160 simula Simula Simula 0 0 Programming Language :: Simula 160 :: 180
3771 181 2000032001 160 160 smalltalk Smalltalk Smalltalk 0 0 Programming Language :: Smalltalk 160 :: 181
3772 182 2000032001 160 160 tcl Tcl Tcl 0 0 Programming Language :: Tcl 160 :: 182
3773 183 2000032001 160 160 php PHP PHP 0 0 Programming Language :: PHP 160 :: 183
3774 263 2000080401 160 160 euphoria Euphoria Euphoria programming language - http://www.rapideuphoria.com/ 0 0 Programming Language :: Euphoria 160 :: 263
3775 264 2000080701 160 160 erlang Erlang Erlang - developed by Ericsson - http://www.erlang.org/ 0 0 Programming Language :: Erlang 160 :: 264
3776 267 2000082001 160 160 zope Zope Zope Object Publishing 0 0 Programming Language :: Zope 160 :: 267
3777 269 2000082801 160 160 asm Assembly ASM programming 0 0 Programming Language :: Assembly 160 :: 269
3778 271 2000092001 160 160 csharp C# Microsoft's C++/Java Language 0 0 Programming Language :: C# 160 :: 271
3779 273 2000102001 160 160 Pike Pike Pike, see http://pike.roxen.com/. 0 0 Programming Language :: Pike 160 :: 273
3780 184 2000032001 160 160 asp ASP Active Server Pages 0 0 Programming Language :: ASP 160 :: 184
3781 185 2000032001 160 160 shell Unix Shell Unix Shell 0 0 Programming Language :: Unix Shell 160 :: 185
3782 186 2000032001 160 160 visualbasic Visual Basic Visual Basic 0 0 Programming Language :: Visual Basic 160 :: 186
3783 198 2000032001 160 160 java Java Java 0 0 Programming Language :: Java 160 :: 198
3784 213 2000032101 160 160 other Other Other programming language, specified in description. 0 0 Programming Language :: Other 160 :: 213
3785 242 2000042701 160 160 scheme Scheme Scheme programming language. 0 0 Programming Language :: Scheme 160 :: 242
3786 254 2000071101 160 160 plsql PL/SQL PL/SQL Programming Language 0 0 Programming Language :: PL/SQL 160 :: 254
3787 255 2000071101 160 160 progress PROGRESS PROGRESS Programming Language 0 0 Programming Language :: PROGRESS 160 :: 255
3788 258 2000071101 160 160 objectpascal Object Pascal Object Pascal 0 0 Programming Language :: Object Pascal 160 :: 258
3789 261 2000072501 160 160 xbasic XBasic XBasic programming language 0 0 Programming Language :: XBasic 160 :: 261
3790 262 2000073101 160 160 coldfusion Cold Fusion Cold Fusion Language 0 0 Programming Language :: Cold Fusion 160 :: 262
3791 304 2001041701 189 13 mpl10 Mozilla Public License 1.0 Mozilla Public License 1.0 0 0 License :: OSI Approved :: Mozilla Public License (MPL) :: Mozilla Public License 1.0 13 :: 14 :: 189 :: 304
3792 188 2000032001 14 13 mit MIT/X Consortium License MIT License, also the X Consortium License. 0 0 License :: OSI Approved :: MIT/X Consortium License 13 :: 14 :: 188
3793 187 2000032001 14 13 bsd BSD License BSD License 0 0 License :: OSI Approved :: BSD License 13 :: 14 :: 187
3794 17 2000032001 14 13 artistic Artistic License The Perl Artistic License 0 0 License :: OSI Approved :: Artistic License 13 :: 14 :: 17
3795 16 2000050801 14 13 lgpl GNU Lesser General Public License (LGPL) GNU Lesser General Public License 0 0 License :: OSI Approved :: GNU Lesser General Public License (LGPL) 13 :: 14 :: 16
3796 15 2000032001 14 13 gpl GNU General Public License (GPL) GNU General Public License. 0 0 License :: OSI Approved :: GNU General Public License (GPL) 13 :: 14 :: 15
3797 280 2000110101 160 160 JavaScript JavaScript Java Scripting Language 0 0 Programming Language :: JavaScript 160 :: 280
3798 281 2000111401 160 160 REBOL REBOL REBOL Programming Language 0 0 Programming Language :: REBOL 160 :: 281
3799 265 2001032001 160 160 Delphi Delphi/Kylix Borland/Inprise Delphi or other Object-Pascal based languages 0 0 Programming Language :: Delphi/Kylix 160 :: 265
3800 293 2001032001 160 160 ruby Ruby Ruby programming language 0 0 Programming Language :: Ruby 160 :: 293
3801 45 2000031601 18 18 development Software Development Software used to aid software development. 0 0 Topic :: Software Development 18 :: 45
3802 99 2000031601 18 18 multimedia Multimedia Graphics, sound, video, and multimedia. 0 0 Topic :: Multimedia 18 :: 99
3803 296 2001041701 14 13 asl Apache Software License Apache Software License 0 0 License :: OSI Approved :: Apache Software License 13 :: 14 :: 296
3804 274 2000102401 0 0 natlanguage Natural Language The oral/written language for the development and use of this software. 0 0 Natural Language 274
3805 295 2001040601 274 274 russian Russian Projects having something to do with Russian Language 0 0 Natural Language :: Russian 274 :: 295
3806 275 2000102401 274 274 english English English 0 0 Natural Language :: English 274 :: 275
3807 276 2000102401 274 274 french French French 0 0 Natural Language :: French 274 :: 276
3808 277 2000102401 274 274 spanish Spanish Spanish 0 0 Natural Language :: Spanish 274 :: 277
3809 278 2000102601 274 274 japanese Japanese Projects using the Japanese language 0 0 Natural Language :: Japanese 274 :: 278
3810 279 2000102601 274 274 german German Projects using the German language 0 0 Natural Language :: German 274 :: 279
3811 298 2001041701 14 13 sissl Sun Internet Standards Source License Sun Internet Standards Source License 0 0 License :: OSI Approved :: Sun Internet Standards Source License 13 :: 14 :: 298
3812 300 2001041701 14 13 josl Jabber Open Source License Jabber Open Source License 0 0 License :: OSI Approved :: Jabber Open Source License 13 :: 14 :: 300
3813 302 2001041701 14 13 sleepycat Sleepycat License Sleepycat License 0 0 License :: OSI Approved :: Sleepycat License 13 :: 14 :: 302
3816 -- Data for TOC Entry ID 539 (OID 21825)
3818 -- Name: trove_group_link Type: TABLE DATA Owner: tperdue
3822 COPY "trove_group_link" FROM stdin;
3825 -- Data for TOC Entry ID 540 (OID 21885)
3827 -- Name: user_bookmarks Type: TABLE DATA Owner: tperdue
3831 COPY "user_bookmarks" FROM stdin;
3834 -- Data for TOC Entry ID 541 (OID 21937)
3836 -- Name: user_diary Type: TABLE DATA Owner: tperdue
3840 COPY "user_diary" FROM stdin;
3843 -- Data for TOC Entry ID 542 (OID 21993)
3845 -- Name: user_diary_monitor Type: TABLE DATA Owner: tperdue
3849 COPY "user_diary_monitor" FROM stdin;
3852 -- Data for TOC Entry ID 543 (OID 22030)
3854 -- Name: user_group Type: TABLE DATA Owner: tperdue
3858 COPY "user_group" FROM stdin;
3861 -- Data for TOC Entry ID 544 (OID 22088)
3863 -- Name: user_metric Type: TABLE DATA Owner: tperdue
3867 COPY "user_metric" FROM stdin;
3870 -- Data for TOC Entry ID 545 (OID 22135)
3872 -- Name: user_metric0 Type: TABLE DATA Owner: tperdue
3876 COPY "user_metric0" FROM stdin;
3879 -- Data for TOC Entry ID 546 (OID 22163)
3881 -- Name: user_preferences Type: TABLE DATA Owner: tperdue
3885 COPY "user_preferences" FROM stdin;
3888 -- Data for TOC Entry ID 547 (OID 22194)
3890 -- Name: user_ratings Type: TABLE DATA Owner: tperdue
3894 COPY "user_ratings" FROM stdin;
3897 -- Data for TOC Entry ID 548 (OID 22230)
3899 -- Name: users Type: TABLE DATA Owner: tperdue
3903 COPY "users" FROM stdin;
3904 100 None noreply@sourceforge.net *********34343 A /bin/bash N 0 shell1 0 \N 0 0 \N \N 0 GMT 1 0
3907 -- Data for TOC Entry ID 549 (OID 22336)
3909 -- Name: project_sums_agg Type: TABLE DATA Owner: tperdue
3913 COPY "project_sums_agg" FROM stdin;
3916 -- Data for TOC Entry ID 550 (OID 22388)
3918 -- Name: prdb_dbs Type: TABLE DATA Owner: tperdue
3922 COPY "prdb_dbs" FROM stdin;
3925 -- Data for TOC Entry ID 551 (OID 22425)
3927 -- Name: prdb_states Type: TABLE DATA Owner: tperdue
3931 COPY "prdb_states" FROM stdin;
3934 -- Data for TOC Entry ID 552 (OID 22451)
3936 -- Name: prdb_types Type: TABLE DATA Owner: tperdue
3940 COPY "prdb_types" FROM stdin;
3943 -- Data for TOC Entry ID 553 (OID 22500)
3945 -- Name: prweb_vhost Type: TABLE DATA Owner: tperdue
3949 COPY "prweb_vhost" FROM stdin;
3952 -- Data for TOC Entry ID 554 (OID 22552)
3954 -- Name: artifact_group_list Type: TABLE DATA Owner: tperdue
3958 COPY "artifact_group_list" FROM stdin;
3959 100 1 Default Default Data - Dont Edit 3 0 0 2592000 0 \N \N 0 \N
3962 -- Data for TOC Entry ID 555 (OID 22619)
3964 -- Name: artifact_resolution Type: TABLE DATA Owner: tperdue
3968 COPY "artifact_resolution" FROM stdin;
3971 -- Data for TOC Entry ID 556 (OID 22668)
3973 -- Name: artifact_perm Type: TABLE DATA Owner: tperdue
3977 COPY "artifact_perm" FROM stdin;
3980 -- Data for TOC Entry ID 557 (OID 22737)
3982 -- Name: artifact_category Type: TABLE DATA Owner: tperdue
3986 COPY "artifact_category" FROM stdin;
3990 -- Data for TOC Entry ID 558 (OID 22789)
3992 -- Name: artifact_group Type: TABLE DATA Owner: tperdue
3996 COPY "artifact_group" FROM stdin;
4000 -- Data for TOC Entry ID 559 (OID 22839)
4002 -- Name: artifact_status Type: TABLE DATA Owner: tperdue
4006 COPY "artifact_status" FROM stdin;
4012 -- Data for TOC Entry ID 560 (OID 22888)
4014 -- Name: artifact Type: TABLE DATA Owner: tperdue
4018 COPY "artifact" FROM stdin;
4021 -- Data for TOC Entry ID 561 (OID 22993)
4023 -- Name: artifact_history Type: TABLE DATA Owner: tperdue
4027 COPY "artifact_history" FROM stdin;
4030 -- Data for TOC Entry ID 562 (OID 23067)
4032 -- Name: artifact_file Type: TABLE DATA Owner: tperdue
4036 COPY "artifact_file" FROM stdin;
4039 -- Data for TOC Entry ID 563 (OID 23145)
4041 -- Name: artifact_message Type: TABLE DATA Owner: tperdue
4045 COPY "artifact_message" FROM stdin;
4048 -- Data for TOC Entry ID 564 (OID 23218)
4050 -- Name: artifact_monitor Type: TABLE DATA Owner: tperdue
4054 COPY "artifact_monitor" FROM stdin;
4057 -- Data for TOC Entry ID 565 (OID 23269)
4059 -- Name: artifact_canned_responses Type: TABLE DATA Owner: tperdue
4063 COPY "artifact_canned_responses" FROM stdin;
4066 -- Data for TOC Entry ID 566 (OID 23301)
4068 -- Name: artifact_counts_agg Type: TABLE DATA Owner: tperdue
4072 COPY "artifact_counts_agg" FROM stdin;
4076 -- Data for TOC Entry ID 567 (OID 23313)
4078 -- Name: stats_site_pages_by_day Type: TABLE DATA Owner: tperdue
4082 COPY "stats_site_pages_by_day" FROM stdin;
4085 -- Data for TOC Entry ID 568 (OID 23349)
4087 -- Name: massmail_queue Type: TABLE DATA Owner: tperdue
4091 COPY "massmail_queue" FROM stdin;
4094 -- Data for TOC Entry ID 569 (OID 23388)
4096 -- Name: frs_dlstats_file_agg Type: TABLE DATA Owner: tperdue
4100 COPY "frs_dlstats_file_agg" FROM stdin;
4103 -- Data for TOC Entry ID 570 (OID 23401)
4105 -- Name: stats_agg_site_by_group Type: TABLE DATA Owner: tperdue
4109 COPY "stats_agg_site_by_group" FROM stdin;
4112 -- Data for TOC Entry ID 571 (OID 23414)
4114 -- Name: stats_project_metric Type: TABLE DATA Owner: tperdue
4118 COPY "stats_project_metric" FROM stdin;
4121 -- Data for TOC Entry ID 572 (OID 23433)
4123 -- Name: stats_agg_logo_by_group Type: TABLE DATA Owner: tperdue
4127 COPY "stats_agg_logo_by_group" FROM stdin;
4130 -- Data for TOC Entry ID 573 (OID 23446)
4132 -- Name: stats_subd_pages Type: TABLE DATA Owner: tperdue
4136 COPY "stats_subd_pages" FROM stdin;
4139 -- Data for TOC Entry ID 574 (OID 23463)
4141 -- Name: stats_cvs_user Type: TABLE DATA Owner: tperdue
4145 COPY "stats_cvs_user" FROM stdin;
4148 -- Data for TOC Entry ID 575 (OID 23486)
4150 -- Name: stats_cvs_group Type: TABLE DATA Owner: tperdue
4154 COPY "stats_cvs_group" FROM stdin;
4157 -- Data for TOC Entry ID 576 (OID 23507)
4159 -- Name: stats_project_developers Type: TABLE DATA Owner: tperdue
4163 COPY "stats_project_developers" FROM stdin;
4166 -- Data for TOC Entry ID 577 (OID 23524)
4168 -- Name: stats_project Type: TABLE DATA Owner: tperdue
4172 COPY "stats_project" FROM stdin;
4175 -- Data for TOC Entry ID 578 (OID 23567)
4177 -- Name: stats_site Type: TABLE DATA Owner: tperdue
4181 COPY "stats_site" FROM stdin;
4184 -- Data for TOC Entry ID 579 (OID 23583)
4186 -- Name: activity_log_old_old Type: TABLE DATA Owner: tperdue
4190 COPY "activity_log_old_old" FROM stdin;
4193 -- Data for TOC Entry ID 580 (OID 23624)
4195 -- Name: activity_log_old Type: TABLE DATA Owner: tperdue
4199 COPY "activity_log_old" FROM stdin;
4202 -- Data for TOC Entry ID 581 (OID 23665)
4204 -- Name: activity_log Type: TABLE DATA Owner: tperdue
4208 COPY "activity_log" FROM stdin;
4211 -- Data for TOC Entry ID 582 (OID 23706)
4213 -- Name: cache_store Type: TABLE DATA Owner: tperdue
4218 -- Data for TOC Entry ID 583 (OID 25693)
4220 -- Name: user_metric_history Type: TABLE DATA Owner: tperdue
4224 COPY "user_metric_history" FROM stdin;
4227 -- Data for TOC Entry ID 584 (OID 25710)
4229 -- Name: foundry_project_rankings_agg Type: TABLE DATA Owner: tperdue
4233 COPY "foundry_project_rankings_agg" FROM stdin;
4236 -- Data for TOC Entry ID 585 (OID 25728)
4238 -- Name: foundry_project_downloads_agg Type: TABLE DATA Owner: tperdue
4242 COPY "foundry_project_downloads_agg" FROM stdin;
4245 -- Data for TOC Entry ID 586 (OID 25745)
4247 -- Name: frs_dlstats_filetotal_agg Type: TABLE DATA Owner: tperdue
4251 COPY "frs_dlstats_filetotal_agg" FROM stdin;
4254 -- Data for TOC Entry ID 587 (OID 25759)
4256 -- Name: frs_dlstats_grouptotal_agg Type: TABLE DATA Owner: tperdue
4260 COPY "frs_dlstats_grouptotal_agg" FROM stdin;
4263 -- Data for TOC Entry ID 588 (OID 25773)
4265 -- Name: frs_dlstats_group_agg Type: TABLE DATA Owner: tperdue
4269 COPY "frs_dlstats_group_agg" FROM stdin;
4272 -- Data for TOC Entry ID 589 (OID 25792)
4274 -- Name: stats_project_months Type: TABLE DATA Owner: tperdue
4278 COPY "stats_project_months" FROM stdin;
4281 -- Data for TOC Entry ID 590 (OID 25834)
4283 -- Name: stats_project_all Type: TABLE DATA Owner: tperdue
4287 COPY "stats_project_all" FROM stdin;
4290 -- Data for TOC Entry ID 591 (OID 25871)
4292 -- Name: stats_project_developers_last30 Type: TABLE DATA Owner: tperdue
4296 COPY "stats_project_developers_last30" FROM stdin;
4299 -- Data for TOC Entry ID 592 (OID 25884)
4301 -- Name: stats_project_last_30 Type: TABLE DATA Owner: tperdue
4305 COPY "stats_project_last_30" FROM stdin;
4308 -- Data for TOC Entry ID 593 (OID 25924)
4310 -- Name: stats_site_pages_by_month Type: TABLE DATA Owner: tperdue
4314 COPY "stats_site_pages_by_month" FROM stdin;
4317 -- Data for TOC Entry ID 594 (OID 25935)
4319 -- Name: stats_site_last_30 Type: TABLE DATA Owner: tperdue
4323 COPY "stats_site_last_30" FROM stdin;
4326 -- Data for TOC Entry ID 595 (OID 25967)
4328 -- Name: stats_site_months Type: TABLE DATA Owner: tperdue
4332 COPY "stats_site_months" FROM stdin;
4335 -- Data for TOC Entry ID 596 (OID 25998)
4337 -- Name: stats_site_all Type: TABLE DATA Owner: tperdue
4341 COPY "stats_site_all" FROM stdin;
4342 \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N
4345 -- Data for TOC Entry ID 597 (OID 26026)
4347 -- Name: trove_agg Type: TABLE DATA Owner: tperdue
4351 COPY "trove_agg" FROM stdin;
4354 -- Data for TOC Entry ID 598 (OID 26069)
4356 -- Name: trove_treesums Type: TABLE DATA Owner: tperdue
4360 COPY "trove_treesums" FROM stdin;
4363 -- TOC Entry ID 307 (OID 18793)
4365 -- Name: "db_images_group" Type: INDEX Owner: tperdue
4368 CREATE INDEX "db_images_group" on "db_images" using btree ( "group_id" "int4_ops" );
4371 -- TOC Entry ID 308 (OID 18859)
4373 -- Name: "doc_group_doc_group" Type: INDEX Owner: tperdue
4376 CREATE INDEX "doc_group_doc_group" on "doc_data" using btree ( "doc_group" "int4_ops" );
4379 -- TOC Entry ID 309 (OID 18924)
4381 -- Name: "doc_groups_group" Type: INDEX Owner: tperdue
4384 CREATE INDEX "doc_groups_group" on "doc_groups" using btree ( "group_id" "int4_ops" );
4387 -- TOC Entry ID 310 (OID 18996)
4389 -- Name: "filemodule_monitor_id" Type: INDEX Owner: tperdue
4392 CREATE INDEX "filemodule_monitor_id" on "filemodule_monitor" using btree ( "filemodule_id" "int4_ops" );
4395 -- TOC Entry ID 311 (OID 18996)
4397 -- Name: "filemodulemonitor_userid" Type: INDEX Owner: tperdue
4400 CREATE INDEX "filemodulemonitor_userid" on "filemodule_monitor" using btree ( "user_id" "int4_ops" );
4403 -- TOC Entry ID 312 (OID 19033)
4405 -- Name: "forum_forumid_msgid" Type: INDEX Owner: tperdue
4408 CREATE INDEX "forum_forumid_msgid" on "forum" using btree ( "group_forum_id" "int4_ops", "msg_id" "int4_ops" );
4411 -- TOC Entry ID 313 (OID 19033)
4413 -- Name: "forum_group_forum_id" Type: INDEX Owner: tperdue
4416 CREATE INDEX "forum_group_forum_id" on "forum" using btree ( "group_forum_id" "int4_ops" );
4419 -- TOC Entry ID 314 (OID 19033)
4421 -- Name: "forum_forumid_isfollowupto" Type: INDEX Owner: tperdue
4424 CREATE INDEX "forum_forumid_isfollowupto" on "forum" using btree ( "group_forum_id" "int4_ops", "is_followup_to" "int4_ops" );
4427 -- TOC Entry ID 315 (OID 19033)
4429 -- Name: "forum_forumid_threadid_mostrece" Type: INDEX Owner: tperdue
4432 CREATE INDEX "forum_forumid_threadid_mostrece" on "forum" using btree ( "group_forum_id" "int4_ops", "thread_id" "int4_ops", "most_recent_date" "int4_ops" );
4435 -- TOC Entry ID 316 (OID 19033)
4437 -- Name: "forum_threadid_isfollowupto" Type: INDEX Owner: tperdue
4440 CREATE INDEX "forum_threadid_isfollowupto" on "forum" using btree ( "thread_id" "int4_ops", "is_followup_to" "int4_ops" );
4443 -- TOC Entry ID 317 (OID 19033)
4445 -- Name: "forum_forumid_isfollto_mostrece" Type: INDEX Owner: tperdue
4448 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" );
4451 -- TOC Entry ID 318 (OID 19115)
4453 -- Name: "forum_group_list_group_id" Type: INDEX Owner: tperdue
4456 CREATE INDEX "forum_group_list_group_id" on "forum_group_list" using btree ( "group_id" "int4_ops" );
4459 -- TOC Entry ID 319 (OID 19173)
4461 -- Name: "forummonitoredforums_user" Type: INDEX Owner: tperdue
4464 CREATE INDEX "forummonitoredforums_user" on "forum_monitored_forums" using btree ( "user_id" "int4_ops" );
4467 -- TOC Entry ID 320 (OID 19173)
4469 -- Name: "forum_monitor_combo_id" Type: INDEX Owner: tperdue
4472 CREATE INDEX "forum_monitor_combo_id" on "forum_monitored_forums" using btree ( "forum_id" "int4_ops", "user_id" "int4_ops" );
4475 -- TOC Entry ID 321 (OID 19173)
4477 -- Name: "forum_monitor_thread_id" Type: INDEX Owner: tperdue
4480 CREATE INDEX "forum_monitor_thread_id" on "forum_monitored_forums" using btree ( "forum_id" "int4_ops" );
4483 -- TOC Entry ID 322 (OID 19287)
4485 -- Name: "foundry_news_foundry_approved_d" Type: INDEX Owner: tperdue
4488 CREATE INDEX "foundry_news_foundry_approved_d" on "foundry_news" using btree ( "foundry_id" "int4_ops", "is_approved" "int4_ops", "approve_date" "int4_ops" );
4491 -- TOC Entry ID 323 (OID 19287)
4493 -- Name: "foundry_news_foundry_approved" Type: INDEX Owner: tperdue
4496 CREATE INDEX "foundry_news_foundry_approved" on "foundry_news" using btree ( "foundry_id" "int4_ops", "is_approved" "int4_ops" );
4499 -- TOC Entry ID 324 (OID 19287)
4501 -- Name: "foundry_news_foundry" Type: INDEX Owner: tperdue
4504 CREATE INDEX "foundry_news_foundry" on "foundry_news" using btree ( "foundry_id" "int4_ops" );
4507 -- TOC Entry ID 325 (OID 19287)
4509 -- Name: "foundrynews_foundry_date_approv" Type: INDEX Owner: tperdue
4512 CREATE INDEX "foundrynews_foundry_date_approv" on "foundry_news" using btree ( "foundry_id" "int4_ops", "approve_date" "int4_ops", "is_approved" "int4_ops" );
4515 -- TOC Entry ID 326 (OID 19328)
4517 -- Name: "foundry_project_group_rank" Type: INDEX Owner: tperdue
4520 CREATE INDEX "foundry_project_group_rank" on "foundry_preferred_projects" using btree ( "group_id" "int4_ops", "rank" "int4_ops" );
4523 -- TOC Entry ID 327 (OID 19328)
4525 -- Name: "foundry_project_group" Type: INDEX Owner: tperdue
4528 CREATE INDEX "foundry_project_group" on "foundry_preferred_projects" using btree ( "group_id" "int4_ops" );
4531 -- TOC Entry ID 328 (OID 19367)
4533 -- Name: "foundry_projects_foundry" Type: INDEX Owner: tperdue
4536 CREATE INDEX "foundry_projects_foundry" on "foundry_projects" using btree ( "foundry_id" "int4_ops" );
4539 -- TOC Entry ID 329 (OID 19404)
4541 -- Name: "frs_file_date" Type: INDEX Owner: tperdue
4544 CREATE INDEX "frs_file_date" on "frs_file" using btree ( "post_date" "int4_ops" );
4547 -- TOC Entry ID 330 (OID 19404)
4549 -- Name: "frs_file_release_id" Type: INDEX Owner: tperdue
4552 CREATE INDEX "frs_file_release_id" on "frs_file" using btree ( "release_id" "int4_ops" );
4555 -- TOC Entry ID 331 (OID 19514)
4557 -- Name: "package_group_id" Type: INDEX Owner: tperdue
4560 CREATE INDEX "package_group_id" on "frs_package" using btree ( "group_id" "int4_ops" );
4563 -- TOC Entry ID 332 (OID 19616)
4565 -- Name: "frs_release_package" Type: INDEX Owner: tperdue
4568 CREATE INDEX "frs_release_package" on "frs_release" using btree ( "package_id" "int4_ops" );
4571 -- TOC Entry ID 333 (OID 19745)
4573 -- Name: "group_history_group_id" Type: INDEX Owner: tperdue
4576 CREATE INDEX "group_history_group_id" on "group_history" using btree ( "group_id" "int4_ops" );
4579 -- TOC Entry ID 334 (OID 19851)
4581 -- Name: "group_unix_uniq" Type: INDEX Owner: tperdue
4584 CREATE UNIQUE INDEX "group_unix_uniq" on "groups" using btree ( "unix_group_name" "varchar_ops" );
4587 -- TOC Entry ID 335 (OID 19851)
4589 -- Name: "groups_type" Type: INDEX Owner: tperdue
4592 CREATE INDEX "groups_type" on "groups" using btree ( "type" "int4_ops" );
4595 -- TOC Entry ID 336 (OID 19851)
4597 -- Name: "groups_public" Type: INDEX Owner: tperdue
4600 CREATE INDEX "groups_public" on "groups" using btree ( "is_public" "int4_ops" );
4603 -- TOC Entry ID 337 (OID 19851)
4605 -- Name: "groups_status" Type: INDEX Owner: tperdue
4608 CREATE INDEX "groups_status" on "groups" using btree ( "status" "bpchar_ops" );
4611 -- TOC Entry ID 338 (OID 19996)
4613 -- Name: "mail_group_list_group" Type: INDEX Owner: tperdue
4616 CREATE INDEX "mail_group_list_group" on "mail_group_list" using btree ( "group_id" "int4_ops" );
4619 -- TOC Entry ID 339 (OID 20055)
4621 -- Name: "news_bytes_group" Type: INDEX Owner: tperdue
4624 CREATE INDEX "news_bytes_group" on "news_bytes" using btree ( "group_id" "int4_ops" );
4627 -- TOC Entry ID 340 (OID 20055)
4629 -- Name: "news_bytes_approved" Type: INDEX Owner: tperdue
4632 CREATE INDEX "news_bytes_approved" on "news_bytes" using btree ( "is_approved" "int4_ops" );
4635 -- TOC Entry ID 341 (OID 20055)
4637 -- Name: "news_bytes_forum" Type: INDEX Owner: tperdue
4640 CREATE INDEX "news_bytes_forum" on "news_bytes" using btree ( "forum_id" "int4_ops" );
4643 -- TOC Entry ID 342 (OID 20055)
4645 -- Name: "news_group_date" Type: INDEX Owner: tperdue
4648 CREATE INDEX "news_group_date" on "news_bytes" using btree ( "group_id" "int4_ops", "date" "int4_ops" );
4651 -- TOC Entry ID 343 (OID 20055)
4653 -- Name: "news_approved_date" Type: INDEX Owner: tperdue
4656 CREATE INDEX "news_approved_date" on "news_bytes" using btree ( "is_approved" "int4_ops", "date" "int4_ops" );
4659 -- TOC Entry ID 344 (OID 20115)
4661 -- Name: "people_job_group_id" Type: INDEX Owner: tperdue
4664 CREATE INDEX "people_job_group_id" on "people_job" using btree ( "group_id" "int4_ops" );
4667 -- TOC Entry ID 345 (OID 20504)
4669 -- Name: "project_assigned_to_assigned_to" Type: INDEX Owner: tperdue
4672 CREATE INDEX "project_assigned_to_assigned_to" on "project_assigned_to" using btree ( "assigned_to_id" "int4_ops" );
4675 -- TOC Entry ID 346 (OID 20504)
4677 -- Name: "project_assigned_to_task_id" Type: INDEX Owner: tperdue
4680 CREATE INDEX "project_assigned_to_task_id" on "project_assigned_to" using btree ( "project_task_id" "int4_ops" );
4683 -- TOC Entry ID 347 (OID 20541)
4685 -- Name: "project_is_dependent_on_task_id" Type: INDEX Owner: tperdue
4688 CREATE INDEX "project_is_dependent_on_task_id" on "project_dependencies" using btree ( "is_dependent_on_task_id" "int4_ops" );
4691 -- TOC Entry ID 348 (OID 20541)
4693 -- Name: "project_dependencies_task_id" Type: INDEX Owner: tperdue
4696 CREATE INDEX "project_dependencies_task_id" on "project_dependencies" using btree ( "project_task_id" "int4_ops" );
4699 -- TOC Entry ID 349 (OID 20578)
4701 -- Name: "project_group_list_group_id" Type: INDEX Owner: tperdue
4704 CREATE INDEX "project_group_list_group_id" on "project_group_list" using btree ( "group_id" "int4_ops" );
4707 -- TOC Entry ID 350 (OID 20633)
4709 -- Name: "project_history_task_id" Type: INDEX Owner: tperdue
4712 CREATE INDEX "project_history_task_id" on "project_history" using btree ( "project_task_id" "int4_ops" );
4715 -- TOC Entry ID 351 (OID 20691)
4717 -- Name: "project_metric_group" Type: INDEX Owner: tperdue
4720 CREATE INDEX "project_metric_group" on "project_metric" using btree ( "group_id" "int4_ops" );
4723 -- TOC Entry ID 352 (OID 20832)
4725 -- Name: "projecttask_projid_status" Type: INDEX Owner: tperdue
4728 CREATE INDEX "projecttask_projid_status" on "project_task" using btree ( "group_project_id" "int4_ops", "status_id" "int4_ops" );
4731 -- TOC Entry ID 353 (OID 20832)
4733 -- Name: "project_task_group_project_id" Type: INDEX Owner: tperdue
4736 CREATE INDEX "project_task_group_project_id" on "project_task" using btree ( "group_project_id" "int4_ops" );
4739 -- TOC Entry ID 354 (OID 20900)
4741 -- Name: "projectweeklymetric_ranking" Type: INDEX Owner: tperdue
4744 CREATE INDEX "projectweeklymetric_ranking" on "project_weekly_metric" using btree ( "ranking" "int4_ops" );
4747 -- TOC Entry ID 355 (OID 20900)
4749 -- Name: "project_metric_weekly_group" Type: INDEX Owner: tperdue
4752 CREATE INDEX "project_metric_weekly_group" on "project_weekly_metric" using btree ( "group_id" "int4_ops" );
4755 -- TOC Entry ID 356 (OID 20914)
4757 -- Name: "session_user_id" Type: INDEX Owner: tperdue
4760 CREATE INDEX "session_user_id" on "session" using btree ( "user_id" "int4_ops" );
4763 -- TOC Entry ID 357 (OID 20914)
4765 -- Name: "session_time" Type: INDEX Owner: tperdue
4768 CREATE INDEX "session_time" on "session" using btree ( "time" "int4_ops" );
4771 -- TOC Entry ID 358 (OID 20953)
4773 -- Name: "snippet_language" Type: INDEX Owner: tperdue
4776 CREATE INDEX "snippet_language" on "snippet" using btree ( "language" "int4_ops" );
4779 -- TOC Entry ID 359 (OID 20953)
4781 -- Name: "snippet_category" Type: INDEX Owner: tperdue
4784 CREATE INDEX "snippet_category" on "snippet" using btree ( "category" "int4_ops" );
4787 -- TOC Entry ID 360 (OID 21013)
4789 -- Name: "snippet_package_language" Type: INDEX Owner: tperdue
4792 CREATE INDEX "snippet_package_language" on "snippet_package" using btree ( "language" "int4_ops" );
4795 -- TOC Entry ID 361 (OID 21013)
4797 -- Name: "snippet_package_category" Type: INDEX Owner: tperdue
4800 CREATE INDEX "snippet_package_category" on "snippet_package" using btree ( "category" "int4_ops" );
4803 -- TOC Entry ID 362 (OID 21069)
4805 -- Name: "snippet_package_item_pkg_ver" Type: INDEX Owner: tperdue
4808 CREATE INDEX "snippet_package_item_pkg_ver" on "snippet_package_item" using btree ( "snippet_package_version_id" "int4_ops" );
4811 -- TOC Entry ID 363 (OID 21106)
4813 -- Name: "snippet_package_version_pkg_id" Type: INDEX Owner: tperdue
4816 CREATE INDEX "snippet_package_version_pkg_id" on "snippet_package_version" using btree ( "snippet_package_id" "int4_ops" );
4819 -- TOC Entry ID 364 (OID 21162)
4821 -- Name: "snippet_version_snippet_id" Type: INDEX Owner: tperdue
4824 CREATE INDEX "snippet_version_snippet_id" on "snippet_version" using btree ( "snippet_id" "int4_ops" );
4827 -- TOC Entry ID 365 (OID 21211)
4829 -- Name: "pages_by_day_day" Type: INDEX Owner: tperdue
4832 CREATE INDEX "pages_by_day_day" on "stats_agg_pages_by_day" using btree ( "day" "int4_ops" );
4835 -- TOC Entry ID 366 (OID 21224)
4837 -- Name: "statsftpdl_day_fileid" Type: INDEX Owner: tperdue
4840 CREATE INDEX "statsftpdl_day_fileid" on "stats_ftp_downloads" using btree ( "day" "int4_ops", "filerelease_id" "int4_ops" );
4843 -- TOC Entry ID 367 (OID 21241)
4845 -- Name: "statshttpdl_day_fileid" Type: INDEX Owner: tperdue
4848 CREATE INDEX "statshttpdl_day_fileid" on "stats_http_downloads" using btree ( "day" "int4_ops", "filerelease_id" "int4_ops" );
4851 -- TOC Entry ID 368 (OID 21277)
4853 -- Name: "supported_languages_code" Type: INDEX Owner: tperdue
4856 CREATE INDEX "supported_languages_code" on "supported_languages" using btree ( "language_code" "bpchar_ops" );
4859 -- TOC Entry ID 369 (OID 21379)
4861 -- Name: "survey_questions_group" Type: INDEX Owner: tperdue
4864 CREATE INDEX "survey_questions_group" on "survey_questions" using btree ( "group_id" "int4_ops" );
4867 -- TOC Entry ID 370 (OID 21414)
4869 -- Name: "survey_rating_aggregate_type_id" Type: INDEX Owner: tperdue
4872 CREATE INDEX "survey_rating_aggregate_type_id" on "survey_rating_aggregate" using btree ( "type" "int4_ops", "id" "int4_ops" );
4875 -- TOC Entry ID 371 (OID 21431)
4877 -- Name: "survey_rating_responses_user_ty" Type: INDEX Owner: tperdue
4880 CREATE INDEX "survey_rating_responses_user_ty" on "survey_rating_response" using btree ( "user_id" "int4_ops", "type" "int4_ops", "id" "int4_ops" );
4883 -- TOC Entry ID 372 (OID 21431)
4885 -- Name: "survey_rating_responses_type_id" Type: INDEX Owner: tperdue
4888 CREATE INDEX "survey_rating_responses_type_id" on "survey_rating_response" using btree ( "type" "int4_ops", "id" "int4_ops" );
4891 -- TOC Entry ID 373 (OID 21450)
4893 -- Name: "survey_responses_group_id" Type: INDEX Owner: tperdue
4896 CREATE INDEX "survey_responses_group_id" on "survey_responses" using btree ( "group_id" "int4_ops" );
4899 -- TOC Entry ID 374 (OID 21450)
4901 -- Name: "survey_responses_user_survey_qu" Type: INDEX Owner: tperdue
4904 CREATE INDEX "survey_responses_user_survey_qu" on "survey_responses" using btree ( "user_id" "int4_ops", "survey_id" "int4_ops", "question_id" "int4_ops" );
4907 -- TOC Entry ID 375 (OID 21450)
4909 -- Name: "survey_responses_user_survey" Type: INDEX Owner: tperdue
4912 CREATE INDEX "survey_responses_user_survey" on "survey_responses" using btree ( "user_id" "int4_ops", "survey_id" "int4_ops" );
4915 -- TOC Entry ID 376 (OID 21450)
4917 -- Name: "survey_responses_survey_questio" Type: INDEX Owner: tperdue
4920 CREATE INDEX "survey_responses_survey_questio" on "survey_responses" using btree ( "survey_id" "int4_ops", "question_id" "int4_ops" );
4923 -- TOC Entry ID 377 (OID 21505)
4925 -- Name: "surveys_group" Type: INDEX Owner: tperdue
4928 CREATE INDEX "surveys_group" on "surveys" using btree ( "group_id" "int4_ops" );
4931 -- TOC Entry ID 378 (OID 21700)
4933 -- Name: "rank_forumposts_week_idx" Type: INDEX Owner: tperdue
4936 CREATE INDEX "rank_forumposts_week_idx" on "top_group" using btree ( "rank_forumposts_week" "int4_ops" );
4939 -- TOC Entry ID 379 (OID 21700)
4941 -- Name: "rank_downloads_week_idx" Type: INDEX Owner: tperdue
4944 CREATE INDEX "rank_downloads_week_idx" on "top_group" using btree ( "rank_downloads_week" "int4_ops" );
4947 -- TOC Entry ID 380 (OID 21700)
4949 -- Name: "pageviews_proj_idx" Type: INDEX Owner: tperdue
4952 CREATE INDEX "pageviews_proj_idx" on "top_group" using btree ( "pageviews_proj" "int4_ops" );
4955 -- TOC Entry ID 381 (OID 21700)
4957 -- Name: "rank_userrank_idx" Type: INDEX Owner: tperdue
4960 CREATE INDEX "rank_userrank_idx" on "top_group" using btree ( "rank_userrank" "int4_ops" );
4963 -- TOC Entry ID 382 (OID 21700)
4965 -- Name: "rank_downloads_all_idx" Type: INDEX Owner: tperdue
4968 CREATE INDEX "rank_downloads_all_idx" on "top_group" using btree ( "rank_downloads_all" "int4_ops" );
4971 -- TOC Entry ID 383 (OID 21761)
4973 -- Name: "parent_idx" Type: INDEX Owner: tperdue
4976 CREATE INDEX "parent_idx" on "trove_cat" using btree ( "parent" "int4_ops" );
4979 -- TOC Entry ID 384 (OID 21761)
4981 -- Name: "root_parent_idx" Type: INDEX Owner: tperdue
4984 CREATE INDEX "root_parent_idx" on "trove_cat" using btree ( "root_parent" "int4_ops" );
4987 -- TOC Entry ID 385 (OID 21761)
4989 -- Name: "version_idx" Type: INDEX Owner: tperdue
4992 CREATE INDEX "version_idx" on "trove_cat" using btree ( "version" "int4_ops" );
4995 -- TOC Entry ID 386 (OID 21825)
4997 -- Name: "trove_group_link_group_id" Type: INDEX Owner: tperdue
5000 CREATE INDEX "trove_group_link_group_id" on "trove_group_link" using btree ( "group_id" "int4_ops" );
5003 -- TOC Entry ID 387 (OID 21825)
5005 -- Name: "trove_group_link_cat_id" Type: INDEX Owner: tperdue
5008 CREATE INDEX "trove_group_link_cat_id" on "trove_group_link" using btree ( "trove_cat_id" "int4_ops" );
5011 -- TOC Entry ID 388 (OID 21885)
5013 -- Name: "user_bookmark_user_id" Type: INDEX Owner: tperdue
5016 CREATE INDEX "user_bookmark_user_id" on "user_bookmarks" using btree ( "user_id" "int4_ops" );
5019 -- TOC Entry ID 389 (OID 21937)
5021 -- Name: "user_diary_user" Type: INDEX Owner: tperdue
5024 CREATE INDEX "user_diary_user" on "user_diary" using btree ( "user_id" "int4_ops" );
5027 -- TOC Entry ID 390 (OID 21937)
5029 -- Name: "user_diary_user_date" Type: INDEX Owner: tperdue
5032 CREATE INDEX "user_diary_user_date" on "user_diary" using btree ( "user_id" "int4_ops", "date_posted" "int4_ops" );
5035 -- TOC Entry ID 391 (OID 21937)
5037 -- Name: "user_diary_date" Type: INDEX Owner: tperdue
5040 CREATE INDEX "user_diary_date" on "user_diary" using btree ( "date_posted" "int4_ops" );
5043 -- TOC Entry ID 392 (OID 21993)
5045 -- Name: "user_diary_monitor_user" Type: INDEX Owner: tperdue
5048 CREATE INDEX "user_diary_monitor_user" on "user_diary_monitor" using btree ( "user_id" "int4_ops" );
5051 -- TOC Entry ID 393 (OID 21993)
5053 -- Name: "user_diary_monitor_monitored_us" Type: INDEX Owner: tperdue
5056 CREATE INDEX "user_diary_monitor_monitored_us" on "user_diary_monitor" using btree ( "monitored_user" "int4_ops" );
5059 -- TOC Entry ID 394 (OID 22030)
5061 -- Name: "user_group_group_id" Type: INDEX Owner: tperdue
5064 CREATE INDEX "user_group_group_id" on "user_group" using btree ( "group_id" "int4_ops" );
5067 -- TOC Entry ID 395 (OID 22030)
5069 -- Name: "bug_flags_idx" Type: INDEX Owner: tperdue
5072 CREATE INDEX "bug_flags_idx" on "user_group" using btree ( "bug_flags" "int4_ops" );
5075 -- TOC Entry ID 396 (OID 22030)
5077 -- Name: "project_flags_idx" Type: INDEX Owner: tperdue
5080 CREATE INDEX "project_flags_idx" on "user_group" using btree ( "project_flags" "int4_ops" );
5083 -- TOC Entry ID 397 (OID 22030)
5085 -- Name: "user_group_user_id" Type: INDEX Owner: tperdue
5088 CREATE INDEX "user_group_user_id" on "user_group" using btree ( "user_id" "int4_ops" );
5091 -- TOC Entry ID 398 (OID 22030)
5093 -- Name: "admin_flags_idx" Type: INDEX Owner: tperdue
5096 CREATE INDEX "admin_flags_idx" on "user_group" using btree ( "admin_flags" "bpchar_ops" );
5099 -- TOC Entry ID 399 (OID 22030)
5101 -- Name: "forum_flags_idx" Type: INDEX Owner: tperdue
5104 CREATE INDEX "forum_flags_idx" on "user_group" using btree ( "forum_flags" "int4_ops" );
5107 -- TOC Entry ID 400 (OID 22030)
5109 -- Name: "usergroup_uniq_groupid_userid" Type: INDEX Owner: tperdue
5112 CREATE UNIQUE INDEX "usergroup_uniq_groupid_userid" on "user_group" using btree ( "group_id" "int4_ops", "user_id" "int4_ops" );
5115 -- TOC Entry ID 401 (OID 22135)
5117 -- Name: "user_metric0_user_id" Type: INDEX Owner: tperdue
5120 CREATE INDEX "user_metric0_user_id" on "user_metric0" using btree ( "user_id" "int4_ops" );
5123 -- TOC Entry ID 402 (OID 22163)
5125 -- Name: "user_pref_user_id" Type: INDEX Owner: tperdue
5128 CREATE INDEX "user_pref_user_id" on "user_preferences" using btree ( "user_id" "int4_ops" );
5131 -- TOC Entry ID 403 (OID 22194)
5133 -- Name: "user_ratings_rated_by" Type: INDEX Owner: tperdue
5136 CREATE INDEX "user_ratings_rated_by" on "user_ratings" using btree ( "rated_by" "int4_ops" );
5139 -- TOC Entry ID 404 (OID 22194)
5141 -- Name: "user_ratings_user_id" Type: INDEX Owner: tperdue
5144 CREATE INDEX "user_ratings_user_id" on "user_ratings" using btree ( "user_id" "int4_ops" );
5147 -- TOC Entry ID 405 (OID 22230)
5149 -- Name: "users_namename_uniq" Type: INDEX Owner: tperdue
5152 CREATE UNIQUE INDEX "users_namename_uniq" on "users" using btree ( "user_name" "text_ops" );
5155 -- TOC Entry ID 406 (OID 22230)
5157 -- Name: "users_status" Type: INDEX Owner: tperdue
5160 CREATE INDEX "users_status" on "users" using btree ( "status" "bpchar_ops" );
5163 -- TOC Entry ID 407 (OID 22230)
5165 -- Name: "users_user_pw" Type: INDEX Owner: tperdue
5168 CREATE INDEX "users_user_pw" on "users" using btree ( "user_pw" "varchar_ops" );
5171 -- TOC Entry ID 408 (OID 22336)
5173 -- Name: "projectsumsagg_groupid" Type: INDEX Owner: tperdue
5176 CREATE INDEX "projectsumsagg_groupid" on "project_sums_agg" using btree ( "group_id" "int4_ops" );
5179 -- TOC Entry ID 409 (OID 22388)
5181 -- Name: "idx_prdb_dbname" Type: INDEX Owner: tperdue
5184 CREATE UNIQUE INDEX "idx_prdb_dbname" on "prdb_dbs" using btree ( "dbname" "text_ops" );
5187 -- TOC Entry ID 410 (OID 22500)
5189 -- Name: "idx_vhost_groups" Type: INDEX Owner: tperdue
5192 CREATE INDEX "idx_vhost_groups" on "prweb_vhost" using btree ( "group_id" "int4_ops" );
5195 -- TOC Entry ID 411 (OID 22500)
5197 -- Name: "idx_vhost_hostnames" Type: INDEX Owner: tperdue
5200 CREATE UNIQUE INDEX "idx_vhost_hostnames" on "prweb_vhost" using btree ( "vhost_name" "text_ops" );
5203 -- TOC Entry ID 412 (OID 22552)
5205 -- Name: "artgrouplist_groupid" Type: INDEX Owner: tperdue
5208 CREATE INDEX "artgrouplist_groupid" on "artifact_group_list" using btree ( "group_id" "int4_ops" );
5211 -- TOC Entry ID 413 (OID 22552)
5213 -- Name: "artgrouplist_groupid_public" Type: INDEX Owner: tperdue
5216 CREATE INDEX "artgrouplist_groupid_public" on "artifact_group_list" using btree ( "group_id" "int4_ops", "is_public" "int4_ops" );
5219 -- TOC Entry ID 414 (OID 22668)
5221 -- Name: "artperm_groupartifactid_userid" Type: INDEX Owner: tperdue
5224 CREATE UNIQUE INDEX "artperm_groupartifactid_userid" on "artifact_perm" using btree ( "group_artifact_id" "int4_ops", "user_id" "int4_ops" );
5227 -- TOC Entry ID 415 (OID 22668)
5229 -- Name: "artperm_groupartifactid" Type: INDEX Owner: tperdue
5232 CREATE INDEX "artperm_groupartifactid" on "artifact_perm" using btree ( "group_artifact_id" "int4_ops" );
5235 -- TOC Entry ID 416 (OID 22737)
5237 -- Name: "artcategory_groupartifactid" Type: INDEX Owner: tperdue
5240 CREATE INDEX "artcategory_groupartifactid" on "artifact_category" using btree ( "group_artifact_id" "int4_ops" );
5243 -- TOC Entry ID 417 (OID 22789)
5245 -- Name: "artgroup_groupartifactid" Type: INDEX Owner: tperdue
5248 CREATE INDEX "artgroup_groupartifactid" on "artifact_group" using btree ( "group_artifact_id" "int4_ops" );
5251 -- TOC Entry ID 418 (OID 22888)
5253 -- Name: "art_groupartid" Type: INDEX Owner: tperdue
5256 CREATE INDEX "art_groupartid" on "artifact" using btree ( "group_artifact_id" "int4_ops" );
5259 -- TOC Entry ID 419 (OID 22888)
5261 -- Name: "art_groupartid_statusid" Type: INDEX Owner: tperdue
5264 CREATE INDEX "art_groupartid_statusid" on "artifact" using btree ( "group_artifact_id" "int4_ops", "status_id" "int4_ops" );
5267 -- TOC Entry ID 420 (OID 22888)
5269 -- Name: "art_groupartid_assign" Type: INDEX Owner: tperdue
5272 CREATE INDEX "art_groupartid_assign" on "artifact" using btree ( "group_artifact_id" "int4_ops", "assigned_to" "int4_ops" );
5275 -- TOC Entry ID 421 (OID 22888)
5277 -- Name: "art_groupartid_submit" Type: INDEX Owner: tperdue
5280 CREATE INDEX "art_groupartid_submit" on "artifact" using btree ( "group_artifact_id" "int4_ops", "submitted_by" "int4_ops" );
5283 -- TOC Entry ID 422 (OID 22888)
5285 -- Name: "art_submit_status" Type: INDEX Owner: tperdue
5288 CREATE INDEX "art_submit_status" on "artifact" using btree ( "submitted_by" "int4_ops", "status_id" "int4_ops" );
5291 -- TOC Entry ID 423 (OID 22888)
5293 -- Name: "art_assign_status" Type: INDEX Owner: tperdue
5296 CREATE INDEX "art_assign_status" on "artifact" using btree ( "assigned_to" "int4_ops", "status_id" "int4_ops" );
5299 -- TOC Entry ID 424 (OID 22888)
5301 -- Name: "art_groupartid_artifactid" Type: INDEX Owner: tperdue
5304 CREATE INDEX "art_groupartid_artifactid" on "artifact" using btree ( "group_artifact_id" "int4_ops", "artifact_id" "int4_ops" );
5307 -- TOC Entry ID 425 (OID 22993)
5309 -- Name: "arthistory_artid" Type: INDEX Owner: tperdue
5312 CREATE INDEX "arthistory_artid" on "artifact_history" using btree ( "artifact_id" "int4_ops" );
5315 -- TOC Entry ID 426 (OID 22993)
5317 -- Name: "arthistory_artid_entrydate" Type: INDEX Owner: tperdue
5320 CREATE INDEX "arthistory_artid_entrydate" on "artifact_history" using btree ( "artifact_id" "int4_ops", "entrydate" "int4_ops" );
5323 -- TOC Entry ID 427 (OID 23067)
5325 -- Name: "artfile_artid" Type: INDEX Owner: tperdue
5328 CREATE INDEX "artfile_artid" on "artifact_file" using btree ( "artifact_id" "int4_ops" );
5331 -- TOC Entry ID 428 (OID 23067)
5333 -- Name: "artfile_artid_adddate" Type: INDEX Owner: tperdue
5336 CREATE INDEX "artfile_artid_adddate" on "artifact_file" using btree ( "artifact_id" "int4_ops", "adddate" "int4_ops" );
5339 -- TOC Entry ID 429 (OID 23145)
5341 -- Name: "artmessage_artid" Type: INDEX Owner: tperdue
5344 CREATE INDEX "artmessage_artid" on "artifact_message" using btree ( "artifact_id" "int4_ops" );
5347 -- TOC Entry ID 430 (OID 23145)
5349 -- Name: "artmessage_artid_adddate" Type: INDEX Owner: tperdue
5352 CREATE INDEX "artmessage_artid_adddate" on "artifact_message" using btree ( "artifact_id" "int4_ops", "adddate" "int4_ops" );
5355 -- TOC Entry ID 431 (OID 23218)
5357 -- Name: "artmonitor_artifactid" Type: INDEX Owner: tperdue
5360 CREATE INDEX "artmonitor_artifactid" on "artifact_monitor" using btree ( "artifact_id" "int4_ops" );
5363 -- TOC Entry ID 432 (OID 23269)
5365 -- Name: "artifactcannedresponses_groupid" Type: INDEX Owner: tperdue
5368 CREATE INDEX "artifactcannedresponses_groupid" on "artifact_canned_responses" using btree ( "group_artifact_id" "int4_ops" );
5371 -- TOC Entry ID 433 (OID 23301)
5373 -- Name: "artifactcountsagg_groupartid" Type: INDEX Owner: tperdue
5376 CREATE INDEX "artifactcountsagg_groupartid" on "artifact_counts_agg" using btree ( "group_artifact_id" "int4_ops" );
5379 -- TOC Entry ID 434 (OID 23313)
5381 -- Name: "statssitepgsbyday_oid" Type: INDEX Owner: tperdue
5384 CREATE UNIQUE INDEX "statssitepgsbyday_oid" on "stats_site_pages_by_day" using btree ( "oid" "oid_ops" );
5387 -- TOC Entry ID 435 (OID 23313)
5389 -- Name: "statssitepagesbyday_month_day" Type: INDEX Owner: tperdue
5392 CREATE INDEX "statssitepagesbyday_month_day" on "stats_site_pages_by_day" using btree ( "month" "int4_ops", "day" "int4_ops" );
5395 -- TOC Entry ID 436 (OID 23388)
5397 -- Name: "frsdlfileagg_oid" Type: INDEX Owner: tperdue
5400 CREATE UNIQUE INDEX "frsdlfileagg_oid" on "frs_dlstats_file_agg" using btree ( "oid" "oid_ops" );
5403 -- TOC Entry ID 437 (OID 23388)
5405 -- Name: "frsdlfileagg_month_day_file" Type: INDEX Owner: tperdue
5408 CREATE UNIQUE INDEX "frsdlfileagg_month_day_file" on "frs_dlstats_file_agg" using btree ( "month" "int4_ops", "day" "int4_ops", "file_id" "int4_ops" );
5411 -- TOC Entry ID 438 (OID 23401)
5413 -- Name: "statsaggsitebygrp_oid" Type: INDEX Owner: tperdue
5416 CREATE UNIQUE INDEX "statsaggsitebygrp_oid" on "stats_agg_site_by_group" using btree ( "oid" "oid_ops" );
5419 -- TOC Entry ID 439 (OID 23401)
5421 -- Name: "statssitebygroup_month_day_grou" Type: INDEX Owner: tperdue
5424 CREATE UNIQUE INDEX "statssitebygroup_month_day_grou" on "stats_agg_site_by_group" using btree ( "month" "int4_ops", "day" "int4_ops", "group_id" "int4_ops" );
5427 -- TOC Entry ID 440 (OID 23414)
5429 -- Name: "statsprojectmetric_oid" Type: INDEX Owner: tperdue
5432 CREATE UNIQUE INDEX "statsprojectmetric_oid" on "stats_project_metric" using btree ( "oid" "oid_ops" );
5435 -- TOC Entry ID 441 (OID 23414)
5437 -- Name: "statsprojectmetric_month_day_gr" Type: INDEX Owner: tperdue
5440 CREATE UNIQUE INDEX "statsprojectmetric_month_day_gr" on "stats_project_metric" using btree ( "month" "int4_ops", "day" "int4_ops", "group_id" "int4_ops" );
5443 -- TOC Entry ID 442 (OID 23433)
5445 -- Name: "statsagglogobygrp_oid" Type: INDEX Owner: tperdue
5448 CREATE UNIQUE INDEX "statsagglogobygrp_oid" on "stats_agg_logo_by_group" using btree ( "oid" "oid_ops" );
5451 -- TOC Entry ID 443 (OID 23433)
5453 -- Name: "statslogobygroup_month_day_grou" Type: INDEX Owner: tperdue
5456 CREATE UNIQUE INDEX "statslogobygroup_month_day_grou" on "stats_agg_logo_by_group" using btree ( "month" "int4_ops", "day" "int4_ops", "group_id" "int4_ops" );
5459 -- TOC Entry ID 444 (OID 23446)
5461 -- Name: "statssubdpages_oid" Type: INDEX Owner: tperdue
5464 CREATE UNIQUE INDEX "statssubdpages_oid" on "stats_subd_pages" using btree ( "oid" "oid_ops" );
5467 -- TOC Entry ID 445 (OID 23446)
5469 -- Name: "statssubdpages_month_day_group" Type: INDEX Owner: tperdue
5472 CREATE UNIQUE INDEX "statssubdpages_month_day_group" on "stats_subd_pages" using btree ( "month" "int4_ops", "day" "int4_ops", "group_id" "int4_ops" );
5475 -- TOC Entry ID 446 (OID 23486)
5477 -- Name: "statscvsgrp_oid" Type: INDEX Owner: tperdue
5480 CREATE UNIQUE INDEX "statscvsgrp_oid" on "stats_cvs_group" using btree ( "oid" "oid_ops" );
5483 -- TOC Entry ID 447 (OID 23486)
5485 -- Name: "statscvsgroup_month_day_group" Type: INDEX Owner: tperdue
5488 CREATE UNIQUE INDEX "statscvsgroup_month_day_group" on "stats_cvs_group" using btree ( "month" "int4_ops", "day" "int4_ops", "group_id" "int4_ops" );
5491 -- TOC Entry ID 448 (OID 23507)
5493 -- Name: "statsprojectdevelop_oid" Type: INDEX Owner: tperdue
5496 CREATE UNIQUE INDEX "statsprojectdevelop_oid" on "stats_project_developers" using btree ( "oid" "oid_ops" );
5499 -- TOC Entry ID 449 (OID 23507)
5501 -- Name: "statsprojectdev_month_day_group" Type: INDEX Owner: tperdue
5504 CREATE UNIQUE INDEX "statsprojectdev_month_day_group" on "stats_project_developers" using btree ( "month" "int4_ops", "day" "int4_ops", "group_id" "int4_ops" );
5507 -- TOC Entry ID 450 (OID 23524)
5509 -- Name: "statsproject_oid" Type: INDEX Owner: tperdue
5512 CREATE UNIQUE INDEX "statsproject_oid" on "stats_project" using btree ( "oid" "oid_ops" );
5515 -- TOC Entry ID 451 (OID 23524)
5517 -- Name: "statsproject_month_day_group" Type: INDEX Owner: tperdue
5520 CREATE UNIQUE INDEX "statsproject_month_day_group" on "stats_project" using btree ( "month" "int4_ops", "day" "int4_ops", "group_id" "int4_ops" );
5523 -- TOC Entry ID 452 (OID 23567)
5525 -- Name: "statssite_oid" Type: INDEX Owner: tperdue
5528 CREATE UNIQUE INDEX "statssite_oid" on "stats_site" using btree ( "oid" "oid_ops" );
5531 -- TOC Entry ID 453 (OID 23567)
5533 -- Name: "statssite_month_day" Type: INDEX Owner: tperdue
5536 CREATE UNIQUE INDEX "statssite_month_day" on "stats_site" using btree ( "month" "int4_ops", "day" "int4_ops" );
5539 -- TOC Entry ID 454 (OID 25693)
5541 -- Name: "user_metric_history_date_userid" Type: INDEX Owner: tperdue
5544 CREATE INDEX "user_metric_history_date_userid" on "user_metric_history" using btree ( "month" "int4_ops", "day" "int4_ops", "user_id" "int4_ops" );
5547 -- TOC Entry ID 455 (OID 25710)
5549 -- Name: "foundryprojectrankingsagg_found" Type: INDEX Owner: tperdue
5552 CREATE INDEX "foundryprojectrankingsagg_found" on "foundry_project_rankings_agg" using btree ( "foundry_id" "int4_ops", "ranking" "int4_ops" );
5555 -- TOC Entry ID 456 (OID 25728)
5557 -- Name: "foundryprojdlsagg_foundryid_dls" Type: INDEX Owner: tperdue
5560 CREATE INDEX "foundryprojdlsagg_foundryid_dls" on "foundry_project_downloads_agg" using btree ( "foundry_id" "int4_ops", "downloads" "int4_ops" );
5563 -- TOC Entry ID 457 (OID 25745)
5565 -- Name: "frsdlfiletotal_fileid" Type: INDEX Owner: tperdue
5568 CREATE INDEX "frsdlfiletotal_fileid" on "frs_dlstats_filetotal_agg" using btree ( "file_id" "int4_ops" );
5571 -- TOC Entry ID 458 (OID 25759)
5573 -- Name: "frsdlgrouptotal_groupid" Type: INDEX Owner: tperdue
5576 CREATE INDEX "frsdlgrouptotal_groupid" on "frs_dlstats_grouptotal_agg" using btree ( "group_id" "int4_ops" );
5579 -- TOC Entry ID 459 (OID 25773)
5581 -- Name: "frsdlgroup_groupid" Type: INDEX Owner: tperdue
5584 CREATE INDEX "frsdlgroup_groupid" on "frs_dlstats_group_agg" using btree ( "group_id" "int4_ops" );
5587 -- TOC Entry ID 460 (OID 25773)
5589 -- Name: "frsdlgroup_month_day_groupid" Type: INDEX Owner: tperdue
5592 CREATE INDEX "frsdlgroup_month_day_groupid" on "frs_dlstats_group_agg" using btree ( "month" "int4_ops", "day" "int4_ops", "group_id" "int4_ops" );
5595 -- TOC Entry ID 461 (OID 25792)
5597 -- Name: "statsprojectmonths_groupid" Type: INDEX Owner: tperdue
5600 CREATE INDEX "statsprojectmonths_groupid" on "stats_project_months" using btree ( "group_id" "int4_ops" );
5603 -- TOC Entry ID 462 (OID 25792)
5605 -- Name: "statsprojectmonths_groupid_mont" Type: INDEX Owner: tperdue
5608 CREATE INDEX "statsprojectmonths_groupid_mont" on "stats_project_months" using btree ( "group_id" "int4_ops", "month" "int4_ops" );
5611 -- TOC Entry ID 463 (OID 25834)
5613 -- Name: "statsprojectall_groupid" Type: INDEX Owner: tperdue
5616 CREATE INDEX "statsprojectall_groupid" on "stats_project_all" using btree ( "group_id" "int4_ops" );
5619 -- TOC Entry ID 464 (OID 25884)
5621 -- Name: "statsproject30_groupid" Type: INDEX Owner: tperdue
5624 CREATE INDEX "statsproject30_groupid" on "stats_project_last_30" using btree ( "group_id" "int4_ops" );
5627 -- TOC Entry ID 465 (OID 25935)
5629 -- Name: "statssitelast30_month_day" Type: INDEX Owner: tperdue
5632 CREATE INDEX "statssitelast30_month_day" on "stats_site_last_30" using btree ( "month" "int4_ops", "day" "int4_ops" );
5635 -- TOC Entry ID 466 (OID 25967)
5637 -- Name: "statssitemonths_month" Type: INDEX Owner: tperdue
5640 CREATE INDEX "statssitemonths_month" on "stats_site_months" using btree ( "month" "int4_ops" );
5643 -- TOC Entry ID 467 (OID 26026)
5645 -- Name: "troveagg_trovecatid" Type: INDEX Owner: tperdue
5648 CREATE INDEX "troveagg_trovecatid" on "trove_agg" using btree ( "trove_cat_id" "int4_ops" );
5651 -- TOC Entry ID 468 (OID 26026)
5653 -- Name: "troveagg_trovecatid_ranking" Type: INDEX Owner: tperdue
5656 CREATE INDEX "troveagg_trovecatid_ranking" on "trove_agg" using btree ( "trove_cat_id" "int4_ops", "ranking" "int4_ops" );
5659 -- TOC Entry ID 649 (OID 24179)
5661 -- Name: "RI_ConstraintTrigger_24178" Type: TRIGGER Owner: tperdue
5664 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');
5667 -- TOC Entry ID 651 (OID 24181)
5669 -- Name: "RI_ConstraintTrigger_24180" Type: TRIGGER Owner: tperdue
5672 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');
5675 -- TOC Entry ID 652 (OID 24183)
5677 -- Name: "RI_ConstraintTrigger_24182" Type: TRIGGER Owner: tperdue
5680 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');
5683 -- TOC Entry ID 650 (OID 24185)
5685 -- Name: "RI_ConstraintTrigger_24184" Type: TRIGGER Owner: tperdue
5688 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');
5691 -- TOC Entry ID 629 (OID 24187)
5693 -- Name: "RI_ConstraintTrigger_24186" Type: TRIGGER Owner: tperdue
5696 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');
5699 -- TOC Entry ID 630 (OID 24189)
5701 -- Name: "RI_ConstraintTrigger_24188" Type: TRIGGER Owner: tperdue
5704 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');
5707 -- TOC Entry ID 599 (OID 24191)
5709 -- Name: "RI_ConstraintTrigger_24190" Type: TRIGGER Owner: tperdue
5712 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');
5715 -- TOC Entry ID 653 (OID 24193)
5717 -- Name: "RI_ConstraintTrigger_24192" Type: TRIGGER Owner: tperdue
5720 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');
5723 -- TOC Entry ID 654 (OID 24195)
5725 -- Name: "RI_ConstraintTrigger_24194" Type: TRIGGER Owner: tperdue
5728 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');
5731 -- TOC Entry ID 600 (OID 24197)
5733 -- Name: "RI_ConstraintTrigger_24196" Type: TRIGGER Owner: tperdue
5736 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');
5739 -- TOC Entry ID 603 (OID 24199)
5741 -- Name: "RI_ConstraintTrigger_24198" Type: TRIGGER Owner: tperdue
5744 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');
5747 -- TOC Entry ID 604 (OID 24201)
5749 -- Name: "RI_ConstraintTrigger_24200" Type: TRIGGER Owner: tperdue
5752 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');
5755 -- TOC Entry ID 605 (OID 24203)
5757 -- Name: "RI_ConstraintTrigger_24202" Type: TRIGGER Owner: tperdue
5760 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');
5763 -- TOC Entry ID 631 (OID 24205)
5765 -- Name: "RI_ConstraintTrigger_24204" Type: TRIGGER Owner: tperdue
5768 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');
5771 -- TOC Entry ID 632 (OID 24207)
5773 -- Name: "RI_ConstraintTrigger_24206" Type: TRIGGER Owner: tperdue
5776 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');
5779 -- TOC Entry ID 601 (OID 24209)
5781 -- Name: "RI_ConstraintTrigger_24208" Type: TRIGGER Owner: tperdue
5784 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');
5787 -- TOC Entry ID 655 (OID 24211)
5789 -- Name: "RI_ConstraintTrigger_24210" Type: TRIGGER Owner: tperdue
5792 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');
5795 -- TOC Entry ID 656 (OID 24213)
5797 -- Name: "RI_ConstraintTrigger_24212" Type: TRIGGER Owner: tperdue
5800 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');
5803 -- TOC Entry ID 602 (OID 24215)
5805 -- Name: "RI_ConstraintTrigger_24214" Type: TRIGGER Owner: tperdue
5808 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');
5811 -- TOC Entry ID 606 (OID 24217)
5813 -- Name: "RI_ConstraintTrigger_24216" Type: TRIGGER Owner: tperdue
5816 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');
5819 -- TOC Entry ID 607 (OID 24219)
5821 -- Name: "RI_ConstraintTrigger_24218" Type: TRIGGER Owner: tperdue
5824 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');
5827 -- TOC Entry ID 639 (OID 24221)
5829 -- Name: "RI_ConstraintTrigger_24220" Type: TRIGGER Owner: tperdue
5832 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');
5835 -- TOC Entry ID 633 (OID 24223)
5837 -- Name: "RI_ConstraintTrigger_24222" Type: TRIGGER Owner: tperdue
5840 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');
5843 -- TOC Entry ID 634 (OID 24225)
5845 -- Name: "RI_ConstraintTrigger_24224" Type: TRIGGER Owner: tperdue
5848 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');
5851 -- TOC Entry ID 644 (OID 24227)
5853 -- Name: "RI_ConstraintTrigger_24226" Type: TRIGGER Owner: tperdue
5856 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');
5859 -- TOC Entry ID 640 (OID 24229)
5861 -- Name: "RI_ConstraintTrigger_24228" Type: TRIGGER Owner: tperdue
5864 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');
5867 -- TOC Entry ID 641 (OID 24231)
5869 -- Name: "RI_ConstraintTrigger_24230" Type: TRIGGER Owner: tperdue
5872 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');
5875 -- TOC Entry ID 645 (OID 24233)
5877 -- Name: "RI_ConstraintTrigger_24232" Type: TRIGGER Owner: tperdue
5880 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');
5883 -- TOC Entry ID 657 (OID 24235)
5885 -- Name: "RI_ConstraintTrigger_24234" Type: TRIGGER Owner: tperdue
5888 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');
5891 -- TOC Entry ID 658 (OID 24237)
5893 -- Name: "RI_ConstraintTrigger_24236" Type: TRIGGER Owner: tperdue
5896 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');
5899 -- TOC Entry ID 646 (OID 24239)
5901 -- Name: "RI_ConstraintTrigger_24238" Type: TRIGGER Owner: tperdue
5904 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');
5907 -- TOC Entry ID 642 (OID 24241)
5909 -- Name: "RI_ConstraintTrigger_24240" Type: TRIGGER Owner: tperdue
5912 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');
5915 -- TOC Entry ID 643 (OID 24243)
5917 -- Name: "RI_ConstraintTrigger_24242" Type: TRIGGER Owner: tperdue
5920 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');
5923 -- TOC Entry ID 659 (OID 24245)
5925 -- Name: "RI_ConstraintTrigger_24244" Type: TRIGGER Owner: tperdue
5928 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');
5931 -- TOC Entry ID 647 (OID 24247)
5933 -- Name: "RI_ConstraintTrigger_24246" Type: TRIGGER Owner: tperdue
5936 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');
5939 -- TOC Entry ID 648 (OID 24249)
5941 -- Name: "RI_ConstraintTrigger_24248" Type: TRIGGER Owner: tperdue
5944 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');
5947 -- TOC Entry ID 723 (OID 24251)
5949 -- Name: "RI_ConstraintTrigger_24250" Type: TRIGGER Owner: tperdue
5952 CREATE CONSTRAINT TRIGGER "artifactmonitor_artifactid_fk" AFTER INSERT OR UPDATE ON "artifact_monitor" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('artifactmonitor_artifactid_fk', 'artifact_monitor', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
5955 -- TOC Entry ID 699 (OID 24253)
5957 -- Name: "RI_ConstraintTrigger_24252" Type: TRIGGER Owner: tperdue
5960 CREATE CONSTRAINT TRIGGER "artifactmonitor_artifactid_fk" AFTER DELETE ON "artifact" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('artifactmonitor_artifactid_fk', 'artifact_monitor', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
5963 -- TOC Entry ID 700 (OID 24255)
5965 -- Name: "RI_ConstraintTrigger_24254" Type: TRIGGER Owner: tperdue
5968 CREATE CONSTRAINT TRIGGER "artifactmonitor_artifactid_fk" AFTER UPDATE ON "artifact" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('artifactmonitor_artifactid_fk', 'artifact_monitor', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
5971 -- TOC Entry ID 676 (OID 24257)
5973 -- Name: "RI_ConstraintTrigger_24256" Type: TRIGGER Owner: tperdue
5976 CREATE CONSTRAINT TRIGGER "artifactgroup_groupid_fk" AFTER INSERT OR UPDATE ON "artifact_group_list" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('artifactgroup_groupid_fk', 'artifact_group_list', 'groups', 'FULL', 'group_id', 'group_id');
5979 -- TOC Entry ID 635 (OID 24259)
5981 -- Name: "RI_ConstraintTrigger_24258" Type: TRIGGER Owner: tperdue
5984 CREATE CONSTRAINT TRIGGER "artifactgroup_groupid_fk" AFTER DELETE ON "groups" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('artifactgroup_groupid_fk', 'artifact_group_list', 'groups', 'FULL', 'group_id', 'group_id');
5987 -- TOC Entry ID 636 (OID 24261)
5989 -- Name: "RI_ConstraintTrigger_24260" Type: TRIGGER Owner: tperdue
5992 CREATE CONSTRAINT TRIGGER "artifactgroup_groupid_fk" AFTER UPDATE ON "groups" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('artifactgroup_groupid_fk', 'artifact_group_list', 'groups', 'FULL', 'group_id', 'group_id');
5995 -- TOC Entry ID 688 (OID 24263)
5997 -- Name: "RI_ConstraintTrigger_24262" Type: TRIGGER Owner: tperdue
6000 CREATE CONSTRAINT TRIGGER "artifactperm_userid_fk" AFTER INSERT OR UPDATE ON "artifact_perm" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('artifactperm_userid_fk', 'artifact_perm', 'users', 'FULL', 'user_id', 'user_id');
6003 -- TOC Entry ID 660 (OID 24265)
6005 -- Name: "RI_ConstraintTrigger_24264" Type: TRIGGER Owner: tperdue
6008 CREATE CONSTRAINT TRIGGER "artifactperm_userid_fk" AFTER DELETE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('artifactperm_userid_fk', 'artifact_perm', 'users', 'FULL', 'user_id', 'user_id');
6011 -- TOC Entry ID 661 (OID 24267)
6013 -- Name: "RI_ConstraintTrigger_24266" Type: TRIGGER Owner: tperdue
6016 CREATE CONSTRAINT TRIGGER "artifactperm_userid_fk" AFTER UPDATE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('artifactperm_userid_fk', 'artifact_perm', 'users', 'FULL', 'user_id', 'user_id');
6019 -- TOC Entry ID 689 (OID 24269)
6021 -- Name: "RI_ConstraintTrigger_24268" Type: TRIGGER Owner: tperdue
6024 CREATE CONSTRAINT TRIGGER "artifactperm_groupartifactid_fk" AFTER INSERT OR UPDATE ON "artifact_perm" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('artifactperm_groupartifactid_fk', 'artifact_perm', 'artifact_group_list', 'FULL', 'group_artifact_id', 'group_artifact_id');
6027 -- TOC Entry ID 677 (OID 24271)
6029 -- Name: "RI_ConstraintTrigger_24270" Type: TRIGGER Owner: tperdue
6032 CREATE CONSTRAINT TRIGGER "artifactperm_groupartifactid_fk" AFTER DELETE ON "artifact_group_list" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('artifactperm_groupartifactid_fk', 'artifact_perm', 'artifact_group_list', 'FULL', 'group_artifact_id', 'group_artifact_id');
6035 -- TOC Entry ID 678 (OID 24273)
6037 -- Name: "RI_ConstraintTrigger_24272" Type: TRIGGER Owner: tperdue
6040 CREATE CONSTRAINT TRIGGER "artifactperm_groupartifactid_fk" AFTER UPDATE ON "artifact_group_list" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('artifactperm_groupartifactid_fk', 'artifact_perm', 'artifact_group_list', 'FULL', 'group_artifact_id', 'group_artifact_id');
6043 -- TOC Entry ID 690 (OID 24275)
6045 -- Name: "RI_ConstraintTrigger_24274" Type: TRIGGER Owner: tperdue
6048 CREATE CONSTRAINT TRIGGER "artifactcategory_groupartifacti" AFTER INSERT OR UPDATE ON "artifact_category" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('artifactcategory_groupartifacti', 'artifact_category', 'artifact_group_list', 'FULL', 'group_artifact_id', 'group_artifact_id');
6051 -- TOC Entry ID 679 (OID 24277)
6053 -- Name: "RI_ConstraintTrigger_24276" Type: TRIGGER Owner: tperdue
6056 CREATE CONSTRAINT TRIGGER "artifactcategory_groupartifacti" AFTER DELETE ON "artifact_group_list" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('artifactcategory_groupartifacti', 'artifact_category', 'artifact_group_list', 'FULL', 'group_artifact_id', 'group_artifact_id');
6059 -- TOC Entry ID 680 (OID 24279)
6061 -- Name: "RI_ConstraintTrigger_24278" Type: TRIGGER Owner: tperdue
6064 CREATE CONSTRAINT TRIGGER "artifactcategory_groupartifacti" AFTER UPDATE ON "artifact_group_list" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('artifactcategory_groupartifacti', 'artifact_category', 'artifact_group_list', 'FULL', 'group_artifact_id', 'group_artifact_id');
6067 -- TOC Entry ID 691 (OID 24281)
6069 -- Name: "RI_ConstraintTrigger_24280" Type: TRIGGER Owner: tperdue
6072 CREATE CONSTRAINT TRIGGER "artifactcategory_autoassignto_f" AFTER INSERT OR UPDATE ON "artifact_category" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('artifactcategory_autoassignto_f', 'artifact_category', 'users', 'FULL', 'auto_assign_to', 'user_id');
6075 -- TOC Entry ID 662 (OID 24283)
6077 -- Name: "RI_ConstraintTrigger_24282" Type: TRIGGER Owner: tperdue
6080 CREATE CONSTRAINT TRIGGER "artifactcategory_autoassignto_f" AFTER DELETE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('artifactcategory_autoassignto_f', 'artifact_category', 'users', 'FULL', 'auto_assign_to', 'user_id');
6083 -- TOC Entry ID 663 (OID 24285)
6085 -- Name: "RI_ConstraintTrigger_24284" Type: TRIGGER Owner: tperdue
6088 CREATE CONSTRAINT TRIGGER "artifactcategory_autoassignto_f" AFTER UPDATE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('artifactcategory_autoassignto_f', 'artifact_category', 'users', 'FULL', 'auto_assign_to', 'user_id');
6091 -- TOC Entry ID 694 (OID 24287)
6093 -- Name: "RI_ConstraintTrigger_24286" Type: TRIGGER Owner: tperdue
6096 CREATE CONSTRAINT TRIGGER "artifactgroup_groupartifactid_f" AFTER INSERT OR UPDATE ON "artifact_group" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('artifactgroup_groupartifactid_f', 'artifact_group', 'artifact_group_list', 'FULL', 'group_artifact_id', 'group_artifact_id');
6099 -- TOC Entry ID 681 (OID 24289)
6101 -- Name: "RI_ConstraintTrigger_24288" Type: TRIGGER Owner: tperdue
6104 CREATE CONSTRAINT TRIGGER "artifactgroup_groupartifactid_f" AFTER DELETE ON "artifact_group_list" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('artifactgroup_groupartifactid_f', 'artifact_group', 'artifact_group_list', 'FULL', 'group_artifact_id', 'group_artifact_id');
6107 -- TOC Entry ID 682 (OID 24291)
6109 -- Name: "RI_ConstraintTrigger_24290" Type: TRIGGER Owner: tperdue
6112 CREATE CONSTRAINT TRIGGER "artifactgroup_groupartifactid_f" AFTER UPDATE ON "artifact_group_list" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('artifactgroup_groupartifactid_f', 'artifact_group', 'artifact_group_list', 'FULL', 'group_artifact_id', 'group_artifact_id');
6115 -- TOC Entry ID 701 (OID 24293)
6117 -- Name: "RI_ConstraintTrigger_24292" Type: TRIGGER Owner: tperdue
6120 CREATE CONSTRAINT TRIGGER "artifact_groupartifactid_fk" AFTER INSERT OR UPDATE ON "artifact" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('artifact_groupartifactid_fk', 'artifact', 'artifact_group_list', 'FULL', 'group_artifact_id', 'group_artifact_id');
6123 -- TOC Entry ID 683 (OID 24295)
6125 -- Name: "RI_ConstraintTrigger_24294" Type: TRIGGER Owner: tperdue
6128 CREATE CONSTRAINT TRIGGER "artifact_groupartifactid_fk" AFTER DELETE ON "artifact_group_list" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('artifact_groupartifactid_fk', 'artifact', 'artifact_group_list', 'FULL', 'group_artifact_id', 'group_artifact_id');
6131 -- TOC Entry ID 684 (OID 24297)
6133 -- Name: "RI_ConstraintTrigger_24296" Type: TRIGGER Owner: tperdue
6136 CREATE CONSTRAINT TRIGGER "artifact_groupartifactid_fk" AFTER UPDATE ON "artifact_group_list" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('artifact_groupartifactid_fk', 'artifact', 'artifact_group_list', 'FULL', 'group_artifact_id', 'group_artifact_id');
6139 -- TOC Entry ID 702 (OID 24299)
6141 -- Name: "RI_ConstraintTrigger_24298" Type: TRIGGER Owner: tperdue
6144 CREATE CONSTRAINT TRIGGER "artifact_statusid_fk" AFTER INSERT OR UPDATE ON "artifact" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('artifact_statusid_fk', 'artifact', 'artifact_status', 'FULL', 'status_id', 'id');
6147 -- TOC Entry ID 697 (OID 24301)
6149 -- Name: "RI_ConstraintTrigger_24300" Type: TRIGGER Owner: tperdue
6152 CREATE CONSTRAINT TRIGGER "artifact_statusid_fk" AFTER DELETE ON "artifact_status" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('artifact_statusid_fk', 'artifact', 'artifact_status', 'FULL', 'status_id', 'id');
6155 -- TOC Entry ID 698 (OID 24303)
6157 -- Name: "RI_ConstraintTrigger_24302" Type: TRIGGER Owner: tperdue
6160 CREATE CONSTRAINT TRIGGER "artifact_statusid_fk" AFTER UPDATE ON "artifact_status" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('artifact_statusid_fk', 'artifact', 'artifact_status', 'FULL', 'status_id', 'id');
6163 -- TOC Entry ID 703 (OID 24305)
6165 -- Name: "RI_ConstraintTrigger_24304" Type: TRIGGER Owner: tperdue
6168 CREATE CONSTRAINT TRIGGER "artifact_categoryid_fk" AFTER INSERT OR UPDATE ON "artifact" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('artifact_categoryid_fk', 'artifact', 'artifact_category', 'FULL', 'category_id', 'id');
6171 -- TOC Entry ID 692 (OID 24307)
6173 -- Name: "RI_ConstraintTrigger_24306" Type: TRIGGER Owner: tperdue
6176 CREATE CONSTRAINT TRIGGER "artifact_categoryid_fk" AFTER DELETE ON "artifact_category" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('artifact_categoryid_fk', 'artifact', 'artifact_category', 'FULL', 'category_id', 'id');
6179 -- TOC Entry ID 693 (OID 24309)
6181 -- Name: "RI_ConstraintTrigger_24308" Type: TRIGGER Owner: tperdue
6184 CREATE CONSTRAINT TRIGGER "artifact_categoryid_fk" AFTER UPDATE ON "artifact_category" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('artifact_categoryid_fk', 'artifact', 'artifact_category', 'FULL', 'category_id', 'id');
6187 -- TOC Entry ID 704 (OID 24311)
6189 -- Name: "RI_ConstraintTrigger_24310" Type: TRIGGER Owner: tperdue
6192 CREATE CONSTRAINT TRIGGER "artifact_artifactgroupid_fk" AFTER INSERT OR UPDATE ON "artifact" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('artifact_artifactgroupid_fk', 'artifact', 'artifact_group', 'FULL', 'artifact_group_id', 'id');
6195 -- TOC Entry ID 695 (OID 24313)
6197 -- Name: "RI_ConstraintTrigger_24312" Type: TRIGGER Owner: tperdue
6200 CREATE CONSTRAINT TRIGGER "artifact_artifactgroupid_fk" AFTER DELETE ON "artifact_group" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('artifact_artifactgroupid_fk', 'artifact', 'artifact_group', 'FULL', 'artifact_group_id', 'id');
6203 -- TOC Entry ID 696 (OID 24315)
6205 -- Name: "RI_ConstraintTrigger_24314" Type: TRIGGER Owner: tperdue
6208 CREATE CONSTRAINT TRIGGER "artifact_artifactgroupid_fk" AFTER UPDATE ON "artifact_group" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('artifact_artifactgroupid_fk', 'artifact', 'artifact_group', 'FULL', 'artifact_group_id', 'id');
6211 -- TOC Entry ID 705 (OID 24317)
6213 -- Name: "RI_ConstraintTrigger_24316" Type: TRIGGER Owner: tperdue
6216 CREATE CONSTRAINT TRIGGER "artifact_submittedby_fk" AFTER INSERT OR UPDATE ON "artifact" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('artifact_submittedby_fk', 'artifact', 'users', 'FULL', 'submitted_by', 'user_id');
6219 -- TOC Entry ID 664 (OID 24319)
6221 -- Name: "RI_ConstraintTrigger_24318" Type: TRIGGER Owner: tperdue
6224 CREATE CONSTRAINT TRIGGER "artifact_submittedby_fk" AFTER DELETE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('artifact_submittedby_fk', 'artifact', 'users', 'FULL', 'submitted_by', 'user_id');
6227 -- TOC Entry ID 665 (OID 24321)
6229 -- Name: "RI_ConstraintTrigger_24320" Type: TRIGGER Owner: tperdue
6232 CREATE CONSTRAINT TRIGGER "artifact_submittedby_fk" AFTER UPDATE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('artifact_submittedby_fk', 'artifact', 'users', 'FULL', 'submitted_by', 'user_id');
6235 -- TOC Entry ID 706 (OID 24323)
6237 -- Name: "RI_ConstraintTrigger_24322" Type: TRIGGER Owner: tperdue
6240 CREATE CONSTRAINT TRIGGER "artifact_assignedto_fk" AFTER INSERT OR UPDATE ON "artifact" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('artifact_assignedto_fk', 'artifact', 'users', 'FULL', 'assigned_to', 'user_id');
6243 -- TOC Entry ID 666 (OID 24325)
6245 -- Name: "RI_ConstraintTrigger_24324" Type: TRIGGER Owner: tperdue
6248 CREATE CONSTRAINT TRIGGER "artifact_assignedto_fk" AFTER DELETE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('artifact_assignedto_fk', 'artifact', 'users', 'FULL', 'assigned_to', 'user_id');
6251 -- TOC Entry ID 667 (OID 24327)
6253 -- Name: "RI_ConstraintTrigger_24326" Type: TRIGGER Owner: tperdue
6256 CREATE CONSTRAINT TRIGGER "artifact_assignedto_fk" AFTER UPDATE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('artifact_assignedto_fk', 'artifact', 'users', 'FULL', 'assigned_to', 'user_id');
6259 -- TOC Entry ID 707 (OID 24329)
6261 -- Name: "RI_ConstraintTrigger_24328" Type: TRIGGER Owner: tperdue
6264 CREATE CONSTRAINT TRIGGER "artifact_resolutionid_fk" AFTER INSERT OR UPDATE ON "artifact" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('artifact_resolutionid_fk', 'artifact', 'artifact_resolution', 'FULL', 'resolution_id', 'id');
6267 -- TOC Entry ID 686 (OID 24331)
6269 -- Name: "RI_ConstraintTrigger_24330" Type: TRIGGER Owner: tperdue
6272 CREATE CONSTRAINT TRIGGER "artifact_resolutionid_fk" AFTER DELETE ON "artifact_resolution" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('artifact_resolutionid_fk', 'artifact', 'artifact_resolution', 'FULL', 'resolution_id', 'id');
6275 -- TOC Entry ID 687 (OID 24333)
6277 -- Name: "RI_ConstraintTrigger_24332" Type: TRIGGER Owner: tperdue
6280 CREATE CONSTRAINT TRIGGER "artifact_resolutionid_fk" AFTER UPDATE ON "artifact_resolution" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('artifact_resolutionid_fk', 'artifact', 'artifact_resolution', 'FULL', 'resolution_id', 'id');
6283 -- TOC Entry ID 717 (OID 24335)
6285 -- Name: "RI_ConstraintTrigger_24334" Type: TRIGGER Owner: tperdue
6288 CREATE CONSTRAINT TRIGGER "artifacthistory_artifactid_fk" AFTER INSERT OR UPDATE ON "artifact_history" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('artifacthistory_artifactid_fk', 'artifact_history', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
6291 -- TOC Entry ID 708 (OID 24337)
6293 -- Name: "RI_ConstraintTrigger_24336" Type: TRIGGER Owner: tperdue
6296 CREATE CONSTRAINT TRIGGER "artifacthistory_artifactid_fk" AFTER DELETE ON "artifact" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('artifacthistory_artifactid_fk', 'artifact_history', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
6299 -- TOC Entry ID 709 (OID 24339)
6301 -- Name: "RI_ConstraintTrigger_24338" Type: TRIGGER Owner: tperdue
6304 CREATE CONSTRAINT TRIGGER "artifacthistory_artifactid_fk" AFTER UPDATE ON "artifact" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('artifacthistory_artifactid_fk', 'artifact_history', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
6307 -- TOC Entry ID 718 (OID 24341)
6309 -- Name: "RI_ConstraintTrigger_24340" Type: TRIGGER Owner: tperdue
6312 CREATE CONSTRAINT TRIGGER "artifacthistory_modby_fk" AFTER INSERT OR UPDATE ON "artifact_history" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('artifacthistory_modby_fk', 'artifact_history', 'users', 'FULL', 'mod_by', 'user_id');
6315 -- TOC Entry ID 668 (OID 24343)
6317 -- Name: "RI_ConstraintTrigger_24342" Type: TRIGGER Owner: tperdue
6320 CREATE CONSTRAINT TRIGGER "artifacthistory_modby_fk" AFTER DELETE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('artifacthistory_modby_fk', 'artifact_history', 'users', 'FULL', 'mod_by', 'user_id');
6323 -- TOC Entry ID 669 (OID 24345)
6325 -- Name: "RI_ConstraintTrigger_24344" Type: TRIGGER Owner: tperdue
6328 CREATE CONSTRAINT TRIGGER "artifacthistory_modby_fk" AFTER UPDATE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('artifacthistory_modby_fk', 'artifact_history', 'users', 'FULL', 'mod_by', 'user_id');
6331 -- TOC Entry ID 719 (OID 24347)
6333 -- Name: "RI_ConstraintTrigger_24346" Type: TRIGGER Owner: tperdue
6336 CREATE CONSTRAINT TRIGGER "artifactfile_artifactid_fk" AFTER INSERT OR UPDATE ON "artifact_file" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('artifactfile_artifactid_fk', 'artifact_file', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
6339 -- TOC Entry ID 710 (OID 24349)
6341 -- Name: "RI_ConstraintTrigger_24348" Type: TRIGGER Owner: tperdue
6344 CREATE CONSTRAINT TRIGGER "artifactfile_artifactid_fk" AFTER DELETE ON "artifact" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('artifactfile_artifactid_fk', 'artifact_file', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
6347 -- TOC Entry ID 711 (OID 24351)
6349 -- Name: "RI_ConstraintTrigger_24350" Type: TRIGGER Owner: tperdue
6352 CREATE CONSTRAINT TRIGGER "artifactfile_artifactid_fk" AFTER UPDATE ON "artifact" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('artifactfile_artifactid_fk', 'artifact_file', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
6355 -- TOC Entry ID 720 (OID 24353)
6357 -- Name: "RI_ConstraintTrigger_24352" Type: TRIGGER Owner: tperdue
6360 CREATE CONSTRAINT TRIGGER "artifactfile_submittedby_fk" AFTER INSERT OR UPDATE ON "artifact_file" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('artifactfile_submittedby_fk', 'artifact_file', 'users', 'FULL', 'submitted_by', 'user_id');
6363 -- TOC Entry ID 670 (OID 24355)
6365 -- Name: "RI_ConstraintTrigger_24354" Type: TRIGGER Owner: tperdue
6368 CREATE CONSTRAINT TRIGGER "artifactfile_submittedby_fk" AFTER DELETE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('artifactfile_submittedby_fk', 'artifact_file', 'users', 'FULL', 'submitted_by', 'user_id');
6371 -- TOC Entry ID 671 (OID 24357)
6373 -- Name: "RI_ConstraintTrigger_24356" Type: TRIGGER Owner: tperdue
6376 CREATE CONSTRAINT TRIGGER "artifactfile_submittedby_fk" AFTER UPDATE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('artifactfile_submittedby_fk', 'artifact_file', 'users', 'FULL', 'submitted_by', 'user_id');
6379 -- TOC Entry ID 721 (OID 24359)
6381 -- Name: "RI_ConstraintTrigger_24358" Type: TRIGGER Owner: tperdue
6384 CREATE CONSTRAINT TRIGGER "artifactmessage_artifactid_fk" AFTER INSERT OR UPDATE ON "artifact_message" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('artifactmessage_artifactid_fk', 'artifact_message', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
6387 -- TOC Entry ID 712 (OID 24361)
6389 -- Name: "RI_ConstraintTrigger_24360" Type: TRIGGER Owner: tperdue
6392 CREATE CONSTRAINT TRIGGER "artifactmessage_artifactid_fk" AFTER DELETE ON "artifact" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('artifactmessage_artifactid_fk', 'artifact_message', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
6395 -- TOC Entry ID 713 (OID 24363)
6397 -- Name: "RI_ConstraintTrigger_24362" Type: TRIGGER Owner: tperdue
6400 CREATE CONSTRAINT TRIGGER "artifactmessage_artifactid_fk" AFTER UPDATE ON "artifact" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('artifactmessage_artifactid_fk', 'artifact_message', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
6403 -- TOC Entry ID 722 (OID 24365)
6405 -- Name: "RI_ConstraintTrigger_24364" Type: TRIGGER Owner: tperdue
6408 CREATE CONSTRAINT TRIGGER "artifactmessage_submittedby_fk" AFTER INSERT OR UPDATE ON "artifact_message" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('artifactmessage_submittedby_fk', 'artifact_message', 'users', 'FULL', 'submitted_by', 'user_id');
6411 -- TOC Entry ID 672 (OID 24367)
6413 -- Name: "RI_ConstraintTrigger_24366" Type: TRIGGER Owner: tperdue
6416 CREATE CONSTRAINT TRIGGER "artifactmessage_submittedby_fk" AFTER DELETE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('artifactmessage_submittedby_fk', 'artifact_message', 'users', 'FULL', 'submitted_by', 'user_id');
6419 -- TOC Entry ID 673 (OID 24369)
6421 -- Name: "RI_ConstraintTrigger_24368" Type: TRIGGER Owner: tperdue
6424 CREATE CONSTRAINT TRIGGER "artifactmessage_submittedby_fk" AFTER UPDATE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('artifactmessage_submittedby_fk', 'artifact_message', 'users', 'FULL', 'submitted_by', 'user_id');
6427 -- TOC Entry ID 724 (OID 24371)
6429 -- Name: "RI_ConstraintTrigger_24370" Type: TRIGGER Owner: tperdue
6432 CREATE CONSTRAINT TRIGGER "artifactmonitor_artifactid_fk" AFTER INSERT OR UPDATE ON "artifact_monitor" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('artifactmonitor_artifactid_fk', 'artifact_monitor', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
6435 -- TOC Entry ID 714 (OID 24373)
6437 -- Name: "RI_ConstraintTrigger_24372" Type: TRIGGER Owner: tperdue
6440 CREATE CONSTRAINT TRIGGER "artifactmonitor_artifactid_fk" AFTER DELETE ON "artifact" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('artifactmonitor_artifactid_fk', 'artifact_monitor', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
6443 -- TOC Entry ID 715 (OID 24375)
6445 -- Name: "RI_ConstraintTrigger_24374" Type: TRIGGER Owner: tperdue
6448 CREATE CONSTRAINT TRIGGER "artifactmonitor_artifactid_fk" AFTER UPDATE ON "artifact" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('artifactmonitor_artifactid_fk', 'artifact_monitor', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
6451 -- TOC Entry ID 685 (OID 24376)
6453 -- Name: artifactgrouplist_insert_trig Type: TRIGGER Owner: tperdue
6456 CREATE TRIGGER "artifactgrouplist_insert_trig" AFTER INSERT ON "artifact_group_list" FOR EACH ROW EXECUTE PROCEDURE "artifactgrouplist_insert_agg" ();
6459 -- TOC Entry ID 716 (OID 24377)
6461 -- Name: artifactgroup_update_trig Type: TRIGGER Owner: tperdue
6464 CREATE TRIGGER "artifactgroup_update_trig" AFTER UPDATE ON "artifact" FOR EACH ROW EXECUTE PROCEDURE "artifactgroup_update_agg" ();
6467 -- TOC Entry ID 608 (OID 24378)
6469 -- Name: forumgrouplist_insert_trig Type: TRIGGER Owner: tperdue
6472 CREATE TRIGGER "forumgrouplist_insert_trig" AFTER INSERT ON "forum_group_list" FOR EACH ROW EXECUTE PROCEDURE "forumgrouplist_insert_agg" ();
6475 -- TOC Entry ID 609 (OID 24380)
6477 -- Name: "RI_ConstraintTrigger_24379" Type: TRIGGER Owner: tperdue
6480 CREATE CONSTRAINT TRIGGER "frsfile_releaseid_fk" AFTER INSERT OR UPDATE ON "frs_file" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('frsfile_releaseid_fk', 'frs_file', 'frs_release', 'FULL', 'release_id', 'release_id');
6483 -- TOC Entry ID 620 (OID 24382)
6485 -- Name: "RI_ConstraintTrigger_24381" Type: TRIGGER Owner: tperdue
6488 CREATE CONSTRAINT TRIGGER "frsfile_releaseid_fk" AFTER DELETE ON "frs_release" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('frsfile_releaseid_fk', 'frs_file', 'frs_release', 'FULL', 'release_id', 'release_id');
6491 -- TOC Entry ID 621 (OID 24384)
6493 -- Name: "RI_ConstraintTrigger_24383" Type: TRIGGER Owner: tperdue
6496 CREATE CONSTRAINT TRIGGER "frsfile_releaseid_fk" AFTER UPDATE ON "frs_release" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('frsfile_releaseid_fk', 'frs_file', 'frs_release', 'FULL', 'release_id', 'release_id');
6499 -- TOC Entry ID 610 (OID 24386)
6501 -- Name: "RI_ConstraintTrigger_24385" Type: TRIGGER Owner: tperdue
6504 CREATE CONSTRAINT TRIGGER "frsfile_typeid_fk" AFTER INSERT OR UPDATE ON "frs_file" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('frsfile_typeid_fk', 'frs_file', 'frs_filetype', 'FULL', 'type_id', 'type_id');
6507 -- TOC Entry ID 612 (OID 24388)
6509 -- Name: "RI_ConstraintTrigger_24387" Type: TRIGGER Owner: tperdue
6512 CREATE CONSTRAINT TRIGGER "frsfile_typeid_fk" AFTER DELETE ON "frs_filetype" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('frsfile_typeid_fk', 'frs_file', 'frs_filetype', 'FULL', 'type_id', 'type_id');
6515 -- TOC Entry ID 613 (OID 24390)
6517 -- Name: "RI_ConstraintTrigger_24389" Type: TRIGGER Owner: tperdue
6520 CREATE CONSTRAINT TRIGGER "frsfile_typeid_fk" AFTER UPDATE ON "frs_filetype" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('frsfile_typeid_fk', 'frs_file', 'frs_filetype', 'FULL', 'type_id', 'type_id');
6523 -- TOC Entry ID 611 (OID 24392)
6525 -- Name: "RI_ConstraintTrigger_24391" Type: TRIGGER Owner: tperdue
6528 CREATE CONSTRAINT TRIGGER "frsfile_processorid_fk" AFTER INSERT OR UPDATE ON "frs_file" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('frsfile_processorid_fk', 'frs_file', 'frs_processor', 'FULL', 'processor_id', 'processor_id');
6531 -- TOC Entry ID 618 (OID 24394)
6533 -- Name: "RI_ConstraintTrigger_24393" Type: TRIGGER Owner: tperdue
6536 CREATE CONSTRAINT TRIGGER "frsfile_processorid_fk" AFTER DELETE ON "frs_processor" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('frsfile_processorid_fk', 'frs_file', 'frs_processor', 'FULL', 'processor_id', 'processor_id');
6539 -- TOC Entry ID 619 (OID 24396)
6541 -- Name: "RI_ConstraintTrigger_24395" Type: TRIGGER Owner: tperdue
6544 CREATE CONSTRAINT TRIGGER "frsfile_processorid_fk" AFTER UPDATE ON "frs_processor" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('frsfile_processorid_fk', 'frs_file', 'frs_processor', 'FULL', 'processor_id', 'processor_id');
6547 -- TOC Entry ID 614 (OID 24398)
6549 -- Name: "RI_ConstraintTrigger_24397" Type: TRIGGER Owner: tperdue
6552 CREATE CONSTRAINT TRIGGER "frspackage_groupid_fk" AFTER INSERT OR UPDATE ON "frs_package" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('frspackage_groupid_fk', 'frs_package', 'groups', 'FULL', 'group_id', 'group_id');
6555 -- TOC Entry ID 637 (OID 24400)
6557 -- Name: "RI_ConstraintTrigger_24399" Type: TRIGGER Owner: tperdue
6560 CREATE CONSTRAINT TRIGGER "frspackage_groupid_fk" AFTER DELETE ON "groups" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('frspackage_groupid_fk', 'frs_package', 'groups', 'FULL', 'group_id', 'group_id');
6563 -- TOC Entry ID 638 (OID 24402)
6565 -- Name: "RI_ConstraintTrigger_24401" Type: TRIGGER Owner: tperdue
6568 CREATE CONSTRAINT TRIGGER "frspackage_groupid_fk" AFTER UPDATE ON "groups" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('frspackage_groupid_fk', 'frs_package', 'groups', 'FULL', 'group_id', 'group_id');
6571 -- TOC Entry ID 615 (OID 24404)
6573 -- Name: "RI_ConstraintTrigger_24403" Type: TRIGGER Owner: tperdue
6576 CREATE CONSTRAINT TRIGGER "frspackage_statusid_fk" AFTER INSERT OR UPDATE ON "frs_package" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('frspackage_statusid_fk', 'frs_package', 'frs_status', 'FULL', 'status_id', 'status_id');
6579 -- TOC Entry ID 625 (OID 24406)
6581 -- Name: "RI_ConstraintTrigger_24405" Type: TRIGGER Owner: tperdue
6584 CREATE CONSTRAINT TRIGGER "frspackage_statusid_fk" AFTER DELETE ON "frs_status" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('frspackage_statusid_fk', 'frs_package', 'frs_status', 'FULL', 'status_id', 'status_id');
6587 -- TOC Entry ID 626 (OID 24408)
6589 -- Name: "RI_ConstraintTrigger_24407" Type: TRIGGER Owner: tperdue
6592 CREATE CONSTRAINT TRIGGER "frspackage_statusid_fk" AFTER UPDATE ON "frs_status" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('frspackage_statusid_fk', 'frs_package', 'frs_status', 'FULL', 'status_id', 'status_id');
6595 -- TOC Entry ID 622 (OID 24410)
6597 -- Name: "RI_ConstraintTrigger_24409" Type: TRIGGER Owner: tperdue
6600 CREATE CONSTRAINT TRIGGER "frsrelease_packageid_fk" AFTER INSERT OR UPDATE ON "frs_release" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('frsrelease_packageid_fk', 'frs_release', 'frs_package', 'FULL', 'package_id', 'package_id');
6603 -- TOC Entry ID 616 (OID 24412)
6605 -- Name: "RI_ConstraintTrigger_24411" Type: TRIGGER Owner: tperdue
6608 CREATE CONSTRAINT TRIGGER "frsrelease_packageid_fk" AFTER DELETE ON "frs_package" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('frsrelease_packageid_fk', 'frs_release', 'frs_package', 'FULL', 'package_id', 'package_id');
6611 -- TOC Entry ID 617 (OID 24414)
6613 -- Name: "RI_ConstraintTrigger_24413" Type: TRIGGER Owner: tperdue
6616 CREATE CONSTRAINT TRIGGER "frsrelease_packageid_fk" AFTER UPDATE ON "frs_package" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('frsrelease_packageid_fk', 'frs_release', 'frs_package', 'FULL', 'package_id', 'package_id');
6619 -- TOC Entry ID 623 (OID 24416)
6621 -- Name: "RI_ConstraintTrigger_24415" Type: TRIGGER Owner: tperdue
6624 CREATE CONSTRAINT TRIGGER "frsrelease_statusid_fk" AFTER INSERT OR UPDATE ON "frs_release" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('frsrelease_statusid_fk', 'frs_release', 'frs_status', 'FULL', 'status_id', 'status_id');
6627 -- TOC Entry ID 627 (OID 24418)
6629 -- Name: "RI_ConstraintTrigger_24417" Type: TRIGGER Owner: tperdue
6632 CREATE CONSTRAINT TRIGGER "frsrelease_statusid_fk" AFTER DELETE ON "frs_status" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('frsrelease_statusid_fk', 'frs_release', 'frs_status', 'FULL', 'status_id', 'status_id');
6635 -- TOC Entry ID 628 (OID 24420)
6637 -- Name: "RI_ConstraintTrigger_24419" Type: TRIGGER Owner: tperdue
6640 CREATE CONSTRAINT TRIGGER "frsrelease_statusid_fk" AFTER UPDATE ON "frs_status" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('frsrelease_statusid_fk', 'frs_release', 'frs_status', 'FULL', 'status_id', 'status_id');
6643 -- TOC Entry ID 624 (OID 24422)
6645 -- Name: "RI_ConstraintTrigger_24421" Type: TRIGGER Owner: tperdue
6648 CREATE CONSTRAINT TRIGGER "frsrelease_releasedby_fk" AFTER INSERT OR UPDATE ON "frs_release" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('frsrelease_releasedby_fk', 'frs_release', 'users', 'FULL', 'released_by', 'user_id');
6651 -- TOC Entry ID 674 (OID 24424)
6653 -- Name: "RI_ConstraintTrigger_24423" Type: TRIGGER Owner: tperdue
6656 CREATE CONSTRAINT TRIGGER "frsrelease_releasedby_fk" AFTER DELETE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('frsrelease_releasedby_fk', 'frs_release', 'users', 'FULL', 'released_by', 'user_id');
6659 -- TOC Entry ID 675 (OID 24426)
6661 -- Name: "RI_ConstraintTrigger_24425" Type: TRIGGER Owner: tperdue
6664 CREATE CONSTRAINT TRIGGER "frsrelease_releasedby_fk" AFTER UPDATE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('frsrelease_releasedby_fk', 'frs_release', 'users', 'FULL', 'released_by', 'user_id');
6667 -- TOC Entry ID 725 (OID 24427)
6669 -- Name: forum_insert_agg Type: RULE Owner: tperdue
6672 CREATE RULE forum_insert_agg AS ON INSERT TO forum DO UPDATE forum_agg_msg_count SET count = (forum_agg_msg_count.count + 1) WHERE (forum_agg_msg_count.group_forum_id = new.group_forum_id);
6674 -- TOC Entry ID 726 (OID 24428)
6676 -- Name: forum_delete_agg Type: RULE Owner: tperdue
6679 CREATE RULE forum_delete_agg AS ON DELETE TO forum DO UPDATE forum_agg_msg_count SET count = (forum_agg_msg_count.count - 1) WHERE (forum_agg_msg_count.group_forum_id = old.group_forum_id);
6681 -- TOC Entry ID 727 (OID 24429)
6683 -- Name: artifact_insert_agg Type: RULE Owner: tperdue
6686 CREATE RULE artifact_insert_agg AS ON INSERT TO artifact DO UPDATE artifact_counts_agg SET count = (artifact_counts_agg.count + 1), open_count = (artifact_counts_agg.open_count + 1) WHERE (artifact_counts_agg.group_artifact_id = new.group_artifact_id);
6688 -- TOC Entry ID 3 (OID 18724)
6690 -- Name: canned_responses_pk_seq Type: SEQUENCE SET Owner:
6693 SELECT setval ('"canned_responses_pk_seq"', 1, 'f');
6696 -- TOC Entry ID 5 (OID 18774)
6698 -- Name: db_images_pk_seq Type: SEQUENCE SET Owner:
6701 SELECT setval ('"db_images_pk_seq"', 1, 'f');
6704 -- TOC Entry ID 7 (OID 18840)
6706 -- Name: doc_data_pk_seq Type: SEQUENCE SET Owner:
6709 SELECT setval ('"doc_data_pk_seq"', 1, 'f');
6712 -- TOC Entry ID 9 (OID 18905)
6714 -- Name: doc_groups_pk_seq Type: SEQUENCE SET Owner:
6717 SELECT setval ('"doc_groups_pk_seq"', 1, 'f');
6720 -- TOC Entry ID 11 (OID 18942)
6722 -- Name: doc_states_pk_seq Type: SEQUENCE SET Owner:
6725 SELECT setval ('"doc_states_pk_seq"', 1, 'f');
6728 -- TOC Entry ID 13 (OID 18977)
6730 -- Name: filemodule_monitor_pk_seq Type: SEQUENCE SET Owner:
6733 SELECT setval ('"filemodule_monitor_pk_seq"', 1, 'f');
6736 -- TOC Entry ID 15 (OID 19014)
6738 -- Name: forum_pk_seq Type: SEQUENCE SET Owner:
6741 SELECT setval ('"forum_pk_seq"', 1, 'f');
6744 -- TOC Entry ID 17 (OID 19096)
6746 -- Name: forum_group_list_pk_seq Type: SEQUENCE SET Owner:
6749 SELECT setval ('"forum_group_list_pk_seq"', 1, 'f');
6752 -- TOC Entry ID 19 (OID 19154)
6754 -- Name: forum_monitored_forums_pk_seq Type: SEQUENCE SET Owner:
6757 SELECT setval ('"forum_monitored_forums_pk_seq"', 1, 'f');
6760 -- TOC Entry ID 21 (OID 19191)
6762 -- Name: forum_saved_place_pk_seq Type: SEQUENCE SET Owner:
6765 SELECT setval ('"forum_saved_place_pk_seq"', 1, 'f');
6768 -- TOC Entry ID 23 (OID 19268)
6770 -- Name: foundry_news_pk_seq Type: SEQUENCE SET Owner:
6773 SELECT setval ('"foundry_news_pk_seq"', 1, 'f');
6776 -- TOC Entry ID 25 (OID 19309)
6778 -- Name: foundry_preferred_projec_pk_seq Type: SEQUENCE SET Owner:
6781 SELECT setval ('"foundry_preferred_projec_pk_seq"', 1, 'f');
6784 -- TOC Entry ID 27 (OID 19348)
6786 -- Name: foundry_projects_pk_seq Type: SEQUENCE SET Owner:
6789 SELECT setval ('"foundry_projects_pk_seq"', 1, 'f');
6792 -- TOC Entry ID 29 (OID 19385)
6794 -- Name: frs_file_pk_seq Type: SEQUENCE SET Owner:
6797 SELECT setval ('"frs_file_pk_seq"', 1, 'f');
6800 -- TOC Entry ID 31 (OID 19446)
6802 -- Name: frs_filetype_pk_seq Type: SEQUENCE SET Owner:
6805 SELECT setval ('"frs_filetype_pk_seq"', 9999, 't');
6808 -- TOC Entry ID 33 (OID 19495)
6810 -- Name: frs_package_pk_seq Type: SEQUENCE SET Owner:
6813 SELECT setval ('"frs_package_pk_seq"', 1, 'f');
6816 -- TOC Entry ID 35 (OID 19548)
6818 -- Name: frs_processor_pk_seq Type: SEQUENCE SET Owner:
6821 SELECT setval ('"frs_processor_pk_seq"', 9999, 't');
6824 -- TOC Entry ID 37 (OID 19597)
6826 -- Name: frs_release_pk_seq Type: SEQUENCE SET Owner:
6829 SELECT setval ('"frs_release_pk_seq"', 1, 'f');
6832 -- TOC Entry ID 39 (OID 19658)
6834 -- Name: frs_status_pk_seq Type: SEQUENCE SET Owner:
6837 SELECT setval ('"frs_status_pk_seq"', 3, 't');
6840 -- TOC Entry ID 41 (OID 19707)
6842 -- Name: group_cvs_history_pk_seq Type: SEQUENCE SET Owner:
6845 SELECT setval ('"group_cvs_history_pk_seq"', 1, 'f');
6848 -- TOC Entry ID 43 (OID 19726)
6850 -- Name: group_history_pk_seq Type: SEQUENCE SET Owner:
6853 SELECT setval ('"group_history_pk_seq"', 1, 'f');
6856 -- TOC Entry ID 45 (OID 19783)
6858 -- Name: group_type_pk_seq Type: SEQUENCE SET Owner:
6861 SELECT setval ('"group_type_pk_seq"', 1, 'f');
6864 -- TOC Entry ID 47 (OID 19832)
6866 -- Name: groups_pk_seq Type: SEQUENCE SET Owner:
6869 SELECT setval ('"groups_pk_seq"', 4, 't');
6872 -- TOC Entry ID 49 (OID 19977)
6874 -- Name: mail_group_list_pk_seq Type: SEQUENCE SET Owner:
6877 SELECT setval ('"mail_group_list_pk_seq"', 1, 'f');
6880 -- TOC Entry ID 51 (OID 20036)
6882 -- Name: news_bytes_pk_seq Type: SEQUENCE SET Owner:
6885 SELECT setval ('"news_bytes_pk_seq"', 1, 'f');
6888 -- TOC Entry ID 53 (OID 20096)
6890 -- Name: people_job_pk_seq Type: SEQUENCE SET Owner:
6893 SELECT setval ('"people_job_pk_seq"', 1, 'f');
6896 -- TOC Entry ID 55 (OID 20156)
6898 -- Name: people_job_category_pk_seq Type: SEQUENCE SET Owner:
6901 SELECT setval ('"people_job_category_pk_seq"', 7, 't');
6904 -- TOC Entry ID 57 (OID 20207)
6906 -- Name: people_job_inventory_pk_seq Type: SEQUENCE SET Owner:
6909 SELECT setval ('"people_job_inventory_pk_seq"', 1, 'f');
6912 -- TOC Entry ID 59 (OID 20248)
6914 -- Name: people_job_status_pk_seq Type: SEQUENCE SET Owner:
6917 SELECT setval ('"people_job_status_pk_seq"', 1, 'f');
6920 -- TOC Entry ID 61 (OID 20297)
6922 -- Name: people_skill_pk_seq Type: SEQUENCE SET Owner:
6925 SELECT setval ('"people_skill_pk_seq"', 1, 'f');
6928 -- TOC Entry ID 63 (OID 20346)
6930 -- Name: people_skill_inventory_pk_seq Type: SEQUENCE SET Owner:
6933 SELECT setval ('"people_skill_inventory_pk_seq"', 1, 'f');
6936 -- TOC Entry ID 65 (OID 20387)
6938 -- Name: people_skill_level_pk_seq Type: SEQUENCE SET Owner:
6941 SELECT setval ('"people_skill_level_pk_seq"', 5, 't');
6944 -- TOC Entry ID 67 (OID 20436)
6946 -- Name: people_skill_year_pk_seq Type: SEQUENCE SET Owner:
6949 SELECT setval ('"people_skill_year_pk_seq"', 5, 't');
6952 -- TOC Entry ID 69 (OID 20485)
6954 -- Name: project_assigned_to_pk_seq Type: SEQUENCE SET Owner:
6957 SELECT setval ('"project_assigned_to_pk_seq"', 1, 'f');
6960 -- TOC Entry ID 71 (OID 20522)
6962 -- Name: project_dependencies_pk_seq Type: SEQUENCE SET Owner:
6965 SELECT setval ('"project_dependencies_pk_seq"', 1, 'f');
6968 -- TOC Entry ID 73 (OID 20559)
6970 -- Name: project_group_list_pk_seq Type: SEQUENCE SET Owner:
6973 SELECT setval ('"project_group_list_pk_seq"', 1, 't');
6976 -- TOC Entry ID 75 (OID 20614)
6978 -- Name: project_history_pk_seq Type: SEQUENCE SET Owner:
6981 SELECT setval ('"project_history_pk_seq"', 1, 'f');
6984 -- TOC Entry ID 77 (OID 20672)
6986 -- Name: project_metric_pk_seq Type: SEQUENCE SET Owner:
6989 SELECT setval ('"project_metric_pk_seq"', 1, 'f');
6992 -- TOC Entry ID 79 (OID 20708)
6994 -- Name: project_metric_tmp1_pk_seq Type: SEQUENCE SET Owner:
6997 SELECT setval ('"project_metric_tmp1_pk_seq"', 1, 'f');
7000 -- TOC Entry ID 81 (OID 20744)
7002 -- Name: project_metric_weekly_tm_pk_seq Type: SEQUENCE SET Owner:
7005 SELECT setval ('"project_metric_weekly_tm_pk_seq"', 1, 'f');
7008 -- TOC Entry ID 83 (OID 20763)
7010 -- Name: project_status_pk_seq Type: SEQUENCE SET Owner:
7013 SELECT setval ('"project_status_pk_seq"', 1, 'f');
7016 -- TOC Entry ID 85 (OID 20813)
7018 -- Name: project_task_pk_seq Type: SEQUENCE SET Owner:
7021 SELECT setval ('"project_task_pk_seq"', 1, 't');
7024 -- TOC Entry ID 87 (OID 20881)
7026 -- Name: project_weekly_metric_pk_seq Type: SEQUENCE SET Owner:
7029 SELECT setval ('"project_weekly_metric_pk_seq"', 1, 'f');
7032 -- TOC Entry ID 89 (OID 20934)
7034 -- Name: snippet_pk_seq Type: SEQUENCE SET Owner:
7037 SELECT setval ('"snippet_pk_seq"', 1, 'f');
7040 -- TOC Entry ID 91 (OID 20994)
7042 -- Name: snippet_package_pk_seq Type: SEQUENCE SET Owner:
7045 SELECT setval ('"snippet_package_pk_seq"', 1, 'f');
7048 -- TOC Entry ID 93 (OID 21050)
7050 -- Name: snippet_package_item_pk_seq Type: SEQUENCE SET Owner:
7053 SELECT setval ('"snippet_package_item_pk_seq"', 1, 'f');
7056 -- TOC Entry ID 95 (OID 21087)
7058 -- Name: snippet_package_version_pk_seq Type: SEQUENCE SET Owner:
7061 SELECT setval ('"snippet_package_version_pk_seq"', 1, 'f');
7064 -- TOC Entry ID 97 (OID 21143)
7066 -- Name: snippet_version_pk_seq Type: SEQUENCE SET Owner:
7069 SELECT setval ('"snippet_version_pk_seq"', 1, 'f');
7072 -- TOC Entry ID 99 (OID 21258)
7074 -- Name: supported_languages_pk_seq Type: SEQUENCE SET Owner:
7077 SELECT setval ('"supported_languages_pk_seq"', 23, 't');
7080 -- TOC Entry ID 101 (OID 21310)
7082 -- Name: survey_question_types_pk_seq Type: SEQUENCE SET Owner:
7085 SELECT setval ('"survey_question_types_pk_seq"', 1, 'f');
7088 -- TOC Entry ID 103 (OID 21360)
7090 -- Name: survey_questions_pk_seq Type: SEQUENCE SET Owner:
7093 SELECT setval ('"survey_questions_pk_seq"', 1, 'f');
7096 -- TOC Entry ID 105 (OID 21486)
7098 -- Name: surveys_pk_seq Type: SEQUENCE SET Owner:
7101 SELECT setval ('"surveys_pk_seq"', 1, 'f');
7104 -- TOC Entry ID 107 (OID 21542)
7106 -- Name: system_history_pk_seq Type: SEQUENCE SET Owner:
7109 SELECT setval ('"system_history_pk_seq"', 1, 'f');
7112 -- TOC Entry ID 109 (OID 21561)
7114 -- Name: system_machines_pk_seq Type: SEQUENCE SET Owner:
7117 SELECT setval ('"system_machines_pk_seq"', 1, 'f');
7120 -- TOC Entry ID 111 (OID 21580)
7122 -- Name: system_news_pk_seq Type: SEQUENCE SET Owner:
7125 SELECT setval ('"system_news_pk_seq"', 1, 'f');
7128 -- TOC Entry ID 113 (OID 21599)
7130 -- Name: system_services_pk_seq Type: SEQUENCE SET Owner:
7133 SELECT setval ('"system_services_pk_seq"', 1, 'f');
7136 -- TOC Entry ID 115 (OID 21618)
7138 -- Name: system_status_pk_seq Type: SEQUENCE SET Owner:
7141 SELECT setval ('"system_status_pk_seq"', 1, 'f');
7144 -- TOC Entry ID 117 (OID 21665)
7146 -- Name: themes_pk_seq Type: SEQUENCE SET Owner:
7149 SELECT setval ('"themes_pk_seq"', 1, 't');
7152 -- TOC Entry ID 119 (OID 21742)
7154 -- Name: trove_cat_pk_seq Type: SEQUENCE SET Owner:
7157 SELECT setval ('"trove_cat_pk_seq"', 305, 't');
7160 -- TOC Entry ID 121 (OID 21806)
7162 -- Name: trove_group_link_pk_seq Type: SEQUENCE SET Owner:
7165 SELECT setval ('"trove_group_link_pk_seq"', 1, 'f');
7168 -- TOC Entry ID 123 (OID 21847)
7170 -- Name: trove_treesums_pk_seq Type: SEQUENCE SET Owner:
7173 SELECT setval ('"trove_treesums_pk_seq"', 1, 'f');
7176 -- TOC Entry ID 125 (OID 21866)
7178 -- Name: user_bookmarks_pk_seq Type: SEQUENCE SET Owner:
7181 SELECT setval ('"user_bookmarks_pk_seq"', 1, 'f');
7184 -- TOC Entry ID 127 (OID 21918)
7186 -- Name: user_diary_pk_seq Type: SEQUENCE SET Owner:
7189 SELECT setval ('"user_diary_pk_seq"', 1, 'f');
7192 -- TOC Entry ID 129 (OID 21974)
7194 -- Name: user_diary_monitor_pk_seq Type: SEQUENCE SET Owner:
7197 SELECT setval ('"user_diary_monitor_pk_seq"', 1, 'f');
7200 -- TOC Entry ID 131 (OID 22011)
7202 -- Name: user_group_pk_seq Type: SEQUENCE SET Owner:
7205 SELECT setval ('"user_group_pk_seq"', 1, 'f');
7208 -- TOC Entry ID 133 (OID 22069)
7210 -- Name: user_metric_pk_seq Type: SEQUENCE SET Owner:
7213 SELECT setval ('"user_metric_pk_seq"', 1, 'f');
7216 -- TOC Entry ID 135 (OID 22116)
7218 -- Name: user_metric0_pk_seq Type: SEQUENCE SET Owner:
7221 SELECT setval ('"user_metric0_pk_seq"', 1, 'f');
7224 -- TOC Entry ID 137 (OID 22211)
7226 -- Name: users_pk_seq Type: SEQUENCE SET Owner:
7229 SELECT setval ('"users_pk_seq"', 1, 'f');
7232 -- TOC Entry ID 139 (OID 22298)
7234 -- Name: unix_uid_seq Type: SEQUENCE SET Owner:
7237 SELECT setval ('"unix_uid_seq"', 1, 'f');
7240 -- TOC Entry ID 141 (OID 22317)
7242 -- Name: forum_thread_seq Type: SEQUENCE SET Owner:
7245 SELECT setval ('"forum_thread_seq"', 1, 'f');
7248 -- TOC Entry ID 143 (OID 22350)
7250 -- Name: project_metric_wee_ranking1_seq Type: SEQUENCE SET Owner:
7253 SELECT setval ('"project_metric_wee_ranking1_seq"', 1, 'f');
7256 -- TOC Entry ID 145 (OID 22369)
7258 -- Name: prdb_dbs_dbid_seq Type: SEQUENCE SET Owner:
7261 SELECT setval ('"prdb_dbs_dbid_seq"', 1, 'f');
7264 -- TOC Entry ID 147 (OID 22481)
7266 -- Name: prweb_vhost_vhostid_seq Type: SEQUENCE SET Owner:
7269 SELECT setval ('"prweb_vhost_vhostid_seq"', 1, 'f');
7272 -- TOC Entry ID 149 (OID 22533)
7274 -- Name: artifact_grou_group_artifac_seq Type: SEQUENCE SET Owner:
7277 SELECT setval ('"artifact_grou_group_artifac_seq"', 100, 't');
7280 -- TOC Entry ID 151 (OID 22600)
7282 -- Name: artifact_resolution_id_seq Type: SEQUENCE SET Owner:
7285 SELECT setval ('"artifact_resolution_id_seq"', 1, 'f');
7288 -- TOC Entry ID 153 (OID 22649)
7290 -- Name: artifact_perm_id_seq Type: SEQUENCE SET Owner:
7293 SELECT setval ('"artifact_perm_id_seq"', 1, 'f');
7296 -- TOC Entry ID 155 (OID 22718)
7298 -- Name: artifact_category_id_seq Type: SEQUENCE SET Owner:
7301 SELECT setval ('"artifact_category_id_seq"', 100, 't');
7304 -- TOC Entry ID 157 (OID 22770)
7306 -- Name: artifact_group_id_seq Type: SEQUENCE SET Owner:
7309 SELECT setval ('"artifact_group_id_seq"', 1, 'f');
7312 -- TOC Entry ID 159 (OID 22820)
7314 -- Name: artifact_status_id_seq Type: SEQUENCE SET Owner:
7317 SELECT setval ('"artifact_status_id_seq"', 3, 't');
7320 -- TOC Entry ID 161 (OID 22869)
7322 -- Name: artifact_artifact_id_seq Type: SEQUENCE SET Owner:
7325 SELECT setval ('"artifact_artifact_id_seq"', 1, 'f');
7328 -- TOC Entry ID 163 (OID 22974)
7330 -- Name: artifact_history_id_seq Type: SEQUENCE SET Owner:
7333 SELECT setval ('"artifact_history_id_seq"', 1, 'f');
7336 -- TOC Entry ID 165 (OID 23048)
7338 -- Name: artifact_file_id_seq Type: SEQUENCE SET Owner:
7341 SELECT setval ('"artifact_file_id_seq"', 1, 'f');
7344 -- TOC Entry ID 167 (OID 23126)
7346 -- Name: artifact_message_id_seq Type: SEQUENCE SET Owner:
7349 SELECT setval ('"artifact_message_id_seq"', 1, 'f');
7352 -- TOC Entry ID 169 (OID 23199)
7354 -- Name: artifact_monitor_id_seq Type: SEQUENCE SET Owner:
7357 SELECT setval ('"artifact_monitor_id_seq"', 1, 'f');
7360 -- TOC Entry ID 171 (OID 23250)
7362 -- Name: artifact_canned_response_id_seq Type: SEQUENCE SET Owner:
7365 SELECT setval ('"artifact_canned_response_id_seq"', 1, 'f');
7368 -- TOC Entry ID 173 (OID 23330)
7370 -- Name: massmail_queue_id_seq Type: SEQUENCE SET Owner:
7373 SELECT setval ('"massmail_queue_id_seq"', 1, 'f');
7376 -- TOC Entry ID 175 (OID 26050)
7378 -- Name: trove_treesum_trove_treesum_seq Type: SEQUENCE SET Owner:
7381 SELECT setval ('"trove_treesum_trove_treesum_seq"', 1, 'f');