[Devel] openserctl adding a new domain

[Daniel-Constantin Mierla]

Hello,

On 11/02/05 19:19, 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());"
this is ok, I will commit the change on cvs.

>
> 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
I am not sure that this works with old mysql (3.x).

Cheers,
Daniel
>
> 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
>