From 86da5ac84fdad19571c27beb89bc375b6dc04c92 Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Tue, 2 Jun 2020 09:42:49 -0400 Subject: [PATCH] base staging tables for koha added for kmig.d/init --- kmig.d/sql/init/003-base_tables.sql | 22 ++++++++++++++++++++++ 1 files changed, 22 insertions(+), 0 deletions(-) create mode 100644 kmig.d/sql/init/003-base_tables.sql 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; + + -- 1.7.2.5