--
--


--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';





--
-- Name: account_emailaddress; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE account_emailaddress (
    id integer NOT NULL,
    email character varying(254) NOT NULL,
    verified boolean NOT NULL,
    "primary" boolean NOT NULL,
    user_id integer NOT NULL
);


ALTER TABLE account_emailaddress OWNER TO django;

--
-- Name: account_emailaddress_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE account_emailaddress_id_seq OWNER TO django;

--
-- Name: account_emailaddress_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE account_emailaddress_id_seq OWNED BY account_emailaddress.id;

--
-- Name: account_emailconfirmation_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE account_emailconfirmation_id_seq OWNER TO django;

--
-- Name: account_emailconfirmation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE account_emailconfirmation_id_seq OWNED BY account_emailconfirmation.id;


--
-- Name: accounts_achievement; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE accounts_achievement (
    id integer NOT NULL,
    name character varying(100) NOT NULL,
    count integer NOT NULL,
    buyer_id integer NOT NULL
);


ALTER TABLE accounts_achievement OWNER TO django;

--
-- Name: accounts_achievement_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE accounts_achievement_id_seq OWNER TO django;

--
-- Name: accounts_achievement_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE accounts_achievement_id_seq OWNED BY accounts_achievement.id;


--
-- Name: accounts_buyer; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE accounts_buyer (
    id integer NOT NULL,
    points integer NOT NULL,
    longitude double precision NOT NULL,
    latitude double precision NOT NULL,
    role integer NOT NULL,
    criteria_matching character varying(100) NOT NULL,
    user_account_id integer NOT NULL
);


ALTER TABLE accounts_buyer OWNER TO django;

--
-- Name: accounts_buyer_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE accounts_buyer_id_seq OWNER TO django;

--
-- Name: accounts_buyer_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE accounts_buyer_id_seq OWNED BY accounts_buyer.id;


--
-- Name: accounts_clientprofile; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE accounts_clientprofile (
    id integer NOT NULL,
    name character varying(100) NOT NULL,
    description text,
    buyer_id integer NOT NULL
);


ALTER TABLE accounts_clientprofile OWNER TO django;

--
-- Name: accounts_clientprofile_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE accounts_clientprofile_id_seq OWNER TO django;

--
-- Name: accounts_clientprofile_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE accounts_clientprofile_id_seq OWNED BY accounts_clientprofile.id;


--
-- Name: accounts_clientprofile_interests; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE accounts_clientprofile_interests (
    id integer NOT NULL,
    clientprofile_id integer NOT NULL,
    subcategory_id integer NOT NULL
);


ALTER TABLE accounts_clientprofile_interests OWNER TO django;

--
-- Name: accounts_clientprofile_interests_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE accounts_clientprofile_interests_id_seq OWNER TO django;

--
-- Name: accounts_clientprofile_interests_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE accounts_clientprofile_interests_id_seq OWNED BY accounts_clientprofile_interests.id;


--
-- Name: accounts_ownershop; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE accounts_ownershop (
    id integer NOT NULL,
    user_account_id integer NOT NULL
);


ALTER TABLE accounts_ownershop OWNER TO django;

--
-- Name: accounts_ownershop_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE accounts_ownershop_id_seq OWNER TO django;

--
-- Name: accounts_ownershop_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE accounts_ownershop_id_seq OWNED BY accounts_ownershop.id;


--
-- Name: accounts_seller; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE accounts_seller (
    id integer NOT NULL,
    experience integer NOT NULL,
    role integer NOT NULL,
    user_account_id integer NOT NULL
);


ALTER TABLE accounts_seller OWNER TO django;

--
-- Name: accounts_seller_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE accounts_seller_id_seq OWNER TO django;

--
-- Name: accounts_seller_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE accounts_seller_id_seq OWNED BY accounts_seller.id;


--
-- Name: accounts_sellertarget; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE accounts_sellertarget (
    id integer NOT NULL,
    name character varying(100) NOT NULL,
    description text,
    seller_id integer NOT NULL
);


ALTER TABLE accounts_sellertarget OWNER TO django;

--
-- Name: accounts_sellertarget_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE accounts_sellertarget_id_seq OWNER TO django;

--
-- Name: accounts_sellertarget_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE accounts_sellertarget_id_seq OWNED BY accounts_sellertarget.id;


--
-- Name: accounts_sellertarget_target; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE accounts_sellertarget_target (
    id integer NOT NULL,
    sellertarget_id integer NOT NULL,
    subcategory_id integer NOT NULL
);


ALTER TABLE accounts_sellertarget_target OWNER TO django;

--
-- Name: accounts_sellertarget_target_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE accounts_sellertarget_target_id_seq OWNER TO django;

--
-- Name: accounts_sellertarget_target_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE accounts_sellertarget_target_id_seq OWNED BY accounts_sellertarget_target.id;


--
-- Name: accounts_shoppinglistitem; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE accounts_shoppinglistitem (
    id integer NOT NULL,
    description character varying(255),
    buyer_id integer NOT NULL,
    subcategory_id integer NOT NULL
);


ALTER TABLE accounts_shoppinglistitem OWNER TO django;

--
-- Name: accounts_shoppinglistitem_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE accounts_shoppinglistitem_id_seq OWNER TO django;

--
-- Name: accounts_shoppinglistitem_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE accounts_shoppinglistitem_id_seq OWNED BY accounts_shoppinglistitem.id;

--
-- Name: accounts_useraccount_groups; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE accounts_useraccount_groups (
    id integer NOT NULL,
    useraccount_id integer NOT NULL,
    group_id integer NOT NULL
);


ALTER TABLE accounts_useraccount_groups OWNER TO django;

--
-- Name: accounts_useraccount_groups_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE accounts_useraccount_groups_id_seq OWNER TO django;

--
-- Name: accounts_useraccount_groups_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE accounts_useraccount_groups_id_seq OWNED BY accounts_useraccount_groups.id;


--
-- Name: accounts_useraccount_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE accounts_useraccount_id_seq OWNER TO django;

--
-- Name: accounts_useraccount_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE accounts_useraccount_id_seq OWNED BY accounts_useraccount.id;


--
-- Name: accounts_useraccount_user_permissions; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE accounts_useraccount_user_permissions (
    id integer NOT NULL,
    useraccount_id integer NOT NULL,
    permission_id integer NOT NULL
);


ALTER TABLE accounts_useraccount_user_permissions OWNER TO django;

--
-- Name: accounts_useraccount_user_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE accounts_useraccount_user_permissions_id_seq OWNER TO django;

--
-- Name: accounts_useraccount_user_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE accounts_useraccount_user_permissions_id_seq OWNED BY accounts_useraccount_user_permissions.id;


--
-- Name: admon_category; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE admon_category (
    id integer NOT NULL,
    name character varying(100) NOT NULL,
    image character varying(255) NOT NULL,
    active boolean NOT NULL
);


ALTER TABLE admon_category OWNER TO django;

--
-- Name: admon_category_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE admon_category_id_seq OWNER TO django;

--
-- Name: admon_category_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE admon_category_id_seq OWNED BY admon_category.id;


--
-- Name: admon_category_subcategories; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE admon_category_subcategories (
    id integer NOT NULL,
    category_id integer NOT NULL,
    subcategory_id integer NOT NULL
);


ALTER TABLE admon_category_subcategories OWNER TO django;

--
-- Name: admon_category_subcategories_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE admon_category_subcategories_id_seq OWNER TO django;

--
-- Name: admon_category_subcategories_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE admon_category_subcategories_id_seq OWNED BY admon_category_subcategories.id;


--
-- Name: admon_subcategory; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE admon_subcategory (
    id integer NOT NULL,
    name character varying(100) NOT NULL,
    image character varying(255) NOT NULL,
    active boolean NOT NULL
);


ALTER TABLE admon_subcategory OWNER TO django;

--
-- Name: admon_subcategory_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE admon_subcategory_id_seq OWNER TO django;

--
-- Name: admon_subcategory_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE admon_subcategory_id_seq OWNED BY admon_subcategory.id;


--
-- Name: auth_group; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

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


ALTER TABLE auth_group OWNER TO django;

--
-- Name: auth_group_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE auth_group_id_seq OWNER TO django;

--
-- Name: auth_group_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE auth_group_id_seq OWNED BY auth_group.id;


--
-- Name: auth_group_permissions; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

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


ALTER TABLE auth_group_permissions OWNER TO django;

--
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE auth_group_permissions_id_seq OWNER TO django;

--
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE auth_group_permissions_id_seq OWNED BY auth_group_permissions.id;


--
-- Name: auth_permission; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

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


ALTER TABLE auth_permission OWNER TO django;

--
-- Name: auth_permission_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE auth_permission_id_seq OWNER TO django;

--
-- Name: auth_permission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE auth_permission_id_seq OWNED BY auth_permission.id;

--
-- Name: billing_bill; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE billing_bill (
    id integer NOT NULL,
    payment_id integer NOT NULL,
    date timestamp with time zone NOT NULL,
    account_id integer NOT NULL
);


ALTER TABLE billing_bill OWNER TO django;

--
-- Name: billing_bill_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE billing_bill_id_seq OWNER TO django;

--
-- Name: billing_bill_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE billing_bill_id_seq OWNED BY billing_bill.id;


--
-- Name: django_admin_log; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

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


ALTER TABLE django_admin_log OWNER TO django;

--
-- Name: django_admin_log_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE django_admin_log_id_seq OWNER TO django;

--
-- Name: django_admin_log_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE django_admin_log_id_seq OWNED BY django_admin_log.id;


--
-- Name: django_content_type; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

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


ALTER TABLE django_content_type OWNER TO django;

--
-- Name: django_content_type_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE django_content_type_id_seq OWNER TO django;

--
-- Name: django_content_type_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE django_content_type_id_seq OWNED BY django_content_type.id;


--
-- Name: django_migrations; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE django_migrations (
    id integer NOT NULL,
    app character varying(255) NOT NULL,
    name character varying(255) NOT NULL,
    applied timestamp with time zone NOT NULL
);


ALTER TABLE django_migrations OWNER TO django;

--
-- Name: django_migrations_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE django_migrations_id_seq OWNER TO django;

--
-- Name: django_migrations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE django_migrations_id_seq OWNED BY django_migrations.id;

--
-- Name: django_site; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

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


ALTER TABLE django_site OWNER TO django;

--
-- Name: django_site_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE django_site_id_seq OWNER TO django;

--
-- Name: django_site_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE django_site_id_seq OWNED BY django_site.id;


--
-- Name: easy_thumbnails_source; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE easy_thumbnails_source (
    id integer NOT NULL,
    storage_hash character varying(40) NOT NULL,
    name character varying(255) NOT NULL,
    modified timestamp with time zone NOT NULL
);


ALTER TABLE easy_thumbnails_source OWNER TO django;

--
-- Name: easy_thumbnails_source_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE easy_thumbnails_source_id_seq OWNER TO django;

--
-- Name: easy_thumbnails_source_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE easy_thumbnails_source_id_seq OWNED BY easy_thumbnails_source.id;


--
-- Name: easy_thumbnails_thumbnail; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE easy_thumbnails_thumbnail (
    id integer NOT NULL,
    storage_hash character varying(40) NOT NULL,
    name character varying(255) NOT NULL,
    modified timestamp with time zone NOT NULL,
    source_id integer NOT NULL
);


ALTER TABLE easy_thumbnails_thumbnail OWNER TO django;

--
-- Name: easy_thumbnails_thumbnail_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE easy_thumbnails_thumbnail_id_seq OWNER TO django;

--
-- Name: easy_thumbnails_thumbnail_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE easy_thumbnails_thumbnail_id_seq OWNED BY easy_thumbnails_thumbnail.id;


--
-- Name: easy_thumbnails_thumbnaildimensions; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE easy_thumbnails_thumbnaildimensions (
    id integer NOT NULL,
    thumbnail_id integer NOT NULL,
    width integer,
    height integer,
    CONSTRAINT easy_thumbnails_thumbnaildimensions_height_check CHECK ((height >= 0)),
    CONSTRAINT easy_thumbnails_thumbnaildimensions_width_check CHECK ((width >= 0))
);


ALTER TABLE easy_thumbnails_thumbnaildimensions OWNER TO django;

--
-- Name: easy_thumbnails_thumbnaildimensions_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE easy_thumbnails_thumbnaildimensions_id_seq OWNER TO django;

--
-- Name: easy_thumbnails_thumbnaildimensions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE easy_thumbnails_thumbnaildimensions_id_seq OWNED BY easy_thumbnails_thumbnaildimensions.id;


--
-- Name: filer_clipboard; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE filer_clipboard (
    id integer NOT NULL,
    user_id integer NOT NULL
);


ALTER TABLE filer_clipboard OWNER TO django;

--
-- Name: filer_clipboard_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE filer_clipboard_id_seq OWNER TO django;

--
-- Name: filer_clipboard_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE filer_clipboard_id_seq OWNED BY filer_clipboard.id;


--
-- Name: filer_clipboarditem; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE filer_clipboarditem (
    id integer NOT NULL,
    clipboard_id integer NOT NULL,
    file_id integer NOT NULL
);


ALTER TABLE filer_clipboarditem OWNER TO django;

--
-- Name: filer_clipboarditem_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE filer_clipboarditem_id_seq OWNER TO django;

--
-- Name: filer_clipboarditem_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE filer_clipboarditem_id_seq OWNED BY filer_clipboarditem.id;


--
-- Name: filer_file; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE filer_file (
    id integer NOT NULL,
    file character varying(255),
    _file_size integer,
    sha1 character varying(40) NOT NULL,
    has_all_mandatory_data boolean NOT NULL,
    original_filename character varying(255),
    name character varying(255) NOT NULL,
    description text,
    uploaded_at timestamp with time zone NOT NULL,
    modified_at timestamp with time zone NOT NULL,
    is_public boolean NOT NULL,
    folder_id integer,
    owner_id integer,
    polymorphic_ctype_id integer
);


ALTER TABLE filer_file OWNER TO django;

--
-- Name: filer_file_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE filer_file_id_seq OWNER TO django;

--
-- Name: filer_file_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE filer_file_id_seq OWNED BY filer_file.id;


--
-- Name: filer_folder; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE filer_folder (
    id integer NOT NULL,
    name character varying(255) NOT NULL,
    uploaded_at timestamp with time zone NOT NULL,
    created_at timestamp with time zone NOT NULL,
    modified_at timestamp with time zone NOT NULL,
    lft integer NOT NULL,
    rght integer NOT NULL,
    tree_id integer NOT NULL,
    level integer NOT NULL,
    owner_id integer,
    parent_id integer,
    CONSTRAINT filer_folder_level_check CHECK ((level >= 0)),
    CONSTRAINT filer_folder_lft_check CHECK ((lft >= 0)),
    CONSTRAINT filer_folder_rght_check CHECK ((rght >= 0)),
    CONSTRAINT filer_folder_tree_id_check CHECK ((tree_id >= 0))
);


ALTER TABLE filer_folder OWNER TO django;

--
-- Name: filer_folder_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE filer_folder_id_seq OWNER TO django;

--
-- Name: filer_folder_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE filer_folder_id_seq OWNED BY filer_folder.id;


--
-- Name: filer_folderpermission; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE filer_folderpermission (
    id integer NOT NULL,
    type smallint NOT NULL,
    everybody boolean NOT NULL,
    can_edit smallint,
    can_read smallint,
    can_add_children smallint,
    folder_id integer,
    group_id integer,
    user_id integer
);


ALTER TABLE filer_folderpermission OWNER TO django;

--
-- Name: filer_folderpermission_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE filer_folderpermission_id_seq OWNER TO django;

--
-- Name: filer_folderpermission_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE filer_folderpermission_id_seq OWNED BY filer_folderpermission.id;


