SF.net SVN: postfixadmin: [391] branches/postfixadmin-2.2.1/upgrade.php

[<Gin...@us...>]

Revision: 391
          http://postfixadmin.svn.sourceforge.net/postfixadmin/?rev=391&view=rev
Author:   GingerDog
Date:     2008-06-20 00:54:14 -0700 (Fri, 20 Jun 2008)

Log Message:
-----------
upgrade.php: fix as per https://sourceforge.net/forum/forum.php?thread_id=2067293&forum_id=676076 - possible fix for vacation table creation issue

Modified Paths:
--------------
    branches/postfixadmin-2.2.1/upgrade.php

Modified: branches/postfixadmin-2.2.1/upgrade.php
===================================================================
--- branches/postfixadmin-2.2.1/upgrade.php	2008-06-17 21:40:33 UTC (rev 390)
+++ branches/postfixadmin-2.2.1/upgrade.php	2008-06-20 07:54:14 UTC (rev 391)
@@ -305,11 +305,11 @@
 
     $sql[] = "
     CREATE TABLE {IF_NOT_EXISTS} $vacation ( 
-        email varchar(255) NOT NULL default '', 
-        subject varchar(255) NOT NULL default '', 
+        email varchar(255) NOT NULL , 
+        subject varchar(255) NOT NULL, 
         body text NOT NULL, 
         cache text NOT NULL, 
-        domain varchar(255) NOT NULL default '', 
+        domain varchar(255) NOT NULL , 
         created datetime NOT NULL default '0000-00-00 00:00:00', 
         active tinyint(4) NOT NULL default '1', 
         PRIMARY KEY (email), 
@@ -432,9 +432,9 @@
         db_query_parsed('
             CREATE TABLE ' . table_by_key('vacation') . ' (
                 email character varying(255) PRIMARY KEY,
-                subject character varying(255) NOT NULL DEFAULT \'\',
-                body text NOT NULL DEFAULT \'\',
-                cache text NOT NULL DEFAULT \'\',
+                subject character varying(255) NOT NULL,
+                body text NOT NULL ,
+                cache text NOT NULL ,
                 "domain" character varying(255) NOT NULL REFERENCES "domain",
                 created timestamp with time zone DEFAULT now(),
                 active boolean DEFAULT true NOT NULL
@@ -689,11 +689,11 @@
 
     $result = db_query_parsed("
         CREATE TABLE {IF_NOT_EXISTS} `" . table_by_key('vacation') . "` (
-            `email` varchar(255) NOT NULL default '',
-            `subject` varchar(255) NOT NULL default '',
-            `body` text NOT NULL default '',
-            `cache` text NOT NULL default '',
-            `domain` varchar(255) NOT NULL default '',
+            `email` varchar(255) NOT NULL ,
+            `subject` varchar(255) NOT NULL,
+            `body` text NOT NULL,
+            `cache` text NOT NULL,
+            `domain` varchar(255) NOT NULL,
             `created` datetime NOT NULL default '0000-00-00 00:00:00',
             `active` tinyint(1) NOT NULL default '1',
             PRIMARY KEY  (`email`),


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