SET statement_timeout = 0;

SET lock_timeout = 0;

SET client_encoding = 'UTF8';

SET standard_conforming_strings = on;

SET check_function_bodies = false;

SET client_min_messages = warning;

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;

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

CREATE EXTENSION IF NOT EXISTS dblink WITH SCHEMA public;

COMMENT ON EXTENSION dblink IS 'connect to other PostgreSQL databases from within a database';

SET search_path = public, pg_catalog;

CREATE TYPE ghstore;

CREATE FUNCTION ghstore_in(cstring) RETURNS ghstore

LANGUAGE c STRICT

AS '$libdir/hstore', 'ghstore_in';

CREATE FUNCTION ghstore_out(ghstore) RETURNS cstring

LANGUAGE c STRICT

AS '$libdir/hstore', 'ghstore_out';

CREATE TYPE ghstore (

INTERNALLENGTH = variable,

INPUT = ghstore_in,

OUTPUT = ghstore_out,

ALIGNMENT = int4,

STORAGE = plain

);

CREATE TYPE hstore;

CREATE FUNCTION hstore_in(cstring) RETURNS hstore

LANGUAGE c STRICT

AS '$libdir/hstore', 'hstore_in';

CREATE FUNCTION hstore_out(hstore) RETURNS cstring

LANGUAGE c STRICT

AS '$libdir/hstore', 'hstore_out';

CREATE TYPE hstore (

INTERNALLENGTH = variable,

INPUT = hstore_in,

OUTPUT = hstore_out,

ALIGNMENT = int4,

STORAGE = extended

);

CREATE FUNCTION akeys(hstore) RETURNS text[]

LANGUAGE c IMMUTABLE STRICT

AS '$libdir/hstore', 'akeys';

CREATE FUNCTION avals(hstore) RETURNS text[]

LANGUAGE c IMMUTABLE STRICT

AS '$libdir/hstore', 'avals';

CREATE FUNCTION defined(hstore, text) RETURNS boolean

LANGUAGE c IMMUTABLE STRICT

AS '$libdir/hstore', 'defined';

CREATE FUNCTION delete(hstore, text) RETURNS hstore

LANGUAGE c IMMUTABLE STRICT

AS '$libdir/hstore', 'delete';

CREATE FUNCTION each(hs hstore, OUT key text, OUT value text) RETURNS SETOF record

LANGUAGE c IMMUTABLE STRICT

AS '$libdir/hstore', 'each';

CREATE FUNCTION exist(hstore, text) RETURNS boolean

LANGUAGE c IMMUTABLE STRICT

AS '$libdir/hstore', 'exists';

CREATE FUNCTION fetchval(hstore, text) RETURNS text

LANGUAGE c IMMUTABLE STRICT

AS '$libdir/hstore', 'fetchval';

CREATE FUNCTION ghstore_compress(internal) RETURNS internal

LANGUAGE c IMMUTABLE STRICT

AS '$libdir/hstore', 'ghstore_compress';

CREATE FUNCTION ghstore_consistent(internal, internal, integer, oid, internal) RETURNS boolean

LANGUAGE c IMMUTABLE STRICT

AS '$libdir/hstore', 'ghstore_consistent';

CREATE FUNCTION ghstore_decompress(internal) RETURNS internal

LANGUAGE c IMMUTABLE STRICT

AS '$libdir/hstore', 'ghstore_decompress';

CREATE FUNCTION ghstore_penalty(internal, internal, internal) RETURNS internal

LANGUAGE c IMMUTABLE STRICT

AS '$libdir/hstore', 'ghstore_penalty';

CREATE FUNCTION ghstore_picksplit(internal, internal) RETURNS internal

LANGUAGE c IMMUTABLE STRICT

AS '$libdir/hstore', 'ghstore_picksplit';

CREATE FUNCTION ghstore_same(internal, internal, internal) RETURNS internal

LANGUAGE c IMMUTABLE STRICT

AS '$libdir/hstore', 'ghstore_same';

CREATE FUNCTION ghstore_union(internal, internal) RETURNS internal

LANGUAGE c IMMUTABLE STRICT

AS '$libdir/hstore', 'ghstore_union';

CREATE FUNCTION gin_consistent_hstore(internal, smallint, internal, integer, internal, internal) RETURNS boolean

LANGUAGE c IMMUTABLE STRICT

AS '$libdir/hstore', 'gin_consistent_hstore';

CREATE FUNCTION gin_extract_hstore(internal, internal) RETURNS internal

LANGUAGE c IMMUTABLE STRICT

AS '$libdir/hstore', 'gin_extract_hstore';

