CREATE TABLE `tbl_Check_SubType_Response` (
	`iSno` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
	`cSequenceNo` char(20) NOT NULL DEFAULT '0',
	`cScpTransactionID` char(50) NOT NULL DEFAULT '0',
	`iMSISDN` bigint(20) unsigned NOT NULL,
	`cServiceType` char(20) NOT NULL DEFAULT '0',
	`cServiceID` char(20) NOT NULL DEFAULT '0',
	`iSubsType` tinyint(4) NOT NULL COMMENT '1-POSTPAID 2-PREPAID 3-DATA/Blacklisted 4-Unknown /Non-ooredoo Number',
	`cChargeAmount` char(5) NOT NULL DEFAULT '0',
	`cResult` char(30) NOT NULL DEFAULT '0',
	`cErrorCode` char(10) NOT NULL DEFAULT '0',
	`cServiceUsage` char(10) NOT NULL DEFAULT '0',
	`cEligible` char(10) NOT NULL DEFAULT '0',
	`cAccountStatus` char(10) NOT NULL DEFAULT '0',
	`cIsBlack` char(10) NOT NULL DEFAULT '0',
	`cAccountBalance` char(10) NOT NULL DEFAULT '0',
	`cRequestedPlan` char(10) NOT NULL DEFAULT '0',
	`cAppliedPlan` char(10) NOT NULL DEFAULT '0',
	`cDiscountPlan` char(10) NOT NULL DEFAULT '0',
	`cOp1` char(50) NOT NULL DEFAULT '0',
	`cOp2` char(50) NOT NULL DEFAULT '0',
	`cOp3` char(50) NOT NULL DEFAULT '0',
	`cOp4` char(50) NOT NULL DEFAULT '0',
	`cOp5` char(50) NOT NULL DEFAULT '0',
	`cOp6` char(50) NOT NULL DEFAULT '0',
	`cOp7` char(50) NOT NULL DEFAULT '0',
	`cOp8` char(50) NOT NULL DEFAULT '0',
	`cOp9` char(50) NOT NULL DEFAULT '0',
	`cOp10` char(50) NOT NULL DEFAULT '0',
	`cOp11` char(50) NOT NULL DEFAULT '0',
	`cOp12` char(50) NOT NULL DEFAULT '0',
	`dtCreatedOn` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
	PRIMARY KEY (`iSno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `tbl_Sub_Response` (
	`iSno` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
	`cSequenceNo` char(20) NOT NULL DEFAULT '0',
	`cScpTransactionID` char(50) NOT NULL DEFAULT '0',
	`iMSISDN` bigint(20) unsigned NOT NULL,
	`cServiceType` char(20) NOT NULL DEFAULT '0',
	`cServiceID` char(20) NOT NULL DEFAULT '0',
	`iSubsType` tinyint(4) NOT NULL COMMENT '1-POSTPAID 2-PREPAID 3-DATA/Blacklisted 4-Unknown /Non-ooredoo Number',
	`cChargeAmount` char(5) NOT NULL DEFAULT '0',
	`cResult` char(30) NOT NULL DEFAULT '0',
	`cErrorCode` char(10) NOT NULL DEFAULT '0',
	`cServiceUsage` char(10) NOT NULL DEFAULT '0',
	`cAccountBalance` char(10) NOT NULL DEFAULT '0',
	`cRequestedPlan` char(10) NOT NULL DEFAULT '0',
	`cAppliedPlan` char(10) NOT NULL DEFAULT '0',
	`cOp1` char(50) NOT NULL DEFAULT '0',
	`cOp2` char(50) NOT NULL DEFAULT '0',
	`cOp3` char(50) NOT NULL DEFAULT '0',
	`cOp4` char(50) NOT NULL DEFAULT '0',
	`cOp5` char(50) NOT NULL DEFAULT '0',
	`cOp6` char(50) NOT NULL DEFAULT '0',
	`cOp7` char(50) NOT NULL DEFAULT '0',
	`cOp8` char(50) NOT NULL DEFAULT '0',
	`cOp9` char(50) NOT NULL DEFAULT '0',
	`cOp10` char(50) NOT NULL DEFAULT '0',
	`cOp11` char(50) NOT NULL DEFAULT '0',
	`dtCreatedOn` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
	PRIMARY KEY (`iSno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

CREATE TABLE `tbl_Cg_Response` (
	`iSno` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
	`iMSISDN` bigint(20) unsigned NOT NULL,
	`cResult` char(30) NOT NULL DEFAULT '',
	`cReason` char(50) NOT NULL DEFAULT '',
	`cProductID` char(20) NOT NULL DEFAULT '',
	`cTransactionID` char(20) NOT NULL DEFAULT '',
	`cTPCGID` char(30) NOT NULL DEFAULT '',
	`cSongname` char(10) NOT NULL DEFAULT '',
	`cFlow` char(10) NOT NULL DEFAULT '',
	`dtCreatedOn` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
	PRIMARY KEY (`iSno`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
