--
-- PostgreSQL database dump
--

-- Dumped from database version 9.1.0
-- Dumped by pg_dump version 9.1.0
-- Started on 2012-06-08 02:32:27 CEST

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- TOC entry 240 (class 3079 OID 11906)
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- TOC entry 2636 (class 0 OID 0)
-- Dependencies: 240
-- 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;

--
-- TOC entry 166 (class 1259 OID 120002)
-- Dependencies: 6
-- Name: auth_group; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE auth_group (
    id integer NOT NULL,
    name character varying(80) NOT NULL
);


ALTER TABLE public.auth_group OWNER TO iri;

--
-- TOC entry 165 (class 1259 OID 120000)
-- Dependencies: 166 6
-- Name: auth_group_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE auth_group_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.auth_group_id_seq OWNER TO iri;

--
-- TOC entry 2637 (class 0 OID 0)
-- Dependencies: 165
-- Name: auth_group_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE auth_group_id_seq OWNED BY auth_group.id;


--
-- TOC entry 2638 (class 0 OID 0)
-- Dependencies: 165
-- Name: auth_group_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('auth_group_id_seq', 1, true);


--
-- TOC entry 164 (class 1259 OID 119987)
-- Dependencies: 6
-- Name: auth_group_permissions; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE auth_group_permissions (
    id integer NOT NULL,
    group_id integer NOT NULL,
    permission_id integer NOT NULL
);


ALTER TABLE public.auth_group_permissions OWNER TO iri;

--
-- TOC entry 163 (class 1259 OID 119985)
-- Dependencies: 164 6
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE auth_group_permissions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.auth_group_permissions_id_seq OWNER TO iri;

--
-- TOC entry 2639 (class 0 OID 0)
-- Dependencies: 163
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE auth_group_permissions_id_seq OWNED BY auth_group_permissions.id;


--
-- TOC entry 2640 (class 0 OID 0)
-- Dependencies: 163
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('auth_group_permissions_id_seq', 1, false);


--
-- TOC entry 162 (class 1259 OID 119977)
-- Dependencies: 6
-- Name: auth_permission; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE auth_permission (
    id integer NOT NULL,
    name character varying(50) NOT NULL,
    content_type_id integer NOT NULL,
    codename character varying(100) NOT NULL
);


ALTER TABLE public.auth_permission OWNER TO iri;

--
-- TOC entry 161 (class 1259 OID 119975)
-- Dependencies: 6 162
-- Name: auth_permission_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE auth_permission_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.auth_permission_id_seq OWNER TO iri;

--
-- TOC entry 2641 (class 0 OID 0)
-- Dependencies: 161
-- Name: auth_permission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE auth_permission_id_seq OWNED BY auth_permission.id;


--
-- TOC entry 2642 (class 0 OID 0)
-- Dependencies: 161
-- Name: auth_permission_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('auth_permission_id_seq', 114, true);


--
-- TOC entry 172 (class 1259 OID 120047)
-- Dependencies: 6
-- Name: auth_user; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE auth_user (
    id integer NOT NULL,
    username character varying(30) NOT NULL,
    first_name character varying(30) NOT NULL,
    last_name character varying(30) NOT NULL,
    email character varying(75) NOT NULL,
    password character varying(128) NOT NULL,
    is_staff boolean NOT NULL,
    is_active boolean NOT NULL,
    is_superuser boolean NOT NULL,
    last_login timestamp with time zone NOT NULL,
    date_joined timestamp with time zone NOT NULL
);


ALTER TABLE public.auth_user OWNER TO iri;

--
-- TOC entry 170 (class 1259 OID 120032)
-- Dependencies: 6
-- Name: auth_user_groups; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE auth_user_groups (
    id integer NOT NULL,
    user_id integer NOT NULL,
    group_id integer NOT NULL
);


ALTER TABLE public.auth_user_groups OWNER TO iri;

--
-- TOC entry 169 (class 1259 OID 120030)
-- Dependencies: 170 6
-- Name: auth_user_groups_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE auth_user_groups_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.auth_user_groups_id_seq OWNER TO iri;

--
-- TOC entry 2643 (class 0 OID 0)
-- Dependencies: 169
-- Name: auth_user_groups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE auth_user_groups_id_seq OWNED BY auth_user_groups.id;


--
-- TOC entry 2644 (class 0 OID 0)
-- Dependencies: 169
-- Name: auth_user_groups_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('auth_user_groups_id_seq', 2, true);


--
-- TOC entry 171 (class 1259 OID 120045)
-- Dependencies: 172 6
-- Name: auth_user_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE auth_user_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.auth_user_id_seq OWNER TO iri;

--
-- TOC entry 2645 (class 0 OID 0)
-- Dependencies: 171
-- Name: auth_user_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE auth_user_id_seq OWNED BY auth_user.id;


--
-- TOC entry 2646 (class 0 OID 0)
-- Dependencies: 171
-- Name: auth_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('auth_user_id_seq', 1, true);


--
-- TOC entry 168 (class 1259 OID 120017)
-- Dependencies: 6
-- Name: auth_user_user_permissions; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE auth_user_user_permissions (
    id integer NOT NULL,
    user_id integer NOT NULL,
    permission_id integer NOT NULL
);


ALTER TABLE public.auth_user_user_permissions OWNER TO iri;

--
-- TOC entry 167 (class 1259 OID 120015)
-- Dependencies: 6 168
-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE auth_user_user_permissions_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.auth_user_user_permissions_id_seq OWNER TO iri;

--
-- TOC entry 2647 (class 0 OID 0)
-- Dependencies: 167
-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE auth_user_user_permissions_id_seq OWNED BY auth_user_user_permissions.id;


--
-- TOC entry 2648 (class 0 OID 0)
-- Dependencies: 167
-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('auth_user_user_permissions_id_seq', 1, false);


--
-- TOC entry 179 (class 1259 OID 120098)
-- Dependencies: 2337 6
-- Name: django_admin_log; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE django_admin_log (
    id integer NOT NULL,
    action_time timestamp with time zone NOT NULL,
    user_id integer NOT NULL,
    content_type_id integer,
    object_id text,
    object_repr character varying(200) NOT NULL,
    action_flag smallint NOT NULL,
    change_message text NOT NULL,
    CONSTRAINT django_admin_log_action_flag_check CHECK ((action_flag >= 0))
);


ALTER TABLE public.django_admin_log OWNER TO iri;

--
-- TOC entry 178 (class 1259 OID 120096)
-- Dependencies: 6 179
-- Name: django_admin_log_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE django_admin_log_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.django_admin_log_id_seq OWNER TO iri;

--
-- TOC entry 2649 (class 0 OID 0)
-- Dependencies: 178
-- Name: django_admin_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE django_admin_log_id_seq OWNED BY django_admin_log.id;


--
-- TOC entry 2650 (class 0 OID 0)
-- Dependencies: 178
-- Name: django_admin_log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('django_admin_log_id_seq', 7, true);


--
-- TOC entry 174 (class 1259 OID 120067)
-- Dependencies: 6
-- Name: django_content_type; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE django_content_type (
    id integer NOT NULL,
    name character varying(100) NOT NULL,
    app_label character varying(100) NOT NULL,
    model character varying(100) NOT NULL
);


ALTER TABLE public.django_content_type OWNER TO iri;

--
-- TOC entry 173 (class 1259 OID 120065)
-- Dependencies: 174 6
-- Name: django_content_type_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE django_content_type_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.django_content_type_id_seq OWNER TO iri;

--
-- TOC entry 2651 (class 0 OID 0)
-- Dependencies: 173
-- Name: django_content_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE django_content_type_id_seq OWNED BY django_content_type.id;


--
-- TOC entry 2652 (class 0 OID 0)
-- Dependencies: 173
-- Name: django_content_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('django_content_type_id_seq', 36, true);


--
-- TOC entry 197 (class 1259 OID 120238)
-- Dependencies: 6
-- Name: django_openid_consumer_association; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE django_openid_consumer_association (
    id integer NOT NULL,
    server_url text NOT NULL,
    handle character varying(255) NOT NULL,
    secret text NOT NULL,
    issued integer NOT NULL,
    lifetime integer NOT NULL,
    assoc_type text NOT NULL
);


ALTER TABLE public.django_openid_consumer_association OWNER TO iri;

--
-- TOC entry 196 (class 1259 OID 120236)
-- Dependencies: 197 6
-- Name: django_openid_consumer_association_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE django_openid_consumer_association_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.django_openid_consumer_association_id_seq OWNER TO iri;

--
-- TOC entry 2653 (class 0 OID 0)
-- Dependencies: 196
-- Name: django_openid_consumer_association_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE django_openid_consumer_association_id_seq OWNED BY django_openid_consumer_association.id;


--
-- TOC entry 2654 (class 0 OID 0)
-- Dependencies: 196
-- Name: django_openid_consumer_association_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('django_openid_consumer_association_id_seq', 1, false);


--
-- TOC entry 195 (class 1259 OID 120230)
-- Dependencies: 6
-- Name: django_openid_consumer_nonce; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE django_openid_consumer_nonce (
    id integer NOT NULL,
    server_url character varying(200) NOT NULL,
    "timestamp" integer NOT NULL,
    salt character varying(50) NOT NULL
);


ALTER TABLE public.django_openid_consumer_nonce OWNER TO iri;

--
-- TOC entry 194 (class 1259 OID 120228)
-- Dependencies: 6 195
-- Name: django_openid_consumer_nonce_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE django_openid_consumer_nonce_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.django_openid_consumer_nonce_id_seq OWNER TO iri;

--
-- TOC entry 2655 (class 0 OID 0)
-- Dependencies: 194
-- Name: django_openid_consumer_nonce_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE django_openid_consumer_nonce_id_seq OWNED BY django_openid_consumer_nonce.id;


--
-- TOC entry 2656 (class 0 OID 0)
-- Dependencies: 194
-- Name: django_openid_consumer_nonce_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('django_openid_consumer_nonce_id_seq', 1, false);


--
-- TOC entry 175 (class 1259 OID 120080)
-- Dependencies: 6
-- Name: django_session; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE django_session (
    session_key character varying(40) NOT NULL,
    session_data text NOT NULL,
    expire_date timestamp with time zone NOT NULL
);


ALTER TABLE public.django_session OWNER TO iri;

--
-- TOC entry 177 (class 1259 OID 120090)
-- Dependencies: 6
-- Name: django_site; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE django_site (
    id integer NOT NULL,
    domain character varying(100) NOT NULL,
    name character varying(50) NOT NULL
);


ALTER TABLE public.django_site OWNER TO iri;

--
-- TOC entry 176 (class 1259 OID 120088)
-- Dependencies: 177 6
-- Name: django_site_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE django_site_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.django_site_id_seq OWNER TO iri;

--
-- TOC entry 2657 (class 0 OID 0)
-- Dependencies: 176
-- Name: django_site_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE django_site_id_seq OWNED BY django_site.id;


--
-- TOC entry 2658 (class 0 OID 0)
-- Dependencies: 176
-- Name: django_site_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('django_site_id_seq', 1, true);


--
-- TOC entry 235 (class 1259 OID 120649)
-- Dependencies: 6
-- Name: guardian_groupobjectpermission; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE guardian_groupobjectpermission (
    id integer NOT NULL,
    permission_id integer NOT NULL,
    content_type_id integer NOT NULL,
    group_id integer NOT NULL,
    object_pk character varying(255) NOT NULL
);


ALTER TABLE public.guardian_groupobjectpermission OWNER TO iri;

--
-- TOC entry 234 (class 1259 OID 120647)
-- Dependencies: 235 6
-- Name: guardian_groupobjectpermission_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE guardian_groupobjectpermission_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.guardian_groupobjectpermission_id_seq OWNER TO iri;

--
-- TOC entry 2659 (class 0 OID 0)
-- Dependencies: 234
-- Name: guardian_groupobjectpermission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE guardian_groupobjectpermission_id_seq OWNED BY guardian_groupobjectpermission.id;


--
-- TOC entry 2660 (class 0 OID 0)
-- Dependencies: 234
-- Name: guardian_groupobjectpermission_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('guardian_groupobjectpermission_id_seq', 48, true);


--
-- TOC entry 233 (class 1259 OID 120638)
-- Dependencies: 6
-- Name: guardian_userobjectpermission; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE guardian_userobjectpermission (
    id integer NOT NULL,
    permission_id integer NOT NULL,
    content_type_id integer NOT NULL,
    user_id integer NOT NULL,
    object_pk character varying(255) NOT NULL
);


ALTER TABLE public.guardian_userobjectpermission OWNER TO iri;

--
-- TOC entry 232 (class 1259 OID 120636)
-- Dependencies: 6 233
-- Name: guardian_userobjectpermission_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE guardian_userobjectpermission_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.guardian_userobjectpermission_id_seq OWNER TO iri;

--
-- TOC entry 2661 (class 0 OID 0)
-- Dependencies: 232
-- Name: guardian_userobjectpermission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE guardian_userobjectpermission_id_seq OWNED BY guardian_userobjectpermission.id;


--
-- TOC entry 2662 (class 0 OID 0)
-- Dependencies: 232
-- Name: guardian_userobjectpermission_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('guardian_userobjectpermission_id_seq', 60, true);


--
-- TOC entry 214 (class 1259 OID 120404)
-- Dependencies: 6
-- Name: ldt_utils_author; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE ldt_utils_author (
    id integer NOT NULL,
    handle character varying(512),
    email character varying(75),
    firstname character varying(512),
    lastname character varying(512)
);


ALTER TABLE public.ldt_utils_author OWNER TO iri;

--
-- TOC entry 213 (class 1259 OID 120402)
-- Dependencies: 6 214
-- Name: ldt_utils_author_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE ldt_utils_author_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.ldt_utils_author_id_seq OWNER TO iri;

--
-- TOC entry 2663 (class 0 OID 0)
-- Dependencies: 213
-- Name: ldt_utils_author_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE ldt_utils_author_id_seq OWNED BY ldt_utils_author.id;


--
-- TOC entry 2664 (class 0 OID 0)
-- Dependencies: 213
-- Name: ldt_utils_author_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('ldt_utils_author_id_seq', 1, false);


--
-- TOC entry 218 (class 1259 OID 120430)
-- Dependencies: 2358 6
-- Name: ldt_utils_content; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE ldt_utils_content (
    id integer NOT NULL,
    iri_id character varying(1024) DEFAULT '540fe9e1-c974-11e0-9684-58b035f6b93d'::character varying NOT NULL,
    iriurl character varying(1024) NOT NULL,
    creation_date timestamp with time zone NOT NULL,
    update_date timestamp with time zone NOT NULL,
    title character varying(1024),
    description text,
    duration integer,
    content_creation_date timestamp with time zone,
    tags character varying(2048),
    media_obj_id integer,
    image character varying(200) NOT NULL,
    front_project_id integer
);


ALTER TABLE public.ldt_utils_content OWNER TO iri;

--
-- TOC entry 220 (class 1259 OID 120444)
-- Dependencies: 6
-- Name: ldt_utils_content_authors; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE ldt_utils_content_authors (
    id integer NOT NULL,
    content_id integer NOT NULL,
    author_id integer NOT NULL
);


ALTER TABLE public.ldt_utils_content_authors OWNER TO iri;

--
-- TOC entry 219 (class 1259 OID 120442)
-- Dependencies: 220 6
-- Name: ldt_utils_content_authors_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE ldt_utils_content_authors_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.ldt_utils_content_authors_id_seq OWNER TO iri;

--
-- TOC entry 2665 (class 0 OID 0)
-- Dependencies: 219
-- Name: ldt_utils_content_authors_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE ldt_utils_content_authors_id_seq OWNED BY ldt_utils_content_authors.id;


--
-- TOC entry 2666 (class 0 OID 0)
-- Dependencies: 219
-- Name: ldt_utils_content_authors_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('ldt_utils_content_authors_id_seq', 1, false);


--
-- TOC entry 217 (class 1259 OID 120428)
-- Dependencies: 218 6
-- Name: ldt_utils_content_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE ldt_utils_content_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.ldt_utils_content_id_seq OWNER TO iri;

--
-- TOC entry 2667 (class 0 OID 0)
-- Dependencies: 217
-- Name: ldt_utils_content_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE ldt_utils_content_id_seq OWNED BY ldt_utils_content.id;


--
-- TOC entry 2668 (class 0 OID 0)
-- Dependencies: 217
-- Name: ldt_utils_content_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('ldt_utils_content_id_seq', 12, true);


--
-- TOC entry 237 (class 1259 OID 120835)
-- Dependencies: 2371 2372 6
-- Name: ldt_utils_contentstat; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE ldt_utils_contentstat (
    id integer NOT NULL,
    content_id integer NOT NULL,
    annotation_volume_str character varying(1024),
    polemics_volume_str character varying(1024),
    nb_annotations integer DEFAULT 0 NOT NULL,
    last_annotated timestamp with time zone DEFAULT '2012-06-06 11:53:17.537575+02'::timestamp with time zone
);


ALTER TABLE public.ldt_utils_contentstat OWNER TO iri;

--
-- TOC entry 236 (class 1259 OID 120833)
-- Dependencies: 237 6
-- Name: ldt_utils_contentstat_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE ldt_utils_contentstat_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.ldt_utils_contentstat_id_seq OWNER TO iri;

--
-- TOC entry 2669 (class 0 OID 0)
-- Dependencies: 236
-- Name: ldt_utils_contentstat_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE ldt_utils_contentstat_id_seq OWNED BY ldt_utils_contentstat.id;


--
-- TOC entry 2670 (class 0 OID 0)
-- Dependencies: 236
-- Name: ldt_utils_contentstat_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('ldt_utils_contentstat_id_seq', 12, true);


--
-- TOC entry 216 (class 1259 OID 120417)
-- Dependencies: 6
-- Name: ldt_utils_media; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE ldt_utils_media (
    id integer NOT NULL,
    external_id character varying(1024),
    external_permalink character varying(1024),
    external_publication_url character varying(1024),
    external_src_url character varying(1024),
    creation_date timestamp with time zone NOT NULL,
    media_creation_date timestamp with time zone,
    update_date timestamp with time zone NOT NULL,
    videopath character varying(1024),
    duration integer,
    creator_id integer,
    description text,
    title character varying(1024),
    src character varying(1024) NOT NULL,
    mimetype_field character varying(512)
);


ALTER TABLE public.ldt_utils_media OWNER TO iri;

--
-- TOC entry 215 (class 1259 OID 120415)
-- Dependencies: 216 6
-- Name: ldt_utils_media_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE ldt_utils_media_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.ldt_utils_media_id_seq OWNER TO iri;

--
-- TOC entry 2671 (class 0 OID 0)
-- Dependencies: 215
-- Name: ldt_utils_media_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE ldt_utils_media_id_seq OWNED BY ldt_utils_media.id;


--
-- TOC entry 2672 (class 0 OID 0)
-- Dependencies: 215
-- Name: ldt_utils_media_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('ldt_utils_media_id_seq', 10, true);


--
-- TOC entry 222 (class 1259 OID 120454)
-- Dependencies: 2361 6
-- Name: ldt_utils_project; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE ldt_utils_project (
    id integer NOT NULL,
    owner_id integer,
    ldt_id character varying(1024) NOT NULL,
    ldt text,
    title character varying(1024) NOT NULL,
    creation_date timestamp with time zone NOT NULL,
    modification_date timestamp with time zone NOT NULL,
    created_by character varying(70) NOT NULL,
    changed_by character varying(70) NOT NULL,
    state integer DEFAULT 1 NOT NULL,
    description text,
    image character varying(200) NOT NULL
);


ALTER TABLE public.ldt_utils_project OWNER TO iri;

--
-- TOC entry 224 (class 1259 OID 120468)
-- Dependencies: 6
-- Name: ldt_utils_project_contents; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE ldt_utils_project_contents (
    id integer NOT NULL,
    project_id integer NOT NULL,
    content_id integer NOT NULL
);


ALTER TABLE public.ldt_utils_project_contents OWNER TO iri;

--
-- TOC entry 223 (class 1259 OID 120466)
-- Dependencies: 224 6
-- Name: ldt_utils_project_contents_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE ldt_utils_project_contents_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.ldt_utils_project_contents_id_seq OWNER TO iri;

--
-- TOC entry 2673 (class 0 OID 0)
-- Dependencies: 223
-- Name: ldt_utils_project_contents_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE ldt_utils_project_contents_id_seq OWNED BY ldt_utils_project_contents.id;


--
-- TOC entry 2674 (class 0 OID 0)
-- Dependencies: 223
-- Name: ldt_utils_project_contents_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('ldt_utils_project_contents_id_seq', 16, true);


--
-- TOC entry 221 (class 1259 OID 120452)
-- Dependencies: 222 6
-- Name: ldt_utils_project_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE ldt_utils_project_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.ldt_utils_project_id_seq OWNER TO iri;

