Created
August 17, 2018 09:19
-
-
Save dispeakble/a12bc394241dc4daa0f61ede64db8c44 to your computer and use it in GitHub Desktop.
ai_db
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- | |
| -- 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 | |
| -- | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment