Okay, I patched the code at [1]. The sql now works on mysql 5.5.17 for me (as
well as 5.1).
Please note that I do only very minimal maintenance on this code but I'm the only maintainer left. I probably will
never fix the extant bugs. However, patches are welcome.
[1] https://github.com/mcortez/flotsam
On 21/10/11 19:36, Mike Chase wrote:
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
[email protected]
https://lists.berlios.de/mailman/listinfo/opensim-users
_______________________________________________
Opensim-users mailing list
[email protected]
https://lists.berlios.de/mailman/listinfo/opensim-users
--
Justin Clark-Casey (justincc)
http://justincc.org/blog
http://twitter.com/justincc
_______________________________________________
Opensim-users mailing list
[email protected]
https://lists.berlios.de/mailman/listinfo/opensim-users