--
-- TOC entry 2675 (class 0 OID 0)
-- Dependencies: 221
-- Name: ldt_utils_project_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE ldt_utils_project_id_seq OWNED BY ldt_utils_project.id;


--
-- TOC entry 2676 (class 0 OID 0)
-- Dependencies: 221
-- Name: ldt_utils_project_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('ldt_utils_project_id_seq', 18, true);


--
-- TOC entry 226 (class 1259 OID 120478)
-- Dependencies: 6
-- Name: ldt_utils_segment; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE ldt_utils_segment (
    id integer NOT NULL,
    project_obj_id integer,
    content_id integer NOT NULL,
    project_id character varying(1024),
    iri_id character varying(1024) NOT NULL,
    ensemble_id character varying(1024) NOT NULL,
    cutting_id character varying(1024) NOT NULL,
    element_id character varying(1024) NOT NULL,
    tags character varying(2048),
    title character varying(2048),
    duration integer,
    start_ts integer,
    author character varying(1024),
    date character varying(128),
    abstract text,
    polemics integer
);


ALTER TABLE public.ldt_utils_segment OWNER TO iri;

--
-- TOC entry 225 (class 1259 OID 120476)
-- Dependencies: 226 6
-- Name: ldt_utils_segment_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE ldt_utils_segment_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.ldt_utils_segment_id_seq OWNER TO iri;

--
-- TOC entry 2677 (class 0 OID 0)
-- Dependencies: 225
-- Name: ldt_utils_segment_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE ldt_utils_segment_id_seq OWNED BY ldt_utils_segment.id;


--
-- TOC entry 2678 (class 0 OID 0)
-- Dependencies: 225
-- Name: ldt_utils_segment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('ldt_utils_segment_id_seq', 1, false);


--
-- TOC entry 191 (class 1259 OID 120188)
-- Dependencies: 6
-- Name: oauth_provider_consumer; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE oauth_provider_consumer (
    id integer NOT NULL,
    name character varying(255) NOT NULL,
    description text NOT NULL,
    key character varying(256) NOT NULL,
    secret character varying(32) NOT NULL,
    status smallint NOT NULL,
    user_id integer
);


ALTER TABLE public.oauth_provider_consumer OWNER TO iri;

--
-- TOC entry 190 (class 1259 OID 120186)
-- Dependencies: 191 6
-- Name: oauth_provider_consumer_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE oauth_provider_consumer_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.oauth_provider_consumer_id_seq OWNER TO iri;

--
-- TOC entry 2679 (class 0 OID 0)
-- Dependencies: 190
-- Name: oauth_provider_consumer_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE oauth_provider_consumer_id_seq OWNED BY oauth_provider_consumer.id;


--
-- TOC entry 2680 (class 0 OID 0)
-- Dependencies: 190
-- Name: oauth_provider_consumer_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('oauth_provider_consumer_id_seq', 1, false);


--
-- TOC entry 187 (class 1259 OID 120166)
-- Dependencies: 6
-- Name: oauth_provider_nonce; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE oauth_provider_nonce (
    id integer NOT NULL,
    token_key character varying(32) NOT NULL,
    consumer_key character varying(256) NOT NULL,
    key character varying(255) NOT NULL
);


ALTER TABLE public.oauth_provider_nonce OWNER TO iri;

--
-- TOC entry 186 (class 1259 OID 120164)
-- Dependencies: 6 187
-- Name: oauth_provider_nonce_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE oauth_provider_nonce_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.oauth_provider_nonce_id_seq OWNER TO iri;

--
-- TOC entry 2681 (class 0 OID 0)
-- Dependencies: 186
-- Name: oauth_provider_nonce_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE oauth_provider_nonce_id_seq OWNED BY oauth_provider_nonce.id;


--
-- TOC entry 2682 (class 0 OID 0)
-- Dependencies: 186
-- Name: oauth_provider_nonce_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('oauth_provider_nonce_id_seq', 1, false);


--
-- TOC entry 189 (class 1259 OID 120177)
-- Dependencies: 6
-- Name: oauth_provider_resource; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE oauth_provider_resource (
    id integer NOT NULL,
    name character varying(255) NOT NULL,
    url text NOT NULL,
    is_readonly boolean NOT NULL
);


ALTER TABLE public.oauth_provider_resource OWNER TO iri;

--
-- TOC entry 188 (class 1259 OID 120175)
-- Dependencies: 6 189
-- Name: oauth_provider_resource_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE oauth_provider_resource_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.oauth_provider_resource_id_seq OWNER TO iri;

--
-- TOC entry 2683 (class 0 OID 0)
-- Dependencies: 188
-- Name: oauth_provider_resource_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE oauth_provider_resource_id_seq OWNED BY oauth_provider_resource.id;


--
-- TOC entry 2684 (class 0 OID 0)
-- Dependencies: 188
-- Name: oauth_provider_resource_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('oauth_provider_resource_id_seq', 1, false);


--
-- TOC entry 193 (class 1259 OID 120204)
-- Dependencies: 6
-- Name: oauth_provider_token; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE oauth_provider_token (
    id integer NOT NULL,
    key character varying(32),
    secret character varying(32),
    token_type smallint NOT NULL,
    "timestamp" integer NOT NULL,
    is_approved boolean NOT NULL,
    user_id integer,
    consumer_id integer NOT NULL,
    resource_id integer NOT NULL,
    verifier character varying(10) NOT NULL,
    callback character varying(2083),
    callback_confirmed boolean NOT NULL
);


ALTER TABLE public.oauth_provider_token OWNER TO iri;

--
-- TOC entry 192 (class 1259 OID 120202)
-- Dependencies: 193 6
-- Name: oauth_provider_token_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE oauth_provider_token_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.oauth_provider_token_id_seq OWNER TO iri;

--
-- TOC entry 2685 (class 0 OID 0)
-- Dependencies: 192
-- Name: oauth_provider_token_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE oauth_provider_token_id_seq OWNED BY oauth_provider_token.id;


--
-- TOC entry 2686 (class 0 OID 0)
-- Dependencies: 192
-- Name: oauth_provider_token_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('oauth_provider_token_id_seq', 1, false);


--
-- TOC entry 201 (class 1259 OID 120257)
-- Dependencies: 6
-- Name: piston_consumer; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE piston_consumer (
    id integer NOT NULL,
    name character varying(255) NOT NULL,
    description text NOT NULL,
    key character varying(18) NOT NULL,
    secret character varying(32) NOT NULL,
    status character varying(16) NOT NULL,
    user_id integer
);


ALTER TABLE public.piston_consumer OWNER TO iri;

--
-- TOC entry 200 (class 1259 OID 120255)
-- Dependencies: 6 201
-- Name: piston_consumer_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE piston_consumer_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.piston_consumer_id_seq OWNER TO iri;

--
-- TOC entry 2687 (class 0 OID 0)
-- Dependencies: 200
-- Name: piston_consumer_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE piston_consumer_id_seq OWNED BY piston_consumer.id;


--
-- TOC entry 2688 (class 0 OID 0)
-- Dependencies: 200
-- Name: piston_consumer_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('piston_consumer_id_seq', 1, false);


--
-- TOC entry 199 (class 1259 OID 120249)
-- Dependencies: 6
-- Name: piston_nonce; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE piston_nonce (
    id integer NOT NULL,
    token_key character varying(18) NOT NULL,
    consumer_key character varying(18) NOT NULL,
    key character varying(255) NOT NULL
);


ALTER TABLE public.piston_nonce OWNER TO iri;

--
-- TOC entry 198 (class 1259 OID 120247)
-- Dependencies: 6 199
-- Name: piston_nonce_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE piston_nonce_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.piston_nonce_id_seq OWNER TO iri;

--
-- TOC entry 2689 (class 0 OID 0)
-- Dependencies: 198
-- Name: piston_nonce_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE piston_nonce_id_seq OWNED BY piston_nonce.id;


--
-- TOC entry 2690 (class 0 OID 0)
-- Dependencies: 198
-- Name: piston_nonce_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('piston_nonce_id_seq', 1, false);


--
-- TOC entry 203 (class 1259 OID 120273)
-- Dependencies: 6
-- Name: piston_token; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE piston_token (
    id integer NOT NULL,
    key character varying(18) NOT NULL,
    secret character varying(32) NOT NULL,
    verifier character varying(10) NOT NULL,
    token_type integer NOT NULL,
    "timestamp" integer NOT NULL,
    is_approved boolean NOT NULL,
    user_id integer,
    consumer_id integer NOT NULL,
    callback character varying(255),
    callback_confirmed boolean NOT NULL
);


ALTER TABLE public.piston_token OWNER TO iri;

--
-- TOC entry 202 (class 1259 OID 120271)
-- Dependencies: 6 203
-- Name: piston_token_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE piston_token_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.piston_token_id_seq OWNER TO iri;

--
-- TOC entry 2691 (class 0 OID 0)
-- Dependencies: 202
-- Name: piston_token_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE piston_token_id_seq OWNED BY piston_token.id;


--
-- TOC entry 2692 (class 0 OID 0)
-- Dependencies: 202
-- Name: piston_token_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('piston_token_id_seq', 1, false);


--
-- TOC entry 181 (class 1259 OID 120120)
-- Dependencies: 6
-- Name: registration_registrationprofile; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE registration_registrationprofile (
    id integer NOT NULL,
    user_id integer NOT NULL,
    activation_key character varying(40) NOT NULL
);


ALTER TABLE public.registration_registrationprofile OWNER TO iri;

--
-- TOC entry 180 (class 1259 OID 120118)
-- Dependencies: 6 181
-- Name: registration_registrationprofile_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE registration_registrationprofile_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.registration_registrationprofile_id_seq OWNER TO iri;

--
-- TOC entry 2693 (class 0 OID 0)
-- Dependencies: 180
-- Name: registration_registrationprofile_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE registration_registrationprofile_id_seq OWNED BY registration_registrationprofile.id;


--
-- TOC entry 2694 (class 0 OID 0)
-- Dependencies: 180
-- Name: registration_registrationprofile_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('registration_registrationprofile_id_seq', 1, false);


--
-- TOC entry 209 (class 1259 OID 120317)
-- Dependencies: 6
-- Name: social_auth_association; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE social_auth_association (
    id integer NOT NULL,
    server_url character varying(255) NOT NULL,
    handle character varying(255) NOT NULL,
    secret character varying(255) NOT NULL,
    issued integer NOT NULL,
    lifetime integer NOT NULL,
    assoc_type character varying(64) NOT NULL
);


ALTER TABLE public.social_auth_association OWNER TO iri;

--
-- TOC entry 208 (class 1259 OID 120315)
-- Dependencies: 6 209
-- Name: social_auth_association_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE social_auth_association_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.social_auth_association_id_seq OWNER TO iri;

--
-- TOC entry 2695 (class 0 OID 0)
-- Dependencies: 208
-- Name: social_auth_association_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE social_auth_association_id_seq OWNED BY social_auth_association.id;


--
-- TOC entry 2696 (class 0 OID 0)
-- Dependencies: 208
-- Name: social_auth_association_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('social_auth_association_id_seq', 1, false);


--
-- TOC entry 207 (class 1259 OID 120309)
-- Dependencies: 6
-- Name: social_auth_nonce; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE social_auth_nonce (
    id integer NOT NULL,
    server_url character varying(255) NOT NULL,
    "timestamp" integer NOT NULL,
    salt character varying(40) NOT NULL
);


ALTER TABLE public.social_auth_nonce OWNER TO iri;

--
-- TOC entry 206 (class 1259 OID 120307)
-- Dependencies: 6 207
-- Name: social_auth_nonce_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE social_auth_nonce_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.social_auth_nonce_id_seq OWNER TO iri;

--
-- TOC entry 2697 (class 0 OID 0)
-- Dependencies: 206
-- Name: social_auth_nonce_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE social_auth_nonce_id_seq OWNED BY social_auth_nonce.id;


--
-- TOC entry 2698 (class 0 OID 0)
-- Dependencies: 206
-- Name: social_auth_nonce_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('social_auth_nonce_id_seq', 1, false);


--
-- TOC entry 205 (class 1259 OID 120291)
-- Dependencies: 6
-- Name: social_auth_usersocialauth; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE social_auth_usersocialauth (
    id integer NOT NULL,
    user_id integer NOT NULL,
    provider character varying(32) NOT NULL,
    uid character varying(255) NOT NULL,
    extra_data text NOT NULL
);


ALTER TABLE public.social_auth_usersocialauth OWNER TO iri;

--
-- TOC entry 204 (class 1259 OID 120289)
-- Dependencies: 6 205
-- Name: social_auth_usersocialauth_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE social_auth_usersocialauth_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.social_auth_usersocialauth_id_seq OWNER TO iri;

--
-- TOC entry 2699 (class 0 OID 0)
-- Dependencies: 204
-- Name: social_auth_usersocialauth_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE social_auth_usersocialauth_id_seq OWNED BY social_auth_usersocialauth.id;


--
-- TOC entry 2700 (class 0 OID 0)
-- Dependencies: 204
-- Name: social_auth_usersocialauth_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('social_auth_usersocialauth_id_seq', 1, false);


--
-- TOC entry 211 (class 1259 OID 120328)
-- Dependencies: 6
-- Name: south_migrationhistory; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE south_migrationhistory (
    id integer NOT NULL,
    app_name character varying(255) NOT NULL,
    migration character varying(255) NOT NULL,
    applied timestamp with time zone NOT NULL
);


ALTER TABLE public.south_migrationhistory OWNER TO iri;

--
-- TOC entry 210 (class 1259 OID 120326)
-- Dependencies: 211 6
-- Name: south_migrationhistory_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE south_migrationhistory_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.south_migrationhistory_id_seq OWNER TO iri;

--
-- TOC entry 2701 (class 0 OID 0)
-- Dependencies: 210
-- Name: south_migrationhistory_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE south_migrationhistory_id_seq OWNED BY south_migrationhistory.id;


--
-- TOC entry 2702 (class 0 OID 0)
-- Dependencies: 210
-- Name: south_migrationhistory_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('south_migrationhistory_id_seq', 33, true);


--
-- TOC entry 183 (class 1259 OID 120135)
-- Dependencies: 6
-- Name: tagging_tag; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE tagging_tag (
    id integer NOT NULL,
    name character varying(50) NOT NULL
);


ALTER TABLE public.tagging_tag OWNER TO iri;

--
-- TOC entry 182 (class 1259 OID 120133)
-- Dependencies: 6 183
-- Name: tagging_tag_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE tagging_tag_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.tagging_tag_id_seq OWNER TO iri;

--
-- TOC entry 2703 (class 0 OID 0)
-- Dependencies: 182
-- Name: tagging_tag_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE tagging_tag_id_seq OWNED BY tagging_tag.id;


--
-- TOC entry 2704 (class 0 OID 0)
-- Dependencies: 182
-- Name: tagging_tag_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('tagging_tag_id_seq', 4, true);


--
-- TOC entry 185 (class 1259 OID 120145)
-- Dependencies: 2341 6
-- Name: tagging_taggeditem; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE tagging_taggeditem (
    id integer NOT NULL,
    tag_id integer NOT NULL,
    content_type_id integer NOT NULL,
    object_id integer NOT NULL,
    CONSTRAINT tagging_taggeditem_object_id_check CHECK ((object_id >= 0))
);


ALTER TABLE public.tagging_taggeditem OWNER TO iri;

--
-- TOC entry 184 (class 1259 OID 120143)
-- Dependencies: 185 6
-- Name: tagging_taggeditem_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE tagging_taggeditem_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.tagging_taggeditem_id_seq OWNER TO iri;

--
-- TOC entry 2705 (class 0 OID 0)
-- Dependencies: 184
-- Name: tagging_taggeditem_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE tagging_taggeditem_id_seq OWNED BY tagging_taggeditem.id;


--
-- TOC entry 2706 (class 0 OID 0)
-- Dependencies: 184
-- Name: tagging_taggeditem_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('tagging_taggeditem_id_seq', 22, true);


--
-- TOC entry 239 (class 1259 OID 120863)
-- Dependencies: 2374 6
-- Name: text_annotation; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE text_annotation (
    id integer NOT NULL,
    external_id character varying(1024) DEFAULT '5393f930-c975-11e0-bf36-58b035f6b93d'::character varying NOT NULL,
    uri character varying(1024) NOT NULL,
    tags_field character varying(2048),
    title character varying(1024),
    description text,
    text text,
    color character varying(1024) NOT NULL,
    creator character varying(1024),
    contributor character varying(1024),
    creation_date timestamp with time zone NOT NULL,
    update_date timestamp with time zone NOT NULL
);


ALTER TABLE public.text_annotation OWNER TO iri;

--
-- TOC entry 238 (class 1259 OID 120861)
-- Dependencies: 239 6
-- Name: text_annotation_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE text_annotation_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.text_annotation_id_seq OWNER TO iri;

--
-- TOC entry 2707 (class 0 OID 0)
-- Dependencies: 238
-- Name: text_annotation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE text_annotation_id_seq OWNED BY text_annotation.id;


--
-- TOC entry 2708 (class 0 OID 0)
-- Dependencies: 238
-- Name: text_annotation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('text_annotation_id_seq', 1, false);


--
-- TOC entry 212 (class 1259 OID 120337)
-- Dependencies: 6
-- Name: thumbnail_kvstore; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE thumbnail_kvstore (
    key character varying(200) NOT NULL,
    value text NOT NULL
);


ALTER TABLE public.thumbnail_kvstore OWNER TO iri;

--
-- TOC entry 231 (class 1259 OID 120619)
-- Dependencies: 2367 6
-- Name: user_groupprofile; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE user_groupprofile (
    id integer NOT NULL,
    group_id integer NOT NULL,
    description text NOT NULL,
    image character varying(100) DEFAULT 'thumbnails/groups/group_default_icon.png'::character varying NOT NULL
);


ALTER TABLE public.user_groupprofile OWNER TO iri;

--
-- TOC entry 230 (class 1259 OID 120617)
-- Dependencies: 6 231
-- Name: user_groupprofile_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE user_groupprofile_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.user_groupprofile_id_seq OWNER TO iri;

--
-- TOC entry 2709 (class 0 OID 0)
-- Dependencies: 230
-- Name: user_groupprofile_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE user_groupprofile_id_seq OWNED BY user_groupprofile.id;


--
-- TOC entry 2710 (class 0 OID 0)
-- Dependencies: 230
-- Name: user_groupprofile_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('user_groupprofile_id_seq', 1, true);


--
-- TOC entry 227 (class 1259 OID 120558)
-- Dependencies: 6
-- Name: user_ldt; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE user_ldt (
    user_ptr_id integer NOT NULL
);


ALTER TABLE public.user_ldt OWNER TO iri;

--
-- TOC entry 229 (class 1259 OID 120597)
-- Dependencies: 2365 6
-- Name: user_userprofile; Type: TABLE; Schema: public; Owner: iri; Tablespace: 
--

CREATE TABLE user_userprofile (
    id integer NOT NULL,
    user_id integer NOT NULL,
    language character varying(2) DEFAULT 'fr'::character varying NOT NULL,
    image character varying(100) NOT NULL
);


ALTER TABLE public.user_userprofile OWNER TO iri;

--
-- TOC entry 228 (class 1259 OID 120595)
-- Dependencies: 229 6
-- Name: user_userprofile_id_seq; Type: SEQUENCE; Schema: public; Owner: iri
--

CREATE SEQUENCE user_userprofile_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.user_userprofile_id_seq OWNER TO iri;

--
-- TOC entry 2711 (class 0 OID 0)
-- Dependencies: 228
-- Name: user_userprofile_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: iri
--

ALTER SEQUENCE user_userprofile_id_seq OWNED BY user_userprofile.id;


--
-- TOC entry 2712 (class 0 OID 0)
-- Dependencies: 228
-- Name: user_userprofile_id_seq; Type: SEQUENCE SET; Schema: public; Owner: iri
--

SELECT pg_catalog.setval('user_userprofile_id_seq', 2, true);


--
-- TOC entry 2330 (class 2604 OID 120005)
-- Dependencies: 165 166 166
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE auth_group ALTER COLUMN id SET DEFAULT nextval('auth_group_id_seq'::regclass);


--
-- TOC entry 2329 (class 2604 OID 119990)
-- Dependencies: 164 163 164
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE auth_group_permissions ALTER COLUMN id SET DEFAULT nextval('auth_group_permissions_id_seq'::regclass);


--
-- TOC entry 2328 (class 2604 OID 119980)
-- Dependencies: 161 162 162
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE auth_permission ALTER COLUMN id SET DEFAULT nextval('auth_permission_id_seq'::regclass);


