ai_db

ai.sql

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.3.22
-- Dumped by pg_dump version 9.3.22
-- Started on 2018-07-30 11:16:37

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET client_min_messages = warning;

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

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- TOC entry 2126 (class 0 OID 0)
-- Dependencies: 1
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
--

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


--
-- TOC entry 548 (class 1247 OID 17637)
-- Name: param_type; Type: TYPE; Schema: public; Owner: io
--

CREATE TYPE public.param_type AS ENUM (
    'string',
    'number',
    'boolean',
    'memory',
    'result',
    'object',
    'params'
);


ALTER TYPE public.param_type OWNER TO io;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 171 (class 1259 OID 17651)
-- Name: action; Type: TABLE; Schema: public; Owner: io; Tablespace: 
--

CREATE TABLE public.action (
    id integer NOT NULL,
    phunction integer,
    letter integer,
    save character varying
)
WITH (autovacuum_enabled='true');


ALTER TABLE public.action OWNER TO io;

--
-- TOC entry 2127 (class 0 OID 0)
-- Dependencies: 171
-- Name: COLUMN action.save; Type: COMMENT; Schema: public; Owner: io
--

COMMENT ON COLUMN public.action.save IS 'save as';


--
-- TOC entry 172 (class 1259 OID 17657)
-- Name: action_id_seq; Type: SEQUENCE; Schema: public; Owner: io
--

CREATE SEQUENCE public.action_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.action_id_seq OWNER TO io;

--
-- TOC entry 2128 (class 0 OID 0)
-- Dependencies: 172
-- Name: action_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: io
--

ALTER SEQUENCE public.action_id_seq OWNED BY public.action.id;


--
-- TOC entry 173 (class 1259 OID 17659)
-- Name: ai; Type: TABLE; Schema: public; Owner: io; Tablespace: 
--

CREATE TABLE public.ai (
    id integer NOT NULL,
    word integer NOT NULL
)
WITH (autovacuum_enabled='true');


ALTER TABLE public.ai OWNER TO io;

--
-- TOC entry 174 (class 1259 OID 17662)
-- Name: ai_id_seq; Type: SEQUENCE; Schema: public; Owner: io
--

CREATE SEQUENCE public.ai_id_seq
    START WITH 1
    INCREMENT BY 1
    MINVALUE 0
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.ai_id_seq OWNER TO io;

--
-- TOC entry 2129 (class 0 OID 0)
-- Dependencies: 174
-- Name: ai_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: io
--

ALTER SEQUENCE public.ai_id_seq OWNED BY public.ai.id;


--
-- TOC entry 175 (class 1259 OID 17664)
-- Name: beat; Type: TABLE; Schema: public; Owner: io; Tablespace: 
--

CREATE TABLE public.beat (
    id integer NOT NULL,
    script integer NOT NULL,
    params character varying,
    "interval" integer DEFAULT 1000 NOT NULL
);


ALTER TABLE public.beat OWNER TO io;

--
-- TOC entry 176 (class 1259 OID 17671)
-- Name: beat_id_seq; Type: SEQUENCE; Schema: public; Owner: io
--

CREATE SEQUENCE public.beat_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.beat_id_seq OWNER TO io;

--
-- TOC entry 2130 (class 0 OID 0)
-- Dependencies: 176
-- Name: beat_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: io
--

ALTER SEQUENCE public.beat_id_seq OWNED BY public.beat.id;


--
-- TOC entry 177 (class 1259 OID 17673)
-- Name: conversation; Type: TABLE; Schema: public; Owner: io; Tablespace: 
--

CREATE TABLE public.conversation (
    id integer NOT NULL,
    parent integer DEFAULT 0 NOT NULL,
    letter integer NOT NULL,
    person integer NOT NULL,
    "timestamp" timestamp with time zone
);


ALTER TABLE public.conversation OWNER TO io;

