SF.net SVN: postfixadmin: [113] trunk/DATABASE_MYSQL.TXT

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

Revision: 113
          http://postfixadmin.svn.sourceforge.net/postfixadmin/?rev=113&view=rev
Author:   GingerDog
Date:     2007-10-02 05:22:38 -0700 (Tue, 02 Oct 2007)

Log Message:
-----------
fix broken MySQL Schema (thanks to cytdevel - http://sourceforge.net/forum/forum.php?thread_id=1836415&forum_id=676076)

Modified Paths:
--------------
    trunk/DATABASE_MYSQL.TXT

Modified: trunk/DATABASE_MYSQL.TXT
===================================================================
--- trunk/DATABASE_MYSQL.TXT	2007-10-02 12:06:10 UTC (rev 112)
+++ trunk/DATABASE_MYSQL.TXT	2007-10-02 12:22:38 UTC (rev 113)
@@ -1,8 +1,6 @@
 #
 # Postfix Admin
-# by Mischa Peters <mischa at high5 dot net>
-# Copyright (c) 2002 - 2005 High5!
-# Licensed under GPL for more info check GPL-LICENSE.TXT
+# Licensed under GPL for more info check LICENSE.TXT
 #
 
 # This is the complete MySQL database structure for Postfix Admin.
@@ -25,19 +23,21 @@
 #
 # Postfix / MySQL
 #
+
 USE mysql;
+CREATE DATABASE IF NOT EXISTS postfix;
 # Postfix user & password
-INSERT INTO user (Host, User, Password) VALUES ('localhost','postfix',password('postfix'));
-INSERT INTO db (Host, Db, User, Select_priv) VALUES ('localhost','postfix','postfix','Y');
+#INSERT INTO user (Host, User, Password) VALUES ('localhost','postfix',password('postfix'));
 # Postfix Admin user & password
-INSERT INTO user (Host, User, Password) VALUES ('localhost','postfixadmin',password('postfixadmin'));
-INSERT INTO db (Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv) VALUES ('localhost', 'postfix', 'postfixadmin', 'Y', 'Y', 'Y', 'Y');
+#INSERT INTO user (Host, User, Password) VALUES ('localhost','postfixadmin',password('postfixadmin'));
+# Priviledges
+#INSERT INTO db (Host, Db, User, Select_priv) VALUES ('localhost','postfix','postfix','Y');
+#INSERT INTO db (Host, Db, User, Select_priv, Insert_priv, Update_priv, Delete_priv) VALUES ('localhost', 'postfix', 'postfixadmin', 'Y', 'Y', 'Y', 'Y');
 FLUSH PRIVILEGES;
 GRANT USAGE ON postfix.* TO postfix@localhost;
 GRANT SELECT, INSERT, DELETE, UPDATE ON postfix.* TO postfix@localhost;
 GRANT USAGE ON postfix.* TO postfixadmin@localhost;
 GRANT SELECT, INSERT, DELETE, UPDATE ON postfix.* TO postfixadmin@localhost;
-CREATE DATABASE postfix;
 USE postfix;
 
 #
@@ -49,7 +49,7 @@
   `created` datetime NOT NULL default '0000-00-00 00:00:00',
   `modified` datetime NOT NULL default '0000-00-00 00:00:00',
   `active` tinyint(1) NOT NULL default '1',
-  PRIMARY KEY  (`username`),
+  PRIMARY KEY  (`username`)
 ) TYPE=MyISAM COMMENT='Postfix Admin - Virtual Admins';
 
 #
@@ -62,7 +62,7 @@
   `created` datetime NOT NULL default '0000-00-00 00:00:00',
   `modified` datetime NOT NULL default '0000-00-00 00:00:00',
   `active` tinyint(1) NOT NULL default '1',
-  PRIMARY KEY  (`address`),
+  PRIMARY KEY  (`address`)
 ) TYPE=MyISAM COMMENT='Postfix Admin - Virtual Aliases';
 
 #
@@ -80,7 +80,7 @@
   `created` datetime NOT NULL default '0000-00-00 00:00:00',
   `modified` datetime NOT NULL default '0000-00-00 00:00:00',
   `active` tinyint(1) NOT NULL default '1',
-  PRIMARY KEY  (`domain`),
+  PRIMARY KEY  (`domain`)
 ) TYPE=MyISAM COMMENT='Postfix Admin - Virtual Domains';
 
 #
@@ -119,7 +119,7 @@
   `created` datetime NOT NULL default '0000-00-00 00:00:00',
   `modified` datetime NOT NULL default '0000-00-00 00:00:00',
   `active` tinyint(1) NOT NULL default '1',
-  PRIMARY KEY  (`username`),
+  PRIMARY KEY  (`username`)
 ) TYPE=MyISAM COMMENT='Postfix Admin - Virtual Mailboxes';
 
 


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