--- a/verbnet/src/main/resources/org/wnsql/builder/verbnet/test.properties
+++ b/verbnet/src/main/resources/org/wnsql/builder/verbnet/test.properties
@@ -1,261 +1,261 @@
 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.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 %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.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 %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-index3=DROP INDEX k_%VnClassMemberSense.table%_synsetid;
-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.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 %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.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 %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.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 %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.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 %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.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 %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.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 %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.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 %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.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 %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.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 %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.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 %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.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 %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.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 %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.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 %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.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 %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.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 %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.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 %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.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 %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.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 '/';
@@ -263,8 +263,8 @@
 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.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=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.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=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);
+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);