From 5824bc0991a90f033ef288925a68df19164470b0 Mon Sep 17 00:00:00 2001
From: Thomas Lange <code@nerdmind.de>
Date: Thu, 1 Jul 2021 15:56:42 +0200
Subject: Update database schema: Make id columns unsigned

This commit updates the database schema and adds a new migration to
modify the signed integer columns to make them unsigned.
---
 core/db/database.sql | 12 ++++++------
 1 file changed, 6 insertions(+), 6 deletions(-)

(limited to 'core/db/database.sql')

diff --git a/core/db/database.sql b/core/db/database.sql
index d1eb8e7..244a38b 100644
--- a/core/db/database.sql
+++ b/core/db/database.sql
@@ -3,16 +3,16 @@
 -- =============================================================================
 CREATE TABLE `migration` (`schema_version` smallint(4) NOT NULL)
 	ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-INSERT INTO `migration` (`schema_version`) VALUES (4);
+INSERT INTO `migration` (`schema_version`) VALUES (5);
 
 -- =============================================================================
 -- Table structure for page entities
 -- =============================================================================
 CREATE TABLE `page` (
-	`id` smallint(6) NOT NULL AUTO_INCREMENT,
+	`id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
 	`time_insert` datetime NOT NULL,
 	`time_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
-	`user` tinyint(4) NOT NULL,
+	`user` tinyint(3) UNSIGNED NOT NULL,
 	`slug` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
 	`name` varchar(100) NOT NULL,
 	`body` text NOT NULL,
@@ -28,10 +28,10 @@ CREATE TABLE `page` (
 -- Table structure for post entities
 -- =============================================================================
 CREATE TABLE `post` (
-	`id` smallint(6) NOT NULL AUTO_INCREMENT,
+	`id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
 	`time_insert` datetime NOT NULL,
 	`time_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
-	`user` tinyint(4) NOT NULL,
+	`user` tinyint(3) UNSIGNED NOT NULL,
 	`slug` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
 	`name` varchar(100) NOT NULL,
 	`body` text NOT NULL,
@@ -47,7 +47,7 @@ CREATE TABLE `post` (
 -- Table structure for user entities
 -- =============================================================================
 CREATE TABLE `user` (
-	`id` tinyint(4) NOT NULL AUTO_INCREMENT,
+	`id` tinyint(3) UNSIGNED NOT NULL AUTO_INCREMENT,
 	`time_insert` datetime NOT NULL,
 	`time_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
 	`slug` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
-- 
cgit v1.2.3