--
-- TOC entry 178 (class 1259 OID 17677)
-- Name: conversation_id_seq; Type: SEQUENCE; Schema: public; Owner: io
--

CREATE SEQUENCE public.conversation_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.conversation_id_seq OWNER TO io;

--
-- TOC entry 2131 (class 0 OID 0)
-- Dependencies: 178
-- Name: conversation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: io
--

ALTER SEQUENCE public.conversation_id_seq OWNED BY public.conversation.id;


--
-- TOC entry 179 (class 1259 OID 17679)
-- Name: letter; Type: TABLE; Schema: public; Owner: io; Tablespace: 
--

CREATE TABLE public.letter (
    id integer NOT NULL,
    value text
)
WITH (autovacuum_enabled='true');


ALTER TABLE public.letter OWNER TO io;

--
-- TOC entry 180 (class 1259 OID 17685)
-- Name: letter_id_seq; Type: SEQUENCE; Schema: public; Owner: io
--

CREATE SEQUENCE public.letter_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.letter_id_seq OWNER TO io;

--
-- TOC entry 2132 (class 0 OID 0)
-- Dependencies: 180
-- Name: letter_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: io
--

ALTER SEQUENCE public.letter_id_seq OWNED BY public.letter.id;


--
-- TOC entry 181 (class 1259 OID 17687)
-- Name: neuron; Type: TABLE; Schema: public; Owner: io; Tablespace: 
--

CREATE TABLE public.neuron (
    id integer NOT NULL,
    ai integer,
    object integer,
    interest integer,
    satisfaction integer
)
WITH (autovacuum_enabled='true');


ALTER TABLE public.neuron OWNER TO io;

--
-- TOC entry 182 (class 1259 OID 17690)
-- Name: neuron_id_seq; Type: SEQUENCE; Schema: public; Owner: io
--

CREATE SEQUENCE public.neuron_id_seq
    START WITH 1
    INCREMENT BY 1
    MINVALUE 0
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.neuron_id_seq OWNER TO io;

--
-- TOC entry 2133 (class 0 OID 0)
-- Dependencies: 182
-- Name: neuron_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: io
--

ALTER SEQUENCE public.neuron_id_seq OWNED BY public.neuron.id;


--
-- TOC entry 183 (class 1259 OID 17692)
-- Name: nlp; Type: TABLE; Schema: public; Owner: io; Tablespace: 
--

CREATE TABLE public.nlp (
    id integer NOT NULL,
    value text
)
WITH (autovacuum_enabled='true');


ALTER TABLE public.nlp OWNER TO io;

--
-- TOC entry 184 (class 1259 OID 17698)
-- Name: nlp_id_seq; Type: SEQUENCE; Schema: public; Owner: io
--

CREATE SEQUENCE public.nlp_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.nlp_id_seq OWNER TO io;

--
-- TOC entry 2134 (class 0 OID 0)
-- Dependencies: 184
-- Name: nlp_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: io
--

ALTER SEQUENCE public.nlp_id_seq OWNED BY public.nlp.id;


--
-- TOC entry 185 (class 1259 OID 17700)
-- Name: param; Type: TABLE; Schema: public; Owner: io; Tablespace: 
--

CREATE TABLE public.param (
    id integer NOT NULL,
    script integer NOT NULL,
    name character varying NOT NULL,
    value character varying NOT NULL,
    type public.param_type NOT NULL,
    parent integer
)
WITH (autovacuum_enabled='true');


ALTER TABLE public.param OWNER TO io;

--
-- TOC entry 186 (class 1259 OID 17706)
-- Name: param_id_seq; Type: SEQUENCE; Schema: public; Owner: io
--

CREATE SEQUENCE public.param_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.param_id_seq OWNER TO io;

--
-- TOC entry 2135 (class 0 OID 0)
-- Dependencies: 186
-- Name: param_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: io
--

ALTER SEQUENCE public.param_id_seq OWNED BY public.param.id;


