--
-- Host: 34.68.201.7    Database: lpa_santillana
-- ------------------------------------------------------


--
-- Table structure for table `contents`
--

CREATE TABLE `contents` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) DEFAULT NULL,
  `cover` varchar(450) DEFAULT NULL,
  `link` varchar(450) DEFAULT NULL,
  `creator_user_id` int(11) DEFAULT NULL,
  `modifier_user_id` int(11) DEFAULT NULL,
  `time_created` datetime DEFAULT CURRENT_TIMESTAMP,
  `time_updated` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `contents`
--

INSERT INTO `contents` VALUES (26,'EL LIBRO DE MATE 1','https://contents-lpa.jidadesarrollos.com/santillana/portadas/El_libro_de_mate_1.JPG','https://contents-lpa.jidadesarrollos.com/santillana/El_libro_de_Mate_1/index.html',NULL,NULL,'2022-12-19 02:11:27','2022-12-19 02:11:27'),(27,'EL LIBRO DE MATE 2','https://contents-lpa.jidadesarrollos.com/santillana/portadas/El_libro_de_mate_2.JPG','https://contents-lpa.jidadesarrollos.com/santillana/El_libro_de_Mate_2/index.html',NULL,NULL,'2022-12-19 02:11:28','2022-12-19 02:11:28'),(28,'EL LIBRO DE MATE 3','https://contents-lpa.jidadesarrollos.com/santillana/portadas/El_libro_de_mate_3.JPG','https://contents-lpa.jidadesarrollos.com/santillana/El_libro_de_Mate_3/index.html',NULL,NULL,'2022-12-19 02:11:28','2022-12-19 02:11:28'),(29,'EL LIBRO DE MATE 4','https://contents-lpa.jidadesarrollos.com/santillana/portadas/El_libro_de_mate_4.JPG','https://contents-lpa.jidadesarrollos.com/santillana/El_libro_de_Mate_4/index.html',NULL,NULL,'2022-12-19 02:11:28','2022-12-19 02:11:28'),(30,'EL LIBRO DE MATE 5','https://contents-lpa.jidadesarrollos.com/santillana/portadas/El_libro_de_mate_5.JPG','https://contents-lpa.jidadesarrollos.com/santillana/El_libro_de_Mate_5/index.html',NULL,NULL,'2022-12-19 02:11:29','2022-12-19 02:11:29'),(31,'EL LIBRO DE MATE 6','https://contents-lpa.jidadesarrollos.com/santillana/portadas/El_libro_de_mate_6.JPG','https://contents-lpa.jidadesarrollos.com/santillana/El_libro_de_Mate_6/index.html',NULL,NULL,'2022-12-19 02:11:29','2022-12-19 02:11:29'),(32,'EL LIBRO DE MATE 7-1','https://contents-lpa.jidadesarrollos.com/santillana/portadas/El_libro_de_mate_7-1.JPG','https://contents-lpa.jidadesarrollos.com/santillana/El_libro_de_Mate_7-1/index.html',NULL,NULL,'2022-12-19 02:11:29','2022-12-19 02:11:29'),(33,'CON TODOS LOS NÚMEROS I','https://contents-lpa.jidadesarrollos.com/santillana/portadas/Con_todos_los_numeros_I.JPG','https://contents-lpa.jidadesarrollos.com/santillana/Con_todos_los_nros_1/index.html',NULL,NULL,'2022-12-19 02:11:30','2022-12-19 02:11:30'),(34,'EL LIBRO DE 6. LENGUA-PRÁCTICAS DEL LENGUAJE','https://contents-lpa.jidadesarrollos.com/santillana/portadas/el_libro_de_lengua_6.JPG','https://contents-lpa.jidadesarrollos.com/santillana/El_libro_de_6_Lengua/index.html',NULL,NULL,'2022-12-19 02:11:30','2022-12-19 02:11:30'),(35,'EL LIBRO DE 1. LENGUA-PRÁCTICAS DEL LENGUAJE','https://contents-lpa.jidadesarrollos.com/santillana/portadas/el_libro_de_lengua_1.JPG','https://contents-lpa.jidadesarrollos.com/santillana/El_libro_de_1_Lengua/index.html',NULL,NULL,'2022-12-19 02:11:30','2022-12-19 02:11:30'),(36,'LENGUA 4-VA CON VOS','https://contents-lpa.jidadesarrollos.com/santillana/portadas/Lengua_4_Va_con_Vos.JPG','https://contents-lpa.jidadesarrollos.com/santillana/Lengua_4_Va_con_vos/index.html',NULL,NULL,'2022-12-19 02:11:30','2022-12-19 02:11:30'),(37,'EL LIBRO DE 4. LENGUA-PRÁCTICAS DEL LENGUAJE','https://contents-lpa.jidadesarrollos.com/santillana/portadas/el_libro_de_lengua_4.JPG','https://contents-lpa.jidadesarrollos.com/santillana/El_libro_de_4_Lengua/index.html',NULL,NULL,'2022-12-19 02:11:31','2022-12-19 02:11:31'),(38,'EL LIBRO DE 5. LENGUA-PRÁCTICAS DEL LENGUAJE','https://contents-lpa.jidadesarrollos.com/santillana/portadas/el_libro_de_lengua_5.JPG','https://contents-lpa.jidadesarrollos.com/santillana/El_libro_de_5_Lengua/index.html',NULL,NULL,'2022-12-19 02:11:31','2022-12-19 02:11:31');

