--
-- Selected TOC Entries:
--
DROP TABLE "cache_store";
--
-- TOC Entry ID 2 (OID 469439)
--
-- Name: cache_store Type: TABLE Owner: sourceforge
--

CREATE TABLE "cache_store" (
	"name" character varying(255) NOT NULL,
	"data" text,
	"indate" integer DEFAULT 0 NOT NULL,
	Constraint "cache_store_pkey" Primary Key ("name")
);

--
-- Data for TOC Entry ID 3 (OID 469439)
--
-- Name: cache_store Type: TABLE DATA Owner: sourceforge
--


--
-- Selected TOC Entries:
--
DROP INDEX "foundryprojdlsagg_foundryid_dls";
DROP TABLE "foundry_project_downloads_agg";
--
-- TOC Entry ID 2 (OID 469499)
--
-- Name: foundry_project_downloads_agg Type: TABLE Owner: sourceforge
--

CREATE TABLE "foundry_project_downloads_agg" (
	"foundry_id" integer,
	"downloads" integer,
	"group_id" integer,
	"group_name" character varying(40),
	"unix_group_name" character varying(30)
);

--
-- Data for TOC Entry ID 4 (OID 469499)
--
-- Name: foundry_project_downloads_agg Type: TABLE DATA Owner: sourceforge
--


--
-- TOC Entry ID 3 (OID 469499)
--
-- Name: "foundryprojdlsagg_foundryid_dls" Type: INDEX Owner: sourceforge
--

CREATE  INDEX "foundryprojdlsagg_foundryid_dls" on "foundry_project_downloads_agg" using btree ( "foundry_id" "int4_ops", "downloads" "int4_ops" );

--
-- Selected TOC Entries:
--
DROP INDEX "foundryprojectrankingsagg_found";
DROP TABLE "foundry_project_rankings_agg";
--
-- TOC Entry ID 2 (OID 469484)
--
-- Name: foundry_project_rankings_agg Type: TABLE Owner: sourceforge
--

CREATE TABLE "foundry_project_rankings_agg" (
	"foundry_id" integer,
	"group_id" integer,
	"group_name" character varying(40),
	"unix_group_name" character varying(30),
	"ranking" integer,
	"percentile" double precision
);

--
-- Data for TOC Entry ID 4 (OID 469484)
--
-- Name: foundry_project_rankings_agg Type: TABLE DATA Owner: sourceforge
--


--
-- TOC Entry ID 3 (OID 469484)
--
-- Name: "foundryprojectrankingsagg_found" Type: INDEX Owner: sourceforge
--

CREATE  INDEX "foundryprojectrankingsagg_found" on "foundry_project_rankings_agg" using btree ( "foundry_id" "int4_ops", "ranking" "int4_ops" );

--
-- Selected TOC Entries:
--
DROP INDEX "project_metric_group";
DROP TABLE "project_metric";
--
-- TOC Entry ID 2 (OID 466426)
--
-- Name: project_metric Type: TABLE Owner: sourceforge
--

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,
	Constraint "project_metric_pkey" Primary Key ("ranking")
);

--
-- Data for TOC Entry ID 4 (OID 466426)
--
-- Name: project_metric Type: TABLE DATA Owner: sourceforge
--


--
-- TOC Entry ID 3 (OID 466426)
--
-- Name: "project_metric_group" Type: INDEX Owner: sourceforge
--

CREATE  INDEX "project_metric_group" on "project_metric" using btree ( "group_id" "int4_ops" );

--
-- Selected TOC Entries:
--
DROP TABLE "project_metric_tmp1";
--
-- TOC Entry ID 2 (OID 466462)
--
-- Name: project_metric_tmp1 Type: TABLE Owner: sourceforge
--

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,
	Constraint "project_metric_tmp1_pkey" Primary Key ("ranking")
);

--
-- Data for TOC Entry ID 3 (OID 466462)
--
-- Name: project_metric_tmp1 Type: TABLE DATA Owner: sourceforge
--


--
-- Selected TOC Entries:
--
DROP INDEX "statsprojectall_groupid";
DROP TABLE "stats_project_all";
--
-- TOC Entry ID 2 (OID 469584)
--
-- Name: stats_project_all Type: TABLE Owner: sourceforge
--

CREATE TABLE "stats_project_all" (
	"group_id" integer,
	"developers" integer,
	"group_ranking" integer,
	"group_metric" double precision,
	"logo_showings" integer,
	"downloads" integer,
	"site_views" integer,
	"subdomain_views" integer,
	"page_views" integer,
	"msg_posted" integer,
	"msg_uniq_auth" integer,
	"bugs_opened" integer,
	"bugs_closed" integer,
	"support_opened" integer,
	"support_closed" integer,
	"patches_opened" integer,
	"patches_closed" integer,
	"artifacts_opened" integer,
	"artifacts_closed" integer,
	"tasks_opened" integer,
	"tasks_closed" integer,
	"help_requests" integer,
	"cvs_checkouts" integer,
	"cvs_commits" integer,
	"cvs_adds" integer
);

