summaryrefslogtreecommitdiffstats
path: root/database.sql
diff options
context:
space:
mode:
authorThomas Lange <code@nerdmind.de>2017-10-24 20:30:31 +0200
committerThomas Lange <code@nerdmind.de>2017-10-24 20:36:35 +0200
commit88c4effebd6efa93f41cc3d11d2c3a3fa3e6649f (patch)
treecb4d0ea671990b4e4f8bb9cd4e6103ff26e7449a /database.sql
parent7cdbf9efcc542701b489e8814628bf6a3b48074e (diff)
downloadblog-88c4effebd6efa93f41cc3d11d2c3a3fa3e6649f.tar.gz
blog-88c4effebd6efa93f41cc3d11d2c3a3fa3e6649f.tar.xz
blog-88c4effebd6efa93f41cc3d11d2c3a3fa3e6649f.zip
Database update: The maximum amount of characters for the argument field has been increased from 100 to 250.v2.4.1
Database update to version 2.4.1 (no existing data will be lost or changed): ALTER TABLE `page` MODIFY `argv` VARCHAR(250); ALTER TABLE `post` MODIFY `argv` VARCHAR(250); ALTER TABLE `user` MODIFY `argv` VARCHAR(250);
Diffstat (limited to 'database.sql')
-rw-r--r--database.sql6
1 files changed, 3 insertions, 3 deletions
diff --git a/database.sql b/database.sql
index 1207b3f..63c9765 100644
--- a/database.sql
+++ b/database.sql
@@ -9,7 +9,7 @@ CREATE TABLE `page` (
`slug` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
`name` varchar(100) NOT NULL,
`body` text NOT NULL,
- `argv` varchar(100) DEFAULT NULL
+ `argv` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- =============================================================================
@@ -23,7 +23,7 @@ CREATE TABLE `post` (
`slug` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
`name` varchar(100) NOT NULL,
`body` text NOT NULL,
- `argv` varchar(100) DEFAULT NULL
+ `argv` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- =============================================================================
@@ -39,7 +39,7 @@ CREATE TABLE `user` (
`fullname` varchar(40) NOT NULL,
`mailaddr` varchar(60) NOT NULL,
`body` text NOT NULL,
- `argv` varchar(100) DEFAULT NULL
+ `argv` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-- =============================================================================