mysql> show create table customers; +-----------+------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -----------------------------------------------+ | Table | Create Table | +-----------+------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -----------------------------------------------+ | customers | CREATE TABLE `customers` ( `CustomerID` varchar(255) NOT NULL default '', `PhoneNumber` varchar(255) NOT NULL default '', `RadiusUserName` varchar(255) NOT NULL default '', `ProductID` varchar(255) NOT NULL default '', `ProductUser` varchar(255) NOT NULL default '', `ProductPassword` varchar(255) NOT NULL default '', `Provider` varchar(255) default NULL, `CreationDate` varchar(255) NOT NULL default '', `TerminationDate` varchar(255) NOT NULL default '', `timestamp` varchar(255) NOT NULL default '', `status` varchar(255) NOT NULL default '', `MonitorServerID` varchar(80) default NULL, `Description` varchar(255) default NULL, `ParentProductID` varchar(255) default NULL, `Product` varchar(255) default NULL, PRIMARY KEY (`PhoneNumber`), KEY `phonenumbers` (`PhoneNumber`), KEY `crmusers` (`PhoneNumber`,`CustomerID`,`ProductUser`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | +-----------+------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -----------------------------------------------+