-- Adminer 4.2.1 MySQL dump

SET NAMES utf8;
SET time_zone = '+00:00';
SET foreign_key_checks = 0;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS `tbl_vfstrack`;
CREATE TABLE `tbl_vfstrack` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ClientNo` int(8) NOT NULL DEFAULT '0',
  `Client_name` varchar(100) NOT NULL,
  `Vfs_ID` varchar(100) NOT NULL,
  `status` mediumtext NOT NULL,
  `date_created` varchar(20) NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'YYYY-MM-DD HH:MM:SS',
  `date_modified` varchar(20) NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'YYYY-MM-DD HH:MM:SS',
  `RecStatus` varchar(1) NOT NULL DEFAULT 'E' COMMENT 'E=Enquiry from CMS, A=Active, D=Deleted',
  `prcossingStatus` tinyint(1) NOT NULL DEFAULT '0',
  UNIQUE KEY `id` (`id`),
  KEY `LastMsgNo` (`RecStatus`,`date_modified`),
  KEY `prcossingStatus` (`prcossingStatus`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `tbl_vfstrack` (`id`, `ClientNo`, `Client_name`, `Vfs_ID`, `status`, `date_created`, `date_modified`, `RecStatus`, `prcossingStatus`) VALUES
(1,	0,	'',	'TRC1591965',	'Application for NINA DENISE has been forwarded to the Department of Home Affairs for adjudication on 25-Nov-2015.',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	'E',	1),
(2,	0,	'',	'TRR1607229',	'Application for Kishan has been forwarded to the Department of Home Affairs for adjudication on 25-Nov-2015.',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	'E',	1),
(3,	0,	'',	'PRP1544948',	'Application for Younes has been forwarded to the Department of Home Affairs for adjudication on 25-Nov-2015.',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	'E',	1),
(4,	0,	'',	'TRR1591610',	'Application for THERESA has been forwarded to the Department of Home Affairs for adjudication on 20-Nov-2015.',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	'E',	1),
(5,	0,	'',	'TRR1591556',	'Application for MARILENA SOPHIE has been forwarded to the Department of Home Affairs for adjudication on 20-Nov-2015.',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	'E',	1),
(6,	0,	'',	'TRC1584184',	'Application for Jan Fernande M has been forwarded to the Department of Home Affairs for adjudication on 20-Nov-2015.',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	'E',	1),
(7,	0,	'',	'TRR1564039',	'Application for Runaldo has been forwarded to the Department of Home Affairs for adjudication on 14-Oct-2015.',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	'E',	1),
(8,	0,	'',	'PRP1561173',	'Application for Cosmas Rajabu Omar has been forwarded to the Department of Home Affairs for adjudication on 26-Oct-2015.',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	'E',	1),
(9,	0,	'',	'TRC1539318',	'Application for Daniel Richard  has been forwarded to the Department of Home Affairs for adjudication on 23-Oct-2015.',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	'E',	1),
(10,	0,	'',	'TRR1572854',	'Application for Yuliya has been forwarded to the Department of Home Affairs for adjudication on 23-Oct-2015.',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	'E',	1),
(12,	0,	'',	'TRA1486667',	'Application for Mapey has been forwarded to the Department of Home Affairs for adjudication on 21-Jul-2015.',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	'E',	1),
(13,	0,	'',	'TRC1501461',	'Application for Anthony Ifeanyi has been forwarded to the Department of Home Affairs for adjudication on 28-Jul-2015.',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	'E',	1),
(14,	0,	'',	'TRC1501461',	'Application for Anthony Ifeanyi has been forwarded to the Department of Home Affairs for adjudication on 28-Jul-2015.',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	'E',	1),
(15,	0,	'',	'TRC1501252',	'Application for Mackphilip Nnani has been forwarded to the Department of Home Affairs for adjudication on 30-Jul-2015.',	'0000-00-00 00:00:00',	'0000-00-00 00:00:00',	'E',	1);

-- 2015-11-25 12:41:22