--
-- TOC entry 2333 (class 2604 OID 120050)
-- Dependencies: 171 172 172
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE auth_user ALTER COLUMN id SET DEFAULT nextval('auth_user_id_seq'::regclass);


--
-- TOC entry 2332 (class 2604 OID 120035)
-- Dependencies: 169 170 170
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE auth_user_groups ALTER COLUMN id SET DEFAULT nextval('auth_user_groups_id_seq'::regclass);


--
-- TOC entry 2331 (class 2604 OID 120020)
-- Dependencies: 168 167 168
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE auth_user_user_permissions ALTER COLUMN id SET DEFAULT nextval('auth_user_user_permissions_id_seq'::regclass);


--
-- TOC entry 2336 (class 2604 OID 120101)
-- Dependencies: 178 179 179
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE django_admin_log ALTER COLUMN id SET DEFAULT nextval('django_admin_log_id_seq'::regclass);


--
-- TOC entry 2334 (class 2604 OID 120070)
-- Dependencies: 173 174 174
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE django_content_type ALTER COLUMN id SET DEFAULT nextval('django_content_type_id_seq'::regclass);


--
-- TOC entry 2347 (class 2604 OID 120241)
-- Dependencies: 197 196 197
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE django_openid_consumer_association ALTER COLUMN id SET DEFAULT nextval('django_openid_consumer_association_id_seq'::regclass);


--
-- TOC entry 2346 (class 2604 OID 120233)
-- Dependencies: 194 195 195
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE django_openid_consumer_nonce ALTER COLUMN id SET DEFAULT nextval('django_openid_consumer_nonce_id_seq'::regclass);


--
-- TOC entry 2335 (class 2604 OID 120093)
-- Dependencies: 176 177 177
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE django_site ALTER COLUMN id SET DEFAULT nextval('django_site_id_seq'::regclass);


--
-- TOC entry 2369 (class 2604 OID 120652)
-- Dependencies: 234 235 235
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE guardian_groupobjectpermission ALTER COLUMN id SET DEFAULT nextval('guardian_groupobjectpermission_id_seq'::regclass);


--
-- TOC entry 2368 (class 2604 OID 120641)
-- Dependencies: 233 232 233
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE guardian_userobjectpermission ALTER COLUMN id SET DEFAULT nextval('guardian_userobjectpermission_id_seq'::regclass);


--
-- TOC entry 2355 (class 2604 OID 120407)
-- Dependencies: 213 214 214
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE ldt_utils_author ALTER COLUMN id SET DEFAULT nextval('ldt_utils_author_id_seq'::regclass);


--
-- TOC entry 2357 (class 2604 OID 120433)
-- Dependencies: 218 217 218
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE ldt_utils_content ALTER COLUMN id SET DEFAULT nextval('ldt_utils_content_id_seq'::regclass);


--
-- TOC entry 2359 (class 2604 OID 120447)
-- Dependencies: 219 220 220
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE ldt_utils_content_authors ALTER COLUMN id SET DEFAULT nextval('ldt_utils_content_authors_id_seq'::regclass);


--
-- TOC entry 2370 (class 2604 OID 120838)
-- Dependencies: 236 237 237
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE ldt_utils_contentstat ALTER COLUMN id SET DEFAULT nextval('ldt_utils_contentstat_id_seq'::regclass);


--
-- TOC entry 2356 (class 2604 OID 120420)
-- Dependencies: 215 216 216
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE ldt_utils_media ALTER COLUMN id SET DEFAULT nextval('ldt_utils_media_id_seq'::regclass);


--
-- TOC entry 2360 (class 2604 OID 120457)
-- Dependencies: 221 222 222
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE ldt_utils_project ALTER COLUMN id SET DEFAULT nextval('ldt_utils_project_id_seq'::regclass);


--
-- TOC entry 2362 (class 2604 OID 120471)
-- Dependencies: 224 223 224
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE ldt_utils_project_contents ALTER COLUMN id SET DEFAULT nextval('ldt_utils_project_contents_id_seq'::regclass);


--
-- TOC entry 2363 (class 2604 OID 120481)
-- Dependencies: 225 226 226
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE ldt_utils_segment ALTER COLUMN id SET DEFAULT nextval('ldt_utils_segment_id_seq'::regclass);


--
-- TOC entry 2344 (class 2604 OID 120191)
-- Dependencies: 190 191 191
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE oauth_provider_consumer ALTER COLUMN id SET DEFAULT nextval('oauth_provider_consumer_id_seq'::regclass);


--
-- TOC entry 2342 (class 2604 OID 120169)
-- Dependencies: 186 187 187
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE oauth_provider_nonce ALTER COLUMN id SET DEFAULT nextval('oauth_provider_nonce_id_seq'::regclass);


--
-- TOC entry 2343 (class 2604 OID 120180)
-- Dependencies: 189 188 189
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE oauth_provider_resource ALTER COLUMN id SET DEFAULT nextval('oauth_provider_resource_id_seq'::regclass);


--
-- TOC entry 2345 (class 2604 OID 120207)
-- Dependencies: 193 192 193
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE oauth_provider_token ALTER COLUMN id SET DEFAULT nextval('oauth_provider_token_id_seq'::regclass);


--
-- TOC entry 2349 (class 2604 OID 120260)
-- Dependencies: 200 201 201
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE piston_consumer ALTER COLUMN id SET DEFAULT nextval('piston_consumer_id_seq'::regclass);


--
-- TOC entry 2348 (class 2604 OID 120252)
-- Dependencies: 198 199 199
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE piston_nonce ALTER COLUMN id SET DEFAULT nextval('piston_nonce_id_seq'::regclass);


--
-- TOC entry 2350 (class 2604 OID 120276)
-- Dependencies: 202 203 203
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE piston_token ALTER COLUMN id SET DEFAULT nextval('piston_token_id_seq'::regclass);


--
-- TOC entry 2338 (class 2604 OID 120123)
-- Dependencies: 181 180 181
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE registration_registrationprofile ALTER COLUMN id SET DEFAULT nextval('registration_registrationprofile_id_seq'::regclass);


--
-- TOC entry 2353 (class 2604 OID 120320)
-- Dependencies: 208 209 209
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE social_auth_association ALTER COLUMN id SET DEFAULT nextval('social_auth_association_id_seq'::regclass);


--
-- TOC entry 2352 (class 2604 OID 120312)
-- Dependencies: 206 207 207
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE social_auth_nonce ALTER COLUMN id SET DEFAULT nextval('social_auth_nonce_id_seq'::regclass);


--
-- TOC entry 2351 (class 2604 OID 120294)
-- Dependencies: 205 204 205
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE social_auth_usersocialauth ALTER COLUMN id SET DEFAULT nextval('social_auth_usersocialauth_id_seq'::regclass);


--
-- TOC entry 2354 (class 2604 OID 120331)
-- Dependencies: 210 211 211
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE south_migrationhistory ALTER COLUMN id SET DEFAULT nextval('south_migrationhistory_id_seq'::regclass);


--
-- TOC entry 2339 (class 2604 OID 120138)
-- Dependencies: 182 183 183
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE tagging_tag ALTER COLUMN id SET DEFAULT nextval('tagging_tag_id_seq'::regclass);


--
-- TOC entry 2340 (class 2604 OID 120148)
-- Dependencies: 184 185 185
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE tagging_taggeditem ALTER COLUMN id SET DEFAULT nextval('tagging_taggeditem_id_seq'::regclass);


--
-- TOC entry 2373 (class 2604 OID 120866)
-- Dependencies: 239 238 239
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE text_annotation ALTER COLUMN id SET DEFAULT nextval('text_annotation_id_seq'::regclass);


--
-- TOC entry 2366 (class 2604 OID 120622)
-- Dependencies: 231 230 231
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE user_groupprofile ALTER COLUMN id SET DEFAULT nextval('user_groupprofile_id_seq'::regclass);


--
-- TOC entry 2364 (class 2604 OID 120600)
-- Dependencies: 228 229 229
-- Name: id; Type: DEFAULT; Schema: public; Owner: iri
--

ALTER TABLE user_userprofile ALTER COLUMN id SET DEFAULT nextval('user_userprofile_id_seq'::regclass);


--
-- TOC entry 2592 (class 0 OID 120002)
-- Dependencies: 166
-- Data for Name: auth_group; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY auth_group (id, name) FROM stdin;
1	everyone
\.


--
-- TOC entry 2591 (class 0 OID 119987)
-- Dependencies: 164
-- Data for Name: auth_group_permissions; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY auth_group_permissions (id, group_id, permission_id) FROM stdin;
\.


--
-- TOC entry 2590 (class 0 OID 119977)
-- Dependencies: 162
-- Data for Name: auth_permission; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY auth_permission (id, name, content_type_id, codename) FROM stdin;
1	Can add permission	1	add_permission
2	Can change permission	1	change_permission
3	Can delete permission	1	delete_permission
4	Can add group	2	add_group
5	Can change group	2	change_group
6	Can delete group	2	delete_group
7	Can add user	3	add_user
8	Can change user	3	change_user
9	Can delete user	3	delete_user
10	Can add content type	4	add_contenttype
11	Can change content type	4	change_contenttype
12	Can delete content type	4	delete_contenttype
13	Can add session	5	add_session
14	Can change session	5	change_session
15	Can delete session	5	delete_session
16	Can add site	6	add_site
17	Can change site	6	change_site
18	Can delete site	6	delete_site
19	Can add log entry	7	add_logentry
20	Can change log entry	7	change_logentry
21	Can delete log entry	7	delete_logentry
22	Can add registration profile	8	add_registrationprofile
23	Can change registration profile	8	change_registrationprofile
24	Can delete registration profile	8	delete_registrationprofile
25	Can add tag	9	add_tag
26	Can change tag	9	change_tag
27	Can delete tag	9	delete_tag
28	Can add tagged item	10	add_taggeditem
29	Can change tagged item	10	change_taggeditem
30	Can delete tagged item	10	delete_taggeditem
31	Can add nonce	11	add_nonce
32	Can change nonce	11	change_nonce
33	Can delete nonce	11	delete_nonce
34	Can add resource	12	add_resource
35	Can change resource	12	change_resource
36	Can delete resource	12	delete_resource
37	Can add consumer	13	add_consumer
38	Can change consumer	13	change_consumer
39	Can delete consumer	13	delete_consumer
40	Can add token	14	add_token
41	Can change token	14	change_token
42	Can delete token	14	delete_token
43	Can add nonce	15	add_nonce
44	Can change nonce	15	change_nonce
45	Can delete nonce	15	delete_nonce
46	Can add association	16	add_association
47	Can change association	16	change_association
48	Can delete association	16	delete_association
49	Can add nonce	17	add_nonce
50	Can change nonce	17	change_nonce
51	Can delete nonce	17	delete_nonce
52	Can add consumer	18	add_consumer
53	Can change consumer	18	change_consumer
54	Can delete consumer	18	delete_consumer
55	Can add token	19	add_token
56	Can change token	19	change_token
57	Can delete token	19	delete_token
58	Can add user social auth	20	add_usersocialauth
59	Can change user social auth	20	change_usersocialauth
60	Can delete user social auth	20	delete_usersocialauth
61	Can add nonce	21	add_nonce
62	Can change nonce	21	change_nonce
63	Can delete nonce	21	delete_nonce
64	Can add association	22	add_association
65	Can change association	22	change_association
66	Can delete association	22	delete_association
67	Can add migration history	23	add_migrationhistory
68	Can change migration history	23	change_migrationhistory
69	Can delete migration history	23	delete_migrationhistory
70	Can add kv store	24	add_kvstore
71	Can change kv store	24	change_kvstore
72	Can delete kv store	24	delete_kvstore
73	Can add author	25	add_author
74	Can change author	25	change_author
75	Can delete author	25	delete_author
76	Can view author	25	view_author
77	Can add media	26	add_media
78	Can change media	26	change_media
79	Can delete media	26	delete_media
80	Can view media	26	view_media
81	Can add content	27	add_content
82	Can change content	27	change_content
83	Can delete content	27	delete_content
84	Can view content	27	view_content
85	Can add content stat	28	add_contentstat
86	Can change content stat	28	change_contentstat
87	Can delete content stat	28	delete_contentstat
88	Can add project	29	add_project
89	Can change project	29	change_project
90	Can delete project	29	delete_project
91	Can view project	29	view_project
92	Can add segment	30	add_segment
93	Can change segment	30	change_segment
94	Can delete segment	30	delete_segment
95	Can view segment	30	view_segment
96	Can add/delete admins to the group	2	is_owner_group
97	Can add iri user	31	add_ldt
98	Can change iri user	31	change_ldt
99	Can delete iri user	31	delete_ldt
100	Can add user profile	32	add_userprofile
101	Can change user profile	32	change_userprofile
102	Can delete user profile	32	delete_userprofile
103	Can add group profile	33	add_groupprofile
104	Can change group profile	33	change_groupprofile
105	Can delete group profile	33	delete_groupprofile
106	Can add user object permission	34	add_userobjectpermission
107	Can change user object permission	34	change_userobjectpermission
108	Can delete user object permission	34	delete_userobjectpermission
109	Can add group object permission	35	add_groupobjectpermission
110	Can change group object permission	35	change_groupobjectpermission
111	Can delete group object permission	35	delete_groupobjectpermission
112	Can add annotation	36	add_annotation
113	Can change annotation	36	change_annotation
114	Can delete annotation	36	delete_annotation
\.


--
-- TOC entry 2595 (class 0 OID 120047)
-- Dependencies: 172
-- Data for Name: auth_user; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY auth_user (id, username, first_name, last_name, email, password, is_staff, is_active, is_superuser, last_login, date_joined) FROM stdin;
-1	AnonymousUser					f	t	f	2012-06-06 11:53:17.883279+02	2012-06-06 11:53:17.883311+02
1	admin			a@m.com	pbkdf2_sha256$10000$vPHTeaAQ9yEv$I137lIjLFPcnW1xEqnTmRLZGNbgxsG9JNZqsEMzMhBo=	t	t	t	2012-06-06 16:14:03.167379+02	2012-06-06 16:53:53.969641+02
\.


--
-- TOC entry 2594 (class 0 OID 120032)
-- Dependencies: 170
-- Data for Name: auth_user_groups; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY auth_user_groups (id, user_id, group_id) FROM stdin;
1	-1	1
2	1	1
\.


--
-- TOC entry 2593 (class 0 OID 120017)
-- Dependencies: 168
-- Data for Name: auth_user_user_permissions; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY auth_user_user_permissions (id, user_id, permission_id) FROM stdin;
\.


--
-- TOC entry 2599 (class 0 OID 120098)
-- Dependencies: 179
-- Data for Name: django_admin_log; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY django_admin_log (id, action_time, user_id, content_type_id, object_id, object_repr, action_flag, change_message) FROM stdin;
1	2012-06-06 16:07:33.128456+02	1	26	1	mp3:video/tralalere/hdes_te_0209	2	Changed src.
2	2012-06-06 16:23:25.95051+02	1	26	1	mp3:video/tralalere/hdes_te_0209	2	Changed videopath.
3	2012-06-06 19:27:15.042924+02	1	29	1	1::a2a79e68-afdf-11e1-b402-58b035f6b93d::front project : Alouette	3	
4	2012-06-06 19:27:15.047543+02	1	29	11	11::942cf859-aff6-11e1-8c47-58b035f6b93d::front project : Alouette	3	
5	2012-06-06 19:27:15.049718+02	1	29	13	13::065b3533-aff7-11e1-a91e-58b035f6b93d::front project : Alouette	3	
6	2012-06-06 19:27:15.051899+02	1	29	15	15::402d4187-affb-11e1-8ab9-58b035f6b93d::front project : Alouette	3	
7	2012-06-06 19:31:05.329461+02	1	29	2	2::122dae5e-afe4-11e1-b591-58b035f6b93d::front project : Alouette (instrumental)	3	
\.


--
-- TOC entry 2596 (class 0 OID 120067)
-- Dependencies: 174
-- Data for Name: django_content_type; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY django_content_type (id, name, app_label, model) FROM stdin;
1	permission	auth	permission
2	group	auth	group
3	user	auth	user
4	content type	contenttypes	contenttype
5	session	sessions	session
6	site	sites	site
7	log entry	admin	logentry
8	registration profile	registration	registrationprofile
9	tag	tagging	tag
10	tagged item	tagging	taggeditem
11	nonce	oauth_provider	nonce
12	resource	oauth_provider	resource
13	consumer	oauth_provider	consumer
14	token	oauth_provider	token
15	nonce	django_openid_consumer	nonce
16	association	django_openid_consumer	association
17	nonce	piston	nonce
18	consumer	piston	consumer
19	token	piston	token
20	user social auth	social_auth	usersocialauth
21	nonce	social_auth	nonce
22	association	social_auth	association
23	migration history	south	migrationhistory
24	kv store	thumbnail	kvstore
25	author	ldt_utils	author
26	media	ldt_utils	media
27	content	ldt_utils	content
28	content stat	ldt_utils	contentstat
29	project	ldt_utils	project
30	segment	ldt_utils	segment
31	iri user	user	ldt
32	user profile	user	userprofile
33	group profile	user	groupprofile
34	user object permission	guardian	userobjectpermission
35	group object permission	guardian	groupobjectpermission
36	annotation	text	annotation
\.


--
-- TOC entry 2608 (class 0 OID 120238)
-- Dependencies: 197
-- Data for Name: django_openid_consumer_association; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY django_openid_consumer_association (id, server_url, handle, secret, issued, lifetime, assoc_type) FROM stdin;
\.


--
-- TOC entry 2607 (class 0 OID 120230)
-- Dependencies: 195
-- Data for Name: django_openid_consumer_nonce; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY django_openid_consumer_nonce (id, server_url, "timestamp", salt) FROM stdin;
\.


--
-- TOC entry 2597 (class 0 OID 120080)
-- Dependencies: 175
-- Data for Name: django_session; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY django_session (session_key, session_data, expire_date) FROM stdin;
07932891a107c7586c5513e965bbf62a	OTcwYWRmMzM2NTQ3YjgwM2Y1MjhjMGNiYTExNDkzNjM4NGYxMDVkYjqAAn1xAShVEl9hdXRoX3Vz\nZXJfYmFja2VuZHECVSlkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZHED\nVQ1fYXV0aF91c2VyX2lkcQRLAXUu\n	2012-06-20 12:23:38.707939+02
84319bdf17772c0d5d70f7892192b5e4	OTcwYWRmMzM2NTQ3YjgwM2Y1MjhjMGNiYTExNDkzNjM4NGYxMDVkYjqAAn1xAShVEl9hdXRoX3Vz\nZXJfYmFja2VuZHECVSlkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZHED\nVQ1fYXV0aF91c2VyX2lkcQRLAXUu\n	2012-06-20 13:30:29.641312+02
c13f67938fc66a9e146230be9cf54277	OTcwYWRmMzM2NTQ3YjgwM2Y1MjhjMGNiYTExNDkzNjM4NGYxMDVkYjqAAn1xAShVEl9hdXRoX3Vz\nZXJfYmFja2VuZHECVSlkamFuZ28uY29udHJpYi5hdXRoLmJhY2tlbmRzLk1vZGVsQmFja2VuZHED\nVQ1fYXV0aF91c2VyX2lkcQRLAXUu\n	2012-06-20 16:14:03.189851+02
\.


--
-- TOC entry 2598 (class 0 OID 120090)
-- Dependencies: 177
-- Data for Name: django_site; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY django_site (id, domain, name) FROM stdin;
1	example.com	example.com
\.


--
-- TOC entry 2628 (class 0 OID 120649)
-- Dependencies: 235
-- Data for Name: guardian_groupobjectpermission; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY guardian_groupobjectpermission (id, permission_id, content_type_id, group_id, object_pk) FROM stdin;
1	91	29	1	3
2	89	29	1	3
3	84	27	1	3
4	80	26	1	3
7	84	27	1	4
8	80	26	1	4
9	84	27	1	1
10	80	26	1	1
11	91	29	1	5
12	89	29	1	5
13	84	27	1	5
14	80	26	1	5
17	84	27	1	6
18	80	26	1	6
19	91	29	1	7
20	89	29	1	7
21	84	27	1	7
22	80	26	1	7
23	91	29	1	8
24	89	29	1	8
25	84	27	1	8
26	80	26	1	8
27	91	29	1	9
28	89	29	1	9
29	84	27	1	9
30	80	26	1	9
33	84	27	1	10
34	80	26	1	10
35	91	29	1	11
36	89	29	1	11
37	91	29	1	12
38	89	29	1	12
39	91	29	1	14
40	89	29	1	14
41	84	27	1	11
42	91	29	1	16
43	89	29	1	16
44	84	27	1	12
45	91	29	1	17
46	89	29	1	17
\.


