SF.net SVN: postfixadmin: [344] trunk
Brought to you by:
christian_boltz,
gingerdog
|
From: <chr...@us...> - 2008-04-25 23:31:14
|
Revision: 344
http://postfixadmin.svn.sourceforge.net/postfixadmin/?rev=344&view=rev
Author: christian_boltz
Date: 2008-04-25 16:31:21 -0700 (Fri, 25 Apr 2008)
Log Message:
-----------
upgrade.php:
- create fetchmail table (upgrade_344_mysql)
- TODO: create fetchmail table for pgsql (empty function already included ;-)
fetchmail.php:
- removed CREATE TABLE statement - it's now created by upgrade.php
Modified Paths:
--------------
trunk/fetchmail.php
trunk/upgrade.php
Modified: trunk/fetchmail.php
===================================================================
--- trunk/fetchmail.php 2008-04-25 20:35:55 UTC (rev 343)
+++ trunk/fetchmail.php 2008-04-25 23:31:21 UTC (rev 344)
@@ -33,29 +33,6 @@
* - all editable form values, see $fm_struct
*/
-/* new sql table: fetchmail
-
-create table fetchmail(
- id int(11) unsigned not null auto_increment,
- mailbox varchar(255) not null default '',
- src_server varchar(255) not null default '',
- src_auth enum('password','kerberos_v5','kerberos','kerberos_v4','gssapi','cram-md5','otp','ntlm','msn','ssh','any'),
- src_user varchar(255) not null default '',
- src_password varchar(255) not null default '',
- src_folder varchar(255) not null default '',
- poll_time int(11) unsigned not null default 10,
- fetchall tinyint(1) unsigned not null default 0,
- keep tinyint(1) unsigned not null default 0,
- protocol enum('POP3','IMAP','POP2','ETRN','AUTO'),
- extra_options text,
- returned_text text,
- mda varchar(255) not null default '',
- date timestamp(14),
- primary key(id)
-);
-
-*/
-
require_once('common.php');
authentication_require_role('admin');
Modified: trunk/upgrade.php
===================================================================
--- trunk/upgrade.php 2008-04-25 20:35:55 UTC (rev 343)
+++ trunk/upgrade.php 2008-04-25 23:31:21 UTC (rev 344)
@@ -800,3 +800,38 @@
FOREIGN KEY (`on_vacation`) REFERENCES vacation(`email`) ON DELETE CASCADE
");
}
+
+
+/**
+ * Create fetchmail table
+ */
+function upgrade_344_mysql() {
+
+ $table_vacation_notification = table_by_key('vacation_notification');
+
+ db_query_parsed( "
+ create table fetchmail(
+ id int(11) unsigned not null auto_increment,
+ mailbox varchar(255) not null default '',
+ src_server varchar(255) not null default '',
+ src_auth enum('password','kerberos_v5','kerberos','kerberos_v4','gssapi','cram-md5','otp','ntlm','msn','ssh','any'),
+ src_user varchar(255) not null default '',
+ src_password varchar(255) not null default '',
+ src_folder varchar(255) not null default '',
+ poll_time int(11) unsigned not null default 10,
+ fetchall tinyint(1) unsigned not null default 0,
+ keep tinyint(1) unsigned not null default 0,
+ protocol enum('POP3','IMAP','POP2','ETRN','AUTO'),
+ extra_options text,
+ returned_text text,
+ mda varchar(255) not null default '',
+ date timestamp(14),
+ primary key(id)
+ );
+ ");
+}
+
+function upgrade_344_pgsql() {
+ # TODO: create fetchmail table for PgSQL
+}
+
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|