diff options
| author | Dan Goodliffe <dan@randomdan.homeip.net> | 2021-07-31 12:53:52 +0100 |
|---|---|---|
| committer | Dan Goodliffe <dan@randomdan.homeip.net> | 2021-07-31 12:53:52 +0100 |
| commit | b72ae9cc0a98d60324c758eee22125e49fce223f (patch) | |
| tree | b4540e363e6464b9ecc9a952f90434e168c755d8 /db | |
| parent | Support the rotate event to move to the next binlog file (diff) | |
| download | mygrate-b72ae9cc0a98d60324c758eee22125e49fce223f.tar.bz2 mygrate-b72ae9cc0a98d60324c758eee22125e49fce223f.tar.xz mygrate-b72ae9cc0a98d60324c758eee22125e49fce223f.zip | |
Copy table content in a TX as part of add table
Diffstat (limited to 'db')
| -rw-r--r-- | db/schema.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/db/schema.sql b/db/schema.sql index 11b8259..086dbf8 100644 --- a/db/schema.sql +++ b/db/schema.sql @@ -92,7 +92,9 @@ ALTER TABLE mygrate.table_columns ALTER COLUMN column_id ADD GENERATED ALWAYS AS CREATE TABLE mygrate.tables ( table_id integer NOT NULL, table_name name NOT NULL, - source_id integer NOT NULL + source_id integer NOT NULL, + start_file text NOT NULL, + start_position bigint NOT NULL ); |