2 -- Selected TOC Entries:
6 -- TOC Entry ID 2 (OID 18138427)
8 -- Name: bug_pk_seq Type: SEQUENCE Owner: tperdue
11 CREATE SEQUENCE bug_pk_seq START WITH 1;
14 -- TOC Entry ID 182 (OID 18138445)
16 -- Name: bug Type: TABLE Owner: tperdue
20 bug_id number(*) NOT NULL,
21 group_id number(*) DEFAULT '0' NOT NULL,
22 status_id number(*) DEFAULT '0' NOT NULL,
23 priority number(*) DEFAULT '0' NOT NULL,
24 category_id number(*) DEFAULT '0' NOT NULL,
25 submitted_by number(*) DEFAULT '0' NOT NULL,
26 assigned_to number(*) DEFAULT '0' NOT NULL,
27 date1 number(*) DEFAULT '0' NOT NULL,
28 summary varchar2(4000),
29 details varchar2(4000),
31 bug_group_id number(*) DEFAULT '0' NOT NULL,
32 resolution_id number(*) DEFAULT '0' NOT NULL,
37 -- TOC Entry ID 4 (OID 18138495)
39 -- Name: bug_bug_dependencies_pk_seq Type: SEQUENCE Owner: tperdue
42 CREATE SEQUENCE bug_bug_dependencies_pk_seq START WITH 1;
45 -- TOC Entry ID 183 (OID 18138513)
47 -- Name: bug_bug_dependencies Type: TABLE Owner: tperdue
50 CREATE TABLE bug_bug_dependencies (
51 bug_depend_id number(*) NOT NULL,
52 bug_id number(*) DEFAULT '0' NOT NULL,
53 is_dependent_on_bug_id number(*) DEFAULT '0' NOT NULL,
54 PRIMARY KEY (bug_depend_id)
58 -- TOC Entry ID 6 (OID 18138531)
60 -- Name: bug_canned_responses_pk_seq Type: SEQUENCE Owner: tperdue
63 CREATE SEQUENCE bug_canned_responses_pk_seq START WITH 1;
66 -- TOC Entry ID 184 (OID 18138549)
68 -- Name: bug_canned_responses Type: TABLE Owner: tperdue
71 CREATE TABLE bug_canned_responses (
72 bug_canned_id number(*) NOT NULL,
73 group_id number(*) DEFAULT '0' NOT NULL,
76 PRIMARY KEY (bug_canned_id)
80 -- TOC Entry ID 8 (OID 18138582)
82 -- Name: bug_category_pk_seq Type: SEQUENCE Owner: tperdue
85 CREATE SEQUENCE bug_category_pk_seq START WITH 1;
88 -- TOC Entry ID 185 (OID 18138600)
90 -- Name: bug_category Type: TABLE Owner: tperdue
93 CREATE TABLE bug_category (
94 bug_category_id number(*) NOT NULL,
95 group_id number(*) DEFAULT '0' NOT NULL,
96 category_name varchar2(4000),
97 PRIMARY KEY (bug_category_id)
101 -- TOC Entry ID 10 (OID 18138632)
103 -- Name: bug_filter_pk_seq Type: SEQUENCE Owner: tperdue
106 CREATE SEQUENCE bug_filter_pk_seq START WITH 1;
109 -- TOC Entry ID 186 (OID 18138650)
111 -- Name: bug_filter Type: TABLE Owner: tperdue
114 CREATE TABLE bug_filter (
115 filter_id number(*) NOT NULL,
116 user_id number(*) DEFAULT '0' NOT NULL,
117 group_id number(*) DEFAULT '0' NOT NULL,
118 sql_clause varchar2(4000) DEFAULT ' ' NOT NULL,
119 is_active number(*) DEFAULT '0' NOT NULL,
120 PRIMARY KEY (filter_id)
124 -- TOC Entry ID 12 (OID 18138687)
126 -- Name: bug_group_pk_seq Type: SEQUENCE Owner: tperdue
129 CREATE SEQUENCE bug_group_pk_seq START WITH 1;
132 -- TOC Entry ID 187 (OID 18138705)
134 -- Name: bug_group Type: TABLE Owner: tperdue
137 CREATE TABLE bug_group (
138 bug_group_id number(*) NOT NULL,
139 group_id number(*) DEFAULT '0' NOT NULL,
140 group_name varchar2(4000) DEFAULT ' ' NOT NULL,
141 PRIMARY KEY (bug_group_id)
145 -- TOC Entry ID 14 (OID 18138738)
147 -- Name: bug_history_pk_seq Type: SEQUENCE Owner: tperdue
150 CREATE SEQUENCE bug_history_pk_seq START WITH 1;
153 -- TOC Entry ID 188 (OID 18138756)
155 -- Name: bug_history Type: TABLE Owner: tperdue
158 CREATE TABLE bug_history (
159 bug_history_id number(*) NOT NULL,
160 bug_id number(*) DEFAULT '0' NOT NULL,
161 field_name varchar2(4000) DEFAULT ' ' NOT NULL,
162 old_value varchar2(4000) DEFAULT ' ' NOT NULL,
163 mod_by number(*) DEFAULT '0' NOT NULL,
165 PRIMARY KEY (bug_history_id)
169 -- TOC Entry ID 16 (OID 18138794)
171 -- Name: bug_resolution_pk_seq Type: SEQUENCE Owner: tperdue
174 CREATE SEQUENCE bug_resolution_pk_seq START WITH 1;
177 -- TOC Entry ID 189 (OID 18138812)
179 -- Name: bug_resolution Type: TABLE Owner: tperdue
182 CREATE TABLE bug_resolution (
183 resolution_id number(*) NOT NULL,
184 resolution_name varchar2(4000) DEFAULT ' ' NOT NULL,
185 PRIMARY KEY (resolution_id)
189 -- TOC Entry ID 18 (OID 18138843)
191 -- Name: bug_status_pk_seq Type: SEQUENCE Owner: tperdue
194 CREATE SEQUENCE bug_status_pk_seq START WITH 1;
197 -- TOC Entry ID 190 (OID 18138861)
199 -- Name: bug_status Type: TABLE Owner: tperdue
202 CREATE TABLE bug_status (
203 status_id number(*) NOT NULL,
204 status_name varchar2(4000),
205 PRIMARY KEY (status_id)
209 -- TOC Entry ID 20 (OID 18138891)
211 -- Name: bug_task_dependencies_pk_seq Type: SEQUENCE Owner: tperdue
214 CREATE SEQUENCE bug_task_dependencies_pk_seq START WITH 1;
217 -- TOC Entry ID 191 (OID 18138909)
219 -- Name: bug_task_dependencies Type: TABLE Owner: tperdue
222 CREATE TABLE bug_task_dependencies (
223 bug_depend_id number(*) NOT NULL,
224 bug_id number(*) DEFAULT '0' NOT NULL,
225 is_dependent_on_task_id number(*) DEFAULT '0' NOT NULL,
226 PRIMARY KEY (bug_depend_id)
230 -- TOC Entry ID 22 (OID 18138927)
232 -- Name: canned_responses_pk_seq Type: SEQUENCE Owner: tperdue
235 CREATE SEQUENCE canned_responses_pk_seq START WITH 1;
238 -- TOC Entry ID 192 (OID 18138946)
240 -- Name: canned_responses Type: TABLE Owner: tperdue
243 CREATE TABLE canned_responses (
244 response_id number(*) NOT NULL,
245 response_title character varying(25),
246 response_text varchar2(4000),
247 PRIMARY KEY (response_id)
251 -- TOC Entry ID 24 (OID 18138977)
253 -- Name: db_images_pk_seq Type: SEQUENCE Owner: tperdue
256 CREATE SEQUENCE db_images_pk_seq START WITH 1;
259 -- TOC Entry ID 193 (OID 18138995)
261 -- Name: db_images Type: TABLE Owner: tperdue
264 CREATE TABLE db_images (
265 id number(*) NOT NULL,
266 group_id number(*) DEFAULT '0' NOT NULL,
267 description varchar2(4000) DEFAULT ' ' NOT NULL,
268 bin_data varchar2(4000) DEFAULT ' ' NOT NULL,
269 filename varchar2(4000) DEFAULT ' ' NOT NULL,
270 filesize number(*) DEFAULT '0' NOT NULL,
271 filetype varchar2(4000) DEFAULT ' ' NOT NULL,
272 width number(*) DEFAULT '0' NOT NULL,
273 height number(*) DEFAULT '0' NOT NULL,
278 -- TOC Entry ID 26 (OID 18139040)
280 -- Name: doc_data_pk_seq Type: SEQUENCE Owner: tperdue
283 CREATE SEQUENCE doc_data_pk_seq START WITH 1;
286 -- TOC Entry ID 194 (OID 18139058)
288 -- Name: doc_data Type: TABLE Owner: tperdue
291 CREATE TABLE doc_data (
292 docid number(*) NOT NULL,
293 stateid number(*) DEFAULT '0' NOT NULL,
294 title character varying(255) DEFAULT ' ' NOT NULL,
295 data varchar2(4000) DEFAULT ' ' NOT NULL,
296 updatedate1 number(*) DEFAULT '0' NOT NULL,
297 createdate1 number(*) DEFAULT '0' NOT NULL,
298 created_by number(*) DEFAULT '0' NOT NULL,
299 doc_group number(*) DEFAULT '0' NOT NULL,
300 description varchar2(4000),
301 language_id number(*) DEFAULT '1' NOT NULL,
306 -- TOC Entry ID 28 (OID 18139104)
308 -- Name: doc_groups_pk_seq Type: SEQUENCE Owner: tperdue
311 CREATE SEQUENCE doc_groups_pk_seq START WITH 1;
314 -- TOC Entry ID 195 (OID 18139122)
316 -- Name: doc_groups Type: TABLE Owner: tperdue
319 CREATE TABLE doc_groups (
320 doc_group number(*) NOT NULL,
321 groupname character varying(255) DEFAULT ' ' NOT NULL,
322 group_id number(*) DEFAULT '0' NOT NULL,
323 PRIMARY KEY (doc_group)
327 -- TOC Entry ID 30 (OID 18139140)
329 -- Name: doc_states_pk_seq Type: SEQUENCE Owner: tperdue
332 CREATE SEQUENCE doc_states_pk_seq START WITH 1;
335 -- TOC Entry ID 196 (OID 18139158)
337 -- Name: doc_states Type: TABLE Owner: tperdue
340 CREATE TABLE doc_states (
341 stateid number(*) NOT NULL,
342 name character varying(255) DEFAULT ' ' NOT NULL,
343 PRIMARY KEY (stateid)
347 -- TOC Entry ID 32 (OID 18139174)
349 -- Name: filemodule_monitor_pk_seq Type: SEQUENCE Owner: tperdue
352 CREATE SEQUENCE filemodule_monitor_pk_seq START WITH 1;
355 -- TOC Entry ID 197 (OID 18139192)
357 -- Name: filemodule_monitor Type: TABLE Owner: tperdue
360 CREATE TABLE filemodule_monitor (
361 id number(*) NOT NULL,
362 filemodule_id number(*) DEFAULT '0' NOT NULL,
363 user_id number(*) DEFAULT '0' NOT NULL,
368 -- TOC Entry ID 34 (OID 18139210)
370 -- Name: forum_pk_seq Type: SEQUENCE Owner: tperdue
373 CREATE SEQUENCE forum_pk_seq START WITH 1;
376 -- TOC Entry ID 198 (OID 18139228)
378 -- Name: forum Type: TABLE Owner: tperdue
382 msg_id number(*) NOT NULL,
383 group_forum_id number(*) DEFAULT '0' NOT NULL,
384 posted_by number(*) DEFAULT '0' NOT NULL,
385 subject varchar2(4000) DEFAULT ' ' NOT NULL,
386 body varchar2(4000) DEFAULT ' ' NOT NULL,
387 date1 number(*) DEFAULT '0' NOT NULL,
388 is_followup_to number(*) DEFAULT '0' NOT NULL,
389 thread_id number(*) DEFAULT '0' NOT NULL,
390 has_followups number(*) DEFAULT '0',
391 most_recent_date number(*) DEFAULT '0' NOT NULL,
396 -- TOC Entry ID 199 (OID 18139275)
398 -- Name: forum_agg_msg_count Type: TABLE Owner: tperdue
401 CREATE TABLE forum_agg_msg_count (
402 group_forum_id number(*) DEFAULT '0' NOT NULL,
403 count number(*) DEFAULT '0' NOT NULL,
404 PRIMARY KEY (group_forum_id)
408 -- TOC Entry ID 36 (OID 18139291)
410 -- Name: forum_group_list_pk_seq Type: SEQUENCE Owner: tperdue
413 CREATE SEQUENCE forum_group_list_pk_seq START WITH 1;
416 -- TOC Entry ID 200 (OID 18139309)
418 -- Name: forum_group_list Type: TABLE Owner: tperdue
421 CREATE TABLE forum_group_list (
422 group_forum_id number(*) NOT NULL,
423 group_id number(*) DEFAULT '0' NOT NULL,
424 forum_name varchar2(4000) DEFAULT ' ' NOT NULL,
425 is_public number(*) DEFAULT '0' NOT NULL,
426 description varchar2(4000),
427 allow_anonymous number(*) DEFAULT '0' NOT NULL,
428 send_all_posts_to varchar2(4000),
429 PRIMARY KEY (group_forum_id)
433 -- TOC Entry ID 38 (OID 18139348)
435 -- Name: forum_monitor_forums_pk_seq Type: SEQUENCE Owner: tperdue
438 CREATE SEQUENCE forum_monitor_forums_pk_seq START WITH 1;
441 -- TOC Entry ID 201 (OID 18139366)
443 -- Name: forum_monitored_forums Type: TABLE Owner: tperdue
446 CREATE TABLE forum_monitored_forums (
447 monitor_id number(*) NOT NULL,
448 forum_id number(*) DEFAULT '0' NOT NULL,
449 user_id number(*) DEFAULT '0' NOT NULL,
450 PRIMARY KEY (monitor_id)
454 -- TOC Entry ID 40 (OID 18139384)
456 -- Name: forum_saved_place_pk_seq Type: SEQUENCE Owner: tperdue
459 CREATE SEQUENCE forum_saved_place_pk_seq START WITH 1;
462 -- TOC Entry ID 202 (OID 18139402)
464 -- Name: forum_saved_place Type: TABLE Owner: tperdue
467 CREATE TABLE forum_saved_place (
468 saved_place_id number(*) NOT NULL,
469 user_id number(*) DEFAULT '0' NOT NULL,
470 forum_id number(*) DEFAULT '0' NOT NULL,
471 save_date number(*) DEFAULT '0' NOT NULL,
472 PRIMARY KEY (saved_place_id)
476 -- TOC Entry ID 203 (OID 18139454)
478 -- Name: foundry_data Type: TABLE Owner: tperdue
481 CREATE TABLE foundry_data (
482 foundry_id number(*) DEFAULT '0' NOT NULL,
483 freeform1_html varchar2(4000),
484 freeform2_html varchar2(4000),
485 sponsor1_html varchar2(4000),
486 sponsor2_html varchar2(4000),
487 guide_image_id number(*) DEFAULT '0' NOT NULL,
488 logo_image_id number(*) DEFAULT '0' NOT NULL,
489 trove_categories varchar2(4000),
490 PRIMARY KEY (foundry_id)
494 -- TOC Entry ID 42 (OID 18139492)
496 -- Name: foundry_news_pk_seq Type: SEQUENCE Owner: tperdue
499 CREATE SEQUENCE foundry_news_pk_seq START WITH 1;
502 -- TOC Entry ID 204 (OID 18139510)
504 -- Name: foundry_news Type: TABLE Owner: tperdue
507 CREATE TABLE foundry_news (
508 foundry_news_id number(*) NOT NULL,
509 foundry_id number(*) DEFAULT '0' NOT NULL,
510 news_id number(*) DEFAULT '0' NOT NULL,
511 approve_date number(*) DEFAULT '0' NOT NULL,
512 is_approved number(*) DEFAULT '0' NOT NULL,
513 PRIMARY KEY (foundry_news_id)
517 -- TOC Entry ID 44 (OID 18139532)
519 -- Name: foundry_prefer_proj_pk_seq Type: SEQUENCE Owner: tperdue
522 CREATE SEQUENCE foundry_prefer_proj_pk_seq START WITH 1;
525 -- TOC Entry ID 205 (OID 18139550)
527 -- Name: foundry_preferred_projects Type: TABLE Owner: tperdue
530 CREATE TABLE foundry_preferred_projects (
531 foundry_project_id number(*) NOT NULL,
532 foundry_id number(*) DEFAULT '0' NOT NULL,
533 group_id number(*) DEFAULT '0' NOT NULL,
534 rank number(*) DEFAULT '0' NOT NULL,
535 PRIMARY KEY (foundry_project_id)
539 -- TOC Entry ID 46 (OID 18139570)
541 -- Name: foundry_projects_pk_seq Type: SEQUENCE Owner: tperdue
544 CREATE SEQUENCE foundry_projects_pk_seq START WITH 1;
547 -- TOC Entry ID 206 (OID 18139588)
549 -- Name: foundry_projects Type: TABLE Owner: tperdue
552 CREATE TABLE foundry_projects (
553 id number(*) NOT NULL,
554 foundry_id number(*) DEFAULT '0' NOT NULL,
555 project_id number(*) DEFAULT '0' NOT NULL,
560 -- TOC Entry ID 207 (OID 18139606)
562 -- Name: frs_dlstats_agg Type: TABLE Owner: tperdue
565 CREATE TABLE frs_dlstats_agg (
566 file_id number(*) DEFAULT '0' NOT NULL,
567 day number(*) DEFAULT '0' NOT NULL,
568 downloads_http number(*) DEFAULT '0' NOT NULL,
569 downloads_ftp number(*) DEFAULT '0' NOT NULL
573 -- TOC Entry ID 208 (OID 18139623)
575 -- Name: frs_dlstats_file_agg Type: TABLE Owner: tperdue
578 CREATE TABLE frs_dlstats_file_agg (
579 file_id number(*) DEFAULT '0' NOT NULL,
580 day number(*) DEFAULT '0' NOT NULL,
581 downloads number(*) DEFAULT '0' NOT NULL
585 -- TOC Entry ID 209 (OID 18139638)
587 -- Name: frs_dlstats_filetotal_agg Type: TABLE Owner: tperdue
590 CREATE TABLE frs_dlstats_filetotal_agg (
591 file_id number(*) DEFAULT '0' NOT NULL,
592 downloads number(*) DEFAULT '0' NOT NULL,
593 PRIMARY KEY (file_id)
597 -- TOC Entry ID 210 (OID 18139654)
599 -- Name: frs_dlstats_filetotal_agg_old Type: TABLE Owner: tperdue
602 CREATE TABLE frs_dlstats_filetotal_agg_old (
603 file_id number(*) DEFAULT '0' NOT NULL,
604 downloads number(*) DEFAULT '0' NOT NULL
608 -- TOC Entry ID 211 (OID 18139667)
610 -- Name: frs_dlstats_group_agg Type: TABLE Owner: tperdue
613 CREATE TABLE frs_dlstats_group_agg (
614 group_id number(*) DEFAULT '0' NOT NULL,
615 day number(*) DEFAULT '0' NOT NULL,
616 downloads number(*) DEFAULT '0' NOT NULL
620 -- TOC Entry ID 212 (OID 18139682)
622 -- Name: frs_dlstats_grouptotal_agg Type: TABLE Owner: tperdue
625 CREATE TABLE frs_dlstats_grouptotal_agg (
626 group_id number(*) DEFAULT '0' NOT NULL,
627 downloads number(*) DEFAULT '0' NOT NULL
631 -- TOC Entry ID 48 (OID 18139695)
633 -- Name: frs_file_pk_seq Type: SEQUENCE Owner: tperdue
636 CREATE SEQUENCE frs_file_pk_seq START WITH 1;
639 -- TOC Entry ID 213 (OID 18139714)
641 -- Name: frs_file Type: TABLE Owner: tperdue
644 CREATE TABLE frs_file (
645 file_id number(*) NOT NULL,
646 filename varchar2(200),
647 release_id number(*) DEFAULT '0' NOT NULL,
648 type_id number(*) DEFAULT '0' NOT NULL,
649 processor_id number(*) DEFAULT '0' NOT NULL,
650 release_time number(*) DEFAULT '0' NOT NULL,
651 file_size number(*) DEFAULT '0' NOT NULL,
652 post_date number(*) DEFAULT '0' NOT NULL,
653 PRIMARY KEY (file_id)
657 -- TOC Entry ID 50 (OID 18139756)
659 -- Name: frs_filetype_pk_seq Type: SEQUENCE Owner: tperdue
662 CREATE SEQUENCE frs_filetype_pk_seq START WITH 1;
665 -- TOC Entry ID 214 (OID 18139774)
667 -- Name: frs_filetype Type: TABLE Owner: tperdue
670 CREATE TABLE frs_filetype (
671 type_id number(*) NOT NULL,
673 PRIMARY KEY (type_id)
677 -- TOC Entry ID 52 (OID 18139804)
679 -- Name: frs_package_pk_seq Type: SEQUENCE Owner: tperdue
682 CREATE SEQUENCE frs_package_pk_seq START WITH 1;
685 -- TOC Entry ID 215 (OID 18139822)
687 -- Name: frs_package Type: TABLE Owner: tperdue
690 CREATE TABLE frs_package (
691 package_id number(*) NOT NULL,
692 group_id number(*) DEFAULT '0' NOT NULL,
694 status_id number(*) DEFAULT '0' NOT NULL,
695 PRIMARY KEY (package_id)
699 -- TOC Entry ID 54 (OID 18139856)
701 -- Name: frs_processor_pk_seq Type: SEQUENCE Owner: tperdue
704 CREATE SEQUENCE frs_processor_pk_seq START WITH 1;
707 -- TOC Entry ID 216 (OID 18139874)
709 -- Name: frs_processor Type: TABLE Owner: tperdue
712 CREATE TABLE frs_processor (
713 processor_id number(*) NOT NULL,
715 PRIMARY KEY (processor_id)
719 -- TOC Entry ID 56 (OID 18139904)
721 -- Name: frs_release_pk_seq Type: SEQUENCE Owner: tperdue
724 CREATE SEQUENCE frs_release_pk_seq START WITH 1;
727 -- TOC Entry ID 217 (OID 18139922)
729 -- Name: frs_release Type: TABLE Owner: tperdue
732 CREATE TABLE frs_release (
733 release_id number(*) NOT NULL,
734 package_id number(*) DEFAULT '0' NOT NULL,
736 notes varchar2(4000),
737 changes varchar2(4000),
738 status_id number(*) DEFAULT '0' NOT NULL,
739 preformatted number(*) DEFAULT '0' NOT NULL,
740 release_date number(*) DEFAULT '0' NOT NULL,
741 released_by number(*) DEFAULT '0' NOT NULL,
742 PRIMARY KEY (release_id)
746 -- TOC Entry ID 58 (OID 18139964)
748 -- Name: frs_status_pk_seq Type: SEQUENCE Owner: tperdue
751 CREATE SEQUENCE frs_status_pk_seq START WITH 1;
754 -- TOC Entry ID 218 (OID 18139982)
756 -- Name: frs_status Type: TABLE Owner: tperdue
759 CREATE TABLE frs_status (
760 status_id number(*) NOT NULL,
762 PRIMARY KEY (status_id)
766 -- TOC Entry ID 60 (OID 18140012)
768 -- Name: group_cvs_history_pk_seq Type: SEQUENCE Owner: tperdue
771 CREATE SEQUENCE group_cvs_history_pk_seq START WITH 1;
774 -- TOC Entry ID 219 (OID 18140030)
776 -- Name: group_cvs_history Type: TABLE Owner: tperdue
779 CREATE TABLE group_cvs_history (
780 id number(*) NOT NULL,
781 group_id number(*) DEFAULT '0' NOT NULL,
782 user_name character varying(80) DEFAULT ' ' NOT NULL,
783 cvs_commits number(*) DEFAULT '0' NOT NULL,
784 cvs_commits_wk number(*) DEFAULT '0' NOT NULL,
785 cvs_adds number(*) DEFAULT '0' NOT NULL,
786 cvs_adds_wk number(*) DEFAULT '0' NOT NULL,
791 -- TOC Entry ID 62 (OID 18140056)
793 -- Name: group_history_pk_seq Type: SEQUENCE Owner: tperdue
796 CREATE SEQUENCE group_history_pk_seq START WITH 1;
799 -- TOC Entry ID 220 (OID 18140074)
801 -- Name: group_history Type: TABLE Owner: tperdue
804 CREATE TABLE group_history (
805 group_history_id number(*) NOT NULL,
806 group_id number(*) DEFAULT '0' NOT NULL,
807 field_name varchar2(4000) DEFAULT ' ' NOT NULL,
808 old_value varchar2(4000) DEFAULT ' ' NOT NULL,
809 mod_by number(*) DEFAULT '0' NOT NULL,
811 PRIMARY KEY (group_history_id)
815 -- TOC Entry ID 64 (OID 18140112)
817 -- Name: group_type_pk_seq Type: SEQUENCE Owner: tperdue
820 CREATE SEQUENCE group_type_pk_seq START WITH 1;
823 -- TOC Entry ID 221 (OID 18140130)
825 -- Name: group_type Type: TABLE Owner: tperdue
828 CREATE TABLE group_type (
829 type_id number(*) NOT NULL,
831 PRIMARY KEY (type_id)
835 -- TOC Entry ID 66 (OID 18140160)
837 -- Name: groups_pk_seq Type: SEQUENCE Owner: tperdue
840 CREATE SEQUENCE groups_pk_seq START WITH 1;
843 -- TOC Entry ID 222 (OID 18140178)
845 -- Name: groups Type: TABLE Owner: tperdue
848 CREATE TABLE groups (
849 group_id number(*) NOT NULL,
850 group_name character varying(40),
851 homepage character varying(128),
852 is_public number(*) DEFAULT '0' NOT NULL,
853 status character(1) DEFAULT 'A' NOT NULL,
854 unix_group_name character varying(30) DEFAULT ' ' NOT NULL,
855 unix_box character varying(20) DEFAULT 'shell1' NOT NULL,
856 http_domain character varying(80),
857 short_description character varying(255),
858 cvs_box character varying(20) DEFAULT 'cvs1' NOT NULL,
859 license character varying(16),
860 register_purpose varchar2(4000),
861 license_other varchar2(4000),
862 register_time number(*) DEFAULT '0' NOT NULL,
863 use_bugs number(*) DEFAULT '1' NOT NULL,
864 rand_hash varchar2(4000),
865 use_mail number(*) DEFAULT '1' NOT NULL,
866 use_survey number(*) DEFAULT '1' NOT NULL,
867 use_patch number(*) DEFAULT '1' NOT NULL,
868 use_forum number(*) DEFAULT '1' NOT NULL,
869 use_pm number(*) DEFAULT '1' NOT NULL,
870 use_cvs number(*) DEFAULT '1' NOT NULL,
871 use_news number(*) DEFAULT '1' NOT NULL,
872 use_support number(*) DEFAULT '1' NOT NULL,
873 new_bug_address varchar2(4000) DEFAULT ' ' NOT NULL,
874 new_patch_address varchar2(4000) DEFAULT ' ' NOT NULL,
875 new_support_address varchar2(4000) DEFAULT ' ' NOT NULL,
876 type number(*) DEFAULT '1' NOT NULL,
877 use_docman number(*) DEFAULT '1' NOT NULL,
878 send_all_bugs number(*) DEFAULT '0' NOT NULL,
879 send_all_patches number(*) DEFAULT '0' NOT NULL,
880 send_all_support number(*) DEFAULT '0' NOT NULL,
881 new_task_address varchar2(4000) DEFAULT ' ' NOT NULL,
882 send_all_tasks number(*) DEFAULT '0' NOT NULL,
883 use_bug_depend_box number(*) DEFAULT '1' NOT NULL,
884 use_pm_depend_box number(*) DEFAULT '1' NOT NULL,
885 PRIMARY KEY (group_id)
889 -- TOC Entry ID 223 (OID 18140269)
891 -- Name: intel_agreement Type: TABLE Owner: tperdue
894 CREATE TABLE intel_agreement (
895 user_id number(*) DEFAULT '0' NOT NULL,
896 message varchar2(4000),
897 is_approved number(*) DEFAULT '0' NOT NULL,
898 PRIMARY KEY (user_id)
902 -- TOC Entry ID 68 (OID 18140301)
904 -- Name: mail_group_list_pk_seq Type: SEQUENCE Owner: tperdue
907 CREATE SEQUENCE mail_group_list_pk_seq START WITH 1;
910 -- TOC Entry ID 224 (OID 18140319)
912 -- Name: mail_group_list Type: TABLE Owner: tperdue
915 CREATE TABLE mail_group_list (
916 group_list_id number(*) NOT NULL,
917 group_id number(*) DEFAULT '0' NOT NULL,
918 list_name varchar2(4000),
919 is_public number(*) DEFAULT '0' NOT NULL,
920 password character varying(16),
921 list_admin number(*) DEFAULT '0' NOT NULL,
922 status number(*) DEFAULT '0' NOT NULL,
923 description varchar2(4000),
924 PRIMARY KEY (group_list_id)
928 -- TOC Entry ID 70 (OID 18140359)
930 -- Name: news_bytes_pk_seq Type: SEQUENCE Owner: tperdue
933 CREATE SEQUENCE news_bytes_pk_seq START WITH 1;
936 -- TOC Entry ID 225 (OID 18140377)
938 -- Name: news_bytes Type: TABLE Owner: tperdue
941 CREATE TABLE news_bytes (
942 id number(*) NOT NULL,
943 group_id number(*) DEFAULT '0' NOT NULL,
944 submitted_by number(*) DEFAULT '0' NOT NULL,
945 is_approved number(*) DEFAULT '0' NOT NULL,
946 date1 number(*) DEFAULT '0' NOT NULL,
947 forum_id number(*) DEFAULT '0' NOT NULL,
948 summary varchar2(4000),
949 details varchar2(4000),
954 -- TOC Entry ID 72 (OID 18140419)
956 -- Name: patch_pk_seq Type: SEQUENCE Owner: tperdue
959 CREATE SEQUENCE patch_pk_seq START WITH 1;
962 -- TOC Entry ID 226 (OID 18140437)
964 -- Name: patch Type: TABLE Owner: tperdue
968 patch_id number(*) NOT NULL,
969 group_id number(*) DEFAULT '0' NOT NULL,
970 patch_status_id number(*) DEFAULT '0' NOT NULL,
971 patch_category_id number(*) DEFAULT '0' NOT NULL,
972 submitted_by number(*) DEFAULT '0' NOT NULL,
973 assigned_to number(*) DEFAULT '0' NOT NULL,
974 open_date number(*) DEFAULT '0' NOT NULL,
975 summary varchar2(4000),
977 close_date number(*) DEFAULT '0' NOT NULL,
978 PRIMARY KEY (patch_id)
982 -- TOC Entry ID 74 (OID 18140483)
984 -- Name: patch_category_pk_seq Type: SEQUENCE Owner: tperdue
987 CREATE SEQUENCE patch_category_pk_seq START WITH 1;
990 -- TOC Entry ID 227 (OID 18140501)
992 -- Name: patch_category Type: TABLE Owner: tperdue
995 CREATE TABLE patch_category (
996 patch_category_id number(*) NOT NULL,
997 group_id number(*) DEFAULT '0' NOT NULL,
998 category_name varchar2(4000) DEFAULT ' ' NOT NULL,
999 PRIMARY KEY (patch_category_id)
1003 -- TOC Entry ID 76 (OID 18140534)
1005 -- Name: patch_history_pk_seq Type: SEQUENCE Owner: tperdue
1008 CREATE SEQUENCE patch_history_pk_seq START WITH 1;
1011 -- TOC Entry ID 228 (OID 18140552)
1013 -- Name: patch_history Type: TABLE Owner: tperdue
1016 CREATE TABLE patch_history (
1017 patch_history_id number(*) NOT NULL,
1018 patch_id number(*) DEFAULT '0' NOT NULL,
1019 field_name varchar2(4000) DEFAULT ' ' NOT NULL,
1020 old_value varchar2(4000) DEFAULT ' ' NOT NULL,
1021 mod_by number(*) DEFAULT '0' NOT NULL,
1023 PRIMARY KEY (patch_history_id)
1027 -- TOC Entry ID 78 (OID 18140590)
1029 -- Name: patch_status_pk_seq Type: SEQUENCE Owner: tperdue
1032 CREATE SEQUENCE patch_status_pk_seq START WITH 1;
1035 -- TOC Entry ID 229 (OID 18140608)
1037 -- Name: patch_status Type: TABLE Owner: tperdue
1040 CREATE TABLE patch_status (
1041 patch_status_id number(*) NOT NULL,
1042 status_name varchar2(4000),
1043 PRIMARY KEY (patch_status_id)
1047 -- TOC Entry ID 80 (OID 18140638)
1049 -- Name: people_job_pk_seq Type: SEQUENCE Owner: tperdue
1052 CREATE SEQUENCE people_job_pk_seq START WITH 1;
1055 -- TOC Entry ID 230 (OID 18140656)
1057 -- Name: people_job Type: TABLE Owner: tperdue
1060 CREATE TABLE people_job (
1061 job_id number(*) NOT NULL,
1062 group_id number(*) DEFAULT '0' NOT NULL,
1063 created_by number(*) DEFAULT '0' NOT NULL,
1064 title varchar2(4000),
1065 description varchar2(4000),
1066 date1 number(*) DEFAULT '0' NOT NULL,
1067 status_id number(*) DEFAULT '0' NOT NULL,
1068 category_id number(*) DEFAULT '0' NOT NULL,
1069 PRIMARY KEY (job_id)
1073 -- TOC Entry ID 82 (OID 18140697)
1075 -- Name: people_job_category_pk_seq Type: SEQUENCE Owner: tperdue
1078 CREATE SEQUENCE people_job_category_pk_seq START WITH 1;
1081 -- TOC Entry ID 231 (OID 18140715)
1083 -- Name: people_job_category Type: TABLE Owner: tperdue
1086 CREATE TABLE people_job_category (
1087 category_id number(*) NOT NULL,
1088 name varchar2(4000),
1089 private_flag number(*) DEFAULT '0' NOT NULL,
1090 PRIMARY KEY (category_id)
1094 -- TOC Entry ID 84 (OID 18140747)
1096 -- Name: people_job_inventory_pk_seq Type: SEQUENCE Owner: tperdue
1099 CREATE SEQUENCE people_job_inventory_pk_seq START WITH 1;
1102 -- TOC Entry ID 232 (OID 18140765)
1104 -- Name: people_job_inventory Type: TABLE Owner: tperdue
1107 CREATE TABLE people_job_inventory (
1108 job_inventory_id number(*) NOT NULL,
1109 job_id number(*) DEFAULT '0' NOT NULL,
1110 skill_id number(*) DEFAULT '0' NOT NULL,
1111 skill_level_id number(*) DEFAULT '0' NOT NULL,
1112 skill_year_id number(*) DEFAULT '0' NOT NULL,
1113 PRIMARY KEY (job_inventory_id)
1117 -- TOC Entry ID 86 (OID 18140787)
1119 -- Name: people_job_status_pk_seq Type: SEQUENCE Owner: tperdue
1122 CREATE SEQUENCE people_job_status_pk_seq START WITH 1;
1125 -- TOC Entry ID 233 (OID 18140805)
1127 -- Name: people_job_status Type: TABLE Owner: tperdue
1130 CREATE TABLE people_job_status (
1131 status_id number(*) NOT NULL,
1132 name varchar2(4000),
1133 PRIMARY KEY (status_id)
1137 -- TOC Entry ID 88 (OID 18140835)
1139 -- Name: people_skill_pk_seq Type: SEQUENCE Owner: tperdue
1142 CREATE SEQUENCE people_skill_pk_seq START WITH 1;
1145 -- TOC Entry ID 234 (OID 18140853)
1147 -- Name: people_skill Type: TABLE Owner: tperdue
1150 CREATE TABLE people_skill (
1151 skill_id number(*) NOT NULL,
1152 name varchar2(4000),
1153 PRIMARY KEY (skill_id)
1157 -- TOC Entry ID 90 (OID 18140884)
1159 -- Name: people_skill_inv_pk_seq Type: SEQUENCE Owner: tperdue
1162 CREATE SEQUENCE people_skill_inv_pk_seq START WITH 1;
1165 -- TOC Entry ID 235 (OID 18140902)
1167 -- Name: people_skill_inventory Type: TABLE Owner: tperdue
1170 CREATE TABLE people_skill_inventory (
1171 skill_inventory_id number(*) NOT NULL,
1172 user_id number(*) DEFAULT '0' NOT NULL,
1173 skill_id number(*) DEFAULT '0' NOT NULL,
1174 skill_level_id number(*) DEFAULT '0' NOT NULL,
1175 skill_year_id number(*) DEFAULT '0' NOT NULL,
1176 PRIMARY KEY (skill_inventory_id)
1180 -- TOC Entry ID 92 (OID 18140924)
1182 -- Name: people_skill_level_pk_seq Type: SEQUENCE Owner: tperdue
1185 CREATE SEQUENCE people_skill_level_pk_seq START WITH 1;
1188 -- TOC Entry ID 236 (OID 18140942)
1190 -- Name: people_skill_level Type: TABLE Owner: tperdue
1193 CREATE TABLE people_skill_level (
1194 skill_level_id number(*) NOT NULL,
1195 name varchar2(4000),
1196 PRIMARY KEY (skill_level_id)
1200 -- TOC Entry ID 94 (OID 18140972)
1202 -- Name: people_skill_year_pk_seq Type: SEQUENCE Owner: tperdue
1205 CREATE SEQUENCE people_skill_year_pk_seq START WITH 1;
1208 -- TOC Entry ID 237 (OID 18140990)
1210 -- Name: people_skill_year Type: TABLE Owner: tperdue
1213 CREATE TABLE people_skill_year (
1214 skill_year_id number(*) NOT NULL,
1215 name varchar2(4000),
1216 PRIMARY KEY (skill_year_id)
1220 -- TOC Entry ID 96 (OID 18141020)
1222 -- Name: project_assigned_to_pk_seq Type: SEQUENCE Owner: tperdue
1225 CREATE SEQUENCE project_assigned_to_pk_seq START WITH 1;
1228 -- TOC Entry ID 238 (OID 18141038)
1230 -- Name: project_assigned_to Type: TABLE Owner: tperdue
1233 CREATE TABLE project_assigned_to (
1234 project_assigned_id number(*) NOT NULL,
1235 project_task_id number(*) DEFAULT '0' NOT NULL,
1236 assigned_to_id number(*) DEFAULT '0' NOT NULL,
1237 PRIMARY KEY (project_assigned_id)
1241 -- TOC Entry ID 239 (OID 18141056)
1243 -- Name: project_counts_tmp Type: TABLE Owner: tperdue
1246 CREATE TABLE project_counts_tmp (
1248 type varchar2(4000),
1249 count double precision
1253 -- TOC Entry ID 240 (OID 18141083)
1255 -- Name: project_counts_weekly_tmp Type: TABLE Owner: tperdue
1258 CREATE TABLE project_counts_weekly_tmp (
1260 type varchar2(4000),
1261 count double precision
1265 -- TOC Entry ID 98 (OID 18141110)
1267 -- Name: project_dependencies_pk_seq Type: SEQUENCE Owner: tperdue
1270 CREATE SEQUENCE project_dependencies_pk_seq START WITH 1;
1273 -- TOC Entry ID 241 (OID 18141128)
1275 -- Name: project_dependencies Type: TABLE Owner: tperdue
1278 CREATE TABLE project_dependencies (
1279 project_depend_id number(*) NOT NULL,
1280 project_task_id number(*) DEFAULT '0' NOT NULL,
1281 is_dependent_on_task_id number(*) DEFAULT '0' NOT NULL,
1282 PRIMARY KEY (project_depend_id)
1286 -- TOC Entry ID 100 (OID 18141146)
1288 -- Name: project_group_list_pk_seq Type: SEQUENCE Owner: tperdue
1291 CREATE SEQUENCE project_group_list_pk_seq START WITH 1;
1294 -- TOC Entry ID 242 (OID 18141164)
1296 -- Name: project_group_list Type: TABLE Owner: tperdue
1299 CREATE TABLE project_group_list (
1300 group_project_id number(*) NOT NULL,
1301 group_id number(*) DEFAULT '0' NOT NULL,
1302 project_name varchar2(4000) DEFAULT ' ' NOT NULL,
1303 is_public number(*) DEFAULT '0' NOT NULL,
1304 description varchar2(4000),
1305 PRIMARY KEY (group_project_id)
1309 -- TOC Entry ID 102 (OID 18141200)
1311 -- Name: project_history_pk_seq Type: SEQUENCE Owner: tperdue
1314 CREATE SEQUENCE project_history_pk_seq START WITH 1;
1317 -- TOC Entry ID 243 (OID 18141218)
1319 -- Name: project_history Type: TABLE Owner: tperdue
1322 CREATE TABLE project_history (
1323 project_history_id number(*) NOT NULL,
1324 project_task_id number(*) DEFAULT '0' NOT NULL,
1325 field_name varchar2(4000) DEFAULT ' ' NOT NULL,
1326 old_value varchar2(4000) DEFAULT ' ' NOT NULL,
1327 mod_by number(*) DEFAULT '0' NOT NULL,
1328 date1 number(*) DEFAULT '0' NOT NULL,
1329 PRIMARY KEY (project_history_id)
1333 -- TOC Entry ID 104 (OID 18141257)
1335 -- Name: project_metric_pk_seq Type: SEQUENCE Owner: tperdue
1338 CREATE SEQUENCE project_metric_pk_seq START WITH 1;
1341 -- TOC Entry ID 244 (OID 18141275)
1343 -- Name: project_metric Type: TABLE Owner: tperdue
1346 CREATE TABLE project_metric (
1347 ranking number(*) NOT NULL,
1348 percentile double precision,
1349 group_id number(*) DEFAULT '0' NOT NULL,
1350 PRIMARY KEY (ranking)
1354 -- TOC Entry ID 106 (OID 18141292)
1356 -- Name: project_metric_tmp1_pk_seq Type: SEQUENCE Owner: tperdue
1359 CREATE SEQUENCE project_metric_tmp1_pk_seq START WITH 1;
1362 -- TOC Entry ID 245 (OID 18141310)
1364 -- Name: project_metric_tmp1 Type: TABLE Owner: tperdue
1367 CREATE TABLE project_metric_tmp1 (
1368 ranking number(*) NOT NULL,
1369 group_id number(*) DEFAULT '0' NOT NULL,
1370 value double precision,
1371 PRIMARY KEY (ranking)
1375 -- TOC Entry ID 108 (OID 18141327)
1377 -- Name: proj_metric_weekly_tm_pk_seq Type: SEQUENCE Owner: tperdue
1380 CREATE SEQUENCE proj_metric_weekly_tm_pk_seq START WITH 1;
1383 -- TOC Entry ID 246 (OID 18141346)
1385 -- Name: project_metric_weekly_tmp1 Type: TABLE Owner: tperdue
1388 CREATE TABLE project_metric_weekly_tmp1 (
1389 ranking number(*) NOT NULL,
1390 group_id number(*) DEFAULT '0' NOT NULL,
1391 value double precision,
1392 PRIMARY KEY (ranking)
1396 -- TOC Entry ID 110 (OID 18141363)
1398 -- Name: project_status_pk_seq Type: SEQUENCE Owner: tperdue
1401 CREATE SEQUENCE project_status_pk_seq START WITH 1;
1404 -- TOC Entry ID 247 (OID 18141381)
1406 -- Name: project_status Type: TABLE Owner: tperdue
1409 CREATE TABLE project_status (
1410 status_id number(*) NOT NULL,
1411 status_name varchar2(4000) DEFAULT ' ' NOT NULL,
1412 PRIMARY KEY (status_id)
1416 -- TOC Entry ID 112 (OID 18141412)
1418 -- Name: project_task_pk_seq Type: SEQUENCE Owner: tperdue
1421 CREATE SEQUENCE project_task_pk_seq START WITH 1;
1424 -- TOC Entry ID 248 (OID 18141430)
1426 -- Name: project_task Type: TABLE Owner: tperdue
1429 CREATE TABLE project_task (
1430 project_task_id number(*) NOT NULL,
1431 group_project_id number(*) DEFAULT '0' NOT NULL,
1432 summary varchar2(4000) DEFAULT ' ' NOT NULL,
1433 details varchar2(4000) DEFAULT ' ' NOT NULL,
1434 percent_complete number(*) DEFAULT '0' NOT NULL,
1435 priority number(*) DEFAULT '0' NOT NULL,
1436 hours double precision DEFAULT '0.00' NOT NULL,
1437 start_date number(*) DEFAULT '0' NOT NULL,
1438 end_date number(*) DEFAULT '0' NOT NULL,
1439 created_by number(*) DEFAULT '0' NOT NULL,
1440 status_id number(*) DEFAULT '0' NOT NULL,
1441 PRIMARY KEY (project_task_id)
1445 -- TOC Entry ID 114 (OID 18141479)
1447 -- Name: project_weekly_metric_pk_seq Type: SEQUENCE Owner: tperdue
1450 CREATE SEQUENCE project_weekly_metric_pk_seq START WITH 1;
1453 -- TOC Entry ID 249 (OID 18141497)
1455 -- Name: project_weekly_metric Type: TABLE Owner: tperdue
1458 CREATE TABLE project_weekly_metric (
1459 ranking number(*) NOT NULL,
1460 percentile double precision,
1461 group_id number(*) DEFAULT '0' NOT NULL,
1462 PRIMARY KEY (ranking)
1466 -- TOC Entry ID 250 (OID 18141514)
1468 -- Name: session Type: TABLE Owner: tperdue
1471 CREATE TABLE session1 (
1472 user_id number(*) DEFAULT '0' NOT NULL,
1473 session_hash character(32) DEFAULT ' ' NOT NULL,
1474 ip_addr character(15) DEFAULT ' ' NOT NULL,
1475 time number(*) DEFAULT '0' NOT NULL,
1476 PRIMARY KEY (session_hash)
1480 -- TOC Entry ID 116 (OID 18141534)
1482 -- Name: snippet_pk_seq Type: SEQUENCE Owner: tperdue
1485 CREATE SEQUENCE snippet_pk_seq START WITH 1;
1488 -- TOC Entry ID 251 (OID 18141552)
1490 -- Name: snippet Type: TABLE Owner: tperdue
1493 CREATE TABLE snippet (
1494 snippet_id number(*) NOT NULL,
1495 created_by number(*) DEFAULT '0' NOT NULL,
1496 name varchar2(4000),
1497 description varchar2(4000),
1498 type number(*) DEFAULT '0' NOT NULL,
1499 language number(*) DEFAULT '0' NOT NULL,
1500 license varchar2(4000) DEFAULT ' ' NOT NULL,
1501 category number(*) DEFAULT '0' NOT NULL,
1502 PRIMARY KEY (snippet_id)
1506 -- TOC Entry ID 118 (OID 18141593)
1508 -- Name: snippet_package_pk_seq Type: SEQUENCE Owner: tperdue
1511 CREATE SEQUENCE snippet_package_pk_seq START WITH 1;
1514 -- TOC Entry ID 252 (OID 18141611)
1516 -- Name: snippet_package Type: TABLE Owner: tperdue
1519 CREATE TABLE snippet_package (
1520 snippet_package_id number(*) NOT NULL,
1521 created_by number(*) DEFAULT '0' NOT NULL,
1522 name varchar2(4000),
1523 description varchar2(4000),
1524 category number(*) DEFAULT '0' NOT NULL,
1525 language number(*) DEFAULT '0' NOT NULL,
1526 PRIMARY KEY (snippet_package_id)
1530 -- TOC Entry ID 120 (OID 18141648)
1532 -- Name: snippet_package_item_pk_seq Type: SEQUENCE Owner: tperdue
1535 CREATE SEQUENCE snippet_package_item_pk_seq START WITH 1;
1538 -- TOC Entry ID 253 (OID 18141666)
1540 -- Name: snippet_package_item Type: TABLE Owner: tperdue
1543 CREATE TABLE snippet_package_item (
1544 snippet_package_item_id number(*) NOT NULL,
1545 snippet_package_version_id number(*) DEFAULT '0' NOT NULL,
1546 snippet_version_id number(*) DEFAULT '0' NOT NULL,
1547 PRIMARY KEY (snippet_package_item_id)
1551 -- TOC Entry ID 122 (OID 18141684)
1553 -- Name: snippet_package_ver_pk_seq Type: SEQUENCE Owner: tperdue
1556 CREATE SEQUENCE snippet_package_ver_pk_seq START WITH 1;
1559 -- TOC Entry ID 254 (OID 18141702)
1561 -- Name: snippet_package_version Type: TABLE Owner: tperdue
1564 CREATE TABLE snippet_package_version (
1565 snippet_package_version_id number(*) NOT NULL,
1566 snippet_package_id number(*) DEFAULT '0' NOT NULL,
1567 changes varchar2(4000),
1568 version varchar2(4000),
1569 submitted_by number(*) DEFAULT '0' NOT NULL,
1570 date1 number(*) DEFAULT '0' NOT NULL,
1571 PRIMARY KEY (snippet_package_version_id)
1575 -- TOC Entry ID 124 (OID 18141739)
1577 -- Name: snippet_version_pk_seq Type: SEQUENCE Owner: tperdue
1580 CREATE SEQUENCE snippet_version_pk_seq START WITH 1;
1583 -- TOC Entry ID 255 (OID 18141757)
1585 -- Name: snippet_version Type: TABLE Owner: tperdue
1588 CREATE TABLE snippet_version (
1589 snippet_version_id number(*) NOT NULL,
1590 snippet_id number(*) DEFAULT '0' NOT NULL,
1591 changes varchar2(4000),
1592 version varchar2(4000),
1593 submitted_by number(*) DEFAULT '0' NOT NULL,
1594 date1 number(*) DEFAULT '0' NOT NULL,
1595 code varchar2(4000),
1596 PRIMARY KEY (snippet_version_id)
1600 -- TOC Entry ID 256 (OID 18141795)
1602 -- Name: stats_agg_logo_by_day Type: TABLE Owner: tperdue
1605 CREATE TABLE stats_agg_logo_by_day (
1611 -- TOC Entry ID 257 (OID 18141806)
1613 -- Name: stats_agg_logo_by_group Type: TABLE Owner: tperdue
1616 CREATE TABLE stats_agg_logo_by_group (
1623 -- TOC Entry ID 258 (OID 18141818)
1625 -- Name: stats_agg_pages_by_browser Type: TABLE Owner: tperdue
1628 CREATE TABLE stats_agg_pages_by_browser (
1629 browser character varying(8),
1634 -- TOC Entry ID 259 (OID 18141829)
1636 -- Name: stats_agg_pages_by_day Type: TABLE Owner: tperdue
1639 CREATE TABLE stats_agg_pages_by_day (
1640 day number(*) DEFAULT '0' NOT NULL,
1641 count number(*) DEFAULT '0' NOT NULL
1645 -- TOC Entry ID 260 (OID 18141842)
1647 -- Name: stats_agg_pages_by_day_old Type: TABLE Owner: tperdue
1650 CREATE TABLE stats_agg_pages_by_day_old (
1656 -- TOC Entry ID 261 (OID 18141853)
1658 -- Name: stats_agg_site_by_day Type: TABLE Owner: tperdue
1661 CREATE TABLE stats_agg_site_by_day (
1662 day number(*) DEFAULT '0' NOT NULL,
1663 count number(*) DEFAULT '0' NOT NULL
1667 -- TOC Entry ID 262 (OID 18141866)
1669 -- Name: stats_agg_site_by_group Type: TABLE Owner: tperdue
1672 CREATE TABLE stats_agg_site_by_group (
1673 day number(*) DEFAULT '0' NOT NULL,
1674 group_id number(*) DEFAULT '0' NOT NULL,
1675 count number(*) DEFAULT '0' NOT NULL
1679 -- TOC Entry ID 263 (OID 18141881)
1681 -- Name: stats_agr_filerelease Type: TABLE Owner: tperdue
1684 CREATE TABLE stats_agr_filerelease (
1685 filerelease_id number(*) DEFAULT '0' NOT NULL,
1686 group_id number(*) DEFAULT '0' NOT NULL,
1687 downloads number(*) DEFAULT '0' NOT NULL
1691 -- TOC Entry ID 264 (OID 18141896)
1693 -- Name: stats_agr_project Type: TABLE Owner: tperdue
1696 CREATE TABLE stats_agr_project (
1697 group_id number(*) DEFAULT '0' NOT NULL,
1698 group_ranking number(*) DEFAULT '0' NOT NULL,
1699 group_metric double precision DEFAULT '0.00000' NOT NULL,
1700 developers number(*) DEFAULT '0' NOT NULL,
1701 file_releases number(*) DEFAULT '0' NOT NULL,
1702 downloads number(*) DEFAULT '0' NOT NULL,
1703 site_views number(*) DEFAULT '0' NOT NULL,
1704 logo_views number(*) DEFAULT '0' NOT NULL,
1705 msg_posted number(*) DEFAULT '0' NOT NULL,
1706 msg_uniq_auth number(*) DEFAULT '0' NOT NULL,
1707 bugs_opened number(*) DEFAULT '0' NOT NULL,
1708 bugs_closed number(*) DEFAULT '0' NOT NULL,
1709 support_opened number(*) DEFAULT '0' NOT NULL,
1710 support_closed number(*) DEFAULT '0' NOT NULL,
1711 patches_opened number(*) DEFAULT '0' NOT NULL,
1712 patches_closed number(*) DEFAULT '0' NOT NULL,
1713 tasks_opened number(*) DEFAULT '0' NOT NULL,
1714 tasks_closed number(*) DEFAULT '0' NOT NULL,
1715 help_requests number(*) DEFAULT '0' NOT NULL,
1716 cvs_checkouts number(*) DEFAULT '0' NOT NULL,
1717 cvs_commits number(*) DEFAULT '0' NOT NULL,
1718 cvs_adds number(*) DEFAULT '0' NOT NULL
1722 -- TOC Entry ID 265 (OID 18141949)
1724 -- Name: stats_ftp_downloads Type: TABLE Owner: tperdue
1727 CREATE TABLE stats_ftp_downloads (
1728 day number(*) DEFAULT '0' NOT NULL,
1729 filerelease_id number(*) DEFAULT '0' NOT NULL,
1730 group_id number(*) DEFAULT '0' NOT NULL,
1731 downloads number(*) DEFAULT '0' NOT NULL
1735 -- TOC Entry ID 266 (OID 18141966)
1737 -- Name: stats_http_downloads Type: TABLE Owner: tperdue
1740 CREATE TABLE stats_http_downloads (
1741 day number(*) DEFAULT '0' NOT NULL,
1742 filerelease_id number(*) DEFAULT '0' NOT NULL,
1743 group_id number(*) DEFAULT '0' NOT NULL,
1744 downloads number(*) DEFAULT '0' NOT NULL
1748 -- TOC Entry ID 267 (OID 18141983)
1750 -- Name: stats_project Type: TABLE Owner: tperdue
1753 CREATE TABLE stats_project (
1754 month number(*) DEFAULT '0' NOT NULL,
1755 week number(*) DEFAULT '0' NOT NULL,
1756 day number(*) DEFAULT '0' NOT NULL,
1757 group_id number(*) DEFAULT '0' NOT NULL,
1758 group_ranking number(*) DEFAULT '0' NOT NULL,
1759 group_metric double precision DEFAULT '0.00000' NOT NULL,
1760 developers number(*) DEFAULT '0' NOT NULL,
1761 file_releases number(*) DEFAULT '0' NOT NULL,
1762 downloads number(*) DEFAULT '0' NOT NULL,
1763 site_views number(*) DEFAULT '0' NOT NULL,
1764 subdomain_views number(*) DEFAULT '0' NOT NULL,
1765 msg_posted number(*) DEFAULT '0' NOT NULL,
1766 msg_uniq_auth number(*) DEFAULT '0' NOT NULL,
1767 bugs_opened number(*) DEFAULT '0' NOT NULL,
1768 bugs_closed number(*) DEFAULT '0' NOT NULL,
1769 support_opened number(*) DEFAULT '0' NOT NULL,
1770 support_closed number(*) DEFAULT '0' NOT NULL,
1771 patches_opened number(*) DEFAULT '0' NOT NULL,
1772 patches_closed number(*) DEFAULT '0' NOT NULL,
1773 tasks_opened number(*) DEFAULT '0' NOT NULL,
1774 tasks_closed number(*) DEFAULT '0' NOT NULL,
1775 help_requests number(*) DEFAULT '0' NOT NULL,
1776 cvs_checkouts number(*) DEFAULT '0' NOT NULL,
1777 cvs_commits number(*) DEFAULT '0' NOT NULL,
1778 cvs_adds number(*) DEFAULT '0' NOT NULL
1782 -- TOC Entry ID 268 (OID 18142042)
1784 -- Name: stats_project_tmp Type: TABLE Owner: tperdue
1787 CREATE TABLE stats_project_tmp (
1788 month number(*) DEFAULT '0' NOT NULL,
1789 week number(*) DEFAULT '0' NOT NULL,
1790 day number(*) DEFAULT '0' NOT NULL,
1791 group_id number(*) DEFAULT '0' NOT NULL,
1792 group_ranking number(*) DEFAULT '0' NOT NULL,
1793 group_metric double precision DEFAULT '0.00000' NOT NULL,
1794 developers number(*) DEFAULT '0' NOT NULL,
1795 file_releases number(*) DEFAULT '0' NOT NULL,
1796 downloads number(*) DEFAULT '0' NOT NULL,
1797 site_views number(*) DEFAULT '0' NOT NULL,
1798 subdomain_views number(*) DEFAULT '0' NOT NULL,
1799 msg_posted number(*) DEFAULT '0' NOT NULL,
1800 msg_uniq_auth number(*) DEFAULT '0' NOT NULL,
1801 bugs_opened number(*) DEFAULT '0' NOT NULL,
1802 bugs_closed number(*) DEFAULT '0' NOT NULL,
1803 support_opened number(*) DEFAULT '0' NOT NULL,
1804 support_closed number(*) DEFAULT '0' NOT NULL,
1805 patches_opened number(*) DEFAULT '0' NOT NULL,
1806 patches_closed number(*) DEFAULT '0' NOT NULL,
1807 tasks_opened number(*) DEFAULT '0' NOT NULL,
1808 tasks_closed number(*) DEFAULT '0' NOT NULL,
1809 help_requests number(*) DEFAULT '0' NOT NULL,
1810 cvs_checkouts number(*) DEFAULT '0' NOT NULL,
1811 cvs_commits number(*) DEFAULT '0' NOT NULL,
1812 cvs_adds number(*) DEFAULT '0' NOT NULL
1816 -- TOC Entry ID 269 (OID 18142101)
1818 -- Name: stats_site Type: TABLE Owner: tperdue
1821 CREATE TABLE stats_site (
1822 month number(*) DEFAULT '0' NOT NULL,
1823 week number(*) DEFAULT '0' NOT NULL,
1824 day number(*) DEFAULT '0' NOT NULL,
1825 site_views number(*) DEFAULT '0' NOT NULL,
1826 subdomain_views number(*) DEFAULT '0' NOT NULL,
1827 downloads number(*) DEFAULT '0' NOT NULL,
1828 uniq_users number(*) DEFAULT '0' NOT NULL,
1829 sessions number(*) DEFAULT '0' NOT NULL,
1830 total_users number(*) DEFAULT '0' NOT NULL,
1831 new_users number(*) DEFAULT '0' NOT NULL,
1832 new_projects number(*) DEFAULT '0' NOT NULL
1836 -- TOC Entry ID 126 (OID 18142132)
1838 -- Name: support_pk_seq Type: SEQUENCE Owner: tperdue
1841 CREATE SEQUENCE support_pk_seq START WITH 1;
1844 -- TOC Entry ID 270 (OID 18142150)
1846 -- Name: support Type: TABLE Owner: tperdue
1849 CREATE TABLE support (
1850 support_id number(*) NOT NULL,
1851 group_id number(*) DEFAULT '0' NOT NULL,
1852 support_status_id number(*) DEFAULT '0' NOT NULL,
1853 support_category_id number(*) DEFAULT '0' NOT NULL,
1854 priority number(*) DEFAULT '0' NOT NULL,
1855 submitted_by number(*) DEFAULT '0' NOT NULL,
1856 assigned_to number(*) DEFAULT '0' NOT NULL,
1857 open_date number(*) DEFAULT '0' NOT NULL,
1858 summary varchar2(4000),
1859 close_date number(*) DEFAULT '0' NOT NULL,
1860 PRIMARY KEY (support_id)
1864 -- TOC Entry ID 128 (OID 18142196)
1866 -- Name: support_canned_res_pk_seq Type: SEQUENCE Owner: tperdue
1869 CREATE SEQUENCE support_canned_res_pk_seq START WITH 1;
1872 -- TOC Entry ID 271 (OID 18142214)
1874 -- Name: support_canned_responses Type: TABLE Owner: tperdue
1877 CREATE TABLE support_canned_responses (
1878 support_canned_id number(*) NOT NULL,
1879 group_id number(*) DEFAULT '0' NOT NULL,
1880 title varchar2(4000),
1881 body varchar2(4000),
1882 PRIMARY KEY (support_canned_id)
1886 -- TOC Entry ID 130 (OID 18142247)
1888 -- Name: support_category_pk_seq Type: SEQUENCE Owner: tperdue
1891 CREATE SEQUENCE support_category_pk_seq START WITH 1;
1894 -- TOC Entry ID 272 (OID 18142265)
1896 -- Name: support_category Type: TABLE Owner: tperdue
1899 CREATE TABLE support_category (
1900 support_category_id number(*) NOT NULL,
1901 group_id number(*) DEFAULT '0' NOT NULL,
1902 category_name varchar2(4000) DEFAULT ' ' NOT NULL,
1903 PRIMARY KEY (support_category_id)
1907 -- TOC Entry ID 132 (OID 18142298)
1909 -- Name: support_history_pk_seq Type: SEQUENCE Owner: tperdue
1912 CREATE SEQUENCE support_history_pk_seq START WITH 1;
1915 -- TOC Entry ID 273 (OID 18142316)
1917 -- Name: support_history Type: TABLE Owner: tperdue
1920 CREATE TABLE support_history (
1921 support_history_id number(*) NOT NULL,
1922 support_id number(*) DEFAULT '0' NOT NULL,
1923 field_name varchar2(4000) DEFAULT ' ' NOT NULL,
1924 old_value varchar2(4000) DEFAULT ' ' NOT NULL,
1925 mod_by number(*) DEFAULT '0' NOT NULL,
1927 PRIMARY KEY (support_history_id)
1931 -- TOC Entry ID 134 (OID 18142354)
1933 -- Name: support_messages_pk_seq Type: SEQUENCE Owner: tperdue
1936 CREATE SEQUENCE support_messages_pk_seq START WITH 1;
1939 -- TOC Entry ID 274 (OID 18142372)
1941 -- Name: support_messages Type: TABLE Owner: tperdue
1944 CREATE TABLE support_messages (
1945 support_message_id number(*) NOT NULL,
1946 support_id number(*) DEFAULT '0' NOT NULL,
1947 from_email varchar2(4000),
1948 date1 number(*) DEFAULT '0' NOT NULL,
1949 body varchar2(4000),
1950 PRIMARY KEY (support_message_id)
1954 -- TOC Entry ID 136 (OID 18142407)
1956 -- Name: support_status_pk_seq Type: SEQUENCE Owner: tperdue
1959 CREATE SEQUENCE support_status_pk_seq START WITH 1;
1962 -- TOC Entry ID 275 (OID 18142425)
1964 -- Name: support_status Type: TABLE Owner: tperdue
1967 CREATE TABLE support_status (
1968 support_status_id number(*) NOT NULL,
1969 status_name varchar2(4000),
1970 PRIMARY KEY (support_status_id)
1974 -- TOC Entry ID 138 (OID 18142455)
1976 -- Name: supported_languages_pk_seq Type: SEQUENCE Owner: tperdue
1979 CREATE SEQUENCE supported_languages_pk_seq START WITH 1;
1982 -- TOC Entry ID 276 (OID 18142473)
1984 -- Name: supported_languages Type: TABLE Owner: tperdue
1987 CREATE TABLE supported_languages (
1988 language_id number(*) NOT NULL,
1989 name varchar2(4000),
1990 filename varchar2(4000),
1991 classname varchar2(4000),
1992 language_code character(2),
1993 PRIMARY KEY (language_id)
1997 -- TOC Entry ID 140 (OID 18142506)
1999 -- Name: survey_question_types_pk_seq Type: SEQUENCE Owner: tperdue
2002 CREATE SEQUENCE survey_question_types_pk_seq START WITH 1;
2005 -- TOC Entry ID 277 (OID 18142524)
2007 -- Name: survey_question_types Type: TABLE Owner: tperdue
2010 CREATE TABLE survey_question_types (
2011 id number(*) NOT NULL,
2012 type varchar2(4000) DEFAULT ' ' NOT NULL,
2017 -- TOC Entry ID 142 (OID 18142555)
2019 -- Name: survey_questions_pk_seq Type: SEQUENCE Owner: tperdue
2022 CREATE SEQUENCE survey_questions_pk_seq START WITH 1;
2025 -- TOC Entry ID 278 (OID 18142573)
2027 -- Name: survey_questions Type: TABLE Owner: tperdue
2030 CREATE TABLE survey_questions (
2031 question_id number(*) NOT NULL,
2032 group_id number(*) DEFAULT '0' NOT NULL,
2033 question varchar2(4000) DEFAULT ' ' NOT NULL,
2034 question_type number(*) DEFAULT '0' NOT NULL,
2035 PRIMARY KEY (question_id)
2039 -- TOC Entry ID 279 (OID 18142608)
2041 -- Name: survey_rating_aggregate Type: TABLE Owner: tperdue
2044 CREATE TABLE survey_rating_aggregate (
2045 type number(*) DEFAULT '0' NOT NULL,
2046 id number(*) DEFAULT '0' NOT NULL,
2047 response double precision DEFAULT '0' NOT NULL,
2048 count number(*) DEFAULT '0' NOT NULL
2052 -- TOC Entry ID 280 (OID 18142625)
2054 -- Name: survey_rating_response Type: TABLE Owner: tperdue
2057 CREATE TABLE survey_rating_response (
2058 user_id number(*) DEFAULT '0' NOT NULL,
2059 type number(*) DEFAULT '0' NOT NULL,
2060 id number(*) DEFAULT '0' NOT NULL,
2061 response number(*) DEFAULT '0' NOT NULL,
2062 date1 number(*) DEFAULT '0' NOT NULL
2066 -- TOC Entry ID 281 (OID 18142644)
2068 -- Name: survey_responses Type: TABLE Owner: tperdue
2071 CREATE TABLE survey_responses (
2072 user_id number(*) DEFAULT '0' NOT NULL,
2073 group_id number(*) DEFAULT '0' NOT NULL,
2074 survey_id number(*) DEFAULT '0' NOT NULL,
2075 question_id number(*) DEFAULT '0' NOT NULL,
2076 response varchar2(4000) DEFAULT ' ' NOT NULL,
2077 date1 number(*) DEFAULT '0' NOT NULL
2081 -- TOC Entry ID 144 (OID 18142680)
2083 -- Name: surveys_pk_seq Type: SEQUENCE Owner: tperdue
2086 CREATE SEQUENCE surveys_pk_seq START WITH 1;
2089 -- TOC Entry ID 282 (OID 18142698)
2091 -- Name: surveys Type: TABLE Owner: tperdue
2094 CREATE TABLE surveys (
2095 survey_id number(*) NOT NULL,
2096 group_id number(*) DEFAULT '0' NOT NULL,
2097 survey_title varchar2(4000) DEFAULT ' ' NOT NULL,
2098 survey_questions varchar2(4000) DEFAULT ' ' NOT NULL,
2099 is_active number(*) DEFAULT '1' NOT NULL,
2100 PRIMARY KEY (survey_id)
2104 -- TOC Entry ID 146 (OID 18142735)
2106 -- Name: system_history_pk_seq Type: SEQUENCE Owner: tperdue
2109 CREATE SEQUENCE system_history_pk_seq START WITH 1;
2112 -- TOC Entry ID 148 (OID 18142787)
2114 -- Name: system_machines_pk_seq Type: SEQUENCE Owner: tperdue
2117 CREATE SEQUENCE system_machines_pk_seq START WITH 1;
2120 -- TOC Entry ID 150 (OID 18142836)
2122 -- Name: system_news_pk_seq Type: SEQUENCE Owner: tperdue
2125 CREATE SEQUENCE system_news_pk_seq START WITH 1;
2128 -- TOC Entry ID 152 (OID 18142895)
2130 -- Name: system_services_pk_seq Type: SEQUENCE Owner: tperdue
2133 CREATE SEQUENCE system_services_pk_seq START WITH 1;
2136 -- TOC Entry ID 154 (OID 18142944)
2138 -- Name: system_status_pk_seq Type: SEQUENCE Owner: tperdue
2141 CREATE SEQUENCE system_status_pk_seq START WITH 1;
2144 -- TOC Entry ID 283 (OID 18142992)
2146 -- Name: theme_prefs Type: TABLE Owner: tperdue
2149 CREATE TABLE theme_prefs (
2150 user_id number(*) DEFAULT '0' NOT NULL,
2151 user_theme number(*) DEFAULT '0' NOT NULL,
2152 body_font character(80) DEFAULT '',
2153 body_size character(5) DEFAULT '',
2154 titlebar_font character(80) DEFAULT '',
2155 titlebar_size character(5) DEFAULT '',
2156 color_titlebar_back character(7) DEFAULT '',
2157 color_ltback1 character(7) DEFAULT '',
2158 PRIMARY KEY (user_id)
2162 -- TOC Entry ID 156 (OID 18143020)
2164 -- Name: themes_pk_seq Type: SEQUENCE Owner: tperdue
2167 CREATE SEQUENCE themes_pk_seq START WITH 1;
2170 -- TOC Entry ID 284 (OID 18143038)
2172 -- Name: themes Type: TABLE Owner: tperdue
2175 CREATE TABLE themes (
2176 theme_id number(*) NOT NULL,
2177 dirname character varying(80),
2178 fullname character varying(80),
2179 PRIMARY KEY (theme_id)
2183 -- TOC Entry ID 285 (OID 18143054)
2185 -- Name: tmp_projs_releases_tmp Type: TABLE Owner: tperdue
2188 CREATE TABLE tmp_projs_releases_tmp (
2189 year number(*) DEFAULT '0' NOT NULL,
2190 month number(*) DEFAULT '0' NOT NULL,
2191 total_proj number(*) DEFAULT '0' NOT NULL,
2192 total_releases number(*) DEFAULT '0' NOT NULL
2196 -- TOC Entry ID 286 (OID 18143071)
2198 -- Name: top_group Type: TABLE Owner: tperdue
2201 CREATE TABLE top_group (
2202 group_id number(*) DEFAULT '0' NOT NULL,
2203 group_name character varying(40),
2204 downloads_all number(*) DEFAULT '0' NOT NULL,
2205 rank_downloads_all number(*) DEFAULT '0' NOT NULL,
2206 rank_downloads_all_old number(*) DEFAULT '0' NOT NULL,
2207 downloads_week number(*) DEFAULT '0' NOT NULL,
2208 rank_downloads_week number(*) DEFAULT '0' NOT NULL,
2209 rank_downloads_week_old number(*) DEFAULT '0' NOT NULL,
2210 userrank number(*) DEFAULT '0' NOT NULL,
2211 rank_userrank number(*) DEFAULT '0' NOT NULL,
2212 rank_userrank_old number(*) DEFAULT '0' NOT NULL,
2213 forumposts_week number(*) DEFAULT '0' NOT NULL,
2214 rank_forumposts_week number(*) DEFAULT '0' NOT NULL,
2215 rank_forumposts_week_old number(*) DEFAULT '0' NOT NULL,
2216 pageviews_proj number(*) DEFAULT '0' NOT NULL,
2217 rank_pageviews_proj number(*) DEFAULT '0' NOT NULL,
2218 rank_pageviews_proj_old number(*) DEFAULT '0' NOT NULL
2222 -- TOC Entry ID 158 (OID 18143113)
2224 -- Name: trove_cat_pk_seq Type: SEQUENCE Owner: tperdue
2227 CREATE SEQUENCE trove_cat_pk_seq START WITH 1;
2230 -- TOC Entry ID 287 (OID 18143131)
2232 -- Name: trove_cat Type: TABLE Owner: tperdue
2235 CREATE TABLE trove_cat (
2236 trove_cat_id number(*) NOT NULL,
2237 version number(*) DEFAULT '0' NOT NULL,
2238 parent number(*) DEFAULT '0' NOT NULL,
2239 root_parent number(*) DEFAULT '0' NOT NULL,
2240 shortname character varying(80),
2241 fullname character varying(80),
2242 description character varying(255),
2243 count_subcat number(*) DEFAULT '0' NOT NULL,
2244 count_subproj number(*) DEFAULT '0' NOT NULL,
2245 fullpath varchar2(4000) DEFAULT ' ' NOT NULL,
2246 fullpath_ids varchar2(4000),
2247 PRIMARY KEY (trove_cat_id)
2251 -- TOC Entry ID 160 (OID 18143176)
2253 -- Name: trove_group_link_pk_seq Type: SEQUENCE Owner: tperdue
2256 CREATE SEQUENCE trove_group_link_pk_seq START WITH 1;
2259 -- TOC Entry ID 288 (OID 18143194)
2261 -- Name: trove_group_link Type: TABLE Owner: tperdue
2264 CREATE TABLE trove_group_link (
2265 trove_group_id number(*) NOT NULL,
2266 trove_cat_id number(*) DEFAULT '0' NOT NULL,
2267 trove_cat_version number(*) DEFAULT '0' NOT NULL,
2268 group_id number(*) DEFAULT '0' NOT NULL,
2269 trove_cat_root number(*) DEFAULT '0' NOT NULL,
2270 PRIMARY KEY (trove_group_id)
2274 -- TOC Entry ID 162 (OID 18143216)
2276 -- Name: trove_treesums_pk_seq Type: SEQUENCE Owner: tperdue
2279 CREATE SEQUENCE trove_treesums_pk_seq START WITH 1;
2282 -- TOC Entry ID 289 (OID 18143234)
2284 -- Name: trove_treesums Type: TABLE Owner: tperdue
2287 CREATE TABLE trove_treesums (
2288 trove_treesums_id number(*) NOT NULL,
2289 trove_cat_id number(*) DEFAULT '0' NOT NULL,
2290 limit_1 number(*) DEFAULT '0' NOT NULL,
2291 subprojects number(*) DEFAULT '0' NOT NULL,
2292 PRIMARY KEY (trove_treesums_id)
2296 -- TOC Entry ID 164 (OID 18143286)
2298 -- Name: user_bookmarks_pk_seq Type: SEQUENCE Owner: tperdue
2301 CREATE SEQUENCE user_bookmarks_pk_seq START WITH 1;
2304 -- TOC Entry ID 290 (OID 18143304)
2306 -- Name: user_bookmarks Type: TABLE Owner: tperdue
2309 CREATE TABLE user_bookmarks (
2310 bookmark_id number(*) NOT NULL,
2311 user_id number(*) DEFAULT '0' NOT NULL,
2312 bookmark_url varchar2(4000),
2313 bookmark_title varchar2(4000),
2314 PRIMARY KEY (bookmark_id)
2318 -- TOC Entry ID 166 (OID 18143337)
2320 -- Name: user_diary_pk_seq Type: SEQUENCE Owner: tperdue
2323 CREATE SEQUENCE user_diary_pk_seq START WITH 1;
2326 -- TOC Entry ID 291 (OID 18143355)
2328 -- Name: user_diary Type: TABLE Owner: tperdue
2331 CREATE TABLE user_diary (
2332 id number(*) NOT NULL,
2333 user_id number(*) DEFAULT '0' NOT NULL,
2334 date_posted number(*) DEFAULT '0' NOT NULL,
2335 summary varchar2(4000),
2336 details varchar2(4000),
2337 is_public number(*) DEFAULT '0' NOT NULL,
2342 -- TOC Entry ID 168 (OID 18143392)
2344 -- Name: user_diary_monitor_pk_seq Type: SEQUENCE Owner: tperdue
2347 CREATE SEQUENCE user_diary_monitor_pk_seq START WITH 1;
2350 -- TOC Entry ID 292 (OID 18143410)
2352 -- Name: user_diary_monitor Type: TABLE Owner: tperdue
2355 CREATE TABLE user_diary_monitor (
2356 monitor_id number(*) NOT NULL,
2357 monitored_user number(*) DEFAULT '0' NOT NULL,
2358 user_id number(*) DEFAULT '0' NOT NULL,
2359 PRIMARY KEY (monitor_id)
2363 -- TOC Entry ID 170 (OID 18143428)
2365 -- Name: user_group_pk_seq Type: SEQUENCE Owner: tperdue
2368 CREATE SEQUENCE user_group_pk_seq START WITH 1;
2371 -- TOC Entry ID 293 (OID 18143446)
2373 -- Name: user_group Type: TABLE Owner: tperdue
2376 CREATE TABLE user_group (
2377 user_group_id number(*) NOT NULL,
2378 user_id number(*) DEFAULT '0' NOT NULL,
2379 group_id number(*) DEFAULT '0' NOT NULL,
2380 admin_flags character(16) DEFAULT ' ' NOT NULL,
2381 bug_flags number(*) DEFAULT '0' NOT NULL,
2382 forum_flags number(*) DEFAULT '0' NOT NULL,
2383 project_flags number(*) DEFAULT '2' NOT NULL,
2384 patch_flags number(*) DEFAULT '1' NOT NULL,
2385 support_flags number(*) DEFAULT '1' NOT NULL,
2386 doc_flags number(*) DEFAULT '0' NOT NULL,
2387 cvs_flags number(*) DEFAULT '1' NOT NULL,
2388 member_role number(*) DEFAULT '100' NOT NULL,
2389 release_flags number(*) DEFAULT '0' NOT NULL,
2390 PRIMARY KEY (user_group_id)
2394 -- TOC Entry ID 172 (OID 18143484)
2396 -- Name: user_metric_pk_seq Type: SEQUENCE Owner: tperdue
2399 CREATE SEQUENCE user_metric_pk_seq START WITH 1;
2402 -- TOC Entry ID 294 (OID 18143502)
2404 -- Name: user_metric Type: TABLE Owner: tperdue
2407 CREATE TABLE user_metric (
2408 ranking number(*) NOT NULL,
2409 user_id number(*) DEFAULT '0' NOT NULL,
2410 times_ranked number(*) DEFAULT '0' NOT NULL,
2411 avg_raters_importance double precision DEFAULT '0.00000000' NOT NULL,
2412 avg_rating double precision DEFAULT '0.00000000' NOT NULL,
2413 metric double precision DEFAULT '0.00000000' NOT NULL,
2414 percentile double precision DEFAULT '0.00000000' NOT NULL,
2415 importance_factor double precision DEFAULT '0.00000000' NOT NULL,
2416 PRIMARY KEY (ranking)
2420 -- TOC Entry ID 174 (OID 18143530)
2422 -- Name: user_metric0_pk_seq Type: SEQUENCE Owner: tperdue
2425 CREATE SEQUENCE user_metric0_pk_seq START WITH 1;
2428 -- TOC Entry ID 295 (OID 18143548)
2430 -- Name: user_metric0 Type: TABLE Owner: tperdue
2433 CREATE TABLE user_metric0 (
2434 ranking number(*) NOT NULL,
2435 user_id number(*) DEFAULT '0' NOT NULL,
2436 times_ranked number(*) DEFAULT '0' NOT NULL,
2437 avg_raters_importance double precision DEFAULT '0.00000000' NOT NULL,
2438 avg_rating double precision DEFAULT '0.00000000' NOT NULL,
2439 metric double precision DEFAULT '0.00000000' NOT NULL,
2440 percentile double precision DEFAULT '0.00000000' NOT NULL,
2441 importance_factor double precision DEFAULT '0.00000000' NOT NULL,
2442 PRIMARY KEY (ranking)
2446 -- TOC Entry ID 296 (OID 18143576)
2448 -- Name: user_preferences Type: TABLE Owner: tperdue
2451 CREATE TABLE user_preferences (
2452 user_id number(*) DEFAULT '0' NOT NULL,
2453 preference_name character varying(20),
2454 preference_value character varying(20),
2455 set_date number(*) DEFAULT '0' NOT NULL
2459 -- TOC Entry ID 297 (OID 18143591)
2461 -- Name: user_ratings Type: TABLE Owner: tperdue
2464 CREATE TABLE user_ratings (
2465 rated_by number(*) DEFAULT '0' NOT NULL,
2466 user_id number(*) DEFAULT '0' NOT NULL,
2467 rate_field number(*) DEFAULT '0' NOT NULL,
2468 rating number(*) DEFAULT '0' NOT NULL
2472 -- TOC Entry ID 176 (OID 18143608)
2474 -- Name: users_pk_seq Type: SEQUENCE Owner: tperdue
2477 CREATE SEQUENCE users_pk_seq START WITH 1;
2480 -- TOC Entry ID 298 (OID 18143626)
2482 -- Name: users Type: TABLE Owner: tperdue
2485 CREATE TABLE users (
2486 user_id number(*) NOT NULL,
2487 user_name varchar2(200) DEFAULT ' ' NOT NULL,
2488 email varchar2(4000) DEFAULT ' ' NOT NULL,
2489 user_pw character varying(32) DEFAULT ' ' NOT NULL,
2490 realname character varying(32) DEFAULT ' ' NOT NULL,
2491 status character(1) DEFAULT 'A' NOT NULL,
2492 shell character varying(20) DEFAULT '/bin/bash' NOT NULL,
2493 unix_pw character varying(40) DEFAULT ' ' NOT NULL,
2494 unix_status character(1) DEFAULT 'N' NOT NULL,
2495 unix_uid number(*) DEFAULT '0' NOT NULL,
2496 unix_box character varying(10) DEFAULT 'shell1' NOT NULL,
2497 add_date number(*) DEFAULT '0' NOT NULL,
2498 confirm_hash character varying(32),
2499 mail_siteupdates number(*) DEFAULT '0' NOT NULL,
2500 mail_va number(*) DEFAULT '0' NOT NULL,
2501 authorized_keys varchar2(4000),
2502 email_new varchar2(4000),
2503 people_view_skills number(*) DEFAULT '0' NOT NULL,
2504 people_resume varchar2(4000) DEFAULT ' ' NOT NULL,
2505 timezone character varying(64) DEFAULT 'GMT',
2506 language number(*) DEFAULT '1' NOT NULL,
2507 PRIMARY KEY (user_id)
2511 -- TOC Entry ID 178 (OID 27311232)
2513 -- Name: unix_uid_seq Type: SEQUENCE Owner: tperdue
2516 CREATE SEQUENCE unix_uid_seq START WITH 1;
2519 -- TOC Entry ID 180 (OID 27311250)
2521 -- Name: forum_thread_seq Type: SEQUENCE Owner: tperdue
2524 CREATE SEQUENCE forum_thread_seq START WITH 1;
2527 -- TOC Entry ID 299 (OID 27311451)
2529 -- Name: trove_agg Type: TABLE Owner: tperdue
2532 CREATE TABLE trove_agg (
2533 trove_cat_id number(*),
2535 group_name character varying(40),
2536 unix_group_name character varying(30),
2537 status character(1),
2538 register_time number(*),
2539 short_description character varying(255),
2540 percentile double precision,
2545 -- TOC Entry ID 302 (OID 30136736)
2547 -- Name: activity_log Type: TABLE Owner: www
2550 CREATE TABLE activity_log (
2551 day number(*) DEFAULT '0' NOT NULL,
2552 hour number(*) DEFAULT '0' NOT NULL,
2553 group_id number(*) DEFAULT '0' NOT NULL,
2554 browser character varying(8) DEFAULT 'OTHER' NOT NULL,
2555 ver double precision DEFAULT '0.00' NOT NULL,
2556 platform character varying(8) DEFAULT 'OTHER' NOT NULL,
2557 time number(*) DEFAULT '0' NOT NULL,
2558 page varchar2(4000),
2559 type number(*) DEFAULT '0' NOT NULL
2562 --\connect - tperdue
2564 -- TOC Entry ID 316 (OID 18138445)
2566 -- Name: bug_group_id Type: INDEX Owner: tperdue
2569 CREATE INDEX bug_group_id on bug ( group_id );
2572 -- TOC Entry ID 466 (OID 18138445)
2574 -- Name: bug_groupid_statusid Type: INDEX Owner: tperdue
2577 CREATE INDEX bug_groupid_statusid on bug ( group_id, status_id );
2580 -- TOC Entry ID 467 (OID 18138445)
2582 -- Name: bug_groupid_assign_statusid Type: INDEX Owner: tperdue
2585 CREATE INDEX bug_groupid_assign_statusid on bug ( group_id, assigned_to, status_id );
2588 -- TOC Entry ID 317 (OID 18138513)
2590 -- Name: bug_bug_dependencies_bug_id Type: INDEX Owner: tperdue
2593 CREATE INDEX bug_bug_dependencies_bug_id on bug_bug_dependencies ( bug_id );
2596 -- TOC Entry ID 318 (OID 18138513)
2598 -- Name: bug_bug_dependent_on_task_id Type: INDEX Owner: tperdue
2601 CREATE INDEX bug_bug_dependent_on_task_id on bug_bug_dependencies ( is_dependent_on_bug_id );
2604 -- TOC Entry ID 319 (OID 18138549)
2606 -- Name: bug_canned_response_group_id Type: INDEX Owner: tperdue
2609 CREATE INDEX bug_canned_response_group_id on bug_canned_responses ( group_id );
2612 -- TOC Entry ID 320 (OID 18138600)
2614 -- Name: bug_category_group_id Type: INDEX Owner: tperdue
2617 CREATE INDEX bug_category_group_id on bug_category ( group_id );
2620 -- TOC Entry ID 321 (OID 18138705)
2622 -- Name: bug_group_group_id Type: INDEX Owner: tperdue
2625 CREATE INDEX bug_group_group_id on bug_group ( group_id );
2628 -- TOC Entry ID 322 (OID 18138756)
2630 -- Name: bug_history_bug_id Type: INDEX Owner: tperdue
2633 CREATE INDEX bug_history_bug_id on bug_history ( bug_id );
2636 -- TOC Entry ID 323 (OID 18138909)
2638 -- Name: bug_task_dependencies_bug_id Type: INDEX Owner: tperdue
2641 CREATE INDEX bug_task_dependencies_bug_id on bug_task_dependencies ( bug_id );
2644 -- TOC Entry ID 324 (OID 18138909)
2646 -- Name: bug_task_dependent_on_task_i Type: INDEX Owner: tperdue
2649 CREATE INDEX bug_task_dependent_on_task_i on bug_task_dependencies ( is_dependent_on_task_id );
2652 -- TOC Entry ID 325 (OID 18138995)
2654 -- Name: db_images_group Type: INDEX Owner: tperdue
2657 CREATE INDEX db_images_group on db_images ( group_id );
2660 -- TOC Entry ID 326 (OID 18139058)
2662 -- Name: doc_group_doc_group Type: INDEX Owner: tperdue
2665 CREATE INDEX doc_group_doc_group on doc_data ( doc_group );
2668 -- TOC Entry ID 327 (OID 18139122)
2670 -- Name: doc_groups_group Type: INDEX Owner: tperdue
2673 CREATE INDEX doc_groups_group on doc_groups ( group_id );
2676 -- TOC Entry ID 328 (OID 18139192)
2678 -- Name: filemodule_monitor_id Type: INDEX Owner: tperdue
2681 CREATE INDEX filemodule_monitor_id on filemodule_monitor ( filemodule_id );
2684 -- TOC Entry ID 329 (OID 18139228)
2686 -- Name: forum_forumid_msgid Type: INDEX Owner: tperdue
2689 CREATE INDEX forum_forumid_msgid on forum ( group_forum_id, msg_id );
2692 -- TOC Entry ID 330 (OID 18139228)
2694 -- Name: forum_group_forum_id Type: INDEX Owner: tperdue
2697 CREATE INDEX forum_group_forum_id on forum ( group_forum_id );
2700 -- TOC Entry ID 331 (OID 18139228)
2702 -- Name: forum_forumid_isfollowupto Type: INDEX Owner: tperdue
2705 CREATE INDEX forum_forumid_isfollowupto on forum ( group_forum_id, is_followup_to );
2708 -- TOC Entry ID 332 (OID 18139228)
2710 -- Name: forum_forumid_threadid_mrec Type: INDEX Owner: tperdue
2713 CREATE INDEX forum_forumid_threadid_mrec on forum ( group_forum_id, thread_id, most_recent_date );
2716 -- TOC Entry ID 333 (OID 18139228)
2718 -- Name: forum_threadid_isfollowupto Type: INDEX Owner: tperdue
2721 CREATE INDEX forum_threadid_isfollowupto on forum ( thread_id, is_followup_to );
2724 -- TOC Entry ID 334 (OID 18139228)
2726 -- Name: forum_forumid_isfollto_mrec Type: INDEX Owner: tperdue
2729 CREATE INDEX forum_forumid_isfollto_mrec on forum ( group_forum_id, is_followup_to, most_recent_date );
2732 -- TOC Entry ID 335 (OID 18139309)
2734 -- Name: forum_group_list_group_id Type: INDEX Owner: tperdue
2737 CREATE INDEX forum_group_list_group_id on forum_group_list ( group_id );
2740 -- TOC Entry ID 336 (OID 18139366)
2742 -- Name: forum_monitor_combo_id Type: INDEX Owner: tperdue
2745 CREATE INDEX forum_monitor_combo_id on forum_monitored_forums ( forum_id, user_id );
2748 -- TOC Entry ID 337 (OID 18139366)
2750 -- Name: forum_monitor_thread_id Type: INDEX Owner: tperdue
2753 CREATE INDEX forum_monitor_thread_id on forum_monitored_forums ( forum_id );
2756 -- TOC Entry ID 338 (OID 18139510)
2758 -- Name: foundry_news_foundry_app_d Type: INDEX Owner: tperdue
2761 CREATE INDEX foundry_news_foundry_app_d on foundry_news ( foundry_id, is_approved, approve_date );
2764 -- TOC Entry ID 339 (OID 18139510)
2766 -- Name: foundry_news_foundry_approved Type: INDEX Owner: tperdue
2769 CREATE INDEX foundry_news_foundry_approved on foundry_news ( foundry_id, is_approved );
2772 -- TOC Entry ID 340 (OID 18139510)
2774 -- Name: foundry_news_foundry Type: INDEX Owner: tperdue
2777 CREATE INDEX foundry_news_foundry on foundry_news ( foundry_id );
2780 -- TOC Entry ID 463 (OID 18139510)
2782 -- Name: foundrynews_foundry_date_app Type: INDEX Owner: tperdue
2785 CREATE INDEX foundrynews_foundry_date_app on foundry_news ( foundry_id, approve_date, is_approved );
2788 -- TOC Entry ID 341 (OID 18139550)
2790 -- Name: foundry_project_group_rank Type: INDEX Owner: tperdue
2793 CREATE INDEX foundry_project_group_rank on foundry_preferred_projects ( group_id, rank );
2796 -- TOC Entry ID 342 (OID 18139550)
2798 -- Name: foundry_project_group Type: INDEX Owner: tperdue
2801 CREATE INDEX foundry_project_group on foundry_preferred_projects ( group_id );
2804 -- TOC Entry ID 343 (OID 18139588)
2806 -- Name: foundry_projects_foundry Type: INDEX Owner: tperdue
2809 CREATE INDEX foundry_projects_foundry on foundry_projects ( foundry_id );
2812 -- TOC Entry ID 344 (OID 18139606)
2814 -- Name: downloads_http_idx Type: INDEX Owner: tperdue
2817 CREATE INDEX downloads_http_idx on frs_dlstats_agg ( downloads_http );
2820 -- TOC Entry ID 345 (OID 18139606)
2822 -- Name: downloads_ftp_idx Type: INDEX Owner: tperdue
2825 CREATE INDEX downloads_ftp_idx on frs_dlstats_agg ( downloads_ftp );
2828 -- TOC Entry ID 346 (OID 18139606)
2830 -- Name: file_id_idx Type: INDEX Owner: tperdue
2833 CREATE INDEX file_id_idx on frs_dlstats_agg ( file_id );
2836 -- TOC Entry ID 347 (OID 18139606)
2838 -- Name: day_idx Type: INDEX Owner: tperdue
2841 CREATE INDEX day_idx on frs_dlstats_agg ( day );
2844 -- TOC Entry ID 348 (OID 18139623)
2846 -- Name: dlstats_file_down Type: INDEX Owner: tperdue
2849 CREATE INDEX dlstats_file_down on frs_dlstats_file_agg ( downloads );
2852 -- TOC Entry ID 349 (OID 18139623)
2854 -- Name: dlstats_file_file_id Type: INDEX Owner: tperdue
2857 CREATE INDEX dlstats_file_file_id on frs_dlstats_file_agg ( file_id );
2860 -- TOC Entry ID 350 (OID 18139623)
2862 -- Name: dlstats_file_day Type: INDEX Owner: tperdue
2865 CREATE INDEX dlstats_file_day on frs_dlstats_file_agg ( day );
2868 -- TOC Entry ID 351 (OID 18139638)
2870 -- Name: stats_agr_tmp_fid Type: INDEX Owner: tperdue
2873 --CREATE INDEX stats_agr_tmp_fid on frs_dlstats_filetotal_agg ( file_id );
2876 -- TOC Entry ID 352 (OID 18139654)
2878 -- Name: frs_dlstats_filet_agg_old_f Type: INDEX Owner: tperdue
2881 CREATE INDEX frs_dlstats_filet_agg_old_f on frs_dlstats_filetotal_agg_old ( file_id );
2884 -- TOC Entry ID 303 (OID 18139667)
2886 -- Name: frsdlstatsgroupagg_day_dls Type: INDEX Owner: tperdue
2889 CREATE INDEX frsdlstatsgroupagg_day_dls on frs_dlstats_group_agg ( day, downloads );
2892 -- TOC Entry ID 353 (OID 18139667)
2894 -- Name: group_id_idx Type: INDEX Owner: tperdue
2897 CREATE INDEX group_id_idx on frs_dlstats_group_agg ( group_id );
2900 -- TOC Entry ID 355 (OID 18139667)
2902 -- Name: frs_dlstats_group_agg_day Type: INDEX Owner: tperdue
2905 CREATE INDEX frs_dlstats_group_agg_day on frs_dlstats_group_agg ( day );
2908 -- TOC Entry ID 356 (OID 18139682)
2910 -- Name: stats_agr_tmp_gid Type: INDEX Owner: tperdue
2913 CREATE INDEX stats_agr_tmp_gid on frs_dlstats_grouptotal_agg ( group_id );
2916 -- TOC Entry ID 357 (OID 18139714)
2918 -- Name: frs_file_name Type: INDEX Owner: tperdue
2921 CREATE INDEX frs_file_name on frs_file ( filename );
2924 -- TOC Entry ID 358 (OID 18139714)
2926 -- Name: frs_file_date Type: INDEX Owner: tperdue
2929 CREATE INDEX frs_file_date on frs_file ( post_date );
2932 -- TOC Entry ID 359 (OID 18139714)
2934 -- Name: frs_file_processor Type: INDEX Owner: tperdue
2937 CREATE INDEX frs_file_processor on frs_file ( processor_id );
2940 -- TOC Entry ID 360 (OID 18139714)
2942 -- Name: frs_file_release_id Type: INDEX Owner: tperdue
2945 CREATE INDEX frs_file_release_id on frs_file ( release_id );
2948 -- TOC Entry ID 361 (OID 18139714)
2950 -- Name: frs_file_type Type: INDEX Owner: tperdue
2953 CREATE INDEX frs_file_type on frs_file ( type_id );
2956 -- TOC Entry ID 362 (OID 18139822)
2958 -- Name: package_group_id Type: INDEX Owner: tperdue
2961 CREATE INDEX package_group_id on frs_package ( group_id );
2964 -- TOC Entry ID 363 (OID 18139922)
2966 -- Name: frs_release_package Type: INDEX Owner: tperdue
2969 CREATE INDEX frs_release_package on frs_release ( package_id );
2972 -- TOC Entry ID 364 (OID 18139922)
2974 -- Name: frs_release_date Type: INDEX Owner: tperdue
2977 CREATE INDEX frs_release_date on frs_release ( release_date );
2980 -- TOC Entry ID 365 (OID 18139922)
2982 -- Name: frs_release_by Type: INDEX Owner: tperdue
2985 CREATE INDEX frs_release_by on frs_release ( released_by );
2988 -- TOC Entry ID 366 (OID 18140030)
2990 -- Name: group_cvs_history_group_id Type: INDEX Owner: tperdue
2993 CREATE INDEX group_cvs_history_group_id on group_cvs_history ( group_id );
2996 -- TOC Entry ID 367 (OID 18140030)
2998 -- Name: user_name_idx Type: INDEX Owner: tperdue
3001 CREATE INDEX user_name_idx on group_cvs_history ( user_name );
3004 -- TOC Entry ID 368 (OID 18140074)
3006 -- Name: group_history_group_id Type: INDEX Owner: tperdue
3009 CREATE INDEX group_history_group_id on group_history ( group_id );
3012 -- TOC Entry ID 369 (OID 18140178)
3014 -- Name: groups_unix Type: INDEX Owner: tperdue
3017 CREATE INDEX groups_unix on groups ( unix_group_name );
3020 -- TOC Entry ID 370 (OID 18140178)
3022 -- Name: groups_type Type: INDEX Owner: tperdue
3025 CREATE INDEX groups_type on groups ( type );
3028 -- TOC Entry ID 371 (OID 18140178)
3030 -- Name: groups_public Type: INDEX Owner: tperdue
3033 CREATE INDEX groups_public on groups ( is_public );
3036 -- TOC Entry ID 372 (OID 18140178)
3038 -- Name: groups_status Type: INDEX Owner: tperdue
3041 CREATE INDEX groups_status on groups ( status );
3044 -- TOC Entry ID 373 (OID 18140319)
3046 -- Name: mail_group_list_group Type: INDEX Owner: tperdue
3049 CREATE INDEX mail_group_list_group on mail_group_list ( group_id );
3052 -- TOC Entry ID 374 (OID 18140377)
3054 -- Name: news_bytes_group Type: INDEX Owner: tperdue
3057 CREATE INDEX news_bytes_group on news_bytes ( group_id );
3060 -- TOC Entry ID 375 (OID 18140377)
3062 -- Name: news_bytes_approved Type: INDEX Owner: tperdue
3065 CREATE INDEX news_bytes_approved on news_bytes ( is_approved );
3068 -- TOC Entry ID 376 (OID 18140377)
3070 -- Name: news_bytes_forum Type: INDEX Owner: tperdue
3073 CREATE INDEX news_bytes_forum on news_bytes ( forum_id );
3076 -- TOC Entry ID 464 (OID 18140377)
3078 -- Name: news_group_date Type: INDEX Owner: tperdue
3081 CREATE INDEX news_group_date on news_bytes ( group_id, date1 );
3084 -- TOC Entry ID 465 (OID 18140377)
3086 -- Name: news_approved_date Type: INDEX Owner: tperdue
3089 CREATE INDEX news_approved_date on news_bytes ( is_approved, date1 );
3092 -- TOC Entry ID 377 (OID 18140437)
3094 -- Name: patch_group_id Type: INDEX Owner: tperdue
3097 CREATE INDEX patch_group_id on patch ( group_id );
3100 -- TOC Entry ID 451 (OID 18140437)
3102 -- Name: patch_groupid_assign_status Type: INDEX Owner: tperdue
3105 CREATE INDEX patch_groupid_assign_status on patch ( group_id, assigned_to, patch_status_id );
3108 -- TOC Entry ID 452 (OID 18140437)
3110 -- Name: patch_groupid_assignedto Type: INDEX Owner: tperdue
3113 CREATE INDEX patch_groupid_assignedto on patch ( group_id, assigned_to );
3116 -- TOC Entry ID 453 (OID 18140437)
3118 -- Name: patch_groupid_status Type: INDEX Owner: tperdue
3121 CREATE INDEX patch_groupid_status on patch ( group_id, patch_status_id );
3124 -- TOC Entry ID 378 (OID 18140501)
3126 -- Name: patch_group_group_id Type: INDEX Owner: tperdue
3129 CREATE INDEX patch_group_group_id on patch_category ( group_id );
3132 -- TOC Entry ID 379 (OID 18140552)
3134 -- Name: patch_history_patch_id Type: INDEX Owner: tperdue
3137 CREATE INDEX patch_history_patch_id on patch_history ( patch_id );
3140 -- TOC Entry ID 461 (OID 18140656)
3142 -- Name: people_job_group_id Type: INDEX Owner: tperdue
3145 CREATE INDEX people_job_group_id on people_job ( group_id );
3148 -- TOC Entry ID 380 (OID 18141038)
3150 -- Name: project_assign_to_assigned_to Type: INDEX Owner: tperdue
3153 CREATE INDEX project_assign_to_assigned_to on project_assigned_to ( assigned_to_id );
3156 -- TOC Entry ID 381 (OID 18141038)
3158 -- Name: project_assigned_to_task_id Type: INDEX Owner: tperdue
3161 CREATE INDEX project_assigned_to_task_id on project_assigned_to ( project_task_id );
3164 -- TOC Entry ID 382 (OID 18141128)
3166 -- Name: project_dependent_on_task_id Type: INDEX Owner: tperdue
3169 CREATE INDEX project_dependent_on_task_id on project_dependencies ( is_dependent_on_task_id );
3172 -- TOC Entry ID 383 (OID 18141128)
3174 -- Name: project_dependencies_task_id Type: INDEX Owner: tperdue
3177 CREATE INDEX project_dependencies_task_id on project_dependencies ( project_task_id );
3180 -- TOC Entry ID 384 (OID 18141164)
3182 -- Name: project_group_list_group_id Type: INDEX Owner: tperdue
3185 CREATE INDEX project_group_list_group_id on project_group_list ( group_id );
3188 -- TOC Entry ID 385 (OID 18141218)
3190 -- Name: project_history_task_id Type: INDEX Owner: tperdue
3193 CREATE INDEX project_history_task_id on project_history ( project_task_id );
3196 -- TOC Entry ID 386 (OID 18141275)
3198 -- Name: project_metric_group Type: INDEX Owner: tperdue
3201 CREATE INDEX project_metric_group on project_metric ( group_id );
3204 -- TOC Entry ID 387 (OID 18141430)
3206 -- Name: project_task_group_project_id Type: INDEX Owner: tperdue
3209 CREATE INDEX project_task_group_project_id on project_task ( group_project_id );
3212 -- TOC Entry ID 454 (OID 18141430)
3214 -- Name: projecttask_projid_status Type: INDEX Owner: tperdue
3217 CREATE INDEX projecttask_projid_status on project_task ( group_project_id, status_id );
3220 -- TOC Entry ID 354 (OID 18141497)
3222 -- Name: projectweeklymetric_ranking Type: INDEX Owner: tperdue
3225 --CREATE INDEX projectweeklymetric_ranking on project_weekly_metric ( ranking );
3228 -- TOC Entry ID 388 (OID 18141497)
3230 -- Name: project_metric_weekly_group Type: INDEX Owner: tperdue
3233 CREATE INDEX project_metric_weekly_group on project_weekly_metric ( group_id );
3236 -- TOC Entry ID 389 (OID 18141514)
3238 -- Name: session_user_id Type: INDEX Owner: tperdue
3241 CREATE INDEX session1_user_id on session1 ( user_id );
3244 -- TOC Entry ID 390 (OID 18141514)
3246 -- Name: session_time Type: INDEX Owner: tperdue
3249 CREATE INDEX session1_time on session1 ( time );
3252 -- TOC Entry ID 391 (OID 18141552)
3254 -- Name: snippet_language Type: INDEX Owner: tperdue
3257 CREATE INDEX snippet_language on snippet ( language );
3260 -- TOC Entry ID 392 (OID 18141552)
3262 -- Name: snippet_category Type: INDEX Owner: tperdue
3265 CREATE INDEX snippet_category on snippet ( category );
3268 -- TOC Entry ID 393 (OID 18141611)
3270 -- Name: snippet_package_language Type: INDEX Owner: tperdue
3273 CREATE INDEX snippet_package_language on snippet_package ( language );
3276 -- TOC Entry ID 394 (OID 18141611)
3278 -- Name: snippet_package_category Type: INDEX Owner: tperdue
3281 CREATE INDEX snippet_package_category on snippet_package ( category );
3284 -- TOC Entry ID 395 (OID 18141666)
3286 -- Name: snippet_package_item_pkg_ver Type: INDEX Owner: tperdue
3289 CREATE INDEX snippet_package_item_pkg_ver on snippet_package_item ( snippet_package_version_id );
3292 -- TOC Entry ID 396 (OID 18141702)
3294 -- Name: snippet_package_version_pkg_id Type: INDEX Owner: tperdue
3297 CREATE INDEX snippet_package_version_pkg_id on snippet_package_version ( snippet_package_id );
3300 -- TOC Entry ID 397 (OID 18141757)
3302 -- Name: snippet_version_snippet_id Type: INDEX Owner: tperdue
3305 CREATE INDEX snippet_version_snippet_id on snippet_version ( snippet_id );
3308 -- TOC Entry ID 398 (OID 18141829)
3310 -- Name: pages_by_day_day Type: INDEX Owner: tperdue
3313 CREATE INDEX pages_by_day_day on stats_agg_pages_by_day ( day );
3316 -- TOC Entry ID 399 (OID 18141881)
3318 -- Name: stats_agr_filerelease_group_id Type: INDEX Owner: tperdue
3321 CREATE INDEX stats_agr_filerelease_group_id on stats_agr_filerelease ( group_id );
3324 -- TOC Entry ID 400 (OID 18141881)
3326 -- Name: stats_agr_filerel_filerelea Type: INDEX Owner: tperdue
3329 CREATE INDEX stats_agr_filerel_filerelea on stats_agr_filerelease ( filerelease_id );
3332 -- TOC Entry ID 401 (OID 18141896)
3334 -- Name: project_agr_log_group Type: INDEX Owner: tperdue
3337 CREATE INDEX project_agr_log_group on stats_agr_project ( group_id );
3340 -- TOC Entry ID 402 (OID 18141949)
3342 -- Name: ftpdl_group_id Type: INDEX Owner: tperdue
3345 CREATE INDEX ftpdl_group_id on stats_ftp_downloads ( group_id );
3348 -- TOC Entry ID 403 (OID 18141949)
3350 -- Name: ftpdl_fid Type: INDEX Owner: tperdue
3353 CREATE INDEX ftpdl_fid on stats_ftp_downloads ( filerelease_id );
3356 -- TOC Entry ID 404 (OID 18141949)
3358 -- Name: ftpdl_day Type: INDEX Owner: tperdue
3361 CREATE INDEX ftpdl_day on stats_ftp_downloads ( day );
3364 -- TOC Entry ID 405 (OID 18141966)
3366 -- Name: httpdl_group_id Type: INDEX Owner: tperdue
3369 CREATE INDEX httpdl_group_id on stats_http_downloads ( group_id );
3372 -- TOC Entry ID 406 (OID 18141966)
3374 -- Name: httpdl_fid Type: INDEX Owner: tperdue
3377 CREATE INDEX httpdl_fid on stats_http_downloads ( filerelease_id );
3380 -- TOC Entry ID 407 (OID 18141966)
3382 -- Name: httpdl_day Type: INDEX Owner: tperdue
3385 CREATE INDEX httpdl_day on stats_http_downloads ( day );
3388 -- TOC Entry ID 408 (OID 18141983)
3390 -- Name: archive_project_monthday Type: INDEX Owner: tperdue
3393 CREATE INDEX archive_project_monthday on stats_project ( month, day );
3396 -- TOC Entry ID 409 (OID 18141983)
3398 -- Name: project_log_group Type: INDEX Owner: tperdue
3401 CREATE INDEX project_log_group on stats_project ( group_id );
3404 -- TOC Entry ID 410 (OID 18141983)
3406 -- Name: archive_project_week Type: INDEX Owner: tperdue
3409 CREATE INDEX archive_project_week on stats_project ( week );
3412 -- TOC Entry ID 411 (OID 18141983)
3414 -- Name: archive_project_day Type: INDEX Owner: tperdue
3417 CREATE INDEX archive_project_day on stats_project ( day );
3420 -- TOC Entry ID 412 (OID 18141983)
3422 -- Name: archive_project_month Type: INDEX Owner: tperdue
3425 CREATE INDEX archive_project_month on stats_project ( month );
3428 -- TOC Entry ID 413 (OID 18142042)
3430 -- Name: stats_project_tmp_group_id Type: INDEX Owner: tperdue
3433 CREATE INDEX stats_project_tmp_group_id on stats_project_tmp ( group_id );
3436 -- TOC Entry ID 414 (OID 18142042)
3438 -- Name: project_stats_week Type: INDEX Owner: tperdue
3441 CREATE INDEX project_stats_week on stats_project_tmp ( week );
3444 -- TOC Entry ID 415 (OID 18142042)
3446 -- Name: project_stats_month Type: INDEX Owner: tperdue
3449 CREATE INDEX project_stats_month on stats_project_tmp ( month );
3452 -- TOC Entry ID 416 (OID 18142042)
3454 -- Name: project_stats_day Type: INDEX Owner: tperdue
3457 CREATE INDEX project_stats_day on stats_project_tmp ( day );
3460 -- TOC Entry ID 417 (OID 18142101)
3462 -- Name: stats_site_monthday Type: INDEX Owner: tperdue
3465 CREATE INDEX stats_site_monthday on stats_site ( month, day );
3468 -- TOC Entry ID 418 (OID 18142101)
3470 -- Name: stats_site_week Type: INDEX Owner: tperdue
3473 CREATE INDEX stats_site_week on stats_site ( week );
3476 -- TOC Entry ID 419 (OID 18142101)
3478 -- Name: stats_site_day Type: INDEX Owner: tperdue
3481 CREATE INDEX stats_site_day on stats_site ( day );
3484 -- TOC Entry ID 420 (OID 18142101)
3486 -- Name: stats_site_month Type: INDEX Owner: tperdue
3489 CREATE INDEX stats_site_month on stats_site ( month );
3492 -- TOC Entry ID 421 (OID 18142150)
3494 -- Name: support_group_id Type: INDEX Owner: tperdue
3497 CREATE INDEX support_group_id on support ( group_id );
3500 -- TOC Entry ID 448 (OID 18142150)
3502 -- Name: support_groupid_assignedto Type: INDEX Owner: tperdue
3505 CREATE INDEX support_groupid_assignedto on support ( group_id, assigned_to );
3508 -- TOC Entry ID 449 (OID 18142150)
3510 -- Name: support_groupid_assign_stat Type: INDEX Owner: tperdue
3513 CREATE INDEX support_groupid_assign_stat on support ( group_id, assigned_to, support_status_id );
3516 -- TOC Entry ID 450 (OID 18142150)
3518 -- Name: support_groupid_status Type: INDEX Owner: tperdue
3521 CREATE INDEX support_groupid_status on support ( group_id, support_status_id );
3524 -- TOC Entry ID 422 (OID 18142214)
3526 -- Name: support_canned_res_group_i Type: INDEX Owner: tperdue
3529 CREATE INDEX support_canned_res_group_i on support_canned_responses ( group_id );
3532 -- TOC Entry ID 423 (OID 18142265)
3534 -- Name: support_group_group_id Type: INDEX Owner: tperdue
3537 CREATE INDEX support_group_group_id on support_category ( group_id );
3540 -- TOC Entry ID 424 (OID 18142316)
3542 -- Name: support_history_support_id Type: INDEX Owner: tperdue
3545 CREATE INDEX support_history_support_id on support_history ( support_id );
3548 -- TOC Entry ID 425 (OID 18142372)
3550 -- Name: support_messages_support_id Type: INDEX Owner: tperdue
3553 CREATE INDEX support_messages_support_id on support_messages ( support_id );
3556 -- TOC Entry ID 426 (OID 18142473)
3558 -- Name: supported_languages_code Type: INDEX Owner: tperdue
3561 CREATE INDEX supported_languages_code on supported_languages ( language_code );
3564 -- TOC Entry ID 427 (OID 18142573)
3566 -- Name: survey_questions_group Type: INDEX Owner: tperdue
3569 CREATE INDEX survey_questions_group on survey_questions ( group_id );
3572 -- TOC Entry ID 428 (OID 18142608)
3574 -- Name: survey_rating_agg_type_id Type: INDEX Owner: tperdue
3577 CREATE INDEX survey_rating_agg_type_id on survey_rating_aggregate ( type, id );
3580 -- TOC Entry ID 429 (OID 18142625)
3582 -- Name: survey_rating_res_user_ty Type: INDEX Owner: tperdue
3585 CREATE INDEX survey_rating_res_user_ty on survey_rating_response ( user_id, type, id );
3588 -- TOC Entry ID 430 (OID 18142625)
3590 -- Name: survey_rating_res_type_id Type: INDEX Owner: tperdue
3593 CREATE INDEX survey_rating_res_type_id on survey_rating_response ( type, id );
3596 -- TOC Entry ID 431 (OID 18142644)
3598 -- Name: survey_responses_group_id Type: INDEX Owner: tperdue
3601 CREATE INDEX survey_responses_group_id on survey_responses ( group_id );
3604 -- TOC Entry ID 432 (OID 18142644)
3606 -- Name: survey_res_user_survey_qu Type: INDEX Owner: tperdue
3609 CREATE INDEX survey_res_user_survey_qu on survey_responses ( user_id, survey_id, question_id );
3612 -- TOC Entry ID 433 (OID 18142644)
3614 -- Name: survey_responses_user_survey Type: INDEX Owner: tperdue
3617 CREATE INDEX survey_responses_user_survey on survey_responses ( user_id, survey_id );
3620 -- TOC Entry ID 434 (OID 18142644)
3622 -- Name: survey_res_survey_questio Type: INDEX Owner: tperdue
3625 CREATE INDEX survey_res_survey_questio on survey_responses ( survey_id, question_id );
3628 -- TOC Entry ID 435 (OID 18142698)
3630 -- Name: surveys_group Type: INDEX Owner: tperdue
3633 CREATE INDEX surveys_group on surveys ( group_id );
3636 -- TOC Entry ID 436 (OID 18143071)
3638 -- Name: rank_forumposts_week_idx Type: INDEX Owner: tperdue
3641 CREATE INDEX rank_forumposts_week_idx on top_group ( rank_forumposts_week );
3644 -- TOC Entry ID 437 (OID 18143071)
3646 -- Name: rank_downloads_week_idx Type: INDEX Owner: tperdue
3649 CREATE INDEX rank_downloads_week_idx on top_group ( rank_downloads_week );
3652 -- TOC Entry ID 438 (OID 18143071)
3654 -- Name: pageviews_proj_idx Type: INDEX Owner: tperdue
3657 CREATE INDEX pageviews_proj_idx on top_group ( pageviews_proj );
3660 -- TOC Entry ID 439 (OID 18143071)
3662 -- Name: rank_userrank_idx Type: INDEX Owner: tperdue
3665 CREATE INDEX rank_userrank_idx on top_group ( rank_userrank );
3668 -- TOC Entry ID 440 (OID 18143071)
3670 -- Name: rank_downloads_all_idx Type: INDEX Owner: tperdue
3673 CREATE INDEX rank_downloads_all_idx on top_group ( rank_downloads_all );
3676 -- TOC Entry ID 441 (OID 18143131)
3678 -- Name: parent_idx Type: INDEX Owner: tperdue
3681 CREATE INDEX parent_idx on trove_cat ( parent );
3684 -- TOC Entry ID 442 (OID 18143131)
3686 -- Name: root_parent_idx Type: INDEX Owner: tperdue
3689 CREATE INDEX root_parent_idx on trove_cat ( root_parent );
3692 -- TOC Entry ID 443 (OID 18143131)
3694 -- Name: version_idx Type: INDEX Owner: tperdue
3697 CREATE INDEX version_idx on trove_cat ( version );
3700 -- TOC Entry ID 444 (OID 18143194)
3702 -- Name: trove_group_link_group_id Type: INDEX Owner: tperdue
3705 CREATE INDEX trove_group_link_group_id on trove_group_link ( group_id );
3708 -- TOC Entry ID 445 (OID 18143194)
3710 -- Name: trove_group_link_cat_id Type: INDEX Owner: tperdue
3713 CREATE INDEX trove_group_link_cat_id on trove_group_link ( trove_cat_id );
3716 -- TOC Entry ID 446 (OID 18143304)
3718 -- Name: user_bookmark_user_id Type: INDEX Owner: tperdue
3721 CREATE INDEX user_bookmark_user_id on user_bookmarks ( user_id );
3724 -- TOC Entry ID 304 (OID 18143355)
3726 -- Name: user_diary_user Type: INDEX Owner: tperdue
3729 CREATE INDEX user_diary_user on user_diary ( user_id );
3732 -- TOC Entry ID 305 (OID 18143355)
3734 -- Name: user_diary_user_date Type: INDEX Owner: tperdue
3737 CREATE INDEX user_diary_user_date on user_diary ( user_id, date_posted );
3740 -- TOC Entry ID 306 (OID 18143355)
3742 -- Name: user_diary_date Type: INDEX Owner: tperdue
3745 CREATE INDEX user_diary_date on user_diary ( date_posted );
3748 -- TOC Entry ID 307 (OID 18143410)
3750 -- Name: user_diary_monitor_user Type: INDEX Owner: tperdue
3753 CREATE INDEX user_diary_monitor_user on user_diary_monitor ( user_id );
3756 -- TOC Entry ID 308 (OID 18143410)
3758 -- Name: user_diary_monitor_monitor_us Type: INDEX Owner: tperdue
3761 CREATE INDEX user_diary_monitor_monitor_us on user_diary_monitor ( monitored_user );
3764 -- TOC Entry ID 309 (OID 18143446)
3766 -- Name: user_group_group_id Type: INDEX Owner: tperdue
3769 CREATE INDEX user_group_group_id on user_group ( group_id );
3772 -- TOC Entry ID 310 (OID 18143446)
3774 -- Name: bug_flags_idx Type: INDEX Owner: tperdue
3777 CREATE INDEX bug_flags_idx on user_group ( bug_flags );
3780 -- TOC Entry ID 311 (OID 18143446)
3782 -- Name: project_flags_idx Type: INDEX Owner: tperdue
3785 CREATE INDEX project_flags_idx on user_group ( project_flags );
3788 -- TOC Entry ID 312 (OID 18143446)
3790 -- Name: user_group_user_id Type: INDEX Owner: tperdue
3793 CREATE INDEX user_group_user_id on user_group ( user_id );
3796 -- TOC Entry ID 313 (OID 18143446)
3798 -- Name: admin_flags_idx Type: INDEX Owner: tperdue
3801 CREATE INDEX admin_flags_idx on user_group ( admin_flags );
3804 -- TOC Entry ID 314 (OID 18143446)
3806 -- Name: forum_flags_idx Type: INDEX Owner: tperdue
3809 CREATE INDEX forum_flags_idx on user_group ( forum_flags );
3812 -- TOC Entry ID 315 (OID 18143548)
3814 -- Name: user_metric0_user_id Type: INDEX Owner: tperdue
3817 CREATE INDEX user_metric0_user_id on user_metric0 ( user_id );
3820 -- TOC Entry ID 455 (OID 18143576)
3822 -- Name: user_pref_user_id Type: INDEX Owner: tperdue
3825 CREATE INDEX user_pref_user_id on user_preferences ( user_id );
3828 -- TOC Entry ID 456 (OID 18143591)
3830 -- Name: user_ratings_rated_by Type: INDEX Owner: tperdue
3833 CREATE INDEX user_ratings_rated_by on user_ratings ( rated_by );
3836 -- TOC Entry ID 457 (OID 18143591)
3838 -- Name: user_ratings_user_id Type: INDEX Owner: tperdue
3841 CREATE INDEX user_ratings_user_id on user_ratings ( user_id );
3844 -- TOC Entry ID 447 (OID 18143626)
3846 -- Name: users_status Type: INDEX Owner: tperdue
3849 CREATE INDEX users_status on users ( status );
3852 -- TOC Entry ID 458 (OID 18143626)
3854 -- Name: user_user Type: INDEX Owner: tperdue
3857 --CREATE INDEX user_user on users ( status );
3860 -- TOC Entry ID 459 (OID 18143626)
3862 -- Name: idx_users_username Type: INDEX Owner: tperdue
3865 CREATE INDEX idx_users_username on users ( user_name );
3868 -- TOC Entry ID 462 (OID 18143626)
3870 -- Name: users_user_pw Type: INDEX Owner: tperdue
3873 CREATE INDEX users_user_pw on users ( user_pw );
3876 -- TOC Entry ID 460 (OID 27311451)
3878 -- Name: troveagg_trovecatid Type: INDEX Owner: tperdue
3881 CREATE INDEX troveagg_trovecatid on trove_agg ( trove_cat_id );
3884 -- TOC Entry ID 536 (OID 27311269)
3886 -- Name: RI_ConstraintTrigger_27311268 Type: TRIGGER Owner: tperdue
3891 -- TOC Entry ID 537 (OID 27311271)
3893 -- Name: RI_ConstraintTrigger_27311270 Type: TRIGGER Owner: tperdue
3898 -- TOC Entry ID 538 (OID 27311273)
3900 -- Name: RI_ConstraintTrigger_27311272 Type: TRIGGER Owner: tperdue
3905 -- TOC Entry ID 535 (OID 27311275)
3907 -- Name: RI_ConstraintTrigger_27311274 Type: TRIGGER Owner: tperdue
3912 -- TOC Entry ID 506 (OID 27311277)
3914 -- Name: RI_ConstraintTrigger_27311276 Type: TRIGGER Owner: tperdue
3919 -- TOC Entry ID 505 (OID 27311279)
3921 -- Name: RI_ConstraintTrigger_27311278 Type: TRIGGER Owner: tperdue
3926 -- TOC Entry ID 487 (OID 27311281)
3928 -- Name: RI_ConstraintTrigger_27311280 Type: TRIGGER Owner: tperdue
3933 -- TOC Entry ID 539 (OID 27311283)
3935 -- Name: RI_ConstraintTrigger_27311282 Type: TRIGGER Owner: tperdue
3940 -- TOC Entry ID 540 (OID 27311285)
3942 -- Name: RI_ConstraintTrigger_27311284 Type: TRIGGER Owner: tperdue
3947 -- TOC Entry ID 486 (OID 27311287)
3949 -- Name: RI_ConstraintTrigger_27311286 Type: TRIGGER Owner: tperdue
3954 -- TOC Entry ID 492 (OID 27311289)
3956 -- Name: RI_ConstraintTrigger_27311288 Type: TRIGGER Owner: tperdue
3961 -- TOC Entry ID 491 (OID 27311291)
3963 -- Name: RI_ConstraintTrigger_27311290 Type: TRIGGER Owner: tperdue
3968 -- TOC Entry ID 490 (OID 27311293)
3970 -- Name: RI_ConstraintTrigger_27311292 Type: TRIGGER Owner: tperdue
3975 -- TOC Entry ID 504 (OID 27311295)
3977 -- Name: RI_ConstraintTrigger_27311294 Type: TRIGGER Owner: tperdue
3982 -- TOC Entry ID 503 (OID 27311297)
3984 -- Name: RI_ConstraintTrigger_27311296 Type: TRIGGER Owner: tperdue
3989 -- TOC Entry ID 479 (OID 27311299)
3991 -- Name: RI_ConstraintTrigger_27311298 Type: TRIGGER Owner: tperdue
3996 -- TOC Entry ID 502 (OID 27311301)
3998 -- Name: RI_ConstraintTrigger_27311300 Type: TRIGGER Owner: tperdue
4003 -- TOC Entry ID 501 (OID 27311303)
4005 -- Name: RI_ConstraintTrigger_27311302 Type: TRIGGER Owner: tperdue
4010 -- TOC Entry ID 476 (OID 27311305)
4012 -- Name: RI_ConstraintTrigger_27311304 Type: TRIGGER Owner: tperdue
4017 -- TOC Entry ID 500 (OID 27311307)
4019 -- Name: RI_ConstraintTrigger_27311306 Type: TRIGGER Owner: tperdue
4024 -- TOC Entry ID 499 (OID 27311309)
4026 -- Name: RI_ConstraintTrigger_27311308 Type: TRIGGER Owner: tperdue
4031 -- TOC Entry ID 473 (OID 27311311)
4033 -- Name: RI_ConstraintTrigger_27311310 Type: TRIGGER Owner: tperdue
4038 -- TOC Entry ID 541 (OID 27311313)
4040 -- Name: RI_ConstraintTrigger_27311312 Type: TRIGGER Owner: tperdue
4045 -- TOC Entry ID 542 (OID 27311315)
4047 -- Name: RI_ConstraintTrigger_27311314 Type: TRIGGER Owner: tperdue
4052 -- TOC Entry ID 472 (OID 27311317)
4054 -- Name: RI_ConstraintTrigger_27311316 Type: TRIGGER Owner: tperdue
4059 -- TOC Entry ID 543 (OID 27311319)
4061 -- Name: RI_ConstraintTrigger_27311318 Type: TRIGGER Owner: tperdue
4066 -- TOC Entry ID 544 (OID 27311321)
4068 -- Name: RI_ConstraintTrigger_27311320 Type: TRIGGER Owner: tperdue
4073 -- TOC Entry ID 471 (OID 27311323)
4075 -- Name: RI_ConstraintTrigger_27311322 Type: TRIGGER Owner: tperdue
4080 -- TOC Entry ID 483 (OID 27311325)
4082 -- Name: RI_ConstraintTrigger_27311324 Type: TRIGGER Owner: tperdue
4087 -- TOC Entry ID 482 (OID 27311327)
4089 -- Name: RI_ConstraintTrigger_27311326 Type: TRIGGER Owner: tperdue
4094 -- TOC Entry ID 470 (OID 27311329)
4096 -- Name: RI_ConstraintTrigger_27311328 Type: TRIGGER Owner: tperdue
4101 -- TOC Entry ID 475 (OID 27311331)
4103 -- Name: RI_ConstraintTrigger_27311330 Type: TRIGGER Owner: tperdue
4108 -- TOC Entry ID 474 (OID 27311333)
4110 -- Name: RI_ConstraintTrigger_27311332 Type: TRIGGER Owner: tperdue
4115 -- TOC Entry ID 469 (OID 27311335)
4117 -- Name: RI_ConstraintTrigger_27311334 Type: TRIGGER Owner: tperdue
4122 -- TOC Entry ID 481 (OID 27311337)
4124 -- Name: RI_ConstraintTrigger_27311336 Type: TRIGGER Owner: tperdue
4129 -- TOC Entry ID 480 (OID 27311339)
4131 -- Name: RI_ConstraintTrigger_27311338 Type: TRIGGER Owner: tperdue
4136 -- TOC Entry ID 468 (OID 27311341)
4138 -- Name: RI_ConstraintTrigger_27311340 Type: TRIGGER Owner: tperdue
4143 -- TOC Entry ID 478 (OID 27311343)
4145 -- Name: RI_ConstraintTrigger_27311342 Type: TRIGGER Owner: tperdue
4150 -- TOC Entry ID 477 (OID 27311345)
4152 -- Name: RI_ConstraintTrigger_27311344 Type: TRIGGER Owner: tperdue
4157 -- TOC Entry ID 485 (OID 27311347)
4159 -- Name: RI_ConstraintTrigger_27311346 Type: TRIGGER Owner: tperdue
4164 -- TOC Entry ID 545 (OID 27311349)
4166 -- Name: RI_ConstraintTrigger_27311348 Type: TRIGGER Owner: tperdue
4171 -- TOC Entry ID 546 (OID 27311351)
4173 -- Name: RI_ConstraintTrigger_27311350 Type: TRIGGER Owner: tperdue
4178 -- TOC Entry ID 484 (OID 27311353)
4180 -- Name: RI_ConstraintTrigger_27311352 Type: TRIGGER Owner: tperdue
4185 -- TOC Entry ID 489 (OID 27311355)
4187 -- Name: RI_ConstraintTrigger_27311354 Type: TRIGGER Owner: tperdue
4192 -- TOC Entry ID 488 (OID 27311357)
4194 -- Name: RI_ConstraintTrigger_27311356 Type: TRIGGER Owner: tperdue
4199 -- TOC Entry ID 518 (OID 27311359)
4201 -- Name: RI_ConstraintTrigger_27311358 Type: TRIGGER Owner: tperdue
4206 -- TOC Entry ID 498 (OID 27311361)
4208 -- Name: RI_ConstraintTrigger_27311360 Type: TRIGGER Owner: tperdue
4213 -- TOC Entry ID 497 (OID 27311363)
4215 -- Name: RI_ConstraintTrigger_27311362 Type: TRIGGER Owner: tperdue
4220 -- TOC Entry ID 523 (OID 27311365)
4222 -- Name: RI_ConstraintTrigger_27311364 Type: TRIGGER Owner: tperdue
4227 -- TOC Entry ID 517 (OID 27311367)
4229 -- Name: RI_ConstraintTrigger_27311366 Type: TRIGGER Owner: tperdue
4234 -- TOC Entry ID 516 (OID 27311369)
4236 -- Name: RI_ConstraintTrigger_27311368 Type: TRIGGER Owner: tperdue
4241 -- TOC Entry ID 522 (OID 27311371)
4243 -- Name: RI_ConstraintTrigger_27311370 Type: TRIGGER Owner: tperdue
4248 -- TOC Entry ID 547 (OID 27311373)
4250 -- Name: RI_ConstraintTrigger_27311372 Type: TRIGGER Owner: tperdue
4255 -- TOC Entry ID 548 (OID 27311375)
4257 -- Name: RI_ConstraintTrigger_27311374 Type: TRIGGER Owner: tperdue
4262 -- TOC Entry ID 521 (OID 27311377)
4264 -- Name: RI_ConstraintTrigger_27311376 Type: TRIGGER Owner: tperdue
4269 -- TOC Entry ID 520 (OID 27311379)
4271 -- Name: RI_ConstraintTrigger_27311378 Type: TRIGGER Owner: tperdue
4276 -- TOC Entry ID 519 (OID 27311381)
4278 -- Name: RI_ConstraintTrigger_27311380 Type: TRIGGER Owner: tperdue
4283 -- TOC Entry ID 510 (OID 27311383)
4285 -- Name: RI_ConstraintTrigger_27311382 Type: TRIGGER Owner: tperdue
4290 -- TOC Entry ID 515 (OID 27311385)
4292 -- Name: RI_ConstraintTrigger_27311384 Type: TRIGGER Owner: tperdue
4297 -- TOC Entry ID 514 (OID 27311387)
4299 -- Name: RI_ConstraintTrigger_27311386 Type: TRIGGER Owner: tperdue
4304 -- TOC Entry ID 509 (OID 27311389)
4306 -- Name: RI_ConstraintTrigger_27311388 Type: TRIGGER Owner: tperdue
4311 -- TOC Entry ID 513 (OID 27311391)
4313 -- Name: RI_ConstraintTrigger_27311390 Type: TRIGGER Owner: tperdue
4318 -- TOC Entry ID 512 (OID 27311393)
4320 -- Name: RI_ConstraintTrigger_27311392 Type: TRIGGER Owner: tperdue
4325 -- TOC Entry ID 508 (OID 27311395)
4327 -- Name: RI_ConstraintTrigger_27311394 Type: TRIGGER Owner: tperdue
4332 -- TOC Entry ID 549 (OID 27311397)
4334 -- Name: RI_ConstraintTrigger_27311396 Type: TRIGGER Owner: tperdue
4339 -- TOC Entry ID 550 (OID 27311399)
4341 -- Name: RI_ConstraintTrigger_27311398 Type: TRIGGER Owner: tperdue
4346 -- TOC Entry ID 507 (OID 27311401)
4348 -- Name: RI_ConstraintTrigger_27311400 Type: TRIGGER Owner: tperdue
4353 -- TOC Entry ID 551 (OID 27311403)
4355 -- Name: RI_ConstraintTrigger_27311402 Type: TRIGGER Owner: tperdue
4360 -- TOC Entry ID 552 (OID 27311405)
4362 -- Name: RI_ConstraintTrigger_27311404 Type: TRIGGER Owner: tperdue
4367 -- TOC Entry ID 511 (OID 27311407)
4369 -- Name: RI_ConstraintTrigger_27311406 Type: TRIGGER Owner: tperdue
4374 -- TOC Entry ID 496 (OID 27311409)
4376 -- Name: RI_ConstraintTrigger_27311408 Type: TRIGGER Owner: tperdue
4381 -- TOC Entry ID 495 (OID 27311411)
4383 -- Name: RI_ConstraintTrigger_27311410 Type: TRIGGER Owner: tperdue
4388 -- TOC Entry ID 527 (OID 27311413)
4390 -- Name: RI_ConstraintTrigger_27311412 Type: TRIGGER Owner: tperdue
4395 -- TOC Entry ID 532 (OID 27311415)
4397 -- Name: RI_ConstraintTrigger_27311414 Type: TRIGGER Owner: tperdue
4402 -- TOC Entry ID 531 (OID 27311417)
4404 -- Name: RI_ConstraintTrigger_27311416 Type: TRIGGER Owner: tperdue
4409 -- TOC Entry ID 526 (OID 27311419)
4411 -- Name: RI_ConstraintTrigger_27311418 Type: TRIGGER Owner: tperdue
4416 -- TOC Entry ID 530 (OID 27311421)
4418 -- Name: RI_ConstraintTrigger_27311420 Type: TRIGGER Owner: tperdue
4423 -- TOC Entry ID 529 (OID 27311423)
4425 -- Name: RI_ConstraintTrigger_27311422 Type: TRIGGER Owner: tperdue
4430 -- TOC Entry ID 525 (OID 27311425)
4432 -- Name: RI_ConstraintTrigger_27311424 Type: TRIGGER Owner: tperdue
4437 -- TOC Entry ID 553 (OID 27311427)
4439 -- Name: RI_ConstraintTrigger_27311426 Type: TRIGGER Owner: tperdue
4444 -- TOC Entry ID 554 (OID 27311429)
4446 -- Name: RI_ConstraintTrigger_27311428 Type: TRIGGER Owner: tperdue
4451 -- TOC Entry ID 524 (OID 27311431)
4453 -- Name: RI_ConstraintTrigger_27311430 Type: TRIGGER Owner: tperdue
4458 -- TOC Entry ID 555 (OID 27311433)
4460 -- Name: RI_ConstraintTrigger_27311432 Type: TRIGGER Owner: tperdue
4465 -- TOC Entry ID 556 (OID 27311435)
4467 -- Name: RI_ConstraintTrigger_27311434 Type: TRIGGER Owner: tperdue
4472 -- TOC Entry ID 528 (OID 27311437)
4474 -- Name: RI_ConstraintTrigger_27311436 Type: TRIGGER Owner: tperdue
4479 -- TOC Entry ID 494 (OID 27311439)
4481 -- Name: RI_ConstraintTrigger_27311438 Type: TRIGGER Owner: tperdue
4486 -- TOC Entry ID 493 (OID 27311441)
4488 -- Name: RI_ConstraintTrigger_27311440 Type: TRIGGER Owner: tperdue
4493 -- TOC Entry ID 557 (OID 27311443)
4495 -- Name: RI_ConstraintTrigger_27311442 Type: TRIGGER Owner: tperdue
4500 -- TOC Entry ID 534 (OID 27311445)
4502 -- Name: RI_ConstraintTrigger_27311444 Type: TRIGGER Owner: tperdue
4507 -- TOC Entry ID 533 (OID 27311447)
4509 -- Name: RI_ConstraintTrigger_27311446 Type: TRIGGER Owner: tperdue
4514 -- TOC Entry ID 3 (OID 18138427)
4516 -- Name: bug_pk_seq Type: SEQUENCE SET Owner:
4519 DROP SEQUENCE bug_pk_seq;
4520 CREATE SEQUENCE bug_pk_seq START WITH 125359;
4523 -- TOC Entry ID 5 (OID 18138495)
4525 -- Name: bug_bug_dependencies_pk_seq Type: SEQUENCE SET Owner:
4528 DROP SEQUENCE bug_bug_dependencies_pk_seq;
4529 CREATE SEQUENCE bug_bug_dependencies_pk_seq START WITH 44691;
4532 -- TOC Entry ID 7 (OID 18138531)
4534 -- Name: bug_canned_responses_pk_seq Type: SEQUENCE SET Owner:
4537 DROP SEQUENCE bug_canned_responses_pk_seq;
4538 CREATE SEQUENCE bug_canned_responses_pk_seq START WITH 100204;
4541 -- TOC Entry ID 9 (OID 18138582)
4543 -- Name: bug_category_pk_seq Type: SEQUENCE SET Owner:
4546 DROP SEQUENCE bug_category_pk_seq;
4547 CREATE SEQUENCE bug_category_pk_seq START WITH 5053;
4550 -- TOC Entry ID 11 (OID 18138632)
4552 -- Name: bug_filter_pk_seq Type: SEQUENCE SET Owner:
4555 DROP SEQUENCE bug_filter_pk_seq;
4556 CREATE SEQUENCE bug_filter_pk_seq START WITH 140;
4559 -- TOC Entry ID 13 (OID 18138687)
4561 -- Name: bug_group_pk_seq Type: SEQUENCE SET Owner:
4564 DROP SEQUENCE bug_group_pk_seq;
4565 CREATE SEQUENCE bug_group_pk_seq START WITH 2780;
4568 -- TOC Entry ID 15 (OID 18138738)
4570 -- Name: bug_history_pk_seq Type: SEQUENCE SET Owner:
4573 DROP SEQUENCE bug_history_pk_seq;
4574 CREATE SEQUENCE bug_history_pk_seq START WITH 106196;
4577 -- TOC Entry ID 17 (OID 18138794)
4579 -- Name: bug_resolution_pk_seq Type: SEQUENCE SET Owner:
4582 DROP SEQUENCE bug_resolution_pk_seq;
4583 CREATE SEQUENCE bug_resolution_pk_seq START WITH 101;
4586 -- TOC Entry ID 19 (OID 18138843)
4588 -- Name: bug_status_pk_seq Type: SEQUENCE SET Owner:
4591 DROP SEQUENCE bug_status_pk_seq;
4592 CREATE SEQUENCE bug_status_pk_seq START WITH 100;
4595 -- TOC Entry ID 21 (OID 18138891)
4597 -- Name: bug_task_dependencies_pk_seq Type: SEQUENCE SET Owner:
4600 DROP SEQUENCE bug_task_dependencies_pk_seq;
4601 CREATE SEQUENCE bug_task_dependencies_pk_seq START WITH 44583;
4604 -- TOC Entry ID 23 (OID 18138927)
4606 -- Name: canned_responses_pk_seq Type: SEQUENCE SET Owner:
4609 DROP SEQUENCE canned_responses_pk_seq;
4610 CREATE SEQUENCE canned_responses_pk_seq START WITH 5;
4613 -- TOC Entry ID 25 (OID 18138977)
4615 -- Name: db_images_pk_seq Type: SEQUENCE SET Owner:
4618 DROP SEQUENCE db_images_pk_seq;
4619 CREATE SEQUENCE db_images_pk_seq START WITH 1128;
4622 -- TOC Entry ID 27 (OID 18139040)
4624 -- Name: doc_data_pk_seq Type: SEQUENCE SET Owner:
4627 DROP SEQUENCE doc_data_pk_seq;
4628 CREATE SEQUENCE doc_data_pk_seq START WITH 2124;
4631 -- TOC Entry ID 29 (OID 18139104)
4633 -- Name: doc_groups_pk_seq Type: SEQUENCE SET Owner:
4636 DROP SEQUENCE doc_groups_pk_seq;
4637 CREATE SEQUENCE doc_groups_pk_seq START WITH 1815;
4640 -- TOC Entry ID 31 (OID 18139140)
4642 -- Name: doc_states_pk_seq Type: SEQUENCE SET Owner:
4645 DROP SEQUENCE doc_states_pk_seq;
4646 CREATE SEQUENCE doc_states_pk_seq START WITH 5;
4649 -- TOC Entry ID 33 (OID 18139174)
4651 -- Name: filemodule_monitor_pk_seq Type: SEQUENCE SET Owner:
4654 DROP SEQUENCE filemodule_monitor_pk_seq;
4655 CREATE SEQUENCE filemodule_monitor_pk_seq START WITH 312;
4658 -- TOC Entry ID 35 (OID 18139210)
4660 -- Name: forum_pk_seq Type: SEQUENCE SET Owner:
4663 DROP SEQUENCE forum_pk_seq;
4664 CREATE SEQUENCE forum_pk_seq START WITH 84486;
4667 -- TOC Entry ID 37 (OID 18139291)
4669 -- Name: forum_group_list_pk_seq Type: SEQUENCE SET Owner:
4672 DROP SEQUENCE forum_group_list_pk_seq;
4673 CREATE SEQUENCE forum_group_list_pk_seq START WITH 51981;
4676 -- TOC Entry ID 39 (OID 18139348)
4678 -- Name: forum_monitor_forums_pk_seq Type: SEQUENCE SET Owner:
4681 DROP SEQUENCE forum_monitor_forums_pk_seq;
4682 CREATE SEQUENCE forum_monitor_forums_pk_seq START WITH 14831;
4685 -- TOC Entry ID 41 (OID 18139384)
4687 -- Name: forum_saved_place_pk_seq Type: SEQUENCE SET Owner:
4690 DROP SEQUENCE forum_saved_place_pk_seq;
4691 CREATE SEQUENCE forum_saved_place_pk_seq START WITH 1835;
4694 -- TOC Entry ID 43 (OID 18139492)
4696 -- Name: foundry_news_pk_seq Type: SEQUENCE SET Owner:
4699 DROP SEQUENCE foundry_news_pk_seq;
4700 CREATE SEQUENCE foundry_news_pk_seq START WITH 1973;
4703 -- TOC Entry ID 45 (OID 18139532)
4705 -- Name: foundry_prefer_proj_pk_seq Type: SEQUENCE SET Owner:
4708 DROP SEQUENCE foundry_prefer_proj_pk_seq;
4709 CREATE SEQUENCE foundry_prefer_proj_pk_seq START WITH 165;
4712 -- TOC Entry ID 47 (OID 18139570)
4714 -- Name: foundry_projects_pk_seq Type: SEQUENCE SET Owner:
4717 DROP SEQUENCE foundry_projects_pk_seq;
4718 CREATE SEQUENCE foundry_projects_pk_seq START WITH 320807;
4721 -- TOC Entry ID 49 (OID 18139695)
4723 -- Name: frs_file_pk_seq Type: SEQUENCE SET Owner:
4726 DROP SEQUENCE frs_file_pk_seq;
4727 CREATE SEQUENCE frs_file_pk_seq START WITH 29214;
4730 -- TOC Entry ID 51 (OID 18139756)
4732 -- Name: frs_filetype_pk_seq Type: SEQUENCE SET Owner:
4735 DROP SEQUENCE frs_filetype_pk_seq;
4736 CREATE SEQUENCE frs_filetype_pk_seq START WITH 9999;
4739 -- TOC Entry ID 53 (OID 18139804)
4741 -- Name: frs_package_pk_seq Type: SEQUENCE SET Owner:
4744 DROP SEQUENCE frs_package_pk_seq;
4745 CREATE SEQUENCE frs_package_pk_seq START WITH 12688;
4748 -- TOC Entry ID 55 (OID 18139856)
4750 -- Name: frs_processor_pk_seq Type: SEQUENCE SET Owner:
4753 DROP SEQUENCE frs_processor_pk_seq;
4754 CREATE SEQUENCE frs_processor_pk_seq START WITH 9999;
4757 -- TOC Entry ID 57 (OID 18139904)
4759 -- Name: frs_release_pk_seq Type: SEQUENCE SET Owner:
4762 DROP SEQUENCE frs_release_pk_seq;
4763 CREATE SEQUENCE frs_release_pk_seq START WITH 17983;
4766 -- TOC Entry ID 59 (OID 18139964)
4768 -- Name: frs_status_pk_seq Type: SEQUENCE SET Owner:
4771 DROP SEQUENCE frs_status_pk_seq;
4772 CREATE SEQUENCE frs_status_pk_seq START WITH 3;
4775 -- TOC Entry ID 61 (OID 18140012)
4777 -- Name: group_cvs_history_pk_seq Type: SEQUENCE SET Owner:
4780 DROP SEQUENCE group_cvs_history_pk_seq;
4781 CREATE SEQUENCE group_cvs_history_pk_seq START WITH 1;
4784 -- TOC Entry ID 63 (OID 18140056)
4786 -- Name: group_history_pk_seq Type: SEQUENCE SET Owner:
4789 DROP SEQUENCE group_history_pk_seq;
4790 CREATE SEQUENCE group_history_pk_seq START WITH 29283;
4793 -- TOC Entry ID 65 (OID 18140112)
4795 -- Name: group_type_pk_seq Type: SEQUENCE SET Owner:
4798 DROP SEQUENCE group_type_pk_seq;
4799 CREATE SEQUENCE group_type_pk_seq START WITH 2;
4802 -- TOC Entry ID 67 (OID 18140160)
4804 -- Name: groups_pk_seq Type: SEQUENCE SET Owner:
4807 DROP SEQUENCE groups_pk_seq;
4808 CREATE SEQUENCE groups_pk_seq START WITH 16379;
4811 -- TOC Entry ID 69 (OID 18140301)
4813 -- Name: mail_group_list_pk_seq Type: SEQUENCE SET Owner:
4816 DROP SEQUENCE mail_group_list_pk_seq;
4817 CREATE SEQUENCE mail_group_list_pk_seq START WITH 7581;
4820 -- TOC Entry ID 71 (OID 18140359)
4822 -- Name: news_bytes_pk_seq Type: SEQUENCE SET Owner:
4825 DROP SEQUENCE news_bytes_pk_seq;
4826 CREATE SEQUENCE news_bytes_pk_seq START WITH 10299;
4829 -- TOC Entry ID 73 (OID 18140419)
4831 -- Name: patch_pk_seq Type: SEQUENCE SET Owner:
4834 DROP SEQUENCE patch_pk_seq;
4835 CREATE SEQUENCE patch_pk_seq START WITH 102785;
4838 -- TOC Entry ID 75 (OID 18140483)
4840 -- Name: patch_category_pk_seq Type: SEQUENCE SET Owner:
4843 DROP SEQUENCE patch_category_pk_seq;
4844 CREATE SEQUENCE patch_category_pk_seq START WITH 10607;
4847 -- TOC Entry ID 77 (OID 18140534)
4849 -- Name: patch_history_pk_seq Type: SEQUENCE SET Owner:
4852 DROP SEQUENCE patch_history_pk_seq;
4853 CREATE SEQUENCE patch_history_pk_seq START WITH 9813;
4856 -- TOC Entry ID 79 (OID 18140590)
4858 -- Name: patch_status_pk_seq Type: SEQUENCE SET Owner:
4861 DROP SEQUENCE patch_status_pk_seq;
4862 CREATE SEQUENCE patch_status_pk_seq START WITH 103;
4865 -- TOC Entry ID 81 (OID 18140638)
4867 -- Name: people_job_pk_seq Type: SEQUENCE SET Owner:
4870 DROP SEQUENCE people_job_pk_seq;
4871 CREATE SEQUENCE people_job_pk_seq START WITH 1641;
4874 -- TOC Entry ID 83 (OID 18140697)
4876 -- Name: people_job_category_pk_seq Type: SEQUENCE SET Owner:
4879 DROP SEQUENCE people_job_category_pk_seq;
4880 CREATE SEQUENCE people_job_category_pk_seq START WITH 102;
4883 -- TOC Entry ID 85 (OID 18140747)
4885 -- Name: people_job_inventory_pk_seq Type: SEQUENCE SET Owner:
4888 DROP SEQUENCE people_job_inventory_pk_seq;
4889 CREATE SEQUENCE people_job_inventory_pk_seq START WITH 1970;
4892 -- TOC Entry ID 87 (OID 18140787)
4894 -- Name: people_job_status_pk_seq Type: SEQUENCE SET Owner:
4897 DROP SEQUENCE people_job_status_pk_seq;
4898 CREATE SEQUENCE people_job_status_pk_seq START WITH 3;
4901 -- TOC Entry ID 89 (OID 18140835)
4903 -- Name: people_skill_pk_seq Type: SEQUENCE SET Owner:
4906 DROP SEQUENCE people_skill_pk_seq;
4907 CREATE SEQUENCE people_skill_pk_seq START WITH 33;
4910 -- TOC Entry ID 91 (OID 18140884)
4912 -- Name: people_skill_inv_pk_seq Type: SEQUENCE SET Owner:
4915 DROP SEQUENCE people_skill_inv_pk_seq;
4916 CREATE SEQUENCE people_skill_inv_pk_seq START WITH 60179;
4919 -- TOC Entry ID 93 (OID 18140924)
4921 -- Name: people_skill_level_pk_seq Type: SEQUENCE SET Owner:
4924 DROP SEQUENCE people_skill_level_pk_seq;
4925 CREATE SEQUENCE people_skill_level_pk_seq START WITH 5;
4928 -- TOC Entry ID 95 (OID 18140972)
4930 -- Name: people_skill_year_pk_seq Type: SEQUENCE SET Owner:
4933 DROP SEQUENCE people_skill_year_pk_seq;
4934 CREATE SEQUENCE people_skill_year_pk_seq START WITH 5;
4937 -- TOC Entry ID 97 (OID 18141020)
4939 -- Name: project_assigned_to_pk_seq Type: SEQUENCE SET Owner:
4942 DROP SEQUENCE project_assigned_to_pk_seq;
4943 CREATE SEQUENCE project_assigned_to_pk_seq START WITH 30257;
4946 -- TOC Entry ID 99 (OID 18141110)
4948 -- Name: project_dependencies_pk_seq Type: SEQUENCE SET Owner:
4951 DROP SEQUENCE project_dependencies_pk_seq;
4952 CREATE SEQUENCE project_dependencies_pk_seq START WITH 25231;
4955 -- TOC Entry ID 101 (OID 18141146)
4957 -- Name: project_group_list_pk_seq Type: SEQUENCE SET Owner:
4960 DROP SEQUENCE project_group_list_pk_seq;
4961 CREATE SEQUENCE project_group_list_pk_seq START WITH 6360;
4964 -- TOC Entry ID 103 (OID 18141200)
4966 -- Name: project_history_pk_seq Type: SEQUENCE SET Owner:
4969 DROP SEQUENCE project_history_pk_seq;
4970 CREATE SEQUENCE project_history_pk_seq START WITH 27347;
4973 -- TOC Entry ID 105 (OID 18141257)
4975 -- Name: project_metric_pk_seq Type: SEQUENCE SET Owner:
4978 DROP SEQUENCE project_metric_pk_seq;
4979 CREATE SEQUENCE project_metric_pk_seq START WITH 13274;
4982 -- TOC Entry ID 107 (OID 18141292)
4984 -- Name: project_metric_tmp1_pk_seq Type: SEQUENCE SET Owner:
4987 DROP SEQUENCE project_metric_tmp1_pk_seq;
4988 CREATE SEQUENCE project_metric_tmp1_pk_seq START WITH 13274;
4991 -- TOC Entry ID 109 (OID 18141327)
4993 -- Name: proj_metric_weekly_tm_pk_seq Type: SEQUENCE SET Owner:
4996 DROP SEQUENCE proj_metric_weekly_tm_pk_seq;
4997 CREATE SEQUENCE proj_metric_weekly_tm_pk_seq START WITH 2213;
5000 -- TOC Entry ID 111 (OID 18141363)
5002 -- Name: project_status_pk_seq Type: SEQUENCE SET Owner:
5005 DROP SEQUENCE project_status_pk_seq;
5006 CREATE SEQUENCE project_status_pk_seq START WITH 100;
5009 -- TOC Entry ID 113 (OID 18141412)
5011 -- Name: project_task_pk_seq Type: SEQUENCE SET Owner:
5014 DROP SEQUENCE project_task_pk_seq;
5015 CREATE SEQUENCE project_task_pk_seq START WITH 23295;
5018 -- TOC Entry ID 115 (OID 18141479)
5020 -- Name: project_weekly_metric_pk_seq Type: SEQUENCE SET Owner:
5023 DROP SEQUENCE project_weekly_metric_pk_seq;
5024 CREATE SEQUENCE project_weekly_metric_pk_seq START WITH 2213;
5027 -- TOC Entry ID 117 (OID 18141534)
5029 -- Name: snippet_pk_seq Type: SEQUENCE SET Owner:
5032 DROP SEQUENCE snippet_pk_seq;
5033 CREATE SEQUENCE snippet_pk_seq START WITH 100501;
5036 -- TOC Entry ID 119 (OID 18141593)
5038 -- Name: snippet_package_pk_seq Type: SEQUENCE SET Owner:
5041 DROP SEQUENCE snippet_package_pk_seq;
5042 CREATE SEQUENCE snippet_package_pk_seq START WITH 100035;
5045 -- TOC Entry ID 121 (OID 18141648)
5047 -- Name: snippet_package_item_pk_seq Type: SEQUENCE SET Owner:
5050 DROP SEQUENCE snippet_package_item_pk_seq;
5051 CREATE SEQUENCE snippet_package_item_pk_seq START WITH 100100;
5054 -- TOC Entry ID 123 (OID 18141684)
5056 -- Name: snippet_package_ver_pk_seq Type: SEQUENCE SET Owner:
5059 DROP SEQUENCE snippet_package_ver_pk_seq;
5060 CREATE SEQUENCE snippet_package_ver_pk_seq START WITH 100035;
5063 -- TOC Entry ID 125 (OID 18141739)
5065 -- Name: snippet_version_pk_seq Type: SEQUENCE SET Owner:
5068 DROP SEQUENCE snippet_version_pk_seq;
5069 CREATE SEQUENCE snippet_version_pk_seq START WITH 100662;
5072 -- TOC Entry ID 127 (OID 18142132)
5074 -- Name: support_pk_seq Type: SEQUENCE SET Owner:
5077 DROP SEQUENCE support_pk_seq;
5078 CREATE SEQUENCE support_pk_seq START WITH 109672;
5081 -- TOC Entry ID 129 (OID 18142196)
5083 -- Name: support_canned_res_pk_seq Type: SEQUENCE SET Owner:
5086 DROP SEQUENCE support_canned_res_pk_seq;
5087 CREATE SEQUENCE support_canned_res_pk_seq START WITH 100088;
5090 -- TOC Entry ID 131 (OID 18142247)
5092 -- Name: support_category_pk_seq Type: SEQUENCE SET Owner:
5095 DROP SEQUENCE support_category_pk_seq;
5096 CREATE SEQUENCE support_category_pk_seq START WITH 10699;
5099 -- TOC Entry ID 133 (OID 18142298)
5101 -- Name: support_history_pk_seq Type: SEQUENCE SET Owner:
5104 DROP SEQUENCE support_history_pk_seq;
5105 CREATE SEQUENCE support_history_pk_seq START WITH 24027;
5108 -- TOC Entry ID 135 (OID 18142354)
5110 -- Name: support_messages_pk_seq Type: SEQUENCE SET Owner:
5113 DROP SEQUENCE support_messages_pk_seq;
5114 CREATE SEQUENCE support_messages_pk_seq START WITH 122077;
5117 -- TOC Entry ID 137 (OID 18142407)
5119 -- Name: support_status_pk_seq Type: SEQUENCE SET Owner:
5122 DROP SEQUENCE support_status_pk_seq;
5123 CREATE SEQUENCE support_status_pk_seq START WITH 3;
5126 -- TOC Entry ID 139 (OID 18142455)
5128 -- Name: supported_languages_pk_seq Type: SEQUENCE SET Owner:
5131 DROP SEQUENCE supported_languages_pk_seq;
5132 CREATE SEQUENCE supported_languages_pk_seq START WITH 21;
5135 -- TOC Entry ID 141 (OID 18142506)
5137 -- Name: survey_question_types_pk_seq Type: SEQUENCE SET Owner:
5140 DROP SEQUENCE survey_question_types_pk_seq;
5141 CREATE SEQUENCE survey_question_types_pk_seq START WITH 100;
5144 -- TOC Entry ID 143 (OID 18142555)
5146 -- Name: survey_questions_pk_seq Type: SEQUENCE SET Owner:
5149 DROP SEQUENCE survey_questions_pk_seq;
5150 CREATE SEQUENCE survey_questions_pk_seq START WITH 14662;
5153 -- TOC Entry ID 145 (OID 18142680)
5155 -- Name: surveys_pk_seq Type: SEQUENCE SET Owner:
5158 DROP SEQUENCE surveys_pk_seq;
5159 CREATE SEQUENCE surveys_pk_seq START WITH 11185;
5162 -- TOC Entry ID 147 (OID 18142735)
5164 -- Name: system_history_pk_seq Type: SEQUENCE SET Owner:
5167 DROP SEQUENCE system_history_pk_seq;
5168 CREATE SEQUENCE system_history_pk_seq START WITH 1;
5171 -- TOC Entry ID 149 (OID 18142787)
5173 -- Name: system_machines_pk_seq Type: SEQUENCE SET Owner:
5176 DROP SEQUENCE system_machines_pk_seq;
5177 CREATE SEQUENCE system_machines_pk_seq START WITH 1;
5180 -- TOC Entry ID 151 (OID 18142836)
5182 -- Name: system_news_pk_seq Type: SEQUENCE SET Owner:
5185 DROP SEQUENCE system_news_pk_seq;
5186 CREATE SEQUENCE system_news_pk_seq START WITH 1;
5189 -- TOC Entry ID 153 (OID 18142895)
5191 -- Name: system_services_pk_seq Type: SEQUENCE SET Owner:
5194 DROP SEQUENCE system_services_pk_seq;
5195 CREATE SEQUENCE system_services_pk_seq START WITH 1;
5198 -- TOC Entry ID 155 (OID 18142944)
5200 -- Name: system_status_pk_seq Type: SEQUENCE SET Owner:
5203 DROP SEQUENCE system_status_pk_seq;
5204 CREATE SEQUENCE system_status_pk_seq START WITH 1;
5207 -- TOC Entry ID 157 (OID 18143020)
5209 -- Name: themes_pk_seq Type: SEQUENCE SET Owner:
5212 DROP SEQUENCE themes_pk_seq;
5213 CREATE SEQUENCE themes_pk_seq START WITH 2;
5216 -- TOC Entry ID 159 (OID 18143113)
5218 -- Name: trove_cat_pk_seq Type: SEQUENCE SET Owner:
5221 DROP SEQUENCE trove_cat_pk_seq;
5222 CREATE SEQUENCE trove_cat_pk_seq START WITH 281;
5225 -- TOC Entry ID 161 (OID 18143176)
5227 -- Name: trove_group_link_pk_seq Type: SEQUENCE SET Owner:
5230 DROP SEQUENCE trove_group_link_pk_seq;
5231 CREATE SEQUENCE trove_group_link_pk_seq START WITH 111628;
5234 -- TOC Entry ID 163 (OID 18143216)
5236 -- Name: trove_treesums_pk_seq Type: SEQUENCE SET Owner:
5239 DROP SEQUENCE trove_treesums_pk_seq;
5240 CREATE SEQUENCE trove_treesums_pk_seq START WITH 765;
5243 -- TOC Entry ID 165 (OID 18143286)
5245 -- Name: user_bookmarks_pk_seq Type: SEQUENCE SET Owner:
5248 DROP SEQUENCE user_bookmarks_pk_seq;
5249 CREATE SEQUENCE user_bookmarks_pk_seq START WITH 23482;
5252 -- TOC Entry ID 167 (OID 18143337)
5254 -- Name: user_diary_pk_seq Type: SEQUENCE SET Owner:
5257 DROP SEQUENCE user_diary_pk_seq;
5258 CREATE SEQUENCE user_diary_pk_seq START WITH 892;
5261 -- TOC Entry ID 169 (OID 18143392)
5263 -- Name: user_diary_monitor_pk_seq Type: SEQUENCE SET Owner:
5266 DROP SEQUENCE user_diary_monitor_pk_seq;
5267 CREATE SEQUENCE user_diary_monitor_pk_seq START WITH 521;
5270 -- TOC Entry ID 171 (OID 18143428)
5272 -- Name: user_group_pk_seq Type: SEQUENCE SET Owner:
5275 DROP SEQUENCE user_group_pk_seq;
5276 CREATE SEQUENCE user_group_pk_seq START WITH 27204;
5279 -- TOC Entry ID 173 (OID 18143484)
5281 -- Name: user_metric_pk_seq Type: SEQUENCE SET Owner:
5284 DROP SEQUENCE user_metric_pk_seq;
5285 CREATE SEQUENCE user_metric_pk_seq START WITH 115;
5288 -- TOC Entry ID 175 (OID 18143530)
5290 -- Name: user_metric0_pk_seq Type: SEQUENCE SET Owner:
5293 DROP SEQUENCE user_metric0_pk_seq;
5294 CREATE SEQUENCE user_metric0_pk_seq START WITH 5;
5297 -- TOC Entry ID 177 (OID 18143608)
5299 -- Name: users_pk_seq Type: SEQUENCE SET Owner:
5302 DROP SEQUENCE users_pk_seq;
5303 CREATE SEQUENCE users_pk_seq START WITH 120800;
5306 -- TOC Entry ID 179 (OID 27311232)
5308 -- Name: unix_uid_seq Type: SEQUENCE SET Owner:
5311 DROP SEQUENCE unix_uid_seq;
5312 CREATE SEQUENCE unix_uid_seq START WITH 21044;
5315 -- TOC Entry ID 181 (OID 27311250)
5317 -- Name: forum_thread_seq Type: SEQUENCE SET Owner:
5320 DROP SEQUENCE forum_thread_seq;
5321 CREATE SEQUENCE forum_thread_seq START WITH 59698;