--
-- TOC entry 187 (class 1259 OID 17708)
-- Name: phunction; Type: TABLE; Schema: public; Owner: io; Tablespace: 
--

CREATE TABLE public.phunction (
    id integer NOT NULL,
    api character varying NOT NULL,
    action character varying
)
WITH (autovacuum_enabled='true');


ALTER TABLE public.phunction OWNER TO io;

--
-- TOC entry 188 (class 1259 OID 17714)
-- Name: phunction_id_seq; Type: SEQUENCE; Schema: public; Owner: io
--

CREATE SEQUENCE public.phunction_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.phunction_id_seq OWNER TO io;

--
-- TOC entry 2136 (class 0 OID 0)
-- Dependencies: 188
-- Name: phunction_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: io
--

ALTER SEQUENCE public.phunction_id_seq OWNED BY public.phunction.id;


--
-- TOC entry 189 (class 1259 OID 17716)
-- Name: script; Type: TABLE; Schema: public; Owner: io; Tablespace: 
--

CREATE TABLE public.script (
    id integer NOT NULL,
    parent integer DEFAULT 0,
    action integer DEFAULT 0 NOT NULL,
    "position" integer DEFAULT 1 NOT NULL,
    "timestamp" timestamp without time zone DEFAULT statement_timestamp()
)
WITH (autovacuum_enabled='true');


ALTER TABLE public.script OWNER TO io;

--
-- TOC entry 190 (class 1259 OID 17723)
-- Name: script_id_seq; Type: SEQUENCE; Schema: public; Owner: io
--

CREATE SEQUENCE public.script_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.script_id_seq OWNER TO io;

--
-- TOC entry 2137 (class 0 OID 0)
-- Dependencies: 190
-- Name: script_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: io
--

ALTER SEQUENCE public.script_id_seq OWNED BY public.script.id;


--
-- TOC entry 191 (class 1259 OID 17725)
-- Name: sentence; Type: TABLE; Schema: public; Owner: io; Tablespace: 
--

CREATE TABLE public.sentence (
    id integer NOT NULL,
    word integer DEFAULT 0 NOT NULL,
    letter integer NOT NULL
)
WITH (autovacuum_enabled='true');


ALTER TABLE public.sentence OWNER TO io;

--
-- TOC entry 192 (class 1259 OID 17729)
-- Name: sentence_id_seq; Type: SEQUENCE; Schema: public; Owner: io
--

CREATE SEQUENCE public.sentence_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.sentence_id_seq OWNER TO io;

--
-- TOC entry 2138 (class 0 OID 0)
-- Dependencies: 192
-- Name: sentence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: io
--

ALTER SEQUENCE public.sentence_id_seq OWNED BY public.sentence.id;


--
-- TOC entry 193 (class 1259 OID 17731)
-- Name: synaps; Type: TABLE; Schema: public; Owner: io; Tablespace: 
--

CREATE TABLE public.synaps (
    id integer NOT NULL,
    a integer,
    b integer,
    "when" timestamp without time zone DEFAULT now(),
    strength smallint,
    relation integer
)
WITH (autovacuum_enabled='true');


ALTER TABLE public.synaps OWNER TO io;

--
-- TOC entry 194 (class 1259 OID 17735)
-- Name: synaps_id_seq; Type: SEQUENCE; Schema: public; Owner: io
--

CREATE SEQUENCE public.synaps_id_seq
    START WITH 1
    INCREMENT BY 1
    MINVALUE 0
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.synaps_id_seq OWNER TO io;

--
-- TOC entry 2139 (class 0 OID 0)
-- Dependencies: 194
-- Name: synaps_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: io
--

ALTER SEQUENCE public.synaps_id_seq OWNED BY public.synaps.id;


--
-- TOC entry 195 (class 1259 OID 17737)
-- Name: task; Type: TABLE; Schema: public; Owner: io; Tablespace: 
--

