On 28 May 2010 10:11, Konstantin Kletschke <[email protected]> wrote: > > Hello! > > In my config i have an alias_domain part in my config, which checks a > table if there are aliases in it depending on domain. > > alias_domain: > driver = redirect > allow_defer > allow_fail > data = ${lookup mysql {MYSQL_DOMAIN_ALIAS}{$value}} > domains = mysql;MYSQL_LOCALDOMAINS > retry_use_local_part > user = exim > > In many cases these tables are emtpy but I need them to be created, even > if empty. Can I get a behaviour where the existence is optional so that > non existand tables are created as if the are there and empty?
Not really an Exim question but relying on the existence/otherwise of a piece of database schema is not really a sensible route - better to organise your schema to store aliases in a single table with a column (indexed to improve performance) to indicate which domain an alias refers to. You can add/delete rows at will without needing to worry about the database structure, and construct a query using the domain as a key. Peter -- Peter Bowyer Email: [email protected] Follow me on Twitter: twitter.com/peeebeee -- ## List details at http://lists.exim.org/mailman/listinfo/exim-users ## Exim details at http://www.exim.org/ ## Please use the Wiki with this list - http://wiki.exim.org/
