diff options
author | Thomas Lange <code@nerdmind.de> | 2021-06-16 22:11:30 +0200 |
---|---|---|
committer | Thomas Lange <code@nerdmind.de> | 2021-06-16 22:28:59 +0200 |
commit | 85d6e75d4c77d13f6f5c0c7bc75f6ed48ee6df6c (patch) | |
tree | c8516e3094bf4061c23799d3e7f189ac7545ac99 | |
parent | 78fcc20190121d487a2e6cf1fca53b66df67dc3a (diff) | |
download | blog-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.sql | 7 |
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` ( |