· 8 years ago · Dec 07, 2017, 07:14 PM
1-- phpMyAdmin SQL Dump
2-- version 4.7.2
3-- https://www.phpmyadmin.net/
4--
5-- Host: localhost:8889
6-- Generation Time: Dec 07, 2017 at 08:11 PM
7-- Server version: 5.6.35
8-- PHP Version: 7.1.6
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13--
14-- Database: `blog_db`
15--
16CREATE DATABASE IF NOT EXISTS `blog_db` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
17USE `blog_db`;
18
19-- --------------------------------------------------------
20
21--
22-- Table structure for table `post`
23--
24
25CREATE TABLE `post` (
26 `id` int(11) NOT NULL,
27 `title` text NOT NULL,
28 `date` date NOT NULL,
29 `body` text NOT NULL
30) ENGINE=InnoDB DEFAULT CHARSET=utf8;
31
32--
33-- Dumping data for table `post`
34--
35
36INSERT INTO `post` (`id`, `title`, `date`, `body`) VALUES
37(1, 'Titulo1', '2017-11-09', 'Body1'),
38(2, 'Titulo2', '2017-11-09', 'Body2'),
39(3, 'Titulo3', '2017-11-09', 'Body3'),
40(4, 'Titulo4', '2017-11-09', 'Body4'),
41(5, 'Titulo5', '2017-11-09', 'Body5');
42
43--
44-- Indexes for dumped tables
45--
46
47--
48-- Indexes for table `post`
49--
50ALTER TABLE `post`
51 ADD PRIMARY KEY (`id`);
52
53--
54-- AUTO_INCREMENT for dumped tables
55--
56
57--
58-- AUTO_INCREMENT for table `post`
59--
60ALTER TABLE `post`
61 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;--
62-- Database: `deustobd`
63--
64CREATE DATABASE IF NOT EXISTS `deustobd` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
65USE `deustobd`;
66
67-- --------------------------------------------------------
68
69--
70-- Table structure for table `noticia`
71--
72
73CREATE TABLE `noticia` (
74 `ID` int(11) NOT NULL,
75 `Fecha` date NOT NULL,
76 `Titular` varchar(50) NOT NULL,
77 `Cuerpo` text NOT NULL,
78 `Autor` varchar(20) NOT NULL
79) ENGINE=InnoDB DEFAULT CHARSET=latin1;
80
81--
82-- Dumping data for table `noticia`
83--
84
85INSERT INTO `noticia` (`ID`, `Fecha`, `Titular`, `Cuerpo`, `Autor`) VALUES
86(1, '2017-10-15', 'Descuentos en Lankopi!!!', 'Desde el proximo Lunes hasta el viernes habrá descuentos hasta el 50%.', 'Gonzalo'),
87(2, '2017-10-15', 'Noticia 2', 'Texto', 'Jon Ander'),
88(3, '2017-10-15', 'Noticia 3', 'Texto', 'Omar'),
89(4, '2017-10-15', 'Noticia 4', 'Texto', 'Unai'),
90(5, '2017-10-15', 'Noticia5', 'Texto', 'Koldo'),
91(6, '2017-10-15', 'TEXTO GORDO', 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', 'NO SE SABE'),
92(7, '2017-10-15', 'TEXTO GORDO', 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', 'NO SE SABE');
93
94--
95-- Indexes for dumped tables
96--
97
98--
99-- Indexes for table `noticia`
100--
101ALTER TABLE `noticia`
102 ADD PRIMARY KEY (`ID`);
103
104--
105-- AUTO_INCREMENT for dumped tables
106--
107
108--
109-- AUTO_INCREMENT for table `noticia`
110--
111ALTER TABLE `noticia`
112 MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;--
113-- Database: `videomaniacos`
114--
115CREATE DATABASE IF NOT EXISTS `videomaniacos` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
116USE `videomaniacos`;
117
118-- --------------------------------------------------------
119
120--
121-- Table structure for table `Videojuego`
122--
123
124CREATE TABLE `Videojuego` (
125 `id` int(11) NOT NULL,
126 `name` text NOT NULL,
127 `date` date NOT NULL,
128 `description` text NOT NULL,
129 `platform` text NOT NULL,
130 `rating` int(11) NOT NULL
131) ENGINE=InnoDB DEFAULT CHARSET=utf8;
132
133--
134-- Dumping data for table `Videojuego`
135--
136
137INSERT INTO `Videojuego` (`id`, `name`, `date`, `description`, `platform`, `rating`) VALUES
138(1, 'Juego 1', '2017-11-01', 'Descripción 1', 'Plataforma 1', 1),
139(2, 'Juego 2', '2017-11-07', 'Descripción 2', 'Plataforma 2', 2),
140(3, 'Juego 2', '2017-11-17', 'Descripción 2', 'Plataforma 3', 3);
141
142-- --------------------------------------------------------
143
144--
145-- Table structure for table `comment`
146--
147
148CREATE TABLE `comment` (
149 `id` int(11) NOT NULL,
150 `game_id` int(11) DEFAULT NULL,
151 `user` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
152 `comment` longtext COLLATE utf8_unicode_ci NOT NULL,
153 `approved` tinyint(1) NOT NULL,
154 `created` datetime NOT NULL,
155 `updated` datetime NOT NULL
156) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
157
158--
159-- Dumping data for table `comment`
160--
161
162INSERT INTO `comment` (`id`, `game_id`, `user`, `comment`, `approved`, `created`, `updated`) VALUES
163(1, 6, 'Odlok', 'Best Game', 1, '2017-12-01 15:04:42', '2017-12-01 15:04:42'),
164(0, 9, 'yo', 'Koldo ya veras como te pille te va a faltar calle para correr', 1, '2017-12-06 18:52:44', '2017-12-06 18:52:44'),
165(0, 1, '123', '1234', 1, '2017-12-07 16:31:39', '2017-12-07 16:31:39');
166
167-- --------------------------------------------------------
168
169--
170-- Table structure for table `game`
171--
172
173CREATE TABLE `game` (
174 `id` int(11) NOT NULL,
175 `name` text NOT NULL,
176 `description` text NOT NULL,
177 `pvp` int(11) NOT NULL,
178 `rating` int(11) NOT NULL,
179 `date` date NOT NULL,
180 `cplatform` int(11) DEFAULT NULL
181) ENGINE=InnoDB DEFAULT CHARSET=utf8;
182
183--
184-- Dumping data for table `game`
185--
186
187INSERT INTO `game` (`id`, `name`, `description`, `pvp`, `rating`, `date`, `cplatform`) VALUES
188(1, 'FIFA', 'de futbol', 1, 1, '2017-11-15', 1),
189(2, 'CUPHEAD', 'un indi de una taza', 2, 2, '2017-11-15', 2),
190(3, 'NBA 2K18', 'es de baloncesto ', 5, 5, '2017-11-07', 1),
191(4, 'Dark souls', 'prepata to die edition', 9, 9, '2017-11-06', 1),
192(5, 'LOL', 'la liga de las leyendas', 6, 6, '2017-11-08', 5),
193(6, 'WOW', 'Wow of wow', 9, 9, '2017-11-15', 5),
194(7, 'Buscaminas', 'tienes que buscar la mina', 2, 2, '2017-11-07', 5),
195(8, 'Tetris', 'El de toda la vida', 1, 1, '2017-11-22', 5),
196(9, 'Tekken', 'unas peleas', 3, 3, '2017-11-14', 1),
197(10, 'Mario bros', 'el mitico mario', 9, 9, '2017-11-07', 6),
198(11, 'Wii sports', 'de todos los deportes pata toda la familia', 4, 4, '2017-11-10', 6),
199(12, 'Castelvania', 'de vampires', 4, 3, '2017-11-22', 6),
200(13, 'El zelda', 'la leyenda del zelda', 8, 8, '2017-11-22', 6),
201(14, 'HALo', 'mola la ostia', 9, 9, '2017-11-06', 2),
202(15, 'Fable', 'nunca lo he jugado pero parece que mola', 3, 3, '2017-11-13', 2),
203(16, 'Gears of war', 'muy violento', 3, 2, '2017-11-09', 2);
204
205-- --------------------------------------------------------
206
207--
208-- Table structure for table `genre`
209--
210
211CREATE TABLE `genre` (
212 `id` int(11) NOT NULL,
213 `name` text NOT NULL,
214 `description` text NOT NULL
215) ENGINE=InnoDB DEFAULT CHARSET=utf8;
216
217--
218-- Dumping data for table `genre`
219--
220
221INSERT INTO `genre` (`id`, `name`, `description`) VALUES
222(3, 'Miedo', 'da todo el miedo los juegos de miedo'),
223(4, 'Plataformas', 'si te gusta saltar xd'),
224(5, 'baile', 'pa bailar jeje'),
225(6, 'lucha', 'como el tekennnnn'),
226(7, 'shoter', 'los de laws pistolas');
227
228-- --------------------------------------------------------
229
230--
231-- Table structure for table `platform`
232--
233
234CREATE TABLE `platform` (
235 `cplatform` int(11) NOT NULL,
236 `name` text NOT NULL,
237 `description` text NOT NULL,
238 `company` longtext NOT NULL
239) ENGINE=InnoDB DEFAULT CHARSET=utf8;
240
241--
242-- Dumping data for table `platform`
243--
244
245INSERT INTO `platform` (`cplatform`, `name`, `description`, `company`) VALUES
246(1, 'PLAYSATION', 'la play creada por sony', '0000-00-00'),
247(2, 'XBoxxxxx', 'es de microsoft', '0000-00-00'),
248(5, 'Ordenador', 'es un pc master race', ''),
249(6, 'La wii', 'de nintendo ', '');
250
251-- --------------------------------------------------------
252
253--
254-- Table structure for table `uniongg`
255--
256
257CREATE TABLE `uniongg` (
258 `game_id` int(11) NOT NULL,
259 `genre_id` int(11) NOT NULL
260) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
261
262--
263-- Dumping data for table `uniongg`
264--
265
266INSERT INTO `uniongg` (`game_id`, `genre_id`) VALUES
267(1, 5),
268(1, 6),
269(2, 3),
270(2, 4),
271(2, 6);
272
273--
274-- Indexes for dumped tables
275--
276
277--
278-- Indexes for table `Videojuego`
279--
280ALTER TABLE `Videojuego`
281 ADD PRIMARY KEY (`id`);
282
283--
284-- Indexes for table `game`
285--
286ALTER TABLE `game`
287 ADD PRIMARY KEY (`id`),
288 ADD KEY `IDX_232B318CDF97A66D` (`cplatform`);
289
290--
291-- Indexes for table `genre`
292--
293ALTER TABLE `genre`
294 ADD PRIMARY KEY (`id`);
295
296--
297-- Indexes for table `platform`
298--
299ALTER TABLE `platform`
300 ADD PRIMARY KEY (`cplatform`);
301
302--
303-- Indexes for table `uniongg`
304--
305ALTER TABLE `uniongg`
306 ADD PRIMARY KEY (`game_id`,`genre_id`),
307 ADD KEY `IDX_5D865300E48FD905` (`game_id`),
308 ADD KEY `IDX_5D8653004296D31F` (`genre_id`);
309
310--
311-- AUTO_INCREMENT for dumped tables
312--
313
314--
315-- AUTO_INCREMENT for table `Videojuego`
316--
317ALTER TABLE `Videojuego`
318 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
319--
320-- AUTO_INCREMENT for table `game`
321--
322ALTER TABLE `game`
323 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
324--
325-- AUTO_INCREMENT for table `genre`
326--
327ALTER TABLE `genre`
328 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
329--
330-- AUTO_INCREMENT for table `platform`
331--
332ALTER TABLE `platform`
333 MODIFY `cplatform` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
334--
335-- Constraints for dumped tables
336--
337
338--
339-- Constraints for table `game`
340--
341ALTER TABLE `game`
342 ADD CONSTRAINT `FK_232B318C28C15600` FOREIGN KEY (`cplatform`) REFERENCES `platform` (`cplatform`);
343
344--
345-- Constraints for table `uniongg`
346--
347ALTER TABLE `uniongg`
348 ADD CONSTRAINT `FK_5D8653004296D31F` FOREIGN KEY (`genre_id`) REFERENCES `genre` (`id`) ON DELETE CASCADE,
349 ADD CONSTRAINT `FK_5D865300E48FD905` FOREIGN KEY (`game_id`) REFERENCES `game` (`id`) ON DELETE CASCADE;