CREATE FUNCTION gin_extract_hstore_query(internal, internal, smallint, internal, internal) RETURNS internal

LANGUAGE c IMMUTABLE STRICT

AS '$libdir/hstore', 'gin_extract_hstore_query';

CREATE FUNCTION hs_concat(hstore, hstore) RETURNS hstore

LANGUAGE c IMMUTABLE STRICT

AS '$libdir/hstore', 'hs_concat';

CREATE FUNCTION hs_contained(hstore, hstore) RETURNS boolean

LANGUAGE c IMMUTABLE STRICT

AS '$libdir/hstore', 'hs_contained';

CREATE FUNCTION hs_contains(hstore, hstore) RETURNS boolean

LANGUAGE c IMMUTABLE STRICT

AS '$libdir/hstore', 'hs_contains';

CREATE FUNCTION hstore(text, text) RETURNS hstore

LANGUAGE c IMMUTABLE

AS '$libdir/hstore', 'tconvert';

CREATE FUNCTION isdefined(hstore, text) RETURNS boolean

LANGUAGE c IMMUTABLE STRICT

AS '$libdir/hstore', 'defined';

CREATE FUNCTION isexists(hstore, text) RETURNS boolean

LANGUAGE c IMMUTABLE STRICT

AS '$libdir/hstore', 'exists';

CREATE FUNCTION skeys(hstore) RETURNS SETOF text

LANGUAGE c IMMUTABLE STRICT

AS '$libdir/hstore', 'skeys';

CREATE FUNCTION svals(hstore) RETURNS SETOF text

LANGUAGE c IMMUTABLE STRICT

AS '$libdir/hstore', 'svals';

CREATE FUNCTION tconvert(text, text) RETURNS hstore

LANGUAGE c IMMUTABLE

AS '$libdir/hstore', 'tconvert';

CREATE OPERATOR -> (

PROCEDURE = fetchval,

LEFTARG = hstore,

RIGHTARG = text

);

CREATE OPERATOR <@ (

PROCEDURE = hs_contained,

LEFTARG = hstore,

RIGHTARG = hstore,

COMMUTATOR = @>,

RESTRICT = contsel,

JOIN = contjoinsel

);

CREATE OPERATOR => (

PROCEDURE = tconvert,

LEFTARG = text,

RIGHTARG = text

);

CREATE OPERATOR ? (

PROCEDURE = exist,

LEFTARG = hstore,

RIGHTARG = text,

RESTRICT = contsel,

JOIN = contjoinsel

);

CREATE OPERATOR @ (

PROCEDURE = hs_contains,

LEFTARG = hstore,

RIGHTARG = hstore,

COMMUTATOR = ~,

RESTRICT = contsel,

JOIN = contjoinsel

);

CREATE OPERATOR @> (

PROCEDURE = hs_contains,

LEFTARG = hstore,

RIGHTARG = hstore,

COMMUTATOR = <@,

RESTRICT = contsel,

JOIN = contjoinsel

);

CREATE OPERATOR || (

PROCEDURE = hs_concat,

LEFTARG = hstore,

RIGHTARG = hstore

);

CREATE OPERATOR ~ (

PROCEDURE = hs_contained,

LEFTARG = hstore,

RIGHTARG = hstore,

COMMUTATOR = @,

RESTRICT = contsel,

JOIN = contjoinsel

);

CREATE OPERATOR CLASS gin_hstore_ops

DEFAULT FOR TYPE hstore USING gin AS

STORAGE text ,

OPERATOR 7 @>(hstore,hstore) ,

OPERATOR 9 ?(hstore,text) ,

FUNCTION 1 (hstore, hstore) bttextcmp(text,text) ,

FUNCTION 2 (hstore, hstore) gin_extract_hstore(internal,internal) ,

FUNCTION 3 (hstore, hstore) gin_extract_hstore_query(internal,internal,smallint,internal,internal) ,

FUNCTION 4 (hstore, hstore) gin_consistent_hstore(internal,smallint,internal,integer,internal,internal);

CREATE OPERATOR CLASS gist_hstore_ops

DEFAULT FOR TYPE hstore USING gist AS

STORAGE ghstore ,

OPERATOR 7 @>(hstore,hstore) ,

OPERATOR 9 ?(hstore,text) ,

OPERATOR 13 @(hstore,hstore) ,

FUNCTION 1 (hstore, hstore) ghstore_consistent(internal,internal,integer,oid,internal) ,

FUNCTION 2 (hstore, hstore) ghstore_union(internal,internal) ,

FUNCTION 3 (hstore, hstore) ghstore_compress(internal) ,

