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