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)
projects / fusionforge / fusionforge.git / blob