CREATE TABLE public.task (
    id integer NOT NULL,
    script integer,
    params character varying,
    status smallint,
    priority integer,
    due timestamp without time zone DEFAULT now(),
    chore smallint DEFAULT 0
);


ALTER TABLE public.task OWNER TO io;

--
-- TOC entry 196 (class 1259 OID 17745)
-- Name: task_id_seq; Type: SEQUENCE; Schema: public; Owner: io
--

CREATE SEQUENCE public.task_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.task_id_seq OWNER TO io;

--
-- TOC entry 2140 (class 0 OID 0)
-- Dependencies: 196
-- Name: task_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: io
--

ALTER SEQUENCE public.task_id_seq OWNED BY public.task.id;


--
-- TOC entry 197 (class 1259 OID 17747)
-- Name: word; Type: TABLE; Schema: public; Owner: io; Tablespace: 
--

CREATE TABLE public.word (
    id integer NOT NULL,
    value character varying
)
WITH (autovacuum_enabled='true');


ALTER TABLE public.word OWNER TO io;

--
-- TOC entry 198 (class 1259 OID 17753)
-- Name: word_id_seq; Type: SEQUENCE; Schema: public; Owner: io
--

CREATE SEQUENCE public.word_id_seq
    START WITH 1
    INCREMENT BY 1
    MINVALUE 0
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.word_id_seq OWNER TO io;

--
-- TOC entry 2141 (class 0 OID 0)
-- Dependencies: 198
-- Name: word_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: io
--

ALTER SEQUENCE public.word_id_seq OWNED BY public.word.id;


--
-- TOC entry 199 (class 1259 OID 17755)
-- Name: word_sequence; Type: TABLE; Schema: public; Owner: io; Tablespace: 
--

CREATE TABLE public.word_sequence (
    id integer NOT NULL,
    word integer NOT NULL,
    sentence integer NOT NULL,
    "position" integer DEFAULT 1 NOT NULL,
    word_tag integer DEFAULT 0,
    parent integer DEFAULT 0 NOT NULL
)
WITH (autovacuum_enabled='true');


ALTER TABLE public.word_sequence OWNER TO io;

--
-- TOC entry 200 (class 1259 OID 17761)
-- Name: word_sequence_id_seq; Type: SEQUENCE; Schema: public; Owner: io
--

CREATE SEQUENCE public.word_sequence_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.word_sequence_id_seq OWNER TO io;

--
-- TOC entry 2142 (class 0 OID 0)
-- Dependencies: 200
-- Name: word_sequence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: io
--

ALTER SEQUENCE public.word_sequence_id_seq OWNED BY public.word_sequence.id;


--
-- TOC entry 201 (class 1259 OID 17763)
-- Name: word_tag; Type: TABLE; Schema: public; Owner: io; Tablespace: 
--

CREATE TABLE public.word_tag (
    id integer NOT NULL,
    word integer
)
WITH (autovacuum_enabled='true');


ALTER TABLE public.word_tag OWNER TO io;

--
-- TOC entry 202 (class 1259 OID 17766)
-- Name: word_tag_id_seq; Type: SEQUENCE; Schema: public; Owner: io
--

CREATE SEQUENCE public.word_tag_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.word_tag_id_seq OWNER TO io;

--
-- TOC entry 2143 (class 0 OID 0)
-- Dependencies: 202
-- Name: word_tag_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: io
--

ALTER SEQUENCE public.word_tag_id_seq OWNED BY public.word_tag.id;


--
-- TOC entry 1924 (class 2604 OID 17768)
-- Name: id; Type: DEFAULT; Schema: public; Owner: io
--

ALTER TABLE ONLY public.action ALTER COLUMN id SET DEFAULT nextval('public.action_id_seq'::regclass);


--
-- TOC entry 1925 (class 2604 OID 17769)
-- Name: id; Type: DEFAULT; Schema: public; Owner: io
--

