From 85d6e75d4c77d13f6f5c0c7bc75f6ed48ee6df6c Mon Sep 17 00:00:00 2001 From: Thomas Lange 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(+) 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