1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
| CREATE TABLE `user` (
`user_key` smallint NOT NULL AUTO_INCREMENT,
`sesa` int DEFAULT NULL,
`lastname` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`firstname` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`email` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
`company` varchar(50) COLLATE utf8_bin DEFAULT NULL,
`buunitname` varchar(50) COLLATE utf8_bin DEFAULT NULL,
`location` varchar(50) COLLATE utf8_bin DEFAULT NULL,
`manager_key` smallint DEFAULT NULL,
PRIMARY KEY (`user_key`),
UNIQUE KEY `sesa_UNIQUE` (`sesa`),
UNIQUE KEY `email_UNIQUE` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
CREATE TABLE `location` (
`location_key` smallint NOT NULL AUTO_INCREMENT,
`location` varchar(40) COLLATE utf8_bin NOT NULL DEFAULT '',
`country_key` smallint NOT NULL DEFAULT '2',
PRIMARY KEY (`location_key`),
UNIQUE KEY `uk_location` (`location`),
KEY `fk_country` (`country_key`),
CONSTRAINT `fk_country` FOREIGN KEY (`country_key`) REFERENCES `country` (`country_key`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
CREATE TABLE `country` (
`country_key` smallint NOT NULL AUTO_INCREMENT,
`country` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
`region` varchar(30) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (`country_key`),
UNIQUE KEY `uk_country` (`country`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; |
Partager