--
-- Name: filer_image; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE filer_image (
    file_ptr_id integer NOT NULL,
    _height integer,
    _width integer,
    date_taken timestamp with time zone,
    default_alt_text character varying(255),
    default_caption character varying(255),
    author character varying(255),
    must_always_publish_author_credit boolean NOT NULL,
    must_always_publish_copyright boolean NOT NULL,
    subject_location character varying(64) NOT NULL
);


ALTER TABLE filer_image OWNER TO django;

--
-- Name: filer_thumbnailoption; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE filer_thumbnailoption (
    id integer NOT NULL,
    name character varying(100) NOT NULL,
    width integer NOT NULL,
    height integer NOT NULL,
    crop boolean NOT NULL,
    upscale boolean NOT NULL
);


ALTER TABLE filer_thumbnailoption OWNER TO django;

--
-- Name: filer_thumbnailoption_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE filer_thumbnailoption_id_seq OWNER TO django;

--
-- Name: filer_thumbnailoption_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE filer_thumbnailoption_id_seq OWNED BY filer_thumbnailoption.id;

--
-- Name: oauth2_provider_accesstoken_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE oauth2_provider_accesstoken_id_seq OWNER TO django;

--
-- Name: oauth2_provider_accesstoken_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE oauth2_provider_accesstoken_id_seq OWNED BY oauth2_provider_accesstoken.id;

--
-- Name: oauth2_provider_application_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE oauth2_provider_application_id_seq OWNER TO django;

--
-- Name: oauth2_provider_application_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE oauth2_provider_application_id_seq OWNED BY oauth2_provider_application.id;


--
-- Name: oauth2_provider_grant; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE oauth2_provider_grant (
    id integer NOT NULL,
    code character varying(255) NOT NULL,
    expires timestamp with time zone NOT NULL,
    redirect_uri character varying(255) NOT NULL,
    scope text NOT NULL,
    application_id integer NOT NULL,
    user_id integer NOT NULL
);


ALTER TABLE oauth2_provider_grant OWNER TO django;

--
-- Name: oauth2_provider_grant_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE oauth2_provider_grant_id_seq OWNER TO django;

--
-- Name: oauth2_provider_grant_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE oauth2_provider_grant_id_seq OWNED BY oauth2_provider_grant.id;

--
-- Name: oauth2_provider_refreshtoken_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE oauth2_provider_refreshtoken_id_seq OWNER TO django;

--
-- Name: oauth2_provider_refreshtoken_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE oauth2_provider_refreshtoken_id_seq OWNED BY oauth2_provider_refreshtoken.id;


--
-- Name: shop_bookmarkspromotionitem; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE shop_bookmarkspromotionitem (
    id integer NOT NULL,
    buyer_id integer NOT NULL,
    promotion_id integer NOT NULL
);


ALTER TABLE shop_bookmarkspromotionitem OWNER TO django;

--
-- Name: shop_bookmarkspromotionitem_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE shop_bookmarkspromotionitem_id_seq OWNER TO django;

--
-- Name: shop_bookmarkspromotionitem_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE shop_bookmarkspromotionitem_id_seq OWNED BY shop_bookmarkspromotionitem.id;


--
-- Name: shop_coupon; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE shop_coupon (
    id integer NOT NULL,
    status integer NOT NULL,
    buyer_id integer NOT NULL,
    promotion_id integer NOT NULL
);


ALTER TABLE shop_coupon OWNER TO django;

--
-- Name: shop_coupon_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE shop_coupon_id_seq OWNER TO django;

--
-- Name: shop_coupon_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE shop_coupon_id_seq OWNED BY shop_coupon.id;


--
-- Name: shop_promotion; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE shop_promotion (
    id integer NOT NULL,
    name character varying(100) NOT NULL,
    description text NOT NULL,
    regular_price numeric(9,2) NOT NULL,
    offered_price numeric(9,2) NOT NULL,
    discount_rate double precision NOT NULL,
    type integer NOT NULL,
    status integer NOT NULL,
    quantity_coupons integer NOT NULL,
    seller_id integer NOT NULL,
    available_coupons integer
);


ALTER TABLE shop_promotion OWNER TO django;

--
-- Name: shop_promotion_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE shop_promotion_id_seq OWNER TO django;

--
-- Name: shop_promotion_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE shop_promotion_id_seq OWNED BY shop_promotion.id;


--
-- Name: shop_promotion_target; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE shop_promotion_target (
    id integer NOT NULL,
    promotion_id integer NOT NULL,
    subcategory_id integer NOT NULL
);


ALTER TABLE shop_promotion_target OWNER TO django;

--
-- Name: shop_promotion_target_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE shop_promotion_target_id_seq OWNER TO django;

--
-- Name: shop_promotion_target_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE shop_promotion_target_id_seq OWNED BY shop_promotion_target.id;


--
-- Name: shop_promotionimage; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE shop_promotionimage (
    id integer NOT NULL,
    name character varying(100) NOT NULL,
    image character varying(100) NOT NULL,
    promotion_id integer NOT NULL
);


ALTER TABLE shop_promotionimage OWNER TO django;

--
-- Name: shop_promotionimage_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE shop_promotionimage_id_seq OWNER TO django;

--
-- Name: shop_promotionimage_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE shop_promotionimage_id_seq OWNED BY shop_promotionimage.id;

--
-- Name: social_auth_association_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE social_auth_association_id_seq OWNER TO django;

--
-- Name: social_auth_association_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE social_auth_association_id_seq OWNED BY social_auth_association.id;


--
-- Name: social_auth_code; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE social_auth_code (
    id integer NOT NULL,
    email character varying(254) NOT NULL,
    code character varying(32) NOT NULL,
    verified boolean NOT NULL
);


ALTER TABLE social_auth_code OWNER TO django;

--
-- Name: social_auth_code_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE social_auth_code_id_seq OWNER TO django;

--
-- Name: social_auth_code_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE social_auth_code_id_seq OWNED BY social_auth_code.id;

--
-- Name: social_auth_nonce_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE social_auth_nonce_id_seq OWNER TO django;

--
-- Name: social_auth_nonce_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE social_auth_nonce_id_seq OWNED BY social_auth_nonce.id;


--
-- Name: social_auth_usersocialauth; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

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


ALTER TABLE social_auth_usersocialauth OWNER TO django;

--
-- Name: social_auth_usersocialauth_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE social_auth_usersocialauth_id_seq OWNER TO django;

--
-- Name: social_auth_usersocialauth_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE social_auth_usersocialauth_id_seq OWNED BY social_auth_usersocialauth.id;


--
-- Name: socialaccount_socialaccount; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE socialaccount_socialaccount (
    id integer NOT NULL,
    provider character varying(30) NOT NULL,
    uid character varying(191) NOT NULL,
    last_login timestamp with time zone NOT NULL,
    date_joined timestamp with time zone NOT NULL,
    extra_data text NOT NULL,
    user_id integer NOT NULL
);


ALTER TABLE socialaccount_socialaccount OWNER TO django;

--
-- Name: socialaccount_socialaccount_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE socialaccount_socialaccount_id_seq OWNER TO django;

--
-- Name: socialaccount_socialaccount_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE socialaccount_socialaccount_id_seq OWNED BY socialaccount_socialaccount.id;

--
-- Name: socialaccount_socialapp_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE socialaccount_socialapp_id_seq OWNER TO django;

--
-- Name: socialaccount_socialapp_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE socialaccount_socialapp_id_seq OWNED BY socialaccount_socialapp.id;


--
-- Name: socialaccount_socialapp_sites; Type: TABLE; Schema: public; Owner: django; Tablespace: 
--

CREATE TABLE socialaccount_socialapp_sites (
    id integer NOT NULL,
    socialapp_id integer NOT NULL,
    site_id integer NOT NULL
);


ALTER TABLE socialaccount_socialapp_sites OWNER TO django;

--
-- Name: socialaccount_socialapp_sites_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE socialaccount_socialapp_sites_id_seq OWNER TO django;

--
-- Name: socialaccount_socialapp_sites_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE socialaccount_socialapp_sites_id_seq OWNED BY socialaccount_socialapp_sites.id;

--
-- Name: socialaccount_socialtoken_id_seq; Type: SEQUENCE; Schema: public; Owner: django
--

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


ALTER TABLE socialaccount_socialtoken_id_seq OWNER TO django;

--
-- Name: socialaccount_socialtoken_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: django
--

