---
--- Selected TOC Entries:
---
-\connect - tperdue
---
--- TOC Entry ID 2 (OID 18138427)
---
--- Name: "bug_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "bug_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 182 (OID 18138445)
---
--- Name: bug Type: TABLE Owner: tperdue
---
-
CREATE TABLE "bug" (
"bug_id" integer DEFAULT nextval('bug_pk_seq'::text) NOT NULL,
"group_id" integer DEFAULT '0' NOT NULL,
"resolution_id" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("bug_id")
);
-
---
--- TOC Entry ID 4 (OID 18138495)
---
--- Name: "bug_bug_dependencies_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "bug_bug_dependencies_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 183 (OID 18138513)
---
--- Name: bug_bug_dependencies Type: TABLE Owner: tperdue
---
-
CREATE TABLE "bug_bug_dependencies" (
"bug_depend_id" integer DEFAULT nextval('bug_bug_dependencies_pk_seq'::text) NOT NULL,
"bug_id" integer DEFAULT '0' NOT NULL,
"is_dependent_on_bug_id" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("bug_depend_id")
);
-
---
--- TOC Entry ID 6 (OID 18138531)
---
--- Name: "bug_canned_responses_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "bug_canned_responses_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 184 (OID 18138549)
---
--- Name: bug_canned_responses Type: TABLE Owner: tperdue
---
-
CREATE TABLE "bug_canned_responses" (
"bug_canned_id" integer DEFAULT nextval('bug_canned_responses_pk_seq'::text) NOT NULL,
"group_id" integer DEFAULT '0' NOT NULL,
"body" text,
PRIMARY KEY ("bug_canned_id")
);
-
---
--- TOC Entry ID 8 (OID 18138582)
---
--- Name: "bug_category_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "bug_category_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 185 (OID 18138600)
---
--- Name: bug_category Type: TABLE Owner: tperdue
---
-
CREATE TABLE "bug_category" (
"bug_category_id" integer DEFAULT nextval('bug_category_pk_seq'::text) NOT NULL,
"group_id" integer DEFAULT '0' NOT NULL,
"category_name" text,
PRIMARY KEY ("bug_category_id")
);
-
---
--- TOC Entry ID 10 (OID 18138632)
---
--- Name: "bug_filter_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "bug_filter_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 186 (OID 18138650)
---
--- Name: bug_filter Type: TABLE Owner: tperdue
---
-
CREATE TABLE "bug_filter" (
"filter_id" integer DEFAULT nextval('bug_filter_pk_seq'::text) NOT NULL,
"user_id" integer DEFAULT '0' NOT NULL,
"is_active" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("filter_id")
);
-
---
--- TOC Entry ID 12 (OID 18138687)
---
--- Name: "bug_group_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "bug_group_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 187 (OID 18138705)
---
--- Name: bug_group Type: TABLE Owner: tperdue
---
-
CREATE TABLE "bug_group" (
"bug_group_id" integer DEFAULT nextval('bug_group_pk_seq'::text) NOT NULL,
"group_id" integer DEFAULT '0' NOT NULL,
"group_name" text DEFAULT '' NOT NULL,
PRIMARY KEY ("bug_group_id")
);
-
---
--- TOC Entry ID 14 (OID 18138738)
---
--- Name: "bug_history_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "bug_history_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 188 (OID 18138756)
---
--- Name: bug_history Type: TABLE Owner: tperdue
---
-
CREATE TABLE "bug_history" (
"bug_history_id" integer DEFAULT nextval('bug_history_pk_seq'::text) NOT NULL,
"bug_id" integer DEFAULT '0' NOT NULL,
"date" integer,
PRIMARY KEY ("bug_history_id")
);
-
---
--- TOC Entry ID 16 (OID 18138794)
---
--- Name: "bug_resolution_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "bug_resolution_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 189 (OID 18138812)
---
--- Name: bug_resolution Type: TABLE Owner: tperdue
---
-
CREATE TABLE "bug_resolution" (
"resolution_id" integer DEFAULT nextval('bug_resolution_pk_seq'::text) NOT NULL,
"resolution_name" text DEFAULT '' NOT NULL,
PRIMARY KEY ("resolution_id")
);
-
---
--- TOC Entry ID 18 (OID 18138843)
---
--- Name: "bug_status_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "bug_status_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 190 (OID 18138861)
---
--- Name: bug_status Type: TABLE Owner: tperdue
---
-
CREATE TABLE "bug_status" (
"status_id" integer DEFAULT nextval('bug_status_pk_seq'::text) NOT NULL,
"status_name" text,
PRIMARY KEY ("status_id")
);
-
---
--- TOC Entry ID 20 (OID 18138891)
---
--- Name: "bug_task_dependencies_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "bug_task_dependencies_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 191 (OID 18138909)
---
--- Name: bug_task_dependencies Type: TABLE Owner: tperdue
---
-
CREATE TABLE "bug_task_dependencies" (
"bug_depend_id" integer DEFAULT nextval('bug_task_dependencies_pk_seq'::text) NOT NULL,
"bug_id" integer DEFAULT '0' NOT NULL,
"is_dependent_on_task_id" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("bug_depend_id")
);
-
---
--- TOC Entry ID 22 (OID 18138927)
---
--- Name: "canned_responses_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "canned_responses_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 192 (OID 18138946)
---
--- Name: canned_responses Type: TABLE Owner: tperdue
---
-
CREATE TABLE "canned_responses" (
"response_id" integer DEFAULT nextval('canned_responses_pk_seq'::text) NOT NULL,
"response_title" character varying(25),
"response_text" text,
PRIMARY KEY ("response_id")
);
-
---
--- TOC Entry ID 24 (OID 18138977)
---
--- Name: "db_images_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "db_images_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 193 (OID 18138995)
---
--- Name: db_images Type: TABLE Owner: tperdue
---
-
CREATE TABLE "db_images" (
"id" integer DEFAULT nextval('db_images_pk_seq'::text) NOT NULL,
"group_id" integer DEFAULT '0' NOT NULL,
"height" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("id")
);
-
---
--- TOC Entry ID 26 (OID 18139040)
---
--- Name: "doc_data_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "doc_data_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 194 (OID 18139058)
---
--- Name: doc_data Type: TABLE Owner: tperdue
---
-
CREATE TABLE "doc_data" (
"docid" integer DEFAULT nextval('doc_data_pk_seq'::text) NOT NULL,
"stateid" integer DEFAULT '0' NOT NULL,
"language_id" integer DEFAULT '1' NOT NULL,
PRIMARY KEY ("docid")
);
-
---
--- TOC Entry ID 28 (OID 18139104)
---
--- Name: "doc_groups_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "doc_groups_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 195 (OID 18139122)
---
--- Name: doc_groups Type: TABLE Owner: tperdue
---
-
CREATE TABLE "doc_groups" (
"doc_group" integer DEFAULT nextval('doc_groups_pk_seq'::text) NOT NULL,
"groupname" character varying(255) DEFAULT '' NOT NULL,
"group_id" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("doc_group")
);
-
---
--- TOC Entry ID 30 (OID 18139140)
---
--- Name: "doc_states_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "doc_states_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 196 (OID 18139158)
---
--- Name: doc_states Type: TABLE Owner: tperdue
---
-
CREATE TABLE "doc_states" (
"stateid" integer DEFAULT nextval('doc_states_pk_seq'::text) NOT NULL,
"name" character varying(255) DEFAULT '' NOT NULL,
PRIMARY KEY ("stateid")
);
-
---
--- TOC Entry ID 32 (OID 18139174)
---
--- Name: "filemodule_monitor_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "filemodule_monitor_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 197 (OID 18139192)
---
--- Name: filemodule_monitor Type: TABLE Owner: tperdue
---
-
CREATE TABLE "filemodule_monitor" (
"id" integer DEFAULT nextval('filemodule_monitor_pk_seq'::text) NOT NULL,
"filemodule_id" integer DEFAULT '0' NOT NULL,
"user_id" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("id")
);
-
---
--- TOC Entry ID 34 (OID 18139210)
---
--- Name: "forum_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "forum_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 198 (OID 18139228)
---
--- Name: forum Type: TABLE Owner: tperdue
---
-
CREATE TABLE "forum" (
"msg_id" integer DEFAULT nextval('forum_pk_seq'::text) NOT NULL,
"group_forum_id" integer DEFAULT '0' NOT NULL,
"most_recent_date" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("msg_id")
);
-
---
--- TOC Entry ID 199 (OID 18139275)
---
--- Name: forum_agg_msg_count Type: TABLE Owner: tperdue
---
-
CREATE TABLE "forum_agg_msg_count" (
"group_forum_id" integer DEFAULT '0' NOT NULL,
"count" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("group_forum_id")
);
-
---
--- TOC Entry ID 36 (OID 18139291)
---
--- Name: "forum_group_list_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "forum_group_list_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 200 (OID 18139309)
---
--- Name: forum_group_list Type: TABLE Owner: tperdue
---
-
CREATE TABLE "forum_group_list" (
"group_forum_id" integer DEFAULT nextval('forum_group_list_pk_seq'::text) NOT NULL,
"group_id" integer DEFAULT '0' NOT NULL,
"send_all_posts_to" text,
PRIMARY KEY ("group_forum_id")
);
-
---
--- TOC Entry ID 38 (OID 18139348)
---
--- Name: "forum_monitored_forums_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "forum_monitored_forums_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 201 (OID 18139366)
---
--- Name: forum_monitored_forums Type: TABLE Owner: tperdue
---
-
CREATE TABLE "forum_monitored_forums" (
"monitor_id" integer DEFAULT nextval('forum_monitored_forums_pk_seq'::text) NOT NULL,
"forum_id" integer DEFAULT '0' NOT NULL,
"user_id" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("monitor_id")
);
-
---
--- TOC Entry ID 40 (OID 18139384)
---
--- Name: "forum_saved_place_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "forum_saved_place_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 202 (OID 18139402)
---
--- Name: forum_saved_place Type: TABLE Owner: tperdue
---
-
CREATE TABLE "forum_saved_place" (
"saved_place_id" integer DEFAULT nextval('forum_saved_place_pk_seq'::text) NOT NULL,
"user_id" integer DEFAULT '0' NOT NULL,
"save_date" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("saved_place_id")
);
-
---
--- TOC Entry ID 203 (OID 18139454)
---
--- Name: foundry_data Type: TABLE Owner: tperdue
---
-
CREATE TABLE "foundry_data" (
"foundry_id" integer DEFAULT '0' NOT NULL,
"freeform1_html" text,
"trove_categories" text,
PRIMARY KEY ("foundry_id")
);
-
---
--- TOC Entry ID 42 (OID 18139492)
---
--- Name: "foundry_news_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "foundry_news_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 204 (OID 18139510)
---
--- Name: foundry_news Type: TABLE Owner: tperdue
---
-
CREATE TABLE "foundry_news" (
"foundry_news_id" integer DEFAULT nextval('foundry_news_pk_seq'::text) NOT NULL,
"foundry_id" integer DEFAULT '0' NOT NULL,
"is_approved" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("foundry_news_id")
);
-
---
--- TOC Entry ID 44 (OID 18139532)
---
--- Name: "foundry_preferred_projec_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "foundry_preferred_projec_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 205 (OID 18139550)
---
--- Name: foundry_preferred_projects Type: TABLE Owner: tperdue
---
-
CREATE TABLE "foundry_preferred_projects" (
"foundry_project_id" integer DEFAULT nextval('foundry_preferred_projec_pk_seq'::text) NOT NULL,
"foundry_id" integer DEFAULT '0' NOT NULL,
"rank" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("foundry_project_id")
);
-
---
--- TOC Entry ID 46 (OID 18139570)
---
--- Name: "foundry_projects_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "foundry_projects_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 206 (OID 18139588)
---
--- Name: foundry_projects Type: TABLE Owner: tperdue
---
-
CREATE TABLE "foundry_projects" (
"id" integer DEFAULT nextval('foundry_projects_pk_seq'::text) NOT NULL,
"foundry_id" integer DEFAULT '0' NOT NULL,
"project_id" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("id")
);
-
---
--- TOC Entry ID 207 (OID 18139606)
---
--- Name: frs_dlstats_agg Type: TABLE Owner: tperdue
---
-
CREATE TABLE "frs_dlstats_agg" (
"file_id" integer DEFAULT '0' NOT NULL,
"day" integer DEFAULT '0' NOT NULL,
"downloads_http" integer DEFAULT '0' NOT NULL,
"downloads_ftp" integer DEFAULT '0' NOT NULL
);
-
---
--- TOC Entry ID 208 (OID 18139623)
---
--- Name: frs_dlstats_file_agg Type: TABLE Owner: tperdue
---
-
CREATE TABLE "frs_dlstats_file_agg" (
"file_id" integer DEFAULT '0' NOT NULL,
"day" integer DEFAULT '0' NOT NULL,
"downloads" integer DEFAULT '0' NOT NULL
);
-
---
--- TOC Entry ID 209 (OID 18139638)
---
--- Name: frs_dlstats_filetotal_agg Type: TABLE Owner: tperdue
---
-
CREATE TABLE "frs_dlstats_filetotal_agg" (
"file_id" integer DEFAULT '0' NOT NULL,
"downloads" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("file_id")
);
-
---
--- TOC Entry ID 210 (OID 18139654)
---
--- Name: frs_dlstats_filetotal_agg_old Type: TABLE Owner: tperdue
---
-
CREATE TABLE "frs_dlstats_filetotal_agg_old" (
"file_id" integer DEFAULT '0' NOT NULL,
"downloads" integer DEFAULT '0' NOT NULL
);
-
---
--- TOC Entry ID 211 (OID 18139667)
---
--- Name: frs_dlstats_group_agg Type: TABLE Owner: tperdue
---
-
CREATE TABLE "frs_dlstats_group_agg" (
"group_id" integer DEFAULT '0' NOT NULL,
"day" integer DEFAULT '0' NOT NULL,
"downloads" integer DEFAULT '0' NOT NULL
);
-
---
--- TOC Entry ID 212 (OID 18139682)
---
--- Name: frs_dlstats_grouptotal_agg Type: TABLE Owner: tperdue
---
-
CREATE TABLE "frs_dlstats_grouptotal_agg" (
"group_id" integer DEFAULT '0' NOT NULL,
"downloads" integer DEFAULT '0' NOT NULL
);
-
---
--- TOC Entry ID 48 (OID 18139695)
---
--- Name: "frs_file_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "frs_file_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 213 (OID 18139714)
---
--- Name: frs_file Type: TABLE Owner: tperdue
---
-
CREATE TABLE "frs_file" (
"file_id" integer DEFAULT nextval('frs_file_pk_seq'::text) NOT NULL,
"filename" text,
"post_date" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("file_id")
);
-
---
--- TOC Entry ID 50 (OID 18139756)
---
--- Name: "frs_filetype_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "frs_filetype_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 214 (OID 18139774)
---
--- Name: frs_filetype Type: TABLE Owner: tperdue
---
-
CREATE TABLE "frs_filetype" (
"type_id" integer DEFAULT nextval('frs_filetype_pk_seq'::text) NOT NULL,
"name" text,
PRIMARY KEY ("type_id")
);
-
---
--- TOC Entry ID 52 (OID 18139804)
---
--- Name: "frs_package_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "frs_package_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 215 (OID 18139822)
---
--- Name: frs_package Type: TABLE Owner: tperdue
---
-
CREATE TABLE "frs_package" (
"package_id" integer DEFAULT nextval('frs_package_pk_seq'::text) NOT NULL,
"group_id" integer DEFAULT '0' NOT NULL,
"status_id" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("package_id")
);
-
---
--- TOC Entry ID 54 (OID 18139856)
---
--- Name: "frs_processor_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "frs_processor_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 216 (OID 18139874)
---
--- Name: frs_processor Type: TABLE Owner: tperdue
---
-
CREATE TABLE "frs_processor" (
"processor_id" integer DEFAULT nextval('frs_processor_pk_seq'::text) NOT NULL,
"name" text,
PRIMARY KEY ("processor_id")
);
-
---
--- TOC Entry ID 56 (OID 18139904)
---
--- Name: "frs_release_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "frs_release_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 217 (OID 18139922)
---
--- Name: frs_release Type: TABLE Owner: tperdue
---
-
CREATE TABLE "frs_release" (
"release_id" integer DEFAULT nextval('frs_release_pk_seq'::text) NOT NULL,
"package_id" integer DEFAULT '0' NOT NULL,
"released_by" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("release_id")
);
-
---
--- TOC Entry ID 58 (OID 18139964)
---
--- Name: "frs_status_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "frs_status_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 218 (OID 18139982)
---
--- Name: frs_status Type: TABLE Owner: tperdue
---
-
CREATE TABLE "frs_status" (
"status_id" integer DEFAULT nextval('frs_status_pk_seq'::text) NOT NULL,
"name" text,
PRIMARY KEY ("status_id")
);
-
---
--- TOC Entry ID 60 (OID 18140012)
---
--- Name: "group_cvs_history_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "group_cvs_history_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 219 (OID 18140030)
---
--- Name: group_cvs_history Type: TABLE Owner: tperdue
---
-
CREATE TABLE "group_cvs_history" (
"id" integer DEFAULT nextval('group_cvs_history_pk_seq'::text) NOT NULL,
"group_id" integer DEFAULT '0' NOT NULL,
"cvs_adds_wk" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("id")
);
-
---
--- TOC Entry ID 62 (OID 18140056)
---
--- Name: "group_history_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "group_history_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 220 (OID 18140074)
---
--- Name: group_history Type: TABLE Owner: tperdue
---
-
CREATE TABLE "group_history" (
"group_history_id" integer DEFAULT nextval('group_history_pk_seq'::text) NOT NULL,
"group_id" integer DEFAULT '0' NOT NULL,
"date" integer,
PRIMARY KEY ("group_history_id")
);
-
---
--- TOC Entry ID 64 (OID 18140112)
---
--- Name: "group_type_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "group_type_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 221 (OID 18140130)
---
--- Name: group_type Type: TABLE Owner: tperdue
---
-
CREATE TABLE "group_type" (
"type_id" integer DEFAULT nextval('group_type_pk_seq'::text) NOT NULL,
"name" text,
PRIMARY KEY ("type_id")
);
-
---
--- TOC Entry ID 66 (OID 18140160)
---
--- Name: "groups_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "groups_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 222 (OID 18140178)
---
--- Name: groups Type: TABLE Owner: tperdue
---
-
CREATE TABLE "groups" (
"group_id" integer DEFAULT nextval('groups_pk_seq'::text) NOT NULL,
"group_name" character varying(40),
"use_pm_depend_box" integer DEFAULT '1' NOT NULL,
PRIMARY KEY ("group_id")
);
-
---
--- TOC Entry ID 223 (OID 18140269)
---
--- Name: intel_agreement Type: TABLE Owner: tperdue
---
-
CREATE TABLE "intel_agreement" (
"user_id" integer DEFAULT '0' NOT NULL,
"message" text,
"is_approved" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("user_id")
);
-
---
--- TOC Entry ID 68 (OID 18140301)
---
--- Name: "mail_group_list_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "mail_group_list_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 224 (OID 18140319)
---
--- Name: mail_group_list Type: TABLE Owner: tperdue
---
-
CREATE TABLE "mail_group_list" (
"group_list_id" integer DEFAULT nextval('mail_group_list_pk_seq'::text) NOT NULL,
"group_id" integer DEFAULT '0' NOT NULL,
"description" text,
PRIMARY KEY ("group_list_id")
);
-
---
--- TOC Entry ID 70 (OID 18140359)
---
--- Name: "news_bytes_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "news_bytes_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 225 (OID 18140377)
---
--- Name: news_bytes Type: TABLE Owner: tperdue
---
-
CREATE TABLE "news_bytes" (
"id" integer DEFAULT nextval('news_bytes_pk_seq'::text) NOT NULL,
"group_id" integer DEFAULT '0' NOT NULL,
"details" text,
PRIMARY KEY ("id")
);
-
---
--- TOC Entry ID 72 (OID 18140419)
---
--- Name: "patch_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "patch_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 226 (OID 18140437)
---
--- Name: patch Type: TABLE Owner: tperdue
---
-
CREATE TABLE "patch" (
"patch_id" integer DEFAULT nextval('patch_pk_seq'::text) NOT NULL,
"group_id" integer DEFAULT '0' NOT NULL,
"close_date" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("patch_id")
);
-
---
--- TOC Entry ID 74 (OID 18140483)
---
--- Name: "patch_category_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "patch_category_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 227 (OID 18140501)
---
--- Name: patch_category Type: TABLE Owner: tperdue
---
-
CREATE TABLE "patch_category" (
"patch_category_id" integer DEFAULT nextval('patch_category_pk_seq'::text) NOT NULL,
"group_id" integer DEFAULT '0' NOT NULL,
"category_name" text DEFAULT '' NOT NULL,
PRIMARY KEY ("patch_category_id")
);
-
---
--- TOC Entry ID 76 (OID 18140534)
---
--- Name: "patch_history_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "patch_history_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 228 (OID 18140552)
---
--- Name: patch_history Type: TABLE Owner: tperdue
---
-
CREATE TABLE "patch_history" (
"patch_history_id" integer DEFAULT nextval('patch_history_pk_seq'::text) NOT NULL,
"patch_id" integer DEFAULT '0' NOT NULL,
"date" integer,
PRIMARY KEY ("patch_history_id")
);
-
---
--- TOC Entry ID 78 (OID 18140590)
---
--- Name: "patch_status_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "patch_status_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 229 (OID 18140608)
---
--- Name: patch_status Type: TABLE Owner: tperdue
---
-
CREATE TABLE "patch_status" (
"patch_status_id" integer DEFAULT nextval('patch_status_pk_seq'::text) NOT NULL,
"status_name" text,
PRIMARY KEY ("patch_status_id")
);
-
---
--- TOC Entry ID 80 (OID 18140638)
---
--- Name: "people_job_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "people_job_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 230 (OID 18140656)
---
--- Name: people_job Type: TABLE Owner: tperdue
---
-
CREATE TABLE "people_job" (
"job_id" integer DEFAULT nextval('people_job_pk_seq'::text) NOT NULL,
"group_id" integer DEFAULT '0' NOT NULL,
"category_id" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("job_id")
);
-
---
--- TOC Entry ID 82 (OID 18140697)
---
--- Name: "people_job_category_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "people_job_category_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 231 (OID 18140715)
---
--- Name: people_job_category Type: TABLE Owner: tperdue
---
-
CREATE TABLE "people_job_category" (
"category_id" integer DEFAULT nextval('people_job_category_pk_seq'::text) NOT NULL,
"name" text,
"private_flag" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("category_id")
);
-
---
--- TOC Entry ID 84 (OID 18140747)
---
--- Name: "people_job_inventory_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "people_job_inventory_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 232 (OID 18140765)
---
--- Name: people_job_inventory Type: TABLE Owner: tperdue
---
-
CREATE TABLE "people_job_inventory" (
"job_inventory_id" integer DEFAULT nextval('people_job_inventory_pk_seq'::text) NOT NULL,
"job_id" integer DEFAULT '0' NOT NULL,
"skill_year_id" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("job_inventory_id")
);
-
---
--- TOC Entry ID 86 (OID 18140787)
---
--- Name: "people_job_status_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "people_job_status_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 233 (OID 18140805)
---
--- Name: people_job_status Type: TABLE Owner: tperdue
---
-
CREATE TABLE "people_job_status" (
"status_id" integer DEFAULT nextval('people_job_status_pk_seq'::text) NOT NULL,
"name" text,
PRIMARY KEY ("status_id")
);
-
---
--- TOC Entry ID 88 (OID 18140835)
---
--- Name: "people_skill_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "people_skill_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 234 (OID 18140853)
---
--- Name: people_skill Type: TABLE Owner: tperdue
---
-
CREATE TABLE "people_skill" (
"skill_id" integer DEFAULT nextval('people_skill_pk_seq'::text) NOT NULL,
"name" text,
PRIMARY KEY ("skill_id")
);
-
---
--- TOC Entry ID 90 (OID 18140884)
---
--- Name: "people_skill_inventory_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "people_skill_inventory_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 235 (OID 18140902)
---
--- Name: people_skill_inventory Type: TABLE Owner: tperdue
---
-
CREATE TABLE "people_skill_inventory" (
"skill_inventory_id" integer DEFAULT nextval('people_skill_inventory_pk_seq'::text) NOT NULL,
"user_id" integer DEFAULT '0' NOT NULL,
"skill_year_id" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("skill_inventory_id")
);
-
---
--- TOC Entry ID 92 (OID 18140924)
---
--- Name: "people_skill_level_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "people_skill_level_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 236 (OID 18140942)
---
--- Name: people_skill_level Type: TABLE Owner: tperdue
---
-
CREATE TABLE "people_skill_level" (
"skill_level_id" integer DEFAULT nextval('people_skill_level_pk_seq'::text) NOT NULL,
"name" text,
PRIMARY KEY ("skill_level_id")
);
-
---
--- TOC Entry ID 94 (OID 18140972)
---
--- Name: "people_skill_year_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "people_skill_year_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 237 (OID 18140990)
---
--- Name: people_skill_year Type: TABLE Owner: tperdue
---
-
CREATE TABLE "people_skill_year" (
"skill_year_id" integer DEFAULT nextval('people_skill_year_pk_seq'::text) NOT NULL,
"name" text,
PRIMARY KEY ("skill_year_id")
);
-
---
--- TOC Entry ID 96 (OID 18141020)
---
--- Name: "project_assigned_to_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "project_assigned_to_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 238 (OID 18141038)
---
--- Name: project_assigned_to Type: TABLE Owner: tperdue
---
-
CREATE TABLE "project_assigned_to" (
"project_assigned_id" integer DEFAULT nextval('project_assigned_to_pk_seq'::text) NOT NULL,
"project_task_id" integer DEFAULT '0' NOT NULL,
"assigned_to_id" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("project_assigned_id")
);
-
---
--- TOC Entry ID 239 (OID 18141056)
---
--- Name: project_counts_tmp Type: TABLE Owner: tperdue
---
-
CREATE TABLE "project_counts_tmp" (
"group_id" integer,
"type" text,
"count" double precision
);
-
---
--- TOC Entry ID 240 (OID 18141083)
---
--- Name: project_counts_weekly_tmp Type: TABLE Owner: tperdue
---
-
CREATE TABLE "project_counts_weekly_tmp" (
"group_id" integer,
"type" text,
"count" double precision
);
-
---
--- TOC Entry ID 98 (OID 18141110)
---
--- Name: "project_dependencies_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "project_dependencies_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 241 (OID 18141128)
---
--- Name: project_dependencies Type: TABLE Owner: tperdue
---
-
CREATE TABLE "project_dependencies" (
"project_depend_id" integer DEFAULT nextval('project_dependencies_pk_seq'::text) NOT NULL,
"project_task_id" integer DEFAULT '0' NOT NULL,
"is_dependent_on_task_id" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("project_depend_id")
);
-
---
--- TOC Entry ID 100 (OID 18141146)
---
--- Name: "project_group_list_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "project_group_list_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 242 (OID 18141164)
---
--- Name: project_group_list Type: TABLE Owner: tperdue
---
-
CREATE TABLE "project_group_list" (
"group_project_id" integer DEFAULT nextval('project_group_list_pk_seq'::text) NOT NULL,
"group_id" integer DEFAULT '0' NOT NULL,
"description" text,
PRIMARY KEY ("group_project_id")
);
-
---
--- TOC Entry ID 102 (OID 18141200)
---
--- Name: "project_history_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "project_history_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 243 (OID 18141218)
---
--- Name: project_history Type: TABLE Owner: tperdue
---
-
CREATE TABLE "project_history" (
"project_history_id" integer DEFAULT nextval('project_history_pk_seq'::text) NOT NULL,
"project_task_id" integer DEFAULT '0' NOT NULL,
"date" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("project_history_id")
);
-
---
--- TOC Entry ID 104 (OID 18141257)
---
--- Name: "project_metric_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "project_metric_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 244 (OID 18141275)
---
--- Name: project_metric Type: TABLE Owner: tperdue
---
-
CREATE TABLE "project_metric" (
"ranking" integer DEFAULT nextval('project_metric_pk_seq'::text) NOT NULL,
"percentile" double precision,
"group_id" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("ranking")
);
-
---
--- TOC Entry ID 106 (OID 18141292)
---
--- Name: "project_metric_tmp1_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "project_metric_tmp1_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 245 (OID 18141310)
---
--- Name: project_metric_tmp1 Type: TABLE Owner: tperdue
---
-
CREATE TABLE "project_metric_tmp1" (
"ranking" integer DEFAULT nextval('project_metric_tmp1_pk_seq'::text) NOT NULL,
"group_id" integer DEFAULT '0' NOT NULL,
"value" double precision,
PRIMARY KEY ("ranking")
);
-
---
--- TOC Entry ID 108 (OID 18141327)
---
--- Name: "project_metric_weekly_tm_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "project_metric_weekly_tm_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 246 (OID 18141346)
---
--- Name: project_metric_weekly_tmp1 Type: TABLE Owner: tperdue
---
-
CREATE TABLE "project_metric_weekly_tmp1" (
"ranking" integer DEFAULT nextval('project_metric_weekly_tm_pk_seq'::text) NOT NULL,
"group_id" integer DEFAULT '0' NOT NULL,
"value" double precision,
PRIMARY KEY ("ranking")
);
-
---
--- TOC Entry ID 110 (OID 18141363)
---
--- Name: "project_status_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "project_status_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 247 (OID 18141381)
---
--- Name: project_status Type: TABLE Owner: tperdue
---
-
CREATE TABLE "project_status" (
"status_id" integer DEFAULT nextval('project_status_pk_seq'::text) NOT NULL,
"status_name" text DEFAULT '' NOT NULL,
PRIMARY KEY ("status_id")
);
-
---
--- TOC Entry ID 112 (OID 18141412)
---
--- Name: "project_task_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "project_task_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 248 (OID 18141430)
---
--- Name: project_task Type: TABLE Owner: tperdue
---
-
CREATE TABLE "project_task" (
"project_task_id" integer DEFAULT nextval('project_task_pk_seq'::text) NOT NULL,
"group_project_id" integer DEFAULT '0' NOT NULL,
"status_id" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("project_task_id")
);
-
---
--- TOC Entry ID 114 (OID 18141479)
---
--- Name: "project_weekly_metric_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "project_weekly_metric_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 249 (OID 18141497)
---
--- Name: project_weekly_metric Type: TABLE Owner: tperdue
---
-
CREATE TABLE "project_weekly_metric" (
"ranking" integer DEFAULT nextval('project_weekly_metric_pk_seq'::text) NOT NULL,
"percentile" double precision,
"group_id" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("ranking")
);
-
---
--- TOC Entry ID 250 (OID 18141514)
---
--- Name: session Type: TABLE Owner: tperdue
---
-
CREATE TABLE "session" (
"user_id" integer DEFAULT '0' NOT NULL,
"session_hash" character(32) DEFAULT '' NOT NULL,
"time" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("session_hash")
);
-
---
--- TOC Entry ID 116 (OID 18141534)
---
--- Name: "snippet_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "snippet_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 251 (OID 18141552)
---
--- Name: snippet Type: TABLE Owner: tperdue
---
-
CREATE TABLE "snippet" (
"snippet_id" integer DEFAULT nextval('snippet_pk_seq'::text) NOT NULL,
"created_by" integer DEFAULT '0' NOT NULL,
"category" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("snippet_id")
);
-
---
--- TOC Entry ID 118 (OID 18141593)
---
--- Name: "snippet_package_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "snippet_package_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 252 (OID 18141611)
---
--- Name: snippet_package Type: TABLE Owner: tperdue
---
-
CREATE TABLE "snippet_package" (
"snippet_package_id" integer DEFAULT nextval('snippet_package_pk_seq'::text) NOT NULL,
"created_by" integer DEFAULT '0' NOT NULL,
"language" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("snippet_package_id")
);
-
---
--- TOC Entry ID 120 (OID 18141648)
---
--- Name: "snippet_package_item_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "snippet_package_item_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 253 (OID 18141666)
---
--- Name: snippet_package_item Type: TABLE Owner: tperdue
---
-
CREATE TABLE "snippet_package_item" (
"snippet_package_item_id" integer DEFAULT nextval('snippet_package_item_pk_seq'::text) NOT NULL,
"snippet_package_version_id" integer DEFAULT '0' NOT NULL,
"snippet_version_id" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("snippet_package_item_id")
);
-
---
--- TOC Entry ID 122 (OID 18141684)
---
--- Name: "snippet_package_version_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "snippet_package_version_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 254 (OID 18141702)
---
--- Name: snippet_package_version Type: TABLE Owner: tperdue
---
-
CREATE TABLE "snippet_package_version" (
"snippet_package_version_id" integer DEFAULT nextval('snippet_package_version_pk_seq'::text) NOT NULL,
"snippet_package_id" integer DEFAULT '0' NOT NULL,
"date" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("snippet_package_version_id")
);
-
---
--- TOC Entry ID 124 (OID 18141739)
---
--- Name: "snippet_version_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "snippet_version_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 255 (OID 18141757)
---
--- Name: snippet_version Type: TABLE Owner: tperdue
---
-
CREATE TABLE "snippet_version" (
"snippet_version_id" integer DEFAULT nextval('snippet_version_pk_seq'::text) NOT NULL,
"snippet_id" integer DEFAULT '0' NOT NULL,
"code" text,
PRIMARY KEY ("snippet_version_id")
);
-
---
--- TOC Entry ID 256 (OID 18141795)
---
--- Name: stats_agg_logo_by_day Type: TABLE Owner: tperdue
---
-
CREATE TABLE "stats_agg_logo_by_day" (
"day" integer,
"count" integer
);
-
---
--- TOC Entry ID 257 (OID 18141806)
---
--- Name: stats_agg_logo_by_group Type: TABLE Owner: tperdue
---
-
CREATE TABLE "stats_agg_logo_by_group" (
"day" integer,
"group_id" integer,
"count" integer
);
-
---
--- TOC Entry ID 258 (OID 18141818)
---
--- Name: stats_agg_pages_by_browser Type: TABLE Owner: tperdue
---
-
CREATE TABLE "stats_agg_pages_by_browser" (
"browser" character varying(8),
"count" integer
);
-
---
--- TOC Entry ID 259 (OID 18141829)
---
--- Name: stats_agg_pages_by_day Type: TABLE Owner: tperdue
---
-
CREATE TABLE "stats_agg_pages_by_day" (
"day" integer DEFAULT '0' NOT NULL,
"count" integer DEFAULT '0' NOT NULL
);
-
---
--- TOC Entry ID 260 (OID 18141842)
---
--- Name: stats_agg_pages_by_day_old Type: TABLE Owner: tperdue
---
-
CREATE TABLE "stats_agg_pages_by_day_old" (
"day" integer,
"count" integer
);
-
---
--- TOC Entry ID 261 (OID 18141853)
---
--- Name: stats_agg_site_by_day Type: TABLE Owner: tperdue
---
-
CREATE TABLE "stats_agg_site_by_day" (
"day" integer DEFAULT '0' NOT NULL,
"count" integer DEFAULT '0' NOT NULL
);
-
---
--- TOC Entry ID 262 (OID 18141866)
---
--- Name: stats_agg_site_by_group Type: TABLE Owner: tperdue
---
-
CREATE TABLE "stats_agg_site_by_group" (
"day" integer DEFAULT '0' NOT NULL,
"group_id" integer DEFAULT '0' NOT NULL,
"count" integer DEFAULT '0' NOT NULL
);
-
---
--- TOC Entry ID 263 (OID 18141881)
---
--- Name: stats_agr_filerelease Type: TABLE Owner: tperdue
---
-
CREATE TABLE "stats_agr_filerelease" (
"filerelease_id" integer DEFAULT '0' NOT NULL,
"group_id" integer DEFAULT '0' NOT NULL,
"downloads" integer DEFAULT '0' NOT NULL
);
-
---
--- TOC Entry ID 264 (OID 18141896)
---
--- Name: stats_agr_project Type: TABLE Owner: tperdue
---
-
CREATE TABLE "stats_agr_project" (
"group_id" integer DEFAULT '0' NOT NULL,
"group_ranking" integer DEFAULT '0' NOT NULL,
"cvs_commits" integer DEFAULT '0' NOT NULL,
"cvs_adds" integer DEFAULT '0' NOT NULL
);
-
---
--- TOC Entry ID 265 (OID 18141949)
---
--- Name: stats_ftp_downloads Type: TABLE Owner: tperdue
---
-
CREATE TABLE "stats_ftp_downloads" (
"day" integer DEFAULT '0' NOT NULL,
"filerelease_id" integer DEFAULT '0' NOT NULL,
"group_id" integer DEFAULT '0' NOT NULL,
"downloads" integer DEFAULT '0' NOT NULL
);
-
---
--- TOC Entry ID 266 (OID 18141966)
---
--- Name: stats_http_downloads Type: TABLE Owner: tperdue
---
-
CREATE TABLE "stats_http_downloads" (
"day" integer DEFAULT '0' NOT NULL,
"filerelease_id" integer DEFAULT '0' NOT NULL,
"group_id" integer DEFAULT '0' NOT NULL,
"downloads" integer DEFAULT '0' NOT NULL
);
-
---
--- TOC Entry ID 267 (OID 18141983)
---
--- Name: stats_project Type: TABLE Owner: tperdue
---
-
CREATE TABLE "stats_project" (
"month" integer DEFAULT '0' NOT NULL,
"week" integer DEFAULT '0' NOT NULL,
"cvs_commits" integer DEFAULT '0' NOT NULL,
"cvs_adds" integer DEFAULT '0' NOT NULL
);
-
---
--- TOC Entry ID 268 (OID 18142042)
---
--- Name: stats_project_tmp Type: TABLE Owner: tperdue
---
-
CREATE TABLE "stats_project_tmp" (
"month" integer DEFAULT '0' NOT NULL,
"week" integer DEFAULT '0' NOT NULL,
"cvs_commits" integer DEFAULT '0' NOT NULL,
"cvs_adds" integer DEFAULT '0' NOT NULL
);
-
---
--- TOC Entry ID 269 (OID 18142101)
---
--- Name: stats_site Type: TABLE Owner: tperdue
---
-
CREATE TABLE "stats_site" (
"month" integer DEFAULT '0' NOT NULL,
"week" integer DEFAULT '0' NOT NULL,
"new_users" integer DEFAULT '0' NOT NULL,
"new_projects" integer DEFAULT '0' NOT NULL
);
-
---
--- TOC Entry ID 126 (OID 18142132)
---
--- Name: "support_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "support_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 270 (OID 18142150)
---
--- Name: support Type: TABLE Owner: tperdue
---
-
CREATE TABLE "support" (
"support_id" integer DEFAULT nextval('support_pk_seq'::text) NOT NULL,
"group_id" integer DEFAULT '0' NOT NULL,
"close_date" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("support_id")
);
-
---
--- TOC Entry ID 128 (OID 18142196)
---
--- Name: "support_canned_responses_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "support_canned_responses_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 271 (OID 18142214)
---
--- Name: support_canned_responses Type: TABLE Owner: tperdue
---
-
CREATE TABLE "support_canned_responses" (
"support_canned_id" integer DEFAULT nextval('support_canned_responses_pk_seq'::text) NOT NULL,
"group_id" integer DEFAULT '0' NOT NULL,
"body" text,
PRIMARY KEY ("support_canned_id")
);
-
---
--- TOC Entry ID 130 (OID 18142247)
---
--- Name: "support_category_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "support_category_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 272 (OID 18142265)
---
--- Name: support_category Type: TABLE Owner: tperdue
---
-
CREATE TABLE "support_category" (
"support_category_id" integer DEFAULT nextval('support_category_pk_seq'::text) NOT NULL,
"group_id" integer DEFAULT '0' NOT NULL,
"category_name" text DEFAULT '' NOT NULL,
PRIMARY KEY ("support_category_id")
);
-
---
--- TOC Entry ID 132 (OID 18142298)
---
--- Name: "support_history_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "support_history_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 273 (OID 18142316)
---
--- Name: support_history Type: TABLE Owner: tperdue
---
-
CREATE TABLE "support_history" (
"support_history_id" integer DEFAULT nextval('support_history_pk_seq'::text) NOT NULL,
"support_id" integer DEFAULT '0' NOT NULL,
"date" integer,
PRIMARY KEY ("support_history_id")
);
-
---
--- TOC Entry ID 134 (OID 18142354)
---
--- Name: "support_messages_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "support_messages_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 274 (OID 18142372)
---
--- Name: support_messages Type: TABLE Owner: tperdue
---
-
CREATE TABLE "support_messages" (
"support_message_id" integer DEFAULT nextval('support_messages_pk_seq'::text) NOT NULL,
"support_id" integer DEFAULT '0' NOT NULL,
"body" text,
PRIMARY KEY ("support_message_id")
);
-
---
--- TOC Entry ID 136 (OID 18142407)
---
--- Name: "support_status_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "support_status_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 275 (OID 18142425)
---
--- Name: support_status Type: TABLE Owner: tperdue
---
-
CREATE TABLE "support_status" (
"support_status_id" integer DEFAULT nextval('support_status_pk_seq'::text) NOT NULL,
"status_name" text,
PRIMARY KEY ("support_status_id")
);
-
---
--- TOC Entry ID 138 (OID 18142455)
---
--- Name: "supported_languages_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "supported_languages_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 276 (OID 18142473)
---
--- Name: supported_languages Type: TABLE Owner: tperdue
---
-
CREATE TABLE "supported_languages" (
"language_id" integer DEFAULT nextval('supported_languages_pk_seq'::text) NOT NULL,
"name" text,
"language_code" character(2),
PRIMARY KEY ("language_id")
);
-
---
--- TOC Entry ID 140 (OID 18142506)
---
--- Name: "survey_question_types_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "survey_question_types_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 277 (OID 18142524)
---
--- Name: survey_question_types Type: TABLE Owner: tperdue
---
-
CREATE TABLE "survey_question_types" (
"id" integer DEFAULT nextval('survey_question_types_pk_seq'::text) NOT NULL,
"type" text DEFAULT '' NOT NULL,
PRIMARY KEY ("id")
);
-
---
--- TOC Entry ID 142 (OID 18142555)
---
--- Name: "survey_questions_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "survey_questions_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 278 (OID 18142573)
---
--- Name: survey_questions Type: TABLE Owner: tperdue
---
-
CREATE TABLE "survey_questions" (
"question_id" integer DEFAULT nextval('survey_questions_pk_seq'::text) NOT NULL,
"group_id" integer DEFAULT '0' NOT NULL,
"question_type" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("question_id")
);
-
---
--- TOC Entry ID 279 (OID 18142608)
---
--- Name: survey_rating_aggregate Type: TABLE Owner: tperdue
---
-
CREATE TABLE "survey_rating_aggregate" (
"type" integer DEFAULT '0' NOT NULL,
"id" integer DEFAULT '0' NOT NULL,
"response" double precision DEFAULT '0' NOT NULL,
"count" integer DEFAULT '0' NOT NULL
);
-
---
--- TOC Entry ID 280 (OID 18142625)
---
--- Name: survey_rating_response Type: TABLE Owner: tperdue
---
-
CREATE TABLE "survey_rating_response" (
"user_id" integer DEFAULT '0' NOT NULL,
"type" integer DEFAULT '0' NOT NULL,
"response" integer DEFAULT '0' NOT NULL,
"date" integer DEFAULT '0' NOT NULL
);
-
---
--- TOC Entry ID 281 (OID 18142644)
---
--- Name: survey_responses Type: TABLE Owner: tperdue
---
-
CREATE TABLE "survey_responses" (
"user_id" integer DEFAULT '0' NOT NULL,
"group_id" integer DEFAULT '0' NOT NULL,
"response" text DEFAULT '' NOT NULL,
"date" integer DEFAULT '0' NOT NULL
);
-
---
--- TOC Entry ID 144 (OID 18142680)
---
--- Name: "surveys_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "surveys_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 282 (OID 18142698)
---
--- Name: surveys Type: TABLE Owner: tperdue
---
-
CREATE TABLE "surveys" (
"survey_id" integer DEFAULT nextval('surveys_pk_seq'::text) NOT NULL,
"group_id" integer DEFAULT '0' NOT NULL,
"is_active" integer DEFAULT '1' NOT NULL,
PRIMARY KEY ("survey_id")
);
-
---
--- TOC Entry ID 146 (OID 18142735)
---
--- Name: "system_history_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "system_history_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 148 (OID 18142787)
---
--- Name: "system_machines_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "system_machines_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 150 (OID 18142836)
---
--- Name: "system_news_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "system_news_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 152 (OID 18142895)
---
--- Name: "system_services_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "system_services_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 154 (OID 18142944)
---
--- Name: "system_status_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "system_status_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 283 (OID 18142992)
---
--- Name: theme_prefs Type: TABLE Owner: tperdue
---
-
CREATE TABLE "theme_prefs" (
"user_id" integer DEFAULT '0' NOT NULL,
"user_theme" integer DEFAULT '0' NOT NULL,
"color_ltback1" character(7) DEFAULT '',
PRIMARY KEY ("user_id")
);
-
---
--- TOC Entry ID 156 (OID 18143020)
---
--- Name: "themes_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "themes_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 284 (OID 18143038)
---
--- Name: themes Type: TABLE Owner: tperdue
---
-
CREATE TABLE "themes" (
"theme_id" integer DEFAULT nextval('themes_pk_seq'::text) NOT NULL,
"dirname" character varying(80),
"fullname" character varying(80),
PRIMARY KEY ("theme_id")
);
-
---
--- TOC Entry ID 285 (OID 18143054)
---
--- Name: tmp_projs_releases_tmp Type: TABLE Owner: tperdue
---
-
CREATE TABLE "tmp_projs_releases_tmp" (
"year" integer DEFAULT '0' NOT NULL,
"month" integer DEFAULT '0' NOT NULL,
"total_proj" integer DEFAULT '0' NOT NULL,
"total_releases" integer DEFAULT '0' NOT NULL
);
-
---
--- TOC Entry ID 286 (OID 18143071)
---
--- Name: top_group Type: TABLE Owner: tperdue
---
-
CREATE TABLE "top_group" (
"group_id" integer DEFAULT '0' NOT NULL,
"group_name" character varying(40),
"rank_pageviews_proj" integer DEFAULT '0' NOT NULL,
"rank_pageviews_proj_old" integer DEFAULT '0' NOT NULL
);
-
---
--- TOC Entry ID 158 (OID 18143113)
---
--- Name: "trove_cat_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "trove_cat_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 287 (OID 18143131)
---
--- Name: trove_cat Type: TABLE Owner: tperdue
---
-
CREATE TABLE "trove_cat" (
"trove_cat_id" integer DEFAULT nextval('trove_cat_pk_seq'::text) NOT NULL,
"version" integer DEFAULT '0' NOT NULL,
"fullpath_ids" text,
PRIMARY KEY ("trove_cat_id")
);
-
---
--- TOC Entry ID 160 (OID 18143176)
---
--- Name: "trove_group_link_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "trove_group_link_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 288 (OID 18143194)
---
--- Name: trove_group_link Type: TABLE Owner: tperdue
---
-
CREATE TABLE "trove_group_link" (
"trove_group_id" integer DEFAULT nextval('trove_group_link_pk_seq'::text) NOT NULL,
"trove_cat_id" integer DEFAULT '0' NOT NULL,
"trove_cat_root" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("trove_group_id")
);
-
---
--- TOC Entry ID 162 (OID 18143216)
---
--- Name: "trove_treesums_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "trove_treesums_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 289 (OID 18143234)
---
--- Name: trove_treesums Type: TABLE Owner: tperdue
---
-
CREATE TABLE "trove_treesums" (
"trove_treesums_id" integer DEFAULT nextval('trove_treesums_pk_seq'::text) NOT NULL,
"trove_cat_id" integer DEFAULT '0' NOT NULL,
"subprojects" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("trove_treesums_id")
);
-
---
--- TOC Entry ID 164 (OID 18143286)
---
--- Name: "user_bookmarks_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "user_bookmarks_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 290 (OID 18143304)
---
--- Name: user_bookmarks Type: TABLE Owner: tperdue
---
-
CREATE TABLE "user_bookmarks" (
"bookmark_id" integer DEFAULT nextval('user_bookmarks_pk_seq'::text) NOT NULL,
"user_id" integer DEFAULT '0' NOT NULL,
"bookmark_title" text,
PRIMARY KEY ("bookmark_id")
);
-
---
--- TOC Entry ID 166 (OID 18143337)
---
--- Name: "user_diary_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "user_diary_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 291 (OID 18143355)
---
--- Name: user_diary Type: TABLE Owner: tperdue
---
-
CREATE TABLE "user_diary" (
"id" integer DEFAULT nextval('user_diary_pk_seq'::text) NOT NULL,
"user_id" integer DEFAULT '0' NOT NULL,
"is_public" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("id")
);
-
---
--- TOC Entry ID 168 (OID 18143392)
---
--- Name: "user_diary_monitor_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "user_diary_monitor_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 292 (OID 18143410)
---
--- Name: user_diary_monitor Type: TABLE Owner: tperdue
---
-
CREATE TABLE "user_diary_monitor" (
"monitor_id" integer DEFAULT nextval('user_diary_monitor_pk_seq'::text) NOT NULL,
"monitored_user" integer DEFAULT '0' NOT NULL,
"user_id" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("monitor_id")
);
-
---
--- TOC Entry ID 170 (OID 18143428)
---
--- Name: "user_group_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "user_group_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 293 (OID 18143446)
---
--- Name: user_group Type: TABLE Owner: tperdue
---
-
CREATE TABLE "user_group" (
"user_group_id" integer DEFAULT nextval('user_group_pk_seq'::text) NOT NULL,
"user_id" integer DEFAULT '0' NOT NULL,
"release_flags" integer DEFAULT '0' NOT NULL,
PRIMARY KEY ("user_group_id")
);
-
---
--- TOC Entry ID 172 (OID 18143484)
---
--- Name: "user_metric_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "user_metric_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 294 (OID 18143502)
---
--- Name: user_metric Type: TABLE Owner: tperdue
---
-
CREATE TABLE "user_metric" (
"ranking" integer DEFAULT nextval('user_metric_pk_seq'::text) NOT NULL,
"user_id" integer DEFAULT '0' NOT NULL,
"importance_factor" double precision DEFAULT '0.00000000' NOT NULL,
PRIMARY KEY ("ranking")
);
-
---
--- TOC Entry ID 174 (OID 18143530)
---
--- Name: "user_metric0_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "user_metric0_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 295 (OID 18143548)
---
--- Name: user_metric0 Type: TABLE Owner: tperdue
---
-
CREATE TABLE "user_metric0" (
"ranking" integer DEFAULT nextval('user_metric0_pk_seq'::text) NOT NULL,
"user_id" integer DEFAULT '0' NOT NULL,
"importance_factor" double precision DEFAULT '0.00000000' NOT NULL,
PRIMARY KEY ("ranking")
);
-
---
--- TOC Entry ID 296 (OID 18143576)
---
--- Name: user_preferences Type: TABLE Owner: tperdue
---
-
CREATE TABLE "user_preferences" (
"user_id" integer DEFAULT '0' NOT NULL,
"preference_name" character varying(20),
"preference_value" character varying(20),
"set_date" integer DEFAULT '0' NOT NULL
);
-
---
--- TOC Entry ID 297 (OID 18143591)
---
--- Name: user_ratings Type: TABLE Owner: tperdue
---
-
CREATE TABLE "user_ratings" (
"rated_by" integer DEFAULT '0' NOT NULL,
"user_id" integer DEFAULT '0' NOT NULL,
"rate_field" integer DEFAULT '0' NOT NULL,
"rating" integer DEFAULT '0' NOT NULL
);
-
---
--- TOC Entry ID 176 (OID 18143608)
---
--- Name: "users_pk_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "users_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 298 (OID 18143626)
---
--- Name: users Type: TABLE Owner: tperdue
---
-
CREATE TABLE "users" (
"user_id" integer DEFAULT nextval('users_pk_seq'::text) NOT NULL,
"user_name" text DEFAULT '' NOT NULL,
"language" integer DEFAULT '1' NOT NULL,
PRIMARY KEY ("user_id")
);
-
---
--- TOC Entry ID 178 (OID 27311232)
---
--- Name: "unix_uid_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "unix_uid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 180 (OID 27311250)
---
--- Name: "forum_thread_seq" Type: SEQUENCE Owner: tperdue
---
-
CREATE SEQUENCE "forum_thread_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
-
---
--- TOC Entry ID 299 (OID 27311451)
---
--- Name: trove_agg Type: TABLE Owner: tperdue
---
-
CREATE TABLE "trove_agg" (
"trove_cat_id" integer,
"group_id" integer,
"percentile" double precision,
"ranking" integer
);
-
---
--- TOC Entry ID 302 (OID 30136736)
---
--- Name: activity_log Type: TABLE Owner: www
---
-
CREATE TABLE "activity_log" (
"day" integer DEFAULT '0' NOT NULL,
"hour" integer DEFAULT '0' NOT NULL,
"page" text,
"type" integer DEFAULT '0' NOT NULL
);
-
-\connect - tperdue
---
--- TOC Entry ID 316 (OID 18138445)
---
--- Name: "bug_group_id" Type: INDEX Owner: tperdue
---
-
+CREATE TABLE "activity_log_old" (
+ "day" integer DEFAULT '0' NOT NULL,
+ "hour" integer DEFAULT '0' NOT NULL,
+ "group_id" integer DEFAULT '0' NOT NULL,
+ "browser" character varying(8) DEFAULT 'OTHER' NOT NULL,
+ "ver" double precision DEFAULT '0.00' NOT NULL,
+ "platform" character varying(8) DEFAULT 'OTHER' NOT NULL,
+ "time" integer DEFAULT '0' NOT NULL,
+ "page" text,
+ "type" integer DEFAULT '0' NOT NULL
+);
+CREATE TABLE "activity_log_old_old" (
+ "day" integer DEFAULT '0' NOT NULL,
+ "hour" integer DEFAULT '0' NOT NULL,
+ "group_id" integer DEFAULT '0' NOT NULL,
+ "browser" character varying(8) DEFAULT 'OTHER' NOT NULL,
+ "ver" double precision DEFAULT '0.00' NOT NULL,
+ "platform" character varying(8) DEFAULT 'OTHER' NOT NULL,
+ "time" integer DEFAULT '0' NOT NULL,
+ "page" text,
+ "type" integer DEFAULT '0' NOT NULL
+);
CREATE INDEX "bug_group_id" on "bug" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 466 (OID 18138445)
---
--- Name: "bug_groupid_statusid" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "bug_groupid_statusid" on "bug" using btree ( "group_id" "int4_ops", "status_id" "int4_ops" );
-
---
--- TOC Entry ID 467 (OID 18138445)
---
--- Name: "bug_groupid_assignedto_statusid" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "bug_groupid_assignedto_statusid" on "bug" using btree ( "group_id" "int4_ops", "assigned_to" "int4_ops", "status_id" "int4_ops" );
-
---
--- TOC Entry ID 317 (OID 18138513)
---
--- Name: "bug_bug_dependencies_bug_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "bug_bug_dependencies_bug_id" on "bug_bug_dependencies" using btree ( "bug_id" "int4_ops" );
-
---
--- TOC Entry ID 318 (OID 18138513)
---
--- Name: "bug_bug_is_dependent_on_task_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "bug_bug_is_dependent_on_task_id" on "bug_bug_dependencies" using btree ( "is_dependent_on_bug_id" "int4_ops" );
-
---
--- TOC Entry ID 319 (OID 18138549)
---
--- Name: "bug_canned_response_group_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "bug_canned_response_group_id" on "bug_canned_responses" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 320 (OID 18138600)
---
--- Name: "bug_category_group_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "bug_category_group_id" on "bug_category" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 321 (OID 18138705)
---
--- Name: "bug_group_group_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "bug_group_group_id" on "bug_group" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 322 (OID 18138756)
---
--- Name: "bug_history_bug_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "bug_history_bug_id" on "bug_history" using btree ( "bug_id" "int4_ops" );
-
---
--- TOC Entry ID 323 (OID 18138909)
---
--- Name: "bug_task_dependencies_bug_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "bug_task_dependencies_bug_id" on "bug_task_dependencies" using btree ( "bug_id" "int4_ops" );
-
---
--- TOC Entry ID 324 (OID 18138909)
---
--- Name: "bug_task_is_dependent_on_task_i" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "bug_task_is_dependent_on_task_i" on "bug_task_dependencies" using btree ( "is_dependent_on_task_id" "int4_ops" );
-
---
--- TOC Entry ID 325 (OID 18138995)
---
--- Name: "db_images_group" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "db_images_group" on "db_images" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 326 (OID 18139058)
---
--- Name: "doc_group_doc_group" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "doc_group_doc_group" on "doc_data" using btree ( "doc_group" "int4_ops" );
-
---
--- TOC Entry ID 327 (OID 18139122)
---
--- Name: "doc_groups_group" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "doc_groups_group" on "doc_groups" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 328 (OID 18139192)
---
--- Name: "filemodule_monitor_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "filemodule_monitor_id" on "filemodule_monitor" using btree ( "filemodule_id" "int4_ops" );
-
---
--- TOC Entry ID 329 (OID 18139228)
---
--- Name: "forum_forumid_msgid" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "forum_forumid_msgid" on "forum" using btree ( "group_forum_id" "int4_ops", "msg_id" "int4_ops" );
-
---
--- TOC Entry ID 330 (OID 18139228)
---
--- Name: "forum_group_forum_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "forum_group_forum_id" on "forum" using btree ( "group_forum_id" "int4_ops" );
-
---
--- TOC Entry ID 331 (OID 18139228)
---
--- Name: "forum_forumid_isfollowupto" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "forum_forumid_isfollowupto" on "forum" using btree ( "group_forum_id" "int4_ops", "is_followup_to" "int4_ops" );
-
---
--- TOC Entry ID 332 (OID 18139228)
---
--- Name: "forum_forumid_threadid_mostrece" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "forum_forumid_threadid_mostrece" on "forum" using btree ( "group_forum_id" "int4_ops", "thread_id" "int4_ops", "most_recent_date" "int4_ops" );
-
---
--- TOC Entry ID 333 (OID 18139228)
---
--- Name: "forum_threadid_isfollowupto" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "forum_threadid_isfollowupto" on "forum" using btree ( "thread_id" "int4_ops", "is_followup_to" "int4_ops" );
-
---
--- TOC Entry ID 334 (OID 18139228)
---
--- Name: "forum_forumid_isfollto_mostrece" Type: INDEX Owner: tperdue
---
-
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" );
-
---
--- TOC Entry ID 335 (OID 18139309)
---
--- Name: "forum_group_list_group_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "forum_group_list_group_id" on "forum_group_list" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 336 (OID 18139366)
---
--- Name: "forum_monitor_combo_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "forum_monitor_combo_id" on "forum_monitored_forums" using btree ( "forum_id" "int4_ops", "user_id" "int4_ops" );
-
---
--- TOC Entry ID 337 (OID 18139366)
---
--- Name: "forum_monitor_thread_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "forum_monitor_thread_id" on "forum_monitored_forums" using btree ( "forum_id" "int4_ops" );
-
---
--- TOC Entry ID 338 (OID 18139510)
---
--- Name: "foundry_news_foundry_approved_d" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "foundry_news_foundry_approved_d" on "foundry_news" using btree ( "foundry_id" "int4_ops", "is_approved" "int4_ops", "approve_date" "int4_ops" );
-
---
--- TOC Entry ID 339 (OID 18139510)
---
--- Name: "foundry_news_foundry_approved" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "foundry_news_foundry_approved" on "foundry_news" using btree ( "foundry_id" "int4_ops", "is_approved" "int4_ops" );
-
---
--- TOC Entry ID 340 (OID 18139510)
---
--- Name: "foundry_news_foundry" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "foundry_news_foundry" on "foundry_news" using btree ( "foundry_id" "int4_ops" );
-
---
--- TOC Entry ID 463 (OID 18139510)
---
--- Name: "foundrynews_foundry_date_approv" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "foundrynews_foundry_date_approv" on "foundry_news" using btree ( "foundry_id" "int4_ops", "approve_date" "int4_ops", "is_approved" "int4_ops" );
-
---
--- TOC Entry ID 341 (OID 18139550)
---
--- Name: "foundry_project_group_rank" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "foundry_project_group_rank" on "foundry_preferred_projects" using btree ( "group_id" "int4_ops", "rank" "int4_ops" );
-
---
--- TOC Entry ID 342 (OID 18139550)
---
--- Name: "foundry_project_group" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "foundry_project_group" on "foundry_preferred_projects" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 343 (OID 18139588)
---
--- Name: "foundry_projects_foundry" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "foundry_projects_foundry" on "foundry_projects" using btree ( "foundry_id" "int4_ops" );
-
---
--- TOC Entry ID 344 (OID 18139606)
---
--- Name: "downloads_http_idx" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "downloads_http_idx" on "frs_dlstats_agg" using btree ( "downloads_http" "int4_ops" );
-
---
--- TOC Entry ID 345 (OID 18139606)
---
--- Name: "downloads_ftp_idx" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "downloads_ftp_idx" on "frs_dlstats_agg" using btree ( "downloads_ftp" "int4_ops" );
-
---
--- TOC Entry ID 346 (OID 18139606)
---
--- Name: "file_id_idx" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "file_id_idx" on "frs_dlstats_agg" using btree ( "file_id" "int4_ops" );
-
---
--- TOC Entry ID 347 (OID 18139606)
---
--- Name: "day_idx" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "day_idx" on "frs_dlstats_agg" using btree ( "day" "int4_ops" );
-
---
--- TOC Entry ID 348 (OID 18139623)
---
--- Name: "dlstats_file_down" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "dlstats_file_down" on "frs_dlstats_file_agg" using btree ( "downloads" "int4_ops" );
-
---
--- TOC Entry ID 349 (OID 18139623)
---
--- Name: "dlstats_file_file_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "dlstats_file_file_id" on "frs_dlstats_file_agg" using btree ( "file_id" "int4_ops" );
-
---
--- TOC Entry ID 350 (OID 18139623)
---
--- Name: "dlstats_file_day" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "dlstats_file_day" on "frs_dlstats_file_agg" using btree ( "day" "int4_ops" );
-
---
--- TOC Entry ID 351 (OID 18139638)
---
--- Name: "stats_agr_tmp_fid" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "stats_agr_tmp_fid" on "frs_dlstats_filetotal_agg" using btree ( "file_id" "int4_ops" );
-
---
--- TOC Entry ID 352 (OID 18139654)
---
--- Name: "frs_dlstats_filetotal_agg_old_f" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "frs_dlstats_filetotal_agg_old_f" on "frs_dlstats_filetotal_agg_old" using btree ( "file_id" "int4_ops" );
-
---
--- TOC Entry ID 303 (OID 18139667)
---
--- Name: "frsdlstatsgroupagg_day_dls" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "frsdlstatsgroupagg_day_dls" on "frs_dlstats_group_agg" using btree ( "day" "int4_ops", "downloads" "int4_ops" );
-
---
--- TOC Entry ID 353 (OID 18139667)
---
--- Name: "group_id_idx" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "group_id_idx" on "frs_dlstats_group_agg" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 355 (OID 18139667)
---
--- Name: "frs_dlstats_group_agg_day" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "frs_dlstats_group_agg_day" on "frs_dlstats_group_agg" using btree ( "day" "int4_ops" );
-
---
--- TOC Entry ID 356 (OID 18139682)
---
--- Name: "stats_agr_tmp_gid" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "stats_agr_tmp_gid" on "frs_dlstats_grouptotal_agg" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 357 (OID 18139714)
---
--- Name: "frs_file_name" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "frs_file_name" on "frs_file" using btree ( "filename" "text_ops" );
-
---
--- TOC Entry ID 358 (OID 18139714)
---
--- Name: "frs_file_date" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "frs_file_date" on "frs_file" using btree ( "post_date" "int4_ops" );
-
---
--- TOC Entry ID 359 (OID 18139714)
---
--- Name: "frs_file_processor" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "frs_file_processor" on "frs_file" using btree ( "processor_id" "int4_ops" );
-
---
--- TOC Entry ID 360 (OID 18139714)
---
--- Name: "frs_file_release_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "frs_file_release_id" on "frs_file" using btree ( "release_id" "int4_ops" );
-
---
--- TOC Entry ID 361 (OID 18139714)
---
--- Name: "frs_file_type" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "frs_file_type" on "frs_file" using btree ( "type_id" "int4_ops" );
-
---
--- TOC Entry ID 362 (OID 18139822)
---
--- Name: "package_group_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "package_group_id" on "frs_package" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 363 (OID 18139922)
---
--- Name: "frs_release_package" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "frs_release_package" on "frs_release" using btree ( "package_id" "int4_ops" );
-
---
--- TOC Entry ID 364 (OID 18139922)
---
--- Name: "frs_release_date" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "frs_release_date" on "frs_release" using btree ( "release_date" "int4_ops" );
-
---
--- TOC Entry ID 365 (OID 18139922)
---
--- Name: "frs_release_by" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "frs_release_by" on "frs_release" using btree ( "released_by" "int4_ops" );
-
---
--- TOC Entry ID 366 (OID 18140030)
---
--- Name: "group_cvs_history_group_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "group_cvs_history_group_id" on "group_cvs_history" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 367 (OID 18140030)
---
--- Name: "user_name_idx" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "user_name_idx" on "group_cvs_history" using btree ( "user_name" "varchar_ops" );
-
---
--- TOC Entry ID 368 (OID 18140074)
---
--- Name: "group_history_group_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "group_history_group_id" on "group_history" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 369 (OID 18140178)
---
--- Name: "groups_unix" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "groups_unix" on "groups" using btree ( "unix_group_name" "varchar_ops" );
-
---
--- TOC Entry ID 370 (OID 18140178)
---
--- Name: "groups_type" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "groups_type" on "groups" using btree ( "type" "int4_ops" );
-
---
--- TOC Entry ID 371 (OID 18140178)
---
--- Name: "groups_public" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "groups_public" on "groups" using btree ( "is_public" "int4_ops" );
-
---
--- TOC Entry ID 372 (OID 18140178)
---
--- Name: "groups_status" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "groups_status" on "groups" using btree ( "status" "bpchar_ops" );
-
---
--- TOC Entry ID 373 (OID 18140319)
---
--- Name: "mail_group_list_group" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "mail_group_list_group" on "mail_group_list" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 374 (OID 18140377)
---
--- Name: "news_bytes_group" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "news_bytes_group" on "news_bytes" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 375 (OID 18140377)
---
--- Name: "news_bytes_approved" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "news_bytes_approved" on "news_bytes" using btree ( "is_approved" "int4_ops" );
-
---
--- TOC Entry ID 376 (OID 18140377)
---
--- Name: "news_bytes_forum" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "news_bytes_forum" on "news_bytes" using btree ( "forum_id" "int4_ops" );
-
---
--- TOC Entry ID 464 (OID 18140377)
---
--- Name: "news_group_date" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "news_group_date" on "news_bytes" using btree ( "group_id" "int4_ops", "date" "int4_ops" );
-
---
--- TOC Entry ID 465 (OID 18140377)
---
--- Name: "news_approved_date" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "news_approved_date" on "news_bytes" using btree ( "is_approved" "int4_ops", "date" "int4_ops" );
-
---
--- TOC Entry ID 377 (OID 18140437)
---
--- Name: "patch_group_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "patch_group_id" on "patch" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 451 (OID 18140437)
---
--- Name: "patch_groupid_assignedto_status" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "patch_groupid_assignedto_status" on "patch" using btree ( "group_id" "int4_ops", "assigned_to" "int4_ops", "patch_status_id" "int4_ops" );
-
---
--- TOC Entry ID 452 (OID 18140437)
---
--- Name: "patch_groupid_assignedto" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "patch_groupid_assignedto" on "patch" using btree ( "group_id" "int4_ops", "assigned_to" "int4_ops" );
-
---
--- TOC Entry ID 453 (OID 18140437)
---
--- Name: "patch_groupid_status" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "patch_groupid_status" on "patch" using btree ( "group_id" "int4_ops", "patch_status_id" "int4_ops" );
-
---
--- TOC Entry ID 378 (OID 18140501)
---
--- Name: "patch_group_group_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "patch_group_group_id" on "patch_category" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 379 (OID 18140552)
---
--- Name: "patch_history_patch_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "patch_history_patch_id" on "patch_history" using btree ( "patch_id" "int4_ops" );
-
---
--- TOC Entry ID 461 (OID 18140656)
---
--- Name: "people_job_group_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "people_job_group_id" on "people_job" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 380 (OID 18141038)
---
--- Name: "project_assigned_to_assigned_to" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "project_assigned_to_assigned_to" on "project_assigned_to" using btree ( "assigned_to_id" "int4_ops" );
-
---
--- TOC Entry ID 381 (OID 18141038)
---
--- Name: "project_assigned_to_task_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "project_assigned_to_task_id" on "project_assigned_to" using btree ( "project_task_id" "int4_ops" );
-
---
--- TOC Entry ID 382 (OID 18141128)
---
--- Name: "project_is_dependent_on_task_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "project_is_dependent_on_task_id" on "project_dependencies" using btree ( "is_dependent_on_task_id" "int4_ops" );
-
---
--- TOC Entry ID 383 (OID 18141128)
---
--- Name: "project_dependencies_task_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "project_dependencies_task_id" on "project_dependencies" using btree ( "project_task_id" "int4_ops" );
-
---
--- TOC Entry ID 384 (OID 18141164)
---
--- Name: "project_group_list_group_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "project_group_list_group_id" on "project_group_list" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 385 (OID 18141218)
---
--- Name: "project_history_task_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "project_history_task_id" on "project_history" using btree ( "project_task_id" "int4_ops" );
-
---
--- TOC Entry ID 386 (OID 18141275)
---
--- Name: "project_metric_group" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "project_metric_group" on "project_metric" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 387 (OID 18141430)
---
--- Name: "project_task_group_project_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "project_task_group_project_id" on "project_task" using btree ( "group_project_id" "int4_ops" );
-
---
--- TOC Entry ID 454 (OID 18141430)
---
--- Name: "projecttask_projid_status" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "projecttask_projid_status" on "project_task" using btree ( "group_project_id" "int4_ops", "status_id" "int4_ops" );
-
---
--- TOC Entry ID 354 (OID 18141497)
---
--- Name: "projectweeklymetric_ranking" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "projectweeklymetric_ranking" on "project_weekly_metric" using btree ( "ranking" "int4_ops" );
-
---
--- TOC Entry ID 388 (OID 18141497)
---
--- Name: "project_metric_weekly_group" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "project_metric_weekly_group" on "project_weekly_metric" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 389 (OID 18141514)
---
--- Name: "session_user_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "session_user_id" on "session" using btree ( "user_id" "int4_ops" );
-
---
--- TOC Entry ID 390 (OID 18141514)
---
--- Name: "session_time" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "session_time" on "session" using btree ( "time" "int4_ops" );
-
---
--- TOC Entry ID 391 (OID 18141552)
---
--- Name: "snippet_language" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "snippet_language" on "snippet" using btree ( "language" "int4_ops" );
-
---
--- TOC Entry ID 392 (OID 18141552)
---
--- Name: "snippet_category" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "snippet_category" on "snippet" using btree ( "category" "int4_ops" );
-
---
--- TOC Entry ID 393 (OID 18141611)
---
--- Name: "snippet_package_language" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "snippet_package_language" on "snippet_package" using btree ( "language" "int4_ops" );
-
---
--- TOC Entry ID 394 (OID 18141611)
---
--- Name: "snippet_package_category" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "snippet_package_category" on "snippet_package" using btree ( "category" "int4_ops" );
-
---
--- TOC Entry ID 395 (OID 18141666)
---
--- Name: "snippet_package_item_pkg_ver" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "snippet_package_item_pkg_ver" on "snippet_package_item" using btree ( "snippet_package_version_id" "int4_ops" );
-
---
--- TOC Entry ID 396 (OID 18141702)
---
--- Name: "snippet_package_version_pkg_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "snippet_package_version_pkg_id" on "snippet_package_version" using btree ( "snippet_package_id" "int4_ops" );
-
---
--- TOC Entry ID 397 (OID 18141757)
---
--- Name: "snippet_version_snippet_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "snippet_version_snippet_id" on "snippet_version" using btree ( "snippet_id" "int4_ops" );
-
---
--- TOC Entry ID 398 (OID 18141829)
---
--- Name: "pages_by_day_day" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "pages_by_day_day" on "stats_agg_pages_by_day" using btree ( "day" "int4_ops" );
-
---
--- TOC Entry ID 399 (OID 18141881)
---
--- Name: "stats_agr_filerelease_group_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "stats_agr_filerelease_group_id" on "stats_agr_filerelease" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 400 (OID 18141881)
---
--- Name: "stats_agr_filerelease_filerelea" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "stats_agr_filerelease_filerelea" on "stats_agr_filerelease" using btree ( "filerelease_id" "int4_ops" );
-
---
--- TOC Entry ID 401 (OID 18141896)
---
--- Name: "project_agr_log_group" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "project_agr_log_group" on "stats_agr_project" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 402 (OID 18141949)
---
--- Name: "ftpdl_group_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "ftpdl_group_id" on "stats_ftp_downloads" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 403 (OID 18141949)
---
--- Name: "ftpdl_fid" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "ftpdl_fid" on "stats_ftp_downloads" using btree ( "filerelease_id" "int4_ops" );
-
---
--- TOC Entry ID 404 (OID 18141949)
---
--- Name: "ftpdl_day" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "ftpdl_day" on "stats_ftp_downloads" using btree ( "day" "int4_ops" );
-
---
--- TOC Entry ID 405 (OID 18141966)
---
--- Name: "httpdl_group_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "httpdl_group_id" on "stats_http_downloads" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 406 (OID 18141966)
---
--- Name: "httpdl_fid" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "httpdl_fid" on "stats_http_downloads" using btree ( "filerelease_id" "int4_ops" );
-
---
--- TOC Entry ID 407 (OID 18141966)
---
--- Name: "httpdl_day" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "httpdl_day" on "stats_http_downloads" using btree ( "day" "int4_ops" );
-
---
--- TOC Entry ID 408 (OID 18141983)
---
--- Name: "archive_project_monthday" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "archive_project_monthday" on "stats_project" using btree ( "month" "int4_ops", "day" "int4_ops" );
-
---
--- TOC Entry ID 409 (OID 18141983)
---
--- Name: "project_log_group" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "project_log_group" on "stats_project" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 410 (OID 18141983)
---
--- Name: "archive_project_week" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "archive_project_week" on "stats_project" using btree ( "week" "int4_ops" );
-
---
--- TOC Entry ID 411 (OID 18141983)
---
--- Name: "archive_project_day" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "archive_project_day" on "stats_project" using btree ( "day" "int4_ops" );
-
---
--- TOC Entry ID 412 (OID 18141983)
---
--- Name: "archive_project_month" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "archive_project_month" on "stats_project" using btree ( "month" "int4_ops" );
-
---
--- TOC Entry ID 413 (OID 18142042)
---
--- Name: "stats_project_tmp_group_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "stats_project_tmp_group_id" on "stats_project_tmp" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 414 (OID 18142042)
---
--- Name: "project_stats_week" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "project_stats_week" on "stats_project_tmp" using btree ( "week" "int4_ops" );
-
---
--- TOC Entry ID 415 (OID 18142042)
---
--- Name: "project_stats_month" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "project_stats_month" on "stats_project_tmp" using btree ( "month" "int4_ops" );
-
---
--- TOC Entry ID 416 (OID 18142042)
---
--- Name: "project_stats_day" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "project_stats_day" on "stats_project_tmp" using btree ( "day" "int4_ops" );
-
---
--- TOC Entry ID 417 (OID 18142101)
---
--- Name: "stats_site_monthday" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "stats_site_monthday" on "stats_site" using btree ( "month" "int4_ops", "day" "int4_ops" );
-
---
--- TOC Entry ID 418 (OID 18142101)
---
--- Name: "stats_site_week" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "stats_site_week" on "stats_site" using btree ( "week" "int4_ops" );
-
---
--- TOC Entry ID 419 (OID 18142101)
---
--- Name: "stats_site_day" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "stats_site_day" on "stats_site" using btree ( "day" "int4_ops" );
-
---
--- TOC Entry ID 420 (OID 18142101)
---
--- Name: "stats_site_month" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "stats_site_month" on "stats_site" using btree ( "month" "int4_ops" );
-
---
--- TOC Entry ID 421 (OID 18142150)
---
--- Name: "support_group_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "support_group_id" on "support" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 448 (OID 18142150)
---
--- Name: "support_groupid_assignedto" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "support_groupid_assignedto" on "support" using btree ( "group_id" "int4_ops", "assigned_to" "int4_ops" );
-
---
--- TOC Entry ID 449 (OID 18142150)
---
--- Name: "support_groupid_assignedto_stat" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "support_groupid_assignedto_stat" on "support" using btree ( "group_id" "int4_ops", "assigned_to" "int4_ops", "support_status_id" "int4_ops" );
-
---
--- TOC Entry ID 450 (OID 18142150)
---
--- Name: "support_groupid_status" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "support_groupid_status" on "support" using btree ( "group_id" "int4_ops", "support_status_id" "int4_ops" );
-
---
--- TOC Entry ID 422 (OID 18142214)
---
--- Name: "support_canned_response_group_i" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "support_canned_response_group_i" on "support_canned_responses" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 423 (OID 18142265)
---
--- Name: "support_group_group_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "support_group_group_id" on "support_category" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 424 (OID 18142316)
---
--- Name: "support_history_support_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "support_history_support_id" on "support_history" using btree ( "support_id" "int4_ops" );
-
---
--- TOC Entry ID 425 (OID 18142372)
---
--- Name: "support_messages_support_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "support_messages_support_id" on "support_messages" using btree ( "support_id" "int4_ops" );
-
---
--- TOC Entry ID 426 (OID 18142473)
---
--- Name: "supported_languages_code" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "supported_languages_code" on "supported_languages" using btree ( "language_code" "bpchar_ops" );
-
---
--- TOC Entry ID 427 (OID 18142573)
---
--- Name: "survey_questions_group" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "survey_questions_group" on "survey_questions" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 428 (OID 18142608)
---
--- Name: "survey_rating_aggregate_type_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "survey_rating_aggregate_type_id" on "survey_rating_aggregate" using btree ( "type" "int4_ops", "id" "int4_ops" );
-
---
--- TOC Entry ID 429 (OID 18142625)
---
--- Name: "survey_rating_responses_user_ty" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "survey_rating_responses_user_ty" on "survey_rating_response" using btree ( "user_id" "int4_ops", "type" "int4_ops", "id" "int4_ops" );
-
---
--- TOC Entry ID 430 (OID 18142625)
---
--- Name: "survey_rating_responses_type_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "survey_rating_responses_type_id" on "survey_rating_response" using btree ( "type" "int4_ops", "id" "int4_ops" );
-
---
--- TOC Entry ID 431 (OID 18142644)
---
--- Name: "survey_responses_group_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "survey_responses_group_id" on "survey_responses" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 432 (OID 18142644)
---
--- Name: "survey_responses_user_survey_qu" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "survey_responses_user_survey_qu" on "survey_responses" using btree ( "user_id" "int4_ops", "survey_id" "int4_ops", "question_id" "int4_ops" );
-
---
--- TOC Entry ID 433 (OID 18142644)
---
--- Name: "survey_responses_user_survey" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "survey_responses_user_survey" on "survey_responses" using btree ( "user_id" "int4_ops", "survey_id" "int4_ops" );
-
---
--- TOC Entry ID 434 (OID 18142644)
---
--- Name: "survey_responses_survey_questio" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "survey_responses_survey_questio" on "survey_responses" using btree ( "survey_id" "int4_ops", "question_id" "int4_ops" );
-
---
--- TOC Entry ID 435 (OID 18142698)
---
--- Name: "surveys_group" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "surveys_group" on "surveys" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 436 (OID 18143071)
---
--- Name: "rank_forumposts_week_idx" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "rank_forumposts_week_idx" on "top_group" using btree ( "rank_forumposts_week" "int4_ops" );
-
---
--- TOC Entry ID 437 (OID 18143071)
---
--- Name: "rank_downloads_week_idx" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "rank_downloads_week_idx" on "top_group" using btree ( "rank_downloads_week" "int4_ops" );
-
---
--- TOC Entry ID 438 (OID 18143071)
---
--- Name: "pageviews_proj_idx" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "pageviews_proj_idx" on "top_group" using btree ( "pageviews_proj" "int4_ops" );
-
---
--- TOC Entry ID 439 (OID 18143071)
---
--- Name: "rank_userrank_idx" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "rank_userrank_idx" on "top_group" using btree ( "rank_userrank" "int4_ops" );
-
---
--- TOC Entry ID 440 (OID 18143071)
---
--- Name: "rank_downloads_all_idx" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "rank_downloads_all_idx" on "top_group" using btree ( "rank_downloads_all" "int4_ops" );
-
---
--- TOC Entry ID 441 (OID 18143131)
---
--- Name: "parent_idx" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "parent_idx" on "trove_cat" using btree ( "parent" "int4_ops" );
-
---
--- TOC Entry ID 442 (OID 18143131)
---
--- Name: "root_parent_idx" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "root_parent_idx" on "trove_cat" using btree ( "root_parent" "int4_ops" );
-
---
--- TOC Entry ID 443 (OID 18143131)
---
--- Name: "version_idx" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "version_idx" on "trove_cat" using btree ( "version" "int4_ops" );
-
---
--- TOC Entry ID 444 (OID 18143194)
---
--- Name: "trove_group_link_group_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "trove_group_link_group_id" on "trove_group_link" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 445 (OID 18143194)
---
--- Name: "trove_group_link_cat_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "trove_group_link_cat_id" on "trove_group_link" using btree ( "trove_cat_id" "int4_ops" );
-
---
--- TOC Entry ID 446 (OID 18143304)
---
--- Name: "user_bookmark_user_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "user_bookmark_user_id" on "user_bookmarks" using btree ( "user_id" "int4_ops" );
-
---
--- TOC Entry ID 304 (OID 18143355)
---
--- Name: "user_diary_user" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "user_diary_user" on "user_diary" using btree ( "user_id" "int4_ops" );
-
---
--- TOC Entry ID 305 (OID 18143355)
---
--- Name: "user_diary_user_date" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "user_diary_user_date" on "user_diary" using btree ( "user_id" "int4_ops", "date_posted" "int4_ops" );
-
---
--- TOC Entry ID 306 (OID 18143355)
---
--- Name: "user_diary_date" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "user_diary_date" on "user_diary" using btree ( "date_posted" "int4_ops" );
-
---
--- TOC Entry ID 307 (OID 18143410)
---
--- Name: "user_diary_monitor_user" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "user_diary_monitor_user" on "user_diary_monitor" using btree ( "user_id" "int4_ops" );
-
---
--- TOC Entry ID 308 (OID 18143410)
---
--- Name: "user_diary_monitor_monitored_us" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "user_diary_monitor_monitored_us" on "user_diary_monitor" using btree ( "monitored_user" "int4_ops" );
-
---
--- TOC Entry ID 309 (OID 18143446)
---
--- Name: "user_group_group_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "user_group_group_id" on "user_group" using btree ( "group_id" "int4_ops" );
-
---
--- TOC Entry ID 310 (OID 18143446)
---
--- Name: "bug_flags_idx" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "bug_flags_idx" on "user_group" using btree ( "bug_flags" "int4_ops" );
-
---
--- TOC Entry ID 311 (OID 18143446)
---
--- Name: "project_flags_idx" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "project_flags_idx" on "user_group" using btree ( "project_flags" "int4_ops" );
-
---
--- TOC Entry ID 312 (OID 18143446)
---
--- Name: "user_group_user_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "user_group_user_id" on "user_group" using btree ( "user_id" "int4_ops" );
-
---
--- TOC Entry ID 313 (OID 18143446)
---
--- Name: "admin_flags_idx" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "admin_flags_idx" on "user_group" using btree ( "admin_flags" "bpchar_ops" );
-
---
--- TOC Entry ID 314 (OID 18143446)
---
--- Name: "forum_flags_idx" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "forum_flags_idx" on "user_group" using btree ( "forum_flags" "int4_ops" );
-
---
--- TOC Entry ID 315 (OID 18143548)
---
--- Name: "user_metric0_user_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "user_metric0_user_id" on "user_metric0" using btree ( "user_id" "int4_ops" );
-
---
--- TOC Entry ID 455 (OID 18143576)
---
--- Name: "user_pref_user_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "user_pref_user_id" on "user_preferences" using btree ( "user_id" "int4_ops" );
-
---
--- TOC Entry ID 456 (OID 18143591)
---
--- Name: "user_ratings_rated_by" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "user_ratings_rated_by" on "user_ratings" using btree ( "rated_by" "int4_ops" );
-
---
--- TOC Entry ID 457 (OID 18143591)
---
--- Name: "user_ratings_user_id" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "user_ratings_user_id" on "user_ratings" using btree ( "user_id" "int4_ops" );
-
---
--- TOC Entry ID 447 (OID 18143626)
---
--- Name: "users_status" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "users_status" on "users" using btree ( "status" "bpchar_ops" );
-
---
--- TOC Entry ID 458 (OID 18143626)
---
--- Name: "user_user" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "user_user" on "users" using btree ( "status" "bpchar_ops" );
-
---
--- TOC Entry ID 459 (OID 18143626)
---
--- Name: "idx_users_username" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "idx_users_username" on "users" using btree ( "user_name" "text_ops" );
-
---
--- TOC Entry ID 462 (OID 18143626)
---
--- Name: "users_user_pw" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "users_user_pw" on "users" using btree ( "user_pw" "varchar_ops" );
-
---
--- TOC Entry ID 460 (OID 27311451)
---
--- Name: "troveagg_trovecatid" Type: INDEX Owner: tperdue
---
-
CREATE INDEX "troveagg_trovecatid" on "trove_agg" using btree ( "trove_cat_id" "int4_ops" );
-
---
--- TOC Entry ID 536 (OID 27311269)
---
--- Name: "RI_ConstraintTrigger_27311268" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "user_group_user_id_fk" AFTER INSERT OR UPDATE ON "user_group" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('user_group_user_id_fk', 'user_group', 'users', 'FULL', 'user_id', 'user_id');
-
---
--- TOC Entry ID 537 (OID 27311271)
---
--- Name: "RI_ConstraintTrigger_27311270" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "user_group_user_id_fk" AFTER DELETE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('user_group_user_id_fk', 'user_group', 'users', 'FULL', 'user_id', 'user_id');
-
---
--- TOC Entry ID 538 (OID 27311273)
---
--- Name: "RI_ConstraintTrigger_27311272" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "user_group_user_id_fk" AFTER UPDATE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('user_group_user_id_fk', 'user_group', 'users', 'FULL', 'user_id', 'user_id');
-
---
--- TOC Entry ID 535 (OID 27311275)
---
--- Name: "RI_ConstraintTrigger_27311274" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "user_group_group_id_fk" AFTER INSERT OR UPDATE ON "user_group" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('user_group_group_id_fk', 'user_group', 'groups', 'FULL', 'group_id', 'group_id');
-
---
--- TOC Entry ID 506 (OID 27311277)
---
--- Name: "RI_ConstraintTrigger_27311276" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "user_group_group_id_fk" AFTER DELETE ON "groups" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('user_group_group_id_fk', 'user_group', 'groups', 'FULL', 'group_id', 'group_id');
-
---
--- TOC Entry ID 505 (OID 27311279)
---
--- Name: "RI_ConstraintTrigger_27311278" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "user_group_group_id_fk" AFTER UPDATE ON "groups" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('user_group_group_id_fk', 'user_group', 'groups', 'FULL', 'group_id', 'group_id');
-
---
--- TOC Entry ID 487 (OID 27311281)
---
--- Name: "RI_ConstraintTrigger_27311280" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "forum_posted_by_fk" AFTER INSERT OR UPDATE ON "forum" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('forum_posted_by_fk', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
-
---
--- TOC Entry ID 539 (OID 27311283)
---
--- Name: "RI_ConstraintTrigger_27311282" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "forum_posted_by_fk" AFTER DELETE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('forum_posted_by_fk', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
-
---
--- TOC Entry ID 540 (OID 27311285)
---
--- Name: "RI_ConstraintTrigger_27311284" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "forum_posted_by_fk" AFTER UPDATE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('forum_posted_by_fk', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
-
---
--- TOC Entry ID 486 (OID 27311287)
---
--- Name: "RI_ConstraintTrigger_27311286" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "forum_group_forum_id_fk" AFTER INSERT OR UPDATE ON "forum" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('forum_group_forum_id_fk', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
-
---
--- TOC Entry ID 492 (OID 27311289)
---
--- Name: "RI_ConstraintTrigger_27311288" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "forum_group_forum_id_fk" AFTER DELETE ON "forum_group_list" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('forum_group_forum_id_fk', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
-
---
--- TOC Entry ID 491 (OID 27311291)
---
--- Name: "RI_ConstraintTrigger_27311290" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "forum_group_forum_id_fk" AFTER UPDATE ON "forum_group_list" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('forum_group_forum_id_fk', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
-
---
--- TOC Entry ID 490 (OID 27311293)
---
--- Name: "RI_ConstraintTrigger_27311292" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "forum_group_list_group_id_fk" AFTER INSERT OR UPDATE ON "forum_group_list" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('forum_group_list_group_id_fk', 'forum_group_list', 'groups', 'FULL', 'group_id', 'group_id');
-
---
--- TOC Entry ID 504 (OID 27311295)
---
--- Name: "RI_ConstraintTrigger_27311294" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "forum_group_list_group_id_fk" AFTER DELETE ON "groups" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('forum_group_list_group_id_fk', 'forum_group_list', 'groups', 'FULL', 'group_id', 'group_id');
-
---
--- TOC Entry ID 503 (OID 27311297)
---
--- Name: "RI_ConstraintTrigger_27311296" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "forum_group_list_group_id_fk" AFTER UPDATE ON "groups" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('forum_group_list_group_id_fk', 'forum_group_list', 'groups', 'FULL', 'group_id', 'group_id');
-
---
--- TOC Entry ID 479 (OID 27311299)
---
--- Name: "RI_ConstraintTrigger_27311298" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "bug_group_group_fk" AFTER INSERT OR UPDATE ON "bug_group" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('bug_group_group_fk', 'bug_group', 'groups', 'FULL', 'group_id', 'group_id');
-
---
--- TOC Entry ID 502 (OID 27311301)
---
--- Name: "RI_ConstraintTrigger_27311300" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "bug_group_group_fk" AFTER DELETE ON "groups" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('bug_group_group_fk', 'bug_group', 'groups', 'FULL', 'group_id', 'group_id');
-
---
--- TOC Entry ID 501 (OID 27311303)
---
--- Name: "RI_ConstraintTrigger_27311302" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "bug_group_group_fk" AFTER UPDATE ON "groups" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('bug_group_group_fk', 'bug_group', 'groups', 'FULL', 'group_id', 'group_id');
-
---
--- TOC Entry ID 476 (OID 27311305)
---
--- Name: "RI_ConstraintTrigger_27311304" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "bug_category_group_fk" AFTER INSERT OR UPDATE ON "bug_category" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('bug_category_group_fk', 'bug_category', 'groups', 'FULL', 'group_id', 'group_id');
-
---
--- TOC Entry ID 500 (OID 27311307)
---
--- Name: "RI_ConstraintTrigger_27311306" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "bug_category_group_fk" AFTER DELETE ON "groups" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('bug_category_group_fk', 'bug_category', 'groups', 'FULL', 'group_id', 'group_id');
-
---
--- TOC Entry ID 499 (OID 27311309)
---
--- Name: "RI_ConstraintTrigger_27311308" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "bug_category_group_fk" AFTER UPDATE ON "groups" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('bug_category_group_fk', 'bug_category', 'groups', 'FULL', 'group_id', 'group_id');
-
---
--- TOC Entry ID 473 (OID 27311311)
---
--- Name: "RI_ConstraintTrigger_27311310" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "bug_submitted_by_fk" AFTER INSERT OR UPDATE ON "bug" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('bug_submitted_by_fk', 'bug', 'users', 'FULL', 'submitted_by', 'user_id');
-
---
--- TOC Entry ID 541 (OID 27311313)
---
--- Name: "RI_ConstraintTrigger_27311312" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "bug_submitted_by_fk" AFTER DELETE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('bug_submitted_by_fk', 'bug', 'users', 'FULL', 'submitted_by', 'user_id');
-
---
--- TOC Entry ID 542 (OID 27311315)
---
--- Name: "RI_ConstraintTrigger_27311314" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "bug_submitted_by_fk" AFTER UPDATE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('bug_submitted_by_fk', 'bug', 'users', 'FULL', 'submitted_by', 'user_id');
-
---
--- TOC Entry ID 472 (OID 27311317)
---
--- Name: "RI_ConstraintTrigger_27311316" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "bug_assigned_to_fk" AFTER INSERT OR UPDATE ON "bug" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('bug_assigned_to_fk', 'bug', 'users', 'FULL', 'assigned_to', 'user_id');
-
---
--- TOC Entry ID 543 (OID 27311319)
---
--- Name: "RI_ConstraintTrigger_27311318" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "bug_assigned_to_fk" AFTER DELETE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('bug_assigned_to_fk', 'bug', 'users', 'FULL', 'assigned_to', 'user_id');
-
---
--- TOC Entry ID 544 (OID 27311321)
---
--- Name: "RI_ConstraintTrigger_27311320" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "bug_assigned_to_fk" AFTER UPDATE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('bug_assigned_to_fk', 'bug', 'users', 'FULL', 'assigned_to', 'user_id');
-
---
--- TOC Entry ID 471 (OID 27311323)
---
--- Name: "RI_ConstraintTrigger_27311322" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "bug_status_fk" AFTER INSERT OR UPDATE ON "bug" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('bug_status_fk', 'bug', 'bug_status', 'FULL', 'status_id', 'status_id');
-
---
--- TOC Entry ID 483 (OID 27311325)
---
--- Name: "RI_ConstraintTrigger_27311324" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "bug_status_fk" AFTER DELETE ON "bug_status" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('bug_status_fk', 'bug', 'bug_status', 'FULL', 'status_id', 'status_id');
-
---
--- TOC Entry ID 482 (OID 27311327)
---
--- Name: "RI_ConstraintTrigger_27311326" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "bug_status_fk" AFTER UPDATE ON "bug_status" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('bug_status_fk', 'bug', 'bug_status', 'FULL', 'status_id', 'status_id');
-
---
--- TOC Entry ID 470 (OID 27311329)
---
--- Name: "RI_ConstraintTrigger_27311328" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "bug_category_fk" AFTER INSERT OR UPDATE ON "bug" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('bug_category_fk', 'bug', 'bug_category', 'FULL', 'category_id', 'bug_category_id');
-
---
--- TOC Entry ID 475 (OID 27311331)
---
--- Name: "RI_ConstraintTrigger_27311330" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "bug_category_fk" AFTER DELETE ON "bug_category" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('bug_category_fk', 'bug', 'bug_category', 'FULL', 'category_id', 'bug_category_id');
-
---
--- TOC Entry ID 474 (OID 27311333)
---
--- Name: "RI_ConstraintTrigger_27311332" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "bug_category_fk" AFTER UPDATE ON "bug_category" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('bug_category_fk', 'bug', 'bug_category', 'FULL', 'category_id', 'bug_category_id');
-
---
--- TOC Entry ID 469 (OID 27311335)
---
--- Name: "RI_ConstraintTrigger_27311334" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "bug_resolution_fk" AFTER INSERT OR UPDATE ON "bug" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('bug_resolution_fk', 'bug', 'bug_resolution', 'FULL', 'resolution_id', 'resolution_id');
-
---
--- TOC Entry ID 481 (OID 27311337)
---
--- Name: "RI_ConstraintTrigger_27311336" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "bug_resolution_fk" AFTER DELETE ON "bug_resolution" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('bug_resolution_fk', 'bug', 'bug_resolution', 'FULL', 'resolution_id', 'resolution_id');
-
---
--- TOC Entry ID 480 (OID 27311339)
---
--- Name: "RI_ConstraintTrigger_27311338" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "bug_resolution_fk" AFTER UPDATE ON "bug_resolution" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('bug_resolution_fk', 'bug', 'bug_resolution', 'FULL', 'resolution_id', 'resolution_id');
-
---
--- TOC Entry ID 468 (OID 27311341)
---
--- Name: "RI_ConstraintTrigger_27311340" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "bug_group_fk" AFTER INSERT OR UPDATE ON "bug" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('bug_group_fk', 'bug', 'bug_group', 'FULL', 'bug_group_id', 'bug_group_id');
-
---
--- TOC Entry ID 478 (OID 27311343)
---
--- Name: "RI_ConstraintTrigger_27311342" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "bug_group_fk" AFTER DELETE ON "bug_group" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('bug_group_fk', 'bug', 'bug_group', 'FULL', 'bug_group_id', 'bug_group_id');
-
---
--- TOC Entry ID 477 (OID 27311345)
---
--- Name: "RI_ConstraintTrigger_27311344" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "bug_group_fk" AFTER UPDATE ON "bug_group" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('bug_group_fk', 'bug', 'bug_group', 'FULL', 'bug_group_id', 'bug_group_id');
-
---
--- TOC Entry ID 485 (OID 27311347)
---
--- Name: "RI_ConstraintTrigger_27311346" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "forum_posted_by_fk" AFTER INSERT OR UPDATE ON "forum" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('forum_posted_by_fk', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
-
---
--- TOC Entry ID 545 (OID 27311349)
---
--- Name: "RI_ConstraintTrigger_27311348" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "forum_posted_by_fk" AFTER DELETE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('forum_posted_by_fk', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
-
---
--- TOC Entry ID 546 (OID 27311351)
---
--- Name: "RI_ConstraintTrigger_27311350" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "forum_posted_by_fk" AFTER UPDATE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('forum_posted_by_fk', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
-
---
--- TOC Entry ID 484 (OID 27311353)
---
--- Name: "RI_ConstraintTrigger_27311352" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "forum_group_forum_id_fk" AFTER INSERT OR UPDATE ON "forum" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('forum_group_forum_id_fk', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
-
---
--- TOC Entry ID 489 (OID 27311355)
---
--- Name: "RI_ConstraintTrigger_27311354" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "forum_group_forum_id_fk" AFTER DELETE ON "forum_group_list" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('forum_group_forum_id_fk', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
-
---
--- TOC Entry ID 488 (OID 27311357)
---
--- Name: "RI_ConstraintTrigger_27311356" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "forum_group_forum_id_fk" AFTER UPDATE ON "forum_group_list" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('forum_group_forum_id_fk', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
-
---
--- TOC Entry ID 518 (OID 27311359)
---
--- Name: "RI_ConstraintTrigger_27311358" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "project_group_list_group_id_fk" AFTER INSERT OR UPDATE ON "project_group_list" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('project_group_list_group_id_fk', 'project_group_list', 'groups', 'FULL', 'group_id', 'group_id');
-
---
--- TOC Entry ID 498 (OID 27311361)
---
--- Name: "RI_ConstraintTrigger_27311360" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "project_group_list_group_id_fk" AFTER DELETE ON "groups" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('project_group_list_group_id_fk', 'project_group_list', 'groups', 'FULL', 'group_id', 'group_id');
-
---
--- TOC Entry ID 497 (OID 27311363)
---
--- Name: "RI_ConstraintTrigger_27311362" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "project_group_list_group_id_fk" AFTER UPDATE ON "groups" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('project_group_list_group_id_fk', 'project_group_list', 'groups', 'FULL', 'group_id', 'group_id');
-
---
--- TOC Entry ID 523 (OID 27311365)
---
--- Name: "RI_ConstraintTrigger_27311364" Type: TRIGGER Owner: tperdue
---
-
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');
-
---
--- TOC Entry ID 517 (OID 27311367)
---
--- Name: "RI_ConstraintTrigger_27311366" Type: TRIGGER Owner: tperdue
---
-
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');
-
---
--- TOC Entry ID 516 (OID 27311369)
---
--- Name: "RI_ConstraintTrigger_27311368" Type: TRIGGER Owner: tperdue
---
-
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');
-
---
--- TOC Entry ID 522 (OID 27311371)
---
--- Name: "RI_ConstraintTrigger_27311370" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "project_task_created_by_fk" AFTER INSERT OR UPDATE ON "project_task" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('project_task_created_by_fk', 'project_task', 'users', 'FULL', 'created_by', 'user_id');
-
---
--- TOC Entry ID 547 (OID 27311373)
---
--- Name: "RI_ConstraintTrigger_27311372" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "project_task_created_by_fk" AFTER DELETE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('project_task_created_by_fk', 'project_task', 'users', 'FULL', 'created_by', 'user_id');
-
---
--- TOC Entry ID 548 (OID 27311375)
---
--- Name: "RI_ConstraintTrigger_27311374" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "project_task_created_by_fk" AFTER UPDATE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('project_task_created_by_fk', 'project_task', 'users', 'FULL', 'created_by', 'user_id');
-
---
--- TOC Entry ID 521 (OID 27311377)
---
--- Name: "RI_ConstraintTrigger_27311376" Type: TRIGGER Owner: tperdue
---
-
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');
-
---
--- TOC Entry ID 520 (OID 27311379)
---
--- Name: "RI_ConstraintTrigger_27311378" Type: TRIGGER Owner: tperdue
---
-
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');
-
---
--- TOC Entry ID 519 (OID 27311381)
---
--- Name: "RI_ConstraintTrigger_27311380" Type: TRIGGER Owner: tperdue
---
-
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');
-
---
--- TOC Entry ID 510 (OID 27311383)
---
--- Name: "RI_ConstraintTrigger_27311382" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "patch_status_id_fk" AFTER INSERT OR UPDATE ON "patch" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('patch_status_id_fk', 'patch', 'patch_status', 'FULL', 'patch_status_id', 'patch_status_id');
-
---
--- TOC Entry ID 515 (OID 27311385)
---
--- Name: "RI_ConstraintTrigger_27311384" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "patch_status_id_fk" AFTER DELETE ON "patch_status" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('patch_status_id_fk', 'patch', 'patch_status', 'FULL', 'patch_status_id', 'patch_status_id');
-
---
--- TOC Entry ID 514 (OID 27311387)
---
--- Name: "RI_ConstraintTrigger_27311386" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "patch_status_id_fk" AFTER UPDATE ON "patch_status" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('patch_status_id_fk', 'patch', 'patch_status', 'FULL', 'patch_status_id', 'patch_status_id');
-
---
--- TOC Entry ID 509 (OID 27311389)
---
--- Name: "RI_ConstraintTrigger_27311388" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "patch_category_id_fk" AFTER INSERT OR UPDATE ON "patch" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('patch_category_id_fk', 'patch', 'patch_category', 'FULL', 'patch_category_id', 'patch_category_id');
-
---
--- TOC Entry ID 513 (OID 27311391)
---
--- Name: "RI_ConstraintTrigger_27311390" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "patch_category_id_fk" AFTER DELETE ON "patch_category" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('patch_category_id_fk', 'patch', 'patch_category', 'FULL', 'patch_category_id', 'patch_category_id');
-
---
--- TOC Entry ID 512 (OID 27311393)
---
--- Name: "RI_ConstraintTrigger_27311392" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "patch_category_id_fk" AFTER UPDATE ON "patch_category" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('patch_category_id_fk', 'patch', 'patch_category', 'FULL', 'patch_category_id', 'patch_category_id');
-
---
--- TOC Entry ID 508 (OID 27311395)
---
--- Name: "RI_ConstraintTrigger_27311394" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "patch_submitted_by_fk" AFTER INSERT OR UPDATE ON "patch" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('patch_submitted_by_fk', 'patch', 'users', 'FULL', 'submitted_by', 'user_id');
-
---
--- TOC Entry ID 549 (OID 27311397)
---
--- Name: "RI_ConstraintTrigger_27311396" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "patch_submitted_by_fk" AFTER DELETE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('patch_submitted_by_fk', 'patch', 'users', 'FULL', 'submitted_by', 'user_id');
-
---
--- TOC Entry ID 550 (OID 27311399)
---
--- Name: "RI_ConstraintTrigger_27311398" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "patch_submitted_by_fk" AFTER UPDATE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('patch_submitted_by_fk', 'patch', 'users', 'FULL', 'submitted_by', 'user_id');
-
---
--- TOC Entry ID 507 (OID 27311401)
---
--- Name: "RI_ConstraintTrigger_27311400" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "patch_assigned_to_fk" AFTER INSERT OR UPDATE ON "patch" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('patch_assigned_to_fk', 'patch', 'users', 'FULL', 'assigned_to', 'user_id');
-
---
--- TOC Entry ID 551 (OID 27311403)
---
--- Name: "RI_ConstraintTrigger_27311402" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "patch_assigned_to_fk" AFTER DELETE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('patch_assigned_to_fk', 'patch', 'users', 'FULL', 'assigned_to', 'user_id');
-
---
--- TOC Entry ID 552 (OID 27311405)
---
--- Name: "RI_ConstraintTrigger_27311404" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "patch_assigned_to_fk" AFTER UPDATE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('patch_assigned_to_fk', 'patch', 'users', 'FULL', 'assigned_to', 'user_id');
-
---
--- TOC Entry ID 511 (OID 27311407)
---
--- Name: "RI_ConstraintTrigger_27311406" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "patch_category_group_id_fk" AFTER INSERT OR UPDATE ON "patch_category" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('patch_category_group_id_fk', 'patch_category', 'groups', 'FULL', 'group_id', 'group_id');
-
---
--- TOC Entry ID 496 (OID 27311409)
---
--- Name: "RI_ConstraintTrigger_27311408" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "patch_category_group_id_fk" AFTER DELETE ON "groups" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('patch_category_group_id_fk', 'patch_category', 'groups', 'FULL', 'group_id', 'group_id');
-
---
--- TOC Entry ID 495 (OID 27311411)
---
--- Name: "RI_ConstraintTrigger_27311410" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "patch_category_group_id_fk" AFTER UPDATE ON "groups" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('patch_category_group_id_fk', 'patch_category', 'groups', 'FULL', 'group_id', 'group_id');
-
---
--- TOC Entry ID 527 (OID 27311413)
---
--- Name: "RI_ConstraintTrigger_27311412" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "support_status_id_fk" AFTER INSERT OR UPDATE ON "support" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('support_status_id_fk', 'support', 'support_status', 'FULL', 'support_status_id', 'support_status_id');
-
---
--- TOC Entry ID 532 (OID 27311415)
---
--- Name: "RI_ConstraintTrigger_27311414" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "support_status_id_fk" AFTER DELETE ON "support_status" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('support_status_id_fk', 'support', 'support_status', 'FULL', 'support_status_id', 'support_status_id');
-
---
--- TOC Entry ID 531 (OID 27311417)
---
--- Name: "RI_ConstraintTrigger_27311416" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "support_status_id_fk" AFTER UPDATE ON "support_status" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('support_status_id_fk', 'support', 'support_status', 'FULL', 'support_status_id', 'support_status_id');
-
---
--- TOC Entry ID 526 (OID 27311419)
---
--- Name: "RI_ConstraintTrigger_27311418" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "support_category_id_fk" AFTER INSERT OR UPDATE ON "support" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('support_category_id_fk', 'support', 'support_category', 'FULL', 'support_category_id', 'support_category_id');
-
---
--- TOC Entry ID 530 (OID 27311421)
---
--- Name: "RI_ConstraintTrigger_27311420" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "support_category_id_fk" AFTER DELETE ON "support_category" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('support_category_id_fk', 'support', 'support_category', 'FULL', 'support_category_id', 'support_category_id');
-
---
--- TOC Entry ID 529 (OID 27311423)
---
--- Name: "RI_ConstraintTrigger_27311422" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "support_category_id_fk" AFTER UPDATE ON "support_category" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('support_category_id_fk', 'support', 'support_category', 'FULL', 'support_category_id', 'support_category_id');
-
---
--- TOC Entry ID 525 (OID 27311425)
---
--- Name: "RI_ConstraintTrigger_27311424" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "support_submitted_by_fk" AFTER INSERT OR UPDATE ON "support" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('support_submitted_by_fk', 'support', 'users', 'FULL', 'submitted_by', 'user_id');
-
---
--- TOC Entry ID 553 (OID 27311427)
---
--- Name: "RI_ConstraintTrigger_27311426" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "support_submitted_by_fk" AFTER DELETE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('support_submitted_by_fk', 'support', 'users', 'FULL', 'submitted_by', 'user_id');
-
---
--- TOC Entry ID 554 (OID 27311429)
---
--- Name: "RI_ConstraintTrigger_27311428" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "support_submitted_by_fk" AFTER UPDATE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('support_submitted_by_fk', 'support', 'users', 'FULL', 'submitted_by', 'user_id');
-
---
--- TOC Entry ID 524 (OID 27311431)
---
--- Name: "RI_ConstraintTrigger_27311430" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "support_assigned_to_fk" AFTER INSERT OR UPDATE ON "support" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('support_assigned_to_fk', 'support', 'users', 'FULL', 'assigned_to', 'user_id');
-
---
--- TOC Entry ID 555 (OID 27311433)
---
--- Name: "RI_ConstraintTrigger_27311432" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "support_assigned_to_fk" AFTER DELETE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('support_assigned_to_fk', 'support', 'users', 'FULL', 'assigned_to', 'user_id');
-
---
--- TOC Entry ID 556 (OID 27311435)
---
--- Name: "RI_ConstraintTrigger_27311434" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "support_assigned_to_fk" AFTER UPDATE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('support_assigned_to_fk', 'support', 'users', 'FULL', 'assigned_to', 'user_id');
-
---
--- TOC Entry ID 528 (OID 27311437)
---
--- Name: "RI_ConstraintTrigger_27311436" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "support_category_group_id_fk" AFTER INSERT OR UPDATE ON "support_category" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('support_category_group_id_fk', 'support_category', 'groups', 'FULL', 'group_id', 'group_id');
-
---
--- TOC Entry ID 494 (OID 27311439)
---
--- Name: "RI_ConstraintTrigger_27311438" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "support_category_group_id_fk" AFTER DELETE ON "groups" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('support_category_group_id_fk', 'support_category', 'groups', 'FULL', 'group_id', 'group_id');
-
---
--- TOC Entry ID 493 (OID 27311441)
---
--- Name: "RI_ConstraintTrigger_27311440" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "support_category_group_id_fk" AFTER UPDATE ON "groups" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('support_category_group_id_fk', 'support_category', 'groups', 'FULL', 'group_id', 'group_id');
-
---
--- TOC Entry ID 557 (OID 27311443)
---
--- Name: "RI_ConstraintTrigger_27311442" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "users_languageid_fk" AFTER INSERT OR UPDATE ON "users" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('users_languageid_fk', 'users', 'supported_languages', 'FULL', 'language', 'language_id');
-
---
--- TOC Entry ID 534 (OID 27311445)
---
--- Name: "RI_ConstraintTrigger_27311444" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "users_languageid_fk" AFTER DELETE ON "supported_languages" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('users_languageid_fk', 'users', 'supported_languages', 'FULL', 'language', 'language_id');
-
---
--- TOC Entry ID 533 (OID 27311447)
---
--- Name: "RI_ConstraintTrigger_27311446" Type: TRIGGER Owner: tperdue
---
-
CREATE CONSTRAINT TRIGGER "users_languageid_fk" AFTER UPDATE ON "supported_languages" NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('users_languageid_fk', 'users', 'supported_languages', 'FULL', 'language', 'language_id');
---
--- TOC Entry ID 3 (OID 18138427)
---
--- Name: "bug_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"bug_pk_seq"', 125359, 't');
-
---
--- TOC Entry ID 5 (OID 18138495)
---
--- Name: "bug_bug_dependencies_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"bug_bug_dependencies_pk_seq"', 44691, 't');
-
---
--- TOC Entry ID 7 (OID 18138531)
---
--- Name: "bug_canned_responses_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"bug_canned_responses_pk_seq"', 100204, 't');
-
---
--- TOC Entry ID 9 (OID 18138582)
---
--- Name: "bug_category_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"bug_category_pk_seq"', 5053, 't');
-
---
--- TOC Entry ID 11 (OID 18138632)
---
--- Name: "bug_filter_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"bug_filter_pk_seq"', 140, 't');
-
---
--- TOC Entry ID 13 (OID 18138687)
---
--- Name: "bug_group_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"bug_group_pk_seq"', 2780, 't');
-
---
--- TOC Entry ID 15 (OID 18138738)
---
--- Name: "bug_history_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"bug_history_pk_seq"', 106196, 't');
-
---
--- TOC Entry ID 17 (OID 18138794)
---
--- Name: "bug_resolution_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"bug_resolution_pk_seq"', 101, 't');
-
---
--- TOC Entry ID 19 (OID 18138843)
---
--- Name: "bug_status_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"bug_status_pk_seq"', 100, 't');
-
---
--- TOC Entry ID 21 (OID 18138891)
---
--- Name: "bug_task_dependencies_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"bug_task_dependencies_pk_seq"', 44583, 't');
-
---
--- TOC Entry ID 23 (OID 18138927)
---
--- Name: "canned_responses_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"canned_responses_pk_seq"', 5, 't');
-
---
--- TOC Entry ID 25 (OID 18138977)
---
--- Name: "db_images_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"db_images_pk_seq"', 1128, 't');
-
---
--- TOC Entry ID 27 (OID 18139040)
---
--- Name: "doc_data_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"doc_data_pk_seq"', 2124, 't');
-
---
--- TOC Entry ID 29 (OID 18139104)
---
--- Name: "doc_groups_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"doc_groups_pk_seq"', 1815, 't');
-
---
--- TOC Entry ID 31 (OID 18139140)
---
--- Name: "doc_states_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"doc_states_pk_seq"', 5, 't');
-
---
--- TOC Entry ID 33 (OID 18139174)
---
--- Name: "filemodule_monitor_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"filemodule_monitor_pk_seq"', 312, 't');
-
---
--- TOC Entry ID 35 (OID 18139210)
---
--- Name: "forum_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"forum_pk_seq"', 84486, 't');
-
---
--- TOC Entry ID 37 (OID 18139291)
---
--- Name: "forum_group_list_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"forum_group_list_pk_seq"', 51981, 't');
-
---
--- TOC Entry ID 39 (OID 18139348)
---
--- Name: "forum_monitored_forums_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"forum_monitored_forums_pk_seq"', 14831, 't');
-
---
--- TOC Entry ID 41 (OID 18139384)
---
--- Name: "forum_saved_place_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"forum_saved_place_pk_seq"', 1835, 't');
-
---
--- TOC Entry ID 43 (OID 18139492)
---
--- Name: "foundry_news_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"foundry_news_pk_seq"', 1973, 't');
-
---
--- TOC Entry ID 45 (OID 18139532)
---
--- Name: "foundry_preferred_projec_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"foundry_preferred_projec_pk_seq"', 165, 't');
-
---
--- TOC Entry ID 47 (OID 18139570)
---
--- Name: "foundry_projects_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"foundry_projects_pk_seq"', 320807, 't');
-
---
--- TOC Entry ID 49 (OID 18139695)
---
--- Name: "frs_file_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"frs_file_pk_seq"', 29214, 't');
-
---
--- TOC Entry ID 51 (OID 18139756)
---
--- Name: "frs_filetype_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"frs_filetype_pk_seq"', 9999, 't');
-
---
--- TOC Entry ID 53 (OID 18139804)
---
--- Name: "frs_package_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"frs_package_pk_seq"', 12688, 't');
-
---
--- TOC Entry ID 55 (OID 18139856)
---
--- Name: "frs_processor_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"frs_processor_pk_seq"', 9999, 't');
-
---
--- TOC Entry ID 57 (OID 18139904)
---
--- Name: "frs_release_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"frs_release_pk_seq"', 17983, 't');
-
---
--- TOC Entry ID 59 (OID 18139964)
---
--- Name: "frs_status_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"frs_status_pk_seq"', 3, 't');
-
---
--- TOC Entry ID 61 (OID 18140012)
---
--- Name: "group_cvs_history_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"group_cvs_history_pk_seq"', 1, 'f');
-
---
--- TOC Entry ID 63 (OID 18140056)
---
--- Name: "group_history_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"group_history_pk_seq"', 29283, 't');
-
---
--- TOC Entry ID 65 (OID 18140112)
---
--- Name: "group_type_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"group_type_pk_seq"', 2, 't');
-
---
--- TOC Entry ID 67 (OID 18140160)
---
--- Name: "groups_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"groups_pk_seq"', 16379, 't');
-
---
--- TOC Entry ID 69 (OID 18140301)
---
--- Name: "mail_group_list_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"mail_group_list_pk_seq"', 7581, 't');
-
---
--- TOC Entry ID 71 (OID 18140359)
---
--- Name: "news_bytes_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"news_bytes_pk_seq"', 10299, 't');
-
---
--- TOC Entry ID 73 (OID 18140419)
---
--- Name: "patch_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"patch_pk_seq"', 102785, 't');
-
---
--- TOC Entry ID 75 (OID 18140483)
---
--- Name: "patch_category_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"patch_category_pk_seq"', 10607, 't');
-
---
--- TOC Entry ID 77 (OID 18140534)
---
--- Name: "patch_history_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"patch_history_pk_seq"', 9813, 't');
-
---
--- TOC Entry ID 79 (OID 18140590)
---
--- Name: "patch_status_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"patch_status_pk_seq"', 103, 't');
-
---
--- TOC Entry ID 81 (OID 18140638)
---
--- Name: "people_job_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"people_job_pk_seq"', 1641, 't');
-
---
--- TOC Entry ID 83 (OID 18140697)
---
--- Name: "people_job_category_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"people_job_category_pk_seq"', 102, 't');
-
---
--- TOC Entry ID 85 (OID 18140747)
---
--- Name: "people_job_inventory_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"people_job_inventory_pk_seq"', 1970, 't');
-
---
--- TOC Entry ID 87 (OID 18140787)
---
--- Name: "people_job_status_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"people_job_status_pk_seq"', 3, 't');
-
---
--- TOC Entry ID 89 (OID 18140835)
---
--- Name: "people_skill_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"people_skill_pk_seq"', 33, 't');
-
---
--- TOC Entry ID 91 (OID 18140884)
---
--- Name: "people_skill_inventory_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"people_skill_inventory_pk_seq"', 60179, 't');
-
---
--- TOC Entry ID 93 (OID 18140924)
---
--- Name: "people_skill_level_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"people_skill_level_pk_seq"', 5, 't');
-
---
--- TOC Entry ID 95 (OID 18140972)
---
--- Name: "people_skill_year_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"people_skill_year_pk_seq"', 5, 't');
-
---
--- TOC Entry ID 97 (OID 18141020)
---
--- Name: "project_assigned_to_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"project_assigned_to_pk_seq"', 30257, 't');
-
---
--- TOC Entry ID 99 (OID 18141110)
---
--- Name: "project_dependencies_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"project_dependencies_pk_seq"', 25231, 't');
-
---
--- TOC Entry ID 101 (OID 18141146)
---
--- Name: "project_group_list_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"project_group_list_pk_seq"', 6360, 't');
-
---
--- TOC Entry ID 103 (OID 18141200)
---
--- Name: "project_history_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"project_history_pk_seq"', 27347, 't');
-
---
--- TOC Entry ID 105 (OID 18141257)
---
--- Name: "project_metric_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"project_metric_pk_seq"', 13274, 't');
-
---
--- TOC Entry ID 107 (OID 18141292)
---
--- Name: "project_metric_tmp1_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"project_metric_tmp1_pk_seq"', 13274, 't');
-
---
--- TOC Entry ID 109 (OID 18141327)
---
--- Name: "project_metric_weekly_tm_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"project_metric_weekly_tm_pk_seq"', 2213, 't');
-
---
--- TOC Entry ID 111 (OID 18141363)
---
--- Name: "project_status_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"project_status_pk_seq"', 100, 't');
-
---
--- TOC Entry ID 113 (OID 18141412)
---
--- Name: "project_task_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"project_task_pk_seq"', 23295, 't');
-
---
--- TOC Entry ID 115 (OID 18141479)
---
--- Name: "project_weekly_metric_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"project_weekly_metric_pk_seq"', 2213, 't');
-
---
--- TOC Entry ID 117 (OID 18141534)
---
--- Name: "snippet_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"snippet_pk_seq"', 100501, 't');
-
---
--- TOC Entry ID 119 (OID 18141593)
---
--- Name: "snippet_package_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"snippet_package_pk_seq"', 100035, 't');
-
---
--- TOC Entry ID 121 (OID 18141648)
---
--- Name: "snippet_package_item_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"snippet_package_item_pk_seq"', 100100, 't');
-
---
--- TOC Entry ID 123 (OID 18141684)
---
--- Name: "snippet_package_version_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"snippet_package_version_pk_seq"', 100035, 't');
-
---
--- TOC Entry ID 125 (OID 18141739)
---
--- Name: "snippet_version_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"snippet_version_pk_seq"', 100662, 't');
-
---
--- TOC Entry ID 127 (OID 18142132)
---
--- Name: "support_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"support_pk_seq"', 109672, 't');
-
---
--- TOC Entry ID 129 (OID 18142196)
---
--- Name: "support_canned_responses_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"support_canned_responses_pk_seq"', 100088, 't');
-
---
--- TOC Entry ID 131 (OID 18142247)
---
--- Name: "support_category_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"support_category_pk_seq"', 10699, 't');
-
---
--- TOC Entry ID 133 (OID 18142298)
---
--- Name: "support_history_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"support_history_pk_seq"', 24027, 't');
-
---
--- TOC Entry ID 135 (OID 18142354)
---
--- Name: "support_messages_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"support_messages_pk_seq"', 122077, 't');
-
---
--- TOC Entry ID 137 (OID 18142407)
---
--- Name: "support_status_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"support_status_pk_seq"', 3, 't');
-
---
--- TOC Entry ID 139 (OID 18142455)
---
--- Name: "supported_languages_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"supported_languages_pk_seq"', 21, 't');
-
---
--- TOC Entry ID 141 (OID 18142506)
---
--- Name: "survey_question_types_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"survey_question_types_pk_seq"', 100, 't');
-
---
--- TOC Entry ID 143 (OID 18142555)
---
--- Name: "survey_questions_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"survey_questions_pk_seq"', 14662, 't');
-
---
--- TOC Entry ID 145 (OID 18142680)
---
--- Name: "surveys_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"surveys_pk_seq"', 11185, 't');
-
---
--- TOC Entry ID 147 (OID 18142735)
---
--- Name: "system_history_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"system_history_pk_seq"', 1, 'f');
-
---
--- TOC Entry ID 149 (OID 18142787)
---
--- Name: "system_machines_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"system_machines_pk_seq"', 1, 'f');
-
---
--- TOC Entry ID 151 (OID 18142836)
---
--- Name: "system_news_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"system_news_pk_seq"', 1, 'f');
-
---
--- TOC Entry ID 153 (OID 18142895)
---
--- Name: "system_services_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"system_services_pk_seq"', 1, 'f');
-
---
--- TOC Entry ID 155 (OID 18142944)
---
--- Name: "system_status_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"system_status_pk_seq"', 1, 'f');
-
---
--- TOC Entry ID 157 (OID 18143020)
---
--- Name: "themes_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"themes_pk_seq"', 2, 't');
-
---
--- TOC Entry ID 159 (OID 18143113)
---
--- Name: "trove_cat_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"trove_cat_pk_seq"', 281, 't');
-
---
--- TOC Entry ID 161 (OID 18143176)
---
--- Name: "trove_group_link_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"trove_group_link_pk_seq"', 111628, 't');
-
---
--- TOC Entry ID 163 (OID 18143216)
---
--- Name: "trove_treesums_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"trove_treesums_pk_seq"', 765, 't');
-
---
--- TOC Entry ID 165 (OID 18143286)
---
--- Name: "user_bookmarks_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"user_bookmarks_pk_seq"', 23482, 't');
-
---
--- TOC Entry ID 167 (OID 18143337)
---
--- Name: "user_diary_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"user_diary_pk_seq"', 892, 't');
-
---
--- TOC Entry ID 169 (OID 18143392)
---
--- Name: "user_diary_monitor_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"user_diary_monitor_pk_seq"', 521, 't');
-
---
--- TOC Entry ID 171 (OID 18143428)
---
--- Name: "user_group_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"user_group_pk_seq"', 27204, 't');
-
---
--- TOC Entry ID 173 (OID 18143484)
---
--- Name: "user_metric_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"user_metric_pk_seq"', 115, 't');
-
---
--- TOC Entry ID 175 (OID 18143530)
---
--- Name: "user_metric0_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"user_metric0_pk_seq"', 5, 't');
-
---
--- TOC Entry ID 177 (OID 18143608)
---
--- Name: "users_pk_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"users_pk_seq"', 120800, 't');
-
---
--- TOC Entry ID 179 (OID 27311232)
---
--- Name: "unix_uid_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"unix_uid_seq"', 21044, 't');
-
---
--- TOC Entry ID 181 (OID 27311250)
---
--- Name: "forum_thread_seq" Type: SEQUENCE SET Owner:
---
-
-SELECT setval ('"forum_thread_seq"', 59698, 't');
-
--- /dev/null
+#!/usr/bin/perl -s
+#
+# cvsweb - a CGI interface to CVS trees.
+#
+# Written in their spare time by
+# Bill Fenner <fenner@freebsd.org> (original work)
+# extended by Henner Zeller <zeller@think.de>,
+# Henrik Nordström <hno@hem.passagen.se>
+# Ken Coar <coar@Apache.Org>
+# Dick Balaska <dick@buckosoft.com>
+# Jens-Uwe Mager <jum@helios.de>
+#
+# Based on:
+# * Bill Fenners cvsweb.cgi revision 1.28 available from:
+# http://www.freebsd.org/cgi/cvsweb.cgi/www/en/cgi/cvsweb.cgi
+#
+# Copyright (c) 1996-1998 Bill Fenner
+# (c) 1998-1999 Henner Zeller
+# (c) 1999 Henrik Nordström
+# All rights reserved.
+#
+# Redistribution and use in source and binary forms, with or without
+# modification, are permitted provided that the following conditions
+# are met:
+# 1. Redistributions of source code must retain the above copyright
+# notice, this list of conditions and the following disclaimer.
+# 2. Redistributions in binary form must reproduce the above copyright
+# notice, this list of conditions and the following disclaimer in the
+# documentation and/or other materials provided with the distribution.
+#
+# THIS SOFTWARE IS PROVIDED BY THE AUTHOR AND CONTRIBUTORS ``AS IS'' AND
+# ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
+# IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
+# ARE DISCLAIMED. IN NO EVENT SHALL THE AUTHOR OR CONTRIBUTORS BE LIABLE
+# FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL
+# DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS
+# OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION)
+# HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT
+# LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY
+# OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF
+# SUCH DAMAGE.
+#
+# $Id$
+#
+###
+
+use strict;
+
+use vars qw (
+ $config $allow_version_select $verbose
+ %CVSROOT %CVSROOTdescr %MIRRORS %DEFAULTVALUE %ICONS %MTYPES
+ %alltags @tabcolors %fileinfo %tags @branchnames %nameprinted
+ %symrev %revsym @allrevisions %date %author @revdisplayorder
+ @revisions %state %difflines %log %branchpoint @revorder $prcgi
+ $checkoutMagic $doCheckout $scriptname $scriptwhere
+ $where $Browser $nofilelinks $maycompress @stickyvars
+ %input $query $barequery $sortby $bydate $byrev $byauthor
+ $bylog $byfile $hr_default $logsort $cvstree $cvsroot
+ $mimetype $defaultTextPlain $defaultViewable $allow_compress
+ $GZIPBIN $backicon $diricon $fileicon $fullname $newname
+ $cvstreedefault $body_tag $logo $defaulttitle $address
+ $backcolor $long_intro $short_instruction $shortLogLen
+ $show_author $dirtable $tablepadding $columnHeaderColorDefault
+ $columnHeaderColorSorted $hr_breakable $hr_funout $hr_ignwhite
+ $hr_ignkeysubst $diffcolorHeading $diffcolorEmpty $diffcolorRemove
+ $diffcolorChange $diffcolorAdd $diffcolorDarkChange $difffontface
+ $difffontsize $inputTextSize $mime_types $allow_annotate
+ $allow_markup $use_java_script $open_extern_window
+ $extern_window_width $extern_window_height $edit_option_form
+ $checkout_magic $show_subdir_lastmod $show_log_in_markup $v
+ $navigationHeaderColor $tableBorderColor $markupLogColor
+ $tabstop $state $annTable $sel $curbranch @HideModules
+ $module $use_descriptions %descriptions @mytz $dwhere $moddate
+ $use_moddate $has_zlib $gzip_open
+ $allow_tar
+);
+
+##### Start of Configuration Area ########
+# == EDIT this ==
+# User configuration is stored in
+$config = $ENV{'CVSWEB_CONFIG'} || '/etc/sourceforge/cvsweb.conf';
+
+# == Configuration defaults ==
+# Defaults for configuration variables that shouldn't need
+# to be configured..
+$allow_version_select = 1;
+
+##### End of Configuration Area ########
+
+######## Configuration variables #########
+# These are defined to allow checking with perl -cw
+%CVSROOT = %MIRRORS = %DEFAULTVALUE = %ICONS = %MTYPES =
+%tags = %alltags = @tabcolors = ();
+$cvstreedefault = $body_tag = $logo = $defaulttitle = $address =
+$backcolor = $long_intro = $short_instruction = $shortLogLen =
+$show_author = $dirtable = $tablepadding = $columnHeaderColorDefault =
+$columnHeaderColorSorted = $hr_breakable = $hr_funout = $hr_ignwhite =
+$hr_ignkeysubst = $diffcolorHeading = $diffcolorEmpty = $diffcolorRemove =
+$diffcolorChange = $diffcolorAdd = $diffcolorDarkChange = $difffontface =
+$difffontsize = $inputTextSize = $mime_types = $allow_annotate =
+$allow_markup = $use_java_script = $open_extern_window =
+$extern_window_width = $extern_window_height = $edit_option_form =
+$checkout_magic = $show_subdir_lastmod = $show_log_in_markup = $v =
+$navigationHeaderColor = $tableBorderColor = $markupLogColor =
+$tabstop = $use_moddate = $moddate = $gzip_open = undef;
+
+##### End of configuration variables #####
+
+use Time::Local;
+use IPC::Open2;
+
+# Check if the zlib C library interface is installed, and if yes
+# we can avoid using the extra gzip process.
+eval {
+ require Compress::Zlib;
+};
+$has_zlib = !$@;
+
+$verbose = $v;
+$checkoutMagic = "~checkout~";
+$where = defined($ENV{'PATH_INFO'}) ? $ENV{'PATH_INFO'} : "";
+$where =~ tr|/|/|s;
+$doCheckout = ($where =~ /^\/$checkoutMagic/);
+$where =~ s|^/($checkoutMagic)?||;
+$where =~ s|/+$||;
+($scriptname = $ENV{'SCRIPT_NAME'}) =~ s|^/?|/|;
+$scriptname =~ s|/+$||;
+if ($where) {
+ $scriptwhere = $scriptname . '/' . urlencode($where);
+}
+else {
+ $scriptwhere = $scriptname;
+}
+$scriptwhere =~ s|/+$||;
+
+# in lynx, it it very annoying to have two links
+# per file, so disable the link at the icon
+# in this case:
+$Browser = $ENV{'HTTP_USER_AGENT'};
+$nofilelinks = ($Browser =~ m'^Lynx/');
+
+# newer browsers accept gzip content encoding
+# and state this in a header
+# (netscape did always but didn't state it)
+# It has been reported that these
+# braindamaged MS-Internet Exploders claim that they
+# accept gzip .. but don't in fact and
+# display garbage then :-/
+# Turn off gzip if running under mod_perl and no zlib is available,
+# piping does not work as expected inside the server.
+$maycompress = (((defined($ENV{'HTTP_ACCEPT_ENCODING'})
+ && $ENV{'HTTP_ACCEPT_ENCODING'} =~ m|gzip|)
+ || $Browser =~ m%^Mozilla/3%)
+ && ($Browser !~ m/MSIE/)
+ && !(defined($ENV{'MOD_PERL'}) && !$has_zlib));
+
+# put here the variables we need in order
+# to hold our state - they will be added (with
+# their current value) to any link/query string
+# you construct
+@stickyvars = ('cvsroot','hideattic','sortby','logsort','f','only_with_tag');
+
+if (-f $config) {
+ do "$config";
+}
+else {
+ &fatal("500 Internal Error",
+ 'Configuration not found. Set the variable <code>$config</code> '
+ . 'in cvsweb.cgi, or the environment variable '
+ . '<code>CVSWEB_CONFIG</code>, to your <b>cvsweb.conf</b> '
+ . 'configuration file first.');
+}
+
+undef %input;
+if ($query = $ENV{'QUERY_STRING'}) {
+ foreach (split(/&/, $query)) {
+ s/%(..)/sprintf("%c", hex($1))/ge; # unquote %-quoted
+ if (/(\S+)=(.*)/) {
+ $input{$1} = $2 if ($2 ne "");
+ }
+ else {
+ $input{$_}++;
+ }
+ }
+}
+
+# For backwards compability, set only_with_tag to only_on_branch if set.
+$input{only_with_tag} = $input{only_on_branch}
+ if (defined($input{only_on_branch}));
+
+foreach (keys %DEFAULTVALUE)
+{
+ # replace not given parameters with the default parameters
+ if (!defined($input{$_}) || $input{$_} eq "") {
+ # Empty Checkboxes in forms return -- nothing. So we define a helper
+ # variable in these forms (copt) which indicates that we just set
+ # parameters with a checkbox
+ if (!defined($input{"copt"})) {
+ # 'copt' isn't defined --> empty input is not the result
+ # of empty input checkbox --> set default
+ $input{$_} = $DEFAULTVALUE{$_} if (defined($DEFAULTVALUE{$_}));
+ }
+ else {
+ # 'copt' is defined -> the result of empty input checkbox
+ # -> set to zero (disable) if default is a boolean (0|1).
+ $input{$_} = 0
+ if (defined($DEFAULTVALUE{$_})
+ && ($DEFAULTVALUE{$_} eq "0" || $DEFAULTVALUE{$_} eq "1"));
+ }
+ }
+}
+
+$barequery = "";
+foreach (@stickyvars) {
+ # construct a query string with the sticky non default parameters set
+ if (defined($input{$_}) && ($input{$_} ne "") &&
+ (!defined($DEFAULTVALUE{$_}) || $input{$_} ne $DEFAULTVALUE{$_})) {
+ if ($barequery) {
+ $barequery = $barequery . "&";
+ }
+ my $thisval = urlencode($_) . "=" . urlencode($input{$_});
+ $barequery .= $thisval;
+ }
+}
+# is there any query ?
+if ($barequery) {
+ $query = "?$barequery";
+ $barequery = "&" . $barequery;
+}
+else {
+ $query = "";
+}
+
+# get actual parameters
+$sortby = $input{"sortby"};
+$bydate = 0;
+$byrev = 0;
+$byauthor = 0;
+$bylog = 0;
+$byfile = 0;
+if ($sortby eq "date") {
+ $bydate = 1;
+}
+elsif ($sortby eq "rev") {
+ $byrev = 1;
+}
+elsif ($sortby eq "author") {
+ $byauthor = 1;
+}
+elsif ($sortby eq "log") {
+ $bylog = 1;
+}
+else {
+ $byfile = 1;
+}
+
+$hr_default = $input{'f'} eq 'h';
+
+$logsort = $input{"logsort"};
+
+
+## Default CVS-Tree
+if (!defined($CVSROOT{$cvstreedefault})) {
+ &fatal("500 Internal Error",
+ "<code>\$cvstreedefault</code> points to a repository "
+ . "not defined in <code>%CVSROOT</code> "
+ . "(edit your configuration file $config)");
+}
+# $cvstree = $cvstreedefault . "/" . $input{'cvsroot'};
+$cvstree = $cvstreedefault;
+$cvsroot = $CVSROOT{"$cvstree"};
+
+# alternate CVS-Tree, configured in cvsweb.conf
+if ($input{'cvsroot'}) {
+ if ($CVSROOT{$input{'cvsroot'}}) {
+ $cvstree = $input{'cvsroot'};
+ $cvsroot = $CVSROOT{"$cvstree"};
+ }
+ $input{'cvsroot'} =~ s/\.//g; # we do not like dots
+ if ( -d ($CVSROOT{"$cvstree"} . "/" . $input{'cvsroot'}) ) {
+ $cvsroot = $CVSROOT{"$cvstree"} . "/" . $input{'cvsroot'};
+ } else {
+ &fatal("500 Internal Error", "<strong>no such project</strong>");
+ }
+}
+
+# create icons out of description
+foreach my $k (keys %ICONS) {
+ no strict 'refs';
+ my ($itxt,$ipath,$iwidth,$iheight) = @{$ICONS{$k}};
+ if ($ipath) {
+ $ {"${k}icon"} = "<IMG SRC=\"$ipath\" ALT=\"$itxt\" BORDER=\"0\" WIDTH=\"$iwidth\" HEIGHT=\"$iheight\">";
+ }
+ else {
+ $ {"${k}icon"} = $itxt;
+ }
+}
+
+# Do some special configuration for cvstrees
+do "$config-$cvstree" if (-f "$config-$cvstree");
+
+$fullname = $cvsroot . '/' . $where;
+$mimetype = &getMimeTypeFromSuffix ($fullname);
+$defaultTextPlain = ($mimetype eq "text/plain");
+$defaultViewable = $allow_markup && viewable($mimetype);
+
+# search for GZIP if compression allowed
+# We've to find out if the GZIP-binary exists .. otherwise
+# ge get an Internal Server Error if we try to pipe the
+# output through the nonexistent gzip ..
+# any more elegant ways to prevent this are welcome!
+if ($allow_compress && $maycompress && !$has_zlib) {
+ foreach (split(/:/, $ENV{PATH})) {
+ if (-x "$_/gzip") {
+ $GZIPBIN = "$_/gzip";
+ last;
+ }
+ }
+}
+
+if (-d $fullname) {
+ #
+ # ensure, that directories always end with (exactly) one '/'
+ # to allow relative URL's. If they're not, make a redirect.
+ ##
+ my $pathinfo = defined($ENV{'PATH_INFO'}) ? $ENV{'PATH_INFO'} : "";
+ if (!($pathinfo =~ m|/$|) || ($pathinfo =~ m |/{2,}$|)) {
+ redirect ($scriptwhere . '/' . $query);
+ }
+ else {
+ $where .= '/';
+ $scriptwhere .= '/';
+ }
+}
+
+if (!-d $cvsroot) {
+ &fatal("500 Internal Error",'$CVSROOT not found!<P>The server on which the CVS tree lives is probably down. Please try again in a few minutes.');
+}
+
+#
+# See if the module is in our forbidden list.
+#
+$where =~ m:([^/]*):;
+$module = $1;
+if ($module && &forbidden_module($module)) {
+ &fatal("403 Forbidden", "Access to $where forbidden.");
+}
+
+# Handle tarball downloads before any headers are output.
+if ($input{tarball}) {
+ &fatal("403 Forbidden", "Downloading tarballs is prohibited.")
+ unless $allow_tar;
+ $where=~s:[^/]*$::;
+ my ($basedir)=$where=~m!(?:.*/)?([^/]+)!;
+ my $tmpdir="/tmp/.cvsweb.$$.".int(time);
+ mkdir($tmpdir, 0700) ||
+ &fatal("500 Internal Error", "Unable to make temporary directory: $!");
+ chdir $tmpdir ||
+ &fatal("500 Internal Error", "Unable to cd to temporary directory: $!");
+ my @params=("-Q", "-d", $cvsroot, "co");
+ if (exists $input{only_with_tag} && length $input{only_with_tag}) {
+ push @params, ("-r", $input{only_with_tag});
+ }
+ system "cvs", @params, $where
+ || &fatal("500 Internal Error","cvs co failure: $!");
+ chdir $where."/.."
+ || &fatal("500 Internal Error","Cannot find expected directory in checkout");
+ $|=1; # Essential to get the buffering right.
+ print "Content-type: application/x-tar\r\n\r\n";
+ system "tar", "cz", $basedir, "--exclude", "CVS";
+ chdir $tmpdir || &fatal("500 Internal Error","Unable to cd to temporary directory: $!");
+ system "rm", "-rf", $tmpdir;
+ exit;
+}
+
+##############################
+# View a directory
+###############################
+elsif (-d $fullname) {
+ my $dh = do {local(*DH);};
+ opendir($dh, $fullname) || &fatal("404 Not Found","$where: $!");
+ my @dir = readdir($dh);
+ closedir($dh);
+ my @subLevelFiles = findLastModifiedSubdirs(@dir)
+ if ($show_subdir_lastmod);
+ getDirLogs($cvsroot,$where,@subLevelFiles);
+
+ if ($where eq '/') {
+ html_header("$defaulttitle");
+ print $long_intro;
+ }
+ else {
+ html_header("$where");
+ print $short_instruction;
+ }
+
+ my $descriptions;
+ if (($use_descriptions) && open (DESC, "<$cvsroot/CVSROOT/descriptions")) {
+ while (<DESC>) {
+ chomp;
+ my ($dir,$description) = /(\S+)\s+(.*)/;
+ $descriptions{$dir} = $description;
+ }
+ }
+
+ print "<P><a name=\"dirlist\"></a>\n";
+ # give direct access to dirs
+ if ($where eq '/') {
+ chooseMirror();
+ chooseCVSRoot();
+ }
+ else {
+ print "<p>Current directory: <b>", &clickablePath($where,0), "</b>\n";
+
+ print "<P>Current tag: <B>", $input{only_with_tag}, "</b>\n" if
+ $input{only_with_tag};
+
+ }
+
+
+ print "<HR NOSHADE>\n";
+ # Using <MENU> in this manner violates the HTML2.0 spec but
+ # provides the results that I want in most browsers. Another
+ # case of layout spooging up HTML.
+
+ my $infocols = 0;
+ if ($dirtable) {
+ if (defined($tableBorderColor)) {
+ # Can't this be done by defining the border for the inner table?
+ print "<table border=0 cellpadding=0 width=\"100%\"><tr><td bgcolor=\"$tableBorderColor\">";
+ }
+ print "<table width=\"100%\" border=0 cellspacing=1 cellpadding=$tablepadding>\n";
+ $infocols++;
+ print "<tr><th align=left bgcolor=\"" . (($byfile) ?
+ $columnHeaderColorSorted :
+ $columnHeaderColorDefault) . "\">";
+ print "<a href=\"./" . &toggleQuery("sortby","file") .
+ "#dirlist\">" if (!$byfile);
+ print "File";
+ print "</a>" if (!$byfile);
+ print "</th>";
+ # do not display the other column-headers, if we do not have any files
+ # with revision information:
+ if (scalar(%fileinfo)) {
+ $infocols++;
+ print "<th align=left bgcolor=\"" . (($byrev) ?
+ $columnHeaderColorSorted :
+ $columnHeaderColorDefault) . "\">";
+ print "<a href=\"./" . &toggleQuery ("sortby","rev") .
+ "#dirlist\">" if (!$byrev);
+ print "Rev.";
+ print "</a>" if (!$byrev);
+ print "</th>";
+ $infocols++;
+ print "<th align=left bgcolor=\"" . (($bydate) ?
+ $columnHeaderColorSorted :
+ $columnHeaderColorDefault) . "\">";
+ print "<a href=\"./" . &toggleQuery ("sortby","date") .
+ "#dirlist\">" if (!$bydate);
+ print "Age";
+ print "</a>" if (!$bydate);
+ print "</th>";
+ if ($show_author) {
+ $infocols++;
+ print "<th align=left bgcolor=\"" . (($byauthor) ?
+ $columnHeaderColorSorted :
+ $columnHeaderColorDefault) . "\">";
+ print "<a href=\"./" . &toggleQuery ("sortby","author") .
+ "#dirlist\">" if (!$byauthor);
+ print "Author";
+ print "</a>" if (!$byauthor);
+ print "</th>";
+ }
+ $infocols++;
+ print "<th align=left bgcolor=\"" . (($bylog) ?
+ $columnHeaderColorSorted :
+ $columnHeaderColorDefault) . "\">";
+ print "<a href=\"./", toggleQuery("sortby","log"), "#dirlist\">" if (!$bylog);
+ print "Last log entry";
+ print "</a>" if (!$bylog);
+ print "</th>";
+ }
+ elsif ($use_descriptions) {
+ print "<th align=left bgcolor=\"". $columnHeaderColorDefault . "\">";
+ print "Description";
+ $infocols++;
+ }
+ print "</tr>\n";
+ }
+ else {
+ print "<menu>\n";
+ }
+ my $dirrow = 0;
+
+ my $i;
+ lookingforattic:
+ for ($i = 0; $i <= $#dir; $i++) {
+ if ($dir[$i] eq "Attic") {
+ last lookingforattic;
+ }
+ }
+ if (!$input{'hideattic'} && ($i <= $#dir) &&
+ opendir($dh, $fullname . "/Attic")) {
+ splice(@dir, $i, 1,
+ grep((s|^|Attic/|,!m|/\.|), readdir($dh)));
+ closedir($dh);
+ }
+
+ my $hideAtticToggleLink = "<a href=\"./" .
+ &toggleQuery ("hideattic") .
+ "#dirlist\">[Hide]</a>" if (!$input{'hideattic'});
+
+ # Sort without the Attic/ pathname.
+ # place directories first
+
+ my $attic;
+ my $url;
+ my $fileurl;
+ my $filesexists;
+ my $filesfound;
+
+ foreach (sort { &fileSortCmp } @dir) {
+ if ($_ eq '.') {
+ next;
+ }
+ # ignore CVS lock and stale NFS files
+ next if (/^#cvs\.|^,|^\.nfs/);
+
+ # Check whether to show the CVSROOT path
+ next if ($input{'hidecvsroot'} && ($_ eq 'CVSROOT'));
+
+ # Check whether the module is in the restricted list
+ next if ($_ && &forbidden_module($_));
+
+ # Ignore non-readable files
+ next if ($input{'hidenonreadable'} && !(-r "$fullname/$_"));
+
+ if (s|^Attic/||) {
+ $attic = " (in the Attic) " . $hideAtticToggleLink;
+ }
+ else {
+ $attic = "";
+ }
+
+ if ($_ eq '..' || -d "$fullname/$_") {
+ next if ($_ eq '..' && $where eq '/');
+ my ($rev,$date,$log,$author,$filename);
+ ($rev,$date,$log,$author,$filename) = @{$fileinfo{$_}}
+ if (defined($fileinfo{$_}));
+ print "<tr bgcolor=\"" . @tabcolors[$dirrow%2] . "\"><td>" if ($dirtable);
+ if ($_ eq '..') {
+ $url = "../" . $query;
+ if ($nofilelinks) {
+ print $backicon;
+ }
+ else {
+ print &link($backicon,$url);
+ }
+ print " ", &link("Previous Directory",$url);
+ }
+ else {
+ $url = urlencode($_) . '/' . $query;
+ print "<A NAME=\"$_\"></A>";
+ if ($nofilelinks) {
+ print $diricon;
+ }
+ else {
+ print &link($diricon,$url);
+ }
+ print " ", &link($_ . "/", $url), $attic;
+ if ($_ eq "Attic") {
+ print " <a href=\"./" .
+ &toggleQuery ("hideattic") .
+ "#dirlist\">[Don't hide]</a>";
+ }
+ }
+ # Show last change in dir
+ if ($filename) {
+ print "</td><td> </td><td> " if ($dirtable);
+ if ($date) {
+ print " <i>" . readableTime(time() - $date,0) . "</i>";
+ }
+ if ($show_author) {
+ print "</td><td> " if ($dirtable);
+ print $author;
+ }
+ print "</td><td> " if ($dirtable);
+ $filename =~ s%^[^/]+/%%;
+ print "$filename/$rev";
+ print "<BR>" if ($dirtable);
+ if ($log) {
+ print " <font size=-1>"
+ . &htmlify(substr($log,0,$shortLogLen));
+ if (length $log > 80) {
+ print "...";
+ }
+ print "</font>";
+ }
+ }
+ else {
+ my ($dwhere) = ($where ne "/" ? $where : "") . $_;
+ if ($use_descriptions && defined $descriptions{$dwhere}) {
+ print "<TD COLSPAN=" . ($infocols-1) . "> " if $dirtable;
+ print $descriptions{$dwhere};
+ } elsif ($dirtable && $infocols > 1) {
+ # close the row with the appropriate number of
+ # columns, so that the vertical seperators are visible
+ my($cols) = $infocols;
+ while ($cols > 1) {
+ print "</td><td> ";
+ $cols--;
+ }
+ }
+ }
+ if ($dirtable) {
+ print "</td></tr>\n";
+ }
+ else {
+ print "<br>\n";
+ }
+ $dirrow++;
+ }
+ elsif (s/,v$//) {
+ $fileurl = ($attic ? "Attic/" : "") . urlencode($_);
+ $url = $fileurl . $query;
+ my $rev = '';
+ my $date = '';
+ my $log = '';
+ my $author = '';
+ $filesexists++;
+ next if (!defined($fileinfo{$_}));
+ ($rev,$date,$log,$author) = @{$fileinfo{$_}};
+ $filesfound++;
+ print "<tr bgcolor=\"" . @tabcolors[$dirrow%2] . "\"><td>" if ($dirtable);
+ print "<A NAME=\"$_\"></A>";
+ if ($nofilelinks) {
+ print $fileicon;
+ }
+ else {
+ print &link($fileicon,$url);
+ }
+ print " ", &link($_, $url), $attic;
+ print "</td><td> " if ($dirtable);
+ download_link($fileurl,
+ $rev, $rev,
+ $defaultViewable ? "text/x-cvsweb-markup" : undef);
+ print "</td><td> " if ($dirtable);
+ if ($date) {
+ print " <i>" . readableTime(time() - $date,0) . "</i>";
+ }
+ if ($show_author) {
+ print "</td><td> " if ($dirtable);
+ print $author;
+ }
+ print "</td><td> " if ($dirtable);
+ if ($log) {
+ print " <font size=-1>" . &htmlify(substr($log,0,$shortLogLen));
+ if (length $log > 80) {
+ print "...";
+ }
+ print "</font>";
+ }
+ print "</td>" if ($dirtable);
+ print (($dirtable) ? "</tr>" : "<br>");
+ $dirrow++;
+ }
+ print "\n";
+ }
+ if ($dirtable && defined($tableBorderColor)) {
+ print "</td></tr></table>";
+ }
+ print "". ($dirtable == 1) ? "</table>" : "</menu>" . "\n";
+
+ if ($filesexists && !$filesfound) {
+ print "<P><B>NOTE:</B> There are $filesexists files, but none matches the current tag ($input{only_with_tag})\n";
+ }
+ if ($input{only_with_tag} && (!%tags || !$tags{$input{only_with_tag}})) {
+ %tags = %alltags
+ }
+ if (scalar %tags
+ || $input{only_with_tag}
+ || $edit_option_form
+ || defined($input{"options"})) {
+ print "<hr size=1 NOSHADE>";
+ }
+
+ if (scalar %tags || $input{only_with_tag}) {
+ print "<FORM METHOD=\"GET\" ACTION=\"./\">\n";
+ foreach my $var (@stickyvars) {
+ print "<INPUT TYPE=HIDDEN NAME=\"$var\" VALUE=\"$input{$var}\">\n"
+ if (defined($input{$var})
+ && (!defined($DEFAULTVALUE{$var})
+ || $input{$var} ne $DEFAULTVALUE{$var})
+ && $input{$var} ne ""
+ && $var ne "only_with_tag");
+ }
+ print "Show only files with tag:\n";
+ print "<SELECT NAME=only_with_tag";
+ print " onchange=\"submit()\"" if ($use_java_script);
+ print ">";
+ print "<OPTION VALUE=\"\">All tags / default branch\n";
+ foreach my $tag (reverse sort { lc $a cmp lc $b } keys %tags) {
+ print "<OPTION",defined($input{only_with_tag}) &&
+ $input{only_with_tag} eq $tag ? " SELECTED":"",
+ ">$tag\n";
+ }
+ print "</SELECT>\n";
+ print "<INPUT TYPE=SUBMIT VALUE=\"Go\">\n";
+ print "</FORM>\n";
+ }
+
+ if ($allow_tar) {
+ my ($basefile)=$where=~m!(?:.*/)?([^/]+)!;
+ print &link("Download tarball",
+ # Mangle the filename so browsers show a reasonable
+ # filename to download.
+ "$basefile.tar.gz$query".
+ ($query ? "&" : "?")."tarball=1")
+ }
+
+ my $formwhere = $scriptwhere;
+ $formwhere =~ s|Attic/?$|| if ($input{'hideattic'});
+
+ if ($edit_option_form || defined($input{"options"})) {
+ print "<FORM METHOD=\"GET\" ACTION=\"${formwhere}\">\n";
+ print "<INPUT TYPE=HIDDEN NAME=\"copt\" VALUE=\"1\">\n";
+ if ($cvstree ne $cvstreedefault) {
+ print "<INPUT TYPE=HIDDEN NAME=\"cvsroot\" VALUE=\"$cvstree\">\n";
+ }
+ print "<center><table cellpadding=0 cellspacing=0>";
+ print "<tr bgcolor=\"$columnHeaderColorDefault\"><th colspan=2>Preferences</th></tr>";
+ print "<tr><td>Sort files by <SELECT name=\"sortby\">";
+ print "<OPTION VALUE=\"\">File";
+ print "<OPTION",$bydate ? " SELECTED" : ""," VALUE=date>Age";
+ print "<OPTION",$byauthor ? " SELECTED" : ""," VALUE=author>Author"
+ if ($show_author);
+ print "<OPTION",$byrev ? " SELECTED" : ""," VALUE=rev>Revision";
+ print "<OPTION",$bylog ? " SELECTED" : ""," VALUE=log>Log message";
+ print "</SELECT></td>";
+ print "<td>revisions by: \n";
+ print "<SELECT NAME=logsort>\n";
+ print "<OPTION VALUE=cvs",$logsort eq "cvs" ? " SELECTED" : "", ">Not sorted";
+ print "<OPTION VALUE=date",$logsort eq "date" ? " SELECTED" : "", ">Commit date";
+ print "<OPTION VALUE=rev",$logsort eq "rev" ? " SELECTED" : "", ">Revision";
+ print "</SELECT></td></tr>";
+ print "<tr><td>Diff format: ";
+ printDiffSelect();
+ print "</td>";
+ print "<td>Show Attic files: ";
+ print "<INPUT NAME=hideattic TYPE=CHECKBOX", $input{'hideattic'}?" CHECKED":"",
+ "></td></tr>\n";
+ print "<tr><td align=center colspan=2><input type=submit value=\"Change Options\">";
+ print "</td></tr></table></center></FORM>\n";
+ }
+ print &html_footer;
+ print "</BODY></HTML>\n";
+ }
+
+###############################
+# View Files
+###############################
+ elsif (-f $fullname . ',v') {
+ if (defined($input{'rev'}) || $doCheckout) {
+ &doCheckout($fullname, $input{'rev'});
+ gzipclose();
+ exit;
+ }
+ if (defined($input{'annotate'}) && $allow_annotate) {
+ &doAnnotate($input{'annotate'});
+ gzipclose();
+ exit;
+ }
+ if (defined($input{'r1'}) && defined($input{'r2'})) {
+ &doDiff($fullname, $input{'r1'}, $input{'tr1'},
+ $input{'r2'}, $input{'tr2'}, $input{'f'});
+ gzipclose();
+ exit;
+ }
+ print("going to dolog($fullname)\n") if ($verbose);
+ &doLog($fullname);
+##############################
+# View Diff
+##############################
+ }
+ elsif ($fullname =~ s/\.diff$// && -f $fullname . ",v" &&
+ $input{'r1'} && $input{'r2'}) {
+
+ # $where-diff-removal if 'cvs rdiff' is used
+ # .. but 'cvs rdiff'doesn't support some options
+ # rcsdiff does (-w and -p), so it is disabled
+ # $where =~ s/\.diff$//;
+
+ # Allow diffs using the ".diff" extension
+ # so that browsers that default to the URL
+ # for a save filename don't save diff's as
+ # e.g. foo.c
+ &doDiff($fullname, $input{'r1'}, $input{'tr1'},
+ $input{'r2'}, $input{'tr2'}, $input{'f'});
+ gzipclose();
+ exit;
+ }
+ elsif (($newname = $fullname) =~ s|/([^/]+)$|/Attic/$1| &&
+ -f $newname . ",v") {
+ # The file has been removed and is in the Attic.
+ # Send a redirect pointing to the file in the Attic.
+ (my $newplace = $scriptwhere) =~ s|/([^/]+)$|/Attic/$1|;
+ &redirect($newplace);
+ exit;
+ }
+ elsif (0 && (my @files = &safeglob($fullname . ",v"))) {
+ http_header("text/plain");
+ print "You matched the following files:\n";
+ print join("\n", @files);
+ # Find the tags from each file
+ # Display a form offering diffs between said tags
+ }
+ else {
+ my $fh = do {local(*FH);};
+ my ($xtra, $module);
+ # Assume it's a module name with a potential path following it.
+ $xtra = $& if (($module = $where) =~ s|/.*||);
+ # Is there an indexed version of modules?
+ if (open($fh, "$cvsroot/CVSROOT/modules")) {
+ while (<$fh>) {
+ if (/^(\S+)\s+(\S+)/o && $module eq $1
+ && -d "${cvsroot}/$2" && $module ne $2) {
+ &redirect($scriptname . '/' . $2 . $xtra);
+ }
+ }
+ }
+ &fatal("404 Not Found","$where: no such file or directory");
+ }
+
+gzipclose();
+## End MAIN
+
+sub printDiffSelect {
+ my ($use_java_script) = @_;
+ $use_java_script = 0 if (!defined($use_java_script));
+ my ($f) = $input{'f'};
+ print "<SELECT NAME=\"f\"";
+ print " onchange=\"submit()\"" if ($use_java_script);
+ print ">\n";
+ print "<OPTION VALUE=h",$f eq "h" ? " SELECTED" : "", ">Colored Diff";
+ print "<OPTION VALUE=H",$f eq "H" ? " SELECTED" : "", ">Long Colored Diff";
+ print "<OPTION VALUE=u",$f eq "u" ? " SELECTED" : "", ">Unidiff";
+ print "<OPTION VALUE=c",$f eq "c" ? " SELECTED" : "", ">Context Diff";
+ print "<OPTION VALUE=s",$f eq "s" ? " SELECTED" : "", ">Side by Side";
+ print "</SELECT>";
+}
+
+sub findLastModifiedSubdirs {
+ my (@dirs) = @_;
+ my ($dirname, @files);
+
+ foreach $dirname (@dirs) {
+ next if ($dirname eq ".");
+ next if ($dirname eq "..");
+ my ($dir) = "$fullname/$dirname";
+ next if (!-d $dir);
+
+ my ($lastmod) = undef;
+ my ($lastmodtime) = undef;
+ my $dh = do {local(*DH);};
+
+ opendir($dh,$dir) || next;
+ my (@filenames) = readdir($dh);
+ closedir($dh);
+
+ foreach my $filename (@filenames) {
+ $filename = "$dirname/$filename";
+ my ($file) = "$fullname/$filename";
+ next if ($filename !~ /,v$/ || !-f $file);
+ $filename =~ s/,v$//;
+ my $modtime = -M $file;
+ if (!defined($lastmod) || $modtime < $lastmodtime) {
+ $lastmod = $filename;
+ $lastmodtime = $modtime;
+ }
+ }
+ push(@files, $lastmod) if (defined($lastmod));
+ }
+ return @files;
+}
+
+sub htmlify {
+ my($string, $pr) = @_;
+
+ # Special Characters; RFC 1866
+ $string =~ s/&/&/g;
+ $string =~ s/\"/"/g;
+ $string =~ s/</</g;
+ $string =~ s/>/>/g;
+
+ # get URL's as link ..
+ $string =~ s§(http|ftp|https)(://[-a-zA-Z0-9%.~:_/]+)([?&]([-a-zA-Z0-9%.~:_]+)=([-a-zA-Z0-9%.~:_])+)*§<A HREF="$1$2$3">$1$2$3</A>§;
+ # get e-mails as link
+ $string =~ s§([-a-zA-Z0-9_.]+@([-a-zA-Z0-9]+\.)+[A-Za-z]{2,4})§<A HREF="mailto:$1">$1</A>§;
+
+ # get #PR as link ..
+ if ($pr && defined($prcgi)) {
+ $string =~ s!\b((pr[:#]?\s*#?)|((bin|conf|docs|gnu|i386|kern|misc|ports)\/))(\d+)\b!<A HREF="$prcgi?pr=$5">$&</A>!ig;
+ }
+
+ return $string;
+}
+
+sub spacedHtmlText {
+ my($string, $pr) = @_;
+
+ # Cut trailing spaces
+ s/\s+$//;
+
+ # Expand tabs
+ $string =~ s/\t+/' ' x (length($&) * $tabstop - length($`) % $tabstop)/e
+ if (defined($tabstop));
+
+ # replace <tab> and <space> (§ is to protect us from htmlify)
+ # gzip can make excellent use of this repeating pattern :-)
+ $string =~ s/§/§%/g; #protect our & substitute
+ if ($hr_breakable) {
+ # make every other space 'breakable'
+ $string =~ s/ / §nbsp; §nbsp; §nbsp; §nbsp;/g; # <tab>
+ $string =~ s/ / §nbsp;/g; # 2 * <space>
+ # leave single space as it is
+ }
+ else {
+ $string =~ s/ /§nbsp;§nbsp;§nbsp;§nbsp;§nbsp;§nbsp;§nbsp;§nbsp;/g;
+ $string =~ s/ /§nbsp;/g;
+ }
+
+ $string = htmlify($string);
+
+ # unescape
+ $string =~ s/§([^%])/&$1/g;
+ $string =~ s/§%/§/g;
+
+ return $string;
+}
+
+sub link {
+ my($name, $where) = @_;
+
+ $where =~ s| |%20|;
+ return "<A HREF=\"$where\">$name</A>\n";
+}
+
+sub revcmp {
+ my($rev1, $rev2) = @_;
+ my(@r1) = split(/\./, $rev1);
+ my(@r2) = split(/\./, $rev2);
+ my($a,$b);
+
+ while (($a = shift(@r1)) && ($b = shift(@r2))) {
+ if ($a != $b) {
+ return $a <=> $b;
+ }
+ }
+ if (@r1) { return 1; }
+ if (@r2) { return -1; }
+ return 0;
+}
+
+sub fatal {
+ my($errcode, $errmsg) = @_;
+ if (defined($ENV{'MOD_PERL'})) {
+ Apache->request->status((split(/ /, $errcode))[0]);
+ }
+ else {
+ print "Status: $errcode\n";
+ }
+ html_header("Error");
+ print "Error: $errmsg\n";
+ print &html_footer;
+ exit(1);
+}
+
+sub redirect {
+ my($url) = @_;
+ if (defined($ENV{'MOD_PERL'})) {
+ Apache->request->status(301);
+ Apache->request->header_out(Location => $url);
+ }
+ else {
+ print "Status: 301 Moved\r\n";
+ print "Location: $url\r\n";
+ }
+ html_header("Moved");
+ print "This document is located <A HREF=$url>here</A>.\n";
+ print &html_footer;
+ exit(1);
+}
+
+sub safeglob {
+ my ($filename) = @_;
+ my ($dirname);
+ my (@results);
+ my $dh = do {local(*DH);};
+
+ ($dirname = $filename) =~ s|/[^/]+$||;
+ $filename =~ s|.*/||;
+
+ if (opendir($dh, $dirname)) {
+ my $glob = $filename;
+ my $t;
+ # transform filename from glob to regex. Deal with:
+ # [, {, ?, * as glob chars
+ # make sure to escape all other regex chars
+ $glob =~ s/([\.\(\)\|\+])/\\$1/g;
+ $glob =~ s/\*/.*/g;
+ $glob =~ s/\?/./g;
+ $glob =~ s/{([^}]+)}/($t = $1) =~ s-,-|-g; "($t)"/eg;
+ foreach (readdir($dh)) {
+ if (/^${glob}$/) {
+ push(@results, $dirname . "/" .$_);
+ }
+ }
+ }
+
+ @results;
+}
+
+sub getMimeTypeFromSuffix {
+ my ($fullname) = @_;
+ my ($mimetype, $suffix);
+ my $fh = do {local(*FH);};
+
+ ($suffix = $fullname) =~ s/^.*\.([^.]*)$/$1/;
+ $mimetype = $MTYPES{$suffix};
+ $mimetype = $MTYPES{'*'} if (!$mimetype);
+
+ if (!$mimetype && -f $mime_types) {
+ # okey, this is something special - search the
+ # mime.types database
+ open ($fh, "<$mime_types");
+ while (<$fh>) {
+ if ($_ =~ /^\s*(\S+\/\S+).*\b$suffix\b/) {
+ $mimetype = $1;
+ last;
+ }
+ }
+ close ($fh);
+ }
+
+# okey, didn't find anything useful ..
+ if (!($mimetype =~ /\S\/\S/)) {
+ $mimetype = "text/plain";
+ }
+ return $mimetype;
+}
+
+###############################
+# show Annotation
+###############################
+sub doAnnotate ($$) {
+ my ($rev) = @_;
+ my ($pid);
+ my ($pathname, $filename);
+ my $reader = do {local(*FH);};
+ my $writer = do {local(*FH);};
+
+ # make sure the revisions a wellformed, for security
+ # reasons ..
+ if (!($rev =~ /^[\d\.]+$/)) {
+ &fatal("404 Not Found",
+ "Malformed query \"$ENV{'QUERY_STRING'}\"");
+ }
+
+ ($pathname = $where) =~ s/(Attic\/)?[^\/]*$//;
+ ($filename = $where) =~ s/^.*\///;
+
+ http_header();
+
+ navigateHeader ($scriptwhere,$pathname,$filename,$rev, "annotate");
+ print "<h3 align=center>Annotation of $pathname$filename, Revision $rev</h3>\n";
+
+ # this seems to be necessary
+ $| = 1; $| = 0; # Flush
+
+ # this annotate version is based on the
+ # cvs annotate-demo Perl script by Cyclic Software
+ # It was written by Cyclic Software, http://www.cyclic.com/, and is in
+ # the public domain.
+ # we could abandon the use of rlog, rcsdiff and co using
+ # the cvsserver in a similiar way one day (..after rewrite)
+ $pid = open2($reader, $writer, "cvs server") || fatal ("500 Internal Error",
+ "Fatal Error - unable to open cvs for annotation");
+
+ # OK, first send the request to the server. A simplified example is:
+ # Root /home/kingdon/zwork/cvsroot
+ # Argument foo/xx
+ # Directory foo
+ # /home/kingdon/zwork/cvsroot/foo
+ # Directory .
+ # /home/kingdon/zwork/cvsroot
+ # annotate
+ # although as you can see there are a few more details.
+
+ print $writer "Root $cvsroot\n";
+ print $writer "Valid-responses ok error Valid-requests Checked-in Updated Merged Removed M E\n";
+ # Don't worry about sending valid-requests, the server just needs to
+ # support "annotate" and if it doesn't, there isn't anything to be done.
+ print $writer "UseUnchanged\n";
+ print $writer "Argument -r\n";
+ print $writer "Argument $rev\n";
+ print $writer "Argument $where\n";
+
+ # The protocol requires us to fully fake a working directory (at
+ # least to the point of including the directories down to the one
+ # containing the file in question).
+ # So if $where is "dir/sdir/file", then @dirs will be ("dir","sdir","file")
+ my @dirs = split (/\//, $where);
+ my $path = "";
+ foreach (@dirs) {
+ if ($path eq "") {
+ # In our example, $_ is "dir".
+ $path = $_;
+ }
+ else {
+ print $writer "Directory " . $path . "\n";
+ print $writer "$cvsroot/" . $path ."\n";
+ # In our example, $_ is "sdir" and $path becomes "dir/sdir"
+ # And the next time, "file" and "dir/sdir/file" (which then gets
+ # ignored, because we don't need to send Directory for the file).
+ $path = $path . "/" . $_;
+ }
+ }
+ # And the last "Directory" before "annotate" is the top level.
+ print $writer "Directory .\n";
+ print $writer "$cvsroot\n";
+
+ print $writer "annotate\n";
+ # OK, we've sent our command to the server. Thing to do is to
+ # close the writer side and get all the responses. If "cvs server"
+ # were nicer about buffering, then we could just leave it open, I think.
+ close ($writer) || die "cannot close: $!";
+
+ # Ready to get the responses from the server.
+ # For example:
+ # E Annotations for foo/xx
+ # E ***************
+ # M 1.3 (kingdon 06-Sep-97): hello
+ # ok
+ my ($lineNr) = 0;
+ my ($oldLrev, $oldLusr) = ("", "");
+ my ($revprint, $usrprint);
+ if ($annTable) {
+ print "<table border=0 cellspacing=0 cellpadding=0>\n";
+ }
+ else {
+ print "<pre>";
+ }
+ while (<$reader>) {
+ my @words = split;
+ # Adding one is for the (single) space which follows $words[0].
+ my $rest = substr ($_, length ($words[0]) + 1);
+ if ($words[0] eq "E") {
+ next;
+ }
+ elsif ($words[0] eq "M") {
+ $lineNr++;
+ my $lrev = substr ($_, 2, 13);
+ my $lusr = substr ($_, 16, 9);
+ my $line = substr ($_, 36);
+ # we should parse the date here ..
+ if ($lrev eq $oldLrev) {
+ $revprint = " ";
+ }
+ else {
+ $revprint = $lrev; $oldLusr = "";
+ }
+ if ($lusr eq $oldLusr) {
+ $usrprint = " ";
+ }
+ else {
+ $usrprint = $lusr;
+ }
+ $oldLrev = $lrev;
+ $oldLusr = $lusr;
+ # is there a less timeconsuming way to strip spaces ?
+ ($lrev = $lrev) =~ s/\s+//g;
+ my $isCurrentRev = ("$rev" eq "$lrev");
+
+ print "<b>" if ($isCurrentRev);
+ printf ("%8s%s%8s %4d:", $revprint, ($isCurrentRev ? "|" : " "), $usrprint, $lineNr);
+ print spacedHtmlText($line);
+ print "</b>" if ($isCurrentRev);
+ }
+ elsif ($words[0] eq "ok") {
+ # We could complain about any text received after this, like the
+ # CVS command line client. But for simplicity, we don't.
+ }
+ elsif ($words[0] eq "error") {
+ fatal ("500 Internal Error", "Error occured during annotate: <b>$_</b>");
+ }
+ }
+ if ($annTable) {
+ print "</table>";
+ }
+ else {
+ print "</pre>";
+ }
+ close ($reader) || warn "cannot close: $!";
+ wait;
+}
+
+###############################
+# make Checkout
+###############################
+sub doCheckout {
+ my ($fullname, $rev) = @_;
+ my ($mimetype,$revopt);
+ my $fh = do {local(*FH);};
+
+ # make sure the revisions a wellformed, for security
+ # reasons ..
+ if (defined($rev) && !($rev =~ /^[\d\.]+$/)) {
+ &fatal("404 Not Found",
+ "Malformed query \"$ENV{'QUERY_STRING'}\"");
+ }
+
+ # get mimetype
+ if (defined($input{"content-type"}) && ($input{"content-type"} =~ /\S\/\S/)) {
+ $mimetype = $input{"content-type"}
+ }
+ else {
+ $mimetype = &getMimeTypeFromSuffix($fullname);
+ }
+
+ if (defined($rev)) {
+ $revopt = "-r$rev";
+ if ($use_moddate) {
+ readLog($fullname,$rev);
+ $moddate=$date{$rev};
+ }
+ }
+ else {
+ $revopt = "-rHEAD";
+ if ($use_moddate) {
+ readLog($fullname);
+ $moddate=$date{$symrev{HEAD}};
+ }
+ }
+
+ ### just for the record:
+ ### 'cvs co' seems to have a bug regarding single checkout of
+ ### directories/files having spaces in it;
+ ### this is an issue that should be resolved on cvs's side
+ #
+ # Safely for a child process to read from.
+ if (! open($fh, "-|")) { # child
+ open(STDERR, ">&STDOUT"); # Redirect stderr to stdout
+ exec("cvs", "-d", "$cvsroot", "co", "-p", "$revopt", "$where");
+ }
+#===================================================================
+#Checking out squid/src/ftp.c
+#RCS: /usr/src/CVS/squid/src/ftp.c,v
+#VERS: 1.1.1.28.6.2
+#***************
+
+ # Parse CVS header
+ my ($revision, $filename, $cvsheader);
+ while(<$fh>) {
+ last if (/^\*\*\*\*/);
+ $revision = $1 if (/^VERS: (.*)$/);
+ if (/^Checking out (.*)$/) {
+ $filename = $1;
+ $filename =~ s/^\.\/*//;
+ }
+ $cvsheader .= $_;
+ }
+ if (($filename ne $where) && ("/$filename" ne $where)) {
+ &fatal("500 Internal Error",
+ "Unexpected output from cvs co: $cvsheader"
+ . "<p><b>Check whether the directory $cvsroot/CVSROOT exists "
+ . "and the script has write-access to the CVSROOT/history "
+ . "file if it exists."
+ . "<br>The script needs to place lock files in the "
+ . "directory the file is in as well.</b>");
+ }
+ $| = 1;
+
+ if ($mimetype eq "text/x-cvsweb-markup") {
+ &cvswebMarkup($fh,$fullname,$revision);
+ }
+ else {
+ http_header($mimetype);
+ print <$fh>;
+ }
+ close($fh);
+}
+
+sub cvswebMarkup {
+ my ($filehandle,$fullname,$revision) = @_;
+ my ($pathname, $filename);
+
+ ($pathname = $where) =~ s/(Attic\/)?[^\/]*$//;
+ ($filename = $where) =~ s/^.*\///;
+ my ($fileurl) = urlencode($filename);
+
+ http_header();
+
+ navigateHeader ($scriptwhere, $pathname, $filename, $revision, "view");
+ print "<HR noshade>";
+ print "<table width=\"100%\"><tr><td bgcolor=\"$markupLogColor\">";
+ print "File: ", &clickablePath($where, 1);
+ print " ";
+ &download_link(urlencode($fileurl), $revision, "(download)");
+ if (!$defaultTextPlain) {
+ print " ";
+ &download_link(urlencode($fileurl), $revision, "(as text)",
+ "text/plain");
+ }
+ print "<BR>\n";
+ if ($show_log_in_markup) {
+ readLog($fullname); #,$revision);
+ printLog($revision,0);
+ }
+ else {
+ print "Version: <B>$revision</B><BR>\n";
+ print "Tag: <B>", $input{only_with_tag}, "</b><br>\n" if
+ $input{only_with_tag};
+ }
+ print "</td></tr></table>";
+ my @content = <$filehandle>;
+ my $url = download_url($fileurl, $revision, $mimetype);
+ print "<HR noshade>";
+ if ($mimetype =~ /^image/) {
+ print "<IMG SRC=\"$url$barequery\"><BR>";
+ }
+ elsif ($mimetype =~ m%^application/pdf%) {
+ print "<EMBED SRC=\"$url$barequery\" WIDTH=\"100%\"><BR>";
+ }
+ else {
+ print "<PRE>";
+ foreach (@content) {
+ print spacedHtmlText($_);
+ }
+ print "</PRE>";
+ }
+}
+
+sub viewable($) {
+ my ($mimetype) = @_;
+
+ $mimetype =~ m%^text/% ||
+ $mimetype =~ m%^image/% ||
+ $mimetype =~ m%^application/pdf% ||
+ 0;
+}
+
+###############################
+# Show Colored Diff
+###############################
+sub doDiff {
+ my($fullname, $r1, $tr1, $r2, $tr2, $f) = @_;
+ my $fh = do {local(*FH);};
+ my ($rev1, $rev2, $sym1, $sym2, @difftype, $diffname, $f1, $f2);
+
+ if ($r1 =~ /([^:]+)(:(.+))?/) {
+ $rev1 = $1;
+ $sym1 = $3;
+ }
+ if ($r1 eq 'text') {
+ $rev1 = $tr1;
+ $sym1 = "";
+ }
+ if ($r2 =~ /([^:]+)(:(.+))?/) {
+ $rev2 = $1;
+ $sym2 = $3;
+ }
+ if ($r2 eq 'text') {
+ $rev2 = $tr2;
+ $sym2 = "";
+ }
+ # make sure the revisions a wellformed, for security
+ # reasons ..
+ if (!($rev1 =~ /^[\d\.]+$/) || !($rev2 =~ /^[\d\.]+$/)) {
+ &fatal("404 Not Found",
+ "Malformed query \"$ENV{'QUERY_STRING'}\"");
+ }
+#
+# rev1 and rev2 are now both numeric revisions.
+# Thus we do a DWIM here and swap them if rev1 is after rev2.
+# XXX should we warn about the fact that we do this?
+ if (&revcmp($rev1,$rev2) > 0) {
+ my ($tmp1, $tmp2) = ($rev1, $sym1);
+ ($rev1, $sym1) = ($rev2, $sym2);
+ ($rev2, $sym2) = ($tmp1, $tmp2);
+ }
+ my $human_readable = 0;
+ if ($f eq 'c') {
+ @difftype = qw{-c};
+ $diffname = "Context diff";
+ }
+ elsif ($f eq 's') {
+ @difftype = qw{--side-by-side --width=164};
+ $diffname = "Side by Side";
+ }
+ elsif ($f eq 'H') {
+ $human_readable = 1;
+ @difftype = qw{--unified=15};
+ $diffname = "Long Human readable";
+ }
+ elsif ($f eq 'h') {
+ @difftype =qw{-u};
+ $human_readable = 1;
+ $diffname = "Human readable";
+ }
+ elsif ($f eq 'u') {
+ @difftype = qw{-u};
+ $diffname = "Unidiff";
+ }
+ else {
+ fatal ("400 Bad arguments", "Diff format $f not understood");
+ }
+
+ # apply special options
+ if ($human_readable) {
+ if ($hr_funout) {
+ push @difftype, '-p';
+ }
+ if ($hr_ignwhite) {
+ push @difftype, '-w';
+ }
+ if ($hr_ignkeysubst) {
+ push @difftype, '-kk';
+ }
+ }
+ if (! open($fh, "-|")) { # child
+ open(STDERR, ">&STDOUT"); # Redirect stderr to stdout
+ exec("rcsdiff",@difftype,"-r$rev1","-r$rev2",$fullname);
+ }
+ if ($human_readable) {
+ http_header();
+ &human_readable_diff($fh, $rev2);
+ gzipclose();
+ exit;
+ }
+ else {
+ http_header("text/plain");
+ }
+#
+#===================================================================
+#RCS file: /home/ncvs/src/sys/netinet/tcp_output.c,v
+#retrieving revision 1.16
+#retrieving revision 1.17
+#diff -c -r1.16 -r1.17
+#*** /home/ncvs/src/sys/netinet/tcp_output.c 1995/11/03 22:08:08 1.16
+#--- /home/ncvs/src/sys/netinet/tcp_output.c 1995/12/05 17:46:35 1.17
+#
+# Ideas:
+# - nuke the stderr output if it's what we expect it to be
+# - Add "no differences found" if the diff command supplied no output.
+#
+#*** src/sys/netinet/tcp_output.c 1995/11/03 22:08:08 1.16
+#--- src/sys/netinet/tcp_output.c 1995/12/05 17:46:35 1.17 RELENG_2_1_0
+# (bogus example, but...)
+#
+ if (grep { $_ eq '-u'} @difftype) {
+ $f1 = '---';
+ $f2 = '\+\+\+';
+ }
+ else {
+ $f1 = '\*\*\*';
+ $f2 = '---';
+ }
+ while (<$fh>) {
+ if (m|^$f1 $cvsroot|o) {
+ s|$cvsroot/||o;
+ if ($sym1) {
+ chop;
+ $_ .= " " . $sym1 . "\n";
+ }
+ }
+ elsif (m|^$f2 $cvsroot|o) {
+ s|$cvsroot/||o;
+ if ($sym2) {
+ chop;
+ $_ .= " " . $sym2 . "\n";
+ }
+ }
+ print $_;
+ }
+ close($fh);
+}
+
+###############################
+# Show Logs ..
+###############################
+sub getDirLogs {
+ my ($cvsroot,$dirname,@otherFiles) = @_;
+ my ($state,$otherFiles,$tag, $file, $date, $branchpoint, $branch, $log);
+ my ($rev, $revision, $revwanted, $filename, $head, $author);
+
+ $tag = $input{only_with_tag};
+
+ my ($DirName) = "$cvsroot/$where";
+ my (@files, @filetags);
+ my $fh = do {local(*FH);};
+
+ push(@files, &safeglob("$DirName/*,v"));
+ push(@files, &safeglob("$DirName/Attic/*,v")) if (!$input{'hideattic'});
+ foreach $file (@otherFiles) {
+ push(@files, "$DirName/$file");
+ }
+
+ # just execute rlog if there are any files
+ if ($#files < 0) {
+ return;
+ }
+
+ if ($tag) {
+ #can't use -r<tag> as - is allowed in tagnames, but misinterpreated by rlog..
+ if (! open($fh, "-|")) {
+ open(STDERR, "> /dev/null"); # rlog may complain; ignore.
+ exec("rlog",@files);
+ }
+ }
+ else {
+ my $kidpid = open($fh, "-|");
+ if (! $kidpid) {
+ open(STDERR, "> /dev/null"); # rlog may complain; ignore.
+ exec("rlog","-r",@files);
+ }
+ }
+ $state = "start";
+ while (<$fh>) {
+ if ($state eq "start") {
+ #Next file. Initialize file variables
+ $rev = undef;
+ $revwanted = undef;
+ $branch = undef;
+ $branchpoint = undef;
+ $filename = undef;
+ $log = undef;
+ $revision = undef;
+ $branch = undef;
+ %symrev = ();
+ @filetags = ();
+ #jump to head state
+ $state = "head";
+ }
+ print "$state:$_" if ($verbose);
+again:
+ if ($state eq "head") {
+ #$rcsfile = $1 if (/^RCS file: (.+)$/); #not used (yet)
+ $filename = $1 if (/^Working file: (.+)$/);
+ $head = $1 if (/^head: (.+)$/);
+ $branch = $1 if (/^branch: (.+)$/);
+ }
+ if ($state eq "head" && /^symbolic names/) {
+ $state = "tags";
+ ($branch = $head) =~ s/\.\d+$// if (!defined($branch));
+ $branch =~ s/(\.?)(\d+)$/${1}0.$2/;
+ $symrev{MAIN} = $branch;
+ $symrev{HEAD} = $branch;
+ $alltags{MAIN} = 1;
+ $alltags{HEAD} = 1;
+ push (@filetags, "MAIN", "HEAD");
+ next;
+ }
+ if ($state eq "tags" &&
+ /^\s+(.+):\s+([\d\.]+)\s+$/) {
+ push (@filetags, $1);
+ $symrev{$1} = $2;
+ $alltags{$1} = 1;
+ next;
+ }
+ if ($state eq "tags" && /^\S/) {
+ if (defined($tag) && (defined($symrev{$tag}) || $tag eq "HEAD")) {
+ $revwanted = $tag eq "HEAD" ? $symrev{"MAIN"} : $symrev{$tag};
+ ($branch = $revwanted) =~ s/\.0\././;
+ ($branchpoint = $branch) =~ s/\.?\d+$//;
+ $revwanted = undef if ($revwanted ne $branch);
+ }
+ elsif (defined($tag) && $tag ne "HEAD") {
+ print "Tag not found, skip this file" if ($verbose);
+ $state = "skip";
+ next;
+ }
+ foreach my $tagfound (@filetags) {
+ $tags{$tagfound} = 1;
+ }
+ $state = "head";
+ goto again;
+ }
+ if ($state eq "head" && /^----------------------------$/) {
+ $state = "log";
+ $rev = undef;
+ $date = undef;
+ $log = "";
+ # Try to reconstruct the relative filename if RCS spits out a full path
+ $filename =~ s%^\Q$DirName\E/%%;
+ next;
+ }
+ if ($state eq "log") {
+ if (/^----------------------------$/
+ || /^=============================/) {
+ # End of a log entry.
+ my $revbranch;
+ ($revbranch = $rev) =~ s/\.\d+$//;
+ print "$filename $rev Wanted: $revwanted "
+ . "Revbranch: $revbranch Branch: $branch "
+ . "Branchpoint: $branchpoint\n" if ($verbose);
+ if (!defined($revwanted) && defined($branch)
+ && $branch eq $revbranch || !defined($tag)) {
+ print "File revision $rev found for branch $branch\n"
+ if ($verbose);
+ $revwanted = $rev;
+ }
+ if (defined($revwanted) ? $rev eq $revwanted :
+ defined($branchpoint) ? $rev eq $branchpoint :
+ 0 && ($rev eq $head)) { # Don't think head is needed here..
+ print "File info $rev found for $filename\n" if ($verbose);
+ my @finfo = ($rev,$date,$log,$author,$filename);
+ my ($name);
+ ($name = $filename) =~ s%/.*%%;
+ $fileinfo{$name} = [ @finfo ];
+ $state = "done" if ($rev eq $revwanted);
+ }
+ $rev = undef;
+ $date = undef;
+ $log = "";
+ }
+ elsif (!defined($date) && m|^date:\s+(\d+)/(\d+)/(\d+)\s+(\d+):(\d+):(\d+);|) {
+ my $yr = $1;
+ # damn 2-digit year routines :-)
+ if ($yr > 100) {
+ $yr -= 1900;
+ }
+ $date = &Time::Local::timegm($6,$5,$4,$3,$2 - 1,$yr);
+ ($author) = /author: ([^;]+)/;
+ $state = "log";
+ $log = '';
+ next;
+ }
+ elsif (!defined($rev) && m/^revision (.*)$/) {
+ $rev = $1;
+ next;
+ }
+ else {
+ $log = $log . $_;
+ }
+ }
+ if (/^===============/) {
+ $state = "start";
+ next;
+ }
+ }
+ if ($. == 0) {
+ fatal("500 Internal Error",
+ "Failed to spawn GNU rlog on <em>'".join(", ", @files)."'</em><p>did you set the <b>\$ENV{PATH}</b> in your configuration file correctly ?");
+ }
+ close($fh);
+}
+
+sub readLog {
+ my($fullname,$revision) = @_;
+ my ($symnames, $head, $rev, $br, $brp, $branch, $branchrev);
+ my $fh = do {local(*FH);};
+
+ if (defined($revision)) {
+ $revision = "-r$revision";
+ }
+ else {
+ $revision = "";
+ }
+
+ undef %symrev;
+ undef %revsym;
+ undef @allrevisions;
+ undef %date;
+ undef %author;
+ undef %state;
+ undef %difflines;
+ undef %log;
+
+ print("Going to rlog '$fullname'\n") if ($verbose);
+ if (! open($fh, "-|")) { # child
+ if ($revision ne '') {
+ exec("rlog",$revision,$fullname);
+ }
+ else {
+ exec("rlog",$fullname);
+ }
+ }
+ while (<$fh>) {
+ print if ($verbose);
+ if ($symnames) {
+ if (/^\s+([^:]+):\s+([\d\.]+)/) {
+ $symrev{$1} = $2;
+ }
+ else {
+ $symnames = 0;
+ }
+ }
+ elsif (/^head:\s+([\d\.]+)/) {
+ $head = $1;
+ }
+ elsif (/^branch:\s+([\d\.]+)/) {
+ $curbranch = $1;
+ }
+ elsif (/^symbolic names/) {
+ $symnames = 1;
+ }
+ elsif (/^-----/) {
+ last;
+ }
+ }
+ ($curbranch = $head) =~ s/\.\d+$// if (!defined($curbranch));
+
+# each log entry is of the form:
+# ----------------------------
+# revision 3.7.1.1
+# date: 1995/11/29 22:15:52; author: fenner; state: Exp; lines: +5 -3
+# log info
+# ----------------------------
+ logentry:
+ while (!/^=========/) {
+ $_ = <$fh>;
+ last logentry if (!defined($_)); # EOF
+ print "R:", $_ if ($verbose);
+ if (/^revision ([\d\.]+)/) {
+ $rev = $1;
+ unshift(@allrevisions,$rev);
+ }
+ elsif (/^========/ || /^----------------------------$/) {
+ next logentry;
+ }
+ else {
+ # The rlog output is syntactically ambiguous. We must
+ # have guessed wrong about where the end of the last log
+ # message was.
+ # Since this is likely to happen when people put rlog output
+ # in their commit messages, don't even bother keeping
+ # these lines since we don't know what revision they go with
+ # any more.
+ next logentry;
+# &fatal("500 Internal Error","Error parsing RCS output: $_");
+ }
+ $_ = <$fh>;
+ print "D:", $_ if ($verbose);
+ if (m|^date:\s+(\d+)/(\d+)/(\d+)\s+(\d+):(\d+):(\d+);\s+author:\s+(\S+);\s+state:\s+(\S+);\s+(lines:\s+([0-9\s+-]+))?|) {
+ my $yr = $1;
+ # damn 2-digit year routines :-)
+ if ($yr > 100) {
+ $yr -= 1900;
+ }
+ $date{$rev} = &Time::Local::timegm($6,$5,$4,$3,$2 - 1,$yr);
+ $author{$rev} = $7;
+ $state{$rev} = $8;
+ $difflines{$rev} = $10;
+ }
+ else {
+ &fatal("500 Internal Error", "Error parsing RCS output: $_");
+ }
+ line:
+ while (<$fh>) {
+ print "L:", $_ if ($verbose);
+ next line if (/^branches:\s/);
+ last line if (/^----------------------------$/ || /^=========/);
+ $log{$rev} .= $_;
+ }
+ print "E:", $_ if ($verbose);
+ }
+ close($fh);
+ print "Done reading RCS file\n" if ($verbose);
+
+ @revorder = reverse sort {revcmp($a,$b)} @allrevisions;
+ print "Done sorting revisions",join(" ",@revorder),"\n" if ($verbose);
+
+#
+# HEAD is an artificial tag which is simply the highest tag number on the main
+# branch, unless there is a branch tag in the RCS file in which case it's the
+# highest revision on that branch. Find it by looking through @revorder; it
+# is the first commit listed on the appropriate branch.
+# This is not neccesary the same revision as marked as head in the RCS file.
+ my $headrev = $curbranch || "1";
+ ($symrev{"MAIN"} = $headrev) =~ s/(\.?)(\d+)$/${1}0.$2/;
+ revision:
+ foreach $rev (@revorder) {
+ if ($rev =~ /^(\S*)\.\d+$/ && $headrev eq $1) {
+ $symrev{"HEAD"} = $rev;
+ last revision;
+ }
+ }
+ ($symrev{"HEAD"} = $headrev) =~ s/\.\d+$//
+ if (!defined($symrev{"HEAD"}));
+ print "Done finding HEAD\n" if ($verbose);
+#
+# Now that we know all of the revision numbers, we can associate
+# absolute revision numbers with all of the symbolic names, and
+# pass them to the form so that the same association doesn't have
+# to be built then.
+#
+ undef @branchnames;
+ undef %branchpoint;
+ undef $sel;
+
+ foreach (reverse sort keys %symrev) {
+ $rev = $symrev{$_};
+ if ($rev =~ /^((.*)\.)0\.(\d+)$/) {
+ push(@branchnames, $_);
+ #
+ # A revision number of A.B.0.D really translates into
+ # "the highest current revision on branch A.B.D".
+ #
+ # If there is no branch A.B.D, then it translates into
+ # the head A.B .
+ #
+ # This reasoning also applies to the main branch A.B,
+ # with the branch number 0.A, with the exception that
+ # it has no head to translate to if there is nothing on
+ # the branch, but I guess this can never happen?
+ #
+ # Since some stupid people actually import/check in
+ # files with version 0.X we assume that the above cannot
+ # happen, and regard 0.X(.*) as a revision and not a branch.
+ #
+ $head = defined($2) ? $2 : "";
+ $branch = $3;
+ $branchrev = $head . ($head ne "" ? "." : "") . $branch;
+ my $regex;
+ ($regex = $branchrev) =~ s/\./\\./g;
+ $rev = $head;
+
+ revision:
+ foreach my $r (@revorder) {
+ if ($r =~ /^${regex}\b/) {
+ $rev = $branchrev;
+ last revision;
+ }
+ }
+ next if ($rev eq "");
+ if ($rev ne $head && $head ne "") {
+ $branchpoint{$head} .= ", " if ($branchpoint{$head});
+ $branchpoint{$head} .= $_;
+ }
+ }
+ $revsym{$rev} .= ", " if ($revsym{$rev});
+ $revsym{$rev} .= $_;
+ $sel .= "<OPTION VALUE=\"${rev}:${_}\">$_\n";
+ }
+ print "Done associating revisions with branches\n" if ($verbose);
+
+ my ($onlyonbranch, $onlybranchpoint);
+ if ($onlyonbranch = $input{'only_with_tag'}) {
+ $onlyonbranch = $symrev{$onlyonbranch};
+ if ($onlyonbranch =~ s/\.0\././) {
+ ($onlybranchpoint = $onlyonbranch) =~ s/\.\d+$//;
+ }
+ else {
+ $onlybranchpoint = $onlyonbranch;
+ }
+ if (!defined($onlyonbranch) || $onlybranchpoint eq "") {
+ fatal("404 Tag not found","Tag $input{'only_with_tag'} not defined");
+ }
+ }
+
+ undef @revisions;
+
+ foreach (@allrevisions) {
+ ($br = $_) =~ s/\.\d+$//;
+ ($brp = $br) =~ s/\.\d+$//;
+ next if ($onlyonbranch && $br ne $onlyonbranch &&
+ $_ ne $onlybranchpoint);
+ unshift(@revisions,$_);
+ }
+
+ if ($logsort eq "date") {
+ # Sort the revisions in commit order an secondary sort on revision
+ # (secondary sort needed for imported sources, or the first main
+ # revision gets before the same revision on the 1.1.1 branch)
+ @revdisplayorder = sort {$date{$b} <=> $date{$a} || -revcmp($a, $b)} @revisions;
+ }
+ elsif ($logsort eq "rev") {
+ # Sort the revisions in revision order, highest first
+ @revdisplayorder = reverse sort {revcmp($a,$b)} @revisions;
+ }
+ else {
+ # No sorting. Present in the same order as rlog / cvs log
+ @revdisplayorder = @revisions;
+ }
+
+}
+
+sub printLog($;$) {
+ my ($link, $br, $brp);
+ ($_,$link) = @_;
+ ($br = $_) =~ s/\.\d+$//;
+ ($brp = $br) =~ s/\.?\d+$//;
+ my ($isDead, $prev);
+
+ $link = 1 if (!defined($link));
+ $isDead = ($state{$_} eq "dead");
+
+ if ($link && !$isDead) {
+ my ($filename);
+ ($filename = $where) =~ s/^.*\///;
+ my ($fileurl) = urlencode($filename);
+ print "<a NAME=\"rev$_\"></a>";
+ if (defined($revsym{$_})) {
+ foreach my $sym (split(", ", $revsym{$_})) {
+ print "<a NAME=\"$sym\"></a>";
+ }
+ }
+ if (defined($revsym{$br}) && $revsym{$br} && !defined($nameprinted{$br})) {
+ foreach my $sym (split(", ", $revsym{$br})) {
+ print "<a NAME=\"$sym\"></a>";
+ }
+ $nameprinted{$br} = 1;
+ }
+ print "\n Revision ";
+ &download_link($fileurl, $_, $_,
+ $defaultViewable ? "text/x-cvsweb-markup" : undef);
+ if ($defaultViewable) {
+ print " / ";
+#print("<b>[$fileurl==$_==(download)==$mimetype]</b>");
+ &download_link($fileurl, $_, "(download)", $mimetype);
+ }
+ if (not $defaultTextPlain) {
+ print " / ";
+ &download_link($fileurl, $_, "(as text)",
+ "text/plain");
+ }
+ if (!$defaultViewable) {
+ print " / ";
+ &download_link($fileurl, $_, "(view)", "text/x-cvsweb-markup");
+ }
+ if ($allow_annotate) {
+ print " - <a href=\"" . $scriptname . "/" . urlencode($where) . "?annotate=$_$barequery\">";
+ print "annotate</a>";
+ }
+ # Plus a select link if enabled, and this version isn't selected
+ if ($allow_version_select) {
+ if ((!defined($input{"r1"}) || $input{"r1"} ne $_)) {
+ print " - <A HREF=\"${scriptwhere}?r1=$_$barequery" .
+ "\">[select for diffs]</A>\n";
+ }
+ else {
+ print " - <b>[selected]</b>";
+ }
+ }
+ }
+ else {
+ print "Revision <B>$_</B>";
+ }
+ if (/^1\.1\.1\.\d+$/) {
+ print " <i>(vendor branch)</i>";
+ }
+ if (defined @mytz) {
+ my ($est) = $mytz[(localtime($date{$_}))[8]];
+ print ", <i>" . scalar localtime($date{$_}) . " $est</i> (";
+ } else {
+ print ", <i>" . scalar gmtime($date{$_}) . " UTC</i> (";
+ }
+ print readableTime(time() - $date{$_},1) . " ago)";
+ print " by ";
+ print "<i>" . $author{$_} . "</i>\n";
+ print "<BR>Branch: <b>",$link?link_tags($revsym{$br}):$revsym{$br},"</b>\n"
+ if ($revsym{$br});
+ print "<BR>CVS Tags: <b>",$link?link_tags($revsym{$_}):$revsym{$_},"</b>"
+ if ($revsym{$_});
+ print "<BR>Branch point for: <b>",$link?link_tags($branchpoint{$_}):$branchpoint{$_},"</b>\n"
+ if ($branchpoint{$_});
+ # Find the previous revision
+ my @prevrev = split(/\./, $_);
+ do {
+ if (--$prevrev[$#prevrev] <= 0) {
+ # If it was X.Y.Z.1, just make it X.Y
+ pop(@prevrev);
+ pop(@prevrev);
+ }
+ $prev = join(".", @prevrev);
+ } until (defined($date{$prev}) || $prev eq "");
+ if ($prev ne "") {
+ if ($difflines{$_}) {
+ print "<BR>Changes since <b>$prev: $difflines{$_} lines</b>";
+ }
+ }
+ if ($isDead) {
+ print "<BR><B><I>FILE REMOVED</I></B>\n";
+ }
+ elsif ($link) {
+ my %diffrev = ();
+ $diffrev{$_} = 1;
+ $diffrev{""} = 1;
+ print "<BR>Diff";
+ #
+ # Offer diff to previous revision
+ if ($prev) {
+ $diffrev{$prev} = 1;
+ print " to previous <A HREF=\"${scriptwhere}.diff?r1=$prev";
+ print "&r2=$_" . $barequery . "\">$prev</A>\n";
+ if (!$hr_default) { # offer a human readable version if not default
+ print "(<A HREF=\"${scriptwhere}.diff?r1=$prev";
+ print "&r2=$_" . $barequery . "&f=h\">colored</A>)\n";
+ }
+ }
+ #
+ # Plus, if it's on a branch, and it's not a vendor branch,
+ # offer a diff with the branch point.
+ if ($revsym{$brp} && !/^1\.1\.1\.\d+$/ && !defined($diffrev{$brp})) {
+ print " to branchpoint <A HREF=\"${scriptwhere}.diff?r1=$brp";
+ print "&r2=$_" . $barequery . "\">$brp</A>\n";
+ if (!$hr_default) { # offer a human readable version if not default
+ print "(<A HREF=\"${scriptwhere}.diff?r1=$brp";
+ print "&r2=$_" . $barequery . "&f=h\">colored</A>)\n";
+ }
+ }
+ #
+ # Plus, if it's on a branch, and it's not a vendor branch,
+ # offer to diff with the next revision of the higher branch.
+ # (e.g. change gets committed and then brought
+ # over to -stable)
+ if (/^\d+\.\d+\.\d+/ && !/^1\.1\.1\.\d+$/) {
+ my ($i,$nextmain);
+ for ($i = 0; $i < $#revorder && $revorder[$i] ne $_; $i++){}
+ my (@tmp2) = split(/\./, $_);
+ for ($nextmain = ""; $i > 0; $i--) {
+ my ($next) = $revorder[$i-1];
+ my (@tmp1) = split(/\./, $next);
+ if ($#tmp1 < $#tmp2) {
+ $nextmain = $next;
+ last;
+ }
+ # Only the highest version on a branch should have
+ # a diff for the "next main".
+ last if (join(".",@tmp1[0..$#tmp1-1])
+ eq join(".",@tmp2[0..$#tmp1-1]));
+ }
+ if (!defined($diffrev{$nextmain})) {
+ $diffrev{$nextmain} = 1;
+ print " next main <A HREF=\"${scriptwhere}.diff?r1=$nextmain";
+ print "&r2=$_" . $barequery .
+ "\">$nextmain</A>\n";
+ if (!$hr_default) { # offer a human readable version if not default
+ print "(<A HREF=\"${scriptwhere}.diff?r1=$nextmain";
+ print "&r2=$_" . $barequery .
+ "&f=h\">colored</A>)\n";
+ }
+ }
+ }
+ # Plus if user has selected only r1, then present a link
+ # to make a diff to that revision
+ if (defined($input{"r1"}) && !defined($diffrev{$input{"r1"}})) {
+ $diffrev{$input{"r1"}} = 1;
+ print " to selected <A HREF=\"${scriptwhere}.diff?"
+ . "r1=$input{'r1'}&r2=$_" . $barequery
+ . "\">$input{'r1'}</A>\n";
+ if (!$hr_default) { # offer a human readable version if not default
+ print "(<A HREF=\"${scriptwhere}.diff?r1=$input{'r1'}";
+ print "&r2=$_" . $barequery .
+ "&f=h\">colored</A>)\n";
+
+ }
+ }
+ }
+ print "<PRE>\n";
+ print &htmlify($log{$_}, 1);
+ print "</PRE>\n";
+}
+
+sub doLog {
+ my($fullname) = @_;
+ my ($diffrev, $upwhere, $filename, $backurl);
+
+ readLog($fullname);
+
+ html_header("CVS log for $where");
+ ($upwhere = $where) =~ s|(Attic/)?[^/]+$||;
+ ($filename = $where) =~ s|^.*/||;
+ $backurl = $scriptname . "/" . urlencode($upwhere) . $query;
+ print &link($backicon, "$backurl#$filename"),
+ " <b>Up to ", &clickablePath($upwhere, 1), "</b><p>\n";
+ print "<A HREF=\"#diff\">Request diff between arbitrary revisions</A>\n";
+ print "<HR NOSHADE>\n";
+ if ($curbranch) {
+ print "Default branch: ";
+ print ($revsym{$curbranch} || $curbranch);
+ }
+ else {
+ print "No default branch";
+ }
+ print "<BR>\n";
+ if ($input{only_with_tag}) {
+ print "Current tag: $input{only_with_tag}<BR>\n";
+ }
+
+ undef %nameprinted;
+
+ for (my $i = 0; $i <= $#revdisplayorder; $i++) {
+ print "<HR size=1 NOSHADE>";
+ printLog($revdisplayorder[$i]);
+ }
+
+ print "<HR NOSHADE>";
+ print "<A NAME=diff>\n";
+ print "This form allows you to request diff's between any two\n";
+ print "revisions of a file. You may select a symbolic revision\n";
+ print "name using the selection box or you may type in a numeric\n";
+ print "name using the type-in text box.\n";
+ print "</A><P>\n";
+ print "<FORM METHOD=\"GET\" ACTION=\"${scriptwhere}.diff\" NAME=\"diff_select\">\n";
+ foreach (@stickyvars) {
+ print "<INPUT TYPE=HIDDEN NAME=\"$_\" VALUE=\"$input{$_}\">\n"
+ if (defined($input{$_})
+ && ((!defined($DEFAULTVALUE{$_})
+ || $input{$_} ne $DEFAULTVALUE{$_})
+ && $input{$_} ne ""));
+ }
+ print "Diffs between \n";
+ print "<SELECT NAME=\"r1\">\n";
+ print "<OPTION VALUE=\"text\" SELECTED>Use Text Field\n";
+ print $sel;
+ print "</SELECT>\n";
+ $diffrev = $revdisplayorder[$#revdisplayorder];
+ $diffrev = $input{"r1"} if (defined($input{"r1"}));
+ print "<INPUT TYPE=\"TEXT\" SIZE=\"$inputTextSize\" NAME=\"tr1\" VALUE=\"$diffrev\" onChange='document.diff_select.r1.selectedIndex=0'>\n";
+ print " and \n";
+ print "<SELECT NAME=\"r2\">\n";
+ print "<OPTION VALUE=\"text\" SELECTED>Use Text Field\n";
+ print $sel;
+ print "</SELECT>\n";
+ $diffrev = $revdisplayorder[0];
+ $diffrev = $input{"r2"} if (defined($input{"r2"}));
+ print "<INPUT TYPE=\"TEXT\" SIZE=\"$inputTextSize\" NAME=\"tr2\" VALUE=\"$diffrev\" onChange='document.diff_select.r2.selectedIndex=0'>\n";
+ print "<BR>Type of Diff should be a ";
+ printDiffSelect();
+ print "<INPUT TYPE=SUBMIT VALUE=\" Get Diffs \">\n";
+ print "</FORM>\n";
+ print "<HR noshade>\n";
+ if (@branchnames) {
+ print "<A name=branch></A>\n";
+ print "<FORM METHOD=\"GET\" ACTION=\"$scriptwhere\">\n";
+ foreach (@stickyvars) {
+ next if ($_ eq "only_with_tag");
+ next if ($_ eq "logsort");
+ print "<INPUT TYPE=HIDDEN NAME=\"$_\" VALUE=\"$input{$_}\">\n"
+ if (defined($input{$_})
+ && (!defined($DEFAULTVALUE{$_})
+ || $input{$_} ne $DEFAULTVALUE{$_})
+ && $input{$_} ne "");
+ }
+ print "View only Branch: \n";
+ print "<SELECT NAME=\"only_with_tag\"";
+ print " onchange=\"submit()\"" if ($use_java_script);
+ print ">\n";
+ print "<OPTION VALUE=\"\"";
+ print " SELECTED" if (defined($input{"only_with_tag"}) &&
+ $input{"only_with_tag"} eq "");
+ print ">Show all branches\n";
+ foreach (reverse sort @branchnames) {
+ print "<OPTION";
+ print " SELECTED" if (defined($input{"only_with_tag"})
+ && $input{"only_with_tag"} eq $_);
+ print ">${_}\n";
+ }
+ print "</SELECT>\n";
+ print "<INPUT TYPE=SUBMIT VALUE=\" View Branch \">\n";
+ print "</FORM>\n";
+ }
+ print "<A name=logsort></A>\n";
+ print "<FORM METHOD=\"GET\" ACTION=\"$scriptwhere\">\n";
+ foreach (@stickyvars) {
+ next if ($_ eq "only_with_tag");
+ next if ($_ eq "logsort");
+ print "<INPUT TYPE=HIDDEN NAME=\"$_\" VALUE=\"$input{$_}\">\n"
+ if (defined($input{$_})
+ && (!defined($DEFAULTVALUE{$_})
+ || $input{$_} ne $DEFAULTVALUE{$_})
+ && $input{$_} ne "");
+ }
+ print "Sort log by: \n";
+ print "<SELECT NAME=\"logsort\"";
+ print " onchange=\"submit()\"" if ($use_java_script);
+ print ">\n";
+ print "<OPTION VALUE=cvs",$logsort eq "cvs" ? " SELECTED" : "", ">Not sorted";
+ print "<OPTION VALUE=date",$logsort eq "date" ? " SELECTED" : "", ">Commit date";
+ print "<OPTION VALUE=rev",$logsort eq "rev" ? " SELECTED" : "", ">Revision";
+ print "</SELECT>\n";
+ print "<INPUT TYPE=SUBMIT VALUE=\" Sort \">\n";
+ print "</FORM>\n";
+ print &html_footer;
+ print "</BODY></HTML>\n";
+}
+
+sub flush_diff_rows ($$$$)
+{
+ my $j;
+ my ($leftColRef,$rightColRef,$leftRow,$rightRow) = @_;
+ if ($state eq "PreChangeRemove") { # we just got remove-lines before
+ for ($j = 0 ; $j < $leftRow; $j++) {
+ print "<tr><td bgcolor=\"$diffcolorRemove\">@$leftColRef[$j]</td>";
+ print "<td bgcolor=\"$diffcolorEmpty\"> </td></tr>\n";
+ }
+ }
+ elsif ($state eq "PreChange") { # state eq "PreChange"
+ # we got removes with subsequent adds
+ for ($j = 0; $j < $leftRow || $j < $rightRow ; $j++) { # dump out both cols
+ print "<tr>";
+ if ($j < $leftRow) {
+ print "<td bgcolor=\"$diffcolorChange\">@$leftColRef[$j]</td>";
+ }
+ else {
+ print "<td bgcolor=\"$diffcolorDarkChange\"> </td>";
+ }
+ if ($j < $rightRow) {
+ print "<td bgcolor=\"$diffcolorChange\">@$rightColRef[$j]</td>";
+ }
+ else {
+ print "<td bgcolor=\"$diffcolorDarkChange\"> </td>";
+ }
+ print "</tr>\n";
+ }
+ }
+}
+
+##
+# Function to generate Human readable diff-files
+# human_readable_diff(String revision_to_return_to);
+##
+sub human_readable_diff($){
+ my ($i,$difftxt, $where_nd, $filename, $pathname, $scriptwhere_nd);
+ my ($fh, $rev) = @_;
+ my ($date1, $date2, $r1d, $r2d, $r1r, $r2r, $rev1, $rev2, $sym1, $sym2);
+ my (@rightCol, @leftCol);
+
+ ($where_nd = $where) =~ s/.diff$//;
+ ($filename = $where_nd) =~ s/^.*\///;
+ ($pathname = $where_nd) =~ s/(Attic\/)?[^\/]*$//;
+ ($scriptwhere_nd = $scriptwhere) =~ s/.diff$//;
+
+ navigateHeader ($scriptwhere_nd, $pathname, $filename, $rev, "diff");
+
+ # Read header to pick up read revision and date, if possible
+ while (<$fh>) {
+ ($r1d,$r1r) = /\t(.*)\t(.*)$/ if (/^--- /);
+ ($r2d,$r2r) = /\t(.*)\t(.*)$/ if (/^\+\+\+ /);
+ last if (/^\+\+\+ /);
+ }
+ if (defined($r1r) && $r1r =~ /^(\d+\.)+\d+$/) {
+ $rev1 = $r1r;
+ $date1 = $r1d;
+ }
+ if (defined($r2r) && $r2r =~ /^(\d+\.)+\d+$/) {
+ $rev2 = $r2r;
+ $date2 = $r2d;
+ }
+
+ print "<h3 align=center>Diff for /$where_nd between version $rev1 and $rev2</h3>\n";
+
+ print "<table border=0 cellspacing=0 cellpadding=0 width=\"100%\">\n";
+ print "<tr bgcolor=\"#ffffff\">\n";
+ print "<th width=\"50%\" valign=TOP>";
+ print "version $rev1";
+ print ", $date1" if (defined($date1));
+ print "<br>Tag: $sym1\n" if ($sym1);
+ print "</th>\n";
+ print "<th width=\"50%\" valign=TOP>";
+ print "version $rev2";
+ print ", $date2" if (defined($date2));
+ print "<br>Tag: $sym2\n" if ($sym1);
+ print "</th>\n";
+
+ my $fs = "<font face=\"$difffontface\" size=\"$difffontsize\">";
+ my $fe = "</font>";
+
+ my $leftRow = 0;
+ my $rightRow = 0;
+ my ($oldline, $newline, $funname, $diffcode, $rest);
+
+ # Process diff text
+ # The diffrows are could make excellent use of
+ # cascading style sheets because we've to set the
+ # font and color for each row. anyone ...?
+ ####
+ while (<$fh>) {
+ $difftxt = $_;
+
+ if ($difftxt =~ /^@@/) {
+ ($oldline,$newline,$funname) = $difftxt =~ /@@ \-([0-9]+).*\+([0-9]+).*@@(.*)/;
+ print "<tr bgcolor=\"$diffcolorHeading\"><td width=\"50%\">";
+ print "<table width=\"100%\" border=1 cellpadding=5><tr><td><b>Line $oldline</b>";
+ print " <font size=-1>$funname</font></td></tr></table>";
+ print "</td><td width=\"50%\">";
+ print "<table width=\"100%\" border=1 cellpadding=5><tr><td><b>Line $newline</b>";
+ print " <font size=-1>$funname</font></td></tr></table>";
+ print "</td>\n";
+ $state = "dump";
+ $leftRow = 0;
+ $rightRow = 0;
+ }
+ else {
+ ($diffcode,$rest) = $difftxt =~ /^([-+ ])(.*)/;
+ $_ = spacedHtmlText ($rest);
+
+ # Add fontface, size
+ $_ = "$fs $_$fe";
+
+ #########
+ # little state machine to parse unified-diff output (Hen, zeller@think.de)
+ # in order to get some nice 'ediff'-mode output
+ # states:
+ # "dump" - just dump the value
+ # "PreChangeRemove" - we began with '-' .. so this could be the start of a 'change' area or just remove
+ # "PreChange" - okey, we got several '-' lines and moved to '+' lines -> this is a change block
+ ##########
+
+ if ($diffcode eq '+') {
+ if ($state eq "dump") { # 'change' never begins with '+': just dump out value
+ print "<tr><td bgcolor=\"$diffcolorEmpty\"> </td><td bgcolor=\"$diffcolorAdd\">$_</td></tr>\n";
+ }
+ else { # we got minus before
+ $state = "PreChange";
+ $rightCol[$rightRow++] = $_;
+ }
+ }
+ elsif ($diffcode eq '-') {
+ $state = "PreChangeRemove";
+ $leftCol[$leftRow++] = $_;
+ }
+ else { # empty diffcode
+ flush_diff_rows \@leftCol, \@rightCol, $leftRow, $rightRow;
+ print "<tr><td>$_</td><td>$_</td></tr>\n";
+ $state = "dump";
+ $leftRow = 0;
+ $rightRow = 0;
+ }
+ }
+ }
+ flush_diff_rows \@leftCol, \@rightCol, $leftRow, $rightRow;
+
+ # state is empty if we didn't have any change
+ if (!$state) {
+ print "<tr><td colspan=2> </td></tr>";
+ print "<tr bgcolor=\"$diffcolorEmpty\" >";
+ print "<td colspan=2 align=center><b>- No viewable Change -</b></td></tr>";
+ }
+ print "</table>";
+ close($fh);
+
+ print "<br><hr noshade width=\"100%\">\n";
+
+ print "<table border=0>";
+
+ print "<tr><td>";
+ # print legend
+ print "<table border=1><tr><td>";
+ print "Legend:<br><table border=0 cellspacing=0 cellpadding=1>\n";
+ print "<tr><td align=center bgcolor=\"$diffcolorRemove\">Removed from v.$rev1</td><td bgcolor=\"$diffcolorEmpty\"> </td></tr>";
+ print "<tr bgcolor=\"$diffcolorChange\"><td align=center colspan=2>changed lines</td></tr>";
+ print "<tr><td bgcolor=\"$diffcolorEmpty\"> </td><td align=center bgcolor=\"$diffcolorAdd\">Added in v.$rev2</td></tr>";
+ print "</table></td></tr></table>\n";
+
+ print "<td>";
+ # Print format selector
+ print "<FORM METHOD=\"GET\" ACTION=\"${scriptwhere}\">\n";
+ foreach my $var (keys %input) {
+ next if ($var eq "f");
+ next if (defined($DEFAULTVALUE{$var})
+ && $DEFAULTVALUE{$var} eq $input{$var});
+ print "<INPUT TYPE=HIDDEN NAME=\"",urlencode($var),"\" VALUE=\"",
+ urlencode($input{$var}),"\">\n";
+ }
+ printDiffSelect($use_java_script);
+ print "<INPUT TYPE=SUBMIT VALUE=\"Show\">\n";
+ print "</FORM>\n";
+ print "</td>";
+
+ print "</tr></table>";
+}
+
+sub navigateHeader ($$$$$) {
+ my ($swhere,$path,$filename,$rev,$title) = @_;
+ $swhere = "" if ($swhere eq $scriptwhere);
+ $swhere = urlencode($filename) if ($swhere eq "");
+ print "<\!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.0 Transitional//EN\">";
+ print "<HTML>\n<HEAD>\n";
+ print '<!-- hennerik CVSweb $Revision$ -->';
+ print "\n<TITLE>$path$filename - $title - $rev</TITLE></HEAD>\n";
+ print "<BODY BGCOLOR=\"$backcolor\">\n";
+ print "<table width=\"100%\" border=0 cellspacing=0 cellpadding=1 bgcolor=\"$navigationHeaderColor\">";
+ print "<tr valign=bottom><td>";
+ print "<a href=\"$swhere$query#rev$rev\">$backicon";
+ print "</a> <b>Return to ", &link("$filename","$swhere$query#rev$rev")," CVS log";
+ print "</b> $fileicon</td>";
+
+ print "<td align=right>$diricon <b>Up to ", &clickablePath($path, 1), "</b></td>";
+ print "</tr></table>";
+}
+
+sub plural_write ($$)
+{
+ my ($num,$text) = @_;
+ if ($num != 1) {
+ $text = $text . "s";
+ }
+ if ($num > 0) {
+ return $num . " " . $text;
+ }
+ else {
+ return "";
+ }
+}
+
+##
+# print readable timestamp in terms of
+# '..time ago'
+# H. Zeller <zeller@think.de>
+##
+sub readableTime ($$)
+{
+ my ($i, $break, $retval);
+ my ($secs,$long) = @_;
+
+ # this function works correct for time >= 2 seconds
+ if ($secs < 2) {
+ return "very little time";
+ }
+
+ my %desc = (1 , 'second',
+ 60, 'minute',
+ 3600, 'hour',
+ 86400, 'day',
+ 604800, 'week',
+ 2628000, 'month',
+ 31536000, 'year');
+ my @breaks = sort {$a <=> $b} keys %desc;
+ $i = 0;
+ while ($i <= $#breaks && $secs >= 2 * $breaks[$i]) {
+ $i++;
+ }
+ $i--;
+ $break = $breaks[$i];
+ $retval = plural_write(int ($secs / $break), $desc{"$break"});
+
+ if ($long == 1 && $i > 0) {
+ my $rest = $secs % $break;
+ $i--;
+ $break = $breaks[$i];
+ my $resttime = plural_write(int ($rest / $break),
+ $desc{"$break"});
+ if ($resttime) {
+ $retval = $retval . ", " . $resttime;
+ }
+ }
+
+ return $retval;
+}
+
+##
+# clickablePath(String pathname, boolean last_item_clickable)
+#
+# returns a html-ified path whereas each directory is a link for
+# faster navigation. last_item_clickable controls whether the
+# basename (last directory/file) is a link as well
+##
+sub clickablePath($$) {
+ my ($pathname,$clickLast) = @_;
+ my $retval = '';
+
+ if ($pathname eq '/') {
+ # this should never happen - chooseCVSRoot() is
+ # intended to do this
+ $retval = "[$cvstree]";
+ }
+ else {
+ $retval = $retval . " <a href=\"${scriptname}/${query}#dirlist\">[$cvstree]</a>";
+ my $wherepath = '';
+ my ($lastslash) = $pathname =~ m|/$|;
+ foreach (split(/\//, $pathname)) {
+ $retval = $retval . " / ";
+ $wherepath = $wherepath . '/' . $_;
+ my ($last) = "$wherepath/" eq "/$pathname"
+ || "$wherepath" eq "/$pathname";
+ if ($clickLast || !$last) {
+ $retval = $retval . "<a href=\"${scriptname}"
+ . urlencode($wherepath)
+ . (!$last || $lastslash ? '/' : '')
+ . ${query}
+ . (!$last || $lastslash ? "#dirlist" : "")
+ . "\">$_</a>";
+ }
+ else { # do not make a link to the current dir
+ $retval = $retval . $_;
+ }
+ }
+ }
+ return $retval;
+}
+
+sub chooseCVSRoot() {
+ my @foo;
+ foreach (sort keys %CVSROOT) {
+ if (-d $CVSROOT{$_}) {
+ push(@foo, $_);
+ }
+ }
+ if (@foo > 1) {
+ my ($k);
+ print "<form method=\"GET\" action=\"${scriptwhere}\">\n";
+ foreach $k (keys %input) {
+ print "<input type=hidden NAME=$k VALUE=$input{$k}>\n"
+ if ($input{$k}) && ($k ne "cvsroot");
+ }
+ # Form-Elements look wierd in Netscape if the background
+ # isn't gray and the form elements are not placed
+ # within a table ...
+ print "<table><tr>";
+ print "<td>CVS Root:</td>";
+ print "<td>\n<select name=\"cvsroot\"";
+ print " onchange=\"submit()\"" if ($use_java_script);
+ print ">\n";
+ foreach $k (@foo) {
+ print "<option value=\"$k\"";
+ print " selected" if ("$k" eq "$cvstree");
+ print ">" . ($CVSROOTdescr{"$k"} ? $CVSROOTdescr{"$k"} :
+ $k). "</option>\n";
+ }
+ print "</select>\n</td>";
+ print "<td><input type=submit value=\"Go\"></td>";
+ print "</tr></table></form>";
+ }
+ else {
+ # no choice ..
+ print "CVS Root: <b>[$cvstree]</b>";
+ }
+}
+
+sub chooseMirror() {
+ my ($mirror,$moremirrors);
+ $moremirrors = 0;
+ # This code comes from the original BSD-cvsweb
+ # and may not be useful for your site; If you don't
+ # set %MIRRORS this won't show up, anyway
+ #
+ # Should perhaps exlude the current site somehow..
+ if (keys %MIRRORS) {
+ print "\nThis cvsweb is mirrored in:\n";
+ foreach $mirror (keys %MIRRORS) {
+ print ", " if ($moremirrors);
+ print qq(<a href="$MIRRORS{$mirror}">$mirror</A>\n);
+ $moremirrors = 1;
+ }
+ print "<p>\n";
+ }
+}
+
+sub fileSortCmp {
+ my ($comp) = 0;
+ my ($c,$d,$af,$bf);
+
+ ($af = $a) =~ s/,v$//;
+ ($bf = $b) =~ s/,v$//;
+ my ($rev1,$date1,$log1,$author1,$filename1) = @{$fileinfo{$af}}
+ if (defined($fileinfo{$af}));
+ my ($rev2,$date2,$log2,$author2,$filename2) = @{$fileinfo{$bf}}
+ if (defined($fileinfo{$bf}));
+
+ if (defined($filename1) && defined($filename2) && $af eq $filename1 && $bf eq $filename2) {
+ # Two files
+ $comp = -revcmp($rev1, $rev2) if ($byrev && $rev1 && $rev2);
+ $comp = ($date2 <=> $date1) if ($bydate && $date1 && $date2);
+ $comp = ($log1 cmp $log2) if ($bylog && $log1 && $log2);
+ $comp = ($author1 cmp $author2) if ($byauthor && $author1 && $author2);
+ }
+ if ($comp == 0) {
+ # Directories first, then sorted on name if no other sort critera
+ # available.
+ my $ad = ((-d "$fullname/$a")?"D":"F");
+ my $bd = ((-d "$fullname/$b")?"D":"F");
+ ($c=$a) =~ s|.*/||;
+ ($d=$b) =~ s|.*/||;
+ $comp = ("$ad$c" cmp "$bd$d");
+ }
+ return $comp;
+}
+
+# make A url for downloading
+sub download_url {
+ my ($url,$revision,$mimetype) = @_;
+#print("<br><b>[$url|$revision|$mimetype]</b><br>");
+ $revision =~ s/\.0\././;
+
+ if (defined($checkout_magic)
+ && (!defined($mimetype) || $mimetype ne "text/x-cvsweb-markup")) {
+ my ($path);
+#print("<b>[$where]</b><br>");
+# There is a bug I Hope to correct
+# ($path = $where) =~ s|/[^/]*$|/|;
+ ($path = $where) =~ s|[^/]*$||;
+#print("<b>[$path|$where]</b><br>");
+ $url = "$scriptname/$checkoutMagic/${path}$url";
+#print("<b>[$scriptname!$checkoutMagic!${path}!$url]</b>");
+ }
+ $url .= "?rev=$revision";
+ $url .= "&content-type=$mimetype" if (defined($mimetype));
+
+ return $url;
+}
+
+# Presents a link to download the
+# selected revision
+sub download_link {
+ my ($url,$revision,$textlink,$mimetype) = @_;
+ my ($fullurl) = download_url($url,$revision,$mimetype);
+#print("<b>[$fullurl]</b>");
+ my ($paren) = $textlink =~ /^\(/;
+ $textlink =~ s/^\(// if ($paren);
+ $textlink =~ s/\)$// if ($paren);
+ print "(" if ($paren);
+ print "<A HREF=\"$fullurl";
+ print $barequery;
+ print "\"";
+ if ($open_extern_window && (!defined($mimetype) || $mimetype ne "text/x-cvsweb-markup")) {
+ print " target=\"cvs_checkout\"";
+ # we should have
+ # 'if (document.cvswin==null) document.cvswin=window.open(...'
+ # in order to allow the user to resize the window; otherwise
+ # the user may resize the window, but on next checkout - zap -
+ # its original (configured s. cvsweb.conf) size is back again
+ # .. annoying (if $extern_window_(width|height) is defined)
+ # but this if (..) solution is far from perfect
+ # what we need to do as well is
+ # 1) save cvswin in an invisible frame that always exists
+ # (document.cvswin will be void on next load)
+ # 2) on close of the cvs_checkout - window set the cvswin
+ # variable to 'null' again - so that it will be
+ # reopenend with the configured size
+ # anyone a JavaScript programmer ?
+ # .. so here without if (..):
+ # currently, the best way is to comment out the size parameters
+ # ($extern_window...) in cvsweb.conf.
+ if ($use_java_script) {
+ print " onClick=\"window.open('$fullurl','cvs_checkout',";
+ print "'resizeable,scrollbars";
+ print ",status,toolbar" if (defined($mimetype)
+ && $mimetype eq "text/html");
+ print ",width=$extern_window_width" if (defined($extern_window_width));
+ print ",height=$extern_window_height" if (defined($extern_window_height));
+ print"');\"";
+ }
+ }
+ print "><b>$textlink</b></A>";
+ print ")" if ($paren);
+}
+
+# Returns a Query string with the
+# specified parameter toggled
+sub toggleQuery($$) {
+ my ($toggle,$value) = @_;
+ my ($newquery,$var);
+ my (%vars);
+ %vars = %input;
+ if (defined($value)) {
+ $vars{$toggle} = $value;
+ }
+ else {
+ $vars{$toggle} = $vars{$toggle} ? 0 : 1;
+ }
+ # Build a new query of non-default paramenters
+ $newquery = "";
+ foreach $var (@stickyvars) {
+ my ($value) = defined($vars{$var}) ? $vars{$var} : "";
+ my ($default) = defined($DEFAULTVALUE{$var}) ? $DEFAULTVALUE{$var} : "";
+ if ($value ne $default) {
+ $newquery .= "&" if ($newquery ne "");
+ $newquery .= urlencode($var) . "=" . urlencode($value);
+ }
+ }
+ if ($newquery) {
+ return '?' . $newquery;
+ }
+ return "";
+}
+
+sub urlencode {
+ my ($in) = @_;
+ my ($out);
+ ($out = $in) =~ s/([\000-+{-\377])/sprintf("%%%02x", ord($1))/ge;
+ return $out;
+}
+
+sub http_header {
+ my $content_type = shift || "text/html";
+ my $is_mod_perl = defined($ENV{'MOD_PERL'});
+ if (defined($moddate)) {
+ if ($is_mod_perl) {
+ Apache->request->header_out("Last-Modified" => scalar gmtime($moddate) . " GMT");
+ }
+ else {
+ print "Last-Modified: " . scalar gmtime($moddate) . " GMT\r\n";
+ }
+ }
+ if ($is_mod_perl) {
+ Apache->request->content_type($content_type);
+ }
+ else {
+ print "Content-type: $content_type\r\n";
+ }
+ if ($allow_compress && $maycompress) {
+ if ($has_zlib || (defined($GZIPBIN) && open(GZIP, "|$GZIPBIN -1 -c"))) {
+ if ($is_mod_perl) {
+ Apache->request->content_encoding("x-gzip");
+ Apache->request->header_out(Vary => "Accept-Encoding");
+ Apache->request->send_http_header;
+ }
+ else {
+ print "Content-encoding: x-gzip\r\n";
+ print "Vary: Accept-Encoding\r\n"; #RFC 2068, 14.43
+ print "\r\n"; # Close headers
+ }
+ $| = 1; $| = 0; # Flush header output
+ if ($has_zlib) {
+ tie *GZIP, __PACKAGE__, \*STDOUT;
+ }
+ select(GZIP);
+ $gzip_open = 1;
+# print "<!-- gzipped -->" if ($content_type eq "text/html");
+ }
+ else {
+ if ($is_mod_perl) {
+ Apache->request->send_http_header;
+ }
+ else {
+ print "\r\n"; # Close headers
+ }
+ print "<font size=-1>Unable to find gzip binary in the \$PATH to compress output</font><br>";
+ }
+ }
+ else {
+ if ($is_mod_perl) {
+ Apache->request->send_http_header;
+ }
+ else {
+ print "\r\n"; # Close headers
+ }
+ }
+}
+
+sub html_header($) {
+ my ($title) = @_;
+ my $version = '$Revision$';
+ http_header();
+ print <<EOH;
+<!doctype html public "-//W3C//DTD HTML 4.0 Transitional//EN"
+ "http://www.w3.org/TR/REC-html40/loose.dtd">
+<html>
+<title>$title</title>
+<!-- hennerik CVSweb $version -->
+</head>
+$body_tag
+$logo <h1 align="center">$title</h1>
+EOH
+}
+
+sub html_footer {
+ return "<hr noshade><address>$address</address>\n";
+}
+
+sub link_tags
+{
+ my ($tags) = @_;
+ my ($ret) = "";
+ my ($fileurl,$filename);
+
+ ($filename = $where) =~ s/^.*\///;
+ $fileurl = urlencode($filename);
+
+ foreach my $sym (split(", ", $tags)) {
+ $ret .= ",\n" if ($ret ne "");
+ $ret .= "<A HREF=\"$fileurl"
+ . toggleQuery('only_with_tag',$sym) . "\">$sym</A>";
+ }
+ return $ret."\n";
+}
+
+#
+# See if a module is listed in the config file's @HideModule list.
+#
+sub forbidden_module {
+ my($module) = @_;
+
+ for (my $i=0; $i < @HideModules; $i++) {
+ return 1 if $module eq $HideModules[$i];
+ }
+
+ return 0;
+}
+
+# Close the GZIP handle remove the tie.
+
+sub gzipclose {
+ if ($gzip_open) {
+ select(STDOUT);
+ close(GZIP);
+ untie *GZIP;
+ $gzip_open = 0;
+ }
+}
+
+# implement a gzipped file handle via the Compress:Zlib compression
+# library.
+
+sub MAGIC1() { 0x1f }
+sub MAGIC2() { 0x8b }
+sub OSCODE() { 3 }
+
+sub TIEHANDLE {
+ my ($class, $out) = @_;
+ my ($d) = Compress::Zlib::deflateInit(-Level => Compress::Zlib::Z_BEST_COMPRESSION(),
+ -WindowBits => -Compress::Zlib::MAX_WBITS()) or return undef;
+ my ($o) = {
+ handle => $out,
+ dh => $d,
+ crc => 0,
+ len => 0,
+ };
+ my ($header) = pack("c10", MAGIC1, MAGIC2, Compress::Zlib::Z_DEFLATED(), 0,0,0,0,0,0, OSCODE);
+ print {$o->{handle}} $header;
+ return bless($o, $class);
+}
+
+sub PRINT {
+ my ($o) = shift;
+ my ($buf) = join(defined $, ? $, : "",@_);
+ my ($len) = length($buf);
+ my ($compressed, $status) = $o->{dh}->deflate($buf);
+ print {$o->{handle}} $compressed if defined($compressed);
+ $o->{crc} = Compress::Zlib::crc32($buf, $o->{crc});
+ $o->{len} += $len;
+ return $len;
+}
+
+sub PRINTF {
+ my ($o) = shift;
+ my ($fmt) = shift;
+ my ($buf) = sprintf($fmt, @_);
+ my ($len) = length($buf);
+ my ($compressed, $status) = $o->{dh}->deflate($buf);
+ print {$o->{handle}} $compressed if defined($compressed);
+ $o->{crc} = Compress::Zlib::crc32($buf, $o->{crc});
+ $o->{len} += $len;
+ return $len;
+}
+
+sub WRITE {
+ my ($o, $buf, $len, $off) = @_;
+ my ($compressed, $status) = $o->{dh}->deflate(substr($buf, 0, $len));
+ print {$o->{handle}} $compressed if defined($compressed);
+ $o->{crc} = Compress::Zlib::crc32(substr($buf, 0, $len), $o->{crc});
+ $o->{len} += $len;
+ return $len;
+}
+
+sub CLOSE {
+ my ($o) = @_;
+ return if !defined( $o->{dh});
+ my ($buf) = $o->{dh}->flush();
+ $buf .= pack("V V", $o->{crc}, $o->{len});
+ print {$o->{handle}} $buf;
+ undef $o->{dh};
+}
+
+sub DESTROY {
+ my ($o) = @_;
+ CLOSE($o);
+}
projects / fusionforge / fusionforge.git / commitdiff