ALTER TABLE ONLY public.ai ALTER COLUMN id SET DEFAULT nextval('public.ai_id_seq'::regclass);


--
-- TOC entry 1927 (class 2604 OID 17770)
-- Name: id; Type: DEFAULT; Schema: public; Owner: io
--

ALTER TABLE ONLY public.beat ALTER COLUMN id SET DEFAULT nextval('public.beat_id_seq'::regclass);


--
-- TOC entry 1929 (class 2604 OID 17771)
-- Name: id; Type: DEFAULT; Schema: public; Owner: io
--

ALTER TABLE ONLY public.conversation ALTER COLUMN id SET DEFAULT nextval('public.conversation_id_seq'::regclass);


--
-- TOC entry 1930 (class 2604 OID 17772)
-- Name: id; Type: DEFAULT; Schema: public; Owner: io
--

ALTER TABLE ONLY public.letter ALTER COLUMN id SET DEFAULT nextval('public.letter_id_seq'::regclass);


--
-- TOC entry 1931 (class 2604 OID 17773)
-- Name: id; Type: DEFAULT; Schema: public; Owner: io
--

ALTER TABLE ONLY public.neuron ALTER COLUMN id SET DEFAULT nextval('public.neuron_id_seq'::regclass);


--
-- TOC entry 1932 (class 2604 OID 17774)
-- Name: id; Type: DEFAULT; Schema: public; Owner: io
--

ALTER TABLE ONLY public.nlp ALTER COLUMN id SET DEFAULT nextval('public.nlp_id_seq'::regclass);


--
-- TOC entry 1933 (class 2604 OID 17775)
-- Name: id; Type: DEFAULT; Schema: public; Owner: io
--

ALTER TABLE ONLY public.param ALTER COLUMN id SET DEFAULT nextval('public.param_id_seq'::regclass);


--
-- TOC entry 1934 (class 2604 OID 17776)
-- Name: id; Type: DEFAULT; Schema: public; Owner: io
--

ALTER TABLE ONLY public.phunction ALTER COLUMN id SET DEFAULT nextval('public.phunction_id_seq'::regclass);


--
-- TOC entry 1939 (class 2604 OID 17777)
-- Name: id; Type: DEFAULT; Schema: public; Owner: io
--

ALTER TABLE ONLY public.script ALTER COLUMN id SET DEFAULT nextval('public.script_id_seq'::regclass);


--
-- TOC entry 1941 (class 2604 OID 17778)
-- Name: id; Type: DEFAULT; Schema: public; Owner: io
--

ALTER TABLE ONLY public.sentence ALTER COLUMN id SET DEFAULT nextval('public.sentence_id_seq'::regclass);


--
-- TOC entry 1943 (class 2604 OID 17779)
-- Name: id; Type: DEFAULT; Schema: public; Owner: io
--

ALTER TABLE ONLY public.synaps ALTER COLUMN id SET DEFAULT nextval('public.synaps_id_seq'::regclass);


--
-- TOC entry 1946 (class 2604 OID 17780)
-- Name: id; Type: DEFAULT; Schema: public; Owner: io
--

ALTER TABLE ONLY public.task ALTER COLUMN id SET DEFAULT nextval('public.task_id_seq'::regclass);


--
-- TOC entry 1947 (class 2604 OID 17781)
-- Name: id; Type: DEFAULT; Schema: public; Owner: io
--

ALTER TABLE ONLY public.word ALTER COLUMN id SET DEFAULT nextval('public.word_id_seq'::regclass);


--
-- TOC entry 1951 (class 2604 OID 17782)
-- Name: id; Type: DEFAULT; Schema: public; Owner: io
--

ALTER TABLE ONLY public.word_sequence ALTER COLUMN id SET DEFAULT nextval('public.word_sequence_id_seq'::regclass);


