summaryrefslogtreecommitdiff
path: root/lib/output/pq/sql/insertTable.sql
diff options
context:
space:
mode:
authorDan Goodliffe <dan@randomdan.homeip.net>2021-07-31 12:53:52 +0100
committerDan Goodliffe <dan@randomdan.homeip.net>2021-07-31 12:53:52 +0100
commitb72ae9cc0a98d60324c758eee22125e49fce223f (patch)
treeb4540e363e6464b9ecc9a952f90434e168c755d8 /lib/output/pq/sql/insertTable.sql
parentSupport the rotate event to move to the next binlog file (diff)
downloadmygrate-b72ae9cc0a98d60324c758eee22125e49fce223f.tar.bz2
mygrate-b72ae9cc0a98d60324c758eee22125e49fce223f.tar.xz
mygrate-b72ae9cc0a98d60324c758eee22125e49fce223f.zip
Copy table content in a TX as part of add table
Diffstat (limited to 'lib/output/pq/sql/insertTable.sql')
-rw-r--r--lib/output/pq/sql/insertTable.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/lib/output/pq/sql/insertTable.sql b/lib/output/pq/sql/insertTable.sql
index 4b559d0..a31b1a1 100644
--- a/lib/output/pq/sql/insertTable.sql
+++ b/lib/output/pq/sql/insertTable.sql
@@ -1,3 +1,3 @@
-INSERT INTO mygrate.tables(table_name, source_id)
-VALUES($1, $2)
+INSERT INTO mygrate.tables(table_name, source_id, start_file, start_position)
+VALUES($1, $2, $3, $4)
RETURNING table_id