SF.net SVN: postfixadmin: [344] trunk

[<chr...@us...>]

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.