--
-- Host: localhost    Database: lean_shop_net
-- ------------------------------------------------------


--
-- Table structure for table `leanps_order_payment`
--

CREATE TABLE `leanps_order_payment` (
  `id_order_payment` int(11) NOT NULL AUTO_INCREMENT,
  `order_reference` varchar(9) DEFAULT NULL,
  `id_currency` int(10) unsigned NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `payment_method` varchar(255) NOT NULL,
  `conversion_rate` decimal(13,6) NOT NULL DEFAULT 1.000000,
  `transaction_id` varchar(254) DEFAULT NULL,
  `card_number` varchar(254) DEFAULT NULL,
  `card_brand` varchar(254) DEFAULT NULL,
  `card_expiration` char(7) DEFAULT NULL,
  `card_holder` varchar(254) DEFAULT NULL,
  `date_add` datetime NOT NULL,
  PRIMARY KEY (`id_order_payment`),
  KEY `order_reference` (`order_reference`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;

--
-- Dumping data for table `leanps_order_payment`
--

INSERT INTO `leanps_order_payment` VALUES (1,'000000001',1,0.00,'Chèque',1.000000,NULL,NULL,NULL,NULL,NULL,'2012-07-27 12:24:16'),(2,'000000002',1,498.99,'Virement Bancaire',1.000000,NULL,NULL,NULL,NULL,NULL,'2012-07-27 14:46:28'),(3,'TNHBSROQD',1,394.68,'PayPal',1.000000,'1MK40255XF1259945',NULL,NULL,NULL,NULL,'2013-07-25 16:37:28'),(4,'WTNTUNERK',1,0.00,'Commande gratuite',1.000000,NULL,NULL,NULL,NULL,NULL,'2013-07-31 15:32:14'),(5,'RKSSWLTTS',1,0.00,'Commande gratuite',1.000000,NULL,NULL,NULL,NULL,NULL,'2013-07-31 19:54:30'),(6,'JZUMZYWKK',1,0.00,'Commande gratuite',1.000000,NULL,NULL,NULL,NULL,NULL,'2013-07-31 20:10:40'),(7,'KODOUYVAV',1,0.00,'Commande gratuite',1.000000,NULL,NULL,NULL,NULL,NULL,'2013-07-31 20:51:00'),(8,'SUTLDAFVU',1,0.00,'Commande gratuite',1.000000,NULL,NULL,NULL,NULL,NULL,'2013-08-01 18:58:26'),(9,'RYQTQGNHX',1,353.94,'PayPal',1.000000,'5TT33326DF147735P',NULL,NULL,NULL,NULL,'2013-08-29 06:54:27'),(10,'FAYVRUTLE',1,75.35,'Chèque',1.000000,'SARL Jamespot',NULL,NULL,NULL,NULL,'2013-11-18 16:05:57'),(11,'TVOGKYSAE',1,539.25,'PayPal',1.000000,'7R6534466S365425E',NULL,NULL,NULL,NULL,'2014-01-15 10:01:48'),(12,'HQYEUVREV',1,0.00,'Commande gratuite',1.000000,NULL,NULL,NULL,NULL,NULL,'2014-09-04 14:38:31'),(13,'AMKPMQECO',1,355.10,'PayPal',1.000000,'5HK60681RM215691D','','','','','2014-11-28 10:48:31'),(14,'QVIYCQYLS',1,31.08,'PayPal',1.000000,'7N3923651Y298584U','','','','','2015-04-30 09:02:04'),(15,'HWEVBQQXE',1,355.10,'PayPal',1.000000,'8NC969499U7545216','','','','','2015-05-26 16:28:22'),(16,'ARTNVEEEL',1,250.70,'PayPal',1.000000,'8UB07831ML784000D','','','','','2015-07-22 21:32:32'),(17,'VPBILMKLY',1,645.25,'PayPal',1.000000,'78289309VN017472M','','','','','2015-10-16 06:05:12'),(18,'ZZELQCSRT',1,2808.00,'PayPal',1.000000,'6P304599YP632421N','','','','','2016-01-21 15:47:02'),(19,'QLITOOSXW',1,376.35,'PayPal',1.000000,'9N985189XG569844A','','','','','2016-02-16 12:00:13'),(20,'GYHZZHCRP',1,117.25,'PayPal',1.000000,'18F43234RB0541828','','','','','2016-03-07 17:46:58'),(21,'WANBDMYWS',1,972.00,'PayPal',1.000000,'35T708795U1042937','','','','','2016-03-09 11:11:43'),(22,'CERFTSHOM',1,0.70,'PayPal',1.000000,'8K337168PU4203843','','','','','2016-04-29 14:41:46'),(23,'FGCADGZGE',1,80.20,'PayPal',1.000000,'4DS49957522697613','','','','','2016-05-09 10:06:24'),(24,'BCKSAANTF',1,0.60,'PayPal',1.000000,'86746293TX498254W','','','','','2016-07-01 10:55:01'),(25,'FWJFDRIEE',1,80.20,'PayPal',1.000000,'4K0407833L222984A','','','','','2016-10-03 16:53:26'),(26,'FEOVQOTOF',1,1104.00,'PayPal',1.000000,'0YV673811S830803T','','','','','2016-10-07 12:48:02'),(27,'HEIRULKBV',1,1104.00,'PayPal',1.000000,'3CD39676UT503715Y','','','','','2016-10-31 10:30:32'),(28,'SSZGSDVXE',1,413.90,'PayPal',1.000000,'4MT24892CC555934S','','','','','2016-11-14 11:13:48'),(29,'QCCNQAJFI',1,653.70,'PayPal',1.000000,'04U40463KR849693G','','','','','2016-11-23 15:42:05'),(30,'ICQJIOEUB',1,357.25,'PayPal',1.000000,'67375769B3871273H','','','','','2017-05-18 22:28:11'),(31,'VKEIYQCAG',1,0.84,'PayPal',1.000000,'1DS60006SM3327114','','','','','2017-09-01 10:05:22'),(32,'HFVTYCNOV',1,0.84,'PayPal',1.000000,'1BM233026T132423P','','','','','2017-09-07 11:42:24'),(33,'PKOBYYNSQ',1,1089.84,'PayPal',1.000000,'7KE571148S343844C','','','','','2017-11-29 09:48:57'),(34,'BBASDMAOQ',1,348.84,'PayPal',1.000000,'2VJ678361J700880J','','','','','2017-12-08 13:56:02'),(35,'BTTUXUPQW',1,25.19,'PayPal',1.000000,'27H048425M1013138','','','','','2018-02-25 10:57:50'),(36,'ASWYEMCTO',1,0.84,'PayPal',1.000000,'77R35545KJ821003U','','','','','2018-11-17 11:48:42'),(37,'FPJFZXERW',1,0.42,'PayPal',1.000000,'3SF67787N9719640J','','','','','2018-11-17 15:20:20'),(38,'YAJDOYFNU',1,154.20,'PayPal',1.000000,'1HF97507ER258390X','','','','','2019-07-11 10:52:48'),(39,'KBZQJTIJS',1,1.68,'PayPal',1.000000,'6NJ80157683298330','','','','','2019-08-17 10:47:04'),(40,'JXHQPCAQC',1,0.00,'Commande gratuite',1.000000,'','','','','','2019-08-18 10:29:16'),(41,'AGFYMLHXL',1,0.00,'Commande gratuite',1.000000,'','','','','','2019-10-15 16:21:17'),(42,'JXMONNXFY',1,0.00,'Commande gratuite',1.000000,'','','','','','2019-10-16 22:06:52'),(43,'ROUZMPXUT',1,0.00,'Free order',1.000000,'','','','','','2019-10-23 00:09:39'),(44,'SLVQYIYUZ',1,56.64,'',1.000000,'','','','','','2019-12-03 10:16:07'),(45,'DXPEHROEX',1,354.00,'PayPal',1.000000,'6T411963K8019800H','','','','','2020-02-22 05:42:20'),(46,'TIFMKWVQG',1,0.00,'Commande gratuite',1.000000,'','','','','','2020-05-12 07:19:05'),(47,'EBSNLYKFO',1,119.60,'PayPal',1.000000,'51K21563ER480121S','','','','','2020-10-20 15:52:22'),(48,'JTSYBDMVQ',1,348.00,'',1.000000,'','','','','','2021-01-22 10:50:01'),(49,'LMEOYGOLU',1,361.00,'Transfert bancaire',1.000000,'','','','','','2021-04-24 19:35:08'),(50,'NUAKBTPTI',1,361.00,'PayPal',1.000000,'6US73029UT1972841','','','','','2022-04-06 09:58:05'),(51,'RRLVNGPSR',1,361.00,'PayPal',1.000000,'5G611146198589227','','','','','2022-07-26 14:10:27'),(52,'IDNDLSLOG',1,119.60,'PayPal',1.000000,'0VP740128P793464A','','','','','2023-04-11 14:20:26');