--
-- Data for TOC Entry ID 4 (OID 469584)
--
-- Name: stats_project_all Type: TABLE DATA Owner: sourceforge
--


--
-- TOC Entry ID 3 (OID 469584)
--
-- Name: "statsprojectall_groupid" Type: INDEX Owner: sourceforge
--

CREATE  INDEX "statsprojectall_groupid" on "stats_project_all" using btree ( "group_id" "int4_ops" );

--
-- Selected TOC Entries:
--
DROP TABLE "stats_project_developers_last30";
--
-- TOC Entry ID 2 (OID 469618)
--
-- Name: stats_project_developers_last30 Type: TABLE Owner: sourceforge
--

CREATE TABLE "stats_project_developers_last30" (
	"month" integer,
	"day" integer,
	"group_id" integer,
	"developers" integer
);

--
-- Data for TOC Entry ID 3 (OID 469618)
--
-- Name: stats_project_developers_last30 Type: TABLE DATA Owner: sourceforge
--


--
-- Selected TOC Entries:
--
DROP INDEX "statsproject30_groupid";
DROP TABLE "stats_project_last_30";
--
-- TOC Entry ID 2 (OID 469631)
--
-- Name: stats_project_last_30 Type: TABLE Owner: sourceforge
--

CREATE TABLE "stats_project_last_30" (
	"month" integer,
	"day" integer,
	"group_id" integer,
	"developers" integer,
	"group_ranking" integer,
	"group_metric" double precision,
	"logo_showings" integer,
	"downloads" integer,
	"site_views" integer,
	"subdomain_views" integer,
	"page_views" integer,
	"filereleases" integer,
	"msg_posted" integer,
	"msg_uniq_auth" integer,
	"bugs_opened" integer,
	"bugs_closed" integer,
	"support_opened" integer,
	"support_closed" integer,
	"patches_opened" integer,
	"patches_closed" integer,
	"artifacts_opened" integer,
	"artifacts_closed" integer,
	"tasks_opened" integer,
	"tasks_closed" integer,
	"help_requests" integer,
	"cvs_checkouts" integer,
	"cvs_commits" integer,
	"cvs_adds" integer
);

--
-- Data for TOC Entry ID 4 (OID 469631)
--
-- Name: stats_project_last_30 Type: TABLE DATA Owner: sourceforge
--


--
-- TOC Entry ID 3 (OID 469631)
--
-- Name: "statsproject30_groupid" Type: INDEX Owner: sourceforge
--

CREATE  INDEX "statsproject30_groupid" on "stats_project_last_30" using btree ( "group_id" "int4_ops" );

--
-- Selected TOC Entries:
--
DROP INDEX "statsprojectmonths_groupid_mont";
DROP INDEX "statsprojectmonths_groupid";
DROP TABLE "stats_project_months";
--
-- TOC Entry ID 2 (OID 469548)
--
-- Name: stats_project_months Type: TABLE Owner: sourceforge
--

CREATE TABLE "stats_project_months" (
	"month" integer,
	"group_id" integer,
	"developers" integer,
	"group_ranking" integer,
	"group_metric" double precision,
	"logo_showings" integer,
	"downloads" integer,
	"site_views" integer,
	"subdomain_views" integer,
	"page_views" integer,
	"file_releases" integer,
	"msg_posted" integer,
	"msg_uniq_auth" integer,
	"bugs_opened" integer,
	"bugs_closed" integer,
	"support_opened" integer,
	"support_closed" integer,
	"patches_opened" integer,
	"patches_closed" integer,
	"artifacts_opened" integer,
	"artifacts_closed" integer,
	"tasks_opened" integer,
	"tasks_closed" integer,
	"help_requests" integer,
	"cvs_checkouts" integer,
	"cvs_commits" integer,
	"cvs_adds" integer
);

--
-- Data for TOC Entry ID 5 (OID 469548)
--
-- Name: stats_project_months Type: TABLE DATA Owner: sourceforge
--


--
-- TOC Entry ID 3 (OID 469548)
--
-- Name: "statsprojectmonths_groupid" Type: INDEX Owner: sourceforge
--

CREATE  INDEX "statsprojectmonths_groupid" on "stats_project_months" using btree ( "group_id" "int4_ops" );

--
-- TOC Entry ID 4 (OID 469548)
--
-- Name: "statsprojectmonths_groupid_mont" Type: INDEX Owner: sourceforge
--

CREATE  INDEX "statsprojectmonths_groupid_mont" on "stats_project_months" using btree ( "group_id" "int4_ops", "month" "int4_ops" );

--
-- Selected TOC Entries:
--
DROP TABLE "stats_site_all";
--
-- TOC Entry ID 2 (OID 469736)
--
-- Name: stats_site_all Type: TABLE Owner: sourceforge
--