--
-- TOC entry 2627 (class 0 OID 120638)
-- Dependencies: 233
-- Data for Name: guardian_userobjectpermission; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY guardian_userobjectpermission (id, permission_id, content_type_id, user_id, object_pk) FROM stdin;
1	80	26	1	1
2	78	26	1	1
3	82	27	1	1
4	84	27	1	1
5	80	26	1	2
6	78	26	1	2
7	82	27	1	2
8	84	27	1	2
9	91	29	1	3
10	89	29	1	3
11	82	27	1	3
12	84	27	1	3
13	91	29	1	4
14	89	29	1	4
15	82	27	1	4
16	84	27	1	4
17	91	29	1	5
18	89	29	1	5
19	82	27	1	5
20	84	27	1	5
21	91	29	1	6
22	89	29	1	6
23	82	27	1	6
24	84	27	1	6
25	91	29	1	7
26	89	29	1	7
27	82	27	1	7
28	84	27	1	7
29	91	29	1	8
30	89	29	1	8
31	82	27	1	8
32	84	27	1	8
33	91	29	1	9
34	89	29	1	9
35	82	27	1	9
36	84	27	1	9
37	91	29	1	10
38	89	29	1	10
39	82	27	1	10
40	84	27	1	10
41	91	29	1	11
42	89	29	1	11
43	91	29	1	12
44	89	29	1	12
45	91	29	1	13
46	89	29	1	13
47	91	29	1	14
48	89	29	1	14
49	82	27	1	11
50	84	27	1	11
51	91	29	1	15
52	89	29	1	15
53	91	29	1	16
54	89	29	1	16
55	82	27	1	12
56	84	27	1	12
57	91	29	1	17
58	89	29	1	17
59	91	29	1	18
60	89	29	1	18
\.


--
-- TOC entry 2617 (class 0 OID 120404)
-- Dependencies: 214
-- Data for Name: ldt_utils_author; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY ldt_utils_author (id, handle, email, firstname, lastname) FROM stdin;
\.


--
-- TOC entry 2619 (class 0 OID 120430)
-- Dependencies: 218
-- Data for Name: ldt_utils_content; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY ldt_utils_content (id, iri_id, iriurl, creation_date, update_date, title, description, duration, content_creation_date, tags, media_obj_id, image, front_project_id) FROM stdin;
12	6a4d35a6-affc-11e1-b451-58b035f6b93d	6a4d35a6-affc-11e1-b451-58b035f6b93d/6a4d35a6-affc-11e1-b451-58b035f6b93d.iri	2012-06-06 19:25:57.421951+02	2012-06-08 02:31:48.789399+02	Alouette	Henri Dès	187800	\N	tralalere, henri des	1	thumbnails/contents/6a4d35a6-affc-11e1-b451-58b035f6b93d_2.jpg	16
2	c7bf25c7-afe3-11e1-8747-58b035f6b93d	c7bf25c7-afe3-11e1-8747-58b035f6b93d/c7bf25c7-afe3-11e1-8747-58b035f6b93d.iri	2012-06-06 16:29:49.01517+02	2012-06-08 02:31:48.802165+02	Alouette (instrumental)	Henri Dès	188500	\N	tralalere, henri des	2	thumbnails/contents/c7bf25c7-afe3-11e1-8747-58b035f6b93d.jpg	18
3	a8c730ee-afe4-11e1-81dc-58b035f6b93d	a8c730ee-afe4-11e1-81dc-58b035f6b93d/a8c730ee-afe4-11e1-81dc-58b035f6b93d.iri	2012-06-06 16:37:03.929785+02	2012-06-08 02:31:48.807689+02	Au clair de la lune	Steve Waring	147000	\N	tralalere, steve waring	3	thumbnails/contents/a8c730ee-afe4-11e1-81dc-58b035f6b93d.jpg	3
4	3f0148e8-afe5-11e1-9960-58b035f6b93d	3f0148e8-afe5-11e1-9960-58b035f6b93d/3f0148e8-afe5-11e1-9960-58b035f6b93d.iri	2012-06-06 16:39:27.325199+02	2012-06-08 02:31:48.813386+02	Au clair de la lune (instrumental)	Steve Waring	145700	\N	tralalere, steve waring	4	thumbnails/contents/3f0148e8-afe5-11e1-9960-58b035f6b93d.jpg	4
5	168b2126-afed-11e1-9429-58b035f6b93d	168b2126-afed-11e1-9429-58b035f6b93d/168b2126-afed-11e1-9429-58b035f6b93d.iri	2012-06-06 17:36:10.414935+02	2012-06-08 02:31:48.819129+02	Cadet Rousselle	Steve Waring	230000	\N	tralalere, steve waring	5	thumbnails/contents/168b2126-afed-11e1-9429-58b035f6b93d.jpg	5
6	5ca8712b-afed-11e1-86d7-58b035f6b93d	5ca8712b-afed-11e1-86d7-58b035f6b93d/5ca8712b-afed-11e1-86d7-58b035f6b93d.iri	2012-06-06 17:37:26.377902+02	2012-06-08 02:31:48.824391+02	Cadet Rousselle (instrumental)	Steve Waring	230500	\N	tralalere, steve waring	6	thumbnails/contents/5ca8712b-afed-11e1-86d7-58b035f6b93d.jpg	6
7	88d13054-afed-11e1-b351-58b035f6b93d	88d13054-afed-11e1-b351-58b035f6b93d/88d13054-afed-11e1-b351-58b035f6b93d.iri	2012-06-06 17:40:51.758039+02	2012-06-08 02:31:48.829538+02	Frère Jacques	Jolies chansons d'enfance	70800	\N	tralalere, jolies chansons d'enfance	7	thumbnails/contents/88d13054-afed-11e1-b351-58b035f6b93d.jpg	7
8	0595b6bd-afee-11e1-a00e-58b035f6b93d	0595b6bd-afee-11e1-a00e-58b035f6b93d/0595b6bd-afee-11e1-a00e-58b035f6b93d.iri	2012-06-06 17:42:45.279356+02	2012-06-08 02:31:48.834497+02	Pirouette	Jolies chansons d'enfance	146300	\N	tralalere, jolies chansons d'enfance	8	thumbnails/contents/0595b6bd-afee-11e1-a00e-58b035f6b93d.jpg	8
9	fb9d5a9e-afee-11e1-a770-58b035f6b93d	fb9d5a9e-afee-11e1-a770-58b035f6b93d/fb9d5a9e-afee-11e1-a770-58b035f6b93d.iri	2012-06-06 17:48:54.230946+02	2012-06-08 02:31:48.839705+02	Ya une pie	Henri Dès	183200	\N	tralalere, henri des	9	thumbnails/contents/fb9d5a9e-afee-11e1-a770-58b035f6b93d.jpg	9
10	247de85c-afef-11e1-9e56-58b035f6b93d	247de85c-afef-11e1-9e56-58b035f6b93d/247de85c-afef-11e1-9e56-58b035f6b93d.iri	2012-06-06 17:50:16.001329+02	2012-06-08 02:31:48.845083+02	Ya une pie (instrumental)	Henri Dès	183400	\N	tralalere, henri des	10	thumbnails/contents/247de85c-afef-11e1-9e56-58b035f6b93d.jpg	10
\.


--
-- TOC entry 2620 (class 0 OID 120444)
-- Dependencies: 220
-- Data for Name: ldt_utils_content_authors; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY ldt_utils_content_authors (id, content_id, author_id) FROM stdin;
\.


--
-- TOC entry 2629 (class 0 OID 120835)
-- Dependencies: 237
-- Data for Name: ldt_utils_contentstat; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY ldt_utils_contentstat (id, content_id, annotation_volume_str, polemics_volume_str, nb_annotations, last_annotated) FROM stdin;
1	3	0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0	0,0,0,0	0	2012-06-06 16:37:03.929842+02
3	5	0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0	0,0,0,0	0	2012-06-06 17:36:10.414979+02
11	12	0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0	0,0,0,0	0	2012-06-06 19:25:57.421989+02
5	7	0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0	0,0,0,0	0	2012-06-06 17:40:51.758076+02
6	8	0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0	0,0,0,0	0	2012-06-06 17:42:45.279421+02
7	9	0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0	0,0,0,0	0	2012-06-06 17:48:54.230986+02
12	2	0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0	0,0,0,0	0	2012-06-06 19:32:28.45968+02
2	4	0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0	0,0,0,0	0	2012-06-06 16:39:27.624547+02
4	6	0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0	0,0,0,0	0	2012-06-06 17:37:26.705767+02
8	10	0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0	0,0,0,0	0	2012-06-06 17:50:16.294968+02
\.


--
-- TOC entry 2618 (class 0 OID 120417)
-- Dependencies: 216
-- Data for Name: ldt_utils_media; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY ldt_utils_media (id, external_id, external_permalink, external_publication_url, external_src_url, creation_date, media_creation_date, update_date, videopath, duration, creator_id, description, title, src, mimetype_field) FROM stdin;
3					2012-06-06 16:37:03.916349+02	\N	2012-06-06 16:37:03.9164+02	rtmp://media.iri.centrepompidou.fr/ddc_player/	\N	\N			mp3:video/tralalere/wari_0710	
4					2012-06-06 16:39:27.312582+02	\N	2012-06-06 16:39:27.312633+02	rtmp://media.iri.centrepompidou.fr/ddc_player/	\N	\N			mp3:video/tralalere/wari_0720	
5					2012-06-06 17:36:09.69636+02	\N	2012-06-06 17:36:09.696411+02	rtmp://media.iri.centrepompidou.fr/ddc_player/	\N	\N			mp3:video/tralalere/wari_0706	
6					2012-06-06 17:37:26.295464+02	\N	2012-06-06 17:37:26.295513+02	rtmp://media.iri.centrepompidou.fr/ddc_player/	\N	\N			mp3:video/tralalere/wari_0716	
7					2012-06-06 17:40:51.746149+02	\N	2012-06-06 17:40:51.746202+02	rtmp://media.iri.centrepompidou.fr/ddc_player/	\N	\N			mp3:video/tralalere/jcde_0201.mp3	
8					2012-06-06 17:42:45.25231+02	\N	2012-06-06 17:42:45.252359+02	rtmp://media.iri.centrepompidou.fr/ddc_player/	\N	\N			mp3:video/tralalere/jcde_0404.mp3	
9					2012-06-06 17:48:54.21283+02	\N	2012-06-06 17:48:54.212901+02	rtmp://media.iri.centrepompidou.fr/ddc_player/	\N	\N			mp3:video/tralalere/hdes_te_0201	
10					2012-06-06 17:50:15.948833+02	\N	2012-06-06 17:50:15.948882+02	rtmp://media.iri.centrepompidou.fr/ddc_player/	\N	\N			mp3:video/tralalere/hdes_te_0216	
2					2012-06-06 16:29:48.971169+02	\N	2012-06-08 02:21:19.548958+02	rtmp://media.iri.centrepompidou.fr/ddc_player/	\N	\N			mp3:video/tralalere/hdes_te_0224	(None, None)
1					2012-06-06 15:53:03.427725+02	\N	2012-06-08 02:26:45.471849+02	rtmp://media.iri.centrepompidou.fr/ddc_player/	\N	\N			mp3:video/tralalere/hdes_te_0209	(None, None)
\.


