Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

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

Download this file

postgresql.properties    251 lines (231 with data), 25.1 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 %Word.table% (wordid INTEGER NOT NULL DEFAULT '0',lemma VARCHAR (80) NOT NULL,CONSTRAINT pk_%Word.table% PRIMARY KEY (wordid));
Word.pk=ALTER TABLE %Word.table% ADD CONSTRAINT pk_%Word.table% PRIMARY KEY (wordid);
Word.no-pk=ALTER TABLE %Word.table% DROP CONSTRAINT pk_%Word.table% CASCADE;
Word.unq=CREATE UNIQUE INDEX unq_%Word.table%_lemma ON %Word.table% (lemma);
Word.no-unq=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 %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=ALTER TABLE %CasedWord.table% ADD CONSTRAINT pk_%CasedWord.table% PRIMARY KEY (casedwordid);
CasedWord.no-pk=ALTER TABLE %CasedWord.table% DROP CONSTRAINT pk_%CasedWord.table% CASCADE;
CasedWord.unq=CREATE UNIQUE INDEX unq_%CasedWord.table%_cased ON %CasedWord.table% (cased);
CasedWord.no-unq=DROP INDEX unq_%CasedWord.table%_cased;
CasedWord.index=CREATE INDEX k_%CasedWord.table%_wordid ON %CasedWord.table% (wordid);
CasedWord.no-index=DROP INDEX k_%CasedWord.table%_wordid;
CasedWord.fk=ALTER TABLE %CasedWord.table% ADD CONSTRAINT fk_%CasedWord.table%_wordid FOREIGN KEY (wordid) REFERENCES %Word.table% (wordid);
CasedWord.no-fk=ALTER TABLE %CasedWord.table% DROP CONSTRAINT fk_%CasedWord.table%_wordid CASCADE;
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 %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=ALTER TABLE %Sense.table% ADD CONSTRAINT pk_%Sense.table% PRIMARY KEY (wordid,synsetid);
Sense.no-pk=ALTER TABLE %Sense.table% DROP CONSTRAINT pk_%Sense.table% CASCADE;
Sense.unq1=CREATE UNIQUE INDEX unq_%Sense.table%_senseid ON %Sense.table% (senseid);
Sense.no-unq1=DROP INDEX unq_%Sense.table%_senseid;
Sense.unq2=CREATE UNIQUE INDEX unq_%Sense.table%_sensekey ON %Sense.table% (sensekey);
Sense.no-unq2=DROP INDEX unq_%Sense.table%_sensekey;
Sense.index1=CREATE INDEX k_%Sense.table%_wordid ON %Sense.table% (wordid);
Sense.no-index1=DROP INDEX k_%Sense.table%_wordid;
Sense.index2=CREATE INDEX k_%Sense.table%_synsetid ON %Sense.table% (synsetid);
Sense.no-index2=DROP INDEX k_%Sense.table%_synsetid;
Sense.index3=CREATE INDEX k_%Sense.table%_lexid ON %Sense.table% (lexid);
Sense.no-index3=DROP INDEX k_%Sense.table%_lexid;
Sense.fk1=ALTER TABLE %Sense.table% ADD CONSTRAINT fk_%Sense.table%_wordid FOREIGN KEY (wordid) REFERENCES %Word.table% (wordid);
Sense.no-fk1=ALTER TABLE %Sense.table% DROP CONSTRAINT fk_%Sense.table%_wordid CASCADE;
Sense.fk2=ALTER TABLE %Sense.table% ADD CONSTRAINT fk_%Sense.table%_synsetid FOREIGN KEY (synsetid) REFERENCES %Synset.table% (synsetid);
Sense.no-fk2=ALTER TABLE %Sense.table% DROP CONSTRAINT fk_%Sense.table%_synsetid CASCADE;
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 %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=ALTER TABLE %Synset.table% ADD CONSTRAINT pk_%Synset.table% PRIMARY KEY (synsetid);
Synset.no-pk=ALTER TABLE %Synset.table% DROP CONSTRAINT pk_%Synset.table% CASCADE;
Synset.index=CREATE INDEX k_%Synset.table%_lexdomainid ON %Synset.table% (lexdomainid);
Synset.no-index=DROP INDEX k_%Synset.table%_lexdomainid;
Synset.fk=ALTER TABLE %Synset.table% ADD CONSTRAINT fk_%Synset.table%_lexdomainid FOREIGN KEY (lexdomainid) REFERENCES %LexDomain.table% (lexdomainid);
Synset.no-fk=ALTER TABLE %Synset.table% DROP CONSTRAINT fk_%Synset.table%_lexdomainid CASCADE;
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 %PosType.table% (pos CHARACTER (1) NOT NULL,posname VARCHAR (20) NOT NULL,CONSTRAINT pk_%PosType.table% PRIMARY KEY (pos));
PosType.pk=ALTER TABLE %PosType.table% ADD CONSTRAINT pk_%PosType.table% PRIMARY KEY (pos);
PosType.no-pk=ALTER TABLE %PosType.table% DROP CONSTRAINT pk_%PosType.table% CASCADE;
PosType.insert=INSERT INTO %PosType.table% (pos,posname) VALUES (?,?);
LexDomain.table=lexdomains
LexDomain.create=CREATE TABLE %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=ALTER TABLE %LexDomain.table% ADD CONSTRAINT pk_%LexDomain.table% PRIMARY KEY (lexdomainid);
LexDomain.no-pk=ALTER TABLE %LexDomain.table% DROP CONSTRAINT pk_%LexDomain.table% CASCADE;
LexDomain.insert=INSERT INTO %LexDomain.table% (lexdomainid,lexdomainname,lexdomain,pos) VALUES (?,?,?,?);
Sample.table=samples
Sample.create=CREATE TABLE %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=ALTER TABLE %Sample.table% ADD CONSTRAINT pk_%Sample.table% PRIMARY KEY (synsetid,sampleid);
Sample.no-pk=ALTER TABLE %Sample.table% DROP CONSTRAINT pk_%Sample.table% CASCADE;
Sample.index=CREATE INDEX k_%Sample.table%_synsetid ON %Sample.table% (synsetid);
Sample.no-index=DROP INDEX k_%Sample.table%_synsetid;
Sample.fk=ALTER TABLE %Sample.table% ADD CONSTRAINT fk_%Sample.table%_synsetid FOREIGN KEY (synsetid) REFERENCES %Synset.table% (synsetid);
Sample.no-fk=ALTER TABLE %Sample.table% DROP CONSTRAINT fk_%Sample.table%_synsetid CASCADE;
Sample.insert=INSERT INTO %Sample.table% (synsetid,sampleid,sample) VALUES (?,?,?);
LinkType.table=linktypes
LinkType.create=CREATE TABLE %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=ALTER TABLE %LinkType.table% ADD CONSTRAINT pk_%LinkType.table% PRIMARY KEY (linkid);
LinkType.no-pk=ALTER TABLE %LinkType.table% DROP CONSTRAINT pk_%LinkType.table% CASCADE;
LinkType.insert=INSERT INTO %LinkType.table% (linkid,link,recurses) VALUES (?,?,?);
SemLink.table=semlinks
SemLink.create=CREATE TABLE %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=ALTER TABLE %SemLink.table% ADD CONSTRAINT pk_%SemLink.table% PRIMARY KEY (synset1id,synset2id,linkid);
SemLink.no-pk=ALTER TABLE %SemLink.table% DROP CONSTRAINT pk_%SemLink.table% CASCADE;
SemLink.index1=CREATE INDEX k_%SemLink.table%_synset1id ON %SemLink.table% (synset1id);
SemLink.no-index1=DROP INDEX k_%SemLink.table%_synset1id;
SemLink.index2=CREATE INDEX k_%SemLink.table%_synset2id ON %SemLink.table% (synset2id);
SemLink.no-index2=DROP INDEX k_%SemLink.table%_synset2id;
SemLink.index3=CREATE INDEX k_%SemLink.table%_linkid ON %SemLink.table% (linkid);
SemLink.no-index3=DROP INDEX k_%SemLink.table%_linkid;
SemLink.fk1=ALTER TABLE %SemLink.table% ADD CONSTRAINT fk_%SemLink.table%_synset1id FOREIGN KEY (synset1id) REFERENCES %Synset.table% (synsetid);
SemLink.no-fk1=ALTER TABLE %SemLink.table% DROP CONSTRAINT fk_%SemLink.table%_synset1id CASCADE;
SemLink.fk2=ALTER TABLE %SemLink.table% ADD CONSTRAINT fk_%SemLink.table%_synset2id FOREIGN KEY (synset2id) REFERENCES %Synset.table% (synsetid);
SemLink.no-fk2=ALTER TABLE %SemLink.table% DROP CONSTRAINT fk_%SemLink.table%_synset2id CASCADE;
SemLink.fk3=ALTER TABLE %SemLink.table% ADD CONSTRAINT fk_%SemLink.table%_linkid FOREIGN KEY (linkid) REFERENCES %LinkType.table% (linkid);
SemLink.no-fk3=ALTER TABLE %SemLink.table% DROP CONSTRAINT fk_%SemLink.table%_linkid CASCADE;
SemLink.insert=INSERT INTO %SemLink.table% (synset1id,synset2id,linkid) VALUES (?,?,?);
LexLink.table=lexlinks
LexLink.create=CREATE TABLE %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=ALTER TABLE %LexLink.table% ADD CONSTRAINT pk_%LexLink.table% PRIMARY KEY (word1id,synset1id,word2id,synset2id,linkid);
LexLink.no-pk=ALTER TABLE %LexLink.table% DROP CONSTRAINT pk_%LexLink.table% CASCADE;
LexLink.index1=CREATE INDEX k_%LexLink.table%_synset1id_word1id ON %LexLink.table% (synset1id,word1id);
LexLink.no-index1=DROP INDEX k_%LexLink.table%_synset1id_word1id;
LexLink.index2=CREATE INDEX k_%LexLink.table%_synset2id_word2id ON %LexLink.table% (synset2id,word2id);
LexLink.no-index2=DROP INDEX k_%LexLink.table%_synset2id_word2id;
LexLink.index3=CREATE INDEX k_%LexLink.table%_linkid ON %LexLink.table% (linkid);
LexLink.no-index3=DROP INDEX k_%LexLink.table%_linkid;
LexLink.index4=CREATE INDEX k_%LexLink.table%_synset1id ON %LexLink.table% (synset1id);
LexLink.no-index4=DROP INDEX k_%LexLink.table%_synset1id;
LexLink.index5=CREATE INDEX k_%LexLink.table%_word1id ON %LexLink.table% (word1id);
LexLink.no-index5=DROP INDEX k_%LexLink.table%_word1id;
LexLink.index6=CREATE INDEX k_%LexLink.table%_synset2id ON %LexLink.table% (synset2id);
LexLink.no-index6=DROP INDEX k_%LexLink.table%_synset2id;
LexLink.index7=CREATE INDEX k_%LexLink.table%_word2id ON %LexLink.table% (word2id);
LexLink.no-index7=DROP INDEX k_%LexLink.table%_word2id;
LexLink.fk1=ALTER TABLE %LexLink.table% ADD CONSTRAINT fk_%LexLink.table%_synset1id FOREIGN KEY (synset1id) REFERENCES %Synset.table% (synsetid);
LexLink.no-fk1=ALTER TABLE %LexLink.table% DROP CONSTRAINT fk_%LexLink.table%_synset1id CASCADE;
LexLink.fk2=ALTER TABLE %LexLink.table% ADD CONSTRAINT fk_%LexLink.table%_synset2id FOREIGN KEY (synset2id) REFERENCES %Synset.table% (synsetid);
LexLink.no-fk2=ALTER TABLE %LexLink.table% DROP CONSTRAINT fk_%LexLink.table%_synset2id CASCADE;
LexLink.fk3=ALTER TABLE %LexLink.table% ADD CONSTRAINT fk_%LexLink.table%_word1id FOREIGN KEY (word1id) REFERENCES %Word.table% (wordid);
LexLink.no-fk3=ALTER TABLE %LexLink.table% DROP CONSTRAINT fk_%LexLink.table%_word1id CASCADE;
LexLink.fk4=ALTER TABLE %LexLink.table% ADD CONSTRAINT fk_%LexLink.table%_word2id FOREIGN KEY (word2id) REFERENCES %Word.table% (wordid);
LexLink.no-fk4=ALTER TABLE %LexLink.table% DROP CONSTRAINT fk_%LexLink.table%_word2id CASCADE;
LexLink.fk5=ALTER TABLE %LexLink.table% ADD CONSTRAINT fk_%LexLink.table%_linkid FOREIGN KEY (linkid) REFERENCES %LinkType.table% (linkid);
LexLink.no-fk5=ALTER TABLE %LexLink.table% DROP CONSTRAINT fk_%LexLink.table%_linkid CASCADE;
LexLink.insert=INSERT INTO %LexLink.table% (word1id,synset1id,word2id,synset2id,linkid) VALUES (?,?,?,?,?);
Morph.table=morphs
Morph.create=CREATE TABLE %Morph.table% (morphid INTEGER NOT NULL DEFAULT '0',morph VARCHAR (70) NOT NULL,CONSTRAINT pk_%Morph.table% PRIMARY KEY (morphid));
Morph.pk=ALTER TABLE %Morph.table% ADD CONSTRAINT pk_%Morph.table% PRIMARY KEY (morphid);
Morph.no-pk=ALTER TABLE %Morph.table% DROP CONSTRAINT pk_%Morph.table% CASCADE;
Morph.unq=CREATE UNIQUE INDEX unq_%Morph.table%_morph ON %Morph.table% (morph);
Morph.no-unq=DROP INDEX unq_%Morph.table%_morph;
Morph.insert=INSERT INTO %Morph.table% (morphid,morph) VALUES (?,?);
MorphMap.table=morphmaps
MorphMap.create=CREATE TABLE %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=ALTER TABLE %MorphMap.table% ADD CONSTRAINT pk_%MorphMap.table% PRIMARY KEY (morphid,pos,wordid);
MorphMap.no-pk=ALTER TABLE %MorphMap.table% DROP CONSTRAINT pk_%MorphMap.table% CASCADE;
MorphMap.index1=CREATE INDEX k_%MorphMap.table%_wordid ON %MorphMap.table% (wordid);
MorphMap.no-index1=DROP INDEX k_%MorphMap.table%_wordid;
MorphMap.index2=CREATE INDEX k_%MorphMap.table%_morphid ON %MorphMap.table% (morphid);
MorphMap.no-index2=DROP INDEX k_%MorphMap.table%_morphid;
MorphMap.fk1=ALTER TABLE %MorphMap.table% ADD CONSTRAINT fk_%MorphMap.table%_wordid FOREIGN KEY (wordid) REFERENCES %Word.table% (wordid);
MorphMap.no-fk1=ALTER TABLE %MorphMap.table% DROP CONSTRAINT fk_%MorphMap.table%_wordid CASCADE;
MorphMap.fk2=ALTER TABLE %MorphMap.table% ADD CONSTRAINT fk_%MorphMap.table%_morphid FOREIGN KEY (morphid) REFERENCES %Morph.table% (morphid);
MorphMap.no-fk2=ALTER TABLE %MorphMap.table% DROP CONSTRAINT fk_%MorphMap.table%_morphid CASCADE;
MorphMap.insert=INSERT INTO %MorphMap.table% (morphid,pos,wordid) VALUES (?,?,?);
AdjPosition.table=adjpositions
AdjPosition.create=CREATE TABLE %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=ALTER TABLE %AdjPosition.table% ADD CONSTRAINT pk_%AdjPosition.table% PRIMARY KEY (synsetid,wordid);
AdjPosition.no-pk=ALTER TABLE %AdjPosition.table% DROP CONSTRAINT pk_%AdjPosition.table% CASCADE;
AdjPosition.index1=CREATE INDEX k_%AdjPosition.table%_synsetid ON %AdjPosition.table% (synsetid);
AdjPosition.no-index1=DROP INDEX k_%AdjPosition.table%_synsetid;
AdjPosition.index2=CREATE INDEX k_%AdjPosition.table%_wordid ON %AdjPosition.table% (wordid);
AdjPosition.no-index2=DROP INDEX k_%AdjPosition.table%_wordid;
AdjPosition.fk1=ALTER TABLE %AdjPosition.table% ADD CONSTRAINT fk_%AdjPosition.table%_synsetid FOREIGN KEY (synsetid) REFERENCES %Synset.table% (synsetid);
AdjPosition.no-fk1=ALTER TABLE %AdjPosition.table% DROP CONSTRAINT fk_%AdjPosition.table%_synsetid CASCADE;
AdjPosition.fk2=ALTER TABLE %AdjPosition.table% ADD CONSTRAINT fk_%AdjPosition.table%_wordid FOREIGN KEY (wordid) REFERENCES %Word.table% (wordid);
AdjPosition.no-fk2=ALTER TABLE %AdjPosition.table% DROP CONSTRAINT fk_%AdjPosition.table%_wordid CASCADE;
AdjPosition.insert=INSERT INTO %AdjPosition.table% (synsetid,wordid,position) VALUES (?,?,?);
AdjPositionType.table=adjpositiontypes
AdjPositionType.create=CREATE TABLE %AdjPositionType.table% (position CHARACTER (2) NOT NULL,positionname VARCHAR (24) NOT NULL,CONSTRAINT pk_%AdjPositionType.table% PRIMARY KEY (position));
AdjPositionType.pk=ALTER TABLE %AdjPositionType.table% ADD CONSTRAINT pk_%AdjPositionType.table% PRIMARY KEY (position);
AdjPositionType.no-pk=ALTER TABLE %AdjPositionType.table% DROP CONSTRAINT pk_%AdjPositionType.table% CASCADE;
AdjPositionType.insert=INSERT INTO %AdjPositionType.table% (position,positionname) VALUES (?,?);
VFrame.table=vframes
VFrame.create=CREATE TABLE %VFrame.table% (frameid SMALLINT NOT NULL DEFAULT '0',frame VARCHAR (50) DEFAULT NULL,CONSTRAINT pk_%VFrame.table% PRIMARY KEY (frameid));
VFrame.pk=ALTER TABLE %VFrame.table% ADD CONSTRAINT pk_%VFrame.table% PRIMARY KEY (frameid);
VFrame.no-pk=ALTER TABLE %VFrame.table% DROP CONSTRAINT pk_%VFrame.table% CASCADE;
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 %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=ALTER TABLE %VFrameMap.table% ADD CONSTRAINT pk_%VFrameMap.table% PRIMARY KEY (synsetid,wordid,frameid);
VFrameMap.no-pk=ALTER TABLE %VFrameMap.table% DROP CONSTRAINT pk_%VFrameMap.table% CASCADE;
VFrameMap.index1=CREATE INDEX k_%VFrameMap.table%_frameid ON %VFrameMap.table% (frameid);
VFrameMap.no-index1=DROP INDEX k_%VFrameMap.table%_frameid;
VFrameMap.index2=CREATE INDEX k_%VFrameMap.table%_synsetid ON %VFrameMap.table% (synsetid);
VFrameMap.no-index2=DROP INDEX k_%VFrameMap.table%_synsetid;
VFrameMap.index3=CREATE INDEX k_%VFrameMap.table%_wordid ON %VFrameMap.table% (wordid);
VFrameMap.no-index3=DROP INDEX k_%VFrameMap.table%_wordid;
VFrameMap.fk1=ALTER TABLE %VFrameMap.table% ADD CONSTRAINT fk_%VFrameMap.table%_frameid FOREIGN KEY (frameid) REFERENCES %VFrame.table% (frameid);
VFrameMap.no-fk1=ALTER TABLE %VFrameMap.table% DROP CONSTRAINT fk_%VFrameMap.table%_frameid CASCADE;
VFrameMap.fk2=ALTER TABLE %VFrameMap.table% ADD CONSTRAINT fk_%VFrameMap.table%_synsetid FOREIGN KEY (synsetid) REFERENCES %Synset.table% (synsetid);
VFrameMap.no-fk2=ALTER TABLE %VFrameMap.table% DROP CONSTRAINT fk_%VFrameMap.table%_synsetid CASCADE;
VFrameMap.fk3=ALTER TABLE %VFrameMap.table% ADD CONSTRAINT fk_%VFrameMap.table%_wordid FOREIGN KEY (wordid) REFERENCES %Word.table% (wordid);
VFrameMap.no-fk3=ALTER TABLE %VFrameMap.table% DROP CONSTRAINT fk_%VFrameMap.table%_wordid CASCADE;
VFrameMap.insert=INSERT INTO %VFrameMap.table% (synsetid,wordid,frameid) VALUES (?,?,?);
VFrameSentence.table=vframesentences
VFrameSentence.create=CREATE TABLE %VFrameSentence.table% (sentenceid SMALLINT NOT NULL DEFAULT '0',sentence TEXT DEFAULT NULL,CONSTRAINT pk_%VFrameSentence.table% PRIMARY KEY (sentenceid));
VFrameSentence.pk=ALTER TABLE %VFrameSentence.table% ADD CONSTRAINT pk_%VFrameSentence.table% PRIMARY KEY (sentenceid);
VFrameSentence.no-pk=ALTER TABLE %VFrameSentence.table% DROP CONSTRAINT pk_%VFrameSentence.table% CASCADE;
VFrameSentence.insert=INSERT INTO %VFrameSentence.table% (sentenceid,sentence) VALUES (?,?);
VFrameSentenceMap.table=vframesentencemaps
VFrameSentenceMap.create=CREATE TABLE %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=ALTER TABLE %VFrameSentenceMap.table% ADD CONSTRAINT pk_%VFrameSentenceMap.table% PRIMARY KEY (synsetid,wordid,sentenceid);
VFrameSentenceMap.no-pk=ALTER TABLE %VFrameSentenceMap.table% DROP CONSTRAINT pk_%VFrameSentenceMap.table% CASCADE;
VFrameSentenceMap.index1=CREATE INDEX k_%VFrameSentenceMap.table%_sentenceid ON %VFrameSentenceMap.table% (sentenceid);
VFrameSentenceMap.no-index1=DROP INDEX k_%VFrameSentenceMap.table%_sentenceid;
VFrameSentenceMap.index2=CREATE INDEX k_%VFrameSentenceMap.table%_synsetid ON %VFrameSentenceMap.table% (synsetid);
VFrameSentenceMap.no-index2=DROP INDEX k_%VFrameSentenceMap.table%_synsetid;
VFrameSentenceMap.index3=CREATE INDEX k_%VFrameSentenceMap.table%_wordid ON %VFrameSentenceMap.table% (wordid);
VFrameSentenceMap.no-index3=DROP INDEX k_%VFrameSentenceMap.table%_wordid;
VFrameSentenceMap.fk1=ALTER TABLE %VFrameSentenceMap.table% ADD CONSTRAINT fk_%VFrameSentenceMap.table%_sentenceid FOREIGN KEY (sentenceid) REFERENCES %VFrameSentence.table% (sentenceid);
VFrameSentenceMap.no-fk1=ALTER TABLE %VFrameSentenceMap.table% DROP CONSTRAINT fk_%VFrameSentenceMap.table%_sentenceid CASCADE;
VFrameSentenceMap.fk2=ALTER TABLE %VFrameSentenceMap.table% ADD CONSTRAINT fk_%VFrameSentenceMap.table%_synsetid FOREIGN KEY (synsetid) REFERENCES %Synset.table% (synsetid);
VFrameSentenceMap.no-fk2=ALTER TABLE %VFrameSentenceMap.table% DROP CONSTRAINT fk_%VFrameSentenceMap.table%_synsetid CASCADE;
VFrameSentenceMap.fk3=ALTER TABLE %VFrameSentenceMap.table% ADD CONSTRAINT fk_%VFrameSentenceMap.table%_wordid FOREIGN KEY (wordid) REFERENCES %Word.table% (wordid);
VFrameSentenceMap.no-fk3=ALTER TABLE %VFrameSentenceMap.table% DROP CONSTRAINT fk_%VFrameSentenceMap.table%_wordid CASCADE;
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 s.synsetid,array_to_string(ARRAY (SELECT %Sample.table%.sample FROM %Sample.table% WHERE synsetid = s.synsetid ORDER BY sampleid),'|') AS sampleset FROM %Sample.table% AS s GROUP BY s.synsetid ORDER BY s.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);