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

Download this file

251 lines (231 with data), 18.4 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 NOT NULL DEFAULT '0',lemma VARCHAR (80) NOT NULL,CONSTRAINT pk_%Word.table% PRIMARY KEY (wordid));
Word.pk=
Word.no-pk=
Word.unq=CREATE UNIQUE INDEX IF NOT EXISTS unq_%Word.table%_lemma ON %Word.table% (lemma);
Word.no-unq=DROP INDEX IF EXISTS 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 NOT NULL DEFAULT '0',wordid INTEGER NOT NULL DEFAULT '0',cased VARCHAR (80) NOT NULL,CONSTRAINT pk_%CasedWord.table% PRIMARY KEY (casedwordid));
CasedWord.pk=
CasedWord.no-pk=
CasedWord.unq=CREATE UNIQUE INDEX IF NOT EXISTS unq_%CasedWord.table%_cased ON %CasedWord.table% (cased);
CasedWord.no-unq=DROP INDEX IF EXISTS unq_%CasedWord.table%_cased;
CasedWord.index=CREATE INDEX IF NOT EXISTS k_%CasedWord.table%_wordid ON %CasedWord.table% (wordid);
CasedWord.no-index=DROP INDEX IF EXISTS k_%CasedWord.table%_wordid;
CasedWord.fk=
CasedWord.no-fk=
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 NOT NULL DEFAULT '0',casedwordid INTEGER NULL,synsetid INTEGER NOT NULL DEFAULT '0',senseid INTEGER NULL,sensenum SMALLINT NOT NULL DEFAULT '0',lexid SMALLINT NOT NULL DEFAULT '0',tagcount INTEGER NULL,sensekey VARCHAR (100) DEFAULT NULL,CONSTRAINT pk_%Sense.table% PRIMARY KEY (wordid,synsetid));
Sense.pk=
Sense.no-pk=
Sense.unq1=CREATE UNIQUE INDEX IF NOT EXISTS unq_%Sense.table%_senseid ON %Sense.table% (senseid);
Sense.no-unq1=DROP INDEX IF EXISTS unq_%Sense.table%_senseid;
Sense.unq2=CREATE UNIQUE INDEX IF NOT EXISTS unq_%Sense.table%_sensekey ON %Sense.table% (sensekey);
Sense.no-unq2=DROP INDEX IF EXISTS unq_%Sense.table%_sensekey;
Sense.index1=CREATE INDEX IF NOT EXISTS k_%Sense.table%_wordid ON %Sense.table% (wordid);
Sense.no-index1=DROP INDEX IF EXISTS k_%Sense.table%_wordid;
Sense.index2=CREATE INDEX IF NOT EXISTS k_%Sense.table%_synsetid ON %Sense.table% (synsetid);
Sense.no-index2=DROP INDEX IF EXISTS k_%Sense.table%_synsetid;
Sense.index3=CREATE INDEX IF NOT EXISTS k_%Sense.table%_lexid ON %Sense.table% (lexid);
Sense.no-index3=DROP INDEX IF EXISTS k_%Sense.table%_lexid;
Sense.fk1=
Sense.no-fk1=
Sense.fk2=
Sense.no-fk2=
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 NOT NULL DEFAULT '0',pos CHARACTER (1) NOT NULL,lexdomainid SMALLINT NOT NULL DEFAULT '0',definition TEXT,CONSTRAINT pk_%Synset.table% PRIMARY KEY (synsetid));
Synset.pk=
Synset.no-pk=
Synset.index=CREATE INDEX IF NOT EXISTS k_%Synset.table%_lexdomainid ON %Synset.table% (lexdomainid);
Synset.no-index=DROP INDEX IF EXISTS k_%Synset.table%_lexdomainid;
Synset.fk=
Synset.no-fk=
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 CHARACTER (1) NOT NULL,posname VARCHAR (20) NOT NULL,CONSTRAINT pk_%PosType.table% PRIMARY KEY (pos));
PosType.pk=
PosType.no-pk=
PosType.insert=INSERT INTO %PosType.table% (pos,posname) VALUES (?,?);
LexDomain.table=lexdomains
LexDomain.create=CREATE TABLE IF NOT EXISTS %LexDomain.table% (lexdomainid SMALLINT NOT NULL DEFAULT '0',lexdomainname VARCHAR (32) DEFAULT NULL,lexdomain VARCHAR (32) DEFAULT NULL,pos CHARACTER (1) DEFAULT NULL,CONSTRAINT pk_%LexDomain.table% PRIMARY KEY (lexdomainid));
LexDomain.pk=
LexDomain.no-pk=
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 NOT NULL DEFAULT '0',sampleid SMALLINT NOT NULL DEFAULT '0',sample TEXT NOT NULL,CONSTRAINT pk_%Sample.table% PRIMARY KEY (synsetid,sampleid));
Sample.pk=
Sample.no-pk=
Sample.index=CREATE INDEX IF NOT EXISTS k_%Sample.table%_synsetid ON %Sample.table% (synsetid);
Sample.no-index=DROP INDEX IF EXISTS k_%Sample.table%_synsetid;
Sample.fk=
Sample.no-fk=
Sample.insert=INSERT INTO %Sample.table% (synsetid,sampleid,sample) VALUES (?,?,?);
LinkType.table=linktypes
LinkType.create=CREATE TABLE IF NOT EXISTS %LinkType.table% (linkid SMALLINT NOT NULL DEFAULT '0',link VARCHAR (50) DEFAULT NULL,recurses BOOLEAN NOT NULL DEFAULT FALSE,CONSTRAINT pk_%LinkType.table% PRIMARY KEY (linkid));
LinkType.pk=
LinkType.no-pk=
LinkType.insert=INSERT INTO %LinkType.table% (linkid,link,recurses) VALUES (?,?,?);
SemLink.table=semlinks
SemLink.create=CREATE TABLE IF NOT EXISTS %SemLink.table% (synset1id INTEGER NOT NULL DEFAULT '0',synset2id INTEGER NOT NULL DEFAULT '0',linkid SMALLINT NOT NULL DEFAULT '0',CONSTRAINT pk_%SemLink.table% PRIMARY KEY (synset1id,synset2id,linkid));
SemLink.pk=
SemLink.no-pk=
SemLink.index1=CREATE INDEX IF NOT EXISTS k_%SemLink.table%_synset1id ON %SemLink.table% (synset1id);
SemLink.no-index1=DROP INDEX IF EXISTS k_%SemLink.table%_synset1id;
SemLink.index2=CREATE INDEX IF NOT EXISTS k_%SemLink.table%_synset2id ON %SemLink.table% (synset2id);
SemLink.no-index2=DROP INDEX IF EXISTS k_%SemLink.table%_synset2id;
SemLink.index3=CREATE INDEX IF NOT EXISTS k_%SemLink.table%_linkid ON %SemLink.table% (linkid);
SemLink.no-index3=DROP INDEX IF EXISTS k_%SemLink.table%_linkid;
SemLink.fk1=
SemLink.no-fk1=
SemLink.fk2=
SemLink.no-fk2=
SemLink.fk3=
SemLink.no-fk3=
SemLink.insert=INSERT INTO %SemLink.table% (synset1id,synset2id,linkid) VALUES (?,?,?);
LexLink.table=lexlinks
LexLink.create=CREATE TABLE IF NOT EXISTS %LexLink.table% (synset1id INTEGER NOT NULL DEFAULT '0',word1id INTEGER NOT NULL DEFAULT '0',synset2id INTEGER NOT NULL DEFAULT '0',word2id INTEGER NOT NULL DEFAULT '0',linkid SMALLINT NOT NULL DEFAULT '0',CONSTRAINT pk_%LexLink.table% PRIMARY KEY (word1id,synset1id,word2id,synset2id,linkid));
LexLink.pk=
LexLink.no-pk=
LexLink.index1=CREATE INDEX IF NOT EXISTS k_%LexLink.table%_synset1id_word1id ON %LexLink.table% (synset1id,word1id);
LexLink.no-index1=DROP INDEX IF EXISTS k_%LexLink.table%_synset1id_word1id;
LexLink.index2=CREATE INDEX IF NOT EXISTS k_%LexLink.table%_synset2id_word2id ON %LexLink.table% (synset2id,word2id);
LexLink.no-index2=DROP INDEX IF EXISTS k_%LexLink.table%_synset2id_word2id;
LexLink.index3=CREATE INDEX IF NOT EXISTS k_%LexLink.table%_linkid ON %LexLink.table% (linkid);
LexLink.no-index3=DROP INDEX IF EXISTS k_%LexLink.table%_linkid;
LexLink.index4=CREATE INDEX IF NOT EXISTS k_%LexLink.table%_synset1id ON %LexLink.table% (synset1id);
LexLink.no-index4=DROP INDEX IF EXISTS k_%LexLink.table%_synset1id;
LexLink.index5=CREATE INDEX IF NOT EXISTS k_%LexLink.table%_word1id ON %LexLink.table% (word1id);
LexLink.no-index5=DROP INDEX IF EXISTS k_%LexLink.table%_word1id;
LexLink.index6=CREATE INDEX IF NOT EXISTS k_%LexLink.table%_synset2id ON %LexLink.table% (synset2id);
LexLink.no-index6=DROP INDEX IF EXISTS k_%LexLink.table%_synset2id;
LexLink.index7=CREATE INDEX IF NOT EXISTS k_%LexLink.table%_word2id ON %LexLink.table% (word2id);
LexLink.no-index7=DROP INDEX IF EXISTS k_%LexLink.table%_word2id;
LexLink.fk1=
LexLink.no-fk1=
LexLink.fk2=
LexLink.no-fk2=
LexLink.fk3=
LexLink.no-fk3=
LexLink.fk4=
LexLink.no-fk4=
LexLink.fk5=
LexLink.no-fk5=
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 NOT NULL DEFAULT '0',morph VARCHAR (70) NOT NULL,CONSTRAINT pk_%Morph.table% PRIMARY KEY (morphid));
Morph.pk=
Morph.no-pk=
Morph.unq=CREATE UNIQUE INDEX IF NOT EXISTS unq_%Morph.table%_morph ON %Morph.table% (morph);
Morph.no-unq=DROP INDEX IF EXISTS 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 NOT NULL DEFAULT '0',pos CHARACTER (1) DEFAULT NULL,morphid INTEGER NOT NULL DEFAULT '0',CONSTRAINT pk_%MorphMap.table% PRIMARY KEY (morphid,pos,wordid));
MorphMap.pk=
MorphMap.no-pk=
MorphMap.index1=CREATE INDEX IF NOT EXISTS k_%MorphMap.table%_wordid ON %MorphMap.table% (wordid);
MorphMap.no-index1=DROP INDEX IF EXISTS k_%MorphMap.table%_wordid;
MorphMap.index2=CREATE INDEX IF NOT EXISTS k_%MorphMap.table%_morphid ON %MorphMap.table% (morphid);
MorphMap.no-index2=DROP INDEX IF EXISTS k_%MorphMap.table%_morphid;
MorphMap.fk1=
MorphMap.no-fk1=
MorphMap.fk2=
MorphMap.no-fk2=
MorphMap.insert=INSERT INTO %MorphMap.table% (morphid,pos,wordid) VALUES (?,?,?);
AdjPosition.table=adjpositions
AdjPosition.create=CREATE TABLE IF NOT EXISTS %AdjPosition.table% (synsetid INTEGER NOT NULL DEFAULT '0',wordid INTEGER NOT NULL DEFAULT '0',position CHARACTER (2) NOT NULL,CONSTRAINT pk_%AdjPosition.table% PRIMARY KEY (synsetid,wordid));
AdjPosition.pk=
AdjPosition.no-pk=
AdjPosition.index1=CREATE INDEX IF NOT EXISTS k_%AdjPosition.table%_synsetid ON %AdjPosition.table% (synsetid);
AdjPosition.no-index1=DROP INDEX IF EXISTS k_%AdjPosition.table%_synsetid;
AdjPosition.index2=CREATE INDEX IF NOT EXISTS k_%AdjPosition.table%_wordid ON %AdjPosition.table% (wordid);
AdjPosition.no-index2=DROP INDEX IF EXISTS k_%AdjPosition.table%_wordid;
AdjPosition.fk1=
AdjPosition.no-fk1=
AdjPosition.fk2=
AdjPosition.no-fk2=
AdjPosition.insert=INSERT INTO %AdjPosition.table% (synsetid,wordid,position) VALUES (?,?,?);
AdjPositionType.table=adjpositiontypes
AdjPositionType.create=CREATE TABLE IF NOT EXISTS %AdjPositionType.table% (position CHARACTER (2) NOT NULL,positionname VARCHAR (24) NOT NULL,CONSTRAINT pk_%AdjPositionType.table% PRIMARY KEY (position));
AdjPositionType.pk=
AdjPositionType.no-pk=
AdjPositionType.insert=INSERT INTO %AdjPositionType.table% (position,positionname) VALUES (?,?);
VFrame.table=vframes
VFrame.create=CREATE TABLE IF NOT EXISTS %VFrame.table% (frameid SMALLINT NOT NULL DEFAULT '0',frame VARCHAR (50) DEFAULT NULL,CONSTRAINT pk_%VFrame.table% PRIMARY KEY (frameid));
VFrame.pk=
VFrame.no-pk=
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 NOT NULL DEFAULT '0',wordid INTEGER DEFAULT NULL,frameid SMALLINT NOT NULL DEFAULT '0',CONSTRAINT pk_%VFrameMap.table% PRIMARY KEY (synsetid,wordid,frameid));
VFrameMap.pk=
VFrameMap.no-pk=
VFrameMap.index1=CREATE INDEX IF NOT EXISTS k_%VFrameMap.table%_frameid ON %VFrameMap.table% (frameid);
VFrameMap.no-index1=DROP INDEX IF EXISTS k_%VFrameMap.table%_frameid;
VFrameMap.index2=CREATE INDEX IF NOT EXISTS k_%VFrameMap.table%_synsetid ON %VFrameMap.table% (synsetid);
VFrameMap.no-index2=DROP INDEX IF EXISTS k_%VFrameMap.table%_synsetid;
VFrameMap.index3=CREATE INDEX IF NOT EXISTS k_%VFrameMap.table%_wordid ON %VFrameMap.table% (wordid);
VFrameMap.no-index3=DROP INDEX IF EXISTS k_%VFrameMap.table%_wordid;
VFrameMap.fk1=
VFrameMap.no-fk1=
VFrameMap.fk2=
VFrameMap.no-fk2=
VFrameMap.fk3=
VFrameMap.no-fk3=
VFrameMap.insert=INSERT INTO %VFrameMap.table% (synsetid,wordid,frameid) VALUES (?,?,?);
VFrameSentence.table=vframesentences
VFrameSentence.create=CREATE TABLE IF NOT EXISTS %VFrameSentence.table% (sentenceid SMALLINT NOT NULL DEFAULT '0',sentence TEXT DEFAULT NULL,CONSTRAINT pk_%VFrameSentence.table% PRIMARY KEY (sentenceid));
VFrameSentence.pk=
VFrameSentence.no-pk=
VFrameSentence.insert=INSERT INTO %VFrameSentence.table% (sentenceid,sentence) VALUES (?,?);
VFrameSentenceMap.table=vframesentencemaps
VFrameSentenceMap.create=CREATE TABLE IF NOT EXISTS %VFrameSentenceMap.table% (synsetid INTEGER NOT NULL DEFAULT '0',wordid INTEGER NOT NULL DEFAULT '0',sentenceid SMALLINT NOT NULL DEFAULT '0',CONSTRAINT pk_%VFrameSentenceMap.table% PRIMARY KEY (synsetid,wordid,sentenceid));
VFrameSentenceMap.pk=
VFrameSentenceMap.no-pk=
VFrameSentenceMap.index1=CREATE INDEX IF NOT EXISTS k_%VFrameSentenceMap.table%_sentenceid ON %VFrameSentenceMap.table% (sentenceid);
VFrameSentenceMap.no-index1=DROP INDEX IF EXISTS k_%VFrameSentenceMap.table%_sentenceid;
VFrameSentenceMap.index2=CREATE INDEX IF NOT EXISTS k_%VFrameSentenceMap.table%_synsetid ON %VFrameSentenceMap.table% (synsetid);
VFrameSentenceMap.no-index2=DROP INDEX IF EXISTS k_%VFrameSentenceMap.table%_synsetid;
VFrameSentenceMap.index3=CREATE INDEX IF NOT EXISTS k_%VFrameSentenceMap.table%_wordid ON %VFrameSentenceMap.table% (wordid);
VFrameSentenceMap.no-index3=DROP INDEX IF EXISTS k_%VFrameSentenceMap.table%_wordid;
VFrameSentenceMap.fk1=
VFrameSentenceMap.no-fk1=
VFrameSentenceMap.fk2=
VFrameSentenceMap.no-fk2=
VFrameSentenceMap.fk3=
VFrameSentenceMap.no-fk3=
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=DROP VIEW IF EXISTS %wn0.Sampleset.view%; CREATE VIEW %wn0.Sampleset.view% AS SELECT synsetid,GROUP_CONCAT(DISTINCT %Sample.table%.sample,'|') AS sampleset FROM %Sample.table% GROUP BY synsetid;
wn0.WordXSense.view=wordsXsenses
wn0.WordXSense.createview=DROP VIEW IF EXISTS %wn0.WordXSense.view%; CREATE VIEW %wn0.WordXSense.view% AS SELECT * FROM %Word.table% INNER JOIN %Sense.table% USING (wordid);
wn0.SenseXSynset.view=sensesXsynsets
wn0.SenseXSynset.createview=DROP VIEW IF EXISTS %wn0.SenseXSynset.view%; CREATE VIEW %wn0.SenseXSynset.view% AS SELECT * FROM %Sense.table% INNER JOIN %Synset.table% USING (synsetid);
wn0.WordXSenseXSynset.view=wordsXsensesXsynsets
wn0.WordXSenseXSynset.createview=DROP VIEW IF EXISTS %wn0.WordXSenseXSynset.view%; CREATE 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=DROP VIEW IF EXISTS %wn1.SenseXSemlinkXSense.view%; CREATE 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=DROP VIEW IF EXISTS %wn1.SynsetXSemlinkXSynset.view%; CREATE 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=DROP VIEW IF EXISTS %wn1.SenseXLexlinkXSense.view%; CREATE 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=DROP VIEW IF EXISTS %wn1.Dict.view%; CREATE 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=DROP VIEW IF EXISTS %wn1.Morphology.view%; CREATE 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=DROP VIEW IF EXISTS %wn1.VerbsWithFrames.view%; CREATE 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=DROP VIEW IF EXISTS %wn1.AdjsWithPos.view%; CREATE 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);