--
-- TOC entry 2621 (class 0 OID 120454)
-- Dependencies: 222
-- Data for Name: ldt_utils_project; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY ldt_utils_project (id, owner_id, ldt_id, ldt, title, creation_date, modification_date, created_by, changed_by, state, description, image) FROM stdin;
3	1	156c66cc-afe5-11e1-807a-58b035f6b93d	<iri>\n  <project abstract="" title="front project : Au clair de la lune" user="admin" id="156c66cc-afe5-11e1-807a-58b035f6b93d"/>\n  <medias>\n    <media id="a8c730ee-afe4-11e1-81dc-58b035f6b93d" src="http://localhost/~ymh/tralalere/static/media/ldt/a8c730ee-afe4-11e1-81dc-58b035f6b93d/a8c730ee-afe4-11e1-81dc-58b035f6b93d.iri" video="rtmp://media.iri.centrepompidou.fr/ddc_player/" pict="" extra=""/>\n  </medias>\n  <annotations>\n    <content id="a8c730ee-afe4-11e1-81dc-58b035f6b93d">\n      <ensemble title="Personal cutting" id="g_15aa56ee-afe5-11e1-b56b-58b035f6b93d" author="undefined" abstract="" idProject="156c66cc-afe5-11e1-807a-58b035f6b93d">\n        <decoupage author="perso" id="c_15aa5c02-afe5-11e1-a2e9-58b035f6b93d">\n          <title>chapitrage</title>\n          <abstract/>\n          <elements/>\n        </decoupage>\n        <decoupage author="perso" id="c_15aa5ef0-afe5-11e1-902e-58b035f6b93d">\n          <title>contributions</title>\n          <abstract/>\n          <elements/>\n        </decoupage>\n      </ensemble>\n    </content>\n  </annotations>\n  <displays>\n    <display id="0" title="Init view" idsel="a8c730ee-afe4-11e1-81dc-58b035f6b93d" tc="0" zoom="0" scroll="0" infoBAB="">\n      <content id="a8c730ee-afe4-11e1-81dc-58b035f6b93d">\n        <decoupage idens="g_15aa56ee-afe5-11e1-b56b-58b035f6b93d" id="c_15aa5c02-afe5-11e1-a2e9-58b035f6b93d" tagSelect=""/>\n        <decoupage idens="g_15aa56ee-afe5-11e1-b56b-58b035f6b93d" id="c_15aa5ef0-afe5-11e1-902e-58b035f6b93d" tagSelect=""/>\n      </content>\n    </display>\n  </displays>\n  <edits/>\n</iri>\n	front project : Au clair de la lune	2012-06-06 16:37:03.962543+02	2012-06-08 02:31:48.861149+02	admin	admin	2		thumbnails/contents/content_default_icon.png
4	1	6ae4921e-afe5-11e1-8f11-58b035f6b93d	<iri>\n  <project abstract="" title="front project : Au clair de la lune (instrumental)" user="admin" id="6ae4921e-afe5-11e1-8f11-58b035f6b93d"/>\n  <medias>\n    <media id="3f0148e8-afe5-11e1-9960-58b035f6b93d" src="http://localhost/~ymh/tralalere/static/media/ldt/3f0148e8-afe5-11e1-9960-58b035f6b93d/3f0148e8-afe5-11e1-9960-58b035f6b93d.iri" video="rtmp://media.iri.centrepompidou.fr/ddc_player/" pict="" extra=""/>\n  </medias>\n  <annotations>\n    <content id="3f0148e8-afe5-11e1-9960-58b035f6b93d">\n      <ensemble title="Personal cutting" id="g_6af7d459-afe5-11e1-bcf2-58b035f6b93d" author="undefined" abstract="" idProject="6ae4921e-afe5-11e1-8f11-58b035f6b93d">\n        <decoupage author="perso" id="c_6af7d98c-afe5-11e1-a917-58b035f6b93d">\n          <title>chapitrage</title>\n          <abstract/>\n          <elements/>\n        </decoupage>\n        <decoupage author="perso" id="c_6af7dc0c-afe5-11e1-91b2-58b035f6b93d">\n          <title>contributions</title>\n          <abstract/>\n          <elements/>\n        </decoupage>\n      </ensemble>\n    </content>\n  </annotations>\n  <displays>\n    <display id="0" title="Init view" idsel="3f0148e8-afe5-11e1-9960-58b035f6b93d" tc="0" zoom="0" scroll="0" infoBAB="">\n      <content id="3f0148e8-afe5-11e1-9960-58b035f6b93d">\n        <decoupage idens="g_6af7d459-afe5-11e1-bcf2-58b035f6b93d" id="c_6af7d98c-afe5-11e1-a917-58b035f6b93d" tagSelect=""/>\n        <decoupage idens="g_6af7d459-afe5-11e1-bcf2-58b035f6b93d" id="c_6af7dc0c-afe5-11e1-91b2-58b035f6b93d" tagSelect=""/>\n      </content>\n    </display>\n  </displays>\n  <edits/>\n</iri>\n	front project : Au clair de la lune (instrumental)	2012-06-06 16:39:27.356447+02	2012-06-08 02:31:48.865214+02	admin	admin	1		thumbnails/contents/content_default_icon.png
5	1	57547297-afed-11e1-bbdd-58b035f6b93d	<iri>\n  <project abstract="" title="front project : Cadet Rousselle" user="admin" id="57547297-afed-11e1-bbdd-58b035f6b93d"/>\n  <medias>\n    <media id="168b2126-afed-11e1-9429-58b035f6b93d" src="http://localhost/~ymh/tralalere/static/media/ldt/168b2126-afed-11e1-9429-58b035f6b93d/168b2126-afed-11e1-9429-58b035f6b93d.iri" video="rtmp://media.iri.centrepompidou.fr/ddc_player/" pict="" extra=""/>\n  </medias>\n  <annotations>\n    <content id="168b2126-afed-11e1-9429-58b035f6b93d">\n      <ensemble title="Personal cutting" id="g_57ac6f85-afed-11e1-8cd8-58b035f6b93d" author="undefined" abstract="" idProject="57547297-afed-11e1-bbdd-58b035f6b93d">\n        <decoupage author="perso" id="c_57ac76bd-afed-11e1-b6b8-58b035f6b93d">\n          <title>chapitrage</title>\n          <abstract/>\n          <elements/>\n        </decoupage>\n        <decoupage author="perso" id="c_57ac7933-afed-11e1-8881-58b035f6b93d">\n          <title>contributions</title>\n          <abstract/>\n          <elements/>\n        </decoupage>\n      </ensemble>\n    </content>\n  </annotations>\n  <displays>\n    <display id="0" title="Init view" idsel="168b2126-afed-11e1-9429-58b035f6b93d" tc="0" zoom="0" scroll="0" infoBAB="">\n      <content id="168b2126-afed-11e1-9429-58b035f6b93d">\n        <decoupage idens="g_57ac6f85-afed-11e1-8cd8-58b035f6b93d" id="c_57ac76bd-afed-11e1-b6b8-58b035f6b93d" tagSelect=""/>\n        <decoupage idens="g_57ac6f85-afed-11e1-8cd8-58b035f6b93d" id="c_57ac7933-afed-11e1-8881-58b035f6b93d" tagSelect=""/>\n      </content>\n    </display>\n  </displays>\n  <edits/>\n</iri>\n	front project : Cadet Rousselle	2012-06-06 17:36:10.509027+02	2012-06-08 02:31:48.869107+02	admin	admin	2		thumbnails/contents/content_default_icon.png
7	1	fefaf454-afed-11e1-968a-58b035f6b93d	<iri>\n  <project abstract="" title="front project : Fr&#232;re Jacques" user="admin" id="fefaf454-afed-11e1-968a-58b035f6b93d"/>\n  <medias>\n    <media id="88d13054-afed-11e1-b351-58b035f6b93d" src="http://localhost/~ymh/tralalere/static/media/ldt/88d13054-afed-11e1-b351-58b035f6b93d/88d13054-afed-11e1-b351-58b035f6b93d.iri" video="rtmp://media.iri.centrepompidou.fr/ddc_player/" pict="" extra=""/>\n  </medias>\n  <annotations>\n    <content id="88d13054-afed-11e1-b351-58b035f6b93d">\n      <ensemble title="Personal cutting" id="g_ff157073-afed-11e1-bacf-58b035f6b93d" author="undefined" abstract="" idProject="fefaf454-afed-11e1-968a-58b035f6b93d">\n        <decoupage author="perso" id="c_ff157805-afed-11e1-85df-58b035f6b93d">\n          <title>chapitrage</title>\n          <abstract/>\n          <elements/>\n        </decoupage>\n        <decoupage author="perso" id="c_ff15799e-afed-11e1-9a06-58b035f6b93d">\n          <title>contributions</title>\n          <abstract/>\n          <elements/>\n        </decoupage>\n      </ensemble>\n    </content>\n  </annotations>\n  <displays>\n    <display id="0" title="Init view" idsel="88d13054-afed-11e1-b351-58b035f6b93d" tc="0" zoom="0" scroll="0" infoBAB="">\n      <content id="88d13054-afed-11e1-b351-58b035f6b93d">\n        <decoupage idens="g_ff157073-afed-11e1-bacf-58b035f6b93d" id="c_ff157805-afed-11e1-85df-58b035f6b93d" tagSelect=""/>\n        <decoupage idens="g_ff157073-afed-11e1-bacf-58b035f6b93d" id="c_ff15799e-afed-11e1-9a06-58b035f6b93d" tagSelect=""/>\n      </content>\n    </display>\n  </displays>\n  <edits/>\n</iri>\n	front project : Frère Jacques	2012-06-06 17:40:51.779751+02	2012-06-08 02:31:48.891434+02	admin	admin	2		thumbnails/contents/content_default_icon.png
16	1	ad73938f-affc-11e1-920d-58b035f6b93d	<iri>\n  <project abstract="" title="front project : Alouette" user="admin" id="ad73938f-affc-11e1-920d-58b035f6b93d"/>\n  <medias>\n    <media id="6a4d35a6-affc-11e1-b451-58b035f6b93d" src="http://localhost/~ymh/tralalere/static/media/ldt/6a4d35a6-affc-11e1-b451-58b035f6b93d/6a4d35a6-affc-11e1-b451-58b035f6b93d.iri" video="" pict="" extra=""/>\n  </medias>\n  <annotations>\n    <content id="6a4d35a6-affc-11e1-b451-58b035f6b93d">\n      <ensemble title="Personal cutting" id="g_ad9e0519-affc-11e1-a1d5-58b035f6b93d" author="undefined" abstract="" idProject="ad73938f-affc-11e1-920d-58b035f6b93d">\n        <decoupage author="perso" id="c_ad9e0d38-affc-11e1-b2cb-58b035f6b93d">\n          <title>chapitrage</title>\n          <abstract/>\n          <elements/>\n        </decoupage>\n        <decoupage author="perso" id="c_ad9e0efa-affc-11e1-910b-58b035f6b93d">\n          <title>contributions</title>\n          <abstract/>\n          <elements/>\n        </decoupage>\n      </ensemble>\n    </content>\n  </annotations>\n  <displays>\n    <display id="0" title="Init view" idsel="6a4d35a6-affc-11e1-b451-58b035f6b93d" tc="0" zoom="0" scroll="0" infoBAB="">\n      <content id="6a4d35a6-affc-11e1-b451-58b035f6b93d">\n        <decoupage idens="g_ad9e0519-affc-11e1-a1d5-58b035f6b93d" id="c_ad9e0d38-affc-11e1-b2cb-58b035f6b93d" tagSelect=""/>\n        <decoupage idens="g_ad9e0519-affc-11e1-a1d5-58b035f6b93d" id="c_ad9e0efa-affc-11e1-910b-58b035f6b93d" tagSelect=""/>\n      </content>\n    </display>\n  </displays>\n  <edits/>\n</iri>\n	front project : Alouette	2012-06-06 19:25:57.448007+02	2012-06-08 02:31:48.852501+02	admin	admin	2		thumbnails/contents/content_default_icon.png
18	1	9642edb0-affd-11e1-8b7d-58b035f6b93d	<iri>\n  <project abstract="" title="front project : Alouette (instrumental)" user="admin" id="9642edb0-affd-11e1-8b7d-58b035f6b93d"/>\n  <medias>\n    <media id="c7bf25c7-afe3-11e1-8747-58b035f6b93d" src="http://localhost/~ymh/tralalere/static/media/ldt/c7bf25c7-afe3-11e1-8747-58b035f6b93d/c7bf25c7-afe3-11e1-8747-58b035f6b93d.iri" video="rtmp://media.iri.centrepompidou.fr/ddc_player/" pict="" extra=""/>\n  </medias>\n  <annotations>\n    <content id="c7bf25c7-afe3-11e1-8747-58b035f6b93d">\n      <ensemble title="Personal cutting" id="g_9667589e-affd-11e1-a72a-58b035f6b93d" author="undefined" abstract="" idProject="9642edb0-affd-11e1-8b7d-58b035f6b93d">\n        <decoupage author="perso" id="c_96676f21-affd-11e1-89e8-58b035f6b93d">\n          <title>chapitrage</title>\n          <abstract/>\n          <elements/>\n        </decoupage>\n        <decoupage author="perso" id="c_96677719-affd-11e1-ae5e-58b035f6b93d">\n          <title>contributions</title>\n          <abstract/>\n          <elements/>\n        </decoupage>\n      </ensemble>\n    </content>\n  </annotations>\n  <displays>\n    <display id="0" title="Init view" idsel="c7bf25c7-afe3-11e1-8747-58b035f6b93d" tc="0" zoom="0" scroll="0" infoBAB="">\n      <content id="c7bf25c7-afe3-11e1-8747-58b035f6b93d">\n        <decoupage idens="g_9667589e-affd-11e1-a72a-58b035f6b93d" id="c_96676f21-affd-11e1-89e8-58b035f6b93d" tagSelect=""/>\n        <decoupage idens="g_9667589e-affd-11e1-a72a-58b035f6b93d" id="c_96677719-affd-11e1-ae5e-58b035f6b93d" tagSelect=""/>\n      </content>\n    </display>\n  </displays>\n  <edits/>\n</iri>\n	front project : Alouette (instrumental)	2012-06-06 19:32:28.045297+02	2012-06-08 02:31:48.856774+02	admin	admin	1		thumbnails/contents/c7bf25c7-afe3-11e1-8747-58b035f6b93d.jpg
6	1	848fc851-afed-11e1-8bf9-58b035f6b93d	<iri>\n  <project abstract="" title="front project : Cadet Rousselle (instrumental)" user="admin" id="848fc851-afed-11e1-8bf9-58b035f6b93d"/>\n  <medias>\n    <media id="5ca8712b-afed-11e1-86d7-58b035f6b93d" src="http://localhost/~ymh/tralalere/static/media/ldt/5ca8712b-afed-11e1-86d7-58b035f6b93d/5ca8712b-afed-11e1-86d7-58b035f6b93d.iri" video="rtmp://media.iri.centrepompidou.fr/ddc_player/" pict="" extra=""/>\n  </medias>\n  <annotations>\n    <content id="5ca8712b-afed-11e1-86d7-58b035f6b93d">\n      <ensemble title="Personal cutting" id="g_84a7d37a-afed-11e1-aace-58b035f6b93d" author="undefined" abstract="" idProject="848fc851-afed-11e1-8bf9-58b035f6b93d">\n        <decoupage author="perso" id="c_84a7d74c-afed-11e1-90fe-58b035f6b93d">\n          <title>chapitrage</title>\n          <abstract/>\n          <elements/>\n        </decoupage>\n        <decoupage author="perso" id="c_84a7d8c0-afed-11e1-a66e-58b035f6b93d">\n          <title>contributions</title>\n          <abstract/>\n          <elements/>\n        </decoupage>\n      </ensemble>\n    </content>\n  </annotations>\n  <displays>\n    <display id="0" title="Init view" idsel="5ca8712b-afed-11e1-86d7-58b035f6b93d" tc="0" zoom="0" scroll="0" infoBAB="">\n      <content id="5ca8712b-afed-11e1-86d7-58b035f6b93d">\n        <decoupage idens="g_84a7d37a-afed-11e1-aace-58b035f6b93d" id="c_84a7d74c-afed-11e1-90fe-58b035f6b93d" tagSelect=""/>\n        <decoupage idens="g_84a7d37a-afed-11e1-aace-58b035f6b93d" id="c_84a7d8c0-afed-11e1-a66e-58b035f6b93d" tagSelect=""/>\n      </content>\n    </display>\n  </displays>\n  <edits/>\n</iri>\n	front project : Cadet Rousselle (instrumental)	2012-06-06 17:37:26.395348+02	2012-06-08 02:31:48.873138+02	admin	admin	1		thumbnails/contents/content_default_icon.png
8	1	42a3fc0a-afee-11e1-82e8-58b035f6b93d	<iri>\n  <project abstract="" title="front project : Pirouette" user="admin" id="42a3fc0a-afee-11e1-82e8-58b035f6b93d"/>\n  <medias>\n    <media id="0595b6bd-afee-11e1-a00e-58b035f6b93d" src="http://localhost/~ymh/tralalere/static/media/ldt/0595b6bd-afee-11e1-a00e-58b035f6b93d/0595b6bd-afee-11e1-a00e-58b035f6b93d.iri" video="rtmp://media.iri.centrepompidou.fr/ddc_player/" pict="" extra=""/>\n  </medias>\n  <annotations>\n    <content id="0595b6bd-afee-11e1-a00e-58b035f6b93d">\n      <ensemble title="Personal cutting" id="g_42b91451-afee-11e1-b00f-58b035f6b93d" author="undefined" abstract="" idProject="42a3fc0a-afee-11e1-82e8-58b035f6b93d">\n        <decoupage author="perso" id="c_42b91933-afee-11e1-b7f2-58b035f6b93d">\n          <title>chapitrage</title>\n          <abstract/>\n          <elements/>\n        </decoupage>\n        <decoupage author="perso" id="c_42b91acc-afee-11e1-9a63-58b035f6b93d">\n          <title>contributions</title>\n          <abstract/>\n          <elements/>\n        </decoupage>\n      </ensemble>\n    </content>\n  </annotations>\n  <displays>\n    <display id="0" title="Init view" idsel="0595b6bd-afee-11e1-a00e-58b035f6b93d" tc="0" zoom="0" scroll="0" infoBAB="">\n      <content id="0595b6bd-afee-11e1-a00e-58b035f6b93d">\n        <decoupage idens="g_42b91451-afee-11e1-b00f-58b035f6b93d" id="c_42b91933-afee-11e1-b7f2-58b035f6b93d" tagSelect=""/>\n        <decoupage idens="g_42b91451-afee-11e1-b00f-58b035f6b93d" id="c_42b91acc-afee-11e1-9a63-58b035f6b93d" tagSelect=""/>\n      </content>\n    </display>\n  </displays>\n  <edits/>\n</iri>\n	front project : Pirouette	2012-06-06 17:42:45.294891+02	2012-06-08 02:31:48.89555+02	admin	admin	2		thumbnails/contents/content_default_icon.png
9	1	1e90d7cf-afef-11e1-8b8b-58b035f6b93d	<iri>\n  <project abstract="" title="front project : Ya une pie" user="admin" id="1e90d7cf-afef-11e1-8b8b-58b035f6b93d"/>\n  <medias>\n    <media id="fb9d5a9e-afee-11e1-a770-58b035f6b93d" src="http://localhost/~ymh/tralalere/static/media/ldt/fb9d5a9e-afee-11e1-a770-58b035f6b93d/fb9d5a9e-afee-11e1-a770-58b035f6b93d.iri" video="rtmp://media.iri.centrepompidou.fr/ddc_player/" pict="" extra=""/>\n  </medias>\n  <annotations>\n    <content id="fb9d5a9e-afee-11e1-a770-58b035f6b93d">\n      <ensemble title="Personal cutting" id="g_1ea85c00-afef-11e1-9db9-58b035f6b93d" author="undefined" abstract="" idProject="1e90d7cf-afef-11e1-8b8b-58b035f6b93d">\n        <decoupage author="perso" id="c_1ea8619e-afef-11e1-962c-58b035f6b93d">\n          <title>chapitrage</title>\n          <abstract/>\n          <elements/>\n        </decoupage>\n        <decoupage author="perso" id="c_1ea86402-afef-11e1-85d7-58b035f6b93d">\n          <title>contributions</title>\n          <abstract/>\n          <elements/>\n        </decoupage>\n      </ensemble>\n    </content>\n  </annotations>\n  <displays>\n    <display id="0" title="Init view" idsel="fb9d5a9e-afee-11e1-a770-58b035f6b93d" tc="0" zoom="0" scroll="0" infoBAB="">\n      <content id="fb9d5a9e-afee-11e1-a770-58b035f6b93d">\n        <decoupage idens="g_1ea85c00-afef-11e1-9db9-58b035f6b93d" id="c_1ea8619e-afef-11e1-962c-58b035f6b93d" tagSelect=""/>\n        <decoupage idens="g_1ea85c00-afef-11e1-9db9-58b035f6b93d" id="c_1ea86402-afef-11e1-85d7-58b035f6b93d" tagSelect=""/>\n      </content>\n    </display>\n  </displays>\n  <edits/>\n</iri>\n	front project : Ya une pie	2012-06-06 17:48:54.26819+02	2012-06-08 02:31:48.899541+02	admin	admin	2		thumbnails/contents/content_default_icon.png
10	1	4f4d41fd-afef-11e1-8211-58b035f6b93d	<iri>\n  <project abstract="" title="front project : Ya une pie (instrumental)" user="admin" id="4f4d41fd-afef-11e1-8211-58b035f6b93d"/>\n  <medias>\n    <media id="247de85c-afef-11e1-9e56-58b035f6b93d" src="http://localhost/~ymh/tralalere/static/media/ldt/247de85c-afef-11e1-9e56-58b035f6b93d/247de85c-afef-11e1-9e56-58b035f6b93d.iri" video="rtmp://media.iri.centrepompidou.fr/ddc_player/" pict="" extra=""/>\n  </medias>\n  <annotations>\n    <content id="247de85c-afef-11e1-9e56-58b035f6b93d">\n      <ensemble title="Personal cutting" id="g_4f5ad507-afef-11e1-a63b-58b035f6b93d" author="undefined" abstract="" idProject="4f4d41fd-afef-11e1-8211-58b035f6b93d">\n        <decoupage author="perso" id="c_4f5adb5c-afef-11e1-b5b0-58b035f6b93d">\n          <title>chapitrage</title>\n          <abstract/>\n          <elements/>\n        </decoupage>\n        <decoupage author="perso" id="c_4f5addab-afef-11e1-a7e2-58b035f6b93d">\n          <title>contributions</title>\n          <abstract/>\n          <elements/>\n        </decoupage>\n      </ensemble>\n    </content>\n  </annotations>\n  <displays>\n    <display id="0" title="Init view" idsel="247de85c-afef-11e1-9e56-58b035f6b93d" tc="0" zoom="0" scroll="0" infoBAB="">\n      <content id="247de85c-afef-11e1-9e56-58b035f6b93d">\n        <decoupage idens="g_4f5ad507-afef-11e1-a63b-58b035f6b93d" id="c_4f5adb5c-afef-11e1-b5b0-58b035f6b93d" tagSelect=""/>\n        <decoupage idens="g_4f5ad507-afef-11e1-a63b-58b035f6b93d" id="c_4f5addab-afef-11e1-a7e2-58b035f6b93d" tagSelect=""/>\n      </content>\n    </display>\n  </displays>\n  <edits/>\n</iri>\n	front project : Ya une pie (instrumental)	2012-06-06 17:50:16.03359+02	2012-06-08 02:31:48.903797+02	admin	admin	1		thumbnails/contents/content_default_icon.png
\.


--
-- TOC entry 2622 (class 0 OID 120468)
-- Dependencies: 224
-- Data for Name: ldt_utils_project_contents; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY ldt_utils_project_contents (id, project_id, content_id) FROM stdin;
1	3	3
2	4	4
3	5	5
4	6	6
5	7	7
6	8	8
7	9	9
8	10	10
14	16	12
16	18	2
\.


--
-- TOC entry 2623 (class 0 OID 120478)
-- Dependencies: 226
-- Data for Name: ldt_utils_segment; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY ldt_utils_segment (id, project_obj_id, content_id, project_id, iri_id, ensemble_id, cutting_id, element_id, tags, title, duration, start_ts, author, date, abstract, polemics) FROM stdin;
\.


--
-- TOC entry 2605 (class 0 OID 120188)
-- Dependencies: 191
-- Data for Name: oauth_provider_consumer; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY oauth_provider_consumer (id, name, description, key, secret, status, user_id) FROM stdin;
\.


--
-- TOC entry 2603 (class 0 OID 120166)
-- Dependencies: 187
-- Data for Name: oauth_provider_nonce; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY oauth_provider_nonce (id, token_key, consumer_key, key) FROM stdin;
\.


--
-- TOC entry 2604 (class 0 OID 120177)
-- Dependencies: 189
-- Data for Name: oauth_provider_resource; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY oauth_provider_resource (id, name, url, is_readonly) FROM stdin;
\.


--
-- TOC entry 2606 (class 0 OID 120204)
-- Dependencies: 193
-- Data for Name: oauth_provider_token; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY oauth_provider_token (id, key, secret, token_type, "timestamp", is_approved, user_id, consumer_id, resource_id, verifier, callback, callback_confirmed) FROM stdin;
\.


--
-- TOC entry 2610 (class 0 OID 120257)
-- Dependencies: 201
-- Data for Name: piston_consumer; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY piston_consumer (id, name, description, key, secret, status, user_id) FROM stdin;
\.


--
-- TOC entry 2609 (class 0 OID 120249)
-- Dependencies: 199
-- Data for Name: piston_nonce; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY piston_nonce (id, token_key, consumer_key, key) FROM stdin;
\.


--
-- TOC entry 2611 (class 0 OID 120273)
-- Dependencies: 203
-- Data for Name: piston_token; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY piston_token (id, key, secret, verifier, token_type, "timestamp", is_approved, user_id, consumer_id, callback, callback_confirmed) FROM stdin;
\.


--
-- TOC entry 2600 (class 0 OID 120120)
-- Dependencies: 181
-- Data for Name: registration_registrationprofile; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY registration_registrationprofile (id, user_id, activation_key) FROM stdin;
\.


--
-- TOC entry 2614 (class 0 OID 120317)
-- Dependencies: 209
-- Data for Name: social_auth_association; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY social_auth_association (id, server_url, handle, secret, issued, lifetime, assoc_type) FROM stdin;
\.


--
-- TOC entry 2613 (class 0 OID 120309)
-- Dependencies: 207
-- Data for Name: social_auth_nonce; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY social_auth_nonce (id, server_url, "timestamp", salt) FROM stdin;
\.


--
-- TOC entry 2612 (class 0 OID 120291)
-- Dependencies: 205
-- Data for Name: social_auth_usersocialauth; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY social_auth_usersocialauth (id, user_id, provider, uid, extra_data) FROM stdin;
\.


--
-- TOC entry 2615 (class 0 OID 120328)
-- Dependencies: 211
-- Data for Name: south_migrationhistory; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY south_migrationhistory (id, app_name, migration, applied) FROM stdin;
1	core	0001_initial	2012-06-06 11:53:15.62102+02
2	ldt_utils	0001_initial	2012-06-06 11:53:15.827905+02
3	ldt_utils	0002_auto__add_field_media_mimetype_field__chg_field_media_external_src_url	2012-06-06 11:53:15.987365+02
4	ldt_utils	0003_auto__chg_field_project_owner	2012-06-06 11:53:16.065425+02
5	core	0002_auto__del_owner	2012-06-06 11:53:16.078261+02
6	user	0001_initial	2012-06-06 11:53:16.268236+02
7	user	0002_auto__del_irigroup	2012-06-06 11:53:16.290634+02
8	user	0003_auto__add_userprofile	2012-06-06 11:53:16.320983+02
9	user	0004_fill_language	2012-06-06 11:53:16.336767+02
10	user	0005_add_permission_owner_group	2012-06-06 11:53:16.357911+02
11	user	0006_auto__add_field_userprofile_image	2012-06-06 11:53:16.387444+02
12	user	0007_auto__add_groupprofile	2012-06-06 11:53:16.421515+02
13	ldt_utils	0004_auto__add_field_project_description	2012-06-06 11:53:16.45337+02
14	guardian	0001_initial	2012-06-06 11:53:16.52245+02
15	guardian	0002_auto__add_field_groupobjectpermission_object_pk__add_field_userobjectp	2012-06-06 11:53:16.592874+02
16	guardian	0003_update_objectpermission_object_pk	2012-06-06 11:53:16.620624+02
17	guardian	0004_auto__del_field_groupobjectpermission_object_id__del_unique_groupobjec	2012-06-06 11:53:16.82206+02
18	guardian	0005_auto__chg_field_groupobjectpermission_object_pk__chg_field_userobjectp	2012-06-06 11:53:16.848081+02
19	ldt_utils	0005_add_permissions	2012-06-06 11:53:16.903005+02
20	ldt_utils	0006_auto__add_field_media_image	2012-06-06 11:53:16.94915+02
21	ldt_utils	0007_auto__add_field_content_image__del_field_media_image	2012-06-06 11:53:17.000559+02
22	ldt_utils	0008_auto__add_field_project_image	2012-06-06 11:53:17.051569+02
23	ldt_utils	0009_auto__chg_field_content_image__chg_field_project_image	2012-06-06 11:53:17.183102+02
24	ldt_utils	0010_auto__add_annotationstat	2012-06-06 11:53:17.248158+02
25	ldt_utils	0011_gen_stat_annotation	2012-06-06 11:53:17.281123+02
26	ldt_utils	0012_auto__add_field_content_last_annotated	2012-06-06 11:53:17.329024+02
27	ldt_utils	0013_auto__add_field_content_front_project__chg_field_content_last_annotate	2012-06-06 11:53:17.445871+02
28	ldt_utils	0014_auto__del_annotationstat__chg_field_content_last_annotated	2012-06-06 11:53:17.504152+02
29	ldt_utils	0015_auto__add_contentstat__del_field_content_last_annotated__del_field_con	2012-06-06 11:53:17.583993+02
30	ldt_utils	0016_one_to_one_stat_annotation	2012-06-06 11:53:17.745002+02
31	text	0001_initial	2012-06-06 11:53:17.996091+02
33	ldt_utils	0017_correct_image_path	2012-06-08 02:31:48.91+02
\.


