p2RWHxE7

1-- MySQL dump 10.13  Distrib 5.1.56, for Win32 (ia32)
2--
3-- Host: localhost    Database: 
4-- ------------------------------------------------------
5-- Server version	5.1.56-community-log
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Current Database: `ebanca`
20--
21
22CREATE DATABASE /*!32312 IF NOT EXISTS*/ `ebanca` /*!40100 DEFAULT CHARACTER SET latin1 */;
23
24USE `ebanca`;
25
26--
27-- Table structure for table `clientes`
28--
29
30DROP TABLE IF EXISTS `clientes`;
31/*!40101 SET @saved_cs_client     = @@character_set_client */;
32/*!40101 SET character_set_client = utf8 */;
33CREATE TABLE `clientes` (
34  `codigo_cliente` int(11) NOT NULL AUTO_INCREMENT,
35  `dni` int(7) NOT NULL,
36  `nombre` char(20) NOT NULL,
37  `apellido1` char(20) NOT NULL,
38  `apellido2` char(20) DEFAULT NULL,
39  `direccion` char(50) NOT NULL,
40  `region` varchar(45) DEFAULT NULL,
41  PRIMARY KEY (`codigo_cliente`),
42  UNIQUE KEY `idni` (`dni`)
43) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
44/*!40101 SET character_set_client = @saved_cs_client */;
45
46--
47-- Dumping data for table `clientes`
48--
49
50LOCK TABLES `clientes` WRITE;
51/*!40000 ALTER TABLE `clientes` DISABLE KEYS */;
52INSERT INTO `clientes` VALUES 
53(1,11111111,'jcarlos','baldo',NULL,'d1','aragon'),
54(2,22222222,'pilar','rodri',NULL,'d2','aragon'),
55(3,33333333,'pablo','babes',NULL,'d3','pais vasco'),
56(4,44444444,'javi','sonas',NULL,'d4','pais vasco'),
57(5,55555555,'angel','alva',NULL,'d5','pais vasco'),
58(6,66666666,'pilar','bueso','perez','d6','aragon'),
59(7,77777777,'alberto','perez','dominguez','d7','aragon'),
60(8,88888888,'antonio','martinez','barea','d8','extremadura'),
61(9,99999999,'maria jesus','longares','hernandez','d9','extremadura'),
62(10,10101010,'ana','guillen','lopera','d10','aragon'),
63(11,12121212,'fernando','montero','iglesias','d11','aragon'),
64(12,13131313,'silvia','lopez','escartin','d12','aragon'),
65(13,14141414,'raquel','beltran','acebes','d13','aragon'),
66(14,15151515,'mario','cabaña','encinas','d14','aragon'),
67(15,16161616,'manuel','falceto','carrera','d15','aragon'),
68(16,17171717,'jordi','eulalia','perales','d16','aragon'),
69(17,18181818,'marc','garriga','higuera','d17','aragon'),
70(18,19191919,'rafael','hueso','ibañez','d18','aragon'),
71(19,20202020,'fran','granada','mariategui','d19','aragon'),
72(20,21212121,'porfirio','gambo','perez','d20','aragon');
73/*!40000 ALTER TABLE `clientes` ENABLE KEYS */;
74UNLOCK TABLES;
75
76--
77-- Table structure for table `cuentas`
78--
79
80DROP TABLE IF EXISTS `cuentas`;
81/*!40101 SET @saved_cs_client     = @@character_set_client */;
82/*!40101 SET character_set_client = utf8 */;
83CREATE TABLE `cuentas` (
84  `fecha_creacion` date NOT NULL,
85  `saldo` int(11) NOT NULL DEFAULT '0',
86  `cod_cuenta` int(11) NOT NULL,
87  `cod_cliente` int(11) NOT NULL,
88  PRIMARY KEY (`cod_cuenta`),
89  KEY `ccl` (`cod_cliente`),
90  KEY `fc` (`fecha_creacion`,`cod_cliente`),
91  KEY `cfc` (`fecha_creacion`,`cod_cliente`)
92) ENGINE=InnoDB DEFAULT CHARSET=latin1;
93/*!40101 SET character_set_client = @saved_cs_client */;
94
95--
96-- Dumping data for table `cuentas`
97--
98
99LOCK TABLES `cuentas` WRITE;
100/*!40000 ALTER TABLE `cuentas` DISABLE KEYS */;
101INSERT INTO `cuentas` VALUES 
102('2012-01-01',30000,0,6),
103('2010-01-01',100,1,1),
104('2010-02-01',100,2,2),
105('2009-02-13',4400,3,3),
106('2011-12-13',-40,4,4),
107('2011-06-23',20040,5,5),
108('2012-01-01',30000,6,6),
109('2012-02-01',3300,7,7),
110('2012-02-03',0,8,8),
111('2012-02-03',41990,9,9),
112('2012-12-13',4718,10,10),
113('2012-12-23',47622,11,10),
114('2012-12-23',45452,12,9),
115('2012-11-03',36414,13,3),
116('2008-05-03',32799,14,15),
117('2008-05-03',45464,15,4),
118('2010-09-12',18632,16,4),
119('2012-02-02',44837,17,17),
120('2009-02-02',34210,18,15),
121('2009-04-10',46461,19,5),
122('2009-07-13',24873,20,14),
123('2010-01-23',4435,21,5),
124('2010-03-29',10415,22,3),
125('2011-02-24',7971,23,6),
126('2011-02-25',7726,24,15),
127('2012-02-25',-25061,25,2),
128('2012-12-15',-6621,26,5),
129('2012-11-09',-255,27,3),
130('2011-11-09',-4525,28,19),
131('2011-04-11',-3777,29,4),
132('2011-06-05',-4890,30,2),
133('2011-06-17',-3917,31,9),
134('2010-06-17',-423,32,19),
135('2010-08-17',-4263,33,10),
136('2009-08-17',-873,34,4),
137('2009-12-01',-3339,35,15);
138/*!40000 ALTER TABLE `cuentas` ENABLE KEYS */;
139UNLOCK TABLES;
140
141--
142-- Table structure for table `movimientos`
143--
144
145DROP TABLE IF EXISTS `movimientos`;
146/*!40101 SET @saved_cs_client     = @@character_set_client */;
147/*!40101 SET character_set_client = utf8 */;
148CREATE TABLE `movimientos` (
149  `id_movimiento` int(11) NOT NULL AUTO_INCREMENT,
150  `fechahora` date NOT NULL,
151  `cantidad` double NOT NULL,
152  `dni` int(11) NOT NULL,
153  `cod_cuenta` int(11) NOT NULL,
154  PRIMARY KEY (`id_movimiento`),
155  KEY `ccuenta` (`cod_cuenta`),
156  KEY `fk1_dni` (`dni`),
157  KEY `fk2_ccuenta` (`cod_cuenta`),
158  CONSTRAINT `fk2_ccuenta` FOREIGN KEY (`cod_cuenta`) REFERENCES `cuentas` (`cod_cuenta`) ON DELETE NO ACTION ON UPDATE NO ACTION,
159  CONSTRAINT `fk1_dni` FOREIGN KEY (`dni`) REFERENCES `clientes` (`dni`) ON DELETE NO ACTION ON UPDATE NO ACTION
160) ENGINE=InnoDB AUTO_INCREMENT=123 DEFAULT CHARSET=latin1;
161/*!40101 SET character_set_client = @saved_cs_client */;
162
163--
164-- Dumping data for table `movimientos`
165--
166
167LOCK TABLES `movimientos` WRITE;
168/*!40000 ALTER TABLE `movimientos` DISABLE KEYS */;
169INSERT INTO `movimientos` VALUES 
170(37,'2011-04-18',64028,11111111,1),
171(38,'2011-04-18',60528,44444444,4),
172(39,'2011-04-18',13979,44444444,4),
173(40,'2011-04-18',26467,44444444,4),
174(41,'2011-04-18',6906,22222222,2),
175(42,'2011-04-18',47477,44444444,4),
176(43,'2011-04-18',15490,33333333,3),
177(44,'2011-04-18',57323,22222222,2),
178(45,'2011-04-18',67620,33333333,3),
179(46,'2011-04-18',61864,33333333,3),
180(47,'2011-04-18',35142,11111111,1),
181(48,'2011-04-18',87009,11111111,1),
182(49,'2011-04-18',11884,22222222,2),
183(50,'2011-04-18',1480,11111111,1),
184(51,'2011-04-18',75530,22222222,2),
185(52,'2011-04-18',32424,44444444,4),
186(53,'2011-04-18',86077,44444444,4),
187(54,'2011-04-18',96523,33333333,3),
188(55,'2011-04-18',35796,22222222,2),
189(56,'2011-04-18',99784,33333333,3),
190(57,'2010-05-04',-583,55555555,14),
191(78,'2009-03-25',-3327,55555555,33),
192(79,'2009-03-21',471,55555555,3),
193(80,'2010-12-05',2881,66666666,13),
194(81,'2011-01-09',2784,66666666,13),
195(82,'2010-10-11',4939,66666666,9),
196(83,'2010-06-01',4972,77777777,31),
197(84,'2009-12-22',4450,77777777,31),
198(85,'2009-03-07',1763,88888888,11),
199(86,'2009-08-22',902,88888888,34),
200(87,'2010-05-15',4605,88888888,16),
201(88,'2009-08-09',4066,88888888,3),
202(89,'2011-02-08',994,99999999,23),
203(90,'2009-03-19',4733,10101010,12),
204(91,'2008-12-26',1827,10101010,6),
205(92,'2009-01-25',-3397,10101010,29),
206(93,'2010-10-29',-2440,10101010,28),
207(94,'2009-08-31',-3496,11111111,21),
208(95,'2008-11-20',-3826,11111111,2),
209(96,'2011-01-26',-1699,12121212,12),
210(97,'2009-06-07',-2685,12121212,18),
211(98,'2011-03-03',-3959,13131313,25),
212(99,'2010-11-06',-4243,13131313,22),
213(100,'2009-07-01',-2586,14141414,17),
214(101,'2011-05-24',-2351,15151515,12),
215(102,'2010-06-16',-3289,15151515,9),
216(103,'2010-06-13',-4672,16161616,22),
217(104,'2010-05-07',-4996,16161616,29),
218(105,'2010-09-14',-3550,17171717,27),
219(107,'2009-08-07',-1928,21212121,33),
220(108,'2013-03-08',-1922,15151515,33),
221(109,'2013-03-01',-1773,15151515,29),
222(110,'2011-09-01',-4997,15151515,24),
223(111,'2012-10-01',-1906,14141414,14),
224(112,'2014-01-02',-2566,13131313,24),
225(113,'2014-01-23',-3821,13131313,31),
226(114,'2011-12-07',-1447,13131313,30),
227(115,'2012-07-17',-2631,99999999,13),
228(116,'2012-02-29',-1446,99999999,21),
229(117,'2011-10-21',-4691,99999999,8),
230(118,'2012-06-23',-1273,77777777,2),
231(119,'2013-03-14',-217,77777777,8),
232(120,'2011-07-25',-2981,33333333,27),
233(121,'2011-11-23',-2669,11111111,4),
234(122,'2014-02-12',-3086,11111111,3);
235/*!40000 ALTER TABLE `movimientos` ENABLE KEYS */;
236UNLOCK TABLES;
237
238--
239-- Table structure for table `tiene`
240--
241
242DROP TABLE IF EXISTS `tiene`;
243/*!40101 SET @saved_cs_client     = @@character_set_client */;
244/*!40101 SET character_set_client = utf8 */;
245CREATE TABLE `tiene` (
246  `dni` int(7) NOT NULL,
247  `cod_cuenta` int(11) NOT NULL,
248  PRIMARY KEY (`dni`,`cod_cuenta`),
249  KEY `dd` (`dni`),
250  KEY `fk2_tccuenta` (`cod_cuenta`),
251  CONSTRAINT `fk2_tccuenta` FOREIGN KEY (`cod_cuenta`) REFERENCES `cuentas` (`cod_cuenta`) ON DELETE NO ACTION ON UPDATE NO ACTION,
252  CONSTRAINT `fk1_tdni` FOREIGN KEY (`dni`) REFERENCES `clientes` (`dni`) ON DELETE NO ACTION ON UPDATE NO ACTION
253) ENGINE=InnoDB DEFAULT CHARSET=latin1;
254/*!40101 SET character_set_client = @saved_cs_client */;
255
256--
257-- Dumping data for table `tiene`
258--
259
260LOCK TABLES `tiene` WRITE;
261/*!40000 ALTER TABLE `tiene` DISABLE KEYS */;
262INSERT INTO `tiene` VALUES 
263(11111111,1),
264(22222222,4),
265(33333333,4),
266(44444444,4),
267(55555555,2),
268(66666666,4),
269(77777777,3),
270(88888888,2),
271(99999999,3),
272(10101010,3),
273(12121212,1),
274(13131313,1),
275(14141414,2),
276(15151515,1),
277(16161616,2),
278(17171717,4),
279(18181818,4),
280(19191919,3),
281(20202020,2),
282(21212121,3);
283/*!40000 ALTER TABLE `tiene` ENABLE KEYS */;
284UNLOCK TABLES;