Subversion Repositories bacoAlunos

DROP TABLE IF EXISTS `sru_source`;
CREATE TABLE `sru_source` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `discrimitator` varchar(255) NOT NULL,
  `updateDate` datetime NOT NULL,
  `saveDate` datetime DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `collection_field` varchar(255) DEFAULT NULL,
  `description` text,
  `url` varchar(255) DEFAULT NULL,
  `metadata_schema` varchar(255) DEFAULT NULL,
  `creator` bigint(20) DEFAULT NULL,
  PRIMARY KEY  (`id`),
  KEY `creatorFK` (`creator`),
  CONSTRAINT `creatorFK` FOREIGN KEY (`creator`) REFERENCES `user` (`id`)
) ENGINE=Innodb DEFAULT CHARSET=latin1;

DROP TABLE IF EXISTS `sru_source_collection`;
CREATE TABLE `sru_source_collection` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `discrimitator` varchar(255) NOT NULL,
  `updateDate` datetime NOT NULL,
  `saveDate` datetime DEFAULT NULL,
  `collection` varchar(255) DEFAULT NULL,
  `admited_roles` varchar(255) DEFAULT NULL,
  `sru_source_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY  (`id`),
  KEY `sru_sourceFK` (`sru_source_id`),
  CONSTRAINT `sru_sourceFK` FOREIGN KEY (`sru_source_id`) REFERENCES `sru_source` (`id`)
) ENGINE=Innodb DEFAULT CHARSET=latin1;