--
-- TOC entry 2601 (class 0 OID 120135)
-- Dependencies: 183
-- Data for Name: tagging_tag; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY tagging_tag (id, name) FROM stdin;
1	henri des
2	tralalere
3	steve waring
4	jolies chansons d'enfance
\.


--
-- TOC entry 2602 (class 0 OID 120145)
-- Dependencies: 185
-- Data for Name: tagging_taggeditem; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY tagging_taggeditem (id, tag_id, content_type_id, object_id) FROM stdin;
1	1	27	1
2	2	27	1
3	3	27	3
4	2	27	3
5	3	27	4
6	2	27	4
7	3	27	5
8	2	27	5
9	3	27	6
10	2	27	6
11	4	27	7
12	2	27	7
13	4	27	8
14	2	27	8
15	1	27	9
16	2	27	9
17	1	27	10
18	2	27	10
19	1	27	12
20	2	27	12
21	1	27	2
22	2	27	2
\.


--
-- TOC entry 2630 (class 0 OID 120863)
-- Dependencies: 239
-- Data for Name: text_annotation; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY text_annotation (id, external_id, uri, tags_field, title, description, text, color, creator, contributor, creation_date, update_date) FROM stdin;
\.


--
-- TOC entry 2616 (class 0 OID 120337)
-- Dependencies: 212
-- Data for Name: thumbnail_kvstore; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY thumbnail_kvstore (key, value) FROM stdin;
sorl-thumbnail||image||0d4b1104d0703f9b1c1d355da70a4cee	{"storage": "django.core.files.storage.FileSystemStorage", "name": "/Users/ymh/dev/workspace/tralalere/web/static/media/thumbnails/contents/28606717-afdf-11e1-9e3c-58b035f6b93d.jpg", "size": [348, 310]}
sorl-thumbnail||image||6afddde1c480ed991a779f503a16d8ee	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/70/0d/700d021eac0d0be57896eaf66bf7573c.png", "size": [112, 100]}
sorl-thumbnail||image||b302db7516c9071b7e2fb5e12e367366	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/77/b5/77b55d09ce2567b28c0185e749ecc0c8.png", "size": [50, 50]}
sorl-thumbnail||image||1850ab98840d165be61e39f7979c624d	{"storage": "django.core.files.storage.FileSystemStorage", "name": "/Users/ymh/dev/workspace/tralalere/web/static/media/thumbnails/contents/c7bf25c7-afe3-11e1-8747-58b035f6b93d.jpg", "size": [348, 310]}
sorl-thumbnail||image||1e37bfa9adc28402a4a39c4a52dad141	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/73/c4/73c4df8adaf645c259fdb172a3ff4d0e.png", "size": [112, 100]}
sorl-thumbnail||image||29a2650e8b7288f4b5b3337bc97fa0b1	{"storage": "django.core.files.storage.FileSystemStorage", "name": "/Users/ymh/dev/workspace/tralalere/web/static/media/thumbnails/contents/0595b6bd-afee-11e1-a00e-58b035f6b93d.jpg", "size": [348, 310]}
sorl-thumbnail||image||4db2e059687f723d39b9e3d3e758e273	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/21/a1/21a1bfe5619b909dc5180f51be613d62.png", "size": [50, 50]}
sorl-thumbnail||thumbnails||43b48df88e6e67e92ec9b7a3d7dbb94e	["a4079da4aa3f31f8f16eff7f613eb049", "7400dc710b3c60d77645ae6413893767"]
sorl-thumbnail||image||43b48df88e6e67e92ec9b7a3d7dbb94e	{"storage": "django.core.files.storage.FileSystemStorage", "name": "/Users/ymh/dev/workspace/tralalere/web/static/media/thumbnails/contents/a8c730ee-afe4-11e1-81dc-58b035f6b93d.jpg", "size": [348, 310]}
sorl-thumbnail||image||7400dc710b3c60d77645ae6413893767	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/c4/cf/c4cf562519b202cd068b228772b7033d.png", "size": [50, 50]}
sorl-thumbnail||thumbnails||bd4a83b5656dc0280365af1bebe77bab	["c0834e7cc05d1858ede0cb22a154f0cb", "3e244a19c86fa40847641510374043f3"]
sorl-thumbnail||image||b026c2896fde12dfc71000c053aa0584	{"storage": "django.core.files.storage.FileSystemStorage", "name": "/Users/ymh/dev/workspace/tralalere/web/static/media/thumbnails/contents/3f0148e8-afe5-11e1-9960-58b035f6b93d.jpg", "size": [348, 310]}
sorl-thumbnail||image||6d721bdb409fd09a305a70b10e0959aa	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/4a/1e/4a1ef1fb9cf36629cf7f9e75c16d00d7.png", "size": [50, 50]}
sorl-thumbnail||thumbnails||b026c2896fde12dfc71000c053aa0584	["6d721bdb409fd09a305a70b10e0959aa"]
sorl-thumbnail||image||bd4a83b5656dc0280365af1bebe77bab	{"storage": "django.core.files.storage.FileSystemStorage", "name": "/Users/ymh/dev/workspace/tralalere/web/static/media/thumbnails/contents/168b2126-afed-11e1-9429-58b035f6b93d.jpg", "size": [348, 310]}
sorl-thumbnail||image||3e244a19c86fa40847641510374043f3	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/4d/fb/4dfbb2282d755f6b7f7d5efaa4680d8f.png", "size": [50, 50]}
sorl-thumbnail||thumbnails||b36b41142892a745ca8934edab6bd73e	["48d57a54f52b58f4d2e03d5e4c27a27c", "c1dc2b66965fb0bf6eb0f00d2e6d268c"]
sorl-thumbnail||image||ad32024c13b4261c48540446d92b87e7	{"storage": "django.core.files.storage.FileSystemStorage", "name": "/Users/ymh/dev/workspace/tralalere/web/static/media/thumbnails/contents/5ca8712b-afed-11e1-86d7-58b035f6b93d.jpg", "size": [348, 310]}
sorl-thumbnail||image||e19058f852ff19ba8e00089c435f7b2f	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/3f/30/3f309a1ce408ac9629ae55f6862c0fde.png", "size": [50, 50]}
sorl-thumbnail||thumbnails||ad32024c13b4261c48540446d92b87e7	["e19058f852ff19ba8e00089c435f7b2f"]
sorl-thumbnail||image||b36b41142892a745ca8934edab6bd73e	{"storage": "django.core.files.storage.FileSystemStorage", "name": "/Users/ymh/dev/workspace/tralalere/web/static/media/thumbnails/contents/88d13054-afed-11e1-b351-58b035f6b93d.jpg", "size": [348, 310]}
sorl-thumbnail||image||48d57a54f52b58f4d2e03d5e4c27a27c	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/f6/ea/f6ea18c04312a49051db22196b749cc7.png", "size": [50, 50]}
sorl-thumbnail||thumbnails||29a2650e8b7288f4b5b3337bc97fa0b1	["3d880f7b66ae1c70cb9ae4bf24dfeac8", "2d43568873939ed26830f11519ab87b5"]
sorl-thumbnail||image||3d880f7b66ae1c70cb9ae4bf24dfeac8	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/d0/91/d0918fc024e6cd4b522179b095ce32eb.png", "size": [50, 50]}
sorl-thumbnail||thumbnails||3005ec2035a3a865d9a13b387369e075	["1424dc05dcb14be25c50f1b2854929f5", "4caa10d48238ce1420c1d4b8603d2539"]
sorl-thumbnail||image||3005ec2035a3a865d9a13b387369e075	{"storage": "django.core.files.storage.FileSystemStorage", "name": "/Users/ymh/dev/workspace/tralalere/web/static/media/thumbnails/contents/fb9d5a9e-afee-11e1-a770-58b035f6b93d.jpg", "size": [348, 310]}
sorl-thumbnail||image||1424dc05dcb14be25c50f1b2854929f5	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/0d/bb/0dbb4b3472ef1d88c288e5820a36cd73.png", "size": [50, 50]}
sorl-thumbnail||image||c54cc0f91ba2e5d1c700ea649f750c5c	{"storage": "django.core.files.storage.FileSystemStorage", "name": "/Users/ymh/dev/workspace/tralalere/web/static/media/thumbnails/contents/247de85c-afef-11e1-9e56-58b035f6b93d.jpg", "size": [348, 310]}
sorl-thumbnail||image||45997c5a75edbdb161dd2c203275cf30	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/27/09/270956ba389ddb062fd6fda095c12f8e.png", "size": [50, 50]}
sorl-thumbnail||image||9e7697dd5e630f5310b2746a719b568b	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/95/2e/952ef78b77fb820f19f695d09830a2ed.png", "size": [112, 100]}
sorl-thumbnail||thumbnails||c54cc0f91ba2e5d1c700ea649f750c5c	["45997c5a75edbdb161dd2c203275cf30", "9e7697dd5e630f5310b2746a719b568b"]
sorl-thumbnail||image||9c75f052bc23667cc4e3e1e1aae72e09	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/81/e8/81e8315cedca2708c5844a9bb58ffe6f.png", "size": [50, 50]}
sorl-thumbnail||thumbnails||0d4b1104d0703f9b1c1d355da70a4cee	["b302db7516c9071b7e2fb5e12e367366", "6afddde1c480ed991a779f503a16d8ee", "9c75f052bc23667cc4e3e1e1aae72e09"]
sorl-thumbnail||image||9b86d422a3022c11257903f29b90f159	{"storage": "django.core.files.storage.FileSystemStorage", "name": "/Users/ymh/dev/workspace/tralalere/web/static/media/thumbnails/contents/4f07de99-aff7-11e1-89df-58b035f6b93d.jpg", "size": [348, 310]}
sorl-thumbnail||image||a2fae590302d8a809cfa3d5fe36f10f2	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/a9/f7/a9f785ed3b593e1c6d944df31f68c3ce.png", "size": [50, 50]}
sorl-thumbnail||thumbnails||9b86d422a3022c11257903f29b90f159	["a2fae590302d8a809cfa3d5fe36f10f2"]
sorl-thumbnail||image||49dddff542d7d067fbc04b955a207ac0	{"storage": "django.core.files.storage.FileSystemStorage", "name": "/Users/ymh/dev/workspace/tralalere/web/static/media/thumbnails/contents/6a4d35a6-affc-11e1-b451-58b035f6b93d.jpg", "size": [348, 310]}
sorl-thumbnail||image||26bd0bf89f1f277af993647bcd05ac80	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/24/93/2493ee1015dfeaf1eaa44ece2a362461.png", "size": [50, 50]}
sorl-thumbnail||image||b21a9dfb4dc4bdf13b5c073031324aec	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/a5/81/a581ee20fe10536e7929061347748b8d.png", "size": [50, 50]}
sorl-thumbnail||thumbnails||1850ab98840d165be61e39f7979c624d	["b21a9dfb4dc4bdf13b5c073031324aec", "1e37bfa9adc28402a4a39c4a52dad141", "4db2e059687f723d39b9e3d3e758e273"]
sorl-thumbnail||image||6bf61dc31c37a274a49c26d63cdbb682	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/47/60/476067be7d7e056b41e85c574b643c35.png", "size": [135, 120]}
sorl-thumbnail||image||41925664c4cab8d5685442ce914f0c33	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/c9/81/c98106d23342a69a1a41d014fd997632.png", "size": [135, 120]}
sorl-thumbnail||image||a4079da4aa3f31f8f16eff7f613eb049	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/6a/7a/6a7a67fa0f6c335161e39cae3ea53aa3.png", "size": [135, 120]}
sorl-thumbnail||image||c0834e7cc05d1858ede0cb22a154f0cb	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/15/1e/151e877050b64e800ff34d1b59acd9a1.png", "size": [135, 120]}
sorl-thumbnail||image||c1dc2b66965fb0bf6eb0f00d2e6d268c	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/d7/7a/d77ad12db6182c1e9992c54136a22daa.png", "size": [135, 120]}
sorl-thumbnail||image||2d43568873939ed26830f11519ab87b5	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/5b/6e/5b6ec232602efe7453204d29a28c4685.png", "size": [135, 120]}
sorl-thumbnail||image||4caa10d48238ce1420c1d4b8603d2539	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/0b/e2/0be25db33a31f9cf9ef92506721ffc3e.png", "size": [135, 120]}
sorl-thumbnail||image||b60a7f62e01ba74785c8ad4506d1be41	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/32/43/3243345e73a95971b90a2d0d35a801a8.png", "size": [213, 190]}
sorl-thumbnail||thumbnails||49dddff542d7d067fbc04b955a207ac0	["b60a7f62e01ba74785c8ad4506d1be41", "26bd0bf89f1f277af993647bcd05ac80", "6bf61dc31c37a274a49c26d63cdbb682"]
sorl-thumbnail||image||a09d015af6095120c8b3d64fb3c6ccf2	{"storage": "django.core.files.storage.FileSystemStorage", "name": "thumbnails/contents/6a4d35a6-affc-11e1-b451-58b035f6b93d.jpg", "size": [348, 310]}
sorl-thumbnail||image||9d8eef0a84ef5dc79f1743fdeef3f415	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/b5/66/b5665816245cfd71935450c9e02c6fc5.png", "size": [135, 120]}
sorl-thumbnail||image||e0b28a9e50fd63d4693f332b3c66ea10	{"storage": "django.core.files.storage.FileSystemStorage", "name": "thumbnails/contents/a8c730ee-afe4-11e1-81dc-58b035f6b93d.jpg", "size": [348, 310]}
sorl-thumbnail||image||4d0e6149dede158f60ef81135a6873a6	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/95/14/95149aab25b604b5c62a3bdc9cca0caf.png", "size": [135, 120]}
sorl-thumbnail||thumbnails||028816968a98b3674d35bd6557b96655	["a7bca3767fa4a6bdb8f540e3d467eb67", "41925664c4cab8d5685442ce914f0c33"]
sorl-thumbnail||image||8340de80e2d1bfa47bd039e77b80631f	{"storage": "django.core.files.storage.FileSystemStorage", "name": "thumbnails/contents/168b2126-afed-11e1-9429-58b035f6b93d.jpg", "size": [348, 310]}
sorl-thumbnail||image||9cf8babe64a8f1ae3f39fd65018c7bcc	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/22/9f/229f7648a3e2b54f72f9ccf144f9f316.png", "size": [135, 120]}
sorl-thumbnail||thumbnails||fe0a2a04177ed09b169dd3b16617deb9	["21b21a3fb592d99e35a14072a2c6b9fe", "c8e7d53b1e39f78e19f036cad7003403"]
sorl-thumbnail||image||028816968a98b3674d35bd6557b96655	{"storage": "django.core.files.storage.FileSystemStorage", "name": "thumbnails/contents/88d13054-afed-11e1-b351-58b035f6b93d.jpg", "size": [348, 310]}
sorl-thumbnail||thumbnails||a9ec7d0b51b07203b7612105fa1e2e0f	["e90b3be400d8552618efe22e26146700", "70dab4eecd5b9ea2eb5fbe6607023dad"]
sorl-thumbnail||image||fe0a2a04177ed09b169dd3b16617deb9	{"storage": "django.core.files.storage.FileSystemStorage", "name": "thumbnails/contents/0595b6bd-afee-11e1-a00e-58b035f6b93d.jpg", "size": [348, 310]}
sorl-thumbnail||image||21b21a3fb592d99e35a14072a2c6b9fe	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/59/4b/594b8ebc0f730d4316eac7ac81e8d136.png", "size": [135, 120]}
sorl-thumbnail||image||a9ec7d0b51b07203b7612105fa1e2e0f	{"storage": "django.core.files.storage.FileSystemStorage", "name": "thumbnails/contents/fb9d5a9e-afee-11e1-a770-58b035f6b93d.jpg", "size": [348, 310]}
sorl-thumbnail||image||70dab4eecd5b9ea2eb5fbe6607023dad	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/99/e4/99e4521b1fc19e0180e69372ba463052.png", "size": [135, 120]}
sorl-thumbnail||image||ebd488a5dfc12a1a04dddc7aba5ba2d2	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/b9/2f/b92f78d7e81c3e5becba6df8765897a2.png", "size": [112, 100]}
sorl-thumbnail||thumbnails||a09d015af6095120c8b3d64fb3c6ccf2	["9d8eef0a84ef5dc79f1743fdeef3f415", "ebd488a5dfc12a1a04dddc7aba5ba2d2"]
sorl-thumbnail||image||fdfd766abbbf2813fa5e4a147ad24127	{"storage": "django.core.files.storage.FileSystemStorage", "name": "thumbnails/contents/6a4d35a6-affc-11e1-b451-58b035f6b93d_1.jpg", "size": [348, 310]}
sorl-thumbnail||image||e16d212a5a5e6b5def29996fcde73c39	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/e4/9a/e49af56391c7c20d7b03067d75e235ec.png", "size": [112, 100]}
sorl-thumbnail||image||fac7862e08fdaed499cd9658f0aa190a	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/aa/c8/aac847882df5a354270dae91499cae1d.png", "size": [50, 50]}
sorl-thumbnail||thumbnails||fdfd766abbbf2813fa5e4a147ad24127	["fac7862e08fdaed499cd9658f0aa190a", "e16d212a5a5e6b5def29996fcde73c39"]
sorl-thumbnail||thumbnails||e0b28a9e50fd63d4693f332b3c66ea10	["5052a012be36d1487f73b34293c2ce66", "4d0e6149dede158f60ef81135a6873a6"]
sorl-thumbnail||image||2622e6c33094e643bad81543fda33de0	{"storage": "django.core.files.storage.FileSystemStorage", "name": "thumbnails/contents/c7bf25c7-afe3-11e1-8747-58b035f6b93d.jpg", "size": [348, 310]}
sorl-thumbnail||image||95e4a4c3aa753121d5160d5d020cc721	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/16/b0/16b02bcb34785a7d9de1277e124b8b1c.png", "size": [50, 50]}
sorl-thumbnail||thumbnails||2622e6c33094e643bad81543fda33de0	["95e4a4c3aa753121d5160d5d020cc721"]
sorl-thumbnail||image||5052a012be36d1487f73b34293c2ce66	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/86/59/8659bb907a840c44a24951b1f8f736af.png", "size": [50, 50]}
sorl-thumbnail||image||79a42a48842e2ba9bef93e6a5fa782a4	{"storage": "django.core.files.storage.FileSystemStorage", "name": "thumbnails/contents/3f0148e8-afe5-11e1-9960-58b035f6b93d.jpg", "size": [348, 310]}
sorl-thumbnail||image||34a148b7830aecc83a7d855e95e64622	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/92/58/92587e78941df7e06216bb5bddaa5f56.png", "size": [50, 50]}
sorl-thumbnail||thumbnails||79a42a48842e2ba9bef93e6a5fa782a4	["34a148b7830aecc83a7d855e95e64622"]
sorl-thumbnail||image||9e72160fd87ce9b671ecd1279b54f974	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/33/3c/333cf9c0beeefb6091b12facec865e91.png", "size": [50, 50]}
sorl-thumbnail||thumbnails||8340de80e2d1bfa47bd039e77b80631f	["9e72160fd87ce9b671ecd1279b54f974", "9cf8babe64a8f1ae3f39fd65018c7bcc"]
sorl-thumbnail||image||7afa78236a72de43a35bde7b3c27aa69	{"storage": "django.core.files.storage.FileSystemStorage", "name": "thumbnails/contents/5ca8712b-afed-11e1-86d7-58b035f6b93d.jpg", "size": [348, 310]}
sorl-thumbnail||image||e774ee78f83a78dd45df0e9c8929eaeb	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/28/b8/28b8b62fc96d4a7136d1c5b6a2ae71fa.png", "size": [50, 50]}
sorl-thumbnail||thumbnails||7afa78236a72de43a35bde7b3c27aa69	["e774ee78f83a78dd45df0e9c8929eaeb"]
sorl-thumbnail||image||a7bca3767fa4a6bdb8f540e3d467eb67	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/54/e0/54e06c9974ef11eeb2b9c27ca63906fa.png", "size": [50, 50]}
sorl-thumbnail||image||c8e7d53b1e39f78e19f036cad7003403	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/d9/ff/d9ffb7bca1583a55f239d0c47ae53726.png", "size": [50, 50]}
sorl-thumbnail||image||e90b3be400d8552618efe22e26146700	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/df/bb/dfbb3e111121cf456dcb14f772db2c1b.png", "size": [50, 50]}
sorl-thumbnail||image||0e39fa02d9ff88dda63bd738fa1116c2	{"storage": "django.core.files.storage.FileSystemStorage", "name": "thumbnails/contents/247de85c-afef-11e1-9e56-58b035f6b93d.jpg", "size": [348, 310]}
sorl-thumbnail||image||2d59924ac34031a56848432473203949	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/1a/6a/1a6a7a493160b9c544c87ff3b9425645.png", "size": [50, 50]}
sorl-thumbnail||thumbnails||0e39fa02d9ff88dda63bd738fa1116c2	["2d59924ac34031a56848432473203949"]
sorl-thumbnail||image||68073b0be381ff95e2e6f7373368b004	{"storage": "django.core.files.storage.FileSystemStorage", "name": "thumbnails/contents/6a4d35a6-affc-11e1-b451-58b035f6b93d_2.jpg", "size": [348, 310]}
sorl-thumbnail||image||9b81d880c53a619af361fae15187fea5	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/50/db/50db38630df2c5161bf5694b9ff79955.png", "size": [112, 100]}
sorl-thumbnail||image||f710506c949f219e0f98d9257399074a	{"storage": "django.core.files.storage.FileSystemStorage", "name": "cache/b8/5e/b85e8a330f5fe91987ebbe4fc18496fe.png", "size": [50, 50]}
sorl-thumbnail||thumbnails||68073b0be381ff95e2e6f7373368b004	["f710506c949f219e0f98d9257399074a", "9b81d880c53a619af361fae15187fea5"]
\.


