-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `praxisdblivitpay_bo`
--

-- --------------------------------------------------------

--
-- Table structure for table `Declined_31120`
--

CREATE TABLE `Declined_31120` (
  `id` int NOT NULL DEFAULT '1',
  `ipn_no` varchar(50) NOT NULL,
  `client_transaction_id` varchar(200) NOT NULL,
  `order_id` varchar(100) NOT NULL,
  `companyID` varchar(255) NOT NULL,
  `customer_name` varchar(255) NOT NULL,
  `customer_email` varchar(255) NOT NULL,
  `customer_address` varchar(255) NOT NULL,
  `customer_city` varchar(255) NOT NULL,
  `customer_state` varchar(255) NOT NULL,
  `customer_country` varchar(255) NOT NULL,
  `customer_zip` varchar(255) NOT NULL,
  `customer_phone` varchar(255) NOT NULL,
  `item_name` varchar(100) NOT NULL,
  `item_number` varchar(50) NOT NULL,
  `item_price` float NOT NULL,
  `item_price_currency` varchar(20) NOT NULL,
  `grossPrice` float NOT NULL,
  `currency_type` varchar(20) NOT NULL,
  `card_no` varchar(20) NOT NULL,
  `cvv` varchar(10) NOT NULL,
  `card_expiry` varchar(10) NOT NULL,
  `gatewayTransactionId` varchar(255) DEFAULT NULL,
  `ip` varchar(50) NOT NULL,
  `txn_id` varchar(100) NOT NULL,
  `pgtxn_id` varchar(100) NOT NULL,
  `g_type` varchar(100) NOT NULL,
  `auth_code` varchar(100) NOT NULL,
  `avsresponse` varchar(100) NOT NULL,
  `cvvresponse` varchar(100) NOT NULL,
  `response` varchar(100) NOT NULL,
  `response_code` varchar(100) NOT NULL,
  `status` varchar(50) NOT NULL,
  `rec_crt_date` datetime NOT NULL,
  `rec_up_date` datetime NOT NULL,
  `refund_amount` float NOT NULL,
  `refund` enum('Y','N') NOT NULL DEFAULT 'N',
  `refund_date` datetime NOT NULL,
  `chargeback` enum('Y','N') NOT NULL DEFAULT 'N',
  `chagreback_date` datetime NOT NULL,
  `callback_url` varchar(255) NOT NULL,
  `success_url` varchar(255) NOT NULL,
  `fail_url` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `gateway_login`
--

CREATE TABLE `gateway_login` (
  `id` int NOT NULL,
  `userID` varchar(255) NOT NULL,
  `userPass` varchar(255) NOT NULL,
  `userEmail` varchar(50) NOT NULL,
  `gatewayName` varchar(45) NOT NULL,
  `gusername` varchar(30) NOT NULL,
  `gpassword` varchar(30) NOT NULL,
  `gurl` varchar(255) NOT NULL,
  `email` varchar(50) NOT NULL,
  `epassword` varchar(30) NOT NULL,
  `elink` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `organiztion_incident_type`
--

CREATE TABLE `organiztion_incident_type` (
  `id` int NOT NULL,
  `organization_id` int NOT NULL,
  `incident_type_id` int NOT NULL,
  `incient_organization_email` varchar(255) NOT NULL,
  `status` enum('Y','N') NOT NULL,
  `rec_crt_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `process_31120`
--

CREATE TABLE `process_31120` (
  `id` int NOT NULL DEFAULT '0',
  `ipn_no` varchar(50) NOT NULL,
  `client_transaction_id` varchar(200) NOT NULL,
  `order_id` varchar(100) NOT NULL,
  `companyID` varchar(255) NOT NULL,
  `customer_name` varchar(255) NOT NULL,
  `customer_email` varchar(255) NOT NULL,
  `customer_address` varchar(255) NOT NULL,
  `customer_city` varchar(255) NOT NULL,
  `customer_state` varchar(255) NOT NULL,
  `customer_country` varchar(255) NOT NULL,
  `customer_zip` varchar(255) NOT NULL,
  `customer_phone` varchar(255) NOT NULL,
  `item_name` varchar(100) NOT NULL,
  `item_number` varchar(50) NOT NULL,
  `item_price` float NOT NULL,
  `item_price_currency` varchar(20) NOT NULL,
  `grossPrice` float NOT NULL,
  `currency_type` varchar(20) NOT NULL,
  `card_no` varchar(20) NOT NULL,
  `cvv` varchar(10) NOT NULL,
  `card_expiry` varchar(10) NOT NULL,
  `gatewayTransactionId` varchar(255) DEFAULT NULL,
  `ip` varchar(50) NOT NULL,
  `txn_id` varchar(100) NOT NULL,
  `pgtxn_id` varchar(100) NOT NULL,
  `g_type` varchar(100) NOT NULL,
  `auth_code` varchar(100) NOT NULL,
  `avsresponse` varchar(100) NOT NULL,
  `cvvresponse` varchar(100) NOT NULL,
  `response` varchar(100) NOT NULL,
  `response_code` varchar(100) NOT NULL,
  `status` varchar(50) NOT NULL,
  `rec_crt_date` datetime NOT NULL,
  `rec_up_date` datetime NOT NULL,
  `refund_amount` float NOT NULL,
  `refund` enum('Y','N') NOT NULL DEFAULT 'N',
  `refund_date` datetime NOT NULL,
  `chargeback` enum('Y','N') NOT NULL DEFAULT 'N',
  `chagreback_date` datetime NOT NULL,
  `callback_url` varchar(255) NOT NULL,
  `success_url` varchar(255) NOT NULL,
  `fail_url` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `response_log`
--

CREATE TABLE `response_log` (
  `id` int NOT NULL,
  `transaction_id` varchar(255) NOT NULL,
  `response` longtext CHARACTER SET latin1 COLLATE latin1_swedish_ci,
  `json_callback` longtext,
  `json_txn` longtext,
  `rec_crt_date` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `response_log`
--

INSERT INTO `response_log` (`id`, `transaction_id`, `response`, `json_callback`, `json_txn`, `rec_crt_date`) VALUES
(1, 'TR46090', '<!DOCTYPE html>\n<html lang=en>\n  <meta charset=utf-8>\n  <meta name=viewport content=\"initial-scale=1, minimum-scale=1, width=device-width\">\n  <title>Error 405 (Method Not Allowed)!!1</title>\n  <style>\n    *{margin:0;padding:0}html,code{font:15px/22px arial,sans-serif}html{background:#fff;color:#222;padding:15px}body{margin:7% auto 0;max-width:390px;min-height:180px;padding:30px 0 15px}* > body{background:url(//www.google.com/images/errors/robot.png) 100% 5px no-repeat;padding-right:205px}p{margin:11px 0 22px;overflow:hidden}ins{color:#777;text-decoration:none}a img{border:0}@media screen and (max-width:772px){body{background:none;margin-top:0;max-width:none;padding-right:0}}#logo{background:url(//www.google.com/images/branding/googlelogo/1x/googlelogo_color_150x54dp.png) no-repeat;margin-left:-5px}@media only screen and (min-resolution:192dpi){#logo{background:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) no-repeat 0% 0%/100% 100%;-moz-border-image:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) 0}}@media only screen and (-webkit-min-device-pixel-ratio:2){#logo{background:url(//www.google.com/images/branding/googlelogo/2x/googlelogo_color_150x54dp.png) no-repeat;-webkit-background-size:100% 100%}}#logo{display:inline-block;height:54px;width:150px}\n  </style>\n  <a href=//www.google.com/><span id=logo aria-label=Google></span></a>\n  <p><b>405.</b> <ins>That’s an error.</ins>\n  <p>The request method <code>POST</code> is inappropriate for the URL <code>/</code>.  <ins>That’s all we know.</ins>\n', NULL, NULL, '2023-11-27 15:11:07'),
(2, '1234552323', 'true', NULL, NULL, '2023-12-28 11:36:03'),
(3, '15456784', 'true', NULL, NULL, '2023-12-28 11:56:55'),
(4, '1585535137', 'true', NULL, NULL, '2023-12-29 09:15:58'),
(5, '1585535158', 'true', NULL, NULL, '2024-01-02 07:16:50'),
(6, '1585535159', 'true', NULL, NULL, '2024-01-02 07:24:05'),
(7, '21121232323', 'true', NULL, NULL, '2024-01-02 07:44:12'),
(8, '2114448989', 'true', NULL, NULL, '2024-01-02 07:59:46'),
(9, '1585535171', 'true', NULL, NULL, '2024-01-02 09:00:25'),
(10, '1000-1923729', 'true', NULL, NULL, '2024-01-15 08:11:08'),
(11, '1000-1923750', 'true', NULL, NULL, '2024-01-15 08:25:24'),
(12, '1000-1923753', 'true', NULL, NULL, '2024-01-15 08:32:06'),
(13, '1000-1923893', 'true', NULL, NULL, '2024-01-15 09:56:38'),
(14, '1000-1923918', 'true', NULL, NULL, '2024-01-15 10:05:50'),
(15, '1000-1924398', 'true', NULL, NULL, '2024-01-15 14:54:00'),
(16, '1000-1120166546', 'true', NULL, NULL, '2024-01-24 13:24:29'),
(17, '1000-1120167252', 'true', NULL, NULL, '2024-01-24 13:29:35'),
(18, '1000-1120353380', 'true', NULL, NULL, '2024-01-25 13:42:09'),
(19, '1000-1120353822', 'true', NULL, NULL, '2024-01-25 13:45:43'),
(20, '1000-1120354603', 'true', NULL, NULL, '2024-01-25 13:50:15'),
(21, '1000-1120354919', 'true', NULL, NULL, '2024-01-25 13:52:39'),
(22, '1000-1961001', 'true', NULL, NULL, '2024-02-20 09:17:00'),
(23, '1000-1961307', 'true', NULL, NULL, '2024-02-20 11:29:42'),
(24, '1000-1961336', 'true', NULL, NULL, '2024-02-20 11:37:42'),
(25, '1961358', 'true', NULL, NULL, '2024-02-20 11:43:51'),
(26, '1125117531', 'true', NULL, NULL, '2024-02-20 13:08:36'),
(27, '1125273488', 'true', NULL, NULL, '2024-02-21 08:27:02'),
(28, '1125273398', 'true', NULL, NULL, '2024-02-21 08:27:09'),
(29, '1125274074', 'true', NULL, NULL, '2024-02-21 08:31:21'),
(30, '1962442', 'true', NULL, NULL, '2024-02-21 09:41:42'),
(31, '1125655097', 'true', NULL, NULL, '2024-02-23 09:14:27'),
(32, '1125655519', 'true', NULL, NULL, '2024-02-23 09:18:25'),
(33, '1125728890', 'true', NULL, NULL, '2024-02-23 17:46:04'),
(34, '1125728957', 'true', NULL, NULL, '2024-02-23 17:47:26');

-- --------------------------------------------------------

--
-- Table structure for table `t_admin_back`
--

CREATE TABLE `t_admin_back` (
  `id` int NOT NULL,
  `username` varchar(25) NOT NULL,
  `email` varchar(100) DEFAULT NULL,
  `passwd` varchar(255) DEFAULT NULL,
  `mobile` varchar(25) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `country` tinyint DEFAULT NULL,
  `zip` varchar(20) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `secondaryPhone` varchar(50) DEFAULT NULL,
  `aliasName` varchar(50) DEFAULT NULL,
  `image` varchar(100) DEFAULT NULL,
  `status` enum('Y','N') DEFAULT 'Y',
  `tech_support` enum('Y','N') NOT NULL DEFAULT 'Y',
  `type` enum('teamlead','superadmin','quality','tech','sales','techsupport','chargebacks','shipping','group') DEFAULT 'sales',
  `cancelOrCapture` enum('Y','N') NOT NULL DEFAULT 'Y',
  `groupID` int NOT NULL,
  `companyID` varchar(50) NOT NULL,
  `nomineeID` varchar(50) NOT NULL,
  `commission` float NOT NULL,
  `adminPermission` enum('system','group','company','nominee') NOT NULL DEFAULT 'system',
  `rec_crt_date` datetime DEFAULT NULL,
  `rec_up_date` datetime DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `ip_address` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `t_auth_token`
--

CREATE TABLE `t_auth_token` (
  `id` int NOT NULL,
  `user_id` int DEFAULT NULL,
  `ipn` text,
  `user_token` text,
  `generated_token` text,
  `expire_time` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Table structure for table `t_blocked_info`
--

CREATE TABLE `t_blocked_info` (
  `id` int NOT NULL,
  `customer_phone` text,
  `customer_email` text,
  `rec_crt_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;



-- --------------------------------------------------------

--
-- Table structure for table `t_country`
--

CREATE TABLE `t_country` (
  `id` int NOT NULL,
  `order_id` int NOT NULL,
  `iso` varchar(225) NOT NULL,
  `country_nm` varchar(225) NOT NULL,
  `printable_name` varchar(225) NOT NULL,
  `printable_name_sp` varchar(225) NOT NULL,
  `iso3` varchar(225) NOT NULL,
  `numcode` varchar(225) NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `t_country`
--

INSERT INTO `t_country` (`id`, `order_id`, `iso`, `country_nm`, `printable_name`, `printable_name_sp`, `iso3`, `numcode`, `status`) VALUES
(1, 2, 'AF', 'AFGHANISTAN', 'Afghanistan', 'Afganistán', 'AFG', '4', 'N'),
(2, 3, 'AL', 'ALBANIA', 'Albania', 'Albania', 'ALB', '8', 'N'),
(3, 6, 'DZ', 'ALGERIA', 'Algeria', 'Algeria', 'DZA', '12', 'N'),
(4, 5, 'AS', 'AMERICAN SAMOA', 'American Samoa', 'Samoa Americana', 'ASM', '16', 'N'),
(5, 4, 'AD', 'ANDORRA', 'Andorra', 'Andorra', 'AND', '20', 'N'),
(6, 7, 'AO', 'ANGOLA', 'Angola', 'Angola', 'AGO', '24', 'N'),
(7, 8, 'AI', 'ANGUILLA', 'Anguilla', 'Anguila', 'AIA', '660', 'N'),
(8, 9, 'AQ', 'ANTARCTICA', 'Antarctica', 'Antártida', 'ATA', '', 'N'),
(9, 10, 'AG', 'ANTIGUA AND BARBUDA', 'Antigua and Barbuda', 'Antigua y Barbuda', 'ATG', '28', 'N'),
(10, 11, 'AR', 'ARGENTINA', 'Argentina', 'Argentina', 'ARG', '32', 'N'),
(11, 12, 'AM', 'ARMENIA', 'Armenia', 'Armenia', 'ARM', '51', 'N'),
(12, 13, 'AW', 'ARUBA', 'Aruba', 'Aruba', 'ABW', '533', 'N'),
(13, 14, 'AU', 'AUSTRALIA', 'Australia', 'Australia', 'AUS', '36', 'Y'),
(14, 15, 'AT', 'AUSTRIA', 'Austria', 'Austria', 'AUT', '40', 'N'),
(15, 16, 'AZ', 'AZERBAIJAN', 'Azerbaijan', 'Azerbaiyán', 'AZE', '31', 'N'),
(16, 17, 'BS', 'BAHAMAS', 'Bahamas', 'Bahamas', 'BHS', '44', 'N'),
(17, 18, 'BH', 'BAHRAIN', 'Bahrain', 'Bahréin', 'BHR', '48', 'N'),
(18, 19, 'BD', 'BANGLADESH', 'Bangladesh', 'Bangladesh', 'BGD', '50', 'N'),
(19, 20, 'BB', 'BARBADOS', 'Barbados', 'Barbados', 'BRB', '52', 'N'),
(20, 21, 'BY', 'BELARUS', 'Belarus', 'Bielorrusia', 'BLR', '112', 'N'),
(21, 22, 'BE', 'BELGIUM', 'Belgium', 'Bélgica', 'BEL', '56', 'N'),
(22, 23, 'BZ', 'BELIZE', 'Belize', 'Belice', 'BLZ', '84', 'N'),
(23, 24, 'BJ', 'BENIN', 'Benin', 'Benín', 'BEN', '204', 'N'),
(24, 25, 'BM', 'BERMUDA', 'Bermuda', 'Bermuda', 'BMU', '60', 'N'),
(25, 26, 'BT', 'BHUTAN', 'Bhutan', 'Bután', 'BTN', '64', 'N'),
(26, 27, 'BO', 'BOLIVIA', 'Bolivia', 'Bolivia', 'BOL', '68', 'N'),
(27, 28, 'BA', 'BOSNIA AND HERZEGOVINA', 'Bosnia and Herzegovina', 'Bosnia y Herzegovina', 'BIH', '70', 'N'),
(28, 29, 'BW', 'BOTSWANA', 'Botswana', 'Botsuana', 'BWA', '72', 'N'),
(29, 30, 'BV', 'BOUVET ISLAND', 'Bouvet Island', 'Isla Bouvet', '', '', 'N'),
(30, 31, 'BR', 'BRAZIL', 'Brazil', 'Brasil', 'BRA', '76', 'N'),
(31, 32, 'IO', 'BRITISH INDIAN OCEAN TERRITORY', 'British Indian Ocean Territory', 'Territorio Británico del Océano Índico', '', '', 'N'),
(32, 33, 'BN', 'BRUNEI DARUSSALAM', 'Brunei Darussalam', 'Brunei Darussalam', 'BRN', '96', 'N'),
(33, 34, 'BG', 'BULGARIA', 'Bulgaria', 'Bulgaria', 'BGR', '100', 'N'),
(34, 35, 'BF', 'BURKINA FASO', 'Burkina Faso', 'Burkina Faso', 'BFA', '854', 'N'),
(35, 36, 'BI', 'BURUNDI', 'Burundi', 'Burundi', 'BDI', '108', 'N'),
(36, 37, 'KH', 'CAMBODIA', 'Cambodia', 'Camboya', 'KHM', '116', 'N'),
(37, 38, 'CM', 'CAMEROON', 'Cameroon', 'Camerún', 'CMR', '120', 'N'),
(38, 39, 'CA', 'CANADA', 'Canada', 'Canadá', 'CAN', '124', 'Y'),
(39, 40, 'CV', 'CAPE VERDE', 'Cape Verde', 'Cabo Verde', 'CPV', '132', 'N'),
(40, 41, 'KY', 'CAYMAN ISLANDS', 'Cayman Islands', 'Islas Caimán', 'CYM', '136', 'N'),
(41, 42, 'CF', 'CENTRAL AFRICAN REPUBLIC', 'Central African Republic', 'República Centroafricana', 'CAF', '140', 'N'),
(42, 43, 'TD', 'CHAD', 'Chad', 'Chad', 'TCD', '148', 'N'),
(43, 44, 'CL', 'CHILE', 'Chile', 'Chile', 'CHL', '152', 'N'),
(44, 45, 'CN', 'CHINA', 'China', 'China', 'CHN', '156', 'N'),
(45, 46, 'CX', 'CHRISTMAS ISLAND', 'Christmas Island', 'Christmas Island', '', '', 'N'),
(46, 47, 'CC', 'COCOS (KEELING) ISLANDS', 'Cocos (Keeling) Islands', 'Islas Cocos (Keeling)', '', '', 'N'),
(47, 48, 'CO', 'COLOMBIA', 'Colombia', 'Colombia', 'COL', '170', 'N'),
(48, 49, 'KM', 'COMOROS', 'Comoros', 'Comoras', 'COM', '174', 'N'),
(49, 50, 'CG', 'CONGO', 'Congo', 'Congo', 'COG', '178', 'N'),
(50, 51, 'CD', 'CONGO, THE DEMOCRATIC REPUBLIC OF THE', 'Congo, the Democratic Republic of the', 'Congo, la República Democrática del', 'COD', '180', 'N'),
(51, 52, 'CK', 'COOK ISLANDS', 'Cook Islands', 'Islas Cook', 'COK', '184', 'N'),
(52, 53, 'CR', 'COSTA RICA', 'Costa Rica', 'Costa Rica', 'CRI', '188', 'N'),
(53, 54, 'CI', 'COTE D\'IVOIRE', 'Cote D\'Ivoire', 'Cote d\'Ivoire', 'CIV', '384', 'N'),
(54, 55, 'HR', 'CROATIA', 'Croatia', 'Croacia', 'HRV', '191', 'N'),
(55, 56, 'CU', 'CUBA', 'Cuba', 'Cuba', 'CUB', '192', 'N'),
(56, 57, 'CY', 'CYPRUS', 'Cyprus', 'Chipre', 'CYP', '196', 'N'),
(57, 58, 'CZ', 'CZECH REPUBLIC', 'Czech Republic', 'República Checa', 'CZE', '203', 'N'),
(58, 59, 'DK', 'DENMARK', 'Denmark', 'Dinamarca', 'DNK', '208', 'N'),
(59, 60, 'DJ', 'DJIBOUTI', 'Djibouti', 'Yibuti', 'DJI', '262', 'N'),
(60, 61, 'DM', 'DOMINICA', 'Dominica', 'Dominica', 'DMA', '212', 'N'),
(61, 62, 'DO', 'DOMINICAN REPUBLIC', 'Dominican Republic', 'República Dominicana', 'DOM', '214', 'N'),
(62, 63, 'EC', 'ECUADOR', 'Ecuador', 'Ecuador', 'ECU', '218', 'N'),
(63, 64, 'EG', 'EGYPT', 'Egypt', 'Egipto', 'EGY', '818', 'N'),
(64, 65, 'SV', 'EL SALVADOR', 'El Salvador', 'El Salvador', 'SLV', '222', 'N'),
(65, 66, 'GQ', 'EQUATORIAL GUINEA', 'Equatorial Guinea', 'Guinea Ecuatorial', 'GNQ', '226', 'N'),
(66, 67, 'ER', 'ERITREA', 'Eritrea', 'Eritrea', 'ERI', '232', 'N'),
(67, 68, 'EE', 'ESTONIA', 'Estonia', 'Estonia', 'EST', '233', 'N'),
(68, 69, 'ET', 'ETHIOPIA', 'Ethiopia', 'Etiopía', 'ETH', '231', 'N'),
(69, 70, 'FK', 'FALKLAND ISLANDS (MALVINAS)', 'Falkland Islands (Malvinas)', 'Islas Malvinas (Falkland)', 'FLK', '238', 'N'),
(70, 71, 'FO', 'FAROE ISLANDS', 'Faroe Islands', 'Islas Feroe', 'FRO', '234', 'N'),
(71, 72, 'FJ', 'FIJI', 'Fiji', 'Fiyi', 'FJI', '242', 'N'),
(72, 73, 'FI', 'FINLAND', 'Finland', 'Finlandia', 'FIN', '246', 'N'),
(73, 74, 'FR', 'FRANCE', 'France', 'Francia', 'FRA', '250', 'N'),
(74, 75, 'GF', 'FRENCH GUIANA', 'French Guiana', 'Francés Guayana', 'GUF', '254', 'N'),
(75, 76, 'PF', 'FRENCH POLYNESIA', 'French Polynesia', 'Polinesia francés', 'PYF', '258', 'N'),
(76, 77, 'TF', 'FRENCH SOUTHERN TERRITORIES', 'French Southern Territories', 'Territorios del sur francés', '', '', 'N'),
(77, 78, 'GA', 'GABON', 'Gabon', 'Gabón', 'GAB', '266', 'N'),
(78, 79, 'GM', 'GAMBIA', 'Gambia', 'Gambia', 'GMB', '270', 'N'),
(79, 80, 'GE', 'GEORGIA', 'Georgia', 'Georgia', 'GEO', '268', 'N'),
(80, 81, 'DE', 'GERMANY', 'Germany', 'Alemania', 'DEU', '276', 'N'),
(81, 82, 'GH', 'GHANA', 'Ghana', 'Ghana', 'GHA', '288', 'N'),
(82, 83, 'GI', 'GIBRALTAR', 'Gibraltar', 'Gibraltar', 'GIB', '292', 'N'),
(83, 84, 'GR', 'GREECE', 'Greece', 'Grecia', 'GRC', '300', 'N'),
(84, 85, 'GL', 'GREENLAND', 'Greenland', 'Groenlandia', 'GRL', '304', 'N'),
(85, 86, 'GD', 'GRENADA', 'Grenada', 'Granada', 'GRD', '308', 'N'),
(86, 87, 'GP', 'GUADELOUPE', 'Guadeloupe', 'Guadalupe', 'GLP', '312', 'N'),
(87, 88, 'GU', 'GUAM', 'Guam', 'Guam', 'GUM', '316', 'N'),
(88, 89, 'GT', 'GUATEMALA', 'Guatemala', 'Guatemala', 'GTM', '320', 'N'),
(89, 90, 'GN', 'GUINEA', 'Guinea', 'Guinea', 'GIN', '324', 'N'),
(90, 91, 'GW', 'GUINEA-BISSAU', 'Guinea-Bissau', 'Guinea-Bissau', 'GNB', '624', 'N'),
(91, 92, 'GY', 'GUYANA', 'Guyana', 'Guyana', 'GUY', '328', 'N'),
(92, 93, 'HT', 'HAITI', 'Haiti', 'Haití', 'HTI', '332', 'N'),
(93, 94, 'HM', 'HEARD ISLAND AND MCDONALD ISLANDS', 'Heard Island and Mcdonald Islands', 'Islas Heard y McDonald', '', '', 'N'),
(94, 95, 'VA', 'HOLY SEE (VATICAN CITY STATE)', 'Holy See (Vatican City State)', 'Santa Sede (Ciudad del Vaticano)', 'VAT', '336', 'N'),
(95, 96, 'HN', 'HONDURAS', 'Honduras', 'Honduras', 'HND', '340', 'N'),
(96, 97, 'HK', 'HONG KONG', 'Hong Kong', 'Hong Kong', 'HKG', '344', 'N'),
(97, 98, 'HU', 'HUNGARY', 'Hungary', 'Hungría', 'HUN', '348', 'N'),
(98, 99, 'IS', 'ICELAND', 'Iceland', 'Islandia', 'ISL', '352', 'N'),
(99, 100, 'IN', 'INDIA', 'India', 'India', 'IND', '356', 'N'),
(100, 101, 'ID', 'INDONESIA', 'Indonesia', 'Indonesia', 'IDN', '360', 'N'),
(101, 102, 'IR', 'IRAN, ISLAMIC REPUBLIC OF', 'Iran, Islamic Republic of', 'Irán, República Islámica del', 'IRN', '364', 'N'),
(102, 103, 'IQ', 'IRAQ', 'Iraq', 'Iraq', 'IRQ', '368', 'N'),
(103, 104, 'IE', 'IRELAND', 'Ireland', 'Irlanda', 'IRL', '372', 'N'),
(104, 105, 'IL', 'ISRAEL', 'Israel', 'Israel', 'ISR', '376', 'N'),
(105, 106, 'IT', 'ITALY', 'Italy', 'Italia', 'ITA', '380', 'N'),
(106, 107, 'JM', 'JAMAICA', 'Jamaica', 'Jamaica', 'JAM', '388', 'N'),
(107, 108, 'JP', 'JAPAN', 'Japan', 'Japón', 'JPN', '392', 'N'),
(108, 109, 'JO', 'JORDAN', 'Jordan', 'Jordania', 'JOR', '400', 'N'),
(109, 110, 'KZ', 'KAZAKHSTAN', 'Kazakhstan', 'Kazajstán', 'KAZ', '398', 'N'),
(110, 111, 'KE', 'KENYA', 'Kenya', 'Kenia', 'KEN', '404', 'N'),
(111, 112, 'KI', 'KIRIBATI', 'Kiribati', 'Kiribati', 'KIR', '296', 'N'),
(112, 113, 'KP', 'KOREA, DEMOCRATIC PEOPLE\'S REPUBLIC OF', 'Korea, Democratic People\'s Republic of', 'Corea, República Democrática del People\'s Republic de', 'PRK', '408', 'N'),
(113, 114, 'KR', 'KOREA, REPUBLIC OF', 'Korea, Republic of', 'Corea, República de', 'KOR', '410', 'N'),
(114, 115, 'KW', 'KUWAIT', 'Kuwait', 'Kuwait', 'KWT', '414', 'N'),
(115, 116, 'KG', 'KYRGYZSTAN', 'Kyrgyzstan', 'Kirguistán', 'KGZ', '417', 'N'),
(116, 117, 'LA', 'LAO PEOPLE\'S DEMOCRATIC REPUBLIC', 'Lao People\'s Democratic Republic', 'República Democrática Popular Lao', 'LAO', '418', 'N'),
(117, 118, 'LV', 'LATVIA', 'Latvia', 'Letonia', 'LVA', '428', 'N'),
(118, 119, 'LB', 'LEBANON', 'Lebanon', 'Líbano', 'LBN', '422', 'N'),
(119, 120, 'LS', 'LESOTHO', 'Lesotho', 'Lesotho', 'LSO', '426', 'N'),
(120, 121, 'LR', 'LIBERIA', 'Liberia', 'Liberia', 'LBR', '430', 'N'),
(121, 122, 'LY', 'LIBYAN ARAB JAMAHIRIYA', 'Libyan Arab Jamahiriya', 'Jamahiriya Árabe Libia', 'LBY', '434', 'N'),
(122, 123, 'LI', 'LIECHTENSTEIN', 'Liechtenstein', 'Liechtenstein', 'LIE', '438', 'N'),
(123, 124, 'LT', 'LITHUANIA', 'Lithuania', 'Lituania', 'LTU', '440', 'N'),
(124, 125, 'LU', 'LUXEMBOURG', 'Luxembourg', 'Luxemburgo', 'LUX', '442', 'N'),
(125, 126, 'MO', 'MACAO', 'Macao', 'Macao', 'MAC', '446', 'N'),
(126, 127, 'MK', 'MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF', 'Macedonia, the Former Yugoslav Republic of', 'Macedonia, la ex República Yugoslava de', 'MKD', '807', 'N'),
(127, 128, 'MG', 'MADAGASCAR', 'Madagascar', 'Madagascar', 'MDG', '450', 'N'),
(128, 129, 'MW', 'MALAWI', 'Malawi', 'Malawi', 'MWI', '454', 'N'),
(129, 130, 'MY', 'MALAYSIA', 'Malaysia', 'Malasia', 'MYS', '458', 'N'),
(130, 131, 'MV', 'MALDIVES', 'Maldives', 'Maldivas', 'MDV', '462', 'N'),
(131, 132, 'ML', 'MALI', 'Mali', 'Mali', 'MLI', '466', 'N'),
(132, 133, 'MT', 'MALTA', 'Malta', 'Malta', 'MLT', '470', 'N'),
(133, 134, 'MH', 'MARSHALL ISLANDS', 'Marshall Islands', 'Islas Marshall', 'MHL', '584', 'N'),
(134, 135, 'MQ', 'MARTINIQUE', 'Martinique', 'Martinica', 'MTQ', '474', 'N'),
(135, 136, 'MR', 'MAURITANIA', 'Mauritania', 'Mauritania', 'MRT', '478', 'N'),
(136, 137, 'MU', 'MAURITIUS', 'Mauritius', 'Mauricio', 'MUS', '480', 'N'),
(137, 138, 'YT', 'MAYOTTE', 'Mayotte', 'Mayotte', '', '', 'N'),
(138, 139, 'MX', 'MEXICO', 'Mexico', 'Mexico', 'MEX', '484', 'N'),
(139, 140, 'FM', 'MICRONESIA, FEDERATED STATES OF', 'Micronesia, Federated States of', 'Micronesia, Estados Federados de', 'FSM', '583', 'N'),
(140, 141, 'MD', 'MOLDOVA, REPUBLIC OF', 'Moldova, Republic of', 'Moldova, República de', 'MDA', '498', 'N'),
(141, 142, 'MC', 'MONACO', 'Monaco', 'Mónaco', 'MCO', '492', 'N'),
(142, 143, 'MN', 'MONGOLIA', 'Mongolia', 'Mongolia', 'MNG', '496', 'N'),
(143, 144, 'MS', 'MONTSERRAT', 'Montserrat', 'Montserrat', 'MSR', '500', 'N'),
(144, 145, 'MA', 'MOROCCO', 'Morocco', 'Marruecos', 'MAR', '504', 'N'),
(145, 146, 'MZ', 'MOZAMBIQUE', 'Mozambique', 'Mozambique', 'MOZ', '508', 'N'),
(146, 147, 'MM', 'MYANMAR', 'Myanmar', 'Myanmar', 'MMR', '104', 'N'),
(147, 148, 'NA', 'NAMIBIA', 'Namibia', 'Namibia', 'NAM', '516', 'N'),
(148, 149, 'NR', 'NAURU', 'Nauru', 'Nauru', 'NRU', '520', 'N'),
(149, 150, 'NP', 'NEPAL', 'Nepal', 'Nepal', 'NPL', '524', 'N'),
(150, 151, 'NL', 'NETHERLANDS', 'Netherlands', 'Países Bajos', 'NLD', '528', 'N'),
(151, 152, 'AN', 'NETHERLANDS ANTILLES', 'Netherlands Antilles', 'Antillas Neerlandesas', 'ANT', '530', 'N'),
(152, 153, 'NC', 'NEW CALEDONIA', 'New Caledonia', 'Nueva Caledonia', 'NCL', '540', 'N'),
(153, 154, 'NZ', 'NEW ZEALAND', 'New Zealand', 'Nueva Zelanda', 'NZL', '554', 'N'),
(154, 155, 'NI', 'NICARAGUA', 'Nicaragua', 'Nicaragua', 'NIC', '558', 'N'),
(155, 156, 'NE', 'NIGER', 'Niger', 'Níger', 'NER', '562', 'N'),
(156, 157, 'NG', 'NIGERIA', 'Nigeria', 'Nigeria', 'NGA', '566', 'N'),
(157, 158, 'NU', 'NIUE', 'Niue', 'Niue', 'NIU', '570', 'N'),
(158, 159, 'NF', 'NORFOLK ISLAND', 'Norfolk Island', 'Isla Norfolk', 'NFK', '574', 'N'),
(159, 160, 'MP', 'NORTHERN MARIANA ISLANDS', 'Northern Mariana Islands', 'Islas Marianas del Norte', 'MNP', '580', 'N'),
(160, 161, 'NO', 'NORWAY', 'Norway', 'Noruega', 'NOR', '578', 'N'),
(161, 162, 'OM', 'OMAN', 'Oman', 'Omán', 'OMN', '512', 'N'),
(162, 163, 'PK', 'PAKISTAN', 'Pakistan', 'Pakistán', 'PAK', '586', 'N'),
(163, 164, 'PW', 'PALAU', 'Palau', 'Palau', 'PLW', '585', 'N'),
(164, 165, 'PS', 'PALESTINIAN TERRITORY, OCCUPIED', 'Palestinian Territory, Occupied', 'Territorio palestino, ocupado', '', '', 'N'),
(165, 166, 'PA', 'PANAMA', 'Panama', 'Panamá', 'PAN', '591', 'N'),
(166, 167, 'PG', 'PAPUA NEW GUINEA', 'Papua New Guinea', 'Papua Nueva Guinea', 'PNG', '598', 'N'),
(167, 168, 'PY', 'PARAGUAY', 'Paraguay', 'Paraguay', 'PRY', '600', 'N'),
(168, 169, 'PE', 'PERU', 'Peru', 'Perú', 'PER', '604', 'N'),
(169, 170, 'PH', 'PHILIPPINES', 'Philippines', 'Filipinas', 'PHL', '608', 'N'),
(170, 171, 'PN', 'PITCAIRN', 'Pitcairn', 'Pitcairn', 'PCN', '612', 'N'),
(171, 172, 'PL', 'POLAND', 'Poland', 'Polonia', 'POL', '616', 'N'),
(172, 173, 'PT', 'PORTUGAL', 'Portugal', 'Portugal', 'PRT', '620', 'N'),
(173, 174, 'PR', 'PUERTO RICO', 'Puerto Rico', 'Puerto Rico', 'PRI', '630', 'N'),
(174, 175, 'QA', 'QATAR', 'Qatar', 'Qatar', 'QAT', '634', 'N'),
(175, 176, 'RE', 'REUNION', 'Reunion', 'Reunión', 'REU', '638', 'N'),
(176, 177, 'RO', 'ROMANIA', 'Romania', 'Rumania', 'ROM', '642', 'N'),
(177, 178, 'RU', 'RUSSIAN FEDERATION', 'Russian Federation', 'Federación de Rusia', 'RUS', '643', 'N'),
(178, 179, 'RW', 'RWANDA', 'Rwanda', 'Ruanda', 'RWA', '646', 'N'),
(179, 180, 'SH', 'SAINT HELENA', 'Saint Helena', 'Santa Elena', 'SHN', '654', 'N'),
(180, 181, 'KN', 'SAINT KITTS AND NEVIS', 'Saint Kitts and Nevis', 'Saint Kitts y Nevis', 'KNA', '659', 'N'),
(181, 182, 'LC', 'SAINT LUCIA', 'Saint Lucia', 'Santa Lucía', 'LCA', '662', 'N'),
(182, 183, 'PM', 'SAINT PIERRE AND MIQUELON', 'Saint Pierre and Miquelon', 'Saint Pierre y Miquelón', 'SPM', '666', 'N'),
(183, 184, 'VC', 'SAINT VINCENT AND THE GRENADINES', 'Saint Vincent and the Grenadines', 'San Vicente y las Granadinas', 'VCT', '670', 'N'),
(184, 185, 'WS', 'SAMOA', 'Samoa', 'Samoa', 'WSM', '882', 'N'),
(185, 186, 'SM', 'SAN MARINO', 'San Marino', 'San Marino', 'SMR', '674', 'N'),
(186, 187, 'ST', 'SAO TOME AND PRINCIPE', 'Sao Tome and Principe', 'Santo Tomé y Príncipe', 'STP', '678', 'N'),
(187, 188, 'SA', 'SAUDI ARABIA', 'Saudi Arabia', 'Arabia Saudita', 'SAU', '682', 'N'),
(188, 189, 'SN', 'SENEGAL', 'Senegal', 'Senegal', 'SEN', '686', 'N'),
(189, 190, 'CS', 'SERBIA AND MONTENEGRO', 'Serbia and Montenegro', 'Serbia y Montenegro', '', '', 'N'),
(190, 191, 'SC', 'SEYCHELLES', 'Seychelles', 'Seychelles', 'SYC', '690', 'N'),
(191, 192, 'SL', 'SIERRA LEONE', 'Sierra Leone', 'Sierra Leona', 'SLE', '694', 'N'),
(192, 193, 'SG', 'SINGAPORE', 'Singapore', 'Singapur', 'SGP', '702', 'N'),
(193, 194, 'SK', 'SLOVAKIA', 'Slovakia', 'Eslovaquia', 'SVK', '703', 'N'),
(194, 195, 'SI', 'SLOVENIA', 'Slovenia', 'Eslovenia', 'SVN', '705', 'N'),
(195, 196, 'SB', 'SOLOMON ISLANDS', 'Solomon Islands', 'Islas Salomón', 'SLB', '90', 'N'),
(196, 197, 'SO', 'SOMALIA', 'Somalia', 'Somalia', 'SOM', '706', 'N'),
(197, 198, 'ZA', 'SOUTH AFRICA', 'South Africa', 'Sur de África', 'ZAF', '710', 'N'),
(198, 199, 'GS', 'SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS', 'South Georgia and the South Sandwich Islands', 'Georgia del Sur y las Islas Sandwich del Sur', '', '', 'N'),
(199, 200, 'ES', 'SPAIN', 'Spain', 'España', 'ESP', '724', 'N'),
(200, 201, 'LK', 'SRI LANKA', 'Sri Lanka', 'Sri Lanka', 'LKA', '144', 'N'),
(201, 202, 'SD', 'SUDAN', 'Sudan', 'Sudán', 'SDN', '736', 'N'),
(202, 203, 'SR', 'SURINAME', 'Suriname', 'Surinam', 'SUR', '740', 'N'),
(203, 204, 'SJ', 'SVALBARD AND JAN MAYEN', 'Svalbard and Jan Mayen', 'Svalbard y Jan Mayen', 'SJM', '744', 'N'),
(204, 205, 'SZ', 'SWAZILAND', 'Swaziland', 'Suazilandia', 'SWZ', '748', 'N'),
(205, 206, 'SE', 'SWEDEN', 'Sweden', 'Suecia', 'SWE', '752', 'N'),
(206, 207, 'CH', 'SWITZERLAND', 'Switzerland', 'Suiza', 'CHE', '756', 'N'),
(207, 208, 'SY', 'SYRIAN ARAB REPUBLIC', 'Syrian Arab Republic', 'República Árabe Siria', 'SYR', '760', 'N'),
(208, 209, 'TW', 'TAIWAN, PROVINCE OF CHINA', 'Taiwan, Province of China', 'Taiwán, Provincia de China', 'TWN', '158', 'N'),
(209, 210, 'TJ', 'TAJIKISTAN', 'Tajikistan', 'Tayikistán', 'TJK', '762', 'N'),
(210, 211, 'TZ', 'TANZANIA, UNITED REPUBLIC OF', 'Tanzania, United Republic of', 'Tanzania, República Unida de', 'TZA', '834', 'N'),
(211, 212, 'TH', 'THAILAND', 'Thailand', 'Tailandia', 'THA', '764', 'N'),
(212, 213, 'TL', 'TIMOR-LESTE', 'Timor-Leste', 'Timor-Leste', '', '', 'N'),
(213, 214, 'TG', 'TOGO', 'Togo', 'Togo', 'TGO', '768', 'N'),
(214, 215, 'TK', 'TOKELAU', 'Tokelau', 'Tokelau', 'TKL', '772', 'N'),
(215, 216, 'TO', 'TONGA', 'Tonga', 'Tonga', 'TON', '776', 'N'),
(216, 217, 'TT', 'TRINIDAD AND TOBAGO', 'Trinidad and Tobago', 'Trinidad y Tobago', 'TTO', '780', 'N'),
(217, 218, 'TN', 'TUNISIA', 'Tunisia', 'Túnez', 'TUN', '788', 'N'),
(218, 219, 'TR', 'TURKEY', 'Turkey', 'Turquía', 'TUR', '792', 'N'),
(219, 220, 'TM', 'TURKMENISTAN', 'Turkmenistan', 'Turkmenistán', 'TKM', '795', 'N'),
(220, 221, 'TC', 'TURKS AND CAICOS ISLANDS', 'Turks and Caicos Islands', 'Islas Turcas y Caicos', 'TCA', '796', 'N'),
(221, 222, 'TV', 'TUVALU', 'Tuvalu', 'Tuvalu', 'TUV', '798', 'N'),
(222, 223, 'UG', 'UGANDA', 'Uganda', 'Uganda', 'UGA', '800', 'N'),
(223, 224, 'UA', 'UKRAINE', 'Ukraine', 'Ucrania', 'UKR', '804', 'N'),
(224, 225, 'AE', 'UNITED ARAB EMIRATES', 'United Arab Emirates', 'Emiratos Árabes Unidos', 'ARE', '784', 'N'),
(225, 226, 'GB', 'UNITED KINGDOM', 'United Kingdom', 'Reino Unido', 'GBR', '826', 'N'),
(227, 227, 'UM', 'UNITED STATES MINOR OUTLYING ISLANDS', 'United States Minor Outlying Islands', 'Islas Menores de los EEUU', '', '', 'N'),
(228, 228, 'UY', 'URUGUAY', 'Uruguay', 'Uruguay', 'URY', '858', 'N'),
(229, 229, 'UZ', 'UZBEKISTAN', 'Uzbekistan', 'Uzbekistán', 'UZB', '860', 'N'),
(230, 230, 'VU', 'VANUATU', 'Vanuatu', 'Vanuatu', 'VUT', '548', 'N'),
(231, 231, 'VE', 'VENEZUELA', 'Venezuela', 'Venezuela', 'VEN', '862', 'N'),
(232, 232, 'VN', 'VIET NAM', 'Viet Nam', 'Viet Nam,', 'VNM', '704', 'N'),
(233, 233, 'VG', 'VIRGIN ISLANDS, BRITISH', 'Virgin Islands, British', 'Virgin Islands, British', 'VGB', '92', 'N'),
(234, 234, 'VI', 'VIRGIN ISLANDS, U.S.', 'Virgin Islands, U.s.', 'Islas Vírgenes, EE.UU.', 'VIR', '850', 'N'),
(235, 235, 'WF', 'WALLIS AND FUTUNA', 'Wallis and Futuna', 'Islas Wallis y Futuna', 'WLF', '876', 'N'),
(236, 236, 'EH', 'WESTERN SAHARA', 'Western Sahara', 'Sáhara Occidental', 'ESH', '732', 'N'),
(237, 237, 'YE', 'YEMEN', 'Yemen', 'Yemen', 'YEM', '887', 'N'),
(238, 238, 'ZM', 'ZAMBIA', 'Zambia', 'Zambia', 'ZMB', '894', 'N'),
(239, 239, 'ZW', 'ZIMBABWE', 'Zimbabwe', 'Zimbabue', 'ZWE', '716', 'N'),
(888, 1, 'US', 'UNITED STATES', 'United States', 'Estados Unidos', 'USA', '840', 'Y');

-- --------------------------------------------------------

--
-- Table structure for table `t_currencyConversion`
--

CREATE TABLE `t_currencyConversion` (
  `id` int NOT NULL,
  `Type` varchar(50) NOT NULL,
  `Rate` float NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t_currencyConversion`
--

INSERT INTO `t_currencyConversion` (`id`, `Type`, `Rate`) VALUES
(3, 'EUR', 88),
(4, 'USD', 74),
(5, 'GBP', 102),
(6, 'AUD', 58),
(8, 'NOK', 8.3),
(9, 'PLN', 17.5);

-- --------------------------------------------------------

--
-- Table structure for table `t_customer`
--

CREATE TABLE `t_customer` (
  `id` int NOT NULL,
  `companyID` varchar(50) NOT NULL,
  `agentId` int NOT NULL,
  `pin` int NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `passwd` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `state` varchar(255) DEFAULT NULL,
  `country` varchar(50) DEFAULT NULL,
  `zip` varchar(20) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `seperate_shipping_address` int NOT NULL,
  `shipping_fname` varchar(50) NOT NULL,
  `shipping_lname` varchar(50) NOT NULL,
  `shipping_contact` varchar(20) NOT NULL,
  `shipping_address` varchar(100) NOT NULL,
  `shipping_state` varchar(20) NOT NULL,
  `shipping_city` varchar(20) NOT NULL,
  `shipping_zip` varchar(20) NOT NULL,
  `tracking_no` varchar(20) NOT NULL,
  `secondaryPhone` varchar(50) DEFAULT NULL,
  `profileName` varchar(255) DEFAULT NULL,
  `image` varchar(100) DEFAULT NULL,
  `status` enum('Y','N') DEFAULT 'Y',
  `rec_crt_date` datetime DEFAULT NULL,
  `rec_up_date` datetime DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `ip_address` varchar(50) DEFAULT NULL,
  `refType` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `t_custom_product`
--

CREATE TABLE `t_custom_product` (
  `id` int NOT NULL,
  `tr_id` int NOT NULL,
  `product_name` varchar(255) NOT NULL,
  `no_item` smallint NOT NULL,
  `product_price` float NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `t_email`
--

CREATE TABLE `t_email` (
  `id` int NOT NULL,
  `customer_email` text,
  `rec_crt_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `t_email`
--

INSERT INTO `t_email` (`id`, `customer_email`, `rec_crt_date`) VALUES
(1, 'Test', '2023-09-01 10:59:46'),
(2, 'test', '2023-09-01 10:59:46'),
(3, 'Xyz', '2023-09-01 10:59:46'),
(4, 'xyz', '2023-09-01 10:59:46'),
(5, 'newt', '2023-09-01 10:59:46'),
(6, 'akashkanase81', '2023-09-01 10:59:46'),
(7, 'siddheshkap64', '2023-09-01 10:59:46'),
(8, 'kanaseakash9', '2023-09-01 10:59:46'),
(9, 'kapsiddhesh812', '2023-09-01 10:59:46'),
(10, 'xonyop69', '2023-09-01 10:59:46'),
(11, 'marivict.131', '2023-09-01 10:59:46'),
(12, 'geetr0001', '2023-09-01 10:59:46'),
(13, 'suryabishnoi75', '2023-09-01 10:59:46'),
(14, 'kapilvishnoi526', '2023-09-01 10:59:46'),
(15, 'annychauhan1998', '2023-09-01 10:59:46'),
(16, 'rlmzfntgxlr', '2023-09-01 10:59:46'),
(17, 'rajesh.t7010', '2023-09-01 10:59:46'),
(18, 'bossbhati744', '2023-09-01 10:59:46'),
(19, 'ajaysinghaniae', '2023-09-01 10:59:46'),
(20, 'parryjonas4', '2023-09-01 10:59:46'),
(21, 'jaas0898', '2023-09-01 10:59:46'),
(22, 'avishnoi810', '2023-09-01 10:59:46'),
(23, 'saranblsaran1', '2023-09-01 10:59:46'),
(24, 'mundelsuresh2513', '2023-09-01 10:59:46'),
(25, '21moneygamer', '2023-09-01 10:59:46'),
(26, '21moneygamer', '2023-09-01 10:59:46'),
(27, 'dropadivishnoi70', '2023-09-01 10:59:46'),
(28, 'shahkrim71190', '2023-09-01 10:59:46'),
(29, 'rakubhai29292929', '2023-09-01 10:59:46'),
(30, 'ravibishnoi830', '2023-09-01 10:59:46'),
(31, 'bdineshbhadu', '2023-09-01 10:59:46'),
(32, 'bishnoisom91', '2023-09-01 10:59:46'),
(33, 'bishnoimramphal', '2023-09-01 10:59:46'),
(34, 'profsite376', '2023-09-01 10:59:46'),
(35, 'pradeepkhawa2929', '2023-09-01 10:59:46'),
(36, 'pradeepkhawa2929', '2023-09-01 10:59:46'),
(37, 'yogeshsharma6688', '2023-09-01 10:59:46'),
(38, 'bishnoishrawan08', '2023-09-01 10:59:46'),
(39, 'rajubhai007', '2023-09-01 10:59:46'),
(40, 'anilsara001', '2023-09-01 10:59:46'),
(41, 'rameshvishnoi761', '2023-09-01 10:59:46'),
(42, 'omi572550', '2023-09-01 10:59:46'),
(43, 'ashokdhaka7665', '2023-09-01 10:59:46'),
(44, 'vikashbishnoii3435', '2023-09-01 10:59:46'),
(45, 'bishnoishyamsundar', '2023-09-01 10:59:46'),
(46, 'dineshvishnoi', '2023-09-01 10:59:46'),
(47, 'dineshvishnoi310', '2023-09-01 10:59:46'),
(48, 'vishnoiv35', '2023-09-01 10:59:46'),
(49, 'jbishnoi743', '2023-09-01 10:59:46'),
(50, 'himmatbanna729', '2023-09-01 10:59:46'),
(51, 'rajmisra58', '2023-09-01 10:59:46'),
(52, 'soniyarathore369', '2023-09-01 10:59:46'),
(53, 'saininawal7891444399', '2023-09-01 10:59:46'),
(54, 'ramchandrasaran029', '2023-09-01 10:59:46'),
(55, 'sonubishnoi098765', '2023-09-01 10:59:46'),
(56, 'surendarbishnoi978', '2023-09-01 10:59:46'),
(57, 'ekpreetsinghmakkar', '2023-09-01 10:59:46'),
(58, 'nemsabantajnvu2018', '2023-09-01 10:59:46'),
(59, 'mangilalj309', '2023-09-01 10:59:46'),
(60, 'anabi54179', '2023-09-01 10:59:46'),
(61, 'anabi54179', '2023-09-01 10:59:46'),
(62, 'anabi54179', '2023-09-01 10:59:46'),
(63, 'makkarpreet95', '2023-09-01 10:59:46'),
(64, 'surbhivishnoi29rs', '2023-09-01 10:59:46'),
(65, 'gopirambishnoiphalodi', '2023-09-01 10:59:46'),
(66, 'mangimanju39', '2023-09-01 10:59:46'),
(67, 'mangimanju39', '2023-09-01 10:59:46'),
(68, 'hetramb84', '2023-09-01 10:59:46'),
(69, 'vikashbhanwal', '2023-09-01 10:59:46'),
(70, 'kapilbishnoi004', '2023-09-01 10:59:46'),
(71, 'ramgopalvishnoi2925', '2023-09-01 10:59:46'),
(72, 'rajendragodara863', '2023-09-01 10:59:46'),
(73, 'kamalgodara616', '2023-09-01 10:59:46'),
(74, 'mahi.pal0127', '2023-09-01 10:59:46'),
(75, 'bhuraram010119999', '2023-09-01 10:59:46'),
(76, 'mgjb2929', '2023-09-01 10:59:46'),
(77, 'rajarambishnoi', '2023-09-01 10:59:46'),
(78, 'dsbhati7777', '2023-09-01 10:59:46'),
(79, 'shyamshyam00669', '2023-09-01 10:59:46'),
(80, '3sandeepbishnoi', '2023-09-01 10:59:46'),
(81, 'madan29siyag', '2023-09-01 10:59:46'),
(82, 'sushivishnoi96', '2023-09-01 10:59:46'),
(83, 'mangilalj309', '2023-09-01 10:59:46'),
(84, 'ss.bishnoi300', '2023-09-01 10:59:46'),
(85, 'sawai979904', '2023-09-01 10:59:46'),
(86, 'bhatilaxman96', '2023-09-01 10:59:46'),
(87, 'sharwandhaka729', '2023-09-01 10:59:46'),
(88, 'abc', '2023-09-01 10:59:46'),
(89, 'Abc', '2023-09-01 10:59:46'),
(90, 'anutoshsarkar1989', '2023-09-01 10:59:46'),
(91, 'ajnabibhati', '2023-09-01 10:59:46'),
(92, 'anilsiyag029', '2023-09-01 10:59:46'),
(93, 'omnamo', '2023-09-01 10:59:46'),
(94, 'pcvishnoi5231', '2023-09-01 10:59:46'),
(95, 'samvishnoi29299', '2023-09-01 10:59:46'),
(96, 'poonamchandmanzu2525', '2023-09-01 10:59:46'),
(97, 'ravr3128', '2023-09-01 10:59:46'),
(98, 'saisandeep0077', '2023-09-01 10:59:46'),
(99, 'mjj820064', '2023-09-01 10:59:46'),
(100, 'bishnoivikasa34', '2023-09-01 10:59:46'),
(101, 'vikashbishnoi8729', '2023-09-01 10:59:46'),
(102, '1983singh.v', '2023-09-01 10:59:46'),
(103, 'stefansmith1707', '2023-09-01 10:59:46'),
(104, 'suresh1988siyag', '2023-09-01 10:59:46'),
(105, 'ashok1987siyag', '2023-09-01 10:59:46'),
(106, 'mahipalbish31432', '2023-09-01 10:59:46'),
(107, 'sutharprakash5292', '2023-09-01 10:59:46'),
(108, 'vishnoikamlesh68', '2023-09-01 10:59:46'),
(109, 'omjidara1979', '2023-09-01 10:59:46'),
(110, 'sg6407081', '2023-09-01 10:59:46'),
(111, 'celltrail540', '2023-09-01 10:59:46'),
(112, 'manaklal062', '2023-09-01 10:59:46'),
(113, 'jram49028', '2023-09-01 10:59:46'),
(114, 'mzfmpapowfdf', '2023-09-01 10:59:46'),
(115, 'omfpftrvb', '2023-09-01 10:59:46'),
(116, 'ranabisenrb', '2023-09-01 10:59:46'),
(117, 'raqaegshwhfyr', '2023-09-01 10:59:46'),
(118, 'zjykbdkrbnpu', '2023-09-01 10:59:46'),
(119, 'khankemi6', '2023-09-01 10:59:46'),
(120, 'pewmtw', '2023-09-01 10:59:46'),
(121, 'arjunrambishnoi8899', '2023-09-01 10:59:46'),
(122, 'robin04998', '2023-09-01 10:59:46'),
(123, 'selhuvolohe007', '2023-09-01 10:59:46'),
(124, 'amit123', '2023-09-01 10:59:46'),
(125, 'ssdxbg', '2023-09-01 10:59:46'),
(126, 'zzhwvvtuxiuhda', '2023-09-01 10:59:46'),
(127, 'jassachauhan321', '2023-09-01 10:59:46'),
(128, 'cccchutwala', '2023-09-01 10:59:46'),
(129, 'jatinmakker8', '2023-09-01 10:59:46'),
(130, 'qddolat', '2023-09-01 10:59:46'),
(131, 'princemakker1', '2023-09-01 10:59:46'),
(132, 'abdaizr', '2023-09-01 10:59:46'),
(133, 'wakpaoau', '2023-09-01 10:59:46'),
(134, 'jannatlove8998', '2023-09-01 10:59:46'),
(135, 'baghotmeenu', '2023-09-01 10:59:46'),
(136, 'manojsinaruram', '2023-09-01 10:59:46'),
(137, 'mahipalbhojakor', '2023-09-01 10:59:46'),
(138, 'ravr3128', '2023-09-01 10:59:46'),
(139, 'arpitvishnoi88', '2023-09-01 10:59:46'),
(140, 'vishnoiikapil463', '2023-09-01 10:59:46'),
(141, 'bishnoisway', '2023-09-01 10:59:46'),
(142, 'samvishnoi29299', '2023-09-01 10:59:46'),
(143, 'anil2929vishnoiii', '2023-09-01 10:59:46'),
(144, 'bhanwarlalbishnoi759', '2023-09-01 10:59:46'),
(145, 'brandofbishnoi', '2023-09-01 10:59:46'),
(146, 'raturockr', '2023-09-01 10:59:46'),
(147, 'akhilmali723', '2023-09-01 10:59:46'),
(148, 'vickvishnoii', '2023-09-01 10:59:46'),
(149, 'sachinsaran920', '2023-09-01 10:59:46'),
(150, 'rakeshbishnoi9132', '2023-09-01 10:59:46'),
(151, 'pcvishnoi5231', '2023-09-01 10:59:46'),
(152, 'surendarbishnoi978', '2023-09-01 10:59:46');

-- --------------------------------------------------------

--
-- Table structure for table `t_events`
--

CREATE TABLE `t_events` (
  `id` int NOT NULL,
  `createdby` int NOT NULL,
  `subject` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y',
  `rec_crt_date` datetime NOT NULL,
  `rec_up_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `t_gatewayCurrencies`
--

CREATE TABLE `t_gatewayCurrencies` (
  `id` int NOT NULL,
  `gatewayId` varchar(50) NOT NULL,
  `currency` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `t_groupCenter`
--

CREATE TABLE `t_groupCenter` (
  `id` int NOT NULL,
  `groupID` int NOT NULL,
  `ipn_no` varchar(50) NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t_groupCenter`
--

INSERT INTO `t_groupCenter` (`id`, `groupID`, `ipn_no`, `status`) VALUES
(1, 1, 'Subhojit', 'Y'),
(2, 4, 'LIVITCRMID002', 'Y'),
(3, 4, 'LIVITCRMID003', 'Y');

-- --------------------------------------------------------

--
-- Table structure for table `t_groups`
--

CREATE TABLE `t_groups` (
  `id` int NOT NULL,
  `groups` varchar(20) NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t_groups`
--

INSERT INTO `t_groups` (`id`, `groups`, `status`) VALUES
(1, 'Admin', 'Y'),
(2, 'Sales', 'Y'),
(3, 'Joaquin Lasa Group', 'Y'),
(4, 'Delasports', 'Y');

-- --------------------------------------------------------

--
-- Table structure for table `t_incident`
--

CREATE TABLE `t_incident` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `organization_id` int NOT NULL,
  `location_address` varchar(100) NOT NULL,
  `location_city` varchar(100) NOT NULL,
  `location_state` varchar(100) NOT NULL,
  `location_zip` varchar(20) NOT NULL,
  `location_county` varchar(100) NOT NULL,
  `incident_type_id` int NOT NULL,
  `comment` text NOT NULL,
  `post_as_anonymous` enum('Y','N') NOT NULL,
  `incident_visibility` enum('Public','Privet','Protected') NOT NULL,
  `status` enum('Y','N') NOT NULL,
  `rec_crt_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `t_incident_type`
--

CREATE TABLE `t_incident_type` (
  `id` int NOT NULL,
  `type` varchar(100) NOT NULL,
  `parent_id` int NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y',
  `rec_crt_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `t_invoice`
--

CREATE TABLE `t_invoice` (
  `id` int NOT NULL,
  `companyID` varchar(255) NOT NULL,
  `invoice_id` varchar(20) NOT NULL,
  `customerId` int NOT NULL,
  `agentID` int NOT NULL,
  `productId` int NOT NULL,
  `quantity` int NOT NULL,
  `couponId` int NOT NULL,
  `grossPrice` float NOT NULL,
  `product_price` float NOT NULL,
  `shipping_price` float NOT NULL,
  `cardType` varchar(50) NOT NULL,
  `cardNo` varchar(50) NOT NULL,
  `gatewayID` varchar(255) NOT NULL,
  `gatewayTransactionId` varchar(255) DEFAULT NULL,
  `sourceCode` varchar(255) NOT NULL,
  `batch_id` varchar(50) NOT NULL,
  `sign` text NOT NULL,
  `ip` varchar(255) NOT NULL,
  `paid` enum('Y','N') NOT NULL DEFAULT 'N',
  `sale_type` int NOT NULL DEFAULT '0',
  `gateway_descriptor` varchar(255) NOT NULL,
  `company_name` varchar(255) NOT NULL,
  `productDuration` varchar(255) NOT NULL,
  `RoutingNumber` varchar(50) NOT NULL,
  `AccountNumber` varchar(50) NOT NULL,
  `BankName` varchar(255) NOT NULL,
  `CheckDate` varchar(50) NOT NULL,
  `CheckNumber` varchar(50) NOT NULL,
  `CheckMemo` varchar(50) NOT NULL,
  `paymentType` varchar(255) NOT NULL,
  `securityProtection` int NOT NULL,
  `totalDevices` int NOT NULL,
  `originalGatewayTransactionId` varchar(50) NOT NULL,
  `reason_code` varchar(255) NOT NULL,
  `reason_descrption` varchar(255) NOT NULL,
  `status` enum('Capture','Sale','Refund','Credit','Authorize','Void','Verify','Settlement','Return','Decrypt','Chargeback','Failed') DEFAULT NULL,
  `captured_by` varchar(255) NOT NULL,
  `captured_date` datetime NOT NULL,
  `rec_crt_date` datetime NOT NULL,
  `rec_up_date` datetime NOT NULL,
  `rec_end_date` datetime NOT NULL,
  `frozen` enum('Y','N') NOT NULL DEFAULT 'N',
  `frozenDate` datetime NOT NULL,
  `releaseDate` datetime NOT NULL,
  `master_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `t_ipn_login_history`
--

CREATE TABLE `t_ipn_login_history` (
  `id` int NOT NULL,
  `login_session_id` varchar(255) DEFAULT NULL,
  `ipn` varchar(255) DEFAULT NULL,
  `pass` varchar(255) DEFAULT NULL,
  `ip_address` varchar(255) DEFAULT NULL,
  `action` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `fail_reason` text,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Table structure for table `t_kyc`
--

CREATE TABLE `t_kyc` (
  `id` int NOT NULL,
  `tr_id` int NOT NULL,
  `kyc_type` varchar(255) NOT NULL,
  `file` varchar(255) NOT NULL,
  `rec_crt_date` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `t_logdetails`
--

CREATE TABLE `t_logdetails` (
  `id` int NOT NULL,
  `details` text NOT NULL,
  `gateway_response` text NOT NULL,
  `master_id` int NOT NULL,
  `rec_crt_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `t_master_sales_bak`
--

CREATE TABLE `t_master_sales_bak` (
  `id` int NOT NULL,
  `mid_no` varchar(50) NOT NULL,
  `client_transaction_id` varchar(20) NOT NULL,
  `order_id` varchar(20) NOT NULL,
  `companyID` varchar(255) NOT NULL,
  `customer_name` varchar(255) NOT NULL,
  `customer_email` varchar(255) NOT NULL,
  `customer_address` varchar(255) NOT NULL,
  `customer_city` varchar(255) NOT NULL,
  `customer_state` varchar(255) NOT NULL,
  `customer_country` varchar(255) NOT NULL,
  `customer_zip` varchar(255) NOT NULL,
  `customer_phone` varchar(255) NOT NULL,
  `grossPrice` float NOT NULL,
  `currency_type` varchar(20) NOT NULL,
  `card_no` varchar(20) NOT NULL,
  `cvv` varchar(10) NOT NULL,
  `card_mm` varchar(10) NOT NULL,
  `card_yy` varchar(10) NOT NULL,
  `gatewayTransactionId` varchar(255) DEFAULT NULL,
  `ip` varchar(50) NOT NULL,
  `status` varchar(50) NOT NULL DEFAULT 'Authorize',
  `refund` enum('Y','N') NOT NULL DEFAULT 'N',
  `refund_date` datetime NOT NULL,
  `chargeback` enum('Y','N') NOT NULL DEFAULT 'N',
  `chagreback_date` datetime NOT NULL,
  `rec_crt_date` datetime NOT NULL,
  `rec_up_date` datetime NOT NULL,
  `callback_url` varchar(255) NOT NULL,
  `success_url` varchar(255) NOT NULL,
  `fail_url` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `t_MidCenter`
--

CREATE TABLE `t_MidCenter` (
  `id` int NOT NULL,
  `companyID` varchar(50) NOT NULL,
  `gatewayID` varchar(50) NOT NULL,
  `status` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `t_midCenter`
--

CREATE TABLE `t_midCenter` (
  `id` int NOT NULL,
  `ipn` varchar(50) NOT NULL,
  `gatewayID` varchar(50) NOT NULL,
  `daily_volume` float NOT NULL,
  `weekly_volume` float NOT NULL,
  `monthly_volume` float NOT NULL,
  `mdr` float NOT NULL,
  `rolling_reserve` float NOT NULL,
  `deny` enum('Y') DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `t_mid_configuration`
--

CREATE TABLE `t_mid_configuration` (
  `id` int NOT NULL,
  `ipn` varchar(255) DEFAULT NULL,
  `gateway_id` int DEFAULT NULL,
  `gateway_configuration` longtext,
  `rec_crt_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Table structure for table `t_organization`
--

CREATE TABLE `t_organization` (
  `id` int NOT NULL,
  `companyID` varchar(50) NOT NULL,
  `name` varchar(100) NOT NULL,
  `about` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `email` varchar(100) NOT NULL,
  `address` varchar(255) NOT NULL,
  `city` varchar(50) NOT NULL,
  `state` varchar(50) NOT NULL,
  `zip` varchar(20) NOT NULL,
  `country` int NOT NULL,
  `website` varchar(255) NOT NULL,
  `type` varchar(50) NOT NULL,
  `customColor` varchar(25) NOT NULL DEFAULT '#000000',
  `customText` varchar(25) NOT NULL,
  `ip_address` varchar(50) NOT NULL,
  `rec_crt_date` datetime NOT NULL,
  `rec_up_date` datetime NOT NULL,
  `status` enum('Y','N') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `t_organization_admin`
--

CREATE TABLE `t_organization_admin` (
  `id` int NOT NULL,
  `user_id` int NOT NULL,
  `org_id` int NOT NULL,
  `admin_type` tinyint NOT NULL,
  `status` enum('Y','N') NOT NULL,
  `rec_crt_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `t_password_alert_tbl`
--

CREATE TABLE `t_password_alert_tbl` (
  `id` int NOT NULL,
  `ipn` varchar(255) DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `pass_change_date` timestamp NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Table structure for table `t_phone`
--

CREATE TABLE `t_phone` (
  `id` int NOT NULL,
  `customer_phone` text,
  `rec_crt_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `t_phone`
--

INSERT INTO `t_phone` (`id`, `customer_phone`, `rec_crt_date`) VALUES
(1, '9527241127', '2023-09-01 09:18:16'),
(2, '9321564228', '2023-09-01 09:20:02'),
(3, '917494851136', '2023-09-01 09:22:10'),
(4, '918607312031', '2023-09-01 09:24:19'),
(5, '919114831423', '2023-09-01 09:24:19'),
(6, '918306210529', '2023-09-01 09:24:19'),
(7, '917568926329', '2023-09-01 09:24:19'),
(8, '919866897010', '2023-09-01 09:24:19'),
(9, '8824341060', '2023-09-01 09:24:19'),
(10, '918824341060', '2023-09-01 09:24:19'),
(11, '8290947156', '2023-09-01 09:24:19'),
(12, '918290947156', '2023-09-01 09:24:19'),
(13, '919179877072', '2023-09-01 09:24:19'),
(14, '917412908528', '2023-09-01 09:24:19'),
(15, '917412908429', '2023-09-01 09:24:19'),
(16, '9460032289', '2023-09-01 09:24:19'),
(17, '919460032289', '2023-09-01 09:24:19'),
(18, '7976744692', '2023-09-01 09:24:19'),
(19, '917976744692', '2023-09-01 09:24:19'),
(20, '918555010191', '2023-09-01 09:24:19'),
(21, '8555010191', '2023-09-01 09:24:19'),
(22, '918555010191', '2023-09-01 09:24:19'),
(23, '6377040072', '2023-09-01 09:24:19'),
(24, '916377040072', '2023-09-01 09:24:19'),
(25, '7874061504', '2023-09-01 09:24:19'),
(26, '917874061504', '2023-09-01 09:24:19'),
(27, '918690526229', '2023-09-01 09:24:19'),
(28, '918302169531', '2023-09-01 09:24:19'),
(29, '9001682833', '2023-09-01 09:24:19'),
(30, '919001682833', '2023-09-01 09:24:19'),
(31, '6367479227', '2023-09-01 09:24:19'),
(32, '916367479227', '2023-09-01 09:24:19'),
(33, '7014372431', '2023-09-01 09:24:19'),
(34, '917014372431', '2023-09-01 09:24:19'),
(35, '919971844192', '2023-09-01 09:24:19'),
(36, '9971844192', '2023-09-01 09:24:19'),
(37, '918094334294', '2023-09-01 09:24:19'),
(38, '8094334294', '2023-09-01 09:24:19'),
(39, '919643749919', '2023-09-01 09:24:19'),
(40, '9643749919', '2023-09-01 09:24:19'),
(41, '917742570668', '2023-09-01 09:24:19'),
(42, '7742570668', '2023-09-01 09:24:19'),
(43, '919530003600', '2023-09-01 09:24:19'),
(44, '9530003600', '2023-09-01 09:24:19'),
(45, '958736335115', '2023-09-01 09:24:19'),
(46, '918736335115', '2023-09-01 09:24:19'),
(47, '8736335115', '2023-09-01 09:24:19'),
(48, '918160726434', '2023-09-01 09:24:19'),
(49, '8160726434', '2023-09-01 09:24:19'),
(50, '919829776069', '2023-09-01 09:24:19'),
(51, '9829776069', '2023-09-01 09:24:19'),
(52, '918302180798', '2023-09-01 09:24:19'),
(53, '8302180798', '2023-09-01 09:24:19'),
(54, '918440059229', '2023-09-01 09:24:19'),
(55, '8440059229', '2023-09-01 09:24:19'),
(56, '918850753878', '2023-09-01 09:24:19'),
(57, '8850753878', '2023-09-01 09:24:19'),
(58, '9829020703', '2023-09-01 09:24:19'),
(59, '919829020703', '2023-09-01 09:24:19'),
(60, '6350446280', '2023-09-01 09:24:19'),
(61, '916350446280', '2023-09-01 09:24:19'),
(62, '919571928955', '2023-09-01 09:24:19'),
(63, '9571928955', '2023-09-01 09:24:19'),
(64, '917800600003', '2023-09-01 09:24:19'),
(65, '7800600003', '2023-09-01 09:24:19'),
(66, '919875758798', '2023-09-01 09:24:19'),
(67, '9875758798', '2023-09-01 09:24:19'),
(68, '917891444399', '2023-09-01 09:24:19'),
(69, '7891444399', '2023-09-01 09:24:19'),
(70, '91961431996', '2023-09-01 09:24:19'),
(71, '961431996', '2023-09-01 09:24:19'),
(72, '968286245', '2023-09-01 09:24:19'),
(73, '7737100629', '2023-09-01 09:24:19'),
(74, '8955101419', '2023-09-01 09:24:19'),
(75, '9414405930', '2023-09-01 09:24:19'),
(76, '8985238735', '2023-09-01 09:24:19'),
(77, '9618678256', '2023-09-01 09:24:19'),
(78, '9618678256', '2023-09-01 09:24:19'),
(79, '9618678256', '2023-09-01 09:24:19'),
(80, '7973060545', '2023-09-01 09:24:19'),
(81, '7023914103', '2023-09-01 09:24:19'),
(82, '8529670042', '2023-09-01 09:24:19'),
(83, '6350446749', '2023-09-01 09:24:19'),
(84, '8529670042', '2023-09-01 09:24:19'),
(85, '9079830866', '2023-09-01 09:24:19'),
(86, '9772905395', '2023-09-01 09:24:19'),
(87, '7232812931', '2023-09-01 09:24:19'),
(88, '7851989316', '2023-09-01 09:24:19'),
(89, '917357751129', '2023-09-01 09:24:19'),
(90, '7357751129', '2023-09-01 09:24:19'),
(91, '6376586783', '2023-09-01 09:24:19'),
(92, '918140464903', '2023-09-01 09:24:19'),
(93, '8140464903', '2023-09-01 09:24:19'),
(94, '7727935340', '2023-09-01 09:24:19'),
(95, '8696166540', '2023-09-01 09:24:19'),
(96, '9351310865', '2023-09-01 09:24:19'),
(97, '8306803398', '2023-09-01 09:24:19'),
(98, '6377324414', '2023-09-01 09:24:19'),
(99, '7740865558', '2023-09-01 09:24:19'),
(100, '9460310509', '2023-09-01 09:24:19'),
(101, '8985238735', '2023-09-01 09:24:19'),
(102, '9509167996', '2023-09-01 09:24:19'),
(103, '8824313831', '2023-09-01 09:24:19'),
(104, '9982942289', '2023-09-01 09:24:19'),
(105, '7240700290', '2023-09-01 09:24:19'),
(106, '9732615616', '2023-09-01 09:24:19'),
(107, '919732615616', '2023-09-01 09:24:19'),
(108, '919649432795', '2023-09-01 09:24:19'),
(109, '9649432795', '2023-09-01 09:24:19'),
(110, '9772605231', '2023-09-01 09:24:19'),
(111, '9660601281', '2023-09-01 09:24:19'),
(112, '919815078056', '2023-09-01 09:24:19'),
(113, '9815078056', '2023-09-01 09:24:19'),
(114, '918123473180', '2023-09-01 09:24:19'),
(115, '918769856587', '2023-09-01 09:24:19'),
(116, '918239333322', '2023-09-01 09:24:19'),
(117, '917483168930', '2023-09-01 09:24:19'),
(118, '9001380939', '2023-09-01 09:24:19'),
(119, '9001380939', '2023-09-01 09:24:19'),
(120, '919983753642', '2023-09-01 09:24:19'),
(121, '919462340557', '2023-09-01 09:24:19'),
(122, '9462340557', '2023-09-01 09:24:19'),
(123, '919509399199', '2023-09-01 09:24:19'),
(124, '9509399199', '2023-09-01 09:24:19'),
(125, '919581091985', '2023-09-01 09:24:19'),
(126, '9581091985', '2023-09-01 09:24:19'),
(127, '918239333322', '2023-09-01 09:24:19'),
(128, '919414216729', '2023-09-01 09:24:19'),
(129, '918955460585', '2023-09-01 09:24:19'),
(130, '919636892829', '2023-09-01 09:24:19'),
(131, '9636892829', '2023-09-01 09:24:19'),
(132, '917339815292', '2023-09-01 09:24:19'),
(133, '919549407565', '2023-09-01 09:24:19'),
(134, '917795764396', '2023-09-01 09:24:19'),
(135, '919843399211', '2023-09-01 09:24:19'),
(136, '919116128329', '2023-09-01 09:24:19'),
(137, '916377964496', '2023-09-01 09:24:19'),
(138, '8123473180', '2023-09-01 09:24:19'),
(139, '8769856587', '2023-09-01 09:24:19'),
(140, '8239333322', '2023-09-01 09:24:19'),
(141, '7483168930', '2023-09-01 09:24:19'),
(142, '9983753642', '2023-09-01 09:24:19'),
(143, '8239333322', '2023-09-01 09:24:19'),
(144, '9414216729', '2023-09-01 09:24:19'),
(145, '8955460585', '2023-09-01 09:24:19'),
(146, '7339815292', '2023-09-01 09:24:19'),
(147, '9549407565', '2023-09-01 09:24:19'),
(148, '7795764396', '2023-09-01 09:24:19'),
(149, '9843399211', '2023-09-01 09:24:19'),
(150, '9116128329', '2023-09-01 09:24:19'),
(151, '6377964496', '2023-09-01 09:24:19'),
(152, '9636892829', '2023-09-01 09:24:19'),
(153, '919636892829', '2023-09-01 09:24:19'),
(154, '7869001129', '2023-09-01 09:24:19'),
(155, '9988195216', '2023-09-01 09:24:19'),
(156, '7889910229', '2023-09-01 09:24:19'),
(157, '9988195216', '2023-09-01 09:24:19'),
(158, '7869110222', '2023-09-01 09:24:19'),
(159, '7869220119', '2023-09-01 09:24:19'),
(160, '9855795928', '2023-09-01 09:24:19'),
(161, '7869110228', '2023-09-01 09:24:19'),
(162, '9988134138', '2023-09-01 09:24:19'),
(163, '7779110229', '2023-09-01 09:24:19'),
(164, '7589625534', '2023-09-01 09:24:19'),
(165, '9988223305', '2023-09-01 09:24:19'),
(166, '8528441400', '2023-09-01 09:24:19'),
(167, '9569778295', '2023-09-01 09:24:19'),
(168, '9041204998', '2023-09-01 09:24:19'),
(169, '689752524', '2023-09-01 09:24:19'),
(170, '7007254136', '2023-09-01 09:24:19'),
(171, '6457288947', '2023-09-01 09:24:19'),
(172, '799613918', '2023-09-01 09:24:19'),
(173, '9414136199', '2023-09-01 09:24:19'),
(174, '9928617605', '2023-09-01 09:24:19'),
(175, '917869001129', '2023-09-01 09:24:19'),
(176, '919988195216', '2023-09-01 09:24:19'),
(177, '917889910229', '2023-09-01 09:24:19'),
(178, '919988195216', '2023-09-01 09:24:19'),
(179, '917869110222', '2023-09-01 09:24:19'),
(180, '917869220119', '2023-09-01 09:24:19'),
(181, '919855795928', '2023-09-01 09:24:19'),
(182, '917869110228', '2023-09-01 09:24:19'),
(183, '919988134138', '2023-09-01 09:24:19'),
(184, '917779110229', '2023-09-01 09:24:19'),
(185, '917589625534', '2023-09-01 09:24:19'),
(186, '919988223305', '2023-09-01 09:24:19'),
(187, '918528441400', '2023-09-01 09:24:19'),
(188, '919569778295', '2023-09-01 09:24:19'),
(189, '919041204998', '2023-09-01 09:24:19'),
(190, '91689752524', '2023-09-01 09:24:19'),
(191, '917007254136', '2023-09-01 09:24:19'),
(192, '916457288947', '2023-09-01 09:24:19'),
(193, '91799613918', '2023-09-01 09:24:19'),
(194, '919414136199', '2023-09-01 09:24:19'),
(195, '919928617605', '2023-09-01 09:24:19'),
(196, '8306223255', '2023-09-01 09:24:19'),
(197, '918306223255', '2023-09-01 09:24:19'),
(198, '917877742353', '2023-09-01 09:24:19'),
(199, '7877742353', '2023-09-01 09:24:19'),
(200, '917506016894', '2023-09-01 09:24:19'),
(201, '7506016894', '2023-09-01 09:24:19'),
(202, '918440036829', '2023-09-01 09:24:19'),
(203, '8440036829', '2023-09-01 09:24:19'),
(204, '8306192937', '2023-09-01 09:24:19'),
(205, '7597680351', '2023-09-01 09:24:19'),
(206, '8769689677', '2023-09-01 09:24:19'),
(207, '7062298429', '2023-09-01 09:24:19'),
(208, '918306192937', '2023-09-01 09:24:19'),
(209, '917597680351', '2023-09-01 09:24:19'),
(210, '918769689677', '2023-09-01 09:24:19'),
(211, '917062298429', '2023-09-01 09:24:19'),
(212, '9462998490', '2023-09-01 09:24:19'),
(213, '919462998490', '2023-09-01 09:24:19'),
(214, '919772605231', '2023-09-01 09:24:19'),
(215, '9772605231', '2023-09-01 09:24:19'),
(216, '918875112390', '2023-09-01 09:24:19'),
(217, '918571079601', '2023-09-01 09:24:19'),
(218, '919991735111', '2023-09-01 09:24:19');

-- --------------------------------------------------------

--
-- Table structure for table `t_product`
--

CREATE TABLE `t_product` (
  `id` int NOT NULL,
  `companyID` varchar(50) NOT NULL,
  `productName` varchar(255) NOT NULL,
  `productPrice` float NOT NULL,
  `ProductSupscriptionPeriod` int NOT NULL,
  `no_of_support` int NOT NULL,
  `productDescription` varchar(255) NOT NULL,
  `productType` enum('Tangible','Service') NOT NULL,
  `discount` float NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y',
  `rec_crt_date` datetime NOT NULL,
  `rec_up_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `t_queryLog`
--

CREATE TABLE `t_queryLog` (
  `id` int NOT NULL,
  `queryType` varchar(255) NOT NULL,
  `queryText` text NOT NULL,
  `rec_crt_date` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `t_secure_data`
--

CREATE TABLE `t_secure_data` (
  `id` int NOT NULL,
  `generated_key` text NOT NULL,
  `rec_crt_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `t_secure_data`
--

INSERT INTO `t_secure_data` (`id`, `generated_key`, `rec_crt_at`) VALUES
(1, '1DUvHMTDYPjZu8BR', '2024-02-29 09:11:06');

-- --------------------------------------------------------

--
-- Table structure for table `t_state`
--

CREATE TABLE `t_state` (
  `id` int NOT NULL,
  `countryId` int NOT NULL,
  `name` char(40) NOT NULL,
  `order_id` int NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `t_state`
--

INSERT INTO `t_state` (`id`, `countryId`, `name`, `order_id`, `status`) VALUES
(1, 888, 'Alabama', 0, 'Y'),
(2, 888, 'Alaska', 0, 'Y'),
(3, 888, 'Arizona', 0, 'Y'),
(4, 888, 'Arkansas', 0, 'Y'),
(5, 888, 'California', 0, 'Y'),
(6, 888, 'Colorado', 0, 'Y'),
(7, 888, 'Connecticut', 0, 'Y'),
(8, 888, 'Delaware', 0, 'Y'),
(9, 888, 'Florida', 0, 'Y'),
(10, 888, 'Georgia', 0, 'Y'),
(11, 888, 'Hawaii', 0, 'Y'),
(12, 888, 'Idaho', 0, 'Y'),
(13, 888, 'Illinois', 0, 'Y'),
(14, 888, 'Indiana', 0, 'Y'),
(15, 888, 'Iowa', 0, 'Y'),
(16, 888, 'Kansas', 0, 'Y'),
(17, 888, 'Kentucky', 0, 'Y'),
(18, 888, 'Louisiana', 0, 'Y'),
(19, 888, 'Maine', 0, 'Y'),
(20, 888, 'Maryland', 0, 'Y'),
(21, 888, 'Massachusetts', 0, 'Y'),
(22, 888, 'Michigan', 0, 'Y'),
(23, 888, 'Minnesota', 0, 'Y'),
(24, 888, 'Mississippi', 0, 'Y'),
(25, 888, 'Missouri', 0, 'Y'),
(26, 888, 'Montana', 0, 'Y'),
(27, 888, 'Nebraska', 0, 'Y'),
(28, 888, 'Nevada', 0, 'Y'),
(29, 888, 'New Hampshire', 0, 'Y'),
(30, 888, 'New Jersey', 0, 'Y'),
(31, 888, 'New Mexico', 0, 'Y'),
(32, 888, 'New York', 0, 'Y'),
(33, 888, 'North Carolina', 0, 'Y'),
(34, 888, 'North Dakota', 0, 'Y'),
(35, 888, 'Ohio', 0, 'Y'),
(36, 888, 'Oklahoma', 0, 'Y'),
(37, 888, 'Oregon', 0, 'Y'),
(38, 888, 'Pennsylvania', 0, 'N'),
(39, 888, 'Rhode Island', 0, 'Y'),
(40, 888, 'South Carolina', 0, 'Y'),
(41, 888, 'South Dakota', 0, 'Y'),
(42, 888, 'Tennessee', 0, 'Y'),
(43, 888, 'Texas', 0, 'Y'),
(44, 888, 'Utah', 0, 'Y'),
(45, 888, 'Vermont', 0, 'Y'),
(46, 888, 'Virginia', 0, 'Y'),
(47, 888, 'Washington', 0, 'Y'),
(48, 888, 'West Virginia', 0, 'Y'),
(49, 888, 'Wisconsin', 0, 'Y'),
(50, 888, 'Wyoming', 0, 'Y'),
(51, 888, 'American Samoa', 0, 'Y'),
(52, 888, 'District of Columbia', 0, 'Y'),
(53, 888, 'Guam', 0, 'Y'),
(54, 888, ' Northern Mariana Islands', 0, 'Y'),
(55, 888, 'Puerto Rico', 0, 'Y'),
(56, 888, 'United States Virgin Islands', 0, 'Y'),
(57, 38, 'Ontario', 0, 'Y'),
(58, 38, 'Quebec', 0, 'Y'),
(59, 38, 'Nova Scotia', 0, 'Y'),
(60, 38, 'New Brunswick', 0, 'Y'),
(61, 38, 'Manitoba', 0, 'Y'),
(62, 38, 'British Columbia', 0, 'Y'),
(63, 38, 'Prince Edward Island 	', 0, 'Y'),
(64, 38, 'Saskatchewan', 0, 'Y'),
(65, 38, 'Alberta', 0, 'Y'),
(66, 38, 'Newfoundland and Labrador', 0, 'Y'),
(67, 38, 'Northwest Territories', 0, 'Y'),
(68, 38, 'Nunavut', 0, 'Y'),
(69, 38, 'Yukon', 0, 'Y'),
(70, 13, 'Ashmore and Cartier Islands', 0, 'Y'),
(71, 13, 'Australian Antarctic Territory', 0, 'Y'),
(72, 13, 'Australian Capital Territory', 0, 'Y'),
(73, 13, 'Christmas Island', 0, 'Y'),
(74, 13, 'Cocos (Keeling) Islands', 0, 'Y'),
(75, 13, 'Coral Sea Islands', 0, 'Y'),
(76, 13, 'Heard Island and McDonald Islands', 0, 'Y'),
(77, 13, 'Jervis Bay Territory', 0, 'Y'),
(78, 13, 'New South Wales', 0, 'Y'),
(79, 13, 'Norfolk Island', 0, 'Y'),
(80, 13, 'Northern Territory', 0, 'Y'),
(81, 13, 'Queensland', 0, 'Y'),
(82, 13, 'South Australia', 0, 'Y'),
(83, 13, 'Tasmania', 0, 'Y'),
(84, 13, 'Victoria', 0, 'Y'),
(85, 13, 'Western Australia', 0, 'Y');

-- --------------------------------------------------------

--
-- Table structure for table `t_systemEvents`
--

CREATE TABLE `t_systemEvents` (
  `id` int NOT NULL,
  `email` varchar(255) NOT NULL,
  `event` varchar(255) NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `t_systemSettings`
--

CREATE TABLE `t_systemSettings` (
  `id` int NOT NULL,
  `slug` varchar(50) NOT NULL,
  `slug_value` varchar(100) NOT NULL,
  `description` varchar(255) NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'Y'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `t_system_settings`
--

CREATE TABLE `t_system_settings` (
  `id` int NOT NULL,
  `SYSTEMMAXSALESALLOWED` float NOT NULL,
  `ECHECKINGALLOWED` enum('Y','N') NOT NULL DEFAULT 'N',
  `AuthorizedSaleAmount` float NOT NULL,
  `searchLimit` int NOT NULL,
  `newTollFreeNo` varchar(50) NOT NULL,
  `order_by` enum('asc','desc') NOT NULL DEFAULT 'asc',
  `pending_order_fld` enum('date','amount') NOT NULL DEFAULT 'date',
  `pending_oder_by` enum('asc','desc') NOT NULL DEFAULT 'asc',
  `Mid_Selection` enum('Y','N') NOT NULL DEFAULT 'Y',
  `international_routine` enum('Y','N') NOT NULL DEFAULT 'N',
  `techSupportStatusChange` enum('Y','N') NOT NULL DEFAULT 'N',
  `selectCenter` varchar(255) NOT NULL,
  `show_all_center_gateway` enum('Y','N') NOT NULL DEFAULT 'N'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `t_transaction_code`
--

CREATE TABLE `t_transaction_code` (
  `transaction_code_id` int NOT NULL,
  `agent_id` int NOT NULL,
  `transaction_code` int NOT NULL,
  `rec_crt_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `t_transaction_logs`
--

CREATE TABLE `t_transaction_logs` (
  `id` int NOT NULL,
  `client_transaction_id` longtext,
  `ipn` longtext,
  `gateway` longtext,
  `gateway_response` longtext,
  `rec_crt_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Table structure for table `t_txn_ipn_details`
--

CREATE TABLE `t_txn_ipn_details` (
  `id` int NOT NULL,
  `client_transaction_id` varchar(255) DEFAULT NULL,
  `ipn` varchar(255) DEFAULT NULL,
  `rec_crt_date` datetime DEFAULT NULL,
  `rec_up_date` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- --------------------------------------------------------

--
-- Table structure for table `t_users`
--

CREATE TABLE `t_users` (
  `id` int NOT NULL,
  `fname` varchar(100) NOT NULL,
  `lname` varchar(100) NOT NULL,
  `email` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `city` varchar(100) NOT NULL,
  `state` varchar(100) NOT NULL,
  `zip` varchar(20) NOT NULL,
  `country` varchar(50) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `images` varchar(255) NOT NULL,
  `status` enum('Y','N') NOT NULL DEFAULT 'N',
  `code` varchar(20) NOT NULL,
  `email_verified` enum('Y','N') NOT NULL DEFAULT 'N',
  `phone_verified` enum('Y','N') NOT NULL DEFAULT 'N',
  `ip_address` varchar(100) NOT NULL,
  `rec_crt_date` datetime NOT NULL,
  `rec_up_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `t_weeklyInvoice`
--

CREATE TABLE `t_weeklyInvoice` (
  `id` int NOT NULL,
  `startDate` date NOT NULL,
  `endDate` date NOT NULL,
  `ipn` varchar(50) NOT NULL,
  `totalUsdDue` float NOT NULL,
  `totalEurDue` float NOT NULL,
  `paid` enum('Y','N') NOT NULL DEFAULT 'N'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `t_weekly_sales`
--

CREATE TABLE `t_weekly_sales` (
  `id` int NOT NULL,
  `Company` varchar(100) NOT NULL,
  `IPN` varchar(50) NOT NULL,
  `Gateway` varchar(20) NOT NULL,
  `Amount` float NOT NULL,
  `StartDate` datetime NOT NULL,
  `EndDate` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Table structure for table `users_twitter`
--

CREATE TABLE `users_twitter` (
  `id` int NOT NULL,
  `name` varchar(255) NOT NULL,
  `twitter_id` varchar(50) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Stand-in structure for view `vw_sales`
-- (See below for the actual view)
--
CREATE TABLE `vw_sales` (
`auth_code` varchar(100)
,`chargeback` enum('Y','N')
,`client_transaction_id` varchar(200)
,`currency_type` varchar(20)
,`customer_email` varchar(255)
,`customer_name` varchar(255)
,`customer_phone` varchar(255)
,`email_verified` enum('Y','N')
,`fname` varchar(50)
,`g_type` varchar(100)
,`gatewayTransactionId` varchar(255)
,`grossPrice` decimal(10,2)
,`id` int
,`ipn_no` varchar(50)
,`order_id` varchar(100)
,`payout_verify` enum('Y','N')
,`phone_verified` enum('Y','N')
,`rec_crt_date` datetime
,`rec_up_date` datetime
,`refund` enum('Y','N')
,`refund_amount` float
,`response` varchar(255)
,`response_code` varchar(100)
,`risk` enum('Y','N')
,`status` varchar(50)
);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `Declined_31120`
--
ALTER TABLE `Declined_31120`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `gateway_login`
--
ALTER TABLE `gateway_login`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `organiztion_incident_type`
--
ALTER TABLE `organiztion_incident_type`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `process_31120`
--
ALTER TABLE `process_31120`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `response_log`
--
ALTER TABLE `response_log`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_admin_back`
--
ALTER TABLE `t_admin_back`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_auth_token`
--
ALTER TABLE `t_auth_token`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_blocked_info`
--
ALTER TABLE `t_blocked_info`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_centerdb`
--
ALTER TABLE `t_centerdb`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_country`
--
ALTER TABLE `t_country`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_currencyConversion`
--
ALTER TABLE `t_currencyConversion`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_customer`
--
ALTER TABLE `t_customer`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_custom_product`
--
ALTER TABLE `t_custom_product`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_email`
--
ALTER TABLE `t_email`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_groupCenter`
--
ALTER TABLE `t_groupCenter`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_groups`
--
ALTER TABLE `t_groups`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_incident`
--
ALTER TABLE `t_incident`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_incident_type`
--
ALTER TABLE `t_incident_type`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_invoice`
--
ALTER TABLE `t_invoice`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_ipn_login_history`
--
ALTER TABLE `t_ipn_login_history`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_kyc`
--
ALTER TABLE `t_kyc`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_logdetails`
--
ALTER TABLE `t_logdetails`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_midCenter`
--
ALTER TABLE `t_midCenter`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_mid_configuration`
--
ALTER TABLE `t_mid_configuration`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_organization`
--
ALTER TABLE `t_organization`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_organization_admin`
--
ALTER TABLE `t_organization_admin`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_password_alert_tbl`
--
ALTER TABLE `t_password_alert_tbl`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_phone`
--
ALTER TABLE `t_phone`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_product`
--
ALTER TABLE `t_product`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_queryLog`
--
ALTER TABLE `t_queryLog`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_secure_data`
--
ALTER TABLE `t_secure_data`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_state`
--
ALTER TABLE `t_state`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_systemEvents`
--
ALTER TABLE `t_systemEvents`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_systemSettings`
--
ALTER TABLE `t_systemSettings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_system_settings`
--
ALTER TABLE `t_system_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_transaction_code`
--
ALTER TABLE `t_transaction_code`
  ADD PRIMARY KEY (`transaction_code_id`);

--
-- Indexes for table `t_transaction_logs`
--
ALTER TABLE `t_transaction_logs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_txn_ipn_details`
--
ALTER TABLE `t_txn_ipn_details`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_users`
--
ALTER TABLE `t_users`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_weeklyInvoice`
--
ALTER TABLE `t_weeklyInvoice`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `t_weekly_sales`
--
ALTER TABLE `t_weekly_sales`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `users_twitter`
--
ALTER TABLE `users_twitter`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `gateway_login`
--
ALTER TABLE `gateway_login`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `organiztion_incident_type`
--
ALTER TABLE `organiztion_incident_type`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `response_log`
--
ALTER TABLE `response_log`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `t_admin_back`
--
ALTER TABLE `t_admin_back`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `t_auth_token`
--
ALTER TABLE `t_auth_token`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `t_blocked_info`
--
ALTER TABLE `t_blocked_info`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `t_centerdb`
--
ALTER TABLE `t_centerdb`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `t_country`
--
ALTER TABLE `t_country`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=889;

--
-- AUTO_INCREMENT for table `t_currencyConversion`
--
ALTER TABLE `t_currencyConversion`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `t_customer`
--
ALTER TABLE `t_customer`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `t_custom_product`
--
ALTER TABLE `t_custom_product`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `t_email`
--
ALTER TABLE `t_email`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=153;

--
-- AUTO_INCREMENT for table `t_groupCenter`
--
ALTER TABLE `t_groupCenter`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `t_groups`
--
ALTER TABLE `t_groups`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `t_incident`
--
ALTER TABLE `t_incident`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `t_incident_type`
--
ALTER TABLE `t_incident_type`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `t_invoice`
--
ALTER TABLE `t_invoice`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `t_ipn_login_history`
--
ALTER TABLE `t_ipn_login_history`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `t_kyc`
--
ALTER TABLE `t_kyc`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `t_logdetails`
--
ALTER TABLE `t_logdetails`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `t_midCenter`
--
ALTER TABLE `t_midCenter`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `t_mid_configuration`
--
ALTER TABLE `t_mid_configuration`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `t_organization`
--
ALTER TABLE `t_organization`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `t_organization_admin`
--
ALTER TABLE `t_organization_admin`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `t_password_alert_tbl`
--
ALTER TABLE `t_password_alert_tbl`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `t_phone`
--
ALTER TABLE `t_phone`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=434;

--
-- AUTO_INCREMENT for table `t_product`
--
ALTER TABLE `t_product`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `t_queryLog`
--
ALTER TABLE `t_queryLog`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `t_secure_data`
--
ALTER TABLE `t_secure_data`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `t_state`
--
ALTER TABLE `t_state`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=86;

--
-- AUTO_INCREMENT for table `t_systemEvents`
--
ALTER TABLE `t_systemEvents`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `t_systemSettings`
--
ALTER TABLE `t_systemSettings`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `t_system_settings`
--
ALTER TABLE `t_system_settings`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `t_transaction_code`
--
ALTER TABLE `t_transaction_code`
  MODIFY `transaction_code_id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `t_transaction_logs`
--
ALTER TABLE `t_transaction_logs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `t_txn_ipn_details`
--
ALTER TABLE `t_txn_ipn_details`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `t_users`
--
ALTER TABLE `t_users`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `t_weeklyInvoice`
--
ALTER TABLE `t_weeklyInvoice`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `t_weekly_sales`
--
ALTER TABLE `t_weekly_sales`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `users_twitter`
--
ALTER TABLE `users_twitter`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

-- --------------------------------------------------------

--
-- Structure for view `vw_sales`
--
COMMIT;

