Subversion Repositories bacoAlunos

DROP TABLE IF EXISTS `digital_delivery_category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `digital_delivery_category` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `discrimitator` varchar(255) NOT NULL,
  `updateDate` datetime NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` text,
  `parent_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK9D6868294DEAB94` (`parent_id`),
  CONSTRAINT `FK9D6868294DEAB94` FOREIGN KEY (`parent_id`) REFERENCES `digital_delivery_category` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `digital_delivery_category`
--
DROP TABLE IF EXISTS `digital_delivery`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `digital_delivery` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `discrimitator` varchar(255) NOT NULL,
  `updateDate` datetime NOT NULL,
  `saveDate` datetime DEFAULT NULL,
  `openDate` datetime DEFAULT NULL,
  `closeDate` datetime DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `infoFileStream` varchar(255) DEFAULT NULL,
  `description` text,
  `targetReadersRole` varchar(255) DEFAULT NULL,
  `category` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FKD88FBA3B1C7AB7C2` (`category`),
  CONSTRAINT `FKD88FBA3B1C7AB7C2` FOREIGN KEY (`category`) REFERENCES `digital_delivery_category` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;


--
-- Table structure for table `digital_delivery_target`
--

DROP TABLE IF EXISTS `digital_delivery_target`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `digital_delivery_target` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `discrimitator` varchar(255) NOT NULL,
  `updateDate` datetime NOT NULL,
  `repositoryStream` varchar(255) DEFAULT NULL,
  `notesReader` text,
  `notesOwner` text,
  `checked` bit(1) DEFAULT NULL,
  `courseUnit` bigint(20) DEFAULT NULL,
  `owner` bigint(20) DEFAULT NULL,
  `digital_delivery_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK30FECC1568442945` (`digital_delivery_id`),
  KEY `FK30FECC1552876F6F` (`owner`),
  KEY `FK30FECC15DF034EA4` (`courseUnit`),
  CONSTRAINT `FK30FECC1552876F6F` FOREIGN KEY (`owner`) REFERENCES `user` (`id`),
  CONSTRAINT `FK30FECC1568442945` FOREIGN KEY (`digital_delivery_id`) REFERENCES `digital_delivery` (`id`),
  CONSTRAINT `FK30FECC15DF034EA4` FOREIGN KEY (`courseUnit`) REFERENCES `courseunit` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `digital_delivery_target`
--

--
-- Table structure for table `digital_delivery`
--


--
-- Dumping data for table `digital_delivery`
--