-- -- PostgreSQL database dump -- -- Dumped from database version 10.3 (Ubuntu 10.3-1) -- Dumped by pg_dump version 10.3 (Ubuntu 10.3-1) -- Started on 2018-09-26 09:55:55 -03 SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_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; SET row_security = off; -- -- TOC entry 4460 (class 1262 OID 89169) -- Name: qgis_test; Type: DATABASE; Schema: -; Owner: - -- CREATE DATABASE qgis_test WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8'; \connect qgis_test SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_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; SET row_security = off; -- -- TOC entry 6 (class 2615 OID 17884) -- Name: topology; Type: SCHEMA; Schema: -; Owner: - -- CREATE SCHEMA topology; -- -- TOC entry 4462 (class 0 OID 0) -- Dependencies: 6 -- Name: SCHEMA topology; Type: COMMENT; Schema: -; Owner: - -- COMMENT ON SCHEMA topology IS 'PostGIS Topology schema'; -- -- TOC entry 1 (class 3079 OID 13041) -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: - -- CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog; -- -- TOC entry 4463 (class 0 OID 0) -- Dependencies: 1 -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: - -- COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language'; -- -- TOC entry 2 (class 3079 OID 16385) -- Name: postgis; Type: EXTENSION; Schema: -; Owner: - -- CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA public; -- -- TOC entry 4464 (class 0 OID 0) -- Dependencies: 2 -- Name: EXTENSION postgis; Type: COMMENT; Schema: -; Owner: - -- COMMENT ON EXTENSION postgis IS 'PostGIS geometry, geography, and raster spatial types and functions'; -- -- TOC entry 3 (class 3079 OID 17885) -- Name: postgis_topology; Type: EXTENSION; Schema: -; Owner: - -- CREATE EXTENSION IF NOT EXISTS postgis_topology WITH SCHEMA topology; -- -- TOC entry 4465 (class 0 OID 0) -- Dependencies: 3 -- Name: EXTENSION postgis_topology; Type: COMMENT; Schema: -; Owner: - -- COMMENT ON EXTENSION postgis_topology IS 'PostGIS topology spatial types and functions'; SET default_with_oids = false; -- -- TOC entry 222 (class 1259 OID 89202) -- Name: qgis_projects; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.qgis_projects ( name text NOT NULL, metadata jsonb, content bytea ); -- -- TOC entry 221 (class 1259 OID 89192) -- Name: split_test; Type: TABLE; Schema: public; Owner: - -- CREATE TABLE public.split_test ( id integer NOT NULL, field1 smallint DEFAULT 1, geom public.geometry(MultiLineString,4326) ); -- -- TOC entry 220 (class 1259 OID 89190) -- Name: split_test_id_seq; Type: SEQUENCE; Schema: public; Owner: - -- CREATE SEQUENCE public.split_test_id_seq AS integer START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; -- -- TOC entry 4466 (class 0 OID 0) -- Dependencies: 220 -- Name: split_test_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - -- ALTER SEQUENCE public.split_test_id_seq OWNED BY public.split_test.id; -- -- TOC entry 4318 (class 2604 OID 89195) -- Name: split_test id; Type: DEFAULT; Schema: public; Owner: - -- ALTER TABLE ONLY public.split_test ALTER COLUMN id SET DEFAULT nextval('public.split_test_id_seq'::regclass); -- -- TOC entry 4454 (class 0 OID 89202) -- Dependencies: 222 -- Data for Name: qgis_projects; Type: TABLE DATA; Schema: public; Owner: - -- INSERT INTO public.qgis_projects (name, metadata, content) VALUES ('debug_test', '{"last_modified_time": "2018-09-26 12:51:39.077551", "last_modified_user": "postgres"}', '\x504b0304140000000800734e3a4de2a39f6c2a1000004d4000002a0000007b62343262343839642d376430612d346231362d626334322d3465633135396133386461307d2e716773ed3c6b73db38929fd7bf02cbadbaccdc5812a9872d7b295539b627935a7becc4cecc6d4d4da9201292b8210986806c2b57f7dfaf1b004990a214c7f970b755f1544564a3d16874a31f009ae3fff5e2e6fcfe9fb797e4d33212e4f6c3ebabb7e7e4d54acaecb4d74bf220e8063ce961633794e12bf2eaee9f77f797d7afa607beeaf1c07211f174e20cba5ed7ed5c532159ee902ce7ff62814c69c2268e333d20c45ff184dd52b92219fc03c09e82ca48c66ceaf7f42f42e85a7299d354d0400265823f0f40c5353dd8038dd754b20bb6a0eb58fe066f4c6c61c97c2de416d4b0759e0b7c05800066221ae76c21360666d086d39ff06712f3741953497e0aa95c2793dfdfdc8d87e4a794cf42e8e3f7346ad1518030c2e96038eafb3dfd5cb5c0cb70d03fc2060b0eb35dc1ebe5eddd9b53dd6c200542c8449047198a620a8393f1d0efd9309b67a62446839ca79b646a38d73cd69b8a4e2c8ea34cf0282c1ad4f4fcde16bce8b0647c99d36c15058b982ea72065e6f71a402dd9de96684b468cf8fd986e58de9139639d65ced799e91980e67802b819cb65c444cfc02d74f54882150b3eb270e2bc93a7a7e7fac521ec29a3698860cf217a018a2c8ee44c32211d22f83a0f0016ce55db2b5cc5aae91559712141df018df189643c97931128850811273c64933012741e33822a0a164b687447e363413eb2cde45504d681aa9da01a89dc646c720deb33ba8a527627f3285d1289bd27fff169cde5dfb3f53c8e02fddcd53f159bfa9dfc00924d7e24e2533c710850b626321b0e8ee62773c666a323cf9d0dc7c3d16cccdcfeac3feed390bae351bfcf941d3e4421cbff011c3a19cc6a9933e194eadc25ea5e53d635d574780e24094b713a215a574930922c997e25977e4ff53223db43e855d3b64c7c91d22c0399760493127e05511a72fa8e163d2a5ff2988123416d7b008f52704d421b42a7e88fdcdb3321eb3492d8dbf013a56104125cd3580ba21caf9c720dbc7bf09768afc99740caa58ef6b206f6d7949002e70c5c020840abda4f6816d0f4810a632972c5ae6976ae400ea169caa546ff2d12112ede4a328aa169c86045317084fa5537b127c952594ae82989d269c7eb774f06dec81df747c3fee0e4a8ef0e8ffd9e6a2b10370a71d41d8f4f462783b1e70e87c3f1917702781b1bef29a14fd3e3eef0a87fe2b983913bf4bcd1f8e8f804c9414b454ea11d8d8f61d8c1f1e8c8f58e0683fe18a91568e0eb2c66fddccc77eafabdf2f9a070c420462d8dbc527f6b04f98618b22f8aec8e23cf8824cf8f252f8c262f88275f13515a630a02db1403eb1c62400ecb5b469057a0366b006521e5e2d7d1882d0185acb310938b9c3e82cddca01702ab00a68a65afd1f605a0ed9803ee3535544858a3dc014f2156fcf167062b2367e77c9dca9a435d00b7caebd588805a437c5bd05830c792a6c51df6240f95d99248bc4d6f205f7b88d8a372290aed258ea95769a4e4af8c1c1507c67d2b40e16d7e83c12f78f0b1f23f256470514bd21489429d80a7450e867b07015ae5746445857a794d050b95878a60229b9f61cda8764c25dfb30584bcd5a5e54ab58f7e803138a4aa224a60fa8bcd15067e2528abdb7d94e8a10aaceb727c40049f54bcb09fc60ec9190d6fd27853eb6196d22f107e94ff062c45fa26fd954ba4c884a04b4c939b2d36cf980930990369cc27507773160b1ba318ef2c5ef23c92aba48d8b7b1e572e7ccb5397befab8db1f79eec8eb0f86c747fd81db1fd63d75e9abddee70ec8dc7e3c168e8b9ae079875575d386b401c0d8727b0a8c0f7f70763f4c4756f5df8eb51f7d8f306e3e363d71b8f8e8f8f4ffa7ddb5f373d3686e8f005198795605349755238fdbfcb091d9d0e3add9adfb0f23f7073159f05eb30c623244a5791b05588fb23dc52e9df526a2dc83a77c1395b12340997825afb1a3b06b587bc6f0a7afbc3debec0f7acd0f735c1efc5e1ef4501f0eb42e08e20a8c05652025e44ad946b2629ae1bab3bec0652702e11b8673483f2c58afd3447a88db705b2220e4d976bf05f535c37e6b16ac5253f552b9781ecd49bd5d8dcfb17ea9c0b99c3d61d9acac7aa35e0a9ac4100a616abdfb3d7ac82f37c49d3e8b34ee3fc5eedb5a66f2e2283533edaed0f3c0a9449a95fbb65018e09a2a0edc7701924348a01ae7fed969cab29ab1f4ba75b93f2e328fd287a16600169360e853f56c695063c043f8283158f96acf2ba7deeb4dc6fb4dd2f59ef7efb7da6057f9d0d7f8315bfd08ebfd69277dab25a10358fdb0cd3952a3121d2f9063c7cd60f515a3ee8262036714ad92ad427d510427a93e2f99d503b67e8f0541e965566ca12087b346e4a177247de5010f225698e96ab7f9bad9809e24a6d2ab6b74d0dfcc2d6c05bb1bfb7cbd3f9c5c90729cc62e27cb8ffb93376a6c531885a050aa7eca473c27ff128ad4c4f07c90b96e106220daa5312933bb4b798dd844e35437d54d9312967cf4abf32600415005e350eadfe90f016bb7ab9895927a1297856d872ac7374c5254d3bf96ff4311b9102d14ada7710b70e259f2091a6f9e60a917a5658c13d14747be89b9905b057c274f3330bef36c99cc7c5a1853abf99ebe5b7e0a0a05c9d0cebb45c4a785033c6ed8fea17b307c867edad0fba2f439dd5bd98016f4c574553253b26bd4eab4d9bce93ad63935d24bc92c40e0a360130cf16ce7c4dabe17115cc482b56a93b8db315b54e27d140c1abcc249fe9d56d67e8f61a2490877e34d97e4685a89f5d79484641ef30e7676a9fb0658078d6473ea2e232a57b9836ecff3ead21c0d74554c756877221152b853ffa7bff59c8335868333c189a09dc26a9be83a753f7b0fcef79649084ea7c7dbda703eeac6760b960d1b38cc79b254f55a77d8328532fe530c745b8071bf5370b788cdb4640879dcca137383af48edcc3fe68f4a58e96bc791c855f427f8c42a9c5ed76c1693f07fb9982e28b05a4635f948d46fb261d1a12cf636b2d40b84ae9b372a5ed23aea7fc12f6d06d632a03820b67d5e977130f306f545e61ccf79a66ce364e13eb9dded859fe449b39febbcd8bdd5fe355fcecc76e1f2d4057aa129b625cc46ba3e4f76e5a922675a0f61cf1986d62239d51deee6b1da0f7dd01fe7b3a40efe8b0df1f1f7ac727dffddf77fff7ddff6df9bf0252cb12d57ea5f33257f93d57fc77ce15bdc1a137f4befbcaefbef2bbaf6cf395ed9ed1575694d32433f3c8691af2444145c1f91fbaf39fb56d7a71836fc344f49929f5f7ec43a4f25c6367694cfd721c819b428ee059f1b6c761c99c85210b7f8fc22593a217e06d6e8da1b2a7c27fa079840ef957988178069e2e75b30f727631e903761a5ef3505d7d572fe5adb2be6e7e6d636dc16ae75f37190d22b9997a4697c57b8174070b2b66e7e658e522a24b50d87b235712eaf77ba5be5f22601a5ff54950345f4b76a58ecbeac1cc37540aa205959b3c82c0a7143b713e644e79277cc1529e602500cf8b1bd98ca5bfa3e92b2571cdb30a7f731a7cc47beb343cc7753471feb6507f0e79d4f8dec821e82def60bd68bec12121bd02df557f1592b9096e38146ba0331dcbd1fbe3496b94ac13eca7af6935ffe62411583ccb19c5dbdb9d74572c5aaea4e613bad9c445cb9db8b90cb6e75258c78d72bcd0f7d835a75db7310d580242be6672c5412dfff58b1aadbaf1ae89ba514135a7b991f9c8a9df95f054de966b955807f713e7572e39b9a3a938f4dcc38e07731c59d33d7ccf96eb98e26d3d06c68953bcd70ee51aeba53293bd8bb344337075e679575495a1764b71606101dee18f75d1c659ac0f0e4358d03ad1ca23bc7ad7c2fefc16e8eb63f6ac20a04ed9f95c481ae812866d9b6f1e767e21aabc3c9e3c37927c7b0cd98e1eeae8bde9b37a6d0ab00a61580cb69a2ea2e53a6fdce0e946333e644bf5bbb83092da239b29dc43e67c09c0a62403457c2bc469de9b42e96d63fbbd6a287baa8ab91dcc9a43f0ffc70c9bd756c9fb348ec0cdd8b15141cce41ca2ba2a9590a8b086de97b08b8b01d3c3b3035e63409f3d05f13a6467451c11bf5fdff5f6b4fe6cb59a8b11512b90532042b32cdedca41f542d987670e54d4d7d5ebd97f736f3b466d7e408358cf7df583a54bf013750927299aee318f60b90c32c55dcaa491db2dd4f6b566fb688425851cc59087505ed1dcadd52d9d6706e633877cf706a8936a76b7170590a71873030a034561d0cd6b8bad98d5f4ca2d1c766ab8505bfcc61f4f70a2dcbe94c7fc8603ce67fbbe6afd3f24ff1f73f26a53495b8b605ec18aee2435514696b2782e7d2941ae2c59beaa20dfe4e07d210fcf0057f4c1d857a69afd37a06be4ed2c62d9c821917a564e7541eb8ac5074cb84aab37507b79340a189af2562445275f47674449dd66664c9d5125fe548c04f2e789e4cb5cb548fcd36c8e864af151a40366d2ab7dc8a40a3a5ad231657e2d732d37aaf12bc6bb0a9ffd73fce2fceeecffef81be9fc6787e80bf053b2968bce1821078ee31cbc7bf3f60eef661341029a92157d608492db0da47c2959ac53bd6ae58a4a12210a04fa903cae18c298ea08f0032c4b6561f7e0e08360d0009855574e6818823d81f190982fa300411b98af1e163a5d624dbea2879a277ca1691714223d9663987a0bf32b1b9d03b54cba0767290c41f1180bc8c6317f14a76a7e8b9c27eab3a6eeede69decbe33914e9008cb0a2479a7df0f0ec04c49b299214f339cce0fb0d100760f7581ec21313ba31f4f0ffe820579645240ba4555e60f3f1efc054b78721e43abeede853d7178be8ae2f00733d22171ae3778d4a682f98f077ffe39dd5e0eb53d9a12d33a534659ecd16a307b05f01cf8e56b3985ad148340cd42fdaec7285bed2eb8d4f76726a4406bdca13753ae763c3db43d8aaf361837e93dcfbe307085d80c4acda17760e24eb53996ff68f6e6767c0955c1178dd5de42d4ce0f1e356c6bf40658c58876327b6a3c008eb5d895d39d462166c64da85513721f655355bf810f07653587556ebd553dadf7efe5f734e501f18b0bbfcd0940f5854e3397f7f133bf4a00677301ce5632e3a4e79cc78e298d2a9a8aa9581dfd6b4605d8586297fb5cc04e0bbfa9f9801f9b34762453b04498326e232ca48a0bd850b777eb031f4563c1c8d6e0053b25bdcba212ac49cf548a95ed0d928588ceaeaab313d84b425788f5618429a3a8494ad5f8c31eb6895476af40b7fa24db74877cc5990ec06b6c2154f2cce9e3cd5ae226f74a1594b7e8680ba77560cca7ac61bda3fab091a5c40a8ebed0ee35aa318bad958c18cd83953e8fb0bb400fbba936b3f76007588edf264ebbbda908d8d7b748a3ae8712a7d9f996e658972776cab315af34806259f877babeef3d5bdc5955beb765dd6251fb5f933a10d8422848b710f4afca6f338a8f4dc0845e6fae69d63675abb9206a13f0dfac234b5fe658401d97a9d3299cb1cd6d7f3442e5b5e2eda0f326672c7d069d126f079dd7908937c9b84d220592bd702119df4940f1d182b38387f72c7cc64c0c561b0fbb85d186d44661170bdb2885be4b15fbb7a64efa366741540b53676bc913586b419bc32fda2a4385ee09d5478ea2c60918a9dd569a48dbc0cd0325ffa13cf9ec601c2d42beafbe2cc714ea1cd235c84c6b9f1cd58b48f797ca3fbf4c7e7789bc2e8fb7ebe2db6ae277d7c3d78ac4550d35cfa792a5739ecfa92ea1e6e5a7bb10e2d4d94ddff5c61df7a4d33fba774f4e47eea93bc07263569eec9439842d0effacfa1654cbec4aa593f8e2abff3fc0f4e07f01504b0304140000000000734e3a4d0000000000000000000000002a0000007b62343262343839642d376430612d346231362d626334322d3465633135396133386461307d2e716764504b01021403140000000800734e3a4de2a39f6c2a1000004d4000002a0000000000000000000000b681000000007b62343262343839642d376430612d346231362d626334322d3465633135396133386461307d2e716773504b01021403140000000000734e3a4d0000000000000000000000002a0000000000000000000000b681721000007b62343262343839642d376430612d346231362d626334322d3465633135396133386461307d2e716764504b05060000000002000200b0000000ba1000000000'); -- -- TOC entry 4311 (class 0 OID 16685) -- Dependencies: 200 -- Data for Name: spatial_ref_sys; Type: TABLE DATA; Schema: public; Owner: - -- -- -- TOC entry 4453 (class 0 OID 89192) -- Dependencies: 221 -- Data for Name: split_test; Type: TABLE DATA; Schema: public; Owner: - -- INSERT INTO public.split_test (id, field1, geom) VALUES (1, 1, '0105000020E610000001000000010200000003000000B2B22B9313011DC06037CD53ADE5FC3F2E838C9AA5650BC061EFA0CDD3301240201F21DD4770E1BFE605890476D81640'); INSERT INTO public.split_test (id, field1, geom) VALUES (2, 2, '0105000020E610000001000000010200000003000000708AD7E13E4518C0A0BB4B4042D7DEBF4E9736F38FC30DC0243D03774889F13FD6C70C4A10A20BC0E14FA95B298FF33F'); INSERT INTO public.split_test (id, field1, geom) VALUES (3, 1, '0105000020E610000001000000010200000002000000D6C70C4A10A20BC0E14FA95B298FF33FD0C842570355E3BF3A03D4F6379A0440'); -- -- TOC entry 4312 (class 0 OID 17888) -- Dependencies: 215 -- Data for Name: topology; Type: TABLE DATA; Schema: topology; Owner: - -- -- -- TOC entry 4313 (class 0 OID 17901) -- Dependencies: 216 -- Data for Name: layer; Type: TABLE DATA; Schema: topology; Owner: - -- -- -- TOC entry 4467 (class 0 OID 0) -- Dependencies: 220 -- Name: split_test_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - -- SELECT pg_catalog.setval('public.split_test_id_seq', 3, true); -- -- TOC entry 4323 (class 2606 OID 89209) -- Name: qgis_projects qgis_projects_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.qgis_projects ADD CONSTRAINT qgis_projects_pkey PRIMARY KEY (name); -- -- TOC entry 4321 (class 2606 OID 89201) -- Name: split_test split_test_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- ALTER TABLE ONLY public.split_test ADD CONSTRAINT split_test_pkey PRIMARY KEY (id); -- Completed on 2018-09-26 09:55:55 -03 -- -- PostgreSQL database dump complete --