--
-- TOC entry 1952 (class 2604 OID 17783)
-- Name: id; Type: DEFAULT; Schema: public; Owner: io
--

ALTER TABLE ONLY public.word_tag ALTER COLUMN id SET DEFAULT nextval('public.word_tag_id_seq'::regclass);


--
-- TOC entry 1956 (class 2606 OID 17785)
-- Name: action_pk; Type: CONSTRAINT; Schema: public; Owner: io; Tablespace: 
--

ALTER TABLE ONLY public.action
    ADD CONSTRAINT action_pk PRIMARY KEY (id);


--
-- TOC entry 1958 (class 2606 OID 17787)
-- Name: ai_pk; Type: CONSTRAINT; Schema: public; Owner: io; Tablespace: 
--

ALTER TABLE ONLY public.ai
    ADD CONSTRAINT ai_pk PRIMARY KEY (id);


--
-- TOC entry 1961 (class 2606 OID 17789)
-- Name: beat_pk; Type: CONSTRAINT; Schema: public; Owner: io; Tablespace: 
--

ALTER TABLE ONLY public.beat
    ADD CONSTRAINT beat_pk PRIMARY KEY (id);


--
-- TOC entry 1963 (class 2606 OID 17791)
-- Name: conversation_pk; Type: CONSTRAINT; Schema: public; Owner: io; Tablespace: 
--

ALTER TABLE ONLY public.conversation
    ADD CONSTRAINT conversation_pk PRIMARY KEY (id);


--
-- TOC entry 1965 (class 2606 OID 17793)
-- Name: letter_pk; Type: CONSTRAINT; Schema: public; Owner: io; Tablespace: 
--

ALTER TABLE ONLY public.letter
    ADD CONSTRAINT letter_pk PRIMARY KEY (id);


--
-- TOC entry 1970 (class 2606 OID 17795)
-- Name: neuron_pk; Type: CONSTRAINT; Schema: public; Owner: io; Tablespace: 
--

ALTER TABLE ONLY public.neuron
    ADD CONSTRAINT neuron_pk PRIMARY KEY (id);


--
-- TOC entry 1973 (class 2606 OID 17797)
-- Name: nlp_pk; Type: CONSTRAINT; Schema: public; Owner: io; Tablespace: 
--

ALTER TABLE ONLY public.nlp
    ADD CONSTRAINT nlp_pk PRIMARY KEY (id);


--
-- TOC entry 1975 (class 2606 OID 17799)
-- Name: param_pk; Type: CONSTRAINT; Schema: public; Owner: io; Tablespace: 
--

ALTER TABLE ONLY public.param
    ADD CONSTRAINT param_pk PRIMARY KEY (id);


--
-- TOC entry 1981 (class 2606 OID 17801)
-- Name: phunction_pk; Type: CONSTRAINT; Schema: public; Owner: io; Tablespace: 
--

ALTER TABLE ONLY public.phunction
    ADD CONSTRAINT phunction_pk PRIMARY KEY (id);


--
-- TOC entry 1985 (class 2606 OID 17803)
-- Name: script_pk; Type: CONSTRAINT; Schema: public; Owner: io; Tablespace: 
--

ALTER TABLE ONLY public.script
    ADD CONSTRAINT script_pk PRIMARY KEY (id);


--
-- TOC entry 1988 (class 2606 OID 17805)
-- Name: sentence_pk; Type: CONSTRAINT; Schema: public; Owner: io; Tablespace: 
--

ALTER TABLE ONLY public.sentence
    ADD CONSTRAINT sentence_pk PRIMARY KEY (id);


--
-- TOC entry 1992 (class 2606 OID 17807)
-- Name: synaps_pk; Type: CONSTRAINT; Schema: public; Owner: io; Tablespace: 
--

ALTER TABLE ONLY public.synaps
    ADD CONSTRAINT synaps_pk PRIMARY KEY (id);