CREATE TABLE "stats_site_all" (
	"site_page_views" integer,
	"downloads" integer,
	"subdomain_views" integer,
	"msg_posted" integer,
	"bugs_opened" integer,
	"bugs_closed" integer,
	"support_opened" integer,
	"support_closed" integer,
	"patches_opened" integer,
	"patches_closed" integer,
	"artifacts_opened" integer,
	"artifacts_closed" integer,
	"tasks_opened" integer,
	"tasks_closed" integer,
	"help_requests" integer,
	"cvs_checkouts" integer,
	"cvs_commits" integer,
	"cvs_adds" integer
);

--
-- Data for TOC Entry ID 3 (OID 469736)
--
-- Name: stats_site_all Type: TABLE DATA Owner: sourceforge
--


INSERT INTO "stats_site_all" VALUES (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
--
-- Selected TOC Entries:
--
DROP INDEX "statssitelast30_month_day";
DROP TABLE "stats_site_last_30";
--
-- TOC Entry ID 2 (OID 469679)
--
-- Name: stats_site_last_30 Type: TABLE Owner: sourceforge
--

CREATE TABLE "stats_site_last_30" (
	"month" integer,
	"day" integer,
	"site_page_views" integer,
	"downloads" integer,
	"subdomain_views" integer,
	"msg_posted" integer,
	"bugs_opened" integer,
	"bugs_closed" integer,
	"support_opened" integer,
	"support_closed" integer,
	"patches_opened" integer,
	"patches_closed" integer,
	"artifacts_opened" integer,
	"artifacts_closed" integer,
	"tasks_opened" integer,
	"tasks_closed" integer,
	"help_requests" integer,
	"cvs_checkouts" integer,
	"cvs_commits" integer,
	"cvs_adds" integer
);

--
-- Data for TOC Entry ID 4 (OID 469679)
--
-- Name: stats_site_last_30 Type: TABLE DATA Owner: sourceforge
--


--
-- TOC Entry ID 3 (OID 469679)
--
-- Name: "statssitelast30_month_day" Type: INDEX Owner: sourceforge
--

CREATE  INDEX "statssitelast30_month_day" on "stats_site_last_30" using btree ( "month" "int4_ops", "day" "int4_ops" );

--
-- Selected TOC Entries:
--
DROP INDEX "statssitemonths_month";
DROP TABLE "stats_site_months";
--
-- TOC Entry ID 2 (OID 469708)
--
-- Name: stats_site_months Type: TABLE Owner: sourceforge
--

CREATE TABLE "stats_site_months" (
	"month" integer,
	"site_page_views" integer,
	"downloads" integer,
	"subdomain_views" integer,
	"msg_posted" integer,
	"bugs_opened" integer,
	"bugs_closed" integer,
	"support_opened" integer,
	"support_closed" integer,
	"patches_opened" integer,
	"patches_closed" integer,
	"artifacts_opened" integer,
	"artifacts_closed" integer,
	"tasks_opened" integer,
	"tasks_closed" integer,
	"help_requests" integer,
	"cvs_checkouts" integer,
	"cvs_commits" integer,
	"cvs_adds" integer
);

--
-- Data for TOC Entry ID 4 (OID 469708)
--
-- Name: stats_site_months Type: TABLE DATA Owner: sourceforge
--


--
-- TOC Entry ID 3 (OID 469708)
--
-- Name: "statssitemonths_month" Type: INDEX Owner: sourceforge
--

CREATE  INDEX "statssitemonths_month" on "stats_site_months" using btree ( "month" "int4_ops" );

--
-- Selected TOC Entries:
--
DROP INDEX "statssitepagesbyday_month_day";
DROP INDEX "statssitepgsbyday_oid";
DROP TABLE "stats_site_pages_by_day";
--
-- TOC Entry ID 2 (OID 469048)
--
-- Name: stats_site_pages_by_day Type: TABLE Owner: sourceforge
--

CREATE TABLE "stats_site_pages_by_day" (
	"month" integer,
	"day" integer,
	"site_page_views" integer
);

--
-- Data for TOC Entry ID 5 (OID 469048)
--
-- Name: stats_site_pages_by_day Type: TABLE DATA Owner: sourceforge
--


--
-- TOC Entry ID 3 (OID 469048)
--
-- Name: "statssitepgsbyday_oid" Type: INDEX Owner: sourceforge
--

CREATE UNIQUE INDEX "statssitepgsbyday_oid" on "stats_site_pages_by_day" using btree ( "oid" "oid_ops" );

--
-- TOC Entry ID 4 (OID 469048)
--
-- Name: "statssitepagesbyday_month_day" Type: INDEX Owner: sourceforge
--

CREATE  INDEX "statssitepagesbyday_month_day" on "stats_site_pages_by_day" using btree ( "month" "int4_ops", "day" "int4_ops" );

--
-- Selected TOC Entries:
--
DROP TABLE "stats_site_pages_by_month";
--
-- TOC Entry ID 2 (OID 469668)
--
-- Name: stats_site_pages_by_month Type: TABLE Owner: sourceforge
--

CREATE TABLE "stats_site_pages_by_month" (
	"month" integer,
	"site_page_views" integer
);

--
-- Data for TOC Entry ID 3 (OID 469668)
--
-- Name: stats_site_pages_by_month Type: TABLE DATA Owner: sourceforge
--


--
-- Selected TOC Entries:
--
DROP SEQUENCE "artifact_artifact_id_seq";
--
-- TOC Entry ID 2 (OID 468604)
--
-- Name: artifact_artifact_id_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "artifact_artifact_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 468604)
--
-- Name: artifact_artifact_id_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"artifact_artifact_id_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "artifact_canned_response_id_seq";
--
-- TOC Entry ID 2 (OID 468985)
--
-- Name: artifact_canned_response_id_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "artifact_canned_response_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 468985)
--
-- Name: artifact_canned_response_id_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"artifact_canned_response_id_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "artifact_category_id_seq";
--
-- TOC Entry ID 2 (OID 468453)
--
-- Name: artifact_category_id_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "artifact_category_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 468453)
--
-- Name: artifact_category_id_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"artifact_category_id_seq"', 100, 't');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "artifact_file_id_seq";
--
-- TOC Entry ID 2 (OID 468783)
--
-- Name: artifact_file_id_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "artifact_file_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 468783)
--
-- Name: artifact_file_id_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"artifact_file_id_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "artifact_grou_group_artifac_seq";
--
-- TOC Entry ID 2 (OID 468268)
--
-- Name: artifact_grou_group_artifac_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "artifact_grou_group_artifac_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 468268)
--
-- Name: artifact_grou_group_artifac_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"artifact_grou_group_artifac_seq"', 100, 't');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "artifact_group_id_seq";
--
-- TOC Entry ID 2 (OID 468505)
--
-- Name: artifact_group_id_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "artifact_group_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 468505)
--
-- Name: artifact_group_id_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"artifact_group_id_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "artifact_history_id_seq";
--
-- TOC Entry ID 2 (OID 468709)
--
-- Name: artifact_history_id_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "artifact_history_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 468709)
--
-- Name: artifact_history_id_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"artifact_history_id_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "artifact_message_id_seq";
--
-- TOC Entry ID 2 (OID 468861)
--
-- Name: artifact_message_id_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "artifact_message_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 468861)
--
-- Name: artifact_message_id_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"artifact_message_id_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "artifact_monitor_id_seq";
--
-- TOC Entry ID 2 (OID 468934)
--
-- Name: artifact_monitor_id_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "artifact_monitor_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 468934)
--
-- Name: artifact_monitor_id_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"artifact_monitor_id_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "artifact_perm_id_seq";
--
-- TOC Entry ID 2 (OID 468384)
--
-- Name: artifact_perm_id_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "artifact_perm_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 468384)
--
-- Name: artifact_perm_id_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"artifact_perm_id_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "artifact_resolution_id_seq";
--
-- TOC Entry ID 2 (OID 468335)
--
-- Name: artifact_resolution_id_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "artifact_resolution_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 468335)
--
-- Name: artifact_resolution_id_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"artifact_resolution_id_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "artifact_status_id_seq";
--
-- TOC Entry ID 2 (OID 468555)
--
-- Name: artifact_status_id_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "artifact_status_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 468555)
--
-- Name: artifact_status_id_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"artifact_status_id_seq"', 3, 't');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "canned_responses_pk_seq";
--
-- TOC Entry ID 2 (OID 464514)
--
-- Name: canned_responses_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "canned_responses_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 464514)
--
-- Name: canned_responses_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"canned_responses_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "db_images_pk_seq";
--
-- TOC Entry ID 2 (OID 464564)
--
-- Name: db_images_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "db_images_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 464564)
--
-- Name: db_images_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"db_images_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "doc_data_pk_seq";
--
-- TOC Entry ID 2 (OID 464630)
--
-- Name: doc_data_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "doc_data_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 464630)
--
-- Name: doc_data_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"doc_data_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "doc_groups_pk_seq";
--
-- TOC Entry ID 2 (OID 464695)
--
-- Name: doc_groups_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "doc_groups_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 464695)
--
-- Name: doc_groups_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"doc_groups_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "doc_states_pk_seq";
--
-- TOC Entry ID 2 (OID 464732)
--
-- Name: doc_states_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "doc_states_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 464732)
--
-- Name: doc_states_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"doc_states_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "filemodule_monitor_pk_seq";
--
-- TOC Entry ID 2 (OID 464767)
--
-- Name: filemodule_monitor_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "filemodule_monitor_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 464767)
--
-- Name: filemodule_monitor_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"filemodule_monitor_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "forum_group_list_pk_seq";
--
-- TOC Entry ID 2 (OID 464886)
--
-- Name: forum_group_list_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "forum_group_list_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 464886)
--
-- Name: forum_group_list_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"forum_group_list_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "forum_monitored_forums_pk_seq";
--
-- TOC Entry ID 2 (OID 464944)
--
-- Name: forum_monitored_forums_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "forum_monitored_forums_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 464944)
--
-- Name: forum_monitored_forums_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"forum_monitored_forums_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "forum_pk_seq";
--
-- TOC Entry ID 2 (OID 464804)
--
-- Name: forum_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "forum_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 464804)
--
-- Name: forum_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"forum_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "forum_saved_place_pk_seq";
--
-- TOC Entry ID 2 (OID 464981)
--
-- Name: forum_saved_place_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "forum_saved_place_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 464981)
--
-- Name: forum_saved_place_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"forum_saved_place_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "forum_thread_seq";
--
-- TOC Entry ID 2 (OID 468052)
--
-- Name: forum_thread_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "forum_thread_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 468052)
--
-- Name: forum_thread_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"forum_thread_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "foundry_news_pk_seq";
--
-- TOC Entry ID 2 (OID 465058)
--
-- Name: foundry_news_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "foundry_news_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 465058)
--
-- Name: foundry_news_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"foundry_news_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "foundry_preferred_projec_pk_seq";
--
-- TOC Entry ID 2 (OID 465099)
--
-- Name: foundry_preferred_projec_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "foundry_preferred_projec_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 465099)
--
-- Name: foundry_preferred_projec_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"foundry_preferred_projec_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "foundry_projects_pk_seq";
--
-- TOC Entry ID 2 (OID 465138)
--
-- Name: foundry_projects_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "foundry_projects_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 465138)
--
-- Name: foundry_projects_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"foundry_projects_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "frs_file_pk_seq";
--
-- TOC Entry ID 2 (OID 465175)
--
-- Name: frs_file_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "frs_file_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 465175)
--
-- Name: frs_file_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"frs_file_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "frs_filetype_pk_seq";
--
-- TOC Entry ID 2 (OID 465236)
--
-- Name: frs_filetype_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "frs_filetype_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 465236)
--
-- Name: frs_filetype_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"frs_filetype_pk_seq"', 9999, 't');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "frs_package_pk_seq";
--
-- TOC Entry ID 2 (OID 465285)
--
-- Name: frs_package_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "frs_package_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 465285)
--
-- Name: frs_package_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"frs_package_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "frs_processor_pk_seq";
--
-- TOC Entry ID 2 (OID 465338)
--
-- Name: frs_processor_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "frs_processor_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 465338)
--
-- Name: frs_processor_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"frs_processor_pk_seq"', 9999, 't');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "frs_release_pk_seq";
--
-- TOC Entry ID 2 (OID 465387)
--
-- Name: frs_release_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "frs_release_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 465387)
--
-- Name: frs_release_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"frs_release_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "frs_status_pk_seq";
--
-- TOC Entry ID 2 (OID 465448)
--
-- Name: frs_status_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "frs_status_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 465448)
--
-- Name: frs_status_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"frs_status_pk_seq"', 3, 't');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "group_cvs_history_pk_seq";
--
-- TOC Entry ID 2 (OID 465497)
--
-- Name: group_cvs_history_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "group_cvs_history_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 465497)
--
-- Name: group_cvs_history_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"group_cvs_history_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "group_history_pk_seq";
--
-- TOC Entry ID 2 (OID 465516)
--
-- Name: group_history_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "group_history_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 465516)
--
-- Name: group_history_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"group_history_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "groups_pk_seq";
--
-- TOC Entry ID 2 (OID 465622)
--
-- Name: groups_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "groups_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 465622)
--
-- Name: groups_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"groups_pk_seq"', 4, 't');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "group_type_pk_seq";
--
-- TOC Entry ID 2 (OID 465573)
--
-- Name: group_type_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "group_type_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 465573)
--
-- Name: group_type_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"group_type_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "mail_group_list_pk_seq";
--
-- TOC Entry ID 2 (OID 465712)
--
-- Name: mail_group_list_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "mail_group_list_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 465712)
--
-- Name: mail_group_list_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"mail_group_list_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "massmail_queue_id_seq";
--
-- TOC Entry ID 2 (OID 469063)
--
-- Name: massmail_queue_id_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "massmail_queue_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 469063)
--
-- Name: massmail_queue_id_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"massmail_queue_id_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "news_bytes_pk_seq";
--
-- TOC Entry ID 2 (OID 465771)
--
-- Name: news_bytes_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "news_bytes_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 465771)
--
-- Name: news_bytes_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"news_bytes_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "people_job_category_pk_seq";
--
-- TOC Entry ID 2 (OID 465891)
--
-- Name: people_job_category_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "people_job_category_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 465891)
--
-- Name: people_job_category_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"people_job_category_pk_seq"', 7, 't');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "people_job_inventory_pk_seq";
--
-- TOC Entry ID 2 (OID 465942)
--
-- Name: people_job_inventory_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "people_job_inventory_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 465942)
--
-- Name: people_job_inventory_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"people_job_inventory_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "people_job_pk_seq";
--
-- TOC Entry ID 2 (OID 465831)
--
-- Name: people_job_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "people_job_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 465831)
--
-- Name: people_job_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"people_job_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "people_job_status_pk_seq";
--
-- TOC Entry ID 2 (OID 465983)
--
-- Name: people_job_status_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "people_job_status_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 465983)
--
-- Name: people_job_status_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"people_job_status_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "people_skill_inventory_pk_seq";
--
-- TOC Entry ID 2 (OID 466081)
--
-- Name: people_skill_inventory_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "people_skill_inventory_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 466081)
--
-- Name: people_skill_inventory_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"people_skill_inventory_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "people_skill_level_pk_seq";
--
-- TOC Entry ID 2 (OID 466122)
--
-- Name: people_skill_level_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "people_skill_level_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 466122)
--
-- Name: people_skill_level_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"people_skill_level_pk_seq"', 5, 't');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "people_skill_pk_seq";
--
-- TOC Entry ID 2 (OID 466032)
--
-- Name: people_skill_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "people_skill_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 466032)
--
-- Name: people_skill_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"people_skill_pk_seq"', 9, 't');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "people_skill_year_pk_seq";
--
-- TOC Entry ID 2 (OID 466171)
--
-- Name: people_skill_year_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "people_skill_year_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 466171)
--
-- Name: people_skill_year_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"people_skill_year_pk_seq"', 5, 't');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "prdb_dbs_dbid_seq";
--
-- TOC Entry ID 2 (OID 468104)
--
-- Name: prdb_dbs_dbid_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "prdb_dbs_dbid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 468104)
--
-- Name: prdb_dbs_dbid_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"prdb_dbs_dbid_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "project_assigned_to_pk_seq";
--
-- TOC Entry ID 2 (OID 466220)
--
-- Name: project_assigned_to_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "project_assigned_to_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 466220)
--
-- Name: project_assigned_to_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"project_assigned_to_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "project_dependencies_pk_seq";
--
-- TOC Entry ID 2 (OID 466257)
--
-- Name: project_dependencies_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "project_dependencies_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 466257)
--
-- Name: project_dependencies_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"project_dependencies_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "project_group_list_pk_seq";
--
-- TOC Entry ID 2 (OID 466294)
--
-- Name: project_group_list_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "project_group_list_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 466294)
--
-- Name: project_group_list_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"project_group_list_pk_seq"', 1, 't');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "project_history_pk_seq";
--
-- TOC Entry ID 2 (OID 466349)
--
-- Name: project_history_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "project_history_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 466349)
--
-- Name: project_history_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"project_history_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "project_metric_pk_seq";
--
-- TOC Entry ID 2 (OID 466407)
--
-- Name: project_metric_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "project_metric_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 466407)
--
-- Name: project_metric_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"project_metric_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "project_metric_tmp1_pk_seq";
--
-- TOC Entry ID 2 (OID 466443)
--
-- Name: project_metric_tmp1_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "project_metric_tmp1_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 466443)
--
-- Name: project_metric_tmp1_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"project_metric_tmp1_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "project_metric_weekly_tm_pk_seq";
--
-- TOC Entry ID 2 (OID 466479)
--
-- Name: project_metric_weekly_tm_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "project_metric_weekly_tm_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 466479)
--
-- Name: project_metric_weekly_tm_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"project_metric_weekly_tm_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "project_metric_wee_ranking1_seq";
--
-- TOC Entry ID 2 (OID 468085)
--
-- Name: project_metric_wee_ranking1_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "project_metric_wee_ranking1_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 468085)
--
-- Name: project_metric_wee_ranking1_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"project_metric_wee_ranking1_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "project_status_pk_seq";
--
-- TOC Entry ID 2 (OID 466498)
--
-- Name: project_status_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "project_status_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 466498)
--
-- Name: project_status_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"project_status_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "project_task_pk_seq";
--
-- TOC Entry ID 2 (OID 466548)
--
-- Name: project_task_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "project_task_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 466548)
--
-- Name: project_task_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"project_task_pk_seq"', 1, 't');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "project_weekly_metric_pk_seq";
--
-- TOC Entry ID 2 (OID 466616)
--
-- Name: project_weekly_metric_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "project_weekly_metric_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 466616)
--
-- Name: project_weekly_metric_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"project_weekly_metric_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "prweb_vhost_vhostid_seq";
--
-- TOC Entry ID 2 (OID 468216)
--
-- Name: prweb_vhost_vhostid_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "prweb_vhost_vhostid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 468216)
--
-- Name: prweb_vhost_vhostid_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"prweb_vhost_vhostid_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "snippet_package_item_pk_seq";
--
-- TOC Entry ID 2 (OID 466785)
--
-- Name: snippet_package_item_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "snippet_package_item_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 466785)
--
-- Name: snippet_package_item_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"snippet_package_item_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "snippet_package_pk_seq";
--
-- TOC Entry ID 2 (OID 466729)
--
-- Name: snippet_package_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "snippet_package_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 466729)
--
-- Name: snippet_package_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"snippet_package_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "snippet_package_version_pk_seq";
--
-- TOC Entry ID 2 (OID 466822)
--
-- Name: snippet_package_version_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "snippet_package_version_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 466822)
--
-- Name: snippet_package_version_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"snippet_package_version_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "snippet_pk_seq";
--
-- TOC Entry ID 2 (OID 466669)
--
-- Name: snippet_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "snippet_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 466669)
--
-- Name: snippet_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"snippet_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "snippet_version_pk_seq";
--
-- TOC Entry ID 2 (OID 466878)
--
-- Name: snippet_version_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "snippet_version_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 466878)
--
-- Name: snippet_version_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"snippet_version_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "supported_languages_pk_seq";
--
-- TOC Entry ID 2 (OID 466993)
--
-- Name: supported_languages_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "supported_languages_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 466993)
--
-- Name: supported_languages_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"supported_languages_pk_seq"', 23, 't');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "survey_questions_pk_seq";
--
-- TOC Entry ID 2 (OID 467095)
--
-- Name: survey_questions_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "survey_questions_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 467095)
--
-- Name: survey_questions_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"survey_questions_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "survey_question_types_pk_seq";
--
-- TOC Entry ID 2 (OID 467045)
--
-- Name: survey_question_types_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "survey_question_types_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 467045)
--
-- Name: survey_question_types_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"survey_question_types_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "surveys_pk_seq";
--
-- TOC Entry ID 2 (OID 467221)
--
-- Name: surveys_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "surveys_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 467221)
--
-- Name: surveys_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"surveys_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "system_history_pk_seq";
--
-- TOC Entry ID 2 (OID 467277)
--
-- Name: system_history_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "system_history_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 467277)
--
-- Name: system_history_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"system_history_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "system_machines_pk_seq";
--
-- TOC Entry ID 2 (OID 467296)
--
-- Name: system_machines_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "system_machines_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 467296)
--
-- Name: system_machines_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"system_machines_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "system_news_pk_seq";
--
-- TOC Entry ID 2 (OID 467315)
--
-- Name: system_news_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "system_news_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 467315)
--
-- Name: system_news_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"system_news_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "system_services_pk_seq";
--
-- TOC Entry ID 2 (OID 467334)
--
-- Name: system_services_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "system_services_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 467334)
--
-- Name: system_services_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"system_services_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "system_status_pk_seq";
--
-- TOC Entry ID 2 (OID 467353)
--
-- Name: system_status_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "system_status_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 467353)
--
-- Name: system_status_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"system_status_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "themes_pk_seq";
--
-- TOC Entry ID 2 (OID 467400)
--
-- Name: themes_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "themes_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 467400)
--
-- Name: themes_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"themes_pk_seq"', 1, 't');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "trove_cat_pk_seq";
--
-- TOC Entry ID 2 (OID 467477)
--
-- Name: trove_cat_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "trove_cat_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 467477)
--
-- Name: trove_cat_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"trove_cat_pk_seq"', 305, 't');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "trove_group_link_pk_seq";
--
-- TOC Entry ID 2 (OID 467541)
--
-- Name: trove_group_link_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "trove_group_link_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 467541)
--
-- Name: trove_group_link_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"trove_group_link_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "trove_treesums_pk_seq";
--
-- TOC Entry ID 2 (OID 467582)
--
-- Name: trove_treesums_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "trove_treesums_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 467582)
--
-- Name: trove_treesums_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"trove_treesums_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "trove_treesum_trove_treesum_seq";
--
-- TOC Entry ID 2 (OID 469781)
--
-- Name: trove_treesum_trove_treesum_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "trove_treesum_trove_treesum_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 469781)
--
-- Name: trove_treesum_trove_treesum_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"trove_treesum_trove_treesum_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "unix_uid_seq";
--
-- TOC Entry ID 2 (OID 468033)
--
-- Name: unix_uid_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "unix_uid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 468033)
--
-- Name: unix_uid_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"unix_uid_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "user_bookmarks_pk_seq";
--
-- TOC Entry ID 2 (OID 467601)
--
-- Name: user_bookmarks_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "user_bookmarks_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 467601)
--
-- Name: user_bookmarks_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"user_bookmarks_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "user_diary_monitor_pk_seq";
--
-- TOC Entry ID 2 (OID 467709)
--
-- Name: user_diary_monitor_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "user_diary_monitor_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 467709)
--
-- Name: user_diary_monitor_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"user_diary_monitor_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "user_diary_pk_seq";
--
-- TOC Entry ID 2 (OID 467653)
--
-- Name: user_diary_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "user_diary_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 467653)
--
-- Name: user_diary_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"user_diary_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "user_group_pk_seq";
--
-- TOC Entry ID 2 (OID 467746)
--
-- Name: user_group_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "user_group_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 467746)
--
-- Name: user_group_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"user_group_pk_seq"', 4, 't');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "user_metric0_pk_seq";
--
-- TOC Entry ID 2 (OID 467851)
--
-- Name: user_metric0_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "user_metric0_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 467851)
--
-- Name: user_metric0_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"user_metric0_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "user_metric_pk_seq";
--
-- TOC Entry ID 2 (OID 467804)
--
-- Name: user_metric_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "user_metric_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 467804)
--
-- Name: user_metric_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"user_metric_pk_seq"', 1, 'f');

--
-- Selected TOC Entries:
--
DROP SEQUENCE "users_pk_seq";
--
-- TOC Entry ID 2 (OID 467946)
--
-- Name: users_pk_seq Type: SEQUENCE Owner: sourceforge
--

CREATE SEQUENCE "users_pk_seq" start 102 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 3 (OID 467946)
--
-- Name: users_pk_seq Type: SEQUENCE SET Owner: 
--

SELECT setval ('"users_pk_seq"', 102, 'f');




DROP VIEW "artifact_file_user_vw";
--
-- TOC Entry ID 2 (OID 468860)
--
-- Name: artifact_file_user_vw Type: VIEW Owner: sourceforge
--

CREATE VIEW "artifact_file_user_vw" as SELECT af.id, af.artifact_id, af.description, af.bin_data, af.filename, af.filesize, af.filetype, af.adddate, af.submitted_by, users.user_name, users.realname FROM artifact_file af, users WHERE (af.submitted_by = users.user_id);

--
-- Selected TOC Entries:
--
DROP VIEW "artifact_history_user_vw";
--
-- TOC Entry ID 2 (OID 468782)
--
-- Name: artifact_history_user_vw Type: VIEW Owner: sourceforge
--

CREATE VIEW "artifact_history_user_vw" as SELECT ah.id, ah.artifact_id, ah.field_name, ah.old_value, ah.entrydate, users.user_name FROM artifact_history ah, users WHERE (ah.mod_by = users.user_id);

--
-- Selected TOC Entries:
--
DROP VIEW "artifact_message_user_vw";
--
-- TOC Entry ID 2 (OID 468933)
--
-- Name: artifact_message_user_vw Type: VIEW Owner: sourceforge
--

CREATE VIEW "artifact_message_user_vw" as SELECT am.id, am.artifact_id, am.from_email, am.body, am.adddate, users.user_id, users.email, users.user_name, users.realname FROM artifact_message am, users WHERE (am.submitted_by = users.user_id);

--
-- Selected TOC Entries:
--
DROP VIEW "artifactperm_artgrouplist_vw";
--
-- TOC Entry ID 2 (OID 468452)
--
-- Name: artifactperm_artgrouplist_vw Type: VIEW Owner: sourceforge
--

CREATE VIEW "artifactperm_artgrouplist_vw" as SELECT agl.group_artifact_id, agl.name, agl.description, agl.group_id, ap.user_id, ap.perm_level FROM artifact_perm ap, artifact_group_list agl WHERE (ap.group_artifact_id = agl.group_artifact_id);

--
-- Selected TOC Entries:
--
DROP VIEW "artifactperm_user_vw";
--
-- TOC Entry ID 2 (OID 468436)
--
-- Name: artifactperm_user_vw Type: VIEW Owner: sourceforge
--

CREATE VIEW "artifactperm_user_vw" as SELECT ap.id, ap.group_artifact_id, ap.user_id, ap.perm_level, users.user_name, users.realname FROM artifact_perm ap, users WHERE (users.user_id = ap.user_id);

--
-- Selected TOC Entries:
--
DROP VIEW "artifact_vw";
--
-- TOC Entry ID 2 (OID 468705)
--
-- Name: artifact_vw Type: VIEW Owner: sourceforge
--

CREATE VIEW "artifact_vw" as SELECT artifact.artifact_id, artifact.group_artifact_id, artifact.status_id, artifact.category_id, artifact.artifact_group_id, artifact.resolution_id, artifact.priority, artifact.submitted_by, artifact.assigned_to, artifact.open_date, artifact.close_date, artifact.summary, artifact.details, u.user_name AS assigned_unixname, u.realname AS assigned_realname, u.email AS assigned_email, u2.user_name AS submitted_unixname, u2.realname AS submitted_realname, u2.email AS submitted_email, artifact_status.status_name, artifact_category.category_name, artifact_group.group_name, artifact_resolution.resolution_name FROM users u, users u2, artifact, artifact_status, artifact_category, artifact_group, artifact_resolution WHERE ((((((artifact.assigned_to = u.user_id) AND (artifact.submitted_by = u2.user_id)) AND (artifact.status_id = artifact_status.id)) AND (artifact.category_id = artifact_category.id)) AND (artifact.artifact_group_id = artifact_group.id)) AND (artifact.resolution_id = artifact_resolution.id));

