· 4 years ago · Jun 04, 2021, 10:34 AM
1-- MySQL dump 10.13 Distrib 8.0.25, for Linux (x86_64)
2--
3-- Host: localhost Database: aplazarme
4-- ------------------------------------------------------
5-- Server version 8.0.25-0ubuntu0.20.04.1
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `cliente`
20--
21
22DROP TABLE IF EXISTS `cliente`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!50503 SET character_set_client = utf8mb4 */;
25CREATE TABLE `cliente` (
26 `id` int NOT NULL AUTO_INCREMENT,
27 `nombre` varchar(200) DEFAULT NULL,
28 `apellidos` varchar(200) DEFAULT NULL,
29 `empresa` varchar(200) DEFAULT NULL,
30 `email` varchar(200) DEFAULT NULL,
31 `telefono` varchar(100) DEFAULT NULL,
32 PRIMARY KEY (`id`)
33) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
34/*!40101 SET character_set_client = @saved_cs_client */;
35
36--
37-- Dumping data for table `cliente`
38--
39
40LOCK TABLES `cliente` WRITE;
41/*!40000 ALTER TABLE `cliente` DISABLE KEYS */;
42INSERT INTO `cliente` VALUES (3,'Jamalia','Camacho','Morbi Tristique Senectus Foundation','Sed.congue@sitametmassa.com','1-273-932-4575'),(4,'Linus','Mcguire','At PC','convallis@Loremipsumdolor.org','1-154-108-1806'),(5,'Callie','Savage','Gravida Sagittis Industries','ac@urna.com','1-847-271-7119'),(6,'Ishmael','Johns','Imperdiet Ornare In Consulting','quis.urna.Nunc@ipsumDonecsollicitudin.edu','1-747-115-9013'),(7,'Malik','Reilly','Sed Hendrerit Incorporated','vel.faucibus.id@rhoncusProinnisl.co.uk','1-481-671-4490'),(8,'Nehru','Camacho','Risus Institute','Morbi.vehicula@justositamet.edu','1-610-349-4605'),(9,'Salvador','Marsh','Lorem Foundation','convallis@blandit.com','1-919-122-7793'),(10,'Alan','Fox','Lobortis Tellus Justo Ltd','sed.leo.Cras@Morbiaccumsan.net','1-403-464-4947'),(11,'Ann','Dillard','Fusce Feugiat Lorem Industries','eu.metus.In@euduiCum.edu','1-555-646-3504'),(12,'Sade','Doyle','Tempor Est Ac Foundation','et.euismod@tempuslorem.net','1-637-664-4369'),(13,'Noah','Mcintyre','Leo PC','enim.nec.tempus@senectuset.ca','1-502-134-5477'),(14,'Madonna','Roberts','Sed Auctor LLC','in@Nulla.edu','1-749-929-2523'),(15,'Heather','Marquez','Amet LLC','luctus.et@velfaucibusid.edu','1-868-464-2890'),(16,'Yasir','Dawson','Imperdiet Erat Institute','non.leo.Vivamus@variusNam.ca','1-337-796-6815'),(17,'Jameson','Randolph','Convallis Convallis Limited','in.tempus@luctus.net','1-455-240-7489'),(18,'Cade','Shannon','Sit Incorporated','elementum.lorem@Nuncsedorci.org','1-479-851-0374'),(19,'Ayanna','Downs','Cubilia Foundation','orci.quis.lectus@miAliquam.net','1-722-646-2046'),(20,'Damon','Coleman','Ante Ipsum Industries','litora@Maurisquis.com','1-245-117-2769'),(21,'Evangeline','Robles','Leo Elementum Consulting','Donec.tempus.lorem@fringillaDonec.co.uk','1-452-394-2329'),(22,'Lyle','Fowler','Lacus Vestibulum LLP','natoque@sapien.com','1-217-428-9777'),(23,'Amity','Copeland','Sed Foundation','iaculis.nec@egestasligulaNullam.org','1-534-711-1666'),(24,'Danielle','Warner','Magnis Dis LLP','feugiat@dis.com','1-718-779-7090'),(25,'Tarik','Mcintosh','Velit In Aliquet Consulting','et.ultrices@lectus.co.uk','1-120-230-4274'),(26,'Hiram','Noble','Molestie Arcu Corp.','diam.Duis@Phasellusnulla.net','1-714-250-1229'),(27,'Cally','Slater','Sit PC','ipsum.leo@eu.net','1-537-997-0644'),(28,'Oleg','Dennis','Ornare Limited','leo@mauris.org','1-715-929-6422'),(29,'Geraldine','Tyson','Magna Praesent Interdum Corporation','sem.Nulla.interdum@erateget.edu','1-879-764-9135'),(30,'Tiger','Warner','Maecenas Ornare Industries','purus@Duismienim.net','1-913-146-9520'),(31,'Portia','Patton','Nisi Dictum Augue Corp.','molestie.orci.tincidunt@lobortisultricesVivamus.edu','1-715-839-6447'),(32,'Walter','Graves','Mus Proin Vel Industries','elit@non.net','1-462-479-6214'),(33,'Jordan','Johns','Donec Feugiat Metus Incorporated','ut.sem.Nulla@nequeNullamnisl.ca','1-352-313-8696'),(34,'Flavia','Barnett','Ipsum Suspendisse Corporation','Suspendisse.non.leo@Morbi.net','1-640-325-7068'),(35,'Ima','Leon','Convallis Foundation','nunc.interdum@rutrum.edu','1-318-505-7489'),(36,'Leslie','Herman','Eu Nibh Vulputate Foundation','amet@eu.edu','1-540-496-6417'),(37,'Mara','Williams','Aliquet Phasellus Industries','cursus.Integer@inceptos.org','1-852-906-0651'),(38,'Jessica','Moses','Id Libero PC','enim.nisl@turpisegestasFusce.net','1-456-435-5130'),(39,'Quinlan','Johnston','Tempor Erat Ltd','fermentum.fermentum.arcu@iaculisodio.net','1-601-312-9668'),(40,'Jason','Mitchell','Vivamus Euismod LLC','pede@libero.net','1-835-877-4185'),(41,'Kevin','Stark','Ut Nulla Associates','dolor@sagittisplaceratCras.com','1-919-774-0726'),(42,'Martina','Moore','Eu Inc.','nibh@nuncQuisque.edu','1-757-391-4704'),(43,'Brenda','Blake','Mauris Vel Turpis Associates','Cras@infelis.net','1-246-820-2363'),(44,'Carla','Phelps','Sodales Corporation','arcu.Vestibulum.ut@habitantmorbitristique.ca','1-877-251-3412'),(45,'Benedict','Preston','Nonummy Incorporated','ante.dictum.cursus@Namconsequat.org','1-995-352-7406'),(46,'Marsden','Dejesus','Donec Nibh Industries','egestas@eleifendnec.org','1-524-442-3740'),(47,'Keane','Eaton','Nam Consequat Dolor LLP','volutpat.Nulla.dignissim@Aliquam.com','1-726-748-9978'),(48,'Belle','Stone','Sem Molestie Sodales Corporation','Maecenas.mi@Suspendissesed.org','1-293-376-2578'),(49,'Mara','Vang','Cum Sociis Company','neque@inmagna.ca','1-195-496-9193'),(50,'Walter','Spencer','Accumsan Interdum Ltd','non@arcuvel.com','1-515-233-6690'),(51,'Leigh','Whitney','Semper Pretium PC','non.lobortis@MorbivehiculaPellentesque.net','1-778-860-1672'),(52,'Noble','Salazar','Enim Institute','a@egestas.ca','1-908-439-4453'),(53,'Davis','Norman','Facilisis Vitae Orci Ltd','erat.neque.non@mauris.net','1-577-876-4423'),(54,'Ariana','Randolph','Tristique Ac Company','metus@dictum.org','1-386-709-2381'),(55,'Rae','English','Vel Inc.','in@iaculisodioNam.edu','1-622-856-9651'),(56,'Adrienne','Hammond','Varius Et Industries','euismod.est.arcu@eratsemper.edu','1-936-635-2550'),(57,'Destiny','Shannon','Mauris Ipsum Porta Ltd','lobortis.nisi.nibh@nuncnullavulputate.com','1-836-701-5220'),(58,'Flynn','Harding','Integer Ltd','eget.dictum@Nullamfeugiatplacerat.net','1-763-495-4812'),(59,'Zeus','York','Enim Mi Tempor Ltd','at@ipsumSuspendissenon.org','1-205-355-6350'),(60,'Jana','Bradford','Luctus Aliquet PC','Integer@vitae.com','1-225-575-2947'),(61,'Basil','Mueller','Elit Incorporated','pede@blanditenim.org','1-480-299-7458'),(62,'Sonia','Vasquez','Nostra Per Incorporated','Nulla.tempor@lobortismaurisSuspendisse.org','1-438-376-1502'),(63,'Cameran','Warren','Id Magna Company','sodales@orci.net','1-891-175-8404'),(64,'Carson','Calhoun','Sed Corporation','facilisis.lorem@enimcondimentum.ca','1-698-740-1508'),(65,'Gavin','Livingston','Eros Nam Foundation','Nulla.facilisis.Suspendisse@nequeet.ca','1-864-703-9842'),(66,'Callie','Cochran','Mi LLP','vitae.purus.gravida@loremvitae.net','1-971-185-2119'),(67,'Kiona','Burnett','Et LLC','mauris.id@sagittisNullam.edu','1-342-566-2250'),(68,'Petra','Williamson','Phasellus LLP','vulputate@acorci.org','1-565-727-5571'),(69,'Karleigh','Cunningham','Tincidunt Vehicula Risus Consulting','ut@ridiculusmusAenean.ca','1-566-879-9140'),(70,'Nora','Swanson','Nulla Tincidunt Neque Incorporated','placerat.Cras@quisdiamPellentesque.edu','1-500-292-7763'),(71,'Odysseus','Mack','Curabitur Consequat Corporation','venenatis.vel@dignissimlacusAliquam.ca','1-891-844-2497'),(72,'Idola','Clemons','Nisl Incorporated','imperdiet.ornare.In@Proineget.co.uk','1-446-380-7481'),(73,'Camilla','Reeves','Eu Incorporated','mollis.non.cursus@quamquis.co.uk','1-812-130-4600'),(74,'Ivor','Dean','Nisl LLP','pretium@sed.co.uk','1-338-595-3895'),(75,'Ezekiel','Obrien','Rutrum Eu Ultrices Corp.','sed@in.org','1-511-362-9788'),(76,'Savannah','Chandler','Etiam Vestibulum Limited','dui@Maurisquis.net','1-299-612-8190'),(77,'Cheyenne','Beard','Eros Non LLP','at.arcu.Vestibulum@Mauris.net','1-368-735-3169'),(78,'Sylvia','Irwin','Cursus Vestibulum Mauris Corporation','pellentesque.tellus@ipsumnunc.com','1-882-647-9551'),(79,'Amos','Case','Enim Non Nisi Institute','inceptos.hymenaeos.Mauris@Aliquam.net','1-796-657-9553'),(80,'Aiko','Anderson','Enim Consequat Purus Company','magna.Ut@ataugueid.org','1-264-859-1369'),(81,'Quemby','Walton','Ligula Incorporated','hendrerit.id@Curabitur.org','1-883-716-6838'),(82,'Brooke','Barrera','Nibh Limited','est@NullamenimSed.org','1-130-105-2741'),(83,'Macaulay','Oneil','Eget Corp.','egestas.rhoncus.Proin@adipiscingelit.org','1-100-205-6631'),(84,'Boris','Sanders','Ante Blandit Viverra Ltd','nunc.est@nuncinterdumfeugiat.ca','1-808-838-6207'),(85,'Kyra','Hartman','Ridiculus Ltd','amet.lorem@ante.co.uk','1-154-489-4026'),(86,'Aaron','Dominguez','Magna Foundation','cubilia@bibendumsedest.org','1-753-143-1328'),(87,'Ursa','Salinas','Enim Consulting','Nulla.eget@ligula.org','1-441-578-8160'),(88,'Jordan','Brock','Facilisis Associates','ipsum@auctornunc.org','1-495-996-5063'),(89,'Reese','Houston','Consectetuer Adipiscing Elit Foundation','aliquet.molestie@sitamet.net','1-340-167-8257'),(90,'Lenore','Charles','Purus Mauris A LLP','suscipit@scelerisquemollisPhasellus.org','1-551-721-4582'),(91,'Hedley','Mccray','Turpis In Consulting','magna.Suspendisse.tristique@Lorem.com','1-313-626-8870'),(92,'Conan','Rodriquez','Facilisis Institute','at@Vivamus.co.uk','1-990-340-5380'),(93,'Dexter','Moran','Amet Consectetuer Adipiscing Consulting','amet.faucibus.ut@a.ca','1-751-967-1967'),(94,'Darryl','Clayton','Integer Id LLC','ipsum@fringillaporttitor.net','1-281-923-0568'),(95,'Marsden','Gonzalez','Ut Molestie Corporation','ultrices.sit.amet@feliseget.edu','1-848-544-7292'),(96,'Sage','Payne','Risus Odio Inc.','dolor@loremtristiquealiquet.net','1-141-804-8298'),(97,'Jackson','Holloway','Ornare Sagittis Felis LLC','eget.varius.ultrices@orcisem.com','1-615-742-1334'),(98,'Liberty','Erickson','Donec Felis Foundation','non.justo@Loremipsum.edu','1-360-569-7955'),(99,'Kenyon','Guzman','Est Ac Facilisis Ltd','Cum.sociis.natoque@euturpisNulla.com','1-286-405-9236'),(100,'Colton','Kirkland','Arcu Corporation','pede@Etiam.edu','1-894-330-5727'),(101,'Allistair','Irwin','Eu Nibh Institute','eu@dolorelitpellentesque.com','1-236-127-9668'),(102,'Amelia','Bruce','A Corporation','Suspendisse.non@gravidamolestiearcu.edu','1-568-269-4728'),(130,'Kessie','Reyes','CRSCaonaville','kreyes@crscaonaville.com','1-177-856-3064'),(131,'Oliver','Richard','Facility Second','orichard@facilitysecond.com','1-145-432-4034'),(132,'Bryan','Sunders','Ulla Corp','bsunders@ullacorp.com','1-477-566-6066'),(133,'Mariano','Sánchez','PP-SOE','mariano.sanchez@pp-soe.com','919999999'),(134,'Pedro','Rajoy','PP-SOE','pedro.rajoy@pp-soe.com','919999999');
43/*!40000 ALTER TABLE `cliente` ENABLE KEYS */;
44UNLOCK TABLES;
45
46--
47-- Table structure for table `pedido`
48--
49
50DROP TABLE IF EXISTS `pedido`;
51/*!40101 SET @saved_cs_client = @@character_set_client */;
52/*!50503 SET character_set_client = utf8mb4 */;
53CREATE TABLE `pedido` (
54 `id` int NOT NULL AUTO_INCREMENT,
55 `id_cliente` int DEFAULT NULL,
56 `cantidad` int DEFAULT NULL,
57 `precio` float DEFAULT NULL,
58 `total` float DEFAULT NULL,
59 PRIMARY KEY (`id`)
60) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
61/*!40101 SET character_set_client = @saved_cs_client */;
62
63--
64-- Dumping data for table `pedido`
65--
66
67LOCK TABLES `pedido` WRITE;
68/*!40000 ALTER TABLE `pedido` DISABLE KEYS */;
69INSERT INTO `pedido` VALUES (2,3,30,300,9000),(3,10,50,100,5000),(4,60,20,3000,60000);
70/*!40000 ALTER TABLE `pedido` ENABLE KEYS */;
71UNLOCK TABLES;
72/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
73
74/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
75/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
76/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
77/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
78/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
79/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
80/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
81
82-- Dump completed on 2021-06-04 10:24:06
83