[Devel] openserctl adding a new domain

[Klaus Darilion]

Norman Brandinger wrote:
> Tried to post this to the sourceforge site but it's down.
> 
> When adding a new domain using /usr/local/sbin/openserctl, the 
> last_modified column isn't populated.
> 
> Changing the query as shown below for the "domain add" function within 
> openserctl resolved this problem
> 
> QUERY="insert into $DOMAIN_TABLE (domain, last_modified) VALUES ('$1', 
> now());"
> 
> An alternate solution might be to update the database definition for 
> domain.last_modified as follows:
> 
> ALTER TABLE `domain` CHANGE `last_modified` `last_modified` TIMESTAMP 
> NOT NULL DEFAULT CURRENT_TIMESTAMP

does this work with both, mysql and postgres?

regards
klaus

> 
> Each solution solves the problem and offers different benefits in terms 
> of user control and simplicity of programming.  I feel that one of the 
> above should be implemented.
> 
> Regards,
> Norm
> 
> 
> 
> 
> 
> _______________________________________________
> Devel mailing list
> Devel at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/devel
> 
>