11 lines
547 B
SQL
Executable File
11 lines
547 B
SQL
Executable File
CREATE TABLE IF NOT EXISTS `Keyword_Keyword` (
|
|
`Keyword_id` bigint(20) NOT NULL,
|
|
`associatedKeywords_id` bigint(20) NOT NULL,
|
|
PRIMARY KEY (`Keyword_id`,`associatedKeywords_id`),
|
|
KEY `FKC121395398ED461` (`Keyword_id`),
|
|
KEY `FKC121395356E25A3A` (`associatedKeywords_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
|
|
|
ALTER TABLE `Keyword_Keyword`
|
|
ADD CONSTRAINT `FKC121395356E25A3A` FOREIGN KEY (`associatedKeywords_id`) REFERENCES `Keyword` (`id`),
|
|
ADD CONSTRAINT `FKC121395398ED461` FOREIGN KEY (`Keyword_id`) REFERENCES `Keyword` (`id`); |