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
