Base de datos de tenda

Enunciado

A base de datos tendaBD serve para controlar as vendas dunha cadea de tendas. Gárdanse nela os datos das vendas que se realizan, das tendas nas que se fan as vendas, dos artigos vendidos, e dos clientes.

Tarefa

Executa o seguinte script para mediante DDL xenerar o esquema da base de datos e con DML cargar con datos as diferentes táboas.

-- MySQL dump 10.13  Distrib 5.6.17, for Win32 (x86)
--
-- Host: localhost    Database: tendabd
-- ------------------------------------------------------
-- Server version	5.6.17

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!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 */;

CREATE DATABASE  IF NOT EXISTS `xxx_tendaBD` /*!40100 DEFAULT CHARACTER SET latin1 COLLATE latin1_spanish_ci */;
USE `xxx_tendaBD`;
--
-- Table structure for table `artigos`
--

DROP TABLE IF EXISTS `artigos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `artigos` (
  `art_codigo` char(8) NOT NULL,
  `art_nome` varchar(120) NOT NULL DEFAULT '',
  `art_peso` smallint(5) unsigned DEFAULT NULL,
  `art_color` char(20) DEFAULT NULL,
  `art_pc` decimal(8,2) DEFAULT NULL COMMENT 'prezo de compra do artigo',
  `art_pv` decimal(8,2) NOT NULL COMMENT 'prezo de venta do artigo',
  `art_provedor` smallint(6) DEFAULT NULL,
  `art_stock` smallint(5) unsigned DEFAULT NULL COMMENT 'número de unidades do artigo disponibles no almacén',
  `art_alta` date NOT NULL COMMENT 'data na que se deu de alta o artigo',
  `art_baixa` date DEFAULT NULL COMMENT 'data na que se deu de baixa o artigo',
  `art_ultima_actualizacion` date DEFAULT NULL COMMENT 'data da última vez en que se fixeron cambios nos dato do artigo',
  PRIMARY KEY (`art_codigo`),
  KEY `art_nome` (`art_nome`),
  KEY `art_provedor` (`art_provedor`),
  CONSTRAINT `fk_artigos_provedores` FOREIGN KEY (`art_provedor`) REFERENCES `provedores` (`prv_id`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `artigos`
--

LOCK TABLES `artigos` WRITE;
/*!40000 ALTER TABLE `artigos` DISABLE KEYS */;
INSERT INTO `artigos` VALUES ('0713242','READYNAS 102 (1X1TB DS) EXT',6228,NULL,240.40,300.50,7,3,'2011-04-04',NULL,NULL),('0713245','READYNAS 312 (1X2TB DS) EXT',8204,NULL,461.20,576.50,7,2,'2011-06-16',NULL,NULL),('0713249','READYNAS 102 (2X3TB DS) EXT',9848,NULL,446.80,558.50,7,2,'2011-08-03',NULL,NULL),('0713263','READYNAS 314 (4X3TB ENT) EXT',3287,NULL,1752.58,2190.73,7,2,'2012-05-04',NULL,NULL),('07714M0','HDD SATA III 500GB 7200RPM',7187,NULL,117.30,146.62,12,4,'2010-08-27',NULL,NULL),('0772VS2','HD SATA 3G 250GB 7200RPM',2643,NULL,210.83,263.54,12,1,'2012-05-11',NULL,NULL),('07735Y4','HD SATA 6G 1TB 7200RPM',5521,NULL,400.40,500.50,12,4,'2009-07-19',NULL,NULL),('077MR98','DVD-RW SUPER',3469,NULL,89.44,111.80,12,1,'2009-06-28',NULL,NULL),('077MS34','HD SATA 3G 500GB 7200RPM',1123,NULL,196.99,246.24,12,14,'2010-08-03',NULL,NULL),('077PC04','HD SATA 3G 500GB 7200RPM',1636,NULL,196.99,246.24,12,7,'2010-07-08',NULL,NULL),('077WN45','HD SATA 3G 2TB 7200RPM',974,NULL,407.99,509.99,12,7,'2012-02-04',NULL,NULL),('1410767','HD BLACK 160GB INT - SATA 7200RPM',3771,'NEGRO',42.78,53.47,13,31,'2009-10-31',NULL,NULL),('1410768','HD BLACK 250GB INT - SATA 7200RPM',2888,'NEGRO',42.78,53.47,13,24,'2010-03-18',NULL,NULL),('1410769','HD BLACK 320GB INT - SATA 7200RPM',937,'NEGRO',44.53,55.66,13,33,'2013-01-31',NULL,NULL),('1411058','HD WD RE 2TB SATA 7200RPM',1797,NULL,152.79,190.99,13,39,'2010-11-28',NULL,NULL),('1411068','HD BLACK 1TB 7200RPM',5715,'NEGRO',68.11,85.14,13,69,'2009-05-23',NULL,NULL),('1411127','HD WD RE 250GB SATA 7200RPM',2424,NULL,61.11,76.39,13,52,'2012-06-27',NULL,NULL),('1411131','HD WD RE 1TB SATA 7200RPM',4617,NULL,82.94,103.67,13,32,'2011-01-07',NULL,NULL),('1411134','HD BLUE 750GB SATA2 5400RPM',5917,NULL,45.40,56.75,13,168,'2012-10-02',NULL,NULL),('1411158','HD AV GREEN 2TB',881,NULL,82.47,103.09,13,69,'2009-09-04',NULL,NULL),('2359569','TONER AMARILLO C1100',8556,'AMARELO',122.06,152.58,22,1,'2010-04-18',NULL,NULL),('2359982','TONER MAGENTA  ACULASER C4200',2918,'MAGENTA',170.40,213.00,22,1,'2012-11-15',NULL,NULL),('2359986','TONER NEGRO  ACULASER C4200',8419,'NEGRO',59.58,74.48,22,2,'2010-04-06',NULL,NULL),('235B624','TONER YELLOW ACULASER CX21N/NF',3729,'AMARELO',129.33,161.66,22,3,'2011-04-23',NULL,NULL),('235E508','TONER BLACK ACULASER C1700',5066,'NEGRO',49.50,61.88,22,2,'2009-07-13',NULL,NULL),('235E509','TONER CYAN ACULASER C1700',2694,'CYAN',50.01,62.51,22,1,'2011-07-09',NULL,NULL),('235E510','TONER MAGENTA ACULASER C1700',5594,'MAGENTA',50.01,62.51,22,1,'2011-12-01',NULL,NULL),('242C283','TONER CRG 701 BLACK LBP-5200',2059,'NEGRO',65.84,82.30,23,1,'2009-10-09',NULL,NULL),('242E446','TONER CRG 707 CYAN',8763,'CYAN',55.71,69.64,23,3,'2010-08-25',NULL,NULL),('242G454','TONER CRG 711 LBP5300 LBP5360',7987,NULL,91.88,114.85,23,10,'2009-08-13',NULL,NULL),('242G457','TONER CRG 711 LBP5300 LBP5360',2897,NULL,118.15,147.69,23,2,'2010-11-06',NULL,NULL),('242L743','TONER CRG 717 YELLOW MF8450',3145,'AMARILLO',89.26,111.57,23,2,'2010-09-29',NULL,NULL),('242L760','TONER CRG 716 YELLOW 5050 5050N',3678,'AMARELO',43.90,54.87,23,16,'2009-12-18',NULL,NULL),('242L762','TONER CRG 716 BLACK 5050 5050N',1592,'NEGRO',47.76,59.70,23,42,'2012-06-26',NULL,NULL),('242L763','TONER CRG 716 CYAN LBP 5050 5050N',7145,'CYAN',43.90,54.87,23,15,'2009-12-10',NULL,NULL),('242L764','TONER CRG 716 MAGENTA 5050 5050N',1436,'MAGENTA',43.90,54.87,23,4,'2012-11-12',NULL,NULL),('242N561','TONER YELLOW CRG 718 7200CDN',2972,'AMARELO',79.61,99.51,23,7,'2013-04-06',NULL,NULL),('2704123','SAI SMART-UPS 1500VA 2U RACK',7693,NULL,381.85,477.31,4,9,'2012-10-26',NULL,NULL),('2704148','SAI SMART-UPS 1000VA 2U RACK',4772,NULL,294.51,368.14,4,3,'2009-09-15',NULL,NULL),('2704342','SAI SMART-UPS XL 3000VA RM 3U RACK',1428,NULL,1389.90,1737.37,4,2,'2009-06-26',NULL,NULL),('2704423','SAI SMART-UPS RT 8000VA TOWER',4178,NULL,3305.92,4132.40,4,3,'2012-09-19',NULL,NULL),('2704488','SAI APC SMART-UPS RT 6000',6546,NULL,2537.54,3171.93,4,4,'2010-06-22',NULL,NULL),('2704727','SAI SMART-UPS 3000VA ',6773,NULL,1218.14,1522.68,4,4,'2012-08-19',NULL,NULL),('2752951','BUSINESS STORAGE 2BAY NAS 2TB 2X 1TB',3815,NULL,141.50,176.87,8,1,'2013-02-08',NULL,NULL),('2752959','BUSINESS STORAGE 4BAY NAS 4TB 4X 1TB',2910,NULL,488.12,610.15,8,5,'2012-09-01',NULL,NULL),('404N216','DVD-WRITER EXTERNAL SUPER',7988,NULL,56.98,71.23,14,1,'2013-02-02',NULL,NULL),('404R440','PORTATIL PORTEGE 128GB SSD 8GB',9540,NULL,1120.21,1400.26,14,17,'2010-10-11',NULL,NULL),('404R442','PORTATIL PORTEGE Z930 128GB SSD 4GB',4108,NULL,777.30,971.63,14,1,'2013-02-03',NULL,NULL),('404S109','PORTATIL TECRA R950-11G 320GB 4GB',2183,NULL,569.34,711.67,14,98,'2010-02-03',NULL,NULL),('404S523','PORTATIL TECRA R940-1CV 4 GB 320GB',4498,NULL,777.30,971.63,14,3,'2010-03-27',NULL,NULL),('404S524','NOTEBOOK TECRA R940-1CX4GB 320GB',5828,NULL,777.30,971.63,14,5,'2011-03-09',NULL,NULL),('404S890','PORTATIL SATL955D-108 AMD 640GB 4GB',252,NULL,422.73,528.41,14,33,'2011-07-27',NULL,NULL),('404S891','PORTATIL SATELLITE P875 2TB 16GB 17IN W8',2323,NULL,1157.14,1446.43,14,12,'2010-04-10',NULL,NULL),('404S893','PORTATIL SATELLITE-U840W 128GB SSD 4GB',1871,NULL,781.56,976.95,14,74,'2010-12-24',NULL,NULL),('404S903','PORTATIL TECRA R940-1CV 320GB 4GB',4637,NULL,777.30,971.63,14,16,'2011-05-25',NULL,NULL),('404S905','PORTATIL PORTEGE R930-109 500GB 4GB',1272,NULL,793.17,991.46,14,10,'2012-12-13',NULL,NULL),('404S913','NOTEBOOK PORT Z930 SSD-143 SSD 4GB',2425,NULL,699.72,874.65,14,27,'2010-01-08',NULL,NULL),('404T635','PORTATIL SATELLITE-U840W-10M',4633,NULL,746.01,932.51,20,1,'2010-03-03',NULL,NULL),('404T668','PORTATIL SATL955D-108 APU/A6-4455M',6202,NULL,403.60,504.50,14,2,'2010-08-10',NULL,NULL),('404T925','PORTATIL TECRA R940-3G-1CX 320GB 4GB',6160,NULL,785.15,981.44,14,15,'2009-05-20',NULL,NULL),('404T988','PORTATIL PORTEGE R930 256SSD 8GB P',1218,NULL,1201.39,1501.74,14,55,'2010-11-21',NULL,NULL),('404U040','PORTATIL TECRA R950 320GB 4GB',7688,NULL,563.59,704.49,14,17,'2009-07-04',NULL,NULL),('404U264','PORTATIL SATELLITE U840T 500GB 6GB',5131,NULL,763.65,954.56,14,128,'2010-09-12',NULL,NULL),('4064078','MONITOR 22IN LED 1680X1050 16:10',408,NULL,135.23,169.04,1,49,'2012-11-23',NULL,NULL),('4065091','DVD-WRITER  24X  INT',580,NULL,13.05,16.31,1,3599,'2013-05-24',NULL,NULL),('4065115','MONITOR 29IN LED IPS 2560X1080 21:9',5708,NULL,424.86,531.07,1,11,'2011-08-31',NULL,NULL),('4065174','DVD-WRITER  24X SATA INT',9103,NULL,14.50,18.13,1,58,'2011-05-28',NULL,NULL),('4065200','MONITOR 23IN LED IPS 1920X1080 16:9',4798,NULL,137.33,171.66,1,8,'2013-02-13',NULL,NULL),('4065204','MONITOR 24IN LED IPS 1920X1200 16:10',9783,NULL,224.17,280.21,1,13,'2010-10-30',NULL,NULL),('4065240','MONITOR 27IN LED IPS 1920X1080',2730,NULL,211.50,264.37,1,21,'2011-08-29',NULL,NULL),('4065260','MONITOR 22IN LED IPS 1920X1080 16:9',3801,NULL,126.70,158.38,1,43,'2011-01-28',NULL,NULL),('4065263','MONITOR 23IN LED 1920X1080 16:9',7662,NULL,126.82,158.53,1,44,'2013-02-08',NULL,NULL),('4065265','MONITOR 24IN LED 1920X1080 16:9',1378,NULL,124.15,155.19,1,57,'2011-09-17',NULL,NULL),('4065298','MONITOR 20IN LED 1600X900 16:9',7216,NULL,73.45,91.81,1,230,'2012-02-13',NULL,NULL),('4065316','MONITOR 23IN LED-TV IPS 1920X1080 16:9',4722,NULL,187.97,234.96,1,5,'2011-11-28',NULL,NULL),('479V375','MONITOR 27IN LED 2560X1440 16:9',4774,NULL,845.90,1057.38,2,4,'2012-06-08',NULL,NULL),('558L097','NOTEBOOK VAIO SVD1Q2EB 128GB SSD 4GB',8300,NULL,951.56,1189.45,21,12,'2012-12-07',NULL,NULL),('558L508','PORTATIL VAIO SVE3B1EW 500GB 4GB',1545,NULL,366.69,458.36,21,263,'2011-11-18',NULL,NULL),('558L509','PORTATIL VAIO SVE3E9EB 500GB 4GB',4641,NULL,515.48,644.35,21,45,'2012-10-15',NULL,NULL),('558L510','PORTATIL VAIO SVE3F4EW 750GB 6GB',4288,NULL,664.97,831.21,21,375,'2010-10-15',NULL,NULL),('5844105','SHARECENTER 1-BAY SATA EXT',946,NULL,61.13,76.41,9,4,'2009-10-19',NULL,NULL),('6181508','STORCENTER PX4-300R 8 TB 4 X 2TB',1787,NULL,1085.62,1357.03,10,1,'2012-07-30',NULL,NULL),('6181517','STORCENTER PX6-300D 18 TB 6 X 3TB',5432,NULL,1283.95,1604.94,10,2,'2013-03-07',NULL,NULL),('6181677','STORCENTER IX2 2BAY 2TB(2X1)',7141,NULL,185.50,231.87,10,8,'2011-12-19',NULL,NULL),('6181740','STORCENTER PX2-300D 6TB 2 X 3TB',6807,NULL,746.18,932.72,10,5,'2012-03-11',NULL,NULL),('8652V77','MONITOR 22IN LED 1680X1050 16:9',8207,NULL,121.98,152.47,3,30,'2012-01-07',NULL,NULL),('8652V94','MONITOR 19IN LED 1440X900 16:10',2992,NULL,111.04,138.80,3,6,'2011-08-30',NULL,NULL),('8653D08','MONITOR 22IN LED 1680X1050 16:10',2966,NULL,139.63,174.54,3,13,'2012-10-12',NULL,NULL),('8653E96','MONITOR 24IN LED 1920X1080 16:9',9424,NULL,111.88,139.85,3,3,'2012-08-03',NULL,NULL),('8653L70','PC ASPIRE XC600  500GB 4GB NVD1',9526,NULL,323.03,403.79,3,10,'2011-08-24',NULL,NULL),('8653S15','PC ASPIRE AXC600 500GB 4GB ATI1',3576,NULL,355.62,444.52,3,32,'2011-07-31',NULL,NULL),('8653S16','PC ASPIRE AX3470  2TB 6GB ATI2',2207,NULL,395.22,494.02,3,333,'2010-06-23',NULL,NULL),('8653T45','PC VL4620G 2130 500GB 4GB',9745,NULL,469.10,586.38,3,11,'2010-08-17',NULL,NULL),('8653T54','PC IMDS2870 500GB 4GB DVD W8',5318,NULL,323.03,403.79,3,258,'2011-01-22',NULL,NULL),('8653X54','MONITOR 23IN IPS LED 1920X1080 16:9',2388,NULL,144.69,180.86,3,21,'2011-03-10',NULL,NULL),('8654C18','PC IMDS2875 500GB 6GB DVD W8',3338,NULL,323.03,403.79,3,490,'2009-09-20',NULL,NULL),('8654C19','PC VM2611G 500GB 4GB DVD W8',5565,NULL,336.43,420.54,3,64,'2013-04-08',NULL,NULL),('8654C22','PC VX2619G 500GB 4GB DVD W8',5691,NULL,330.74,413.42,3,31,'2010-07-31',NULL,NULL),('8654C23','PC VM290 500GB 2GB',8052,NULL,220.81,276.01,3,1,'2009-09-09',NULL,NULL),('8654C35','PORTATIL TRAVELMATE P253M 500GB 4GB',9702,NULL,346.46,433.08,3,521,'2009-10-11',NULL,NULL),('8654E78','PORTATIL TRAVELMATE P253M 500GB 4GB',5766,NULL,501.32,626.65,3,51,'2012-09-05',NULL,NULL),('8654E79','PORTATIL TRAVELMATE P253M 500GB 4GB',2237,NULL,457.73,572.16,3,59,'2011-03-22',NULL,NULL),('8654E80','PORTATIL TRAVELMATE P253E 320GB 4GB',597,NULL,292.83,366.04,3,56,'2010-10-03',NULL,NULL),('8654E81','PC VM2611G PENT/G2020 500GB 4GB DVD',1788,NULL,336.43,420.54,3,41,'2012-11-25',NULL,NULL),('8654E82','PC VM2611G CI3/3220 500GB 4GB DVD',1499,NULL,406.55,508.19,3,80,'2012-01-29',NULL,NULL),('8654E83','PC VM2611G CI5/3330 500GB 4GB DVD',2382,NULL,472.89,591.11,3,58,'2012-09-24',NULL,NULL),('8654E84','PC VX2611G CI3/3220 500GB 4GB DVD',1764,NULL,387.60,484.50,3,10,'2012-01-14',NULL,NULL),('8654E85','PC VX2611G CI5/3330 500GB 4GB DVD',2086,NULL,472.89,591.11,3,15,'2013-06-18',NULL,NULL),('8654E99','PORTATIL ENTE11BZ-5167 750GB 6GB 15IN',1204,NULL,323.03,403.79,3,457,'2010-11-28',NULL,NULL),('8654F39','PORTATIL V5-571P 500GB 4GB TOUCH W8',7493,NULL,474.40,593.00,3,213,'2009-11-05',NULL,NULL),('8654F40','PORTATIL V5-571PG 750GB 8GB 15IN W8',1557,NULL,541.30,676.63,3,76,'2012-11-26',NULL,NULL),('8654H62','PC VX4620G CI5/3330 500GB 4GB DVD',3754,NULL,472.89,591.11,3,72,'2009-11-12',NULL,NULL),('8654H63','PC VX2611G PENT/2020 500GB 4GB DVD',2549,NULL,330.74,413.42,3,9,'2010-10-24',NULL,NULL),('8654J46','MONITOR 23IN LED 1920X1080 16:9',552,NULL,101.16,126.45,3,84,'2010-12-12',NULL,NULL),('8654P49','MONITOR 23IN LED 1920X1080 16:9',8982,NULL,137.23,171.54,3,1,'2010-10-13',NULL,NULL),('8654Q92','MONITOR 17IN LCD 1920X1080 16:9',5712,NULL,97.67,122.09,3,1,'2009-10-13',NULL,NULL),('886G524','DVD+-R/RW/DL USB 2.0  EXT ',7773,NULL,22.90,28.63,15,108,'2011-11-24',NULL,NULL),('886H119','DVD+-R/RW/DL USB 2.0  EXT',5772,NULL,22.90,28.63,15,292,'2010-06-03',NULL,NULL),('886H120','DVD+-R/RW/DL USB 2.0  EXT',9713,NULL,22.90,28.63,15,212,'2010-11-08',NULL,NULL),('886H121','DVD+-R/RW/DL USB 2.0  EXT SLIM',2623,NULL,22.90,28.63,15,627,'2011-10-20',NULL,NULL),('886J093','PORTATIL NP3530EC-A02ES 500GB 4GB',2135,NULL,442.86,553.58,15,53,'2010-10-04',NULL,NULL),('886J094','NOTEBOOK NP535U3C-A04ES 500GB 6GB',6557,NULL,476.68,595.85,15,43,'2012-03-24',NULL,NULL),('886J095','NOTEBOOK NP900X3D-A04ES 128GBSSD 4GB',5390,NULL,934.22,1167.77,15,31,'2010-03-20',NULL,NULL),('886J096','NOTEBOOK NP900X3D-A05ES 128GBSSD 4GB',3390,NULL,805.86,1007.33,15,13,'2012-02-23',NULL,NULL),('886J712','NOTEBOOK XE700T1A ',5892,NULL,730.52,913.15,15,1,'2009-06-05',NULL,NULL),('886K037','NOTEBOOK NP900X3D-A05ES',1457,NULL,853.84,1067.30,15,1,'2010-04-05',NULL,NULL),('94331QK','DVD RW SATA HALFHEIGHT INT',2399,NULL,43.46,54.33,16,23,'2009-06-05',NULL,NULL),('9436E6N','NOTEBOOK ELITEBOOK 2170P 500GB 4GB',4651,NULL,867.82,1084.77,16,29,'2009-06-03',NULL,NULL),('9436E6P','NOTEBOOK SPECTREXT I5 128GB SSD 4GB',5258,NULL,793.28,991.60,16,26,'2010-09-07',NULL,NULL),('9436L7T','NOTEBOOK ELITEBOOK 2570P 500GB 4GB',8057,NULL,971.10,1213.87,16,5,'2009-05-12',NULL,NULL),('9436SGF','PORTATIL PRO 4740S 750GB 6GB BLU-RAY',5765,NULL,663.98,829.98,16,13,'2009-10-27',NULL,NULL),('943766W','PORTATIL HP 650 CEL 500GB 4GB',7036,NULL,327.96,409.95,16,2193,'2009-12-09',NULL,NULL),('943766X','PORTATIL HP 650 CI3 500GB 4GB',1806,NULL,392.91,491.14,16,939,'2012-02-13',NULL,NULL),('9437F1J','PC P3500 MT CI3 3220 500GB 4GB DVD W8',4644,NULL,448.84,561.05,16,404,'2011-11-19',NULL,NULL),('9437G1S','PC 4300 SFF CI3 3220 500GB 4GB DVD',5305,NULL,458.62,573.27,16,37,'2011-06-02',NULL,NULL),('9437G1X','PC 7500 ELITE 1TB 4GB DVD W8 SP',8995,NULL,585.74,732.18,16,9,'2013-06-13',NULL,NULL),('9437G2B','PC 6305P A6-5400 500GB 4GB DVD',3180,NULL,585.74,732.18,16,7,'2011-01-30',NULL,NULL),('9437G2D','PC 6300P MT CI3 500GB 4GB DVD',9460,NULL,634.64,793.30,16,68,'2009-05-24',NULL,NULL),('9437G2F','PC 6300 PRO 3.2G 500GB 4GB DVD',1152,NULL,683.54,854.42,16,9,'2010-12-26',NULL,NULL),('9437G2T','PORTATIL PRO 6470B 500GB 4GB W8P',977,NULL,679.34,849.18,16,12,'2011-05-23',NULL,NULL),('9437G4D','PORTATIL ELITEBOOK 8570P 500GB 4GB',2307,NULL,902.95,1128.69,16,2,'2010-11-03',NULL,NULL),('94389AF','PORTATIL CQ58-313SS CI3/2328M',5036,NULL,364.06,455.08,16,2,'2010-12-30',NULL,NULL),('943VHQ0','SLIM 12.7MM SATA INT - DVDRW',1970,NULL,96.08,120.10,16,2,'2013-04-27',NULL,NULL),('B940644','DVD+-R/RW/DL USB2 SLIM EXT',5847,NULL,21.90,27.38,17,679,'2010-02-07',NULL,NULL),('B940692','DVD+-R/RW/DL/RAM SATA INT',3367,NULL,12.44,15.55,17,24,'2012-07-10',NULL,NULL),('B940693','DVD±R/RW/DL/RAM SATA SLIM INT',1355,NULL,19.58,24.47,17,19,'2009-05-25',NULL,NULL),('B940695','DVD+-R/RW/DL/RAM SATA BLACK INT',5437,'NEGRO',11.79,14.74,17,174,'2010-05-23',NULL,NULL),('B99H834','PORTATIL F55VD 500GB 4GB W8',4931,NULL,414.06,517.57,18,33,'2010-09-27',NULL,NULL),('B99H836','PORTATIL S500CA 500GB 4GB',8371,NULL,600.01,750.01,18,19,'2012-08-28',NULL,NULL),('B99J147','PC EB1007P ATOM D425 320GB 1GB',6722,NULL,230.06,287.57,18,1,'2011-03-15',NULL,NULL),('B99J148','PC EB1035 CELERON 847 320GB 2GB',7371,NULL,277.80,347.25,18,16,'2013-04-29',NULL,NULL),('B99J150','PC EB1503 ATOM 320GB 2GB DVD',9551,NULL,349.46,436.82,18,11,'2010-09-08',NULL,NULL),('B99J501','NOTEBOOK TAICHI31 256GB SSD 4GB W8',4689,NULL,1420.46,1775.57,18,1,'2010-05-11',NULL,NULL),('B99K000','DRW-24B5ST/BLK/B BULK INT - INT',1118,NULL,14.72,18.40,18,27,'2012-03-06',NULL,NULL),('B99K004','BLURAY COMBO DRIVE SBC-06D2X-U',2294,NULL,68.17,85.21,18,2,'2012-08-10',NULL,NULL),('B99K043','NOTEBOOK VIVO BOOK S200 500GB 4GB W8',3750,NULL,418.60,523.25,18,41,'2010-12-23',NULL,NULL),('B99K231','DRW-24B5ST/BLK/G SILENT INT - 24X ',3528,NULL,18.66,23.33,18,11,'2012-11-22',NULL,NULL),('B99K233','SDRW-08D2S-U LITE EXT - EXT 8X ',6382,NULL,25.50,31.88,18,4,'2010-04-15',NULL,NULL),('R340871','LINKSTATION LIVE 3.0TB NAS EXT',5060,NULL,148.41,185.51,11,1,'2010-12-30',NULL,NULL),('R341086','LINKSTATION 420 NAS 6TB 2X3TB',4880,NULL,376.41,470.51,11,3,'2010-11-07',NULL,NULL),('S602FN8','PC TC-EDGE-M82 500GB 4GB DVD',5160,NULL,524.94,656.18,19,7,'2011-03-15',NULL,NULL),('S602HU7','PC TC-EDGE 72 G645 500GB 4GB DVD',2079,NULL,349.48,436.85,19,23,'2011-11-18',NULL,NULL),('S602HV3','PC TC-EDGE-M82 500GB 4GB DVD W8PR',3051,NULL,515.36,644.20,19,6,'2011-12-14',NULL,NULL),('S602HV8','PC TC-EDGE72 1TB 4GB DVD W8PR',9264,NULL,623.63,779.54,19,29,'2011-04-19',NULL,NULL),('S602LB1','PORTATIL ESSENTIA-B590 500GB 4GB',9042,NULL,450.41,563.01,19,3,'2010-07-28',NULL,NULL),('S602MP2','PORTATIL ESSENTIAL B590 500GB ',8071,NULL,405.17,506.46,19,520,'2009-09-02',NULL,NULL),('S602NE6','PORTATIL IDEAPAD E1-1200 500GB 6GB',1981,NULL,309.46,386.82,19,63,'2012-07-26',NULL,NULL),('S602PP2','PC TC EDGE72 500GB 4GB DVD W7P/W8P',8574,NULL,349.48,436.85,19,1,'2010-07-27',NULL,NULL),('S602PQ0','PORTATIL THINKPAD L430 - 500GB 4GB',4987,NULL,764.48,955.60,19,18,'2010-01-09',NULL,NULL),('S602PQ4','PORTATIL ESSENTIA B590 500GB 4GB',6933,NULL,427.02,533.77,19,146,'2009-07-20',NULL,NULL),('S602PQ5','NOTEBOOK THINKPAD E130 320GB 4GB',6851,NULL,513.29,641.61,19,1,'2011-02-19',NULL,NULL),('S602PX5','PORTATIL ESSENTIAL-B590 500GB 4GB',7787,NULL,362.90,453.63,19,450,'2012-09-02',NULL,NULL),('S602RA1','PORTATIL G580IMR 1TB 4GB ',6298,NULL,347.16,433.95,19,349,'2011-02-15',NULL,NULL),('S602TZ5','PORTATIL THINKPAD-E530',9589,NULL,877.70,1097.13,19,1,'2013-02-10',NULL,NULL),('S602VG6','NOTEBOOK TP X220T 160GBSSD 6GB',5519,NULL,1505.01,1881.26,19,2,'2011-05-27',NULL,NULL),('W890502','SAI LIEBERT GXT3 700VA (630W)',9792,NULL,397.83,497.29,5,1,'2012-04-10',NULL,NULL),('W890503','SAI LIEBERT GXT3 1000VA (900W)',5107,NULL,535.76,669.70,5,2,'2010-08-26',NULL,NULL),('W890504','SAI LIEBERT GXT3 1500VA (1350W)',8909,NULL,715.00,893.75,5,4,'2011-10-26',NULL,NULL),('W890505','SAI LIEBERT GXT3 2000VA (1800W)',3328,NULL,930.56,1163.20,5,3,'2011-07-29',NULL,NULL),('W890506','SAI LIEBERT GXT3 3000VA (2700W)',3045,NULL,1284.82,1606.03,5,4,'2012-11-19',NULL,NULL),('Z660117','CABINA DE DISCOS SYNOLOGY 10TB',7898,NULL,1074.68,1343.35,6,5,'2011-04-20',NULL,NULL),('Z660118','CABINA DE DISCOS SYNOLOGY 4 BAY',2669,NULL,386.70,483.38,6,4,'2010-05-17',NULL,NULL),('Z660119','CABINA DE DISCOS SYNOLOGY 5 BAY',9624,NULL,361.06,451.33,6,2,'2011-03-10',NULL,NULL),('Z660122','CABINA DE DISCOS SYNOLOGY 2 BAY',8851,NULL,231.99,289.99,6,32,'2010-05-02',NULL,NULL),('Z660129','CABINA DE DISCOS SYNOLOGY 2U 16TB',1562,NULL,3516.30,4395.37,6,2,'2011-06-08',NULL,NULL),('Z660131','CABINA DE DISCOS SYNOLOGY 5TB',16,NULL,369.46,461.82,6,9,'2011-04-22',NULL,NULL);
/*!40000 ALTER TABLE `artigos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `clientes`
--