--
-- TOC entry 1997 (class 2606 OID 17809)
-- Name: task_pk; Type: CONSTRAINT; Schema: public; Owner: io; Tablespace: 
--

ALTER TABLE ONLY public.task
    ADD CONSTRAINT task_pk PRIMARY KEY (id);


--
-- TOC entry 1999 (class 2606 OID 17811)
-- Name: word_pk; Type: CONSTRAINT; Schema: public; Owner: io; Tablespace: 
--

ALTER TABLE ONLY public.word
    ADD CONSTRAINT word_pk PRIMARY KEY (id);


--
-- TOC entry 2003 (class 2606 OID 17813)
-- Name: word_sequence_pk; Type: CONSTRAINT; Schema: public; Owner: io; Tablespace: 
--

ALTER TABLE ONLY public.word_sequence
    ADD CONSTRAINT word_sequence_pk PRIMARY KEY (id);


--
-- TOC entry 2009 (class 2606 OID 17815)
-- Name: word_tag_pk; Type: CONSTRAINT; Schema: public; Owner: io; Tablespace: 
--

ALTER TABLE ONLY public.word_tag
    ADD CONSTRAINT word_tag_pk PRIMARY KEY (id);


--
-- TOC entry 1953 (class 1259 OID 17816)
-- Name: action_letter; Type: INDEX; Schema: public; Owner: io; Tablespace: 
--

CREATE INDEX action_letter ON public.action USING btree (letter);


--
-- TOC entry 1954 (class 1259 OID 17817)
-- Name: action_phunction; Type: INDEX; Schema: public; Owner: io; Tablespace: 
--

CREATE INDEX action_phunction ON public.action USING btree (phunction);


--
-- TOC entry 1959 (class 1259 OID 17818)
-- Name: ai_word_id; Type: INDEX; Schema: public; Owner: io; Tablespace: 
--

CREATE INDEX ai_word_id ON public.ai USING btree (word);


--
-- TOC entry 1966 (class 1259 OID 17819)
-- Name: interest_index; Type: INDEX; Schema: public; Owner: io; Tablespace: 
--

CREATE INDEX interest_index ON public.neuron USING btree (interest);


--
-- TOC entry 1967 (class 1259 OID 17820)
-- Name: neuron_ai; Type: INDEX; Schema: public; Owner: io; Tablespace: 
--

CREATE INDEX neuron_ai ON public.neuron USING btree (ai);


--
-- TOC entry 1968 (class 1259 OID 17821)
-- Name: neuron_object; Type: INDEX; Schema: public; Owner: io; Tablespace: 
--

CREATE INDEX neuron_object ON public.neuron USING btree (object);


--
-- TOC entry 1976 (class 1259 OID 17822)
-- Name: parent_index; Type: INDEX; Schema: public; Owner: io; Tablespace: 
--

CREATE INDEX parent_index ON public.param USING btree (parent);


--
-- TOC entry 1978 (class 1259 OID 17823)
-- Name: phunction_action; Type: INDEX; Schema: public; Owner: io; Tablespace: 
--

CREATE INDEX phunction_action ON public.phunction USING btree (action);


--
-- TOC entry 1979 (class 1259 OID 17824)
-- Name: phunction_api; Type: INDEX; Schema: public; Owner: io; Tablespace: 
--

CREATE INDEX phunction_api ON public.phunction USING btree (api);


--
-- TOC entry 1971 (class 1259 OID 17825)
-- Name: satisfaction_index; Type: INDEX; Schema: public; Owner: io; Tablespace: 
--

CREATE INDEX satisfaction_index ON public.neuron USING btree (satisfaction);


--
-- TOC entry 1977 (class 1259 OID 17826)
-- Name: script_index; Type: INDEX; Schema: public; Owner: io; Tablespace: 
--

CREATE INDEX script_index ON public.param USING btree (script);


--
-- TOC entry 1982 (class 1259 OID 17827)
-- Name: script_object_id; Type: INDEX; Schema: public; Owner: io; Tablespace: 
--

