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 DEFAULT '0',
47 "version" integer DEFAULT '0',
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 'shell' NOT NULL,
542 "http_domain" character varying(80),
543 "short_description" character varying(255),
544 "cvs_box" character varying(20) DEFAULT 'cvs' 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,
995 Constraint "project_weekly_metric_pkey" Primary Key ("ranking")
999 -- TOC Entry ID 220 (OID 20914)
1001 -- Name: session Type: TABLE Owner: tperdue
1004 CREATE TABLE "session" (
1005 "user_id" integer DEFAULT '0' NOT NULL,
1006 "session_hash" character(32) DEFAULT '' NOT NULL,
1007 "ip_addr" character(15) DEFAULT '' NOT NULL,
1008 "time" integer DEFAULT '0' NOT NULL,
1009 Constraint "session_pkey" Primary Key ("session_hash")
1013 -- TOC Entry ID 88 (OID 20934)
1015 -- Name: snippet_pk_seq Type: SEQUENCE Owner: tperdue
1018 CREATE SEQUENCE "snippet_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1021 -- TOC Entry ID 221 (OID 20953)
1023 -- Name: snippet Type: TABLE Owner: tperdue
1026 CREATE TABLE "snippet" (
1027 "snippet_id" integer DEFAULT nextval('snippet_pk_seq'::text) NOT NULL,
1028 "created_by" integer DEFAULT '0' NOT NULL,
1031 "type" integer DEFAULT '0' NOT NULL,
1032 "language" integer DEFAULT '0' NOT NULL,
1033 "license" text DEFAULT '' NOT NULL,
1034 "category" integer DEFAULT '0' NOT NULL,
1035 Constraint "snippet_pkey" Primary Key ("snippet_id")
1039 -- TOC Entry ID 90 (OID 20994)
1041 -- Name: snippet_package_pk_seq Type: SEQUENCE Owner: tperdue
1044 CREATE SEQUENCE "snippet_package_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1047 -- TOC Entry ID 222 (OID 21013)
1049 -- Name: snippet_package Type: TABLE Owner: tperdue
1052 CREATE TABLE "snippet_package" (
1053 "snippet_package_id" integer DEFAULT nextval('snippet_package_pk_seq'::text) NOT NULL,
1054 "created_by" integer DEFAULT '0' NOT NULL,
1057 "category" integer DEFAULT '0' NOT NULL,
1058 "language" integer DEFAULT '0' NOT NULL,
1059 Constraint "snippet_package_pkey" Primary Key ("snippet_package_id")
1063 -- TOC Entry ID 92 (OID 21050)
1065 -- Name: snippet_package_item_pk_seq Type: SEQUENCE Owner: tperdue
1068 CREATE SEQUENCE "snippet_package_item_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1071 -- TOC Entry ID 223 (OID 21069)
1073 -- Name: snippet_package_item Type: TABLE Owner: tperdue
1076 CREATE TABLE "snippet_package_item" (
1077 "snippet_package_item_id" integer DEFAULT nextval('snippet_package_item_pk_seq'::text) NOT NULL,
1078 "snippet_package_version_id" integer DEFAULT '0' NOT NULL,
1079 "snippet_version_id" integer DEFAULT '0' NOT NULL,
1080 Constraint "snippet_package_item_pkey" Primary Key ("snippet_package_item_id")
1084 -- TOC Entry ID 94 (OID 21087)
1086 -- Name: snippet_package_version_pk_seq Type: SEQUENCE Owner: tperdue
1089 CREATE SEQUENCE "snippet_package_version_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1092 -- TOC Entry ID 224 (OID 21106)
1094 -- Name: snippet_package_version Type: TABLE Owner: tperdue
1097 CREATE TABLE "snippet_package_version" (
1098 "snippet_package_version_id" integer DEFAULT nextval('snippet_package_version_pk_seq'::text) NOT NULL,
1099 "snippet_package_id" integer DEFAULT '0' NOT NULL,
1102 "submitted_by" integer DEFAULT '0' NOT NULL,
1103 "date" integer DEFAULT '0' NOT NULL,
1104 Constraint "snippet_package_version_pkey" Primary Key ("snippet_package_version_id")
1108 -- TOC Entry ID 96 (OID 21143)
1110 -- Name: snippet_version_pk_seq Type: SEQUENCE Owner: tperdue
1113 CREATE SEQUENCE "snippet_version_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1116 -- TOC Entry ID 225 (OID 21162)
1118 -- Name: snippet_version Type: TABLE Owner: tperdue
1121 CREATE TABLE "snippet_version" (
1122 "snippet_version_id" integer DEFAULT nextval('snippet_version_pk_seq'::text) NOT NULL,
1123 "snippet_id" integer DEFAULT '0' NOT NULL,
1126 "submitted_by" integer DEFAULT '0' NOT NULL,
1127 "date" integer DEFAULT '0' NOT NULL,
1129 Constraint "snippet_version_pkey" Primary Key ("snippet_version_id")
1133 -- TOC Entry ID 226 (OID 21200)
1135 -- Name: stats_agg_logo_by_day Type: TABLE Owner: tperdue
1138 CREATE TABLE "stats_agg_logo_by_day" (
1144 -- TOC Entry ID 227 (OID 21211)
1146 -- Name: stats_agg_pages_by_day Type: TABLE Owner: tperdue
1149 CREATE TABLE "stats_agg_pages_by_day" (
1150 "day" integer DEFAULT '0' NOT NULL,
1151 "count" integer DEFAULT '0' NOT NULL
1155 -- TOC Entry ID 228 (OID 21224)
1157 -- Name: stats_ftp_downloads Type: TABLE Owner: tperdue
1160 CREATE TABLE "stats_ftp_downloads" (
1161 "day" integer DEFAULT '0' NOT NULL,
1162 "filerelease_id" integer DEFAULT '0' NOT NULL,
1163 "group_id" integer DEFAULT '0' NOT NULL,
1164 "downloads" integer DEFAULT '0' NOT NULL
1168 -- TOC Entry ID 229 (OID 21241)
1170 -- Name: stats_http_downloads Type: TABLE Owner: tperdue
1173 CREATE TABLE "stats_http_downloads" (
1174 "day" integer DEFAULT '0' NOT NULL,
1175 "filerelease_id" integer DEFAULT '0' NOT NULL,
1176 "group_id" integer DEFAULT '0' NOT NULL,
1177 "downloads" integer DEFAULT '0' NOT NULL
1181 -- TOC Entry ID 98 (OID 21258)
1183 -- Name: supported_languages_pk_seq Type: SEQUENCE Owner: tperdue
1186 CREATE SEQUENCE "supported_languages_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1189 -- TOC Entry ID 230 (OID 21277)
1191 -- Name: supported_languages Type: TABLE Owner: tperdue
1194 CREATE TABLE "supported_languages" (
1195 "language_id" integer DEFAULT nextval('supported_languages_pk_seq'::text) NOT NULL,
1199 "language_code" character(2),
1200 Constraint "supported_languages_pkey" Primary Key ("language_id")
1204 -- TOC Entry ID 100 (OID 21310)
1206 -- Name: survey_question_types_pk_seq Type: SEQUENCE Owner: tperdue
1209 CREATE SEQUENCE "survey_question_types_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1212 -- TOC Entry ID 231 (OID 21329)
1214 -- Name: survey_question_types Type: TABLE Owner: tperdue
1217 CREATE TABLE "survey_question_types" (
1218 "id" integer DEFAULT nextval('survey_question_types_pk_seq'::text) NOT NULL,
1219 "type" text DEFAULT '' NOT NULL,
1220 Constraint "survey_question_types_pkey" Primary Key ("id")
1224 -- TOC Entry ID 102 (OID 21360)
1226 -- Name: survey_questions_pk_seq Type: SEQUENCE Owner: tperdue
1229 CREATE SEQUENCE "survey_questions_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1232 -- TOC Entry ID 232 (OID 21379)
1234 -- Name: survey_questions Type: TABLE Owner: tperdue
1237 CREATE TABLE "survey_questions" (
1238 "question_id" integer DEFAULT nextval('survey_questions_pk_seq'::text) NOT NULL,
1239 "group_id" integer DEFAULT '0' NOT NULL,
1240 "question" text DEFAULT '' NOT NULL,
1241 "question_type" integer DEFAULT '0' NOT NULL,
1242 Constraint "survey_questions_pkey" Primary Key ("question_id")
1246 -- TOC Entry ID 233 (OID 21414)
1248 -- Name: survey_rating_aggregate Type: TABLE Owner: tperdue
1251 CREATE TABLE "survey_rating_aggregate" (
1252 "type" integer DEFAULT '0' NOT NULL,
1253 "id" integer DEFAULT '0' NOT NULL,
1254 "response" double precision DEFAULT '0' NOT NULL,
1255 "count" integer DEFAULT '0' NOT NULL
1259 -- TOC Entry ID 234 (OID 21431)
1261 -- Name: survey_rating_response Type: TABLE Owner: tperdue
1264 CREATE TABLE "survey_rating_response" (
1265 "user_id" integer DEFAULT '0' NOT NULL,
1266 "type" integer DEFAULT '0' NOT NULL,
1267 "id" integer DEFAULT '0' NOT NULL,
1268 "response" integer DEFAULT '0' NOT NULL,
1269 "date" integer DEFAULT '0' NOT NULL
1273 -- TOC Entry ID 235 (OID 21450)
1275 -- Name: survey_responses Type: TABLE Owner: tperdue
1278 CREATE TABLE "survey_responses" (
1279 "user_id" integer DEFAULT '0' NOT NULL,
1280 "group_id" integer DEFAULT '0' NOT NULL,
1281 "survey_id" integer DEFAULT '0' NOT NULL,
1282 "question_id" integer DEFAULT '0' NOT NULL,
1283 "response" text DEFAULT '' NOT NULL,
1284 "date" integer DEFAULT '0' NOT NULL
1288 -- TOC Entry ID 104 (OID 21486)
1290 -- Name: surveys_pk_seq Type: SEQUENCE Owner: tperdue
1293 CREATE SEQUENCE "surveys_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1296 -- TOC Entry ID 236 (OID 21505)
1298 -- Name: surveys Type: TABLE Owner: tperdue
1301 CREATE TABLE "surveys" (
1302 "survey_id" integer DEFAULT nextval('surveys_pk_seq'::text) NOT NULL,
1303 "group_id" integer DEFAULT '0' NOT NULL,
1304 "survey_title" text DEFAULT '' NOT NULL,
1305 "survey_questions" text DEFAULT '' NOT NULL,
1306 "is_active" integer DEFAULT '1' NOT NULL,
1307 Constraint "surveys_pkey" Primary Key ("survey_id")
1311 -- TOC Entry ID 106 (OID 21542)
1313 -- Name: system_history_pk_seq Type: SEQUENCE Owner: tperdue
1316 CREATE SEQUENCE "system_history_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1319 -- TOC Entry ID 108 (OID 21561)
1321 -- Name: system_machines_pk_seq Type: SEQUENCE Owner: tperdue
1324 CREATE SEQUENCE "system_machines_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1327 -- TOC Entry ID 110 (OID 21580)
1329 -- Name: system_news_pk_seq Type: SEQUENCE Owner: tperdue
1332 CREATE SEQUENCE "system_news_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1335 -- TOC Entry ID 112 (OID 21599)
1337 -- Name: system_services_pk_seq Type: SEQUENCE Owner: tperdue
1340 CREATE SEQUENCE "system_services_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1343 -- TOC Entry ID 114 (OID 21618)
1345 -- Name: system_status_pk_seq Type: SEQUENCE Owner: tperdue
1348 CREATE SEQUENCE "system_status_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1351 -- TOC Entry ID 237 (OID 21637)
1353 -- Name: theme_prefs Type: TABLE Owner: tperdue
1356 CREATE TABLE "theme_prefs" (
1357 "user_id" integer DEFAULT '0' NOT NULL,
1358 "user_theme" integer DEFAULT '0' NOT NULL,
1359 "body_font" character(80) DEFAULT '',
1360 "body_size" character(5) DEFAULT '',
1361 "titlebar_font" character(80) DEFAULT '',
1362 "titlebar_size" character(5) DEFAULT '',
1363 "color_titlebar_back" character(7) DEFAULT '',
1364 "color_ltback1" character(7) DEFAULT '',
1365 Constraint "theme_prefs_pkey" Primary Key ("user_id")
1369 -- TOC Entry ID 116 (OID 21665)
1371 -- Name: themes_pk_seq Type: SEQUENCE Owner: tperdue
1374 CREATE SEQUENCE "themes_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1377 -- TOC Entry ID 238 (OID 21684)
1379 -- Name: themes Type: TABLE Owner: tperdue
1382 CREATE TABLE "themes" (
1383 "theme_id" integer DEFAULT nextval('themes_pk_seq'::text) NOT NULL,
1384 "dirname" character varying(80),
1385 "fullname" character varying(80),
1386 Constraint "themes_pkey" Primary Key ("theme_id")
1390 -- TOC Entry ID 239 (OID 21700)
1392 -- Name: top_group Type: TABLE Owner: tperdue
1395 CREATE TABLE "top_group" (
1396 "group_id" integer DEFAULT '0' NOT NULL,
1397 "group_name" character varying(40),
1398 "downloads_all" integer DEFAULT '0' NOT NULL,
1399 "rank_downloads_all" integer DEFAULT '0' NOT NULL,
1400 "rank_downloads_all_old" integer DEFAULT '0' NOT NULL,
1401 "downloads_week" integer DEFAULT '0' NOT NULL,
1402 "rank_downloads_week" integer DEFAULT '0' NOT NULL,
1403 "rank_downloads_week_old" integer DEFAULT '0' NOT NULL,
1404 "userrank" integer DEFAULT '0' NOT NULL,
1405 "rank_userrank" integer DEFAULT '0' NOT NULL,
1406 "rank_userrank_old" integer DEFAULT '0' NOT NULL,
1407 "forumposts_week" integer DEFAULT '0' NOT NULL,
1408 "rank_forumposts_week" integer DEFAULT '0' NOT NULL,
1409 "rank_forumposts_week_old" integer DEFAULT '0' NOT NULL,
1410 "pageviews_proj" integer DEFAULT '0' NOT NULL,
1411 "rank_pageviews_proj" integer DEFAULT '0' NOT NULL,
1412 "rank_pageviews_proj_old" integer DEFAULT '0' NOT NULL
1416 -- TOC Entry ID 118 (OID 21742)
1418 -- Name: trove_cat_pk_seq Type: SEQUENCE Owner: tperdue
1421 CREATE SEQUENCE "trove_cat_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1424 -- TOC Entry ID 240 (OID 21761)
1426 -- Name: trove_cat Type: TABLE Owner: tperdue
1429 CREATE TABLE "trove_cat" (
1430 "trove_cat_id" integer DEFAULT nextval('trove_cat_pk_seq'::text) NOT NULL,
1431 "version" integer DEFAULT '0' NOT NULL,
1432 "parent" integer DEFAULT '0' NOT NULL,
1433 "root_parent" integer DEFAULT '0' NOT NULL,
1434 "shortname" character varying(80),
1435 "fullname" character varying(80),
1436 "description" character varying(255),
1437 "count_subcat" integer DEFAULT '0' NOT NULL,
1438 "count_subproj" integer DEFAULT '0' NOT NULL,
1439 "fullpath" text DEFAULT '' NOT NULL,
1440 "fullpath_ids" text,
1441 Constraint "trove_cat_pkey" Primary Key ("trove_cat_id")
1445 -- TOC Entry ID 120 (OID 21806)
1447 -- Name: trove_group_link_pk_seq Type: SEQUENCE Owner: tperdue
1450 CREATE SEQUENCE "trove_group_link_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1453 -- TOC Entry ID 241 (OID 21825)
1455 -- Name: trove_group_link Type: TABLE Owner: tperdue
1458 CREATE TABLE "trove_group_link" (
1459 "trove_group_id" integer DEFAULT nextval('trove_group_link_pk_seq'::text) NOT NULL,
1460 "trove_cat_id" integer DEFAULT '0' NOT NULL,
1461 "trove_cat_version" integer DEFAULT '0' NOT NULL,
1462 "group_id" integer DEFAULT '0' NOT NULL,
1463 "trove_cat_root" integer DEFAULT '0' NOT NULL,
1464 Constraint "trove_group_link_pkey" Primary Key ("trove_group_id")
1468 -- TOC Entry ID 122 (OID 21847)
1470 -- Name: trove_treesums_pk_seq Type: SEQUENCE Owner: tperdue
1473 CREATE SEQUENCE "trove_treesums_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1476 -- TOC Entry ID 124 (OID 21866)
1478 -- Name: user_bookmarks_pk_seq Type: SEQUENCE Owner: tperdue
1481 CREATE SEQUENCE "user_bookmarks_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1484 -- TOC Entry ID 242 (OID 21885)
1486 -- Name: user_bookmarks Type: TABLE Owner: tperdue
1489 CREATE TABLE "user_bookmarks" (
1490 "bookmark_id" integer DEFAULT nextval('user_bookmarks_pk_seq'::text) NOT NULL,
1491 "user_id" integer DEFAULT '0' NOT NULL,
1492 "bookmark_url" text,
1493 "bookmark_title" text,
1494 Constraint "user_bookmarks_pkey" Primary Key ("bookmark_id")
1498 -- TOC Entry ID 126 (OID 21918)
1500 -- Name: user_diary_pk_seq Type: SEQUENCE Owner: tperdue
1503 CREATE SEQUENCE "user_diary_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1506 -- TOC Entry ID 243 (OID 21937)
1508 -- Name: user_diary Type: TABLE Owner: tperdue
1511 CREATE TABLE "user_diary" (
1512 "id" integer DEFAULT nextval('user_diary_pk_seq'::text) NOT NULL,
1513 "user_id" integer DEFAULT '0' NOT NULL,
1514 "date_posted" integer DEFAULT '0' NOT NULL,
1517 "is_public" integer DEFAULT '0' NOT NULL,
1518 Constraint "user_diary_pkey" Primary Key ("id")
1522 -- TOC Entry ID 128 (OID 21974)
1524 -- Name: user_diary_monitor_pk_seq Type: SEQUENCE Owner: tperdue
1527 CREATE SEQUENCE "user_diary_monitor_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1530 -- TOC Entry ID 244 (OID 21993)
1532 -- Name: user_diary_monitor Type: TABLE Owner: tperdue
1535 CREATE TABLE "user_diary_monitor" (
1536 "monitor_id" integer DEFAULT nextval('user_diary_monitor_pk_seq'::text) NOT NULL,
1537 "monitored_user" integer DEFAULT '0' NOT NULL,
1538 "user_id" integer DEFAULT '0' NOT NULL,
1539 Constraint "user_diary_monitor_pkey" Primary Key ("monitor_id")
1543 -- TOC Entry ID 130 (OID 22011)
1545 -- Name: user_group_pk_seq Type: SEQUENCE Owner: tperdue
1548 CREATE SEQUENCE "user_group_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1551 -- TOC Entry ID 245 (OID 22030)
1553 -- Name: user_group Type: TABLE Owner: tperdue
1556 CREATE TABLE "user_group" (
1557 "user_group_id" integer DEFAULT nextval('user_group_pk_seq'::text) NOT NULL,
1558 "user_id" integer DEFAULT '0' NOT NULL,
1559 "group_id" integer DEFAULT '0' NOT NULL,
1560 "admin_flags" character(16) DEFAULT '' NOT NULL,
1561 "bug_flags" integer DEFAULT '0' NOT NULL,
1562 "forum_flags" integer DEFAULT '0' NOT NULL,
1563 "project_flags" integer DEFAULT '2' NOT NULL,
1564 "patch_flags" integer DEFAULT '1' NOT NULL,
1565 "support_flags" integer DEFAULT '1' NOT NULL,
1566 "doc_flags" integer DEFAULT '0' NOT NULL,
1567 "cvs_flags" integer DEFAULT '1' NOT NULL,
1568 "member_role" integer DEFAULT '100' NOT NULL,
1569 "release_flags" integer DEFAULT '0' NOT NULL,
1570 "artifact_flags" integer DEFAULT '0',
1571 Constraint "user_group_pkey" Primary Key ("user_group_id")
1575 -- TOC Entry ID 132 (OID 22069)
1577 -- Name: user_metric_pk_seq Type: SEQUENCE Owner: tperdue
1580 CREATE SEQUENCE "user_metric_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1583 -- TOC Entry ID 246 (OID 22088)
1585 -- Name: user_metric Type: TABLE Owner: tperdue
1588 CREATE TABLE "user_metric" (
1589 "ranking" integer DEFAULT nextval('user_metric_pk_seq'::text) NOT NULL,
1590 "user_id" integer DEFAULT '0' NOT NULL,
1591 "times_ranked" integer DEFAULT '0' NOT NULL,
1592 "avg_raters_importance" double precision DEFAULT '0.00000000' NOT NULL,
1593 "avg_rating" double precision DEFAULT '0.00000000' NOT NULL,
1594 "metric" double precision DEFAULT '0.00000000' NOT NULL,
1595 "percentile" double precision DEFAULT '0.00000000' NOT NULL,
1596 "importance_factor" double precision DEFAULT '0.00000000' NOT NULL,
1597 Constraint "user_metric_pkey" Primary Key ("ranking")
1601 -- TOC Entry ID 134 (OID 22116)
1603 -- Name: user_metric0_pk_seq Type: SEQUENCE Owner: tperdue
1606 CREATE SEQUENCE "user_metric0_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1609 -- TOC Entry ID 247 (OID 22135)
1611 -- Name: user_metric0 Type: TABLE Owner: tperdue
1614 CREATE TABLE "user_metric0" (
1615 "ranking" integer DEFAULT nextval('user_metric0_pk_seq'::text) NOT NULL,
1616 "user_id" integer DEFAULT '0' NOT NULL,
1617 "times_ranked" integer DEFAULT '0' NOT NULL,
1618 "avg_raters_importance" double precision DEFAULT '0.00000000' NOT NULL,
1619 "avg_rating" double precision DEFAULT '0.00000000' NOT NULL,
1620 "metric" double precision DEFAULT '0.00000000' NOT NULL,
1621 "percentile" double precision DEFAULT '0.00000000' NOT NULL,
1622 "importance_factor" double precision DEFAULT '0.00000000' NOT NULL,
1623 Constraint "user_metric0_pkey" Primary Key ("ranking")
1627 -- TOC Entry ID 248 (OID 22163)
1629 -- Name: user_preferences Type: TABLE Owner: tperdue
1632 CREATE TABLE "user_preferences" (
1633 "user_id" integer DEFAULT '0' NOT NULL,
1634 "preference_name" character varying(20),
1635 "preference_value" text,
1636 "set_date" integer DEFAULT '0' NOT NULL
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 'shell' 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/lib/postgresql/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" (
2563 "file_id" integer DEFAULT '0' NOT NULL,
2564 "downloads" integer DEFAULT '0' NOT NULL,
2565 Constraint "frs_dlstats_filetotal_agg_pkey" Primary Key ("file_id")
2569 -- TOC Entry ID 295 (OID 25759)
2571 -- Name: frs_dlstats_grouptotal_agg Type: TABLE Owner: tperdue
2574 CREATE TABLE "frs_dlstats_grouptotal_agg" (
2575 "group_id" integer DEFAULT '0' NOT NULL,
2576 "downloads" integer DEFAULT '0' NOT NULL
2580 -- TOC Entry ID 296 (OID 25773)
2582 -- Name: frs_dlstats_group_agg Type: TABLE Owner: tperdue
2585 CREATE TABLE "frs_dlstats_group_agg" (
2586 "group_id" integer DEFAULT '0' NOT NULL,
2587 "day" integer DEFAULT '0' NOT NULL,
2588 "downloads" integer DEFAULT '0' NOT NULL,
2589 "month" integer DEFAULT '0'
2593 -- TOC Entry ID 297 (OID 25792)
2595 -- Name: stats_project_months Type: TABLE Owner: tperdue
2598 CREATE TABLE "stats_project_months" (
2601 "developers" integer,
2602 "group_ranking" integer,
2603 "group_metric" double precision,
2604 "logo_showings" integer,
2605 "downloads" integer,
2606 "site_views" integer,
2607 "subdomain_views" integer,
2608 "page_views" integer,
2609 "file_releases" integer,
2610 "msg_posted" integer,
2611 "msg_uniq_auth" integer,
2612 "bugs_opened" integer,
2613 "bugs_closed" integer,
2614 "support_opened" integer,
2615 "support_closed" integer,
2616 "patches_opened" integer,
2617 "patches_closed" integer,
2618 "artifacts_opened" integer,
2619 "artifacts_closed" integer,
2620 "tasks_opened" integer,
2621 "tasks_closed" integer,
2622 "help_requests" integer,
2623 "cvs_checkouts" integer,
2624 "cvs_commits" integer,
2629 -- TOC Entry ID 298 (OID 25834)
2631 -- Name: stats_project_all Type: TABLE Owner: tperdue
2634 CREATE TABLE "stats_project_all" (
2636 "developers" integer,
2637 "group_ranking" integer,
2638 "group_metric" double precision,
2639 "logo_showings" integer,
2640 "downloads" integer,
2641 "site_views" integer,
2642 "subdomain_views" integer,
2643 "page_views" integer,
2644 "msg_posted" integer,
2645 "msg_uniq_auth" integer,
2646 "bugs_opened" integer,
2647 "bugs_closed" integer,
2648 "support_opened" integer,
2649 "support_closed" integer,
2650 "patches_opened" integer,
2651 "patches_closed" integer,
2652 "artifacts_opened" integer,
2653 "artifacts_closed" integer,
2654 "tasks_opened" integer,
2655 "tasks_closed" integer,
2656 "help_requests" integer,
2657 "cvs_checkouts" integer,
2658 "cvs_commits" integer,
2663 -- TOC Entry ID 299 (OID 25871)
2665 -- Name: stats_project_developers_last30 Type: TABLE Owner: tperdue
2668 CREATE TABLE "stats_project_developers_last30" (
2672 "developers" integer
2676 -- TOC Entry ID 300 (OID 25884)
2678 -- Name: stats_project_last_30 Type: TABLE Owner: tperdue
2681 CREATE TABLE "stats_project_last_30" (
2685 "developers" integer,
2686 "group_ranking" integer,
2687 "group_metric" double precision,
2688 "logo_showings" integer,
2689 "downloads" integer,
2690 "site_views" integer,
2691 "subdomain_views" integer,
2692 "page_views" integer,
2693 "filereleases" integer,
2694 "msg_posted" integer,
2695 "msg_uniq_auth" integer,
2696 "bugs_opened" integer,
2697 "bugs_closed" integer,
2698 "support_opened" integer,
2699 "support_closed" integer,
2700 "patches_opened" integer,
2701 "patches_closed" integer,
2702 "artifacts_opened" integer,
2703 "artifacts_closed" integer,
2704 "tasks_opened" integer,
2705 "tasks_closed" integer,
2706 "help_requests" integer,
2707 "cvs_checkouts" integer,
2708 "cvs_commits" integer,
2713 -- TOC Entry ID 301 (OID 25924)
2715 -- Name: stats_site_pages_by_month Type: TABLE Owner: tperdue
2718 CREATE TABLE "stats_site_pages_by_month" (
2720 "site_page_views" integer
2724 -- TOC Entry ID 302 (OID 25935)
2726 -- Name: stats_site_last_30 Type: TABLE Owner: tperdue
2729 CREATE TABLE "stats_site_last_30" (
2732 "site_page_views" integer,
2733 "downloads" integer,
2734 "subdomain_views" integer,
2735 "msg_posted" integer,
2736 "bugs_opened" integer,
2737 "bugs_closed" integer,
2738 "support_opened" integer,
2739 "support_closed" integer,
2740 "patches_opened" integer,
2741 "patches_closed" integer,
2742 "artifacts_opened" integer,
2743 "artifacts_closed" integer,
2744 "tasks_opened" integer,
2745 "tasks_closed" integer,
2746 "help_requests" integer,
2747 "cvs_checkouts" integer,
2748 "cvs_commits" integer,
2753 -- TOC Entry ID 303 (OID 25967)
2755 -- Name: stats_site_months Type: TABLE Owner: tperdue
2758 CREATE TABLE "stats_site_months" (
2760 "site_page_views" integer,
2761 "downloads" integer,
2762 "subdomain_views" integer,
2763 "msg_posted" integer,
2764 "bugs_opened" integer,
2765 "bugs_closed" integer,
2766 "support_opened" integer,
2767 "support_closed" integer,
2768 "patches_opened" integer,
2769 "patches_closed" integer,
2770 "artifacts_opened" integer,
2771 "artifacts_closed" integer,
2772 "tasks_opened" integer,
2773 "tasks_closed" integer,
2774 "help_requests" integer,
2775 "cvs_checkouts" integer,
2776 "cvs_commits" integer,
2781 -- TOC Entry ID 304 (OID 25998)
2783 -- Name: stats_site_all Type: TABLE Owner: tperdue
2786 CREATE TABLE "stats_site_all" (
2787 "site_page_views" integer,
2788 "downloads" integer,
2789 "subdomain_views" integer,
2790 "msg_posted" integer,
2791 "bugs_opened" integer,
2792 "bugs_closed" integer,
2793 "support_opened" integer,
2794 "support_closed" integer,
2795 "patches_opened" integer,
2796 "patches_closed" integer,
2797 "artifacts_opened" integer,
2798 "artifacts_closed" integer,
2799 "tasks_opened" integer,
2800 "tasks_closed" integer,
2801 "help_requests" integer,
2802 "cvs_checkouts" integer,
2803 "cvs_commits" integer,
2808 -- TOC Entry ID 305 (OID 26026)
2810 -- Name: trove_agg Type: TABLE Owner: tperdue
2813 CREATE TABLE "trove_agg" (
2814 "trove_cat_id" integer,
2816 "group_name" character varying(40),
2817 "unix_group_name" character varying(30),
2818 "status" character(1),
2819 "register_time" integer,
2820 "short_description" character varying(255),
2821 "percentile" double precision,
2826 -- TOC Entry ID 174 (OID 26050)
2828 -- Name: trove_treesum_trove_treesum_seq Type: SEQUENCE Owner: tperdue
2831 -- CREATE SEQUENCE "trove_treesum_trove_treesum_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
2834 -- TOC Entry ID 306 (OID 26069)
2836 -- Name: trove_treesums Type: TABLE Owner: tperdue
2839 CREATE TABLE "trove_treesums" (
2840 "trove_treesums_id" integer DEFAULT nextval('trove_treesums_pk_seq'::text) NOT NULL,
2841 "trove_cat_id" integer DEFAULT '0' NOT NULL,
2842 "limit_1" integer DEFAULT '0' NOT NULL,
2843 "subprojects" integer DEFAULT '0' NOT NULL,
2844 Constraint "trove_treesums_pkey" Primary Key ("trove_treesums_id")
2848 -- Data for TOC Entry ID 474 (OID 18743)
2850 -- Name: canned_responses Type: TABLE DATA Owner: tperdue
2854 COPY "canned_responses" FROM stdin;
2857 -- Data for TOC Entry ID 475 (OID 18793)
2859 -- Name: db_images Type: TABLE DATA Owner: tperdue
2863 COPY "db_images" FROM stdin;
2866 -- Data for TOC Entry ID 476 (OID 18859)
2868 -- Name: doc_data Type: TABLE DATA Owner: tperdue
2872 COPY "doc_data" FROM stdin;
2875 -- Data for TOC Entry ID 477 (OID 18924)
2877 -- Name: doc_groups Type: TABLE DATA Owner: tperdue
2881 COPY "doc_groups" FROM stdin;
2884 -- Data for TOC Entry ID 478 (OID 18961)
2886 -- Name: doc_states Type: TABLE DATA Owner: tperdue
2890 COPY "doc_states" FROM stdin;
2898 -- Data for TOC Entry ID 479 (OID 18996)
2900 -- Name: filemodule_monitor Type: TABLE DATA Owner: tperdue
2904 COPY "filemodule_monitor" FROM stdin;
2907 -- Data for TOC Entry ID 480 (OID 19033)
2909 -- Name: forum Type: TABLE DATA Owner: tperdue
2913 COPY "forum" FROM stdin;
2916 -- Data for TOC Entry ID 481 (OID 19080)
2918 -- Name: forum_agg_msg_count Type: TABLE DATA Owner: tperdue
2922 COPY "forum_agg_msg_count" FROM stdin;
2925 -- Data for TOC Entry ID 482 (OID 19115)
2927 -- Name: forum_group_list Type: TABLE DATA Owner: tperdue
2931 COPY "forum_group_list" FROM stdin;
2934 -- Data for TOC Entry ID 483 (OID 19173)
2936 -- Name: forum_monitored_forums Type: TABLE DATA Owner: tperdue
2940 COPY "forum_monitored_forums" FROM stdin;
2943 -- Data for TOC Entry ID 484 (OID 19210)
2945 -- Name: forum_saved_place Type: TABLE DATA Owner: tperdue
2949 COPY "forum_saved_place" FROM stdin;
2952 -- Data for TOC Entry ID 485 (OID 19230)
2954 -- Name: foundry_data Type: TABLE DATA Owner: tperdue
2958 COPY "foundry_data" FROM stdin;
2961 -- Data for TOC Entry ID 486 (OID 19287)
2963 -- Name: foundry_news Type: TABLE DATA Owner: tperdue
2967 COPY "foundry_news" FROM stdin;
2970 -- Data for TOC Entry ID 487 (OID 19328)
2972 -- Name: foundry_preferred_projects Type: TABLE DATA Owner: tperdue
2976 COPY "foundry_preferred_projects" FROM stdin;
2979 -- Data for TOC Entry ID 488 (OID 19367)
2981 -- Name: foundry_projects Type: TABLE DATA Owner: tperdue
2985 COPY "foundry_projects" FROM stdin;
2988 -- Data for TOC Entry ID 489 (OID 19404)
2990 -- Name: frs_file Type: TABLE DATA Owner: tperdue
2994 COPY "frs_file" FROM stdin;
2997 -- Data for TOC Entry ID 490 (OID 19465)
2999 -- Name: frs_filetype Type: TABLE DATA Owner: tperdue
3003 COPY "frs_filetype" FROM stdin;
3013 5900 Other Source File
3021 -- Data for TOC Entry ID 491 (OID 19514)
3023 -- Name: frs_package Type: TABLE DATA Owner: tperdue
3027 COPY "frs_package" FROM stdin;
3030 -- Data for TOC Entry ID 492 (OID 19567)
3032 -- Name: frs_processor Type: TABLE DATA Owner: tperdue
3036 COPY "frs_processor" FROM stdin;
3048 -- Data for TOC Entry ID 493 (OID 19616)
3050 -- Name: frs_release Type: TABLE DATA Owner: tperdue
3054 COPY "frs_release" FROM stdin;
3057 -- Data for TOC Entry ID 494 (OID 19677)
3059 -- Name: frs_status Type: TABLE DATA Owner: tperdue
3063 COPY "frs_status" FROM stdin;
3068 -- Data for TOC Entry ID 495 (OID 19745)
3070 -- Name: group_history Type: TABLE DATA Owner: tperdue
3074 COPY "group_history" FROM stdin;
3077 -- Data for TOC Entry ID 496 (OID 19802)
3079 -- Name: group_type Type: TABLE DATA Owner: tperdue
3083 COPY "group_type" FROM stdin;
3088 -- Data for TOC Entry ID 497 (OID 19851)
3090 -- Name: groups Type: TABLE DATA Owner: tperdue
3094 COPY "groups" FROM stdin;
3095 1 Site Admin \N 1 A siteadmin shell \N \N cvs \N \N \N 0 \N 1 1 1 1 1 1 1 1 0 1 1
3096 2 Site News Admin \N 1 A newsadmin shell \N \N cvs \N \N \N 0 \N 1 1 1 1 1 1 1 1 0 1 1
3097 3 Stats Group \N 0 A stats shell \N \N cvs \N \N \N 0 \N 1 1 1 1 1 1 1 1 0 1 1
3098 4 Peer Ratings Group \N 0 A peerrating shell \N \N cvs \N \N \N 0 \N 1 1 1 1 1 1 1 1 0 1 1
3101 -- Data for TOC Entry ID 499 (OID 19996)
3103 -- Name: mail_group_list Type: TABLE DATA Owner: tperdue
3107 COPY "mail_group_list" FROM stdin;
3110 -- Data for TOC Entry ID 500 (OID 20055)
3112 -- Name: news_bytes Type: TABLE DATA Owner: tperdue
3116 COPY "news_bytes" FROM stdin;
3119 -- Data for TOC Entry ID 501 (OID 20115)
3121 -- Name: people_job Type: TABLE DATA Owner: tperdue
3125 COPY "people_job" FROM stdin;
3128 -- Data for TOC Entry ID 502 (OID 20175)
3130 -- Name: people_job_category Type: TABLE DATA Owner: tperdue
3134 COPY "people_job_category" FROM stdin;
3141 7 Graphic/Other Designer 0
3144 -- Data for TOC Entry ID 503 (OID 20226)
3146 -- Name: people_job_inventory Type: TABLE DATA Owner: tperdue
3150 COPY "people_job_inventory" FROM stdin;
3153 -- Data for TOC Entry ID 504 (OID 20267)
3155 -- Name: people_job_status Type: TABLE DATA Owner: tperdue
3159 COPY "people_job_status" FROM stdin;
3165 -- Data for TOC Entry ID 505 (OID 20316)
3167 -- Name: people_skill Type: TABLE DATA Owner: tperdue
3171 COPY "people_skill" FROM stdin;
3174 -- Data for TOC Entry ID 506 (OID 20365)
3176 -- Name: people_skill_inventory Type: TABLE DATA Owner: tperdue
3180 COPY "people_skill_inventory" FROM stdin;
3183 -- Data for TOC Entry ID 507 (OID 20406)
3185 -- Name: people_skill_level Type: TABLE DATA Owner: tperdue
3189 COPY "people_skill_level" FROM stdin;
3197 -- Data for TOC Entry ID 508 (OID 20455)
3199 -- Name: people_skill_year Type: TABLE DATA Owner: tperdue
3203 COPY "people_skill_year" FROM stdin;
3211 -- Data for TOC Entry ID 509 (OID 20504)
3213 -- Name: project_assigned_to Type: TABLE DATA Owner: tperdue
3217 COPY "project_assigned_to" FROM stdin;
3220 -- Data for TOC Entry ID 510 (OID 20541)
3222 -- Name: project_dependencies Type: TABLE DATA Owner: tperdue
3226 COPY "project_dependencies" FROM stdin;
3229 -- Data for TOC Entry ID 511 (OID 20578)
3231 -- Name: project_group_list Type: TABLE DATA Owner: tperdue
3235 COPY "project_group_list" FROM stdin;
3239 -- Data for TOC Entry ID 512 (OID 20633)
3241 -- Name: project_history Type: TABLE DATA Owner: tperdue
3245 COPY "project_history" FROM stdin;
3248 -- Data for TOC Entry ID 513 (OID 20691)
3250 -- Name: project_metric Type: TABLE DATA Owner: tperdue
3254 COPY "project_metric" FROM stdin;
3257 -- Data for TOC Entry ID 514 (OID 20727)
3259 -- Name: project_metric_tmp1 Type: TABLE DATA Owner: tperdue
3263 -- COPY "project_metric_tmp1" FROM stdin;
3266 -- Data for TOC Entry ID 515 (OID 20782)
3268 -- Name: project_status Type: TABLE DATA Owner: tperdue
3272 COPY "project_status" FROM stdin;
3279 -- Data for TOC Entry ID 516 (OID 20832)
3281 -- Name: project_task Type: TABLE DATA Owner: tperdue
3285 COPY "project_task" FROM stdin;
3286 1 1 0 0 0 0 0 100 100
3289 -- Data for TOC Entry ID 517 (OID 20900)
3291 -- Name: project_weekly_metric Type: TABLE DATA Owner: tperdue
3295 COPY "project_weekly_metric" FROM stdin;
3298 -- Data for TOC Entry ID 518 (OID 20914)
3300 -- Name: session Type: TABLE DATA Owner: tperdue
3304 COPY "session" FROM stdin;
3307 -- Data for TOC Entry ID 519 (OID 20953)
3309 -- Name: snippet Type: TABLE DATA Owner: tperdue
3313 COPY "snippet" FROM stdin;
3316 -- Data for TOC Entry ID 520 (OID 21013)
3318 -- Name: snippet_package Type: TABLE DATA Owner: tperdue
3322 COPY "snippet_package" FROM stdin;
3325 -- Data for TOC Entry ID 521 (OID 21069)
3327 -- Name: snippet_package_item Type: TABLE DATA Owner: tperdue
3331 COPY "snippet_package_item" FROM stdin;
3334 -- Data for TOC Entry ID 522 (OID 21106)
3336 -- Name: snippet_package_version Type: TABLE DATA Owner: tperdue
3340 COPY "snippet_package_version" FROM stdin;
3343 -- Data for TOC Entry ID 523 (OID 21162)
3345 -- Name: snippet_version Type: TABLE DATA Owner: tperdue
3349 COPY "snippet_version" FROM stdin;
3352 -- Data for TOC Entry ID 524 (OID 21200)
3354 -- Name: stats_agg_logo_by_day Type: TABLE DATA Owner: tperdue
3358 COPY "stats_agg_logo_by_day" FROM stdin;
3361 -- Data for TOC Entry ID 525 (OID 21211)
3363 -- Name: stats_agg_pages_by_day Type: TABLE DATA Owner: tperdue
3367 COPY "stats_agg_pages_by_day" FROM stdin;
3370 -- Data for TOC Entry ID 526 (OID 21224)
3372 -- Name: stats_ftp_downloads Type: TABLE DATA Owner: tperdue
3376 COPY "stats_ftp_downloads" FROM stdin;
3379 -- Data for TOC Entry ID 527 (OID 21241)
3381 -- Name: stats_http_downloads Type: TABLE DATA Owner: tperdue
3385 COPY "stats_http_downloads" FROM stdin;
3388 -- Data for TOC Entry ID 528 (OID 21277)
3390 -- Name: supported_languages Type: TABLE DATA Owner: tperdue
3394 COPY "supported_languages" FROM stdin;
3395 1 English English.class English en
3396 2 Japanese Japanese.class Japanese ja
3397 3 Hebrew Hebrew.class Hebrew iw
3398 4 Spanish Spanish.class Spanish es
3399 5 Thai Thai.class Thai th
3400 6 German German.class German de
3401 7 French French.class French fr
3402 8 Italian Italian.class Italian it
3403 9 Norwegian Norwegian.class Norwegian no
3404 10 Swedish Swedish.class Swedish sv
3405 11 Trad.Chinese Chinese.class Chinese zh
3406 12 Dutch Dutch.class Dutch nl
3407 13 Esperanto Esperanto.class Esperanto eo
3408 14 Catalan Catalan.class Catalan ca
3409 15 Polish Polish.class Polish pl
3410 16 Pt. Brazillian PortugueseBrazillian.class PortugueseBrazillian pt
3411 17 Russian Russian.class Russian ru
3412 18 Portuguese Portuguese.class Portuguese pt
3413 19 Greek Greek.class Greek el
3414 20 Bulgarian Bulgarian.class Bulgarian bg
3415 21 Indonesian Indonesian.class Indonesian id
3416 22 Korean Korean.class Korean ko
3417 23 Smpl.Chinese SimplifiedChinese.class SimplifiedChinese zn
3420 -- Data for TOC Entry ID 529 (OID 21329)
3422 -- Name: survey_question_types Type: TABLE DATA Owner: tperdue
3426 COPY "survey_question_types" FROM stdin;
3429 3 Radio Buttons Yes/No
3435 -- Data for TOC Entry ID 530 (OID 21379)
3437 -- Name: survey_questions Type: TABLE DATA Owner: tperdue
3441 COPY "survey_questions" FROM stdin;
3444 -- Data for TOC Entry ID 531 (OID 21414)
3446 -- Name: survey_rating_aggregate Type: TABLE DATA Owner: tperdue
3450 COPY "survey_rating_aggregate" FROM stdin;
3453 -- Data for TOC Entry ID 532 (OID 21431)
3455 -- Name: survey_rating_response Type: TABLE DATA Owner: tperdue
3459 COPY "survey_rating_response" FROM stdin;
3462 -- Data for TOC Entry ID 533 (OID 21450)
3464 -- Name: survey_responses Type: TABLE DATA Owner: tperdue
3468 COPY "survey_responses" FROM stdin;
3471 -- Data for TOC Entry ID 534 (OID 21505)
3473 -- Name: surveys Type: TABLE DATA Owner: tperdue
3477 COPY "surveys" FROM stdin;
3480 -- Data for TOC Entry ID 535 (OID 21637)
3482 -- Name: theme_prefs Type: TABLE DATA Owner: tperdue
3486 COPY "theme_prefs" FROM stdin;
3489 -- Data for TOC Entry ID 536 (OID 21684)
3491 -- Name: themes Type: TABLE DATA Owner: tperdue
3495 COPY "themes" FROM stdin;
3496 1 forged Forged Metal
3497 2 classic Classic Sourceforge
3498 3 ultralite Ultra Lite
3503 -- Data for TOC Entry ID 537 (OID 21700)
3505 -- Name: top_group Type: TABLE DATA Owner: tperdue
3509 COPY "top_group" FROM stdin;
3512 -- Data for TOC Entry ID 538 (OID 21761)
3514 -- Name: trove_cat Type: TABLE DATA Owner: tperdue
3518 COPY "trove_cat" FROM stdin;
3519 1 2000031601 0 0 audience Intended Audience The main class of people likely to be interested in this resource. 0 0 Intended Audience 1
3520 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
3521 3 2000041101 1 1 developers Developers Programs and resources for software developers, to include libraries. 0 0 Intended Audience :: Developers 1 :: 3
3522 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
3523 5 2000040701 1 1 other Other Audience Programs and resources for an unlisted audience. 0 0 Intended Audience :: Other Audience 1 :: 5
3524 6 2000031601 0 0 developmentstatus Development Status An indication of the development status of the software or resource. 0 0 Development Status 6
3525 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
3526 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
3527 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
3528 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
3529 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
3530 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
3531 13 2000031601 0 0 license License License terms under which the resource is distributed. 0 0 License 13
3532 197 2000032001 13 13 publicdomain Public Domain Public Domain. No author-retained rights. 0 0 License :: Public Domain 13 :: 197
3533 196 2000040701 13 13 other Other/Proprietary License Non OSI-Approved/Proprietary license. 0 0 License :: Other/Proprietary License 13 :: 196
3534 14 2000032401 13 13 osi OSI Approved Licenses that have been approved by OSI as approved 0 0 License :: OSI Approved 13 :: 14
3535 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
3536 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
3537 139 2000032001 136 18 boot Boot Programs for bootstrapping your OS. 0 0 Topic :: System :: Boot 18 :: 136 :: 139
3538 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
3539 138 2000032001 136 18 benchmark Benchmark Programs for benchmarking system performance. 0 0 Topic :: System :: Benchmark 18 :: 136 :: 138
3540 74 2000042701 136 18 emulators Emulators Emulations of foreign operating systme and machines. 0 0 Topic :: System :: Emulators 18 :: 136 :: 74
3541 19 2000032001 136 18 archiving Archiving Tools for maintaining and searching software or document archives. 0 0 Topic :: System :: Archiving 18 :: 136 :: 19
3542 137 2000032001 19 18 backup Backup Programs to manage and sequence system backup. 0 0 Topic :: System :: Archiving :: Backup 18 :: 136 :: 19 :: 137
3543 42 2000031601 19 18 compression Compression Tools and libraries for data compression. 0 0 Topic :: System :: Archiving :: Compression 18 :: 136 :: 19 :: 42
3544 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
3545 132 2000032001 18 18 religion Religion Programs relating to religion and sacred texts. 0 0 Topic :: Religion 18 :: 132
3546 129 2000031701 18 18 office Office/Business Software for assisting and organizing work at your desk. 0 0 Topic :: Office/Business 18 :: 129
3547 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
3548 130 2000031701 129 18 scheduling Scheduling Projects for scheduling time, to include project management. 0 0 Topic :: Office/Business :: Scheduling 18 :: 129 :: 130
3549 75 2000031701 129 18 financial Financial Programs related to finance. 0 0 Topic :: Office/Business :: Financial 18 :: 129 :: 75
3550 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
3551 78 2000031601 75 18 spreadsheet Spreadsheet Spreadsheet applications. 0 0 Topic :: Office/Business :: Financial :: Spreadsheet 18 :: 129 :: 75 :: 78
3552 77 2000031601 75 18 investment Investment Programs for assisting in financial investment. 0 0 Topic :: Office/Business :: Financial :: Investment 18 :: 129 :: 75 :: 77
3553 76 2000031601 75 18 accounting Accounting Checkbook balancers and accounting programs. 0 0 Topic :: Office/Business :: Financial :: Accounting 18 :: 129 :: 75 :: 76
3554 234 2000040701 18 18 other Other/Nonlisted Topic Topic does not fit into any listed category. 0 0 Topic :: Other/Nonlisted Topic 18 :: 234
3555 156 2000032001 18 18 terminals Terminals Terminal emulators, terminal programs, and terminal session utilities. 0 0 Topic :: Terminals 18 :: 156
3556 159 2000032001 156 18 telnet Telnet Support for telnet; terminal sessions across Internet links. 0 0 Topic :: Terminals :: Telnet 18 :: 156 :: 159
3557 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
3558 157 2000032001 156 18 serial Serial Dialup, terminal emulation, and file transfer over serial lines. 0 0 Topic :: Terminals :: Serial 18 :: 156 :: 157
3559 115 2000031701 113 18 capture Capture/Recording Sound capture and recording. 0 0 Topic :: Multimedia :: Sound/Audio :: Capture/Recording 18 :: 99 :: 113 :: 115
3560 114 2000031701 113 18 analysis Analysis Sound analysis tools, to include frequency analysis. 0 0 Topic :: Multimedia :: Sound/Audio :: Analysis 18 :: 99 :: 113 :: 114
3561 100 2000031601 99 18 graphics Graphics Tools and resources for computer graphics. 0 0 Topic :: Multimedia :: Graphics 18 :: 99 :: 100
3562 112 2000031701 100 18 viewers Viewers Programs that can display various graphics formats. 0 0 Topic :: Multimedia :: Graphics :: Viewers 18 :: 99 :: 100 :: 112
3563 111 2000031701 100 18 presentation Presentation Tools for generating presentation graphics and slides. 0 0 Topic :: Multimedia :: Graphics :: Presentation 18 :: 99 :: 100 :: 111
3564 110 2000031701 100 18 3drendering 3D Rendering Programs which render 3D models. 0 0 Topic :: Multimedia :: Graphics :: 3D Rendering 18 :: 99 :: 100 :: 110
3565 109 2000031701 100 18 3dmodeling 3D Modeling Programs for working with 3D Models. 0 0 Topic :: Multimedia :: Graphics :: 3D Modeling 18 :: 99 :: 100 :: 109
3566 106 2000031701 100 18 editors Editors Drawing, painting, and structured editing programs. 0 0 Topic :: Multimedia :: Graphics :: Editors 18 :: 99 :: 100 :: 106
3567 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
3568 107 2000031701 106 18 vector Vector-Based Vector-Based drawing programs. 0 0 Topic :: Multimedia :: Graphics :: Editors :: Vector-Based 18 :: 99 :: 100 :: 106 :: 107
3569 105 2000031701 100 18 conversion Graphics Conversion Programs which convert between graphics formats. 0 0 Topic :: Multimedia :: Graphics :: Graphics Conversion 18 :: 99 :: 100 :: 105
3570 101 2000031601 100 18 capture Capture Support for scanners, cameras, and screen capture. 0 0 Topic :: Multimedia :: Graphics :: Capture 18 :: 99 :: 100 :: 101
3571 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
3572 103 2000031601 101 18 cameras Digital Camera Digital Camera 0 0 Topic :: Multimedia :: Graphics :: Capture :: Digital Camera 18 :: 99 :: 100 :: 101 :: 103
3573 102 2000031601 101 18 scanners Scanners Support for graphic scanners. 0 0 Topic :: Multimedia :: Graphics :: Capture :: Scanners 18 :: 99 :: 100 :: 101 :: 102
3574 154 2000032001 18 18 printing Printing Tools, daemons, and utilities for printer control. 0 0 Topic :: Printing 18 :: 154
3575 136 2000032001 18 18 system System Operating system core and administration utilities. 0 0 Topic :: System 18 :: 136
3576 294 2001032001 136 18 shells System Shells System Shells 0 0 Topic :: System :: System Shells 18 :: 136 :: 294
3577 257 2000071101 136 18 softwaredist Software Distribution Systems software for distributing other software. 0 0 Topic :: System :: Software Distribution 18 :: 136 :: 257
3578 253 2000071101 136 18 sysadministration Systems Administration Systems Administration Software (e.g. configuration apps.) 0 0 Topic :: System :: Systems Administration 18 :: 136 :: 253
3579 289 2001032001 253 18 authentication Authentication/Directory Authentication and directory services 0 0 Topic :: System :: Systems Administration :: Authentication/Directory 18 :: 136 :: 253 :: 289
3580 291 2001032001 289 18 ldap LDAP Leightweight directory access protocol 0 0 Topic :: System :: Systems Administration :: Authentication/Directory :: LDAP 18 :: 136 :: 253 :: 289 :: 291
3581 290 2001032001 289 18 nis NIS NIS services 0 0 Topic :: System :: Systems Administration :: Authentication/Directory :: NIS 18 :: 136 :: 253 :: 289 :: 290
3582 153 2000032001 136 18 power Power (UPS) Code for communication with uninterruptible power supplies. 0 0 Topic :: System :: Power (UPS) 18 :: 136 :: 153
3583 150 2000032001 136 18 networking Networking Network configuration and administration. 0 0 Topic :: System :: Networking 18 :: 136 :: 150
3584 152 2000032001 150 18 monitoring Monitoring System monitoring, traffic analysis, and sniffers. 0 0 Topic :: System :: Networking :: Monitoring 18 :: 136 :: 150 :: 152
3585 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
3586 151 2000032001 150 18 firewalls Firewalls Firewalls and filtering systems. 0 0 Topic :: System :: Networking :: Firewalls 18 :: 136 :: 150 :: 151
3587 148 2000032001 136 18 logging Logging Utilities for clearing, rotating, and digesting system logs. 0 0 Topic :: System :: Logging 18 :: 136 :: 148
3588 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
3589 146 2000032001 136 18 hardware Hardware Tools for direct, non-kernel control and configuration of hardware. 0 0 Topic :: System :: Hardware 18 :: 136 :: 146
3590 292 2001032001 146 18 drivers Hardware Drivers Hardware Drivers 0 0 Topic :: System :: Hardware :: Hardware Drivers 18 :: 136 :: 146 :: 292
3591 144 2000032001 136 18 kernels Operating System Kernels OS Kernels, patches, modules, and tools. 0 0 Topic :: System :: Operating System Kernels 18 :: 136 :: 144
3592 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
3593 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
3594 143 2000032001 144 18 linux Linux The Linux kernel, patches, and modules. 0 0 Topic :: System :: Operating System Kernels :: Linux 18 :: 136 :: 144 :: 143
3595 142 2000032001 136 18 filesystems Filesystems Support for creating, editing, reading, and writing file systems. 0 0 Topic :: System :: Filesystems 18 :: 136 :: 142
3596 287 2001032001 80 18 boardgames Board Games Board Games 0 0 Topic :: Games/Entertainment :: Board Games 18 :: 80 :: 287
3597 268 2000082101 80 18 Puzzles Puzzle Games Puzzle Games 0 0 Topic :: Games/Entertainment :: Puzzle Games 18 :: 80 :: 268
3598 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
3599 85 2000031601 80 18 simulation Simulation Simulation games 0 0 Topic :: Games/Entertainment :: Simulation 18 :: 80 :: 85
3600 84 2000031601 80 18 rpg Role-Playing Role-Playing games 0 0 Topic :: Games/Entertainment :: Role-Playing 18 :: 80 :: 84
3601 83 2000032401 80 18 turnbasedstrategy Turn Based Strategy Turn Based Strategy 0 0 Topic :: Games/Entertainment :: Turn Based Strategy 18 :: 80 :: 83
3602 82 2000031601 80 18 firstpersonshooters First Person Shooters First Person Shooters. 0 0 Topic :: Games/Entertainment :: First Person Shooters 18 :: 80 :: 82
3603 81 2000031601 80 18 realtimestrategy Real Time Strategy Real Time strategy games 0 0 Topic :: Games/Entertainment :: Real Time Strategy 18 :: 80 :: 81
3604 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
3605 71 2000031601 18 18 education Education Programs and tools for educating yourself or others. 0 0 Topic :: Education 18 :: 71
3606 73 2000031601 71 18 testing Testing Tools for testing someone's knowledge on a subject. 0 0 Topic :: Education :: Testing 18 :: 71 :: 73
3607 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
3608 66 2000031601 18 18 database Database Front ends, engines, and tools for database work. 0 0 Topic :: Database 18 :: 66
3609 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
3610 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
3611 63 2000032001 18 18 editors Text Editors Programs for editing code and documents. 0 0 Topic :: Text Editors 18 :: 63
3612 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
3613 70 2000031601 63 18 wordprocessors Word Processors WYSIWYG word processors. 0 0 Topic :: Text Editors :: Word Processors 18 :: 63 :: 70
3614 69 2000031601 63 18 documentation Documentation Tools for the creation and use of documentation. 0 0 Topic :: Text Editors :: Documentation 18 :: 63 :: 69
3615 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
3616 64 2000031601 63 18 emacs Emacs GNU Emacs and its imitators and tools. 0 0 Topic :: Text Editors :: Emacs 18 :: 63 :: 64
3617 125 2000031701 99 18 video Video Video capture, editing, and playback. 0 0 Topic :: Multimedia :: Video 18 :: 99 :: 125
3618 126 2000031701 125 18 capture Capture Video capture tools. 0 0 Topic :: Multimedia :: Video :: Capture 18 :: 99 :: 125 :: 126
3619 256 2000071101 125 18 nonlineareditor Non-Linear Editor Video Non-Linear Editors 0 0 Topic :: Multimedia :: Video :: Non-Linear Editor 18 :: 99 :: 125 :: 256
3620 128 2000031701 125 18 display Display Programs which display various video formats. 0 0 Topic :: Multimedia :: Video :: Display 18 :: 99 :: 125 :: 128
3621 127 2000031701 125 18 conversion Conversion Programs which convert between video formats. 0 0 Topic :: Multimedia :: Video :: Conversion 18 :: 99 :: 125 :: 127
3622 113 2000031701 99 18 sound Sound/Audio Tools for generating, editing, analyzing, and playing sound. 0 0 Topic :: Multimedia :: Sound/Audio 18 :: 99 :: 113
3623 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
3624 248 2000042801 113 18 midi MIDI Software related to MIDI synthesis and playback. 0 0 Topic :: Multimedia :: Sound/Audio :: MIDI 18 :: 99 :: 113 :: 248
3625 124 2000031701 113 18 speech Speech Speech manipulation and intepretation tools. 0 0 Topic :: Multimedia :: Sound/Audio :: Speech 18 :: 99 :: 113 :: 124
3626 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
3627 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
3628 121 2000031701 113 18 mixers Mixers Programs to mix audio. 0 0 Topic :: Multimedia :: Sound/Audio :: Mixers 18 :: 99 :: 113 :: 121
3629 120 2000031701 113 18 editors Editors Programs to edit/manipulate sound data. 0 0 Topic :: Multimedia :: Sound/Audio :: Editors 18 :: 99 :: 113 :: 120
3630 119 2000031701 113 18 conversion Conversion Programs to convert between audio formats. 0 0 Topic :: Multimedia :: Sound/Audio :: Conversion 18 :: 99 :: 113 :: 119
3631 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
3632 88 2000031601 87 18 finger Finger The Finger protocol for getting information about users. 0 0 Topic :: Internet :: Finger 18 :: 87 :: 88
3633 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
3634 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
3635 260 2000071401 52 18 SCCS SCCS SCCS 0 0 Topic :: Software Development :: Version Control :: SCCS 18 :: 45 :: 52 :: 260
3636 54 2000031601 52 18 rcs RCS Tools for RCS (Revision Control System). 0 0 Topic :: Software Development :: Version Control :: RCS 18 :: 45 :: 52 :: 54
3637 53 2000031601 52 18 cvs CVS Tools for CVS (Concurrent Versioning System). 0 0 Topic :: Software Development :: Version Control :: CVS 18 :: 45 :: 52 :: 53
3638 50 2000031601 45 18 objectbrokering Object Brokering Object brokering libraries and tools. 0 0 Topic :: Software Development :: Object Brokering 18 :: 45 :: 50
3639 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
3640 49 2000031601 45 18 interpreters Interpreters Programs for interpreting and executing high-level languages directly. 0 0 Topic :: Software Development :: Interpreters 18 :: 45 :: 49
3641 48 2000031601 45 18 compilers Compilers Programs for compiling high-level languges into machine code. 0 0 Topic :: Software Development :: Compilers 18 :: 45 :: 48
3642 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
3643 46 2000031601 45 18 build Build Tools Software for the build process. 0 0 Topic :: Software Development :: Build Tools 18 :: 45 :: 46
3644 43 2000031601 18 18 security Security Security-related software, to include system administration and cryptography. 0 0 Topic :: Security 18 :: 43
3645 44 2000031601 43 18 cryptography Cryptography Cryptography programs, algorithms, and libraries. 0 0 Topic :: Security :: Cryptography 18 :: 43 :: 44
3646 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
3647 98 2000031601 97 18 mathematics Mathematics Software to support pure and applied mathematics. 0 0 Topic :: Scientific/Engineering :: Mathematics 18 :: 97 :: 98
3648 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
3649 266 2000081601 97 18 medical Medical Science Apps. Medical / BioMedical Science Apps. 0 0 Topic :: Scientific/Engineering :: Medical Science Apps. 18 :: 97 :: 266
3650 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
3651 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
3652 135 2000032001 97 18 visualization Visualization Software for scientific visualization. 0 0 Topic :: Scientific/Engineering :: Visualization 18 :: 97 :: 135
3653 134 2000032001 97 18 astronomy Astronomy Software and tools related to astronomy. 0 0 Topic :: Scientific/Engineering :: Astronomy 18 :: 97 :: 134
3654 133 2000032001 97 18 ai Artificial Intelligence Artificial Intelligence. 0 0 Topic :: Scientific/Engineering :: Artificial Intelligence 18 :: 97 :: 133
3655 87 2000031601 18 18 internet Internet Tools to assist human access to the Internet. 0 0 Topic :: Internet 18 :: 87
3656 270 2000083101 87 18 WAP WAP Wireless Access Protocol 0 0 Topic :: Internet :: WAP 18 :: 87 :: 270
3657 245 2000042701 87 18 loganalysis Log Analysis Software to help analyze various log files. 0 0 Topic :: Internet :: Log Analysis 18 :: 87 :: 245
3658 149 2000032001 87 18 dns Name Service (DNS) Domain name system servers and utilities. 0 0 Topic :: Internet :: Name Service (DNS) 18 :: 87 :: 149
3659 90 2000031601 87 18 www WWW/HTTP Programs and tools for the World Wide Web. 0 0 Topic :: Internet :: WWW/HTTP 18 :: 87 :: 90
3660 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
3661 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
3662 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
3663 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
3664 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
3665 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
3666 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
3667 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
3668 91 2000031601 90 18 browsers Browsers Web Browsers 0 0 Topic :: Internet :: WWW/HTTP :: Browsers 18 :: 87 :: 90 :: 91
3669 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
3670 80 2000031601 18 18 games Games/Entertainment Games and Entertainment software. 0 0 Topic :: Games/Entertainment 18 :: 80
3671 18 2000031601 0 0 topic Topic Topic categorization. 0 0 Topic 18
3672 20 2000032401 18 18 communications Communications Programs intended to facilitate communication between people. 0 0 Topic :: Communications 18 :: 20
3673 27 2000031601 20 18 conferencing Conferencing Software to support real-time conferencing over the Internet. 0 0 Topic :: Communications :: Conferencing 18 :: 20 :: 27
3674 22 2000031601 20 18 chat Chat Programs to support real-time communication over the Internet. 0 0 Topic :: Communications :: Chat 18 :: 20 :: 22
3675 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
3676 25 2000031601 22 18 talk Unix Talk Programs to support Unix Talk protocol. 0 0 Topic :: Communications :: Chat :: Unix Talk 18 :: 20 :: 22 :: 25
3677 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
3678 23 2000031601 22 18 icq ICQ Programs to support ICQ. 0 0 Topic :: Communications :: Chat :: ICQ 18 :: 20 :: 22 :: 23
3679 21 2000031601 20 18 bbs BBS Bulletin Board systems. 0 0 Topic :: Communications :: BBS 18 :: 20 :: 21
3680 251 2000050101 20 18 filesharing File Sharing Software for person-to-person online file sharing. 0 0 Topic :: Communications :: File Sharing 18 :: 20 :: 251
3681 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
3682 286 2001032001 251 18 gnutella Gnutella Projects based around the gnutella protocol. 0 0 Topic :: Communications :: File Sharing :: Gnutella 18 :: 20 :: 251 :: 286
3683 247 2000042701 20 18 telephony Telephony Telephony related applications, to include automated voice response systems. 0 0 Topic :: Communications :: Telephony 18 :: 20 :: 247
3684 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
3685 39 2000031601 20 18 usenet Usenet News Software to support USENET news. 0 0 Topic :: Communications :: Usenet News 18 :: 20 :: 39
3686 38 2000031601 20 18 hamradio Ham Radio Tools and resources for amateur radio. 0 0 Topic :: Communications :: Ham Radio 18 :: 20 :: 38
3687 37 2000031601 20 18 fido FIDO Tools for FIDOnet mail and echoes. 0 0 Topic :: Communications :: FIDO 18 :: 20 :: 37
3688 36 2000031601 20 18 fax Fax Tools for sending and receiving facsimile messages. 0 0 Topic :: Communications :: Fax 18 :: 20 :: 36
3689 28 2000031601 20 18 email Email Programs for sending, processing, and handling electronic mail. 0 0 Topic :: Communications :: Email 18 :: 20 :: 28
3690 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
3691 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
3692 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
3693 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
3694 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
3695 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
3696 29 2000031601 28 18 filters Filters Content-driven filters and dispatchers for Email. 0 0 Topic :: Communications :: Email :: Filters 18 :: 20 :: 28 :: 29
3697 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
3698 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
3699 297 2001041701 14 13 vsl Vovida Software License Vovida Software License 0 0 License :: OSI Approved :: Vovida Software License 13 :: 14 :: 297
3700 195 2000032001 14 13 zlib zlib/libpng License zlib/libpng License 0 0 License :: OSI Approved :: zlib/libpng License 13 :: 14 :: 195
3701 194 2000032001 14 13 python Python License Python License 0 0 License :: OSI Approved :: Python License 13 :: 14 :: 194
3702 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
3703 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
3704 191 2000032001 14 13 ibm IBM Public License IBM Public License 0 0 License :: OSI Approved :: IBM Public License 13 :: 14 :: 191
3705 190 2000032001 14 13 qpl QT Public License (QPL) QT Public License 0 0 License :: OSI Approved :: QT Public License (QPL) 13 :: 14 :: 190
3706 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
3707 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
3708 199 2000032101 0 0 os Operating System What operating system the program requires to run, if any. 0 0 Operating System 199
3709 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
3710 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
3711 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
3712 203 2000041101 202 199 freebsd FreeBSD FreeBSD 0 0 Operating System :: POSIX :: BSD :: FreeBSD 199 :: 200 :: 202 :: 203
3713 204 2000032101 202 199 netbsd NetBSD NetBSD 0 0 Operating System :: POSIX :: BSD :: NetBSD 199 :: 200 :: 202 :: 204
3714 205 2000032101 202 199 openbsd OpenBSD OpenBSD 0 0 Operating System :: POSIX :: BSD :: OpenBSD 199 :: 200 :: 202 :: 205
3715 206 2000032101 202 199 bsdos BSD/OS BSD/OS 0 0 Operating System :: POSIX :: BSD :: BSD/OS 199 :: 200 :: 202 :: 206
3716 207 2000032101 200 199 sun SunOS/Solaris Any Sun Microsystems OS. 0 0 Operating System :: POSIX :: SunOS/Solaris 199 :: 200 :: 207
3717 208 2000032101 200 199 sco SCO SCO 0 0 Operating System :: POSIX :: SCO 199 :: 200 :: 208
3718 209 2000032101 200 199 hpux HP-UX HP-UX 0 0 Operating System :: POSIX :: HP-UX 199 :: 200 :: 209
3719 210 2000032101 200 199 aix AIX AIX 0 0 Operating System :: POSIX :: AIX 199 :: 200 :: 210
3720 211 2000032101 200 199 irix IRIX IRIX 0 0 Operating System :: POSIX :: IRIX 199 :: 200 :: 211
3721 212 2000032101 200 199 other Other Other specific POSIX OS, specified in description. 0 0 Operating System :: POSIX :: Other 199 :: 200 :: 212
3722 282 2000121901 18 18 Sociology Sociology Social / Informational - Family / etc. 0 0 Topic :: Sociology 18 :: 282
3723 214 2000032101 199 199 microsoft Microsoft Microsoft operating systems. 0 0 Operating System :: Microsoft 199 :: 214
3724 215 2000032101 214 199 msdos MS-DOS Microsoft Disk Operating System (DOS) 0 0 Operating System :: Microsoft :: MS-DOS 199 :: 214 :: 215
3725 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
3726 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
3727 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
3728 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
3729 220 2000032101 199 199 os2 OS/2 OS/2 0 0 Operating System :: OS/2 199 :: 220
3730 221 2000032101 199 199 macos MacOS MacOS 0 0 Operating System :: MacOS 199 :: 221
3731 222 2000032101 216 199 wince Windows CE Windows CE 0 0 Operating System :: Microsoft :: Windows :: Windows CE 199 :: 214 :: 216 :: 222
3732 223 2000032101 199 199 palmos PalmOS PalmOS (for Palm Pilot) 0 0 Operating System :: PalmOS 199 :: 223
3733 224 2000032101 199 199 beos BeOS BeOS 0 0 Operating System :: BeOS 199 :: 224
3734 225 2000032101 0 0 environment Environment Run-time environment required for this program. 0 0 Environment 225
3735 226 2000041101 225 225 console Console (Text Based) Console-based programs. 0 0 Environment :: Console (Text Based) 225 :: 226
3736 227 2000032401 226 225 curses Curses Curses-based software. 0 0 Environment :: Console (Text Based) :: Curses 225 :: 226 :: 227
3737 228 2000040701 226 225 newt Newt Newt 0 0 Environment :: Console (Text Based) :: Newt 225 :: 226 :: 228
3738 229 2000040701 225 225 x11 X11 Applications Programs that run in an X windowing environment. 0 0 Environment :: X11 Applications 225 :: 229
3739 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
3740 231 2000040701 229 225 gnome Gnome Programs designed to run in a Gnome environment. 0 0 Environment :: X11 Applications :: Gnome 225 :: 229 :: 231
3741 232 2000040701 229 225 kde KDE Programs designed to run in a KDE environment. 0 0 Environment :: X11 Applications :: KDE 225 :: 229 :: 232
3742 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
3743 283 2000121901 282 18 History History History / Informational 0 0 Topic :: Sociology :: History 18 :: 282 :: 283
3744 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
3745 236 2000040701 199 199 other Other OS Program is designe for a nonlisted operating system. 0 0 Operating System :: Other OS 199 :: 236
3746 237 2000041001 225 225 web Web Environment This software is designed for a web environment. 0 0 Environment :: Web Environment 225 :: 237
3747 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
3748 284 2000121901 282 18 Genealogy Genealogy Family History / Genealogy 0 0 Topic :: Sociology :: Genealogy 18 :: 282 :: 284
3749 240 2000041301 200 199 gnuhurd GNU Hurd GNU Hurd 0 0 Operating System :: POSIX :: GNU Hurd 199 :: 200 :: 240
3750 55 2000031601 18 18 desktop Desktop Environment Accessories, managers, and utilities for your GUI desktop. 0 0 Topic :: Desktop Environment 18 :: 55
3751 58 2000031601 55 18 gnome Gnome Software for the Gnome desktop. 0 0 Topic :: Desktop Environment :: Gnome 18 :: 55 :: 58
3752 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
3753 61 2000031601 57 18 themes Themes Themes for KDE. 0 0 Topic :: Desktop Environment :: K Desktop Environment (KDE) :: Themes 18 :: 55 :: 57 :: 61
3754 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
3755 59 2000031601 56 18 enlightenment Enlightenment Software for the Enlightenment window manager. 0 0 Topic :: Desktop Environment :: Window Managers :: Enlightenment 18 :: 55 :: 56 :: 59
3756 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
3757 62 2000031601 55 18 screensavers Screen Savers Screen savers and lockers. 0 0 Topic :: Desktop Environment :: Screen Savers 18 :: 55 :: 62
3758 259 2000071401 45 18 codegen Code Generators Code Generators 0 0 Topic :: Software Development :: Code Generators 18 :: 45 :: 259
3759 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
3760 160 2000032001 0 0 language Programming Language Language in which this program was written, or was meant to support. 0 0 Programming Language 160
3761 161 2000032001 160 160 apl APL APL 0 0 Programming Language :: APL 160 :: 161
3762 164 2000032001 160 160 c C C 0 0 Programming Language :: C 160 :: 164
3763 162 2000032001 160 160 assembly Assembly Assembly-level programs. Platform specific. 0 0 Programming Language :: Assembly 160 :: 162
3764 163 2000051001 160 160 ada Ada Ada 0 0 Programming Language :: Ada 160 :: 163
3765 165 2000032001 160 160 cpp C++ C++ 0 0 Programming Language :: C++ 160 :: 165
3766 166 2000032401 160 160 eiffel Eiffel Eiffel 0 0 Programming Language :: Eiffel 160 :: 166
3767 167 2000032001 160 160 euler Euler Euler 0 0 Programming Language :: Euler 160 :: 167
3768 168 2000032001 160 160 forth Forth Forth 0 0 Programming Language :: Forth 160 :: 168
3769 169 2000032001 160 160 fortran Fortran Fortran 0 0 Programming Language :: Fortran 160 :: 169
3770 170 2000032001 160 160 lisp Lisp Lisp 0 0 Programming Language :: Lisp 160 :: 170
3771 171 2000041101 160 160 logo Logo Logo 0 0 Programming Language :: Logo 160 :: 171
3772 172 2000032001 160 160 ml ML ML 0 0 Programming Language :: ML 160 :: 172
3773 173 2000032001 160 160 modula Modula Modula-2 or Modula-3 0 0 Programming Language :: Modula 160 :: 173
3774 174 2000032001 160 160 objectivec Objective C Objective C 0 0 Programming Language :: Objective C 160 :: 174
3775 175 2000032001 160 160 pascal Pascal Pascal 0 0 Programming Language :: Pascal 160 :: 175
3776 176 2000032001 160 160 perl Perl Perl 0 0 Programming Language :: Perl 160 :: 176
3777 177 2000032001 160 160 prolog Prolog Prolog 0 0 Programming Language :: Prolog 160 :: 177
3778 178 2000032001 160 160 python Python Python 0 0 Programming Language :: Python 160 :: 178
3779 179 2000032001 160 160 rexx Rexx Rexx 0 0 Programming Language :: Rexx 160 :: 179
3780 180 2000032001 160 160 simula Simula Simula 0 0 Programming Language :: Simula 160 :: 180
3781 181 2000032001 160 160 smalltalk Smalltalk Smalltalk 0 0 Programming Language :: Smalltalk 160 :: 181
3782 182 2000032001 160 160 tcl Tcl Tcl 0 0 Programming Language :: Tcl 160 :: 182
3783 183 2000032001 160 160 php PHP PHP 0 0 Programming Language :: PHP 160 :: 183
3784 263 2000080401 160 160 euphoria Euphoria Euphoria programming language - http://www.rapideuphoria.com/ 0 0 Programming Language :: Euphoria 160 :: 263
3785 264 2000080701 160 160 erlang Erlang Erlang - developed by Ericsson - http://www.erlang.org/ 0 0 Programming Language :: Erlang 160 :: 264
3786 267 2000082001 160 160 zope Zope Zope Object Publishing 0 0 Programming Language :: Zope 160 :: 267
3787 269 2000082801 160 160 asm Assembly ASM programming 0 0 Programming Language :: Assembly 160 :: 269
3788 271 2000092001 160 160 csharp C# Microsoft's C++/Java Language 0 0 Programming Language :: C# 160 :: 271
3789 273 2000102001 160 160 Pike Pike Pike, see http://pike.roxen.com/. 0 0 Programming Language :: Pike 160 :: 273
3790 184 2000032001 160 160 asp ASP Active Server Pages 0 0 Programming Language :: ASP 160 :: 184
3791 185 2000032001 160 160 shell Unix Shell Unix Shell 0 0 Programming Language :: Unix Shell 160 :: 185
3792 186 2000032001 160 160 visualbasic Visual Basic Visual Basic 0 0 Programming Language :: Visual Basic 160 :: 186
3793 198 2000032001 160 160 java Java Java 0 0 Programming Language :: Java 160 :: 198
3794 213 2000032101 160 160 other Other Other programming language, specified in description. 0 0 Programming Language :: Other 160 :: 213
3795 242 2000042701 160 160 scheme Scheme Scheme programming language. 0 0 Programming Language :: Scheme 160 :: 242
3796 254 2000071101 160 160 plsql PL/SQL PL/SQL Programming Language 0 0 Programming Language :: PL/SQL 160 :: 254
3797 255 2000071101 160 160 progress PROGRESS PROGRESS Programming Language 0 0 Programming Language :: PROGRESS 160 :: 255
3798 258 2000071101 160 160 objectpascal Object Pascal Object Pascal 0 0 Programming Language :: Object Pascal 160 :: 258
3799 261 2000072501 160 160 xbasic XBasic XBasic programming language 0 0 Programming Language :: XBasic 160 :: 261
3800 262 2000073101 160 160 coldfusion Cold Fusion Cold Fusion Language 0 0 Programming Language :: Cold Fusion 160 :: 262
3801 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
3802 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
3803 187 2000032001 14 13 bsd BSD License BSD License 0 0 License :: OSI Approved :: BSD License 13 :: 14 :: 187
3804 17 2000032001 14 13 artistic Artistic License The Perl Artistic License 0 0 License :: OSI Approved :: Artistic License 13 :: 14 :: 17
3805 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
3806 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
3807 280 2000110101 160 160 JavaScript JavaScript Java Scripting Language 0 0 Programming Language :: JavaScript 160 :: 280
3808 281 2000111401 160 160 REBOL REBOL REBOL Programming Language 0 0 Programming Language :: REBOL 160 :: 281
3809 265 2001032001 160 160 Delphi Delphi/Kylix Borland/Inprise Delphi or other Object-Pascal based languages 0 0 Programming Language :: Delphi/Kylix 160 :: 265
3810 293 2001032001 160 160 ruby Ruby Ruby programming language 0 0 Programming Language :: Ruby 160 :: 293
3811 45 2000031601 18 18 development Software Development Software used to aid software development. 0 0 Topic :: Software Development 18 :: 45
3812 99 2000031601 18 18 multimedia Multimedia Graphics, sound, video, and multimedia. 0 0 Topic :: Multimedia 18 :: 99
3813 296 2001041701 14 13 asl Apache Software License Apache Software License 0 0 License :: OSI Approved :: Apache Software License 13 :: 14 :: 296
3814 274 2000102401 0 0 natlanguage Natural Language The oral/written language for the development and use of this software. 0 0 Natural Language 274
3815 295 2001040601 274 274 russian Russian Projects having something to do with Russian Language 0 0 Natural Language :: Russian 274 :: 295
3816 275 2000102401 274 274 english English English 0 0 Natural Language :: English 274 :: 275
3817 276 2000102401 274 274 french French French 0 0 Natural Language :: French 274 :: 276
3818 277 2000102401 274 274 spanish Spanish Spanish 0 0 Natural Language :: Spanish 274 :: 277
3819 278 2000102601 274 274 japanese Japanese Projects using the Japanese language 0 0 Natural Language :: Japanese 274 :: 278
3820 279 2000102601 274 274 german German Projects using the German language 0 0 Natural Language :: German 274 :: 279
3821 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
3822 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
3823 302 2001041701 14 13 sleepycat Sleepycat License Sleepycat License 0 0 License :: OSI Approved :: Sleepycat License 13 :: 14 :: 302
3826 -- ' <-- This quote to help Emacs not get lost for its syntax-highlighting
3830 -- Data for TOC Entry ID 539 (OID 21825)
3832 -- Name: trove_group_link Type: TABLE DATA Owner: tperdue
3836 COPY "trove_group_link" FROM stdin;
3839 -- Data for TOC Entry ID 540 (OID 21885)
3841 -- Name: user_bookmarks Type: TABLE DATA Owner: tperdue
3845 COPY "user_bookmarks" FROM stdin;
3848 -- Data for TOC Entry ID 541 (OID 21937)
3850 -- Name: user_diary Type: TABLE DATA Owner: tperdue
3854 COPY "user_diary" FROM stdin;
3857 -- Data for TOC Entry ID 542 (OID 21993)
3859 -- Name: user_diary_monitor Type: TABLE DATA Owner: tperdue
3863 COPY "user_diary_monitor" FROM stdin;
3866 -- Data for TOC Entry ID 543 (OID 22030)
3868 -- Name: user_group Type: TABLE DATA Owner: tperdue
3872 COPY "user_group" FROM stdin;
3875 -- Data for TOC Entry ID 544 (OID 22088)
3877 -- Name: user_metric Type: TABLE DATA Owner: tperdue
3881 COPY "user_metric" FROM stdin;
3884 -- Data for TOC Entry ID 545 (OID 22135)
3886 -- Name: user_metric0 Type: TABLE DATA Owner: tperdue
3890 COPY "user_metric0" FROM stdin;
3893 -- Data for TOC Entry ID 546 (OID 22163)
3895 -- Name: user_preferences Type: TABLE DATA Owner: tperdue
3899 COPY "user_preferences" FROM stdin;
3902 -- Data for TOC Entry ID 547 (OID 22194)
3904 -- Name: user_ratings Type: TABLE DATA Owner: tperdue
3908 COPY "user_ratings" FROM stdin;
3911 -- Data for TOC Entry ID 548 (OID 22230)
3913 -- Name: users Type: TABLE DATA Owner: tperdue
3917 COPY "users" FROM stdin;
3918 100 None noreply@gforge.net *********34343 A /bin/bash N 0 shell 0 \N 0 0 \N \N 0 GMT 1 0
3921 -- Data for TOC Entry ID 549 (OID 22336)
3923 -- Name: project_sums_agg Type: TABLE DATA Owner: tperdue
3927 COPY "project_sums_agg" FROM stdin;
3930 -- Data for TOC Entry ID 550 (OID 22388)
3932 -- Name: prdb_dbs Type: TABLE DATA Owner: tperdue
3936 COPY "prdb_dbs" FROM stdin;
3939 -- Data for TOC Entry ID 551 (OID 22425)
3941 -- Name: prdb_states Type: TABLE DATA Owner: tperdue
3945 COPY "prdb_states" FROM stdin;
3948 -- Data for TOC Entry ID 552 (OID 22451)
3950 -- Name: prdb_types Type: TABLE DATA Owner: tperdue
3954 COPY "prdb_types" FROM stdin;
3957 -- Data for TOC Entry ID 553 (OID 22500)
3959 -- Name: prweb_vhost Type: TABLE DATA Owner: tperdue
3963 COPY "prweb_vhost" FROM stdin;
3966 -- Data for TOC Entry ID 554 (OID 22552)
3968 -- Name: artifact_group_list Type: TABLE DATA Owner: tperdue
3972 COPY "artifact_group_list" FROM stdin;
3973 100 1 Default Default Data - Dont Edit 3 0 0 2592000 0 \N \N 0 \N
3976 -- Data for TOC Entry ID 555 (OID 22619)
3978 -- Name: artifact_resolution Type: TABLE DATA Owner: tperdue
3982 COPY "artifact_resolution" FROM stdin;
3997 -- Data for TOC Entry ID 556 (OID 22668)
3999 -- Name: artifact_perm Type: TABLE DATA Owner: tperdue
4003 COPY "artifact_perm" FROM stdin;
4006 -- Data for TOC Entry ID 557 (OID 22737)
4008 -- Name: artifact_category Type: TABLE DATA Owner: tperdue
4012 COPY "artifact_category" FROM stdin;
4016 -- Data for TOC Entry ID 558 (OID 22789)
4018 -- Name: artifact_group Type: TABLE DATA Owner: tperdue
4022 COPY "artifact_group" FROM stdin;
4026 -- Data for TOC Entry ID 559 (OID 22839)
4028 -- Name: artifact_status Type: TABLE DATA Owner: tperdue
4032 COPY "artifact_status" FROM stdin;
4038 -- Data for TOC Entry ID 560 (OID 22888)
4040 -- Name: artifact Type: TABLE DATA Owner: tperdue
4044 COPY "artifact" FROM stdin;
4047 -- Data for TOC Entry ID 561 (OID 22993)
4049 -- Name: artifact_history Type: TABLE DATA Owner: tperdue
4053 COPY "artifact_history" FROM stdin;
4056 -- Data for TOC Entry ID 562 (OID 23067)
4058 -- Name: artifact_file Type: TABLE DATA Owner: tperdue
4062 COPY "artifact_file" FROM stdin;
4065 -- Data for TOC Entry ID 563 (OID 23145)
4067 -- Name: artifact_message Type: TABLE DATA Owner: tperdue
4071 COPY "artifact_message" FROM stdin;
4074 -- Data for TOC Entry ID 564 (OID 23218)
4076 -- Name: artifact_monitor Type: TABLE DATA Owner: tperdue
4080 COPY "artifact_monitor" FROM stdin;
4083 -- Data for TOC Entry ID 565 (OID 23269)
4085 -- Name: artifact_canned_responses Type: TABLE DATA Owner: tperdue
4089 COPY "artifact_canned_responses" FROM stdin;
4092 -- Data for TOC Entry ID 566 (OID 23301)
4094 -- Name: artifact_counts_agg Type: TABLE DATA Owner: tperdue
4098 COPY "artifact_counts_agg" FROM stdin;
4102 -- Data for TOC Entry ID 567 (OID 23313)
4104 -- Name: stats_site_pages_by_day Type: TABLE DATA Owner: tperdue
4108 COPY "stats_site_pages_by_day" FROM stdin;
4111 -- Data for TOC Entry ID 568 (OID 23349)
4113 -- Name: massmail_queue Type: TABLE DATA Owner: tperdue
4117 COPY "massmail_queue" FROM stdin;
4120 -- Data for TOC Entry ID 569 (OID 23388)
4122 -- Name: frs_dlstats_file_agg Type: TABLE DATA Owner: tperdue
4126 COPY "frs_dlstats_file_agg" FROM stdin;
4129 -- Data for TOC Entry ID 570 (OID 23401)
4131 -- Name: stats_agg_site_by_group Type: TABLE DATA Owner: tperdue
4135 COPY "stats_agg_site_by_group" FROM stdin;
4138 -- Data for TOC Entry ID 571 (OID 23414)
4140 -- Name: stats_project_metric Type: TABLE DATA Owner: tperdue
4144 COPY "stats_project_metric" FROM stdin;
4147 -- Data for TOC Entry ID 572 (OID 23433)
4149 -- Name: stats_agg_logo_by_group Type: TABLE DATA Owner: tperdue
4153 COPY "stats_agg_logo_by_group" FROM stdin;
4156 -- Data for TOC Entry ID 573 (OID 23446)
4158 -- Name: stats_subd_pages Type: TABLE DATA Owner: tperdue
4162 COPY "stats_subd_pages" FROM stdin;
4165 -- Data for TOC Entry ID 574 (OID 23463)
4167 -- Name: stats_cvs_user Type: TABLE DATA Owner: tperdue
4171 COPY "stats_cvs_user" FROM stdin;
4174 -- Data for TOC Entry ID 575 (OID 23486)
4176 -- Name: stats_cvs_group Type: TABLE DATA Owner: tperdue
4180 COPY "stats_cvs_group" FROM stdin;
4183 -- Data for TOC Entry ID 576 (OID 23507)
4185 -- Name: stats_project_developers Type: TABLE DATA Owner: tperdue
4189 COPY "stats_project_developers" FROM stdin;
4192 -- Data for TOC Entry ID 577 (OID 23524)
4194 -- Name: stats_project Type: TABLE DATA Owner: tperdue
4198 COPY "stats_project" FROM stdin;
4201 -- Data for TOC Entry ID 578 (OID 23567)
4203 -- Name: stats_site Type: TABLE DATA Owner: tperdue
4207 COPY "stats_site" FROM stdin;
4210 -- Data for TOC Entry ID 579 (OID 23583)
4212 -- Name: activity_log_old_old Type: TABLE DATA Owner: tperdue
4216 COPY "activity_log_old_old" FROM stdin;
4219 -- Data for TOC Entry ID 580 (OID 23624)
4221 -- Name: activity_log_old Type: TABLE DATA Owner: tperdue
4225 COPY "activity_log_old" FROM stdin;
4228 -- Data for TOC Entry ID 581 (OID 23665)
4230 -- Name: activity_log Type: TABLE DATA Owner: tperdue
4234 COPY "activity_log" FROM stdin;
4237 -- Data for TOC Entry ID 582 (OID 23706)
4239 -- Name: cache_store Type: TABLE DATA Owner: tperdue
4244 -- Data for TOC Entry ID 583 (OID 25693)
4246 -- Name: user_metric_history Type: TABLE DATA Owner: tperdue
4250 COPY "user_metric_history" FROM stdin;
4253 -- Data for TOC Entry ID 584 (OID 25710)
4255 -- Name: foundry_project_rankings_agg Type: TABLE DATA Owner: tperdue
4259 COPY "foundry_project_rankings_agg" FROM stdin;
4262 -- Data for TOC Entry ID 585 (OID 25728)
4264 -- Name: foundry_project_downloads_agg Type: TABLE DATA Owner: tperdue
4268 COPY "foundry_project_downloads_agg" FROM stdin;
4271 -- Data for TOC Entry ID 586 (OID 25745)
4273 -- Name: frs_dlstats_filetotal_agg Type: TABLE DATA Owner: tperdue
4277 COPY "frs_dlstats_filetotal_agg" FROM stdin;
4280 -- Data for TOC Entry ID 587 (OID 25759)
4282 -- Name: frs_dlstats_grouptotal_agg Type: TABLE DATA Owner: tperdue
4286 COPY "frs_dlstats_grouptotal_agg" FROM stdin;
4289 -- Data for TOC Entry ID 588 (OID 25773)
4291 -- Name: frs_dlstats_group_agg Type: TABLE DATA Owner: tperdue
4295 COPY "frs_dlstats_group_agg" FROM stdin;
4298 -- Data for TOC Entry ID 589 (OID 25792)
4300 -- Name: stats_project_months Type: TABLE DATA Owner: tperdue
4304 COPY "stats_project_months" FROM stdin;
4307 -- Data for TOC Entry ID 590 (OID 25834)
4309 -- Name: stats_project_all Type: TABLE DATA Owner: tperdue
4313 COPY "stats_project_all" FROM stdin;
4316 -- Data for TOC Entry ID 591 (OID 25871)
4318 -- Name: stats_project_developers_last30 Type: TABLE DATA Owner: tperdue
4322 COPY "stats_project_developers_last30" FROM stdin;
4325 -- Data for TOC Entry ID 592 (OID 25884)
4327 -- Name: stats_project_last_30 Type: TABLE DATA Owner: tperdue
4331 COPY "stats_project_last_30" FROM stdin;
4334 -- Data for TOC Entry ID 593 (OID 25924)
4336 -- Name: stats_site_pages_by_month Type: TABLE DATA Owner: tperdue
4340 COPY "stats_site_pages_by_month" FROM stdin;
4343 -- Data for TOC Entry ID 594 (OID 25935)
4345 -- Name: stats_site_last_30 Type: TABLE DATA Owner: tperdue
4349 COPY "stats_site_last_30" FROM stdin;
4352 -- Data for TOC Entry ID 595 (OID 25967)
4354 -- Name: stats_site_months Type: TABLE DATA Owner: tperdue
4358 COPY "stats_site_months" FROM stdin;
4361 -- Data for TOC Entry ID 596 (OID 25998)
4363 -- Name: stats_site_all Type: TABLE DATA Owner: tperdue
4367 COPY "stats_site_all" FROM stdin;
4368 \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N \N
4371 -- Data for TOC Entry ID 597 (OID 26026)
4373 -- Name: trove_agg Type: TABLE DATA Owner: tperdue
4377 COPY "trove_agg" FROM stdin;
4380 -- Data for TOC Entry ID 598 (OID 26069)
4382 -- Name: trove_treesums Type: TABLE DATA Owner: tperdue
4386 COPY "trove_treesums" FROM stdin;
4389 -- TOC Entry ID 307 (OID 18793)
4391 -- Name: "db_images_group" Type: INDEX Owner: tperdue
4394 CREATE INDEX "db_images_group" on "db_images" using btree ( "group_id" "int4_ops" );
4397 -- TOC Entry ID 308 (OID 18859)
4399 -- Name: "doc_group_doc_group" Type: INDEX Owner: tperdue
4402 CREATE INDEX "doc_group_doc_group" on "doc_data" using btree ( "doc_group" "int4_ops" );
4405 -- TOC Entry ID 309 (OID 18924)
4407 -- Name: "doc_groups_group" Type: INDEX Owner: tperdue
4410 CREATE INDEX "doc_groups_group" on "doc_groups" using btree ( "group_id" "int4_ops" );
4413 -- TOC Entry ID 310 (OID 18996)
4415 -- Name: "filemodule_monitor_id" Type: INDEX Owner: tperdue
4418 CREATE INDEX "filemodule_monitor_id" on "filemodule_monitor" using btree ( "filemodule_id" "int4_ops" );
4421 -- TOC Entry ID 311 (OID 18996)
4423 -- Name: "filemodulemonitor_userid" Type: INDEX Owner: tperdue
4426 CREATE INDEX "filemodulemonitor_userid" on "filemodule_monitor" using btree ( "user_id" "int4_ops" );
4429 -- TOC Entry ID 312 (OID 19033)
4431 -- Name: "forum_forumid_msgid" Type: INDEX Owner: tperdue
4434 CREATE INDEX "forum_forumid_msgid" on "forum" using btree ( "group_forum_id" "int4_ops", "msg_id" "int4_ops" );
4437 -- TOC Entry ID 313 (OID 19033)
4439 -- Name: "forum_group_forum_id" Type: INDEX Owner: tperdue
4442 CREATE INDEX "forum_group_forum_id" on "forum" using btree ( "group_forum_id" "int4_ops" );
4445 -- TOC Entry ID 314 (OID 19033)
4447 -- Name: "forum_forumid_isfollowupto" Type: INDEX Owner: tperdue
4450 CREATE INDEX "forum_forumid_isfollowupto" on "forum" using btree ( "group_forum_id" "int4_ops", "is_followup_to" "int4_ops" );
4453 -- TOC Entry ID 315 (OID 19033)
4455 -- Name: "forum_forumid_threadid_mostrece" Type: INDEX Owner: tperdue
4458 CREATE INDEX "forum_forumid_threadid_mostrece" on "forum" using btree ( "group_forum_id" "int4_ops", "thread_id" "int4_ops", "most_recent_date" "int4_ops" );
4461 -- TOC Entry ID 316 (OID 19033)
4463 -- Name: "forum_threadid_isfollowupto" Type: INDEX Owner: tperdue
4466 CREATE INDEX "forum_threadid_isfollowupto" on "forum" using btree ( "thread_id" "int4_ops", "is_followup_to" "int4_ops" );
4469 -- TOC Entry ID 317 (OID 19033)
4471 -- Name: "forum_forumid_isfollto_mostrece" Type: INDEX Owner: tperdue
4474 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" );
4477 -- TOC Entry ID 318 (OID 19115)
4479 -- Name: "forum_group_list_group_id" Type: INDEX Owner: tperdue
4482 CREATE INDEX "forum_group_list_group_id" on "forum_group_list" using btree ( "group_id" "int4_ops" );
4485 -- TOC Entry ID 319 (OID 19173)
4487 -- Name: "forummonitoredforums_user" Type: INDEX Owner: tperdue
4490 CREATE INDEX "forummonitoredforums_user" on "forum_monitored_forums" using btree ( "user_id" "int4_ops" );
4493 -- TOC Entry ID 320 (OID 19173)
4495 -- Name: "forum_monitor_combo_id" Type: INDEX Owner: tperdue
4498 CREATE INDEX "forum_monitor_combo_id" on "forum_monitored_forums" using btree ( "forum_id" "int4_ops", "user_id" "int4_ops" );
4501 -- TOC Entry ID 321 (OID 19173)
4503 -- Name: "forum_monitor_thread_id" Type: INDEX Owner: tperdue
4506 CREATE INDEX "forum_monitor_thread_id" on "forum_monitored_forums" using btree ( "forum_id" "int4_ops" );
4509 -- TOC Entry ID 322 (OID 19287)
4511 -- Name: "foundry_news_foundry_approved_d" Type: INDEX Owner: tperdue
4514 CREATE INDEX "foundry_news_foundry_approved_d" on "foundry_news" using btree ( "foundry_id" "int4_ops", "is_approved" "int4_ops", "approve_date" "int4_ops" );
4517 -- TOC Entry ID 323 (OID 19287)
4519 -- Name: "foundry_news_foundry_approved" Type: INDEX Owner: tperdue
4522 CREATE INDEX "foundry_news_foundry_approved" on "foundry_news" using btree ( "foundry_id" "int4_ops", "is_approved" "int4_ops" );
4525 -- TOC Entry ID 324 (OID 19287)
4527 -- Name: "foundry_news_foundry" Type: INDEX Owner: tperdue
4530 CREATE INDEX "foundry_news_foundry" on "foundry_news" using btree ( "foundry_id" "int4_ops" );
4533 -- TOC Entry ID 325 (OID 19287)
4535 -- Name: "foundrynews_foundry_date_approv" Type: INDEX Owner: tperdue
4538 CREATE INDEX "foundrynews_foundry_date_approv" on "foundry_news" using btree ( "foundry_id" "int4_ops", "approve_date" "int4_ops", "is_approved" "int4_ops" );
4541 -- TOC Entry ID 326 (OID 19328)
4543 -- Name: "foundry_project_group_rank" Type: INDEX Owner: tperdue
4546 CREATE INDEX "foundry_project_group_rank" on "foundry_preferred_projects" using btree ( "group_id" "int4_ops", "rank" "int4_ops" );
4549 -- TOC Entry ID 327 (OID 19328)
4551 -- Name: "foundry_project_group" Type: INDEX Owner: tperdue
4554 CREATE INDEX "foundry_project_group" on "foundry_preferred_projects" using btree ( "group_id" "int4_ops" );
4557 -- TOC Entry ID 328 (OID 19367)
4559 -- Name: "foundry_projects_foundry" Type: INDEX Owner: tperdue
4562 CREATE INDEX "foundry_projects_foundry" on "foundry_projects" using btree ( "foundry_id" "int4_ops" );
4565 -- TOC Entry ID 329 (OID 19404)
4567 -- Name: "frs_file_date" Type: INDEX Owner: tperdue
4570 CREATE INDEX "frs_file_date" on "frs_file" using btree ( "post_date" "int4_ops" );
4573 -- TOC Entry ID 330 (OID 19404)
4575 -- Name: "frs_file_release_id" Type: INDEX Owner: tperdue
4578 CREATE INDEX "frs_file_release_id" on "frs_file" using btree ( "release_id" "int4_ops" );
4581 -- TOC Entry ID 331 (OID 19514)
4583 -- Name: "package_group_id" Type: INDEX Owner: tperdue
4586 CREATE INDEX "package_group_id" on "frs_package" using btree ( "group_id" "int4_ops" );
4589 -- TOC Entry ID 332 (OID 19616)
4591 -- Name: "frs_release_package" Type: INDEX Owner: tperdue
4594 CREATE INDEX "frs_release_package" on "frs_release" using btree ( "package_id" "int4_ops" );
4597 -- TOC Entry ID 333 (OID 19745)
4599 -- Name: "group_history_group_id" Type: INDEX Owner: tperdue
4602 CREATE INDEX "group_history_group_id" on "group_history" using btree ( "group_id" "int4_ops" );
4605 -- TOC Entry ID 334 (OID 19851)
4607 -- Name: "group_unix_uniq" Type: INDEX Owner: tperdue
4610 CREATE UNIQUE INDEX "group_unix_uniq" on "groups" using btree ( "unix_group_name" "varchar_ops" );
4613 -- TOC Entry ID 335 (OID 19851)
4615 -- Name: "groups_type" Type: INDEX Owner: tperdue
4618 CREATE INDEX "groups_type" on "groups" using btree ( "type" "int4_ops" );
4621 -- TOC Entry ID 336 (OID 19851)
4623 -- Name: "groups_public" Type: INDEX Owner: tperdue
4626 CREATE INDEX "groups_public" on "groups" using btree ( "is_public" "int4_ops" );
4629 -- TOC Entry ID 337 (OID 19851)
4631 -- Name: "groups_status" Type: INDEX Owner: tperdue
4634 CREATE INDEX "groups_status" on "groups" using btree ( "status" "bpchar_ops" );
4637 -- TOC Entry ID 338 (OID 19996)
4639 -- Name: "mail_group_list_group" Type: INDEX Owner: tperdue
4642 CREATE INDEX "mail_group_list_group" on "mail_group_list" using btree ( "group_id" "int4_ops" );
4645 -- TOC Entry ID 339 (OID 20055)
4647 -- Name: "news_bytes_group" Type: INDEX Owner: tperdue
4650 CREATE INDEX "news_bytes_group" on "news_bytes" using btree ( "group_id" "int4_ops" );
4653 -- TOC Entry ID 340 (OID 20055)
4655 -- Name: "news_bytes_approved" Type: INDEX Owner: tperdue
4658 CREATE INDEX "news_bytes_approved" on "news_bytes" using btree ( "is_approved" "int4_ops" );
4661 -- TOC Entry ID 341 (OID 20055)
4663 -- Name: "news_bytes_forum" Type: INDEX Owner: tperdue
4666 CREATE INDEX "news_bytes_forum" on "news_bytes" using btree ( "forum_id" "int4_ops" );
4669 -- TOC Entry ID 342 (OID 20055)
4671 -- Name: "news_group_date" Type: INDEX Owner: tperdue
4674 CREATE INDEX "news_group_date" on "news_bytes" using btree ( "group_id" "int4_ops", "date" "int4_ops" );
4677 -- TOC Entry ID 343 (OID 20055)
4679 -- Name: "news_approved_date" Type: INDEX Owner: tperdue
4682 CREATE INDEX "news_approved_date" on "news_bytes" using btree ( "is_approved" "int4_ops", "date" "int4_ops" );
4685 -- TOC Entry ID 344 (OID 20115)
4687 -- Name: "people_job_group_id" Type: INDEX Owner: tperdue
4690 CREATE INDEX "people_job_group_id" on "people_job" using btree ( "group_id" "int4_ops" );
4693 -- TOC Entry ID 345 (OID 20504)
4695 -- Name: "project_assigned_to_assigned_to" Type: INDEX Owner: tperdue
4698 CREATE INDEX "project_assigned_to_assigned_to" on "project_assigned_to" using btree ( "assigned_to_id" "int4_ops" );
4701 -- TOC Entry ID 346 (OID 20504)
4703 -- Name: "project_assigned_to_task_id" Type: INDEX Owner: tperdue
4706 CREATE INDEX "project_assigned_to_task_id" on "project_assigned_to" using btree ( "project_task_id" "int4_ops" );
4709 -- TOC Entry ID 347 (OID 20541)
4711 -- Name: "project_is_dependent_on_task_id" Type: INDEX Owner: tperdue
4714 CREATE INDEX "project_is_dependent_on_task_id" on "project_dependencies" using btree ( "is_dependent_on_task_id" "int4_ops" );
4717 -- TOC Entry ID 348 (OID 20541)
4719 -- Name: "project_dependencies_task_id" Type: INDEX Owner: tperdue
4722 CREATE INDEX "project_dependencies_task_id" on "project_dependencies" using btree ( "project_task_id" "int4_ops" );
4725 -- TOC Entry ID 349 (OID 20578)
4727 -- Name: "project_group_list_group_id" Type: INDEX Owner: tperdue
4730 CREATE INDEX "project_group_list_group_id" on "project_group_list" using btree ( "group_id" "int4_ops" );
4733 -- TOC Entry ID 350 (OID 20633)
4735 -- Name: "project_history_task_id" Type: INDEX Owner: tperdue
4738 CREATE INDEX "project_history_task_id" on "project_history" using btree ( "project_task_id" "int4_ops" );
4741 -- TOC Entry ID 351 (OID 20691)
4743 -- Name: "project_metric_group" Type: INDEX Owner: tperdue
4746 CREATE INDEX "project_metric_group" on "project_metric" using btree ( "group_id" "int4_ops" );
4749 -- TOC Entry ID 352 (OID 20832)
4751 -- Name: "projecttask_projid_status" Type: INDEX Owner: tperdue
4754 CREATE INDEX "projecttask_projid_status" on "project_task" using btree ( "group_project_id" "int4_ops", "status_id" "int4_ops" );
4757 -- TOC Entry ID 353 (OID 20832)
4759 -- Name: "project_task_group_project_id" Type: INDEX Owner: tperdue
4762 CREATE INDEX "project_task_group_project_id" on "project_task" using btree ( "group_project_id" "int4_ops" );
4765 -- TOC Entry ID 354 (OID 20900)
4767 -- Name: "projectweeklymetric_ranking" Type: INDEX Owner: tperdue
4770 CREATE INDEX "projectweeklymetric_ranking" on "project_weekly_metric" using btree ( "ranking" "int4_ops" );
4773 -- TOC Entry ID 355 (OID 20900)
4775 -- Name: "project_metric_weekly_group" Type: INDEX Owner: tperdue
4778 CREATE INDEX "project_metric_weekly_group" on "project_weekly_metric" using btree ( "group_id" "int4_ops" );
4781 -- TOC Entry ID 356 (OID 20914)
4783 -- Name: "session_user_id" Type: INDEX Owner: tperdue
4786 CREATE INDEX "session_user_id" on "session" using btree ( "user_id" "int4_ops" );
4789 -- TOC Entry ID 357 (OID 20914)
4791 -- Name: "session_time" Type: INDEX Owner: tperdue
4794 CREATE INDEX "session_time" on "session" using btree ( "time" "int4_ops" );
4797 -- TOC Entry ID 358 (OID 20953)
4799 -- Name: "snippet_language" Type: INDEX Owner: tperdue
4802 CREATE INDEX "snippet_language" on "snippet" using btree ( "language" "int4_ops" );
4805 -- TOC Entry ID 359 (OID 20953)
4807 -- Name: "snippet_category" Type: INDEX Owner: tperdue
4810 CREATE INDEX "snippet_category" on "snippet" using btree ( "category" "int4_ops" );
4813 -- TOC Entry ID 360 (OID 21013)
4815 -- Name: "snippet_package_language" Type: INDEX Owner: tperdue
4818 CREATE INDEX "snippet_package_language" on "snippet_package" using btree ( "language" "int4_ops" );
4821 -- TOC Entry ID 361 (OID 21013)
4823 -- Name: "snippet_package_category" Type: INDEX Owner: tperdue
4826 CREATE INDEX "snippet_package_category" on "snippet_package" using btree ( "category" "int4_ops" );
4829 -- TOC Entry ID 362 (OID 21069)
4831 -- Name: "snippet_package_item_pkg_ver" Type: INDEX Owner: tperdue
4834 CREATE INDEX "snippet_package_item_pkg_ver" on "snippet_package_item" using btree ( "snippet_package_version_id" "int4_ops" );
4837 -- TOC Entry ID 363 (OID 21106)
4839 -- Name: "snippet_package_version_pkg_id" Type: INDEX Owner: tperdue
4842 CREATE INDEX "snippet_package_version_pkg_id" on "snippet_package_version" using btree ( "snippet_package_id" "int4_ops" );
4845 -- TOC Entry ID 364 (OID 21162)
4847 -- Name: "snippet_version_snippet_id" Type: INDEX Owner: tperdue
4850 CREATE INDEX "snippet_version_snippet_id" on "snippet_version" using btree ( "snippet_id" "int4_ops" );
4853 -- TOC Entry ID 365 (OID 21211)
4855 -- Name: "pages_by_day_day" Type: INDEX Owner: tperdue
4858 CREATE INDEX "pages_by_day_day" on "stats_agg_pages_by_day" using btree ( "day" "int4_ops" );
4861 -- TOC Entry ID 366 (OID 21224)
4863 -- Name: "statsftpdl_day_fileid" Type: INDEX Owner: tperdue
4866 CREATE INDEX "statsftpdl_day_fileid" on "stats_ftp_downloads" using btree ( "day" "int4_ops", "filerelease_id" "int4_ops" );
4869 -- TOC Entry ID 367 (OID 21241)
4871 -- Name: "statshttpdl_day_fileid" Type: INDEX Owner: tperdue
4874 CREATE INDEX "statshttpdl_day_fileid" on "stats_http_downloads" using btree ( "day" "int4_ops", "filerelease_id" "int4_ops" );
4877 -- TOC Entry ID 368 (OID 21277)
4879 -- Name: "supported_languages_code" Type: INDEX Owner: tperdue
4882 CREATE INDEX "supported_languages_code" on "supported_languages" using btree ( "language_code" "bpchar_ops" );
4885 -- TOC Entry ID 369 (OID 21379)
4887 -- Name: "survey_questions_group" Type: INDEX Owner: tperdue
4890 CREATE INDEX "survey_questions_group" on "survey_questions" using btree ( "group_id" "int4_ops" );
4893 -- TOC Entry ID 370 (OID 21414)
4895 -- Name: "survey_rating_aggregate_type_id" Type: INDEX Owner: tperdue
4898 CREATE INDEX "survey_rating_aggregate_type_id" on "survey_rating_aggregate" using btree ( "type" "int4_ops", "id" "int4_ops" );
4901 -- TOC Entry ID 371 (OID 21431)
4903 -- Name: "survey_rating_responses_user_ty" Type: INDEX Owner: tperdue
4906 CREATE INDEX "survey_rating_responses_user_ty" on "survey_rating_response" using btree ( "user_id" "int4_ops", "type" "int4_ops", "id" "int4_ops" );
4909 -- TOC Entry ID 372 (OID 21431)
4911 -- Name: "survey_rating_responses_type_id" Type: INDEX Owner: tperdue
4914 CREATE INDEX "survey_rating_responses_type_id" on "survey_rating_response" using btree ( "type" "int4_ops", "id" "int4_ops" );
4917 -- TOC Entry ID 373 (OID 21450)
4919 -- Name: "survey_responses_group_id" Type: INDEX Owner: tperdue
4922 CREATE INDEX "survey_responses_group_id" on "survey_responses" using btree ( "group_id" "int4_ops" );
4925 -- TOC Entry ID 374 (OID 21450)
4927 -- Name: "survey_responses_user_survey_qu" Type: INDEX Owner: tperdue
4930 CREATE INDEX "survey_responses_user_survey_qu" on "survey_responses" using btree ( "user_id" "int4_ops", "survey_id" "int4_ops", "question_id" "int4_ops" );
4933 -- TOC Entry ID 375 (OID 21450)
4935 -- Name: "survey_responses_user_survey" Type: INDEX Owner: tperdue
4938 CREATE INDEX "survey_responses_user_survey" on "survey_responses" using btree ( "user_id" "int4_ops", "survey_id" "int4_ops" );
4941 -- TOC Entry ID 376 (OID 21450)
4943 -- Name: "survey_responses_survey_questio" Type: INDEX Owner: tperdue
4946 CREATE INDEX "survey_responses_survey_questio" on "survey_responses" using btree ( "survey_id" "int4_ops", "question_id" "int4_ops" );
4949 -- TOC Entry ID 377 (OID 21505)
4951 -- Name: "surveys_group" Type: INDEX Owner: tperdue
4954 CREATE INDEX "surveys_group" on "surveys" using btree ( "group_id" "int4_ops" );
4957 -- TOC Entry ID 378 (OID 21700)
4959 -- Name: "rank_forumposts_week_idx" Type: INDEX Owner: tperdue
4962 CREATE INDEX "rank_forumposts_week_idx" on "top_group" using btree ( "rank_forumposts_week" "int4_ops" );
4965 -- TOC Entry ID 379 (OID 21700)
4967 -- Name: "rank_downloads_week_idx" Type: INDEX Owner: tperdue
4970 CREATE INDEX "rank_downloads_week_idx" on "top_group" using btree ( "rank_downloads_week" "int4_ops" );
4973 -- TOC Entry ID 380 (OID 21700)
4975 -- Name: "pageviews_proj_idx" Type: INDEX Owner: tperdue
4978 CREATE INDEX "pageviews_proj_idx" on "top_group" using btree ( "pageviews_proj" "int4_ops" );
4981 -- TOC Entry ID 381 (OID 21700)
4983 -- Name: "rank_userrank_idx" Type: INDEX Owner: tperdue
4986 CREATE INDEX "rank_userrank_idx" on "top_group" using btree ( "rank_userrank" "int4_ops" );
4989 -- TOC Entry ID 382 (OID 21700)
4991 -- Name: "rank_downloads_all_idx" Type: INDEX Owner: tperdue
4994 CREATE INDEX "rank_downloads_all_idx" on "top_group" using btree ( "rank_downloads_all" "int4_ops" );
4997 -- TOC Entry ID 383 (OID 21761)
4999 -- Name: "parent_idx" Type: INDEX Owner: tperdue
5002 CREATE INDEX "parent_idx" on "trove_cat" using btree ( "parent" "int4_ops" );
5005 -- TOC Entry ID 384 (OID 21761)
5007 -- Name: "root_parent_idx" Type: INDEX Owner: tperdue
5010 CREATE INDEX "root_parent_idx" on "trove_cat" using btree ( "root_parent" "int4_ops" );
5013 -- TOC Entry ID 385 (OID 21761)
5015 -- Name: "version_idx" Type: INDEX Owner: tperdue
5018 CREATE INDEX "version_idx" on "trove_cat" using btree ( "version" "int4_ops" );
5021 -- TOC Entry ID 386 (OID 21825)
5023 -- Name: "trove_group_link_group_id" Type: INDEX Owner: tperdue
5026 CREATE INDEX "trove_group_link_group_id" on "trove_group_link" using btree ( "group_id" "int4_ops" );
5029 -- TOC Entry ID 387 (OID 21825)
5031 -- Name: "trove_group_link_cat_id" Type: INDEX Owner: tperdue
5034 CREATE INDEX "trove_group_link_cat_id" on "trove_group_link" using btree ( "trove_cat_id" "int4_ops" );
5037 -- TOC Entry ID 388 (OID 21885)
5039 -- Name: "user_bookmark_user_id" Type: INDEX Owner: tperdue
5042 CREATE INDEX "user_bookmark_user_id" on "user_bookmarks" using btree ( "user_id" "int4_ops" );
5045 -- TOC Entry ID 389 (OID 21937)
5047 -- Name: "user_diary_user" Type: INDEX Owner: tperdue
5050 CREATE INDEX "user_diary_user" on "user_diary" using btree ( "user_id" "int4_ops" );
5053 -- TOC Entry ID 390 (OID 21937)
5055 -- Name: "user_diary_user_date" Type: INDEX Owner: tperdue
5058 CREATE INDEX "user_diary_user_date" on "user_diary" using btree ( "user_id" "int4_ops", "date_posted" "int4_ops" );
5061 -- TOC Entry ID 391 (OID 21937)
5063 -- Name: "user_diary_date" Type: INDEX Owner: tperdue
5066 CREATE INDEX "user_diary_date" on "user_diary" using btree ( "date_posted" "int4_ops" );
5069 -- TOC Entry ID 392 (OID 21993)
5071 -- Name: "user_diary_monitor_user" Type: INDEX Owner: tperdue
5074 CREATE INDEX "user_diary_monitor_user" on "user_diary_monitor" using btree ( "user_id" "int4_ops" );
5077 -- TOC Entry ID 393 (OID 21993)
5079 -- Name: "user_diary_monitor_monitored_us" Type: INDEX Owner: tperdue
5082 CREATE INDEX "user_diary_monitor_monitored_us" on "user_diary_monitor" using btree ( "monitored_user" "int4_ops" );
5085 -- TOC Entry ID 394 (OID 22030)
5087 -- Name: "user_group_group_id" Type: INDEX Owner: tperdue
5090 CREATE INDEX "user_group_group_id" on "user_group" using btree ( "group_id" "int4_ops" );
5093 -- TOC Entry ID 395 (OID 22030)
5095 -- Name: "bug_flags_idx" Type: INDEX Owner: tperdue
5098 CREATE INDEX "bug_flags_idx" on "user_group" using btree ( "bug_flags" "int4_ops" );
5101 -- TOC Entry ID 396 (OID 22030)
5103 -- Name: "project_flags_idx" Type: INDEX Owner: tperdue
5106 CREATE INDEX "project_flags_idx" on "user_group" using btree ( "project_flags" "int4_ops" );
5109 -- TOC Entry ID 397 (OID 22030)
5111 -- Name: "user_group_user_id" Type: INDEX Owner: tperdue
5114 CREATE INDEX "user_group_user_id" on "user_group" using btree ( "user_id" "int4_ops" );
5117 -- TOC Entry ID 398 (OID 22030)
5119 -- Name: "admin_flags_idx" Type: INDEX Owner: tperdue
5122 CREATE INDEX "admin_flags_idx" on "user_group" using btree ( "admin_flags" "bpchar_ops" );
5125 -- TOC Entry ID 399 (OID 22030)
5127 -- Name: "forum_flags_idx" Type: INDEX Owner: tperdue
5130 CREATE INDEX "forum_flags_idx" on "user_group" using btree ( "forum_flags" "int4_ops" );
5133 -- TOC Entry ID 400 (OID 22030)
5135 -- Name: "usergroup_uniq_groupid_userid" Type: INDEX Owner: tperdue
5138 CREATE UNIQUE INDEX "usergroup_uniq_groupid_userid" on "user_group" using btree ( "group_id" "int4_ops", "user_id" "int4_ops" );
5141 -- TOC Entry ID 401 (OID 22135)
5143 -- Name: "user_metric0_user_id" Type: INDEX Owner: tperdue
5146 CREATE INDEX "user_metric0_user_id" on "user_metric0" using btree ( "user_id" "int4_ops" );
5149 -- TOC Entry ID 402 (OID 22163)
5151 -- Name: "user_pref_user_id" Type: INDEX Owner: tperdue
5154 CREATE INDEX "user_pref_user_id" on "user_preferences" using btree ( "user_id" "int4_ops" );
5157 -- TOC Entry ID 403 (OID 22194)
5159 -- Name: "user_ratings_rated_by" Type: INDEX Owner: tperdue
5162 CREATE INDEX "user_ratings_rated_by" on "user_ratings" using btree ( "rated_by" "int4_ops" );
5165 -- TOC Entry ID 404 (OID 22194)
5167 -- Name: "user_ratings_user_id" Type: INDEX Owner: tperdue
5170 CREATE INDEX "user_ratings_user_id" on "user_ratings" using btree ( "user_id" "int4_ops" );
5173 -- TOC Entry ID 405 (OID 22230)
5175 -- Name: "users_namename_uniq" Type: INDEX Owner: tperdue
5178 CREATE UNIQUE INDEX "users_namename_uniq" on "users" using btree ( "user_name" "text_ops" );
5181 -- TOC Entry ID 406 (OID 22230)
5183 -- Name: "users_status" Type: INDEX Owner: tperdue
5186 CREATE INDEX "users_status" on "users" using btree ( "status" "bpchar_ops" );
5189 -- TOC Entry ID 407 (OID 22230)
5191 -- Name: "users_user_pw" Type: INDEX Owner: tperdue
5194 CREATE INDEX "users_user_pw" on "users" using btree ( "user_pw" "varchar_ops" );
5197 -- TOC Entry ID 408 (OID 22336)
5199 -- Name: "projectsumsagg_groupid" Type: INDEX Owner: tperdue
5202 CREATE INDEX "projectsumsagg_groupid" on "project_sums_agg" using btree ( "group_id" "int4_ops" );
5205 -- TOC Entry ID 409 (OID 22388)
5207 -- Name: "idx_prdb_dbname" Type: INDEX Owner: tperdue
5210 CREATE UNIQUE INDEX "idx_prdb_dbname" on "prdb_dbs" using btree ( "dbname" "text_ops" );
5213 -- TOC Entry ID 410 (OID 22500)
5215 -- Name: "idx_vhost_groups" Type: INDEX Owner: tperdue
5218 CREATE INDEX "idx_vhost_groups" on "prweb_vhost" using btree ( "group_id" "int4_ops" );
5221 -- TOC Entry ID 411 (OID 22500)
5223 -- Name: "idx_vhost_hostnames" Type: INDEX Owner: tperdue
5226 CREATE UNIQUE INDEX "idx_vhost_hostnames" on "prweb_vhost" using btree ( "vhost_name" "text_ops" );
5229 -- TOC Entry ID 412 (OID 22552)
5231 -- Name: "artgrouplist_groupid" Type: INDEX Owner: tperdue
5234 CREATE INDEX "artgrouplist_groupid" on "artifact_group_list" using btree ( "group_id" "int4_ops" );
5237 -- TOC Entry ID 413 (OID 22552)
5239 -- Name: "artgrouplist_groupid_public" Type: INDEX Owner: tperdue
5242 CREATE INDEX "artgrouplist_groupid_public" on "artifact_group_list" using btree ( "group_id" "int4_ops", "is_public" "int4_ops" );
5245 -- TOC Entry ID 414 (OID 22668)
5247 -- Name: "artperm_groupartifactid_userid" Type: INDEX Owner: tperdue
5250 CREATE UNIQUE INDEX "artperm_groupartifactid_userid" on "artifact_perm" using btree ( "group_artifact_id" "int4_ops", "user_id" "int4_ops" );
5253 -- TOC Entry ID 415 (OID 22668)
5255 -- Name: "artperm_groupartifactid" Type: INDEX Owner: tperdue
5258 CREATE INDEX "artperm_groupartifactid" on "artifact_perm" using btree ( "group_artifact_id" "int4_ops" );
5261 -- TOC Entry ID 416 (OID 22737)
5263 -- Name: "artcategory_groupartifactid" Type: INDEX Owner: tperdue
5266 CREATE INDEX "artcategory_groupartifactid" on "artifact_category" using btree ( "group_artifact_id" "int4_ops" );
5269 -- TOC Entry ID 417 (OID 22789)
5271 -- Name: "artgroup_groupartifactid" Type: INDEX Owner: tperdue
5274 CREATE INDEX "artgroup_groupartifactid" on "artifact_group" using btree ( "group_artifact_id" "int4_ops" );
5277 -- TOC Entry ID 418 (OID 22888)
5279 -- Name: "art_groupartid" Type: INDEX Owner: tperdue
5282 CREATE INDEX "art_groupartid" on "artifact" using btree ( "group_artifact_id" "int4_ops" );
5285 -- TOC Entry ID 419 (OID 22888)
5287 -- Name: "art_groupartid_statusid" Type: INDEX Owner: tperdue
5290 CREATE INDEX "art_groupartid_statusid" on "artifact" using btree ( "group_artifact_id" "int4_ops", "status_id" "int4_ops" );
5293 -- TOC Entry ID 420 (OID 22888)
5295 -- Name: "art_groupartid_assign" Type: INDEX Owner: tperdue
5298 CREATE INDEX "art_groupartid_assign" on "artifact" using btree ( "group_artifact_id" "int4_ops", "assigned_to" "int4_ops" );
5301 -- TOC Entry ID 421 (OID 22888)
5303 -- Name: "art_groupartid_submit" Type: INDEX Owner: tperdue
5306 CREATE INDEX "art_groupartid_submit" on "artifact" using btree ( "group_artifact_id" "int4_ops", "submitted_by" "int4_ops" );
5309 -- TOC Entry ID 422 (OID 22888)
5311 -- Name: "art_submit_status" Type: INDEX Owner: tperdue
5314 CREATE INDEX "art_submit_status" on "artifact" using btree ( "submitted_by" "int4_ops", "status_id" "int4_ops" );
5317 -- TOC Entry ID 423 (OID 22888)
5319 -- Name: "art_assign_status" Type: INDEX Owner: tperdue
5322 CREATE INDEX "art_assign_status" on "artifact" using btree ( "assigned_to" "int4_ops", "status_id" "int4_ops" );
5325 -- TOC Entry ID 424 (OID 22888)
5327 -- Name: "art_groupartid_artifactid" Type: INDEX Owner: tperdue
5330 CREATE INDEX "art_groupartid_artifactid" on "artifact" using btree ( "group_artifact_id" "int4_ops", "artifact_id" "int4_ops" );
5333 -- TOC Entry ID 425 (OID 22993)
5335 -- Name: "arthistory_artid" Type: INDEX Owner: tperdue
5338 CREATE INDEX "arthistory_artid" on "artifact_history" using btree ( "artifact_id" "int4_ops" );
5341 -- TOC Entry ID 426 (OID 22993)
5343 -- Name: "arthistory_artid_entrydate" Type: INDEX Owner: tperdue
5346 CREATE INDEX "arthistory_artid_entrydate" on "artifact_history" using btree ( "artifact_id" "int4_ops", "entrydate" "int4_ops" );
5349 -- TOC Entry ID 427 (OID 23067)
5351 -- Name: "artfile_artid" Type: INDEX Owner: tperdue
5354 CREATE INDEX "artfile_artid" on "artifact_file" using btree ( "artifact_id" "int4_ops" );
5357 -- TOC Entry ID 428 (OID 23067)
5359 -- Name: "artfile_artid_adddate" Type: INDEX Owner: tperdue
5362 CREATE INDEX "artfile_artid_adddate" on "artifact_file" using btree ( "artifact_id" "int4_ops", "adddate" "int4_ops" );
5365 -- TOC Entry ID 429 (OID 23145)
5367 -- Name: "artmessage_artid" Type: INDEX Owner: tperdue
5370 CREATE INDEX "artmessage_artid" on "artifact_message" using btree ( "artifact_id" "int4_ops" );
5373 -- TOC Entry ID 430 (OID 23145)
5375 -- Name: "artmessage_artid_adddate" Type: INDEX Owner: tperdue
5378 CREATE INDEX "artmessage_artid_adddate" on "artifact_message" using btree ( "artifact_id" "int4_ops", "adddate" "int4_ops" );
5381 -- TOC Entry ID 431 (OID 23218)
5383 -- Name: "artmonitor_artifactid" Type: INDEX Owner: tperdue
5386 CREATE INDEX "artmonitor_artifactid" on "artifact_monitor" using btree ( "artifact_id" "int4_ops" );
5389 -- TOC Entry ID 432 (OID 23269)
5391 -- Name: "artifactcannedresponses_groupid" Type: INDEX Owner: tperdue
5394 CREATE INDEX "artifactcannedresponses_groupid" on "artifact_canned_responses" using btree ( "group_artifact_id" "int4_ops" );
5397 -- TOC Entry ID 433 (OID 23301)
5399 -- Name: "artifactcountsagg_groupartid" Type: INDEX Owner: tperdue
5402 CREATE INDEX "artifactcountsagg_groupartid" on "artifact_counts_agg" using btree ( "group_artifact_id" "int4_ops" );
5405 -- TOC Entry ID 434 (OID 23313)
5407 -- Name: "statssitepgsbyday_oid" Type: INDEX Owner: tperdue
5410 CREATE UNIQUE INDEX "statssitepgsbyday_oid" on stats_site_pages_by_day(month,day) ;
5411 -- using btree ( "oid" "oid_ops" );
5414 -- TOC Entry ID 435 (OID 23313)
5416 -- Name: "statssitepagesbyday_month_day" Type: INDEX Owner: tperdue
5419 CREATE INDEX "statssitepagesbyday_month_day" on "stats_site_pages_by_day" using btree ( "month" "int4_ops", "day" "int4_ops" );
5422 -- TOC Entry ID 436 (OID 23388)
5424 -- Name: "frsdlfileagg_oid" Type: INDEX Owner: tperdue
5427 CREATE UNIQUE INDEX "frsdlfileagg_oid" on frs_dlstats_file_agg(month,day) ;
5428 -- using btree ( "oid" "oid_ops" );
5431 -- TOC Entry ID 437 (OID 23388)
5433 -- Name: "frsdlfileagg_month_day_file" Type: INDEX Owner: tperdue
5436 CREATE UNIQUE INDEX "frsdlfileagg_month_day_file" on "frs_dlstats_file_agg" using btree ( "month" "int4_ops", "day" "int4_ops", "file_id" "int4_ops" );
5439 -- TOC Entry ID 438 (OID 23401)
5441 -- Name: "statsaggsitebygrp_oid" Type: INDEX Owner: tperdue
5444 CREATE UNIQUE INDEX "statsaggsitebygrp_oid" on stats_agg_site_by_group(month,day) ;
5445 -- using btree ( "oid" "oid_ops" );
5448 -- TOC Entry ID 439 (OID 23401)
5450 -- Name: "statssitebygroup_month_day_grou" Type: INDEX Owner: tperdue
5453 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" );
5456 -- TOC Entry ID 440 (OID 23414)
5458 -- Name: "statsprojectmetric_oid" Type: INDEX Owner: tperdue
5461 CREATE UNIQUE INDEX "statsprojectmetric_oid" on stats_project_metric(month,day) ;
5462 -- using btree ( "oid" "oid_ops" );
5465 -- TOC Entry ID 441 (OID 23414)
5467 -- Name: "statsprojectmetric_month_day_gr" Type: INDEX Owner: tperdue
5470 CREATE UNIQUE INDEX "statsprojectmetric_month_day_gr" on "stats_project_metric" using btree ( "month" "int4_ops", "day" "int4_ops", "group_id" "int4_ops" );
5473 -- TOC Entry ID 442 (OID 23433)
5475 -- Name: "statsagglogobygrp_oid" Type: INDEX Owner: tperdue
5478 CREATE UNIQUE INDEX "statsagglogobygrp_oid" on stats_agg_logo_by_group(month,day) ;
5479 -- using btree ( "oid" "oid_ops" );
5482 -- TOC Entry ID 443 (OID 23433)
5484 -- Name: "statslogobygroup_month_day_grou" Type: INDEX Owner: tperdue
5487 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" );
5490 -- TOC Entry ID 444 (OID 23446)
5492 -- Name: "statssubdpages_oid" Type: INDEX Owner: tperdue
5495 CREATE UNIQUE INDEX "statssubdpages_oid" on stats_subd_pages(month,day) ;
5496 -- using btree ( "oid" "oid_ops" );
5499 -- TOC Entry ID 445 (OID 23446)
5501 -- Name: "statssubdpages_month_day_group" Type: INDEX Owner: tperdue
5504 CREATE UNIQUE INDEX "statssubdpages_month_day_group" on "stats_subd_pages" using btree ( "month" "int4_ops", "day" "int4_ops", "group_id" "int4_ops" );
5507 -- TOC Entry ID 446 (OID 23486)
5509 -- Name: "statscvsgrp_oid" Type: INDEX Owner: tperdue
5512 CREATE UNIQUE INDEX "statscvsgrp_oid" on stats_cvs_group(month,day) ;
5513 -- using btree ( "oid" "oid_ops" );
5516 -- TOC Entry ID 447 (OID 23486)
5518 -- Name: "statscvsgroup_month_day_group" Type: INDEX Owner: tperdue
5521 CREATE UNIQUE INDEX "statscvsgroup_month_day_group" on "stats_cvs_group" using btree ( "month" "int4_ops", "day" "int4_ops", "group_id" "int4_ops" );
5524 -- TOC Entry ID 448 (OID 23507)
5526 -- Name: "statsprojectdevelop_oid" Type: INDEX Owner: tperdue
5529 CREATE UNIQUE INDEX "statsprojectdevelop_oid" on stats_project_developers(month,day) ;
5530 -- using btree ( "oid" "oid_ops" );
5533 -- TOC Entry ID 449 (OID 23507)
5535 -- Name: "statsprojectdev_month_day_group" Type: INDEX Owner: tperdue
5538 CREATE UNIQUE INDEX "statsprojectdev_month_day_group" on "stats_project_developers" using btree ( "month" "int4_ops", "day" "int4_ops", "group_id" "int4_ops" );
5541 -- TOC Entry ID 450 (OID 23524)
5543 -- Name: "statsproject_oid" Type: INDEX Owner: tperdue
5546 CREATE UNIQUE INDEX "statsproject_oid" on stats_project(month,day) ;
5547 -- using btree ( "oid" "oid_ops" );
5550 -- TOC Entry ID 451 (OID 23524)
5552 -- Name: "statsproject_month_day_group" Type: INDEX Owner: tperdue
5555 CREATE UNIQUE INDEX "statsproject_month_day_group" on "stats_project" using btree ( "month" "int4_ops", "day" "int4_ops", "group_id" "int4_ops" );
5558 -- TOC Entry ID 452 (OID 23567)
5560 -- Name: "statssite_oid" Type: INDEX Owner: tperdue
5563 CREATE UNIQUE INDEX "statssite_oid" on stats_site(month,day) ;
5564 -- using btree ( "oid" "oid_ops" );
5567 -- TOC Entry ID 453 (OID 23567)
5569 -- Name: "statssite_month_day" Type: INDEX Owner: tperdue
5572 CREATE UNIQUE INDEX "statssite_month_day" on "stats_site" using btree ( "month" "int4_ops", "day" "int4_ops" );
5575 -- TOC Entry ID 454 (OID 25693)
5577 -- Name: "user_metric_history_date_userid" Type: INDEX Owner: tperdue
5580 CREATE INDEX "user_metric_history_date_userid" on "user_metric_history" using btree ( "month" "int4_ops", "day" "int4_ops", "user_id" "int4_ops" );
5583 -- TOC Entry ID 455 (OID 25710)
5585 -- Name: "foundryprojectrankingsagg_found" Type: INDEX Owner: tperdue
5588 CREATE INDEX "foundryprojectrankingsagg_found" on "foundry_project_rankings_agg" using btree ( "foundry_id" "int4_ops", "ranking" "int4_ops" );
5591 -- TOC Entry ID 456 (OID 25728)
5593 -- Name: "foundryprojdlsagg_foundryid_dls" Type: INDEX Owner: tperdue
5596 CREATE INDEX "foundryprojdlsagg_foundryid_dls" on "foundry_project_downloads_agg" using btree ( "foundry_id" "int4_ops", "downloads" "int4_ops" );
5599 -- TOC Entry ID 457 (OID 25745)
5601 -- Name: "frsdlfiletotal_fileid" Type: INDEX Owner: tperdue
5604 CREATE INDEX "frsdlfiletotal_fileid" on "frs_dlstats_filetotal_agg" using btree ( "file_id" "int4_ops" );
5607 -- TOC Entry ID 458 (OID 25759)
5609 -- Name: "frsdlgrouptotal_groupid" Type: INDEX Owner: tperdue
5612 CREATE INDEX "frsdlgrouptotal_groupid" on "frs_dlstats_grouptotal_agg" using btree ( "group_id" "int4_ops" );
5615 -- TOC Entry ID 459 (OID 25773)
5617 -- Name: "frsdlgroup_groupid" Type: INDEX Owner: tperdue
5620 CREATE INDEX "frsdlgroup_groupid" on "frs_dlstats_group_agg" using btree ( "group_id" "int4_ops" );
5623 -- TOC Entry ID 460 (OID 25773)
5625 -- Name: "frsdlgroup_month_day_groupid" Type: INDEX Owner: tperdue
5628 CREATE INDEX "frsdlgroup_month_day_groupid" on "frs_dlstats_group_agg" using btree ( "month" "int4_ops", "day" "int4_ops", "group_id" "int4_ops" );
5631 -- TOC Entry ID 461 (OID 25792)
5633 -- Name: "statsprojectmonths_groupid" Type: INDEX Owner: tperdue
5636 CREATE INDEX "statsprojectmonths_groupid" on "stats_project_months" using btree ( "group_id" "int4_ops" );
5639 -- TOC Entry ID 462 (OID 25792)
5641 -- Name: "statsprojectmonths_groupid_mont" Type: INDEX Owner: tperdue
5644 CREATE INDEX "statsprojectmonths_groupid_mont" on "stats_project_months" using btree ( "group_id" "int4_ops", "month" "int4_ops" );
5647 -- TOC Entry ID 463 (OID 25834)
5649 -- Name: "statsprojectall_groupid" Type: INDEX Owner: tperdue
5652 CREATE INDEX "statsprojectall_groupid" on "stats_project_all" using btree ( "group_id" "int4_ops" );
5655 -- TOC Entry ID 464 (OID 25884)
5657 -- Name: "statsproject30_groupid" Type: INDEX Owner: tperdue
5660 CREATE INDEX "statsproject30_groupid" on "stats_project_last_30" using btree ( "group_id" "int4_ops" );
5663 -- TOC Entry ID 465 (OID 25935)
5665 -- Name: "statssitelast30_month_day" Type: INDEX Owner: tperdue
5668 CREATE INDEX "statssitelast30_month_day" on "stats_site_last_30" using btree ( "month" "int4_ops", "day" "int4_ops" );
5671 -- TOC Entry ID 466 (OID 25967)
5673 -- Name: "statssitemonths_month" Type: INDEX Owner: tperdue
5676 CREATE INDEX "statssitemonths_month" on "stats_site_months" using btree ( "month" "int4_ops" );
5679 -- TOC Entry ID 467 (OID 26026)
5681 -- Name: "troveagg_trovecatid" Type: INDEX Owner: tperdue
5684 CREATE INDEX "troveagg_trovecatid" on "trove_agg" using btree ( "trove_cat_id" "int4_ops" );
5687 -- TOC Entry ID 468 (OID 26026)
5689 -- Name: "troveagg_trovecatid_ranking" Type: INDEX Owner: tperdue
5692 CREATE INDEX "troveagg_trovecatid_ranking" on "trove_agg" using btree ( "trove_cat_id" "int4_ops", "ranking" "int4_ops" );
5694 ALTER TABLE user_group ADD CONSTRAINT user_group_user_id_fk
5695 FOREIGN KEY (user_id) REFERENCES users(user_id) MATCH FULL ;
5697 ALTER TABLE user_group ADD CONSTRAINT user_group_group_id_fk
5698 FOREIGN KEY (group_id) REFERENCES groups(group_id) MATCH FULL ;
5700 ALTER TABLE forum ADD CONSTRAINT forum_group_forum_id_fk
5701 FOREIGN KEY (group_forum_id) REFERENCES forum_group_list(group_forum_id) MATCH FULL ;
5703 ALTER TABLE forum_group_list ADD CONSTRAINT forum_group_list_group_id_fk
5704 FOREIGN KEY (group_id) REFERENCES groups(group_id) MATCH FULL ;
5706 ALTER TABLE project_group_list ADD CONSTRAINT project_group_list_group_id_fk
5707 FOREIGN KEY (group_id) REFERENCES groups(group_id) MATCH FULL ;
5710 -- TOC Entry ID 644 (OID 24227)
5712 -- Name: "RI_ConstraintTrigger_24226" Type: TRIGGER Owner: tperdue
5715 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');
5718 -- TOC Entry ID 640 (OID 24229)
5720 -- Name: "RI_ConstraintTrigger_24228" Type: TRIGGER Owner: tperdue
5723 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');
5726 -- TOC Entry ID 641 (OID 24231)
5728 -- Name: "RI_ConstraintTrigger_24230" Type: TRIGGER Owner: tperdue
5731 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');
5734 -- TOC Entry ID 645 (OID 24233)
5736 -- Name: "RI_ConstraintTrigger_24232" Type: TRIGGER Owner: tperdue
5739 ALTER TABLE project_task ADD CONSTRAINT project_task_created_by_fk
5740 FOREIGN KEY (created_by) REFERENCES users(user_id) MATCH FULL ;
5743 -- TOC Entry ID 646 (OID 24239)
5745 -- Name: "RI_ConstraintTrigger_24238" Type: TRIGGER Owner: tperdue
5748 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');
5751 -- TOC Entry ID 642 (OID 24241)
5753 -- Name: "RI_ConstraintTrigger_24240" Type: TRIGGER Owner: tperdue
5756 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');
5759 -- TOC Entry ID 643 (OID 24243)
5761 -- Name: "RI_ConstraintTrigger_24242" Type: TRIGGER Owner: tperdue
5764 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');
5767 -- TOC Entry ID 659 (OID 24245)
5769 -- Name: "RI_ConstraintTrigger_24244" Type: TRIGGER Owner: tperdue
5772 ALTER TABLE users ADD CONSTRAINT users_languageid_fk
5773 FOREIGN KEY (language) REFERENCES supported_languages(language_id) MATCH FULL ;
5775 ALTER TABLE artifact_group_list ADD CONSTRAINT artifactgroup_groupid_fk FOREIGN KEY (group_id) REFERENCES groups(group_id) MATCH FULL ;
5777 ALTER TABLE artifact_perm ADD CONSTRAINT artifactperm_userid_fk
5778 FOREIGN KEY (user_id) REFERENCES users(user_id) MATCH FULL;
5779 ALTER TABLE artifact_perm ADD CONSTRAINT artifactperm_groupartifactid_fk
5780 FOREIGN KEY (group_artifact_id) REFERENCES artifact_group_list(group_artifact_id) MATCH FULL;
5782 ALTER TABLE artifact_category ADD CONSTRAINT artifactcategory_autoassignto_fk
5783 FOREIGN KEY (auto_assign_to) REFERENCES users(user_id) MATCH FULL;
5784 ALTER TABLE artifact_category ADD CONSTRAINT artifactcategory_groupartifactid_fk
5785 FOREIGN KEY (group_artifact_id) REFERENCES artifact_group_list(group_artifact_id) MATCH FULL;
5787 ALTER TABLE artifact_group ADD CONSTRAINT artifactgroup_groupartifactid_fk
5788 FOREIGN KEY (group_artifact_id) REFERENCES artifact_group_list(group_artifact_id) MATCH FULL;
5790 ALTER TABLE artifact ADD CONSTRAINT artifact_artifactgroupid_fk
5791 FOREIGN KEY (artifact_group_id) REFERENCES artifact_group(id) MATCH FULL;
5792 ALTER TABLE artifact ADD CONSTRAINT artifact_assignedto_fk
5793 FOREIGN KEY (assigned_to) REFERENCES users(user_id) MATCH FULL;
5794 ALTER TABLE artifact ADD CONSTRAINT artifact_categoryid_fk
5795 FOREIGN KEY (category_id) REFERENCES artifact_category(id) MATCH FULL;
5796 ALTER TABLE artifact ADD CONSTRAINT artifact_groupartifactid_fk
5797 FOREIGN KEY (group_artifact_id) REFERENCES artifact_group_list(group_artifact_id) MATCH FULL;
5798 ALTER TABLE artifact ADD CONSTRAINT artifact_resolutionid_fk
5799 FOREIGN KEY (resolution_id) REFERENCES artifact_resolution(id) MATCH FULL;
5800 ALTER TABLE artifact ADD CONSTRAINT artifact_statusid_fk
5801 FOREIGN KEY (status_id) REFERENCES artifact_status(id) MATCH FULL;
5802 ALTER TABLE artifact ADD CONSTRAINT artifact_submittedby_fk
5803 FOREIGN KEY (submitted_by) REFERENCES users(user_id) MATCH FULL;
5805 ALTER TABLE artifact_history ADD CONSTRAINT artifacthistory_artifactid_fk
5806 FOREIGN KEY (artifact_id) REFERENCES artifact(artifact_id) MATCH FULL;
5807 ALTER TABLE artifact_history ADD CONSTRAINT artifacthistory_modby_fk
5808 FOREIGN KEY (mod_by) REFERENCES users(user_id) MATCH FULL;
5810 ALTER TABLE artifact_file ADD CONSTRAINT artifactfile_artifactid_fk
5811 FOREIGN KEY (artifact_id) REFERENCES artifact(artifact_id) MATCH FULL;
5812 ALTER TABLE artifact_file ADD CONSTRAINT artifactfile_submittedby_fk
5813 FOREIGN KEY (submitted_by) REFERENCES users(user_id) MATCH FULL;
5815 ALTER TABLE artifact_message ADD CONSTRAINT artifactmessage_artifactid_fk
5816 FOREIGN KEY (artifact_id) REFERENCES artifact(artifact_id) MATCH FULL;
5817 ALTER TABLE artifact_message ADD CONSTRAINT artifactmessage_submittedby_fk
5818 FOREIGN KEY (submitted_by) REFERENCES users(user_id) MATCH FULL;
5820 ALTER TABLE artifact_monitor ADD CONSTRAINT artifactmonitor_artifactid_fk
5821 FOREIGN KEY (artifact_id) REFERENCES artifact(artifact_id) MATCH FULL;
5824 -- TOC Entry ID 685 (OID 24376)
5826 -- Name: artifactgrouplist_insert_trig Type: TRIGGER Owner: tperdue
5829 CREATE TRIGGER "artifactgrouplist_insert_trig" AFTER INSERT ON "artifact_group_list" FOR EACH ROW EXECUTE PROCEDURE "artifactgrouplist_insert_agg" ();
5832 -- TOC Entry ID 716 (OID 24377)
5834 -- Name: artifactgroup_update_trig Type: TRIGGER Owner: tperdue
5837 CREATE TRIGGER "artifactgroup_update_trig" AFTER UPDATE ON "artifact" FOR EACH ROW EXECUTE PROCEDURE "artifactgroup_update_agg" ();
5840 -- TOC Entry ID 608 (OID 24378)
5842 -- Name: forumgrouplist_insert_trig Type: TRIGGER Owner: tperdue
5845 CREATE TRIGGER "forumgrouplist_insert_trig" AFTER INSERT ON "forum_group_list" FOR EACH ROW EXECUTE PROCEDURE "forumgrouplist_insert_agg" ();
5847 ALTER TABLE frs_file ADD CONSTRAINT frsfile_processorid_fk
5848 FOREIGN KEY (processor_id) REFERENCES frs_processor(processor_id) MATCH FULL;
5849 ALTER TABLE frs_file ADD CONSTRAINT frsfile_releaseid_fk
5850 FOREIGN KEY (release_id) REFERENCES frs_release(release_id) MATCH FULL;
5851 ALTER TABLE frs_file ADD CONSTRAINT frsfile_typeid_fk
5852 FOREIGN KEY (type_id) REFERENCES frs_filetype(type_id) MATCH FULL;
5854 ALTER TABLE frs_package ADD CONSTRAINT frspackage_statusid_fk
5855 FOREIGN KEY (status_id) REFERENCES frs_status(status_id) MATCH FULL;
5856 ALTER TABLE frs_package ADD CONSTRAINT frspackage_groupid_fk
5857 FOREIGN KEY (group_id) REFERENCES groups(group_id) MATCH FULL ;
5859 ALTER TABLE frs_release ADD CONSTRAINT frsrelease_packageid_fk
5860 FOREIGN KEY (package_id) REFERENCES frs_package(package_id) MATCH FULL;
5861 ALTER TABLE frs_release ADD CONSTRAINT frsrelease_releasedby_fk
5862 FOREIGN KEY (released_by) REFERENCES users(user_id) MATCH FULL;
5863 ALTER TABLE frs_release ADD CONSTRAINT frsrelease_statusid_fk
5864 FOREIGN KEY (status_id) REFERENCES frs_status(status_id) MATCH FULL;
5867 -- TOC Entry ID 725 (OID 24427)
5869 -- Name: forum_insert_agg Type: RULE Owner: tperdue
5872 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);
5874 -- TOC Entry ID 726 (OID 24428)
5876 -- Name: forum_delete_agg Type: RULE Owner: tperdue
5879 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);
5881 -- TOC Entry ID 727 (OID 24429)
5883 -- Name: artifact_insert_agg Type: RULE Owner: tperdue
5886 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);
5888 -- TOC Entry ID 3 (OID 18724)
5890 -- Name: canned_responses_pk_seq Type: SEQUENCE SET Owner:
5893 SELECT setval ('"canned_responses_pk_seq"', 1, 'f');
5896 -- TOC Entry ID 5 (OID 18774)
5898 -- Name: db_images_pk_seq Type: SEQUENCE SET Owner:
5901 SELECT setval ('"db_images_pk_seq"', 1, 'f');
5904 -- TOC Entry ID 7 (OID 18840)
5906 -- Name: doc_data_pk_seq Type: SEQUENCE SET Owner:
5909 SELECT setval ('"doc_data_pk_seq"', 1, 'f');
5912 -- TOC Entry ID 9 (OID 18905)
5914 -- Name: doc_groups_pk_seq Type: SEQUENCE SET Owner:
5917 SELECT setval ('"doc_groups_pk_seq"', 1, 'f');
5920 -- TOC Entry ID 11 (OID 18942)
5922 -- Name: doc_states_pk_seq Type: SEQUENCE SET Owner:
5925 SELECT setval ('"doc_states_pk_seq"', 1, 'f');
5928 -- TOC Entry ID 13 (OID 18977)
5930 -- Name: filemodule_monitor_pk_seq Type: SEQUENCE SET Owner:
5933 SELECT setval ('"filemodule_monitor_pk_seq"', 1, 'f');
5936 -- TOC Entry ID 15 (OID 19014)
5938 -- Name: forum_pk_seq Type: SEQUENCE SET Owner:
5941 SELECT setval ('"forum_pk_seq"', 1, 'f');
5944 -- TOC Entry ID 17 (OID 19096)
5946 -- Name: forum_group_list_pk_seq Type: SEQUENCE SET Owner:
5949 SELECT setval ('"forum_group_list_pk_seq"', 1, 'f');
5952 -- TOC Entry ID 19 (OID 19154)
5954 -- Name: forum_monitored_forums_pk_seq Type: SEQUENCE SET Owner:
5957 SELECT setval ('"forum_monitored_forums_pk_seq"', 1, 'f');
5960 -- TOC Entry ID 21 (OID 19191)
5962 -- Name: forum_saved_place_pk_seq Type: SEQUENCE SET Owner:
5965 SELECT setval ('"forum_saved_place_pk_seq"', 1, 'f');
5968 -- TOC Entry ID 23 (OID 19268)
5970 -- Name: foundry_news_pk_seq Type: SEQUENCE SET Owner:
5973 SELECT setval ('"foundry_news_pk_seq"', 1, 'f');
5976 -- TOC Entry ID 25 (OID 19309)
5978 -- Name: foundry_preferred_projec_pk_seq Type: SEQUENCE SET Owner:
5981 SELECT setval ('"foundry_preferred_projec_pk_seq"', 1, 'f');
5984 -- TOC Entry ID 27 (OID 19348)
5986 -- Name: foundry_projects_pk_seq Type: SEQUENCE SET Owner:
5989 SELECT setval ('"foundry_projects_pk_seq"', 1, 'f');
5992 -- TOC Entry ID 29 (OID 19385)
5994 -- Name: frs_file_pk_seq Type: SEQUENCE SET Owner:
5997 SELECT setval ('"frs_file_pk_seq"', 1, 'f');
6000 -- TOC Entry ID 31 (OID 19446)
6002 -- Name: frs_filetype_pk_seq Type: SEQUENCE SET Owner:
6005 SELECT setval ('"frs_filetype_pk_seq"', 9999, 't');
6008 -- TOC Entry ID 33 (OID 19495)
6010 -- Name: frs_package_pk_seq Type: SEQUENCE SET Owner:
6013 SELECT setval ('"frs_package_pk_seq"', 1, 'f');
6016 -- TOC Entry ID 35 (OID 19548)
6018 -- Name: frs_processor_pk_seq Type: SEQUENCE SET Owner:
6021 SELECT setval ('"frs_processor_pk_seq"', 9999, 't');
6024 -- TOC Entry ID 37 (OID 19597)
6026 -- Name: frs_release_pk_seq Type: SEQUENCE SET Owner:
6029 SELECT setval ('"frs_release_pk_seq"', 1, 'f');
6032 -- TOC Entry ID 39 (OID 19658)
6034 -- Name: frs_status_pk_seq Type: SEQUENCE SET Owner:
6037 SELECT setval ('"frs_status_pk_seq"', 3, 't');
6040 -- TOC Entry ID 41 (OID 19707)
6042 -- Name: group_cvs_history_pk_seq Type: SEQUENCE SET Owner:
6045 SELECT setval ('"group_cvs_history_pk_seq"', 1, 'f');
6048 -- TOC Entry ID 43 (OID 19726)
6050 -- Name: group_history_pk_seq Type: SEQUENCE SET Owner:
6053 SELECT setval ('"group_history_pk_seq"', 1, 'f');
6056 -- TOC Entry ID 45 (OID 19783)
6058 -- Name: group_type_pk_seq Type: SEQUENCE SET Owner:
6061 SELECT setval ('"group_type_pk_seq"', 1, 'f');
6064 -- TOC Entry ID 47 (OID 19832)
6066 -- Name: groups_pk_seq Type: SEQUENCE SET Owner:
6069 SELECT setval ('"groups_pk_seq"', 4, 't');
6072 -- TOC Entry ID 49 (OID 19977)
6074 -- Name: mail_group_list_pk_seq Type: SEQUENCE SET Owner:
6077 SELECT setval ('"mail_group_list_pk_seq"', 1, 'f');
6080 -- TOC Entry ID 51 (OID 20036)
6082 -- Name: news_bytes_pk_seq Type: SEQUENCE SET Owner:
6085 SELECT setval ('"news_bytes_pk_seq"', 1, 'f');
6088 -- TOC Entry ID 53 (OID 20096)
6090 -- Name: people_job_pk_seq Type: SEQUENCE SET Owner:
6093 SELECT setval ('"people_job_pk_seq"', 1, 'f');
6096 -- TOC Entry ID 55 (OID 20156)
6098 -- Name: people_job_category_pk_seq Type: SEQUENCE SET Owner:
6101 SELECT setval ('"people_job_category_pk_seq"', 7, 't');
6104 -- TOC Entry ID 57 (OID 20207)
6106 -- Name: people_job_inventory_pk_seq Type: SEQUENCE SET Owner:
6109 SELECT setval ('"people_job_inventory_pk_seq"', 1, 'f');
6112 -- TOC Entry ID 59 (OID 20248)
6114 -- Name: people_job_status_pk_seq Type: SEQUENCE SET Owner:
6117 SELECT setval ('"people_job_status_pk_seq"', 1, 'f');
6120 -- TOC Entry ID 61 (OID 20297)
6122 -- Name: people_skill_pk_seq Type: SEQUENCE SET Owner:
6125 SELECT setval ('"people_skill_pk_seq"', 1, 'f');
6128 -- TOC Entry ID 63 (OID 20346)
6130 -- Name: people_skill_inventory_pk_seq Type: SEQUENCE SET Owner:
6133 SELECT setval ('"people_skill_inventory_pk_seq"', 1, 'f');
6136 -- TOC Entry ID 65 (OID 20387)
6138 -- Name: people_skill_level_pk_seq Type: SEQUENCE SET Owner:
6141 SELECT setval ('"people_skill_level_pk_seq"', 5, 't');
6144 -- TOC Entry ID 67 (OID 20436)
6146 -- Name: people_skill_year_pk_seq Type: SEQUENCE SET Owner:
6149 SELECT setval ('"people_skill_year_pk_seq"', 5, 't');
6152 -- TOC Entry ID 69 (OID 20485)
6154 -- Name: project_assigned_to_pk_seq Type: SEQUENCE SET Owner:
6157 SELECT setval ('"project_assigned_to_pk_seq"', 1, 'f');
6160 -- TOC Entry ID 71 (OID 20522)
6162 -- Name: project_dependencies_pk_seq Type: SEQUENCE SET Owner:
6165 SELECT setval ('"project_dependencies_pk_seq"', 1, 'f');
6168 -- TOC Entry ID 73 (OID 20559)
6170 -- Name: project_group_list_pk_seq Type: SEQUENCE SET Owner:
6173 SELECT setval ('"project_group_list_pk_seq"', 1, 't');
6176 -- TOC Entry ID 75 (OID 20614)
6178 -- Name: project_history_pk_seq Type: SEQUENCE SET Owner:
6181 SELECT setval ('"project_history_pk_seq"', 1, 'f');
6184 -- TOC Entry ID 77 (OID 20672)
6186 -- Name: project_metric_pk_seq Type: SEQUENCE SET Owner:
6189 SELECT setval ('"project_metric_pk_seq"', 1, 'f');
6192 -- TOC Entry ID 79 (OID 20708)
6194 -- Name: project_metric_tmp1_pk_seq Type: SEQUENCE SET Owner:
6197 -- SELECT setval ('"project_metric_tmp1_pk_seq"', 1, 'f');
6200 -- TOC Entry ID 81 (OID 20744)
6202 -- Name: project_metric_weekly_tm_pk_seq Type: SEQUENCE SET Owner:
6205 SELECT setval ('"project_metric_weekly_tm_pk_seq"', 1, 'f');
6208 -- TOC Entry ID 83 (OID 20763)
6210 -- Name: project_status_pk_seq Type: SEQUENCE SET Owner:
6213 SELECT setval ('"project_status_pk_seq"', 1, 'f');
6216 -- TOC Entry ID 85 (OID 20813)
6218 -- Name: project_task_pk_seq Type: SEQUENCE SET Owner:
6221 SELECT setval ('"project_task_pk_seq"', 100, 't');
6224 -- TOC Entry ID 87 (OID 20881)
6226 -- Name: project_weekly_metric_pk_seq Type: SEQUENCE SET Owner:
6229 SELECT setval ('"project_weekly_metric_pk_seq"', 1, 'f');
6232 -- TOC Entry ID 89 (OID 20934)
6234 -- Name: snippet_pk_seq Type: SEQUENCE SET Owner:
6237 SELECT setval ('"snippet_pk_seq"', 1, 'f');
6240 -- TOC Entry ID 91 (OID 20994)
6242 -- Name: snippet_package_pk_seq Type: SEQUENCE SET Owner:
6245 SELECT setval ('"snippet_package_pk_seq"', 1, 'f');
6248 -- TOC Entry ID 93 (OID 21050)
6250 -- Name: snippet_package_item_pk_seq Type: SEQUENCE SET Owner:
6253 SELECT setval ('"snippet_package_item_pk_seq"', 1, 'f');
6256 -- TOC Entry ID 95 (OID 21087)
6258 -- Name: snippet_package_version_pk_seq Type: SEQUENCE SET Owner:
6261 SELECT setval ('"snippet_package_version_pk_seq"', 1, 'f');
6264 -- TOC Entry ID 97 (OID 21143)
6266 -- Name: snippet_version_pk_seq Type: SEQUENCE SET Owner:
6269 SELECT setval ('"snippet_version_pk_seq"', 1, 'f');
6272 -- TOC Entry ID 99 (OID 21258)
6274 -- Name: supported_languages_pk_seq Type: SEQUENCE SET Owner:
6277 SELECT setval ('"supported_languages_pk_seq"', 23, 't');
6280 -- TOC Entry ID 101 (OID 21310)
6282 -- Name: survey_question_types_pk_seq Type: SEQUENCE SET Owner:
6285 SELECT setval ('"survey_question_types_pk_seq"', 1, 'f');
6288 -- TOC Entry ID 103 (OID 21360)
6290 -- Name: survey_questions_pk_seq Type: SEQUENCE SET Owner:
6293 SELECT setval ('"survey_questions_pk_seq"', 1, 'f');
6296 -- TOC Entry ID 105 (OID 21486)
6298 -- Name: surveys_pk_seq Type: SEQUENCE SET Owner:
6301 SELECT setval ('"surveys_pk_seq"', 1, 'f');
6304 -- TOC Entry ID 107 (OID 21542)
6306 -- Name: system_history_pk_seq Type: SEQUENCE SET Owner:
6309 SELECT setval ('"system_history_pk_seq"', 1, 'f');
6312 -- TOC Entry ID 109 (OID 21561)
6314 -- Name: system_machines_pk_seq Type: SEQUENCE SET Owner:
6317 SELECT setval ('"system_machines_pk_seq"', 1, 'f');
6320 -- TOC Entry ID 111 (OID 21580)
6322 -- Name: system_news_pk_seq Type: SEQUENCE SET Owner:
6325 SELECT setval ('"system_news_pk_seq"', 1, 'f');
6328 -- TOC Entry ID 113 (OID 21599)
6330 -- Name: system_services_pk_seq Type: SEQUENCE SET Owner:
6333 SELECT setval ('"system_services_pk_seq"', 1, 'f');
6336 -- TOC Entry ID 115 (OID 21618)
6338 -- Name: system_status_pk_seq Type: SEQUENCE SET Owner:
6341 SELECT setval ('"system_status_pk_seq"', 1, 'f');
6344 -- TOC Entry ID 117 (OID 21665)
6346 -- Name: themes_pk_seq Type: SEQUENCE SET Owner:
6349 SELECT setval ('"themes_pk_seq"', 1, 't');
6352 -- TOC Entry ID 119 (OID 21742)
6354 -- Name: trove_cat_pk_seq Type: SEQUENCE SET Owner:
6357 SELECT setval ('"trove_cat_pk_seq"', 305, 't');
6360 -- TOC Entry ID 121 (OID 21806)
6362 -- Name: trove_group_link_pk_seq Type: SEQUENCE SET Owner:
6365 SELECT setval ('"trove_group_link_pk_seq"', 1, 'f');
6368 -- TOC Entry ID 123 (OID 21847)
6370 -- Name: trove_treesums_pk_seq Type: SEQUENCE SET Owner:
6373 SELECT setval ('"trove_treesums_pk_seq"', 1, 'f');
6376 -- TOC Entry ID 125 (OID 21866)
6378 -- Name: user_bookmarks_pk_seq Type: SEQUENCE SET Owner:
6381 SELECT setval ('"user_bookmarks_pk_seq"', 1, 'f');
6384 -- TOC Entry ID 127 (OID 21918)
6386 -- Name: user_diary_pk_seq Type: SEQUENCE SET Owner:
6389 SELECT setval ('"user_diary_pk_seq"', 1, 'f');
6392 -- TOC Entry ID 129 (OID 21974)
6394 -- Name: user_diary_monitor_pk_seq Type: SEQUENCE SET Owner:
6397 SELECT setval ('"user_diary_monitor_pk_seq"', 1, 'f');
6400 -- TOC Entry ID 131 (OID 22011)
6402 -- Name: user_group_pk_seq Type: SEQUENCE SET Owner:
6405 SELECT setval ('"user_group_pk_seq"', 1, 'f');
6408 -- TOC Entry ID 133 (OID 22069)
6410 -- Name: user_metric_pk_seq Type: SEQUENCE SET Owner:
6413 SELECT setval ('"user_metric_pk_seq"', 1, 'f');
6416 -- TOC Entry ID 135 (OID 22116)
6418 -- Name: user_metric0_pk_seq Type: SEQUENCE SET Owner:
6421 SELECT setval ('"user_metric0_pk_seq"', 1, 'f');
6424 -- TOC Entry ID 137 (OID 22211)
6426 -- Name: users_pk_seq Type: SEQUENCE SET Owner:
6429 SELECT setval ('"users_pk_seq"', 1, 'f');
6432 -- TOC Entry ID 139 (OID 22298)
6434 -- Name: unix_uid_seq Type: SEQUENCE SET Owner:
6437 SELECT setval ('"unix_uid_seq"', 1, 'f');
6440 -- TOC Entry ID 141 (OID 22317)
6442 -- Name: forum_thread_seq Type: SEQUENCE SET Owner:
6445 SELECT setval ('"forum_thread_seq"', 1, 'f');
6448 -- TOC Entry ID 143 (OID 22350)
6450 -- Name: project_metric_wee_ranking1_seq Type: SEQUENCE SET Owner:
6453 -- SELECT setval ('"project_metric_wee_ranking1_seq"', 1, 'f');
6456 -- TOC Entry ID 145 (OID 22369)
6458 -- Name: prdb_dbs_dbid_seq Type: SEQUENCE SET Owner:
6461 SELECT setval ('"prdb_dbs_dbid_seq"', 1, 'f');
6464 -- TOC Entry ID 147 (OID 22481)
6466 -- Name: prweb_vhost_vhostid_seq Type: SEQUENCE SET Owner:
6469 SELECT setval ('"prweb_vhost_vhostid_seq"', 1, 'f');
6472 -- TOC Entry ID 149 (OID 22533)
6474 -- Name: artifact_grou_group_artifac_seq Type: SEQUENCE SET Owner:
6477 SELECT setval ('"artifact_grou_group_artifac_seq"', 100, 't');
6480 -- TOC Entry ID 151 (OID 22600)
6482 -- Name: artifact_resolution_id_seq Type: SEQUENCE SET Owner:
6485 SELECT setval ('"artifact_resolution_id_seq"', 1, 'f');
6488 -- TOC Entry ID 153 (OID 22649)
6490 -- Name: artifact_perm_id_seq Type: SEQUENCE SET Owner:
6493 SELECT setval ('"artifact_perm_id_seq"', 1, 'f');
6496 -- TOC Entry ID 155 (OID 22718)
6498 -- Name: artifact_category_id_seq Type: SEQUENCE SET Owner:
6501 SELECT setval ('"artifact_category_id_seq"', 100, 't');
6504 -- TOC Entry ID 157 (OID 22770)
6506 -- Name: artifact_group_id_seq Type: SEQUENCE SET Owner:
6509 SELECT setval ('"artifact_group_id_seq"', 1, 'f');
6512 -- TOC Entry ID 159 (OID 22820)
6514 -- Name: artifact_status_id_seq Type: SEQUENCE SET Owner:
6517 SELECT setval ('"artifact_status_id_seq"', 3, 't');
6520 -- TOC Entry ID 161 (OID 22869)
6522 -- Name: artifact_artifact_id_seq Type: SEQUENCE SET Owner:
6525 SELECT setval ('"artifact_artifact_id_seq"', 1, 'f');
6528 -- TOC Entry ID 163 (OID 22974)
6530 -- Name: artifact_history_id_seq Type: SEQUENCE SET Owner:
6533 SELECT setval ('"artifact_history_id_seq"', 1, 'f');
6536 -- TOC Entry ID 165 (OID 23048)
6538 -- Name: artifact_file_id_seq Type: SEQUENCE SET Owner:
6541 SELECT setval ('"artifact_file_id_seq"', 1, 'f');
6544 -- TOC Entry ID 167 (OID 23126)
6546 -- Name: artifact_message_id_seq Type: SEQUENCE SET Owner:
6549 SELECT setval ('"artifact_message_id_seq"', 1, 'f');
6552 -- TOC Entry ID 169 (OID 23199)
6554 -- Name: artifact_monitor_id_seq Type: SEQUENCE SET Owner:
6557 SELECT setval ('"artifact_monitor_id_seq"', 1, 'f');
6560 -- TOC Entry ID 171 (OID 23250)
6562 -- Name: artifact_canned_response_id_seq Type: SEQUENCE SET Owner:
6565 SELECT setval ('"artifact_canned_response_id_seq"', 1, 'f');
6568 -- TOC Entry ID 173 (OID 23330)
6570 -- Name: massmail_queue_id_seq Type: SEQUENCE SET Owner:
6573 SELECT setval ('"massmail_queue_id_seq"', 1, 'f');
6576 -- TOC Entry ID 175 (OID 26050)
6578 -- Name: trove_treesum_trove_treesum_seq Type: SEQUENCE SET Owner:
6581 -- SELECT setval ('"trove_treesum_trove_treesum_seq"', 1, 'f');
6583 ---- From now on, everything comes from Debian-SF
6585 -- System projects were *not* created in 1970
6586 update groups set register_time = int4(abstime(now())) ;