2 -- Selected TOC Entries:
4 DROP TABLE "cache_store";
6 -- TOC Entry ID 2 (OID 469439)
8 -- Name: cache_store Type: TABLE Owner: sourceforge
11 CREATE TABLE "cache_store" (
12 "name" character varying(255) NOT NULL,
14 "indate" integer DEFAULT 0 NOT NULL,
15 Constraint "cache_store_pkey" Primary Key ("name")
19 -- Data for TOC Entry ID 3 (OID 469439)
21 -- Name: cache_store Type: TABLE DATA Owner: sourceforge
26 -- Selected TOC Entries:
28 DROP INDEX "foundryprojdlsagg_foundryid_dls";
29 DROP TABLE "foundry_project_downloads_agg";
31 -- TOC Entry ID 2 (OID 469499)
33 -- Name: foundry_project_downloads_agg Type: TABLE Owner: sourceforge
36 CREATE TABLE "foundry_project_downloads_agg" (
40 "group_name" character varying(40),
41 "unix_group_name" character varying(30)
45 -- Data for TOC Entry ID 4 (OID 469499)
47 -- Name: foundry_project_downloads_agg Type: TABLE DATA Owner: sourceforge
52 -- TOC Entry ID 3 (OID 469499)
54 -- Name: "foundryprojdlsagg_foundryid_dls" Type: INDEX Owner: sourceforge
57 CREATE INDEX "foundryprojdlsagg_foundryid_dls" on "foundry_project_downloads_agg" using btree ( "foundry_id" "int4_ops", "downloads" "int4_ops" );
60 -- Selected TOC Entries:
62 DROP INDEX "foundryprojectrankingsagg_found";
63 DROP TABLE "foundry_project_rankings_agg";
65 -- TOC Entry ID 2 (OID 469484)
67 -- Name: foundry_project_rankings_agg Type: TABLE Owner: sourceforge
70 CREATE TABLE "foundry_project_rankings_agg" (
73 "group_name" character varying(40),
74 "unix_group_name" character varying(30),
76 "percentile" double precision
80 -- Data for TOC Entry ID 4 (OID 469484)
82 -- Name: foundry_project_rankings_agg Type: TABLE DATA Owner: sourceforge
87 -- TOC Entry ID 3 (OID 469484)
89 -- Name: "foundryprojectrankingsagg_found" Type: INDEX Owner: sourceforge
92 CREATE INDEX "foundryprojectrankingsagg_found" on "foundry_project_rankings_agg" using btree ( "foundry_id" "int4_ops", "ranking" "int4_ops" );
95 -- Selected TOC Entries:
97 DROP INDEX "project_metric_group";
98 DROP TABLE "project_metric";
100 -- TOC Entry ID 2 (OID 466426)
102 -- Name: project_metric Type: TABLE Owner: sourceforge
105 CREATE TABLE "project_metric" (
106 "ranking" integer DEFAULT nextval('project_metric_pk_seq'::text) NOT NULL,
107 "percentile" double precision,
108 "group_id" integer DEFAULT '0' NOT NULL,
109 Constraint "project_metric_pkey" Primary Key ("ranking")
113 -- Data for TOC Entry ID 4 (OID 466426)
115 -- Name: project_metric Type: TABLE DATA Owner: sourceforge
120 -- TOC Entry ID 3 (OID 466426)
122 -- Name: "project_metric_group" Type: INDEX Owner: sourceforge
125 CREATE INDEX "project_metric_group" on "project_metric" using btree ( "group_id" "int4_ops" );
128 -- Selected TOC Entries:
130 DROP TABLE "project_metric_tmp1";
132 -- TOC Entry ID 2 (OID 466462)
134 -- Name: project_metric_tmp1 Type: TABLE Owner: sourceforge
137 CREATE TABLE "project_metric_tmp1" (
138 "ranking" integer DEFAULT nextval('project_metric_tmp1_pk_seq'::text) NOT NULL,
139 "group_id" integer DEFAULT '0' NOT NULL,
140 "value" double precision,
141 Constraint "project_metric_tmp1_pkey" Primary Key ("ranking")
145 -- Data for TOC Entry ID 3 (OID 466462)
147 -- Name: project_metric_tmp1 Type: TABLE DATA Owner: sourceforge
152 -- Selected TOC Entries:
154 DROP INDEX "statsprojectall_groupid";
155 DROP TABLE "stats_project_all";
157 -- TOC Entry ID 2 (OID 469584)
159 -- Name: stats_project_all Type: TABLE Owner: sourceforge
162 CREATE TABLE "stats_project_all" (
164 "developers" integer,
165 "group_ranking" integer,
166 "group_metric" double precision,
167 "logo_showings" integer,
169 "site_views" integer,
170 "subdomain_views" integer,
171 "page_views" integer,
172 "msg_posted" integer,
173 "msg_uniq_auth" integer,
174 "bugs_opened" integer,
175 "bugs_closed" integer,
176 "support_opened" integer,
177 "support_closed" integer,
178 "patches_opened" integer,
179 "patches_closed" integer,
180 "artifacts_opened" integer,
181 "artifacts_closed" integer,
182 "tasks_opened" integer,
183 "tasks_closed" integer,
184 "help_requests" integer,
185 "cvs_checkouts" integer,
186 "cvs_commits" integer,
191 -- Data for TOC Entry ID 4 (OID 469584)
193 -- Name: stats_project_all Type: TABLE DATA Owner: sourceforge
198 -- TOC Entry ID 3 (OID 469584)
200 -- Name: "statsprojectall_groupid" Type: INDEX Owner: sourceforge
203 CREATE INDEX "statsprojectall_groupid" on "stats_project_all" using btree ( "group_id" "int4_ops" );
206 -- Selected TOC Entries:
208 DROP TABLE "stats_project_developers_last30";
210 -- TOC Entry ID 2 (OID 469618)
212 -- Name: stats_project_developers_last30 Type: TABLE Owner: sourceforge
215 CREATE TABLE "stats_project_developers_last30" (
223 -- Data for TOC Entry ID 3 (OID 469618)
225 -- Name: stats_project_developers_last30 Type: TABLE DATA Owner: sourceforge
230 -- Selected TOC Entries:
232 DROP INDEX "statsproject30_groupid";
233 DROP TABLE "stats_project_last_30";
235 -- TOC Entry ID 2 (OID 469631)
237 -- Name: stats_project_last_30 Type: TABLE Owner: sourceforge
240 CREATE TABLE "stats_project_last_30" (
244 "developers" integer,
245 "group_ranking" integer,
246 "group_metric" double precision,
247 "logo_showings" integer,
249 "site_views" integer,
250 "subdomain_views" integer,
251 "page_views" integer,
252 "filereleases" integer,
253 "msg_posted" integer,
254 "msg_uniq_auth" integer,
255 "bugs_opened" integer,
256 "bugs_closed" integer,
257 "support_opened" integer,
258 "support_closed" integer,
259 "patches_opened" integer,
260 "patches_closed" integer,
261 "artifacts_opened" integer,
262 "artifacts_closed" integer,
263 "tasks_opened" integer,
264 "tasks_closed" integer,
265 "help_requests" integer,
266 "cvs_checkouts" integer,
267 "cvs_commits" integer,
272 -- Data for TOC Entry ID 4 (OID 469631)
274 -- Name: stats_project_last_30 Type: TABLE DATA Owner: sourceforge
279 -- TOC Entry ID 3 (OID 469631)
281 -- Name: "statsproject30_groupid" Type: INDEX Owner: sourceforge
284 CREATE INDEX "statsproject30_groupid" on "stats_project_last_30" using btree ( "group_id" "int4_ops" );
287 -- Selected TOC Entries:
289 DROP INDEX "statsprojectmonths_groupid_mont";
290 DROP INDEX "statsprojectmonths_groupid";
291 DROP TABLE "stats_project_months";
293 -- TOC Entry ID 2 (OID 469548)
295 -- Name: stats_project_months Type: TABLE Owner: sourceforge
298 CREATE TABLE "stats_project_months" (
301 "developers" integer,
302 "group_ranking" integer,
303 "group_metric" double precision,
304 "logo_showings" integer,
306 "site_views" integer,
307 "subdomain_views" integer,
308 "page_views" integer,
309 "file_releases" integer,
310 "msg_posted" integer,
311 "msg_uniq_auth" integer,
312 "bugs_opened" integer,
313 "bugs_closed" integer,
314 "support_opened" integer,
315 "support_closed" integer,
316 "patches_opened" integer,
317 "patches_closed" integer,
318 "artifacts_opened" integer,
319 "artifacts_closed" integer,
320 "tasks_opened" integer,
321 "tasks_closed" integer,
322 "help_requests" integer,
323 "cvs_checkouts" integer,
324 "cvs_commits" integer,
329 -- Data for TOC Entry ID 5 (OID 469548)
331 -- Name: stats_project_months Type: TABLE DATA Owner: sourceforge
336 -- TOC Entry ID 3 (OID 469548)
338 -- Name: "statsprojectmonths_groupid" Type: INDEX Owner: sourceforge
341 CREATE INDEX "statsprojectmonths_groupid" on "stats_project_months" using btree ( "group_id" "int4_ops" );
344 -- TOC Entry ID 4 (OID 469548)
346 -- Name: "statsprojectmonths_groupid_mont" Type: INDEX Owner: sourceforge
349 CREATE INDEX "statsprojectmonths_groupid_mont" on "stats_project_months" using btree ( "group_id" "int4_ops", "month" "int4_ops" );
352 -- Selected TOC Entries:
354 DROP TABLE "stats_site_all";
356 -- TOC Entry ID 2 (OID 469736)
358 -- Name: stats_site_all Type: TABLE Owner: sourceforge
361 CREATE TABLE "stats_site_all" (
362 "site_page_views" integer,
364 "subdomain_views" integer,
365 "msg_posted" integer,
366 "bugs_opened" integer,
367 "bugs_closed" integer,
368 "support_opened" integer,
369 "support_closed" integer,
370 "patches_opened" integer,
371 "patches_closed" integer,
372 "artifacts_opened" integer,
373 "artifacts_closed" integer,
374 "tasks_opened" integer,
375 "tasks_closed" integer,
376 "help_requests" integer,
377 "cvs_checkouts" integer,
378 "cvs_commits" integer,
383 -- Data for TOC Entry ID 3 (OID 469736)
385 -- Name: stats_site_all Type: TABLE DATA Owner: sourceforge
389 INSERT INTO "stats_site_all" VALUES (NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
391 -- Selected TOC Entries:
393 DROP INDEX "statssitelast30_month_day";
394 DROP TABLE "stats_site_last_30";
396 -- TOC Entry ID 2 (OID 469679)
398 -- Name: stats_site_last_30 Type: TABLE Owner: sourceforge
401 CREATE TABLE "stats_site_last_30" (
404 "site_page_views" integer,
406 "subdomain_views" integer,
407 "msg_posted" integer,
408 "bugs_opened" integer,
409 "bugs_closed" integer,
410 "support_opened" integer,
411 "support_closed" integer,
412 "patches_opened" integer,
413 "patches_closed" integer,
414 "artifacts_opened" integer,
415 "artifacts_closed" integer,
416 "tasks_opened" integer,
417 "tasks_closed" integer,
418 "help_requests" integer,
419 "cvs_checkouts" integer,
420 "cvs_commits" integer,
425 -- Data for TOC Entry ID 4 (OID 469679)
427 -- Name: stats_site_last_30 Type: TABLE DATA Owner: sourceforge
432 -- TOC Entry ID 3 (OID 469679)
434 -- Name: "statssitelast30_month_day" Type: INDEX Owner: sourceforge
437 CREATE INDEX "statssitelast30_month_day" on "stats_site_last_30" using btree ( "month" "int4_ops", "day" "int4_ops" );
440 -- Selected TOC Entries:
442 DROP INDEX "statssitemonths_month";
443 DROP TABLE "stats_site_months";
445 -- TOC Entry ID 2 (OID 469708)
447 -- Name: stats_site_months Type: TABLE Owner: sourceforge
450 CREATE TABLE "stats_site_months" (
452 "site_page_views" integer,
454 "subdomain_views" integer,
455 "msg_posted" integer,
456 "bugs_opened" integer,
457 "bugs_closed" integer,
458 "support_opened" integer,
459 "support_closed" integer,
460 "patches_opened" integer,
461 "patches_closed" integer,
462 "artifacts_opened" integer,
463 "artifacts_closed" integer,
464 "tasks_opened" integer,
465 "tasks_closed" integer,
466 "help_requests" integer,
467 "cvs_checkouts" integer,
468 "cvs_commits" integer,
473 -- Data for TOC Entry ID 4 (OID 469708)
475 -- Name: stats_site_months Type: TABLE DATA Owner: sourceforge
480 -- TOC Entry ID 3 (OID 469708)
482 -- Name: "statssitemonths_month" Type: INDEX Owner: sourceforge
485 CREATE INDEX "statssitemonths_month" on "stats_site_months" using btree ( "month" "int4_ops" );
488 -- Selected TOC Entries:
490 DROP INDEX "statssitepagesbyday_month_day";
491 DROP INDEX "statssitepgsbyday_oid";
492 DROP TABLE "stats_site_pages_by_day";
494 -- TOC Entry ID 2 (OID 469048)
496 -- Name: stats_site_pages_by_day Type: TABLE Owner: sourceforge
499 CREATE TABLE "stats_site_pages_by_day" (
502 "site_page_views" integer
506 -- Data for TOC Entry ID 5 (OID 469048)
508 -- Name: stats_site_pages_by_day Type: TABLE DATA Owner: sourceforge
513 -- TOC Entry ID 3 (OID 469048)
515 -- Name: "statssitepgsbyday_oid" Type: INDEX Owner: sourceforge
518 CREATE UNIQUE INDEX "statssitepgsbyday_oid" on "stats_site_pages_by_day" using btree ( "oid" "oid_ops" );
521 -- TOC Entry ID 4 (OID 469048)
523 -- Name: "statssitepagesbyday_month_day" Type: INDEX Owner: sourceforge
526 CREATE INDEX "statssitepagesbyday_month_day" on "stats_site_pages_by_day" using btree ( "month" "int4_ops", "day" "int4_ops" );
529 -- Selected TOC Entries:
531 DROP TABLE "stats_site_pages_by_month";
533 -- TOC Entry ID 2 (OID 469668)
535 -- Name: stats_site_pages_by_month Type: TABLE Owner: sourceforge
538 CREATE TABLE "stats_site_pages_by_month" (
540 "site_page_views" integer
544 -- Data for TOC Entry ID 3 (OID 469668)
546 -- Name: stats_site_pages_by_month Type: TABLE DATA Owner: sourceforge
551 -- Selected TOC Entries:
553 DROP SEQUENCE "artifact_artifact_id_seq";
555 -- TOC Entry ID 2 (OID 468604)
557 -- Name: artifact_artifact_id_seq Type: SEQUENCE Owner: sourceforge
560 CREATE SEQUENCE "artifact_artifact_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
563 -- TOC Entry ID 3 (OID 468604)
565 -- Name: artifact_artifact_id_seq Type: SEQUENCE SET Owner:
568 SELECT setval ('"artifact_artifact_id_seq"', 1, 'f');
571 -- Selected TOC Entries:
573 DROP SEQUENCE "artifact_canned_response_id_seq";
575 -- TOC Entry ID 2 (OID 468985)
577 -- Name: artifact_canned_response_id_seq Type: SEQUENCE Owner: sourceforge
580 CREATE SEQUENCE "artifact_canned_response_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
583 -- TOC Entry ID 3 (OID 468985)
585 -- Name: artifact_canned_response_id_seq Type: SEQUENCE SET Owner:
588 SELECT setval ('"artifact_canned_response_id_seq"', 1, 'f');
591 -- Selected TOC Entries:
593 DROP SEQUENCE "artifact_category_id_seq";
595 -- TOC Entry ID 2 (OID 468453)
597 -- Name: artifact_category_id_seq Type: SEQUENCE Owner: sourceforge
600 CREATE SEQUENCE "artifact_category_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
603 -- TOC Entry ID 3 (OID 468453)
605 -- Name: artifact_category_id_seq Type: SEQUENCE SET Owner:
608 SELECT setval ('"artifact_category_id_seq"', 100, 't');
611 -- Selected TOC Entries:
613 DROP SEQUENCE "artifact_file_id_seq";
615 -- TOC Entry ID 2 (OID 468783)
617 -- Name: artifact_file_id_seq Type: SEQUENCE Owner: sourceforge
620 CREATE SEQUENCE "artifact_file_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
623 -- TOC Entry ID 3 (OID 468783)
625 -- Name: artifact_file_id_seq Type: SEQUENCE SET Owner:
628 SELECT setval ('"artifact_file_id_seq"', 1, 'f');
631 -- Selected TOC Entries:
633 DROP SEQUENCE "artifact_grou_group_artifac_seq";
635 -- TOC Entry ID 2 (OID 468268)
637 -- Name: artifact_grou_group_artifac_seq Type: SEQUENCE Owner: sourceforge
640 CREATE SEQUENCE "artifact_grou_group_artifac_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
643 -- TOC Entry ID 3 (OID 468268)
645 -- Name: artifact_grou_group_artifac_seq Type: SEQUENCE SET Owner:
648 SELECT setval ('"artifact_grou_group_artifac_seq"', 100, 't');
651 -- Selected TOC Entries:
653 DROP SEQUENCE "artifact_group_id_seq";
655 -- TOC Entry ID 2 (OID 468505)
657 -- Name: artifact_group_id_seq Type: SEQUENCE Owner: sourceforge
660 CREATE SEQUENCE "artifact_group_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
663 -- TOC Entry ID 3 (OID 468505)
665 -- Name: artifact_group_id_seq Type: SEQUENCE SET Owner:
668 SELECT setval ('"artifact_group_id_seq"', 1, 'f');
671 -- Selected TOC Entries:
673 DROP SEQUENCE "artifact_history_id_seq";
675 -- TOC Entry ID 2 (OID 468709)
677 -- Name: artifact_history_id_seq Type: SEQUENCE Owner: sourceforge
680 CREATE SEQUENCE "artifact_history_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
683 -- TOC Entry ID 3 (OID 468709)
685 -- Name: artifact_history_id_seq Type: SEQUENCE SET Owner:
688 SELECT setval ('"artifact_history_id_seq"', 1, 'f');
691 -- Selected TOC Entries:
693 DROP SEQUENCE "artifact_message_id_seq";
695 -- TOC Entry ID 2 (OID 468861)
697 -- Name: artifact_message_id_seq Type: SEQUENCE Owner: sourceforge
700 CREATE SEQUENCE "artifact_message_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
703 -- TOC Entry ID 3 (OID 468861)
705 -- Name: artifact_message_id_seq Type: SEQUENCE SET Owner:
708 SELECT setval ('"artifact_message_id_seq"', 1, 'f');
711 -- Selected TOC Entries:
713 DROP SEQUENCE "artifact_monitor_id_seq";
715 -- TOC Entry ID 2 (OID 468934)
717 -- Name: artifact_monitor_id_seq Type: SEQUENCE Owner: sourceforge
720 CREATE SEQUENCE "artifact_monitor_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
723 -- TOC Entry ID 3 (OID 468934)
725 -- Name: artifact_monitor_id_seq Type: SEQUENCE SET Owner:
728 SELECT setval ('"artifact_monitor_id_seq"', 1, 'f');
731 -- Selected TOC Entries:
733 DROP SEQUENCE "artifact_perm_id_seq";
735 -- TOC Entry ID 2 (OID 468384)
737 -- Name: artifact_perm_id_seq Type: SEQUENCE Owner: sourceforge
740 CREATE SEQUENCE "artifact_perm_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
743 -- TOC Entry ID 3 (OID 468384)
745 -- Name: artifact_perm_id_seq Type: SEQUENCE SET Owner:
748 SELECT setval ('"artifact_perm_id_seq"', 1, 'f');
751 -- Selected TOC Entries:
753 DROP SEQUENCE "artifact_resolution_id_seq";
755 -- TOC Entry ID 2 (OID 468335)
757 -- Name: artifact_resolution_id_seq Type: SEQUENCE Owner: sourceforge
760 CREATE SEQUENCE "artifact_resolution_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
763 -- TOC Entry ID 3 (OID 468335)
765 -- Name: artifact_resolution_id_seq Type: SEQUENCE SET Owner:
768 SELECT setval ('"artifact_resolution_id_seq"', 1, 'f');
771 -- Selected TOC Entries:
773 DROP SEQUENCE "artifact_status_id_seq";
775 -- TOC Entry ID 2 (OID 468555)
777 -- Name: artifact_status_id_seq Type: SEQUENCE Owner: sourceforge
780 CREATE SEQUENCE "artifact_status_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
783 -- TOC Entry ID 3 (OID 468555)
785 -- Name: artifact_status_id_seq Type: SEQUENCE SET Owner:
788 SELECT setval ('"artifact_status_id_seq"', 3, 't');
791 -- Selected TOC Entries:
793 DROP SEQUENCE "canned_responses_pk_seq";
795 -- TOC Entry ID 2 (OID 464514)
797 -- Name: canned_responses_pk_seq Type: SEQUENCE Owner: sourceforge
800 CREATE SEQUENCE "canned_responses_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
803 -- TOC Entry ID 3 (OID 464514)
805 -- Name: canned_responses_pk_seq Type: SEQUENCE SET Owner:
808 SELECT setval ('"canned_responses_pk_seq"', 1, 'f');
811 -- Selected TOC Entries:
813 DROP SEQUENCE "db_images_pk_seq";
815 -- TOC Entry ID 2 (OID 464564)
817 -- Name: db_images_pk_seq Type: SEQUENCE Owner: sourceforge
820 CREATE SEQUENCE "db_images_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
823 -- TOC Entry ID 3 (OID 464564)
825 -- Name: db_images_pk_seq Type: SEQUENCE SET Owner:
828 SELECT setval ('"db_images_pk_seq"', 1, 'f');
831 -- Selected TOC Entries:
833 DROP SEQUENCE "doc_data_pk_seq";
835 -- TOC Entry ID 2 (OID 464630)
837 -- Name: doc_data_pk_seq Type: SEQUENCE Owner: sourceforge
840 CREATE SEQUENCE "doc_data_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
843 -- TOC Entry ID 3 (OID 464630)
845 -- Name: doc_data_pk_seq Type: SEQUENCE SET Owner:
848 SELECT setval ('"doc_data_pk_seq"', 1, 'f');
851 -- Selected TOC Entries:
853 DROP SEQUENCE "doc_groups_pk_seq";
855 -- TOC Entry ID 2 (OID 464695)
857 -- Name: doc_groups_pk_seq Type: SEQUENCE Owner: sourceforge
860 CREATE SEQUENCE "doc_groups_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
863 -- TOC Entry ID 3 (OID 464695)
865 -- Name: doc_groups_pk_seq Type: SEQUENCE SET Owner:
868 SELECT setval ('"doc_groups_pk_seq"', 1, 'f');
871 -- Selected TOC Entries:
873 DROP SEQUENCE "doc_states_pk_seq";
875 -- TOC Entry ID 2 (OID 464732)
877 -- Name: doc_states_pk_seq Type: SEQUENCE Owner: sourceforge
880 CREATE SEQUENCE "doc_states_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
883 -- TOC Entry ID 3 (OID 464732)
885 -- Name: doc_states_pk_seq Type: SEQUENCE SET Owner:
888 SELECT setval ('"doc_states_pk_seq"', 1, 'f');
891 -- Selected TOC Entries:
893 DROP SEQUENCE "filemodule_monitor_pk_seq";
895 -- TOC Entry ID 2 (OID 464767)
897 -- Name: filemodule_monitor_pk_seq Type: SEQUENCE Owner: sourceforge
900 CREATE SEQUENCE "filemodule_monitor_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
903 -- TOC Entry ID 3 (OID 464767)
905 -- Name: filemodule_monitor_pk_seq Type: SEQUENCE SET Owner:
908 SELECT setval ('"filemodule_monitor_pk_seq"', 1, 'f');
911 -- Selected TOC Entries:
913 DROP SEQUENCE "forum_group_list_pk_seq";
915 -- TOC Entry ID 2 (OID 464886)
917 -- Name: forum_group_list_pk_seq Type: SEQUENCE Owner: sourceforge
920 CREATE SEQUENCE "forum_group_list_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
923 -- TOC Entry ID 3 (OID 464886)
925 -- Name: forum_group_list_pk_seq Type: SEQUENCE SET Owner:
928 SELECT setval ('"forum_group_list_pk_seq"', 1, 'f');
931 -- Selected TOC Entries:
933 DROP SEQUENCE "forum_monitored_forums_pk_seq";
935 -- TOC Entry ID 2 (OID 464944)
937 -- Name: forum_monitored_forums_pk_seq Type: SEQUENCE Owner: sourceforge
940 CREATE SEQUENCE "forum_monitored_forums_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
943 -- TOC Entry ID 3 (OID 464944)
945 -- Name: forum_monitored_forums_pk_seq Type: SEQUENCE SET Owner:
948 SELECT setval ('"forum_monitored_forums_pk_seq"', 1, 'f');
951 -- Selected TOC Entries:
953 DROP SEQUENCE "forum_pk_seq";
955 -- TOC Entry ID 2 (OID 464804)
957 -- Name: forum_pk_seq Type: SEQUENCE Owner: sourceforge
960 CREATE SEQUENCE "forum_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
963 -- TOC Entry ID 3 (OID 464804)
965 -- Name: forum_pk_seq Type: SEQUENCE SET Owner:
968 SELECT setval ('"forum_pk_seq"', 1, 'f');
971 -- Selected TOC Entries:
973 DROP SEQUENCE "forum_saved_place_pk_seq";
975 -- TOC Entry ID 2 (OID 464981)
977 -- Name: forum_saved_place_pk_seq Type: SEQUENCE Owner: sourceforge
980 CREATE SEQUENCE "forum_saved_place_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
983 -- TOC Entry ID 3 (OID 464981)
985 -- Name: forum_saved_place_pk_seq Type: SEQUENCE SET Owner:
988 SELECT setval ('"forum_saved_place_pk_seq"', 1, 'f');
991 -- Selected TOC Entries:
993 DROP SEQUENCE "forum_thread_seq";
995 -- TOC Entry ID 2 (OID 468052)
997 -- Name: forum_thread_seq Type: SEQUENCE Owner: sourceforge
1000 CREATE SEQUENCE "forum_thread_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1003 -- TOC Entry ID 3 (OID 468052)
1005 -- Name: forum_thread_seq Type: SEQUENCE SET Owner:
1008 SELECT setval ('"forum_thread_seq"', 1, 'f');
1011 -- Selected TOC Entries:
1013 DROP SEQUENCE "foundry_news_pk_seq";
1015 -- TOC Entry ID 2 (OID 465058)
1017 -- Name: foundry_news_pk_seq Type: SEQUENCE Owner: sourceforge
1020 CREATE SEQUENCE "foundry_news_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1023 -- TOC Entry ID 3 (OID 465058)
1025 -- Name: foundry_news_pk_seq Type: SEQUENCE SET Owner:
1028 SELECT setval ('"foundry_news_pk_seq"', 1, 'f');
1031 -- Selected TOC Entries:
1033 DROP SEQUENCE "foundry_preferred_projec_pk_seq";
1035 -- TOC Entry ID 2 (OID 465099)
1037 -- Name: foundry_preferred_projec_pk_seq Type: SEQUENCE Owner: sourceforge
1040 CREATE SEQUENCE "foundry_preferred_projec_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1043 -- TOC Entry ID 3 (OID 465099)
1045 -- Name: foundry_preferred_projec_pk_seq Type: SEQUENCE SET Owner:
1048 SELECT setval ('"foundry_preferred_projec_pk_seq"', 1, 'f');
1051 -- Selected TOC Entries:
1053 DROP SEQUENCE "foundry_projects_pk_seq";
1055 -- TOC Entry ID 2 (OID 465138)
1057 -- Name: foundry_projects_pk_seq Type: SEQUENCE Owner: sourceforge
1060 CREATE SEQUENCE "foundry_projects_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1063 -- TOC Entry ID 3 (OID 465138)
1065 -- Name: foundry_projects_pk_seq Type: SEQUENCE SET Owner:
1068 SELECT setval ('"foundry_projects_pk_seq"', 1, 'f');
1071 -- Selected TOC Entries:
1073 DROP SEQUENCE "frs_file_pk_seq";
1075 -- TOC Entry ID 2 (OID 465175)
1077 -- Name: frs_file_pk_seq Type: SEQUENCE Owner: sourceforge
1080 CREATE SEQUENCE "frs_file_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1083 -- TOC Entry ID 3 (OID 465175)
1085 -- Name: frs_file_pk_seq Type: SEQUENCE SET Owner:
1088 SELECT setval ('"frs_file_pk_seq"', 1, 'f');
1091 -- Selected TOC Entries:
1093 DROP SEQUENCE "frs_filetype_pk_seq";
1095 -- TOC Entry ID 2 (OID 465236)
1097 -- Name: frs_filetype_pk_seq Type: SEQUENCE Owner: sourceforge
1100 CREATE SEQUENCE "frs_filetype_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1103 -- TOC Entry ID 3 (OID 465236)
1105 -- Name: frs_filetype_pk_seq Type: SEQUENCE SET Owner:
1108 SELECT setval ('"frs_filetype_pk_seq"', 9999, 't');
1111 -- Selected TOC Entries:
1113 DROP SEQUENCE "frs_package_pk_seq";
1115 -- TOC Entry ID 2 (OID 465285)
1117 -- Name: frs_package_pk_seq Type: SEQUENCE Owner: sourceforge
1120 CREATE SEQUENCE "frs_package_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1123 -- TOC Entry ID 3 (OID 465285)
1125 -- Name: frs_package_pk_seq Type: SEQUENCE SET Owner:
1128 SELECT setval ('"frs_package_pk_seq"', 1, 'f');
1131 -- Selected TOC Entries:
1133 DROP SEQUENCE "frs_processor_pk_seq";
1135 -- TOC Entry ID 2 (OID 465338)
1137 -- Name: frs_processor_pk_seq Type: SEQUENCE Owner: sourceforge
1140 CREATE SEQUENCE "frs_processor_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1143 -- TOC Entry ID 3 (OID 465338)
1145 -- Name: frs_processor_pk_seq Type: SEQUENCE SET Owner:
1148 SELECT setval ('"frs_processor_pk_seq"', 9999, 't');
1151 -- Selected TOC Entries:
1153 DROP SEQUENCE "frs_release_pk_seq";
1155 -- TOC Entry ID 2 (OID 465387)
1157 -- Name: frs_release_pk_seq Type: SEQUENCE Owner: sourceforge
1160 CREATE SEQUENCE "frs_release_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1163 -- TOC Entry ID 3 (OID 465387)
1165 -- Name: frs_release_pk_seq Type: SEQUENCE SET Owner:
1168 SELECT setval ('"frs_release_pk_seq"', 1, 'f');
1171 -- Selected TOC Entries:
1173 DROP SEQUENCE "frs_status_pk_seq";
1175 -- TOC Entry ID 2 (OID 465448)
1177 -- Name: frs_status_pk_seq Type: SEQUENCE Owner: sourceforge
1180 CREATE SEQUENCE "frs_status_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1183 -- TOC Entry ID 3 (OID 465448)
1185 -- Name: frs_status_pk_seq Type: SEQUENCE SET Owner:
1188 SELECT setval ('"frs_status_pk_seq"', 3, 't');
1191 -- Selected TOC Entries:
1193 DROP SEQUENCE "group_cvs_history_pk_seq";
1195 -- TOC Entry ID 2 (OID 465497)
1197 -- Name: group_cvs_history_pk_seq Type: SEQUENCE Owner: sourceforge
1200 CREATE SEQUENCE "group_cvs_history_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1203 -- TOC Entry ID 3 (OID 465497)
1205 -- Name: group_cvs_history_pk_seq Type: SEQUENCE SET Owner:
1208 SELECT setval ('"group_cvs_history_pk_seq"', 1, 'f');
1211 -- Selected TOC Entries:
1213 DROP SEQUENCE "group_history_pk_seq";
1215 -- TOC Entry ID 2 (OID 465516)
1217 -- Name: group_history_pk_seq Type: SEQUENCE Owner: sourceforge
1220 CREATE SEQUENCE "group_history_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1223 -- TOC Entry ID 3 (OID 465516)
1225 -- Name: group_history_pk_seq Type: SEQUENCE SET Owner:
1228 SELECT setval ('"group_history_pk_seq"', 1, 'f');
1231 -- Selected TOC Entries:
1233 DROP SEQUENCE "groups_pk_seq";
1235 -- TOC Entry ID 2 (OID 465622)
1237 -- Name: groups_pk_seq Type: SEQUENCE Owner: sourceforge
1240 CREATE SEQUENCE "groups_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1243 -- TOC Entry ID 3 (OID 465622)
1245 -- Name: groups_pk_seq Type: SEQUENCE SET Owner:
1248 SELECT setval ('"groups_pk_seq"', 4, 't');
1251 -- Selected TOC Entries:
1253 DROP SEQUENCE "group_type_pk_seq";
1255 -- TOC Entry ID 2 (OID 465573)
1257 -- Name: group_type_pk_seq Type: SEQUENCE Owner: sourceforge
1260 CREATE SEQUENCE "group_type_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1263 -- TOC Entry ID 3 (OID 465573)
1265 -- Name: group_type_pk_seq Type: SEQUENCE SET Owner:
1268 SELECT setval ('"group_type_pk_seq"', 1, 'f');
1271 -- Selected TOC Entries:
1273 DROP SEQUENCE "mail_group_list_pk_seq";
1275 -- TOC Entry ID 2 (OID 465712)
1277 -- Name: mail_group_list_pk_seq Type: SEQUENCE Owner: sourceforge
1280 CREATE SEQUENCE "mail_group_list_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1283 -- TOC Entry ID 3 (OID 465712)
1285 -- Name: mail_group_list_pk_seq Type: SEQUENCE SET Owner:
1288 SELECT setval ('"mail_group_list_pk_seq"', 1, 'f');
1291 -- Selected TOC Entries:
1293 DROP SEQUENCE "massmail_queue_id_seq";
1295 -- TOC Entry ID 2 (OID 469063)
1297 -- Name: massmail_queue_id_seq Type: SEQUENCE Owner: sourceforge
1300 CREATE SEQUENCE "massmail_queue_id_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1303 -- TOC Entry ID 3 (OID 469063)
1305 -- Name: massmail_queue_id_seq Type: SEQUENCE SET Owner:
1308 SELECT setval ('"massmail_queue_id_seq"', 1, 'f');
1311 -- Selected TOC Entries:
1313 DROP SEQUENCE "news_bytes_pk_seq";
1315 -- TOC Entry ID 2 (OID 465771)
1317 -- Name: news_bytes_pk_seq Type: SEQUENCE Owner: sourceforge
1320 CREATE SEQUENCE "news_bytes_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1323 -- TOC Entry ID 3 (OID 465771)
1325 -- Name: news_bytes_pk_seq Type: SEQUENCE SET Owner:
1328 SELECT setval ('"news_bytes_pk_seq"', 1, 'f');
1331 -- Selected TOC Entries:
1333 DROP SEQUENCE "people_job_category_pk_seq";
1335 -- TOC Entry ID 2 (OID 465891)
1337 -- Name: people_job_category_pk_seq Type: SEQUENCE Owner: sourceforge
1340 CREATE SEQUENCE "people_job_category_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1343 -- TOC Entry ID 3 (OID 465891)
1345 -- Name: people_job_category_pk_seq Type: SEQUENCE SET Owner:
1348 SELECT setval ('"people_job_category_pk_seq"', 7, 't');
1351 -- Selected TOC Entries:
1353 DROP SEQUENCE "people_job_inventory_pk_seq";
1355 -- TOC Entry ID 2 (OID 465942)
1357 -- Name: people_job_inventory_pk_seq Type: SEQUENCE Owner: sourceforge
1360 CREATE SEQUENCE "people_job_inventory_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1363 -- TOC Entry ID 3 (OID 465942)
1365 -- Name: people_job_inventory_pk_seq Type: SEQUENCE SET Owner:
1368 SELECT setval ('"people_job_inventory_pk_seq"', 1, 'f');
1371 -- Selected TOC Entries:
1373 DROP SEQUENCE "people_job_pk_seq";
1375 -- TOC Entry ID 2 (OID 465831)
1377 -- Name: people_job_pk_seq Type: SEQUENCE Owner: sourceforge
1380 CREATE SEQUENCE "people_job_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1383 -- TOC Entry ID 3 (OID 465831)
1385 -- Name: people_job_pk_seq Type: SEQUENCE SET Owner:
1388 SELECT setval ('"people_job_pk_seq"', 1, 'f');
1391 -- Selected TOC Entries:
1393 DROP SEQUENCE "people_job_status_pk_seq";
1395 -- TOC Entry ID 2 (OID 465983)
1397 -- Name: people_job_status_pk_seq Type: SEQUENCE Owner: sourceforge
1400 CREATE SEQUENCE "people_job_status_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1403 -- TOC Entry ID 3 (OID 465983)
1405 -- Name: people_job_status_pk_seq Type: SEQUENCE SET Owner:
1408 SELECT setval ('"people_job_status_pk_seq"', 1, 'f');
1411 -- Selected TOC Entries:
1413 DROP SEQUENCE "people_skill_inventory_pk_seq";
1415 -- TOC Entry ID 2 (OID 466081)
1417 -- Name: people_skill_inventory_pk_seq Type: SEQUENCE Owner: sourceforge
1420 CREATE SEQUENCE "people_skill_inventory_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1423 -- TOC Entry ID 3 (OID 466081)
1425 -- Name: people_skill_inventory_pk_seq Type: SEQUENCE SET Owner:
1428 SELECT setval ('"people_skill_inventory_pk_seq"', 1, 'f');
1431 -- Selected TOC Entries:
1433 DROP SEQUENCE "people_skill_level_pk_seq";
1435 -- TOC Entry ID 2 (OID 466122)
1437 -- Name: people_skill_level_pk_seq Type: SEQUENCE Owner: sourceforge
1440 CREATE SEQUENCE "people_skill_level_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1443 -- TOC Entry ID 3 (OID 466122)
1445 -- Name: people_skill_level_pk_seq Type: SEQUENCE SET Owner:
1448 SELECT setval ('"people_skill_level_pk_seq"', 5, 't');
1451 -- Selected TOC Entries:
1453 DROP SEQUENCE "people_skill_pk_seq";
1455 -- TOC Entry ID 2 (OID 466032)
1457 -- Name: people_skill_pk_seq Type: SEQUENCE Owner: sourceforge
1460 CREATE SEQUENCE "people_skill_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1463 -- TOC Entry ID 3 (OID 466032)
1465 -- Name: people_skill_pk_seq Type: SEQUENCE SET Owner:
1468 SELECT setval ('"people_skill_pk_seq"', 9, 't');
1471 -- Selected TOC Entries:
1473 DROP SEQUENCE "people_skill_year_pk_seq";
1475 -- TOC Entry ID 2 (OID 466171)
1477 -- Name: people_skill_year_pk_seq Type: SEQUENCE Owner: sourceforge
1480 CREATE SEQUENCE "people_skill_year_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1483 -- TOC Entry ID 3 (OID 466171)
1485 -- Name: people_skill_year_pk_seq Type: SEQUENCE SET Owner:
1488 SELECT setval ('"people_skill_year_pk_seq"', 5, 't');
1491 -- Selected TOC Entries:
1493 DROP SEQUENCE "prdb_dbs_dbid_seq";
1495 -- TOC Entry ID 2 (OID 468104)
1497 -- Name: prdb_dbs_dbid_seq Type: SEQUENCE Owner: sourceforge
1500 CREATE SEQUENCE "prdb_dbs_dbid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1503 -- TOC Entry ID 3 (OID 468104)
1505 -- Name: prdb_dbs_dbid_seq Type: SEQUENCE SET Owner:
1508 SELECT setval ('"prdb_dbs_dbid_seq"', 1, 'f');
1511 -- Selected TOC Entries:
1513 DROP SEQUENCE "project_assigned_to_pk_seq";
1515 -- TOC Entry ID 2 (OID 466220)
1517 -- Name: project_assigned_to_pk_seq Type: SEQUENCE Owner: sourceforge
1520 CREATE SEQUENCE "project_assigned_to_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1523 -- TOC Entry ID 3 (OID 466220)
1525 -- Name: project_assigned_to_pk_seq Type: SEQUENCE SET Owner:
1528 SELECT setval ('"project_assigned_to_pk_seq"', 1, 'f');
1531 -- Selected TOC Entries:
1533 DROP SEQUENCE "project_dependencies_pk_seq";
1535 -- TOC Entry ID 2 (OID 466257)
1537 -- Name: project_dependencies_pk_seq Type: SEQUENCE Owner: sourceforge
1540 CREATE SEQUENCE "project_dependencies_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1543 -- TOC Entry ID 3 (OID 466257)
1545 -- Name: project_dependencies_pk_seq Type: SEQUENCE SET Owner:
1548 SELECT setval ('"project_dependencies_pk_seq"', 1, 'f');
1551 -- Selected TOC Entries:
1553 DROP SEQUENCE "project_group_list_pk_seq";
1555 -- TOC Entry ID 2 (OID 466294)
1557 -- Name: project_group_list_pk_seq Type: SEQUENCE Owner: sourceforge
1560 CREATE SEQUENCE "project_group_list_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1563 -- TOC Entry ID 3 (OID 466294)
1565 -- Name: project_group_list_pk_seq Type: SEQUENCE SET Owner:
1568 SELECT setval ('"project_group_list_pk_seq"', 1, 't');
1571 -- Selected TOC Entries:
1573 DROP SEQUENCE "project_history_pk_seq";
1575 -- TOC Entry ID 2 (OID 466349)
1577 -- Name: project_history_pk_seq Type: SEQUENCE Owner: sourceforge
1580 CREATE SEQUENCE "project_history_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1583 -- TOC Entry ID 3 (OID 466349)
1585 -- Name: project_history_pk_seq Type: SEQUENCE SET Owner:
1588 SELECT setval ('"project_history_pk_seq"', 1, 'f');
1591 -- Selected TOC Entries:
1593 DROP SEQUENCE "project_metric_pk_seq";
1595 -- TOC Entry ID 2 (OID 466407)
1597 -- Name: project_metric_pk_seq Type: SEQUENCE Owner: sourceforge
1600 CREATE SEQUENCE "project_metric_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1603 -- TOC Entry ID 3 (OID 466407)
1605 -- Name: project_metric_pk_seq Type: SEQUENCE SET Owner:
1608 SELECT setval ('"project_metric_pk_seq"', 1, 'f');
1611 -- Selected TOC Entries:
1613 DROP SEQUENCE "project_metric_tmp1_pk_seq";
1615 -- TOC Entry ID 2 (OID 466443)
1617 -- Name: project_metric_tmp1_pk_seq Type: SEQUENCE Owner: sourceforge
1620 CREATE SEQUENCE "project_metric_tmp1_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1623 -- TOC Entry ID 3 (OID 466443)
1625 -- Name: project_metric_tmp1_pk_seq Type: SEQUENCE SET Owner:
1628 SELECT setval ('"project_metric_tmp1_pk_seq"', 1, 'f');
1631 -- Selected TOC Entries:
1633 DROP SEQUENCE "project_metric_weekly_tm_pk_seq";
1635 -- TOC Entry ID 2 (OID 466479)
1637 -- Name: project_metric_weekly_tm_pk_seq Type: SEQUENCE Owner: sourceforge
1640 CREATE SEQUENCE "project_metric_weekly_tm_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1643 -- TOC Entry ID 3 (OID 466479)
1645 -- Name: project_metric_weekly_tm_pk_seq Type: SEQUENCE SET Owner:
1648 SELECT setval ('"project_metric_weekly_tm_pk_seq"', 1, 'f');
1651 -- Selected TOC Entries:
1653 DROP SEQUENCE "project_metric_wee_ranking1_seq";
1655 -- TOC Entry ID 2 (OID 468085)
1657 -- Name: project_metric_wee_ranking1_seq Type: SEQUENCE Owner: sourceforge
1660 CREATE SEQUENCE "project_metric_wee_ranking1_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1663 -- TOC Entry ID 3 (OID 468085)
1665 -- Name: project_metric_wee_ranking1_seq Type: SEQUENCE SET Owner:
1668 SELECT setval ('"project_metric_wee_ranking1_seq"', 1, 'f');
1671 -- Selected TOC Entries:
1673 DROP SEQUENCE "project_status_pk_seq";
1675 -- TOC Entry ID 2 (OID 466498)
1677 -- Name: project_status_pk_seq Type: SEQUENCE Owner: sourceforge
1680 CREATE SEQUENCE "project_status_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1683 -- TOC Entry ID 3 (OID 466498)
1685 -- Name: project_status_pk_seq Type: SEQUENCE SET Owner:
1688 SELECT setval ('"project_status_pk_seq"', 1, 'f');
1691 -- Selected TOC Entries:
1693 DROP SEQUENCE "project_task_pk_seq";
1695 -- TOC Entry ID 2 (OID 466548)
1697 -- Name: project_task_pk_seq Type: SEQUENCE Owner: sourceforge
1700 CREATE SEQUENCE "project_task_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1703 -- TOC Entry ID 3 (OID 466548)
1705 -- Name: project_task_pk_seq Type: SEQUENCE SET Owner:
1708 SELECT setval ('"project_task_pk_seq"', 1, 't');
1711 -- Selected TOC Entries:
1713 DROP SEQUENCE "project_weekly_metric_pk_seq";
1715 -- TOC Entry ID 2 (OID 466616)
1717 -- Name: project_weekly_metric_pk_seq Type: SEQUENCE Owner: sourceforge
1720 CREATE SEQUENCE "project_weekly_metric_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1723 -- TOC Entry ID 3 (OID 466616)
1725 -- Name: project_weekly_metric_pk_seq Type: SEQUENCE SET Owner:
1728 SELECT setval ('"project_weekly_metric_pk_seq"', 1, 'f');
1731 -- Selected TOC Entries:
1733 DROP SEQUENCE "prweb_vhost_vhostid_seq";
1735 -- TOC Entry ID 2 (OID 468216)
1737 -- Name: prweb_vhost_vhostid_seq Type: SEQUENCE Owner: sourceforge
1740 CREATE SEQUENCE "prweb_vhost_vhostid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1743 -- TOC Entry ID 3 (OID 468216)
1745 -- Name: prweb_vhost_vhostid_seq Type: SEQUENCE SET Owner:
1748 SELECT setval ('"prweb_vhost_vhostid_seq"', 1, 'f');
1751 -- Selected TOC Entries:
1753 DROP SEQUENCE "snippet_package_item_pk_seq";
1755 -- TOC Entry ID 2 (OID 466785)
1757 -- Name: snippet_package_item_pk_seq Type: SEQUENCE Owner: sourceforge
1760 CREATE SEQUENCE "snippet_package_item_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1763 -- TOC Entry ID 3 (OID 466785)
1765 -- Name: snippet_package_item_pk_seq Type: SEQUENCE SET Owner:
1768 SELECT setval ('"snippet_package_item_pk_seq"', 1, 'f');
1771 -- Selected TOC Entries:
1773 DROP SEQUENCE "snippet_package_pk_seq";
1775 -- TOC Entry ID 2 (OID 466729)
1777 -- Name: snippet_package_pk_seq Type: SEQUENCE Owner: sourceforge
1780 CREATE SEQUENCE "snippet_package_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1783 -- TOC Entry ID 3 (OID 466729)
1785 -- Name: snippet_package_pk_seq Type: SEQUENCE SET Owner:
1788 SELECT setval ('"snippet_package_pk_seq"', 1, 'f');
1791 -- Selected TOC Entries:
1793 DROP SEQUENCE "snippet_package_version_pk_seq";
1795 -- TOC Entry ID 2 (OID 466822)
1797 -- Name: snippet_package_version_pk_seq Type: SEQUENCE Owner: sourceforge
1800 CREATE SEQUENCE "snippet_package_version_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1803 -- TOC Entry ID 3 (OID 466822)
1805 -- Name: snippet_package_version_pk_seq Type: SEQUENCE SET Owner:
1808 SELECT setval ('"snippet_package_version_pk_seq"', 1, 'f');
1811 -- Selected TOC Entries:
1813 DROP SEQUENCE "snippet_pk_seq";
1815 -- TOC Entry ID 2 (OID 466669)
1817 -- Name: snippet_pk_seq Type: SEQUENCE Owner: sourceforge
1820 CREATE SEQUENCE "snippet_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1823 -- TOC Entry ID 3 (OID 466669)
1825 -- Name: snippet_pk_seq Type: SEQUENCE SET Owner:
1828 SELECT setval ('"snippet_pk_seq"', 1, 'f');
1831 -- Selected TOC Entries:
1833 DROP SEQUENCE "snippet_version_pk_seq";
1835 -- TOC Entry ID 2 (OID 466878)
1837 -- Name: snippet_version_pk_seq Type: SEQUENCE Owner: sourceforge
1840 CREATE SEQUENCE "snippet_version_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1843 -- TOC Entry ID 3 (OID 466878)
1845 -- Name: snippet_version_pk_seq Type: SEQUENCE SET Owner:
1848 SELECT setval ('"snippet_version_pk_seq"', 1, 'f');
1851 -- Selected TOC Entries:
1853 DROP SEQUENCE "supported_languages_pk_seq";
1855 -- TOC Entry ID 2 (OID 466993)
1857 -- Name: supported_languages_pk_seq Type: SEQUENCE Owner: sourceforge
1860 CREATE SEQUENCE "supported_languages_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1863 -- TOC Entry ID 3 (OID 466993)
1865 -- Name: supported_languages_pk_seq Type: SEQUENCE SET Owner:
1868 SELECT setval ('"supported_languages_pk_seq"', 23, 't');
1871 -- Selected TOC Entries:
1873 DROP SEQUENCE "survey_questions_pk_seq";
1875 -- TOC Entry ID 2 (OID 467095)
1877 -- Name: survey_questions_pk_seq Type: SEQUENCE Owner: sourceforge
1880 CREATE SEQUENCE "survey_questions_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1883 -- TOC Entry ID 3 (OID 467095)
1885 -- Name: survey_questions_pk_seq Type: SEQUENCE SET Owner:
1888 SELECT setval ('"survey_questions_pk_seq"', 1, 'f');
1891 -- Selected TOC Entries:
1893 DROP SEQUENCE "survey_question_types_pk_seq";
1895 -- TOC Entry ID 2 (OID 467045)
1897 -- Name: survey_question_types_pk_seq Type: SEQUENCE Owner: sourceforge
1900 CREATE SEQUENCE "survey_question_types_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1903 -- TOC Entry ID 3 (OID 467045)
1905 -- Name: survey_question_types_pk_seq Type: SEQUENCE SET Owner:
1908 SELECT setval ('"survey_question_types_pk_seq"', 1, 'f');
1911 -- Selected TOC Entries:
1913 DROP SEQUENCE "surveys_pk_seq";
1915 -- TOC Entry ID 2 (OID 467221)
1917 -- Name: surveys_pk_seq Type: SEQUENCE Owner: sourceforge
1920 CREATE SEQUENCE "surveys_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1923 -- TOC Entry ID 3 (OID 467221)
1925 -- Name: surveys_pk_seq Type: SEQUENCE SET Owner:
1928 SELECT setval ('"surveys_pk_seq"', 1, 'f');
1931 -- Selected TOC Entries:
1933 DROP SEQUENCE "system_history_pk_seq";
1935 -- TOC Entry ID 2 (OID 467277)
1937 -- Name: system_history_pk_seq Type: SEQUENCE Owner: sourceforge
1940 CREATE SEQUENCE "system_history_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1943 -- TOC Entry ID 3 (OID 467277)
1945 -- Name: system_history_pk_seq Type: SEQUENCE SET Owner:
1948 SELECT setval ('"system_history_pk_seq"', 1, 'f');
1951 -- Selected TOC Entries:
1953 DROP SEQUENCE "system_machines_pk_seq";
1955 -- TOC Entry ID 2 (OID 467296)
1957 -- Name: system_machines_pk_seq Type: SEQUENCE Owner: sourceforge
1960 CREATE SEQUENCE "system_machines_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1963 -- TOC Entry ID 3 (OID 467296)
1965 -- Name: system_machines_pk_seq Type: SEQUENCE SET Owner:
1968 SELECT setval ('"system_machines_pk_seq"', 1, 'f');
1971 -- Selected TOC Entries:
1973 DROP SEQUENCE "system_news_pk_seq";
1975 -- TOC Entry ID 2 (OID 467315)
1977 -- Name: system_news_pk_seq Type: SEQUENCE Owner: sourceforge
1980 CREATE SEQUENCE "system_news_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
1983 -- TOC Entry ID 3 (OID 467315)
1985 -- Name: system_news_pk_seq Type: SEQUENCE SET Owner:
1988 SELECT setval ('"system_news_pk_seq"', 1, 'f');
1991 -- Selected TOC Entries:
1993 DROP SEQUENCE "system_services_pk_seq";
1995 -- TOC Entry ID 2 (OID 467334)
1997 -- Name: system_services_pk_seq Type: SEQUENCE Owner: sourceforge
2000 CREATE SEQUENCE "system_services_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
2003 -- TOC Entry ID 3 (OID 467334)
2005 -- Name: system_services_pk_seq Type: SEQUENCE SET Owner:
2008 SELECT setval ('"system_services_pk_seq"', 1, 'f');
2011 -- Selected TOC Entries:
2013 DROP SEQUENCE "system_status_pk_seq";
2015 -- TOC Entry ID 2 (OID 467353)
2017 -- Name: system_status_pk_seq Type: SEQUENCE Owner: sourceforge
2020 CREATE SEQUENCE "system_status_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
2023 -- TOC Entry ID 3 (OID 467353)
2025 -- Name: system_status_pk_seq Type: SEQUENCE SET Owner:
2028 SELECT setval ('"system_status_pk_seq"', 1, 'f');
2031 -- Selected TOC Entries:
2033 DROP SEQUENCE "themes_pk_seq";
2035 -- TOC Entry ID 2 (OID 467400)
2037 -- Name: themes_pk_seq Type: SEQUENCE Owner: sourceforge
2040 CREATE SEQUENCE "themes_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
2043 -- TOC Entry ID 3 (OID 467400)
2045 -- Name: themes_pk_seq Type: SEQUENCE SET Owner:
2048 SELECT setval ('"themes_pk_seq"', 1, 't');
2051 -- Selected TOC Entries:
2053 DROP SEQUENCE "trove_cat_pk_seq";
2055 -- TOC Entry ID 2 (OID 467477)
2057 -- Name: trove_cat_pk_seq Type: SEQUENCE Owner: sourceforge
2060 CREATE SEQUENCE "trove_cat_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
2063 -- TOC Entry ID 3 (OID 467477)
2065 -- Name: trove_cat_pk_seq Type: SEQUENCE SET Owner:
2068 SELECT setval ('"trove_cat_pk_seq"', 305, 't');
2071 -- Selected TOC Entries:
2073 DROP SEQUENCE "trove_group_link_pk_seq";
2075 -- TOC Entry ID 2 (OID 467541)
2077 -- Name: trove_group_link_pk_seq Type: SEQUENCE Owner: sourceforge
2080 CREATE SEQUENCE "trove_group_link_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
2083 -- TOC Entry ID 3 (OID 467541)
2085 -- Name: trove_group_link_pk_seq Type: SEQUENCE SET Owner:
2088 SELECT setval ('"trove_group_link_pk_seq"', 1, 'f');
2091 -- Selected TOC Entries:
2093 DROP SEQUENCE "trove_treesums_pk_seq";
2095 -- TOC Entry ID 2 (OID 467582)
2097 -- Name: trove_treesums_pk_seq Type: SEQUENCE Owner: sourceforge
2100 CREATE SEQUENCE "trove_treesums_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
2103 -- TOC Entry ID 3 (OID 467582)
2105 -- Name: trove_treesums_pk_seq Type: SEQUENCE SET Owner:
2108 SELECT setval ('"trove_treesums_pk_seq"', 1, 'f');
2111 -- Selected TOC Entries:
2113 DROP SEQUENCE "trove_treesum_trove_treesum_seq";
2115 -- TOC Entry ID 2 (OID 469781)
2117 -- Name: trove_treesum_trove_treesum_seq Type: SEQUENCE Owner: sourceforge
2120 CREATE SEQUENCE "trove_treesum_trove_treesum_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
2123 -- TOC Entry ID 3 (OID 469781)
2125 -- Name: trove_treesum_trove_treesum_seq Type: SEQUENCE SET Owner:
2128 SELECT setval ('"trove_treesum_trove_treesum_seq"', 1, 'f');
2131 -- Selected TOC Entries:
2133 DROP SEQUENCE "unix_uid_seq";
2135 -- TOC Entry ID 2 (OID 468033)
2137 -- Name: unix_uid_seq Type: SEQUENCE Owner: sourceforge
2140 CREATE SEQUENCE "unix_uid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
2143 -- TOC Entry ID 3 (OID 468033)
2145 -- Name: unix_uid_seq Type: SEQUENCE SET Owner:
2148 SELECT setval ('"unix_uid_seq"', 1, 'f');
2151 -- Selected TOC Entries:
2153 DROP SEQUENCE "user_bookmarks_pk_seq";
2155 -- TOC Entry ID 2 (OID 467601)
2157 -- Name: user_bookmarks_pk_seq Type: SEQUENCE Owner: sourceforge
2160 CREATE SEQUENCE "user_bookmarks_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
2163 -- TOC Entry ID 3 (OID 467601)
2165 -- Name: user_bookmarks_pk_seq Type: SEQUENCE SET Owner:
2168 SELECT setval ('"user_bookmarks_pk_seq"', 1, 'f');
2171 -- Selected TOC Entries:
2173 DROP SEQUENCE "user_diary_monitor_pk_seq";
2175 -- TOC Entry ID 2 (OID 467709)
2177 -- Name: user_diary_monitor_pk_seq Type: SEQUENCE Owner: sourceforge
2180 CREATE SEQUENCE "user_diary_monitor_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
2183 -- TOC Entry ID 3 (OID 467709)
2185 -- Name: user_diary_monitor_pk_seq Type: SEQUENCE SET Owner:
2188 SELECT setval ('"user_diary_monitor_pk_seq"', 1, 'f');
2191 -- Selected TOC Entries:
2193 DROP SEQUENCE "user_diary_pk_seq";
2195 -- TOC Entry ID 2 (OID 467653)
2197 -- Name: user_diary_pk_seq Type: SEQUENCE Owner: sourceforge
2200 CREATE SEQUENCE "user_diary_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
2203 -- TOC Entry ID 3 (OID 467653)
2205 -- Name: user_diary_pk_seq Type: SEQUENCE SET Owner:
2208 SELECT setval ('"user_diary_pk_seq"', 1, 'f');
2211 -- Selected TOC Entries:
2213 DROP SEQUENCE "user_group_pk_seq";
2215 -- TOC Entry ID 2 (OID 467746)
2217 -- Name: user_group_pk_seq Type: SEQUENCE Owner: sourceforge
2220 CREATE SEQUENCE "user_group_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
2223 -- TOC Entry ID 3 (OID 467746)
2225 -- Name: user_group_pk_seq Type: SEQUENCE SET Owner:
2228 SELECT setval ('"user_group_pk_seq"', 4, 't');
2231 -- Selected TOC Entries:
2233 DROP SEQUENCE "user_metric0_pk_seq";
2235 -- TOC Entry ID 2 (OID 467851)
2237 -- Name: user_metric0_pk_seq Type: SEQUENCE Owner: sourceforge
2240 CREATE SEQUENCE "user_metric0_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
2243 -- TOC Entry ID 3 (OID 467851)
2245 -- Name: user_metric0_pk_seq Type: SEQUENCE SET Owner:
2248 SELECT setval ('"user_metric0_pk_seq"', 1, 'f');
2251 -- Selected TOC Entries:
2253 DROP SEQUENCE "user_metric_pk_seq";
2255 -- TOC Entry ID 2 (OID 467804)
2257 -- Name: user_metric_pk_seq Type: SEQUENCE Owner: sourceforge
2260 CREATE SEQUENCE "user_metric_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
2263 -- TOC Entry ID 3 (OID 467804)
2265 -- Name: user_metric_pk_seq Type: SEQUENCE SET Owner:
2268 SELECT setval ('"user_metric_pk_seq"', 1, 'f');
2271 -- Selected TOC Entries:
2273 DROP SEQUENCE "users_pk_seq";
2275 -- TOC Entry ID 2 (OID 467946)
2277 -- Name: users_pk_seq Type: SEQUENCE Owner: sourceforge
2280 CREATE SEQUENCE "users_pk_seq" start 102 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ;
2283 -- TOC Entry ID 3 (OID 467946)
2285 -- Name: users_pk_seq Type: SEQUENCE SET Owner:
2288 SELECT setval ('"users_pk_seq"', 102, 'f');
2293 DROP VIEW "artifact_file_user_vw";
2295 -- TOC Entry ID 2 (OID 468860)
2297 -- Name: artifact_file_user_vw Type: VIEW Owner: sourceforge
2300 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);
2303 -- Selected TOC Entries:
2305 DROP VIEW "artifact_history_user_vw";
2307 -- TOC Entry ID 2 (OID 468782)
2309 -- Name: artifact_history_user_vw Type: VIEW Owner: sourceforge
2312 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);
2315 -- Selected TOC Entries:
2317 DROP VIEW "artifact_message_user_vw";
2319 -- TOC Entry ID 2 (OID 468933)
2321 -- Name: artifact_message_user_vw Type: VIEW Owner: sourceforge
2324 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);
2327 -- Selected TOC Entries:
2329 DROP VIEW "artifactperm_artgrouplist_vw";
2331 -- TOC Entry ID 2 (OID 468452)
2333 -- Name: artifactperm_artgrouplist_vw Type: VIEW Owner: sourceforge
2336 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);
2339 -- Selected TOC Entries:
2341 DROP VIEW "artifactperm_user_vw";
2343 -- TOC Entry ID 2 (OID 468436)
2345 -- Name: artifactperm_user_vw Type: VIEW Owner: sourceforge
2348 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);
2351 -- Selected TOC Entries:
2353 DROP VIEW "artifact_vw";
2355 -- TOC Entry ID 2 (OID 468705)
2357 -- Name: artifact_vw Type: VIEW Owner: sourceforge
2360 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));