ALTER SEQUENCE socialaccount_socialtoken_id_seq OWNED BY socialaccount_socialtoken.id;


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY account_emailaddress ALTER COLUMN id SET DEFAULT nextval('account_emailaddress_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY accounts_achievement ALTER COLUMN id SET DEFAULT nextval('accounts_achievement_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY accounts_buyer ALTER COLUMN id SET DEFAULT nextval('accounts_buyer_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY accounts_clientprofile ALTER COLUMN id SET DEFAULT nextval('accounts_clientprofile_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY accounts_clientprofile_interests ALTER COLUMN id SET DEFAULT nextval('accounts_clientprofile_interests_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY accounts_ownershop ALTER COLUMN id SET DEFAULT nextval('accounts_ownershop_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY accounts_seller ALTER COLUMN id SET DEFAULT nextval('accounts_seller_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY accounts_sellertarget ALTER COLUMN id SET DEFAULT nextval('accounts_sellertarget_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY accounts_sellertarget_target ALTER COLUMN id SET DEFAULT nextval('accounts_sellertarget_target_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY accounts_shoppinglistitem ALTER COLUMN id SET DEFAULT nextval('accounts_shoppinglistitem_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY accounts_useraccount_groups ALTER COLUMN id SET DEFAULT nextval('accounts_useraccount_groups_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY accounts_useraccount_user_permissions ALTER COLUMN id SET DEFAULT nextval('accounts_useraccount_user_permissions_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY admon_category ALTER COLUMN id SET DEFAULT nextval('admon_category_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY admon_category_subcategories ALTER COLUMN id SET DEFAULT nextval('admon_category_subcategories_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY admon_subcategory ALTER COLUMN id SET DEFAULT nextval('admon_subcategory_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

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


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

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


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

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


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY billing_bill ALTER COLUMN id SET DEFAULT nextval('billing_bill_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

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


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

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


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY django_migrations ALTER COLUMN id SET DEFAULT nextval('django_migrations_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

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


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY easy_thumbnails_source ALTER COLUMN id SET DEFAULT nextval('easy_thumbnails_source_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY easy_thumbnails_thumbnail ALTER COLUMN id SET DEFAULT nextval('easy_thumbnails_thumbnail_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY easy_thumbnails_thumbnaildimensions ALTER COLUMN id SET DEFAULT nextval('easy_thumbnails_thumbnaildimensions_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY filer_clipboard ALTER COLUMN id SET DEFAULT nextval('filer_clipboard_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY filer_clipboarditem ALTER COLUMN id SET DEFAULT nextval('filer_clipboarditem_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY filer_file ALTER COLUMN id SET DEFAULT nextval('filer_file_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY filer_folder ALTER COLUMN id SET DEFAULT nextval('filer_folder_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY filer_folderpermission ALTER COLUMN id SET DEFAULT nextval('filer_folderpermission_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY filer_thumbnailoption ALTER COLUMN id SET DEFAULT nextval('filer_thumbnailoption_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY oauth2_provider_grant ALTER COLUMN id SET DEFAULT nextval('oauth2_provider_grant_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY shop_bookmarkspromotionitem ALTER COLUMN id SET DEFAULT nextval('shop_bookmarkspromotionitem_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY shop_coupon ALTER COLUMN id SET DEFAULT nextval('shop_coupon_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY shop_promotion ALTER COLUMN id SET DEFAULT nextval('shop_promotion_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY shop_promotion_target ALTER COLUMN id SET DEFAULT nextval('shop_promotion_target_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY shop_promotionimage ALTER COLUMN id SET DEFAULT nextval('shop_promotionimage_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY social_auth_code ALTER COLUMN id SET DEFAULT nextval('social_auth_code_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

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


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY socialaccount_socialaccount ALTER COLUMN id SET DEFAULT nextval('socialaccount_socialaccount_id_seq'::regclass);


--
-- Name: id; Type: DEFAULT; Schema: public; Owner: django
--

ALTER TABLE ONLY socialaccount_socialapp_sites ALTER COLUMN id SET DEFAULT nextval('socialaccount_socialapp_sites_id_seq'::regclass);


--
-- Data for Name: account_emailaddress; Type: TABLE DATA; Schema: public; Owner: django
--

COPY account_emailaddress (id, email, verified, "primary", user_id) FROM stdin;
\.



--
-- Data for Name: accounts_achievement; Type: TABLE DATA; Schema: public; Owner: django
--

COPY accounts_achievement (id, name, count, buyer_id) FROM stdin;
\.



--
-- Data for Name: accounts_buyer; Type: TABLE DATA; Schema: public; Owner: django
--

COPY accounts_buyer (id, points, longitude, latitude, role, criteria_matching, user_account_id) FROM stdin;
3	0	0	0	2	Client Profile	5
7	0	0	0	2	Client Profile	9
8	0	0	0	2	Client Profile	11
9	0	0	0	2	Client Profile	12
11	0	0	0	2	Client Profile	14
12	0	0	0	2	Client Profile	15
13	0	0	0	2	Client Profile	16
15	0	0	0	2	Client Profile	17
14	0	0	0	2	Client Profile	18
10	0	0	0	2	Client Profile	13
4	0	0	0	2	Client Profile	6
16	0	0	0	2	Client Profile	21
17	0	0	0	2	Client Profile	22
18	0	0	0	2	Shopping List	23
5	0	0	0	2	Client Profile	7
2	0	0	0	2	Client Profile	4
1	0	0	0	2	Client Profile	2
6	0	0	0	2	Shopping List	8
\.



--
-- Data for Name: accounts_clientprofile; Type: TABLE DATA; Schema: public; Owner: django
--

COPY accounts_clientprofile (id, name, description, buyer_id) FROM stdin;
7	Main Profile	Main Profile	7
13	Main Profile	Main Profile	13
12	Main Profile	Main Profile	12
15	Main Profile	Main Profile	15
14	Main Profile	Main Profile	14
8	Main Profile	Main Profile	8
9	Main Profile	Main Profile	9
2	Main Profile	Main Profile	2
3	new profile	\N	3
10	Main Profile	Main Profile	10
16	new profile	\N	16
11	Main Profile	Main Profile	11
1	Main Profile	Main Profile	1
6	Main Profile	Main Profile	6
4	Main Profile	Main Profile	4
18	Main Profile	Main Profile	18
17	Main Profile	Main Profile	17
5	Main Profile	Main Profile	5
\.



--
-- Data for Name: accounts_clientprofile_interests; Type: TABLE DATA; Schema: public; Owner: django
--

COPY accounts_clientprofile_interests (id, clientprofile_id, subcategory_id) FROM stdin;
170	13	1
228	11	19
475	1	3
476	1	6
477	1	5
478	1	4
7	2	1
8	2	6
9	2	15
10	2	9
479	1	59
587	15	24
481	1	62
14	2	11
588	15	25
589	15	22
484	1	64
485	1	63
19	6	29
20	6	1
21	6	7
22	6	65
590	15	23
24	6	69
25	6	72
26	6	75
27	7	56
28	7	22
487	1	85
488	1	84
489	1	14
35	8	9
36	9	57
37	11	1
38	10	9
39	11	172
40	10	1
41	11	171
327	18	65
48	12	17
328	18	72
329	18	74
330	18	78
331	18	161
332	18	162
333	18	171
334	18	172
335	18	174
336	18	176
337	18	114
338	18	115
339	18	50
203	14	160
204	14	1
205	14	2
206	14	3
207	14	9
340	18	117
341	18	55
342	18	56
343	18	121
344	17	1
345	17	35
208	14	10
346	17	3
209	14	11
347	17	5
348	17	10
349	17	11
210	14	159
211	14	87
350	17	45
351	17	14
352	17	47
353	17	13
354	17	50
355	17	55
356	17	56
357	17	26
358	17	27
224	11	15
226	11	9
227	11	12
369	5	171
446	4	14
451	4	19
452	4	11
453	4	176
455	4	174
456	5	5
457	5	3
459	5	14
542	15	49
462	5	13
543	15	50
544	15	51
545	15	52
546	15	53
547	15	54
548	15	55
549	15	56
550	15	57
551	15	64
552	15	65
553	15	66
554	15	67
555	15	68
556	15	69
557	15	70
558	15	71
559	15	72
560	15	73
561	15	74
562	15	75
563	15	76
564	15	77
565	15	78
566	15	79
567	15	80
568	15	58
569	15	59
570	15	60
571	15	61
572	15	62
573	15	63
\.



--
-- Data for Name: accounts_ownershop; Type: TABLE DATA; Schema: public; Owner: django
--

COPY accounts_ownershop (id, user_account_id) FROM stdin;
\.



--
-- Data for Name: accounts_seller; Type: TABLE DATA; Schema: public; Owner: django
--

COPY accounts_seller (id, experience, role, user_account_id) FROM stdin;
1	0	3	2
2	0	3	3
3	0	3	5
4	0	3	4
5	0	3	6
6	0	3	8
7	0	3	10
8	0	3	9
9	0	3	11
10	0	3	12
11	0	3	13
12	0	3	14
13	0	3	15
14	0	3	7
15	0	3	17
16	0	3	18
17	0	3	20
18	0	3	21
19	0	3	23
20	0	3	24
\.



--
-- Data for Name: accounts_sellertarget; Type: TABLE DATA; Schema: public; Owner: django
--

COPY accounts_sellertarget (id, name, description, seller_id) FROM stdin;
8	new category	\N	8
18	new category	\N	18
10	new category	\N	10
4	new category	\N	4
3	new category	\N	3
12	new category	\N	12
17	new category	\N	17
2	new category	\N	2
20	new category	\N	20
6	new category	\N	6
13	new category	\N	13
19	new category	\N	19
5	new category	\N	5
9	new category	\N	9
7	new category	\N	7
14	new category	\N	14
16	new category	\N	16
1	new category	\N	1
11	new category	\N	11
15	new category	\N	15
\.



--
-- Data for Name: accounts_sellertarget_target; Type: TABLE DATA; Schema: public; Owner: django
--

COPY accounts_sellertarget_target (id, sellertarget_id, subcategory_id) FROM stdin;
1	2	62
2	3	1
10	6	127
12	7	176
13	7	171
14	7	172
15	7	173
16	7	24
17	7	9
18	7	10
19	7	11
20	7	23
21	9	9
22	9	10
27	1	22
31	7	1
32	7	2
45	1	144
46	1	9
47	1	143
50	16	64
51	16	33
52	16	34
53	16	3
54	16	2
55	16	1
56	16	62
57	16	63
58	1	49
59	15	1
60	15	2
61	15	3
62	15	4
63	15	5
69	14	2
70	14	83
83	19	32
84	19	177
85	6	1
86	6	7
87	6	81
88	6	11
89	6	14
92	1	26
93	1	27
94	1	28
95	1	29
96	1	12
97	20	9
98	20	10
99	11	1
105	1	61
107	19	11
108	19	13
109	19	14
110	5	129
111	5	177
112	5	171
113	5	172
114	5	11
115	5	14
116	5	13
\.



--
-- Data for Name: accounts_shoppinglistitem; Type: TABLE DATA; Schema: public; Owner: django
--

COPY accounts_shoppinglistitem (id, description, buyer_id, subcategory_id) FROM stdin;
6	Blue shoes	1	1
7		15	179
4	kid wanted	5	179
\.


--
-- Data for Name: accounts_useraccount_groups; Type: TABLE DATA; Schema: public; Owner: django
--

COPY accounts_useraccount_groups (id, useraccount_id, group_id) FROM stdin;
\.



--
-- Data for Name: accounts_useraccount_user_permissions; Type: TABLE DATA; Schema: public; Owner: django
--

COPY accounts_useraccount_user_permissions (id, useraccount_id, permission_id) FROM stdin;
\.



--
-- Data for Name: admon_category; Type: TABLE DATA; Schema: public; Owner: django
--

COPY admon_category (id, name, image, active) FROM stdin;
1	Fashion	res/fashionIcon.svg	t
2	Electronics & Gadgets	res/electronicsIcon.svg	t
3	Office Supplies	res/officeIcon.svg	t
4	Restaurant	res/restaurantIcon.svg	t
5	Food	res/foodIcon.svg	t
6	Services	res/servicesIcon.svg	t
7	Education	res/educationIcon.svg	t
8	Health/Personal Care	res/healthIcon.svg	t
9	Home & Garden	res/homeIcon.svg	t
10	Agriculture & Farms	res/farmIcon.svg	t
11	Classified	res/classifiedIcon.svg	t
12	Local Finds	res/localIcon.svg	t
13	Entertainment	res/entertainmentIcon.svg	t
14	Travel & Hospitality	res/travelIcon.svg	t
15	Pets	res/petsIcon.svg	t
\.



--
-- Data for Name: admon_category_subcategories; Type: TABLE DATA; Schema: public; Owner: django
--

COPY admon_category_subcategories (id, category_id, subcategory_id) FROM stdin;
1	1	1
2	1	2
3	1	3
4	1	4
5	1	5
6	1	6
7	1	7
8	1	8
9	2	9
10	2	10
11	2	11
12	2	12
13	2	13
14	2	14
15	2	15
16	2	16
17	2	17
18	2	18
19	2	19
20	2	20
21	2	21
22	3	22
23	3	23
24	3	24
25	3	25
26	4	26
27	4	27
28	4	28
29	4	29
30	4	30
31	4	31
32	4	32
33	4	33
34	4	34
35	4	35
36	4	36
37	4	37
38	4	38
39	4	39
40	4	40
41	4	41
42	4	42
43	4	43
44	4	44
45	4	45
46	4	46
47	4	47
48	4	48
49	5	49
50	5	50
51	5	51
52	5	52
53	5	53
54	5	54
55	5	55
56	5	56
57	5	57
58	6	58
59	6	59
60	6	60
61	6	61
62	6	62
63	6	63
64	6	64
65	6	65
66	6	66
67	6	67
68	6	68
69	6	69
70	6	70
71	6	71
72	6	72
73	6	73
74	6	74
75	6	75
76	6	76
77	6	77
78	6	78
79	6	79
80	6	80
81	7	81
82	7	82
83	7	83
84	7	84
85	7	85
86	7	86
87	7	87
88	7	88
89	7	89
90	7	90
91	8	91
92	8	92
93	8	93
94	8	94
95	8	95
96	8	96
97	8	97
98	9	98
99	9	99
100	9	100
101	9	101
102	9	102
103	9	103
104	9	104
105	9	105
106	9	106
107	9	107
108	9	108
109	9	109
110	9	110
111	9	111
112	9	112
113	9	113
114	10	114
115	10	115
116	10	116
117	10	117
118	10	118
119	10	119
120	10	120
121	10	121
122	10	122
123	10	123
124	10	124
125	10	125
126	11	126
127	11	127
128	11	128
129	11	129
130	11	130
131	11	131
132	11	132
133	12	133
134	12	134
135	12	135
136	12	136
137	12	137
138	12	138
139	13	139
140	13	140
141	13	141
142	13	142
143	13	143
144	13	144
145	13	145
146	13	146
147	13	147
148	13	148
149	13	149
150	13	150
151	13	151
152	13	152
153	13	153
154	14	154
155	14	155
156	14	156
157	14	157
158	14	158
159	14	159
160	14	160
161	14	161
162	14	162
163	14	163
164	14	164
165	14	165
166	14	166
167	14	167
168	14	168
169	14	169
170	14	170
171	15	171
172	15	172
173	15	173
174	15	174
175	15	175
176	15	176
177	15	177
178	15	178
179	15	179
\.



--
-- Data for Name: admon_subcategory; Type: TABLE DATA; Schema: public; Owner: django
--

COPY admon_subcategory (id, name, image, active) FROM stdin;
1	Fashion/Men	res/fashionIcon.svg	t
2	Fashion/Women	res/fashionIcon.svg	t
3	Fashion/Children & Teens	res/fashionIcon.svg	t
4	Fashion/Work Life	res/fashionIcon.svg	t
5	Fashion/Pets	res/fashionIcon.svg	t
6	Fashion/Accessories	res/fashionIcon.svg	t
7	Fashion/Specialties	res/fashionIcon.svg	t
8	Fashion/Others	res/fashionIcon.svg	t
9	Electronics & Gadgets/Business	res/electronicsIcon.svg	t
10	Electronics & Gadgets/Home	res/electronicsIcon.svg	t
11	Electronics & Gadgets/Personal	res/electronicsIcon.svg	t
12	Electronics & Gadgets/Auto	res/electronicsIcon.svg	t
13	Electronics & Gadgets/Mobile	res/electronicsIcon.svg	t
14	Electronics & Gadgets/Gaming	res/electronicsIcon.svg	t
15	Electronics & Gadgets/Portables (Laptop & Pads)	res/electronicsIcon.svg	t
16	Electronics & Gadgets/Desktop	res/electronicsIcon.svg	t
17	Electronics & Gadgets/Peripherals	res/electronicsIcon.svg	t
18	Electronics & Gadgets/Accessories	res/electronicsIcon.svg	t
19	Electronics & Gadgets/Cool & Nifty	res/electronicsIcon.svg	t
20	Electronics & Gadgets/Specialties	res/electronicsIcon.svg	t
21	Electronics & Gadgets/Others	res/electronicsIcon.svg	t
22	Office Supplies/Paper/Forms	res/officeIcon.svg	t
23	Office Supplies/Writing Instruments	res/officeIcon.svg	t
24	Office Supplies/Art Supplies	res/officeIcon.svg	t
25	Office Supplies/Others	res/officeIcon.svg	t
26	Restaurant/Thai & Southeast Asian	res/restaurantIcon.svg	t
27	Restaurant/Japanese	res/restaurantIcon.svg	t
28	Restaurant/Korean	res/restaurantIcon.svg	t
29	Restaurant/North American	res/restaurantIcon.svg	t
30	Restaurant/French	res/restaurantIcon.svg	t
31	Restaurant/Italian	res/restaurantIcon.svg	t
32	Restaurant/Indian	res/restaurantIcon.svg	t
33	Restaurant/Chinese	res/restaurantIcon.svg	t
34	Restaurant/African	res/restaurantIcon.svg	t
35	Restaurant/Cajun	res/restaurantIcon.svg	t
36	Restaurant/Greek	res/restaurantIcon.svg	t
37	Restaurant/Mediterranean	res/restaurantIcon.svg	t
38	Restaurant/Spanish	res/restaurantIcon.svg	t
39	Restaurant/German	res/restaurantIcon.svg	t
40	Restaurant/Carribean	res/restaurantIcon.svg	t
41	Restaurant/Turkish & Middle East	res/restaurantIcon.svg	t
42	Restaurant/South American	res/restaurantIcon.svg	t
43	Restaurant/Mexican	res/restaurantIcon.svg	t
44	Restaurant/Eastern European	res/restaurantIcon.svg	t
45	Restaurant/Fusion	res/restaurantIcon.svg	t
46	Restaurant/Specialties	res/restaurantIcon.svg	t
47	Restaurant/Award Winners	res/restaurantIcon.svg	t
48	Restaurant/Others	res/restaurantIcon.svg	t
49	Food/Grocery	res/foodIcon.svg	t
50	Food/Organic & Natural	res/foodIcon.svg	t
51	Food/Fast Food	res/foodIcon.svg	t
52	Food/Deserts & Bakeries	res/foodIcon.svg	t
53	Food/Ice Cream	res/foodIcon.svg	t
54	Food/Carts & Food Trucks	res/foodIcon.svg	t
55	Food/Specialties	res/foodIcon.svg	t
56	Food/Award Winners	res/foodIcon.svg	t
57	Food/Others	res/foodIcon.svg	t
58	Services/Real Estate	res/servicesIcon.svg	t
59	Services/Legal & Accounting	res/servicesIcon.svg	t
60	Services/Government Agency Liason	res/servicesIcon.svg	t
61	Services/Business Services	res/servicesIcon.svg	t
62	Services/IT Services 	res/servicesIcon.svg	t
63	Services/Health & Beauty	res/servicesIcon.svg	t
64	Services/Massage & Chiropractor	res/servicesIcon.svg	t
65	Services/Laundry	res/servicesIcon.svg	t
66	Services/Home Maintenace & Repair	res/servicesIcon.svg	t
67	Services/Contractors	res/servicesIcon.svg	t
68	Services/Interior Design & Architect	res/servicesIcon.svg	t
69	Services/Sanitation & Waste Management	res/servicesIcon.svg	t
70	Services/Child & Elderly Care	res/servicesIcon.svg	t
71	Services/Home & Office Care	res/servicesIcon.svg	t
72	Services/Security	res/servicesIcon.svg	t
73	Services/Catering	res/servicesIcon.svg	t
74	Services/Logistics & Delivery	res/servicesIcon.svg	t
75	Services/Auto Services	res/servicesIcon.svg	t
76	Services/Entertainment & Recreation	res/servicesIcon.svg	t
77	Services/Event & Party Organizers	res/servicesIcon.svg	t
78	Services/Specialties	res/servicesIcon.svg	t
79	Services/Award Winners	res/servicesIcon.svg	t
80	Services/Others	res/servicesIcon.svg	t
81	Education/Personal Coach	res/educationIcon.svg	t
82	Education/Music	res/educationIcon.svg	t
83	Education/Language	res/educationIcon.svg	t
84	Education/Children & Teens	res/educationIcon.svg	t
85	Education/Sports & Coaching	res/educationIcon.svg	t
86	Education/Adult Education	res/educationIcon.svg	t
87	Education/Institutions & Academies	res/educationIcon.svg	t
88	Education/Specialty	res/educationIcon.svg	t
89	Education/Award Winners	res/educationIcon.svg	t
90	Education/Others	res/educationIcon.svg	t
91	Health/Personal Care/Cosmetics	res/healthIcon.svg	t
92	Health/Personal Care/Personal Care	res/healthIcon.svg	t
93	Health/Personal Care/Medicine & Remedies	res/healthIcon.svg	t
94	Health/Personal Care/Supplements	res/healthIcon.svg	t
95	Health/Personal Care/Natural & Holistic	res/healthIcon.svg	t
96	Health/Personal Care/Speicalties	res/healthIcon.svg	t
97	Health/Personal Care/Others	res/healthIcon.svg	t
98	Home & Garden/Furniture	res/homeIcon.svg	t
99	Home & Garden/Home Decore	res/homeIcon.svg	t
100	Home & Garden/Garden Supplies	res/homeIcon.svg	t
101	Home & Garden/Cleaning & Maintenance	res/homeIcon.svg	t
102	Home & Garden/Lighting	res/homeIcon.svg	t
103	Home & Garden/DIY	res/homeIcon.svg	t
104	Home & Garden/Kitchen	res/homeIcon.svg	t
105	Home & Garden/Bedroom	res/homeIcon.svg	t
106	Home & Garden/Living Room	res/homeIcon.svg	t
107	Home & Garden/Bathroom	res/homeIcon.svg	t
108	Home & Garden/His	res/homeIcon.svg	t
109	Home & Garden/Hers	res/homeIcon.svg	t
110	Home & Garden/Children & Teens	res/homeIcon.svg	t
111	Home & Garden/Toys & Games	res/homeIcon.svg	t
112	Home & Garden/Specialties	res/homeIcon.svg	t
113	Home & Garden/Others	res/homeIcon.svg	t
114	Agriculture & Farms/Farms & Farmers	res/farmIcon.svg	t
115	Agriculture & Farms/Fruits & Vegetables	res/farmIcon.svg	t
116	Agriculture & Farms/Natural & Non-Chemical	res/farmIcon.svg	t
117	Agriculture & Farms/Animal Products	res/farmIcon.svg	t
118	Agriculture & Farms/Plant Breeds & Seeds	res/farmIcon.svg	t
119	Agriculture & Farms/Animal Breeds	res/farmIcon.svg	t
120	Agriculture & Farms/Equipment & Supplies	res/farmIcon.svg	t
121	Agriculture & Farms/Herbal Medicine	res/farmIcon.svg	t
122	Agriculture & Farms/Flowers & Non-Edibles	res/farmIcon.svg	t
123	Agriculture & Farms/Specialties	res/farmIcon.svg	t
124	Agriculture & Farms/Award Winners	res/farmIcon.svg	t
125	Agriculture & Farms/Others	res/farmIcon.svg	t
126	Classified/Jobs	res/classifiedIcon.svg	t
127	Classified/Services	res/classifiedIcon.svg	t
128	Classified/Pets & Plants	res/classifiedIcon.svg	t
129	Classified/2nd Hand	res/classifiedIcon.svg	t
130	Classified/Free Stuff	res/classifiedIcon.svg	t
131	Classified/Wanted (Dead or Alive)	res/classifiedIcon.svg	t
132	Classified/Others	res/classifiedIcon.svg	t
133	Local Finds/Products (e.g. OTOP)	res/localIcon.svg	t
134	Local Finds/Local Markets	res/localIcon.svg	t
135	Local Finds/Local Events	res/localIcon.svg	t
136	Local Finds/Charity Activities	res/localIcon.svg	t
137	Local Finds/Flash Events	res/localIcon.svg	t
138	Local Finds/Others	res/localIcon.svg	t
139	Entertainment/Sports	res/entertainmentIcon.svg	t
140	Entertainment/Music	res/entertainmentIcon.svg	t
141	Entertainment/Performing Arts	res/entertainmentIcon.svg	t
142	Entertainment/Fine Arts	res/entertainmentIcon.svg	t
143	Entertainment/Cultural	res/entertainmentIcon.svg	t
144	Entertainment/Kids & Teens	res/entertainmentIcon.svg	t
145	Entertainment/Young & Wild	res/entertainmentIcon.svg	t
146	Entertainment/Family	res/entertainmentIcon.svg	t
147	Entertainment/Adult	res/entertainmentIcon.svg	t
148	Entertainment/Seniors & Classics	res/entertainmentIcon.svg	t
149	Entertainment/Night Life	res/entertainmentIcon.svg	t
150	Entertainment/Romatic	res/entertainmentIcon.svg	t
151	Entertainment/Specialties	res/entertainmentIcon.svg	t
152	Entertainment/Award Winners	res/entertainmentIcon.svg	t
153	Entertainment/Others	res/entertainmentIcon.svg	t
154	Travel & Hospitality/Travel Agencies	res/travelIcon.svg	t
155	Travel & Hospitality/Guide Services	res/travelIcon.svg	t
156	Travel & Hospitality/Travel Document	res/travelIcon.svg	t
157	Travel & Hospitality/Travel Products	res/travelIcon.svg	t
158	Travel & Hospitality/International Chains	res/travelIcon.svg	t
159	Travel & Hospitality/Local Chains	res/travelIcon.svg	t
160	Travel & Hospitality/Boutique Hotels	res/travelIcon.svg	t
161	Travel & Hospitality/Resorts & Spa	res/travelIcon.svg	t
162	Travel & Hospitality/Bed & Breakfast	res/travelIcon.svg	t
163	Travel & Hospitality/Home Stay & Hostel	res/travelIcon.svg	t
164	Travel & Hospitality/Eco-Tourism	res/travelIcon.svg	t
165	Travel & Hospitality/Health Tourism (Medical)	res/travelIcon.svg	t
166	Travel & Hospitality/Work & Stay	res/travelIcon.svg	t
167	Travel & Hospitality/Transportation	res/travelIcon.svg	t
168	Travel & Hospitality/Specialties	res/travelIcon.svg	t
169	Travel & Hospitality/Award Winners	res/travelIcon.svg	t
170	Travel & Hospitality/Others	res/travelIcon.svg	t
171	Pets/Dogs	res/petsIcon.svg	t
172	Pets/Cats	res/petsIcon.svg	t
173	Pets/Birds	res/petsIcon.svg	t
174	Pets/Fishes	res/petsIcon.svg	t
175	Pets/Reptiles	res/petsIcon.svg	t
176	Pets/Insects	res/petsIcon.svg	t
177	Pets/Specialties	res/petsIcon.svg	t
178	Pets/Award Winners	res/petsIcon.svg	t
179	Pets/Others	res/petsIcon.svg	t
\.



--
-- Data for Name: auth_group; Type: TABLE DATA; Schema: public; Owner: django
--

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



--
-- Data for Name: auth_group_permissions; Type: TABLE DATA; Schema: public; Owner: django
--

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



--
-- Data for Name: auth_permission; Type: TABLE DATA; Schema: public; Owner: django
--

COPY auth_permission (id, name, content_type_id, codename) FROM stdin;
1	Can add log entry	1	add_logentry
2	Can change log entry	1	change_logentry
3	Can delete log entry	1	delete_logentry
4	Can add permission	2	add_permission
5	Can change permission	2	change_permission
6	Can delete permission	2	delete_permission
7	Can add group	3	add_group
8	Can change group	3	change_group
9	Can delete group	3	delete_group
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 Folder	6	add_folder
17	Can change Folder	6	change_folder
18	Can delete Folder	6	delete_folder
19	Can use directory listing	6	can_use_directory_listing
20	Can add folder permission	7	add_folderpermission
21	Can change folder permission	7	change_folderpermission
22	Can delete folder permission	7	delete_folderpermission
23	Can add file	8	add_file
24	Can change file	8	change_file
25	Can delete file	8	delete_file
26	Can add clipboard	9	add_clipboard
27	Can change clipboard	9	change_clipboard
28	Can delete clipboard	9	delete_clipboard
29	Can add clipboard item	10	add_clipboarditem
30	Can change clipboard item	10	change_clipboarditem
31	Can delete clipboard item	10	delete_clipboarditem
32	Can add image	11	add_image
33	Can change image	11	change_image
34	Can delete image	11	delete_image
35	Can add thumbnail option	12	add_thumbnailoption
36	Can change thumbnail option	12	change_thumbnailoption
37	Can delete thumbnail option	12	delete_thumbnailoption
38	Can add source	13	add_source
39	Can change source	13	change_source
40	Can delete source	13	delete_source
41	Can add thumbnail	14	add_thumbnail
42	Can change thumbnail	14	change_thumbnail
43	Can delete thumbnail	14	delete_thumbnail
44	Can add thumbnail dimensions	15	add_thumbnaildimensions
45	Can change thumbnail dimensions	15	change_thumbnaildimensions
46	Can delete thumbnail dimensions	15	delete_thumbnaildimensions
47	Can add site	16	add_site
48	Can change site	16	change_site
49	Can delete site	16	delete_site
50	Can add email address	17	add_emailaddress
51	Can change email address	17	change_emailaddress
52	Can delete email address	17	delete_emailaddress
53	Can add email confirmation	18	add_emailconfirmation
54	Can change email confirmation	18	change_emailconfirmation
55	Can delete email confirmation	18	delete_emailconfirmation
56	Can add social application	19	add_socialapp
57	Can change social application	19	change_socialapp
58	Can delete social application	19	delete_socialapp
59	Can add social account	20	add_socialaccount
60	Can change social account	20	change_socialaccount
61	Can delete social account	20	delete_socialaccount
62	Can add social application token	21	add_socialtoken
63	Can change social application token	21	change_socialtoken
64	Can delete social application token	21	delete_socialtoken
65	Can add Token	22	add_token
66	Can change Token	22	change_token
67	Can delete Token	22	delete_token
68	Can add user social auth	23	add_usersocialauth
69	Can change user social auth	23	change_usersocialauth
70	Can delete user social auth	23	delete_usersocialauth
71	Can add nonce	24	add_nonce
72	Can change nonce	24	change_nonce
73	Can delete nonce	24	delete_nonce
74	Can add association	25	add_association
75	Can change association	25	change_association
76	Can delete association	25	delete_association
77	Can add code	26	add_code
78	Can change code	26	change_code
79	Can delete code	26	delete_code
80	Can add application	27	add_application
81	Can change application	27	change_application
82	Can delete application	27	delete_application
83	Can add grant	28	add_grant
84	Can change grant	28	change_grant
85	Can delete grant	28	delete_grant
86	Can add access token	29	add_accesstoken
87	Can change access token	29	change_accesstoken
88	Can delete access token	29	delete_accesstoken
89	Can add refresh token	30	add_refreshtoken
90	Can change refresh token	30	change_refreshtoken
91	Can delete refresh token	30	delete_refreshtoken
92	Can add user account	31	add_useraccount
93	Can change user account	31	change_useraccount
94	Can delete user account	31	delete_useraccount
95	Can add owner shop	32	add_ownershop
96	Can change owner shop	32	change_ownershop
97	Can delete owner shop	32	delete_ownershop
98	Can add seller	33	add_seller
99	Can change seller	33	change_seller
100	Can delete seller	33	delete_seller
101	Can add seller target	34	add_sellertarget
102	Can change seller target	34	change_sellertarget
103	Can delete seller target	34	delete_sellertarget
104	Can add buyer	35	add_buyer
105	Can change buyer	35	change_buyer
106	Can delete buyer	35	delete_buyer
110	Can add achievement	37	add_achievement
111	Can change achievement	37	change_achievement
112	Can delete achievement	37	delete_achievement
113	Can add client profile	38	add_clientprofile
114	Can change client profile	38	change_clientprofile
115	Can delete client profile	38	delete_clientprofile
116	Can add shopping list item	39	add_shoppinglistitem
117	Can change shopping list item	39	change_shoppinglistitem
118	Can delete shopping list item	39	delete_shoppinglistitem
119	Can add subcategory	40	add_subcategory
120	Can change subcategory	40	change_subcategory
121	Can delete subcategory	40	delete_subcategory
122	Can add category	41	add_category
123	Can change category	41	change_category
124	Can delete category	41	delete_category
131	Can add bill	44	add_bill
132	Can change bill	44	change_bill
133	Can delete bill	44	delete_bill
140	Can add promotion	47	add_promotion
141	Can change promotion	47	change_promotion
142	Can delete promotion	47	delete_promotion
143	Can add promotion image	48	add_promotionimage
144	Can change promotion image	48	change_promotionimage
145	Can delete promotion image	48	delete_promotionimage
146	Can add coupon	49	add_coupon
147	Can change coupon	49	change_coupon
148	Can delete coupon	49	delete_coupon
152	Can add cors model	51	add_corsmodel
153	Can change cors model	51	change_corsmodel
154	Can delete cors model	51	delete_corsmodel
155	Can add bookmarks promotion item	52	add_bookmarkspromotionitem
156	Can change bookmarks promotion item	52	change_bookmarkspromotionitem
157	Can delete bookmarks promotion item	52	delete_bookmarkspromotionitem
\.


--
-- Data for Name: billing_bill; Type: TABLE DATA; Schema: public; Owner: django
--

COPY billing_bill (id, payment_id, date, account_id) FROM stdin;
\.



--
-- Data for Name: django_admin_log; Type: TABLE DATA; Schema: public; Owner: django
--

COPY django_admin_log (id, action_time, object_id, object_repr, action_flag, change_message, content_type_id, user_id) FROM stdin;
\.



--
-- Data for Name: django_content_type; Type: TABLE DATA; Schema: public; Owner: django
--

COPY django_content_type (id, app_label, model) FROM stdin;
1	admin	logentry
2	auth	permission
3	auth	group
4	contenttypes	contenttype
5	sessions	session
6	filer	folder
7	filer	folderpermission
8	filer	file
9	filer	clipboard
10	filer	clipboarditem
11	filer	image
12	filer	thumbnailoption
13	easy_thumbnails	source
14	easy_thumbnails	thumbnail
15	easy_thumbnails	thumbnaildimensions
16	sites	site
17	account	emailaddress
18	account	emailconfirmation
19	socialaccount	socialapp
20	socialaccount	socialaccount
21	socialaccount	socialtoken
22	authtoken	token
23	default	usersocialauth
24	default	nonce
25	default	association
26	default	code
27	oauth2_provider	application
28	oauth2_provider	grant
29	oauth2_provider	accesstoken
30	oauth2_provider	refreshtoken
31	accounts	useraccount
32	accounts	ownershop
33	accounts	seller
34	accounts	sellertarget
35	accounts	buyer
37	accounts	achievement
38	accounts	clientprofile
39	accounts	shoppinglistitem
40	admon	subcategory
41	admon	category
44	billing	bill
47	shop	promotion
48	shop	promotionimage
49	shop	coupon
51	corsheaders	corsmodel
52	shop	bookmarkspromotionitem
\.



--
-- Data for Name: django_migrations; Type: TABLE DATA; Schema: public; Owner: django
--

COPY django_migrations (id, app, name, applied) FROM stdin;
1	admon	0001_initial	2016-07-14 16:31:32.938292-05
2	accounts	0001_initial	2016-07-14 16:31:33.121645-05
3	account	0001_initial	2016-07-14 16:31:33.182673-05
4	account	0002_email_max_length	2016-07-14 16:31:33.205056-05
5	shop	0001_initial	2016-07-14 16:31:33.417828-05
6	contenttypes	0001_initial	2016-07-14 16:31:33.43673-05
7	contenttypes	0002_remove_content_type_name	2016-07-14 16:31:33.453819-05
8	auth	0001_initial	2016-07-14 16:31:33.503509-05
9	auth	0002_alter_permission_name_max_length	2016-07-14 16:31:33.51819-05
10	auth	0003_alter_user_email_max_length	2016-07-14 16:31:33.527283-05
11	auth	0004_alter_user_username_opts	2016-07-14 16:31:33.537015-05
12	auth	0005_alter_user_last_login_null	2016-07-14 16:31:33.546993-05
13	auth	0006_require_contenttypes_0002	2016-07-14 16:31:33.549451-05
14	auth	0007_alter_validators_add_error_messages	2016-07-14 16:31:33.559019-05
15	accounts	0002_auto_20160714_2131	2016-07-14 16:31:33.757815-05
16	admin	0001_initial	2016-07-14 16:31:33.801045-05
17	admin	0002_logentry_remove_auto_add	2016-07-14 16:31:33.834067-05
18	authtoken	0001_initial	2016-07-14 16:31:33.873151-05
19	authtoken	0002_auto_20160226_1747	2016-07-14 16:31:33.993911-05
20	billing	0001_initial	2016-07-14 16:31:34.031715-05
21	default	0001_initial	2016-07-14 16:31:34.158802-05
22	default	0002_add_related_name	2016-07-14 16:31:34.207226-05
23	default	0003_alter_email_max_length	2016-07-14 16:31:34.215367-05
24	default	0004_auto_20160423_0400	2016-07-14 16:31:34.254656-05
25	easy_thumbnails	0001_initial	2016-07-14 16:31:34.32027-05
26	easy_thumbnails	0002_thumbnaildimensions	2016-07-14 16:31:34.343585-05
27	filer	0001_initial	2016-07-14 16:31:34.895822-05
28	filer	0002_auto_20150606_2003	2016-07-14 16:31:34.974765-05
29	filer	0003_thumbnailoption	2016-07-14 16:31:34.992776-05
30	filer	0004_auto_20160328_1434	2016-07-14 16:31:35.036356-05
31	filer	0005_auto_20160714_2131	2016-07-14 16:31:35.07361-05
32	oauth2_provider	0001_initial	2016-07-14 16:31:35.30283-05
33	oauth2_provider	0002_08_updates	2016-07-14 16:31:35.528029-05
34	sessions	0001_initial	2016-07-14 16:31:35.556406-05
35	sites	0001_initial	2016-07-14 16:31:35.570551-05
36	sites	0002_alter_domain_unique	2016-07-14 16:31:35.591977-05
37	socialaccount	0001_initial	2016-07-14 16:31:35.890913-05
38	socialaccount	0002_token_max_lengths	2016-07-14 16:31:36.088496-05
39	socialaccount	0003_extra_data_default_dict	2016-07-14 16:31:36.13201-05
40	accounts	0003_auto_20160722_1554	2016-07-22 15:54:08.809446-05
41	shop	0002_auto_20160722_1554	2016-07-22 15:54:09.238227-05
42	admon	0002_auto_20160722_1554	2016-07-22 15:54:09.252209-05
43	shop	0003_auto_20160729_1431	2016-07-29 14:31:49.587253-05
44	accounts	0004_auto_20160729_1701	2016-07-29 17:01:11.013854-05
45	shop	0004_auto_20160729_1701	2016-07-29 17:01:11.814583-05
46	shop	0005_auto_20160801_1513	2016-08-01 15:13:00.805068-05
\.


--
-- Data for Name: django_site; Type: TABLE DATA; Schema: public; Owner: django
--

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



--
-- Data for Name: easy_thumbnails_source; Type: TABLE DATA; Schema: public; Owner: django
--

COPY easy_thumbnails_source (id, storage_hash, name, modified) FROM stdin;
\.



--
-- Data for Name: easy_thumbnails_thumbnail; Type: TABLE DATA; Schema: public; Owner: django
--

COPY easy_thumbnails_thumbnail (id, storage_hash, name, modified, source_id) FROM stdin;
\.



--
-- Data for Name: easy_thumbnails_thumbnaildimensions; Type: TABLE DATA; Schema: public; Owner: django
--

COPY easy_thumbnails_thumbnaildimensions (id, thumbnail_id, width, height) FROM stdin;
\.



--
-- Data for Name: filer_clipboard; Type: TABLE DATA; Schema: public; Owner: django
--

COPY filer_clipboard (id, user_id) FROM stdin;
\.



--
-- Data for Name: filer_clipboarditem; Type: TABLE DATA; Schema: public; Owner: django
--

COPY filer_clipboarditem (id, clipboard_id, file_id) FROM stdin;
\.



--
-- Data for Name: filer_file; Type: TABLE DATA; Schema: public; Owner: django
--

COPY filer_file (id, file, _file_size, sha1, has_all_mandatory_data, original_filename, name, description, uploaded_at, modified_at, is_public, folder_id, owner_id, polymorphic_ctype_id) FROM stdin;
\.



--
-- Data for Name: filer_folder; Type: TABLE DATA; Schema: public; Owner: django
--

COPY filer_folder (id, name, uploaded_at, created_at, modified_at, lft, rght, tree_id, level, owner_id, parent_id) FROM stdin;
\.



--
-- Data for Name: filer_folderpermission; Type: TABLE DATA; Schema: public; Owner: django
--

COPY filer_folderpermission (id, type, everybody, can_edit, can_read, can_add_children, folder_id, group_id, user_id) FROM stdin;
\.



--
-- Data for Name: filer_image; Type: TABLE DATA; Schema: public; Owner: django
--

COPY filer_image (file_ptr_id, _height, _width, date_taken, default_alt_text, default_caption, author, must_always_publish_author_credit, must_always_publish_copyright, subject_location) FROM stdin;
\.


--
-- Data for Name: filer_thumbnailoption; Type: TABLE DATA; Schema: public; Owner: django
--

COPY filer_thumbnailoption (id, name, width, height, crop, upscale) FROM stdin;
\.



--
-- Data for Name: oauth2_provider_grant; Type: TABLE DATA; Schema: public; Owner: django
--

COPY oauth2_provider_grant (id, code, expires, redirect_uri, scope, application_id, user_id) FROM stdin;
\.



--
-- Data for Name: shop_bookmarkspromotionitem; Type: TABLE DATA; Schema: public; Owner: django
--

COPY shop_bookmarkspromotionitem (id, buyer_id, promotion_id) FROM stdin;
6	1	40
17	18	94
18	18	53
19	18	82
20	4	67
23	6	94
24	1	94
26	4	94
32	1	76
33	1	108
39	15	112
\.



--
-- Data for Name: shop_coupon; Type: TABLE DATA; Schema: public; Owner: django
--

COPY shop_coupon (id, status, buyer_id, promotion_id) FROM stdin;
2	1	1	16
3	0	1	16
5	1	1	19
9	0	11	36
10	0	11	36
11	0	1	40
14	0	15	67
15	0	15	67
16	0	15	59
18	0	15	7
19	0	15	17
20	0	15	63
23	0	1	68
24	0	1	70
25	0	1	71
26	0	1	72
27	1	1	94
17	1	15	7
29	1	18	82
30	1	4	94
31	1	5	94
28	1	18	53
32	0	6	94
33	0	4	100
1	1	2	7
34	0	1	12
35	1	15	112
36	1	15	113
4	1	1	7
37	0	15	69
38	0	1	100
39	0	1	76
40	0	1	94
41	0	1	74
42	0	1	78
43	0	15	112
\.



--
-- Data for Name: shop_promotion; Type: TABLE DATA; Schema: public; Owner: django
--

COPY shop_promotion (id, name, description, regular_price, offered_price, discount_rate, type, status, quantity_coupons, seller_id, available_coupons) FROM stdin;
113	Ipad	Awesome	20.00	10.00	0	1	1	0	20	\N
14	Limited offer	Servers discounted	370000.00	200000.00	0	2	2	15	2	0
51	Little Japanese girl	3.5 yr old polite little japanese girl 4sale	100.00	95.00	0	3	1	0	5	0
7	Test 1	Probando con oacero	30000.00	20000.00	0	1	1	0	3	0
28	Test 3	Descripción  de test 3	40000.00	35000.00	0	3	0	0	3	0
12	new promotion 3	description 3	10000.00	8000.00	0	3	1	0	3	0
36	Gatos gratis	Regalamos gatos	300000.00	0.00	0	1	1	0	7	0
19	New test pro	Solo para i	5000.00	4000.00	0	2	1	14	2	0
20	new promotion	description	0.00	0.00	0	1	0	0	2	0
38	new promotion	description	0.00	0.00	0	1	0	0	10	0
39	new promotion	description	0.00	0.00	0	1	0	0	10	0
52	new promo  target selection	shld  hv cat subcat auto	28.00	25.00	0	1	0	0	14	0
9	Developmet	1 hr development for every 10 hrs reached	100000.00	100000.00	0	3	1	0	2	0
41	Some Mushrooms	Will Make you Grow	100.00	99.00	0	1	1	0	1	0
25	new promotion	description	50000.00	35000.00	0	2	1	8	8	0
10	Test 2	Prueba 2	25000.00	20000.00	0	2	2	10	3	0
13	Service Discount	It service discounted	135000.00	23000.00	0	2	1	0	2	0
100	Headphones	Some usb headphones	1.00	0.50	0	2	1	5	15	3
69	test promotion	blablabla	0.00	0.00	0	2	1	10	9	9
21	4.5 yr old boy	4.5 year old boy Thai-american -Dutch for sale. toilet trained loves all animals, easy to feed  easily entertained.	100.00	99.00	0	1	1	0	5	0
16	Limited it service	Food for it developers	15000.00	10000.00	0	2	1	38	2	0
40	Your Promo	Everything you need for traveling	100.00	99.00	0	1	1	0	11	0
34	Perros de raza	Perros golden en descuento	1300000.00	800000.00	0	2	1	6	7	0
22	new promotion	description	0.00	0.00	0	2	1	5	5	0
42	new promotion	description	0.02	0.01	0	1	1	0	1	0
17	new promotion	description	1.18	0.78	0	1	1	0	1	0
43	new promotion	description	10.00	9.00	0	1	1	0	1	0
65	new promotion	description	0.00	0.00	0	1	0	0	7	0
77	hats 9	yes	0.00	0.00	0	1	1	0	15	0
59	Photoless promo	Photoless promo	12.00	11.00	0	1	1	0	1	0
119	new promotion	description	0.00	0.00	0	1	0	0	1	\N
61	new promotion	description	0.00	0.00	0	1	0	0	12	0
115	new promotion	Hello \n\nthis is  a product description	123.12	1231.23	0	2	0	123123	1	0
6	Hello	World	0.00	0.00	0	1	2	0	1	0
58	new promotion	description	434683.00	267576.00	0	3	2	0	7	0
67	Limited hats	Hats are limited	0.00	0.00	0	2	1	40	1	38
123	YET ANOTHER PROMOTION	SDF	0.00	0.00	0	1	0	0	1	\N
49	purple talking worm	pet worm for sale, purple color can speak english and japanese	100.00	98.00	0	2	0	50	14	0
56	Nice mug	Super awesome mug	14.99	5.99	0	1	1	0	1	0
125	yes, yes, yes.asdasd	oinsodinf SasASasasdskldjlkjlkj\n\n\nalksjdlak	0.00	0.00	0	1	0	0	1	\N
75	hats 6	awesome hats	0.00	0.00	0	1	1	0	15	0
70	Hats 1	description	0.00	0.00	0	1	1	0	15	0
73	hats 4	description	0.00	0.00	0	1	1	0	15	0
68	promo test	description	0.00	0.00	0	1	1	0	15	0
82	Free range eggs	Case of 30size 1 free range stormtrooper eggs fresh from the farm!!	0.00	0.00	0	1	1	0	5	0
63	Hats	Hats are awesome	0.00	0.00	0	1	1	0	1	0
94	Super hats	This are the super hats	12.23	1.50	0	2	1	10	15	5
106	More headphones	Headphones are awesome	33.33	22.22	0	1	0	0	15	\N
95	Hatter mastr	The hatter master	55.55	44.44	0	1	1	0	15	\N
71	Hats 2	description	0.00	0.00	0	1	1	0	15	0
78	hats 10	description	0.00	0.00	0	1	1	0	15	0
76	hats 7	description	0.00	0.00	0	1	1	0	15	0
74	hats 5	description	0.00	0.00	0	1	1	0	15	0
72	hats 3	description	0.00	0.00	0	1	1	0	15	0
127	new promotion	description	0.00	0.00	0	1	0	0	1	\N
81	Darkness	Darkness for sale	0.00	0.00	0	2	1	10	5	0
80	new promotion gus	description	0.00	0.00	0	1	1	0	1	0
97	Test delete promo	This is to test description mmmmmmmmmmmmmmmmmmmmmHhhhhhhhhhh hhhhhhhhhhhh hhhhhhhhhhh hhhhhhhhhhhhhhhhhhhhhhhh hhhhhhhhhhhhhhhhhhhhhh	1000.00	150.00	0	2	1	100	5	100
50	talking worm	purple talking worm	100.00	98.00	0	2	1	1	14	0
93	new promotion	description	0.00	0.00	0	1	1	0	1	\N
99	Personal S.A.T/ P.S.A.T & Math Tutor	First 3 customers get 1 hour FREE with purchase of 1 hour or more.	200.00	0.00	0	3	2	0	6	\N
53	new promotion	description	10.00	9.00	0	1	2	0	1	0
107	new promotion	description	123.23	12.33	0	3	1	0	9	\N
108	A Banner Promotion	A super Banner promotion that does all tonnes of things	123.12	122.32	0	3	1	0	9	\N
109	new promotion test #53/3	description	50.00	150.00	0	2	0	100	14	100
162	new promotion	description	0.00	0.00	0	1	0	0	1	\N
163	new promotion	description	0.00	0.00	0	1	0	0	15	\N
114	new promotion	description	0.00	0.00	0	1	0	0	1	\N
116	new promotion	description	0.00	0.00	0	1	0	0	1	\N
118	new promotion	description	0.00	0.00	0	1	0	0	1	\N
120	new promotion	description	0.00	0.00	0	2	0	1500	19	1500
122	new promotion	description	0.00	0.00	0	1	0	0	1	\N
124	new promotion	description	0.00	0.00	0	1	0	0	1	\N
126	new promotion	description	0.00	0.00	0	1	0	0	1	\N
128	new promotion	description	0.00	0.00	0	1	0	0	1	\N
129	new promotion	description	0.00	0.00	0	1	0	0	1	\N
130	new promotion	description	0.00	0.00	0	1	0	0	1	\N
131	new promotion	description	0.00	0.00	0	1	0	0	1	\N
132	new promotion	description	0.00	0.00	0	1	0	0	1	\N
133	new promotion	description	0.00	0.00	0	1	0	0	1	\N
134	new promotion	description	0.00	0.00	0	1	0	0	1	\N
135	new promotion	description	0.00	0.00	0	1	0	0	1	\N
136	new promotion	description	0.00	0.00	0	1	0	0	1	\N
137	new promotion	description	0.00	0.00	0	1	0	0	1	\N
138	new promotion	description	0.00	0.00	0	1	0	0	1	\N
111	new promotion 1007	description	0.00	0.00	0	2	0	1	3	0
139	new promotion	description	0.00	0.00	0	1	0	0	1	\N
140	new promotion	description	0.00	0.00	0	1	0	0	1	\N
141	new promotion	description	0.00	0.00	0	1	0	0	1	\N
142	new promotion	description	0.00	0.00	0	1	0	0	1	\N
143	new promotion	description	0.00	0.00	0	1	0	0	1	\N
144	new promotion	description	0.00	0.00	0	1	0	0	1	\N
145	new promotion	description	0.00	0.00	0	1	0	0	1	\N
146	new promotion	description	0.00	0.00	0	1	0	0	1	\N
147	new promotion	description	0.00	0.00	0	1	0	0	1	\N
148	new promotion	description	0.00	0.00	0	1	0	0	1	\N
149	new promotion	description	0.00	0.00	0	1	0	0	1	\N
150	new promotion	description	0.00	0.00	0	1	0	0	1	\N
151	new promotion	description	0.00	0.00	0	1	0	0	1	\N
152	new promotion	description	0.00	0.00	0	1	0	0	1	\N
153	new promotion	description	0.00	0.00	0	1	0	0	1	\N
154	new promotion	description	0.00	0.00	0	1	0	0	1	\N
155	new promotion	description	0.00	0.00	0	1	0	0	1	\N
156	new promotion	description	0.00	0.00	0	1	0	0	1	\N
117	new promotion	description	0.00	0.00	0	1	0	0	1	\N
157	new promotion	description	0.00	0.00	0	1	0	0	1	\N
173	new promotion 1234	description	0.00	0.00	0	1	0	0	5	\N
175	new promotion test back2	description test back2	0.00	0.00	0	1	0	0	5	\N
176	new promotion	description	0.00	0.00	0	1	0	0	1	\N
112	Tech test	This is tech	12.00	10.00	0	2	1	15	1	13
158	new promotion	description	0.00	0.00	0	1	0	0	1	\N
159	new promotion	description	0.00	0.00	0	1	0	0	1	\N
160	new promotion	description	0.00	0.00	0	1	0	0	1	\N
161	new promotion	description	0.00	0.00	0	1	0	0	1	\N
121	new promotion	2qewrweroiwjerowiejroij\noisjdoifj\noijsdfoij\n\n\nsoidoijs	0.00	0.00	0	1	0	0	1	\N
174	new promotion test back	description chaflnged	0.00	0.00	0	1	0	0	5	\N
170	Test 58	description	125.50	105.00	0	3	0	0	5	\N
171	new promotion yyy	description	0.00	0.00	0	1	0	0	5	\N
\.



--
-- Data for Name: shop_promotion_target; Type: TABLE DATA; Schema: public; Owner: django
--

COPY shop_promotion_target (id, promotion_id, subcategory_id) FROM stdin;
403	173	9
404	173	10
405	173	11
124	63	1
125	63	2
126	63	3
127	63	4
10	6	37
11	6	91
12	7	1
13	7	6
14	7	9
15	7	11
16	7	15
129	65	118
21	9	62
22	10	1
23	10	6
132	67	1
133	67	2
26	10	15
134	67	3
28	12	59
135	67	4
136	67	5
137	67	6
32	13	62
33	12	1
34	14	149
138	67	7
139	68	100
140	68	1
141	68	2
39	16	62
40	17	6
142	68	3
143	68	4
144	68	5
145	68	6
45	19	62
46	20	79
146	68	7
147	69	12
148	70	3
50	21	177
51	22	126
149	70	1
150	70	2
151	70	4
152	70	5
57	25	21
153	70	6
154	70	7
60	28	115
155	71	178
156	71	1
157	71	2
158	71	3
159	71	4
160	71	5
161	71	6
162	71	7
72	34	171
163	72	33
164	72	1
75	36	172
165	72	2
77	38	132
78	39	152
79	40	81
80	40	126
81	40	154
166	72	3
83	41	55
84	42	25
85	43	163
167	72	4
168	72	5
169	72	6
170	72	7
171	73	73
172	73	1
92	49	177
173	73	2
94	49	46
95	50	177
174	73	3
97	51	129
98	51	128
99	51	112
100	51	110
101	52	177
102	53	22
103	53	56
175	73	4
176	73	5
177	73	6
107	56	25
108	56	104
178	73	7
110	58	158
111	59	22
112	59	1
179	74	176
114	61	7
180	74	1
181	74	2
182	74	3
183	74	4
184	74	5
185	74	6
186	74	7
187	75	41
188	75	1
189	75	2
190	75	3
191	75	4
192	75	5
193	75	6
194	75	7
195	76	107
196	76	1
197	76	2
198	76	3
199	76	4
200	76	5
201	76	6
202	76	7
203	77	113
204	77	1
205	77	2
206	77	3
207	77	4
208	77	5
209	77	6
210	77	7
211	78	31
212	78	1
213	78	2
214	78	3
215	78	4
216	78	5
217	78	6
218	78	7
220	80	167
222	81	129
223	81	172
225	82	117
226	82	114
227	93	4
228	94	50
229	94	1
230	94	2
231	94	3
232	94	4
233	94	8
234	94	5
235	94	6
236	94	7
238	95	1
239	95	3
240	95	2
241	95	4
242	95	6
243	95	5
244	95	7
245	49	178
255	97	171
256	99	126
257	99	81
258	100	15
259	100	9
260	100	10
261	100	11
262	100	12
263	100	13
264	100	14
265	100	16
266	100	17
267	100	18
268	100	19
269	100	20
270	100	21
406	173	12
407	173	13
408	173	14
409	173	15
410	173	16
411	173	17
277	107	1
278	107	2
279	107	3
280	107	5
281	107	4
282	108	1
283	108	3
284	108	2
285	108	4
412	173	18
413	173	19
288	109	3
414	173	20
415	173	21
416	174	1
417	174	35
418	174	3
419	174	5
295	109	7
296	109	4
297	112	9
298	112	10
299	112	11
300	112	12
301	112	13
302	112	14
303	112	15
304	112	16
305	112	17
306	112	18
307	112	19
308	112	20
309	112	21
310	113	9
311	113	10
312	113	11
313	113	12
314	113	13
315	113	14
316	113	15
317	113	16
318	113	17
319	120	11
320	120	14
321	120	19
322	120	174
323	120	176
324	121	94
325	106	26
420	174	10
421	174	11
422	174	45
423	174	14
424	174	47
425	174	13
426	174	50
427	174	55
428	174	56
429	174	26
430	174	27
431	175	3
432	175	4
433	175	5
434	175	6
435	175	14
436	175	59
437	175	62
438	175	63
439	175	64
440	175	84
441	175	85
378	170	9
379	170	10
380	170	11
381	170	12
382	170	13
383	170	14
384	170	15
385	170	16
386	170	17
387	170	18
388	170	19
389	170	20
390	170	21
391	171	1
392	171	6
393	171	9
394	171	11
395	171	15
\.



--
-- Data for Name: shop_promotionimage; Type: TABLE DATA; Schema: public; Owner: django
--

COPY shop_promotionimage (id, name, image, promotion_id) FROM stdin;
1	IMG-20160718-WA0004.jpg	promotion_image/16/07/18/IMG-20160718-WA0004.jpg	6
2	Screenshot_2016-07-18-19-27-58.png	promotion_image/16/07/19/Screenshot_2016-07-18-19-27-58.png	7
3	image.jpeg	promotion_image/16/07/19/image.jpeg	9
4	Screenshot_2016-07-17-20-45-38.png	promotion_image/16/07/19/Screenshot_2016-07-17-20-45-38.png	10
5	IMG-20160717-WA0000.jpg	promotion_image/16/07/19/IMG-20160717-WA0000.jpg	12
6	image.jpeg	promotion_image/16/07/19/image_rMvdPGt.jpeg	13
7	image.jpeg	promotion_image/16/07/19/image_s9olIme.jpeg	13
8	image.jpeg	promotion_image/16/07/19/image_8b5kEUh.jpeg	14
9	image.jpeg	promotion_image/16/07/19/image_5OWcjyZ.jpeg	14
11	image.jpeg	promotion_image/16/07/19/image_ERMKw9O.jpeg	16
12	image.jpeg	promotion_image/16/07/19/image_QH2YT2l.jpeg	16
13	image.jpg	promotion_image/16/07/19/image.jpg	19
14	image%3A108981	promotion_image/16/07/21/image3A108981	25
15	IMG-20160720-WA0002.jpg	promotion_image/16/07/21/IMG-20160720-WA0002.jpg	28
19	image.jpg	promotion_image/16/07/21/image.jpg	34
20	image.jpg	promotion_image/16/07/21/image_e98yh03.jpg	36
21	image%3A149905	promotion_image/16/07/21/image3A149905	39
22	IMG-20160721-WA0000.jpg	promotion_image/16/07/21/IMG-20160721-WA0000.jpg	40
24	conejos de pascua.jpg	promotion_image/16/07/21/conejos_de_pascua.jpg	17
25	chapiñon_nintendo 8080.jpg	promotion_image/16/07/21/chapinon_nintendo_8080.jpg	41
26	20160720_164940.jpg	promotion_image/16/07/21/20160720_164940.jpg	21
27	IMG-20160722-WA0003.jpg	promotion_image/16/07/21/IMG-20160722-WA0003.jpg	22
28	IMG-20160721-WA0002.jpg	promotion_image/16/07/21/IMG-20160721-WA0002.jpg	51
29	IMG-20160721-WA0001.jpg	promotion_image/16/07/21/IMG-20160721-WA0001.jpg	51
30	tech.jpg	promotion_image/16/07/22/tech.jpg	53
31	chapiñon_nintendo 8080.jpg	promotion_image/16/07/22/chapinon_nintendo_8080.jpg	42
32	conejos de pascua.jpg	promotion_image/16/07/22/conejos_de_pascua.jpg	42
33	tech.jpg	promotion_image/16/07/22/tech_ncAiF1l.jpg	43
34	IMG-20160721-WA0000.jpg	promotion_image/16/07/22/IMG-20160721-WA0000.jpg	43
35	pets.jpg	promotion_image/16/07/22/pets.jpg	43
38	a name	promotion_image/16/07/27/nombre	56
39	a name	promotion_image/16/07/28/nombre	58
40	a name	promotion_image/16/07/28/nombre_uNaw5ed	63
41	a name	promotion_image/16/07/29/nombre	81
42	a name	promotion_image/16/07/29/nombre_ss5hfWf	81
43	a name	promotion_image/16/07/29/nombre_njLCC44	82
44	a name	promotion_image/16/07/30/nombre	97
45	a name	promotion_image/16/07/30/nombre_Ca7AXAW	97
46	a name	promotion_image/16/07/30/nombre_tCvWDnv	97
47	a name	promotion_image/16/07/31/nombre	100
48	a name	promotion_image/16/07/31/nombre_RYxybpD	100
49	a name	promotion_image/16/08/02/nombre	109
50	a name	promotion_image/16/08/02/nombre_h30Rqzt	109
51	a name	promotion_image/16/08/02/nombre_jV9HlMU	109
52	a name	promotion_image/16/08/02/nombre_vdLzOoC	109
53	a name	promotion_image/16/08/02/nombre_2W6Lugt	109
54	a name	promotion_image/16/08/02/nombre_Ocwyx5d	109
55	a name	promotion_image/16/08/02/nombre_P5jwf6W	109
56	a name	promotion_image/16/08/02/nombre_hKyMBF9	112
57	a name	promotion_image/16/08/02/nombre_DQA21aD	112
58	a name	promotion_image/16/08/02/nombre_93IqD9B	113
59	a name	promotion_image/16/08/02/nombre_I6soMKB	115
62	a name	promotion_image/16/08/02/nombre_6ieel8i	115
63	a name	promotion_image/16/08/03/nombre	106
\.



--
-- Data for Name: social_auth_code; Type: TABLE DATA; Schema: public; Owner: django
--

COPY social_auth_code (id, email, code, verified) FROM stdin;
\.



--
-- Data for Name: social_auth_usersocialauth; Type: TABLE DATA; Schema: public; Owner: django
--

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



--
-- Data for Name: socialaccount_socialaccount; Type: TABLE DATA; Schema: public; Owner: django
--

COPY socialaccount_socialaccount (id, provider, uid, last_login, date_joined, extra_data, user_id) FROM stdin;
\.



--
-- Data for Name: socialaccount_socialapp_sites; Type: TABLE DATA; Schema: public; Owner: django
--

COPY socialaccount_socialapp_sites (id, socialapp_id, site_id) FROM stdin;
\.



--
-- Name: account_emailaddress_email_key; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY account_emailaddress
    ADD CONSTRAINT account_emailaddress_email_key UNIQUE (email);


--
-- Name: account_emailaddress_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY account_emailaddress
    ADD CONSTRAINT account_emailaddress_pkey PRIMARY KEY (id);


--
-- Name: accounts_achievement_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY accounts_achievement
    ADD CONSTRAINT accounts_achievement_pkey PRIMARY KEY (id);


--
-- Name: accounts_buyer_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY accounts_buyer
    ADD CONSTRAINT accounts_buyer_pkey PRIMARY KEY (id);


--
-- Name: accounts_buyer_user_account_id_key; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY accounts_buyer
    ADD CONSTRAINT accounts_buyer_user_account_id_key UNIQUE (user_account_id);


--
-- Name: accounts_clientprofile_buyer_id_key; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY accounts_clientprofile
    ADD CONSTRAINT accounts_clientprofile_buyer_id_key UNIQUE (buyer_id);


--
-- Name: accounts_clientprofile_interests_clientprofile_id_255822e6_uniq; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY accounts_clientprofile_interests
    ADD CONSTRAINT accounts_clientprofile_interests_clientprofile_id_255822e6_uniq UNIQUE (clientprofile_id, subcategory_id);


--
-- Name: accounts_clientprofile_interests_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY accounts_clientprofile_interests
    ADD CONSTRAINT accounts_clientprofile_interests_pkey PRIMARY KEY (id);


--
-- Name: accounts_clientprofile_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY accounts_clientprofile
    ADD CONSTRAINT accounts_clientprofile_pkey PRIMARY KEY (id);


--
-- Name: accounts_ownershop_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY accounts_ownershop
    ADD CONSTRAINT accounts_ownershop_pkey PRIMARY KEY (id);


--
-- Name: accounts_ownershop_user_account_id_key; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY accounts_ownershop
    ADD CONSTRAINT accounts_ownershop_user_account_id_key UNIQUE (user_account_id);


--
-- Name: accounts_seller_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY accounts_seller
    ADD CONSTRAINT accounts_seller_pkey PRIMARY KEY (id);


--
-- Name: accounts_seller_user_account_id_key; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY accounts_seller
    ADD CONSTRAINT accounts_seller_user_account_id_key UNIQUE (user_account_id);


--
-- Name: accounts_sellertarget_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY accounts_sellertarget
    ADD CONSTRAINT accounts_sellertarget_pkey PRIMARY KEY (id);


--
-- Name: accounts_sellertarget_seller_id_key; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY accounts_sellertarget
    ADD CONSTRAINT accounts_sellertarget_seller_id_key UNIQUE (seller_id);


--
-- Name: accounts_sellertarget_target_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY accounts_sellertarget_target
    ADD CONSTRAINT accounts_sellertarget_target_pkey PRIMARY KEY (id);


--
-- Name: accounts_sellertarget_target_sellertarget_id_00c3c3a1_uniq; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY accounts_sellertarget_target
    ADD CONSTRAINT accounts_sellertarget_target_sellertarget_id_00c3c3a1_uniq UNIQUE (sellertarget_id, subcategory_id);


--
-- Name: accounts_shoppinglistitem_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY accounts_shoppinglistitem
    ADD CONSTRAINT accounts_shoppinglistitem_pkey PRIMARY KEY (id);


--
-- Name: accounts_useraccount_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY accounts_useraccount_groups
    ADD CONSTRAINT accounts_useraccount_groups_pkey PRIMARY KEY (id);


--
-- Name: accounts_useraccount_groups_useraccount_id_9e1772b3_uniq; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY accounts_useraccount_groups
    ADD CONSTRAINT accounts_useraccount_groups_useraccount_id_9e1772b3_uniq UNIQUE (useraccount_id, group_id);


--
-- Name: accounts_useraccount_user_permissi_useraccount_id_54014a73_uniq; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY accounts_useraccount_user_permissions
    ADD CONSTRAINT accounts_useraccount_user_permissi_useraccount_id_54014a73_uniq UNIQUE (useraccount_id, permission_id);


--
-- Name: accounts_useraccount_user_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY accounts_useraccount_user_permissions
    ADD CONSTRAINT accounts_useraccount_user_permissions_pkey PRIMARY KEY (id);


--
-- Name: admon_category_name_key; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY admon_category
    ADD CONSTRAINT admon_category_name_key UNIQUE (name);


--
-- Name: admon_category_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY admon_category
    ADD CONSTRAINT admon_category_pkey PRIMARY KEY (id);


--
-- Name: admon_category_subcategories_category_id_0cfcbd91_uniq; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY admon_category_subcategories
    ADD CONSTRAINT admon_category_subcategories_category_id_0cfcbd91_uniq UNIQUE (category_id, subcategory_id);


--
-- Name: admon_category_subcategories_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY admon_category_subcategories
    ADD CONSTRAINT admon_category_subcategories_pkey PRIMARY KEY (id);


--
-- Name: admon_subcategory_name_key; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY admon_subcategory
    ADD CONSTRAINT admon_subcategory_name_key UNIQUE (name);


--
-- Name: admon_subcategory_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY admon_subcategory
    ADD CONSTRAINT admon_subcategory_pkey PRIMARY KEY (id);


--
-- Name: auth_group_name_key; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

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


--
-- Name: auth_group_permissions_group_id_0cd325b0_uniq; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

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


--
-- Name: auth_group_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

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


--
-- Name: auth_group_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

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


--
-- Name: auth_permission_content_type_id_01ab375a_uniq; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

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


--
-- Name: auth_permission_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

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


--
-- Name: billing_bill_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY billing_bill
    ADD CONSTRAINT billing_bill_pkey PRIMARY KEY (id);


--
-- Name: django_admin_log_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

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


--
-- Name: django_content_type_app_label_76bd3d3b_uniq; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

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


--
-- Name: django_content_type_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

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


--
-- Name: django_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY django_migrations
    ADD CONSTRAINT django_migrations_pkey PRIMARY KEY (id);


--
-- Name: django_site_domain_a2e37b91_uniq; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY django_site
    ADD CONSTRAINT django_site_domain_a2e37b91_uniq UNIQUE (domain);


--
-- Name: django_site_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

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


--
-- Name: easy_thumbnails_source_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY easy_thumbnails_source
    ADD CONSTRAINT easy_thumbnails_source_pkey PRIMARY KEY (id);


--
-- Name: easy_thumbnails_source_storage_hash_481ce32d_uniq; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY easy_thumbnails_source
    ADD CONSTRAINT easy_thumbnails_source_storage_hash_481ce32d_uniq UNIQUE (storage_hash, name);


--
-- Name: easy_thumbnails_thumbnail_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY easy_thumbnails_thumbnail
    ADD CONSTRAINT easy_thumbnails_thumbnail_pkey PRIMARY KEY (id);


--
-- Name: easy_thumbnails_thumbnail_storage_hash_fb375270_uniq; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY easy_thumbnails_thumbnail
    ADD CONSTRAINT easy_thumbnails_thumbnail_storage_hash_fb375270_uniq UNIQUE (storage_hash, name, source_id);


--
-- Name: easy_thumbnails_thumbnaildimensions_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY easy_thumbnails_thumbnaildimensions
    ADD CONSTRAINT easy_thumbnails_thumbnaildimensions_pkey PRIMARY KEY (id);


--
-- Name: easy_thumbnails_thumbnaildimensions_thumbnail_id_key; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY easy_thumbnails_thumbnaildimensions
    ADD CONSTRAINT easy_thumbnails_thumbnaildimensions_thumbnail_id_key UNIQUE (thumbnail_id);


--
-- Name: filer_clipboard_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY filer_clipboard
    ADD CONSTRAINT filer_clipboard_pkey PRIMARY KEY (id);


--
-- Name: filer_clipboarditem_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY filer_clipboarditem
    ADD CONSTRAINT filer_clipboarditem_pkey PRIMARY KEY (id);


--
-- Name: filer_file_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY filer_file
    ADD CONSTRAINT filer_file_pkey PRIMARY KEY (id);


--
-- Name: filer_folder_parent_id_bc773258_uniq; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY filer_folder
    ADD CONSTRAINT filer_folder_parent_id_bc773258_uniq UNIQUE (parent_id, name);


--
-- Name: filer_folder_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY filer_folder
    ADD CONSTRAINT filer_folder_pkey PRIMARY KEY (id);


--
-- Name: filer_folderpermission_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY filer_folderpermission
    ADD CONSTRAINT filer_folderpermission_pkey PRIMARY KEY (id);


--
-- Name: filer_image_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY filer_image
    ADD CONSTRAINT filer_image_pkey PRIMARY KEY (file_ptr_id);


--
-- Name: filer_thumbnailoption_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY filer_thumbnailoption
    ADD CONSTRAINT filer_thumbnailoption_pkey PRIMARY KEY (id);


--
-- Name: oauth2_provider_grant_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY oauth2_provider_grant
    ADD CONSTRAINT oauth2_provider_grant_pkey PRIMARY KEY (id);


--
-- Name: shop_bookmarkspromotionitem_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY shop_bookmarkspromotionitem
    ADD CONSTRAINT shop_bookmarkspromotionitem_pkey PRIMARY KEY (id);


--
-- Name: shop_coupon_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY shop_coupon
    ADD CONSTRAINT shop_coupon_pkey PRIMARY KEY (id);


--
-- Name: shop_promotion_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY shop_promotion
    ADD CONSTRAINT shop_promotion_pkey PRIMARY KEY (id);


--
-- Name: shop_promotion_target_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY shop_promotion_target
    ADD CONSTRAINT shop_promotion_target_pkey PRIMARY KEY (id);


--
-- Name: shop_promotion_target_promotion_id_b4ec847b_uniq; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY shop_promotion_target
    ADD CONSTRAINT shop_promotion_target_promotion_id_b4ec847b_uniq UNIQUE (promotion_id, subcategory_id);


--
-- Name: shop_promotionimage_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY shop_promotionimage
    ADD CONSTRAINT shop_promotionimage_pkey PRIMARY KEY (id);


--
-- Name: social_auth_code_email_801b2d02_uniq; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY social_auth_code
    ADD CONSTRAINT social_auth_code_email_801b2d02_uniq UNIQUE (email, code);


--
-- Name: social_auth_code_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY social_auth_code
    ADD CONSTRAINT social_auth_code_pkey PRIMARY KEY (id);


--
-- Name: social_auth_usersocialauth_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

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


--
-- Name: social_auth_usersocialauth_provider_e6b5e668_uniq; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

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


--
-- Name: socialaccount_socialaccount_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY socialaccount_socialaccount
    ADD CONSTRAINT socialaccount_socialaccount_pkey PRIMARY KEY (id);


--
-- Name: socialaccount_socialaccount_provider_fc810c6e_uniq; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY socialaccount_socialaccount
    ADD CONSTRAINT socialaccount_socialaccount_provider_fc810c6e_uniq UNIQUE (provider, uid);


--
-- Name: socialaccount_socialapp_sites_pkey; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY socialaccount_socialapp_sites
    ADD CONSTRAINT socialaccount_socialapp_sites_pkey PRIMARY KEY (id);


--
-- Name: socialaccount_socialapp_sites_socialapp_id_71a9a768_uniq; Type: CONSTRAINT; Schema: public; Owner: django; Tablespace: 
--

ALTER TABLE ONLY socialaccount_socialapp_sites
    ADD CONSTRAINT socialaccount_socialapp_sites_socialapp_id_71a9a768_uniq UNIQUE (socialapp_id, site_id);


--
-- Name: account_emailaddress_e8701ad4; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX account_emailaddress_e8701ad4 ON account_emailaddress USING btree (user_id);


--
-- Name: account_emailaddress_email_03be32b2_like; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX account_emailaddress_email_03be32b2_like ON account_emailaddress USING btree (email varchar_pattern_ops);


--
-- Name: accounts_achievement_2c724d65; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX accounts_achievement_2c724d65 ON accounts_achievement USING btree (buyer_id);


--
-- Name: accounts_clientprofile_interests_79f70305; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX accounts_clientprofile_interests_79f70305 ON accounts_clientprofile_interests USING btree (subcategory_id);


--
-- Name: accounts_clientprofile_interests_d5a6e845; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX accounts_clientprofile_interests_d5a6e845 ON accounts_clientprofile_interests USING btree (clientprofile_id);


--
-- Name: accounts_sellertarget_target_79f70305; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX accounts_sellertarget_target_79f70305 ON accounts_sellertarget_target USING btree (subcategory_id);


--
-- Name: accounts_sellertarget_target_80a580c2; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX accounts_sellertarget_target_80a580c2 ON accounts_sellertarget_target USING btree (sellertarget_id);


--
-- Name: accounts_shoppinglistitem_2c724d65; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX accounts_shoppinglistitem_2c724d65 ON accounts_shoppinglistitem USING btree (buyer_id);


--
-- Name: accounts_shoppinglistitem_79f70305; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX accounts_shoppinglistitem_79f70305 ON accounts_shoppinglistitem USING btree (subcategory_id);


--
-- Name: accounts_useraccount_groups_0e939a4f; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX accounts_useraccount_groups_0e939a4f ON accounts_useraccount_groups USING btree (group_id);


--
-- Name: accounts_useraccount_groups_f705e196; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX accounts_useraccount_groups_f705e196 ON accounts_useraccount_groups USING btree (useraccount_id);


--
-- Name: accounts_useraccount_user_permissions_8373b171; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX accounts_useraccount_user_permissions_8373b171 ON accounts_useraccount_user_permissions USING btree (permission_id);


--
-- Name: accounts_useraccount_user_permissions_f705e196; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX accounts_useraccount_user_permissions_f705e196 ON accounts_useraccount_user_permissions USING btree (useraccount_id);


--
-- Name: admon_category_name_d9ea34f6_like; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX admon_category_name_d9ea34f6_like ON admon_category USING btree (name varchar_pattern_ops);


--
-- Name: admon_category_subcategories_79f70305; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX admon_category_subcategories_79f70305 ON admon_category_subcategories USING btree (subcategory_id);


--
-- Name: admon_category_subcategories_b583a629; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX admon_category_subcategories_b583a629 ON admon_category_subcategories USING btree (category_id);


--
-- Name: admon_subcategory_name_6342090e_like; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX admon_subcategory_name_6342090e_like ON admon_subcategory USING btree (name varchar_pattern_ops);


--
-- Name: auth_group_name_a6ea08ec_like; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX auth_group_name_a6ea08ec_like ON auth_group USING btree (name varchar_pattern_ops);


--
-- Name: auth_group_permissions_0e939a4f; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX auth_group_permissions_0e939a4f ON auth_group_permissions USING btree (group_id);


--
-- Name: auth_group_permissions_8373b171; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX auth_group_permissions_8373b171 ON auth_group_permissions USING btree (permission_id);


--
-- Name: auth_permission_417f1b1c; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX auth_permission_417f1b1c ON auth_permission USING btree (content_type_id);


--
-- Name: billing_bill_8a089c2a; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX billing_bill_8a089c2a ON billing_bill USING btree (account_id);


--
-- Name: django_admin_log_417f1b1c; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX django_admin_log_417f1b1c ON django_admin_log USING btree (content_type_id);


--
-- Name: django_admin_log_e8701ad4; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX django_admin_log_e8701ad4 ON django_admin_log USING btree (user_id);


--
-- Name: django_site_domain_a2e37b91_like; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX django_site_domain_a2e37b91_like ON django_site USING btree (domain varchar_pattern_ops);


--
-- Name: easy_thumbnails_source_b068931c; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX easy_thumbnails_source_b068931c ON easy_thumbnails_source USING btree (name);


--
-- Name: easy_thumbnails_source_b454e115; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX easy_thumbnails_source_b454e115 ON easy_thumbnails_source USING btree (storage_hash);


--
-- Name: easy_thumbnails_source_name_5fe0edc6_like; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX easy_thumbnails_source_name_5fe0edc6_like ON easy_thumbnails_source USING btree (name varchar_pattern_ops);


--
-- Name: easy_thumbnails_source_storage_hash_946cbcc9_like; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX easy_thumbnails_source_storage_hash_946cbcc9_like ON easy_thumbnails_source USING btree (storage_hash varchar_pattern_ops);


--
-- Name: easy_thumbnails_thumbnail_0afd9202; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX easy_thumbnails_thumbnail_0afd9202 ON easy_thumbnails_thumbnail USING btree (source_id);


--
-- Name: easy_thumbnails_thumbnail_b068931c; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX easy_thumbnails_thumbnail_b068931c ON easy_thumbnails_thumbnail USING btree (name);


--
-- Name: easy_thumbnails_thumbnail_b454e115; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX easy_thumbnails_thumbnail_b454e115 ON easy_thumbnails_thumbnail USING btree (storage_hash);


--
-- Name: easy_thumbnails_thumbnail_name_b5882c31_like; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX easy_thumbnails_thumbnail_name_b5882c31_like ON easy_thumbnails_thumbnail USING btree (name varchar_pattern_ops);


--
-- Name: easy_thumbnails_thumbnail_storage_hash_f1435f49_like; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX easy_thumbnails_thumbnail_storage_hash_f1435f49_like ON easy_thumbnails_thumbnail USING btree (storage_hash varchar_pattern_ops);


--
-- Name: filer_clipboard_e8701ad4; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX filer_clipboard_e8701ad4 ON filer_clipboard USING btree (user_id);


--
-- Name: filer_clipboarditem_2655b062; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX filer_clipboarditem_2655b062 ON filer_clipboarditem USING btree (clipboard_id);


--
-- Name: filer_clipboarditem_814552b9; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX filer_clipboarditem_814552b9 ON filer_clipboarditem USING btree (file_id);


--
-- Name: filer_file_5e7b1936; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX filer_file_5e7b1936 ON filer_file USING btree (owner_id);


--
-- Name: filer_file_a8a44dbb; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX filer_file_a8a44dbb ON filer_file USING btree (folder_id);


--
-- Name: filer_file_d3e32c49; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX filer_file_d3e32c49 ON filer_file USING btree (polymorphic_ctype_id);


--
-- Name: filer_folder_3cfbd988; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX filer_folder_3cfbd988 ON filer_folder USING btree (rght);


--
-- Name: filer_folder_5e7b1936; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX filer_folder_5e7b1936 ON filer_folder USING btree (owner_id);


--
-- Name: filer_folder_656442a0; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX filer_folder_656442a0 ON filer_folder USING btree (tree_id);


--
-- Name: filer_folder_6be37982; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX filer_folder_6be37982 ON filer_folder USING btree (parent_id);


--
-- Name: filer_folder_c9e9a848; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX filer_folder_c9e9a848 ON filer_folder USING btree (level);


--
-- Name: filer_folder_caf7cc51; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX filer_folder_caf7cc51 ON filer_folder USING btree (lft);


--
-- Name: filer_folderpermission_0e939a4f; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX filer_folderpermission_0e939a4f ON filer_folderpermission USING btree (group_id);


--
-- Name: filer_folderpermission_a8a44dbb; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX filer_folderpermission_a8a44dbb ON filer_folderpermission USING btree (folder_id);


--
-- Name: filer_folderpermission_e8701ad4; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX filer_folderpermission_e8701ad4 ON filer_folderpermission USING btree (user_id);


--
-- Name: oauth2_provider_grant_6bc0a4eb; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX oauth2_provider_grant_6bc0a4eb ON oauth2_provider_grant USING btree (application_id);


--
-- Name: oauth2_provider_grant_c1336794; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX oauth2_provider_grant_c1336794 ON oauth2_provider_grant USING btree (code);


--
-- Name: oauth2_provider_grant_code_49ab4ddf_like; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX oauth2_provider_grant_code_49ab4ddf_like ON oauth2_provider_grant USING btree (code varchar_pattern_ops);


--
-- Name: oauth2_provider_grant_e8701ad4; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX oauth2_provider_grant_e8701ad4 ON oauth2_provider_grant USING btree (user_id);


--
-- Name: shop_bookmarkspromotionitem_2c724d65; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX shop_bookmarkspromotionitem_2c724d65 ON shop_bookmarkspromotionitem USING btree (buyer_id);


--
-- Name: shop_bookmarkspromotionitem_b3c06c3b; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX shop_bookmarkspromotionitem_b3c06c3b ON shop_bookmarkspromotionitem USING btree (promotion_id);


--
-- Name: shop_coupon_2c724d65; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX shop_coupon_2c724d65 ON shop_coupon USING btree (buyer_id);


--
-- Name: shop_coupon_b3c06c3b; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX shop_coupon_b3c06c3b ON shop_coupon USING btree (promotion_id);


--
-- Name: shop_promotion_0a7c7ff2; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX shop_promotion_0a7c7ff2 ON shop_promotion USING btree (seller_id);


--
-- Name: shop_promotion_target_79f70305; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX shop_promotion_target_79f70305 ON shop_promotion_target USING btree (subcategory_id);


--
-- Name: shop_promotion_target_b3c06c3b; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX shop_promotion_target_b3c06c3b ON shop_promotion_target USING btree (promotion_id);


--
-- Name: shop_promotionimage_b3c06c3b; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX shop_promotionimage_b3c06c3b ON shop_promotionimage USING btree (promotion_id);


--
-- Name: social_auth_code_c1336794; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX social_auth_code_c1336794 ON social_auth_code USING btree (code);


--
-- Name: social_auth_code_code_a2393167_like; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX social_auth_code_code_a2393167_like ON social_auth_code USING btree (code varchar_pattern_ops);


--
-- Name: social_auth_usersocialauth_e8701ad4; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX social_auth_usersocialauth_e8701ad4 ON social_auth_usersocialauth USING btree (user_id);


--
-- Name: socialaccount_socialaccount_e8701ad4; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX socialaccount_socialaccount_e8701ad4 ON socialaccount_socialaccount USING btree (user_id);


--
-- Name: socialaccount_socialapp_sites_9365d6e7; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX socialaccount_socialapp_sites_9365d6e7 ON socialaccount_socialapp_sites USING btree (site_id);


--
-- Name: socialaccount_socialapp_sites_fe95b0a0; Type: INDEX; Schema: public; Owner: django; Tablespace: 
--

CREATE INDEX socialaccount_socialapp_sites_fe95b0a0 ON socialaccount_socialapp_sites USING btree (socialapp_id);


--
-- Name: account_emailaddres_user_id_2c513194_fk_accounts_useraccount_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY account_emailaddress
    ADD CONSTRAINT account_emailaddres_user_id_2c513194_fk_accounts_useraccount_id FOREIGN KEY (user_id) REFERENCES accounts_useraccount(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: accounts_achievement_buyer_id_a410ee24_fk_accounts_buyer_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY accounts_achievement
    ADD CONSTRAINT accounts_achievement_buyer_id_a410ee24_fk_accounts_buyer_id FOREIGN KEY (buyer_id) REFERENCES accounts_buyer(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: accounts_bu_user_account_id_49cdd495_fk_accounts_useraccount_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY accounts_buyer
    ADD CONSTRAINT accounts_bu_user_account_id_49cdd495_fk_accounts_useraccount_id FOREIGN KEY (user_account_id) REFERENCES accounts_useraccount(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: accounts_client_subcategory_id_cb16336b_fk_admon_subcategory_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY accounts_clientprofile_interests
    ADD CONSTRAINT accounts_client_subcategory_id_cb16336b_fk_admon_subcategory_id FOREIGN KEY (subcategory_id) REFERENCES admon_subcategory(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: accounts_clientprofile_buyer_id_71a63457_fk_accounts_buyer_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY accounts_clientprofile
    ADD CONSTRAINT accounts_clientprofile_buyer_id_71a63457_fk_accounts_buyer_id FOREIGN KEY (buyer_id) REFERENCES accounts_buyer(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: accounts_clientprofile_id_bea0de1e_fk_accounts_clientprofile_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY accounts_clientprofile_interests
    ADD CONSTRAINT accounts_clientprofile_id_bea0de1e_fk_accounts_clientprofile_id FOREIGN KEY (clientprofile_id) REFERENCES accounts_clientprofile(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: accounts_ow_user_account_id_a0b5c9b3_fk_accounts_useraccount_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY accounts_ownershop
    ADD CONSTRAINT accounts_ow_user_account_id_a0b5c9b3_fk_accounts_useraccount_id FOREIGN KEY (user_account_id) REFERENCES accounts_useraccount(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: accounts_s_sellertarget_id_1b0caf12_fk_accounts_sellertarget_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY accounts_sellertarget_target
    ADD CONSTRAINT accounts_s_sellertarget_id_1b0caf12_fk_accounts_sellertarget_id FOREIGN KEY (sellertarget_id) REFERENCES accounts_sellertarget(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: accounts_se_user_account_id_5ff93fbb_fk_accounts_useraccount_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY accounts_seller
    ADD CONSTRAINT accounts_se_user_account_id_5ff93fbb_fk_accounts_useraccount_id FOREIGN KEY (user_account_id) REFERENCES accounts_useraccount(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: accounts_seller_subcategory_id_2f69b130_fk_admon_subcategory_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY accounts_sellertarget_target
    ADD CONSTRAINT accounts_seller_subcategory_id_2f69b130_fk_admon_subcategory_id FOREIGN KEY (subcategory_id) REFERENCES admon_subcategory(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: accounts_sellertarget_seller_id_5afb27b2_fk_accounts_seller_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY accounts_sellertarget
    ADD CONSTRAINT accounts_sellertarget_seller_id_5afb27b2_fk_accounts_seller_id FOREIGN KEY (seller_id) REFERENCES accounts_seller(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: accounts_shoppi_subcategory_id_04400a1d_fk_admon_subcategory_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY accounts_shoppinglistitem
    ADD CONSTRAINT accounts_shoppi_subcategory_id_04400a1d_fk_admon_subcategory_id FOREIGN KEY (subcategory_id) REFERENCES admon_subcategory(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: accounts_shoppinglistite_buyer_id_a03c7134_fk_accounts_buyer_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY accounts_shoppinglistitem
    ADD CONSTRAINT accounts_shoppinglistite_buyer_id_a03c7134_fk_accounts_buyer_id FOREIGN KEY (buyer_id) REFERENCES accounts_buyer(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: accounts_use_useraccount_id_1eefb17f_fk_accounts_useraccount_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY accounts_useraccount_groups
    ADD CONSTRAINT accounts_use_useraccount_id_1eefb17f_fk_accounts_useraccount_id FOREIGN KEY (useraccount_id) REFERENCES accounts_useraccount(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: accounts_use_useraccount_id_9ee22c82_fk_accounts_useraccount_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY accounts_useraccount_user_permissions
    ADD CONSTRAINT accounts_use_useraccount_id_9ee22c82_fk_accounts_useraccount_id FOREIGN KEY (useraccount_id) REFERENCES accounts_useraccount(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: accounts_useraccou_permission_id_5751e5ed_fk_auth_permission_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

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


--
-- Name: accounts_useraccount_groups_group_id_07495d90_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

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


--
-- Name: admon_category__subcategory_id_332a7e64_fk_admon_subcategory_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY admon_category_subcategories
    ADD CONSTRAINT admon_category__subcategory_id_332a7e64_fk_admon_subcategory_id FOREIGN KEY (subcategory_id) REFERENCES admon_subcategory(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: admon_category_subcat_category_id_7062dca5_fk_admon_category_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY admon_category_subcategories
    ADD CONSTRAINT admon_category_subcat_category_id_7062dca5_fk_admon_category_id FOREIGN KEY (category_id) REFERENCES admon_category(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_group_permiss_permission_id_84c5c92e_fk_auth_permission_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

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


--
-- Name: auth_group_permissions_group_id_b120cbf9_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

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


--
-- Name: auth_permiss_content_type_id_2f476e4b_fk_django_content_type_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

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


--
-- Name: billing_bill_account_id_ebd68bac_fk_accounts_useraccount_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY billing_bill
    ADD CONSTRAINT billing_bill_account_id_ebd68bac_fk_accounts_useraccount_id FOREIGN KEY (account_id) REFERENCES accounts_useraccount(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: django_admin_content_type_id_c4bce8eb_fk_django_content_type_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

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


--
-- Name: django_admin_log_user_id_c564eba6_fk_accounts_useraccount_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

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


--
-- Name: easy_thum_thumbnail_id_c3a0c549_fk_easy_thumbnails_thumbnail_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY easy_thumbnails_thumbnaildimensions
    ADD CONSTRAINT easy_thum_thumbnail_id_c3a0c549_fk_easy_thumbnails_thumbnail_id FOREIGN KEY (thumbnail_id) REFERENCES easy_thumbnails_thumbnail(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: easy_thumbnails_source_id_5b57bc77_fk_easy_thumbnails_source_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY easy_thumbnails_thumbnail
    ADD CONSTRAINT easy_thumbnails_source_id_5b57bc77_fk_easy_thumbnails_source_id FOREIGN KEY (source_id) REFERENCES easy_thumbnails_source(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: filer_clipboard_user_id_b52ff0bc_fk_accounts_useraccount_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY filer_clipboard
    ADD CONSTRAINT filer_clipboard_user_id_b52ff0bc_fk_accounts_useraccount_id FOREIGN KEY (user_id) REFERENCES accounts_useraccount(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: filer_clipboarditem_clipboard_id_7a76518b_fk_filer_clipboard_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY filer_clipboarditem
    ADD CONSTRAINT filer_clipboarditem_clipboard_id_7a76518b_fk_filer_clipboard_id FOREIGN KEY (clipboard_id) REFERENCES filer_clipboard(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: filer_clipboarditem_file_id_06196f80_fk_filer_file_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY filer_clipboarditem
    ADD CONSTRAINT filer_clipboarditem_file_id_06196f80_fk_filer_file_id FOREIGN KEY (file_id) REFERENCES filer_file(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: filer_f_polymorphic_ctype_id_f44903c1_fk_django_content_type_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY filer_file
    ADD CONSTRAINT filer_f_polymorphic_ctype_id_f44903c1_fk_django_content_type_id FOREIGN KEY (polymorphic_ctype_id) REFERENCES django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: filer_file_folder_id_af803bbb_fk_filer_folder_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY filer_file
    ADD CONSTRAINT filer_file_folder_id_af803bbb_fk_filer_folder_id FOREIGN KEY (folder_id) REFERENCES filer_folder(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: filer_file_owner_id_b9e32671_fk_accounts_useraccount_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY filer_file
    ADD CONSTRAINT filer_file_owner_id_b9e32671_fk_accounts_useraccount_id FOREIGN KEY (owner_id) REFERENCES accounts_useraccount(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: filer_folder_owner_id_be530fb4_fk_accounts_useraccount_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY filer_folder
    ADD CONSTRAINT filer_folder_owner_id_be530fb4_fk_accounts_useraccount_id FOREIGN KEY (owner_id) REFERENCES accounts_useraccount(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: filer_folder_parent_id_308aecda_fk_filer_folder_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY filer_folder
    ADD CONSTRAINT filer_folder_parent_id_308aecda_fk_filer_folder_id FOREIGN KEY (parent_id) REFERENCES filer_folder(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: filer_folderpermiss_user_id_7673d4b6_fk_accounts_useraccount_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY filer_folderpermission
    ADD CONSTRAINT filer_folderpermiss_user_id_7673d4b6_fk_accounts_useraccount_id FOREIGN KEY (user_id) REFERENCES accounts_useraccount(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: filer_folderpermission_folder_id_5d02f1da_fk_filer_folder_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY filer_folderpermission
    ADD CONSTRAINT filer_folderpermission_folder_id_5d02f1da_fk_filer_folder_id FOREIGN KEY (folder_id) REFERENCES filer_folder(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: filer_folderpermission_group_id_8901bafa_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

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


--
-- Name: filer_image_file_ptr_id_3e21d4f0_fk_filer_file_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY filer_image
    ADD CONSTRAINT filer_image_file_ptr_id_3e21d4f0_fk_filer_file_id FOREIGN KEY (file_ptr_id) REFERENCES filer_file(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: oauth2_provider_gra_user_id_e8f62af8_fk_accounts_useraccount_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY oauth2_provider_grant
    ADD CONSTRAINT oauth2_provider_gra_user_id_e8f62af8_fk_accounts_useraccount_id FOREIGN KEY (user_id) REFERENCES accounts_useraccount(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: oauth_application_id_81923564_fk_oauth2_provider_application_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY oauth2_provider_grant
    ADD CONSTRAINT oauth_application_id_81923564_fk_oauth2_provider_application_id FOREIGN KEY (application_id) REFERENCES oauth2_provider_application(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: shop_bookmarkspromot_promotion_id_5ab0d0de_fk_shop_promotion_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY shop_bookmarkspromotionitem
    ADD CONSTRAINT shop_bookmarkspromot_promotion_id_5ab0d0de_fk_shop_promotion_id FOREIGN KEY (promotion_id) REFERENCES shop_promotion(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: shop_bookmarkspromotioni_buyer_id_e13a659c_fk_accounts_buyer_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY shop_bookmarkspromotionitem
    ADD CONSTRAINT shop_bookmarkspromotioni_buyer_id_e13a659c_fk_accounts_buyer_id FOREIGN KEY (buyer_id) REFERENCES accounts_buyer(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: shop_coupon_buyer_id_c440b68b_fk_accounts_buyer_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY shop_coupon
    ADD CONSTRAINT shop_coupon_buyer_id_c440b68b_fk_accounts_buyer_id FOREIGN KEY (buyer_id) REFERENCES accounts_buyer(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: shop_coupon_promotion_id_9d9f8516_fk_shop_promotion_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY shop_coupon
    ADD CONSTRAINT shop_coupon_promotion_id_9d9f8516_fk_shop_promotion_id FOREIGN KEY (promotion_id) REFERENCES shop_promotion(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: shop_promotion__subcategory_id_9db442c2_fk_admon_subcategory_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY shop_promotion_target
    ADD CONSTRAINT shop_promotion__subcategory_id_9db442c2_fk_admon_subcategory_id FOREIGN KEY (subcategory_id) REFERENCES admon_subcategory(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: shop_promotion_seller_id_20ec2d80_fk_accounts_seller_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY shop_promotion
    ADD CONSTRAINT shop_promotion_seller_id_20ec2d80_fk_accounts_seller_id FOREIGN KEY (seller_id) REFERENCES accounts_seller(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: shop_promotion_targe_promotion_id_4bdabaa3_fk_shop_promotion_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY shop_promotion_target
    ADD CONSTRAINT shop_promotion_targe_promotion_id_4bdabaa3_fk_shop_promotion_id FOREIGN KEY (promotion_id) REFERENCES shop_promotion(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: shop_promotionimage_promotion_id_c1a6f722_fk_shop_promotion_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY shop_promotionimage
    ADD CONSTRAINT shop_promotionimage_promotion_id_c1a6f722_fk_shop_promotion_id FOREIGN KEY (promotion_id) REFERENCES shop_promotion(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: social_auth_usersoc_user_id_17d28448_fk_accounts_useraccount_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

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


--
-- Name: socialaccou_socialapp_id_97fb6e7d_fk_socialaccount_socialapp_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY socialaccount_socialapp_sites
    ADD CONSTRAINT socialaccou_socialapp_id_97fb6e7d_fk_socialaccount_socialapp_id FOREIGN KEY (socialapp_id) REFERENCES socialaccount_socialapp(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: socialaccount_socia_user_id_8146e70c_fk_accounts_useraccount_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY socialaccount_socialaccount
    ADD CONSTRAINT socialaccount_socia_user_id_8146e70c_fk_accounts_useraccount_id FOREIGN KEY (user_id) REFERENCES accounts_useraccount(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: socialaccount_socialapp_site_site_id_2579dee5_fk_django_site_id; Type: FK CONSTRAINT; Schema: public; Owner: django
--

ALTER TABLE ONLY socialaccount_socialapp_sites
    ADD CONSTRAINT socialaccount_socialapp_site_site_id_2579dee5_fk_django_site_id FOREIGN KEY (site_id) REFERENCES django_site(id) DEFERRABLE INITIALLY DEFERRED;


--
-- 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;


--
--

