diff options
| author | Thomas Lange <code@nerdmind.de> | 2017-10-24 20:30:31 +0200 |
|---|---|---|
| committer | Thomas Lange <code@nerdmind.de> | 2017-10-24 20:36:35 +0200 |
| commit | 88c4effebd6efa93f41cc3d11d2c3a3fa3e6649f (patch) | |
| tree | cb4d0ea671990b4e4f8bb9cd4e6103ff26e7449a /database.sql | |
| parent | 7cdbf9efcc542701b489e8814628bf6a3b48074e (diff) | |
| download | blog-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.sql | 6 |
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; -- ============================================================================= |