· 8 years ago · Aug 17, 2018, 10:26 AM
1--
2-- PostgreSQL database dump
3--
4
5-- Dumped from database version 9.3.22
6-- Dumped by pg_dump version 9.3.22
7-- Started on 2018-07-30 11:16:37
8
9SET statement_timeout = 0;
10SET lock_timeout = 0;
11SET client_encoding = 'UTF8';
12SET standard_conforming_strings = on;
13SELECT pg_catalog.set_config('search_path', '', false);
14SET check_function_bodies = false;
15SET client_min_messages = warning;
16
17--
18-- TOC entry 1 (class 3079 OID 11750)
19-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
20--
21
22CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
23
24
25--
26-- TOC entry 2126 (class 0 OID 0)
27-- Dependencies: 1
28-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
29--
30
31COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
32
33
34--
35-- TOC entry 548 (class 1247 OID 17637)
36-- Name: param_type; Type: TYPE; Schema: public; Owner: io
37--
38
39CREATE TYPE public.param_type AS ENUM (
40 'string',
41 'number',
42 'boolean',
43 'memory',
44 'result',
45 'object',
46 'params'
47);
48
49
50ALTER TYPE public.param_type OWNER TO io;
51
52SET default_tablespace = '';
53
54SET default_with_oids = false;
55
56--
57-- TOC entry 171 (class 1259 OID 17651)
58-- Name: action; Type: TABLE; Schema: public; Owner: io; Tablespace:
59--
60
61CREATE TABLE public.action (
62 id integer NOT NULL,
63 phunction integer,
64 letter integer,
65 save character varying
66)
67WITH (autovacuum_enabled='true');
68
69
70ALTER TABLE public.action OWNER TO io;
71
72--
73-- TOC entry 2127 (class 0 OID 0)
74-- Dependencies: 171
75-- Name: COLUMN action.save; Type: COMMENT; Schema: public; Owner: io
76--
77
78COMMENT ON COLUMN public.action.save IS 'save as';
79
80
81--
82-- TOC entry 172 (class 1259 OID 17657)
83-- Name: action_id_seq; Type: SEQUENCE; Schema: public; Owner: io
84--
85
86CREATE SEQUENCE public.action_id_seq
87 START WITH 1
88 INCREMENT BY 1
89 NO MINVALUE
90 NO MAXVALUE
91 CACHE 1;
92
93
94ALTER TABLE public.action_id_seq OWNER TO io;
95
96--
97-- TOC entry 2128 (class 0 OID 0)
98-- Dependencies: 172
99-- Name: action_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: io
100--
101
102ALTER SEQUENCE public.action_id_seq OWNED BY public.action.id;
103
104
105--
106-- TOC entry 173 (class 1259 OID 17659)
107-- Name: ai; Type: TABLE; Schema: public; Owner: io; Tablespace:
108--
109
110CREATE TABLE public.ai (
111 id integer NOT NULL,
112 word integer NOT NULL
113)
114WITH (autovacuum_enabled='true');
115
116
117ALTER TABLE public.ai OWNER TO io;
118
119--
120-- TOC entry 174 (class 1259 OID 17662)
121-- Name: ai_id_seq; Type: SEQUENCE; Schema: public; Owner: io
122--
123
124CREATE SEQUENCE public.ai_id_seq
125 START WITH 1
126 INCREMENT BY 1
127 MINVALUE 0
128 NO MAXVALUE
129 CACHE 1;
130
131
132ALTER TABLE public.ai_id_seq OWNER TO io;
133
134--
135-- TOC entry 2129 (class 0 OID 0)
136-- Dependencies: 174
137-- Name: ai_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: io
138--
139
140ALTER SEQUENCE public.ai_id_seq OWNED BY public.ai.id;
141
142
143--
144-- TOC entry 175 (class 1259 OID 17664)
145-- Name: beat; Type: TABLE; Schema: public; Owner: io; Tablespace:
146--
147
148CREATE TABLE public.beat (
149 id integer NOT NULL,
150 script integer NOT NULL,
151 params character varying,
152 "interval" integer DEFAULT 1000 NOT NULL
153);
154
155
156ALTER TABLE public.beat OWNER TO io;
157
158--
159-- TOC entry 176 (class 1259 OID 17671)
160-- Name: beat_id_seq; Type: SEQUENCE; Schema: public; Owner: io
161--
162
163CREATE SEQUENCE public.beat_id_seq
164 START WITH 1
165 INCREMENT BY 1
166 NO MINVALUE
167 NO MAXVALUE
168 CACHE 1;
169
170
171ALTER TABLE public.beat_id_seq OWNER TO io;
172
173--
174-- TOC entry 2130 (class 0 OID 0)
175-- Dependencies: 176
176-- Name: beat_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: io
177--
178
179ALTER SEQUENCE public.beat_id_seq OWNED BY public.beat.id;
180
181
182--
183-- TOC entry 177 (class 1259 OID 17673)
184-- Name: conversation; Type: TABLE; Schema: public; Owner: io; Tablespace:
185--
186
187CREATE TABLE public.conversation (
188 id integer NOT NULL,
189 parent integer DEFAULT 0 NOT NULL,
190 letter integer NOT NULL,
191 person integer NOT NULL,
192 "timestamp" timestamp with time zone
193);
194
195
196ALTER TABLE public.conversation OWNER TO io;
197
198--
199-- TOC entry 178 (class 1259 OID 17677)
200-- Name: conversation_id_seq; Type: SEQUENCE; Schema: public; Owner: io
201--
202
203CREATE SEQUENCE public.conversation_id_seq
204 START WITH 1
205 INCREMENT BY 1
206 NO MINVALUE
207 NO MAXVALUE
208 CACHE 1;
209
210
211ALTER TABLE public.conversation_id_seq OWNER TO io;
212
213--
214-- TOC entry 2131 (class 0 OID 0)
215-- Dependencies: 178
216-- Name: conversation_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: io
217--
218
219ALTER SEQUENCE public.conversation_id_seq OWNED BY public.conversation.id;
220
221
222--
223-- TOC entry 179 (class 1259 OID 17679)
224-- Name: letter; Type: TABLE; Schema: public; Owner: io; Tablespace:
225--
226
227CREATE TABLE public.letter (
228 id integer NOT NULL,
229 value text
230)
231WITH (autovacuum_enabled='true');
232
233
234ALTER TABLE public.letter OWNER TO io;
235
236--
237-- TOC entry 180 (class 1259 OID 17685)
238-- Name: letter_id_seq; Type: SEQUENCE; Schema: public; Owner: io
239--
240
241CREATE SEQUENCE public.letter_id_seq
242 START WITH 1
243 INCREMENT BY 1
244 NO MINVALUE
245 NO MAXVALUE
246 CACHE 1;
247
248
249ALTER TABLE public.letter_id_seq OWNER TO io;
250
251--
252-- TOC entry 2132 (class 0 OID 0)
253-- Dependencies: 180
254-- Name: letter_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: io
255--
256
257ALTER SEQUENCE public.letter_id_seq OWNED BY public.letter.id;
258
259
260--
261-- TOC entry 181 (class 1259 OID 17687)
262-- Name: neuron; Type: TABLE; Schema: public; Owner: io; Tablespace:
263--
264
265CREATE TABLE public.neuron (
266 id integer NOT NULL,
267 ai integer,
268 object integer,
269 interest integer,
270 satisfaction integer
271)
272WITH (autovacuum_enabled='true');
273
274
275ALTER TABLE public.neuron OWNER TO io;
276
277--
278-- TOC entry 182 (class 1259 OID 17690)
279-- Name: neuron_id_seq; Type: SEQUENCE; Schema: public; Owner: io
280--
281
282CREATE SEQUENCE public.neuron_id_seq
283 START WITH 1
284 INCREMENT BY 1
285 MINVALUE 0
286 NO MAXVALUE
287 CACHE 1;
288
289
290ALTER TABLE public.neuron_id_seq OWNER TO io;
291
292--
293-- TOC entry 2133 (class 0 OID 0)
294-- Dependencies: 182
295-- Name: neuron_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: io
296--
297
298ALTER SEQUENCE public.neuron_id_seq OWNED BY public.neuron.id;
299
300
301--
302-- TOC entry 183 (class 1259 OID 17692)
303-- Name: nlp; Type: TABLE; Schema: public; Owner: io; Tablespace:
304--
305
306CREATE TABLE public.nlp (
307 id integer NOT NULL,
308 value text
309)
310WITH (autovacuum_enabled='true');
311
312
313ALTER TABLE public.nlp OWNER TO io;
314
315--
316-- TOC entry 184 (class 1259 OID 17698)
317-- Name: nlp_id_seq; Type: SEQUENCE; Schema: public; Owner: io
318--
319
320CREATE SEQUENCE public.nlp_id_seq
321 START WITH 1
322 INCREMENT BY 1
323 NO MINVALUE
324 NO MAXVALUE
325 CACHE 1;
326
327
328ALTER TABLE public.nlp_id_seq OWNER TO io;
329
330--
331-- TOC entry 2134 (class 0 OID 0)
332-- Dependencies: 184
333-- Name: nlp_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: io
334--
335
336ALTER SEQUENCE public.nlp_id_seq OWNED BY public.nlp.id;
337
338
339--
340-- TOC entry 185 (class 1259 OID 17700)
341-- Name: param; Type: TABLE; Schema: public; Owner: io; Tablespace:
342--
343
344CREATE TABLE public.param (
345 id integer NOT NULL,
346 script integer NOT NULL,
347 name character varying NOT NULL,
348 value character varying NOT NULL,
349 type public.param_type NOT NULL,
350 parent integer
351)
352WITH (autovacuum_enabled='true');
353
354
355ALTER TABLE public.param OWNER TO io;
356
357--
358-- TOC entry 186 (class 1259 OID 17706)
359-- Name: param_id_seq; Type: SEQUENCE; Schema: public; Owner: io
360--
361
362CREATE SEQUENCE public.param_id_seq
363 START WITH 1
364 INCREMENT BY 1
365 NO MINVALUE
366 NO MAXVALUE
367 CACHE 1;
368
369
370ALTER TABLE public.param_id_seq OWNER TO io;
371
372--
373-- TOC entry 2135 (class 0 OID 0)
374-- Dependencies: 186
375-- Name: param_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: io
376--
377
378ALTER SEQUENCE public.param_id_seq OWNED BY public.param.id;
379
380
381--
382-- TOC entry 187 (class 1259 OID 17708)
383-- Name: phunction; Type: TABLE; Schema: public; Owner: io; Tablespace:
384--
385
386CREATE TABLE public.phunction (
387 id integer NOT NULL,
388 api character varying NOT NULL,
389 action character varying
390)
391WITH (autovacuum_enabled='true');
392
393
394ALTER TABLE public.phunction OWNER TO io;
395
396--
397-- TOC entry 188 (class 1259 OID 17714)
398-- Name: phunction_id_seq; Type: SEQUENCE; Schema: public; Owner: io
399--
400
401CREATE SEQUENCE public.phunction_id_seq
402 START WITH 1
403 INCREMENT BY 1
404 NO MINVALUE
405 NO MAXVALUE
406 CACHE 1;
407
408
409ALTER TABLE public.phunction_id_seq OWNER TO io;
410
411--
412-- TOC entry 2136 (class 0 OID 0)
413-- Dependencies: 188
414-- Name: phunction_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: io
415--
416
417ALTER SEQUENCE public.phunction_id_seq OWNED BY public.phunction.id;
418
419
420--
421-- TOC entry 189 (class 1259 OID 17716)
422-- Name: script; Type: TABLE; Schema: public; Owner: io; Tablespace:
423--
424
425CREATE TABLE public.script (
426 id integer NOT NULL,
427 parent integer DEFAULT 0,
428 action integer DEFAULT 0 NOT NULL,
429 "position" integer DEFAULT 1 NOT NULL,
430 "timestamp" timestamp without time zone DEFAULT statement_timestamp()
431)
432WITH (autovacuum_enabled='true');
433
434
435ALTER TABLE public.script OWNER TO io;
436
437--
438-- TOC entry 190 (class 1259 OID 17723)
439-- Name: script_id_seq; Type: SEQUENCE; Schema: public; Owner: io
440--
441
442CREATE SEQUENCE public.script_id_seq
443 START WITH 1
444 INCREMENT BY 1
445 NO MINVALUE
446 NO MAXVALUE
447 CACHE 1;
448
449
450ALTER TABLE public.script_id_seq OWNER TO io;
451
452--
453-- TOC entry 2137 (class 0 OID 0)
454-- Dependencies: 190
455-- Name: script_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: io
456--
457
458ALTER SEQUENCE public.script_id_seq OWNED BY public.script.id;
459
460
461--
462-- TOC entry 191 (class 1259 OID 17725)
463-- Name: sentence; Type: TABLE; Schema: public; Owner: io; Tablespace:
464--
465
466CREATE TABLE public.sentence (
467 id integer NOT NULL,
468 word integer DEFAULT 0 NOT NULL,
469 letter integer NOT NULL
470)
471WITH (autovacuum_enabled='true');
472
473
474ALTER TABLE public.sentence OWNER TO io;
475
476--
477-- TOC entry 192 (class 1259 OID 17729)
478-- Name: sentence_id_seq; Type: SEQUENCE; Schema: public; Owner: io
479--
480
481CREATE SEQUENCE public.sentence_id_seq
482 START WITH 1
483 INCREMENT BY 1
484 NO MINVALUE
485 NO MAXVALUE
486 CACHE 1;
487
488
489ALTER TABLE public.sentence_id_seq OWNER TO io;
490
491--
492-- TOC entry 2138 (class 0 OID 0)
493-- Dependencies: 192
494-- Name: sentence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: io
495--
496
497ALTER SEQUENCE public.sentence_id_seq OWNED BY public.sentence.id;
498
499
500--
501-- TOC entry 193 (class 1259 OID 17731)
502-- Name: synaps; Type: TABLE; Schema: public; Owner: io; Tablespace:
503--
504
505CREATE TABLE public.synaps (
506 id integer NOT NULL,
507 a integer,
508 b integer,
509 "when" timestamp without time zone DEFAULT now(),
510 strength smallint,
511 relation integer
512)
513WITH (autovacuum_enabled='true');
514
515
516ALTER TABLE public.synaps OWNER TO io;
517
518--
519-- TOC entry 194 (class 1259 OID 17735)
520-- Name: synaps_id_seq; Type: SEQUENCE; Schema: public; Owner: io
521--
522
523CREATE SEQUENCE public.synaps_id_seq
524 START WITH 1
525 INCREMENT BY 1
526 MINVALUE 0
527 NO MAXVALUE
528 CACHE 1;
529
530
531ALTER TABLE public.synaps_id_seq OWNER TO io;
532
533--
534-- TOC entry 2139 (class 0 OID 0)
535-- Dependencies: 194
536-- Name: synaps_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: io
537--
538
539ALTER SEQUENCE public.synaps_id_seq OWNED BY public.synaps.id;
540
541
542--
543-- TOC entry 195 (class 1259 OID 17737)
544-- Name: task; Type: TABLE; Schema: public; Owner: io; Tablespace:
545--
546
547CREATE TABLE public.task (
548 id integer NOT NULL,
549 script integer,
550 params character varying,
551 status smallint,
552 priority integer,
553 due timestamp without time zone DEFAULT now(),
554 chore smallint DEFAULT 0
555);
556
557
558ALTER TABLE public.task OWNER TO io;
559
560--
561-- TOC entry 196 (class 1259 OID 17745)
562-- Name: task_id_seq; Type: SEQUENCE; Schema: public; Owner: io
563--
564
565CREATE SEQUENCE public.task_id_seq
566 START WITH 1
567 INCREMENT BY 1
568 NO MINVALUE
569 NO MAXVALUE
570 CACHE 1;
571
572
573ALTER TABLE public.task_id_seq OWNER TO io;
574
575--
576-- TOC entry 2140 (class 0 OID 0)
577-- Dependencies: 196
578-- Name: task_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: io
579--
580
581ALTER SEQUENCE public.task_id_seq OWNED BY public.task.id;
582
583
584--
585-- TOC entry 197 (class 1259 OID 17747)
586-- Name: word; Type: TABLE; Schema: public; Owner: io; Tablespace:
587--
588
589CREATE TABLE public.word (
590 id integer NOT NULL,
591 value character varying
592)
593WITH (autovacuum_enabled='true');
594
595
596ALTER TABLE public.word OWNER TO io;
597
598--
599-- TOC entry 198 (class 1259 OID 17753)
600-- Name: word_id_seq; Type: SEQUENCE; Schema: public; Owner: io
601--
602
603CREATE SEQUENCE public.word_id_seq
604 START WITH 1
605 INCREMENT BY 1
606 MINVALUE 0
607 NO MAXVALUE
608 CACHE 1;
609
610
611ALTER TABLE public.word_id_seq OWNER TO io;
612
613--
614-- TOC entry 2141 (class 0 OID 0)
615-- Dependencies: 198
616-- Name: word_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: io
617--
618
619ALTER SEQUENCE public.word_id_seq OWNED BY public.word.id;
620
621
622--
623-- TOC entry 199 (class 1259 OID 17755)
624-- Name: word_sequence; Type: TABLE; Schema: public; Owner: io; Tablespace:
625--
626
627CREATE TABLE public.word_sequence (
628 id integer NOT NULL,
629 word integer NOT NULL,
630 sentence integer NOT NULL,
631 "position" integer DEFAULT 1 NOT NULL,
632 word_tag integer DEFAULT 0,
633 parent integer DEFAULT 0 NOT NULL
634)
635WITH (autovacuum_enabled='true');
636
637
638ALTER TABLE public.word_sequence OWNER TO io;
639
640--
641-- TOC entry 200 (class 1259 OID 17761)
642-- Name: word_sequence_id_seq; Type: SEQUENCE; Schema: public; Owner: io
643--
644
645CREATE SEQUENCE public.word_sequence_id_seq
646 START WITH 1
647 INCREMENT BY 1
648 NO MINVALUE
649 NO MAXVALUE
650 CACHE 1;
651
652
653ALTER TABLE public.word_sequence_id_seq OWNER TO io;
654
655--
656-- TOC entry 2142 (class 0 OID 0)
657-- Dependencies: 200
658-- Name: word_sequence_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: io
659--
660
661ALTER SEQUENCE public.word_sequence_id_seq OWNED BY public.word_sequence.id;
662
663
664--
665-- TOC entry 201 (class 1259 OID 17763)
666-- Name: word_tag; Type: TABLE; Schema: public; Owner: io; Tablespace:
667--
668
669CREATE TABLE public.word_tag (
670 id integer NOT NULL,
671 word integer
672)
673WITH (autovacuum_enabled='true');
674
675
676ALTER TABLE public.word_tag OWNER TO io;
677
678--
679-- TOC entry 202 (class 1259 OID 17766)
680-- Name: word_tag_id_seq; Type: SEQUENCE; Schema: public; Owner: io
681--
682
683CREATE SEQUENCE public.word_tag_id_seq
684 START WITH 1
685 INCREMENT BY 1
686 NO MINVALUE
687 NO MAXVALUE
688 CACHE 1;
689
690
691ALTER TABLE public.word_tag_id_seq OWNER TO io;
692
693--
694-- TOC entry 2143 (class 0 OID 0)
695-- Dependencies: 202
696-- Name: word_tag_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: io
697--
698
699ALTER SEQUENCE public.word_tag_id_seq OWNED BY public.word_tag.id;
700
701
702--
703-- TOC entry 1924 (class 2604 OID 17768)
704-- Name: id; Type: DEFAULT; Schema: public; Owner: io
705--
706
707ALTER TABLE ONLY public.action ALTER COLUMN id SET DEFAULT nextval('public.action_id_seq'::regclass);
708
709
710--
711-- TOC entry 1925 (class 2604 OID 17769)
712-- Name: id; Type: DEFAULT; Schema: public; Owner: io
713--
714
715ALTER TABLE ONLY public.ai ALTER COLUMN id SET DEFAULT nextval('public.ai_id_seq'::regclass);
716
717
718--
719-- TOC entry 1927 (class 2604 OID 17770)
720-- Name: id; Type: DEFAULT; Schema: public; Owner: io
721--
722
723ALTER TABLE ONLY public.beat ALTER COLUMN id SET DEFAULT nextval('public.beat_id_seq'::regclass);
724
725
726--
727-- TOC entry 1929 (class 2604 OID 17771)
728-- Name: id; Type: DEFAULT; Schema: public; Owner: io
729--
730
731ALTER TABLE ONLY public.conversation ALTER COLUMN id SET DEFAULT nextval('public.conversation_id_seq'::regclass);
732
733
734--
735-- TOC entry 1930 (class 2604 OID 17772)
736-- Name: id; Type: DEFAULT; Schema: public; Owner: io
737--
738
739ALTER TABLE ONLY public.letter ALTER COLUMN id SET DEFAULT nextval('public.letter_id_seq'::regclass);
740
741
742--
743-- TOC entry 1931 (class 2604 OID 17773)
744-- Name: id; Type: DEFAULT; Schema: public; Owner: io
745--
746
747ALTER TABLE ONLY public.neuron ALTER COLUMN id SET DEFAULT nextval('public.neuron_id_seq'::regclass);
748
749
750--
751-- TOC entry 1932 (class 2604 OID 17774)
752-- Name: id; Type: DEFAULT; Schema: public; Owner: io
753--
754
755ALTER TABLE ONLY public.nlp ALTER COLUMN id SET DEFAULT nextval('public.nlp_id_seq'::regclass);
756
757
758--
759-- TOC entry 1933 (class 2604 OID 17775)
760-- Name: id; Type: DEFAULT; Schema: public; Owner: io
761--
762
763ALTER TABLE ONLY public.param ALTER COLUMN id SET DEFAULT nextval('public.param_id_seq'::regclass);
764
765
766--
767-- TOC entry 1934 (class 2604 OID 17776)
768-- Name: id; Type: DEFAULT; Schema: public; Owner: io
769--
770
771ALTER TABLE ONLY public.phunction ALTER COLUMN id SET DEFAULT nextval('public.phunction_id_seq'::regclass);
772
773
774--
775-- TOC entry 1939 (class 2604 OID 17777)
776-- Name: id; Type: DEFAULT; Schema: public; Owner: io
777--
778
779ALTER TABLE ONLY public.script ALTER COLUMN id SET DEFAULT nextval('public.script_id_seq'::regclass);
780
781
782--
783-- TOC entry 1941 (class 2604 OID 17778)
784-- Name: id; Type: DEFAULT; Schema: public; Owner: io
785--
786
787ALTER TABLE ONLY public.sentence ALTER COLUMN id SET DEFAULT nextval('public.sentence_id_seq'::regclass);
788
789
790--
791-- TOC entry 1943 (class 2604 OID 17779)
792-- Name: id; Type: DEFAULT; Schema: public; Owner: io
793--
794
795ALTER TABLE ONLY public.synaps ALTER COLUMN id SET DEFAULT nextval('public.synaps_id_seq'::regclass);
796
797
798--
799-- TOC entry 1946 (class 2604 OID 17780)
800-- Name: id; Type: DEFAULT; Schema: public; Owner: io
801--
802
803ALTER TABLE ONLY public.task ALTER COLUMN id SET DEFAULT nextval('public.task_id_seq'::regclass);
804
805
806--
807-- TOC entry 1947 (class 2604 OID 17781)
808-- Name: id; Type: DEFAULT; Schema: public; Owner: io
809--
810
811ALTER TABLE ONLY public.word ALTER COLUMN id SET DEFAULT nextval('public.word_id_seq'::regclass);
812
813
814--
815-- TOC entry 1951 (class 2604 OID 17782)
816-- Name: id; Type: DEFAULT; Schema: public; Owner: io
817--
818
819ALTER TABLE ONLY public.word_sequence ALTER COLUMN id SET DEFAULT nextval('public.word_sequence_id_seq'::regclass);
820
821
822--
823-- TOC entry 1952 (class 2604 OID 17783)
824-- Name: id; Type: DEFAULT; Schema: public; Owner: io
825--
826
827ALTER TABLE ONLY public.word_tag ALTER COLUMN id SET DEFAULT nextval('public.word_tag_id_seq'::regclass);
828
829
830--
831-- TOC entry 1956 (class 2606 OID 17785)
832-- Name: action_pk; Type: CONSTRAINT; Schema: public; Owner: io; Tablespace:
833--
834
835ALTER TABLE ONLY public.action
836 ADD CONSTRAINT action_pk PRIMARY KEY (id);
837
838
839--
840-- TOC entry 1958 (class 2606 OID 17787)
841-- Name: ai_pk; Type: CONSTRAINT; Schema: public; Owner: io; Tablespace:
842--
843
844ALTER TABLE ONLY public.ai
845 ADD CONSTRAINT ai_pk PRIMARY KEY (id);
846
847
848--
849-- TOC entry 1961 (class 2606 OID 17789)
850-- Name: beat_pk; Type: CONSTRAINT; Schema: public; Owner: io; Tablespace:
851--
852
853ALTER TABLE ONLY public.beat
854 ADD CONSTRAINT beat_pk PRIMARY KEY (id);
855
856
857--
858-- TOC entry 1963 (class 2606 OID 17791)
859-- Name: conversation_pk; Type: CONSTRAINT; Schema: public; Owner: io; Tablespace:
860--
861
862ALTER TABLE ONLY public.conversation
863 ADD CONSTRAINT conversation_pk PRIMARY KEY (id);
864
865
866--
867-- TOC entry 1965 (class 2606 OID 17793)
868-- Name: letter_pk; Type: CONSTRAINT; Schema: public; Owner: io; Tablespace:
869--
870
871ALTER TABLE ONLY public.letter
872 ADD CONSTRAINT letter_pk PRIMARY KEY (id);
873
874
875--
876-- TOC entry 1970 (class 2606 OID 17795)
877-- Name: neuron_pk; Type: CONSTRAINT; Schema: public; Owner: io; Tablespace:
878--
879
880ALTER TABLE ONLY public.neuron
881 ADD CONSTRAINT neuron_pk PRIMARY KEY (id);
882
883
884--
885-- TOC entry 1973 (class 2606 OID 17797)
886-- Name: nlp_pk; Type: CONSTRAINT; Schema: public; Owner: io; Tablespace:
887--
888
889ALTER TABLE ONLY public.nlp
890 ADD CONSTRAINT nlp_pk PRIMARY KEY (id);
891
892
893--
894-- TOC entry 1975 (class 2606 OID 17799)
895-- Name: param_pk; Type: CONSTRAINT; Schema: public; Owner: io; Tablespace:
896--
897
898ALTER TABLE ONLY public.param
899 ADD CONSTRAINT param_pk PRIMARY KEY (id);
900
901
902--
903-- TOC entry 1981 (class 2606 OID 17801)
904-- Name: phunction_pk; Type: CONSTRAINT; Schema: public; Owner: io; Tablespace:
905--
906
907ALTER TABLE ONLY public.phunction
908 ADD CONSTRAINT phunction_pk PRIMARY KEY (id);
909
910
911--
912-- TOC entry 1985 (class 2606 OID 17803)
913-- Name: script_pk; Type: CONSTRAINT; Schema: public; Owner: io; Tablespace:
914--
915
916ALTER TABLE ONLY public.script
917 ADD CONSTRAINT script_pk PRIMARY KEY (id);
918
919
920--
921-- TOC entry 1988 (class 2606 OID 17805)
922-- Name: sentence_pk; Type: CONSTRAINT; Schema: public; Owner: io; Tablespace:
923--
924
925ALTER TABLE ONLY public.sentence
926 ADD CONSTRAINT sentence_pk PRIMARY KEY (id);
927
928
929--
930-- TOC entry 1992 (class 2606 OID 17807)
931-- Name: synaps_pk; Type: CONSTRAINT; Schema: public; Owner: io; Tablespace:
932--
933
934ALTER TABLE ONLY public.synaps
935 ADD CONSTRAINT synaps_pk PRIMARY KEY (id);
936
937
938--
939-- TOC entry 1997 (class 2606 OID 17809)
940-- Name: task_pk; Type: CONSTRAINT; Schema: public; Owner: io; Tablespace:
941--
942
943ALTER TABLE ONLY public.task
944 ADD CONSTRAINT task_pk PRIMARY KEY (id);
945
946
947--
948-- TOC entry 1999 (class 2606 OID 17811)
949-- Name: word_pk; Type: CONSTRAINT; Schema: public; Owner: io; Tablespace:
950--
951
952ALTER TABLE ONLY public.word
953 ADD CONSTRAINT word_pk PRIMARY KEY (id);
954
955
956--
957-- TOC entry 2003 (class 2606 OID 17813)
958-- Name: word_sequence_pk; Type: CONSTRAINT; Schema: public; Owner: io; Tablespace:
959--
960
961ALTER TABLE ONLY public.word_sequence
962 ADD CONSTRAINT word_sequence_pk PRIMARY KEY (id);
963
964
965--
966-- TOC entry 2009 (class 2606 OID 17815)
967-- Name: word_tag_pk; Type: CONSTRAINT; Schema: public; Owner: io; Tablespace:
968--
969
970ALTER TABLE ONLY public.word_tag
971 ADD CONSTRAINT word_tag_pk PRIMARY KEY (id);
972
973
974--
975-- TOC entry 1953 (class 1259 OID 17816)
976-- Name: action_letter; Type: INDEX; Schema: public; Owner: io; Tablespace:
977--
978
979CREATE INDEX action_letter ON public.action USING btree (letter);
980
981
982--
983-- TOC entry 1954 (class 1259 OID 17817)
984-- Name: action_phunction; Type: INDEX; Schema: public; Owner: io; Tablespace:
985--
986
987CREATE INDEX action_phunction ON public.action USING btree (phunction);
988
989
990--
991-- TOC entry 1959 (class 1259 OID 17818)
992-- Name: ai_word_id; Type: INDEX; Schema: public; Owner: io; Tablespace:
993--
994
995CREATE INDEX ai_word_id ON public.ai USING btree (word);
996
997
998--
999-- TOC entry 1966 (class 1259 OID 17819)
1000-- Name: interest_index; Type: INDEX; Schema: public; Owner: io; Tablespace:
1001--
1002
1003CREATE INDEX interest_index ON public.neuron USING btree (interest);
1004
1005
1006--
1007-- TOC entry 1967 (class 1259 OID 17820)
1008-- Name: neuron_ai; Type: INDEX; Schema: public; Owner: io; Tablespace:
1009--
1010
1011CREATE INDEX neuron_ai ON public.neuron USING btree (ai);
1012
1013
1014--
1015-- TOC entry 1968 (class 1259 OID 17821)
1016-- Name: neuron_object; Type: INDEX; Schema: public; Owner: io; Tablespace:
1017--
1018
1019CREATE INDEX neuron_object ON public.neuron USING btree (object);
1020
1021
1022--
1023-- TOC entry 1976 (class 1259 OID 17822)
1024-- Name: parent_index; Type: INDEX; Schema: public; Owner: io; Tablespace:
1025--
1026
1027CREATE INDEX parent_index ON public.param USING btree (parent);
1028
1029
1030--
1031-- TOC entry 1978 (class 1259 OID 17823)
1032-- Name: phunction_action; Type: INDEX; Schema: public; Owner: io; Tablespace:
1033--
1034
1035CREATE INDEX phunction_action ON public.phunction USING btree (action);
1036
1037
1038--
1039-- TOC entry 1979 (class 1259 OID 17824)
1040-- Name: phunction_api; Type: INDEX; Schema: public; Owner: io; Tablespace:
1041--
1042
1043CREATE INDEX phunction_api ON public.phunction USING btree (api);
1044
1045
1046--
1047-- TOC entry 1971 (class 1259 OID 17825)
1048-- Name: satisfaction_index; Type: INDEX; Schema: public; Owner: io; Tablespace:
1049--
1050
1051CREATE INDEX satisfaction_index ON public.neuron USING btree (satisfaction);
1052
1053
1054--
1055-- TOC entry 1977 (class 1259 OID 17826)
1056-- Name: script_index; Type: INDEX; Schema: public; Owner: io; Tablespace:
1057--
1058
1059CREATE INDEX script_index ON public.param USING btree (script);
1060
1061
1062--
1063-- TOC entry 1982 (class 1259 OID 17827)
1064-- Name: script_object_id; Type: INDEX; Schema: public; Owner: io; Tablespace:
1065--
1066
1067CREATE INDEX script_object_id ON public.script USING btree (action);
1068
1069
1070--
1071-- TOC entry 1983 (class 1259 OID 17828)
1072-- Name: script_parent_id; Type: INDEX; Schema: public; Owner: io; Tablespace:
1073--
1074
1075CREATE INDEX script_parent_id ON public.script USING btree (parent);
1076
1077
1078--
1079-- TOC entry 1986 (class 1259 OID 17829)
1080-- Name: script_position; Type: INDEX; Schema: public; Owner: io; Tablespace:
1081--
1082
1083CREATE INDEX script_position ON public.script USING btree ("position");
1084
1085
1086--
1087-- TOC entry 1989 (class 1259 OID 17830)
1088-- Name: synaps_a; Type: INDEX; Schema: public; Owner: io; Tablespace:
1089--
1090
1091CREATE INDEX synaps_a ON public.synaps USING btree (a);
1092
1093
1094--
1095-- TOC entry 1990 (class 1259 OID 17831)
1096-- Name: synaps_b; Type: INDEX; Schema: public; Owner: io; Tablespace:
1097--
1098
1099CREATE INDEX synaps_b ON public.synaps USING btree (b);
1100
1101
1102--
1103-- TOC entry 1993 (class 1259 OID 17832)
1104-- Name: synaps_relation; Type: INDEX; Schema: public; Owner: io; Tablespace:
1105--
1106
1107CREATE INDEX synaps_relation ON public.synaps USING btree (relation);
1108
1109
1110--
1111-- TOC entry 1994 (class 1259 OID 17833)
1112-- Name: synaps_strength; Type: INDEX; Schema: public; Owner: io; Tablespace:
1113--
1114
1115CREATE INDEX synaps_strength ON public.synaps USING btree (strength);
1116
1117
1118--
1119-- TOC entry 1995 (class 1259 OID 17834)
1120-- Name: synaps_when; Type: INDEX; Schema: public; Owner: io; Tablespace:
1121--
1122
1123CREATE INDEX synaps_when ON public.synaps USING btree ("when");
1124
1125
1126--
1127-- TOC entry 2001 (class 1259 OID 17835)
1128-- Name: word_sequence_parent_id; Type: INDEX; Schema: public; Owner: io; Tablespace:
1129--
1130
1131CREATE INDEX word_sequence_parent_id ON public.word_sequence USING btree (parent);
1132
1133
1134--
1135-- TOC entry 2004 (class 1259 OID 17836)
1136-- Name: word_sequence_position; Type: INDEX; Schema: public; Owner: io; Tablespace:
1137--
1138
1139CREATE INDEX word_sequence_position ON public.word_sequence USING btree ("position");
1140
1141
1142--
1143-- TOC entry 2005 (class 1259 OID 17837)
1144-- Name: word_sequence_sentence_id; Type: INDEX; Schema: public; Owner: io; Tablespace:
1145--
1146
1147CREATE INDEX word_sequence_sentence_id ON public.word_sequence USING btree (sentence);
1148
1149
1150--
1151-- TOC entry 2006 (class 1259 OID 17838)
1152-- Name: word_sequence_word_id; Type: INDEX; Schema: public; Owner: io; Tablespace:
1153--
1154
1155CREATE INDEX word_sequence_word_id ON public.word_sequence USING btree (word);
1156
1157
1158--
1159-- TOC entry 2007 (class 1259 OID 17839)
1160-- Name: word_sequence_word_tag_id; Type: INDEX; Schema: public; Owner: io; Tablespace:
1161--
1162
1163CREATE INDEX word_sequence_word_tag_id ON public.word_sequence USING btree (word_tag);
1164
1165
1166--
1167-- TOC entry 2010 (class 1259 OID 17840)
1168-- Name: word_tag_word; Type: INDEX; Schema: public; Owner: io; Tablespace:
1169--
1170
1171CREATE INDEX word_tag_word ON public.word_tag USING btree (word);
1172
1173
1174--
1175-- TOC entry 2000 (class 1259 OID 17841)
1176-- Name: word_value; Type: INDEX; Schema: public; Owner: io; Tablespace:
1177--
1178
1179CREATE INDEX word_value ON public.word USING btree (value);
1180
1181
1182--
1183-- TOC entry 2125 (class 0 OID 0)
1184-- Dependencies: 7
1185-- Name: SCHEMA public; Type: ACL; Schema: -; Owner: postgres
1186--
1187
1188REVOKE ALL ON SCHEMA public FROM PUBLIC;
1189REVOKE ALL ON SCHEMA public FROM postgres;
1190GRANT ALL ON SCHEMA public TO postgres;
1191GRANT ALL ON SCHEMA public TO PUBLIC;
1192
1193
1194-- Completed on 2018-07-30 11:16:37
1195
1196--
1197-- PostgreSQL database dump complete
1198--