PGDMP!ysample12.513.2 00ENCODINGENCODINGSET client_encoding = 'UTF8'; false 00 STDSTRINGS STDSTRINGS(SET standard_conforming_strings = 'on'; false00 SEARCHPATH SEARCHPATH8SELECT pg_catalog.set_config('search_path', '', false); false126216401sampleDATABASE[CREATE DATABASE sample WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE = 'en_US.UTF-8'; DROP DATABASE sample; postgresfalse261516402chatbotSCHEMACREATE SCHEMA chatbot; DROP SCHEMA chatbot; postgresfalse00 SCHEMA publicACLREVOKE ALL ON SCHEMA public FROM rdsadmin; REVOKE ALL ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO postgres; GRANT ALL ON SCHEMA public TO PUBLIC; postgresfalse3125916403authorsTABLEYCREATE TABLE chatbot.authors ( author_id integer NOT NULL, name text NOT NULL ); DROP TABLE chatbot.authors; chatbotheappostgresfalse8125916409 post_authorsTABLEdCREATE TABLE chatbot.post_authors ( post_id integer NOT NULL, author_id integer NOT NULL ); !DROP TABLE chatbot.post_authors; chatbotheappostgresfalse8125916412 post_tagsTABLE^CREATE TABLE chatbot.post_tags ( post_id integer NOT NULL, tag_id integer NOT NULL ); DROP TABLE chatbot.post_tags; chatbotheappostgresfalse8125916415postsTABLE|CREATE TABLE chatbot.posts ( post_id integer NOT NULL, url text NOT NULL, title text NOT NULL, date text ); DROP TABLE chatbot.posts; chatbotheappostgresfalse8125916421tagsTABLERCREATE TABLE chatbot.tags ( tag_id integer NOT NULL, tag text NOT NULL ); DROP TABLE chatbot.tags; chatbotheappostgresfalse8016403authors TABLE DATA3COPY chatbot.authors (author_id, name) FROM stdin; chatbotpostgresfalse203016409 post_authors TABLE DATA;COPY chatbot.post_authors (post_id, author_id) FROM stdin; chatbotpostgresfalse204016412 post_tags TABLE DATA5COPY chatbot.post_tags (post_id, tag_id) FROM stdin; chatbotpostgresfalse205 016415posts TABLE DATA;COPY chatbot.posts (post_id, url, title, date) FROM stdin; chatbotpostgresfalse206x! 016421tags TABLE DATA,COPY chatbot.tags (tag_id, tag) FROM stdin; chatbotpostgresfalse207+v260616428authors authors_pkey CONSTRAINTZALTER TABLE ONLY chatbot.authors ADD CONSTRAINT authors_pkey PRIMARY KEY (author_id); ?ALTER TABLE ONLY chatbot.authors DROP CONSTRAINT authors_pkey; chatbotpostgresfalse203z260616430post_authors post_authors_pkey CONSTRAINTmALTER TABLE ONLY chatbot.post_authors ADD CONSTRAINT post_authors_pkey PRIMARY KEY (post_id, author_id); IALTER TABLE ONLY chatbot.post_authors DROP CONSTRAINT post_authors_pkey; chatbotpostgresfalse204204~260616432post_tags post_tags_pkey CONSTRAINTdALTER TABLE ONLY chatbot.post_tags ADD CONSTRAINT post_tags_pkey PRIMARY KEY (tag_id, post_id); CALTER TABLE ONLY chatbot.post_tags DROP CONSTRAINT post_tags_pkey; chatbotpostgresfalse205205260616434posts posts_pkey CONSTRAINTTALTER TABLE ONLY chatbot.posts ADD CONSTRAINT posts_pkey PRIMARY KEY (post_id); ;ALTER TABLE ONLY chatbot.posts DROP CONSTRAINT posts_pkey; chatbotpostgresfalse206260616436tags tags_pkey CONSTRAINTQALTER TABLE ONLY chatbot.tags ADD CONSTRAINT tags_pkey PRIMARY KEY (tag_id); 9ALTER TABLE ONLY chatbot.tags DROP CONSTRAINT tags_pkey; chatbotpostgresfalse207w125916437fki_fk_author_idINDEXOCREATE INDEX fki_fk_author_id ON chatbot.post_authors USING btree (author_id); %DROP INDEX chatbot.fki_fk_author_id; chatbotpostgresfalse204{125916438fki_fk_post_idINDEXHCREATE INDEX fki_fk_post_id ON chatbot.post_tags USING btree (post_id); #DROP INDEX chatbot.fki_fk_post_id; chatbotpostgresfalse205x125916439fki_fk_post_id_1INDEXMCREATE INDEX fki_fk_post_id_1 ON chatbot.post_authors USING btree (post_id); %DROP INDEX chatbot.fki_fk_post_id_1; chatbotpostgresfalse204|125916440 fki_fk_tag_idINDEXFCREATE INDEX fki_fk_tag_id ON chatbot.post_tags USING btree (tag_id); "DROP INDEX chatbot.fki_fk_tag_id; chatbotpostgresfalse205260616441post_authors fk_author_id FK CONSTRAINTALTER TABLE ONLY chatbot.post_authors ADD CONSTRAINT fk_author_id FOREIGN KEY (author_id) REFERENCES chatbot.authors(author_id) NOT VALID; DALTER TABLE ONLY chatbot.post_authors DROP CONSTRAINT fk_author_id; chatbotpostgresfalse3702204203260616446post_tags fk_post_id FK CONSTRAINTALTER TABLE ONLY chatbot.post_tags ADD CONSTRAINT fk_post_id FOREIGN KEY (post_id) REFERENCES chatbot.posts(post_id) NOT VALID; ?ALTER TABLE ONLY chatbot.post_tags DROP CONSTRAINT fk_post_id; chatbotpostgresfalse2063712205260616451post_authors fk_post_id_1 FK CONSTRAINTALTER TABLE ONLY chatbot.post_authors ADD CONSTRAINT fk_post_id_1 FOREIGN KEY (post_id) REFERENCES chatbot.posts(post_id) NOT VALID; DALTER TABLE ONLY chatbot.post_authors DROP CONSTRAINT fk_post_id_1; chatbotpostgresfalse3712204206260616456post_tags fk_tag_id FK CONSTRAINTALTER TABLE ONLY chatbot.post_tags ADD CONSTRAINT fk_tag_id FOREIGN KEY (tag_id) REFERENCES chatbot.tags(tag_id) NOT VALID; >ALTER TABLE ONLY chatbot.post_tags DROP CONSTRAINT fk_tag_id; chatbotpostgresfalse2053714207x5As0ϻbou  eBBH28M^{*#3ί}'Ajwl/g_79^1UTʳJ2潔(z9sb baQA`4@N`{< x5m@1Cf 't9jzA1qqT Oїڭ2,Krws$LxboR$ICVӼÞϲ2O2 (*ř%>4qp\#/8JM>dfnSDZ5:b.x,2SӹJ B.-?"XY*B=A<  tWy0`u/,^7UT!'M=heiREN:m]$/ J/(AI'JY_d U)hqоM_¾dx&nT*FQجΔ:EniG&eI$}ғ=1WNX'+ld ;;O'Zmr}\Y.ҍhY(+1ֱ4+@iSX0W T9o^ :;dhǣ/r_} O2qD[gu]oq.lCѩxgg}_bxuYY.yTUiJ1'%s+L 㣓_E?]LIWcvydzޓ)3ٖU&-6>G_OFZQ=TinE~w-k/9]10R0$w MYUO~&t+˿%yJ %HOjϱ*A΢D $f_MH >ܼ[aՠAʔrpm.f[< #cof%+ٔlo9ULQ՞TL%,^ <35U+ZUp\Gxw׀@pwᇷ0<?PW w[q-+e$A7k g}&q|CTuσ^$N3Ž*MZLPˑ*p*\ʓJyjj' Rbaj =O$7N 6ʙO3çxZ5ƍ5d,dLn~h2 fڡUP,c=A!o,RaH5gju@qY@< E8l}kH*3Io/@[-uW*6NFb-b@FMK^y fdx0[yz291|d39E%U+/MafIgG/AW֩;3߂w0 Mz>Wy p:O+l=ZY'jdG %/$$j$ݭ?&LACcQ!B@nԆcn}SZ$'=ËoH37k&Æ`|#bdTz*y/ʋhR1{!yɛ`}3xZ%%5 eN~%,b)s`G9{&-[lɭ? \Rn{:x뾕M{ â RU51LN-|޺B  Ij-4^0Zww^bmƧPXLw.m b"* FxQN:Ojr\oJׅrstIaBPKQ#]DKy8Q[}!t L딬҅xg4QB˕ڜO*4Y R^vLo=/QҘD(l&'o}ҭʴ;v8msk=A+[/+YHCoT^q\ٞZɗ7@Rr*+WAC5jPJ^,EWI:;W7dЖ*j,}:CDyi.},.guPxUtC3ڱLM4ӿ {`{] ]3[.Q(Wfzjsi%-&}Zl`ܷl`Iqe i[oel'īoC#,z&i0OXd{GN~@AYАcx1H~yvVD=kR* \wj//"*o5u(|֑/lrPB* p|C1V񈭟cۦ+;Pz:f&'0,OU~_WS2]@50 UpyL 9%nP>iEjSTcpqǩTr}TezLS+~K5$y2[B4+tQL ]"z y=Z}*^ 32PbJqAz+QqV+P=bx$PiJW%AN2@:l, [bcKH>1zScm*6քr8CB8.`.ϣ xen0 g)4K'߄f1w.]XX! hxwq=7fO ؞Ac\Ry`\l+JIQ)[ kɴⷬ)ýqwSC>8QWJvyA><*'R"hPwZuҺxk" ,cna&{"^[ً;|/a