Subversion Repositories bacoAlunos

DROP TABLE comunicationfolder;
CREATE TABLE comunicationfolder (
   id bigint NOT NULL AUTO_INCREMENT,
   discrimitator varchar(255) NOT NULL,
   updateDate datetime NOT NULL,
   saveDate datetime,
   name varchar(255),
   code varchar(255),
   targetRoles varchar(255),
   owner bigint,
   blog bigint,
   PRIMARY KEY (id),
   KEY `nameIndex` (`name`),
   KEY `codeIndex` (`code`),
   KEY `ownerIndex` (`owner`),
   KEY `targetRolesIndex` (`targetRoles`),
   CONSTRAINT `fkBlog` FOREIGN KEY (`blog`) REFERENCES `blog` (`id`),
   CONSTRAINT `fkOwner` FOREIGN KEY (`owner`) REFERENCES `user` (`id`)
 );