--
-- TOC entry 2626 (class 0 OID 120619)
-- Dependencies: 231
-- Data for Name: user_groupprofile; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY user_groupprofile (id, group_id, description, image) FROM stdin;
1	1		thumbnails/groups/group_default_icon.png
\.


--
-- TOC entry 2624 (class 0 OID 120558)
-- Dependencies: 227
-- Data for Name: user_ldt; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY user_ldt (user_ptr_id) FROM stdin;
1
\.


--
-- TOC entry 2625 (class 0 OID 120597)
-- Dependencies: 229
-- Data for Name: user_userprofile; Type: TABLE DATA; Schema: public; Owner: iri
--

COPY user_userprofile (id, user_id, language, image) FROM stdin;
1	-1	en	thumbnails/users/user_default_icon.png
2	1	en	thumbnails/users/user_default_icon.png
\.


--
-- TOC entry 2387 (class 2606 OID 120009)
-- Dependencies: 166 166
-- Name: auth_group_name_key; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY auth_group
    ADD CONSTRAINT auth_group_name_key UNIQUE (name);


--
-- TOC entry 2382 (class 2606 OID 119994)
-- Dependencies: 164 164 164
-- Name: auth_group_permissions_group_id_permission_id_key; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_group_id_permission_id_key UNIQUE (group_id, permission_id);


--
-- TOC entry 2385 (class 2606 OID 119992)
-- Dependencies: 164 164
-- Name: auth_group_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_pkey PRIMARY KEY (id);


--
-- TOC entry 2389 (class 2606 OID 120007)
-- Dependencies: 166 166
-- Name: auth_group_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY auth_group
    ADD CONSTRAINT auth_group_pkey PRIMARY KEY (id);


--
-- TOC entry 2377 (class 2606 OID 119984)
-- Dependencies: 162 162 162
-- Name: auth_permission_content_type_id_codename_key; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY auth_permission
    ADD CONSTRAINT auth_permission_content_type_id_codename_key UNIQUE (content_type_id, codename);


--
-- TOC entry 2379 (class 2606 OID 119982)
-- Dependencies: 162 162
-- Name: auth_permission_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY auth_permission
    ADD CONSTRAINT auth_permission_pkey PRIMARY KEY (id);


--
-- TOC entry 2398 (class 2606 OID 120037)
-- Dependencies: 170 170
-- Name: auth_user_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY auth_user_groups
    ADD CONSTRAINT auth_user_groups_pkey PRIMARY KEY (id);


--
-- TOC entry 2401 (class 2606 OID 120039)
-- Dependencies: 170 170 170
-- Name: auth_user_groups_user_id_group_id_key; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY auth_user_groups
    ADD CONSTRAINT auth_user_groups_user_id_group_id_key UNIQUE (user_id, group_id);


--
-- TOC entry 2403 (class 2606 OID 120052)
-- Dependencies: 172 172
-- Name: auth_user_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY auth_user
    ADD CONSTRAINT auth_user_pkey PRIMARY KEY (id);


--
-- TOC entry 2392 (class 2606 OID 120022)
-- Dependencies: 168 168
-- Name: auth_user_user_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_pkey PRIMARY KEY (id);


--
-- TOC entry 2395 (class 2606 OID 120024)
-- Dependencies: 168 168 168
-- Name: auth_user_user_permissions_user_id_permission_id_key; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_user_id_permission_id_key UNIQUE (user_id, permission_id);


--
-- TOC entry 2405 (class 2606 OID 120054)
-- Dependencies: 172 172
-- Name: auth_user_username_key; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY auth_user
    ADD CONSTRAINT auth_user_username_key UNIQUE (username);


--
-- TOC entry 2417 (class 2606 OID 120107)
-- Dependencies: 179 179
-- Name: django_admin_log_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY django_admin_log
    ADD CONSTRAINT django_admin_log_pkey PRIMARY KEY (id);


--
-- TOC entry 2407 (class 2606 OID 120074)
-- Dependencies: 174 174 174
-- Name: django_content_type_app_label_model_key; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY django_content_type
    ADD CONSTRAINT django_content_type_app_label_model_key UNIQUE (app_label, model);


--
-- TOC entry 2409 (class 2606 OID 120072)
-- Dependencies: 174 174
-- Name: django_content_type_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY django_content_type
    ADD CONSTRAINT django_content_type_pkey PRIMARY KEY (id);


--
-- TOC entry 2454 (class 2606 OID 120246)
-- Dependencies: 197 197
-- Name: django_openid_consumer_association_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY django_openid_consumer_association
    ADD CONSTRAINT django_openid_consumer_association_pkey PRIMARY KEY (id);


--
-- TOC entry 2447 (class 2606 OID 120235)
-- Dependencies: 195 195
-- Name: django_openid_consumer_nonce_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY django_openid_consumer_nonce
    ADD CONSTRAINT django_openid_consumer_nonce_pkey PRIMARY KEY (id);


--
-- TOC entry 2412 (class 2606 OID 120087)
-- Dependencies: 175 175
-- Name: django_session_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY django_session
    ADD CONSTRAINT django_session_pkey PRIMARY KEY (session_key);


--
-- TOC entry 2414 (class 2606 OID 120095)
-- Dependencies: 177 177
-- Name: django_site_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY django_site
    ADD CONSTRAINT django_site_pkey PRIMARY KEY (id);


--
-- TOC entry 2537 (class 2606 OID 120741)
-- Dependencies: 235 235 235 235 235
-- Name: guardian_groupobjectpermission_object_pk_1496f467edd78b17_uniq; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY guardian_groupobjectpermission
    ADD CONSTRAINT guardian_groupobjectpermission_object_pk_1496f467edd78b17_uniq UNIQUE (object_pk, group_id, content_type_id, permission_id);


--
-- TOC entry 2540 (class 2606 OID 120655)
-- Dependencies: 235 235
-- Name: guardian_groupobjectpermission_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY guardian_groupobjectpermission
    ADD CONSTRAINT guardian_groupobjectpermission_pkey PRIMARY KEY (id);


--
-- TOC entry 2529 (class 2606 OID 120743)
-- Dependencies: 233 233 233 233 233
-- Name: guardian_userobjectpermission_object_pk_4a3e38372084f8ff_uniq; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY guardian_userobjectpermission
    ADD CONSTRAINT guardian_userobjectpermission_object_pk_4a3e38372084f8ff_uniq UNIQUE (object_pk, user_id, content_type_id, permission_id);


--
-- TOC entry 2532 (class 2606 OID 120644)
-- Dependencies: 233 233
-- Name: guardian_userobjectpermission_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY guardian_userobjectpermission
    ADD CONSTRAINT guardian_userobjectpermission_pkey PRIMARY KEY (id);


--
-- TOC entry 2480 (class 2606 OID 120414)
-- Dependencies: 214 214
-- Name: ldt_utils_author_handle_key; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY ldt_utils_author
    ADD CONSTRAINT ldt_utils_author_handle_key UNIQUE (handle);


--
-- TOC entry 2482 (class 2606 OID 120412)
-- Dependencies: 214 214
-- Name: ldt_utils_author_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY ldt_utils_author
    ADD CONSTRAINT ldt_utils_author_pkey PRIMARY KEY (id);


--
-- TOC entry 2497 (class 2606 OID 120451)
-- Dependencies: 220 220 220
-- Name: ldt_utils_content_authors_content_id_cd220dd3d0cdbf3_uniq; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY ldt_utils_content_authors
    ADD CONSTRAINT ldt_utils_content_authors_content_id_cd220dd3d0cdbf3_uniq UNIQUE (content_id, author_id);


--
-- TOC entry 2499 (class 2606 OID 120449)
-- Dependencies: 220 220
-- Name: ldt_utils_content_authors_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY ldt_utils_content_authors
    ADD CONSTRAINT ldt_utils_content_authors_pkey PRIMARY KEY (id);


--
-- TOC entry 2490 (class 2606 OID 120441)
-- Dependencies: 218 218
-- Name: ldt_utils_content_iri_id_key; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY ldt_utils_content
    ADD CONSTRAINT ldt_utils_content_iri_id_key UNIQUE (iri_id);


--
-- TOC entry 2493 (class 2606 OID 120439)
-- Dependencies: 218 218
-- Name: ldt_utils_content_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY ldt_utils_content
    ADD CONSTRAINT ldt_utils_content_pkey PRIMARY KEY (id);


--
-- TOC entry 2542 (class 2606 OID 120855)
-- Dependencies: 237 237
-- Name: ldt_utils_contentstat_content_id_key; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY ldt_utils_contentstat
    ADD CONSTRAINT ldt_utils_contentstat_content_id_key UNIQUE (content_id);


--
-- TOC entry 2545 (class 2606 OID 120845)
-- Dependencies: 237 237
-- Name: ldt_utils_contentstat_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY ldt_utils_contentstat
    ADD CONSTRAINT ldt_utils_contentstat_pkey PRIMARY KEY (id);


--
-- TOC entry 2485 (class 2606 OID 120425)
-- Dependencies: 216 216
-- Name: ldt_utils_media_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY ldt_utils_media
    ADD CONSTRAINT ldt_utils_media_pkey PRIMARY KEY (id);


--
-- TOC entry 2487 (class 2606 OID 120427)
-- Dependencies: 216 216
-- Name: ldt_utils_media_src_key; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY ldt_utils_media
    ADD CONSTRAINT ldt_utils_media_src_key UNIQUE (src);


--
-- TOC entry 2507 (class 2606 OID 120473)
-- Dependencies: 224 224
-- Name: ldt_utils_project_contents_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY ldt_utils_project_contents
    ADD CONSTRAINT ldt_utils_project_contents_pkey PRIMARY KEY (id);


--
-- TOC entry 2510 (class 2606 OID 120475)
-- Dependencies: 224 224 224
-- Name: ldt_utils_project_contents_project_id_2ae0c6a1958850b7_uniq; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY ldt_utils_project_contents
    ADD CONSTRAINT ldt_utils_project_contents_project_id_2ae0c6a1958850b7_uniq UNIQUE (project_id, content_id);


--
-- TOC entry 2501 (class 2606 OID 120465)
-- Dependencies: 222 222
-- Name: ldt_utils_project_ldt_id_key; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY ldt_utils_project
    ADD CONSTRAINT ldt_utils_project_ldt_id_key UNIQUE (ldt_id);


--
-- TOC entry 2504 (class 2606 OID 120463)
-- Dependencies: 222 222
-- Name: ldt_utils_project_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY ldt_utils_project
    ADD CONSTRAINT ldt_utils_project_pkey PRIMARY KEY (id);


--
-- TOC entry 2513 (class 2606 OID 120486)
-- Dependencies: 226 226
-- Name: ldt_utils_segment_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY ldt_utils_segment
    ADD CONSTRAINT ldt_utils_segment_pkey PRIMARY KEY (id);


--
-- TOC entry 2515 (class 2606 OID 120488)
-- Dependencies: 226 226 226 226 226 226
-- Name: ldt_utils_segment_project_id_1627ba286692fe29_uniq; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY ldt_utils_segment
    ADD CONSTRAINT ldt_utils_segment_project_id_1627ba286692fe29_uniq UNIQUE (project_id, iri_id, ensemble_id, cutting_id, element_id);


--
-- TOC entry 2439 (class 2606 OID 120196)
-- Dependencies: 191 191
-- Name: oauth_provider_consumer_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY oauth_provider_consumer
    ADD CONSTRAINT oauth_provider_consumer_pkey PRIMARY KEY (id);


--
-- TOC entry 2435 (class 2606 OID 120174)
-- Dependencies: 187 187
-- Name: oauth_provider_nonce_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY oauth_provider_nonce
    ADD CONSTRAINT oauth_provider_nonce_pkey PRIMARY KEY (id);


--
-- TOC entry 2437 (class 2606 OID 120185)
-- Dependencies: 189 189
-- Name: oauth_provider_resource_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY oauth_provider_resource
    ADD CONSTRAINT oauth_provider_resource_pkey PRIMARY KEY (id);


--
-- TOC entry 2443 (class 2606 OID 120212)
-- Dependencies: 193 193
-- Name: oauth_provider_token_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY oauth_provider_token
    ADD CONSTRAINT oauth_provider_token_pkey PRIMARY KEY (id);


--
-- TOC entry 2460 (class 2606 OID 120265)
-- Dependencies: 201 201
-- Name: piston_consumer_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY piston_consumer
    ADD CONSTRAINT piston_consumer_pkey PRIMARY KEY (id);


--
-- TOC entry 2458 (class 2606 OID 120254)
-- Dependencies: 199 199
-- Name: piston_nonce_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY piston_nonce
    ADD CONSTRAINT piston_nonce_pkey PRIMARY KEY (id);


--
-- TOC entry 2464 (class 2606 OID 120278)
-- Dependencies: 203 203
-- Name: piston_token_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY piston_token
    ADD CONSTRAINT piston_token_pkey PRIMARY KEY (id);


--
-- TOC entry 2420 (class 2606 OID 120125)
-- Dependencies: 181 181
-- Name: registration_registrationprofile_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY registration_registrationprofile
    ADD CONSTRAINT registration_registrationprofile_pkey PRIMARY KEY (id);


--
-- TOC entry 2422 (class 2606 OID 120127)
-- Dependencies: 181 181
-- Name: registration_registrationprofile_user_id_key; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY registration_registrationprofile
    ADD CONSTRAINT registration_registrationprofile_user_id_key UNIQUE (user_id);


--
-- TOC entry 2474 (class 2606 OID 120325)
-- Dependencies: 209 209
-- Name: social_auth_association_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY social_auth_association
    ADD CONSTRAINT social_auth_association_pkey PRIMARY KEY (id);


--
-- TOC entry 2472 (class 2606 OID 120314)
-- Dependencies: 207 207
-- Name: social_auth_nonce_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY social_auth_nonce
    ADD CONSTRAINT social_auth_nonce_pkey PRIMARY KEY (id);


--
-- TOC entry 2467 (class 2606 OID 120299)
-- Dependencies: 205 205
-- Name: social_auth_usersocialauth_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY social_auth_usersocialauth
    ADD CONSTRAINT social_auth_usersocialauth_pkey PRIMARY KEY (id);


--
-- TOC entry 2469 (class 2606 OID 120301)
-- Dependencies: 205 205 205
-- Name: social_auth_usersocialauth_provider_uid_key; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY social_auth_usersocialauth
    ADD CONSTRAINT social_auth_usersocialauth_provider_uid_key UNIQUE (provider, uid);


--
-- TOC entry 2476 (class 2606 OID 120336)
-- Dependencies: 211 211
-- Name: south_migrationhistory_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY south_migrationhistory
    ADD CONSTRAINT south_migrationhistory_pkey PRIMARY KEY (id);


--
-- TOC entry 2424 (class 2606 OID 120142)
-- Dependencies: 183 183
-- Name: tagging_tag_name_key; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY tagging_tag
    ADD CONSTRAINT tagging_tag_name_key UNIQUE (name);


--
-- TOC entry 2426 (class 2606 OID 120140)
-- Dependencies: 183 183
-- Name: tagging_tag_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY tagging_tag
    ADD CONSTRAINT tagging_tag_pkey PRIMARY KEY (id);


--
-- TOC entry 2430 (class 2606 OID 120151)
-- Dependencies: 185 185
-- Name: tagging_taggeditem_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY tagging_taggeditem
    ADD CONSTRAINT tagging_taggeditem_pkey PRIMARY KEY (id);


--
-- TOC entry 2433 (class 2606 OID 120153)
-- Dependencies: 185 185 185 185
-- Name: tagging_taggeditem_tag_id_content_type_id_object_id_key; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY tagging_taggeditem
    ADD CONSTRAINT tagging_taggeditem_tag_id_content_type_id_object_id_key UNIQUE (tag_id, content_type_id, object_id);


--
-- TOC entry 2547 (class 2606 OID 120874)
-- Dependencies: 239 239
-- Name: text_annotation_external_id_key; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY text_annotation
    ADD CONSTRAINT text_annotation_external_id_key UNIQUE (external_id);


--
-- TOC entry 2549 (class 2606 OID 120872)
-- Dependencies: 239 239
-- Name: text_annotation_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY text_annotation
    ADD CONSTRAINT text_annotation_pkey PRIMARY KEY (id);


--
-- TOC entry 2478 (class 2606 OID 120344)
-- Dependencies: 212 212
-- Name: thumbnail_kvstore_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY thumbnail_kvstore
    ADD CONSTRAINT thumbnail_kvstore_pkey PRIMARY KEY (key);


--
-- TOC entry 2524 (class 2606 OID 120630)
-- Dependencies: 231 231
-- Name: user_groupprofile_group_id_key; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY user_groupprofile
    ADD CONSTRAINT user_groupprofile_group_id_key UNIQUE (group_id);


--
-- TOC entry 2526 (class 2606 OID 120628)
-- Dependencies: 231 231
-- Name: user_groupprofile_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY user_groupprofile
    ADD CONSTRAINT user_groupprofile_pkey PRIMARY KEY (id);


--
-- TOC entry 2518 (class 2606 OID 120562)
-- Dependencies: 227 227
-- Name: user_ldt_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY user_ldt
    ADD CONSTRAINT user_ldt_pkey PRIMARY KEY (user_ptr_id);


--
-- TOC entry 2520 (class 2606 OID 120603)
-- Dependencies: 229 229
-- Name: user_userprofile_pkey; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY user_userprofile
    ADD CONSTRAINT user_userprofile_pkey PRIMARY KEY (id);


--
-- TOC entry 2522 (class 2606 OID 120605)
-- Dependencies: 229 229
-- Name: user_userprofile_user_id_key; Type: CONSTRAINT; Schema: public; Owner: iri; Tablespace: 
--

ALTER TABLE ONLY user_userprofile
    ADD CONSTRAINT user_userprofile_user_id_key UNIQUE (user_id);


--
-- TOC entry 2380 (class 1259 OID 120346)
-- Dependencies: 164
-- Name: auth_group_permissions_group_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX auth_group_permissions_group_id ON auth_group_permissions USING btree (group_id);


--
-- TOC entry 2383 (class 1259 OID 120347)
-- Dependencies: 164
-- Name: auth_group_permissions_permission_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX auth_group_permissions_permission_id ON auth_group_permissions USING btree (permission_id);


--
-- TOC entry 2375 (class 1259 OID 120345)
-- Dependencies: 162
-- Name: auth_permission_content_type_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX auth_permission_content_type_id ON auth_permission USING btree (content_type_id);


--
-- TOC entry 2396 (class 1259 OID 120351)
-- Dependencies: 170
-- Name: auth_user_groups_group_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX auth_user_groups_group_id ON auth_user_groups USING btree (group_id);


--
-- TOC entry 2399 (class 1259 OID 120350)
-- Dependencies: 170
-- Name: auth_user_groups_user_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX auth_user_groups_user_id ON auth_user_groups USING btree (user_id);


--
-- TOC entry 2390 (class 1259 OID 120349)
-- Dependencies: 168
-- Name: auth_user_user_permissions_permission_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX auth_user_user_permissions_permission_id ON auth_user_user_permissions USING btree (permission_id);


