2 SET client_encoding = 'SQL_ASCII';
3 SET check_function_bodies = false;
4 SET client_min_messages TO warning;
6 SET search_path = public, pg_catalog;
9 -- CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler
10 -- AS '$libdir/plpgsql', 'plpgsql_call_handler'
15 -- CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER plpgsql_call_handler;
19 -- REVOKE ALL ON SCHEMA public FROM PUBLIC;
20 -- GRANT ALL ON SCHEMA public TO PUBLIC;
24 CREATE SEQUENCE canned_responses_pk_seq
33 CREATE TABLE canned_responses (
34 response_id integer DEFAULT nextval('canned_responses_pk_seq'::text) NOT NULL,
35 response_title character varying(25),
41 CREATE SEQUENCE db_images_pk_seq
50 CREATE TABLE db_images (
51 id integer DEFAULT nextval('db_images_pk_seq'::text) NOT NULL,
52 group_id integer DEFAULT 0 NOT NULL,
53 description text DEFAULT ''::text NOT NULL,
54 bin_data text DEFAULT ''::text NOT NULL,
55 filename text DEFAULT ''::text NOT NULL,
56 filesize integer DEFAULT 0 NOT NULL,
57 filetype text DEFAULT ''::text NOT NULL,
58 width integer DEFAULT 0 NOT NULL,
59 height integer DEFAULT 0 NOT NULL,
66 CREATE SEQUENCE doc_data_pk_seq
75 CREATE TABLE doc_data (
76 docid integer DEFAULT nextval('doc_data_pk_seq'::text) NOT NULL,
77 stateid integer DEFAULT 0 NOT NULL,
78 title character varying(255) DEFAULT ''::character varying NOT NULL,
79 data text DEFAULT ''::text NOT NULL,
80 updatedate integer DEFAULT 0 NOT NULL,
81 createdate integer DEFAULT 0 NOT NULL,
82 created_by integer DEFAULT 0 NOT NULL,
83 doc_group integer DEFAULT 0 NOT NULL,
85 language_id integer DEFAULT 1 NOT NULL,
89 filesize integer DEFAULT 0 NOT NULL,
90 data_words text DEFAULT ''::text NOT NULL
95 CREATE SEQUENCE doc_groups_pk_seq
104 CREATE TABLE doc_groups (
105 doc_group integer DEFAULT nextval('doc_groups_pk_seq'::text) NOT NULL,
106 groupname character varying(255) DEFAULT ''::character varying NOT NULL,
107 group_id integer DEFAULT 0 NOT NULL,
108 parent_doc_group integer DEFAULT 0 NOT NULL
113 CREATE SEQUENCE doc_states_pk_seq
122 CREATE TABLE doc_states (
123 stateid integer DEFAULT nextval('doc_states_pk_seq'::text) NOT NULL,
124 name character varying(255) DEFAULT ''::character varying NOT NULL
129 CREATE SEQUENCE filemodule_monitor_pk_seq
138 CREATE TABLE filemodule_monitor (
139 id integer DEFAULT nextval('filemodule_monitor_pk_seq'::text) NOT NULL,
140 filemodule_id integer DEFAULT 0 NOT NULL,
141 user_id integer DEFAULT 0 NOT NULL
146 CREATE SEQUENCE forum_pk_seq
156 msg_id integer DEFAULT nextval('forum_pk_seq'::text) NOT NULL,
157 group_forum_id integer DEFAULT 0 NOT NULL,
158 posted_by integer DEFAULT 0 NOT NULL,
159 subject text DEFAULT ''::text NOT NULL,
160 body text DEFAULT ''::text NOT NULL,
161 post_date integer DEFAULT 0 NOT NULL,
162 is_followup_to integer DEFAULT 0 NOT NULL,
163 thread_id integer DEFAULT 0 NOT NULL,
164 has_followups integer DEFAULT 0,
165 most_recent_date integer DEFAULT 0 NOT NULL
170 CREATE TABLE forum_agg_msg_count (
171 group_forum_id integer DEFAULT 0 NOT NULL,
172 count integer DEFAULT 0 NOT NULL
177 CREATE SEQUENCE forum_group_list_pk_seq
186 CREATE TABLE forum_group_list (
187 group_forum_id integer DEFAULT nextval('forum_group_list_pk_seq'::text) NOT NULL,
188 group_id integer DEFAULT 0 NOT NULL,
189 forum_name text DEFAULT ''::text NOT NULL,
190 is_public integer DEFAULT 0 NOT NULL,
192 allow_anonymous integer DEFAULT 0 NOT NULL,
193 send_all_posts_to text,
194 moderation_level integer DEFAULT 0
199 CREATE SEQUENCE forum_monitored_forums_pk_seq
208 CREATE TABLE forum_monitored_forums (
209 monitor_id integer DEFAULT nextval('forum_monitored_forums_pk_seq'::text) NOT NULL,
210 forum_id integer DEFAULT 0 NOT NULL,
211 user_id integer DEFAULT 0 NOT NULL
216 CREATE SEQUENCE forum_saved_place_pk_seq
225 CREATE TABLE forum_saved_place (
226 saved_place_id integer DEFAULT nextval('forum_saved_place_pk_seq'::text) NOT NULL,
227 user_id integer DEFAULT 0 NOT NULL,
228 forum_id integer DEFAULT 0 NOT NULL,
229 save_date integer DEFAULT 0 NOT NULL
234 CREATE SEQUENCE foundry_news_pk_seq
243 CREATE SEQUENCE frs_file_pk_seq
252 CREATE TABLE frs_file (
253 file_id integer DEFAULT nextval('frs_file_pk_seq'::text) NOT NULL,
255 release_id integer DEFAULT 0 NOT NULL,
256 type_id integer DEFAULT 0 NOT NULL,
257 processor_id integer DEFAULT 0 NOT NULL,
258 release_time integer DEFAULT 0 NOT NULL,
259 file_size integer DEFAULT 0 NOT NULL,
260 post_date integer DEFAULT 0 NOT NULL
265 CREATE SEQUENCE frs_filetype_pk_seq
273 CREATE TABLE frs_filetype (
274 type_id integer DEFAULT nextval('frs_filetype_pk_seq'::text) NOT NULL,
280 CREATE SEQUENCE frs_package_pk_seq
289 CREATE TABLE frs_package (
290 package_id integer DEFAULT nextval('frs_package_pk_seq'::text) NOT NULL,
291 group_id integer DEFAULT 0 NOT NULL,
293 status_id integer DEFAULT 0 NOT NULL,
294 is_public integer DEFAULT 1
299 CREATE SEQUENCE frs_processor_pk_seq
307 CREATE TABLE frs_processor (
308 processor_id integer DEFAULT nextval('frs_processor_pk_seq'::text) NOT NULL,
314 CREATE SEQUENCE frs_release_pk_seq
323 CREATE TABLE frs_release (
324 release_id integer DEFAULT nextval('frs_release_pk_seq'::text) NOT NULL,
325 package_id integer DEFAULT 0 NOT NULL,
329 status_id integer DEFAULT 0 NOT NULL,
330 preformatted integer DEFAULT 0 NOT NULL,
331 release_date integer DEFAULT 0 NOT NULL,
332 released_by integer DEFAULT 0 NOT NULL
337 CREATE SEQUENCE frs_status_pk_seq
345 CREATE TABLE frs_status (
346 status_id integer DEFAULT nextval('frs_status_pk_seq'::text) NOT NULL,
352 CREATE SEQUENCE group_history_pk_seq
361 CREATE TABLE group_history (
362 group_history_id integer DEFAULT nextval('group_history_pk_seq'::text) NOT NULL,
363 group_id integer DEFAULT 0 NOT NULL,
364 field_name text DEFAULT ''::text NOT NULL,
365 old_value text DEFAULT ''::text NOT NULL,
366 mod_by integer DEFAULT 0 NOT NULL,
372 CREATE SEQUENCE groups_pk_seq
380 CREATE TABLE groups (
381 group_id integer DEFAULT nextval('groups_pk_seq'::text) NOT NULL,
382 group_name character varying(40),
383 homepage character varying(128),
384 is_public integer DEFAULT 0 NOT NULL,
385 status character(1) DEFAULT 'A'::bpchar NOT NULL,
386 unix_group_name character varying(30) DEFAULT ''::character varying NOT NULL,
387 unix_box character varying(20) DEFAULT 'shell1'::character varying NOT NULL,
388 http_domain character varying(80),
389 short_description character varying(255),
390 register_purpose text,
392 register_time integer DEFAULT 0 NOT NULL,
394 use_mail integer DEFAULT 1 NOT NULL,
395 use_survey integer DEFAULT 1 NOT NULL,
396 use_forum integer DEFAULT 1 NOT NULL,
397 use_pm integer DEFAULT 1 NOT NULL,
398 use_scm integer DEFAULT 1 NOT NULL,
399 use_news integer DEFAULT 1 NOT NULL,
400 type_id integer DEFAULT 1 NOT NULL,
401 use_docman integer DEFAULT 1 NOT NULL,
402 new_doc_address text DEFAULT ''::text NOT NULL,
403 send_all_docs integer DEFAULT 0 NOT NULL,
404 use_pm_depend_box integer DEFAULT 1 NOT NULL,
405 use_ftp integer DEFAULT 1,
406 use_tracker integer DEFAULT 1,
407 use_frs integer DEFAULT 1,
408 use_stats integer DEFAULT 1,
409 enable_pserver integer DEFAULT 1,
410 enable_anonscm integer DEFAULT 1,
411 license integer DEFAULT 100,
417 CREATE SEQUENCE mail_group_list_pk_seq
426 CREATE TABLE mail_group_list (
427 group_list_id integer DEFAULT nextval('mail_group_list_pk_seq'::text) NOT NULL,
428 group_id integer DEFAULT 0 NOT NULL,
430 is_public integer DEFAULT 0 NOT NULL,
431 "password" character varying(16),
432 list_admin integer DEFAULT 0 NOT NULL,
433 status integer DEFAULT 0 NOT NULL,
439 CREATE SEQUENCE news_bytes_pk_seq
448 CREATE TABLE news_bytes (
449 id integer DEFAULT nextval('news_bytes_pk_seq'::text) NOT NULL,
450 group_id integer DEFAULT 0 NOT NULL,
451 submitted_by integer DEFAULT 0 NOT NULL,
452 is_approved integer DEFAULT 0 NOT NULL,
453 post_date integer DEFAULT 0 NOT NULL,
454 forum_id integer DEFAULT 0 NOT NULL,
461 CREATE SEQUENCE people_job_pk_seq
470 CREATE TABLE people_job (
471 job_id integer DEFAULT nextval('people_job_pk_seq'::text) NOT NULL,
472 group_id integer DEFAULT 0 NOT NULL,
473 created_by integer DEFAULT 0 NOT NULL,
476 post_date integer DEFAULT 0 NOT NULL,
477 status_id integer DEFAULT 0 NOT NULL,
478 category_id integer DEFAULT 0 NOT NULL
483 CREATE SEQUENCE people_job_category_pk_seq
491 CREATE TABLE people_job_category (
492 category_id integer DEFAULT nextval('people_job_category_pk_seq'::text) NOT NULL,
494 private_flag integer DEFAULT 0 NOT NULL
499 CREATE SEQUENCE people_job_inventory_pk_seq
508 CREATE TABLE people_job_inventory (
509 job_inventory_id integer DEFAULT nextval('people_job_inventory_pk_seq'::text) NOT NULL,
510 job_id integer DEFAULT 0 NOT NULL,
511 skill_id integer DEFAULT 0 NOT NULL,
512 skill_level_id integer DEFAULT 0 NOT NULL,
513 skill_year_id integer DEFAULT 0 NOT NULL
518 CREATE SEQUENCE people_job_status_pk_seq
527 CREATE TABLE people_job_status (
528 status_id integer DEFAULT nextval('people_job_status_pk_seq'::text) NOT NULL,
534 CREATE SEQUENCE people_skill_pk_seq
543 CREATE TABLE people_skill (
544 skill_id integer DEFAULT nextval('people_skill_pk_seq'::text) NOT NULL,
550 CREATE SEQUENCE people_skill_inventory_pk_seq
559 CREATE TABLE people_skill_inventory (
560 skill_inventory_id integer DEFAULT nextval('people_skill_inventory_pk_seq'::text) NOT NULL,
561 user_id integer DEFAULT 0 NOT NULL,
562 skill_id integer DEFAULT 0 NOT NULL,
563 skill_level_id integer DEFAULT 0 NOT NULL,
564 skill_year_id integer DEFAULT 0 NOT NULL
569 CREATE SEQUENCE people_skill_level_pk_seq
577 CREATE TABLE people_skill_level (
578 skill_level_id integer DEFAULT nextval('people_skill_level_pk_seq'::text) NOT NULL,
584 CREATE SEQUENCE people_skill_year_pk_seq
592 CREATE TABLE people_skill_year (
593 skill_year_id integer DEFAULT nextval('people_skill_year_pk_seq'::text) NOT NULL,
599 CREATE SEQUENCE project_assigned_to_pk_seq
608 CREATE TABLE project_assigned_to (
609 project_assigned_id integer DEFAULT nextval('project_assigned_to_pk_seq'::text) NOT NULL,
610 project_task_id integer DEFAULT 0 NOT NULL,
611 assigned_to_id integer DEFAULT 0 NOT NULL
616 CREATE SEQUENCE project_dependencies_pk_seq
625 CREATE TABLE project_dependencies (
626 project_depend_id integer DEFAULT nextval('project_dependencies_pk_seq'::text) NOT NULL,
627 project_task_id integer DEFAULT 0 NOT NULL,
628 is_dependent_on_task_id integer DEFAULT 0 NOT NULL,
629 link_type character(2) DEFAULT 'FS'::bpchar
634 CREATE SEQUENCE project_group_list_pk_seq
642 CREATE TABLE project_group_list (
643 group_project_id integer DEFAULT nextval('project_group_list_pk_seq'::text) NOT NULL,
644 group_id integer DEFAULT 0 NOT NULL,
645 project_name text DEFAULT ''::text NOT NULL,
646 is_public integer DEFAULT 0 NOT NULL,
648 send_all_posts_to text
653 CREATE SEQUENCE project_history_pk_seq
662 CREATE TABLE project_history (
663 project_history_id integer DEFAULT nextval('project_history_pk_seq'::text) NOT NULL,
664 project_task_id integer DEFAULT 0 NOT NULL,
665 field_name text DEFAULT ''::text NOT NULL,
666 old_value text DEFAULT ''::text NOT NULL,
667 mod_by integer DEFAULT 0 NOT NULL,
668 mod_date integer DEFAULT 0 NOT NULL
673 CREATE SEQUENCE project_metric_pk_seq
682 CREATE TABLE project_metric (
683 ranking integer DEFAULT nextval('project_metric_pk_seq'::text) NOT NULL,
684 percentile double precision,
685 group_id integer DEFAULT 0 NOT NULL
690 CREATE SEQUENCE project_metric_tmp1_pk_seq
699 CREATE TABLE project_metric_tmp1 (
700 ranking integer DEFAULT nextval('project_metric_tmp1_pk_seq'::text) NOT NULL,
701 group_id integer DEFAULT 0 NOT NULL,
702 value double precision
707 CREATE SEQUENCE project_status_pk_seq
716 CREATE TABLE project_status (
717 status_id integer DEFAULT nextval('project_status_pk_seq'::text) NOT NULL,
718 status_name text DEFAULT ''::text NOT NULL
723 CREATE SEQUENCE project_task_pk_seq
731 CREATE TABLE project_task (
732 project_task_id integer DEFAULT nextval('project_task_pk_seq'::text) NOT NULL,
733 group_project_id integer DEFAULT 0 NOT NULL,
734 summary text DEFAULT ''::text NOT NULL,
735 details text DEFAULT ''::text NOT NULL,
736 percent_complete integer DEFAULT 0 NOT NULL,
737 priority integer DEFAULT 3 NOT NULL,
738 hours double precision DEFAULT (0)::double precision NOT NULL,
739 start_date integer DEFAULT 0 NOT NULL,
740 end_date integer DEFAULT 0 NOT NULL,
741 created_by integer DEFAULT 0 NOT NULL,
742 status_id integer DEFAULT 0 NOT NULL,
744 duration integer DEFAULT 0,
745 parent_id integer DEFAULT 0,
746 last_modified_date integer
751 CREATE SEQUENCE project_weekly_metric_pk_seq
760 CREATE TABLE project_weekly_metric (
761 ranking integer DEFAULT nextval('project_weekly_metric_pk_seq'::text) NOT NULL,
762 percentile double precision,
763 group_id integer DEFAULT 0 NOT NULL
768 CREATE TABLE user_session (
769 user_id integer DEFAULT 0 NOT NULL,
770 session_hash character(32) DEFAULT ''::bpchar NOT NULL,
771 ip_addr character(15) DEFAULT ''::bpchar NOT NULL,
772 "time" integer DEFAULT 0 NOT NULL
777 CREATE SEQUENCE snippet_pk_seq
786 CREATE TABLE snippet (
787 snippet_id integer DEFAULT nextval('snippet_pk_seq'::text) NOT NULL,
788 created_by integer DEFAULT 0 NOT NULL,
791 "type" integer DEFAULT 0 NOT NULL,
792 "language" integer DEFAULT 0 NOT NULL,
793 license text DEFAULT ''::text NOT NULL,
794 category integer DEFAULT 0 NOT NULL
799 CREATE SEQUENCE snippet_package_pk_seq
808 CREATE TABLE snippet_package (
809 snippet_package_id integer DEFAULT nextval('snippet_package_pk_seq'::text) NOT NULL,
810 created_by integer DEFAULT 0 NOT NULL,
813 category integer DEFAULT 0 NOT NULL,
814 "language" integer DEFAULT 0 NOT NULL
819 CREATE SEQUENCE snippet_package_item_pk_seq
828 CREATE TABLE snippet_package_item (
829 snippet_package_item_id integer DEFAULT nextval('snippet_package_item_pk_seq'::text) NOT NULL,
830 snippet_package_version_id integer DEFAULT 0 NOT NULL,
831 snippet_version_id integer DEFAULT 0 NOT NULL
836 CREATE SEQUENCE snippet_package_version_pk_seq
845 CREATE TABLE snippet_package_version (
846 snippet_package_version_id integer DEFAULT nextval('snippet_package_version_pk_seq'::text) NOT NULL,
847 snippet_package_id integer DEFAULT 0 NOT NULL,
850 submitted_by integer DEFAULT 0 NOT NULL,
851 post_date integer DEFAULT 0 NOT NULL
856 CREATE SEQUENCE snippet_version_pk_seq
865 CREATE TABLE snippet_version (
866 snippet_version_id integer DEFAULT nextval('snippet_version_pk_seq'::text) NOT NULL,
867 snippet_id integer DEFAULT 0 NOT NULL,
870 submitted_by integer DEFAULT 0 NOT NULL,
871 post_date integer DEFAULT 0 NOT NULL,
877 CREATE TABLE stats_agg_logo_by_day (
884 CREATE TABLE stats_agg_pages_by_day (
885 "day" integer DEFAULT 0 NOT NULL,
886 count integer DEFAULT 0 NOT NULL
891 CREATE SEQUENCE survey_question_types_pk_seq
900 CREATE TABLE survey_question_types (
901 id integer DEFAULT nextval('survey_question_types_pk_seq'::text) NOT NULL,
902 "type" text DEFAULT ''::text NOT NULL
907 CREATE SEQUENCE survey_questions_pk_seq
916 CREATE TABLE survey_questions (
917 question_id integer DEFAULT nextval('survey_questions_pk_seq'::text) NOT NULL,
918 group_id integer DEFAULT 0 NOT NULL,
919 question text DEFAULT ''::text NOT NULL,
920 question_type integer DEFAULT 0 NOT NULL
925 CREATE TABLE survey_rating_aggregate (
926 "type" integer DEFAULT 0 NOT NULL,
927 id integer DEFAULT 0 NOT NULL,
928 response double precision DEFAULT (0)::double precision NOT NULL,
929 count integer DEFAULT 0 NOT NULL
934 CREATE TABLE survey_rating_response (
935 user_id integer DEFAULT 0 NOT NULL,
936 "type" integer DEFAULT 0 NOT NULL,
937 id integer DEFAULT 0 NOT NULL,
938 response integer DEFAULT 0 NOT NULL,
939 post_date integer DEFAULT 0 NOT NULL
944 CREATE TABLE survey_responses (
945 user_id integer DEFAULT 0 NOT NULL,
946 group_id integer DEFAULT 0 NOT NULL,
947 survey_id integer DEFAULT 0 NOT NULL,
948 question_id integer DEFAULT 0 NOT NULL,
949 response text DEFAULT ''::text NOT NULL,
950 post_date integer DEFAULT 0 NOT NULL
955 CREATE SEQUENCE surveys_pk_seq
964 CREATE TABLE surveys (
965 survey_id integer DEFAULT nextval('surveys_pk_seq'::text) NOT NULL,
966 group_id integer DEFAULT 0 NOT NULL,
967 survey_title text DEFAULT ''::text NOT NULL,
968 survey_questions text DEFAULT ''::text NOT NULL,
969 is_active integer DEFAULT 1 NOT NULL
974 CREATE SEQUENCE themes_pk_seq
982 CREATE SEQUENCE trove_cat_pk_seq
990 CREATE TABLE trove_cat (
991 trove_cat_id integer DEFAULT nextval('trove_cat_pk_seq'::text) NOT NULL,
992 "version" integer DEFAULT 0 NOT NULL,
993 parent integer DEFAULT 0 NOT NULL,
994 root_parent integer DEFAULT 0 NOT NULL,
995 shortname character varying(80),
996 fullname character varying(80),
997 description character varying(255),
998 count_subcat integer DEFAULT 0 NOT NULL,
999 count_subproj integer DEFAULT 0 NOT NULL,
1000 fullpath text DEFAULT ''::text NOT NULL,
1006 CREATE SEQUENCE trove_group_link_pk_seq
1015 CREATE TABLE trove_group_link (
1016 trove_group_id integer DEFAULT nextval('trove_group_link_pk_seq'::text) NOT NULL,
1017 trove_cat_id integer DEFAULT 0 NOT NULL,
1018 trove_cat_version integer DEFAULT 0 NOT NULL,
1019 group_id integer DEFAULT 0 NOT NULL,
1020 trove_cat_root integer DEFAULT 0 NOT NULL
1025 CREATE SEQUENCE trove_treesums_pk_seq
1034 CREATE SEQUENCE user_bookmarks_pk_seq
1043 CREATE TABLE user_bookmarks (
1044 bookmark_id integer DEFAULT nextval('user_bookmarks_pk_seq'::text) NOT NULL,
1045 user_id integer DEFAULT 0 NOT NULL,
1052 CREATE SEQUENCE user_diary_pk_seq
1061 CREATE TABLE user_diary (
1062 id integer DEFAULT nextval('user_diary_pk_seq'::text) NOT NULL,
1063 user_id integer DEFAULT 0 NOT NULL,
1064 date_posted integer DEFAULT 0 NOT NULL,
1067 is_public integer DEFAULT 0 NOT NULL
1072 CREATE SEQUENCE user_diary_monitor_pk_seq
1081 CREATE TABLE user_diary_monitor (
1082 monitor_id integer DEFAULT nextval('user_diary_monitor_pk_seq'::text) NOT NULL,
1083 monitored_user integer DEFAULT 0 NOT NULL,
1084 user_id integer DEFAULT 0 NOT NULL
1089 CREATE SEQUENCE user_group_pk_seq
1097 CREATE TABLE user_group (
1098 user_group_id integer DEFAULT nextval('user_group_pk_seq'::text) NOT NULL,
1099 user_id integer DEFAULT 0 NOT NULL,
1100 group_id integer DEFAULT 0 NOT NULL,
1101 admin_flags character(16) DEFAULT ''::bpchar NOT NULL,
1102 forum_flags integer DEFAULT 0 NOT NULL,
1103 project_flags integer DEFAULT 2 NOT NULL,
1104 doc_flags integer DEFAULT 0 NOT NULL,
1105 cvs_flags integer DEFAULT 1 NOT NULL,
1106 member_role integer DEFAULT 100 NOT NULL,
1107 release_flags integer DEFAULT 0 NOT NULL,
1108 artifact_flags integer,
1109 role_id integer DEFAULT 1
1114 CREATE SEQUENCE user_metric_pk_seq
1123 CREATE TABLE user_metric (
1124 ranking integer DEFAULT nextval('user_metric_pk_seq'::text) NOT NULL,
1125 user_id integer DEFAULT 0 NOT NULL,
1126 times_ranked integer DEFAULT 0 NOT NULL,
1127 avg_raters_importance double precision DEFAULT (0)::double precision NOT NULL,
1128 avg_rating double precision DEFAULT (0)::double precision NOT NULL,
1129 metric double precision DEFAULT (0)::double precision NOT NULL,
1130 percentile double precision DEFAULT (0)::double precision NOT NULL,
1131 importance_factor double precision DEFAULT (0)::double precision NOT NULL
1136 CREATE SEQUENCE user_metric0_pk_seq
1145 CREATE TABLE user_metric0 (
1146 ranking integer DEFAULT nextval('user_metric0_pk_seq'::text) NOT NULL,
1147 user_id integer DEFAULT 0 NOT NULL,
1148 times_ranked integer DEFAULT 0 NOT NULL,
1149 avg_raters_importance double precision DEFAULT (0)::double precision NOT NULL,
1150 avg_rating double precision DEFAULT (0)::double precision NOT NULL,
1151 metric double precision DEFAULT (0)::double precision NOT NULL,
1152 percentile double precision DEFAULT (0)::double precision NOT NULL,
1153 importance_factor double precision DEFAULT (0)::double precision NOT NULL
1158 CREATE TABLE user_preferences (
1159 user_id integer DEFAULT 0 NOT NULL,
1160 preference_name character varying(20) NOT NULL,
1161 dead1 character varying(20),
1162 set_date integer DEFAULT 0 NOT NULL,
1163 preference_value text
1168 CREATE TABLE user_ratings (
1169 rated_by integer DEFAULT 0 NOT NULL,
1170 user_id integer DEFAULT 0 NOT NULL,
1171 rate_field integer DEFAULT 0 NOT NULL,
1172 rating integer DEFAULT 0 NOT NULL
1177 CREATE SEQUENCE users_pk_seq
1185 CREATE TABLE users (
1186 user_id integer DEFAULT nextval('users_pk_seq'::text) NOT NULL,
1187 user_name text DEFAULT ''::text NOT NULL,
1188 email text DEFAULT ''::text NOT NULL,
1189 user_pw character varying(32) DEFAULT ''::character varying NOT NULL,
1190 realname character varying(32) DEFAULT ''::character varying NOT NULL,
1191 status character(1) DEFAULT 'A'::bpchar NOT NULL,
1192 shell character varying(20) DEFAULT '/bin/bash'::character varying NOT NULL,
1193 unix_pw character varying(40) DEFAULT ''::character varying NOT NULL,
1194 unix_status character(1) DEFAULT 'N'::bpchar NOT NULL,
1195 unix_uid integer DEFAULT 0 NOT NULL,
1196 unix_box character varying(10) DEFAULT 'shell1'::character varying NOT NULL,
1197 add_date integer DEFAULT 0 NOT NULL,
1198 confirm_hash character varying(32),
1199 mail_siteupdates integer DEFAULT 0 NOT NULL,
1200 mail_va integer DEFAULT 0 NOT NULL,
1201 authorized_keys text,
1203 people_view_skills integer DEFAULT 0 NOT NULL,
1204 people_resume text DEFAULT ''::text NOT NULL,
1205 timezone character varying(64) DEFAULT 'GMT'::character varying,
1206 "language" integer DEFAULT 1 NOT NULL,
1207 block_ratings integer DEFAULT 0,
1208 jabber_address text,
1209 jabber_only integer,
1214 firstname character varying(60),
1215 lastname character varying(60),
1217 ccode character(2) DEFAULT 'US'::bpchar,
1219 type_id integer DEFAULT 1,
1220 unix_gid integer DEFAULT 0
1225 CREATE SEQUENCE unix_uid_seq
1234 CREATE SEQUENCE forum_thread_seq
1243 CREATE TABLE project_sums_agg (
1244 group_id integer DEFAULT 0 NOT NULL,
1245 "type" character(4) NOT NULL,
1246 count integer DEFAULT 0 NOT NULL
1251 CREATE SEQUENCE project_metric_wee_ranking1_seq
1260 CREATE SEQUENCE prdb_dbs_dbid_seq
1269 CREATE TABLE prdb_dbs (
1270 dbid integer DEFAULT nextval('"prdb_dbs_dbid_seq"'::text) NOT NULL,
1271 group_id integer NOT NULL,
1272 dbname text NOT NULL,
1273 dbusername text NOT NULL,
1274 dbuserpass text NOT NULL,
1275 requestdate integer NOT NULL,
1276 dbtype integer NOT NULL,
1277 created_by integer NOT NULL,
1278 state integer NOT NULL
1283 CREATE TABLE prdb_states (
1284 stateid integer NOT NULL,
1290 CREATE TABLE prdb_types (
1291 dbtypeid integer NOT NULL,
1292 dbservername text NOT NULL,
1293 dbsoftware text NOT NULL
1298 CREATE SEQUENCE prweb_vhost_vhostid_seq
1307 CREATE TABLE prweb_vhost (
1308 vhostid integer DEFAULT nextval('"prweb_vhost_vhostid_seq"'::text) NOT NULL,
1312 group_id integer NOT NULL
1317 CREATE SEQUENCE artifact_grou_group_artifac_seq
1325 CREATE TABLE artifact_group_list (
1326 group_artifact_id integer DEFAULT nextval('"artifact_grou_group_artifac_seq"'::text) NOT NULL,
1327 group_id integer NOT NULL,
1330 is_public integer DEFAULT 0 NOT NULL,
1331 allow_anon integer DEFAULT 0 NOT NULL,
1332 email_all_updates integer DEFAULT 0 NOT NULL,
1333 email_address text NOT NULL,
1334 due_period integer DEFAULT 2592000 NOT NULL,
1335 submit_instructions text,
1336 browse_instructions text,
1337 datatype integer DEFAULT 0 NOT NULL,
1338 status_timeout integer,
1339 custom_status_field integer DEFAULT 0 NOT NULL,
1340 custom_renderer text
1345 CREATE SEQUENCE artifact_status_id_seq
1353 CREATE TABLE artifact_status (
1354 id integer DEFAULT nextval('"artifact_status_id_seq"'::text) NOT NULL,
1355 status_name text NOT NULL
1360 CREATE SEQUENCE artifact_artifact_id_seq
1369 CREATE TABLE artifact (
1370 artifact_id integer DEFAULT nextval('"artifact_artifact_id_seq"'::text) NOT NULL,
1371 group_artifact_id integer NOT NULL,
1372 status_id integer DEFAULT 1 NOT NULL,
1373 priority integer DEFAULT 3 NOT NULL,
1374 submitted_by integer DEFAULT 100 NOT NULL,
1375 assigned_to integer DEFAULT 100 NOT NULL,
1376 open_date integer DEFAULT 0 NOT NULL,
1377 close_date integer DEFAULT 0 NOT NULL,
1378 summary text NOT NULL,
1379 details text NOT NULL,
1380 last_modified_date integer
1385 CREATE SEQUENCE artifact_history_id_seq
1394 CREATE TABLE artifact_history (
1395 id integer DEFAULT nextval('"artifact_history_id_seq"'::text) NOT NULL,
1396 artifact_id integer DEFAULT 0 NOT NULL,
1397 field_name text DEFAULT ''::text NOT NULL,
1398 old_value text DEFAULT ''::text NOT NULL,
1399 mod_by integer DEFAULT 0 NOT NULL,
1400 entrydate integer DEFAULT 0 NOT NULL
1405 CREATE VIEW artifact_history_user_vw AS
1406 SELECT ah.id, ah.artifact_id, ah.field_name, ah.old_value, ah.entrydate, users.user_name FROM artifact_history ah, users WHERE (ah.mod_by = users.user_id);
1410 CREATE SEQUENCE artifact_file_id_seq
1419 CREATE TABLE artifact_file (
1420 id integer DEFAULT nextval('"artifact_file_id_seq"'::text) NOT NULL,
1421 artifact_id integer NOT NULL,
1422 description text NOT NULL,
1423 bin_data text NOT NULL,
1424 filename text NOT NULL,
1425 filesize integer NOT NULL,
1426 filetype text NOT NULL,
1427 adddate integer DEFAULT 0 NOT NULL,
1428 submitted_by integer NOT NULL
1433 CREATE VIEW artifact_file_user_vw AS
1434 SELECT af.id, af.artifact_id, af.description, af.bin_data, af.filename, af.filesize, af.filetype, af.adddate, af.submitted_by, users.user_name, users.realname FROM artifact_file af, users WHERE (af.submitted_by = users.user_id);
1438 CREATE SEQUENCE artifact_message_id_seq
1447 CREATE TABLE artifact_message (
1448 id integer DEFAULT nextval('"artifact_message_id_seq"'::text) NOT NULL,
1449 artifact_id integer NOT NULL,
1450 submitted_by integer NOT NULL,
1451 from_email text NOT NULL,
1452 adddate integer DEFAULT 0 NOT NULL,
1458 CREATE VIEW artifact_message_user_vw AS
1459 SELECT am.id, am.artifact_id, am.from_email, am.body, am.adddate, users.user_id, users.email, users.user_name, users.realname FROM artifact_message am, users WHERE (am.submitted_by = users.user_id);
1463 CREATE SEQUENCE artifact_monitor_id_seq
1472 CREATE TABLE artifact_monitor (
1473 id integer DEFAULT nextval('"artifact_monitor_id_seq"'::text) NOT NULL,
1474 artifact_id integer NOT NULL,
1475 user_id integer NOT NULL,
1481 CREATE SEQUENCE artifact_canned_response_id_seq
1490 CREATE TABLE artifact_canned_responses (
1491 id integer DEFAULT nextval('"artifact_canned_response_id_seq"'::text) NOT NULL,
1492 group_artifact_id integer NOT NULL,
1493 title text NOT NULL,
1499 CREATE TABLE artifact_counts_agg (
1500 group_artifact_id integer NOT NULL,
1501 count integer DEFAULT 0 NOT NULL,
1502 open_count integer DEFAULT 0
1507 CREATE TABLE stats_site_pages_by_day (
1510 site_page_views integer
1515 CREATE FUNCTION forumgrouplist_insert_agg() RETURNS "trigger"
1518 INSERT INTO forum_agg_msg_count (group_forum_id,count)
1519 VALUES (NEW.group_forum_id,0);
1527 CREATE FUNCTION artifactgrouplist_insert_agg() RETURNS "trigger"
1530 INSERT INTO artifact_counts_agg (group_artifact_id,count,open_count)
1531 VALUES (NEW.group_artifact_id,0,0);
1539 CREATE FUNCTION artifactgroup_update_agg() RETURNS "trigger"
1543 -- see if they are moving to a new artifacttype
1544 -- if so, its a more complex operation
1546 IF NEW.group_artifact_id <> OLD.group_artifact_id THEN
1548 -- transferred artifacts always have a status of 1
1549 -- so we will increment the new artifacttypes sums
1551 IF OLD.status_id=3 THEN
1552 -- No need to decrement counters on old tracker
1554 IF OLD.status_id=2 THEN
1555 UPDATE artifact_counts_agg SET count=count-1
1556 WHERE group_artifact_id=OLD.group_artifact_id;
1558 IF OLD.status_id=1 THEN
1559 UPDATE artifact_counts_agg SET count=count-1,open_count=open_count-1
1560 WHERE group_artifact_id=OLD.group_artifact_id;
1565 IF NEW.status_id=3 THEN
1568 IF NEW.status_id=2 THEN
1569 UPDATE artifact_counts_agg SET count=count+1
1570 WHERE group_artifact_id=NEW.group_artifact_id;
1572 IF NEW.status_id=1 THEN
1573 UPDATE artifact_counts_agg SET count=count+1, open_count=open_count+1
1574 WHERE group_artifact_id=NEW.group_artifact_id;
1580 -- just need to evaluate the status flag and
1581 -- increment/decrement the counter as necessary
1583 IF NEW.status_id <> OLD.status_id THEN
1584 IF NEW.status_id = 1 THEN
1585 IF OLD.status_id=2 THEN
1586 UPDATE artifact_counts_agg SET open_count=open_count+1
1587 WHERE group_artifact_id=NEW.group_artifact_id;
1589 IF OLD.status_id=3 THEN
1590 UPDATE artifact_counts_agg SET open_count=open_count+1, count=count+1
1591 WHERE group_artifact_id=NEW.group_artifact_id;
1595 IF NEW.status_id = 2 THEN
1596 IF OLD.status_id=1 THEN
1597 UPDATE artifact_counts_agg SET open_count=open_count-1
1598 WHERE group_artifact_id=NEW.group_artifact_id;
1600 IF OLD.status_id=3 THEN
1601 UPDATE artifact_counts_agg SET count=count+1
1602 WHERE group_artifact_id=NEW.group_artifact_id;
1606 IF NEW.status_id = 3 THEN
1607 IF OLD.status_id=2 THEN
1608 UPDATE artifact_counts_agg SET count=count-1
1609 WHERE group_artifact_id=NEW.group_artifact_id;
1611 IF OLD.status_id=1 THEN
1612 UPDATE artifact_counts_agg SET open_count=open_count-1,count=count-1
1613 WHERE group_artifact_id=NEW.group_artifact_id;
1628 CREATE SEQUENCE massmail_queue_id_seq
1637 CREATE TABLE massmail_queue (
1638 id integer DEFAULT nextval('"massmail_queue_id_seq"'::text) NOT NULL,
1639 "type" character varying(8) NOT NULL,
1640 subject text NOT NULL,
1641 message text NOT NULL,
1642 queued_date integer NOT NULL,
1643 last_userid integer DEFAULT 0 NOT NULL,
1644 failed_date integer DEFAULT 0 NOT NULL,
1645 finished_date integer DEFAULT 0 NOT NULL
1650 CREATE TABLE stats_agg_site_by_group (
1659 CREATE TABLE stats_project_metric (
1660 "month" integer DEFAULT 0 NOT NULL,
1661 "day" integer DEFAULT 0 NOT NULL,
1662 ranking integer DEFAULT 0 NOT NULL,
1663 percentile double precision DEFAULT 0 NOT NULL,
1664 group_id integer DEFAULT 0 NOT NULL
1669 CREATE TABLE stats_agg_logo_by_group (
1678 CREATE TABLE stats_subd_pages (
1679 "month" integer DEFAULT 0 NOT NULL,
1680 "day" integer DEFAULT 0 NOT NULL,
1681 group_id integer DEFAULT 0 NOT NULL,
1682 pages integer DEFAULT 0 NOT NULL
1687 CREATE TABLE stats_cvs_user (
1688 "month" integer DEFAULT 0 NOT NULL,
1689 "day" integer DEFAULT 0 NOT NULL,
1690 group_id integer DEFAULT 0 NOT NULL,
1691 user_id integer DEFAULT 0 NOT NULL,
1692 checkouts integer DEFAULT 0 NOT NULL,
1693 commits integer DEFAULT 0 NOT NULL,
1694 adds integer DEFAULT 0 NOT NULL
1699 CREATE TABLE stats_cvs_group (
1700 "month" integer DEFAULT 0 NOT NULL,
1701 "day" integer DEFAULT 0 NOT NULL,
1702 group_id integer DEFAULT 0 NOT NULL,
1703 checkouts integer DEFAULT 0 NOT NULL,
1704 commits integer DEFAULT 0 NOT NULL,
1705 adds integer DEFAULT 0 NOT NULL
1710 CREATE TABLE stats_project_developers (
1711 "month" integer DEFAULT 0 NOT NULL,
1712 "day" integer DEFAULT 0 NOT NULL,
1713 group_id integer DEFAULT 0 NOT NULL,
1714 developers integer DEFAULT 0 NOT NULL
1719 CREATE TABLE stats_project (
1720 "month" integer DEFAULT 0 NOT NULL,
1721 "day" integer DEFAULT 0 NOT NULL,
1722 group_id integer DEFAULT 0 NOT NULL,
1723 file_releases integer DEFAULT 0,
1724 msg_posted integer DEFAULT 0,
1725 msg_uniq_auth integer DEFAULT 0,
1726 bugs_opened integer DEFAULT 0,
1727 bugs_closed integer DEFAULT 0,
1728 support_opened integer DEFAULT 0,
1729 support_closed integer DEFAULT 0,
1730 patches_opened integer DEFAULT 0,
1731 patches_closed integer DEFAULT 0,
1732 artifacts_opened integer DEFAULT 0,
1733 artifacts_closed integer DEFAULT 0,
1734 tasks_opened integer DEFAULT 0,
1735 tasks_closed integer DEFAULT 0,
1736 help_requests integer DEFAULT 0
1741 CREATE TABLE stats_site (
1746 total_users integer,
1748 new_projects integer
1753 CREATE TABLE activity_log (
1754 "day" integer DEFAULT 0 NOT NULL,
1755 "hour" integer DEFAULT 0 NOT NULL,
1756 group_id integer DEFAULT 0 NOT NULL,
1757 browser character varying(8) DEFAULT 'OTHER'::character varying NOT NULL,
1758 ver double precision DEFAULT (0)::double precision NOT NULL,
1759 platform character varying(8) DEFAULT 'OTHER'::character varying NOT NULL,
1760 "time" integer DEFAULT 0 NOT NULL,
1762 "type" integer DEFAULT 0 NOT NULL
1767 CREATE TABLE user_metric_history (
1768 "month" integer NOT NULL,
1769 "day" integer NOT NULL,
1770 user_id integer NOT NULL,
1771 ranking integer NOT NULL,
1772 metric double precision NOT NULL
1777 CREATE TABLE frs_dlstats_filetotal_agg (
1778 file_id integer NOT NULL,
1784 CREATE TABLE stats_project_months (
1788 group_ranking integer,
1789 group_metric double precision,
1790 logo_showings integer,
1793 subdomain_views integer,
1795 file_releases integer,
1797 msg_uniq_auth integer,
1798 bugs_opened integer,
1799 bugs_closed integer,
1800 support_opened integer,
1801 support_closed integer,
1802 patches_opened integer,
1803 patches_closed integer,
1804 artifacts_opened integer,
1805 artifacts_closed integer,
1806 tasks_opened integer,
1807 tasks_closed integer,
1808 help_requests integer,
1809 cvs_checkouts integer,
1810 cvs_commits integer,
1816 CREATE TABLE stats_site_pages_by_month (
1818 site_page_views integer
1823 CREATE TABLE stats_site_months (
1825 site_page_views integer,
1827 subdomain_views integer,
1829 bugs_opened integer,
1830 bugs_closed integer,
1831 support_opened integer,
1832 support_closed integer,
1833 patches_opened integer,
1834 patches_closed integer,
1835 artifacts_opened integer,
1836 artifacts_closed integer,
1837 tasks_opened integer,
1838 tasks_closed integer,
1839 help_requests integer,
1840 cvs_checkouts integer,
1841 cvs_commits integer,
1847 CREATE TABLE trove_agg (
1848 trove_cat_id integer,
1850 group_name character varying(40),
1851 unix_group_name character varying(30),
1852 status character(1),
1853 register_time integer,
1854 short_description character varying(255),
1855 percentile double precision,
1861 CREATE SEQUENCE trove_treesum_trove_treesum_seq
1870 CREATE TABLE trove_treesums (
1871 trove_treesums_id integer DEFAULT nextval('"trove_treesum_trove_treesum_seq"'::text) NOT NULL,
1872 trove_cat_id integer DEFAULT 0 NOT NULL,
1873 limit_1 integer DEFAULT 0 NOT NULL,
1874 subprojects integer DEFAULT 0 NOT NULL
1879 CREATE TABLE frs_dlstats_file (
1889 CREATE SEQUENCE group_cvs_history_id_seq
1898 CREATE TABLE group_cvs_history (
1899 id integer DEFAULT nextval('"group_cvs_history_id_seq"'::text) NOT NULL,
1900 group_id integer DEFAULT 0 NOT NULL,
1901 user_name character varying(80) DEFAULT ''::character varying NOT NULL,
1902 cvs_commits integer DEFAULT 0 NOT NULL,
1903 cvs_commits_wk integer DEFAULT 0 NOT NULL,
1904 cvs_adds integer DEFAULT 0 NOT NULL,
1905 cvs_adds_wk integer DEFAULT 0 NOT NULL
1910 CREATE SEQUENCE themes_theme_id_seq
1918 CREATE TABLE themes (
1919 theme_id integer DEFAULT nextval('"themes_theme_id_seq"'::text) NOT NULL,
1920 dirname character varying(80),
1921 fullname character varying(80),
1922 enabled boolean DEFAULT true
1927 CREATE SEQUENCE supported_langu_language_id_seq
1935 CREATE TABLE supported_languages (
1936 language_id integer DEFAULT nextval('"supported_langu_language_id_seq"'::text) NOT NULL,
1940 language_code character(5)
1945 CREATE SEQUENCE skills_data_pk_seq
1954 CREATE SEQUENCE skills_data_types_pk_seq
1962 CREATE TABLE skills_data_types (
1963 type_id integer DEFAULT nextval('skills_data_types_pk_seq'::text) NOT NULL,
1964 type_name character varying(25) DEFAULT ''::character varying NOT NULL
1969 CREATE TABLE skills_data (
1970 skills_data_id integer DEFAULT nextval('skills_data_pk_seq'::text) NOT NULL,
1971 user_id integer DEFAULT 0 NOT NULL,
1972 "type" integer DEFAULT 0 NOT NULL,
1973 title character varying(100) DEFAULT ''::character varying NOT NULL,
1974 "start" integer DEFAULT 0 NOT NULL,
1975 finish integer DEFAULT 0 NOT NULL,
1976 keywords character varying(255) DEFAULT ''::character varying NOT NULL
1981 CREATE VIEW frs_file_vw AS
1982 SELECT frs_file.file_id, frs_file.filename, frs_file.release_id, frs_file.type_id, frs_file.processor_id, frs_file.release_time, frs_file.file_size, frs_file.post_date, frs_filetype.name AS filetype, frs_processor.name AS processor, frs_dlstats_filetotal_agg.downloads FROM frs_filetype, frs_processor, (frs_file LEFT JOIN frs_dlstats_filetotal_agg ON ((frs_dlstats_filetotal_agg.file_id = frs_file.file_id))) WHERE ((frs_filetype.type_id = frs_file.type_id) AND (frs_processor.processor_id = frs_file.processor_id));
1986 CREATE SEQUENCE project_categor_category_id_seq
1994 CREATE TABLE project_category (
1995 category_id integer DEFAULT nextval('"project_categor_category_id_seq"'::text) NOT NULL,
1996 group_project_id integer,
2002 CREATE TABLE project_task_artifact (
2003 project_task_id integer NOT NULL,
2004 artifact_id integer NOT NULL
2009 CREATE VIEW project_history_user_vw AS
2010 SELECT users.realname, users.email, users.user_name, project_history.project_history_id, project_history.project_task_id, project_history.field_name, project_history.old_value, project_history.mod_by, project_history.mod_date FROM users, project_history WHERE (project_history.mod_by = users.user_id);
2014 CREATE SEQUENCE project_messa_project_messa_seq
2023 CREATE TABLE project_messages (
2024 project_message_id integer DEFAULT nextval('"project_messa_project_messa_seq"'::text) NOT NULL,
2025 project_task_id integer NOT NULL,
2027 posted_by integer NOT NULL,
2028 postdate integer NOT NULL
2033 CREATE VIEW project_message_user_vw AS
2034 SELECT users.realname, users.email, users.user_name, project_messages.project_message_id, project_messages.project_task_id, project_messages.body, project_messages.posted_by, project_messages.postdate FROM users, project_messages WHERE (project_messages.posted_by = users.user_id);
2038 CREATE FUNCTION frs_dlstats_filetotal_insert_ag() RETURNS "trigger"
2041 INSERT INTO frs_dlstats_filetotal_agg (file_id, downloads) VALUES (NEW.file_id, 0);
2049 CREATE VIEW frs_dlstats_file_agg_vw AS
2050 SELECT frs_dlstats_file."month", frs_dlstats_file."day", frs_dlstats_file.file_id, count(*) AS downloads FROM frs_dlstats_file GROUP BY frs_dlstats_file."month", frs_dlstats_file."day", frs_dlstats_file.file_id;
2054 CREATE VIEW frs_dlstats_grouptotal_vw AS
2055 SELECT frs_package.group_id, sum(frs_dlstats_filetotal_agg.downloads) AS downloads FROM frs_package, frs_release, frs_file, frs_dlstats_filetotal_agg WHERE (((frs_package.package_id = frs_release.package_id) AND (frs_release.release_id = frs_file.release_id)) AND (frs_file.file_id = frs_dlstats_filetotal_agg.file_id)) GROUP BY frs_package.group_id;
2059 CREATE VIEW frs_dlstats_group_vw AS
2060 SELECT frs_package.group_id, fdfa."month", fdfa."day", sum(fdfa.downloads) AS downloads FROM frs_package, frs_release, frs_file, frs_dlstats_file_agg_vw fdfa WHERE (((frs_package.package_id = frs_release.package_id) AND (frs_release.release_id = frs_file.release_id)) AND (frs_file.file_id = fdfa.file_id)) GROUP BY frs_package.group_id, fdfa."month", fdfa."day";
2064 CREATE VIEW stats_project_vw AS
2065 SELECT spd.group_id, spd."month", spd."day", spd.developers, spm.ranking AS group_ranking, spm.percentile AS group_metric, salbg.count AS logo_showings, fdga.downloads, sasbg.count AS site_views, ssp.pages AS subdomain_views, (CASE WHEN (sasbg.count IS NOT NULL) THEN sasbg.count WHEN (0 IS NOT NULL) THEN 0 ELSE NULL::integer END + CASE WHEN (ssp.pages IS NOT NULL) THEN ssp.pages WHEN (0 IS NOT NULL) THEN 0 ELSE NULL::integer END) AS page_views, sp.file_releases, sp.msg_posted, sp.msg_uniq_auth, sp.bugs_opened, sp.bugs_closed, sp.support_opened, sp.support_closed, sp.patches_opened, sp.patches_closed, sp.artifacts_opened, sp.artifacts_closed, sp.tasks_opened, sp.tasks_closed, sp.help_requests, scg.checkouts AS cvs_checkouts, scg.commits AS cvs_commits, scg.adds AS cvs_adds FROM (((((((stats_project_developers spd LEFT JOIN stats_project sp USING ("month", "day", group_id)) LEFT JOIN stats_project_metric spm USING ("month", "day", group_id)) LEFT JOIN stats_cvs_group scg USING ("month", "day", group_id)) LEFT JOIN stats_agg_site_by_group sasbg USING ("month", "day", group_id)) LEFT JOIN stats_agg_logo_by_group salbg USING ("month", "day", group_id)) LEFT JOIN stats_subd_pages ssp USING ("month", "day", group_id)) LEFT JOIN frs_dlstats_group_vw fdga USING ("month", "day", group_id));
2069 CREATE VIEW stats_project_all_vw AS
2070 SELECT stats_project_months.group_id, int4(avg(stats_project_months.developers)) AS developers, int4(avg(stats_project_months.group_ranking)) AS group_ranking, avg(stats_project_months.group_metric) AS group_metric, sum(stats_project_months.logo_showings) AS logo_showings, sum(stats_project_months.downloads) AS downloads, sum(stats_project_months.site_views) AS site_views, sum(stats_project_months.subdomain_views) AS subdomain_views, sum(stats_project_months.page_views) AS page_views, sum(stats_project_months.file_releases) AS file_releases, sum(stats_project_months.msg_posted) AS msg_posted, int4(avg(stats_project_months.msg_uniq_auth)) AS msg_uniq_auth, sum(stats_project_months.bugs_opened) AS bugs_opened, sum(stats_project_months.bugs_closed) AS bugs_closed, sum(stats_project_months.support_opened) AS support_opened, sum(stats_project_months.support_closed) AS support_closed, sum(stats_project_months.patches_opened) AS patches_opened, sum(stats_project_months.patches_closed) AS patches_closed, sum(stats_project_months.artifacts_opened) AS artifacts_opened, sum(stats_project_months.artifacts_closed) AS artifacts_closed, sum(stats_project_months.tasks_opened) AS tasks_opened, sum(stats_project_months.tasks_closed) AS tasks_closed, sum(stats_project_months.help_requests) AS help_requests, sum(stats_project_months.cvs_checkouts) AS cvs_checkouts, sum(stats_project_months.cvs_commits) AS cvs_commits, sum(stats_project_months.cvs_adds) AS cvs_adds FROM stats_project_months GROUP BY stats_project_months.group_id;
2074 CREATE VIEW stats_site_vw AS
2075 SELECT p."month", p."day", sspbd.site_page_views, sum(p.downloads) AS downloads, sum(p.subdomain_views) AS subdomain_views, sum(p.msg_posted) AS msg_posted, sum(p.bugs_opened) AS bugs_opened, sum(p.bugs_closed) AS bugs_closed, sum(p.support_opened) AS support_opened, sum(p.support_closed) AS support_closed, sum(p.patches_opened) AS patches_opened, sum(p.patches_closed) AS patches_closed, sum(p.artifacts_opened) AS artifacts_opened, sum(p.artifacts_closed) AS artifacts_closed, sum(p.tasks_opened) AS tasks_opened, sum(p.tasks_closed) AS tasks_closed, sum(p.help_requests) AS help_requests, sum(p.cvs_checkouts) AS cvs_checkouts, sum(p.cvs_commits) AS cvs_commits, sum(p.cvs_adds) AS cvs_adds FROM stats_project_vw p, stats_site_pages_by_day sspbd WHERE ((p."month" = sspbd."month") AND (p."day" = sspbd."day")) GROUP BY p."month", p."day", sspbd.site_page_views;
2079 CREATE VIEW stats_site_all_vw AS
2080 SELECT sum(stats_site_months.site_page_views) AS site_page_views, sum(stats_site_months.downloads) AS downloads, sum(stats_site_months.subdomain_views) AS subdomain_views, sum(stats_site_months.msg_posted) AS msg_posted, sum(stats_site_months.bugs_opened) AS bugs_opened, sum(stats_site_months.bugs_closed) AS bugs_closed, sum(stats_site_months.support_opened) AS support_opened, sum(stats_site_months.support_closed) AS support_closed, sum(stats_site_months.patches_opened) AS patches_opened, sum(stats_site_months.patches_closed) AS patches_closed, sum(stats_site_months.artifacts_opened) AS artifacts_opened, sum(stats_site_months.artifacts_closed) AS artifacts_closed, sum(stats_site_months.tasks_opened) AS tasks_opened, sum(stats_site_months.tasks_closed) AS tasks_closed, sum(stats_site_months.help_requests) AS help_requests, sum(stats_site_months.cvs_checkouts) AS cvs_checkouts, sum(stats_site_months.cvs_commits) AS cvs_commits, sum(stats_site_months.cvs_adds) AS cvs_adds FROM stats_site_months;
2084 CREATE SEQUENCE plugins_pk_seq
2092 CREATE TABLE plugins (
2093 plugin_id integer DEFAULT nextval('plugins_pk_seq'::text) NOT NULL,
2094 plugin_name character varying(32) NOT NULL,
2100 CREATE SEQUENCE group_plugin_pk_seq
2108 CREATE TABLE group_plugin (
2109 group_plugin_id integer DEFAULT nextval('group_plugin_pk_seq'::text) NOT NULL,
2116 CREATE SEQUENCE user_plugin_pk_seq
2125 CREATE TABLE user_plugin (
2126 user_plugin_id integer DEFAULT nextval('user_plugin_pk_seq'::text) NOT NULL,
2127 user_id integer NOT NULL,
2128 plugin_id integer NOT NULL
2133 CREATE TABLE cron_history (
2134 rundate integer NOT NULL,
2141 CREATE TABLE country_code (
2142 country_name character varying(80),
2143 ccode character(2) NOT NULL
2148 CREATE TABLE licenses (
2149 license_id serial NOT NULL,
2155 CREATE TABLE user_type (
2156 type_id serial NOT NULL,
2163 role_id serial NOT NULL,
2164 group_id integer NOT NULL,
2170 CREATE TABLE role_setting (
2171 role_id integer NOT NULL,
2172 section_name text NOT NULL,
2173 ref_id integer NOT NULL,
2174 value character varying(2) NOT NULL
2178 CREATE VIEW artifact_perm AS
2181 role_setting.ref_id AS group_artifact_id,
2183 role_setting.value::int AS perm_level
2184 FROM role_setting, user_group
2185 WHERE user_group.role_id = role_setting.role_id
2186 AND role_setting.section_name='tracker';
2190 CREATE VIEW artifactperm_artgrouplist_vw AS
2192 agl.group_artifact_id, agl.name, agl.description,
2193 agl.group_id, ap.user_id, ap.perm_level
2194 FROM artifact_perm ap, artifact_group_list agl
2195 WHERE (ap.group_artifact_id = agl.group_artifact_id) ;
2198 CREATE VIEW artifactperm_user_vw AS
2200 ap.id, ap.group_artifact_id, ap.user_id, ap.perm_level,
2201 users.user_name, users.realname
2202 FROM artifact_perm ap, users
2203 WHERE (users.user_id = ap.user_id) ;
2206 CREATE VIEW project_perm AS
2209 role_setting.ref_id AS group_project_id,
2211 role_setting.value::int AS perm_level
2212 FROM role_setting, user_group
2213 WHERE user_group.role_id = role_setting.role_id
2214 AND role_setting.section_name='pm';
2217 CREATE VIEW forum_perm AS
2220 role_setting.ref_id AS group_forum_id,
2222 role_setting.value::int AS perm_level
2223 FROM role_setting, user_group
2224 WHERE user_group.role_id = role_setting.role_id
2225 AND role_setting.section_name='forum';
2228 CREATE TABLE artifact_extra_field_list (
2229 extra_field_id integer DEFAULT nextval('artifact_extra_field_list_extra_field_id_seq'::text) NOT NULL,
2230 group_artifact_id integer NOT NULL,
2231 field_name text NOT NULL,
2232 field_type integer DEFAULT 1,
2233 attribute1 integer DEFAULT 0,
2234 attribute2 integer DEFAULT 0,
2235 is_required integer DEFAULT 0 NOT NULL,
2241 CREATE TABLE artifact_extra_field_elements (
2242 element_id integer DEFAULT nextval('artifact_extra_field_elements_element_id_seq'::text) NOT NULL,
2243 extra_field_id integer NOT NULL,
2244 element_name text NOT NULL,
2245 status_id integer DEFAULT 0 NOT NULL,
2251 CREATE TABLE artifact_extra_field_data (
2252 data_id integer DEFAULT nextval('artifact_extra_field_data_data_id_seq'::text) NOT NULL,
2253 artifact_id integer NOT NULL,
2255 extra_field_id integer DEFAULT 0
2260 CREATE TABLE project_counts_agg (
2261 group_project_id integer NOT NULL,
2262 count integer DEFAULT 0 NOT NULL,
2263 open_count integer DEFAULT 0
2268 CREATE VIEW project_group_list_vw AS
2269 SELECT group_project_id, group_id, project_name, is_public, description, send_all_posts_to, count, open_count FROM (project_group_list NATURAL JOIN project_counts_agg);
2273 CREATE FUNCTION projectgrouplist_insert_agg() RETURNS "trigger"
2276 INSERT INTO project_counts_agg (group_project_id,count,open_count)
2277 VALUES (NEW.group_project_id,0,0);
2285 CREATE FUNCTION projectgroup_update_agg() RETURNS "trigger"
2289 -- see if they are moving to a new subproject
2290 -- if so, its a more complex operation
2292 IF NEW.group_project_id <> OLD.group_project_id THEN
2294 -- transferred tasks always have a status of 1
2295 -- so we will increment the new subprojects sums
2297 IF OLD.status_id=3 THEN
2298 -- No need to decrement counters on old tracker
2300 IF OLD.status_id=2 THEN
2301 UPDATE project_counts_agg SET count=count-1
2302 WHERE group_project_id=OLD.group_project_id;
2304 IF OLD.status_id=1 THEN
2305 UPDATE project_counts_agg SET count=count-1,open_count=open_count-1
2306 WHERE group_project_id=OLD.group_project_id;
2311 IF NEW.status_id=3 THEN
2314 IF NEW.status_id=2 THEN
2315 UPDATE project_counts_agg SET count=count+1
2316 WHERE group_project_id=NEW.group_project_id;
2318 IF NEW.status_id=1 THEN
2319 UPDATE project_counts_agg SET count=count+1, open_count=open_count+1
2320 WHERE group_project_id=NEW.group_project_id;
2326 -- just need to evaluate the status flag and
2327 -- increment/decrement the counter as necessary
2329 IF NEW.status_id <> OLD.status_id THEN
2330 IF NEW.status_id = 1 THEN
2331 IF OLD.status_id=2 THEN
2332 UPDATE project_counts_agg SET open_count=open_count+1
2333 WHERE group_project_id=NEW.group_project_id;
2335 IF OLD.status_id=3 THEN
2336 UPDATE project_counts_agg SET open_count=open_count+1, count=count+1
2337 WHERE group_project_id=NEW.group_project_id;
2341 IF NEW.status_id = 2 THEN
2342 IF OLD.status_id=1 THEN
2343 UPDATE project_counts_agg SET open_count=open_count-1
2344 WHERE group_project_id=NEW.group_project_id;
2346 IF OLD.status_id=3 THEN
2347 UPDATE project_counts_agg SET count=count+1
2348 WHERE group_project_id=NEW.group_project_id;
2352 IF NEW.status_id = 3 THEN
2353 IF OLD.status_id=2 THEN
2354 UPDATE project_counts_agg SET count=count-1
2355 WHERE group_project_id=NEW.group_project_id;
2357 IF OLD.status_id=1 THEN
2358 UPDATE project_counts_agg SET open_count=open_count-1,count=count-1
2359 WHERE group_project_id=NEW.group_project_id;
2374 CREATE VIEW project_depend_vw AS
2375 SELECT pt.project_task_id, pd.is_dependent_on_task_id, pd.link_type, pt.end_date, pt.start_date FROM (project_task pt NATURAL JOIN project_dependencies pd);
2379 CREATE VIEW project_dependon_vw AS
2380 SELECT pd.project_task_id, pd.is_dependent_on_task_id, pd.link_type, pt.end_date, pt.start_date FROM (project_task pt FULL JOIN project_dependencies pd ON ((pd.is_dependent_on_task_id = pt.project_task_id)));
2384 CREATE TABLE project_task_external_order (
2385 project_task_id integer NOT NULL,
2386 external_id integer NOT NULL
2391 CREATE TABLE group_join_request (
2392 group_id integer NOT NULL,
2393 user_id integer NOT NULL,
2395 request_date integer
2400 CREATE FUNCTION update_last_modified_date() RETURNS "trigger"
2403 NEW.last_modified_date = EXTRACT(EPOCH FROM now())::integer;
2411 CREATE VIEW project_task_vw AS
2412 SELECT project_task.project_task_id, project_task.group_project_id, project_task.summary, project_task.details, project_task.percent_complete, project_task.priority, project_task.hours, project_task.start_date, project_task.end_date, project_task.created_by, project_task.status_id, project_task.category_id, project_task.duration, project_task.parent_id, project_task.last_modified_date, project_category.category_name, project_status.status_name, users.user_name, users.realname FROM (((project_task FULL JOIN project_category ON ((project_category.category_id = project_task.category_id))) FULL JOIN users ON ((users.user_id = project_task.created_by))) NATURAL JOIN project_status);
2416 CREATE TABLE artifact_type_monitor (
2417 group_artifact_id integer NOT NULL,
2418 user_id integer NOT NULL
2423 CREATE SEQUENCE artifact_extra_field_elements_element_id_seq
2432 CREATE SEQUENCE artifact_extra_field_data_data_id_seq
2441 CREATE SEQUENCE plugin_cvstracker_artifact_seq
2450 CREATE TABLE plugin_cvstracker_data_artifact (
2451 id integer DEFAULT nextval('plugin_cvstracker_artifact_seq'::text) NOT NULL,
2452 kind integer DEFAULT 0 NOT NULL,
2453 group_artifact_id integer,
2454 project_task_id integer
2459 CREATE SEQUENCE plugin_cvstracker_master_seq
2468 CREATE TABLE plugin_cvstracker_data_master (
2469 id integer DEFAULT nextval('plugin_cvstracker_master_seq'::text) NOT NULL,
2470 holder_id integer NOT NULL,
2471 log_text text DEFAULT ''::text,
2472 file text DEFAULT ''::text NOT NULL,
2473 prev_version text DEFAULT ''::text,
2474 actual_version text DEFAULT ''::text,
2475 author text DEFAULT ''::text NOT NULL,
2476 cvs_date integer NOT NULL
2481 CREATE VIEW nss_passwd AS
2482 SELECT users.unix_uid AS uid, users.unix_gid AS gid, users.user_name AS login, users.unix_pw AS passwd, users.realname AS gecos, users.shell, users.user_name AS homedir, users.status FROM users WHERE (users.unix_status = 'A'::bpchar);
2486 CREATE VIEW nss_shadow AS
2487 SELECT users.user_name AS login, users.unix_pw AS passwd, 'n'::bpchar AS expired, 'n'::bpchar AS pwchange FROM users WHERE (users.unix_status = 'A'::bpchar);
2491 CREATE TABLE nss_groups (
2494 name character varying(30),
2500 CREATE TABLE nss_usergroups (
2506 unix_group_name character varying
2511 CREATE TABLE deleted_mailing_lists (
2512 mailing_list_name character varying(30),
2513 delete_date integer,
2519 CREATE TABLE deleted_groups (
2520 unix_group_name character varying(30),
2521 delete_date integer,
2527 CREATE FUNCTION project_sums() RETURNS "trigger"
2535 --- Get number of things this group has now
2537 IF TG_ARGV[0]=''surv'' THEN
2538 IF TG_OP=''DELETE'' THEN
2539 SELECT INTO num count(*) FROM surveys WHERE OLD.group_id=group_id AND is_active=1;
2540 curr_group := OLD.group_id;
2542 SELECT INTO num count(*) FROM surveys WHERE NEW.group_id=group_id AND is_active=1;
2543 curr_group := NEW.group_id;
2546 IF TG_ARGV[0]=''mail'' THEN
2547 IF TG_OP=''DELETE'' THEN
2548 SELECT INTO num count(*) FROM mail_group_list WHERE OLD.group_id=group_id AND is_public=1;
2549 curr_group := OLD.group_id;
2551 SELECT INTO num count(*) FROM mail_group_list WHERE NEW.group_id=group_id AND is_public=1;
2552 curr_group := NEW.group_id;
2555 IF TG_ARGV[0]=''fmsg'' THEN
2556 IF TG_OP=''DELETE'' THEN
2557 SELECT INTO curr_group group_id FROM forum_group_list WHERE OLD.group_forum_id=group_forum_id;
2558 SELECT INTO num count(*) FROM forum, forum_group_list WHERE forum.group_forum_id=forum_group_list.group_forum_id AND forum_group_list.is_public=1 AND forum_group_list.group_id=curr_group;
2560 SELECT INTO curr_group group_id FROM forum_group_list WHERE NEW.group_forum_id=group_forum_id;
2561 SELECT INTO num count(*) FROM forum, forum_group_list WHERE forum.group_forum_id=forum_group_list.group_forum_id AND forum_group_list.is_public=1 AND forum_group_list.group_id=curr_group;
2564 IF TG_ARGV[0]=''fora'' THEN
2565 IF TG_OP=''DELETE'' THEN
2566 SELECT INTO num count(*) FROM forum_group_list WHERE OLD.group_id=group_id AND is_public=1;
2567 curr_group = OLD.group_id;
2568 --- also need to update message count
2569 DELETE FROM project_sums_agg WHERE group_id=OLD.group_id AND type=''fmsg'';
2570 INSERT INTO project_sums_agg
2571 SELECT OLD.group_id,''fmsg''::text AS type, count(forum.msg_id) AS count
2572 FROM forum, forum_group_list
2573 WHERE forum.group_forum_id=forum_group_list.group_forum_id AND forum_group_list.is_public=1 AND forum_group_list.group_id=OLD.group_id GROUP BY group_id,type;
2575 SELECT INTO num count(*) FROM forum_group_list WHERE NEW.group_id=group_id AND is_public=1;
2576 curr_group = NEW.group_id;
2580 --- See if this group already has a row in project_sums_agg for these things
2582 SELECT INTO found count(group_id) FROM project_sums_agg WHERE curr_group=group_id AND type=TG_ARGV[0];
2586 --- Create row for this group
2588 INSERT INTO project_sums_agg
2589 VALUES (curr_group, TG_ARGV[0], num);
2594 UPDATE project_sums_agg SET count=num
2595 WHERE curr_group=group_id AND type=TG_ARGV[0];
2598 IF TG_OP=''DELETE'' THEN
2609 CREATE TABLE artifact_query (
2610 artifact_query_id serial NOT NULL,
2611 group_artifact_id integer NOT NULL,
2612 user_id integer NOT NULL,
2613 query_name text NOT NULL,
2614 query_type integer DEFAULT 0 NOT NULL
2619 CREATE TABLE artifact_query_fields (
2620 artifact_query_id integer NOT NULL,
2621 query_field_type text NOT NULL,
2622 query_field_id integer NOT NULL,
2623 query_field_values text NOT NULL
2628 CREATE VIEW artifact_group_list_vw AS
2629 SELECT agl.group_artifact_id, agl.group_id, agl.name, agl.description, agl.is_public, agl.allow_anon, agl.email_all_updates, agl.email_address, agl.due_period, agl.submit_instructions, agl.browse_instructions, agl.datatype, agl.status_timeout, agl.custom_status_field, agl.custom_renderer, aca.count, aca.open_count FROM (artifact_group_list agl LEFT JOIN artifact_counts_agg aca USING (group_artifact_id));
2633 CREATE VIEW artifact_vw AS
2634 SELECT artifact.artifact_id, artifact.group_artifact_id, artifact.status_id, artifact.priority, artifact.submitted_by, artifact.assigned_to, artifact.open_date, artifact.close_date, artifact.summary, artifact.details, u.user_name AS assigned_unixname, u.realname AS assigned_realname, u.email AS assigned_email, u2.user_name AS submitted_unixname, u2.realname AS submitted_realname, u2.email AS submitted_email, artifact_status.status_name, artifact.last_modified_date FROM users u, users u2, artifact_status, artifact WHERE (((artifact.assigned_to = u.user_id) AND (artifact.submitted_by = u2.user_id)) AND (artifact.status_id = artifact_status.id));
2638 CREATE SEQUENCE artifact_extra_field_list_extra_field_id_seq
2647 CREATE VIEW docdata_vw AS
2648 SELECT users.user_name, users.realname, users.email, d.group_id, d.docid, d.stateid, d.title, d.updatedate, d.createdate, d.created_by, d.doc_group, d.description, d.language_id, d.filename, d.filetype, d.filesize, doc_states.name AS state_name, doc_groups.groupname AS group_name, sl.name AS language_name FROM ((((doc_data d NATURAL JOIN doc_states) NATURAL JOIN doc_groups) JOIN supported_languages sl ON ((sl.language_id = d.language_id))) JOIN users ON ((users.user_id = d.created_by)));
2652 CREATE TABLE form_keys (
2653 key_id serial NOT NULL,
2654 "key" text NOT NULL,
2655 creation_date integer NOT NULL,
2656 is_used integer DEFAULT 0 NOT NULL
2661 CREATE TABLE forum_attachment (
2662 attachmentid serial NOT NULL,
2663 userid integer DEFAULT 100 NOT NULL,
2664 dateline integer DEFAULT 0 NOT NULL,
2665 filename character varying(100) DEFAULT ''::character varying NOT NULL,
2666 filedata text NOT NULL,
2667 visible smallint DEFAULT (0)::smallint NOT NULL,
2668 counter smallint DEFAULT (0)::smallint NOT NULL,
2669 filesize integer DEFAULT 0 NOT NULL,
2670 msg_id integer DEFAULT 0 NOT NULL,
2671 filehash character varying(32) DEFAULT ''::character varying NOT NULL,
2672 mimetype character varying(32) DEFAULT 'application/octet-stream' NOT NULL
2677 CREATE TABLE forum_attachment_type (
2678 extension character varying(20) DEFAULT ''::character varying NOT NULL,
2679 mimetype character varying(255) DEFAULT ''::character varying NOT NULL,
2680 size integer DEFAULT 0 NOT NULL,
2681 width smallint DEFAULT (0)::smallint NOT NULL,
2682 height smallint DEFAULT (0)::smallint NOT NULL,
2683 enabled smallint DEFAULT (1)::smallint NOT NULL
2688 CREATE VIEW forum_group_list_vw AS
2689 SELECT forum_group_list.group_forum_id, forum_group_list.group_id, forum_group_list.forum_name, forum_group_list.is_public, forum_group_list.description, forum_group_list.allow_anonymous, forum_group_list.send_all_posts_to, forum_group_list.moderation_level, forum_agg_msg_count.count AS total, (SELECT max(forum.post_date) AS recent FROM forum WHERE (forum.group_forum_id = forum_group_list.group_forum_id)) AS recent, (SELECT count(*) AS count FROM (SELECT forum.thread_id FROM forum WHERE (forum.group_forum_id = forum_group_list.group_forum_id) GROUP BY forum.thread_id) tmp) AS threads FROM (forum_group_list LEFT JOIN forum_agg_msg_count USING (group_forum_id));
2693 CREATE TABLE forum_pending_messages (
2694 msg_id serial NOT NULL,
2695 group_forum_id integer DEFAULT 0 NOT NULL,
2696 posted_by integer DEFAULT 0 NOT NULL,
2697 subject text DEFAULT ''::text NOT NULL,
2698 body text DEFAULT ''::text NOT NULL,
2699 post_date integer DEFAULT 0 NOT NULL,
2700 is_followup_to integer DEFAULT 0 NOT NULL,
2701 thread_id integer DEFAULT 0 NOT NULL,
2702 has_followups integer DEFAULT 0,
2703 most_recent_date integer DEFAULT 0 NOT NULL
2708 CREATE TABLE forum_pending_attachment (
2709 attachmentid serial NOT NULL,
2710 userid integer DEFAULT 100 NOT NULL,
2711 dateline integer DEFAULT 0 NOT NULL,
2712 filename character varying(100) DEFAULT ''::character varying NOT NULL,
2713 filedata text NOT NULL,
2714 visible smallint DEFAULT (0)::smallint NOT NULL,
2715 counter smallint DEFAULT (0)::smallint NOT NULL,
2716 filesize integer DEFAULT 0 NOT NULL,
2717 msg_id integer DEFAULT 0 NOT NULL,
2718 filehash character varying(32) DEFAULT ''::character varying NOT NULL,
2719 mimetype character varying(32) DEFAULT 'application/octet-stream' NOT NULL
2724 CREATE VIEW forum_user_vw AS
2725 SELECT forum.msg_id, forum.group_forum_id, forum.posted_by, forum.subject, forum.body, forum.post_date, forum.is_followup_to, forum.thread_id, forum.has_followups, forum.most_recent_date, users.user_name, users.realname FROM forum, users WHERE (forum.posted_by = users.user_id);
2729 CREATE VIEW forum_pending_user_vw AS
2730 SELECT forum_pending_messages.msg_id, forum_pending_messages.group_forum_id, forum_pending_messages.posted_by, forum_pending_messages.subject, forum_pending_messages.body, forum_pending_messages.post_date, forum_pending_messages.is_followup_to, forum_pending_messages.thread_id, forum_pending_messages.has_followups, forum_pending_messages.most_recent_date, users.user_name, users.realname FROM forum_pending_messages, users WHERE (forum_pending_messages.posted_by = users.user_id);
2734 CREATE TABLE group_activity_monitor (
2735 group_id integer NOT NULL,
2736 user_id integer NOT NULL,
2741 CREATE TABLE project_tags
2743 group_id integer NOT NULL,
2748 CREATE VIEW activity_vw AS
2749 (((SELECT agl.group_id, 'trackeropen'::text AS section, agl.group_artifact_id AS ref_id, a.artifact_id AS subref_id, a.summary AS description, a.open_date AS activity_date, u.user_id, u.user_name, u.realname FROM (artifact_group_list agl JOIN artifact a USING (group_artifact_id)), users u WHERE (u.user_id = a.submitted_by) UNION SELECT agl.group_id, 'trackerclose'::text AS section, agl.group_artifact_id AS ref_id, a.artifact_id AS subref_id, a.summary AS description, a.close_date AS activity_date, u.user_id, u.user_name, u.realname FROM (artifact_group_list agl JOIN artifact a USING (group_artifact_id)), users u WHERE ((u.user_id = a.assigned_to) AND (a.close_date > 0))) UNION SELECT agl.group_id, 'commit'::text AS section, agl.group_artifact_id AS ref_id, a.artifact_id AS subref_id, pcdm.log_text AS description, pcdm.cvs_date AS activity_date, u.user_id, u.user_name, u.realname FROM (artifact_group_list agl JOIN artifact a USING (group_artifact_id)), plugin_cvstracker_data_master pcdm, plugin_cvstracker_data_artifact pcda, users u WHERE (((pcdm.holder_id = pcda.id) AND (pcda.group_artifact_id = a.artifact_id)) AND (u.user_name = pcdm.author))) UNION SELECT frsp.group_id, 'frsrelease'::text AS section, frsp.package_id AS ref_id, frsr.release_id AS subref_id, frsr.name AS description, frsr.release_date AS activity_date, u.user_id, u.user_name, u.realname FROM (frs_package frsp JOIN frs_release frsr USING (package_id)), users u WHERE (u.user_id = frsr.released_by)) UNION SELECT fgl.group_id, 'forumpost'::text AS section, fgl.group_forum_id AS ref_id, forum.msg_id AS subref_id, forum.subject AS description, forum.post_date AS activity_date, u.user_id, u.user_name, u.realname FROM (forum_group_list fgl JOIN forum USING (group_forum_id)), users u WHERE (u.user_id = forum.posted_by);
2753 COPY canned_responses (response_id, response_title, response_text) FROM stdin;
2758 COPY db_images (id, group_id, description, bin_data, filename, filesize, filetype, width, height, upload_date, "version") FROM stdin;
2763 COPY doc_data (docid, stateid, title, data, updatedate, createdate, created_by, doc_group, description, language_id, filename, filetype, group_id, filesize) FROM stdin;
2768 COPY doc_groups (doc_group, groupname, group_id, parent_doc_group) FROM stdin;
2773 COPY doc_states (stateid, name) FROM stdin;
2783 COPY filemodule_monitor (id, filemodule_id, user_id) FROM stdin;
2788 COPY forum (msg_id, group_forum_id, posted_by, subject, body, post_date, is_followup_to, thread_id, has_followups, most_recent_date) FROM stdin;
2793 COPY forum_agg_msg_count (group_forum_id, count) FROM stdin;
2798 COPY forum_group_list (group_forum_id, group_id, forum_name, is_public, description, allow_anonymous, send_all_posts_to, moderation_level) FROM stdin;
2803 COPY forum_monitored_forums (monitor_id, forum_id, user_id) FROM stdin;
2808 COPY forum_saved_place (saved_place_id, user_id, forum_id, save_date) FROM stdin;
2813 COPY frs_file (file_id, filename, release_id, type_id, processor_id, release_time, file_size, post_date) FROM stdin;
2818 COPY frs_filetype (type_id, name) FROM stdin;
2828 5900 Other Source File
2838 COPY frs_package (package_id, group_id, name, status_id, is_public) FROM stdin;
2843 COPY frs_processor (processor_id, name) FROM stdin;
2857 COPY frs_release (release_id, package_id, name, notes, changes, status_id, preformatted, release_date, released_by) FROM stdin;
2862 COPY frs_status (status_id, name) FROM stdin;
2869 COPY group_history (group_history_id, group_id, field_name, old_value, mod_by, adddate) FROM stdin;
2874 COPY groups (group_id, group_name, homepage, is_public, status, unix_group_name, unix_box, http_domain, short_description, register_purpose, license_other, register_time, rand_hash, use_mail, use_survey, use_forum, use_pm, use_scm, use_news, type_id, use_docman, new_doc_address, send_all_docs, use_pm_depend_box, use_ftp, use_tracker, use_frs, use_stats, enable_pserver, enable_anonscm, license, scm_box) FROM stdin;
2875 2 Stats Group \N 0 A stats shell1 \N \N \N \N 0 \N 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 100 cvs1
2876 3 News Group \N 0 A newsadmin shell1 \N \N \N \N 0 \N 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 100 cvs1
2877 4 Peer Ratings Group \N 0 A peerrating shell1 \N \N \N \N 0 \N 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 100 cvs1
2878 1 Master Group \N 0 A siteadmin shell1 \N \N \N \N 0 \N 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 100 cvs1
2879 5 Template Project \N 1 P template shell1 \N Project to house templates used to build other projects \N \N 1120266772 \N 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 100 \N
2884 COPY mail_group_list (group_list_id, group_id, list_name, is_public, "password", list_admin, status, description) FROM stdin;
2889 COPY news_bytes (id, group_id, submitted_by, is_approved, post_date, forum_id, summary, details) FROM stdin;
2894 COPY people_job (job_id, group_id, created_by, title, description, post_date, status_id, category_id) FROM stdin;
2899 COPY people_job_category (category_id, name, private_flag) FROM stdin;
2906 7 Graphic/Other Designer 0
2911 COPY people_job_inventory (job_inventory_id, job_id, skill_id, skill_level_id, skill_year_id) FROM stdin;
2916 COPY people_job_status (status_id, name) FROM stdin;
2924 COPY people_skill (skill_id, name) FROM stdin;
2929 COPY people_skill_inventory (skill_inventory_id, user_id, skill_id, skill_level_id, skill_year_id) FROM stdin;
2934 COPY people_skill_level (skill_level_id, name) FROM stdin;
2944 COPY people_skill_year (skill_year_id, name) FROM stdin;
2954 COPY project_assigned_to (project_assigned_id, project_task_id, assigned_to_id) FROM stdin;
2959 COPY project_dependencies (project_depend_id, project_task_id, is_dependent_on_task_id, link_type) FROM stdin;
2964 COPY project_group_list (group_project_id, group_id, project_name, is_public, description, send_all_posts_to) FROM stdin;
2965 1 1 Default 0 Default Project - Don't Change \N
2970 COPY project_history (project_history_id, project_task_id, field_name, old_value, mod_by, mod_date) FROM stdin;
2975 COPY project_metric (ranking, percentile, group_id) FROM stdin;
2980 COPY project_metric_tmp1 (ranking, group_id, value) FROM stdin;
2985 COPY project_status (status_id, status_name) FROM stdin;
2992 COPY project_task (project_task_id, group_project_id, summary, details, percent_complete, priority, hours, start_date, end_date, created_by, status_id, category_id, duration, parent_id, last_modified_date) FROM stdin;
2993 1 1 0 0 0 0 0 100 1 100 0 0 1108701981
2998 COPY project_weekly_metric (ranking, percentile, group_id) FROM stdin;
3003 COPY user_session (user_id, session_hash, ip_addr, "time") FROM stdin;
3004 100 867b0c76e3a110d924f98029a28baa95 1096480068
3009 COPY snippet (snippet_id, created_by, name, description, "type", "language", license, category) FROM stdin;
3014 COPY snippet_package (snippet_package_id, created_by, name, description, category, "language") FROM stdin;
3019 COPY snippet_package_item (snippet_package_item_id, snippet_package_version_id, snippet_version_id) FROM stdin;
3024 COPY snippet_package_version (snippet_package_version_id, snippet_package_id, changes, "version", submitted_by, post_date) FROM stdin;
3029 COPY snippet_version (snippet_version_id, snippet_id, changes, "version", submitted_by, post_date, code) FROM stdin;
3034 COPY stats_agg_logo_by_day ("day", count) FROM stdin;
3039 COPY stats_agg_pages_by_day ("day", count) FROM stdin;
3044 COPY survey_question_types (id, "type") FROM stdin;
3047 3 Radio Buttons Yes/No
3055 COPY survey_questions (question_id, group_id, question, question_type) FROM stdin;
3060 COPY survey_rating_aggregate ("type", id, response, count) FROM stdin;
3065 COPY survey_rating_response (user_id, "type", id, response, post_date) FROM stdin;
3070 COPY survey_responses (user_id, group_id, survey_id, question_id, response, post_date) FROM stdin;
3075 COPY surveys (survey_id, group_id, survey_title, survey_questions, is_active) FROM stdin;
3080 COPY trove_cat (trove_cat_id, "version", parent, root_parent, shortname, fullname, description, count_subcat, count_subproj, fullpath, fullpath_ids) FROM stdin;
3081 1 2000031601 0 0 audience Intended Audience The main class of people likely to be interested in this resource. 0 0 Intended Audience 1
3082 2 2000032401 1 1 endusers End Users/Desktop Programs and resources for software end users. Software for the desktop. 0 0 Intended Audience :: End Users/Desktop 1 :: 2
3083 3 2000041101 1 1 developers Developers Programs and resources for software developers, to include libraries. 0 0 Intended Audience :: Developers 1 :: 3
3084 4 2000031601 1 1 sysadmins System Administrators Programs and resources for people who administer computers and networks. 0 0 Intended Audience :: System Administrators 1 :: 4
3085 5 2000040701 1 1 other Other Audience Programs and resources for an unlisted audience. 0 0 Intended Audience :: Other Audience 1 :: 5
3086 6 2000031601 0 0 developmentstatus Development Status An indication of the development status of the software or resource. 0 0 Development Status 6
3087 7 2000040701 6 6 planning 1 - Planning This resource is in the planning stages only. There is no code. 0 0 Development Status :: 1 - Planning 6 :: 7
3088 8 2000040701 6 6 prealpha 2 - Pre-Alpha There is code for this project, but it is not usable except for further development. 0 0 Development Status :: 2 - Pre-Alpha 6 :: 8
3089 9 2000041101 6 6 alpha 3 - Alpha Resource is in early development, and probably incomplete and/or extremely buggy. 0 0 Development Status :: 3 - Alpha 6 :: 9
3090 10 2000040701 6 6 beta 4 - Beta Resource is in late phases of development. Deliverables are essentially complete, but may still have significant bugs. 0 0 Development Status :: 4 - Beta 6 :: 10
3091 11 2000040701 6 6 production 5 - Production/Stable Deliverables are complete and usable by the intended audience. 0 0 Development Status :: 5 - Production/Stable 6 :: 11
3092 12 2000040701 6 6 mature 6 - Mature This resource has an extensive history of successful use and has probably undergone several stable revisions. 0 0 Development Status :: 6 - Mature 6 :: 12
3093 13 2000031601 0 0 license License License terms under which the resource is distributed. 0 0 License 13
3094 197 2000032001 13 13 publicdomain Public Domain Public Domain. No author-retained rights. 0 0 License :: Public Domain 13 :: 197
3095 196 2000040701 13 13 other Other/Proprietary License Non OSI-Approved/Proprietary license. 0 0 License :: Other/Proprietary License 13 :: 196
3096 14 2000032401 13 13 osi OSI Approved Licenses that have been approved by OSI as approved 0 0 License :: OSI Approved 13 :: 14
3097 303 2001041701 14 13 nethack Nethack General Public License Nethack General Public License 0 0 License :: OSI Approved :: Nethack General Public License 13 :: 14 :: 303
3098 141 2000032001 136 18 clustering Clustering/Distributed Networks Tools for automatically distributing computation across a network. 0 0 Topic :: System :: Clustering/Distributed Networks 18 :: 136 :: 141
3099 139 2000032001 136 18 boot Boot Programs for bootstrapping your OS. 0 0 Topic :: System :: Boot 18 :: 136 :: 139
3100 140 2000032001 139 18 init Init Init-time programs to start system services after boot. 0 0 Topic :: System :: Boot :: Init 18 :: 136 :: 139 :: 140
3101 138 2000032001 136 18 benchmark Benchmark Programs for benchmarking system performance. 0 0 Topic :: System :: Benchmark 18 :: 136 :: 138
3102 74 2000042701 136 18 emulators Emulators Emulations of foreign operating systme and machines. 0 0 Topic :: System :: Emulators 18 :: 136 :: 74
3103 19 2000032001 136 18 archiving Archiving Tools for maintaining and searching software or document archives. 0 0 Topic :: System :: Archiving 18 :: 136 :: 19
3104 137 2000032001 19 18 backup Backup Programs to manage and sequence system backup. 0 0 Topic :: System :: Archiving :: Backup 18 :: 136 :: 19 :: 137
3105 42 2000031601 19 18 compression Compression Tools and libraries for data compression. 0 0 Topic :: System :: Archiving :: Compression 18 :: 136 :: 19 :: 42
3106 41 2000031601 19 18 packaging Packaging Tools for packing and unpacking multi-file formats. Includes data-only formats and software package systems. 0 0 Topic :: System :: Archiving :: Packaging 18 :: 136 :: 19 :: 41
3107 132 2000032001 18 18 religion Religion Programs relating to religion and sacred texts. 0 0 Topic :: Religion 18 :: 132
3108 129 2000031701 18 18 office Office/Business Software for assisting and organizing work at your desk. 0 0 Topic :: Office/Business 18 :: 129
3109 131 2000032001 129 18 suites Office Suites Integrated office suites (word processing, presentation, spreadsheet, database, etc). 0 0 Topic :: Office/Business :: Office Suites 18 :: 129 :: 131
3110 130 2000031701 129 18 scheduling Scheduling Projects for scheduling time, to include project management. 0 0 Topic :: Office/Business :: Scheduling 18 :: 129 :: 130
3111 75 2000031701 129 18 financial Financial Programs related to finance. 0 0 Topic :: Office/Business :: Financial 18 :: 129 :: 75
3112 79 2000031601 75 18 pointofsale Point-Of-Sale Point-Of-Sale applications. 0 0 Topic :: Office/Business :: Financial :: Point-Of-Sale 18 :: 129 :: 75 :: 79
3113 78 2000031601 75 18 spreadsheet Spreadsheet Spreadsheet applications. 0 0 Topic :: Office/Business :: Financial :: Spreadsheet 18 :: 129 :: 75 :: 78
3114 77 2000031601 75 18 investment Investment Programs for assisting in financial investment. 0 0 Topic :: Office/Business :: Financial :: Investment 18 :: 129 :: 75 :: 77
3115 76 2000031601 75 18 accounting Accounting Checkbook balancers and accounting programs. 0 0 Topic :: Office/Business :: Financial :: Accounting 18 :: 129 :: 75 :: 76
3116 234 2000040701 18 18 other Other/Nonlisted Topic Topic does not fit into any listed category. 0 0 Topic :: Other/Nonlisted Topic 18 :: 234
3117 156 2000032001 18 18 terminals Terminals Terminal emulators, terminal programs, and terminal session utilities. 0 0 Topic :: Terminals 18 :: 156
3118 159 2000032001 156 18 telnet Telnet Support for telnet; terminal sessions across Internet links. 0 0 Topic :: Terminals :: Telnet 18 :: 156 :: 159
3119 158 2000032001 156 18 virtual Terminal Emulators/X Terminals Programs to handle multiple terminal sessions. Includes terminal emulations for X and other window systems. 0 0 Topic :: Terminals :: Terminal Emulators/X Terminals 18 :: 156 :: 158
3120 157 2000032001 156 18 serial Serial Dialup, terminal emulation, and file transfer over serial lines. 0 0 Topic :: Terminals :: Serial 18 :: 156 :: 157
3121 115 2000031701 113 18 capture Capture/Recording Sound capture and recording. 0 0 Topic :: Multimedia :: Sound/Audio :: Capture/Recording 18 :: 99 :: 113 :: 115
3122 114 2000031701 113 18 analysis Analysis Sound analysis tools, to include frequency analysis. 0 0 Topic :: Multimedia :: Sound/Audio :: Analysis 18 :: 99 :: 113 :: 114
3123 100 2000031601 99 18 graphics Graphics Tools and resources for computer graphics. 0 0 Topic :: Multimedia :: Graphics 18 :: 99 :: 100
3124 112 2000031701 100 18 viewers Viewers Programs that can display various graphics formats. 0 0 Topic :: Multimedia :: Graphics :: Viewers 18 :: 99 :: 100 :: 112
3125 111 2000031701 100 18 presentation Presentation Tools for generating presentation graphics and slides. 0 0 Topic :: Multimedia :: Graphics :: Presentation 18 :: 99 :: 100 :: 111
3126 110 2000031701 100 18 3drendering 3D Rendering Programs which render 3D models. 0 0 Topic :: Multimedia :: Graphics :: 3D Rendering 18 :: 99 :: 100 :: 110
3127 109 2000031701 100 18 3dmodeling 3D Modeling Programs for working with 3D Models. 0 0 Topic :: Multimedia :: Graphics :: 3D Modeling 18 :: 99 :: 100 :: 109
3128 106 2000031701 100 18 editors Editors Drawing, painting, and structured editing programs. 0 0 Topic :: Multimedia :: Graphics :: Editors 18 :: 99 :: 100 :: 106
3129 108 2000031701 106 18 raster Raster-Based Raster/Bitmap based drawing programs. 0 0 Topic :: Multimedia :: Graphics :: Editors :: Raster-Based 18 :: 99 :: 100 :: 106 :: 108
3130 107 2000031701 106 18 vector Vector-Based Vector-Based drawing programs. 0 0 Topic :: Multimedia :: Graphics :: Editors :: Vector-Based 18 :: 99 :: 100 :: 106 :: 107
3131 105 2000031701 100 18 conversion Graphics Conversion Programs which convert between graphics formats. 0 0 Topic :: Multimedia :: Graphics :: Graphics Conversion 18 :: 99 :: 100 :: 105
3132 101 2000031601 100 18 capture Capture Support for scanners, cameras, and screen capture. 0 0 Topic :: Multimedia :: Graphics :: Capture 18 :: 99 :: 100 :: 101
3133 104 2000031601 101 18 screencapture Screen Capture Screen capture tools and processors. 0 0 Topic :: Multimedia :: Graphics :: Capture :: Screen Capture 18 :: 99 :: 100 :: 101 :: 104
3134 103 2000031601 101 18 cameras Digital Camera Digital Camera 0 0 Topic :: Multimedia :: Graphics :: Capture :: Digital Camera 18 :: 99 :: 100 :: 101 :: 103
3135 102 2000031601 101 18 scanners Scanners Support for graphic scanners. 0 0 Topic :: Multimedia :: Graphics :: Capture :: Scanners 18 :: 99 :: 100 :: 101 :: 102
3136 154 2000032001 18 18 printing Printing Tools, daemons, and utilities for printer control. 0 0 Topic :: Printing 18 :: 154
3137 136 2000032001 18 18 system System Operating system core and administration utilities. 0 0 Topic :: System 18 :: 136
3138 294 2001032001 136 18 shells System Shells System Shells 0 0 Topic :: System :: System Shells 18 :: 136 :: 294
3139 257 2000071101 136 18 softwaredist Software Distribution Systems software for distributing other software. 0 0 Topic :: System :: Software Distribution 18 :: 136 :: 257
3140 253 2000071101 136 18 sysadministration Systems Administration Systems Administration Software (e.g. configuration apps.) 0 0 Topic :: System :: Systems Administration 18 :: 136 :: 253
3141 289 2001032001 253 18 authentication Authentication/Directory Authentication and directory services 0 0 Topic :: System :: Systems Administration :: Authentication/Directory 18 :: 136 :: 253 :: 289
3142 291 2001032001 289 18 ldap LDAP Leightweight directory access protocol 0 0 Topic :: System :: Systems Administration :: Authentication/Directory :: LDAP 18 :: 136 :: 253 :: 289 :: 291
3143 290 2001032001 289 18 nis NIS NIS services 0 0 Topic :: System :: Systems Administration :: Authentication/Directory :: NIS 18 :: 136 :: 253 :: 289 :: 290
3144 153 2000032001 136 18 power Power (UPS) Code for communication with uninterruptible power supplies. 0 0 Topic :: System :: Power (UPS) 18 :: 136 :: 153
3145 150 2000032001 136 18 networking Networking Network configuration and administration. 0 0 Topic :: System :: Networking 18 :: 136 :: 150
3146 152 2000032001 150 18 monitoring Monitoring System monitoring, traffic analysis, and sniffers. 0 0 Topic :: System :: Networking :: Monitoring 18 :: 136 :: 150 :: 152
3147 155 2000032001 152 18 watchdog Hardware Watchdog Software to monitor and perform actions or shutdown on hardware trouble detection. 0 0 Topic :: System :: Networking :: Monitoring :: Hardware Watchdog 18 :: 136 :: 150 :: 152 :: 155
3148 151 2000032001 150 18 firewalls Firewalls Firewalls and filtering systems. 0 0 Topic :: System :: Networking :: Firewalls 18 :: 136 :: 150 :: 151
3149 148 2000032001 136 18 logging Logging Utilities for clearing, rotating, and digesting system logs. 0 0 Topic :: System :: Logging 18 :: 136 :: 148
3150 147 2000032001 136 18 setup Installation/Setup Tools for installation and setup of the operating system and other programs. 0 0 Topic :: System :: Installation/Setup 18 :: 136 :: 147
3151 146 2000032001 136 18 hardware Hardware Tools for direct, non-kernel control and configuration of hardware. 0 0 Topic :: System :: Hardware 18 :: 136 :: 146
3152 292 2001032001 146 18 drivers Hardware Drivers Hardware Drivers 0 0 Topic :: System :: Hardware :: Hardware Drivers 18 :: 136 :: 146 :: 292
3153 144 2000032001 136 18 kernels Operating System Kernels OS Kernels, patches, modules, and tools. 0 0 Topic :: System :: Operating System Kernels 18 :: 136 :: 144
3154 239 2000041301 144 18 gnuhurd GNU Hurd Kernel code and modules for GNU Hurd. 0 0 Topic :: System :: Operating System Kernels :: GNU Hurd 18 :: 136 :: 144 :: 239
3155 145 2000032001 144 18 bsd BSD Code relating to any of the BSD kernels. 0 0 Topic :: System :: Operating System Kernels :: BSD 18 :: 136 :: 144 :: 145
3156 143 2000032001 144 18 linux Linux The Linux kernel, patches, and modules. 0 0 Topic :: System :: Operating System Kernels :: Linux 18 :: 136 :: 144 :: 143
3157 142 2000032001 136 18 filesystems Filesystems Support for creating, editing, reading, and writing file systems. 0 0 Topic :: System :: Filesystems 18 :: 136 :: 142
3158 287 2001032001 80 18 boardgames Board Games Board Games 0 0 Topic :: Games/Entertainment :: Board Games 18 :: 80 :: 287
3159 268 2000082101 80 18 Puzzles Puzzle Games Puzzle Games 0 0 Topic :: Games/Entertainment :: Puzzle Games 18 :: 80 :: 268
3160 86 2000031601 80 18 mud Multi-User Dungeons (MUD) Massively-multiplayer text based games. 0 0 Topic :: Games/Entertainment :: Multi-User Dungeons (MUD) 18 :: 80 :: 86
3161 85 2000031601 80 18 simulation Simulation Simulation games 0 0 Topic :: Games/Entertainment :: Simulation 18 :: 80 :: 85
3162 84 2000031601 80 18 rpg Role-Playing Role-Playing games 0 0 Topic :: Games/Entertainment :: Role-Playing 18 :: 80 :: 84
3163 83 2000032401 80 18 turnbasedstrategy Turn Based Strategy Turn Based Strategy 0 0 Topic :: Games/Entertainment :: Turn Based Strategy 18 :: 80 :: 83
3164 82 2000031601 80 18 firstpersonshooters First Person Shooters First Person Shooters. 0 0 Topic :: Games/Entertainment :: First Person Shooters 18 :: 80 :: 82
3165 81 2000031601 80 18 realtimestrategy Real Time Strategy Real Time strategy games 0 0 Topic :: Games/Entertainment :: Real Time Strategy 18 :: 80 :: 81
3166 288 2001032001 80 18 sidescrolling Side-Scrolling/Arcade Games Arcade-style side-scrolling games 0 0 Topic :: Games/Entertainment :: Side-Scrolling/Arcade Games 18 :: 80 :: 288
3167 71 2000031601 18 18 education Education Programs and tools for educating yourself or others. 0 0 Topic :: Education 18 :: 71
3168 73 2000031601 71 18 testing Testing Tools for testing someone's knowledge on a subject. 0 0 Topic :: Education :: Testing 18 :: 71 :: 73
3169 72 2000031601 71 18 cai Computer Aided Instruction (CAI) Programs for authoring or using Computer Aided Instrution courses. 0 0 Topic :: Education :: Computer Aided Instruction (CAI) 18 :: 71 :: 72
3170 66 2000031601 18 18 database Database Front ends, engines, and tools for database work. 0 0 Topic :: Database 18 :: 66
3171 68 2000031601 66 18 frontends Front-Ends Clients and front-ends for generating queries to database engines. 0 0 Topic :: Database :: Front-Ends 18 :: 66 :: 68
3172 67 2000031601 66 18 engines Database Engines/Servers Programs that manage data and provide control via some query language. 0 0 Topic :: Database :: Database Engines/Servers 18 :: 66 :: 67
3173 63 2000032001 18 18 editors Text Editors Programs for editing code and documents. 0 0 Topic :: Text Editors 18 :: 63
3174 285 2001032001 63 18 textprocessing Text Processing Programs or libraries that are designed to batch process text documents 0 0 Topic :: Text Editors :: Text Processing 18 :: 63 :: 285
3175 70 2000031601 63 18 wordprocessors Word Processors WYSIWYG word processors. 0 0 Topic :: Text Editors :: Word Processors 18 :: 63 :: 70
3176 69 2000031601 63 18 documentation Documentation Tools for the creation and use of documentation. 0 0 Topic :: Text Editors :: Documentation 18 :: 63 :: 69
3177 65 2000031601 63 18 ide Integrated Development Environments (IDE) Complete editing environments for code, including cababilities such as compilation and code building assistance. 0 0 Topic :: Text Editors :: Integrated Development Environments (IDE) 18 :: 63 :: 65
3178 64 2000031601 63 18 emacs Emacs GNU Emacs and its imitators and tools. 0 0 Topic :: Text Editors :: Emacs 18 :: 63 :: 64
3179 125 2000031701 99 18 video Video Video capture, editing, and playback. 0 0 Topic :: Multimedia :: Video 18 :: 99 :: 125
3180 126 2000031701 125 18 capture Capture Video capture tools. 0 0 Topic :: Multimedia :: Video :: Capture 18 :: 99 :: 125 :: 126
3181 256 2000071101 125 18 nonlineareditor Non-Linear Editor Video Non-Linear Editors 0 0 Topic :: Multimedia :: Video :: Non-Linear Editor 18 :: 99 :: 125 :: 256
3182 128 2000031701 125 18 display Display Programs which display various video formats. 0 0 Topic :: Multimedia :: Video :: Display 18 :: 99 :: 125 :: 128
3183 127 2000031701 125 18 conversion Conversion Programs which convert between video formats. 0 0 Topic :: Multimedia :: Video :: Conversion 18 :: 99 :: 125 :: 127
3184 113 2000031701 99 18 sound Sound/Audio Tools for generating, editing, analyzing, and playing sound. 0 0 Topic :: Multimedia :: Sound/Audio 18 :: 99 :: 113
3185 249 2000042801 113 18 synthesis Sound Synthesis Software for creation and synthesis of sound. 0 0 Topic :: Multimedia :: Sound/Audio :: Sound Synthesis 18 :: 99 :: 113 :: 249
3186 248 2000042801 113 18 midi MIDI Software related to MIDI synthesis and playback. 0 0 Topic :: Multimedia :: Sound/Audio :: MIDI 18 :: 99 :: 113 :: 248
3187 124 2000031701 113 18 speech Speech Speech manipulation and intepretation tools. 0 0 Topic :: Multimedia :: Sound/Audio :: Speech 18 :: 99 :: 113 :: 124
3188 122 2000031701 113 18 players Players Programs to play audio files to a sound device. 0 0 Topic :: Multimedia :: Sound/Audio :: Players 18 :: 99 :: 113 :: 122
3189 123 2000031701 122 18 mp3 MP3 Programs to play MP3 audio files. 0 0 Topic :: Multimedia :: Sound/Audio :: Players :: MP3 18 :: 99 :: 113 :: 122 :: 123
3190 121 2000031701 113 18 mixers Mixers Programs to mix audio. 0 0 Topic :: Multimedia :: Sound/Audio :: Mixers 18 :: 99 :: 113 :: 121
3191 120 2000031701 113 18 editors Editors Programs to edit/manipulate sound data. 0 0 Topic :: Multimedia :: Sound/Audio :: Editors 18 :: 99 :: 113 :: 120
3192 119 2000031701 113 18 conversion Conversion Programs to convert between audio formats. 0 0 Topic :: Multimedia :: Sound/Audio :: Conversion 18 :: 99 :: 113 :: 119
3193 116 2000031701 113 18 cdaudio CD Audio Programs to play and manipulate audio CDs. 0 0 Topic :: Multimedia :: Sound/Audio :: CD Audio 18 :: 99 :: 113 :: 116
3194 88 2000031601 87 18 finger Finger The Finger protocol for getting information about users. 0 0 Topic :: Internet :: Finger 18 :: 87 :: 88
3195 118 2000031701 116 18 cdripping CD Ripping Software to convert CD Audio to other digital formats. 0 0 Topic :: Multimedia :: Sound/Audio :: CD Audio :: CD Ripping 18 :: 99 :: 113 :: 116 :: 118
3196 117 2000031701 116 18 cdplay CD Playing CD Playing software, to include jukebox software. 0 0 Topic :: Multimedia :: Sound/Audio :: CD Audio :: CD Playing 18 :: 99 :: 113 :: 116 :: 117
3197 260 2000071401 52 18 SCCS SCCS SCCS 0 0 Topic :: Software Development :: Version Control :: SCCS 18 :: 45 :: 52 :: 260
3198 54 2000031601 52 18 rcs RCS Tools for RCS (Revision Control System). 0 0 Topic :: Software Development :: Version Control :: RCS 18 :: 45 :: 52 :: 54
3199 53 2000031601 52 18 cvs CVS Tools for CVS (Concurrent Versioning System). 0 0 Topic :: Software Development :: Version Control :: CVS 18 :: 45 :: 52 :: 53
3200 50 2000031601 45 18 objectbrokering Object Brokering Object brokering libraries and tools. 0 0 Topic :: Software Development :: Object Brokering 18 :: 45 :: 50
3201 51 2000031601 50 18 corba CORBA Tools for implementation and use of CORBA. 0 0 Topic :: Software Development :: Object Brokering :: CORBA 18 :: 45 :: 50 :: 51
3202 49 2000031601 45 18 interpreters Interpreters Programs for interpreting and executing high-level languages directly. 0 0 Topic :: Software Development :: Interpreters 18 :: 45 :: 49
3203 48 2000031601 45 18 compilers Compilers Programs for compiling high-level languges into machine code. 0 0 Topic :: Software Development :: Compilers 18 :: 45 :: 48
3204 47 2000031601 45 18 debuggers Debuggers Programs for controlling and monitoring the execution of compiled binaries. 0 0 Topic :: Software Development :: Debuggers 18 :: 45 :: 47
3205 46 2000031601 45 18 build Build Tools Software for the build process. 0 0 Topic :: Software Development :: Build Tools 18 :: 45 :: 46
3206 43 2000031601 18 18 security Security Security-related software, to include system administration and cryptography. 0 0 Topic :: Security 18 :: 43
3207 44 2000031601 43 18 cryptography Cryptography Cryptography programs, algorithms, and libraries. 0 0 Topic :: Security :: Cryptography 18 :: 43 :: 44
3208 97 2000042701 18 18 scientific Scientific/Engineering Scientific applications, to include research, applied and pure mathematics and sciences. 0 0 Topic :: Scientific/Engineering 18 :: 97
3209 98 2000031601 97 18 mathematics Mathematics Software to support pure and applied mathematics. 0 0 Topic :: Scientific/Engineering :: Mathematics 18 :: 97 :: 98
3210 272 2000100501 97 18 HMI Human Machine Interfaces This applies to the Factory/Machine control/Automation fields where there are already thousands of applications and millions of installations. 0 0 Topic :: Scientific/Engineering :: Human Machine Interfaces 18 :: 97 :: 272
3211 266 2000081601 97 18 medical Medical Science Apps. Medical / BioMedical Science Apps. 0 0 Topic :: Scientific/Engineering :: Medical Science Apps. 18 :: 97 :: 266
3212 252 2000071101 97 18 bioinformatics Bio-Informatics Category for gene software (e.g. Gene Ontology) 0 0 Topic :: Scientific/Engineering :: Bio-Informatics 18 :: 97 :: 252
3213 246 2000042701 97 18 eda Electronic Design Automation (EDA) Tools for circuit design, schematics, board layout, and more. 0 0 Topic :: Scientific/Engineering :: Electronic Design Automation (EDA) 18 :: 97 :: 246
3214 135 2000032001 97 18 visualization Visualization Software for scientific visualization. 0 0 Topic :: Scientific/Engineering :: Visualization 18 :: 97 :: 135
3215 134 2000032001 97 18 astronomy Astronomy Software and tools related to astronomy. 0 0 Topic :: Scientific/Engineering :: Astronomy 18 :: 97 :: 134
3216 133 2000032001 97 18 ai Artificial Intelligence Artificial Intelligence. 0 0 Topic :: Scientific/Engineering :: Artificial Intelligence 18 :: 97 :: 133
3217 87 2000031601 18 18 internet Internet Tools to assist human access to the Internet. 0 0 Topic :: Internet 18 :: 87
3218 270 2000083101 87 18 WAP WAP Wireless Access Protocol 0 0 Topic :: Internet :: WAP 18 :: 87 :: 270
3219 245 2000042701 87 18 loganalysis Log Analysis Software to help analyze various log files. 0 0 Topic :: Internet :: Log Analysis 18 :: 87 :: 245
3220 149 2000032001 87 18 dns Name Service (DNS) Domain name system servers and utilities. 0 0 Topic :: Internet :: Name Service (DNS) 18 :: 87 :: 149
3221 90 2000031601 87 18 www WWW/HTTP Programs and tools for the World Wide Web. 0 0 Topic :: Internet :: WWW/HTTP 18 :: 87 :: 90
3222 250 2000042801 90 18 httpservers HTTP Servers Software designed to serve content via the HTTP protocol. 0 0 Topic :: Internet :: WWW/HTTP :: HTTP Servers 18 :: 87 :: 90 :: 250
3223 243 2000042701 90 18 sitemanagement Site Management Tools for maintanance and management of web sites. 0 0 Topic :: Internet :: WWW/HTTP :: Site Management 18 :: 87 :: 90 :: 243
3224 244 2000042701 243 18 linkchecking Link Checking Tools to assist in checking for broken links. 0 0 Topic :: Internet :: WWW/HTTP :: Site Management :: Link Checking 18 :: 87 :: 90 :: 243 :: 244
3225 93 2000031601 90 18 indexing Indexing/Search Indexing and search tools for the Web. 0 0 Topic :: Internet :: WWW/HTTP :: Indexing/Search 18 :: 87 :: 90 :: 93
3226 92 2000031601 90 18 dynamic Dynamic Content Common Gateway Interface scripting and server-side parsing. 0 0 Topic :: Internet :: WWW/HTTP :: Dynamic Content 18 :: 87 :: 90 :: 92
3227 96 2000031601 92 18 cgi CGI Tools/Libraries Tools for the Common Gateway Interface 0 0 Topic :: Internet :: WWW/HTTP :: Dynamic Content :: CGI Tools/Libraries 18 :: 87 :: 90 :: 92 :: 96
3228 95 2000031601 92 18 messageboards Message Boards Online message boards 0 0 Topic :: Internet :: WWW/HTTP :: Dynamic Content :: Message Boards 18 :: 87 :: 90 :: 92 :: 95
3229 94 2000031601 92 18 counters Page Counters Scripts to count numbers of pageviews. 0 0 Topic :: Internet :: WWW/HTTP :: Dynamic Content :: Page Counters 18 :: 87 :: 90 :: 92 :: 94
3230 91 2000031601 90 18 browsers Browsers Web Browsers 0 0 Topic :: Internet :: WWW/HTTP :: Browsers 18 :: 87 :: 90 :: 91
3231 89 2000031601 87 18 ftp File Transfer Protocol (FTP) Programs and tools for file transfer via FTP. 0 0 Topic :: Internet :: File Transfer Protocol (FTP) 18 :: 87 :: 89
3232 80 2000031601 18 18 games Games/Entertainment Games and Entertainment software. 0 0 Topic :: Games/Entertainment 18 :: 80
3233 18 2000031601 0 0 topic Topic Topic categorization. 0 0 Topic 18
3234 20 2000032401 18 18 communications Communications Programs intended to facilitate communication between people. 0 0 Topic :: Communications 18 :: 20
3235 27 2000031601 20 18 conferencing Conferencing Software to support real-time conferencing over the Internet. 0 0 Topic :: Communications :: Conferencing 18 :: 20 :: 27
3236 22 2000031601 20 18 chat Chat Programs to support real-time communication over the Internet. 0 0 Topic :: Communications :: Chat 18 :: 20 :: 22
3237 26 2000031601 22 18 aim AOL Instant Messanger Programs to support AOL Instant Messanger. 0 0 Topic :: Communications :: Chat :: AOL Instant Messanger 18 :: 20 :: 22 :: 26
3238 25 2000031601 22 18 talk Unix Talk Programs to support Unix Talk protocol. 0 0 Topic :: Communications :: Chat :: Unix Talk 18 :: 20 :: 22 :: 25
3239 24 2000041101 22 18 irc Internet Relay Chat Programs to support Internet Relay Chat. 0 0 Topic :: Communications :: Chat :: Internet Relay Chat 18 :: 20 :: 22 :: 24
3240 23 2000031601 22 18 icq ICQ Programs to support ICQ. 0 0 Topic :: Communications :: Chat :: ICQ 18 :: 20 :: 22 :: 23
3241 21 2000031601 20 18 bbs BBS Bulletin Board systems. 0 0 Topic :: Communications :: BBS 18 :: 20 :: 21
3242 251 2000050101 20 18 filesharing File Sharing Software for person-to-person online file sharing. 0 0 Topic :: Communications :: File Sharing 18 :: 20 :: 251
3243 241 2000050101 251 18 napster Napster Clients and servers for the Napster file sharing protocol. 0 0 Topic :: Communications :: File Sharing :: Napster 18 :: 20 :: 251 :: 241
3244 286 2001032001 251 18 gnutella Gnutella Projects based around the gnutella protocol. 0 0 Topic :: Communications :: File Sharing :: Gnutella 18 :: 20 :: 251 :: 286
3245 247 2000042701 20 18 telephony Telephony Telephony related applications, to include automated voice response systems. 0 0 Topic :: Communications :: Telephony 18 :: 20 :: 247
3246 40 2000031601 20 18 internetphone Internet Phone Software to support real-time speech communication over the Internet. 0 0 Topic :: Communications :: Internet Phone 18 :: 20 :: 40
3247 39 2000031601 20 18 usenet Usenet News Software to support USENET news. 0 0 Topic :: Communications :: Usenet News 18 :: 20 :: 39
3248 38 2000031601 20 18 hamradio Ham Radio Tools and resources for amateur radio. 0 0 Topic :: Communications :: Ham Radio 18 :: 20 :: 38
3249 37 2000031601 20 18 fido FIDO Tools for FIDOnet mail and echoes. 0 0 Topic :: Communications :: FIDO 18 :: 20 :: 37
3250 36 2000031601 20 18 fax Fax Tools for sending and receiving facsimile messages. 0 0 Topic :: Communications :: Fax 18 :: 20 :: 36
3251 28 2000031601 20 18 email Email Programs for sending, processing, and handling electronic mail. 0 0 Topic :: Communications :: Email 18 :: 20 :: 28
3252 33 2000031601 28 18 postoffice Post-Office Programs to support post-office protocols, including POP and IMAP. 0 0 Topic :: Communications :: Email :: Post-Office 18 :: 20 :: 28 :: 33
3253 35 2000031601 33 18 imap IMAP Programs to support IMAP protocol (Internet Message Access Protocol). 0 0 Topic :: Communications :: Email :: Post-Office :: IMAP 18 :: 20 :: 28 :: 33 :: 35
3254 34 2000031601 33 18 pop3 POP3 Programs to support POP3 (Post-Office Protocol, version 3). 0 0 Topic :: Communications :: Email :: Post-Office :: POP3 18 :: 20 :: 28 :: 33 :: 34
3255 32 2000031601 28 18 mta Mail Transport Agents Email transport and gatewaying software. 0 0 Topic :: Communications :: Email :: Mail Transport Agents 18 :: 20 :: 28 :: 32
3256 31 2000031601 28 18 mua Email Clients (MUA) Programs for interactively reading and sending Email. 0 0 Topic :: Communications :: Email :: Email Clients (MUA) 18 :: 20 :: 28 :: 31
3257 30 2000031601 28 18 listservers Mailing List Servers Tools for managing electronic mailing lists. 0 0 Topic :: Communications :: Email :: Mailing List Servers 18 :: 20 :: 28 :: 30
3258 29 2000031601 28 18 filters Filters Content-driven filters and dispatchers for Email. 0 0 Topic :: Communications :: Email :: Filters 18 :: 20 :: 28 :: 29
3259 301 2001041701 14 13 nosl Nokia Open Source License Nokia Open Source License 0 0 License :: OSI Approved :: Nokia Open Source License 13 :: 14 :: 301
3260 299 2001041701 14 13 iosl Intel Open Source License Intel Open Source License 0 0 License :: OSI Approved :: Intel Open Source License 13 :: 14 :: 299
3261 297 2001041701 14 13 vsl Vovida Software License Vovida Software License 0 0 License :: OSI Approved :: Vovida Software License 13 :: 14 :: 297
3262 195 2000032001 14 13 zlib zlib/libpng License zlib/libpng License 0 0 License :: OSI Approved :: zlib/libpng License 13 :: 14 :: 195
3263 194 2000032001 14 13 python Python License Python License 0 0 License :: OSI Approved :: Python License 13 :: 14 :: 194
3264 193 2000032001 14 13 ricoh Ricoh Source Code Public License Ricoh Source Code Public License 0 0 License :: OSI Approved :: Ricoh Source Code Public License 13 :: 14 :: 193
3265 192 2000032001 14 13 cvw MITRE Collaborative Virtual Workspace License (CVW) MITRE Collaborative Virtual Workspace License (CVW) 0 0 License :: OSI Approved :: MITRE Collaborative Virtual Workspace License (CVW) 13 :: 14 :: 192
3266 191 2000032001 14 13 ibm IBM Public License IBM Public License 0 0 License :: OSI Approved :: IBM Public License 13 :: 14 :: 191
3267 190 2000032001 14 13 qpl QT Public License (QPL) QT Public License 0 0 License :: OSI Approved :: QT Public License (QPL) 13 :: 14 :: 190
3268 189 2000032001 14 13 mpl Mozilla Public License (MPL) Mozilla Public License (MPL) 0 0 License :: OSI Approved :: Mozilla Public License (MPL) 13 :: 14 :: 189
3269 305 2001041701 189 13 mpl11 Mozilla Public License 1.1 Mozilla Public License 1.1 0 0 License :: OSI Approved :: Mozilla Public License (MPL) :: Mozilla Public License 1.1 13 :: 14 :: 189 :: 305
3270 199 2000032101 0 0 os Operating System What operating system the program requires to run, if any. 0 0 Operating System 199
3271 200 2000032101 199 199 posix POSIX POSIX plus standard Berkeley socket facilities. Don't list a more specific OS unless your program requires it. 0 0 Operating System :: POSIX 199 :: 200
3272 201 2000032101 200 199 linux Linux Any version of Linux. Don't specify a subcategory unless the program requires a particular distribution. 0 0 Operating System :: POSIX :: Linux 199 :: 200 :: 201
3273 202 2000032101 200 199 bsd BSD Any variant of BSD. Don't specify a subcategory unless the program requires a particular BSD flavor. 0 0 Operating System :: POSIX :: BSD 199 :: 200 :: 202
3274 203 2000041101 202 199 freebsd FreeBSD FreeBSD 0 0 Operating System :: POSIX :: BSD :: FreeBSD 199 :: 200 :: 202 :: 203
3275 204 2000032101 202 199 netbsd NetBSD NetBSD 0 0 Operating System :: POSIX :: BSD :: NetBSD 199 :: 200 :: 202 :: 204
3276 205 2000032101 202 199 openbsd OpenBSD OpenBSD 0 0 Operating System :: POSIX :: BSD :: OpenBSD 199 :: 200 :: 202 :: 205
3277 206 2000032101 202 199 bsdos BSD/OS BSD/OS 0 0 Operating System :: POSIX :: BSD :: BSD/OS 199 :: 200 :: 202 :: 206
3278 207 2000032101 200 199 sun SunOS/Solaris Any Sun Microsystems OS. 0 0 Operating System :: POSIX :: SunOS/Solaris 199 :: 200 :: 207
3279 208 2000032101 200 199 sco SCO SCO 0 0 Operating System :: POSIX :: SCO 199 :: 200 :: 208
3280 209 2000032101 200 199 hpux HP-UX HP-UX 0 0 Operating System :: POSIX :: HP-UX 199 :: 200 :: 209
3281 210 2000032101 200 199 aix AIX AIX 0 0 Operating System :: POSIX :: AIX 199 :: 200 :: 210
3282 211 2000032101 200 199 irix IRIX IRIX 0 0 Operating System :: POSIX :: IRIX 199 :: 200 :: 211
3283 212 2000032101 200 199 other Other Other specific POSIX OS, specified in description. 0 0 Operating System :: POSIX :: Other 199 :: 200 :: 212
3284 282 2000121901 18 18 Sociology Sociology Social / Informational - Family / etc. 0 0 Topic :: Sociology 18 :: 282
3285 214 2000032101 199 199 microsoft Microsoft Microsoft operating systems. 0 0 Operating System :: Microsoft 199 :: 214
3286 215 2000032101 214 199 msdos MS-DOS Microsoft Disk Operating System (DOS) 0 0 Operating System :: Microsoft :: MS-DOS 199 :: 214 :: 215
3287 216 2000032101 214 199 windows Windows Windows software, not specific to any particular version of Windows. 0 0 Operating System :: Microsoft :: Windows 199 :: 214 :: 216
3288 217 2000032101 216 199 win31 Windows 3.1 or Earlier Windows 3.1 or Earlier 0 0 Operating System :: Microsoft :: Windows :: Windows 3.1 or Earlier 199 :: 214 :: 216 :: 217
3289 218 2000032101 216 199 win95 Windows 95/98/2000 Windows 95, Windows 98, and Windows 2000. 0 0 Operating System :: Microsoft :: Windows :: Windows 95/98/2000 199 :: 214 :: 216 :: 218
3290 219 2000041101 216 199 winnt Windows NT/2000 Windows NT and Windows 2000. 0 0 Operating System :: Microsoft :: Windows :: Windows NT/2000 199 :: 214 :: 216 :: 219
3291 220 2000032101 199 199 os2 OS/2 OS/2 0 0 Operating System :: OS/2 199 :: 220
3292 221 2000032101 199 199 macos MacOS MacOS 0 0 Operating System :: MacOS 199 :: 221
3293 222 2000032101 216 199 wince Windows CE Windows CE 0 0 Operating System :: Microsoft :: Windows :: Windows CE 199 :: 214 :: 216 :: 222
3294 223 2000032101 199 199 palmos PalmOS PalmOS (for Palm Pilot) 0 0 Operating System :: PalmOS 199 :: 223
3295 224 2000032101 199 199 beos BeOS BeOS 0 0 Operating System :: BeOS 199 :: 224
3296 225 2000032101 0 0 environment Environment Run-time environment required for this program. 0 0 Environment 225
3297 226 2000041101 225 225 console Console (Text Based) Console-based programs. 0 0 Environment :: Console (Text Based) 225 :: 226
3298 227 2000032401 226 225 curses Curses Curses-based software. 0 0 Environment :: Console (Text Based) :: Curses 225 :: 226 :: 227
3299 228 2000040701 226 225 newt Newt Newt 0 0 Environment :: Console (Text Based) :: Newt 225 :: 226 :: 228
3300 229 2000040701 225 225 x11 X11 Applications Programs that run in an X windowing environment. 0 0 Environment :: X11 Applications 225 :: 229
3301 230 2000040701 225 225 win32 Win32 (MS Windows) Programs designed to run in a graphical Microsoft Windows environment. 0 0 Environment :: Win32 (MS Windows) 225 :: 230
3302 231 2000040701 229 225 gnome Gnome Programs designed to run in a Gnome environment. 0 0 Environment :: X11 Applications :: Gnome 225 :: 229 :: 231
3303 232 2000040701 229 225 kde KDE Programs designed to run in a KDE environment. 0 0 Environment :: X11 Applications :: KDE 225 :: 229 :: 232
3304 233 2000040701 225 225 other Other Environment Programs designed to run in an environment other than one listed. 0 0 Environment :: Other Environment 225 :: 233
3305 283 2000121901 282 18 History History History / Informational 0 0 Topic :: Sociology :: History 18 :: 282 :: 283
3306 235 2000041001 199 199 independent OS Independent This software does not depend on any particular operating system. 0 0 Operating System :: OS Independent 199 :: 235
3307 236 2000040701 199 199 other Other OS Program is designe for a nonlisted operating system. 0 0 Operating System :: Other OS 199 :: 236
3308 237 2000041001 225 225 web Web Environment This software is designed for a web environment. 0 0 Environment :: Web Environment 225 :: 237
3309 238 2000041101 225 225 daemon No Input/Output (Daemon) This program has no input or output, but is intended to run in the background as a daemon. 0 0 Environment :: No Input/Output (Daemon) 225 :: 238
3310 284 2000121901 282 18 Genealogy Genealogy Family History / Genealogy 0 0 Topic :: Sociology :: Genealogy 18 :: 282 :: 284
3311 240 2000041301 200 199 gnuhurd GNU Hurd GNU Hurd 0 0 Operating System :: POSIX :: GNU Hurd 199 :: 200 :: 240
3312 55 2000031601 18 18 desktop Desktop Environment Accessories, managers, and utilities for your GUI desktop. 0 0 Topic :: Desktop Environment 18 :: 55
3313 58 2000031601 55 18 gnome Gnome Software for the Gnome desktop. 0 0 Topic :: Desktop Environment :: Gnome 18 :: 55 :: 58
3314 57 2000031601 55 18 kde K Desktop Environment (KDE) Software for the KDE desktop. 0 0 Topic :: Desktop Environment :: K Desktop Environment (KDE) 18 :: 55 :: 57
3315 61 2000031601 57 18 themes Themes Themes for KDE. 0 0 Topic :: Desktop Environment :: K Desktop Environment (KDE) :: Themes 18 :: 55 :: 57 :: 61
3316 56 2000031601 55 18 windowmanagers Window Managers Programs that provide window control and application launching. 0 0 Topic :: Desktop Environment :: Window Managers 18 :: 55 :: 56
3317 59 2000031601 56 18 enlightenment Enlightenment Software for the Enlightenment window manager. 0 0 Topic :: Desktop Environment :: Window Managers :: Enlightenment 18 :: 55 :: 56 :: 59
3318 60 2000031601 59 18 themes Themes Themes for the Enlightenment window manager. 0 0 Topic :: Desktop Environment :: Window Managers :: Enlightenment :: Themes 18 :: 55 :: 56 :: 59 :: 60
3319 62 2000031601 55 18 screensavers Screen Savers Screen savers and lockers. 0 0 Topic :: Desktop Environment :: Screen Savers 18 :: 55 :: 62
3320 259 2000071401 45 18 codegen Code Generators Code Generators 0 0 Topic :: Software Development :: Code Generators 18 :: 45 :: 259
3321 52 2000031601 45 18 versioncontrol Version Control Tools for managing multiple versions of evolving sources or documents. 0 0 Topic :: Software Development :: Version Control 18 :: 45 :: 52
3322 160 2000032001 0 0 language Programming Language Language in which this program was written, or was meant to support. 0 0 Programming Language 160
3323 161 2000032001 160 160 apl APL APL 0 0 Programming Language :: APL 160 :: 161
3324 164 2000032001 160 160 c C C 0 0 Programming Language :: C 160 :: 164
3325 162 2000032001 160 160 assembly Assembly Assembly-level programs. Platform specific. 0 0 Programming Language :: Assembly 160 :: 162
3326 163 2000051001 160 160 ada Ada Ada 0 0 Programming Language :: Ada 160 :: 163
3327 165 2000032001 160 160 cpp C++ C++ 0 0 Programming Language :: C++ 160 :: 165
3328 166 2000032401 160 160 eiffel Eiffel Eiffel 0 0 Programming Language :: Eiffel 160 :: 166
3329 167 2000032001 160 160 euler Euler Euler 0 0 Programming Language :: Euler 160 :: 167
3330 168 2000032001 160 160 forth Forth Forth 0 0 Programming Language :: Forth 160 :: 168
3331 169 2000032001 160 160 fortran Fortran Fortran 0 0 Programming Language :: Fortran 160 :: 169
3332 170 2000032001 160 160 lisp Lisp Lisp 0 0 Programming Language :: Lisp 160 :: 170
3333 171 2000041101 160 160 logo Logo Logo 0 0 Programming Language :: Logo 160 :: 171
3334 172 2000032001 160 160 ml ML ML 0 0 Programming Language :: ML 160 :: 172
3335 173 2000032001 160 160 modula Modula Modula-2 or Modula-3 0 0 Programming Language :: Modula 160 :: 173
3336 174 2000032001 160 160 objectivec Objective C Objective C 0 0 Programming Language :: Objective C 160 :: 174
3337 175 2000032001 160 160 pascal Pascal Pascal 0 0 Programming Language :: Pascal 160 :: 175
3338 176 2000032001 160 160 perl Perl Perl 0 0 Programming Language :: Perl 160 :: 176
3339 177 2000032001 160 160 prolog Prolog Prolog 0 0 Programming Language :: Prolog 160 :: 177
3340 178 2000032001 160 160 python Python Python 0 0 Programming Language :: Python 160 :: 178
3341 179 2000032001 160 160 rexx Rexx Rexx 0 0 Programming Language :: Rexx 160 :: 179
3342 180 2000032001 160 160 simula Simula Simula 0 0 Programming Language :: Simula 160 :: 180
3343 181 2000032001 160 160 smalltalk Smalltalk Smalltalk 0 0 Programming Language :: Smalltalk 160 :: 181
3344 182 2000032001 160 160 tcl Tcl Tcl 0 0 Programming Language :: Tcl 160 :: 182
3345 183 2000032001 160 160 php PHP PHP 0 0 Programming Language :: PHP 160 :: 183
3346 263 2000080401 160 160 euphoria Euphoria Euphoria programming language - http://www.rapideuphoria.com/ 0 0 Programming Language :: Euphoria 160 :: 263
3347 264 2000080701 160 160 erlang Erlang Erlang - developed by Ericsson - http://www.erlang.org/ 0 0 Programming Language :: Erlang 160 :: 264
3348 267 2000082001 160 160 zope Zope Zope Object Publishing 0 0 Programming Language :: Zope 160 :: 267
3349 269 2000082801 160 160 asm Assembly ASM programming 0 0 Programming Language :: Assembly 160 :: 269
3350 271 2000092001 160 160 csharp C# Microsoft's C++/Java Language 0 0 Programming Language :: C# 160 :: 271
3351 273 2000102001 160 160 Pike Pike Pike, see http://pike.roxen.com/. 0 0 Programming Language :: Pike 160 :: 273
3352 184 2000032001 160 160 asp ASP Active Server Pages 0 0 Programming Language :: ASP 160 :: 184
3353 185 2000032001 160 160 shell Unix Shell Unix Shell 0 0 Programming Language :: Unix Shell 160 :: 185
3354 186 2000032001 160 160 visualbasic Visual Basic Visual Basic 0 0 Programming Language :: Visual Basic 160 :: 186
3355 198 2000032001 160 160 java Java Java 0 0 Programming Language :: Java 160 :: 198
3356 213 2000032101 160 160 other Other Other programming language, specified in description. 0 0 Programming Language :: Other 160 :: 213
3357 242 2000042701 160 160 scheme Scheme Scheme programming language. 0 0 Programming Language :: Scheme 160 :: 242
3358 254 2000071101 160 160 plsql PL/SQL PL/SQL Programming Language 0 0 Programming Language :: PL/SQL 160 :: 254
3359 255 2000071101 160 160 progress PROGRESS PROGRESS Programming Language 0 0 Programming Language :: PROGRESS 160 :: 255
3360 258 2000071101 160 160 objectpascal Object Pascal Object Pascal 0 0 Programming Language :: Object Pascal 160 :: 258
3361 261 2000072501 160 160 xbasic XBasic XBasic programming language 0 0 Programming Language :: XBasic 160 :: 261
3362 262 2000073101 160 160 coldfusion Cold Fusion Cold Fusion Language 0 0 Programming Language :: Cold Fusion 160 :: 262
3363 304 2001041701 189 13 mpl10 Mozilla Public License 1.0 Mozilla Public License 1.0 0 0 License :: OSI Approved :: Mozilla Public License (MPL) :: Mozilla Public License 1.0 13 :: 14 :: 189 :: 304
3364 188 2000032001 14 13 mit MIT/X Consortium License MIT License, also the X Consortium License. 0 0 License :: OSI Approved :: MIT/X Consortium License 13 :: 14 :: 188
3365 187 2000032001 14 13 bsd BSD License BSD License 0 0 License :: OSI Approved :: BSD License 13 :: 14 :: 187
3366 17 2000032001 14 13 artistic Artistic License The Perl Artistic License 0 0 License :: OSI Approved :: Artistic License 13 :: 14 :: 17
3367 16 2000050801 14 13 lgpl GNU Lesser General Public License (LGPL) GNU Lesser General Public License 0 0 License :: OSI Approved :: GNU Lesser General Public License (LGPL) 13 :: 14 :: 16
3368 15 2000032001 14 13 gpl GNU General Public License (GPL) GNU General Public License. 0 0 License :: OSI Approved :: GNU General Public License (GPL) 13 :: 14 :: 15
3369 280 2000110101 160 160 JavaScript JavaScript Java Scripting Language 0 0 Programming Language :: JavaScript 160 :: 280
3370 281 2000111401 160 160 REBOL REBOL REBOL Programming Language 0 0 Programming Language :: REBOL 160 :: 281
3371 265 2001032001 160 160 Delphi Delphi/Kylix Borland/Inprise Delphi or other Object-Pascal based languages 0 0 Programming Language :: Delphi/Kylix 160 :: 265
3372 293 2001032001 160 160 ruby Ruby Ruby programming language 0 0 Programming Language :: Ruby 160 :: 293
3373 45 2000031601 18 18 development Software Development Software used to aid software development. 0 0 Topic :: Software Development 18 :: 45
3374 99 2000031601 18 18 multimedia Multimedia Graphics, sound, video, and multimedia. 0 0 Topic :: Multimedia 18 :: 99
3375 296 2001041701 14 13 asl Apache Software License Apache Software License 0 0 License :: OSI Approved :: Apache Software License 13 :: 14 :: 296
3376 274 2000102401 0 0 natlanguage Natural Language The oral/written language for the development and use of this software. 0 0 Natural Language 274
3377 295 2001040601 274 274 russian Russian Projects having something to do with Russian Language 0 0 Natural Language :: Russian 274 :: 295
3378 275 2000102401 274 274 english English English 0 0 Natural Language :: English 274 :: 275
3379 276 2000102401 274 274 french French French 0 0 Natural Language :: French 274 :: 276
3380 277 2000102401 274 274 spanish Spanish Spanish 0 0 Natural Language :: Spanish 274 :: 277
3381 278 2000102601 274 274 japanese Japanese Projects using the Japanese language 0 0 Natural Language :: Japanese 274 :: 278
3382 279 2000102601 274 274 german German Projects using the German language 0 0 Natural Language :: German 274 :: 279
3383 298 2001041701 14 13 sissl Sun Internet Standards Source License Sun Internet Standards Source License 0 0 License :: OSI Approved :: Sun Internet Standards Source License 13 :: 14 :: 298
3384 300 2001041701 14 13 josl Jabber Open Source License Jabber Open Source License 0 0 License :: OSI Approved :: Jabber Open Source License 13 :: 14 :: 300
3385 302 2001041701 14 13 sleepycat Sleepycat License Sleepycat License 0 0 License :: OSI Approved :: Sleepycat License 13 :: 14 :: 302
3390 COPY trove_group_link (trove_group_id, trove_cat_id, trove_cat_version, group_id, trove_cat_root) FROM stdin;
3395 COPY user_bookmarks (bookmark_id, user_id, bookmark_url, bookmark_title) FROM stdin;
3400 COPY user_diary (id, user_id, date_posted, summary, details, is_public) FROM stdin;
3405 COPY user_diary_monitor (monitor_id, monitored_user, user_id) FROM stdin;
3410 COPY user_group (user_group_id, user_id, group_id, admin_flags, forum_flags, project_flags, doc_flags, cvs_flags, member_role, release_flags, artifact_flags, role_id) FROM stdin;
3415 COPY user_metric (ranking, user_id, times_ranked, avg_raters_importance, avg_rating, metric, percentile, importance_factor) FROM stdin;
3420 COPY user_metric0 (ranking, user_id, times_ranked, avg_raters_importance, avg_rating, metric, percentile, importance_factor) FROM stdin;
3425 COPY user_preferences (user_id, preference_name, dead1, set_date, preference_value) FROM stdin;
3430 COPY user_ratings (rated_by, user_id, rate_field, rating) FROM stdin;
3435 COPY users (user_id, user_name, email, user_pw, realname, status, shell, unix_pw, unix_status, unix_uid, unix_box, add_date, confirm_hash, mail_siteupdates, mail_va, authorized_keys, email_new, people_view_skills, people_resume, timezone, "language", block_ratings, jabber_address, jabber_only, address, phone, fax, title, firstname, lastname, address2, ccode, theme_id, type_id, unix_gid) FROM stdin;
3436 2 noreply D /bin/bash N 20002 shell1 0 \N 0 0 \N \N 0 GMT 1 0 \N \N \N \N \N \N \N \N US 1 1 20002
3437 100 None noreply@sourceforge.net *********34343 Nobody D /bin/bash N 20100 shell1 0 \N 0 0 \N \N 0 GMT 1 0 \N \N \N \N \N \N Nobody \N \N US 1 1 20100
3442 COPY project_sums_agg (group_id, "type", count) FROM stdin;
3447 COPY prdb_dbs (dbid, group_id, dbname, dbusername, dbuserpass, requestdate, dbtype, created_by, state) FROM stdin;
3452 COPY prdb_states (stateid, statename) FROM stdin;
3457 COPY prdb_types (dbtypeid, dbservername, dbsoftware) FROM stdin;
3462 COPY prweb_vhost (vhostid, vhost_name, docdir, cgidir, group_id) FROM stdin;
3467 COPY artifact_group_list (group_artifact_id, group_id, name, description, is_public, allow_anon, email_all_updates, email_address, due_period, submit_instructions, browse_instructions, datatype, status_timeout, custom_status_field, custom_renderer) FROM stdin;
3468 100 1 Default Default Data - Dont Edit 3 0 0 2592000 \N \N 0 \N 0 \N
3473 COPY artifact_status (id, status_name) FROM stdin;
3480 COPY artifact (artifact_id, group_artifact_id, status_id, priority, submitted_by, assigned_to, open_date, close_date, summary, details, last_modified_date) FROM stdin;
3485 COPY artifact_history (id, artifact_id, field_name, old_value, mod_by, entrydate) FROM stdin;
3490 COPY artifact_file (id, artifact_id, description, bin_data, filename, filesize, filetype, adddate, submitted_by) FROM stdin;
3495 COPY artifact_message (id, artifact_id, submitted_by, from_email, adddate, body) FROM stdin;
3500 COPY artifact_monitor (id, artifact_id, user_id, email) FROM stdin;
3505 COPY artifact_canned_responses (id, group_artifact_id, title, body) FROM stdin;
3510 COPY artifact_counts_agg (group_artifact_id, count, open_count) FROM stdin;
3516 COPY stats_site_pages_by_day ("month", "day", site_page_views) FROM stdin;
3521 COPY massmail_queue (id, "type", subject, message, queued_date, last_userid, failed_date, finished_date) FROM stdin;
3526 COPY stats_agg_site_by_group ("month", "day", group_id, count) FROM stdin;
3531 COPY stats_project_metric ("month", "day", ranking, percentile, group_id) FROM stdin;
3536 COPY stats_agg_logo_by_group ("month", "day", group_id, count) FROM stdin;
3541 COPY stats_subd_pages ("month", "day", group_id, pages) FROM stdin;
3546 COPY stats_cvs_user ("month", "day", group_id, user_id, checkouts, commits, adds) FROM stdin;
3551 COPY stats_cvs_group ("month", "day", group_id, checkouts, commits, adds) FROM stdin;
3556 COPY stats_project_developers ("month", "day", group_id, developers) FROM stdin;
3561 COPY stats_project ("month", "day", group_id, file_releases, msg_posted, msg_uniq_auth, bugs_opened, bugs_closed, support_opened, support_closed, patches_opened, patches_closed, artifacts_opened, artifacts_closed, tasks_opened, tasks_closed, help_requests) FROM stdin;
3566 COPY stats_site ("month", "day", uniq_users, sessions, total_users, new_users, new_projects) FROM stdin;
3571 COPY activity_log ("day", "hour", group_id, browser, ver, platform, "time", page, "type") FROM stdin;
3576 COPY user_metric_history ("month", "day", user_id, ranking, metric) FROM stdin;
3581 COPY frs_dlstats_filetotal_agg (file_id, downloads) FROM stdin;
3586 COPY stats_project_months ("month", group_id, developers, group_ranking, group_metric, logo_showings, downloads, site_views, subdomain_views, page_views, file_releases, msg_posted, msg_uniq_auth, bugs_opened, bugs_closed, support_opened, support_closed, patches_opened, patches_closed, artifacts_opened, artifacts_closed, tasks_opened, tasks_closed, help_requests, cvs_checkouts, cvs_commits, cvs_adds) FROM stdin;
3591 COPY stats_site_pages_by_month ("month", site_page_views) FROM stdin;
3596 COPY stats_site_months ("month", site_page_views, downloads, subdomain_views, msg_posted, bugs_opened, bugs_closed, support_opened, support_closed, patches_opened, patches_closed, artifacts_opened, artifacts_closed, tasks_opened, tasks_closed, help_requests, cvs_checkouts, cvs_commits, cvs_adds) FROM stdin;
3601 COPY trove_agg (trove_cat_id, group_id, group_name, unix_group_name, status, register_time, short_description, percentile, ranking) FROM stdin;
3606 COPY trove_treesums (trove_treesums_id, trove_cat_id, limit_1, subprojects) FROM stdin;
3611 COPY frs_dlstats_file (ip_address, file_id, "month", "day", user_id) FROM stdin;
3616 COPY group_cvs_history (id, group_id, user_name, cvs_commits, cvs_commits_wk, cvs_adds, cvs_adds_wk) FROM stdin;
3621 COPY themes (theme_id, dirname, fullname, enabled) FROM stdin;
3622 1 gforge Default Theme t
3624 4 ultralite Ultra-Lite Text-only Theme t
3629 COPY supported_languages (language_id, name, filename, classname, language_code) FROM stdin;
3630 1 English English.class English en
3631 2 Japanese Japanese.class Japanese ja
3632 4 Spanish Spanish.class Spanish es
3633 5 Thai Thai.class Thai th
3634 6 German German.class German de
3635 8 Italian Italian.class Italian it
3636 10 Swedish Swedish.class Swedish sv
3637 12 Dutch Dutch.class Dutch nl
3638 14 Catalan Catalan.class Catalan ca
3639 22 Korean Korean.class Korean ko
3640 20 Bulgarian Bulgarian.class Bulgarian bg
3641 17 Russian Russian.class Russian ru
3642 7 French French.class French fr
3643 23 Smpl.Chinese SimplifiedChinese.class SimplifiedChinese zh-cn
3644 11 Trad.Chinese Chinese.class Chinese zh-tw
3645 16 Pt. Brazilian PortugueseBrazilian.class PortugueseBrazilian pt-br
3650 COPY skills_data_types (type_id, type_name) FROM stdin;
3660 COPY skills_data (skills_data_id, user_id, "type", title, "start", finish, keywords) FROM stdin;
3665 COPY project_category (category_id, group_project_id, category_name) FROM stdin;
3671 COPY project_task_artifact (project_task_id, artifact_id) FROM stdin;
3676 COPY project_messages (project_message_id, project_task_id, body, posted_by, postdate) FROM stdin;
3681 COPY plugins (plugin_id, plugin_name, plugin_desc) FROM stdin;
3684 3 cvstracker CVS Tracker Integration
3685 4 online_help Online Help Plugin
3690 COPY group_plugin (group_plugin_id, group_id, plugin_id) FROM stdin;
3699 COPY user_plugin (user_plugin_id, user_id, plugin_id) FROM stdin;
3704 COPY cron_history (rundate, job, output) FROM stdin;
3709 COPY country_code (country_name, ccode) FROM stdin;
3718 ANTIGUA AND BARBUDA AG
3736 BOSNIA AND HERZEGOVINA BA
3740 BRITISH INDIAN OCEAN TERRITORY IO
3741 BRUNEI DARUSSALAM BN
3750 CENTRAL AFRICAN REPUBLIC CF
3755 COCOS (KEELING) ISLANDS CC
3759 CONGO, THE DEMOCRATIC REPUBLIC OF THE CD
3770 DOMINICAN REPUBLIC DO
3775 EQUATORIAL GUINEA GQ
3779 FALKLAND ISLANDS (MALVINAS) FK
3786 FRENCH SOUTHERN TERRITORIES TF
3803 HEARD ISLAND AND MCDONALD ISLANDS HM
3804 HOLY SEE (VATICAN CITY STATE) VA
3811 IRAN, ISLAMIC REPUBLIC OF IR
3822 KOREA, DEMOCRATIC PEOPLE'S REPUBLIC OF KP
3823 KOREA, REPUBLIC OF KR
3826 LAO PEOPLE'S DEMOCRATIC REPUBLIC LA
3831 LIBYAN ARAB JAMAHIRIYA LY
3836 MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF MK
3849 MICRONESIA, FEDERATED STATES OF FM
3850 MOLDOVA, REPUBLIC OF MD
3861 NETHERLANDS ANTILLES AN
3869 NORTHERN MARIANA ISLANDS MP
3874 PALESTINIAN TERRITORY, OCCUPIED PS
3887 RUSSIAN FEDERATION RU
3890 SAINT KITTS AND NEVIS KN
3892 SAINT PIERRE AND MIQUELON PM
3893 SAINT VINCENT AND THE GRENADINES VC
3896 SAO TOME AND PRINCIPE ST
3907 SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS GS
3912 SVALBARD AND JAN MAYEN SJ
3916 SYRIAN ARAB REPUBLIC SY
3917 TAIWAN, PROVINCE OF CHINA TW
3919 TANZANIA, UNITED REPUBLIC OF TZ
3924 TRINIDAD AND TOBAGO TT
3928 TURKS AND CAICOS ISLANDS TC
3932 UNITED ARAB EMIRATES AE
3934 UNITED STATES MINOR OUTLYING ISLANDS UM
3940 VIRGIN ISLANDS, BRITISH VG
3941 VIRGIN ISLANDS, U.S. VI
3942 WALLIS AND FUTUNA WF
3953 COPY licenses (license_id, license_name) FROM stdin;
3955 101 GNU General Public License (GPL)
3956 102 GNU Library Public License (LGPL)
3959 105 Artistic License
3960 106 Mozilla Public License 1.0 (MPL)
3961 107 Qt Public License (QPL)
3962 108 IBM Public License
3963 109 MITRE Collaborative Virtual Workspace License (CVW License)
3964 110 Ricoh Source Code Public License
3966 112 zlib/libpng License
3967 113 Apache Software License
3968 114 Vovida Software License 1.0
3969 115 Sun Internet Standards Source License (SISSL)
3970 116 Intel Open Source License
3971 117 Mozilla Public License 1.1 (MPL 1.1)
3972 118 Jabber Open Source License
3973 119 Nokia Open Source License
3974 120 Sleepycat License
3975 121 Nethack General Public License
3976 122 IBM Common Public License
3977 123 Apple Public Source License
3980 126 Other/Proprietary License
3985 COPY user_type (type_id, type_name) FROM stdin;
3992 COPY role (role_id, group_id, role_name) FROM stdin;
3995 3 2 Senior Developer
3996 4 2 Junior Developer
4000 8 3 Senior Developer
4001 9 3 Junior Developer
4005 13 4 Senior Developer
4006 14 4 Junior Developer
4010 18 1 Senior Developer
4011 19 1 Junior Developer
4018 COPY role_setting (role_id, section_name, ref_id, value) FROM stdin;
4173 COPY artifact_extra_field_list (extra_field_id, group_artifact_id, field_name, field_type, attribute1, attribute2, is_required, alias) FROM stdin;
4178 COPY artifact_extra_field_elements (element_id, extra_field_id, element_name, status_id) FROM stdin;
4183 COPY artifact_extra_field_data (data_id, artifact_id, field_data, extra_field_id) FROM stdin;
4188 COPY project_counts_agg (group_project_id, count, open_count) FROM stdin;
4194 COPY project_task_external_order (project_task_id, external_id) FROM stdin;
4199 COPY group_join_request (group_id, user_id, comments, request_date) FROM stdin;
4204 COPY artifact_type_monitor (group_artifact_id, user_id) FROM stdin;
4209 COPY plugin_cvstracker_data_artifact (id, kind, group_artifact_id, project_task_id) FROM stdin;
4214 COPY plugin_cvstracker_data_master (id, holder_id, log_text, file, prev_version, actual_version, author, cvs_date) FROM stdin;
4219 COPY nss_groups (user_id, group_id, name, gid) FROM stdin;
4222 0 4 peerrating 10004
4225 0 3 scm_newsadmin 50003
4226 0 4 scm_peerrating 50004
4227 0 1 scm_siteadmin 50001
4232 COPY nss_usergroups (uid, gid, user_id, group_id, user_name, unix_group_name) FROM stdin;
4237 COPY deleted_mailing_lists (mailing_list_name, delete_date, isdeleted) FROM stdin;
4242 COPY deleted_groups (unix_group_name, delete_date, isdeleted) FROM stdin;
4247 COPY artifact_query (artifact_query_id, group_artifact_id, user_id, query_name) FROM stdin;
4252 COPY artifact_query_fields (artifact_query_id, query_field_type, query_field_id, query_field_values) FROM stdin;
4257 COPY form_keys (key_id, "key", creation_date, is_used) FROM stdin;
4262 COPY forum_attachment (attachmentid, userid, dateline, filename, filedata, visible, counter, filesize, msg_id, filehash) FROM stdin;
4267 COPY forum_attachment_type (extension, mimetype, size, width, height, enabled) FROM stdin;
4268 gif a:1:{i:0;s:23:"Content-type: image/gif";} 20000 620 280 1
4269 jpeg a:1:{i:0;s:24:"Content-type: image/jpeg";} 20000 620 280 1
4270 jpg a:1:{i:0;s:24:"Content-type: image/jpeg";} 100000 0 0 1
4271 jpe a:1:{i:0;s:24:"Content-type: image/jpeg";} 20000 620 280 1
4272 png a:1:{i:0;s:23:"Content-type: image/png";} 20000 620 280 1
4273 doc a:2:{i:0;s:20:"Accept-ranges: bytes";i:1;s:32:"Content-type: application/msword";} 20000 0 0 1
4274 pdf a:1:{i:0;s:29:"Content-type: application/pdf";} 20000 0 0 1
4275 bmp a:1:{i:0;s:26:"Content-type: image/bitmap";} 20000 620 280 1
4276 psd a:1:{i:0;s:29:"Content-type: unknown/unknown";} 20000 0 0 1
4277 zip a:1:{i:0;s:29:"Content-type: application/zip";} 100000 0 0 1
4278 txt a:1:{i:0;s:24:"Content-type: plain/text";} 20000 0 0 1
4283 COPY forum_pending_messages (msg_id, group_forum_id, posted_by, subject, body, post_date, is_followup_to, thread_id, has_followups, most_recent_date) FROM stdin;
4288 COPY forum_pending_attachment (attachmentid, userid, dateline, filename, filedata, visible, counter, filesize, msg_id, filehash) FROM stdin;
4293 COPY group_activity_monitor (group_id, user_id, filter) FROM stdin;
4298 CREATE INDEX db_images_group ON db_images USING btree (group_id);
4302 CREATE INDEX doc_groups_group ON doc_groups USING btree (group_id);
4306 CREATE INDEX forum_forumid_msgid ON forum USING btree (group_forum_id, msg_id);
4310 CREATE INDEX forum_group_forum_id ON forum USING btree (group_forum_id);
4314 CREATE INDEX forum_forumid_threadid_mostrece ON forum USING btree (group_forum_id, thread_id, most_recent_date);
4318 CREATE INDEX forum_threadid_isfollowupto ON forum USING btree (thread_id, is_followup_to);
4322 CREATE INDEX forum_forumid_isfollto_mostrece ON forum USING btree (group_forum_id, is_followup_to, most_recent_date);
4326 CREATE INDEX forum_group_list_group_id ON forum_group_list USING btree (group_id);
4330 CREATE INDEX frs_file_date ON frs_file USING btree (post_date);
4334 CREATE INDEX frs_file_release_id ON frs_file USING btree (release_id);
4338 CREATE INDEX package_group_id ON frs_package USING btree (group_id);
4342 CREATE INDEX frs_release_package ON frs_release USING btree (package_id);
4346 CREATE INDEX group_history_group_id ON group_history USING btree (group_id);
4350 CREATE UNIQUE INDEX group_unix_uniq ON groups USING btree (unix_group_name);
4354 CREATE INDEX groups_type ON groups USING btree (type_id);
4358 CREATE INDEX groups_public ON groups USING btree (is_public);
4362 CREATE INDEX groups_status ON groups USING btree (status);
4366 CREATE INDEX mail_group_list_group ON mail_group_list USING btree (group_id);
4370 CREATE INDEX news_bytes_group ON news_bytes USING btree (group_id);
4374 CREATE INDEX news_bytes_approved ON news_bytes USING btree (is_approved);
4378 CREATE INDEX news_bytes_forum ON news_bytes USING btree (forum_id);
4382 CREATE INDEX news_group_date ON news_bytes USING btree (group_id, post_date);
4386 CREATE INDEX news_approved_date ON news_bytes USING btree (is_approved, post_date);
4390 CREATE INDEX people_job_group_id ON people_job USING btree (group_id);
4394 CREATE INDEX project_group_list_group_id ON project_group_list USING btree (group_id);
4398 CREATE INDEX project_history_task_id ON project_history USING btree (project_task_id);
4402 CREATE INDEX project_metric_group ON project_metric USING btree (group_id);
4406 CREATE INDEX projecttask_projid_status ON project_task USING btree (group_project_id, status_id);
4410 CREATE INDEX projectweeklymetric_ranking ON project_weekly_metric USING btree (ranking);
4414 CREATE INDEX project_metric_weekly_group ON project_weekly_metric USING btree (group_id);
4418 CREATE INDEX session_user_id ON user_session USING btree (user_id);
4422 CREATE INDEX session_time ON user_session USING btree ("time");
4426 CREATE INDEX snippet_language ON snippet USING btree ("language");
4430 CREATE INDEX snippet_category ON snippet USING btree (category);
4434 CREATE INDEX snippet_package_language ON snippet_package USING btree ("language");
4438 CREATE INDEX snippet_package_category ON snippet_package USING btree (category);
4442 CREATE INDEX snippet_package_item_pkg_ver ON snippet_package_item USING btree (snippet_package_version_id);
4446 CREATE INDEX snippet_package_version_pkg_id ON snippet_package_version USING btree (snippet_package_id);
4450 CREATE INDEX snippet_version_snippet_id ON snippet_version USING btree (snippet_id);
4454 CREATE INDEX pages_by_day_day ON stats_agg_pages_by_day USING btree ("day");
4458 CREATE INDEX survey_questions_group ON survey_questions USING btree (group_id);
4462 CREATE INDEX survey_rating_aggregate_type_id ON survey_rating_aggregate USING btree ("type", id);
4466 CREATE INDEX survey_rating_responses_user_ty ON survey_rating_response USING btree (user_id, "type", id);
4470 CREATE INDEX survey_rating_responses_type_id ON survey_rating_response USING btree ("type", id);
4474 CREATE INDEX survey_responses_group_id ON survey_responses USING btree (group_id);
4478 CREATE INDEX survey_responses_user_survey_qu ON survey_responses USING btree (user_id, survey_id, question_id);
4482 CREATE INDEX survey_responses_survey_questio ON survey_responses USING btree (survey_id, question_id);
4486 CREATE INDEX surveys_group ON surveys USING btree (group_id);
4490 CREATE INDEX user_bookmark_user_id ON user_bookmarks USING btree (user_id);
4494 CREATE INDEX user_diary_user_date ON user_diary USING btree (user_id, date_posted);
4498 CREATE INDEX user_metric0_user_id ON user_metric0 USING btree (user_id);
4502 CREATE INDEX user_ratings_user_id ON user_ratings USING btree (user_id);
4506 CREATE UNIQUE INDEX users_namename_uniq ON users USING btree (user_name);
4510 CREATE INDEX users_status ON users USING btree (status);
4514 CREATE UNIQUE INDEX idx_prdb_dbname ON prdb_dbs USING btree (dbname);
4518 CREATE INDEX idx_vhost_groups ON prweb_vhost USING btree (group_id);
4522 CREATE UNIQUE INDEX idx_vhost_hostnames ON prweb_vhost USING btree (vhost_name);
4526 CREATE INDEX artgrouplist_groupid_public ON artifact_group_list USING btree (group_id, is_public);
4530 CREATE INDEX art_groupartid ON artifact USING btree (group_artifact_id);
4534 CREATE INDEX art_groupartid_statusid ON artifact USING btree (group_artifact_id, status_id);
4538 CREATE INDEX art_groupartid_assign ON artifact USING btree (group_artifact_id, assigned_to);
4542 CREATE INDEX art_groupartid_submit ON artifact USING btree (group_artifact_id, submitted_by);
4546 CREATE INDEX art_submit_status ON artifact USING btree (submitted_by, status_id);
4550 CREATE INDEX art_assign_status ON artifact USING btree (assigned_to, status_id);
4554 CREATE INDEX art_groupartid_artifactid ON artifact USING btree (group_artifact_id, artifact_id);
4558 CREATE INDEX arthistory_artid_entrydate ON artifact_history USING btree (artifact_id, entrydate);
4562 CREATE INDEX artfile_artid_adddate ON artifact_file USING btree (artifact_id, adddate);
4566 CREATE INDEX artmessage_artid_adddate ON artifact_message USING btree (artifact_id, adddate);
4570 CREATE INDEX artifactcannedresponses_groupid ON artifact_canned_responses USING btree (group_artifact_id);
4574 -- CREATE UNIQUE INDEX statssitepgsbyday_oid ON stats_site_pages_by_day USING btree (oid);
4578 CREATE INDEX statssitepagesbyday_month_day ON stats_site_pages_by_day USING btree ("month", "day");
4582 -- CREATE UNIQUE INDEX statsaggsitebygrp_oid ON stats_agg_site_by_group USING btree (oid);
4586 CREATE UNIQUE INDEX statssitebygroup_month_day_grou ON stats_agg_site_by_group USING btree ("month", "day", group_id);
4590 -- CREATE UNIQUE INDEX statsprojectmetric_oid ON stats_project_metric USING btree (oid);
4594 CREATE UNIQUE INDEX statsprojectmetric_month_day_gr ON stats_project_metric USING btree ("month", "day", group_id);
4598 -- CREATE UNIQUE INDEX statsagglogobygrp_oid ON stats_agg_logo_by_group USING btree (oid);
4602 CREATE UNIQUE INDEX statslogobygroup_month_day_grou ON stats_agg_logo_by_group USING btree ("month", "day", group_id);
4606 -- CREATE UNIQUE INDEX statssubdpages_oid ON stats_subd_pages USING btree (oid);
4610 CREATE UNIQUE INDEX statssubdpages_month_day_group ON stats_subd_pages USING btree ("month", "day", group_id);
4614 -- CREATE UNIQUE INDEX statscvsgrp_oid ON stats_cvs_group USING btree (oid);
4618 CREATE UNIQUE INDEX statscvsgroup_month_day_group ON stats_cvs_group USING btree ("month", "day", group_id);
4622 -- CREATE UNIQUE INDEX statsprojectdevelop_oid ON stats_project_developers USING btree (oid);
4626 CREATE UNIQUE INDEX statsprojectdev_month_day_group ON stats_project_developers USING btree ("month", "day", group_id);
4630 -- CREATE UNIQUE INDEX statsproject_oid ON stats_project USING btree (oid);
4634 CREATE UNIQUE INDEX statsproject_month_day_group ON stats_project USING btree ("month", "day", group_id);
4638 -- CREATE UNIQUE INDEX statssite_oid ON stats_site USING btree (oid);
4642 CREATE UNIQUE INDEX statssite_month_day ON stats_site USING btree ("month", "day");
4646 CREATE INDEX statsprojectmonths_groupid ON stats_project_months USING btree (group_id);
4650 CREATE INDEX statsprojectmonths_groupid_mont ON stats_project_months USING btree (group_id, "month");
4654 CREATE INDEX statssitemonths_month ON stats_site_months USING btree ("month");
4658 CREATE INDEX troveagg_trovecatid_ranking ON trove_agg USING btree (trove_cat_id, ranking);
4662 CREATE INDEX groupcvshistory_groupid ON group_cvs_history USING btree (group_id);
4666 CREATE UNIQUE INDEX themes_theme_id_key ON themes USING btree (theme_id);
4670 CREATE UNIQUE INDEX project_categor_category_id_key ON project_category USING btree (category_id);
4674 CREATE INDEX projectcategory_groupprojectid ON project_category USING btree (group_project_id);
4678 CREATE UNIQUE INDEX project_messa_project_messa_key ON project_messages USING btree (project_message_id);
4682 CREATE UNIQUE INDEX plugins_plugin_name_key ON plugins USING btree (plugin_name);
4686 CREATE INDEX cronhist_rundate ON cron_history USING btree (rundate);
4690 CREATE UNIQUE INDEX role_groupidroleid ON role USING btree (group_id, role_id);
4694 CREATE INDEX artifactextrafldlmts_extrafieldid ON artifact_extra_field_elements USING btree (extra_field_id);
4698 CREATE INDEX artifactextrafielddata_artifactid ON artifact_extra_field_data USING btree (artifact_id);
4702 CREATE INDEX artifactextrafieldlist_groupartid ON artifact_extra_field_list USING btree (group_artifact_id);
4706 CREATE INDEX artmonitor_useridartid ON artifact_monitor USING btree (user_id, artifact_id);
4710 CREATE INDEX cronhist_jobrundate ON cron_history USING btree (job, rundate);
4714 CREATE INDEX filemodulemonitor_useridfilemoduleid ON filemodule_monitor USING btree (user_id, filemodule_id);
4718 CREATE INDEX forummonitoredforums_useridforumid ON forum_monitored_forums USING btree (user_id, forum_id);
4722 CREATE INDEX groupplugin_groupid ON group_plugin USING btree (group_id);
4726 CREATE INDEX prdbdbs_groupid ON prdb_dbs USING btree (group_id);
4730 CREATE INDEX prdbstates_stateid ON prdb_states USING btree (stateid);
4734 CREATE INDEX projectassigned_assignedtotaskid ON project_assigned_to USING btree (assigned_to_id, project_task_id);
4738 CREATE INDEX projectdep_isdepon_projtaskid ON project_dependencies USING btree (is_dependent_on_task_id, project_task_id);
4742 CREATE INDEX projectmsgs_projtaskidpostdate ON project_messages USING btree (project_task_id, postdate);
4746 CREATE INDEX projecttaskartifact_artidprojtaskid ON project_task_artifact USING btree (artifact_id, project_task_id);
4750 CREATE UNIQUE INDEX supportedlanguage_code ON supported_languages USING btree (language_code);
4754 CREATE INDEX trovecat_parentid ON trove_cat USING btree (parent);
4758 CREATE INDEX trovegrouplink_groupidcatid ON trove_group_link USING btree (group_id, trove_cat_id);
4762 CREATE INDEX userdiarymon_useridmonitoredid ON user_diary_monitor USING btree (user_id, monitored_user);
4766 CREATE INDEX usergroup_useridgroupid ON user_group USING btree (user_id, group_id);
4770 CREATE UNIQUE INDEX usermetric_userid ON user_metric USING btree (user_id);
4774 CREATE INDEX usermetrichistory_useridmonthday ON user_metric_history USING btree (user_id, "month", "day");
4778 CREATE INDEX plugin_cvstracker_group_artifact_id ON plugin_cvstracker_data_artifact USING btree (group_artifact_id);
4782 CREATE INDEX docgroups_parentdocgroup ON doc_groups USING btree (parent_doc_group);
4786 CREATE INDEX docdata_groupid ON doc_data USING btree (group_id, doc_group);
4790 ALTER TABLE ONLY canned_responses
4791 ADD CONSTRAINT canned_responses_pkey PRIMARY KEY (response_id);
4795 ALTER TABLE ONLY db_images
4796 ADD CONSTRAINT db_images_pkey PRIMARY KEY (id);
4800 ALTER TABLE ONLY doc_data
4801 ADD CONSTRAINT doc_data_pkey PRIMARY KEY (docid);
4805 ALTER TABLE ONLY doc_groups
4806 ADD CONSTRAINT doc_groups_pkey PRIMARY KEY (doc_group);
4810 ALTER TABLE ONLY doc_states
4811 ADD CONSTRAINT doc_states_pkey PRIMARY KEY (stateid);
4815 ALTER TABLE ONLY forum
4816 ADD CONSTRAINT forum_pkey PRIMARY KEY (msg_id);
4820 ALTER TABLE ONLY forum_agg_msg_count
4821 ADD CONSTRAINT forum_agg_msg_count_pkey PRIMARY KEY (group_forum_id);
4825 ALTER TABLE ONLY forum_group_list
4826 ADD CONSTRAINT forum_group_list_pkey PRIMARY KEY (group_forum_id);
4830 ALTER TABLE ONLY frs_file
4831 ADD CONSTRAINT frs_file_pkey PRIMARY KEY (file_id);
4835 ALTER TABLE ONLY frs_filetype
4836 ADD CONSTRAINT frs_filetype_pkey PRIMARY KEY (type_id);
4840 ALTER TABLE ONLY frs_package
4841 ADD CONSTRAINT frs_package_pkey PRIMARY KEY (package_id);
4845 ALTER TABLE ONLY frs_processor
4846 ADD CONSTRAINT frs_processor_pkey PRIMARY KEY (processor_id);
4850 ALTER TABLE ONLY frs_release
4851 ADD CONSTRAINT frs_release_pkey PRIMARY KEY (release_id);
4855 ALTER TABLE ONLY frs_status
4856 ADD CONSTRAINT frs_status_pkey PRIMARY KEY (status_id);
4860 ALTER TABLE ONLY group_history
4861 ADD CONSTRAINT group_history_pkey PRIMARY KEY (group_history_id);
4865 ALTER TABLE ONLY groups
4866 ADD CONSTRAINT groups_pkey PRIMARY KEY (group_id);
4870 ALTER TABLE ONLY mail_group_list
4871 ADD CONSTRAINT mail_group_list_pkey PRIMARY KEY (group_list_id);
4875 ALTER TABLE ONLY news_bytes
4876 ADD CONSTRAINT news_bytes_pkey PRIMARY KEY (id);
4880 ALTER TABLE ONLY people_job
4881 ADD CONSTRAINT people_job_pkey PRIMARY KEY (job_id);
4885 ALTER TABLE ONLY people_job_category
4886 ADD CONSTRAINT people_job_category_pkey PRIMARY KEY (category_id);
4890 ALTER TABLE ONLY people_job_inventory
4891 ADD CONSTRAINT people_job_inventory_pkey PRIMARY KEY (job_inventory_id);
4895 ALTER TABLE ONLY people_job_status
4896 ADD CONSTRAINT people_job_status_pkey PRIMARY KEY (status_id);
4900 ALTER TABLE ONLY people_skill
4901 ADD CONSTRAINT people_skill_pkey PRIMARY KEY (skill_id);
4905 ALTER TABLE ONLY people_skill_inventory
4906 ADD CONSTRAINT people_skill_inventory_pkey PRIMARY KEY (skill_inventory_id);
4910 ALTER TABLE ONLY people_skill_level
4911 ADD CONSTRAINT people_skill_level_pkey PRIMARY KEY (skill_level_id);
4915 ALTER TABLE ONLY people_skill_year
4916 ADD CONSTRAINT people_skill_year_pkey PRIMARY KEY (skill_year_id);
4920 ALTER TABLE ONLY project_group_list
4921 ADD CONSTRAINT project_group_list_pkey PRIMARY KEY (group_project_id);
4925 ALTER TABLE ONLY project_history
4926 ADD CONSTRAINT project_history_pkey PRIMARY KEY (project_history_id);
4930 ALTER TABLE ONLY project_metric
4931 ADD CONSTRAINT project_metric_pkey PRIMARY KEY (ranking);
4935 ALTER TABLE ONLY project_metric_tmp1
4936 ADD CONSTRAINT project_metric_tmp1_pkey PRIMARY KEY (ranking);
4940 ALTER TABLE ONLY project_status
4941 ADD CONSTRAINT project_status_pkey PRIMARY KEY (status_id);
4945 ALTER TABLE ONLY project_task
4946 ADD CONSTRAINT project_task_pkey PRIMARY KEY (project_task_id);
4950 ALTER TABLE ONLY user_session
4951 ADD CONSTRAINT session_pkey PRIMARY KEY (session_hash);
4955 ALTER TABLE ONLY snippet
4956 ADD CONSTRAINT snippet_pkey PRIMARY KEY (snippet_id);
4960 ALTER TABLE ONLY snippet_package
4961 ADD CONSTRAINT snippet_package_pkey PRIMARY KEY (snippet_package_id);
4965 ALTER TABLE ONLY snippet_package_item
4966 ADD CONSTRAINT snippet_package_item_pkey PRIMARY KEY (snippet_package_item_id);
4970 ALTER TABLE ONLY snippet_package_version
4971 ADD CONSTRAINT snippet_package_version_pkey PRIMARY KEY (snippet_package_version_id);
4975 ALTER TABLE ONLY snippet_version
4976 ADD CONSTRAINT snippet_version_pkey PRIMARY KEY (snippet_version_id);
4980 ALTER TABLE ONLY survey_question_types
4981 ADD CONSTRAINT survey_question_types_pkey PRIMARY KEY (id);
4985 ALTER TABLE ONLY survey_questions
4986 ADD CONSTRAINT survey_questions_pkey PRIMARY KEY (question_id);
4990 ALTER TABLE ONLY surveys
4991 ADD CONSTRAINT surveys_pkey PRIMARY KEY (survey_id);
4995 ALTER TABLE ONLY trove_cat
4996 ADD CONSTRAINT trove_cat_pkey PRIMARY KEY (trove_cat_id);
5000 ALTER TABLE ONLY user_bookmarks
5001 ADD CONSTRAINT user_bookmarks_pkey PRIMARY KEY (bookmark_id);
5005 ALTER TABLE ONLY user_diary
5006 ADD CONSTRAINT user_diary_pkey PRIMARY KEY (id);
5010 ALTER TABLE ONLY user_metric
5011 ADD CONSTRAINT user_metric_pkey PRIMARY KEY (ranking);
5015 ALTER TABLE ONLY user_metric0
5016 ADD CONSTRAINT user_metric0_pkey PRIMARY KEY (ranking);
5020 ALTER TABLE ONLY users
5021 ADD CONSTRAINT users_pkey PRIMARY KEY (user_id);
5025 ALTER TABLE ONLY prdb_dbs
5026 ADD CONSTRAINT prdb_dbs_pkey PRIMARY KEY (dbid);
5030 ALTER TABLE ONLY prdb_types
5031 ADD CONSTRAINT prdb_types_pkey PRIMARY KEY (dbtypeid);
5035 ALTER TABLE ONLY prweb_vhost
5036 ADD CONSTRAINT prweb_vhost_pkey PRIMARY KEY (vhostid);
5040 ALTER TABLE ONLY artifact_group_list
5041 ADD CONSTRAINT artifact_group_list_pkey PRIMARY KEY (group_artifact_id);
5045 ALTER TABLE ONLY artifact_status
5046 ADD CONSTRAINT artifact_status_pkey PRIMARY KEY (id);
5050 ALTER TABLE ONLY artifact
5051 ADD CONSTRAINT artifact_pkey PRIMARY KEY (artifact_id);
5055 ALTER TABLE ONLY artifact_history
5056 ADD CONSTRAINT artifact_history_pkey PRIMARY KEY (id);
5060 ALTER TABLE ONLY artifact_file
5061 ADD CONSTRAINT artifact_file_pkey PRIMARY KEY (id);
5065 ALTER TABLE ONLY artifact_message
5066 ADD CONSTRAINT artifact_message_pkey PRIMARY KEY (id);
5070 ALTER TABLE ONLY artifact_canned_responses
5071 ADD CONSTRAINT artifact_canned_responses_pkey PRIMARY KEY (id);
5075 ALTER TABLE ONLY massmail_queue
5076 ADD CONSTRAINT massmail_queue_pkey PRIMARY KEY (id);
5080 ALTER TABLE ONLY supported_languages
5081 ADD CONSTRAINT supported_languages_pkey PRIMARY KEY (language_id);
5085 ALTER TABLE ONLY skills_data_types
5086 ADD CONSTRAINT skills_data_types_pkey PRIMARY KEY (type_id);
5090 ALTER TABLE ONLY skills_data
5091 ADD CONSTRAINT skills_data_pkey PRIMARY KEY (skills_data_id);
5095 ALTER TABLE ONLY plugins
5096 ADD CONSTRAINT plugins_pkey PRIMARY KEY (plugin_id);
5100 ALTER TABLE ONLY group_plugin
5101 ADD CONSTRAINT group_plugin_pkey PRIMARY KEY (group_plugin_id);
5105 ALTER TABLE ONLY country_code
5106 ADD CONSTRAINT country_code_pkey PRIMARY KEY (ccode);
5110 ALTER TABLE ONLY user_type
5111 ADD CONSTRAINT user_type_type_id_key UNIQUE (type_id);
5115 ALTER TABLE ONLY artifact_extra_field_data
5116 ADD CONSTRAINT artifact_extra_field_data_pkey PRIMARY KEY (data_id);
5120 ALTER TABLE ONLY group_join_request
5121 ADD CONSTRAINT group_join_request_pkey PRIMARY KEY (group_id, user_id);
5125 ALTER TABLE ONLY artifact_type_monitor
5126 ADD CONSTRAINT artifact_type_monitor_pkey PRIMARY KEY (group_artifact_id, user_id);
5130 ALTER TABLE ONLY artifact_counts_agg
5131 ADD CONSTRAINT artifact_counts_agg_pkey PRIMARY KEY (group_artifact_id);
5135 ALTER TABLE ONLY artifact_extra_field_elements
5136 ADD CONSTRAINT artifact_extra_field_elements_pkey PRIMARY KEY (element_id);
5140 ALTER TABLE ONLY artifact_extra_field_list
5141 ADD CONSTRAINT artifact_extra_field_list_pkey PRIMARY KEY (extra_field_id);
5145 ALTER TABLE ONLY artifact_monitor
5146 ADD CONSTRAINT artifact_monitor_pkey PRIMARY KEY (artifact_id, user_id);
5150 ALTER TABLE ONLY filemodule_monitor
5151 ADD CONSTRAINT filemodule_monitor_pkey PRIMARY KEY (filemodule_id, user_id);
5155 ALTER TABLE ONLY forum_monitored_forums
5156 ADD CONSTRAINT forum_monitored_forums_pkey PRIMARY KEY (forum_id, user_id);
5160 ALTER TABLE ONLY forum_saved_place
5161 ADD CONSTRAINT forum_saved_place_pkey PRIMARY KEY (user_id, forum_id);
5165 ALTER TABLE ONLY frs_dlstats_filetotal_agg
5166 ADD CONSTRAINT frs_dlstats_filetotal_agg_pkey PRIMARY KEY (file_id);
5170 ALTER TABLE ONLY licenses
5171 ADD CONSTRAINT licenses_pkey PRIMARY KEY (license_id);
5175 ALTER TABLE ONLY project_assigned_to
5176 ADD CONSTRAINT project_assigned_to_pkey PRIMARY KEY (project_task_id, assigned_to_id);
5180 ALTER TABLE ONLY project_counts_agg
5181 ADD CONSTRAINT project_counts_agg_pkey PRIMARY KEY (group_project_id);
5185 ALTER TABLE ONLY project_dependencies
5186 ADD CONSTRAINT project_dependencies_pkey PRIMARY KEY (project_task_id, is_dependent_on_task_id);
5190 ALTER TABLE ONLY project_sums_agg
5191 ADD CONSTRAINT project_sums_agg_pkey PRIMARY KEY (group_id, "type");
5195 ALTER TABLE ONLY project_task_artifact
5196 ADD CONSTRAINT project_task_artifact_pkey PRIMARY KEY (project_task_id, artifact_id);
5200 ALTER TABLE ONLY project_task_external_order
5201 ADD CONSTRAINT project_task_external_order_pkey PRIMARY KEY (project_task_id);
5205 ALTER TABLE ONLY role
5206 ADD CONSTRAINT role_role_id_pkey PRIMARY KEY (role_id);
5210 ALTER TABLE ONLY role_setting
5211 ADD CONSTRAINT role_setting_pkey PRIMARY KEY (role_id, section_name, ref_id);
5215 ALTER TABLE ONLY trove_group_link
5216 ADD CONSTRAINT trove_group_link_pkey PRIMARY KEY (trove_cat_id, group_id, trove_cat_version);
5220 ALTER TABLE ONLY trove_treesums
5221 ADD CONSTRAINT trove_treesums_pkey PRIMARY KEY (trove_cat_id);
5225 ALTER TABLE ONLY user_diary_monitor
5226 ADD CONSTRAINT user_diary_monitor_pkey PRIMARY KEY (monitored_user, user_id);
5230 ALTER TABLE ONLY user_group
5231 ADD CONSTRAINT user_group_pkey PRIMARY KEY (group_id, user_id);
5235 ALTER TABLE ONLY user_metric_history
5236 ADD CONSTRAINT user_metric_history_pkey PRIMARY KEY ("month", "day", user_id);
5240 ALTER TABLE ONLY user_plugin
5241 ADD CONSTRAINT user_plugin_pkey PRIMARY KEY (user_id, plugin_id);
5245 ALTER TABLE ONLY user_preferences
5246 ADD CONSTRAINT user_preferences_pkey PRIMARY KEY (user_id, preference_name);
5250 ALTER TABLE ONLY user_ratings
5251 ADD CONSTRAINT user_ratings_pkey PRIMARY KEY (rated_by, user_id, rate_field);
5255 ALTER TABLE ONLY plugin_cvstracker_data_artifact
5256 ADD CONSTRAINT plugin_cvstracker_artifact_pkey PRIMARY KEY (id);
5260 ALTER TABLE ONLY plugin_cvstracker_data_master
5261 ADD CONSTRAINT plugin_cvstracker_master_pkey PRIMARY KEY (id);
5265 ALTER TABLE ONLY artifact_query
5266 ADD CONSTRAINT artifact_query_pkey PRIMARY KEY (artifact_query_id);
5270 ALTER TABLE ONLY artifact_query_fields
5271 ADD CONSTRAINT artifact_query_elements_pkey PRIMARY KEY (artifact_query_id, query_field_type, query_field_id);
5275 ALTER TABLE ONLY form_keys
5276 ADD CONSTRAINT form_keys_pkey PRIMARY KEY (key_id);
5280 ALTER TABLE ONLY form_keys
5281 ADD CONSTRAINT "key" UNIQUE ("key");
5285 ALTER TABLE ONLY forum_attachment
5286 ADD CONSTRAINT forum_attachment_pkey PRIMARY KEY (attachmentid);
5290 ALTER TABLE ONLY forum_attachment_type
5291 ADD CONSTRAINT forum_attachment_type_pkey PRIMARY KEY (extension);
5295 ALTER TABLE ONLY forum_pending_messages
5296 ADD CONSTRAINT forum_pending_messages_pkey PRIMARY KEY (msg_id);
5300 ALTER TABLE ONLY forum_pending_attachment
5301 ADD CONSTRAINT forum_pending_attachment_pkey PRIMARY KEY (attachmentid);
5305 ALTER TABLE ONLY group_activity_monitor
5306 ADD CONSTRAINT group_activity_monitor_pkey PRIMARY KEY (group_id, user_id);
5310 ALTER TABLE ONLY users
5311 ADD CONSTRAINT users_typeid FOREIGN KEY (type_id) REFERENCES user_type(type_id) MATCH FULL;
5315 ALTER TABLE ONLY role
5316 ADD CONSTRAINT "$1" FOREIGN KEY (group_id) REFERENCES groups(group_id) ON DELETE CASCADE;
5320 ALTER TABLE ONLY project_task_external_order
5321 ADD CONSTRAINT "$1" FOREIGN KEY (project_task_id) REFERENCES project_task(project_task_id) MATCH FULL ON DELETE CASCADE;
5325 ALTER TABLE ONLY group_join_request
5326 ADD CONSTRAINT "$1" FOREIGN KEY (group_id) REFERENCES groups(group_id) ON DELETE CASCADE;
5330 ALTER TABLE ONLY group_join_request
5331 ADD CONSTRAINT "$2" FOREIGN KEY (user_id) REFERENCES users(user_id);
5335 ALTER TABLE ONLY artifact_type_monitor
5336 ADD CONSTRAINT "$1" FOREIGN KEY (group_artifact_id) REFERENCES artifact_group_list(group_artifact_id) ON DELETE CASCADE;
5340 ALTER TABLE ONLY artifact_type_monitor
5341 ADD CONSTRAINT "$2" FOREIGN KEY (user_id) REFERENCES users(user_id);
5345 ALTER TABLE ONLY user_group
5346 ADD CONSTRAINT usergroup_roleid FOREIGN KEY (role_id) REFERENCES role(role_id) MATCH FULL;
5350 ALTER TABLE ONLY role_setting
5351 ADD CONSTRAINT rolesetting_roleroleid FOREIGN KEY (role_id) REFERENCES role(role_id) ON DELETE CASCADE;
5355 ALTER TABLE ONLY plugin_cvstracker_data_master
5356 ADD CONSTRAINT "$1" FOREIGN KEY (holder_id) REFERENCES plugin_cvstracker_data_artifact(id);
5360 ALTER TABLE ONLY plugin_cvstracker_data_master
5361 ADD CONSTRAINT "$2" FOREIGN KEY (author) REFERENCES users(user_name);
5365 ALTER TABLE ONLY artifact_query
5366 ADD CONSTRAINT artquery_groupartid_fk FOREIGN KEY (group_artifact_id) REFERENCES artifact_group_list(group_artifact_id) ON DELETE CASCADE;
5370 ALTER TABLE ONLY artifact_query_fields
5371 ADD CONSTRAINT artqueryelmnt_artqueryid FOREIGN KEY (artifact_query_id) REFERENCES artifact_query(artifact_query_id) ON DELETE CASCADE;
5375 ALTER TABLE ONLY mail_group_list
5376 ADD CONSTRAINT mail_group_list_group_id_fkey FOREIGN KEY (group_id) REFERENCES groups(group_id) ON DELETE CASCADE;
5380 ALTER TABLE ONLY forum_attachment
5381 ADD CONSTRAINT "$1" FOREIGN KEY (msg_id) REFERENCES forum(msg_id) ON DELETE CASCADE;
5385 ALTER TABLE ONLY forum_attachment
5386 ADD CONSTRAINT "$2" FOREIGN KEY (userid) REFERENCES users(user_id) ON DELETE SET DEFAULT;
5390 ALTER TABLE ONLY forum_pending_messages
5391 ADD CONSTRAINT forum_pending_messages_group_forum_id_fkey FOREIGN KEY (group_forum_id) REFERENCES forum_group_list(group_forum_id) ON DELETE CASCADE;
5395 ALTER TABLE ONLY forum_pending_attachment
5396 ADD CONSTRAINT forum_pending_attachment_msg_id_fkey FOREIGN KEY (msg_id) REFERENCES forum_pending_messages(msg_id) ON DELETE CASCADE;
5400 ALTER TABLE ONLY forum_pending_attachment
5401 ADD CONSTRAINT forum_pending_attachment_userid_fkey FOREIGN KEY (userid) REFERENCES users(user_id) ON DELETE SET DEFAULT;
5405 ALTER TABLE ONLY group_activity_monitor
5406 ADD CONSTRAINT group_id FOREIGN KEY (group_id) REFERENCES groups(group_id) ON DELETE CASCADE;
5410 ALTER TABLE ONLY group_activity_monitor
5411 ADD CONSTRAINT userid_fk FOREIGN KEY (user_id) REFERENCES users(user_id);
5415 CREATE CONSTRAINT TRIGGER user_group_user_id_fk
5416 AFTER INSERT OR UPDATE ON user_group
5418 NOT DEFERRABLE INITIALLY IMMEDIATE
5420 EXECUTE PROCEDURE "RI_FKey_check_ins"('user_group_user_id_fk', 'user_group', 'users', 'FULL', 'user_id', 'user_id');
5424 CREATE CONSTRAINT TRIGGER user_group_user_id_fk
5425 AFTER DELETE ON users
5427 NOT DEFERRABLE INITIALLY IMMEDIATE
5429 EXECUTE PROCEDURE "RI_FKey_noaction_del"('user_group_user_id_fk', 'user_group', 'users', 'FULL', 'user_id', 'user_id');
5433 CREATE CONSTRAINT TRIGGER user_group_user_id_fk
5434 AFTER UPDATE ON users
5436 NOT DEFERRABLE INITIALLY IMMEDIATE
5438 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('user_group_user_id_fk', 'user_group', 'users', 'FULL', 'user_id', 'user_id');
5442 CREATE CONSTRAINT TRIGGER user_group_group_id_fk
5443 AFTER INSERT OR UPDATE ON user_group
5445 NOT DEFERRABLE INITIALLY IMMEDIATE
5447 EXECUTE PROCEDURE "RI_FKey_check_ins"('user_group_group_id_fk', 'user_group', 'groups', 'FULL', 'group_id', 'group_id');
5451 CREATE CONSTRAINT TRIGGER user_group_group_id_fk
5452 AFTER DELETE ON groups
5454 NOT DEFERRABLE INITIALLY IMMEDIATE
5456 EXECUTE PROCEDURE "RI_FKey_noaction_del"('user_group_group_id_fk', 'user_group', 'groups', 'FULL', 'group_id', 'group_id');
5460 CREATE CONSTRAINT TRIGGER user_group_group_id_fk
5461 AFTER UPDATE ON groups
5463 NOT DEFERRABLE INITIALLY IMMEDIATE
5465 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('user_group_group_id_fk', 'user_group', 'groups', 'FULL', 'group_id', 'group_id');
5469 CREATE CONSTRAINT TRIGGER forum_posted_by_fk
5470 AFTER INSERT OR UPDATE ON forum
5472 NOT DEFERRABLE INITIALLY IMMEDIATE
5474 EXECUTE PROCEDURE "RI_FKey_check_ins"('forum_posted_by_fk', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
5478 CREATE CONSTRAINT TRIGGER forum_posted_by_fk
5479 AFTER DELETE ON users
5481 NOT DEFERRABLE INITIALLY IMMEDIATE
5483 EXECUTE PROCEDURE "RI_FKey_noaction_del"('forum_posted_by_fk', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
5487 CREATE CONSTRAINT TRIGGER forum_posted_by_fk
5488 AFTER UPDATE ON users
5490 NOT DEFERRABLE INITIALLY IMMEDIATE
5492 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('forum_posted_by_fk', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
5496 CREATE CONSTRAINT TRIGGER forum_group_forum_id_fk
5497 AFTER INSERT OR UPDATE ON forum
5498 FROM forum_group_list
5499 NOT DEFERRABLE INITIALLY IMMEDIATE
5501 EXECUTE PROCEDURE "RI_FKey_check_ins"('forum_group_forum_id_fk', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
5505 CREATE CONSTRAINT TRIGGER forum_group_forum_id_fk
5506 AFTER DELETE ON forum_group_list
5508 NOT DEFERRABLE INITIALLY IMMEDIATE
5510 EXECUTE PROCEDURE "RI_FKey_noaction_del"('forum_group_forum_id_fk', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
5514 CREATE CONSTRAINT TRIGGER forum_group_forum_id_fk
5515 AFTER UPDATE ON forum_group_list
5517 NOT DEFERRABLE INITIALLY IMMEDIATE
5519 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('forum_group_forum_id_fk', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
5523 CREATE CONSTRAINT TRIGGER forum_group_list_group_id_fk
5524 AFTER INSERT OR UPDATE ON forum_group_list
5526 NOT DEFERRABLE INITIALLY IMMEDIATE
5528 EXECUTE PROCEDURE "RI_FKey_check_ins"('forum_group_list_group_id_fk', 'forum_group_list', 'groups', 'FULL', 'group_id', 'group_id');
5532 CREATE CONSTRAINT TRIGGER forum_group_list_group_id_fk
5533 AFTER DELETE ON groups
5534 FROM forum_group_list
5535 NOT DEFERRABLE INITIALLY IMMEDIATE
5537 EXECUTE PROCEDURE "RI_FKey_noaction_del"('forum_group_list_group_id_fk', 'forum_group_list', 'groups', 'FULL', 'group_id', 'group_id');
5541 CREATE CONSTRAINT TRIGGER forum_group_list_group_id_fk
5542 AFTER UPDATE ON groups
5543 FROM forum_group_list
5544 NOT DEFERRABLE INITIALLY IMMEDIATE
5546 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('forum_group_list_group_id_fk', 'forum_group_list', 'groups', 'FULL', 'group_id', 'group_id');
5550 CREATE CONSTRAINT TRIGGER forum_posted_by_fk
5551 AFTER INSERT OR UPDATE ON forum
5553 NOT DEFERRABLE INITIALLY IMMEDIATE
5555 EXECUTE PROCEDURE "RI_FKey_check_ins"('forum_posted_by_fk', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
5559 CREATE CONSTRAINT TRIGGER forum_posted_by_fk
5560 AFTER DELETE ON users
5562 NOT DEFERRABLE INITIALLY IMMEDIATE
5564 EXECUTE PROCEDURE "RI_FKey_noaction_del"('forum_posted_by_fk', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
5568 CREATE CONSTRAINT TRIGGER forum_posted_by_fk
5569 AFTER UPDATE ON users
5571 NOT DEFERRABLE INITIALLY IMMEDIATE
5573 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('forum_posted_by_fk', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
5577 CREATE CONSTRAINT TRIGGER forum_group_forum_id_fk
5578 AFTER INSERT OR UPDATE ON forum
5579 FROM forum_group_list
5580 NOT DEFERRABLE INITIALLY IMMEDIATE
5582 EXECUTE PROCEDURE "RI_FKey_check_ins"('forum_group_forum_id_fk', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
5586 CREATE CONSTRAINT TRIGGER forum_group_forum_id_fk
5587 AFTER DELETE ON forum_group_list
5589 NOT DEFERRABLE INITIALLY IMMEDIATE
5591 EXECUTE PROCEDURE "RI_FKey_noaction_del"('forum_group_forum_id_fk', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
5595 CREATE CONSTRAINT TRIGGER forum_group_forum_id_fk
5596 AFTER UPDATE ON forum_group_list
5598 NOT DEFERRABLE INITIALLY IMMEDIATE
5600 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('forum_group_forum_id_fk', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
5604 CREATE CONSTRAINT TRIGGER project_group_list_group_id_fk
5605 AFTER INSERT OR UPDATE ON project_group_list
5607 NOT DEFERRABLE INITIALLY IMMEDIATE
5609 EXECUTE PROCEDURE "RI_FKey_check_ins"('project_group_list_group_id_fk', 'project_group_list', 'groups', 'FULL', 'group_id', 'group_id');
5613 CREATE CONSTRAINT TRIGGER project_group_list_group_id_fk
5614 AFTER DELETE ON groups
5615 FROM project_group_list
5616 NOT DEFERRABLE INITIALLY IMMEDIATE
5618 EXECUTE PROCEDURE "RI_FKey_noaction_del"('project_group_list_group_id_fk', 'project_group_list', 'groups', 'FULL', 'group_id', 'group_id');
5622 CREATE CONSTRAINT TRIGGER project_group_list_group_id_fk
5623 AFTER UPDATE ON groups
5624 FROM project_group_list
5625 NOT DEFERRABLE INITIALLY IMMEDIATE
5627 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('project_group_list_group_id_fk', 'project_group_list', 'groups', 'FULL', 'group_id', 'group_id');
5631 CREATE CONSTRAINT TRIGGER project_task_created_by_fk
5632 AFTER INSERT OR UPDATE ON project_task
5634 NOT DEFERRABLE INITIALLY IMMEDIATE
5636 EXECUTE PROCEDURE "RI_FKey_check_ins"('project_task_created_by_fk', 'project_task', 'users', 'FULL', 'created_by', 'user_id');
5640 CREATE CONSTRAINT TRIGGER project_task_created_by_fk
5641 AFTER DELETE ON users
5643 NOT DEFERRABLE INITIALLY IMMEDIATE
5645 EXECUTE PROCEDURE "RI_FKey_noaction_del"('project_task_created_by_fk', 'project_task', 'users', 'FULL', 'created_by', 'user_id');
5649 CREATE CONSTRAINT TRIGGER project_task_created_by_fk
5650 AFTER UPDATE ON users
5652 NOT DEFERRABLE INITIALLY IMMEDIATE
5654 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('project_task_created_by_fk', 'project_task', 'users', 'FULL', 'created_by', 'user_id');
5658 CREATE CONSTRAINT TRIGGER project_task_status_id_fk
5659 AFTER INSERT OR UPDATE ON project_task
5661 NOT DEFERRABLE INITIALLY IMMEDIATE
5663 EXECUTE PROCEDURE "RI_FKey_check_ins"('project_task_status_id_fk', 'project_task', 'project_status', 'FULL', 'status_id', 'status_id');
5667 CREATE CONSTRAINT TRIGGER project_task_status_id_fk
5668 AFTER DELETE ON project_status
5670 NOT DEFERRABLE INITIALLY IMMEDIATE
5672 EXECUTE PROCEDURE "RI_FKey_noaction_del"('project_task_status_id_fk', 'project_task', 'project_status', 'FULL', 'status_id', 'status_id');
5676 CREATE CONSTRAINT TRIGGER project_task_status_id_fk
5677 AFTER UPDATE ON project_status
5679 NOT DEFERRABLE INITIALLY IMMEDIATE
5681 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('project_task_status_id_fk', 'project_task', 'project_status', 'FULL', 'status_id', 'status_id');
5685 CREATE CONSTRAINT TRIGGER users_languageid_fk
5686 AFTER INSERT OR UPDATE ON users
5687 FROM supported_languages
5688 NOT DEFERRABLE INITIALLY IMMEDIATE
5690 EXECUTE PROCEDURE "RI_FKey_check_ins"('users_languageid_fk', 'users', 'supported_languages', 'FULL', 'language', 'language_id');
5694 CREATE CONSTRAINT TRIGGER artifactmonitor_artifactid_fk
5695 AFTER INSERT OR UPDATE ON artifact_monitor
5697 NOT DEFERRABLE INITIALLY IMMEDIATE
5699 EXECUTE PROCEDURE "RI_FKey_check_ins"('artifactmonitor_artifactid_fk', 'artifact_monitor', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
5703 CREATE CONSTRAINT TRIGGER artifactmonitor_artifactid_fk
5704 AFTER DELETE ON artifact
5705 FROM artifact_monitor
5706 NOT DEFERRABLE INITIALLY IMMEDIATE
5708 EXECUTE PROCEDURE "RI_FKey_noaction_del"('artifactmonitor_artifactid_fk', 'artifact_monitor', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
5712 CREATE CONSTRAINT TRIGGER artifactmonitor_artifactid_fk
5713 AFTER UPDATE ON artifact
5714 FROM artifact_monitor
5715 NOT DEFERRABLE INITIALLY IMMEDIATE
5717 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('artifactmonitor_artifactid_fk', 'artifact_monitor', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
5721 CREATE CONSTRAINT TRIGGER artifactgroup_groupid_fk
5722 AFTER INSERT OR UPDATE ON artifact_group_list
5724 NOT DEFERRABLE INITIALLY IMMEDIATE
5726 EXECUTE PROCEDURE "RI_FKey_check_ins"('artifactgroup_groupid_fk', 'artifact_group_list', 'groups', 'FULL', 'group_id', 'group_id');
5730 CREATE CONSTRAINT TRIGGER artifactgroup_groupid_fk
5731 AFTER DELETE ON groups
5732 FROM artifact_group_list
5733 NOT DEFERRABLE INITIALLY IMMEDIATE
5735 EXECUTE PROCEDURE "RI_FKey_noaction_del"('artifactgroup_groupid_fk', 'artifact_group_list', 'groups', 'FULL', 'group_id', 'group_id');
5739 CREATE CONSTRAINT TRIGGER artifactgroup_groupid_fk
5740 AFTER UPDATE ON groups
5741 FROM artifact_group_list
5742 NOT DEFERRABLE INITIALLY IMMEDIATE
5744 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('artifactgroup_groupid_fk', 'artifact_group_list', 'groups', 'FULL', 'group_id', 'group_id');
5748 CREATE CONSTRAINT TRIGGER artifactperm_userid_fk
5749 AFTER DELETE ON users
5751 NOT DEFERRABLE INITIALLY IMMEDIATE
5753 EXECUTE PROCEDURE "RI_FKey_noaction_del"('artifactperm_userid_fk', 'artifact_perm', 'users', 'FULL', 'user_id', 'user_id');
5757 CREATE CONSTRAINT TRIGGER artifactperm_userid_fk
5758 AFTER UPDATE ON users
5760 NOT DEFERRABLE INITIALLY IMMEDIATE
5762 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('artifactperm_userid_fk', 'artifact_perm', 'users', 'FULL', 'user_id', 'user_id');
5766 CREATE CONSTRAINT TRIGGER artifactperm_groupartifactid_fk
5767 AFTER DELETE ON artifact_group_list
5769 NOT DEFERRABLE INITIALLY IMMEDIATE
5771 EXECUTE PROCEDURE "RI_FKey_noaction_del"('artifactperm_groupartifactid_fk', 'artifact_perm', 'artifact_group_list', 'FULL', 'group_artifact_id', 'group_artifact_id');
5775 CREATE CONSTRAINT TRIGGER artifactperm_groupartifactid_fk
5776 AFTER UPDATE ON artifact_group_list
5778 NOT DEFERRABLE INITIALLY IMMEDIATE
5780 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('artifactperm_groupartifactid_fk', 'artifact_perm', 'artifact_group_list', 'FULL', 'group_artifact_id', 'group_artifact_id');
5784 CREATE CONSTRAINT TRIGGER artifact_groupartifactid_fk
5785 AFTER INSERT OR UPDATE ON artifact
5786 FROM artifact_group_list
5787 NOT DEFERRABLE INITIALLY IMMEDIATE
5789 EXECUTE PROCEDURE "RI_FKey_check_ins"('artifact_groupartifactid_fk', 'artifact', 'artifact_group_list', 'FULL', 'group_artifact_id', 'group_artifact_id');
5793 CREATE CONSTRAINT TRIGGER artifact_groupartifactid_fk
5794 AFTER DELETE ON artifact_group_list
5796 NOT DEFERRABLE INITIALLY IMMEDIATE
5798 EXECUTE PROCEDURE "RI_FKey_noaction_del"('artifact_groupartifactid_fk', 'artifact', 'artifact_group_list', 'FULL', 'group_artifact_id', 'group_artifact_id');
5802 CREATE CONSTRAINT TRIGGER artifact_groupartifactid_fk
5803 AFTER UPDATE ON artifact_group_list
5805 NOT DEFERRABLE INITIALLY IMMEDIATE
5807 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('artifact_groupartifactid_fk', 'artifact', 'artifact_group_list', 'FULL', 'group_artifact_id', 'group_artifact_id');
5811 CREATE CONSTRAINT TRIGGER artifact_statusid_fk
5812 AFTER INSERT OR UPDATE ON artifact
5813 FROM artifact_status
5814 NOT DEFERRABLE INITIALLY IMMEDIATE
5816 EXECUTE PROCEDURE "RI_FKey_check_ins"('artifact_statusid_fk', 'artifact', 'artifact_status', 'FULL', 'status_id', 'id');
5820 CREATE CONSTRAINT TRIGGER artifact_statusid_fk
5821 AFTER DELETE ON artifact_status
5823 NOT DEFERRABLE INITIALLY IMMEDIATE
5825 EXECUTE PROCEDURE "RI_FKey_noaction_del"('artifact_statusid_fk', 'artifact', 'artifact_status', 'FULL', 'status_id', 'id');
5829 CREATE CONSTRAINT TRIGGER artifact_statusid_fk
5830 AFTER UPDATE ON artifact_status
5832 NOT DEFERRABLE INITIALLY IMMEDIATE
5834 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('artifact_statusid_fk', 'artifact', 'artifact_status', 'FULL', 'status_id', 'id');
5838 CREATE CONSTRAINT TRIGGER artifact_submittedby_fk
5839 AFTER INSERT OR UPDATE ON artifact
5841 NOT DEFERRABLE INITIALLY IMMEDIATE
5843 EXECUTE PROCEDURE "RI_FKey_check_ins"('artifact_submittedby_fk', 'artifact', 'users', 'FULL', 'submitted_by', 'user_id');
5847 CREATE CONSTRAINT TRIGGER artifact_submittedby_fk
5848 AFTER DELETE ON users
5850 NOT DEFERRABLE INITIALLY IMMEDIATE
5852 EXECUTE PROCEDURE "RI_FKey_noaction_del"('artifact_submittedby_fk', 'artifact', 'users', 'FULL', 'submitted_by', 'user_id');
5856 CREATE CONSTRAINT TRIGGER artifact_submittedby_fk
5857 AFTER UPDATE ON users
5859 NOT DEFERRABLE INITIALLY IMMEDIATE
5861 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('artifact_submittedby_fk', 'artifact', 'users', 'FULL', 'submitted_by', 'user_id');
5865 CREATE CONSTRAINT TRIGGER artifact_assignedto_fk
5866 AFTER INSERT OR UPDATE ON artifact
5868 NOT DEFERRABLE INITIALLY IMMEDIATE
5870 EXECUTE PROCEDURE "RI_FKey_check_ins"('artifact_assignedto_fk', 'artifact', 'users', 'FULL', 'assigned_to', 'user_id');
5874 CREATE CONSTRAINT TRIGGER artifact_assignedto_fk
5875 AFTER DELETE ON users
5877 NOT DEFERRABLE INITIALLY IMMEDIATE
5879 EXECUTE PROCEDURE "RI_FKey_noaction_del"('artifact_assignedto_fk', 'artifact', 'users', 'FULL', 'assigned_to', 'user_id');
5883 CREATE CONSTRAINT TRIGGER artifact_assignedto_fk
5884 AFTER UPDATE ON users
5886 NOT DEFERRABLE INITIALLY IMMEDIATE
5888 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('artifact_assignedto_fk', 'artifact', 'users', 'FULL', 'assigned_to', 'user_id');
5892 CREATE CONSTRAINT TRIGGER artifacthistory_artifactid_fk
5893 AFTER INSERT OR UPDATE ON artifact_history
5895 NOT DEFERRABLE INITIALLY IMMEDIATE
5897 EXECUTE PROCEDURE "RI_FKey_check_ins"('artifacthistory_artifactid_fk', 'artifact_history', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
5901 CREATE CONSTRAINT TRIGGER artifacthistory_artifactid_fk
5902 AFTER DELETE ON artifact
5903 FROM artifact_history
5904 NOT DEFERRABLE INITIALLY IMMEDIATE
5906 EXECUTE PROCEDURE "RI_FKey_noaction_del"('artifacthistory_artifactid_fk', 'artifact_history', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
5910 CREATE CONSTRAINT TRIGGER artifacthistory_artifactid_fk
5911 AFTER UPDATE ON artifact
5912 FROM artifact_history
5913 NOT DEFERRABLE INITIALLY IMMEDIATE
5915 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('artifacthistory_artifactid_fk', 'artifact_history', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
5919 CREATE CONSTRAINT TRIGGER artifacthistory_modby_fk
5920 AFTER INSERT OR UPDATE ON artifact_history
5922 NOT DEFERRABLE INITIALLY IMMEDIATE
5924 EXECUTE PROCEDURE "RI_FKey_check_ins"('artifacthistory_modby_fk', 'artifact_history', 'users', 'FULL', 'mod_by', 'user_id');
5928 CREATE CONSTRAINT TRIGGER artifacthistory_modby_fk
5929 AFTER DELETE ON users
5930 FROM artifact_history
5931 NOT DEFERRABLE INITIALLY IMMEDIATE
5933 EXECUTE PROCEDURE "RI_FKey_noaction_del"('artifacthistory_modby_fk', 'artifact_history', 'users', 'FULL', 'mod_by', 'user_id');
5937 CREATE CONSTRAINT TRIGGER artifacthistory_modby_fk
5938 AFTER UPDATE ON users
5939 FROM artifact_history
5940 NOT DEFERRABLE INITIALLY IMMEDIATE
5942 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('artifacthistory_modby_fk', 'artifact_history', 'users', 'FULL', 'mod_by', 'user_id');
5946 CREATE CONSTRAINT TRIGGER artifactfile_artifactid_fk
5947 AFTER INSERT OR UPDATE ON artifact_file
5949 NOT DEFERRABLE INITIALLY IMMEDIATE
5951 EXECUTE PROCEDURE "RI_FKey_check_ins"('artifactfile_artifactid_fk', 'artifact_file', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
5955 CREATE CONSTRAINT TRIGGER artifactfile_artifactid_fk
5956 AFTER DELETE ON artifact
5958 NOT DEFERRABLE INITIALLY IMMEDIATE
5960 EXECUTE PROCEDURE "RI_FKey_noaction_del"('artifactfile_artifactid_fk', 'artifact_file', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
5964 CREATE CONSTRAINT TRIGGER artifactfile_artifactid_fk
5965 AFTER UPDATE ON artifact
5967 NOT DEFERRABLE INITIALLY IMMEDIATE
5969 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('artifactfile_artifactid_fk', 'artifact_file', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
5973 CREATE CONSTRAINT TRIGGER artifactfile_submittedby_fk
5974 AFTER INSERT OR UPDATE ON artifact_file
5976 NOT DEFERRABLE INITIALLY IMMEDIATE
5978 EXECUTE PROCEDURE "RI_FKey_check_ins"('artifactfile_submittedby_fk', 'artifact_file', 'users', 'FULL', 'submitted_by', 'user_id');
5982 CREATE CONSTRAINT TRIGGER artifactfile_submittedby_fk
5983 AFTER DELETE ON users
5985 NOT DEFERRABLE INITIALLY IMMEDIATE
5987 EXECUTE PROCEDURE "RI_FKey_noaction_del"('artifactfile_submittedby_fk', 'artifact_file', 'users', 'FULL', 'submitted_by', 'user_id');
5991 CREATE CONSTRAINT TRIGGER artifactfile_submittedby_fk
5992 AFTER UPDATE ON users
5994 NOT DEFERRABLE INITIALLY IMMEDIATE
5996 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('artifactfile_submittedby_fk', 'artifact_file', 'users', 'FULL', 'submitted_by', 'user_id');
6000 CREATE CONSTRAINT TRIGGER artifactmessage_artifactid_fk
6001 AFTER INSERT OR UPDATE ON artifact_message
6003 NOT DEFERRABLE INITIALLY IMMEDIATE
6005 EXECUTE PROCEDURE "RI_FKey_check_ins"('artifactmessage_artifactid_fk', 'artifact_message', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
6009 CREATE CONSTRAINT TRIGGER artifactmessage_artifactid_fk
6010 AFTER DELETE ON artifact
6011 FROM artifact_message
6012 NOT DEFERRABLE INITIALLY IMMEDIATE
6014 EXECUTE PROCEDURE "RI_FKey_noaction_del"('artifactmessage_artifactid_fk', 'artifact_message', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
6018 CREATE CONSTRAINT TRIGGER artifactmessage_artifactid_fk
6019 AFTER UPDATE ON artifact
6020 FROM artifact_message
6021 NOT DEFERRABLE INITIALLY IMMEDIATE
6023 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('artifactmessage_artifactid_fk', 'artifact_message', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
6027 CREATE CONSTRAINT TRIGGER artifactmessage_submittedby_fk
6028 AFTER INSERT OR UPDATE ON artifact_message
6030 NOT DEFERRABLE INITIALLY IMMEDIATE
6032 EXECUTE PROCEDURE "RI_FKey_check_ins"('artifactmessage_submittedby_fk', 'artifact_message', 'users', 'FULL', 'submitted_by', 'user_id');
6036 CREATE CONSTRAINT TRIGGER artifactmessage_submittedby_fk
6037 AFTER DELETE ON users
6038 FROM artifact_message
6039 NOT DEFERRABLE INITIALLY IMMEDIATE
6041 EXECUTE PROCEDURE "RI_FKey_noaction_del"('artifactmessage_submittedby_fk', 'artifact_message', 'users', 'FULL', 'submitted_by', 'user_id');
6045 CREATE CONSTRAINT TRIGGER artifactmessage_submittedby_fk
6046 AFTER UPDATE ON users
6047 FROM artifact_message
6048 NOT DEFERRABLE INITIALLY IMMEDIATE
6050 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('artifactmessage_submittedby_fk', 'artifact_message', 'users', 'FULL', 'submitted_by', 'user_id');
6054 CREATE CONSTRAINT TRIGGER artifactmonitor_artifactid_fk
6055 AFTER INSERT OR UPDATE ON artifact_monitor
6057 NOT DEFERRABLE INITIALLY IMMEDIATE
6059 EXECUTE PROCEDURE "RI_FKey_check_ins"('artifactmonitor_artifactid_fk', 'artifact_monitor', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
6063 CREATE CONSTRAINT TRIGGER artifactmonitor_artifactid_fk
6064 AFTER DELETE ON artifact
6065 FROM artifact_monitor
6066 NOT DEFERRABLE INITIALLY IMMEDIATE
6068 EXECUTE PROCEDURE "RI_FKey_noaction_del"('artifactmonitor_artifactid_fk', 'artifact_monitor', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
6072 CREATE CONSTRAINT TRIGGER artifactmonitor_artifactid_fk
6073 AFTER UPDATE ON artifact
6074 FROM artifact_monitor
6075 NOT DEFERRABLE INITIALLY IMMEDIATE
6077 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('artifactmonitor_artifactid_fk', 'artifact_monitor', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
6081 CREATE TRIGGER artifactgrouplist_insert_trig
6082 AFTER INSERT ON artifact_group_list
6084 EXECUTE PROCEDURE artifactgrouplist_insert_agg();
6088 CREATE TRIGGER artifactgroup_update_trig
6089 AFTER UPDATE ON artifact
6091 EXECUTE PROCEDURE artifactgroup_update_agg();
6095 CREATE TRIGGER forumgrouplist_insert_trig
6096 AFTER INSERT ON forum_group_list
6098 EXECUTE PROCEDURE forumgrouplist_insert_agg();
6102 CREATE CONSTRAINT TRIGGER frsfile_releaseid_fk
6103 AFTER INSERT OR UPDATE ON frs_file
6105 NOT DEFERRABLE INITIALLY IMMEDIATE
6107 EXECUTE PROCEDURE "RI_FKey_check_ins"('frsfile_releaseid_fk', 'frs_file', 'frs_release', 'FULL', 'release_id', 'release_id');
6111 CREATE CONSTRAINT TRIGGER frsfile_releaseid_fk
6112 AFTER DELETE ON frs_release
6114 NOT DEFERRABLE INITIALLY IMMEDIATE
6116 EXECUTE PROCEDURE "RI_FKey_noaction_del"('frsfile_releaseid_fk', 'frs_file', 'frs_release', 'FULL', 'release_id', 'release_id');
6120 CREATE CONSTRAINT TRIGGER frsfile_releaseid_fk
6121 AFTER UPDATE ON frs_release
6123 NOT DEFERRABLE INITIALLY IMMEDIATE
6125 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('frsfile_releaseid_fk', 'frs_file', 'frs_release', 'FULL', 'release_id', 'release_id');
6129 CREATE CONSTRAINT TRIGGER frsfile_typeid_fk
6130 AFTER INSERT OR UPDATE ON frs_file
6132 NOT DEFERRABLE INITIALLY IMMEDIATE
6134 EXECUTE PROCEDURE "RI_FKey_check_ins"('frsfile_typeid_fk', 'frs_file', 'frs_filetype', 'FULL', 'type_id', 'type_id');
6138 CREATE CONSTRAINT TRIGGER frsfile_typeid_fk
6139 AFTER DELETE ON frs_filetype
6141 NOT DEFERRABLE INITIALLY IMMEDIATE
6143 EXECUTE PROCEDURE "RI_FKey_noaction_del"('frsfile_typeid_fk', 'frs_file', 'frs_filetype', 'FULL', 'type_id', 'type_id');
6147 CREATE CONSTRAINT TRIGGER frsfile_typeid_fk
6148 AFTER UPDATE ON frs_filetype
6150 NOT DEFERRABLE INITIALLY IMMEDIATE
6152 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('frsfile_typeid_fk', 'frs_file', 'frs_filetype', 'FULL', 'type_id', 'type_id');
6156 CREATE CONSTRAINT TRIGGER frsfile_processorid_fk
6157 AFTER INSERT OR UPDATE ON frs_file
6159 NOT DEFERRABLE INITIALLY IMMEDIATE
6161 EXECUTE PROCEDURE "RI_FKey_check_ins"('frsfile_processorid_fk', 'frs_file', 'frs_processor', 'FULL', 'processor_id', 'processor_id');
6165 CREATE CONSTRAINT TRIGGER frsfile_processorid_fk
6166 AFTER DELETE ON frs_processor
6168 NOT DEFERRABLE INITIALLY IMMEDIATE
6170 EXECUTE PROCEDURE "RI_FKey_noaction_del"('frsfile_processorid_fk', 'frs_file', 'frs_processor', 'FULL', 'processor_id', 'processor_id');
6174 CREATE CONSTRAINT TRIGGER frsfile_processorid_fk
6175 AFTER UPDATE ON frs_processor
6177 NOT DEFERRABLE INITIALLY IMMEDIATE
6179 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('frsfile_processorid_fk', 'frs_file', 'frs_processor', 'FULL', 'processor_id', 'processor_id');
6183 CREATE CONSTRAINT TRIGGER frspackage_groupid_fk
6184 AFTER INSERT OR UPDATE ON frs_package
6186 NOT DEFERRABLE INITIALLY IMMEDIATE
6188 EXECUTE PROCEDURE "RI_FKey_check_ins"('frspackage_groupid_fk', 'frs_package', 'groups', 'FULL', 'group_id', 'group_id');
6192 CREATE CONSTRAINT TRIGGER frspackage_groupid_fk
6193 AFTER DELETE ON groups
6195 NOT DEFERRABLE INITIALLY IMMEDIATE
6197 EXECUTE PROCEDURE "RI_FKey_noaction_del"('frspackage_groupid_fk', 'frs_package', 'groups', 'FULL', 'group_id', 'group_id');
6201 CREATE CONSTRAINT TRIGGER frspackage_groupid_fk
6202 AFTER UPDATE ON groups
6204 NOT DEFERRABLE INITIALLY IMMEDIATE
6206 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('frspackage_groupid_fk', 'frs_package', 'groups', 'FULL', 'group_id', 'group_id');
6210 CREATE CONSTRAINT TRIGGER frspackage_statusid_fk
6211 AFTER INSERT OR UPDATE ON frs_package
6213 NOT DEFERRABLE INITIALLY IMMEDIATE
6215 EXECUTE PROCEDURE "RI_FKey_check_ins"('frspackage_statusid_fk', 'frs_package', 'frs_status', 'FULL', 'status_id', 'status_id');
6219 CREATE CONSTRAINT TRIGGER frspackage_statusid_fk
6220 AFTER DELETE ON frs_status
6222 NOT DEFERRABLE INITIALLY IMMEDIATE
6224 EXECUTE PROCEDURE "RI_FKey_noaction_del"('frspackage_statusid_fk', 'frs_package', 'frs_status', 'FULL', 'status_id', 'status_id');
6228 CREATE CONSTRAINT TRIGGER frspackage_statusid_fk
6229 AFTER UPDATE ON frs_status
6231 NOT DEFERRABLE INITIALLY IMMEDIATE
6233 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('frspackage_statusid_fk', 'frs_package', 'frs_status', 'FULL', 'status_id', 'status_id');
6237 CREATE CONSTRAINT TRIGGER frsrelease_packageid_fk
6238 AFTER INSERT OR UPDATE ON frs_release
6240 NOT DEFERRABLE INITIALLY IMMEDIATE
6242 EXECUTE PROCEDURE "RI_FKey_check_ins"('frsrelease_packageid_fk', 'frs_release', 'frs_package', 'FULL', 'package_id', 'package_id');
6246 CREATE CONSTRAINT TRIGGER frsrelease_packageid_fk
6247 AFTER DELETE ON frs_package
6249 NOT DEFERRABLE INITIALLY IMMEDIATE
6251 EXECUTE PROCEDURE "RI_FKey_noaction_del"('frsrelease_packageid_fk', 'frs_release', 'frs_package', 'FULL', 'package_id', 'package_id');
6255 CREATE CONSTRAINT TRIGGER frsrelease_packageid_fk
6256 AFTER UPDATE ON frs_package
6258 NOT DEFERRABLE INITIALLY IMMEDIATE
6260 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('frsrelease_packageid_fk', 'frs_release', 'frs_package', 'FULL', 'package_id', 'package_id');
6264 CREATE CONSTRAINT TRIGGER frsrelease_statusid_fk
6265 AFTER INSERT OR UPDATE ON frs_release
6267 NOT DEFERRABLE INITIALLY IMMEDIATE
6269 EXECUTE PROCEDURE "RI_FKey_check_ins"('frsrelease_statusid_fk', 'frs_release', 'frs_status', 'FULL', 'status_id', 'status_id');
6273 CREATE CONSTRAINT TRIGGER frsrelease_statusid_fk
6274 AFTER DELETE ON frs_status
6276 NOT DEFERRABLE INITIALLY IMMEDIATE
6278 EXECUTE PROCEDURE "RI_FKey_noaction_del"('frsrelease_statusid_fk', 'frs_release', 'frs_status', 'FULL', 'status_id', 'status_id');
6282 CREATE CONSTRAINT TRIGGER frsrelease_statusid_fk
6283 AFTER UPDATE ON frs_status
6285 NOT DEFERRABLE INITIALLY IMMEDIATE
6287 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('frsrelease_statusid_fk', 'frs_release', 'frs_status', 'FULL', 'status_id', 'status_id');
6291 CREATE CONSTRAINT TRIGGER frsrelease_releasedby_fk
6292 AFTER INSERT OR UPDATE ON frs_release
6294 NOT DEFERRABLE INITIALLY IMMEDIATE
6296 EXECUTE PROCEDURE "RI_FKey_check_ins"('frsrelease_releasedby_fk', 'frs_release', 'users', 'FULL', 'released_by', 'user_id');
6300 CREATE CONSTRAINT TRIGGER frsrelease_releasedby_fk
6301 AFTER DELETE ON users
6303 NOT DEFERRABLE INITIALLY IMMEDIATE
6305 EXECUTE PROCEDURE "RI_FKey_noaction_del"('frsrelease_releasedby_fk', 'frs_release', 'users', 'FULL', 'released_by', 'user_id');
6309 CREATE CONSTRAINT TRIGGER frsrelease_releasedby_fk
6310 AFTER UPDATE ON users
6312 NOT DEFERRABLE INITIALLY IMMEDIATE
6314 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('frsrelease_releasedby_fk', 'frs_release', 'users', 'FULL', 'released_by', 'user_id');
6318 CREATE CONSTRAINT TRIGGER tgl_group_id_fk
6319 AFTER INSERT OR UPDATE ON trove_group_link
6321 NOT DEFERRABLE INITIALLY IMMEDIATE
6323 EXECUTE PROCEDURE "RI_FKey_check_ins"('tgl_group_id_fk', 'trove_group_link', 'groups', 'FULL', 'group_id', 'group_id');
6327 CREATE CONSTRAINT TRIGGER tgl_group_id_fk
6328 AFTER DELETE ON groups
6329 FROM trove_group_link
6330 NOT DEFERRABLE INITIALLY IMMEDIATE
6332 EXECUTE PROCEDURE "RI_FKey_noaction_del"('tgl_group_id_fk', 'trove_group_link', 'groups', 'FULL', 'group_id', 'group_id');
6336 CREATE CONSTRAINT TRIGGER tgl_group_id_fk
6337 AFTER UPDATE ON groups
6338 FROM trove_group_link
6339 NOT DEFERRABLE INITIALLY IMMEDIATE
6341 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('tgl_group_id_fk', 'trove_group_link', 'groups', 'FULL', 'group_id', 'group_id');
6345 CREATE CONSTRAINT TRIGGER tgl_cat_id_fk
6346 AFTER INSERT OR UPDATE ON trove_group_link
6348 NOT DEFERRABLE INITIALLY IMMEDIATE
6350 EXECUTE PROCEDURE "RI_FKey_check_ins"('tgl_cat_id_fk', 'trove_group_link', 'trove_cat', 'FULL', 'trove_cat_id', 'trove_cat_id');
6354 CREATE CONSTRAINT TRIGGER tgl_cat_id_fk
6355 AFTER DELETE ON trove_cat
6356 FROM trove_group_link
6357 NOT DEFERRABLE INITIALLY IMMEDIATE
6359 EXECUTE PROCEDURE "RI_FKey_noaction_del"('tgl_cat_id_fk', 'trove_group_link', 'trove_cat', 'FULL', 'trove_cat_id', 'trove_cat_id');
6363 CREATE CONSTRAINT TRIGGER tgl_cat_id_fk
6364 AFTER UPDATE ON trove_cat
6365 FROM trove_group_link
6366 NOT DEFERRABLE INITIALLY IMMEDIATE
6368 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('tgl_cat_id_fk', 'trove_group_link', 'trove_cat', 'FULL', 'trove_cat_id', 'trove_cat_id');
6372 CREATE CONSTRAINT TRIGGER trove_agg_cat_id_fk
6373 AFTER INSERT OR UPDATE ON trove_agg
6375 NOT DEFERRABLE INITIALLY IMMEDIATE
6377 EXECUTE PROCEDURE "RI_FKey_check_ins"('trove_agg_cat_id_fk', 'trove_agg', 'trove_cat', 'FULL', 'trove_cat_id', 'trove_cat_id');
6381 CREATE CONSTRAINT TRIGGER trove_agg_cat_id_fk
6382 AFTER DELETE ON trove_cat
6384 NOT DEFERRABLE INITIALLY IMMEDIATE
6386 EXECUTE PROCEDURE "RI_FKey_noaction_del"('trove_agg_cat_id_fk', 'trove_agg', 'trove_cat', 'FULL', 'trove_cat_id', 'trove_cat_id');
6390 CREATE CONSTRAINT TRIGGER trove_agg_cat_id_fk
6391 AFTER UPDATE ON trove_cat
6393 NOT DEFERRABLE INITIALLY IMMEDIATE
6395 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('trove_agg_cat_id_fk', 'trove_agg', 'trove_cat', 'FULL', 'trove_cat_id', 'trove_cat_id');
6399 CREATE CONSTRAINT TRIGGER trove_agg_group_id_fk
6400 AFTER INSERT OR UPDATE ON trove_agg
6402 NOT DEFERRABLE INITIALLY IMMEDIATE
6404 EXECUTE PROCEDURE "RI_FKey_check_ins"('trove_agg_group_id_fk', 'trove_agg', 'groups', 'FULL', 'group_id', 'group_id');
6408 CREATE CONSTRAINT TRIGGER trove_agg_group_id_fk
6409 AFTER DELETE ON groups
6411 NOT DEFERRABLE INITIALLY IMMEDIATE
6413 EXECUTE PROCEDURE "RI_FKey_noaction_del"('trove_agg_group_id_fk', 'trove_agg', 'groups', 'FULL', 'group_id', 'group_id');
6417 CREATE CONSTRAINT TRIGGER trove_agg_group_id_fk
6418 AFTER UPDATE ON groups
6420 NOT DEFERRABLE INITIALLY IMMEDIATE
6422 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('trove_agg_group_id_fk', 'trove_agg', 'groups', 'FULL', 'group_id', 'group_id');
6426 CREATE CONSTRAINT TRIGGER trove_treesums_cat_id_fk
6427 AFTER INSERT OR UPDATE ON trove_treesums
6429 NOT DEFERRABLE INITIALLY IMMEDIATE
6431 EXECUTE PROCEDURE "RI_FKey_check_ins"('trove_treesums_cat_id_fk', 'trove_treesums', 'trove_cat', 'FULL', 'trove_cat_id', 'trove_cat_id');
6435 CREATE CONSTRAINT TRIGGER trove_treesums_cat_id_fk
6436 AFTER DELETE ON trove_cat
6438 NOT DEFERRABLE INITIALLY IMMEDIATE
6440 EXECUTE PROCEDURE "RI_FKey_noaction_del"('trove_treesums_cat_id_fk', 'trove_treesums', 'trove_cat', 'FULL', 'trove_cat_id', 'trove_cat_id');
6444 CREATE CONSTRAINT TRIGGER trove_treesums_cat_id_fk
6445 AFTER UPDATE ON trove_cat
6447 NOT DEFERRABLE INITIALLY IMMEDIATE
6449 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('trove_treesums_cat_id_fk', 'trove_treesums', 'trove_cat', 'FULL', 'trove_cat_id', 'trove_cat_id');
6453 CREATE CONSTRAINT TRIGGER users_languageid_fk
6454 AFTER INSERT OR UPDATE ON users
6455 FROM supported_languages
6456 NOT DEFERRABLE INITIALLY IMMEDIATE
6458 EXECUTE PROCEDURE "RI_FKey_check_ins"('users_languageid_fk', 'users', 'supported_languages', 'FULL', 'language', 'language_id');
6462 CREATE CONSTRAINT TRIGGER users_languageid_fk
6463 AFTER DELETE ON supported_languages
6465 NOT DEFERRABLE INITIALLY IMMEDIATE
6467 EXECUTE PROCEDURE "RI_FKey_noaction_del"('users_languageid_fk', 'users', 'supported_languages', 'FULL', 'language', 'language_id');
6471 CREATE CONSTRAINT TRIGGER users_languageid_fk
6472 AFTER UPDATE ON supported_languages
6474 NOT DEFERRABLE INITIALLY IMMEDIATE
6476 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('users_languageid_fk', 'users', 'supported_languages', 'FULL', 'language', 'language_id');
6480 CREATE CONSTRAINT TRIGGER docdata_languageid_fk
6481 AFTER INSERT OR UPDATE ON doc_data
6482 FROM supported_languages
6483 NOT DEFERRABLE INITIALLY IMMEDIATE
6485 EXECUTE PROCEDURE "RI_FKey_check_ins"('docdata_languageid_fk', 'doc_data', 'supported_languages', 'FULL', 'language_id', 'language_id');
6489 CREATE CONSTRAINT TRIGGER docdata_languageid_fk
6490 AFTER DELETE ON supported_languages
6492 NOT DEFERRABLE INITIALLY IMMEDIATE
6494 EXECUTE PROCEDURE "RI_FKey_noaction_del"('docdata_languageid_fk', 'doc_data', 'supported_languages', 'FULL', 'language_id', 'language_id');
6498 CREATE CONSTRAINT TRIGGER docdata_languageid_fk
6499 AFTER UPDATE ON supported_languages
6501 NOT DEFERRABLE INITIALLY IMMEDIATE
6503 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('docdata_languageid_fk', 'doc_data', 'supported_languages', 'FULL', 'language_id', 'language_id');
6507 CREATE CONSTRAINT TRIGGER forumgrouplist_groupid
6508 AFTER INSERT OR UPDATE ON forum_group_list
6510 NOT DEFERRABLE INITIALLY IMMEDIATE
6512 EXECUTE PROCEDURE "RI_FKey_check_ins"('forumgrouplist_groupid', 'forum_group_list', 'groups', 'FULL', 'group_id', 'group_id');
6516 CREATE CONSTRAINT TRIGGER forumgrouplist_groupid
6517 AFTER DELETE ON groups
6518 FROM forum_group_list
6519 NOT DEFERRABLE INITIALLY IMMEDIATE
6521 EXECUTE PROCEDURE "RI_FKey_cascade_del"('forumgrouplist_groupid', 'forum_group_list', 'groups', 'FULL', 'group_id', 'group_id');
6525 CREATE CONSTRAINT TRIGGER forumgrouplist_groupid
6526 AFTER UPDATE ON groups
6527 FROM forum_group_list
6528 NOT DEFERRABLE INITIALLY IMMEDIATE
6530 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('forumgrouplist_groupid', 'forum_group_list', 'groups', 'FULL', 'group_id', 'group_id');
6534 CREATE CONSTRAINT TRIGGER forum_groupforumid
6535 AFTER INSERT OR UPDATE ON forum
6536 FROM forum_group_list
6537 NOT DEFERRABLE INITIALLY IMMEDIATE
6539 EXECUTE PROCEDURE "RI_FKey_check_ins"('forum_groupforumid', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
6543 CREATE CONSTRAINT TRIGGER forum_groupforumid
6544 AFTER DELETE ON forum_group_list
6546 NOT DEFERRABLE INITIALLY IMMEDIATE
6548 EXECUTE PROCEDURE "RI_FKey_cascade_del"('forum_groupforumid', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
6552 CREATE CONSTRAINT TRIGGER forum_groupforumid
6553 AFTER UPDATE ON forum_group_list
6555 NOT DEFERRABLE INITIALLY IMMEDIATE
6557 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('forum_groupforumid', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
6561 CREATE CONSTRAINT TRIGGER forum_userid
6562 AFTER INSERT OR UPDATE ON forum
6564 NOT DEFERRABLE INITIALLY IMMEDIATE
6566 EXECUTE PROCEDURE "RI_FKey_check_ins"('forum_userid', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
6570 CREATE CONSTRAINT TRIGGER forum_userid
6571 AFTER DELETE ON users
6573 NOT DEFERRABLE INITIALLY IMMEDIATE
6575 EXECUTE PROCEDURE "RI_FKey_noaction_del"('forum_userid', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
6579 CREATE CONSTRAINT TRIGGER forum_userid
6580 AFTER UPDATE ON users
6582 NOT DEFERRABLE INITIALLY IMMEDIATE
6584 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('forum_userid', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
6588 CREATE CONSTRAINT TRIGGER "<unnamed>"
6589 AFTER INSERT OR UPDATE ON skills_data
6591 NOT DEFERRABLE INITIALLY IMMEDIATE
6593 EXECUTE PROCEDURE "RI_FKey_check_ins"('<unnamed>', 'skills_data', 'users', 'UNSPECIFIED', 'user_id', 'user_id');
6597 CREATE CONSTRAINT TRIGGER "<unnamed>"
6598 AFTER DELETE ON users
6600 NOT DEFERRABLE INITIALLY IMMEDIATE
6602 EXECUTE PROCEDURE "RI_FKey_noaction_del"('<unnamed>', 'skills_data', 'users', 'UNSPECIFIED', 'user_id', 'user_id');
6606 CREATE CONSTRAINT TRIGGER "<unnamed>"
6607 AFTER UPDATE ON users
6609 NOT DEFERRABLE INITIALLY IMMEDIATE
6611 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('<unnamed>', 'skills_data', 'users', 'UNSPECIFIED', 'user_id', 'user_id');
6615 CREATE CONSTRAINT TRIGGER "<unnamed>"
6616 AFTER INSERT OR UPDATE ON skills_data
6617 FROM skills_data_types
6618 NOT DEFERRABLE INITIALLY IMMEDIATE
6620 EXECUTE PROCEDURE "RI_FKey_check_ins"('<unnamed>', 'skills_data', 'skills_data_types', 'UNSPECIFIED', 'type', 'type_id');
6624 CREATE CONSTRAINT TRIGGER "<unnamed>"
6625 AFTER DELETE ON skills_data_types
6627 NOT DEFERRABLE INITIALLY IMMEDIATE
6629 EXECUTE PROCEDURE "RI_FKey_noaction_del"('<unnamed>', 'skills_data', 'skills_data_types', 'UNSPECIFIED', 'type', 'type_id');
6633 CREATE CONSTRAINT TRIGGER "<unnamed>"
6634 AFTER UPDATE ON skills_data_types
6636 NOT DEFERRABLE INITIALLY IMMEDIATE
6638 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('<unnamed>', 'skills_data', 'skills_data_types', 'UNSPECIFIED', 'type', 'type_id');
6642 CREATE CONSTRAINT TRIGGER projecttask_groupprojectid_fk
6643 AFTER INSERT OR UPDATE ON project_task
6644 FROM project_group_list
6645 NOT DEFERRABLE INITIALLY IMMEDIATE
6647 EXECUTE PROCEDURE "RI_FKey_check_ins"('projecttask_groupprojectid_fk', 'project_task', 'project_group_list', 'UNSPECIFIED', 'group_project_id', 'group_project_id');
6651 CREATE CONSTRAINT TRIGGER projecttask_groupprojectid_fk
6652 AFTER DELETE ON project_group_list
6654 NOT DEFERRABLE INITIALLY IMMEDIATE
6656 EXECUTE PROCEDURE "RI_FKey_cascade_del"('projecttask_groupprojectid_fk', 'project_task', 'project_group_list', 'UNSPECIFIED', 'group_project_id', 'group_project_id');
6660 CREATE CONSTRAINT TRIGGER projecttask_groupprojectid_fk
6661 AFTER UPDATE ON project_group_list
6663 NOT DEFERRABLE INITIALLY IMMEDIATE
6665 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('projecttask_groupprojectid_fk', 'project_task', 'project_group_list', 'UNSPECIFIED', 'group_project_id', 'group_project_id');
6669 CREATE CONSTRAINT TRIGGER projcat_projgroupid_fk
6670 AFTER INSERT OR UPDATE ON project_category
6671 FROM project_group_list
6672 NOT DEFERRABLE INITIALLY IMMEDIATE
6674 EXECUTE PROCEDURE "RI_FKey_check_ins"('projcat_projgroupid_fk', 'project_category', 'project_group_list', 'UNSPECIFIED', 'group_project_id', 'group_project_id');
6678 CREATE CONSTRAINT TRIGGER projcat_projgroupid_fk
6679 AFTER DELETE ON project_group_list
6680 FROM project_category
6681 NOT DEFERRABLE INITIALLY IMMEDIATE
6683 EXECUTE PROCEDURE "RI_FKey_cascade_del"('projcat_projgroupid_fk', 'project_category', 'project_group_list', 'UNSPECIFIED', 'group_project_id', 'group_project_id');
6687 CREATE CONSTRAINT TRIGGER projcat_projgroupid_fk
6688 AFTER UPDATE ON project_group_list
6689 FROM project_category
6690 NOT DEFERRABLE INITIALLY IMMEDIATE
6692 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('projcat_projgroupid_fk', 'project_category', 'project_group_list', 'UNSPECIFIED', 'group_project_id', 'group_project_id');
6696 CREATE CONSTRAINT TRIGGER "<unnamed>"
6697 AFTER INSERT OR UPDATE ON project_task
6698 FROM project_category
6699 NOT DEFERRABLE INITIALLY IMMEDIATE
6701 EXECUTE PROCEDURE "RI_FKey_check_ins"('<unnamed>', 'project_task', 'project_category', 'UNSPECIFIED', 'category_id', 'category_id');
6705 CREATE CONSTRAINT TRIGGER "<unnamed>"
6706 AFTER DELETE ON project_category
6708 NOT DEFERRABLE INITIALLY IMMEDIATE
6710 EXECUTE PROCEDURE "RI_FKey_noaction_del"('<unnamed>', 'project_task', 'project_category', 'UNSPECIFIED', 'category_id', 'category_id');
6714 CREATE CONSTRAINT TRIGGER "<unnamed>"
6715 AFTER UPDATE ON project_category
6717 NOT DEFERRABLE INITIALLY IMMEDIATE
6719 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('<unnamed>', 'project_task', 'project_category', 'UNSPECIFIED', 'category_id', 'category_id');
6723 CREATE CONSTRAINT TRIGGER projtaskartifact_projtaskid_fk
6724 AFTER INSERT OR UPDATE ON project_task_artifact
6726 NOT DEFERRABLE INITIALLY IMMEDIATE
6728 EXECUTE PROCEDURE "RI_FKey_check_ins"('projtaskartifact_projtaskid_fk', 'project_task_artifact', 'project_task', 'UNSPECIFIED', 'project_task_id', 'project_task_id');
6732 CREATE CONSTRAINT TRIGGER projtaskartifact_projtaskid_fk
6733 AFTER DELETE ON project_task
6734 FROM project_task_artifact
6735 NOT DEFERRABLE INITIALLY IMMEDIATE
6737 EXECUTE PROCEDURE "RI_FKey_cascade_del"('projtaskartifact_projtaskid_fk', 'project_task_artifact', 'project_task', 'UNSPECIFIED', 'project_task_id', 'project_task_id');
6741 CREATE CONSTRAINT TRIGGER projtaskartifact_projtaskid_fk
6742 AFTER UPDATE ON project_task
6743 FROM project_task_artifact
6744 NOT DEFERRABLE INITIALLY IMMEDIATE
6746 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('projtaskartifact_projtaskid_fk', 'project_task_artifact', 'project_task', 'UNSPECIFIED', 'project_task_id', 'project_task_id');
6750 CREATE CONSTRAINT TRIGGER projtaskartifact_artifactid_fk
6751 AFTER INSERT OR UPDATE ON project_task_artifact
6753 NOT DEFERRABLE INITIALLY IMMEDIATE
6755 EXECUTE PROCEDURE "RI_FKey_check_ins"('projtaskartifact_artifactid_fk', 'project_task_artifact', 'artifact', 'UNSPECIFIED', 'artifact_id', 'artifact_id');
6759 CREATE CONSTRAINT TRIGGER projtaskartifact_artifactid_fk
6760 AFTER DELETE ON artifact
6761 FROM project_task_artifact
6762 NOT DEFERRABLE INITIALLY IMMEDIATE
6764 EXECUTE PROCEDURE "RI_FKey_cascade_del"('projtaskartifact_artifactid_fk', 'project_task_artifact', 'artifact', 'UNSPECIFIED', 'artifact_id', 'artifact_id');
6768 CREATE CONSTRAINT TRIGGER projtaskartifact_artifactid_fk
6769 AFTER UPDATE ON artifact
6770 FROM project_task_artifact
6771 NOT DEFERRABLE INITIALLY IMMEDIATE
6773 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('projtaskartifact_artifactid_fk', 'project_task_artifact', 'artifact', 'UNSPECIFIED', 'artifact_id', 'artifact_id');
6777 CREATE CONSTRAINT TRIGGER "<unnamed>"
6778 AFTER INSERT OR UPDATE ON project_messages
6780 NOT DEFERRABLE INITIALLY IMMEDIATE
6782 EXECUTE PROCEDURE "RI_FKey_check_ins"('<unnamed>', 'project_messages', 'project_task', 'UNSPECIFIED', 'project_task_id', 'project_task_id');
6786 CREATE CONSTRAINT TRIGGER "<unnamed>"
6787 AFTER DELETE ON project_task
6788 FROM project_messages
6789 NOT DEFERRABLE INITIALLY IMMEDIATE
6791 EXECUTE PROCEDURE "RI_FKey_cascade_del"('<unnamed>', 'project_messages', 'project_task', 'UNSPECIFIED', 'project_task_id', 'project_task_id');
6795 CREATE CONSTRAINT TRIGGER "<unnamed>"
6796 AFTER UPDATE ON project_task
6797 FROM project_messages
6798 NOT DEFERRABLE INITIALLY IMMEDIATE
6800 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('<unnamed>', 'project_messages', 'project_task', 'UNSPECIFIED', 'project_task_id', 'project_task_id');
6804 CREATE CONSTRAINT TRIGGER "<unnamed>"
6805 AFTER INSERT OR UPDATE ON project_messages
6807 NOT DEFERRABLE INITIALLY IMMEDIATE
6809 EXECUTE PROCEDURE "RI_FKey_check_ins"('<unnamed>', 'project_messages', 'users', 'UNSPECIFIED', 'posted_by', 'user_id');
6813 CREATE CONSTRAINT TRIGGER "<unnamed>"
6814 AFTER DELETE ON users
6815 FROM project_messages
6816 NOT DEFERRABLE INITIALLY IMMEDIATE
6818 EXECUTE PROCEDURE "RI_FKey_noaction_del"('<unnamed>', 'project_messages', 'users', 'UNSPECIFIED', 'posted_by', 'user_id');
6822 CREATE CONSTRAINT TRIGGER "<unnamed>"
6823 AFTER UPDATE ON users
6824 FROM project_messages
6825 NOT DEFERRABLE INITIALLY IMMEDIATE
6827 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('<unnamed>', 'project_messages', 'users', 'UNSPECIFIED', 'posted_by', 'user_id');
6831 CREATE CONSTRAINT TRIGGER docdata_groupid
6832 AFTER INSERT OR UPDATE ON doc_data
6834 NOT DEFERRABLE INITIALLY IMMEDIATE
6836 EXECUTE PROCEDURE "RI_FKey_check_ins"('docdata_groupid', 'doc_data', 'groups', 'UNSPECIFIED', 'group_id', 'group_id');
6840 CREATE CONSTRAINT TRIGGER docdata_groupid
6841 AFTER DELETE ON groups
6843 NOT DEFERRABLE INITIALLY IMMEDIATE
6845 EXECUTE PROCEDURE "RI_FKey_cascade_del"('docdata_groupid', 'doc_data', 'groups', 'UNSPECIFIED', 'group_id', 'group_id');
6849 CREATE CONSTRAINT TRIGGER docdata_groupid
6850 AFTER UPDATE ON groups
6852 NOT DEFERRABLE INITIALLY IMMEDIATE
6854 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('docdata_groupid', 'doc_data', 'groups', 'UNSPECIFIED', 'group_id', 'group_id');
6858 CREATE CONSTRAINT TRIGGER docdata_docgroupid
6859 AFTER INSERT OR UPDATE ON doc_data
6861 NOT DEFERRABLE INITIALLY IMMEDIATE
6863 EXECUTE PROCEDURE "RI_FKey_check_ins"('docdata_docgroupid', 'doc_data', 'doc_groups', 'UNSPECIFIED', 'doc_group', 'doc_group');
6867 CREATE CONSTRAINT TRIGGER docdata_docgroupid
6868 AFTER DELETE ON doc_groups
6870 NOT DEFERRABLE INITIALLY IMMEDIATE
6872 EXECUTE PROCEDURE "RI_FKey_noaction_del"('docdata_docgroupid', 'doc_data', 'doc_groups', 'UNSPECIFIED', 'doc_group', 'doc_group');
6876 CREATE CONSTRAINT TRIGGER docdata_docgroupid
6877 AFTER UPDATE ON doc_groups
6879 NOT DEFERRABLE INITIALLY IMMEDIATE
6881 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('docdata_docgroupid', 'doc_data', 'doc_groups', 'UNSPECIFIED', 'doc_group', 'doc_group');
6885 CREATE CONSTRAINT TRIGGER docdata_stateid
6886 AFTER INSERT OR UPDATE ON doc_data
6888 NOT DEFERRABLE INITIALLY IMMEDIATE
6890 EXECUTE PROCEDURE "RI_FKey_check_ins"('docdata_stateid', 'doc_data', 'doc_states', 'UNSPECIFIED', 'stateid', 'stateid');
6894 CREATE CONSTRAINT TRIGGER docdata_stateid
6895 AFTER DELETE ON doc_states
6897 NOT DEFERRABLE INITIALLY IMMEDIATE
6899 EXECUTE PROCEDURE "RI_FKey_noaction_del"('docdata_stateid', 'doc_data', 'doc_states', 'UNSPECIFIED', 'stateid', 'stateid');
6903 CREATE CONSTRAINT TRIGGER docdata_stateid
6904 AFTER UPDATE ON doc_states
6906 NOT DEFERRABLE INITIALLY IMMEDIATE
6908 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('docdata_stateid', 'doc_data', 'doc_states', 'UNSPECIFIED', 'stateid', 'stateid');
6912 CREATE CONSTRAINT TRIGGER docgroups_groupid
6913 AFTER INSERT OR UPDATE ON doc_groups
6915 NOT DEFERRABLE INITIALLY IMMEDIATE
6917 EXECUTE PROCEDURE "RI_FKey_check_ins"('docgroups_groupid', 'doc_groups', 'groups', 'UNSPECIFIED', 'group_id', 'group_id');
6921 CREATE CONSTRAINT TRIGGER docgroups_groupid
6922 AFTER DELETE ON groups
6924 NOT DEFERRABLE INITIALLY IMMEDIATE
6926 EXECUTE PROCEDURE "RI_FKey_cascade_del"('docgroups_groupid', 'doc_groups', 'groups', 'UNSPECIFIED', 'group_id', 'group_id');
6930 CREATE CONSTRAINT TRIGGER docgroups_groupid
6931 AFTER UPDATE ON groups
6933 NOT DEFERRABLE INITIALLY IMMEDIATE
6935 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('docgroups_groupid', 'doc_groups', 'groups', 'UNSPECIFIED', 'group_id', 'group_id');
6939 CREATE TRIGGER frs_file_insert_trig
6940 AFTER INSERT ON frs_file
6942 EXECUTE PROCEDURE frs_dlstats_filetotal_insert_ag();
6946 CREATE CONSTRAINT TRIGGER group_plugin_group_id_fk
6947 AFTER INSERT OR UPDATE ON group_plugin
6949 NOT DEFERRABLE INITIALLY IMMEDIATE
6951 EXECUTE PROCEDURE "RI_FKey_check_ins"('group_plugin_group_id_fk', 'group_plugin', 'groups', 'FULL', 'group_id', 'group_id');
6955 CREATE CONSTRAINT TRIGGER group_plugin_group_id_fk
6956 AFTER DELETE ON groups
6958 NOT DEFERRABLE INITIALLY IMMEDIATE
6960 EXECUTE PROCEDURE "RI_FKey_noaction_del"('group_plugin_group_id_fk', 'group_plugin', 'groups', 'FULL', 'group_id', 'group_id');
6964 CREATE CONSTRAINT TRIGGER group_plugin_group_id_fk
6965 AFTER UPDATE ON groups
6967 NOT DEFERRABLE INITIALLY IMMEDIATE
6969 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('group_plugin_group_id_fk', 'group_plugin', 'groups', 'FULL', 'group_id', 'group_id');
6973 CREATE CONSTRAINT TRIGGER group_plugin_plugin_id_fk
6974 AFTER INSERT OR UPDATE ON group_plugin
6976 NOT DEFERRABLE INITIALLY IMMEDIATE
6978 EXECUTE PROCEDURE "RI_FKey_check_ins"('group_plugin_plugin_id_fk', 'group_plugin', 'plugins', 'FULL', 'plugin_id', 'plugin_id');
6982 CREATE CONSTRAINT TRIGGER group_plugin_plugin_id_fk
6983 AFTER DELETE ON plugins
6985 NOT DEFERRABLE INITIALLY IMMEDIATE
6987 EXECUTE PROCEDURE "RI_FKey_noaction_del"('group_plugin_plugin_id_fk', 'group_plugin', 'plugins', 'FULL', 'plugin_id', 'plugin_id');
6991 CREATE CONSTRAINT TRIGGER group_plugin_plugin_id_fk
6992 AFTER UPDATE ON plugins
6994 NOT DEFERRABLE INITIALLY IMMEDIATE
6996 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('group_plugin_plugin_id_fk', 'group_plugin', 'plugins', 'FULL', 'plugin_id', 'plugin_id');
7000 CREATE CONSTRAINT TRIGGER user_plugin_user_id_fk
7001 AFTER INSERT OR UPDATE ON user_plugin
7003 NOT DEFERRABLE INITIALLY IMMEDIATE
7005 EXECUTE PROCEDURE "RI_FKey_check_ins"('user_plugin_user_id_fk', 'user_plugin', 'users', 'FULL', 'user_id', 'user_id');
7009 CREATE CONSTRAINT TRIGGER user_plugin_user_id_fk
7010 AFTER DELETE ON users
7012 NOT DEFERRABLE INITIALLY IMMEDIATE
7014 EXECUTE PROCEDURE "RI_FKey_noaction_del"('user_plugin_user_id_fk', 'user_plugin', 'users', 'FULL', 'user_id', 'user_id');
7018 CREATE CONSTRAINT TRIGGER user_plugin_user_id_fk
7019 AFTER UPDATE ON users
7021 NOT DEFERRABLE INITIALLY IMMEDIATE
7023 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('user_plugin_user_id_fk', 'user_plugin', 'users', 'FULL', 'user_id', 'user_id');
7027 CREATE CONSTRAINT TRIGGER user_plugin_plugin_id_fk
7028 AFTER INSERT OR UPDATE ON user_plugin
7030 NOT DEFERRABLE INITIALLY IMMEDIATE
7032 EXECUTE PROCEDURE "RI_FKey_check_ins"('user_plugin_plugin_id_fk', 'user_plugin', 'plugins', 'FULL', 'plugin_id', 'plugin_id');
7036 CREATE CONSTRAINT TRIGGER user_plugin_plugin_id_fk
7037 AFTER DELETE ON plugins
7039 NOT DEFERRABLE INITIALLY IMMEDIATE
7041 EXECUTE PROCEDURE "RI_FKey_noaction_del"('user_plugin_plugin_id_fk', 'user_plugin', 'plugins', 'FULL', 'plugin_id', 'plugin_id');
7045 CREATE CONSTRAINT TRIGGER user_plugin_plugin_id_fk
7046 AFTER UPDATE ON plugins
7048 NOT DEFERRABLE INITIALLY IMMEDIATE
7050 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('user_plugin_plugin_id_fk', 'user_plugin', 'plugins', 'FULL', 'plugin_id', 'plugin_id');
7054 CREATE CONSTRAINT TRIGGER users_themeid
7055 AFTER INSERT OR UPDATE ON users
7057 NOT DEFERRABLE INITIALLY IMMEDIATE
7059 EXECUTE PROCEDURE "RI_FKey_check_ins"('users_themeid', 'users', 'themes', 'FULL', 'theme_id', 'theme_id');
7063 CREATE CONSTRAINT TRIGGER users_themeid
7064 AFTER DELETE ON themes
7066 NOT DEFERRABLE INITIALLY IMMEDIATE
7068 EXECUTE PROCEDURE "RI_FKey_noaction_del"('users_themeid', 'users', 'themes', 'FULL', 'theme_id', 'theme_id');
7072 CREATE CONSTRAINT TRIGGER users_themeid
7073 AFTER UPDATE ON themes
7075 NOT DEFERRABLE INITIALLY IMMEDIATE
7077 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('users_themeid', 'users', 'themes', 'FULL', 'theme_id', 'theme_id');
7081 CREATE CONSTRAINT TRIGGER users_ccode
7082 AFTER INSERT OR UPDATE ON users
7084 NOT DEFERRABLE INITIALLY IMMEDIATE
7086 EXECUTE PROCEDURE "RI_FKey_check_ins"('users_ccode', 'users', 'country_code', 'FULL', 'ccode', 'ccode');
7090 CREATE CONSTRAINT TRIGGER users_ccode
7091 AFTER DELETE ON country_code
7093 NOT DEFERRABLE INITIALLY IMMEDIATE
7095 EXECUTE PROCEDURE "RI_FKey_noaction_del"('users_ccode', 'users', 'country_code', 'FULL', 'ccode', 'ccode');
7099 CREATE CONSTRAINT TRIGGER users_ccode
7100 AFTER UPDATE ON country_code
7102 NOT DEFERRABLE INITIALLY IMMEDIATE
7104 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('users_ccode', 'users', 'country_code', 'FULL', 'ccode', 'ccode');
7108 CREATE TRIGGER projectgrouplist_insert_trig
7109 AFTER INSERT ON project_group_list
7111 EXECUTE PROCEDURE projectgrouplist_insert_agg();
7115 CREATE TRIGGER projectgroup_update_trig
7116 AFTER UPDATE ON project_task
7118 EXECUTE PROCEDURE projectgroup_update_agg();
7122 CREATE TRIGGER artifact_update_last_modified_date
7123 BEFORE INSERT OR UPDATE ON artifact
7125 EXECUTE PROCEDURE update_last_modified_date();
7129 CREATE TRIGGER project_task_update_last_modified_date
7130 BEFORE INSERT OR UPDATE ON project_task
7132 EXECUTE PROCEDURE update_last_modified_date();
7136 CREATE TRIGGER surveys_agg_trig
7137 AFTER INSERT OR DELETE OR UPDATE ON surveys
7139 EXECUTE PROCEDURE project_sums('surv');
7143 CREATE TRIGGER mail_agg_trig
7144 AFTER INSERT OR DELETE OR UPDATE ON mail_group_list
7146 EXECUTE PROCEDURE project_sums('mail');
7150 CREATE TRIGGER fmsg_agg_trig
7151 AFTER INSERT OR DELETE OR UPDATE ON forum
7153 EXECUTE PROCEDURE project_sums('fmsg');
7157 CREATE TRIGGER fora_agg_trig
7158 AFTER INSERT OR DELETE OR UPDATE ON forum_group_list
7160 EXECUTE PROCEDURE project_sums('fora');
7164 CREATE RULE forum_insert_agg AS ON INSERT TO forum DO UPDATE forum_agg_msg_count SET count = (forum_agg_msg_count.count + 1) WHERE (forum_agg_msg_count.group_forum_id = new.group_forum_id);
7168 CREATE RULE forum_delete_agg AS ON DELETE TO forum DO UPDATE forum_agg_msg_count SET count = (forum_agg_msg_count.count - 1) WHERE (forum_agg_msg_count.group_forum_id = old.group_forum_id);
7172 CREATE RULE artifact_insert_agg AS ON INSERT TO artifact DO UPDATE artifact_counts_agg SET count = (artifact_counts_agg.count + 1), open_count = (artifact_counts_agg.open_count + 1) WHERE (artifact_counts_agg.group_artifact_id = new.group_artifact_id);
7176 CREATE RULE frs_dlstats_file_rule AS ON INSERT TO frs_dlstats_file DO UPDATE frs_dlstats_filetotal_agg SET downloads = (frs_dlstats_filetotal_agg.downloads + 1) WHERE (frs_dlstats_filetotal_agg.file_id = new.file_id);
7180 CREATE RULE projecttask_insert_agg AS ON INSERT TO project_task DO UPDATE project_counts_agg SET count = (project_counts_agg.count + 1), open_count = (project_counts_agg.open_count + 1) WHERE (project_counts_agg.group_project_id = new.group_project_id);
7184 CREATE RULE artifact_delete_agg AS ON DELETE TO artifact DO UPDATE artifact_counts_agg SET count = (artifact_counts_agg.count - 1), open_count = CASE WHEN (old.status_id = 1) THEN (artifact_counts_agg.open_count - 1) ELSE artifact_counts_agg.open_count END WHERE (artifact_counts_agg.group_artifact_id = old.group_artifact_id);
7188 CREATE RULE projecttask_delete_agg AS ON DELETE TO project_task DO UPDATE project_counts_agg SET count = (project_counts_agg.count - 1), open_count = CASE WHEN (old.status_id = 1) THEN (project_counts_agg.open_count - 1) ELSE project_counts_agg.open_count END WHERE (project_counts_agg.group_project_id = old.group_project_id);
7192 CREATE RULE groupactivity_userdelete_rule AS ON UPDATE TO users DO DELETE FROM group_activity_monitor WHERE (group_activity_monitor.user_id = CASE WHEN (new.status = 'D'::bpchar) THEN new.user_id ELSE 0 END);
7196 SELECT pg_catalog.setval('canned_responses_pk_seq', 1, false);
7200 SELECT pg_catalog.setval('db_images_pk_seq', 1, false);
7204 SELECT pg_catalog.setval('doc_data_pk_seq', 1, false);
7208 SELECT pg_catalog.setval('doc_groups_pk_seq', 1, false);
7212 SELECT pg_catalog.setval('doc_states_pk_seq', 1, false);
7216 SELECT pg_catalog.setval('filemodule_monitor_pk_seq', 1, false);
7220 SELECT pg_catalog.setval('forum_pk_seq', 1, false);
7224 SELECT pg_catalog.setval('forum_group_list_pk_seq', 1, false);
7228 SELECT pg_catalog.setval('forum_monitored_forums_pk_seq', 1, false);
7232 SELECT pg_catalog.setval('forum_saved_place_pk_seq', 1, false);
7236 SELECT pg_catalog.setval('foundry_news_pk_seq', 1, false);
7240 SELECT pg_catalog.setval('frs_file_pk_seq', 1, false);
7244 SELECT pg_catalog.setval('frs_filetype_pk_seq', 9999, true);
7248 SELECT pg_catalog.setval('frs_package_pk_seq', 1, false);
7252 SELECT pg_catalog.setval('frs_processor_pk_seq', 9999, true);
7256 SELECT pg_catalog.setval('frs_release_pk_seq', 1, false);
7260 SELECT pg_catalog.setval('frs_status_pk_seq', 3, true);
7264 SELECT pg_catalog.setval('group_history_pk_seq', 1, false);
7268 SELECT pg_catalog.setval('groups_pk_seq', 5, true);
7272 SELECT pg_catalog.setval('mail_group_list_pk_seq', 1, false);
7276 SELECT pg_catalog.setval('news_bytes_pk_seq', 1, false);
7280 SELECT pg_catalog.setval('people_job_pk_seq', 1, false);
7284 SELECT pg_catalog.setval('people_job_category_pk_seq', 7, true);
7288 SELECT pg_catalog.setval('people_job_inventory_pk_seq', 1, false);
7292 SELECT pg_catalog.setval('people_job_status_pk_seq', 1, false);
7296 SELECT pg_catalog.setval('people_skill_pk_seq', 1, false);
7300 SELECT pg_catalog.setval('people_skill_inventory_pk_seq', 1, false);
7304 SELECT pg_catalog.setval('people_skill_level_pk_seq', 5, true);
7308 SELECT pg_catalog.setval('people_skill_year_pk_seq', 5, true);
7312 SELECT pg_catalog.setval('project_assigned_to_pk_seq', 1, false);
7316 SELECT pg_catalog.setval('project_dependencies_pk_seq', 1, false);
7320 SELECT pg_catalog.setval('project_group_list_pk_seq', 1, true);
7324 SELECT pg_catalog.setval('project_history_pk_seq', 1, false);
7328 SELECT pg_catalog.setval('project_metric_pk_seq', 1, false);
7332 SELECT pg_catalog.setval('project_metric_tmp1_pk_seq', 1, false);
7336 SELECT pg_catalog.setval('project_status_pk_seq', 1, false);
7340 SELECT pg_catalog.setval('project_task_pk_seq', 1, true);
7344 SELECT pg_catalog.setval('project_weekly_metric_pk_seq', 1, false);
7348 SELECT pg_catalog.setval('snippet_pk_seq', 1, false);
7352 SELECT pg_catalog.setval('snippet_package_pk_seq', 1, false);
7356 SELECT pg_catalog.setval('snippet_package_item_pk_seq', 1, false);
7360 SELECT pg_catalog.setval('snippet_package_version_pk_seq', 1, false);
7364 SELECT pg_catalog.setval('snippet_version_pk_seq', 1, false);
7368 SELECT pg_catalog.setval('survey_question_types_pk_seq', 1, false);
7372 SELECT pg_catalog.setval('survey_questions_pk_seq', 1, false);
7376 SELECT pg_catalog.setval('surveys_pk_seq', 1, false);
7380 SELECT pg_catalog.setval('themes_pk_seq', 1, true);
7384 SELECT pg_catalog.setval('trove_cat_pk_seq', 305, true);
7388 SELECT pg_catalog.setval('trove_group_link_pk_seq', 1, false);
7392 SELECT pg_catalog.setval('trove_treesums_pk_seq', 1, false);
7396 SELECT pg_catalog.setval('user_bookmarks_pk_seq', 1, false);
7400 SELECT pg_catalog.setval('user_diary_pk_seq', 1, false);
7404 SELECT pg_catalog.setval('user_diary_monitor_pk_seq', 1, false);
7408 SELECT pg_catalog.setval('user_group_pk_seq', 1, true);
7412 SELECT pg_catalog.setval('user_metric_pk_seq', 1, false);
7416 SELECT pg_catalog.setval('user_metric0_pk_seq', 1, false);
7420 SELECT pg_catalog.setval('users_pk_seq', 101, true);
7424 SELECT pg_catalog.setval('unix_uid_seq', 1, false);
7428 SELECT pg_catalog.setval('forum_thread_seq', 1, false);
7432 SELECT pg_catalog.setval('project_metric_wee_ranking1_seq', 1, false);
7436 SELECT pg_catalog.setval('prdb_dbs_dbid_seq', 1, false);
7440 SELECT pg_catalog.setval('prweb_vhost_vhostid_seq', 1, false);
7444 SELECT pg_catalog.setval('artifact_grou_group_artifac_seq', 100, true);
7448 SELECT pg_catalog.setval('artifact_status_id_seq', 3, true);
7452 SELECT pg_catalog.setval('artifact_artifact_id_seq', 1, false);
7456 SELECT pg_catalog.setval('artifact_history_id_seq', 1, false);
7460 SELECT pg_catalog.setval('artifact_file_id_seq', 1, false);
7464 SELECT pg_catalog.setval('artifact_message_id_seq', 1, false);
7468 SELECT pg_catalog.setval('artifact_monitor_id_seq', 1, false);
7472 SELECT pg_catalog.setval('artifact_canned_response_id_seq', 1, false);
7476 SELECT pg_catalog.setval('massmail_queue_id_seq', 1, false);
7480 SELECT pg_catalog.setval('trove_treesum_trove_treesum_seq', 1, false);
7484 SELECT pg_catalog.setval('group_cvs_history_id_seq', 1, false);
7488 SELECT pg_catalog.setval('themes_theme_id_seq', 4, true);
7492 SELECT pg_catalog.setval('supported_langu_language_id_seq', 24, true);
7496 SELECT pg_catalog.setval('skills_data_pk_seq', 1, false);
7500 SELECT pg_catalog.setval('skills_data_types_pk_seq', 4, true);
7504 SELECT pg_catalog.setval('project_categor_category_id_seq', 100, true);
7508 SELECT pg_catalog.setval('project_messa_project_messa_seq', 1, false);
7512 SELECT pg_catalog.setval('plugins_pk_seq', 4, true);
7516 SELECT pg_catalog.setval('group_plugin_pk_seq', 4, true);
7520 SELECT pg_catalog.setval('user_plugin_pk_seq', 1, false);
7524 SELECT pg_catalog.setval('licenses_license_id_seq', 126, true);
7528 SELECT pg_catalog.setval('user_type_type_id_seq', 2, true);
7532 SELECT pg_catalog.setval('role_role_id_seq', 21, true);
7536 SELECT pg_catalog.setval('artifact_extra_field_elements_element_id_seq', 1, false);
7540 SELECT pg_catalog.setval('artifact_extra_field_data_data_id_seq', 1, false);
7544 SELECT pg_catalog.setval('plugin_cvstracker_artifact_seq', 1, false);
7548 SELECT pg_catalog.setval('plugin_cvstracker_master_seq', 1, false);
7552 SELECT pg_catalog.setval('artifact_query_artifact_query_id_seq', 1, false);
7556 SELECT pg_catalog.setval('artifact_extra_field_list_extra_field_id_seq', 1, false);
7560 SELECT pg_catalog.setval('form_keys_key_id_seq', 1, false);
7564 SELECT pg_catalog.setval('forum_attachment_attachmentid_seq', 1, false);
7568 SELECT pg_catalog.setval('forum_pending_messages_msg_id_seq', 1, false);
7572 SELECT pg_catalog.setval('forum_pending_attachment_attachmentid_seq', 1, false);
7576 -- COMMENT ON SCHEMA public IS 'Standard public schema';
7578 CREATE SEQUENCE rep_time_category_time_code_seq ;
7579 CREATE TABLE rep_time_category (
7580 time_code integer DEFAULT nextval('rep_time_category_time_code_seq'::text) UNIQUE,
7583 CREATE TABLE rep_time_tracking (
7585 report_date int not null,
7586 user_id int not null,
7587 project_task_id int not null,
7588 time_code int not null CONSTRAINT reptimetrk_timecode REFERENCES rep_time_category(time_code),
7589 hours float not null
7591 -- CREATE UNIQUE INDEX reptimetrk_weekusrtskcde ON
7592 -- rep_time_tracking (week,user_id,project_task_id,time_code);
7593 CREATE INDEX reptimetracking_userdate ON
7594 rep_time_tracking (user_id,week);
7596 INSERT INTO rep_time_category VALUES ('1','Coding');
7597 INSERT INTO rep_time_category VALUES ('2','Testing');
7598 INSERT INTO rep_time_category VALUES ('3','Meeting');
7599 SELECT setval('rep_time_category_time_code_seq',(SELECT max(time_code) FROM rep_time_category));
7602 CREATE TABLE rep_users_added_daily (
7603 day int not null primary key,
7604 added int not null default 0
7606 CREATE TABLE rep_users_added_weekly (
7607 week int not null primary key,
7608 added int not null default 0
7610 CREATE TABLE rep_users_added_monthly (
7611 month int not null primary key,
7612 added int not null default 0
7616 CREATE TABLE rep_users_cum_daily (
7617 day int not null primary key,
7618 total int not null default 0
7620 CREATE TABLE rep_users_cum_weekly (
7621 week int not null primary key,
7622 total int not null default 0
7624 CREATE TABLE rep_users_cum_monthly (
7625 month int not null primary key,
7626 total int not null default 0
7630 CREATE TABLE rep_groups_added_daily (
7631 day int not null primary key,
7632 added int not null default 0
7635 CREATE TABLE rep_groups_added_weekly (
7636 week int not null primary key,
7637 added int not null default 0
7640 CREATE TABLE rep_groups_added_monthly (
7641 month int not null primary key,
7642 added int not null default 0
7645 -- cumulative groups
7646 CREATE TABLE rep_groups_cum_daily (
7647 day int not null primary key,
7648 total int not null default 0
7651 CREATE TABLE rep_groups_cum_weekly (
7652 week int not null primary key,
7653 total int not null default 0
7656 CREATE TABLE rep_groups_cum_monthly (
7657 month int not null primary key,
7658 total int not null default 0
7661 -- per-user activity
7662 CREATE TABLE rep_user_act_daily (
7663 user_id int not null,
7665 tracker_opened int not null,
7666 tracker_closed int not null,
7669 cvs_commits int not null,
7670 tasks_opened int not null,
7671 tasks_closed int not null,
7672 PRIMARY KEY (user_id,day)
7675 CREATE TABLE rep_user_act_weekly (
7676 user_id int not null,
7678 tracker_opened int not null,
7679 tracker_closed int not null,
7682 cvs_commits int not null,
7683 tasks_opened int not null,
7684 tasks_closed int not null,
7685 PRIMARY KEY (user_id,week)
7688 CREATE TABLE rep_user_act_monthly (
7689 user_id int not null,
7691 tracker_opened int not null,
7692 tracker_closed int not null,
7695 cvs_commits int not null,
7696 tasks_opened int not null,
7697 tasks_closed int not null,
7698 PRIMARY KEY (user_id,month)
7701 CREATE VIEW rep_user_act_oa_vw AS
7703 sum(tracker_opened) AS tracker_opened,
7704 sum(tracker_closed) AS tracker_closed,
7705 sum(forum) AS forum,
7707 sum(cvs_commits) AS cvs_commits,
7708 sum(tasks_opened) AS tasks_opened,
7709 sum(tasks_closed) AS tasks_closed
7710 FROM rep_user_act_monthly
7713 -- per-project activity
7714 CREATE TABLE rep_group_act_daily (
7715 group_id int not null,
7717 tracker_opened int not null,
7718 tracker_closed int not null,
7721 downloads int not null,
7722 cvs_commits int not null,
7723 tasks_opened int not null,
7724 tasks_closed int not null,
7725 PRIMARY KEY (group_id,day)
7728 CREATE INDEX repgroupactdaily_day ON rep_group_act_daily(day);
7730 CREATE TABLE rep_group_act_weekly (
7731 group_id int not null,
7733 tracker_opened int not null,
7734 tracker_closed int not null,
7737 downloads int not null,
7738 cvs_commits int not null,
7739 tasks_opened int not null,
7740 tasks_closed int not null,
7741 PRIMARY KEY (group_id,week)
7744 CREATE INDEX repgroupactweekly_week ON rep_group_act_weekly(week);
7746 CREATE TABLE rep_group_act_monthly (
7747 group_id int not null,
7749 tracker_opened int not null,
7750 tracker_closed int not null,
7753 downloads int not null,
7754 cvs_commits int not null,
7755 tasks_opened int not null,
7756 tasks_closed int not null,
7757 PRIMARY KEY (group_id,month)
7760 CREATE INDEX repgroupactmonthly_month ON rep_group_act_monthly(month);
7762 CREATE VIEW rep_group_act_oa_vw AS
7764 sum(tracker_opened) AS tracker_opened,
7765 sum(tracker_closed) AS tracker_closed,
7766 sum(forum) AS forum,
7768 sum(downloads) AS downloads,
7769 sum(cvs_commits) AS cvs_commits,
7770 sum(tasks_opened) AS tasks_opened,
7771 sum(tasks_closed) AS tasks_closed
7772 FROM rep_group_act_monthly
7776 CREATE VIEW rep_site_act_daily_vw AS
7778 sum(tracker_opened) AS tracker_opened,
7779 sum(tracker_closed) AS tracker_closed,
7780 sum(forum) AS forum,
7782 sum(downloads) AS downloads,
7783 sum(cvs_commits) AS cvs_commits,
7784 sum(tasks_opened) AS tasks_opened,
7785 sum(tasks_closed) AS tasks_closed
7786 FROM rep_group_act_daily
7789 CREATE VIEW rep_site_act_weekly_vw AS
7791 sum(tracker_opened) AS tracker_opened,
7792 sum(tracker_closed) AS tracker_closed,
7793 sum(forum) AS forum,
7795 sum(downloads) AS downloads,
7796 sum(cvs_commits) AS cvs_commits,
7797 sum(tasks_opened) AS tasks_opened,
7798 sum(tasks_closed) AS tasks_closed
7799 FROM rep_group_act_weekly
7802 CREATE VIEW rep_site_act_monthly_vw AS
7804 sum(tracker_opened) AS tracker_opened,
7805 sum(tracker_closed) AS tracker_closed,
7806 sum(forum) AS forum,
7808 sum(downloads) AS downloads,
7809 sum(cvs_commits) AS cvs_commits,
7810 sum(tasks_opened) AS tasks_opened,
7811 sum(tasks_closed) AS tasks_closed
7812 FROM rep_group_act_monthly
7815 DROP VIEW "artifact_group_list_vw";
7817 ALTER TABLE "artifact_group_list" ADD COLUMN "browse_list" text;
7818 UPDATE "artifact_group_list"
7819 SET browse_list='summary,open_date,assigned_to,submitted_by';
7820 ALTER TABLE "artifact_group_list" ALTER COLUMN browse_list SET NOT NULL;
7821 ALTER TABLE "artifact_group_list" ALTER COLUMN browse_list
7822 SET DEFAULT 'summary,open_date,assigned_to,submitted_by';
7824 CREATE VIEW "artifact_group_list_vw" AS
7825 SELECT agl.group_artifact_id, agl.group_id, agl.name, agl.description,
7826 agl.is_public, agl.allow_anon, agl.email_all_updates, agl.email_address,
7827 agl.due_period, agl.submit_instructions, agl.browse_instructions,
7828 agl.browse_list, agl.datatype, agl.status_timeout, agl.custom_status_field,
7829 agl.custom_renderer, aca.count, aca.open_count
7830 FROM artifact_group_list agl
7831 LEFT JOIN artifact_counts_agg aca USING (group_artifact_id);
7832 ALTER TABLE artifact_extra_field_list ADD CONSTRAINT artifact_extra_field_list_unique UNIQUE (group_artifact_id, extra_field_id);
7834 -- Table: artifact_workflow_event
7836 CREATE SEQUENCE artifact_workflow_event_id_seq
7842 -- ALTER TABLE artifact_workflow_event_id_seq OWNER TO gforge;
7844 CREATE TABLE artifact_workflow_event
7846 event_id integer NOT NULL DEFAULT nextval('"artifact_workflow_event_id_seq"'::text),
7847 group_artifact_id integer NOT NULL,
7848 field_id integer NOT NULL,
7849 from_value_id integer NOT NULL,
7850 to_value_id integer NOT NULL,
7851 CONSTRAINT artifact_workflow_event_pkey PRIMARY KEY (event_id),
7852 CONSTRAINT artifact_workflow_event_group_artifact_id_fkey FOREIGN KEY (group_artifact_id, field_id)
7853 REFERENCES artifact_extra_field_list (group_artifact_id, extra_field_id) MATCH SIMPLE
7854 ON UPDATE NO ACTION ON DELETE CASCADE
7857 -- ALTER TABLE artifact_workflow_event OWNER TO gforge;
7859 -- Index: artifact_workflow_event_index
7861 CREATE INDEX artifact_workflow_event_index
7862 ON artifact_workflow_event
7864 (event_id, group_artifact_id, field_id);
7868 -- Table: artifact_workflow_roles
7870 CREATE TABLE artifact_workflow_roles
7872 event_id integer NOT NULL,
7873 role_id integer NOT NULL,
7874 CONSTRAINT artifact_workflow_roles_pkey PRIMARY KEY (event_id, role_id),
7875 CONSTRAINT artifact_workflow_roles_event_id_fkey FOREIGN KEY (event_id)
7876 REFERENCES artifact_workflow_event (event_id) MATCH SIMPLE
7877 ON UPDATE NO ACTION ON DELETE CASCADE
7880 -- ALTER TABLE artifact_workflow_roles OWNER TO gforge;
7883 -- Table: artifact_workflow_notify
7885 CREATE TABLE artifact_workflow_notify
7887 event_id integer NOT NULL,
7888 role_id integer NOT NULL,
7889 CONSTRAINT artifact_workflow_notify_pkey PRIMARY KEY (event_id, role_id),
7890 CONSTRAINT artifact_workflow_notify_event_id_fkey FOREIGN KEY (event_id)
7891 REFERENCES artifact_workflow_event (event_id) MATCH SIMPLE
7892 ON UPDATE NO ACTION ON DELETE CASCADE
7895 -- ALTER TABLE artifact_workflow_notify OWNER TO gforge;
7899 -- Name: database_changes; Type: TABLE; Schema: public; Owner: gforge; Tablespace:
7902 CREATE TABLE database_changes (
7907 ALTER TABLE public.database_changes OWNER TO gforge;
7910 -- Name: database_startpoint; Type: TABLE; Schema: public; Owner: gforge; Tablespace:
7913 CREATE TABLE database_startpoint (
7914 db_version character varying(10),
7915 db_start_date integer
7919 ALTER TABLE public.database_startpoint OWNER TO gforge;
7922 -- Data for Name: database_startpoint; Type: TABLE DATA; Schema: public; Owner: gforge
7925 COPY database_startpoint (db_version, db_start_date) FROM stdin;