2 -- PostgreSQL database dump
5 SET statement_timeout = 0;
7 SET client_encoding = 'UTF8';
8 SET standard_conforming_strings = on;
9 SET check_function_bodies = false;
10 SET client_min_messages = warning;
13 -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: -
16 CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;
20 -- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: -
23 COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';
27 -- Name: btree_gist; Type: EXTENSION; Schema: -; Owner: -
30 CREATE EXTENSION IF NOT EXISTS btree_gist WITH SCHEMA public;
34 -- Name: EXTENSION btree_gist; Type: COMMENT; Schema: -; Owner: -
37 COMMENT ON EXTENSION btree_gist IS 'support for indexing common datatypes in GiST';
40 SET search_path = public, pg_catalog;
43 -- Name: format_enum; Type: TYPE; Schema: public; Owner: -
46 CREATE TYPE format_enum AS ENUM (
54 -- Name: gpx_visibility_enum; Type: TYPE; Schema: public; Owner: -
57 CREATE TYPE gpx_visibility_enum AS ENUM (
66 -- Name: note_event_enum; Type: TYPE; Schema: public; Owner: -
69 CREATE TYPE note_event_enum AS ENUM (
79 -- Name: note_status_enum; Type: TYPE; Schema: public; Owner: -
82 CREATE TYPE note_status_enum AS ENUM (
90 -- Name: nwr_enum; Type: TYPE; Schema: public; Owner: -
93 CREATE TYPE nwr_enum AS ENUM (
101 -- Name: user_role_enum; Type: TYPE; Schema: public; Owner: -
104 CREATE TYPE user_role_enum AS ENUM (
111 -- Name: user_status_enum; Type: TYPE; Schema: public; Owner: -
114 CREATE TYPE user_status_enum AS ENUM (
124 -- Name: maptile_for_point(bigint, bigint, integer); Type: FUNCTION; Schema: public; Owner: -
127 CREATE FUNCTION maptile_for_point(bigint, bigint, integer) RETURNS integer
129 AS '/srv/www/master.osm.compton.nu/db/functions/libpgosm.so', 'maptile_for_point';
133 -- Name: tile_for_point(integer, integer); Type: FUNCTION; Schema: public; Owner: -
136 CREATE FUNCTION tile_for_point(integer, integer) RETURNS bigint
138 AS '/srv/www/master.osm.compton.nu/db/functions/libpgosm.so', 'tile_for_point';
142 -- Name: xid_to_int4(xid); Type: FUNCTION; Schema: public; Owner: -
145 CREATE FUNCTION xid_to_int4(xid) RETURNS integer
146 LANGUAGE c IMMUTABLE STRICT
147 AS '/srv/www/master.osm.compton.nu/db/functions/libpgosm.so', 'xid_to_int4';
150 SET default_tablespace = '';
152 SET default_with_oids = false;
155 -- Name: acls; Type: TABLE; Schema: public; Owner: -; Tablespace:
161 k character varying NOT NULL,
163 domain character varying
168 -- Name: acls_id_seq; Type: SEQUENCE; Schema: public; Owner: -
171 CREATE SEQUENCE acls_id_seq
180 -- Name: acls_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
183 ALTER SEQUENCE acls_id_seq OWNED BY acls.id;
187 -- Name: changeset_comments; Type: TABLE; Schema: public; Owner: -; Tablespace:
190 CREATE TABLE changeset_comments (
192 changeset_id bigint NOT NULL,
193 author_id bigint NOT NULL,
195 created_at timestamp without time zone NOT NULL,
196 visible boolean NOT NULL
201 -- Name: changeset_comments_id_seq; Type: SEQUENCE; Schema: public; Owner: -
204 CREATE SEQUENCE changeset_comments_id_seq
213 -- Name: changeset_comments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
216 ALTER SEQUENCE changeset_comments_id_seq OWNED BY changeset_comments.id;
220 -- Name: changeset_tags; Type: TABLE; Schema: public; Owner: -; Tablespace:
223 CREATE TABLE changeset_tags (
224 changeset_id bigint NOT NULL,
225 k character varying DEFAULT ''::character varying NOT NULL,
226 v character varying DEFAULT ''::character varying NOT NULL
231 -- Name: changesets; Type: TABLE; Schema: public; Owner: -; Tablespace:
234 CREATE TABLE changesets (
236 user_id bigint NOT NULL,
237 created_at timestamp without time zone NOT NULL,
242 closed_at timestamp without time zone NOT NULL,
243 num_changes integer DEFAULT 0 NOT NULL
248 -- Name: changesets_id_seq; Type: SEQUENCE; Schema: public; Owner: -
251 CREATE SEQUENCE changesets_id_seq
260 -- Name: changesets_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
263 ALTER SEQUENCE changesets_id_seq OWNED BY changesets.id;
267 -- Name: changesets_subscribers; Type: TABLE; Schema: public; Owner: -; Tablespace:
270 CREATE TABLE changesets_subscribers (
271 subscriber_id bigint NOT NULL,
272 changeset_id bigint NOT NULL
277 -- Name: client_applications; Type: TABLE; Schema: public; Owner: -; Tablespace:
280 CREATE TABLE client_applications (
282 name character varying,
283 url character varying,
284 support_url character varying,
285 callback_url character varying,
286 key character varying(50),
287 secret character varying(50),
289 created_at timestamp without time zone,
290 updated_at timestamp without time zone,
291 allow_read_prefs boolean DEFAULT false NOT NULL,
292 allow_write_prefs boolean DEFAULT false NOT NULL,
293 allow_write_diary boolean DEFAULT false NOT NULL,
294 allow_write_api boolean DEFAULT false NOT NULL,
295 allow_read_gpx boolean DEFAULT false NOT NULL,
296 allow_write_gpx boolean DEFAULT false NOT NULL,
297 allow_write_notes boolean DEFAULT false NOT NULL
302 -- Name: client_applications_id_seq; Type: SEQUENCE; Schema: public; Owner: -
305 CREATE SEQUENCE client_applications_id_seq
314 -- Name: client_applications_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
317 ALTER SEQUENCE client_applications_id_seq OWNED BY client_applications.id;
321 -- Name: current_node_tags; Type: TABLE; Schema: public; Owner: -; Tablespace:
324 CREATE TABLE current_node_tags (
325 node_id bigint NOT NULL,
326 k character varying DEFAULT ''::character varying NOT NULL,
327 v character varying DEFAULT ''::character varying NOT NULL
332 -- Name: current_nodes; Type: TABLE; Schema: public; Owner: -; Tablespace:
335 CREATE TABLE current_nodes (
337 latitude integer NOT NULL,
338 longitude integer NOT NULL,
339 changeset_id bigint NOT NULL,
340 visible boolean NOT NULL,
341 "timestamp" timestamp without time zone NOT NULL,
342 tile bigint NOT NULL,
343 version bigint NOT NULL
348 -- Name: current_nodes_id_seq; Type: SEQUENCE; Schema: public; Owner: -
351 CREATE SEQUENCE current_nodes_id_seq
360 -- Name: current_nodes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
363 ALTER SEQUENCE current_nodes_id_seq OWNED BY current_nodes.id;
367 -- Name: current_relation_members; Type: TABLE; Schema: public; Owner: -; Tablespace:
370 CREATE TABLE current_relation_members (
371 relation_id bigint NOT NULL,
372 member_type nwr_enum NOT NULL,
373 member_id bigint NOT NULL,
374 member_role character varying NOT NULL,
375 sequence_id integer DEFAULT 0 NOT NULL
380 -- Name: current_relation_tags; Type: TABLE; Schema: public; Owner: -; Tablespace:
383 CREATE TABLE current_relation_tags (
384 relation_id bigint NOT NULL,
385 k character varying DEFAULT ''::character varying NOT NULL,
386 v character varying DEFAULT ''::character varying NOT NULL
391 -- Name: current_relations; Type: TABLE; Schema: public; Owner: -; Tablespace:
394 CREATE TABLE current_relations (
396 changeset_id bigint NOT NULL,
397 "timestamp" timestamp without time zone NOT NULL,
398 visible boolean NOT NULL,
399 version bigint NOT NULL
404 -- Name: current_relations_id_seq; Type: SEQUENCE; Schema: public; Owner: -
407 CREATE SEQUENCE current_relations_id_seq
416 -- Name: current_relations_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
419 ALTER SEQUENCE current_relations_id_seq OWNED BY current_relations.id;
423 -- Name: current_way_nodes; Type: TABLE; Schema: public; Owner: -; Tablespace:
426 CREATE TABLE current_way_nodes (
427 way_id bigint NOT NULL,
428 node_id bigint NOT NULL,
429 sequence_id bigint NOT NULL
434 -- Name: current_way_tags; Type: TABLE; Schema: public; Owner: -; Tablespace:
437 CREATE TABLE current_way_tags (
438 way_id bigint NOT NULL,
439 k character varying DEFAULT ''::character varying NOT NULL,
440 v character varying DEFAULT ''::character varying NOT NULL
445 -- Name: current_ways; Type: TABLE; Schema: public; Owner: -; Tablespace:
448 CREATE TABLE current_ways (
450 changeset_id bigint NOT NULL,
451 "timestamp" timestamp without time zone NOT NULL,
452 visible boolean NOT NULL,
453 version bigint NOT NULL
458 -- Name: current_ways_id_seq; Type: SEQUENCE; Schema: public; Owner: -
461 CREATE SEQUENCE current_ways_id_seq
470 -- Name: current_ways_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
473 ALTER SEQUENCE current_ways_id_seq OWNED BY current_ways.id;
477 -- Name: diary_comments; Type: TABLE; Schema: public; Owner: -; Tablespace:
480 CREATE TABLE diary_comments (
482 diary_entry_id bigint NOT NULL,
483 user_id bigint NOT NULL,
485 created_at timestamp without time zone NOT NULL,
486 updated_at timestamp without time zone NOT NULL,
487 visible boolean DEFAULT true NOT NULL,
488 body_format format_enum DEFAULT 'markdown'::format_enum NOT NULL
493 -- Name: diary_comments_id_seq; Type: SEQUENCE; Schema: public; Owner: -
496 CREATE SEQUENCE diary_comments_id_seq
505 -- Name: diary_comments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
508 ALTER SEQUENCE diary_comments_id_seq OWNED BY diary_comments.id;
512 -- Name: diary_entries; Type: TABLE; Schema: public; Owner: -; Tablespace:
515 CREATE TABLE diary_entries (
517 user_id bigint NOT NULL,
518 title character varying NOT NULL,
520 created_at timestamp without time zone NOT NULL,
521 updated_at timestamp without time zone NOT NULL,
522 latitude double precision,
523 longitude double precision,
524 language_code character varying DEFAULT 'en'::character varying NOT NULL,
525 visible boolean DEFAULT true NOT NULL,
526 body_format format_enum DEFAULT 'markdown'::format_enum NOT NULL
531 -- Name: diary_entries_id_seq; Type: SEQUENCE; Schema: public; Owner: -
534 CREATE SEQUENCE diary_entries_id_seq
543 -- Name: diary_entries_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
546 ALTER SEQUENCE diary_entries_id_seq OWNED BY diary_entries.id;
550 -- Name: friends; Type: TABLE; Schema: public; Owner: -; Tablespace:
553 CREATE TABLE friends (
555 user_id bigint NOT NULL,
556 friend_user_id bigint NOT NULL
561 -- Name: friends_id_seq; Type: SEQUENCE; Schema: public; Owner: -
564 CREATE SEQUENCE friends_id_seq
573 -- Name: friends_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
576 ALTER SEQUENCE friends_id_seq OWNED BY friends.id;
580 -- Name: gps_points; Type: TABLE; Schema: public; Owner: -; Tablespace:
583 CREATE TABLE gps_points (
584 altitude double precision,
585 trackid integer NOT NULL,
586 latitude integer NOT NULL,
587 longitude integer NOT NULL,
588 gpx_id bigint NOT NULL,
589 "timestamp" timestamp without time zone,
595 -- Name: gpx_file_tags; Type: TABLE; Schema: public; Owner: -; Tablespace:
598 CREATE TABLE gpx_file_tags (
599 gpx_id bigint DEFAULT 0 NOT NULL,
600 tag character varying NOT NULL,
606 -- Name: gpx_file_tags_id_seq; Type: SEQUENCE; Schema: public; Owner: -
609 CREATE SEQUENCE gpx_file_tags_id_seq
618 -- Name: gpx_file_tags_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
621 ALTER SEQUENCE gpx_file_tags_id_seq OWNED BY gpx_file_tags.id;
625 -- Name: gpx_files; Type: TABLE; Schema: public; Owner: -; Tablespace:
628 CREATE TABLE gpx_files (
630 user_id bigint NOT NULL,
631 visible boolean DEFAULT true NOT NULL,
632 name character varying DEFAULT ''::character varying NOT NULL,
634 latitude double precision,
635 longitude double precision,
636 "timestamp" timestamp without time zone NOT NULL,
637 description character varying DEFAULT ''::character varying NOT NULL,
638 inserted boolean NOT NULL,
639 visibility gpx_visibility_enum DEFAULT 'public'::gpx_visibility_enum NOT NULL
644 -- Name: gpx_files_id_seq; Type: SEQUENCE; Schema: public; Owner: -
647 CREATE SEQUENCE gpx_files_id_seq
656 -- Name: gpx_files_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
659 ALTER SEQUENCE gpx_files_id_seq OWNED BY gpx_files.id;
663 -- Name: languages; Type: TABLE; Schema: public; Owner: -; Tablespace:
666 CREATE TABLE languages (
667 code character varying NOT NULL,
668 english_name character varying NOT NULL,
669 native_name character varying
674 -- Name: messages; Type: TABLE; Schema: public; Owner: -; Tablespace:
677 CREATE TABLE messages (
679 from_user_id bigint NOT NULL,
680 title character varying NOT NULL,
682 sent_on timestamp without time zone NOT NULL,
683 message_read boolean DEFAULT false NOT NULL,
684 to_user_id bigint NOT NULL,
685 to_user_visible boolean DEFAULT true NOT NULL,
686 from_user_visible boolean DEFAULT true NOT NULL,
687 body_format format_enum DEFAULT 'markdown'::format_enum NOT NULL
692 -- Name: messages_id_seq; Type: SEQUENCE; Schema: public; Owner: -
695 CREATE SEQUENCE messages_id_seq
704 -- Name: messages_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
707 ALTER SEQUENCE messages_id_seq OWNED BY messages.id;
711 -- Name: node_tags; Type: TABLE; Schema: public; Owner: -; Tablespace:
714 CREATE TABLE node_tags (
715 node_id bigint NOT NULL,
716 version bigint NOT NULL,
717 k character varying DEFAULT ''::character varying NOT NULL,
718 v character varying DEFAULT ''::character varying NOT NULL
723 -- Name: nodes; Type: TABLE; Schema: public; Owner: -; Tablespace:
727 node_id bigint NOT NULL,
728 latitude integer NOT NULL,
729 longitude integer NOT NULL,
730 changeset_id bigint NOT NULL,
731 visible boolean NOT NULL,
732 "timestamp" timestamp without time zone NOT NULL,
733 tile bigint NOT NULL,
734 version bigint NOT NULL,
740 -- Name: note_comments; Type: TABLE; Schema: public; Owner: -; Tablespace:
743 CREATE TABLE note_comments (
745 note_id bigint NOT NULL,
746 visible boolean NOT NULL,
747 created_at timestamp without time zone NOT NULL,
751 event note_event_enum
756 -- Name: note_comments_id_seq; Type: SEQUENCE; Schema: public; Owner: -
759 CREATE SEQUENCE note_comments_id_seq
768 -- Name: note_comments_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
771 ALTER SEQUENCE note_comments_id_seq OWNED BY note_comments.id;
775 -- Name: notes; Type: TABLE; Schema: public; Owner: -; Tablespace:
780 latitude integer NOT NULL,
781 longitude integer NOT NULL,
782 tile bigint NOT NULL,
783 updated_at timestamp without time zone NOT NULL,
784 created_at timestamp without time zone NOT NULL,
785 status note_status_enum NOT NULL,
786 closed_at timestamp without time zone
791 -- Name: notes_id_seq; Type: SEQUENCE; Schema: public; Owner: -
794 CREATE SEQUENCE notes_id_seq
803 -- Name: notes_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
806 ALTER SEQUENCE notes_id_seq OWNED BY notes.id;
810 -- Name: oauth_nonces; Type: TABLE; Schema: public; Owner: -; Tablespace:
813 CREATE TABLE oauth_nonces (
815 nonce character varying,
817 created_at timestamp without time zone,
818 updated_at timestamp without time zone
823 -- Name: oauth_nonces_id_seq; Type: SEQUENCE; Schema: public; Owner: -
826 CREATE SEQUENCE oauth_nonces_id_seq
835 -- Name: oauth_nonces_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
838 ALTER SEQUENCE oauth_nonces_id_seq OWNED BY oauth_nonces.id;
842 -- Name: oauth_tokens; Type: TABLE; Schema: public; Owner: -; Tablespace:
845 CREATE TABLE oauth_tokens (
848 type character varying(20),
849 client_application_id integer,
850 token character varying(50),
851 secret character varying(50),
852 authorized_at timestamp without time zone,
853 invalidated_at timestamp without time zone,
854 created_at timestamp without time zone,
855 updated_at timestamp without time zone,
856 allow_read_prefs boolean DEFAULT false NOT NULL,
857 allow_write_prefs boolean DEFAULT false NOT NULL,
858 allow_write_diary boolean DEFAULT false NOT NULL,
859 allow_write_api boolean DEFAULT false NOT NULL,
860 allow_read_gpx boolean DEFAULT false NOT NULL,
861 allow_write_gpx boolean DEFAULT false NOT NULL,
862 callback_url character varying,
863 verifier character varying(20),
864 scope character varying,
865 valid_to timestamp without time zone,
866 allow_write_notes boolean DEFAULT false NOT NULL
871 -- Name: oauth_tokens_id_seq; Type: SEQUENCE; Schema: public; Owner: -
874 CREATE SEQUENCE oauth_tokens_id_seq
883 -- Name: oauth_tokens_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
886 ALTER SEQUENCE oauth_tokens_id_seq OWNED BY oauth_tokens.id;
890 -- Name: redactions; Type: TABLE; Schema: public; Owner: -; Tablespace:
893 CREATE TABLE redactions (
895 title character varying,
897 created_at timestamp without time zone,
898 updated_at timestamp without time zone,
899 user_id bigint NOT NULL,
900 description_format format_enum DEFAULT 'markdown'::format_enum NOT NULL
905 -- Name: redactions_id_seq; Type: SEQUENCE; Schema: public; Owner: -
908 CREATE SEQUENCE redactions_id_seq
917 -- Name: redactions_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
920 ALTER SEQUENCE redactions_id_seq OWNED BY redactions.id;
924 -- Name: relation_members; Type: TABLE; Schema: public; Owner: -; Tablespace:
927 CREATE TABLE relation_members (
928 relation_id bigint DEFAULT 0 NOT NULL,
929 member_type nwr_enum NOT NULL,
930 member_id bigint NOT NULL,
931 member_role character varying NOT NULL,
932 version bigint DEFAULT 0 NOT NULL,
933 sequence_id integer DEFAULT 0 NOT NULL
938 -- Name: relation_tags; Type: TABLE; Schema: public; Owner: -; Tablespace:
941 CREATE TABLE relation_tags (
942 relation_id bigint DEFAULT 0 NOT NULL,
943 k character varying DEFAULT ''::character varying NOT NULL,
944 v character varying DEFAULT ''::character varying NOT NULL,
945 version bigint NOT NULL
950 -- Name: relations; Type: TABLE; Schema: public; Owner: -; Tablespace:
953 CREATE TABLE relations (
954 relation_id bigint DEFAULT 0 NOT NULL,
955 changeset_id bigint NOT NULL,
956 "timestamp" timestamp without time zone NOT NULL,
957 version bigint NOT NULL,
958 visible boolean DEFAULT true NOT NULL,
964 -- Name: schema_migrations; Type: TABLE; Schema: public; Owner: -; Tablespace:
967 CREATE TABLE schema_migrations (
968 version character varying NOT NULL
973 -- Name: user_blocks; Type: TABLE; Schema: public; Owner: -; Tablespace:
976 CREATE TABLE user_blocks (
978 user_id bigint NOT NULL,
979 creator_id bigint NOT NULL,
980 reason text NOT NULL,
981 ends_at timestamp without time zone NOT NULL,
982 needs_view boolean DEFAULT false NOT NULL,
984 created_at timestamp without time zone,
985 updated_at timestamp without time zone,
986 reason_format format_enum DEFAULT 'markdown'::format_enum NOT NULL
991 -- Name: user_blocks_id_seq; Type: SEQUENCE; Schema: public; Owner: -
994 CREATE SEQUENCE user_blocks_id_seq
1003 -- Name: user_blocks_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1006 ALTER SEQUENCE user_blocks_id_seq OWNED BY user_blocks.id;
1010 -- Name: user_preferences; Type: TABLE; Schema: public; Owner: -; Tablespace:
1013 CREATE TABLE user_preferences (
1014 user_id bigint NOT NULL,
1015 k character varying NOT NULL,
1016 v character varying NOT NULL
1021 -- Name: user_roles; Type: TABLE; Schema: public; Owner: -; Tablespace:
1024 CREATE TABLE user_roles (
1025 id integer NOT NULL,
1026 user_id bigint NOT NULL,
1027 role user_role_enum NOT NULL,
1028 created_at timestamp without time zone,
1029 updated_at timestamp without time zone,
1030 granter_id bigint NOT NULL
1035 -- Name: user_roles_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1038 CREATE SEQUENCE user_roles_id_seq
1047 -- Name: user_roles_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1050 ALTER SEQUENCE user_roles_id_seq OWNED BY user_roles.id;
1054 -- Name: user_tokens; Type: TABLE; Schema: public; Owner: -; Tablespace:
1057 CREATE TABLE user_tokens (
1059 user_id bigint NOT NULL,
1060 token character varying NOT NULL,
1061 expiry timestamp without time zone NOT NULL,
1067 -- Name: user_tokens_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1070 CREATE SEQUENCE user_tokens_id_seq
1079 -- Name: user_tokens_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1082 ALTER SEQUENCE user_tokens_id_seq OWNED BY user_tokens.id;
1086 -- Name: users; Type: TABLE; Schema: public; Owner: -; Tablespace:
1089 CREATE TABLE users (
1090 email character varying NOT NULL,
1092 pass_crypt character varying NOT NULL,
1093 creation_time timestamp without time zone NOT NULL,
1094 display_name character varying DEFAULT ''::character varying NOT NULL,
1095 data_public boolean DEFAULT false NOT NULL,
1096 description text DEFAULT ''::text NOT NULL,
1097 home_lat double precision,
1098 home_lon double precision,
1099 home_zoom smallint DEFAULT 3,
1100 nearby integer DEFAULT 50,
1101 pass_salt character varying,
1102 image_file_name text,
1103 email_valid boolean DEFAULT false NOT NULL,
1104 new_email character varying,
1105 creation_ip character varying,
1106 languages character varying,
1107 status user_status_enum DEFAULT 'pending'::user_status_enum NOT NULL,
1108 terms_agreed timestamp without time zone,
1109 consider_pd boolean DEFAULT false NOT NULL,
1110 openid_url character varying,
1111 preferred_editor character varying,
1112 terms_seen boolean DEFAULT false NOT NULL,
1113 description_format format_enum DEFAULT 'markdown'::format_enum NOT NULL,
1114 image_fingerprint character varying,
1115 changesets_count integer DEFAULT 0 NOT NULL,
1116 traces_count integer DEFAULT 0 NOT NULL,
1117 diary_entries_count integer DEFAULT 0 NOT NULL,
1118 image_use_gravatar boolean DEFAULT true NOT NULL,
1119 image_content_type character varying
1124 -- Name: users_id_seq; Type: SEQUENCE; Schema: public; Owner: -
1127 CREATE SEQUENCE users_id_seq
1136 -- Name: users_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -
1139 ALTER SEQUENCE users_id_seq OWNED BY users.id;
1143 -- Name: way_nodes; Type: TABLE; Schema: public; Owner: -; Tablespace:
1146 CREATE TABLE way_nodes (
1147 way_id bigint NOT NULL,
1148 node_id bigint NOT NULL,
1149 version bigint NOT NULL,
1150 sequence_id bigint NOT NULL
1155 -- Name: way_tags; Type: TABLE; Schema: public; Owner: -; Tablespace:
1158 CREATE TABLE way_tags (
1159 way_id bigint DEFAULT 0 NOT NULL,
1160 k character varying NOT NULL,
1161 v character varying NOT NULL,
1162 version bigint NOT NULL
1167 -- Name: ways; Type: TABLE; Schema: public; Owner: -; Tablespace:
1171 way_id bigint DEFAULT 0 NOT NULL,
1172 changeset_id bigint NOT NULL,
1173 "timestamp" timestamp without time zone NOT NULL,
1174 version bigint NOT NULL,
1175 visible boolean DEFAULT true NOT NULL,
1176 redaction_id integer
1181 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1184 ALTER TABLE ONLY acls ALTER COLUMN id SET DEFAULT nextval('acls_id_seq'::regclass);
1188 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1191 ALTER TABLE ONLY changeset_comments ALTER COLUMN id SET DEFAULT nextval('changeset_comments_id_seq'::regclass);
1195 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1198 ALTER TABLE ONLY changesets ALTER COLUMN id SET DEFAULT nextval('changesets_id_seq'::regclass);
1202 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1205 ALTER TABLE ONLY client_applications ALTER COLUMN id SET DEFAULT nextval('client_applications_id_seq'::regclass);
1209 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1212 ALTER TABLE ONLY current_nodes ALTER COLUMN id SET DEFAULT nextval('current_nodes_id_seq'::regclass);
1216 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1219 ALTER TABLE ONLY current_relations ALTER COLUMN id SET DEFAULT nextval('current_relations_id_seq'::regclass);
1223 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1226 ALTER TABLE ONLY current_ways ALTER COLUMN id SET DEFAULT nextval('current_ways_id_seq'::regclass);
1230 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1233 ALTER TABLE ONLY diary_comments ALTER COLUMN id SET DEFAULT nextval('diary_comments_id_seq'::regclass);
1237 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1240 ALTER TABLE ONLY diary_entries ALTER COLUMN id SET DEFAULT nextval('diary_entries_id_seq'::regclass);
1244 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1247 ALTER TABLE ONLY friends ALTER COLUMN id SET DEFAULT nextval('friends_id_seq'::regclass);
1251 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1254 ALTER TABLE ONLY gpx_file_tags ALTER COLUMN id SET DEFAULT nextval('gpx_file_tags_id_seq'::regclass);
1258 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1261 ALTER TABLE ONLY gpx_files ALTER COLUMN id SET DEFAULT nextval('gpx_files_id_seq'::regclass);
1265 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1268 ALTER TABLE ONLY messages ALTER COLUMN id SET DEFAULT nextval('messages_id_seq'::regclass);
1272 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1275 ALTER TABLE ONLY note_comments ALTER COLUMN id SET DEFAULT nextval('note_comments_id_seq'::regclass);
1279 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1282 ALTER TABLE ONLY notes ALTER COLUMN id SET DEFAULT nextval('notes_id_seq'::regclass);
1286 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1289 ALTER TABLE ONLY oauth_nonces ALTER COLUMN id SET DEFAULT nextval('oauth_nonces_id_seq'::regclass);
1293 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1296 ALTER TABLE ONLY oauth_tokens ALTER COLUMN id SET DEFAULT nextval('oauth_tokens_id_seq'::regclass);
1300 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1303 ALTER TABLE ONLY redactions ALTER COLUMN id SET DEFAULT nextval('redactions_id_seq'::regclass);
1307 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1310 ALTER TABLE ONLY user_blocks ALTER COLUMN id SET DEFAULT nextval('user_blocks_id_seq'::regclass);
1314 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1317 ALTER TABLE ONLY user_roles ALTER COLUMN id SET DEFAULT nextval('user_roles_id_seq'::regclass);
1321 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1324 ALTER TABLE ONLY user_tokens ALTER COLUMN id SET DEFAULT nextval('user_tokens_id_seq'::regclass);
1328 -- Name: id; Type: DEFAULT; Schema: public; Owner: -
1331 ALTER TABLE ONLY users ALTER COLUMN id SET DEFAULT nextval('users_id_seq'::regclass);
1335 -- Name: acls_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1338 ALTER TABLE ONLY acls
1339 ADD CONSTRAINT acls_pkey PRIMARY KEY (id);
1343 -- Name: changeset_comments_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1346 ALTER TABLE ONLY changeset_comments
1347 ADD CONSTRAINT changeset_comments_pkey PRIMARY KEY (id);
1351 -- Name: changesets_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1354 ALTER TABLE ONLY changesets
1355 ADD CONSTRAINT changesets_pkey PRIMARY KEY (id);
1359 -- Name: client_applications_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1362 ALTER TABLE ONLY client_applications
1363 ADD CONSTRAINT client_applications_pkey PRIMARY KEY (id);
1367 -- Name: current_node_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1370 ALTER TABLE ONLY current_node_tags
1371 ADD CONSTRAINT current_node_tags_pkey PRIMARY KEY (node_id, k);
1375 -- Name: current_nodes_pkey1; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1378 ALTER TABLE ONLY current_nodes
1379 ADD CONSTRAINT current_nodes_pkey1 PRIMARY KEY (id);
1383 -- Name: current_relation_members_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1386 ALTER TABLE ONLY current_relation_members
1387 ADD CONSTRAINT current_relation_members_pkey PRIMARY KEY (relation_id, member_type, member_id, member_role, sequence_id);
1391 -- Name: current_relation_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1394 ALTER TABLE ONLY current_relation_tags
1395 ADD CONSTRAINT current_relation_tags_pkey PRIMARY KEY (relation_id, k);
1399 -- Name: current_relations_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1402 ALTER TABLE ONLY current_relations
1403 ADD CONSTRAINT current_relations_pkey PRIMARY KEY (id);
1407 -- Name: current_way_nodes_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1410 ALTER TABLE ONLY current_way_nodes
1411 ADD CONSTRAINT current_way_nodes_pkey PRIMARY KEY (way_id, sequence_id);
1415 -- Name: current_way_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1418 ALTER TABLE ONLY current_way_tags
1419 ADD CONSTRAINT current_way_tags_pkey PRIMARY KEY (way_id, k);
1423 -- Name: current_ways_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1426 ALTER TABLE ONLY current_ways
1427 ADD CONSTRAINT current_ways_pkey PRIMARY KEY (id);
1431 -- Name: diary_comments_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1434 ALTER TABLE ONLY diary_comments
1435 ADD CONSTRAINT diary_comments_pkey PRIMARY KEY (id);
1439 -- Name: diary_entries_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1442 ALTER TABLE ONLY diary_entries
1443 ADD CONSTRAINT diary_entries_pkey PRIMARY KEY (id);
1447 -- Name: friends_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1450 ALTER TABLE ONLY friends
1451 ADD CONSTRAINT friends_pkey PRIMARY KEY (id);
1455 -- Name: gpx_file_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1458 ALTER TABLE ONLY gpx_file_tags
1459 ADD CONSTRAINT gpx_file_tags_pkey PRIMARY KEY (id);
1463 -- Name: gpx_files_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1466 ALTER TABLE ONLY gpx_files
1467 ADD CONSTRAINT gpx_files_pkey PRIMARY KEY (id);
1471 -- Name: languages_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1474 ALTER TABLE ONLY languages
1475 ADD CONSTRAINT languages_pkey PRIMARY KEY (code);
1479 -- Name: messages_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1482 ALTER TABLE ONLY messages
1483 ADD CONSTRAINT messages_pkey PRIMARY KEY (id);
1487 -- Name: node_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1490 ALTER TABLE ONLY node_tags
1491 ADD CONSTRAINT node_tags_pkey PRIMARY KEY (node_id, version, k);
1495 -- Name: nodes_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1498 ALTER TABLE ONLY nodes
1499 ADD CONSTRAINT nodes_pkey PRIMARY KEY (node_id, version);
1503 -- Name: note_comments_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1506 ALTER TABLE ONLY note_comments
1507 ADD CONSTRAINT note_comments_pkey PRIMARY KEY (id);
1511 -- Name: notes_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1514 ALTER TABLE ONLY notes
1515 ADD CONSTRAINT notes_pkey PRIMARY KEY (id);
1519 -- Name: oauth_nonces_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1522 ALTER TABLE ONLY oauth_nonces
1523 ADD CONSTRAINT oauth_nonces_pkey PRIMARY KEY (id);
1527 -- Name: oauth_tokens_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1530 ALTER TABLE ONLY oauth_tokens
1531 ADD CONSTRAINT oauth_tokens_pkey PRIMARY KEY (id);
1535 -- Name: redactions_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1538 ALTER TABLE ONLY redactions
1539 ADD CONSTRAINT redactions_pkey PRIMARY KEY (id);
1543 -- Name: relation_members_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1546 ALTER TABLE ONLY relation_members
1547 ADD CONSTRAINT relation_members_pkey PRIMARY KEY (relation_id, version, member_type, member_id, member_role, sequence_id);
1551 -- Name: relation_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1554 ALTER TABLE ONLY relation_tags
1555 ADD CONSTRAINT relation_tags_pkey PRIMARY KEY (relation_id, version, k);
1559 -- Name: relations_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1562 ALTER TABLE ONLY relations
1563 ADD CONSTRAINT relations_pkey PRIMARY KEY (relation_id, version);
1567 -- Name: user_blocks_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1570 ALTER TABLE ONLY user_blocks
1571 ADD CONSTRAINT user_blocks_pkey PRIMARY KEY (id);
1575 -- Name: user_preferences_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1578 ALTER TABLE ONLY user_preferences
1579 ADD CONSTRAINT user_preferences_pkey PRIMARY KEY (user_id, k);
1583 -- Name: user_roles_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1586 ALTER TABLE ONLY user_roles
1587 ADD CONSTRAINT user_roles_pkey PRIMARY KEY (id);
1591 -- Name: user_tokens_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1594 ALTER TABLE ONLY user_tokens
1595 ADD CONSTRAINT user_tokens_pkey PRIMARY KEY (id);
1599 -- Name: users_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1602 ALTER TABLE ONLY users
1603 ADD CONSTRAINT users_pkey PRIMARY KEY (id);
1607 -- Name: way_nodes_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1610 ALTER TABLE ONLY way_nodes
1611 ADD CONSTRAINT way_nodes_pkey PRIMARY KEY (way_id, version, sequence_id);
1615 -- Name: way_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1618 ALTER TABLE ONLY way_tags
1619 ADD CONSTRAINT way_tags_pkey PRIMARY KEY (way_id, version, k);
1623 -- Name: ways_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace:
1626 ALTER TABLE ONLY ways
1627 ADD CONSTRAINT ways_pkey PRIMARY KEY (way_id, version);
1631 -- Name: acls_k_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1634 CREATE INDEX acls_k_idx ON acls USING btree (k);
1638 -- Name: changeset_tags_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1641 CREATE INDEX changeset_tags_id_idx ON changeset_tags USING btree (changeset_id);
1645 -- Name: changesets_bbox_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1648 CREATE INDEX changesets_bbox_idx ON changesets USING gist (min_lat, max_lat, min_lon, max_lon);
1652 -- Name: changesets_closed_at_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1655 CREATE INDEX changesets_closed_at_idx ON changesets USING btree (closed_at);
1659 -- Name: changesets_created_at_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1662 CREATE INDEX changesets_created_at_idx ON changesets USING btree (created_at);
1666 -- Name: changesets_user_id_created_at_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1669 CREATE INDEX changesets_user_id_created_at_idx ON changesets USING btree (user_id, created_at);
1673 -- Name: changesets_user_id_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1676 CREATE INDEX changesets_user_id_id_idx ON changesets USING btree (user_id, id);
1680 -- Name: current_nodes_tile_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1683 CREATE INDEX current_nodes_tile_idx ON current_nodes USING btree (tile);
1687 -- Name: current_nodes_timestamp_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1690 CREATE INDEX current_nodes_timestamp_idx ON current_nodes USING btree ("timestamp");
1694 -- Name: current_relation_members_member_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1697 CREATE INDEX current_relation_members_member_idx ON current_relation_members USING btree (member_type, member_id);
1701 -- Name: current_relations_timestamp_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1704 CREATE INDEX current_relations_timestamp_idx ON current_relations USING btree ("timestamp");
1708 -- Name: current_way_nodes_node_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1711 CREATE INDEX current_way_nodes_node_idx ON current_way_nodes USING btree (node_id);
1715 -- Name: current_ways_timestamp_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1718 CREATE INDEX current_ways_timestamp_idx ON current_ways USING btree ("timestamp");
1722 -- Name: diary_comment_user_id_created_at_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
1725 CREATE INDEX diary_comment_user_id_created_at_index ON diary_comments USING btree (user_id, created_at);
1729 -- Name: diary_comments_entry_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1732 CREATE UNIQUE INDEX diary_comments_entry_id_idx ON diary_comments USING btree (diary_entry_id, id);
1736 -- Name: diary_entry_created_at_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
1739 CREATE INDEX diary_entry_created_at_index ON diary_entries USING btree (created_at);
1743 -- Name: diary_entry_language_code_created_at_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
1746 CREATE INDEX diary_entry_language_code_created_at_index ON diary_entries USING btree (language_code, created_at);
1750 -- Name: diary_entry_user_id_created_at_index; Type: INDEX; Schema: public; Owner: -; Tablespace:
1753 CREATE INDEX diary_entry_user_id_created_at_index ON diary_entries USING btree (user_id, created_at);
1757 -- Name: friends_user_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1760 CREATE INDEX friends_user_id_idx ON friends USING btree (user_id);
1764 -- Name: gpx_file_tags_gpxid_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1767 CREATE INDEX gpx_file_tags_gpxid_idx ON gpx_file_tags USING btree (gpx_id);
1771 -- Name: gpx_file_tags_tag_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1774 CREATE INDEX gpx_file_tags_tag_idx ON gpx_file_tags USING btree (tag);
1778 -- Name: gpx_files_timestamp_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1781 CREATE INDEX gpx_files_timestamp_idx ON gpx_files USING btree ("timestamp");
1785 -- Name: gpx_files_user_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1788 CREATE INDEX gpx_files_user_id_idx ON gpx_files USING btree (user_id);
1792 -- Name: gpx_files_visible_visibility_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1795 CREATE INDEX gpx_files_visible_visibility_idx ON gpx_files USING btree (visible, visibility);
1799 -- Name: index_changeset_comments_on_created_at; Type: INDEX; Schema: public; Owner: -; Tablespace:
1802 CREATE INDEX index_changeset_comments_on_created_at ON changeset_comments USING btree (created_at);
1806 -- Name: index_changesets_subscribers_on_changeset_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
1809 CREATE INDEX index_changesets_subscribers_on_changeset_id ON changesets_subscribers USING btree (changeset_id);
1813 -- Name: index_changesets_subscribers_on_subscriber_id_and_changeset_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
1816 CREATE UNIQUE INDEX index_changesets_subscribers_on_subscriber_id_and_changeset_id ON changesets_subscribers USING btree (subscriber_id, changeset_id);
1820 -- Name: index_client_applications_on_key; Type: INDEX; Schema: public; Owner: -; Tablespace:
1823 CREATE UNIQUE INDEX index_client_applications_on_key ON client_applications USING btree (key);
1827 -- Name: index_note_comments_on_body; Type: INDEX; Schema: public; Owner: -; Tablespace:
1830 CREATE INDEX index_note_comments_on_body ON note_comments USING gin (to_tsvector('english'::regconfig, body));
1834 -- Name: index_note_comments_on_created_at; Type: INDEX; Schema: public; Owner: -; Tablespace:
1837 CREATE INDEX index_note_comments_on_created_at ON note_comments USING btree (created_at);
1841 -- Name: index_oauth_nonces_on_nonce_and_timestamp; Type: INDEX; Schema: public; Owner: -; Tablespace:
1844 CREATE UNIQUE INDEX index_oauth_nonces_on_nonce_and_timestamp ON oauth_nonces USING btree (nonce, "timestamp");
1848 -- Name: index_oauth_tokens_on_token; Type: INDEX; Schema: public; Owner: -; Tablespace:
1851 CREATE UNIQUE INDEX index_oauth_tokens_on_token ON oauth_tokens USING btree (token);
1855 -- Name: index_user_blocks_on_user_id; Type: INDEX; Schema: public; Owner: -; Tablespace:
1858 CREATE INDEX index_user_blocks_on_user_id ON user_blocks USING btree (user_id);
1862 -- Name: messages_from_user_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1865 CREATE INDEX messages_from_user_id_idx ON messages USING btree (from_user_id);
1869 -- Name: messages_to_user_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1872 CREATE INDEX messages_to_user_id_idx ON messages USING btree (to_user_id);
1876 -- Name: nodes_changeset_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1879 CREATE INDEX nodes_changeset_id_idx ON nodes USING btree (changeset_id);
1883 -- Name: nodes_tile_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1886 CREATE INDEX nodes_tile_idx ON nodes USING btree (tile);
1890 -- Name: nodes_timestamp_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1893 CREATE INDEX nodes_timestamp_idx ON nodes USING btree ("timestamp");
1897 -- Name: note_comments_note_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1900 CREATE INDEX note_comments_note_id_idx ON note_comments USING btree (note_id);
1904 -- Name: notes_created_at_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1907 CREATE INDEX notes_created_at_idx ON notes USING btree (created_at);
1911 -- Name: notes_tile_status_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1914 CREATE INDEX notes_tile_status_idx ON notes USING btree (tile, status);
1918 -- Name: notes_updated_at_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1921 CREATE INDEX notes_updated_at_idx ON notes USING btree (updated_at);
1925 -- Name: points_gpxid_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1928 CREATE INDEX points_gpxid_idx ON gps_points USING btree (gpx_id);
1932 -- Name: points_tile_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1935 CREATE INDEX points_tile_idx ON gps_points USING btree (tile);
1939 -- Name: relation_members_member_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1942 CREATE INDEX relation_members_member_idx ON relation_members USING btree (member_type, member_id);
1946 -- Name: relations_changeset_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1949 CREATE INDEX relations_changeset_id_idx ON relations USING btree (changeset_id);
1953 -- Name: relations_timestamp_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1956 CREATE INDEX relations_timestamp_idx ON relations USING btree ("timestamp");
1960 -- Name: unique_schema_migrations; Type: INDEX; Schema: public; Owner: -; Tablespace:
1963 CREATE UNIQUE INDEX unique_schema_migrations ON schema_migrations USING btree (version);
1967 -- Name: user_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1970 CREATE INDEX user_id_idx ON friends USING btree (friend_user_id);
1974 -- Name: user_openid_url_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1977 CREATE UNIQUE INDEX user_openid_url_idx ON users USING btree (openid_url);
1981 -- Name: user_roles_id_role_unique; Type: INDEX; Schema: public; Owner: -; Tablespace:
1984 CREATE UNIQUE INDEX user_roles_id_role_unique ON user_roles USING btree (user_id, role);
1988 -- Name: user_tokens_token_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1991 CREATE UNIQUE INDEX user_tokens_token_idx ON user_tokens USING btree (token);
1995 -- Name: user_tokens_user_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
1998 CREATE INDEX user_tokens_user_id_idx ON user_tokens USING btree (user_id);
2002 -- Name: users_display_name_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2005 CREATE UNIQUE INDEX users_display_name_idx ON users USING btree (display_name);
2009 -- Name: users_display_name_lower_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2012 CREATE INDEX users_display_name_lower_idx ON users USING btree (lower((display_name)::text));
2016 -- Name: users_email_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2019 CREATE UNIQUE INDEX users_email_idx ON users USING btree (email);
2023 -- Name: users_email_lower_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2026 CREATE INDEX users_email_lower_idx ON users USING btree (lower((email)::text));
2030 -- Name: way_nodes_node_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2033 CREATE INDEX way_nodes_node_idx ON way_nodes USING btree (node_id);
2037 -- Name: ways_changeset_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2040 CREATE INDEX ways_changeset_id_idx ON ways USING btree (changeset_id);
2044 -- Name: ways_timestamp_idx; Type: INDEX; Schema: public; Owner: -; Tablespace:
2047 CREATE INDEX ways_timestamp_idx ON ways USING btree ("timestamp");
2051 -- Name: changeset_comments_author_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2054 ALTER TABLE ONLY changeset_comments
2055 ADD CONSTRAINT changeset_comments_author_id_fkey FOREIGN KEY (author_id) REFERENCES users(id);
2059 -- Name: changeset_comments_changeset_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2062 ALTER TABLE ONLY changeset_comments
2063 ADD CONSTRAINT changeset_comments_changeset_id_fkey FOREIGN KEY (changeset_id) REFERENCES changesets(id);
2067 -- Name: changeset_tags_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2070 ALTER TABLE ONLY changeset_tags
2071 ADD CONSTRAINT changeset_tags_id_fkey FOREIGN KEY (changeset_id) REFERENCES changesets(id);
2075 -- Name: changesets_subscribers_changeset_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2078 ALTER TABLE ONLY changesets_subscribers
2079 ADD CONSTRAINT changesets_subscribers_changeset_id_fkey FOREIGN KEY (changeset_id) REFERENCES changesets(id);
2083 -- Name: changesets_subscribers_subscriber_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2086 ALTER TABLE ONLY changesets_subscribers
2087 ADD CONSTRAINT changesets_subscribers_subscriber_id_fkey FOREIGN KEY (subscriber_id) REFERENCES users(id);
2091 -- Name: changesets_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2094 ALTER TABLE ONLY changesets
2095 ADD CONSTRAINT changesets_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);
2099 -- Name: client_applications_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2102 ALTER TABLE ONLY client_applications
2103 ADD CONSTRAINT client_applications_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);
2107 -- Name: current_node_tags_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2110 ALTER TABLE ONLY current_node_tags
2111 ADD CONSTRAINT current_node_tags_id_fkey FOREIGN KEY (node_id) REFERENCES current_nodes(id);
2115 -- Name: current_nodes_changeset_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2118 ALTER TABLE ONLY current_nodes
2119 ADD CONSTRAINT current_nodes_changeset_id_fkey FOREIGN KEY (changeset_id) REFERENCES changesets(id);
2123 -- Name: current_relation_members_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2126 ALTER TABLE ONLY current_relation_members
2127 ADD CONSTRAINT current_relation_members_id_fkey FOREIGN KEY (relation_id) REFERENCES current_relations(id);
2131 -- Name: current_relation_tags_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2134 ALTER TABLE ONLY current_relation_tags
2135 ADD CONSTRAINT current_relation_tags_id_fkey FOREIGN KEY (relation_id) REFERENCES current_relations(id);
2139 -- Name: current_relations_changeset_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2142 ALTER TABLE ONLY current_relations
2143 ADD CONSTRAINT current_relations_changeset_id_fkey FOREIGN KEY (changeset_id) REFERENCES changesets(id);
2147 -- Name: current_way_nodes_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2150 ALTER TABLE ONLY current_way_nodes
2151 ADD CONSTRAINT current_way_nodes_id_fkey FOREIGN KEY (way_id) REFERENCES current_ways(id);
2155 -- Name: current_way_nodes_node_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2158 ALTER TABLE ONLY current_way_nodes
2159 ADD CONSTRAINT current_way_nodes_node_id_fkey FOREIGN KEY (node_id) REFERENCES current_nodes(id);
2163 -- Name: current_way_tags_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2166 ALTER TABLE ONLY current_way_tags
2167 ADD CONSTRAINT current_way_tags_id_fkey FOREIGN KEY (way_id) REFERENCES current_ways(id);
2171 -- Name: current_ways_changeset_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2174 ALTER TABLE ONLY current_ways
2175 ADD CONSTRAINT current_ways_changeset_id_fkey FOREIGN KEY (changeset_id) REFERENCES changesets(id);
2179 -- Name: diary_comments_diary_entry_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2182 ALTER TABLE ONLY diary_comments
2183 ADD CONSTRAINT diary_comments_diary_entry_id_fkey FOREIGN KEY (diary_entry_id) REFERENCES diary_entries(id);
2187 -- Name: diary_comments_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2190 ALTER TABLE ONLY diary_comments
2191 ADD CONSTRAINT diary_comments_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);
2195 -- Name: diary_entries_language_code_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2198 ALTER TABLE ONLY diary_entries
2199 ADD CONSTRAINT diary_entries_language_code_fkey FOREIGN KEY (language_code) REFERENCES languages(code);
2203 -- Name: diary_entries_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2206 ALTER TABLE ONLY diary_entries
2207 ADD CONSTRAINT diary_entries_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);
2211 -- Name: friends_friend_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2214 ALTER TABLE ONLY friends
2215 ADD CONSTRAINT friends_friend_user_id_fkey FOREIGN KEY (friend_user_id) REFERENCES users(id);
2219 -- Name: friends_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2222 ALTER TABLE ONLY friends
2223 ADD CONSTRAINT friends_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);
2227 -- Name: gps_points_gpx_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2230 ALTER TABLE ONLY gps_points
2231 ADD CONSTRAINT gps_points_gpx_id_fkey FOREIGN KEY (gpx_id) REFERENCES gpx_files(id);
2235 -- Name: gpx_file_tags_gpx_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2238 ALTER TABLE ONLY gpx_file_tags
2239 ADD CONSTRAINT gpx_file_tags_gpx_id_fkey FOREIGN KEY (gpx_id) REFERENCES gpx_files(id);
2243 -- Name: gpx_files_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2246 ALTER TABLE ONLY gpx_files
2247 ADD CONSTRAINT gpx_files_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);
2251 -- Name: messages_from_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2254 ALTER TABLE ONLY messages
2255 ADD CONSTRAINT messages_from_user_id_fkey FOREIGN KEY (from_user_id) REFERENCES users(id);
2259 -- Name: messages_to_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2262 ALTER TABLE ONLY messages
2263 ADD CONSTRAINT messages_to_user_id_fkey FOREIGN KEY (to_user_id) REFERENCES users(id);
2267 -- Name: node_tags_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2270 ALTER TABLE ONLY node_tags
2271 ADD CONSTRAINT node_tags_id_fkey FOREIGN KEY (node_id, version) REFERENCES nodes(node_id, version);
2275 -- Name: nodes_changeset_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2278 ALTER TABLE ONLY nodes
2279 ADD CONSTRAINT nodes_changeset_id_fkey FOREIGN KEY (changeset_id) REFERENCES changesets(id);
2283 -- Name: nodes_redaction_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2286 ALTER TABLE ONLY nodes
2287 ADD CONSTRAINT nodes_redaction_id_fkey FOREIGN KEY (redaction_id) REFERENCES redactions(id);
2291 -- Name: note_comments_author_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2294 ALTER TABLE ONLY note_comments
2295 ADD CONSTRAINT note_comments_author_id_fkey FOREIGN KEY (author_id) REFERENCES users(id);
2299 -- Name: note_comments_note_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2302 ALTER TABLE ONLY note_comments
2303 ADD CONSTRAINT note_comments_note_id_fkey FOREIGN KEY (note_id) REFERENCES notes(id);
2307 -- Name: oauth_tokens_client_application_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2310 ALTER TABLE ONLY oauth_tokens
2311 ADD CONSTRAINT oauth_tokens_client_application_id_fkey FOREIGN KEY (client_application_id) REFERENCES client_applications(id);
2315 -- Name: oauth_tokens_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2318 ALTER TABLE ONLY oauth_tokens
2319 ADD CONSTRAINT oauth_tokens_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);
2323 -- Name: redactions_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2326 ALTER TABLE ONLY redactions
2327 ADD CONSTRAINT redactions_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);
2331 -- Name: relation_members_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2334 ALTER TABLE ONLY relation_members
2335 ADD CONSTRAINT relation_members_id_fkey FOREIGN KEY (relation_id, version) REFERENCES relations(relation_id, version);
2339 -- Name: relation_tags_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2342 ALTER TABLE ONLY relation_tags
2343 ADD CONSTRAINT relation_tags_id_fkey FOREIGN KEY (relation_id, version) REFERENCES relations(relation_id, version);
2347 -- Name: relations_changeset_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2350 ALTER TABLE ONLY relations
2351 ADD CONSTRAINT relations_changeset_id_fkey FOREIGN KEY (changeset_id) REFERENCES changesets(id);
2355 -- Name: relations_redaction_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2358 ALTER TABLE ONLY relations
2359 ADD CONSTRAINT relations_redaction_id_fkey FOREIGN KEY (redaction_id) REFERENCES redactions(id);
2363 -- Name: user_blocks_moderator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2366 ALTER TABLE ONLY user_blocks
2367 ADD CONSTRAINT user_blocks_moderator_id_fkey FOREIGN KEY (creator_id) REFERENCES users(id);
2371 -- Name: user_blocks_revoker_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2374 ALTER TABLE ONLY user_blocks
2375 ADD CONSTRAINT user_blocks_revoker_id_fkey FOREIGN KEY (revoker_id) REFERENCES users(id);
2379 -- Name: user_blocks_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2382 ALTER TABLE ONLY user_blocks
2383 ADD CONSTRAINT user_blocks_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);
2387 -- Name: user_preferences_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2390 ALTER TABLE ONLY user_preferences
2391 ADD CONSTRAINT user_preferences_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);
2395 -- Name: user_roles_granter_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2398 ALTER TABLE ONLY user_roles
2399 ADD CONSTRAINT user_roles_granter_id_fkey FOREIGN KEY (granter_id) REFERENCES users(id);
2403 -- Name: user_roles_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2406 ALTER TABLE ONLY user_roles
2407 ADD CONSTRAINT user_roles_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);
2411 -- Name: user_tokens_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2414 ALTER TABLE ONLY user_tokens
2415 ADD CONSTRAINT user_tokens_user_id_fkey FOREIGN KEY (user_id) REFERENCES users(id);
2419 -- Name: way_nodes_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2422 ALTER TABLE ONLY way_nodes
2423 ADD CONSTRAINT way_nodes_id_fkey FOREIGN KEY (way_id, version) REFERENCES ways(way_id, version);
2427 -- Name: way_tags_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2430 ALTER TABLE ONLY way_tags
2431 ADD CONSTRAINT way_tags_id_fkey FOREIGN KEY (way_id, version) REFERENCES ways(way_id, version);
2435 -- Name: ways_changeset_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2438 ALTER TABLE ONLY ways
2439 ADD CONSTRAINT ways_changeset_id_fkey FOREIGN KEY (changeset_id) REFERENCES changesets(id);
2443 -- Name: ways_redaction_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
2446 ALTER TABLE ONLY ways
2447 ADD CONSTRAINT ways_redaction_id_fkey FOREIGN KEY (redaction_id) REFERENCES redactions(id);
2451 -- PostgreSQL database dump complete
2454 SET search_path TO "$user",public;
2456 INSERT INTO schema_migrations (version) VALUES ('1');
2458 INSERT INTO schema_migrations (version) VALUES ('10');
2460 INSERT INTO schema_migrations (version) VALUES ('11');
2462 INSERT INTO schema_migrations (version) VALUES ('12');
2464 INSERT INTO schema_migrations (version) VALUES ('13');
2466 INSERT INTO schema_migrations (version) VALUES ('14');
2468 INSERT INTO schema_migrations (version) VALUES ('15');
2470 INSERT INTO schema_migrations (version) VALUES ('16');
2472 INSERT INTO schema_migrations (version) VALUES ('17');
2474 INSERT INTO schema_migrations (version) VALUES ('18');
2476 INSERT INTO schema_migrations (version) VALUES ('19');
2478 INSERT INTO schema_migrations (version) VALUES ('2');
2480 INSERT INTO schema_migrations (version) VALUES ('20');
2482 INSERT INTO schema_migrations (version) VALUES ('20100513171259');
2484 INSERT INTO schema_migrations (version) VALUES ('20100516124737');
2486 INSERT INTO schema_migrations (version) VALUES ('20100910084426');
2488 INSERT INTO schema_migrations (version) VALUES ('20101114011429');
2490 INSERT INTO schema_migrations (version) VALUES ('20110322001319');
2492 INSERT INTO schema_migrations (version) VALUES ('20110508145337');
2494 INSERT INTO schema_migrations (version) VALUES ('20110521142405');
2496 INSERT INTO schema_migrations (version) VALUES ('20110925112722');
2498 INSERT INTO schema_migrations (version) VALUES ('20111116184519');
2500 INSERT INTO schema_migrations (version) VALUES ('20111212183945');
2502 INSERT INTO schema_migrations (version) VALUES ('20120123184321');
2504 INSERT INTO schema_migrations (version) VALUES ('20120208122334');
2506 INSERT INTO schema_migrations (version) VALUES ('20120208194454');
2508 INSERT INTO schema_migrations (version) VALUES ('20120214210114');
2510 INSERT INTO schema_migrations (version) VALUES ('20120219161649');
2512 INSERT INTO schema_migrations (version) VALUES ('20120318201948');
2514 INSERT INTO schema_migrations (version) VALUES ('20120328090602');
2516 INSERT INTO schema_migrations (version) VALUES ('20120404205604');
2518 INSERT INTO schema_migrations (version) VALUES ('20120808231205');
2520 INSERT INTO schema_migrations (version) VALUES ('20121005195010');
2522 INSERT INTO schema_migrations (version) VALUES ('20121012044047');
2524 INSERT INTO schema_migrations (version) VALUES ('20121119165817');
2526 INSERT INTO schema_migrations (version) VALUES ('20121202155309');
2528 INSERT INTO schema_migrations (version) VALUES ('20121203124841');
2530 INSERT INTO schema_migrations (version) VALUES ('20130328184137');
2532 INSERT INTO schema_migrations (version) VALUES ('20131212124700');
2534 INSERT INTO schema_migrations (version) VALUES ('20140115192822');
2536 INSERT INTO schema_migrations (version) VALUES ('20140117185510');
2538 INSERT INTO schema_migrations (version) VALUES ('20140210003018');
2540 INSERT INTO schema_migrations (version) VALUES ('20140507110937');
2542 INSERT INTO schema_migrations (version) VALUES ('20140519141742');
2544 INSERT INTO schema_migrations (version) VALUES ('20150110152606');
2546 INSERT INTO schema_migrations (version) VALUES ('21');
2548 INSERT INTO schema_migrations (version) VALUES ('22');
2550 INSERT INTO schema_migrations (version) VALUES ('23');
2552 INSERT INTO schema_migrations (version) VALUES ('24');
2554 INSERT INTO schema_migrations (version) VALUES ('25');
2556 INSERT INTO schema_migrations (version) VALUES ('26');
2558 INSERT INTO schema_migrations (version) VALUES ('27');
2560 INSERT INTO schema_migrations (version) VALUES ('28');
2562 INSERT INTO schema_migrations (version) VALUES ('29');
2564 INSERT INTO schema_migrations (version) VALUES ('3');
2566 INSERT INTO schema_migrations (version) VALUES ('30');
2568 INSERT INTO schema_migrations (version) VALUES ('31');
2570 INSERT INTO schema_migrations (version) VALUES ('32');
2572 INSERT INTO schema_migrations (version) VALUES ('33');
2574 INSERT INTO schema_migrations (version) VALUES ('34');
2576 INSERT INTO schema_migrations (version) VALUES ('35');
2578 INSERT INTO schema_migrations (version) VALUES ('36');
2580 INSERT INTO schema_migrations (version) VALUES ('37');
2582 INSERT INTO schema_migrations (version) VALUES ('38');
2584 INSERT INTO schema_migrations (version) VALUES ('39');
2586 INSERT INTO schema_migrations (version) VALUES ('4');
2588 INSERT INTO schema_migrations (version) VALUES ('40');
2590 INSERT INTO schema_migrations (version) VALUES ('41');
2592 INSERT INTO schema_migrations (version) VALUES ('42');
2594 INSERT INTO schema_migrations (version) VALUES ('43');
2596 INSERT INTO schema_migrations (version) VALUES ('44');
2598 INSERT INTO schema_migrations (version) VALUES ('45');
2600 INSERT INTO schema_migrations (version) VALUES ('46');
2602 INSERT INTO schema_migrations (version) VALUES ('47');
2604 INSERT INTO schema_migrations (version) VALUES ('48');
2606 INSERT INTO schema_migrations (version) VALUES ('49');
2608 INSERT INTO schema_migrations (version) VALUES ('5');
2610 INSERT INTO schema_migrations (version) VALUES ('50');
2612 INSERT INTO schema_migrations (version) VALUES ('51');
2614 INSERT INTO schema_migrations (version) VALUES ('52');
2616 INSERT INTO schema_migrations (version) VALUES ('53');
2618 INSERT INTO schema_migrations (version) VALUES ('54');
2620 INSERT INTO schema_migrations (version) VALUES ('55');
2622 INSERT INTO schema_migrations (version) VALUES ('56');
2624 INSERT INTO schema_migrations (version) VALUES ('57');
2626 INSERT INTO schema_migrations (version) VALUES ('6');
2628 INSERT INTO schema_migrations (version) VALUES ('7');
2630 INSERT INTO schema_migrations (version) VALUES ('8');
2632 INSERT INTO schema_migrations (version) VALUES ('9');