[Opensim-users] Problems creating MySQL tables for XmlRpcGroupsServer

[Mike Chase]

On 10/21/2011 02:27 PM, Luisillo Contepomi wrote:
> I think you have a syntax error.
>
The TIMESTAMP(14) syntax is old.


Something like:

ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

Should do it. See:

http://dev.mysql.com/doc/refman/5.0/en/timestamp.html

Mike


> Copy and paste this
>
> CREATE TABLE osgroupinvite (
>       InviteID varchar(128) NOT NULL default '',
>       GroupID varchar(128) NOT NULL default '',
>        RoleID varchar(128) NOT NULL default '',
>       AgentID varchar(128) NOT NULL default '',
>        TMStamp timestamp(14) NOT NULL,
>        PRIMARY KEY  (InviteID),
>        UNIQUE KEY GroupID (GroupID,RoleID,AgentID)
>     ) ENGINE=MyISAM
>
> Regards,
> Luisillo Contepomi
>
>
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20111021/73b04568/attachment.html>