X-Git-Url: https://git.openstreetmap.org./rails.git/blobdiff_plain/f227804093a5a82eaf724f9b028b25aa7cbf41a1..efd50cd529990069dc1ca95f66ec6f61471fe29d:/db/structure.sql diff --git a/db/structure.sql b/db/structure.sql index 48fedeba5..dcab302bb 100644 --- a/db/structure.sql +++ b/db/structure.sql @@ -494,6 +494,45 @@ CREATE SEQUENCE current_ways_id_seq ALTER SEQUENCE current_ways_id_seq OWNED BY current_ways.id; +-- +-- Name: delayed_jobs; Type: TABLE; Schema: public; Owner: - +-- + +CREATE TABLE delayed_jobs ( + id bigint NOT NULL, + priority integer DEFAULT 0 NOT NULL, + attempts integer DEFAULT 0 NOT NULL, + handler text NOT NULL, + last_error text, + run_at timestamp without time zone, + locked_at timestamp without time zone, + failed_at timestamp without time zone, + locked_by character varying, + queue character varying, + created_at timestamp without time zone, + updated_at timestamp without time zone +); + + +-- +-- Name: delayed_jobs_id_seq; Type: SEQUENCE; Schema: public; Owner: - +-- + +CREATE SEQUENCE delayed_jobs_id_seq + START WITH 1 + INCREMENT BY 1 + NO MINVALUE + NO MAXVALUE + CACHE 1; + + +-- +-- Name: delayed_jobs_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - +-- + +ALTER SEQUENCE delayed_jobs_id_seq OWNED BY delayed_jobs.id; + + -- -- Name: diary_comments; Type: TABLE; Schema: public; Owner: - -- @@ -1365,6 +1404,13 @@ ALTER TABLE ONLY current_relations ALTER COLUMN id SET DEFAULT nextval('current_ ALTER TABLE ONLY current_ways ALTER COLUMN id SET DEFAULT nextval('current_ways_id_seq'::regclass); +-- +-- Name: delayed_jobs id; Type: DEFAULT; Schema: public; Owner: - +-- + +ALTER TABLE ONLY delayed_jobs ALTER COLUMN id SET DEFAULT nextval('delayed_jobs_id_seq'::regclass); + + -- -- Name: diary_comments id; Type: DEFAULT; Schema: public; Owner: - -- @@ -1595,6 +1641,14 @@ ALTER TABLE ONLY current_ways ADD CONSTRAINT current_ways_pkey PRIMARY KEY (id); +-- +-- Name: delayed_jobs delayed_jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: - +-- + +ALTER TABLE ONLY delayed_jobs + ADD CONSTRAINT delayed_jobs_pkey PRIMARY KEY (id); + + -- -- Name: diary_comments diary_comments_pkey; Type: CONSTRAINT; Schema: public; Owner: - -- @@ -1918,6 +1972,13 @@ CREATE INDEX current_way_nodes_node_idx ON current_way_nodes USING btree (node_i CREATE INDEX current_ways_timestamp_idx ON current_ways USING btree ("timestamp"); +-- +-- Name: delayed_jobs_priority; Type: INDEX; Schema: public; Owner: - +-- + +CREATE INDEX delayed_jobs_priority ON delayed_jobs USING btree (priority, run_at); + + -- -- Name: diary_comment_user_id_created_at_index; Type: INDEX; Schema: public; Owner: - -- @@ -2870,6 +2931,7 @@ INSERT INTO "schema_migrations" (version) VALUES ('20161011010929'), ('20170222134109'), ('20180204153242'), +('20181031113522'), ('21'), ('22'), ('23'),