FUNCTION 4 (hstore, hstore) ghstore_decompress(internal) ,

FUNCTION 5 (hstore, hstore) ghstore_penalty(internal,internal,internal) ,

FUNCTION 6 (hstore, hstore) ghstore_picksplit(internal,internal) ,

FUNCTION 7 (hstore, hstore) ghstore_same(internal,internal,internal);

SET default_tablespace = '';

SET default_with_oids = false;

CREATE TABLE accounts (

id integer NOT NULL,

first_name character varying(40),

last_name character varying(40),

email character varying(100),

hashed_password character varying(255),

created_at timestamp without time zone,

updated_at timestamp without time zone,

identities hstore,

language character varying(3) DEFAULT 'eng'::character varying,

document_language character varying(3) DEFAULT 'eng'::character varying

);

CREATE SEQUENCE accounts_id_seq

START WITH 1

INCREMENT BY 1

NO MINVALUE

NO MAXVALUE

CACHE 1;

ALTER SEQUENCE accounts_id_seq OWNED BY accounts.id;

CREATE TABLE annotations (

id integer NOT NULL,

organization_id integer NOT NULL,

account_id integer NOT NULL,

document_id integer NOT NULL,

page_number integer NOT NULL,

access integer NOT NULL,

title text NOT NULL,

content text,

location character varying(40),

created_at timestamp without time zone,

updated_at timestamp without time zone

);

CREATE SEQUENCE annotations_id_seq

START WITH 1

INCREMENT BY 1

NO MINVALUE

NO MAXVALUE

CACHE 1;

ALTER SEQUENCE annotations_id_seq OWNED BY annotations.id;

CREATE TABLE app_constants (

id integer NOT NULL,

key character varying(255),

value character varying(255)

);

CREATE SEQUENCE app_constants_id_seq

START WITH 1

INCREMENT BY 1

NO MINVALUE

NO MAXVALUE

CACHE 1;

ALTER SEQUENCE app_constants_id_seq OWNED BY app_constants.id;

CREATE TABLE bull_proof_china_shop_account_requests (

id integer NOT NULL,

created_at timestamp without time zone,

updated_at timestamp without time zone,

requester_email character varying(255),

requester_first_name character varying(255),

requester_last_name character varying(255),

requester_notes text,

organization_name character varying(255),

organization_url character varying(255),

approver_email character varying(255),

approver_first_name character varying(255),

approver_last_name character varying(255),

country character varying(255) NOT NULL,

verification_notes text,

status integer DEFAULT 1,

agreed_to_terms boolean DEFAULT false,

authorized_posting boolean DEFAULT false,

token character varying(255),

industry character varying(255),

use_case text,

reference_links text,

marketing_optin boolean DEFAULT false,

in_market boolean DEFAULT false,

requester_position character varying

);

CREATE SEQUENCE bull_proof_china_shop_account_requests_id_seq

START WITH 1

INCREMENT BY 1

NO MINVALUE

NO MAXVALUE

CACHE 1;

ALTER SEQUENCE bull_proof_china_shop_account_requests_id_seq OWNED BY bull_proof_china_shop_account_requests.id;

CREATE TABLE bull_proof_china_shop_accounts (

id integer NOT NULL,

stripe_customer_id character varying,

billing_email text,

dc_membership_id integer,

dc_membership_role integer,

dc_organization_id integer,

dc_account_id integer,

created_at timestamp without time zone NOT NULL,

updated_at timestamp without time zone NOT NULL

);

CREATE SEQUENCE bull_proof_china_shop_accounts_id_seq

START WITH 1

INCREMENT BY 1

NO MINVALUE

NO MAXVALUE

CACHE 1;

ALTER SEQUENCE bull_proof_china_shop_accounts_id_seq OWNED BY bull_proof_china_shop_accounts.id;

CREATE TABLE bull_proof_china_shop_permits (

id integer NOT NULL,

stripe_plan_id character varying,

stripe_customer_id character varying,

stripe_card_id character varying,

dc_membership_id integer,

dc_account_id integer,

dc_organization_id integer,

dc_membership_role integer,

status integer DEFAULT 1,

created_at timestamp without time zone NOT NULL,

updated_at timestamp without time zone NOT NULL,

stripe_subscription_id character varying,

stripe_customer_email character varying,

stripe_card_last4 integer,

account_id integer,

start_date timestamp without time zone,

end_date_scheduled timestamp without time zone,

end_date_actual timestamp without time zone

);

CREATE SEQUENCE bull_proof_china_shop_permits_id_seq

START WITH 1

INCREMENT BY 1

NO MINVALUE

NO MAXVALUE

