diff options
author | Thomas Lange <code@nerdmind.de> | 2021-07-01 15:56:42 +0200 |
---|---|---|
committer | Thomas Lange <code@nerdmind.de> | 2021-07-01 15:56:42 +0200 |
commit | 5824bc0991a90f033ef288925a68df19164470b0 (patch) | |
tree | bb2e1dc48af533fde81f8e5f556a3e5d0fb304ea /core/db/database.sql | |
parent | cd87a869b1d52fd65f53875527abf3205a4098a0 (diff) | |
download | blog-5824bc0991a90f033ef288925a68df19164470b0.tar.gz blog-5824bc0991a90f033ef288925a68df19164470b0.tar.xz blog-5824bc0991a90f033ef288925a68df19164470b0.zip |
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.
Diffstat (limited to 'core/db/database.sql')
-rw-r--r-- | core/db/database.sql | 12 |
1 files changed, 6 insertions, 6 deletions
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, |