· 8 years ago · Dec 10, 2017, 02:20 PM
1-- phpMyAdmin SQL Dump
2-- version 4.4.15.5
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1:3306
6-- Generation Time: Dec 05, 2017 at 12:17 AM
7-- Server version: 5.6.34-log
8-- PHP Version: 5.6.28
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8mb4 */;
18
19--
20-- Database: `proyecto`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `curso`
27--
28
29CREATE TABLE IF NOT EXISTS `curso` (
30 `idCurso` int(11) NOT NULL,
31 `Curso_Id` varchar(50) NOT NULL,
32 `Turno` varchar(50) NOT NULL
33) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
34
35--
36-- Dumping data for table `curso`
37--
38
39INSERT INTO `curso` (`idCurso`, `Curso_Id`, `Turno`) VALUES
40 (1, 'Primero C', 'Mañana'),
41 (2, 'Segundo', 'Mañana');
42
43-- --------------------------------------------------------
44
45--
46-- Table structure for table `cursos_materia`
47--
48
49CREATE TABLE IF NOT EXISTS `cursos_materia` (
50 `Id` int(11) NOT NULL,
51 `Curso_Id` varchar(50) NOT NULL,
52 `Materia_Id` varchar(50) NOT NULL,
53 `CargaHoraria` float NOT NULL
54) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;
55
56--
57-- Dumping data for table `cursos_materia`
58--
59
60INSERT INTO `cursos_materia` (`Id`, `Curso_Id`, `Materia_Id`, `CargaHoraria`) VALUES
61 (33, 'Primero C', 'Ingles', 3),
62 (35, 'Segundo', 'Ingles', 3),
63 (36, 'Segundo', 'Ingles', 4);
64
65-- --------------------------------------------------------
66
67--
68-- Table structure for table `horario`
69--
70
71CREATE TABLE IF NOT EXISTS `horario` (
72 `Id` int(11) NOT NULL,
73 `Horario_Id` varchar(50) NOT NULL,
74 `Nombre` varchar(50) NOT NULL,
75 `Curso_Id` varchar(50) NOT NULL
76) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
77
78--
79-- Dumping data for table `horario`
80--
81
82INSERT INTO `horario` (`Id`, `Horario_Id`, `Nombre`, `Curso_Id`) VALUES
83 (1, 'hola', 'hola', 'Primero C'),
84 (2, 'eee', 'eee', 'Primero C');
85
86-- --------------------------------------------------------
87
88--
89-- Table structure for table `horas`
90--
91
92CREATE TABLE IF NOT EXISTS `horas` (
93 `Id` int(5) NOT NULL,
94 `horas` varchar(50) NOT NULL,
95 `orden` int(5) NOT NULL,
96 `Horario` varchar(50) NOT NULL
97) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
98
99--
100-- Dumping data for table `horas`
101--
102
103INSERT INTO `horas` (`Id`, `horas`, `orden`, `Horario`) VALUES
104 (8, '07:30 09:15', 1, 'eee'),
105 (17, '07:30 10:30', 1, 'hola');
106
107-- --------------------------------------------------------
108
109--
110-- Table structure for table `materia`
111--
112
113CREATE TABLE IF NOT EXISTS `materia` (
114 `Id` int(11) NOT NULL,
115 `Color` varchar(30) NOT NULL,
116 `Materia_Id` varchar(50) NOT NULL
117) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
118
119--
120-- Dumping data for table `materia`
121--
122
123INSERT INTO `materia` (`Id`, `Color`, `Materia_Id`) VALUES
124 (1, 'Violeta', 'Ingles'),
125 (2, 'Verde2', 'Fisica'),
126 (3, 'Azul', 'BD');
127
128-- --------------------------------------------------------
129
130--
131-- Table structure for table `materias`
132--
133
134CREATE TABLE IF NOT EXISTS `materias` (
135 `Id` int(5) NOT NULL,
136 `Nombre` varchar(20) NOT NULL,
137 `Color` varchar(20) NOT NULL
138) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;
139
140--
141-- Dumping data for table `materias`
142--
143
144INSERT INTO `materias` (`Id`, `Nombre`, `Color`) VALUES
145 (12, 'Teatro', 'Verde'),
146 (14, 'Botanica', 'Verde2'),
147 (15, 'BaseDatos', 'Azul'),
148 (16, 'Sistemas', 'Violeta'),
149 (17, 'Fisica', 'Amarillo'),
150 (18, 'Voley', 'Azul');
151
152-- --------------------------------------------------------
153
154--
155-- Table structure for table `materia_profesor`
156--
157
158CREATE TABLE IF NOT EXISTS `materia_profesor` (
159 `Id` int(11) NOT NULL,
160 `Materia_Id` varchar(50) NOT NULL,
161 `Profesor_CI` int(11) NOT NULL
162) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8;
163
164--
165-- Dumping data for table `materia_profesor`
166--
167
168INSERT INTO `materia_profesor` (`Id`, `Materia_Id`, `Profesor_CI`) VALUES
169 (69, ' Ingles', 47941291);
170
171-- --------------------------------------------------------
172
173--
174-- Table structure for table `profesor`
175--
176
177CREATE TABLE IF NOT EXISTS `profesor` (
178 `Id` int(11) NOT NULL,
179 `Profesor_CI` varchar(30) NOT NULL,
180 `Nombre` varchar(50) NOT NULL,
181 `Apellido` varchar(50) NOT NULL,
182 `Estado` tinyint(1) NOT NULL,
183 `NombreCorto` varchar(50) NOT NULL
184) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8;
185
186--
187-- Dumping data for table `profesor`
188--
189
190INSERT INTO `profesor` (`Id`, `Profesor_CI`, `Nombre`, `Apellido`, `Estado`, `NombreCorto`) VALUES
191 (29, '47941291', 'Pepe', 'Sanchez', 1, 'Pepe');
192
193-- --------------------------------------------------------
194
195--
196-- Table structure for table `redips_subject`
197--
198
199CREATE TABLE IF NOT EXISTS `redips_subject` (
200 `Id` int(11) NOT NULL,
201 `sub_id` char(2) NOT NULL,
202 `sub_name` varchar(12) NOT NULL,
203 `Color` varchar(30) NOT NULL
204) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
205
206--
207-- Dumping data for table `redips_subject`
208--
209
210INSERT INTO `redips_subject` (`Id`, `sub_id`, `sub_name`, `Color`) VALUES
211 (1, 'In', 'Ingles', 'Azul'),
212 (2, 'Fi', 'Fisica', 'Naranja');
213
214-- --------------------------------------------------------
215
216--
217-- Table structure for table `redips_timetable`
218--
219
220CREATE TABLE IF NOT EXISTS `redips_timetable` (
221 `tbl_id` int(10) unsigned NOT NULL,
222 `sub_id` char(2) NOT NULL,
223 `tbl_row` smallint(6) NOT NULL,
224 `tbl_col` smallint(6) NOT NULL,
225 `Profe1` varchar(50) NOT NULL,
226 `Profe2` varchar(50) NOT NULL,
227 `Nombre` varchar(100) NOT NULL
228) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;
229
230--
231-- Dumping data for table `redips_timetable`
232--
233
234INSERT INTO `redips_timetable` (`tbl_id`, `sub_id`, `tbl_row`, `tbl_col`, `Profe1`, `Profe2`, `Nombre`) VALUES
235 (21, 'In', 1, 2, 'Pepe', '', 'hola');
236
237-- --------------------------------------------------------
238
239--
240-- Table structure for table `usuarios`
241--
242
243CREATE TABLE IF NOT EXISTS `usuarios` (
244 `Id` int(10) NOT NULL,
245 `CI` varchar(30) NOT NULL,
246 `Nombre` varchar(50) NOT NULL,
247 `Apellido` varchar(50) NOT NULL,
248 `Password` varchar(50) NOT NULL,
249 `EsAdmin` tinyint(1) NOT NULL
250) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
251
252--
253-- Dumping data for table `usuarios`
254--
255
256INSERT INTO `usuarios` (`Id`, `CI`, `Nombre`, `Apellido`, `Password`, `EsAdmin`) VALUES
257 (3, '47941291', 'juanpagl', 'pereznola', '123456123', 1),
258 (4, '123', 'joaquin', 'servetto', '123', 1);
259
260--
261-- Indexes for dumped tables
262--
263
264--
265-- Indexes for table `curso`
266--
267ALTER TABLE `curso`
268 ADD PRIMARY KEY (`idCurso`),
269 ADD UNIQUE KEY `Curso_Id` (`Curso_Id`);
270
271--
272-- Indexes for table `cursos_materia`
273--
274ALTER TABLE `cursos_materia`
275 ADD PRIMARY KEY (`Id`);
276
277--
278-- Indexes for table `horario`
279--
280ALTER TABLE `horario`
281 ADD PRIMARY KEY (`Id`),
282 ADD UNIQUE KEY `Horario_Id` (`Horario_Id`);
283
284--
285-- Indexes for table `horas`
286--
287ALTER TABLE `horas`
288 ADD PRIMARY KEY (`Id`),
289 ADD UNIQUE KEY `Id` (`Id`),
290 ADD KEY `Id_2` (`Id`);
291
292--
293-- Indexes for table `materia`
294--
295ALTER TABLE `materia`
296 ADD PRIMARY KEY (`Id`);
297
298--
299-- Indexes for table `materias`
300--
301ALTER TABLE `materias`
302 ADD PRIMARY KEY (`Id`),
303 ADD UNIQUE KEY `Nombre` (`Nombre`);
304
305--
306-- Indexes for table `materia_profesor`
307--
308ALTER TABLE `materia_profesor`
309 ADD PRIMARY KEY (`Id`);
310
311--
312-- Indexes for table `profesor`
313--
314ALTER TABLE `profesor`
315 ADD PRIMARY KEY (`Id`),
316 ADD UNIQUE KEY `Id` (`Id`),
317 ADD UNIQUE KEY `Profesor_CI` (`Profesor_CI`);
318
319--
320-- Indexes for table `redips_subject`
321--
322ALTER TABLE `redips_subject`
323 ADD PRIMARY KEY (`Id`),
324 ADD UNIQUE KEY `sub_id` (`sub_id`);
325
326--
327-- Indexes for table `redips_timetable`
328--
329ALTER TABLE `redips_timetable`
330 ADD PRIMARY KEY (`tbl_id`) USING BTREE;
331
332--
333-- Indexes for table `usuarios`
334--
335ALTER TABLE `usuarios`
336 ADD PRIMARY KEY (`Id`),
337 ADD UNIQUE KEY `CI` (`CI`);
338
339--
340-- AUTO_INCREMENT for dumped tables
341--
342
343--
344-- AUTO_INCREMENT for table `curso`
345--
346ALTER TABLE `curso`
347 MODIFY `idCurso` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
348--
349-- AUTO_INCREMENT for table `cursos_materia`
350--
351ALTER TABLE `cursos_materia`
352 MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=37;
353--
354-- AUTO_INCREMENT for table `horario`
355--
356ALTER TABLE `horario`
357 MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
358--
359-- AUTO_INCREMENT for table `horas`
360--
361ALTER TABLE `horas`
362 MODIFY `Id` int(5) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=18;
363--
364-- AUTO_INCREMENT for table `materia`
365--
366ALTER TABLE `materia`
367 MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
368--
369-- AUTO_INCREMENT for table `materias`
370--
371ALTER TABLE `materias`
372 MODIFY `Id` int(5) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=20;
373--
374-- AUTO_INCREMENT for table `materia_profesor`
375--
376ALTER TABLE `materia_profesor`
377 MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=70;
378--
379-- AUTO_INCREMENT for table `profesor`
380--
381ALTER TABLE `profesor`
382 MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=30;
383--
384-- AUTO_INCREMENT for table `redips_subject`
385--
386ALTER TABLE `redips_subject`
387 MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
388--
389-- AUTO_INCREMENT for table `redips_timetable`
390--
391ALTER TABLE `redips_timetable`
392 MODIFY `tbl_id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=22;
393--
394-- AUTO_INCREMENT for table `usuarios`
395--
396ALTER TABLE `usuarios`
397 MODIFY `Id` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
398/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
399/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
400/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;