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 DATABASE dcloud_development WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8';

\connect dcloud_development

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

CREATE EXTENSION IF NOT EXISTS hstore WITH SCHEMA public;

COMMENT ON EXTENSION hstore IS 'data type for storing sets of (key, value) pairs';

SET search_path = public, pg_catalog;

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;

ALTER SEQUENCE memberships_id_seq OWNED BY memberships.id;

CREATE SEQUENCE metadata_dates_id_seq

START WITH 1

INCREMENT BY 1

NO MINVALUE

NO MAXVALUE

CACHE 1;

ALTER SEQUENCE metadata_dates_id_seq OWNED BY entity_dates.id;

CREATE SEQUENCE metadata_id_seq

START WITH 1

INCREMENT BY 1

NO MINVALUE

NO MAXVALUE

CACHE 1;

ALTER SEQUENCE metadata_id_seq OWNED BY entities.id;

CREATE TABLE organizations (

id integer NOT NULL,

name character varying(100) NOT NULL,

slug character varying(100) NOT NULL,

created_at timestamp without time zone,

updated_at timestamp without time zone,

demo boolean DEFAULT false NOT NULL,

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

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

);

CREATE SEQUENCE organizations_id_seq

START WITH 1

INCREMENT BY 1

NO MINVALUE

NO MAXVALUE

CACHE 1;

ALTER SEQUENCE organizations_id_seq OWNED BY organizations.id;

CREATE TABLE page_count (

document_id integer,

count bigint

);

CREATE TABLE pages (

id integer NOT NULL,

organization_id integer NOT NULL,

account_id integer NOT NULL,

document_id integer NOT NULL,

access integer NOT NULL,

page_number integer NOT NULL,

text text NOT NULL,

start_offset integer,

end_offset integer,

aspect_ratio double precision

);

CREATE SEQUENCE pages_id_seq

START WITH 1

INCREMENT BY 1

NO MINVALUE

NO MAXVALUE

CACHE 1;

ALTER SEQUENCE pages_id_seq OWNED BY pages.id;

CREATE TABLE processing_jobs (

id integer NOT NULL,

account_id integer NOT NULL,

cloud_crowd_id integer NOT NULL,

title character varying(1000) NOT NULL,

document_id integer,

action character varying,

options character varying,

complete boolean DEFAULT false

);

CREATE SEQUENCE processing_jobs_id_seq

START WITH 1

INCREMENT BY 1

NO MINVALUE

NO MAXVALUE

CACHE 1;

ALTER SEQUENCE processing_jobs_id_seq OWNED BY processing_jobs.id;

CREATE TABLE project_memberships (

id integer NOT NULL,

project_id integer NOT NULL,

document_id integer NOT NULL

);

CREATE SEQUENCE project_memberships_id_seq

START WITH 1

INCREMENT BY 1

NO MINVALUE

NO MAXVALUE

CACHE 1;

ALTER SEQUENCE project_memberships_id_seq OWNED BY project_memberships.id;

CREATE TABLE schema_migrations (

version character varying(255) NOT NULL

);

CREATE TABLE sections (

id integer NOT NULL,

organization_id integer NOT NULL,

account_id integer NOT NULL,

document_id integer NOT NULL,

access integer NOT NULL,

title text NOT NULL,

page_number integer NOT NULL

);

CREATE SEQUENCE sections_id_seq

START WITH 1

INCREMENT BY 1

NO MINVALUE

NO MAXVALUE

CACHE 1;

ALTER SEQUENCE sections_id_seq OWNED BY sections.id;

CREATE TABLE security_keys (

id integer NOT NULL,

securable_type character varying(40) NOT NULL,

securable_id integer NOT NULL,

key character varying(40)

);

CREATE SEQUENCE security_keys_id_seq

START WITH 1

INCREMENT BY 1

NO MINVALUE

NO MAXVALUE

CACHE 1;

ALTER SEQUENCE security_keys_id_seq OWNED BY security_keys.id;

CREATE TABLE upload_mailboxes (

id integer NOT NULL,

membership_id integer NOT NULL,

sender character varying(255) NOT NULL,

recipient character varying(255) NOT NULL,

upload_count integer DEFAULT 0,

created_at timestamp without time zone NOT NULL,

updated_at timestamp without time zone NOT NULL

);

CREATE SEQUENCE upload_mailboxes_id_seq

START WITH 1

INCREMENT BY 1

NO MINVALUE

NO MAXVALUE

CACHE 1;

ALTER SEQUENCE upload_mailboxes_id_seq OWNED BY upload_mailboxes.id;

ALTER TABLE ONLY accounts ALTER COLUMN id SET DEFAULT nextval('accounts_id_seq'::regclass);

ALTER TABLE ONLY annotations ALTER COLUMN id SET DEFAULT nextval('annotations_id_seq'::regclass);

ALTER TABLE ONLY app_constants ALTER COLUMN id SET DEFAULT nextval('app_constants_id_seq'::regclass);

ALTER TABLE ONLY bull_proof_china_shop_account_requests ALTER COLUMN id SET DEFAULT nextval('bull_proof_china_shop_account_requests_id_seq'::regclass);

ALTER TABLE ONLY bull_proof_china_shop_accounts ALTER COLUMN id SET DEFAULT nextval('bull_proof_china_shop_accounts_id_seq'::regclass);

ALTER TABLE ONLY bull_proof_china_shop_permits ALTER COLUMN id SET DEFAULT nextval('bull_proof_china_shop_permits_id_seq'::regclass);

ALTER TABLE ONLY collaborations ALTER COLUMN id SET DEFAULT nextval('collaborations_id_seq'::regclass);

ALTER TABLE ONLY docdata ALTER COLUMN id SET DEFAULT nextval('docdata_id_seq'::regclass);

ALTER TABLE ONLY document_reviewers ALTER COLUMN id SET DEFAULT nextval('document_reviewers_id_seq'::regclass);

ALTER TABLE ONLY documents ALTER COLUMN id SET DEFAULT nextval('documents_id_seq'::regclass);

ALTER TABLE ONLY entities ALTER COLUMN id SET DEFAULT nextval('metadata_id_seq'::regclass);

ALTER TABLE ONLY entity_dates ALTER COLUMN id SET DEFAULT nextval('metadata_dates_id_seq'::regclass);

ALTER TABLE ONLY featured_reports ALTER COLUMN id SET DEFAULT nextval('featured_reports_id_seq'::regclass);

ALTER TABLE ONLY memberships ALTER COLUMN id SET DEFAULT nextval('memberships_id_seq'::regclass);

ALTER TABLE ONLY organizations ALTER COLUMN id SET DEFAULT nextval('organizations_id_seq'::regclass);

ALTER TABLE ONLY pages ALTER COLUMN id SET DEFAULT nextval('pages_id_seq'::regclass);