Subversion Repositories bacoAlunos

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