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

Download this file

test.properties    271 lines (249 with data), 20.3 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
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
VnClass.table=vnclasses
VnClass.create=CREATE TABLE IF NOT EXISTS %VnClass.table% (classid SMALLINT NOT NULL,class VARCHAR (64) NOT NULL,CONSTRAINT pk_%VnClass.table% PRIMARY KEY (classid));
VnClass.pk=
VnClass.no-pk=
VnClass.unq=CREATE UNIQUE INDEX IF NOT EXISTS unq_%VnClass.table%_class ON %VnClass.table% (class);
VnClass.no-unq=DROP INDEX IF EXISTS unq_%VnClass.table%_class;
VnClass.insert=INSERT INTO %VnClass.table% (classid,class) VALUES (?,?);
VnClass.select=SELECT classid FROM %VnClass.table% WHERE class = ?;
VnClassMember.table=vnclassmembers
VnClassMember.create=CREATE TABLE IF NOT EXISTS %VnClassMember.table% (classid SMALLINT NOT NULL,wordid INTEGER NOT NULL DEFAULT 0,CONSTRAINT pk_%VnClassMember.table% PRIMARY KEY (classid,wordid));
VnClassMember.pk=
VnClassMember.no-pk=
VnClassMember.index1=CREATE INDEX IF NOT EXISTS k_%VnClassMember.table%_classid ON %VnClassMember.table% (classid);
VnClassMember.no-index1=DROP INDEX IF EXISTS k_%VnClassMember.table%_classid;
VnClassMember.index2=CREATE INDEX IF NOT EXISTS k_%VnClassMember.table%_wordid ON %VnClassMember.table% (wordid);
VnClassMember.no-index2=DROP INDEX IF EXISTS k_%VnClassMember.table%_wordid;
VnClassMember.fk1=
VnClassMember.no-fk1=
VnClassMember.fk2=
VnClassMember.no-fk2=
VnClassMember.insert=INSERT INTO %VnClassMember.table% (classid,wordid) VALUES (?,?);
VnClassMember.select=SELECT classid,wordid FROM %VnClassMember.table% WHERE classid = ? AND wordid = ?;
VnClassMemberSense.table=vnclassmembersenses
VnClassMemberSense.create=CREATE TABLE IF NOT EXISTS %VnClassMemberSense.table% (classid SMALLINT NOT NULL,wordid INTEGER NOT NULL DEFAULT 0,sensenum SMALLINT NOT NULL DEFAULT 0,synsetid INTEGER DEFAULT NULL,sensekey VARCHAR (100) DEFAULT NULL,quality FLOAT NOT NULL,CONSTRAINT pk_%VnClassMemberSense.table% PRIMARY KEY (classid,wordid,sensenum));
VnClassMemberSense.pk=
VnClassMemberSense.no-pk=
VnClassMemberSense.index1=CREATE INDEX IF NOT EXISTS k_%VnClassMemberSense.table%_classid ON %VnClassMemberSense.table% (classid);
VnClassMemberSense.no-index1=DROP INDEX IF EXISTS k_%VnClassMemberSense.table%_classid;
VnClassMemberSense.index2=CREATE INDEX IF NOT EXISTS k_%VnClassMemberSense.table%_wordid ON %VnClassMemberSense.table% (wordid);
VnClassMemberSense.no-index3=DROP INDEX IF EXISTS k_%VnClassMemberSense.table%_synsetid;
VnClassMemberSense.index3=CREATE INDEX IF NOT EXISTS k_%VnClassMemberSense.table%_synsetid ON %VnClassMemberSense.table% (synsetid);
VnClassMemberSense.no-index3=DROP INDEX IF EXISTS k_%VnClassMemberSense.table%_synsetid;
VnClassMemberSense.index4=CREATE INDEX IF NOT EXISTS k_%VnClassMemberSense.table%_sensekey ON %VnClassMemberSense.table% (sensekey);
VnClassMemberSense.no-index4=DROP INDEX IF EXISTS k_%VnClassMemberSense.table%_sensekey;
VnClassMemberSense.fk1=
VnClassMemberSense.no-fk1=
VnClassMemberSense.fk2=
VnClassMemberSense.no-fk2=
VnClassMemberSense.insert=INSERT INTO %VnClassMemberSense.table% (classid,wordid,sensenum,synsetid,sensekey,quality) VALUES (?,?,?,?,?,?);
VnClassMemberSense.select=SELECT classid,wordid,sensenum,synsetid,sensekey FROM %VnClassMemberSense.table% WHERE classid = ? AND wordid = ? AND (synsetid IS NULL OR synsetid = ?);
VnGrouping.table=vngroupings
VnGrouping.create=CREATE TABLE IF NOT EXISTS %VnGrouping.table% (groupingid SMALLINT NOT NULL,grouping VARCHAR (64) NOT NULL,CONSTRAINT pk_%VnGrouping.table% PRIMARY KEY (groupingid));
VnGrouping.pk=
VnGrouping.no-pk=
VnGrouping.unq=CREATE UNIQUE INDEX IF NOT EXISTS unq_%VnGrouping.table%_grouping ON %VnGrouping.table% (grouping);
VnGrouping.no-unq=DROP INDEX IF EXISTS unq_%VnGrouping.table%_grouping;
VnGrouping.insert=INSERT INTO %VnGrouping.table% (groupingid,grouping) VALUES (?,?);
VnGroupingMap.table=vngroupingmaps
VnGroupingMap.create=CREATE TABLE IF NOT EXISTS %VnGroupingMap.table% (groupingmapid INTEGER NOT NULL,classid SMALLINT NOT NULL,wordid INTEGER NOT NULL,groupingid SMALLINT NOT NULL,CONSTRAINT pk_%VnGroupingMap.table% PRIMARY KEY (groupingmapid));
VnGroupingMap.pk=
VnGroupingMap.no-pk=
VnGroupingMap.index1=CREATE INDEX IF NOT EXISTS k_%VnGroupingMap.table%_classid ON %VnGroupingMap.table% (classid);
VnGroupingMap.no-index1=DROP INDEX IF EXISTS k_%VnGroupingMap.table%_classid;
VnGroupingMap.index2=CREATE INDEX IF NOT EXISTS k_%VnGroupingMap.table%_wordid ON %VnGroupingMap.table% (wordid);
VnGroupingMap.no-index2=DROP INDEX IF EXISTS k_%VnGroupingMap.table%_wordid;
VnGroupingMap.index3=CREATE INDEX IF NOT EXISTS k_%VnGroupingMap.table%_groupingid ON %VnGroupingMap.table% (groupingid);
VnGroupingMap.no-index3=DROP INDEX IF EXISTS k_%VnGroupingMap.table%_groupingid;
VnGroupingMap.fk1=
VnGroupingMap.no-fk1=
VnGroupingMap.fk2=
VnGroupingMap.no-fk2=
VnGroupingMap.fk3=
VnGroupingMap.no-fk3=
VnGroupingMap.insert=INSERT INTO %VnGroupingMap.table% (groupingmapid,classid,wordid,groupingid) VALUES (?,?,?,?);
VnGroupingMap.select=SELECT groupingmapid FROM %VnGroupingMap.table% WHERE classid = ? AND wordid = ? AND groupingid = ?;
VnRole.table=vnroles
VnRole.create=CREATE TABLE IF NOT EXISTS %VnRole.table% (roleid SMALLINT NOT NULL,roletypeid SMALLINT NOT NULL,selrestrsid SMALLINT NOT NULL,CONSTRAINT pk_%VnRole.table% PRIMARY KEY (roleid));
VnRole.pk=
VnRole.no-pk=
VnRole.unq=CREATE UNIQUE INDEX IF NOT EXISTS unq_%VnRole.table%_roletypeid_selrestrsid ON %VnRole.table% (roletypeid,selrestrsid);
VnRole.no-unq=DROP INDEX IF EXISTS unq_%VnRole.table%_roletypeid_selrestrsid;
VnRole.index1=CREATE INDEX IF NOT EXISTS k_%VnRole.table%_roletypeid ON %VnRole.table% (roletypeid);
VnRole.no-index1=DROP INDEX IF EXISTS k_%VnRole.table%_roletypeid;
VnRole.index2=CREATE INDEX IF NOT EXISTS k_%VnRole.table%_selrestrsid ON %VnRole.table% (selrestrsid);
VnRole.no-index2=DROP INDEX IF EXISTS k_%VnRole.table%_selrestrsid;
VnRole.fk1=
VnRole.no-fk1=
VnRole.fk2=
VnRole.no-fk2=
VnRole.insert=INSERT INTO %VnRole.table% (roleid,roletypeid,selrestrsid) VALUES (?,?,?);
VnRoleMap.table=vnrolemaps
VnRoleMap.create=CREATE TABLE IF NOT EXISTS %VnRoleMap.table% (rolemapid INTEGER NOT NULL,wordid INTEGER NOT NULL,synsetid INTEGER DEFAULT NULL,roleid SMALLINT NOT NULL,classid SMALLINT NOT NULL,rquality FLOAT NOT NULL,CONSTRAINT pk_%VnRoleMap.table% PRIMARY KEY (rolemapid));
VnRoleMap.pk=
VnRoleMap.no-pk=
VnRoleMap.unq=CREATE UNIQUE INDEX IF NOT EXISTS unq_%VnRoleMap.table%_wordid_synsetid_roleid_classid_rquality ON %VnRoleMap.table% (wordid,synsetid,roleid,classid,rquality);
VnRoleMap.no-unq=DROP INDEX IF EXISTS unq_%VnRoleMap.table%_wordid_synsetid_roleid_classid_rquality;
VnRoleMap.index1=CREATE INDEX IF NOT EXISTS k_%VnRoleMap.table%_wordid ON %VnRoleMap.table% (wordid);
VnRoleMap.no-index1=DROP INDEX IF EXISTS k_%VnRoleMap.table%_wordid;
VnRoleMap.index2=CREATE INDEX IF NOT EXISTS k_%VnRoleMap.table%_synsetid ON %VnRoleMap.table% (synsetid);
VnRoleMap.no-index2=DROP INDEX IF EXISTS k_%VnRoleMap.table%_synsetid;
VnRoleMap.index3=CREATE INDEX IF NOT EXISTS k_%VnRoleMap.table%_roleid ON %VnRoleMap.table% (roleid);
VnRoleMap.no-index3=DROP INDEX IF EXISTS k_%VnRoleMap.table%_roleid;
VnRoleMap.index4=CREATE INDEX IF NOT EXISTS k_%VnRoleMap.table%_classid ON %VnRoleMap.table% (classid);
VnRoleMap.no-index4=DROP INDEX IF EXISTS k_%VnRoleMap.table%_classid;
VnRoleMap.fk1=
VnRoleMap.no-fk1=
VnRoleMap.fk2=
VnRoleMap.no-fk2=
VnRoleMap.fk3=
VnRoleMap.no-fk3=
VnRoleMap.fk4=
VnRoleMap.no-fk4=
VnRoleMap.insert=INSERT INTO %VnRoleMap.table% (rolemapid,wordid,synsetid,roleid,classid,rquality) VALUES (?,?,?,?,?,?);
VnRoleMap.select=SELECT rolemapid FROM %VnRoleMap.table% WHERE wordid = ? AND synsetid = ? AND roleid = ? AND classid = ? AND rquality = ?;
VnRoleType.table=vnroletypes
VnRoleType.create=CREATE TABLE IF NOT EXISTS %VnRoleType.table% (roletypeid SMALLINT NOT NULL,roletype VARCHAR (32) NOT NULL,CONSTRAINT pk_%VnRoleType.table% PRIMARY KEY (roletypeid));
VnRoleType.pk=
VnRoleType.no-pk=
VnRoleType.unq=CREATE UNIQUE INDEX IF NOT EXISTS unq_%VnRoleType.table%_roletype ON %VnRoleType.table% (roletype);
VnRoleType.no-unq=DROP INDEX IF EXISTS unq_%VnRoleType.table%_roletype;
VnRoleType.insert=INSERT INTO %VnRoleType.table% (roletypeid,roletype) VALUES (?,?);
VnSelRestrs.table=vnselrestrs
VnSelRestrs.create=CREATE TABLE IF NOT EXISTS %VnSelRestrs.table% (selrestrsid SMALLINT NOT NULL,selrestrs TEXT NOT NULL,CONSTRAINT pk_%VnSelRestrs.table% PRIMARY KEY (selrestrsid));
VnSelRestrs.pk=
VnSelRestrs.no-pk=
VnSelRestrs.unq=CREATE UNIQUE INDEX IF NOT EXISTS unq_%VnSelRestrs.table%_selrestrs ON %VnSelRestrs.table% (selrestrs);
VnSelRestrs.no-unq=DROP INDEX IF EXISTS unq_%VnSelRestrs.table%_selrestrs;
VnSelRestrs.insert=INSERT INTO %VnSelRestrs.table% (selrestrsid,selrestrs) VALUES (?,?);
VnSelRestrType.table=vnselrestrtypes
VnSelRestrType.create=CREATE TABLE IF NOT EXISTS %VnSelRestrType.table% (selrestrid SMALLINT NOT NULL,selrestrval VARCHAR (32) NOT NULL,selrestr VARCHAR (32) NOT NULL,CONSTRAINT pk_%VnSelRestrType.table% PRIMARY KEY (selrestrid));
VnSelRestrType.pk=
VnSelRestrType.no-pk=
VnSelRestrType.unq=CREATE UNIQUE INDEX IF NOT EXISTS unq_%VnSelRestrType.table%_selrestrval_selrestr ON %VnSelRestrType.table% (selrestrval,selrestr);
VnSelRestrType.no-unq=DROP INDEX IF EXISTS unq_%VnSelRestrType.table%_selrestrval_selrestr;
VnSelRestrType.insert=INSERT INTO %VnSelRestrType.table% (selrestrid,selrestrval,selrestr) VALUES (?,?,?);
VnFrame.table=vnframes
VnFrame.create=CREATE TABLE IF NOT EXISTS %VnFrame.table% (frameid INTEGER NOT NULL,number VARCHAR (16) NULL,xtag VARCHAR (16) NULL,nameid SMALLINT NOT NULL,subnameid SMALLINT NOT NULL,syntaxid INTEGER NOT NULL,semanticsid INTEGER NOT NULL,CONSTRAINT pk_%VnFrame.table% PRIMARY KEY (frameid));
VnFrame.pk=
VnFrame.no-pk=
VnFrame.unq=CREATE UNIQUE INDEX IF NOT EXISTS unq_%VnFrame.table%_number_xtag_nameid_subnameid_syntaxid_semanticsid ON %VnFrame.table% (number,xtag,nameid,subnameid,syntaxid,semanticsid);
VnFrame.no-unq=DROP INDEX IF EXISTS unq_%VnFrame.table%_number_xtag_nameid_subnameid_syntaxid_semanticsid;
VnFrame.index1=CREATE INDEX IF NOT EXISTS k_%VnFrame.table%_nameid ON %VnFrame.table% (nameid);
VnFrame.no-index1=DROP INDEX IF EXISTS k_%VnFrame.table%_nameid;
VnFrame.index2=CREATE INDEX IF NOT EXISTS k_%VnFrame.table%_subnameid ON %VnFrame.table% (subnameid);
VnFrame.no-index2=DROP INDEX IF EXISTS k_%VnFrame.table%_subnameid;
VnFrame.index3=CREATE INDEX IF NOT EXISTS k_%VnFrame.table%_syntaxid ON %VnFrame.table% (syntaxid);
VnFrame.no-index3=DROP INDEX IF EXISTS k_%VnFrame.table%_syntaxid;
VnFrame.index4=CREATE INDEX IF NOT EXISTS k_%VnFrame.table%_semanticsid ON %VnFrame.table% (semanticsid);
VnFrame.no-index4=DROP INDEX IF EXISTS k_%VnFrame.table%_semanticsid;
VnFrame.fk1=
VnFrame.no-fk1=
VnFrame.fk2=
VnFrame.no-fk2=
VnFrame.fk3=
VnFrame.no-fk3=
VnFrame.fk4=
VnFrame.no-fk4=
VnFrame.insert=INSERT INTO %VnFrame.table% (frameid,number,xtag,nameid,subnameid,syntaxid,semanticsid) VALUES (?,?,?,?,?,?,?);
VnFrameMap.table=vnframemaps
VnFrameMap.create=CREATE TABLE IF NOT EXISTS %VnFrameMap.table% (framemapid INTEGER NOT NULL,wordid INTEGER NOT NULL,synsetid INTEGER DEFAULT NULL,classid SMALLINT NOT NULL,frameid INTEGER NOT NULL,fquality FLOAT NOT NULL,CONSTRAINT pk_%VnFrameMap.table% PRIMARY KEY (framemapid));
VnFrameMap.pk=
VnFrameMap.no-pk=
VnFrameMap.unq=CREATE UNIQUE INDEX IF NOT EXISTS unq_%VnFrameMap.table%_wordid_synsetid_classid_frameid_fquality ON %VnFrameMap.table% (wordid,synsetid,classid,frameid,fquality);
VnFrameMap.no-unq=DROP INDEX IF EXISTS unq_%VnFrameMap.table%_wordid_synsetid_classid_frameid_fquality;
VnFrameMap.index1=CREATE INDEX IF NOT EXISTS k_%VnFrameMap.table%_wordid ON %VnFrameMap.table% (wordid);
VnFrameMap.no-index1=DROP INDEX IF EXISTS k_%VnFrameMap.table%_wordid;
VnFrameMap.index2=CREATE INDEX IF NOT EXISTS k_%VnFrameMap.table%_synsetid ON %VnFrameMap.table% (synsetid);
VnFrameMap.no-index2=DROP INDEX IF EXISTS k_%VnFrameMap.table%_synsetid;
VnFrameMap.index3=CREATE INDEX IF NOT EXISTS k_%VnFrameMap.table%_classid ON %VnFrameMap.table% (classid);
VnFrameMap.no-index3=DROP INDEX IF EXISTS k_%VnFrameMap.table%_classid;
VnFrameMap.index4=CREATE INDEX IF NOT EXISTS k_%VnFrameMap.table%_frameid ON %VnFrameMap.table% (frameid);
VnFrameMap.no-index4=DROP INDEX IF EXISTS k_%VnFrameMap.table%_frameid;
VnFrameMap.fk1=
VnFrameMap.no-fk1=
VnFrameMap.fk2=
VnFrameMap.no-fk2=
VnFrameMap.fk3=
VnFrameMap.no-fk3=
VnFrameMap.fk4=
VnFrameMap.no-fk4=
VnFrameMap.insert=INSERT INTO %VnFrameMap.table% (framemapid,wordid,synsetid,classid,frameid,fquality) VALUES (?,?,?,?,?,?);
VnFrameMap.select=SELECT framemapid FROM %VnFrameMap.table% WHERE wordid = ? AND synsetid = ? AND classid = ? AND frameid= ? AND fquality= ?;
VnFrameName.table=vnframenames
VnFrameName.create=CREATE TABLE IF NOT EXISTS %VnFrameName.table% (nameid SMALLINT NOT NULL,framename VARCHAR (64) NOT NULL,CONSTRAINT pk_%VnFrameName.table% PRIMARY KEY (nameid));
VnFrameName.pk=
VnFrameName.no-pk=
VnFrameName.unq=CREATE UNIQUE INDEX IF NOT EXISTS unq_%VnFrameName.table%_framename ON %VnFrameName.table% (framename);
VnFrameName.no-unq=DROP INDEX IF EXISTS unq_%VnFrameName.table%_framename;
VnFrameName.insert=INSERT INTO %VnFrameName.table% (nameid,framename) VALUES (?,?);
VnFrameSubName.table=vnframesubnames
VnFrameSubName.create=CREATE TABLE IF NOT EXISTS %VnFrameSubName.table% (subnameid SMALLINT NOT NULL,framesubname VARCHAR (64) NOT NULL,CONSTRAINT pk_%VnFrameSubName.table% PRIMARY KEY (subnameid));
VnFrameSubName.pk=
VnFrameSubName.no-pk=
VnFrameSubName.unq=CREATE UNIQUE INDEX IF NOT EXISTS unq_%VnFrameSubName.table%_framesubname ON %VnFrameSubName.table% (framesubname);
VnFrameSubName.no-unq=DROP INDEX IF EXISTS unq_%VnFrameSubName.table%_framesubname;
VnFrameSubName.insert=INSERT INTO %VnFrameSubName.table% (subnameid,framesubname) VALUES (?,?);
VnSyntax.table=vnsyntaxes
VnSyntax.create=CREATE TABLE IF NOT EXISTS %VnSyntax.table% (syntaxid INTEGER NOT NULL,syntax TEXT NOT NULL,CONSTRAINT pk_%VnSyntax.table% PRIMARY KEY (syntaxid));
VnSyntax.pk=
VnSyntax.no-pk=
VnSyntax.unq=CREATE UNIQUE INDEX IF NOT EXISTS unq_%VnSyntax.table%_syntax ON %VnSyntax.table% (syntax);
VnSyntax.no-unq=DROP INDEX IF EXISTS unq_%VnSyntax.table%_syntax;
VnSyntax.insert=INSERT INTO %VnSyntax.table% (syntaxid,syntax) VALUES (?,?);
VnSemantics.table=vnsemantics
VnSemantics.create=CREATE TABLE IF NOT EXISTS %VnSemantics.table% (semanticsid INTEGER NOT NULL,semantics TEXT NOT NULL,CONSTRAINT pk_%VnSemantics.table% PRIMARY KEY (semanticsid));
VnSemantics.pk=
VnSemantics.no-pk=
VnSemantics.unq=CREATE UNIQUE INDEX IF NOT EXISTS unq_%VnSemantics.table%_semantics ON %VnSemantics.table% (semantics);
VnSemantics.no-unq=DROP INDEX IF EXISTS unq_%VnSemantics.table%_semantics;
VnSemantics.insert=INSERT INTO %VnSemantics.table% (semanticsid,semantics) VALUES (?,?);
VnPredicate.table=vnpredicates
VnPredicate.create=CREATE TABLE IF NOT EXISTS %VnPredicate.table% (predid SMALLINT NOT NULL,pred VARCHAR (128) NOT NULL,CONSTRAINT pk_%VnPredicate.table% PRIMARY KEY (predid));
VnPredicate.pk=
VnPredicate.no-pk=
VnPredicate.unq=CREATE UNIQUE INDEX IF NOT EXISTS unq_%VnPredicate.table%_pred ON %VnPredicate.table% (pred);
VnPredicate.no-unq=DROP INDEX IF EXISTS unq_%VnPredicate.table%_pred;
VnPredicate.insert=INSERT INTO %VnPredicate.table% (predid,pred) VALUES (?,?);
VnPredicateMap.table=vnpredicatemaps
VnPredicateMap.create=CREATE TABLE IF NOT EXISTS %VnPredicateMap.table% (semanticsid INTEGER NOT NULL,predid SMALLINT NOT NULL,CONSTRAINT pk_%VnPredicateMap.table% PRIMARY KEY (semanticsid,predid));
VnPredicateMap.pk=
VnPredicateMap.no-pk=
VnPredicateMap.index1=CREATE INDEX IF NOT EXISTS k_%VnPredicateMap.table%_semanticsid ON %VnPredicateMap.table% (semanticsid);
VnPredicateMap.no-index1=DROP INDEX IF EXISTS k_%VnPredicateMap.table%_semanticsid;
VnPredicateMap.index2=CREATE INDEX IF NOT EXISTS k_%VnPredicateMap.table%_predid ON %VnPredicateMap.table% (predid);
VnPredicateMap.no-index2=DROP INDEX IF EXISTS k_%VnPredicateMap.table%_predid;
VnPredicateMap.fk1=
VnPredicateMap.no-fk1=
VnPredicateMap.fk2=
VnPredicateMap.no-fk2=
VnPredicateMap.insert=INSERT INTO %VnPredicateMap.table% (semanticsid,predid) VALUES (?,?);
VnExample.table=vnexamples
VnExample.create=CREATE TABLE IF NOT EXISTS %VnExample.table% (exampleid SMALLINT NOT NULL,example VARCHAR (128) NOT NULL,CONSTRAINT pk_%VnExample.table% PRIMARY KEY (exampleid));
VnExample.pk=
VnExample.no-pk=
VnExample.unq=CREATE UNIQUE INDEX IF NOT EXISTS unq_%VnExample.table%_example ON %VnExample.table% (example);
VnExample.no-unq=DROP INDEX IF EXISTS unq_%VnExample.table%_example;
VnExample.insert=INSERT INTO %VnExample.table% (exampleid,example) VALUES (?,?);
VnExampleMap.table=vnexamplemaps
VnExampleMap.create=CREATE TABLE IF NOT EXISTS %VnExampleMap.table% (frameid INTEGER NOT NULL,exampleid SMALLINT NOT NULL,CONSTRAINT pk_%VnExampleMap.table% PRIMARY KEY (frameid,exampleid));
VnExampleMap.pk=
VnExampleMap.no-pk=
VnExampleMap.index1=CREATE INDEX IF NOT EXISTS k_%VnExampleMap.table%_frameid ON %VnExampleMap.table% (frameid);
VnExampleMap.no-index1=DROP INDEX IF EXISTS k_%VnExampleMap.table%_frameid;
VnExampleMap.index2=CREATE INDEX IF NOT EXISTS k_%VnExampleMap.table%_exampleid ON %VnExampleMap.table% (exampleid);
VnExampleMap.no-index2=DROP INDEX IF EXISTS k_%VnExampleMap.table%_exampleid;
VnExampleMap.fk1=
VnExampleMap.no-fk1=
VnExampleMap.fk2=
VnExampleMap.no-fk2=
VnExampleMap.insert=INSERT INTO %VnExampleMap.table% (frameid,exampleid) VALUES (?,?);
Vn.SenseMap.select=SELECT %LegacySenseMap.table.base%$XY$.synsetid,%LegacySense.table.base%$X$.sensekey FROM %LegacySenseMap.table.base%$XY$ INNER JOIN %LegacySense.table.base%$X$ ON %LegacySenseMap.table.base%$XY$.srcsynsetid = %LegacySense.table.base%$X$.synsetid WHERE %LegacySense.table.base%$X$.sensekey LIKE ? ESCAPE '/';
Vn.SynsetMap.select=SELECT %LegacySynsetMap.table.base%$XY$.synsetid,%LegacySense.table.base%$X$.sensekey FROM %LegacySynsetMap.table.base%$XY$ INNER JOIN %LegacySense.table.base%$X$ ON %LegacySynsetMap.table.base%$XY$.srcsynsetid = %LegacySense.table.base%$X$.synsetid WHERE %LegacySense.table.base%$X$.sensekey LIKE ? ESCAPE '/';
Vn.Sense.select=SELECT %Sense.table%$X$.synsetid,%Sense.table%$X$.sensekey FROM %Sense.table%$X$ WHERE %Sense.table%$X$.sensekey LIKE ? ESCAPE '/';
vn0.VnFrames.view=verbnetframes
vn0.VnFrames.createview=DROP VIEW IF EXISTS %vn0.VnFrames.view%; CREATE VIEW %vn0.VnFrames.view% AS SELECT * FROM %Sense.table% INNER JOIN %VnFrameMap.table% USING (wordid,synsetid) INNER JOIN %VnFrame.table% USING (frameid) INNER JOIN %VnSyntax.table% USING (syntaxid) INNER JOIN %VnSemantics.table% USING (semanticsid) INNER JOIN %VnFrameName.table% USING (nameid) LEFT JOIN %VnFrameSubName.table% USING (subnameid) LEFT JOIN %VnExampleMap.table% USING (frameid) LEFT JOIN %VnExample.table% USING (exampleid) INNER JOIN %VnClass.table% USING (classid) LEFT JOIN %Word.table% USING (wordid) LEFT JOIN %Synset.table% USING (synsetid);
vn0.VnRoles.view=verbnetroles
vn0.VnRoles.createview=DROP VIEW IF EXISTS %vn0.VnRoles.view%; CREATE VIEW %vn0.VnRoles.view% AS SELECT * FROM %Sense.table% INNER JOIN %VnRoleMap.table% USING (wordid,synsetid) INNER JOIN %VnRole.table% USING (roleid) INNER JOIN %VnRoleType.table% USING (roletypeid) LEFT JOIN %VnSelRestrs.table% USING (selrestrsid) INNER JOIN %VnClass.table% USING (classid) LEFT JOIN %Word.table% USING (wordid) LEFT JOIN %Synset.table% USING (synsetid);
vn0.VnRolesFrames.view=verbnetrolesframes
vn0.VnRolesFrames.createview=DROP VIEW IF EXISTS %vn0.VnRolesFrames.view%; CREATE VIEW %vn0.VnRolesFrames.view% AS SELECT * FROM %VnRoleMap.table% INNER JOIN %VnFrameMap.table% USING (wordid,synsetid,classid) INNER JOIN %VnRole.table% USING (roleid) INNER JOIN %VnRoleType.table% USING (roletypeid) LEFT JOIN %VnSelRestrs.table% USING (selrestrsid) INNER JOIN %VnFrame.table% USING (frameid) INNER JOIN %VnSyntax.table% USING (syntaxid) INNER JOIN %VnSemantics.table% USING (semanticsid) INNER JOIN %VnFrameName.table% USING (nameid) LEFT JOIN %VnFrameSubName.table% USING (subnameid) LEFT JOIN %VnExampleMap.table% USING (frameid) LEFT JOIN %VnExample.table% USING (exampleid) INNER JOIN %VnClass.table% USING (classid) LEFT JOIN %Sense.table% USING (wordid,synsetid) LEFT JOIN %Word.table% USING (wordid) LEFT JOIN %Synset.table% USING (synsetid);