phpwiki-checkins

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

[<ru...@us...>]

Revision: 7117
          http://phpwiki.svn.sourceforge.net/phpwiki/?rev=7117&view=rev
Author:   rurban
Date:     2009-09-15 08:02:20 +0000 (Tue, 15 Sep 2009)

Log Message:
-----------
Bug#2761192 mysql 5.1 timestamp changes
change to no automatic update per default, only if supported

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

Modified: trunk/schemas/mysql-initialize.sql
===================================================================
--- trunk/schemas/mysql-initialize.sql	2009-09-14 16:30:20 UTC (rev 7116)
+++ trunk/schemas/mysql-initialize.sql	2009-09-15 08:02:20 UTC (rev 7117)
@@ -113,7 +113,11 @@
         rateepage INT(11) NOT NULL,
         ratingvalue FLOAT NOT NULL,
         rateeversion INT(11) NOT NULL,
-        tstamp TIMESTAMP(14) NOT NULL,
+        tstamp TIMESTAMP,
+-- before:
+--      tstamp TIMESTAMP(14) NOT NULL,
+-- since mysql 5.1 better use:
+--      tstamp TIMESTAMP DEFAULT 0,
         PRIMARY KEY (dimension, raterpage, rateepage)
 );
 -- for empty dimensions use extra indices. see lib/wikilens/RatingsDb.php


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

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

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

Revision: 9624
          http://sourceforge.net/p/phpwiki/code/9624
Author:   vargenau
Date:     2015-03-09 14:34:30 +0000 (Mon, 09 Mar 2015)
Log Message:
-----------
Remove obsolete comments

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

Modified: trunk/schemas/mysql-initialize.sql
===================================================================
--- trunk/schemas/mysql-initialize.sql	2015-03-09 14:08:02 UTC (rev 9623)
+++ trunk/schemas/mysql-initialize.sql	2015-03-09 14:34:30 UTC (rev 9624)
@@ -1,10 +1,5 @@
 CREATE TABLE page (
 	id              INT NOT NULL AUTO_INCREMENT,
--- for mysql => 4.1 define the charset here
--- this is esp. needed for mysql 4.1.0 up to 4.1.6. 
--- not yet confirmed, at least since 4.1.8 it's okay with binary.
---      pagename        VARCHAR(100) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
--- otherwise use the old syntax to do case-sensitive comparison
         pagename        VARCHAR(100) BINARY NOT NULL,
 	hits            INT NOT NULL DEFAULT 0,
         pagedata        MEDIUMTEXT NOT NULL DEFAULT '',

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

[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.