[6ff7b6]: wordnet / src / main / resources / org / wnsql / builder / wordnet / mysql.properties  Maximize  Restore  History

Download this file

251 lines (231 with data), 26.7 kB

  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
 33
 34
 35
 36
 37
 38
 39
 40
 41
 42
 43
 44
 45
 46
 47
 48
 49
 50
 51
 52
 53
 54
 55
 56
 57
 58
 59
 60
 61
 62
 63
 64
 65
 66
 67
 68
 69
 70
 71
 72
 73
 74
 75
 76
 77
 78
 79
 80
 81
 82
 83
 84
 85
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
Word.table=words
Word.create=CREATE TABLE IF NOT EXISTS %Word.table% (wordid INTEGER UNSIGNED NOT NULL DEFAULT '0',lemma VARCHAR (80) NOT NULL,PRIMARY KEY (wordid)) DEFAULT CHARSET=utf8;
Word.pk=ALTER TABLE %Word.table% ADD CONSTRAINT pk_%Word.table% PRIMARY KEY (wordid);
Word.no-pk=ALTER TABLE %Word.table% DROP PRIMARY KEY;
Word.unq=ALTER TABLE %Word.table% ADD CONSTRAINT unq_%Word.table%_lemma UNIQUE KEY (lemma);
Word.no-unq=ALTER TABLE %Word.table% DROP INDEX unq_%Word.table%_lemma;
Word.insert=INSERT INTO %Word.table% (wordid,lemma) VALUES (?,?);
Word.select=SELECT wordid FROM %Word.table% WHERE lemma = ?;
CasedWord.table=casedwords
CasedWord.create=CREATE TABLE IF NOT EXISTS %CasedWord.table% (casedwordid INTEGER UNSIGNED NOT NULL DEFAULT '0',wordid INTEGER UNSIGNED NOT NULL DEFAULT '0',cased VARCHAR (80) BINARY COLLATE utf8_bin NOT NULL,PRIMARY KEY (casedwordid)) DEFAULT CHARSET=utf8;
CasedWord.pk=ALTER TABLE %CasedWord.table% ADD CONSTRAINT pk_%CasedWord.table% PRIMARY KEY (casedwordid);
CasedWord.no-pk=ALTER TABLE %CasedWord.table% DROP PRIMARY KEY;
CasedWord.unq=ALTER TABLE %CasedWord.table% ADD CONSTRAINT unq_%CasedWord.table%_cased UNIQUE KEY (cased);
CasedWord.no-unq=ALTER TABLE %CasedWord.table% DROP INDEX unq_%CasedWord.table%_cased;
CasedWord.index=ALTER TABLE %CasedWord.table% ADD INDEX k_%CasedWord.table%_wordid (wordid);
CasedWord.no-index=ALTER TABLE %CasedWord.table% DROP INDEX k_%CasedWord.table%_wordid;
CasedWord.fk=ALTER TABLE %CasedWord.table% ADD CONSTRAINT fk_%CasedWord.table%_wordid FOREIGN KEY k_%CasedWord.table%_wordid (wordid) REFERENCES %Word.table% (wordid);
CasedWord.no-fk=ALTER TABLE %CasedWord.table% DROP FOREIGN KEY fk_%CasedWord.table%_wordid;
CasedWord.insert=INSERT INTO %CasedWord.table% (casedwordid,wordid,cased) VALUES (?,?,?);
CasedWord.select=SELECT casedwordid FROM %CasedWord.table% WHERE cased = ?;
Sense.table=senses
Sense.create=CREATE TABLE IF NOT EXISTS %Sense.table% (wordid INTEGER UNSIGNED NOT NULL DEFAULT '0',casedwordid INTEGER UNSIGNED,synsetid INTEGER UNSIGNED NOT NULL DEFAULT '0',senseid INTEGER UNSIGNED NULL,sensenum SMALLINT UNSIGNED NOT NULL DEFAULT '0',lexid SMALLINT UNSIGNED NOT NULL DEFAULT '0',tagcount INTEGER UNSIGNED NULL,sensekey VARCHAR (100) DEFAULT NULL,PRIMARY KEY (wordid,synsetid)) DEFAULT CHARSET=utf8;
Sense.pk=ALTER TABLE %Sense.table% ADD CONSTRAINT pk_%Sense.table% PRIMARY KEY (wordid,synsetid);
Sense.no-pk=ALTER TABLE %Sense.table% DROP PRIMARY KEY;
Sense.unq1=ALTER TABLE %Sense.table% ADD CONSTRAINT unq_%Sense.table%_senseid UNIQUE KEY (senseid);
Sense.no-unq1=ALTER TABLE %Sense.table% DROP INDEX unq_%Sense.table%_senseid;
Sense.unq2=ALTER TABLE %Sense.table% ADD CONSTRAINT unq_%Sense.table%_sensekey UNIQUE KEY (sensekey);
Sense.no-unq2=ALTER TABLE %Sense.table% DROP INDEX unq_%Sense.table%_sensekey;
Sense.index1=ALTER TABLE %Sense.table% ADD INDEX k_%Sense.table%_wordid (wordid);
Sense.no-index1=ALTER TABLE %Sense.table% DROP INDEX k_%Sense.table%_wordid;
Sense.index2=ALTER TABLE %Sense.table% ADD INDEX k_%Sense.table%_synsetid (synsetid);
Sense.no-index2=ALTER TABLE %Sense.table% DROP INDEX k_%Sense.table%_synsetid;
Sense.index3=ALTER TABLE %Sense.table% ADD INDEX k_%Sense.table%_lexid (lexid);
Sense.no-index3=ALTER TABLE %Sense.table% DROP INDEX k_%Sense.table%_lexid;
Sense.fk1=ALTER TABLE %Sense.table% ADD CONSTRAINT fk_%Sense.table%_wordid FOREIGN KEY k_%Sense.table%_wordid (wordid) REFERENCES %Word.table% (wordid);
Sense.no-fk1=ALTER TABLE %Sense.table% DROP FOREIGN KEY fk_%Sense.table%_wordid;
Sense.fk2=ALTER TABLE %Sense.table% ADD CONSTRAINT fk_%Sense.table%_synsetid FOREIGN KEY k_%Sense.table%_synsetid (synsetid) REFERENCES %Synset.table% (synsetid);
Sense.no-fk2=ALTER TABLE %Sense.table% DROP FOREIGN KEY fk_%Sense.table%_synsetid;
Sense.insert=INSERT INTO %Sense.table% (wordid,synsetid,sensenum) VALUES (?,?,?);
Sense.update=UPDATE %Sense.table% SET senseid = ?,sensekey = ?,lexid = ?,tagcount = ? WHERE wordid = ? AND synsetid = ?;
Sense.case.update=UPDATE %Sense.table% SET casedwordid = ? WHERE synsetid = ? AND wordid = ?;
Sense.select=SELECT %Sense.table%.synsetid FROM %Word.table% INNER JOIN %Sense.table% USING (wordid) INNER JOIN %Synset.table% USING (synsetid) WHERE %Word.table%.lemma = ? AND %Sense.table%.lexid = ? AND %Synset.table%.lexdomainid = ?;
Synset.table=synsets
Synset.create=CREATE TABLE IF NOT EXISTS %Synset.table% (synsetid INTEGER UNSIGNED NOT NULL DEFAULT '0',pos ENUM ('n','v','a','r','s') NOT NULL,lexdomainid SMALLINT UNSIGNED NOT NULL DEFAULT '0',definition MEDIUMTEXT,PRIMARY KEY (synsetid)) DEFAULT CHARSET=utf8;
Synset.pk=ALTER TABLE %Synset.table% ADD CONSTRAINT pk_%Synset.table% PRIMARY KEY (synsetid);
Synset.no-pk=ALTER TABLE %Synset.table% DROP PRIMARY KEY;
Synset.index=ALTER TABLE %Synset.table% ADD INDEX k_%Synset.table%_lexdomainid (lexdomainid);
Synset.no-index=ALTER TABLE %Synset.table% DROP INDEX k_%Synset.table%_lexdomainid;
Synset.fk=ALTER TABLE %Synset.table% ADD CONSTRAINT fk_%Synset.table%_lexdomainid FOREIGN KEY k_%Synset.table%_lexdomainid (lexdomainid) REFERENCES %LexDomain.table% (lexdomainid);
Synset.no-fk=ALTER TABLE %Synset.table% DROP FOREIGN KEY fk_%Synset.table%_lexdomainid;
Synset.insert=INSERT INTO %Synset.table% (synsetid,pos,lexdomainid,definition) VALUES (?,?,?,?);
Synset.select=SELECT * FROM %Synset.table% WHERE synsetid = ?;
Synset.definition.select=SELECT definition FROM %Synset.table% WHERE synsetid = ?;
PosType.table=postypes
PosType.create=CREATE TABLE IF NOT EXISTS %PosType.table% (pos ENUM ('n','v','a','r','s') NOT NULL,posname VARCHAR (20) NOT NULL,PRIMARY KEY (pos)) DEFAULT CHARSET=utf8;
PosType.pk=ALTER TABLE %PosType.table% ADD CONSTRAINT pk_%PosType.table% PRIMARY KEY (pos);
PosType.no-pk=ALTER TABLE %PosType.table% DROP PRIMARY KEY;
PosType.insert=INSERT INTO %PosType.table% (pos,posname) VALUES (?,?);
LexDomain.table=lexdomains
LexDomain.create=CREATE TABLE IF NOT EXISTS %LexDomain.table% (lexdomainid SMALLINT UNSIGNED NOT NULL DEFAULT '0',lexdomainname VARCHAR (32) DEFAULT NULL,lexdomain VARCHAR (32) DEFAULT NULL,pos ENUM ('n','v','a','r','s') DEFAULT NULL,PRIMARY KEY (lexdomainid)) DEFAULT CHARSET=utf8;
LexDomain.pk=ALTER TABLE %LexDomain.table% ADD CONSTRAINT pk_%LexDomain.table% PRIMARY KEY (lexdomainid);
LexDomain.no-pk=ALTER TABLE %LexDomain.table% DROP PRIMARY KEY;
LexDomain.insert=INSERT INTO %LexDomain.table% (lexdomainid,lexdomainname,lexdomain,pos) VALUES (?,?,?,?);
Sample.table=samples
Sample.create=CREATE TABLE IF NOT EXISTS %Sample.table% (synsetid INTEGER UNSIGNED NOT NULL DEFAULT '0',sampleid SMALLINT UNSIGNED NOT NULL DEFAULT '0',sample MEDIUMTEXT NOT NULL,PRIMARY KEY (synsetid,sampleid)) DEFAULT CHARSET=utf8;
Sample.pk=ALTER TABLE %Sample.table% ADD CONSTRAINT pk_%Sample.table% PRIMARY KEY (synsetid,sampleid);
Sample.no-pk=ALTER TABLE %Sample.table% DROP PRIMARY KEY;
Sample.index=ALTER TABLE %Sample.table% ADD INDEX k_%Sample.table%_synsetid (synsetid);
Sample.no-index=ALTER TABLE %Sample.table% DROP INDEX k_%Sample.table%_synsetid;
Sample.fk=ALTER TABLE %Sample.table% ADD CONSTRAINT fk_%Sample.table%_synsetid FOREIGN KEY k_%Sample.table%_synsetid (synsetid) REFERENCES %Synset.table% (synsetid);
Sample.no-fk=ALTER TABLE %Sample.table% DROP FOREIGN KEY fk_%Sample.table%_synsetid;
Sample.insert=INSERT INTO %Sample.table% (synsetid,sampleid,sample) VALUES (?,?,?);
LinkType.table=linktypes
LinkType.create=CREATE TABLE IF NOT EXISTS %LinkType.table% (linkid SMALLINT UNSIGNED NOT NULL DEFAULT '0',link VARCHAR (50) DEFAULT NULL,recurses BOOLEAN NOT NULL DEFAULT FALSE,PRIMARY KEY (linkid)) DEFAULT CHARSET=utf8;
LinkType.pk=ALTER TABLE %LinkType.table% ADD CONSTRAINT pk_%LinkType.table% PRIMARY KEY (linkid);
LinkType.no-pk=ALTER TABLE %LinkType.table% DROP PRIMARY KEY;
LinkType.insert=INSERT INTO %LinkType.table% (linkid,link,recurses) VALUES (?,?,?);
SemLink.table=semlinks
SemLink.create=CREATE TABLE IF NOT EXISTS %SemLink.table% (synset1id INTEGER UNSIGNED NOT NULL DEFAULT '0',synset2id INTEGER UNSIGNED NOT NULL DEFAULT '0',linkid SMALLINT UNSIGNED NOT NULL DEFAULT '0',PRIMARY KEY (synset1id,synset2id,linkid)) DEFAULT CHARSET=utf8;
SemLink.pk=ALTER TABLE %SemLink.table% ADD CONSTRAINT pk_%SemLink.table% PRIMARY KEY (synset1id,synset2id,linkid);
SemLink.no-pk=ALTER TABLE %SemLink.table% DROP PRIMARY KEY;
SemLink.index1=ALTER TABLE %SemLink.table% ADD INDEX k_%SemLink.table%_synset1id (synset1id);
SemLink.no-index1=ALTER TABLE %SemLink.table% DROP INDEX k_%SemLink.table%_synset1id;
SemLink.index2=ALTER TABLE %SemLink.table% ADD INDEX k_%SemLink.table%_synset2id (synset2id);
SemLink.no-index2=ALTER TABLE %SemLink.table% DROP INDEX k_%SemLink.table%_synset2id;
SemLink.index3=ALTER TABLE %SemLink.table% ADD INDEX k_%SemLink.table%_linkid (linkid);
SemLink.no-index3=ALTER TABLE %SemLink.table% DROP INDEX k_%SemLink.table%_linkid;
SemLink.fk1=ALTER TABLE %SemLink.table% ADD CONSTRAINT fk_%SemLink.table%_synset1id FOREIGN KEY k_%SemLink.table%_synset1id (synset1id) REFERENCES %Synset.table% (synsetid);
SemLink.no-fk1=ALTER TABLE %SemLink.table% DROP FOREIGN KEY fk_%SemLink.table%_synset1id;
SemLink.fk2=ALTER TABLE %SemLink.table% ADD CONSTRAINT fk_%SemLink.table%_synset2id FOREIGN KEY k_%SemLink.table%_synset2id (synset2id) REFERENCES %Synset.table% (synsetid);
SemLink.no-fk2=ALTER TABLE %SemLink.table% DROP FOREIGN KEY fk_%SemLink.table%_synset2id;
SemLink.fk3=ALTER TABLE %SemLink.table% ADD CONSTRAINT fk_%SemLink.table%_linkid FOREIGN KEY k_%SemLink.table%_linkid (linkid) REFERENCES %LinkType.table% (linkid);
SemLink.no-fk3=ALTER TABLE %SemLink.table% DROP FOREIGN KEY fk_%SemLink.table%_linkid;
SemLink.insert=INSERT INTO %SemLink.table% (synset1id,synset2id,linkid) VALUES (?,?,?);
LexLink.table=lexlinks
LexLink.create=CREATE TABLE IF NOT EXISTS %LexLink.table% (synset1id INTEGER UNSIGNED NOT NULL DEFAULT '0',word1id INTEGER UNSIGNED NOT NULL DEFAULT '0',synset2id INTEGER UNSIGNED NOT NULL DEFAULT '0',word2id INTEGER UNSIGNED NOT NULL DEFAULT '0',linkid SMALLINT UNSIGNED NOT NULL DEFAULT '0',PRIMARY KEY (word1id,synset1id,word2id,synset2id,linkid)) DEFAULT CHARSET=utf8;
LexLink.pk=ALTER TABLE %LexLink.table% ADD CONSTRAINT pk_%LexLink.table% PRIMARY KEY (word1id,synset1id,word2id,synset2id,linkid);
LexLink.no-pk=ALTER TABLE %LexLink.table% DROP PRIMARY KEY;
LexLink.index1=ALTER TABLE %LexLink.table% ADD INDEX k_%LexLink.table%_synset1id_word1id (synset1id,word1id);
LexLink.no-index1=ALTER TABLE %LexLink.table% DROP INDEX k_%LexLink.table%_synset1id_word1id;
LexLink.index2=ALTER TABLE %LexLink.table% ADD INDEX k_%LexLink.table%_synset2id_word2id (synset2id,word2id);
LexLink.no-index2=ALTER TABLE %LexLink.table% DROP INDEX k_%LexLink.table%_synset2id_word2id;
LexLink.index3=ALTER TABLE %LexLink.table% ADD INDEX k_%LexLink.table%_linkid (linkid);
LexLink.no-index3=ALTER TABLE %LexLink.table% DROP INDEX k_%LexLink.table%_linkid;
LexLink.index4=ALTER TABLE %LexLink.table% ADD INDEX k_%LexLink.table%_synset1id (synset1id);
LexLink.no-index4=ALTER TABLE %LexLink.table% DROP INDEX k_%LexLink.table%_synset1id;
LexLink.index5=ALTER TABLE %LexLink.table% ADD INDEX k_%LexLink.table%_word1id (word1id);
LexLink.no-index5=ALTER TABLE %LexLink.table% DROP INDEX k_%LexLink.table%_word1id;
LexLink.index6=ALTER TABLE %LexLink.table% ADD INDEX k_%LexLink.table%_synset2id (synset2id);
LexLink.no-index6=ALTER TABLE %LexLink.table% DROP INDEX k_%LexLink.table%_synset2id;
LexLink.index7=ALTER TABLE %LexLink.table% ADD INDEX k_%LexLink.table%_word2id (word2id);
LexLink.no-index7=ALTER TABLE %LexLink.table% DROP INDEX k_%LexLink.table%_word2id;
LexLink.fk1=ALTER TABLE %LexLink.table% ADD CONSTRAINT fk_%LexLink.table%_synset1id FOREIGN KEY k_%LexLink.table%_synset1id (synset1id) REFERENCES %Synset.table% (synsetid);
LexLink.no-fk1=ALTER TABLE %LexLink.table% DROP FOREIGN KEY fk_%LexLink.table%_synset1id;
LexLink.fk2=ALTER TABLE %LexLink.table% ADD CONSTRAINT fk_%LexLink.table%_synset2id FOREIGN KEY k_%LexLink.table%_synset2id (synset2id) REFERENCES %Synset.table% (synsetid);
LexLink.no-fk2=ALTER TABLE %LexLink.table% DROP FOREIGN KEY fk_%LexLink.table%_synset2id;
LexLink.fk3=ALTER TABLE %LexLink.table% ADD CONSTRAINT fk_%LexLink.table%_word1id FOREIGN KEY k_%LexLink.table%_word1id (word1id) REFERENCES %Word.table% (wordid);
LexLink.no-fk3=ALTER TABLE %LexLink.table% DROP FOREIGN KEY fk_%LexLink.table%_word1id;
LexLink.fk4=ALTER TABLE %LexLink.table% ADD CONSTRAINT fk_%LexLink.table%_word2id FOREIGN KEY k_%LexLink.table%_word2id (word2id) REFERENCES %Word.table% (wordid);
LexLink.no-fk4=ALTER TABLE %LexLink.table% DROP FOREIGN KEY fk_%LexLink.table%_word2id;
LexLink.fk5=ALTER TABLE %LexLink.table% ADD CONSTRAINT fk_%LexLink.table%_linkid FOREIGN KEY k_%LexLink.table%_linkid (linkid) REFERENCES %LinkType.table% (linkid);
LexLink.no-fk5=ALTER TABLE %LexLink.table% DROP FOREIGN KEY fk_%LexLink.table%_linkid;
LexLink.insert=INSERT INTO %LexLink.table% (word1id,synset1id,word2id,synset2id,linkid) VALUES (?,?,?,?,?);
Morph.table=morphs
Morph.create=CREATE TABLE IF NOT EXISTS %Morph.table% (morphid INTEGER UNSIGNED NOT NULL DEFAULT '0',morph VARCHAR (70) NOT NULL,PRIMARY KEY (morphid)) DEFAULT CHARSET=utf8;
Morph.pk=ALTER TABLE %Morph.table% ADD CONSTRAINT pk_%Morph.table% PRIMARY KEY (morphid);
Morph.no-pk=ALTER TABLE %Morph.table% DROP PRIMARY KEY;
Morph.unq=ALTER TABLE %Morph.table% ADD CONSTRAINT unq_%Morph.table%_morph UNIQUE KEY (morph);
Morph.no-unq=ALTER TABLE %Morph.table% DROP INDEX unq_%Morph.table%_morph;
Morph.insert=INSERT INTO %Morph.table% (morphid,morph) VALUES (?,?);
MorphMap.table=morphmaps
MorphMap.create=CREATE TABLE IF NOT EXISTS %MorphMap.table% (wordid INTEGER UNSIGNED NOT NULL DEFAULT '0',pos ENUM ('n','v','a','r','s') DEFAULT NULL,morphid INTEGER UNSIGNED NOT NULL DEFAULT '0',PRIMARY KEY (morphid,pos,wordid)) DEFAULT CHARSET=utf8;
MorphMap.pk=ALTER TABLE %MorphMap.table% ADD CONSTRAINT pk_%MorphMap.table% PRIMARY KEY (morphid,pos,wordid);
MorphMap.no-pk=ALTER TABLE %MorphMap.table% DROP PRIMARY KEY;
MorphMap.index1=ALTER TABLE %MorphMap.table% ADD INDEX k_%MorphMap.table%_wordid (wordid);
MorphMap.no-index1=ALTER TABLE %MorphMap.table% DROP INDEX k_%MorphMap.table%_wordid;
MorphMap.index2=ALTER TABLE %MorphMap.table% ADD INDEX k_%MorphMap.table%_morphid (morphid);
MorphMap.no-index2=ALTER TABLE %MorphMap.table% DROP INDEX k_%MorphMap.table%_morphid;
MorphMap.fk1=ALTER TABLE %MorphMap.table% ADD CONSTRAINT fk_%MorphMap.table%_wordid FOREIGN KEY k_%MorphMap.table%_wordid (wordid) REFERENCES %Word.table% (wordid);
MorphMap.no-fk1=ALTER TABLE %MorphMap.table% DROP FOREIGN KEY fk_%MorphMap.table%_wordid;
MorphMap.fk2=ALTER TABLE %MorphMap.table% ADD CONSTRAINT fk_%MorphMap.table%_morphid FOREIGN KEY k_%MorphMap.table%_morphid (morphid) REFERENCES %Morph.table% (morphid);
MorphMap.no-fk2=ALTER TABLE %MorphMap.table% DROP FOREIGN KEY fk_%MorphMap.table%_morphid;
MorphMap.insert=INSERT INTO %MorphMap.table% (morphid,pos,wordid) VALUES (?,?,?);
AdjPosition.table=adjpositions
AdjPosition.create=CREATE TABLE IF NOT EXISTS %AdjPosition.table% (synsetid INTEGER UNSIGNED NOT NULL DEFAULT '0',wordid INTEGER UNSIGNED NOT NULL DEFAULT '0',position ENUM ('a','p','ip') NOT NULL,PRIMARY KEY (synsetid,wordid)) DEFAULT CHARSET=utf8;
AdjPosition.pk=ALTER TABLE %AdjPosition.table% ADD CONSTRAINT pk_%AdjPosition.table% PRIMARY KEY (synsetid,wordid);
AdjPosition.no-pk=ALTER TABLE %AdjPosition.table% DROP PRIMARY KEY;
AdjPosition.index1=ALTER TABLE %AdjPosition.table% ADD INDEX k_%AdjPosition.table%_synsetid (synsetid);
AdjPosition.no-index1=ALTER TABLE %AdjPosition.table% DROP INDEX k_%AdjPosition.table%_synsetid;
AdjPosition.index2=ALTER TABLE %AdjPosition.table% ADD INDEX k_%AdjPosition.table%_wordid (wordid);
AdjPosition.no-index2=ALTER TABLE %AdjPosition.table% DROP INDEX k_%AdjPosition.table%_wordid;
AdjPosition.fk1=ALTER TABLE %AdjPosition.table% ADD CONSTRAINT fk_%AdjPosition.table%_synsetid FOREIGN KEY k_%AdjPosition.table%_synsetid (synsetid) REFERENCES %Synset.table% (synsetid);
AdjPosition.no-fk1=ALTER TABLE %AdjPosition.table% DROP FOREIGN KEY fk_%AdjPosition.table%_synsetid;
AdjPosition.fk2=ALTER TABLE %AdjPosition.table% ADD CONSTRAINT fk_%AdjPosition.table%_wordid FOREIGN KEY k_%AdjPosition.table%_wordid (wordid) REFERENCES %Word.table% (wordid);
AdjPosition.no-fk2=ALTER TABLE %AdjPosition.table% DROP FOREIGN KEY fk_%AdjPosition.table%_wordid;
AdjPosition.insert=INSERT INTO %AdjPosition.table% (synsetid,wordid,position) VALUES (?,?,?);
AdjPositionType.table=adjpositiontypes
AdjPositionType.create=CREATE TABLE IF NOT EXISTS %AdjPositionType.table% (position ENUM ('a','p','ip') NOT NULL,positionname VARCHAR (24) NOT NULL,PRIMARY KEY (position)) DEFAULT CHARSET=utf8;
AdjPositionType.pk=ALTER TABLE %AdjPositionType.table% ADD CONSTRAINT pk_%AdjPositionType.table% PRIMARY KEY (position);
AdjPositionType.no-pk=ALTER TABLE %AdjPositionType.table% DROP PRIMARY KEY;
AdjPositionType.insert=INSERT INTO %AdjPositionType.table% (position,positionname) VALUES (?,?);
VFrame.table=vframes
VFrame.create=CREATE TABLE IF NOT EXISTS %VFrame.table% (frameid SMALLINT UNSIGNED NOT NULL DEFAULT '0',frame VARCHAR (50) DEFAULT NULL,PRIMARY KEY (frameid)) DEFAULT CHARSET=utf8;
VFrame.pk=ALTER TABLE %VFrame.table% ADD CONSTRAINT pk_%VFrame.table% PRIMARY KEY (frameid);
VFrame.no-pk=ALTER TABLE %VFrame.table% DROP PRIMARY KEY;
VFrame.insert=INSERT INTO %VFrame.table% (frameid,frame) VALUES (?,?);
VFrame.select=SELECT frameid FROM %VFrame.table% WHERE frameid = ?;
VFrameMap.table=vframemaps
VFrameMap.create=CREATE TABLE IF NOT EXISTS %VFrameMap.table% (synsetid INTEGER UNSIGNED NOT NULL DEFAULT '0',wordid INTEGER UNSIGNED DEFAULT NULL,frameid SMALLINT UNSIGNED NOT NULL DEFAULT '0',PRIMARY KEY (synsetid,wordid,frameid)) DEFAULT CHARSET=utf8;
VFrameMap.pk=ALTER TABLE %VFrameMap.table% ADD CONSTRAINT pk_%VFrameMap.table% PRIMARY KEY (synsetid,wordid,frameid);
VFrameMap.no-pk=ALTER TABLE %VFrameMap.table% DROP PRIMARY KEY;
VFrameMap.index1=ALTER TABLE %VFrameMap.table% ADD INDEX k_%VFrameMap.table%_frameid (frameid);
VFrameMap.no-index1=ALTER TABLE %VFrameMap.table% DROP INDEX k_%VFrameMap.table%_frameid;
VFrameMap.index2=ALTER TABLE %VFrameMap.table% ADD INDEX k_%VFrameMap.table%_synsetid (synsetid);
VFrameMap.no-index2=ALTER TABLE %VFrameMap.table% DROP INDEX k_%VFrameMap.table%_synsetid;
VFrameMap.index3=ALTER TABLE %VFrameMap.table% ADD INDEX k_%VFrameMap.table%_wordid (wordid);
VFrameMap.no-index3=ALTER TABLE %VFrameMap.table% DROP INDEX k_%VFrameMap.table%_wordid;
VFrameMap.fk1=ALTER TABLE %VFrameMap.table% ADD CONSTRAINT fk_%VFrameMap.table%_frameid FOREIGN KEY k_%VFrameMap.table%_frameid (frameid) REFERENCES %VFrame.table% (frameid);
VFrameMap.no-fk1=ALTER TABLE %VFrameMap.table% DROP FOREIGN KEY fk_%VFrameMap.table%_frameid;
VFrameMap.fk2=ALTER TABLE %VFrameMap.table% ADD CONSTRAINT fk_%VFrameMap.table%_synsetid FOREIGN KEY k_%VFrameMap.table%_synsetid (synsetid) REFERENCES %Synset.table% (synsetid);
VFrameMap.no-fk2=ALTER TABLE %VFrameMap.table% DROP FOREIGN KEY fk_%VFrameMap.table%_synsetid;
VFrameMap.fk3=ALTER TABLE %VFrameMap.table% ADD CONSTRAINT fk_%VFrameMap.table%_wordid FOREIGN KEY k_%VFrameMap.table%_wordid (wordid) REFERENCES %Word.table% (wordid);
VFrameMap.no-fk3=ALTER TABLE %VFrameMap.table% DROP FOREIGN KEY fk_%VFrameMap.table%_wordid;
VFrameMap.insert=INSERT INTO %VFrameMap.table% (synsetid,wordid,frameid) VALUES (?,?,?);
VFrameSentence.table=vframesentences
VFrameSentence.create=CREATE TABLE IF NOT EXISTS %VFrameSentence.table% (sentenceid SMALLINT UNSIGNED NOT NULL DEFAULT '0',sentence MEDIUMTEXT DEFAULT NULL,PRIMARY KEY (sentenceid)) DEFAULT CHARSET=utf8;
VFrameSentence.pk=ALTER TABLE %VFrameSentence.table% ADD CONSTRAINT pk_%VFrameSentence.table% PRIMARY KEY (sentenceid);
VFrameSentence.no-pk=ALTER TABLE %VFrameSentence.table% DROP PRIMARY KEY;
VFrameSentence.insert=INSERT INTO %VFrameSentence.table% (sentenceid,sentence) VALUES (?,?);
VFrameSentenceMap.table=vframesentencemaps
VFrameSentenceMap.create=CREATE TABLE IF NOT EXISTS %VFrameSentenceMap.table% (synsetid INTEGER UNSIGNED NOT NULL DEFAULT '0',wordid INTEGER UNSIGNED NOT NULL DEFAULT '0',sentenceid SMALLINT UNSIGNED NOT NULL DEFAULT '0',PRIMARY KEY (synsetid,wordid,sentenceid)) DEFAULT CHARSET=utf8;
VFrameSentenceMap.pk=ALTER TABLE %VFrameSentenceMap.table% ADD CONSTRAINT pk_%VFrameSentenceMap.table% PRIMARY KEY (synsetid,wordid,sentenceid);
VFrameSentenceMap.no-pk=ALTER TABLE %VFrameSentenceMap.table% DROP PRIMARY KEY;
VFrameSentenceMap.index1=ALTER TABLE %VFrameSentenceMap.table% ADD INDEX k_%VFrameSentenceMap.table%_sentenceid (sentenceid);
VFrameSentenceMap.no-index1=ALTER TABLE %VFrameSentenceMap.table% DROP INDEX k_%VFrameSentenceMap.table%_sentenceid;
VFrameSentenceMap.index2=ALTER TABLE %VFrameSentenceMap.table% ADD INDEX k_%VFrameSentenceMap.table%_synsetid (synsetid);
VFrameSentenceMap.no-index2=ALTER TABLE %VFrameSentenceMap.table% DROP INDEX k_%VFrameSentenceMap.table%_synsetid;
VFrameSentenceMap.index3=ALTER TABLE %VFrameSentenceMap.table% ADD INDEX k_%VFrameSentenceMap.table%_wordid (wordid);
VFrameSentenceMap.no-index3=ALTER TABLE %VFrameSentenceMap.table% DROP INDEX k_%VFrameSentenceMap.table%_wordid;
VFrameSentenceMap.fk1=ALTER TABLE %VFrameSentenceMap.table% ADD CONSTRAINT fk_%VFrameSentenceMap.table%_sentenceid FOREIGN KEY k_%VFrameSentenceMap.table%_sentenceid (sentenceid) REFERENCES %VFrameSentence.table% (sentenceid);
VFrameSentenceMap.no-fk1=ALTER TABLE %VFrameSentenceMap.table% DROP FOREIGN KEY fk_%VFrameSentenceMap.table%_sentenceid;
VFrameSentenceMap.fk2=ALTER TABLE %VFrameSentenceMap.table% ADD CONSTRAINT fk_%VFrameSentenceMap.table%_synsetid FOREIGN KEY k_%VFrameSentenceMap.table%_synsetid (synsetid) REFERENCES %Synset.table% (synsetid);
VFrameSentenceMap.no-fk2=ALTER TABLE %VFrameSentenceMap.table% DROP FOREIGN KEY fk_%VFrameSentenceMap.table%_synsetid;
VFrameSentenceMap.fk3=ALTER TABLE %VFrameSentenceMap.table% ADD CONSTRAINT fk_%VFrameSentenceMap.table%_wordid FOREIGN KEY k_%VFrameSentenceMap.table%_wordid (wordid) REFERENCES %Word.table% (wordid);
VFrameSentenceMap.no-fk3=ALTER TABLE %VFrameSentenceMap.table% DROP FOREIGN KEY fk_%VFrameSentenceMap.table%_wordid;
VFrameSentenceMap.insert=INSERT INTO %VFrameSentenceMap.table% (synsetid,wordid,sentenceid) VALUES (?,?,?);
Members.extend=ALTER TABLE %Synset.table% ADD COLUMN members VARCHAR(256);
Members.no-extend=ALTER TABLE %Synset.table% DROP COLUMN members;
Members.update=UPDATE %Synset.table% SET members = ? WHERE synsetid = ?;
wn0.Sampleset.view=samplesets
wn0.Sampleset.createview=CREATE OR REPLACE VIEW %wn0.Sampleset.view% AS SELECT synsetid,GROUP_CONCAT(DISTINCT %Sample.table%.sample ORDER BY sampleid SEPARATOR '|') AS sampleset FROM %Sample.table% GROUP BY synsetid;
wn0.WordXSense.view=wordsXsenses
wn0.WordXSense.createview=CREATE OR REPLACE VIEW %wn0.WordXSense.view% AS SELECT * FROM %Word.table% INNER JOIN %Sense.table% USING (wordid);
wn0.SenseXSynset.view=sensesXsynsets
wn0.SenseXSynset.createview=CREATE OR REPLACE VIEW %wn0.SenseXSynset.view% AS SELECT * FROM %Sense.table% INNER JOIN %Synset.table% USING (synsetid);
wn0.WordXSenseXSynset.view=wordsXsensesXsynsets
wn0.WordXSenseXSynset.createview=CREATE OR REPLACE VIEW %wn0.WordXSenseXSynset.view% AS SELECT * FROM %Word.table% INNER JOIN %Sense.table% USING (wordid) INNER JOIN %Synset.table% USING (synsetid);
wn1.SenseXSemlinkXSense.view=sensesXsemlinksXsenses
wn1.SenseXSemlinkXSense.createview=CREATE OR REPLACE VIEW %wn1.SenseXSemlinkXSense.view% AS SELECT linkid,s.synsetid AS ssynsetid,s.wordid AS swordid,s.senseid AS ssenseid,s.casedwordid AS scasedwordid,s.sensenum AS ssensenum,s.lexid AS slexid,s.tagcount AS stagcount,s.sensekey AS ssensekey,s.pos AS spos,s.lexdomainid AS slexdomainid,s.definition AS sdefinition,d.synsetid AS dsynsetid,d.wordid AS dwordid,d.senseid AS dsenseid,d.casedwordid AS dcasedwordid,d.sensenum AS dsensenum,d.lexid AS dlexid,d.tagcount AS dtagcount,d.sensekey AS dsensekey,d.pos AS dpos,d.lexdomainid AS dlexdomainid,d.definition AS ddefinition FROM %wn0.SenseXSynset.view% AS s INNER JOIN %SemLink.table% AS l ON s.synsetid = l.synset1id INNER JOIN %wn0.SenseXSynset.view% AS d ON l.synset2id = d.synsetid;
wn1.SynsetXSemlinkXSynset.view=synsetsXsemlinksXsynsets
wn1.SynsetXSemlinkXSynset.createview=CREATE OR REPLACE VIEW %wn1.SynsetXSemlinkXSynset.view% AS SELECT linkid,s.synsetid AS ssynsetid,s.definition AS sdefinition,d.synsetid AS dsynsetid,d.definition AS ddefinition FROM %Synset.table% AS s INNER JOIN %SemLink.table% AS l ON s.synsetid = l.synset1id INNER JOIN %Synset.table% AS d ON l.synset2id = d.synsetid;
wn1.SenseXLexlinkXSense.view=sensesXlexlinksXsenses
wn1.SenseXLexlinkXSense.createview=CREATE OR REPLACE VIEW %wn1.SenseXLexlinkXSense.view% AS SELECT linkid,s.synsetid AS ssynsetid,s.wordid AS swordid,s.senseid AS ssenseid,s.casedwordid AS scasedwordid,s.sensenum AS ssensenum,s.lexid AS slexid,s.tagcount AS stagcount,s.sensekey AS ssensekey,s.pos AS spos,s.lexdomainid AS slexdomainid,s.definition AS sdefinition,d.synsetid AS dsynsetid,d.wordid AS dwordid,d.senseid AS dsenseid,d.casedwordid AS dcasedwordid,d.sensenum AS dsensenum,d.lexid AS dlexid,d.tagcount AS dtagcount,d.sensekey AS dsensekey,d.pos AS dpos,d.lexdomainid AS dlexdomainid,d.definition AS ddefinition FROM %wn0.SenseXSynset.view% AS s INNER JOIN %LexLink.table% AS l ON s.synsetid = l.synset1id AND s.wordid = l.word1id INNER JOIN %wn0.SenseXSynset.view% AS d ON l.synset2id = d.synsetid AND l.word2id = d.wordid;
wn1.Dict.view=dict
wn1.Dict.createview=CREATE OR REPLACE VIEW %wn1.Dict.view% AS SELECT * FROM %Word.table% LEFT JOIN %Sense.table% s USING (wordid) LEFT JOIN %CasedWord.table% USING (wordid,casedwordid) LEFT JOIN %Synset.table% USING (synsetid) LEFT JOIN %wn0.Sampleset.view% USING (synsetid);
wn1.Morphology.view=morphology
wn1.Morphology.createview=CREATE OR REPLACE VIEW %wn1.Morphology.view% AS SELECT * FROM %Word.table% INNER JOIN %MorphMap.table% USING (wordid) INNER JOIN %Morph.table% USING (morphid);
wn1.VerbsWithFrames.view=verbswithframes
wn1.VerbsWithFrames.createview=CREATE OR REPLACE VIEW %wn1.VerbsWithFrames.view% AS SELECT * FROM %Sense.table% INNER JOIN %VFrameMap.table% USING (wordid,synsetid) INNER JOIN %VFrame.table% USING (frameid) LEFT JOIN %Word.table% USING (wordid) LEFT JOIN %Synset.table% USING (synsetid);
wn1.AdjsWithPos.view=adjectiveswithpositions
wn1.AdjsWithPos.createview=CREATE OR REPLACE VIEW %wn1.AdjsWithPos.view% AS SELECT * FROM %Sense.table% INNER JOIN %AdjPosition.table% USING (wordid,synsetid) LEFT JOIN %Word.table% USING (wordid) LEFT JOIN %Synset.table% USING (synsetid);

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks