From: Rogan Hamby <rhamby@equinoxinitiative.org>
Date: Tue, 2 Jun 2020 13:42:49 +0000 (-0400)
Subject: base staging tables for koha added for kmig.d/init
X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=86da5ac84fdad19571c27beb89bc375b6dc04c92

base staging tables for koha added for kmig.d/init
---

diff --git a/kmig.d/sql/init/003-base_tables.sql b/kmig.d/sql/init/003-base_tables.sql
new file mode 100644
index 0000000..f0e094d
--- /dev/null
+++ b/kmig.d/sql/init/003-base_tables.sql
@@ -0,0 +1,22 @@
+
+CREATE TABLE m_borrowers LIKE borrowers;
+ALTER TABLE m_borrowers ADD COLUMN x_borrowernumber INTEGER;
+ALTER TABLE m_borrowers CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+
+CREATE TABLE m_items LIKE items;
+ALTER TABLE m_items ADD COLUMN x_itemnumber INTEGER;
+ALTER TABLE m_items CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+
+CREATE TABLE m_issues LIKE issues;
+ALTER TABLE m_issues ADD COLUMN x_issue_id INTEGER;
+ALTER TABLE m_issues CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+
+CREATE TABLE m_reserves LIKE reserves;
+ALTER TABLE m_reserves ADD COLUMN x_reserve_id INTEGER;
+ALTER TABLE m_reserves CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+
+CREATE TABLE m_accountlines LIKE accountlines;
+ALTER TABLE m_accountlines ADD COLUMN x_accountlines_id INTEGER;
+ALTER TABLE m_accountlines CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+
+