CREATE INDEX script_object_id ON public.script USING btree (action);


--
-- TOC entry 1983 (class 1259 OID 17828)
-- Name: script_parent_id; Type: INDEX; Schema: public; Owner: io; Tablespace: 
--

CREATE INDEX script_parent_id ON public.script USING btree (parent);


--
-- TOC entry 1986 (class 1259 OID 17829)
-- Name: script_position; Type: INDEX; Schema: public; Owner: io; Tablespace: 
--

CREATE INDEX script_position ON public.script USING btree ("position");


--
-- TOC entry 1989 (class 1259 OID 17830)
-- Name: synaps_a; Type: INDEX; Schema: public; Owner: io; Tablespace: 
--

CREATE INDEX synaps_a ON public.synaps USING btree (a);


--
-- TOC entry 1990 (class 1259 OID 17831)
-- Name: synaps_b; Type: INDEX; Schema: public; Owner: io; Tablespace: 
--

CREATE INDEX synaps_b ON public.synaps USING btree (b);


--
-- TOC entry 1993 (class 1259 OID 17832)
-- Name: synaps_relation; Type: INDEX; Schema: public; Owner: io; Tablespace: 
--

CREATE INDEX synaps_relation ON public.synaps USING btree (relation);


--
-- TOC entry 1994 (class 1259 OID 17833)
-- Name: synaps_strength; Type: INDEX; Schema: public; Owner: io; Tablespace: 
--

CREATE INDEX synaps_strength ON public.synaps USING btree (strength);


--
-- TOC entry 1995 (class 1259 OID 17834)
-- Name: synaps_when; Type: INDEX; Schema: public; Owner: io; Tablespace: 
--

CREATE INDEX synaps_when ON public.synaps USING btree ("when");


--
-- TOC entry 2001 (class 1259 OID 17835)
-- Name: word_sequence_parent_id; Type: INDEX; Schema: public; Owner: io; Tablespace: 
--

CREATE INDEX word_sequence_parent_id ON public.word_sequence USING btree (parent);


--
-- TOC entry 2004 (class 1259 OID 17836)
-- Name: word_sequence_position; Type: INDEX; Schema: public; Owner: io; Tablespace: 
--

CREATE INDEX word_sequence_position ON public.word_sequence USING btree ("position");


--
-- TOC entry 2005 (class 1259 OID 17837)
-- Name: word_sequence_sentence_id; Type: INDEX; Schema: public; Owner: io; Tablespace: 
--

CREATE INDEX word_sequence_sentence_id ON public.word_sequence USING btree (sentence);


--
-- TOC entry 2006 (class 1259 OID 17838)
-- Name: word_sequence_word_id; Type: INDEX; Schema: public; Owner: io; Tablespace: 
--

CREATE INDEX word_sequence_word_id ON public.word_sequence USING btree (word);


--
-- TOC entry 2007 (class 1259 OID 17839)
-- Name: word_sequence_word_tag_id; Type: INDEX; Schema: public; Owner: io; Tablespace: 
--

CREATE INDEX word_sequence_word_tag_id ON public.word_sequence USING btree (word_tag);


--
-- TOC entry 2010 (class 1259 OID 17840)
-- Name: word_tag_word; Type: INDEX; Schema: public; Owner: io; Tablespace: 
--

CREATE INDEX word_tag_word ON public.word_tag USING btree (word);


--
-- TOC entry 2000 (class 1259 OID 17841)
-- Name: word_value; Type: INDEX; Schema: public; Owner: io; Tablespace: 
--

CREATE INDEX word_value ON public.word USING btree (value);


--
-- TOC entry 2125 (class 0 OID 0)
-- Dependencies: 7
-- Name: SCHEMA public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


-- Completed on 2018-07-30 11:16:37

--
-- PostgreSQL database dump complete
--