PGDMP1'{ openstreetmap14.8 (Debian 14.8-1.pgdg110+1)14.6 (Homebrew)K 00ENCODINGENCODINGSET client_encoding = 'UTF8'; false 00 STDSTRINGS STDSTRINGS(SET standard_conforming_strings = 'on'; false 00 SEARCHPATH SEARCHPATH8SELECT pg_catalog.set_config('search_path', '', false); false 126216384 openstreetmapDATABASEaCREATE DATABASE openstreetmap WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE = 'en_US.utf8'; DROP DATABASE openstreetmap; postgresfalse00DATABASE openstreetmapACL6GRANT ALL ON DATABASE openstreetmap TO openstreetmap; postgresfalse3853125917123 changesetsTABLEACREATE TABLE public.changesets ( id bigint NOT NULL, user_id bigint NOT NULL, created_at timestamp without time zone NOT NULL, min_lat integer, max_lat integer, min_lon integer, max_lon integer, closed_at timestamp without time zone NOT NULL, num_changes integer DEFAULT 0 NOT NULL ); DROP TABLE public.changesets; publicheappostgresfalse125917127changesets_id_seqSEQUENCEzCREATE SEQUENCE public.changesets_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; (DROP SEQUENCE public.changesets_id_seq; publicpostgresfalse22200changesets_id_seqSEQUENCE OWNED BYGALTER SEQUENCE public.changesets_id_seq OWNED BY public.changesets.id; publicpostgresfalse223125917266 node_tagsTABLECREATE TABLE public.node_tags ( node_id bigint NOT NULL, version bigint NOT NULL, k character varying DEFAULT ''::character varying NOT NULL, v character varying DEFAULT ''::character varying NOT NULL ); DROP TABLE public.node_tags; publicheappostgresfalse125917273nodesTABLEACREATE TABLE public.nodes ( node_id bigint NOT NULL, latitude integer NOT NULL, longitude integer NOT NULL, changeset_id bigint NOT NULL, visible boolean NOT NULL, "timestamp" timestamp without time zone NOT NULL, tile bigint NOT NULL, version bigint NOT NULL, redaction_id integer ); DROP TABLE public.nodes; publicheappostgresfalse125917334relation_membersTABLECREATE TABLE public.relation_members ( relation_id bigint NOT NULL, member_type public.nwr_enum NOT NULL, member_id bigint NOT NULL, member_role character varying NOT NULL, version bigint DEFAULT 0 NOT NULL, sequence_id integer DEFAULT 0 NOT NULL ); $DROP TABLE public.relation_members; publicheappostgresfalse125917341 relation_tagsTABLECREATE TABLE public.relation_tags ( relation_id bigint NOT NULL, k character varying DEFAULT ''::character varying NOT NULL, v character varying DEFAULT ''::character varying NOT NULL, version bigint NOT NULL ); !DROP TABLE public.relation_tags; publicheappostgresfalse125917348 relationsTABLECREATE TABLE public.relations ( relation_id bigint NOT NULL, changeset_id bigint NOT NULL, "timestamp" timestamp without time zone NOT NULL, version bigint NOT NULL, visible boolean DEFAULT true NOT NULL, redaction_id integer ); DROP TABLE public.relations; publicheappostgresfalse"125917386usersTABLE8CREATE TABLE public.users ( email character varying NOT NULL, id bigint NOT NULL, pass_crypt character varying NOT NULL, creation_time timestamp without time zone NOT NULL, display_name character varying DEFAULT ''::character varying NOT NULL, data_public boolean DEFAULT false NOT NULL, description text DEFAULT ''::text NOT NULL, home_lat double precision, home_lon double precision, home_zoom smallint DEFAULT 3, pass_salt character varying, email_valid boolean DEFAULT false NOT NULL, new_email character varying, creation_ip character varying, languages character varying, status public.user_status_enum DEFAULT 'pending'::public.user_status_enum NOT NULL, terms_agreed timestamp without time zone, consider_pd boolean DEFAULT false NOT NULL, auth_uid character varying, preferred_editor character varying, terms_seen boolean DEFAULT false NOT NULL, description_format public.format_enum DEFAULT 'markdown'::public.format_enum NOT NULL, changesets_count integer DEFAULT 0 NOT NULL, traces_count integer DEFAULT 0 NOT NULL, diary_entries_count integer DEFAULT 0 NOT NULL, image_use_gravatar boolean DEFAULT false NOT NULL, auth_provider character varying, home_tile bigint, tou_agreed timestamp without time zone ); DROP TABLE public.users; publicheappostgresfalse#125917404 users_id_seqSEQUENCEuCREATE SEQUENCE public.users_id_seq START WITH 1 INCREMENT BY 1 NO MINVALUE NO MAXVALUE CACHE 1; #DROP SEQUENCE public.users_id_seq; publicpostgresfalse29000 users_id_seqSEQUENCE OWNED BY=ALTER SEQUENCE public.users_id_seq OWNED BY public.users.id; publicpostgresfalse291$125917405 way_nodesTABLECREATE TABLE public.way_nodes ( way_id bigint NOT NULL, node_id bigint NOT NULL, version bigint NOT NULL, sequence_id bigint NOT NULL ); DROP TABLE public.way_nodes; publicheappostgresfalse%125917408way_tagsTABLECREATE TABLE public.way_tags ( way_id bigint NOT NULL, k character varying NOT NULL, v character varying NOT NULL, version bigint NOT NULL ); DROP TABLE public.way_tags; publicheappostgresfalse&125917413waysTABLECREATE TABLE public.ways ( way_id bigint NOT NULL, changeset_id bigint NOT NULL, "timestamp" timestamp without time zone NOT NULL, version bigint NOT NULL, visible boolean DEFAULT true NOT NULL, redaction_id integer ); DROP TABLE public.ways; publicheappostgresfalse&260417422 changesets idDEFAULTnALTER TABLE ONLY public.changesets ALTER COLUMN id SET DEFAULT nextval('public.changesets_id_seq'::regclass); <ALTER TABLE public.changesets ALTER COLUMN id DROP DEFAULT; publicpostgresfalse223222;260417448users idDEFAULTdALTER TABLE ONLY public.users ALTER COLUMN id SET DEFAULT nextval('public.users_id_seq'::regclass); 7ALTER TABLE public.users ALTER COLUMN id DROP DEFAULT; publicpostgresfalse291290017123 changesets TABLE DATAyCOPY public.changesets (id, user_id, created_at, min_lat, max_lat, min_lon, max_lon, closed_at, num_changes) FROM stdin; publicpostgresfalse2223836.dat017266 node_tags TABLE DATA;COPY public.node_tags (node_id, version, k, v) FROM stdin; publicpostgresfalse2593838.dat017273nodes TABLE DATA~COPY public.nodes (node_id, latitude, longitude, changeset_id, visible, "timestamp", tile, version, redaction_id) FROM stdin; publicpostgresfalse2603839.dat017334relation_members TABLE DATArCOPY public.relation_members (relation_id, member_type, member_id, member_role, version, sequence_id) FROM stdin; publicpostgresfalse2773840.dat017341 relation_tags TABLE DATACCOPY public.relation_tags (relation_id, k, v, version) FROM stdin; publicpostgresfalse2783841.dat017348 relations TABLE DATAkCOPY public.relations (relation_id, changeset_id, "timestamp", version, visible, redaction_id) FROM stdin; publicpostgresfalse2793842.dat017386users TABLE DATACOPY public.users (email, id, pass_crypt, creation_time, display_name, data_public, description, home_lat, home_lon, home_zoom, pass_salt, email_valid, new_email, creation_ip, languages, status, terms_agreed, consider_pd, auth_uid, preferred_editor, terms_seen, description_format, changesets_count, traces_count, diary_entries_count, image_use_gravatar, auth_provider, home_tile, tou_agreed) FROM stdin; publicpostgresfalse2903843.dat017405 way_nodes TABLE DATAJCOPY public.way_nodes (way_id, node_id, version, sequence_id) FROM stdin; publicpostgresfalse2923845.dat017408way_tags TABLE DATA9COPY public.way_tags (way_id, k, v, version) FROM stdin; publicpostgresfalse2933846.dat017413ways TABLE DATAaCOPY public.ways (way_id, changeset_id, "timestamp", version, visible, redaction_id) FROM stdin; publicpostgresfalse2943847.dat00changesets_id_seq SEQUENCE SET@SELECT pg_catalog.setval('public.changesets_id_seq', 1, false); publicpostgresfalse22300 users_id_seq SEQUENCE SET;SELECT pg_catalog.setval('public.users_id_seq', 1, false); publicpostgresfalse291A260617537changesets changesets_pkey CONSTRAINTXALTER TABLE ONLY public.changesets ADD CONSTRAINT changesets_pkey PRIMARY KEY (id); DALTER TABLE ONLY public.changesets DROP CONSTRAINT changesets_pkey; publicpostgresfalse222E260617495node_tags node_tags_pkey CONSTRAINTgALTER TABLE ONLY public.node_tags ADD CONSTRAINT node_tags_pkey PRIMARY KEY (node_id, version, k); BALTER TABLE ONLY public.node_tags DROP CONSTRAINT node_tags_pkey; publicpostgresfalse259259259H260617463nodes nodes_pkey CONSTRAINT\ALTER TABLE ONLY public.nodes ADD CONSTRAINT nodes_pkey PRIMARY KEY (node_id, version); :ALTER TABLE ONLY public.nodes DROP CONSTRAINT nodes_pkey; publicpostgresfalse260260M260617553&relation_members relation_members_pkey CONSTRAINTALTER TABLE ONLY public.relation_members ADD CONSTRAINT relation_members_pkey PRIMARY KEY (relation_id, version, member_type, member_id, member_role, sequence_id); PALTER TABLE ONLY public.relation_members DROP CONSTRAINT relation_members_pkey; publicpostgresfalse277277277277277277O260617532 relation_tags relation_tags_pkey CONSTRAINTsALTER TABLE ONLY public.relation_tags ADD CONSTRAINT relation_tags_pkey PRIMARY KEY (relation_id, version, k); JALTER TABLE ONLY public.relation_tags DROP CONSTRAINT relation_tags_pkey; publicpostgresfalse278278278R260617633relations relations_pkey CONSTRAINThALTER TABLE ONLY public.relations ADD CONSTRAINT relations_pkey PRIMARY KEY (relation_id, version); BALTER TABLE ONLY public.relations DROP CONSTRAINT relations_pkey; publicpostgresfalse279279[260617587users users_pkey CONSTRAINTNALTER TABLE ONLY public.users ADD CONSTRAINT users_pkey PRIMARY KEY (id); :ALTER TABLE ONLY public.users DROP CONSTRAINT users_pkey; publicpostgresfalse290^260617461way_nodes way_nodes_pkey CONSTRAINTpALTER TABLE ONLY public.way_nodes ADD CONSTRAINT way_nodes_pkey PRIMARY KEY (way_id, version, sequence_id); BALTER TABLE ONLY public.way_nodes DROP CONSTRAINT way_nodes_pkey; publicpostgresfalse292292292`260617477way_tags way_tags_pkey CONSTRAINTdALTER TABLE ONLY public.way_tags ADD CONSTRAINT way_tags_pkey PRIMARY KEY (way_id, version, k); @ALTER TABLE ONLY public.way_tags DROP CONSTRAINT way_tags_pkey; publicpostgresfalse293293293c260617479ways ways_pkey CONSTRAINTYALTER TABLE ONLY public.ways ADD CONSTRAINT ways_pkey PRIMARY KEY (way_id, version); 8ALTER TABLE ONLY public.ways DROP CONSTRAINT ways_pkey; publicpostgresfalse294294=125917527changesets_bbox_idxINDEXgCREATE INDEX changesets_bbox_idx ON public.changesets USING gist (min_lat, max_lat, min_lon, max_lon); 'DROP INDEX public.changesets_bbox_idx; publicpostgresfalse222222222222>125917526changesets_closed_at_idxINDEXTCREATE INDEX changesets_closed_at_idx ON public.changesets USING btree (closed_at); ,DROP INDEX public.changesets_closed_at_idx; publicpostgresfalse222?125917528changesets_created_at_idxINDEXVCREATE INDEX changesets_created_at_idx ON public.changesets USING btree (created_at); -DROP INDEX public.changesets_created_at_idx; publicpostgresfalse222B125917529!changesets_user_id_created_at_idxINDEXgCREATE INDEX changesets_user_id_created_at_idx ON public.changesets USING btree (user_id, created_at); 5DROP INDEX public.changesets_user_id_created_at_idx; publicpostgresfalse222222C125917530changesets_user_id_id_idxINDEXWCREATE INDEX changesets_user_id_id_idx ON public.changesets USING btree (user_id, id); -DROP INDEX public.changesets_user_id_id_idx; publicpostgresfalse222222F125917456nodes_changeset_id_idxINDEXPCREATE INDEX nodes_changeset_id_idx ON public.nodes USING btree (changeset_id); *DROP INDEX public.nodes_changeset_id_idx; publicpostgresfalse260I125917457nodes_tile_idxINDEX@CREATE INDEX nodes_tile_idx ON public.nodes USING btree (tile); "DROP INDEX public.nodes_tile_idx; publicpostgresfalse260J125917458nodes_timestamp_idxINDEXLCREATE INDEX nodes_timestamp_idx ON public.nodes USING btree ("timestamp"); 'DROP INDEX public.nodes_timestamp_idx; publicpostgresfalse260K125917541relation_members_member_idxINDEXjCREATE INDEX relation_members_member_idx ON public.relation_members USING btree (member_type, member_id); /DROP INDEX public.relation_members_member_idx; publicpostgresfalse277277P125917614relations_changeset_id_idxINDEXXCREATE INDEX relations_changeset_id_idx ON public.relations USING btree (changeset_id); .DROP INDEX public.relations_changeset_id_idx; publicpostgresfalse279S125917623relations_timestamp_idxINDEXTCREATE INDEX relations_timestamp_idx ON public.relations USING btree ("timestamp"); +DROP INDEX public.relations_timestamp_idx; publicpostgresfalse279T125917562users_auth_idxINDEXZCREATE UNIQUE INDEX users_auth_idx ON public.users USING btree (auth_provider, auth_uid); "DROP INDEX public.users_auth_idx; publicpostgresfalse290290U125917575users_display_name_idxINDEXWCREATE UNIQUE INDEX users_display_name_idx ON public.users USING btree (display_name); *DROP INDEX public.users_display_name_idx; publicpostgresfalse290V125917576users_display_name_lower_idxINDEXeCREATE INDEX users_display_name_lower_idx ON public.users USING btree (lower((display_name)::text)); 0DROP INDEX public.users_display_name_lower_idx; publicpostgresfalse290290W125917577users_email_idxINDEXICREATE UNIQUE INDEX users_email_idx ON public.users USING btree (email); #DROP INDEX public.users_email_idx; publicpostgresfalse290X125917578users_email_lower_idxINDEXWCREATE INDEX users_email_lower_idx ON public.users USING btree (lower((email)::text)); )DROP INDEX public.users_email_lower_idx; publicpostgresfalse290290Y125917579users_home_idxINDEXECREATE INDEX users_home_idx ON public.users USING btree (home_tile); "DROP INDEX public.users_home_idx; publicpostgresfalse290\125917454way_nodes_node_idxINDEXKCREATE INDEX way_nodes_node_idx ON public.way_nodes USING btree (node_id); &DROP INDEX public.way_nodes_node_idx; publicpostgresfalse292a125917474ways_changeset_id_idxINDEXNCREATE INDEX ways_changeset_id_idx ON public.ways USING btree (changeset_id); )DROP INDEX public.ways_changeset_id_idx; publicpostgresfalse294d125917475ways_timestamp_idxINDEXJCREATE INDEX ways_timestamp_idx ON public.ways USING btree ("timestamp"); &DROP INDEX public.ways_timestamp_idx; publicpostgresfalse294e260617588"changesets changesets_user_id_fkey FK CONSTRAINTALTER TABLE ONLY public.changesets ADD CONSTRAINT changesets_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id); LALTER TABLE ONLY public.changesets DROP CONSTRAINT changesets_user_id_fkey; publicpostgresfalse2222903675f260617489node_tags node_tags_id_fkey FK CONSTRAINTALTER TABLE ONLY public.node_tags ADD CONSTRAINT node_tags_id_fkey FOREIGN KEY (node_id, version) REFERENCES public.nodes(node_id, version); EALTER TABLE ONLY public.node_tags DROP CONSTRAINT node_tags_id_fkey; publicpostgresfalse3656260260259259g260617542nodes nodes_changeset_id_fkey FK CONSTRAINTALTER TABLE ONLY public.nodes ADD CONSTRAINT nodes_changeset_id_fkey FOREIGN KEY (changeset_id) REFERENCES public.changesets(id); GALTER TABLE ONLY public.nodes DROP CONSTRAINT nodes_changeset_id_fkey; publicpostgresfalse2603649222h260618020nodes nodes_redaction_id_fkey FK CONSTRAINTALTER TABLE ONLY public.nodes ADD CONSTRAINT nodes_redaction_id_fkey FOREIGN KEY (redaction_id) REFERENCES public.redactions(id); GALTER TABLE ONLY public.nodes DROP CONSTRAINT nodes_redaction_id_fkey; publicpostgresfalse260i260617648)relation_members relation_members_id_fkey FK CONSTRAINTALTER TABLE ONLY public.relation_members ADD CONSTRAINT relation_members_id_fkey FOREIGN KEY (relation_id, version) REFERENCES public.relations(relation_id, version); SALTER TABLE ONLY public.relation_members DROP CONSTRAINT relation_members_id_fkey; publicpostgresfalse2772772793666279j260617642#relation_tags relation_tags_id_fkey FK CONSTRAINTALTER TABLE ONLY public.relation_tags ADD CONSTRAINT relation_tags_id_fkey FOREIGN KEY (relation_id, version) REFERENCES public.relations(relation_id, version); MALTER TABLE ONLY public.relation_tags DROP CONSTRAINT relation_tags_id_fkey; publicpostgresfalse2783666278279279l260617609%relations relations_changeset_id_fkey FK CONSTRAINTALTER TABLE ONLY public.relations ADD CONSTRAINT relations_changeset_id_fkey FOREIGN KEY (changeset_id) REFERENCES public.changesets(id); OALTER TABLE ONLY public.relations DROP CONSTRAINT relations_changeset_id_fkey; publicpostgresfalse2792223649k260618048%relations relations_redaction_id_fkey FK CONSTRAINTALTER TABLE ONLY public.relations ADD CONSTRAINT relations_redaction_id_fkey FOREIGN KEY (redaction_id) REFERENCES public.redactions(id); OALTER TABLE ONLY public.relations DROP CONSTRAINT relations_redaction_id_fkey; publicpostgresfalse279m260617480way_nodes way_nodes_id_fkey FK CONSTRAINTALTER TABLE ONLY public.way_nodes ADD CONSTRAINT way_nodes_id_fkey FOREIGN KEY (way_id, version) REFERENCES public.ways(way_id, version); EALTER TABLE ONLY public.way_nodes DROP CONSTRAINT way_nodes_id_fkey; publicpostgresfalse3683294292294292n260617499way_tags way_tags_id_fkey FK CONSTRAINTALTER TABLE ONLY public.way_tags ADD CONSTRAINT way_tags_id_fkey FOREIGN KEY (way_id, version) REFERENCES public.ways(way_id, version); CALTER TABLE ONLY public.way_tags DROP CONSTRAINT way_tags_id_fkey; publicpostgresfalse2943683293293294o260617557ways ways_changeset_id_fkey FK CONSTRAINTALTER TABLE ONLY public.ways ADD CONSTRAINT ways_changeset_id_fkey FOREIGN KEY (changeset_id) REFERENCES public.changesets(id); EALTER TABLE ONLY public.ways DROP CONSTRAINT ways_changeset_id_fkey; publicpostgresfalse3649294222p260618035ways ways_redaction_id_fkey FK CONSTRAINTALTER TABLE ONLY public.ways ADD CONSTRAINT ways_redaction_id_fkey FOREIGN KEY (redaction_id) REFERENCES public.redactions(id); EALTER TABLE ONLY public.ways DROP CONSTRAINT ways_redaction_id_fkey; publicpostgresfalse294