[ postfixadmin-Feature Requests-1851244 ] Reform alias table

[SourceForge.net <no...@so...>]

Feature Requests item #1851244, was opened at 2007-12-15 09:57
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937967&aid=1851244&group_id=191583

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Database
Group: None
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: GingerDog (gingerdog)
Assigned to: Nobody/Anonymous (nobody)
Summary: Reform alias table

Initial Comment:
On IRC last night, DRJ33 suggested that the 'alias' table is reformed to not have a comma seperated list within it. Obviously there are some scalability issues with this (i.e. you wouldn't be able to have more aliases than the field length could handle). 

His suggestion is to go from :

mysql> select * from alias;
+-------------------+----------------------------------------------------+--------------+---------------------+---------------------+--------+
| address           | goto    | domain  | created | modified            | active |
| d9...@ex...   | do...@ex... | example.com 2007-12-13 15:06:55 | 2007-12-13 15:06:55 |      1 |
| dr...@ex...   | do...@ex...,te...@ex...,ej...@ex... | example.com | 2007-12-13 15:17:31 | 2007-12-14 11:40:53 |      1 |

TO :
      +----+-------------------+--------------------+--------------+---------------------+---------------------+--------+
| id | address           | goto               | domain       | created             | modified            | active |
|  1 | to...@ex... | ro...@ex... | example.com | 2007-12-14 13:28:26 | 2007-12-14 13:28:26 
|  2 | to...@ex... | ro...@ex...  | example.com | 2007-12-14 13:28:30 | 2007-12-14 13:28:30 |      1 
|  3 | to...@ex... | ro...@ex... | example.com | 2007-12-14 13:28:35 | 2007-12-14 13:28:35 |      1 |


Apparently the queries for Postfix would still work fine if there are multiple rows returned, and not just a single row with multiple comma seperated lists.

This seems a great idea, and would certainly simplify some of e.g. the vacation handling logic; but it would also mean that there would need to be some sort of database reforming code for anyone wishing to migrate.

I'd like to see this implemented, but probably in 2.3?

(See also http://pastebin.com/d3bec4ec8 if it exists)

David.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=937967&aid=1851244&group_id=191583