2 -- Changes were renaming the "session" table to sf_session
3 -- renaming "date" columns to sf_date
4 -- commenting out the create trigger constraints
5 -- commenting out the select setval statements
8 -- Selected TOC Entries:
12 -- TOC Entry ID 2 (OID 18138427)
14 -- Name: bug_pk_seq Type: SEQUENCE
17 CREATE SEQUENCE bug_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
20 -- TOC Entry ID 182 (OID 18138445)
22 -- Name: bug Type: TABLE
26 bug_id integer DEFAULT '0' NOT NULL,
27 group_id integer DEFAULT '0' NOT NULL,
28 status_id integer DEFAULT '0' NOT NULL,
29 priority integer DEFAULT '0' NOT NULL,
30 category_id integer DEFAULT '0' NOT NULL,
31 submitted_by integer DEFAULT '0' NOT NULL,
32 assigned_to integer DEFAULT '0' NOT NULL,
33 sf_date integer DEFAULT '0' NOT NULL,
34 summary varchar2(255),
35 details varchar2(255),
37 bug_group_id integer DEFAULT '0' NOT NULL,
38 resolution_id integer DEFAULT '0' NOT NULL,
42 CREATE TRIGGER DEFAULT_BUG_ID BEFORE
44 ON bug REFERENCING OLD AS old NEW AS new
47 select bug_pk_seq.nextval into :new.bug_id from dual;
52 -- TOC Entry ID 4 (OID 18138495)
54 -- Name: bug_bug_dependencies_pk_seq Type: SEQUENCE
57 CREATE SEQUENCE bug_bug_dependencies_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
60 -- TOC Entry ID 183 (OID 18138513)
62 -- Name: bug_bug_dependencies Type: TABLE
65 CREATE TABLE bug_bug_dependencies (
66 bug_depend_id integer DEFAULT '0' NOT NULL,
67 bug_id integer DEFAULT '0' NOT NULL,
68 is_dependent_on_bug_id integer DEFAULT '0' NOT NULL,
69 PRIMARY KEY (bug_depend_id)
72 CREATE TRIGGER DEFAULT_BUG_DEPEND_ID BEFORE
74 ON bug_bug_dependencies REFERENCING OLD AS old NEW AS new
77 select bug_bug_dependencies_pk_seq.nextval into :new.bug_depend_id from dual;
82 -- TOC Entry ID 6 (OID 18138531)
84 -- Name: bug_canned_responses_pk_seq Type: SEQUENCE
87 CREATE SEQUENCE bug_canned_responses_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
90 -- TOC Entry ID 184 (OID 18138549)
92 -- Name: bug_canned_responses Type: TABLE
95 CREATE TABLE bug_canned_responses (
96 bug_canned_id integer DEFAULT '0' NOT NULL,
97 group_id integer DEFAULT '0' NOT NULL,
100 PRIMARY KEY (bug_canned_id)
103 CREATE TRIGGER DEFAULT_BUG_CANNED_ID BEFORE
105 ON bug_canned_responses REFERENCING OLD AS old NEW AS new
108 select bug_canned_responses_pk_seq.nextval into :new.bug_canned_id from dual;
113 -- TOC Entry ID 8 (OID 18138582)
115 -- Name: bug_category_pk_seq Type: SEQUENCE
118 CREATE SEQUENCE bug_category_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
121 -- TOC Entry ID 185 (OID 18138600)
123 -- Name: bug_category Type: TABLE
126 CREATE TABLE bug_category (
127 bug_category_id integer DEFAULT '0' NOT NULL,
128 group_id integer DEFAULT '0' NOT NULL,
129 category_name varchar2(255),
130 PRIMARY KEY (bug_category_id)
133 CREATE TRIGGER DEFAULT_BUG_CATEGORY_ID BEFORE
135 ON bug_category REFERENCING OLD AS old NEW AS new
138 select bug_category_pk_seq.nextval into :new.bug_category_id from dual;
143 -- TOC Entry ID 10 (OID 18138632)
145 -- Name: bug_filter_pk_seq Type: SEQUENCE
148 CREATE SEQUENCE bug_filter_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
151 -- TOC Entry ID 186 (OID 18138650)
153 -- Name: bug_filter Type: TABLE
156 CREATE TABLE bug_filter (
157 filter_id integer DEFAULT '0' NOT NULL,
158 user_id integer DEFAULT '0' NOT NULL,
159 group_id integer DEFAULT '0' NOT NULL,
160 sql_clause varchar2(255) DEFAULT '',
161 is_active integer DEFAULT '0' NOT NULL,
162 PRIMARY KEY (filter_id)
165 CREATE TRIGGER DEFAULT_BUG_FILTER_ID BEFORE
167 ON bug_filter REFERENCING OLD AS old NEW AS new
170 select bug_filter_pk_seq.nextval into :new.filter_id from dual;
175 -- TOC Entry ID 12 (OID 18138687)
177 -- Name: bug_group_pk_seq Type: SEQUENCE
180 CREATE SEQUENCE bug_group_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
183 -- TOC Entry ID 187 (OID 18138705)
185 -- Name: bug_group Type: TABLE
188 CREATE TABLE bug_group (
189 bug_group_id integer DEFAULT '0' NOT NULL,
190 group_id integer DEFAULT '0' NOT NULL,
191 group_name varchar2(255) DEFAULT '',
192 PRIMARY KEY (bug_group_id)
195 CREATE TRIGGER DEFAULT_BUG_GROUP_ID BEFORE
197 ON bug_group REFERENCING OLD AS old NEW AS new
200 select bug_group_pk_seq.nextval into :new.bug_group_id from dual;
205 -- TOC Entry ID 14 (OID 18138738)
207 -- Name: bug_history_pk_seq Type: SEQUENCE
210 CREATE SEQUENCE bug_history_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
213 -- TOC Entry ID 188 (OID 18138756)
215 -- Name: bug_history Type: TABLE
218 CREATE TABLE bug_history (
219 bug_history_id integer DEFAULT '0' NOT NULL,
220 bug_id integer DEFAULT '0' NOT NULL,
221 field_name varchar2(255) DEFAULT '',
222 old_value varchar2(255) DEFAULT '',
223 mod_by integer DEFAULT '0' NOT NULL,
225 PRIMARY KEY (bug_history_id)
228 --nextval('bug_history_pk_seq'::text)
229 CREATE TRIGGER DEFAULT_BUG_HISTORY_ID BEFORE
231 ON bug_history REFERENCING OLD AS old NEW AS new
234 select bug_history_pk_seq.nextval into :new.bug_history_id from dual;
239 -- TOC Entry ID 16 (OID 18138794)
241 -- Name: bug_resolution_pk_seq Type: SEQUENCE
244 CREATE SEQUENCE bug_resolution_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
247 -- TOC Entry ID 189 (OID 18138812)
249 -- Name: bug_resolution Type: TABLE
252 CREATE TABLE bug_resolution (
253 resolution_id integer DEFAULT '0' NOT NULL,
254 resolution_name varchar2(255) DEFAULT '',
255 PRIMARY KEY (resolution_id)
258 --nextval('bug_resolution_pk_seq'::text)
259 CREATE TRIGGER DEFAULT_BUG_RESOLUTION_ID BEFORE
261 ON bug_resolution REFERENCING OLD AS old NEW AS new
264 select bug_resolution_pk_seq.nextval into :new.resolution_id from dual;
269 -- TOC Entry ID 18 (OID 18138843)
271 -- Name: bug_status_pk_seq Type: SEQUENCE
274 CREATE SEQUENCE bug_status_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
277 -- TOC Entry ID 190 (OID 18138861)
279 -- Name: bug_status Type: TABLE
282 CREATE TABLE bug_status (
283 status_id integer DEFAULT '0' NOT NULL,
284 status_name varchar2(255),
285 PRIMARY KEY (status_id)
288 --nextval('bug_status_pk_seq'::text)
289 CREATE TRIGGER DEFAULT_BUG_STATUS_ID BEFORE
291 ON bug_status REFERENCING OLD AS old NEW AS new
294 select bug_status_pk_seq.nextval into :new.status_id from dual;
299 -- TOC Entry ID 20 (OID 18138891)
301 -- Name: bug_task_dependencies_pk_seq Type: SEQUENCE
304 CREATE SEQUENCE bug_task_dependencies_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
307 -- TOC Entry ID 191 (OID 18138909)
309 -- Name: bug_task_dependencies Type: TABLE
312 CREATE TABLE bug_task_dependencies (
313 bug_depend_id integer DEFAULT '0' NOT NULL,
314 bug_id integer DEFAULT '0' NOT NULL,
315 is_dependent_on_task_id integer DEFAULT '0' NOT NULL,
316 PRIMARY KEY (bug_depend_id)
319 --nextval('bug_task_dependencies_pk_seq'::text)
320 CREATE TRIGGER DEFAULT_BUG_TASK_ID BEFORE
322 ON bug_task_dependencies REFERENCING OLD AS old NEW AS new
325 select bug_task_dependencies_pk_seq.nextval into :new.bug_depend_id from dual;
330 -- TOC Entry ID 22 (OID 18138927)
332 -- Name: canned_responses_pk_seq Type: SEQUENCE
335 CREATE SEQUENCE canned_responses_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
338 -- TOC Entry ID 192 (OID 18138946)
340 -- Name: canned_responses Type: TABLE
343 CREATE TABLE canned_responses (
344 response_id integer DEFAULT '0' NOT NULL,
345 response_title character varying(25),
346 response_text varchar2(255),
347 PRIMARY KEY (response_id)
350 --nextval('canned_responses_pk_seq'::text)
351 CREATE TRIGGER DEFAULT_CANNED_RESPONSE_ID BEFORE
353 ON canned_responses REFERENCING OLD AS old NEW AS new
356 select canned_responses_pk_seq.nextval into :new.response_id from dual;
361 -- TOC Entry ID 24 (OID 18138977)
363 -- Name: db_images_pk_seq Type: SEQUENCE
366 CREATE SEQUENCE db_images_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
369 -- TOC Entry ID 193 (OID 18138995)
371 -- Name: db_images Type: TABLE
374 CREATE TABLE db_images (
375 id integer DEFAULT '0' NOT NULL,
376 group_id integer DEFAULT '0' NOT NULL,
377 description varchar2(255) DEFAULT '',
378 bin_data varchar2(255) DEFAULT '',
379 filename varchar2(255) DEFAULT '',
380 filesize integer DEFAULT '0' NOT NULL,
381 filetype varchar2(255) DEFAULT '',
382 width integer DEFAULT '0' NOT NULL,
383 height integer DEFAULT '0' NOT NULL,
387 --nextval('db_images_pk_seq'::text)
388 CREATE TRIGGER DEFAULT_DB_IMAGES_ID BEFORE
390 ON db_images REFERENCING OLD AS old NEW AS new
393 select db_images_pk_seq.nextval into :new.id from dual;
398 -- TOC Entry ID 26 (OID 18139040)
400 -- Name: doc_data_pk_seq Type: SEQUENCE
403 CREATE SEQUENCE doc_data_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
406 -- TOC Entry ID 194 (OID 18139058)
408 -- Name: doc_data Type: TABLE
411 CREATE TABLE doc_data (
412 docid integer DEFAULT '0' NOT NULL,
413 stateid integer DEFAULT '0' NOT NULL,
414 title character varying(255) DEFAULT '',
415 data varchar2(255) DEFAULT '',
416 updatedate integer DEFAULT '0' NOT NULL,
417 createdate integer DEFAULT '0' NOT NULL,
418 created_by integer DEFAULT '0' NOT NULL,
419 doc_group integer DEFAULT '0' NOT NULL,
420 description varchar2(255),
421 language_id integer DEFAULT '1' NOT NULL,
425 --nextval('doc_data_pk_seq'::text)
426 CREATE TRIGGER DEFAULT_DOC_DATA_ID BEFORE
428 ON doc_data REFERENCING OLD AS old NEW AS new
431 select doc_data_pk_seq.nextval into :new.docid from dual;
436 -- TOC Entry ID 28 (OID 18139104)
438 -- Name: doc_groups_pk_seq Type: SEQUENCE
441 CREATE SEQUENCE doc_groups_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
444 -- TOC Entry ID 195 (OID 18139122)
446 -- Name: doc_groups Type: TABLE
449 CREATE TABLE doc_groups (
450 doc_group integer DEFAULT '0' NOT NULL,
451 groupname character varying(255) DEFAULT '',
452 group_id integer DEFAULT '0' NOT NULL,
453 PRIMARY KEY (doc_group)
456 --nextval('doc_groups_pk_seq'::text)
457 CREATE TRIGGER DEFAULT_DOC_GROUP BEFORE
459 ON doc_groups REFERENCING OLD AS old NEW AS new
462 select doc_groups_pk_seq.nextval into :new.doc_group from dual;
467 -- TOC Entry ID 30 (OID 18139140)
469 -- Name: doc_states_pk_seq Type: SEQUENCE
472 CREATE SEQUENCE doc_states_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
475 -- TOC Entry ID 196 (OID 18139158)
477 -- Name: doc_states Type: TABLE
480 CREATE TABLE doc_states (
481 stateid integer DEFAULT '0' NOT NULL,
482 name character varying(255) DEFAULT '',
483 PRIMARY KEY (stateid)
486 --nextval('doc_states_pk_seq'::text)
487 CREATE TRIGGER DEFAULT_DOC_STATES_ID BEFORE
489 ON doc_states REFERENCING OLD AS old NEW AS new
492 select doc_states_pk_seq.nextval into :new.stateid from dual;
497 -- TOC Entry ID 32 (OID 18139174)
499 -- Name: filemodule_monitor_pk_seq Type: SEQUENCE
502 CREATE SEQUENCE filemodule_monitor_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
505 -- TOC Entry ID 197 (OID 18139192)
507 -- Name: filemodule_monitor Type: TABLE
510 CREATE TABLE filemodule_monitor (
511 id integer DEFAULT '0' NOT NULL,
512 filemodule_id integer DEFAULT '0' NOT NULL,
513 user_id integer DEFAULT '0' NOT NULL,
517 --nextval('filemodule_monitor_pk_seq'::text)
518 CREATE TRIGGER DEFAULT_FILEMODULE_MONITOR_ID BEFORE
520 ON filemodule_monitor REFERENCING OLD AS old NEW AS new
523 select filemodule_monitor_pk_seq.nextval into :new.id from dual;
528 -- TOC Entry ID 34 (OID 18139210)
530 -- Name: forum_pk_seq Type: SEQUENCE
533 CREATE SEQUENCE forum_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
536 -- TOC Entry ID 198 (OID 18139228)
538 -- Name: forum Type: TABLE
542 msg_id integer DEFAULT '0' NOT NULL,
543 group_forum_id integer DEFAULT '0' NOT NULL,
544 posted_by integer DEFAULT '0' NOT NULL,
545 subject varchar2(255) DEFAULT '',
546 body varchar2(255) DEFAULT '',
547 sf_date integer DEFAULT '0' NOT NULL,
548 is_followup_to integer DEFAULT '0' NOT NULL,
549 thread_id integer DEFAULT '0' NOT NULL,
550 has_followups integer DEFAULT '0',
551 most_recent_date integer DEFAULT '0' NOT NULL,
555 --nextval('forum_pk_seq'::text)
556 CREATE TRIGGER DEFAULT_FORUM_MSG_ID BEFORE
558 ON forum REFERENCING OLD AS old NEW AS new
561 select forum_pk_seq.nextval into :new.msg_id from dual;
567 -- TOC Entry ID 199 (OID 18139275)
569 -- Name: forum_agg_msg_count Type: TABLE
572 CREATE TABLE forum_agg_msg_count (
573 group_forum_id integer DEFAULT '0' NOT NULL,
574 count integer DEFAULT '0' NOT NULL,
575 PRIMARY KEY (group_forum_id)
579 -- TOC Entry ID 36 (OID 18139291)
581 -- Name: forum_group_list_pk_seq Type: SEQUENCE
584 CREATE SEQUENCE forum_group_list_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
587 -- TOC Entry ID 200 (OID 18139309)
589 -- Name: forum_group_list Type: TABLE
592 CREATE TABLE forum_group_list (
593 group_forum_id integer DEFAULT '0' NOT NULL,
594 group_id integer DEFAULT '0' NOT NULL,
595 forum_name varchar2(255) DEFAULT '',
596 is_public integer DEFAULT '0' NOT NULL,
597 description varchar2(255),
598 allow_anonymous integer DEFAULT '0' NOT NULL,
599 send_all_posts_to varchar2(255),
600 PRIMARY KEY (group_forum_id)
603 --nextval('forum_group_list_pk_seq'::text)
604 CREATE TRIGGER DEFAULT_FORUM_GROUP_ID BEFORE
606 ON forum_group_list REFERENCING OLD AS old NEW AS new
609 select forum_group_list_pk_seq.nextval into :new.group_forum_id from dual;
614 -- TOC Entry ID 38 (OID 18139348)
616 -- Name: forum_monitored_forums_pk_seq Type: SEQUENCE
619 CREATE SEQUENCE forum_monitored_forums_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
622 -- TOC Entry ID 201 (OID 18139366)
624 -- Name: forum_monitored_forums Type: TABLE
627 CREATE TABLE forum_monitored_forums (
628 monitor_id integer DEFAULT '0' NOT NULL,
629 forum_id integer DEFAULT '0' NOT NULL,
630 user_id integer DEFAULT '0' NOT NULL,
631 PRIMARY KEY (monitor_id)
634 --nextval('forum_monitored_forums_pk_seq'::text)
635 CREATE TRIGGER DEFAULT_FORUM_MON_FORUMS_ID BEFORE
637 ON forum_monitored_forums REFERENCING OLD AS old NEW AS new
640 select forum_monitored_forums_pk_seq.nextval into :new.monitor_id from dual;
645 -- TOC Entry ID 40 (OID 18139384)
647 -- Name: forum_saved_place_pk_seq Type: SEQUENCE
650 CREATE SEQUENCE forum_saved_place_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
653 -- TOC Entry ID 202 (OID 18139402)
655 -- Name: forum_saved_place Type: TABLE
658 CREATE TABLE forum_saved_place (
659 saved_place_id integer DEFAULT '0' NOT NULL,
660 user_id integer DEFAULT '0' NOT NULL,
661 forum_id integer DEFAULT '0' NOT NULL,
662 save_date integer DEFAULT '0' NOT NULL,
663 PRIMARY KEY (saved_place_id)
666 --nextval('forum_saved_place_pk_seq'::text)
667 CREATE TRIGGER DEFAULT_FORUM_SAVED_PLACES_ID BEFORE
669 ON forum_saved_place REFERENCING OLD AS old NEW AS new
672 select forum_saved_place_pk_seq.nextval into :new.saved_place_id from dual;
677 -- TOC Entry ID 203 (OID 18139454)
679 -- Name: foundry_data Type: TABLE
682 CREATE TABLE foundry_data (
683 foundry_id integer DEFAULT '0' NOT NULL,
684 freeform1_html varchar2(255),
685 freeform2_html varchar2(255),
686 sponsor1_html varchar2(255),
687 sponsor2_html varchar2(255),
688 guide_image_id integer DEFAULT '0' NOT NULL,
689 logo_image_id integer DEFAULT '0' NOT NULL,
690 trove_categories varchar2(255),
691 PRIMARY KEY (foundry_id)
695 -- TOC Entry ID 42 (OID 18139492)
697 -- Name: foundry_news_pk_seq Type: SEQUENCE
700 CREATE SEQUENCE foundry_news_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
703 -- TOC Entry ID 204 (OID 18139510)
705 -- Name: foundry_news Type: TABLE
708 CREATE TABLE foundry_news (
709 foundry_news_id integer DEFAULT '0' NOT NULL,
710 foundry_id integer DEFAULT '0' NOT NULL,
711 news_id integer DEFAULT '0' NOT NULL,
712 approve_date integer DEFAULT '0' NOT NULL,
713 is_approved integer DEFAULT '0' NOT NULL,
714 PRIMARY KEY (foundry_news_id)
717 --nextval('foundry_news_pk_seq'::text)
718 CREATE TRIGGER DEFAULT_FOUNDRY_NEWS_ID BEFORE
720 ON foundry_news REFERENCING OLD AS old NEW AS new
723 select foundry_news_pk_seq.nextval into :new.foundry_news_id from dual;
728 -- TOC Entry ID 44 (OID 18139532)
730 -- Name: foundry_preferred_projec_pk_seq Type: SEQUENCE
733 CREATE SEQUENCE foundry_preferred_proj_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
736 -- TOC Entry ID 205 (OID 18139550)
738 -- Name: foundry_preferred_projects Type: TABLE
741 CREATE TABLE foundry_preferred_projects (
742 foundry_project_id integer DEFAULT '0' NOT NULL,
743 foundry_id integer DEFAULT '0' NOT NULL,
744 group_id integer DEFAULT '0' NOT NULL,
745 rank integer DEFAULT '0' NOT NULL,
746 PRIMARY KEY (foundry_project_id)
749 --nextval('foundry_preferred_projec_pk_seq'::text)
750 CREATE TRIGGER DEFAULT_FOUNDRY_PREF_PROJS_ID BEFORE
752 ON foundry_preferred_projects REFERENCING OLD AS old NEW AS new
755 select foundry_preferred_proj_pk_seq.nextval into :new.foundry_project_id from dual;
760 -- TOC Entry ID 46 (OID 18139570)
762 -- Name: foundry_projects_pk_seq Type: SEQUENCE
765 CREATE SEQUENCE foundry_projects_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
768 -- TOC Entry ID 206 (OID 18139588)
770 -- Name: foundry_projects Type: TABLE
773 CREATE TABLE foundry_projects (
774 id integer DEFAULT '0' NOT NULL,
775 foundry_id integer DEFAULT '0' NOT NULL,
776 project_id integer DEFAULT '0' NOT NULL,
780 --nextval('foundry_projects_pk_seq'::text)
781 CREATE TRIGGER DEFAULT_FOUNDRY_PROJS_ID BEFORE
783 ON foundry_projects REFERENCING OLD AS old NEW AS new
786 select foundry_projects_pk_seq.nextval into :new.id from dual;
791 -- TOC Entry ID 207 (OID 18139606)
793 -- Name: frs_dlstats_agg Type: TABLE
796 CREATE TABLE frs_dlstats_agg (
797 file_id integer DEFAULT '0' NOT NULL,
798 day integer DEFAULT '0' NOT NULL,
799 downloads_http integer DEFAULT '0' NOT NULL,
800 downloads_ftp integer DEFAULT '0' NOT NULL
804 -- TOC Entry ID 208 (OID 18139623)
806 -- Name: frs_dlstats_file_agg Type: TABLE
809 CREATE TABLE frs_dlstats_file_agg (
810 file_id integer DEFAULT '0' NOT NULL,
811 day integer DEFAULT '0' NOT NULL,
812 downloads integer DEFAULT '0' NOT NULL
816 -- TOC Entry ID 209 (OID 18139638)
818 -- Name: frs_dlstats_filetotal_agg Type: TABLE
821 CREATE TABLE frs_dlstats_filetotal_agg (
822 file_id integer DEFAULT '0' NOT NULL,
823 downloads integer DEFAULT '0' NOT NULL,
824 PRIMARY KEY (file_id)
828 -- TOC Entry ID 210 (OID 18139654)
830 -- Name: frs_dlstats_filetotal_agg_old Type: TABLE
833 CREATE TABLE frs_dlstats_filetotal_agg_old (
834 file_id integer DEFAULT '0' NOT NULL,
835 downloads integer DEFAULT '0' NOT NULL
839 -- TOC Entry ID 211 (OID 18139667)
841 -- Name: frs_dlstats_group_agg Type: TABLE
844 CREATE TABLE frs_dlstats_group_agg (
845 group_id integer DEFAULT '0' NOT NULL,
846 day integer DEFAULT '0' NOT NULL,
847 downloads integer DEFAULT '0' NOT NULL
851 -- TOC Entry ID 212 (OID 18139682)
853 -- Name: frs_dlstats_grouptotal_agg Type: TABLE
856 CREATE TABLE frs_dlstats_grouptotal_agg (
857 group_id integer DEFAULT '0' NOT NULL,
858 downloads integer DEFAULT '0' NOT NULL
862 -- TOC Entry ID 48 (OID 18139695)
864 -- Name: frs_file_pk_seq Type: SEQUENCE
867 CREATE SEQUENCE frs_file_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
870 -- TOC Entry ID 213 (OID 18139714)
872 -- Name: frs_file Type: TABLE
875 CREATE TABLE frs_file (
876 file_id integer DEFAULT '0' NOT NULL,
877 filename varchar2(255),
878 release_id integer DEFAULT '0' NOT NULL,
879 type_id integer DEFAULT '0' NOT NULL,
880 processor_id integer DEFAULT '0' NOT NULL,
881 release_time integer DEFAULT '0' NOT NULL,
882 file_size integer DEFAULT '0' NOT NULL,
883 post_date integer DEFAULT '0' NOT NULL,
884 PRIMARY KEY (file_id)
887 --nextval('frs_file_pk_seq'::text)
888 CREATE TRIGGER DEFAULT_FRS_FILE_ID BEFORE
890 ON frs_file REFERENCING OLD AS old NEW AS new
893 select frs_file_pk_seq.nextval into :new.file_id from dual;
898 -- TOC Entry ID 50 (OID 18139756)
900 -- Name: frs_filetype_pk_seq Type: SEQUENCE
903 CREATE SEQUENCE frs_filetype_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
906 -- TOC Entry ID 214 (OID 18139774)
908 -- Name: frs_filetype Type: TABLE
911 CREATE TABLE frs_filetype (
912 type_id integer DEFAULT '0' NOT NULL,
914 PRIMARY KEY (type_id)
917 --nextval('frs_filetype_pk_seq'::text)
918 CREATE TRIGGER DEFAULT_FRS_FILETYPE_ID BEFORE
920 ON frs_filetype REFERENCING OLD AS old NEW AS new
923 select frs_filetype_pk_seq.nextval into :new.type_id from dual;
928 -- TOC Entry ID 52 (OID 18139804)
930 -- Name: frs_package_pk_seq Type: SEQUENCE
933 CREATE SEQUENCE frs_package_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
936 -- TOC Entry ID 215 (OID 18139822)
938 -- Name: frs_package Type: TABLE
941 CREATE TABLE frs_package (
942 package_id integer DEFAULT '0' NOT NULL,
943 group_id integer DEFAULT '0' NOT NULL,
945 status_id integer DEFAULT '0' NOT NULL,
946 PRIMARY KEY (package_id)
949 --nextval('frs_package_pk_seq'::text)
950 CREATE TRIGGER DEFAULT_FRS_PACKAGE_ID BEFORE
952 ON frs_package REFERENCING OLD AS old NEW AS new
955 select frs_package_pk_seq.nextval into :new.package_id from dual;
960 -- TOC Entry ID 54 (OID 18139856)
962 -- Name: frs_processor_pk_seq Type: SEQUENCE
965 CREATE SEQUENCE frs_processor_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
968 -- TOC Entry ID 216 (OID 18139874)
970 -- Name: frs_processor Type: TABLE
973 CREATE TABLE frs_processor (
974 processor_id integer DEFAULT '0' NOT NULL,
976 PRIMARY KEY (processor_id)
979 --nextval('frs_processor_pk_seq'::text)
980 CREATE TRIGGER DEFAULT_FRS_PROCESSOR_ID BEFORE
982 ON frs_processor REFERENCING OLD AS old NEW AS new
985 select frs_processor_pk_seq.nextval into :new.processor_id from dual;
990 -- TOC Entry ID 56 (OID 18139904)
992 -- Name: frs_release_pk_seq Type: SEQUENCE
995 CREATE SEQUENCE frs_release_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
998 -- TOC Entry ID 217 (OID 18139922)
1000 -- Name: frs_release Type: TABLE
1003 CREATE TABLE frs_release (
1004 release_id integer DEFAULT '0' NOT NULL,
1005 package_id integer DEFAULT '0' NOT NULL,
1007 notes varchar2(255),
1008 changes varchar2(255),
1009 status_id integer DEFAULT '0' NOT NULL,
1010 preformatted integer DEFAULT '0' NOT NULL,
1011 release_date integer DEFAULT '0' NOT NULL,
1012 released_by integer DEFAULT '0' NOT NULL,
1013 PRIMARY KEY (release_id)
1016 --nextval('frs_release_pk_seq'::text)
1017 CREATE TRIGGER DEFAULT_FRS_RELEASE_ID BEFORE
1019 ON frs_release REFERENCING OLD AS old NEW AS new
1022 select frs_release_pk_seq.nextval into :new.release_id from dual;
1027 -- TOC Entry ID 58 (OID 18139964)
1029 -- Name: frs_status_pk_seq Type: SEQUENCE
1032 CREATE SEQUENCE frs_status_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
1035 -- TOC Entry ID 218 (OID 18139982)
1037 -- Name: frs_status Type: TABLE
1040 CREATE TABLE frs_status (
1041 status_id integer DEFAULT '0' NULL,
1043 PRIMARY KEY (status_id)
1046 --nextval('frs_status_pk_seq'::text)
1047 CREATE TRIGGER DEFAULT_FRS_STATUS_ID BEFORE
1049 ON frs_status REFERENCING OLD AS old NEW AS new
1052 select frs_status_pk_seq.nextval into :new.status_id from dual;
1057 -- TOC Entry ID 60 (OID 18140012)
1059 -- Name: group_cvs_history_pk_seq Type: SEQUENCE
1062 CREATE SEQUENCE group_cvs_history_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
1065 -- TOC Entry ID 219 (OID 18140030)
1067 -- Name: group_cvs_history Type: TABLE
1070 CREATE TABLE group_cvs_history (
1071 id integer DEFAULT '0' NOT NULL,
1072 group_id integer DEFAULT '0' NOT NULL,
1073 user_name character varying(80) DEFAULT '',
1074 cvs_commits integer DEFAULT '0' NOT NULL,
1075 cvs_commits_wk integer DEFAULT '0' NOT NULL,
1076 cvs_adds integer DEFAULT '0' NOT NULL,
1077 cvs_adds_wk integer DEFAULT '0' NOT NULL,
1081 --nextval('group_cvs_history_pk_seq'::text)
1082 CREATE TRIGGER DEFAULT_GROUP_CVS_HISTORY_ID BEFORE
1084 ON group_cvs_history REFERENCING OLD AS old NEW AS new
1087 select group_cvs_history_pk_seq.nextval into :new.id from dual;
1092 -- TOC Entry ID 62 (OID 18140056)
1094 -- Name: group_history_pk_seq Type: SEQUENCE
1097 CREATE SEQUENCE group_history_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
1100 -- TOC Entry ID 220 (OID 18140074)
1102 -- Name: group_history Type: TABLE
1105 CREATE TABLE group_history (
1106 group_history_id integer DEFAULT '0' NOT NULL,
1107 group_id integer DEFAULT '0' NOT NULL,
1108 field_name varchar2(255) DEFAULT '',
1109 old_value varchar2(255) DEFAULT '',
1110 mod_by integer DEFAULT '0' NOT NULL,
1112 PRIMARY KEY (group_history_id)
1115 --nextval('group_history_pk_seq'::text)
1116 CREATE TRIGGER DEFAULT_GROUP_HISTORY_ID BEFORE
1118 ON group_history REFERENCING OLD AS old NEW AS new
1121 select group_history_pk_seq.nextval into :new.group_history_id from dual;
1126 -- TOC Entry ID 64 (OID 18140112)
1128 -- Name: group_type_pk_seq Type: SEQUENCE
1131 CREATE SEQUENCE group_type_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
1134 -- TOC Entry ID 221 (OID 18140130)
1136 -- Name: group_type Type: TABLE
1139 CREATE TABLE group_type (
1140 type_id integer DEFAULT '0' NOT NULL,
1142 PRIMARY KEY (type_id)
1145 --nextval('group_type_pk_seq'::text)
1146 CREATE TRIGGER DEFAULT_GROUP_TYPE_ID BEFORE
1148 ON group_type REFERENCING OLD AS old NEW AS new
1151 select group_type_pk_seq.nextval into :new.type_id from dual;
1156 -- TOC Entry ID 66 (OID 18140160)
1158 -- Name: groups_pk_seq Type: SEQUENCE
1161 CREATE SEQUENCE groups_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
1164 -- TOC Entry ID 222 (OID 18140178)
1166 -- Name: groups Type: TABLE
1169 CREATE TABLE groups (
1170 group_id integer DEFAULT '0' NOT NULL,
1171 group_name character varying(40),
1172 homepage character varying(128),
1173 is_public integer DEFAULT '0' NOT NULL,
1174 status character(1) DEFAULT 'A' NOT NULL,
1175 unix_group_name character varying(30) DEFAULT '',
1176 unix_box character varying(20) DEFAULT 'shell1' NOT NULL,
1177 http_domain character varying(80),
1178 short_description character varying(255),
1179 cvs_box character varying(20) DEFAULT 'cvs1' NOT NULL,
1180 license character varying(16),
1181 register_purpose varchar2(2000),
1182 license_other varchar2(255),
1183 register_time integer DEFAULT '0' NOT NULL,
1184 use_bugs integer DEFAULT '1' NOT NULL,
1185 rand_hash varchar2(255),
1186 use_mail integer DEFAULT '1' NOT NULL,
1187 use_survey integer DEFAULT '1' NOT NULL,
1188 use_patch integer DEFAULT '1' NOT NULL,
1189 use_forum integer DEFAULT '1' NOT NULL,
1190 use_pm integer DEFAULT '1' NOT NULL,
1191 use_cvs integer DEFAULT '1' NOT NULL,
1192 use_news integer DEFAULT '1' NOT NULL,
1193 use_support integer DEFAULT '1' NOT NULL,
1194 new_bug_address varchar2(255) DEFAULT '',
1195 new_patch_address varchar2(255) DEFAULT '',
1196 new_support_address varchar2(255) DEFAULT '',
1197 type integer DEFAULT '1' NOT NULL,
1198 use_docman integer DEFAULT '1' NOT NULL,
1199 send_all_bugs integer DEFAULT '0' NOT NULL,
1200 send_all_patches integer DEFAULT '0' NOT NULL,
1201 send_all_support integer DEFAULT '0' NOT NULL,
1202 new_task_address varchar2(255) DEFAULT '',
1203 send_all_tasks integer DEFAULT '0' NOT NULL,
1204 use_bug_depend_box integer DEFAULT '1' NOT NULL,
1205 use_pm_depend_box integer DEFAULT '1' NOT NULL,
1206 PRIMARY KEY (group_id)
1209 --nextval('groups_pk_seq'::text)
1210 CREATE TRIGGER DEFAULT_GROUP_ID BEFORE
1212 ON groups REFERENCING OLD AS old NEW AS new
1215 select groups_pk_seq.nextval into :new.group_id from dual;
1220 -- TOC Entry ID 223 (OID 18140269)
1222 -- Name: intel_agreement Type: TABLE
1225 CREATE TABLE intel_agreement (
1226 user_id integer DEFAULT '0' NOT NULL,
1227 message varchar2(255),
1228 is_approved integer DEFAULT '0' NOT NULL,
1229 PRIMARY KEY (user_id)
1233 -- TOC Entry ID 68 (OID 18140301)
1235 -- Name: mail_group_list_pk_seq Type: SEQUENCE
1238 CREATE SEQUENCE mail_group_list_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
1241 -- TOC Entry ID 224 (OID 18140319)
1243 -- Name: mail_group_list Type: TABLE
1246 CREATE TABLE mail_group_list (
1247 group_list_id integer DEFAULT '0' NOT NULL,
1248 group_id integer DEFAULT '0' NOT NULL,
1249 list_name varchar2(255),
1250 is_public integer DEFAULT '0' NOT NULL,
1251 password character varying(16),
1252 list_admin integer DEFAULT '0' NOT NULL,
1253 status integer DEFAULT '0' NOT NULL,
1254 description varchar2(255),
1255 PRIMARY KEY (group_list_id)
1258 --nextval('mail_group_list_pk_seq'::text)
1259 CREATE TRIGGER DEFAULT_MAIL_GROUP_LIST_ID BEFORE
1261 ON mail_group_list REFERENCING OLD AS old NEW AS new
1264 select mail_group_list_pk_seq.nextval into :new.group_list_id from dual;
1269 -- TOC Entry ID 70 (OID 18140359)
1271 -- Name: news_bytes_pk_seq Type: SEQUENCE
1274 CREATE SEQUENCE news_bytes_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
1277 -- TOC Entry ID 225 (OID 18140377)
1279 -- Name: news_bytes Type: TABLE
1282 CREATE TABLE news_bytes (
1283 id integer DEFAULT '0' NOT NULL,
1284 group_id integer DEFAULT '0' NOT NULL,
1285 submitted_by integer DEFAULT '0' NOT NULL,
1286 is_approved integer DEFAULT '0' NOT NULL,
1287 sf_date integer DEFAULT '0' NOT NULL,
1288 forum_id integer DEFAULT '0' NOT NULL,
1289 summary varchar2(255),
1290 details varchar2(255),
1294 --nextval('news_bytes_pk_seq'::text)
1295 CREATE TRIGGER DEFAULT_NEWS_BYTES_ID BEFORE
1297 ON news_bytes REFERENCING OLD AS old NEW AS new
1300 select news_bytes_pk_seq.nextval into :new.id from dual;
1305 -- TOC Entry ID 72 (OID 18140419)
1307 -- Name: patch_pk_seq Type: SEQUENCE
1310 CREATE SEQUENCE patch_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
1313 -- TOC Entry ID 226 (OID 18140437)
1315 -- Name: patch Type: TABLE
1318 CREATE TABLE patch (
1319 patch_id integer DEFAULT '0' NOT NULL,
1320 group_id integer DEFAULT '0' NOT NULL,
1321 patch_status_id integer DEFAULT '0' NOT NULL,
1322 patch_category_id integer DEFAULT '0' NOT NULL,
1323 submitted_by integer DEFAULT '0' NOT NULL,
1324 assigned_to integer DEFAULT '0' NOT NULL,
1325 open_date integer DEFAULT '0' NOT NULL,
1326 summary varchar2(255),
1328 close_date integer DEFAULT '0' NOT NULL,
1329 PRIMARY KEY (patch_id)
1332 --nextval('patch_pk_seq'::text)
1333 CREATE TRIGGER DEFAULT_PATCH_ID BEFORE
1335 ON patch REFERENCING OLD AS old NEW AS new
1338 select patch_pk_seq.nextval into :new.patch_id from dual;
1343 -- TOC Entry ID 74 (OID 18140483)
1345 -- Name: patch_category_pk_seq Type: SEQUENCE
1348 CREATE SEQUENCE patch_category_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
1351 -- TOC Entry ID 227 (OID 18140501)
1353 -- Name: patch_category Type: TABLE
1356 CREATE TABLE patch_category (
1357 patch_category_id integer DEFAULT '0' NOT NULL,
1358 group_id integer DEFAULT '0' NOT NULL,
1359 category_name varchar2(255) DEFAULT '',
1360 PRIMARY KEY (patch_category_id)
1363 --nextval('patch_category_pk_seq'::text)
1364 CREATE TRIGGER DEFAULT_PATCH_CATEGORY_ID BEFORE
1366 ON patch_category REFERENCING OLD AS old NEW AS new
1369 select patch_category_pk_seq.nextval into :new.patch_category_id from dual;
1374 -- TOC Entry ID 76 (OID 18140534)
1376 -- Name: patch_history_pk_seq Type: SEQUENCE
1379 CREATE SEQUENCE patch_history_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
1382 -- TOC Entry ID 228 (OID 18140552)
1384 -- Name: patch_history Type: TABLE
1387 CREATE TABLE patch_history (
1388 patch_history_id integer DEFAULT '0' NOT NULL,
1389 patch_id integer DEFAULT '0' NOT NULL,
1390 field_name varchar2(255) DEFAULT '',
1391 old_value varchar2(255) DEFAULT '',
1392 mod_by integer DEFAULT '0' NOT NULL,
1394 PRIMARY KEY (patch_history_id)
1397 --nextval('patch_history_pk_seq'::text)
1398 CREATE TRIGGER DEFAULT_PATCH_HISTORY BEFORE
1400 ON patch_history REFERENCING OLD AS old NEW AS new
1403 select patch_history_pk_seq.nextval into :new.patch_history_id from dual;
1408 -- TOC Entry ID 78 (OID 18140590)
1410 -- Name: patch_status_pk_seq Type: SEQUENCE
1413 CREATE SEQUENCE patch_status_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
1416 -- TOC Entry ID 229 (OID 18140608)
1418 -- Name: patch_status Type: TABLE
1421 CREATE TABLE patch_status (
1422 patch_status_id integer DEFAULT '0' NOT NULL,
1423 status_name varchar2(255),
1424 PRIMARY KEY (patch_status_id)
1427 --nextval('patch_status_pk_seq'::text)
1428 CREATE TRIGGER DEFAULT_PATCH_STATUS BEFORE
1430 ON patch_status REFERENCING OLD AS old NEW AS new
1433 select patch_status_pk_seq.nextval into :new.patch_status_id from dual;
1438 -- TOC Entry ID 80 (OID 18140638)
1440 -- Name: people_job_pk_seq Type: SEQUENCE
1443 CREATE SEQUENCE people_job_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
1446 -- TOC Entry ID 230 (OID 18140656)
1448 -- Name: people_job Type: TABLE
1451 CREATE TABLE people_job (
1452 job_id integer DEFAULT '0' NOT NULL,
1453 group_id integer DEFAULT '0' NOT NULL,
1454 created_by integer DEFAULT '0' NOT NULL,
1455 title varchar2(255),
1456 description varchar2(255),
1457 sf_date integer DEFAULT '0' NOT NULL,
1458 status_id integer DEFAULT '0' NOT NULL,
1459 category_id integer DEFAULT '0' NOT NULL,
1460 PRIMARY KEY (job_id)
1463 --nextval('people_job_pk_seq'::text)
1464 CREATE TRIGGER DEFAULT_people_job BEFORE
1466 ON people_job REFERENCING OLD AS old NEW AS new
1469 select people_job_pk_seq.nextval into :new.job_id from dual;
1475 -- TOC Entry ID 82 (OID 18140697)
1477 -- Name: people_job_category_pk_seq Type: SEQUENCE
1480 CREATE SEQUENCE people_job_category_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
1483 -- TOC Entry ID 231 (OID 18140715)
1485 -- Name: people_job_category Type: TABLE
1488 CREATE TABLE people_job_category (
1489 category_id integer DEFAULT '0' NOT NULL,
1491 private_flag integer DEFAULT '0' NOT NULL,
1492 PRIMARY KEY (category_id)
1495 --nextval('people_job_category_pk_seq'::text)
1496 CREATE TRIGGER DEFAULT_people_job_category BEFORE
1498 ON people_job_category REFERENCING OLD AS old NEW AS new
1501 select people_job_category_pk_seq.nextval into :new.category_id from dual;
1506 -- TOC Entry ID 84 (OID 18140747)
1508 -- Name: people_job_inventory_pk_seq Type: SEQUENCE
1511 CREATE SEQUENCE people_job_inventory_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
1514 -- TOC Entry ID 232 (OID 18140765)
1516 -- Name: people_job_inventory Type: TABLE
1519 CREATE TABLE people_job_inventory (
1520 job_inventory_id integer DEFAULT '0' NOT NULL,
1521 job_id integer DEFAULT '0' NOT NULL,
1522 skill_id integer DEFAULT '0' NOT NULL,
1523 skill_level_id integer DEFAULT '0' NOT NULL,
1524 skill_year_id integer DEFAULT '0' NOT NULL,
1525 PRIMARY KEY (job_inventory_id)
1528 --nextval('people_job_inventory_pk_seq'::text)
1529 CREATE TRIGGER DEFAULT_people_job_inventory BEFORE
1531 ON people_job_inventory REFERENCING OLD AS old NEW AS new
1534 select people_job_inventory_pk_seq.nextval into :new.job_inventory_id from dual;
1539 -- TOC Entry ID 86 (OID 18140787)
1541 -- Name: people_job_status_pk_seq Type: SEQUENCE
1544 CREATE SEQUENCE people_job_status_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
1547 -- TOC Entry ID 233 (OID 18140805)
1549 -- Name: people_job_status Type: TABLE
1552 CREATE TABLE people_job_status (
1553 status_id integer DEFAULT '0' NOT NULL,
1555 PRIMARY KEY (status_id)
1558 --nextval('people_job_status_pk_seq'::text)
1559 CREATE TRIGGER DEFAULT_people_job_status BEFORE
1561 ON people_job_status REFERENCING OLD AS old NEW AS new
1564 select people_job_status_pk_seq.nextval into :new.status_id from dual;
1569 -- TOC Entry ID 88 (OID 18140835)
1571 -- Name: people_skill_pk_seq Type: SEQUENCE
1574 CREATE SEQUENCE people_skill_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
1577 -- TOC Entry ID 234 (OID 18140853)
1579 -- Name: people_skill Type: TABLE
1582 CREATE TABLE people_skill (
1583 skill_id integer DEFAULT '0' NOT NULL,
1585 PRIMARY KEY (skill_id)
1588 --nextval('people_skill_pk_seq'::text)
1589 CREATE TRIGGER DEFAULT_people_skill BEFORE
1591 ON people_skill REFERENCING OLD AS old NEW AS new
1594 select people_skill_pk_seq.nextval into :new.skill_id from dual;
1599 -- TOC Entry ID 90 (OID 18140884)
1601 -- Name: people_skill_inventory_pk_seq Type: SEQUENCE
1604 CREATE SEQUENCE people_skill_inventory_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
1607 -- TOC Entry ID 235 (OID 18140902)
1609 -- Name: people_skill_inventory Type: TABLE
1612 CREATE TABLE people_skill_inventory (
1613 skill_inventory_id integer DEFAULT '0' NOT NULL,
1614 user_id integer DEFAULT '0' NOT NULL,
1615 skill_id integer DEFAULT '0' NOT NULL,
1616 skill_level_id integer DEFAULT '0' NOT NULL,
1617 skill_year_id integer DEFAULT '0' NOT NULL,
1618 PRIMARY KEY (skill_inventory_id)
1621 --nextval('people_skill_inventory_pk_seq'::text)
1622 CREATE TRIGGER DEFAULT_people_inventory BEFORE
1624 ON people_skill_inventory REFERENCING OLD AS old NEW AS new
1627 select people_skill_inventory_pk_seq.nextval into :new.skill_inventory_id from dual;
1632 -- TOC Entry ID 92 (OID 18140924)
1634 -- Name: people_skill_level_pk_seq Type: SEQUENCE
1637 CREATE SEQUENCE people_skill_level_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
1640 -- TOC Entry ID 236 (OID 18140942)
1642 -- Name: people_skill_level Type: TABLE
1645 CREATE TABLE people_skill_level (
1646 skill_level_id integer DEFAULT '0' NOT NULL,
1648 PRIMARY KEY (skill_level_id)
1651 --nextval('people_skill_level_pk_seq'::text)
1652 CREATE TRIGGER DEFAULT_people_skill_level BEFORE
1654 ON people_skill_level REFERENCING OLD AS old NEW AS new
1657 select people_skill_level_pk_seq.nextval into :new.skill_level_id from dual;
1662 -- TOC Entry ID 94 (OID 18140972)
1664 -- Name: people_skill_year_pk_seq Type: SEQUENCE
1667 CREATE SEQUENCE people_skill_year_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
1670 -- TOC Entry ID 237 (OID 18140990)
1672 -- Name: people_skill_year Type: TABLE
1675 CREATE TABLE people_skill_year (
1676 skill_year_id integer DEFAULT '0' NOT NULL,
1678 PRIMARY KEY (skill_year_id)
1681 --nextval('people_skill_year_pk_seq'::text)
1682 CREATE TRIGGER DEFAULT_people_skill_year BEFORE
1684 ON people_skill_year REFERENCING OLD AS old NEW AS new
1687 select people_skill_year_pk_seq.nextval into :new.skill_year_id from dual;
1693 -- TOC Entry ID 96 (OID 18141020)
1695 -- Name: project_assigned_to_pk_seq Type: SEQUENCE
1698 CREATE SEQUENCE project_assigned_to_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
1701 -- TOC Entry ID 238 (OID 18141038)
1703 -- Name: project_assigned_to Type: TABLE
1706 CREATE TABLE project_assigned_to (
1707 project_assigned_id integer DEFAULT '0' NOT NULL,
1708 project_task_id integer DEFAULT '0' NOT NULL,
1709 assigned_to_id integer DEFAULT '0' NOT NULL,
1710 PRIMARY KEY (project_assigned_id)
1713 --nextval('project_assigned_to_pk_seq'::text)
1714 CREATE TRIGGER DEFAULT_project_assigned_to BEFORE
1716 ON project_assigned_to REFERENCING OLD AS old NEW AS new
1719 select project_assigned_to_pk_seq.nextval into :new.project_assigned_id from dual;
1724 -- TOC Entry ID 239 (OID 18141056)
1726 -- Name: project_counts_tmp Type: TABLE
1729 CREATE TABLE project_counts_tmp (
1732 count double precision
1736 -- TOC Entry ID 240 (OID 18141083)
1738 -- Name: project_counts_weekly_tmp Type: TABLE
1741 CREATE TABLE project_counts_weekly_tmp (
1744 count double precision
1748 -- TOC Entry ID 98 (OID 18141110)
1750 -- Name: project_dependencies_pk_seq Type: SEQUENCE
1753 CREATE SEQUENCE project_dependencies_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
1756 -- TOC Entry ID 241 (OID 18141128)
1758 -- Name: project_dependencies Type: TABLE
1761 CREATE TABLE project_dependencies (
1762 project_depend_id integer DEFAULT '0' NOT NULL,
1763 project_task_id integer DEFAULT '0' NOT NULL,
1764 is_dependent_on_task_id integer DEFAULT '0' NOT NULL,
1765 PRIMARY KEY (project_depend_id)
1768 --nextval('project_dependencies_pk_seq'::text)
1769 CREATE TRIGGER DEFAULT_project_dependencies BEFORE
1771 ON project_dependencies REFERENCING OLD AS old NEW AS new
1774 select project_dependencies_pk_seq.nextval into :new.project_depend_id from dual;
1779 -- TOC Entry ID 100 (OID 18141146)
1781 -- Name: project_group_list_pk_seq Type: SEQUENCE
1784 CREATE SEQUENCE project_group_list_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
1787 -- TOC Entry ID 242 (OID 18141164)
1789 -- Name: project_group_list Type: TABLE
1792 CREATE TABLE project_group_list (
1793 group_project_id integer DEFAULT '0' NOT NULL,
1794 group_id integer DEFAULT '0' NOT NULL,
1795 project_name varchar2(255) DEFAULT '',
1796 is_public integer DEFAULT '0' NOT NULL,
1797 description varchar2(255),
1798 PRIMARY KEY (group_project_id)
1801 --nextval('project_group_list_pk_seq'::text)
1802 CREATE TRIGGER DEFAULT_project_group_list BEFORE
1804 ON project_group_list REFERENCING OLD AS old NEW AS new
1807 select project_group_list_pk_seq.nextval into :new.group_project_id from dual;
1812 -- TOC Entry ID 102 (OID 18141200)
1814 -- Name: project_history_pk_seq Type: SEQUENCE
1817 CREATE SEQUENCE project_history_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
1820 -- TOC Entry ID 243 (OID 18141218)
1822 -- Name: project_history Type: TABLE
1825 CREATE TABLE project_history (
1826 project_history_id integer DEFAULT '0' NOT NULL,
1827 project_task_id integer DEFAULT '0' NOT NULL,
1828 field_name varchar2(255) DEFAULT '',
1829 old_value varchar2(255) DEFAULT '',
1830 mod_by integer DEFAULT '0' NOT NULL,
1831 sf_date integer DEFAULT '0' NOT NULL,
1832 PRIMARY KEY (project_history_id)
1835 --nextval('project_history_pk_seq'::text)
1836 CREATE TRIGGER DEFAULT_project_history BEFORE
1838 ON project_history REFERENCING OLD AS old NEW AS new
1841 select project_history_pk_seq.nextval into :new.project_history_id from dual;
1846 -- TOC Entry ID 104 (OID 18141257)
1848 -- Name: project_metric_pk_seq Type: SEQUENCE
1851 CREATE SEQUENCE project_metric_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
1854 -- TOC Entry ID 244 (OID 18141275)
1856 -- Name: project_metric Type: TABLE
1859 CREATE TABLE project_metric (
1860 ranking integer DEFAULT '0' NOT NULL,
1861 percentile double precision,
1862 group_id integer DEFAULT '0' NOT NULL,
1863 PRIMARY KEY (ranking)
1866 --nextval('project_metric_pk_seq'::text)
1867 CREATE TRIGGER DEFAULT_project_metric BEFORE
1869 ON project_metric REFERENCING OLD AS old NEW AS new
1872 select project_metric_pk_seq.nextval into :new.ranking from dual;
1877 -- TOC Entry ID 106 (OID 18141292)
1879 -- Name: project_metric_tmp1_pk_seq Type: SEQUENCE
1882 CREATE SEQUENCE project_metric_tmp1_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
1885 -- TOC Entry ID 245 (OID 18141310)
1887 -- Name: project_metric_tmp1 Type: TABLE
1890 CREATE TABLE project_metric_tmp1 (
1891 ranking integer DEFAULT '0' NOT NULL,
1892 group_id integer DEFAULT '0' NOT NULL,
1893 value double precision,
1894 PRIMARY KEY (ranking)
1897 --nextval('project_metric_tmp1_pk_seq'::text)
1898 CREATE TRIGGER DEFAULT_project_metric_tmp1 BEFORE
1900 ON project_metric_tmp1 REFERENCING OLD AS old NEW AS new
1903 select project_metric_tmp1_pk_seq.nextval into :new.ranking from dual;
1908 -- TOC Entry ID 108 (OID 18141327)
1910 -- Name: project_metric_weekly_tm_pk_seq Type: SEQUENCE
1913 CREATE SEQUENCE project_metric_week_tm_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
1916 -- TOC Entry ID 246 (OID 18141346)
1918 -- Name: project_metric_weekly_tmp1 Type: TABLE
1921 CREATE TABLE project_metric_weekly_tmp1 (
1922 ranking integer DEFAULT '0' NOT NULL,
1923 group_id integer DEFAULT '0' NOT NULL,
1924 value double precision,
1925 PRIMARY KEY (ranking)
1928 --nextval('project_metric_week_tm_pk_seq'::text)
1929 CREATE TRIGGER DEFAULT_proj_metric_week_tmp1 BEFORE
1931 ON project_metric_weekly_tmp1 REFERENCING OLD AS old NEW AS new
1934 select project_metric_week_tm_pk_seq.nextval into :new.ranking from dual;
1939 -- TOC Entry ID 110 (OID 18141363)
1941 -- Name: project_status_pk_seq Type: SEQUENCE
1944 CREATE SEQUENCE project_status_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
1947 -- TOC Entry ID 247 (OID 18141381)
1949 -- Name: project_status Type: TABLE
1952 CREATE TABLE project_status (
1953 status_id integer DEFAULT '0' NOT NULL,
1954 status_name varchar2(255) DEFAULT '',
1955 PRIMARY KEY (status_id)
1958 --nextval('project_status_pk_seq'::text)
1959 CREATE TRIGGER DEFAULT_project_status BEFORE
1961 ON project_status REFERENCING OLD AS old NEW AS new
1964 select project_status_pk_seq.nextval into :new.status_id from dual;
1969 -- TOC Entry ID 112 (OID 18141412)
1971 -- Name: project_task_pk_seq Type: SEQUENCE
1974 CREATE SEQUENCE project_task_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
1977 -- TOC Entry ID 248 (OID 18141430)
1979 -- Name: project_task Type: TABLE
1982 CREATE TABLE project_task (
1983 project_task_id integer DEFAULT '0' NOT NULL,
1984 group_project_id integer DEFAULT '0' NOT NULL,
1985 summary varchar2(255) DEFAULT '',
1986 details varchar2(255) DEFAULT '',
1987 percent_complete integer DEFAULT '0' NOT NULL,
1988 priority integer DEFAULT '0' NOT NULL,
1989 hours double precision DEFAULT '0.00' NOT NULL,
1990 start_date integer DEFAULT '0' NOT NULL,
1991 end_date integer DEFAULT '0' NOT NULL,
1992 created_by integer DEFAULT '0' NOT NULL,
1993 status_id integer DEFAULT '0' NOT NULL,
1994 PRIMARY KEY (project_task_id)
1997 --nextval('project_task_pk_seq'::text)
1998 CREATE TRIGGER DEFAULT_project_task BEFORE
2000 ON project_task REFERENCING OLD AS old NEW AS new
2003 select project_task_pk_seq.nextval into :new.project_task_id from dual;
2008 -- TOC Entry ID 114 (OID 18141479)
2010 -- Name: project_weekly_metric_pk_seq Type: SEQUENCE
2013 CREATE SEQUENCE project_weekly_metric_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
2016 -- TOC Entry ID 249 (OID 18141497)
2018 -- Name: project_weekly_metric Type: TABLE
2021 CREATE TABLE project_weekly_metric (
2022 ranking integer DEFAULT '0' NOT NULL,
2023 percentile double precision,
2024 group_id integer DEFAULT '0' NOT NULL,
2025 PRIMARY KEY (ranking)
2028 --nextval('project_weekly_metric_pk_seq'::text)
2029 CREATE TRIGGER DEFAULT_project_weekly_metric BEFORE
2031 ON project_weekly_metric REFERENCING OLD AS old NEW AS new
2034 select project_weekly_metric_pk_seq.nextval into :new.ranking from dual;
2039 -- TOC Entry ID 250 (OID 18141514)
2041 -- Name: sf_session Type: TABLE
2044 CREATE TABLE sf_session (
2045 user_id integer DEFAULT '0' NOT NULL,
2046 session_hash character(32) DEFAULT '',
2047 ip_addr character(15) DEFAULT '',
2048 time integer DEFAULT '0' NOT NULL,
2049 PRIMARY KEY (session_hash)
2053 -- TOC Entry ID 116 (OID 18141534)
2055 -- Name: snippet_pk_seq Type: SEQUENCE
2058 CREATE SEQUENCE snippet_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
2061 -- TOC Entry ID 251 (OID 18141552)
2063 -- Name: snippet Type: TABLE
2066 CREATE TABLE snippet (
2067 snippet_id integer DEFAULT '0' NOT NULL,
2068 created_by integer DEFAULT '0' NOT NULL,
2070 description varchar2(255),
2071 type integer DEFAULT '0' NOT NULL,
2072 language integer DEFAULT '0' NOT NULL,
2073 license varchar2(255) DEFAULT '',
2074 category integer DEFAULT '0' NOT NULL,
2075 PRIMARY KEY (snippet_id)
2078 --nextval('snippet_pk_seq'::text)
2079 CREATE TRIGGER DEFAULT_snippet BEFORE
2081 ON snippet REFERENCING OLD AS old NEW AS new
2084 select snippet_pk_seq.nextval into :new.snippet_id from dual;
2089 -- TOC Entry ID 118 (OID 18141593)
2091 -- Name: snippet_package_pk_seq Type: SEQUENCE
2094 CREATE SEQUENCE snippet_package_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
2097 -- TOC Entry ID 252 (OID 18141611)
2099 -- Name: snippet_package Type: TABLE
2102 CREATE TABLE snippet_package (
2103 snippet_package_id integer DEFAULT '0' NOT NULL,
2104 created_by integer DEFAULT '0' NOT NULL,
2106 description varchar2(255),
2107 category integer DEFAULT '0' NOT NULL,
2108 language integer DEFAULT '0' NOT NULL,
2109 PRIMARY KEY (snippet_package_id)
2112 --nextval('snippet_package_pk_seq'::text)
2113 CREATE TRIGGER DEFAULT_snippet_package BEFORE
2115 ON snippet_package REFERENCING OLD AS old NEW AS new
2118 select snippet_package_pk_seq.nextval into :new.snippet_package_id from dual;
2123 -- TOC Entry ID 120 (OID 18141648)
2125 -- Name: snippet_package_item_pk_seq Type: SEQUENCE
2128 CREATE SEQUENCE snippet_package_item_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
2131 -- TOC Entry ID 253 (OID 18141666)
2133 -- Name: snippet_package_item Type: TABLE
2136 CREATE TABLE snippet_package_item (
2137 snippet_package_item_id integer DEFAULT '0' NOT NULL,
2138 snippet_package_version_id integer DEFAULT '0' NOT NULL,
2139 snippet_version_id integer DEFAULT '0' NOT NULL,
2140 PRIMARY KEY (snippet_package_item_id)
2143 --nextval('snippet_package_item_pk_seq'::text)
2144 CREATE TRIGGER DEFAULT_snippet_package_item BEFORE
2146 ON snippet_package_item REFERENCING OLD AS old NEW AS new
2149 select snippet_package_item_pk_seq.nextval into :new.snippet_package_item_id from dual;
2155 -- TOC Entry ID 122 (OID 18141684)
2157 -- Name: snippet_package_version_pk_seq Type: SEQUENCE
2160 CREATE SEQUENCE snippet_package_version_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
2163 -- TOC Entry ID 254 (OID 18141702)
2165 -- Name: snippet_package_version Type: TABLE
2168 CREATE TABLE snippet_package_version (
2169 snippet_package_version_id integer DEFAULT '0' NOT NULL,
2170 snippet_package_id integer DEFAULT '0' NOT NULL,
2171 changes varchar2(255),
2172 version varchar2(255),
2173 submitted_by integer DEFAULT '0' NOT NULL,
2174 sf_date integer DEFAULT '0' NOT NULL,
2175 PRIMARY KEY (snippet_package_version_id)
2178 --nextval('snippet_package_version_pk_seq'::text)
2179 CREATE TRIGGER DEFAULT_snippet_package_ver BEFORE
2181 ON snippet_package_version REFERENCING OLD AS old NEW AS new
2184 select snippet_package_version_pk_seq.nextval into :new.snippet_package_version_id from dual;
2190 -- TOC Entry ID 124 (OID 18141739)
2192 -- Name: snippet_version_pk_seq Type: SEQUENCE
2195 CREATE SEQUENCE snippet_version_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
2198 -- TOC Entry ID 255 (OID 18141757)
2200 -- Name: snippet_version Type: TABLE
2203 CREATE TABLE snippet_version (
2204 snippet_version_id integer DEFAULT '0' NOT NULL,
2205 snippet_id integer DEFAULT '0' NOT NULL,
2206 changes varchar2(255),
2207 version varchar2(255),
2208 submitted_by integer DEFAULT '0' NOT NULL,
2209 sf_date integer DEFAULT '0' NOT NULL,
2211 PRIMARY KEY (snippet_version_id)
2214 --nextval('snippet_version_pk_seq'::text)
2215 CREATE TRIGGER DEFAULT_snippet_version BEFORE
2217 ON snippet_version REFERENCING OLD AS old NEW AS new
2220 select snippet_version_pk_seq.nextval into :new.snippet_version_id from dual;
2225 -- TOC Entry ID 256 (OID 18141795)
2227 -- Name: stats_agg_logo_by_day Type: TABLE
2230 CREATE TABLE stats_agg_logo_by_day (
2236 -- TOC Entry ID 257 (OID 18141806)
2238 -- Name: stats_agg_logo_by_group Type: TABLE
2241 CREATE TABLE stats_agg_logo_by_group (
2248 -- TOC Entry ID 258 (OID 18141818)
2250 -- Name: stats_agg_pages_by_browser Type: TABLE
2253 CREATE TABLE stats_agg_pages_by_browser (
2254 browser character varying(8),
2259 -- TOC Entry ID 259 (OID 18141829)
2261 -- Name: stats_agg_pages_by_day Type: TABLE
2264 CREATE TABLE stats_agg_pages_by_day (
2265 day integer DEFAULT '0' NOT NULL,
2266 count integer DEFAULT '0' NOT NULL
2270 -- TOC Entry ID 260 (OID 18141842)
2272 -- Name: stats_agg_pages_by_day_old Type: TABLE
2275 CREATE TABLE stats_agg_pages_by_day_old (
2281 -- TOC Entry ID 261 (OID 18141853)
2283 -- Name: stats_agg_site_by_day Type: TABLE
2286 CREATE TABLE stats_agg_site_by_day (
2287 day integer DEFAULT '0' NOT NULL,
2288 count integer DEFAULT '0' NOT NULL
2292 -- TOC Entry ID 262 (OID 18141866)
2294 -- Name: stats_agg_site_by_group Type: TABLE
2297 CREATE TABLE stats_agg_site_by_group (
2298 day integer DEFAULT '0' NOT NULL,
2299 group_id integer DEFAULT '0' NOT NULL,
2300 count integer DEFAULT '0' NOT NULL
2304 -- TOC Entry ID 263 (OID 18141881)
2306 -- Name: stats_agr_filerelease Type: TABLE
2309 CREATE TABLE stats_agr_filerelease (
2310 filerelease_id integer DEFAULT '0' NOT NULL,
2311 group_id integer DEFAULT '0' NOT NULL,
2312 downloads integer DEFAULT '0' NOT NULL
2316 -- TOC Entry ID 264 (OID 18141896)
2318 -- Name: stats_agr_project Type: TABLE
2321 CREATE TABLE stats_agr_project (
2322 group_id integer DEFAULT '0' NOT NULL,
2323 group_ranking integer DEFAULT '0' NOT NULL,
2324 group_metric double precision DEFAULT '0.00000' NOT NULL,
2325 developers integer DEFAULT '0' NOT NULL,
2326 file_releases integer DEFAULT '0' NOT NULL,
2327 downloads integer DEFAULT '0' NOT NULL,
2328 site_views integer DEFAULT '0' NOT NULL,
2329 logo_views integer DEFAULT '0' NOT NULL,
2330 msg_posted integer DEFAULT '0' NOT NULL,
2331 msg_uniq_auth integer DEFAULT '0' NOT NULL,
2332 bugs_opened integer DEFAULT '0' NOT NULL,
2333 bugs_closed integer DEFAULT '0' NOT NULL,
2334 support_opened integer DEFAULT '0' NOT NULL,
2335 support_closed integer DEFAULT '0' NOT NULL,
2336 patches_opened integer DEFAULT '0' NOT NULL,
2337 patches_closed integer DEFAULT '0' NOT NULL,
2338 tasks_opened integer DEFAULT '0' NOT NULL,
2339 tasks_closed integer DEFAULT '0' NOT NULL,
2340 help_requests integer DEFAULT '0' NOT NULL,
2341 cvs_checkouts integer DEFAULT '0' NOT NULL,
2342 cvs_commits integer DEFAULT '0' NOT NULL,
2343 cvs_adds integer DEFAULT '0' NOT NULL
2347 -- TOC Entry ID 265 (OID 18141949)
2349 -- Name: stats_ftp_downloads Type: TABLE
2352 CREATE TABLE stats_ftp_downloads (
2353 day integer DEFAULT '0' NOT NULL,
2354 filerelease_id integer DEFAULT '0' NOT NULL,
2355 group_id integer DEFAULT '0' NOT NULL,
2356 downloads integer DEFAULT '0' NOT NULL
2360 -- TOC Entry ID 266 (OID 18141966)
2362 -- Name: stats_http_downloads Type: TABLE
2365 CREATE TABLE stats_http_downloads (
2366 day integer DEFAULT '0' NOT NULL,
2367 filerelease_id integer DEFAULT '0' NOT NULL,
2368 group_id integer DEFAULT '0' NOT NULL,
2369 downloads integer DEFAULT '0' NOT NULL
2373 -- TOC Entry ID 267 (OID 18141983)
2375 -- Name: stats_project Type: TABLE
2378 CREATE TABLE stats_project (
2379 month integer DEFAULT '0' NOT NULL,
2380 week integer DEFAULT '0' NOT NULL,
2381 day integer DEFAULT '0' NOT NULL,
2382 group_id integer DEFAULT '0' NOT NULL,
2383 group_ranking integer DEFAULT '0' NOT NULL,
2384 group_metric double precision DEFAULT '0.00000' NOT NULL,
2385 developers integer DEFAULT '0' NOT NULL,
2386 file_releases integer DEFAULT '0' NOT NULL,
2387 downloads integer DEFAULT '0' NOT NULL,
2388 site_views integer DEFAULT '0' NOT NULL,
2389 subdomain_views integer DEFAULT '0' NOT NULL,
2390 msg_posted integer DEFAULT '0' NOT NULL,
2391 msg_uniq_auth integer DEFAULT '0' NOT NULL,
2392 bugs_opened integer DEFAULT '0' NOT NULL,
2393 bugs_closed integer DEFAULT '0' NOT NULL,
2394 support_opened integer DEFAULT '0' NOT NULL,
2395 support_closed integer DEFAULT '0' NOT NULL,
2396 patches_opened integer DEFAULT '0' NOT NULL,
2397 patches_closed integer DEFAULT '0' NOT NULL,
2398 tasks_opened integer DEFAULT '0' NOT NULL,
2399 tasks_closed integer DEFAULT '0' NOT NULL,
2400 help_requests integer DEFAULT '0' NOT NULL,
2401 cvs_checkouts integer DEFAULT '0' NOT NULL,
2402 cvs_commits integer DEFAULT '0' NOT NULL,
2403 cvs_adds integer DEFAULT '0' NOT NULL
2407 -- TOC Entry ID 268 (OID 18142042)
2409 -- Name: stats_project_tmp Type: TABLE
2412 CREATE TABLE stats_project_tmp (
2413 month integer DEFAULT '0' NOT NULL,
2414 week integer DEFAULT '0' NOT NULL,
2415 day integer DEFAULT '0' NOT NULL,
2416 group_id integer DEFAULT '0' NOT NULL,
2417 group_ranking integer DEFAULT '0' NOT NULL,
2418 group_metric double precision DEFAULT '0.00000' NOT NULL,
2419 developers integer DEFAULT '0' NOT NULL,
2420 file_releases integer DEFAULT '0' NOT NULL,
2421 downloads integer DEFAULT '0' NOT NULL,
2422 site_views integer DEFAULT '0' NOT NULL,
2423 subdomain_views integer DEFAULT '0' NOT NULL,
2424 msg_posted integer DEFAULT '0' NOT NULL,
2425 msg_uniq_auth integer DEFAULT '0' NOT NULL,
2426 bugs_opened integer DEFAULT '0' NOT NULL,
2427 bugs_closed integer DEFAULT '0' NOT NULL,
2428 support_opened integer DEFAULT '0' NOT NULL,
2429 support_closed integer DEFAULT '0' NOT NULL,
2430 patches_opened integer DEFAULT '0' NOT NULL,
2431 patches_closed integer DEFAULT '0' NOT NULL,
2432 tasks_opened integer DEFAULT '0' NOT NULL,
2433 tasks_closed integer DEFAULT '0' NOT NULL,
2434 help_requests integer DEFAULT '0' NOT NULL,
2435 cvs_checkouts integer DEFAULT '0' NOT NULL,
2436 cvs_commits integer DEFAULT '0' NOT NULL,
2437 cvs_adds integer DEFAULT '0' NOT NULL
2441 -- TOC Entry ID 269 (OID 18142101)
2443 -- Name: stats_site Type: TABLE
2446 CREATE TABLE stats_site (
2447 month integer DEFAULT '0' NOT NULL,
2448 week integer DEFAULT '0' NOT NULL,
2449 day integer DEFAULT '0' NOT NULL,
2450 site_views integer DEFAULT '0' NOT NULL,
2451 subdomain_views integer DEFAULT '0' NOT NULL,
2452 downloads integer DEFAULT '0' NOT NULL,
2453 uniq_users integer DEFAULT '0' NOT NULL,
2454 sessions integer DEFAULT '0' NOT NULL,
2455 total_users integer DEFAULT '0' NOT NULL,
2456 new_users integer DEFAULT '0' NOT NULL,
2457 new_projects integer DEFAULT '0' NOT NULL
2461 -- TOC Entry ID 126 (OID 18142132)
2463 -- Name: support_pk_seq Type: SEQUENCE
2466 CREATE SEQUENCE support_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
2469 -- TOC Entry ID 270 (OID 18142150)
2471 -- Name: support Type: TABLE
2474 CREATE TABLE support (
2475 support_id integer DEFAULT '0' NOT NULL,
2476 group_id integer DEFAULT '0' NOT NULL,
2477 support_status_id integer DEFAULT '0' NOT NULL,
2478 support_category_id integer DEFAULT '0' NOT NULL,
2479 priority integer DEFAULT '0' NOT NULL,
2480 submitted_by integer DEFAULT '0' NOT NULL,
2481 assigned_to integer DEFAULT '0' NOT NULL,
2482 open_date integer DEFAULT '0' NOT NULL,
2483 summary varchar2(255),
2484 close_date integer DEFAULT '0' NOT NULL,
2485 PRIMARY KEY (support_id)
2488 --nextval('support_pk_seq'::text)
2489 CREATE TRIGGER DEFAULT_support BEFORE
2491 ON support REFERENCING OLD AS old NEW AS new
2494 select support_pk_seq.nextval into :new.support_id from dual;
2499 -- TOC Entry ID 128 (OID 18142196)
2501 -- Name: support_canned_responses_pk_seq Type: SEQUENCE
2504 CREATE SEQUENCE support_canned_resp_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
2507 -- TOC Entry ID 271 (OID 18142214)
2509 -- Name: support_canned_responses Type: TABLE
2512 CREATE TABLE support_canned_responses (
2513 support_canned_id integer DEFAULT '0' NOT NULL,
2514 group_id integer DEFAULT '0' NOT NULL,
2515 title varchar2(255),
2517 PRIMARY KEY (support_canned_id)
2520 CREATE TRIGGER DEFAULT_support_canned_resp BEFORE
2522 ON support_canned_responses REFERENCING OLD AS old NEW AS new
2525 select support_canned_resp_pk_seq.nextval into :new.support_canned_id from dual;
2530 -- TOC Entry ID 130 (OID 18142247)
2532 -- Name: support_category_pk_seq Type: SEQUENCE
2535 CREATE SEQUENCE support_category_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
2538 -- TOC Entry ID 272 (OID 18142265)
2540 -- Name: support_category Type: TABLE
2543 CREATE TABLE support_category (
2544 support_category_id integer DEFAULT '0' NOT NULL,
2545 group_id integer DEFAULT '0' NOT NULL,
2546 category_name varchar2(255) DEFAULT '',
2547 PRIMARY KEY (support_category_id)
2550 CREATE TRIGGER DEFAULT_support_category BEFORE
2552 ON support_category REFERENCING OLD AS old NEW AS new
2555 select support_category_pk_seq.nextval into :new.support_category_id from dual;
2560 -- TOC Entry ID 132 (OID 18142298)
2562 -- Name: support_history_pk_seq Type: SEQUENCE
2565 CREATE SEQUENCE support_history_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
2568 -- TOC Entry ID 273 (OID 18142316)
2570 -- Name: support_history Type: TABLE
2573 CREATE TABLE support_history (
2574 support_history_id integer DEFAULT '0' NOT NULL,
2575 support_id integer DEFAULT '0' NOT NULL,
2576 field_name varchar2(255) DEFAULT '',
2577 old_value varchar2(255) DEFAULT '',
2578 mod_by integer DEFAULT '0' NOT NULL,
2580 PRIMARY KEY (support_history_id)
2583 CREATE TRIGGER DEFAULT_support_history BEFORE
2585 ON support_history REFERENCING OLD AS old NEW AS new
2588 select support_history_pk_seq.nextval into :new.support_history_id from dual;
2593 -- TOC Entry ID 134 (OID 18142354)
2595 -- Name: support_messages_pk_seq Type: SEQUENCE
2598 CREATE SEQUENCE support_messages_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
2601 -- TOC Entry ID 274 (OID 18142372)
2603 -- Name: support_messages Type: TABLE
2606 CREATE TABLE support_messages (
2607 support_message_id integer DEFAULT '0' NOT NULL,
2608 support_id integer DEFAULT '0' NOT NULL,
2609 from_email varchar2(255),
2610 sf_date integer DEFAULT '0' NOT NULL,
2612 PRIMARY KEY (support_message_id)
2615 CREATE TRIGGER DEFAULT_support_messages BEFORE
2617 ON support_messages REFERENCING OLD AS old NEW AS new
2620 select support_messages_pk_seq.nextval into :new.support_message_id from dual;
2625 -- TOC Entry ID 136 (OID 18142407)
2627 -- Name: support_status_pk_seq Type: SEQUENCE
2630 CREATE SEQUENCE support_status_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
2633 -- TOC Entry ID 275 (OID 18142425)
2635 -- Name: support_status Type: TABLE
2638 CREATE TABLE support_status (
2639 support_status_id integer DEFAULT '0' NOT NULL,
2640 status_name varchar2(255),
2641 PRIMARY KEY (support_status_id)
2644 CREATE TRIGGER DEFAULT_support_status BEFORE
2646 ON support_status REFERENCING OLD AS old NEW AS new
2649 select support_status_pk_seq.nextval into :new.support_status_id from dual;
2654 -- TOC Entry ID 138 (OID 18142455)
2656 -- Name: supported_languages_pk_seq Type: SEQUENCE
2659 CREATE SEQUENCE supported_languages_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
2662 -- TOC Entry ID 276 (OID 18142473)
2664 -- Name: supported_languages Type: TABLE
2667 CREATE TABLE supported_languages (
2668 language_id integer DEFAULT '0' NOT NULL,
2670 filename varchar2(255),
2671 classname varchar2(255),
2672 language_code character(2),
2673 PRIMARY KEY (language_id)
2676 CREATE TRIGGER DEFAULT_supported_languages BEFORE
2678 ON supported_languages REFERENCING OLD AS old NEW AS new
2681 select supported_languages_pk_seq.nextval into :new.language_id from dual;
2686 -- TOC Entry ID 140 (OID 18142506)
2688 -- Name: survey_question_types_pk_seq Type: SEQUENCE
2691 CREATE SEQUENCE survey_question_types_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
2694 -- TOC Entry ID 277 (OID 18142524)
2696 -- Name: survey_question_types Type: TABLE
2699 CREATE TABLE survey_question_types (
2700 id integer DEFAULT '0' NOT NULL,
2701 type varchar2(255) DEFAULT '',
2705 CREATE TRIGGER DEFAULT_survey_question_types BEFORE
2707 ON survey_question_types REFERENCING OLD AS old NEW AS new
2710 select survey_question_types_pk_seq.nextval into :new.id from dual;
2715 -- TOC Entry ID 142 (OID 18142555)
2717 -- Name: survey_questions_pk_seq Type: SEQUENCE
2720 CREATE SEQUENCE survey_questions_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
2723 -- TOC Entry ID 278 (OID 18142573)
2725 -- Name: survey_questions Type: TABLE
2728 CREATE TABLE survey_questions (
2729 question_id integer DEFAULT '0' NOT NULL,
2730 group_id integer DEFAULT '0' NOT NULL,
2731 question varchar2(255) DEFAULT '',
2732 question_type integer DEFAULT '0' NOT NULL,
2733 PRIMARY KEY (question_id)
2736 CREATE TRIGGER DEFAULT_survey_question BEFORE
2738 ON survey_questions REFERENCING OLD AS old NEW AS new
2741 select survey_questions_pk_seq.nextval into :new.question_id from dual;
2746 -- TOC Entry ID 279 (OID 18142608)
2748 -- Name: survey_rating_aggregate Type: TABLE
2751 CREATE TABLE survey_rating_aggregate (
2752 type integer DEFAULT '0' NOT NULL,
2753 id integer DEFAULT '0' NOT NULL,
2754 response double precision DEFAULT '0' NOT NULL,
2755 count integer DEFAULT '0' NOT NULL
2759 -- TOC Entry ID 280 (OID 18142625)
2761 -- Name: survey_rating_response Type: TABLE
2764 CREATE TABLE survey_rating_response (
2765 user_id integer DEFAULT '0' NOT NULL,
2766 type integer DEFAULT '0' NOT NULL,
2767 id integer DEFAULT '0' NOT NULL,
2768 response integer DEFAULT '0' NOT NULL,
2769 sf_date integer DEFAULT '0' NOT NULL
2773 -- TOC Entry ID 281 (OID 18142644)
2775 -- Name: survey_responses Type: TABLE
2778 CREATE TABLE survey_responses (
2779 user_id integer DEFAULT '0' NOT NULL,
2780 group_id integer DEFAULT '0' NOT NULL,
2781 survey_id integer DEFAULT '0' NOT NULL,
2782 question_id integer DEFAULT '0' NOT NULL,
2783 response varchar2(255) DEFAULT '',
2784 sf_date integer DEFAULT '0' NOT NULL
2788 -- TOC Entry ID 144 (OID 18142680)
2790 -- Name: surveys_pk_seq Type: SEQUENCE
2793 CREATE SEQUENCE surveys_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
2796 -- TOC Entry ID 282 (OID 18142698)
2798 -- Name: surveys Type: TABLE
2801 CREATE TABLE surveys (
2802 survey_id integer DEFAULT '0' NOT NULL,
2803 group_id integer DEFAULT '0' NOT NULL,
2804 survey_title varchar2(255) DEFAULT '',
2805 survey_questions varchar2(255) DEFAULT '',
2806 is_active integer DEFAULT '1' NOT NULL,
2807 PRIMARY KEY (survey_id)
2811 CREATE TRIGGER DEFAULT_surveys BEFORE
2813 ON surveys REFERENCING OLD AS old NEW AS new
2816 select surveys_pk_seq.nextval into :new.survey_id from dual;
2821 -- TOC Entry ID 146 (OID 18142735)
2823 -- Name: system_history_pk_seq Type: SEQUENCE
2826 CREATE SEQUENCE system_history_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
2829 -- TOC Entry ID 148 (OID 18142787)
2831 -- Name: system_machines_pk_seq Type: SEQUENCE
2834 CREATE SEQUENCE system_machines_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
2837 -- TOC Entry ID 150 (OID 18142836)
2839 -- Name: system_news_pk_seq Type: SEQUENCE
2842 CREATE SEQUENCE system_news_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
2845 -- TOC Entry ID 152 (OID 18142895)
2847 -- Name: system_services_pk_seq Type: SEQUENCE
2850 CREATE SEQUENCE system_services_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
2853 -- TOC Entry ID 154 (OID 18142944)
2855 -- Name: system_status_pk_seq Type: SEQUENCE
2858 CREATE SEQUENCE system_status_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
2861 -- TOC Entry ID 283 (OID 18142992)
2863 -- Name: theme_prefs Type: TABLE
2866 CREATE TABLE theme_prefs (
2867 user_id integer DEFAULT '0' NOT NULL,
2868 user_theme integer DEFAULT '0' NOT NULL,
2869 body_font character(80) DEFAULT '',
2870 body_size character(5) DEFAULT '',
2871 titlebar_font character(80) DEFAULT '',
2872 titlebar_size character(5) DEFAULT '',
2873 color_titlebar_back character(7) DEFAULT '',
2874 color_ltback1 character(7) DEFAULT '',
2875 PRIMARY KEY (user_id)
2879 -- TOC Entry ID 156 (OID 18143020)
2881 -- Name: themes_pk_seq Type: SEQUENCE
2884 CREATE SEQUENCE themes_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
2887 -- TOC Entry ID 284 (OID 18143038)
2889 -- Name: themes Type: TABLE
2892 CREATE TABLE themes (
2893 theme_id integer DEFAULT '0' NOT NULL,
2894 dirname character varying(80),
2895 fullname character varying(80),
2896 PRIMARY KEY (theme_id)
2899 CREATE TRIGGER DEFAULT_themes BEFORE
2901 ON themes REFERENCING OLD AS old NEW AS new
2904 select themes_pk_seq.nextval into :new.theme_id from dual;
2909 -- TOC Entry ID 285 (OID 18143054)
2911 -- Name: tmp_projs_releases_tmp Type: TABLE
2914 CREATE TABLE tmp_projs_releases_tmp (
2915 year integer DEFAULT '0' NOT NULL,
2916 month integer DEFAULT '0' NOT NULL,
2917 total_proj integer DEFAULT '0' NOT NULL,
2918 total_releases integer DEFAULT '0' NOT NULL
2922 -- TOC Entry ID 286 (OID 18143071)
2924 -- Name: top_group Type: TABLE
2927 CREATE TABLE top_group (
2928 group_id integer DEFAULT '0' NOT NULL,
2929 group_name character varying(40),
2930 downloads_all integer DEFAULT '0' NOT NULL,
2931 rank_downloads_all integer DEFAULT '0' NOT NULL,
2932 rank_downloads_all_old integer DEFAULT '0' NOT NULL,
2933 downloads_week integer DEFAULT '0' NOT NULL,
2934 rank_downloads_week integer DEFAULT '0' NOT NULL,
2935 rank_downloads_week_old integer DEFAULT '0' NOT NULL,
2936 userrank integer DEFAULT '0' NOT NULL,
2937 rank_userrank integer DEFAULT '0' NOT NULL,
2938 rank_userrank_old integer DEFAULT '0' NOT NULL,
2939 forumposts_week integer DEFAULT '0' NOT NULL,
2940 rank_forumposts_week integer DEFAULT '0' NOT NULL,
2941 rank_forumposts_week_old integer DEFAULT '0' NOT NULL,
2942 pageviews_proj integer DEFAULT '0' NOT NULL,
2943 rank_pageviews_proj integer DEFAULT '0' NOT NULL,
2944 rank_pageviews_proj_old integer DEFAULT '0' NOT NULL
2948 -- TOC Entry ID 158 (OID 18143113)
2950 -- Name: trove_cat_pk_seq Type: SEQUENCE
2953 CREATE SEQUENCE trove_cat_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
2956 -- TOC Entry ID 287 (OID 18143131)
2958 -- Name: trove_cat Type: TABLE
2961 CREATE TABLE trove_cat (
2962 trove_cat_id integer DEFAULT '0' NOT NULL,
2963 version integer DEFAULT '0' NOT NULL,
2964 parent integer DEFAULT '0' NOT NULL,
2965 root_parent integer DEFAULT '0' NOT NULL,
2966 shortname character varying(80),
2967 fullname character varying(80),
2968 description character varying(255),
2969 count_subcat integer DEFAULT '0' NOT NULL,
2970 count_subproj integer DEFAULT '0' NOT NULL,
2971 fullpath varchar2(255) DEFAULT '',
2972 fullpath_ids varchar2(255),
2973 PRIMARY KEY (trove_cat_id)
2976 CREATE TRIGGER DEFAULT_trove_cat BEFORE
2978 ON trove_cat REFERENCING OLD AS old NEW AS new
2981 select trove_cat_pk_seq.nextval into :new.trove_cat_id from dual;
2986 -- TOC Entry ID 160 (OID 18143176)
2988 -- Name: trove_group_link_pk_seq Type: SEQUENCE
2991 CREATE SEQUENCE trove_group_link_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
2994 -- TOC Entry ID 288 (OID 18143194)
2996 -- Name: trove_group_link Type: TABLE
2999 CREATE TABLE trove_group_link (
3000 trove_group_id integer DEFAULT '0' NOT NULL,
3001 trove_cat_id integer DEFAULT '0' NOT NULL,
3002 trove_cat_version integer DEFAULT '0' NOT NULL,
3003 group_id integer DEFAULT '0' NOT NULL,
3004 trove_cat_root integer DEFAULT '0' NOT NULL,
3005 PRIMARY KEY (trove_group_id)
3008 CREATE TRIGGER DEFAULT_trove_group_link BEFORE
3010 ON trove_group_link REFERENCING OLD AS old NEW AS new
3013 select trove_group_link_pk_seq.nextval into :new.trove_group_id from dual;
3018 -- TOC Entry ID 162 (OID 18143216)
3020 -- Name: trove_treesums_pk_seq Type: SEQUENCE
3023 CREATE SEQUENCE trove_treesums_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
3026 -- TOC Entry ID 289 (OID 18143234)
3028 -- Name: trove_treesums Type: TABLE
3031 CREATE TABLE trove_treesums (
3032 trove_treesums_id integer DEFAULT '0' NOT NULL,
3033 trove_cat_id integer DEFAULT '0' NOT NULL,
3034 limit_1 integer DEFAULT '0' NOT NULL,
3035 subprojects integer DEFAULT '0' NOT NULL,
3036 PRIMARY KEY (trove_treesums_id)
3039 CREATE TRIGGER DEFAULT_trove_treesums BEFORE
3041 ON trove_treesums REFERENCING OLD AS old NEW AS new
3044 select trove_treesums_pk_seq.nextval into :new.trove_treesums_id from dual;
3049 -- TOC Entry ID 164 (OID 18143286)
3051 -- Name: user_bookmarks_pk_seq Type: SEQUENCE
3054 CREATE SEQUENCE user_bookmarks_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
3057 -- TOC Entry ID 290 (OID 18143304)
3059 -- Name: user_bookmarks Type: TABLE
3062 CREATE TABLE user_bookmarks (
3063 bookmark_id integer DEFAULT '0' NOT NULL,
3064 user_id integer DEFAULT '0' NOT NULL,
3065 bookmark_url varchar2(255),
3066 bookmark_title varchar2(255),
3067 PRIMARY KEY (bookmark_id)
3070 CREATE TRIGGER DEFAULT_user_bookmarks BEFORE
3072 ON user_bookmarks REFERENCING OLD AS old NEW AS new
3075 select user_bookmarks_pk_seq.nextval into :new.bookmark_id from dual;
3080 -- TOC Entry ID 166 (OID 18143337)
3082 -- Name: user_diary_pk_seq Type: SEQUENCE
3085 CREATE SEQUENCE user_diary_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
3088 -- TOC Entry ID 291 (OID 18143355)
3090 -- Name: user_diary Type: TABLE
3093 CREATE TABLE user_diary (
3094 id integer DEFAULT '0' NOT NULL,
3095 user_id integer DEFAULT '0' NOT NULL,
3096 date_posted integer DEFAULT '0' NOT NULL,
3097 summary varchar2(255),
3098 details varchar2(255),
3099 is_public integer DEFAULT '0' NOT NULL,
3103 CREATE TRIGGER DEFAULT_user_diary BEFORE
3105 ON user_diary REFERENCING OLD AS old NEW AS new
3108 select user_diary_pk_seq.nextval into :new.id from dual;
3113 -- TOC Entry ID 168 (OID 18143392)
3115 -- Name: user_diary_monitor_pk_seq Type: SEQUENCE
3118 CREATE SEQUENCE user_diary_monitor_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
3121 -- TOC Entry ID 292 (OID 18143410)
3123 -- Name: user_diary_monitor Type: TABLE
3126 CREATE TABLE user_diary_monitor (
3127 monitor_id integer DEFAULT '0' NOT NULL,
3128 monitored_user integer DEFAULT '0' NOT NULL,
3129 user_id integer DEFAULT '0' NOT NULL,
3130 PRIMARY KEY (monitor_id)
3133 CREATE TRIGGER DEFAULT_user_diary_monitor BEFORE
3135 ON user_diary_monitor REFERENCING OLD AS old NEW AS new
3138 select user_diary_monitor_pk_seq.nextval into :new.monitor_id from dual;
3143 -- TOC Entry ID 170 (OID 18143428)
3145 -- Name: user_group_pk_seq Type: SEQUENCE
3148 CREATE SEQUENCE user_group_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
3151 -- TOC Entry ID 293 (OID 18143446)
3153 -- Name: user_group Type: TABLE
3156 CREATE TABLE user_group (
3157 user_group_id integer DEFAULT '0' NOT NULL,
3158 user_id integer DEFAULT '0' NOT NULL,
3159 group_id integer DEFAULT '0' NOT NULL,
3160 admin_flags character(16) DEFAULT '',
3161 bug_flags integer DEFAULT '0' NOT NULL,
3162 forum_flags integer DEFAULT '0' NOT NULL,
3163 project_flags integer DEFAULT '2' NOT NULL,
3164 patch_flags integer DEFAULT '1' NOT NULL,
3165 support_flags integer DEFAULT '1' NOT NULL,
3166 doc_flags integer DEFAULT '0' NOT NULL,
3167 cvs_flags integer DEFAULT '1' NOT NULL,
3168 member_role integer DEFAULT '100' NOT NULL,
3169 release_flags integer DEFAULT '0' NOT NULL,
3170 PRIMARY KEY (user_group_id)
3173 CREATE TRIGGER DEFAULT_user_group BEFORE
3175 ON user_group REFERENCING OLD AS old NEW AS new
3178 select user_group_pk_seq.nextval into :new.user_group_id from dual;
3183 -- TOC Entry ID 172 (OID 18143484)
3185 -- Name: user_metric_pk_seq Type: SEQUENCE
3188 CREATE SEQUENCE user_metric_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
3191 -- TOC Entry ID 294 (OID 18143502)
3193 -- Name: user_metric Type: TABLE
3196 CREATE TABLE user_metric (
3197 ranking integer DEFAULT '0' NOT NULL,
3198 user_id integer DEFAULT '0' NOT NULL,
3199 times_ranked integer DEFAULT '0' NOT NULL,
3200 avg_raters_importance double precision DEFAULT '0.00000000' NOT NULL,
3201 avg_rating double precision DEFAULT '0.00000000' NOT NULL,
3202 metric double precision DEFAULT '0.00000000' NOT NULL,
3203 percentile double precision DEFAULT '0.00000000' NOT NULL,
3204 importance_factor double precision DEFAULT '0.00000000' NOT NULL,
3205 PRIMARY KEY (ranking)
3208 CREATE TRIGGER DEFAULT_user_metric BEFORE
3210 ON user_metric REFERENCING OLD AS old NEW AS new
3213 select user_metric_pk_seq.nextval into :new.ranking from dual;
3218 -- TOC Entry ID 174 (OID 18143530)
3220 -- Name: user_metric0_pk_seq Type: SEQUENCE
3223 CREATE SEQUENCE user_metric0_pk_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
3226 -- TOC Entry ID 295 (OID 18143548)
3228 -- Name: user_metric0 Type: TABLE
3231 CREATE TABLE user_metric0 (
3232 ranking integer DEFAULT '0' NOT NULL,
3233 user_id integer DEFAULT '0' NOT NULL,
3234 times_ranked integer DEFAULT '0' NOT NULL,
3235 avg_raters_importance double precision DEFAULT '0.00000000' NOT NULL,
3236 avg_rating double precision DEFAULT '0.00000000' NOT NULL,
3237 metric double precision DEFAULT '0.00000000' NOT NULL,
3238 percentile double precision DEFAULT '0.00000000' NOT NULL,
3239 importance_factor double precision DEFAULT '0.00000000' NOT NULL,
3240 PRIMARY KEY (ranking)
3243 CREATE TRIGGER DEFAULT_user_metric0 BEFORE
3245 ON user_metric0 REFERENCING OLD AS old NEW AS new
3248 select user_metric0_pk_seq.nextval into :new.ranking from dual;
3253 -- TOC Entry ID 296 (OID 18143576)
3255 -- Name: user_preferences Type: TABLE
3258 CREATE TABLE user_preferences (
3259 user_id integer DEFAULT '0' NOT NULL,
3260 preference_name character varying(20),
3261 preference_value character varying(20),
3262 set_date integer DEFAULT '0' NOT NULL
3266 -- TOC Entry ID 297 (OID 18143591)
3268 -- Name: user_ratings Type: TABLE
3271 CREATE TABLE user_ratings (
3272 rated_by integer DEFAULT '0' NOT NULL,
3273 user_id integer DEFAULT '0' NOT NULL,
3274 rate_field integer DEFAULT '0' NOT NULL,
3275 rating integer DEFAULT '0' NOT NULL
3279 -- TOC Entry ID 176 (OID 18143608)
3281 -- Name: users_pk_seq Type: SEQUENCE
3284 CREATE SEQUENCE users_pk_seq start with 100 increment by 1 maxvalue 2147483647 minvalue 1 ;
3287 -- TOC Entry ID 298 (OID 18143626)
3289 -- Name: users Type: TABLE
3292 CREATE TABLE users (
3293 user_id integer DEFAULT '0' NOT NULL,
3294 user_name varchar2(255) DEFAULT '',
3295 email varchar2(255) DEFAULT '',
3296 user_pw character varying(32) DEFAULT '',
3297 realname character varying(32) DEFAULT '',
3298 status character(1) DEFAULT 'A' NOT NULL,
3299 shell character varying(20) DEFAULT '/bin/bash' NOT NULL,
3300 unix_pw character varying(40) DEFAULT '',
3301 unix_status character(1) DEFAULT 'N' NOT NULL,
3302 unix_uid integer DEFAULT '0' NOT NULL,
3303 unix_box character varying(10) DEFAULT 'shell1' NOT NULL,
3304 add_date integer DEFAULT '0' NOT NULL,
3305 confirm_hash character varying(32),
3306 mail_siteupdates integer DEFAULT '0' NOT NULL,
3307 mail_va integer DEFAULT '0' NOT NULL,
3308 authorized_keys varchar2(255),
3309 email_new varchar2(255),
3310 people_view_skills integer DEFAULT '0' NOT NULL,
3311 people_resume varchar2(255) DEFAULT '',
3312 timezone character varying(64) DEFAULT 'GMT',
3313 language integer DEFAULT '1' NOT NULL,
3314 PRIMARY KEY (user_id)
3317 CREATE TRIGGER DEFAULT_users BEFORE
3319 ON users REFERENCING OLD AS old NEW AS new
3322 select users_pk_seq.nextval into :new.user_id from dual;
3327 -- TOC Entry ID 178 (OID 27311232)
3329 -- Name: unix_uid_seq Type: SEQUENCE
3332 CREATE SEQUENCE unix_uid_seq start with 600 increment by 1 maxvalue 2147483647 minvalue 1 ;
3335 -- TOC Entry ID 180 (OID 27311250)
3337 -- Name: forum_thread_seq Type: SEQUENCE
3340 CREATE SEQUENCE forum_thread_seq start with 1 increment by 1 maxvalue 2147483647 minvalue 1 ;
3343 -- TOC Entry ID 299 (OID 27311451)
3345 -- Name: trove_agg Type: TABLE
3348 CREATE TABLE trove_agg (
3349 trove_cat_id integer,
3351 group_name character varying(40),
3352 unix_group_name character varying(30),
3353 status character(1),
3354 register_time integer,
3355 short_description character varying(255),
3356 percentile double precision,
3361 -- TOC Entry ID 302 (OID 30136736)
3363 -- Name: activity_log Type: TABLE Owner: www
3366 CREATE TABLE activity_log (
3367 day integer DEFAULT '0' NOT NULL,
3368 hour integer DEFAULT '0' NOT NULL,
3369 group_id integer DEFAULT '0' NOT NULL,
3370 browser character varying(8) DEFAULT 'OTHER' NOT NULL,
3371 ver double precision DEFAULT '0.00' NOT NULL,
3372 platform character varying(8) DEFAULT 'OTHER' NOT NULL,
3373 time integer DEFAULT '0' NOT NULL,
3375 type integer DEFAULT '0' NOT NULL
3378 --\connect - tperdue
3380 -- TOC Entry ID 316 (OID 18138445)
3382 -- Name: bug_group_id Type: INDEX
3385 CREATE INDEX bug_group_id on bug ( group_id );
3388 -- TOC Entry ID 466 (OID 18138445)
3390 -- Name: bug_groupid_statusid Type: INDEX
3393 CREATE INDEX bug_groupid_statusid on bug ( group_id , status_id );
3396 -- TOC Entry ID 467 (OID 18138445)
3398 -- Name: bug_groupid_assignedto_statusid Type: INDEX
3401 CREATE INDEX bug_groupid_assngto_stsid on bug ( group_id , assigned_to , status_id );
3404 -- TOC Entry ID 317 (OID 18138513)
3406 -- Name: bug_bug_dependencies_bug_id Type: INDEX
3409 CREATE INDEX bug_bug_dependencies_bug_id on bug_bug_dependencies ( bug_id );
3412 -- TOC Entry ID 318 (OID 18138513)
3414 -- Name: bug_bug_is_dependent_on_task_id Type: INDEX
3417 CREATE INDEX bug_bug_is_dpnd_on_tsk_id on bug_bug_dependencies ( is_dependent_on_bug_id );
3420 -- TOC Entry ID 319 (OID 18138549)
3422 -- Name: bug_canned_response_group_id Type: INDEX
3425 CREATE INDEX bug_canned_response_group_id on bug_canned_responses ( group_id );
3428 -- TOC Entry ID 320 (OID 18138600)
3430 -- Name: bug_category_group_id Type: INDEX
3433 CREATE INDEX bug_category_group_id on bug_category ( group_id );
3436 -- TOC Entry ID 321 (OID 18138705)
3438 -- Name: bug_group_group_id Type: INDEX
3441 CREATE INDEX bug_group_group_id on bug_group ( group_id );
3444 -- TOC Entry ID 322 (OID 18138756)
3446 -- Name: bug_history_bug_id Type: INDEX
3449 CREATE INDEX bug_history_bug_id on bug_history ( bug_id );
3452 -- TOC Entry ID 323 (OID 18138909)
3454 -- Name: bug_task_dependencies_bug_id Type: INDEX
3457 CREATE INDEX bug_task_dependencies_bug_id on bug_task_dependencies ( bug_id );
3460 -- TOC Entry ID 324 (OID 18138909)
3462 -- Name: bug_task_is_dpndnt_on_tsk_i Type: INDEX
3465 CREATE INDEX bug_task_is_dpndnt_on_tsk_i on bug_task_dependencies ( is_dependent_on_task_id );
3468 -- TOC Entry ID 325 (OID 18138995)
3470 -- Name: db_images_group Type: INDEX
3473 CREATE INDEX db_images_group on db_images ( group_id );
3476 -- TOC Entry ID 326 (OID 18139058)
3478 -- Name: doc_group_doc_group Type: INDEX
3481 CREATE INDEX doc_group_doc_group on doc_data ( doc_group );
3484 -- TOC Entry ID 327 (OID 18139122)
3486 -- Name: doc_groups_group Type: INDEX
3489 CREATE INDEX doc_groups_group on doc_groups ( group_id );
3492 -- TOC Entry ID 328 (OID 18139192)
3494 -- Name: filemodule_monitor_id Type: INDEX
3497 CREATE INDEX filemodule_monitor_id on filemodule_monitor ( filemodule_id );
3500 -- TOC Entry ID 329 (OID 18139228)
3502 -- Name: forum_forumid_msgid Type: INDEX
3505 CREATE INDEX forum_forumid_msgid on forum ( group_forum_id , msg_id );
3508 -- TOC Entry ID 330 (OID 18139228)
3510 -- Name: forum_group_forum_id Type: INDEX
3513 CREATE INDEX forum_group_forum_id on forum ( group_forum_id );
3516 -- TOC Entry ID 331 (OID 18139228)
3518 -- Name: forum_forumid_isfollowupto Type: INDEX
3521 CREATE INDEX forum_forumid_isfollowupto on forum ( group_forum_id , is_followup_to );
3524 -- TOC Entry ID 332 (OID 18139228)
3526 -- Name: forum_forumid_threadid_mostrece Type: INDEX
3529 CREATE INDEX forum_formid_thrdid_mstrc on forum ( group_forum_id , thread_id , most_recent_date );
3532 -- TOC Entry ID 333 (OID 18139228)
3534 -- Name: forum_threadid_isfollowupto Type: INDEX
3537 CREATE INDEX forum_threadid_isfollowupto on forum ( thread_id , is_followup_to );
3540 -- TOC Entry ID 334 (OID 18139228)
3542 -- Name: forum_forumid_isfollto_mostrece Type: INDEX
3545 CREATE INDEX forum_forumid_isfollto_mstrc on forum ( group_forum_id , is_followup_to , most_recent_date );
3548 -- TOC Entry ID 335 (OID 18139309)
3550 -- Name: forum_group_list_group_id Type: INDEX
3553 CREATE INDEX forum_group_list_group_id on forum_group_list ( group_id );
3556 -- TOC Entry ID 336 (OID 18139366)
3558 -- Name: forum_monitor_combo_id Type: INDEX
3561 CREATE INDEX forum_monitor_combo_id on forum_monitored_forums ( forum_id , user_id );
3564 -- TOC Entry ID 337 (OID 18139366)
3566 -- Name: forum_monitor_thread_id Type: INDEX
3569 CREATE INDEX forum_monitor_thread_id on forum_monitored_forums ( forum_id );
3572 -- TOC Entry ID 338 (OID 18139510)
3574 -- Name: foundry_news_foundry_approved_d Type: INDEX
3577 CREATE INDEX foundry_news_fndry_apprvd_d on foundry_news ( foundry_id , is_approved , approve_date );
3580 -- TOC Entry ID 339 (OID 18139510)
3582 -- Name: foundry_news_foundry_approved Type: INDEX
3585 CREATE INDEX foundry_news_foundry_approved on foundry_news ( foundry_id , is_approved );
3588 -- TOC Entry ID 340 (OID 18139510)
3590 -- Name: foundry_news_foundry Type: INDEX
3593 CREATE INDEX foundry_news_foundry on foundry_news ( foundry_id );
3596 -- TOC Entry ID 463 (OID 18139510)
3598 -- Name: foundrynews_foundry_dt_apprv Type: INDEX
3601 CREATE INDEX foundrynews_foundry_dt_apprv on foundry_news ( foundry_id , approve_date , is_approved );
3604 -- TOC Entry ID 341 (OID 18139550)
3606 -- Name: foundry_project_group_rank Type: INDEX
3609 CREATE INDEX foundry_project_group_rank on foundry_preferred_projects ( group_id , rank );
3612 -- TOC Entry ID 342 (OID 18139550)
3614 -- Name: foundry_project_group Type: INDEX
3617 CREATE INDEX foundry_project_group on foundry_preferred_projects ( group_id );
3620 -- TOC Entry ID 343 (OID 18139588)
3622 -- Name: foundry_projects_foundry Type: INDEX
3625 CREATE INDEX foundry_projects_foundry on foundry_projects ( foundry_id );
3628 -- TOC Entry ID 344 (OID 18139606)
3630 -- Name: downloads_http_idx Type: INDEX
3633 CREATE INDEX downloads_http_idx on frs_dlstats_agg ( downloads_http );
3636 -- TOC Entry ID 345 (OID 18139606)
3638 -- Name: downloads_ftp_idx Type: INDEX
3641 CREATE INDEX downloads_ftp_idx on frs_dlstats_agg ( downloads_ftp );
3644 -- TOC Entry ID 346 (OID 18139606)
3646 -- Name: file_id_idx Type: INDEX
3649 CREATE INDEX file_id_idx on frs_dlstats_agg ( file_id );
3652 -- TOC Entry ID 347 (OID 18139606)
3654 -- Name: day_idx Type: INDEX
3657 CREATE INDEX day_idx on frs_dlstats_agg ( day );
3660 -- TOC Entry ID 348 (OID 18139623)
3662 -- Name: dlstats_file_down Type: INDEX
3665 CREATE INDEX dlstats_file_down on frs_dlstats_file_agg ( downloads );
3668 -- TOC Entry ID 349 (OID 18139623)
3670 -- Name: dlstats_file_file_id Type: INDEX
3673 CREATE INDEX dlstats_file_file_id on frs_dlstats_file_agg ( file_id );
3676 -- TOC Entry ID 350 (OID 18139623)
3678 -- Name: dlstats_file_day Type: INDEX
3681 CREATE INDEX dlstats_file_day on frs_dlstats_file_agg ( day );
3684 -- TOC Entry ID 351 (OID 18139638)
3686 -- Name: stats_agr_tmp_fid Type: INDEX
3689 -- Removed because is not needed because is created in table definition
3690 -- CREATE INDEX stats_agr_tmp_fid on frs_dlstats_filetotal_agg ( file_id );
3693 -- TOC Entry ID 352 (OID 18139654)
3695 -- Name: frs_dlstats_filetotal_agg_old_f Type: INDEX
3698 CREATE INDEX frs_dlstats_filettl_agg_old_f on frs_dlstats_filetotal_agg_old ( file_id );
3701 -- TOC Entry ID 303 (OID 18139667)
3703 -- Name: frsdlstatsgroupagg_day_dls Type: INDEX
3706 CREATE INDEX frsdlstatsgroupagg_day_dls on frs_dlstats_group_agg ( day , downloads );
3709 -- TOC Entry ID 353 (OID 18139667)
3711 -- Name: group_id_idx Type: INDEX
3714 CREATE INDEX group_id_idx on frs_dlstats_group_agg ( group_id );
3717 -- TOC Entry ID 355 (OID 18139667)
3719 -- Name: frs_dlstats_group_agg_day Type: INDEX
3722 CREATE INDEX frs_dlstats_group_agg_day on frs_dlstats_group_agg ( day );
3725 -- TOC Entry ID 356 (OID 18139682)
3727 -- Name: stats_agr_tmp_gid Type: INDEX
3730 CREATE INDEX stats_agr_tmp_gid on frs_dlstats_grouptotal_agg ( group_id );
3733 -- TOC Entry ID 357 (OID 18139714)
3735 -- Name: frs_file_name Type: INDEX
3738 CREATE INDEX frs_file_name on frs_file ( filename );
3741 -- TOC Entry ID 358 (OID 18139714)
3743 -- Name: frs_file_date Type: INDEX
3746 CREATE INDEX frs_file_date on frs_file ( post_date );
3749 -- TOC Entry ID 359 (OID 18139714)
3751 -- Name: frs_file_processor Type: INDEX
3754 CREATE INDEX frs_file_processor on frs_file ( processor_id );
3757 -- TOC Entry ID 360 (OID 18139714)
3759 -- Name: frs_file_release_id Type: INDEX
3762 CREATE INDEX frs_file_release_id on frs_file ( release_id );
3765 -- TOC Entry ID 361 (OID 18139714)
3767 -- Name: frs_file_type Type: INDEX
3770 CREATE INDEX frs_file_type on frs_file ( type_id );
3773 -- TOC Entry ID 362 (OID 18139822)
3775 -- Name: package_group_id Type: INDEX
3778 CREATE INDEX package_group_id on frs_package ( group_id );
3781 -- TOC Entry ID 363 (OID 18139922)
3783 -- Name: frs_release_package Type: INDEX
3786 CREATE INDEX frs_release_package on frs_release ( package_id );
3789 -- TOC Entry ID 364 (OID 18139922)
3791 -- Name: frs_release_date Type: INDEX
3794 CREATE INDEX frs_release_date on frs_release ( release_date );
3797 -- TOC Entry ID 365 (OID 18139922)
3799 -- Name: frs_release_by Type: INDEX
3802 CREATE INDEX frs_release_by on frs_release ( released_by );
3805 -- TOC Entry ID 366 (OID 18140030)
3807 -- Name: group_cvs_history_group_id Type: INDEX
3810 CREATE INDEX group_cvs_history_group_id on group_cvs_history ( group_id );
3813 -- TOC Entry ID 367 (OID 18140030)
3815 -- Name: user_name_idx Type: INDEX
3818 CREATE INDEX user_name_idx on group_cvs_history ( user_name );
3821 -- TOC Entry ID 368 (OID 18140074)
3823 -- Name: group_history_group_id Type: INDEX
3826 CREATE INDEX group_history_group_id on group_history ( group_id );
3829 -- TOC Entry ID 369 (OID 18140178)
3831 -- Name: groups_unix Type: INDEX
3834 CREATE INDEX groups_unix on groups ( unix_group_name );
3837 -- TOC Entry ID 370 (OID 18140178)
3839 -- Name: groups_type Type: INDEX
3842 CREATE INDEX groups_type on groups ( type );
3845 -- TOC Entry ID 371 (OID 18140178)
3847 -- Name: groups_public Type: INDEX
3850 CREATE INDEX groups_public on groups ( is_public );
3853 -- TOC Entry ID 372 (OID 18140178)
3855 -- Name: groups_status Type: INDEX
3858 CREATE INDEX groups_status on groups ( status );
3861 -- TOC Entry ID 373 (OID 18140319)
3863 -- Name: mail_group_list_group Type: INDEX
3866 CREATE INDEX mail_group_list_group on mail_group_list ( group_id );
3869 -- TOC Entry ID 374 (OID 18140377)
3871 -- Name: news_bytes_group Type: INDEX
3874 CREATE INDEX news_bytes_group on news_bytes ( group_id );
3877 -- TOC Entry ID 375 (OID 18140377)
3879 -- Name: news_bytes_approved Type: INDEX
3882 CREATE INDEX news_bytes_approved on news_bytes ( is_approved );
3885 -- TOC Entry ID 376 (OID 18140377)
3887 -- Name: news_bytes_forum Type: INDEX
3890 CREATE INDEX news_bytes_forum on news_bytes ( forum_id );
3893 -- TOC Entry ID 464 (OID 18140377)
3895 -- Name: news_group_date Type: INDEX
3898 CREATE INDEX news_group_date on news_bytes ( group_id , sf_date );
3901 -- TOC Entry ID 465 (OID 18140377)
3903 -- Name: news_approved_date Type: INDEX
3906 CREATE INDEX news_approved_date on news_bytes ( is_approved , sf_date );
3909 -- TOC Entry ID 377 (OID 18140437)
3911 -- Name: patch_group_id Type: INDEX
3914 CREATE INDEX patch_group_id on patch ( group_id );
3917 -- TOC Entry ID 451 (OID 18140437)
3919 -- Name: patch_groupid_assignedto_status Type: INDEX
3922 CREATE INDEX patch_groupid_assgndto_sts on patch ( group_id , assigned_to , patch_status_id );
3925 -- TOC Entry ID 452 (OID 18140437)
3927 -- Name: patch_groupid_assignedto Type: INDEX
3930 CREATE INDEX patch_groupid_assignedto on patch ( group_id , assigned_to );
3933 -- TOC Entry ID 453 (OID 18140437)
3935 -- Name: patch_groupid_status Type: INDEX
3938 CREATE INDEX patch_groupid_status on patch ( group_id , patch_status_id );
3941 -- TOC Entry ID 378 (OID 18140501)
3943 -- Name: patch_group_group_id Type: INDEX
3946 CREATE INDEX patch_group_group_id on patch_category ( group_id );
3949 -- TOC Entry ID 379 (OID 18140552)
3951 -- Name: patch_history_patch_id Type: INDEX
3954 CREATE INDEX patch_history_patch_id on patch_history ( patch_id );
3957 -- TOC Entry ID 461 (OID 18140656)
3959 -- Name: people_job_group_id Type: INDEX
3962 CREATE INDEX people_job_group_id on people_job ( group_id );
3965 -- TOC Entry ID 380 (OID 18141038)
3967 -- Name: project_assgnd_to_assgnd_to Type: INDEX
3970 CREATE INDEX project_assgnd_to_assgnd_to on project_assigned_to ( assigned_to_id );
3973 -- TOC Entry ID 381 (OID 18141038)
3975 -- Name: project_assigned_to_task_id Type: INDEX
3978 CREATE INDEX project_assigned_to_task_id on project_assigned_to ( project_task_id );
3981 -- TOC Entry ID 382 (OID 18141128)
3983 -- Name: project_is_depndnt_on_tsk_id Type: INDEX
3986 CREATE INDEX project_is_depndnt_on_tsk_id on project_dependencies ( is_dependent_on_task_id );
3989 -- TOC Entry ID 383 (OID 18141128)
3991 -- Name: project_dependencies_task_id Type: INDEX
3994 CREATE INDEX project_dependencies_task_id on project_dependencies ( project_task_id );
3997 -- TOC Entry ID 384 (OID 18141164)
3999 -- Name: project_group_list_group_id Type: INDEX
4002 CREATE INDEX project_group_list_group_id on project_group_list ( group_id );
4005 -- TOC Entry ID 385 (OID 18141218)
4007 -- Name: project_history_task_id Type: INDEX
4010 CREATE INDEX project_history_task_id on project_history ( project_task_id );
4013 -- TOC Entry ID 386 (OID 18141275)
4015 -- Name: project_metric_group Type: INDEX
4018 CREATE INDEX project_metric_group on project_metric ( group_id );
4021 -- TOC Entry ID 387 (OID 18141430)
4023 -- Name: project_task_group_project_id Type: INDEX
4026 CREATE INDEX project_task_group_project_id on project_task ( group_project_id );
4029 -- TOC Entry ID 454 (OID 18141430)
4031 -- Name: projecttask_projid_status Type: INDEX
4034 CREATE INDEX projecttask_projid_status on project_task ( group_project_id , status_id );
4037 -- TOC Entry ID 354 (OID 18141497)
4039 -- Name: projectweeklymetric_ranking Type: INDEX
4042 -- Removed because is not needed because is created in table definition
4043 -- CREATE INDEX projectweeklymetric_ranking on project_weekly_metric ( ranking );
4046 -- TOC Entry ID 388 (OID 18141497)
4048 -- Name: project_metric_weekly_group Type: INDEX
4051 CREATE INDEX project_metric_weekly_group on project_weekly_metric ( group_id );
4054 -- TOC Entry ID 389 (OID 18141514)
4056 -- Name: sf_session_user_id Type: INDEX
4059 CREATE INDEX sf_session_user_id on sf_session ( user_id );
4062 -- TOC Entry ID 390 (OID 18141514)
4064 -- Name: sf_session_time Type: INDEX
4067 CREATE INDEX sf_session_time on sf_session ( time );
4070 -- TOC Entry ID 391 (OID 18141552)
4072 -- Name: snippet_language Type: INDEX
4075 CREATE INDEX snippet_language on snippet ( language );
4078 -- TOC Entry ID 392 (OID 18141552)
4080 -- Name: snippet_category Type: INDEX
4083 CREATE INDEX snippet_category on snippet ( category );
4086 -- TOC Entry ID 393 (OID 18141611)
4088 -- Name: snippet_package_language Type: INDEX
4091 CREATE INDEX snippet_package_language on snippet_package ( language );
4094 -- TOC Entry ID 394 (OID 18141611)
4096 -- Name: snippet_package_category Type: INDEX
4099 CREATE INDEX snippet_package_category on snippet_package ( category );
4102 -- TOC Entry ID 395 (OID 18141666)
4104 -- Name: snippet_package_item_pkg_ver Type: INDEX
4107 CREATE INDEX snippet_package_item_pkg_ver on snippet_package_item ( snippet_package_version_id );
4110 -- TOC Entry ID 396 (OID 18141702)
4112 -- Name: snippet_package_version_pkg_id Type: INDEX
4115 CREATE INDEX snippet_package_version_pkg_id on snippet_package_version ( snippet_package_id );
4118 -- TOC Entry ID 397 (OID 18141757)
4120 -- Name: snippet_version_snippet_id Type: INDEX
4123 CREATE INDEX snippet_version_snippet_id on snippet_version ( snippet_id );
4126 -- TOC Entry ID 398 (OID 18141829)
4128 -- Name: pages_by_day_day Type: INDEX
4131 CREATE INDEX pages_by_day_day on stats_agg_pages_by_day ( day );
4134 -- TOC Entry ID 399 (OID 18141881)
4136 -- Name: stats_agr_filerelease_group_id Type: INDEX
4139 CREATE INDEX stats_agr_filerelease_group_id on stats_agr_filerelease ( group_id );
4142 -- TOC Entry ID 400 (OID 18141881)
4144 -- Name: stats_agr_filerelease_filerelea Type: INDEX
4147 CREATE INDEX stats_agr_filerelease_flrl on stats_agr_filerelease ( filerelease_id );
4150 -- TOC Entry ID 401 (OID 18141896)
4152 -- Name: project_agr_log_group Type: INDEX
4155 CREATE INDEX project_agr_log_group on stats_agr_project ( group_id );
4158 -- TOC Entry ID 402 (OID 18141949)
4160 -- Name: ftpdl_group_id Type: INDEX
4163 CREATE INDEX ftpdl_group_id on stats_ftp_downloads ( group_id );
4166 -- TOC Entry ID 403 (OID 18141949)
4168 -- Name: ftpdl_fid Type: INDEX
4171 CREATE INDEX ftpdl_fid on stats_ftp_downloads ( filerelease_id );
4174 -- TOC Entry ID 404 (OID 18141949)
4176 -- Name: ftpdl_day Type: INDEX
4179 CREATE INDEX ftpdl_day on stats_ftp_downloads ( day );
4182 -- TOC Entry ID 405 (OID 18141966)
4184 -- Name: httpdl_group_id Type: INDEX
4187 CREATE INDEX httpdl_group_id on stats_http_downloads ( group_id );
4190 -- TOC Entry ID 406 (OID 18141966)
4192 -- Name: httpdl_fid Type: INDEX
4195 CREATE INDEX httpdl_fid on stats_http_downloads ( filerelease_id );
4198 -- TOC Entry ID 407 (OID 18141966)
4200 -- Name: httpdl_day Type: INDEX
4203 CREATE INDEX httpdl_day on stats_http_downloads ( day );
4206 -- TOC Entry ID 408 (OID 18141983)
4208 -- Name: archive_project_monthday Type: INDEX
4211 CREATE INDEX archive_project_monthday on stats_project ( month , day );
4214 -- TOC Entry ID 409 (OID 18141983)
4216 -- Name: project_log_group Type: INDEX
4219 CREATE INDEX project_log_group on stats_project ( group_id );
4222 -- TOC Entry ID 410 (OID 18141983)
4224 -- Name: archive_project_week Type: INDEX
4227 CREATE INDEX archive_project_week on stats_project ( week );
4230 -- TOC Entry ID 411 (OID 18141983)
4232 -- Name: archive_project_day Type: INDEX
4235 CREATE INDEX archive_project_day on stats_project ( day );
4238 -- TOC Entry ID 412 (OID 18141983)
4240 -- Name: archive_project_month Type: INDEX
4243 CREATE INDEX archive_project_month on stats_project ( month );
4246 -- TOC Entry ID 413 (OID 18142042)
4248 -- Name: stats_project_tmp_group_id Type: INDEX
4251 CREATE INDEX stats_project_tmp_group_id on stats_project_tmp ( group_id );
4254 -- TOC Entry ID 414 (OID 18142042)
4256 -- Name: project_stats_week Type: INDEX
4259 CREATE INDEX project_stats_week on stats_project_tmp ( week );
4262 -- TOC Entry ID 415 (OID 18142042)
4264 -- Name: project_stats_month Type: INDEX
4267 CREATE INDEX project_stats_month on stats_project_tmp ( month );
4270 -- TOC Entry ID 416 (OID 18142042)
4272 -- Name: project_stats_day Type: INDEX
4275 CREATE INDEX project_stats_day on stats_project_tmp ( day );
4278 -- TOC Entry ID 417 (OID 18142101)
4280 -- Name: stats_site_monthday Type: INDEX
4283 CREATE INDEX stats_site_monthday on stats_site ( month , day );
4286 -- TOC Entry ID 418 (OID 18142101)
4288 -- Name: stats_site_week Type: INDEX
4291 CREATE INDEX stats_site_week on stats_site ( week );
4294 -- TOC Entry ID 419 (OID 18142101)
4296 -- Name: stats_site_day Type: INDEX
4299 CREATE INDEX stats_site_day on stats_site ( day );
4302 -- TOC Entry ID 420 (OID 18142101)
4304 -- Name: stats_site_month Type: INDEX
4307 CREATE INDEX stats_site_month on stats_site ( month );
4310 -- TOC Entry ID 421 (OID 18142150)
4312 -- Name: support_group_id Type: INDEX
4315 CREATE INDEX support_group_id on support ( group_id );
4318 -- TOC Entry ID 448 (OID 18142150)
4320 -- Name: support_groupid_assignedto Type: INDEX
4323 CREATE INDEX support_groupid_assignedto on support ( group_id , assigned_to );
4326 -- TOC Entry ID 449 (OID 18142150)
4328 -- Name: support_groupid_assignedto_stat Type: INDEX
4331 CREATE INDEX support_groupid_assgndto_stt on support ( group_id , assigned_to , support_status_id );
4334 -- TOC Entry ID 450 (OID 18142150)
4336 -- Name: support_groupid_status Type: INDEX
4339 CREATE INDEX support_groupid_status on support ( group_id , support_status_id );
4342 -- TOC Entry ID 422 (OID 18142214)
4344 -- Name: support_canned_response_group_i Type: INDEX
4347 CREATE INDEX support_canned_rspns_grp_i on support_canned_responses ( group_id );
4350 -- TOC Entry ID 423 (OID 18142265)
4352 -- Name: support_group_group_id Type: INDEX
4355 CREATE INDEX support_group_group_id on support_category ( group_id );
4358 -- TOC Entry ID 424 (OID 18142316)
4360 -- Name: support_history_support_id Type: INDEX
4363 CREATE INDEX support_history_support_id on support_history ( support_id );
4366 -- TOC Entry ID 425 (OID 18142372)
4368 -- Name: support_messages_support_id Type: INDEX
4371 CREATE INDEX support_messages_support_id on support_messages ( support_id );
4374 -- TOC Entry ID 426 (OID 18142473)
4376 -- Name: supported_languages_code Type: INDEX
4379 CREATE INDEX supported_languages_code on supported_languages ( language_code );
4382 -- TOC Entry ID 427 (OID 18142573)
4384 -- Name: survey_questions_group Type: INDEX
4387 CREATE INDEX survey_questions_group on survey_questions ( group_id );
4390 -- TOC Entry ID 428 (OID 18142608)
4392 -- Name: survey_rating_aggregate_type_id Type: INDEX
4395 CREATE INDEX survey_rating_aggrgt_typ_id on survey_rating_aggregate ( type , id );
4398 -- TOC Entry ID 429 (OID 18142625)
4400 -- Name: survey_rating_responses_user_ty Type: INDEX
4403 CREATE INDEX survey_rating_rspns_usr_ty on survey_rating_response ( user_id , type , id );
4406 -- TOC Entry ID 430 (OID 18142625)
4408 -- Name: survey_rating_responses_type_id Type: INDEX
4411 CREATE INDEX survey_rating_rspns_typ_id on survey_rating_response ( type , id );
4414 -- TOC Entry ID 431 (OID 18142644)
4416 -- Name: survey_responses_group_id Type: INDEX
4419 CREATE INDEX survey_responses_group_id on survey_responses ( group_id );
4422 -- TOC Entry ID 432 (OID 18142644)
4424 -- Name: survey_responses_user_survey_qu Type: INDEX
4427 CREATE INDEX survey_rspns_usr_srvy_qu on survey_responses ( user_id , survey_id , question_id );
4430 -- TOC Entry ID 433 (OID 18142644)
4432 -- Name: survey_responses_user_survey Type: INDEX
4435 CREATE INDEX survey_responses_user_survey on survey_responses ( user_id , survey_id );
4438 -- TOC Entry ID 434 (OID 18142644)
4440 -- Name: survey_responses_survey_questio Type: INDEX
4443 CREATE INDEX survey_rspns_srvy_quest on survey_responses ( survey_id , question_id );
4446 -- TOC Entry ID 435 (OID 18142698)
4448 -- Name: surveys_group Type: INDEX
4451 CREATE INDEX surveys_group on surveys ( group_id );
4454 -- TOC Entry ID 436 (OID 18143071)
4456 -- Name: rank_forumposts_week_idx Type: INDEX
4459 CREATE INDEX rank_forumposts_week_idx on top_group ( rank_forumposts_week );
4462 -- TOC Entry ID 437 (OID 18143071)
4464 -- Name: rank_downloads_week_idx Type: INDEX
4467 CREATE INDEX rank_downloads_week_idx on top_group ( rank_downloads_week );
4470 -- TOC Entry ID 438 (OID 18143071)
4472 -- Name: pageviews_proj_idx Type: INDEX
4475 CREATE INDEX pageviews_proj_idx on top_group ( pageviews_proj );
4478 -- TOC Entry ID 439 (OID 18143071)
4480 -- Name: rank_userrank_idx Type: INDEX
4483 CREATE INDEX rank_userrank_idx on top_group ( rank_userrank );
4486 -- TOC Entry ID 440 (OID 18143071)
4488 -- Name: rank_downloads_all_idx Type: INDEX
4491 CREATE INDEX rank_downloads_all_idx on top_group ( rank_downloads_all );
4494 -- TOC Entry ID 441 (OID 18143131)
4496 -- Name: parent_idx Type: INDEX
4499 CREATE INDEX parent_idx on trove_cat ( parent );
4502 -- TOC Entry ID 442 (OID 18143131)
4504 -- Name: root_parent_idx Type: INDEX
4507 CREATE INDEX root_parent_idx on trove_cat ( root_parent );
4510 -- TOC Entry ID 443 (OID 18143131)
4512 -- Name: version_idx Type: INDEX
4515 CREATE INDEX version_idx on trove_cat ( version );
4518 -- TOC Entry ID 444 (OID 18143194)
4520 -- Name: trove_group_link_group_id Type: INDEX
4523 CREATE INDEX trove_group_link_group_id on trove_group_link ( group_id );
4526 -- TOC Entry ID 445 (OID 18143194)
4528 -- Name: trove_group_link_cat_id Type: INDEX
4531 CREATE INDEX trove_group_link_cat_id on trove_group_link ( trove_cat_id );
4534 -- TOC Entry ID 446 (OID 18143304)
4536 -- Name: user_bookmark_user_id Type: INDEX
4539 CREATE INDEX user_bookmark_user_id on user_bookmarks ( user_id );
4542 -- TOC Entry ID 304 (OID 18143355)
4544 -- Name: user_diary_user Type: INDEX
4547 CREATE INDEX user_diary_user on user_diary ( user_id );
4550 -- TOC Entry ID 305 (OID 18143355)
4552 -- Name: user_diary_user_date Type: INDEX
4555 CREATE INDEX user_diary_user_date on user_diary ( user_id , date_posted );
4558 -- TOC Entry ID 306 (OID 18143355)
4560 -- Name: user_diary_date Type: INDEX
4563 CREATE INDEX user_diary_date on user_diary ( date_posted );
4566 -- TOC Entry ID 307 (OID 18143410)
4568 -- Name: user_diary_monitor_user Type: INDEX
4571 CREATE INDEX user_diary_monitor_user on user_diary_monitor ( user_id );
4574 -- TOC Entry ID 308 (OID 18143410)
4576 -- Name: user_diary_monitor_monitored_us Type: INDEX
4579 CREATE INDEX user_diary_monitor_mntrd_us on user_diary_monitor ( monitored_user );
4582 -- TOC Entry ID 309 (OID 18143446)
4584 -- Name: user_group_group_id Type: INDEX
4587 CREATE INDEX user_group_group_id on user_group ( group_id );
4590 -- TOC Entry ID 310 (OID 18143446)
4592 -- Name: bug_flags_idx Type: INDEX
4595 CREATE INDEX bug_flags_idx on user_group ( bug_flags );
4598 -- TOC Entry ID 311 (OID 18143446)
4600 -- Name: project_flags_idx Type: INDEX
4603 CREATE INDEX project_flags_idx on user_group ( project_flags );
4606 -- TOC Entry ID 312 (OID 18143446)
4608 -- Name: user_group_user_id Type: INDEX
4611 CREATE INDEX user_group_user_id on user_group ( user_id );
4614 -- TOC Entry ID 313 (OID 18143446)
4616 -- Name: admin_flags_idx Type: INDEX
4619 CREATE INDEX admin_flags_idx on user_group ( admin_flags );
4622 -- TOC Entry ID 314 (OID 18143446)
4624 -- Name: forum_flags_idx Type: INDEX
4627 CREATE INDEX forum_flags_idx on user_group ( forum_flags );
4630 -- TOC Entry ID 315 (OID 18143548)
4632 -- Name: user_metric0_user_id Type: INDEX
4635 CREATE INDEX user_metric0_user_id on user_metric0 ( user_id );
4638 -- TOC Entry ID 455 (OID 18143576)
4640 -- Name: user_pref_user_id Type: INDEX
4643 CREATE INDEX user_pref_user_id on user_preferences ( user_id );
4646 -- TOC Entry ID 456 (OID 18143591)
4648 -- Name: user_ratings_rated_by Type: INDEX
4651 CREATE INDEX user_ratings_rated_by on user_ratings ( rated_by );
4654 -- TOC Entry ID 457 (OID 18143591)
4656 -- Name: user_ratings_user_id Type: INDEX
4659 CREATE INDEX user_ratings_user_id on user_ratings ( user_id );
4662 -- TOC Entry ID 447 (OID 18143626)
4664 -- Name: users_status Type: INDEX
4667 CREATE INDEX users_status on users ( status );
4670 -- TOC Entry ID 458 (OID 18143626)
4672 -- Name: user_user Type: INDEX
4675 -- Removed because is not needed because is created in table definition
4676 -- CREATE INDEX user_user on users ( status );
4679 -- TOC Entry ID 459 (OID 18143626)
4681 -- Name: idx_users_username Type: INDEX
4684 CREATE INDEX idx_users_username on users ( user_name );
4687 -- TOC Entry ID 462 (OID 18143626)
4689 -- Name: users_user_pw Type: INDEX
4692 CREATE INDEX users_user_pw on users ( user_pw );
4695 -- TOC Entry ID 460 (OID 27311451)
4697 -- Name: troveagg_trovecatid Type: INDEX
4700 CREATE INDEX troveagg_trovecatid on trove_agg ( trove_cat_id );
4703 -- TOC Entry ID 536 (OID 27311269)
4705 -- Name: RI_ConstraintTrigger_27311268 Type: TRIGGER
4708 -- CREATE CONSTRAINT TRIGGER user_group_user_id_fk AFTER INSERT OR UPdate ON user_group NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins ('user_group_user_id_fk', 'user_group', 'users', 'FULL', 'user_id', 'user_id');
4711 -- TOC Entry ID 537 (OID 27311271)
4713 -- Name: RI_ConstraintTrigger_27311270 Type: TRIGGER
4716 -- CREATE CONSTRAINT TRIGGER user_group_user_id_fk AFTER DELETE ON users NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del ('user_group_user_id_fk', 'user_group', 'users', 'FULL', 'user_id', 'user_id');
4719 -- TOC Entry ID 538 (OID 27311273)
4721 -- Name: RI_ConstraintTrigger_27311272 Type: TRIGGER
4724 -- CREATE CONSTRAINT TRIGGER user_group_user_id_fk AFTER UPdate ON users NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd ('user_group_user_id_fk', 'user_group', 'users', 'FULL', 'user_id', 'user_id');
4727 -- TOC Entry ID 535 (OID 27311275)
4729 -- Name: RI_ConstraintTrigger_27311274 Type: TRIGGER
4732 -- CREATE CONSTRAINT TRIGGER user_group_group_id_fk AFTER INSERT OR UPDATE ON user_group NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins ('user_group_group_id_fk', 'user_group', 'groups', 'FULL', 'group_id', 'group_id');
4735 -- TOC Entry ID 506 (OID 27311277)
4737 -- Name: RI_ConstraintTrigger_27311276 Type: TRIGGER
4740 -- CREATE CONSTRAINT TRIGGER user_group_group_id_fk AFTER DELETE ON groups NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del ('user_group_group_id_fk', 'user_group', 'groups', 'FULL', 'group_id', 'group_id');
4743 -- TOC Entry ID 505 (OID 27311279)
4745 -- Name: RI_ConstraintTrigger_27311278 Type: TRIGGER
4748 -- CREATE CONSTRAINT TRIGGER user_group_group_id_fk AFTER UPDATE ON groups NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd ('user_group_group_id_fk', 'user_group', 'groups', 'FULL', 'group_id', 'group_id');
4751 -- TOC Entry ID 487 (OID 27311281)
4753 -- Name: RI_ConstraintTrigger_27311280 Type: TRIGGER
4756 -- CREATE CONSTRAINT TRIGGER forum_posted_by_fk AFTER INSERT OR UPDATE ON forum NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins ('forum_posted_by_fk', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
4759 -- TOC Entry ID 539 (OID 27311283)
4761 -- Name: RI_ConstraintTrigger_27311282 Type: TRIGGER
4764 -- CREATE CONSTRAINT TRIGGER forum_posted_by_fk AFTER DELETE ON users NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del ('forum_posted_by_fk', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
4767 -- TOC Entry ID 540 (OID 27311285)
4769 -- Name: RI_ConstraintTrigger_27311284 Type: TRIGGER
4772 -- CREATE CONSTRAINT TRIGGER forum_posted_by_fk AFTER UPDATE ON users NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd ('forum_posted_by_fk', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
4775 -- TOC Entry ID 486 (OID 27311287)
4777 -- Name: RI_ConstraintTrigger_27311286 Type: TRIGGER
4780 -- CREATE CONSTRAINT TRIGGER forum_group_forum_id_fk AFTER INSERT OR UPDATE ON forum NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins ('forum_group_forum_id_fk', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
4783 -- TOC Entry ID 492 (OID 27311289)
4785 -- Name: RI_ConstraintTrigger_27311288 Type: TRIGGER
4788 -- CREATE CONSTRAINT TRIGGER forum_group_forum_id_fk AFTER DELETE ON forum_group_list NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del ('forum_group_forum_id_fk', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
4791 -- TOC Entry ID 491 (OID 27311291)
4793 -- Name: RI_ConstraintTrigger_27311290 Type: TRIGGER
4796 -- CREATE CONSTRAINT TRIGGER forum_group_forum_id_fk AFTER UPDATE ON forum_group_list NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd ('forum_group_forum_id_fk', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
4799 -- TOC Entry ID 490 (OID 27311293)
4801 -- Name: RI_ConstraintTrigger_27311292 Type: TRIGGER
4804 -- CREATE CONSTRAINT TRIGGER forum_group_list_group_id_fk AFTER INSERT OR UPDATE ON forum_group_list NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins ('forum_group_list_group_id_fk', 'forum_group_list', 'groups', 'FULL', 'group_id', 'group_id');
4807 -- TOC Entry ID 504 (OID 27311295)
4809 -- Name: RI_ConstraintTrigger_27311294 Type: TRIGGER
4812 -- CREATE CONSTRAINT TRIGGER forum_group_list_group_id_fk AFTER DELETE ON groups NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del ('forum_group_list_group_id_fk', 'forum_group_list', 'groups', 'FULL', 'group_id', 'group_id');
4815 -- TOC Entry ID 503 (OID 27311297)
4817 -- Name: RI_ConstraintTrigger_27311296 Type: TRIGGER
4820 -- CREATE CONSTRAINT TRIGGER forum_group_list_group_id_fk AFTER UPDATE ON groups NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd ('forum_group_list_group_id_fk', 'forum_group_list', 'groups', 'FULL', 'group_id', 'group_id');
4823 -- TOC Entry ID 479 (OID 27311299)
4825 -- Name: RI_ConstraintTrigger_27311298 Type: TRIGGER
4828 -- CREATE CONSTRAINT TRIGGER bug_group_group_fk AFTER INSERT OR UPDATE ON bug_group NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins ('bug_group_group_fk', 'bug_group', 'groups', 'FULL', 'group_id', 'group_id');
4831 -- TOC Entry ID 502 (OID 27311301)
4833 -- Name: RI_ConstraintTrigger_27311300 Type: TRIGGER
4836 -- CREATE CONSTRAINT TRIGGER bug_group_group_fk AFTER DELETE ON groups NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del ('bug_group_group_fk', 'bug_group', 'groups', 'FULL', 'group_id', 'group_id');
4839 -- TOC Entry ID 501 (OID 27311303)
4841 -- Name: RI_ConstraintTrigger_27311302 Type: TRIGGER
4844 -- CREATE CONSTRAINT TRIGGER bug_group_group_fk AFTER UPDATE ON groups NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd ('bug_group_group_fk', 'bug_group', 'groups', 'FULL', 'group_id', 'group_id');
4847 -- TOC Entry ID 476 (OID 27311305)
4849 -- Name: RI_ConstraintTrigger_27311304 Type: TRIGGER
4852 -- CREATE CONSTRAINT TRIGGER bug_category_group_fk AFTER INSERT OR UPDATE ON bug_category NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins ('bug_category_group_fk', 'bug_category', 'groups', 'FULL', 'group_id', 'group_id');
4855 -- TOC Entry ID 500 (OID 27311307)
4857 -- Name: RI_ConstraintTrigger_27311306 Type: TRIGGER
4860 -- CREATE CONSTRAINT TRIGGER bug_category_group_fk AFTER DELETE ON groups NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del ('bug_category_group_fk', 'bug_category', 'groups', 'FULL', 'group_id', 'group_id');
4863 -- TOC Entry ID 499 (OID 27311309)
4865 -- Name: RI_ConstraintTrigger_27311308 Type: TRIGGER
4868 -- CREATE CONSTRAINT TRIGGER bug_category_group_fk AFTER UPDATE ON groups NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd ('bug_category_group_fk', 'bug_category', 'groups', 'FULL', 'group_id', 'group_id');
4871 -- TOC Entry ID 473 (OID 27311311)
4873 -- Name: RI_ConstraintTrigger_27311310 Type: TRIGGER
4876 -- CREATE CONSTRAINT TRIGGER bug_submitted_by_fk AFTER INSERT OR UPDATE ON bug NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins ('bug_submitted_by_fk', 'bug', 'users', 'FULL', 'submitted_by', 'user_id');
4879 -- TOC Entry ID 541 (OID 27311313)
4881 -- Name: RI_ConstraintTrigger_27311312 Type: TRIGGER
4884 -- CREATE CONSTRAINT TRIGGER bug_submitted_by_fk AFTER DELETE ON users NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del ('bug_submitted_by_fk', 'bug', 'users', 'FULL', 'submitted_by', 'user_id');
4887 -- TOC Entry ID 542 (OID 27311315)
4889 -- Name: RI_ConstraintTrigger_27311314 Type: TRIGGER
4892 -- CREATE CONSTRAINT TRIGGER bug_submitted_by_fk AFTER UPDATE ON users NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd ('bug_submitted_by_fk', 'bug', 'users', 'FULL', 'submitted_by', 'user_id');
4895 -- TOC Entry ID 472 (OID 27311317)
4897 -- Name: RI_ConstraintTrigger_27311316 Type: TRIGGER
4900 -- CREATE CONSTRAINT TRIGGER bug_assigned_to_fk AFTER INSERT OR UPDATE ON bug NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins ('bug_assigned_to_fk', 'bug', 'users', 'FULL', 'assigned_to', 'user_id');
4903 -- TOC Entry ID 543 (OID 27311319)
4905 -- Name: RI_ConstraintTrigger_27311318 Type: TRIGGER
4908 -- CREATE CONSTRAINT TRIGGER bug_assigned_to_fk AFTER DELETE ON users NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del ('bug_assigned_to_fk', 'bug', 'users', 'FULL', 'assigned_to', 'user_id');
4911 -- TOC Entry ID 544 (OID 27311321)
4913 -- Name: RI_ConstraintTrigger_27311320 Type: TRIGGER
4916 -- CREATE CONSTRAINT TRIGGER bug_assigned_to_fk AFTER UPDATE ON users NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd ('bug_assigned_to_fk', 'bug', 'users', 'FULL', 'assigned_to', 'user_id');
4919 -- TOC Entry ID 471 (OID 27311323)
4921 -- Name: RI_ConstraintTrigger_27311322 Type: TRIGGER
4924 -- CREATE CONSTRAINT TRIGGER bug_status_fk AFTER INSERT OR UPDATE ON bug NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins ('bug_status_fk', 'bug', 'bug_status', 'FULL', 'status_id', 'status_id');
4927 -- TOC Entry ID 483 (OID 27311325)
4929 -- Name: RI_ConstraintTrigger_27311324 Type: TRIGGER
4932 -- CREATE CONSTRAINT TRIGGER bug_status_fk AFTER DELETE ON bug_status NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del ('bug_status_fk', 'bug', 'bug_status', 'FULL', 'status_id', 'status_id');
4935 -- TOC Entry ID 482 (OID 27311327)
4937 -- Name: RI_ConstraintTrigger_27311326 Type: TRIGGER
4940 -- CREATE CONSTRAINT TRIGGER bug_status_fk AFTER UPDATE ON bug_status NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd ('bug_status_fk', 'bug', 'bug_status', 'FULL', 'status_id', 'status_id');
4943 -- TOC Entry ID 470 (OID 27311329)
4945 -- Name: RI_ConstraintTrigger_27311328 Type: TRIGGER
4948 -- CREATE CONSTRAINT TRIGGER bug_category_fk AFTER INSERT OR UPDATE ON bug NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins ('bug_category_fk', 'bug', 'bug_category', 'FULL', 'category_id', 'bug_category_id');
4951 -- TOC Entry ID 475 (OID 27311331)
4953 -- Name: RI_ConstraintTrigger_27311330 Type: TRIGGER
4956 -- CREATE CONSTRAINT TRIGGER bug_category_fk AFTER DELETE ON bug_category NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del ('bug_category_fk', 'bug', 'bug_category', 'FULL', 'category_id', 'bug_category_id');
4959 -- TOC Entry ID 474 (OID 27311333)
4961 -- Name: RI_ConstraintTrigger_27311332 Type: TRIGGER
4964 -- CREATE CONSTRAINT TRIGGER bug_category_fk AFTER UPDATE ON bug_category NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd ('bug_category_fk', 'bug', 'bug_category', 'FULL', 'category_id', 'bug_category_id');
4967 -- TOC Entry ID 469 (OID 27311335)
4969 -- Name: RI_ConstraintTrigger_27311334 Type: TRIGGER
4972 -- CREATE CONSTRAINT TRIGGER bug_resolution_fk AFTER INSERT OR UPDATE ON bug NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins ('bug_resolution_fk', 'bug', 'bug_resolution', 'FULL', 'resolution_id', 'resolution_id');
4975 -- TOC Entry ID 481 (OID 27311337)
4977 -- Name: RI_ConstraintTrigger_27311336 Type: TRIGGER
4980 -- CREATE CONSTRAINT TRIGGER bug_resolution_fk AFTER DELETE ON bug_resolution NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del ('bug_resolution_fk', 'bug', 'bug_resolution', 'FULL', 'resolution_id', 'resolution_id');
4983 -- TOC Entry ID 480 (OID 27311339)
4985 -- Name: RI_ConstraintTrigger_27311338 Type: TRIGGER
4988 -- CREATE CONSTRAINT TRIGGER bug_resolution_fk AFTER UPDATE ON bug_resolution NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd ('bug_resolution_fk', 'bug', 'bug_resolution', 'FULL', 'resolution_id', 'resolution_id');
4991 -- TOC Entry ID 468 (OID 27311341)
4993 -- Name: RI_ConstraintTrigger_27311340 Type: TRIGGER
4996 -- CREATE CONSTRAINT TRIGGER bug_group_fk AFTER INSERT OR UPDATE ON bug NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins ('bug_group_fk', 'bug', 'bug_group', 'FULL', 'bug_group_id', 'bug_group_id');
4999 -- TOC Entry ID 478 (OID 27311343)
5001 -- Name: RI_ConstraintTrigger_27311342 Type: TRIGGER
5004 -- CREATE CONSTRAINT TRIGGER bug_group_fk AFTER DELETE ON bug_group NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del ('bug_group_fk', 'bug', 'bug_group', 'FULL', 'bug_group_id', 'bug_group_id');
5007 -- TOC Entry ID 477 (OID 27311345)
5009 -- Name: RI_ConstraintTrigger_27311344 Type: TRIGGER
5012 -- CREATE CONSTRAINT TRIGGER bug_group_fk AFTER UPDATE ON bug_group NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd ('bug_group_fk', 'bug', 'bug_group', 'FULL', 'bug_group_id', 'bug_group_id');
5015 -- TOC Entry ID 485 (OID 27311347)
5017 -- Name: RI_ConstraintTrigger_27311346 Type: TRIGGER
5020 -- CREATE CONSTRAINT TRIGGER forum_posted_by_fk AFTER INSERT OR UPDATE ON forum NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins ('forum_posted_by_fk', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
5023 -- TOC Entry ID 545 (OID 27311349)
5025 -- Name: RI_ConstraintTrigger_27311348 Type: TRIGGER
5028 -- CREATE CONSTRAINT TRIGGER forum_posted_by_fk AFTER DELETE ON users NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del ('forum_posted_by_fk', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
5031 -- TOC Entry ID 546 (OID 27311351)
5033 -- Name: RI_ConstraintTrigger_27311350 Type: TRIGGER
5036 -- CREATE CONSTRAINT TRIGGER forum_posted_by_fk AFTER UPDATE ON users NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd ('forum_posted_by_fk', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
5039 -- TOC Entry ID 484 (OID 27311353)
5041 -- Name: RI_ConstraintTrigger_27311352 Type: TRIGGER
5044 -- CREATE CONSTRAINT TRIGGER forum_group_forum_id_fk AFTER INSERT OR UPDATE ON forum NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins ('forum_group_forum_id_fk', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
5047 -- TOC Entry ID 489 (OID 27311355)
5049 -- Name: RI_ConstraintTrigger_27311354 Type: TRIGGER
5052 -- CREATE CONSTRAINT TRIGGER forum_group_forum_id_fk AFTER DELETE ON forum_group_list NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del ('forum_group_forum_id_fk', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
5055 -- TOC Entry ID 488 (OID 27311357)
5057 -- Name: RI_ConstraintTrigger_27311356 Type: TRIGGER
5060 -- CREATE CONSTRAINT TRIGGER forum_group_forum_id_fk AFTER UPDATE ON forum_group_list NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd ('forum_group_forum_id_fk', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
5063 -- TOC Entry ID 518 (OID 27311359)
5065 -- Name: RI_ConstraintTrigger_27311358 Type: TRIGGER
5068 -- CREATE CONSTRAINT TRIGGER project_group_list_group_id_fk AFTER INSERT OR UPDATE ON project_group_list NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins ('project_group_list_group_id_fk', 'project_group_list', 'groups', 'FULL', 'group_id', 'group_id');
5071 -- TOC Entry ID 498 (OID 27311361)
5073 -- Name: RI_ConstraintTrigger_27311360 Type: TRIGGER
5076 -- CREATE CONSTRAINT TRIGGER project_group_list_group_id_fk AFTER DELETE ON groups NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del ('project_group_list_group_id_fk', 'project_group_list', 'groups', 'FULL', 'group_id', 'group_id');
5079 -- TOC Entry ID 497 (OID 27311363)
5081 -- Name: RI_ConstraintTrigger_27311362 Type: TRIGGER
5084 -- CREATE CONSTRAINT TRIGGER project_group_list_group_id_fk AFTER UPDATE ON groups NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd ('project_group_list_group_id_fk', 'project_group_list', 'groups', 'FULL', 'group_id', 'group_id');
5087 -- TOC Entry ID 523 (OID 27311365)
5089 -- Name: RI_ConstraintTrigger_27311364 Type: TRIGGER
5092 -- CREATE CONSTRAINT TRIGGER project_task_group_project_id_f AFTER INSERT OR UPDATE ON project_task NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins ('project_task_group_project_id_f', 'project_task', 'project_group_list', 'FULL', 'group_project_id', 'group_project_id');
5095 -- TOC Entry ID 517 (OID 27311367)
5097 -- Name: RI_ConstraintTrigger_27311366 Type: TRIGGER
5100 -- CREATE CONSTRAINT TRIGGER project_task_group_project_id_f AFTER DELETE ON project_group_list NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del ('project_task_group_project_id_f', 'project_task', 'project_group_list', 'FULL', 'group_project_id', 'group_project_id');
5103 -- TOC Entry ID 516 (OID 27311369)
5105 -- Name: RI_ConstraintTrigger_27311368 Type: TRIGGER
5108 -- CREATE CONSTRAINT TRIGGER project_task_group_project_id_f AFTER UPDATE ON project_group_list NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd ('project_task_group_project_id_f', 'project_task', 'project_group_list', 'FULL', 'group_project_id', 'group_project_id');
5111 -- TOC Entry ID 522 (OID 27311371)
5113 -- Name: RI_ConstraintTrigger_27311370 Type: TRIGGER
5116 -- CREATE CONSTRAINT TRIGGER project_task_created_by_fk AFTER INSERT OR UPDATE ON project_task NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins ('project_task_created_by_fk', 'project_task', 'users', 'FULL', 'created_by', 'user_id');
5119 -- TOC Entry ID 547 (OID 27311373)
5121 -- Name: RI_ConstraintTrigger_27311372 Type: TRIGGER
5124 -- CREATE CONSTRAINT TRIGGER project_task_created_by_fk AFTER DELETE ON users NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del ('project_task_created_by_fk', 'project_task', 'users', 'FULL', 'created_by', 'user_id');
5127 -- TOC Entry ID 548 (OID 27311375)
5129 -- Name: RI_ConstraintTrigger_27311374 Type: TRIGGER
5132 -- CREATE CONSTRAINT TRIGGER project_task_created_by_fk AFTER UPDATE ON users NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd ('project_task_created_by_fk', 'project_task', 'users', 'FULL', 'created_by', 'user_id');
5135 -- TOC Entry ID 521 (OID 27311377)
5137 -- Name: RI_ConstraintTrigger_27311376 Type: TRIGGER
5140 -- CREATE CONSTRAINT TRIGGER project_task_status_id_fk AFTER INSERT OR UPDATE ON project_task NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins ('project_task_status_id_fk', 'project_task', 'project_status', 'FULL', 'status_id', 'status_id');
5143 -- TOC Entry ID 520 (OID 27311379)
5145 -- Name: RI_ConstraintTrigger_27311378 Type: TRIGGER
5148 -- CREATE CONSTRAINT TRIGGER project_task_status_id_fk AFTER DELETE ON project_status NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del ('project_task_status_id_fk', 'project_task', 'project_status', 'FULL', 'status_id', 'status_id');
5151 -- TOC Entry ID 519 (OID 27311381)
5153 -- Name: RI_ConstraintTrigger_27311380 Type: TRIGGER
5156 -- CREATE CONSTRAINT TRIGGER project_task_status_id_fk AFTER UPDATE ON project_status NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd ('project_task_status_id_fk', 'project_task', 'project_status', 'FULL', 'status_id', 'status_id');
5159 -- TOC Entry ID 510 (OID 27311383)
5161 -- Name: RI_ConstraintTrigger_27311382 Type: TRIGGER
5164 -- CREATE CONSTRAINT TRIGGER patch_status_id_fk AFTER INSERT OR UPDATE ON patch NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins ('patch_status_id_fk', 'patch', 'patch_status', 'FULL', 'patch_status_id', 'patch_status_id');
5167 -- TOC Entry ID 515 (OID 27311385)
5169 -- Name: RI_ConstraintTrigger_27311384 Type: TRIGGER
5172 -- CREATE CONSTRAINT TRIGGER patch_status_id_fk AFTER DELETE ON patch_status NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del ('patch_status_id_fk', 'patch', 'patch_status', 'FULL', 'patch_status_id', 'patch_status_id');
5175 -- TOC Entry ID 514 (OID 27311387)
5177 -- Name: RI_ConstraintTrigger_27311386 Type: TRIGGER
5180 -- CREATE CONSTRAINT TRIGGER patch_status_id_fk AFTER UPDATE ON patch_status NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd ('patch_status_id_fk', 'patch', 'patch_status', 'FULL', 'patch_status_id', 'patch_status_id');
5183 -- TOC Entry ID 509 (OID 27311389)
5185 -- Name: RI_ConstraintTrigger_27311388 Type: TRIGGER
5188 -- CREATE CONSTRAINT TRIGGER patch_category_id_fk AFTER INSERT OR UPDATE ON patch NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins ('patch_category_id_fk', 'patch', 'patch_category', 'FULL', 'patch_category_id', 'patch_category_id');
5191 -- TOC Entry ID 513 (OID 27311391)
5193 -- Name: RI_ConstraintTrigger_27311390 Type: TRIGGER
5196 -- CREATE CONSTRAINT TRIGGER patch_category_id_fk AFTER DELETE ON patch_category NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del ('patch_category_id_fk', 'patch', 'patch_category', 'FULL', 'patch_category_id', 'patch_category_id');
5199 -- TOC Entry ID 512 (OID 27311393)
5201 -- Name: RI_ConstraintTrigger_27311392 Type: TRIGGER
5204 -- CREATE CONSTRAINT TRIGGER patch_category_id_fk AFTER UPDATE ON patch_category NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd ('patch_category_id_fk', 'patch', 'patch_category', 'FULL', 'patch_category_id', 'patch_category_id');
5207 -- TOC Entry ID 508 (OID 27311395)
5209 -- Name: RI_ConstraintTrigger_27311394 Type: TRIGGER
5212 -- CREATE CONSTRAINT TRIGGER patch_submitted_by_fk AFTER INSERT OR UPDATE ON patch NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins ('patch_submitted_by_fk', 'patch', 'users', 'FULL', 'submitted_by', 'user_id');
5215 -- TOC Entry ID 549 (OID 27311397)
5217 -- Name: RI_ConstraintTrigger_27311396 Type: TRIGGER
5220 -- CREATE CONSTRAINT TRIGGER patch_submitted_by_fk AFTER DELETE ON users NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del ('patch_submitted_by_fk', 'patch', 'users', 'FULL', 'submitted_by', 'user_id');
5223 -- TOC Entry ID 550 (OID 27311399)
5225 -- Name: RI_ConstraintTrigger_27311398 Type: TRIGGER
5228 -- CREATE CONSTRAINT TRIGGER patch_submitted_by_fk AFTER UPDATE ON users NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd ('patch_submitted_by_fk', 'patch', 'users', 'FULL', 'submitted_by', 'user_id');
5231 -- TOC Entry ID 507 (OID 27311401)
5233 -- Name: RI_ConstraintTrigger_27311400 Type: TRIGGER
5236 -- CREATE CONSTRAINT TRIGGER patch_assigned_to_fk AFTER INSERT OR UPDATE ON patch NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins ('patch_assigned_to_fk', 'patch', 'users', 'FULL', 'assigned_to', 'user_id');
5239 -- TOC Entry ID 551 (OID 27311403)
5241 -- Name: RI_ConstraintTrigger_27311402 Type: TRIGGER
5244 -- CREATE CONSTRAINT TRIGGER patch_assigned_to_fk AFTER DELETE ON users NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del ('patch_assigned_to_fk', 'patch', 'users', 'FULL', 'assigned_to', 'user_id');
5247 -- TOC Entry ID 552 (OID 27311405)
5249 -- Name: RI_ConstraintTrigger_27311404 Type: TRIGGER
5252 -- CREATE CONSTRAINT TRIGGER patch_assigned_to_fk AFTER UPDATE ON users NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd ('patch_assigned_to_fk', 'patch', 'users', 'FULL', 'assigned_to', 'user_id');
5255 -- TOC Entry ID 511 (OID 27311407)
5257 -- Name: RI_ConstraintTrigger_27311406 Type: TRIGGER
5260 -- CREATE CONSTRAINT TRIGGER patch_category_group_id_fk AFTER INSERT OR UPDATE ON patch_category NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins ('patch_category_group_id_fk', 'patch_category', 'groups', 'FULL', 'group_id', 'group_id');
5263 -- TOC Entry ID 496 (OID 27311409)
5265 -- Name: RI_ConstraintTrigger_27311408 Type: TRIGGER
5268 -- CREATE CONSTRAINT TRIGGER patch_category_group_id_fk AFTER DELETE ON groups NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del ('patch_category_group_id_fk', 'patch_category', 'groups', 'FULL', 'group_id', 'group_id');
5271 -- TOC Entry ID 495 (OID 27311411)
5273 -- Name: RI_ConstraintTrigger_27311410 Type: TRIGGER
5276 -- CREATE CONSTRAINT TRIGGER patch_category_group_id_fk AFTER UPDATE ON groups NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd ('patch_category_group_id_fk', 'patch_category', 'groups', 'FULL', 'group_id', 'group_id');
5279 -- TOC Entry ID 527 (OID 27311413)
5281 -- Name: RI_ConstraintTrigger_27311412 Type: TRIGGER
5284 -- CREATE CONSTRAINT TRIGGER support_status_id_fk AFTER INSERT OR UPDATE ON support NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins ('support_status_id_fk', 'support', 'support_status', 'FULL', 'support_status_id', 'support_status_id');
5287 -- TOC Entry ID 532 (OID 27311415)
5289 -- Name: RI_ConstraintTrigger_27311414 Type: TRIGGER
5292 -- CREATE CONSTRAINT TRIGGER support_status_id_fk AFTER DELETE ON support_status NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del ('support_status_id_fk', 'support', 'support_status', 'FULL', 'support_status_id', 'support_status_id');
5295 -- TOC Entry ID 531 (OID 27311417)
5297 -- Name: RI_ConstraintTrigger_27311416 Type: TRIGGER
5300 -- CREATE CONSTRAINT TRIGGER support_status_id_fk AFTER UPDATE ON support_status NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd ('support_status_id_fk', 'support', 'support_status', 'FULL', 'support_status_id', 'support_status_id');
5303 -- TOC Entry ID 526 (OID 27311419)
5305 -- Name: RI_ConstraintTrigger_27311418 Type: TRIGGER
5308 -- CREATE CONSTRAINT TRIGGER support_category_id_fk AFTER INSERT OR UPDATE ON support NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins ('support_category_id_fk', 'support', 'support_category', 'FULL', 'support_category_id', 'support_category_id');
5311 -- TOC Entry ID 530 (OID 27311421)
5313 -- Name: RI_ConstraintTrigger_27311420 Type: TRIGGER
5316 -- CREATE CONSTRAINT TRIGGER support_category_id_fk AFTER DELETE ON support_category NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del ('support_category_id_fk', 'support', 'support_category', 'FULL', 'support_category_id', 'support_category_id');
5319 -- TOC Entry ID 529 (OID 27311423)
5321 -- Name: RI_ConstraintTrigger_27311422 Type: TRIGGER
5324 -- CREATE CONSTRAINT TRIGGER support_category_id_fk AFTER UPDATE ON support_category NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd ('support_category_id_fk', 'support', 'support_category', 'FULL', 'support_category_id', 'support_category_id');
5327 -- TOC Entry ID 525 (OID 27311425)
5329 -- Name: RI_ConstraintTrigger_27311424 Type: TRIGGER
5332 -- CREATE CONSTRAINT TRIGGER support_submitted_by_fk AFTER INSERT OR UPDATE ON support NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins ('support_submitted_by_fk', 'support', 'users', 'FULL', 'submitted_by', 'user_id');
5335 -- TOC Entry ID 553 (OID 27311427)
5337 -- Name: RI_ConstraintTrigger_27311426 Type: TRIGGER
5340 -- CREATE CONSTRAINT TRIGGER support_submitted_by_fk AFTER DELETE ON users NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del ('support_submitted_by_fk', 'support', 'users', 'FULL', 'submitted_by', 'user_id');
5343 -- TOC Entry ID 554 (OID 27311429)
5345 -- Name: RI_ConstraintTrigger_27311428 Type: TRIGGER
5348 -- CREATE CONSTRAINT TRIGGER support_submitted_by_fk AFTER UPDATE ON users NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd ('support_submitted_by_fk', 'support', 'users', 'FULL', 'submitted_by', 'user_id');
5351 -- TOC Entry ID 524 (OID 27311431)
5353 -- Name: RI_ConstraintTrigger_27311430 Type: TRIGGER
5356 -- CREATE CONSTRAINT TRIGGER support_assigned_to_fk AFTER INSERT OR UPDATE ON support NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins ('support_assigned_to_fk', 'support', 'users', 'FULL', 'assigned_to', 'user_id');
5359 -- TOC Entry ID 555 (OID 27311433)
5361 -- Name: RI_ConstraintTrigger_27311432 Type: TRIGGER
5364 -- CREATE CONSTRAINT TRIGGER support_assigned_to_fk AFTER DELETE ON users NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del ('support_assigned_to_fk', 'support', 'users', 'FULL', 'assigned_to', 'user_id');
5367 -- TOC Entry ID 556 (OID 27311435)
5369 -- Name: RI_ConstraintTrigger_27311434 Type: TRIGGER
5372 -- CREATE CONSTRAINT TRIGGER support_assigned_to_fk AFTER UPDATE ON users NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd ('support_assigned_to_fk', 'support', 'users', 'FULL', 'assigned_to', 'user_id');
5375 -- TOC Entry ID 528 (OID 27311437)
5377 -- Name: RI_ConstraintTrigger_27311436 Type: TRIGGER
5380 -- CREATE CONSTRAINT TRIGGER support_category_group_id_fk AFTER INSERT OR UPDATE ON support_category NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins ('support_category_group_id_fk', 'support_category', 'groups', 'FULL', 'group_id', 'group_id');
5383 -- TOC Entry ID 494 (OID 27311439)
5385 -- Name: RI_ConstraintTrigger_27311438 Type: TRIGGER
5388 -- CREATE CONSTRAINT TRIGGER support_category_group_id_fk AFTER DELETE ON groups NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del ('support_category_group_id_fk', 'support_category', 'groups', 'FULL', 'group_id', 'group_id');
5391 -- TOC Entry ID 493 (OID 27311441)
5393 -- Name: RI_ConstraintTrigger_27311440 Type: TRIGGER
5396 -- CREATE CONSTRAINT TRIGGER support_category_group_id_fk AFTER UPDATE ON groups NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd ('support_category_group_id_fk', 'support_category', 'groups', 'FULL', 'group_id', 'group_id');
5399 -- TOC Entry ID 557 (OID 27311443)
5401 -- Name: RI_ConstraintTrigger_27311442 Type: TRIGGER
5404 -- CREATE CONSTRAINT TRIGGER users_languageid_fk AFTER INSERT OR UPDATE ON users NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins ('users_languageid_fk', 'users', 'supported_languages', 'FULL', 'language', 'language_id');
5407 -- TOC Entry ID 534 (OID 27311445)
5409 -- Name: RI_ConstraintTrigger_27311444 Type: TRIGGER
5412 -- CREATE CONSTRAINT TRIGGER users_languageid_fk AFTER DELETE ON supported_languages NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del ('users_languageid_fk', 'users', 'supported_languages', 'FULL', 'language', 'language_id');
5415 -- TOC Entry ID 533 (OID 27311447)
5417 -- Name: RI_ConstraintTrigger_27311446 Type: TRIGGER
5420 -- CREATE CONSTRAINT TRIGGER users_languageid_fk AFTER UPDATE ON supported_languages NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd ('users_languageid_fk', 'users', 'supported_languages', 'FULL', 'language', 'language_id');
5423 -- TOC Entry ID 3 (OID 18138427)
5425 -- Name: bug_pk_seq Type: SEQUENCE SET Owner:
5428 -- SELECT setval ('bug_pk_seq', 125359, 't');
5431 -- TOC Entry ID 5 (OID 18138495)
5433 -- Name: bug_bug_dependencies_pk_seq Type: SEQUENCE SET Owner:
5436 -- SELECT setval ('bug_bug_dependencies_pk_seq', 44691, 't');
5439 -- TOC Entry ID 7 (OID 18138531)
5441 -- Name: bug_canned_responses_pk_seq Type: SEQUENCE SET Owner:
5444 -- SELECT setval ('bug_canned_responses_pk_seq', 100204, 't');
5447 -- TOC Entry ID 9 (OID 18138582)
5449 -- Name: bug_category_pk_seq Type: SEQUENCE SET Owner:
5452 -- SELECT setval ('bug_category_pk_seq', 5053, 't');
5455 -- TOC Entry ID 11 (OID 18138632)
5457 -- Name: bug_filter_pk_seq Type: SEQUENCE SET Owner:
5460 -- SELECT setval ('bug_filter_pk_seq', 140, 't');
5463 -- TOC Entry ID 13 (OID 18138687)
5465 -- Name: bug_group_pk_seq Type: SEQUENCE SET Owner:
5468 -- SELECT setval ('bug_group_pk_seq', 2780, 't');
5471 -- TOC Entry ID 15 (OID 18138738)
5473 -- Name: bug_history_pk_seq Type: SEQUENCE SET Owner:
5476 -- SELECT setval ('bug_history_pk_seq', 106196, 't');
5479 -- TOC Entry ID 17 (OID 18138794)
5481 -- Name: bug_resolution_pk_seq Type: SEQUENCE SET Owner:
5484 -- SELECT setval ('bug_resolution_pk_seq', 101, 't');
5487 -- TOC Entry ID 19 (OID 18138843)
5489 -- Name: bug_status_pk_seq Type: SEQUENCE SET Owner:
5492 -- SELECT setval ('bug_status_pk_seq', 100, 't');
5495 -- TOC Entry ID 21 (OID 18138891)
5497 -- Name: bug_task_dependencies_pk_seq Type: SEQUENCE SET Owner:
5500 -- SELECT setval ('bug_task_dependencies_pk_seq', 44583, 't');
5503 -- TOC Entry ID 23 (OID 18138927)
5505 -- Name: canned_responses_pk_seq Type: SEQUENCE SET Owner:
5508 -- SELECT setval ('canned_responses_pk_seq', 5, 't');
5511 -- TOC Entry ID 25 (OID 18138977)
5513 -- Name: db_images_pk_seq Type: SEQUENCE SET Owner:
5516 -- SELECT setval ('db_images_pk_seq', 1128, 't');
5519 -- TOC Entry ID 27 (OID 18139040)
5521 -- Name: doc_data_pk_seq Type: SEQUENCE SET Owner:
5524 -- SELECT setval ('doc_data_pk_seq', 2124, 't');
5527 -- TOC Entry ID 29 (OID 18139104)
5529 -- Name: doc_groups_pk_seq Type: SEQUENCE SET Owner:
5532 -- SELECT setval ('doc_groups_pk_seq', 1815, 't');
5535 -- TOC Entry ID 31 (OID 18139140)
5537 -- Name: doc_states_pk_seq Type: SEQUENCE SET Owner:
5540 -- SELECT setval ('doc_states_pk_seq', 5, 't');
5543 -- TOC Entry ID 33 (OID 18139174)
5545 -- Name: filemodule_monitor_pk_seq Type: SEQUENCE SET Owner:
5548 -- SELECT setval ('filemodule_monitor_pk_seq', 312, 't');
5551 -- TOC Entry ID 35 (OID 18139210)
5553 -- Name: forum_pk_seq Type: SEQUENCE SET Owner:
5556 -- SELECT setval ('forum_pk_seq', 84486, 't');
5559 -- TOC Entry ID 37 (OID 18139291)
5561 -- Name: forum_group_list_pk_seq Type: SEQUENCE SET Owner:
5564 -- SELECT setval ('forum_group_list_pk_seq', 51981, 't');
5567 -- TOC Entry ID 39 (OID 18139348)
5569 -- Name: forum_monitored_forums_pk_seq Type: SEQUENCE SET Owner:
5572 -- SELECT setval ('forum_monitored_forums_pk_seq', 14831, 't');
5575 -- TOC Entry ID 41 (OID 18139384)
5577 -- Name: forum_saved_place_pk_seq Type: SEQUENCE SET Owner:
5580 -- SELECT setval ('forum_saved_place_pk_seq', 1835, 't');
5583 -- TOC Entry ID 43 (OID 18139492)
5585 -- Name: foundry_news_pk_seq Type: SEQUENCE SET Owner:
5588 -- SELECT setval ('foundry_news_pk_seq', 1973, 't');
5591 -- TOC Entry ID 45 (OID 18139532)
5593 -- Name: foundry_preferred_projec_pk_seq Type: SEQUENCE SET Owner:
5596 -- SELECT setval ('foundry_preferred_projec_pk_seq', 165, 't');
5599 -- TOC Entry ID 47 (OID 18139570)
5601 -- Name: foundry_projects_pk_seq Type: SEQUENCE SET Owner:
5604 -- SELECT setval ('foundry_projects_pk_seq', 320807, 't');
5607 -- TOC Entry ID 49 (OID 18139695)
5609 -- Name: frs_file_pk_seq Type: SEQUENCE SET Owner:
5612 -- SELECT setval ('frs_file_pk_seq', 29214, 't');
5615 -- TOC Entry ID 51 (OID 18139756)
5617 -- Name: frs_filetype_pk_seq Type: SEQUENCE SET Owner:
5620 -- SELECT setval ('frs_filetype_pk_seq', 9999, 't');
5623 -- TOC Entry ID 53 (OID 18139804)
5625 -- Name: frs_package_pk_seq Type: SEQUENCE SET Owner:
5628 -- SELECT setval ('frs_package_pk_seq', 12688, 't');
5631 -- TOC Entry ID 55 (OID 18139856)
5633 -- Name: frs_processor_pk_seq Type: SEQUENCE SET Owner:
5636 -- SELECT setval ('frs_processor_pk_seq', 9999, 't');
5639 -- TOC Entry ID 57 (OID 18139904)
5641 -- Name: frs_release_pk_seq Type: SEQUENCE SET Owner:
5644 -- SELECT setval ('frs_release_pk_seq', 17983, 't');
5647 -- TOC Entry ID 59 (OID 18139964)
5649 -- Name: frs_status_pk_seq Type: SEQUENCE SET Owner:
5652 -- SELECT setval ('frs_status_pk_seq', 3, 't');
5655 -- TOC Entry ID 61 (OID 18140012)
5657 -- Name: group_cvs_history_pk_seq Type: SEQUENCE SET Owner:
5660 -- SELECT setval ('group_cvs_history_pk_seq', 1, 'f');
5663 -- TOC Entry ID 63 (OID 18140056)
5665 -- Name: group_history_pk_seq Type: SEQUENCE SET Owner:
5668 -- SELECT setval ('group_history_pk_seq', 29283, 't');
5671 -- TOC Entry ID 65 (OID 18140112)
5673 -- Name: group_type_pk_seq Type: SEQUENCE SET Owner:
5676 -- SELECT setval ('group_type_pk_seq', 2, 't');
5679 -- TOC Entry ID 67 (OID 18140160)
5681 -- Name: groups_pk_seq Type: SEQUENCE SET Owner:
5684 -- SELECT setval ('groups_pk_seq', 16379, 't');
5687 -- TOC Entry ID 69 (OID 18140301)
5689 -- Name: mail_group_list_pk_seq Type: SEQUENCE SET Owner:
5692 -- SELECT setval ('mail_group_list_pk_seq', 7581, 't');
5695 -- TOC Entry ID 71 (OID 18140359)
5697 -- Name: news_bytes_pk_seq Type: SEQUENCE SET Owner:
5700 -- SELECT setval ('news_bytes_pk_seq', 10299, 't');
5703 -- TOC Entry ID 73 (OID 18140419)
5705 -- Name: patch_pk_seq Type: SEQUENCE SET Owner:
5708 -- SELECT setval ('patch_pk_seq', 102785, 't');
5711 -- TOC Entry ID 75 (OID 18140483)
5713 -- Name: patch_category_pk_seq Type: SEQUENCE SET Owner:
5716 -- SELECT setval ('patch_category_pk_seq', 10607, 't');
5719 -- TOC Entry ID 77 (OID 18140534)
5721 -- Name: patch_history_pk_seq Type: SEQUENCE SET Owner:
5724 -- SELECT setval ('patch_history_pk_seq', 9813, 't');
5727 -- TOC Entry ID 79 (OID 18140590)
5729 -- Name: patch_status_pk_seq Type: SEQUENCE SET Owner:
5732 -- SELECT setval ('patch_status_pk_seq', 103, 't');
5735 -- TOC Entry ID 81 (OID 18140638)
5737 -- Name: people_job_pk_seq Type: SEQUENCE SET Owner:
5740 -- SELECT setval ('people_job_pk_seq', 1641, 't');
5743 -- TOC Entry ID 83 (OID 18140697)
5745 -- Name: people_job_category_pk_seq Type: SEQUENCE SET Owner:
5748 -- SELECT setval ('people_job_category_pk_seq', 102, 't');
5751 -- TOC Entry ID 85 (OID 18140747)
5753 -- Name: people_job_inventory_pk_seq Type: SEQUENCE SET Owner:
5756 -- SELECT setval ('people_job_inventory_pk_seq', 1970, 't');
5759 -- TOC Entry ID 87 (OID 18140787)
5761 -- Name: people_job_status_pk_seq Type: SEQUENCE SET Owner:
5764 -- SELECT setval ('people_job_status_pk_seq', 3, 't');
5767 -- TOC Entry ID 89 (OID 18140835)
5769 -- Name: people_skill_pk_seq Type: SEQUENCE SET Owner:
5772 -- SELECT setval ('people_skill_pk_seq', 33, 't');
5775 -- TOC Entry ID 91 (OID 18140884)
5777 -- Name: people_skill_inventory_pk_seq Type: SEQUENCE SET Owner:
5780 -- SELECT setval ('people_skill_inventory_pk_seq', 60179, 't');
5783 -- TOC Entry ID 93 (OID 18140924)
5785 -- Name: people_skill_level_pk_seq Type: SEQUENCE SET Owner:
5788 -- SELECT setval ('people_skill_level_pk_seq', 5, 't');
5791 -- TOC Entry ID 95 (OID 18140972)
5793 -- Name: people_skill_year_pk_seq Type: SEQUENCE SET Owner:
5796 -- SELECT setval ('people_skill_year_pk_seq', 5, 't');
5799 -- TOC Entry ID 97 (OID 18141020)
5801 -- Name: project_assigned_to_pk_seq Type: SEQUENCE SET Owner:
5804 -- SELECT setval ('project_assigned_to_pk_seq', 30257, 't');
5807 -- TOC Entry ID 99 (OID 18141110)
5809 -- Name: project_dependencies_pk_seq Type: SEQUENCE SET Owner:
5812 -- SELECT setval ('project_dependencies_pk_seq', 25231, 't');
5815 -- TOC Entry ID 101 (OID 18141146)
5817 -- Name: project_group_list_pk_seq Type: SEQUENCE SET Owner:
5820 -- SELECT setval ('project_group_list_pk_seq', 6360, 't');
5823 -- TOC Entry ID 103 (OID 18141200)
5825 -- Name: project_history_pk_seq Type: SEQUENCE SET Owner:
5828 -- SELECT setval ('project_history_pk_seq', 27347, 't');
5831 -- TOC Entry ID 105 (OID 18141257)
5833 -- Name: project_metric_pk_seq Type: SEQUENCE SET Owner:
5836 -- SELECT setval ('project_metric_pk_seq', 13274, 't');
5839 -- TOC Entry ID 107 (OID 18141292)
5841 -- Name: project_metric_tmp1_pk_seq Type: SEQUENCE SET Owner:
5844 -- SELECT setval ('project_metric_tmp1_pk_seq', 13274, 't');
5847 -- TOC Entry ID 109 (OID 18141327)
5849 -- Name: project_metric_weekly_tm_pk_seq Type: SEQUENCE SET Owner:
5852 -- SELECT setval ('project_metric_weekly_tm_pk_seq', 2213, 't');
5855 -- TOC Entry ID 111 (OID 18141363)
5857 -- Name: project_status_pk_seq Type: SEQUENCE SET Owner:
5860 -- SELECT setval ('project_status_pk_seq', 100, 't');
5863 -- TOC Entry ID 113 (OID 18141412)
5865 -- Name: project_task_pk_seq Type: SEQUENCE SET Owner:
5868 -- SELECT setval ('project_task_pk_seq', 23295, 't');
5871 -- TOC Entry ID 115 (OID 18141479)
5873 -- Name: project_weekly_metric_pk_seq Type: SEQUENCE SET Owner:
5876 -- SELECT setval ('project_weekly_metric_pk_seq', 2213, 't');
5879 -- TOC Entry ID 117 (OID 18141534)
5881 -- Name: snippet_pk_seq Type: SEQUENCE SET Owner:
5884 -- SELECT setval ('snippet_pk_seq', 100501, 't');
5887 -- TOC Entry ID 119 (OID 18141593)
5889 -- Name: snippet_package_pk_seq Type: SEQUENCE SET Owner:
5892 -- SELECT setval ('snippet_package_pk_seq', 100035, 't');
5895 -- TOC Entry ID 121 (OID 18141648)
5897 -- Name: snippet_package_item_pk_seq Type: SEQUENCE SET Owner:
5900 -- SELECT setval ('snippet_package_item_pk_seq', 100100, 't');
5903 -- TOC Entry ID 123 (OID 18141684)
5905 -- Name: snippet_package_version_pk_seq Type: SEQUENCE SET Owner:
5908 -- SELECT setval ('snippet_package_version_pk_seq', 100035, 't');
5911 -- TOC Entry ID 125 (OID 18141739)
5913 -- Name: snippet_version_pk_seq Type: SEQUENCE SET Owner:
5916 -- SELECT setval ('snippet_version_pk_seq', 100662, 't');
5919 -- TOC Entry ID 127 (OID 18142132)
5921 -- Name: support_pk_seq Type: SEQUENCE SET Owner:
5924 -- SELECT setval ('support_pk_seq', 109672, 't');
5927 -- TOC Entry ID 129 (OID 18142196)
5929 -- Name: support_canned_responses_pk_seq Type: SEQUENCE SET Owner:
5932 -- SELECT setval ('support_canned_responses_pk_seq', 100088, 't');
5935 -- TOC Entry ID 131 (OID 18142247)
5937 -- Name: support_category_pk_seq Type: SEQUENCE SET Owner:
5940 -- SELECT setval ('support_category_pk_seq', 10699, 't');
5943 -- TOC Entry ID 133 (OID 18142298)
5945 -- Name: support_history_pk_seq Type: SEQUENCE SET Owner:
5948 -- SELECT setval ('support_history_pk_seq', 24027, 't');
5951 -- TOC Entry ID 135 (OID 18142354)
5953 -- Name: support_messages_pk_seq Type: SEQUENCE SET Owner:
5956 -- SELECT setval ('support_messages_pk_seq', 122077, 't');
5959 -- TOC Entry ID 137 (OID 18142407)
5961 -- Name: support_status_pk_seq Type: SEQUENCE SET Owner:
5964 -- SELECT setval ('support_status_pk_seq', 3, 't');
5967 -- TOC Entry ID 139 (OID 18142455)
5969 -- Name: supported_languages_pk_seq Type: SEQUENCE SET Owner:
5972 -- SELECT setval ('supported_languages_pk_seq', 21, 't');
5975 -- TOC Entry ID 141 (OID 18142506)
5977 -- Name: survey_question_types_pk_seq Type: SEQUENCE SET Owner:
5980 -- SELECT setval ('survey_question_types_pk_seq', 100, 't');
5983 -- TOC Entry ID 143 (OID 18142555)
5985 -- Name: survey_questions_pk_seq Type: SEQUENCE SET Owner:
5988 -- SELECT setval ('survey_questions_pk_seq', 14662, 't');
5991 -- TOC Entry ID 145 (OID 18142680)
5993 -- Name: surveys_pk_seq Type: SEQUENCE SET Owner:
5996 -- SELECT setval ('surveys_pk_seq', 11185, 't');
5999 -- TOC Entry ID 147 (OID 18142735)
6001 -- Name: system_history_pk_seq Type: SEQUENCE SET Owner:
6004 -- SELECT setval ('system_history_pk_seq', 1, 'f');
6007 -- TOC Entry ID 149 (OID 18142787)
6009 -- Name: system_machines_pk_seq Type: SEQUENCE SET Owner:
6012 -- SELECT setval ('system_machines_pk_seq', 1, 'f');
6015 -- TOC Entry ID 151 (OID 18142836)
6017 -- Name: system_news_pk_seq Type: SEQUENCE SET Owner:
6020 -- SELECT setval ('system_news_pk_seq', 1, 'f');
6023 -- TOC Entry ID 153 (OID 18142895)
6025 -- Name: system_services_pk_seq Type: SEQUENCE SET Owner:
6028 -- SELECT setval ('system_services_pk_seq', 1, 'f');
6031 -- TOC Entry ID 155 (OID 18142944)
6033 -- Name: system_status_pk_seq Type: SEQUENCE SET Owner:
6036 -- SELECT setval ('system_status_pk_seq', 1, 'f');
6039 -- TOC Entry ID 157 (OID 18143020)
6041 -- Name: themes_pk_seq Type: SEQUENCE SET Owner:
6044 -- SELECT setval ('themes_pk_seq', 2, 't');
6047 -- TOC Entry ID 159 (OID 18143113)
6049 -- Name: trove_cat_pk_seq Type: SEQUENCE SET Owner:
6052 -- SELECT setval ('trove_cat_pk_seq', 281, 't');
6055 -- TOC Entry ID 161 (OID 18143176)
6057 -- Name: trove_group_link_pk_seq Type: SEQUENCE SET Owner:
6060 -- SELECT setval ('trove_group_link_pk_seq', 111628, 't');
6063 -- TOC Entry ID 163 (OID 18143216)
6065 -- Name: trove_treesums_pk_seq Type: SEQUENCE SET Owner:
6068 -- SELECT setval ('trove_treesums_pk_seq', 765, 't');
6071 -- TOC Entry ID 165 (OID 18143286)
6073 -- Name: user_bookmarks_pk_seq Type: SEQUENCE SET Owner:
6076 -- SELECT setval ('user_bookmarks_pk_seq', 23482, 't');
6079 -- TOC Entry ID 167 (OID 18143337)
6081 -- Name: user_diary_pk_seq Type: SEQUENCE SET Owner:
6084 -- SELECT setval ('user_diary_pk_seq', 892, 't');
6087 -- TOC Entry ID 169 (OID 18143392)
6089 -- Name: user_diary_monitor_pk_seq Type: SEQUENCE SET Owner:
6092 -- SELECT setval ('user_diary_monitor_pk_seq', 521, 't');
6095 -- TOC Entry ID 171 (OID 18143428)
6097 -- Name: user_group_pk_seq Type: SEQUENCE SET Owner:
6100 -- SELECT setval ('user_group_pk_seq', 27204, 't');
6103 -- TOC Entry ID 173 (OID 18143484)
6105 -- Name: user_metric_pk_seq Type: SEQUENCE SET Owner:
6108 -- SELECT setval ('user_metric_pk_seq', 115, 't');
6111 -- TOC Entry ID 175 (OID 18143530)
6113 -- Name: user_metric0_pk_seq Type: SEQUENCE SET Owner:
6116 -- SELECT setval ('user_metric0_pk_seq', 5, 't');
6119 -- TOC Entry ID 177 (OID 18143608)
6121 -- Name: users_pk_seq Type: SEQUENCE SET Owner:
6124 -- SELECT setval ('users_pk_seq', 120800, 't');
6127 -- TOC Entry ID 179 (OID 27311232)
6129 -- Name: unix_uid_seq Type: SEQUENCE SET Owner:
6132 -- SELECT setval ('unix_uid_seq', 21044, 't');
6135 -- TOC Entry ID 181 (OID 27311250)
6137 -- Name: forum_thread_seq Type: SEQUENCE SET Owner:
6140 -- SELECT setval ('forum_thread_seq', 59698, 't');