aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorThomas Lange <code@nerdmind.de>2021-06-16 22:11:30 +0200
committerThomas Lange <code@nerdmind.de>2021-06-16 22:28:59 +0200
commit85d6e75d4c77d13f6f5c0c7bc75f6ed48ee6df6c (patch)
treec8516e3094bf4061c23799d3e7f189ac7545ac99
parent78fcc20190121d487a2e6cf1fca53b66df67dc3a (diff)
downloadblog-85d6e75d4c77d13f6f5c0c7bc75f6ed48ee6df6c.tar.gz
blog-85d6e75d4c77d13f6f5c0c7bc75f6ed48ee6df6c.tar.xz
blog-85d6e75d4c77d13f6f5c0c7bc75f6ed48ee6df6c.zip
Add migration table to database.sql
This commit adds a new table called "migration" to the database which will contain information used for database schema migrations. The current schema version is 5 because 5 modifications (migrations) have been applied to the database schema since the initial release.
-rw-r--r--database.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/database.sql b/database.sql
index 3f77a3b..ae61034 100644
--- a/database.sql
+++ b/database.sql
@@ -1,4 +1,11 @@
-- =============================================================================
+-- Internal information table for migrations
+-- =============================================================================
+CREATE TABLE `migration` (`schema_version` smallint(4) NOT NULL)
+ ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
+INSERT INTO `migration` (`schema_version`) VALUES (5);
+
+-- =============================================================================
-- Table structure for page items
-- =============================================================================
CREATE TABLE `page` (