[d3657c]: / verbnet / src / main / resources / org / wnsql / builder / verbnet / template.properties  Maximize  Restore  History

Download this file

271 lines (249 with data), 29.0 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 UNSIGNED NOT NULL,class VARCHAR (64) NOT NULL,PRIMARY KEY (classid));
VnClass.pk=ALTER TABLE %VnClass.table% ADD CONSTRAINT pk_%VnClass.table% PRIMARY KEY (classid);
VnClass.no-pk=ALTER TABLE %VnClass.table% DROP CONSTRAINT pk_%VnClass.table% CASCADE;
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 UNSIGNED NOT NULL,wordid INTEGER UNSIGNED NOT NULL DEFAULT 0,PRIMARY KEY (classid,wordid));
VnClassMember.pk=ALTER TABLE %VnClassMember.table% ADD CONSTRAINT pk_%VnClassMember.table% PRIMARY KEY (classid,wordid);
VnClassMember.no-pk=ALTER TABLE %VnClassMember.table% DROP CONSTRAINT pk_%VnClassMember.table% CASCADE;
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=ALTER TABLE %VnClassMember.table% ADD CONSTRAINT fk_%VnClassMember.table%_classid FOREIGN KEY (classid) REFERENCES %VnClass.table% (classid);
VnClassMember.no-fk1=ALTER TABLE %VnClassMember.table% DROP CONSTRAINT fk_%VnClassMember.table%_classid CASCADE;
VnClassMember.fk2=ALTER TABLE %VnClassMember.table% ADD CONSTRAINT fk_%VnClassMember.table%_wordid FOREIGN KEY (wordid) REFERENCES %Word.table% (wordid);
VnClassMember.no-fk2=ALTER TABLE %VnClassMember.table% DROP CONSTRAINT fk_%VnClassMember.table%_wordid CASCADE;
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 UNSIGNED NOT NULL,wordid INTEGER UNSIGNED NOT NULL DEFAULT 0,sensenum SMALLINT UNSIGNED NOT NULL DEFAULT 0,synsetid INTEGER UNSIGNED DEFAULT NULL,sensekey VARCHAR (100) DEFAULT NULL,quality FLOAT NOT NULL,PRIMARY KEY (classid,wordid,sensenum));
VnClassMemberSense.pk=ALTER TABLE %VnClassMemberSense.table% ADD CONSTRAINT pk_%VnClassMemberSense.table% PRIMARY KEY (classid,wordid,sensenum);
VnClassMemberSense.no-pk=ALTER TABLE %VnClassMemberSense.table% DROP CONSTRAINT pk_%VnClassMemberSense.table% CASCADE;
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-index2=DROP INDEX IF EXISTS k_%VnClassMemberSense.table%_wordid;
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=ALTER TABLE %VnClassMemberSense.table% ADD CONSTRAINT fk_%VnClassMemberSense.table%_classid FOREIGN KEY (classid) REFERENCES %VnClass.table% (classid);
VnClassMemberSense.no-fk1=ALTER TABLE %VnClassMemberSense.table% DROP CONSTRAINT fk_%VnClassMemberSense.table%_classid CASCADE;
VnClassMemberSense.fk2=ALTER TABLE %VnClassMemberSense.table% ADD CONSTRAINT fk_%VnClassMemberSense.table%_wordid FOREIGN KEY (wordid) REFERENCES %Word.table% (wordid);
VnClassMemberSense.no-fk2=ALTER TABLE %VnClassMemberSense.table% DROP CONSTRAINT fk_%VnClassMemberSense.table%_wordid CASCADE;
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 UNSIGNED NOT NULL,grouping VARCHAR (64) NOT NULL,PRIMARY KEY (groupingid));
VnGrouping.pk=ALTER TABLE %VnGrouping.table% ADD CONSTRAINT pk_%VnGrouping.table% PRIMARY KEY (groupingid);
VnGrouping.no-pk=ALTER TABLE %VnGrouping.table% DROP CONSTRAINT pk_%VnGrouping.table% CASCADE;
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 UNSIGNED NOT NULL,classid SMALLINT UNSIGNED NOT NULL,wordid INTEGER UNSIGNED NOT NULL,groupingid SMALLINT UNSIGNED NOT NULL,PRIMARY KEY (groupingmapid));
VnGroupingMap.pk=ALTER TABLE %VnGroupingMap.table% ADD CONSTRAINT pk_%VnGroupingMap.table% PRIMARY KEY (groupingmapid);
VnGroupingMap.no-pk=ALTER TABLE %VnGroupingMap.table% DROP CONSTRAINT pk_%VnGroupingMap.table% CASCADE;
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=ALTER TABLE %VnGroupingMap.table% ADD CONSTRAINT fk_%VnGroupingMap.table%_classid FOREIGN KEY (classid) REFERENCES %VnClass.table% (classid);
VnGroupingMap.no-fk1=ALTER TABLE %VnGroupingMap.table% DROP CONSTRAINT fk_%VnGroupingMap.table%_classid CASCADE;
VnGroupingMap.fk2=ALTER TABLE %VnGroupingMap.table% ADD CONSTRAINT fk_%VnGroupingMap.table%_wordid FOREIGN KEY (wordid) REFERENCES %Word.table% (wordid);
VnGroupingMap.no-fk2=ALTER TABLE %VnGroupingMap.table% DROP CONSTRAINT fk_%VnGroupingMap.table%_wordid CASCADE;
VnGroupingMap.fk3=ALTER TABLE %VnGroupingMap.table% ADD CONSTRAINT fk_%VnGroupingMap.table%_groupingid FOREIGN KEY (groupingid) REFERENCES %VnGrouping.table% (groupingid);
VnGroupingMap.no-fk3=ALTER TABLE %VnGroupingMap.table% DROP CONSTRAINT fk_%VnGroupingMap.table%_groupingid CASCADE;
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 UNSIGNED NOT NULL,roletypeid SMALLINT UNSIGNED NOT NULL,selrestrsid SMALLINT UNSIGNED NOT NULL,PRIMARY KEY (roleid));
VnRole.pk=ALTER TABLE %VnRole.table% ADD CONSTRAINT pk_%VnRole.table% PRIMARY KEY (roleid);
VnRole.no-pk=ALTER TABLE %VnRole.table% DROP CONSTRAINT pk_%VnRole.table% CASCADE;
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=ALTER TABLE %VnRole.table% ADD CONSTRAINT fk_%VnRole.table%_roletypeid FOREIGN KEY (roletypeid) REFERENCES %VnRoleType.table% (roletypeid);
VnRole.no-fk1=ALTER TABLE %VnRole.table% DROP CONSTRAINT fk_%VnRole.table%_roletypeid CASCADE;
VnRole.fk2=ALTER TABLE %VnRole.table% ADD CONSTRAINT fk_%VnRole.table%_selrestrsid FOREIGN KEY (selrestrsid) REFERENCES %VnSelRestrs.table% (selrestrsid);
VnRole.no-fk2=ALTER TABLE %VnRole.table% DROP CONSTRAINT fk_%VnRole.table%_selrestrsid CASCADE;
VnRole.insert=INSERT INTO %VnRole.table% (roleid,roletypeid,selrestrsid) VALUES (?,?,?);
VnRoleMap.table=vnrolemaps
VnRoleMap.create=CREATE TABLE IF NOT EXISTS %VnRoleMap.table% (rolemapid INTEGER UNSIGNED NOT NULL,wordid INTEGER UNSIGNED NOT NULL,synsetid INTEGER UNSIGNED DEFAULT NULL,roleid SMALLINT UNSIGNED NOT NULL,classid SMALLINT UNSIGNED NOT NULL,rquality FLOAT NOT NULL,PRIMARY KEY (rolemapid));
VnRoleMap.pk=ALTER TABLE %VnRoleMap.table% ADD CONSTRAINT pk_%VnRoleMap.table% PRIMARY KEY (rolemapid);
VnRoleMap.no-pk=ALTER TABLE %VnRoleMap.table% DROP CONSTRAINT pk_%VnRoleMap.table% CASCADE;
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=ALTER TABLE %VnRoleMap.table% ADD CONSTRAINT fk_%VnRoleMap.table%_wordid FOREIGN KEY (wordid) REFERENCES %Word.table% (wordid);
VnRoleMap.no-fk1=ALTER TABLE %VnRoleMap.table% DROP CONSTRAINT fk_%VnRoleMap.table%_wordid CASCADE;
VnRoleMap.fk2=ALTER TABLE %VnRoleMap.table% ADD CONSTRAINT fk_%VnRoleMap.table%_synsetid FOREIGN KEY (synsetid) REFERENCES %Synset.table% (synsetid);
VnRoleMap.no-fk2=ALTER TABLE %VnRoleMap.table% DROP CONSTRAINT fk_%VnRoleMap.table%_synsetid CASCADE;
VnRoleMap.fk3=ALTER TABLE %VnRoleMap.table% ADD CONSTRAINT fk_%VnRoleMap.table%_roleid FOREIGN KEY (roleid) REFERENCES %VnRole.table% (roleid);
VnRoleMap.no-fk3=ALTER TABLE %VnRoleMap.table% DROP CONSTRAINT fk_%VnRoleMap.table%_roleid CASCADE;
VnRoleMap.fk4=ALTER TABLE %VnRoleMap.table% ADD CONSTRAINT fk_%VnRoleMap.table%_classid FOREIGN KEY (classid) REFERENCES %VnClass.table% (classid);
VnRoleMap.no-fk4=ALTER TABLE %VnRoleMap.table% DROP CONSTRAINT fk_%VnRoleMap.table%_classid CASCADE;
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 UNSIGNED NOT NULL,roletype VARCHAR (32) NOT NULL,PRIMARY KEY (roletypeid));
VnRoleType.pk=ALTER TABLE %VnRoleType.table% ADD CONSTRAINT pk_%VnRoleType.table% PRIMARY KEY (roletypeid);
VnRoleType.no-pk=ALTER TABLE %VnRoleType.table% DROP CONSTRAINT pk_%VnRoleType.table% CASCADE;
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 UNSIGNED NOT NULL,selrestrs TEXT NOT NULL,PRIMARY KEY (selrestrsid));
VnSelRestrs.pk=ALTER TABLE %VnSelRestrs.table% ADD CONSTRAINT pk_%VnSelRestrs.table% PRIMARY KEY (selrestrsid);
VnSelRestrs.no-pk=ALTER TABLE %VnSelRestrs.table% DROP CONSTRAINT pk_%VnSelRestrs.table% CASCADE;
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 UNSIGNED NOT NULL,selrestrval VARCHAR (32) NOT NULL,selrestr VARCHAR (32) NOT NULL,PRIMARY KEY (selrestrid));
VnSelRestrType.pk=ALTER TABLE %VnSelRestrType.table% ADD CONSTRAINT pk_%VnSelRestrType.table% PRIMARY KEY (selrestrid);
VnSelRestrType.no-pk=ALTER TABLE %VnSelRestrType.table% DROP CONSTRAINT pk_%VnSelRestrType.table% CASCADE;
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 UNSIGNED NOT NULL,number VARCHAR (16) NULL,xtag VARCHAR (16) NULL,nameid SMALLINT UNSIGNED NOT NULL,subnameid SMALLINT UNSIGNED NOT NULL,syntaxid INTEGER UNSIGNED NOT NULL,semanticsid INTEGER UNSIGNED NOT NULL,PRIMARY KEY (frameid));
VnFrame.pk=ALTER TABLE %VnFrame.table% ADD CONSTRAINT pk_%VnFrame.table% PRIMARY KEY (frameid);
VnFrame.no-pk=ALTER TABLE %VnFrame.table% DROP CONSTRAINT pk_%VnFrame.table% CASCADE;
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=ALTER TABLE %VnFrame.table% ADD CONSTRAINT fk_%VnFrame.table%_nameid FOREIGN KEY (nameid) REFERENCES %VnFrameName.table% (nameid);
VnFrame.no-fk1=ALTER TABLE %VnFrame.table% DROP CONSTRAINT fk_%VnFrame.table%_nameid CASCADE;
VnFrame.fk2=ALTER TABLE %VnFrame.table% ADD CONSTRAINT fk_%VnFrame.table%_subnameid FOREIGN KEY (subnameid) REFERENCES %VnFrameSubName.table% (subnameid);
VnFrame.no-fk2=ALTER TABLE %VnFrame.table% DROP CONSTRAINT fk_%VnFrame.table%_subnameid CASCADE;
VnFrame.fk3=ALTER TABLE %VnFrame.table% ADD CONSTRAINT fk_%VnFrame.table%_syntaxid FOREIGN KEY (syntaxid) REFERENCES %VnSyntax.table% (syntaxid);
VnFrame.no-fk3=ALTER TABLE %VnFrame.table% DROP CONSTRAINT fk_%VnFrame.table%_syntaxid CASCADE;
VnFrame.fk4=ALTER TABLE %VnFrame.table% ADD CONSTRAINT fk_%VnFrame.table%_semanticsid FOREIGN KEY (semanticsid) REFERENCES %VnSemantics.table% (semanticsid);
VnFrame.no-fk4=ALTER TABLE %VnFrame.table% DROP CONSTRAINT fk_%VnFrame.table%_semanticsid CASCADE;
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 UNSIGNED NOT NULL,wordid INTEGER UNSIGNED NOT NULL,synsetid INTEGER UNSIGNED DEFAULT NULL,classid SMALLINT UNSIGNED NOT NULL,frameid INTEGER UNSIGNED NOT NULL,fquality FLOAT NOT NULL,PRIMARY KEY (framemapid));
VnFrameMap.pk=ALTER TABLE %VnFrameMap.table% ADD CONSTRAINT pk_%VnFrameMap.table% PRIMARY KEY (framemapid);
VnFrameMap.no-pk=ALTER TABLE %VnFrameMap.table% DROP CONSTRAINT pk_%VnFrameMap.table% CASCADE;
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=ALTER TABLE %VnFrameMap.table% ADD CONSTRAINT fk_%VnFrameMap.table%_wordid FOREIGN KEY (wordid) REFERENCES %Word.table% (wordid);
VnFrameMap.no-fk1=ALTER TABLE %VnFrameMap.table% DROP CONSTRAINT fk_%VnFrameMap.table%_wordid CASCADE;
VnFrameMap.fk2=ALTER TABLE %VnFrameMap.table% ADD CONSTRAINT fk_%VnFrameMap.table%_synsetid FOREIGN KEY (synsetid) REFERENCES %Synset.table% (synsetid);
VnFrameMap.no-fk2=ALTER TABLE %VnFrameMap.table% DROP CONSTRAINT fk_%VnFrameMap.table%_synsetid CASCADE;
VnFrameMap.fk3=ALTER TABLE %VnFrameMap.table% ADD CONSTRAINT fk_%VnFrameMap.table%_classid FOREIGN KEY (classid) REFERENCES %VnClass.table% (classid);
VnFrameMap.no-fk3=ALTER TABLE %VnFrameMap.table% DROP CONSTRAINT fk_%VnFrameMap.table%_classid CASCADE;
VnFrameMap.fk4=ALTER TABLE %VnFrameMap.table% ADD CONSTRAINT fk_%VnFrameMap.table%_frameid FOREIGN KEY (frameid) REFERENCES %VnFrame.table% (frameid);
VnFrameMap.no-fk4=ALTER TABLE %VnFrameMap.table% DROP CONSTRAINT fk_%VnFrameMap.table%_frameid CASCADE;
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 UNSIGNED NOT NULL,framename VARCHAR (64) NOT NULL,PRIMARY KEY (nameid));
VnFrameName.pk=ALTER TABLE %VnFrameName.table% ADD CONSTRAINT pk_%VnFrameName.table% PRIMARY KEY (nameid);
VnFrameName.no-pk=ALTER TABLE %VnFrameName.table% DROP CONSTRAINT pk_%VnFrameName.table% CASCADE;
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 UNSIGNED NOT NULL,framesubname VARCHAR (64) NOT NULL,PRIMARY KEY (subnameid));
VnFrameSubName.pk=ALTER TABLE %VnFrameSubName.table% ADD CONSTRAINT pk_%VnFrameSubName.table% PRIMARY KEY (subnameid);
VnFrameSubName.no-pk=ALTER TABLE %VnFrameSubName.table% DROP CONSTRAINT pk_%VnFrameSubName.table% CASCADE;
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 UNSIGNED NOT NULL,syntax TEXT NOT NULL,PRIMARY KEY (syntaxid));
VnSyntax.pk=ALTER TABLE %VnSyntax.table% ADD CONSTRAINT pk_%VnSyntax.table% PRIMARY KEY (syntaxid);
VnSyntax.no-pk=ALTER TABLE %VnSyntax.table% DROP CONSTRAINT pk_%VnSyntax.table% CASCADE;
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 UNSIGNED NOT NULL,semantics TEXT NOT NULL,PRIMARY KEY (semanticsid));
VnSemantics.pk=ALTER TABLE %VnSemantics.table% ADD CONSTRAINT pk_%VnSemantics.table% PRIMARY KEY (semanticsid);
VnSemantics.no-pk=ALTER TABLE %VnSemantics.table% DROP CONSTRAINT pk_%VnSemantics.table% CASCADE;
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 UNSIGNED NOT NULL,pred VARCHAR (128) NOT NULL,PRIMARY KEY (predid));
VnPredicate.pk=ALTER TABLE %VnPredicate.table% ADD CONSTRAINT pk_%VnPredicate.table% PRIMARY KEY (predid);
VnPredicate.no-pk=ALTER TABLE %VnPredicate.table% DROP CONSTRAINT pk_%VnPredicate.table% CASCADE;
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 UNSIGNED NOT NULL,predid SMALLINT UNSIGNED NOT NULL,PRIMARY KEY (semanticsid,predid));
VnPredicateMap.pk=ALTER TABLE %VnPredicateMap.table% ADD CONSTRAINT pk_%VnPredicateMap.table% PRIMARY KEY (semanticsid,predid);
VnPredicateMap.no-pk=ALTER TABLE %VnPredicateMap.table% DROP CONSTRAINT pk_%VnPredicateMap.table% CASCADE;
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=ALTER TABLE %VnPredicateMap.table% ADD CONSTRAINT fk_%VnPredicateMap.table%_semanticsid FOREIGN KEY (semanticsid) REFERENCES %VnSemantics.table% (semanticsid);
VnPredicateMap.no-fk1=ALTER TABLE %VnPredicateMap.table% DROP CONSTRAINT fk_%VnPredicateMap.table%_semanticsid CASCADE;
VnPredicateMap.fk2=ALTER TABLE %VnPredicateMap.table% ADD CONSTRAINT fk_%VnPredicateMap.table%_predid FOREIGN KEY (predid) REFERENCES %VnPredicate.table% (predid);
VnPredicateMap.no-fk2=ALTER TABLE %VnPredicateMap.table% DROP CONSTRAINT fk_%VnPredicateMap.table%_predid CASCADE;
VnPredicateMap.insert=INSERT INTO %VnPredicateMap.table% (semanticsid,predid) VALUES (?,?);
VnExample.table=vnexamples
VnExample.create=CREATE TABLE IF NOT EXISTS %VnExample.table% (exampleid SMALLINT UNSIGNED NOT NULL,example VARCHAR (128) NOT NULL,PRIMARY KEY (exampleid));
VnExample.pk=ALTER TABLE %VnExample.table% ADD CONSTRAINT pk_%VnExample.table% PRIMARY KEY (exampleid);
VnExample.no-pk=ALTER TABLE %VnExample.table% DROP CONSTRAINT pk_%VnExample.table% CASCADE;
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 UNSIGNED NOT NULL,exampleid SMALLINT UNSIGNED NOT NULL,PRIMARY KEY (frameid,exampleid));
VnExampleMap.pk=ALTER TABLE %VnExampleMap.table% ADD CONSTRAINT pk_%VnExampleMap.table% PRIMARY KEY (frameid,exampleid);
VnExampleMap.no-pk=ALTER TABLE %VnExampleMap.table% DROP CONSTRAINT pk_%VnExampleMap.table% CASCADE;
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=ALTER TABLE %VnExampleMap.table% ADD CONSTRAINT fk_%VnExampleMap.table%_frameid FOREIGN KEY (frameid) REFERENCES %VnFrame.table% (frameid);
VnExampleMap.no-fk1=ALTER TABLE %VnExampleMap.table% DROP CONSTRAINT fk_%VnExampleMap.table%_frameid CASCADE;
VnExampleMap.fk2=ALTER TABLE %VnExampleMap.table% ADD CONSTRAINT fk_%VnExampleMap.table%_exampleid FOREIGN KEY (exampleid) REFERENCES %VnExample.table% (exampleid);
VnExampleMap.no-fk2=ALTER TABLE %VnExampleMap.table% DROP CONSTRAINT fk_%VnExampleMap.table%_exampleid CASCADE;
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=CREATE OR REPLACE 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=CREATE OR REPLACE 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=CREATE OR REPLACE 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);