From 85d6e75d4c77d13f6f5c0c7bc75f6ed48ee6df6c Mon Sep 17 00:00:00 2001
From: Thomas Lange <code@nerdmind.de>
Date: Wed, 16 Jun 2021 22:11:30 +0200
Subject: 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.
---
 database.sql | 7 +++++++
 1 file changed, 7 insertions(+)

(limited to 'database.sql')

diff --git a/database.sql b/database.sql
index 3f77a3b..ae61034 100644
--- a/database.sql
+++ b/database.sql
@@ -1,3 +1,10 @@
+-- =============================================================================
+-- 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
 -- =============================================================================
-- 
cgit v1.2.3