CACHE 1;

ALTER SEQUENCE bull_proof_china_shop_permits_id_seq OWNED BY bull_proof_china_shop_permits.id;

CREATE TABLE collaborations (

id integer NOT NULL,

project_id integer NOT NULL,

account_id integer NOT NULL,

creator_id integer

);

CREATE SEQUENCE collaborations_id_seq

START WITH 1

INCREMENT BY 1

NO MINVALUE

NO MAXVALUE

CACHE 1;

ALTER SEQUENCE collaborations_id_seq OWNED BY collaborations.id;

CREATE TABLE docdata (

id integer NOT NULL,

document_id integer NOT NULL,

data hstore

);

CREATE SEQUENCE docdata_id_seq

START WITH 1

INCREMENT BY 1

NO MINVALUE

NO MAXVALUE

CACHE 1;

ALTER SEQUENCE docdata_id_seq OWNED BY docdata.id;

CREATE TABLE document_reviewers (

id integer NOT NULL,

account_id integer NOT NULL,

document_id integer NOT NULL,

created_at timestamp without time zone,

updated_at timestamp without time zone

);

CREATE SEQUENCE document_reviewers_id_seq

START WITH 1

INCREMENT BY 1

NO MINVALUE

NO MAXVALUE

CACHE 1;

ALTER SEQUENCE document_reviewers_id_seq OWNED BY document_reviewers.id;

CREATE TABLE documents (

id integer NOT NULL,

organization_id integer NOT NULL,

account_id integer NOT NULL,

access integer NOT NULL,

page_count integer DEFAULT 0 NOT NULL,

title character varying(1000) NOT NULL,

slug character varying(255) NOT NULL,

source character varying(1000),

language character varying(3),

description text,

calais_id character varying(40),

publication_date date,

created_at timestamp without time zone,

updated_at timestamp without time zone,

related_article text,

detected_remote_url text,

remote_url text,

publish_at timestamp without time zone,

text_changed boolean DEFAULT false NOT NULL,

hit_count integer DEFAULT 0 NOT NULL,

public_note_count integer DEFAULT 0 NOT NULL,

file_size integer DEFAULT 0 NOT NULL,

reviewer_count integer DEFAULT 0 NOT NULL,

char_count integer DEFAULT 0 NOT NULL,

original_extension character varying(255),

file_hash text

);

CREATE SEQUENCE documents_id_seq

START WITH 1

INCREMENT BY 1

NO MINVALUE

NO MAXVALUE

CACHE 1;

ALTER SEQUENCE documents_id_seq OWNED BY documents.id;

CREATE TABLE entities (

id integer NOT NULL,

organization_id integer NOT NULL,

account_id integer NOT NULL,

document_id integer NOT NULL,

access integer NOT NULL,

kind character varying(40) NOT NULL,

value character varying(255) NOT NULL,

relevance double precision DEFAULT 0.0 NOT NULL,

calais_id character varying(40),

occurrences text

);

CREATE TABLE entity_dates (

id integer NOT NULL,

organization_id integer NOT NULL,

account_id integer NOT NULL,

document_id integer NOT NULL,

access integer NOT NULL,

date date NOT NULL,

occurrences text

);

CREATE TABLE featured_reports (

id integer NOT NULL,

url character varying(255) NOT NULL,

title character varying(255) NOT NULL,

organization character varying(255) NOT NULL,

article_date date NOT NULL,

writeup text NOT NULL,

present_order integer DEFAULT 0 NOT NULL,

created_at timestamp without time zone,

updated_at timestamp without time zone

);

CREATE SEQUENCE featured_reports_id_seq

START WITH 1

INCREMENT BY 1

NO MINVALUE

NO MAXVALUE

CACHE 1;

ALTER SEQUENCE featured_reports_id_seq OWNED BY featured_reports.id;

CREATE TABLE projects (

id integer NOT NULL,

account_id integer,

title character varying(255),

description text,

hidden boolean DEFAULT false NOT NULL

);

CREATE SEQUENCE labels_id_seq

START WITH 1

INCREMENT BY 1

NO MINVALUE

NO MAXVALUE

CACHE 1;

ALTER SEQUENCE labels_id_seq OWNED BY projects.id;

CREATE TABLE memberships (

id integer NOT NULL,

organization_id integer NOT NULL,

account_id integer NOT NULL,

role integer NOT NULL,

"default" boolean DEFAULT false,

concealed boolean DEFAULT false

);

CREATE SEQUENCE memberships_id_seq

START WITH 1

INCREMENT BY 1

NO MINVALUE

NO MAXVALUE

CACHE 1;