Rev 726 |
Go to most recent revision |
Blame |
Compare with Previous |
Last modification |
View Log
| RSS feed
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`)
);