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

Download this file

271 lines (249 with data), 28.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 %VnClass.table% (classid SMALLINT NOT NULL,class VARCHAR (64) NOT NULL,CONSTRAINT pk_%VnClass.table% 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 unq_%VnClass.table%_class ON %VnClass.table% (class);
VnClass.no-unq=DROP INDEX 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 %VnClassMember.table% (classid SMALLINT NOT NULL,wordid INTEGER NOT NULL DEFAULT 0,CONSTRAINT pk_%VnClassMember.table% 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 k_%VnClassMember.table%_classid ON %VnClassMember.table% (classid);
VnClassMember.no-index1=DROP INDEX k_%VnClassMember.table%_classid;
VnClassMember.index2=CREATE INDEX k_%VnClassMember.table%_wordid ON %VnClassMember.table% (wordid);
VnClassMember.no-index2=DROP INDEX 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 %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=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 k_%VnClassMemberSense.table%_classid ON %VnClassMemberSense.table% (classid);
VnClassMemberSense.no-index1=DROP INDEX k_%VnClassMemberSense.table%_classid;
VnClassMemberSense.index2=CREATE INDEX k_%VnClassMemberSense.table%_wordid ON %VnClassMemberSense.table% (wordid);
VnClassMemberSense.no-index2=DROP INDEX k_%VnClassMemberSense.table%_wordid;
VnClassMemberSense.index3=CREATE INDEX k_%VnClassMemberSense.table%_synsetid ON %VnClassMemberSense.table% (synsetid);
VnClassMemberSense.no-index3=DROP INDEX k_%VnClassMemberSense.table%_synsetid;
VnClassMemberSense.index4=CREATE INDEX k_%VnClassMemberSense.table%_sensekey ON %VnClassMemberSense.table% (sensekey);
VnClassMemberSense.no-index4=DROP INDEX 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 %VnGrouping.table% (groupingid SMALLINT NOT NULL,grouping VARCHAR (64) NOT NULL,CONSTRAINT pk_%VnGrouping.table% 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 unq_%VnGrouping.table%_grouping ON %VnGrouping.table% (grouping);
VnGrouping.no-unq=DROP INDEX unq_%VnGrouping.table%_grouping;
VnGrouping.insert=INSERT INTO %VnGrouping.table% (groupingid,grouping) VALUES (?,?);
VnGroupingMap.table=vngroupingmaps
VnGroupingMap.create=CREATE TABLE %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=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 k_%VnGroupingMap.table%_classid ON %VnGroupingMap.table% (classid);
VnGroupingMap.no-index1=DROP INDEX k_%VnGroupingMap.table%_classid;
VnGroupingMap.index2=CREATE INDEX k_%VnGroupingMap.table%_wordid ON %VnGroupingMap.table% (wordid);
VnGroupingMap.no-index2=DROP INDEX k_%VnGroupingMap.table%_wordid;
VnGroupingMap.index3=CREATE INDEX k_%VnGroupingMap.table%_groupingid ON %VnGroupingMap.table% (groupingid);
VnGroupingMap.no-index3=DROP INDEX 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 %VnRole.table% (roleid SMALLINT NOT NULL,roletypeid SMALLINT NOT NULL,selrestrsid SMALLINT NOT NULL,CONSTRAINT pk_%VnRole.table% 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 unq_%VnRole.table%_roletypeid_selrestrsid ON %VnRole.table% (roletypeid,selrestrsid);
VnRole.no-unq=DROP INDEX unq_%VnRole.table%_roletypeid_selrestrsid;
VnRole.index1=CREATE INDEX k_%VnRole.table%_roletypeid ON %VnRole.table% (roletypeid);
VnRole.no-index1=DROP INDEX k_%VnRole.table%_roletypeid;
VnRole.index2=CREATE INDEX k_%VnRole.table%_selrestrsid ON %VnRole.table% (selrestrsid);
VnRole.no-index2=DROP INDEX 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 %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=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 unq_%VnRoleMap.table%_wordid_synsetid_roleid_classid_rquality ON %VnRoleMap.table% (wordid,synsetid,roleid,classid,rquality);
VnRoleMap.no-unq=DROP INDEX unq_%VnRoleMap.table%_wordid_synsetid_roleid_classid_rquality;
VnRoleMap.index1=CREATE INDEX k_%VnRoleMap.table%_wordid ON %VnRoleMap.table% (wordid);
VnRoleMap.no-index1=DROP INDEX k_%VnRoleMap.table%_wordid;
VnRoleMap.index2=CREATE INDEX k_%VnRoleMap.table%_synsetid ON %VnRoleMap.table% (synsetid);
VnRoleMap.no-index2=DROP INDEX k_%VnRoleMap.table%_synsetid;
VnRoleMap.index3=CREATE INDEX k_%VnRoleMap.table%_roleid ON %VnRoleMap.table% (roleid);
VnRoleMap.no-index3=DROP INDEX k_%VnRoleMap.table%_roleid;
VnRoleMap.index4=CREATE INDEX k_%VnRoleMap.table%_classid ON %VnRoleMap.table% (classid);
VnRoleMap.no-index4=DROP INDEX 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 %VnRoleType.table% (roletypeid SMALLINT NOT NULL,roletype VARCHAR (32) NOT NULL,CONSTRAINT pk_%VnRoleType.table% 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 unq_%VnRoleType.table%_roletype ON %VnRoleType.table% (roletype);
VnRoleType.no-unq=DROP INDEX unq_%VnRoleType.table%_roletype;
VnRoleType.insert=INSERT INTO %VnRoleType.table% (roletypeid,roletype) VALUES (?,?);
VnSelRestrs.table=vnselrestrs
VnSelRestrs.create=CREATE TABLE %VnSelRestrs.table% (selrestrsid SMALLINT NOT NULL,selrestrs TEXT NOT NULL,CONSTRAINT pk_%VnSelRestrs.table% 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 unq_%VnSelRestrs.table%_selrestrs ON %VnSelRestrs.table% (selrestrs);
VnSelRestrs.no-unq=DROP INDEX unq_%VnSelRestrs.table%_selrestrs;
VnSelRestrs.insert=INSERT INTO %VnSelRestrs.table% (selrestrsid,selrestrs) VALUES (?,?);
VnSelRestrType.table=vnselrestrtypes
VnSelRestrType.create=CREATE TABLE %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=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 unq_%VnSelRestrType.table%_selrestrval_selrestr ON %VnSelRestrType.table% (selrestrval,selrestr);
VnSelRestrType.no-unq=DROP INDEX unq_%VnSelRestrType.table%_selrestrval_selrestr;
VnSelRestrType.insert=INSERT INTO %VnSelRestrType.table% (selrestrid,selrestrval,selrestr) VALUES (?,?,?);
VnFrame.table=vnframes
VnFrame.create=CREATE TABLE %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=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 unq_%VnFrame.table%_number_xtag_nameid_subnameid_syntaxid_semanticsid ON %VnFrame.table% (number,xtag,nameid,subnameid,syntaxid,semanticsid);
VnFrame.no-unq=DROP INDEX unq_%VnFrame.table%_number_xtag_nameid_subnameid_syntaxid_semanticsid;
VnFrame.index1=CREATE INDEX k_%VnFrame.table%_nameid ON %VnFrame.table% (nameid);
VnFrame.no-index1=DROP INDEX k_%VnFrame.table%_nameid;
VnFrame.index2=CREATE INDEX k_%VnFrame.table%_subnameid ON %VnFrame.table% (subnameid);
VnFrame.no-index2=DROP INDEX k_%VnFrame.table%_subnameid;
VnFrame.index3=CREATE INDEX k_%VnFrame.table%_syntaxid ON %VnFrame.table% (syntaxid);
VnFrame.no-index3=DROP INDEX k_%VnFrame.table%_syntaxid;
VnFrame.index4=CREATE INDEX k_%VnFrame.table%_semanticsid ON %VnFrame.table% (semanticsid);
VnFrame.no-index4=DROP INDEX 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 %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=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 unq_%VnFrameMap.table%_wordid_synsetid_classid_frameid_fquality ON %VnFrameMap.table% (wordid,synsetid,classid,frameid,fquality);
VnFrameMap.no-unq=DROP INDEX unq_%VnFrameMap.table%_wordid_synsetid_classid_frameid_fquality;
VnFrameMap.index1=CREATE INDEX k_%VnFrameMap.table%_wordid ON %VnFrameMap.table% (wordid);
VnFrameMap.no-index1=DROP INDEX k_%VnFrameMap.table%_wordid;
VnFrameMap.index2=CREATE INDEX k_%VnFrameMap.table%_synsetid ON %VnFrameMap.table% (synsetid);
VnFrameMap.no-index2=DROP INDEX k_%VnFrameMap.table%_synsetid;
VnFrameMap.index3=CREATE INDEX k_%VnFrameMap.table%_classid ON %VnFrameMap.table% (classid);
VnFrameMap.no-index3=DROP INDEX k_%VnFrameMap.table%_classid;
VnFrameMap.index4=CREATE INDEX k_%VnFrameMap.table%_frameid ON %VnFrameMap.table% (frameid);
VnFrameMap.no-index4=DROP INDEX 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 %VnFrameName.table% (nameid SMALLINT NOT NULL,framename VARCHAR (64) NOT NULL,CONSTRAINT pk_%VnFrameName.table% 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 unq_%VnFrameName.table%_framename ON %VnFrameName.table% (framename);
VnFrameName.no-unq=DROP INDEX unq_%VnFrameName.table%_framename;
VnFrameName.insert=INSERT INTO %VnFrameName.table% (nameid,framename) VALUES (?,?);
VnFrameSubName.table=vnframesubnames
VnFrameSubName.create=CREATE TABLE %VnFrameSubName.table% (subnameid SMALLINT NOT NULL,framesubname VARCHAR (64) NOT NULL,CONSTRAINT pk_%VnFrameSubName.table% 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 unq_%VnFrameSubName.table%_framesubname ON %VnFrameSubName.table% (framesubname);
VnFrameSubName.no-unq=DROP INDEX unq_%VnFrameSubName.table%_framesubname;
VnFrameSubName.insert=INSERT INTO %VnFrameSubName.table% (subnameid,framesubname) VALUES (?,?);
VnSyntax.table=vnsyntaxes
VnSyntax.create=CREATE TABLE %VnSyntax.table% (syntaxid INTEGER NOT NULL,syntax TEXT NOT NULL,CONSTRAINT pk_%VnSyntax.table% 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 unq_%VnSyntax.table%_syntax ON %VnSyntax.table% (syntax);
VnSyntax.no-unq=DROP INDEX unq_%VnSyntax.table%_syntax;
VnSyntax.insert=INSERT INTO %VnSyntax.table% (syntaxid,syntax) VALUES (?,?);
VnSemantics.table=vnsemantics
VnSemantics.create=CREATE TABLE %VnSemantics.table% (semanticsid INTEGER NOT NULL,semantics TEXT NOT NULL,CONSTRAINT pk_%VnSemantics.table% 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 unq_%VnSemantics.table%_semantics ON %VnSemantics.table% (semantics);
VnSemantics.no-unq=DROP INDEX unq_%VnSemantics.table%_semantics;
VnSemantics.insert=INSERT INTO %VnSemantics.table% (semanticsid,semantics) VALUES (?,?);
VnPredicate.table=vnpredicates
VnPredicate.create=CREATE TABLE %VnPredicate.table% (predid SMALLINT NOT NULL,pred VARCHAR (128) NOT NULL,CONSTRAINT pk_%VnPredicate.table% 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 unq_%VnPredicate.table%_pred ON %VnPredicate.table% (pred);
VnPredicate.no-unq=DROP INDEX unq_%VnPredicate.table%_pred;
VnPredicate.insert=INSERT INTO %VnPredicate.table% (predid,pred) VALUES (?,?);
VnPredicateMap.table=vnpredicatemaps
VnPredicateMap.create=CREATE TABLE %VnPredicateMap.table% (semanticsid INTEGER NOT NULL,predid SMALLINT NOT NULL,CONSTRAINT pk_%VnPredicateMap.table% 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 k_%VnPredicateMap.table%_semanticsid ON %VnPredicateMap.table% (semanticsid);
VnPredicateMap.no-index1=DROP INDEX k_%VnPredicateMap.table%_semanticsid;
VnPredicateMap.index2=CREATE INDEX k_%VnPredicateMap.table%_predid ON %VnPredicateMap.table% (predid);
VnPredicateMap.no-index2=DROP INDEX 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 %VnExample.table% (exampleid SMALLINT NOT NULL,example VARCHAR (128) NOT NULL,CONSTRAINT pk_%VnExample.table% 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 unq_%VnExample.table%_example ON %VnExample.table% (example);
VnExample.no-unq=DROP INDEX unq_%VnExample.table%_example;
VnExample.insert=INSERT INTO %VnExample.table% (exampleid,example) VALUES (?,?);
VnExampleMap.table=vnexamplemaps
VnExampleMap.create=CREATE TABLE %VnExampleMap.table% (frameid INTEGER NOT NULL,exampleid SMALLINT NOT NULL,CONSTRAINT pk_%VnExampleMap.table% 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 k_%VnExampleMap.table%_frameid ON %VnExampleMap.table% (frameid);
VnExampleMap.no-index1=DROP INDEX k_%VnExampleMap.table%_frameid;
VnExampleMap.index2=CREATE INDEX k_%VnExampleMap.table%_exampleid ON %VnExampleMap.table% (exampleid);
VnExampleMap.no-index2=DROP INDEX 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);

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

Sign up for the SourceForge newsletter:





No, thanks