-- MariaDB dump 10.19  Distrib 10.5.19-MariaDB, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: commerce
-- ------------------------------------------------------
-- Server version	10.5.19-MariaDB-0+deb11u2

/*!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 `tbl_music`
--

DROP TABLE IF EXISTS `tbl_music`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_music` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `annee` char(10) NOT NULL,
  `country` varchar(150) NOT NULL,
  `artists` varchar(255) NOT NULL,
  `album` varchar(255) NOT NULL,
  `poster` varchar(255) DEFAULT NULL,
  `brand` char(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=128 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_music`
--

LOCK TABLES `tbl_music` WRITE;
/*!40000 ALTER TABLE `tbl_music` DISABLE KEYS */;
INSERT INTO `tbl_music` VALUES (1,'','Italy','Bill','mp4/11-italy.mp4','mp4/11-italy.png','1'),(3,'','Suisse','Bill','mp4/22-suisse.mp4','mp4/22-suisse.png','1'),(5,'','Suisse','Bill','mp4/33-suisse.mp4','mp4/33-suisse.png','1'),(7,'','Suisse','Bill','mp4/44-ski.mp4','mp4/44-ski.png','1'),(17,'','USA','Jeannet Jackson','mp4/130.mp4','mp4/130.jpg','3'),(18,'','France','Cars Futur','mp4/140.mp4','mp4/140.jpg','1'),(19,'','France','Golf','mp4/150.mp4','mp4/150.jpg','8'),(20,'','UK','Dark Punk','mp4/160.mp4','mp4/160.jpg','2'),(21,'','UK','Georges Mickel','mp4/170.mp4','mp4/170.jpg','1'),(22,'','UK','Georges Mickel','mp4/180.mp4','mp4/180.jpg','1'),(23,'','France','Johnny Halliday','mp4/190.mp4','mp4/190.png','1'),(24,'','UK','George Mac Crae','mp4/200.mp4','mp4/200.png','1'),(25,'','Italy','Gianna Gianini','mp4/210.mp4','mp4/210.png','1'),(26,'','USA','James Brown','mp4/220.mp4','mp4/220.png','1'),(27,'','France','MSC-Boat','mp4/230.mp4','mp4/230.png','8'),(28,'','France','MSC-Boat','mp4/240.mp4','mp4/240.png','8'),(124,'','Italy','Ricchi-e-Poveri','mp4/Cosa sei - Ricchi e Poveri.mp4','mp4/1000.jpg','1'),(125,'','Italy','Ricchi-e-Poveri','mp4/Cosa Sei Ricchi e Poveri (Jennifer Lopez).mp4','mp4/1001.jpg','1'),(126,'','Italy','Ricchi-e-Poveri','mp4/Ricchi-e-Poveri.mp4','mp4/1002.jpg','1'),(127,'','Italy','Ricchi-e-Poveri','mp4/Ricchi e Poveri - Come Vorrei (?Malena?-Monica Bellucci).mp4','mp4/1003.jpg','1');
/*!40000 ALTER TABLE `tbl_music` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tbl_movie`
--

DROP TABLE IF EXISTS `tbl_movie`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tbl_movie` (
  `id` tinyint(5) NOT NULL AUTO_INCREMENT,
  `annee` char(10) NOT NULL,
  `country` varchar(150) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `artists` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `album` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `poster` varchar(255) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL,
  `brand` char(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tbl_movie`
--

LOCK TABLES `tbl_movie` WRITE;
/*!40000 ALTER TABLE `tbl_movie` DISABLE KEYS */;
INSERT INTO `tbl_movie` VALUES (2,'','UK','James Bond','mp4/22.mp4','mp4/22.jpg','4'),(4,'','UK','James Bond','mp4/33.mp4','mp4/33.jpg','3'),(6,'','UK','James Bond','mp4/44.mp4','mp4/44.jpg','4'),(8,'','UK','James Bond','mp4/55.mp4','mp4/55.jpg','4'),(9,'','UK','James Bond','mp4/66.mp4','mp4/66.jpg','4'),(10,'','UK','James Bond','mp4/77.mp4','mp4/77.jpg','4'),(11,'','UK','James Bond','mp4/88.mp4','mp4/88.jpg','4'),(12,'','UK','James Bond','mp4/99.mp4','mp4/99.jpg','4'),(13,'','UK','James Bond','mp4/100.mp4','mp4/100.jpg','4'),(14,'','UK','James Bond','mp4/110.mp4','mp4/110.jpg','4'),(16,'','UK','James Bond','mp4/120.mp4','mp4/120.jpg','4'),(29,'','France ','Lino Ventura ','film/1-CENT MILLE DOLLARS AU SOLEIL 1964 (Lino VENTURA, Bernard BLIER, Jean-Paul BELMONDO).mp4','film/1.jpg ','5'),(30,'','USA ','Al Pacino ','film/2-DONNIE-BRASCO-Bande-Annonce-VF-1997-HD.mp4','film/2.jpg','6'),(31,'','USA ','Robert De Niro ','film/3-Donnie-Brasco-Une balance-HD.mp4','film/3.jpg','6'),(32,'','USA ','Robert De Niro ','film/4-Il Était Une Fois En Amérique-Sergio Leone _ Robert De Niro.mp4','film/4.jpg ','6'),(33,'','France ','Luis DE Funes ','film/5-AILE-OU-LA-CUISSE-1976-Louis-DE-FUNÈS-COLUCHE-Raymond -BUSSIÈRES.mp4','film/5.jpg ','5'),(34,'','France ','Alain Delon ','film/6-LE CLAN DES SICILIENS 1969 Jean GABIN, Alain DELON, Lino VENTURA.mp4','film/6.jpg','5'),(35,'','France ','Jean-Paul Belmondo ','film/7-Le Marginale-Belmondo.mp4','film/7.jpg','5'),(36,'','France ','Jean-Paul Belmondo ','film/8-LE-MARGINAL-Extrait-Alors-Georges-mon steak-Jean-Paul-Belmondo.mp4','film/8.jpg','5'),(37,'','France ','Jean Gabin ','film/9-LE PACHA 1968 Jean GABIN, Robert DALBAN, Serge GAINSBOURG, Dany CARREL.mp4','film/9.jpg','5'),(38,'','France ','Jean-Paul Belmondo','film/10-Le-Professionnel.mp4','film/10.jpg ','5'),(39,'','France ','Jean-Paul Belmondo ','film/11-Le professionnel-1981-Trailer.mp4','film/11.jpg','5'),(40,'','USA ','Robert De Niro ','film/12-Les Affranchis-Bande Officielle VF - Robert De Niro _ Ray Liotta _ Martin Scorsese.mp4','film/12.jpg','6'),(41,'','France ','Lino Ventura ','film/13-UN-TAXI-POUR-TOBROUK-1961-Lino-VENTURA,Charles-AZNAVOUR,Maurice-BIRAUD.mp4','film/13.jpg ','5');
/*!40000 ALTER TABLE `tbl_movie` 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 2023-09-08 15:55:24
