[phpwiki-checkins] SF.net SVN: phpwiki:[10318] trunk/schemas/mysql-initialize.sql

[<var...@us...>]

Revision: 10318
          http://sourceforge.net/p/phpwiki/code/10318
Author:   vargenau
Date:     2021-06-23 17:19:25 +0000 (Wed, 23 Jun 2021)
Log Message:
-----------
MySQL: remove default values

Modified Paths:
--------------
    trunk/schemas/mysql-initialize.sql

Modified: trunk/schemas/mysql-initialize.sql
===================================================================
--- trunk/schemas/mysql-initialize.sql	2021-06-22 16:31:24 UTC (rev 10317)
+++ trunk/schemas/mysql-initialize.sql	2021-06-23 17:19:25 UTC (rev 10318)
@@ -2,7 +2,7 @@
 	id              INT NOT NULL AUTO_INCREMENT,
         pagename        VARCHAR(100) BINARY NOT NULL,
 	hits            INT NOT NULL DEFAULT 0,
-        pagedata        MEDIUMTEXT NOT NULL DEFAULT '',
+        pagedata        MEDIUMTEXT NOT NULL,
 -- dont add that by hand, better let action=upgrade convert your data
 	cached_html 	MEDIUMBLOB,
         PRIMARY KEY (id),
@@ -14,8 +14,8 @@
         version         INT NOT NULL,
 	mtime           INT NOT NULL,
 	minor_edit      TINYINT DEFAULT 0,
-        content         MEDIUMTEXT NOT NULL DEFAULT '',
-        versiondata     MEDIUMTEXT NOT NULL DEFAULT '',
+        content         MEDIUMTEXT NOT NULL,
+        versiondata     MEDIUMTEXT NOT NULL,
         PRIMARY KEY (id,version),
 	INDEX (mtime)
 );
@@ -66,7 +66,7 @@
 
 CREATE TABLE pref (
   	userid 	VARCHAR(48) BINARY NOT NULL UNIQUE,
-  	prefs  	TEXT NULL DEFAULT '',
+  	prefs  	TEXT NULL,
   	passwd 	VARCHAR(48) BINARY DEFAULT '',
 	groupname VARCHAR(48) BINARY DEFAULT 'users',
   	PRIMARY KEY (userid)

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.