SF.net SVN: postfixadmin: [392] trunk/upgrade.php

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

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

Log Message:
-----------
update trunk also; this is a merge of r391 from branches/postfixadmin-2.2.1

Modified Paths:
--------------
    trunk/upgrade.php

Modified: trunk/upgrade.php
===================================================================
--- trunk/upgrade.php	2008-06-20 07:54:14 UTC (rev 391)
+++ trunk/upgrade.php	2008-06-20 08:00:44 UTC (rev 392)
@@ -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
@@ -735,11 +735,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.