• Home
• io.github.oewntk
• tosql
• 2.1.2
• source code
• senses-index.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.index.senses-index.sql Maven / Gradle / Ivy

ALTER TABLE ${senses.table} ADD CONSTRAINT `pk_@{senses.table}`                                   PRIMARY KEY (${senses.senseid});
ALTER TABLE ${senses.table} ADD CONSTRAINT `uk_@{senses.table}_@{senses.sensekey}`                UNIQUE KEY  (${senses.sensekey});
ALTER TABLE ${senses.table} ADD CONSTRAINT `uk_@{senses.table}_@{senses.luid}_@{senses.sensekey}` UNIQUE KEY  (${senses.luid},${senses.sensekey});
ALTER TABLE ${senses.table} ADD CONSTRAINT `uk_@{senses.table}_@{senses.luid}_@{senses.synsetid}` UNIQUE KEY  (${senses.luid},${senses.synsetid});
ALTER TABLE ${senses.table} ADD KEY        `k_@{senses.table}_@{senses.luid}`                                 (${senses.luid});
ALTER TABLE ${senses.table} ADD KEY        `k_@{senses.table}_@{senses.wordid}`                               (${senses.wordid});
ALTER TABLE ${senses.table} ADD KEY        `k_@{senses.table}_@{senses.casedwordid}`                          (${senses.casedwordid});
ALTER TABLE ${senses.table} ADD KEY        `k_@{senses.table}_@{senses.synsetid}`                             (${senses.synsetid});