rhodecode/tests/database/postgres/1.4.4.sql

--
-- 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),
    fork_id integer,
    group_id integer
);


ALTER TABLE public.repositories OWNER TO postgres;

--
-- 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_logs; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE user_logs (
    user_log_id integer NOT NULL,
    user_id integer NOT NULL,
    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: 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: 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/fakeclone	RC/fakeclone	f
2	1RC/muay	RC/muay	f
3	1one	one	f
4	1RC/rc2/test2	RC/rc2/test2	f
5	1RC/rc2/test3	RC/rc2/test3	f
6	1RC/rc2/test4	RC/rc2/test4	f
7	1rhodecode-cli-gist	rhodecode-cli-gist	f
8	1test.onaut.com	test.onaut.com	f
9	1RC/new	RC/new	f
10	1rc_gist/32	rc_gist/32	f
11	1vcs	vcs	f
12	1rc_gist/36	rc_gist/36	f
13	1rc_gist/37	rc_gist/37	f
14	1rc_gist/39	rc_gist/39	f
15	1remote-salt	remote-salt	f
16	1RC/INRC/trololo	RC/INRC/trololo	f
17	1quest	quest	f
18	1csa-hyperion	csa-hyperion	f
19	1rhodecode	rhodecode	f
20	1RC/origin-fork-fork	RC/origin-fork-fork	f
21	1rc_gist/45	rc_gist/45	f
22	1rc_gist/44	rc_gist/44	f
23	1rc_gist/46	rc_gist/46	f
24	1rc_gist/41	rc_gist/41	f
25	1rc_gist/40	rc_gist/40	f
26	1RC/gogo2	RC/gogo2	f
27	1rc_gist/42	rc_gist/42	f
28	1rc_gist/49	rc_gist/49	f
29	1rc_gist/48	rc_gist/48	f
30	1csa-collins	csa-collins	f
31	1rc_gist/54	rc_gist/54	f
32	1rc_gist/55	rc_gist/55	f
33	1rc_gist/52	rc_gist/52	f
34	1rc_gist/53	rc_gist/53	f
35	1rc_gist/50	rc_gist/50	f
36	1rc_gist/51	rc_gist/51	f
37	1rhodecode.bak.1	rhodecode.bak.1	f
38	1BIG/android	BIG/android	f
39	1RC/gogo-fork	RC/gogo-fork	f
40	1RC/mygr/lol	RC/mygr/lol	f
41	1testrepo-wp	testrepo-wp	f
42	1RC/hg-repo	RC/hg-repo	f
43	1testrepo-quick	testrepo-quick	f
44	1RC/bin-ops	RC/bin-ops	f
45	1rc_gist/xFvj6dFqqVK5vfsGP8PU	rc_gist/xFvj6dFqqVK5vfsGP8PU	f
46	1rhodecode-git	rhodecode-git	f
47	1csa-io	csa-io	f
48	1RC/qweqwe-fork	RC/qweqwe-fork	f
49	1csa-libcloud	csa-libcloud	f
50	1waitress	waitress	f
51	1rc_gist/8	rc_gist/8	f
52	1rc_gist/9	rc_gist/9	f
53	1RC/foobar	RC/foobar	f
54	1rc_gist/1	rc_gist/1	f
55	1rc_gist/3	rc_gist/3	f
56	1rc_gist/4	rc_gist/4	f
57	1rc_gist/5	rc_gist/5	f
58	1rc_gist/6	rc_gist/6	f
59	1rc_gist/7	rc_gist/7	f
60	1csa-harmony	csa-harmony	f
61	1rhodecode-extensions	rhodecode-extensions	f
62	1csa-prometheus	csa-prometheus	f
63	1RC/empty-git	RC/empty-git	f
64	1csa-salt-states	csa-salt-states	f
65	1RC/łęcina	RC/łęcina	f
66	1rhodecode-premium	rhodecode-premium	f
67	1RC/qweqwe-fork2	RC/qweqwe-fork2	f
68	1RC/INRC/L2_NEW/lalalal	RC/INRC/L2_NEW/lalalal	f
69	1RC/INRC/L2_NEW/L3/repo_test_move	RC/INRC/L2_NEW/L3/repo_test_move	f
70	1rhodecode.bak	rhodecode.bak	f
71	1RC/jap	RC/jap	f
72	1RC/origin	RC/origin	f
73	1rhodecode-cli-api	rhodecode-cli-api	f
74	1csa-armstrong	csa-armstrong	f
75	1rc_gist/NAsB8cacjxnqdyZ8QUl3	rc_gist/NAsB8cacjxnqdyZ8QUl3	f
76	1RC/lol/haha	RC/lol/haha	f
77	1enc-envelope	enc-envelope	f
78	1rc_gist/43	rc_gist/43	f
79	1RC/test	RC/test	f
80	1BIG/git	BIG/git	f
81	1RC/origin-fork	RC/origin-fork	f
82	1RC/trololo	RC/trololo	f
83	1rc_gist/FLj8GunafFAVBnuTWDxU	rc_gist/FLj8GunafFAVBnuTWDxU	f
84	1csa-unity	csa-unity	f
85	1RC/vcs-git	RC/vcs-git	f
86	1rc_gist/12	rc_gist/12	f
87	1rc_gist/13	rc_gist/13	f
88	1rc_gist/10	rc_gist/10	f
89	1rc_gist/11	rc_gist/11	f
90	1RC/kiall-nova	RC/kiall-nova	f
91	1RC/rc2/test	RC/rc2/test	f
92	1DOCS	DOCS	f
93	1RC/fork-remote	RC/fork-remote	f
94	1RC/git-pull-test	RC/git-pull-test	f
95	1pyramidpypi	pyramidpypi	f
96	1rc_gist/aQpbufbhSac6FyvVHhmS	rc_gist/aQpbufbhSac6FyvVHhmS	f
97	1csa-aldrin	csa-aldrin	f
98	1RC/ąqweqwe	RC/ąqweqwe	f
99	1rc_gist/QL2GhrlKymNmrUJJy5js	rc_gist/QL2GhrlKymNmrUJJy5js	f
100	1RC/git-test	RC/git-test	f
101	1salt	salt	f
\.


--
-- Name: cache_invalidation_cache_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('cache_invalidation_cache_id_seq', 101, 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	7
\.


--
-- 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/rc2	1	RC/rc2 group	f
3	rc_gist	\N	rc_gist group	f
4	RC/INRC	1	RC/INRC group	f
5	BIG	\N	BIG group	f
6	RC/mygr	1	RC/mygr group	f
7	RC/INRC/L2_NEW	4	RC/INRC/L2_NEW group	f
8	RC/INRC/L2_NEW/L3	7	RC/INRC/L2_NEW/L3 group	f
9	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', 9, 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
66	1	2	66
67	1	2	67
68	1	2	68
69	1	2	69
70	1	2	70
71	1	2	71
72	1	2	72
73	1	2	73
74	1	2	74
75	1	2	75
76	1	2	76
77	1	2	77
78	1	2	78
79	1	2	79
80	1	2	80
81	1	2	81
82	1	2	82
83	1	2	83
84	1	2	84
85	1	2	85
86	1	2	86
87	1	2	87
88	1	2	88
89	1	2	89
90	1	2	90
91	1	2	91
92	1	2	92
93	1	2	93
94	1	2	94
95	1	2	95
96	1	2	96
97	1	2	97
98	1	2	98
99	1	2	99
100	1	2	100
101	1	2	101
\.


--
-- 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', 101, 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, fork_id, group_id) FROM stdin;
1	RC/fakeclone	http://user@vm/RC/fakeclone	git	2	f	f	t	Unnamed repository; edit this file 'description' to name the repository.\n	2013-05-28 20:19:46.047944	2013-05-28 20:19:46.047971	tip	f	\N	\N	1
2	RC/muay	\N	hg	2	f	f	t	RC/muay repository	2013-05-28 20:19:46.114543	2013-05-28 20:19:46.114565	tip	f	\N	\N	1
3	one	\N	hg	2	f	f	t	one repository	2013-05-28 20:19:46.134156	2013-05-28 20:19:46.134179	tip	f	\N	\N	\N
4	RC/rc2/test2	\N	git	2	f	f	t	Unnamed repository; edit this file 'description' to name the repository.\n	2013-05-28 20:19:46.172851	2013-05-28 20:19:46.172875	tip	f	\N	\N	2
5	RC/rc2/test3	\N	git	2	f	f	t	Unnamed repository; edit this file 'description' to name the repository.\n	2013-05-28 20:19:46.224723	2013-05-28 20:19:46.224746	tip	f	\N	\N	2
6	RC/rc2/test4	\N	git	2	f	f	t	Unnamed repository; edit this file 'description' to name the repository.\n	2013-05-28 20:19:46.282256	2013-05-28 20:19:46.282281	tip	f	\N	\N	2
7	rhodecode-cli-gist	\N	hg	2	f	f	t	rhodecode-cli-gist repository	2013-05-28 20:19:46.33147	2013-05-28 20:19:46.331495	tip	f	\N	\N	\N
8	test.onaut.com	\N	git	2	f	f	t	Unnamed repository	2013-05-28 20:19:46.352391	2013-05-28 20:19:46.352413	tip	f	\N	\N	\N
9	RC/new	\N	hg	2	f	f	t	RC/new repository	2013-05-28 20:19:46.406258	2013-05-28 20:19:46.406287	tip	f	\N	\N	1
10	rc_gist/32	\N	hg	2	f	f	t	rc_gist/32 repository	2013-05-28 20:19:46.439556	2013-05-28 20:19:46.439581	tip	f	\N	\N	3
11	vcs	\N	hg	2	f	f	t	vcs repository	2013-05-28 20:19:46.464778	2013-05-28 20:19:46.464804	tip	f	\N	\N	\N
12	rc_gist/36	\N	hg	2	f	f	t	rc_gist/36 repository	2013-05-28 20:19:46.497987	2013-05-28 20:19:46.498012	tip	f	\N	\N	3
13	rc_gist/37	\N	hg	2	f	f	t	rc_gist/37 repository	2013-05-28 20:19:46.52051	2013-05-28 20:19:46.520533	tip	f	\N	\N	3
14	rc_gist/39	\N	hg	2	f	f	t	rc_gist/39 repository	2013-05-28 20:19:46.545352	2013-05-28 20:19:46.545375	tip	f	\N	\N	3
15	remote-salt	\N	git	2	f	f	t	Unnamed repository; edit this file 'description' to name the repository.\n	2013-05-28 20:19:46.568093	2013-05-28 20:19:46.568116	tip	f	\N	\N	\N
16	RC/INRC/trololo	\N	hg	2	f	f	t	RC/INRC/trololo repository	2013-05-28 20:19:46.630152	2013-05-28 20:19:46.630174	tip	f	\N	\N	4
17	quest	\N	hg	2	f	f	t	quest repository	2013-05-28 20:19:46.65001	2013-05-28 20:19:46.650031	tip	f	\N	\N	\N
18	csa-hyperion	\N	git	2	f	f	t	Unnamed repository; edit this file 'description' to name the repository.\n	2013-05-28 20:19:46.674955	2013-05-28 20:19:46.67498	tip	f	\N	\N	\N
19	rhodecode	\N	hg	2	f	f	t	rhodecode repository	2013-05-28 20:19:46.717995	2013-05-28 20:19:46.718016	tip	f	\N	\N	\N
20	RC/origin-fork-fork	\N	hg	2	f	f	t	RC/origin-fork-fork repository	2013-05-28 20:19:46.738847	2013-05-28 20:19:46.738871	tip	f	\N	\N	1
21	rc_gist/45	\N	hg	2	f	f	t	rc_gist/45 repository	2013-05-28 20:19:46.763345	2013-05-28 20:19:46.763368	tip	f	\N	\N	3
22	rc_gist/44	\N	hg	2	f	f	t	rc_gist/44 repository	2013-05-28 20:19:46.785822	2013-05-28 20:19:46.785845	tip	f	\N	\N	3
23	rc_gist/46	\N	hg	2	f	f	t	rc_gist/46 repository	2013-05-28 20:19:46.810502	2013-05-28 20:19:46.810526	tip	f	\N	\N	3
24	rc_gist/41	\N	hg	2	f	f	t	rc_gist/41 repository	2013-05-28 20:19:46.831198	2013-05-28 20:19:46.831222	tip	f	\N	\N	3
25	rc_gist/40	\N	hg	2	f	f	t	rc_gist/40 repository	2013-05-28 20:19:46.854003	2013-05-28 20:19:46.854027	tip	f	\N	\N	3
26	RC/gogo2	\N	hg	2	f	f	t	RC/gogo2 repository	2013-05-28 20:19:46.875303	2013-05-28 20:19:46.875328	tip	f	\N	\N	1
27	rc_gist/42	\N	hg	2	f	f	t	rc_gist/42 repository	2013-05-28 20:19:46.90018	2013-05-28 20:19:46.900204	tip	f	\N	\N	3
28	rc_gist/49	\N	hg	2	f	f	t	rc_gist/49 repository	2013-05-28 20:19:46.921025	2013-05-28 20:19:46.921048	tip	f	\N	\N	3
29	rc_gist/48	\N	hg	2	f	f	t	rc_gist/48 repository	2013-05-28 20:19:46.943213	2013-05-28 20:19:46.943239	tip	f	\N	\N	3
30	csa-collins	\N	git	2	f	f	t	Unnamed repository; edit this file 'description' to name the repository.\n	2013-05-28 20:19:46.971235	2013-05-28 20:19:46.971268	tip	f	\N	\N	\N
31	rc_gist/54	\N	hg	2	f	f	t	rc_gist/54 repository	2013-05-28 20:19:47.027501	2013-05-28 20:19:47.027544	tip	f	\N	\N	3
32	rc_gist/55	\N	hg	2	f	f	t	rc_gist/55 repository	2013-05-28 20:19:47.050943	2013-05-28 20:19:47.050969	tip	f	\N	\N	3
33	rc_gist/52	\N	hg	2	f	f	t	rc_gist/52 repository	2013-05-28 20:19:47.073536	2013-05-28 20:19:47.073559	tip	f	\N	\N	3
34	rc_gist/53	\N	hg	2	f	f	t	rc_gist/53 repository	2013-05-28 20:19:47.094418	2013-05-28 20:19:47.094443	tip	f	\N	\N	3
35	rc_gist/50	\N	hg	2	f	f	t	rc_gist/50 repository	2013-05-28 20:19:47.116567	2013-05-28 20:19:47.116591	tip	f	\N	\N	3
36	rc_gist/51	\N	hg	2	f	f	t	rc_gist/51 repository	2013-05-28 20:19:47.136888	2013-05-28 20:19:47.136911	tip	f	\N	\N	3
37	rhodecode.bak.1	\N	hg	2	f	f	t	rhodecode.bak.1 repository	2013-05-28 20:19:47.16212	2013-05-28 20:19:47.162142	tip	f	\N	\N	\N
38	BIG/android	\N	git	2	f	f	t	Unnamed repository; edit this file 'description' to name the repository.\n	2013-05-28 20:19:47.198231	2013-05-28 20:19:47.198266	tip	f	\N	\N	5
39	RC/gogo-fork	\N	hg	2	f	f	t	RC/gogo-fork repository	2013-05-28 20:19:47.249438	2013-05-28 20:19:47.24946	tip	f	\N	\N	1
40	RC/mygr/lol	\N	hg	2	f	f	t	RC/mygr/lol repository	2013-05-28 20:19:47.282234	2013-05-28 20:19:47.282267	tip	f	\N	\N	6
41	testrepo-wp	\N	git	2	f	f	t	Unnamed repository; edit this file 'description' to name the repository.\n	2013-05-28 20:19:47.308192	2013-05-28 20:19:47.308216	tip	f	\N	\N	\N
42	RC/hg-repo	\N	hg	2	f	f	t	RC/hg-repo repository	2013-05-28 20:19:47.353158	2013-05-28 20:19:47.353181	tip	f	\N	\N	1
43	testrepo-quick	\N	git	2	f	f	t	Unnamed repository; edit this file 'description' to name the repository.\n	2013-05-28 20:19:47.375672	2013-05-28 20:19:47.375701	tip	f	\N	\N	\N
44	RC/bin-ops	\N	hg	2	f	f	t	RC/bin-ops repository	2013-05-28 20:19:47.42118	2013-05-28 20:19:47.421204	tip	f	\N	\N	1
45	rc_gist/xFvj6dFqqVK5vfsGP8PU	\N	hg	2	f	f	t	rc_gist/xFvj6dFqqVK5vfsGP8PU repository	2013-05-28 20:19:47.44612	2013-05-28 20:19:47.446142	tip	f	\N	\N	3
46	rhodecode-git	\N	git	2	f	f	t	Unnamed repository; edit this file 'description' to name the repository.\n	2013-05-28 20:19:47.477245	2013-05-28 20:19:47.477284	tip	f	\N	\N	\N
47	csa-io	\N	git	2	f	f	t	Unnamed repository; edit this file 'description' to name the repository.\n	2013-05-28 20:19:47.535352	2013-05-28 20:19:47.535377	tip	f	\N	\N	\N
48	RC/qweqwe-fork	\N	hg	2	f	f	t	RC/qweqwe-fork repository	2013-05-28 20:19:47.578105	2013-05-28 20:19:47.578127	tip	f	\N	\N	1
49	csa-libcloud	\N	git	2	f	f	t	Unnamed repository; edit this file 'description' to name the repository.\n	2013-05-28 20:19:47.600812	2013-05-28 20:19:47.600856	tip	f	\N	\N	\N
50	waitress	\N	git	2	f	f	t	Unnamed repository; edit this file 'description' to name the repository.\n	2013-05-28 20:19:47.685314	2013-05-28 20:19:47.685339	tip	f	\N	\N	\N
51	rc_gist/8	\N	hg	2	f	f	t	rc_gist/8 repository	2013-05-28 20:19:47.730031	2013-05-28 20:19:47.730055	tip	f	\N	\N	3
52	rc_gist/9	\N	hg	2	f	f	t	rc_gist/9 repository	2013-05-28 20:19:47.751262	2013-05-28 20:19:47.751285	tip	f	\N	\N	3
53	RC/foobar	\N	hg	2	f	f	t	RC/foobar repository	2013-05-28 20:19:47.772708	2013-05-28 20:19:47.772732	tip	f	\N	\N	1
54	rc_gist/1	\N	hg	2	f	f	t	rc_gist/1 repository	2013-05-28 20:19:47.7954	2013-05-28 20:19:47.795424	tip	f	\N	\N	3
55	rc_gist/3	\N	hg	2	f	f	t	rc_gist/3 repository	2013-05-28 20:19:47.816017	2013-05-28 20:19:47.81604	tip	f	\N	\N	3
56	rc_gist/4	\N	hg	2	f	f	t	rc_gist/4 repository	2013-05-28 20:19:47.840819	2013-05-28 20:19:47.840841	tip	f	\N	\N	3
57	rc_gist/5	\N	hg	2	f	f	t	rc_gist/5 repository	2013-05-28 20:19:47.86283	2013-05-28 20:19:47.862854	tip	f	\N	\N	3
58	rc_gist/6	\N	hg	2	f	f	t	rc_gist/6 repository	2013-05-28 20:19:47.885803	2013-05-28 20:19:47.885827	tip	f	\N	\N	3
59	rc_gist/7	\N	hg	2	f	f	t	rc_gist/7 repository	2013-05-28 20:19:47.906892	2013-05-28 20:19:47.906917	tip	f	\N	\N	3
60	csa-harmony	\N	git	2	f	f	t	Unnamed repository; edit this file 'description' to name the repository.\n	2013-05-28 20:19:47.93115	2013-05-28 20:19:47.931176	tip	f	\N	\N	\N
61	rhodecode-extensions	\N	hg	2	f	f	t	rhodecode-extensions repository	2013-05-28 20:19:47.98251	2013-05-28 20:19:47.982541	tip	f	\N	\N	\N
62	csa-prometheus	\N	git	2	f	f	t	Unnamed repository; edit this file 'description' to name the repository.\n	2013-05-28 20:19:48.01428	2013-05-28 20:19:48.014303	tip	f	\N	\N	\N
63	RC/empty-git	\N	git	2	f	f	t	Unnamed repository; edit this file 'description' to name the repository.\n	2013-05-28 20:19:48.062792	2013-05-28 20:19:48.062814	tip	f	\N	\N	1
64	csa-salt-states	\N	git	2	f	f	t	Unnamed repository; edit this file 'description' to name the repository.\n	2013-05-28 20:19:48.108636	2013-05-28 20:19:48.108661	tip	f	\N	\N	\N
65	RC/łęcina	\N	hg	2	f	f	t	RC/łęcina repository	2013-05-28 20:19:48.154998	2013-05-28 20:19:48.155023	tip	f	\N	\N	1
66	rhodecode-premium	\N	hg	2	f	f	t	rhodecode-premium repository	2013-05-28 20:19:48.176652	2013-05-28 20:19:48.17668	tip	f	\N	\N	\N
67	RC/qweqwe-fork2	\N	hg	2	f	f	t	RC/qweqwe-fork2 repository	2013-05-28 20:19:48.198005	2013-05-28 20:19:48.198028	tip	f	\N	\N	1
68	RC/INRC/L2_NEW/lalalal	\N	hg	2	f	f	t	RC/INRC/L2_NEW/lalalal repository	2013-05-28 20:19:48.235645	2013-05-28 20:19:48.235669	tip	f	\N	\N	7
69	RC/INRC/L2_NEW/L3/repo_test_move	\N	hg	2	f	f	t	RC/INRC/L2_NEW/L3/repo_test_move repository	2013-05-28 20:19:48.270928	2013-05-28 20:19:48.27095	tip	f	\N	\N	8
70	rhodecode.bak	\N	hg	2	f	f	t	rhodecode.bak repository	2013-05-28 20:19:48.289771	2013-05-28 20:19:48.289794	tip	f	\N	\N	\N
71	RC/jap	\N	git	2	f	f	t	Unnamed repository; edit this file 'description' to name the repository.\n	2013-05-28 20:19:48.315557	2013-05-28 20:19:48.315581	tip	f	\N	\N	1
72	RC/origin	\N	hg	2	f	f	t	RC/origin repository	2013-05-28 20:19:48.361233	2013-05-28 20:19:48.361257	tip	f	\N	\N	1
73	rhodecode-cli-api	\N	hg	2	f	f	t	rhodecode-cli-api repository	2013-05-28 20:19:48.380668	2013-05-28 20:19:48.380694	tip	f	\N	\N	\N
74	csa-armstrong	\N	git	2	f	f	t	Unnamed repository; edit this file 'description' to name the repository.\n	2013-05-28 20:19:48.415666	2013-05-28 20:19:48.41569	tip	f	\N	\N	\N
75	rc_gist/NAsB8cacjxnqdyZ8QUl3	\N	hg	2	f	f	t	rc_gist/NAsB8cacjxnqdyZ8QUl3 repository	2013-05-28 20:19:48.464189	2013-05-28 20:19:48.464241	tip	f	\N	\N	3
76	RC/lol/haha	\N	hg	2	f	f	t	RC/lol/haha repository	2013-05-28 20:19:48.523514	2013-05-28 20:19:48.523544	tip	f	\N	\N	9
77	enc-envelope	\N	hg	2	f	f	t	enc-envelope repository	2013-05-28 20:19:48.556295	2013-05-28 20:19:48.556333	tip	f	\N	\N	\N
78	rc_gist/43	\N	hg	2	f	f	t	rc_gist/43 repository	2013-05-28 20:19:48.58417	2013-05-28 20:19:48.584196	tip	f	\N	\N	3
79	RC/test	\N	hg	2	f	f	t	RC/test repository	2013-05-28 20:19:48.609009	2013-05-28 20:19:48.609036	tip	f	\N	\N	1
80	BIG/git	\N	git	2	f	f	t	Unnamed repository; edit this file 'description' to name the repository.\n	2013-05-28 20:19:48.634082	2013-05-28 20:19:48.634105	tip	f	\N	\N	5
81	RC/origin-fork	\N	hg	2	f	f	t	RC/origin-fork repository	2013-05-28 20:19:48.686725	2013-05-28 20:19:48.686747	tip	f	\N	\N	1
82	RC/trololo	\N	hg	2	f	f	t	RC/trololo repository	2013-05-28 20:19:48.715102	2013-05-28 20:19:48.715132	tip	f	\N	\N	1
83	rc_gist/FLj8GunafFAVBnuTWDxU	\N	hg	2	f	f	t	rc_gist/FLj8GunafFAVBnuTWDxU repository	2013-05-28 20:19:48.747675	2013-05-28 20:19:48.74771	tip	f	\N	\N	3
84	csa-unity	\N	git	2	f	f	t	Unnamed repository; edit this file 'description' to name the repository.\n	2013-05-28 20:19:48.781008	2013-05-28 20:19:48.781035	tip	f	\N	\N	\N
85	RC/vcs-git	\N	git	2	f	f	t	Unnamed repository; edit this file 'description' to name the repository.\n	2013-05-28 20:19:48.835086	2013-05-28 20:19:48.835109	tip	f	\N	\N	1
86	rc_gist/12	\N	hg	2	f	f	t	rc_gist/12 repository	2013-05-28 20:19:48.893392	2013-05-28 20:19:48.893422	tip	f	\N	\N	3
87	rc_gist/13	\N	hg	2	f	f	t	rc_gist/13 repository	2013-05-28 20:19:48.917374	2013-05-28 20:19:48.917398	tip	f	\N	\N	3
88	rc_gist/10	\N	hg	2	f	f	t	rc_gist/10 repository	2013-05-28 20:19:48.940824	2013-05-28 20:19:48.94085	tip	f	\N	\N	3
89	rc_gist/11	\N	hg	2	f	f	t	rc_gist/11 repository	2013-05-28 20:19:48.97297	2013-05-28 20:19:48.973	tip	f	\N	\N	3
90	RC/kiall-nova	\N	git	2	f	f	t	Unnamed repository; edit this file 'description' to name the repository.\n	2013-05-28 20:19:49.009005	2013-05-28 20:19:49.009032	tip	f	\N	\N	1
91	RC/rc2/test	\N	hg	2	f	f	t	RC/rc2/test repository	2013-05-28 20:19:49.062753	2013-05-28 20:19:49.062777	tip	f	\N	\N	2
92	DOCS	\N	git	2	f	f	t	Unnamed repository; edit this file 'description' to name the repository.\n	2013-05-28 20:19:49.087857	2013-05-28 20:19:49.087881	tip	f	\N	\N	\N
93	RC/fork-remote	\N	hg	2	f	f	t	RC/fork-remote repository	2013-05-28 20:19:49.133406	2013-05-28 20:19:49.133432	tip	f	\N	\N	1
94	RC/git-pull-test	\N	git	2	f	f	t	Unnamed repository; edit this file 'description' to name the repository.\n	2013-05-28 20:19:49.157471	2013-05-28 20:19:49.157508	tip	f	\N	\N	1
95	pyramidpypi	\N	git	2	f	f	t	Unnamed repository; edit this file 'description' to name the repository.\n	2013-05-28 20:19:49.216696	2013-05-28 20:19:49.216733	tip	f	\N	\N	\N
96	rc_gist/aQpbufbhSac6FyvVHhmS	\N	hg	2	f	f	t	rc_gist/aQpbufbhSac6FyvVHhmS repository	2013-05-28 20:19:49.266672	2013-05-28 20:19:49.2667	tip	f	\N	\N	3
97	csa-aldrin	\N	git	2	f	f	t	Unnamed repository; edit this file 'description' to name the repository.\n	2013-05-28 20:19:49.291319	2013-05-28 20:19:49.291353	tip	f	\N	\N	\N
98	RC/ąqweqwe	\N	hg	2	f	f	t	RC/ąqweqwe repository	2013-05-28 20:19:49.340516	2013-05-28 20:19:49.340539	tip	f	\N	\N	1
99	rc_gist/QL2GhrlKymNmrUJJy5js	\N	hg	2	f	f	t	rc_gist/QL2GhrlKymNmrUJJy5js repository	2013-05-28 20:19:49.36452	2013-05-28 20:19:49.364547	tip	f	\N	\N	3
100	RC/git-test	\N	git	2	f	f	t	Unnamed repository	2013-05-28 20:19:49.393521	2013-05-28 20:19:49.393548	tip	f	\N	\N	1
101	salt	\N	git	2	f	f	t	Unnamed repository; edit this file 'description' to name the repository.\n	2013-05-28 20:19:49.44733	2013-05-28 20:19:49.447355	tip	f	\N	\N	\N
\.


--
-- Name: repositories_repo_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('repositories_repo_id_seq', 101, 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	
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	
\.


--
-- Name: rhodecode_settings_app_settings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('rhodecode_settings_app_settings_id_seq', 20, 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:19:46.068609
2	2	2	\N	2013-05-28 20:19:46.126742
3	2	3	\N	2013-05-28 20:19:46.147054
4	2	4	\N	2013-05-28 20:19:46.213476
5	2	5	\N	2013-05-28 20:19:46.268777
6	2	6	\N	2013-05-28 20:19:46.322156
7	2	7	\N	2013-05-28 20:19:46.343256
8	2	8	\N	2013-05-28 20:19:46.395212
9	2	9	\N	2013-05-28 20:19:46.420661
10	2	10	\N	2013-05-28 20:19:46.451956
11	2	11	\N	2013-05-28 20:19:46.484107
12	2	12	\N	2013-05-28 20:19:46.510375
13	2	13	\N	2013-05-28 20:19:46.53353
14	2	14	\N	2013-05-28 20:19:46.557944
15	2	15	\N	2013-05-28 20:19:46.606327
16	2	16	\N	2013-05-28 20:19:46.642731
17	2	17	\N	2013-05-28 20:19:46.661205
18	2	18	\N	2013-05-28 20:19:46.710005
19	2	19	\N	2013-05-28 20:19:46.729946
20	2	20	\N	2013-05-28 20:19:46.752531
21	2	21	\N	2013-05-28 20:19:46.776886
22	2	22	\N	2013-05-28 20:19:46.801248
23	2	23	\N	2013-05-28 20:19:46.822563
24	2	24	\N	2013-05-28 20:19:46.845405
25	2	25	\N	2013-05-28 20:19:46.866146
26	2	26	\N	2013-05-28 20:19:46.891708
27	2	27	\N	2013-05-28 20:19:46.912589
28	2	28	\N	2013-05-28 20:19:46.934387
29	2	29	\N	2013-05-28 20:19:46.955575
30	2	30	\N	2013-05-28 20:19:47.0168
31	2	31	\N	2013-05-28 20:19:47.040684
32	2	32	\N	2013-05-28 20:19:47.063573
33	2	33	\N	2013-05-28 20:19:47.085898
34	2	34	\N	2013-05-28 20:19:47.10634
35	2	35	\N	2013-05-28 20:19:47.128293
36	2	36	\N	2013-05-28 20:19:47.151701
37	2	37	\N	2013-05-28 20:19:47.174067
38	2	38	\N	2013-05-28 20:19:47.235231
39	2	39	\N	2013-05-28 20:19:47.261671
40	2	40	\N	2013-05-28 20:19:47.297526
41	2	41	\N	2013-05-28 20:19:47.344301
42	2	42	\N	2013-05-28 20:19:47.364906
43	2	43	\N	2013-05-28 20:19:47.412273
44	2	44	\N	2013-05-28 20:19:47.437251
45	2	45	\N	2013-05-28 20:19:47.4616
46	2	46	\N	2013-05-28 20:19:47.525929
47	2	47	\N	2013-05-28 20:19:47.569847
48	2	48	\N	2013-05-28 20:19:47.591066
49	2	49	\N	2013-05-28 20:19:47.636599
50	2	50	\N	2013-05-28 20:19:47.721273
51	2	51	\N	2013-05-28 20:19:47.742706
52	2	52	\N	2013-05-28 20:19:47.763578
53	2	53	\N	2013-05-28 20:19:47.786723
54	2	54	\N	2013-05-28 20:19:47.806992
55	2	55	\N	2013-05-28 20:19:47.832521
56	2	56	\N	2013-05-28 20:19:47.854374
57	2	57	\N	2013-05-28 20:19:47.876909
58	2	58	\N	2013-05-28 20:19:47.897876
59	2	59	\N	2013-05-28 20:19:47.920242
60	2	60	\N	2013-05-28 20:19:47.971649
61	2	61	\N	2013-05-28 20:19:48.001881
62	2	62	\N	2013-05-28 20:19:48.052068
63	2	63	\N	2013-05-28 20:19:48.099443
64	2	64	\N	2013-05-28 20:19:48.145784
65	2	65	\N	2013-05-28 20:19:48.167391
66	2	66	\N	2013-05-28 20:19:48.189143
67	2	67	\N	2013-05-28 20:19:48.211778
68	2	68	\N	2013-05-28 20:19:48.24747
69	2	69	\N	2013-05-28 20:19:48.282577
70	2	70	\N	2013-05-28 20:19:48.303227
71	2	71	\N	2013-05-28 20:19:48.351707
72	2	72	\N	2013-05-28 20:19:48.373519
73	2	73	\N	2013-05-28 20:19:48.404984
74	2	74	\N	2013-05-28 20:19:48.450431
75	2	75	\N	2013-05-28 20:19:48.485354
76	2	76	\N	2013-05-28 20:19:48.543067
77	2	77	\N	2013-05-28 20:19:48.571906
78	2	78	\N	2013-05-28 20:19:48.599293
79	2	79	\N	2013-05-28 20:19:48.622407
80	2	80	\N	2013-05-28 20:19:48.67569
81	2	81	\N	2013-05-28 20:19:48.699443
82	2	82	\N	2013-05-28 20:19:48.734442
83	2	83	\N	2013-05-28 20:19:48.768314
84	2	84	\N	2013-05-28 20:19:48.821613
85	2	85	\N	2013-05-28 20:19:48.882902
86	2	86	\N	2013-05-28 20:19:48.906216
87	2	87	\N	2013-05-28 20:19:48.929819
88	2	88	\N	2013-05-28 20:19:48.956595
89	2	89	\N	2013-05-28 20:19:48.992037
90	2	90	\N	2013-05-28 20:19:49.052422
91	2	91	\N	2013-05-28 20:19:49.076845
92	2	92	\N	2013-05-28 20:19:49.123624
93	2	93	\N	2013-05-28 20:19:49.145816
94	2	94	\N	2013-05-28 20:19:49.201878
95	2	95	\N	2013-05-28 20:19:49.255729
96	2	96	\N	2013-05-28 20:19:49.279708
97	2	97	\N	2013-05-28 20:19:49.327966
98	2	98	\N	2013-05-28 20:19:49.355807
99	2	99	\N	2013-05-28 20:19:49.379948
100	2	100	\N	2013-05-28 20:19:49.437281
101	2	101	\N	2013-05-28 20:19:49.498065
\.


--
-- Name: user_followings_user_following_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('user_followings_user_following_id_seq', 101, true);


--
-- Data for Name: user_logs; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY user_logs (user_log_id, user_id, repository_id, repository_name, user_ip, action, action_date) FROM stdin;
1	2	1	RC/fakeclone		started_following_repo	2013-05-28 20:19:46.06345
2	2	2	RC/muay		started_following_repo	2013-05-28 20:19:46.124201
3	2	3	one		started_following_repo	2013-05-28 20:19:46.144023
4	2	4	RC/rc2/test2		started_following_repo	2013-05-28 20:19:46.183325
5	2	5	RC/rc2/test3		started_following_repo	2013-05-28 20:19:46.238781
6	2	6	RC/rc2/test4		started_following_repo	2013-05-28 20:19:46.292145
7	2	7	rhodecode-cli-gist		started_following_repo	2013-05-28 20:19:46.340854
8	2	8	test.onaut.com		started_following_repo	2013-05-28 20:19:46.364293
9	2	9	RC/new		started_following_repo	2013-05-28 20:19:46.418203
10	2	10	rc_gist/32		started_following_repo	2013-05-28 20:19:46.449509
11	2	11	vcs		started_following_repo	2013-05-28 20:19:46.480962
12	2	12	rc_gist/36		started_following_repo	2013-05-28 20:19:46.507782
13	2	13	rc_gist/37		started_following_repo	2013-05-28 20:19:46.530376
14	2	14	rc_gist/39		started_following_repo	2013-05-28 20:19:46.555564
15	2	15	remote-salt		started_following_repo	2013-05-28 20:19:46.581784
16	2	16	RC/INRC/trololo		started_following_repo	2013-05-28 20:19:46.640239
17	2	17	quest		started_following_repo	2013-05-28 20:19:46.658865
18	2	18	csa-hyperion		started_following_repo	2013-05-28 20:19:46.685236
19	2	19	rhodecode		started_following_repo	2013-05-28 20:19:46.727476
20	2	20	RC/origin-fork-fork		started_following_repo	2013-05-28 20:19:46.749515
21	2	21	rc_gist/45		started_following_repo	2013-05-28 20:19:46.774465
22	2	22	rc_gist/44		started_following_repo	2013-05-28 20:19:46.798226
23	2	23	rc_gist/46		started_following_repo	2013-05-28 20:19:46.820131
24	2	24	rc_gist/41		started_following_repo	2013-05-28 20:19:46.843096
25	2	25	rc_gist/40		started_following_repo	2013-05-28 20:19:46.863481
26	2	26	RC/gogo2		started_following_repo	2013-05-28 20:19:46.889163
27	2	27	rc_gist/42		started_following_repo	2013-05-28 20:19:46.910218
28	2	28	rc_gist/49		started_following_repo	2013-05-28 20:19:46.932045
29	2	29	rc_gist/48		started_following_repo	2013-05-28 20:19:46.953051
30	2	30	csa-collins		started_following_repo	2013-05-28 20:19:46.98622
31	2	31	rc_gist/54		started_following_repo	2013-05-28 20:19:47.038223
32	2	32	rc_gist/55		started_following_repo	2013-05-28 20:19:47.060774
33	2	33	rc_gist/52		started_following_repo	2013-05-28 20:19:47.083498
34	2	34	rc_gist/53		started_following_repo	2013-05-28 20:19:47.103903
35	2	35	rc_gist/50		started_following_repo	2013-05-28 20:19:47.125837
36	2	36	rc_gist/51		started_following_repo	2013-05-28 20:19:47.148328
37	2	37	rhodecode.bak.1		started_following_repo	2013-05-28 20:19:47.171696
38	2	38	BIG/android		started_following_repo	2013-05-28 20:19:47.209124
39	2	39	RC/gogo-fork		started_following_repo	2013-05-28 20:19:47.259188
40	2	40	RC/mygr/lol		started_following_repo	2013-05-28 20:19:47.295185
41	2	41	testrepo-wp		started_following_repo	2013-05-28 20:19:47.317898
42	2	42	RC/hg-repo		started_following_repo	2013-05-28 20:19:47.362609
43	2	43	testrepo-quick		started_following_repo	2013-05-28 20:19:47.387878
44	2	44	RC/bin-ops		started_following_repo	2013-05-28 20:19:47.434723
45	2	45	rc_gist/xFvj6dFqqVK5vfsGP8PU		started_following_repo	2013-05-28 20:19:47.457194
46	2	46	rhodecode-git		started_following_repo	2013-05-28 20:19:47.492079
47	2	47	csa-io		started_following_repo	2013-05-28 20:19:47.544724
48	2	48	RC/qweqwe-fork		started_following_repo	2013-05-28 20:19:47.588558
49	2	49	csa-libcloud		started_following_repo	2013-05-28 20:19:47.612633
50	2	50	waitress		started_following_repo	2013-05-28 20:19:47.695147
51	2	51	rc_gist/8		started_following_repo	2013-05-28 20:19:47.740409
52	2	52	rc_gist/9		started_following_repo	2013-05-28 20:19:47.760966
53	2	53	RC/foobar		started_following_repo	2013-05-28 20:19:47.784301
54	2	54	rc_gist/1		started_following_repo	2013-05-28 20:19:47.804641
55	2	55	rc_gist/3		started_following_repo	2013-05-28 20:19:47.830277
56	2	56	rc_gist/4		started_following_repo	2013-05-28 20:19:47.851913
57	2	57	rc_gist/5		started_following_repo	2013-05-28 20:19:47.874467
58	2	58	rc_gist/6		started_following_repo	2013-05-28 20:19:47.895581
59	2	59	rc_gist/7		started_following_repo	2013-05-28 20:19:47.917912
60	2	60	csa-harmony		started_following_repo	2013-05-28 20:19:47.941389
61	2	61	rhodecode-extensions		started_following_repo	2013-05-28 20:19:47.998531
62	2	62	csa-prometheus		started_following_repo	2013-05-28 20:19:48.024655
63	2	63	RC/empty-git		started_following_repo	2013-05-28 20:19:48.072925
64	2	64	csa-salt-states		started_following_repo	2013-05-28 20:19:48.119876
65	2	65	RC/łęcina		started_following_repo	2013-05-28 20:19:48.164852
66	2	66	rhodecode-premium		started_following_repo	2013-05-28 20:19:48.186836
67	2	67	RC/qweqwe-fork2		started_following_repo	2013-05-28 20:19:48.208735
68	2	68	RC/INRC/L2_NEW/lalalal		started_following_repo	2013-05-28 20:19:48.245171
69	2	69	RC/INRC/L2_NEW/L3/repo_test_move		started_following_repo	2013-05-28 20:19:48.280102
70	2	70	rhodecode.bak		started_following_repo	2013-05-28 20:19:48.300852
71	2	71	RC/jap		started_following_repo	2013-05-28 20:19:48.325071
72	2	72	RC/origin		started_following_repo	2013-05-28 20:19:48.37108
73	2	73	rhodecode-cli-api		started_following_repo	2013-05-28 20:19:48.402627
74	2	74	csa-armstrong		started_following_repo	2013-05-28 20:19:48.425969
75	2	75	rc_gist/NAsB8cacjxnqdyZ8QUl3		started_following_repo	2013-05-28 20:19:48.482094
76	2	76	RC/lol/haha		started_following_repo	2013-05-28 20:19:48.539291
77	2	77	enc-envelope		started_following_repo	2013-05-28 20:19:48.568444
78	2	78	rc_gist/43		started_following_repo	2013-05-28 20:19:48.596804
79	2	79	RC/test		started_following_repo	2013-05-28 20:19:48.619757
80	2	80	BIG/git		started_following_repo	2013-05-28 20:19:48.647018
81	2	81	RC/origin-fork		started_following_repo	2013-05-28 20:19:48.696698
82	2	82	RC/trololo		started_following_repo	2013-05-28 20:19:48.731089
83	2	83	rc_gist/FLj8GunafFAVBnuTWDxU		started_following_repo	2013-05-28 20:19:48.765206
84	2	84	csa-unity		started_following_repo	2013-05-28 20:19:48.793189
85	2	85	RC/vcs-git		started_following_repo	2013-05-28 20:19:48.846115
86	2	86	rc_gist/12		started_following_repo	2013-05-28 20:19:48.903713
87	2	87	rc_gist/13		started_following_repo	2013-05-28 20:19:48.926737
88	2	88	rc_gist/10		started_following_repo	2013-05-28 20:19:48.953085
89	2	89	rc_gist/11		started_following_repo	2013-05-28 20:19:48.988513
90	2	90	RC/kiall-nova		started_following_repo	2013-05-28 20:19:49.022101
91	2	91	RC/rc2/test		started_following_repo	2013-05-28 20:19:49.073863
92	2	92	DOCS		started_following_repo	2013-05-28 20:19:49.097898
93	2	93	RC/fork-remote		started_following_repo	2013-05-28 20:19:49.143406
94	2	94	RC/git-pull-test		started_following_repo	2013-05-28 20:19:49.169824
95	2	95	pyramidpypi		started_following_repo	2013-05-28 20:19:49.226862
96	2	96	rc_gist/aQpbufbhSac6FyvVHhmS		started_following_repo	2013-05-28 20:19:49.2771
97	2	97	csa-aldrin		started_following_repo	2013-05-28 20:19:49.301235
98	2	98	RC/ąqweqwe		started_following_repo	2013-05-28 20:19:49.353131
99	2	99	rc_gist/QL2GhrlKymNmrUJJy5js		started_following_repo	2013-05-28 20:19:49.376769
100	2	100	RC/git-test		started_following_repo	2013-05-28 20:19:49.405255
101	2	101	salt		started_following_repo	2013-05-28 20:19:49.462231
\.


--
-- Name: user_logs_user_log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('user_logs_user_log_id_seq', 101, 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
9	1	9	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', 9, 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
\.


--
-- 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', 4, 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$nv5rCK16FTMWwsfp7vST0.yuHJ/spZcw4VqZ9Bl5Y5fNXxdHwi6Jm	t	f	Anonymous	User	[e-mail]	\N	\N	3bde4a66f98734dcc824fbfd4bfb0f0813921c34	t
2	marcink	$2a$10$MNNSVrDOaAwM6FJuuPdfA.TKywm4X4prOFndPE.KamfwRTTmS42ze	t	t	RhodeCode	Admin	[e-mail]	\N	\N	08cac6e1607032b6a712c657a70b829b91c41fbe	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_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_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_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_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
--