--
-- Table structure for table `contents_levels_jurisdictions`
--

CREATE TABLE `contents_levels_jurisdictions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content_id` int(11) DEFAULT NULL,
  `level_id` int(11) DEFAULT NULL,
  `jurisdiction_id` int(11) DEFAULT NULL,
  `creator_user_id` int(11) DEFAULT NULL,
  `modifier_user_id` int(11) DEFAULT NULL,
  `time_created` datetime DEFAULT CURRENT_TIMESTAMP,
  `time_updated` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=163 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `contents_levels_jurisdictions`
--

INSERT INTO `contents_levels_jurisdictions` VALUES (83,26,2,34,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(84,27,2,34,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(85,28,2,34,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(86,30,2,34,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(87,31,2,34,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(88,26,2,35,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(89,27,2,35,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(90,28,2,35,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(91,33,2,35,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(92,26,2,36,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(93,28,2,36,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(94,29,2,36,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(95,28,2,37,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(96,27,2,38,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(97,28,2,38,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(98,30,2,38,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(99,31,2,38,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(100,26,2,39,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(101,27,2,39,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(102,28,2,39,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(103,26,2,40,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(104,28,2,40,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(105,29,2,40,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(106,30,2,40,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(107,31,2,40,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(108,32,2,41,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(109,26,2,42,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(110,29,2,42,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(111,30,2,42,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(112,31,2,42,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(113,28,2,43,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(114,26,2,44,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(115,28,2,44,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(116,30,2,44,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(117,31,2,44,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(118,32,2,44,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(119,28,2,45,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(120,26,2,46,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(121,29,2,46,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(122,31,2,46,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(123,27,2,47,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(124,30,2,47,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(125,31,2,47,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(126,32,2,47,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(127,26,2,48,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(128,32,2,48,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(129,26,2,49,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(130,34,2,44,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(131,35,2,48,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(132,36,2,48,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(133,34,2,48,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(134,37,2,49,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(135,38,2,49,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(136,34,2,49,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(137,26,2,51,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(138,27,2,51,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(139,28,2,51,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(140,29,2,51,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(141,30,2,51,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(142,31,2,51,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(143,32,2,51,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(144,35,2,51,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(145,37,2,51,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(146,38,2,51,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(147,34,2,51,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(148,36,2,51,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(149,33,2,51,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(150,26,2,52,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(151,27,2,52,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(152,28,2,52,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(153,29,2,52,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(154,30,2,52,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(155,31,2,52,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(156,32,2,52,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(157,35,2,52,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(158,37,2,52,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(159,38,2,52,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(160,34,2,52,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(161,36,2,52,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58'),(162,33,2,52,NULL,NULL,'2022-12-19 02:34:58','2022-12-19 02:34:58');

--
-- Table structure for table `jurisdictions`
--

CREATE TABLE `jurisdictions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(450) DEFAULT NULL,
  `identifier` varchar(45) DEFAULT NULL,
  `creator_user_id` int(11) DEFAULT NULL,
  `modifier_user_id` int(11) DEFAULT NULL,
  `time_created` datetime DEFAULT CURRENT_TIMESTAMP,
  `time_updated` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jurisdictions`
--

INSERT INTO `jurisdictions` VALUES (34,'BUENOS AIRES',NULL,NULL,NULL,'2022-12-16 17:20:28','2022-12-16 17:20:28'),(35,'CHACO',NULL,NULL,NULL,'2022-12-16 17:20:28','2022-12-16 17:20:28'),(36,'CHUBUT',NULL,NULL,NULL,'2022-12-16 17:20:28','2022-12-16 17:20:28'),(37,'CIUDAD AUTÓNOMA DE BUENOS AIRES',NULL,NULL,NULL,'2022-12-16 17:20:29','2022-12-16 17:20:29'),(38,'CÓRDOBA',NULL,NULL,NULL,'2022-12-16 17:20:29','2022-12-16 17:20:29'),(39,'CORRIENTES',NULL,NULL,NULL,'2022-12-16 17:20:29','2022-12-16 17:20:29'),(40,'ENTRE RÍOS',NULL,NULL,NULL,'2022-12-16 17:20:29','2022-12-16 17:20:29'),(41,'JUJUY',NULL,NULL,NULL,'2022-12-16 17:20:30','2022-12-16 17:20:30'),(42,'LA PAMPA',NULL,NULL,NULL,'2022-12-16 17:20:30','2022-12-16 17:20:30'),(43,'LA RIOJA',NULL,NULL,NULL,'2022-12-16 17:20:30','2022-12-16 17:20:30'),(44,'MISIONES',NULL,NULL,NULL,'2022-12-16 17:20:31','2022-12-16 17:20:31'),(45,'NEUQUÉN',NULL,NULL,NULL,'2022-12-16 17:20:31','2022-12-16 17:20:31'),(46,'RÍO NEGRO',NULL,NULL,NULL,'2022-12-16 17:20:31','2022-12-16 17:20:31'),(47,'SALTA',NULL,NULL,NULL,'2022-12-16 17:20:31','2022-12-16 17:20:31'),(48,'SANTA FE',NULL,NULL,NULL,'2022-12-16 17:20:32','2022-12-16 17:20:32'),(49,'TIERRA DEL FUEGO, ANTÁRTIDA E ISLAS DEL ATLÁNTICO SUR',NULL,NULL,NULL,'2022-12-16 17:20:32','2022-12-16 17:20:32'),(51,'MINISTERIO',NULL,NULL,NULL,'2022-12-16 17:20:33','2022-12-16 17:20:33'),(52,'NACIÓN',NULL,NULL,NULL,'2022-12-16 17:20:33','2022-12-16 17:20:33');

--
-- Table structure for table `levels`
--

CREATE TABLE `levels` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) DEFAULT NULL,
  `identifier` varchar(45) DEFAULT NULL,
  `creator_user_id` int(11) DEFAULT NULL,
  `modifier_user_id` int(11) DEFAULT NULL,
  `time_created` datetime DEFAULT CURRENT_TIMESTAMP,
  `time_updated` datetime DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `levels`
--

INSERT INTO `levels` VALUES (2,'PRIMARIA',NULL,NULL,NULL,'2022-12-16 19:05:53','2022-12-16 19:05:53'),(3,'SECUNDARIA',NULL,NULL,NULL,'2022-12-16 19:05:54','2022-12-16 19:05:54');

--
-- Table structure for table `profiles`
--

CREATE TABLE `profiles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `profile` varchar(50) DEFAULT NULL,
  `created_date` datetime DEFAULT NULL,
  `identificador` varchar(60) DEFAULT NULL,
  `creator_user_id` int(11) DEFAULT NULL,
  `modifier_user_id` int(11) DEFAULT NULL,
  `time_created` datetime DEFAULT NULL,
  `time_updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `profiles`
--


--
-- Table structure for table `status`
--

CREATE TABLE `status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `status` varchar(45) DEFAULT NULL,
  `identifier` varchar(45) DEFAULT NULL,
  `creator_user_id` int(11) DEFAULT NULL,
  `modifier_user_id` int(11) DEFAULT NULL,
  `time_created` datetime DEFAULT NULL,
  `time_updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `status`
--

INSERT INTO `status` VALUES (5,'activo',NULL,NULL,NULL,NULL,NULL),(6,'inactivo',NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `users_code_values`
--

CREATE TABLE `users_code_values` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `user_value` varchar(45) DEFAULT NULL,
  `type_register` varchar(45) DEFAULT NULL,
  `status` varchar(45) DEFAULT NULL,
  `code` varchar(45) DEFAULT NULL,
  `time_created` datetime DEFAULT NULL,
  `time_updated` datetime DEFAULT NULL,
  `creator_user_id` int(11) DEFAULT NULL,
  `modifier_user_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `users_code_values`
--


--
-- Table structure for table `users_configurations`
--

CREATE TABLE `users_configurations` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `configuration` text,
  `creator_user_id` int(11) DEFAULT NULL,
  `modifier_user_id` int(11) DEFAULT NULL,
  `time_created` datetime DEFAULT NULL,
  `time_updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users_configurations`
--


--
-- Table structure for table `users_profiles`
--

CREATE TABLE `users_profiles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `profile_id` int(11) DEFAULT NULL,
  `creator_user_id` int(11) DEFAULT NULL,
  `modifier_user_id` int(11) DEFAULT NULL,
  `time_created` datetime DEFAULT NULL,
  `time_updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_profiles_users_profiles_idx` (`profile_id`),
  KEY `fk_users_users_profiles_idx` (`user_id`),
  CONSTRAINT `fk_profiles_users_profiles` FOREIGN KEY (`profile_id`) REFERENCES `profiles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_users_users_profiles` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `users_profiles`
--


--
-- Dumping routines for database 'lpa_santillana'
--