--
-- TOC entry 2393 (class 1259 OID 120348)
-- Dependencies: 168
-- Name: auth_user_user_permissions_user_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX auth_user_user_permissions_user_id ON auth_user_user_permissions USING btree (user_id);


--
-- TOC entry 2415 (class 1259 OID 120354)
-- Dependencies: 179
-- Name: django_admin_log_content_type_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX django_admin_log_content_type_id ON django_admin_log USING btree (content_type_id);


--
-- TOC entry 2418 (class 1259 OID 120353)
-- Dependencies: 179
-- Name: django_admin_log_user_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX django_admin_log_user_id ON django_admin_log USING btree (user_id);


--
-- TOC entry 2451 (class 1259 OID 120367)
-- Dependencies: 197
-- Name: django_openid_consumer_association_handle; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX django_openid_consumer_association_handle ON django_openid_consumer_association USING btree (handle);


--
-- TOC entry 2452 (class 1259 OID 120368)
-- Dependencies: 197
-- Name: django_openid_consumer_association_handle_like; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX django_openid_consumer_association_handle_like ON django_openid_consumer_association USING btree (handle varchar_pattern_ops);


--
-- TOC entry 2455 (class 1259 OID 120365)
-- Dependencies: 197
-- Name: django_openid_consumer_association_server_url; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX django_openid_consumer_association_server_url ON django_openid_consumer_association USING btree (server_url);


--
-- TOC entry 2456 (class 1259 OID 120366)
-- Dependencies: 197
-- Name: django_openid_consumer_association_server_url_like; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX django_openid_consumer_association_server_url_like ON django_openid_consumer_association USING btree (server_url text_pattern_ops);


--
-- TOC entry 2448 (class 1259 OID 120362)
-- Dependencies: 195
-- Name: django_openid_consumer_nonce_server_url; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX django_openid_consumer_nonce_server_url ON django_openid_consumer_nonce USING btree (server_url);


--
-- TOC entry 2449 (class 1259 OID 120363)
-- Dependencies: 195
-- Name: django_openid_consumer_nonce_server_url_like; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX django_openid_consumer_nonce_server_url_like ON django_openid_consumer_nonce USING btree (server_url varchar_pattern_ops);


--
-- TOC entry 2450 (class 1259 OID 120364)
-- Dependencies: 195
-- Name: django_openid_consumer_nonce_timestamp; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX django_openid_consumer_nonce_timestamp ON django_openid_consumer_nonce USING btree ("timestamp");


--
-- TOC entry 2410 (class 1259 OID 120352)
-- Dependencies: 175
-- Name: django_session_expire_date; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX django_session_expire_date ON django_session USING btree (expire_date);


--
-- TOC entry 2534 (class 1259 OID 120687)
-- Dependencies: 235
-- Name: guardian_groupobjectpermission_content_type_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX guardian_groupobjectpermission_content_type_id ON guardian_groupobjectpermission USING btree (content_type_id);


--
-- TOC entry 2535 (class 1259 OID 120693)
-- Dependencies: 235
-- Name: guardian_groupobjectpermission_group_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX guardian_groupobjectpermission_group_id ON guardian_groupobjectpermission USING btree (group_id);


--
-- TOC entry 2538 (class 1259 OID 120681)
-- Dependencies: 235
-- Name: guardian_groupobjectpermission_permission_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX guardian_groupobjectpermission_permission_id ON guardian_groupobjectpermission USING btree (permission_id);


--
-- TOC entry 2527 (class 1259 OID 120669)
-- Dependencies: 233
-- Name: guardian_userobjectpermission_content_type_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX guardian_userobjectpermission_content_type_id ON guardian_userobjectpermission USING btree (content_type_id);


--
-- TOC entry 2530 (class 1259 OID 120663)
-- Dependencies: 233
-- Name: guardian_userobjectpermission_permission_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX guardian_userobjectpermission_permission_id ON guardian_userobjectpermission USING btree (permission_id);


--
-- TOC entry 2533 (class 1259 OID 120675)
-- Dependencies: 233
-- Name: guardian_userobjectpermission_user_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX guardian_userobjectpermission_user_id ON guardian_userobjectpermission USING btree (user_id);


--
-- TOC entry 2494 (class 1259 OID 120512)
-- Dependencies: 220
-- Name: ldt_utils_content_authors_author_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX ldt_utils_content_authors_author_id ON ldt_utils_content_authors USING btree (author_id);


--
-- TOC entry 2495 (class 1259 OID 120506)
-- Dependencies: 220
-- Name: ldt_utils_content_authors_content_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX ldt_utils_content_authors_content_id ON ldt_utils_content_authors USING btree (content_id);


--
-- TOC entry 2488 (class 1259 OID 120821)
-- Dependencies: 218
-- Name: ldt_utils_content_front_project_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX ldt_utils_content_front_project_id ON ldt_utils_content USING btree (front_project_id);


--
-- TOC entry 2491 (class 1259 OID 120500)
-- Dependencies: 218
-- Name: ldt_utils_content_media_obj_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX ldt_utils_content_media_obj_id ON ldt_utils_content USING btree (media_obj_id);


--
-- TOC entry 2543 (class 1259 OID 120853)
-- Dependencies: 237
-- Name: ldt_utils_contentstat_nb_annotations; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX ldt_utils_contentstat_nb_annotations ON ldt_utils_contentstat USING btree (nb_annotations);


--
-- TOC entry 2483 (class 1259 OID 120494)
-- Dependencies: 216
-- Name: ldt_utils_media_creator_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX ldt_utils_media_creator_id ON ldt_utils_media USING btree (creator_id);


--
-- TOC entry 2505 (class 1259 OID 120530)
-- Dependencies: 224
-- Name: ldt_utils_project_contents_content_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX ldt_utils_project_contents_content_id ON ldt_utils_project_contents USING btree (content_id);


--
-- TOC entry 2508 (class 1259 OID 120524)
-- Dependencies: 224
-- Name: ldt_utils_project_contents_project_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX ldt_utils_project_contents_project_id ON ldt_utils_project_contents USING btree (project_id);


--
-- TOC entry 2502 (class 1259 OID 120544)
-- Dependencies: 222
-- Name: ldt_utils_project_owner_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX ldt_utils_project_owner_id ON ldt_utils_project USING btree (owner_id);


--
-- TOC entry 2511 (class 1259 OID 120542)
-- Dependencies: 226
-- Name: ldt_utils_segment_content_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX ldt_utils_segment_content_id ON ldt_utils_segment USING btree (content_id);


--
-- TOC entry 2516 (class 1259 OID 120536)
-- Dependencies: 226
-- Name: ldt_utils_segment_project_obj_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX ldt_utils_segment_project_obj_id ON ldt_utils_segment USING btree (project_obj_id);


--
-- TOC entry 2440 (class 1259 OID 120358)
-- Dependencies: 191
-- Name: oauth_provider_consumer_user_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX oauth_provider_consumer_user_id ON oauth_provider_consumer USING btree (user_id);


--
-- TOC entry 2441 (class 1259 OID 120360)
-- Dependencies: 193
-- Name: oauth_provider_token_consumer_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX oauth_provider_token_consumer_id ON oauth_provider_token USING btree (consumer_id);


--
-- TOC entry 2444 (class 1259 OID 120361)
-- Dependencies: 193
-- Name: oauth_provider_token_resource_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX oauth_provider_token_resource_id ON oauth_provider_token USING btree (resource_id);


--
-- TOC entry 2445 (class 1259 OID 120359)
-- Dependencies: 193
-- Name: oauth_provider_token_user_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX oauth_provider_token_user_id ON oauth_provider_token USING btree (user_id);


--
-- TOC entry 2461 (class 1259 OID 120369)
-- Dependencies: 201
-- Name: piston_consumer_user_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX piston_consumer_user_id ON piston_consumer USING btree (user_id);


--
-- TOC entry 2462 (class 1259 OID 120371)
-- Dependencies: 203
-- Name: piston_token_consumer_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX piston_token_consumer_id ON piston_token USING btree (consumer_id);


--
-- TOC entry 2465 (class 1259 OID 120370)
-- Dependencies: 203
-- Name: piston_token_user_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX piston_token_user_id ON piston_token USING btree (user_id);


--
-- TOC entry 2470 (class 1259 OID 120372)
-- Dependencies: 205
-- Name: social_auth_usersocialauth_user_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX social_auth_usersocialauth_user_id ON social_auth_usersocialauth USING btree (user_id);


--
-- TOC entry 2427 (class 1259 OID 120356)
-- Dependencies: 185
-- Name: tagging_taggeditem_content_type_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX tagging_taggeditem_content_type_id ON tagging_taggeditem USING btree (content_type_id);


--
-- TOC entry 2428 (class 1259 OID 120357)
-- Dependencies: 185
-- Name: tagging_taggeditem_object_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX tagging_taggeditem_object_id ON tagging_taggeditem USING btree (object_id);


--
-- TOC entry 2431 (class 1259 OID 120355)
-- Dependencies: 185
-- Name: tagging_taggeditem_tag_id; Type: INDEX; Schema: public; Owner: iri; Tablespace: 
--

CREATE INDEX tagging_taggeditem_tag_id ON tagging_taggeditem USING btree (tag_id);


--
-- TOC entry 2551 (class 2606 OID 119995)
-- Dependencies: 164 2378 162
-- Name: auth_group_permissions_permission_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_permission_id_fkey FOREIGN KEY (permission_id) REFERENCES auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2555 (class 2606 OID 120040)
-- Dependencies: 170 166 2388
-- Name: auth_user_groups_group_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY auth_user_groups
    ADD CONSTRAINT auth_user_groups_group_id_fkey FOREIGN KEY (group_id) REFERENCES auth_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2553 (class 2606 OID 120025)
-- Dependencies: 162 168 2378
-- Name: auth_user_user_permissions_permission_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_permission_id_fkey FOREIGN KEY (permission_id) REFERENCES auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2574 (class 2606 OID 120507)
-- Dependencies: 220 214 2481
-- Name: author_id_refs_id_775c80163b70a229; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY ldt_utils_content_authors
    ADD CONSTRAINT author_id_refs_id_775c80163b70a229 FOREIGN KEY (author_id) REFERENCES ldt_utils_author(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2589 (class 2606 OID 120856)
-- Dependencies: 237 2492 218
-- Name: content_id_refs_id_11d9479ad5ca68cb; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY ldt_utils_contentstat
    ADD CONSTRAINT content_id_refs_id_11d9479ad5ca68cb FOREIGN KEY (content_id) REFERENCES ldt_utils_content(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2579 (class 2606 OID 120537)
-- Dependencies: 226 2492 218
-- Name: content_id_refs_id_3a1d09ebfcd0e9b; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY ldt_utils_segment
    ADD CONSTRAINT content_id_refs_id_3a1d09ebfcd0e9b FOREIGN KEY (content_id) REFERENCES ldt_utils_content(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2573 (class 2606 OID 120501)
-- Dependencies: 220 218 2492
-- Name: content_id_refs_id_42ac98eec6a19fdc; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY ldt_utils_content_authors
    ADD CONSTRAINT content_id_refs_id_42ac98eec6a19fdc FOREIGN KEY (content_id) REFERENCES ldt_utils_content(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2577 (class 2606 OID 120525)
-- Dependencies: 224 218 2492
-- Name: content_id_refs_id_5246c9ae107ebf61; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY ldt_utils_project_contents
    ADD CONSTRAINT content_id_refs_id_5246c9ae107ebf61 FOREIGN KEY (content_id) REFERENCES ldt_utils_content(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2584 (class 2606 OID 120664)
-- Dependencies: 2408 233 174
-- Name: content_type_id_refs_id_41c07efb11cb62e8; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY guardian_userobjectpermission
    ADD CONSTRAINT content_type_id_refs_id_41c07efb11cb62e8 FOREIGN KEY (content_type_id) REFERENCES django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2587 (class 2606 OID 120682)
-- Dependencies: 174 235 2408
-- Name: content_type_id_refs_id_478017b6b7357933; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY guardian_groupobjectpermission
    ADD CONSTRAINT content_type_id_refs_id_478017b6b7357933 FOREIGN KEY (content_type_id) REFERENCES django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2550 (class 2606 OID 120075)
-- Dependencies: 162 174 2408
-- Name: content_type_id_refs_id_728de91f; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY auth_permission
    ADD CONSTRAINT content_type_id_refs_id_728de91f FOREIGN KEY (content_type_id) REFERENCES django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2570 (class 2606 OID 120489)
-- Dependencies: 216 172 2402
-- Name: creator_id_refs_id_11b732999d350164; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY ldt_utils_media
    ADD CONSTRAINT creator_id_refs_id_11b732999d350164 FOREIGN KEY (creator_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2558 (class 2606 OID 120113)
-- Dependencies: 2408 179 174
-- Name: django_admin_log_content_type_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY django_admin_log
    ADD CONSTRAINT django_admin_log_content_type_id_fkey FOREIGN KEY (content_type_id) REFERENCES django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2557 (class 2606 OID 120108)
-- Dependencies: 179 172 2402
-- Name: django_admin_log_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY django_admin_log
    ADD CONSTRAINT django_admin_log_user_id_fkey FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2572 (class 2606 OID 120816)
-- Dependencies: 222 2503 218
-- Name: front_project_id_refs_id_61c038c0407af0f7; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY ldt_utils_content
    ADD CONSTRAINT front_project_id_refs_id_61c038c0407af0f7 FOREIGN KEY (front_project_id) REFERENCES ldt_utils_project(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2582 (class 2606 OID 120631)
-- Dependencies: 166 231 2388
-- Name: group_id_refs_id_1033bdb7d6ab756; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY user_groupprofile
    ADD CONSTRAINT group_id_refs_id_1033bdb7d6ab756 FOREIGN KEY (group_id) REFERENCES auth_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2588 (class 2606 OID 120688)
-- Dependencies: 166 2388 235
-- Name: group_id_refs_id_1d1dde31576d4670; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY guardian_groupobjectpermission
    ADD CONSTRAINT group_id_refs_id_1d1dde31576d4670 FOREIGN KEY (group_id) REFERENCES auth_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2552 (class 2606 OID 120010)
-- Dependencies: 166 2388 164
-- Name: group_id_refs_id_3cea63fe; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY auth_group_permissions
    ADD CONSTRAINT group_id_refs_id_3cea63fe FOREIGN KEY (group_id) REFERENCES auth_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2571 (class 2606 OID 120495)
-- Dependencies: 218 216 2484
-- Name: media_obj_id_refs_id_188cc205e05615ea; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY ldt_utils_content
    ADD CONSTRAINT media_obj_id_refs_id_188cc205e05615ea FOREIGN KEY (media_obj_id) REFERENCES ldt_utils_media(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2562 (class 2606 OID 120197)
-- Dependencies: 2402 172 191
-- Name: oauth_provider_consumer_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY oauth_provider_consumer
    ADD CONSTRAINT oauth_provider_consumer_user_id_fkey FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2564 (class 2606 OID 120218)
-- Dependencies: 2438 191 193
-- Name: oauth_provider_token_consumer_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY oauth_provider_token
    ADD CONSTRAINT oauth_provider_token_consumer_id_fkey FOREIGN KEY (consumer_id) REFERENCES oauth_provider_consumer(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2565 (class 2606 OID 120223)
-- Dependencies: 189 2436 193
-- Name: oauth_provider_token_resource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY oauth_provider_token
    ADD CONSTRAINT oauth_provider_token_resource_id_fkey FOREIGN KEY (resource_id) REFERENCES oauth_provider_resource(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2563 (class 2606 OID 120213)
-- Dependencies: 193 172 2402
-- Name: oauth_provider_token_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY oauth_provider_token
    ADD CONSTRAINT oauth_provider_token_user_id_fkey FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2575 (class 2606 OID 120545)
-- Dependencies: 172 2402 222
-- Name: owner_id_refs_id_3cf0d97825853857; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY ldt_utils_project
    ADD CONSTRAINT owner_id_refs_id_3cf0d97825853857 FOREIGN KEY (owner_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2586 (class 2606 OID 120676)
-- Dependencies: 2378 235 162
-- Name: permission_id_refs_id_4d2ad9935b560df; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY guardian_groupobjectpermission
    ADD CONSTRAINT permission_id_refs_id_4d2ad9935b560df FOREIGN KEY (permission_id) REFERENCES auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2583 (class 2606 OID 120658)
-- Dependencies: 2378 162 233
-- Name: permission_id_refs_id_6b69e5b38352772a; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY guardian_userobjectpermission
    ADD CONSTRAINT permission_id_refs_id_6b69e5b38352772a FOREIGN KEY (permission_id) REFERENCES auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2566 (class 2606 OID 120266)
-- Dependencies: 172 2402 201
-- Name: piston_consumer_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY piston_consumer
    ADD CONSTRAINT piston_consumer_user_id_fkey FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2568 (class 2606 OID 120284)
-- Dependencies: 201 203 2459
-- Name: piston_token_consumer_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY piston_token
    ADD CONSTRAINT piston_token_consumer_id_fkey FOREIGN KEY (consumer_id) REFERENCES piston_consumer(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2567 (class 2606 OID 120279)
-- Dependencies: 2402 172 203
-- Name: piston_token_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY piston_token
    ADD CONSTRAINT piston_token_user_id_fkey FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2576 (class 2606 OID 120519)
-- Dependencies: 222 224 2503
-- Name: project_id_refs_id_3d2f395ad463ebed; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY ldt_utils_project_contents
    ADD CONSTRAINT project_id_refs_id_3d2f395ad463ebed FOREIGN KEY (project_id) REFERENCES ldt_utils_project(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2578 (class 2606 OID 120531)
-- Dependencies: 222 2503 226
-- Name: project_obj_id_refs_id_f7dc408b0b5fe3f; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY ldt_utils_segment
    ADD CONSTRAINT project_obj_id_refs_id_f7dc408b0b5fe3f FOREIGN KEY (project_obj_id) REFERENCES ldt_utils_project(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2559 (class 2606 OID 120128)
-- Dependencies: 172 2402 181
-- Name: registration_registrationprofile_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY registration_registrationprofile
    ADD CONSTRAINT registration_registrationprofile_user_id_fkey FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2569 (class 2606 OID 120302)
-- Dependencies: 205 172 2402
-- Name: social_auth_usersocialauth_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY social_auth_usersocialauth
    ADD CONSTRAINT social_auth_usersocialauth_user_id_fkey FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2561 (class 2606 OID 120159)
-- Dependencies: 174 2408 185
-- Name: tagging_taggeditem_content_type_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY tagging_taggeditem
    ADD CONSTRAINT tagging_taggeditem_content_type_id_fkey FOREIGN KEY (content_type_id) REFERENCES django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2560 (class 2606 OID 120154)
-- Dependencies: 183 2425 185
-- Name: tagging_taggeditem_tag_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY tagging_taggeditem
    ADD CONSTRAINT tagging_taggeditem_tag_id_fkey FOREIGN KEY (tag_id) REFERENCES tagging_tag(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2581 (class 2606 OID 120606)
-- Dependencies: 172 229 2402
-- Name: user_id_refs_id_23ae1fa1db3a7c80; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY user_userprofile
    ADD CONSTRAINT user_id_refs_id_23ae1fa1db3a7c80 FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2556 (class 2606 OID 120060)
-- Dependencies: 172 2402 170
-- Name: user_id_refs_id_831107f1; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY auth_user_groups
    ADD CONSTRAINT user_id_refs_id_831107f1 FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2585 (class 2606 OID 120670)
-- Dependencies: 233 172 2402
-- Name: user_id_refs_id_e4b08bac101bc94; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY guardian_userobjectpermission
    ADD CONSTRAINT user_id_refs_id_e4b08bac101bc94 FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2554 (class 2606 OID 120055)
-- Dependencies: 168 172 2402
-- Name: user_id_refs_id_f2045483; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY auth_user_user_permissions
    ADD CONSTRAINT user_id_refs_id_f2045483 FOREIGN KEY (user_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2580 (class 2606 OID 120578)
-- Dependencies: 2402 227 172
-- Name: user_ptr_id_refs_id_3d88f8ff9e71be00; Type: FK CONSTRAINT; Schema: public; Owner: iri
--

ALTER TABLE ONLY user_ldt
    ADD CONSTRAINT user_ptr_id_refs_id_3d88f8ff9e71be00 FOREIGN KEY (user_ptr_id) REFERENCES auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- TOC entry 2635 (class 0 OID 0)
-- Dependencies: 6
-- 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;


-- Completed on 2012-06-08 02:32:27 CEST

--
-- PostgreSQL database dump complete
--