• Home
• io.github.oewntk
• tosql
• 2.1.2
• source code
• lexrelations-reference.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

wn.sqltemplates.mysql.reference.lexrelations-reference.sql Maven / Gradle / Ivy

ALTER TABLE ${lexrelations.table} ADD CONSTRAINT `fk_@{lexrelations.table}_@{lexrelations.synset1id}`  FOREIGN KEY (${lexrelations.synset1id})  REFERENCES ${synsets.table}  (${synsets.synsetid});
ALTER TABLE ${lexrelations.table} ADD CONSTRAINT `fk_@{lexrelations.table}_@{lexrelations.synset2id}`  FOREIGN KEY (${lexrelations.synset2id})  REFERENCES ${synsets.table}  (${synsets.synsetid});
ALTER TABLE ${lexrelations.table} ADD CONSTRAINT `fk_@{lexrelations.table}_@{lexrelations.relationid}` FOREIGN KEY (${lexrelations.relationid}) REFERENCES ${relations.table}(${relations.relationid});
ALTER TABLE ${lexrelations.table} ADD CONSTRAINT `fk_@{lexrelations.table}_@{lexrelations.lu1id}`      FOREIGN KEY (${lexrelations.lu1id})      REFERENCES ${lexes.table}    (${lexes.luid});
ALTER TABLE ${lexrelations.table} ADD CONSTRAINT `fk_@{lexrelations.table}_@{lexrelations.lu2id}`      FOREIGN KEY (${lexrelations.lu2id})      REFERENCES ${lexes.table}    (${lexes.luid});
ALTER TABLE ${lexrelations.table} ADD CONSTRAINT `fk_@{lexrelations.table}_@{lexrelations.word1id}`    FOREIGN KEY (${lexrelations.word1id})    REFERENCES ${words.table}    (${words.wordid});
ALTER TABLE ${lexrelations.table} ADD CONSTRAINT `fk_@{lexrelations.table}_@{lexrelations.word2id}`    FOREIGN KEY (${lexrelations.word2id})    REFERENCES ${words.table}    (${words.wordid});