
CREATE TABLE  `pms_new`.`fleet_login` (
  `FLEETLOGINID` int(11) NOT NULL AUTO_INCREMENT,
  `MCOMPANYID` int(11) DEFAULT NULL,
  `LOCATIONID` int(11) DEFAULT NULL,
  `CONTACT_PERSON` varchar(500) CHARACTER SET latin1 DEFAULT NULL,
  `ADDRESS` text CHARACTER SET latin1,
  `PHONE_NO` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `EMAILID` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `USER_TYPE` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `STATUS` int(11) DEFAULT NULL,
  `USERNAME` varchar(500) CHARACTER SET latin1 DEFAULT NULL,
  `PASSWORD` varchar(500) CHARACTER SET latin1 DEFAULT NULL,
  `MODULES` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `FLEETUSERTYPE` varchar(45) CHARACTER SET latin1 DEFAULT NULL,
  `FLEETIDS` varchar(100) CHARACTER SET latin1 DEFAULT NULL,
  `ADDEDBY` int(11) DEFAULT '0',
  `LOGIN_STATUS` varchar(45) CHARACTER SET latin1 DEFAULT 'OFFLINE',
  PRIMARY KEY (`FLEETLOGINID`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;