/*M!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.6.23-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: lean_shop_net
-- ------------------------------------------------------
-- Server version	10.6.23-MariaDB-0ubuntu0.22.04.1

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

--
-- Table structure for table `leanps_message`
--

DROP TABLE IF EXISTS `leanps_message`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8mb4 */;
CREATE TABLE `leanps_message` (
  `id_message` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_cart` int(10) unsigned DEFAULT NULL,
  `id_customer` int(10) unsigned NOT NULL,
  `id_employee` int(10) unsigned DEFAULT NULL,
  `id_order` int(10) unsigned NOT NULL,
  `message` text NOT NULL,
  `private` tinyint(1) unsigned NOT NULL DEFAULT 1,
  `date_add` datetime NOT NULL,
  PRIMARY KEY (`id_message`),
  KEY `message_order` (`id_order`),
  KEY `id_cart` (`id_cart`),
  KEY `id_customer` (`id_customer`),
  KEY `id_employee` (`id_employee`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `leanps_message`
--

LOCK TABLES `leanps_message` WRITE;
/*!40000 ALTER TABLE `leanps_message` DISABLE KEYS */;
INSERT INTO `leanps_message` VALUES (1,0,0,0,5,'Payment accepted.',1,'2013-07-25 16:37:28'),(3,0,0,0,11,'PayPal response:TIMESTAMP -> 2013-08-02T00:53:36ZL_ERRORCODE0 -> 10411L_SHORTMESSAGE0 -> This Express Checkout session has expired.L_LONGMESSAGE0 -> This Express Checkout session has expired.  Token value is no longer valid.L_SEVERITYCODE0 -> Error',1,'2013-08-02 02:53:35'),(4,0,0,0,12,'PayPal response:TIMESTAMP -> 2013-08-02T00:59:45ZL_ERRORCODE0 -> 10486L_SHORTMESSAGE0 -> This transaction couldn\'t be completed.L_LONGMESSAGE0 -> This transaction couldn\'t be completed. Please redirect your customer to PayPal.L_SEVERITYCODE0 -> Error',1,'2013-08-02 02:59:43'),(5,0,0,0,13,'PayPal response:TIMESTAMP -> 2013-08-27T01:10:42ZL_ERRORCODE0 -> 10411L_SHORTMESSAGE0 -> This Express Checkout session has expired.L_LONGMESSAGE0 -> This Express Checkout session has expired.  Token value is no longer valid.L_SEVERITYCODE0 -> Error',1,'2013-08-27 03:10:40'),(6,0,0,0,14,'PayPal response:TIMESTAMP -> 2013-08-27T01:18:36ZL_ERRORCODE0 -> 10486L_SHORTMESSAGE0 -> This transaction couldn\'t be completed.L_LONGMESSAGE0 -> This transaction couldn\'t be completed. Please redirect your customer to PayPal.L_SEVERITYCODE0 -> Error',1,'2013-08-27 03:18:34'),(7,0,0,0,15,'PayPal response:TIMESTAMP -> 2013-08-29T04:49:49ZL_ERRORCODE0 -> 10411L_SHORTMESSAGE0 -> This Express Checkout session has expired.L_LONGMESSAGE0 -> This Express Checkout session has expired.  Token value is no longer valid.L_SEVERITYCODE0 -> Error',1,'2013-08-29 06:49:45'),(8,0,0,0,16,'Payment accepted.',1,'2013-08-29 06:54:27'),(9,0,0,0,18,'Payment accepted.',1,'2014-01-15 10:01:48'),(10,0,0,0,20,'Payment accepted.',1,'2014-11-28 10:48:32'),(11,0,0,0,21,'Payment accepted.',1,'2015-04-30 09:02:04'),(12,0,0,0,22,'Payment accepted.',1,'2015-05-26 16:28:23'),(13,0,0,0,23,'Payment accepted.',1,'2015-07-22 21:32:32'),(14,198,0,0,24,'ordering on the page in english, I am wondering if the tool itself is english . This is what I would like: english version. Thanks in advance,',0,'2015-10-16 05:58:02'),(15,0,0,0,24,'Payment accepted.',1,'2015-10-16 06:05:12'),(16,0,0,0,25,'Payment accepted.',1,'2016-01-21 15:47:02'),(17,0,0,0,26,'Payment accepted.',1,'2016-02-16 12:00:13'),(18,0,0,0,27,'Payment accepted.',1,'2016-03-07 17:46:58'),(19,0,0,0,28,'Payment accepted.',1,'2016-03-09 11:11:43'),(20,237,7,0,29,'Payment accepted.',1,'2016-04-29 14:41:46'),(21,242,33,0,30,'Payment accepted.',1,'2016-05-09 10:06:24'),(22,256,7,0,31,'Payment accepted.',1,'2016-07-01 10:55:01'),(23,292,34,0,32,'Payment accepted.',1,'2016-10-03 16:53:26'),(24,294,30,0,33,'Payment accepted.',1,'2016-10-07 12:48:02'),(25,295,30,0,34,'Payment accepted.',1,'2016-10-31 10:30:32'),(26,297,35,0,35,'Payment accepted.',1,'2016-11-14 11:13:48'),(27,300,36,0,36,'Payment accepted.',1,'2016-11-23 15:42:05'),(28,381,38,0,38,'Payment accepted.',1,'2017-05-18 22:28:11'),(29,389,39,0,0,'I would like to have the English version.',0,'2017-05-23 10:42:59'),(30,391,41,0,0,'I would like the guideline in English',0,'2017-06-01 10:05:20'),(31,392,42,0,0,'Guideline in English',0,'2017-06-06 14:57:24'),(32,440,62,0,45,'Payment accepted.',1,'2017-09-01 10:05:22'),(33,443,62,0,46,'Payment accepted.',1,'2017-09-07 11:42:24'),(34,455,0,0,47,'NOUS AVONS BESOIN IMPERATIVEMENT D UNE FACTURE  POUR  SKF FRANCE / MR CLAEYS / 204 BLVD CHARLES DE GAULLE 37540  ST CYR SUR LOIRE ',0,'2017-11-29 09:00:02'),(35,455,63,0,47,'Payment accepted.',1,'2017-11-29 09:48:57'),(36,458,64,0,48,'Payment accepted.',1,'2017-12-08 13:56:02'),(37,467,66,0,49,'Payment accepted.',1,'2018-02-25 10:57:50'),(38,574,67,0,50,'Payment accepted.',1,'2018-11-17 11:48:42'),(39,575,67,0,51,'Payment accepted.',1,'2018-11-17 15:20:20'),(40,618,70,0,54,'Payment accepted.',1,'2019-07-11 10:52:48'),(41,650,85,0,0,'Merci de vous pr&eacute;senter au poste de garde au 129 cours berriat, 38000 Grenoble pour la livraison. ',0,'2019-10-25 14:26:38'),(42,711,103,0,67,'COMMANDE 159236',0,'2022-04-06 09:56:35'),(43,716,104,0,68,'161780',0,'2022-07-26 14:10:14');
/*!40000 ALTER TABLE `leanps_message` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

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

-- Dump completed on 2026-07-01 21:35:46
