1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
|
CREATE TABLE `safe`.`utilisateur` (
`UID` varchar(32) NOT NULL,
`Password` varchar(32) DEFAULT NULL,
`Nom` varchar(80) DEFAULT NULL,
`Telephone` varchar(30) DEFAULT NULL,
`Fax` varchar(30) DEFAULT NULL,
`Email` varchar(80) DEFAULT NULL,
PRIMARY KEY (`UID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `safe`.`role` (
`UID` varchar(32) CHARACTER SET latin1 DEFAULT NULL,
`Role` varchar(32) CHARACTER SET latin1 DEFAULT NULL,
KEY `FK_role_1` (`UID`),
CONSTRAINT `FK_role_1` FOREIGN KEY (`UID`) REFERENCES `utilisateur` (`UID`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
Partager