New file |
0,0 → 1,113 |
CREATE DATABASE IF NOT EXISTS `pae` /*!40100 DEFAULT CHARACTER SET latin1 */; |
USE `pae`; |
-- MySQL dump 10.13 Distrib 5.6.13, for osx10.6 (i386) |
-- |
-- Host: localhost Database: pae |
-- ------------------------------------------------------ |
-- Server version 5.1.73 |
|
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; |
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; |
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; |
/*!40101 SET NAMES utf8 */; |
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; |
/*!40103 SET TIME_ZONE='+00:00' */; |
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; |
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; |
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; |
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; |
|
-- |
-- Table structure for table `course_department` |
-- |
|
DROP TABLE IF EXISTS `course_department`; |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
/*!40101 SET character_set_client = utf8 */; |
CREATE TABLE `course_department` ( |
`sigla` varchar(20) NOT NULL, |
`discrimitator` varchar(255) NOT NULL, |
`updateDate` datetime NOT NULL, |
`saveDate` datetime DEFAULT NULL, |
`institutionalCode` varchar(255) DEFAULT NULL, |
`active` bit(1) DEFAULT b'1', |
`name` varchar(255) DEFAULT NULL, |
`nameEn` varchar(255) DEFAULT NULL, |
`nameEs` varchar(255) DEFAULT NULL, |
`nameFr` varchar(255) DEFAULT NULL, |
`directorRole` varchar(255) DEFAULT NULL, |
`boardRole` varchar(255) DEFAULT NULL, |
`school_id` bigint(20) DEFAULT NULL, |
PRIMARY KEY (`sigla`), |
KEY `FK475A29F6A3AE51FB` (`school_id`), |
KEY `FK475A29F6AA0C05BB` (`school_id`), |
CONSTRAINT `FK475A29F6A3AE51FB` FOREIGN KEY (`school_id`) REFERENCES `course_school` (`id`), |
CONSTRAINT `FK475A29F6AA0C05BB` FOREIGN KEY (`school_id`) REFERENCES `course_school` (`id`) |
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
-- |
-- Dumping data for table `course_department` |
-- |
|
LOCK TABLES `course_department` WRITE; |
/*!40000 ALTER TABLE `course_department` DISABLE KEYS */; |
INSERT INTO `course_department` VALUES ('arn','CourseDepartmentImpl','2017-06-23 08:43:01','2016-09-23 09:26:32','2','','Ciências Agrárias e Veterinárias','Ciencias Agrarias y Veterinarias','Ciencias Agrarias y Veterinarias','Sciences agricoles et vétérinaires','department.diretor.cien.agr.vet','department.board.cien.agr.vet',2),('cat','CourseDepartmentImpl','2017-03-29 19:49:15','2016-09-23 09:26:32','3','','Comunicação, Artes e Tecnologias','Comunicación, Artes y Tecnologías','Comunicación, Artes y Tecnologías','Communication, Arts et Technologies','department.diretor.comun.artes.tecn','department.board.comun.artes.tecn',3),('cesh','CourseDepartmentImpl','2017-03-24 10:37:10','2016-09-23 09:26:32','1','','Ciências Empresariais, Sociais e Humanas','Ciencias empresariales, Social y Humano','Ciencias empresariales, Social y Humano','Entreprise Sciences, Sciences sociales et humaines','department.diretor.cienc.empre.sh','department.board.cienc.empre.sh',1),('clc','CourseDepartmentImpl','2017-07-11 16:11:51','2017-07-11 15:59:58',NULL,'','Ciências da Linguagem e da Comunicação',NULL,NULL,NULL,'department.diretor.clc','department.board.clc',3),('cta','CourseDepartmentImpl','2017-06-23 08:36:55','2016-09-23 09:26:32','2','\0','Ciência e Tecnologia Animal','Ciencia y Tecnología Animal','Ciencia y Tecnología Animal','Animal Science et technologie','department.diretor.cienc.tecnol.ani','department.board.cienc.tecnol.ani',2),('cts','CourseDepartmentImpl','2017-03-24 10:37:13','2016-09-23 09:26:32','4','','Ciências e Tecnologias da Saúde','Ciencia y Salud Tecnologías','Ciencia y Salud Tecnologías','Sciences et technologies de la santé','department.diretor.cienc.tec.saude','department.board.cienc.tec.saude',4),('ef','CourseDepartmentImpl','2017-03-24 10:37:14','2016-09-23 09:26:32','3','','Educação e Formação','Educación y formación','Educación y formación','Éducation et formation','department.diretor.educac.formac','department.board.educac.formac',3),('ids','CourseDepartmentImpl','2017-03-24 10:37:15','2016-09-23 09:26:32','3','','Intervenção e Desenvolvimento Social','Intervención y Desarrollo Social','Intervención y Desarrollo Social','Intervention et du Développement social','department.diretor.inter.des.soc','department.board.inter.des.soc',3),('td','CourseDepartmentImpl','2017-05-30 11:20:17','2016-09-23 09:26:32','1','','Tecnologias','Tecnología y Diseño','Tecnología y Diseño','Technologie et Design','department.diretor.tecnolo.design','department.board.tecnolo.design',1); |
/*!40000 ALTER TABLE `course_department` ENABLE KEYS */; |
UNLOCK TABLES; |
|
-- |
-- Table structure for table `course_school` |
-- |
|
DROP TABLE IF EXISTS `course_school`; |
/*!40101 SET @saved_cs_client = @@character_set_client */; |
/*!40101 SET character_set_client = utf8 */; |
CREATE TABLE `course_school` ( |
`id` bigint(20) NOT NULL AUTO_INCREMENT, |
`discrimitator` varchar(255) NOT NULL, |
`updateDate` datetime NOT NULL, |
`saveDate` datetime DEFAULT NULL, |
`institutionalCode` varchar(255) DEFAULT NULL, |
`active` bit(1) DEFAULT b'1', |
`name` varchar(255) DEFAULT NULL, |
`nameEn` varchar(255) DEFAULT NULL, |
`nameEs` varchar(255) DEFAULT NULL, |
`nameFr` varchar(255) DEFAULT NULL, |
`schoolDirectorRole` varchar(255) DEFAULT NULL, |
`schoolBoardRole` varchar(255) DEFAULT NULL, |
`schoolSecretariadoRole` varchar(255) DEFAULT NULL, |
`ctcPresidentRole` varchar(255) DEFAULT NULL, |
`ctcMemberRole` varchar(255) DEFAULT NULL, |
`ctcSecretariadoRole` varchar(255) DEFAULT NULL, |
`pedagogicoPresidentRole` varchar(255) DEFAULT NULL, |
`pedagogicoMemberRole` varchar(255) DEFAULT NULL, |
`pedagogicoSecretariadoRole` varchar(255) DEFAULT NULL, |
`initials` varchar(255) DEFAULT NULL, |
`funcionarioRole` varchar(255) DEFAULT NULL, |
`studentRole` varchar(255) DEFAULT NULL, |
`teacherRole` varchar(255) DEFAULT NULL, |
PRIMARY KEY (`id`) |
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1; |
/*!40101 SET character_set_client = @saved_cs_client */; |
|
-- |
-- Dumping data for table `course_school` |
-- |
|
LOCK TABLES `course_school` WRITE; |
/*!40000 ALTER TABLE `course_school` DISABLE KEYS */; |
INSERT INTO `course_school` VALUES (1,'CourseSchoolImpl','2017-05-04 08:08:07','2017-03-24 10:33:00','1','','Escola Superior de Tecnologia e Gestão',NULL,NULL,NULL,'school.president.estg','school.board.estg','school.secretariado.estg','scientificCouncil.president.estg','scientificCouncil.board.estg','scientificCouncil.secretariado.estg','pedagogicCouncil.president.estg','pedagogicCouncil.board.estg','pedagogicCouncil.secretariado.estg','ESTG',NULL,NULL,NULL),(2,'CourseSchoolImpl','2017-05-04 08:08:06','2017-03-24 10:33:02','2','','Escola Superior Agrária de Elvas',NULL,NULL,NULL,'school.president.asae','school.board.esae','school.secretariado.esae','scientificCouncil.president.esae','scientificCouncil.board.esae','scientificCouncil.secretariado.esae','pedagogicCouncil.president.esae','pedagogicCouncil.board.esae','pedagogicCouncil.secretariado.esae','ESAE',NULL,NULL,NULL),(3,'CourseSchoolImpl','2017-05-04 08:08:05','2017-03-24 10:33:02','3','','Escola Superior de Educação e Ciências Sociais',NULL,NULL,NULL,'school.president.esecs','school.board.esecs','school.secretariado.esecs','scientificCouncil.president.esecs','scientificCouncil.board.esecs','scientificCouncil.secretariado.esecs','pedagogicCouncil.president.esecs','pedagogicCouncil.board.esecs','pedagogicCouncil.secretariado.esecs','ESECS',NULL,NULL,NULL),(4,'CourseSchoolImpl','2017-05-04 08:08:04','2017-03-24 10:33:04','4','','Escola Superior de Saúde',NULL,NULL,NULL,'school.president.ess','school.board.ess','school.secretariado.ess','scientificCouncil.president.ess','scientificCouncil.board.ess','scientificCouncil.secretariado.ess','pedagogicCouncil.president.ess','pedagogicCouncil.board.ess','pedagogicCouncil.secretariado.ess','ESS',NULL,NULL,NULL); |
/*!40000 ALTER TABLE `course_school` ENABLE KEYS */; |
UNLOCK TABLES; |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; |
|
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; |
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; |
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; |
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; |
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
|
-- Dump completed on 2017-11-09 11:22:55 |