-
Notifications
You must be signed in to change notification settings - Fork 6
/
futbol.sql
142 lines (134 loc) · 4.94 KB
/
futbol.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
create database if not exists futbol;
use futbol;
drop table if exists partidos;
drop table if exists jugadores;
drop table if exists equipos;
create table equipos (
id int auto_increment primary key
, nombre varchar(50) not null
, unique key (nombre)
);
create table jugadores (
id int auto_increment primary key
, nombre varchar(50) not null
, posicion int not null
, equipo int not null
, foreign key (equipo)
references equipos(id)
on update cascade
on delete restrict
);
create table partidos (
id int auto_increment primary key
, fecha timestamp not null
, local_equipo int not null
, visit_equipo int not null
, local_goles int not null
, visit_goles int not null
, foreign key (local_equipo) references equipos(id)
, foreign key (visit_equipo) references equipos(id)
);
insert into equipos (id, nombre)
values (1, 'Deportivo La Tristeza')
, (2, 'Defensores de Medrano')
, (3, 'C.A. Perros Unidos')
;
insert into jugadores (nombre, posicion, equipo)
values ('Dr. Diego Alejandro Cisneros Segundo', 4, 1)
, ('Lic. Franco Ureña Hijo', 8, 3)
, ('Alejandra Acuña', 3, 3)
, ('Julia Gaytan', 1, 3)
, ('Camilo Arreola', 1, 1)
, ('Carlos Velazquez', 10, 1)
, ('Dn. Hugo Caraballo', 3, 1)
, ('Thiago Moya Segundo', 10, 3)
, ('Matias Palacios', 1, 2)
, ('Sra. Jazmin Oquendo Hijo', 7, 2)
, ('Maria Santillan', 10, 2)
, ('Bianca Alva', 4, 3)
, ('Dr. Antonio Aguilera', 9, 1)
, ('Bruno Castro', 9, 3)
, ('Pedro Arroyo', 4, 3)
, ('Sara Sofia Coronado', 11, 1)
, ('Ing. Dante Santillan', 8, 1)
, ('Lic. Dylan Leiva', 4, 3)
, ('Magdalena Orosco', 6, 2)
, ('Maria Jose Gamboa', 1, 2)
, ('Facundo Delagarza', 5, 2)
, ('Lic. Isabella Campos', 4, 2)
, ('Dn. Jacobo Rosado', 8, 2)
, ('Sebastian Delvalle Segundo', 9, 3)
, ('Sara Sofia Urbina', 1, 3)
, ('Alexa Mora', 5, 3)
, ('Elena Carmona', 1, 1)
, ('Mario Chavarria', 9, 2)
, ('Ing. Dante Mares', 8, 1)
, ('Jesus Ceja Segundo', 7, 1)
, ('Lic. Ariana Venegas Hijo', 8, 2)
, ('Oliva Alvarado', 5, 2)
, ('Sra. Alejandra Salgado', 2, 1)
, ('Alessandra Alcala', 6, 1)
, ('Ing. Rafaela Matos', 8, 1)
, ('Victoria Sosa', 2, 3)
, ('Isaac Luna', 7, 3)
, ('Ing. Axel Roybal Segundo', 11, 3)
, ('Santino Sedillo Hijo', 5, 2)
, ('Sergio Ozuna', 3, 2)
, ('Lautaro Calderon', 11, 2)
, ('Juan Pablo Holguin', 3, 1)
, ('Julian Longoria', 2, 2)
, ('Bianca Munguia', 7, 2)
, ('Damian Robledo Hijo', 9, 1)
;
insert into partidos (fecha, local_equipo, visit_equipo, local_goles, visit_goles)
values ('2017-04-28 11:06:30', 3, 2, 7, 2)
, ('2017-06-01 03:15:30', 2, 2, 7, 5)
, ('2017-05-18 19:33:09', 3, 3, 4, 5)
, ('2017-05-11 15:18:58', 1, 1, 3, 1)
, ('2016-12-03 11:27:53', 3, 2, 5, 2)
, ('2017-04-30 17:37:31', 2, 1, 5, 3)
, ('2017-02-07 11:19:23', 3, 3, 3, 4)
, ('2017-08-13 23:50:44', 2, 2, 0, 4)
, ('2017-05-30 03:23:29', 1, 1, 7, 5)
, ('2017-06-14 04:26:10', 1, 1, 2, 5)
, ('2017-08-13 14:13:51', 1, 2, 6, 0)
, ('2017-09-06 19:11:49', 3, 3, 0, 3)
, ('2016-11-13 01:16:14', 3, 2, 7, 1)
, ('2016-11-08 05:36:06', 1, 2, 5, 5)
, ('2017-09-13 13:10:53', 1, 3, 6, 3)
, ('2017-10-31 08:38:24', 1, 2, 1, 4)
, ('2017-09-15 14:17:32', 2, 1, 4, 4)
, ('2017-09-02 07:39:33', 3, 2, 7, 1)
, ('2017-02-23 00:39:30', 1, 1, 2, 4)
, ('2017-03-18 17:29:52', 2, 1, 4, 4)
, ('2017-08-12 10:13:29', 2, 1, 7, 0)
, ('2017-10-05 15:10:53', 2, 3, 6, 1)
, ('2017-08-10 18:15:27', 1, 3, 5, 5)
, ('2017-04-25 01:33:14', 1, 3, 6, 0)
, ('2017-02-01 03:28:20', 2, 3, 5, 1)
, ('2017-02-28 13:27:31', 3, 1, 6, 5)
, ('2016-11-20 15:31:01', 2, 3, 4, 3)
, ('2017-10-12 16:42:51', 3, 1, 2, 0)
, ('2016-11-13 18:54:44', 2, 1, 5, 5)
, ('2016-12-06 09:53:45', 1, 1, 4, 3)
, ('2017-05-29 09:33:59', 3, 3, 2, 2)
, ('2017-05-29 21:03:40', 3, 1, 2, 3)
, ('2017-10-31 13:12:32', 1, 3, 3, 4)
, ('2017-03-23 13:34:41', 1, 3, 7, 5)
, ('2017-02-24 22:30:44', 1, 3, 0, 0)
, ('2017-10-11 22:59:41', 3, 2, 0, 1)
, ('2017-05-25 22:27:43', 2, 1, 3, 4)
, ('2017-07-21 12:36:44', 1, 1, 2, 5)
, ('2017-01-26 06:25:47', 3, 3, 2, 1)
, ('2017-01-13 13:20:47', 1, 2, 0, 2)
, ('2017-03-17 02:48:07', 3, 2, 1, 2)
, ('2017-01-01 09:01:06', 3, 3, 6, 2)
, ('2017-09-13 00:08:17', 2, 2, 6, 1)
, ('2017-06-10 13:49:24', 3, 1, 4, 1)
, ('2016-11-20 20:32:19', 2, 3, 1, 2)
, ('2016-12-30 18:45:59', 3, 2, 3, 2)
, ('2017-06-01 22:23:33', 1, 3, 1, 5)
, ('2017-08-20 10:40:31', 2, 1, 2, 2)
, ('2017-09-10 07:44:52', 2, 2, 0, 3)
, ('2017-06-18 01:06:33', 1, 3, 0, 5)
;