search

ALT-PI-Fintech / org-billing-system-backend

0 stars 1 forks source link

Import All Data in tables and export it with every one #27

Closed DevAltpiin closed 3 months ago

DevAltpiin commented 4 months ago

export

DevAltpiin commented 4 months ago

CREATE TABLE IF NOT EXISTS biller ( biller_id int(11) NOT NULL AUTO_INCREMENT, country_id int(11) DEFAULT NULL, biller_code varchar(6) NOT NULL, biller_status varchar(1) DEFAULT NULL, biller_name varchar(100) DEFAULT NULL, biller_category varchar(6) NOT NULL, upi_trailer varchar(100) DEFAULT NULL, npci_id_1 varchar(30) DEFAULT NULL, npci_id_2 varchar(30) DEFAULT NULL, txn_auth_yn varchar(1) DEFAULT NULL, payment_method_01 varchar(15) DEFAULT NULL, payment_method_02 varchar(15) DEFAULT NULL, payment_method_03 varchar(15) DEFAULT NULL, payment_method_04 varchar(15) DEFAULT NULL, source_of_bill_code varchar(6) NOT NULL, agent_id int(6) NOT NULL, logo_image longblob, logoimage_indicator varchar(1) DEFAULT NULL, theme varchar(15) DEFAULT NULL, background_image longblob, backgroundimage_indicator varchar(1) DEFAULT NULL, createdAt datetime NOT NULL, updatedAt datetime NOT NULL, PRIMARY KEY (biller_id), UNIQUE KEY Party_Code (biller_code) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='This is the Biller Information' AUTO_INCREMENT=139 ;

-- -- Dumping data for table biller

INSERT INTO biller (biller_id, country_id, biller_code, biller_status, biller_name, biller_category, upi_trailer, npci_id_1, npci_id_2, txn_auth_yn, payment_method_01, payment_method_02, payment_method_03, payment_method_04, source_of_bill_code, agent_id, logo_image, logoimage_indicator, theme, background_image, backgroundimage_indicator, createdAt, updatedAt) VALUES (1, 1, 'OKC', '1', 'OK Chalo', '', '', '', '', '', 'Y', 'N', 'N', 'N', '', 0, 0x3f, '', '', 0x3f, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (3, 1, 'CCSA', '1', 'ABC Credit Co-op Society', '', '', '', '', '', '', '', '', '', '', 0, 0x3f, '', '', 0x3f, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (7, 1, 'ALPUAE', '1', 'Alt-Pi UAE', '', '', '', '', '', '', '', '', '', '', 0, 0x3f, '', '', 0x3f, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (9, 1, 'PSTLN', '1', 'Postilion -OKC', '', '', '', '', '', '', '', '', '', '', 0, 0x3f, '', '', 0x3f, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');

CREATE TABLE IF NOT EXISTS bill_frequency ( bill_freq_id int(2) NOT NULL AUTO_INCREMENT, frequency_code varchar(6) NOT NULL, frequency_description varchar(20) NOT NULL, PRIMARY KEY (bill_freq_id) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

-- -- Dumping data for table bill_frequency

INSERT INTO bill_frequency (bill_freq_id, frequency_code, frequency_description) VALUES (1, 'DAILY', 'DAILY'), (2, 'MONTH', 'MONTHLY'), (3, 'QRTR', 'QUARTERLY'), (4, 'HLFYR', 'HALF YEARLY'), (5, 'YRLY', 'YEARLY'); -- phpMyAdmin SQL Dump -- version 3.2.0.1 -- http://www.phpmyadmin.net

-- Host: localhost -- Generation Time: Jun 11, 2024 at 12:37 PM -- Server version: 5.1.36 -- PHP Version: 5.3.0

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

/!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 /;

-- -- Database: dev_malaysia

-- -- Table structure for table agent_biller_details

CREATE TABLE IF NOT EXISTS agent_biller_details ( agent_id int(6) NOT NULL AUTO_INCREMENT, AppRefSrNo int(11) DEFAULT NULL, biller_id int(6) DEFAULT NULL, biller_code varchar(6) DEFAULT NULL, agent_name varchar(100) DEFAULT NULL, agent_type varchar(6) DEFAULT NULL, Tax_Id_No varchar(100) DEFAULT NULL, Address_1 varchar(100) DEFAULT NULL, Address_2 varchar(100) DEFAULT NULL, City varchar(50) DEFAULT NULL, State varchar(50) DEFAULT NULL, ZIP varchar(10) DEFAULT NULL, Title varchar(3) DEFAULT NULL, First_Name varchar(50) DEFAULT NULL, Last_Name varchar(50) DEFAULT NULL, Mobile_No varchar(15) DEFAULT NULL, Email_Id varchar(30) DEFAULT NULL, Business_Reg_Document mediumblob, Business_Tax_Id_Document mediumblob, Individual_Id_Document mediumblob, Bank_Name varchar(100) DEFAULT NULL, Bank_Address varchar(100) DEFAULT NULL, Bank_Routing_No int(11) DEFAULT NULL, Account_Name varchar(100) DEFAULT NULL, Account_No varchar(30) DEFAULT NULL, V_AC_Id varchar(100) DEFAULT NULL, V_Ac_No varchar(100) DEFAULT NULL, V_IFSC_No varchar(100) DEFAULT NULL, V_UPI_Handle varchar(100) DEFAULT NULL, Label varchar(100) DEFAULT NULL, Password varchar(50) DEFAULT NULL, MDR_Percentage decimal(5,2) DEFAULT NULL, createdAt datetime NOT NULL, updatedAt datetime NOT NULL, PRIMARY KEY (agent_id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='This is the agent table who introduces us to various billers' AUTO_INCREMENT=1 ;

-- -- Dumping data for table agent_biller_details

-- -- Table structure for table biller

CREATE TABLE IF NOT EXISTS biller ( Biller_Id int(11) NOT NULL AUTO_INCREMENT, Country_Id int(11) DEFAULT NULL, Biller_Code varchar(6) NOT NULL, Biller_Status varchar(1) DEFAULT NULL, Biller_Name varchar(100) DEFAULT NULL, Biller_Category varchar(6) NOT NULL, UPI_Trailer varchar(100) DEFAULT NULL, NPCI_ID_1 varchar(30) DEFAULT NULL, NPCI_ID_2 varchar(30) DEFAULT NULL, Txn_Auth_YN varchar(1) DEFAULT NULL, Payment_Method_01 varchar(15) DEFAULT NULL, Payment_Method_02 varchar(15) DEFAULT NULL, Payment_Method_03 varchar(15) DEFAULT NULL, Payment_Method_04 varchar(15) DEFAULT NULL, source_of_bill_code varchar(6) NOT NULL, Logo_Image longblob, LogoImage_Indicator varchar(1) DEFAULT NULL, Theme varchar(15) DEFAULT NULL, Background_Image longblob, BackgroundImage_Indicator varchar(1) DEFAULT NULL, createdAt datetime NOT NULL, updatedAt datetime NOT NULL, PRIMARY KEY (Biller_Id), UNIQUE KEY Party_Code (Biller_Code) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='This is the Biller Information' AUTO_INCREMENT=139 ;

-- -- Dumping data for table biller

INSERT INTO biller (Biller_Id, Country_Id, Biller_Code, Biller_Status, Biller_Name, Biller_Category, UPI_Trailer, NPCI_ID_1, NPCI_ID_2, Txn_Auth_YN, Payment_Method_01, Payment_Method_02, Payment_Method_03, Payment_Method_04, source_of_bill_code, Logo_Image, LogoImage_Indicator, Theme, Background_Image, BackgroundImage_Indicator, createdAt, updatedAt) VALUES (1, 1, 'OKC', '1', 'OK Chalo', '', '', '', '', '', 'Y', 'N', 'N', 'N', '', 0x3f, '', '', 0x3f, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (3, 1, 'CCSA', '1', 'ABC Credit Co-op Society', '', '', '', '', '', '', '', '', '', '', 0x3f, '', '', 0x3f, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (7, 1, 'ALPUAE', '1', 'Alt-Pi UAE', '', '', '', '', '', '', '', '', '', '', 0x3f, '', '', 0x3f, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (9, 1, 'PSTLN', '1', 'Postilion -OKC', '', '', '', '', '', '', '', '', '', '', 0x3f, '', '', 0x3f, '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');

-- -- Table structure for table biller_bill

CREATE TABLE IF NOT EXISTS biller_bill ( biller_bill_id int(6) NOT NULL AUTO_INCREMENT COMMENT 'Autoincrement field', biller_id int(6) NOT NULL COMMENT 'this is the same_id picked from biller table', biller_code varchar(6) NOT NULL COMMENT 'biller code picked up from iler table', biller_customer_account_no varchar(20) NOT NULL, biller_bill_no varchar(20) NOT NULL, biller_customer_name varchar(50) NOT NULL, biller_bill_date date NOT NULL, biller_bill_amount decimal(12,2) NOT NULL, biller_other_charges decimal(12,2) NOT NULL, biller_taxes decimal(12,2) NOT NULL, biller_pending_due decimal(12,2) NOT NULL, biller_total_amount_due decimal(12,2) NOT NULL, last_meter_reading decimal(14,2) NOT NULL, current_meter_reading decimal(14,2) NOT NULL, units_consumed decimal(14,2) NOT NULL, reading_date date NOT NULL, paid_indicator varchar(1) NOT NULL, paid_amount decimal(12,2) NOT NULL, paid_date date NOT NULL, PRIMARY KEY (biller_bill_id) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- -- Dumping data for table biller_bill

-- -- Table structure for table biller_category_master

CREATE TABLE IF NOT EXISTS biller_category_master ( id int(11) NOT NULL AUTO_INCREMENT, customer_type varchar(6) NOT NULL, description varchar(45) NOT NULL, notes mediumblob NOT NULL, createdAt datetime NOT NULL, updatedAt datetime NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Biller Category Table , telephone, gas, etc' AUTO_INCREMENT=2 ;

-- -- Dumping data for table biller_category_master

INSERT INTO biller_category_master (id, customer_type, description, notes, createdAt, updatedAt) VALUES (1, 'TELCOM', 'Telephone Service Provider', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');

-- -- Table structure for table biller_contact

CREATE TABLE IF NOT EXISTS biller_contact ( biller_contact_id int(8) NOT NULL AUTO_INCREMENT, biller_id int(6) DEFAULT NULL, address_1 varchar(100) DEFAULT NULL, address_2 varchar(100) DEFAULT NULL, city varchar(50) DEFAULT NULL, state int(11) DEFAULT NULL, pin varchar(10) DEFAULT NULL, country varchar(50) DEFAULT NULL, contact_name_1 varchar(100) DEFAULT NULL, mobile_no_1 varchar(15) DEFAULT NULL, email_1 varchar(30) DEFAULT NULL, contact_name_2 varchar(100) DEFAULT NULL, mobile_no_2 varchar(15) DEFAULT NULL, email_2 varchar(30) DEFAULT NULL, contact_Name_3 varchar(100) DEFAULT NULL, mobile_no_3 varchar(15) DEFAULT NULL, email_3 varchar(30) DEFAULT NULL, PRIMARY KEY (biller_contact_id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- -- Dumping data for table biller_contact

-- -- Table structure for table country

CREATE TABLE IF NOT EXISTS country ( Country_Id int(11) NOT NULL, Country_Name varchar(50) DEFAULT NULL, Currency_Code varchar(4) DEFAULT NULL, createdAt datetime NOT NULL, updatedAt datetime NOT NULL, PRIMARY KEY (Country_Id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table country

INSERT INTO country (Country_Id, Country_Name, Currency_Code, createdAt, updatedAt) VALUES (1, 'India', 'INR', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (2, 'United States of America', 'USD', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (3, 'United Arab Emirates', 'AED', '0000-00-00 00:00:00', '0000-00-00 00:00:00');

-- -- Table structure for table currency

CREATE TABLE IF NOT EXISTS currency ( Currency_ID int(11) NOT NULL AUTO_INCREMENT, Currency_Name varchar(50) DEFAULT NULL, Currency_Code varchar(4) DEFAULT NULL, createdAt datetime NOT NULL, updatedAt datetime NOT NULL, PRIMARY KEY (Currency_ID) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- -- Dumping data for table currency

INSERT INTO currency (Currency_ID, Currency_Name, Currency_Code, createdAt, updatedAt) VALUES (1, 'Indian National Rupee', 'INR', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (2, 'US Dollar', 'USD', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (3, 'United Arab Emirates Dirham', 'AED', '0000-00-00 00:00:00', '0000-00-00 00:00:00');

-- -- Table structure for table customer

CREATE TABLE IF NOT EXISTS customer ( customer_id int(6) NOT NULL AUTO_INCREMENT, app_ref_sr_no int(8) DEFAULT NULL, cust_email_id varchar(30) DEFAULT NULL, cust_mobile_no varchar(30) DEFAULT NULL, cust_last_name varchar(50) DEFAULT NULL, cust_first_name varchar(50) DEFAULT NULL, registered_date datetime DEFAULT NULL, suspended_date datetime DEFAULT NULL, createdAt datetime DEFAULT NULL, updatedAt datetime DEFAULT NULL, PRIMARY KEY (customer_id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='This is the enduser who makes the payments. (from ch_main)' AUTO_INCREMENT=1013 ;

-- -- Dumping data for table customer

INSERT INTO customer (customer_id, app_ref_sr_no, cust_email_id, cust_mobile_no, cust_last_name, cust_first_name, registered_date, suspended_date, createdAt, updatedAt) VALUES (1, NULL, NULL, '8691102166', 'Thakur', 'Sameer', '2023-02-13 00:00:00', '2023-02-13 00:00:00', '2023-02-13 17:37:59', '2023-02-13 17:37:59'), (2, NULL, NULL, '7895312456', 'Shivanand', 'Rama', '2023-02-05 00:00:00', '2033-02-05 00:00:00', '2023-02-05 12:18:16', '2023-02-05 12:18:16'), (3, NULL, NULL, '9096779492', 'Rane', 'Siddhi', '2023-02-20 00:00:00', '2023-02-20 00:00:00', '2023-02-20 13:30:22', '2023-02-20 13:31:32'), (4, NULL, NULL, '9651541511', 'Matre', 'Ashish', '2023-03-20 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (5, NULL, NULL, '9757424239', 'Joshi', 'Sachin', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (7, NULL, NULL, '9876543235', 'Kadam', 'Mahesh', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (8, NULL, NULL, '8108115507', 'Palav', 'Namita', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (9, NULL, NULL, '7895312457', 'Bhoir', 'Sarita', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (10, 3, NULL, '9876543240', 'Salkar', 'Prakash', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2023-11-14 12:40:26'), (11, 6, NULL, '9876543245', 'Pise', 'Manda', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2023-12-27 11:44:49'), (14, NULL, NULL, '9823400207', 'devala', 'ram', '2023-09-27 15:09:38', '2023-09-27 15:09:38', '2023-09-27 15:09:38', '2023-09-27 15:09:38'), (15, NULL, NULL, '9823400217', 'devadla', 'ramadf', '2023-09-27 16:13:15', '2023-09-27 16:13:15', '2023-09-27 16:13:15', '2023-09-27 16:13:15'), (16, NULL, NULL, '9113400217', 'huda', 'ronak', '2023-09-27 17:01:57', '2023-09-27 17:01:57', '2023-09-27 17:01:57', '2023-09-27 17:01:57'), (17, NULL, NULL, '9113400213', 'zha', 'sumit', '2023-09-29 13:36:00', '2023-09-29 13:36:00', '2023-09-29 13:36:00', '2023-09-29 13:36:00'), (19, NULL, NULL, '9213100213', 'gurav', 'neha', '2023-09-29 16:45:25', '2023-09-29 16:45:25', '2023-09-29 16:45:25', '2023-09-29 16:45:25'), (20, 142, NULL, '9213100213', 'Kapoor', 'Vani', '2023-09-29 16:48:46', '2023-09-29 16:48:46', '2023-09-29 16:48:46', '2024-03-21 12:31:28'), (21, 100, NULL, '9213100218', 'Verma', 'Tina', '2023-09-29 16:50:41', '2023-09-29 16:50:41', '2023-09-29 16:50:41', '2024-03-21 12:34:11'), (23, 1, NULL, '9662100218', 'yevle', 'sahil', '2023-10-05 12:58:46', '2023-10-05 12:58:46', '2023-10-05 12:58:46', '2023-10-16 16:47:37'), (24, NULL, 'sarvesh@gmail.com', '7508665566', 'gupta', 'sarvesh', '2023-10-17 16:13:50', '2023-10-17 16:13:50', '2023-10-17 16:13:50', '2023-10-17 16:13:50'), (25, NULL, 'sahil.altpi@gmail.com', '9662100219', 'yevle', 'saadf', '2023-10-31 11:48:00', '2023-10-31 11:48:00', '2023-10-31 11:48:00', '2023-10-31 11:48:00'), (26, 50, 'sarvesh@gmail.com', '7500665566', 'gupta', 'ravika', '2023-11-01 18:49:15', '2023-11-01 18:49:15', '2023-11-01 18:49:15', '2024-03-21 12:34:47'), (27, NULL, 'nasirshah@abc.com', '9776543212', 'Enterprises', 'Al Nassr ', '2023-11-20 17:42:51', '2023-11-20 17:42:51', '2023-11-20 17:42:51', '2023-11-20 17:42:51'), (28, NULL, 'nazirsheikh@one.com', '9822113344', 'Enterprises', 'Al Hafiz ', '2023-11-20 18:00:52', '2023-11-20 18:00:52', '2023-11-20 18:00:52', '2023-11-20 18:00:52'), (30, NULL, 'anyaforger@gmial.com', '7588689518', 'Forger', 'Anya ', '2023-12-19 18:26:13', '2023-12-19 18:26:13', '2023-12-19 18:26:13', '2023-12-19 18:26:13'), (43, NULL, 'raj@gmail.com', '7865216709', 'Tate', 'Raj', '2024-01-05 13:01:55', '2024-01-05 13:01:55', '2024-01-05 13:01:55', '2024-01-05 13:01:55'), (44, NULL, 'tate@gmail,com', '8347983498', 'Tate ', 'Andrew ', '2024-01-05 13:01:56', '2024-01-05 13:01:56', '2024-01-05 13:01:56', '2024-01-05 13:01:56'), (45, NULL, 'abu@gmail.com', '6575632187', 'Tate', 'Abu ', '2024-01-05 13:01:56', '2024-01-05 13:01:56', '2024-01-05 13:01:56', '2024-01-05 13:01:56'), (46, NULL, 'tris@gmail.com', '7632876512', 'Tate', 'Tristian', '2024-01-05 13:01:56', '2024-01-05 13:01:56', '2024-01-05 13:01:56', '2024-01-05 13:01:56'), (47, NULL, 'tris@gmail.com', '76328512', 'Tate', 'Tristian', '2024-01-05 13:09:09', '2024-01-05 13:09:09', '2024-01-05 13:09:09', '2024-01-05 13:09:09'), (48, NULL, 'abu@gmail.com', '65756187', 'Tate', 'Abu ', '2024-01-05 13:09:09', '2024-01-05 13:09:09', '2024-01-05 13:09:09', '2024-01-05 13:09:09'), (49, NULL, 'tate@gmail,com', '83479838', 'Tate ', 'Andrew ', '2024-01-05 13:09:09', '2024-01-05 13:09:09', '2024-01-05 13:09:09', '2024-01-05 13:09:09'), (50, NULL, 'raj@gmail.com', '78652109', 'Tate', 'Raj', '2024-01-05 13:09:09', '2024-01-05 13:09:09', '2024-01-05 13:09:09', '2024-01-05 13:09:09'), (51, NULL, 'tate@gmail,com', '834738', 'Tate ', 'AndrSta', '2024-01-05 13:11:06', '2024-01-05 13:11:06', '2024-01-05 13:11:06', '2024-01-05 13:11:06'), (52, NULL, 'abu@gmail.com', '657561817', 'Tate', 'Abujhgds', '2024-01-05 13:11:06', '2024-01-05 13:11:06', '2024-01-05 13:11:06', '2024-01-05 13:11:06'), (53, NULL, 'tris@gmail.com', '763285612', 'Tate', 'Khalid', '2024-01-05 13:11:06', '2024-01-05 13:11:06', '2024-01-05 13:11:06', '2024-01-05 13:11:06'), (54, NULL, 'raj@gmail.com', '78612109', 'Tate', 'Raju', '2024-01-05 13:11:06', '2024-01-05 13:11:06', '2024-01-05 13:11:06', '2024-01-05 13:11:06'), (55, NULL, 'mutallibqureshi.altpi@gmail.co', '36457698', 'Shaikh', 'Ashok', '2024-01-05 16:17:37', '2024-01-05 16:17:37', '2024-01-05 16:17:37', '2024-01-05 16:17:37'), (56, NULL, 'salman@gmail.com', '765432190', 'Saraf', 'Salman', '2024-01-05 16:31:47', '2024-01-05 16:31:47', '2024-01-05 16:31:47', '2024-01-05 16:31:47'), (57, NULL, 'test@gmail.com', '542134567', 'Kapoor', 'Salman', '2024-01-05 16:36:13', '2024-01-05 16:36:13', '2024-01-05 16:36:13', '2024-01-05 16:36:13'), (58, NULL, 'tris@gmail.com', '7632876512', 'Tate', 'Tristian', '2024-01-05 16:46:30', '2024-01-05 16:46:30', '2024-01-05 16:46:30', '2024-01-05 16:46:30'), (59, NULL, 'tate@gmail,com', '1593248760', 'Tate ', 'Andrew ', '2024-01-05 16:54:42', '2024-01-05 16:54:42', '2024-01-05 16:54:42', '2024-01-05 16:54:42'), (60, NULL, 'abu@gmail.com', '1379842650', 'Tate', 'Abu ', '2024-01-05 16:54:42', '2024-01-05 16:54:42', '2024-01-05 16:54:42', '2024-01-05 16:54:42'), (61, NULL, 'tris@gmail.com', '3491678250', 'Tate', 'Tristian', '2024-01-05 16:54:42', '2024-01-05 16:54:42', '2024-01-05 16:54:42', '2024-01-05 16:54:42'), (62, NULL, 'raj@gmail.com', '3491678402', 'Tate', 'Raj', '2024-01-05 16:54:42', '2024-01-05 16:54:42', '2024-01-05 16:54:42', '2024-01-05 16:54:42'), (63, 2, 'shashotolaha.altpi@gmail.com', '1596423870', 'Gojo', 'Satoro', '2024-01-05 17:32:52', '2024-01-05 17:32:52', '2024-01-05 17:32:52', '2024-01-05 20:05:07'), (64, 1, 'shashotolaha.altpi@gmail.com', '3491576280', 'Geto', 'Sugoru', '2024-01-05 17:44:37', '2024-01-05 17:44:37', '2024-01-05 17:44:37', '2024-01-05 18:54:59'), (65, NULL, 'tate@gmail,com', '1593248761', 'Tate ', 'Andrew ', '2024-01-05 17:46:10', '2024-01-05 17:46:10', '2024-01-05 17:46:10', '2024-01-05 17:46:10'), (66, NULL, 'raj@gmail.com', '3491678412', 'Tate', 'Raj', '2024-01-05 17:46:11', '2024-01-05 17:46:11', '2024-01-05 17:46:11', '2024-01-05 17:46:11'), (67, NULL, 'abu@gmail.com', '1379842659', 'Tate', 'Abu ', '2024-01-05 17:46:11', '2024-01-05 17:46:11', '2024-01-05 17:46:11', '2024-01-05 17:46:11'), (68, NULL, 'tris@gmail.com', '3491678252', 'Tate', 'Tristian', '2024-01-05 17:46:11', '2024-01-05 17:46:11', '2024-01-05 17:46:11', '2024-01-05 17:46:11'), (69, NULL, 'raj@gmail.com', '3491671412', 'Tate', 'Raj', '2024-01-05 17:52:05', '2024-01-05 17:52:05', '2024-01-05 17:52:05', '2024-01-05 17:52:05'), (70, NULL, 'Kenzaku@gmail.com', '1234567121', 'Itadori', 'Kenzaku', '2024-01-05 17:53:18', '2024-01-05 17:53:18', '2024-01-05 17:53:18', '2024-01-05 17:53:18'), (71, 1, 'umesh@techventia.com', '7867867861', 'Mastakar', 'Sumant', '2024-01-05 20:53:49', '2024-01-05 20:53:49', '2024-01-05 20:53:49', '2024-01-05 20:59:41'), (72, NULL, 'test@gmail.com', '7410852963', 'Shaikh', 'Salman', '2024-01-09 15:46:50', '2024-01-09 15:46:50', '2024-01-09 15:46:50', '2024-01-09 15:46:50'), (73, NULL, 'sanjubai@gmail.com', '1234567098', 'bhai', 'sanju', '2024-01-09 15:50:38', '2024-01-09 15:50:38', '2024-01-09 15:50:38', '2024-01-09 15:50:38'), (74, NULL, 'shashotolaha.altpi@gmail.com', '4561879230', 'bhai', 'salu', '2024-01-09 15:52:41', '2024-01-09 15:52:41', '2024-01-09 15:52:41', '2024-01-09 15:52:41'), (75, NULL, 'shashotolaha7709@gmail.com', '1590316780', 'Khan', 'Salman', '2024-01-11 16:27:28', '2024-01-11 16:27:28', '2024-01-11 16:27:28', '2024-01-11 16:27:28'), (76, NULL, 'shashotolaha7709@gmail.com', '1597894620', 'sas', 'dadas', '2024-01-12 12:55:24', '2024-01-12 12:55:24', '2024-01-12 12:55:24', '2024-01-12 12:55:24'), (77, 5, 'paula@gmail.com', '7500667567', 'fandriks', 'paula', '2024-01-23 19:05:59', '2024-01-23 19:05:59', '2024-01-23 19:05:59', '2024-01-23 19:19:42'), (78, 1, 'shetty@gmail.com', '750066757', 'shetty', 'Rubina', '2024-01-24 15:55:38', '2024-01-24 15:55:38', '2024-01-24 15:55:38', '2024-01-24 15:59:40'), (79, NULL, 'tester2@gmail.com', '567676767', 'Testing', 'Tester 2', '2024-01-30 12:29:43', '2024-01-30 12:29:43', '2024-01-30 12:29:43', '2024-01-30 12:29:43'), (80, NULL, 'tester2@gmail.com', '872356452', 'Tesing', 'Tester 2', '2024-01-30 12:31:33', '2024-01-30 12:31:33', '2024-01-30 12:31:33', '2024-01-30 12:31:33'), (81, NULL, 'tester2@gmail.com', '7623673276', 'testing', 'Tester2', '2024-01-30 12:33:13', '2024-01-30 12:33:13', '2024-01-30 12:33:13', '2024-01-30 12:33:13'), (82, NULL, 'tester2@gmail.com', '5678787878', 'testing1', 'Tester2', '2024-01-30 12:34:32', '2024-01-30 12:34:32', '2024-01-30 12:34:32', '2024-01-30 12:34:32'), (83, NULL, 'testeristesting@gmail.com', '7878655621', 'testing267', 'Testing23', '2024-01-30 12:46:25', '2024-01-30 12:46:25', '2024-01-30 12:46:25', '2024-01-30 12:46:25'), (84, NULL, 'testeristesting@gmail.com', '758828763', 'tester123', 'tester123', '2024-01-30 12:48:40', '2024-01-30 12:48:40', '2024-01-30 12:48:40', '2024-01-30 12:48:40'), (85, NULL, 'salmanansari.altpi@gmail.com', '7588289518', 'Altpi', 'Salman', '2024-01-30 12:49:26', '2024-01-30 12:49:26', '2024-01-30 12:49:26', '2024-01-30 12:49:26'), (86, NULL, 'testeristesting@gmail.com', '877767688', 'testingggg', 'tester123', '2024-01-30 12:57:20', '2024-01-30 12:57:20', '2024-01-30 12:57:20', '2024-01-30 12:57:20'), (87, NULL, 'tester2@gmail.com', '7767766776', 'tester2', 'tester2', '2024-01-30 13:00:03', '2024-01-30 13:00:03', '2024-01-30 13:00:03', '2024-01-30 13:00:03'), (88, NULL, 'tester2@gmail.com', '6767676767', 'testing2', 'Tester2', '2024-01-30 13:00:45', '2024-01-30 13:00:45', '2024-01-30 13:00:45', '2024-01-30 13:00:45'), (89, NULL, 'tester3@gmail.com', '6767676776', 'tesing3', 'tester3', '2024-01-30 13:11:44', '2024-01-30 13:11:44', '2024-01-30 13:11:44', '2024-01-30 13:11:44'), (90, NULL, 'test3@gmail.com', '652365326532', 'test', 'Test3', '2024-01-30 13:14:20', '2024-01-30 13:14:20', '2024-01-30 13:14:20', '2024-01-30 13:14:20'), (91, NULL, 'test3@gmail.com', '6776677667', 'test3', 'test3', '2024-01-30 13:14:59', '2024-01-30 13:14:59', '2024-01-30 13:14:59', '2024-01-30 13:14:59'), (92, NULL, 'test4@gmail.com', '7767767776', 'test4', 'tester4', '2024-01-30 13:17:28', '2024-01-30 13:17:28', '2024-01-30 13:17:28', '2024-01-30 13:17:28'), (93, NULL, 'finale@gmail.com', '736322398', 'hay', 'finale ', '2024-01-30 13:19:53', '2024-01-30 13:19:53', '2024-01-30 13:19:53', '2024-01-30 13:19:53'), (94, NULL, 'testinggg@gmail.com', '9734993787', 'testinggg', 'testingggg', '2024-01-30 13:21:05', '2024-01-30 13:21:05', '2024-01-30 13:21:05', '2024-01-30 13:21:05'), (95, NULL, 'testing12@gmail.com', '6776677676', 'tester12', 'testing12', '2024-01-30 13:28:58', '2024-01-30 13:28:58', '2024-01-30 13:28:58', '2024-01-30 13:28:58'), (96, NULL, 'last@gmail.com', '387267376', 'test', 'last', '2024-01-30 13:30:35', '2024-01-30 13:30:35', '2024-01-30 13:30:35', '2024-01-30 13:30:35'), (97, NULL, 'lasted@gmail.com', '932898327', 'tested', 'lasted', '2024-01-30 13:31:10', '2024-01-30 13:31:10', '2024-01-30 13:31:10', '2024-01-30 13:31:10'), (98, NULL, 'existed@gmail.com', '328793287', 'test', 'existing', '2024-01-30 13:36:12', '2024-01-30 13:36:12', '2024-01-30 13:36:12', '2024-01-30 13:36:12'), (99, 21, 'isha@gmail.com', '76732823', 'behra', 'isha', '2024-01-30 14:18:14', '2024-01-30 14:18:14', '2024-01-30 14:18:14', '2024-02-06 12:37:07'), (100, NULL, 'aksa@gmail.com', '233298732987', 'shaikh', 'Aksa', '2024-01-30 14:31:48', '2024-01-30 14:31:48', '2024-01-30 14:31:48', '2024-01-30 14:31:48'), (101, 1, NULL, '1234567891', 'test2', 'laha', '2024-02-05 16:51:47', '2024-02-05 16:51:47', '2024-02-05 16:51:47', '2024-02-05 16:51:47'), (102, 1, 'test4@gmail.com', '1234567895', 'test4', 'test', '2024-02-07 12:03:19', '2024-02-07 12:03:19', '2024-02-07 12:03:19', '2024-02-07 12:03:19'), (103, NULL, 'shetty@gmail.com', '7500667571', 'shetty', 'Rubina', '2024-02-12 12:10:54', '2024-02-12 12:10:54', '2024-02-12 12:10:54', '2024-02-12 12:10:54'), (104, NULL, 'salima@gmail.com', '7500667533', 'raj', 'salima', '2024-02-12 12:12:11', '2024-02-12 12:12:11', '2024-02-12 12:12:11', '2024-02-12 12:12:11'), (105, NULL, 'salima@gmail.com', '7500660033', 'raj', 'salima', '2024-02-12 12:13:09', '2024-02-12 12:13:09', '2024-02-12 12:13:09', '2024-02-12 12:13:09'), (106, NULL, 'sunny@gmail.com', '8016720466', 'doh', 'sunny', '2024-03-11 16:50:01', '2024-03-11 16:50:01', '2024-03-11 16:50:01', '2024-03-11 16:50:01'), (107, 6, 'ravi@gmail.com', '8016700466', 'shankar', 'ravi', '2024-03-12 11:55:45', '2024-03-12 11:55:45', '2024-03-12 11:55:45', '2024-03-19 15:00:45'), (108, 1001, 'jiya@gmail.com', '9874123568', 'Shankar', 'Jiya', '2024-03-14 12:53:02', '2024-03-14 12:53:02', '2024-03-14 12:53:02', '2024-03-14 16:06:39'), (109, 1001, 'jiya@gmail.com', '9874123568', 'Shankar', 'Jiya', '2024-03-14 12:55:41', '2024-03-14 12:55:41', '2024-03-14 12:55:41', '2024-03-14 16:06:39'), (110, 1002, 'aveer@gmail.com', '7874123568', 'Shankar', 'Aveer', '2024-03-14 13:15:46', '2024-03-14 13:15:46', '2024-03-14 13:15:46', '2024-03-14 13:15:46'), (111, 1003, 'shashotolaha7709@gmail.com', '9270999455', 'Laha', 'shashoto', '2024-03-14 15:43:46', '2024-03-14 15:43:46', '2024-03-14 15:43:46', '2024-03-14 15:43:46'), (112, 1006, 'vani@gmail.com', '9364123533', 'Mehta', 'Vanishka', '2024-03-14 16:36:03', '2024-03-14 16:36:03', '2024-03-14 16:36:03', '2024-03-14 16:36:03'), (113, 1007, 'anita@gmail.com', '9364123593', 'Rao', 'Anita', '2024-03-14 16:40:53', '2024-03-14 16:40:53', '2024-03-14 16:40:53', '2024-03-14 16:40:53'), (114, 1003, 'shashotolaha7709@gmail.com', '9270999455', 'Laha', 'shashoto', '2024-03-14 17:03:26', '2024-03-14 17:03:26', '2024-03-14 17:03:26', '2024-03-14 17:03:26'), (115, 1008, 'nikita@gmail.com', '9364123093', 'Sawant', 'Nikita', '2024-03-14 17:26:25', '2024-03-14 17:26:25', '2024-03-14 17:26:25', '2024-03-14 17:26:25'), (116, 1001, NULL, NULL, NULL, NULL, '2024-03-15 16:48:47', '2024-03-15 16:48:47', '2024-03-15 16:48:47', '2024-03-15 16:48:47'), (117, 1002, NULL, NULL, NULL, NULL, '2024-03-15 16:45:19', '2024-03-15 16:45:19', '2024-03-15 16:45:19', '2024-03-15 16:45:19'), (118, 1008, NULL, NULL, NULL, NULL, '2024-03-15 16:54:00', '2024-03-15 16:54:00', '2024-03-15 16:54:00', '2024-03-15 16:54:00'), (1002, 1002, NULL, NULL, NULL, NULL, '2024-03-15 17:29:17', '2024-03-15 17:29:17', '2024-03-15 17:29:17', '2024-03-15 17:29:17'), (1009, 1009, 'ozus@gmail.com', '8864123093', 'Kadam', 'Ozus', '2024-03-20 17:49:59', '2024-03-20 17:49:59', '2024-03-20 17:49:59', '2024-03-20 17:49:59'), (1010, 1010, 'kuhu@gmail.com', '7864123093', 'Kadam', 'KUHU', '2024-03-20 18:51:25', '2024-03-20 18:51:25', '2024-03-20 18:51:25', '2024-03-20 18:51:25'), (1011, 1011, 'geeta@gmail.com', '9664123093', 'Bali', 'Geeta', '2024-03-21 17:04:55', '2024-03-21 17:04:55', '2024-03-21 17:04:55', '2024-03-21 17:04:55'), (1012, 13, 'yash@gmail.com', '8016700556', 'Dubey', 'Yashna', '2024-03-26 16:45:14', '2024-03-26 16:45:14', '2024-03-26 16:45:14', '2024-03-26 17:13:52');

-- -------------------------------------------------------- Done -------------

-- -- Table structure for table customer_biller_cref

CREATE TABLE IF NOT EXISTS customer_biller_cref ( cust_biller_id int(8) NOT NULL AUTO_INCREMENT, customer_id int(6) NOT NULL, biller_id int(6) NOT NULL, biller_customer_account_no varchar(20) NOT NULL, PRIMARY KEY (cust_biller_id) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- -- Dumping data for table customer_biller_cref

-- -- Table structure for table language_master

CREATE TABLE IF NOT EXISTS language_master ( Id int(11) NOT NULL AUTO_INCREMENT, biller_code varchar(6) NOT NULL, Application_Id int(11) NOT NULL, Language_Code varchar(3) NOT NULL, Language_Description varchar(20) NOT NULL, PRIMARY KEY (Id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- -- Dumping data for table language_master

INSERT INTO language_master (Id, biller_code, Application_Id, Language_Code, Language_Description) VALUES (1, 'CCSA', 1, 'eng', 'English'), (2, 'CCSA', 1, 'mar', 'Marathi'), (3, 'CCSA', 1, 'hin', 'Hindi');

-- -- Table structure for table partner_bank

CREATE TABLE IF NOT EXISTS partner_bank ( partner_bank_id int(6) NOT NULL AUTO_INCREMENT, partner_bank_code varchar(6) DEFAULT NULL, partner_bank_name varchar(30) DEFAULT NULL, partner_bank_status varchar(2) DEFAULT NULL, partner_bank_note blob, createdAt datetime NOT NULL, updatedAt datetime NOT NULL, PRIMARY KEY (partner_bank_id), UNIQUE KEY Partner_Bank_Code (partner_bank_code) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

-- -- Dumping data for table partner_bank

INSERT INTO partner_bank (partner_bank_id, partner_bank_code, partner_bank_name, partner_bank_status, partner_bank_note, createdAt, updatedAt) VALUES (1, 'RBL', 'RBL Bank', '1', 0x3f, '2023-08-24 17:03:31', '2023-08-24 17:03:31'), (8, 'YBL', 'Yes Bank Ltd', '1', 0x3f, '2023-09-07 13:25:16', '2023-09-07 13:25:16');

-- -- Table structure for table payment_methods

CREATE TABLE IF NOT EXISTS payment_methods ( payment_method_id int(6) NOT NULL AUTO_INCREMENT COMMENT 'running unique id', payment_method_code varchar(6) NOT NULL, payment_method_description varchar(20) NOT NULL, PRIMARY KEY (payment_method_id), UNIQUE KEY payment_method_code (payment_method_code), KEY payment_method_description (payment_method_description) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- -- Dumping data for table payment_methods

INSERT INTO payment_methods (payment_method_id, payment_method_code, payment_method_description) VALUES (1, 'DUITNW', 'Do It Now - QR Code'), (2, 'DBTCRD', 'Debit Card'), (3, 'CRTCRD', 'Credit Card');

-- -- Table structure for table payment_txn

CREATE TABLE IF NOT EXISTS payment_txn ( id int(11) NOT NULL AUTO_INCREMENT, TxnId varchar(100) DEFAULT NULL, biller_id int(6) DEFAULT NULL, biller_code varchar(6) DEFAULT NULL, remitter_full_name varchar(50) DEFAULT NULL, remitter_account_number varchar(50) DEFAULT NULL, remitter_account_ifsc varchar(20) DEFAULT NULL, remitter_phone_number int(11) DEFAULT NULL, unique_transaction_reference varchar(20) DEFAULT NULL, application_reference_no varchar(20) NOT NULL, payment_mode varchar(6) DEFAULT NULL, amount decimal(15,2) DEFAULT NULL, service_charge int(11) DEFAULT NULL, gst_amount decimal(15,2) DEFAULT NULL, service_charge_with_gst int(11) DEFAULT NULL, Bill_No varchar(20) DEFAULT NULL, Txn_code varchar(2) DEFAULT NULL, CustomerDrCr varchar(2) DEFAULT NULL, Txn_Description varchar(100) DEFAULT NULL, status varchar(20) DEFAULT NULL, Local_Validation_Status varchar(1) DEFAULT NULL, transaction_date_time datetime DEFAULT NULL, VA_id varchar(50) DEFAULT NULL, VA_label varchar(30) DEFAULT NULL, VA_virtual_account_number varchar(30) DEFAULT NULL, VA_virtual_ifsc_number varchar(30) DEFAULT NULL, CreditCurrency varchar(4) DEFAULT NULL, CreditRate decimal(15,4) DEFAULT NULL, CreditAmount decimal(15,4) DEFAULT NULL, ChargesCurrency varchar(4) DEFAULT NULL, ChargesAmount decimal(15,4) DEFAULT NULL, Mct_App_RefNo varchar(20) DEFAULT NULL, upi_params_tid varchar(255) DEFAULT NULL, createdAt datetime NOT NULL, updatedAt datetime NOT NULL, endUserAccountNo varchar(20) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- -- Dumping data for table payment_txn

-- -- Table structure for table pay_authority

CREATE TABLE IF NOT EXISTS pay_authority ( PayAuthority_Id int(11) NOT NULL, PayAuthority_Code varchar(4) DEFAULT NULL, PayAuthority_Description varchar(50) DEFAULT NULL, PayAuthority_Note longblob NOT NULL, PayAuthority_Status varchar(2) DEFAULT NULL, createdAt datetime NOT NULL, updatedAt datetime NOT NULL, PRIMARY KEY (PayAuthority_Id), UNIQUE KEY PayAuthority_Code (PayAuthority_Code) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table pay_authority

INSERT INTO pay_authority (PayAuthority_Id, PayAuthority_Code, PayAuthority_Description, PayAuthority_Note, PayAuthority_Status, createdAt, updatedAt) VALUES (2, 'DUIT', 'Payment Corporation of Malaysia', 0x3f, '1', '2023-02-13 17:17:10', '2023-02-13 17:17:10'), (3, 'NBM', 'National Bank Of Malaysia', 0x3f, '1', '2023-02-14 16:40:15', '2023-02-14 16:40:15');

-- -------------------------------------------------------- Done ----------------------------------------------

-- -- Table structure for table prodintegration

CREATE TABLE IF NOT EXISTS prodintegration ( int_id int(11) NOT NULL AUTO_INCREMENT, integration_code varchar(10) DEFAULT NULL, integration_description varchar(100) DEFAULT NULL, product_id int(6) DEFAULT NULL, product_code varchar(8) DEFAULT NULL, biller_id int(6) DEFAULT NULL, biller_code varchar(6) DEFAULT NULL, partner_bank_id int(6) DEFAULT NULL, partner_bank_code varchar(6) DEFAULT NULL, switch_id int(6) DEFAULT NULL, switch_code varchar(6) DEFAULT NULL, payauthority_id int(11) DEFAULT NULL, payauthority_trailer varchar(100) DEFAULT NULL, msg_logo_displ_indicator varchar(1) DEFAULT NULL, display_message varchar(20) DEFAULT NULL, logo_display mediumblob, int_status varchar(2) DEFAULT NULL, key varchar(255) DEFAULT NULL, salt varchar(255) DEFAULT NULL, createdAt datetime NOT NULL, webhook varchar(255) DEFAULT NULL, updatedAt datetime NOT NULL, PRIMARY KEY (int_id), UNIQUE KEY Integration_Code (integration_code) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- -- Dumping data for table prodintegration

-- -- Table structure for table product

CREATE TABLE IF NOT EXISTS product ( Product_Id int(11) NOT NULL, Product_Code varchar(8) DEFAULT NULL, Product_Description varchar(30) DEFAULT NULL, Product_Note longblob NOT NULL, Product_Status varchar(2) DEFAULT NULL, createdAt datetime NOT NULL, updatedAt datetime NOT NULL, PRIMARY KEY (Product_Id), UNIQUE KEY Product_Code (Product_Code) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- -- Dumping data for table product

INSERT INTO product (Product_Id, Product_Code, Product_Description, Product_Note, Product_Status, createdAt, updatedAt) VALUES (1, 'MALCOLL', 'Malaysian Collect', 0x3f, '2', '2023-02-14 17:20:12', '2024-01-09 16:20:47');

-- -- Table structure for table registration_adminuser

CREATE TABLE IF NOT EXISTS registration_adminuser ( id int(11) NOT NULL AUTO_INCREMENT, F_name varchar(20) NOT NULL, L_name varchar(20) NOT NULL, Email varchar(30) NOT NULL, Mobile varchar(15) NOT NULL, Password varchar(15) NOT NULL, createdAt datetime NOT NULL, updatedAt datetime NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;

-- -- Dumping data for table registration_adminuser

INSERT INTO registration_adminuser (id, F_name, L_name, Email, Mobile, Password, createdAt, updatedAt) VALUES (1, 'Sam', 'Zha', 'sm@gmail.com', '9876543210', 'Samzha@123', '2023-12-20 13:36:44', '2023-12-20 13:36:44'), (2, 'Raj', 'Doe', 'rd@gmail.com', '8976543210', 'RajDoe@123', '2023-12-20 15:04:11', '2023-12-20 15:04:11'), (3, 'Nima', 'Jain', 'nimajain@gmail.com', '8108117759', 'nima$12345', '2023-05-18 15:19:02', '2023-05-18 15:19:02'), (4, 'Kunti', 'Jaiswal', 'kuntijaiswal@gmail.com', '9108117766', 'kunti$12345', '2023-05-18 15:22:39', '2023-05-18 15:22:39'), (5, 'Shrav', 'Shelar', 'shravshelar@gmail.com', '8203552744', 'shrav$12345', '2023-05-18 15:27:37', '2023-05-18 15:27:37'), (6, 'Sia', 'Virkar', 'siavirkar@gmail.com', '9135527940', 'Sia$12345', '2023-05-18 16:52:49', '2023-05-18 16:52:49'), (7, 'Kalpana', 'Chwala', 'kalpanachwala@gmail.com', '8863547192', 'KalPana$12345', '2023-05-18 17:33:20', '2023-05-18 17:33:20');

-- -- Table structure for table registration_log_in

CREATE TABLE IF NOT EXISTS registration_log_in ( id int(11) NOT NULL AUTO_INCREMENT, CustomerCode varchar(255) DEFAULT NULL, PartnerAppDateTime datetime DEFAULT NULL, PartnerAppRefNo varchar(255) DEFAULT NULL, CustomerMobileNo varchar(255) DEFAULT NULL, CustomerLatLong varchar(255) DEFAULT NULL, CH_Title varchar(255) DEFAULT NULL, CustomerFirstName varchar(255) DEFAULT NULL, CustomerLastName varchar(255) DEFAULT NULL, CustomerCurrency varchar(255) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=119 ;

-- -- Dumping data for table registration_log_in

INSERT INTO registration_log_in (id, CustomerCode, PartnerAppDateTime, PartnerAppRefNo, CustomerMobileNo, CustomerLatLong, CH_Title, CustomerFirstName, CustomerLastName, CustomerCurrency) VALUES (1, 'pstln', '2001-09-08 00:00:00', '104', '9113451880', 'esrgs', 'Ms', 'foreasf', 'adjsbftyserg', 'INR'), (2, 'pstln', '2001-09-08 00:00:00', '105', '9113789632', 'esrgs', 'Ms', 'rahul', 'moryaaa', 'INR'), (3, 'pstln', '2001-09-08 00:00:00', '105', '9113589632', 'esrgs', 'Ms', 'rahul', 'moryaaa', 'INR'), (4, 'pstln', '2001-09-08 00:00:00', '106', '9113699632', 'esrgs', 'Ms', 'rahuls', 'moryaaa', 'INR'), (5, 'pstln', '2001-09-08 00:00:00', '107', '9113600632', 'esrgs', 'Ms', 'sachin', 'shukla', 'INR'), (6, 'pstln', '2001-09-08 00:00:00', '109', '8113600632', 'esrgs', 'Ms', 'sarita', 'bhoir', 'INR'), (7, 'pstln', '2001-09-08 00:00:00', '109', '8110020632', 'esrgs', 'Ms', 'hemangi', 'dhumal', 'INR'), (8, 'pstln', '2001-09-08 00:00:00', '109', '8110020732', 'esrgs', 'Ms', 'sarvesh', 'dhumal', 'INR'), (9, 'pstln', '2001-09-08 00:00:00', '109', '8110020232', 'esrgs', 'Ms', 'sarveshkh', 'dhumal', 'INR'), (10, 'pstln', '2001-09-08 00:00:00', '110', '8110020993', 'esrgs', 'Ms', 'aveer', 'gupta', 'INR'), (11, 'PSTLN', '2001-11-14 05:30:00', 'OKC/123', '9874563225', '12:33:00 45:67:98', 'Mr', 'Yadavs', 'Siddheshs', 'INR'), (12, 'pstln', '2001-09-08 05:30:00', '110', '9067343773', 'esrgs', 'Ms', 'shubham', 'aher', 'INR'), (13, 'pstln', '2001-09-12 05:30:00', '111', '9833484167', 'esrgs', 'Ms', 'Sejal', 'Yadav', 'INR'), (14, 'pstln', '2001-09-12 05:30:00', '112', '8108117765', 'abcd', 'Ms', 'sejal01', 'yadav', 'INR'), (15, 'pstln', '2001-09-12 05:30:00', '113', '8108117744', 'abcd', 'Mr', 'sejal02', 'yadav', 'INR'), (16, 'pstln', '2001-09-12 05:30:00', '114', '8108117748', 'abcd', 'Mr', 'Ajith', 'yadav', 'INR'), (17, 'pstln', '2001-09-12 05:30:00', 'OKC/114', '8108117749', 'abcd', 'Mr', 'Ajith1', 'yadav', 'INR'), (18, 'pstln', '2001-09-12 05:30:00', '113', '9833004167', 'esrgs', 'Ms', 'Ketan', 'Ambarskar', 'INR'), (19, 'pstln', '2001-09-12 05:30:00', '113', '9813004167', 'esrgs', 'Ms', 'Hemant', 'Balgude', 'INR'), (20, 'pstln', '2001-09-12 00:00:00', '114', '9743389010', 'abcd', 'Mr', 'Rakesh01', 'kumar', 'INR'), (21, 'PSTLN', '2001-09-12 00:00:00', '114', '9743389011', 'abcd', 'Mr', 'Rakesh02', 'kumar', 'INR'), (22, 'PSTLN', '2001-09-12 00:00:00', '114', '9743389012', 'abcd', 'Mr', 'Ajit1', 'kumar', 'INR'), (23, 'pstln', '2001-11-14 05:30:00', 'OKC/123', '8143389020', '12:33:00 45:67:98', 'Mr', 'Ajith2', 'kumar', 'INR'), (24, 'PSTLN', '2001-11-14 05:30:00', 'OKC/123', '9348988999', '12:33:00 45:67:98', 'Mr', 'Naveen', 'Pat', 'INR'), (25, 'PSTLN', '2001-09-13 00:00:00', '114', '9743389056', 'abcd', 'Mr', 'AmitRao', 'Kumar', 'INR'), (26, 'pstln', '2001-09-08 05:30:00', '110', '8110024993', 'esrgs', 'Ms', 'ajit', 'kumar2', 'INR'), (27, 'pstln', '2001-09-08 05:30:00', '110', '8210024993', 'esrgs', 'Ms', 'aji', 'kumar', 'INR'), (28, 'pstln', '2001-09-12 00:00:00', '113', '333333333', 'abcd', 'Mr', 'ajit', 'kumar', 'INR'), (29, 'PSTLN', '2001-09-08 05:30:00', '110', '8210024913', 'esrgs', 'Ms', 'ajit', 'kumar', 'INR'), (30, 'PSTLN', '2023-09-19 13:04:14', 'OKC/123', '8897703038', '12:33:00 45:67:98', 'Mrs', 'Shilpa', 'Ch', 'INR'), (31, 'PSTLN', '2023-09-19 14:48:44', 'OKC/123', '9014614166', '12:33:00 45:67:98', 'Mrs', 'Sadakar', 'Dasari', 'INR'), (32, 'PSTLN', '2001-11-14 05:30:00', 'OKC/123', '9424928056', '12:33:00 45:67:98', 'Mr', 'Naveen', 'Pat', 'INR'), (33, 'PSTLN', '2023-09-19 14:54:43', 'OKC/123', '9014614165', '12:33:00 45:67:98', 'Mrs', 'Sadakar', 'Dasari', 'INR'), (34, 'PSTLN', '2023-09-19 15:02:20', 'OKC/123', '9014614164', '12:33:00 45:67:98', 'Mrs', 'Sadakar', 'Dasari', 'INR'), (35, 'PSTLN', '2001-11-14 05:30:00', 'OKC/123', '9014614163', '12:33:00 45:67:98', 'Mr', 'Naveen', 'Pat', 'INR'), (36, 'PSTLN', '2023-09-19 15:04:56', 'OKC/123', '9014614162', '12:33:00 45:67:98', 'Mrs', 'Sadakar', 'Dasari', 'INR'), (37, 'PSTLN', '2023-09-20 09:57:48', 'OKC/123', '8904765242', '12:33:00 45:67:98', 'Mrs', 'Megha', 'Mal', 'INR'), (38, 'PSTLN', '2001-11-14 05:30:00', 'OKC/123', '9014614161', '12:33:00 45:67:98', 'Mr', '90146', '14161', 'INR'), (39, 'PSTLN', '2023-09-20 10:27:20', 'OKC/123', '8800880088', '12:33:00 45:67:98', 'Mrs', '88008', '80088', 'INR'), (40, 'PSTLN', '2023-09-20 19:50:30', 'OKC/123', '7702385589', '12:33:00 45:67:98', 'Mrs', '77023', '85589', 'INR'), (41, 'PSTLN', '2023-09-21 08:51:01', 'OKC/123', '7675990151', '12:33:00 45:67:98', 'Mrs', '76759', '90151', 'INR'), (42, 'PSTLN', '2023-09-21 12:28:11', 'OKC/123', '7799013311', '12:33:00 45:67:98', 'Mrs', '77990', '13311', 'INR'), (43, 'PSTLN', '2023-09-22 10:00:13', 'OKC/123', '8886482824', '12:33:00 45:67:98', 'Mrs', '88864', '82824', 'INR'), (44, 'PSTLN', '2001-09-25 00:00:00', '115', '7743389056', 'abcd', 'Mr', 'AmitRao', 'Kumar', 'INR'), (45, 'PSTLN', '2001-09-25 00:00:00', '116', '8743389056', 'abcd', 'Mr', 'AmitRao', 'Kumar', 'INR'), (46, 'PSTLN', '2001-09-25 00:00:00', '117', '8743389054', 'abcd', 'Mr', 'Chinnaswamivenugopal', 'Ayyer', 'INR'), (47, 'PSTLN', '2023-09-29 00:47:32', 'OKC/123', '8688253074', '12:33:00 45:67:98', 'Mrs', '86882', '53074', 'INR'), (48, 'PSTLN', '2023-10-01 00:12:40', 'OKC/123', '9000000001', '12:33:00 45:67:98', 'Mrs', '90000', '00001', 'INR'), (49, 'PSTLN', '2023-10-01 16:10:06', 'OKC/123', '7799019932', '12:33:00 45:67:98', 'Mrs', '77990', '19932', 'INR'), (50, 'PSTLN', '2023-10-01 16:18:22', 'OKC/123', '9396293962', '12:33:00 45:67:98', 'Mrs', '93962', '93962', 'INR'), (51, 'PSTLN', '2023-10-01 16:21:16', 'OKC/123', '9246525997', '12:33:00 45:67:98', 'Mrs', '92465', '25997', 'INR'), (52, 'PSTLN', '2023-10-01 16:25:11', 'OKC/123', '9704507233', '12:33:00 45:67:98', 'Mrs', '97045', '07233', 'INR'), (53, 'PSTLN', '2023-10-01 16:26:29', 'OKC/123', '8688357376', '12:33:00 45:67:98', 'Mrs', '86883', '57376', 'INR'), (54, 'PSTLN', '2023-10-01 16:32:18', 'OKC/123', '6304751006', '12:33:00 45:67:98', 'Mrs', '63047', '51006', 'INR'), (55, 'PSTLN', '2023-10-01 16:40:43', 'OKC/123', '9717684678', '12:33:00 45:67:98', 'Mrs', '97176', '84678', 'INR'), (56, 'PSTLN', '2023-10-04 14:23:46', 'OKC/123', '8989488315', '12:33:00 45:67:98', 'Mrs', '89894', '88315', 'INR'), (57, 'PSTLN', '2023-10-05 19:07:37', 'OKC/123', '8688908042', '12:33:00 45:67:98', 'Mrs', '86889', '08042', 'INR'), (58, 'PSTLN', '2023-10-06 11:37:44', 'OKC/123', '9000000003', '12:33:00 45:67:98', 'Mrs', '90000', '00003', 'INR'), (59, 'PSTLN', '2023-10-06 11:39:28', 'OKC/123', '9000000004', '12:33:00 45:67:98', 'Mrs', '90000', '00004', 'INR'), (60, 'PSTLN', '2023-10-06 16:25:10', 'OKC/123', '7702849988', '12:33:00 45:67:98', 'Mrs', '77028', '49988', 'INR'), (61, 'PSTLN', '2023-10-08 08:55:45', 'OKC/123', '7013108602', '12:33:00 45:67:98', 'Mrs', '70131', '08602', 'INR'), (62, 'PSTLN', '2023-10-08 11:53:13', 'OKC/123', '7207917625', '12:33:00 45:67:98', 'Mrs', '72079', '17625', 'INR'), (63, 'PSTLN', '2023-10-08 16:05:22', 'OKC/123', '9700313107', '12:33:00 45:67:98', 'Mrs', '97003', '13107', 'INR'), (64, 'PSTLN', '2023-10-08 16:28:59', 'OKC/123', '9949590755', '12:33:00 45:67:98', 'Mrs', '99495', '90755', 'INR'), (65, 'PSTLN', '2023-10-11 13:58:04', 'OKC/123', '6302134011', '12:33:00 45:67:98', 'Mrs', '63021', '34011', 'INR'), (66, 'PSTLN', '2023-10-11 16:08:20', 'OKC/123', '9032999568', '12:33:00 45:67:98', 'Mrs', '90329', '99568', 'INR'), (67, 'PSTLN', '2023-10-11 16:09:21', 'OKC/123', '6301900216', '12:33:00 45:67:98', 'Mrs', '63019', '00216', 'INR'), (68, 'PSTLN', '2023-10-11 16:11:04', 'OKC/123', '7396642568', '12:33:00 45:67:98', 'Mrs', '73966', '42568', 'INR'), (69, 'PSTLN', '2001-10-13 00:00:00', '118', '8743389051', 'abcd', 'Mr', 'sanjay', 'leela', 'INR'), (70, 'PSTLN', '2001-10-13 00:00:00', '110', '8745581251', 'abcd', 'Mr', 'ronak', 'shahafa', 'INR'), (71, 'PSTLN', '2001-10-13 00:00:00', '111', '8705581251', 'abcd', 'Mr', 'swanand', 'tite', 'INR'), (72, 'PSTLN', '2001-10-13 00:00:00', '112', '8705581271', 'abcd', 'Mr', 'amrit', 'lala', 'INR'), (73, 'PSTLN', '2001-10-13 00:00:00', '112', '8705588271', 'abcd', 'Mr', 'amrxdtit', 'lazla', 'INR'), (74, 'PSTLN', '2001-10-13 00:00:00', '113', '8705118271', 'abcd', 'Mr', 'ranjit', 'desai', 'INR'), (75, 'PSTLN', '2001-10-13 00:00:00', '114', '8705118270', 'abcd', 'Mr', 'sandeep', 'desai', 'INR'), (76, 'PSTLN', '2001-10-13 00:00:00', '115', '8705110270', 'abcd', 'Mr', 'deep', 'saihgfh', 'INR'), (77, 'PSTLN', '2001-10-13 00:00:00', '116', '8115110270', 'abcd', 'Mr', 'hemant', 'kharat', 'INR'), (78, 'PSTLN', '2023-10-13 00:00:00', '124', '7843386060', '75.23', 'Ms', 'Maria', 'Doe', 'INR'), (79, 'PSTLN', '2023-10-16 00:00:00', '125', '7843006060', '75.23', 'Ms', 'Sania', 'Doe', 'INR'), (80, 'PSTLN', '2001-10-17 00:00:00', '117', '8115110210', 'abcd', 'Mr', 'yugraj', 'mohite', 'INR'), (81, 'PSTLN', '2001-10-19 00:00:00', '118', '8115210210', 'abcd', 'Mr', 'urmila', 'gandhari', 'INR'), (82, 'PSTLN', '2023-10-31 10:19:41', 'OKC/123', '7730899291', '12:33:00 45:67:98', 'Mrs', '77308', '99291', 'INR'), (83, 'PSTLN', '2023-11-01 15:54:54', 'OKC/123', '9111111111', '12:33:00 45:67:98', 'Mrs', '91111', '11111', 'INR'), (84, 'PSTLN', '2023-11-01 20:05:00', 'OKC/123', '9581128488', '12:33:00 45:67:98', 'Mrs', '95811', '28488', 'INR'), (85, 'PSTLN', '2023-11-09 10:37:18', 'OKC/123', '9111111112', '12:33:00 45:67:98', 'Mrs', '91111', '11112', 'INR'), (86, 'PSTLN', '2023-11-09 11:42:50', 'OKC/123', '9111111113', '12:33:00 45:67:98', 'Mrs', '91111', '11113', 'INR'), (87, 'PSTLN', '2023-11-09 12:36:45', 'OKC/123', '9533221156', '12:33:00 45:67:98', 'Mrs', '95332', '21156', 'INR'), (88, 'PSTLN', '2023-11-09 13:16:48', 'OKC/123', '9959449440', '12:33:00 45:67:98', 'Mrs', '99594', '49440', 'INR'), (89, 'PSTLN', '2023-11-09 14:26:15', 'OKC/123', '9111111114', '12:33:00 45:67:98', 'Mrs', '91111', '11114', 'INR'), (90, 'PSTLN', '2023-11-14 17:48:33', 'OKC/123', '9111111115', '12:33:00 45:67:98', 'Mrs', '91111', '11115', 'INR'), (91, 'PSTLN', '2023-11-15 09:35:39', 'OKC/123', '9866551677', '12:33:00 45:67:98', 'Mrs', '98665', '51677', 'INR'), (92, 'PSTLN', '2023-11-15 10:21:35', 'OKC/123', '9424708165', '12:33:00 45:67:98', 'Mrs', '94247', '08165', 'INR'), (93, 'PSTLN', '2023-11-16 10:59:44', 'OKC/123', '9391821811', '12:33:00 45:67:98', 'Mrs', '93918', '21811', 'INR'), (94, 'PSTLN', '2023-11-20 11:12:54', 'OKC/123', '8374026283', '12:33:00 45:67:98', 'Mrs', '83740', '26283', 'INR'), (95, 'PSTLN', '2023-11-20 14:41:24', 'OKC/123', '7799324584', '12:33:00 45:67:98', 'Mrs', '77993', '24584', 'INR'), (96, 'PSTLN', '2023-11-20 14:53:40', 'OKC/123', '8328570445', '12:33:00 45:67:98', 'Mrs', '83285', '70445', 'INR'), (97, 'PSTLN', '2023-11-20 15:16:37', 'OKC/123', '7999617705', '12:33:00 45:67:98', 'Mrs', '79996', '17705', 'INR'), (98, 'PSTLN', '2023-11-22 10:22:16', 'OKC/123', '9640272390', '12:33:00 45:67:98', 'Mrs', '96402', '72390', 'INR'), (99, 'PSTLN', '2023-11-25 12:20:32', 'OKC/123', '9346471144', '12:33:00 45:67:98', 'Mrs', '93464', '71144', 'INR'), (100, 'PSTLN', '2023-11-25 12:21:00', 'OKC/123', '8712738945', '12:33:00 45:67:98', 'Mrs', '87127', '38945', 'INR'), (101, 'PSTLN', '2023-11-25 12:23:16', 'OKC/123', '9347374441', '12:33:00 45:67:98', 'Mrs', '93473', '74441', 'INR'), (102, 'PSTLN', '2023-08-24 22:48:16', 'okc', '9421429877', 'shub', 'Mr', 'Shubhm', 'Aher', 'INR'), (103, 'PSTLN', '2023-11-30 18:20:09', 'OKC/123', '9949412208', '12:33:00 45:67:98', 'Mrs', '99494', '12208', 'INR'), (104, 'PSTLN', '2023-08-24 22:48:16', 'okc', '9421429872', 'shub', 'Mr', 'Shubhmqa', 'Aherq', 'INR'), (105, 'PSTLN', '2023-12-01 12:13:38', 'OKC/123', '8839131927', '12:33:00 45:67:98', 'Mrs', '88391', '31927', 'INR'), (106, 'PSTLN', '2023-08-24 22:48:16', 'okc', '9421429873', 'shub', 'Mr', 'Shubhm', 'Aherq', 'INR'), (107, 'PSTLN', '2023-11-30 18:20:09', 'OKC/123', '9949412207', '12:33:00 45:67:98', 'Mrs', '99494', '12207', 'INR'), (108, 'PSTLN', '2023-11-30 18:20:09', 'OKC/123', '93040800591', '12:33:00 45:67:98', 'Mrs', '93040', '800591', 'INR'), (109, 'PSTLN', '2023-12-18 00:00:00', '125', '9545034532', NULL, 'Mr', 'Rihan', 'Raja', 'INR'), (110, 'PSTLN', '2023-12-18 00:00:00', '125', '9545034531', NULL, 'Miss', 'Jeni', 'Jerin', 'INR'), (111, 'PSTLN', '2023-12-18 00:00:00', '125', '9545034531', NULL, 'Miss', 'Jensi', 'Jerdin', 'INR'), (112, 'PSTLN', '2023-12-18 00:00:00', '125', '9545034532', NULL, 'Mr', 'Rihans', 'Rajas', 'INR'), (113, 'PSTLN', '2023-12-18 00:00:00', '125', '9545034531', NULL, 'Miss', 'Jesi', 'Jedin', 'INR'), (114, 'PSTLN', '2023-12-18 00:00:00', '125', '9545034532', NULL, 'Mr', 'Rians', 'Raas', 'INR'), (115, 'PSTLN', '2023-12-18 00:00:00', '125', '9545034538', NULL, 'Mr', 'Rians', 'Raas', 'INR'), (116, 'PSTLN', '2023-12-18 00:00:00', '126', '8845034538', NULL, 'Miss', 'Angha', 'Singh', 'INR'), (117, 'PSTLN', '2023-11-30 18:20:09', 'OKC/123', '8886439911', '12:33:00 45:67:98', 'Mrs', '88864', '39911', 'INR'), (118, 'PSTLN', '2023-12-26 05:30:00', '126', '7824300606', '85.99', 'Miss', 'Aarna', 'Parab', 'INR');

-- --------------------------------------------------------Done --------------------------------------------------

-- -- Table structure for table registration_log_out

CREATE TABLE IF NOT EXISTS registration_log_out ( id int(11) NOT NULL AUTO_INCREMENT, CustomerCode varchar(255) DEFAULT NULL, AppDateTime datetime DEFAULT NULL, RefNo int(11) DEFAULT NULL, PartnerAppRefNo varchar(255) DEFAULT NULL, Assigned_VPA varchar(255) DEFAULT NULL, Result varchar(255) DEFAULT NULL, ErrorCode varchar(255) DEFAULT NULL, ErrorDesc varchar(255) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=46 ;

-- -- Dumping data for table registration_log_out

INSERT INTO registration_log_out (id, CustomerCode, AppDateTime, RefNo, PartnerAppRefNo, Assigned_VPA, Result, ErrorCode, ErrorDesc) VALUES (1, 'OKC', '2001-11-13 05:30:00', 1, NULL, 'altpitest.Aarushi.Kadam@yestransact', '00', NULL, NULL), (2, 'OKC', '2001-11-13 05:30:00', 2, NULL, 'altpitest.Ozas.More@yestransact', '00', NULL, NULL), (3, 'OKC', '2023-02-13 17:37:59', 12, NULL, 'sameer.thakur@altpi', '00', '00', 'success'), (4, 'OKC', '2023-02-20 12:18:16', 122, NULL, 'Siddhi.Rane@altpi', '00', '00', 'success'), (5, 'OKC', '2023-02-20 13:30:22', 122, NULL, 'Siddhi.Rane1@altpi', '00', '00', 'success'), (6, '', '2001-10-13 00:00:00', 71, '111', 'swanancdti@yesbank', '00', NULL, NULL), (7, NULL, '2001-10-13 00:00:00', 77, '116', 'hemantkhar@yesbank', '00', NULL, NULL), (8, 'PSTLN', '2023-10-13 00:00:00', 78, '124', 'mariadoe@yesbank', '00', NULL, NULL), (9, NULL, '2001-10-17 00:00:00', 80, '117', 'yugrajmohi@yesbank', '00', NULL, NULL), (10, NULL, '2001-10-19 00:00:00', 81, '118', 'urmilagand@yesbank', '00', NULL, NULL), (11, NULL, '2023-10-31 10:19:41', 82, 'OKC/123', '7730899291@yesbank', '00', NULL, NULL), (12, NULL, '2023-11-01 15:54:54', 83, 'OKC/123', '9111111111@yesbank', '00', NULL, NULL), (13, NULL, '2023-11-01 20:05:00', 84, 'OKC/123', '9581128488@yesbank', '00', NULL, NULL), (14, NULL, '2023-11-09 10:37:18', 85, 'OKC/123', '9111111112@yesbank', '00', NULL, NULL), (15, NULL, '2023-11-09 11:42:50', 86, 'OKC/123', '9111111113@yesbank', '00', NULL, NULL), (16, NULL, '2023-11-09 12:36:45', 87, 'OKC/123', '9533221156@yesbank', '00', NULL, NULL), (17, NULL, '2023-11-09 13:16:48', 88, 'OKC/123', '9959449440@yesbank', '00', NULL, NULL), (18, NULL, '2023-11-09 14:26:15', 89, 'OKC/123', '9111111114@yesbank', '00', NULL, NULL), (19, NULL, '2023-11-14 17:48:33', 90, 'OKC/123', '9111111115@yesbank', '00', NULL, NULL), (20, NULL, '2023-11-15 09:35:39', 91, 'OKC/123', '9866551677@yesbank', '00', NULL, NULL), (21, NULL, '2023-11-15 10:21:35', 92, 'OKC/123', '9424708165@yesbank', '00', NULL, NULL), (22, NULL, '2023-11-16 10:59:44', 93, 'OKC/123', '9391821811@yesbank', '00', NULL, NULL), (23, NULL, '2023-11-20 11:12:54', 94, 'OKC/123', '8374026283@yesbank', '00', NULL, NULL), (24, NULL, '2023-11-20 14:41:24', 95, 'OKC/123', '7799324584@yesbank', '00', NULL, NULL), (25, NULL, '2023-11-20 14:53:40', 96, 'OKC/123', '8328570445@yesbank', '00', NULL, NULL), (26, NULL, '2023-11-20 15:16:37', 97, 'OKC/123', '7999617705@yesbank', '00', NULL, NULL), (27, NULL, '2023-11-22 10:22:16', 98, 'OKC/123', '9640272390@yesbank', '00', NULL, NULL), (28, NULL, '2023-11-25 12:20:32', 99, 'OKC/123', '9346471144@yesbank', '00', NULL, NULL), (29, NULL, '2023-11-25 12:21:00', 100, 'OKC/123', '8712738945@yesbank', '00', NULL, NULL), (30, NULL, '2023-11-25 12:23:16', 101, 'OKC/123', '9347374441@yesbank', '00', NULL, NULL), (31, NULL, '2023-08-24 22:48:16', 102, 'okc', 'shubhmaher@yesbank', '00', NULL, NULL), (32, NULL, '2023-11-30 18:20:09', 103, 'OKC/123', '9949412208@yesbank', '00', NULL, NULL), (33, NULL, '2023-08-24 22:48:16', 104, 'okc', 'shubhmqaah@yesbank', '00', NULL, NULL), (34, NULL, '2023-12-01 12:13:38', 105, 'OKC/123', '8839131927@yesbank', '00', NULL, NULL), (35, NULL, '2023-08-24 22:48:16', 106, 'okc', 'shubhmaher1@yesbank', '00', NULL, NULL), (36, NULL, '2023-11-30 18:20:09', 107, 'OKC/123', '9949412207@yesbank', '00', NULL, NULL), (37, NULL, '2023-11-30 18:20:09', 108, 'OKC/123', '9304080059@yesbank', '00', NULL, NULL), (38, NULL, '2023-10-16 00:00:00', 110, '125', 'jensijerdi@yesbank', '00', NULL, NULL), (39, NULL, '2023-10-16 00:00:00', 109, '125', 'rihansraja@yesbank', '00', NULL, NULL), (40, NULL, '2023-10-16 00:00:00', 110, '125', 'jesijedin@yesbank', '00', NULL, NULL), (41, NULL, '2023-10-16 00:00:00', 109, '125', 'riansraas@yesbank', '00', NULL, NULL), (42, NULL, '2023-10-16 00:00:00', 115, '125', 'riansraas1@yesbank', '00', NULL, NULL), (43, NULL, '2023-12-18 00:00:00', 116, '126', 'anghasingh@yesbank', '00', NULL, NULL), (44, NULL, '2023-11-30 18:20:09', 117, 'OKC/123', '8886439911@yesbank', '00', NULL, NULL), (45, NULL, '2023-12-26 05:30:00', 118, '126', 'aarnaparab@yesbank', '00', NULL, NULL);

-- -- Table structure for table role_master

CREATE TABLE IF NOT EXISTS role_master ( id int(11) NOT NULL AUTO_INCREMENT, user_type varchar(6) NOT NULL, role varchar(45) NOT NULL, createdAt datetime NOT NULL, updatedAt datetime NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

-- -- Dumping data for table role_master

INSERT INTO role_master (id, user_type, role, createdAt, updatedAt) VALUES (1, 'PADM', 'Super Admin', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (2, 'ADMI', 'Administration', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (3, 'SALE', 'Sales Admin', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (4, 'SALE', 'VP - Sales', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (5, 'SALE', 'GM - Sales', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (6, 'SALE', 'RM - Sales', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (7, 'SALE', 'AM - Sales', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (8, 'SALE', 'Sales Rep', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (9, 'FINA', 'VP-Finance', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (10, 'FINA', 'GM-Finance', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (11, 'FINA', 'Accountant', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (12, 'COLL', 'Collection Manager', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (13, 'COLL', 'Collection Agent', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (14, 'ENDU', 'End User ', '0000-00-00 00:00:00', '0000-00-00 00:00:00');

-- -- Table structure for table saleslogin

CREATE TABLE IF NOT EXISTS saleslogin ( id int(11) NOT NULL AUTO_INCREMENT, MobileNo varchar(15) NOT NULL, Password varchar(30) NOT NULL, createdAt datetime NOT NULL, updatedAt datetime NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- -- Dumping data for table saleslogin

INSERT INTO saleslogin (id, MobileNo, Password, createdAt, updatedAt) VALUES (1, '7588289518', '123456', '0000-00-00 00:00:00', '0000-00-00 00:00:00');

-- -- Table structure for table source_of_bill

CREATE TABLE IF NOT EXISTS source_of_bill ( source_of_bill_id int(3) NOT NULL AUTO_INCREMENT, source_of_bill_code varchar(6) NOT NULL, source_of_bill_description varchar(20) NOT NULL, PRIMARY KEY (source_of_bill_id) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- -- Dumping data for table source_of_bill

INSERT INTO source_of_bill (source_of_bill_id, source_of_bill_code, source_of_bill_description) VALUES (1, 'XLSX', 'Excel File'), (2, 'XML', 'XML File'), (3, 'API', 'API File');

-- -- Table structure for table switch_master

CREATE TABLE IF NOT EXISTS switch_master ( switch_id int(6) NOT NULL AUTO_INCREMENT, switch_code varchar(6) DEFAULT NULL, switch_name varchar(30) DEFAULT NULL, switch_status varchar(2) DEFAULT NULL, switch_note longblob NOT NULL, createdAt datetime NOT NULL, updatedAt datetime NOT NULL, PRIMARY KEY (switch_id), UNIQUE KEY Switch_Code (switch_code) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

-- -- Dumping data for table switch_master

INSERT INTO switch_master (switch_id, switch_code, switch_name, switch_status, switch_note, createdAt, updatedAt) VALUES (1, 'MBW', 'Mobileware', '1', 0x3f, '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (6, 'EASBZZ', 'EASEBUZZ', '1', 0x3f, '2023-08-24 16:44:44', '2024-01-09 16:21:05');

-- -- Table structure for table systemcode

CREATE TABLE IF NOT EXISTS systemcode ( id int(11) NOT NULL AUTO_INCREMENT, Code_Type varchar(30) NOT NULL, Sys_Code varchar(4) DEFAULT NULL, Code_Description varchar(50) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=91 ;

-- -- Dumping data for table systemcode

INSERT INTO systemcode (id, Code_Type, Sys_Code, Code_Description) VALUES (1, 'User_Status', '0', 'Added'), (2, 'User_Status', '1', 'Live'), (3, 'User_Status', '2', 'Suspended'), (4, 'User_Status', '9', 'Deleted'), (5, 'Party_Status', '1', 'Live'), (6, 'Party_Status', '2', 'Suspended'), (7, 'Party_Status', '9', 'Deleted'), (8, 'PARTY_TYPE', '0', 'Partner Bank'), (9, 'PARTY_TYPE', '0', 'Commercial Bank'), (10, 'PARTY_TYPE', '0', 'Urban Coop Bank'), (11, 'PARTY_TYPE', '0', 'DCC'), (12, 'PARTY_TYPE', '0', 'Credit Union'), (13, 'PARTY_TYPE', '0', 'Non-Banking Finance Company'), (14, 'PARTY_TYPE', '0', 'Corporate/Company'), (15, 'CARD_STATUS', '1', 'On'), (16, 'CARD_STATUS', '9', 'Off'), (17, 'CARD_STATUS', '7', 'Switched Off by Main CH'), (18, 'CARD_STATUS', '8', 'Switched Off by App/System'), (19, 'TXN_TYPE', '0', 'New VPA'), (20, 'TXN_TYPE', '0', 'Delete VPA'), (21, 'TXN_TYPE', '0', 'VPA based Debit'), (22, 'TXN_TYPE', '0', 'QR based Credit/Push'), (23, 'TXN_TYPE', '0', 'Chargeback Refund'), (24, 'TXN_TYPE', '0', 'Account Credit'), (25, 'TXN_TYPE', '0', 'Account Debit'), (26, 'REQ_STATUS_VPA', '0', 'Record Added'), (27, 'REQ_STATUS_VPA', '1', 'Success'), (28, 'REQ_STATUS_VPA', '9', 'Failed'), (29, 'REQ_STATUS_VPA', '2', 'In-Process - Attempt 1'), (30, 'REQ_STATUS_VPA', '3', 'In-Process - Attempt 2'), (31, 'REQ_STATUS_VPA', '4', 'In-Process - Attempt 3'), (32, 'REQ_SOURCE_VPA', '1', 'CB System (Real-time)'), (33, 'REQ_SOURCE_VPA', '2', 'CB File'), (34, 'REQ_SOURCE_VPA', '3', 'End-User Mobile '), (35, 'DEVICE_TYPE', '0', 'Android'), (36, 'DEVICE_TYPE', '0', 'IOS'), (37, 'DEVICE_TYPE', '0', 'Linux'), (38, 'DEVICE_TYPE', '0', 'Microsoft'), (39, 'CARD_TYPE', '0', 'Main'), (40, 'CARD_TYPE', '0', 'Add-On'), (41, 'PRE_APPROVED_TXN_STATUS', '1', 'Live'), (42, 'PRE_APPROVED_TXN_STATUS', '2', 'Transacted'), (43, 'PRE_APPROVED_TXN_STATUS', '8', 'Expired'), (44, 'PRE_APPROVED_TXN_STATUS', '9', 'Deleted'), (45, 'VALIDATION_STATUS', '0', 'Not Done/Not Applicable'), (46, 'VALIDATION_STATUS', '1', 'Success'), (47, 'VALIDATION_STATUS', '9', 'Failure'), (48, 'SEND_SMS_STATUS', '0', 'Added'), (49, 'SEND_SMS_STATUS', '1', 'Sent'), (50, 'SEND_SMS_STATUS', '9', 'Failed'), (51, 'TXN_STATUS', '0', 'Record Added'), (52, 'TXN_STATUS', '1', 'Success'), (53, 'TXN_STATUS', '9', 'Failed'), (54, 'TXN_STATUS', '2', 'In-Process'), (55, 'TXN_SOURCE', '1', 'Merchant Website/POS'), (56, 'TXN_SOURCE', '2', 'CH Mobile / Alt-PI App'), (57, 'TXN_SOURCE', '3', 'CH Mobile / Third-party App'), (58, 'TXN_SOURCE', '4', 'CB/NBFC'), (59, 'TXN_SOURCE', '9', 'Alt-PI System/App'), (60, 'TXN_FAILURE_TYPE', '0', 'Alt-PI System'), (61, 'TXN_FAILURE_TYPE', '0', 'PB System'), (62, 'TXN_FAILURE_TYPE', '0', 'CB System'), (63, 'SEND_SMS_FAILURE_REASON', '1', 'Invalid Mobile No'), (64, 'SEND_SMS_FAILURE_REASON', '2', 'Invalid Message Content'), (65, 'SEND_SMS_FAILURE_REASON', '9', 'SMS Server Down'), (66, 'TXN_REQ_FAILURE_REASON', '0', 'System Down'), (67, 'TXN_REQ_FAILURE_REASON', '0', 'Invalid Message Format/Content'), (68, 'TXN_REQ_FAILURE_REASON', '0', 'Invalid VPA'), (69, 'TXN_REQ_FAILURE_REASON', '0', 'Insufficient Balance'), (70, 'TXN_REQ_FAILURE_REASON', '0', 'Account Closed'), (71, 'TXN_REQ_FAILURE_REASON', '0', 'Card Off'), (72, 'TXN_REQ_FAILURE_REASON', '0', 'Card Switched Off by Main Card Holder'), (73, 'TXN_REQ_FAILURE_REASON', '0', 'Not a White-Listed Merchant'), (74, 'TXN_REQ_FAILURE_REASON', '0', 'Not a Pre-Approved Transaction'), (75, 'TXN_REQ_FAILURE_REASON', '0', 'POS Txn Off'), (76, 'TXN_REQ_FAILURE_REASON', '0', 'Online Txn Off'), (77, 'TXN_REQ_FAILURE_REASON', '0', 'ATM Txn Off'), (78, 'TXN_REQ_FAILURE_REASON', '0', 'Over Monthly Limit'), (79, 'TXN_REQ_FAILURE_REASON', '0', 'Over Online Txn Limit'), (80, 'TXN_REQ_FAILURE_REASON', '0', 'Over POS Txn Limit'), (81, 'TXN_REQ_FAILURE_REASON', '0', 'Over ATM Txn Limit'), (82, 'TITLE', '0', 'Mister'), (83, 'TITLE', '0', 'Miz'), (84, 'TITLE', '0', 'Missus'), (85, 'TITLE', '0', 'Doctor'), (86, 'TITLE', '0', 'Esquire'), (87, 'TITLE', '0', 'Professor'), (88, 'GENDER', '0', 'Male'), (89, 'GENDER', '0', 'Female'), (90, 'Party_Status', '8', 'Onboarding');

-- -- Table structure for table ui_merchant

CREATE TABLE IF NOT EXISTS ui_merchant ( id int(11) NOT NULL AUTO_INCREMENT, Int_Id int(11) NOT NULL, Integration_Code varchar(10) DEFAULT NULL, header varchar(256) DEFAULT NULL, headerAttribute varchar(30) DEFAULT NULL, mainLogo longblob, mainLogoAttribute varchar(30) DEFAULT NULL, productLogo longblob, productLogoAttribute varchar(30) DEFAULT NULL, pageTitle1 varchar(100) DEFAULT NULL, pageTitle1_Attribute varchar(30) DEFAULT NULL, PageTitle2 varchar(100) DEFAULT NULL, PageTitle2_Attribute varchar(30) DEFAULT NULL, PageTitle3 varchar(100) DEFAULT NULL, pageTitle3_Attribute varchar(30) DEFAULT NULL, Footer varchar(50) DEFAULT NULL, FooterAttribute varchar(30) DEFAULT NULL, createdAt datetime NOT NULL, updatedAt datetime NOT NULL, PRIMARY KEY (id), UNIQUE KEY Integration_Code (Integration_Code) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- -- Dumping data for table ui_merchant

-- -- Table structure for table user_access

CREATE TABLE IF NOT EXISTS user_access ( id int(11) NOT NULL AUTO_INCREMENT, Party_Code varchar(6) NOT NULL, party_type varchar(4) NOT NULL, user_type varchar(6) NOT NULL, role varchar(45) NOT NULL, accessCode varchar(45) NOT NULL, parentalAccess varchar(45) NOT NULL, principalAccess varchar(45) NOT NULL, no_Of_Nodes varchar(45) NOT NULL, APIName varchar(45) NOT NULL, Param1 varchar(45) DEFAULT NULL, Param2 varchar(45) DEFAULT NULL, Param3 varchar(45) DEFAULT NULL, Param4 varchar(45) DEFAULT NULL, Param5 varchar(45) DEFAULT NULL, createdAt datetime NOT NULL, updatedAt datetime NOT NULL, Access_Code varchar(45) NOT NULL, Principal_Access varchar(45) NOT NULL, PRIMARY KEY (id), UNIQUE KEY PartyWiseAccess (Party_Code,party_type,user_type,role,accessCode) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

-- -- Dumping data for table user_access

INSERT INTO user_access (id, Party_Code, party_type, user_type, role, accessCode, parentalAccess, principalAccess, no_Of_Nodes, APIName, Param1, Param2, Param3, Param4, Param5, createdAt, updatedAt, Access_Code, Principal_Access) VALUES (1, 'ALTPI', 'PRIN', 'PADMIN', 'Super Admin', '1.0', '', '', '1', '', '', '', '1.0', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''), (2, 'ALTPI', 'PRIN', 'SALES', 'VP-Sales', '1.1.0', '', '', '2', '', '', '', '1.1', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''), (3, 'ALTPI', 'PRIN', 'SALES', 'RM-Sales', '1.1.1', '1.1', '', '0', '', '', '', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''), (4, 'ALTPI', 'PRIN', 'SALES', 'RM-Sales', '1.1.2', '1.1', '', '0', '', '', '', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''), (5, 'OKC', 'CUST', 'ADMIN', 'Administration', '1.0', '', '1.0', '1', '', '', '', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''), (6, 'OKC', 'CUST', 'SALES', 'RM-Sales', '1.1.0', '', '1.1.2', '1', '', '', '', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''), (7, 'OKC', 'CUST', 'ENDUSR', 'End User', '1.1.1', '', '', '', '', '', '', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''), (8, 'CCSA', 'CUST', 'ADMIN', 'Administration', '1.0', '', '1.0', '1', '', '', '', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''), (9, 'CCSA', 'CUST', 'COLLEC', 'Collection', '1.1.0', '1.0', '1.1.1', '2', '', '', '', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''), (10, 'CCSA', 'CUST', 'COLLEC', 'Collection Agent', '1.1.1.0', '1.1.0', '', '2', '', '', '', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''), (11, 'CCSA', 'CUST', 'COLLEC', 'Collection Agent', '1.1.2.0', '1.1.0', '', '2', '', '', '', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''), (12, 'CCSA', 'CUST', 'ENDUSR', 'End User', '1.1.1.1', '1.1.1.0', '', '', '', '', '', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''), (13, 'CCSA ', 'CUST', 'ENDUSR', 'End User', '1.1.1.2', '1.1.1.0', '', '', '', '', '', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''), (14, 'CCSA', 'CUST', 'ENDUSR', 'End User', '1.1.2.1', '1.1.2.0', '', '', '', '', '', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''), (15, 'CCSA ', 'CUST', 'ENDUSE', 'End User', '1.1.2.2', '1.1.2.0', '', '', '', '', '', '', '', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '');

-- -- Table structure for table user_master

CREATE TABLE IF NOT EXISTS user_master ( id int(11) NOT NULL AUTO_INCREMENT, Party_Code varchar(6) DEFAULT NULL, party_type varchar(4) DEFAULT NULL, user_type varchar(6) DEFAULT NULL, role varchar(45) DEFAULT NULL, Ch_Id int(11) DEFAULT NULL, F_name varchar(20) DEFAULT NULL, L_name varchar(20) DEFAULT NULL, Email varchar(50) DEFAULT NULL, Mobile_No varchar(15) DEFAULT NULL, Password varchar(15) DEFAULT NULL, Status varchar(2) DEFAULT NULL, Register_date varchar(10) DEFAULT NULL, Leave_date varchar(10) DEFAULT NULL, Last_otp varchar(6) DEFAULT NULL, Last_otp_dateTime varchar(15) DEFAULT NULL, Access_Code varchar(30) DEFAULT NULL, Parental_Access varchar(30) DEFAULT NULL, Principal_Access varchar(30) DEFAULT NULL, NoOfNodes int(11) DEFAULT NULL, userName varchar(30) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=448 ;

-- -- Dumping data for table user_master

INSERT INTO user_master (id, Party_Code, party_type, user_type, role, Ch_Id, F_name, L_name, Email, Mobile_No, Password, Status, Register_date, Leave_date, Last_otp, Last_otp_dateTime, Access_Code, Parental_Access, Principal_Access, NoOfNodes, userName) VALUES (1, 'ALTP', 'PRIN', 'PADMIN', 'Super Admin', 0, 'Milind', 'Satpute', 'milind.satpute@altpi.com', NULL, '12', '1', '', '', '', '', '1.0', '', '', 1, 'milind.satpute@altpi.com'), (2, 'ALTP', 'PRIN', 'SALES', 'VP-Sales', 0, 'Manoj', 'Mirchandani', 'm.mirchandai@altpi.com', NULL, '123456', '', '', '', '', '', '1.1.0', '1.0', '', 3, NULL), (3, 'ALTP', 'PRIN', 'SALES', 'RM-Sales-West', 0, 'Makarand', 'Behre', 'm.behre@altpi.com', NULL, '123456', '', '', '', '', '', '1.1.1.0', '1.1.0', '', 1, NULL), (4, 'ALTP', 'PRIN', 'SALES', 'RM-Sales-East', 0, 'Rajesh', 'Oak', 'r.oak@altpi.com', NULL, '00123', '', '', '', '', '', '1.1.2.0', '1.1.0', '', 0, NULL), (5, 'OKC', 'CUST', 'ADMIN', 'Administration', 0, 'Bhaskar', 'Varun', 'bvarun@okc.om', NULL, '98765', '1', '', '', '', '', '1.0', '', '1.0', 1, NULL), (6, 'OKC', 'CUST', 'SALES', 'RM-Sales', 0, 'John', 'Dmello', 'johnd@gmail.com', NULL, '1234', '1', '3/2/2023', '', '4561', '', '1.1.0', '1.0', '1.1.2.0', 1, NULL), (7, 'OKC', 'CUST', 'ENDUSR', 'End User', 2, 'Ram', 'Shivanand', 'ramas@gmail.com', NULL, 'sdf21', '1', '5/2/2023', '', '5122', '', '1.1.1.0', '1.1.0', '1.1.2.0', 0, NULL), (8, 'CCSA', 'CUST', 'ADMIN', 'Administration', 0, 'Suresh', 'Pawar', 'spawar@atmanand.com', NULL, '123456', '', '', '', '', '', '1.0', '', '1.0', 1, 'spawar@atmanand.com'), (9, 'CCSA', 'CUST', 'COLLEC', 'Collection Manager', 0, 'Vikas ', 'Pawar', 'vpawar@atmanand.com', NULL, '123456', '', '', '', '', '', '1.1.0', '1.0', '1.1.1.0', 3, NULL), (10, 'CCSA', 'CUST', 'COLLEC', 'Collection Agent', 0, 'Chandu ', 'Savji', 'csavji@atmanand.com', '1234567890', 'pqr123', '', '', '', '', '', '1.1.1.0', '1.1.0', '1.1.1.0', 6, NULL), (11, 'CCSA', 'CUST', 'COLLEC', 'Collection Agent', 0, 'Magan', 'Dhavale', 'mdhavale@atmanand.com', '9876543225', '123456', '', '', '', '', '', '1.1.3.0', '1.1.0', '1.1.1.0', 4, NULL), (12, 'CCSA', 'CUST', 'ENDUSR', 'End User', 6, 'Dadu', 'Sane', 'saned@gmail.com', NULL, 'dadu123456', '1', '', '', '', '', '1.1.1.1.0', '1.1.1.0', '1.1.1.0', 0, NULL), (13, 'CCSA', 'CUST', 'ENDUSR', 'End User', 7, 'Mahesh', 'Kadam', 'kadamm@gmail.com', NULL, 'MaheshKadam@123', '', '', '', '', '', '1.1.1.2.0', '1.1.1.0', '1.1.1.0', 0, NULL), (14, 'CCSA', 'CUST', 'ENDUSR', 'End User', 10, 'Prakash', 'Salkar', 'salkarp@gmail.com', NULL, 'pakya@123', '', '', '', '', '', '1.1.2.1.0', '1.1.2.0', '1.1.1.0', 0, NULL), (15, 'CCSA', 'CUST', 'ENDUSR', 'End User', 11, 'Manda', 'Pise', 'mpise@gmail.com', NULL, 'mandy@423', '', '', '', '', '', '1.1.2.2.0', '1.1.2.0', '1.1.1.0', 0, NULL), (16, 'OKC', 'CUST', 'ENDUSR', 'End User', 1, 'Sameer', 'Thakur', 'sameer.thakur@gmail.com', NULL, '$2a$12$/LmT3t5I', '1', '01/12/2022', '', '', '', '1.1.3.0', '1.1.0', '1.1.2.0', 0, NULL), (17, 'OKC', 'CUST', 'ENDUSR', 'End User', 8, 'Namita', 'Palav', 'NamitaPalav.altpi@gmail.com', NULL, 'namita123456', '1', '01/12/2022', '', '', '', '1.1.1.1.0', '1.1.1.0', '1.1.2.0', 0, NULL), (18, 'OKC', 'CUST', 'ENDUSR', 'End User', 3, 'Siddhi', 'Rane', 'siddhirane.altpi@gmail.com', NULL, 'minal5', '1', '2023-02-20', '', '', '', '1.1.4.0', '1.1.0', '1.1.2.0', 0, NULL), (19, 'OKC', 'CUST', 'ENDUSR', 'End User', 9, 'Sarita', 'Bhoir', 'saritabhoir@gmail.com', NULL, 'sdf21', '1', '', '', '', '', '1.1.5.0', '1.1.0', '1.1.2.0', 0, NULL), (20, 'CCSA', 'CUST', 'ENDUSR', 'End User', 4, 'Ashish', 'Matre', 'ashishmatre.altpi@gmail.com', NULL, 'ajsdc', '1', '2023-03-20', '', '', '', '1.1.1.3.0', '1.1.1.0', '1.1.1.0', 0, NULL), (21, 'CCSA', 'CUST', 'ENDUSR', 'End User', 5, 'Sachin', 'Joshi', 'sachinjoshi.altpi@gmail.com', NULL, 'sachin123456', '1', '', '', '', '', '1.1.1.4.0', '1.1.1.0', '1.1.1.0', 0, NULL), (22, 'CCSA', 'CUST', 'COLLEC', 'Collection Agent', 0, 'sid', 'yadav', 'sidyadav.altpi@altpi', '1234567892', '123456', '1', NULL, NULL, NULL, NULL, '1.1.1.1.0', '1.1.1.0', NULL, 1, NULL), (23, 'ALPUAE', 'CUST', 'SALES', 'Sales Representative', 0, 'Ankit', 'Mishra', 'anikitmishra786@gmail.com', '9811223344', 'Ankit@786', '1', '16-08-2022', '', '0', '', '1.3.0', '1.0', '1.1.2.0', 2, NULL), (25, 'CCSA', 'CUST', 'ENDUSR', 'End User', 14, 'ram', 'devala', 'ram.altpi@gmail.com', NULL, '123456', '1', '27-8-2023', NULL, NULL, NULL, '1.1.1.3.0', '1.1.1.0', NULL, NULL, NULL), (26, 'CCSA', 'CUST', 'ENDUSR', 'End User', 15, 'ramadf', 'devadla', 'ram.altpi@gmail.com', NULL, '123456', '1', '27-8-2023', NULL, NULL, NULL, '1.1.1.4.0', '1.1.1.0', NULL, NULL, NULL), (27, 'CCSA', 'CUST', 'ENDUSR', 'End User', 16, 'ronak', 'huda', 'ronak.altpi@gmail.com', NULL, '123456', '1', '27-8-2023', NULL, NULL, NULL, '1.1.1.5.0', '1.1.1.0', NULL, 0, NULL), (28, 'CCSA', 'CUST', 'ENDUSR', 'End User', 17, 'sumit', 'zha', 'sumit.altpi@gmail.com', NULL, '123456', '1', '27-8-2023', NULL, NULL, NULL, '1.1.1.6.0', '1.1.1.0', NULL, 0, NULL), (29, 'CCSA', 'CUST', 'ENDUSR', 'End User', 20, 'Vani', 'Kapoor', 'vani.altpi@gmail.com', NULL, '123456', '1', '27-8-2023', NULL, NULL, NULL, '1.1.3.3.0', '1.1.3.0', '1.1.1.0', 0, NULL), (30, 'CCSA', 'CUST', 'ENDUSR', 'End User', 21, 'Tina', 'Verma', 'tina.altpi@gmail.com', NULL, '123456', '1', '27-8-2023', NULL, NULL, NULL, '1.1.3.1.0', '1.1.3.0', '1.1.1.0', 0, NULL);

-- -------------------------------------------------------- Done ----------------------------------

-- -- Table structure for table user_type_master

CREATE TABLE IF NOT EXISTS user_type_master ( id int(11) NOT NULL AUTO_INCREMENT, user_type varchar(6) NOT NULL, description varchar(45) NOT NULL, mandatory varchar(1) NOT NULL, createdAt datetime NOT NULL, updatedAt datetime NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

-- -- Dumping data for table user_type_master

INSERT INTO user_type_master (id, user_type, description, mandatory, createdAt, updatedAt) VALUES (1, 'PADMIN', 'Admin of Principal(Owner)', 'T', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (2, 'ADMIN', 'Admin of any other party type (CUST, PBNK, et', 'T', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (3, 'ENDUSR', 'ENDUSER OF THE APP', 'T', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (4, 'SALES', 'All related to Sales', 'T', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (5, 'FINANC', 'All related to Finance', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (6, 'COLLEC', 'Collection ', 'T', '0000-00-00 00:00:00', '0000-00-00 00:00:00');

DevAltpiin commented 4 months ago

Hey @Ayanshaikh-altpi please check this data - compare with existing model and modify it accordingly and at data in this table CREATE TABLE IF NOT EXISTS biller ( biller_id int(11) NOT NULL AUTO_INCREMENT, country_id int(11) DEFAULT NULL, biller_code varchar(6) NOT NULL, biller_status varchar(1) DEFAULT NULL, biller_name varchar(100) DEFAULT NULL, biller_category varchar(6) NOT NULL, upi_trailer varchar(100) DEFAULT NULL, npci_id_1 varchar(30) DEFAULT NULL, npci_id_2 varchar(30) DEFAULT NULL, txn_auth_yn varchar(1) DEFAULT NULL, payment_method_01 varchar(15) DEFAULT NULL, payment_method_02 varchar(15) DEFAULT NULL, payment_method_03 varchar(15) DEFAULT NULL, payment_method_04 varchar(15) DEFAULT NULL, source_of_bill_code varchar(6) NOT NULL, bill_freq_id int(6) NOT NULL, agent_id int(6) NOT NULL, logo_image longblob, logoimage_indicator varchar(1) DEFAULT NULL, theme varchar(15) DEFAULT NULL, background_image longblob, backgroundimage_indicator varchar(1) DEFAULT NULL, createdAt datetime NOT NULL, updatedAt datetime NOT NULL, PRIMARY KEY (biller_id), UNIQUE KEY Party_Code (biller_code) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='This is the Biller Information' AUTO_INCREMENT=139 ;

-- -- Dumping data for table biller

INSERT INTO biller (biller_id, country_id, biller_code, biller_status, biller_name, biller_category, upi_trailer, npci_id_1, npci_id_2, txn_auth_yn, payment_method_01, payment_method_02, payment_method_03, payment_method_04, source_of_bill_code, bill_freq_id, agent_id, logo_image, logoimage_indicator, theme, background_image, backgroundimage_indicator, createdAt, updatedAt) VALUES (1, 4, 'UOBCR', NULL, 'UOB Credit Card', 'CRTCRD', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'XLSX', 2, 0, NULL, NULL, NULL, NULL, NULL, '0000-00-00 00:00:00', '0000-00-00 00:00:00');

CREATE TABLE IF NOT EXISTS biller_bill ( biller_bill_id int(6) NOT NULL AUTO_INCREMENT COMMENT 'Autoincrement field', biller_id int(6) NOT NULL COMMENT 'this is the same_id picked from biller table', biller_code varchar(6) NOT NULL COMMENT 'biller code picked up from iler table', biller_customer_account_no varchar(20) NOT NULL, biller_bill_no varchar(20) NOT NULL, biller_customer_name varchar(50) NOT NULL, biller_bill_date date NOT NULL, biller_bill_amount decimal(12,2) NOT NULL, biller_other_charges decimal(12,2) NOT NULL, biller_taxes decimal(12,2) NOT NULL, biller_pending_due decimal(12,2) NOT NULL, biller_total_amount_due decimal(12,2) NOT NULL, last_meter_reading decimal(14,2) NOT NULL, current_meter_reading decimal(14,2) NOT NULL, units_consumed decimal(14,2) NOT NULL, reading_date date NOT NULL, due_date date NOT NULL COMMENT 'Bill Due Date', paid_indicator varchar(1) NOT NULL, paid_amount decimal(12,2) NOT NULL, paid_date date NOT NULL, PRIMARY KEY (biller_bill_id) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS biller_category_master ( id int(11) NOT NULL AUTO_INCREMENT, customer_type varchar(6) NOT NULL, description varchar(45) NOT NULL, notes mediumblob NOT NULL, createdAt datetime NOT NULL, updatedAt datetime NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Biller Category Table , telephone, gas, etc' AUTO_INCREMENT=3 ;

-- -- Dumping data for table biller_category_master

INSERT INTO biller_category_master (id, customer_type, description, notes, createdAt, updatedAt) VALUES (1, 'TELCOM', 'Telephone Service Provider', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00'), (2, 'CRTCRD', 'Credit Card', '', '0000-00-00 00:00:00', '0000-00-00 00:00:00');

-- Table structure for table biller_contact

CREATE TABLE IF NOT EXISTS biller_contact ( biller_contact_id int(8) NOT NULL AUTO_INCREMENT, biller_id int(6) DEFAULT NULL, address_1 varchar(100) DEFAULT NULL, address_2 varchar(100) DEFAULT NULL, city varchar(50) DEFAULT NULL, state int(11) DEFAULT NULL, pin varchar(10) DEFAULT NULL, country varchar(50) DEFAULT NULL, contact_name_1 varchar(100) DEFAULT NULL, mobile_no_1 varchar(15) DEFAULT NULL, email_1 varchar(30) DEFAULT NULL, contact_name_2 varchar(100) DEFAULT NULL, mobile_no_2 varchar(15) DEFAULT NULL, email_2 varchar(30) DEFAULT NULL, contact_Name_3 varchar(100) DEFAULT NULL, mobile_no_3 varchar(15) DEFAULT NULL, email_3 varchar(30) DEFAULT NULL, PRIMARY KEY (biller_contact_id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

-- -- Dumping data for table biller_contact

INSERT INTO biller_contact (biller_contact_id, biller_id, address_1, address_2, city, state, pin, country, contact_name_1, mobile_no_1, email_1, contact_name_2, mobile_no_2, email_2, contact_Name_3, mobile_no_3, email_3) VALUES (1, 1, 'United Overseas Bank (Malaysia), Bhd (271809K) Menara UOB,', 'Jalan Raja Laut', 'Kuala Lumpur', NULL, '50350', 'Malaysia', 'Masruddin Sadat', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

--

CREATE TABLE IF NOT EXISTS bill_frequency ( bill_freq_id int(2) NOT NULL AUTO_INCREMENT, frequency_code varchar(6) NOT NULL, frequency_description varchar(20) NOT NULL, PRIMARY KEY (bill_freq_id) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

-- -- Dumping data for table bill_frequency

INSERT INTO bill_frequency (bill_freq_id, frequency_code, frequency_description) VALUES (1, 'DAILY', 'DAILY'), (2, 'MONTH', 'MONTHLY'), (3, 'QRTR', 'QUARTERLY'), (4, 'HLFYR', 'HALF YEARLY'), (5, 'YRLY', 'YEARLY');

Ayanshaikh-altpi commented 4 months ago

malaysia(database).zip