-- MySQL dump 10.13  Distrib 5.7.44, for Linux (x86_64)
--
-- Host: localhost    Database: indians7_upipay
-- ------------------------------------------------------
-- Server version	5.7.44-cll-lve

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `tb_gateway`
--

DROP TABLE IF EXISTS `tb_gateway`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_gateway` (
  `id` int(11) NOT NULL,
  `signup_fee` int(11) NOT NULL,
  `gateway_upiuid` varchar(255) NOT NULL,
  `gateway_secret` varchar(255) NOT NULL,
  `gateway_key` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_gateway`
--

LOCK TABLES `tb_gateway` WRITE;
/*!40000 ALTER TABLE `tb_gateway` DISABLE KEYS */;
INSERT INTO `tb_gateway` VALUES (1,1,'payssxwu@paytm','GcxAm8rrAZ','bec50f-b7370f-fd5df3-9fb5f1-630c9a');
/*!40000 ALTER TABLE `tb_gateway` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_partner`
--

DROP TABLE IF EXISTS `tb_partner`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_partner` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid_token` varchar(50) NOT NULL,
  `type` int(11) NOT NULL,
  `login_id` varchar(20) NOT NULL,
  `login_pwd` varchar(200) NOT NULL,
  `login_otp` varchar(12) NOT NULL,
  `name` varchar(100) NOT NULL,
  `company_name` varchar(255) NOT NULL,
  `mobile` varchar(10) NOT NULL,
  `email` varchar(100) NOT NULL,
  `pan_no` varchar(10) NOT NULL,
  `uid_no` varchar(12) NOT NULL,
  `balance` varchar(100) NOT NULL,
  `token` varchar(100) NOT NULL,
  `secret` varchar(100) NOT NULL,
  `txn_status_webhook` varchar(255) NOT NULL,
  `slab` int(11) NOT NULL,
  `upi_id` varchar(50) NOT NULL,
  `device` longtext NOT NULL,
  `upis` longtext NOT NULL,
  `paytm_business` longtext,
  `paytm_active` int(11) NOT NULL DEFAULT '0',
  `settle_account` mediumtext NOT NULL,
  `upi_active` int(11) NOT NULL,
  `status` varchar(10) NOT NULL,
  `payid` varchar(255) DEFAULT NULL,
  `password_bckup` varchar(255) DEFAULT NULL,
  `start_date` varchar(255) DEFAULT NULL,
  `expire_date` varchar(255) DEFAULT NULL,
  `trial_done` varchar(255) NOT NULL DEFAULT '0',
  `plan_txn_id` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=272 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_partner`
--

LOCK TABLES `tb_partner` WRITE;
/*!40000 ALTER TABLE `tb_partner` DISABLE KEYS */;
INSERT INTO `tb_partner` VALUES (268,'',1,'EXKPA6285E','$2y$10$1XJJgUnZQdJTt5OJVf4K9e2e4nNLojBlV/RaypK2tERG6s7YOTuuW','RPTkGozT','test','Color Game','1234567890','test@gmail.com','EXKPA6285E','123123123124','','bec50f-b7370f-fd5df3-9fb5f1-630c9a','GcxAm8rrAZ','',3,'','','','{\"upi_data\":{\"pa\":\"paytmqr2810050501011x2uay0ea7ef@paytm\",\"pn\":\"Paytm Merchant\"},\"upi_id\":\"paytmqr2810050501011x2uay0ea7ef@paytm\",\"upi_name\":\"Color Game\",\"mid\":\"VQjEgX91371103723060\"}',1,'{\"account_no\":\"asdad\",\"beneficiary_name\":\"nortaxas\",\"ifsc\":\"asd\"}',1,'active','','EXKPA6285E','26-02-2024 14:22:33','26-01-2026 14:22:33','1',NULL),(270,'',0,'EXKPA6295E','$2y$10$1XJJgUnZQdJTt5OJVf4K9e2e4nNLojBlV/RaypK2tERG6s7YOTuuW','FBBSUNun','Aadarsh Ajit','Colour Game','7306721594','aadarshajit4574@gmail.com','EXKPA625E','491084905154','','','','',0,'','','',NULL,1,'',1,'active','','EXKPA6295E','26-02-2024 14:16:28','04-03-2024 14:16:28','1',NULL),(271,'',0,'GCFPM7661G','$2y$10$YLL2U5PdWMIneP3lGDJV5.wpXK4NBZiMQtXvJY3JLamEzPtoVTzMS','','ravi n','Gengusettipatti','9943222009','raviguru0143@Gmail.com','GCFPM7661G','768687878767','','','','',0,'','','',NULL,0,'',0,'active','','GCFPM7661G',NULL,NULL,'0',NULL);
/*!40000 ALTER TABLE `tb_partner` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_settings`
--

DROP TABLE IF EXISTS `tb_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `socket` varchar(10) NOT NULL,
  `base_url` varchar(200) NOT NULL,
  `company_name` varchar(200) NOT NULL,
  `company_account` mediumtext NOT NULL,
  `company_logo` varchar(255) NOT NULL,
  `app_logo` text NOT NULL,
  `company_about` mediumtext NOT NULL,
  `web_fav` varchar(255) NOT NULL,
  `web_tag` text NOT NULL,
  `web_rights` varchar(200) NOT NULL,
  `support` mediumtext NOT NULL,
  `slab_id` int(11) NOT NULL,
  `upi_prefix` varchar(50) NOT NULL,
  `upi_bank` varchar(100) NOT NULL,
  `hypto_token` varchar(200) NOT NULL,
  `authorization` varchar(255) NOT NULL,
  `smsapi` longtext NOT NULL,
  `app_link` text NOT NULL,
  `live_chat` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `notification` longtext NOT NULL,
  `uid` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_settings`
--

LOCK TABLES `tb_settings` WRITE;
/*!40000 ALTER TABLE `tb_settings` DISABLE KEYS */;
INSERT INTO `tb_settings` VALUES (1,'https://','upipay.indiansmmprovider.co.in','UPI PG','{\"account\":\"91700000000\",\"name\":\"test\",\"ifsc\":\"PYTM0123456 ( UPI / IMPS / NEFT )\"}','logo-removebg-preview.png','','Bengaluru Karnataka','https://upipay.indiansmmprovider.co.in/public/uploads/all/62U9RiWsTLJDFPye4O0ox7gVOqRpv6wLbR3cIgLx.gif','UpiFast - Get Instant Settlement with 0 % MDR Fee','UpiFast','{\"mobile\":\"5395001134\",\"mobile1\":\"5395001134\",\"email\":\"admin@apise.in\"}',3,'multipe','upi@upi','NA','NA','{\"username\":\"https://smsapi/login.php?msgid=2\",\"password\":\"https://smsapi/login.php?msgid=2\",\"smsurl\":\"https://smsapi/login.php?msgid=2\"}','http://upipay.indiansmmprovider.co.in/images/brand.png','<script>\n (function () {\n var options = {\n whatsapp: \"5395991134\", // WhatsApp number\n call_to_action: \"WhtsApp Support\", // Call to action\n position: \"right\", // Position may be \'right\' or \'left\'\n };\n var proto = document.location.protocol, host = \"whatshelp.io\", url = proto + \"//static.\" + host;\n var s = document.createElement(\'script\'); s.type = \'text/javascript\'; s.async = true; s.src = url + \'/widget-send-button/js/init.js\';\n s.onload = function () { WhWidgetSendButton.init(host, proto, options); };\n var x = document.getElementsByTagName(\'script\')[0]; x.parentNode.insertBefore(s, x);\n })();\n</script>','<h2><span class=\"marker\"><strong>LifeTime Offer Plan Price: 5000&nbsp;Only</strong></span></h2>\r\n',1,1);
/*!40000 ALTER TABLE `tb_settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_slab`
--

DROP TABLE IF EXISTS `tb_slab`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_slab` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `upi` varchar(50) NOT NULL,
  `van` varchar(50) NOT NULL,
  `imps` varchar(100) NOT NULL,
  `neft` varchar(100) NOT NULL,
  `uid` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_slab`
--

LOCK TABLES `tb_slab` WRITE;
/*!40000 ALTER TABLE `tb_slab` DISABLE KEYS */;
INSERT INTO `tb_slab` VALUES (3,'Default','0.50','0.50','{\"slab1\":\"2.50\",\"slab2\":\"4.30\",\"slab3\":\"8.95\"}','{\"slab1\":\"3.60\",\"slab2\":\"3.60\",\"slab3\":\"3.60\"}',1,1);
/*!40000 ALTER TABLE `tb_slab` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_transactions`
--

DROP TABLE IF EXISTS `tb_transactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_transactions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `token` varchar(100) NOT NULL,
  `user_uid` int(11) NOT NULL,
  `order_id` varchar(50) NOT NULL,
  `client_orderid` varchar(200) NOT NULL,
  `date` date NOT NULL,
  `time` varchar(50) NOT NULL,
  `type` varchar(50) NOT NULL,
  `mode` varchar(50) NOT NULL,
  `pay_upi` varchar(100) NOT NULL,
  `upi_id` varchar(100) NOT NULL,
  `rrn` varchar(100) NOT NULL,
  `txn_amount` varchar(100) NOT NULL,
  `fees` varchar(100) NOT NULL,
  `settle_amount` varchar(100) NOT NULL,
  `closing_balance` varchar(100) NOT NULL,
  `txn_type` varchar(20) NOT NULL,
  `remark` text NOT NULL,
  `status` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_transactions`
--

LOCK TABLES `tb_transactions` WRITE;
/*!40000 ALTER TABLE `tb_transactions` DISABLE KEYS */;
INSERT INTO `tb_transactions` VALUES (3,'',249,'U3ncfuA1hH','','2023-02-08','11:13:22 AM','Received - Admin','DCA','917800152849','GDZPM8799A','1675835002','5000','0','5000','5012','CREDIT','Admin','COMPLETED');
/*!40000 ALTER TABLE `tb_transactions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_upis`
--

DROP TABLE IF EXISTS `tb_upis`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_upis` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) NOT NULL,
  `upi_uid` int(11) NOT NULL,
  `upi_id` varchar(100) NOT NULL,
  `upi_name` varchar(200) NOT NULL,
  `pan` varchar(10) NOT NULL,
  `category` varchar(100) NOT NULL,
  `address` varchar(200) NOT NULL,
  `date` varchar(50) NOT NULL,
  `time` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_upis`
--

LOCK TABLES `tb_upis` WRITE;
/*!40000 ALTER TABLE `tb_upis` DISABLE KEYS */;
INSERT INTO `tb_upis` VALUES (14,1,45545,'nn@upi','fdgfd','HXsdssdsd2','Restaurants','ADDRESS','2023-02-18','02:42:57 AM','PENDING');
/*!40000 ALTER TABLE `tb_upis` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tb_virtualtxn`
--

DROP TABLE IF EXISTS `tb_virtualtxn`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tb_virtualtxn` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `credited_at` varchar(100) NOT NULL,
  `bene_account_no` varchar(200) NOT NULL,
  `bene_account_ifsc` varchar(200) NOT NULL,
  `rmtr_full_name` varchar(200) NOT NULL,
  `rmtr_account_no` varchar(200) NOT NULL,
  `rmtr_account_ifsc` varchar(50) NOT NULL,
  `rmtr_to_bene_note` varchar(255) NOT NULL,
  `txn_id` varchar(200) NOT NULL,
  `amount` varchar(200) NOT NULL,
  `charges_gst` varchar(200) NOT NULL,
  `settled_amount` varchar(200) NOT NULL,
  `txn_time` varchar(100) NOT NULL,
  `created_at` varchar(100) NOT NULL,
  `payment_type` varchar(50) NOT NULL,
  `bank_ref_num` varchar(50) NOT NULL,
  `results` longtext,
  `client_orderid` varchar(100) NOT NULL DEFAULT '0',
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tb_virtualtxn`
--

LOCK TABLES `tb_virtualtxn` WRITE;
/*!40000 ALTER TABLE `tb_virtualtxn` DISABLE KEYS */;
INSERT INTO `tb_virtualtxn` VALUES (75,'2023-02-16 04:23:53','s@paytm','W3EGUVYEs676501592','nfjf@mail.com','4358764587 - 88171676501591','Txn Success','Payment received from name','1676501633','1.00','0','1.00','2023-02-16 04:23:41.0','2023-02-16 04:23:41.0','UPI','304775593756','{\"TXNID\":\"20230216010350000832833673962710483\",\"BANKTXNID\":\"304775593756\",\"ORDERID\":\"W3EGUVYEej1676501592\",\"TXNAMOUNT\":\"1.00\",\"STATUS\":\"TXN_SUCCESS\",\"TXNTYPE\":\"SALE\",\"GATEWAYNAME\":\"PPBL\",\"RESPCODE\":\"01\",\"RESPMSG\":\"Txn Success\",\"MID\":\"idVKUA69203033163757\",\"PAYMENTMODE\":\"UPI\",\"REFUNDAMT\":\"0.0\",\"TXNDATE\":\"2023-02-16 04:23:41.0\",\"currentTxnCount\":\"1\"}','88171676501591',1),(110,'2024-02-26 03:05:17','paytmqr2810050501011x2uay0ea7ef@paytm','SfsLXAzI5K1708940056','aadarshajit4574@gmail.com','7306721594 - 65dc5b17b49f01708940055','Txn Success','854','1708940117','10.00','0','10.00','2024-02-26 15:05:11.0','2024-02-26 15:05:11.0','UPI','405724451459','{\"TXNID\":\"20240226011020000968890561618746274\",\"BANKTXNID\":\"405724451459\",\"ORDERID\":\"SfsLXAzI5K1708940056\",\"TXNAMOUNT\":\"10.00\",\"STATUS\":\"TXN_SUCCESS\",\"TXNTYPE\":\"SALE\",\"GATEWAYNAME\":\"PPBEX\",\"RESPCODE\":\"01\",\"RESPMSG\":\"Txn Success\",\"BANKNAME\":\"Federal Bank\",\"MID\":\"VQjEgX91371103723060\",\"PAYMENTMODE\":\"UPI\",\"REFUNDAMT\":\"0.0\",\"TXNDATE\":\"2024-02-26 15:05:11.0\",\"MERC_UNQ_REF\":\"2810050501011X2UAY0EA7EF\",\"POS_ID\":\"689067\",\"UDF_1\":\"689067\",\"currentTxnCount\":\"1\"}','65dc5b17b49f01708940055',268),(111,'2024-02-26 04:11:31','paytmqr2810050501011x2uay0ea7ef@paytm','R5WtW2slYO1708944070','aadarshajit4574@gmail.com','7306721594 - 65dc6ac60151f1708944070','Txn Success','854','1708944091','100.00','0','100.00','2024-02-26 16:11:21.0','2024-02-26 16:11:21.0','UPI','442327331002','{\"TXNID\":\"20240226010880000968907215568171746\",\"BANKTXNID\":\"442327331002\",\"ORDERID\":\"R5WtW2slYO1708944070\",\"TXNAMOUNT\":\"100.00\",\"STATUS\":\"TXN_SUCCESS\",\"TXNTYPE\":\"SALE\",\"GATEWAYNAME\":\"PPBEX\",\"RESPCODE\":\"01\",\"RESPMSG\":\"Txn Success\",\"BANKNAME\":\"Federal Bank\",\"MID\":\"VQjEgX91371103723060\",\"PAYMENTMODE\":\"UPI\",\"REFUNDAMT\":\"0.0\",\"TXNDATE\":\"2024-02-26 16:11:21.0\",\"MERC_UNQ_REF\":\"2810050501011X2UAY0EA7EF\",\"POS_ID\":\"689067\",\"UDF_1\":\"689067\",\"currentTxnCount\":\"2\"}','65dc6ac60151f1708944070',268);
/*!40000 ALTER TABLE `tb_virtualtxn` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2024-03-01 14:34:46
