<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>