2 SET client_encoding = 'SQL_ASCII';
3 SET check_function_bodies = false;
5 SET search_path = public, pg_catalog;
8 CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler
9 AS '$libdir/plpgsql', 'plpgsql_call_handler'
14 CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER plpgsql_call_handler;
18 REVOKE ALL ON SCHEMA public FROM PUBLIC;
19 GRANT ALL ON SCHEMA public TO PUBLIC;
23 CREATE SEQUENCE canned_responses_pk_seq
32 CREATE TABLE canned_responses (
33 response_id integer DEFAULT nextval('canned_responses_pk_seq'::text) NOT NULL,
34 response_title character varying(25),
40 CREATE SEQUENCE db_images_pk_seq
49 CREATE TABLE db_images (
50 id integer DEFAULT nextval('db_images_pk_seq'::text) NOT NULL,
51 group_id integer DEFAULT 0 NOT NULL,
52 description text DEFAULT ''::text NOT NULL,
53 bin_data text DEFAULT ''::text NOT NULL,
54 filename text DEFAULT ''::text NOT NULL,
55 filesize integer DEFAULT 0 NOT NULL,
56 filetype text DEFAULT ''::text NOT NULL,
57 width integer DEFAULT 0 NOT NULL,
58 height integer DEFAULT 0 NOT NULL,
65 CREATE SEQUENCE doc_data_pk_seq
74 CREATE TABLE doc_data (
75 docid integer DEFAULT nextval('doc_data_pk_seq'::text) NOT NULL,
76 stateid integer DEFAULT 0 NOT NULL,
77 title character varying(255) DEFAULT ''::character varying NOT NULL,
78 data text DEFAULT ''::text NOT NULL,
79 updatedate integer DEFAULT 0 NOT NULL,
80 createdate integer DEFAULT 0 NOT NULL,
81 created_by integer DEFAULT 0 NOT NULL,
82 doc_group integer DEFAULT 0 NOT NULL,
84 language_id integer DEFAULT 1 NOT NULL,
88 filesize integer DEFAULT 0 NOT NULL
93 CREATE SEQUENCE doc_groups_pk_seq
102 CREATE TABLE doc_groups (
103 doc_group integer DEFAULT nextval('doc_groups_pk_seq'::text) NOT NULL,
104 groupname character varying(255) DEFAULT ''::character varying NOT NULL,
105 group_id integer DEFAULT 0 NOT NULL,
106 parent_doc_group integer DEFAULT 0 NOT NULL
111 CREATE SEQUENCE doc_states_pk_seq
120 CREATE TABLE doc_states (
121 stateid integer DEFAULT nextval('doc_states_pk_seq'::text) NOT NULL,
122 name character varying(255) DEFAULT ''::character varying NOT NULL
127 CREATE SEQUENCE filemodule_monitor_pk_seq
136 CREATE TABLE filemodule_monitor (
137 id integer DEFAULT nextval('filemodule_monitor_pk_seq'::text) NOT NULL,
138 filemodule_id integer DEFAULT 0 NOT NULL,
139 user_id integer DEFAULT 0 NOT NULL
144 CREATE SEQUENCE forum_pk_seq
154 msg_id integer DEFAULT nextval('forum_pk_seq'::text) NOT NULL,
155 group_forum_id integer DEFAULT 0 NOT NULL,
156 posted_by integer DEFAULT 0 NOT NULL,
157 subject text DEFAULT ''::text NOT NULL,
158 body text DEFAULT ''::text NOT NULL,
159 post_date integer DEFAULT 0 NOT NULL,
160 is_followup_to integer DEFAULT 0 NOT NULL,
161 thread_id integer DEFAULT 0 NOT NULL,
162 has_followups integer DEFAULT 0,
163 most_recent_date integer DEFAULT 0 NOT NULL
168 CREATE TABLE forum_agg_msg_count (
169 group_forum_id integer DEFAULT 0 NOT NULL,
170 count integer DEFAULT 0 NOT NULL
175 CREATE SEQUENCE forum_group_list_pk_seq
184 CREATE TABLE forum_group_list (
185 group_forum_id integer DEFAULT nextval('forum_group_list_pk_seq'::text) NOT NULL,
186 group_id integer DEFAULT 0 NOT NULL,
187 forum_name text DEFAULT ''::text NOT NULL,
188 is_public integer DEFAULT 0 NOT NULL,
190 allow_anonymous integer DEFAULT 0 NOT NULL,
191 send_all_posts_to text,
192 moderation_level integer DEFAULT 0
197 CREATE SEQUENCE forum_monitored_forums_pk_seq
206 CREATE TABLE forum_monitored_forums (
207 monitor_id integer DEFAULT nextval('forum_monitored_forums_pk_seq'::text) NOT NULL,
208 forum_id integer DEFAULT 0 NOT NULL,
209 user_id integer DEFAULT 0 NOT NULL
214 CREATE SEQUENCE forum_saved_place_pk_seq
223 CREATE TABLE forum_saved_place (
224 saved_place_id integer DEFAULT nextval('forum_saved_place_pk_seq'::text) NOT NULL,
225 user_id integer DEFAULT 0 NOT NULL,
226 forum_id integer DEFAULT 0 NOT NULL,
227 save_date integer DEFAULT 0 NOT NULL
232 CREATE SEQUENCE foundry_news_pk_seq
241 CREATE SEQUENCE frs_file_pk_seq
250 CREATE TABLE frs_file (
251 file_id integer DEFAULT nextval('frs_file_pk_seq'::text) NOT NULL,
253 release_id integer DEFAULT 0 NOT NULL,
254 type_id integer DEFAULT 0 NOT NULL,
255 processor_id integer DEFAULT 0 NOT NULL,
256 release_time integer DEFAULT 0 NOT NULL,
257 file_size integer DEFAULT 0 NOT NULL,
258 post_date integer DEFAULT 0 NOT NULL
263 CREATE SEQUENCE frs_filetype_pk_seq
271 CREATE TABLE frs_filetype (
272 type_id integer DEFAULT nextval('frs_filetype_pk_seq'::text) NOT NULL,
278 CREATE SEQUENCE frs_package_pk_seq
287 CREATE TABLE frs_package (
288 package_id integer DEFAULT nextval('frs_package_pk_seq'::text) NOT NULL,
289 group_id integer DEFAULT 0 NOT NULL,
291 status_id integer DEFAULT 0 NOT NULL,
292 is_public integer DEFAULT 1
297 CREATE SEQUENCE frs_processor_pk_seq
305 CREATE TABLE frs_processor (
306 processor_id integer DEFAULT nextval('frs_processor_pk_seq'::text) NOT NULL,
312 CREATE SEQUENCE frs_release_pk_seq
321 CREATE TABLE frs_release (
322 release_id integer DEFAULT nextval('frs_release_pk_seq'::text) NOT NULL,
323 package_id integer DEFAULT 0 NOT NULL,
327 status_id integer DEFAULT 0 NOT NULL,
328 preformatted integer DEFAULT 0 NOT NULL,
329 release_date integer DEFAULT 0 NOT NULL,
330 released_by integer DEFAULT 0 NOT NULL
335 CREATE SEQUENCE frs_status_pk_seq
343 CREATE TABLE frs_status (
344 status_id integer DEFAULT nextval('frs_status_pk_seq'::text) NOT NULL,
350 CREATE SEQUENCE group_history_pk_seq
359 CREATE TABLE group_history (
360 group_history_id integer DEFAULT nextval('group_history_pk_seq'::text) NOT NULL,
361 group_id integer DEFAULT 0 NOT NULL,
362 field_name text DEFAULT ''::text NOT NULL,
363 old_value text DEFAULT ''::text NOT NULL,
364 mod_by integer DEFAULT 0 NOT NULL,
370 CREATE SEQUENCE groups_pk_seq
378 CREATE TABLE groups (
379 group_id integer DEFAULT nextval('groups_pk_seq'::text) NOT NULL,
380 group_name character varying(40),
381 homepage character varying(128),
382 is_public integer DEFAULT 0 NOT NULL,
383 status character(1) DEFAULT 'A'::bpchar NOT NULL,
384 unix_group_name character varying(30) DEFAULT ''::character varying NOT NULL,
385 unix_box character varying(20) DEFAULT 'shell1'::character varying NOT NULL,
386 http_domain character varying(80),
387 short_description character varying(255),
388 register_purpose text,
390 register_time integer DEFAULT 0 NOT NULL,
392 use_mail integer DEFAULT 1 NOT NULL,
393 use_survey integer DEFAULT 1 NOT NULL,
394 use_forum integer DEFAULT 1 NOT NULL,
395 use_pm integer DEFAULT 1 NOT NULL,
396 use_scm integer DEFAULT 1 NOT NULL,
397 use_news integer DEFAULT 1 NOT NULL,
398 type_id integer DEFAULT 1 NOT NULL,
399 use_docman integer DEFAULT 1 NOT NULL,
400 new_doc_address text DEFAULT ''::text NOT NULL,
401 send_all_docs integer DEFAULT 0 NOT NULL,
402 use_pm_depend_box integer DEFAULT 1 NOT NULL,
403 use_ftp integer DEFAULT 1,
404 use_tracker integer DEFAULT 1,
405 use_frs integer DEFAULT 1,
406 use_stats integer DEFAULT 1,
407 enable_pserver integer DEFAULT 1,
408 enable_anonscm integer DEFAULT 1,
409 license integer DEFAULT 100,
415 CREATE SEQUENCE mail_group_list_pk_seq
424 CREATE TABLE mail_group_list (
425 group_list_id integer DEFAULT nextval('mail_group_list_pk_seq'::text) NOT NULL,
426 group_id integer DEFAULT 0 NOT NULL,
428 is_public integer DEFAULT 0 NOT NULL,
429 "password" character varying(16),
430 list_admin integer DEFAULT 0 NOT NULL,
431 status integer DEFAULT 0 NOT NULL,
437 CREATE SEQUENCE news_bytes_pk_seq
446 CREATE TABLE news_bytes (
447 id integer DEFAULT nextval('news_bytes_pk_seq'::text) NOT NULL,
448 group_id integer DEFAULT 0 NOT NULL,
449 submitted_by integer DEFAULT 0 NOT NULL,
450 is_approved integer DEFAULT 0 NOT NULL,
451 post_date integer DEFAULT 0 NOT NULL,
452 forum_id integer DEFAULT 0 NOT NULL,
459 CREATE SEQUENCE people_job_pk_seq
468 CREATE TABLE people_job (
469 job_id integer DEFAULT nextval('people_job_pk_seq'::text) NOT NULL,
470 group_id integer DEFAULT 0 NOT NULL,
471 created_by integer DEFAULT 0 NOT NULL,
474 post_date integer DEFAULT 0 NOT NULL,
475 status_id integer DEFAULT 0 NOT NULL,
476 category_id integer DEFAULT 0 NOT NULL
481 CREATE SEQUENCE people_job_category_pk_seq
489 CREATE TABLE people_job_category (
490 category_id integer DEFAULT nextval('people_job_category_pk_seq'::text) NOT NULL,
492 private_flag integer DEFAULT 0 NOT NULL
497 CREATE SEQUENCE people_job_inventory_pk_seq
506 CREATE TABLE people_job_inventory (
507 job_inventory_id integer DEFAULT nextval('people_job_inventory_pk_seq'::text) NOT NULL,
508 job_id integer DEFAULT 0 NOT NULL,
509 skill_id integer DEFAULT 0 NOT NULL,
510 skill_level_id integer DEFAULT 0 NOT NULL,
511 skill_year_id integer DEFAULT 0 NOT NULL
516 CREATE SEQUENCE people_job_status_pk_seq
525 CREATE TABLE people_job_status (
526 status_id integer DEFAULT nextval('people_job_status_pk_seq'::text) NOT NULL,
532 CREATE SEQUENCE people_skill_pk_seq
541 CREATE TABLE people_skill (
542 skill_id integer DEFAULT nextval('people_skill_pk_seq'::text) NOT NULL,
548 CREATE SEQUENCE people_skill_inventory_pk_seq
557 CREATE TABLE people_skill_inventory (
558 skill_inventory_id integer DEFAULT nextval('people_skill_inventory_pk_seq'::text) NOT NULL,
559 user_id integer DEFAULT 0 NOT NULL,
560 skill_id integer DEFAULT 0 NOT NULL,
561 skill_level_id integer DEFAULT 0 NOT NULL,
562 skill_year_id integer DEFAULT 0 NOT NULL
567 CREATE SEQUENCE people_skill_level_pk_seq
575 CREATE TABLE people_skill_level (
576 skill_level_id integer DEFAULT nextval('people_skill_level_pk_seq'::text) NOT NULL,
582 CREATE SEQUENCE people_skill_year_pk_seq
590 CREATE TABLE people_skill_year (
591 skill_year_id integer DEFAULT nextval('people_skill_year_pk_seq'::text) NOT NULL,
597 CREATE SEQUENCE project_assigned_to_pk_seq
606 CREATE TABLE project_assigned_to (
607 project_assigned_id integer DEFAULT nextval('project_assigned_to_pk_seq'::text) NOT NULL,
608 project_task_id integer DEFAULT 0 NOT NULL,
609 assigned_to_id integer DEFAULT 0 NOT NULL
614 CREATE SEQUENCE project_dependencies_pk_seq
623 CREATE TABLE project_dependencies (
624 project_depend_id integer DEFAULT nextval('project_dependencies_pk_seq'::text) NOT NULL,
625 project_task_id integer DEFAULT 0 NOT NULL,
626 is_dependent_on_task_id integer DEFAULT 0 NOT NULL,
627 link_type character(2) DEFAULT 'FS'::bpchar
632 CREATE SEQUENCE project_group_list_pk_seq
640 CREATE TABLE project_group_list (
641 group_project_id integer DEFAULT nextval('project_group_list_pk_seq'::text) NOT NULL,
642 group_id integer DEFAULT 0 NOT NULL,
643 project_name text DEFAULT ''::text NOT NULL,
644 is_public integer DEFAULT 0 NOT NULL,
646 send_all_posts_to text
651 CREATE SEQUENCE project_history_pk_seq
660 CREATE TABLE project_history (
661 project_history_id integer DEFAULT nextval('project_history_pk_seq'::text) NOT NULL,
662 project_task_id integer DEFAULT 0 NOT NULL,
663 field_name text DEFAULT ''::text NOT NULL,
664 old_value text DEFAULT ''::text NOT NULL,
665 mod_by integer DEFAULT 0 NOT NULL,
666 mod_date integer DEFAULT 0 NOT NULL
671 CREATE SEQUENCE project_metric_pk_seq
680 CREATE TABLE project_metric (
681 ranking integer DEFAULT nextval('project_metric_pk_seq'::text) NOT NULL,
682 percentile double precision,
683 group_id integer DEFAULT 0 NOT NULL
688 CREATE SEQUENCE project_metric_tmp1_pk_seq
697 CREATE TABLE project_metric_tmp1 (
698 ranking integer DEFAULT nextval('project_metric_tmp1_pk_seq'::text) NOT NULL,
699 group_id integer DEFAULT 0 NOT NULL,
700 value double precision
705 CREATE SEQUENCE project_status_pk_seq
714 CREATE TABLE project_status (
715 status_id integer DEFAULT nextval('project_status_pk_seq'::text) NOT NULL,
716 status_name text DEFAULT ''::text NOT NULL
721 CREATE SEQUENCE project_task_pk_seq
729 CREATE TABLE project_task (
730 project_task_id integer DEFAULT nextval('project_task_pk_seq'::text) NOT NULL,
731 group_project_id integer DEFAULT 0 NOT NULL,
732 summary text DEFAULT ''::text NOT NULL,
733 details text DEFAULT ''::text NOT NULL,
734 percent_complete integer DEFAULT 0 NOT NULL,
735 priority integer DEFAULT 3 NOT NULL,
736 hours double precision DEFAULT (0)::double precision NOT NULL,
737 start_date integer DEFAULT 0 NOT NULL,
738 end_date integer DEFAULT 0 NOT NULL,
739 created_by integer DEFAULT 0 NOT NULL,
740 status_id integer DEFAULT 0 NOT NULL,
742 duration integer DEFAULT 0,
743 parent_id integer DEFAULT 0,
744 last_modified_date integer
749 CREATE SEQUENCE project_weekly_metric_pk_seq
758 CREATE TABLE project_weekly_metric (
759 ranking integer DEFAULT nextval('project_weekly_metric_pk_seq'::text) NOT NULL,
760 percentile double precision,
761 group_id integer DEFAULT 0 NOT NULL
766 CREATE TABLE user_session (
767 user_id integer DEFAULT 0 NOT NULL,
768 session_hash character(32) DEFAULT ''::bpchar NOT NULL,
769 ip_addr character(15) DEFAULT ''::bpchar NOT NULL,
770 "time" integer DEFAULT 0 NOT NULL
775 CREATE SEQUENCE snippet_pk_seq
784 CREATE TABLE snippet (
785 snippet_id integer DEFAULT nextval('snippet_pk_seq'::text) NOT NULL,
786 created_by integer DEFAULT 0 NOT NULL,
789 "type" integer DEFAULT 0 NOT NULL,
790 "language" integer DEFAULT 0 NOT NULL,
791 license text DEFAULT ''::text NOT NULL,
792 category integer DEFAULT 0 NOT NULL
797 CREATE SEQUENCE snippet_package_pk_seq
806 CREATE TABLE snippet_package (
807 snippet_package_id integer DEFAULT nextval('snippet_package_pk_seq'::text) NOT NULL,
808 created_by integer DEFAULT 0 NOT NULL,
811 category integer DEFAULT 0 NOT NULL,
812 "language" integer DEFAULT 0 NOT NULL
817 CREATE SEQUENCE snippet_package_item_pk_seq
826 CREATE TABLE snippet_package_item (
827 snippet_package_item_id integer DEFAULT nextval('snippet_package_item_pk_seq'::text) NOT NULL,
828 snippet_package_version_id integer DEFAULT 0 NOT NULL,
829 snippet_version_id integer DEFAULT 0 NOT NULL
834 CREATE SEQUENCE snippet_package_version_pk_seq
843 CREATE TABLE snippet_package_version (
844 snippet_package_version_id integer DEFAULT nextval('snippet_package_version_pk_seq'::text) NOT NULL,
845 snippet_package_id integer DEFAULT 0 NOT NULL,
848 submitted_by integer DEFAULT 0 NOT NULL,
849 post_date integer DEFAULT 0 NOT NULL
854 CREATE SEQUENCE snippet_version_pk_seq
863 CREATE TABLE snippet_version (
864 snippet_version_id integer DEFAULT nextval('snippet_version_pk_seq'::text) NOT NULL,
865 snippet_id integer DEFAULT 0 NOT NULL,
868 submitted_by integer DEFAULT 0 NOT NULL,
869 post_date integer DEFAULT 0 NOT NULL,
875 CREATE TABLE stats_agg_logo_by_day (
882 CREATE TABLE stats_agg_pages_by_day (
883 "day" integer DEFAULT 0 NOT NULL,
884 count integer DEFAULT 0 NOT NULL
889 CREATE SEQUENCE survey_question_types_pk_seq
898 CREATE TABLE survey_question_types (
899 id integer DEFAULT nextval('survey_question_types_pk_seq'::text) NOT NULL,
900 "type" text DEFAULT ''::text NOT NULL
905 CREATE SEQUENCE survey_questions_pk_seq
914 CREATE TABLE survey_questions (
915 question_id integer DEFAULT nextval('survey_questions_pk_seq'::text) NOT NULL,
916 group_id integer DEFAULT 0 NOT NULL,
917 question text DEFAULT ''::text NOT NULL,
918 question_type integer DEFAULT 0 NOT NULL
923 CREATE TABLE survey_rating_aggregate (
924 "type" integer DEFAULT 0 NOT NULL,
925 id integer DEFAULT 0 NOT NULL,
926 response double precision DEFAULT (0)::double precision NOT NULL,
927 count integer DEFAULT 0 NOT NULL
932 CREATE TABLE survey_rating_response (
933 user_id integer DEFAULT 0 NOT NULL,
934 "type" integer DEFAULT 0 NOT NULL,
935 id integer DEFAULT 0 NOT NULL,
936 response integer DEFAULT 0 NOT NULL,
937 post_date integer DEFAULT 0 NOT NULL
942 CREATE TABLE survey_responses (
943 user_id integer DEFAULT 0 NOT NULL,
944 group_id integer DEFAULT 0 NOT NULL,
945 survey_id integer DEFAULT 0 NOT NULL,
946 question_id integer DEFAULT 0 NOT NULL,
947 response text DEFAULT ''::text NOT NULL,
948 post_date integer DEFAULT 0 NOT NULL
953 CREATE SEQUENCE surveys_pk_seq
962 CREATE TABLE surveys (
963 survey_id integer DEFAULT nextval('surveys_pk_seq'::text) NOT NULL,
964 group_id integer DEFAULT 0 NOT NULL,
965 survey_title text DEFAULT ''::text NOT NULL,
966 survey_questions text DEFAULT ''::text NOT NULL,
967 is_active integer DEFAULT 1 NOT NULL
972 CREATE SEQUENCE themes_pk_seq
980 CREATE SEQUENCE trove_cat_pk_seq
988 CREATE TABLE trove_cat (
989 trove_cat_id integer DEFAULT nextval('trove_cat_pk_seq'::text) NOT NULL,
990 "version" integer DEFAULT 0 NOT NULL,
991 parent integer DEFAULT 0 NOT NULL,
992 root_parent integer DEFAULT 0 NOT NULL,
993 shortname character varying(80),
994 fullname character varying(80),
995 description character varying(255),
996 count_subcat integer DEFAULT 0 NOT NULL,
997 count_subproj integer DEFAULT 0 NOT NULL,
998 fullpath text DEFAULT ''::text NOT NULL,
1004 CREATE SEQUENCE trove_group_link_pk_seq
1013 CREATE TABLE trove_group_link (
1014 trove_group_id integer DEFAULT nextval('trove_group_link_pk_seq'::text) NOT NULL,
1015 trove_cat_id integer DEFAULT 0 NOT NULL,
1016 trove_cat_version integer DEFAULT 0 NOT NULL,
1017 group_id integer DEFAULT 0 NOT NULL,
1018 trove_cat_root integer DEFAULT 0 NOT NULL
1023 CREATE SEQUENCE trove_treesums_pk_seq
1032 CREATE SEQUENCE user_bookmarks_pk_seq
1041 CREATE TABLE user_bookmarks (
1042 bookmark_id integer DEFAULT nextval('user_bookmarks_pk_seq'::text) NOT NULL,
1043 user_id integer DEFAULT 0 NOT NULL,
1050 CREATE SEQUENCE user_diary_pk_seq
1059 CREATE TABLE user_diary (
1060 id integer DEFAULT nextval('user_diary_pk_seq'::text) NOT NULL,
1061 user_id integer DEFAULT 0 NOT NULL,
1062 date_posted integer DEFAULT 0 NOT NULL,
1065 is_public integer DEFAULT 0 NOT NULL
1070 CREATE SEQUENCE user_diary_monitor_pk_seq
1079 CREATE TABLE user_diary_monitor (
1080 monitor_id integer DEFAULT nextval('user_diary_monitor_pk_seq'::text) NOT NULL,
1081 monitored_user integer DEFAULT 0 NOT NULL,
1082 user_id integer DEFAULT 0 NOT NULL
1087 CREATE SEQUENCE user_group_pk_seq
1095 CREATE TABLE user_group (
1096 user_group_id integer DEFAULT nextval('user_group_pk_seq'::text) NOT NULL,
1097 user_id integer DEFAULT 0 NOT NULL,
1098 group_id integer DEFAULT 0 NOT NULL,
1099 admin_flags character(16) DEFAULT ''::bpchar NOT NULL,
1100 forum_flags integer DEFAULT 0 NOT NULL,
1101 project_flags integer DEFAULT 2 NOT NULL,
1102 doc_flags integer DEFAULT 0 NOT NULL,
1103 cvs_flags integer DEFAULT 1 NOT NULL,
1104 member_role integer DEFAULT 100 NOT NULL,
1105 release_flags integer DEFAULT 0 NOT NULL,
1106 artifact_flags integer,
1107 role_id integer DEFAULT 1
1112 CREATE SEQUENCE user_metric_pk_seq
1121 CREATE TABLE user_metric (
1122 ranking integer DEFAULT nextval('user_metric_pk_seq'::text) NOT NULL,
1123 user_id integer DEFAULT 0 NOT NULL,
1124 times_ranked integer DEFAULT 0 NOT NULL,
1125 avg_raters_importance double precision DEFAULT (0)::double precision NOT NULL,
1126 avg_rating double precision DEFAULT (0)::double precision NOT NULL,
1127 metric double precision DEFAULT (0)::double precision NOT NULL,
1128 percentile double precision DEFAULT (0)::double precision NOT NULL,
1129 importance_factor double precision DEFAULT (0)::double precision NOT NULL
1134 CREATE SEQUENCE user_metric0_pk_seq
1143 CREATE TABLE user_metric0 (
1144 ranking integer DEFAULT nextval('user_metric0_pk_seq'::text) NOT NULL,
1145 user_id integer DEFAULT 0 NOT NULL,
1146 times_ranked integer DEFAULT 0 NOT NULL,
1147 avg_raters_importance double precision DEFAULT (0)::double precision NOT NULL,
1148 avg_rating double precision DEFAULT (0)::double precision NOT NULL,
1149 metric double precision DEFAULT (0)::double precision NOT NULL,
1150 percentile double precision DEFAULT (0)::double precision NOT NULL,
1151 importance_factor double precision DEFAULT (0)::double precision NOT NULL
1156 CREATE TABLE user_preferences (
1157 user_id integer DEFAULT 0 NOT NULL,
1158 preference_name character varying(20) NOT NULL,
1159 dead1 character varying(20),
1160 set_date integer DEFAULT 0 NOT NULL,
1161 preference_value text
1166 CREATE TABLE user_ratings (
1167 rated_by integer DEFAULT 0 NOT NULL,
1168 user_id integer DEFAULT 0 NOT NULL,
1169 rate_field integer DEFAULT 0 NOT NULL,
1170 rating integer DEFAULT 0 NOT NULL
1175 CREATE SEQUENCE users_pk_seq
1183 CREATE TABLE users (
1184 user_id integer DEFAULT nextval('users_pk_seq'::text) NOT NULL,
1185 user_name text DEFAULT ''::text NOT NULL,
1186 email text DEFAULT ''::text NOT NULL,
1187 user_pw character varying(32) DEFAULT ''::character varying NOT NULL,
1188 realname character varying(32) DEFAULT ''::character varying NOT NULL,
1189 status character(1) DEFAULT 'A'::bpchar NOT NULL,
1190 shell character varying(20) DEFAULT '/bin/bash'::character varying NOT NULL,
1191 unix_pw character varying(40) DEFAULT ''::character varying NOT NULL,
1192 unix_status character(1) DEFAULT 'N'::bpchar NOT NULL,
1193 unix_uid integer DEFAULT 0 NOT NULL,
1194 unix_box character varying(10) DEFAULT 'shell1'::character varying NOT NULL,
1195 add_date integer DEFAULT 0 NOT NULL,
1196 confirm_hash character varying(32),
1197 mail_siteupdates integer DEFAULT 0 NOT NULL,
1198 mail_va integer DEFAULT 0 NOT NULL,
1199 authorized_keys text,
1201 people_view_skills integer DEFAULT 0 NOT NULL,
1202 people_resume text DEFAULT ''::text NOT NULL,
1203 timezone character varying(64) DEFAULT 'GMT'::character varying,
1204 "language" integer DEFAULT 1 NOT NULL,
1205 block_ratings integer DEFAULT 0,
1206 jabber_address text,
1207 jabber_only integer,
1212 firstname character varying(60),
1213 lastname character varying(60),
1215 ccode character(2) DEFAULT 'US'::bpchar,
1217 type_id integer DEFAULT 1,
1218 unix_gid integer DEFAULT 0
1223 CREATE SEQUENCE unix_uid_seq
1232 CREATE SEQUENCE forum_thread_seq
1241 CREATE TABLE project_sums_agg (
1242 group_id integer DEFAULT 0 NOT NULL,
1243 "type" character(4) NOT NULL,
1244 count integer DEFAULT 0 NOT NULL
1249 CREATE SEQUENCE project_metric_wee_ranking1_seq
1258 CREATE SEQUENCE prdb_dbs_dbid_seq
1267 CREATE TABLE prdb_dbs (
1268 dbid integer DEFAULT nextval('"prdb_dbs_dbid_seq"'::text) NOT NULL,
1269 group_id integer NOT NULL,
1270 dbname text NOT NULL,
1271 dbusername text NOT NULL,
1272 dbuserpass text NOT NULL,
1273 requestdate integer NOT NULL,
1274 dbtype integer NOT NULL,
1275 created_by integer NOT NULL,
1276 state integer NOT NULL
1281 CREATE TABLE prdb_states (
1282 stateid integer NOT NULL,
1288 CREATE TABLE prdb_types (
1289 dbtypeid integer NOT NULL,
1290 dbservername text NOT NULL,
1291 dbsoftware text NOT NULL
1296 CREATE SEQUENCE prweb_vhost_vhostid_seq
1305 CREATE TABLE prweb_vhost (
1306 vhostid integer DEFAULT nextval('"prweb_vhost_vhostid_seq"'::text) NOT NULL,
1310 group_id integer NOT NULL
1315 CREATE SEQUENCE artifact_grou_group_artifac_seq
1323 CREATE TABLE artifact_group_list (
1324 group_artifact_id integer DEFAULT nextval('"artifact_grou_group_artifac_seq"'::text) NOT NULL,
1325 group_id integer NOT NULL,
1328 is_public integer DEFAULT 0 NOT NULL,
1329 allow_anon integer DEFAULT 0 NOT NULL,
1330 email_all_updates integer DEFAULT 0 NOT NULL,
1331 email_address text NOT NULL,
1332 due_period integer DEFAULT 2592000 NOT NULL,
1333 submit_instructions text,
1334 browse_instructions text,
1335 datatype integer DEFAULT 0 NOT NULL,
1336 status_timeout integer,
1337 custom_status_field integer DEFAULT 0 NOT NULL,
1338 custom_renderer text
1343 CREATE SEQUENCE artifact_perm_id_seq
1352 CREATE TABLE artifact_perm (
1353 id integer DEFAULT nextval('"artifact_perm_id_seq"'::text) NOT NULL,
1354 group_artifact_id integer NOT NULL,
1355 user_id integer NOT NULL,
1356 perm_level integer DEFAULT 0 NOT NULL
1361 CREATE VIEW artifactperm_user_vw AS
1362 SELECT ap.id, ap.group_artifact_id, ap.user_id, ap.perm_level, users.user_name, users.realname FROM artifact_perm ap, users WHERE (users.user_id = ap.user_id);
1366 CREATE VIEW artifactperm_artgrouplist_vw AS
1367 SELECT agl.group_artifact_id, agl.name, agl.description, agl.group_id, ap.user_id, ap.perm_level FROM artifact_perm ap, artifact_group_list agl WHERE (ap.group_artifact_id = agl.group_artifact_id);
1371 CREATE SEQUENCE artifact_status_id_seq
1379 CREATE TABLE artifact_status (
1380 id integer DEFAULT nextval('"artifact_status_id_seq"'::text) NOT NULL,
1381 status_name text NOT NULL
1386 CREATE SEQUENCE artifact_artifact_id_seq
1395 CREATE TABLE artifact (
1396 artifact_id integer DEFAULT nextval('"artifact_artifact_id_seq"'::text) NOT NULL,
1397 group_artifact_id integer NOT NULL,
1398 status_id integer DEFAULT 1 NOT NULL,
1399 priority integer DEFAULT 3 NOT NULL,
1400 submitted_by integer DEFAULT 100 NOT NULL,
1401 assigned_to integer DEFAULT 100 NOT NULL,
1402 open_date integer DEFAULT 0 NOT NULL,
1403 close_date integer DEFAULT 0 NOT NULL,
1404 summary text NOT NULL,
1405 details text NOT NULL,
1406 last_modified_date integer
1411 CREATE SEQUENCE artifact_history_id_seq
1420 CREATE TABLE artifact_history (
1421 id integer DEFAULT nextval('"artifact_history_id_seq"'::text) NOT NULL,
1422 artifact_id integer DEFAULT 0 NOT NULL,
1423 field_name text DEFAULT ''::text NOT NULL,
1424 old_value text DEFAULT ''::text NOT NULL,
1425 mod_by integer DEFAULT 0 NOT NULL,
1426 entrydate integer DEFAULT 0 NOT NULL
1431 CREATE VIEW artifact_history_user_vw AS
1432 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);
1436 CREATE SEQUENCE artifact_file_id_seq
1445 CREATE TABLE artifact_file (
1446 id integer DEFAULT nextval('"artifact_file_id_seq"'::text) NOT NULL,
1447 artifact_id integer NOT NULL,
1448 description text NOT NULL,
1449 bin_data text NOT NULL,
1450 filename text NOT NULL,
1451 filesize integer NOT NULL,
1452 filetype text NOT NULL,
1453 adddate integer DEFAULT 0 NOT NULL,
1454 submitted_by integer NOT NULL
1459 CREATE VIEW artifact_file_user_vw AS
1460 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);
1464 CREATE SEQUENCE artifact_message_id_seq
1473 CREATE TABLE artifact_message (
1474 id integer DEFAULT nextval('"artifact_message_id_seq"'::text) NOT NULL,
1475 artifact_id integer NOT NULL,
1476 submitted_by integer NOT NULL,
1477 from_email text NOT NULL,
1478 adddate integer DEFAULT 0 NOT NULL,
1484 CREATE VIEW artifact_message_user_vw AS
1485 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);
1489 CREATE SEQUENCE artifact_monitor_id_seq
1498 CREATE TABLE artifact_monitor (
1499 id integer DEFAULT nextval('"artifact_monitor_id_seq"'::text) NOT NULL,
1500 artifact_id integer NOT NULL,
1501 user_id integer NOT NULL,
1507 CREATE SEQUENCE artifact_canned_response_id_seq
1516 CREATE TABLE artifact_canned_responses (
1517 id integer DEFAULT nextval('"artifact_canned_response_id_seq"'::text) NOT NULL,
1518 group_artifact_id integer NOT NULL,
1519 title text NOT NULL,
1525 CREATE TABLE artifact_counts_agg (
1526 group_artifact_id integer NOT NULL,
1527 count integer DEFAULT 0 NOT NULL,
1528 open_count integer DEFAULT 0
1533 CREATE TABLE stats_site_pages_by_day (
1536 site_page_views integer
1541 CREATE FUNCTION forumgrouplist_insert_agg() RETURNS "trigger"
1544 INSERT INTO forum_agg_msg_count (group_forum_id,count)
1545 VALUES (NEW.group_forum_id,0);
1553 CREATE FUNCTION artifactgrouplist_insert_agg() RETURNS "trigger"
1556 INSERT INTO artifact_counts_agg (group_artifact_id,count,open_count)
1557 VALUES (NEW.group_artifact_id,0,0);
1565 CREATE FUNCTION artifactgroup_update_agg() RETURNS "trigger"
1569 -- see if they are moving to a new artifacttype
1570 -- if so, its a more complex operation
1572 IF NEW.group_artifact_id <> OLD.group_artifact_id THEN
1574 -- transferred artifacts always have a status of 1
1575 -- so we will increment the new artifacttypes sums
1577 IF OLD.status_id=3 THEN
1578 -- No need to decrement counters on old tracker
1580 IF OLD.status_id=2 THEN
1581 UPDATE artifact_counts_agg SET count=count-1
1582 WHERE group_artifact_id=OLD.group_artifact_id;
1584 IF OLD.status_id=1 THEN
1585 UPDATE artifact_counts_agg SET count=count-1,open_count=open_count-1
1586 WHERE group_artifact_id=OLD.group_artifact_id;
1591 IF NEW.status_id=3 THEN
1594 IF NEW.status_id=2 THEN
1595 UPDATE artifact_counts_agg SET count=count+1
1596 WHERE group_artifact_id=NEW.group_artifact_id;
1598 IF NEW.status_id=1 THEN
1599 UPDATE artifact_counts_agg SET count=count+1, open_count=open_count+1
1600 WHERE group_artifact_id=NEW.group_artifact_id;
1606 -- just need to evaluate the status flag and
1607 -- increment/decrement the counter as necessary
1609 IF NEW.status_id <> OLD.status_id THEN
1610 IF NEW.status_id = 1 THEN
1611 IF OLD.status_id=2 THEN
1612 UPDATE artifact_counts_agg SET open_count=open_count+1
1613 WHERE group_artifact_id=NEW.group_artifact_id;
1615 IF OLD.status_id=3 THEN
1616 UPDATE artifact_counts_agg SET open_count=open_count+1, count=count+1
1617 WHERE group_artifact_id=NEW.group_artifact_id;
1621 IF NEW.status_id = 2 THEN
1622 IF OLD.status_id=1 THEN
1623 UPDATE artifact_counts_agg SET open_count=open_count-1
1624 WHERE group_artifact_id=NEW.group_artifact_id;
1626 IF OLD.status_id=3 THEN
1627 UPDATE artifact_counts_agg SET count=count+1
1628 WHERE group_artifact_id=NEW.group_artifact_id;
1632 IF NEW.status_id = 3 THEN
1633 IF OLD.status_id=2 THEN
1634 UPDATE artifact_counts_agg SET count=count-1
1635 WHERE group_artifact_id=NEW.group_artifact_id;
1637 IF OLD.status_id=1 THEN
1638 UPDATE artifact_counts_agg SET open_count=open_count-1,count=count-1
1639 WHERE group_artifact_id=NEW.group_artifact_id;
1654 CREATE SEQUENCE massmail_queue_id_seq
1663 CREATE TABLE massmail_queue (
1664 id integer DEFAULT nextval('"massmail_queue_id_seq"'::text) NOT NULL,
1665 "type" character varying(8) NOT NULL,
1666 subject text NOT NULL,
1667 message text NOT NULL,
1668 queued_date integer NOT NULL,
1669 last_userid integer DEFAULT 0 NOT NULL,
1670 failed_date integer DEFAULT 0 NOT NULL,
1671 finished_date integer DEFAULT 0 NOT NULL
1676 CREATE TABLE stats_agg_site_by_group (
1685 CREATE TABLE stats_project_metric (
1686 "month" integer DEFAULT 0 NOT NULL,
1687 "day" integer DEFAULT 0 NOT NULL,
1688 ranking integer DEFAULT 0 NOT NULL,
1689 percentile double precision DEFAULT 0 NOT NULL,
1690 group_id integer DEFAULT 0 NOT NULL
1695 CREATE TABLE stats_agg_logo_by_group (
1704 CREATE TABLE stats_subd_pages (
1705 "month" integer DEFAULT 0 NOT NULL,
1706 "day" integer DEFAULT 0 NOT NULL,
1707 group_id integer DEFAULT 0 NOT NULL,
1708 pages integer DEFAULT 0 NOT NULL
1713 CREATE TABLE stats_cvs_user (
1714 "month" integer DEFAULT 0 NOT NULL,
1715 "day" integer DEFAULT 0 NOT NULL,
1716 group_id integer DEFAULT 0 NOT NULL,
1717 user_id integer DEFAULT 0 NOT NULL,
1718 checkouts integer DEFAULT 0 NOT NULL,
1719 commits integer DEFAULT 0 NOT NULL,
1720 adds integer DEFAULT 0 NOT NULL
1725 CREATE TABLE stats_cvs_group (
1726 "month" integer DEFAULT 0 NOT NULL,
1727 "day" integer DEFAULT 0 NOT NULL,
1728 group_id integer DEFAULT 0 NOT NULL,
1729 checkouts integer DEFAULT 0 NOT NULL,
1730 commits integer DEFAULT 0 NOT NULL,
1731 adds integer DEFAULT 0 NOT NULL
1736 CREATE TABLE stats_project_developers (
1737 "month" integer DEFAULT 0 NOT NULL,
1738 "day" integer DEFAULT 0 NOT NULL,
1739 group_id integer DEFAULT 0 NOT NULL,
1740 developers integer DEFAULT 0 NOT NULL
1745 CREATE TABLE stats_project (
1746 "month" integer DEFAULT 0 NOT NULL,
1747 "day" integer DEFAULT 0 NOT NULL,
1748 group_id integer DEFAULT 0 NOT NULL,
1749 file_releases integer DEFAULT 0,
1750 msg_posted integer DEFAULT 0,
1751 msg_uniq_auth integer DEFAULT 0,
1752 bugs_opened integer DEFAULT 0,
1753 bugs_closed integer DEFAULT 0,
1754 support_opened integer DEFAULT 0,
1755 support_closed integer DEFAULT 0,
1756 patches_opened integer DEFAULT 0,
1757 patches_closed integer DEFAULT 0,
1758 artifacts_opened integer DEFAULT 0,
1759 artifacts_closed integer DEFAULT 0,
1760 tasks_opened integer DEFAULT 0,
1761 tasks_closed integer DEFAULT 0,
1762 help_requests integer DEFAULT 0
1767 CREATE TABLE stats_site (
1772 total_users integer,
1774 new_projects integer
1779 CREATE TABLE activity_log (
1780 "day" integer DEFAULT 0 NOT NULL,
1781 "hour" integer DEFAULT 0 NOT NULL,
1782 group_id integer DEFAULT 0 NOT NULL,
1783 browser character varying(8) DEFAULT 'OTHER'::character varying NOT NULL,
1784 ver double precision DEFAULT (0)::double precision NOT NULL,
1785 platform character varying(8) DEFAULT 'OTHER'::character varying NOT NULL,
1786 "time" integer DEFAULT 0 NOT NULL,
1788 "type" integer DEFAULT 0 NOT NULL
1793 CREATE TABLE user_metric_history (
1794 "month" integer NOT NULL,
1795 "day" integer NOT NULL,
1796 user_id integer NOT NULL,
1797 ranking integer NOT NULL,
1798 metric double precision NOT NULL
1803 CREATE TABLE frs_dlstats_filetotal_agg (
1804 file_id integer NOT NULL,
1810 CREATE TABLE stats_project_months (
1814 group_ranking integer,
1815 group_metric double precision,
1816 logo_showings integer,
1819 subdomain_views integer,
1821 file_releases integer,
1823 msg_uniq_auth integer,
1824 bugs_opened integer,
1825 bugs_closed integer,
1826 support_opened integer,
1827 support_closed integer,
1828 patches_opened integer,
1829 patches_closed integer,
1830 artifacts_opened integer,
1831 artifacts_closed integer,
1832 tasks_opened integer,
1833 tasks_closed integer,
1834 help_requests integer,
1835 cvs_checkouts integer,
1836 cvs_commits integer,
1842 CREATE TABLE stats_site_pages_by_month (
1844 site_page_views integer
1849 CREATE TABLE stats_site_months (
1851 site_page_views integer,
1853 subdomain_views integer,
1855 bugs_opened integer,
1856 bugs_closed integer,
1857 support_opened integer,
1858 support_closed integer,
1859 patches_opened integer,
1860 patches_closed integer,
1861 artifacts_opened integer,
1862 artifacts_closed integer,
1863 tasks_opened integer,
1864 tasks_closed integer,
1865 help_requests integer,
1866 cvs_checkouts integer,
1867 cvs_commits integer,
1873 CREATE TABLE trove_agg (
1874 trove_cat_id integer,
1876 group_name character varying(40),
1877 unix_group_name character varying(30),
1878 status character(1),
1879 register_time integer,
1880 short_description character varying(255),
1881 percentile double precision,
1887 CREATE SEQUENCE trove_treesum_trove_treesum_seq
1896 CREATE TABLE trove_treesums (
1897 trove_treesums_id integer DEFAULT nextval('"trove_treesum_trove_treesum_seq"'::text) NOT NULL,
1898 trove_cat_id integer DEFAULT 0 NOT NULL,
1899 limit_1 integer DEFAULT 0 NOT NULL,
1900 subprojects integer DEFAULT 0 NOT NULL
1905 CREATE TABLE frs_dlstats_file (
1915 CREATE SEQUENCE group_cvs_history_id_seq
1918 MAXVALUE 9223372036854775807
1924 CREATE TABLE group_cvs_history (
1925 id integer DEFAULT nextval('"group_cvs_history_id_seq"'::text) NOT NULL,
1926 group_id integer DEFAULT 0 NOT NULL,
1927 user_name character varying(80) DEFAULT ''::character varying NOT NULL,
1928 cvs_commits integer DEFAULT 0 NOT NULL,
1929 cvs_commits_wk integer DEFAULT 0 NOT NULL,
1930 cvs_adds integer DEFAULT 0 NOT NULL,
1931 cvs_adds_wk integer DEFAULT 0 NOT NULL
1936 CREATE SEQUENCE themes_theme_id_seq
1938 MAXVALUE 9223372036854775807
1944 CREATE TABLE themes (
1945 theme_id integer DEFAULT nextval('"themes_theme_id_seq"'::text) NOT NULL,
1946 dirname character varying(80),
1947 fullname character varying(80),
1948 enabled boolean DEFAULT true
1953 CREATE SEQUENCE supported_langu_language_id_seq
1955 MAXVALUE 9223372036854775807
1961 CREATE TABLE supported_languages (
1962 language_id integer DEFAULT nextval('"supported_langu_language_id_seq"'::text) NOT NULL,
1966 language_code character(5)
1971 CREATE SEQUENCE skills_data_pk_seq
1974 MAXVALUE 9223372036854775807
1980 CREATE SEQUENCE skills_data_types_pk_seq
1982 MAXVALUE 9223372036854775807
1988 CREATE TABLE skills_data_types (
1989 type_id integer DEFAULT nextval('skills_data_types_pk_seq'::text) NOT NULL,
1990 type_name character varying(25) DEFAULT ''::character varying NOT NULL
1995 CREATE TABLE skills_data (
1996 skills_data_id integer DEFAULT nextval('skills_data_pk_seq'::text) NOT NULL,
1997 user_id integer DEFAULT 0 NOT NULL,
1998 "type" integer DEFAULT 0 NOT NULL,
1999 title character varying(100) DEFAULT ''::character varying NOT NULL,
2000 "start" integer DEFAULT 0 NOT NULL,
2001 finish integer DEFAULT 0 NOT NULL,
2002 keywords character varying(255) DEFAULT ''::character varying NOT NULL
2007 CREATE VIEW frs_file_vw AS
2008 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));
2012 CREATE SEQUENCE project_categor_category_id_seq
2014 MAXVALUE 9223372036854775807
2020 CREATE TABLE project_category (
2021 category_id integer DEFAULT nextval('"project_categor_category_id_seq"'::text) NOT NULL,
2022 group_project_id integer,
2028 CREATE TABLE project_task_artifact (
2029 project_task_id integer NOT NULL,
2030 artifact_id integer NOT NULL
2035 CREATE VIEW project_history_user_vw AS
2036 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);
2040 CREATE SEQUENCE project_messa_project_messa_seq
2043 MAXVALUE 9223372036854775807
2049 CREATE TABLE project_messages (
2050 project_message_id integer DEFAULT nextval('"project_messa_project_messa_seq"'::text) NOT NULL,
2051 project_task_id integer NOT NULL,
2053 posted_by integer NOT NULL,
2054 postdate integer NOT NULL
2059 CREATE VIEW project_message_user_vw AS
2060 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);
2064 CREATE FUNCTION frs_dlstats_filetotal_insert_ag() RETURNS "trigger"
2067 INSERT INTO frs_dlstats_filetotal_agg (file_id, downloads) VALUES (NEW.file_id, 0);
2075 CREATE VIEW frs_dlstats_file_agg_vw AS
2076 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;
2080 CREATE VIEW frs_dlstats_grouptotal_vw AS
2081 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;
2085 CREATE VIEW frs_dlstats_group_vw AS
2086 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";
2090 CREATE VIEW stats_project_vw AS
2091 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));
2095 CREATE VIEW stats_project_all_vw AS
2096 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;
2100 CREATE VIEW stats_site_vw AS
2101 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;
2105 CREATE VIEW stats_site_all_vw AS
2106 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;
2110 CREATE SEQUENCE plugins_pk_seq
2112 MAXVALUE 9223372036854775807
2118 CREATE TABLE plugins (
2119 plugin_id integer DEFAULT nextval('plugins_pk_seq'::text) NOT NULL,
2120 plugin_name character varying(32) NOT NULL,
2126 CREATE SEQUENCE group_plugin_pk_seq
2128 MAXVALUE 9223372036854775807
2134 CREATE TABLE group_plugin (
2135 group_plugin_id integer DEFAULT nextval('group_plugin_pk_seq'::text) NOT NULL,
2142 CREATE SEQUENCE user_plugin_pk_seq
2145 MAXVALUE 9223372036854775807
2151 CREATE TABLE user_plugin (
2152 user_plugin_id integer DEFAULT nextval('user_plugin_pk_seq'::text) NOT NULL,
2153 user_id integer NOT NULL,
2154 plugin_id integer NOT NULL
2159 CREATE TABLE cron_history (
2160 rundate integer NOT NULL,
2167 CREATE TABLE country_code (
2168 country_name character varying(80),
2169 ccode character(2) NOT NULL
2174 CREATE TABLE licenses (
2175 license_id serial NOT NULL,
2181 CREATE TABLE user_type (
2182 type_id serial NOT NULL,
2189 role_id serial NOT NULL,
2190 group_id integer NOT NULL,
2196 CREATE TABLE project_perm (
2198 group_project_id integer NOT NULL,
2199 user_id integer NOT NULL,
2200 perm_level integer DEFAULT 0 NOT NULL
2205 CREATE TABLE forum_perm (
2207 group_forum_id integer NOT NULL,
2208 user_id integer NOT NULL,
2209 perm_level integer DEFAULT 0 NOT NULL
2214 CREATE TABLE role_setting (
2215 role_id integer NOT NULL,
2216 section_name text NOT NULL,
2217 ref_id integer NOT NULL,
2218 value character varying(2) NOT NULL
2223 CREATE TABLE artifact_extra_field_list (
2224 extra_field_id integer DEFAULT nextval('artifact_extra_field_list_extra_field_id_seq'::text) NOT NULL,
2225 group_artifact_id integer NOT NULL,
2226 field_name text NOT NULL,
2227 field_type integer DEFAULT 1,
2228 attribute1 integer DEFAULT 0,
2229 attribute2 integer DEFAULT 0,
2230 is_required integer DEFAULT 0 NOT NULL,
2236 CREATE TABLE artifact_extra_field_elements (
2237 element_id integer DEFAULT nextval('artifact_extra_field_elements_element_id_seq'::text) NOT NULL,
2238 extra_field_id integer NOT NULL,
2239 element_name text NOT NULL,
2240 status_id integer DEFAULT 0 NOT NULL
2245 CREATE TABLE artifact_extra_field_data (
2246 data_id integer DEFAULT nextval('artifact_extra_field_data_data_id_seq'::text) NOT NULL,
2247 artifact_id integer NOT NULL,
2249 extra_field_id integer DEFAULT 0
2254 CREATE TABLE project_counts_agg (
2255 group_project_id integer NOT NULL,
2256 count integer DEFAULT 0 NOT NULL,
2257 open_count integer DEFAULT 0
2262 CREATE VIEW project_group_list_vw AS
2263 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);
2267 CREATE FUNCTION projectgrouplist_insert_agg() RETURNS "trigger"
2270 INSERT INTO project_counts_agg (group_project_id,count,open_count)
2271 VALUES (NEW.group_project_id,0,0);
2279 CREATE FUNCTION projectgroup_update_agg() RETURNS "trigger"
2283 -- see if they are moving to a new subproject
2284 -- if so, its a more complex operation
2286 IF NEW.group_project_id <> OLD.group_project_id THEN
2288 -- transferred tasks always have a status of 1
2289 -- so we will increment the new subprojects sums
2291 IF OLD.status_id=3 THEN
2292 -- No need to decrement counters on old tracker
2294 IF OLD.status_id=2 THEN
2295 UPDATE project_counts_agg SET count=count-1
2296 WHERE group_project_id=OLD.group_project_id;
2298 IF OLD.status_id=1 THEN
2299 UPDATE project_counts_agg SET count=count-1,open_count=open_count-1
2300 WHERE group_project_id=OLD.group_project_id;
2305 IF NEW.status_id=3 THEN
2308 IF NEW.status_id=2 THEN
2309 UPDATE project_counts_agg SET count=count+1
2310 WHERE group_project_id=NEW.group_project_id;
2312 IF NEW.status_id=1 THEN
2313 UPDATE project_counts_agg SET count=count+1, open_count=open_count+1
2314 WHERE group_project_id=NEW.group_project_id;
2320 -- just need to evaluate the status flag and
2321 -- increment/decrement the counter as necessary
2323 IF NEW.status_id <> OLD.status_id THEN
2324 IF NEW.status_id = 1 THEN
2325 IF OLD.status_id=2 THEN
2326 UPDATE project_counts_agg SET open_count=open_count+1
2327 WHERE group_project_id=NEW.group_project_id;
2329 IF OLD.status_id=3 THEN
2330 UPDATE project_counts_agg SET open_count=open_count+1, count=count+1
2331 WHERE group_project_id=NEW.group_project_id;
2335 IF NEW.status_id = 2 THEN
2336 IF OLD.status_id=1 THEN
2337 UPDATE project_counts_agg SET open_count=open_count-1
2338 WHERE group_project_id=NEW.group_project_id;
2340 IF OLD.status_id=3 THEN
2341 UPDATE project_counts_agg SET count=count+1
2342 WHERE group_project_id=NEW.group_project_id;
2346 IF NEW.status_id = 3 THEN
2347 IF OLD.status_id=2 THEN
2348 UPDATE project_counts_agg SET count=count-1
2349 WHERE group_project_id=NEW.group_project_id;
2351 IF OLD.status_id=1 THEN
2352 UPDATE project_counts_agg SET open_count=open_count-1,count=count-1
2353 WHERE group_project_id=NEW.group_project_id;
2368 CREATE VIEW project_depend_vw AS
2369 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);
2373 CREATE VIEW project_dependon_vw AS
2374 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)));
2378 CREATE TABLE project_task_external_order (
2379 project_task_id integer NOT NULL,
2380 external_id integer NOT NULL
2385 CREATE TABLE group_join_request (
2386 group_id integer NOT NULL,
2387 user_id integer NOT NULL,
2389 request_date integer
2394 CREATE FUNCTION update_last_modified_date() RETURNS "trigger"
2397 NEW.last_modified_date = EXTRACT(EPOCH FROM now())::integer;
2405 CREATE VIEW project_task_vw AS
2406 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);
2410 CREATE TABLE artifact_type_monitor (
2411 group_artifact_id integer NOT NULL,
2412 user_id integer NOT NULL
2417 CREATE SEQUENCE artifact_extra_field_elements_element_id_seq
2420 MAXVALUE 9223372036854775807
2426 CREATE SEQUENCE artifact_extra_field_data_data_id_seq
2429 MAXVALUE 9223372036854775807
2435 CREATE SEQUENCE plugin_cvstracker_artifact_seq
2444 CREATE TABLE plugin_cvstracker_data_artifact (
2445 id integer DEFAULT nextval('plugin_cvstracker_artifact_seq'::text) NOT NULL,
2446 kind integer DEFAULT 0 NOT NULL,
2447 group_artifact_id integer,
2448 project_task_id integer
2453 CREATE SEQUENCE plugin_cvstracker_master_seq
2462 CREATE TABLE plugin_cvstracker_data_master (
2463 id integer DEFAULT nextval('plugin_cvstracker_master_seq'::text) NOT NULL,
2464 holder_id integer NOT NULL,
2465 log_text text DEFAULT ''::text,
2466 file text DEFAULT ''::text NOT NULL,
2467 prev_version text DEFAULT ''::text,
2468 actual_version text DEFAULT ''::text,
2469 author text DEFAULT ''::text NOT NULL,
2470 cvs_date integer NOT NULL
2475 CREATE VIEW nss_passwd AS
2476 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);
2480 CREATE VIEW nss_shadow AS
2481 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);
2485 CREATE TABLE nss_groups (
2488 name character varying(30),
2494 CREATE TABLE nss_usergroups (
2500 unix_group_name character varying
2505 CREATE TABLE deleted_mailing_lists (
2506 mailing_list_name character varying(30),
2507 delete_date integer,
2513 CREATE TABLE deleted_groups (
2514 unix_group_name character varying(30),
2515 delete_date integer,
2521 CREATE FUNCTION project_sums() RETURNS "trigger"
2529 --- Get number of things this group has now
2531 IF TG_ARGV[0]=''surv'' THEN
2532 IF TG_OP=''DELETE'' THEN
2533 SELECT INTO num count(*) FROM surveys WHERE OLD.group_id=group_id AND is_active=1;
2534 curr_group := OLD.group_id;
2536 SELECT INTO num count(*) FROM surveys WHERE NEW.group_id=group_id AND is_active=1;
2537 curr_group := NEW.group_id;
2540 IF TG_ARGV[0]=''mail'' THEN
2541 IF TG_OP=''DELETE'' THEN
2542 SELECT INTO num count(*) FROM mail_group_list WHERE OLD.group_id=group_id AND is_public=1;
2543 curr_group := OLD.group_id;
2545 SELECT INTO num count(*) FROM mail_group_list WHERE NEW.group_id=group_id AND is_public=1;
2546 curr_group := NEW.group_id;
2549 IF TG_ARGV[0]=''fmsg'' THEN
2550 IF TG_OP=''DELETE'' THEN
2551 SELECT INTO curr_group group_id FROM forum_group_list WHERE OLD.group_forum_id=group_forum_id;
2552 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;
2554 SELECT INTO curr_group group_id FROM forum_group_list WHERE NEW.group_forum_id=group_forum_id;
2555 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;
2558 IF TG_ARGV[0]=''fora'' THEN
2559 IF TG_OP=''DELETE'' THEN
2560 SELECT INTO num count(*) FROM forum_group_list WHERE OLD.group_id=group_id AND is_public=1;
2561 curr_group = OLD.group_id;
2562 --- also need to update message count
2563 DELETE FROM project_sums_agg WHERE group_id=OLD.group_id AND type=''fmsg'';
2564 INSERT INTO project_sums_agg
2565 SELECT OLD.group_id,''fmsg''::text AS type, count(forum.msg_id) AS count
2566 FROM forum, forum_group_list
2567 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;
2569 SELECT INTO num count(*) FROM forum_group_list WHERE NEW.group_id=group_id AND is_public=1;
2570 curr_group = NEW.group_id;
2574 --- See if this group already has a row in project_sums_agg for these things
2576 SELECT INTO found count(group_id) FROM project_sums_agg WHERE curr_group=group_id AND type=TG_ARGV[0];
2580 --- Create row for this group
2582 INSERT INTO project_sums_agg
2583 VALUES (curr_group, TG_ARGV[0], num);
2588 UPDATE project_sums_agg SET count=num
2589 WHERE curr_group=group_id AND type=TG_ARGV[0];
2592 IF TG_OP=''DELETE'' THEN
2603 CREATE TABLE artifact_query (
2604 artifact_query_id serial NOT NULL,
2605 group_artifact_id integer NOT NULL,
2606 user_id integer NOT NULL,
2607 query_name text NOT NULL
2612 CREATE TABLE artifact_query_fields (
2613 artifact_query_id integer NOT NULL,
2614 query_field_type text NOT NULL,
2615 query_field_id integer NOT NULL,
2616 query_field_values text NOT NULL
2621 CREATE VIEW artifact_group_list_vw AS
2622 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));
2626 CREATE VIEW artifact_vw AS
2627 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));
2631 CREATE SEQUENCE artifact_extra_field_list_extra_field_id_seq
2634 MAXVALUE 9223372036854775807
2640 CREATE VIEW docdata_vw AS
2641 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)));
2645 CREATE TABLE form_keys (
2646 key_id serial NOT NULL,
2647 "key" text NOT NULL,
2648 creation_date integer NOT NULL,
2649 is_used integer DEFAULT 0 NOT NULL
2654 CREATE TABLE forum_attachment (
2655 attachmentid serial NOT NULL,
2656 userid integer DEFAULT 100 NOT NULL,
2657 dateline integer DEFAULT 0 NOT NULL,
2658 filename character varying(100) DEFAULT ''::character varying NOT NULL,
2659 filedata text NOT NULL,
2660 visible smallint DEFAULT (0)::smallint NOT NULL,
2661 counter smallint DEFAULT (0)::smallint NOT NULL,
2662 filesize integer DEFAULT 0 NOT NULL,
2663 msg_id integer DEFAULT 0 NOT NULL,
2664 filehash character varying(32) DEFAULT ''::character varying NOT NULL
2669 CREATE TABLE forum_attachment_type (
2670 extension character varying(20) DEFAULT ''::character varying NOT NULL,
2671 mimetype character varying(255) DEFAULT ''::character varying NOT NULL,
2672 size integer DEFAULT 0 NOT NULL,
2673 width smallint DEFAULT (0)::smallint NOT NULL,
2674 height smallint DEFAULT (0)::smallint NOT NULL,
2675 enabled smallint DEFAULT (1)::smallint NOT NULL
2680 CREATE VIEW forum_group_list_vw AS
2681 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));
2685 CREATE TABLE forum_pending_messages (
2686 msg_id serial NOT NULL,
2687 group_forum_id integer DEFAULT 0 NOT NULL,
2688 posted_by integer DEFAULT 0 NOT NULL,
2689 subject text DEFAULT ''::text NOT NULL,
2690 body text DEFAULT ''::text NOT NULL,
2691 post_date integer DEFAULT 0 NOT NULL,
2692 is_followup_to integer DEFAULT 0 NOT NULL,
2693 thread_id integer DEFAULT 0 NOT NULL,
2694 has_followups integer DEFAULT 0,
2695 most_recent_date integer DEFAULT 0 NOT NULL
2700 CREATE TABLE forum_pending_attachment (
2701 attachmentid serial NOT NULL,
2702 userid integer DEFAULT 100 NOT NULL,
2703 dateline integer DEFAULT 0 NOT NULL,
2704 filename character varying(100) DEFAULT ''::character varying NOT NULL,
2705 filedata text NOT NULL,
2706 visible smallint DEFAULT (0)::smallint NOT NULL,
2707 counter smallint DEFAULT (0)::smallint NOT NULL,
2708 filesize integer DEFAULT 0 NOT NULL,
2709 msg_id integer DEFAULT 0 NOT NULL,
2710 filehash character varying(32) DEFAULT ''::character varying NOT NULL
2715 CREATE VIEW forum_user_vw AS
2716 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);
2720 CREATE VIEW forum_pending_user_vw AS
2721 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);
2725 CREATE TABLE group_activity_monitor (
2726 group_id integer NOT NULL,
2727 user_id integer NOT NULL,
2733 CREATE VIEW activity_vw AS
2734 (((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);
2738 COPY canned_responses (response_id, response_title, response_text) FROM stdin;
2743 COPY db_images (id, group_id, description, bin_data, filename, filesize, filetype, width, height, upload_date, "version") FROM stdin;
2748 COPY doc_data (docid, stateid, title, data, updatedate, createdate, created_by, doc_group, description, language_id, filename, filetype, group_id, filesize) FROM stdin;
2753 COPY doc_groups (doc_group, groupname, group_id, parent_doc_group) FROM stdin;
2758 COPY doc_states (stateid, name) FROM stdin;
2768 COPY filemodule_monitor (id, filemodule_id, user_id) FROM stdin;
2773 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;
2778 COPY forum_agg_msg_count (group_forum_id, count) FROM stdin;
2783 COPY forum_group_list (group_forum_id, group_id, forum_name, is_public, description, allow_anonymous, send_all_posts_to, moderation_level) FROM stdin;
2788 COPY forum_monitored_forums (monitor_id, forum_id, user_id) FROM stdin;
2793 COPY forum_saved_place (saved_place_id, user_id, forum_id, save_date) FROM stdin;
2798 COPY frs_file (file_id, filename, release_id, type_id, processor_id, release_time, file_size, post_date) FROM stdin;
2803 COPY frs_filetype (type_id, name) FROM stdin;
2813 5900 Other Source File
2823 COPY frs_package (package_id, group_id, name, status_id, is_public) FROM stdin;
2828 COPY frs_processor (processor_id, name) FROM stdin;
2842 COPY frs_release (release_id, package_id, name, notes, changes, status_id, preformatted, release_date, released_by) FROM stdin;
2847 COPY frs_status (status_id, name) FROM stdin;
2854 COPY group_history (group_history_id, group_id, field_name, old_value, mod_by, adddate) FROM stdin;
2859 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;
2860 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
2861 3 News Group \N 0 A news 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
2862 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
2863 1 Master Group \N 0 A gforge 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
2864 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
2869 COPY mail_group_list (group_list_id, group_id, list_name, is_public, "password", list_admin, status, description) FROM stdin;
2874 COPY news_bytes (id, group_id, submitted_by, is_approved, post_date, forum_id, summary, details) FROM stdin;
2879 COPY people_job (job_id, group_id, created_by, title, description, post_date, status_id, category_id) FROM stdin;
2884 COPY people_job_category (category_id, name, private_flag) FROM stdin;
2891 7 Graphic/Other Designer 0
2896 COPY people_job_inventory (job_inventory_id, job_id, skill_id, skill_level_id, skill_year_id) FROM stdin;
2901 COPY people_job_status (status_id, name) FROM stdin;
2909 COPY people_skill (skill_id, name) FROM stdin;
2914 COPY people_skill_inventory (skill_inventory_id, user_id, skill_id, skill_level_id, skill_year_id) FROM stdin;
2919 COPY people_skill_level (skill_level_id, name) FROM stdin;
2929 COPY people_skill_year (skill_year_id, name) FROM stdin;
2939 COPY project_assigned_to (project_assigned_id, project_task_id, assigned_to_id) FROM stdin;
2944 COPY project_dependencies (project_depend_id, project_task_id, is_dependent_on_task_id, link_type) FROM stdin;
2949 COPY project_group_list (group_project_id, group_id, project_name, is_public, description, send_all_posts_to) FROM stdin;
2950 1 1 Default 0 Default Project - Don't Change \N
2955 COPY project_history (project_history_id, project_task_id, field_name, old_value, mod_by, mod_date) FROM stdin;
2960 COPY project_metric (ranking, percentile, group_id) FROM stdin;
2965 COPY project_metric_tmp1 (ranking, group_id, value) FROM stdin;
2970 COPY project_status (status_id, status_name) FROM stdin;
2977 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;
2978 1 1 0 0 0 0 0 100 1 100 0 0 1108701981
2983 COPY project_weekly_metric (ranking, percentile, group_id) FROM stdin;
2988 COPY user_session (user_id, session_hash, ip_addr, "time") FROM stdin;
2989 100 867b0c76e3a110d924f98029a28baa95 1096480068
2994 COPY snippet (snippet_id, created_by, name, description, "type", "language", license, category) FROM stdin;
2999 COPY snippet_package (snippet_package_id, created_by, name, description, category, "language") FROM stdin;
3004 COPY snippet_package_item (snippet_package_item_id, snippet_package_version_id, snippet_version_id) FROM stdin;
3009 COPY snippet_package_version (snippet_package_version_id, snippet_package_id, changes, "version", submitted_by, post_date) FROM stdin;
3014 COPY snippet_version (snippet_version_id, snippet_id, changes, "version", submitted_by, post_date, code) FROM stdin;
3019 COPY stats_agg_logo_by_day ("day", count) FROM stdin;
3024 COPY stats_agg_pages_by_day ("day", count) FROM stdin;
3029 COPY survey_question_types (id, "type") FROM stdin;
3032 3 Radio Buttons Yes/No
3040 COPY survey_questions (question_id, group_id, question, question_type) FROM stdin;
3045 COPY survey_rating_aggregate ("type", id, response, count) FROM stdin;
3050 COPY survey_rating_response (user_id, "type", id, response, post_date) FROM stdin;
3055 COPY survey_responses (user_id, group_id, survey_id, question_id, response, post_date) FROM stdin;
3060 COPY surveys (survey_id, group_id, survey_title, survey_questions, is_active) FROM stdin;
3065 COPY trove_cat (trove_cat_id, "version", parent, root_parent, shortname, fullname, description, count_subcat, count_subproj, fullpath, fullpath_ids) FROM stdin;
3066 1 2000031601 0 0 audience Intended Audience The main class of people likely to be interested in this resource. 0 0 Intended Audience 1
3067 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
3068 3 2000041101 1 1 developers Developers Programs and resources for software developers, to include libraries. 0 0 Intended Audience :: Developers 1 :: 3
3069 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
3070 5 2000040701 1 1 other Other Audience Programs and resources for an unlisted audience. 0 0 Intended Audience :: Other Audience 1 :: 5
3071 6 2000031601 0 0 developmentstatus Development Status An indication of the development status of the software or resource. 0 0 Development Status 6
3072 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
3073 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
3074 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
3075 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
3076 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
3077 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
3078 13 2000031601 0 0 license License License terms under which the resource is distributed. 0 0 License 13
3079 197 2000032001 13 13 publicdomain Public Domain Public Domain. No author-retained rights. 0 0 License :: Public Domain 13 :: 197
3080 196 2000040701 13 13 other Other/Proprietary License Non OSI-Approved/Proprietary license. 0 0 License :: Other/Proprietary License 13 :: 196
3081 14 2000032401 13 13 osi OSI Approved Licenses that have been approved by OSI as approved 0 0 License :: OSI Approved 13 :: 14
3082 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
3083 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
3084 139 2000032001 136 18 boot Boot Programs for bootstrapping your OS. 0 0 Topic :: System :: Boot 18 :: 136 :: 139
3085 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
3086 138 2000032001 136 18 benchmark Benchmark Programs for benchmarking system performance. 0 0 Topic :: System :: Benchmark 18 :: 136 :: 138
3087 74 2000042701 136 18 emulators Emulators Emulations of foreign operating systme and machines. 0 0 Topic :: System :: Emulators 18 :: 136 :: 74
3088 19 2000032001 136 18 archiving Archiving Tools for maintaining and searching software or document archives. 0 0 Topic :: System :: Archiving 18 :: 136 :: 19
3089 137 2000032001 19 18 backup Backup Programs to manage and sequence system backup. 0 0 Topic :: System :: Archiving :: Backup 18 :: 136 :: 19 :: 137
3090 42 2000031601 19 18 compression Compression Tools and libraries for data compression. 0 0 Topic :: System :: Archiving :: Compression 18 :: 136 :: 19 :: 42
3091 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
3092 132 2000032001 18 18 religion Religion Programs relating to religion and sacred texts. 0 0 Topic :: Religion 18 :: 132
3093 129 2000031701 18 18 office Office/Business Software for assisting and organizing work at your desk. 0 0 Topic :: Office/Business 18 :: 129
3094 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
3095 130 2000031701 129 18 scheduling Scheduling Projects for scheduling time, to include project management. 0 0 Topic :: Office/Business :: Scheduling 18 :: 129 :: 130
3096 75 2000031701 129 18 financial Financial Programs related to finance. 0 0 Topic :: Office/Business :: Financial 18 :: 129 :: 75
3097 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
3098 78 2000031601 75 18 spreadsheet Spreadsheet Spreadsheet applications. 0 0 Topic :: Office/Business :: Financial :: Spreadsheet 18 :: 129 :: 75 :: 78
3099 77 2000031601 75 18 investment Investment Programs for assisting in financial investment. 0 0 Topic :: Office/Business :: Financial :: Investment 18 :: 129 :: 75 :: 77
3100 76 2000031601 75 18 accounting Accounting Checkbook balancers and accounting programs. 0 0 Topic :: Office/Business :: Financial :: Accounting 18 :: 129 :: 75 :: 76
3101 234 2000040701 18 18 other Other/Nonlisted Topic Topic does not fit into any listed category. 0 0 Topic :: Other/Nonlisted Topic 18 :: 234
3102 156 2000032001 18 18 terminals Terminals Terminal emulators, terminal programs, and terminal session utilities. 0 0 Topic :: Terminals 18 :: 156
3103 159 2000032001 156 18 telnet Telnet Support for telnet; terminal sessions across Internet links. 0 0 Topic :: Terminals :: Telnet 18 :: 156 :: 159
3104 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
3105 157 2000032001 156 18 serial Serial Dialup, terminal emulation, and file transfer over serial lines. 0 0 Topic :: Terminals :: Serial 18 :: 156 :: 157
3106 115 2000031701 113 18 capture Capture/Recording Sound capture and recording. 0 0 Topic :: Multimedia :: Sound/Audio :: Capture/Recording 18 :: 99 :: 113 :: 115
3107 114 2000031701 113 18 analysis Analysis Sound analysis tools, to include frequency analysis. 0 0 Topic :: Multimedia :: Sound/Audio :: Analysis 18 :: 99 :: 113 :: 114
3108 100 2000031601 99 18 graphics Graphics Tools and resources for computer graphics. 0 0 Topic :: Multimedia :: Graphics 18 :: 99 :: 100
3109 112 2000031701 100 18 viewers Viewers Programs that can display various graphics formats. 0 0 Topic :: Multimedia :: Graphics :: Viewers 18 :: 99 :: 100 :: 112
3110 111 2000031701 100 18 presentation Presentation Tools for generating presentation graphics and slides. 0 0 Topic :: Multimedia :: Graphics :: Presentation 18 :: 99 :: 100 :: 111
3111 110 2000031701 100 18 3drendering 3D Rendering Programs which render 3D models. 0 0 Topic :: Multimedia :: Graphics :: 3D Rendering 18 :: 99 :: 100 :: 110
3112 109 2000031701 100 18 3dmodeling 3D Modeling Programs for working with 3D Models. 0 0 Topic :: Multimedia :: Graphics :: 3D Modeling 18 :: 99 :: 100 :: 109
3113 106 2000031701 100 18 editors Editors Drawing, painting, and structured editing programs. 0 0 Topic :: Multimedia :: Graphics :: Editors 18 :: 99 :: 100 :: 106
3114 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
3115 107 2000031701 106 18 vector Vector-Based Vector-Based drawing programs. 0 0 Topic :: Multimedia :: Graphics :: Editors :: Vector-Based 18 :: 99 :: 100 :: 106 :: 107
3116 105 2000031701 100 18 conversion Graphics Conversion Programs which convert between graphics formats. 0 0 Topic :: Multimedia :: Graphics :: Graphics Conversion 18 :: 99 :: 100 :: 105
3117 101 2000031601 100 18 capture Capture Support for scanners, cameras, and screen capture. 0 0 Topic :: Multimedia :: Graphics :: Capture 18 :: 99 :: 100 :: 101
3118 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
3119 103 2000031601 101 18 cameras Digital Camera Digital Camera 0 0 Topic :: Multimedia :: Graphics :: Capture :: Digital Camera 18 :: 99 :: 100 :: 101 :: 103
3120 102 2000031601 101 18 scanners Scanners Support for graphic scanners. 0 0 Topic :: Multimedia :: Graphics :: Capture :: Scanners 18 :: 99 :: 100 :: 101 :: 102
3121 154 2000032001 18 18 printing Printing Tools, daemons, and utilities for printer control. 0 0 Topic :: Printing 18 :: 154
3122 136 2000032001 18 18 system System Operating system core and administration utilities. 0 0 Topic :: System 18 :: 136
3123 294 2001032001 136 18 shells System Shells System Shells 0 0 Topic :: System :: System Shells 18 :: 136 :: 294
3124 257 2000071101 136 18 softwaredist Software Distribution Systems software for distributing other software. 0 0 Topic :: System :: Software Distribution 18 :: 136 :: 257
3125 253 2000071101 136 18 sysadministration Systems Administration Systems Administration Software (e.g. configuration apps.) 0 0 Topic :: System :: Systems Administration 18 :: 136 :: 253
3126 289 2001032001 253 18 authentication Authentication/Directory Authentication and directory services 0 0 Topic :: System :: Systems Administration :: Authentication/Directory 18 :: 136 :: 253 :: 289
3127 291 2001032001 289 18 ldap LDAP Leightweight directory access protocol 0 0 Topic :: System :: Systems Administration :: Authentication/Directory :: LDAP 18 :: 136 :: 253 :: 289 :: 291
3128 290 2001032001 289 18 nis NIS NIS services 0 0 Topic :: System :: Systems Administration :: Authentication/Directory :: NIS 18 :: 136 :: 253 :: 289 :: 290
3129 153 2000032001 136 18 power Power (UPS) Code for communication with uninterruptible power supplies. 0 0 Topic :: System :: Power (UPS) 18 :: 136 :: 153
3130 150 2000032001 136 18 networking Networking Network configuration and administration. 0 0 Topic :: System :: Networking 18 :: 136 :: 150
3131 152 2000032001 150 18 monitoring Monitoring System monitoring, traffic analysis, and sniffers. 0 0 Topic :: System :: Networking :: Monitoring 18 :: 136 :: 150 :: 152
3132 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
3133 151 2000032001 150 18 firewalls Firewalls Firewalls and filtering systems. 0 0 Topic :: System :: Networking :: Firewalls 18 :: 136 :: 150 :: 151
3134 148 2000032001 136 18 logging Logging Utilities for clearing, rotating, and digesting system logs. 0 0 Topic :: System :: Logging 18 :: 136 :: 148
3135 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
3136 146 2000032001 136 18 hardware Hardware Tools for direct, non-kernel control and configuration of hardware. 0 0 Topic :: System :: Hardware 18 :: 136 :: 146
3137 292 2001032001 146 18 drivers Hardware Drivers Hardware Drivers 0 0 Topic :: System :: Hardware :: Hardware Drivers 18 :: 136 :: 146 :: 292
3138 144 2000032001 136 18 kernels Operating System Kernels OS Kernels, patches, modules, and tools. 0 0 Topic :: System :: Operating System Kernels 18 :: 136 :: 144
3139 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
3140 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
3141 143 2000032001 144 18 linux Linux The Linux kernel, patches, and modules. 0 0 Topic :: System :: Operating System Kernels :: Linux 18 :: 136 :: 144 :: 143
3142 142 2000032001 136 18 filesystems Filesystems Support for creating, editing, reading, and writing file systems. 0 0 Topic :: System :: Filesystems 18 :: 136 :: 142
3143 287 2001032001 80 18 boardgames Board Games Board Games 0 0 Topic :: Games/Entertainment :: Board Games 18 :: 80 :: 287
3144 268 2000082101 80 18 Puzzles Puzzle Games Puzzle Games 0 0 Topic :: Games/Entertainment :: Puzzle Games 18 :: 80 :: 268
3145 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
3146 85 2000031601 80 18 simulation Simulation Simulation games 0 0 Topic :: Games/Entertainment :: Simulation 18 :: 80 :: 85
3147 84 2000031601 80 18 rpg Role-Playing Role-Playing games 0 0 Topic :: Games/Entertainment :: Role-Playing 18 :: 80 :: 84
3148 83 2000032401 80 18 turnbasedstrategy Turn Based Strategy Turn Based Strategy 0 0 Topic :: Games/Entertainment :: Turn Based Strategy 18 :: 80 :: 83
3149 82 2000031601 80 18 firstpersonshooters First Person Shooters First Person Shooters. 0 0 Topic :: Games/Entertainment :: First Person Shooters 18 :: 80 :: 82
3150 81 2000031601 80 18 realtimestrategy Real Time Strategy Real Time strategy games 0 0 Topic :: Games/Entertainment :: Real Time Strategy 18 :: 80 :: 81
3151 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
3152 71 2000031601 18 18 education Education Programs and tools for educating yourself or others. 0 0 Topic :: Education 18 :: 71
3153 73 2000031601 71 18 testing Testing Tools for testing someone's knowledge on a subject. 0 0 Topic :: Education :: Testing 18 :: 71 :: 73
3154 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
3155 66 2000031601 18 18 database Database Front ends, engines, and tools for database work. 0 0 Topic :: Database 18 :: 66
3156 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
3157 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
3158 63 2000032001 18 18 editors Text Editors Programs for editing code and documents. 0 0 Topic :: Text Editors 18 :: 63
3159 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
3160 70 2000031601 63 18 wordprocessors Word Processors WYSIWYG word processors. 0 0 Topic :: Text Editors :: Word Processors 18 :: 63 :: 70
3161 69 2000031601 63 18 documentation Documentation Tools for the creation and use of documentation. 0 0 Topic :: Text Editors :: Documentation 18 :: 63 :: 69
3162 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
3163 64 2000031601 63 18 emacs Emacs GNU Emacs and its imitators and tools. 0 0 Topic :: Text Editors :: Emacs 18 :: 63 :: 64
3164 125 2000031701 99 18 video Video Video capture, editing, and playback. 0 0 Topic :: Multimedia :: Video 18 :: 99 :: 125
3165 126 2000031701 125 18 capture Capture Video capture tools. 0 0 Topic :: Multimedia :: Video :: Capture 18 :: 99 :: 125 :: 126
3166 256 2000071101 125 18 nonlineareditor Non-Linear Editor Video Non-Linear Editors 0 0 Topic :: Multimedia :: Video :: Non-Linear Editor 18 :: 99 :: 125 :: 256
3167 128 2000031701 125 18 display Display Programs which display various video formats. 0 0 Topic :: Multimedia :: Video :: Display 18 :: 99 :: 125 :: 128
3168 127 2000031701 125 18 conversion Conversion Programs which convert between video formats. 0 0 Topic :: Multimedia :: Video :: Conversion 18 :: 99 :: 125 :: 127
3169 113 2000031701 99 18 sound Sound/Audio Tools for generating, editing, analyzing, and playing sound. 0 0 Topic :: Multimedia :: Sound/Audio 18 :: 99 :: 113
3170 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
3171 248 2000042801 113 18 midi MIDI Software related to MIDI synthesis and playback. 0 0 Topic :: Multimedia :: Sound/Audio :: MIDI 18 :: 99 :: 113 :: 248
3172 124 2000031701 113 18 speech Speech Speech manipulation and intepretation tools. 0 0 Topic :: Multimedia :: Sound/Audio :: Speech 18 :: 99 :: 113 :: 124
3173 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
3174 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
3175 121 2000031701 113 18 mixers Mixers Programs to mix audio. 0 0 Topic :: Multimedia :: Sound/Audio :: Mixers 18 :: 99 :: 113 :: 121
3176 120 2000031701 113 18 editors Editors Programs to edit/manipulate sound data. 0 0 Topic :: Multimedia :: Sound/Audio :: Editors 18 :: 99 :: 113 :: 120
3177 119 2000031701 113 18 conversion Conversion Programs to convert between audio formats. 0 0 Topic :: Multimedia :: Sound/Audio :: Conversion 18 :: 99 :: 113 :: 119
3178 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
3179 88 2000031601 87 18 finger Finger The Finger protocol for getting information about users. 0 0 Topic :: Internet :: Finger 18 :: 87 :: 88
3180 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
3181 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
3182 260 2000071401 52 18 SCCS SCCS SCCS 0 0 Topic :: Software Development :: Version Control :: SCCS 18 :: 45 :: 52 :: 260
3183 54 2000031601 52 18 rcs RCS Tools for RCS (Revision Control System). 0 0 Topic :: Software Development :: Version Control :: RCS 18 :: 45 :: 52 :: 54
3184 53 2000031601 52 18 cvs CVS Tools for CVS (Concurrent Versioning System). 0 0 Topic :: Software Development :: Version Control :: CVS 18 :: 45 :: 52 :: 53
3185 50 2000031601 45 18 objectbrokering Object Brokering Object brokering libraries and tools. 0 0 Topic :: Software Development :: Object Brokering 18 :: 45 :: 50
3186 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
3187 49 2000031601 45 18 interpreters Interpreters Programs for interpreting and executing high-level languages directly. 0 0 Topic :: Software Development :: Interpreters 18 :: 45 :: 49
3188 48 2000031601 45 18 compilers Compilers Programs for compiling high-level languges into machine code. 0 0 Topic :: Software Development :: Compilers 18 :: 45 :: 48
3189 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
3190 46 2000031601 45 18 build Build Tools Software for the build process. 0 0 Topic :: Software Development :: Build Tools 18 :: 45 :: 46
3191 43 2000031601 18 18 security Security Security-related software, to include system administration and cryptography. 0 0 Topic :: Security 18 :: 43
3192 44 2000031601 43 18 cryptography Cryptography Cryptography programs, algorithms, and libraries. 0 0 Topic :: Security :: Cryptography 18 :: 43 :: 44
3193 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
3194 98 2000031601 97 18 mathematics Mathematics Software to support pure and applied mathematics. 0 0 Topic :: Scientific/Engineering :: Mathematics 18 :: 97 :: 98
3195 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
3196 266 2000081601 97 18 medical Medical Science Apps. Medical / BioMedical Science Apps. 0 0 Topic :: Scientific/Engineering :: Medical Science Apps. 18 :: 97 :: 266
3197 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
3198 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
3199 135 2000032001 97 18 visualization Visualization Software for scientific visualization. 0 0 Topic :: Scientific/Engineering :: Visualization 18 :: 97 :: 135
3200 134 2000032001 97 18 astronomy Astronomy Software and tools related to astronomy. 0 0 Topic :: Scientific/Engineering :: Astronomy 18 :: 97 :: 134
3201 133 2000032001 97 18 ai Artificial Intelligence Artificial Intelligence. 0 0 Topic :: Scientific/Engineering :: Artificial Intelligence 18 :: 97 :: 133
3202 87 2000031601 18 18 internet Internet Tools to assist human access to the Internet. 0 0 Topic :: Internet 18 :: 87
3203 270 2000083101 87 18 WAP WAP Wireless Access Protocol 0 0 Topic :: Internet :: WAP 18 :: 87 :: 270
3204 245 2000042701 87 18 loganalysis Log Analysis Software to help analyze various log files. 0 0 Topic :: Internet :: Log Analysis 18 :: 87 :: 245
3205 149 2000032001 87 18 dns Name Service (DNS) Domain name system servers and utilities. 0 0 Topic :: Internet :: Name Service (DNS) 18 :: 87 :: 149
3206 90 2000031601 87 18 www WWW/HTTP Programs and tools for the World Wide Web. 0 0 Topic :: Internet :: WWW/HTTP 18 :: 87 :: 90
3207 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
3208 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
3209 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
3210 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
3211 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
3212 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
3213 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
3214 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
3215 91 2000031601 90 18 browsers Browsers Web Browsers 0 0 Topic :: Internet :: WWW/HTTP :: Browsers 18 :: 87 :: 90 :: 91
3216 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
3217 80 2000031601 18 18 games Games/Entertainment Games and Entertainment software. 0 0 Topic :: Games/Entertainment 18 :: 80
3218 18 2000031601 0 0 topic Topic Topic categorization. 0 0 Topic 18
3219 20 2000032401 18 18 communications Communications Programs intended to facilitate communication between people. 0 0 Topic :: Communications 18 :: 20
3220 27 2000031601 20 18 conferencing Conferencing Software to support real-time conferencing over the Internet. 0 0 Topic :: Communications :: Conferencing 18 :: 20 :: 27
3221 22 2000031601 20 18 chat Chat Programs to support real-time communication over the Internet. 0 0 Topic :: Communications :: Chat 18 :: 20 :: 22
3222 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
3223 25 2000031601 22 18 talk Unix Talk Programs to support Unix Talk protocol. 0 0 Topic :: Communications :: Chat :: Unix Talk 18 :: 20 :: 22 :: 25
3224 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
3225 23 2000031601 22 18 icq ICQ Programs to support ICQ. 0 0 Topic :: Communications :: Chat :: ICQ 18 :: 20 :: 22 :: 23
3226 21 2000031601 20 18 bbs BBS Bulletin Board systems. 0 0 Topic :: Communications :: BBS 18 :: 20 :: 21
3227 251 2000050101 20 18 filesharing File Sharing Software for person-to-person online file sharing. 0 0 Topic :: Communications :: File Sharing 18 :: 20 :: 251
3228 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
3229 286 2001032001 251 18 gnutella Gnutella Projects based around the gnutella protocol. 0 0 Topic :: Communications :: File Sharing :: Gnutella 18 :: 20 :: 251 :: 286
3230 247 2000042701 20 18 telephony Telephony Telephony related applications, to include automated voice response systems. 0 0 Topic :: Communications :: Telephony 18 :: 20 :: 247
3231 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
3232 39 2000031601 20 18 usenet Usenet News Software to support USENET news. 0 0 Topic :: Communications :: Usenet News 18 :: 20 :: 39
3233 38 2000031601 20 18 hamradio Ham Radio Tools and resources for amateur radio. 0 0 Topic :: Communications :: Ham Radio 18 :: 20 :: 38
3234 37 2000031601 20 18 fido FIDO Tools for FIDOnet mail and echoes. 0 0 Topic :: Communications :: FIDO 18 :: 20 :: 37
3235 36 2000031601 20 18 fax Fax Tools for sending and receiving facsimile messages. 0 0 Topic :: Communications :: Fax 18 :: 20 :: 36
3236 28 2000031601 20 18 email Email Programs for sending, processing, and handling electronic mail. 0 0 Topic :: Communications :: Email 18 :: 20 :: 28
3237 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
3238 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
3239 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
3240 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
3241 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
3242 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
3243 29 2000031601 28 18 filters Filters Content-driven filters and dispatchers for Email. 0 0 Topic :: Communications :: Email :: Filters 18 :: 20 :: 28 :: 29
3244 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
3245 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
3246 297 2001041701 14 13 vsl Vovida Software License Vovida Software License 0 0 License :: OSI Approved :: Vovida Software License 13 :: 14 :: 297
3247 195 2000032001 14 13 zlib zlib/libpng License zlib/libpng License 0 0 License :: OSI Approved :: zlib/libpng License 13 :: 14 :: 195
3248 194 2000032001 14 13 python Python License Python License 0 0 License :: OSI Approved :: Python License 13 :: 14 :: 194
3249 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
3250 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
3251 191 2000032001 14 13 ibm IBM Public License IBM Public License 0 0 License :: OSI Approved :: IBM Public License 13 :: 14 :: 191
3252 190 2000032001 14 13 qpl QT Public License (QPL) QT Public License 0 0 License :: OSI Approved :: QT Public License (QPL) 13 :: 14 :: 190
3253 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
3254 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
3255 199 2000032101 0 0 os Operating System What operating system the program requires to run, if any. 0 0 Operating System 199
3256 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
3257 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
3258 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
3259 203 2000041101 202 199 freebsd FreeBSD FreeBSD 0 0 Operating System :: POSIX :: BSD :: FreeBSD 199 :: 200 :: 202 :: 203
3260 204 2000032101 202 199 netbsd NetBSD NetBSD 0 0 Operating System :: POSIX :: BSD :: NetBSD 199 :: 200 :: 202 :: 204
3261 205 2000032101 202 199 openbsd OpenBSD OpenBSD 0 0 Operating System :: POSIX :: BSD :: OpenBSD 199 :: 200 :: 202 :: 205
3262 206 2000032101 202 199 bsdos BSD/OS BSD/OS 0 0 Operating System :: POSIX :: BSD :: BSD/OS 199 :: 200 :: 202 :: 206
3263 207 2000032101 200 199 sun SunOS/Solaris Any Sun Microsystems OS. 0 0 Operating System :: POSIX :: SunOS/Solaris 199 :: 200 :: 207
3264 208 2000032101 200 199 sco SCO SCO 0 0 Operating System :: POSIX :: SCO 199 :: 200 :: 208
3265 209 2000032101 200 199 hpux HP-UX HP-UX 0 0 Operating System :: POSIX :: HP-UX 199 :: 200 :: 209
3266 210 2000032101 200 199 aix AIX AIX 0 0 Operating System :: POSIX :: AIX 199 :: 200 :: 210
3267 211 2000032101 200 199 irix IRIX IRIX 0 0 Operating System :: POSIX :: IRIX 199 :: 200 :: 211
3268 212 2000032101 200 199 other Other Other specific POSIX OS, specified in description. 0 0 Operating System :: POSIX :: Other 199 :: 200 :: 212
3269 282 2000121901 18 18 Sociology Sociology Social / Informational - Family / etc. 0 0 Topic :: Sociology 18 :: 282
3270 214 2000032101 199 199 microsoft Microsoft Microsoft operating systems. 0 0 Operating System :: Microsoft 199 :: 214
3271 215 2000032101 214 199 msdos MS-DOS Microsoft Disk Operating System (DOS) 0 0 Operating System :: Microsoft :: MS-DOS 199 :: 214 :: 215
3272 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
3273 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
3274 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
3275 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
3276 220 2000032101 199 199 os2 OS/2 OS/2 0 0 Operating System :: OS/2 199 :: 220
3277 221 2000032101 199 199 macos MacOS MacOS 0 0 Operating System :: MacOS 199 :: 221
3278 222 2000032101 216 199 wince Windows CE Windows CE 0 0 Operating System :: Microsoft :: Windows :: Windows CE 199 :: 214 :: 216 :: 222
3279 223 2000032101 199 199 palmos PalmOS PalmOS (for Palm Pilot) 0 0 Operating System :: PalmOS 199 :: 223
3280 224 2000032101 199 199 beos BeOS BeOS 0 0 Operating System :: BeOS 199 :: 224
3281 225 2000032101 0 0 environment Environment Run-time environment required for this program. 0 0 Environment 225
3282 226 2000041101 225 225 console Console (Text Based) Console-based programs. 0 0 Environment :: Console (Text Based) 225 :: 226
3283 227 2000032401 226 225 curses Curses Curses-based software. 0 0 Environment :: Console (Text Based) :: Curses 225 :: 226 :: 227
3284 228 2000040701 226 225 newt Newt Newt 0 0 Environment :: Console (Text Based) :: Newt 225 :: 226 :: 228
3285 229 2000040701 225 225 x11 X11 Applications Programs that run in an X windowing environment. 0 0 Environment :: X11 Applications 225 :: 229
3286 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
3287 231 2000040701 229 225 gnome Gnome Programs designed to run in a Gnome environment. 0 0 Environment :: X11 Applications :: Gnome 225 :: 229 :: 231
3288 232 2000040701 229 225 kde KDE Programs designed to run in a KDE environment. 0 0 Environment :: X11 Applications :: KDE 225 :: 229 :: 232
3289 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
3290 283 2000121901 282 18 History History History / Informational 0 0 Topic :: Sociology :: History 18 :: 282 :: 283
3291 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
3292 236 2000040701 199 199 other Other OS Program is designe for a nonlisted operating system. 0 0 Operating System :: Other OS 199 :: 236
3293 237 2000041001 225 225 web Web Environment This software is designed for a web environment. 0 0 Environment :: Web Environment 225 :: 237
3294 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
3295 284 2000121901 282 18 Genealogy Genealogy Family History / Genealogy 0 0 Topic :: Sociology :: Genealogy 18 :: 282 :: 284
3296 240 2000041301 200 199 gnuhurd GNU Hurd GNU Hurd 0 0 Operating System :: POSIX :: GNU Hurd 199 :: 200 :: 240
3297 55 2000031601 18 18 desktop Desktop Environment Accessories, managers, and utilities for your GUI desktop. 0 0 Topic :: Desktop Environment 18 :: 55
3298 58 2000031601 55 18 gnome Gnome Software for the Gnome desktop. 0 0 Topic :: Desktop Environment :: Gnome 18 :: 55 :: 58
3299 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
3300 61 2000031601 57 18 themes Themes Themes for KDE. 0 0 Topic :: Desktop Environment :: K Desktop Environment (KDE) :: Themes 18 :: 55 :: 57 :: 61
3301 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
3302 59 2000031601 56 18 enlightenment Enlightenment Software for the Enlightenment window manager. 0 0 Topic :: Desktop Environment :: Window Managers :: Enlightenment 18 :: 55 :: 56 :: 59
3303 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
3304 62 2000031601 55 18 screensavers Screen Savers Screen savers and lockers. 0 0 Topic :: Desktop Environment :: Screen Savers 18 :: 55 :: 62
3305 259 2000071401 45 18 codegen Code Generators Code Generators 0 0 Topic :: Software Development :: Code Generators 18 :: 45 :: 259
3306 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
3307 160 2000032001 0 0 language Programming Language Language in which this program was written, or was meant to support. 0 0 Programming Language 160
3308 161 2000032001 160 160 apl APL APL 0 0 Programming Language :: APL 160 :: 161
3309 164 2000032001 160 160 c C C 0 0 Programming Language :: C 160 :: 164
3310 162 2000032001 160 160 assembly Assembly Assembly-level programs. Platform specific. 0 0 Programming Language :: Assembly 160 :: 162
3311 163 2000051001 160 160 ada Ada Ada 0 0 Programming Language :: Ada 160 :: 163
3312 165 2000032001 160 160 cpp C++ C++ 0 0 Programming Language :: C++ 160 :: 165
3313 166 2000032401 160 160 eiffel Eiffel Eiffel 0 0 Programming Language :: Eiffel 160 :: 166
3314 167 2000032001 160 160 euler Euler Euler 0 0 Programming Language :: Euler 160 :: 167
3315 168 2000032001 160 160 forth Forth Forth 0 0 Programming Language :: Forth 160 :: 168
3316 169 2000032001 160 160 fortran Fortran Fortran 0 0 Programming Language :: Fortran 160 :: 169
3317 170 2000032001 160 160 lisp Lisp Lisp 0 0 Programming Language :: Lisp 160 :: 170
3318 171 2000041101 160 160 logo Logo Logo 0 0 Programming Language :: Logo 160 :: 171
3319 172 2000032001 160 160 ml ML ML 0 0 Programming Language :: ML 160 :: 172
3320 173 2000032001 160 160 modula Modula Modula-2 or Modula-3 0 0 Programming Language :: Modula 160 :: 173
3321 174 2000032001 160 160 objectivec Objective C Objective C 0 0 Programming Language :: Objective C 160 :: 174
3322 175 2000032001 160 160 pascal Pascal Pascal 0 0 Programming Language :: Pascal 160 :: 175
3323 176 2000032001 160 160 perl Perl Perl 0 0 Programming Language :: Perl 160 :: 176
3324 177 2000032001 160 160 prolog Prolog Prolog 0 0 Programming Language :: Prolog 160 :: 177
3325 178 2000032001 160 160 python Python Python 0 0 Programming Language :: Python 160 :: 178
3326 179 2000032001 160 160 rexx Rexx Rexx 0 0 Programming Language :: Rexx 160 :: 179
3327 180 2000032001 160 160 simula Simula Simula 0 0 Programming Language :: Simula 160 :: 180
3328 181 2000032001 160 160 smalltalk Smalltalk Smalltalk 0 0 Programming Language :: Smalltalk 160 :: 181
3329 182 2000032001 160 160 tcl Tcl Tcl 0 0 Programming Language :: Tcl 160 :: 182
3330 183 2000032001 160 160 php PHP PHP 0 0 Programming Language :: PHP 160 :: 183
3331 263 2000080401 160 160 euphoria Euphoria Euphoria programming language - http://www.rapideuphoria.com/ 0 0 Programming Language :: Euphoria 160 :: 263
3332 264 2000080701 160 160 erlang Erlang Erlang - developed by Ericsson - http://www.erlang.org/ 0 0 Programming Language :: Erlang 160 :: 264
3333 267 2000082001 160 160 zope Zope Zope Object Publishing 0 0 Programming Language :: Zope 160 :: 267
3334 269 2000082801 160 160 asm Assembly ASM programming 0 0 Programming Language :: Assembly 160 :: 269
3335 271 2000092001 160 160 csharp C# Microsoft's C++/Java Language 0 0 Programming Language :: C# 160 :: 271
3336 273 2000102001 160 160 Pike Pike Pike, see http://pike.roxen.com/. 0 0 Programming Language :: Pike 160 :: 273
3337 184 2000032001 160 160 asp ASP Active Server Pages 0 0 Programming Language :: ASP 160 :: 184
3338 185 2000032001 160 160 shell Unix Shell Unix Shell 0 0 Programming Language :: Unix Shell 160 :: 185
3339 186 2000032001 160 160 visualbasic Visual Basic Visual Basic 0 0 Programming Language :: Visual Basic 160 :: 186
3340 198 2000032001 160 160 java Java Java 0 0 Programming Language :: Java 160 :: 198
3341 213 2000032101 160 160 other Other Other programming language, specified in description. 0 0 Programming Language :: Other 160 :: 213
3342 242 2000042701 160 160 scheme Scheme Scheme programming language. 0 0 Programming Language :: Scheme 160 :: 242
3343 254 2000071101 160 160 plsql PL/SQL PL/SQL Programming Language 0 0 Programming Language :: PL/SQL 160 :: 254
3344 255 2000071101 160 160 progress PROGRESS PROGRESS Programming Language 0 0 Programming Language :: PROGRESS 160 :: 255
3345 258 2000071101 160 160 objectpascal Object Pascal Object Pascal 0 0 Programming Language :: Object Pascal 160 :: 258
3346 261 2000072501 160 160 xbasic XBasic XBasic programming language 0 0 Programming Language :: XBasic 160 :: 261
3347 262 2000073101 160 160 coldfusion Cold Fusion Cold Fusion Language 0 0 Programming Language :: Cold Fusion 160 :: 262
3348 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
3349 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
3350 187 2000032001 14 13 bsd BSD License BSD License 0 0 License :: OSI Approved :: BSD License 13 :: 14 :: 187
3351 17 2000032001 14 13 artistic Artistic License The Perl Artistic License 0 0 License :: OSI Approved :: Artistic License 13 :: 14 :: 17
3352 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
3353 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
3354 280 2000110101 160 160 JavaScript JavaScript Java Scripting Language 0 0 Programming Language :: JavaScript 160 :: 280
3355 281 2000111401 160 160 REBOL REBOL REBOL Programming Language 0 0 Programming Language :: REBOL 160 :: 281
3356 265 2001032001 160 160 Delphi Delphi/Kylix Borland/Inprise Delphi or other Object-Pascal based languages 0 0 Programming Language :: Delphi/Kylix 160 :: 265
3357 293 2001032001 160 160 ruby Ruby Ruby programming language 0 0 Programming Language :: Ruby 160 :: 293
3358 45 2000031601 18 18 development Software Development Software used to aid software development. 0 0 Topic :: Software Development 18 :: 45
3359 99 2000031601 18 18 multimedia Multimedia Graphics, sound, video, and multimedia. 0 0 Topic :: Multimedia 18 :: 99
3360 296 2001041701 14 13 asl Apache Software License Apache Software License 0 0 License :: OSI Approved :: Apache Software License 13 :: 14 :: 296
3361 274 2000102401 0 0 natlanguage Natural Language The oral/written language for the development and use of this software. 0 0 Natural Language 274
3362 295 2001040601 274 274 russian Russian Projects having something to do with Russian Language 0 0 Natural Language :: Russian 274 :: 295
3363 275 2000102401 274 274 english English English 0 0 Natural Language :: English 274 :: 275
3364 276 2000102401 274 274 french French French 0 0 Natural Language :: French 274 :: 276
3365 277 2000102401 274 274 spanish Spanish Spanish 0 0 Natural Language :: Spanish 274 :: 277
3366 278 2000102601 274 274 japanese Japanese Projects using the Japanese language 0 0 Natural Language :: Japanese 274 :: 278
3367 279 2000102601 274 274 german German Projects using the German language 0 0 Natural Language :: German 274 :: 279
3368 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
3369 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
3370 302 2001041701 14 13 sleepycat Sleepycat License Sleepycat License 0 0 License :: OSI Approved :: Sleepycat License 13 :: 14 :: 302
3375 COPY trove_group_link (trove_group_id, trove_cat_id, trove_cat_version, group_id, trove_cat_root) FROM stdin;
3380 COPY user_bookmarks (bookmark_id, user_id, bookmark_url, bookmark_title) FROM stdin;
3385 COPY user_diary (id, user_id, date_posted, summary, details, is_public) FROM stdin;
3390 COPY user_diary_monitor (monitor_id, monitored_user, user_id) FROM stdin;
3395 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;
3400 COPY user_metric (ranking, user_id, times_ranked, avg_raters_importance, avg_rating, metric, percentile, importance_factor) FROM stdin;
3405 COPY user_metric0 (ranking, user_id, times_ranked, avg_raters_importance, avg_rating, metric, percentile, importance_factor) FROM stdin;
3410 COPY user_preferences (user_id, preference_name, dead1, set_date, preference_value) FROM stdin;
3415 COPY user_ratings (rated_by, user_id, rate_field, rating) FROM stdin;
3420 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;
3421 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
3422 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
3427 COPY project_sums_agg (group_id, "type", count) FROM stdin;
3432 COPY prdb_dbs (dbid, group_id, dbname, dbusername, dbuserpass, requestdate, dbtype, created_by, state) FROM stdin;
3437 COPY prdb_states (stateid, statename) FROM stdin;
3442 COPY prdb_types (dbtypeid, dbservername, dbsoftware) FROM stdin;
3447 COPY prweb_vhost (vhostid, vhost_name, docdir, cgidir, group_id) FROM stdin;
3452 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;
3453 100 1 Default Default Data - Dont Edit 3 0 0 2592000 \N \N 0 \N 0 \N
3458 COPY artifact_perm (id, group_artifact_id, user_id, perm_level) FROM stdin;
3463 COPY artifact_status (id, status_name) FROM stdin;
3470 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;
3475 COPY artifact_history (id, artifact_id, field_name, old_value, mod_by, entrydate) FROM stdin;
3480 COPY artifact_file (id, artifact_id, description, bin_data, filename, filesize, filetype, adddate, submitted_by) FROM stdin;
3485 COPY artifact_message (id, artifact_id, submitted_by, from_email, adddate, body) FROM stdin;
3490 COPY artifact_monitor (id, artifact_id, user_id, email) FROM stdin;
3495 COPY artifact_canned_responses (id, group_artifact_id, title, body) FROM stdin;
3500 COPY artifact_counts_agg (group_artifact_id, count, open_count) FROM stdin;
3506 COPY stats_site_pages_by_day ("month", "day", site_page_views) FROM stdin;
3511 COPY massmail_queue (id, "type", subject, message, queued_date, last_userid, failed_date, finished_date) FROM stdin;
3516 COPY stats_agg_site_by_group ("month", "day", group_id, count) FROM stdin;
3521 COPY stats_project_metric ("month", "day", ranking, percentile, group_id) FROM stdin;
3526 COPY stats_agg_logo_by_group ("month", "day", group_id, count) FROM stdin;
3531 COPY stats_subd_pages ("month", "day", group_id, pages) FROM stdin;
3536 COPY stats_cvs_user ("month", "day", group_id, user_id, checkouts, commits, adds) FROM stdin;
3541 COPY stats_cvs_group ("month", "day", group_id, checkouts, commits, adds) FROM stdin;
3546 COPY stats_project_developers ("month", "day", group_id, developers) FROM stdin;
3551 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;
3556 COPY stats_site ("month", "day", uniq_users, sessions, total_users, new_users, new_projects) FROM stdin;
3561 COPY activity_log ("day", "hour", group_id, browser, ver, platform, "time", page, "type") FROM stdin;
3566 COPY user_metric_history ("month", "day", user_id, ranking, metric) FROM stdin;
3571 COPY frs_dlstats_filetotal_agg (file_id, downloads) FROM stdin;
3576 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;
3581 COPY stats_site_pages_by_month ("month", site_page_views) FROM stdin;
3586 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;
3591 COPY trove_agg (trove_cat_id, group_id, group_name, unix_group_name, status, register_time, short_description, percentile, ranking) FROM stdin;
3596 COPY trove_treesums (trove_treesums_id, trove_cat_id, limit_1, subprojects) FROM stdin;
3601 COPY frs_dlstats_file (ip_address, file_id, "month", "day", user_id) FROM stdin;
3606 COPY group_cvs_history (id, group_id, user_name, cvs_commits, cvs_commits_wk, cvs_adds, cvs_adds_wk) FROM stdin;
3611 COPY themes (theme_id, dirname, fullname, enabled) FROM stdin;
3612 1 gforge Default Theme t
3614 4 ultralite Ultra-Lite Text-only Theme t
3619 COPY supported_languages (language_id, name, filename, classname, language_code) FROM stdin;
3620 1 English English.class English en
3621 2 Japanese Japanese.class Japanese ja
3622 4 Spanish Spanish.class Spanish es
3623 5 Thai Thai.class Thai th
3624 6 German German.class German de
3625 8 Italian Italian.class Italian it
3626 10 Swedish Swedish.class Swedish sv
3627 12 Dutch Dutch.class Dutch nl
3628 14 Catalan Catalan.class Catalan ca
3629 22 Korean Korean.class Korean ko
3630 20 Bulgarian Bulgarian.class Bulgarian bg
3631 17 Russian Russian.class Russian ru
3632 7 French French.class French fr
3633 23 Smpl.Chinese SimplifiedChinese.class SimplifiedChinese zh-cn
3634 11 Trad.Chinese Chinese.class Chinese zh-tw
3635 16 Pt. Brazilian PortugueseBrazilian.class PortugueseBrazilian pt-br
3640 COPY skills_data_types (type_id, type_name) FROM stdin;
3650 COPY skills_data (skills_data_id, user_id, "type", title, "start", finish, keywords) FROM stdin;
3655 COPY project_category (category_id, group_project_id, category_name) FROM stdin;
3661 COPY project_task_artifact (project_task_id, artifact_id) FROM stdin;
3666 COPY project_messages (project_message_id, project_task_id, body, posted_by, postdate) FROM stdin;
3671 COPY plugins (plugin_id, plugin_name, plugin_desc) FROM stdin;
3674 3 cvstracker CVS Tracker Integration
3679 COPY group_plugin (group_plugin_id, group_id, plugin_id) FROM stdin;
3688 COPY user_plugin (user_plugin_id, user_id, plugin_id) FROM stdin;
3693 COPY cron_history (rundate, job, output) FROM stdin;
3698 COPY country_code (country_name, ccode) FROM stdin;
3707 ANTIGUA AND BARBUDA AG
3725 BOSNIA AND HERZEGOVINA BA
3729 BRITISH INDIAN OCEAN TERRITORY IO
3730 BRUNEI DARUSSALAM BN
3739 CENTRAL AFRICAN REPUBLIC CF
3744 COCOS (KEELING) ISLANDS CC
3748 CONGO, THE DEMOCRATIC REPUBLIC OF THE CD
3759 DOMINICAN REPUBLIC DO
3764 EQUATORIAL GUINEA GQ
3768 FALKLAND ISLANDS (MALVINAS) FK
3775 FRENCH SOUTHERN TERRITORIES TF
3792 HEARD ISLAND AND MCDONALD ISLANDS HM
3793 HOLY SEE (VATICAN CITY STATE) VA
3800 IRAN, ISLAMIC REPUBLIC OF IR
3811 KOREA, DEMOCRATIC PEOPLE'S REPUBLIC OF KP
3812 KOREA, REPUBLIC OF KR
3815 LAO PEOPLE'S DEMOCRATIC REPUBLIC LA
3820 LIBYAN ARAB JAMAHIRIYA LY
3825 MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF MK
3838 MICRONESIA, FEDERATED STATES OF FM
3839 MOLDOVA, REPUBLIC OF MD
3850 NETHERLANDS ANTILLES AN
3858 NORTHERN MARIANA ISLANDS MP
3863 PALESTINIAN TERRITORY, OCCUPIED PS
3876 RUSSIAN FEDERATION RU
3879 SAINT KITTS AND NEVIS KN
3881 SAINT PIERRE AND MIQUELON PM
3882 SAINT VINCENT AND THE GRENADINES VC
3885 SAO TOME AND PRINCIPE ST
3896 SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS GS
3901 SVALBARD AND JAN MAYEN SJ
3905 SYRIAN ARAB REPUBLIC SY
3906 TAIWAN, PROVINCE OF CHINA TW
3908 TANZANIA, UNITED REPUBLIC OF TZ
3913 TRINIDAD AND TOBAGO TT
3917 TURKS AND CAICOS ISLANDS TC
3921 UNITED ARAB EMIRATES AE
3923 UNITED STATES MINOR OUTLYING ISLANDS UM
3929 VIRGIN ISLANDS, BRITISH VG
3930 VIRGIN ISLANDS, U.S. VI
3931 WALLIS AND FUTUNA WF
3942 COPY licenses (license_id, license_name) FROM stdin;
3944 101 GNU General Public License (GPL)
3945 102 GNU Library Public License (LGPL)
3948 105 Artistic License
3949 106 Mozilla Public License 1.0 (MPL)
3950 107 Qt Public License (QPL)
3951 108 IBM Public License
3952 109 MITRE Collaborative Virtual Workspace License (CVW License)
3953 110 Ricoh Source Code Public License
3955 112 zlib/libpng License
3956 113 Apache Software License
3957 114 Vovida Software License 1.0
3958 115 Sun Internet Standards Source License (SISSL)
3959 116 Intel Open Source License
3960 117 Mozilla Public License 1.1 (MPL 1.1)
3961 118 Jabber Open Source License
3962 119 Nokia Open Source License
3963 120 Sleepycat License
3964 121 Nethack General Public License
3965 122 IBM Common Public License
3966 123 Apple Public Source License
3969 126 Other/Proprietary License
3974 COPY user_type (type_id, type_name) FROM stdin;
3981 COPY role (role_id, group_id, role_name) FROM stdin;
3984 3 2 Senior Developer
3985 4 2 Junior Developer
3989 8 3 Senior Developer
3990 9 3 Junior Developer
3994 13 4 Senior Developer
3995 14 4 Junior Developer
3999 18 1 Senior Developer
4000 19 1 Junior Developer
4007 COPY project_perm (id, group_project_id, user_id, perm_level) FROM stdin;
4012 COPY forum_perm (id, group_forum_id, user_id, perm_level) FROM stdin;
4017 COPY role_setting (role_id, section_name, ref_id, value) FROM stdin;
4172 COPY artifact_extra_field_list (extra_field_id, group_artifact_id, field_name, field_type, attribute1, attribute2, is_required, alias) FROM stdin;
4177 COPY artifact_extra_field_elements (element_id, extra_field_id, element_name, status_id) FROM stdin;
4182 COPY artifact_extra_field_data (data_id, artifact_id, field_data, extra_field_id) FROM stdin;
4187 COPY project_counts_agg (group_project_id, count, open_count) FROM stdin;
4193 COPY project_task_external_order (project_task_id, external_id) FROM stdin;
4198 COPY group_join_request (group_id, user_id, comments, request_date) FROM stdin;
4203 COPY artifact_type_monitor (group_artifact_id, user_id) FROM stdin;
4208 COPY plugin_cvstracker_data_artifact (id, kind, group_artifact_id, project_task_id) FROM stdin;
4213 COPY plugin_cvstracker_data_master (id, holder_id, log_text, file, prev_version, actual_version, author, cvs_date) FROM stdin;
4218 COPY nss_groups (user_id, group_id, name, gid) FROM stdin;
4221 0 4 peerrating 10004
4225 0 4 scm_peerrating 50004
4226 0 1 scm_gforge 50001
4231 COPY nss_usergroups (uid, gid, user_id, group_id, user_name, unix_group_name) FROM stdin;
4236 COPY deleted_mailing_lists (mailing_list_name, delete_date, isdeleted) FROM stdin;
4241 COPY deleted_groups (unix_group_name, delete_date, isdeleted) FROM stdin;
4246 COPY artifact_query (artifact_query_id, group_artifact_id, user_id, query_name) FROM stdin;
4251 COPY artifact_query_fields (artifact_query_id, query_field_type, query_field_id, query_field_values) FROM stdin;
4256 COPY form_keys (key_id, "key", creation_date, is_used) FROM stdin;
4261 COPY forum_attachment (attachmentid, userid, dateline, filename, filedata, visible, counter, filesize, msg_id, filehash) FROM stdin;
4266 COPY forum_attachment_type (extension, mimetype, size, width, height, enabled) FROM stdin;
4267 gif a:1:{i:0;s:23:"Content-type: image/gif";} 20000 620 280 1
4268 jpeg a:1:{i:0;s:24:"Content-type: image/jpeg";} 20000 620 280 1
4269 jpg a:1:{i:0;s:24:"Content-type: image/jpeg";} 100000 0 0 1
4270 jpe a:1:{i:0;s:24:"Content-type: image/jpeg";} 20000 620 280 1
4271 png a:1:{i:0;s:23:"Content-type: image/png";} 20000 620 280 1
4272 doc a:2:{i:0;s:20:"Accept-ranges: bytes";i:1;s:32:"Content-type: application/msword";} 20000 0 0 1
4273 pdf a:1:{i:0;s:29:"Content-type: application/pdf";} 20000 0 0 1
4274 bmp a:1:{i:0;s:26:"Content-type: image/bitmap";} 20000 620 280 1
4275 psd a:1:{i:0;s:29:"Content-type: unknown/unknown";} 20000 0 0 1
4276 zip a:1:{i:0;s:29:"Content-type: application/zip";} 100000 0 0 1
4277 txt a:1:{i:0;s:24:"Content-type: plain/text";} 20000 0 0 1
4282 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;
4287 COPY forum_pending_attachment (attachmentid, userid, dateline, filename, filedata, visible, counter, filesize, msg_id, filehash) FROM stdin;
4292 COPY group_activity_monitor (group_id, user_id, filter) FROM stdin;
4297 CREATE INDEX db_images_group ON db_images USING btree (group_id);
4301 CREATE INDEX doc_groups_group ON doc_groups USING btree (group_id);
4305 CREATE INDEX forum_forumid_msgid ON forum USING btree (group_forum_id, msg_id);
4309 CREATE INDEX forum_group_forum_id ON forum USING btree (group_forum_id);
4313 CREATE INDEX forum_forumid_threadid_mostrece ON forum USING btree (group_forum_id, thread_id, most_recent_date);
4317 CREATE INDEX forum_threadid_isfollowupto ON forum USING btree (thread_id, is_followup_to);
4321 CREATE INDEX forum_forumid_isfollto_mostrece ON forum USING btree (group_forum_id, is_followup_to, most_recent_date);
4325 CREATE INDEX forum_group_list_group_id ON forum_group_list USING btree (group_id);
4329 CREATE INDEX frs_file_date ON frs_file USING btree (post_date);
4333 CREATE INDEX frs_file_release_id ON frs_file USING btree (release_id);
4337 CREATE INDEX package_group_id ON frs_package USING btree (group_id);
4341 CREATE INDEX frs_release_package ON frs_release USING btree (package_id);
4345 CREATE INDEX group_history_group_id ON group_history USING btree (group_id);
4349 CREATE UNIQUE INDEX group_unix_uniq ON groups USING btree (unix_group_name);
4353 CREATE INDEX groups_type ON groups USING btree (type_id);
4357 CREATE INDEX groups_public ON groups USING btree (is_public);
4361 CREATE INDEX groups_status ON groups USING btree (status);
4365 CREATE INDEX mail_group_list_group ON mail_group_list USING btree (group_id);
4369 CREATE INDEX news_bytes_group ON news_bytes USING btree (group_id);
4373 CREATE INDEX news_bytes_approved ON news_bytes USING btree (is_approved);
4377 CREATE INDEX news_bytes_forum ON news_bytes USING btree (forum_id);
4381 CREATE INDEX news_group_date ON news_bytes USING btree (group_id, post_date);
4385 CREATE INDEX news_approved_date ON news_bytes USING btree (is_approved, post_date);
4389 CREATE INDEX people_job_group_id ON people_job USING btree (group_id);
4393 CREATE INDEX project_group_list_group_id ON project_group_list USING btree (group_id);
4397 CREATE INDEX project_history_task_id ON project_history USING btree (project_task_id);
4401 CREATE INDEX project_metric_group ON project_metric USING btree (group_id);
4405 CREATE INDEX projecttask_projid_status ON project_task USING btree (group_project_id, status_id);
4409 CREATE INDEX projectweeklymetric_ranking ON project_weekly_metric USING btree (ranking);
4413 CREATE INDEX project_metric_weekly_group ON project_weekly_metric USING btree (group_id);
4417 CREATE INDEX session_user_id ON user_session USING btree (user_id);
4421 CREATE INDEX session_time ON user_session USING btree ("time");
4425 CREATE INDEX snippet_language ON snippet USING btree ("language");
4429 CREATE INDEX snippet_category ON snippet USING btree (category);
4433 CREATE INDEX snippet_package_language ON snippet_package USING btree ("language");
4437 CREATE INDEX snippet_package_category ON snippet_package USING btree (category);
4441 CREATE INDEX snippet_package_item_pkg_ver ON snippet_package_item USING btree (snippet_package_version_id);
4445 CREATE INDEX snippet_package_version_pkg_id ON snippet_package_version USING btree (snippet_package_id);
4449 CREATE INDEX snippet_version_snippet_id ON snippet_version USING btree (snippet_id);
4453 CREATE INDEX pages_by_day_day ON stats_agg_pages_by_day USING btree ("day");
4457 CREATE INDEX survey_questions_group ON survey_questions USING btree (group_id);
4461 CREATE INDEX survey_rating_aggregate_type_id ON survey_rating_aggregate USING btree ("type", id);
4465 CREATE INDEX survey_rating_responses_user_ty ON survey_rating_response USING btree (user_id, "type", id);
4469 CREATE INDEX survey_rating_responses_type_id ON survey_rating_response USING btree ("type", id);
4473 CREATE INDEX survey_responses_group_id ON survey_responses USING btree (group_id);
4477 CREATE INDEX survey_responses_user_survey_qu ON survey_responses USING btree (user_id, survey_id, question_id);
4481 CREATE INDEX survey_responses_survey_questio ON survey_responses USING btree (survey_id, question_id);
4485 CREATE INDEX surveys_group ON surveys USING btree (group_id);
4489 CREATE INDEX user_bookmark_user_id ON user_bookmarks USING btree (user_id);
4493 CREATE INDEX user_diary_user_date ON user_diary USING btree (user_id, date_posted);
4497 CREATE INDEX user_metric0_user_id ON user_metric0 USING btree (user_id);
4501 CREATE INDEX user_ratings_user_id ON user_ratings USING btree (user_id);
4505 CREATE UNIQUE INDEX users_namename_uniq ON users USING btree (user_name);
4509 CREATE INDEX users_status ON users USING btree (status);
4513 CREATE UNIQUE INDEX idx_prdb_dbname ON prdb_dbs USING btree (dbname);
4517 CREATE INDEX idx_vhost_groups ON prweb_vhost USING btree (group_id);
4521 CREATE UNIQUE INDEX idx_vhost_hostnames ON prweb_vhost USING btree (vhost_name);
4525 CREATE INDEX artgrouplist_groupid_public ON artifact_group_list USING btree (group_id, is_public);
4529 CREATE UNIQUE INDEX artperm_groupartifactid_userid ON artifact_perm USING btree (group_artifact_id, user_id);
4533 CREATE INDEX art_groupartid ON artifact USING btree (group_artifact_id);
4537 CREATE INDEX art_groupartid_statusid ON artifact USING btree (group_artifact_id, status_id);
4541 CREATE INDEX art_groupartid_assign ON artifact USING btree (group_artifact_id, assigned_to);
4545 CREATE INDEX art_groupartid_submit ON artifact USING btree (group_artifact_id, submitted_by);
4549 CREATE INDEX art_submit_status ON artifact USING btree (submitted_by, status_id);
4553 CREATE INDEX art_assign_status ON artifact USING btree (assigned_to, status_id);
4557 CREATE INDEX art_groupartid_artifactid ON artifact USING btree (group_artifact_id, artifact_id);
4561 CREATE INDEX arthistory_artid_entrydate ON artifact_history USING btree (artifact_id, entrydate);
4565 CREATE INDEX artfile_artid_adddate ON artifact_file USING btree (artifact_id, adddate);
4569 CREATE INDEX artmessage_artid_adddate ON artifact_message USING btree (artifact_id, adddate);
4573 CREATE INDEX artifactcannedresponses_groupid ON artifact_canned_responses USING btree (group_artifact_id);
4577 CREATE UNIQUE INDEX statssitepgsbyday_oid ON stats_site_pages_by_day USING btree (oid);
4581 CREATE INDEX statssitepagesbyday_month_day ON stats_site_pages_by_day USING btree ("month", "day");
4585 CREATE UNIQUE INDEX statsaggsitebygrp_oid ON stats_agg_site_by_group USING btree (oid);
4589 CREATE UNIQUE INDEX statssitebygroup_month_day_grou ON stats_agg_site_by_group USING btree ("month", "day", group_id);
4593 CREATE UNIQUE INDEX statsprojectmetric_oid ON stats_project_metric USING btree (oid);
4597 CREATE UNIQUE INDEX statsprojectmetric_month_day_gr ON stats_project_metric USING btree ("month", "day", group_id);
4601 CREATE UNIQUE INDEX statsagglogobygrp_oid ON stats_agg_logo_by_group USING btree (oid);
4605 CREATE UNIQUE INDEX statslogobygroup_month_day_grou ON stats_agg_logo_by_group USING btree ("month", "day", group_id);
4609 CREATE UNIQUE INDEX statssubdpages_oid ON stats_subd_pages USING btree (oid);
4613 CREATE UNIQUE INDEX statssubdpages_month_day_group ON stats_subd_pages USING btree ("month", "day", group_id);
4617 CREATE UNIQUE INDEX statscvsgrp_oid ON stats_cvs_group USING btree (oid);
4621 CREATE UNIQUE INDEX statscvsgroup_month_day_group ON stats_cvs_group USING btree ("month", "day", group_id);
4625 CREATE UNIQUE INDEX statsprojectdevelop_oid ON stats_project_developers USING btree (oid);
4629 CREATE UNIQUE INDEX statsprojectdev_month_day_group ON stats_project_developers USING btree ("month", "day", group_id);
4633 CREATE UNIQUE INDEX statsproject_oid ON stats_project USING btree (oid);
4637 CREATE UNIQUE INDEX statsproject_month_day_group ON stats_project USING btree ("month", "day", group_id);
4641 CREATE UNIQUE INDEX statssite_oid ON stats_site USING btree (oid);
4645 CREATE UNIQUE INDEX statssite_month_day ON stats_site USING btree ("month", "day");
4649 CREATE INDEX statsprojectmonths_groupid ON stats_project_months USING btree (group_id);
4653 CREATE INDEX statsprojectmonths_groupid_mont ON stats_project_months USING btree (group_id, "month");
4657 CREATE INDEX statssitemonths_month ON stats_site_months USING btree ("month");
4661 CREATE INDEX troveagg_trovecatid_ranking ON trove_agg USING btree (trove_cat_id, ranking);
4665 CREATE INDEX groupcvshistory_groupid ON group_cvs_history USING btree (group_id);
4669 CREATE UNIQUE INDEX themes_theme_id_key ON themes USING btree (theme_id);
4673 CREATE UNIQUE INDEX project_categor_category_id_key ON project_category USING btree (category_id);
4677 CREATE INDEX projectcategory_groupprojectid ON project_category USING btree (group_project_id);
4681 CREATE UNIQUE INDEX project_messa_project_messa_key ON project_messages USING btree (project_message_id);
4685 CREATE UNIQUE INDEX plugins_plugin_name_key ON plugins USING btree (plugin_name);
4689 CREATE INDEX cronhist_rundate ON cron_history USING btree (rundate);
4693 CREATE UNIQUE INDEX role_groupidroleid ON role USING btree (group_id, role_id);
4697 CREATE INDEX artifactextrafldlmts_extrafieldid ON artifact_extra_field_elements USING btree (extra_field_id);
4701 CREATE INDEX artifactextrafielddata_artifactid ON artifact_extra_field_data USING btree (artifact_id);
4705 CREATE INDEX artifactextrafieldlist_groupartid ON artifact_extra_field_list USING btree (group_artifact_id);
4709 CREATE INDEX artmonitor_useridartid ON artifact_monitor USING btree (user_id, artifact_id);
4713 CREATE INDEX cronhist_jobrundate ON cron_history USING btree (job, rundate);
4717 CREATE INDEX filemodulemonitor_useridfilemoduleid ON filemodule_monitor USING btree (user_id, filemodule_id);
4721 CREATE INDEX forummonitoredforums_useridforumid ON forum_monitored_forums USING btree (user_id, forum_id);
4725 CREATE INDEX groupplugin_groupid ON group_plugin USING btree (group_id);
4729 CREATE INDEX prdbdbs_groupid ON prdb_dbs USING btree (group_id);
4733 CREATE INDEX prdbstates_stateid ON prdb_states USING btree (stateid);
4737 CREATE INDEX projectassigned_assignedtotaskid ON project_assigned_to USING btree (assigned_to_id, project_task_id);
4741 CREATE INDEX projectdep_isdepon_projtaskid ON project_dependencies USING btree (is_dependent_on_task_id, project_task_id);
4745 CREATE INDEX projectmsgs_projtaskidpostdate ON project_messages USING btree (project_task_id, postdate);
4749 CREATE INDEX projectperm_useridgroupprojid ON project_perm USING btree (user_id, group_project_id);
4753 CREATE INDEX projecttaskartifact_artidprojtaskid ON project_task_artifact USING btree (artifact_id, project_task_id);
4757 CREATE UNIQUE INDEX supportedlanguage_code ON supported_languages USING btree (language_code);
4761 CREATE INDEX trovecat_parentid ON trove_cat USING btree (parent);
4765 CREATE INDEX trovegrouplink_groupidcatid ON trove_group_link USING btree (group_id, trove_cat_id);
4769 CREATE INDEX userdiarymon_useridmonitoredid ON user_diary_monitor USING btree (user_id, monitored_user);
4773 CREATE INDEX usergroup_useridgroupid ON user_group USING btree (user_id, group_id);
4777 CREATE UNIQUE INDEX usermetric_userid ON user_metric USING btree (user_id);
4781 CREATE INDEX usermetrichistory_useridmonthday ON user_metric_history USING btree (user_id, "month", "day");
4785 CREATE INDEX plugin_cvstracker_group_artifact_id ON plugin_cvstracker_data_artifact USING btree (group_artifact_id);
4789 CREATE INDEX docgroups_parentdocgroup ON doc_groups USING btree (parent_doc_group);
4793 CREATE INDEX docdata_groupid ON doc_data USING btree (group_id, doc_group);
4797 ALTER TABLE ONLY canned_responses
4798 ADD CONSTRAINT canned_responses_pkey PRIMARY KEY (response_id);
4802 ALTER TABLE ONLY db_images
4803 ADD CONSTRAINT db_images_pkey PRIMARY KEY (id);
4807 ALTER TABLE ONLY doc_data
4808 ADD CONSTRAINT doc_data_pkey PRIMARY KEY (docid);
4812 ALTER TABLE ONLY doc_groups
4813 ADD CONSTRAINT doc_groups_pkey PRIMARY KEY (doc_group);
4817 ALTER TABLE ONLY doc_states
4818 ADD CONSTRAINT doc_states_pkey PRIMARY KEY (stateid);
4822 ALTER TABLE ONLY forum
4823 ADD CONSTRAINT forum_pkey PRIMARY KEY (msg_id);
4827 ALTER TABLE ONLY forum_agg_msg_count
4828 ADD CONSTRAINT forum_agg_msg_count_pkey PRIMARY KEY (group_forum_id);
4832 ALTER TABLE ONLY forum_group_list
4833 ADD CONSTRAINT forum_group_list_pkey PRIMARY KEY (group_forum_id);
4837 ALTER TABLE ONLY frs_file
4838 ADD CONSTRAINT frs_file_pkey PRIMARY KEY (file_id);
4842 ALTER TABLE ONLY frs_filetype
4843 ADD CONSTRAINT frs_filetype_pkey PRIMARY KEY (type_id);
4847 ALTER TABLE ONLY frs_package
4848 ADD CONSTRAINT frs_package_pkey PRIMARY KEY (package_id);
4852 ALTER TABLE ONLY frs_processor
4853 ADD CONSTRAINT frs_processor_pkey PRIMARY KEY (processor_id);
4857 ALTER TABLE ONLY frs_release
4858 ADD CONSTRAINT frs_release_pkey PRIMARY KEY (release_id);
4862 ALTER TABLE ONLY frs_status
4863 ADD CONSTRAINT frs_status_pkey PRIMARY KEY (status_id);
4867 ALTER TABLE ONLY group_history
4868 ADD CONSTRAINT group_history_pkey PRIMARY KEY (group_history_id);
4872 ALTER TABLE ONLY groups
4873 ADD CONSTRAINT groups_pkey PRIMARY KEY (group_id);
4877 ALTER TABLE ONLY mail_group_list
4878 ADD CONSTRAINT mail_group_list_pkey PRIMARY KEY (group_list_id);
4882 ALTER TABLE ONLY news_bytes
4883 ADD CONSTRAINT news_bytes_pkey PRIMARY KEY (id);
4887 ALTER TABLE ONLY people_job
4888 ADD CONSTRAINT people_job_pkey PRIMARY KEY (job_id);
4892 ALTER TABLE ONLY people_job_category
4893 ADD CONSTRAINT people_job_category_pkey PRIMARY KEY (category_id);
4897 ALTER TABLE ONLY people_job_inventory
4898 ADD CONSTRAINT people_job_inventory_pkey PRIMARY KEY (job_inventory_id);
4902 ALTER TABLE ONLY people_job_status
4903 ADD CONSTRAINT people_job_status_pkey PRIMARY KEY (status_id);
4907 ALTER TABLE ONLY people_skill
4908 ADD CONSTRAINT people_skill_pkey PRIMARY KEY (skill_id);
4912 ALTER TABLE ONLY people_skill_inventory
4913 ADD CONSTRAINT people_skill_inventory_pkey PRIMARY KEY (skill_inventory_id);
4917 ALTER TABLE ONLY people_skill_level
4918 ADD CONSTRAINT people_skill_level_pkey PRIMARY KEY (skill_level_id);
4922 ALTER TABLE ONLY people_skill_year
4923 ADD CONSTRAINT people_skill_year_pkey PRIMARY KEY (skill_year_id);
4927 ALTER TABLE ONLY project_group_list
4928 ADD CONSTRAINT project_group_list_pkey PRIMARY KEY (group_project_id);
4932 ALTER TABLE ONLY project_history
4933 ADD CONSTRAINT project_history_pkey PRIMARY KEY (project_history_id);
4937 ALTER TABLE ONLY project_metric
4938 ADD CONSTRAINT project_metric_pkey PRIMARY KEY (ranking);
4942 ALTER TABLE ONLY project_metric_tmp1
4943 ADD CONSTRAINT project_metric_tmp1_pkey PRIMARY KEY (ranking);
4947 ALTER TABLE ONLY project_status
4948 ADD CONSTRAINT project_status_pkey PRIMARY KEY (status_id);
4952 ALTER TABLE ONLY project_task
4953 ADD CONSTRAINT project_task_pkey PRIMARY KEY (project_task_id);
4957 ALTER TABLE ONLY user_session
4958 ADD CONSTRAINT session_pkey PRIMARY KEY (session_hash);
4962 ALTER TABLE ONLY snippet
4963 ADD CONSTRAINT snippet_pkey PRIMARY KEY (snippet_id);
4967 ALTER TABLE ONLY snippet_package
4968 ADD CONSTRAINT snippet_package_pkey PRIMARY KEY (snippet_package_id);
4972 ALTER TABLE ONLY snippet_package_item
4973 ADD CONSTRAINT snippet_package_item_pkey PRIMARY KEY (snippet_package_item_id);
4977 ALTER TABLE ONLY snippet_package_version
4978 ADD CONSTRAINT snippet_package_version_pkey PRIMARY KEY (snippet_package_version_id);
4982 ALTER TABLE ONLY snippet_version
4983 ADD CONSTRAINT snippet_version_pkey PRIMARY KEY (snippet_version_id);
4987 ALTER TABLE ONLY survey_question_types
4988 ADD CONSTRAINT survey_question_types_pkey PRIMARY KEY (id);
4992 ALTER TABLE ONLY survey_questions
4993 ADD CONSTRAINT survey_questions_pkey PRIMARY KEY (question_id);
4997 ALTER TABLE ONLY surveys
4998 ADD CONSTRAINT surveys_pkey PRIMARY KEY (survey_id);
5002 ALTER TABLE ONLY trove_cat
5003 ADD CONSTRAINT trove_cat_pkey PRIMARY KEY (trove_cat_id);
5007 ALTER TABLE ONLY user_bookmarks
5008 ADD CONSTRAINT user_bookmarks_pkey PRIMARY KEY (bookmark_id);
5012 ALTER TABLE ONLY user_diary
5013 ADD CONSTRAINT user_diary_pkey PRIMARY KEY (id);
5017 ALTER TABLE ONLY user_metric
5018 ADD CONSTRAINT user_metric_pkey PRIMARY KEY (ranking);
5022 ALTER TABLE ONLY user_metric0
5023 ADD CONSTRAINT user_metric0_pkey PRIMARY KEY (ranking);
5027 ALTER TABLE ONLY users
5028 ADD CONSTRAINT users_pkey PRIMARY KEY (user_id);
5032 ALTER TABLE ONLY prdb_dbs
5033 ADD CONSTRAINT prdb_dbs_pkey PRIMARY KEY (dbid);
5037 ALTER TABLE ONLY prdb_types
5038 ADD CONSTRAINT prdb_types_pkey PRIMARY KEY (dbtypeid);
5042 ALTER TABLE ONLY prweb_vhost
5043 ADD CONSTRAINT prweb_vhost_pkey PRIMARY KEY (vhostid);
5047 ALTER TABLE ONLY artifact_group_list
5048 ADD CONSTRAINT artifact_group_list_pkey PRIMARY KEY (group_artifact_id);
5052 ALTER TABLE ONLY artifact_perm
5053 ADD CONSTRAINT artifact_perm_pkey PRIMARY KEY (id);
5057 ALTER TABLE ONLY artifact_status
5058 ADD CONSTRAINT artifact_status_pkey PRIMARY KEY (id);
5062 ALTER TABLE ONLY artifact
5063 ADD CONSTRAINT artifact_pkey PRIMARY KEY (artifact_id);
5067 ALTER TABLE ONLY artifact_history
5068 ADD CONSTRAINT artifact_history_pkey PRIMARY KEY (id);
5072 ALTER TABLE ONLY artifact_file
5073 ADD CONSTRAINT artifact_file_pkey PRIMARY KEY (id);
5077 ALTER TABLE ONLY artifact_message
5078 ADD CONSTRAINT artifact_message_pkey PRIMARY KEY (id);
5082 ALTER TABLE ONLY artifact_canned_responses
5083 ADD CONSTRAINT artifact_canned_responses_pkey PRIMARY KEY (id);
5087 ALTER TABLE ONLY massmail_queue
5088 ADD CONSTRAINT massmail_queue_pkey PRIMARY KEY (id);
5092 ALTER TABLE ONLY supported_languages
5093 ADD CONSTRAINT supported_languages_pkey PRIMARY KEY (language_id);
5097 ALTER TABLE ONLY skills_data_types
5098 ADD CONSTRAINT skills_data_types_pkey PRIMARY KEY (type_id);
5102 ALTER TABLE ONLY skills_data
5103 ADD CONSTRAINT skills_data_pkey PRIMARY KEY (skills_data_id);
5107 ALTER TABLE ONLY plugins
5108 ADD CONSTRAINT plugins_pkey PRIMARY KEY (plugin_id);
5112 ALTER TABLE ONLY group_plugin
5113 ADD CONSTRAINT group_plugin_pkey PRIMARY KEY (group_plugin_id);
5117 ALTER TABLE ONLY country_code
5118 ADD CONSTRAINT country_code_pkey PRIMARY KEY (ccode);
5122 ALTER TABLE ONLY user_type
5123 ADD CONSTRAINT user_type_type_id_key UNIQUE (type_id);
5127 ALTER TABLE ONLY artifact_extra_field_data
5128 ADD CONSTRAINT artifact_extra_field_data_pkey PRIMARY KEY (data_id);
5132 ALTER TABLE ONLY group_join_request
5133 ADD CONSTRAINT group_join_request_pkey PRIMARY KEY (group_id, user_id);
5137 ALTER TABLE ONLY artifact_type_monitor
5138 ADD CONSTRAINT artifact_type_monitor_pkey PRIMARY KEY (group_artifact_id, user_id);
5142 ALTER TABLE ONLY artifact_counts_agg
5143 ADD CONSTRAINT artifact_counts_agg_pkey PRIMARY KEY (group_artifact_id);
5147 ALTER TABLE ONLY artifact_extra_field_elements
5148 ADD CONSTRAINT artifact_extra_field_elements_pkey PRIMARY KEY (element_id);
5152 ALTER TABLE ONLY artifact_extra_field_list
5153 ADD CONSTRAINT artifact_extra_field_list_pkey PRIMARY KEY (extra_field_id);
5157 ALTER TABLE ONLY artifact_monitor
5158 ADD CONSTRAINT artifact_monitor_pkey PRIMARY KEY (artifact_id, user_id);
5162 ALTER TABLE ONLY filemodule_monitor
5163 ADD CONSTRAINT filemodule_monitor_pkey PRIMARY KEY (filemodule_id, user_id);
5167 ALTER TABLE ONLY forum_monitored_forums
5168 ADD CONSTRAINT forum_monitored_forums_pkey PRIMARY KEY (forum_id, user_id);
5172 ALTER TABLE ONLY forum_perm
5173 ADD CONSTRAINT forum_perm_pkey PRIMARY KEY (group_forum_id, user_id);
5177 ALTER TABLE ONLY forum_saved_place
5178 ADD CONSTRAINT forum_saved_place_pkey PRIMARY KEY (user_id, forum_id);
5182 ALTER TABLE ONLY frs_dlstats_filetotal_agg
5183 ADD CONSTRAINT frs_dlstats_filetotal_agg_pkey PRIMARY KEY (file_id);
5187 ALTER TABLE ONLY licenses
5188 ADD CONSTRAINT licenses_pkey PRIMARY KEY (license_id);
5192 ALTER TABLE ONLY project_assigned_to
5193 ADD CONSTRAINT project_assigned_to_pkey PRIMARY KEY (project_task_id, assigned_to_id);
5197 ALTER TABLE ONLY project_counts_agg
5198 ADD CONSTRAINT project_counts_agg_pkey PRIMARY KEY (group_project_id);
5202 ALTER TABLE ONLY project_dependencies
5203 ADD CONSTRAINT project_dependencies_pkey PRIMARY KEY (project_task_id, is_dependent_on_task_id);
5207 ALTER TABLE ONLY project_perm
5208 ADD CONSTRAINT project_perm_id_key PRIMARY KEY (group_project_id, user_id);
5212 ALTER TABLE ONLY project_sums_agg
5213 ADD CONSTRAINT project_sums_agg_pkey PRIMARY KEY (group_id, "type");
5217 ALTER TABLE ONLY project_task_artifact
5218 ADD CONSTRAINT project_task_artifact_pkey PRIMARY KEY (project_task_id, artifact_id);
5222 ALTER TABLE ONLY project_task_external_order
5223 ADD CONSTRAINT project_task_external_order_pkey PRIMARY KEY (project_task_id);
5227 ALTER TABLE ONLY role
5228 ADD CONSTRAINT role_role_id_pkey PRIMARY KEY (role_id);
5232 ALTER TABLE ONLY role_setting
5233 ADD CONSTRAINT role_setting_pkey PRIMARY KEY (role_id, section_name, ref_id);
5237 ALTER TABLE ONLY trove_group_link
5238 ADD CONSTRAINT trove_group_link_pkey PRIMARY KEY (trove_cat_id, group_id, trove_cat_version);
5242 ALTER TABLE ONLY trove_treesums
5243 ADD CONSTRAINT trove_treesums_pkey PRIMARY KEY (trove_cat_id);
5247 ALTER TABLE ONLY user_diary_monitor
5248 ADD CONSTRAINT user_diary_monitor_pkey PRIMARY KEY (monitored_user, user_id);
5252 ALTER TABLE ONLY user_group
5253 ADD CONSTRAINT user_group_pkey PRIMARY KEY (group_id, user_id);
5257 ALTER TABLE ONLY user_metric_history
5258 ADD CONSTRAINT user_metric_history_pkey PRIMARY KEY ("month", "day", user_id);
5262 ALTER TABLE ONLY user_plugin
5263 ADD CONSTRAINT user_plugin_pkey PRIMARY KEY (user_id, plugin_id);
5267 ALTER TABLE ONLY user_preferences
5268 ADD CONSTRAINT user_preferences_pkey PRIMARY KEY (user_id, preference_name);
5272 ALTER TABLE ONLY user_ratings
5273 ADD CONSTRAINT user_ratings_pkey PRIMARY KEY (rated_by, user_id, rate_field);
5277 ALTER TABLE ONLY plugin_cvstracker_data_artifact
5278 ADD CONSTRAINT plugin_cvstracker_artifact_pkey PRIMARY KEY (id);
5282 ALTER TABLE ONLY plugin_cvstracker_data_master
5283 ADD CONSTRAINT plugin_cvstracker_master_pkey PRIMARY KEY (id);
5287 ALTER TABLE ONLY artifact_query
5288 ADD CONSTRAINT artifact_query_pkey PRIMARY KEY (artifact_query_id);
5292 ALTER TABLE ONLY artifact_query_fields
5293 ADD CONSTRAINT artifact_query_elements_pkey PRIMARY KEY (artifact_query_id, query_field_type, query_field_id);
5297 ALTER TABLE ONLY form_keys
5298 ADD CONSTRAINT form_keys_pkey PRIMARY KEY (key_id);
5302 ALTER TABLE ONLY form_keys
5303 ADD CONSTRAINT "key" UNIQUE ("key");
5307 ALTER TABLE ONLY forum_attachment
5308 ADD CONSTRAINT forum_attachment_pkey PRIMARY KEY (attachmentid);
5312 ALTER TABLE ONLY forum_attachment_type
5313 ADD CONSTRAINT forum_attachment_type_pkey PRIMARY KEY (extension);
5317 ALTER TABLE ONLY forum_pending_messages
5318 ADD CONSTRAINT forum_pending_messages_pkey PRIMARY KEY (msg_id);
5322 ALTER TABLE ONLY forum_pending_attachment
5323 ADD CONSTRAINT forum_pending_attachment_pkey PRIMARY KEY (attachmentid);
5327 ALTER TABLE ONLY group_activity_monitor
5328 ADD CONSTRAINT group_activity_monitor_pkey PRIMARY KEY (group_id, user_id);
5332 ALTER TABLE ONLY users
5333 ADD CONSTRAINT users_typeid FOREIGN KEY (type_id) REFERENCES user_type(type_id) MATCH FULL;
5337 ALTER TABLE ONLY role
5338 ADD CONSTRAINT "$1" FOREIGN KEY (group_id) REFERENCES groups(group_id) ON DELETE CASCADE;
5342 ALTER TABLE ONLY project_perm
5343 ADD CONSTRAINT "$1" FOREIGN KEY (group_project_id) REFERENCES project_group_list(group_project_id) ON DELETE CASCADE;
5347 ALTER TABLE ONLY project_perm
5348 ADD CONSTRAINT "$2" FOREIGN KEY (user_id) REFERENCES users(user_id) MATCH FULL;
5352 ALTER TABLE ONLY forum_perm
5353 ADD CONSTRAINT "$1" FOREIGN KEY (group_forum_id) REFERENCES forum_group_list(group_forum_id) ON DELETE CASCADE;
5357 ALTER TABLE ONLY forum_perm
5358 ADD CONSTRAINT "$2" FOREIGN KEY (user_id) REFERENCES users(user_id) MATCH FULL;
5362 ALTER TABLE ONLY project_task_external_order
5363 ADD CONSTRAINT "$1" FOREIGN KEY (project_task_id) REFERENCES project_task(project_task_id) MATCH FULL ON DELETE CASCADE;
5367 ALTER TABLE ONLY group_join_request
5368 ADD CONSTRAINT "$1" FOREIGN KEY (group_id) REFERENCES groups(group_id) ON DELETE CASCADE;
5372 ALTER TABLE ONLY group_join_request
5373 ADD CONSTRAINT "$2" FOREIGN KEY (user_id) REFERENCES users(user_id);
5377 ALTER TABLE ONLY artifact_type_monitor
5378 ADD CONSTRAINT "$1" FOREIGN KEY (group_artifact_id) REFERENCES artifact_group_list(group_artifact_id) ON DELETE CASCADE;
5382 ALTER TABLE ONLY artifact_type_monitor
5383 ADD CONSTRAINT "$2" FOREIGN KEY (user_id) REFERENCES users(user_id);
5387 ALTER TABLE ONLY user_group
5388 ADD CONSTRAINT usergroup_roleid FOREIGN KEY (role_id) REFERENCES role(role_id) MATCH FULL;
5392 ALTER TABLE ONLY role_setting
5393 ADD CONSTRAINT rolesetting_roleroleid FOREIGN KEY (role_id) REFERENCES role(role_id) ON DELETE CASCADE;
5397 ALTER TABLE ONLY plugin_cvstracker_data_master
5398 ADD CONSTRAINT "$1" FOREIGN KEY (holder_id) REFERENCES plugin_cvstracker_data_artifact(id);
5402 ALTER TABLE ONLY plugin_cvstracker_data_master
5403 ADD CONSTRAINT "$2" FOREIGN KEY (author) REFERENCES users(user_name);
5407 ALTER TABLE ONLY artifact_query
5408 ADD CONSTRAINT artquery_groupartid_fk FOREIGN KEY (group_artifact_id) REFERENCES artifact_group_list(group_artifact_id) ON DELETE CASCADE;
5412 ALTER TABLE ONLY artifact_query_fields
5413 ADD CONSTRAINT artqueryelmnt_artqueryid FOREIGN KEY (artifact_query_id) REFERENCES artifact_query(artifact_query_id) ON DELETE CASCADE;
5417 ALTER TABLE ONLY mail_group_list
5418 ADD CONSTRAINT mail_group_list_group_id_fkey FOREIGN KEY (group_id) REFERENCES groups(group_id) ON DELETE CASCADE;
5422 ALTER TABLE ONLY forum_attachment
5423 ADD CONSTRAINT "$1" FOREIGN KEY (msg_id) REFERENCES forum(msg_id) ON DELETE CASCADE;
5427 ALTER TABLE ONLY forum_attachment
5428 ADD CONSTRAINT "$2" FOREIGN KEY (userid) REFERENCES users(user_id) ON DELETE SET DEFAULT;
5432 ALTER TABLE ONLY forum_pending_messages
5433 ADD CONSTRAINT forum_pending_messages_group_forum_id_fkey FOREIGN KEY (group_forum_id) REFERENCES forum_group_list(group_forum_id) ON DELETE CASCADE;
5437 ALTER TABLE ONLY forum_pending_attachment
5438 ADD CONSTRAINT forum_pending_attachment_msg_id_fkey FOREIGN KEY (msg_id) REFERENCES forum_pending_messages(msg_id) ON DELETE CASCADE;
5442 ALTER TABLE ONLY forum_pending_attachment
5443 ADD CONSTRAINT forum_pending_attachment_userid_fkey FOREIGN KEY (userid) REFERENCES users(user_id) ON DELETE SET DEFAULT;
5447 ALTER TABLE ONLY group_activity_monitor
5448 ADD CONSTRAINT group_id FOREIGN KEY (group_id) REFERENCES groups(group_id) ON DELETE CASCADE;
5452 ALTER TABLE ONLY group_activity_monitor
5453 ADD CONSTRAINT userid_fk FOREIGN KEY (user_id) REFERENCES users(user_id);
5457 CREATE CONSTRAINT TRIGGER user_group_user_id_fk
5458 AFTER INSERT OR UPDATE ON user_group
5460 NOT DEFERRABLE INITIALLY IMMEDIATE
5462 EXECUTE PROCEDURE "RI_FKey_check_ins"('user_group_user_id_fk', 'user_group', 'users', 'FULL', 'user_id', 'user_id');
5466 CREATE CONSTRAINT TRIGGER user_group_user_id_fk
5467 AFTER DELETE ON users
5469 NOT DEFERRABLE INITIALLY IMMEDIATE
5471 EXECUTE PROCEDURE "RI_FKey_noaction_del"('user_group_user_id_fk', 'user_group', 'users', 'FULL', 'user_id', 'user_id');
5475 CREATE CONSTRAINT TRIGGER user_group_user_id_fk
5476 AFTER UPDATE ON users
5478 NOT DEFERRABLE INITIALLY IMMEDIATE
5480 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('user_group_user_id_fk', 'user_group', 'users', 'FULL', 'user_id', 'user_id');
5484 CREATE CONSTRAINT TRIGGER user_group_group_id_fk
5485 AFTER INSERT OR UPDATE ON user_group
5487 NOT DEFERRABLE INITIALLY IMMEDIATE
5489 EXECUTE PROCEDURE "RI_FKey_check_ins"('user_group_group_id_fk', 'user_group', 'groups', 'FULL', 'group_id', 'group_id');
5493 CREATE CONSTRAINT TRIGGER user_group_group_id_fk
5494 AFTER DELETE ON groups
5496 NOT DEFERRABLE INITIALLY IMMEDIATE
5498 EXECUTE PROCEDURE "RI_FKey_noaction_del"('user_group_group_id_fk', 'user_group', 'groups', 'FULL', 'group_id', 'group_id');
5502 CREATE CONSTRAINT TRIGGER user_group_group_id_fk
5503 AFTER UPDATE ON groups
5505 NOT DEFERRABLE INITIALLY IMMEDIATE
5507 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('user_group_group_id_fk', 'user_group', 'groups', 'FULL', 'group_id', 'group_id');
5511 CREATE CONSTRAINT TRIGGER forum_posted_by_fk
5512 AFTER INSERT OR UPDATE ON forum
5514 NOT DEFERRABLE INITIALLY IMMEDIATE
5516 EXECUTE PROCEDURE "RI_FKey_check_ins"('forum_posted_by_fk', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
5520 CREATE CONSTRAINT TRIGGER forum_posted_by_fk
5521 AFTER DELETE ON users
5523 NOT DEFERRABLE INITIALLY IMMEDIATE
5525 EXECUTE PROCEDURE "RI_FKey_noaction_del"('forum_posted_by_fk', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
5529 CREATE CONSTRAINT TRIGGER forum_posted_by_fk
5530 AFTER UPDATE ON users
5532 NOT DEFERRABLE INITIALLY IMMEDIATE
5534 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('forum_posted_by_fk', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
5538 CREATE CONSTRAINT TRIGGER forum_group_forum_id_fk
5539 AFTER INSERT OR UPDATE ON forum
5540 FROM forum_group_list
5541 NOT DEFERRABLE INITIALLY IMMEDIATE
5543 EXECUTE PROCEDURE "RI_FKey_check_ins"('forum_group_forum_id_fk', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
5547 CREATE CONSTRAINT TRIGGER forum_group_forum_id_fk
5548 AFTER DELETE ON forum_group_list
5550 NOT DEFERRABLE INITIALLY IMMEDIATE
5552 EXECUTE PROCEDURE "RI_FKey_noaction_del"('forum_group_forum_id_fk', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
5556 CREATE CONSTRAINT TRIGGER forum_group_forum_id_fk
5557 AFTER UPDATE ON forum_group_list
5559 NOT DEFERRABLE INITIALLY IMMEDIATE
5561 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('forum_group_forum_id_fk', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
5565 CREATE CONSTRAINT TRIGGER forum_group_list_group_id_fk
5566 AFTER INSERT OR UPDATE ON forum_group_list
5568 NOT DEFERRABLE INITIALLY IMMEDIATE
5570 EXECUTE PROCEDURE "RI_FKey_check_ins"('forum_group_list_group_id_fk', 'forum_group_list', 'groups', 'FULL', 'group_id', 'group_id');
5574 CREATE CONSTRAINT TRIGGER forum_group_list_group_id_fk
5575 AFTER DELETE ON groups
5576 FROM forum_group_list
5577 NOT DEFERRABLE INITIALLY IMMEDIATE
5579 EXECUTE PROCEDURE "RI_FKey_noaction_del"('forum_group_list_group_id_fk', 'forum_group_list', 'groups', 'FULL', 'group_id', 'group_id');
5583 CREATE CONSTRAINT TRIGGER forum_group_list_group_id_fk
5584 AFTER UPDATE ON groups
5585 FROM forum_group_list
5586 NOT DEFERRABLE INITIALLY IMMEDIATE
5588 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('forum_group_list_group_id_fk', 'forum_group_list', 'groups', 'FULL', 'group_id', 'group_id');
5592 CREATE CONSTRAINT TRIGGER forum_posted_by_fk
5593 AFTER INSERT OR UPDATE ON forum
5595 NOT DEFERRABLE INITIALLY IMMEDIATE
5597 EXECUTE PROCEDURE "RI_FKey_check_ins"('forum_posted_by_fk', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
5601 CREATE CONSTRAINT TRIGGER forum_posted_by_fk
5602 AFTER DELETE ON users
5604 NOT DEFERRABLE INITIALLY IMMEDIATE
5606 EXECUTE PROCEDURE "RI_FKey_noaction_del"('forum_posted_by_fk', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
5610 CREATE CONSTRAINT TRIGGER forum_posted_by_fk
5611 AFTER UPDATE ON users
5613 NOT DEFERRABLE INITIALLY IMMEDIATE
5615 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('forum_posted_by_fk', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
5619 CREATE CONSTRAINT TRIGGER forum_group_forum_id_fk
5620 AFTER INSERT OR UPDATE ON forum
5621 FROM forum_group_list
5622 NOT DEFERRABLE INITIALLY IMMEDIATE
5624 EXECUTE PROCEDURE "RI_FKey_check_ins"('forum_group_forum_id_fk', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
5628 CREATE CONSTRAINT TRIGGER forum_group_forum_id_fk
5629 AFTER DELETE ON forum_group_list
5631 NOT DEFERRABLE INITIALLY IMMEDIATE
5633 EXECUTE PROCEDURE "RI_FKey_noaction_del"('forum_group_forum_id_fk', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
5637 CREATE CONSTRAINT TRIGGER forum_group_forum_id_fk
5638 AFTER UPDATE ON forum_group_list
5640 NOT DEFERRABLE INITIALLY IMMEDIATE
5642 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('forum_group_forum_id_fk', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
5646 CREATE CONSTRAINT TRIGGER project_group_list_group_id_fk
5647 AFTER INSERT OR UPDATE ON project_group_list
5649 NOT DEFERRABLE INITIALLY IMMEDIATE
5651 EXECUTE PROCEDURE "RI_FKey_check_ins"('project_group_list_group_id_fk', 'project_group_list', 'groups', 'FULL', 'group_id', 'group_id');
5655 CREATE CONSTRAINT TRIGGER project_group_list_group_id_fk
5656 AFTER DELETE ON groups
5657 FROM project_group_list
5658 NOT DEFERRABLE INITIALLY IMMEDIATE
5660 EXECUTE PROCEDURE "RI_FKey_noaction_del"('project_group_list_group_id_fk', 'project_group_list', 'groups', 'FULL', 'group_id', 'group_id');
5664 CREATE CONSTRAINT TRIGGER project_group_list_group_id_fk
5665 AFTER UPDATE ON groups
5666 FROM project_group_list
5667 NOT DEFERRABLE INITIALLY IMMEDIATE
5669 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('project_group_list_group_id_fk', 'project_group_list', 'groups', 'FULL', 'group_id', 'group_id');
5673 CREATE CONSTRAINT TRIGGER project_task_created_by_fk
5674 AFTER INSERT OR UPDATE ON project_task
5676 NOT DEFERRABLE INITIALLY IMMEDIATE
5678 EXECUTE PROCEDURE "RI_FKey_check_ins"('project_task_created_by_fk', 'project_task', 'users', 'FULL', 'created_by', 'user_id');
5682 CREATE CONSTRAINT TRIGGER project_task_created_by_fk
5683 AFTER DELETE ON users
5685 NOT DEFERRABLE INITIALLY IMMEDIATE
5687 EXECUTE PROCEDURE "RI_FKey_noaction_del"('project_task_created_by_fk', 'project_task', 'users', 'FULL', 'created_by', 'user_id');
5691 CREATE CONSTRAINT TRIGGER project_task_created_by_fk
5692 AFTER UPDATE ON users
5694 NOT DEFERRABLE INITIALLY IMMEDIATE
5696 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('project_task_created_by_fk', 'project_task', 'users', 'FULL', 'created_by', 'user_id');
5700 CREATE CONSTRAINT TRIGGER project_task_status_id_fk
5701 AFTER INSERT OR UPDATE ON project_task
5703 NOT DEFERRABLE INITIALLY IMMEDIATE
5705 EXECUTE PROCEDURE "RI_FKey_check_ins"('project_task_status_id_fk', 'project_task', 'project_status', 'FULL', 'status_id', 'status_id');
5709 CREATE CONSTRAINT TRIGGER project_task_status_id_fk
5710 AFTER DELETE ON project_status
5712 NOT DEFERRABLE INITIALLY IMMEDIATE
5714 EXECUTE PROCEDURE "RI_FKey_noaction_del"('project_task_status_id_fk', 'project_task', 'project_status', 'FULL', 'status_id', 'status_id');
5718 CREATE CONSTRAINT TRIGGER project_task_status_id_fk
5719 AFTER UPDATE ON project_status
5721 NOT DEFERRABLE INITIALLY IMMEDIATE
5723 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('project_task_status_id_fk', 'project_task', 'project_status', 'FULL', 'status_id', 'status_id');
5727 CREATE CONSTRAINT TRIGGER users_languageid_fk
5728 AFTER INSERT OR UPDATE ON users
5729 FROM supported_languages
5730 NOT DEFERRABLE INITIALLY IMMEDIATE
5732 EXECUTE PROCEDURE "RI_FKey_check_ins"('users_languageid_fk', 'users', 'supported_languages', 'FULL', 'language', 'language_id');
5736 CREATE CONSTRAINT TRIGGER artifactmonitor_artifactid_fk
5737 AFTER INSERT OR UPDATE ON artifact_monitor
5739 NOT DEFERRABLE INITIALLY IMMEDIATE
5741 EXECUTE PROCEDURE "RI_FKey_check_ins"('artifactmonitor_artifactid_fk', 'artifact_monitor', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
5745 CREATE CONSTRAINT TRIGGER artifactmonitor_artifactid_fk
5746 AFTER DELETE ON artifact
5747 FROM artifact_monitor
5748 NOT DEFERRABLE INITIALLY IMMEDIATE
5750 EXECUTE PROCEDURE "RI_FKey_noaction_del"('artifactmonitor_artifactid_fk', 'artifact_monitor', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
5754 CREATE CONSTRAINT TRIGGER artifactmonitor_artifactid_fk
5755 AFTER UPDATE ON artifact
5756 FROM artifact_monitor
5757 NOT DEFERRABLE INITIALLY IMMEDIATE
5759 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('artifactmonitor_artifactid_fk', 'artifact_monitor', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
5763 CREATE CONSTRAINT TRIGGER artifactgroup_groupid_fk
5764 AFTER INSERT OR UPDATE ON artifact_group_list
5766 NOT DEFERRABLE INITIALLY IMMEDIATE
5768 EXECUTE PROCEDURE "RI_FKey_check_ins"('artifactgroup_groupid_fk', 'artifact_group_list', 'groups', 'FULL', 'group_id', 'group_id');
5772 CREATE CONSTRAINT TRIGGER artifactgroup_groupid_fk
5773 AFTER DELETE ON groups
5774 FROM artifact_group_list
5775 NOT DEFERRABLE INITIALLY IMMEDIATE
5777 EXECUTE PROCEDURE "RI_FKey_noaction_del"('artifactgroup_groupid_fk', 'artifact_group_list', 'groups', 'FULL', 'group_id', 'group_id');
5781 CREATE CONSTRAINT TRIGGER artifactgroup_groupid_fk
5782 AFTER UPDATE ON groups
5783 FROM artifact_group_list
5784 NOT DEFERRABLE INITIALLY IMMEDIATE
5786 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('artifactgroup_groupid_fk', 'artifact_group_list', 'groups', 'FULL', 'group_id', 'group_id');
5790 CREATE CONSTRAINT TRIGGER artifactperm_userid_fk
5791 AFTER INSERT OR UPDATE ON artifact_perm
5793 NOT DEFERRABLE INITIALLY IMMEDIATE
5795 EXECUTE PROCEDURE "RI_FKey_check_ins"('artifactperm_userid_fk', 'artifact_perm', 'users', 'FULL', 'user_id', 'user_id');
5799 CREATE CONSTRAINT TRIGGER artifactperm_userid_fk
5800 AFTER DELETE ON users
5802 NOT DEFERRABLE INITIALLY IMMEDIATE
5804 EXECUTE PROCEDURE "RI_FKey_noaction_del"('artifactperm_userid_fk', 'artifact_perm', 'users', 'FULL', 'user_id', 'user_id');
5808 CREATE CONSTRAINT TRIGGER artifactperm_userid_fk
5809 AFTER UPDATE ON users
5811 NOT DEFERRABLE INITIALLY IMMEDIATE
5813 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('artifactperm_userid_fk', 'artifact_perm', 'users', 'FULL', 'user_id', 'user_id');
5817 CREATE CONSTRAINT TRIGGER artifactperm_groupartifactid_fk
5818 AFTER INSERT OR UPDATE ON artifact_perm
5819 FROM artifact_group_list
5820 NOT DEFERRABLE INITIALLY IMMEDIATE
5822 EXECUTE PROCEDURE "RI_FKey_check_ins"('artifactperm_groupartifactid_fk', 'artifact_perm', 'artifact_group_list', 'FULL', 'group_artifact_id', 'group_artifact_id');
5826 CREATE CONSTRAINT TRIGGER artifactperm_groupartifactid_fk
5827 AFTER DELETE ON artifact_group_list
5829 NOT DEFERRABLE INITIALLY IMMEDIATE
5831 EXECUTE PROCEDURE "RI_FKey_noaction_del"('artifactperm_groupartifactid_fk', 'artifact_perm', 'artifact_group_list', 'FULL', 'group_artifact_id', 'group_artifact_id');
5835 CREATE CONSTRAINT TRIGGER artifactperm_groupartifactid_fk
5836 AFTER UPDATE ON artifact_group_list
5838 NOT DEFERRABLE INITIALLY IMMEDIATE
5840 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('artifactperm_groupartifactid_fk', 'artifact_perm', 'artifact_group_list', 'FULL', 'group_artifact_id', 'group_artifact_id');
5844 CREATE CONSTRAINT TRIGGER artifact_groupartifactid_fk
5845 AFTER INSERT OR UPDATE ON artifact
5846 FROM artifact_group_list
5847 NOT DEFERRABLE INITIALLY IMMEDIATE
5849 EXECUTE PROCEDURE "RI_FKey_check_ins"('artifact_groupartifactid_fk', 'artifact', 'artifact_group_list', 'FULL', 'group_artifact_id', 'group_artifact_id');
5853 CREATE CONSTRAINT TRIGGER artifact_groupartifactid_fk
5854 AFTER DELETE ON artifact_group_list
5856 NOT DEFERRABLE INITIALLY IMMEDIATE
5858 EXECUTE PROCEDURE "RI_FKey_noaction_del"('artifact_groupartifactid_fk', 'artifact', 'artifact_group_list', 'FULL', 'group_artifact_id', 'group_artifact_id');
5862 CREATE CONSTRAINT TRIGGER artifact_groupartifactid_fk
5863 AFTER UPDATE ON artifact_group_list
5865 NOT DEFERRABLE INITIALLY IMMEDIATE
5867 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('artifact_groupartifactid_fk', 'artifact', 'artifact_group_list', 'FULL', 'group_artifact_id', 'group_artifact_id');
5871 CREATE CONSTRAINT TRIGGER artifact_statusid_fk
5872 AFTER INSERT OR UPDATE ON artifact
5873 FROM artifact_status
5874 NOT DEFERRABLE INITIALLY IMMEDIATE
5876 EXECUTE PROCEDURE "RI_FKey_check_ins"('artifact_statusid_fk', 'artifact', 'artifact_status', 'FULL', 'status_id', 'id');
5880 CREATE CONSTRAINT TRIGGER artifact_statusid_fk
5881 AFTER DELETE ON artifact_status
5883 NOT DEFERRABLE INITIALLY IMMEDIATE
5885 EXECUTE PROCEDURE "RI_FKey_noaction_del"('artifact_statusid_fk', 'artifact', 'artifact_status', 'FULL', 'status_id', 'id');
5889 CREATE CONSTRAINT TRIGGER artifact_statusid_fk
5890 AFTER UPDATE ON artifact_status
5892 NOT DEFERRABLE INITIALLY IMMEDIATE
5894 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('artifact_statusid_fk', 'artifact', 'artifact_status', 'FULL', 'status_id', 'id');
5898 CREATE CONSTRAINT TRIGGER artifact_submittedby_fk
5899 AFTER INSERT OR UPDATE ON artifact
5901 NOT DEFERRABLE INITIALLY IMMEDIATE
5903 EXECUTE PROCEDURE "RI_FKey_check_ins"('artifact_submittedby_fk', 'artifact', 'users', 'FULL', 'submitted_by', 'user_id');
5907 CREATE CONSTRAINT TRIGGER artifact_submittedby_fk
5908 AFTER DELETE ON users
5910 NOT DEFERRABLE INITIALLY IMMEDIATE
5912 EXECUTE PROCEDURE "RI_FKey_noaction_del"('artifact_submittedby_fk', 'artifact', 'users', 'FULL', 'submitted_by', 'user_id');
5916 CREATE CONSTRAINT TRIGGER artifact_submittedby_fk
5917 AFTER UPDATE ON users
5919 NOT DEFERRABLE INITIALLY IMMEDIATE
5921 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('artifact_submittedby_fk', 'artifact', 'users', 'FULL', 'submitted_by', 'user_id');
5925 CREATE CONSTRAINT TRIGGER artifact_assignedto_fk
5926 AFTER INSERT OR UPDATE ON artifact
5928 NOT DEFERRABLE INITIALLY IMMEDIATE
5930 EXECUTE PROCEDURE "RI_FKey_check_ins"('artifact_assignedto_fk', 'artifact', 'users', 'FULL', 'assigned_to', 'user_id');
5934 CREATE CONSTRAINT TRIGGER artifact_assignedto_fk
5935 AFTER DELETE ON users
5937 NOT DEFERRABLE INITIALLY IMMEDIATE
5939 EXECUTE PROCEDURE "RI_FKey_noaction_del"('artifact_assignedto_fk', 'artifact', 'users', 'FULL', 'assigned_to', 'user_id');
5943 CREATE CONSTRAINT TRIGGER artifact_assignedto_fk
5944 AFTER UPDATE ON users
5946 NOT DEFERRABLE INITIALLY IMMEDIATE
5948 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('artifact_assignedto_fk', 'artifact', 'users', 'FULL', 'assigned_to', 'user_id');
5952 CREATE CONSTRAINT TRIGGER artifacthistory_artifactid_fk
5953 AFTER INSERT OR UPDATE ON artifact_history
5955 NOT DEFERRABLE INITIALLY IMMEDIATE
5957 EXECUTE PROCEDURE "RI_FKey_check_ins"('artifacthistory_artifactid_fk', 'artifact_history', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
5961 CREATE CONSTRAINT TRIGGER artifacthistory_artifactid_fk
5962 AFTER DELETE ON artifact
5963 FROM artifact_history
5964 NOT DEFERRABLE INITIALLY IMMEDIATE
5966 EXECUTE PROCEDURE "RI_FKey_noaction_del"('artifacthistory_artifactid_fk', 'artifact_history', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
5970 CREATE CONSTRAINT TRIGGER artifacthistory_artifactid_fk
5971 AFTER UPDATE ON artifact
5972 FROM artifact_history
5973 NOT DEFERRABLE INITIALLY IMMEDIATE
5975 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('artifacthistory_artifactid_fk', 'artifact_history', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
5979 CREATE CONSTRAINT TRIGGER artifacthistory_modby_fk
5980 AFTER INSERT OR UPDATE ON artifact_history
5982 NOT DEFERRABLE INITIALLY IMMEDIATE
5984 EXECUTE PROCEDURE "RI_FKey_check_ins"('artifacthistory_modby_fk', 'artifact_history', 'users', 'FULL', 'mod_by', 'user_id');
5988 CREATE CONSTRAINT TRIGGER artifacthistory_modby_fk
5989 AFTER DELETE ON users
5990 FROM artifact_history
5991 NOT DEFERRABLE INITIALLY IMMEDIATE
5993 EXECUTE PROCEDURE "RI_FKey_noaction_del"('artifacthistory_modby_fk', 'artifact_history', 'users', 'FULL', 'mod_by', 'user_id');
5997 CREATE CONSTRAINT TRIGGER artifacthistory_modby_fk
5998 AFTER UPDATE ON users
5999 FROM artifact_history
6000 NOT DEFERRABLE INITIALLY IMMEDIATE
6002 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('artifacthistory_modby_fk', 'artifact_history', 'users', 'FULL', 'mod_by', 'user_id');
6006 CREATE CONSTRAINT TRIGGER artifactfile_artifactid_fk
6007 AFTER INSERT OR UPDATE ON artifact_file
6009 NOT DEFERRABLE INITIALLY IMMEDIATE
6011 EXECUTE PROCEDURE "RI_FKey_check_ins"('artifactfile_artifactid_fk', 'artifact_file', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
6015 CREATE CONSTRAINT TRIGGER artifactfile_artifactid_fk
6016 AFTER DELETE ON artifact
6018 NOT DEFERRABLE INITIALLY IMMEDIATE
6020 EXECUTE PROCEDURE "RI_FKey_noaction_del"('artifactfile_artifactid_fk', 'artifact_file', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
6024 CREATE CONSTRAINT TRIGGER artifactfile_artifactid_fk
6025 AFTER UPDATE ON artifact
6027 NOT DEFERRABLE INITIALLY IMMEDIATE
6029 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('artifactfile_artifactid_fk', 'artifact_file', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
6033 CREATE CONSTRAINT TRIGGER artifactfile_submittedby_fk
6034 AFTER INSERT OR UPDATE ON artifact_file
6036 NOT DEFERRABLE INITIALLY IMMEDIATE
6038 EXECUTE PROCEDURE "RI_FKey_check_ins"('artifactfile_submittedby_fk', 'artifact_file', 'users', 'FULL', 'submitted_by', 'user_id');
6042 CREATE CONSTRAINT TRIGGER artifactfile_submittedby_fk
6043 AFTER DELETE ON users
6045 NOT DEFERRABLE INITIALLY IMMEDIATE
6047 EXECUTE PROCEDURE "RI_FKey_noaction_del"('artifactfile_submittedby_fk', 'artifact_file', 'users', 'FULL', 'submitted_by', 'user_id');
6051 CREATE CONSTRAINT TRIGGER artifactfile_submittedby_fk
6052 AFTER UPDATE ON users
6054 NOT DEFERRABLE INITIALLY IMMEDIATE
6056 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('artifactfile_submittedby_fk', 'artifact_file', 'users', 'FULL', 'submitted_by', 'user_id');
6060 CREATE CONSTRAINT TRIGGER artifactmessage_artifactid_fk
6061 AFTER INSERT OR UPDATE ON artifact_message
6063 NOT DEFERRABLE INITIALLY IMMEDIATE
6065 EXECUTE PROCEDURE "RI_FKey_check_ins"('artifactmessage_artifactid_fk', 'artifact_message', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
6069 CREATE CONSTRAINT TRIGGER artifactmessage_artifactid_fk
6070 AFTER DELETE ON artifact
6071 FROM artifact_message
6072 NOT DEFERRABLE INITIALLY IMMEDIATE
6074 EXECUTE PROCEDURE "RI_FKey_noaction_del"('artifactmessage_artifactid_fk', 'artifact_message', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
6078 CREATE CONSTRAINT TRIGGER artifactmessage_artifactid_fk
6079 AFTER UPDATE ON artifact
6080 FROM artifact_message
6081 NOT DEFERRABLE INITIALLY IMMEDIATE
6083 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('artifactmessage_artifactid_fk', 'artifact_message', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
6087 CREATE CONSTRAINT TRIGGER artifactmessage_submittedby_fk
6088 AFTER INSERT OR UPDATE ON artifact_message
6090 NOT DEFERRABLE INITIALLY IMMEDIATE
6092 EXECUTE PROCEDURE "RI_FKey_check_ins"('artifactmessage_submittedby_fk', 'artifact_message', 'users', 'FULL', 'submitted_by', 'user_id');
6096 CREATE CONSTRAINT TRIGGER artifactmessage_submittedby_fk
6097 AFTER DELETE ON users
6098 FROM artifact_message
6099 NOT DEFERRABLE INITIALLY IMMEDIATE
6101 EXECUTE PROCEDURE "RI_FKey_noaction_del"('artifactmessage_submittedby_fk', 'artifact_message', 'users', 'FULL', 'submitted_by', 'user_id');
6105 CREATE CONSTRAINT TRIGGER artifactmessage_submittedby_fk
6106 AFTER UPDATE ON users
6107 FROM artifact_message
6108 NOT DEFERRABLE INITIALLY IMMEDIATE
6110 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('artifactmessage_submittedby_fk', 'artifact_message', 'users', 'FULL', 'submitted_by', 'user_id');
6114 CREATE CONSTRAINT TRIGGER artifactmonitor_artifactid_fk
6115 AFTER INSERT OR UPDATE ON artifact_monitor
6117 NOT DEFERRABLE INITIALLY IMMEDIATE
6119 EXECUTE PROCEDURE "RI_FKey_check_ins"('artifactmonitor_artifactid_fk', 'artifact_monitor', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
6123 CREATE CONSTRAINT TRIGGER artifactmonitor_artifactid_fk
6124 AFTER DELETE ON artifact
6125 FROM artifact_monitor
6126 NOT DEFERRABLE INITIALLY IMMEDIATE
6128 EXECUTE PROCEDURE "RI_FKey_noaction_del"('artifactmonitor_artifactid_fk', 'artifact_monitor', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
6132 CREATE CONSTRAINT TRIGGER artifactmonitor_artifactid_fk
6133 AFTER UPDATE ON artifact
6134 FROM artifact_monitor
6135 NOT DEFERRABLE INITIALLY IMMEDIATE
6137 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('artifactmonitor_artifactid_fk', 'artifact_monitor', 'artifact', 'FULL', 'artifact_id', 'artifact_id');
6141 CREATE TRIGGER artifactgrouplist_insert_trig
6142 AFTER INSERT ON artifact_group_list
6144 EXECUTE PROCEDURE artifactgrouplist_insert_agg();
6148 CREATE TRIGGER artifactgroup_update_trig
6149 AFTER UPDATE ON artifact
6151 EXECUTE PROCEDURE artifactgroup_update_agg();
6155 CREATE TRIGGER forumgrouplist_insert_trig
6156 AFTER INSERT ON forum_group_list
6158 EXECUTE PROCEDURE forumgrouplist_insert_agg();
6162 CREATE CONSTRAINT TRIGGER frsfile_releaseid_fk
6163 AFTER INSERT OR UPDATE ON frs_file
6165 NOT DEFERRABLE INITIALLY IMMEDIATE
6167 EXECUTE PROCEDURE "RI_FKey_check_ins"('frsfile_releaseid_fk', 'frs_file', 'frs_release', 'FULL', 'release_id', 'release_id');
6171 CREATE CONSTRAINT TRIGGER frsfile_releaseid_fk
6172 AFTER DELETE ON frs_release
6174 NOT DEFERRABLE INITIALLY IMMEDIATE
6176 EXECUTE PROCEDURE "RI_FKey_noaction_del"('frsfile_releaseid_fk', 'frs_file', 'frs_release', 'FULL', 'release_id', 'release_id');
6180 CREATE CONSTRAINT TRIGGER frsfile_releaseid_fk
6181 AFTER UPDATE ON frs_release
6183 NOT DEFERRABLE INITIALLY IMMEDIATE
6185 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('frsfile_releaseid_fk', 'frs_file', 'frs_release', 'FULL', 'release_id', 'release_id');
6189 CREATE CONSTRAINT TRIGGER frsfile_typeid_fk
6190 AFTER INSERT OR UPDATE ON frs_file
6192 NOT DEFERRABLE INITIALLY IMMEDIATE
6194 EXECUTE PROCEDURE "RI_FKey_check_ins"('frsfile_typeid_fk', 'frs_file', 'frs_filetype', 'FULL', 'type_id', 'type_id');
6198 CREATE CONSTRAINT TRIGGER frsfile_typeid_fk
6199 AFTER DELETE ON frs_filetype
6201 NOT DEFERRABLE INITIALLY IMMEDIATE
6203 EXECUTE PROCEDURE "RI_FKey_noaction_del"('frsfile_typeid_fk', 'frs_file', 'frs_filetype', 'FULL', 'type_id', 'type_id');
6207 CREATE CONSTRAINT TRIGGER frsfile_typeid_fk
6208 AFTER UPDATE ON frs_filetype
6210 NOT DEFERRABLE INITIALLY IMMEDIATE
6212 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('frsfile_typeid_fk', 'frs_file', 'frs_filetype', 'FULL', 'type_id', 'type_id');
6216 CREATE CONSTRAINT TRIGGER frsfile_processorid_fk
6217 AFTER INSERT OR UPDATE ON frs_file
6219 NOT DEFERRABLE INITIALLY IMMEDIATE
6221 EXECUTE PROCEDURE "RI_FKey_check_ins"('frsfile_processorid_fk', 'frs_file', 'frs_processor', 'FULL', 'processor_id', 'processor_id');
6225 CREATE CONSTRAINT TRIGGER frsfile_processorid_fk
6226 AFTER DELETE ON frs_processor
6228 NOT DEFERRABLE INITIALLY IMMEDIATE
6230 EXECUTE PROCEDURE "RI_FKey_noaction_del"('frsfile_processorid_fk', 'frs_file', 'frs_processor', 'FULL', 'processor_id', 'processor_id');
6234 CREATE CONSTRAINT TRIGGER frsfile_processorid_fk
6235 AFTER UPDATE ON frs_processor
6237 NOT DEFERRABLE INITIALLY IMMEDIATE
6239 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('frsfile_processorid_fk', 'frs_file', 'frs_processor', 'FULL', 'processor_id', 'processor_id');
6243 CREATE CONSTRAINT TRIGGER frspackage_groupid_fk
6244 AFTER INSERT OR UPDATE ON frs_package
6246 NOT DEFERRABLE INITIALLY IMMEDIATE
6248 EXECUTE PROCEDURE "RI_FKey_check_ins"('frspackage_groupid_fk', 'frs_package', 'groups', 'FULL', 'group_id', 'group_id');
6252 CREATE CONSTRAINT TRIGGER frspackage_groupid_fk
6253 AFTER DELETE ON groups
6255 NOT DEFERRABLE INITIALLY IMMEDIATE
6257 EXECUTE PROCEDURE "RI_FKey_noaction_del"('frspackage_groupid_fk', 'frs_package', 'groups', 'FULL', 'group_id', 'group_id');
6261 CREATE CONSTRAINT TRIGGER frspackage_groupid_fk
6262 AFTER UPDATE ON groups
6264 NOT DEFERRABLE INITIALLY IMMEDIATE
6266 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('frspackage_groupid_fk', 'frs_package', 'groups', 'FULL', 'group_id', 'group_id');
6270 CREATE CONSTRAINT TRIGGER frspackage_statusid_fk
6271 AFTER INSERT OR UPDATE ON frs_package
6273 NOT DEFERRABLE INITIALLY IMMEDIATE
6275 EXECUTE PROCEDURE "RI_FKey_check_ins"('frspackage_statusid_fk', 'frs_package', 'frs_status', 'FULL', 'status_id', 'status_id');
6279 CREATE CONSTRAINT TRIGGER frspackage_statusid_fk
6280 AFTER DELETE ON frs_status
6282 NOT DEFERRABLE INITIALLY IMMEDIATE
6284 EXECUTE PROCEDURE "RI_FKey_noaction_del"('frspackage_statusid_fk', 'frs_package', 'frs_status', 'FULL', 'status_id', 'status_id');
6288 CREATE CONSTRAINT TRIGGER frspackage_statusid_fk
6289 AFTER UPDATE ON frs_status
6291 NOT DEFERRABLE INITIALLY IMMEDIATE
6293 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('frspackage_statusid_fk', 'frs_package', 'frs_status', 'FULL', 'status_id', 'status_id');
6297 CREATE CONSTRAINT TRIGGER frsrelease_packageid_fk
6298 AFTER INSERT OR UPDATE ON frs_release
6300 NOT DEFERRABLE INITIALLY IMMEDIATE
6302 EXECUTE PROCEDURE "RI_FKey_check_ins"('frsrelease_packageid_fk', 'frs_release', 'frs_package', 'FULL', 'package_id', 'package_id');
6306 CREATE CONSTRAINT TRIGGER frsrelease_packageid_fk
6307 AFTER DELETE ON frs_package
6309 NOT DEFERRABLE INITIALLY IMMEDIATE
6311 EXECUTE PROCEDURE "RI_FKey_noaction_del"('frsrelease_packageid_fk', 'frs_release', 'frs_package', 'FULL', 'package_id', 'package_id');
6315 CREATE CONSTRAINT TRIGGER frsrelease_packageid_fk
6316 AFTER UPDATE ON frs_package
6318 NOT DEFERRABLE INITIALLY IMMEDIATE
6320 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('frsrelease_packageid_fk', 'frs_release', 'frs_package', 'FULL', 'package_id', 'package_id');
6324 CREATE CONSTRAINT TRIGGER frsrelease_statusid_fk
6325 AFTER INSERT OR UPDATE ON frs_release
6327 NOT DEFERRABLE INITIALLY IMMEDIATE
6329 EXECUTE PROCEDURE "RI_FKey_check_ins"('frsrelease_statusid_fk', 'frs_release', 'frs_status', 'FULL', 'status_id', 'status_id');
6333 CREATE CONSTRAINT TRIGGER frsrelease_statusid_fk
6334 AFTER DELETE ON frs_status
6336 NOT DEFERRABLE INITIALLY IMMEDIATE
6338 EXECUTE PROCEDURE "RI_FKey_noaction_del"('frsrelease_statusid_fk', 'frs_release', 'frs_status', 'FULL', 'status_id', 'status_id');
6342 CREATE CONSTRAINT TRIGGER frsrelease_statusid_fk
6343 AFTER UPDATE ON frs_status
6345 NOT DEFERRABLE INITIALLY IMMEDIATE
6347 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('frsrelease_statusid_fk', 'frs_release', 'frs_status', 'FULL', 'status_id', 'status_id');
6351 CREATE CONSTRAINT TRIGGER frsrelease_releasedby_fk
6352 AFTER INSERT OR UPDATE ON frs_release
6354 NOT DEFERRABLE INITIALLY IMMEDIATE
6356 EXECUTE PROCEDURE "RI_FKey_check_ins"('frsrelease_releasedby_fk', 'frs_release', 'users', 'FULL', 'released_by', 'user_id');
6360 CREATE CONSTRAINT TRIGGER frsrelease_releasedby_fk
6361 AFTER DELETE ON users
6363 NOT DEFERRABLE INITIALLY IMMEDIATE
6365 EXECUTE PROCEDURE "RI_FKey_noaction_del"('frsrelease_releasedby_fk', 'frs_release', 'users', 'FULL', 'released_by', 'user_id');
6369 CREATE CONSTRAINT TRIGGER frsrelease_releasedby_fk
6370 AFTER UPDATE ON users
6372 NOT DEFERRABLE INITIALLY IMMEDIATE
6374 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('frsrelease_releasedby_fk', 'frs_release', 'users', 'FULL', 'released_by', 'user_id');
6378 CREATE CONSTRAINT TRIGGER tgl_group_id_fk
6379 AFTER INSERT OR UPDATE ON trove_group_link
6381 NOT DEFERRABLE INITIALLY IMMEDIATE
6383 EXECUTE PROCEDURE "RI_FKey_check_ins"('tgl_group_id_fk', 'trove_group_link', 'groups', 'FULL', 'group_id', 'group_id');
6387 CREATE CONSTRAINT TRIGGER tgl_group_id_fk
6388 AFTER DELETE ON groups
6389 FROM trove_group_link
6390 NOT DEFERRABLE INITIALLY IMMEDIATE
6392 EXECUTE PROCEDURE "RI_FKey_noaction_del"('tgl_group_id_fk', 'trove_group_link', 'groups', 'FULL', 'group_id', 'group_id');
6396 CREATE CONSTRAINT TRIGGER tgl_group_id_fk
6397 AFTER UPDATE ON groups
6398 FROM trove_group_link
6399 NOT DEFERRABLE INITIALLY IMMEDIATE
6401 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('tgl_group_id_fk', 'trove_group_link', 'groups', 'FULL', 'group_id', 'group_id');
6405 CREATE CONSTRAINT TRIGGER tgl_cat_id_fk
6406 AFTER INSERT OR UPDATE ON trove_group_link
6408 NOT DEFERRABLE INITIALLY IMMEDIATE
6410 EXECUTE PROCEDURE "RI_FKey_check_ins"('tgl_cat_id_fk', 'trove_group_link', 'trove_cat', 'FULL', 'trove_cat_id', 'trove_cat_id');
6414 CREATE CONSTRAINT TRIGGER tgl_cat_id_fk
6415 AFTER DELETE ON trove_cat
6416 FROM trove_group_link
6417 NOT DEFERRABLE INITIALLY IMMEDIATE
6419 EXECUTE PROCEDURE "RI_FKey_noaction_del"('tgl_cat_id_fk', 'trove_group_link', 'trove_cat', 'FULL', 'trove_cat_id', 'trove_cat_id');
6423 CREATE CONSTRAINT TRIGGER tgl_cat_id_fk
6424 AFTER UPDATE ON trove_cat
6425 FROM trove_group_link
6426 NOT DEFERRABLE INITIALLY IMMEDIATE
6428 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('tgl_cat_id_fk', 'trove_group_link', 'trove_cat', 'FULL', 'trove_cat_id', 'trove_cat_id');
6432 CREATE CONSTRAINT TRIGGER trove_agg_cat_id_fk
6433 AFTER INSERT OR UPDATE ON trove_agg
6435 NOT DEFERRABLE INITIALLY IMMEDIATE
6437 EXECUTE PROCEDURE "RI_FKey_check_ins"('trove_agg_cat_id_fk', 'trove_agg', 'trove_cat', 'FULL', 'trove_cat_id', 'trove_cat_id');
6441 CREATE CONSTRAINT TRIGGER trove_agg_cat_id_fk
6442 AFTER DELETE ON trove_cat
6444 NOT DEFERRABLE INITIALLY IMMEDIATE
6446 EXECUTE PROCEDURE "RI_FKey_noaction_del"('trove_agg_cat_id_fk', 'trove_agg', 'trove_cat', 'FULL', 'trove_cat_id', 'trove_cat_id');
6450 CREATE CONSTRAINT TRIGGER trove_agg_cat_id_fk
6451 AFTER UPDATE ON trove_cat
6453 NOT DEFERRABLE INITIALLY IMMEDIATE
6455 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('trove_agg_cat_id_fk', 'trove_agg', 'trove_cat', 'FULL', 'trove_cat_id', 'trove_cat_id');
6459 CREATE CONSTRAINT TRIGGER trove_agg_group_id_fk
6460 AFTER INSERT OR UPDATE ON trove_agg
6462 NOT DEFERRABLE INITIALLY IMMEDIATE
6464 EXECUTE PROCEDURE "RI_FKey_check_ins"('trove_agg_group_id_fk', 'trove_agg', 'groups', 'FULL', 'group_id', 'group_id');
6468 CREATE CONSTRAINT TRIGGER trove_agg_group_id_fk
6469 AFTER DELETE ON groups
6471 NOT DEFERRABLE INITIALLY IMMEDIATE
6473 EXECUTE PROCEDURE "RI_FKey_noaction_del"('trove_agg_group_id_fk', 'trove_agg', 'groups', 'FULL', 'group_id', 'group_id');
6477 CREATE CONSTRAINT TRIGGER trove_agg_group_id_fk
6478 AFTER UPDATE ON groups
6480 NOT DEFERRABLE INITIALLY IMMEDIATE
6482 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('trove_agg_group_id_fk', 'trove_agg', 'groups', 'FULL', 'group_id', 'group_id');
6486 CREATE CONSTRAINT TRIGGER trove_treesums_cat_id_fk
6487 AFTER INSERT OR UPDATE ON trove_treesums
6489 NOT DEFERRABLE INITIALLY IMMEDIATE
6491 EXECUTE PROCEDURE "RI_FKey_check_ins"('trove_treesums_cat_id_fk', 'trove_treesums', 'trove_cat', 'FULL', 'trove_cat_id', 'trove_cat_id');
6495 CREATE CONSTRAINT TRIGGER trove_treesums_cat_id_fk
6496 AFTER DELETE ON trove_cat
6498 NOT DEFERRABLE INITIALLY IMMEDIATE
6500 EXECUTE PROCEDURE "RI_FKey_noaction_del"('trove_treesums_cat_id_fk', 'trove_treesums', 'trove_cat', 'FULL', 'trove_cat_id', 'trove_cat_id');
6504 CREATE CONSTRAINT TRIGGER trove_treesums_cat_id_fk
6505 AFTER UPDATE ON trove_cat
6507 NOT DEFERRABLE INITIALLY IMMEDIATE
6509 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('trove_treesums_cat_id_fk', 'trove_treesums', 'trove_cat', 'FULL', 'trove_cat_id', 'trove_cat_id');
6513 CREATE CONSTRAINT TRIGGER users_languageid_fk
6514 AFTER INSERT OR UPDATE ON users
6515 FROM supported_languages
6516 NOT DEFERRABLE INITIALLY IMMEDIATE
6518 EXECUTE PROCEDURE "RI_FKey_check_ins"('users_languageid_fk', 'users', 'supported_languages', 'FULL', 'language', 'language_id');
6522 CREATE CONSTRAINT TRIGGER users_languageid_fk
6523 AFTER DELETE ON supported_languages
6525 NOT DEFERRABLE INITIALLY IMMEDIATE
6527 EXECUTE PROCEDURE "RI_FKey_noaction_del"('users_languageid_fk', 'users', 'supported_languages', 'FULL', 'language', 'language_id');
6531 CREATE CONSTRAINT TRIGGER users_languageid_fk
6532 AFTER UPDATE ON supported_languages
6534 NOT DEFERRABLE INITIALLY IMMEDIATE
6536 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('users_languageid_fk', 'users', 'supported_languages', 'FULL', 'language', 'language_id');
6540 CREATE CONSTRAINT TRIGGER docdata_languageid_fk
6541 AFTER INSERT OR UPDATE ON doc_data
6542 FROM supported_languages
6543 NOT DEFERRABLE INITIALLY IMMEDIATE
6545 EXECUTE PROCEDURE "RI_FKey_check_ins"('docdata_languageid_fk', 'doc_data', 'supported_languages', 'FULL', 'language_id', 'language_id');
6549 CREATE CONSTRAINT TRIGGER docdata_languageid_fk
6550 AFTER DELETE ON supported_languages
6552 NOT DEFERRABLE INITIALLY IMMEDIATE
6554 EXECUTE PROCEDURE "RI_FKey_noaction_del"('docdata_languageid_fk', 'doc_data', 'supported_languages', 'FULL', 'language_id', 'language_id');
6558 CREATE CONSTRAINT TRIGGER docdata_languageid_fk
6559 AFTER UPDATE ON supported_languages
6561 NOT DEFERRABLE INITIALLY IMMEDIATE
6563 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('docdata_languageid_fk', 'doc_data', 'supported_languages', 'FULL', 'language_id', 'language_id');
6567 CREATE CONSTRAINT TRIGGER forumgrouplist_groupid
6568 AFTER INSERT OR UPDATE ON forum_group_list
6570 NOT DEFERRABLE INITIALLY IMMEDIATE
6572 EXECUTE PROCEDURE "RI_FKey_check_ins"('forumgrouplist_groupid', 'forum_group_list', 'groups', 'FULL', 'group_id', 'group_id');
6576 CREATE CONSTRAINT TRIGGER forumgrouplist_groupid
6577 AFTER DELETE ON groups
6578 FROM forum_group_list
6579 NOT DEFERRABLE INITIALLY IMMEDIATE
6581 EXECUTE PROCEDURE "RI_FKey_cascade_del"('forumgrouplist_groupid', 'forum_group_list', 'groups', 'FULL', 'group_id', 'group_id');
6585 CREATE CONSTRAINT TRIGGER forumgrouplist_groupid
6586 AFTER UPDATE ON groups
6587 FROM forum_group_list
6588 NOT DEFERRABLE INITIALLY IMMEDIATE
6590 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('forumgrouplist_groupid', 'forum_group_list', 'groups', 'FULL', 'group_id', 'group_id');
6594 CREATE CONSTRAINT TRIGGER forum_groupforumid
6595 AFTER INSERT OR UPDATE ON forum
6596 FROM forum_group_list
6597 NOT DEFERRABLE INITIALLY IMMEDIATE
6599 EXECUTE PROCEDURE "RI_FKey_check_ins"('forum_groupforumid', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
6603 CREATE CONSTRAINT TRIGGER forum_groupforumid
6604 AFTER DELETE ON forum_group_list
6606 NOT DEFERRABLE INITIALLY IMMEDIATE
6608 EXECUTE PROCEDURE "RI_FKey_cascade_del"('forum_groupforumid', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
6612 CREATE CONSTRAINT TRIGGER forum_groupforumid
6613 AFTER UPDATE ON forum_group_list
6615 NOT DEFERRABLE INITIALLY IMMEDIATE
6617 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('forum_groupforumid', 'forum', 'forum_group_list', 'FULL', 'group_forum_id', 'group_forum_id');
6621 CREATE CONSTRAINT TRIGGER forum_userid
6622 AFTER INSERT OR UPDATE ON forum
6624 NOT DEFERRABLE INITIALLY IMMEDIATE
6626 EXECUTE PROCEDURE "RI_FKey_check_ins"('forum_userid', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
6630 CREATE CONSTRAINT TRIGGER forum_userid
6631 AFTER DELETE ON users
6633 NOT DEFERRABLE INITIALLY IMMEDIATE
6635 EXECUTE PROCEDURE "RI_FKey_noaction_del"('forum_userid', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
6639 CREATE CONSTRAINT TRIGGER forum_userid
6640 AFTER UPDATE ON users
6642 NOT DEFERRABLE INITIALLY IMMEDIATE
6644 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('forum_userid', 'forum', 'users', 'FULL', 'posted_by', 'user_id');
6648 CREATE CONSTRAINT TRIGGER "<unnamed>"
6649 AFTER INSERT OR UPDATE ON skills_data
6651 NOT DEFERRABLE INITIALLY IMMEDIATE
6653 EXECUTE PROCEDURE "RI_FKey_check_ins"('<unnamed>', 'skills_data', 'users', 'UNSPECIFIED', 'user_id', 'user_id');
6657 CREATE CONSTRAINT TRIGGER "<unnamed>"
6658 AFTER DELETE ON users
6660 NOT DEFERRABLE INITIALLY IMMEDIATE
6662 EXECUTE PROCEDURE "RI_FKey_noaction_del"('<unnamed>', 'skills_data', 'users', 'UNSPECIFIED', 'user_id', 'user_id');
6666 CREATE CONSTRAINT TRIGGER "<unnamed>"
6667 AFTER UPDATE ON users
6669 NOT DEFERRABLE INITIALLY IMMEDIATE
6671 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('<unnamed>', 'skills_data', 'users', 'UNSPECIFIED', 'user_id', 'user_id');
6675 CREATE CONSTRAINT TRIGGER "<unnamed>"
6676 AFTER INSERT OR UPDATE ON skills_data
6677 FROM skills_data_types
6678 NOT DEFERRABLE INITIALLY IMMEDIATE
6680 EXECUTE PROCEDURE "RI_FKey_check_ins"('<unnamed>', 'skills_data', 'skills_data_types', 'UNSPECIFIED', 'type', 'type_id');
6684 CREATE CONSTRAINT TRIGGER "<unnamed>"
6685 AFTER DELETE ON skills_data_types
6687 NOT DEFERRABLE INITIALLY IMMEDIATE
6689 EXECUTE PROCEDURE "RI_FKey_noaction_del"('<unnamed>', 'skills_data', 'skills_data_types', 'UNSPECIFIED', 'type', 'type_id');
6693 CREATE CONSTRAINT TRIGGER "<unnamed>"
6694 AFTER UPDATE ON skills_data_types
6696 NOT DEFERRABLE INITIALLY IMMEDIATE
6698 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('<unnamed>', 'skills_data', 'skills_data_types', 'UNSPECIFIED', 'type', 'type_id');
6702 CREATE CONSTRAINT TRIGGER projecttask_groupprojectid_fk
6703 AFTER INSERT OR UPDATE ON project_task
6704 FROM project_group_list
6705 NOT DEFERRABLE INITIALLY IMMEDIATE
6707 EXECUTE PROCEDURE "RI_FKey_check_ins"('projecttask_groupprojectid_fk', 'project_task', 'project_group_list', 'UNSPECIFIED', 'group_project_id', 'group_project_id');
6711 CREATE CONSTRAINT TRIGGER projecttask_groupprojectid_fk
6712 AFTER DELETE ON project_group_list
6714 NOT DEFERRABLE INITIALLY IMMEDIATE
6716 EXECUTE PROCEDURE "RI_FKey_cascade_del"('projecttask_groupprojectid_fk', 'project_task', 'project_group_list', 'UNSPECIFIED', 'group_project_id', 'group_project_id');
6720 CREATE CONSTRAINT TRIGGER projecttask_groupprojectid_fk
6721 AFTER UPDATE ON project_group_list
6723 NOT DEFERRABLE INITIALLY IMMEDIATE
6725 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('projecttask_groupprojectid_fk', 'project_task', 'project_group_list', 'UNSPECIFIED', 'group_project_id', 'group_project_id');
6729 CREATE CONSTRAINT TRIGGER projcat_projgroupid_fk
6730 AFTER INSERT OR UPDATE ON project_category
6731 FROM project_group_list
6732 NOT DEFERRABLE INITIALLY IMMEDIATE
6734 EXECUTE PROCEDURE "RI_FKey_check_ins"('projcat_projgroupid_fk', 'project_category', 'project_group_list', 'UNSPECIFIED', 'group_project_id', 'group_project_id');
6738 CREATE CONSTRAINT TRIGGER projcat_projgroupid_fk
6739 AFTER DELETE ON project_group_list
6740 FROM project_category
6741 NOT DEFERRABLE INITIALLY IMMEDIATE
6743 EXECUTE PROCEDURE "RI_FKey_cascade_del"('projcat_projgroupid_fk', 'project_category', 'project_group_list', 'UNSPECIFIED', 'group_project_id', 'group_project_id');
6747 CREATE CONSTRAINT TRIGGER projcat_projgroupid_fk
6748 AFTER UPDATE ON project_group_list
6749 FROM project_category
6750 NOT DEFERRABLE INITIALLY IMMEDIATE
6752 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('projcat_projgroupid_fk', 'project_category', 'project_group_list', 'UNSPECIFIED', 'group_project_id', 'group_project_id');
6756 CREATE CONSTRAINT TRIGGER "<unnamed>"
6757 AFTER INSERT OR UPDATE ON project_task
6758 FROM project_category
6759 NOT DEFERRABLE INITIALLY IMMEDIATE
6761 EXECUTE PROCEDURE "RI_FKey_check_ins"('<unnamed>', 'project_task', 'project_category', 'UNSPECIFIED', 'category_id', 'category_id');
6765 CREATE CONSTRAINT TRIGGER "<unnamed>"
6766 AFTER DELETE ON project_category
6768 NOT DEFERRABLE INITIALLY IMMEDIATE
6770 EXECUTE PROCEDURE "RI_FKey_noaction_del"('<unnamed>', 'project_task', 'project_category', 'UNSPECIFIED', 'category_id', 'category_id');
6774 CREATE CONSTRAINT TRIGGER "<unnamed>"
6775 AFTER UPDATE ON project_category
6777 NOT DEFERRABLE INITIALLY IMMEDIATE
6779 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('<unnamed>', 'project_task', 'project_category', 'UNSPECIFIED', 'category_id', 'category_id');
6783 CREATE CONSTRAINT TRIGGER projtaskartifact_projtaskid_fk
6784 AFTER INSERT OR UPDATE ON project_task_artifact
6786 NOT DEFERRABLE INITIALLY IMMEDIATE
6788 EXECUTE PROCEDURE "RI_FKey_check_ins"('projtaskartifact_projtaskid_fk', 'project_task_artifact', 'project_task', 'UNSPECIFIED', 'project_task_id', 'project_task_id');
6792 CREATE CONSTRAINT TRIGGER projtaskartifact_projtaskid_fk
6793 AFTER DELETE ON project_task
6794 FROM project_task_artifact
6795 NOT DEFERRABLE INITIALLY IMMEDIATE
6797 EXECUTE PROCEDURE "RI_FKey_cascade_del"('projtaskartifact_projtaskid_fk', 'project_task_artifact', 'project_task', 'UNSPECIFIED', 'project_task_id', 'project_task_id');
6801 CREATE CONSTRAINT TRIGGER projtaskartifact_projtaskid_fk
6802 AFTER UPDATE ON project_task
6803 FROM project_task_artifact
6804 NOT DEFERRABLE INITIALLY IMMEDIATE
6806 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('projtaskartifact_projtaskid_fk', 'project_task_artifact', 'project_task', 'UNSPECIFIED', 'project_task_id', 'project_task_id');
6810 CREATE CONSTRAINT TRIGGER projtaskartifact_artifactid_fk
6811 AFTER INSERT OR UPDATE ON project_task_artifact
6813 NOT DEFERRABLE INITIALLY IMMEDIATE
6815 EXECUTE PROCEDURE "RI_FKey_check_ins"('projtaskartifact_artifactid_fk', 'project_task_artifact', 'artifact', 'UNSPECIFIED', 'artifact_id', 'artifact_id');
6819 CREATE CONSTRAINT TRIGGER projtaskartifact_artifactid_fk
6820 AFTER DELETE ON artifact
6821 FROM project_task_artifact
6822 NOT DEFERRABLE INITIALLY IMMEDIATE
6824 EXECUTE PROCEDURE "RI_FKey_cascade_del"('projtaskartifact_artifactid_fk', 'project_task_artifact', 'artifact', 'UNSPECIFIED', 'artifact_id', 'artifact_id');
6828 CREATE CONSTRAINT TRIGGER projtaskartifact_artifactid_fk
6829 AFTER UPDATE ON artifact
6830 FROM project_task_artifact
6831 NOT DEFERRABLE INITIALLY IMMEDIATE
6833 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('projtaskartifact_artifactid_fk', 'project_task_artifact', 'artifact', 'UNSPECIFIED', 'artifact_id', 'artifact_id');
6837 CREATE CONSTRAINT TRIGGER "<unnamed>"
6838 AFTER INSERT OR UPDATE ON project_messages
6840 NOT DEFERRABLE INITIALLY IMMEDIATE
6842 EXECUTE PROCEDURE "RI_FKey_check_ins"('<unnamed>', 'project_messages', 'project_task', 'UNSPECIFIED', 'project_task_id', 'project_task_id');
6846 CREATE CONSTRAINT TRIGGER "<unnamed>"
6847 AFTER DELETE ON project_task
6848 FROM project_messages
6849 NOT DEFERRABLE INITIALLY IMMEDIATE
6851 EXECUTE PROCEDURE "RI_FKey_cascade_del"('<unnamed>', 'project_messages', 'project_task', 'UNSPECIFIED', 'project_task_id', 'project_task_id');
6855 CREATE CONSTRAINT TRIGGER "<unnamed>"
6856 AFTER UPDATE ON project_task
6857 FROM project_messages
6858 NOT DEFERRABLE INITIALLY IMMEDIATE
6860 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('<unnamed>', 'project_messages', 'project_task', 'UNSPECIFIED', 'project_task_id', 'project_task_id');
6864 CREATE CONSTRAINT TRIGGER "<unnamed>"
6865 AFTER INSERT OR UPDATE ON project_messages
6867 NOT DEFERRABLE INITIALLY IMMEDIATE
6869 EXECUTE PROCEDURE "RI_FKey_check_ins"('<unnamed>', 'project_messages', 'users', 'UNSPECIFIED', 'posted_by', 'user_id');
6873 CREATE CONSTRAINT TRIGGER "<unnamed>"
6874 AFTER DELETE ON users
6875 FROM project_messages
6876 NOT DEFERRABLE INITIALLY IMMEDIATE
6878 EXECUTE PROCEDURE "RI_FKey_noaction_del"('<unnamed>', 'project_messages', 'users', 'UNSPECIFIED', 'posted_by', 'user_id');
6882 CREATE CONSTRAINT TRIGGER "<unnamed>"
6883 AFTER UPDATE ON users
6884 FROM project_messages
6885 NOT DEFERRABLE INITIALLY IMMEDIATE
6887 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('<unnamed>', 'project_messages', 'users', 'UNSPECIFIED', 'posted_by', 'user_id');
6891 CREATE CONSTRAINT TRIGGER docdata_groupid
6892 AFTER INSERT OR UPDATE ON doc_data
6894 NOT DEFERRABLE INITIALLY IMMEDIATE
6896 EXECUTE PROCEDURE "RI_FKey_check_ins"('docdata_groupid', 'doc_data', 'groups', 'UNSPECIFIED', 'group_id', 'group_id');
6900 CREATE CONSTRAINT TRIGGER docdata_groupid
6901 AFTER DELETE ON groups
6903 NOT DEFERRABLE INITIALLY IMMEDIATE
6905 EXECUTE PROCEDURE "RI_FKey_cascade_del"('docdata_groupid', 'doc_data', 'groups', 'UNSPECIFIED', 'group_id', 'group_id');
6909 CREATE CONSTRAINT TRIGGER docdata_groupid
6910 AFTER UPDATE ON groups
6912 NOT DEFERRABLE INITIALLY IMMEDIATE
6914 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('docdata_groupid', 'doc_data', 'groups', 'UNSPECIFIED', 'group_id', 'group_id');
6918 CREATE CONSTRAINT TRIGGER docdata_docgroupid
6919 AFTER INSERT OR UPDATE ON doc_data
6921 NOT DEFERRABLE INITIALLY IMMEDIATE
6923 EXECUTE PROCEDURE "RI_FKey_check_ins"('docdata_docgroupid', 'doc_data', 'doc_groups', 'UNSPECIFIED', 'doc_group', 'doc_group');
6927 CREATE CONSTRAINT TRIGGER docdata_docgroupid
6928 AFTER DELETE ON doc_groups
6930 NOT DEFERRABLE INITIALLY IMMEDIATE
6932 EXECUTE PROCEDURE "RI_FKey_noaction_del"('docdata_docgroupid', 'doc_data', 'doc_groups', 'UNSPECIFIED', 'doc_group', 'doc_group');
6936 CREATE CONSTRAINT TRIGGER docdata_docgroupid
6937 AFTER UPDATE ON doc_groups
6939 NOT DEFERRABLE INITIALLY IMMEDIATE
6941 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('docdata_docgroupid', 'doc_data', 'doc_groups', 'UNSPECIFIED', 'doc_group', 'doc_group');
6945 CREATE CONSTRAINT TRIGGER docdata_stateid
6946 AFTER INSERT OR UPDATE ON doc_data
6948 NOT DEFERRABLE INITIALLY IMMEDIATE
6950 EXECUTE PROCEDURE "RI_FKey_check_ins"('docdata_stateid', 'doc_data', 'doc_states', 'UNSPECIFIED', 'stateid', 'stateid');
6954 CREATE CONSTRAINT TRIGGER docdata_stateid
6955 AFTER DELETE ON doc_states
6957 NOT DEFERRABLE INITIALLY IMMEDIATE
6959 EXECUTE PROCEDURE "RI_FKey_noaction_del"('docdata_stateid', 'doc_data', 'doc_states', 'UNSPECIFIED', 'stateid', 'stateid');
6963 CREATE CONSTRAINT TRIGGER docdata_stateid
6964 AFTER UPDATE ON doc_states
6966 NOT DEFERRABLE INITIALLY IMMEDIATE
6968 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('docdata_stateid', 'doc_data', 'doc_states', 'UNSPECIFIED', 'stateid', 'stateid');
6972 CREATE CONSTRAINT TRIGGER docgroups_groupid
6973 AFTER INSERT OR UPDATE ON doc_groups
6975 NOT DEFERRABLE INITIALLY IMMEDIATE
6977 EXECUTE PROCEDURE "RI_FKey_check_ins"('docgroups_groupid', 'doc_groups', 'groups', 'UNSPECIFIED', 'group_id', 'group_id');
6981 CREATE CONSTRAINT TRIGGER docgroups_groupid
6982 AFTER DELETE ON groups
6984 NOT DEFERRABLE INITIALLY IMMEDIATE
6986 EXECUTE PROCEDURE "RI_FKey_cascade_del"('docgroups_groupid', 'doc_groups', 'groups', 'UNSPECIFIED', 'group_id', 'group_id');
6990 CREATE CONSTRAINT TRIGGER docgroups_groupid
6991 AFTER UPDATE ON groups
6993 NOT DEFERRABLE INITIALLY IMMEDIATE
6995 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('docgroups_groupid', 'doc_groups', 'groups', 'UNSPECIFIED', 'group_id', 'group_id');
6999 CREATE TRIGGER frs_file_insert_trig
7000 AFTER INSERT ON frs_file
7002 EXECUTE PROCEDURE frs_dlstats_filetotal_insert_ag();
7006 CREATE CONSTRAINT TRIGGER group_plugin_group_id_fk
7007 AFTER INSERT OR UPDATE ON group_plugin
7009 NOT DEFERRABLE INITIALLY IMMEDIATE
7011 EXECUTE PROCEDURE "RI_FKey_check_ins"('group_plugin_group_id_fk', 'group_plugin', 'groups', 'FULL', 'group_id', 'group_id');
7015 CREATE CONSTRAINT TRIGGER group_plugin_group_id_fk
7016 AFTER DELETE ON groups
7018 NOT DEFERRABLE INITIALLY IMMEDIATE
7020 EXECUTE PROCEDURE "RI_FKey_noaction_del"('group_plugin_group_id_fk', 'group_plugin', 'groups', 'FULL', 'group_id', 'group_id');
7024 CREATE CONSTRAINT TRIGGER group_plugin_group_id_fk
7025 AFTER UPDATE ON groups
7027 NOT DEFERRABLE INITIALLY IMMEDIATE
7029 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('group_plugin_group_id_fk', 'group_plugin', 'groups', 'FULL', 'group_id', 'group_id');
7033 CREATE CONSTRAINT TRIGGER group_plugin_plugin_id_fk
7034 AFTER INSERT OR UPDATE ON group_plugin
7036 NOT DEFERRABLE INITIALLY IMMEDIATE
7038 EXECUTE PROCEDURE "RI_FKey_check_ins"('group_plugin_plugin_id_fk', 'group_plugin', 'plugins', 'FULL', 'plugin_id', 'plugin_id');
7042 CREATE CONSTRAINT TRIGGER group_plugin_plugin_id_fk
7043 AFTER DELETE ON plugins
7045 NOT DEFERRABLE INITIALLY IMMEDIATE
7047 EXECUTE PROCEDURE "RI_FKey_noaction_del"('group_plugin_plugin_id_fk', 'group_plugin', 'plugins', 'FULL', 'plugin_id', 'plugin_id');
7051 CREATE CONSTRAINT TRIGGER group_plugin_plugin_id_fk
7052 AFTER UPDATE ON plugins
7054 NOT DEFERRABLE INITIALLY IMMEDIATE
7056 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('group_plugin_plugin_id_fk', 'group_plugin', 'plugins', 'FULL', 'plugin_id', 'plugin_id');
7060 CREATE CONSTRAINT TRIGGER user_plugin_user_id_fk
7061 AFTER INSERT OR UPDATE ON user_plugin
7063 NOT DEFERRABLE INITIALLY IMMEDIATE
7065 EXECUTE PROCEDURE "RI_FKey_check_ins"('user_plugin_user_id_fk', 'user_plugin', 'users', 'FULL', 'user_id', 'user_id');
7069 CREATE CONSTRAINT TRIGGER user_plugin_user_id_fk
7070 AFTER DELETE ON users
7072 NOT DEFERRABLE INITIALLY IMMEDIATE
7074 EXECUTE PROCEDURE "RI_FKey_noaction_del"('user_plugin_user_id_fk', 'user_plugin', 'users', 'FULL', 'user_id', 'user_id');
7078 CREATE CONSTRAINT TRIGGER user_plugin_user_id_fk
7079 AFTER UPDATE ON users
7081 NOT DEFERRABLE INITIALLY IMMEDIATE
7083 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('user_plugin_user_id_fk', 'user_plugin', 'users', 'FULL', 'user_id', 'user_id');
7087 CREATE CONSTRAINT TRIGGER user_plugin_plugin_id_fk
7088 AFTER INSERT OR UPDATE ON user_plugin
7090 NOT DEFERRABLE INITIALLY IMMEDIATE
7092 EXECUTE PROCEDURE "RI_FKey_check_ins"('user_plugin_plugin_id_fk', 'user_plugin', 'plugins', 'FULL', 'plugin_id', 'plugin_id');
7096 CREATE CONSTRAINT TRIGGER user_plugin_plugin_id_fk
7097 AFTER DELETE ON plugins
7099 NOT DEFERRABLE INITIALLY IMMEDIATE
7101 EXECUTE PROCEDURE "RI_FKey_noaction_del"('user_plugin_plugin_id_fk', 'user_plugin', 'plugins', 'FULL', 'plugin_id', 'plugin_id');
7105 CREATE CONSTRAINT TRIGGER user_plugin_plugin_id_fk
7106 AFTER UPDATE ON plugins
7108 NOT DEFERRABLE INITIALLY IMMEDIATE
7110 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('user_plugin_plugin_id_fk', 'user_plugin', 'plugins', 'FULL', 'plugin_id', 'plugin_id');
7114 CREATE CONSTRAINT TRIGGER users_themeid
7115 AFTER INSERT OR UPDATE ON users
7117 NOT DEFERRABLE INITIALLY IMMEDIATE
7119 EXECUTE PROCEDURE "RI_FKey_check_ins"('users_themeid', 'users', 'themes', 'FULL', 'theme_id', 'theme_id');
7123 CREATE CONSTRAINT TRIGGER users_themeid
7124 AFTER DELETE ON themes
7126 NOT DEFERRABLE INITIALLY IMMEDIATE
7128 EXECUTE PROCEDURE "RI_FKey_noaction_del"('users_themeid', 'users', 'themes', 'FULL', 'theme_id', 'theme_id');
7132 CREATE CONSTRAINT TRIGGER users_themeid
7133 AFTER UPDATE ON themes
7135 NOT DEFERRABLE INITIALLY IMMEDIATE
7137 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('users_themeid', 'users', 'themes', 'FULL', 'theme_id', 'theme_id');
7141 CREATE CONSTRAINT TRIGGER users_ccode
7142 AFTER INSERT OR UPDATE ON users
7144 NOT DEFERRABLE INITIALLY IMMEDIATE
7146 EXECUTE PROCEDURE "RI_FKey_check_ins"('users_ccode', 'users', 'country_code', 'FULL', 'ccode', 'ccode');
7150 CREATE CONSTRAINT TRIGGER users_ccode
7151 AFTER DELETE ON country_code
7153 NOT DEFERRABLE INITIALLY IMMEDIATE
7155 EXECUTE PROCEDURE "RI_FKey_noaction_del"('users_ccode', 'users', 'country_code', 'FULL', 'ccode', 'ccode');
7159 CREATE CONSTRAINT TRIGGER users_ccode
7160 AFTER UPDATE ON country_code
7162 NOT DEFERRABLE INITIALLY IMMEDIATE
7164 EXECUTE PROCEDURE "RI_FKey_noaction_upd"('users_ccode', 'users', 'country_code', 'FULL', 'ccode', 'ccode');
7168 CREATE TRIGGER projectgrouplist_insert_trig
7169 AFTER INSERT ON project_group_list
7171 EXECUTE PROCEDURE projectgrouplist_insert_agg();
7175 CREATE TRIGGER projectgroup_update_trig
7176 AFTER UPDATE ON project_task
7178 EXECUTE PROCEDURE projectgroup_update_agg();
7182 CREATE TRIGGER artifact_update_last_modified_date
7183 BEFORE INSERT OR UPDATE ON artifact
7185 EXECUTE PROCEDURE update_last_modified_date();
7189 CREATE TRIGGER project_task_update_last_modified_date
7190 BEFORE INSERT OR UPDATE ON project_task
7192 EXECUTE PROCEDURE update_last_modified_date();
7196 CREATE TRIGGER surveys_agg_trig
7197 AFTER INSERT OR DELETE OR UPDATE ON surveys
7199 EXECUTE PROCEDURE project_sums('surv');
7203 CREATE TRIGGER mail_agg_trig
7204 AFTER INSERT OR DELETE OR UPDATE ON mail_group_list
7206 EXECUTE PROCEDURE project_sums('mail');
7210 CREATE TRIGGER fmsg_agg_trig
7211 AFTER INSERT OR DELETE OR UPDATE ON forum
7213 EXECUTE PROCEDURE project_sums('fmsg');
7217 CREATE TRIGGER fora_agg_trig
7218 AFTER INSERT OR DELETE OR UPDATE ON forum_group_list
7220 EXECUTE PROCEDURE project_sums('fora');
7224 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);
7228 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);
7232 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);
7236 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);
7240 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);
7244 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);
7248 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);
7252 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);
7256 SELECT pg_catalog.setval('canned_responses_pk_seq', 1, false);
7260 SELECT pg_catalog.setval('db_images_pk_seq', 1, false);
7264 SELECT pg_catalog.setval('doc_data_pk_seq', 1, false);
7268 SELECT pg_catalog.setval('doc_groups_pk_seq', 1, false);
7272 SELECT pg_catalog.setval('doc_states_pk_seq', 1, false);
7276 SELECT pg_catalog.setval('filemodule_monitor_pk_seq', 1, false);
7280 SELECT pg_catalog.setval('forum_pk_seq', 1, false);
7284 SELECT pg_catalog.setval('forum_group_list_pk_seq', 1, false);
7288 SELECT pg_catalog.setval('forum_monitored_forums_pk_seq', 1, false);
7292 SELECT pg_catalog.setval('forum_saved_place_pk_seq', 1, false);
7296 SELECT pg_catalog.setval('foundry_news_pk_seq', 1, false);
7300 SELECT pg_catalog.setval('frs_file_pk_seq', 1, false);
7304 SELECT pg_catalog.setval('frs_filetype_pk_seq', 9999, true);
7308 SELECT pg_catalog.setval('frs_package_pk_seq', 1, false);
7312 SELECT pg_catalog.setval('frs_processor_pk_seq', 9999, true);
7316 SELECT pg_catalog.setval('frs_release_pk_seq', 1, false);
7320 SELECT pg_catalog.setval('frs_status_pk_seq', 3, true);
7324 SELECT pg_catalog.setval('group_history_pk_seq', 1, false);
7328 SELECT pg_catalog.setval('groups_pk_seq', 5, true);
7332 SELECT pg_catalog.setval('mail_group_list_pk_seq', 1, false);
7336 SELECT pg_catalog.setval('news_bytes_pk_seq', 1, false);
7340 SELECT pg_catalog.setval('people_job_pk_seq', 1, false);
7344 SELECT pg_catalog.setval('people_job_category_pk_seq', 7, true);
7348 SELECT pg_catalog.setval('people_job_inventory_pk_seq', 1, false);
7352 SELECT pg_catalog.setval('people_job_status_pk_seq', 1, false);
7356 SELECT pg_catalog.setval('people_skill_pk_seq', 1, false);
7360 SELECT pg_catalog.setval('people_skill_inventory_pk_seq', 1, false);
7364 SELECT pg_catalog.setval('people_skill_level_pk_seq', 5, true);
7368 SELECT pg_catalog.setval('people_skill_year_pk_seq', 5, true);
7372 SELECT pg_catalog.setval('project_assigned_to_pk_seq', 1, false);
7376 SELECT pg_catalog.setval('project_dependencies_pk_seq', 1, false);
7380 SELECT pg_catalog.setval('project_group_list_pk_seq', 1, true);
7384 SELECT pg_catalog.setval('project_history_pk_seq', 1, false);
7388 SELECT pg_catalog.setval('project_metric_pk_seq', 1, false);
7392 SELECT pg_catalog.setval('project_metric_tmp1_pk_seq', 1, false);
7396 SELECT pg_catalog.setval('project_status_pk_seq', 1, false);
7400 SELECT pg_catalog.setval('project_task_pk_seq', 1, true);
7404 SELECT pg_catalog.setval('project_weekly_metric_pk_seq', 1, false);
7408 SELECT pg_catalog.setval('snippet_pk_seq', 1, false);
7412 SELECT pg_catalog.setval('snippet_package_pk_seq', 1, false);
7416 SELECT pg_catalog.setval('snippet_package_item_pk_seq', 1, false);
7420 SELECT pg_catalog.setval('snippet_package_version_pk_seq', 1, false);
7424 SELECT pg_catalog.setval('snippet_version_pk_seq', 1, false);
7428 SELECT pg_catalog.setval('survey_question_types_pk_seq', 1, false);
7432 SELECT pg_catalog.setval('survey_questions_pk_seq', 1, false);
7436 SELECT pg_catalog.setval('surveys_pk_seq', 1, false);
7440 SELECT pg_catalog.setval('themes_pk_seq', 1, true);
7444 SELECT pg_catalog.setval('trove_cat_pk_seq', 305, true);
7448 SELECT pg_catalog.setval('trove_group_link_pk_seq', 1, false);
7452 SELECT pg_catalog.setval('trove_treesums_pk_seq', 1, false);
7456 SELECT pg_catalog.setval('user_bookmarks_pk_seq', 1, false);
7460 SELECT pg_catalog.setval('user_diary_pk_seq', 1, false);
7464 SELECT pg_catalog.setval('user_diary_monitor_pk_seq', 1, false);
7468 SELECT pg_catalog.setval('user_group_pk_seq', 1, true);
7472 SELECT pg_catalog.setval('user_metric_pk_seq', 1, false);
7476 SELECT pg_catalog.setval('user_metric0_pk_seq', 1, false);
7480 SELECT pg_catalog.setval('users_pk_seq', 101, true);
7484 SELECT pg_catalog.setval('unix_uid_seq', 1, false);
7488 SELECT pg_catalog.setval('forum_thread_seq', 1, false);
7492 SELECT pg_catalog.setval('project_metric_wee_ranking1_seq', 1, false);
7496 SELECT pg_catalog.setval('prdb_dbs_dbid_seq', 1, false);
7500 SELECT pg_catalog.setval('prweb_vhost_vhostid_seq', 1, false);
7504 SELECT pg_catalog.setval('artifact_grou_group_artifac_seq', 100, true);
7508 SELECT pg_catalog.setval('artifact_perm_id_seq', 1, false);
7512 SELECT pg_catalog.setval('artifact_status_id_seq', 3, true);
7516 SELECT pg_catalog.setval('artifact_artifact_id_seq', 1, false);
7520 SELECT pg_catalog.setval('artifact_history_id_seq', 1, false);
7524 SELECT pg_catalog.setval('artifact_file_id_seq', 1, false);
7528 SELECT pg_catalog.setval('artifact_message_id_seq', 1, false);
7532 SELECT pg_catalog.setval('artifact_monitor_id_seq', 1, false);
7536 SELECT pg_catalog.setval('artifact_canned_response_id_seq', 1, false);
7540 SELECT pg_catalog.setval('massmail_queue_id_seq', 1, false);
7544 SELECT pg_catalog.setval('trove_treesum_trove_treesum_seq', 1, false);
7548 SELECT pg_catalog.setval('group_cvs_history_id_seq', 1, false);
7552 SELECT pg_catalog.setval('themes_theme_id_seq', 4, true);
7556 SELECT pg_catalog.setval('supported_langu_language_id_seq', 24, true);
7560 SELECT pg_catalog.setval('skills_data_pk_seq', 1, false);
7564 SELECT pg_catalog.setval('skills_data_types_pk_seq', 4, true);
7568 SELECT pg_catalog.setval('project_categor_category_id_seq', 100, true);
7572 SELECT pg_catalog.setval('project_messa_project_messa_seq', 1, false);
7576 SELECT pg_catalog.setval('plugins_pk_seq', 4, true);
7580 SELECT pg_catalog.setval('group_plugin_pk_seq', 4, true);
7584 SELECT pg_catalog.setval('user_plugin_pk_seq', 1, false);
7588 SELECT pg_catalog.setval('licenses_license_id_seq', 126, true);
7592 SELECT pg_catalog.setval('user_type_type_id_seq', 2, true);
7596 SELECT pg_catalog.setval('role_role_id_seq', 21, true);
7600 SELECT pg_catalog.setval('project_perm_id_seq', 1, false);
7604 SELECT pg_catalog.setval('forum_perm_id_seq', 1, false);
7608 SELECT pg_catalog.setval('artifact_extra_field_elements_element_id_seq', 1, false);
7612 SELECT pg_catalog.setval('artifact_extra_field_data_data_id_seq', 1, false);
7616 SELECT pg_catalog.setval('plugin_cvstracker_artifact_seq', 1, false);
7620 SELECT pg_catalog.setval('plugin_cvstracker_master_seq', 1, false);
7624 SELECT pg_catalog.setval('artifact_query_artifact_query_id_seq', 1, false);
7628 SELECT pg_catalog.setval('artifact_extra_field_list_extra_field_id_seq', 1, false);
7632 SELECT pg_catalog.setval('form_keys_key_id_seq', 1, false);
7636 SELECT pg_catalog.setval('forum_attachment_attachmentid_seq', 1, false);
7640 SELECT pg_catalog.setval('forum_pending_messages_msg_id_seq', 1, false);
7644 SELECT pg_catalog.setval('forum_pending_attachment_attachmentid_seq', 1, false);
7648 COMMENT ON SCHEMA public IS 'Standard public schema';