· 10 years ago · Sep 19, 2016, 03:50 AM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Versión del servidor: 5.6.15-log - MySQL Community Server (GPL)
4-- SO del servidor: Win32
5-- HeidiSQL Versión: 9.3.0.4984
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8mb4 */;
10/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
11/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
12
13-- Volcando estructura de base de datos para clazloop
14CREATE DATABASE IF NOT EXISTS `clazloop` /*!40100 DEFAULT CHARACTER SET latin1 */;
15USE `clazloop`;
16
17
18-- Volcando estructura para tabla clazloop.alembic_version
19CREATE TABLE IF NOT EXISTS `alembic_version` (
20 `version_num` varchar(32) NOT NULL
21) ENGINE=InnoDB DEFAULT CHARSET=latin1;
22
23-- Volcando datos para la tabla clazloop.alembic_version: ~0 rows (aproximadamente)
24DELETE FROM `alembic_version`;
25/*!40000 ALTER TABLE `alembic_version` DISABLE KEYS */;
26INSERT INTO `alembic_version` (`version_num`) VALUES
27 ('c1dc96e80705');
28/*!40000 ALTER TABLE `alembic_version` ENABLE KEYS */;
29
30
31-- Volcando estructura para tabla clazloop.api_keys
32CREATE TABLE IF NOT EXISTS `api_keys` (
33 `id` int(11) NOT NULL AUTO_INCREMENT,
34 `key` varchar(150) DEFAULT NULL,
35 `device` varchar(50) DEFAULT NULL,
36 PRIMARY KEY (`id`)
37) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
38
39-- Volcando datos para la tabla clazloop.api_keys: 1 rows
40DELETE FROM `api_keys`;
41/*!40000 ALTER TABLE `api_keys` DISABLE KEYS */;
42INSERT INTO `api_keys` (`id`, `key`, `device`) VALUES
43 (1, 'a', 's');
44/*!40000 ALTER TABLE `api_keys` ENABLE KEYS */;
45
46
47-- Volcando estructura para tabla clazloop.areas
48CREATE TABLE IF NOT EXISTS `areas` (
49 `id` int(11) NOT NULL AUTO_INCREMENT,
50 `quantity` int(10) DEFAULT NULL,
51 `name` varchar(150) DEFAULT NULL,
52 `description` varchar(300) DEFAULT NULL,
53 `image` varchar(100) DEFAULT NULL,
54 PRIMARY KEY (`id`)
55) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
56
57-- Volcando datos para la tabla clazloop.areas: ~3 rows (aproximadamente)
58DELETE FROM `areas`;
59/*!40000 ALTER TABLE `areas` DISABLE KEYS */;
60INSERT INTO `areas` (`id`, `quantity`, `name`, `description`, `image`) VALUES
61 (1, 3, 'PostConflicto', 'Insertar descrippcion', NULL),
62 (2, 3, 'Desarrollo Personal', 'Insertar descrippcion', NULL),
63 (3, 3, 'Innovacion y Emprendimiento', 'Insertar descrippcion', NULL);
64/*!40000 ALTER TABLE `areas` ENABLE KEYS */;
65
66
67-- Volcando estructura para tabla clazloop.chatmessages
68CREATE TABLE IF NOT EXISTS `chatmessages` (
69 `messageId` int(11) NOT NULL AUTO_INCREMENT,
70 `chatroomId` int(11) DEFAULT NULL,
71 `userID` int(11) DEFAULT NULL,
72 `Message` varchar(50) DEFAULT NULL,
73 `date` varchar(50) DEFAULT NULL,
74 PRIMARY KEY (`messageId`)
75) ENGINE=MyISAM DEFAULT CHARSET=latin1;
76
77-- Volcando datos para la tabla clazloop.chatmessages: 0 rows
78DELETE FROM `chatmessages`;
79/*!40000 ALTER TABLE `chatmessages` DISABLE KEYS */;
80/*!40000 ALTER TABLE `chatmessages` ENABLE KEYS */;
81
82
83-- Volcando estructura para tabla clazloop.chatrooms
84CREATE TABLE IF NOT EXISTS `chatrooms` (
85 `chatroomId` int(11) NOT NULL AUTO_INCREMENT,
86 `name` varchar(50) DEFAULT NULL,
87 `date` varchar(50) DEFAULT NULL,
88 PRIMARY KEY (`chatroomId`)
89) ENGINE=MyISAM DEFAULT CHARSET=latin1;
90
91-- Volcando datos para la tabla clazloop.chatrooms: 0 rows
92DELETE FROM `chatrooms`;
93/*!40000 ALTER TABLE `chatrooms` DISABLE KEYS */;
94/*!40000 ALTER TABLE `chatrooms` ENABLE KEYS */;
95
96
97-- Volcando estructura para tabla clazloop.codes
98CREATE TABLE IF NOT EXISTS `codes` (
99 `id` int(11) NOT NULL AUTO_INCREMENT,
100 `code` varchar(50) DEFAULT '0',
101 `is_active` int(11) DEFAULT '0',
102 PRIMARY KEY (`id`)
103) ENGINE=MyISAM AUTO_INCREMENT=205 DEFAULT CHARSET=latin1;
104
105-- Volcando datos para la tabla clazloop.codes: 5 rows
106DELETE FROM `codes`;
107/*!40000 ALTER TABLE `codes` DISABLE KEYS */;
108INSERT INTO `codes` (`id`, `code`, `is_active`) VALUES
109 (204, 'TESTCODE', 0),
110 (203, 'America12*', 0),
111 (202, 'E6PQD92C', 0),
112 (201, 'America12*', 0),
113 (200, 'ABC123s4', 0);
114/*!40000 ALTER TABLE `codes` ENABLE KEYS */;
115
116
117-- Volcando estructura para tabla clazloop.courses
118CREATE TABLE IF NOT EXISTS `courses` (
119 `id` int(11) NOT NULL AUTO_INCREMENT,
120 `area` int(11) DEFAULT NULL,
121 `level` int(11) DEFAULT NULL,
122 `bg_image` varchar(350) DEFAULT NULL,
123 `name` varchar(180) DEFAULT NULL,
124 `description` varchar(800) DEFAULT NULL,
125 `attachment` varchar(50) NOT NULL DEFAULT '0',
126 `tag` varchar(50) NOT NULL DEFAULT '0',
127 PRIMARY KEY (`id`),
128 KEY `FK_courses_areas` (`area`),
129 CONSTRAINT `FK_courses_areas` FOREIGN KEY (`area`) REFERENCES `areas` (`id`)
130) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=latin1;
131
132-- Volcando datos para la tabla clazloop.courses: ~36 rows (aproximadamente)
133DELETE FROM `courses`;
134/*!40000 ALTER TABLE `courses` DISABLE KEYS */;
135INSERT INTO `courses` (`id`, `area`, `level`, `bg_image`, `name`, `description`, `attachment`, `tag`) VALUES
136 (1, 1, 1, NULL, 'Cultura Ciudadana', 'La cultura ciudadana se define como el conjunto de valores, actitudes,\r\ncomportamientos y normas compartidas que generan sentido de pertenencia,\r\nimpulsan el progreso, facilitan la convivencia y conducen al respeto del\r\npatrimonio común. Uno de los principales objetivos de la cultura ciudadana es\r\ngenerar capital social, que se traduce en la capacidad de interactuar y colaborar\r\nentre personas e instituciones, orientada a la obtención del bienestar colectivo', 'null', 'conflicto, cultura'),
137 (2, 1, 1, NULL, 'Potencial & Legado', 'no definida', 'null', 'convivencia, conflicto'),
138 (3, 1, 1, NULL, 'Formacion (El Perdon, El Orgullo, El Miedo, La Depresion)', 'no definida', 'null', 'postconflicto'),
139 (4, 1, 1, NULL, 'Autoestima', 'no definida', 'null', 'conflicto, cultura'),
140 (5, 1, 1, NULL, 'Alfabetizacion', 'no definida', 'null', 'convivencia, conflicto'),
141 (6, 1, 1, NULL, 'Reinsercion', 'no definida', 'null', 'convivencia, conflicto'),
142 (7, 1, 1, NULL, 'Convivencia', 'no definida', 'null', 'convivencia'),
143 (8, 1, 1, NULL, 'Proposito', 'no definida', 'null', 'proposito, camino, vida'),
144 (9, 1, 2, NULL, 'Inteligencia Emocional', 'no definida', 'null', 'insert tag here'),
145 (10, 1, 2, NULL, 'Habitos', 'no definida', 'null', 'insert tag here'),
146 (11, 1, 2, NULL, 'Dominio Propio', 'no definida', 'null', 'insert tag here'),
147 (12, 1, 2, NULL, 'Integridad y Caracter', 'no definida', 'null', 'insert tag here'),
148 (13, 1, 3, NULL, 'Ciudadano del Mundo en el Siglo XXI', 'no definida', 'null', 'insert tag here'),
149 (14, 1, 3, NULL, 'Preparacion & Planeacion', 'no definida', 'null', 'insert tag here'),
150 (15, 1, 3, NULL, 'La Familia', 'no definida', 'null', 'insert tag here'),
151 (16, 1, 3, NULL, 'Control de Calidad', 'no definida', 'null', 'insert tag here'),
152 (17, 1, 3, NULL, 'Paz y Para Que', 'no definida', 'null', 'insert tag here'),
153 (18, 1, 3, NULL, 'Emprende por Paz', 'no definida', 'null', 'insert tag here'),
154 (19, 1, 3, NULL, 'Reconciliacion', 'no definida', 'null', 'insert tag here'),
155 (20, 2, 1, NULL, 'Auto-Descubrimiento', 'no definida', 'null', 'insert tag here'),
156 (21, 2, 1, NULL, 'Mision', 'no definida', 'null', 'insert tag here'),
157 (22, 2, 1, NULL, 'Valores', 'no definida', 'null', 'insert tag here'),
158 (23, 2, 1, NULL, 'Cultura', 'no definida', 'null', 'insert tag here'),
159 (24, 2, 1, NULL, 'Dones y Talentos', 'no definida', 'null', 'insert tag here'),
160 (25, 2, 2, NULL, 'Proposito', 'no definida', 'null', 'insert tag here'),
161 (26, 2, 2, NULL, 'Potencial', 'no definida', 'null', 'insert tag here'),
162 (27, 2, 2, NULL, 'Vision', 'no definida', 'null', 'insert tag here'),
163 (28, 2, 2, NULL, 'Actualizacion', 'no definida', 'null', 'insert tag here'),
164 (29, 2, 2, NULL, 'Habitos', 'no definida', 'null', 'insert tag here'),
165 (30, 2, 2, NULL, 'Auto-disciplina', 'no definida', 'null', 'insert tag here'),
166 (31, 2, 3, NULL, 'Preparaion', 'no definida', 'null', 'insert tag here'),
167 (32, 2, 3, NULL, 'Planeacion', 'no definida', 'null', 'insert tag here'),
168 (33, 2, 3, NULL, 'Ejecucion', 'no definida', 'null', 'insert tag here'),
169 (34, 2, 3, NULL, 'Enfoque', 'no definida', 'null', 'insert tag here'),
170 (35, 2, 3, NULL, 'Fuerza de Voluntad', 'no definida', 'null', 'insert tag here'),
171 (36, 2, 3, NULL, 'Salud', 'no definida', 'null', 'insert tag here'),
172 (37, 3, 3, NULL, 'Curso de prueba', 'no definida', '0', 'insert tag here');
173/*!40000 ALTER TABLE `courses` ENABLE KEYS */;
174
175
176-- Volcando estructura para tabla clazloop.notes
177CREATE TABLE IF NOT EXISTS `notes` (
178 `id` int(11) NOT NULL AUTO_INCREMENT,
179 `iduser` int(11) DEFAULT NULL,
180 `courseid` int(11) DEFAULT NULL,
181 `videoid` int(11) DEFAULT NULL,
182 `title` varchar(250) DEFAULT NULL,
183 `text` varchar(800) DEFAULT NULL,
184 PRIMARY KEY (`id`)
185) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
186
187-- Volcando datos para la tabla clazloop.notes: 2 rows
188DELETE FROM `notes`;
189/*!40000 ALTER TABLE `notes` DISABLE KEYS */;
190INSERT INTO `notes` (`id`, `iduser`, `courseid`, `videoid`, `title`, `text`) VALUES
191 (1, 39, 1, 1, 'Hola Mundo', 'asldjkaskldjalskdjaskldjalksjda'),
192 (2, 39, 1, 2, 'Hola infierno', 'asldjkaskldjalskdjaskldjalksjda');
193/*!40000 ALTER TABLE `notes` ENABLE KEYS */;
194
195
196-- Volcando estructura para tabla clazloop.permisions
197CREATE TABLE IF NOT EXISTS `permisions` (
198 `id` int(11) NOT NULL,
199 `rol` varchar(50) DEFAULT NULL,
200 `description` varchar(300) DEFAULT NULL,
201 PRIMARY KEY (`id`)
202) ENGINE=MyISAM DEFAULT CHARSET=latin1;
203
204-- Volcando datos para la tabla clazloop.permisions: 0 rows
205DELETE FROM `permisions`;
206/*!40000 ALTER TABLE `permisions` DISABLE KEYS */;
207/*!40000 ALTER TABLE `permisions` ENABLE KEYS */;
208
209
210-- Volcando estructura para tabla clazloop.quiz_options
211CREATE TABLE IF NOT EXISTS `quiz_options` (
212 `id` int(11) NOT NULL AUTO_INCREMENT,
213 `questionid` int(11) DEFAULT NULL,
214 `section` int(11) DEFAULT NULL,
215 `textoption` varchar(400) DEFAULT NULL,
216 `true` int(11) DEFAULT '0',
217 PRIMARY KEY (`id`)
218) ENGINE=MyISAM AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;
219
220-- Volcando datos para la tabla clazloop.quiz_options: 20 rows
221DELETE FROM `quiz_options`;
222/*!40000 ALTER TABLE `quiz_options` DISABLE KEYS */;
223INSERT INTO `quiz_options` (`id`, `questionid`, `section`, `textoption`, `true`) VALUES
224 (1, 1, 1, 'crecer mejor', 0),
225 (2, 1, 1, 'tener mejor relqacion con los demas', 1),
226 (3, 1, 1, 'hacer que la vida sea mas agradable', 0),
227 (4, 1, 1, 'incrementar las ganancias de un negocio', 0),
228 (5, 2, 2, 'abc', 0),
229 (6, 2, 2, 'defg', 0),
230 (7, 2, 2, 'ijok', 0),
231 (8, 2, 2, 'lmn', 0),
232 (9, 3, 3, 'lalalal', 0),
233 (10, 3, 1, 'xD', 0),
234 (11, 3, 1, 'xD', 0),
235 (12, 3, 1, 'xD', 0),
236 (13, 4, 1, 'xD', 0),
237 (14, 4, 2, 'fg', 0),
238 (15, 4, 2, 'fg', 0),
239 (16, 4, 2, 'fg', 0),
240 (17, 5, 2, 'fg', 0),
241 (18, 5, 2, '123', 0),
242 (19, 6, 2, '123', 0),
243 (20, 6, 2, '123', 0);
244/*!40000 ALTER TABLE `quiz_options` ENABLE KEYS */;
245
246
247-- Volcando estructura para tabla clazloop.quiz_questions
248CREATE TABLE IF NOT EXISTS `quiz_questions` (
249 `id` int(11) NOT NULL AUTO_INCREMENT,
250 `videoid` int(11) DEFAULT NULL,
251 `question` varchar(450) DEFAULT NULL,
252 PRIMARY KEY (`id`)
253) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
254
255-- Volcando datos para la tabla clazloop.quiz_questions: 6 rows
256DELETE FROM `quiz_questions`;
257/*!40000 ALTER TABLE `quiz_questions` DISABLE KEYS */;
258INSERT INTO `quiz_questions` (`id`, `videoid`, `question`) VALUES
259 (1, 1, '¿Por definicion la cultura ciudadana es el conjunto de normas que se deben seguir para?'),
260 (2, 1, '¿La cultura ciudadana sirve para?'),
261 (3, 1, 'Se peude vivir sin cultura ciudadana?'),
262 (4, 1, 'this is '),
263 (5, 2, 'sparta'),
264 (6, 2, 'pregunta');
265/*!40000 ALTER TABLE `quiz_questions` ENABLE KEYS */;
266
267
268-- Volcando estructura para tabla clazloop.sessions
269CREATE TABLE IF NOT EXISTS `sessions` (
270 `id` int(10) NOT NULL AUTO_INCREMENT,
271 `userId` int(10) DEFAULT NULL,
272 `token` varchar(200) DEFAULT NULL,
273 `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
274 PRIMARY KEY (`id`)
275) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
276
277-- Volcando datos para la tabla clazloop.sessions: 8 rows
278DELETE FROM `sessions`;
279/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
280INSERT INTO `sessions` (`id`, `userId`, `token`, `date`) VALUES
281 (1, 39, 'lwv-td7I0kbmD17hBAix9b2Bp-Y3CnktycI7XzalCTI', NULL),
282 (2, 39, '8XrIROtkqbJPe_cCS5R1A61DG3TnL2V6DfmLJPm9t7E', NULL),
283 (3, 39, 'yqLFhHrdiqt0v-rdTC_5ELkMjmImy78IAKXI96SWCtU', '2016-09-08 11:13:54'),
284 (4, 39, 'YTYNPXf9zex_YAVhkvVd0ubT9N-yCucSkQMw_KXq85E', '2016-09-13 11:39:34'),
285 (5, 39, 'FIVjjJj14AfNfNhcftdDfkQIOdL6RWDQ19M8fF-AY1U', '2016-09-13 14:14:36'),
286 (6, 39, 'ZV4k2Z6bJSk_mmOsoqSRTFkA8S3Z3VARLH3cGqIaHdo', '2016-09-13 22:13:35'),
287 (7, 39, 'pPP_UARY5dlzA-dZWYq7sSRngW3hG2Eaplps3JWoDG0', '2016-09-13 22:18:58'),
288 (8, 39, 'i_0C7us1pIzVIoRkONBmQTiXX2jU5-9lbgux-V5Q_mI', '2016-09-16 13:06:45');
289/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
290
291
292-- Volcando estructura para tabla clazloop.subscriptions
293CREATE TABLE IF NOT EXISTS `subscriptions` (
294 `id` int(11) NOT NULL AUTO_INCREMENT,
295 `userId` int(11) NOT NULL,
296 `courseId` int(11) NOT NULL,
297 `subDate` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
298 `progression` varchar(20) NOT NULL,
299 `completed` tinyint(1) NOT NULL,
300 PRIMARY KEY (`id`)
301) ENGINE=MyISAM AUTO_INCREMENT=56 DEFAULT CHARSET=latin1;
302
303-- Volcando datos para la tabla clazloop.subscriptions: 4 rows
304DELETE FROM `subscriptions`;
305/*!40000 ALTER TABLE `subscriptions` DISABLE KEYS */;
306INSERT INTO `subscriptions` (`id`, `userId`, `courseId`, `subDate`, `progression`, `completed`) VALUES
307 (47, 39, 37, '2016-09-10 18:37:13', '0', 0),
308 (46, 39, 28, '2016-09-10 18:37:09', '0', 0),
309 (53, 39, 1, '2016-09-10 18:43:32', '0', 0),
310 (50, 39, 2, '2016-09-10 18:40:04', '0', 0);
311/*!40000 ALTER TABLE `subscriptions` ENABLE KEYS */;
312
313
314-- Volcando estructura para tabla clazloop.users
315CREATE TABLE IF NOT EXISTS `users` (
316 `id` int(11) NOT NULL AUTO_INCREMENT,
317 `email` varchar(250) NOT NULL,
318 `names` varchar(250) NOT NULL,
319 `password` varchar(200) NOT NULL,
320 `phone` varchar(50) DEFAULT NULL,
321 `city` varchar(50) DEFAULT NULL,
322 `birth` varchar(50) DEFAULT NULL,
323 `creation_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
324 `is_active` int(11) DEFAULT '0',
325 `is_admin` int(11) DEFAULT '0',
326 `id_code` varchar(50) DEFAULT NULL,
327 `profile_pic` varchar(300) DEFAULT NULL,
328 `cc` varchar(50) DEFAULT NULL,
329 PRIMARY KEY (`id`),
330 UNIQUE KEY `email` (`email`)
331) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=latin1;
332
333-- Volcando datos para la tabla clazloop.users: ~1 rows (aproximadamente)
334DELETE FROM `users`;
335/*!40000 ALTER TABLE `users` DISABLE KEYS */;
336INSERT INTO `users` (`id`, `email`, `names`, `password`, `phone`, `city`, `birth`, `creation_time`, `is_active`, `is_admin`, `id_code`, `profile_pic`, `cc`) VALUES
337 (39, 'db@clazbooks.com', 'Douglas Brunal Fabra', 'f35f811da5ddc1e141dc225204d6bac765e3b1e351c98c8c0a818ec88482050a', '3218240106', '127.0.0.1', '1990-02-28', '2016-08-20 10:56:06', 1, 0, 'ABC123s4', '1472083682.png', '1067883710'),
338 (40, 'adb@clazbooks.com', 'Douglas Brunal Fabra', 'c8627446e99aade754f0b1564accc6bba51594c8ac3fd3f49f7911eb0944edee', '3218240106', '127.0.0.1', '1990-02-28', '2016-08-20 10:56:06', 1, 0, 'ABC123s4', '1472083682.png', '1067883710'),
339 (41, 'deadkity@gmail.com', 'Jorge Brunal', 'f35f811da5ddc1e141dc225204d6bac765e3b1e351c98c8c0a818ec88482050a', '3013037282', '127.0.0.1', '2013-10-30', '2016-09-11 12:02:22', 0, 0, 'E6PQD92C', NULL, NULL),
340 (42, 'frankithy@gmail.com', 'Douglas Brunal', '49d517546ef180524c4b7d2744e0ccb3d5a26f8abbff66f55249def25ef6c8cb', '3166415130', NULL, NULL, '2016-09-13 12:18:39', NULL, NULL, 'TESTCODE', NULL, NULL);
341/*!40000 ALTER TABLE `users` ENABLE KEYS */;
342
343
344-- Volcando estructura para tabla clazloop.videos
345CREATE TABLE IF NOT EXISTS `videos` (
346 `id` int(11) NOT NULL AUTO_INCREMENT,
347 `cursoId` int(11) DEFAULT NULL,
348 `title` varchar(100) DEFAULT NULL,
349 `description` varchar(800) DEFAULT NULL,
350 `link` varchar(800) DEFAULT NULL,
351 `duration` varchar(10) DEFAULT '00:00',
352 PRIMARY KEY (`id`)
353) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
354
355-- Volcando datos para la tabla clazloop.videos: 6 rows
356DELETE FROM `videos`;
357/*!40000 ALTER TABLE `videos` DISABLE KEYS */;
358INSERT INTO `videos` (`id`, `cursoId`, `title`, `description`, `link`, `duration`) VALUES
359 (1, 1, 'Bases de la cultura', NULL, '168365960', '00:00'),
360 (2, 1, 'antecedentes', NULL, '181109548', '00:00'),
361 (3, 1, 'sociedad', NULL, '181907337', '00:00'),
362 (4, 2, 'el poder del pueblo', NULL, '181854249', '00:00'),
363 (5, 1, 'crecer en comunion', NULL, '181118448', '00:00'),
364 (6, 2, 'la gracia del pueblo', NULL, '168365960', '00:00');
365/*!40000 ALTER TABLE `videos` ENABLE KEYS */;
366
367
368-- Volcando estructura para tabla clazloop.viewedvideo
369CREATE TABLE IF NOT EXISTS `viewedvideo` (
370 `id` int(11) NOT NULL AUTO_INCREMENT,
371 `userId` int(11) DEFAULT NULL,
372 `videoId` int(11) DEFAULT NULL,
373 `watched` int(11) DEFAULT '0',
374 PRIMARY KEY (`id`)
375) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
376
377-- Volcando datos para la tabla clazloop.viewedvideo: 1 rows
378DELETE FROM `viewedvideo`;
379/*!40000 ALTER TABLE `viewedvideo` DISABLE KEYS */;
380INSERT INTO `viewedvideo` (`id`, `userId`, `videoId`, `watched`) VALUES
381 (1, 39, 1, 1);
382/*!40000 ALTER TABLE `viewedvideo` ENABLE KEYS */;
383/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
384/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
385/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;