DROP TABLE IF EXISTS `clientes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `clientes` (
  `clt_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `clt_cif` char(9) DEFAULT NULL,
  `clt_apelidos` varchar(100) NOT NULL COMMENT 'apelidos ou razon social do cliente',
  `clt_nome` varchar(50) DEFAULT NULL COMMENT 'nome, ou tipo de sociedade (SL, SA, ...) do cliente',
  `clt_enderezo` varchar(100) DEFAULT NULL,
  `clt_cp` char(5) DEFAULT NULL COMMENT 'código postal do cliente',
  `clt_poboacion` varchar(60) DEFAULT NULL,
  `clt_pais` smallint(5) unsigned DEFAULT NULL COMMENT 'código do pais, tendo en conta a táboa de paises',
  `clt_email` varchar(120) DEFAULT NULL,
  `clt_desconto` tinyint(4) DEFAULT '0' COMMENT 'procentaxe de desconto aplicable ao cliente',
  `clt_vendas` smallint(5) unsigned DEFAULT NULL COMMENT 'número de ventas que se lle ficeron ao cliente',
  `clt_ultima_venda` date DEFAULT NULL COMMENT 'data da última venta feita ao cliente',
  `clt_alta` date NOT NULL COMMENT 'data na que se deu de alta ao cliente',
  `clt_ultima_actualizacion` date DEFAULT NULL COMMENT 'data da última actualización feita nos datos do cliente',
  `clt_baixa` date DEFAULT NULL COMMENT 'data na que se deu de baixa ao cliente',
  PRIMARY KEY (`clt_id`),
  UNIQUE KEY `clt_cif` (`clt_cif`),
  KEY `clt_apelidos_nome` (`clt_apelidos`,`clt_nome`),
  KEY `clt_pais` (`clt_pais`),
  CONSTRAINT `fk_clientes_paises` FOREIGN KEY (`clt_pais`) REFERENCES `paises` (`pai_id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `clientes`
--

LOCK TABLES `clientes` WRITE;
/*!40000 ALTER TABLE `clientes` DISABLE KEYS */;
INSERT INTO `clientes` VALUES (1,'14013338J','Portela Carracedo','Francisco','PORTALEGRE   (Impares del 77 al final)  (Pares del 106 al fi, 111 - 4º','28025','Madrid',73,'jgcs@clientes.es',2,2,'2015-06-10','2013-05-21',NULL,NULL),(2,'32727807A','Barreira Vila','Juan','BRASILIA, 100 - 5º','50007','Zaragoza',73,'xgln@clientes.es',3,1,'2015-05-27','2013-05-21',NULL,NULL),(3,'18533827J','Armas Tellado','Jose','RETRIZ, 186 - 4º A','15635','Coruña',73,'nxdt@clientes.es',1,3,'2015-06-17','2013-05-21',NULL,NULL),(4,'31410232Y','Rodríguez Piñeiro','Brian','FOGAINERS, DELS, 85 - 1º','46014','Valencia',73,'jrhl@clientes.es',3,0,NULL,'2013-06-16',NULL,NULL),(5,'33620253A','Gutierrez Fernández','Asunción','DOCTOR JAIME GARCIA ROYO, 24 - 7º D','18014','Granada',73,'tonw@clientes.es',0,0,NULL,'2013-05-20',NULL,NULL),(6,'20792800H','De Vega Purriños','Benigno','GUARDIA URBANA, 126 - 2º','08004','Barcelona',73,'exff@clientes.es',1,2,'2015-06-12','2013-05-20',NULL,NULL),(7,'21133251T','Guntín Curtier','Oscar','EDROSA, 104 - ático D','15339','Coruña',73,'ogrq@clientes.es',2,1,'2015-06-09','2013-06-11',NULL,NULL),(8,'12555428G','Díaz Jimenez','Jose Luis','CEUTI, 65 - 6º C','30562','Murcia',73,'cmfq@clientes.es',0,0,NULL,'2013-05-21',NULL,NULL),(9,'18045445J','Touriño Calle','Antonia','POLIGON BAIXADOR DE VALLVIDRERA, 70 - 6º','08017','Barcelona',73,'ioye@clientes.es',2,1,'2015-06-12','2013-06-10',NULL,NULL),(10,'19171268D','Menéndez Otero','Javier','EULOGIO MARTIN HIGUERA, 2 - 4º','40001','Segovia',73,'mkqc@clientes.es',1,3,'2015-06-06','2013-06-14',NULL,NULL),(11,'20231871J','Menéndez Arbeloa','Saturno','UMBRIA DE LA ZARZA, 178 - bajo','03659','Alicante',73,'egru@clientes.es',1,2,'2015-06-08','2013-06-12',NULL,NULL),(12,'19845404S','Calle Manzano','Juan Antonio','QUECHUAS, 188 - 2º D','47008','Valladolid',73,'ugte@clientes.es',0,2,'2015-06-02','2013-06-14',NULL,NULL),(13,'29559545Z','Sánchez Hospido','Julián','BUSTO (LUARCA), 62 - 4º B','33789','Asturias',73,'mmyj@clientes.es',0,2,'2015-05-29','2013-05-25',NULL,NULL),(14,'28810744R','Portero Vilela','Cándido','TRAVIESA, 12 - 5º','15404','Ferrol',73,'nnbs@clientes.es',0,0,NULL,'2013-06-09',NULL,NULL),(15,'11409371Z','Suárez Fraga','Enrique','SILENCIO, 188 - 2º','33211','Gijón',73,'fgod@clientes.es',0,0,NULL,'2013-06-06',NULL,NULL),(16,'28457603W','Hernández López','Juan Carlos','VICTORIA PEÑA, 100 - 4º C','07009','Palma de Mallorca',73,'tilg@clientes.es',1,2,'2015-06-03','2013-05-25',NULL,NULL),(17,'16169357N','Arias Calle','Mercedes','RECOLETOS, DE,Acera, 179 - 6º C','47004','Valladolid',73,'lqvh@clientes.es',0,1,'2015-06-11','2013-05-20',NULL,NULL),(18,'28723211Y','Jimenez Fermoso','Bernardo','CUEVA DE LOS CANARIOS (MONTEQUEMADO), 138 - 7º','35017','Palmas de Gran Canaria,Las',73,'dnid@clientes.es',2,1,'2015-05-28','2013-05-23',NULL,NULL),(19,'23932986Z','Jimenez Santoro','Carlos','ANGHERA, 167 - 1º A','33201','Gijón',73,'jhlj@clientes.es',2,1,'2015-05-31','2013-06-13',NULL,NULL),(20,'23096811G','Mazaira Guerra','Olalla','MARTIRES, 200 - 8º D','37001','Salamanca',73,'uasp@clientes.es',2,1,'2015-06-08','2013-05-24',NULL,NULL),(21,'24607206N','Loureiro Menéndez','Miguel Angel','JULIO DEL CAMPO, 141 - 4º C','24002','León',73,'kxnu@clientes.es',0,3,'2015-06-18','2013-05-30',NULL,NULL),(22,'29802445B','Cáceres Domínguez','Lucas','MUÑOZ TORRERO   (Impares del 13 al final)  (Pares del 16 al , 192 - 8º A','06001','Badajoz',73,'rnpl@clientes.es',2,1,'2015-06-09','2013-05-20',NULL,NULL),(23,'25464653L','Fermín Romero','Enriqueta','BARRANCO DE LAS LAJAS, 73 - 3º B','38355','Santa Cruz de Tenerife',73,'trhj@clientes.es',1,2,'2015-06-04','2013-05-23',NULL,NULL),(24,'31431126Q','Cortés Montoya','Oscar','AMISTAD, LA, 200 - 7º','50002','Zaragoza',73,'pcoq@clientes.es',4,0,NULL,'2013-05-22',NULL,NULL),(25,'18753426P','Benitez Cachafeiro','María Jesus','OBISPO VERDUGO, 69 - 4º','35215','Telde',73,'acin@clientes.es',0,0,NULL,'2013-06-07',NULL,NULL),(26,'30170103Z','Besteiro Sarry','Adoración','CIUTAT CONDAL, 145 - 2º A','08901','Hospitalet de Llobregat,l',73,'rjux@clientes.es',0,1,'2015-06-11','2013-06-01',NULL,NULL),(27,'17228470K','Loureiro Benitez','Bernardo','SAN ESTEBAN, 122 - 2º','19001','Guadalajara',73,'jdnh@clientes.es',2,2,'2015-06-16','2013-06-13',NULL,NULL),(28,'17064404Z','Portero Busta','Gimena','SAN FULGENCIO, 24 - 2º','03177','Alicante',73,'dkrf@clientes.es',1,4,'2015-06-13','2013-06-11',NULL,NULL),(29,'19035504Z','Fernández Piñeiro','Zoilo','PENACOBA, 189 - 7º D','15809','Coruña',73,'phpd@clientes.es',2,1,'2015-05-26','2013-06-11',NULL,NULL),(30,'32784859S','López Purriños','Jose','CASTOMAS, 83 - 7º B','32769','Ourense',73,'oqqf@clientes.es',1,3,'2015-06-10','2013-05-28',NULL,NULL),(31,'30240815R','Martínez Herraz','Leandro','SAN AGUSTIN, 91 - ático A','29015','Málaga',73,'wdyn@clientes.es',1,1,'2015-06-08','2013-06-08',NULL,NULL),(32,'31892690Q','Gutierrez Múgica','Isabel','TANARRIO, 48 - 1º','39587','Cantabria',73,'jdmd@clientes.es',2,1,'2015-06-10','2013-06-07',NULL,NULL),(33,'21117348J','Manzano Rodríguez','Iván','BERLIN, 103 - 5º','10005','Cáceres',73,'ibjq@clientes.es',1,1,'2015-06-04','2013-05-28',NULL,NULL),(34,'19556799Z','Calle Núñez','Leandro','CUERIGO, 158 - ático','33680','Asturias',73,'mfpi@clientes.es',4,1,'2015-05-21','2013-06-02',NULL,NULL),(35,'21862456J','Fermoso Xaneiro','Felix','SAN BENITO,Plaza, 115 - 3º D','37002','Salamanca',73,'wwqp@clientes.es',0,2,'2015-06-12','2013-05-28',NULL,NULL),(36,'31189708Y','Manzano Portela','Gema','GONGORA,Plaza, 116 - 6º C','41010','Sevilla',73,'wtfu@clientes.es',3,3,'2015-06-09','2013-06-15',NULL,NULL),(37,'21305236Z','Sarry Portela','Cándida','CARREGAL DE ABAIXO (AMORÍN), 130 - 6º','36730','Pontevedra',73,'binr@clientes.es',1,3,'2015-06-12','2013-06-13',NULL,NULL),(38,'13487901B','Gómez Guntín','Felisa','PAZOS (VICESO), 116 - 8º','15839','Coruña',73,'dapd@clientes.es',4,2,'2015-06-01','2013-06-12',NULL,NULL),(39,'22347778N','Fermoso Mayo','Dositea','SAN JUAN, 29 - 6º','38203','Laguna,La',73,'tmdd@clientes.es',4,0,NULL,'2013-05-22',NULL,NULL),(40,'13098931V','García Montoro','Manuel','GENERAL RICARDOS   (Impares del 157 al final)  (Pares del 16, 41 - 5º','28025','Madrid',73,'tgah@clientes.es',2,3,'2015-06-14','2013-06-01',NULL,NULL),(41,'25961903D','Menéndez Sánchez','Martín','CURRA, 77 - ático A','32366','Ourense',73,'sldk@clientes.es',3,3,'2015-06-13','2013-06-05',NULL,NULL),(42,'33416500F','Vilela Carracedo','Julio','DEHESAS DE GUADIX, 149 - 6º B','18538','Granada',73,'eqtv@clientes.es',1,2,'2015-06-18','2013-05-29',NULL,NULL),(43,'27974761E','Silva Benitez','Martín','CAN MENTA,Cami, 136 - 1º A','08173','Sant Cugat del Vallés',73,'txjy@clientes.es',2,1,'2015-06-14','2013-05-27',NULL,NULL),(44,'26390644F','Cáceres Cortés','Cándido','NAGUSIA, 85 - 8º A','20304','Irún',73,'erys@clientes.es',4,3,'2015-06-16','2013-05-30',NULL,NULL),(45,'22749650M','Fraga Ferreiro','María Jesus','VALGA (LACEIRAS, AS), 156 - 3º A','36646','Pontevedra',73,'vyit@clientes.es',4,1,'2015-06-02','2013-05-22',NULL,NULL),(46,'16526516G','Rivera Louro','Juan','PRESA, LA, 72 - entresuelo','01013','Vitoria-Gasteiz',73,'kcfu@clientes.es',0,1,'2015-05-24','2013-06-04',NULL,NULL),(47,'29297579H','Xaneiro Cáceres','Vicente','CARBALLO (MUNIFERRAL), 116 - 8º A','15317','Coruña',73,'vofk@clientes.es',4,1,'2015-06-10','2013-06-10',NULL,NULL),(48,'27819034M','Leire Rodríguez','Dositea','FERNANDO HUE, 82 - 4º','44002','Teruel',73,'jsnk@clientes.es',2,0,NULL,'2013-06-13',NULL,NULL),(49,'15482053V','Sánchez Menéndez','Rogelio','SANT ANDREU, 23 - 2º C','08923','Santa Coloma de Gramanet',73,'fukr@clientes.es',2,4,'2015-06-04','2013-05-25',NULL,NULL),(50,'19918171X','Ferreiro Cáceres','Isabel','JACINTO DE LA TRINIDAD, 92 - 7º','04009','Almería',73,'qxtb@clientes.es',1,2,'2015-06-17','2013-05-30',NULL,NULL),(51,'13946883M','Carracedo Montoya','Vanesa','VISTA ALEGRE (DOSO-NARON), 9 - 5º A','15570','Coruña',73,'chiq@clientes.es',4,2,'2015-05-30','2013-06-18',NULL,NULL),(52,'20220627Q','Tellado Peteiro','Saturno','RIQUET, 80 - 5º B','03599','Alicante',73,'lbwh@clientes.es',0,3,'2015-06-08','2013-06-16',NULL,NULL),(53,'23898384G','Barreiro Barreira','Marta','OBRADORS, 168 - 1º D','25002','Lleida',73,'ehae@clientes.es',4,1,'2015-05-23','2013-06-04',NULL,NULL),(54,'31817366V','Jimenez Villar','Mª Carmen','CARME,Plaça (Impares del 1 al 13)  (Pares del 2 al 14), 187 - 1º','07701','Maó',73,'vknm@clientes.es',0,1,'2015-06-07','2013-06-04',NULL,NULL),(55,'16151623B','López Fermoso','Jose','BENDICION, 24 - 3º B','33937','Asturias',73,'qxrr@clientes.es',4,1,'2015-06-18','2013-06-17',NULL,NULL),(56,'20497620C','Vilela Portela','Cándido','ORQUIDEAS, DE LAS,Camino, 54 - 1º D','33203','Gijón',73,'xxtc@clientes.es',3,3,'2015-06-06','2013-05-22',NULL,NULL),(57,'13948902T','Fraga Janeiro','Mª Carmen','HEROES DEL ALCAZAR DE TOLEDO, 87 - 5º','47001','Valladolid',73,'bxob@clientes.es',0,1,'2015-06-07','2013-06-09',NULL,NULL),(58,'32180785J','Sánchez Varela','Jorge','MONZON, 122 - 4º','22400','Huesca',73,'glnj@clientes.es',4,0,NULL,'2013-06-07',NULL,NULL),(59,'29613833E','Valín Bermejo','Fátima','OLIVA, 17 - ático B','23007','Jaén',73,'gcqy@clientes.es',0,2,'2015-06-15','2013-06-18',NULL,NULL),(60,'17185452J','Álvarez Paredes','María del Carmen','POBOADORES, 107 - 2º B','36202','Vigo',73,'efqn@clientes.es',1,2,'2015-05-25','2013-05-23',NULL,NULL),(61,'26163723G','Perales Barcia','Sara','TOSCA, LA, 112 - 8º D','35360','Las Palmas',73,'wwsc@clientes.es',2,1,'2015-06-04','2013-06-01',NULL,NULL),(62,'32987161D','Otero Mayo','Mercedes','SANT GREGORI, 153 - 6º A','08917','Badalona',73,'kvyi@clientes.es',2,0,NULL,'2013-05-21',NULL,NULL),(63,'32244703Z','Ferreiro Carballeira','Carlos','IRIARTE, 140 - ático A','08035','Barcelona',73,'xrpy@clientes.es',0,1,'2015-06-05','2013-06-12',NULL,NULL),(64,'19487695W','Illán Martín','Manuel','BUCARELLI, 73 - entresuelo','41006','Sevilla',73,'vgsw@clientes.es',1,0,NULL,'2013-06-01',NULL,NULL),(65,'23236785T','Perales Barcia','Enriqueta','GASCO OLIAG, 175 - 4º D','46010','Valencia',73,'qrlh@clientes.es',1,0,NULL,'2013-05-27',NULL,NULL),(66,'14210711T','Xaneiro Jimenez','Valeriano','VILLALAIN, 18 - ático A','09554','Burgos',73,'erud@clientes.es',1,2,'2015-06-04','2013-05-25',NULL,NULL),(67,'16808540W','Domínguez Pulido','Francisco Javier','DIPUTADO ANTONIO GARCIA MIRALLES, 168 - 4º D','03014','Alacant/Alicante',73,'mwbr@clientes.es',2,0,NULL,'2013-05-26',NULL,NULL),(68,'21122069L','Janeiro Barreiro','Rogelia','ZARATAN, 127 - 8º C','37170','Salamanca',73,'wplj@clientes.es',4,1,'2015-06-08','2013-05-28',NULL,NULL),(69,'27872236P','Hernández Curtier','Cándida','AMBROSIO DEL RUSTE, 10 - 7º','50014','Zaragoza',73,'wjer@clientes.es',2,0,NULL,'2013-05-30',NULL,NULL),(70,'23589966Q','Perales Zamora','Jose Luis','REGO, O (VILAMARIN), 70 - 5º D','32140','Ourense',73,'ytxl@clientes.es',1,1,'2015-05-26','2013-06-04',NULL,NULL),(71,'32927831L','Silva López','Saturno','LLANO, EL (SAN TIRSO DE ABRES), 92 - bajo','33774','Asturias',73,'armj@clientes.es',0,1,'2015-05-29','2013-06-15',NULL,NULL),(72,'33712332J','Hernández Hospido','Secundino','ARINAGA, 59 - 6º','35010','Palmas de Gran Canaria,Las',73,'bkve@clientes.es',3,2,'2015-06-08','2013-06-05',NULL,NULL),(73,'31729153D','Peteiro Fernández','Segismundo','IGUAZU, 197 - 7º','41012','Sevilla',73,'stpu@clientes.es',0,2,'2015-05-31','2013-06-09',NULL,NULL),(74,'20090435G','Martínez Paredes','Estanislao','BORRELL, 79 - 3º','08202','Sabadell',73,'dmei@clientes.es',0,1,'2015-05-31','2013-05-28',NULL,NULL),(75,'27636430K','López Barreira','Hector','MORNETA, 166 - 2º A','07013','Palma de Mallorca',73,'lwbo@clientes.es',4,0,NULL,'2013-06-11',NULL,NULL),(76,'11801870H','Silva Jimenez','Felisa','EZEQUIEL AGUIRRE, 87 - 3º','48930','Las Arenas',73,'nidq@clientes.es',4,4,'2015-06-09','2013-05-26',NULL,NULL),(77,'33278205B','Leire Manzano','Antonia','QUINTANAS DE GORMAZ, 22 - 8º D','42313','Soria',73,'dhbm@clientes.es',2,2,'2015-06-14','2013-06-16',NULL,NULL),(78,'15178507W','Mayo Barcia','Antonia','MISIEGOS, 119 - ático C','33685','Asturias',73,'yeyh@clientes.es',0,1,'2015-06-19','2013-05-21',NULL,NULL),(79,'22526753R','Sánchez Maltrana','Marta','QUINTANAVIDES, 26 - 2º','28050','Madrid',73,'ynte@clientes.es',4,1,'2015-06-08','2013-05-26',NULL,NULL),(80,'20417357G','Mazaira Fernández','Ana','BERGA, 124 - 8º C','08600','Barcelona',73,'ivfm@clientes.es',1,2,'2015-06-03','2013-05-20',NULL,NULL),(81,'15795679S','Fernández Manzano','Vicente','ANITA MARTINEZ, 191 - ático C','28904','Getafe',73,'eapb@clientes.es',4,1,'2015-05-25','2013-06-17',NULL,NULL),(82,'18282575J','Leire García','Valeriano','TORRE LLAMBRION, 165 - 6º C','24008','León',73,'tjno@clientes.es',4,0,NULL,'2013-05-20',NULL,NULL),(83,'31413424R','Fraga Vila','Manuel','ESTRULLONES, 185 - 5º A','33685','Asturias',73,'blcg@clientes.es',2,3,'2015-06-17','2013-05-30',NULL,NULL),(84,'27011728E','Suárez Sarry','María Dolores','SABOCOS, 17 - 8º D','50012','Zaragoza',73,'mhwq@clientes.es',4,3,'2015-06-06','2013-06-13',NULL,NULL),(85,'17785438K','Barcia Ferreiro','Sara','BARCELONA,Avenida, 69 - 6º D','23006','Jaén',73,'pdtm@clientes.es',1,1,'2015-05-29','2013-06-07',NULL,NULL),(86,'21986174Z','Loureiro Piñeiro','María del Carmen','DOCTOR MARAÑON, 193 - 3º B','36211','Vigo',73,'tasq@clientes.es',3,2,'2015-06-19','2013-06-07',NULL,NULL),(87,'28422801E','Martín López','Rogelio','ALFEREZ PROVISIONAL,Avenida, 10 - 4º D','50006','Zaragoza',73,'jqfc@clientes.es',4,3,'2015-06-18','2013-05-30',NULL,NULL),(88,'27528813K','Manzano Louro','Felisa','TOIXEIRO, 22 - 5º A','15339','Coruña',73,'onyf@clientes.es',2,3,'2015-06-18','2013-05-29',NULL,NULL),(89,'22148622J','Fernández Martín','Borja','LANDABURU, 129 - 4º','48902','Barakaldo',73,'kchf@clientes.es',4,0,NULL,'2013-06-03',NULL,NULL),(90,'25457657S','Domínguez Manzano','Manuel','JOAN XXIII,Carrer, 69 - 5º','08241','Manresa',73,'ovoi@clientes.es',3,1,'2015-06-18','2013-05-29',NULL,NULL),(91,'10710232Y','Vila Janeiro','Marcos','MIGDIA, 192 - 3º A','46702','Gandía',73,'kerw@clientes.es',2,2,'2015-06-15','2013-06-15',NULL,NULL),(92,'15203948M','Díaz Barcia','Angel Luis','DOCTOR SEVERO OCHOA, 182 - 8º A','14004','Córdoba',73,'sbyt@clientes.es',0,0,NULL,'2013-05-31',NULL,NULL),(93,'29515620L','Gutierrez Sarry','Javier','AMEZQUETAS,Plaza, 86 - 4º A','20010','Donostia-San Sebastian',73,'cgbk@clientes.es',4,1,'2015-06-10','2013-06-09',NULL,NULL),(94,'29890870R','Varela Martínez','Honorio','RIO TORMES, 188 - 4º A','28913','Leganés',73,'xuji@clientes.es',0,1,'2015-05-26','2013-06-12',NULL,NULL),(95,'22958994A','Silva Arbeloa','Marisa','XALON (CABRAL-IGREXA, A),Lugar, 121 - 8º','36318','Vigo',73,'swgp@clientes.es',2,3,'2015-06-12','2013-05-28',NULL,NULL),(96,'33248016K','Cortés Hospido','Rosa','LOPE DE RUEDA, 117 - 6º','28805','Alcalá de Henares',73,'akxn@clientes.es',4,2,'2015-06-09','2013-05-22',NULL,NULL),(97,'15288297J','Fraga Jimenez','Rogelio','REALENGO, EL, 197 - 1º A','04610','Almería',73,'pbmi@clientes.es',0,3,'2015-06-07','2013-06-13',NULL,NULL),(98,'19622179M','Ferreiro Benitez','Leandro','SABACEDA DE ABAIXO, 80 - 5º','15145','Coruña',73,'cgbo@clientes.es',3,2,'2015-06-17','2013-06-10',NULL,NULL),(99,'25696737X','Suárez Barreiro','María','242 (SON CLADERA), 134 - ático C','07009','Palma de Mallorca',73,'iqfg@clientes.es',4,3,'2015-06-14','2013-05-22',NULL,NULL),(100,'16137107P','Núñez Arias','María Dolores','FLORENCIO QUINTERO, 98 - ático A','41009','Sevilla',73,'rabh@clientes.es',0,1,'2015-06-13','2013-06-14',NULL,NULL);
/*!40000 ALTER TABLE `clientes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detalle_facturas`
--

DROP TABLE IF EXISTS `detalle_facturas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detalle_facturas` (
  `def_factura` int(10) unsigned NOT NULL COMMENT 'id da factura que contén a liña de detalle',
  `def_numero` smallint(6) NOT NULL COMMENT 'número de liña de detalle, dentro da factura',
  `def_id_venda` int(10) unsigned NOT NULL COMMENT 'id da venda que contén a liña de detalle',
  `def_data_venda` date NOT NULL,
  `def_importe` decimal(9,2) NOT NULL COMMENT 'importe toal da venda facturada',
  PRIMARY KEY (`def_factura`,`def_numero`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detalle_facturas`
--

LOCK TABLES `detalle_facturas` WRITE;
/*!40000 ALTER TABLE `detalle_facturas` DISABLE KEYS */;
/*!40000 ALTER TABLE `detalle_facturas` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detalle_pedidos`
--

DROP TABLE IF EXISTS `detalle_pedidos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detalle_pedidos` (
  `dep_pedido` int(10) unsigned NOT NULL COMMENT 'id do pedido que contén a liña de detalle',
  `dep_numero` tinyint(3) unsigned NOT NULL COMMENT 'número de liña de detalle, dentro do pedido',
  `dep_artigo` char(8) NOT NULL,
  `dep_cantidade` smallint(5) unsigned DEFAULT NULL,
  PRIMARY KEY (`dep_pedido`,`dep_numero`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detalle_pedidos`
--

LOCK TABLES `detalle_pedidos` WRITE;
/*!40000 ALTER TABLE `detalle_pedidos` DISABLE KEYS */;
/*!40000 ALTER TABLE `detalle_pedidos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `detalle_vendas`
--

DROP TABLE IF EXISTS `detalle_vendas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detalle_vendas` (
  `dev_venda` int(10) unsigned NOT NULL COMMENT 'id da venda á que corresponde a liña de detalle',
  `dev_numero` tinyint(3) unsigned NOT NULL COMMENT 'número da liña de detalle, dento da venda',
  `dev_artigo` char(8) NOT NULL COMMENT 'id do artigo',
  `dev_cantidade` smallint(5) unsigned NOT NULL COMMENT 'número de unidades do artigo vendidas',
  `dev_prezo_unitario` decimal(8,2) unsigned NOT NULL COMMENT 'prezo unitario do artigo',
  `dev_desconto` tinyint(3) unsigned NOT NULL COMMENT 'porcentaxe de desconto aplicado',
  PRIMARY KEY (`dev_venda`,`dev_numero`),
  KEY `dev_artigo` (`dev_artigo`),
  KEY `dev_venda` (`dev_venda`),
  CONSTRAINT `fk_detalle_vendas_artigos` FOREIGN KEY (`dev_artigo`) REFERENCES `artigos` (`art_codigo`) ON UPDATE CASCADE,
  CONSTRAINT `fk_detalle_vendas_vendas` FOREIGN KEY (`dev_venda`) REFERENCES `vendas` (`ven_id`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detalle_vendas`
--

LOCK TABLES `detalle_vendas` WRITE;
/*!40000 ALTER TABLE `detalle_vendas` DISABLE KEYS */;
INSERT INTO `detalle_vendas` VALUES (1,1,'1410768',11,53.47,2),(1,2,'404T988',13,1501.74,2),(2,1,'8653S16',15,494.02,0),(2,2,'S602HV8',5,779.54,0),(2,3,'9437G2F',2,854.42,0),(2,4,'9437G2T',4,849.18,0),(2,5,'6181508',1,1357.03,0),(2,6,'1411131',12,103.67,0),(2,7,'0772VS2',1,263.54,0),(2,8,'886H120',12,28.63,0),(2,9,'4065316',4,234.96,0),(3,1,'6181677',1,231.87,0),(3,2,'B99J148',7,347.25,0),(3,3,'479V375',1,1057.38,0),(3,4,'404S893',5,976.95,0),(3,5,'404T635',1,932.51,0),(3,6,'4064078',8,169.04,0),(3,7,'943766W',9,409.95,0),(3,8,'9437G2D',3,793.30,0),(3,9,'943766W',4,409.95,0),(3,10,'4065200',7,171.66,0),(3,11,'404S523',1,971.63,0),(3,12,'6181508',1,1357.03,0),(3,13,'404S891',7,1446.43,0),(3,14,'2704148',2,368.14,0),(3,15,'9437G2B',1,732.18,0),(3,16,'404S523',3,971.63,0),(4,1,'1411068',10,85.14,4),(4,2,'1411158',9,103.09,4),(4,3,'4065265',7,155.19,4),(4,4,'4065174',3,18.13,4),(4,5,'S602PQ4',9,533.77,4),(4,6,'886H120',6,28.63,4),(4,7,'Z660131',1,461.82,4),(4,8,'077WN45',4,509.99,4),(4,9,'4065174',7,18.13,4),(4,10,'404N216',1,71.23,4),(4,11,'S602HV8',9,779.54,4),(4,12,'8653S15',14,444.52,4),(4,13,'4065263',3,158.53,4),(5,1,'943766W',4,409.95,2),(5,2,'8653D08',11,174.54,2),(5,3,'886H121',5,28.63,2),(5,4,'404T635',1,932.51,2),(5,5,'242L760',4,54.87,2),(5,6,'1411068',5,85.14,2),(5,7,'886H120',3,28.63,2),(5,8,'W890502',1,497.29,2),(5,9,'235E510',1,62.51,2),(5,10,'07735Y4',3,500.50,2),(5,11,'S602NE6',14,386.82,2),(5,12,'B99J147',1,287.57,2),(5,13,'886K037',1,1067.30,2),(5,14,'242G454',6,114.85,2),(5,15,'077MR98',1,111.80,2),(5,16,'235E508',2,61.88,2),(5,17,'2704488',1,3171.93,2),(5,18,'886H119',9,28.63,2),(5,19,'404T988',9,1501.74,2),(5,20,'8654E80',12,366.04,2),(6,1,'S602TZ5',1,1097.13,1),(6,2,'404T635',1,932.51,1),(6,3,'9437G1X',1,732.18,1),(6,4,'R340871',1,185.51,1),(6,5,'07714M0',3,146.62,1),(6,6,'8653E96',3,139.85,1),(6,7,'Z660119',2,451.33,1),(6,8,'404S893',13,976.95,1),(6,9,'W890504',1,893.75,1),(6,10,'S602PQ0',7,955.60,1),(6,11,'8654P49',1,171.54,1),(6,12,'8654C18',7,403.79,1),(6,13,'8653E96',3,139.85,1),(6,14,'07735Y4',3,500.50,1),(6,15,'S602HV3',3,644.20,1),(6,16,'235E510',1,62.51,1),(6,17,'8654E78',1,626.65,1),(6,18,'B99J147',1,287.57,1),(6,19,'8654C18',2,403.79,1),(7,1,'242E446',1,69.64,2),(7,2,'8654Q92',1,122.09,2),(7,3,'8654E78',14,626.65,2),(7,4,'B99J150',4,436.82,2),(7,5,'8654E79',8,572.16,2),(7,6,'8654E85',15,591.11,2),(7,7,'8653T54',8,403.79,2),(7,8,'S602HV3',6,644.20,2),(7,9,'2704342',2,1737.37,2),(7,10,'8653T45',2,586.38,2),(7,11,'8654C23',1,276.01,2),(7,12,'W890502',1,497.29,2),(7,13,'S602NE6',8,386.82,2),(7,14,'6181677',8,231.87,2),(7,15,'558L509',1,644.35,2),(7,16,'404S523',1,971.63,2),(7,17,'8653E96',1,139.85,2),(7,18,'S602RA1',9,433.95,2),(7,19,'Z660129',1,4395.37,2),(7,20,'8653X54',10,180.86,2),(8,1,'2752959',4,610.15,0),(8,2,'1411068',13,85.14,0),(8,3,'8653E96',3,139.85,0),(8,4,'886J094',3,595.85,0),(8,5,'Z660119',1,451.33,0),(8,6,'4065200',5,171.66,0),(9,1,'94331QK',11,54.33,4),(9,2,'8653S15',5,444.52,4),(9,3,'S602HU7',5,436.85,4),(9,4,'404S523',3,971.63,4),(9,5,'242L743',1,111.57,4),(9,6,'0713245',2,576.50,4),(9,7,'2704148',3,368.14,4),(9,8,'07735Y4',1,500.50,4),(9,9,'8654F40',12,676.63,4),(9,10,'1411068',9,85.14,4),(9,11,'9436E6N',1,1084.77,4),(9,12,'B940695',13,14.74,4),(9,13,'8654P49',1,171.54,4),(9,14,'242L743',1,111.57,4),(9,15,'558L510',15,831.21,4),(10,1,'8654E82',1,508.19,3),(10,2,'B940692',4,15.55,3),(10,3,'4065298',14,91.81,3),(10,4,'S602PQ4',13,533.77,3),(10,5,'B99J150',5,436.82,3),(10,6,'943766X',8,491.14,3),(10,7,'077MS34',5,246.24,3),(10,8,'235E508',1,61.88,3),(10,9,'1410767',7,53.47,3),(10,10,'4065265',14,155.19,3),(10,11,'2359986',2,74.48,3),(10,12,'R340871',1,185.51,3),(10,13,'404T988',15,1501.74,3),(10,14,'0713245',1,576.50,3),(11,1,'4065260',14,158.38,1),(11,2,'Z660122',8,289.99,1),(11,3,'0713245',1,576.50,1),(11,4,'242L763',4,54.87,1),(11,5,'4065260',2,158.38,1),(11,6,'0713245',1,576.50,1),(11,7,'242G457',2,147.69,1),(11,8,'8653T45',3,586.38,1),(11,9,'1410769',13,55.66,1),(11,10,'242C283',1,82.30,1),(11,11,'4065174',8,18.13,1),(11,12,'2752959',3,610.15,1),(11,13,'2704488',3,3171.93,1),(11,14,'404S890',12,528.41,1),(11,15,'W890506',2,1606.03,1),(11,16,'8654E84',3,484.50,1),(12,1,'8654C19',3,420.54,1),(12,2,'6181517',2,1604.94,1),(12,3,'404S893',1,976.95,1),(12,4,'B99K231',6,23.33,1),(12,5,'W890505',1,1163.20,1),(12,6,'242G454',9,114.85,1),(12,7,'B940644',4,27.38,1),(12,8,'886H120',15,28.63,1),(12,9,'943766W',15,409.95,1),(12,10,'8654E84',5,484.50,1),(12,11,'404S524',5,971.63,1),(12,12,'Z660129',1,4395.37,1),(12,13,'6181508',1,1357.03,1),(12,14,'S602PX5',8,453.63,1),(12,15,'8654P49',1,171.54,1),(12,16,'9436E6P',3,991.60,1),(12,17,'4065115',9,531.07,1),(12,18,'94389AF',2,455.08,1),(12,19,'0713263',2,2190.73,1),(12,20,'8654Q92',1,122.09,1),(13,1,'B99K231',8,23.33,0),(13,2,'4065115',6,531.07,0),(13,3,'8653S15',3,444.52,0),(13,4,'6181508',1,1357.03,0),(13,5,'404U040',3,704.49,0),(14,1,'8653X54',4,180.86,1),(14,2,'5844105',4,76.41,1),(14,3,'4065204',6,280.21,1),(14,4,'9436E6P',13,991.60,1),(14,5,'1411068',11,85.14,1),(14,6,'4065091',1,16.31,1),(14,7,'242G457',2,147.69,1),(14,8,'Z660122',7,289.99,1),(14,9,'8653E96',3,139.85,1),(14,10,'9437G2T',1,849.18,1),(14,11,'B99J150',6,436.82,1),(14,12,'8653T45',8,586.38,1),(14,13,'886J094',15,595.85,1),(14,14,'404T988',10,1501.74,1),(14,15,'404S891',5,1446.43,1),(14,16,'9436E6P',10,991.60,1),(14,17,'8653T54',4,403.79,1),(14,18,'Z660119',1,451.33,1),(14,19,'2704123',8,477.31,1),(14,20,'8653E96',1,139.85,1),(15,1,'886J094',14,595.85,2),(15,2,'S602PX5',14,453.63,2),(15,3,'8654J46',1,126.45,2),(15,4,'1410768',1,53.47,2),(15,5,'5844105',2,76.41,2),(15,6,'8654F40',9,676.63,2),(15,7,'1411134',13,56.75,2),(15,8,'9437G4D',1,1128.69,2),(15,9,'8654H63',1,413.42,2),(15,10,'404R440',11,1400.26,2),(15,11,'886H121',3,28.63,2),(15,12,'242N561',7,99.51,2),(15,13,'B940644',15,27.38,2),(15,14,'558L097',5,1189.45,2),(15,15,'404S523',2,971.63,2),(15,16,'558L510',9,831.21,2),(15,17,'W890503',2,669.70,2),(16,1,'8653D08',1,174.54,1),(16,2,'077MR98',1,111.80,1),(16,3,'S602RA1',3,433.95,1),(16,4,'B99J148',10,347.25,1),(16,5,'886H121',14,28.63,1),(16,6,'242L762',9,59.70,1),(16,7,'8653D08',3,174.54,1),(16,8,'886H119',8,28.63,1),(16,9,'S602RA1',2,433.95,1),(16,10,'S602LB1',3,563.01,1),(16,11,'8654E99',5,403.79,1),(16,12,'8654E81',11,420.54,1),(16,13,'8654E83',5,591.11,1),(16,14,'Z660122',2,289.99,1),(16,15,'235E508',1,61.88,1),(17,1,'B99J147',1,287.57,1),(17,2,'558L509',2,644.35,1),(17,3,'8654C23',1,276.01,1),(18,1,'242L743',1,111.57,4),(18,2,'8653L70',4,403.79,4),(18,3,'235E508',2,61.88,4),(18,4,'9436SGF',12,829.98,4),(18,5,'8654C22',8,413.42,4),(18,6,'077MR98',1,111.80,4),(18,7,'8654E82',12,508.19,4),(18,8,'8653E96',3,139.85,4),(19,1,'479V375',1,1057.38,4),(19,2,'242E446',2,69.64,4),(19,3,'8654F40',7,676.63,4),(19,4,'8654C19',8,420.54,4),(19,5,'4065263',6,158.53,4),(19,6,'2752951',1,176.87,4),(19,7,'8653T54',13,403.79,4),(19,8,'1410769',12,55.66,4),(19,9,'558L510',13,831.21,4),(19,10,'S602HV8',4,779.54,4),(19,11,'S602TZ5',1,1097.13,4),(19,12,'B99K043',5,523.25,4),(19,13,'9437G1S',6,573.27,4),(19,14,'4065200',2,171.66,4),(19,15,'886G524',8,28.63,4),(19,16,'8653D08',1,174.54,4),(19,17,'S602FN8',5,656.18,4),(19,18,'2704123',1,477.31,4),(20,1,'S602TZ5',1,1097.13,2),(20,2,'8654C23',1,276.01,2),(20,3,'8654C22',9,413.42,2),(20,4,'2359982',1,213.00,2),(20,5,'886G524',8,28.63,2),(20,6,'1410769',11,55.66,2),(20,7,'S602LB1',1,563.01,2),(20,8,'9436E6P',12,991.60,2),(20,9,'9436L7T',3,1213.87,2),(21,1,'S602NE6',9,386.82,2),(21,2,'9437G2F',2,854.42,2),(21,3,'8654E82',14,508.19,2),(21,4,'4065298',1,91.81,2),(21,5,'404S913',9,874.65,2),(22,1,'8654E83',13,591.11,4),(22,2,'886H121',3,28.63,4),(22,3,'8654H62',11,591.11,4),(22,4,'8653T45',11,586.38,4),(22,5,'8653X54',4,180.86,4),(22,6,'B99K000',10,18.40,4),(22,7,'2752951',1,176.87,4),(22,8,'404T635',1,932.51,4),(22,9,'2704148',2,368.14,4),(22,10,'8653D08',6,174.54,4),(22,11,'B99J147',1,287.57,4),(22,12,'B940644',10,27.38,4),(22,13,'4065263',8,158.53,4),(22,14,'S602HV8',6,779.54,4),(22,15,'886H121',14,28.63,4),(22,16,'4065174',12,18.13,4),(23,1,'8654C19',12,420.54,1),(23,2,'R341086',1,470.51,1),(24,1,'07735Y4',4,500.50,0),(24,2,'404R442',1,971.63,0),(24,3,'B99K231',11,23.33,0),(24,4,'077MS34',8,246.24,0),(24,5,'8654C23',1,276.01,0),(24,6,'8653L70',9,403.79,0),(24,7,'886J094',10,595.85,0),(24,8,'404N216',1,71.23,0),(24,9,'S602PP2',1,436.85,0),(24,10,'R341086',3,470.51,0),(24,11,'S602PQ0',15,955.60,0),(24,12,'4065174',1,18.13,0),(24,13,'2752951',1,176.87,0),(24,14,'9437G2D',5,793.30,0),(24,15,'943VHQ0',1,120.10,0),(24,16,'8654Q92',1,122.09,0),(24,17,'404N216',1,71.23,0),(25,1,'R340871',1,185.51,1),(25,2,'8654H62',11,591.11,1),(25,3,'886K037',1,1067.30,1),(25,4,'2704123',9,477.31,1),(25,5,'S602PX5',14,453.63,1),(25,6,'8654E83',5,591.11,1),(25,7,'235E509',1,62.51,1),(25,8,'2704488',1,3171.93,1),(25,9,'8654E81',9,420.54,1),(25,10,'404S913',4,874.65,1),(25,11,'1410767',14,53.47,1),(25,12,'8654E85',8,591.11,1),(25,13,'9436SGF',5,829.98,1),(25,14,'2704423',2,4132.40,1),(25,15,'S602HV8',9,779.54,1),(25,16,'1411068',9,85.14,1),(25,17,'0772VS2',1,263.54,1),(26,1,'8654E82',9,508.19,4),(26,2,'8654E99',11,403.79,4),(26,3,'S602PX5',9,453.63,4),(26,4,'S602TZ5',1,1097.13,4),(26,5,'242G457',2,147.69,4),(26,6,'6181508',1,1357.03,4),(26,7,'8654E99',6,403.79,4),(26,8,'4065316',3,234.96,4),(27,1,'8654H63',2,413.42,0),(27,2,'2359982',1,213.00,0),(27,3,'8653S15',9,444.52,0),(27,4,'9437F1J',5,561.05,0),(27,5,'B940692',13,15.55,0),(27,6,'Z660118',4,483.38,0),(27,7,'8654E83',9,591.11,0),(27,8,'5844105',3,76.41,0),(27,9,'886G524',12,28.63,0),(27,10,'4065174',6,18.13,0),(27,11,'242G454',3,114.85,0),(28,1,'Z660117',2,1343.35,4),(28,2,'4065298',6,91.81,4),(28,3,'235E508',2,61.88,4),(28,4,'886J094',4,595.85,4),(28,5,'1410769',4,55.66,4),(28,6,'8654E81',11,420.54,4),(28,7,'2359569',1,152.58,4),(28,8,'B99K231',6,23.33,4),(28,9,'2704123',3,477.31,4),(28,10,'8654E83',15,591.11,4),(28,11,'943VHQ0',2,120.10,4),(28,12,'R340871',1,185.51,4),(28,13,'235E508',2,61.88,4),(28,14,'8654Q92',1,122.09,4),(28,15,'404S903',13,971.63,4),(28,16,'8654F40',10,676.63,4),(29,1,'S602MP2',13,506.46,4),(29,2,'8653T54',5,403.79,4),(29,3,'242G454',6,114.85,4),(29,4,'6181517',2,1604.94,4),(29,5,'8654E82',10,508.19,4),(29,6,'4065091',14,16.31,4),(29,7,'9436SGF',1,829.98,4),(29,8,'943766W',8,409.95,4),(29,9,'B99H836',5,750.01,4),(30,1,'07735Y4',3,500.50,4),(30,2,'8654E79',7,572.16,4),(30,3,'404S524',3,971.63,4),(30,4,'077WN45',6,509.99,4),(30,5,'9436E6P',2,991.60,4),(31,1,'8653D08',9,174.54,4),(31,2,'242N561',4,99.51,4),(31,3,'404S890',7,528.41,4),(31,4,'W890503',2,669.70,4),(31,5,'0772VS2',1,263.54,4),(31,6,'8654H62',11,591.11,4),(31,7,'B99H834',15,517.57,4),(31,8,'8652V94',4,138.80,4),(31,9,'0713242',1,300.50,4),(31,10,'8653L70',1,403.79,4),(31,11,'S602PX5',10,453.63,4),(31,12,'4065260',4,158.38,4),(31,13,'0713263',1,2190.73,4),(32,1,'404R442',1,971.63,1),(32,2,'B940693',8,24.47,1),(32,3,'242L743',2,111.57,1),(32,4,'6181517',2,1604.94,1),(32,5,'8653X54',12,180.86,1),(32,6,'4065091',8,16.31,1),(32,7,'8654E81',1,420.54,1),(33,1,'8654C18',8,403.79,2),(33,2,'2359986',1,74.48,2),(33,3,'S602VG6',1,1881.26,2),(33,4,'4065200',7,171.66,2),(33,5,'4065091',1,16.31,2),(33,6,'404S891',8,1446.43,2),(33,7,'B99K233',1,31.88,2),(33,8,'404S893',11,976.95,2),(34,1,'1411058',6,190.99,3),(34,2,'943VHQ0',1,120.10,3),(34,3,'S602HU7',13,436.85,3),(34,4,'9436E6N',8,1084.77,3),(34,5,'8654F39',5,593.00,3),(34,6,'479V375',2,1057.38,3),(34,7,'4065240',6,264.37,3),(34,8,'235E510',1,62.51,3),(35,1,'404T668',1,504.50,1),(35,2,'4065316',1,234.96,1),(35,3,'Z660118',3,483.38,1),(35,4,'558L508',10,458.36,1),(35,5,'S602MP2',13,506.46,1),(35,6,'8654E85',1,591.11,1),(35,7,'404N216',1,71.23,1),(35,8,'404R440',14,1400.26,1),(35,9,'9437G2F',7,854.42,1),(35,10,'2704342',1,1737.37,1),(35,11,'242L762',13,59.70,1),(35,12,'8653T45',2,586.38,1),(35,13,'0713263',1,2190.73,1),(35,14,'8653E96',2,139.85,1),(35,15,'1410769',11,55.66,1),(36,1,'558L097',6,1189.45,4),(36,2,'242E446',3,69.64,4),(36,3,'0713249',2,558.50,4),(36,4,'B99H836',2,750.01,4),(36,5,'404R440',2,1400.26,4),(36,6,'886J094',5,595.85,4),(36,7,'242L764',3,54.87,4),(36,8,'886K037',1,1067.30,4),(36,9,'8653T45',4,586.38,4),(36,10,'R341086',3,470.51,4),(36,11,'8654Q92',1,122.09,4),(36,12,'S602PP2',1,436.85,4),(36,13,'8654C35',3,433.08,4),(36,14,'2704488',1,3171.93,4),(36,15,'235E509',1,62.51,4),(36,16,'8654F40',7,676.63,4),(36,17,'8654F39',6,593.00,4),(37,1,'077MS34',9,246.24,3),(37,2,'242E446',1,69.64,3),(37,3,'8653T54',10,403.79,3),(37,4,'B99K004',1,85.21,3),(37,5,'404R442',1,971.63,3),(37,6,'S602PQ4',12,533.77,3),(37,7,'8654E78',2,626.65,3),(37,8,'404S891',11,1446.43,3),(37,9,'9437F1J',13,561.05,3),(37,10,'1410767',3,53.47,3),(37,11,'886G524',1,28.63,3),(37,12,'2359982',1,213.00,3),(37,13,'S602TZ5',1,1097.13,3),(37,14,'1410769',8,55.66,3),(37,15,'886H119',7,28.63,3),(38,1,'558L510',12,831.21,0),(39,1,'9436E6P',9,991.60,1),(39,2,'1411131',11,103.67,1),(39,3,'8654C19',12,420.54,1),(39,4,'2359569',1,152.58,1),(39,5,'R341086',1,470.51,1),(40,1,'Z660131',2,461.82,2),(41,1,'558L097',12,1189.45,1),(41,2,'8654H62',2,591.11,1),(41,3,'242C283',1,82.30,1),(41,4,'S602VG6',1,1881.26,1),(41,5,'2704727',3,1522.68,1),(41,6,'404U040',7,704.49,1),(41,7,'886K037',1,1067.30,1),(41,8,'6181517',2,1604.94,1),(41,9,'4065260',1,158.38,1),(41,10,'1410768',6,53.47,1),(41,11,'8653E96',3,139.85,1),(41,12,'1410767',5,53.47,1),(41,13,'S602RA1',11,433.95,1),(41,14,'6181517',2,1604.94,1),(41,15,'8653S15',5,444.52,1),(42,1,'2704488',2,3171.93,1),(43,1,'S602HU7',10,436.85,2),(43,2,'886J093',10,553.58,2),(43,3,'242G454',8,114.85,2),(43,4,'8652V94',1,138.80,2),(43,5,'404S913',14,874.65,2),(43,6,'W890506',4,1606.03,2),(44,1,'B99J148',11,347.25,1),(44,2,'4065240',2,264.37,1),(44,3,'077WN45',3,509.99,1),(44,4,'1410767',12,53.47,1),(44,5,'1410768',11,53.47,1),(44,6,'2704148',3,368.14,1),(44,7,'558L509',3,644.35,1),(44,8,'S602VG6',2,1881.26,1),(44,9,'S602FN8',2,656.18,1),(44,10,'4065260',5,158.38,1),(44,11,'9437G2F',7,854.42,1),(44,12,'2359986',2,74.48,1),(44,13,'2359569',1,152.58,1),(44,14,'07735Y4',1,500.50,1),(44,15,'B99K233',3,31.88,1),(44,16,'242N561',2,99.51,1),(45,1,'8654E84',5,484.50,2),(45,2,'Z660119',2,451.33,2),(45,3,'Z660117',4,1343.35,2),(45,4,'2752951',1,176.87,2),(45,5,'2704123',5,477.31,2),(45,6,'S602LB1',3,563.01,2),(45,7,'886H121',12,28.63,2),(45,8,'8653L70',9,403.79,2),(45,9,'8654C22',9,413.42,2),(45,10,'404U040',15,704.49,2),(45,11,'0713249',1,558.50,2),(45,12,'077MS34',2,246.24,2),(45,13,'4065115',8,531.07,2),(45,14,'404S913',11,874.65,2),(45,15,'B99J147',1,287.57,2),(45,16,'0713249',1,558.50,2),(45,17,'886H119',7,28.63,2),(45,18,'404U264',14,954.56,2),(45,19,'R341086',2,470.51,2),(45,20,'07714M0',2,146.62,2),(46,1,'B99J147',1,287.57,0),(46,2,'8654C18',12,403.79,0),(46,3,'8653X54',11,180.86,0),(46,4,'1411158',11,103.09,0),(46,5,'9436SGF',12,829.98,0),(47,1,'242L760',3,54.87,2),(47,2,'235E509',1,62.51,2),(47,3,'8654E83',11,591.11,2),(47,4,'9437G2F',4,854.42,2),(47,5,'886K037',1,1067.30,2),(47,6,'2704123',5,477.31,2),(47,7,'8654E85',3,591.11,2),(47,8,'B940695',7,14.74,2),(47,9,'6181508',1,1357.03,2),(47,10,'242E446',1,69.64,2),(47,11,'886J096',2,1007.33,2),(47,12,'R341086',2,470.51,2),(47,13,'4065204',4,280.21,2),(47,14,'8654E81',6,420.54,2),(47,15,'558L509',9,644.35,2),(47,16,'S602PX5',7,453.63,2),(47,17,'W890503',2,669.70,2),(48,1,'8654E80',10,366.04,2),(48,2,'S602VG6',1,1881.26,2),(48,3,'S602HV3',2,644.20,2),(48,4,'0713249',2,558.50,2),(48,5,'W890503',1,669.70,2),(48,6,'404S524',2,971.63,2),(48,7,'S602MP2',9,506.46,2),(48,8,'8654H63',9,413.42,2),(48,9,'242L743',2,111.57,2),(48,10,'235B624',1,161.66,2),(48,11,'W890505',2,1163.20,2),(49,1,'Z660118',4,483.38,0),(49,2,'Z660119',2,451.33,0),(49,3,'8654E84',4,484.50,0),(49,4,'Z660122',9,289.99,0),(50,1,'94331QK',9,54.33,4),(50,2,'8652V94',3,138.80,4),(50,3,'S602FN8',4,656.18,4),(50,4,'4065115',5,531.07,4),(50,5,'479V375',2,1057.38,4),(50,6,'8652V94',3,138.80,4),(50,7,'404S905',7,991.46,4),(50,8,'479V375',3,1057.38,4),(50,9,'886J093',1,553.58,4),(50,10,'235E510',1,62.51,4),(50,11,'943VHQ0',2,120.10,4),(51,1,'9436L7T',3,1213.87,3),(51,2,'886J093',10,553.58,3),(51,3,'886J095',15,1167.77,3),(51,4,'404T925',3,981.44,3),(51,5,'6181517',2,1604.94,3),(51,6,'B99K004',2,85.21,3),(51,7,'8654E80',4,366.04,3),(51,8,'8654J46',1,126.45,3),(51,9,'8654C22',10,413.42,3),(51,10,'B99J501',1,1775.57,3),(52,1,'S602TZ5',1,1097.13,3),(52,2,'1411158',3,103.09,3),(52,3,'242N561',4,99.51,3),(53,1,'0713263',1,2190.73,4),(53,2,'4065115',5,531.07,4),(53,3,'2359986',2,74.48,4),(53,4,'1411131',2,103.67,4),(53,5,'242L743',2,111.57,4),(53,6,'077MS34',7,246.24,4),(53,7,'S602NE6',1,386.82,4),(53,8,'S602PQ4',15,533.77,4),(53,9,'8652V94',3,138.80,4),(54,1,'8654H63',9,413.42,0),(54,2,'8653T54',5,403.79,0),(54,3,'8654E81',15,420.54,0),(54,4,'B99J501',1,1775.57,0),(54,5,'404S524',1,971.63,0),(54,6,'9437F1J',9,561.05,0),(54,7,'404S109',6,711.67,0),(54,8,'4064078',8,169.04,0),(54,9,'8653X54',8,180.86,0),(54,10,'W890505',3,1163.20,0),(54,11,'B940644',12,27.38,0),(54,12,'2704342',2,1737.37,0),(54,13,'242E446',3,69.64,0),(55,1,'077PC04',4,246.24,2),(55,2,'886J712',1,913.15,2),(55,3,'S602LB1',3,563.01,2),(55,4,'B99J150',5,436.82,2),(55,5,'404T925',2,981.44,2),(56,1,'B99K000',6,18.40,0),(56,2,'R341086',1,470.51,0),(56,3,'8654F39',6,593.00,0),(56,4,'558L509',14,644.35,0),(56,5,'886G524',2,28.63,0),(56,6,'B99J501',1,1775.57,0),(56,7,'07714M0',4,146.62,0),(56,8,'242L762',11,59.70,0),(56,9,'2359982',1,213.00,0),(56,10,'4065204',10,280.21,0),(56,11,'07714M0',3,146.62,0),(56,12,'B940693',13,24.47,0),(56,13,'S602HU7',7,436.85,0),(56,14,'235B624',2,161.66,0),(56,15,'558L508',2,458.36,0),(56,16,'S602HU7',7,436.85,0),(56,17,'0713249',2,558.50,0),(56,18,'2704148',3,368.14,0),(56,19,'886H121',10,28.63,0),(57,1,'9437G2F',6,854.42,0),(57,2,'404R442',1,971.63,0),(57,3,'886J712',1,913.15,0),(57,4,'8654E82',8,508.19,0),(57,5,'4065204',4,280.21,0),(57,6,'8654C19',12,420.54,0),(57,7,'077WN45',2,509.99,0),(57,8,'404T925',3,981.44,0),(57,9,'8654C23',1,276.01,0),(57,10,'8653T54',5,403.79,0),(57,11,'404R440',12,1400.26,0),(57,12,'404T668',2,504.50,0),(57,13,'8654E83',11,591.11,0),(57,14,'077PC04',7,246.24,0),(58,1,'1410768',10,53.47,3),(58,2,'8654F39',8,593.00,3),(58,3,'9437G4D',2,1128.69,3),(58,4,'B99K004',2,85.21,3),(58,5,'8653T54',8,403.79,3),(58,6,'S602MP2',11,506.46,3),(59,1,'886J096',5,1007.33,1),(59,2,'404N216',1,71.23,1),(59,3,'9437G2T',5,849.18,1),(59,4,'8653T45',1,586.38,1),(60,1,'S602RA1',1,433.95,1),(61,1,'B99J150',9,436.82,1),(61,2,'8653D08',10,174.54,1),(61,3,'2359986',1,74.48,1),(61,4,'W890506',3,1606.03,1),(61,5,'404T925',10,981.44,1),(61,6,'S602TZ5',1,1097.13,1),(61,7,'242L764',4,54.87,1),(61,8,'B99K233',4,31.88,1),(61,9,'0713249',2,558.50,1),(62,1,'404T635',1,932.51,4),(62,2,'886J093',10,553.58,4),(62,3,'1410769',4,55.66,4),(62,4,'404S890',4,528.41,4),(62,5,'0713245',2,576.50,4),(62,6,'Z660117',5,1343.35,4),(63,1,'8653D08',13,174.54,0),(63,2,'8654H62',14,591.11,0),(63,3,'2752959',5,610.15,0),(64,1,'9437G4D',2,1128.69,4),(64,2,'8654H62',9,591.11,4),(64,3,'242L760',14,54.87,4),(64,4,'886J096',12,1007.33,4),(64,5,'235E509',1,62.51,4),(64,6,'8653S15',1,444.52,4),(64,7,'404S903',15,971.63,4),(64,8,'Z660131',6,461.82,4),(64,9,'235E510',1,62.51,4),(64,10,'404S913',11,874.65,4),(65,1,'077MR98',1,111.80,4),(65,2,'886G524',13,28.63,4),(65,3,'2704727',1,1522.68,4),(65,4,'242E446',3,69.64,4),(65,5,'S602FN8',4,656.18,4),(65,6,'8652V94',2,138.80,4),(65,7,'2704342',2,1737.37,4),(66,1,'886K037',1,1067.30,1),(66,2,'404S109',11,711.67,1),(66,3,'558L510',2,831.21,1),(66,4,'2704423',3,4132.40,1),(66,5,'S602TZ5',1,1097.13,1),(66,6,'4065265',13,155.19,1),(66,7,'404S903',7,971.63,1),(66,8,'Z660117',1,1343.35,1),(67,1,'1411131',2,103.67,3),(67,2,'8654H62',6,591.11,3),(67,3,'4065091',10,16.31,3),(67,4,'4065174',1,18.13,3),(67,5,'8654P49',1,171.54,3),(67,6,'B940692',13,15.55,3),(67,7,'404S913',15,874.65,3),(67,8,'235E508',2,61.88,3),(67,9,'S602PP2',1,436.85,3),(67,10,'235E510',1,62.51,3),(67,11,'6181508',1,1357.03,3),(67,12,'8653T45',4,586.38,3),(67,13,'242L763',10,54.87,3),(67,14,'8654E78',1,626.65,3),(67,15,'94389AF',2,455.08,3),(67,16,'B940693',6,24.47,3),(67,17,'1411134',10,56.75,3),(67,18,'886H119',11,28.63,3),(68,1,'B99K004',2,85.21,4),(68,2,'077MS34',13,246.24,4),(68,3,'1410768',14,53.47,4),(68,4,'235E508',1,61.88,4),(68,5,'8653T45',3,586.38,4),(68,6,'2704123',7,477.31,4),(68,7,'W890503',2,669.70,4),(68,8,'9436SGF',4,829.98,4),(68,9,'6181740',3,932.72,4),(68,10,'943766X',11,491.14,4),(68,11,'B99J148',10,347.25,4),(68,12,'1411068',13,85.14,4),(68,13,'886J712',1,913.15,4),(68,14,'1410767',8,53.47,4),(68,15,'6181740',1,932.72,4),(69,1,'242L743',1,111.57,0),(69,2,'9436SGF',1,829.98,0),(69,3,'242N561',6,99.51,0),(70,1,'404S524',2,971.63,1),(70,2,'235B624',1,161.66,1),(70,3,'0772VS2',1,263.54,1),(70,4,'9436E6P',9,991.60,1),(70,5,'404U264',9,954.56,1),(70,6,'6181740',4,932.72,1),(70,7,'B940693',15,24.47,1),(70,8,'4065091',8,16.31,1),(71,1,'4065316',5,234.96,0),(71,2,'8654E83',11,591.11,0),(71,3,'242N561',3,99.51,0),(71,4,'404S523',2,971.63,0),(71,5,'886J095',14,1167.77,0),(71,6,'8654E80',4,366.04,0),(71,7,'6181517',2,1604.94,0),(71,8,'886J712',1,913.15,0),(71,9,'07735Y4',1,500.50,0),(71,10,'404S524',4,971.63,0),(71,11,'2704123',7,477.31,0),(71,12,'B940695',14,14.74,0),(71,13,'S602PQ5',1,641.61,0),(71,14,'886H120',13,28.63,0),(72,1,'0772VS2',1,263.54,4),(72,2,'404R440',7,1400.26,4),(72,3,'6181517',2,1604.94,4),(72,4,'404R440',11,1400.26,4),(72,5,'8654C23',1,276.01,4),(72,6,'B99K004',1,85.21,4),(72,7,'8654E79',4,572.16,4),(72,8,'2359982',1,213.00,4),(72,9,'S602TZ5',1,1097.13,4),(72,10,'943VHQ0',1,120.10,4),(72,11,'558L508',7,458.36,4),(72,12,'B99K233',2,31.88,4),(73,1,'8652V77',1,152.47,3),(73,2,'B99K043',15,523.25,3),(73,3,'S602PQ5',1,641.61,3),(73,4,'8654C35',12,433.08,3),(73,5,'886G524',6,28.63,3),(73,6,'404N216',1,71.23,3),(73,7,'558L510',15,831.21,3),(73,8,'077MR98',1,111.80,3),(73,9,'94331QK',15,54.33,3),(73,10,'5844105',4,76.41,3),(73,11,'404S523',1,971.63,3),(73,12,'2704727',1,1522.68,3),(73,13,'8654E85',1,591.11,3),(73,14,'242N561',4,99.51,3),(73,15,'943VHQ0',2,120.10,3),(73,16,'8654E84',1,484.50,3),(73,17,'558L508',6,458.36,3),(74,1,'8653X54',13,180.86,0),(74,2,'242L762',15,59.70,0),(74,3,'9437G1X',4,732.18,0),(75,1,'404T988',3,1501.74,2),(75,2,'8654Q92',1,122.09,2),(75,3,'8653T45',6,586.38,2),(75,4,'9436E6N',8,1084.77,2),(75,5,'2359982',1,213.00,2),(75,6,'235E510',1,62.51,2),(75,7,'242G457',1,147.69,2),(75,8,'B99K000',10,18.40,2),(75,9,'0713242',3,300.50,2),(75,10,'Z660129',1,4395.37,2),(75,11,'B99H836',15,750.01,2),(75,12,'077MS34',3,246.24,2),(75,13,'404R440',8,1400.26,2),(75,14,'8654E78',1,626.65,2),(75,15,'404N216',1,71.23,2),(75,16,'235E508',2,61.88,2),(76,1,'404S913',6,874.65,1),(76,2,'943766W',10,409.95,1),(76,3,'242G454',1,114.85,1),(76,4,'8653T45',10,586.38,1),(76,5,'9436E6N',3,1084.77,1),(76,6,'886J712',1,913.15,1),(76,7,'1410769',10,55.66,1),(76,8,'B99K231',5,23.33,1),(76,9,'886H120',6,28.63,1),(76,10,'9436L7T',5,1213.87,1),(76,11,'Z660131',7,461.82,1),(76,12,'9436SGF',13,829.98,1),(76,13,'8653L70',2,403.79,1),(76,14,'4065265',14,155.19,1),(76,15,'9437F1J',4,561.05,1),(76,16,'0713263',1,2190.73,1),(76,17,'404T668',2,504.50,1),(77,1,'943766X',10,491.14,0),(77,2,'9436L7T',3,1213.87,0),(77,3,'4065263',14,158.53,0),(77,4,'9437G2D',4,793.30,0),(77,5,'S602HV3',5,644.20,0),(77,6,'8654H63',5,413.42,0),(77,7,'886J093',15,553.58,0),(77,8,'9437G2F',7,854.42,0),(77,9,'2752951',1,176.87,0),(77,10,'S602NE6',11,386.82,0),(77,11,'077WN45',3,509.99,0),(77,12,'B940693',2,24.47,0),(77,13,'B99K231',3,23.33,0),(77,14,'886J096',8,1007.33,0),(77,15,'2359986',2,74.48,0),(77,16,'S602HU7',7,436.85,0),(78,1,'404R442',1,971.63,4),(78,2,'404S913',4,874.65,4),(78,3,'8653S15',8,444.52,4),(78,4,'6181508',1,1357.03,4),(78,5,'404U040',13,704.49,4),(78,6,'2752951',1,176.87,4),(78,7,'S602TZ5',1,1097.13,4),(78,8,'8654H62',10,591.11,4),(78,9,'Z660129',1,4395.37,4),(78,10,'2704423',3,4132.40,4),(79,1,'886G524',1,28.63,3),(79,2,'8652V94',6,138.80,3),(79,3,'S602HU7',5,436.85,3),(79,4,'2704342',2,1737.37,3),(79,5,'404R440',9,1400.26,3),(79,6,'8654E80',11,366.04,3),(79,7,'0713245',2,576.50,3),(79,8,'8652V94',1,138.80,3),(80,1,'2704148',3,368.14,2),(80,2,'8653S15',11,444.52,2),(81,1,'9436SGF',9,829.98,1),(81,2,'404T668',1,504.50,1),(81,3,'242L760',13,54.87,1),(81,4,'404S905',5,991.46,1),(81,5,'9436E6P',14,991.60,1),(81,6,'B99K043',14,523.25,1),(81,7,'Z660131',8,461.82,1),(81,8,'9437G4D',1,1128.69,1),(81,9,'2704423',3,4132.40,1),(81,10,'Z660129',1,4395.37,1),(81,11,'8653E96',2,139.85,1),(81,12,'Z660118',1,483.38,1),(81,13,'8654E78',7,626.65,1),(82,1,'1411127',14,76.39,1),(82,2,'8654C18',1,403.79,1),(82,3,'Z660117',5,1343.35,1),(82,4,'558L510',6,831.21,1),(82,5,'Z660117',2,1343.35,1),(82,6,'W890506',1,1606.03,1),(82,7,'077MR98',1,111.80,1),(82,8,'R340871',1,185.51,1),(82,9,'B99J148',9,347.25,1),(82,10,'2704342',2,1737.37,1),(82,11,'4065174',7,18.13,1),(83,1,'886J096',13,1007.33,2),(83,2,'404T668',2,504.50,2),(83,3,'B99K231',5,23.33,2),(84,1,'W890505',1,1163.20,2),(84,2,'9437G1S',9,573.27,2),(84,3,'8653T45',7,586.38,2),(84,4,'8653E96',2,139.85,2),(84,5,'4065260',15,158.38,2),(84,6,'W890503',1,669.70,2),(84,7,'9437G1X',5,732.18,2),(84,8,'S602VG6',2,1881.26,2),(84,9,'S602NE6',3,386.82,2),(84,10,'2359982',1,213.00,2),(84,11,'2359986',2,74.48,2),(85,1,'404N216',1,71.23,3),(85,2,'8654H62',8,591.11,3),(85,3,'S602HU7',2,436.85,3),(85,4,'9437G1X',7,732.18,3),(86,1,'943766W',7,409.95,0),(86,2,'8654F40',4,676.63,0),(86,3,'4065240',2,264.37,0),(86,4,'W890506',3,1606.03,0),(86,5,'558L097',7,1189.45,0),(86,6,'4064078',9,169.04,0),(86,7,'S602PP2',1,436.85,0),(86,8,'2704423',3,4132.40,0),(86,9,'1410769',2,55.66,0),(86,10,'W890502',1,497.29,0),(86,11,'4065115',3,531.07,0),(86,12,'4065263',5,158.53,0),(86,13,'B99H834',4,517.57,0),(86,14,'886H121',14,28.63,0),(86,15,'943766W',2,409.95,0),(86,16,'2704342',2,1737.37,0),(86,17,'4065240',13,264.37,0),(86,18,'9436E6P',6,991.60,0),(86,19,'0713245',2,576.50,0),(87,1,'S602PQ5',1,641.61,3),(87,2,'S602HU7',10,436.85,3),(87,3,'9437G2D',13,793.30,3),(88,1,'404R442',1,971.63,2),(88,2,'404R442',1,971.63,2),(88,3,'4065298',10,91.81,2),(88,4,'S602TZ5',1,1097.13,2),(88,5,'S602FN8',3,656.18,2),(88,6,'8654Q92',1,122.09,2),(88,7,'404S913',10,874.65,2),(88,8,'242E446',3,69.64,2),(88,9,'2359986',2,74.48,2),(88,10,'94389AF',2,455.08,2),(88,11,'8654C22',9,413.42,2),(88,12,'8653X54',1,180.86,2),(88,13,'8654C23',1,276.01,2),(88,14,'404T635',1,932.51,2),(88,15,'0772VS2',1,263.54,2),(88,16,'886J096',12,1007.33,2),(88,17,'B99K043',9,523.25,2),(89,1,'W890505',2,1163.20,4),(89,2,'886H121',5,28.63,4),(90,1,'0713249',1,558.50,2),(90,2,'404T635',1,932.51,2),(90,3,'6181677',8,231.87,2),(91,1,'9437G2F',2,854.42,0),(91,2,'558L510',15,831.21,0),(91,3,'943766X',13,491.14,0),(91,4,'8653E96',2,139.85,0),(91,5,'242G454',10,114.85,0),(91,6,'2752951',1,176.87,0),(92,1,'B99K004',1,85.21,0),(92,2,'077MS34',12,246.24,0),(92,3,'0713245',2,576.50,0),(92,4,'242E446',1,69.64,0),(92,5,'9437G2B',2,732.18,0),(92,6,'404T988',5,1501.74,0),(92,7,'S602LB1',3,563.01,0),(92,8,'404T635',1,932.51,0),(92,9,'Z660117',3,1343.35,0),(92,10,'0713242',3,300.50,0),(92,11,'B940693',8,24.47,0),(92,12,'S602VG6',1,1881.26,0),(92,13,'Z660117',4,1343.35,0),(93,1,'B99H834',2,517.57,2),(93,2,'9437G2B',4,732.18,2),(93,3,'558L510',2,831.21,2),(93,4,'404R442',1,971.63,2),(93,5,'8654H62',7,591.11,2),(93,6,'9436E6P',2,991.60,2),(93,7,'8654E78',2,626.65,2),(93,8,'8653L70',1,403.79,2),(93,9,'8654F40',6,676.63,2),(93,10,'404S893',15,976.95,2),(93,11,'242G457',1,147.69,2),(93,12,'8654P49',1,171.54,2),(93,13,'8653S16',6,494.02,2),(93,14,'B99K004',1,85.21,2),(93,15,'077WN45',3,509.99,2),(93,16,'558L097',6,1189.45,2),(93,17,'8654C19',9,420.54,2),(93,18,'558L097',2,1189.45,2),(94,1,'W890505',1,1163.20,1),(94,2,'S602HU7',13,436.85,1),(95,1,'1411131',2,103.67,1),(95,2,'404T635',1,932.51,1),(95,3,'8654E79',1,572.16,1),(95,4,'0713245',1,576.50,1),(95,5,'242N561',7,99.51,1),(95,6,'242G457',1,147.69,1),(95,7,'2704123',1,477.31,1),(95,8,'4065263',7,158.53,1),(95,9,'242G454',9,114.85,1),(95,10,'235E508',2,61.88,1),(95,11,'4065174',5,18.13,1),(95,12,'B99J147',1,287.57,1),(96,1,'8654E78',12,626.65,4),(96,2,'8652V77',2,152.47,4),(96,3,'8653T54',2,403.79,4),(96,4,'4065115',6,531.07,4),(97,1,'8654E78',1,626.65,1),(97,2,'886J096',9,1007.33,1),(97,3,'8654C23',1,276.01,1),(97,4,'B940692',9,15.55,1),(97,5,'B940692',3,15.55,1),(97,6,'9437G2F',7,854.42,1),(97,7,'S602FN8',2,656.18,1),(97,8,'8654C18',13,403.79,1),(97,9,'B940693',6,24.47,1),(97,10,'479V375',1,1057.38,1),(97,11,'B99J147',1,287.57,1),(97,12,'2359569',1,152.58,1),(97,13,'1410768',4,53.47,1),(97,14,'R340871',1,185.51,1),(97,15,'404S893',12,976.95,1),(97,16,'B940692',9,15.55,1),(97,17,'4065115',6,531.07,1),(97,18,'077WN45',2,509.99,1),(97,19,'1411127',6,76.39,1),(97,20,'8654C18',1,403.79,1),(98,1,'9437G2B',4,732.18,0),(98,2,'4064078',11,169.04,0),(98,3,'558L508',12,458.36,0),(98,4,'8654C35',3,433.08,0),(98,5,'8653T54',12,403.79,0),(98,6,'8654E79',9,572.16,0),(98,7,'B99J501',1,1775.57,0),(98,8,'8654E84',3,484.50,0),(98,9,'404T668',2,504.50,0),(99,1,'B99H834',4,517.57,3),(99,2,'4065174',7,18.13,3),(99,3,'4065298',1,91.81,3),(99,4,'943766X',6,491.14,3),(99,5,'4064078',6,169.04,3),(99,6,'943VHQ0',1,120.10,3),(99,7,'2704423',1,4132.40,3),(99,8,'1411134',14,56.75,3),(99,9,'8652V94',3,138.80,3),(99,10,'2704123',7,477.31,3),(99,11,'235E508',1,61.88,3),(99,12,'S602MP2',2,506.46,3),(100,1,'242E446',2,69.64,2),(100,2,'8654F40',14,676.63,2),(100,3,'8654C19',8,420.54,2),(100,4,'4065260',11,158.38,2),(101,1,'404T635',1,932.51,0),(101,2,'404S905',7,991.46,0),(101,3,'886H120',9,28.63,0),(102,1,'2359986',1,74.48,2),(102,2,'1411131',14,103.67,2),(102,3,'B940692',3,15.55,2),(102,4,'886H120',14,28.63,2),(103,1,'8654P49',1,171.54,4),(103,2,'8653T54',1,403.79,4),(103,3,'94389AF',1,455.08,4),(103,4,'Z660118',1,483.38,4),(103,5,'4065263',7,158.53,4),(103,6,'8654H62',10,591.11,4),(104,1,'242C283',1,82.30,2),(104,2,'0713249',1,558.50,2),(104,3,'558L508',1,458.36,2),(104,4,'6181677',2,231.87,2),(104,5,'886J094',13,595.85,2),(104,6,'B99J150',7,436.82,2),(104,7,'9437G4D',1,1128.69,2),(104,8,'2752951',1,176.87,2),(104,9,'B99J501',1,1775.57,2),(104,10,'8654J46',13,126.45,2),(104,11,'Z660119',2,451.33,2),(105,1,'8654E84',3,484.50,2),(105,2,'4065240',13,264.37,2),(105,3,'1411158',7,103.09,2),(105,4,'8654C23',1,276.01,2),(105,5,'404S890',9,528.41,2),(106,1,'S602RA1',11,433.95,1),(106,2,'S602MP2',8,506.46,1),(106,3,'235E509',1,62.51,1),(106,4,'9436SGF',8,829.98,1),(106,5,'404N216',1,71.23,1),(106,6,'R340871',1,185.51,1),(106,7,'B99J150',1,436.82,1),(106,8,'8653L70',9,403.79,1),(106,9,'404S524',3,971.63,1),(106,10,'8654H62',1,591.11,1),(106,11,'5844105',1,76.41,1),(106,12,'B99J147',1,287.57,1),(106,13,'B99J147',1,287.57,1),(106,14,'242C283',1,82.30,1),(106,15,'B940644',13,27.38,1),(106,16,'S602HU7',5,436.85,1),(106,17,'B99K231',7,23.33,1),(106,18,'B940644',9,27.38,1),(107,1,'8654E99',4,403.79,1),(107,2,'943766X',1,491.14,1),(107,3,'886H121',4,28.63,1),(107,4,'1411134',2,56.75,1),(107,5,'6181677',4,231.87,1),(108,1,'B99K043',3,523.25,2),(108,2,'Z660118',3,483.38,2),(108,3,'S602PQ4',9,533.77,2),(109,1,'8654E81',1,420.54,4),(109,2,'07735Y4',1,500.50,4),(109,3,'9437G2F',7,854.42,4),(109,4,'404T925',1,981.44,4),(109,5,'404S903',14,971.63,4),(109,6,'4064078',6,169.04,4),(109,7,'4065115',6,531.07,4),(109,8,'B99K233',1,31.88,4),(109,9,'6181508',1,1357.03,4),(109,10,'Z660118',2,483.38,4),(109,11,'242L762',6,59.70,4),(109,12,'8654F40',15,676.63,4),(109,13,'9436E6N',11,1084.77,4),(109,14,'B99J150',2,436.82,4),(109,15,'8654E84',8,484.50,4),(109,16,'8654H63',7,413.42,4),(109,17,'8653S16',12,494.02,4),(109,18,'8654F40',7,676.63,4),(110,1,'B99H836',15,750.01,4),(110,2,'8653L70',7,403.79,4),(111,1,'8654E85',15,591.11,0),(111,2,'886J712',1,913.15,0),(111,3,'S602PQ5',1,641.61,0),(111,4,'2704423',2,4132.40,0),(112,1,'6181740',3,932.72,4),(112,2,'S602FN8',6,656.18,4),(112,3,'9436E6P',3,991.60,4),(112,4,'B99H834',6,517.57,4),(112,5,'B940644',7,27.38,4),(112,6,'242E446',1,69.64,4),(112,7,'8654H63',2,413.42,4),(112,8,'886J712',1,913.15,4),(112,9,'242C283',1,82.30,4),(112,10,'077WN45',5,509.99,4),(112,11,'B99J150',10,436.82,4),(112,12,'9436L7T',1,1213.87,4),(112,13,'B99H836',3,750.01,4),(112,14,'886K037',1,1067.30,4),(113,1,'07735Y4',1,500.50,1),(113,2,'B940644',15,27.38,1),(113,3,'4065316',2,234.96,1),(114,1,'S602MP2',8,506.46,4),(114,2,'S602PQ5',1,641.61,4),(114,3,'242E446',1,69.64,4),(115,1,'242C283',1,82.30,3),(116,1,'404S893',10,976.95,0),(116,2,'9437G2D',15,793.30,0),(116,3,'R341086',3,470.51,0),(116,4,'8653T45',3,586.38,0),(117,1,'943766X',13,491.14,3),(117,2,'1411068',4,85.14,3),(117,3,'S602HV3',2,644.20,3),(117,4,'9437G1S',12,573.27,3),(117,5,'9437G2D',10,793.30,3),(117,6,'8653L70',1,403.79,3),(117,7,'235B624',3,161.66,3),(117,8,'1411158',2,103.09,3),(117,9,'235E509',1,62.51,3),(117,10,'404S913',13,874.65,3),(117,11,'0713245',1,576.50,3),(117,12,'07735Y4',2,500.50,3),(117,13,'B940644',14,27.38,3),(117,14,'4065260',4,158.38,3),(118,1,'4065200',1,171.66,2),(118,2,'8654E82',7,508.19,2),(118,3,'8654E85',1,591.11,2),(118,4,'404R442',1,971.63,2),(118,5,'6181740',3,932.72,2),(118,6,'8654H62',15,591.11,2),(118,7,'886J712',1,913.15,2),(118,8,'4065263',7,158.53,2),(119,1,'R341086',2,470.51,0),(119,2,'558L510',8,831.21,0),(119,3,'Z660122',15,289.99,0),(119,4,'8653S15',10,444.52,0),(120,1,'8653D08',1,174.54,1),(120,2,'B99H836',7,750.01,1),(120,3,'S602RA1',13,433.95,1),(120,4,'4065174',13,18.13,1),(120,5,'9437G1X',6,732.18,1),(120,6,'2359986',2,74.48,1),(121,1,'S602VG6',2,1881.26,1),(121,2,'1411134',13,56.75,1),(121,3,'558L510',2,831.21,1),(121,4,'8654P49',1,171.54,1),(121,5,'4064078',1,169.04,1),(121,6,'242G457',1,147.69,1),(121,7,'S602VG6',2,1881.26,1),(121,8,'5844105',2,76.41,1),(121,9,'404R440',9,1400.26,1),(121,10,'Z660122',7,289.99,1),(121,11,'886H119',9,28.63,1),(121,12,'242L743',2,111.57,1),(121,13,'077WN45',2,509.99,1),(121,14,'8654H62',12,591.11,1),(121,15,'S602PX5',12,453.63,1),(121,16,'4065298',3,91.81,1),(121,17,'4065263',15,158.53,1),(121,18,'404T635',1,932.51,1),(122,1,'8652V77',10,152.47,0),(122,2,'8654E80',10,366.04,0),(122,3,'4065115',10,531.07,0),(123,1,'07714M0',3,146.62,4),(123,2,'4065174',15,18.13,4),(123,3,'B99J501',1,1775.57,4),(123,4,'4065204',1,280.21,4),(123,5,'1411058',2,190.99,4),(123,6,'943766W',2,409.95,4),(123,7,'B99K004',1,85.21,4),(123,8,'6181517',1,1604.94,4),(123,9,'943766W',1,409.95,4),(123,10,'8654H62',9,591.11,4),(123,11,'404U040',2,704.49,4),(123,12,'404S891',7,1446.43,4),(123,13,'B99H834',12,517.57,4),(123,14,'242L763',5,54.87,4),(123,15,'B99K043',12,523.25,4),(123,16,'Z660118',3,483.38,4),(123,17,'235E509',1,62.51,4),(123,18,'4065240',6,264.37,4),(123,19,'8653E96',3,139.85,4),(124,1,'8653T54',4,403.79,1),(124,2,'9437G1S',13,573.27,1),(124,3,'8654H63',1,413.42,1),(124,4,'W890504',2,893.75,1),(124,5,'8653D08',7,174.54,1),(124,6,'S602VG6',1,1881.26,1),(124,7,'B99J501',1,1775.57,1),(124,8,'8653S15',11,444.52,1),(124,9,'07735Y4',3,500.50,1),(124,10,'S602PP2',1,436.85,1),(124,11,'6181740',5,932.72,1),(124,12,'0713242',3,300.50,1),(124,13,'1410769',13,55.66,1),(124,14,'8654E99',9,403.79,1),(124,15,'0713242',1,300.50,1),(124,16,'404S893',1,976.95,1),(124,17,'S602PQ4',12,533.77,1),(124,18,'8652V94',5,138.80,1),(124,19,'242G454',2,114.85,1),(124,20,'Z660122',8,289.99,1),(125,1,'W890503',2,669.70,1),(125,2,'B940692',9,15.55,1),(125,3,'Z660117',3,1343.35,1),(125,4,'404S109',11,711.67,1),(125,5,'8653D08',2,174.54,1),(125,6,'1410769',2,55.66,1),(125,7,'S602VG6',2,1881.26,1),(125,8,'6181740',4,932.72,1),(125,9,'404S890',7,528.41,1),(125,10,'242L743',2,111.57,1),(125,11,'8654C22',3,413.42,1),(125,12,'235E509',1,62.51,1),(125,13,'9437G2D',14,793.30,1),(125,14,'558L508',2,458.36,1),(125,15,'1410767',9,53.47,1),(126,1,'2704148',1,368.14,2),(126,2,'1411058',11,190.99,2),(126,3,'B99K004',1,85.21,2),(126,4,'235E509',1,62.51,2),(126,5,'404T668',2,504.50,2),(126,6,'2704727',1,1522.68,2),(126,7,'8653T45',11,586.38,2),(126,8,'8654H63',1,413.42,2),(126,9,'9436E6N',8,1084.77,2),(126,10,'558L097',2,1189.45,2),(126,11,'8654E79',8,572.16,2),(126,12,'Z660122',8,289.99,2),(127,1,'8653E96',2,139.85,1),(127,2,'404R442',1,971.63,1),(127,3,'4065240',3,264.37,1),(127,4,'B99J150',8,436.82,1),(127,5,'886H120',1,28.63,1),(127,6,'9437G4D',2,1128.69,1),(127,7,'404S905',1,991.46,1),(127,8,'2359986',2,74.48,1),(127,9,'B940692',1,15.55,1),(127,10,'9436SGF',2,829.98,1),(127,11,'B99K043',1,523.25,1),(127,12,'Z660118',3,483.38,1),(127,13,'94389AF',2,455.08,1),(127,14,'W890505',2,1163.20,1),(127,15,'S602RA1',9,433.95,1),(128,1,'235B624',2,161.66,3),(128,2,'9437G2F',4,854.42,3),(128,3,'404S893',14,976.95,3),(128,4,'Z660117',3,1343.35,3),(128,5,'242L763',15,54.87,3),(128,6,'404T668',1,504.50,3),(128,7,'886K037',1,1067.30,3),(128,8,'0713249',2,558.50,3),(129,1,'404S903',10,971.63,0),(129,2,'404U040',4,704.49,0),(129,3,'9436E6N',15,1084.77,0),(129,4,'886H121',8,28.63,0),(129,5,'W890506',2,1606.03,0),(129,6,'8653D08',4,174.54,0),(129,7,'B940695',6,14.74,0),(129,8,'W890505',1,1163.20,0),(129,9,'0772VS2',1,263.54,0),(129,10,'8654J46',8,126.45,0),(129,11,'1411058',12,190.99,0),(129,12,'1410768',11,53.47,0),(129,13,'404S891',11,1446.43,0),(129,14,'242L762',13,59.70,0),(129,15,'404S891',6,1446.43,0),(129,16,'2704488',1,3171.93,0),(129,17,'077PC04',6,246.24,0),(130,1,'242E446',2,69.64,4),(130,2,'94389AF',1,455.08,4),(130,3,'Z660117',3,1343.35,4),(131,1,'S602PQ0',7,955.60,2),(131,2,'8653L70',6,403.79,2),(131,3,'W890505',2,1163.20,2),(131,4,'B99K233',4,31.88,2),(131,5,'943766W',15,409.95,2),(131,6,'9437G4D',2,1128.69,2),(131,7,'W890502',1,497.29,2),(132,1,'6181508',1,1357.03,1),(132,2,'Z660129',2,4395.37,1),(132,3,'235E510',1,62.51,1),(132,4,'9437G2D',1,793.30,1),(132,5,'1410767',8,53.47,1),(132,6,'B99J150',4,436.82,1),(132,7,'0713249',1,558.50,1),(132,8,'S602PQ0',5,955.60,1),(132,9,'4065174',9,18.13,1),(132,10,'558L097',7,1189.45,1),(132,11,'8654E82',9,508.19,1),(132,12,'404S524',4,971.63,1),(132,13,'S602HV8',2,779.54,1),(132,14,'B99K004',1,85.21,1),(132,15,'943766X',5,491.14,1),(132,16,'242L764',1,54.87,1),(132,17,'4065316',2,234.96,1),(133,1,'8654E84',5,484.50,2),(133,2,'8654E81',15,420.54,2),(133,3,'404S524',4,971.63,2),(133,4,'4065263',13,158.53,2),(133,5,'8654H62',13,591.11,2),(133,6,'W890505',2,1163.20,2),(133,7,'S602HV3',4,644.20,2),(133,8,'B940695',3,14.74,2),(133,9,'R340871',1,185.51,2),(133,10,'0713242',2,300.50,2),(133,11,'479V375',4,1057.38,2),(133,12,'8654F40',4,676.63,2),(133,13,'404S523',3,971.63,2),(133,14,'S602HV8',11,779.54,2),(133,15,'S602NE6',4,386.82,2),(133,16,'8654P49',1,171.54,2),(134,1,'1411127',9,76.39,4),(134,2,'94331QK',1,54.33,4),(134,3,'6181677',3,231.87,4),(134,4,'8654E81',15,420.54,4),(134,5,'2359986',1,74.48,4),(134,6,'S602PP2',1,436.85,4),(134,7,'W890506',3,1606.03,4),(134,8,'9436E6N',15,1084.77,4),(134,9,'S602FN8',2,656.18,4),(134,10,'0713263',2,2190.73,4),(134,11,'8654E80',4,366.04,4),(134,12,'5844105',2,76.41,4),(134,13,'6181517',1,1604.94,4),(134,14,'B99J501',1,1775.57,4),(134,15,'4065316',5,234.96,4),(134,16,'8653T45',2,586.38,4),(134,17,'235B624',3,161.66,4),(134,18,'077WN45',7,509.99,4),(134,19,'0772VS2',1,263.54,4),(135,1,'404S109',3,711.67,2),(135,2,'886K037',1,1067.30,2),(135,3,'S602VG6',2,1881.26,2),(136,1,'8653S16',8,494.02,4),(136,2,'886J712',1,913.15,4),(136,3,'8654E78',5,626.65,4),(136,4,'W890503',1,669.70,4),(136,5,'07714M0',2,146.62,4),(136,6,'8654H62',14,591.11,4),(136,7,'558L510',7,831.21,4),(136,8,'242G454',1,114.85,4),(136,9,'8652V94',6,138.80,4),(136,10,'1410769',9,55.66,4),(136,11,'9437G2D',6,793.30,4),(136,12,'9437G2B',3,732.18,4),(136,13,'S602LB1',2,563.01,4),(136,14,'1411058',11,190.99,4),(136,15,'242G454',9,114.85,4),(136,16,'1411134',5,56.75,4),(136,17,'404U264',2,954.56,4),(136,18,'9437G1S',9,573.27,4),(136,19,'8653X54',2,180.86,4),(136,20,'2704123',9,477.31,4),(137,1,'B940644',12,27.38,0),(137,2,'2752959',1,610.15,0),(137,3,'1411158',3,103.09,0),(137,4,'4065240',14,264.37,0),(137,5,'1411158',4,103.09,0),(137,6,'S602LB1',3,563.01,0),(137,7,'2704342',1,1737.37,0),(137,8,'242L763',2,54.87,0),(137,9,'8654E81',6,420.54,0),(137,10,'9436E6P',7,991.60,0),(137,11,'07735Y4',2,500.50,0),(137,12,'8654E83',1,591.11,0),(137,13,'S602PQ5',1,641.61,0),(137,14,'B940695',8,14.74,0),(137,15,'Z660131',2,461.82,0),(137,16,'2704342',2,1737.37,0),(137,17,'B940693',9,24.47,0),(137,18,'558L508',8,458.36,0),(137,19,'886H120',2,28.63,0),(138,1,'Z660117',2,1343.35,4),(138,2,'077MR98',1,111.80,4),(138,3,'8654E79',14,572.16,4),(138,4,'9436E6P',13,991.60,4),(138,5,'8654E81',10,420.54,4),(138,6,'B99K233',3,31.88,4),(138,7,'B940644',13,27.38,4),(138,8,'6181508',1,1357.03,4),(139,1,'W890506',1,1606.03,1),(139,2,'6181508',1,1357.03,1),(139,3,'9437G2D',7,793.30,1),(139,4,'4065298',15,91.81,1),(139,5,'1410767',9,53.47,1),(139,6,'8652V77',7,152.47,1),(139,7,'S602MP2',12,506.46,1),(139,8,'2752959',5,610.15,1),(139,9,'9436E6N',15,1084.77,1),(139,10,'S602LB1',3,563.01,1),(139,11,'S602HV8',13,779.54,1),(139,12,'0713245',2,576.50,1),(139,13,'2752951',1,176.87,1),(139,14,'9437G4D',2,1128.69,1),(139,15,'B99H834',13,517.57,1),(139,16,'S602VG6',1,1881.26,1),(139,17,'404S891',12,1446.43,1),(139,18,'235B624',2,161.66,1),(139,19,'W890503',1,669.70,1),(140,1,'6181508',1,1357.03,1),(140,2,'S602PQ0',11,955.60,1),(140,3,'1410767',1,53.47,1),(141,1,'886J712',1,913.15,2),(141,2,'404S524',2,971.63,2),(141,3,'8654E82',14,508.19,2),(141,4,'242C283',1,82.30,2),(141,5,'404U264',11,954.56,2),(141,6,'4065260',11,158.38,2),(141,7,'8653E96',2,139.85,2),(141,8,'404N216',1,71.23,2),(141,9,'2359982',1,213.00,2),(141,10,'8654E84',5,484.50,2),(141,11,'6181740',5,932.72,2),(141,12,'9437G4D',2,1128.69,2),(141,13,'2359986',1,74.48,2),(141,14,'8654F40',10,676.63,2),(141,15,'2704488',4,3171.93,2),(142,1,'1411127',3,76.39,1),(142,2,'1410767',6,53.47,1),(142,3,'8654P49',1,171.54,1),(142,4,'Z660118',3,483.38,1),(142,5,'9436E6N',12,1084.77,1),(142,6,'8654C19',12,420.54,1),(142,7,'8654C18',3,403.79,1),(143,1,'8654E84',5,484.50,3),(143,2,'B99K233',3,31.88,3),(143,3,'235E509',1,62.51,3),(143,4,'B99J501',1,1775.57,3),(143,5,'W890502',1,497.29,3),(143,6,'Z660117',3,1343.35,3),(143,7,'6181740',2,932.72,3),(143,8,'235E509',1,62.51,3),(143,9,'886J093',6,553.58,3),(143,10,'B99J150',11,436.82,3),(143,11,'077MR98',1,111.80,3),(143,12,'2704727',2,1522.68,3),(144,1,'404T668',2,504.50,0),(144,2,'W890503',2,669.70,0),(144,3,'242G454',9,114.85,0),(144,4,'S602VG6',1,1881.26,0),(145,1,'077MS34',3,246.24,3),(145,2,'8654E85',1,591.11,3),(145,3,'2359982',1,213.00,3),(145,4,'404S523',2,971.63,3),(146,1,'242L764',2,54.87,1),(146,2,'Z660117',4,1343.35,1),(146,3,'1411127',4,76.39,1),(146,4,'8653L70',8,403.79,1),(146,5,'B940644',14,27.38,1),(146,6,'558L509',11,644.35,1),(146,7,'235B624',1,161.66,1),(146,8,'8654C19',9,420.54,1),(146,9,'404T635',1,932.51,1),(146,10,'558L097',8,1189.45,1),(146,11,'235E508',1,61.88,1),(146,12,'1411058',11,190.99,1),(146,13,'W890502',1,497.29,1),(146,14,'404U040',5,704.49,1),(146,15,'Z660131',6,461.82,1),(146,16,'2704148',2,368.14,1),(146,17,'Z660122',4,289.99,1),(146,18,'077WN45',5,509.99,1),(146,19,'886J096',8,1007.33,1),(147,1,'235E510',1,62.51,2),(147,2,'4065316',1,234.96,2),(148,1,'6181517',2,1604.94,0),(148,2,'8654E82',8,508.19,0),(148,3,'8654E79',9,572.16,0),(148,4,'R340871',1,185.51,0),(148,5,'8654C18',11,403.79,0),(148,6,'404R442',1,971.63,0),(148,7,'4065115',7,531.07,0),(148,8,'4065174',12,18.13,0),(149,1,'242L764',3,54.87,2),(149,2,'Z660131',6,461.82,2),(149,3,'4065174',2,18.13,2),(150,1,'404U040',10,704.49,2),(150,2,'6181740',3,932.72,2),(150,3,'S602MP2',2,506.46,2),(150,4,'404T635',1,932.51,2),(150,5,'9437G2D',15,793.30,2),(150,6,'1411131',1,103.67,2),(150,7,'235E508',1,61.88,2),(150,8,'886H120',4,28.63,2),(150,9,'077MR98',1,111.80,2),(150,10,'9437G4D',1,1128.69,2);
/*!40000 ALTER TABLE `detalle_vendas` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `empregados`
--

DROP TABLE IF EXISTS `empregados`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `empregados` (
  `emp_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `emp_dni` char(9) DEFAULT NULL,
  `emp_apelidos` varchar(100) NOT NULL DEFAULT '',
  `emp_nome` varchar(50) DEFAULT NULL,
  `emp_enderezo` varchar(100) DEFAULT NULL,
  `emp_cp` char(5) DEFAULT NULL COMMENT 'código postal do empregado',
  `emp_poboacion` varchar(60) DEFAULT NULL,
  `emp_pais` smallint(5) unsigned DEFAULT NULL,
  `emp_alta` date DEFAULT NULL COMMENT 'data na que se deu de alta o empregado',
  PRIMARY KEY (`emp_id`),
  KEY `emp_apelidos_nome` (`emp_apelidos`,`emp_nome`),
  KEY `emp_pais` (`emp_pais`),
  CONSTRAINT `fk_empregados_paises` FOREIGN KEY (`emp_pais`) REFERENCES `paises` (`pai_id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `empregados`
--

LOCK TABLES `empregados` WRITE;
/*!40000 ALTER TABLE `empregados` DISABLE KEYS */;
INSERT INTO `empregados` VALUES (1,'12054601W','Múgica Troncoso','Amadora','ESTACION,Paseo, 89 - 3º','28931','Móstoles',73,'2013-06-10'),(2,'28461893Z','Besteiro Fernández','Mª Carmen','ZORITA DE LA FRONTERA, 182 - 5º A','37408','Salamanca',73,'2013-06-07'),(3,'11660571P','Álvarez García','Gimena','FLORIDA,Plaza, 44 - 3º C','37003','Salamanca',73,'2013-05-26'),(4,'27188517X','López Penelas','Benito','MILLAN ASTRAY, 183 - 7º D','24009','León',73,'2013-05-24'),(5,'13631021W','Hernández Herraz','Julio','SANTISIMA FAZ,Plaza, 113 - 4º C','03002','Alacant/Alicante',73,'2013-06-15'),(6,'29531457D','Arbeloa Fernández','Angeles','PARADA (VILAMARIN), 191 - 4º D','32101','Ourense',73,'2013-06-04'),(7,'10005786G','De Vega Troncoso','Adrián','IGLESIA, A (COUZADOIRO), 73 - 1º','15339','Coruña',73,'2013-06-14'),(8,'22308653X','Cupeiro Bermejo','Amador','JOYANA, 178 - 5º B','33411','Asturias',73,'2013-06-10'),(9,'19715780L','Mazaira Mayo','Vanesa','LARRINOA, 141 - 3º','01138','Álava',73,'2013-06-06'),(10,'23623684Q','Besteiro Villar','Rosa','JAZMIN, 164 - bajo','11204','Algeciras',73,'2013-06-15'),(11,'15913699E','Barreiro Illán','Saturno','SANT MIQUEL, 26 - entresuelo','08303','Mataró',73,'2013-06-18'),(12,'18787792N','Zarauz Roibás','María Teresa','DECANO MANUEL PELIBLANC, 131 - 8º D','29004','Málaga',73,'2013-05-26'),(13,'25881099G','Villar López','Carmen','PEDREGAL (ARMENTON), 81 - ático C','15144','Coruña',73,'2013-05-30'),(14,'20072799D','Varela Rivera','María Teresa','CONDOR, 10 - 1º C','47012','Valladolid',73,'2013-06-03'),(15,'11120383K','Gómez Mazaira','Eduardo','VILLACHICA, 4 - 8º D','01409','Álava',73,'2013-06-07'),(16,'11206847M','Menéndez Maltrana','Teresa','BISBE PONT I GOL,Plaza, 149 - 1º','12003','Castelló de la Plana/Castellón de la Plana',73,'2013-05-21'),(17,'12164266A','Hernández Álvarez','Gimena','ENTREPUENTES, 116 - ático B','39809','Cantabria',73,'2013-05-30'),(18,'27702978F','Cortés Roibás','Honorio','FERREIRUA, 51 - 6º','27335','Lugo',73,'2013-06-05'),(19,'18355868M','Núñez Álvarez','Fátima','LLANECES (EL SIERO), 147 - 5º A','33189','Asturias',73,'2013-05-31'),(20,'18193498S','Varela Manzano','Jose Antonio','FONT DE COLL, DE LA, 97 - 1º A','08023','Barcelona',73,'2013-06-17'),(21,'23981154C','Fraga Zarauz','Asunción','MERCADAL, ES, 39 - 6º','07740','Illes Balears',73,'2013-05-22'),(22,'26364651G','Louro Otero','Brian','CALVO SOTELO, 195 - 7º C','03003','Alacant/Alicante',73,'2013-06-14'),(23,'20645210L','Suárez Leire','Dositea','VILLACONEJOS, 168 - 3º','28805','Alcalá de Henares',73,'2013-06-06'),(24,'33411157T','Rivera Varela','Martín','CARREIRAS (LOBEIRA), 132 - 3º','32897','Ourense',73,'2013-06-17'),(25,'30626725V','Varela Curtier','Felisa','SAN SALVADOR, 21 - 6º B','11403','Jerez de la Frontera',73,'2013-06-15'),(26,'29696646N','Bouza Martín','Pedro','LOMA DE MARIA ANGELA, 72 - 4º','23478','Jaén',73,'2013-06-18'),(27,'21905382K','Vilela Barcia','Enrique','PASQUIN, 95 - 4º B','33697','Asturias',73,'2013-06-03'),(28,'32556131E','De Vega Guntín','Aurora','PANAMA, 67 - 2º C','35010','Palmas de Gran Canaria,Las',73,'2013-05-26'),(29,'32282447S','Benitez Rodríguez','Angel Luis','CUESTA, 153 - 6º B','07010','Palma de Mallorca',73,'2013-05-22'),(30,'10635811J','Mazaira Vilela','Felix','JOSE MARIA MORENO GALVAN, 44 - 1º D','41018','Sevilla',73,'2013-06-05'),(31,'18626597R','Leire Roibás','Benito','BAIX, DE,Plaza, 164 - 2º B','03202','Elx/Elche',73,'2013-06-06'),(32,'22615375G','Benitez Díaz','Aurora','SEBASTIAN DE BELALCAZAR, 84 - 6º','41092','Sevilla',73,'2013-05-27'),(33,'23000301W','Suárez Rivera','Felisa','VALDELOSA, 43 - 1º D','37799','Salamanca',73,'2013-06-08'),(34,'33630200Z','Guerra Barreira','Marcos','CAN MASSA, 126 - 3º D','17007','Girona',73,'2013-06-13'),(35,'26250214S','Herraz Janeiro','Juan','NUESTRA SEÑORA DAS HERMIDAS, 63 - 3º A','32005','Ourense',73,'2013-05-21'),(36,'33717628L','Sánchez Illán','Saturno','NUESTRO PADRE JESUS DE LA SAGRADA CENA,Plaza, 120 - 8º C','11403','Jerez de la Frontera',73,'2013-06-02'),(37,'30716221C','Fraga Touriño','Asunción','DOBLAS,Plaza, 50 - 2º C','14001','Córdoba',73,'2013-06-06'),(38,'20368417P','Varela Sánchez','Julio','TOSSAL GROSS, 165 - 6º D','03700','Alicante',73,'2013-06-01'),(39,'29278198A','Romero Gutierrez','Martín','EDUARDO ALVAREZ, 39 - 7º C','29003','Málaga',73,'2013-06-09'),(40,'33254981V','Álvarez Otero','Francisco Javier','MIQUEL BLEACH, 136 - 4º','08014','Barcelona',73,'2013-06-12'),(41,'19053679L','Tellado López','Francisco Javier','BRONZE, 174 - 1º','08038','Barcelona',73,'2013-06-11'),(42,'33105536A','Herraz García','Marcos','ALONDRA, LA, 151 - 6º C','11205','Algeciras',73,'2013-06-09'),(43,'26118555P','Dieguez Penelas','Antonio','VILLAINCLAN, 19 - bajo','33793','Asturias',73,'2013-06-01'),(44,'20302731X','Fernández Cachafeiro','Teresa','VALCUEVA, LA, 161 - 7º C','24839','León',73,'2013-05-30'),(45,'24670400W','Fernández Cortés','María Mercedes','SANTA BARBARA DE CASA, 112 - 1º','21570','Huelva',73,'2013-05-27'),(46,'15576410M','Besteiro Fernández','Miguel Angel','FRESNEDO (ALFOZ DE LLOREDO), 133 - ático D','39539','Cantabria',73,'2013-06-02'),(47,'18396928X','Barreiro Núñez','Sara','PARMENIDES,Avenida, 166 - 7º','29010','Málaga',73,'2013-06-16'),(48,'13524876W','Roibás Varela','Lucas','EULOGIO SERDAN, 95 - 8º D','01012','Vitoria-Gasteiz',73,'2013-05-22'),(49,'11206513Q','Guerra Louro','Carlos','CHOUSA,Camino, 88 - 1º D','15405','Ferrol',73,'2013-06-15'),(50,'16986447G','Santoro López','Benito','JONQUERES,Passatge, 17 - 4º C','08208','Sabadell',73,'2013-06-12');
/*!40000 ALTER TABLE `empregados` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `facturas`
--

DROP TABLE IF EXISTS `facturas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `facturas` (
  `fac_numero` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `fac_mes` tinyint(4) NOT NULL COMMENT 'mes ao que corresponden as ventas facturadas',
  `fac_ano` smallint(6) NOT NULL COMMENT 'ano ao que corresponden as ventas facturadas',
  `fac_data` date NOT NULL COMMENT 'data de emisión da factura',
  `fac_clt_cif` char(9) COLLATE latin1_spanish_ci DEFAULT NULL COMMENT 'cif do cliente',
  `fac_clt_apelidos` varchar(100) COLLATE latin1_spanish_ci NOT NULL COMMENT 'apelidos do cliente',
  `fac_clt_nome` varchar(50) COLLATE latin1_spanish_ci DEFAULT NULL COMMENT 'nome do cliente',
  `fac_clt_enderezo` varchar(100) COLLATE latin1_spanish_ci DEFAULT NULL,
  `fac_clt_cp` char(5) COLLATE latin1_spanish_ci DEFAULT NULL,
  `fac_clt_poboacion` varchar(60) COLLATE latin1_spanish_ci DEFAULT NULL,
  `fac_clt_pais` smallint(5) unsigned DEFAULT NULL,
  `fac_importe` decimal(12,2) NOT NULL COMMENT 'importe total da factura',
  PRIMARY KEY (`fac_numero`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `facturas`
--

LOCK TABLES `facturas` WRITE;
/*!40000 ALTER TABLE `facturas` DISABLE KEYS */;
/*!40000 ALTER TABLE `facturas` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hdetalle_vendas`
--

DROP TABLE IF EXISTS `hdetalle_vendas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hdetalle_vendas` (
  `hdet_venda` int(10) unsigned NOT NULL,
  `hdet_numero` tinyint(3) unsigned NOT NULL,
  `hdet_artigo` char(8) NOT NULL,
  `hdet_cantidade` smallint(5) unsigned DEFAULT NULL,
  `hdet_importe` decimal(10,2) DEFAULT NULL
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hdetalle_vendas`
--

LOCK TABLES `hdetalle_vendas` WRITE;
/*!40000 ALTER TABLE `hdetalle_vendas` DISABLE KEYS */;
/*!40000 ALTER TABLE `hdetalle_vendas` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `hvendas`
--

DROP TABLE IF EXISTS `hvendas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `hvendas` (
  `hven_id` int(10) unsigned NOT NULL,
  `hven_tenda` tinyint(3) unsigned NOT NULL,
  `hven_empregado` smallint(5) unsigned NOT NULL,
  `hven_cliente` smallint(5) unsigned NOT NULL,
  `hven_data` date NOT NULL
) ENGINE=ARCHIVE DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `hvendas`
--

LOCK TABLES `hvendas` WRITE;
/*!40000 ALTER TABLE `hvendas` DISABLE KEYS */;
/*!40000 ALTER TABLE `hvendas` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `paises`
--

DROP TABLE IF EXISTS `paises`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `paises` (
  `pai_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `pai_isonum` smallint(6) DEFAULT NULL,
  `pai_iso2` char(2) COLLATE latin1_spanish_ci DEFAULT NULL,
  `pai_iso3` char(3) COLLATE latin1_spanish_ci DEFAULT NULL,
  `pai_nome` varchar(80) COLLATE latin1_spanish_ci DEFAULT NULL,
  PRIMARY KEY (`pai_id`)
) ENGINE=InnoDB AUTO_INCREMENT=243 DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `paises`
--

LOCK TABLES `paises` WRITE;
/*!40000 ALTER TABLE `paises` DISABLE KEYS */;
INSERT INTO `paises` VALUES (1,4,'AF','AFG','Afganistán'),(2,248,'AX','ALA','Islas Gland'),(3,8,'AL','ALB','Albania'),(4,276,'DE','DEU','Alemania'),(5,20,'AD','AND','Andorra'),(6,24,'AO','AGO','Angola'),(7,660,'AI','AIA','Anguilla'),(8,10,'AQ','ATA','Antártida'),(9,28,'AG','ATG','Antigua y Barbuda'),(10,530,'AN','ANT','Antillas Holandesas'),(11,682,'SA','SAU','Arabia Saudí'),(12,12,'DZ','DZA','Argelia'),(13,32,'AR','ARG','Argentina'),(14,51,'AM','ARM','Armenia'),(15,533,'AW','ABW','Aruba'),(16,36,'AU','AUS','Australia'),(17,40,'AT','AUT','Austria'),(18,31,'AZ','AZE','Azerbaiyán'),(19,44,'BS','BHS','Bahamas'),(20,48,'BH','BHR','Bahréin'),(21,50,'BD','BGD','Bangladesh'),(22,52,'BB','BRB','Barbados'),(23,112,'BY','BLR','Bielorrusia'),(24,56,'BE','BEL','Bélgica'),(25,84,'BZ','BLZ','Belice'),(26,204,'BJ','BEN','Benin'),(27,60,'BM','BMU','Bermudas'),(28,64,'BT','BTN','Bhután'),(29,68,'BO','BOL','Bolivia'),(30,70,'BA','BIH','Bosnia y Herzegovina'),(31,72,'BW','BWA','Botsuana'),(32,74,'BV','BVT','Isla Bouvet'),(33,76,'BR','BRA','Brasil'),(34,96,'BN','BRN','Brunéi'),(35,100,'BG','BGR','Bulgaria'),(36,854,'BF','BFA','Burkina Faso'),(37,108,'BI','BDI','Burundi'),(38,132,'CV','CPV','Cabo Verde'),(39,136,'KY','CYM','Islas Caimán'),(40,116,'KH','KHM','Camboya'),(41,120,'CM','CMR','Camerún'),(42,124,'CA','CAN','Canadá'),(43,140,'CF','CAF','República Centroafricana'),(44,148,'TD','TCD','Chad'),(45,203,'CZ','CZE','República Checa'),(46,152,'CL','CHL','Chile'),(47,156,'CN','CHN','China'),(48,196,'CY','CYP','Chipre'),(49,162,'CX','CXR','Isla de Navidad'),(50,336,'VA','VAT','Ciudad del Vaticano'),(51,166,'CC','CCK','Islas Cocos'),(52,170,'CO','COL','Colombia'),(53,174,'KM','COM','Comoras'),(54,180,'CD','COD','República Democrática del Congo'),(55,178,'CG','COG','Congo'),(56,184,'CK','COK','Islas Cook'),(57,408,'KP','PRK','Corea del Norte'),(58,410,'KR','KOR','Corea del Sur'),(59,384,'CI','CIV','Costa de Marfil'),(60,188,'CR','CRI','Costa Rica'),(61,191,'HR','HRV','Croacia'),(62,192,'CU','CUB','Cuba'),(63,208,'DK','DNK','Dinamarca'),(64,212,'DM','DMA','Dominica'),(65,214,'DO','DOM','República Dominicana'),(66,218,'EC','ECU','Ecuador'),(67,818,'EG','EGY','Egipto'),(68,222,'SV','SLV','El Salvador'),(69,784,'AE','ARE','Emiratos Árabes Unidos'),(70,232,'ER','ERI','Eritrea'),(71,703,'SK','SVK','Eslovaquia'),(72,705,'SI','SVN','Eslovenia'),(73,724,'ES','ESP','España'),(74,581,'UM','UMI','Islas ultramarinas de Estados Unidos'),(75,840,'US','USA','Estados Unidos'),(76,233,'EE','EST','Estonia'),(77,231,'ET','ETH','Etiopía'),(78,234,'FO','FRO','Islas Feroe'),(79,608,'PH','PHL','Filipinas'),(80,246,'FI','FIN','Finlandia'),(81,242,'FJ','FJI','Fiyi'),(82,250,'FR','FRA','Francia'),(83,266,'GA','GAB','Gabón'),(84,270,'GM','GMB','Gambia'),(85,268,'GE','GEO','Georgia'),(86,239,'GS','SGS','Islas Georgias del Sur y Sandwich del Sur'),(87,288,'GH','GHA','Ghana'),(88,292,'GI','GIB','Gibraltar'),(89,308,'GD','GRD','Granada'),(90,300,'GR','GRC','Grecia'),(91,304,'GL','GRL','Groenlandia'),(92,312,'GP','GLP','Guadalupe'),(93,316,'GU','GUM','Guam'),(94,320,'GT','GTM','Guatemala'),(95,254,'GF','GUF','Guayana Francesa'),(96,324,'GN','GIN','Guinea'),(97,226,'GQ','GNQ','Guinea Ecuatorial'),(98,624,'GW','GNB','Guinea-Bissau'),(99,328,'GY','GUY','Guyana'),(100,332,'HT','HTI','Haití'),(101,334,'HM','HMD','Islas Heard y McDonald'),(102,340,'HN','HND','Honduras'),(103,344,'HK','HKG','Hong Kong'),(104,348,'HU','HUN','Hungría'),(105,356,'IN','IND','India'),(106,360,'ID','IDN','Indonesia'),(107,364,'IR','IRN','Irán'),(108,368,'IQ','IRQ','Iraq'),(109,372,'IE','IRL','Irlanda'),(110,352,'IS','ISL','Islandia'),(111,376,'IL','ISR','Israel'),(112,380,'IT','ITA','Italia'),(113,388,'JM','JAM','Jamaica'),(114,392,'JP','JPN','Japón'),(115,400,'JO','JOR','Jordania'),(116,398,'KZ','KAZ','Kazajstán'),(117,404,'KE','KEN','Kenia'),(118,417,'KG','KGZ','Kirguistán'),(119,296,'KI','KIR','Kiribati'),(120,414,'KW','KWT','Kuwait'),(121,418,'LA','LAO','Laos'),(122,426,'LS','LSO','Lesotho'),(123,428,'LV','LVA','Letonia'),(124,422,'LB','LBN','Líbano'),(125,430,'LR','LBR','Liberia'),(126,434,'LY','LBY','Libia'),(127,438,'LI','LIE','Liechtenstein'),(128,440,'LT','LTU','Lituania'),(129,442,'LU','LUX','Luxemburgo'),(130,446,'MO','MAC','Macao'),(131,807,'MK','MKD','ARY Macedonia'),(132,450,'MG','MDG','Madagascar'),(133,458,'MY','MYS','Malasia'),(134,454,'MW','MWI','Malawi'),(135,462,'MV','MDV','Maldivas'),(136,466,'ML','MLI','Malí'),(137,470,'MT','MLT','Malta'),(138,238,'FK','FLK','Islas Malvinas'),(139,580,'MP','MNP','Islas Marianas del Norte'),(140,504,'MA','MAR','Marruecos'),(141,584,'MH','MHL','Islas Marshall'),(142,474,'MQ','MTQ','Martinica'),(143,480,'MU','MUS','Mauricio'),(144,478,'MR','MRT','Mauritania'),(145,175,'YT','MYT','Mayotte'),(146,484,'MX','MEX','México'),(147,583,'FM','FSM','Micronesia'),(148,498,'MD','MDA','Moldavia'),(149,492,'MC','MCO','Mónaco'),(150,496,'MN','MNG','Mongolia'),(151,500,'MS','MSR','Montserrat'),(152,508,'MZ','MOZ','Mozambique'),(153,104,'MM','MMR','Myanmar'),(154,516,'NA','NAM','Namibia'),(155,520,'NR','NRU','Nauru'),(156,524,'NP','NPL','Nepal'),(157,558,'NI','NIC','Nicaragua'),(158,562,'NE','NER','Níger'),(159,566,'NG','NGA','Nigeria'),(160,570,'NU','NIU','Niue'),(161,574,'NF','NFK','Isla Norfolk'),(162,578,'NO','NOR','Noruega'),(163,540,'NC','NCL','Nueva Caledonia'),(164,554,'NZ','NZL','Nueva Zelanda'),(165,512,'OM','OMN','Omán'),(166,528,'NL','NLD','Países Bajos'),(167,586,'PK','PAK','Pakistán'),(168,585,'PW','PLW','Palau'),(169,275,'PS','PSE','Palestina'),(170,591,'PA','PAN','Panamá'),(171,598,'PG','PNG','Papúa Nueva Guinea'),(172,600,'PY','PRY','Paraguay'),(173,604,'PE','PER','Perú'),(174,612,'PN','PCN','Islas Pitcairn'),(175,258,'PF','PYF','Polinesia Francesa'),(176,616,'PL','POL','Polonia'),(177,620,'PT','PRT','Portugal'),(178,630,'PR','PRI','Puerto Rico'),(179,634,'QA','QAT','Qatar'),(180,826,'GB','GBR','Reino Unido'),(181,638,'RE','REU','Reunión'),(182,646,'RW','RWA','Ruanda'),(183,642,'RO','ROU','Rumania'),(184,643,'RU','RUS','Rusia'),(185,732,'EH','ESH','Sahara Occidental'),(186,90,'SB','SLB','Islas Salomón'),(187,882,'WS','WSM','Samoa'),(188,16,'AS','ASM','Samoa Americana'),(189,659,'KN','KNA','San Cristóbal y Nevis'),(190,674,'SM','SMR','San Marino'),(191,666,'PM','SPM','San Pedro y Miquelón'),(192,670,'VC','VCT','San Vicente y las Granadinas'),(193,654,'SH','SHN','Santa Helena'),(194,662,'LC','LCA','Santa Lucía'),(195,678,'ST','STP','Santo Tomé y Príncipe'),(196,686,'SN','SEN','Senegal'),(197,891,'CS','SCG','Serbia y Montenegro'),(198,690,'SC','SYC','Seychelles'),(199,694,'SL','SLE','Sierra Leona'),(200,702,'SG','SGP','Singapur'),(201,760,'SY','SYR','Siria'),(202,706,'SO','SOM','Somalia'),(203,144,'LK','LKA','Sri Lanka'),(204,748,'SZ','SWZ','Suazilandia'),(205,710,'ZA','ZAF','Sudáfrica'),(206,736,'SD','SDN','Sudán'),(207,752,'SE','SWE','Suecia'),(208,756,'CH','CHE','Suiza'),(209,740,'SR','SUR','Surinam'),(210,744,'SJ','SJM','Svalbard y Jan Mayen'),(211,764,'TH','THA','Tailandia'),(212,158,'TW','TWN','Taiwán'),(213,834,'TZ','TZA','Tanzania'),(214,762,'TJ','TJK','Tayikistán'),(215,86,'IO','IOT','Territorio Británico del Océano Índico'),(216,260,'TF','ATF','Territorios Australes Franceses'),(217,626,'TL','TLS','Timor Oriental'),(218,768,'TG','TGO','Togo'),(219,772,'TK','TKL','Tokelau'),(220,776,'TO','TON','Tonga'),(221,780,'TT','TTO','Trinidad y Tobago'),(222,788,'TN','TUN','Túnez'),(223,796,'TC','TCA','Islas Turcas y Caicos'),(224,795,'TM','TKM','Turkmenistán'),(225,792,'TR','TUR','Turquía'),(226,798,'TV','TUV','Tuvalu'),(227,804,'UA','UKR','Ucrania'),(228,800,'UG','UGA','Uganda'),(229,858,'UY','URY','Uruguay'),(230,860,'UZ','UZB','Uzbekistán'),(231,548,'VU','VUT','Vanuatu'),(232,862,'VE','VEN','Venezuela'),(233,704,'VN','VNM','Vietnam'),(234,92,'VG','VGB','Islas Vírgenes Británicas'),(235,850,'VI','VIR','Islas Vírgenes de los Estados Unidos'),(236,876,'WF','WLF','Wallis y Futuna'),(237,887,'YE','YEM','Yemen'),(238,262,'DJ','DJI','Yibuti'),(239,894,'ZM','ZMB','Zambia'),(240,716,'ZW','ZWE','Zimbabue'),(241,688,'RS','SRB','Serbia'),(242,499,'ME','MNE','Montenegro');
/*!40000 ALTER TABLE `paises` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pedidos`
--

DROP TABLE IF EXISTS `pedidos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pedidos` (
  `ped_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ped_provedor` tinyint(3) unsigned NOT NULL COMMENT 'id do provedor ao que se lle fai o pedido',
  `ped_data` date NOT NULL COMMENT 'data na que se fai o pedido ao provedor',
  `ped_recepcion` date NOT NULL COMMENT 'data na que se recibe o pedido',
  PRIMARY KEY (`ped_id`),
  KEY `ped_provedor` (`ped_provedor`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pedidos`
--

LOCK TABLES `pedidos` WRITE;
/*!40000 ALTER TABLE `pedidos` DISABLE KEYS */;
/*!40000 ALTER TABLE `pedidos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `pesos`
--

DROP TABLE IF EXISTS `pesos`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `pesos` (
  `peso_nome` char(8) NOT NULL DEFAULT '' COMMENT 'nome que describe o tipo de peso: lixeiro, medio, pesado, ...',
  `peso_min` smallint(6) NOT NULL DEFAULT '0',
  `peso_max` smallint(6) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `pesos`
--

LOCK TABLES `pesos` WRITE;
/*!40000 ALTER TABLE `pesos` DISABLE KEYS */;
INSERT INTO `pesos` VALUES ('Leve',0,100),('Lixeiro',101,500),('Medio',501,2500),('Pesado',2501,9999);
/*!40000 ALTER TABLE `pesos` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `provedores`
--

DROP TABLE IF EXISTS `provedores`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `provedores` (
  `prv_id` smallint(6) NOT NULL DEFAULT '0',
  `prv_nome` varchar(60) NOT NULL DEFAULT '',
  PRIMARY KEY (`prv_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `provedores`
--

LOCK TABLES `provedores` WRITE;
/*!40000 ALTER TABLE `provedores` DISABLE KEYS */;
INSERT INTO `provedores` VALUES (1,'LG ELECTRONICS'),(2,'APPLE'),(3,'ACER'),(4,'APC - NETWORK'),(5,'EMERSON NETWORK POWER'),(6,'SYNOLOGY'),(7,'NETGEAR - NAS'),(8,'SEAGATE'),(9,'D-LINK'),(10,'IOMEGA'),(11,'BUFFALO TECHNOLOGY - NAS'),(12,'FTS - SERVER OPTIONS'),(13,'WD'),(14,'TOSHIBA'),(15,'SAMSUNG'),(16,'HP'),(17,'LITE-ON TECHNOLOGY'),(18,'ASUSTEK'),(19,'LENOVO'),(20,'TOSHIBA - SATELLITE'),(21,'SONY'),(22,'EPSON'),(23,'CANON');
/*!40000 ALTER TABLE `provedores` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `provincias`
--

DROP TABLE IF EXISTS `provincias`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `provincias` (
  `pro_id` smallint(6) DEFAULT NULL,
  `pro_nome` varchar(30) COLLATE latin1_spanish_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_spanish_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `provincias`
--

LOCK TABLES `provincias` WRITE;
/*!40000 ALTER TABLE `provincias` DISABLE KEYS */;
INSERT INTO `provincias` VALUES (2,'Albacete'),(3,'Alicante/Alacant'),(4,'Almería'),(1,'Araba/Álava'),(33,'Asturias'),(5,'Ávila'),(6,'Badajoz'),(7,'Balears, Illes'),(8,'Barcelona'),(48,'Bizkaia'),(9,'Burgos'),(10,'Cáceres'),(11,'Cádiz'),(39,'Cantabria'),(12,'Castellón/Castelló'),(51,'Ceuta'),(13,'Ciudad Real'),(14,'Córdoba'),(15,'Coruña, A'),(16,'Cuenca'),(20,'Gipuzkoa'),(17,'Girona'),(18,'Granada'),(19,'Guadalajara'),(21,'Huelva'),(22,'Huesca'),(23,'Jaén'),(24,'León'),(27,'Lugo'),(25,'Lleida'),(28,'Madrid'),(29,'Málaga'),(52,'Melilla'),(30,'Murcia'),(31,'Navarra'),(32,'Ourense'),(34,'Palencia'),(35,'Palmas, Las'),(36,'Pontevedra'),(26,'Rioja, La'),(37,'Salamanca'),(38,'Santa Cruz de Tenerife'),(40,'Segovia'),(41,'Sevilla'),(42,'Soria'),(43,'Tarragona'),(44,'Teruel'),(45,'Toledo'),(46,'Valencia/València'),(47,'Valladolid'),(49,'Zamora'),(50,'Zaragoza');
/*!40000 ALTER TABLE `provincias` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tendas`
--

DROP TABLE IF EXISTS `tendas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tendas` (
  `tda_id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
  `tda_poboacion` varchar(60) NOT NULL,
  `tda_xerente` smallint(5) unsigned DEFAULT NULL COMMENT 'id do empregado que é xerente da tenda',
  PRIMARY KEY (`tda_id`),
  KEY `fk_tendas_empregados` (`tda_xerente`),
  CONSTRAINT `fk_tendas_empregados` FOREIGN KEY (`tda_xerente`) REFERENCES `empregados` (`emp_id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tendas`
--

LOCK TABLES `tendas` WRITE;
/*!40000 ALTER TABLE `tendas` DISABLE KEYS */;
INSERT INTO `tendas` VALUES (1,'Madrid - 3',47),(2,'Almería - 2',1),(3,'Salamanca - Central',35),(4,'Barcelona - Central',48),(5,'Mataró - Central',23),(6,'Palmas de Gran Canaria,Las - Central',25),(7,'Alicante - Central',14),(8,'Alacant/Alicante - 3',33),(9,'Santa Cruz de Tenerife - 2',16),(10,'Coruña - 4',25),(11,'Coruña - 3',40),(12,'Almería - Central',41),(13,'Ávila - Central',11),(14,'Vigo - 2',4),(15,'Sevilla - Central',36),(16,'Cádiz - 2',30),(17,'Coruña - 2',42),(18,'Madrid - 2',2),(19,'Madrid - Central',20),(20,'Leganés - Central',18),(21,'Cádiz - Central',10),(22,'Guadalajara - Central',34),(23,'Terrassa - Central',15),(24,'Granada - Central',41),(25,'Alacant/Alicante - 2',41),(26,'Vigo - Central',3),(27,'Coruña - Central',18),(28,'Alacant/Alicante - Central',12),(29,'Córdoba - Central',33),(30,'Santa Cruz de Tenerife - Central',8);
/*!40000 ALTER TABLE `tendas` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vendas`
--

DROP TABLE IF EXISTS `vendas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vendas` (
  `ven_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ven_tenda` tinyint(3) unsigned NOT NULL COMMENT 'id da tenda na que se fixo a venda',
  `ven_empregado` smallint(5) unsigned NOT NULL COMMENT 'id do empregado que fixo a venda',
  `ven_cliente` smallint(5) unsigned NOT NULL COMMENT 'id do cliente que fixo a venda',
  `ven_data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'data na que se fixo a venda',
  `ven_factura` date DEFAULT NULL COMMENT 'factura na que se incluiu a venda. Se ten NULL é que aínda non se facturou',
  PRIMARY KEY (`ven_id`),
  KEY `ven_tenda` (`ven_tenda`),
  KEY `ven_empregado` (`ven_empregado`),
  KEY `ven_cliente` (`ven_cliente`),
  CONSTRAINT `fk_vendas_cliente` FOREIGN KEY (`ven_cliente`) REFERENCES `clientes` (`clt_id`) ON UPDATE CASCADE,
  CONSTRAINT `fk_vendas_empregados` FOREIGN KEY (`ven_empregado`) REFERENCES `empregados` (`emp_id`) ON UPDATE CASCADE,
  CONSTRAINT `fk_vendas_tendas` FOREIGN KEY (`ven_tenda`) REFERENCES `tendas` (`tda_id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=151 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vendas`
--

LOCK TABLES `vendas` WRITE;
/*!40000 ALTER TABLE `vendas` DISABLE KEYS */;
INSERT INTO `vendas` VALUES (1,5,49,95,'2015-05-24 06:25:45',NULL),(2,4,40,35,'2015-06-08 18:06:45',NULL),(3,3,44,94,'2015-05-26 12:35:45',NULL),(4,27,14,81,'2015-05-25 12:32:45',NULL),(5,3,16,49,'2015-05-27 08:21:45',NULL),(6,20,21,85,'2015-05-29 18:31:45',NULL),(7,14,1,27,'2015-06-15 23:39:45',NULL),(8,4,15,59,'2015-05-27 13:52:45',NULL),(9,11,25,38,'2015-05-21 17:28:45',NULL),(10,5,34,56,'2015-06-05 07:08:45',NULL),(11,17,17,70,'2015-05-26 05:41:45',NULL),(12,13,30,42,'2015-06-10 11:27:45',NULL),(13,16,42,52,'2015-06-08 01:05:45',NULL),(14,15,38,37,'2015-05-31 04:57:45',NULL),(15,2,2,22,'2015-06-09 19:51:45',NULL),(16,26,10,16,'2015-05-23 17:06:45',NULL),(17,15,39,37,'2015-05-28 01:53:45',NULL),(18,24,20,84,'2015-06-03 10:32:45',NULL),(19,7,27,99,'2015-05-25 11:02:45',NULL),(20,15,18,83,'2015-06-07 03:46:45',NULL),(21,15,40,49,'2015-05-29 16:18:45',NULL),(22,7,50,76,'2015-05-21 14:41:45',NULL),(23,16,23,28,'2015-06-13 12:29:45',NULL),(24,20,47,52,'2015-06-08 19:45:45',NULL),(25,27,19,11,'2015-06-01 11:22:45',NULL),(26,13,38,76,'2015-05-26 22:25:45',NULL),(27,23,23,78,'2015-06-18 22:25:45',NULL),(28,9,30,99,'2015-06-14 19:33:45',NULL),(29,11,5,87,'2015-06-18 13:43:45',NULL),(30,13,6,44,'2015-06-10 10:51:45',NULL),(31,7,34,34,'2015-05-21 13:35:45',NULL),(32,18,11,10,'2015-06-01 01:16:45',NULL),(33,15,32,1,'2015-06-10 14:43:45',NULL),(34,8,45,36,'2015-06-04 21:07:45',NULL),(35,24,42,3,'2015-05-23 12:30:45',NULL),(36,29,4,51,'2015-05-30 10:21:45',NULL),(37,27,19,41,'2015-06-12 22:16:45',NULL),(38,14,49,97,'2015-06-04 22:24:45',NULL),(39,27,30,23,'2015-06-04 00:11:45',NULL),(40,7,31,27,'2015-05-29 15:05:45',NULL),(41,9,11,6,'2015-06-06 23:15:45',NULL),(42,11,37,30,'2015-06-08 03:57:45',NULL),(43,19,2,18,'2015-05-28 03:26:45',NULL),(44,1,23,6,'2015-06-12 11:23:45',NULL),(45,26,45,77,'2015-06-14 14:40:45',NULL),(46,19,41,13,'2015-05-25 15:44:45',NULL),(47,5,37,83,'2015-06-17 08:34:45',NULL),(48,25,37,83,'2015-06-12 13:04:45',NULL),(49,28,23,46,'2015-05-24 07:46:45',NULL),(50,26,46,99,'2015-06-09 04:27:45',NULL),(51,15,12,72,'2015-05-21 17:16:45',NULL),(52,18,8,36,'2015-06-09 01:43:45',NULL),(53,15,47,84,'2015-05-29 00:56:45',NULL),(54,5,26,73,'2015-05-31 20:37:45',NULL),(55,12,5,61,'2015-06-04 06:37:45',NULL),(56,7,28,71,'2015-05-29 06:19:45',NULL),(57,7,17,73,'2015-05-31 14:23:45',NULL),(58,23,36,86,'2015-06-16 02:21:45',NULL),(59,29,44,3,'2015-06-17 06:49:45',NULL),(60,7,24,16,'2015-06-02 22:21:45',NULL),(61,10,47,31,'2015-06-08 11:30:45',NULL),(62,7,36,38,'2015-06-01 13:41:45',NULL),(63,29,41,100,'2015-06-13 13:35:45',NULL),(64,19,19,45,'2015-06-02 03:37:45',NULL),(65,5,37,96,'2015-06-09 20:48:45',NULL),(66,14,22,11,'2015-06-08 09:30:45',NULL),(67,8,29,56,'2015-05-23 07:05:45',NULL),(68,23,8,93,'2015-06-09 22:56:45',NULL),(69,28,45,21,'2015-06-18 19:47:45',NULL),(70,11,11,66,'2015-06-03 23:08:45',NULL),(71,24,40,63,'2015-06-05 00:23:45',NULL),(72,16,44,44,'2015-06-09 23:08:45',NULL),(73,14,25,56,'2015-06-06 02:46:45',NULL),(74,19,13,52,'2015-05-25 04:03:45',NULL),(75,26,9,1,'2015-05-22 03:14:45',NULL),(76,11,27,37,'2015-06-12 17:36:45',NULL),(77,26,36,26,'2015-06-11 00:11:45',NULL),(78,15,29,96,'2015-06-07 15:52:45',NULL),(79,23,16,36,'2015-06-06 01:12:45',NULL),(80,7,6,9,'2015-06-12 05:21:45',NULL),(81,13,10,28,'2015-06-05 03:36:45',NULL),(82,23,19,80,'2015-06-03 21:42:45',NULL),(83,8,25,77,'2015-05-29 07:06:45',NULL),(84,14,34,91,'2015-06-15 06:11:45',NULL),(85,16,40,41,'2015-06-03 23:57:45',NULL),(86,25,45,21,'2015-06-16 12:10:45',NULL),(87,2,21,98,'2015-05-21 19:03:45',NULL),(88,18,18,91,'2015-05-31 17:08:45',NULL),(89,7,47,76,'2015-06-07 19:00:45',NULL),(90,21,50,40,'2015-06-11 05:57:45',NULL),(91,5,42,59,'2015-06-14 22:12:45',NULL),(92,11,2,35,'2015-06-12 00:50:45',NULL),(93,21,25,88,'2015-06-17 22:16:45',NULL),(94,6,7,50,'2015-06-15 01:47:45',NULL),(95,5,49,30,'2015-06-04 04:57:45',NULL),(96,21,47,51,'2015-05-26 10:41:45',NULL),(97,6,23,80,'2015-06-01 13:39:45',NULL),(98,30,49,17,'2015-06-11 04:33:45',NULL),(99,6,47,41,'2015-05-27 14:00:45',NULL),(100,11,8,29,'2015-05-26 01:45:45',NULL),(101,2,38,12,'2015-06-02 03:42:45',NULL),(102,6,1,95,'2015-06-12 09:09:45',NULL),(103,6,31,44,'2015-06-16 12:54:45',NULL),(104,19,14,88,'2015-06-09 16:17:45',NULL),(105,10,20,49,'2015-06-04 20:17:45',NULL),(106,6,12,28,'2015-06-09 13:34:45',NULL),(107,5,18,60,'2015-05-25 13:40:45',NULL),(108,20,13,43,'2015-06-14 19:46:45',NULL),(109,1,42,87,'2015-05-27 06:01:45',NULL),(110,17,22,79,'2015-06-07 22:28:45',NULL),(111,27,13,12,'2015-05-31 13:43:45',NULL),(112,3,32,87,'2015-06-16 23:18:45',NULL),(113,12,26,60,'2015-05-24 19:48:45',NULL),(114,20,37,76,'2015-06-09 13:24:45',NULL),(115,3,5,72,'2015-06-08 08:46:45',NULL),(116,5,19,13,'2015-05-29 03:13:45',NULL),(117,7,2,90,'2015-06-18 07:43:45',NULL),(118,20,2,95,'2015-05-29 08:19:45',NULL),(119,3,29,57,'2015-06-07 02:12:45',NULL),(120,18,23,33,'2015-06-04 15:27:45',NULL),(121,4,20,23,'2015-05-21 23:50:45',NULL),(122,10,45,21,'2015-05-23 21:04:45',NULL),(123,13,15,47,'2015-06-10 17:20:45',NULL),(124,7,38,3,'2015-05-25 07:38:45',NULL),(125,1,48,30,'2015-06-10 03:02:45',NULL),(126,20,21,40,'2015-05-25 22:10:45',NULL),(127,7,49,10,'2015-06-03 03:05:45',NULL),(128,26,33,98,'2015-06-17 09:23:45',NULL),(129,30,25,74,'2015-05-31 15:47:45',NULL),(130,4,37,84,'2015-06-06 05:09:45',NULL),(131,13,36,40,'2015-06-14 10:43:45',NULL),(132,10,8,50,'2015-06-17 14:24:45',NULL),(133,25,25,32,'2015-06-10 02:30:45',NULL),(134,9,22,68,'2015-06-08 18:37:45',NULL),(135,15,5,20,'2015-06-08 04:25:45',NULL),(136,25,42,55,'2015-06-17 22:41:45',NULL),(137,6,13,97,'2015-05-28 22:44:45',NULL),(138,21,36,53,'2015-05-23 00:19:45',NULL),(139,23,24,28,'2015-05-27 21:38:45',NULL),(140,24,24,10,'2015-06-06 17:34:45',NULL),(141,29,34,19,'2015-05-31 15:05:45',NULL),(142,24,20,66,'2015-05-29 12:02:45',NULL),(143,15,38,86,'2015-06-19 10:31:45',NULL),(144,25,25,54,'2015-06-07 16:05:45',NULL),(145,1,25,2,'2015-05-27 18:17:45',NULL),(146,3,31,42,'2015-06-17 22:02:45',NULL),(147,22,32,49,'2015-05-24 08:06:45',NULL),(148,13,24,97,'2015-06-07 16:17:45',NULL),(149,24,38,88,'2015-06-16 09:57:45',NULL),(150,13,3,7,'2015-06-08 22:20:45',NULL);
/*!40000 ALTER TABLE `vendas` 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 2015-11-24 18:18:22

Para reflexionar

Revisa as sentenzas do script:

• comprendes o seu funcionamento? Podes indagar sobre aquelas que non comprendas
• pensa como pode ser o modelo E-R que esboza ese script

Podes consultar o diagrama E-R da base de datos tenda coa descripción das súas táboas. Corrobora que se asemella o que ti tiñas esbozado.

Para continuar

Podes facer as tarefas que se indican na seguinte unidade sobre esta base de datos