CREATE TABLE `Payments` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`usr_id` mediumint(8) unsigned NOT NULL DEFAULT 0,
`amount` decimal(7,2) unsigned NOT NULL DEFAULT 0.00,
`status` enum('PENDING','PAID','REJECTED') NOT NULL DEFAULT 'PENDING',
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`processed` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`pay_type` varchar(32) NOT NULL DEFAULT '',
`pay_info` text NOT NULL DEFAULT '',
`currency` varchar(32) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `user` (`usr_id`),
KEY `stat` (`status`,`created`)
) ENGINE=MyISAM AUTO_INCREMENT=78 DEFAULT CHARSET=latin1;
INSERT INTO `Payments` VALUES (1,1,10.00,'REJECTED','2023-07-06 06:57:17','2023-07-28 05:14:19','PayPal','Mark Hoppus\n1234567\nUSA Bank\nCalifornia\n11111\n+1222333444555\[email protected]',''),(2,1,11.00,'REJECTED','2023-07-06 07:02:08','2023-07-28 05:14:19','PayPal','Mark Hoppus\n1234567\nUSA Bank\nCalifornia\n11111\n+1222333444555\[email protected]','INR'),(3,1,0.00,'REJECTED','2023-07-17 14:34:51','2023-07-28 05:14:19','PayPal','Mark Hoppus\n1234567\nUSA Bank\nCalifornia\n11111\n+1222333444555\[email protected]','INR'),(4,1,10.00,'REJECTED','2023-07-19 04:33:59','2023-07-28 05:14:19','PayPal','Mark Hoppus\n1234567\nUSA Bank\nCalifornia\n11111\n+1222333444555\[email protected]','INR'),(5,1,0.00,'REJECTED','2023-07-27 19:02:39','2023-07-28 05:14:19','','test\ntest\ntest\ntest\ntest\ntest\ntest',''),(6,1,0.00,'REJECTED','2023-07-27 19:08:04','2023-07-28 05:14:19','','test\ntest\ntest\ntest\ntest\ntest\ntest',''),(7,1,0.00,'REJECTED','2023-07-28 04:57:42','2023-07-28 05:14:19','','Atom\n111\n222\n333\n111\n111\n111','inr'),(8,1,0.00,'REJECTED','2023-07-28 04:59:43','2023-07-28 05:14:19','','Atom\n111\n222\n333\n444\n555\[email protected]',''),(9,1,0.00,'REJECTED','2023-07-28 04:59:52','2023-07-28 05:14:19','','Atom\n111\n222\n333\n444\n555\[email protected]',''),(10,1,0.00,'REJECTED','2023-07-28 05:07:02','2023-07-28 05:14:19','','Atom\n111\n222\n333\n444\n555\[email protected]',''),(11,1,20.00,'REJECTED','2023-07-28 05:21:40','2023-07-28 05:25:00','','',''),(12,1,12.00,'REJECTED','2023-07-28 05:25:03','2023-07-28 05:25:38','','Atom\n111\n222\n333\n444\n555\[email protected]\nPalm ave',''),(13,1,11.00,'REJECTED','2023-07-28 05:33:19','2023-07-28 06:07:39','','Atom\n111\n222\n333\n444\n+155555\[email protected]\nPalm ave','inr'),(14,1,13.00,'REJECTED','2023-07-28 19:24:03','2023-07-28 19:25:05','','Atom\n111\n222\n333\n444\n+155555\[email protected]\nPalm ave','inr'),(15,1,11.00,'REJECTED','2023-07-28 19:25:53','2023-08-19 19:40:25','','Atom','usd'),(16,1,10.00,'REJECTED','2023-08-19 19:40:29','2023-08-19 19:41:53','','atom1','usd'),(17,1,10.00,'REJECTED','2023-08-19 19:42:22','2023-08-19 19:49:23','','test1','usd'),(18,1,10.00,'REJECTED','2023-08-19 19:49:29','2023-08-19 19:53:31','','test','usd'),(19,1,10.03,'REJECTED','2023-08-25 12:45:52','2023-09-06 06:38:51','','test\n\ntest\ntest\ntest\ntest\[email protected]\ntest','inr'),(20,13,7.00,'PAID','2023-08-27 07:19:52','2023-09-05 09:23:42','','Rizvana\n\nKotak Mahendra Bank\nKotak Mahendra bank \nKKBK0005298\n7007806378\[email protected]\nKotak Mahendra Bank Jhansi','inr'),(21,15,11.68,'PAID','2023-09-01 14:31:52','2023-09-01 18:29:02','','Shivam\n\nPAYTM PAYMENTS BANK\nNnn\nPYTM0123456\n8198051466\[email protected]\nPAYTM PAYMENTS BANK NEW DELHI','inr'),(22,17,8.39,'PAID','2023-09-01 14:57:21','2023-09-02 12:26:38','','Sarabjeet Singh \n\nPaytm Bank\nPaytm bank\nPYTM0123456\n8620018800\[email protected]\nPaytm bank','inr'),(23,60,150.76,'PAID','2023-09-03 18:26:11','2023-09-05 12:31:42','','Sample \n\nAsee\nYtresf\n12345677\n1234567890\[email protected]\nAsertyh','inr'),(24,17,10.24,'PAID','2023-09-04 06:15:36','2023-09-04 18:16:10','','Sarabjeet Singh \n\nPaytm Bank\nPaytm bank\nPYTM0123456\n8620018800\[email protected]\nPaytm bank','inr'),(25,15,11.14,'PAID','2023-09-04 06:29:04','2023-09-04 18:16:10','','Shivam\n\nPAYTM PAYMENTS BANK\nNnn\nPYTM0123456\n8198051466\[email protected]\nPAYTM PAYMENTS BANK NEW DELHI','inr'),(26,116,4.66,'PAID','2023-09-04 10:58:56','2023-09-04 18:16:10','','Shivam\n\nPaytm\nNn\nPAYTM0123456\n8198051466\[email protected]\nNn','inr'),(29,130,3.10,'PAID','2023-09-05 13:43:24','2023-09-07 22:11:44','','Durvesh Kumar Maurya \n\nPunjab & Sind Bank \nUadaikarnpur\nPSIB0000580\n 89231 64307\[email protected]\nPuranpur ','inr'),(28,13,32.19,'PAID','2023-09-05 09:24:22','2023-09-13 07:51:07','','Rizvana\n\nKotak Mahendra Bank\nKotak Mahendra bank \nKKBK0005298\n7007806378\[email protected]\nKotak Mahendra Bank Jhansi','inr'),(30,17,3.54,'PAID','2023-09-05 15:39:01','2023-09-05 17:40:44','','Sarabjeet Singh \n\nPaytm Bank\nPaytm bank\nPYTM0123456\n8620018800\[email protected]\nPaytm bank','inr'),(31,15,3.36,'PAID','2023-09-05 15:40:16','2023-09-05 17:40:44','','Shivam\n\nPAYTM PAYMENTS BANK\nNnn\nPYTM0123456\n8198051466\[email protected]\nPAYTM PAYMENTS BANK NEW DELHI','inr'),(32,60,94.81,'PAID','2023-09-05 19:11:04','2023-09-06 05:10:59','','Sample \n\nAsee\nYtresf\n12345677\n1234567890\[email protected]\nAsertyh','inr'),(33,1,10.00,'REJECTED','2023-09-06 06:39:03','2023-10-30 14:15:37','','test\ntest\ntest\ntest\ntest\ntest\[email protected]\ntest','inr'),(34,60,28.82,'PAID','2023-09-06 18:54:23','2023-09-07 14:57:20','','Sample \n14325777\nAsee\nYtresf\n12345677\n1234567890\[email protected]\nAsertyh','inr'),(35,60,32.56,'PAID','2023-09-07 18:27:03','2023-09-08 16:07:25','','Sample \n14325777\nAsee\nYtresf\n12345677\n1234567890\[email protected]\nAsertyh','inr'),(36,60,36.99,'PAID','2023-09-08 18:28:33','2023-09-14 06:41:05','','Sample \n14325777\nAsee\nYtresf\n12345677\n1234567890\[email protected]\nAsertyh','inr'),(37,15,2.37,'PAID','2023-09-10 16:30:41','2023-09-21 14:08:58','','Shivam\n918198051466\nPAYTM PAYMENTS BANK\nNnn\nPYTM0123456\n8198051466\[email protected]\nPAYTM PAYMENTS BANK NEW DELHI','inr'),(38,17,8.55,'PAID','2023-09-10 16:31:01','2023-09-14 06:41:05','','Sarabjeet Singh \n917837800706\nPaytm Bank\nPaytm bank\nPYTM0123456\n8620018800\[email protected]\nPaytm bank','inr'),(39,131,395.40,'PAID','2023-09-12 18:17:43','2023-09-21 14:13:54','','Dhayanithi\n41323634301\nSBI\nSbi\nSBIN0000937\n0000000000\[email protected]\nIndia ','inr'),(40,13,4.66,'PAID','2023-09-13 07:51:34','2023-10-30 15:51:49','','Rizvana\n8313545119\nKotak Mahendra Bank\nKotak Mahendra bank \nKKBK0005298\n7007806378\[email protected]\nKotak Mahendra Bank Jhansi','inr'),(41,60,170.99,'PAID','2023-09-14 18:37:01','2023-09-30 07:10:16','','Sample \n14325777\nAsee\nYtresf\n12345677\n1234567890\[email protected]\nAsertyh','inr'),(42,226,2.23,'PAID','2023-09-16 10:44:21','2023-09-21 14:15:17','','KAVITHAMANI N\n32354895456\nSTATE BANK OF INDIA\nKAVINDAPADI\nSBIN0015329\n9976207160\[email protected]\n155 A, Sathy Main Road , Kavindapadi','inr'),(43,131,265.04,'PAID','2023-09-21 15:14:30','2023-09-30 07:10:16','','Dhayanithi\n41323634301\nSBI\nSbi\nSBIN0000937\n0000000000\[email protected]\nIndia ','inr'),(44,134,165.17,'PAID','2023-09-22 15:42:29','2023-09-30 07:12:37','','SELVAM G\n6171622592\nINDIAN BANK \nIndian Bank \nIDIB000P068\n7777755555\[email protected]\nTamilnadu ','inr'),(45,226,3.41,'PAID','2023-09-22 16:32:17','2023-09-30 07:13:48','','KAVITHAMANI N\n32354895456\nSTATE BANK OF INDIA\nKAVINDAPADI\nSBIN0015329\n9976207160\[email protected]\n155 A, Sathy Main Road , Kavindapadi','inr'),(46,60,394.16,'PAID','2023-09-30 07:23:48','2023-10-10 13:01:15','','Sample \n14325777\nAsee\nYtresf\n12345677\n1234567890\[email protected]\nAsertyh','inr'),(47,226,3.08,'PAID','2023-10-02 12:50:22','2023-10-30 15:51:49','','KAVITHAMANI N\n32354895456\nSTATE BANK OF INDIA\nKAVINDAPADI\nSBIN0015329\n9976207160\[email protected]\n155 A, Sathy Main Road , Kavindapadi','inr'),(48,311,9.35,'PAID','2023-10-02 20:41:01','2023-10-30 15:51:49','','GURUSAMY D\n286301000004834\nIndian Overseas Bank\nNGO Colony\nIOBA0002863\n9944123362\[email protected]\nTirunelveli','inr'),(49,131,250.76,'PAID','2023-10-05 14:02:11','2023-10-17 13:48:42','','Dhayanithi\n41323634301\nSBI\nSbi\nSBIN0000937\n0000000000\[email protected]\nIndia ','inr'),(50,157,3.26,'PAID','2023-10-10 23:11:51','2023-10-30 15:51:49','','navjot singh\n41459530156\nSbi\nSbi\nSBIN0050065\n+91 78142 64762\[email protected] \nKapurthala ','inr'),(51,60,325.20,'PAID','2023-10-12 02:05:23','2023-10-27 19:55:55','','Sample \n14325777\nAsee\nYtresf\n12345677\n1234567890\[email protected]\nAsertyh','inr'),(52,347,2.01,'PAID','2023-10-14 03:43:40','2023-10-30 15:51:49','','Kalidoss panneerselvam\n6863977377\nIndian Bank\nAlangudi \nIDIB000A219\n7826822154\[email protected]\nAlangudi ','inr'),(53,134,229.36,'PAID','2023-10-15 07:57:02','2023-10-17 13:54:44','','SELVAM G\n6171622592\nINDIAN BANK \nIndian Bank \nIDIB000P068\n7777755555\[email protected]\nTamilnadu ','inr'),(54,364,2.04,'PAID','2023-10-16 04:03:06','2023-10-30 15:51:49','','Suresh \n159788819792\nIndusind\nVelachery \nINDB0000606\n9788819792\[email protected] \nVelachery, Chennai ','inr'),(55,234,7.48,'PAID','2023-10-17 02:56:59','2023-10-30 15:51:49','','RAMESH NAGAPPAN\n41705203664\nSTATE BANK INDIA\nKavindapadi\nSBIN0015329\n8072899930\[email protected]\n155 A, Sathy Road','inr'),(56,131,382.59,'PAID','2023-10-17 13:50:16','2023-10-30 15:51:49','','Dhayanithi\n41323634301\nSBI\nSbi\nSBIN0000937\n0000000000\[email protected]\nIndia ','inr'),(57,134,128.18,'PAID','2023-10-23 06:40:18','2023-10-30 15:51:49','','SELVAM G\n6171622592\nINDIAN BANK \nIndian Bank \nIDIB000P068\n7777755555\[email protected]\nTamilnadu ','inr'),(58,274,856.14,'PAID','2023-10-25 07:28:54','2023-12-13 18:26:30','','Dhayanithi\n6171720101\nIndian Bank\nIndian Bank\nIDIB000P068\n8111111111\[email protected]\nChennai','inr'),(59,275,658.48,'PAID','2023-10-25 08:41:00','2023-11-25 14:45:20','','G LATHA\n42380035899\nState Bank \nAgri comm branch thiruvalluvar \nSBIN0001844\n7094303466\[email protected]\n173 jn road Thiruvalluvar ','inr'),(60,60,681.67,'PAID','2023-10-28 04:54:27','2023-11-18 13:15:01','','Sample \n14325777\nAsee\nYtresf\n12345677\n1234567890\[email protected]\nAsertyh','inr'),(61,364,8.92,'PENDING','2023-10-30 16:21:52','0000-00-00 00:00:00','','Suresh \n159788819792\nIndusind\nVelachery \nINDB0000606\n9788819792\[email protected] \nVelachery, Chennai ','inr'),(62,347,2.72,'PENDING','2023-10-31 04:25:58','0000-00-00 00:00:00','','Kalidoss panneerselvam\n6863977377\nIndian Bank\nAlangudi \nIDIB000A219\n7826822154\[email protected]\nAlangudi ','inr'),(63,226,20.21,'PENDING','2023-10-31 07:47:58','0000-00-00 00:00:00','','KAVITHAMANI N\n32354895456\nSTATE BANK OF INDIA\nKAVINDAPADI\nSBIN0015329\n9976207160\[email protected]\n155 A, Sathy Main Road , Kavindapadi','inr'),(64,134,153.04,'PAID','2023-11-02 06:24:27','2023-12-13 18:26:30','','SELVAM G\n6171622592\nINDIAN BANK \nIndian Bank \nIDIB000P068\n7777755555\[email protected]\nTamilnadu ','inr'),(65,131,500.55,'PAID','2023-11-02 11:06:23','2023-12-13 18:26:30','','Dhayanithi\n41323634301\nSBI\nSbi\nSBIN0000937\n0000000000\[email protected]\nIndia ','inr'),(66,311,63.60,'PENDING','2023-11-02 17:14:11','0000-00-00 00:00:00','','GURUSAMY D\n286301000004834\nIndian Overseas Bank\nNGO Colony\nIOBA0002863\n9944123362\[email protected]\nTirunelveli','inr'),(67,315,18.03,'PENDING','2023-11-12 18:12:25','0000-00-00 00:00:00','','SUMAN D\n286301000004904\nIndian Overseas Bank \nN G O Colony\nIOBA0002863\n8695250913\[email protected]\nNGO Colony, Tirunelveli ','inr'),(68,60,670.38,'PAID','2023-11-18 13:17:26','2023-12-13 18:26:30','','Sample \n14325777\nAsee\nYtresf\n12345677\n1234567890\[email protected]\nAsertyh','inr'),(69,404,2.03,'PAID','2023-11-30 11:53:05','2023-12-30 15:23:23','','Vimal Saravanan\n50100581242061\nHDFC Bank\nMumbai - Sandoz House\nHDFC0000240\n8668199073\[email protected]\nSandoz House, Dr. A.b.roadworlimumbaimaharashtra 400 018','inr'),(70,275,331.14,'PAID','2023-11-30 18:27:55','2023-12-27 08:04:40','','G LATHA\n42380035899\nState Bank \nAgri comm branch thiruvalluvar \nSBIN0001844\n7094303466\[email protected]\n173 jn road Thiruvalluvar ','inr'),(71,60,212.66,'PAID','2023-12-13 18:55:53','2023-12-21 06:01:45','','Sample \n14325777\nAsee\nYtresf\n12345677\n1234567890\[email protected]\nAsertyh','inr'),(72,134,250.08,'PAID','2023-12-14 01:59:31','2023-12-30 11:34:03','','SELVAM G\n6171622592\nINDIAN BANK \nIndian Bank \nIDIB000P068\n7777755555\[email protected]\nTamilnadu ','inr'),(73,274,876.62,'PAID','2023-12-16 18:02:51','2023-12-30 11:34:03','','Dhayanithi\n6171720101\nIndian Bank\nIndian Bank\nIDIB000P068\n8111111111\[email protected]\nChennai','inr'),(74,131,625.21,'PAID','2023-12-19 03:37:13','2024-01-01 10:54:32','','Dhayanithi\n41323634301\nSBI\nSbi\nSBIN0000937\n0000000000\[email protected]\nIndia ','inr'),(75,60,314.23,'PAID','2023-12-23 06:07:05','2023-12-28 09:48:29','','Sample \n14325777\nAsee\nYtresf\n12345677\n1234567890\[email protected]\nAsertyh','inr'),(76,275,251.69,'PENDING','2023-12-30 14:51:53','0000-00-00 00:00:00','','G LATHA\n42380035899\nState Bank \nAgri comm branch thiruvalluvar \nSBIN0001844\n7094303466\[email protected]\n173 jn road Thiruvalluvar ','inr'),(77,404,6.54,'PENDING','2023-12-30 15:23:38','0000-00-00 00:00:00','','Vimal Saravanan\n50100581242061\nHDFC Bank\nMumbai - Sandoz House\nHDFC0000240\n8668199073\[email protected]\nSandoz House, Dr. A.b.roadworlimumbaimaharashtra 400 018','inr');