CREATE DATABASE `bjardineria` CHARACTER SET utf8mb4;
USE `bjardineria`;
-- MySQL dump 10.13  Distrib 8.0.27, for Win64 (x86_64)
--
-- Host: localhost    Database: bjardineria
-- ------------------------------------------------------
-- Server version	8.0.27

/*!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 */;
/*!50503 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 `botiga`
--

DROP TABLE IF EXISTS `botiga`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `botiga` (
  `cod_botiga` int NOT NULL,
  `carrer` varchar(120) NOT NULL,
  `nombre` int NOT NULL,
  `poblacio` varchar(120) NOT NULL,
  `CP` varchar(5) NOT NULL,
  `telefon` int NOT NULL,
  `mail` varchar(120) NOT NULL,
  `superficie` decimal(6,2) DEFAULT NULL,
  PRIMARY KEY (`cod_botiga`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `botiga`
--

LOCK TABLES `botiga` WRITE;
/*!40000 ALTER TABLE `botiga` DISABLE KEYS */;
INSERT INTO `botiga` VALUES (1,'Pl. Nova',13,'Barcelona','8570',933504052,'[email protected]',180.24),(8,'C. Sant Antoni',4,'Barcelona','8500',933502912,'[email protected]',207.64),(12,'C. Cal Xic Corder',1,'Barcelona','8530',933509828,'[email protected]',137.24),(14,'C. Barcelona',52,'Barcelona','8640',933490828,'[email protected]',164.32),(15,'C. Josep M. Pellicer',64,'Barcelona','8350',933497060,'[email protected]',165.64),(16,'C. Montrodon',9,'Barcelona','8552',933502608,'[email protected]',171.42),(18,'C. Germà Julià',3,'Barcelona','8915',933501316,'[email protected]',185.64),(19,'Rbla. de la Pau',34,'Barcelona','8800',933507016,'[email protected]',460.72),(21,'C. Girona',225,'Barcelona','8402',933509752,'[email protected]',433.72),(23,'C. Torrentó',43,'Barcelona','8225',933498048,'[email protected]',115.10),(26,'C. Coronel Molera',12,'Barcelona','8191',933497136,'[email protected]',118.10),(28,'Av. General Moragues',2,'Barcelona','8360',933504584,'[email protected]',460.72),(30,'C. Bruguera',205,'Barcelona','8370',933504432,'[email protected]',165.42),(40,'C. Major',43,'Barcelona','8029',933500708,'[email protected]',163.64),(42,'Ctra. Girona a Palamós km 23',22,'Barcelona','8017',933497440,'[email protected]',154.32),(43,'C. Provença',335,'Barcelona','8232',933501620,'[email protected]',163.64),(44,'C. Tamarit',130,'Barcelona','8015',933508612,'[email protected]',165.24),(45,'C. Josep Coroleu',52,'Barcelona','8800',933506940,'[email protected]',123.10),(47,'C. Burgos',15,'Barcelona','8100',933508308,'[email protected]',129.02),(48,'Ctra. Tarragona',4,'Barcelona','8915',933493564,'[email protected]',155.32),(49,'C. Sant Antoni Maria Claret',264,'Barcelona','8026',933507396,'[email protected]',132.02),(50,'C. Pi i Margall',22,'Barcelona','8025',933507320,'[email protected]',433.72),(51,'Av. Catalunya',10,'Barcelona','8203',933493488,'[email protected]',152.42),(52,'C. Andrade',58,'Barcelona','8915',933501240,'[email protected]',125.02),(53,'Pl. Doctor Letamendi',36,'Barcelona','8560',933501468,'[email protected]',405.50),(56,'Av. Carrilet',139,'Barcelona','8800',933499340,'[email protected]',129.32),(58,'C. Sardenya',278,'Barcelona','8013',933508536,'[email protected]',408.50),(60,'Av. Gran Via de les Corts Catalanes',192,'Barcelona','8004',933507472,'[email protected]',192.64),(61,'C. Major',167,'Barcelona','8570',933496528,'[email protected]',157.32),(62,'C. Mallorca',651,'Barcelona','8015',933501772,'[email protected]',439.72),(63,'C. República Argentina',238,'Barcelona','8840',933501544,'[email protected]',164.24),(64,'Av. de Pau Costa',24,'Barcelona','8350',933504736,'[email protected]',201.64),(67,'C. Cap Norfeu',53,'Barcelona','8370',933496756,'[email protected]',190.64),(83,'Ctra. Barcelona',5,'Barcelona','8184',933505344,'[email protected]',162.42),(84,'C. Sant Joan Bautista de La Salle s/n',33,'Barcelona','8320',933497288,'[email protected]',141.24),(85,'Av. de Lluís Pericot',37,'Barcelona','8570',933496148,'[email protected]',138.24),(86,'C. Arquebisbe Alemany',20,'Barcelona','8500',933502684,'[email protected]',174.32),(87,'C. d\'Ausiàs Marc',23,'Barcelona','8915',933501392,'[email protected]',127.32),(88,'C. Santanyí',6,'Barcelona','8800',933499264,'[email protected]',187.64),(89,'C. Pere Lloses',9,'Barcelona','8755',933498732,'[email protected]',118.10),(90,'C. Mossén Cinto Verdaguer',2,'Barcelona','8221',933490524,'[email protected]',128.10),(91,'C. Sant Josep',44,'Barcelona','8540',933502532,'[email protected]',161.24),(93,'C. Taquígraf Serra',3,'Barcelona','8870',933499416,'[email protected]',402.50),(95,'Pl. de Josep Terradellas',0,'Barcelona','8302',933496984,'[email protected]',166.24),(96,'C. Sicília',370,'Barcelona','8012',933499492,'[email protected]',163.24),(97,'C. Doctor Santponç',125,'Barcelona','8042',933500404,'[email protected]',188.64),(98,'Ctra. de Castelló',1,'Barcelona','8225',933497896,'[email protected]',163.24),(100,'C. Verdi',105,'Barcelona','8012',933507168,'[email protected]',156.42),(101,'C. Jordi de Sant Jordi',1,'Barcelona','8027',933507776,'[email protected]',167.64),(102,'C. Riera de la Torderola',0,'Barcelona','8500',933495236,'[email protected]',141.24),(103,'C. Pompeu Fabra',2,'Barcelona','8755',933495160,'[email protected]',445.72),(104,'Ctra. GI-552 km 16',35,'Barcelona','8640',933498504,'[email protected]',411.50),(105,'C. Xaloc',1,'Barcelona','8500',933495312,'[email protected]',151.42),(106,'Av. Lluís Companys',13,'Barcelona','8540',933494856,'[email protected]',411.50),(107,'C. Del Pont cant. C. Canal',77,'Barcelona','8031',933501088,'[email protected]',152.32),(109,'Pg. de la Font del Ferro',61,'Barcelona','8640',933498428,'[email protected]',132.32),(111,'Av. de Balàfia',6,'Barcelona','8030',933494324,'[email protected]',139.24),(112,'C. Ciutat d\'Elx',23,'Barcelona','8027',933507244,'[email protected]',159.32),(113,'C. Closa d\'en Llop',80,'Barcelona','8500',933495008,'[email protected]',165.64),(114,'C. Capità Arenas',58,'Barcelona','8034',933507928,'[email protected]',451.72),(116,'C. Moragas',122,'Barcelona','8293',933498656,'[email protected]',165.64),(117,'Av. Doctor Vilaseca',6,'Barcelona','8027',933492424,'[email protected]',457.72),(118,'C. Santa Eugènia',66,'Barcelona','8570',933496376,'[email protected]',144.24),(119,'Pl. de Joan Tutau Vergés cant. C.Llançà',0,'Barcelona','8221',933498200,'[email protected]',138.24),(120,'Av. del Castell',39,'Barcelona','8570',933504204,'[email protected]',132.10),(121,'Rbla. Marquesa Castellbell',4,'Barcelona','8784',933490600,'[email protected]',475.72),(122,'C. Pere de Lluna',40,'Barcelona','8100',933492804,'[email protected]',131.02),(123,'C. Casals dels Mogoda',40,'Barcelona','8184',933489992,'[email protected]',457.72),(124,'C. Hispano Suiza',1,'Barcelona','8031',933493412,'[email protected]',142.24),(125,'C. Mare de Déu dels Munts',0,'Barcelona','8500',933502304,'[email protected]',127.32),(126,'C. Moratin',38,'Barcelona','8755',933491132,'[email protected]',139.32),(127,'C. de Santa Anna',16,'Barcelona','8784',933490676,'[email protected]',151.24),(128,'Av. Miquel Martí i Pol',0,'Barcelona','8510',933503748,'[email protected]',144.02),(129,'Rbla. Sant Jordi',69,'Barcelona','8100',933500480,'[email protected]',130.32),(130,'Plaça de la Llibertat',0,'Barcelona','8012',933508004,'[email protected]',143.24),(131,'Pl. de Cuba',0,'Barcelona','8302',933504660,'[email protected]',141.02),(132,'Ctra. N-II',555,'Barcelona','8490',933504356,'[email protected]',155.24),(133,'C. Joan Maragall',0,'Barcelona','8012',933500328,'[email protected]',128.02),(134,'Av. Barcelona',0,'Barcelona','8021',933492348,'[email protected]',122.10),(135,'Av. Generalitat',0,'Barcelona','8025',933491968,'[email protected]',194.64),(137,'C. Sant Isidre',200,'Barcelona','8570',933488700,'[email protected]',134.10),(139,'Av. Catalunya',1,'Barcelona','8191',933497212,'[email protected]',445.72),(142,'Ctra. de Manresa',0,'Barcelona','8186',933490068,'[email protected]',140.02),(143,'C. Barcelona',81,'Barcelona','8034',933492576,'[email protected]',155.42),(144,'Av. Catalunya',81,'Barcelona','8519',933494552,'[email protected]',412.72),(145,'C. Barraquer',10,'Barcelona','8720',933496832,'[email protected]',132.32),(146,'C. Sant Gaudenci',3,'Barcelona','8870',933507092,'[email protected]',146.24),(147,'C. dels Tallers',34,'Barcelona','8290',933492272,'[email protected]',169.64),(148,'C. Barcelona',13,'Barcelona','8450',933490144,'[email protected]',200.64),(149,'C. Migdia',104,'Barcelona','8570',933496604,'[email protected]',427.72),(150,'Pl. Generalitat',1,'Barcelona','8912',933501012,'[email protected]',149.42),(151,'Av. Josep Tarradellas',45,'Barcelona','8029',933508384,'[email protected]',189.64),(152,'C. Independència',313,'Barcelona','8013',933507852,'[email protected]',120.10),(153,'C. Provença',185,'Barcelona','8700',933501848,'[email protected]',139.24),(154,'C. Mossèn Jacint Verdaguer',35,'Barcelona','8640',933506180,'[email protected]',149.24),(156,'Av. Centenari Amadeu Vives',2,'Barcelona','8293',933506332,'[email protected]',162.32),(157,'C. Canigó',48,'Barcelona','8031',933508764,'[email protected]',117.10),(158,'Av. Sant Ignasi de Loiola',10,'Barcelona','8912',933508688,'[email protected]',164.64),(159,'Av. Catalunya',82,'Barcelona','8700',933494248,'[email protected]',439.72),(160,'C. Comte d\'Urgell',31,'Barcelona','8015',933509448,'[email protected]',399.50),(162,'C. de Narcís Oller',2,'Barcelona','8508',933503672,'[email protected]',469.72),(163,'C. Llull',200,'Barcelona','8720',933491512,'[email protected]',466.72),(164,'Av. Sant Antoni Maria Claret',75,'Barcelona','8720',933491436,'[email protected]',125.10),(165,'C. Aurora Bertrana',12,'Barcelona','8755',933491056,'[email protected]',197.64),(166,'C. Portal Nou',37,'Barcelona','8221',933505876,'[email protected]',174.24),(167,'C. Bori i Fontestà',23,'Barcelona','8021',933507700,'[email protected]',168.24),(168,'C. Sant Ramon',259,'Barcelona','8290',933507624,'[email protected]',417.50),(169,'Av. de Catalunya',0,'Barcelona','8401',933501696,'[email protected]',116.10),(170,'Av. Gran Via Carles III',59,'Barcelona','8004',933499796,'[email protected]',138.24),(171,'C. Dublin',6,'Barcelona','8030',933509676,'[email protected]',114.10),(173,'Ctra. De Terrassa a Olesa de Montserrat',0,'Barcelona','8232',933509296,'[email protected]',186.64),(174,'C. Vallforners',34,'Barcelona','8410',933503596,'[email protected]',171.32),(175,'C. Jaume Balmes',0,'Barcelona','8272',933505040,'[email protected]',176.64),(176,'C. d.Alfons I',0,'Barcelona','8459',933508460,'[email protected]',131.32),(177,'C. de Caldes de Montbui',142,'Barcelona','8186',933505420,'[email protected]',165.32),(178,'C. Riu Besòs',223,'Barcelona','8013',933493184,'[email protected]',166.64),(180,'C. Major',212,'Barcelona','8100',933492956,'[email protected]',133.32),(181,'C. Flos Calcat ',2,'Barcelona','8320',933504964,'[email protected]',177.24),(182,'C. Tres d\'Abril',22,'Barcelona','8030',933502000,'[email protected]',152.32),(184,'C. Enric Granados',2,'Barcelona','8700',933494172,'[email protected]',116.10),(185,'C. Martirià',174,'Barcelona','8650',933495692,'[email protected]',129.32),(187,'Av. Catalunya',0,'Barcelona','43530',933509980,'[email protected]',150.32),(188,'C. Camí Ral',523,'Barcelona','8203',933501164,'[email protected]',412.72),(189,'Pg. del Ferrocarril',323,'Barcelona','8174',933495540,'[email protected]',127.02),(190,'Av. del Mil·lenari',21,'Barcelona','8034',933500252,'[email protected]',421.72),(192,'C. Francesc Macià',1,'Barcelona','8840',933509220,'[email protected]',126.02),(194,'Ctra. de Matadepera',60,'Barcelona','8720',933499112,'[email protected]',418.72),(196,'C. Balmes',2,'Barcelona','8650',933503368,'[email protected]',496.72),(197,'C. de l´Alzina del Mas',15,'Barcelona','8459',933493108,'[email protected]',167.24),(199,'Av. Pau Casals',255,'Barcelona','8450',933505496,'[email protected]',451.72),(203,'Av. d\' Espanya',0,'Barcelona','8272',933497364,'[email protected]',151.42),(204,'Pg. Valldaura',148,'Barcelona','8042',933508080,'[email protected]',153.42),(207,'Pg. Generalitat',44,'Barcelona','8500',933502380,'[email protected]',138.10),(208,'Pg. Sant Joan',218,'Barcelona','8560',933503444,'[email protected]',158.24),(210,'C. Buenaventura Muñoz',62,'Barcelona','8510',933488396,'[email protected]',148.32),(211,'C. Padilla',0,'Barcelona','8017',933505116,'[email protected]',129.10),(502,'Ctra. C-17 km 55',33,'Barcelona','8519',933502228,'[email protected]',185.64),(503,'Ctra. Barcelona 115-117',44,'Barcelona','8720',933506560,'[email protected]',195.64),(504,'Ctra. de Manlleu a Torelló',5,'Barcelona','8293',933490980,'[email protected]',137.02),(525,'C. de Ripoll',1,'Barcelona','8500',933503064,'[email protected]',462.50),(528,'Pg. Sant Joan',240,'Barcelona','8560',933503976,'[email protected]',453.50),(536,'C. dels Telers',116,'Barcelona','8560',933496300,'[email protected]',151.32),(555,'C. Lluís Companys',14,'Barcelona','8470',933489840,'[email protected]',164.42),(562,'Av. Josep Tarradellas',2,'Barcelona','8225',933505572,'[email protected]',138.02),(563,'Ctra. Santa Coloma',106,'Barcelona','8302',933489308,'[email protected]',145.32),(572,'Av. Can Campanyà',1,'Barcelona','8755',933502760,'[email protected]',478.72),(577,'Via Augusta',103,'Barcelona','8174',933503292,'[email protected]',135.10),(578,'Av. Mestre Muntaner cant. C. Lleida',120,'Barcelona','8700',933509600,'[email protected]',161.64),(585,'Ctra. Ctra. de Molins de Rei',69,'Barcelona','8508',933488320,'[email protected]',206.64),(587,'C. del Conflent',0,'Barcelona','8915',933508916,'[email protected]',140.24),(1001,'Ctra. Barcelona',115,'Barcelona','8720',933506636,'[email protected]',137.32),(1002,'Ctra. C-17 km 55',55,'Barcelona','8402',933502076,'[email protected]',412.72),(1004,'C. Manlleu',117,'Barcelona','8570',933504280,'[email protected]',487.72),(1005,'Ctra. Girona',219,'Barcelona','8370',933489080,'[email protected]',466.72),(1006,'C. Artesans',80,'Barcelona','8015',933493260,'[email protected]',119.10),(1007,'Ctra. N-340 km 1145',23,'Barcelona','8570',933488776,'[email protected]',493.72),(1009,'C. Nicaragua',0,'Barcelona','8100',933508232,'[email protected]',424.72),(1010,'Av. Lluís companys s/n',88,'Barcelona','8026',933499720,'[email protected]',436.72),(1011,'Av. Països Catalans',2,'Barcelona','8784',933498352,'[email protected]',151.32),(1019,'C. Freixenet',46,'Barcelona','8225',933497972,'[email protected]',162.64),(1021,'C. Monturiol cant. C. Jacint Verdaguer s/n',23,'Barcelona','8490',933489004,'[email protected]',170.32),(1023,'Av. Carretera d\'Igualada',97,'Barcelona','8784',933506028,'[email protected]',126.10),(1024,'C. Blai Madonna s/n',33,'Barcelona','8770',933506712,'[email protected]',426.50),(1025,'C. Ripoll',20,'Barcelona','8500',933502456,'[email protected]',505.72),(1026,'Av. de Tàrrega',5,'Barcelona','8401',933494020,'[email protected]',164.24),(1029,'Av. Galícia',2,'Barcelona','8320',933489612,'[email protected]',131.10),(1030,'Ctra. C-35 cant. C. Indústria',33,'Barcelona','8470',933505192,'[email protected]',478.72),(1031,'Av. De les Alegries',0,'Barcelona','8410',933495920,'[email protected]',162.64),(1036,'Camí del Pla del Llop',42,'Barcelona','8450',933497820,'[email protected]',402.50),(1037,'C. Nou s/n',11,'Barcelona','8206',933498124,'[email protected]',436.72),(1039,'Av. Tres',64,'Barcelona','8100',933500632,'[email protected]',164.24),(1040,'Ctra. C-17',110,'Barcelona','8360',933496908,'[email protected]',411.50),(1041,'Av. Catalunya',40,'Barcelona','8184',933497668,'[email protected]',187.64),(1042,'Av. Fonz',8,'Barcelona','8560',933493792,'[email protected]',188.64),(1043,'Av. Barcelona',185,'Barcelona','8560',933488624,'[email protected]',181.64),(1046,'C. Almacellas',93,'Barcelona','8915',933493640,'[email protected]',421.72),(1048,'C. Romaní',4,'Barcelona','8290',933492196,'[email protected]',170.24),(1049,'C. Chiprana',26,'Barcelona','8800',933491664,'[email protected]',158.42),(1052,'Av. Pirineus',0,'Barcelona','8232',933493944,'[email protected]',405.50),(1053,'C. Enginyer Antoni Llobet',0,'Barcelona','8530',933494476,'[email protected]',152.32),(1055,'C. Josep Tarradellas',3,'Barcelona','8720',933498884,'[email protected]',141.24),(1056,'Costa Brava Bulevar',33,'Barcelona','8470',933497592,'[email protected]',127.02),(1057,'Ctra. De Sant Vicenç',0,'Barcelona','8560',933488548,'[email protected]',182.24),(1058,'C. Victòria dels Àngels',2,'Barcelona','8042',933492728,'[email protected]',430.72),(1059,'Av. Tarragona',132,'Barcelona','8720',933506864,'[email protected]',170.64),(1060,'C. Margenat',42,'Barcelona','8206',933505800,'[email protected]',435.50),(1061,'Ctra. De Roda',0,'Barcelona','8560',933509144,'[email protected]',415.72),(1062,'Av. Josep Tarradellas',2,'Barcelona','8225',933505724,'[email protected]',140.32),(1063,'C. Dalt de Can Turon cant. C.8 de març de 1908',33,'Barcelona','8410',933495844,'[email protected]',163.24),(1065,'Ctra. Argentina',2,'Barcelona','8029',933493032,'[email protected]',414.50),(1066,'Ctra. Vic',11,'Barcelona','8013',933500860,'[email protected]',439.72),(1068,'Av. Castell d\'Aro',44,'Barcelona','8174',933495616,'[email protected]',187.64),(1069,'Parc Central - Av. Vidal i Barraquer',15,'Barcelona','8026',933492044,'[email protected]',136.32),(1070,'Av. Països catalans',17,'Barcelona','8720',933499188,'[email protected]',127.02),(1071,'Av. de Tarragona',13,'Barcelona','8500',933494780,'[email protected]',127.32),(1072,'Av. Can Campanyà',1,'Barcelona','8755',933506484,'[email protected]',135.02),(1073,'Av. Generalitat',1,'Barcelona','8012',933491816,'[email protected]',439.72),(1076,'C. La Closa dels Frares',443,'Barcelona','8360',933489232,'[email protected]',203.64),(1077,'Via Augusta',103,'Barcelona','8174',933503216,'[email protected]',182.64),(1078,'Av. Mestre Muntaner cant. C. Lleida',122,'Barcelona','8700',933509524,'[email protected]',162.24),(1079,'C. Roma',3,'Barcelona','8401',933509372,'[email protected]',128.32),(1081,'C. Brutau',126,'Barcelona','8203',933508840,'[email protected]',442.72),(1082,'C. Lluís Companys',112,'Barcelona','8490',933496680,'[email protected]',130.02),(1085,'Ctra. de Molins de Rei',75,'Barcelona','8191',933504888,'[email protected]',444.50),(1087,'Av. del Conflent Sector Comercial Montigalà',121,'Barcelona','8915',933509068,'[email protected]',153.32),(1088,'Rbla. del Garraf',2,'Barcelona','8720',933498960,'[email protected]',151.42),(1089,'C. Baladre',3,'Barcelona','8500',933494628,'[email protected]',125.02),(1090,'C. Mata',11,'Barcelona','8174',933495464,'[email protected]',418.72),(1093,'Av. de França',127,'Barcelona','8508',933495996,'[email protected]',115.10),(3000,'Ctra. C-17 km 48',74,'Barcelona','8410',933488244,'[email protected]',146.02),(3001,'Ctra. de Santa Coloma',106,'Barcelona','8570',933496452,'[email protected]',154.42),(3002,'Ctra. Nacional II',70,'Barcelona','8720',933491208,'[email protected]',432.50),(3003,'C. Argentina',13,'Barcelona','8870',933491740,'[email protected]',161.32),(3004,'Ctra. Nacional 340',1240,'Barcelona','8770',933499036,'[email protected]',154.32),(3500,'Ctra. de Barcelona',115,'Barcelona','8770',933491360,'[email protected]',172.64),(3501,'C. de Ripoll',20,'Barcelona','8293',933490904,'[email protected]',448.72),(3506,'C. Artesans',79,'Barcelona','43800',933509904,'[email protected]',147.42),(3510,'Av. Lluís Companys',0,'Barcelona','8025',933499644,'[email protected]',115.10),(3555,'C. Lluís Companys',14,'Barcelona','8017',933489764,'[email protected]',154.24),(3566,'Ctra. Vic cant. C. Castellgalí',33,'Barcelona','8640',933490752,'[email protected]',161.42),(3585,'Ctra. De Molins de Rei',69,'Barcelona','8410',933488168,'[email protected]',475.72),(3602,'Ctra. C17',2,'Barcelona','8560',933488092,'[email protected]',173.32),(3609,'C. Nicaragua',0,'Barcelona','8650',933488016,'[email protected]',170.42),(3630,'Ctra. C-35 cant. C. Indústria',4,'Barcelona','8174',933487940,'[email protected]',160.24),(3656,'Ctra. C-31 s/n',55,'Barcelona','8500',933495388,'[email protected]',154.32),(3662,'Av. Josep Tarradellas',2,'Barcelona','8174',933487864,'[email protected]',502.72),(3672,'Av. Can Campanyà',1,'Barcelona','8755',933502836,'[email protected]',147.02),(3677,'Via Augusta',103,'Barcelona','8174',933487788,'[email protected]',137.10),(3678,'Av. Mestre Muntaner cant. C. Lleida',66,'Barcelona','8700',933501924,'[email protected]',149.42),(3679,'C. Roma',3,'Barcelona','8500',933487712,'[email protected]',184.64),(3687,'Av. del Conflent',0,'Barcelona','8500',933487636,'[email protected]',185.24),(3688,'C. Roma',3,'Barcelona','8500',933487560,'[email protected]',468.50),(3689,'C. Ciutat Jardí',0,'Barcelona','8755',933487484,'[email protected]',151.32),(3690,'C. Mata',11,'Barcelona','8755',933487408,'[email protected]',209.64),(3756,'Av. Centenari Amadeu Vives',2,'Barcelona','8500',933487332,'[email protected]',149.02),(3777,'C. de Caldes de Montbui',142,'Barcelona','8552',933487256,'[email protected]',484.72),(4009,'C. Nicaragua',0,'Barcelona','8100',933508156,'[email protected]',156.32),(4059,'Av. Tarragona',132,'Barcelona','8720',933506788,'[email protected]',171.24),(4072,'Av. Can Campanyà',1,'Barcelona','8755',933506408,'[email protected]',442.72),(4087,'Av. del Conflent',0,'Barcelona','8915',933508992,'[email protected]',150.42),(4168,'C. Sant Ramon',259,'Barcelona','8290',933507548,'[email protected]',134.32);
/*!40000 ALTER TABLE `botiga` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `client`
--

DROP TABLE IF EXISTS `client`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `client` (
  `cod_c` int NOT NULL,
  `nom` varchar(45) DEFAULT NULL,
  `cognom` varchar(45) DEFAULT NULL,
  `adreça` varchar(125) DEFAULT NULL,
  `poblacio` varchar(45) DEFAULT NULL,
  `CP` varchar(5) DEFAULT NULL,
  `telefon` int DEFAULT NULL,
  PRIMARY KEY (`cod_c`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `client`
--

LOCK TABLES `client` WRITE;
/*!40000 ALTER TABLE `client` DISABLE KEYS */;
INSERT INTO `client` VALUES (10010,'Daniel','Acevedo Jhong','c. Bruc, 102','Barcelona','08009',934576081),(10020,'Miguelvicente','Agurto Rondoy','c. Sant Pau, 101','Barcelona','08001',934410098),(10030,'Raul Eduardo','Almora Hernandez','c. Àngels, s/n','Barcelona','08001',934427038),(10040,'Jorge ','Alosilla Velazco Vera','pl. Castella, 8','Barcelona','08001',933020835),(10050,'Victor','Alva Campos','c. Nou de Sant Francesc, 9-13','Barcelona','08001',933189733),(10060,'Javier','Arevalo Lopez','rda. Sant Pau, 38','Barcelona','08001',934429203),(10070,'Rosario','Arias Hernandez','av. de Roma, 98-100','Barcelona','08015',934544865),(10080,'Marco Tulio','Alocen Barrera','c. Diputació, 112-116','Barcelona','08015',934546868),(10090,'Cesar','Baiocchi Ureta','c. Londres, 64','Barcelona','08036',934442682),(10100,'Leoncia','Bedoya Castillo','pl. Espanya, 2-3','Barcelona','08014',934235085),(10110,'Luz Marina','Bedregal Canales','c. Canalejas, 107','Barcelona','08028',934222440),(10120,'Ramiro Alberto','Bejar Torres','c. Sagunt, 92-94','Barcelona','08014',933318893),(10130,'Javier','Benavides Espejo','c. Guitard, 8','Barcelona','08014',934907023),(10140,'Nelson','Boza Solis','c. Melcior de Palau, 134-136','Barcelona','08014',934904103),(10150,'Cielito Mercedes','Calle Betancourt','c. Gayarre, 54-56','Barcelona','08014',934211350),(10160,'Isabel Florisa','Caraza Villegas','pl. de Ferran Lesseps, 19','Barcelona','08023',932176196),(10170,'Gizella','Carrera Abanto','c. Olot, s/n (Parc Güell)','Barcelona','08024',932130484),(10180,'Estalins','Carrillo Segura','c. Natzaret, 83-85','Barcelona','08035',934181300),(10190,'Jorge Augusto','Carriã“N Neira','c. Sant Camil, 31','Barcelona','08023',932138802),(10200,'Guillermo ','Casapia Valdivia','c. Torrent del Remei, 2-10','Barcelona','08023',932139845),(10210,'Zarita','Chancos Mendoza','pg. Vall d\'Hebron, 64-70','Barcelona','08023',932124429),(10220,'Carlos','Chirinos Lacotera','c. Orduña, s/n','Barcelona','08031',934084651),(10230,'Doris','Cores Moreno','c. Juan de Garay, 12','Barcelona','08041',933518304),(10240,'Maribel Corina','Cortez Lozano','c. Pujalt, s/n','Barcelona','08033',933592942),(10250,'Angel','Crispin Quispe','c. de Peñalara, 19-55','Barcelona','08031',934295384),(10260,'Antonio ','De Loayza Conterno','c. Arnau Oms, 4','Barcelona','08016',933522951),(10270,'Ana Maria','Diaz Salinas','c. Almacelles, 1-11','Barcelona','08020',933141776),(10280,'Yuliana','Espinoza Arana','c. Tucuman, 1','Barcelona','08030',933455613),(10290,'Carlos Enrique','Fernandez Guzman','c. Vallcivera, s/n','Barcelona','08033',933592941),(10300,'Esther Aurora','Fernandez Matta','c. Casals i Cuberó, s/n','Barcelona','08042',933541302),(10310,'Olga','Ferro Salas','c. Joaquim Valls, 10(Barriada Roquetes)','Barcelona','08016',933594745),(10320,'Edwin','Flores Romero','c. Font d\'en Canyelles, 35','Barcelona','08016',933590946),(10330,'Roberto','Gamarra Astete','c. Guardiola i Feliu, 7-9','Barcelona','08030',933456816),(10340,'Gloria','Gamio Lozano','pl. Sant Bernat Calbó, 2','Barcelona','08005',932252838),(10350,'Marlene Victoria','Gonzales Huilca','c. Extremadura, 15','Barcelona','08020',933136239),(10360,'Elsa Patricia','Gonzales Medina','c. Cristobal de Moura, 240','Barcelona','08019',933052151),(10370,'Javier','Gutierrez Velez','c. Jaume Huguet, 22','Barcelona','08019',933053001),(10380,'Elena Rosavelt','Guzman Chinag','c. Aragó, 620','Barcelona','08018',932454243),(10390,'Clara','Guzman Quispe','c. Pujadas, 252-270','Barcelona','08005',933070033),(10400,'Milagros Susan ','Herrera Carbajal','pl. Eduard Torroja, 12-20','Barcelona','08020',933071232),(10410,'Guillermo','Horruitiner Martinez','c. Perú, 139','Barcelona','08018',933072613),(10420,'Lourdes','Huamani Flores','c. Bernat Metge, 20-26','Barcelona','08019',933142420),(10430,'Luis Armando','Huapaya Raygada','c. Prim, 121-123','Barcelona','08020',933144919),(10440,'Marcos','Huarcaya Quispe','c. Vallespir, 198','Barcelona','08014',934908159),(10450,'Elba Mercedes ','La Rosa Fabian','pg. Font d\'En Fargas, 65','Barcelona','08032',933576148),(10460,'Pedro Guillermo','Landa Ginocchio','c. Indústria, 255','Barcelona','08041',934563281),(10470,'Roberto Julian','Llaja Tafur','c. Llobregós, 154','Barcelona','08032',934294698),(10480,'Hector','Lujan Venegas','c. Marne, 2','Barcelona','08042',933596280),(10490,'Sandra Monica','Maldonado Tinco','c. Mas Casanovas, 55','Barcelona','08025',934364910),(10500,'Cosme Adolfo','Maldonado Quispe','c. Fluvià, 253','Barcelona','08020',933071431),(10510,'Jenny Maria','Mallqui Celestino','prolongació de Perafita, s/n','Barcelona','08033',933506600),(10520,'Santiago','Mamani Uchasara','av. Rasos de  Peguera, 234','Barcelona','08033',933509148),(10530,'Magda Janeth','Maravi Navarro','Gran Via de les Corts Catalanes 1108','Barcelona','08020',933086995),(10540,'Martin','Martinez Marquez','c. Llull, 377','Barcelona','08019',933071458),(10550,'Oscar Enrique','Medina Zuta','pg. Zona Franca, 96-104','Barcelona','08038',933326247),(10560,'Carlos P','Melgarejo Vibes','c. del Platí, 6','Barcelona','08038',933315284),(10570,'Elizabeth','Miguel Holgado','av. Vallcarca, 220','Barcelona','08023',932123375),(10580,'Manuel Antonio','Mori Ramirez','c. Argentina, s/n','Barcelona','08930',933819400),(10590,'Olga','Ore Reyes','rbla. Caçador, 6-12','Barcelona','08042',934270125),(10600,'Josue','Orrillo Ortiz','c. Avinyó, 20','Barcelona','08002',933188716),(10610,'Carmen Rosa','Pardave Camacho','pl. de Sant Felip Neri, 6','Barcelona','08002',933011296),(10620,'Santiago Victor','Paredes Jaramillo','c. Blasco de Garay, 52','Barcelona','08004',934425027),(10630,'Arturo','Pastor Porras','av. Miramar, 7-9','Barcelona','08038',934414224),(10640,'Sonia','Prada Vilchez','c. Rocafort, 42','Barcelona','08015',934231234),(10650,'Gerardo David','Riega Calle','c. Sepúlveda, 67-71/c.Calàbria, 81','Barcelona','08015',933257712),(10660,'Freddy','Rios Lima','c. Setantí, 10-12','Barcelona','08034',932030006),(10670,'Teresa','Rios Lima','c. Tamarit, 80','Barcelona','08004',934240230),(10680,'Juan Elvis','Riquelme Miranda','c. Còrsega, 409','Barcelona','08037',933218377),(10690,'Georgina Esperanza','Roa Yanac','c. Vila Vilà, 14','Barcelona','08004',934418006),(10700,'Rosa Liliana','Robles Valverde','c. Cisell, 15','Barcelona','08038',932230829),(10710,'Rosa Josefa','Rodriguez Farias','pg. Zona Franca, 198','Barcelona','08038',933323246),(10720,'Maria De Fatima','Rojas Valdivia','c. Física, 12-14','Barcelona','08038',933318093),(10730,'Rosa Maria','Romero Gomez Sanchez','c. Gomis, 102-104','Barcelona','08023',934170739),(10740,'Carina Magnolia','Rosales Flores','ctra. d\'Esplugues, 49-53','Barcelona','08034',932030154),(10750,'Carlos Jose','Rosas Bonifaz','pg. de la Bonanova, 8','Barcelona','08022',932540954),(10760,'Aida Cristina','Ruiz De Castilla Britto','c. Císter, 23','Barcelona','08022',932110217),(10770,'Celin','Salcedo Del Pino','c. Copèrnic, 55-59','Barcelona','08006',932018555),(10780,'Violeta Marilu','Salinas Puccio','c. Carrasco i Formiguera, 6-16','Barcelona','08017',932041145),(10790,'Augusto','Sanchez Arone','c. Carrasco i Formiguera, 32','Barcelona','08017',936023000),(10800,'Pedro Manuel','Santa Cruz Benssa','av. Tibidabo, 26-28','Barcelona','08022',932126754),(10810,'Angel','Solano Vargas','c. Eduard Conde, 17-23','Barcelona','08034',932038754),(10820,'Jose Alberto','Tejedo Luna','c. Bailèn, 53-59','Barcelona','08009',932654237),(10830,'Angel ','Tenorio Davila','c. Esperança, 13','Barcelona','08017',934173485),(10840,'Miguel Angel ','Torres Gaspar','c. Carles Riba, 11-15','Barcelona','08035',932123108),(10850,'Jacquelin','Trujillo Parodi','c. Ganduxer, 85-105','Barcelona','08022',932123354),(10860,'Ruth Noricila','Vega Carreazo','c. Eduard Toldrà, 18','Barcelona','08034',932043612);
/*!40000 ALTER TABLE `client` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `comanda`
--

DROP TABLE IF EXISTS `comanda`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `comanda` (
  `Ncomanda` int NOT NULL,
  `data_c` date NOT NULL,
  `import` decimal(8,2) DEFAULT NULL,
  `c_credit` int NOT NULL,
  PRIMARY KEY (`Ncomanda`,`c_credit`),
  KEY `fk_COMANDA_CREDIT1` (`c_credit`),
  CONSTRAINT `fk_COMANDA_CREDIT1` FOREIGN KEY (`c_credit`) REFERENCES `credit` (`c_credit`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `comanda`
--

LOCK TABLES `comanda` WRITE;
/*!40000 ALTER TABLE `comanda` DISABLE KEYS */;
INSERT INTO `comanda` VALUES (11011124,'2021-12-24',1300.00,122310144),(11011125,'2022-02-13',1980.00,122310386),(11011126,'2021-11-17',2574.00,122310628),(11011127,'2022-01-23',2706.00,122310870),(11011128,'2021-10-16',7920.00,122311112),(11011129,'2021-12-18',3250.00,122311354),(11011130,'2022-02-21',4620.00,122311596),(11011131,'2021-11-15',1430.00,122311838),(11011132,'2022-01-17',1845.00,122312080),(11011133,'2021-10-24',2376.00,122312322),(11011134,'2021-12-16',2600.00,122312564),(11011135,'2022-02-15',6600.00,122312806),(11011136,'2021-11-23',2574.00,122313048),(11011137,'2022-01-15',3690.00,122313290),(11011138,'2021-10-18',3960.00,122313532),(11011310,'2021-11-15',1430.00,122310023),(11011311,'2022-01-17',1845.00,122310265),(11011312,'2021-10-24',2376.00,122310507),(11011313,'2021-12-16',2600.00,122310749),(11011314,'2022-02-15',6600.00,122310991),(11011315,'2021-11-23',2574.00,122311233),(11011316,'2022-01-15',3690.00,122311475),(11011317,'2021-10-18',1320.00,122311717),(11011318,'2021-12-24',1300.00,122311959),(11011319,'2022-02-13',1980.00,122312201),(11011320,'2021-11-17',2574.00,122312443),(11011321,'2022-01-23',2706.00,122312685),(11011322,'2021-10-16',7920.00,122312927),(11011323,'2021-12-18',3250.00,122313169),(11011324,'2022-02-21',4620.00,122313411);
/*!40000 ALTER TABLE `comanda` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `conte`
--

DROP TABLE IF EXISTS `conte`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `conte` (
  `codi_prod` int NOT NULL,
  `Ncomanda` int NOT NULL,
  `quantitat` int NOT NULL,
  PRIMARY KEY (`codi_prod`,`Ncomanda`),
  KEY `fk_PRODUCTES_has_COMANDA_COMANDA1` (`Ncomanda`) /*!80000 INVISIBLE */,
  CONSTRAINT `fk_PRODUCTES_has_COMANDA_COMANDA1` FOREIGN KEY (`Ncomanda`) REFERENCES `comanda` (`Ncomanda`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_PRODUCTES_has_COMANDA_PRODUCTES1` FOREIGN KEY (`codi_prod`) REFERENCES `productes` (`codi_prod`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `conte`
--

LOCK TABLES `conte` WRITE;
/*!40000 ALTER TABLE `conte` DISABLE KEYS */;
INSERT INTO `conte` VALUES (371005,11011131,1),(371012,11011318,3),(1830020,11011131,2),(1830028,11011131,1),(1830028,11011310,1),(1830029,11011131,3),(1830029,11011310,1),(1830029,11011311,1),(1830037,11011131,1),(1830037,11011310,1),(1830039,11011131,1),(1830039,11011310,2),(1830039,11011318,1),(1830039,11011319,1),(1831040,11011124,1),(1831040,11011138,2),(1831050,11011124,1),(1831064,11011124,1),(1831064,11011137,1),(1831070,11011323,1),(1831070,11011324,1),(1831076,11011323,1),(1831082,11011138,1),(1831084,11011124,2),(1831090,11011324,1),(1831094,11011132,1),(1831094,11011323,1),(1831098,11011324,1),(1831116,11011311,1),(1831116,11011323,1),(1831118,11011311,1),(1831120,11011132,1),(1831120,11011311,3),(1831120,11011318,1),(1831122,11011311,1),(1831124,11011138,1),(1831124,11011311,3),(1831126,11011311,1),(1831132,11011132,1),(1831139,11011132,1),(1831150,11011132,1),(1831152,11011320,1),(1831160,11011132,1),(1831160,11011134,2),(1831166,11011314,1),(1831167,11011128,1),(1831167,11011321,1),(1831168,11011315,1),(1831169,11011129,1),(1831169,11011132,1),(1831170,11011316,1),(1831171,11011130,2),(1831171,11011321,1),(1831172,11011317,1),(1831173,11011131,1),(1831178,11011132,1),(1831178,11011321,3),(1831185,11011322,1),(1831186,11011132,1),(1831186,11011136,1),(1831187,11011323,1),(1831188,11011323,1),(1831195,11011321,1),(1831196,11011125,1),(1831197,11011125,1),(1831198,11011125,1),(1831198,11011126,1),(1831198,11011132,1),(1831199,11011125,1),(1831199,11011133,1),(1831199,11011135,1),(1831199,11011313,1),(1831199,11011318,1),(1831199,11011319,2),(1831200,11011125,1),(1831200,11011127,1),(1831202,11011135,1),(1831202,11011321,3),(1831205,11011133,1),(1831205,11011135,1),(1831205,11011312,5);
/*!40000 ALTER TABLE `conte` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `credit`
--

DROP TABLE IF EXISTS `credit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `credit` (
  `c_credit` int NOT NULL,
  `n_compte` varchar(45) DEFAULT NULL,
  `import` int DEFAULT NULL,
  `d_venciment` date DEFAULT NULL,
  `codi_c` int NOT NULL,
  PRIMARY KEY (`c_credit`,`codi_c`),
  KEY `fk_CREDIT_MAJORISTA1` (`codi_c`),
  CONSTRAINT `fk_CREDIT_MAJORISTA1` FOREIGN KEY (`codi_c`) REFERENCES `majorista` (`codi_c`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `credit`
--

LOCK TABLES `credit` WRITE;
/*!40000 ALTER TABLE `credit` DISABLE KEYS */;
INSERT INTO `credit` VALUES (122310023,'2100XXXXXXXXXXXX1555',1000,'2021-11-30',10020),(122310144,'0128XXXXXXXXXXXX8783',1000,'2021-12-31',10030),(122310265,'2100XXXXXXXXXXXX1556',1500,'2022-01-30',10040),(122310386,'0128XXXXXXXXXXXX8784',1500,'2022-02-28',10050),(122310507,'2100XXXXXXXXXXXX1557',1800,'2021-10-31',10060),(122310628,'0128XXXXXXXXXXXX8785',1800,'2021-11-30',10070),(122310749,'2100XXXXXXXXXXXX1558',2000,'2021-12-31',10080),(122310870,'0128XXXXXXXXXXXX8786',2200,'2022-01-30',10090),(122310991,'2100XXXXXXXXXXXX1559',5000,'2022-02-28',10100),(122311112,'0128XXXXXXXXXXXX8787',6000,'2021-10-31',10110),(122311233,'2100XXXXXXXXXXXX1560',1800,'2021-11-30',10120),(122311354,'0128XXXXXXXXXXXX8788',2500,'2021-12-31',10130),(122311475,'2100XXXXXXXXXXXX1561',3000,'2022-01-30',10140),(122311596,'0128XXXXXXXXXXXX8789',3500,'2022-02-28',10150),(122311717,'2100XXXXXXXXXXXX1562',1000,'2021-10-31',10160),(122311838,'0128XXXXXXXXXXXX8790',1000,'2021-11-30',10170),(122311959,'2100XXXXXXXXXXXX1563',1000,'2021-12-31',10180),(122312080,'0128XXXXXXXXXXXX8791',1500,'2022-01-30',10190),(122312201,'2100XXXXXXXXXXXX1564',1500,'2022-02-28',10200),(122312322,'0128XXXXXXXXXXXX8792',1800,'2021-10-31',10210),(122312443,'2100XXXXXXXXXXXX1565',1800,'2021-11-30',10220),(122312564,'0128XXXXXXXXXXXX8793',2000,'2021-12-31',10230),(122312685,'2100XXXXXXXXXXXX1566',2200,'2022-01-30',10240),(122312806,'0128XXXXXXXXXXXX8794',5000,'2022-02-28',10250),(122312927,'2100XXXXXXXXXXXX1567',6000,'2021-10-31',10260),(122313048,'0128XXXXXXXXXXXX8795',1800,'2021-11-30',10270),(122313169,'2100XXXXXXXXXXXX1568',2500,'2021-12-31',10280),(122313290,'0128XXXXXXXXXXXX8796',3000,'2022-01-30',10290),(122313411,'2100XXXXXXXXXXXX1569',3500,'2022-02-28',10300),(122313532,'0128XXXXXXXXXXXX8797',3000,'2021-10-31',10300),(122313590,'0128XXXXXXXXXXXX8797',2500,'2020-10-31',10310),(122314590,'0128XXXXXXXXXXXX8795',1500,'2022-10-31',10270),(122314592,'0128XXXXXXXXXXXX8795',2000,'2022-12-31',10270);
/*!40000 ALTER TABLE `credit` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cultius`
--

DROP TABLE IF EXISTS `cultius`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cultius` (
  `codi_prod` int NOT NULL,
  `tipus` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`codi_prod`),
  CONSTRAINT `fk_CULTIUS_PRODUCTES1` FOREIGN KEY (`codi_prod`) REFERENCES `productes` (`codi_prod`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cultius`
--

LOCK TABLES `cultius` WRITE;
/*!40000 ALTER TABLE `cultius` DISABLE KEYS */;
INSERT INTO `cultius` VALUES (371005,'Accesori'),(371010,'Accesori'),(371012,'Motxilla'),(371016,'Motxilla'),(1830020,'Accesori'),(1830026,'Accesori'),(1830027,'Accesori'),(1830028,'Accesori'),(1830029,'Accesori'),(1830037,'Set'),(1830038,'Set'),(1830039,'Set'),(1831020,'Accesori'),(1831022,'Accesori'),(1831024,'Accesori');
/*!40000 ALTER TABLE `cultius` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `decoracio`
--

DROP TABLE IF EXISTS `decoracio`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `decoracio` (
  `codi_prod` int NOT NULL,
  `material` varchar(45) NOT NULL,
  `mida` varchar(60) NOT NULL,
  PRIMARY KEY (`codi_prod`),
  CONSTRAINT `fk_DECORACIO_PRODUCTES1` FOREIGN KEY (`codi_prod`) REFERENCES `productes` (`codi_prod`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `decoracio`
--

LOCK TABLES `decoracio` WRITE;
/*!40000 ALTER TABLE `decoracio` DISABLE KEYS */;
INSERT INTO `decoracio` VALUES (1831204,'fusta','21x21x48'),(1831205,'ceramica','28.5x50');
/*!40000 ALTER TABLE `decoracio` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `distribueix`
--

DROP TABLE IF EXISTS `distribueix`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `distribueix` (
  `cod_botiga` int NOT NULL,
  `cod_zona` int NOT NULL,
  `codi_prod` int NOT NULL,
  `estoc` int NOT NULL,
  PRIMARY KEY (`cod_botiga`,`cod_zona`,`codi_prod`),
  KEY `fk_ZONA_has_PRODUCTES_PRODUCTES1` (`codi_prod`),
  CONSTRAINT `fk_ZONA_has_PRODUCTES_PRODUCTES1` FOREIGN KEY (`codi_prod`) REFERENCES `productes` (`codi_prod`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_ZONA_has_PRODUCTES_ZONA1` FOREIGN KEY (`cod_botiga`, `cod_zona`) REFERENCES `zona` (`cod_botiga`, `cod_zona`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `distribueix`
--

LOCK TABLES `distribueix` WRITE;
/*!40000 ALTER TABLE `distribueix` DISABLE KEYS */;
INSERT INTO `distribueix` VALUES (1,1,1831026,1),(1,1,1831028,2),(1,1,1831030,3),(1,1,1831032,4),(1,1,1831034,5),(1,1,1831036,6),(1,1,1831038,3),(1,1,1831040,2),(1,1,1831042,3),(1,1,1831044,5),(1,1,1831046,12),(1,1,1831048,3),(1,1,1831050,55),(1,1,1831052,2),(1,1,1831054,35),(1,1,1831056,1),(1,1,1831058,35),(1,1,1831060,1),(1,1,1831062,36),(1,1,1831064,7),(1,3,371005,3),(1,3,371010,6),(1,3,371012,7),(1,3,371016,18),(1,3,1830020,2),(1,3,1830026,3),(1,3,1830027,5),(1,3,1830028,34),(1,3,1830029,17),(1,3,1830037,12),(1,3,1830038,3),(1,3,1830039,12),(1,3,1831020,3),(1,3,1831022,1),(1,3,1831024,13),(1,4,1831066,3),(1,4,1831068,5),(1,4,1831070,1),(1,4,1831072,5),(1,4,1831074,5),(1,4,1831076,5),(1,4,1831078,5),(1,4,1831080,5),(1,4,1831082,5),(1,4,1831084,5),(1,4,1831086,5),(1,4,1831088,1),(1,4,1831090,2),(1,4,1831092,3),(1,5,1831139,62),(1,5,1831140,4),(1,5,1831141,2),(1,5,1831142,62),(1,5,1831143,6),(1,5,1831144,2),(1,5,1831145,3),(1,5,1831146,11),(1,5,1831147,1),(1,5,1831148,3),(1,5,1831149,3),(1,5,1831150,1),(1,5,1831151,2),(1,5,1831152,3),(1,5,1831153,5),(1,5,1831154,2),(1,5,1831155,1),(1,5,1831156,2),(1,5,1831157,1),(1,5,1831158,3),(1,5,1831159,5),(1,5,1831160,1),(1,5,1831161,5),(1,5,1831162,5),(1,5,1831163,5),(1,5,1831164,5),(1,5,1831165,5),(1,5,1831166,5),(1,5,1831167,5),(1,5,1831168,5),(1,5,1831169,1),(1,5,1831170,2),(1,5,1831171,3),(1,5,1831172,4),(1,5,1831173,5),(1,5,1831174,6),(1,5,1831175,7),(1,5,1831176,8),(1,5,1831177,2),(1,5,1831178,5),(1,5,1831179,3),(1,5,1831180,5),(1,5,1831181,1),(1,5,1831182,6),(1,5,1831183,7),(1,5,1831184,4),(1,5,1831185,1),(1,5,1831186,2),(1,5,1831187,3),(1,5,1831188,4),(1,5,1831189,5),(1,5,1831190,6),(1,5,1831191,3),(1,5,1831192,2),(1,5,1831193,3),(1,5,1831194,5),(1,5,1831195,12),(1,5,1831196,3),(1,5,1831197,55),(1,5,1831198,2),(1,5,1831199,35),(1,5,1831200,1),(1,6,1831114,12),(1,6,1831116,3),(1,6,1831118,3),(1,6,1831120,1),(1,6,1831122,13),(1,6,1831124,3),(1,6,1831126,3),(1,6,1831128,1),(1,6,1831132,5),(1,7,1831201,12),(1,7,1831202,34),(1,7,1831203,15),(1,8,1831134,5),(1,8,1831136,1),(1,8,1831138,2),(23,1,1831030,18),(23,1,1831032,7),(23,1,1831034,6),(23,1,1831036,3),(23,1,1831038,2),(23,1,1831040,3),(23,1,1831042,5),(23,1,1831044,12),(23,1,1831046,34),(23,1,1831048,17),(47,1,1831038,5),(47,1,1831040,1),(47,1,1831042,5),(47,1,1831044,5),(47,1,1831046,5),(47,1,1831048,5),(47,1,1831050,5),(47,1,1831052,5),(47,1,1831054,5),(47,1,1831056,5),(47,1,1831058,1),(47,1,1831060,2),(47,1,1831062,3),(47,1,1831064,4),(47,3,371005,5),(47,3,371010,4),(47,3,371012,1),(47,3,371016,3),(47,3,1830020,2),(47,3,1830026,3),(47,3,1830027,5),(47,3,1830028,2),(47,3,1830029,1),(47,3,1830037,5),(47,3,1830038,62),(47,3,1830039,4),(47,3,1831020,4),(47,3,1831022,2),(47,3,1831024,62),(47,4,1831066,4),(47,4,1831068,5),(47,4,1831070,6),(47,4,1831072,7),(47,4,1831074,8),(47,4,1831076,2),(47,4,1831078,5),(47,4,1831080,3),(47,4,1831082,5),(47,4,1831084,1),(47,4,1831086,6),(47,4,1831088,7),(47,4,1831090,4),(47,4,1831092,1),(51,1,1831050,5),(51,1,1831052,6),(51,3,371005,11),(51,3,371010,3),(51,3,371012,2),(51,3,371016,6),(51,3,1830020,1),(51,3,1830026,3),(51,3,1830027,5),(51,3,1830028,2),(51,3,1830029,3),(51,3,1830037,1),(51,3,1830038,2),(51,3,1830039,5),(51,3,1831020,1),(51,3,1831022,2),(51,3,1831024,1),(51,5,1831139,35),(51,5,1831140,1),(51,5,1831141,36),(51,5,1831142,7),(51,5,1831143,18),(51,5,1831144,7),(51,5,1831145,6),(51,5,1831146,3),(51,5,1831147,2),(51,5,1831148,3),(51,5,1831149,5),(51,5,1831150,12),(51,5,1831151,34),(51,5,1831152,17),(51,5,1831153,5),(51,5,1831154,1),(51,5,1831155,5),(51,5,1831156,5),(51,5,1831157,5),(51,5,1831158,5),(51,5,1831159,5),(51,5,1831160,5),(51,5,1831161,5),(51,5,1831162,5),(51,5,1831163,1),(51,5,1831164,2),(51,5,1831165,3),(51,5,1831166,4),(51,5,1831167,5),(51,5,1831168,6),(51,5,1831169,7),(51,5,1831170,8),(51,5,1831171,2),(51,5,1831172,5),(51,5,1831173,3),(51,5,1831174,5),(51,5,1831175,1),(51,5,1831176,4),(51,5,1831177,7),(51,5,1831178,4),(51,5,1831179,1),(51,5,1831180,2),(51,5,1831181,3),(51,5,1831182,4),(51,5,1831183,5),(51,5,1831184,6),(51,5,1831185,3),(51,5,1831186,2),(51,5,1831187,3),(51,5,1831188,5),(51,5,1831189,12),(51,5,1831190,3),(51,5,1831191,55),(51,5,1831192,2),(51,5,1831193,35),(51,5,1831194,1),(51,5,1831195,35),(51,5,1831196,1),(51,5,1831197,36),(51,5,1831198,7),(51,5,1831199,18),(51,5,1831200,7),(51,6,1831128,5),(51,6,1831132,2),(51,7,1831201,34),(51,7,1831202,15),(51,7,1831203,23),(51,8,1831134,5),(51,8,1831136,2),(51,8,1831138,5),(63,4,1831066,2),(63,4,1831068,3),(63,4,1831070,4),(63,4,1831072,5),(63,4,1831074,6),(63,4,1831076,3),(63,4,1831078,2),(63,4,1831080,3),(63,4,1831082,5),(63,4,1831084,12),(63,4,1831086,3),(63,4,1831088,55),(63,4,1831090,2),(63,4,1831092,35),(63,5,1831139,6),(63,5,1831140,3),(63,5,1831141,2),(63,5,1831142,3),(63,5,1831143,5),(63,5,1831144,12),(63,5,1831145,34),(63,5,1831146,17),(63,5,1831147,12),(63,5,1831148,3),(63,5,1831149,3),(63,5,1831150,1),(63,5,1831151,13),(63,5,1831152,3),(63,5,1831153,3),(63,5,1831154,1),(63,5,1831155,4),(63,5,1831156,5),(63,5,1831157,2),(63,5,1831158,3),(63,5,1831159,5),(63,5,1831160,5),(63,5,1831161,2),(63,5,1831162,1),(63,5,1831163,5),(63,5,1831164,62),(63,5,1831165,4),(63,5,1831166,2),(63,5,1831167,62),(63,5,1831168,6),(63,5,1831169,2),(63,5,1831170,3),(63,5,1831171,11),(63,5,1831172,1),(63,5,1831173,3),(63,5,1831174,1),(63,5,1831175,1),(63,5,1831176,2),(63,5,1831177,3),(63,5,1831178,5),(63,5,1831179,2),(63,5,1831180,1),(63,5,1831181,2),(63,5,1831182,1),(63,5,1831183,3),(63,5,1831184,5),(63,5,1831185,1),(63,5,1831186,5),(63,5,1831187,5),(63,5,1831188,5),(63,5,1831189,5),(63,5,1831190,5),(63,5,1831191,5),(63,5,1831192,5),(63,5,1831193,5),(63,5,1831194,1),(63,5,1831195,2),(63,5,1831196,3),(63,5,1831197,4),(63,5,1831198,5),(63,5,1831199,6),(63,5,1831200,7),(63,6,1831114,62),(63,6,1831116,4),(63,6,1831118,2),(63,6,1831120,62),(63,6,1831122,6),(83,7,1831201,4),(83,7,1831202,23),(83,7,1831203,1),(83,8,1831134,5),(83,8,1831136,3),(83,8,1831138,3),(86,1,1831048,7),(86,1,1831050,8),(86,1,1831052,2),(86,1,1831054,5),(86,1,1831056,3),(87,3,371005,4),(87,3,371010,1),(87,3,371012,3),(87,3,371016,3),(87,3,1830020,5),(87,3,1830026,2),(87,3,1830027,3),(87,3,1830028,5),(87,3,1830029,2),(87,3,1830037,5),(87,3,1830038,6),(87,3,1830039,1),(87,3,1831020,62),(87,3,1831022,4),(87,3,1831024,2),(87,4,1831066,1),(87,4,1831068,35),(87,4,1831070,1),(87,4,1831072,36),(87,4,1831074,7),(87,4,1831076,18),(87,4,1831078,7),(87,4,1831080,6),(87,4,1831082,3),(87,4,1831084,2),(87,4,1831086,3),(87,4,1831088,5),(87,4,1831090,12),(87,4,1831092,34),(87,5,1831139,8),(87,5,1831140,2),(87,5,1831141,5),(87,5,1831142,3),(87,5,1831143,5),(87,5,1831144,1),(87,5,1831145,2),(87,5,1831146,7),(87,5,1831147,4),(87,5,1831148,1),(87,5,1831149,2),(87,5,1831150,3),(87,5,1831151,4),(87,5,1831152,5),(87,5,1831153,6),(87,5,1831154,3),(87,5,1831155,2),(87,5,1831156,3),(87,5,1831157,5),(87,5,1831158,12),(87,5,1831159,3),(87,5,1831160,55),(87,5,1831161,2),(87,5,1831162,35),(87,5,1831163,1),(87,5,1831164,35),(87,5,1831165,1),(87,5,1831166,36),(87,5,1831167,7),(87,5,1831168,11),(87,5,1831169,7),(87,5,1831170,6),(87,5,1831171,3),(87,5,1831172,2),(87,5,1831173,3),(87,5,1831174,5),(87,5,1831175,12),(87,5,1831176,34),(87,5,1831177,2),(87,5,1831178,5),(87,5,1831179,1),(87,5,1831180,5),(87,5,1831181,5),(87,5,1831182,5),(87,5,1831183,5),(87,5,1831184,5),(87,5,1831185,5),(87,5,1831186,5),(87,5,1831187,5),(87,5,1831188,1),(87,5,1831189,2),(87,5,1831190,3),(87,5,1831191,4),(87,5,1831192,5),(87,5,1831193,6),(87,5,1831194,7),(87,5,1831195,8),(87,5,1831196,2),(87,5,1831197,5),(87,5,1831198,3),(87,5,1831199,5),(87,5,1831200,1),(87,6,1831118,2),(93,7,1831201,12),(93,7,1831202,34),(93,7,1831203,15),(95,8,1831134,5),(95,8,1831136,4),(95,8,1831138,5),(96,1,1831026,5),(96,1,1831028,1),(96,1,1831030,2),(96,1,1831032,7),(96,1,1831034,4),(96,1,1831036,1),(96,1,1831038,2),(96,1,1831040,3),(96,1,1831042,4),(96,1,1831044,5),(96,1,1831046,6),(96,1,1831048,3),(96,1,1831050,2),(96,1,1831052,3),(96,1,1831054,5),(96,1,1831056,12),(96,1,1831058,3),(96,1,1831060,55),(96,1,1831062,2),(96,3,371005,3),(96,3,371010,2),(96,3,371012,6),(96,3,371016,62),(96,3,1830020,11),(96,3,1830026,1),(96,3,1830027,3),(96,3,1830028,1),(96,3,1830029,2),(96,3,1830037,7),(96,3,1830038,5),(96,3,1830039,3),(96,3,1831020,2),(96,3,1831022,1),(96,3,1831024,2),(96,4,1831066,17),(96,4,1831068,5),(96,4,1831070,1),(96,4,1831072,5),(96,4,1831074,5),(96,4,1831076,5),(96,4,1831078,5),(96,4,1831080,5),(96,4,1831082,5),(96,4,1831084,5),(96,4,1831086,5),(96,4,1831088,1),(96,4,1831090,2),(96,4,1831092,3),(96,4,1831094,3),(96,4,1831096,5),(96,4,1831098,5),(96,4,1831100,2),(96,4,1831102,1),(96,4,1831104,4),(102,5,1831139,220),(102,5,1831140,120),(102,5,1831141,120),(102,5,1831142,120),(102,5,1831143,120),(102,5,1831144,120),(102,5,1831145,120),(102,5,1831146,120),(102,5,1831147,120),(102,5,1831148,120),(102,5,1831149,120),(102,5,1831150,120),(102,5,1831151,120),(102,5,1831152,120),(102,5,1831153,120),(102,5,1831154,120),(102,5,1831155,120),(102,5,1831156,120),(102,5,1831157,120),(102,5,1831158,120),(102,5,1831159,120),(102,5,1831160,120),(102,5,1831161,120),(102,5,1831162,120),(102,5,1831163,120),(102,5,1831164,120),(102,5,1831165,120),(102,5,1831166,120),(102,5,1831167,120),(102,5,1831168,120),(102,5,1831169,120),(102,5,1831170,120),(102,5,1831171,120),(102,5,1831172,1120),(102,5,1831173,120),(102,5,1831174,120),(102,5,1831175,120),(102,5,1831176,120),(102,5,1831177,120),(102,5,1831178,120),(102,5,1831179,120),(102,5,1831180,120),(102,5,1831181,120),(102,5,1831182,120),(102,5,1831183,120),(102,5,1831184,120),(102,5,1831185,120),(102,5,1831186,120),(102,5,1831187,120),(102,5,1831188,120),(102,5,1831189,120),(102,5,1831190,120),(102,5,1831191,120),(102,5,1831192,120),(102,5,1831193,120),(102,5,1831194,120),(102,5,1831195,120),(102,5,1831196,120),(102,5,1831197,120),(102,5,1831198,120),(102,5,1831199,120),(102,5,1831200,120),(103,6,1831114,3),(103,6,1831116,11),(103,6,1831118,1),(103,6,1831120,3),(103,6,1831122,5),(103,6,1831124,1),(103,6,1831126,2),(103,6,1831128,3),(103,6,1831132,2),(104,7,1831201,34),(104,7,1831202,15),(104,7,1831203,23),(105,1,1831040,35),(105,1,1831042,1),(105,1,1831044,35),(105,1,1831046,1),(105,1,1831048,36),(105,8,1831134,5),(105,8,1831136,5),(105,8,1831138,1),(111,3,371005,1),(111,3,371010,5),(111,3,371012,3),(111,3,371016,1),(111,3,1830020,5),(111,3,1830026,5),(111,3,1830027,5),(111,3,1830028,5),(111,3,1830029,5),(111,3,1830037,5),(111,3,1830038,5),(111,3,1830039,5),(111,3,1831020,1),(111,3,1831022,2),(111,3,1831024,3),(112,4,1831066,4),(112,4,1831068,5),(112,4,1831070,6),(112,4,1831072,7),(112,4,1831074,8),(112,4,1831076,2),(112,4,1831078,5),(112,4,1831080,3),(112,4,1831082,5),(112,4,1831084,1),(112,4,1831086,7),(112,4,1831088,7),(112,4,1831090,4),(112,4,1831092,1),(112,5,1831139,2),(112,5,1831140,3),(112,5,1831141,5),(112,5,1831142,2),(112,5,1831143,1),(112,5,1831144,2),(112,5,1831145,1),(112,5,1831146,3),(112,5,1831147,5),(112,5,1831148,1),(112,5,1831149,5),(112,5,1831150,5),(112,5,1831151,5),(112,5,1831152,5),(112,5,1831153,5),(112,5,1831154,5),(112,5,1831155,5),(112,5,1831156,5),(112,5,1831157,1),(112,5,1831158,2),(112,5,1831159,3),(112,5,1831160,4),(112,5,1831161,5),(112,5,1831162,6),(112,5,1831163,7),(112,5,1831164,8),(112,5,1831165,2),(112,5,1831166,5),(112,5,1831167,3),(112,5,1831168,5),(112,5,1831169,1),(112,5,1831170,6),(112,5,1831171,7),(112,5,1831172,4),(112,5,1831173,1),(112,5,1831174,2),(112,5,1831175,3),(112,5,1831176,4),(112,5,1831177,5),(112,5,1831178,6),(112,5,1831179,3),(112,5,1831180,2),(112,5,1831181,3),(112,5,1831182,5),(112,5,1831183,12),(112,5,1831184,3),(112,5,1831185,55),(112,5,1831186,2),(112,5,1831187,35),(112,5,1831188,1),(112,5,1831189,35),(112,5,1831190,1),(112,5,1831191,36),(112,5,1831192,7),(112,5,1831193,19),(112,5,1831194,7),(112,5,1831195,6),(112,5,1831196,3),(112,5,1831197,2),(112,5,1831198,3),(112,5,1831199,5),(112,5,1831200,12),(112,6,1831122,1),(112,6,1831124,3),(112,6,1831126,5),(112,6,1831128,1),(112,7,1831201,4),(112,7,1831202,23),(112,7,1831203,1),(117,8,1831134,5),(117,8,1831136,6),(117,8,1831138,2),(119,3,371005,7),(119,3,371010,6),(119,3,371012,5),(119,3,371016,4),(119,3,1830020,8),(119,3,1830026,2),(119,3,1830027,5),(119,3,1830028,5),(119,3,1830029,1),(119,3,1830037,3),(119,3,1830038,7),(119,3,1830039,2),(119,3,1831020,4),(119,3,1831022,1),(119,3,1831024,2),(120,3,371005,6),(120,3,371010,5),(120,3,371012,4),(120,3,371016,3),(120,3,1830020,3),(120,3,1830026,2),(120,3,1830027,3),(120,3,1830028,12),(120,3,1830029,3),(120,3,1830037,5),(120,3,1830038,2),(120,3,1830039,55),(120,3,1831020,35),(120,3,1831022,1),(120,3,1831024,35),(121,3,371005,18),(121,3,371010,7),(121,3,371012,36),(121,3,371016,1),(121,3,1830020,7),(121,3,1830026,6),(121,3,1830027,3),(121,3,1830028,3),(121,3,1830029,5),(121,3,1830037,2),(121,3,1830038,34),(121,3,1830039,12),(121,3,1831020,17),(121,3,1831022,5),(121,3,1831024,1),(122,4,1831066,2),(122,4,1831068,3),(122,4,1831070,4),(122,4,1831072,5),(122,4,1831074,6),(122,4,1831076,3),(122,4,1831078,2),(122,4,1831080,3),(122,4,1831082,5),(122,4,1831084,12),(122,4,1831086,3),(122,4,1831088,55),(122,4,1831090,2),(122,4,1831092,35),(122,4,1831094,3),(122,4,1831096,8),(122,4,1831098,1),(122,4,1831100,4),(122,4,1831102,5),(122,4,1831104,2),(123,3,371005,5),(123,3,371010,5),(123,3,371012,5),(123,3,371016,5),(123,3,1830020,5),(123,3,1830026,5),(123,3,1830027,5),(123,3,1830028,1),(123,3,1830029,2),(123,3,1830037,5),(123,3,1830038,4),(123,3,1830039,3),(123,3,1831020,5),(123,3,1831022,6),(123,3,1831024,7),(124,3,371005,3),(124,3,371010,5),(124,3,371012,2),(124,3,371016,8),(124,3,1830020,5),(124,3,1830026,1),(124,3,1830027,2),(124,3,1830028,4),(124,3,1830029,1),(124,3,1830037,7),(124,3,1830038,3),(124,3,1830039,2),(124,3,1831020,4),(124,3,1831022,5),(124,3,1831024,6),(125,3,371005,5),(125,3,371010,3),(125,3,371012,2),(125,3,371016,3),(125,3,1830020,12),(125,3,1830026,3),(125,3,1830027,55),(125,3,1830028,35),(125,3,1830029,1),(125,3,1830037,2),(125,3,1830038,1),(125,3,1830039,35),(125,3,1831020,36),(125,3,1831022,7),(125,3,1831024,18),(126,8,1831134,5),(126,8,1831136,7),(126,8,1831138,7),(127,1,1831052,7),(127,2,1831204,10),(127,2,1831205,10),(127,3,371005,2),(127,3,371010,3),(127,3,371012,6),(127,3,371016,7),(127,3,1830020,3),(127,3,1830026,5),(127,3,1830027,12),(127,3,1830028,17),(127,3,1830029,12),(127,3,1830037,34),(127,3,1830038,3),(127,3,1830039,3),(127,3,1831020,1),(127,3,1831022,13),(127,3,1831024,3),(127,4,1831066,1),(127,4,1831068,35),(127,4,1831070,1),(127,4,1831072,36),(127,4,1831074,7),(127,4,1831076,18),(127,4,1831078,7),(127,4,1831080,6),(127,4,1831082,3),(127,4,1831084,2),(127,4,1831086,3),(127,4,1831088,5),(127,4,1831090,12),(127,4,1831092,34),(127,4,1831094,17),(127,4,1831096,12),(127,4,1831098,3),(127,4,1831100,3),(127,4,1831102,1),(127,4,1831104,13),(127,5,1831139,34),(127,5,1831140,22),(127,5,1831141,5),(127,5,1831142,1),(127,5,1831143,5),(127,5,1831144,5),(127,5,1831145,5),(127,5,1831146,5),(127,5,1831147,5),(127,5,1831148,5),(127,5,1831149,5),(127,5,1831150,5),(127,5,1831151,1),(127,5,1831152,2),(127,5,1831153,3),(127,5,1831154,4),(127,5,1831155,5),(127,5,1831156,6),(127,5,1831157,7),(127,5,1831158,8),(127,5,1831159,2),(127,5,1831160,5),(127,5,1831161,3),(127,5,1831162,5),(127,5,1831163,1),(127,5,1831164,7),(127,5,1831165,7),(127,5,1831166,4),(127,5,1831167,1),(127,5,1831168,2),(127,5,1831169,3),(127,5,1831170,4),(127,5,1831171,5),(127,5,1831172,6),(127,5,1831173,3),(127,5,1831174,2),(127,5,1831175,3),(127,5,1831176,5),(127,5,1831177,12),(127,5,1831178,3),(127,5,1831179,55),(127,5,1831180,2),(127,5,1831181,35),(127,5,1831182,1),(127,5,1831183,35),(127,5,1831184,1),(127,5,1831185,36),(127,5,1831186,7),(127,5,1831187,12),(127,5,1831188,7),(127,5,1831189,6),(127,5,1831190,3),(127,5,1831191,2),(127,5,1831192,3),(127,5,1831193,5),(127,5,1831194,12),(127,5,1831195,34),(127,5,1831196,15),(127,5,1831197,23),(127,5,1831198,4),(127,5,1831199,23),(127,5,1831200,1),(127,8,1831134,5),(127,8,1831136,8),(127,8,1831138,4);
/*!40000 ALTER TABLE `distribueix` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `eines`
--

DROP TABLE IF EXISTS `eines`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `eines` (
  `codi_prod` int NOT NULL,
  `model` varchar(45) NOT NULL,
  PRIMARY KEY (`codi_prod`),
  CONSTRAINT `fk_EINES_PRODUCTES1` FOREIGN KEY (`codi_prod`) REFERENCES `productes` (`codi_prod`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `eines`
--

LOCK TABLES `eines` WRITE;
/*!40000 ALTER TABLE `eines` DISABLE KEYS */;
INSERT INTO `eines` VALUES (1831172,'hk_33452'),(1831173,'kl_3536'),(1831174,'jk_23435'),(1831175,'hk_33453'),(1831176,'kl_3537'),(1831177,'jk_23436'),(1831178,'hk_33454'),(1831179,'kl_3538'),(1831180,'jk_23437'),(1831181,'hk_33455'),(1831182,'kl_3539'),(1831183,'jk_23438'),(1831184,'hk_33456'),(1831185,'kl_3540'),(1831186,'jk_23439'),(1831187,'hk_33457'),(1831188,'kl_3541'),(1831189,'jk_23440'),(1831190,'hk_33458'),(1831191,'kl_3542'),(1831192,'jk_23441'),(1831193,'hk_33459'),(1831194,'kl_3543'),(1831195,'jk_23442'),(1831196,'hk_33460'),(1831197,'kl_3544'),(1831198,'jk_23443'),(1831199,'hk_33461'),(1831200,'kl_3545'),(1831201,'jk_23444');
/*!40000 ALTER TABLE `eines` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `empleat`
--

DROP TABLE IF EXISTS `empleat`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `empleat` (
  `DNI` varchar(10) NOT NULL,
  `NASS` varchar(25) NOT NULL,
  `Nom` varchar(45) NOT NULL,
  `Cognom` varchar(45) NOT NULL,
  `adreça` varchar(150) DEFAULT NULL,
  `Telefon` int NOT NULL,
  `Mail` varchar(150) DEFAULT NULL,
  `data_n` date DEFAULT NULL,
  `dni_capequip` varchar(10) NOT NULL,
  PRIMARY KEY (`DNI`,`dni_capequip`),
  KEY `fk_EMPLEAT_EMPLEAT1_idx` (`dni_capequip`),
  KEY `fk_EMPLEAT_EMPLEAT1` (`dni_capequip`),
  CONSTRAINT `fk_EMPLEAT_EMPLEAT1` FOREIGN KEY (`dni_capequip`) REFERENCES `empleat` (`DNI`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `empleat`
--

LOCK TABLES `empleat` WRITE;
/*!40000 ALTER TABLE `empleat` DISABLE KEYS */;
INSERT INTO `empleat` VALUES ('11445749M','248765432140','Neena','Acarrolaea Salaberren','c. Salvador Espriu, 3',665667900,'[email protected]','1967-07-31','11445749M'),('11445750N','248765432143','Lex','Acasuso Salaberri','av. del Bosquet, 1',665667913,'[email protected]','1967-08-01','11445750N'),('11445751U','248765432146','Alexander','Acayeta Salaberria','ctra. Lluçanesa, 8',665667926,'[email protected]','1967-08-02','11445750N'),('15485887U','248765432149','Bruce','Achicallende Samur','Antic camí de Caldes, s/n',665667939,'[email protected]','1967-09-14','11445750N'),('15485888P','248765432152','David','Achichuri San','c. Pompeu Fabra, 2',665667952,'[email protected]','1967-09-15','11445750N'),('15485889Q','248765432155','Valli','Achirica San','Rial de Sa Clavella, s/n',665667965,'[email protected]','1968-08-25','11445750N'),('15485890R','248765432158','Diana','Achiricalandacoa San','c. Generalitat, 2',665667978,'[email protected]','1969-11-21','11445750N'),('15485891S','248765432161','Nancy','Achitia San','c. Bernat de Riudemeia, 27',665667991,'[email protected]','1970-11-01','15485890R'),('15485892T','248765432164','Daniel','Achondo Sanagustiechevarria','c. Carme, 16',665668004,'[email protected]','1972-01-28','15485890R'),('15485893V','248765432167','John','Achordoqui Sancha','c. Barcelona, 23',665668017,'[email protected]','1973-01-07','15485890R'),('15485894W','248765432170','Ismael','Achotegui Sanchez','c. Escoles, s/n',665668030,'[email protected]','1974-04-05','15485890R'),('15485895X','248765432173','Jose Manuel','Achua Sanchez','pg. de la Grava, s/n',665668043,'Jose [email protected]','1975-03-16','15485889Q'),('15485896Y','248765432176','Luis','Achucarro Sancho','c. Núria, s/n',665668056,'[email protected]','1976-06-11','15485889Q'),('15485897Z','248765432179','Den','Achuri Sanchotena','c. Riera de Canyadó, 53',665668069,'[email protected]','1977-05-22','15485889Q'),('15485898A','248765432182','Alexander','Achurica Sanchotenea','ptge. Ventós i Mir, 29-31',665668082,'[email protected]','1978-08-18','15485889Q'),('15485899B','248765432185','Shelli','Achurra Sangroniz','c. Sírius, 2A',665668095,'[email protected]','1979-07-29','15485889Q'),('15485900C','248765432188','Sigal','Achurraaguirre Sanjuanena','c. Alfons XII, 111',665668108,'[email protected]','1980-10-24','15485889Q'),('15485901D','248765432191','Guy','Achurrabeitia Sansinanea','c. Arnús, 16-18',665668121,'[email protected]','1981-10-04','15485889Q'),('15485902E','248765432194','Karen','Achustegui Sansinena','c. Barcelona, 44',665668134,'[email protected]','1982-12-31','15485889Q'),('15485903F','248765432197','Matthew','Achustegui-Echarte Sansinenea','c. Carles I, 9-13',665668147,'[email protected]','1983-12-11','15485893V'),('15485904G','248765432200','Adam','Achutegui Sansiñena','pg. de la  Salut, 36-38',665668160,'[email protected]','1985-03-08','15485893V'),('15485905H','248765432203','Payam','Acillona Sansiñenea','c. Dos de Maig, 67',665668173,'[email protected]','1986-02-16','15485893V'),('15485906I','248765432206','Shanta','Acilu Sansirena','c. Europa, 2 i 2 bis/c. Sèquia 1A i 1B',665668186,'[email protected]','1987-05-15','15485893V'),('15485907J','248765432209','Kevin','Acoegui Sansotena','c. Arbres, 17',665668199,'[email protected]','1988-04-24','15485893V'),('15485908K','248765432212','Julia','Acolanaga Santa','c. Lepant, 3',665668212,'[email protected]','1989-07-21','15485908K'),('15485909L','248765432215','Irene','Acorda Santa','ptge. Pi i Gibert, 29-31',665668225,'[email protected]','1990-07-01','15485905H'),('15485910M','248765432218','James','Acordaechezuria Santacara','pl. Marquès de Barberà, 13',665668238,'[email protected]','1991-09-27','15485905H'),('15485911N','248765432221','Steven','Acordagoicoechea Santoa','c. Provença, 7',665668251,'[email protected]','1992-09-06','15485905H'),('15485912U','248765432224','Laura','Acordagoitia Santostegui','av. de les Palmeres, 5',665668264,'[email protected]','1993-12-03','15485905H'),('15485913P','248765432227','Mozhe','Acordanagoitia Santuberry','c. Conquesta, 57-65',665668277,'[email protected]','1994-11-13','15485905H'),('15485914Q','248765432230','James','Acordarrementeria Santucho','c. Roger de Flor, 115-117',665668290,'[email protected]','1996-02-09','15485905H'),('15485915R','248765432233','TJ','Acotegui Santuguinena','c. Ramiro de Maeztu, s/n',665668303,'[email protected]','1997-01-19','15485905H'),('15485916S','248765432236','Jason','Acundegui Santuola','c. Fluvià, 64',665668316,'[email protected]','1998-04-17','15485897Z'),('15485917T','248765432239','Michael','Acurio Santuren','c. Sant Frederic, s/n',665668329,'[email protected]','1999-03-28','15485897Z'),('15485918V','248765432242','Ki','Acuriogogeascoa Santurena','c. Sant Joan Evangelista, 22',665668342,'[email protected]','2000-03-07','15485897Z'),('15485919W','248765432245','Hazel','Acuriogogeascoa Saola','av. Roma, 29-31',665668355,'[email protected]','2001-06-03','15485897Z'),('15485920X','248765432248','Renske','Acuriola Sara','c. Santa Joana de Lestonnac, s/n',665668368,'[email protected]','1979-09-13','15485897Z'),('15485921Y','248765432251','Stephen','Acutain Sarabeitia','c. Sta.Madrona,75 i Sta.Maria,30 i 34-36',665668381,'[email protected]','1967-10-18','15485897Z'),('15485922Z','248765432254','John','Adagorri Saraburo','c. Santiago, 57',665668394,'[email protected]','1980-05-13','15485897Z'),('15485923A','248765432257','Joshua','Adagoya Saraburu','c. Saragossa, 18 i 19',665668407,'[email protected]','1968-06-17','15485897Z'),('15485924B','248765432260','Trenna','Adaro Saracha','c. Muntaner, 2-18',665668420,'[email protected]','1981-01-11','15485897Z');
/*!40000 ALTER TABLE `empleat` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `majorista`
--

DROP TABLE IF EXISTS `majorista`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `majorista` (
  `codi_c` int NOT NULL,
  `CIF` varchar(45) DEFAULT NULL,
  `nom` varchar(45) DEFAULT NULL,
  `descompte` decimal(4,2) DEFAULT NULL,
  PRIMARY KEY (`codi_c`),
  CONSTRAINT `fk_MAJORISTA_CLIENT1` FOREIGN KEY (`codi_c`) REFERENCES `client` (`cod_c`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `majorista`
--

LOCK TABLES `majorista` WRITE;
/*!40000 ALTER TABLE `majorista` DISABLE KEYS */;
INSERT INTO `majorista` VALUES (10010,'Q5855576D','Daniel Acevedo Jhong',10.00),(10020,'S0800631D','Miguelvicente Agurto Rondoy',10.00),(10030,'Q0802257F','Raul Eduardo Almora Hernandez',10.00),(10040,'Q5855652C','Jorge  Alosilla Velazco Vera',10.00),(10050,'Q585403J','Victor Alva Campos',10.00),(10060,'G65454308','Javier Arevalo Lopez',10.00),(10070,'Q5855990G','Rosario Arias Hernandez',10.00),(10080,'Q0802318F','Marco Tulio Alocen Barrera',10.00),(10090,'Q0801192F','Cesar Baiocchi Ureta',10.00),(10100,'S0800539I','Leoncia Bedoya Castillo',10.00),(10110,'S0800591J','Luz Marina Bedregal Canales',10.00),(10120,'Q5856287G','Ramiro Alberto Bejar Torres',10.00),(10130,'Q0802319D','Javier Benavides Espejo',10.00),(10140,'Q5855124C','Nelson Boza Solis',10.00),(10150,'Q5856266A','Cielito Mercedes Calle Betancourt',10.00),(10160,'S0800592H','Isabel Florisa Caraza Villegas',10.00),(10170,'Q5855611I','Gizella Carrera Abanto',10.00),(10180,'Q5855425D','Estalins Carrillo Segura',10.00),(10190,'Q0801880F','Jorge Augusto Carriã“N Neira',10.00),(10200,'Q5855656D','Guillermo  Casapia Valdivia',10.00),(10210,'S0800639G','Zarita Chancos Mendoza',20.00),(10220,'S0800590B','Carlos Chirinos Lacotera',20.00),(10230,'Q0801168F','Doris Cores Moreno',20.00),(10240,'S0800579E','Maribel Corina Cortez Lozano',20.00),(10250,'Q5855653A','Angel Crispin Quispe',20.00),(10260,'P5801934J','Antonio  De Loayza Conterno',20.00),(10270,'P5805934J','Ana Maria Diaz Salinas',20.00),(10280,'P5891934J','Yuliana Espinoza Arana',20.00),(10290,'P5831934J','Carlos Enrique Fernandez Guzman',20.00),(10300,'P5801936J','Esther Aurora Fernandez Matta',20.00),(10310,'P5801923J','Olga Ferro Salas',20.00);
/*!40000 ALTER TABLE `majorista` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `minorista`
--

DROP TABLE IF EXISTS `minorista`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `minorista` (
  `codi_c` int NOT NULL,
  `DNI` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`codi_c`),
  CONSTRAINT `fk_MINORISTA_CLIENT1` FOREIGN KEY (`codi_c`) REFERENCES `client` (`cod_c`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `minorista`
--

LOCK TABLES `minorista` WRITE;
/*!40000 ALTER TABLE `minorista` DISABLE KEYS */;
INSERT INTO `minorista` VALUES (10320,'23632455D'),(10330,'23632478W'),(10340,'23632501N'),(10350,'23632524L'),(10360,'23632547S'),(10370,'23632570R'),(10380,'23632593Q'),(10390,'23632616D'),(10400,'23632639W'),(10410,'23632662N'),(10420,'23632685L'),(10430,'23632708S'),(10440,'23632731R'),(10450,'23632754Q'),(10460,'23632777D'),(10470,'23632800W'),(10480,'23632823N'),(10490,'23632846L'),(10500,'23632869S'),(10510,'23632892R'),(10520,'23632915Q'),(10530,'23632938D'),(10540,'23632961W'),(10550,'23632984N'),(10560,'23633007L'),(10570,'23633030S'),(10580,'23633053R'),(10590,'23633076Q'),(10600,'23633099D'),(10610,'23633122W'),(10620,'23633145N'),(10630,'23633168L'),(10640,'23633191S'),(10650,'23633214R'),(10660,'23633237Q'),(10670,'23633260D'),(10680,'23633283W'),(10690,'23633306N'),(10700,'23633329L'),(10710,'23633352S'),(10720,'23633375R'),(10730,'23633398Q'),(10740,'23633421D'),(10750,'23633444W'),(10760,'23633467N'),(10770,'23633490L'),(10780,'23633513S'),(10790,'23633536R'),(10800,'23633559Q'),(10810,'23633582D'),(10820,'23633605W'),(10830,'23633628N'),(10840,'23633651L'),(10850,'23633674S'),(10860,'23633697R');
/*!40000 ALTER TABLE `minorista` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `productes`
--

DROP TABLE IF EXISTS `productes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `productes` (
  `codi_prod` int NOT NULL,
  `descripcio` varchar(45) DEFAULT NULL,
  `proveidor` varchar(45) DEFAULT NULL,
  `fabricant` varchar(45) DEFAULT NULL,
  `data_c` date DEFAULT NULL,
  `preu` decimal(6,2) DEFAULT NULL,
  PRIMARY KEY (`codi_prod`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `productes`
--

LOCK TABLES `productes` WRITE;
/*!40000 ALTER TABLE `productes` DISABLE KEYS */;
INSERT INTO `productes` VALUES (371005,'Polvoritzador motxilla 16L','604993','bellota','2021-11-10',23.26),(371010,'Polvoritzar pressió 10L','606751','bellota','2021-12-15',40.99),(371012,'Polvoritzador motxilla 12L','604993','bellota','2021-11-10',44.19),(371016,'Polvoritzador motxilla 16L','604993','bellota','2021-11-10',46.33),(1830020,'Llança de neteja multiraig Classic','10733','HK','2023-11-17',112.30),(1830026,'Pistola de neteja amb filtre ecoPulse','10733','HK','2023-11-17',234.20),(1830027,'Pistola de neteja','10733','HK','2023-11-17',121.10),(1830028,'Pistola multiusos','10733','HK','2023-11-17',45.70),(1830029,'Pistola ruixadora','10733','HK','2023-11-17',65.40),(1830037,'Set Pistola de neteja','10733','HK','2023-11-17',198.90),(1830038,'Set Pistola multiusos','10733','HK','2023-11-17',167.60),(1830039,'Set Pistola ruixadora','10733','HK','2023-11-17',165.30),(1831020,'Llança ruixadora de reg Classic','10634','HK','2023-07-27',112.30),(1831022,'Pistola Comfort per a plantes sensibles','10634','HK','2023-07-27',234.20),(1831024,'Pistola multifuncional Classic','10634','HK','2023-07-27',121.10),(1831026,'Fusell de reg clàssic','10634','HK','2023-07-27',56.20),(1831028,'Aspersor difusor Classic','604993','bellota','2022-05-05',121.10),(1831030,'Set d\'Aspersor Twist de 4 toveres','604993','bellota','2022-05-05',167.60),(1831032,'Aspersor circular','604993','bellota','2022-05-05',112.30),(1831034,'Aspersor circular Divers','604993','bellota','2022-05-05',234.20),(1831036,'Aspersor de 6 superfícies Boogie','604993','bellota','2021-06-15',121.10),(1831038,'Aspersor circular Samba','604993','bellota','2021-06-15',167.60),(1831040,'Aspersor circular Divers','604993','bellota','2021-06-15',112.30),(1831042,'Aspersor circular sectorial','604993','bellota','2021-06-15',121.40),(1831044,'Aspersor Oscil·lant Aqua S','604993','bellota','2022-05-05',121.50),(1831046,'Aspersor Oscil·lant Aqua M','604993','bellota','2022-09-17',121.60),(1831048,'Aspersor amb turbina sectorial','110645','Gardena','2022-09-17',121.70),(1831050,'Aspersor d\'impacte sectorial','110645','Gardena','2022-09-17',121.10),(1831052,'Aspersor per a superfícies asimètriques','110645','Gardena','2022-09-17',198.90),(1831054,'Mànega microperforada 7,5m','110645','Gardena','2022-09-17',45.70),(1831056,'Mànega microperforada 15m','110645','Gardena','2022-09-17',121.60),(1831058,'Mànega microporosa 7,5','110645','Gardena','2021-01-13',85.70),(1831060,'Mànega microporosa 15','110645','Gardena','2021-01-13',99.10),(1831062,'Mànega microporosa 20','110645','Gardena','2021-01-13',120.23),(1831064,'Mànega microporosa 100','110645','Gardena','2021-01-13',220.43),(1831066,'Tisores de Jardí','110645','Gardena','2023-11-17',45.70),(1831068,'Tisora ??de Jardí d\'enclusa','110645','Gardena','2023-11-17',65.40),(1831070,'Tisora ??de Jardí d\'alumini','110645','Gardena','2023-11-17',165.30),(1831072,'Tisora ??premium BP 50','110645','Gardena','2023-11-17',167.60),(1831074,'Tallabarders','110645','Gardena','2023-07-27',112.30),(1831076,'Tallamares 500mm','110645','Gardena','2023-07-27',234.20),(1831078,'Tallamares 680mm','110645','Gardena','2023-07-27',121.10),(1831080,'Tisora ??de perxa d\'enclusa','110645','Gardena','2023-07-27',56.20),(1831082,'Serra Jardí 350mm','110645','Gardena','2022-05-05',121.10),(1831084,'Serra Jardí 325mm','110645','Gardena','2022-05-05',167.60),(1831086,'Destral mà universal 34cm','110645','Gardena','2022-05-05',112.30),(1831088,'Destral mà universal 45cm','110645','Gardena','2022-05-05',234.20),(1831090,'Destral mà universal 60cm','110645','Gardena','2021-06-15',121.10),(1831092,'Serra corba combisystem','332243','Rainbird','2021-06-15',167.60),(1831094,'Retallabarders Elèctric EasyCut 420/45','332243','Rainbird','2021-06-15',112.30),(1831096,'Retallabarders Elèctric EasyCut 450/50','332243','Rainbird','2021-06-15',121.40),(1831098,'Retallabarders Elèctric EasyCut 500/55','332243','Rainbird','2022-05-05',121.50),(1831100,'Retallabarders Elèctric ComfortCut 550/50','332243','Rainbird','2022-09-17',121.60),(1831102,'Retallabarders Elèctric ComfortCut 600/55','332243','Rainbird','2022-09-17',121.70),(1831104,'Retallabarders Elèctric PowerCut 700/65','332243','Rainbird','2022-09-17',121.10),(1831114,'Claus D\'Impacte','1233873','Bahco','2022-09-17',198.90),(1831116,'Carraces','1233873','Bahco','2022-09-17',45.70),(1831118,'Emoladores, Politadores I Polidores','1233873','Bahco','2022-09-17',121.60),(1831120,'Trepants I Cargols','1233873','Bahco','2021-01-13',85.70),(1831122,'Eines De Tall','1233873','Bahco','2021-01-13',99.10),(1831124,'Martells, Reguladores I Marcadors','1233873','Bahco','2021-01-13',120.23),(1831126,'Pistoles De Pintar','1233873','Bahco','2022-10-21',657.99),(1831128,'Eines De Bufat I Neteja','1233873','Bahco','2022-10-21',675.23),(1831132,'Eines Pneumàtiques','1233873','Bahco','2022-10-21',987.20),(1831134,'Linternes Manuals','1233873','Bahco','2021-11-28',54.74),(1831136,'Linternes Per Al Cap','1233873','Bahco','2021-11-28',59.01),(1831138,'Enrotlladors De Cable','1233873','Bahco','2021-11-28',247.50),(1831139,'Llimes De Mecànic','1233873','Bahco','2022-10-21',13.56),(1831140,'Llimes Per A Afilat','1233873','Bahco','2022-10-21',34.54),(1831141,'Escofines','1233873','Bahco','2022-10-21',23.11),(1831142,'Llimes Amb Dents Fressats','1233873','Bahco','2022-10-21',1.23),(1831143,'Llimes D\'Agulla','1233873','Bahco','2022-10-21',13.20),(1831144,'Llimes De Diamant','1233873','Bahco','2022-10-21',23.40),(1831145,'Claus Ajustables “Angleses”','1233873','Bahco','2022-10-21',44.19),(1831146,'Claus Combinades','1233873','Bahco','2022-10-21',40.99),(1831147,'Claus De Carraca','1233873','Bahco','2022-10-21',23.26),(1831148,'Claus Fixes De Dues Boques','1233873','Bahco','2022-10-21',112.30),(1831149,'Claus D\'Estrela De Dues Boques','1233873','Bahco','2021-11-28',234.20),(1831150,'Claus Per A Racors','1233873','Bahco','2021-11-28',121.10),(1831151,'Claus De Cup','1233873','Bahco','2021-11-28',198.90),(1831152,'Claus De Tub','1233873','Bahco','2022-10-21',45.70),(1831153,'Claus Universals','1233873','Bahco','2022-10-21',65.40),(1831154,'Claus De Ganxo Articulades','1233873','Bahco','2022-10-21',165.30),(1831155,'Claus Dinamomètriques Digitals','1233873','Bahco','2022-10-21',167.60),(1831156,'Claus Dinamomètriques Mecàniques','1233873','Bahco','2022-10-21',112.30),(1831157,'Tornadors Dinamomètrics','1233873','Bahco','2022-10-21',234.20),(1831158,'Solucions A Prova D\'Errors','1233873','Bahco','2022-10-21',121.10),(1831159,'Multiplicadors','1233873','Bahco','2022-10-21',56.20),(1831160,'Comprovadors De Par','1233873','Bahco','2022-10-21',121.10),(1831161,'Adaptadors De Parell I Angle','1233873','Bahco','2022-10-21',167.60),(1831162,'Corones De Serra','1233873','Bahco','2021-11-28',112.30),(1831163,'Fulls De Saure','1233873','Bahco','2021-11-28',234.20),(1831164,'Fulls De Calar','1233873','Bahco','2021-11-28',121.10),(1831165,'Fulls Per A Serres Circulars','1233873','Bahco','2022-10-21',167.60),(1831166,'Discs Abrasius','1233873','Bahco','2022-10-21',112.30),(1831167,'Serres De Cinta','1233873','Bahco','2022-10-21',121.40),(1831168,'Llimes Rotatives De Carburo','1233873','Bahco','2022-10-21',121.50),(1831169,'Broques','1233873','Bahco','2022-10-21',121.60),(1831170,'Puntes Per Cargolar','1233873','Bahco','2022-10-21',121.70),(1831171,'Eines D\'Impacte','1233873','Bahco','2022-10-21',121.10),(1831172,'Tornadors Ergo Amb Mànec Tri-Component','1233873','Bahco','2022-10-21',198.90),(1831173,'Tornadors Amb Mànec D\'Impacte','1233873','Bahco','2022-10-21',45.70),(1831174,'Tornadors Bahcofit Amb Mànec Bi-Material','1233873','Bahco','2022-10-21',121.60),(1831175,'Tornadors Amb Mànec De Goma','1233873','Bahco','2021-11-28',44.19),(1831176,'Tornadors Amb Mànec De Carraca','1233873','Bahco','2021-11-28',40.99),(1831177,'Tornadors Amb Mànec De Precisió','1233873','Bahco','2021-11-28',23.26),(1831178,'Tornadors Amb Mànec En T','1233873','Bahco','2022-10-21',112.30),(1831179,'Comprovadors Elèctrics','1233873','Bahco','2022-10-21',234.20),(1831180,'Tornadors Portapuntes','1233873','Bahco','2022-10-21',121.10),(1831181,'Tornadors Amb Mànec De Fusta O Plàstic','1233873','Bahco','2022-10-21',198.90),(1831182,'Claus Hexagonals Amb Punta Hexagonal','1233873','Bahco','2022-10-21',45.70),(1831183,'Claus Hexagonals Amb Punta Torx','1233873','Bahco','2022-10-21',65.40),(1831184,'Claus Hexagonals Acodades','1233873','Bahco','2022-10-21',165.30),(1831185,'Claus Hexagonals Multieines','1233873','Bahco','2022-10-21',167.60),(1831186,'Alicats De Tall','1233873','Bahco','2022-10-21',112.30),(1831187,'Alicates Universals','1233873','Bahco','2022-10-21',234.20),(1831188,'Alicats De Manipulació','1233873','Bahco','2021-11-28',121.10),(1831189,'Tenalles Articulades','1233873','Bahco','2021-11-28',56.20),(1831190,'Alicates Per A Roselles','1233873','Bahco','2021-11-28',121.10),(1831191,'Pelacables I Eines Per A Desmuntatge','1233873','Bahco','2022-10-21',167.60),(1831192,'Alicates Per A Terminals','1233873','Bahco','2022-10-21',112.30),(1831193,'Jocs D\'Alicats','1233873','Bahco','2022-10-21',234.20),(1831194,'Mordasses','1233873','Bahco','2022-10-21',121.10),(1831195,'Reguladores','1233873','Bahco','2022-10-21',167.60),(1831196,'Alicates Especials','1233873','Bahco','2022-10-21',112.30),(1831197,'Claus Per A Tubs','1233873','Bahco','2022-10-21',121.40),(1831198,'Eines De Tallaus','1233873','Bahco','2022-10-21',121.50),(1831199,'Eines De Doblat I Conformat','1233873','Bahco','2022-10-21',121.60),(1831200,'Eines De Rebavat','1233873','Bahco','2022-10-21',121.70),(1831201,'Pinces','1233873','Bahco','2021-11-28',121.10),(1831202,'Eines De Soldadura','1233873','Bahco','2021-11-28',198.90),(1831203,'Eines Per A Mecànica De Precisió','1233873','Bahco','2021-11-28',45.70),(1831204,'Fanalet de Fusta','676728','LM','2023-01-20',34.99),(1831205,'Fanalet Jarro','676728','LM','2023-01-20',39.99);
/*!40000 ALTER TABLE `productes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `realitza`
--

DROP TABLE IF EXISTS `realitza`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `realitza` (
  `cod_botiga` int NOT NULL,
  `Ncomanda` int NOT NULL,
  `cod_c` int NOT NULL,
  PRIMARY KEY (`cod_botiga`,`Ncomanda`),
  KEY `fk_BOTIGA_has_COMANDA_COMANDA1` (`Ncomanda`),
  KEY `fk_BOTIGA_has_COMANDA_CLIENT1` (`cod_c`),
  CONSTRAINT `fk_BOTIGA_has_COMANDA_BOTIGA1` FOREIGN KEY (`cod_botiga`) REFERENCES `botiga` (`cod_botiga`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_BOTIGA_has_COMANDA_CLIENT1` FOREIGN KEY (`cod_c`) REFERENCES `client` (`cod_c`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_BOTIGA_has_COMANDA_COMANDA1` FOREIGN KEY (`Ncomanda`) REFERENCES `comanda` (`Ncomanda`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `realitza`
--

LOCK TABLES `realitza` WRITE;
/*!40000 ALTER TABLE `realitza` DISABLE KEYS */;
INSERT INTO `realitza` VALUES (3506,11011310,10020),(12,11011124,10030),(21,11011311,10040),(171,11011125,10050),(578,11011312,10060),(1078,11011126,10070),(160,11011313,10080),(1079,11011127,10090),(173,11011314,10100),(192,11011128,10110),(1061,11011315,10120),(1087,11011129,10130),(4087,11011316,10140),(587,11011130,10150),(1081,11011317,10160),(157,11011131,10170),(158,11011318,10180),(44,11011132,10190),(58,11011319,10200),(176,11011133,10210),(151,11011320,10220),(47,11011134,10230),(1009,11011321,10240),(4009,11011135,10250),(204,11011322,10260),(130,11011136,10270),(114,11011323,10280),(152,11011137,10290),(101,11011324,10300),(167,11011138,10310);
/*!40000 ALTER TABLE `realitza` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `reg`
--

DROP TABLE IF EXISTS `reg`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `reg` (
  `codi_prod` int NOT NULL,
  `abast_sup` decimal(6,2) NOT NULL,
  PRIMARY KEY (`codi_prod`),
  CONSTRAINT `fk_REG_PRODUCTES1` FOREIGN KEY (`codi_prod`) REFERENCES `productes` (`codi_prod`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `reg`
--

LOCK TABLES `reg` WRITE;
/*!40000 ALTER TABLE `reg` DISABLE KEYS */;
INSERT INTO `reg` VALUES (1831026,5.00),(1831028,5.00),(1831030,5.00),(1831032,5.00),(1831034,5.00),(1831036,5.00),(1831038,5.00),(1831040,10.00),(1831042,15.00),(1831044,20.00),(1831046,50.00),(1831048,50.00),(1831050,25.00),(1831052,32.00),(1831054,8.00),(1831056,15.00),(1831058,7.00),(1831060,15.00),(1831062,20.00),(1831064,100.00);
/*!40000 ALTER TABLE `reg` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `treballa`
--

DROP TABLE IF EXISTS `treballa`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `treballa` (
  `cod_botiga` int NOT NULL,
  `DNI` varchar(10) NOT NULL,
  `DATA` date NOT NULL,
  PRIMARY KEY (`DNI`,`DATA`),
  KEY `fk_BOTIGA_has_EMPLEAT_BOTIGA1` (`cod_botiga`),
  CONSTRAINT `fk_BOTIGA_has_EMPLEAT_BOTIGA1` FOREIGN KEY (`cod_botiga`) REFERENCES `botiga` (`cod_botiga`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_BOTIGA_has_EMPLEAT_EMPLEAT1` FOREIGN KEY (`DNI`) REFERENCES `empleat` (`DNI`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `treballa`
--

LOCK TABLES `treballa` WRITE;
/*!40000 ALTER TABLE `treballa` DISABLE KEYS */;
INSERT INTO `treballa` VALUES (12,'11445751U','2019-02-12'),(19,'15485923A','2021-11-10'),(21,'15485887U','2019-02-13'),(44,'15485902E','2021-03-12'),(45,'15485924B','2021-11-11'),(47,'15485906I','2023-05-25'),(49,'15485918V','2021-11-05'),(50,'15485919W','2021-11-06'),(58,'15485903F','2021-03-13'),(60,'15485917T','2021-11-04'),(100,'15485921Y','2021-11-08'),(101,'15485913P','2021-10-31'),(112,'15485920X','2021-11-07'),(114,'15485911N','2021-10-29'),(130,'15485910M','2021-10-28'),(146,'15485922Z','2021-11-09'),(151,'15485905H','2021-03-15'),(152,'15485912U','2021-10-30'),(156,'15485899B','2021-11-19'),(157,'15485900C','2020-02-15'),(158,'15485901D','2020-02-16'),(160,'15485891S','2020-02-06'),(167,'15485914Q','2021-11-01'),(168,'15485915R','2021-11-02'),(171,'15485888P','2019-02-14'),(173,'15485893V','2020-02-08'),(176,'15485904G','2021-03-14'),(187,'11445749M','2019-01-20'),(192,'15485894W','2020-02-09'),(204,'15485909L','2021-10-27'),(503,'15485896Y','2021-11-16'),(578,'15485889Q','2019-02-15'),(587,'15485898A','2020-02-13'),(1001,'15485895X','2021-11-15'),(1009,'15485907J','2020-08-29'),(1024,'15485894W','2021-11-14'),(1059,'15485892T','2021-11-12'),(1061,'15485895X','2020-02-10'),(1072,'15485897Z','2021-11-17'),(1078,'15485890R','2020-02-05'),(1079,'15485892T','2020-02-07'),(1081,'15485899B','2020-02-14'),(1087,'15485896Y','2020-02-11'),(3506,'11445750N','2019-02-11'),(4009,'15485908K','2023-05-27'),(4059,'15485893V','2021-11-13'),(4072,'15485898A','2021-11-18'),(4087,'15485897Z','2020-02-12'),(4168,'15485916S','2021-11-03');
/*!40000 ALTER TABLE `treballa` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zona`
--

DROP TABLE IF EXISTS `zona`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `zona` (
  `cod_botiga` int NOT NULL,
  `cod_zona` int NOT NULL,
  `nom` varchar(45) DEFAULT NULL,
  `superfici` decimal(6,2) DEFAULT NULL,
  PRIMARY KEY (`cod_botiga`,`cod_zona`),
  CONSTRAINT `fk_Zona_botiga` FOREIGN KEY (`cod_botiga`) REFERENCES `botiga` (`cod_botiga`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `zona`
--

LOCK TABLES `zona` WRITE;
/*!40000 ALTER TABLE `zona` DISABLE KEYS */;
INSERT INTO `zona` VALUES (1,1,'ACCESORIS DE REG',10.00),(1,3,'POLVORITZADORS',20.00),(1,4,'EINES DE JARDI',20.00),(1,5,'EINES MANUALS',10.00),(1,6,'EINES PNEUMÀTIQUES',30.00),(1,7,'EINES ELÈCTRIQUES',10.00),(1,8,'MATERIAL IL.LUMINACIÓ',10.00),(23,1,'ACCESORIS DE REG',50.10),(47,1,'ACCESORIS DE REG',75.10),(47,3,'POLVORITZADORS',10.10),(47,4,'EINES DE JARDI',22.00),(51,1,'ACCESORIS DE REG',50.20),(51,3,'POLVORITZADORS',44.00),(51,5,'EINES MANUALS',50.10),(51,6,'EINES PNEUMÀTIQUES',50.20),(51,7,'EINES ELÈCTRIQUES',75.10),(51,8,'MATERIAL IL.LUMINACIÓ',44.00),(63,4,'EINES DE JARDI',22.00),(63,5,'EINES MANUALS',50.20),(63,6,'EINES PNEUMÀTIQUES',75.10),(83,7,'EINES ELÈCTRIQUES',44.00),(83,8,'MATERIAL IL.LUMINACIÓ',50.10),(86,1,'ACCESORIS DE REG',75.10),(87,3,'POLVORITZADORS',10.10),(87,4,'EINES DE JARDI',22.00),(87,5,'EINES MANUALS',50.20),(87,6,'EINES PNEUMÀTIQUES',75.10),(93,7,'EINES ELÈCTRIQUES',44.00),(95,8,'MATERIAL IL.LUMINACIÓ',50.10),(96,1,'ACCESORIS DE REG',50.20),(96,3,'POLVORITZADORS',44.00),(96,4,'EINES DE JARDI',10.10),(102,5,'EINES MANUALS',50.20),(103,6,'EINES PNEUMÀTIQUES',75.10),(104,7,'EINES ELÈCTRIQUES',44.00),(105,1,'ACCESORIS DE REG',50.10),(105,8,'MATERIAL IL.LUMINACIÓ',50.20),(111,3,'POLVORITZADORS',10.10),(112,4,'EINES DE JARDI',22.00),(112,5,'EINES MANUALS',50.20),(112,6,'EINES PNEUMÀTIQUES',75.10),(112,7,'EINES ELÈCTRIQUES',44.00),(117,8,'MATERIAL IL.LUMINACIÓ',50.10),(119,3,'POLVORITZADORS',75.10),(120,3,'POLVORITZADORS',44.00),(121,3,'POLVORITZADORS',10.10),(122,4,'EINES DE JARDI',22.00),(123,3,'POLVORITZADORS',50.20),(124,3,'POLVORITZADORS',75.10),(125,3,'POLVORITZADORS',44.00),(126,8,'MATERIAL IL.LUMINACIÓ',50.10),(127,1,'ACCESORIS DE REG',50.20),(127,2,'DECORACIO',445.00),(127,3,'POLVORITZADORS',22.00),(127,4,'EINES DE JARDI',50.20),(127,5,'EINES MANUALS',75.10),(127,8,'MATERIAL IL.LUMINACIÓ',75.10);
/*!40000 ALTER TABLE `zona` 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-10-23 17:57:32
 

MySQL online editor

Write, Run & Share MySQL queries online using OneCompiler's MySQL online editor and compiler for free. It's one of the robust, feature-rich online editor and compiler for MySQL. Getting started with the OneCompiler's MySQL editor is really simple and pretty fast. The editor shows sample boilerplate code when you choose language as 'MySQL' and start writing queries to learn and test online without worrying about tedious process of installation.

About MySQL

MySQL is a open-source, free and very popular relational database management system which is developed, distributed and supported by Oracle corporation.

Key Features:

  • Open-source relational database management systems.
  • Reliable, very fast and easy to use database server.
  • Works on client-server model.
  • Highly Secure and Scalable
  • High Performance
  • High productivity as it uses stored procedures, triggers, views to write a highly productive code.
  • Supports large databases efficiently.
  • Supports many operating systems like Linux*,CentOS*, Solaris*,Ubuntu*,Windows*, MacOS*,FreeBSD* and others.

Syntax help

Commands

1. CREATE

CREATE TABLE table_name (
                column1 datatype,
                column2 datatype,
                ....);

Example

CREATE TABLE EMPLOYEE (
  empId INTEGER PRIMARY KEY,
  name TEXT NOT NULL,
  dept TEXT NOT NULL
);

2. ALTER

ALTER TABLE Table_name ADD column_name datatype;

Example

INSERT INTO EMPLOYEE VALUES (0001, 'Dave', 'Sales');

3. TRUNCATE

TRUNCATE table table_name;

4. DROP

DROP TABLE table_name;

5. RENAME

RENAME TABLE table_name1 to new_table_name1; 

6. COMMENT

Single-Line Comments:

 --Line1;

Multi-Line comments:

   /* Line1,
   Line2 */

DML Commands

1. INSERT

INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...);

Note: Column names are optional.

Example

INSERT INTO EMPLOYEE VALUES (0001, 'Ava', 'Sales');

2. SELECT

SELECT column1, column2, ...
FROM table_name
[where condition]; 

Example

SELECT * FROM EMPLOYEE where dept ='sales';

3. UPDATE

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition; 

Example

UPDATE EMPLOYEE SET dept = 'Sales' WHERE empId='0001'; 

4. DELETE

DELETE FROM table_name where condition;

Example

DELETE from EMPLOYEE where empId='0001'; 

Indexes

1. CREATE INDEX

  CREATE INDEX index_name on table_name(column_name);
  • To Create Unique index:
  CREATE UNIQUE INDEX index_name on table_name(column_name);

2. DROP INDEX

DROP INDEX index_name ON table_name;

Views

1. Create a View

Creating a View:
CREATE VIEW View_name AS 
Query;

2. How to call view

SELECT * FROM View_name;

3. Altering a View

ALTER View View_name AS 
Query;

4. Deleting a View

DROP VIEW View_name;

Triggers

1. Create a Trigger

CREATE TRIGGER trigger_name trigger_time trigger_event
    ON tbl_name FOR EACH ROW [trigger_order] trigger_body
/* where
trigger_time: { BEFORE | AFTER }
trigger_event: { INSERT | UPDATE | DELETE }
trigger_order: { FOLLOWS | PRECEDES } */

2. Drop a Trigger

DROP TRIGGER [IF EXISTS] trigger_name;

Stored Procedures

1. Create a Stored Procedure

CREATE PROCEDURE sp_name(p1 datatype)
BEGIN
/*Stored procedure code*/
END;

2. How to call Stored procedure

CALL sp_name;

3. How to delete stored procedure

DROP PROCEDURE sp_name;

Joins

1. INNER JOIN

SELECT * FROM TABLE1 INNER JOIN TABLE2 where condition;

2. LEFT JOIN

SELECT * FROM TABLE1 LEFT JOIN TABLE2 ON condition;

3. RIGHT JOIN

SELECT * FROM TABLE1 RIGHT JOIN TABLE2 ON condition;

4. CROSS JOIN

SELECT select_list from TABLE1 CROSS JOIN TABLE2;