sourceforge_2_5.sql

来自「GForge 3.0 协作开发平台 支持CVS, mailing lists, 」· SQL 代码 · 共 1,286 行 · 第 1/5 页

);
CREATE TABLE "user_preferences" (
	"user_id" integer DEFAULT '0' NOT NULL,
	"preference_name" character varying(20),
	"preference_value" character varying(20),
	"set_date" integer DEFAULT '0' NOT NULL
);
CREATE TABLE "user_ratings" (
	"rated_by" integer DEFAULT '0' NOT NULL,
	"user_id" integer DEFAULT '0' NOT NULL,
	"rate_field" integer DEFAULT '0' NOT NULL,
	"rating" integer DEFAULT '0' NOT NULL
);
CREATE SEQUENCE "users_pk_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE TABLE "users" (
	"user_id" integer DEFAULT nextval('users_pk_seq'::text) NOT NULL,
	"user_name" text DEFAULT '' NOT NULL,
	"email" text DEFAULT '' NOT NULL,
	"user_pw" character varying(32) DEFAULT '' NOT NULL,
	"realname" character varying(32) DEFAULT '' NOT NULL,
	"status" character(1) DEFAULT 'A' NOT NULL,
	"shell" character varying(20) DEFAULT '/bin/bash' NOT NULL,
	"unix_pw" character varying(40) DEFAULT '' NOT NULL,
	"unix_status" character(1) DEFAULT 'N' NOT NULL,
	"unix_uid" integer DEFAULT '0' NOT NULL,
	"unix_box" character varying(10) DEFAULT 'shell1' NOT NULL,
	"add_date" integer DEFAULT '0' NOT NULL,
	"confirm_hash" character varying(32),
	"mail_siteupdates" integer DEFAULT '0' NOT NULL,
	"mail_va" integer DEFAULT '0' NOT NULL,
	"authorized_keys" text,
	"email_new" text,
	"people_view_skills" integer DEFAULT '0' NOT NULL,
	"people_resume" text DEFAULT '' NOT NULL,
	"timezone" character varying(64) DEFAULT 'GMT',
	"language" integer DEFAULT '1' NOT NULL,
	PRIMARY KEY ("user_id")
);
CREATE SEQUENCE "unix_uid_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE SEQUENCE "forum_thread_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;
CREATE TABLE "trove_agg" (
	"trove_cat_id" integer,
	"group_id" integer,
	"group_name" character varying(40),
	"unix_group_name" character varying(30),
	"status" character(1),
	"register_time" integer,
	"short_description" character varying(255),
	"percentile" double precision,
	"ranking" integer
);
CREATE TABLE "activity_log" (
	"day" integer DEFAULT '0' NOT NULL,
	"hour" integer DEFAULT '0' NOT NULL,
	"group_id" integer DEFAULT '0' NOT NULL,
	"browser" character varying(8) DEFAULT 'OTHER' NOT NULL,
	"ver" double precision DEFAULT '0.00' NOT NULL,
	"platform" character varying(8) DEFAULT 'OTHER' NOT NULL,
	"time" integer DEFAULT '0' NOT NULL,
	"page" text,
	"type" integer DEFAULT '0' NOT NULL
);
CREATE TABLE "activity_log_old" (
	"day" integer DEFAULT '0' NOT NULL,
	"hour" integer DEFAULT '0' NOT NULL,
	"group_id" integer DEFAULT '0' NOT NULL,
	"browser" character varying(8) DEFAULT 'OTHER' NOT NULL,
	"ver" double precision DEFAULT '0.00' NOT NULL,
	"platform" character varying(8) DEFAULT 'OTHER' NOT NULL,
	"time" integer DEFAULT '0' NOT NULL,
	"page" text,
	"type" integer DEFAULT '0' NOT NULL
);
CREATE TABLE "activity_log_old_old" (
	"day" integer DEFAULT '0' NOT NULL,
	"hour" integer DEFAULT '0' NOT NULL,
	"group_id" integer DEFAULT '0' NOT NULL,
	"browser" character varying(8) DEFAULT 'OTHER' NOT NULL,
	"ver" double precision DEFAULT '0.00' NOT NULL,
	"platform" character varying(8) DEFAULT 'OTHER' NOT NULL,
	"time" integer DEFAULT '0' NOT NULL,
	"page" text,
	"type" integer DEFAULT '0' NOT NULL
);
CREATE  INDEX "bug_group_id" on "bug" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "bug_groupid_statusid" on "bug" using btree ( "group_id" "int4_ops", "status_id" "int4_ops" );
CREATE  INDEX "bug_groupid_assignedto_statusid" on "bug" using btree ( "group_id" "int4_ops", "assigned_to" "int4_ops", "status_id" "int4_ops" );
CREATE  INDEX "bug_bug_dependencies_bug_id" on "bug_bug_dependencies" using btree ( "bug_id" "int4_ops" );
CREATE  INDEX "bug_bug_is_dependent_on_task_id" on "bug_bug_dependencies" using btree ( "is_dependent_on_bug_id" "int4_ops" );
CREATE  INDEX "bug_canned_response_group_id" on "bug_canned_responses" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "bug_category_group_id" on "bug_category" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "bug_group_group_id" on "bug_group" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "bug_history_bug_id" on "bug_history" using btree ( "bug_id" "int4_ops" );
CREATE  INDEX "bug_task_dependencies_bug_id" on "bug_task_dependencies" using btree ( "bug_id" "int4_ops" );
CREATE  INDEX "bug_task_is_dependent_on_task_i" on "bug_task_dependencies" using btree ( "is_dependent_on_task_id" "int4_ops" );
CREATE  INDEX "db_images_group" on "db_images" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "doc_group_doc_group" on "doc_data" using btree ( "doc_group" "int4_ops" );
CREATE  INDEX "doc_groups_group" on "doc_groups" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "filemodule_monitor_id" on "filemodule_monitor" using btree ( "filemodule_id" "int4_ops" );
CREATE  INDEX "forum_forumid_msgid" on "forum" using btree ( "group_forum_id" "int4_ops", "msg_id" "int4_ops" );
CREATE  INDEX "forum_group_forum_id" on "forum" using btree ( "group_forum_id" "int4_ops" );
CREATE  INDEX "forum_forumid_isfollowupto" on "forum" using btree ( "group_forum_id" "int4_ops", "is_followup_to" "int4_ops" );
CREATE  INDEX "forum_forumid_threadid_mostrece" on "forum" using btree ( "group_forum_id" "int4_ops", "thread_id" "int4_ops", "most_recent_date" "int4_ops" );
CREATE  INDEX "forum_threadid_isfollowupto" on "forum" using btree ( "thread_id" "int4_ops", "is_followup_to" "int4_ops" );
CREATE  INDEX "forum_forumid_isfollto_mostrece" on "forum" using btree ( "group_forum_id" "int4_ops", "is_followup_to" "int4_ops", "most_recent_date" "int4_ops" );
CREATE  INDEX "forum_group_list_group_id" on "forum_group_list" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "forum_monitor_combo_id" on "forum_monitored_forums" using btree ( "forum_id" "int4_ops", "user_id" "int4_ops" );
CREATE  INDEX "forum_monitor_thread_id" on "forum_monitored_forums" using btree ( "forum_id" "int4_ops" );
CREATE  INDEX "foundry_news_foundry_approved_d" on "foundry_news" using btree ( "foundry_id" "int4_ops", "is_approved" "int4_ops", "approve_date" "int4_ops" );
CREATE  INDEX "foundry_news_foundry_approved" on "foundry_news" using btree ( "foundry_id" "int4_ops", "is_approved" "int4_ops" );
CREATE  INDEX "foundry_news_foundry" on "foundry_news" using btree ( "foundry_id" "int4_ops" );
CREATE  INDEX "foundrynews_foundry_date_approv" on "foundry_news" using btree ( "foundry_id" "int4_ops", "approve_date" "int4_ops", "is_approved" "int4_ops" );
CREATE  INDEX "foundry_project_group_rank" on "foundry_preferred_projects" using btree ( "group_id" "int4_ops", "rank" "int4_ops" );
CREATE  INDEX "foundry_project_group" on "foundry_preferred_projects" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "foundry_projects_foundry" on "foundry_projects" using btree ( "foundry_id" "int4_ops" );
CREATE  INDEX "downloads_http_idx" on "frs_dlstats_agg" using btree ( "downloads_http" "int4_ops" );
CREATE  INDEX "downloads_ftp_idx" on "frs_dlstats_agg" using btree ( "downloads_ftp" "int4_ops" );
CREATE  INDEX "file_id_idx" on "frs_dlstats_agg" using btree ( "file_id" "int4_ops" );
CREATE  INDEX "day_idx" on "frs_dlstats_agg" using btree ( "day" "int4_ops" );
CREATE  INDEX "dlstats_file_down" on "frs_dlstats_file_agg" using btree ( "downloads" "int4_ops" );
CREATE  INDEX "dlstats_file_file_id" on "frs_dlstats_file_agg" using btree ( "file_id" "int4_ops" );
CREATE  INDEX "dlstats_file_day" on "frs_dlstats_file_agg" using btree ( "day" "int4_ops" );
CREATE  INDEX "stats_agr_tmp_fid" on "frs_dlstats_filetotal_agg" using btree ( "file_id" "int4_ops" );
CREATE  INDEX "frs_dlstats_filetotal_agg_old_f" on "frs_dlstats_filetotal_agg_old" using btree ( "file_id" "int4_ops" );
CREATE  INDEX "frsdlstatsgroupagg_day_dls" on "frs_dlstats_group_agg" using btree ( "day" "int4_ops", "downloads" "int4_ops" );
CREATE  INDEX "group_id_idx" on "frs_dlstats_group_agg" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "frs_dlstats_group_agg_day" on "frs_dlstats_group_agg" using btree ( "day" "int4_ops" );
CREATE  INDEX "stats_agr_tmp_gid" on "frs_dlstats_grouptotal_agg" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "frs_file_name" on "frs_file" using btree ( "filename" "text_ops" );
CREATE  INDEX "frs_file_date" on "frs_file" using btree ( "post_date" "int4_ops" );
CREATE  INDEX "frs_file_processor" on "frs_file" using btree ( "processor_id" "int4_ops" );
CREATE  INDEX "frs_file_release_id" on "frs_file" using btree ( "release_id" "int4_ops" );
CREATE  INDEX "frs_file_type" on "frs_file" using btree ( "type_id" "int4_ops" );
CREATE  INDEX "package_group_id" on "frs_package" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "frs_release_package" on "frs_release" using btree ( "package_id" "int4_ops" );
CREATE  INDEX "frs_release_date" on "frs_release" using btree ( "release_date" "int4_ops" );
CREATE  INDEX "frs_release_by" on "frs_release" using btree ( "released_by" "int4_ops" );
CREATE  INDEX "group_cvs_history_group_id" on "group_cvs_history" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "user_name_idx" on "group_cvs_history" using btree ( "user_name" "varchar_ops" );
CREATE  INDEX "group_history_group_id" on "group_history" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "groups_unix" on "groups" using btree ( "unix_group_name" "varchar_ops" );
CREATE  INDEX "groups_type" on "groups" using btree ( "type" "int4_ops" );
CREATE  INDEX "groups_public" on "groups" using btree ( "is_public" "int4_ops" );
CREATE  INDEX "groups_status" on "groups" using btree ( "status" "bpchar_ops" );
CREATE  INDEX "mail_group_list_group" on "mail_group_list" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "news_bytes_group" on "news_bytes" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "news_bytes_approved" on "news_bytes" using btree ( "is_approved" "int4_ops" );
CREATE  INDEX "news_bytes_forum" on "news_bytes" using btree ( "forum_id" "int4_ops" );
CREATE  INDEX "news_group_date" on "news_bytes" using btree ( "group_id" "int4_ops", "date" "int4_ops" );
CREATE  INDEX "news_approved_date" on "news_bytes" using btree ( "is_approved" "int4_ops", "date" "int4_ops" );
CREATE  INDEX "patch_group_id" on "patch" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "patch_groupid_assignedto_status" on "patch" using btree ( "group_id" "int4_ops", "assigned_to" "int4_ops", "patch_status_id" "int4_ops" );
CREATE  INDEX "patch_groupid_assignedto" on "patch" using btree ( "group_id" "int4_ops", "assigned_to" "int4_ops" );
CREATE  INDEX "patch_groupid_status" on "patch" using btree ( "group_id" "int4_ops", "patch_status_id" "int4_ops" );
CREATE  INDEX "patch_group_group_id" on "patch_category" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "patch_history_patch_id" on "patch_history" using btree ( "patch_id" "int4_ops" );
CREATE  INDEX "people_job_group_id" on "people_job" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "project_assigned_to_assigned_to" on "project_assigned_to" using btree ( "assigned_to_id" "int4_ops" );
CREATE  INDEX "project_assigned_to_task_id" on "project_assigned_to" using btree ( "project_task_id" "int4_ops" );
CREATE  INDEX "project_is_dependent_on_task_id" on "project_dependencies" using btree ( "is_dependent_on_task_id" "int4_ops" );
CREATE  INDEX "project_dependencies_task_id" on "project_dependencies" using btree ( "project_task_id" "int4_ops" );
CREATE  INDEX "project_group_list_group_id" on "project_group_list" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "project_history_task_id" on "project_history" using btree ( "project_task_id" "int4_ops" );
CREATE  INDEX "project_metric_group" on "project_metric" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "project_task_group_project_id" on "project_task" using btree ( "group_project_id" "int4_ops" );
CREATE  INDEX "projecttask_projid_status" on "project_task" using btree ( "group_project_id" "int4_ops", "status_id" "int4_ops" );
CREATE  INDEX "projectweeklymetric_ranking" on "project_weekly_metric" using btree ( "ranking" "int4_ops" );
CREATE  INDEX "project_metric_weekly_group" on "project_weekly_metric" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "session_user_id" on "session" using btree ( "user_id" "int4_ops" );
CREATE  INDEX "session_time" on "session" using btree ( "time" "int4_ops" );
CREATE  INDEX "snippet_language" on "snippet" using btree ( "language" "int4_ops" );
CREATE  INDEX "snippet_category" on "snippet" using btree ( "category" "int4_ops" );
CREATE  INDEX "snippet_package_language" on "snippet_package" using btree ( "language" "int4_ops" );
CREATE  INDEX "snippet_package_category" on "snippet_package" using btree ( "category" "int4_ops" );
CREATE  INDEX "snippet_package_item_pkg_ver" on "snippet_package_item" using btree ( "snippet_package_version_id" "int4_ops" );
CREATE  INDEX "snippet_package_version_pkg_id" on "snippet_package_version" using btree ( "snippet_package_id" "int4_ops" );
CREATE  INDEX "snippet_version_snippet_id" on "snippet_version" using btree ( "snippet_id" "int4_ops" );
CREATE  INDEX "pages_by_day_day" on "stats_agg_pages_by_day" using btree ( "day" "int4_ops" );
CREATE  INDEX "stats_agr_filerelease_group_id" on "stats_agr_filerelease" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "stats_agr_filerelease_filerelea" on "stats_agr_filerelease" using btree ( "filerelease_id" "int4_ops" );
CREATE  INDEX "project_agr_log_group" on "stats_agr_project" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "ftpdl_group_id" on "stats_ftp_downloads" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "ftpdl_fid" on "stats_ftp_downloads" using btree ( "filerelease_id" "int4_ops" );
CREATE  INDEX "ftpdl_day" on "stats_ftp_downloads" using btree ( "day" "int4_ops" );
CREATE  INDEX "httpdl_group_id" on "stats_http_downloads" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "httpdl_fid" on "stats_http_downloads" using btree ( "filerelease_id" "int4_ops" );
CREATE  INDEX "httpdl_day" on "stats_http_downloads" using btree ( "day" "int4_ops" );
CREATE  INDEX "archive_project_monthday" on "stats_project" using btree ( "month" "int4_ops", "day" "int4_ops" );
CREATE  INDEX "project_log_group" on "stats_project" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "archive_project_week" on "stats_project" using btree ( "week" "int4_ops" );
CREATE  INDEX "archive_project_day" on "stats_project" using btree ( "day" "int4_ops" );
CREATE  INDEX "archive_project_month" on "stats_project" using btree ( "month" "int4_ops" );
CREATE  INDEX "stats_project_tmp_group_id" on "stats_project_tmp" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "project_stats_week" on "stats_project_tmp" using btree ( "week" "int4_ops" );
CREATE  INDEX "project_stats_month" on "stats_project_tmp" using btree ( "month" "int4_ops" );
CREATE  INDEX "project_stats_day" on "stats_project_tmp" using btree ( "day" "int4_ops" );
CREATE  INDEX "stats_site_monthday" on "stats_site" using btree ( "month" "int4_ops", "day" "int4_ops" );
CREATE  INDEX "stats_site_week" on "stats_site" using btree ( "week" "int4_ops" );
CREATE  INDEX "stats_site_day" on "stats_site" using btree ( "day" "int4_ops" );
CREATE  INDEX "stats_site_month" on "stats_site" using btree ( "month" "int4_ops" );
CREATE  INDEX "support_group_id" on "support" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "support_groupid_assignedto" on "support" using btree ( "group_id" "int4_ops", "assigned_to" "int4_ops" );
CREATE  INDEX "support_groupid_assignedto_stat" on "support" using btree ( "group_id" "int4_ops", "assigned_to" "int4_ops", "support_status_id" "int4_ops" );
CREATE  INDEX "support_groupid_status" on "support" using btree ( "group_id" "int4_ops", "support_status_id" "int4_ops" );
CREATE  INDEX "support_canned_response_group_i" on "support_canned_responses" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "support_group_group_id" on "support_category" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "support_history_support_id" on "support_history" using btree ( "support_id" "int4_ops" );
CREATE  INDEX "support_messages_support_id" on "support_messages" using btree ( "support_id" "int4_ops" );
CREATE  INDEX "supported_languages_code" on "supported_languages" using btree ( "language_code" "bpchar_ops" );
CREATE  INDEX "survey_questions_group" on "survey_questions" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "survey_rating_aggregate_type_id" on "survey_rating_aggregate" using btree ( "type" "int4_ops", "id" "int4_ops" );
CREATE  INDEX "survey_rating_responses_user_ty" on "survey_rating_response" using btree ( "user_id" "int4_ops", "type" "int4_ops", "id" "int4_ops" );
CREATE  INDEX "survey_rating_responses_type_id" on "survey_rating_response" using btree ( "type" "int4_ops", "id" "int4_ops" );
CREATE  INDEX "survey_responses_group_id" on "survey_responses" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "survey_responses_user_survey_qu" on "survey_responses" using btree ( "user_id" "int4_ops", "survey_id" "int4_ops", "question_id" "int4_ops" );
CREATE  INDEX "survey_responses_user_survey" on "survey_responses" using btree ( "user_id" "int4_ops", "survey_id" "int4_ops" );
CREATE  INDEX "survey_responses_survey_questio" on "survey_responses" using btree ( "survey_id" "int4_ops", "question_id" "int4_ops" );
CREATE  INDEX "surveys_group" on "surveys" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "rank_forumposts_week_idx" on "top_group" using btree ( "rank_forumposts_week" "int4_ops" );
CREATE  INDEX "rank_downloads_week_idx" on "top_group" using btree ( "rank_downloads_week" "int4_ops" );
CREATE  INDEX "pageviews_proj_idx" on "top_group" using btree ( "pageviews_proj" "int4_ops" );
CREATE  INDEX "rank_userrank_idx" on "top_group" using btree ( "rank_userrank" "int4_ops" );
CREATE  INDEX "rank_downloads_all_idx" on "top_group" using btree ( "rank_downloads_all" "int4_ops" );
CREATE  INDEX "parent_idx" on "trove_cat" using btree ( "parent" "int4_ops" );
CREATE  INDEX "root_parent_idx" on "trove_cat" using btree ( "root_parent" "int4_ops" );
CREATE  INDEX "version_idx" on "trove_cat" using btree ( "version" "int4_ops" );
CREATE  INDEX "trove_group_link_group_id" on "trove_group_link" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "trove_group_link_cat_id" on "trove_group_link" using btree ( "trove_cat_id" "int4_ops" );
CREATE  INDEX "user_bookmark_user_id" on "user_bookmarks" using btree ( "user_id" "int4_ops" );
CREATE  INDEX "user_diary_user" on "user_diary" using btree ( "user_id" "int4_ops" );
CREATE  INDEX "user_diary_user_date" on "user_diary" using btree ( "user_id" "int4_ops", "date_posted" "int4_ops" );
CREATE  INDEX "user_diary_date" on "user_diary" using btree ( "date_posted" "int4_ops" );
CREATE  INDEX "user_diary_monitor_user" on "user_diary_monitor" using btree ( "user_id" "int4_ops" );
CREATE  INDEX "user_diary_monitor_monitored_us" on "user_diary_monitor" using btree ( "monitored_user" "int4_ops" );
CREATE  INDEX "user_group_group_id" on "user_group" using btree ( "group_id" "int4_ops" );
CREATE  INDEX "bug_flags_idx" on "user_group" using btree ( "bug_flags" "int4_ops" );
CREATE  INDEX "project_flags_idx" on "user_group" using btree ( "project_flags" "int4_ops" );
CREATE  INDEX "user_group_user_id" on "user_group" using btree ( "user_id" "int4_ops" );
CREATE  INDEX "admin_flags_idx" on "user_group" using btree ( "admin_flags" "bpchar_ops" );
CREATE  INDEX "forum_flags_idx" on "user_group" using btree ( "forum_flags" "int4_ops" );
CREATE  INDEX "user_metric0_user_id" on "user_metric0" using btree ( "user_id" "int4_ops" );
CREATE  INDEX "user_pref_user_id" on "user_preferences" using btree ( "user_id" "int4_ops" );
CREATE  INDEX "user_ratings_rated_by" on "user_ratings" using btree ( "rated_by" "int4_ops" );
CREATE  INDEX "user_ratings_user_id" on "user_ratings" using btree ( "user_id" "int4_ops" );
CREATE  INDEX "users_status" on "users" using btree ( "status" "bpchar_ops" );
CREATE  INDEX "user_user" on "users" using btree ( "status" "bpchar_ops" );
CREATE  INDEX "idx_users_username" on "users" using btree ( "user_name" "text_ops" );
CREATE  INDEX "users_user_pw" on "users" using btree ( "user_pw" "varchar_ops" );
CREATE  INDEX "troveagg_trovecatid" on "trove_agg" using btree ( "trove_cat_id" "int4_ops" );
CREATE CONSTRAINT TRIGGER "user_group_user_id_fk" AFTER INSERT OR UPDATE ON "user_group"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('user_group_user_id_fk', 'user_group', 'users', 'FULL', 'user_id', 'user_id');
CREATE CONSTRAINT TRIGGER "user_group_user_id_fk" AFTER DELETE ON "users"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('user_group_user_id_fk', 'user_group', 'users', 'FULL', 'user_id', 'user_id');
CREATE CONSTRAINT TRIGGER "user_group_user_id_fk" AFTER UPDATE ON "users"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('user_group_user_id_fk', 'user_group', 'users', 'FULL', 'user_id', 'user_id');
CREATE CONSTRAINT TRIGGER "user_group_group_id_fk" AFTER INSERT OR UPDATE ON "user_group"  NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('user_group_group_id_fk', 'user_group', 'groups', 'FULL', 'group_id', 'group_id');
CREATE CONSTRAINT TRIGGER "user_group_group_id_fk" AFTER DELETE ON "groups"