<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
On 10/21/2011 02:27 PM, Luisillo Contepomi wrote:
<blockquote
cite="mid:CACUCPrzzVV=QEU=dnYMv+3OTwBF=GPjh+VEiw1DOeyOVO_Yexg@mail.gmail.com"
type="cite">I think you have a syntax error.<br>
<br>
</blockquote>
The TIMESTAMP(14) syntax is old. <br>
<br>
<br>
Something like:<br>
<pre class="programlisting">ts TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
Should do it. See:
<a class="moz-txt-link-freetext" href="http://dev.mysql.com/doc/refman/5.0/en/timestamp.html">http://dev.mysql.com/doc/refman/5.0/en/timestamp.html</a>
Mike
</pre>
<blockquote
cite="mid:CACUCPrzzVV=QEU=dnYMv+3OTwBF=GPjh+VEiw1DOeyOVO_Yexg@mail.gmail.com"
type="cite">Copy and paste this <br>
<br>
CREATE TABLE osgroupinvite (<br>
InviteID varchar(128) NOT NULL default '',<br>
GroupID varchar(128) NOT NULL default '',<br>
RoleID varchar(128) NOT NULL default '',<br>
AgentID varchar(128) NOT NULL default '',<br>
TMStamp timestamp(14) NOT NULL,<br>
PRIMARY KEY (InviteID),<br>
UNIQUE KEY GroupID (GroupID,RoleID,AgentID)<br>
) ENGINE=MyISAM<br>
<br>
Regards,<br>
Luisillo Contepomi <br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Opensim-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Opensim-users@lists.berlios.de">Opensim-users@lists.berlios.de</a>
<a class="moz-txt-link-freetext" href="https://lists.berlios.de/mailman/listinfo/opensim-users">https://lists.berlios.de/mailman/listinfo/opensim-users</a>
</pre>
</blockquote>
<br>
</body>
</html>