2 -- TOC Entry ID 2 (OID 18724)
4 -- Name: canned_responses_pk_seq Type: SEQUENCE Owner: tperdue
7 CREATE SEQUENCE "canned_responses_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
10 -- TOC Entry ID 176 (OID 18743)
12 -- Name: canned_responses Type: TABLE Owner: tperdue
15 CREATE TABLE "canned_responses" (
16 "response_id" integer DEFAULT nextval('canned_responses_pk_seq'::text) NOT NULL,
17 "response_title" character varying(25),
19 Constraint "canned_responses_pkey" Primary Key ("response_id")
23 -- TOC Entry ID 4 (OID 18774)
25 -- Name: db_images_pk_seq Type: SEQUENCE Owner: tperdue
28 CREATE SEQUENCE "db_images_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
31 -- TOC Entry ID 177 (OID 18793)
33 -- Name: db_images Type: TABLE Owner: tperdue
36 CREATE TABLE "db_images" (
37 "id" integer DEFAULT nextval('db_images_pk_seq'::text) NOT NULL,
38 "group_id" integer DEFAULT '0' NOT NULL,
39 "description" text DEFAULT '' NOT NULL,
40 "bin_data" text DEFAULT '' NOT NULL,
41 "filename" text DEFAULT '' NOT NULL,
42 "filesize" integer DEFAULT '0' NOT NULL,
43 "filetype" text DEFAULT '' NOT NULL,
44 "width" integer DEFAULT '0' NOT NULL,
45 "height" integer DEFAULT '0' NOT NULL,
46 "upload_date" integer,
48 Constraint "db_images_pkey" Primary Key ("id")
52 -- TOC Entry ID 6 (OID 18840)
54 -- Name: doc_data_pk_seq Type: SEQUENCE Owner: tperdue
57 CREATE SEQUENCE "doc_data_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
60 -- TOC Entry ID 178 (OID 18859)
62 -- Name: doc_data Type: TABLE Owner: tperdue
65 CREATE TABLE "doc_data" (
66 "docid" integer DEFAULT nextval('doc_data_pk_seq'::text) NOT NULL,
67 "stateid" integer DEFAULT '0' NOT NULL,
68 "title" character varying(255) DEFAULT '' NOT NULL,
69 "data" text DEFAULT '' NOT NULL,
70 "updatedate" integer DEFAULT '0' NOT NULL,
71 "createdate" integer DEFAULT '0' NOT NULL,
72 "created_by" integer DEFAULT '0' NOT NULL,
73 "doc_group" integer DEFAULT '0' NOT NULL,
75 "language_id" integer DEFAULT '1' NOT NULL,
76 Constraint "doc_data_pkey" Primary Key ("docid")
80 -- TOC Entry ID 8 (OID 18905)
82 -- Name: doc_groups_pk_seq Type: SEQUENCE Owner: tperdue
85 CREATE SEQUENCE "doc_groups_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
88 -- TOC Entry ID 179 (OID 18924)
90 -- Name: doc_groups Type: TABLE Owner: tperdue
93 CREATE TABLE "doc_groups" (
94 "doc_group" integer DEFAULT nextval('doc_groups_pk_seq'::text) NOT NULL,
95 "groupname" character varying(255) DEFAULT '' NOT NULL,
96 "group_id" integer DEFAULT '0' NOT NULL,
97 Constraint "doc_groups_pkey" Primary Key ("doc_group")
101 -- TOC Entry ID 10 (OID 18942)
103 -- Name: doc_states_pk_seq Type: SEQUENCE Owner: tperdue
106 CREATE SEQUENCE "doc_states_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
109 -- TOC Entry ID 180 (OID 18961)
111 -- Name: doc_states Type: TABLE Owner: tperdue
114 CREATE TABLE "doc_states" (
115 "stateid" integer DEFAULT nextval('doc_states_pk_seq'::text) NOT NULL,
116 "name" character varying(255) DEFAULT '' NOT NULL,
117 Constraint "doc_states_pkey" Primary Key ("stateid")
121 -- TOC Entry ID 12 (OID 18977)
123 -- Name: filemodule_monitor_pk_seq Type: SEQUENCE Owner: tperdue
126 CREATE SEQUENCE "filemodule_monitor_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
129 -- TOC Entry ID 181 (OID 18996)
131 -- Name: filemodule_monitor Type: TABLE Owner: tperdue
134 CREATE TABLE "filemodule_monitor" (
135 "id" integer DEFAULT nextval('filemodule_monitor_pk_seq'::text) NOT NULL,
136 "filemodule_id" integer DEFAULT '0' NOT NULL,
137 "user_id" integer DEFAULT '0' NOT NULL,
138 Constraint "filemodule_monitor_pkey" Primary Key ("id")
142 -- TOC Entry ID 14 (OID 19014)
144 -- Name: forum_pk_seq Type: SEQUENCE Owner: tperdue
147 CREATE SEQUENCE "forum_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
150 -- TOC Entry ID 182 (OID 19033)
152 -- Name: forum Type: TABLE Owner: tperdue
155 CREATE TABLE "forum" (
156 "msg_id" integer DEFAULT nextval('forum_pk_seq'::text) NOT NULL,
157 "group_forum_id" integer DEFAULT '0' NOT NULL,
158 "posted_by" integer DEFAULT '0' NOT NULL,
159 "subject" text DEFAULT '' NOT NULL,
160 "body" text DEFAULT '' NOT NULL,
161 "date" integer DEFAULT '0' NOT NULL,
162 "is_followup_to" integer DEFAULT '0' NOT NULL,
163 "thread_id" integer DEFAULT '0' NOT NULL,
164 "has_followups" integer DEFAULT '0',
165 "most_recent_date" integer DEFAULT '0' NOT NULL,
166 Constraint "forum_pkey" Primary Key ("msg_id")
170 -- TOC Entry ID 183 (OID 19080)
172 -- Name: forum_agg_msg_count Type: TABLE Owner: tperdue
175 CREATE TABLE "forum_agg_msg_count" (
176 "group_forum_id" integer DEFAULT '0' NOT NULL,
177 "count" integer DEFAULT '0' NOT NULL,
178 Constraint "forum_agg_msg_count_pkey" Primary Key ("group_forum_id")
182 -- TOC Entry ID 16 (OID 19096)
184 -- Name: forum_group_list_pk_seq Type: SEQUENCE Owner: tperdue
187 CREATE SEQUENCE "forum_group_list_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
190 -- TOC Entry ID 184 (OID 19115)
192 -- Name: forum_group_list Type: TABLE Owner: tperdue
195 CREATE TABLE "forum_group_list" (
196 "group_forum_id" integer DEFAULT nextval('forum_group_list_pk_seq'::text) NOT NULL,
197 "group_id" integer DEFAULT '0' NOT NULL,
198 "forum_name" text DEFAULT '' NOT NULL,
199 "is_public" integer DEFAULT '0' NOT NULL,
201 "allow_anonymous" integer DEFAULT '0' NOT NULL,
202 "send_all_posts_to" text,
203 Constraint "forum_group_list_pkey" Primary Key ("group_forum_id")
207 -- TOC Entry ID 18 (OID 19154)
209 -- Name: forum_monitored_forums_pk_seq Type: SEQUENCE Owner: tperdue
212 CREATE SEQUENCE "forum_monitored_forums_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
215 -- TOC Entry ID 185 (OID 19173)
217 -- Name: forum_monitored_forums Type: TABLE Owner: tperdue
220 CREATE TABLE "forum_monitored_forums" (
221 "monitor_id" integer DEFAULT nextval('forum_monitored_forums_pk_seq'::text) NOT NULL,
222 "forum_id" integer DEFAULT '0' NOT NULL,
223 "user_id" integer DEFAULT '0' NOT NULL,
224 Constraint "forum_monitored_forums_pkey" Primary Key ("monitor_id")
228 -- TOC Entry ID 20 (OID 19191)
230 -- Name: forum_saved_place_pk_seq Type: SEQUENCE Owner: tperdue
233 CREATE SEQUENCE "forum_saved_place_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
236 -- TOC Entry ID 186 (OID 19210)
238 -- Name: forum_saved_place Type: TABLE Owner: tperdue
241 CREATE TABLE "forum_saved_place" (
242 "saved_place_id" integer DEFAULT nextval('forum_saved_place_pk_seq'::text) NOT NULL,
243 "user_id" integer DEFAULT '0' NOT NULL,
244 "forum_id" integer DEFAULT '0' NOT NULL,
245 "save_date" integer DEFAULT '0' NOT NULL,
246 Constraint "forum_saved_place_pkey" Primary Key ("saved_place_id")
250 -- TOC Entry ID 187 (OID 19230)
252 -- Name: foundry_data Type: TABLE Owner: tperdue
255 CREATE TABLE "foundry_data" (
256 "foundry_id" integer DEFAULT '0' NOT NULL,
257 "freeform1_html" text,
258 "freeform2_html" text,
259 "sponsor1_html" text,
260 "sponsor2_html" text,
261 "guide_image_id" integer DEFAULT '0' NOT NULL,
262 "logo_image_id" integer DEFAULT '0' NOT NULL,
263 "trove_categories" text,
264 Constraint "foundry_data_pkey" Primary Key ("foundry_id")
268 -- TOC Entry ID 22 (OID 19268)
270 -- Name: foundry_news_pk_seq Type: SEQUENCE Owner: tperdue
273 CREATE SEQUENCE "foundry_news_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
276 -- TOC Entry ID 188 (OID 19287)
278 -- Name: foundry_news Type: TABLE Owner: tperdue
281 CREATE TABLE "foundry_news" (
282 "foundry_news_id" integer DEFAULT nextval('foundry_news_pk_seq'::text) NOT NULL,
283 "foundry_id" integer DEFAULT '0' NOT NULL,
284 "news_id" integer DEFAULT '0' NOT NULL,
285 "approve_date" integer DEFAULT '0' NOT NULL,
286 "is_approved" integer DEFAULT '0' NOT NULL,
287 Constraint "foundry_news_pkey" Primary Key ("foundry_news_id")
291 -- TOC Entry ID 24 (OID 19309)
293 -- Name: foundry_preferred_projec_pk_seq Type: SEQUENCE Owner: tperdue
296 CREATE SEQUENCE "foundry_preferred_projec_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
299 -- TOC Entry ID 189 (OID 19328)
301 -- Name: foundry_preferred_projects Type: TABLE Owner: tperdue
304 CREATE TABLE "foundry_preferred_projects" (
305 "foundry_project_id" integer DEFAULT nextval('foundry_preferred_projec_pk_seq'::text) NOT NULL,
306 "foundry_id" integer DEFAULT '0' NOT NULL,
307 "group_id" integer DEFAULT '0' NOT NULL,
308 "rank" integer DEFAULT '0' NOT NULL,
309 Constraint "foundry_preferred_projects_pkey" Primary Key ("foundry_project_id")
313 -- TOC Entry ID 26 (OID 19348)
315 -- Name: foundry_projects_pk_seq Type: SEQUENCE Owner: tperdue
318 CREATE SEQUENCE "foundry_projects_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
321 -- TOC Entry ID 190 (OID 19367)
323 -- Name: foundry_projects Type: TABLE Owner: tperdue
326 CREATE TABLE "foundry_projects" (
327 "id" integer DEFAULT nextval('foundry_projects_pk_seq'::text) NOT NULL,
328 "foundry_id" integer DEFAULT '0' NOT NULL,
329 "project_id" integer DEFAULT '0' NOT NULL,
330 Constraint "foundry_projects_pkey" Primary Key ("id")
334 -- TOC Entry ID 28 (OID 19385)
336 -- Name: frs_file_pk_seq Type: SEQUENCE Owner: tperdue
339 CREATE SEQUENCE "frs_file_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
342 -- TOC Entry ID 191 (OID 19404)
344 -- Name: frs_file Type: TABLE Owner: tperdue
347 CREATE TABLE "frs_file" (
348 "file_id" integer DEFAULT nextval('frs_file_pk_seq'::text) NOT NULL,
350 "release_id" integer DEFAULT '0' NOT NULL,
351 "type_id" integer DEFAULT '0' NOT NULL,
352 "processor_id" integer DEFAULT '0' NOT NULL,
353 "release_time" integer DEFAULT '0' NOT NULL,
354 "file_size" integer DEFAULT '0' NOT NULL,
355 "post_date" integer DEFAULT '0' NOT NULL,
356 Constraint "frs_file_pkey" Primary Key ("file_id")
360 -- TOC Entry ID 30 (OID 19446)
362 -- Name: frs_filetype_pk_seq Type: SEQUENCE Owner: tperdue
365 CREATE SEQUENCE "frs_filetype_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
368 -- TOC Entry ID 192 (OID 19465)
370 -- Name: frs_filetype Type: TABLE Owner: tperdue
373 CREATE TABLE "frs_filetype" (
374 "type_id" integer DEFAULT nextval('frs_filetype_pk_seq'::text) NOT NULL,
376 Constraint "frs_filetype_pkey" Primary Key ("type_id")
380 -- TOC Entry ID 32 (OID 19495)
382 -- Name: frs_package_pk_seq Type: SEQUENCE Owner: tperdue
385 CREATE SEQUENCE "frs_package_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
388 -- TOC Entry ID 193 (OID 19514)
390 -- Name: frs_package Type: TABLE Owner: tperdue
393 CREATE TABLE "frs_package" (
394 "package_id" integer DEFAULT nextval('frs_package_pk_seq'::text) NOT NULL,
395 "group_id" integer DEFAULT '0' NOT NULL,
397 "status_id" integer DEFAULT '0' NOT NULL,
398 Constraint "frs_package_pkey" Primary Key ("package_id")
402 -- TOC Entry ID 34 (OID 19548)
404 -- Name: frs_processor_pk_seq Type: SEQUENCE Owner: tperdue
407 CREATE SEQUENCE "frs_processor_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
410 -- TOC Entry ID 194 (OID 19567)
412 -- Name: frs_processor Type: TABLE Owner: tperdue
415 CREATE TABLE "frs_processor" (
416 "processor_id" integer DEFAULT nextval('frs_processor_pk_seq'::text) NOT NULL,
418 Constraint "frs_processor_pkey" Primary Key ("processor_id")
422 -- TOC Entry ID 36 (OID 19597)
424 -- Name: frs_release_pk_seq Type: SEQUENCE Owner: tperdue
427 CREATE SEQUENCE "frs_release_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
430 -- TOC Entry ID 195 (OID 19616)
432 -- Name: frs_release Type: TABLE Owner: tperdue
435 CREATE TABLE "frs_release" (
436 "release_id" integer DEFAULT nextval('frs_release_pk_seq'::text) NOT NULL,
437 "package_id" integer DEFAULT '0' NOT NULL,
441 "status_id" integer DEFAULT '0' NOT NULL,
442 "preformatted" integer DEFAULT '0' NOT NULL,
443 "release_date" integer DEFAULT '0' NOT NULL,
444 "released_by" integer DEFAULT '0' NOT NULL,
445 Constraint "frs_release_pkey" Primary Key ("release_id")
449 -- TOC Entry ID 38 (OID 19658)
451 -- Name: frs_status_pk_seq Type: SEQUENCE Owner: tperdue
454 CREATE SEQUENCE "frs_status_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
457 -- TOC Entry ID 196 (OID 19677)
459 -- Name: frs_status Type: TABLE Owner: tperdue
462 CREATE TABLE "frs_status" (
463 "status_id" integer DEFAULT nextval('frs_status_pk_seq'::text) NOT NULL,
465 Constraint "frs_status_pkey" Primary Key ("status_id")
469 -- TOC Entry ID 40 (OID 19707)
471 -- Name: group_cvs_history_pk_seq Type: SEQUENCE Owner: tperdue
474 CREATE SEQUENCE "group_cvs_history_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
477 -- TOC Entry ID 42 (OID 19726)
479 -- Name: group_history_pk_seq Type: SEQUENCE Owner: tperdue
482 CREATE SEQUENCE "group_history_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
485 -- TOC Entry ID 197 (OID 19745)
487 -- Name: group_history Type: TABLE Owner: tperdue
490 CREATE TABLE "group_history" (
491 "group_history_id" integer DEFAULT nextval('group_history_pk_seq'::text) NOT NULL,
492 "group_id" integer DEFAULT '0' NOT NULL,
493 "field_name" text DEFAULT '' NOT NULL,
494 "old_value" text DEFAULT '' NOT NULL,
495 "mod_by" integer DEFAULT '0' NOT NULL,
497 Constraint "group_history_pkey" Primary Key ("group_history_id")
501 -- TOC Entry ID 44 (OID 19783)
503 -- Name: group_type_pk_seq Type: SEQUENCE Owner: tperdue
506 CREATE SEQUENCE "group_type_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
509 -- TOC Entry ID 198 (OID 19802)
511 -- Name: group_type Type: TABLE Owner: tperdue
514 CREATE TABLE "group_type" (
515 "type_id" integer DEFAULT nextval('group_type_pk_seq'::text) NOT NULL,
517 Constraint "group_type_pkey" Primary Key ("type_id")
521 -- TOC Entry ID 46 (OID 19832)
523 -- Name: groups_pk_seq Type: SEQUENCE Owner: tperdue
526 CREATE SEQUENCE "groups_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
529 -- TOC Entry ID 199 (OID 19851)
531 -- Name: groups Type: TABLE Owner: tperdue
534 CREATE TABLE "groups" (
535 "group_id" integer DEFAULT nextval('groups_pk_seq'::text) NOT NULL,
536 "group_name" character varying(40),
537 "homepage" character varying(128),
538 "is_public" integer DEFAULT '0' NOT NULL,
539 "status" character(1) DEFAULT 'A' NOT NULL,
540 "unix_group_name" character varying(30) DEFAULT '' NOT NULL,
541 "unix_box" character varying(20) DEFAULT 'shell1' NOT NULL,
542 "http_domain" character varying(80),
543 "short_description" character varying(255),
544 "cvs_box" character varying(20) DEFAULT 'cvs1' NOT NULL,
545 "license" character varying(16),
546 "register_purpose" text,
547 "license_other" text,
548 "register_time" integer DEFAULT '0' NOT NULL,
550 "use_mail" integer DEFAULT '1' NOT NULL,
551 "use_survey" integer DEFAULT '1' NOT NULL,
552 "use_forum" integer DEFAULT '1' NOT NULL,
553 "use_pm" integer DEFAULT '1' NOT NULL,
554 "use_cvs" integer DEFAULT '1' NOT NULL,
555 "use_news" integer DEFAULT '1' NOT NULL,
556 "type" integer DEFAULT '1' NOT NULL,
557 "use_docman" integer DEFAULT '1' NOT NULL,
558 "new_task_address" text DEFAULT '' NOT NULL,
559 "send_all_tasks" integer DEFAULT '0' NOT NULL,
560 "use_pm_depend_box" integer DEFAULT '1' NOT NULL,
561 Constraint "groups_pkey" Primary Key ("group_id")
565 -- TOC Entry ID 48 (OID 19977)
567 -- Name: mail_group_list_pk_seq Type: SEQUENCE Owner: tperdue
570 CREATE SEQUENCE "mail_group_list_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
573 -- TOC Entry ID 201 (OID 19996)
575 -- Name: mail_group_list Type: TABLE Owner: tperdue
578 CREATE TABLE "mail_group_list" (
579 "group_list_id" integer DEFAULT nextval('mail_group_list_pk_seq'::text) NOT NULL,
580 "group_id" integer DEFAULT '0' NOT NULL,
582 "is_public" integer DEFAULT '0' NOT NULL,
583 "password" character varying(16),
584 "list_admin" integer DEFAULT '0' NOT NULL,
585 "status" integer DEFAULT '0' NOT NULL,
587 Constraint "mail_group_list_pkey" Primary Key ("group_list_id")
591 -- TOC Entry ID 50 (OID 20036)
593 -- Name: news_bytes_pk_seq Type: SEQUENCE Owner: tperdue
596 CREATE SEQUENCE "news_bytes_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
599 -- TOC Entry ID 202 (OID 20055)
601 -- Name: news_bytes Type: TABLE Owner: tperdue
604 CREATE TABLE "news_bytes" (
605 "id" integer DEFAULT nextval('news_bytes_pk_seq'::text) NOT NULL,
606 "group_id" integer DEFAULT '0' NOT NULL,
607 "submitted_by" integer DEFAULT '0' NOT NULL,
608 "is_approved" integer DEFAULT '0' NOT NULL,
609 "date" integer DEFAULT '0' NOT NULL,
610 "forum_id" integer DEFAULT '0' NOT NULL,
613 Constraint "news_bytes_pkey" Primary Key ("id")
617 -- TOC Entry ID 52 (OID 20096)
619 -- Name: people_job_pk_seq Type: SEQUENCE Owner: tperdue
622 CREATE SEQUENCE "people_job_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
625 -- TOC Entry ID 203 (OID 20115)
627 -- Name: people_job Type: TABLE Owner: tperdue
630 CREATE TABLE "people_job" (
631 "job_id" integer DEFAULT nextval('people_job_pk_seq'::text) NOT NULL,
632 "group_id" integer DEFAULT '0' NOT NULL,
633 "created_by" integer DEFAULT '0' NOT NULL,
636 "date" integer DEFAULT '0' NOT NULL,
637 "status_id" integer DEFAULT '0' NOT NULL,
638 "category_id" integer DEFAULT '0' NOT NULL,
639 Constraint "people_job_pkey" Primary Key ("job_id")
643 -- TOC Entry ID 54 (OID 20156)
645 -- Name: people_job_category_pk_seq Type: SEQUENCE Owner: tperdue
648 CREATE SEQUENCE "people_job_category_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
651 -- TOC Entry ID 204 (OID 20175)
653 -- Name: people_job_category Type: TABLE Owner: tperdue
656 CREATE TABLE "people_job_category" (
657 "category_id" integer DEFAULT nextval('people_job_category_pk_seq'::text) NOT NULL,
659 "private_flag" integer DEFAULT '0' NOT NULL,
660 Constraint "people_job_category_pkey" Primary Key ("category_id")
664 -- TOC Entry ID 56 (OID 20207)
666 -- Name: people_job_inventory_pk_seq Type: SEQUENCE Owner: tperdue
669 CREATE SEQUENCE "people_job_inventory_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
672 -- TOC Entry ID 205 (OID 20226)
674 -- Name: people_job_inventory Type: TABLE Owner: tperdue
677 CREATE TABLE "people_job_inventory" (
678 "job_inventory_id" integer DEFAULT nextval('people_job_inventory_pk_seq'::text) NOT NULL,
679 "job_id" integer DEFAULT '0' NOT NULL,
680 "skill_id" integer DEFAULT '0' NOT NULL,
681 "skill_level_id" integer DEFAULT '0' NOT NULL,
682 "skill_year_id" integer DEFAULT '0' NOT NULL,
683 Constraint "people_job_inventory_pkey" Primary Key ("job_inventory_id")
687 -- TOC Entry ID 58 (OID 20248)
689 -- Name: people_job_status_pk_seq Type: SEQUENCE Owner: tperdue
692 CREATE SEQUENCE "people_job_status_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
695 -- TOC Entry ID 206 (OID 20267)
697 -- Name: people_job_status Type: TABLE Owner: tperdue
700 CREATE TABLE "people_job_status" (
701 "status_id" integer DEFAULT nextval('people_job_status_pk_seq'::text) NOT NULL,
703 Constraint "people_job_status_pkey" Primary Key ("status_id")
707 -- TOC Entry ID 60 (OID 20297)
709 -- Name: people_skill_pk_seq Type: SEQUENCE Owner: tperdue
712 CREATE SEQUENCE "people_skill_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
715 -- TOC Entry ID 207 (OID 20316)
717 -- Name: people_skill Type: TABLE Owner: tperdue
720 CREATE TABLE "people_skill" (
721 "skill_id" integer DEFAULT nextval('people_skill_pk_seq'::text) NOT NULL,
723 Constraint "people_skill_pkey" Primary Key ("skill_id")
727 -- TOC Entry ID 62 (OID 20346)
729 -- Name: people_skill_inventory_pk_seq Type: SEQUENCE Owner: tperdue
732 CREATE SEQUENCE "people_skill_inventory_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
735 -- TOC Entry ID 208 (OID 20365)
737 -- Name: people_skill_inventory Type: TABLE Owner: tperdue
740 CREATE TABLE "people_skill_inventory" (
741 "skill_inventory_id" integer DEFAULT nextval('people_skill_inventory_pk_seq'::text) NOT NULL,
742 "user_id" integer DEFAULT '0' NOT NULL,
743 "skill_id" integer DEFAULT '0' NOT NULL,
744 "skill_level_id" integer DEFAULT '0' NOT NULL,
745 "skill_year_id" integer DEFAULT '0' NOT NULL,
746 Constraint "people_skill_inventory_pkey" Primary Key ("skill_inventory_id")
750 -- TOC Entry ID 64 (OID 20387)
752 -- Name: people_skill_level_pk_seq Type: SEQUENCE Owner: tperdue
755 CREATE SEQUENCE "people_skill_level_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
758 -- TOC Entry ID 209 (OID 20406)
760 -- Name: people_skill_level Type: TABLE Owner: tperdue
763 CREATE TABLE "people_skill_level" (
764 "skill_level_id" integer DEFAULT nextval('people_skill_level_pk_seq'::text) NOT NULL,
766 Constraint "people_skill_level_pkey" Primary Key ("skill_level_id")
770 -- TOC Entry ID 66 (OID 20436)
772 -- Name: people_skill_year_pk_seq Type: SEQUENCE Owner: tperdue
775 CREATE SEQUENCE "people_skill_year_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
778 -- TOC Entry ID 210 (OID 20455)
780 -- Name: people_skill_year Type: TABLE Owner: tperdue
783 CREATE TABLE "people_skill_year" (
784 "skill_year_id" integer DEFAULT nextval('people_skill_year_pk_seq'::text) NOT NULL,
786 Constraint "people_skill_year_pkey" Primary Key ("skill_year_id")
790 -- TOC Entry ID 68 (OID 20485)
792 -- Name: project_assigned_to_pk_seq Type: SEQUENCE Owner: tperdue
795 CREATE SEQUENCE "project_assigned_to_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
798 -- TOC Entry ID 211 (OID 20504)
800 -- Name: project_assigned_to Type: TABLE Owner: tperdue
803 CREATE TABLE "project_assigned_to" (
804 "project_assigned_id" integer DEFAULT nextval('project_assigned_to_pk_seq'::text) NOT NULL,
805 "project_task_id" integer DEFAULT '0' NOT NULL,
806 "assigned_to_id" integer DEFAULT '0' NOT NULL,
807 Constraint "project_assigned_to_pkey" Primary Key ("project_assigned_id")
811 -- TOC Entry ID 70 (OID 20522)
813 -- Name: project_dependencies_pk_seq Type: SEQUENCE Owner: tperdue
816 CREATE SEQUENCE "project_dependencies_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
819 -- TOC Entry ID 212 (OID 20541)
821 -- Name: project_dependencies Type: TABLE Owner: tperdue
824 CREATE TABLE "project_dependencies" (
825 "project_depend_id" integer DEFAULT nextval('project_dependencies_pk_seq'::text) NOT NULL,
826 "project_task_id" integer DEFAULT '0' NOT NULL,
827 "is_dependent_on_task_id" integer DEFAULT '0' NOT NULL,
828 Constraint "project_dependencies_pkey" Primary Key ("project_depend_id")
832 -- TOC Entry ID 72 (OID 20559)
834 -- Name: project_group_list_pk_seq Type: SEQUENCE Owner: tperdue
837 CREATE SEQUENCE "project_group_list_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
840 -- TOC Entry ID 213 (OID 20578)
842 -- Name: project_group_list Type: TABLE Owner: tperdue
845 CREATE TABLE "project_group_list" (
846 "group_project_id" integer DEFAULT nextval('project_group_list_pk_seq'::text) NOT NULL,
847 "group_id" integer DEFAULT '0' NOT NULL,
848 "project_name" text DEFAULT '' NOT NULL,
849 "is_public" integer DEFAULT '0' NOT NULL,
851 Constraint "project_group_list_pkey" Primary Key ("group_project_id")
855 -- TOC Entry ID 74 (OID 20614)
857 -- Name: project_history_pk_seq Type: SEQUENCE Owner: tperdue
860 CREATE SEQUENCE "project_history_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
863 -- TOC Entry ID 214 (OID 20633)
865 -- Name: project_history Type: TABLE Owner: tperdue
868 CREATE TABLE "project_history" (
869 "project_history_id" integer DEFAULT nextval('project_history_pk_seq'::text) NOT NULL,
870 "project_task_id" integer DEFAULT '0' NOT NULL,
871 "field_name" text DEFAULT '' NOT NULL,
872 "old_value" text DEFAULT '' NOT NULL,
873 "mod_by" integer DEFAULT '0' NOT NULL,
874 "date" integer DEFAULT '0' NOT NULL,
875 Constraint "project_history_pkey" Primary Key ("project_history_id")
879 -- TOC Entry ID 76 (OID 20672)
881 -- Name: project_metric_pk_seq Type: SEQUENCE Owner: tperdue
884 CREATE SEQUENCE "project_metric_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
887 -- TOC Entry ID 215 (OID 20691)
889 -- Name: project_metric Type: TABLE Owner: tperdue
892 CREATE TABLE "project_metric" (
893 "ranking" integer DEFAULT nextval('project_metric_pk_seq'::text) NOT NULL,
894 "percentile" double precision,
895 "group_id" integer DEFAULT '0' NOT NULL,
896 Constraint "project_metric_pkey" Primary Key ("ranking")
900 -- TOC Entry ID 78 (OID 20708)
902 -- Name: project_metric_tmp1_pk_seq Type: SEQUENCE Owner: tperdue
905 CREATE SEQUENCE "project_metric_tmp1_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
908 -- TOC Entry ID 216 (OID 20727)
910 -- Name: project_metric_tmp1 Type: TABLE Owner: tperdue
913 CREATE TABLE "project_metric_tmp1" (
914 "ranking" integer DEFAULT nextval('project_metric_tmp1_pk_seq'::text) NOT NULL,
915 "group_id" integer DEFAULT '0' NOT NULL,
916 "value" double precision,
917 Constraint "project_metric_tmp1_pkey" Primary Key ("ranking")
921 -- TOC Entry ID 80 (OID 20744)
923 -- Name: project_metric_weekly_tm_pk_seq Type: SEQUENCE Owner: tperdue
926 CREATE SEQUENCE "project_metric_weekly_tm_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
929 -- TOC Entry ID 82 (OID 20763)
931 -- Name: project_status_pk_seq Type: SEQUENCE Owner: tperdue
934 CREATE SEQUENCE "project_status_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
937 -- TOC Entry ID 217 (OID 20782)
939 -- Name: project_status Type: TABLE Owner: tperdue
942 CREATE TABLE "project_status" (
943 "status_id" integer DEFAULT nextval('project_status_pk_seq'::text) NOT NULL,
944 "status_name" text DEFAULT '' NOT NULL,
945 Constraint "project_status_pkey" Primary Key ("status_id")
949 -- TOC Entry ID 84 (OID 20813)
951 -- Name: project_task_pk_seq Type: SEQUENCE Owner: tperdue
954 CREATE SEQUENCE "project_task_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
957 -- TOC Entry ID 218 (OID 20832)
959 -- Name: project_task Type: TABLE Owner: tperdue
962 CREATE TABLE "project_task" (
963 "project_task_id" integer DEFAULT nextval('project_task_pk_seq'::text) NOT NULL,
964 "group_project_id" integer DEFAULT '0' NOT NULL,
965 "summary" text DEFAULT '' NOT NULL,
966 "details" text DEFAULT '' NOT NULL,
967 "percent_complete" integer DEFAULT '0' NOT NULL,
968 "priority" integer DEFAULT '0' NOT NULL,
969 "hours" double precision DEFAULT '0.00' NOT NULL,
970 "start_date" integer DEFAULT '0' NOT NULL,
971 "end_date" integer DEFAULT '0' NOT NULL,
972 "created_by" integer DEFAULT '0' NOT NULL,
973 "status_id" integer DEFAULT '0' NOT NULL,
974 Constraint "project_task_pkey" Primary Key ("project_task_id")
978 -- TOC Entry ID 86 (OID 20881)
980 -- Name: project_weekly_metric_pk_seq Type: SEQUENCE Owner: tperdue
983 CREATE SEQUENCE "project_weekly_metric_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
986 -- TOC Entry ID 219 (OID 20900)
988 -- Name: project_weekly_metric Type: TABLE Owner: tperdue
991 CREATE TABLE "project_weekly_metric" (
992 "ranking" integer DEFAULT nextval('project_weekly_metric_pk_seq'::text) NOT NULL,
993 "percentile" double precision,
994 "group_id" integer DEFAULT '0' NOT NULL
998 -- TOC Entry ID 220 (OID 20914)
1000 -- Name: session Type: TABLE Owner: tperdue
1003 CREATE TABLE "session" (
1004 "user_id" integer DEFAULT '0' NOT NULL,
1005 "session_hash" character(32) DEFAULT '' NOT NULL,
1006 "ip_addr" character(15) DEFAULT '' NOT NULL,
1007 "time" integer DEFAULT '0' NOT NULL,
1008 Constraint "session_pkey" Primary Key ("session_hash")
1012 -- TOC Entry ID 88 (OID 20934)
1014 -- Name: snippet_pk_seq Type: SEQUENCE Owner: tperdue
1017 CREATE SEQUENCE "snippet_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1020 -- TOC Entry ID 221 (OID 20953)
1022 -- Name: snippet Type: TABLE Owner: tperdue
1025 CREATE TABLE "snippet" (
1026 "snippet_id" integer DEFAULT nextval('snippet_pk_seq'::text) NOT NULL,
1027 "created_by" integer DEFAULT '0' NOT NULL,
1030 "type" integer DEFAULT '0' NOT NULL,
1031 "language" integer DEFAULT '0' NOT NULL,
1032 "license" text DEFAULT '' NOT NULL,
1033 "category" integer DEFAULT '0' NOT NULL,
1034 Constraint "snippet_pkey" Primary Key ("snippet_id")
1038 -- TOC Entry ID 90 (OID 20994)
1040 -- Name: snippet_package_pk_seq Type: SEQUENCE Owner: tperdue
1043 CREATE SEQUENCE "snippet_package_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1046 -- TOC Entry ID 222 (OID 21013)
1048 -- Name: snippet_package Type: TABLE Owner: tperdue
1051 CREATE TABLE "snippet_package" (
1052 "snippet_package_id" integer DEFAULT nextval('snippet_package_pk_seq'::text) NOT NULL,
1053 "created_by" integer DEFAULT '0' NOT NULL,
1056 "category" integer DEFAULT '0' NOT NULL,
1057 "language" integer DEFAULT '0' NOT NULL,
1058 Constraint "snippet_package_pkey" Primary Key ("snippet_package_id")
1062 -- TOC Entry ID 92 (OID 21050)
1064 -- Name: snippet_package_item_pk_seq Type: SEQUENCE Owner: tperdue
1067 CREATE SEQUENCE "snippet_package_item_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1070 -- TOC Entry ID 223 (OID 21069)
1072 -- Name: snippet_package_item Type: TABLE Owner: tperdue
1075 CREATE TABLE "snippet_package_item" (
1076 "snippet_package_item_id" integer DEFAULT nextval('snippet_package_item_pk_seq'::text) NOT NULL,
1077 "snippet_package_version_id" integer DEFAULT '0' NOT NULL,
1078 "snippet_version_id" integer DEFAULT '0' NOT NULL,
1079 Constraint "snippet_package_item_pkey" Primary Key ("snippet_package_item_id")
1083 -- TOC Entry ID 94 (OID 21087)
1085 -- Name: snippet_package_version_pk_seq Type: SEQUENCE Owner: tperdue
1088 CREATE SEQUENCE "snippet_package_version_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1091 -- TOC Entry ID 224 (OID 21106)
1093 -- Name: snippet_package_version Type: TABLE Owner: tperdue
1096 CREATE TABLE "snippet_package_version" (
1097 "snippet_package_version_id" integer DEFAULT nextval('snippet_package_version_pk_seq'::text) NOT NULL,
1098 "snippet_package_id" integer DEFAULT '0' NOT NULL,
1101 "submitted_by" integer DEFAULT '0' NOT NULL,
1102 "date" integer DEFAULT '0' NOT NULL,
1103 Constraint "snippet_package_version_pkey" Primary Key ("snippet_package_version_id")
1107 -- TOC Entry ID 96 (OID 21143)
1109 -- Name: snippet_version_pk_seq Type: SEQUENCE Owner: tperdue
1112 CREATE SEQUENCE "snippet_version_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1115 -- TOC Entry ID 225 (OID 21162)
1117 -- Name: snippet_version Type: TABLE Owner: tperdue
1120 CREATE TABLE "snippet_version" (
1121 "snippet_version_id" integer DEFAULT nextval('snippet_version_pk_seq'::text) NOT NULL,
1122 "snippet_id" integer DEFAULT '0' NOT NULL,
1125 "submitted_by" integer DEFAULT '0' NOT NULL,
1126 "date" integer DEFAULT '0' NOT NULL,
1128 Constraint "snippet_version_pkey" Primary Key ("snippet_version_id")
1132 -- TOC Entry ID 226 (OID 21200)
1134 -- Name: stats_agg_logo_by_day Type: TABLE Owner: tperdue
1137 CREATE TABLE "stats_agg_logo_by_day" (
1143 -- TOC Entry ID 227 (OID 21211)
1145 -- Name: stats_agg_pages_by_day Type: TABLE Owner: tperdue
1148 CREATE TABLE "stats_agg_pages_by_day" (
1149 "day" integer DEFAULT '0' NOT NULL,
1150 "count" integer DEFAULT '0' NOT NULL
1154 -- TOC Entry ID 228 (OID 21224)
1156 -- Name: stats_ftp_downloads Type: TABLE Owner: tperdue
1159 CREATE TABLE "stats_ftp_downloads" (
1160 "day" integer DEFAULT '0' NOT NULL,
1161 "filerelease_id" integer DEFAULT '0' NOT NULL,
1162 "group_id" integer DEFAULT '0' NOT NULL,
1163 "downloads" integer DEFAULT '0' NOT NULL
1167 -- TOC Entry ID 229 (OID 21241)
1169 -- Name: stats_http_downloads Type: TABLE Owner: tperdue
1172 CREATE TABLE "stats_http_downloads" (
1173 "day" integer DEFAULT '0' NOT NULL,
1174 "filerelease_id" integer DEFAULT '0' NOT NULL,
1175 "group_id" integer DEFAULT '0' NOT NULL,
1176 "downloads" integer DEFAULT '0' NOT NULL
1180 -- TOC Entry ID 98 (OID 21258)
1182 -- Name: supported_languages_pk_seq Type: SEQUENCE Owner: tperdue
1185 CREATE SEQUENCE "supported_languages_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1188 -- TOC Entry ID 230 (OID 21277)
1190 -- Name: supported_languages Type: TABLE Owner: tperdue
1193 CREATE TABLE "supported_languages" (
1194 "language_id" integer DEFAULT nextval('supported_languages_pk_seq'::text) NOT NULL,
1198 "language_code" character(2),
1199 Constraint "supported_languages_pkey" Primary Key ("language_id")
1203 -- TOC Entry ID 100 (OID 21310)
1205 -- Name: survey_question_types_pk_seq Type: SEQUENCE Owner: tperdue
1208 CREATE SEQUENCE "survey_question_types_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1211 -- TOC Entry ID 231 (OID 21329)
1213 -- Name: survey_question_types Type: TABLE Owner: tperdue
1216 CREATE TABLE "survey_question_types" (
1217 "id" integer DEFAULT nextval('survey_question_types_pk_seq'::text) NOT NULL,
1218 "type" text DEFAULT '' NOT NULL,
1219 Constraint "survey_question_types_pkey" Primary Key ("id")
1223 -- TOC Entry ID 102 (OID 21360)
1225 -- Name: survey_questions_pk_seq Type: SEQUENCE Owner: tperdue
1228 CREATE SEQUENCE "survey_questions_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1231 -- TOC Entry ID 232 (OID 21379)
1233 -- Name: survey_questions Type: TABLE Owner: tperdue
1236 CREATE TABLE "survey_questions" (
1237 "question_id" integer DEFAULT nextval('survey_questions_pk_seq'::text) NOT NULL,
1238 "group_id" integer DEFAULT '0' NOT NULL,
1239 "question" text DEFAULT '' NOT NULL,
1240 "question_type" integer DEFAULT '0' NOT NULL,
1241 Constraint "survey_questions_pkey" Primary Key ("question_id")
1245 -- TOC Entry ID 233 (OID 21414)
1247 -- Name: survey_rating_aggregate Type: TABLE Owner: tperdue
1250 CREATE TABLE "survey_rating_aggregate" (
1251 "type" integer DEFAULT '0' NOT NULL,
1252 "id" integer DEFAULT '0' NOT NULL,
1253 "response" double precision DEFAULT '0' NOT NULL,
1254 "count" integer DEFAULT '0' NOT NULL
1258 -- TOC Entry ID 234 (OID 21431)
1260 -- Name: survey_rating_response Type: TABLE Owner: tperdue
1263 CREATE TABLE "survey_rating_response" (
1264 "user_id" integer DEFAULT '0' NOT NULL,
1265 "type" integer DEFAULT '0' NOT NULL,
1266 "id" integer DEFAULT '0' NOT NULL,
1267 "response" integer DEFAULT '0' NOT NULL,
1268 "date" integer DEFAULT '0' NOT NULL
1272 -- TOC Entry ID 235 (OID 21450)
1274 -- Name: survey_responses Type: TABLE Owner: tperdue
1277 CREATE TABLE "survey_responses" (
1278 "user_id" integer DEFAULT '0' NOT NULL,
1279 "group_id" integer DEFAULT '0' NOT NULL,
1280 "survey_id" integer DEFAULT '0' NOT NULL,
1281 "question_id" integer DEFAULT '0' NOT NULL,
1282 "response" text DEFAULT '' NOT NULL,
1283 "date" integer DEFAULT '0' NOT NULL
1287 -- TOC Entry ID 104 (OID 21486)
1289 -- Name: surveys_pk_seq Type: SEQUENCE Owner: tperdue
1292 CREATE SEQUENCE "surveys_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1295 -- TOC Entry ID 236 (OID 21505)
1297 -- Name: surveys Type: TABLE Owner: tperdue
1300 CREATE TABLE "surveys" (
1301 "survey_id" integer DEFAULT nextval('surveys_pk_seq'::text) NOT NULL,
1302 "group_id" integer DEFAULT '0' NOT NULL,
1303 "survey_title" text DEFAULT '' NOT NULL,
1304 "survey_questions" text DEFAULT '' NOT NULL,
1305 "is_active" integer DEFAULT '1' NOT NULL,
1306 Constraint "surveys_pkey" Primary Key ("survey_id")
1310 -- TOC Entry ID 106 (OID 21542)
1312 -- Name: system_history_pk_seq Type: SEQUENCE Owner: tperdue
1315 CREATE SEQUENCE "system_history_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1318 -- TOC Entry ID 108 (OID 21561)
1320 -- Name: system_machines_pk_seq Type: SEQUENCE Owner: tperdue
1323 CREATE SEQUENCE "system_machines_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1326 -- TOC Entry ID 110 (OID 21580)
1328 -- Name: system_news_pk_seq Type: SEQUENCE Owner: tperdue
1331 CREATE SEQUENCE "system_news_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1334 -- TOC Entry ID 112 (OID 21599)
1336 -- Name: system_services_pk_seq Type: SEQUENCE Owner: tperdue
1339 CREATE SEQUENCE "system_services_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1342 -- TOC Entry ID 114 (OID 21618)
1344 -- Name: system_status_pk_seq Type: SEQUENCE Owner: tperdue
1347 CREATE SEQUENCE "system_status_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1350 -- TOC Entry ID 237 (OID 21637)
1352 -- Name: theme_prefs Type: TABLE Owner: tperdue
1355 CREATE TABLE "theme_prefs" (
1356 "user_id" integer DEFAULT '0' NOT NULL,
1357 "user_theme" integer DEFAULT '0' NOT NULL,
1358 "body_font" character(80) DEFAULT '',
1359 "body_size" character(5) DEFAULT '',
1360 "titlebar_font" character(80) DEFAULT '',
1361 "titlebar_size" character(5) DEFAULT '',
1362 "color_titlebar_back" character(7) DEFAULT '',
1363 "color_ltback1" character(7) DEFAULT '',
1364 Constraint "theme_prefs_pkey" Primary Key ("user_id")
1368 -- TOC Entry ID 116 (OID 21665)
1370 -- Name: themes_pk_seq Type: SEQUENCE Owner: tperdue
1373 CREATE SEQUENCE "themes_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1376 -- TOC Entry ID 238 (OID 21684)
1378 -- Name: themes Type: TABLE Owner: tperdue
1381 CREATE TABLE "themes" (
1382 "theme_id" integer DEFAULT nextval('themes_pk_seq'::text) NOT NULL,
1383 "dirname" character varying(80),
1384 "fullname" character varying(80),
1385 Constraint "themes_pkey" Primary Key ("theme_id")
1389 -- TOC Entry ID 239 (OID 21700)
1391 -- Name: top_group Type: TABLE Owner: tperdue
1394 CREATE TABLE "top_group" (
1395 "group_id" integer DEFAULT '0' NOT NULL,
1396 "group_name" character varying(40),
1397 "downloads_all" integer DEFAULT '0' NOT NULL,
1398 "rank_downloads_all" integer DEFAULT '0' NOT NULL,
1399 "rank_downloads_all_old" integer DEFAULT '0' NOT NULL,
1400 "downloads_week" integer DEFAULT '0' NOT NULL,
1401 "rank_downloads_week" integer DEFAULT '0' NOT NULL,
1402 "rank_downloads_week_old" integer DEFAULT '0' NOT NULL,
1403 "userrank" integer DEFAULT '0' NOT NULL,
1404 "rank_userrank" integer DEFAULT '0' NOT NULL,
1405 "rank_userrank_old" integer DEFAULT '0' NOT NULL,
1406 "forumposts_week" integer DEFAULT '0' NOT NULL,
1407 "rank_forumposts_week" integer DEFAULT '0' NOT NULL,
1408 "rank_forumposts_week_old" integer DEFAULT '0' NOT NULL,
1409 "pageviews_proj" integer DEFAULT '0' NOT NULL,
1410 "rank_pageviews_proj" integer DEFAULT '0' NOT NULL,
1411 "rank_pageviews_proj_old" integer DEFAULT '0' NOT NULL
1415 -- TOC Entry ID 118 (OID 21742)
1417 -- Name: trove_cat_pk_seq Type: SEQUENCE Owner: tperdue
1420 CREATE SEQUENCE "trove_cat_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1423 -- TOC Entry ID 240 (OID 21761)
1425 -- Name: trove_cat Type: TABLE Owner: tperdue
1428 CREATE TABLE "trove_cat" (
1429 "trove_cat_id" integer DEFAULT nextval('trove_cat_pk_seq'::text) NOT NULL,
1430 "version" integer DEFAULT '0' NOT NULL,
1431 "parent" integer DEFAULT '0' NOT NULL,
1432 "root_parent" integer DEFAULT '0' NOT NULL,
1433 "shortname" character varying(80),
1434 "fullname" character varying(80),
1435 "description" character varying(255),
1436 "count_subcat" integer DEFAULT '0' NOT NULL,
1437 "count_subproj" integer DEFAULT '0' NOT NULL,
1438 "fullpath" text DEFAULT '' NOT NULL,
1439 "fullpath_ids" text,
1440 Constraint "trove_cat_pkey" Primary Key ("trove_cat_id")
1444 -- TOC Entry ID 120 (OID 21806)
1446 -- Name: trove_group_link_pk_seq Type: SEQUENCE Owner: tperdue
1449 CREATE SEQUENCE "trove_group_link_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1452 -- TOC Entry ID 241 (OID 21825)
1454 -- Name: trove_group_link Type: TABLE Owner: tperdue
1457 CREATE TABLE "trove_group_link" (
1458 "trove_group_id" integer DEFAULT nextval('trove_group_link_pk_seq'::text) NOT NULL,
1459 "trove_cat_id" integer DEFAULT '0' NOT NULL,
1460 "trove_cat_version" integer DEFAULT '0' NOT NULL,
1461 "group_id" integer DEFAULT '0' NOT NULL,
1462 "trove_cat_root" integer DEFAULT '0' NOT NULL,
1463 Constraint "trove_group_link_pkey" Primary Key ("trove_group_id")
1467 -- TOC Entry ID 122 (OID 21847)
1469 -- Name: trove_treesums_pk_seq Type: SEQUENCE Owner: tperdue
1472 CREATE SEQUENCE "trove_treesums_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1475 -- TOC Entry ID 124 (OID 21866)
1477 -- Name: user_bookmarks_pk_seq Type: SEQUENCE Owner: tperdue
1480 CREATE SEQUENCE "user_bookmarks_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1483 -- TOC Entry ID 242 (OID 21885)
1485 -- Name: user_bookmarks Type: TABLE Owner: tperdue
1488 CREATE TABLE "user_bookmarks" (
1489 "bookmark_id" integer DEFAULT nextval('user_bookmarks_pk_seq'::text) NOT NULL,
1490 "user_id" integer DEFAULT '0' NOT NULL,
1491 "bookmark_url" text,
1492 "bookmark_title" text,
1493 Constraint "user_bookmarks_pkey" Primary Key ("bookmark_id")
1497 -- TOC Entry ID 126 (OID 21918)
1499 -- Name: user_diary_pk_seq Type: SEQUENCE Owner: tperdue
1502 CREATE SEQUENCE "user_diary_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1505 -- TOC Entry ID 243 (OID 21937)
1507 -- Name: user_diary Type: TABLE Owner: tperdue
1510 CREATE TABLE "user_diary" (
1511 "id" integer DEFAULT nextval('user_diary_pk_seq'::text) NOT NULL,
1512 "user_id" integer DEFAULT '0' NOT NULL,
1513 "date_posted" integer DEFAULT '0' NOT NULL,
1516 "is_public" integer DEFAULT '0' NOT NULL,
1517 Constraint "user_diary_pkey" Primary Key ("id")
1521 -- TOC Entry ID 128 (OID 21974)
1523 -- Name: user_diary_monitor_pk_seq Type: SEQUENCE Owner: tperdue
1526 CREATE SEQUENCE "user_diary_monitor_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1529 -- TOC Entry ID 244 (OID 21993)
1531 -- Name: user_diary_monitor Type: TABLE Owner: tperdue
1534 CREATE TABLE "user_diary_monitor" (
1535 "monitor_id" integer DEFAULT nextval('user_diary_monitor_pk_seq'::text) NOT NULL,
1536 "monitored_user" integer DEFAULT '0' NOT NULL,
1537 "user_id" integer DEFAULT '0' NOT NULL,
1538 Constraint "user_diary_monitor_pkey" Primary Key ("monitor_id")
1542 -- TOC Entry ID 130 (OID 22011)
1544 -- Name: user_group_pk_seq Type: SEQUENCE Owner: tperdue
1547 CREATE SEQUENCE "user_group_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1550 -- TOC Entry ID 245 (OID 22030)
1552 -- Name: user_group Type: TABLE Owner: tperdue
1555 CREATE TABLE "user_group" (
1556 "user_group_id" integer DEFAULT nextval('user_group_pk_seq'::text) NOT NULL,
1557 "user_id" integer DEFAULT '0' NOT NULL,
1558 "group_id" integer DEFAULT '0' NOT NULL,
1559 "admin_flags" character(16) DEFAULT '' NOT NULL,
1560 "bug_flags" integer DEFAULT '0' NOT NULL,
1561 "forum_flags" integer DEFAULT '0' NOT NULL,
1562 "project_flags" integer DEFAULT '2' NOT NULL,
1563 "patch_flags" integer DEFAULT '1' NOT NULL,
1564 "support_flags" integer DEFAULT '1' NOT NULL,
1565 "doc_flags" integer DEFAULT '0' NOT NULL,
1566 "cvs_flags" integer DEFAULT '1' NOT NULL,
1567 "member_role" integer DEFAULT '100' NOT NULL,
1568 "release_flags" integer DEFAULT '0' NOT NULL,
1569 "artifact_flags" integer,
1570 Constraint "user_group_pkey" Primary Key ("user_group_id")
1574 -- TOC Entry ID 132 (OID 22069)
1576 -- Name: user_metric_pk_seq Type: SEQUENCE Owner: tperdue
1579 CREATE SEQUENCE "user_metric_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1582 -- TOC Entry ID 246 (OID 22088)
1584 -- Name: user_metric Type: TABLE Owner: tperdue
1587 CREATE TABLE "user_metric" (
1588 "ranking" integer DEFAULT nextval('user_metric_pk_seq'::text) NOT NULL,
1589 "user_id" integer DEFAULT '0' NOT NULL,
1590 "times_ranked" integer DEFAULT '0' NOT NULL,
1591 "avg_raters_importance" double precision DEFAULT '0.00000000' NOT NULL,
1592 "avg_rating" double precision DEFAULT '0.00000000' NOT NULL,
1593 "metric" double precision DEFAULT '0.00000000' NOT NULL,
1594 "percentile" double precision DEFAULT '0.00000000' NOT NULL,
1595 "importance_factor" double precision DEFAULT '0.00000000' NOT NULL,
1596 Constraint "user_metric_pkey" Primary Key ("ranking")
1600 -- TOC Entry ID 134 (OID 22116)
1602 -- Name: user_metric0_pk_seq Type: SEQUENCE Owner: tperdue
1605 CREATE SEQUENCE "user_metric0_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1608 -- TOC Entry ID 247 (OID 22135)
1610 -- Name: user_metric0 Type: TABLE Owner: tperdue
1613 CREATE TABLE "user_metric0" (
1614 "ranking" integer DEFAULT nextval('user_metric0_pk_seq'::text) NOT NULL,
1615 "user_id" integer DEFAULT '0' NOT NULL,
1616 "times_ranked" integer DEFAULT '0' NOT NULL,
1617 "avg_raters_importance" double precision DEFAULT '0.00000000' NOT NULL,
1618 "avg_rating" double precision DEFAULT '0.00000000' NOT NULL,
1619 "metric" double precision DEFAULT '0.00000000' NOT NULL,
1620 "percentile" double precision DEFAULT '0.00000000' NOT NULL,
1621 "importance_factor" double precision DEFAULT '0.00000000' NOT NULL,
1622 Constraint "user_metric0_pkey" Primary Key ("ranking")
1626 -- TOC Entry ID 248 (OID 22163)
1628 -- Name: user_preferences Type: TABLE Owner: tperdue
1631 CREATE TABLE "user_preferences" (
1632 "user_id" integer DEFAULT '0' NOT NULL,
1633 "preference_name" character varying(20),
1634 "dead1" character varying(20),
1635 "set_date" integer DEFAULT '0' NOT NULL,
1636 "preference_value" text
1640 -- TOC Entry ID 249 (OID 22194)
1642 -- Name: user_ratings Type: TABLE Owner: tperdue
1645 CREATE TABLE "user_ratings" (
1646 "rated_by" integer DEFAULT '0' NOT NULL,
1647 "user_id" integer DEFAULT '0' NOT NULL,
1648 "rate_field" integer DEFAULT '0' NOT NULL,
1649 "rating" integer DEFAULT '0' NOT NULL
1653 -- TOC Entry ID 136 (OID 22211)
1655 -- Name: users_pk_seq Type: SEQUENCE Owner: tperdue
1658 CREATE SEQUENCE "users_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1661 -- TOC Entry ID 250 (OID 22230)
1663 -- Name: users Type: TABLE Owner: tperdue
1666 CREATE TABLE "users" (
1667 "user_id" integer DEFAULT nextval('users_pk_seq'::text) NOT NULL,
1668 "user_name" text DEFAULT '' NOT NULL,
1669 "email" text DEFAULT '' NOT NULL,
1670 "user_pw" character varying(32) DEFAULT '' NOT NULL,
1671 "realname" character varying(32) DEFAULT '' NOT NULL,
1672 "status" character(1) DEFAULT 'A' NOT NULL,
1673 "shell" character varying(20) DEFAULT '/bin/bash' NOT NULL,
1674 "unix_pw" character varying(40) DEFAULT '' NOT NULL,
1675 "unix_status" character(1) DEFAULT 'N' NOT NULL,
1676 "unix_uid" integer DEFAULT '0' NOT NULL,
1677 "unix_box" character varying(10) DEFAULT 'shell1' NOT NULL,
1678 "add_date" integer DEFAULT '0' NOT NULL,
1679 "confirm_hash" character varying(32),
1680 "mail_siteupdates" integer DEFAULT '0' NOT NULL,
1681 "mail_va" integer DEFAULT '0' NOT NULL,
1682 "authorized_keys" text,
1684 "people_view_skills" integer DEFAULT '0' NOT NULL,
1685 "people_resume" text DEFAULT '' NOT NULL,
1686 "timezone" character varying(64) DEFAULT 'GMT',
1687 "language" integer DEFAULT '1' NOT NULL,
1688 "block_ratings" integer DEFAULT 0,
1689 Constraint "users_pkey" Primary Key ("user_id")
1693 -- TOC Entry ID 138 (OID 22298)
1695 -- Name: unix_uid_seq Type: SEQUENCE Owner: tperdue
1698 CREATE SEQUENCE "unix_uid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1701 -- TOC Entry ID 140 (OID 22317)
1703 -- Name: forum_thread_seq Type: SEQUENCE Owner: tperdue
1706 CREATE SEQUENCE "forum_thread_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1709 -- TOC Entry ID 251 (OID 22336)
1711 -- Name: project_sums_agg Type: TABLE Owner: tperdue
1714 CREATE TABLE "project_sums_agg" (
1715 "group_id" integer DEFAULT 0 NOT NULL,
1716 "type" character(4),
1717 "count" integer DEFAULT 0 NOT NULL
1721 -- TOC Entry ID 142 (OID 22350)
1723 -- Name: project_metric_wee_ranking1_seq Type: SEQUENCE Owner: tperdue
1726 CREATE SEQUENCE "project_metric_wee_ranking1_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1729 -- TOC Entry ID 144 (OID 22369)
1731 -- Name: prdb_dbs_dbid_seq Type: SEQUENCE Owner: tperdue
1734 CREATE SEQUENCE "prdb_dbs_dbid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1737 -- TOC Entry ID 252 (OID 22388)
1739 -- Name: prdb_dbs Type: TABLE Owner: tperdue
1742 CREATE TABLE "prdb_dbs" (
1743 "dbid" integer DEFAULT nextval('"prdb_dbs_dbid_seq"'::text) NOT NULL,
1744 "group_id" integer NOT NULL,
1745 "dbname" text NOT NULL,
1746 "dbusername" text NOT NULL,
1747 "dbuserpass" text NOT NULL,
1748 "requestdate" integer NOT NULL,
1749 "dbtype" integer NOT NULL,
1750 "created_by" integer NOT NULL,
1751 "state" integer NOT NULL,
1752 Constraint "prdb_dbs_pkey" Primary Key ("dbid")
1756 -- TOC Entry ID 253 (OID 22425)
1758 -- Name: prdb_states Type: TABLE Owner: tperdue
1761 CREATE TABLE "prdb_states" (
1762 "stateid" integer NOT NULL,
1767 -- TOC Entry ID 254 (OID 22451)
1769 -- Name: prdb_types Type: TABLE Owner: tperdue
1772 CREATE TABLE "prdb_types" (
1773 "dbtypeid" integer NOT NULL,
1774 "dbservername" text NOT NULL,
1775 "dbsoftware" text NOT NULL,
1776 Constraint "prdb_types_pkey" Primary Key ("dbtypeid")
1780 -- TOC Entry ID 146 (OID 22481)
1782 -- Name: prweb_vhost_vhostid_seq Type: SEQUENCE Owner: tperdue
1785 CREATE SEQUENCE "prweb_vhost_vhostid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1788 -- TOC Entry ID 255 (OID 22500)
1790 -- Name: prweb_vhost Type: TABLE Owner: tperdue
1793 CREATE TABLE "prweb_vhost" (
1794 "vhostid" integer DEFAULT nextval('"prweb_vhost_vhostid_seq"'::text) NOT NULL,
1798 "group_id" integer NOT NULL,
1799 Constraint "prweb_vhost_pkey" Primary Key ("vhostid")
1803 -- TOC Entry ID 148 (OID 22533)
1805 -- Name: artifact_grou_group_artifac_seq Type: SEQUENCE Owner: tperdue
1808 CREATE SEQUENCE "artifact_grou_group_artifac_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1811 -- TOC Entry ID 256 (OID 22552)
1813 -- Name: artifact_group_list Type: TABLE Owner: tperdue
1816 CREATE TABLE "artifact_group_list" (
1817 "group_artifact_id" integer DEFAULT nextval('"artifact_grou_group_artifac_seq"'::text) NOT NULL,
1818 "group_id" integer NOT NULL,
1821 "is_public" integer DEFAULT 0 NOT NULL,
1822 "allow_anon" integer DEFAULT 0 NOT NULL,
1823 "email_all_updates" integer DEFAULT 0 NOT NULL,
1824 "email_address" text NOT NULL,
1825 "due_period" integer DEFAULT 2592000 NOT NULL,
1826 "use_resolution" integer DEFAULT 0 NOT NULL,
1827 "submit_instructions" text,
1828 "browse_instructions" text,
1829 "datatype" integer DEFAULT 0 NOT NULL,
1830 "status_timeout" integer,
1831 Constraint "artifact_group_list_pkey" Primary Key ("group_artifact_id")
1835 -- TOC Entry ID 150 (OID 22600)
1837 -- Name: artifact_resolution_id_seq Type: SEQUENCE Owner: tperdue
1840 CREATE SEQUENCE "artifact_resolution_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1843 -- TOC Entry ID 257 (OID 22619)
1845 -- Name: artifact_resolution Type: TABLE Owner: tperdue
1848 CREATE TABLE "artifact_resolution" (
1849 "id" integer DEFAULT nextval('"artifact_resolution_id_seq"'::text) NOT NULL,
1850 "resolution_name" text,
1851 Constraint "artifact_resolution_pkey" Primary Key ("id")
1855 -- TOC Entry ID 152 (OID 22649)
1857 -- Name: artifact_perm_id_seq Type: SEQUENCE Owner: tperdue
1860 CREATE SEQUENCE "artifact_perm_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1863 -- TOC Entry ID 258 (OID 22668)
1865 -- Name: artifact_perm Type: TABLE Owner: tperdue
1868 CREATE TABLE "artifact_perm" (
1869 "id" integer DEFAULT nextval('"artifact_perm_id_seq"'::text) NOT NULL,
1870 "group_artifact_id" integer NOT NULL,
1871 "user_id" integer NOT NULL,
1872 "perm_level" integer DEFAULT 0 NOT NULL,
1873 Constraint "artifact_perm_pkey" Primary Key ("id")
1877 -- TOC Entry ID 259 (OID 22701)
1879 -- Name: artifactperm_user_vw Type: VIEW Owner: tperdue
1882 CREATE VIEW "artifactperm_user_vw" as SELECT ap.id, ap.group_artifact_id, ap.user_id, ap.perm_level, users.user_name, users.realname FROM artifact_perm ap, users WHERE (users.user_id = ap.user_id);
1885 -- TOC Entry ID 260 (OID 22717)
1887 -- Name: artifactperm_artgrouplist_vw Type: VIEW Owner: tperdue
1890 CREATE VIEW "artifactperm_artgrouplist_vw" as SELECT agl.group_artifact_id, agl.name, agl.description, agl.group_id, ap.user_id, ap.perm_level FROM artifact_perm ap, artifact_group_list agl WHERE (ap.group_artifact_id = agl.group_artifact_id);
1893 -- TOC Entry ID 154 (OID 22718)
1895 -- Name: artifact_category_id_seq Type: SEQUENCE Owner: tperdue
1898 CREATE SEQUENCE "artifact_category_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1901 -- TOC Entry ID 261 (OID 22737)
1903 -- Name: artifact_category Type: TABLE Owner: tperdue
1906 CREATE TABLE "artifact_category" (
1907 "id" integer DEFAULT nextval('"artifact_category_id_seq"'::text) NOT NULL,
1908 "group_artifact_id" integer NOT NULL,
1909 "category_name" text NOT NULL,
1910 "auto_assign_to" integer DEFAULT 100 NOT NULL,
1911 Constraint "artifact_category_pkey" Primary Key ("id")
1915 -- TOC Entry ID 156 (OID 22770)
1917 -- Name: artifact_group_id_seq Type: SEQUENCE Owner: tperdue
1920 CREATE SEQUENCE "artifact_group_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1923 -- TOC Entry ID 262 (OID 22789)
1925 -- Name: artifact_group Type: TABLE Owner: tperdue
1928 CREATE TABLE "artifact_group" (
1929 "id" integer DEFAULT nextval('"artifact_group_id_seq"'::text) NOT NULL,
1930 "group_artifact_id" integer NOT NULL,
1931 "group_name" text NOT NULL,
1932 Constraint "artifact_group_pkey" Primary Key ("id")
1936 -- TOC Entry ID 158 (OID 22820)
1938 -- Name: artifact_status_id_seq Type: SEQUENCE Owner: tperdue
1941 CREATE SEQUENCE "artifact_status_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1944 -- TOC Entry ID 263 (OID 22839)
1946 -- Name: artifact_status Type: TABLE Owner: tperdue
1949 CREATE TABLE "artifact_status" (
1950 "id" integer DEFAULT nextval('"artifact_status_id_seq"'::text) NOT NULL,
1951 "status_name" text NOT NULL,
1952 Constraint "artifact_status_pkey" Primary Key ("id")
1956 -- TOC Entry ID 160 (OID 22869)
1958 -- Name: artifact_artifact_id_seq Type: SEQUENCE Owner: tperdue
1961 CREATE SEQUENCE "artifact_artifact_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1964 -- TOC Entry ID 264 (OID 22888)
1966 -- Name: artifact Type: TABLE Owner: tperdue
1969 CREATE TABLE "artifact" (
1970 "artifact_id" integer DEFAULT nextval('"artifact_artifact_id_seq"'::text) NOT NULL,
1971 "group_artifact_id" integer NOT NULL,
1972 "status_id" integer DEFAULT '1' NOT NULL,
1973 "category_id" integer DEFAULT '100' NOT NULL,
1974 "artifact_group_id" integer DEFAULT '0' NOT NULL,
1975 "resolution_id" integer DEFAULT '100' NOT NULL,
1976 "priority" integer DEFAULT '5' NOT NULL,
1977 "submitted_by" integer DEFAULT '100' NOT NULL,
1978 "assigned_to" integer DEFAULT '100' NOT NULL,
1979 "open_date" integer DEFAULT '0' NOT NULL,
1980 "close_date" integer DEFAULT '0' NOT NULL,
1981 "summary" text NOT NULL,
1982 "details" text NOT NULL,
1983 Constraint "artifact_pkey" Primary Key ("artifact_id")
1987 -- TOC Entry ID 265 (OID 22970)
1989 -- Name: artifact_vw Type: VIEW Owner: tperdue
1992 CREATE VIEW "artifact_vw" as SELECT artifact.artifact_id, artifact.group_artifact_id, artifact.status_id, artifact.category_id, artifact.artifact_group_id, artifact.resolution_id, artifact.priority, artifact.submitted_by, artifact.assigned_to, artifact.open_date, artifact.close_date, artifact.summary, artifact.details, u.user_name AS assigned_unixname, u.realname AS assigned_realname, u.email AS assigned_email, u2.user_name AS submitted_unixname, u2.realname AS submitted_realname, u2.email AS submitted_email, artifact_status.status_name, artifact_category.category_name, artifact_group.group_name, artifact_resolution.resolution_name FROM users u, users u2, artifact, artifact_status, artifact_category, artifact_group, artifact_resolution WHERE ((((((artifact.assigned_to = u.user_id) AND (artifact.submitted_by = u2.user_id)) AND (artifact.status_id = artifact_status.id)) AND (artifact.category_id = artifact_category.id)) AND (artifact.artifact_group_id = artifact_group.id)) AND (artifact.resolution_id = artifact_resolution.id));
1995 -- TOC Entry ID 162 (OID 22974)
1997 -- Name: artifact_history_id_seq Type: SEQUENCE Owner: tperdue
2000 CREATE SEQUENCE "artifact_history_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
2003 -- TOC Entry ID 266 (OID 22993)
2005 -- Name: artifact_history Type: TABLE Owner: tperdue
2008 CREATE TABLE "artifact_history" (
2009 "id" integer DEFAULT nextval('"artifact_history_id_seq"'::text) NOT NULL,
2010 "artifact_id" integer DEFAULT '0' NOT NULL,
2011 "field_name" text DEFAULT '' NOT NULL,
2012 "old_value" text DEFAULT '' NOT NULL,
2013 "mod_by" integer DEFAULT '0' NOT NULL,
2014 "entrydate" integer DEFAULT '0' NOT NULL,
2015 Constraint "artifact_history_pkey" Primary Key ("id")
2019 -- TOC Entry ID 267 (OID 23047)
2021 -- Name: artifact_history_user_vw Type: VIEW Owner: tperdue
2024 CREATE VIEW "artifact_history_user_vw" as SELECT ah.id, ah.artifact_id, ah.field_name, ah.old_value, ah.entrydate, users.user_name FROM artifact_history ah, users WHERE (ah.mod_by = users.user_id);
2027 -- TOC Entry ID 164 (OID 23048)
2029 -- Name: artifact_file_id_seq Type: SEQUENCE Owner: tperdue
2032 CREATE SEQUENCE "artifact_file_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
2035 -- TOC Entry ID 268 (OID 23067)
2037 -- Name: artifact_file Type: TABLE Owner: tperdue
2040 CREATE TABLE "artifact_file" (
2041 "id" integer DEFAULT nextval('"artifact_file_id_seq"'::text) NOT NULL,
2042 "artifact_id" integer NOT NULL,
2043 "description" text NOT NULL,
2044 "bin_data" text NOT NULL,
2045 "filename" text NOT NULL,
2046 "filesize" integer NOT NULL,
2047 "filetype" text NOT NULL,
2048 "adddate" integer DEFAULT '0' NOT NULL,
2049 "submitted_by" integer NOT NULL,
2050 Constraint "artifact_file_pkey" Primary Key ("id")
2054 -- TOC Entry ID 269 (OID 23125)
2056 -- Name: artifact_file_user_vw Type: VIEW Owner: tperdue
2059 CREATE VIEW "artifact_file_user_vw" as SELECT af.id, af.artifact_id, af.description, af.bin_data, af.filename, af.filesize, af.filetype, af.adddate, af.submitted_by, users.user_name, users.realname FROM artifact_file af, users WHERE (af.submitted_by = users.user_id);
2062 -- TOC Entry ID 166 (OID 23126)
2064 -- Name: artifact_message_id_seq Type: SEQUENCE Owner: tperdue
2067 CREATE SEQUENCE "artifact_message_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
2070 -- TOC Entry ID 270 (OID 23145)
2072 -- Name: artifact_message Type: TABLE Owner: tperdue
2075 CREATE TABLE "artifact_message" (
2076 "id" integer DEFAULT nextval('"artifact_message_id_seq"'::text) NOT NULL,
2077 "artifact_id" integer NOT NULL,
2078 "submitted_by" integer NOT NULL,
2079 "from_email" text NOT NULL,
2080 "adddate" integer DEFAULT '0' NOT NULL,
2081 "body" text NOT NULL,
2082 Constraint "artifact_message_pkey" Primary Key ("id")
2086 -- TOC Entry ID 271 (OID 23198)
2088 -- Name: artifact_message_user_vw Type: VIEW Owner: tperdue
2091 CREATE VIEW "artifact_message_user_vw" as SELECT am.id, am.artifact_id, am.from_email, am.body, am.adddate, users.user_id, users.email, users.user_name, users.realname FROM artifact_message am, users WHERE (am.submitted_by = users.user_id);
2094 -- TOC Entry ID 168 (OID 23199)
2096 -- Name: artifact_monitor_id_seq Type: SEQUENCE Owner: tperdue
2099 CREATE SEQUENCE "artifact_monitor_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
2102 -- TOC Entry ID 272 (OID 23218)
2104 -- Name: artifact_monitor Type: TABLE Owner: tperdue
2107 CREATE TABLE "artifact_monitor" (
2108 "id" integer DEFAULT nextval('"artifact_monitor_id_seq"'::text) NOT NULL,
2109 "artifact_id" integer NOT NULL,
2110 "user_id" integer NOT NULL,
2112 Constraint "artifact_monitor_pkey" Primary Key ("id")
2116 -- TOC Entry ID 170 (OID 23250)
2118 -- Name: artifact_canned_response_id_seq Type: SEQUENCE Owner: tperdue
2121 CREATE SEQUENCE "artifact_canned_response_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
2124 -- TOC Entry ID 273 (OID 23269)
2126 -- Name: artifact_canned_responses Type: TABLE Owner: tperdue
2129 CREATE TABLE "artifact_canned_responses" (
2130 "id" integer DEFAULT nextval('"artifact_canned_response_id_seq"'::text) NOT NULL,
2131 "group_artifact_id" integer NOT NULL,
2132 "title" text NOT NULL,
2133 "body" text NOT NULL,
2134 Constraint "artifact_canned_responses_pkey" Primary Key ("id")
2138 -- TOC Entry ID 274 (OID 23301)
2140 -- Name: artifact_counts_agg Type: TABLE Owner: tperdue
2143 CREATE TABLE "artifact_counts_agg" (
2144 "group_artifact_id" integer NOT NULL,
2145 "count" integer NOT NULL,
2146 "open_count" integer
2150 -- TOC Entry ID 275 (OID 23313)
2152 -- Name: stats_site_pages_by_day Type: TABLE Owner: tperdue
2155 CREATE TABLE "stats_site_pages_by_day" (
2158 "site_page_views" integer
2162 -- TOC Entry ID 469 (OID 23325)
2164 -- Name: "plpgsql_call_handler" () Type: FUNCTION Owner: tperdue
2167 CREATE FUNCTION "plpgsql_call_handler" () RETURNS opaque AS '/usr/local/pgsql/lib/plpgsql.so', 'plpgsql_call_handler' LANGUAGE 'C';
2170 -- TOC Entry ID 470 (OID 23326)
2172 -- Name: plpgsql Type: PROCEDURAL LANGUAGE Owner:
2175 CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER "plpgsql_call_handler" LANCOMPILER 'PL/pgSQL';
2178 -- TOC Entry ID 471 (OID 23327)
2180 -- Name: "forumgrouplist_insert_agg" () Type: FUNCTION Owner: tperdue
2183 CREATE FUNCTION "forumgrouplist_insert_agg" () RETURNS opaque AS '
2185 INSERT INTO forum_agg_msg_count (group_forum_id,count)
2186 VALUES (NEW.group_forum_id,0);
2189 ' LANGUAGE 'plpgsql';
2192 -- TOC Entry ID 472 (OID 23328)
2194 -- Name: "artifactgrouplist_insert_agg" () Type: FUNCTION Owner: tperdue
2197 CREATE FUNCTION "artifactgrouplist_insert_agg" () RETURNS opaque AS '
2199 INSERT INTO artifact_counts_agg (group_artifact_id,count,open_count)
2200 VALUES (NEW.group_artifact_id,0,0);
2203 ' LANGUAGE 'plpgsql';
2206 -- TOC Entry ID 473 (OID 23329)
2208 -- Name: "artifactgroup_update_agg" () Type: FUNCTION Owner: tperdue
2211 CREATE FUNCTION "artifactgroup_update_agg" () RETURNS opaque AS '
2214 -- see if they are moving to a new artifacttype
2215 -- if so, its a more complex operation
2217 IF NEW.group_artifact_id <> OLD.group_artifact_id THEN
2219 -- transferred artifacts always have a status of 1
2220 -- so we will increment the new artifacttypes sums
2222 UPDATE artifact_counts_agg SET count=count+1, open_count=open_count+1
2223 WHERE group_artifact_id=NEW.group_artifact_id;
2225 -- now see how to increment/decrement the old types sums
2227 IF NEW.status_id <> OLD.status_id THEN
2228 IF OLD.status_id = 2 THEN
2229 UPDATE artifact_counts_agg SET count=count-1
2230 WHERE group_artifact_id=OLD.group_artifact_id;
2232 -- no need to do anything if it was in deleted status
2237 -- Was already in open status before
2239 UPDATE artifact_counts_agg SET count=count-1, open_count=open_count-1
2240 WHERE group_artifact_id=OLD.group_artifact_id;
2244 -- just need to evaluate the status flag and
2245 -- increment/decrement the counter as necessary
2247 IF NEW.status_id <> OLD.status_id THEN
2248 IF new.status_id = 1 THEN
2249 UPDATE artifact_counts_agg SET open_count=open_count+1
2250 WHERE group_artifact_id=new.group_artifact_id;
2252 IF new.status_id = 2 THEN
2253 UPDATE artifact_counts_agg SET open_count=open_count-1
2254 WHERE group_artifact_id=new.group_artifact_id;
2256 IF new.status_id = 3 THEN
2257 UPDATE artifact_counts_agg SET open_count=open_count-1,count=count-1
2258 WHERE group_artifact_id=new.group_artifact_id;
2266 ' LANGUAGE 'plpgsql';
2269 -- TOC Entry ID 172 (OID 23330)
2271 -- Name: massmail_queue_id_seq Type: SEQUENCE Owner: tperdue
2274 CREATE SEQUENCE "massmail_queue_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
2277 -- TOC Entry ID 276 (OID 23349)
2279 -- Name: massmail_queue Type: TABLE Owner: tperdue
2282 CREATE TABLE "massmail_queue" (
2283 "id" integer DEFAULT nextval('"massmail_queue_id_seq"'::text) NOT NULL,
2284 "type" character varying(8) NOT NULL,
2285 "subject" text NOT NULL,
2286 "message" text NOT NULL,
2287 "queued_date" integer NOT NULL,
2288 "last_userid" integer DEFAULT 0 NOT NULL,
2289 "failed_date" integer DEFAULT 0 NOT NULL,
2290 "finished_date" integer DEFAULT 0 NOT NULL,
2291 Constraint "massmail_queue_pkey" Primary Key ("id")
2295 -- TOC Entry ID 277 (OID 23388)
2297 -- Name: frs_dlstats_file_agg Type: TABLE Owner: tperdue
2300 CREATE TABLE "frs_dlstats_file_agg" (
2308 -- TOC Entry ID 278 (OID 23401)
2310 -- Name: stats_agg_site_by_group Type: TABLE Owner: tperdue
2313 CREATE TABLE "stats_agg_site_by_group" (
2321 -- TOC Entry ID 279 (OID 23414)
2323 -- Name: stats_project_metric Type: TABLE Owner: tperdue
2326 CREATE TABLE "stats_project_metric" (
2327 "month" integer DEFAULT 0 NOT NULL,
2328 "day" integer DEFAULT 0 NOT NULL,
2329 "ranking" integer DEFAULT 0 NOT NULL,
2330 "percentile" double precision DEFAULT 0 NOT NULL,
2331 "group_id" integer DEFAULT 0 NOT NULL
2335 -- TOC Entry ID 280 (OID 23433)
2337 -- Name: stats_agg_logo_by_group Type: TABLE Owner: tperdue
2340 CREATE TABLE "stats_agg_logo_by_group" (
2348 -- TOC Entry ID 281 (OID 23446)
2350 -- Name: stats_subd_pages Type: TABLE Owner: tperdue
2353 CREATE TABLE "stats_subd_pages" (
2354 "month" integer DEFAULT 0 NOT NULL,
2355 "day" integer DEFAULT 0 NOT NULL,
2356 "group_id" integer DEFAULT 0 NOT NULL,
2357 "pages" integer DEFAULT 0 NOT NULL
2361 -- TOC Entry ID 282 (OID 23463)
2363 -- Name: stats_cvs_user Type: TABLE Owner: tperdue
2366 CREATE TABLE "stats_cvs_user" (
2367 "month" integer DEFAULT 0 NOT NULL,
2368 "day" integer DEFAULT 0 NOT NULL,
2369 "group_id" integer DEFAULT 0 NOT NULL,
2370 "user_id" integer DEFAULT 0 NOT NULL,
2371 "checkouts" integer DEFAULT 0 NOT NULL,
2372 "commits" integer DEFAULT 0 NOT NULL,
2373 "adds" integer DEFAULT 0 NOT NULL
2377 -- TOC Entry ID 283 (OID 23486)
2379 -- Name: stats_cvs_group Type: TABLE Owner: tperdue
2382 CREATE TABLE "stats_cvs_group" (
2383 "month" integer DEFAULT 0 NOT NULL,
2384 "day" integer DEFAULT 0 NOT NULL,
2385 "group_id" integer DEFAULT 0 NOT NULL,
2386 "checkouts" integer DEFAULT 0 NOT NULL,
2387 "commits" integer DEFAULT 0 NOT NULL,
2388 "adds" integer DEFAULT 0 NOT NULL
2392 -- TOC Entry ID 284 (OID 23507)
2394 -- Name: stats_project_developers Type: TABLE Owner: tperdue
2397 CREATE TABLE "stats_project_developers" (
2398 "month" integer DEFAULT 0 NOT NULL,
2399 "day" integer DEFAULT 0 NOT NULL,
2400 "group_id" integer DEFAULT 0 NOT NULL,
2401 "developers" integer DEFAULT 0 NOT NULL
2405 -- TOC Entry ID 285 (OID 23524)
2407 -- Name: stats_project Type: TABLE Owner: tperdue
2410 CREATE TABLE "stats_project" (
2411 "month" integer DEFAULT 0 NOT NULL,
2412 "day" integer DEFAULT 0 NOT NULL,
2413 "group_id" integer DEFAULT 0 NOT NULL,
2414 "file_releases" integer DEFAULT 0,
2415 "msg_posted" integer DEFAULT 0,
2416 "msg_uniq_auth" integer DEFAULT 0,
2417 "bugs_opened" integer DEFAULT 0,
2418 "bugs_closed" integer DEFAULT 0,
2419 "support_opened" integer DEFAULT 0,
2420 "support_closed" integer DEFAULT 0,
2421 "patches_opened" integer DEFAULT 0,
2422 "patches_closed" integer DEFAULT 0,
2423 "artifacts_opened" integer DEFAULT 0,
2424 "artifacts_closed" integer DEFAULT 0,
2425 "tasks_opened" integer DEFAULT 0,
2426 "tasks_closed" integer DEFAULT 0,
2427 "help_requests" integer DEFAULT 0
2431 -- TOC Entry ID 286 (OID 23567)
2433 -- Name: stats_site Type: TABLE Owner: tperdue
2436 CREATE TABLE "stats_site" (
2439 "uniq_users" integer,
2441 "total_users" integer,
2442 "new_users" integer,
2443 "new_projects" integer
2447 -- TOC Entry ID 287 (OID 23583)
2449 -- Name: activity_log_old_old Type: TABLE Owner: tperdue
2452 CREATE TABLE "activity_log_old_old" (
2453 "day" integer DEFAULT '0' NOT NULL,
2454 "hour" integer DEFAULT '0' NOT NULL,
2455 "group_id" integer DEFAULT '0' NOT NULL,
2456 "browser" character varying(8) DEFAULT 'OTHER' NOT NULL,
2457 "ver" double precision DEFAULT '0.00' NOT NULL,
2458 "platform" character varying(8) DEFAULT 'OTHER' NOT NULL,
2459 "time" integer DEFAULT '0' NOT NULL,
2461 "type" integer DEFAULT '0' NOT NULL
2465 -- TOC Entry ID 288 (OID 23624)
2467 -- Name: activity_log_old Type: TABLE Owner: tperdue
2470 CREATE TABLE "activity_log_old" (
2471 "day" integer DEFAULT '0' NOT NULL,
2472 "hour" integer DEFAULT '0' NOT NULL,
2473 "group_id" integer DEFAULT '0' NOT NULL,
2474 "browser" character varying(8) DEFAULT 'OTHER' NOT NULL,
2475 "ver" double precision DEFAULT '0.00' NOT NULL,
2476 "platform" character varying(8) DEFAULT 'OTHER' NOT NULL,
2477 "time" integer DEFAULT '0' NOT NULL,
2479 "type" integer DEFAULT '0' NOT NULL
2483 -- TOC Entry ID 289 (OID 23665)
2485 -- Name: activity_log Type: TABLE Owner: tperdue
2488 CREATE TABLE "activity_log" (
2489 "day" integer DEFAULT '0' NOT NULL,
2490 "hour" integer DEFAULT '0' NOT NULL,
2491 "group_id" integer DEFAULT '0' NOT NULL,
2492 "browser" character varying(8) DEFAULT 'OTHER' NOT NULL,
2493 "ver" double precision DEFAULT '0.00' NOT NULL,
2494 "platform" character varying(8) DEFAULT 'OTHER' NOT NULL,
2495 "time" integer DEFAULT '0' NOT NULL,
2497 "type" integer DEFAULT '0' NOT NULL
2501 -- TOC Entry ID 290 (OID 23706)
2503 -- Name: cache_store Type: TABLE Owner: tperdue
2506 CREATE TABLE "cache_store" (
2507 "name" character varying(255) NOT NULL,
2509 "indate" integer DEFAULT 0 NOT NULL,
2510 Constraint "cache_store_pkey" Primary Key ("name")
2514 -- TOC Entry ID 291 (OID 25693)
2516 -- Name: user_metric_history Type: TABLE Owner: tperdue
2519 CREATE TABLE "user_metric_history" (
2520 "month" integer NOT NULL,
2521 "day" integer NOT NULL,
2522 "user_id" integer NOT NULL,
2523 "ranking" integer NOT NULL,
2524 "metric" double precision NOT NULL
2528 -- TOC Entry ID 292 (OID 25710)
2530 -- Name: foundry_project_rankings_agg Type: TABLE Owner: tperdue
2533 CREATE TABLE "foundry_project_rankings_agg" (
2534 "foundry_id" integer,
2536 "group_name" character varying(40),
2537 "unix_group_name" character varying(30),
2539 "percentile" double precision
2543 -- TOC Entry ID 293 (OID 25728)
2545 -- Name: foundry_project_downloads_agg Type: TABLE Owner: tperdue
2548 CREATE TABLE "foundry_project_downloads_agg" (
2549 "foundry_id" integer,
2550 "downloads" integer,
2552 "group_name" character varying(40),
2553 "unix_group_name" character varying(30)
2557 -- TOC Entry ID 294 (OID 25745)
2559 -- Name: frs_dlstats_filetotal_agg Type: TABLE Owner: tperdue
2562 CREATE TABLE "frs_dlstats_filetotal_agg" (
2568 -- TOC Entry ID 295 (OID 25759)
2570 -- Name: frs_dlstats_grouptotal_agg Type: TABLE Owner: tperdue
2573 CREATE TABLE "frs_dlstats_grouptotal_agg" (
2579 -- TOC Entry ID 296 (OID 25773)
2581 -- Name: frs_dlstats_group_agg Type: TABLE Owner: tperdue
2584 CREATE TABLE "frs_dlstats_group_agg" (
2592 -- TOC Entry ID 297 (OID 25792)
2594 -- Name: stats_project_months Type: TABLE Owner: tperdue
2597 CREATE TABLE "stats_project_months" (
2600 "developers" integer,
2601 "group_ranking" integer,
2602 "group_metric" double precision,
2603 "logo_showings" integer,
2604 "downloads" integer,
2605 "site_views" integer,
2606 "subdomain_views" integer,
2607 "page_views" integer,
2608 "file_releases" integer,
2609 "msg_posted" integer,
2610 "msg_uniq_auth" integer,
2611 "bugs_opened" integer,
2612 "bugs_closed" integer,
2613 "support_opened" integer,
2614 "support_closed" integer,
2615 "patches_opened" integer,
2616 "patches_closed" integer,
2617 "artifacts_opened" integer,
2618 "artifacts_closed" integer,
2619 "tasks_opened" integer,
2620 "tasks_closed" integer,
2621 "help_requests" integer,
2622 "cvs_checkouts" integer,
2623 "cvs_commits" integer,
2628 -- TOC Entry ID 298 (OID 25834)
2630 -- Name: stats_project_all Type: TABLE Owner: tperdue
2633 CREATE TABLE "stats_project_all" (
2635 "developers" integer,
2636 "group_ranking" integer,
2637 "group_metric" double precision,
2638 "logo_showings" integer,
2639 "downloads" integer,
2640 "site_views" integer,
2641 "subdomain_views" integer,
2642 "page_views" integer,
2643 "msg_posted" integer,
2644 "msg_uniq_auth" integer,
2645 "bugs_opened" integer,
2646 "bugs_closed" integer,
2647 "support_opened" integer,
2648 "support_closed" integer,
2649 "patches_opened" integer,
2650 "patches_closed" integer,
2651 "artifacts_opened" integer,
2652 "artifacts_closed" integer,
2653 "tasks_opened" integer,
2654 "tasks_closed" integer,
2655 "help_requests" integer,
2656 "cvs_checkouts" integer,
2657 "cvs_commits" integer,
2662 -- TOC Entry ID 299 (OID 25871)
2664 -- Name: stats_project_developers_last30 Type: TABLE Owner: tperdue
2667 CREATE TABLE "stats_project_developers_last30" (
2671 "developers" integer
2675 -- TOC Entry ID 300 (OID 25884)
2677 -- Name: stats_project_last_30 Type: TABLE Owner: tperdue
2680 CREATE TABLE "stats_project_last_30" (
2684 "developers" integer,
2685 "group_ranking" integer,
2686 "group_metric" double precision,
2687 "logo_showings" integer,
2688 "downloads" integer,
2689 "site_views" integer,
2690 "subdomain_views" integer,
2691 "page_views" integer,
2692 "filereleases" integer,
2693 "msg_posted" integer,
2694 "msg_uniq_auth" integer,
2695 "bugs_opened" integer,
2696 "bugs_closed" integer,
2697 "support_opened" integer,
2698 "support_closed" integer,
2699 "patches_opened" integer,
2700 "patches_closed" integer,
2701 "artifacts_opened" integer,
2702 "artifacts_closed" integer,
2703 "tasks_opened" integer,
2704 "tasks_closed" integer,
2705 "help_requests" integer,
2706 "cvs_checkouts" integer,
2707 "cvs_commits" integer,
2712 -- TOC Entry ID 301 (OID 25924)
2714 -- Name: stats_site_pages_by_month Type: TABLE Owner: tperdue
2717 CREATE TABLE "stats_site_pages_by_month" (
2719 "site_page_views" integer
2723 -- TOC Entry ID 302 (OID 25935)
2725 -- Name: stats_site_last_30 Type: TABLE Owner: tperdue
2728 CREATE TABLE "stats_site_last_30" (
2731 "site_page_views" integer,
2732 "downloads" integer,
2733 "subdomain_views" integer,
2734 "msg_posted" integer,
2735 "bugs_opened" integer,
2736 "bugs_closed" integer,
2737 "support_opened" integer,
2738 "support_closed" integer,
2739 "patches_opened" integer,
2740 "patches_closed" integer,
2741 "artifacts_opened" integer,
2742 "artifacts_closed" integer,
2743 "tasks_opened" integer,
2744 "tasks_closed" integer,
2745 "help_requests" integer,
2746 "cvs_checkouts" integer,
2747 "cvs_commits" integer,
2752 -- TOC Entry ID 303 (OID 25967)
2754 -- Name: stats_site_months Type: TABLE Owner: tperdue
2757 CREATE TABLE "stats_site_months" (
2759 "site_page_views" integer,
2760 "downloads" integer,
2761 "subdomain_views" integer,
2762 "msg_posted" integer,
2763 "bugs_opened" integer,
2764 "bugs_closed" integer,
2765 "support_opened" integer,
2766 "support_closed" integer,
2767 "patches_opened" integer,
2768 "patches_closed" integer,
2769 "artifacts_opened" integer,
2770 "artifacts_closed" integer,
2771 "tasks_opened" integer,
2772 "tasks_closed" integer,
2773 "help_requests" integer,
2774 "cvs_checkouts" integer,
2775 "cvs_commits" integer,
2780 -- TOC Entry ID 304 (OID 25998)
2782 -- Name: stats_site_all Type: TABLE Owner: tperdue
2785 CREATE TABLE "stats_site_all" (
2786 "site_page_views" integer,
2787 "downloads" integer,
2788 "subdomain_views" integer,
2789 "msg_posted" integer,
2790 "bugs_opened" integer,
2791 "bugs_closed" integer,
2792 "support_opened" integer,
2793 "support_closed" integer,
2794 "patches_opened" integer,
2795 "patches_closed" integer,
2796 "artifacts_opened" integer,
2797 "artifacts_closed" integer,
2798 "tasks_opened" integer,
2799 "tasks_closed" integer,
2800 "help_requests" integer,
2801 "cvs_checkouts" integer,
2802 "cvs_commits" integer,
2807 -- TOC Entry ID 305 (OID 26026)
2809 -- Name: trove_agg Type: TABLE Owner: tperdue
2812 CREATE TABLE "trove_agg" (
2813 "trove_cat_id" integer,
2815 "group_name" character varying(40),
2816 "unix_group_name" character varying(30),
2817 "status" character(1),
2818 "register_time" integer,
2819 "short_description" character varying(255),
2820 "percentile" double precision,
2825 -- TOC Entry ID 174 (OID 26050)
2827 -- Name: trove_treesum_trove_treesum_seq Type: SEQUENCE Owner: tperdue
2830 CREATE SEQUENCE "trove_treesum_trove_treesum_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
2833 -- TOC Entry ID 306 (OID 26069)
2835 -- Name: trove_treesums Type: TABLE Owner: tperdue
2838 CREATE TABLE "trove_treesums" (
2839 "trove_treesums_id" integer DEFAULT nextval('"trove_treesum_trove_treesum_seq"'::text) NOT NULL,
2840 "trove_cat_id" integer DEFAULT '0' NOT NULL,
2841 "limit_1" integer DEFAULT '0' NOT NULL,
2842 "subprojects" integer DEFAULT '0' NOT NULL,
2843 Constraint "trove_treesums_pkey" Primary Key ("trove_treesums_id")
2847 -- Data for TOC Entry ID 474 (OID 18743)
2849 -- Name: canned_responses Type: TABLE DATA Owner: tperdue
2853 COPY "canned_responses" FROM stdin;
2856 -- Data for TOC Entry ID 475 (OID 18793)
2858 -- Name: db_images Type: TABLE DATA Owner: tperdue
2862 COPY "db_images" FROM stdin;
2865 -- Data for TOC Entry ID 476 (OID 18859)
2867 -- Name: doc_data Type: TABLE DATA Owner: tperdue
2871 COPY "doc_data" FROM stdin;
2874 -- Data for TOC Entry ID 477 (OID 18924)
2876 -- Name: doc_groups Type: TABLE DATA Owner: tperdue
2880 COPY "doc_groups" FROM stdin;
2883 -- Data for TOC Entry ID 478 (OID 18961)
2885 -- Name: doc_states Type: TABLE DATA Owner: tperdue
2889 COPY "doc_states" FROM stdin;
2892 -- Data for TOC Entry ID 479 (OID 18996)
2894 -- Name: filemodule_monitor Type: TABLE DATA Owner: tperdue
2898 COPY "filemodule_monitor" FROM stdin;
2901 -- Data for TOC Entry ID 480 (OID 19033)
2903 -- Name: forum Type: TABLE DATA Owner: tperdue
2907 COPY "forum" FROM stdin;
2910 -- Data for TOC Entry ID 481 (OID 19080)
2912 -- Name: forum_agg_msg_count Type: TABLE DATA Owner: tperdue
2916 COPY "forum_agg_msg_count" FROM stdin;
2919 -- Data for TOC Entry ID 482 (OID 19115)
2921 -- Name: forum_group_list Type: TABLE DATA Owner: tperdue
2925 COPY "forum_group_list" FROM stdin;
2928 -- Data for TOC Entry ID 483 (OID 19173)
2930 -- Name: forum_monitored_forums Type: TABLE DATA Owner: tperdue
2934 COPY "forum_monitored_forums" FROM stdin;
2937 -- Data for TOC Entry ID 484 (OID 19210)
2939 -- Name: forum_saved_place Type: TABLE DATA Owner: tperdue
2943 COPY "forum_saved_place" FROM stdin;
2946 -- Data for TOC Entry ID 485 (OID 19230)
2948 -- Name: foundry_data Type: TABLE DATA Owner: tperdue
2952 COPY "foundry_data" FROM stdin;
2955 -- Data for TOC Entry ID 486 (OID 19287)
2957 -- Name: foundry_news Type: TABLE DATA Owner: tperdue
2961 COPY "foundry_news" FROM stdin;
2964 -- Data for TOC Entry ID 487 (OID 19328)
2966 -- Name: foundry_preferred_projects Type: TABLE DATA Owner: tperdue
2970 COPY "foundry_preferred_projects" FROM stdin;
2973 -- Data for TOC Entry ID 488 (OID 19367)
2975 -- Name: foundry_projects Type: TABLE DATA Owner: tperdue
2979 COPY "foundry_projects" FROM stdin;
2982 -- Data for TOC Entry ID 489 (OID 19404)
2984 -- Name: frs_file Type: TABLE DATA Owner: tperdue
2988 COPY "frs_file" FROM stdin;
2991 -- Data for TOC Entry ID 490 (OID 19465)
2993 -- Name: frs_filetype Type: TABLE DATA Owner: tperdue
2997 COPY "frs_filetype" FROM stdin;
3007 5900 Other Source File
3015 -- Data for TOC Entry ID 491 (OID 19514)
3017 -- Name: frs_package Type: TABLE DATA Owner: tperdue
3021 COPY "frs_package" FROM stdin;
3024 -- Data for TOC Entry ID 492 (OID 19567)
3026 -- Name: frs_processor Type: TABLE DATA Owner: tperdue
3030 COPY "frs_processor" FROM stdin;
3042 -- Data for TOC Entry ID 493 (OID 19616)
3044 -- Name: frs_release Type: TABLE DATA Owner: tperdue
3048 COPY "frs_release" FROM stdin;
3051 -- Data for TOC Entry ID 494 (OID 19677)
3053 -- Name: frs_status Type: TABLE DATA Owner: tperdue
3057 COPY "frs_status" FROM stdin;
3062 -- Data for TOC Entry ID 495 (OID 19745)
3064 -- Name: group_history Type: TABLE DATA Owner: tperdue
3068 COPY "group_history" FROM stdin;
3071 -- Data for TOC Entry ID 496 (OID 19802)
3073 -- Name: group_type Type: TABLE DATA Owner: tperdue
3077 COPY "group_type" FROM stdin;
3082 -- Data for TOC Entry ID 497 (OID 19851)
3084 -- Name: groups Type: TABLE DATA Owner: tperdue
3088 COPY "groups" FROM stdin;
3089 1 Master Group \N 0 A sourceforge shell1 \N \N cvs1 \N \N \N 0 1 1 1 1 1 1 1 1 1 0 1
3090 2 Stats Group \N 0 A stats shell1 \N \N cvs1 \N \N \N 0 1 1 1 1 1 1 1 1 1 0 1
3091 3 News Group \N 0 A news shell1 \N \N cvs1 \N \N \N 0 1 1 1 1 1 1 1 1 1 0 1
3092 4 Peer Ratings Group \N 0 A peerrating shell1 \N \N cvs1 \N \N \N 0 1 1 1 1 1 1 1 1 1 0 1
3095 -- Data for TOC Entry ID 499 (OID 19996)
3097 -- Name: mail_group_list Type: TABLE DATA Owner: tperdue
3101 COPY "mail_group_list" FROM stdin;
3104 -- Data for TOC Entry ID 500 (OID 20055)
3106 -- Name: news_bytes Type: TABLE DATA Owner: tperdue
3110 COPY "news_bytes" FROM stdin;
3113 -- Data for TOC Entry ID 501 (OID 20115)
3115 -- Name: people_job Type: TABLE DATA Owner: tperdue
3119 COPY "people_job" FROM stdin;
3122 -- Data for TOC Entry ID 502 (OID 20175)
3124 -- Name: people_job_category Type: TABLE DATA Owner: tperdue
3128 COPY "people_job_category" FROM stdin;
3135 7 Graphic/Other Designer 0
3138 -- Data for TOC Entry ID 503 (OID 20226)
3140 -- Name: people_job_inventory Type: TABLE DATA Owner: tperdue
3144 COPY "people_job_inventory" FROM stdin;
3147 -- Data for TOC Entry ID 504 (OID 20267)
3149 -- Name: people_job_status Type: TABLE DATA Owner: tperdue
3153 COPY "people_job_status" FROM stdin;
3159 -- Data for TOC Entry ID 505 (OID 20316)
3161 -- Name: people_skill Type: TABLE DATA Owner: tperdue
3165 COPY "people_skill" FROM stdin;
3168 -- Data for TOC Entry ID 506 (OID 20365)
3170 -- Name: people_skill_inventory Type: TABLE DATA Owner: tperdue
3174 COPY "people_skill_inventory" FROM stdin;
3177 -- Data for TOC Entry ID 507 (OID 20406)
3179 -- Name: people_skill_level Type: TABLE DATA Owner: tperdue
3183 COPY "people_skill_level" FROM stdin;
3191 -- Data for TOC Entry ID 508 (OID 20455)
3193 -- Name: people_skill_year Type: TABLE DATA Owner: tperdue
3197 COPY "people_skill_year" FROM stdin;
3205 -- Data for TOC Entry ID 509 (OID 20504)
3207 -- Name: project_assigned_to Type: TABLE DATA Owner: tperdue
3211 COPY "project_assigned_to" FROM stdin;
3214 -- Data for TOC Entry ID 510 (OID 20541)
3216 -- Name: project_dependencies Type: TABLE DATA Owner: tperdue
3220 COPY "project_dependencies" FROM stdin;
3223 -- Data for TOC Entry ID 511 (OID 20578)
3225 -- Name: project_group_list Type: TABLE DATA Owner: tperdue
3229 COPY "project_group_list" FROM stdin;
3233 -- Data for TOC Entry ID 512 (OID 20633)
3235 -- Name: project_history Type: TABLE DATA Owner: tperdue
3239 COPY "project_history" FROM stdin;
3242 -- Data for TOC Entry ID 513 (OID 20691)
3244 -- Name: project_metric Type: TABLE DATA Owner: tperdue
3248 COPY "project_metric" FROM stdin;
3251 -- Data for TOC Entry ID 514 (OID 20727)
3253 -- Name: project_metric_tmp1 Type: TABLE DATA Owner: tperdue
3257 COPY "project_metric_tmp1" FROM stdin;
3260 -- Data for TOC Entry ID 515 (OID 20782)
3262 -- Name: project_status Type: TABLE DATA Owner: tperdue
3266 COPY "project_status" FROM stdin;
3273 -- Data for TOC Entry ID 516 (OID 20832)
3275 -- Name: project_task Type: TABLE DATA Owner: tperdue
3279 COPY "project_task" FROM stdin;
3280 1 1 0 0 0 0 0 100 100
3283 -- Data for TOC Entry ID 517 (OID 20900)
3285 -- Name: project_weekly_metric Type: TABLE DATA Owner: tperdue
3289 COPY "project_weekly_metric" FROM stdin;
3292 -- Data for TOC Entry ID 518 (OID 20914)
3294 -- Name: session Type: TABLE DATA Owner: tperdue
3298 COPY "session" FROM stdin;
3301 -- Data for TOC Entry ID 519 (OID 20953)
3303 -- Name: snippet Type: TABLE DATA Owner: tperdue
3307 COPY "snippet" FROM stdin;
3310 -- Data for TOC Entry ID 520 (OID 21013)
3312 -- Name: snippet_package Type: TABLE DATA Owner: tperdue
3316 COPY "snippet_package" FROM stdin;
3319 -- Data for TOC Entry ID 521 (OID 21069)
3321 -- Name: snippet_package_item Type: TABLE DATA Owner: tperdue
3325 COPY "snippet_package_item" FROM stdin;
3328 -- Data for TOC Entry ID 522 (OID 21106)
3330 -- Name: snippet_package_version Type: TABLE DATA Owner: tperdue
3334 COPY "snippet_package_version" FROM stdin;
3337 -- Data for TOC Entry ID 523 (OID 21162)
3339 -- Name: snippet_version Type: TABLE DATA Owner: tperdue
3343 COPY "snippet_version" FROM stdin;
3346 -- Data for TOC Entry ID 524 (OID 21200)
3348 -- Name: stats_agg_logo_by_day Type: TABLE DATA Owner: tperdue
3352 COPY "stats_agg_logo_by_day" FROM stdin;
3355 -- Data for TOC Entry ID 525 (OID 21211)
3357 -- Name: stats_agg_pages_by_day Type: TABLE DATA Owner: tperdue
3361 COPY "stats_agg_pages_by_day" FROM stdin;
3364 -- Data for TOC Entry ID 526 (OID 21224)
3366 -- Name: stats_ftp_downloads Type: TABLE DATA Owner: tperdue
3370 COPY "stats_ftp_downloads" FROM stdin;
3373 -- Data for TOC Entry ID 527 (OID 21241)
3375 -- Name: stats_http_downloads Type: TABLE DATA Owner: tperdue
3379 COPY "stats_http_downloads" FROM stdin;
3382 -- Data for TOC Entry ID 528 (OID 21277)
3384 -- Name: supported_languages Type: TABLE DATA Owner: tperdue
3388 COPY "supported_languages" FROM stdin;
3389 1 English English.class English en
3390 2 Japanese Japanese.class Japanese ja
3391 3 Hebrew Hebrew.class Hebrew iw
3392 4 Spanish Spanish.class Spanish es
3393 5 Thai Thai.class Thai th
3394 6 German German.class German de
3395 7 French French.class French fr
3396 8 Italian Italian.class Italian it
3397 9 Norwegian Norwegian.class Norwegian no
3398 10 Swedish Swedish.class Swedish sv
3399 12 Dutch Dutch.class Dutch nl
3400 13 Esperanto Esperanto.class Esperanto eo
3401 14 Catalan Catalan.class Catalan ca
3402 15 Polish Polish.class Polish pl
3403 11 Trad.Chinese Chinese.class Chinese zh
3404 17 Russian Russian.class Russian ru
3405 18 Portuguese Portuguese.class Portuguese pt
3406 19 Greek Greek.class Greek el
3407 20 Bulgarian Bulgarian.class Bulgarian bg
3408 21 Indonesian Indonesian.class Indonesian id
3409 16 Pt. Brazillian PortugueseBrazillian.class PortugueseBrazillian pt
3410 22 Korean Korean.class Korean ko
3411 23 Smpl.Chinese SimplifiedChinese.class SimplifiedChinese zn
3414 -- Data for TOC Entry ID 529 (OID 21329)
3416 -- Name: survey_question_types Type: TABLE DATA Owner: tperdue
3420 COPY "survey_question_types" FROM stdin;
3423 3 Radio Buttons Yes/No
3429 -- Data for TOC Entry ID 530 (OID 21379)
3431 -- Name: survey_questions Type: TABLE DATA Owner: tperdue
3435 COPY "survey_questions" FROM stdin;
3438 -- Data for TOC Entry ID 531 (OID 21414)
3440 -- Name: survey_rating_aggregate Type: TABLE DATA Owner: tperdue
3444 COPY "survey_rating_aggregate" FROM stdin;
3447 -- Data for TOC Entry ID 532 (OID 21431)
3449 -- Name: survey_rating_response Type: TABLE DATA Owner: tperdue
3453 COPY "survey_rating_response" FROM stdin;
3456 -- Data for TOC Entry ID 533 (OID 21450)
3458 -- Name: survey_responses Type: TABLE DATA Owner: tperdue
3462 COPY "survey_responses" FROM stdin;
3465 -- Data for TOC Entry ID 534 (OID 21505)
3467 -- Name: surveys Type: TABLE DATA Owner: tperdue
3471 COPY "surveys" FROM stdin;
3474 -- Data for TOC Entry ID 535 (OID 21637)
3476 -- Name: theme_prefs Type: TABLE DATA Owner: tperdue
3480 COPY "theme_prefs" FROM stdin;
3483 -- Data for TOC Entry ID 536 (OID 21684)
3485 -- Name: themes Type: TABLE DATA Owner: tperdue
3489 COPY "themes" FROM stdin;
3490 1 offsite Off Site Theme
3493 -- Data for TOC Entry ID 537 (OID 21700)
3495 -- Name: top_group Type: TABLE DATA Owner: tperdue
3499 COPY "top_group" FROM stdin;
3502 -- Data for TOC Entry ID 538 (OID 21761)
3504 -- Name: trove_cat Type: TABLE DATA Owner: tperdue
3508 COPY "trove_cat" FROM stdin;
3509 1 2000031601 0 0 audience Intended Audience The main class of people likely to be interested in this resource. 0 0 Intended Audience 1
3510 2 2000032401 1 1 endusers End Users/Desktop Programs and resources for software end users. Software for the desktop. 0 0 Intended Audience :: End Users/Desktop 1 :: 2
3511 3 2000041101 1 1 developers Developers Programs and resources for software developers, to include libraries. 0 0 Intended Audience :: Developers 1 :: 3
3512 4 2000031601 1 1 sysadmins System Administrators Programs and resources for people who administer computers and networks. 0 0 Intended Audience :: System Administrators 1 :: 4
3513 5 2000040701 1 1 other Other Audience Programs and resources for an unlisted audience. 0 0 Intended Audience :: Other Audience 1 :: 5
3514 6 2000031601 0 0 developmentstatus Development Status An indication of the development status of the software or resource. 0 0 Development Status 6
3515 7 2000040701 6 6 planning 1 - Planning This resource is in the planning stages only. There is no code. 0 0 Development Status :: 1 - Planning 6 :: 7
3516 8 2000040701 6 6 prealpha 2 - Pre-Alpha There is code for this project, but it is not usable except for further development. 0 0 Development Status :: 2 - Pre-Alpha 6 :: 8
3517 9 2000041101 6 6 alpha 3 - Alpha Resource is in early development, and probably incomplete and/or extremely buggy. 0 0 Development Status :: 3 - Alpha 6 :: 9
3518 10 2000040701 6 6 beta 4 - Beta Resource is in late phases of development. Deliverables are essentially complete, but may still have significant bugs. 0 0 Development Status :: 4 - Beta 6 :: 10
3519 11 2000040701 6 6 production 5 - Production/Stable Deliverables are complete and usable by the intended audience. 0 0 Development Status :: 5 - Production/Stable 6 :: 11
3520 12 2000040701 6 6 mature 6 - Mature This resource has an extensive history of successful use and has probably undergone several stable revisions. 0 0 Development Status :: 6 - Mature 6 :: 12
3521 13 2000031601 0 0 license License License terms under which the resource is distributed. 0 0 License 13
3522 197 2000032001 13 13 publicdomain Public Domain Public Domain. No author-retained rights. 0 0 License :: Public Domain 13 :: 197
3523 196 2000040701 13 13 other Other/Proprietary License Non OSI-Approved/Proprietary license. 0 0 License :: Other/Proprietary License 13 :: 196
3524 14 2000032401 13 13 osi OSI Approved Licenses that have been approved by OSI as approved 0 0 License :: OSI Approved 13 :: 14
3525 303 2001041701 14 13 nethack Nethack General Public License Nethack General Public License 0 0 License :: OSI Approved :: Nethack General Public License 13 :: 14 :: 303
3526 141 2000032001 136 18 clustering Clustering/Distributed Networks Tools for automatically distributing computation across a network. 0 0 Topic :: System :: Clustering/Distributed Networks 18 :: 136 :: 141
3527 139 2000032001 136 18 boot Boot Programs for bootstrapping your OS. 0 0 Topic :: System :: Boot 18 :: 136 :: 139
projects / fusionforge / fusionforge.git / blob