Show More
1.6.0.sql
2861 lines
| 111.7 KiB
| text/x-sql
|
TransactSqlLexer
r1 | -- | |||
-- PostgreSQL database dump | ||||
-- | ||||
SET statement_timeout = 0; | ||||
SET client_encoding = 'UTF8'; | ||||
SET standard_conforming_strings = on; | ||||
SET check_function_bodies = false; | ||||
SET client_min_messages = warning; | ||||
-- | ||||
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: | ||||
-- | ||||
CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog; | ||||
-- | ||||
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: | ||||
-- | ||||
COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language'; | ||||
SET search_path = public, pg_catalog; | ||||
SET default_tablespace = ''; | ||||
SET default_with_oids = false; | ||||
-- | ||||
-- Name: cache_invalidation; Type: TABLE; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE TABLE cache_invalidation ( | ||||
cache_id integer NOT NULL, | ||||
cache_key character varying(255), | ||||
cache_args character varying(255), | ||||
cache_active boolean | ||||
); | ||||
ALTER TABLE public.cache_invalidation OWNER TO postgres; | ||||
-- | ||||
-- Name: cache_invalidation_cache_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres | ||||
-- | ||||
CREATE SEQUENCE cache_invalidation_cache_id_seq | ||||
START WITH 1 | ||||
INCREMENT BY 1 | ||||
NO MINVALUE | ||||
NO MAXVALUE | ||||
CACHE 1; | ||||
ALTER TABLE public.cache_invalidation_cache_id_seq OWNER TO postgres; | ||||
-- | ||||
-- Name: cache_invalidation_cache_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER SEQUENCE cache_invalidation_cache_id_seq OWNED BY cache_invalidation.cache_id; | ||||
-- | ||||
-- Name: changeset_comments; Type: TABLE; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE TABLE changeset_comments ( | ||||
comment_id integer NOT NULL, | ||||
repo_id integer NOT NULL, | ||||
revision character varying(40), | ||||
pull_request_id integer, | ||||
line_no character varying(10), | ||||
hl_lines character varying(512), | ||||
f_path character varying(1000), | ||||
user_id integer NOT NULL, | ||||
text text NOT NULL, | ||||
created_on timestamp without time zone NOT NULL, | ||||
modified_at timestamp without time zone NOT NULL | ||||
); | ||||
ALTER TABLE public.changeset_comments OWNER TO postgres; | ||||
-- | ||||
-- Name: changeset_comments_comment_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres | ||||
-- | ||||
CREATE SEQUENCE changeset_comments_comment_id_seq | ||||
START WITH 1 | ||||
INCREMENT BY 1 | ||||
NO MINVALUE | ||||
NO MAXVALUE | ||||
CACHE 1; | ||||
ALTER TABLE public.changeset_comments_comment_id_seq OWNER TO postgres; | ||||
-- | ||||
-- Name: changeset_comments_comment_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER SEQUENCE changeset_comments_comment_id_seq OWNED BY changeset_comments.comment_id; | ||||
-- | ||||
-- Name: changeset_statuses; Type: TABLE; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE TABLE changeset_statuses ( | ||||
changeset_status_id integer NOT NULL, | ||||
repo_id integer NOT NULL, | ||||
user_id integer NOT NULL, | ||||
revision character varying(40) NOT NULL, | ||||
status character varying(128) NOT NULL, | ||||
changeset_comment_id integer, | ||||
modified_at timestamp without time zone NOT NULL, | ||||
version integer NOT NULL, | ||||
pull_request_id integer | ||||
); | ||||
ALTER TABLE public.changeset_statuses OWNER TO postgres; | ||||
-- | ||||
-- Name: changeset_statuses_changeset_status_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres | ||||
-- | ||||
CREATE SEQUENCE changeset_statuses_changeset_status_id_seq | ||||
START WITH 1 | ||||
INCREMENT BY 1 | ||||
NO MINVALUE | ||||
NO MAXVALUE | ||||
CACHE 1; | ||||
ALTER TABLE public.changeset_statuses_changeset_status_id_seq OWNER TO postgres; | ||||
-- | ||||
-- Name: changeset_statuses_changeset_status_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER SEQUENCE changeset_statuses_changeset_status_id_seq OWNED BY changeset_statuses.changeset_status_id; | ||||
-- | ||||
-- Name: db_migrate_version; Type: TABLE; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE TABLE db_migrate_version ( | ||||
repository_id character varying(250) NOT NULL, | ||||
repository_path text, | ||||
version integer | ||||
); | ||||
ALTER TABLE public.db_migrate_version OWNER TO postgres; | ||||
-- | ||||
-- Name: groups; Type: TABLE; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE TABLE groups ( | ||||
group_id integer NOT NULL, | ||||
group_name character varying(255) NOT NULL, | ||||
group_parent_id integer, | ||||
group_description character varying(10000), | ||||
enable_locking boolean NOT NULL, | ||||
CONSTRAINT groups_check CHECK ((group_id <> group_parent_id)) | ||||
); | ||||
ALTER TABLE public.groups OWNER TO postgres; | ||||
-- | ||||
-- Name: groups_group_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres | ||||
-- | ||||
CREATE SEQUENCE groups_group_id_seq | ||||
START WITH 1 | ||||
INCREMENT BY 1 | ||||
NO MINVALUE | ||||
NO MAXVALUE | ||||
CACHE 1; | ||||
ALTER TABLE public.groups_group_id_seq OWNER TO postgres; | ||||
-- | ||||
-- Name: groups_group_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER SEQUENCE groups_group_id_seq OWNED BY groups.group_id; | ||||
-- | ||||
-- Name: notifications; Type: TABLE; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE TABLE notifications ( | ||||
notification_id integer NOT NULL, | ||||
subject character varying(512), | ||||
body text, | ||||
created_by integer, | ||||
created_on timestamp without time zone NOT NULL, | ||||
type character varying(256) | ||||
); | ||||
ALTER TABLE public.notifications OWNER TO postgres; | ||||
-- | ||||
-- Name: notifications_notification_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres | ||||
-- | ||||
CREATE SEQUENCE notifications_notification_id_seq | ||||
START WITH 1 | ||||
INCREMENT BY 1 | ||||
NO MINVALUE | ||||
NO MAXVALUE | ||||
CACHE 1; | ||||
ALTER TABLE public.notifications_notification_id_seq OWNER TO postgres; | ||||
-- | ||||
-- Name: notifications_notification_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER SEQUENCE notifications_notification_id_seq OWNED BY notifications.notification_id; | ||||
-- | ||||
-- Name: permissions; Type: TABLE; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE TABLE permissions ( | ||||
permission_id integer NOT NULL, | ||||
permission_name character varying(255), | ||||
permission_longname character varying(255) | ||||
); | ||||
ALTER TABLE public.permissions OWNER TO postgres; | ||||
-- | ||||
-- Name: permissions_permission_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres | ||||
-- | ||||
CREATE SEQUENCE permissions_permission_id_seq | ||||
START WITH 1 | ||||
INCREMENT BY 1 | ||||
NO MINVALUE | ||||
NO MAXVALUE | ||||
CACHE 1; | ||||
ALTER TABLE public.permissions_permission_id_seq OWNER TO postgres; | ||||
-- | ||||
-- Name: permissions_permission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER SEQUENCE permissions_permission_id_seq OWNED BY permissions.permission_id; | ||||
-- | ||||
-- Name: pull_request_reviewers; Type: TABLE; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE TABLE pull_request_reviewers ( | ||||
pull_requests_reviewers_id integer NOT NULL, | ||||
pull_request_id integer NOT NULL, | ||||
user_id integer | ||||
); | ||||
ALTER TABLE public.pull_request_reviewers OWNER TO postgres; | ||||
-- | ||||
-- Name: pull_request_reviewers_pull_requests_reviewers_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres | ||||
-- | ||||
CREATE SEQUENCE pull_request_reviewers_pull_requests_reviewers_id_seq | ||||
START WITH 1 | ||||
INCREMENT BY 1 | ||||
NO MINVALUE | ||||
NO MAXVALUE | ||||
CACHE 1; | ||||
ALTER TABLE public.pull_request_reviewers_pull_requests_reviewers_id_seq OWNER TO postgres; | ||||
-- | ||||
-- Name: pull_request_reviewers_pull_requests_reviewers_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER SEQUENCE pull_request_reviewers_pull_requests_reviewers_id_seq OWNED BY pull_request_reviewers.pull_requests_reviewers_id; | ||||
-- | ||||
-- Name: pull_requests; Type: TABLE; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE TABLE pull_requests ( | ||||
pull_request_id integer NOT NULL, | ||||
title character varying(256), | ||||
description text, | ||||
status character varying(256) NOT NULL, | ||||
created_on timestamp without time zone NOT NULL, | ||||
updated_on timestamp without time zone NOT NULL, | ||||
user_id integer NOT NULL, | ||||
revisions text, | ||||
org_repo_id integer NOT NULL, | ||||
org_ref character varying(256) NOT NULL, | ||||
other_repo_id integer NOT NULL, | ||||
other_ref character varying(256) NOT NULL | ||||
); | ||||
ALTER TABLE public.pull_requests OWNER TO postgres; | ||||
-- | ||||
-- Name: pull_requests_pull_request_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres | ||||
-- | ||||
CREATE SEQUENCE pull_requests_pull_request_id_seq | ||||
START WITH 1 | ||||
INCREMENT BY 1 | ||||
NO MINVALUE | ||||
NO MAXVALUE | ||||
CACHE 1; | ||||
ALTER TABLE public.pull_requests_pull_request_id_seq OWNER TO postgres; | ||||
-- | ||||
-- Name: pull_requests_pull_request_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER SEQUENCE pull_requests_pull_request_id_seq OWNED BY pull_requests.pull_request_id; | ||||
-- | ||||
-- Name: repo_to_perm; Type: TABLE; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE TABLE repo_to_perm ( | ||||
repo_to_perm_id integer NOT NULL, | ||||
user_id integer NOT NULL, | ||||
permission_id integer NOT NULL, | ||||
repository_id integer NOT NULL | ||||
); | ||||
ALTER TABLE public.repo_to_perm OWNER TO postgres; | ||||
-- | ||||
-- Name: repo_to_perm_repo_to_perm_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres | ||||
-- | ||||
CREATE SEQUENCE repo_to_perm_repo_to_perm_id_seq | ||||
START WITH 1 | ||||
INCREMENT BY 1 | ||||
NO MINVALUE | ||||
NO MAXVALUE | ||||
CACHE 1; | ||||
ALTER TABLE public.repo_to_perm_repo_to_perm_id_seq OWNER TO postgres; | ||||
-- | ||||
-- Name: repo_to_perm_repo_to_perm_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER SEQUENCE repo_to_perm_repo_to_perm_id_seq OWNED BY repo_to_perm.repo_to_perm_id; | ||||
-- | ||||
-- Name: repositories; Type: TABLE; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE TABLE repositories ( | ||||
repo_id integer NOT NULL, | ||||
repo_name character varying(255) NOT NULL, | ||||
clone_uri character varying(255), | ||||
repo_type character varying(255) NOT NULL, | ||||
user_id integer NOT NULL, | ||||
private boolean, | ||||
statistics boolean, | ||||
downloads boolean, | ||||
description character varying(10000), | ||||
created_on timestamp without time zone, | ||||
updated_on timestamp without time zone, | ||||
landing_revision character varying(255) NOT NULL, | ||||
enable_locking boolean NOT NULL, | ||||
locked character varying(255), | ||||
changeset_cache bytea, | ||||
fork_id integer, | ||||
group_id integer | ||||
); | ||||
ALTER TABLE public.repositories OWNER TO postgres; | ||||
-- | ||||
-- Name: repositories_fields; Type: TABLE; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE TABLE repositories_fields ( | ||||
repo_field_id integer NOT NULL, | ||||
repository_id integer NOT NULL, | ||||
field_key character varying(250), | ||||
field_label character varying(1024) NOT NULL, | ||||
field_value character varying(10000) NOT NULL, | ||||
field_desc character varying(1024) NOT NULL, | ||||
field_type character varying(256) NOT NULL, | ||||
created_on timestamp without time zone NOT NULL | ||||
); | ||||
ALTER TABLE public.repositories_fields OWNER TO postgres; | ||||
-- | ||||
-- Name: repositories_fields_repo_field_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres | ||||
-- | ||||
CREATE SEQUENCE repositories_fields_repo_field_id_seq | ||||
START WITH 1 | ||||
INCREMENT BY 1 | ||||
NO MINVALUE | ||||
NO MAXVALUE | ||||
CACHE 1; | ||||
ALTER TABLE public.repositories_fields_repo_field_id_seq OWNER TO postgres; | ||||
-- | ||||
-- Name: repositories_fields_repo_field_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER SEQUENCE repositories_fields_repo_field_id_seq OWNED BY repositories_fields.repo_field_id; | ||||
-- | ||||
-- Name: repositories_repo_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres | ||||
-- | ||||
CREATE SEQUENCE repositories_repo_id_seq | ||||
START WITH 1 | ||||
INCREMENT BY 1 | ||||
NO MINVALUE | ||||
NO MAXVALUE | ||||
CACHE 1; | ||||
ALTER TABLE public.repositories_repo_id_seq OWNER TO postgres; | ||||
-- | ||||
-- Name: repositories_repo_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER SEQUENCE repositories_repo_id_seq OWNED BY repositories.repo_id; | ||||
-- | ||||
-- Name: rhodecode_settings; Type: TABLE; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE TABLE rhodecode_settings ( | ||||
app_settings_id integer NOT NULL, | ||||
app_settings_name character varying(255), | ||||
app_settings_value character varying(255) | ||||
); | ||||
ALTER TABLE public.rhodecode_settings OWNER TO postgres; | ||||
-- | ||||
-- Name: rhodecode_settings_app_settings_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres | ||||
-- | ||||
CREATE SEQUENCE rhodecode_settings_app_settings_id_seq | ||||
START WITH 1 | ||||
INCREMENT BY 1 | ||||
NO MINVALUE | ||||
NO MAXVALUE | ||||
CACHE 1; | ||||
ALTER TABLE public.rhodecode_settings_app_settings_id_seq OWNER TO postgres; | ||||
-- | ||||
-- Name: rhodecode_settings_app_settings_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER SEQUENCE rhodecode_settings_app_settings_id_seq OWNED BY rhodecode_settings.app_settings_id; | ||||
-- | ||||
-- Name: rhodecode_ui; Type: TABLE; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE TABLE rhodecode_ui ( | ||||
ui_id integer NOT NULL, | ||||
ui_section character varying(255), | ||||
ui_key character varying(255), | ||||
ui_value character varying(255), | ||||
ui_active boolean | ||||
); | ||||
ALTER TABLE public.rhodecode_ui OWNER TO postgres; | ||||
-- | ||||
-- Name: rhodecode_ui_ui_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres | ||||
-- | ||||
CREATE SEQUENCE rhodecode_ui_ui_id_seq | ||||
START WITH 1 | ||||
INCREMENT BY 1 | ||||
NO MINVALUE | ||||
NO MAXVALUE | ||||
CACHE 1; | ||||
ALTER TABLE public.rhodecode_ui_ui_id_seq OWNER TO postgres; | ||||
-- | ||||
-- Name: rhodecode_ui_ui_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER SEQUENCE rhodecode_ui_ui_id_seq OWNED BY rhodecode_ui.ui_id; | ||||
-- | ||||
-- Name: statistics; Type: TABLE; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE TABLE statistics ( | ||||
stat_id integer NOT NULL, | ||||
repository_id integer NOT NULL, | ||||
stat_on_revision integer NOT NULL, | ||||
commit_activity bytea NOT NULL, | ||||
commit_activity_combined bytea NOT NULL, | ||||
languages bytea NOT NULL | ||||
); | ||||
ALTER TABLE public.statistics OWNER TO postgres; | ||||
-- | ||||
-- Name: statistics_stat_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres | ||||
-- | ||||
CREATE SEQUENCE statistics_stat_id_seq | ||||
START WITH 1 | ||||
INCREMENT BY 1 | ||||
NO MINVALUE | ||||
NO MAXVALUE | ||||
CACHE 1; | ||||
ALTER TABLE public.statistics_stat_id_seq OWNER TO postgres; | ||||
-- | ||||
-- Name: statistics_stat_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER SEQUENCE statistics_stat_id_seq OWNED BY statistics.stat_id; | ||||
-- | ||||
-- Name: user_email_map; Type: TABLE; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE TABLE user_email_map ( | ||||
email_id integer NOT NULL, | ||||
user_id integer, | ||||
email character varying(255) | ||||
); | ||||
ALTER TABLE public.user_email_map OWNER TO postgres; | ||||
-- | ||||
-- Name: user_email_map_email_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres | ||||
-- | ||||
CREATE SEQUENCE user_email_map_email_id_seq | ||||
START WITH 1 | ||||
INCREMENT BY 1 | ||||
NO MINVALUE | ||||
NO MAXVALUE | ||||
CACHE 1; | ||||
ALTER TABLE public.user_email_map_email_id_seq OWNER TO postgres; | ||||
-- | ||||
-- Name: user_email_map_email_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER SEQUENCE user_email_map_email_id_seq OWNED BY user_email_map.email_id; | ||||
-- | ||||
-- Name: user_followings; Type: TABLE; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE TABLE user_followings ( | ||||
user_following_id integer NOT NULL, | ||||
user_id integer NOT NULL, | ||||
follows_repository_id integer, | ||||
follows_user_id integer, | ||||
follows_from timestamp without time zone | ||||
); | ||||
ALTER TABLE public.user_followings OWNER TO postgres; | ||||
-- | ||||
-- Name: user_followings_user_following_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres | ||||
-- | ||||
CREATE SEQUENCE user_followings_user_following_id_seq | ||||
START WITH 1 | ||||
INCREMENT BY 1 | ||||
NO MINVALUE | ||||
NO MAXVALUE | ||||
CACHE 1; | ||||
ALTER TABLE public.user_followings_user_following_id_seq OWNER TO postgres; | ||||
-- | ||||
-- Name: user_followings_user_following_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER SEQUENCE user_followings_user_following_id_seq OWNED BY user_followings.user_following_id; | ||||
-- | ||||
-- Name: user_ip_map; Type: TABLE; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE TABLE user_ip_map ( | ||||
ip_id integer NOT NULL, | ||||
user_id integer, | ||||
ip_addr character varying(255), | ||||
active boolean | ||||
); | ||||
ALTER TABLE public.user_ip_map OWNER TO postgres; | ||||
-- | ||||
-- Name: user_ip_map_ip_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres | ||||
-- | ||||
CREATE SEQUENCE user_ip_map_ip_id_seq | ||||
START WITH 1 | ||||
INCREMENT BY 1 | ||||
NO MINVALUE | ||||
NO MAXVALUE | ||||
CACHE 1; | ||||
ALTER TABLE public.user_ip_map_ip_id_seq OWNER TO postgres; | ||||
-- | ||||
-- Name: user_ip_map_ip_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER SEQUENCE user_ip_map_ip_id_seq OWNED BY user_ip_map.ip_id; | ||||
-- | ||||
-- Name: user_logs; Type: TABLE; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE TABLE user_logs ( | ||||
user_log_id integer NOT NULL, | ||||
user_id integer, | ||||
username character varying(255), | ||||
repository_id integer, | ||||
repository_name character varying(255), | ||||
user_ip character varying(255), | ||||
action text, | ||||
action_date timestamp without time zone | ||||
); | ||||
ALTER TABLE public.user_logs OWNER TO postgres; | ||||
-- | ||||
-- Name: user_logs_user_log_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres | ||||
-- | ||||
CREATE SEQUENCE user_logs_user_log_id_seq | ||||
START WITH 1 | ||||
INCREMENT BY 1 | ||||
NO MINVALUE | ||||
NO MAXVALUE | ||||
CACHE 1; | ||||
ALTER TABLE public.user_logs_user_log_id_seq OWNER TO postgres; | ||||
-- | ||||
-- Name: user_logs_user_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER SEQUENCE user_logs_user_log_id_seq OWNED BY user_logs.user_log_id; | ||||
-- | ||||
-- Name: user_repo_group_to_perm; Type: TABLE; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE TABLE user_repo_group_to_perm ( | ||||
group_to_perm_id integer NOT NULL, | ||||
user_id integer NOT NULL, | ||||
group_id integer NOT NULL, | ||||
permission_id integer NOT NULL | ||||
); | ||||
ALTER TABLE public.user_repo_group_to_perm OWNER TO postgres; | ||||
-- | ||||
-- Name: user_repo_group_to_perm_group_to_perm_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres | ||||
-- | ||||
CREATE SEQUENCE user_repo_group_to_perm_group_to_perm_id_seq | ||||
START WITH 1 | ||||
INCREMENT BY 1 | ||||
NO MINVALUE | ||||
NO MAXVALUE | ||||
CACHE 1; | ||||
ALTER TABLE public.user_repo_group_to_perm_group_to_perm_id_seq OWNER TO postgres; | ||||
-- | ||||
-- Name: user_repo_group_to_perm_group_to_perm_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER SEQUENCE user_repo_group_to_perm_group_to_perm_id_seq OWNED BY user_repo_group_to_perm.group_to_perm_id; | ||||
-- | ||||
-- Name: user_to_notification; Type: TABLE; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE TABLE user_to_notification ( | ||||
user_id integer NOT NULL, | ||||
notification_id integer NOT NULL, | ||||
read boolean, | ||||
sent_on timestamp without time zone | ||||
); | ||||
ALTER TABLE public.user_to_notification OWNER TO postgres; | ||||
-- | ||||
-- Name: user_to_perm; Type: TABLE; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE TABLE user_to_perm ( | ||||
user_to_perm_id integer NOT NULL, | ||||
user_id integer NOT NULL, | ||||
permission_id integer NOT NULL | ||||
); | ||||
ALTER TABLE public.user_to_perm OWNER TO postgres; | ||||
-- | ||||
-- Name: user_to_perm_user_to_perm_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres | ||||
-- | ||||
CREATE SEQUENCE user_to_perm_user_to_perm_id_seq | ||||
START WITH 1 | ||||
INCREMENT BY 1 | ||||
NO MINVALUE | ||||
NO MAXVALUE | ||||
CACHE 1; | ||||
ALTER TABLE public.user_to_perm_user_to_perm_id_seq OWNER TO postgres; | ||||
-- | ||||
-- Name: user_to_perm_user_to_perm_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER SEQUENCE user_to_perm_user_to_perm_id_seq OWNED BY user_to_perm.user_to_perm_id; | ||||
-- | ||||
-- Name: users; Type: TABLE; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE TABLE users ( | ||||
user_id integer NOT NULL, | ||||
username character varying(255), | ||||
password character varying(255), | ||||
active boolean, | ||||
admin boolean, | ||||
firstname character varying(255), | ||||
lastname character varying(255), | ||||
email character varying(255), | ||||
last_login timestamp without time zone, | ||||
ldap_dn character varying(255), | ||||
api_key character varying(255), | ||||
inherit_default_permissions boolean NOT NULL | ||||
); | ||||
ALTER TABLE public.users OWNER TO postgres; | ||||
-- | ||||
-- Name: users_group_repo_group_to_perm; Type: TABLE; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE TABLE users_group_repo_group_to_perm ( | ||||
users_group_repo_group_to_perm_id integer NOT NULL, | ||||
users_group_id integer NOT NULL, | ||||
group_id integer NOT NULL, | ||||
permission_id integer NOT NULL | ||||
); | ||||
ALTER TABLE public.users_group_repo_group_to_perm OWNER TO postgres; | ||||
-- | ||||
-- Name: users_group_repo_group_to_per_users_group_repo_group_to_per_seq; Type: SEQUENCE; Schema: public; Owner: postgres | ||||
-- | ||||
CREATE SEQUENCE users_group_repo_group_to_per_users_group_repo_group_to_per_seq | ||||
START WITH 1 | ||||
INCREMENT BY 1 | ||||
NO MINVALUE | ||||
NO MAXVALUE | ||||
CACHE 1; | ||||
ALTER TABLE public.users_group_repo_group_to_per_users_group_repo_group_to_per_seq OWNER TO postgres; | ||||
-- | ||||
-- Name: users_group_repo_group_to_per_users_group_repo_group_to_per_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER SEQUENCE users_group_repo_group_to_per_users_group_repo_group_to_per_seq OWNED BY users_group_repo_group_to_perm.users_group_repo_group_to_perm_id; | ||||
-- | ||||
-- Name: users_group_repo_to_perm; Type: TABLE; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE TABLE users_group_repo_to_perm ( | ||||
users_group_to_perm_id integer NOT NULL, | ||||
users_group_id integer NOT NULL, | ||||
permission_id integer NOT NULL, | ||||
repository_id integer NOT NULL | ||||
); | ||||
ALTER TABLE public.users_group_repo_to_perm OWNER TO postgres; | ||||
-- | ||||
-- Name: users_group_repo_to_perm_users_group_to_perm_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres | ||||
-- | ||||
CREATE SEQUENCE users_group_repo_to_perm_users_group_to_perm_id_seq | ||||
START WITH 1 | ||||
INCREMENT BY 1 | ||||
NO MINVALUE | ||||
NO MAXVALUE | ||||
CACHE 1; | ||||
ALTER TABLE public.users_group_repo_to_perm_users_group_to_perm_id_seq OWNER TO postgres; | ||||
-- | ||||
-- Name: users_group_repo_to_perm_users_group_to_perm_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER SEQUENCE users_group_repo_to_perm_users_group_to_perm_id_seq OWNED BY users_group_repo_to_perm.users_group_to_perm_id; | ||||
-- | ||||
-- Name: users_group_to_perm; Type: TABLE; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE TABLE users_group_to_perm ( | ||||
users_group_to_perm_id integer NOT NULL, | ||||
users_group_id integer NOT NULL, | ||||
permission_id integer NOT NULL | ||||
); | ||||
ALTER TABLE public.users_group_to_perm OWNER TO postgres; | ||||
-- | ||||
-- Name: users_group_to_perm_users_group_to_perm_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres | ||||
-- | ||||
CREATE SEQUENCE users_group_to_perm_users_group_to_perm_id_seq | ||||
START WITH 1 | ||||
INCREMENT BY 1 | ||||
NO MINVALUE | ||||
NO MAXVALUE | ||||
CACHE 1; | ||||
ALTER TABLE public.users_group_to_perm_users_group_to_perm_id_seq OWNER TO postgres; | ||||
-- | ||||
-- Name: users_group_to_perm_users_group_to_perm_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER SEQUENCE users_group_to_perm_users_group_to_perm_id_seq OWNED BY users_group_to_perm.users_group_to_perm_id; | ||||
-- | ||||
-- Name: users_groups; Type: TABLE; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE TABLE users_groups ( | ||||
users_group_id integer NOT NULL, | ||||
users_group_name character varying(255) NOT NULL, | ||||
users_group_active boolean, | ||||
users_group_inherit_default_permissions boolean NOT NULL | ||||
); | ||||
ALTER TABLE public.users_groups OWNER TO postgres; | ||||
-- | ||||
-- Name: users_groups_members; Type: TABLE; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE TABLE users_groups_members ( | ||||
users_group_member_id integer NOT NULL, | ||||
users_group_id integer NOT NULL, | ||||
user_id integer NOT NULL | ||||
); | ||||
ALTER TABLE public.users_groups_members OWNER TO postgres; | ||||
-- | ||||
-- Name: users_groups_members_users_group_member_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres | ||||
-- | ||||
CREATE SEQUENCE users_groups_members_users_group_member_id_seq | ||||
START WITH 1 | ||||
INCREMENT BY 1 | ||||
NO MINVALUE | ||||
NO MAXVALUE | ||||
CACHE 1; | ||||
ALTER TABLE public.users_groups_members_users_group_member_id_seq OWNER TO postgres; | ||||
-- | ||||
-- Name: users_groups_members_users_group_member_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER SEQUENCE users_groups_members_users_group_member_id_seq OWNED BY users_groups_members.users_group_member_id; | ||||
-- | ||||
-- Name: users_groups_users_group_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres | ||||
-- | ||||
CREATE SEQUENCE users_groups_users_group_id_seq | ||||
START WITH 1 | ||||
INCREMENT BY 1 | ||||
NO MINVALUE | ||||
NO MAXVALUE | ||||
CACHE 1; | ||||
ALTER TABLE public.users_groups_users_group_id_seq OWNER TO postgres; | ||||
-- | ||||
-- Name: users_groups_users_group_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER SEQUENCE users_groups_users_group_id_seq OWNED BY users_groups.users_group_id; | ||||
-- | ||||
-- Name: users_user_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres | ||||
-- | ||||
CREATE SEQUENCE users_user_id_seq | ||||
START WITH 1 | ||||
INCREMENT BY 1 | ||||
NO MINVALUE | ||||
NO MAXVALUE | ||||
CACHE 1; | ||||
ALTER TABLE public.users_user_id_seq OWNER TO postgres; | ||||
-- | ||||
-- Name: users_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER SEQUENCE users_user_id_seq OWNED BY users.user_id; | ||||
-- | ||||
-- Name: cache_id; Type: DEFAULT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY cache_invalidation ALTER COLUMN cache_id SET DEFAULT nextval('cache_invalidation_cache_id_seq'::regclass); | ||||
-- | ||||
-- Name: comment_id; Type: DEFAULT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY changeset_comments ALTER COLUMN comment_id SET DEFAULT nextval('changeset_comments_comment_id_seq'::regclass); | ||||
-- | ||||
-- Name: changeset_status_id; Type: DEFAULT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY changeset_statuses ALTER COLUMN changeset_status_id SET DEFAULT nextval('changeset_statuses_changeset_status_id_seq'::regclass); | ||||
-- | ||||
-- Name: group_id; Type: DEFAULT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY groups ALTER COLUMN group_id SET DEFAULT nextval('groups_group_id_seq'::regclass); | ||||
-- | ||||
-- Name: notification_id; Type: DEFAULT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY notifications ALTER COLUMN notification_id SET DEFAULT nextval('notifications_notification_id_seq'::regclass); | ||||
-- | ||||
-- Name: permission_id; Type: DEFAULT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY permissions ALTER COLUMN permission_id SET DEFAULT nextval('permissions_permission_id_seq'::regclass); | ||||
-- | ||||
-- Name: pull_requests_reviewers_id; Type: DEFAULT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY pull_request_reviewers ALTER COLUMN pull_requests_reviewers_id SET DEFAULT nextval('pull_request_reviewers_pull_requests_reviewers_id_seq'::regclass); | ||||
-- | ||||
-- Name: pull_request_id; Type: DEFAULT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY pull_requests ALTER COLUMN pull_request_id SET DEFAULT nextval('pull_requests_pull_request_id_seq'::regclass); | ||||
-- | ||||
-- Name: repo_to_perm_id; Type: DEFAULT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY repo_to_perm ALTER COLUMN repo_to_perm_id SET DEFAULT nextval('repo_to_perm_repo_to_perm_id_seq'::regclass); | ||||
-- | ||||
-- Name: repo_id; Type: DEFAULT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY repositories ALTER COLUMN repo_id SET DEFAULT nextval('repositories_repo_id_seq'::regclass); | ||||
-- | ||||
-- Name: repo_field_id; Type: DEFAULT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY repositories_fields ALTER COLUMN repo_field_id SET DEFAULT nextval('repositories_fields_repo_field_id_seq'::regclass); | ||||
-- | ||||
-- Name: app_settings_id; Type: DEFAULT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY rhodecode_settings ALTER COLUMN app_settings_id SET DEFAULT nextval('rhodecode_settings_app_settings_id_seq'::regclass); | ||||
-- | ||||
-- Name: ui_id; Type: DEFAULT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY rhodecode_ui ALTER COLUMN ui_id SET DEFAULT nextval('rhodecode_ui_ui_id_seq'::regclass); | ||||
-- | ||||
-- Name: stat_id; Type: DEFAULT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY statistics ALTER COLUMN stat_id SET DEFAULT nextval('statistics_stat_id_seq'::regclass); | ||||
-- | ||||
-- Name: email_id; Type: DEFAULT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY user_email_map ALTER COLUMN email_id SET DEFAULT nextval('user_email_map_email_id_seq'::regclass); | ||||
-- | ||||
-- Name: user_following_id; Type: DEFAULT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY user_followings ALTER COLUMN user_following_id SET DEFAULT nextval('user_followings_user_following_id_seq'::regclass); | ||||
-- | ||||
-- Name: ip_id; Type: DEFAULT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY user_ip_map ALTER COLUMN ip_id SET DEFAULT nextval('user_ip_map_ip_id_seq'::regclass); | ||||
-- | ||||
-- Name: user_log_id; Type: DEFAULT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY user_logs ALTER COLUMN user_log_id SET DEFAULT nextval('user_logs_user_log_id_seq'::regclass); | ||||
-- | ||||
-- Name: group_to_perm_id; Type: DEFAULT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY user_repo_group_to_perm ALTER COLUMN group_to_perm_id SET DEFAULT nextval('user_repo_group_to_perm_group_to_perm_id_seq'::regclass); | ||||
-- | ||||
-- Name: user_to_perm_id; Type: DEFAULT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY user_to_perm ALTER COLUMN user_to_perm_id SET DEFAULT nextval('user_to_perm_user_to_perm_id_seq'::regclass); | ||||
-- | ||||
-- Name: user_id; Type: DEFAULT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY users ALTER COLUMN user_id SET DEFAULT nextval('users_user_id_seq'::regclass); | ||||
-- | ||||
-- Name: users_group_repo_group_to_perm_id; Type: DEFAULT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY users_group_repo_group_to_perm ALTER COLUMN users_group_repo_group_to_perm_id SET DEFAULT nextval('users_group_repo_group_to_per_users_group_repo_group_to_per_seq'::regclass); | ||||
-- | ||||
-- Name: users_group_to_perm_id; Type: DEFAULT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY users_group_repo_to_perm ALTER COLUMN users_group_to_perm_id SET DEFAULT nextval('users_group_repo_to_perm_users_group_to_perm_id_seq'::regclass); | ||||
-- | ||||
-- Name: users_group_to_perm_id; Type: DEFAULT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY users_group_to_perm ALTER COLUMN users_group_to_perm_id SET DEFAULT nextval('users_group_to_perm_users_group_to_perm_id_seq'::regclass); | ||||
-- | ||||
-- Name: users_group_id; Type: DEFAULT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY users_groups ALTER COLUMN users_group_id SET DEFAULT nextval('users_groups_users_group_id_seq'::regclass); | ||||
-- | ||||
-- Name: users_group_member_id; Type: DEFAULT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY users_groups_members ALTER COLUMN users_group_member_id SET DEFAULT nextval('users_groups_members_users_group_member_id_seq'::regclass); | ||||
-- | ||||
-- Data for Name: cache_invalidation; Type: TABLE DATA; Schema: public; Owner: postgres | ||||
-- | ||||
COPY cache_invalidation (cache_id, cache_key, cache_args, cache_active) FROM stdin; | ||||
1 1RC/mygr/lol RC/mygr/lol f | ||||
2 1RC/fakeclone RC/fakeclone t | ||||
3 1RC/muay RC/muay f | ||||
4 1BIG/git BIG/git t | ||||
5 1RC/origin-fork RC/origin-fork f | ||||
6 1one one f | ||||
7 1rhodecode.bak.1 rhodecode.bak.1 f | ||||
8 1csa-collins csa-collins t | ||||
9 1csa-harmony csa-harmony t | ||||
10 1RC/ąqweqwe RC/ąqweqwe f | ||||
11 1rhodecode rhodecode f | ||||
12 1csa-unity csa-unity t | ||||
13 1RC/łęcina RC/łęcina f | ||||
14 1waitress waitress t | ||||
15 1RC/rc2/test2 RC/rc2/test2 t | ||||
16 1RC/origin-fork-fork RC/origin-fork-fork f | ||||
17 1RC/rc2/test4 RC/rc2/test4 t | ||||
18 1RC/vcs-git RC/vcs-git t | ||||
19 1rhodecode-extensions rhodecode-extensions f | ||||
20 1rhodecode-cli-gist rhodecode-cli-gist f | ||||
21 1test.onaut.com test.onaut.com t | ||||
22 1RC/new RC/new f | ||||
23 1csa-aldrin csa-aldrin t | ||||
24 1vcs vcs f | ||||
25 1csa-prometheus csa-prometheus t | ||||
26 1RC/INRC/trololo RC/INRC/trololo f | ||||
27 1RC/empty-git RC/empty-git t | ||||
28 1csa-salt-states csa-salt-states t | ||||
29 1rhodecode-premium rhodecode-premium f | ||||
30 1RC/qweqwe-fork RC/qweqwe-fork f | ||||
31 1testrepo-quick testrepo-quick t | ||||
32 1RC/test RC/test f | ||||
33 1remote-salt remote-salt t | ||||
34 1BIG/android BIG/android t | ||||
35 1DOCS DOCS t | ||||
36 1rhodecode-git rhodecode-git t | ||||
37 1RC/bin-ops RC/bin-ops f | ||||
38 1RC/INRC/L2_NEW/lalalal RC/INRC/L2_NEW/lalalal f | ||||
39 1RC/fork-remote RC/fork-remote f | ||||
40 1RC/INRC/L2_NEW/L3/repo_test_move RC/INRC/L2_NEW/L3/repo_test_move f | ||||
41 1RC/gogo-fork RC/gogo-fork f | ||||
42 1quest quest f | ||||
43 1RC/foobar RC/foobar f | ||||
44 1csa-hyperion csa-hyperion t | ||||
45 1RC/git-pull-test RC/git-pull-test t | ||||
46 1RC/qweqwe-fork2 RC/qweqwe-fork2 f | ||||
47 1RC/jap RC/jap t | ||||
48 1RC/hg-repo RC/hg-repo f | ||||
49 1RC/origin RC/origin f | ||||
50 1rhodecode-cli-api rhodecode-cli-api f | ||||
51 1RC/rc2/test3 RC/rc2/test3 t | ||||
52 1csa-armstrong csa-armstrong t | ||||
53 1RC/trololo RC/trololo f | ||||
54 1testrepo-wp testrepo-wp t | ||||
55 1pyramidpypi pyramidpypi t | ||||
56 1salt salt t | ||||
57 1RC/lol/haha RC/lol/haha f | ||||
58 1csa-io csa-io t | ||||
59 1enc-envelope enc-envelope f | ||||
60 1RC/gogo2 RC/gogo2 f | ||||
61 1csa-libcloud csa-libcloud t | ||||
62 1RC/git-test RC/git-test t | ||||
63 1RC/rc2/test RC/rc2/test f | ||||
64 1rhodecode.bak rhodecode.bak f | ||||
65 1RC/kiall-nova RC/kiall-nova t | ||||
\. | ||||
-- | ||||
-- Name: cache_invalidation_cache_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | ||||
-- | ||||
SELECT pg_catalog.setval('cache_invalidation_cache_id_seq', 65, true); | ||||
-- | ||||
-- Data for Name: changeset_comments; Type: TABLE DATA; Schema: public; Owner: postgres | ||||
-- | ||||
COPY changeset_comments (comment_id, repo_id, revision, pull_request_id, line_no, hl_lines, f_path, user_id, text, created_on, modified_at) FROM stdin; | ||||
\. | ||||
-- | ||||
-- Name: changeset_comments_comment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | ||||
-- | ||||
SELECT pg_catalog.setval('changeset_comments_comment_id_seq', 1, false); | ||||
-- | ||||
-- Data for Name: changeset_statuses; Type: TABLE DATA; Schema: public; Owner: postgres | ||||
-- | ||||
COPY changeset_statuses (changeset_status_id, repo_id, user_id, revision, status, changeset_comment_id, modified_at, version, pull_request_id) FROM stdin; | ||||
\. | ||||
-- | ||||
-- Name: changeset_statuses_changeset_status_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | ||||
-- | ||||
SELECT pg_catalog.setval('changeset_statuses_changeset_status_id_seq', 1, false); | ||||
-- | ||||
-- Data for Name: db_migrate_version; Type: TABLE DATA; Schema: public; Owner: postgres | ||||
-- | ||||
COPY db_migrate_version (repository_id, repository_path, version) FROM stdin; | ||||
rhodecode_db_migrations versions 11 | ||||
\. | ||||
-- | ||||
-- Data for Name: groups; Type: TABLE DATA; Schema: public; Owner: postgres | ||||
-- | ||||
COPY groups (group_id, group_name, group_parent_id, group_description, enable_locking) FROM stdin; | ||||
1 RC \N RC group f | ||||
2 RC/mygr 1 RC/mygr group f | ||||
3 BIG \N BIG group f | ||||
4 RC/rc2 1 RC/rc2 group f | ||||
5 RC/INRC 1 RC/INRC group f | ||||
6 RC/INRC/L2_NEW 5 RC/INRC/L2_NEW group f | ||||
7 RC/INRC/L2_NEW/L3 6 RC/INRC/L2_NEW/L3 group f | ||||
8 RC/lol 1 RC/lol group f | ||||
\. | ||||
-- | ||||
-- Name: groups_group_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | ||||
-- | ||||
SELECT pg_catalog.setval('groups_group_id_seq', 8, true); | ||||
-- | ||||
-- Data for Name: notifications; Type: TABLE DATA; Schema: public; Owner: postgres | ||||
-- | ||||
COPY notifications (notification_id, subject, body, created_by, created_on, type) FROM stdin; | ||||
\. | ||||
-- | ||||
-- Name: notifications_notification_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | ||||
-- | ||||
SELECT pg_catalog.setval('notifications_notification_id_seq', 1, false); | ||||
-- | ||||
-- Data for Name: permissions; Type: TABLE DATA; Schema: public; Owner: postgres | ||||
-- | ||||
COPY permissions (permission_id, permission_name, permission_longname) FROM stdin; | ||||
1 repository.none repository.none | ||||
2 repository.read repository.read | ||||
3 repository.write repository.write | ||||
4 repository.admin repository.admin | ||||
5 group.none group.none | ||||
6 group.read group.read | ||||
7 group.write group.write | ||||
8 group.admin group.admin | ||||
9 hg.admin hg.admin | ||||
10 hg.create.none hg.create.none | ||||
11 hg.create.repository hg.create.repository | ||||
12 hg.fork.none hg.fork.none | ||||
13 hg.fork.repository hg.fork.repository | ||||
14 hg.register.none hg.register.none | ||||
15 hg.register.manual_activate hg.register.manual_activate | ||||
16 hg.register.auto_activate hg.register.auto_activate | ||||
\. | ||||
-- | ||||
-- Name: permissions_permission_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | ||||
-- | ||||
SELECT pg_catalog.setval('permissions_permission_id_seq', 16, true); | ||||
-- | ||||
-- Data for Name: pull_request_reviewers; Type: TABLE DATA; Schema: public; Owner: postgres | ||||
-- | ||||
COPY pull_request_reviewers (pull_requests_reviewers_id, pull_request_id, user_id) FROM stdin; | ||||
\. | ||||
-- | ||||
-- Name: pull_request_reviewers_pull_requests_reviewers_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | ||||
-- | ||||
SELECT pg_catalog.setval('pull_request_reviewers_pull_requests_reviewers_id_seq', 1, false); | ||||
-- | ||||
-- Data for Name: pull_requests; Type: TABLE DATA; Schema: public; Owner: postgres | ||||
-- | ||||
COPY pull_requests (pull_request_id, title, description, status, created_on, updated_on, user_id, revisions, org_repo_id, org_ref, other_repo_id, other_ref) FROM stdin; | ||||
\. | ||||
-- | ||||
-- Name: pull_requests_pull_request_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | ||||
-- | ||||
SELECT pg_catalog.setval('pull_requests_pull_request_id_seq', 1, false); | ||||
-- | ||||
-- Data for Name: repo_to_perm; Type: TABLE DATA; Schema: public; Owner: postgres | ||||
-- | ||||
COPY repo_to_perm (repo_to_perm_id, user_id, permission_id, repository_id) FROM stdin; | ||||
1 1 2 1 | ||||
2 1 2 2 | ||||
3 1 2 3 | ||||
4 1 2 4 | ||||
5 1 2 5 | ||||
6 1 2 6 | ||||
7 1 2 7 | ||||
8 1 2 8 | ||||
9 1 2 9 | ||||
10 1 2 10 | ||||
11 1 2 11 | ||||
12 1 2 12 | ||||
13 1 2 13 | ||||
14 1 2 14 | ||||
15 1 2 15 | ||||
16 1 2 16 | ||||
17 1 2 17 | ||||
18 1 2 18 | ||||
19 1 2 19 | ||||
20 1 2 20 | ||||
21 1 2 21 | ||||
22 1 2 22 | ||||
23 1 2 23 | ||||
24 1 2 24 | ||||
25 1 2 25 | ||||
26 1 2 26 | ||||
27 1 2 27 | ||||
28 1 2 28 | ||||
29 1 2 29 | ||||
30 1 2 30 | ||||
31 1 2 31 | ||||
32 1 2 32 | ||||
33 1 2 33 | ||||
34 1 2 34 | ||||
35 1 2 35 | ||||
36 1 2 36 | ||||
37 1 2 37 | ||||
38 1 2 38 | ||||
39 1 2 39 | ||||
40 1 2 40 | ||||
41 1 2 41 | ||||
42 1 2 42 | ||||
43 1 2 43 | ||||
44 1 2 44 | ||||
45 1 2 45 | ||||
46 1 2 46 | ||||
47 1 2 47 | ||||
48 1 2 48 | ||||
49 1 2 49 | ||||
50 1 2 50 | ||||
51 1 2 51 | ||||
52 1 2 52 | ||||
53 1 2 53 | ||||
54 1 2 54 | ||||
55 1 2 55 | ||||
56 1 2 56 | ||||
57 1 2 57 | ||||
58 1 2 58 | ||||
59 1 2 59 | ||||
60 1 2 60 | ||||
61 1 2 61 | ||||
62 1 2 62 | ||||
63 1 2 63 | ||||
64 1 2 64 | ||||
65 1 2 65 | ||||
\. | ||||
-- | ||||
-- Name: repo_to_perm_repo_to_perm_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | ||||
-- | ||||
SELECT pg_catalog.setval('repo_to_perm_repo_to_perm_id_seq', 65, true); | ||||
-- | ||||
-- Data for Name: repositories; Type: TABLE DATA; Schema: public; Owner: postgres | ||||
-- | ||||
COPY repositories (repo_id, repo_name, clone_uri, repo_type, user_id, private, statistics, downloads, description, created_on, updated_on, landing_revision, enable_locking, locked, changeset_cache, fork_id, group_id) FROM stdin; | ||||
1 RC/mygr/lol http://user@vm/RC/mygr/lol hg 2 f f f RC/mygr/lol repository 2013-05-28 20:26:59.886314 2013-05-28 20:26:59.886502 tip f \N \N \N 2 | ||||
2 RC/fakeclone \N git 2 f f f Unnamed repository; edit this file 'description' to name the repository.\n 2013-05-28 20:26:59.94415 2013-05-09 01:48:00 tip f \N \\x7b227261775f6964223a202264666137643337363737386436383164313831386634316231373730366566613630333362343037222c202273686f72745f6964223a2022646661376433373637373864222c2022617574686f72223a20224d617263696e204b757a6d696e736b69203c6d617263696e40707974686f6e2d776f726b732e636f6d3e222c202264617465223a2022323031332d30352d30395430313a34383a3030222c20226d657373616765223a202266697865645c6e222c20227265766973696f6e223a203239337d \N 1 | ||||
3 RC/muay \N hg 2 f f f RC/muay repository 2013-05-28 20:27:00.114841 2013-05-28 20:27:00.114864 tip f \N \N \N 1 | ||||
4 BIG/git \N git 2 f f f Unnamed repository; edit this file 'description' to name the repository.\n 2013-05-28 20:27:00.171891 2012-10-21 23:47:54 tip f \N \\x7b227261775f6964223a202233306634633636653633343736306138316162323761323336666531663234383266366637383536222c202273686f72745f6964223a2022333066346336366536333437222c2022617574686f72223a20224a756e696f20432048616d616e6f203c6769747374657240706f626f782e636f6d3e222c202264617465223a2022323031322d31302d32315432333a34373a3534222c20226d657373616765223a202257686174277320636f6f6b696e672028323031322f313020233037295c6e222c20227265766973696f6e223a2033323136307d \N 3 | ||||
5 RC/origin-fork \N hg 2 f f f RC/origin-fork repository 2013-05-28 20:27:01.457264 2013-03-06 20:16:20 tip f \N \\x7b227261775f6964223a202266306365333961366639656466633633393264346436313337663035626233383731653431373830222c202273686f72745f6964223a2022663063653339613666396564222c2022617574686f72223a202252686f6465436f64652041646d696e203c6d617263696e40707974686f6e2d626c6f672e636f6d3e222c202264617465223a2022323031332d30332d30365432303a31363a3230222c20226d657373616765223a20224564697465642066696c6520766961206f7074696f6e735c6e2d20666978656420315c6e2d66207869656420325c6e616e6420736f206f6e20736f206f6e207472616c6c616c616c61222c20227265766973696f6e223a2032317d \N 1 | ||||
6 one \N hg 2 f f f one repository 2013-05-28 20:27:01.525404 2013-05-23 12:11:57 tip f \N \\x7b227261775f6964223a202233393435643961623264396533323262623666643561613763333461316530313132326265343662222c202273686f72745f6964223a2022333934356439616232643965222c2022617574686f72223a202252686f6465436f64652041646d696e203c6d617263696e40707974686f6e2d626c6f672e636f6d3e222c202264617465223a2022323031332d30352d32335431323a31313a3537222c20226d657373616765223a202241646465642066696c65207669612052686f6465436f6465222c20227265766973696f6e223a20307d \N \N | ||||
7 rhodecode.bak.1 \N hg 2 f f f rhodecode.bak.1 repository 2013-05-28 20:27:01.578685 2013-05-28 14:44:56 tip f \N \\x7b227261775f6964223a202232336637333938396439323230343636666239646237633635316431336162663637393666373663222c202273686f72745f6964223a2022323366373339383964393232222c2022617574686f72223a20224d617263696e204b757a6d696e736b69203c6d617263696e40707974686f6e2d776f726b732e636f6d3e222c202264617465223a2022323031332d30352d32385431343a34343a3536222c20226d657373616765223a20226d657267652064657620696e746f2072686f6465636f64652d70616d222c20227265766973696f6e223a20343034307d \N \N | ||||
8 csa-collins \N git 2 f f f Unnamed repository; edit this file 'description' to name the repository.\n 2013-05-28 20:27:01.645073 2013-02-25 17:31:39 tip f \N \\x7b227261775f6964223a202238626536613130643634356338646461356631663333313439363232383131386165383732636538222c202273686f72745f6964223a2022386265366131306436343563222c2022617574686f72223a20224261737469616e20416c62657273203c696e666f406261737469616e616c626572732e64653e222c202264617465223a2022323031332d30322d32355431373a33313a3339222c20226d657373616765223a20224d65726765206272616e6368202773746167652720696e746f207374616765325c6e222c20227265766973696f6e223a20323733317d \N \N | ||||
9 csa-harmony \N git 2 f f f Unnamed repository; edit this file 'description' to name the repository.\n 2013-05-28 20:27:01.870853 2013-05-22 14:49:45 tip f \N \\x7b227261775f6964223a202232376235393630333631386230373235396361306462366230303939306665656261393639333066222c202273686f72745f6964223a2022323762353936303336313862222c2022617574686f72223a20224d617263696e204b757a6d696e736b69203c6d617263696e40707974686f6e2d776f726b732e636f6d3e222c202264617465223a2022323031332d30352d32325431343a34393a3435222c20226d657373616765223a20224164646564206b776172677320746f2073657475702066756e6374696f6e7320666f72206c61746572206f7074696f6e616c20706172616d735c6e222c20227265766973696f6e223a203333397d \N \N | ||||
10 RC/ąqweqwe \N hg 2 f f f RC/ąqweqwe repository 2013-05-28 20:27:02.376512 2013-05-28 20:27:02.376535 tip f \N \N \N 1 | ||||
11 rhodecode \N hg 2 f f f rhodecode repository 2013-05-28 20:27:02.424079 2013-05-28 20:16:08 tip f \N \\x7b227261775f6964223a202237613161333935356434343661343664353235663034326265373339343161303231323266633332222c202273686f72745f6964223a2022376131613339353564343436222c2022617574686f72223a20224d617263696e204b757a6d696e736b69203c6d617263696e40707974686f6e2d776f726b732e636f6d3e222c202264617465223a2022323031332d30352d32385432303a31363a3038222c20226d657373616765223a20226d6967726174696f6e20746f20312e372e30222c20227265766973696f6e223a20343034357d \N \N | ||||
12 csa-unity \N git 2 f f f Unnamed repository; edit this file 'description' to name the repository.\n 2013-05-28 20:27:02.495342 2013-04-29 14:38:23 tip f \N \\x7b227261775f6964223a202230393337303837353965626634666432626231626463616436316662363131626333323933336433222c202273686f72745f6964223a2022303933373038373539656266222c2022617574686f72223a20224d617263696e204b757a6d696e736b69203c6d617263696e40707974686f6e2d776f726b732e636f6d3e222c202264617465223a2022323031332d30342d32395431343a33383a3233222c20226d657373616765223a202272657665727420746f206c6f67626f6f6b20302e332e30222c20227265766973696f6e223a2032387d \N \N | ||||
13 RC/łęcina \N hg 2 f f f RC/łęcina repository 2013-05-28 20:27:02.664128 2013-03-06 16:17:49 tip f \N \\x7b227261775f6964223a202231656535383962636661393231326335313130656135633166653263633866663665616631333033222c202273686f72745f6964223a2022316565353839626366613932222c2022617574686f72223a202252686f6465436f64652041646d696e203c6d617263696e40707974686f6e2d626c6f672e636f6d3e222c202264617465223a2022323031332d30332d30365431363a31373a3439222c20226d657373616765223a202241646465642066696c65207669612052686f6465436f6465222c20227265766973696f6e223a20307d \N 1 | ||||
14 waitress \N git 2 f f f Unnamed repository; edit this file 'description' to name the repository.\n 2013-05-28 20:27:02.721063 2013-05-28 13:21:35 tip f \N \\x7b227261775f6964223a202265356431333863653366373534653630333165376162643736653566353237333633666461663432222c202273686f72745f6964223a2022653564313338636533663735222c2022617574686f72223a20224d617263696e204b757a6d696e736b69203c6d617263696e40707974686f6e2d776f726b732e636f6d3e222c202264617465223a2022323031332d30352d32385431333a32313a3335222c20226d657373616765223a2022416464656420646f637320616e64206e657720666c616720696e746f2072756e6e65725c6e222c20227265766973696f6e223a203237327d \N \N | ||||
15 RC/rc2/test2 \N git 2 f f f Unnamed repository; edit this file 'description' to name the repository.\n 2013-05-28 20:27:02.896717 2013-03-03 00:29:35 tip f \N \\x7b227261775f6964223a202230656233333034666333336430356433323866383632376239616434346461653833663331336132222c202273686f72745f6964223a2022306562333330346663333364222c2022617574686f72223a20224d617263696e204b757a6d696e736b69203c6d617263696e40707974686f6e2d776f726b732e636f6d3e222c202264617465223a2022323031332d30332d30335430303a32393a3335222c20226d657373616765223a20224d65726765206272616e636820277374616765275c6e5c6e2a2073746167653a5c6e202066697820726571756573747320312e31206a736f6e206d6574686f645c6e202066697865642074657374735c6e20206d6f76656420746573747320696e746f207061636b6167655c6e20202d62756d7020646973747269627574655c6e2020757064617465202e67697469676e6f72655c6e202076657273696f6e20667265657a65206f66206c6962735c6e202072656d6f766520676576656e742066726f6d20494f20617320646570656e64656e63795c6e202061646420756e69747920617320646570735c6e202066756c6c792064656c65676174652041555448206261636b20746f2061726d7374726f6e675c6e222c20227265766973696f6e223a2035307d \N 4 | ||||
16 RC/origin-fork-fork \N hg 2 f f f RC/origin-fork-fork repository 2013-05-28 20:27:03.013741 2013-05-06 23:44:50 tip f \N \\x7b227261775f6964223a202236643939653064346466636334613561666135633133386665613230393834373036333466373733222c202273686f72745f6964223a2022366439396530643464666363222c2022617574686f72223a202252686f6465436f64652041646d696e203c6d617263696e40707974686f6e2d626c6f672e636f6d3e222c202264617465223a2022323031332d30352d30365432333a34343a3530222c20226d657373616765223a20224973737565202331373039343a20436c656172207374616c65207468726561642073746174657320616674657220666f726b28292e5c6e5c6e4e6f746520746861742074686973206973206120706f74656e7469616c6c792064697372757074697665206368616e67652073696e6365206974206d61795c6e72656c6561736520736f6d652073797374656d207265736f757263657320776869636820776f756c64206f74686572776973652072656d61696e5c6e70657270657475616c6c7920616c6976652028652e672e20646174616261736520636f6e6e656374696f6e73206b65707420696e207468726561642d6c6f63616c5c6e73746f72616765292e222c20227265766973696f6e223a2032357d \N 1 | ||||
17 RC/rc2/test4 \N git 2 f f f Unnamed repository; edit this file 'description' to name the repository.\n 2013-05-28 20:27:03.077195 2013-03-21 22:55:29 tip f \N \\x7b227261775f6964223a202233623661633766356539333264346464313338373161306232336436636139383531306438386332222c202273686f72745f6964223a2022336236616337663565393332222c2022617574686f72223a202252686f6465436f64652041646d696e203c6d617263696e40707974686f6e2d626c6f672e636f6d3e222c202264617465223a2022323031332d30332d32315432323a35353a3239222c20226d657373616765223a2022647361646173222c20227265766973696f6e223a2035317d \N 4 | ||||
18 RC/vcs-git \N git 2 f f f Unnamed repository; edit this file 'description' to name the repository.\n 2013-05-28 20:27:03.207037 2013-04-26 23:34:15 tip f \N \\x7b227261775f6964223a202239306461316636396136633630663764346435363436656533396163356636313038626330373763222c202273686f72745f6964223a2022393064613166363961366336222c2022617574686f72223a20224d617263696e204b757a6d696e736b69203c6d617263696e40707974686f6e2d776f726b732e636f6d3e222c202264617465223a2022323031332d30342d32365432333a33343a3135222c20226d657373616765223a20226d65726765207769746820474954207663735c6e222c20227265766973696f6e223a203634387d \N 1 | ||||
19 rhodecode-extensions \N hg 2 f f f rhodecode-extensions repository 2013-05-28 20:27:03.363473 2013-02-13 16:50:33 tip f \N \\x7b227261775f6964223a202264613765356637613339643332303366663062346166353031386163346138306439346564316434222c202273686f72745f6964223a2022646137653566376133396433222c2022617574686f72223a20224d617263696e204b757a6d696e736b69203c6d617263696e40707974686f6e2d776f726b732e636f6d3e222c202264617465223a2022323031332d30322d31335431363a35303a3333222c20226d657373616765223a20224c696e6b6966792068697063686174206d65737361676573222c20227265766973696f6e223a20327d \N \N | ||||
20 rhodecode-cli-gist \N hg 2 f f f rhodecode-cli-gist repository 2013-05-28 20:27:03.415835 2013-05-28 20:27:03.415858 tip f \N \N \N \N | ||||
21 test.onaut.com \N git 2 f f f Unnamed repository 2013-05-28 20:27:03.46164 2013-04-29 11:08:31 tip f \N \\x7b227261775f6964223a202236666465656664323034633461656637636263623966656563646564313436373364383563663230222c202273686f72745f6964223a2022366664656566643230346334222c2022617574686f72223a2022596f7572204e616d65203c796f75406578616d706c652e636f6d3e222c202264617465223a2022323031332d30342d32395431313a30383a3331222c20226d657373616765223a2022666f6f6261725c6e222c20227265766973696f6e223a20307d \N \N | ||||
22 RC/new \N hg 2 f f f RC/new repository 2013-05-28 20:27:03.580255 2013-04-17 13:02:59 tip f \N \\x7b227261775f6964223a202239333139326530336133353532623864613466656534306530303163363033303437323362623432222c202273686f72745f6964223a2022393331393265303361333535222c2022617574686f72223a20224d617263696e204b757a6d696e736b69203c6d617263696e40707974686f6e2d776f726b732e636f6d3e222c202264617465223a2022323031332d30342d31375431333a30323a3539222c20226d657373616765223a202272656e616d65222c20227265766973696f6e223a20317d \N 1 | ||||
46 RC/qweqwe-fork2 \N hg 2 f f f RC/qweqwe-fork2 repository 2013-05-28 20:27:17.359662 2013-05-28 20:27:17.359684 tip f \N \N \N 1 | ||||
23 csa-aldrin \N git 2 f f f Unnamed repository; edit this file 'description' to name the repository.\n 2013-05-28 20:27:03.639793 2013-05-02 23:47:52 tip f \N \\x7b227261775f6964223a202236376565396538333063323235393231656331353937346163316466646531376139333065326662222c202273686f72745f6964223a2022363765653965383330633232222c2022617574686f72223a20224d617263696e204b757a6d696e736b69203c6d617263696e40707974686f6e2d776f726b732e636f6d3e222c202264617465223a2022323031332d30352d30325432333a34373a3532222c20226d657373616765223a20224d65726765206272616e636820277374616765275c6e5c6e2a2073746167653a5c6e20206d6f76656420676576656e7420696e746f206f757420696e7465726e616c207365727665725c6e202073747570696420617373686f6c657320696e20676576656e742073686f756c64206c6561726e20686f7720746f207061636b6167652e2e2e5c6e2020666978656420676576656e7420646570656e64656e6379206c696e6b5c6e202061646465642073657061726174652063616c6c20666f722073657373696f6e2076616c69646174696f6e5c6e222c20227265766973696f6e223a203239337d \N \N | ||||
24 vcs \N hg 2 f f f vcs repository 2013-05-28 20:27:03.856575 2013-05-09 00:28:54 tip f \N \\x7b227261775f6964223a202236666261353966396637383036613534356130653565626163393336393931383238343336323630222c202273686f72745f6964223a2022366662613539663966373830222c2022617574686f72223a20224c756b61737a2042616c6365727a616b203c6c756b61737a62616c6365727a616b40676d61696c2e636f6d3e222c202264617465223a2022323031332d30352d30395430303a32383a3534222c20226d657373616765223a20224d657267652070756c6c207265717565737420233131372066726f6d206e69656462616c736b692f6d61737465725c6e5c6e4b65794572726f723a2027616c6c27222c20227265766973696f6e223a203730377d \N \N | ||||
25 csa-prometheus \N git 2 f f f Unnamed repository; edit this file 'description' to name the repository.\n 2013-05-28 20:27:03.916977 2013-04-29 14:37:43 tip f \N \\x7b227261775f6964223a202261373139626438326432356537343131666462373937396331326330383366353961323036613663222c202273686f72745f6964223a2022613731396264383264323565222c2022617574686f72223a20224d617263696e204b757a6d696e736b69203c6d617263696e40707974686f6e2d776f726b732e636f6d3e222c202264617465223a2022323031332d30342d32395431343a33373a3433222c20226d657373616765223a2022726576657274206c6f67626f6f6b20746f20302e332e30222c20227265766973696f6e223a2037397d \N \N | ||||
26 RC/INRC/trololo \N hg 2 f f f RC/INRC/trololo repository 2013-05-28 20:27:04.096413 2013-05-28 20:27:04.096437 tip f \N \N \N 5 | ||||
27 RC/empty-git \N git 2 f f f Unnamed repository; edit this file 'description' to name the repository.\n 2013-05-28 20:27:04.148472 2013-05-28 20:27:04.148509 tip f \N \N \N 1 | ||||
28 csa-salt-states \N git 2 f f f Unnamed repository; edit this file 'description' to name the repository.\n 2013-05-28 20:27:04.212846 2013-05-06 14:48:48 tip f \N \\x7b227261775f6964223a202230633230646337326261656564633363653834306336313131373463376531636433623034393139222c202273686f72745f6964223a2022306332306463373262616565222c2022617574686f72223a20224d617263696e204b757a6d696e736b69203c6d617263696e40707974686f6e2d776f726b732e636f6d3e222c202264617465223a2022323031332d30352d30365431343a34383a3438222c20226d657373616765223a2022696e6372656173652073616d706c696e67206f66204350552074696d6520746f20302e357320666f72206d6f7265207265616c697374696320646174612e222c20227265766973696f6e223a2037317d \N \N | ||||
29 rhodecode-premium \N hg 2 f f f rhodecode-premium repository 2013-05-28 20:27:04.419538 2013-03-21 22:58:11 tip f \N \\x7b227261775f6964223a202264656433356266303137663136626361643636313163376666653362316231633130393432663530222c202273686f72745f6964223a2022646564333562663031376631222c2022617574686f72223a20224d617263696e204b757a6d696e736b69203c6d617263696e40707974686f6e2d776f726b732e636f6d3e222c202264617465223a2022323031332d30332d32315432323a35383a3131222c20226d657373616765223a202276657273696f6e2062756d7020746f20312e352e347032222c20227265766973696f6e223a20333637347d \N \N | ||||
30 RC/qweqwe-fork \N hg 2 f f f RC/qweqwe-fork repository 2013-05-28 20:27:04.494164 2013-05-28 20:27:04.494188 tip f \N \N \N 1 | ||||
31 testrepo-quick \N git 2 f f f Unnamed repository; edit this file 'description' to name the repository.\n 2013-05-28 20:27:04.547757 2012-08-31 11:34:33 tip f \N \\x7b227261775f6964223a202236303763396632336633373731626633353731346639626166353539666433313138366432353930222c202273686f72745f6964223a2022363037633966323366333737222c2022617574686f72223a202253656261737469616e204b726575747a626572676572203c73656261737469616e406170707a6f6e6175742e636f6d3e222c202264617465223a2022323031322d30382d33315431313a33343a3333222c20226d657373616765223a20226164646564207465737420666f72202e617a2d7368617265642066696c655c6e222c20227265766973696f6e223a2031327d \N \N | ||||
32 RC/test \N hg 2 f f f RC/test repository 2013-05-28 20:27:04.697514 2013-01-30 22:56:03 tip f \N \\x7b227261775f6964223a202265353032356533313664396163623339653566383631633439343234306265346635643536646536222c202273686f72745f6964223a2022653530323565333136643961222c2022617574686f72223a202252686f6465436f64652041646d696e203c6d617263696e406d61712e696f3e222c202264617465223a2022323031332d30312d33305432323a35363a3033222c20226d657373616765223a20223c7363726970743e616c65727428277873733227293b3c2f7363726970743e202066697865732023373030222c20227265766973696f6e223a20327d \N 1 | ||||
33 remote-salt \N git 2 f f f Unnamed repository; edit this file 'description' to name the repository.\n 2013-05-28 20:27:04.750525 2012-10-14 22:04:05 tip f \N \\x7b227261775f6964223a202264363631646337323439326536366361623761363437646362353635323030393036376161386364222c202273686f72745f6964223a2022643636316463373234393265222c2022617574686f72223a20224d617263696e204b757a6d696e736b69203c6d617263696e40707974686f6e2d776f726b732e636f6d3e222c202264617465223a2022323031322d31302d31345432323a30343a3035222c20226d657373616765223a20224c6f6767696e675c6e4f6e2d7468652d666c79206d736720656e6372797074696f6e207573696e6720676f6f676c6573206b6579437a6172206c6962222c20227265766973696f6e223a20337d \N \N | ||||
34 BIG/android \N git 2 f f f Unnamed repository; edit this file 'description' to name the repository.\n 2013-05-28 20:27:04.869224 2012-06-17 00:44:46 tip f \N \\x7b227261775f6964223a202265383662313437653462363930386137633561623039363364373766623038363736373962316565222c202273686f72745f6964223a2022653836623134376534623639222c2022617574686f72223a20224265726e6861726420526f73656e6b7261656e7a6572203c4265726e686172642e526f73656e6b72616e7a6572406c696e61726f2e6f72673e222c202264617465223a2022323031322d30362d31375430303a34343a3436222c20226d657373616765223a202270616e64613a204261636b706f72742048444d492076732e204456492070617463682066726f6d206b65726e656c2f70616e64612e6769745c6e5c6e5468697320706174636820616c6c6f777320737769746368696e6720746865207072696d61727920646973706c6179206f7574707574206465766963652e5c6e5c6e4368616e67652d49643a2049366533306538376262633761613732623561636336653663346564333430313938333565363532345c6e5369676e65642d6f66662d62793a204265726e6861726420526f73656e6b7261656e7a6572203c4265726e686172642e526f73656e6b72616e7a6572406c696e61726f2e6f72673e5c6e222c20227265766973696f6e223a203239343839367d \N 3 | ||||
35 DOCS \N git 2 f f f Unnamed repository; edit this file 'description' to name the repository.\n 2013-05-28 20:27:16.065483 2013-04-25 16:45:59 tip f \N \\x7b227261775f6964223a202231653461373238656537613661613838626531313236306436343739613434366562383635646533222c202273686f72745f6964223a2022316534613732386565376136222c2022617574686f72223a20224d617263696e204b757a6d696e736b69203c6d617263696e40707974686f6e2d776f726b732e636f6d3e222c202264617465223a2022323031332d30342d32355431363a34353a3539222c20226d657373616765223a202273796e6320646f637320776974682061726d7374726f6e67222c20227265766973696f6e223a2031357d \N \N | ||||
36 rhodecode-git \N git 2 f f f Unnamed repository; edit this file 'description' to name the repository.\n 2013-05-28 20:27:16.225335 2013-01-04 00:24:22 tip f \N \\x7b227261775f6964223a202236323966313533386164343830306666303531313335313666366139333365326232343366323035222c202273686f72745f6964223a2022363239663135333861643438222c2022617574686f72223a20224d617263696e204b757a6d696e736b69203c6d617263696e40707974686f6e2d776f726b732e636f6d3e222c202264617465223a2022323031332d30312d30345430303a32343a3232222c20226d657373616765223a20226e6963657220726570726573656e746174696f6e206f66206c697374206f662072657363616e6e6564207265706f7369746f726965735c6e5c6e2d2d48472d2d5c6e6272616e6368203a20626574615c6e222c20227265766973696f6e223a20333134327d \N \N | ||||
37 RC/bin-ops \N hg 2 f f f RC/bin-ops repository 2013-05-28 20:27:16.463774 2013-05-12 12:39:34 tip f \N \\x7b227261775f6964223a202234323331373632643863316161636135626533646231353939313037313233366333326537363534222c202273686f72745f6964223a2022343233313736326438633161222c2022617574686f72223a202252686f6465436f64652041646d696e203c6d617263696e40707974686f6e2d626c6f672e636f6d3e222c202264617465223a2022323031332d30352d31325431323a33393a3334222c20226d657373616765223a20224564697465642066696c652066696c6531207669612052686f6465436f6465222c20227265766973696f6e223a2032337d \N 1 | ||||
38 RC/INRC/L2_NEW/lalalal \N hg 2 f f f RC/INRC/L2_NEW/lalalal repository 2013-05-28 20:27:16.555625 2013-05-28 20:27:16.55565 tip f \N \N \N 6 | ||||
39 RC/fork-remote \N hg 2 f f f RC/fork-remote repository 2013-05-28 20:27:16.622524 2013-03-10 22:47:24 tip f \N \\x7b227261775f6964223a202236303535353438346130613064366535323565396437616231623164636535616239656239343837222c202273686f72745f6964223a2022363035353534383461306130222c2022617574686f72223a20224d617263696e204b757a6d696e736b69203c6d617263696e40707974686f6e2d776f726b732e636f6d3e222c202264617465223a2022323031332d30332d31305432323a34373a3234222c20226d657373616765223a2022616161222c20227265766973696f6e223a2032367d \N 1 | ||||
40 RC/INRC/L2_NEW/L3/repo_test_move \N hg 2 f f f RC/INRC/L2_NEW/L3/repo_test_move repository 2013-05-28 20:27:16.717095 2013-05-28 20:27:16.717133 tip f \N \N \N 7 | ||||
41 RC/gogo-fork \N hg 2 f f f RC/gogo-fork repository 2013-05-28 20:27:16.790103 2013-05-28 20:27:16.790129 tip f \N \N \N 1 | ||||
42 quest \N hg 2 f f f quest repository 2013-05-28 20:27:16.858741 2013-03-04 23:01:40 tip f \N \\x7b227261775f6964223a202235346230316366646561323562663431636438653961313834633538353263356434386438363463222c202273686f72745f6964223a2022353462303163666465613235222c2022617574686f72223a20224d617263696e204b757a6d696e736b69203c6d617263696e40707974686f6e2d776f726b732e636f6d3e222c202264617465223a2022323031332d30332d30345432333a30313a3430222c20226d657373616765223a202274656d706c61746520616e642076657273696f6e20302e302e31222c20227265766973696f6e223a2034317d \N \N | ||||
43 RC/foobar \N hg 2 f f f RC/foobar repository 2013-05-28 20:27:16.930525 2013-04-15 21:34:57 tip f \N \\x7b227261775f6964223a202263313764633363353636393532383133653834303337646664363261343735356564336339313263222c202273686f72745f6964223a2022633137646333633536363935222c2022617574686f72223a20224d6972656b204b6f7474203c6d617263696e40707974686f6e2d626c6f672e636f6d3e222c202264617465223a2022323031332d30342d31355432313a33343a3537222c20226d657373616765223a20224564697465642066696c65206c6f6c2e727374207669612052686f6465436f6465222c20227265766973696f6e223a20317d \N 1 | ||||
44 csa-hyperion \N git 2 f f f Unnamed repository; edit this file 'description' to name the repository.\n 2013-05-28 20:27:17.021283 2013-05-20 21:58:28 tip f \N \\x7b227261775f6964223a202232353263393236643130373032653665663763323435366632666332333839323830386535336130222c202273686f72745f6964223a2022323532633932366431303730222c2022617574686f72223a20224d617263696e204b757a6d696e736b69203c6d617263696e40707974686f6e2d776f726b732e636f6d3e222c202264617465223a2022323031332d30352d32305432313a35383a3238222c20226d657373616765223a2022666978657320666f72206e657720636f64655c6e222c20227265766973696f6e223a2035377d \N \N | ||||
45 RC/git-pull-test \N git 2 f f f Unnamed repository; edit this file 'description' to name the repository.\n 2013-05-28 20:27:17.231975 2013-05-20 13:03:02 tip f \N \\x7b227261775f6964223a202262326366313133366630396661363164663930343639623433333130363135393834626337643535222c202273686f72745f6964223a2022623263663131333666303966222c2022617574686f72223a20224d617263696e204b757a6d696e736b69203c6d617263696e40707974686f6e2d776f726b732e636f6d3e222c202264617465223a2022323031332d30352d32305431333a30333a3032222c20226d657373616765223a202261646465645c6e222c20227265766973696f6e223a2031337d \N 1 | ||||
47 RC/jap \N git 2 f f f Unnamed repository; edit this file 'description' to name the repository.\n 2013-05-28 20:27:17.427862 2013-04-24 11:15:30 tip f \N \\x7b227261775f6964223a202232663632636532323435336136376565666436666162316434653035333532306538646562646636222c202273686f72745f6964223a2022326636326365323234353361222c2022617574686f72223a202244656d6f2055736572203c64656d6f4072686f6465636f64652e6f72673e222c202264617465223a2022323031332d30342d32345431313a31353a3330222c20226d657373616765223a20225c75333064355c75333061315c75333061345c75333065625c75386666645c7535326130222c20227265766973696f6e223a20357d \N 1 | ||||
48 RC/hg-repo \N hg 2 f f f RC/hg-repo repository 2013-05-28 20:27:17.558936 2013-05-08 22:54:45 tip f \N \\x7b227261775f6964223a202264363364343065386230363835616636646235663263663737303065383032313661663563373339222c202273686f72745f6964223a2022643633643430653862303638222c2022617574686f72223a202252686f6465436f64652041646d696e203c6d617263696e40707974686f6e2d626c6f672e636f6d3e222c202264617465223a2022323031332d30352d30385432323a35343a3435222c20226d657373616765223a20224564697465642066696c652068616861207669612052686f6465436f6465222c20227265766973696f6e223a2032357d \N 1 | ||||
49 RC/origin \N hg 2 f f f RC/origin repository 2013-05-28 20:27:17.634344 2013-04-05 13:05:02 tip f \N \\x7b227261775f6964223a202235666266326630656164613433626333336139346534383335303333333564386636373537303933222c202273686f72745f6964223a2022356662663266306561646134222c2022617574686f72223a20224d617263696e204b757a6d696e736b69203c6d617263696e40707974686f6e2d776f726b732e636f6d3e222c202264617465223a2022323031332d30342d30355431333a30353a3032222c20226d657373616765223a20226669786564222c20227265766973696f6e223a2032397d \N 1 | ||||
50 rhodecode-cli-api \N hg 2 f f f rhodecode-cli-api repository 2013-05-28 20:27:17.708944 2013-05-28 20:27:17.708995 tip f \N \N \N \N | ||||
51 RC/rc2/test3 \N git 2 f f f Unnamed repository; edit this file 'description' to name the repository.\n 2013-05-28 20:27:17.781161 2013-03-03 00:29:35 tip f \N \\x7b227261775f6964223a202230656233333034666333336430356433323866383632376239616434346461653833663331336132222c202273686f72745f6964223a2022306562333330346663333364222c2022617574686f72223a20224d617263696e204b757a6d696e736b69203c6d617263696e40707974686f6e2d776f726b732e636f6d3e222c202264617465223a2022323031332d30332d30335430303a32393a3335222c20226d657373616765223a20224d65726765206272616e636820277374616765275c6e5c6e2a2073746167653a5c6e202066697820726571756573747320312e31206a736f6e206d6574686f645c6e202066697865642074657374735c6e20206d6f76656420746573747320696e746f207061636b6167655c6e20202d62756d7020646973747269627574655c6e2020757064617465202e67697469676e6f72655c6e202076657273696f6e20667265657a65206f66206c6962735c6e202072656d6f766520676576656e742066726f6d20494f20617320646570656e64656e63795c6e202061646420756e69747920617320646570735c6e202066756c6c792064656c65676174652041555448206261636b20746f2061726d7374726f6e675c6e222c20227265766973696f6e223a2035307d \N 4 | ||||
52 csa-armstrong \N git 2 f f f Unnamed repository; edit this file 'description' to name the repository.\n 2013-05-28 20:27:17.898234 2013-05-22 18:10:20 tip f \N \\x7b227261775f6964223a202236306666613230313866613132306339376330633566636162393365636438326532633361363931222c202273686f72745f6964223a2022363066666132303138666131222c2022617574686f72223a20224d617263696e204b757a6d696e736b69203c6d617263696e40707974686f6e2d776f726b732e636f6d3e222c202264617465223a2022323031332d30352d32325431383a31303a3230222c20226d657373616765223a20226669782061637475616c2070726f677265737320696e63726561736520696e2073616c742063616c6c735c6e222c20227265766973696f6e223a20313134307d \N \N | ||||
53 RC/trololo \N hg 2 f f f RC/trololo repository 2013-05-28 20:27:18.620592 2013-03-28 02:35:50 tip f \N \\x7b227261775f6964223a202238393064373436396162616333363036333763386366373966313538623137303431356531363533222c202273686f72745f6964223a2022383930643734363961626163222c2022617574686f72223a202264656d6f2075736572203c6d617263696e406d61712e696f3e222c202264617465223a2022323031332d30332d32385430323a33353a3530222c20226d657373616765223a202241646465642066696c65207669612052686f6465436f6465222c20227265766973696f6e223a20307d \N 1 | ||||
54 testrepo-wp \N git 2 f f f Unnamed repository; edit this file 'description' to name the repository.\n 2013-05-28 20:27:18.695645 2012-08-27 11:05:37 tip f \N \\x7b227261775f6964223a202264393461663531633130313032303433306132386463616561313135336464643932326332396563222c202273686f72745f6964223a2022643934616635316331303130222c2022617574686f72223a202253656261737469616e204b726575747a626572676572203c73656261737469616e406170707a6f6e6175742e636f6d3e222c202264617465223a2022323031322d30382d32375431313a30353a3337222c20226d657373616765223a2022757064617465642063726564735c6e222c20227265766973696f6e223a20377d \N \N | ||||
55 pyramidpypi \N git 2 f f f Unnamed repository; edit this file 'description' to name the repository.\n 2013-05-28 20:27:18.824235 2013-04-25 16:34:48 tip f \N \\x7b227261775f6964223a202265643961636566666164613365663338353039633564373031306230313662613435653832393434222c202273686f72745f6964223a2022656439616365666661646133222c2022617574686f72223a20224d617263696e204b757a6d696e736b69203c6d617263696e40707974686f6e2d776f726b732e636f6d3e222c202264617465223a2022323031332d30342d32355431363a33343a3438222c20226d657373616765223a202276657273696f6e2062756d70222c20227265766973696f6e223a2032387d \N \N | ||||
56 salt \N git 2 f f f Unnamed repository; edit this file 'description' to name the repository.\n 2013-05-28 20:27:19.036099 2012-10-15 05:20:58 tip f \N \\x7b227261775f6964223a202262643434383332323330666331396562383066653439656630316261646234373765663863613663222c202273686f72745f6964223a2022626434343833323233306663222c2022617574686f72223a202254686f6d61732053204861746368203c746861746368343540676d61696c2e636f6d3e222c202264617465223a2022323031322d31302d31355430353a32303a3538222c20226d657373616765223a20224d657267652070756c6c20726571756573742023323234342066726f6d2046697265486f73742f746f706c6576656c5f776d695f696d706f72745c6e5c6e546f706c6576656c20776d6920696d706f7274222c20227265766973696f6e223a20363935377d \N \N | ||||
57 RC/lol/haha \N hg 2 f f f RC/lol/haha repository 2013-05-28 20:27:19.44935 2013-05-28 20:27:19.449372 tip f \N \N \N 8 | ||||
58 csa-io \N git 2 f f f Unnamed repository; edit this file 'description' to name the repository.\n 2013-05-28 20:27:19.531664 2013-05-02 22:52:54 tip f \N \\x7b227261775f6964223a202262643065663731666366643038386138326238363237653630616161316632303230656433336261222c202273686f72745f6964223a2022626430656637316663666430222c2022617574686f72223a20224d617263696e204b757a6d696e736b69203c6d617263696e40707974686f6e2d776f726b732e636f6d3e222c202264617465223a2022323031332d30352d30325432323a35323a3534222c20226d657373616765223a20224d65726765206272616e636820277374616765275c6e5c6e2a2073746167653a5c6e2020557365206578745f6a736f6e20696e7374656164206f6620706c61696e2073696d706c656a736f6e2073657269616c697a65725c6e20206c6f67206572726f7273206f6e207265737466756c6c206a736f6e20706172736572732f6465636f646572735c6e2020666978656420736f6d652073657269616c697a6174696f6e2070726f626c656d735c6e202076657273696f6e2062756d705c6e20205265706f7369746f7279207265766973696f6e73204150495c6e20206d657263757269616c2076657273696f6e2062756d705c6e202042756d70205643532076657273696f6e20746f20302e342e3020616e64206d6f766520697420746f20636f64652e6170707a6f6e6175742e636f6d5c6e2020666978206c6f6767696e67206f6e206368616e676573206a736f6e206d6f64756c6520696e20726571756573747320312e585c6e222c20227265766973696f6e223a2035397d \N \N | ||||
59 enc-envelope \N hg 2 f f f enc-envelope repository 2013-05-28 20:27:19.74793 2013-03-07 15:37:40 tip f \N \\x7b227261775f6964223a202238313030363666383335643663303832393530666337383238646564353062396238643963323239222c202273686f72745f6964223a2022383130303636663833356436222c2022617574686f72223a20224d617263696e204b757a6d696e736b69203c6d617263696e40707974686f6e2d776f726b732e636f6d3e222c202264617465223a2022323031332d30332d30375431353a33373a3430222c20226d657373616765223a202273686f77206d6f72652064657461696c656420696e666f2061626f75742077726f6e672073747265616d222c20227265766973696f6e223a20357d \N \N | ||||
60 RC/gogo2 \N hg 2 f f f RC/gogo2 repository 2013-05-28 20:27:19.827312 2013-05-28 20:27:19.827334 tip f \N \N \N 1 | ||||
61 csa-libcloud \N git 2 f f f Unnamed repository; edit this file 'description' to name the repository.\n 2013-05-28 20:27:19.892075 2013-04-17 16:42:42 tip f \N \\x7b227261775f6964223a202261326661353531363333636533363937616336336139333561613731663165376238303232326165222c202273686f72745f6964223a2022613266613535313633336365222c2022617574686f72223a20224d617263696e204b757a6d696e736b69203c6d617263696e40707974686f6e2d776f726b732e636f6d3e222c202264617465223a2022323031332d30342d31375431363a34323a3432222c20226d657373616765223a202266696c746572206f6e6c79206c697374656e65727320427269676874626f782063616e2070726f63657373222c20227265766973696f6e223a20313839357d \N \N | ||||
62 RC/git-test \N git 2 f f f Unnamed repository 2013-05-28 20:27:20.231554 2013-03-25 22:50:04 tip f \N \\x7b227261775f6964223a202235643561646464666339323963643839653931313131366436306231323064316361613866333964222c202273686f72745f6964223a2022356435616464646663393239222c2022617574686f72223a20224d617263696e204b757a6d696e736b69203c6d617263696e40707974686f6e2d776f726b732e636f6d3e222c202264617465223a2022323031332d30332d32355432323a35303a3034222c20226d657373616765223a202266785c6e222c20227265766973696f6e223a20397d \N 1 | ||||
63 RC/rc2/test \N hg 2 f f f RC/rc2/test repository 2013-05-28 20:27:20.356786 2013-05-28 20:27:20.35683 tip f \N \N \N 4 | ||||
64 rhodecode.bak \N hg 2 f f f rhodecode.bak repository 2013-05-28 20:27:20.423238 2013-05-28 02:41:49 tip f \N \\x7b227261775f6964223a202262633862616365663164303663306330643132616337386638326565353330666363393661663561222c202273686f72745f6964223a2022626338626163656631643036222c2022617574686f72223a20224d617263696e204b757a6d696e736b69203c6d617263696e40707974686f6e2d776f726b732e636f6d3e222c202264617465223a2022323031332d30352d32385430323a34313a3439222c20226d657373616765223a20224164646564206e657720617069206d6574686f64735c6e2d206765745f7365727665725f696e666f5c6e2d206765745f69705c6e2d207570646174655f7265706f5c6e2d206765745f7265706f5f67726f75705c6e2d206765745f7265706f5f67726f7570735c6e2d206372656174655f7265706f5f67726f75705c6e2d207570646174655f7265706f5f67726f75705c6e2d2064656c6574655f7265706f5f67726f75705c6e2d207570646174655f757365725f67726f75705c6e2d206765745f676973745c6e2d206765745f67697374735c6e2d2064656c6574655f676973745c6e5c6e2b207265666163746f72696e67206f66206e616d657320616e642067656e6572616c2041504920636c65616e75702e5c6e41504920646f63732077696c6c206e6f772062652067656e657261746564206261736564206f6e2066756e6374696f6e20646f63737472696e67735c6e546869732077696c6c206d616b652069742065617369657220746f20646f2070726f70657220646f63756d656e746174696f6e20666f72204150492e222c20227265766973696f6e223a20343033397d \N \N | ||||
65 RC/kiall-nova \N git 2 f f f Unnamed repository; edit this file 'description' to name the repository.\n 2013-05-28 20:27:20.524084 2012-10-23 10:22:06 tip f \N \\x7b227261775f6964223a202261306663643132343830373161643636623631306561633439303361646633366233313433393062222c202273686f72745f6964223a2022613066636431323438303731222c2022617574686f72223a20224a656e6b696e73203c6a656e6b696e73407265766965772e6f70656e737461636b2e6f72673e222c202264617465223a2022323031322d31302d32335431303a32323a3036222c20226d657373616765223a20224d65726765205c22466978206e6f76612d766f6c756d652d75736167652d61756469745c22222c20227265766973696f6e223a2031373235337d \N 1 | ||||
\. | ||||
-- | ||||
-- Data for Name: repositories_fields; Type: TABLE DATA; Schema: public; Owner: postgres | ||||
-- | ||||
COPY repositories_fields (repo_field_id, repository_id, field_key, field_label, field_value, field_desc, field_type, created_on) FROM stdin; | ||||
\. | ||||
-- | ||||
-- Name: repositories_fields_repo_field_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | ||||
-- | ||||
SELECT pg_catalog.setval('repositories_fields_repo_field_id_seq', 1, false); | ||||
-- | ||||
-- Name: repositories_repo_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | ||||
-- | ||||
SELECT pg_catalog.setval('repositories_repo_id_seq', 65, true); | ||||
-- | ||||
-- Data for Name: rhodecode_settings; Type: TABLE DATA; Schema: public; Owner: postgres | ||||
-- | ||||
COPY rhodecode_settings (app_settings_id, app_settings_name, app_settings_value) FROM stdin; | ||||
1 realm RhodeCode authentication | ||||
2 title RhodeCode | ||||
3 ga_code 123456 | ||||
4 show_public_icon True | ||||
5 show_private_icon True | ||||
6 stylify_metatags False | ||||
7 ldap_active false | ||||
8 ldap_host | ||||
9 ldap_port 389 | ||||
10 ldap_tls_kind PLAIN | ||||
11 ldap_tls_reqcert | ||||
12 ldap_dn_user | ||||
13 ldap_dn_pass | ||||
14 ldap_base_dn | ||||
15 ldap_filter | ||||
16 ldap_search_scope | ||||
17 ldap_attr_login | ||||
18 ldap_attr_firstname | ||||
19 ldap_attr_lastname | ||||
20 ldap_attr_email | ||||
21 default_repo_enable_locking False | ||||
22 default_repo_enable_downloads False | ||||
23 default_repo_enable_statistics False | ||||
24 default_repo_private False | ||||
25 default_repo_type hg | ||||
\. | ||||
-- | ||||
-- Name: rhodecode_settings_app_settings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | ||||
-- | ||||
SELECT pg_catalog.setval('rhodecode_settings_app_settings_id_seq', 25, true); | ||||
-- | ||||
-- Data for Name: rhodecode_ui; Type: TABLE DATA; Schema: public; Owner: postgres | ||||
-- | ||||
COPY rhodecode_ui (ui_id, ui_section, ui_key, ui_value, ui_active) FROM stdin; | ||||
1 hooks changegroup.update hg update >&2 f | ||||
2 hooks changegroup.repo_size python:rhodecode.lib.hooks.repo_size t | ||||
3 hooks changegroup.push_logger python:rhodecode.lib.hooks.log_push_action t | ||||
4 hooks prechangegroup.pre_push python:rhodecode.lib.hooks.pre_push t | ||||
5 hooks outgoing.pull_logger python:rhodecode.lib.hooks.log_pull_action t | ||||
6 hooks preoutgoing.pre_pull python:rhodecode.lib.hooks.pre_pull t | ||||
7 extensions largefiles t | ||||
8 extensions hgsubversion f | ||||
9 extensions hggit f | ||||
10 web push_ssl false t | ||||
11 web allow_archive gz zip bz2 t | ||||
12 web allow_push * t | ||||
13 web baseurl / t | ||||
14 paths / /mnt/hgfs/workspace-python t | ||||
\. | ||||
-- | ||||
-- Name: rhodecode_ui_ui_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | ||||
-- | ||||
SELECT pg_catalog.setval('rhodecode_ui_ui_id_seq', 14, true); | ||||
-- | ||||
-- Data for Name: statistics; Type: TABLE DATA; Schema: public; Owner: postgres | ||||
-- | ||||
COPY statistics (stat_id, repository_id, stat_on_revision, commit_activity, commit_activity_combined, languages) FROM stdin; | ||||
\. | ||||
-- | ||||
-- Name: statistics_stat_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | ||||
-- | ||||
SELECT pg_catalog.setval('statistics_stat_id_seq', 1, false); | ||||
-- | ||||
-- Data for Name: user_email_map; Type: TABLE DATA; Schema: public; Owner: postgres | ||||
-- | ||||
COPY user_email_map (email_id, user_id, email) FROM stdin; | ||||
\. | ||||
-- | ||||
-- Name: user_email_map_email_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | ||||
-- | ||||
SELECT pg_catalog.setval('user_email_map_email_id_seq', 1, false); | ||||
-- | ||||
-- Data for Name: user_followings; Type: TABLE DATA; Schema: public; Owner: postgres | ||||
-- | ||||
COPY user_followings (user_following_id, user_id, follows_repository_id, follows_user_id, follows_from) FROM stdin; | ||||
1 2 1 \N 2013-05-28 20:26:59.905946 | ||||
2 2 2 \N 2013-05-28 20:26:59.958581 | ||||
3 2 3 \N 2013-05-28 20:27:00.145566 | ||||
4 2 4 \N 2013-05-28 20:27:00.184438 | ||||
5 2 5 \N 2013-05-28 20:27:01.507836 | ||||
6 2 6 \N 2013-05-28 20:27:01.562696 | ||||
7 2 7 \N 2013-05-28 20:27:01.630538 | ||||
8 2 8 \N 2013-05-28 20:27:01.658765 | ||||
9 2 9 \N 2013-05-28 20:27:01.883077 | ||||
10 2 10 \N 2013-05-28 20:27:02.410512 | ||||
11 2 11 \N 2013-05-28 20:27:02.47039 | ||||
12 2 12 \N 2013-05-28 20:27:02.512861 | ||||
13 2 13 \N 2013-05-28 20:27:02.705559 | ||||
14 2 14 \N 2013-05-28 20:27:02.736051 | ||||
15 2 15 \N 2013-05-28 20:27:02.909458 | ||||
16 2 16 \N 2013-05-28 20:27:03.058143 | ||||
17 2 17 \N 2013-05-28 20:27:03.092663 | ||||
18 2 18 \N 2013-05-28 20:27:03.220556 | ||||
19 2 19 \N 2013-05-28 20:27:03.401209 | ||||
20 2 20 \N 2013-05-28 20:27:03.446846 | ||||
21 2 21 \N 2013-05-28 20:27:03.478718 | ||||
22 2 22 \N 2013-05-28 20:27:03.625506 | ||||
23 2 23 \N 2013-05-28 20:27:03.654446 | ||||
24 2 24 \N 2013-05-28 20:27:03.90204 | ||||
25 2 25 \N 2013-05-28 20:27:03.935584 | ||||
26 2 26 \N 2013-05-28 20:27:04.133528 | ||||
27 2 27 \N 2013-05-28 20:27:04.165426 | ||||
28 2 28 \N 2013-05-28 20:27:04.227192 | ||||
29 2 29 \N 2013-05-28 20:27:04.470074 | ||||
30 2 30 \N 2013-05-28 20:27:04.535036 | ||||
31 2 31 \N 2013-05-28 20:27:04.56081 | ||||
32 2 32 \N 2013-05-28 20:27:04.73511 | ||||
33 2 33 \N 2013-05-28 20:27:04.762367 | ||||
34 2 34 \N 2013-05-28 20:27:04.882269 | ||||
35 2 35 \N 2013-05-28 20:27:16.081624 | ||||
36 2 36 \N 2013-05-28 20:27:16.238074 | ||||
37 2 37 \N 2013-05-28 20:27:16.490921 | ||||
38 2 38 \N 2013-05-28 20:27:16.606332 | ||||
39 2 39 \N 2013-05-28 20:27:16.683877 | ||||
40 2 40 \N 2013-05-28 20:27:16.772204 | ||||
41 2 41 \N 2013-05-28 20:27:16.846091 | ||||
42 2 42 \N 2013-05-28 20:27:16.915625 | ||||
43 2 43 \N 2013-05-28 20:27:17.000652 | ||||
44 2 44 \N 2013-05-28 20:27:17.035001 | ||||
45 2 45 \N 2013-05-28 20:27:17.245544 | ||||
46 2 46 \N 2013-05-28 20:27:17.412282 | ||||
47 2 47 \N 2013-05-28 20:27:17.442703 | ||||
48 2 48 \N 2013-05-28 20:27:17.616299 | ||||
49 2 49 \N 2013-05-28 20:27:17.694907 | ||||
50 2 50 \N 2013-05-28 20:27:17.76193 | ||||
51 2 51 \N 2013-05-28 20:27:17.796316 | ||||
52 2 52 \N 2013-05-28 20:27:17.911214 | ||||
53 2 53 \N 2013-05-28 20:27:18.67818 | ||||
54 2 54 \N 2013-05-28 20:27:18.712023 | ||||
55 2 55 \N 2013-05-28 20:27:18.837132 | ||||
56 2 56 \N 2013-05-28 20:27:19.053951 | ||||
57 2 57 \N 2013-05-28 20:27:19.51609 | ||||
58 2 58 \N 2013-05-28 20:27:19.543354 | ||||
59 2 59 \N 2013-05-28 20:27:19.809302 | ||||
60 2 60 \N 2013-05-28 20:27:19.877469 | ||||
61 2 61 \N 2013-05-28 20:27:19.908981 | ||||
62 2 62 \N 2013-05-28 20:27:20.247031 | ||||
63 2 63 \N 2013-05-28 20:27:20.410876 | ||||
64 2 64 \N 2013-05-28 20:27:20.506094 | ||||
65 2 65 \N 2013-05-28 20:27:20.536866 | ||||
\. | ||||
-- | ||||
-- Name: user_followings_user_following_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | ||||
-- | ||||
SELECT pg_catalog.setval('user_followings_user_following_id_seq', 65, true); | ||||
-- | ||||
-- Data for Name: user_ip_map; Type: TABLE DATA; Schema: public; Owner: postgres | ||||
-- | ||||
COPY user_ip_map (ip_id, user_id, ip_addr, active) FROM stdin; | ||||
\. | ||||
-- | ||||
-- Name: user_ip_map_ip_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | ||||
-- | ||||
SELECT pg_catalog.setval('user_ip_map_ip_id_seq', 1, false); | ||||
-- | ||||
-- Data for Name: user_logs; Type: TABLE DATA; Schema: public; Owner: postgres | ||||
-- | ||||
COPY user_logs (user_log_id, user_id, username, repository_id, repository_name, user_ip, action, action_date) FROM stdin; | ||||
1 2 marcink 1 RC/mygr/lol started_following_repo 2013-05-28 20:26:59.900931 | ||||
2 2 marcink 2 RC/fakeclone started_following_repo 2013-05-28 20:26:59.955428 | ||||
3 2 marcink 3 RC/muay started_following_repo 2013-05-28 20:27:00.125953 | ||||
4 2 marcink 4 BIG/git started_following_repo 2013-05-28 20:27:00.181617 | ||||
5 2 marcink 5 RC/origin-fork started_following_repo 2013-05-28 20:27:01.466724 | ||||
6 2 marcink 6 one started_following_repo 2013-05-28 20:27:01.536732 | ||||
7 2 marcink 7 rhodecode.bak.1 started_following_repo 2013-05-28 20:27:01.589472 | ||||
8 2 marcink 8 csa-collins started_following_repo 2013-05-28 20:27:01.655365 | ||||
9 2 marcink 9 csa-harmony started_following_repo 2013-05-28 20:27:01.88057 | ||||
10 2 marcink 10 RC/ąqweqwe started_following_repo 2013-05-28 20:27:02.387499 | ||||
11 2 marcink 11 rhodecode started_following_repo 2013-05-28 20:27:02.433418 | ||||
12 2 marcink 12 csa-unity started_following_repo 2013-05-28 20:27:02.508796 | ||||
13 2 marcink 13 RC/łęcina started_following_repo 2013-05-28 20:27:02.674658 | ||||
14 2 marcink 14 waitress started_following_repo 2013-05-28 20:27:02.73244 | ||||
15 2 marcink 15 RC/rc2/test2 started_following_repo 2013-05-28 20:27:02.906659 | ||||
16 2 marcink 16 RC/origin-fork-fork started_following_repo 2013-05-28 20:27:03.02717 | ||||
17 2 marcink 17 RC/rc2/test4 started_following_repo 2013-05-28 20:27:03.090085 | ||||
18 2 marcink 18 RC/vcs-git started_following_repo 2013-05-28 20:27:03.218033 | ||||
19 2 marcink 19 rhodecode-extensions started_following_repo 2013-05-28 20:27:03.374166 | ||||
20 2 marcink 20 rhodecode-cli-gist started_following_repo 2013-05-28 20:27:03.425087 | ||||
21 2 marcink 21 test.onaut.com started_following_repo 2013-05-28 20:27:03.473193 | ||||
22 2 marcink 22 RC/new started_following_repo 2013-05-28 20:27:03.593153 | ||||
23 2 marcink 23 csa-aldrin started_following_repo 2013-05-28 20:27:03.651182 | ||||
24 2 marcink 24 vcs started_following_repo 2013-05-28 20:27:03.866907 | ||||
25 2 marcink 25 csa-prometheus started_following_repo 2013-05-28 20:27:03.931789 | ||||
26 2 marcink 26 RC/INRC/trololo started_following_repo 2013-05-28 20:27:04.108947 | ||||
27 2 marcink 27 RC/empty-git started_following_repo 2013-05-28 20:27:04.162816 | ||||
28 2 marcink 28 csa-salt-states started_following_repo 2013-05-28 20:27:04.224517 | ||||
29 2 marcink 29 rhodecode-premium started_following_repo 2013-05-28 20:27:04.429318 | ||||
30 2 marcink 30 RC/qweqwe-fork started_following_repo 2013-05-28 20:27:04.508625 | ||||
31 2 marcink 31 testrepo-quick started_following_repo 2013-05-28 20:27:04.558071 | ||||
32 2 marcink 32 RC/test started_following_repo 2013-05-28 20:27:04.707963 | ||||
33 2 marcink 33 remote-salt started_following_repo 2013-05-28 20:27:04.759601 | ||||
34 2 marcink 34 BIG/android started_following_repo 2013-05-28 20:27:04.879601 | ||||
35 2 marcink 35 DOCS started_following_repo 2013-05-28 20:27:16.077043 | ||||
36 2 marcink 36 rhodecode-git started_following_repo 2013-05-28 20:27:16.235309 | ||||
37 2 marcink 37 RC/bin-ops started_following_repo 2013-05-28 20:27:16.474785 | ||||
38 2 marcink 38 RC/INRC/L2_NEW/lalalal started_following_repo 2013-05-28 20:27:16.566047 | ||||
39 2 marcink 39 RC/fork-remote started_following_repo 2013-05-28 20:27:16.636895 | ||||
40 2 marcink 40 RC/INRC/L2_NEW/L3/repo_test_move started_following_repo 2013-05-28 20:27:16.73064 | ||||
41 2 marcink 41 RC/gogo-fork started_following_repo 2013-05-28 20:27:16.801352 | ||||
42 2 marcink 42 quest started_following_repo 2013-05-28 20:27:16.870218 | ||||
43 2 marcink 43 RC/foobar started_following_repo 2013-05-28 20:27:16.94344 | ||||
44 2 marcink 44 csa-hyperion started_following_repo 2013-05-28 20:27:17.032368 | ||||
45 2 marcink 45 RC/git-pull-test started_following_repo 2013-05-28 20:27:17.242321 | ||||
46 2 marcink 46 RC/qweqwe-fork2 started_following_repo 2013-05-28 20:27:17.369718 | ||||
47 2 marcink 47 RC/jap started_following_repo 2013-05-28 20:27:17.438737 | ||||
48 2 marcink 48 RC/hg-repo started_following_repo 2013-05-28 20:27:17.568968 | ||||
49 2 marcink 49 RC/origin started_following_repo 2013-05-28 20:27:17.647722 | ||||
50 2 marcink 50 rhodecode-cli-api started_following_repo 2013-05-28 20:27:17.720735 | ||||
51 2 marcink 51 RC/rc2/test3 started_following_repo 2013-05-28 20:27:17.793213 | ||||
52 2 marcink 52 csa-armstrong started_following_repo 2013-05-28 20:27:17.908068 | ||||
53 2 marcink 53 RC/trololo started_following_repo 2013-05-28 20:27:18.630661 | ||||
54 2 marcink 54 testrepo-wp started_following_repo 2013-05-28 20:27:18.707708 | ||||
55 2 marcink 55 pyramidpypi started_following_repo 2013-05-28 20:27:18.834547 | ||||
56 2 marcink 56 salt started_following_repo 2013-05-28 20:27:19.050625 | ||||
57 2 marcink 57 RC/lol/haha started_following_repo 2013-05-28 20:27:19.462058 | ||||
58 2 marcink 58 csa-io started_following_repo 2013-05-28 20:27:19.540782 | ||||
59 2 marcink 59 enc-envelope started_following_repo 2013-05-28 20:27:19.758453 | ||||
60 2 marcink 60 RC/gogo2 started_following_repo 2013-05-28 20:27:19.838573 | ||||
61 2 marcink 61 csa-libcloud started_following_repo 2013-05-28 20:27:19.904526 | ||||
62 2 marcink 62 RC/git-test started_following_repo 2013-05-28 20:27:20.243692 | ||||
63 2 marcink 63 RC/rc2/test started_following_repo 2013-05-28 20:27:20.36788 | ||||
64 2 marcink 64 rhodecode.bak started_following_repo 2013-05-28 20:27:20.435328 | ||||
65 2 marcink 65 RC/kiall-nova started_following_repo 2013-05-28 20:27:20.533474 | ||||
\. | ||||
-- | ||||
-- Name: user_logs_user_log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | ||||
-- | ||||
SELECT pg_catalog.setval('user_logs_user_log_id_seq', 65, true); | ||||
-- | ||||
-- Data for Name: user_repo_group_to_perm; Type: TABLE DATA; Schema: public; Owner: postgres | ||||
-- | ||||
COPY user_repo_group_to_perm (group_to_perm_id, user_id, group_id, permission_id) FROM stdin; | ||||
1 1 1 6 | ||||
2 1 2 6 | ||||
3 1 3 6 | ||||
4 1 4 6 | ||||
5 1 5 6 | ||||
6 1 6 6 | ||||
7 1 7 6 | ||||
8 1 8 6 | ||||
\. | ||||
-- | ||||
-- Name: user_repo_group_to_perm_group_to_perm_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | ||||
-- | ||||
SELECT pg_catalog.setval('user_repo_group_to_perm_group_to_perm_id_seq', 8, true); | ||||
-- | ||||
-- Data for Name: user_to_notification; Type: TABLE DATA; Schema: public; Owner: postgres | ||||
-- | ||||
COPY user_to_notification (user_id, notification_id, read, sent_on) FROM stdin; | ||||
\. | ||||
-- | ||||
-- Data for Name: user_to_perm; Type: TABLE DATA; Schema: public; Owner: postgres | ||||
-- | ||||
COPY user_to_perm (user_to_perm_id, user_id, permission_id) FROM stdin; | ||||
1 1 15 | ||||
2 1 11 | ||||
3 1 13 | ||||
4 1 2 | ||||
5 1 6 | ||||
\. | ||||
-- | ||||
-- Name: user_to_perm_user_to_perm_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | ||||
-- | ||||
SELECT pg_catalog.setval('user_to_perm_user_to_perm_id_seq', 5, true); | ||||
-- | ||||
-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: postgres | ||||
-- | ||||
COPY users (user_id, username, password, active, admin, firstname, lastname, email, last_login, ldap_dn, api_key, inherit_default_permissions) FROM stdin; | ||||
1 default $2a$10$pgqzrZyjE0YBlVErXftPnu4bMmbkO4BSIPtgPsrEoxM6xBdu.pFyi t f Anonymous User anonymous@rhodecode.org \N \N b7e62414df8fe4328b567603d6a409946af4a8f7 t | ||||
2 marcink $2a$10$htEvNjGrB1xEWaXJGrlWee.LB/ZT4.RON.VOfQ9caBSGSLnbHnvz2 t t RhodeCode Admin marcin@rhodecode.com \N \N 1d6f72e5dc6de70d9623f006edb28b8b56b3ebce t | ||||
\. | ||||
-- | ||||
-- Name: users_group_repo_group_to_per_users_group_repo_group_to_per_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | ||||
-- | ||||
SELECT pg_catalog.setval('users_group_repo_group_to_per_users_group_repo_group_to_per_seq', 1, false); | ||||
-- | ||||
-- Data for Name: users_group_repo_group_to_perm; Type: TABLE DATA; Schema: public; Owner: postgres | ||||
-- | ||||
COPY users_group_repo_group_to_perm (users_group_repo_group_to_perm_id, users_group_id, group_id, permission_id) FROM stdin; | ||||
\. | ||||
-- | ||||
-- Data for Name: users_group_repo_to_perm; Type: TABLE DATA; Schema: public; Owner: postgres | ||||
-- | ||||
COPY users_group_repo_to_perm (users_group_to_perm_id, users_group_id, permission_id, repository_id) FROM stdin; | ||||
\. | ||||
-- | ||||
-- Name: users_group_repo_to_perm_users_group_to_perm_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | ||||
-- | ||||
SELECT pg_catalog.setval('users_group_repo_to_perm_users_group_to_perm_id_seq', 1, false); | ||||
-- | ||||
-- Data for Name: users_group_to_perm; Type: TABLE DATA; Schema: public; Owner: postgres | ||||
-- | ||||
COPY users_group_to_perm (users_group_to_perm_id, users_group_id, permission_id) FROM stdin; | ||||
\. | ||||
-- | ||||
-- Name: users_group_to_perm_users_group_to_perm_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | ||||
-- | ||||
SELECT pg_catalog.setval('users_group_to_perm_users_group_to_perm_id_seq', 1, false); | ||||
-- | ||||
-- Data for Name: users_groups; Type: TABLE DATA; Schema: public; Owner: postgres | ||||
-- | ||||
COPY users_groups (users_group_id, users_group_name, users_group_active, users_group_inherit_default_permissions) FROM stdin; | ||||
\. | ||||
-- | ||||
-- Data for Name: users_groups_members; Type: TABLE DATA; Schema: public; Owner: postgres | ||||
-- | ||||
COPY users_groups_members (users_group_member_id, users_group_id, user_id) FROM stdin; | ||||
\. | ||||
-- | ||||
-- Name: users_groups_members_users_group_member_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | ||||
-- | ||||
SELECT pg_catalog.setval('users_groups_members_users_group_member_id_seq', 1, false); | ||||
-- | ||||
-- Name: users_groups_users_group_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | ||||
-- | ||||
SELECT pg_catalog.setval('users_groups_users_group_id_seq', 1, false); | ||||
-- | ||||
-- Name: users_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres | ||||
-- | ||||
SELECT pg_catalog.setval('users_user_id_seq', 2, true); | ||||
-- | ||||
-- Name: cache_invalidation_cache_key_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY cache_invalidation | ||||
ADD CONSTRAINT cache_invalidation_cache_key_key UNIQUE (cache_key); | ||||
-- | ||||
-- Name: cache_invalidation_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY cache_invalidation | ||||
ADD CONSTRAINT cache_invalidation_pkey PRIMARY KEY (cache_id); | ||||
-- | ||||
-- Name: changeset_comments_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY changeset_comments | ||||
ADD CONSTRAINT changeset_comments_pkey PRIMARY KEY (comment_id); | ||||
-- | ||||
-- Name: changeset_statuses_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY changeset_statuses | ||||
ADD CONSTRAINT changeset_statuses_pkey PRIMARY KEY (changeset_status_id); | ||||
-- | ||||
-- Name: changeset_statuses_repo_id_revision_version_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY changeset_statuses | ||||
ADD CONSTRAINT changeset_statuses_repo_id_revision_version_key UNIQUE (repo_id, revision, version); | ||||
-- | ||||
-- Name: db_migrate_version_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY db_migrate_version | ||||
ADD CONSTRAINT db_migrate_version_pkey PRIMARY KEY (repository_id); | ||||
-- | ||||
-- Name: groups_group_name_group_parent_id_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY groups | ||||
ADD CONSTRAINT groups_group_name_group_parent_id_key UNIQUE (group_name, group_parent_id); | ||||
-- | ||||
-- Name: groups_group_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY groups | ||||
ADD CONSTRAINT groups_group_name_key UNIQUE (group_name); | ||||
-- | ||||
-- Name: groups_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY groups | ||||
ADD CONSTRAINT groups_pkey PRIMARY KEY (group_id); | ||||
-- | ||||
-- Name: notifications_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY notifications | ||||
ADD CONSTRAINT notifications_pkey PRIMARY KEY (notification_id); | ||||
-- | ||||
-- Name: permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY permissions | ||||
ADD CONSTRAINT permissions_pkey PRIMARY KEY (permission_id); | ||||
-- | ||||
-- Name: pull_request_reviewers_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY pull_request_reviewers | ||||
ADD CONSTRAINT pull_request_reviewers_pkey PRIMARY KEY (pull_requests_reviewers_id); | ||||
-- | ||||
-- Name: pull_requests_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY pull_requests | ||||
ADD CONSTRAINT pull_requests_pkey PRIMARY KEY (pull_request_id); | ||||
-- | ||||
-- Name: repo_to_perm_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY repo_to_perm | ||||
ADD CONSTRAINT repo_to_perm_pkey PRIMARY KEY (repo_to_perm_id); | ||||
-- | ||||
-- Name: repo_to_perm_user_id_repository_id_permission_id_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY repo_to_perm | ||||
ADD CONSTRAINT repo_to_perm_user_id_repository_id_permission_id_key UNIQUE (user_id, repository_id, permission_id); | ||||
-- | ||||
-- Name: repositories_fields_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY repositories_fields | ||||
ADD CONSTRAINT repositories_fields_pkey PRIMARY KEY (repo_field_id); | ||||
-- | ||||
-- Name: repositories_fields_repository_id_field_key_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY repositories_fields | ||||
ADD CONSTRAINT repositories_fields_repository_id_field_key_key UNIQUE (repository_id, field_key); | ||||
-- | ||||
-- Name: repositories_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY repositories | ||||
ADD CONSTRAINT repositories_pkey PRIMARY KEY (repo_id); | ||||
-- | ||||
-- Name: repositories_repo_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY repositories | ||||
ADD CONSTRAINT repositories_repo_name_key UNIQUE (repo_name); | ||||
-- | ||||
-- Name: rhodecode_settings_app_settings_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY rhodecode_settings | ||||
ADD CONSTRAINT rhodecode_settings_app_settings_name_key UNIQUE (app_settings_name); | ||||
-- | ||||
-- Name: rhodecode_settings_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY rhodecode_settings | ||||
ADD CONSTRAINT rhodecode_settings_pkey PRIMARY KEY (app_settings_id); | ||||
-- | ||||
-- Name: rhodecode_ui_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY rhodecode_ui | ||||
ADD CONSTRAINT rhodecode_ui_pkey PRIMARY KEY (ui_id); | ||||
-- | ||||
-- Name: rhodecode_ui_ui_key_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY rhodecode_ui | ||||
ADD CONSTRAINT rhodecode_ui_ui_key_key UNIQUE (ui_key); | ||||
-- | ||||
-- Name: statistics_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY statistics | ||||
ADD CONSTRAINT statistics_pkey PRIMARY KEY (stat_id); | ||||
-- | ||||
-- Name: statistics_repository_id_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY statistics | ||||
ADD CONSTRAINT statistics_repository_id_key UNIQUE (repository_id); | ||||
-- | ||||
-- Name: user_email_map_email_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY user_email_map | ||||
ADD CONSTRAINT user_email_map_email_key UNIQUE (email); | ||||
-- | ||||
-- Name: user_email_map_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY user_email_map | ||||
ADD CONSTRAINT user_email_map_pkey PRIMARY KEY (email_id); | ||||
-- | ||||
-- Name: user_followings_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY user_followings | ||||
ADD CONSTRAINT user_followings_pkey PRIMARY KEY (user_following_id); | ||||
-- | ||||
-- Name: user_followings_user_id_follows_repository_id_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY user_followings | ||||
ADD CONSTRAINT user_followings_user_id_follows_repository_id_key UNIQUE (user_id, follows_repository_id); | ||||
-- | ||||
-- Name: user_followings_user_id_follows_user_id_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY user_followings | ||||
ADD CONSTRAINT user_followings_user_id_follows_user_id_key UNIQUE (user_id, follows_user_id); | ||||
-- | ||||
-- Name: user_ip_map_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY user_ip_map | ||||
ADD CONSTRAINT user_ip_map_pkey PRIMARY KEY (ip_id); | ||||
-- | ||||
-- Name: user_ip_map_user_id_ip_addr_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY user_ip_map | ||||
ADD CONSTRAINT user_ip_map_user_id_ip_addr_key UNIQUE (user_id, ip_addr); | ||||
-- | ||||
-- Name: user_logs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY user_logs | ||||
ADD CONSTRAINT user_logs_pkey PRIMARY KEY (user_log_id); | ||||
-- | ||||
-- Name: user_repo_group_to_perm_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY user_repo_group_to_perm | ||||
ADD CONSTRAINT user_repo_group_to_perm_pkey PRIMARY KEY (group_to_perm_id); | ||||
-- | ||||
-- Name: user_repo_group_to_perm_user_id_group_id_permission_id_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY user_repo_group_to_perm | ||||
ADD CONSTRAINT user_repo_group_to_perm_user_id_group_id_permission_id_key UNIQUE (user_id, group_id, permission_id); | ||||
-- | ||||
-- Name: user_to_notification_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY user_to_notification | ||||
ADD CONSTRAINT user_to_notification_pkey PRIMARY KEY (user_id, notification_id); | ||||
-- | ||||
-- Name: user_to_perm_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY user_to_perm | ||||
ADD CONSTRAINT user_to_perm_pkey PRIMARY KEY (user_to_perm_id); | ||||
-- | ||||
-- Name: user_to_perm_user_id_permission_id_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY user_to_perm | ||||
ADD CONSTRAINT user_to_perm_user_id_permission_id_key UNIQUE (user_id, permission_id); | ||||
-- | ||||
-- Name: users_email_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY users | ||||
ADD CONSTRAINT users_email_key UNIQUE (email); | ||||
-- | ||||
-- Name: users_group_repo_group_to_perm_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY users_group_repo_group_to_perm | ||||
ADD CONSTRAINT users_group_repo_group_to_perm_pkey PRIMARY KEY (users_group_repo_group_to_perm_id); | ||||
-- | ||||
-- Name: users_group_repo_group_to_perm_users_group_id_group_id_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY users_group_repo_group_to_perm | ||||
ADD CONSTRAINT users_group_repo_group_to_perm_users_group_id_group_id_key UNIQUE (users_group_id, group_id); | ||||
-- | ||||
-- Name: users_group_repo_to_perm_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY users_group_repo_to_perm | ||||
ADD CONSTRAINT users_group_repo_to_perm_pkey PRIMARY KEY (users_group_to_perm_id); | ||||
-- | ||||
-- Name: users_group_repo_to_perm_repository_id_users_group_id_permi_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY users_group_repo_to_perm | ||||
ADD CONSTRAINT users_group_repo_to_perm_repository_id_users_group_id_permi_key UNIQUE (repository_id, users_group_id, permission_id); | ||||
-- | ||||
-- Name: users_group_to_perm_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY users_group_to_perm | ||||
ADD CONSTRAINT users_group_to_perm_pkey PRIMARY KEY (users_group_to_perm_id); | ||||
-- | ||||
-- Name: users_group_to_perm_users_group_id_permission_id_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY users_group_to_perm | ||||
ADD CONSTRAINT users_group_to_perm_users_group_id_permission_id_key UNIQUE (users_group_id, permission_id); | ||||
-- | ||||
-- Name: users_groups_members_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY users_groups_members | ||||
ADD CONSTRAINT users_groups_members_pkey PRIMARY KEY (users_group_member_id); | ||||
-- | ||||
-- Name: users_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY users_groups | ||||
ADD CONSTRAINT users_groups_pkey PRIMARY KEY (users_group_id); | ||||
-- | ||||
-- Name: users_groups_users_group_name_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY users_groups | ||||
ADD CONSTRAINT users_groups_users_group_name_key UNIQUE (users_group_name); | ||||
-- | ||||
-- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY users | ||||
ADD CONSTRAINT users_pkey PRIMARY KEY (user_id); | ||||
-- | ||||
-- Name: users_username_key; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
ALTER TABLE ONLY users | ||||
ADD CONSTRAINT users_username_key UNIQUE (username); | ||||
-- | ||||
-- Name: cc_revision_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE INDEX cc_revision_idx ON changeset_comments USING btree (revision); | ||||
-- | ||||
-- Name: cs_revision_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE INDEX cs_revision_idx ON changeset_statuses USING btree (revision); | ||||
-- | ||||
-- Name: cs_version_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE INDEX cs_version_idx ON changeset_statuses USING btree (version); | ||||
-- | ||||
-- Name: key_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE INDEX key_idx ON cache_invalidation USING btree (cache_key); | ||||
-- | ||||
-- Name: notification_type_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE INDEX notification_type_idx ON notifications USING btree (type); | ||||
-- | ||||
-- Name: p_perm_name_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE INDEX p_perm_name_idx ON permissions USING btree (permission_name); | ||||
-- | ||||
-- Name: r_repo_name_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE INDEX r_repo_name_idx ON repositories USING btree (repo_name); | ||||
-- | ||||
-- Name: u_email_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE INDEX u_email_idx ON users USING btree (email); | ||||
-- | ||||
-- Name: u_username_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE INDEX u_username_idx ON users USING btree (username); | ||||
-- | ||||
-- Name: uem_email_idx; Type: INDEX; Schema: public; Owner: postgres; Tablespace: | ||||
-- | ||||
CREATE INDEX uem_email_idx ON user_email_map USING btree (email); | ||||
-- | ||||
-- Name: changeset_comments_pull_request_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY changeset_comments | ||||
ADD CONSTRAINT changeset_comments_pull_request_id_fkey FOREIGN KEY (pull_request_id) REFERENCES pull_requests(pull_request_id); | ||||
-- | ||||
-- Name: changeset_comments_repo_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY changeset_comments | ||||
ADD CONSTRAINT changeset_comments_repo_id_fkey FOREIGN KEY (repo_id) REFERENCES repositories(repo_id); | ||||
-- | ||||
-- Name: changeset_comments_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY changeset_comments | ||||
ADD CONSTRAINT changeset_comments_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(user_id); | ||||
-- | ||||
-- Name: changeset_statuses_changeset_comment_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY changeset_statuses | ||||
ADD CONSTRAINT changeset_statuses_changeset_comment_id_fkey FOREIGN KEY (changeset_comment_id) REFERENCES changeset_comments(comment_id); | ||||
-- | ||||
-- Name: changeset_statuses_pull_request_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY changeset_statuses | ||||
ADD CONSTRAINT changeset_statuses_pull_request_id_fkey FOREIGN KEY (pull_request_id) REFERENCES pull_requests(pull_request_id); | ||||
-- | ||||
-- Name: changeset_statuses_repo_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY changeset_statuses | ||||
ADD CONSTRAINT changeset_statuses_repo_id_fkey FOREIGN KEY (repo_id) REFERENCES repositories(repo_id); | ||||
-- | ||||
-- Name: changeset_statuses_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY changeset_statuses | ||||
ADD CONSTRAINT changeset_statuses_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(user_id); | ||||
-- | ||||
-- Name: groups_group_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY groups | ||||
ADD CONSTRAINT groups_group_parent_id_fkey FOREIGN KEY (group_parent_id) REFERENCES groups(group_id); | ||||
-- | ||||
-- Name: notifications_created_by_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY notifications | ||||
ADD CONSTRAINT notifications_created_by_fkey FOREIGN KEY (created_by) REFERENCES users(user_id); | ||||
-- | ||||
-- Name: pull_request_reviewers_pull_request_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY pull_request_reviewers | ||||
ADD CONSTRAINT pull_request_reviewers_pull_request_id_fkey FOREIGN KEY (pull_request_id) REFERENCES pull_requests(pull_request_id); | ||||
-- | ||||
-- Name: pull_request_reviewers_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY pull_request_reviewers | ||||
ADD CONSTRAINT pull_request_reviewers_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(user_id); | ||||
-- | ||||
-- Name: pull_requests_org_repo_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY pull_requests | ||||
ADD CONSTRAINT pull_requests_org_repo_id_fkey FOREIGN KEY (org_repo_id) REFERENCES repositories(repo_id); | ||||
-- | ||||
-- Name: pull_requests_other_repo_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY pull_requests | ||||
ADD CONSTRAINT pull_requests_other_repo_id_fkey FOREIGN KEY (other_repo_id) REFERENCES repositories(repo_id); | ||||
-- | ||||
-- Name: pull_requests_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY pull_requests | ||||
ADD CONSTRAINT pull_requests_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(user_id); | ||||
-- | ||||
-- Name: repo_to_perm_permission_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY repo_to_perm | ||||
ADD CONSTRAINT repo_to_perm_permission_id_fkey FOREIGN KEY (permission_id) REFERENCES permissions(permission_id); | ||||
-- | ||||
-- Name: repo_to_perm_repository_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY repo_to_perm | ||||
ADD CONSTRAINT repo_to_perm_repository_id_fkey FOREIGN KEY (repository_id) REFERENCES repositories(repo_id); | ||||
-- | ||||
-- Name: repo_to_perm_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY repo_to_perm | ||||
ADD CONSTRAINT repo_to_perm_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(user_id); | ||||
-- | ||||
-- Name: repositories_fields_repository_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY repositories_fields | ||||
ADD CONSTRAINT repositories_fields_repository_id_fkey FOREIGN KEY (repository_id) REFERENCES repositories(repo_id); | ||||
-- | ||||
-- Name: repositories_fork_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY repositories | ||||
ADD CONSTRAINT repositories_fork_id_fkey FOREIGN KEY (fork_id) REFERENCES repositories(repo_id); | ||||
-- | ||||
-- Name: repositories_group_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY repositories | ||||
ADD CONSTRAINT repositories_group_id_fkey FOREIGN KEY (group_id) REFERENCES groups(group_id); | ||||
-- | ||||
-- Name: repositories_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY repositories | ||||
ADD CONSTRAINT repositories_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(user_id); | ||||
-- | ||||
-- Name: statistics_repository_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY statistics | ||||
ADD CONSTRAINT statistics_repository_id_fkey FOREIGN KEY (repository_id) REFERENCES repositories(repo_id); | ||||
-- | ||||
-- Name: user_email_map_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY user_email_map | ||||
ADD CONSTRAINT user_email_map_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(user_id); | ||||
-- | ||||
-- Name: user_followings_follows_repository_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY user_followings | ||||
ADD CONSTRAINT user_followings_follows_repository_id_fkey FOREIGN KEY (follows_repository_id) REFERENCES repositories(repo_id); | ||||
-- | ||||
-- Name: user_followings_follows_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY user_followings | ||||
ADD CONSTRAINT user_followings_follows_user_id_fkey FOREIGN KEY (follows_user_id) REFERENCES users(user_id); | ||||
-- | ||||
-- Name: user_followings_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY user_followings | ||||
ADD CONSTRAINT user_followings_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(user_id); | ||||
-- | ||||
-- Name: user_ip_map_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY user_ip_map | ||||
ADD CONSTRAINT user_ip_map_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(user_id); | ||||
-- | ||||
-- Name: user_logs_repository_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY user_logs | ||||
ADD CONSTRAINT user_logs_repository_id_fkey FOREIGN KEY (repository_id) REFERENCES repositories(repo_id); | ||||
-- | ||||
-- Name: user_logs_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY user_logs | ||||
ADD CONSTRAINT user_logs_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(user_id); | ||||
-- | ||||
-- Name: user_repo_group_to_perm_group_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY user_repo_group_to_perm | ||||
ADD CONSTRAINT user_repo_group_to_perm_group_id_fkey FOREIGN KEY (group_id) REFERENCES groups(group_id); | ||||
-- | ||||
-- Name: user_repo_group_to_perm_permission_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY user_repo_group_to_perm | ||||
ADD CONSTRAINT user_repo_group_to_perm_permission_id_fkey FOREIGN KEY (permission_id) REFERENCES permissions(permission_id); | ||||
-- | ||||
-- Name: user_repo_group_to_perm_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY user_repo_group_to_perm | ||||
ADD CONSTRAINT user_repo_group_to_perm_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(user_id); | ||||
-- | ||||
-- Name: user_to_notification_notification_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY user_to_notification | ||||
ADD CONSTRAINT user_to_notification_notification_id_fkey FOREIGN KEY (notification_id) REFERENCES notifications(notification_id); | ||||
-- | ||||
-- Name: user_to_notification_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY user_to_notification | ||||
ADD CONSTRAINT user_to_notification_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(user_id); | ||||
-- | ||||
-- Name: user_to_perm_permission_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY user_to_perm | ||||
ADD CONSTRAINT user_to_perm_permission_id_fkey FOREIGN KEY (permission_id) REFERENCES permissions(permission_id); | ||||
-- | ||||
-- Name: user_to_perm_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY user_to_perm | ||||
ADD CONSTRAINT user_to_perm_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(user_id); | ||||
-- | ||||
-- Name: users_group_repo_group_to_perm_group_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY users_group_repo_group_to_perm | ||||
ADD CONSTRAINT users_group_repo_group_to_perm_group_id_fkey FOREIGN KEY (group_id) REFERENCES groups(group_id); | ||||
-- | ||||
-- Name: users_group_repo_group_to_perm_permission_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY users_group_repo_group_to_perm | ||||
ADD CONSTRAINT users_group_repo_group_to_perm_permission_id_fkey FOREIGN KEY (permission_id) REFERENCES permissions(permission_id); | ||||
-- | ||||
-- Name: users_group_repo_group_to_perm_users_group_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY users_group_repo_group_to_perm | ||||
ADD CONSTRAINT users_group_repo_group_to_perm_users_group_id_fkey FOREIGN KEY (users_group_id) REFERENCES users_groups(users_group_id); | ||||
-- | ||||
-- Name: users_group_repo_to_perm_permission_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY users_group_repo_to_perm | ||||
ADD CONSTRAINT users_group_repo_to_perm_permission_id_fkey FOREIGN KEY (permission_id) REFERENCES permissions(permission_id); | ||||
-- | ||||
-- Name: users_group_repo_to_perm_repository_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY users_group_repo_to_perm | ||||
ADD CONSTRAINT users_group_repo_to_perm_repository_id_fkey FOREIGN KEY (repository_id) REFERENCES repositories(repo_id); | ||||
-- | ||||
-- Name: users_group_repo_to_perm_users_group_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY users_group_repo_to_perm | ||||
ADD CONSTRAINT users_group_repo_to_perm_users_group_id_fkey FOREIGN KEY (users_group_id) REFERENCES users_groups(users_group_id); | ||||
-- | ||||
-- Name: users_group_to_perm_permission_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY users_group_to_perm | ||||
ADD CONSTRAINT users_group_to_perm_permission_id_fkey FOREIGN KEY (permission_id) REFERENCES permissions(permission_id); | ||||
-- | ||||
-- Name: users_group_to_perm_users_group_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY users_group_to_perm | ||||
ADD CONSTRAINT users_group_to_perm_users_group_id_fkey FOREIGN KEY (users_group_id) REFERENCES users_groups(users_group_id); | ||||
-- | ||||
-- Name: users_groups_members_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY users_groups_members | ||||
ADD CONSTRAINT users_groups_members_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(user_id); | ||||
-- | ||||
-- Name: users_groups_members_users_group_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres | ||||
-- | ||||
ALTER TABLE ONLY users_groups_members | ||||
ADD CONSTRAINT users_groups_members_users_group_id_fkey FOREIGN KEY (users_group_id) REFERENCES users_groups(users_group_id); | ||||
-- | ||||
-- Name: public; Type: ACL; Schema: -; Owner: postgres | ||||
-- | ||||
REVOKE ALL ON SCHEMA public FROM PUBLIC; | ||||
REVOKE ALL ON SCHEMA public FROM postgres; | ||||
GRANT ALL ON SCHEMA public TO postgres; | ||||
GRANT ALL ON SCHEMA public TO PUBLIC; | ||||
-- | ||||
-- PostgreSQL database dump complete | ||||
-- | ||||