<div dir="ltr"><div>Follows,<br><br>##<br>##<br>##<br>mysql> show create table Users;<br>+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+<br>
| Table | Create Table |<br>
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+<br>
| Users | CREATE TABLE `Users` (<br> `id` int(11) NOT NULL AUTO_INCREMENT,<br> `Name` varchar(200) NOT NULL,<br> `Password` varchar(256) DEFAULT NULL,<br> `Comments` text,<br> `Signature` text,<br> `EmailAddress` varchar(120) DEFAULT NULL,<br>
`FreeformContactInfo` text,<br> `Organization` varchar(200) DEFAULT NULL,<br> `RealName` varchar(120) DEFAULT NULL,<br> `NickName` varchar(16) DEFAULT NULL,<br> `Lang` varchar(16) CHARACTER SET ascii DEFAULT NULL,<br>
`EmailEncoding` varchar(16) CHARACTER SET ascii DEFAULT NULL,<br> `WebEncoding` varchar(16) CHARACTER SET ascii DEFAULT NULL,<br> `ExternalContactInfoId` varchar(100) DEFAULT NULL,<br> `ContactInfoSystem` varchar(30) DEFAULT NULL,<br>
`ExternalAuthId` varchar(100) DEFAULT NULL,<br> `AuthSystem` varchar(30) DEFAULT NULL,<br> `Gecos` varchar(16) DEFAULT NULL,<br> `HomePhone` varchar(30) DEFAULT NULL,<br> `WorkPhone` varchar(30) DEFAULT NULL,<br> `MobilePhone` varchar(30) DEFAULT NULL,<br>
`PagerPhone` varchar(30) DEFAULT NULL,<br> `Address1` varchar(200) DEFAULT NULL,<br> `Address2` varchar(200) DEFAULT NULL,<br> `City` varchar(100) DEFAULT NULL,<br> `State` varchar(100) DEFAULT NULL,<br> `Zip` varchar(16) DEFAULT NULL,<br>
`Country` varchar(50) DEFAULT NULL,<br> `Timezone` varchar(50) CHARACTER SET ascii DEFAULT NULL,<br> `PGPKey` blob,<br> `Creator` int(11) NOT NULL DEFAULT '0',<br> `Created` datetime DEFAULT NULL,<br> `LastUpdatedBy` int(11) NOT NULL DEFAULT '0',<br>
`LastUpdated` datetime DEFAULT NULL,<br> `AuthToken` varchar(16) CHARACTER SET ascii DEFAULT NULL,<br> PRIMARY KEY (`id`),<br> UNIQUE KEY `Users1` (`Name`),<br> KEY `Users4` (`EmailAddress`)<br>) ENGINE=InnoDB AUTO_INCREMENT=234863 DEFAULT CHARSET=utf8 |<br>
+-------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+<br>
1 row in set (0.00 sec)<br>##<br>##<br>##<br>mysql> show create table ACL;<br>+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+<br>
| Table | Create Table |<br>
+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+<br>
| ACL | CREATE TABLE `ACL` (<br> `id` int(11) NOT NULL AUTO_INCREMENT,<br> `PrincipalType` varchar(25) CHARACTER SET ascii NOT NULL,<br> `PrincipalId` int(11) NOT NULL,<br> `RightName` varchar(25) CHARACTER SET ascii NOT NULL,<br>
`ObjectType` varchar(25) CHARACTER SET ascii NOT NULL,<br> `ObjectId` int(11) NOT NULL DEFAULT '0',<br> `Creator` int(11) NOT NULL DEFAULT '0',<br> `Created` datetime DEFAULT NULL,<br> `LastUpdatedBy` int(11) NOT NULL DEFAULT '0',<br>
`LastUpdated` datetime DEFAULT NULL,<br> PRIMARY KEY (`id`),<br> KEY `ACL1` (`RightName`,`ObjectType`,`ObjectId`,`PrincipalType`,`PrincipalId`)<br>) ENGINE=InnoDB AUTO_INCREMENT=1731 DEFAULT CHARSET=utf8 |<br>+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+<br>
<br></div><div><div><br><div><br><div class="gmail_extra"><br><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
------------------------------<br>
<br>
Message: 2<br>
Date: Fri, 29 Aug 2014 16:59:59 -0500<br>
From: Kevin Falcone <<a href="mailto:falcone@bestpractical.com">falcone@bestpractical.com</a>><br>
To: <a href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a><br>
Subject: Re: [rt-users] Upgrade RT 3.8.7 to 4.0.1<br>
Message-ID: <<a href="mailto:20140829215959.GD3163@jibsheet.com">20140829215959.GD3163@jibsheet.com</a>><br>
Content-Type: text/plain; charset="us-ascii"<br>
<br>
On Fri, Aug 29, 2014 at 01:18:11PM -0300, Felipe Agnelli Barbosa wrote:<br>
> Show the schema of your Users table, although if your ACL table is<br>
> also messed up then you've not completed the upgrade.<br>
<br>
You neglected this information<br>
<br>
run 'show create table Users' and 'show create table ACL' and share it<br>
with us.<br>
<br>
-kevin<br>
-------------- next part --------------<br>
A non-text attachment was scrubbed...<br>
Name: not available<br>
Type: application/pgp-signature<br>
Size: 221 bytes<br>
Desc: not available<br>
URL: <<a href="http://lists.bestpractical.com/pipermail/rt-users/attachments/20140829/ac0ae864/attachment-0001.pgp" target="_blank">http://lists.bestpractical.com/pipermail/rt-users/attachments/20140829/ac0ae864/attachment-0001.pgp</a>><br>
<br>
------------------------------<br>
<br>
Subject: Digest Footer<br>
<span class=""><font color="#888888"><br>
--<br>
--<br>
RT Training London, March 19-20 and Dallas May 20-21<br>
<a href="http://bestpractical.com/training" target="_blank">http://bestpractical.com/training</a><br>
--------<br>
rt-users mailing list<br>
<a href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a><br>
<a href="http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users" target="_blank">http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users</a><br>
<br>
------------------------------<br>
<br>
End of rt-users Digest, Vol 125, Issue 37<br>
*****************************************<br>
</font></span></blockquote></div><br><br clear="all"><br>-- <br>" A dúvida é o principio da sabedoria "<br><br>
</div></div></div></div></div>