summaryrefslogtreecommitdiff
path: root/db/schema.sql
blob: 086dbf8120a859abd040acb592b96ea04dfa1ab1 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
--
-- PostgreSQL database dump
--

-- Dumped from database version 12.7
-- Dumped by pg_dump version 13.3

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 xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- Name: mygrate; Type: SCHEMA; Schema: -; Owner: -
--

CREATE SCHEMA mygrate;


SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- Name: source; Type: TABLE; Schema: mygrate; Owner: -
--

CREATE TABLE mygrate.source (
    source_id integer NOT NULL,
    host text NOT NULL,
    username text NOT NULL,
    password text NOT NULL,
    port integer NOT NULL,
    database text NOT NULL,
    filename text NOT NULL,
    "position" bigint NOT NULL,
    serverid integer NOT NULL,
    table_schema name NOT NULL COLLATE pg_catalog."default"
);


--
-- Name: source_id_seq; Type: SEQUENCE; Schema: mygrate; Owner: -
--

ALTER TABLE mygrate.source ALTER COLUMN source_id ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME mygrate.source_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: table_columns; Type: TABLE; Schema: mygrate; Owner: -
--

CREATE TABLE mygrate.table_columns (
    column_id integer NOT NULL,
    column_name name NOT NULL,
    mysql_ordinal integer NOT NULL,
    table_id integer NOT NULL
);


--
-- Name: table_columns_column_id_seq1; Type: SEQUENCE; Schema: mygrate; Owner: -
--

ALTER TABLE mygrate.table_columns ALTER COLUMN column_id ADD GENERATED ALWAYS AS IDENTITY (
    SEQUENCE NAME mygrate.table_columns_column_id_seq1
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: tables; Type: TABLE; Schema: mygrate; Owner: -
--

CREATE TABLE mygrate.tables (
    table_id integer NOT NULL,
    table_name name NOT NULL,
    source_id integer NOT NULL,
		start_file text NOT NULL,
		start_position bigint NOT NULL
);


--
-- Name: tables_table_id_seq1; Type: SEQUENCE; Schema: mygrate; Owner: -
--

ALTER TABLE mygrate.tables ALTER COLUMN table_id ADD GENERATED ALWAYS AS IDENTITY (
    SEQUENCE NAME mygrate.tables_table_id_seq1
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- Name: table_columns pk_table_columns; Type: CONSTRAINT; Schema: mygrate; Owner: -
--

ALTER TABLE ONLY mygrate.table_columns
    ADD CONSTRAINT pk_table_columns PRIMARY KEY (column_id);


--
-- Name: tables pk_tables; Type: CONSTRAINT; Schema: mygrate; Owner: -
--

ALTER TABLE ONLY mygrate.tables
    ADD CONSTRAINT pk_tables PRIMARY KEY (table_id);


--
-- Name: source source_pkey; Type: CONSTRAINT; Schema: mygrate; Owner: -
--

ALTER TABLE ONLY mygrate.source
    ADD CONSTRAINT source_pkey PRIMARY KEY (source_id);


--
-- Name: source uni_schema; Type: CONSTRAINT; Schema: mygrate; Owner: -
--

ALTER TABLE ONLY mygrate.source
    ADD CONSTRAINT uni_schema UNIQUE (table_schema);


--
-- Name: tables uni_source_table; Type: CONSTRAINT; Schema: mygrate; Owner: -
--

ALTER TABLE ONLY mygrate.tables
    ADD CONSTRAINT uni_source_table UNIQUE (source_id, table_name);


--
-- Name: table_columns uni_table_columnname; Type: CONSTRAINT; Schema: mygrate; Owner: -
--

ALTER TABLE ONLY mygrate.table_columns
    ADD CONSTRAINT uni_table_columnname UNIQUE (table_id, column_name);


--
-- Name: table_columns uni_table_columnord; Type: CONSTRAINT; Schema: mygrate; Owner: -
--

ALTER TABLE ONLY mygrate.table_columns
    ADD CONSTRAINT uni_table_columnord UNIQUE (table_id, mysql_ordinal);


--
-- Name: table_columns fk_table_columns_table; Type: FK CONSTRAINT; Schema: mygrate; Owner: -
--

ALTER TABLE ONLY mygrate.table_columns
    ADD CONSTRAINT fk_table_columns_table FOREIGN KEY (table_id) REFERENCES mygrate.tables(table_id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: tables fk_table_source; Type: FK CONSTRAINT; Schema: mygrate; Owner: -
--

ALTER TABLE ONLY mygrate.tables
    ADD CONSTRAINT fk_table_source FOREIGN KEY (table_id) REFERENCES mygrate.source(source_id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- PostgreSQL database dump complete
--