SourceForge has been redesigned. Learn more.
Close

Diff of /wordnet/src/main/resources/org/wnsql/builder/wordnet/test.properties [987195] .. [6ff7b6]  Maximize  Restore

Switch to side-by-side view

--- a/wordnet/src/main/resources/org/wnsql/builder/wordnet/test.properties
+++ b/wordnet/src/main/resources/org/wnsql/builder/wordnet/test.properties
@@ -1,246 +1,250 @@
 Word.table=words
-Word.create=CREATE TABLE %Word.table% (wordid INTEGER NOT NULL DEFAULT '0',lemma VARCHAR (80) NOT NULL,CONSTRAINT pk_%Word.table% PRIMARY KEY (wordid));
-Word.pk=ALTER TABLE %Word.table% ADD CONSTRAINT pk_%Word.table% PRIMARY KEY (wordid);
-Word.no-pk=ALTER TABLE %Word.table% DROP CONSTRAINT pk_%Word.table% CASCADE;
-Word.unq=CREATE UNIQUE INDEX unq_%Word.table%_lemma ON %Word.table% (lemma);
-Word.no-unq=DROP INDEX unq_%Word.table%_lemma;
+Word.create=CREATE TABLE IF NOT EXISTS %Word.table% (wordid INTEGER NOT NULL DEFAULT '0',lemma VARCHAR (80) NOT NULL,CONSTRAINT pk_%Word.table% PRIMARY KEY (wordid));
+Word.pk=
+Word.no-pk=
+Word.unq=CREATE UNIQUE INDEX IF NOT EXISTS unq_%Word.table%_lemma ON %Word.table% (lemma);
+Word.no-unq=DROP INDEX IF EXISTS unq_%Word.table%_lemma;
 Word.insert=INSERT INTO %Word.table% (wordid,lemma) VALUES (?,?);
 Word.select=SELECT wordid FROM %Word.table% WHERE lemma = ?;
 
 CasedWord.table=casedwords
-CasedWord.create=CREATE TABLE %CasedWord.table% (casedwordid INTEGER NOT NULL DEFAULT '0',wordid INTEGER NOT NULL DEFAULT '0',cased VARCHAR (80) NOT NULL,CONSTRAINT pk_%CasedWord.table% PRIMARY KEY (casedwordid));
-CasedWord.pk=ALTER TABLE %CasedWord.table% ADD CONSTRAINT pk_%CasedWord.table% PRIMARY KEY (casedwordid);
-CasedWord.no-pk=ALTER TABLE %CasedWord.table% DROP CONSTRAINT pk_%CasedWord.table% CASCADE;
-CasedWord.unq=CREATE UNIQUE INDEX unq_%CasedWord.table%_cased ON %CasedWord.table% (cased);
-CasedWord.no-unq=DROP INDEX unq_%CasedWord.table%_cased;
-CasedWord.index=CREATE INDEX k_%CasedWord.table%_wordid ON %CasedWord.table% (wordid);
-CasedWord.no-index=DROP INDEX k_%CasedWord.table%_wordid;
-CasedWord.fk=ALTER TABLE %CasedWord.table% ADD CONSTRAINT fk_%CasedWord.table%_wordid FOREIGN KEY (wordid) REFERENCES %Word.table% (wordid);
-CasedWord.no-fk=ALTER TABLE %CasedWord.table% DROP CONSTRAINT fk_%CasedWord.table%_wordid CASCADE;
+CasedWord.create=CREATE TABLE IF NOT EXISTS %CasedWord.table% (casedwordid INTEGER NOT NULL DEFAULT '0',wordid INTEGER NOT NULL DEFAULT '0',cased VARCHAR (80) NOT NULL,CONSTRAINT pk_%CasedWord.table% PRIMARY KEY (casedwordid));
+CasedWord.pk=
+CasedWord.no-pk=
+CasedWord.unq=CREATE UNIQUE INDEX IF NOT EXISTS unq_%CasedWord.table%_cased ON %CasedWord.table% (cased);
+CasedWord.no-unq=DROP INDEX IF EXISTS unq_%CasedWord.table%_cased;
+CasedWord.index=CREATE INDEX IF NOT EXISTS k_%CasedWord.table%_wordid ON %CasedWord.table% (wordid);
+CasedWord.no-index=DROP INDEX IF EXISTS k_%CasedWord.table%_wordid;
+CasedWord.fk=
+CasedWord.no-fk=
 CasedWord.insert=INSERT INTO %CasedWord.table% (casedwordid,wordid,cased) VALUES (?,?,?);
 CasedWord.select=SELECT casedwordid FROM %CasedWord.table% WHERE cased = ?;
 
 Sense.table=senses
-Sense.create=CREATE TABLE %Sense.table% (wordid INTEGER NOT NULL DEFAULT '0',casedwordid INTEGER NULL,synsetid INTEGER NOT NULL DEFAULT '0',senseid INTEGER NULL,sensenum SMALLINT NOT NULL DEFAULT '0',lexid SMALLINT NOT NULL DEFAULT '0',tagcount INTEGER NULL,sensekey VARCHAR (100) DEFAULT NULL,CONSTRAINT pk_%Sense.table% PRIMARY KEY (wordid,synsetid));
-Sense.pk=ALTER TABLE %Sense.table% ADD CONSTRAINT pk_%Sense.table% PRIMARY KEY (wordid,synsetid);
-Sense.no-pk=ALTER TABLE %Sense.table% DROP CONSTRAINT pk_%Sense.table% CASCADE;
-Sense.unq1=CREATE UNIQUE INDEX unq_%Sense.table%_senseid ON %Sense.table% (senseid);
-Sense.no-unq1=DROP INDEX unq_%Sense.table%_senseid;
-Sense.unq2=CREATE UNIQUE INDEX unq_%Sense.table%_sensekey ON %Sense.table% (sensekey);
-Sense.no-unq2=DROP INDEX unq_%Sense.table%_sensekey;
-Sense.index1=CREATE INDEX k_%Sense.table%_wordid ON %Sense.table% (wordid);
-Sense.no-index1=DROP INDEX k_%Sense.table%_wordid;
-Sense.index2=CREATE INDEX k_%Sense.table%_synsetid ON %Sense.table% (synsetid);
-Sense.no-index2=DROP INDEX k_%Sense.table%_synsetid;
-Sense.index3=CREATE INDEX k_%Sense.table%_lexid ON %Sense.table% (lexid);
-Sense.no-index3=DROP INDEX k_%Sense.table%_lexid;
-Sense.fk1=ALTER TABLE %Sense.table% ADD CONSTRAINT fk_%Sense.table%_wordid FOREIGN KEY (wordid) REFERENCES %Word.table% (wordid);
-Sense.no-fk1=ALTER TABLE %Sense.table% DROP CONSTRAINT fk_%Sense.table%_wordid CASCADE;
-Sense.fk2=ALTER TABLE %Sense.table% ADD CONSTRAINT fk_%Sense.table%_synsetid FOREIGN KEY (synsetid) REFERENCES %Synset.table% (synsetid);
-Sense.no-fk2=ALTER TABLE %Sense.table% DROP CONSTRAINT fk_%Sense.table%_synsetid CASCADE;
+Sense.create=CREATE TABLE IF NOT EXISTS %Sense.table% (wordid INTEGER NOT NULL DEFAULT '0',casedwordid INTEGER NULL,synsetid INTEGER NOT NULL DEFAULT '0',senseid INTEGER NULL,sensenum SMALLINT NOT NULL DEFAULT '0',lexid SMALLINT NOT NULL DEFAULT '0',tagcount INTEGER NULL,sensekey VARCHAR (100) DEFAULT NULL,CONSTRAINT pk_%Sense.table% PRIMARY KEY (wordid,synsetid));
+Sense.pk=
+Sense.no-pk=
+Sense.unq1=CREATE UNIQUE INDEX IF NOT EXISTS unq_%Sense.table%_senseid ON %Sense.table% (senseid);
+Sense.no-unq1=DROP INDEX IF EXISTS unq_%Sense.table%_senseid;
+Sense.unq2=CREATE UNIQUE INDEX IF NOT EXISTS unq_%Sense.table%_sensekey ON %Sense.table% (sensekey);
+Sense.no-unq2=DROP INDEX IF EXISTS unq_%Sense.table%_sensekey;
+Sense.index1=CREATE INDEX IF NOT EXISTS k_%Sense.table%_wordid ON %Sense.table% (wordid);
+Sense.no-index1=DROP INDEX IF EXISTS k_%Sense.table%_wordid;
+Sense.index2=CREATE INDEX IF NOT EXISTS k_%Sense.table%_synsetid ON %Sense.table% (synsetid);
+Sense.no-index2=DROP INDEX IF EXISTS k_%Sense.table%_synsetid;
+Sense.index3=CREATE INDEX IF NOT EXISTS k_%Sense.table%_lexid ON %Sense.table% (lexid);
+Sense.no-index3=DROP INDEX IF EXISTS k_%Sense.table%_lexid;
+Sense.fk1=
+Sense.no-fk1=
+Sense.fk2=
+Sense.no-fk2=
 Sense.insert=INSERT INTO %Sense.table% (wordid,synsetid,sensenum) VALUES (?,?,?);
 Sense.update=UPDATE %Sense.table% SET senseid = ?,sensekey = ?,lexid = ?,tagcount = ? WHERE wordid = ? AND synsetid = ?;
 Sense.case.update=UPDATE %Sense.table% SET casedwordid = ? WHERE synsetid = ? AND wordid = ?;
 Sense.select=SELECT %Sense.table%.synsetid FROM %Word.table% INNER JOIN %Sense.table% USING (wordid) INNER JOIN %Synset.table% USING (synsetid) WHERE %Word.table%.lemma = ? AND %Sense.table%.lexid = ? AND %Synset.table%.lexdomainid = ?;
 
 Synset.table=synsets
-Synset.create=CREATE TABLE %Synset.table% (synsetid INTEGER NOT NULL DEFAULT '0',pos CHARACTER (1) NOT NULL,lexdomainid SMALLINT NOT NULL DEFAULT '0',definition TEXT,CONSTRAINT pk_%Synset.table% PRIMARY KEY (synsetid));
-Synset.pk=ALTER TABLE %Synset.table% ADD CONSTRAINT pk_%Synset.table% PRIMARY KEY (synsetid);
-Synset.no-pk=ALTER TABLE %Synset.table% DROP CONSTRAINT pk_%Synset.table% CASCADE;
-Synset.index=CREATE INDEX k_%Synset.table%_lexdomainid ON %Synset.table% (lexdomainid);
-Synset.no-index=DROP INDEX k_%Synset.table%_lexdomainid;
-Synset.fk=ALTER TABLE %Synset.table% ADD CONSTRAINT fk_%Synset.table%_lexdomainid FOREIGN KEY (lexdomainid) REFERENCES %LexDomain.table% (lexdomainid);
-Synset.no-fk=ALTER TABLE %Synset.table% DROP CONSTRAINT fk_%Synset.table%_lexdomainid CASCADE;
+Synset.create=CREATE TABLE IF NOT EXISTS %Synset.table% (synsetid INTEGER NOT NULL DEFAULT '0',pos CHARACTER (1) NOT NULL,lexdomainid SMALLINT NOT NULL DEFAULT '0',definition TEXT,CONSTRAINT pk_%Synset.table% PRIMARY KEY (synsetid));
+Synset.pk=
+Synset.no-pk=
+Synset.index=CREATE INDEX IF NOT EXISTS k_%Synset.table%_lexdomainid ON %Synset.table% (lexdomainid);
+Synset.no-index=DROP INDEX IF EXISTS k_%Synset.table%_lexdomainid;
+Synset.fk=
+Synset.no-fk=
 Synset.insert=INSERT INTO %Synset.table% (synsetid,pos,lexdomainid,definition) VALUES (?,?,?,?);
 Synset.select=SELECT * FROM %Synset.table% WHERE synsetid = ?;
 Synset.definition.select=SELECT definition FROM %Synset.table% WHERE synsetid = ?;
 
 PosType.table=postypes
-PosType.create=CREATE TABLE %PosType.table% (pos CHARACTER (1) NOT NULL,posname VARCHAR (20) NOT NULL,CONSTRAINT pk_%PosType.table% PRIMARY KEY (pos));
-PosType.pk=ALTER TABLE %PosType.table% ADD CONSTRAINT pk_%PosType.table% PRIMARY KEY (pos);
-PosType.no-pk=ALTER TABLE %PosType.table% DROP CONSTRAINT pk_%PosType.table% CASCADE;
+PosType.create=CREATE TABLE IF NOT EXISTS %PosType.table% (pos CHARACTER (1) NOT NULL,posname VARCHAR (20) NOT NULL,CONSTRAINT pk_%PosType.table% PRIMARY KEY (pos));
+PosType.pk=
+PosType.no-pk=
 PosType.insert=INSERT INTO %PosType.table% (pos,posname) VALUES (?,?);
 
 LexDomain.table=lexdomains
-LexDomain.create=CREATE TABLE %LexDomain.table% (lexdomainid SMALLINT NOT NULL DEFAULT '0',lexdomainname VARCHAR (32) DEFAULT NULL,lexdomain VARCHAR (32) DEFAULT NULL,pos CHARACTER (1) DEFAULT NULL,CONSTRAINT pk_%LexDomain.table% PRIMARY KEY (lexdomainid));
-LexDomain.pk=ALTER TABLE %LexDomain.table% ADD CONSTRAINT pk_%LexDomain.table% PRIMARY KEY (lexdomainid);
-LexDomain.no-pk=ALTER TABLE %LexDomain.table% DROP CONSTRAINT pk_%LexDomain.table% CASCADE;
+LexDomain.create=CREATE TABLE IF NOT EXISTS %LexDomain.table% (lexdomainid SMALLINT NOT NULL DEFAULT '0',lexdomainname VARCHAR (32) DEFAULT NULL,lexdomain VARCHAR (32) DEFAULT NULL,pos CHARACTER (1) DEFAULT NULL,CONSTRAINT pk_%LexDomain.table% PRIMARY KEY (lexdomainid));
+LexDomain.pk=
+LexDomain.no-pk=
 LexDomain.insert=INSERT INTO %LexDomain.table% (lexdomainid,lexdomainname,lexdomain,pos) VALUES (?,?,?,?);
 
 Sample.table=samples
-Sample.create=CREATE TABLE %Sample.table% (synsetid INTEGER NOT NULL DEFAULT '0',sampleid SMALLINT NOT NULL DEFAULT '0',sample TEXT NOT NULL,CONSTRAINT pk_%Sample.table% PRIMARY KEY (synsetid,sampleid));
-Sample.pk=ALTER TABLE %Sample.table% ADD CONSTRAINT pk_%Sample.table% PRIMARY KEY (synsetid,sampleid);
-Sample.no-pk=ALTER TABLE %Sample.table% DROP CONSTRAINT pk_%Sample.table% CASCADE;
-Sample.index=CREATE INDEX k_%Sample.table%_synsetid ON %Sample.table% (synsetid);
-Sample.no-index=DROP INDEX k_%Sample.table%_synsetid;
-Sample.fk=ALTER TABLE %Sample.table% ADD CONSTRAINT fk_%Sample.table%_synsetid FOREIGN KEY (synsetid) REFERENCES %Synset.table% (synsetid);
-Sample.no-fk=ALTER TABLE %Sample.table% DROP CONSTRAINT fk_%Sample.table%_synsetid CASCADE;
+Sample.create=CREATE TABLE IF NOT EXISTS %Sample.table% (synsetid INTEGER NOT NULL DEFAULT '0',sampleid SMALLINT NOT NULL DEFAULT '0',sample TEXT NOT NULL,CONSTRAINT pk_%Sample.table% PRIMARY KEY (synsetid,sampleid));
+Sample.pk=
+Sample.no-pk=
+Sample.index=CREATE INDEX IF NOT EXISTS k_%Sample.table%_synsetid ON %Sample.table% (synsetid);
+Sample.no-index=DROP INDEX IF EXISTS k_%Sample.table%_synsetid;
+Sample.fk=
+Sample.no-fk=
 Sample.insert=INSERT INTO %Sample.table% (synsetid,sampleid,sample) VALUES (?,?,?);
 
 LinkType.table=linktypes
-LinkType.create=CREATE TABLE %LinkType.table% (linkid SMALLINT NOT NULL DEFAULT '0',link VARCHAR (50) DEFAULT NULL,recurses BOOLEAN NOT NULL DEFAULT FALSE,CONSTRAINT pk_%LinkType.table% PRIMARY KEY (linkid));
-LinkType.pk=ALTER TABLE %LinkType.table% ADD CONSTRAINT pk_%LinkType.table% PRIMARY KEY (linkid);
-LinkType.no-pk=ALTER TABLE %LinkType.table% DROP CONSTRAINT pk_%LinkType.table% CASCADE;
+LinkType.create=CREATE TABLE IF NOT EXISTS %LinkType.table% (linkid SMALLINT NOT NULL DEFAULT '0',link VARCHAR (50) DEFAULT NULL,recurses BOOLEAN NOT NULL DEFAULT FALSE,CONSTRAINT pk_%LinkType.table% PRIMARY KEY (linkid));
+LinkType.pk=
+LinkType.no-pk=
 LinkType.insert=INSERT INTO %LinkType.table% (linkid,link,recurses) VALUES (?,?,?);
 
 SemLink.table=semlinks
-SemLink.create=CREATE TABLE %SemLink.table% (synset1id INTEGER NOT NULL DEFAULT '0',synset2id INTEGER NOT NULL DEFAULT '0',linkid SMALLINT NOT NULL DEFAULT '0',CONSTRAINT pk_%SemLink.table% PRIMARY KEY (synset1id,synset2id,linkid));
-SemLink.pk=ALTER TABLE %SemLink.table% ADD CONSTRAINT pk_%SemLink.table% PRIMARY KEY (synset1id,synset2id,linkid);
-SemLink.no-pk=ALTER TABLE %SemLink.table% DROP CONSTRAINT pk_%SemLink.table% CASCADE;
-SemLink.index1=CREATE INDEX k_%SemLink.table%_synset1id ON %SemLink.table% (synset1id);
-SemLink.no-index1=DROP INDEX k_%SemLink.table%_synset1id;
-SemLink.index2=CREATE INDEX k_%SemLink.table%_synset2id ON %SemLink.table% (synset2id);
-SemLink.no-index2=DROP INDEX k_%SemLink.table%_synset2id;
-SemLink.index3=CREATE INDEX k_%SemLink.table%_linkid ON %SemLink.table% (linkid);
-SemLink.no-index3=DROP INDEX k_%SemLink.table%_linkid;
-SemLink.fk1=ALTER TABLE %SemLink.table% ADD CONSTRAINT fk_%SemLink.table%_synset1id FOREIGN KEY (synset1id) REFERENCES %Synset.table% (synsetid);
-SemLink.no-fk1=ALTER TABLE %SemLink.table% DROP CONSTRAINT fk_%SemLink.table%_synset1id CASCADE;
-SemLink.fk2=ALTER TABLE %SemLink.table% ADD CONSTRAINT fk_%SemLink.table%_synset2id FOREIGN KEY (synset2id) REFERENCES %Synset.table% (synsetid);
-SemLink.no-fk2=ALTER TABLE %SemLink.table% DROP CONSTRAINT fk_%SemLink.table%_synset2id CASCADE;
-SemLink.fk3=ALTER TABLE %SemLink.table% ADD CONSTRAINT fk_%SemLink.table%_linkid FOREIGN KEY (linkid) REFERENCES %LinkType.table% (linkid);
-SemLink.no-fk3=ALTER TABLE %SemLink.table% DROP CONSTRAINT fk_%SemLink.table%_linkid CASCADE;
+SemLink.create=CREATE TABLE IF NOT EXISTS %SemLink.table% (synset1id INTEGER NOT NULL DEFAULT '0',synset2id INTEGER NOT NULL DEFAULT '0',linkid SMALLINT NOT NULL DEFAULT '0',CONSTRAINT pk_%SemLink.table% PRIMARY KEY (synset1id,synset2id,linkid));
+SemLink.pk=
+SemLink.no-pk=
+SemLink.index1=CREATE INDEX IF NOT EXISTS k_%SemLink.table%_synset1id ON %SemLink.table% (synset1id);
+SemLink.no-index1=DROP INDEX IF EXISTS k_%SemLink.table%_synset1id;
+SemLink.index2=CREATE INDEX IF NOT EXISTS k_%SemLink.table%_synset2id ON %SemLink.table% (synset2id);
+SemLink.no-index2=DROP INDEX IF EXISTS k_%SemLink.table%_synset2id;
+SemLink.index3=CREATE INDEX IF NOT EXISTS k_%SemLink.table%_linkid ON %SemLink.table% (linkid);
+SemLink.no-index3=DROP INDEX IF EXISTS k_%SemLink.table%_linkid;
+SemLink.fk1=
+SemLink.no-fk1=
+SemLink.fk2=
+SemLink.no-fk2=
+SemLink.fk3=
+SemLink.no-fk3=
 SemLink.insert=INSERT INTO %SemLink.table% (synset1id,synset2id,linkid) VALUES (?,?,?);
 
 LexLink.table=lexlinks
-LexLink.create=CREATE TABLE %LexLink.table% (synset1id INTEGER NOT NULL DEFAULT '0',word1id INTEGER NOT NULL DEFAULT '0',synset2id INTEGER NOT NULL DEFAULT '0',word2id INTEGER NOT NULL DEFAULT '0',linkid SMALLINT NOT NULL DEFAULT '0',CONSTRAINT pk_%LexLink.table% PRIMARY KEY (word1id,synset1id,word2id,synset2id,linkid));
-LexLink.pk=ALTER TABLE %LexLink.table% ADD CONSTRAINT pk_%LexLink.table% PRIMARY KEY (word1id,synset1id,word2id,synset2id,linkid);
-LexLink.no-pk=ALTER TABLE %LexLink.table% DROP CONSTRAINT pk_%LexLink.table% CASCADE;
-LexLink.index1=CREATE INDEX k_%LexLink.table%_synset1id_word1id ON %LexLink.table% (synset1id,word1id);
-LexLink.no-index1=DROP INDEX k_%LexLink.table%_synset1id_word1id;
-LexLink.index2=CREATE INDEX k_%LexLink.table%_synset2id_word2id ON %LexLink.table% (synset2id,word2id);
-LexLink.no-index2=DROP INDEX k_%LexLink.table%_synset2id_word2id;
-LexLink.index3=CREATE INDEX k_%LexLink.table%_linkid ON %LexLink.table% (linkid);
-LexLink.no-index3=DROP INDEX k_%LexLink.table%_linkid;
-LexLink.index4=CREATE INDEX k_%LexLink.table%_synset1id ON %LexLink.table% (synset1id);
-LexLink.no-index4=DROP INDEX k_%LexLink.table%_synset1id;
-LexLink.index5=CREATE INDEX k_%LexLink.table%_word1id ON %LexLink.table% (word1id);
-LexLink.no-index5=DROP INDEX k_%LexLink.table%_word1id;
-LexLink.index6=CREATE INDEX k_%LexLink.table%_synset2id ON %LexLink.table% (synset2id);
-LexLink.no-index6=DROP INDEX k_%LexLink.table%_synset2id;
-LexLink.index7=CREATE INDEX k_%LexLink.table%_word2id ON %LexLink.table% (word2id);
-LexLink.no-index7=DROP INDEX k_%LexLink.table%_word2id;
-LexLink.fk1=ALTER TABLE %LexLink.table% ADD CONSTRAINT fk_%LexLink.table%_synset1id FOREIGN KEY (synset1id) REFERENCES %Synset.table% (synsetid);
-LexLink.no-fk1=ALTER TABLE %LexLink.table% DROP CONSTRAINT fk_%LexLink.table%_synset1id CASCADE;
-LexLink.fk2=ALTER TABLE %LexLink.table% ADD CONSTRAINT fk_%LexLink.table%_synset2id FOREIGN KEY (synset2id) REFERENCES %Synset.table% (synsetid);
-LexLink.no-fk2=ALTER TABLE %LexLink.table% DROP CONSTRAINT fk_%LexLink.table%_synset2id CASCADE;
-LexLink.fk3=ALTER TABLE %LexLink.table% ADD CONSTRAINT fk_%LexLink.table%_word1id FOREIGN KEY (word1id) REFERENCES %Word.table% (wordid);
-LexLink.no-fk3=ALTER TABLE %LexLink.table% DROP CONSTRAINT fk_%LexLink.table%_word1id CASCADE;
-LexLink.fk4=ALTER TABLE %LexLink.table% ADD CONSTRAINT fk_%LexLink.table%_word2id FOREIGN KEY (word2id) REFERENCES %Word.table% (wordid);
-LexLink.no-fk4=ALTER TABLE %LexLink.table% DROP CONSTRAINT fk_%LexLink.table%_word2id CASCADE;
-LexLink.fk5=ALTER TABLE %LexLink.table% ADD CONSTRAINT fk_%LexLink.table%_linkid FOREIGN KEY (linkid) REFERENCES %LinkType.table% (linkid);
-LexLink.no-fk5=ALTER TABLE %LexLink.table% DROP CONSTRAINT fk_%LexLink.table%_linkid CASCADE;
+LexLink.create=CREATE TABLE IF NOT EXISTS %LexLink.table% (synset1id INTEGER NOT NULL DEFAULT '0',word1id INTEGER NOT NULL DEFAULT '0',synset2id INTEGER NOT NULL DEFAULT '0',word2id INTEGER NOT NULL DEFAULT '0',linkid SMALLINT NOT NULL DEFAULT '0',CONSTRAINT pk_%LexLink.table% PRIMARY KEY (word1id,synset1id,word2id,synset2id,linkid));
+LexLink.pk=
+LexLink.no-pk=
+LexLink.index1=CREATE INDEX IF NOT EXISTS k_%LexLink.table%_synset1id_word1id ON %LexLink.table% (synset1id,word1id);
+LexLink.no-index1=DROP INDEX IF EXISTS k_%LexLink.table%_synset1id_word1id;
+LexLink.index2=CREATE INDEX IF NOT EXISTS k_%LexLink.table%_synset2id_word2id ON %LexLink.table% (synset2id,word2id);
+LexLink.no-index2=DROP INDEX IF EXISTS k_%LexLink.table%_synset2id_word2id;
+LexLink.index3=CREATE INDEX IF NOT EXISTS k_%LexLink.table%_linkid ON %LexLink.table% (linkid);
+LexLink.no-index3=DROP INDEX IF EXISTS k_%LexLink.table%_linkid;
+LexLink.index4=CREATE INDEX IF NOT EXISTS k_%LexLink.table%_synset1id ON %LexLink.table% (synset1id);
+LexLink.no-index4=DROP INDEX IF EXISTS k_%LexLink.table%_synset1id;
+LexLink.index5=CREATE INDEX IF NOT EXISTS k_%LexLink.table%_word1id ON %LexLink.table% (word1id);
+LexLink.no-index5=DROP INDEX IF EXISTS k_%LexLink.table%_word1id;
+LexLink.index6=CREATE INDEX IF NOT EXISTS k_%LexLink.table%_synset2id ON %LexLink.table% (synset2id);
+LexLink.no-index6=DROP INDEX IF EXISTS k_%LexLink.table%_synset2id;
+LexLink.index7=CREATE INDEX IF NOT EXISTS k_%LexLink.table%_word2id ON %LexLink.table% (word2id);
+LexLink.no-index7=DROP INDEX IF EXISTS k_%LexLink.table%_word2id;
+LexLink.fk1=
+LexLink.no-fk1=
+LexLink.fk2=
+LexLink.no-fk2=
+LexLink.fk3=
+LexLink.no-fk3=
+LexLink.fk4=
+LexLink.no-fk4=
+LexLink.fk5=
+LexLink.no-fk5=
 LexLink.insert=INSERT INTO %LexLink.table% (word1id,synset1id,word2id,synset2id,linkid) VALUES (?,?,?,?,?);
 
 Morph.table=morphs
-Morph.create=CREATE TABLE %Morph.table% (morphid INTEGER NOT NULL DEFAULT '0',morph VARCHAR (70) NOT NULL,CONSTRAINT pk_%Morph.table% PRIMARY KEY (morphid));
-Morph.pk=ALTER TABLE %Morph.table% ADD CONSTRAINT pk_%Morph.table% PRIMARY KEY (morphid);
-Morph.no-pk=ALTER TABLE %Morph.table% DROP CONSTRAINT pk_%Morph.table% CASCADE;
-Morph.unq=CREATE UNIQUE INDEX unq_%Morph.table%_morph ON %Morph.table% (morph);
-Morph.no-unq=DROP INDEX unq_%Morph.table%_morph;
+Morph.create=CREATE TABLE IF NOT EXISTS %Morph.table% (morphid INTEGER NOT NULL DEFAULT '0',morph VARCHAR (70) NOT NULL,CONSTRAINT pk_%Morph.table% PRIMARY KEY (morphid));
+Morph.pk=
+Morph.no-pk=
+Morph.unq=CREATE UNIQUE INDEX IF NOT EXISTS unq_%Morph.table%_morph ON %Morph.table% (morph);
+Morph.no-unq=DROP INDEX IF EXISTS unq_%Morph.table%_morph;
 Morph.insert=INSERT INTO %Morph.table% (morphid,morph) VALUES (?,?);
 
 MorphMap.table=morphmaps
-MorphMap.create=CREATE TABLE %MorphMap.table% (wordid INTEGER NOT NULL DEFAULT '0',pos CHARACTER (1) DEFAULT NULL,morphid INTEGER NOT NULL DEFAULT '0',CONSTRAINT pk_%MorphMap.table% PRIMARY KEY (morphid,pos,wordid));
-MorphMap.pk=ALTER TABLE %MorphMap.table% ADD CONSTRAINT pk_%MorphMap.table% PRIMARY KEY (morphid,pos,wordid);
-MorphMap.no-pk=ALTER TABLE %MorphMap.table% DROP CONSTRAINT pk_%MorphMap.table% CASCADE;
-MorphMap.index1=CREATE INDEX k_%MorphMap.table%_wordid ON %MorphMap.table% (wordid);
-MorphMap.no-index1=DROP INDEX k_%MorphMap.table%_wordid;
-MorphMap.index2=CREATE INDEX k_%MorphMap.table%_morphid ON %MorphMap.table% (morphid);
-MorphMap.no-index2=DROP INDEX k_%MorphMap.table%_morphid;
-MorphMap.fk1=ALTER TABLE %MorphMap.table% ADD CONSTRAINT fk_%MorphMap.table%_wordid FOREIGN KEY (wordid) REFERENCES %Word.table% (wordid);
-MorphMap.no-fk1=ALTER TABLE %MorphMap.table% DROP CONSTRAINT fk_%MorphMap.table%_wordid CASCADE;
-MorphMap.fk2=ALTER TABLE %MorphMap.table% ADD CONSTRAINT fk_%MorphMap.table%_morphid FOREIGN KEY (morphid) REFERENCES %Morph.table% (morphid);
-MorphMap.no-fk2=ALTER TABLE %MorphMap.table% DROP CONSTRAINT fk_%MorphMap.table%_morphid CASCADE;
+MorphMap.create=CREATE TABLE IF NOT EXISTS %MorphMap.table% (wordid INTEGER NOT NULL DEFAULT '0',pos CHARACTER (1) DEFAULT NULL,morphid INTEGER NOT NULL DEFAULT '0',CONSTRAINT pk_%MorphMap.table% PRIMARY KEY (morphid,pos,wordid));
+MorphMap.pk=
+MorphMap.no-pk=
+MorphMap.index1=CREATE INDEX IF NOT EXISTS k_%MorphMap.table%_wordid ON %MorphMap.table% (wordid);
+MorphMap.no-index1=DROP INDEX IF EXISTS k_%MorphMap.table%_wordid;
+MorphMap.index2=CREATE INDEX IF NOT EXISTS k_%MorphMap.table%_morphid ON %MorphMap.table% (morphid);
+MorphMap.no-index2=DROP INDEX IF EXISTS k_%MorphMap.table%_morphid;
+MorphMap.fk1=
+MorphMap.no-fk1=
+MorphMap.fk2=
+MorphMap.no-fk2=
 MorphMap.insert=INSERT INTO %MorphMap.table% (morphid,pos,wordid) VALUES (?,?,?);
 
 AdjPosition.table=adjpositions
-AdjPosition.create=CREATE TABLE %AdjPosition.table% (synsetid INTEGER NOT NULL DEFAULT '0',wordid INTEGER NOT NULL DEFAULT '0',position CHARACTER (2) NOT NULL,CONSTRAINT pk_%AdjPosition.table% PRIMARY KEY (synsetid,wordid));
-AdjPosition.pk=ALTER TABLE %AdjPosition.table% ADD CONSTRAINT pk_%AdjPosition.table% PRIMARY KEY (synsetid,wordid);
-AdjPosition.no-pk=ALTER TABLE %AdjPosition.table% DROP CONSTRAINT pk_%AdjPosition.table% CASCADE;
-AdjPosition.index1=CREATE INDEX k_%AdjPosition.table%_synsetid ON %AdjPosition.table% (synsetid);
-AdjPosition.no-index1=DROP INDEX k_%AdjPosition.table%_synsetid;
-AdjPosition.index2=CREATE INDEX k_%AdjPosition.table%_wordid ON %AdjPosition.table% (wordid);
-AdjPosition.no-index2=DROP INDEX k_%AdjPosition.table%_wordid;
-AdjPosition.fk1=ALTER TABLE %AdjPosition.table% ADD CONSTRAINT fk_%AdjPosition.table%_synsetid FOREIGN KEY (synsetid) REFERENCES %Synset.table% (synsetid);
-AdjPosition.no-fk1=ALTER TABLE %AdjPosition.table% DROP CONSTRAINT fk_%AdjPosition.table%_synsetid CASCADE;
-AdjPosition.fk2=ALTER TABLE %AdjPosition.table% ADD CONSTRAINT fk_%AdjPosition.table%_wordid FOREIGN KEY (wordid) REFERENCES %Word.table% (wordid);
-AdjPosition.no-fk2=ALTER TABLE %AdjPosition.table% DROP CONSTRAINT fk_%AdjPosition.table%_wordid CASCADE;
+AdjPosition.create=CREATE TABLE IF NOT EXISTS %AdjPosition.table% (synsetid INTEGER NOT NULL DEFAULT '0',wordid INTEGER NOT NULL DEFAULT '0',position CHARACTER (2) NOT NULL,CONSTRAINT pk_%AdjPosition.table% PRIMARY KEY (synsetid,wordid));
+AdjPosition.pk=
+AdjPosition.no-pk=
+AdjPosition.index1=CREATE INDEX IF NOT EXISTS k_%AdjPosition.table%_synsetid ON %AdjPosition.table% (synsetid);
+AdjPosition.no-index1=DROP INDEX IF EXISTS k_%AdjPosition.table%_synsetid;
+AdjPosition.index2=CREATE INDEX IF NOT EXISTS k_%AdjPosition.table%_wordid ON %AdjPosition.table% (wordid);
+AdjPosition.no-index2=DROP INDEX IF EXISTS k_%AdjPosition.table%_wordid;
+AdjPosition.fk1=
+AdjPosition.no-fk1=
+AdjPosition.fk2=
+AdjPosition.no-fk2=
 AdjPosition.insert=INSERT INTO %AdjPosition.table% (synsetid,wordid,position) VALUES (?,?,?);
 
 AdjPositionType.table=adjpositiontypes
-AdjPositionType.create=CREATE TABLE %AdjPositionType.table% (position CHARACTER (2) NOT NULL,positionname VARCHAR (24) NOT NULL,CONSTRAINT pk_%AdjPositionType.table% PRIMARY KEY (position));
-AdjPositionType.pk=ALTER TABLE %AdjPositionType.table% ADD CONSTRAINT pk_%AdjPositionType.table% PRIMARY KEY (position);
-AdjPositionType.no-pk=ALTER TABLE %AdjPositionType.table% DROP CONSTRAINT pk_%AdjPositionType.table% CASCADE;
+AdjPositionType.create=CREATE TABLE IF NOT EXISTS %AdjPositionType.table% (position CHARACTER (2) NOT NULL,positionname VARCHAR (24) NOT NULL,CONSTRAINT pk_%AdjPositionType.table% PRIMARY KEY (position));
+AdjPositionType.pk=
+AdjPositionType.no-pk=
 AdjPositionType.insert=INSERT INTO %AdjPositionType.table% (position,positionname) VALUES (?,?);
 
 VFrame.table=vframes
-VFrame.create=CREATE TABLE %VFrame.table% (frameid SMALLINT NOT NULL DEFAULT '0',frame VARCHAR (50) DEFAULT NULL,CONSTRAINT pk_%VFrame.table% PRIMARY KEY (frameid));
-VFrame.pk=ALTER TABLE %VFrame.table% ADD CONSTRAINT pk_%VFrame.table% PRIMARY KEY (frameid);
-VFrame.no-pk=ALTER TABLE %VFrame.table% DROP CONSTRAINT pk_%VFrame.table% CASCADE;
+VFrame.create=CREATE TABLE IF NOT EXISTS %VFrame.table% (frameid SMALLINT NOT NULL DEFAULT '0',frame VARCHAR (50) DEFAULT NULL,CONSTRAINT pk_%VFrame.table% PRIMARY KEY (frameid));
+VFrame.pk=
+VFrame.no-pk=
 VFrame.insert=INSERT INTO %VFrame.table% (frameid,frame) VALUES (?,?);
 VFrame.select=SELECT frameid FROM %VFrame.table% WHERE frameid = ?;
 
 VFrameMap.table=vframemaps
-VFrameMap.create=CREATE TABLE %VFrameMap.table% (synsetid INTEGER NOT NULL DEFAULT '0',wordid INTEGER DEFAULT NULL,frameid SMALLINT NOT NULL DEFAULT '0',CONSTRAINT pk_%VFrameMap.table% PRIMARY KEY (synsetid,wordid,frameid));
-VFrameMap.pk=ALTER TABLE %VFrameMap.table% ADD CONSTRAINT pk_%VFrameMap.table% PRIMARY KEY (synsetid,wordid,frameid);
-VFrameMap.no-pk=ALTER TABLE %VFrameMap.table% DROP CONSTRAINT pk_%VFrameMap.table% CASCADE;
-VFrameMap.index1=CREATE INDEX k_%VFrameMap.table%_frameid ON %VFrameMap.table% (frameid);
-VFrameMap.no-index1=DROP INDEX k_%VFrameMap.table%_frameid;
-VFrameMap.index2=CREATE INDEX k_%VFrameMap.table%_synsetid ON %VFrameMap.table% (synsetid);
-VFrameMap.no-index2=DROP INDEX k_%VFrameMap.table%_synsetid;
-VFrameMap.index3=CREATE INDEX k_%VFrameMap.table%_wordid ON %VFrameMap.table% (wordid);
-VFrameMap.no-index3=DROP INDEX k_%VFrameMap.table%_wordid;
-VFrameMap.fk1=ALTER TABLE %VFrameMap.table% ADD CONSTRAINT fk_%VFrameMap.table%_frameid FOREIGN KEY (frameid) REFERENCES %VFrame.table% (frameid);
-VFrameMap.no-fk1=ALTER TABLE %VFrameMap.table% DROP CONSTRAINT fk_%VFrameMap.table%_frameid CASCADE;
-VFrameMap.fk2=ALTER TABLE %VFrameMap.table% ADD CONSTRAINT fk_%VFrameMap.table%_synsetid FOREIGN KEY (synsetid) REFERENCES %Synset.table% (synsetid);
-VFrameMap.no-fk2=ALTER TABLE %VFrameMap.table% DROP CONSTRAINT fk_%VFrameMap.table%_synsetid CASCADE;
-VFrameMap.fk3=ALTER TABLE %VFrameMap.table% ADD CONSTRAINT fk_%VFrameMap.table%_wordid FOREIGN KEY (wordid) REFERENCES %Word.table% (wordid);
-VFrameMap.no-fk3=ALTER TABLE %VFrameMap.table% DROP CONSTRAINT fk_%VFrameMap.table%_wordid CASCADE;
+VFrameMap.create=CREATE TABLE IF NOT EXISTS %VFrameMap.table% (synsetid INTEGER NOT NULL DEFAULT '0',wordid INTEGER DEFAULT NULL,frameid SMALLINT NOT NULL DEFAULT '0',CONSTRAINT pk_%VFrameMap.table% PRIMARY KEY (synsetid,wordid,frameid));
+VFrameMap.pk=
+VFrameMap.no-pk=
+VFrameMap.index1=CREATE INDEX IF NOT EXISTS k_%VFrameMap.table%_frameid ON %VFrameMap.table% (frameid);
+VFrameMap.no-index1=DROP INDEX IF EXISTS k_%VFrameMap.table%_frameid;
+VFrameMap.index2=CREATE INDEX IF NOT EXISTS k_%VFrameMap.table%_synsetid ON %VFrameMap.table% (synsetid);
+VFrameMap.no-index2=DROP INDEX IF EXISTS k_%VFrameMap.table%_synsetid;
+VFrameMap.index3=CREATE INDEX IF NOT EXISTS k_%VFrameMap.table%_wordid ON %VFrameMap.table% (wordid);
+VFrameMap.no-index3=DROP INDEX IF EXISTS k_%VFrameMap.table%_wordid;
+VFrameMap.fk1=
+VFrameMap.no-fk1=
+VFrameMap.fk2=
+VFrameMap.no-fk2=
+VFrameMap.fk3=
+VFrameMap.no-fk3=
 VFrameMap.insert=INSERT INTO %VFrameMap.table% (synsetid,wordid,frameid) VALUES (?,?,?);
 
 VFrameSentence.table=vframesentences
-VFrameSentence.create=CREATE TABLE %VFrameSentence.table% (sentenceid SMALLINT NOT NULL DEFAULT '0',sentence TEXT DEFAULT NULL,CONSTRAINT pk_%VFrameSentence.table% PRIMARY KEY (sentenceid));
-VFrameSentence.pk=ALTER TABLE %VFrameSentence.table% ADD CONSTRAINT pk_%VFrameSentence.table% PRIMARY KEY (sentenceid);
-VFrameSentence.no-pk=ALTER TABLE %VFrameSentence.table% DROP CONSTRAINT pk_%VFrameSentence.table% CASCADE;
+VFrameSentence.create=CREATE TABLE IF NOT EXISTS %VFrameSentence.table% (sentenceid SMALLINT NOT NULL DEFAULT '0',sentence TEXT DEFAULT NULL,CONSTRAINT pk_%VFrameSentence.table% PRIMARY KEY (sentenceid));
+VFrameSentence.pk=
+VFrameSentence.no-pk=
 VFrameSentence.insert=INSERT INTO %VFrameSentence.table% (sentenceid,sentence) VALUES (?,?);
 
 VFrameSentenceMap.table=vframesentencemaps
-VFrameSentenceMap.create=CREATE TABLE %VFrameSentenceMap.table% (synsetid INTEGER NOT NULL DEFAULT '0',wordid INTEGER NOT NULL DEFAULT '0',sentenceid SMALLINT NOT NULL DEFAULT '0',CONSTRAINT pk_%VFrameSentenceMap.table% PRIMARY KEY (synsetid,wordid,sentenceid));
-VFrameSentenceMap.pk=ALTER TABLE %VFrameSentenceMap.table% ADD CONSTRAINT pk_%VFrameSentenceMap.table% PRIMARY KEY (synsetid,wordid,sentenceid);
-VFrameSentenceMap.no-pk=ALTER TABLE %VFrameSentenceMap.table% DROP CONSTRAINT pk_%VFrameSentenceMap.table% CASCADE;
-VFrameSentenceMap.index1=CREATE INDEX k_%VFrameSentenceMap.table%_sentenceid ON %VFrameSentenceMap.table% (sentenceid);
-VFrameSentenceMap.no-index1=DROP INDEX k_%VFrameSentenceMap.table%_sentenceid;
-VFrameSentenceMap.index2=CREATE INDEX k_%VFrameSentenceMap.table%_synsetid ON %VFrameSentenceMap.table% (synsetid);
-VFrameSentenceMap.no-index2=DROP INDEX k_%VFrameSentenceMap.table%_synsetid;
-VFrameSentenceMap.index3=CREATE INDEX k_%VFrameSentenceMap.table%_wordid ON %VFrameSentenceMap.table% (wordid);
-VFrameSentenceMap.no-index3=DROP INDEX k_%VFrameSentenceMap.table%_wordid;
-VFrameSentenceMap.fk1=ALTER TABLE %VFrameSentenceMap.table% ADD CONSTRAINT fk_%VFrameSentenceMap.table%_sentenceid FOREIGN KEY (sentenceid) REFERENCES %VFrameSentence.table% (sentenceid);
-VFrameSentenceMap.no-fk1=ALTER TABLE %VFrameSentenceMap.table% DROP CONSTRAINT fk_%VFrameSentenceMap.table%_sentenceid CASCADE;
-VFrameSentenceMap.fk2=ALTER TABLE %VFrameSentenceMap.table% ADD CONSTRAINT fk_%VFrameSentenceMap.table%_synsetid FOREIGN KEY (synsetid) REFERENCES %Synset.table% (synsetid);
-VFrameSentenceMap.no-fk2=ALTER TABLE %VFrameSentenceMap.table% DROP CONSTRAINT fk_%VFrameSentenceMap.table%_synsetid CASCADE;
-VFrameSentenceMap.fk3=ALTER TABLE %VFrameSentenceMap.table% ADD CONSTRAINT fk_%VFrameSentenceMap.table%_wordid FOREIGN KEY (wordid) REFERENCES %Word.table% (wordid);
-VFrameSentenceMap.no-fk3=ALTER TABLE %VFrameSentenceMap.table% DROP CONSTRAINT fk_%VFrameSentenceMap.table%_wordid CASCADE;
+VFrameSentenceMap.create=CREATE TABLE IF NOT EXISTS %VFrameSentenceMap.table% (synsetid INTEGER NOT NULL DEFAULT '0',wordid INTEGER NOT NULL DEFAULT '0',sentenceid SMALLINT NOT NULL DEFAULT '0',CONSTRAINT pk_%VFrameSentenceMap.table% PRIMARY KEY (synsetid,wordid,sentenceid));
+VFrameSentenceMap.pk=
+VFrameSentenceMap.no-pk=
+VFrameSentenceMap.index1=CREATE INDEX IF NOT EXISTS k_%VFrameSentenceMap.table%_sentenceid ON %VFrameSentenceMap.table% (sentenceid);
+VFrameSentenceMap.no-index1=DROP INDEX IF EXISTS k_%VFrameSentenceMap.table%_sentenceid;
+VFrameSentenceMap.index2=CREATE INDEX IF NOT EXISTS k_%VFrameSentenceMap.table%_synsetid ON %VFrameSentenceMap.table% (synsetid);
+VFrameSentenceMap.no-index2=DROP INDEX IF EXISTS k_%VFrameSentenceMap.table%_synsetid;
+VFrameSentenceMap.index3=CREATE INDEX IF NOT EXISTS k_%VFrameSentenceMap.table%_wordid ON %VFrameSentenceMap.table% (wordid);
+VFrameSentenceMap.no-index3=DROP INDEX IF EXISTS k_%VFrameSentenceMap.table%_wordid;
+VFrameSentenceMap.fk1=
+VFrameSentenceMap.no-fk1=
+VFrameSentenceMap.fk2=
+VFrameSentenceMap.no-fk2=
+VFrameSentenceMap.fk3=
+VFrameSentenceMap.no-fk3=
 VFrameSentenceMap.insert=INSERT INTO %VFrameSentenceMap.table% (synsetid,wordid,sentenceid) VALUES (?,?,?);
 
+Members.extend=ALTER TABLE %Synset.table% ADD COLUMN members VARCHAR(256);
+Members.no-extend=ALTER TABLE %Synset.table% DROP COLUMN members;
+Members.update=UPDATE %Synset.table% SET members = ? WHERE synsetid = ?;
+
 wn0.Sampleset.view=samplesets
-wn0.Sampleset.createview=CREATE OR REPLACE VIEW %wn0.Sampleset.view% AS SELECT s.synsetid,array_to_string(ARRAY (SELECT %Sample.table%.sample FROM %Sample.table% WHERE synsetid = s.synsetid ORDER BY sampleid),'|') AS sampleset FROM %Sample.table% AS s GROUP BY s.synsetid ORDER BY s.synsetid;
+wn0.Sampleset.createview=DROP VIEW IF EXISTS %wn0.Sampleset.view%; CREATE VIEW %wn0.Sampleset.view% AS SELECT synsetid,GROUP_CONCAT(DISTINCT %Sample.table%.sample,'|') AS sampleset FROM %Sample.table% GROUP BY synsetid;
 wn0.WordXSense.view=wordsXsenses
-wn0.WordXSense.createview=CREATE OR REPLACE VIEW %wn0.WordXSense.view% AS SELECT * FROM %Word.table% INNER JOIN %Sense.table% USING (wordid);
+wn0.WordXSense.createview=DROP VIEW IF EXISTS %wn0.WordXSense.view%; CREATE VIEW %wn0.WordXSense.view% AS SELECT * FROM %Word.table% INNER JOIN %Sense.table% USING (wordid);
 wn0.SenseXSynset.view=sensesXsynsets
-wn0.SenseXSynset.createview=CREATE OR REPLACE VIEW %wn0.SenseXSynset.view% AS SELECT * FROM %Sense.table% INNER JOIN %Synset.table% USING (synsetid);
+wn0.SenseXSynset.createview=DROP VIEW IF EXISTS %wn0.SenseXSynset.view%; CREATE VIEW %wn0.SenseXSynset.view% AS SELECT * FROM %Sense.table% INNER JOIN %Synset.table% USING (synsetid);
 wn0.WordXSenseXSynset.view=wordsXsensesXsynsets
-wn0.WordXSenseXSynset.createview=CREATE OR REPLACE VIEW %wn0.WordXSenseXSynset.view% AS SELECT * FROM %Word.table% INNER JOIN %Sense.table% USING (wordid) INNER JOIN %Synset.table% USING (synsetid);
+wn0.WordXSenseXSynset.createview=DROP VIEW IF EXISTS %wn0.WordXSenseXSynset.view%; CREATE VIEW %wn0.WordXSenseXSynset.view% AS SELECT * FROM %Word.table% INNER JOIN %Sense.table% USING (wordid) INNER JOIN %Synset.table% USING (synsetid);
 wn1.SenseXSemlinkXSense.view=sensesXsemlinksXsenses
-wn1.SenseXSemlinkXSense.createview=CREATE OR REPLACE VIEW %wn1.SenseXSemlinkXSense.view% AS SELECT linkid,s.synsetid AS ssynsetid,s.wordid AS swordid,s.senseid AS ssenseid,s.casedwordid AS scasedwordid,s.sensenum AS ssensenum,s.lexid AS slexid,s.tagcount AS stagcount,s.sensekey AS ssensekey,s.pos AS spos,s.lexdomainid AS slexdomainid,s.definition AS sdefinition,d.synsetid AS dsynsetid,d.wordid AS dwordid,d.senseid AS dsenseid,d.casedwordid AS dcasedwordid,d.sensenum AS dsensenum,d.lexid AS dlexid,d.tagcount AS dtagcount,d.sensekey AS dsensekey,d.pos AS dpos,d.lexdomainid AS dlexdomainid,d.definition AS ddefinition FROM %wn0.SenseXSynset.view% AS s INNER JOIN %SemLink.table% AS l ON s.synsetid = l.synset1id INNER JOIN %wn0.SenseXSynset.view% AS d ON l.synset2id = d.synsetid;
+wn1.SenseXSemlinkXSense.createview=DROP VIEW IF EXISTS %wn1.SenseXSemlinkXSense.view%; CREATE VIEW %wn1.SenseXSemlinkXSense.view% AS SELECT linkid,s.synsetid AS ssynsetid,s.wordid AS swordid,s.senseid AS ssenseid,s.casedwordid AS scasedwordid,s.sensenum AS ssensenum,s.lexid AS slexid,s.tagcount AS stagcount,s.sensekey AS ssensekey,s.pos AS spos,s.lexdomainid AS slexdomainid,s.definition AS sdefinition,d.synsetid AS dsynsetid,d.wordid AS dwordid,d.senseid AS dsenseid,d.casedwordid AS dcasedwordid,d.sensenum AS dsensenum,d.lexid AS dlexid,d.tagcount AS dtagcount,d.sensekey AS dsensekey,d.pos AS dpos,d.lexdomainid AS dlexdomainid,d.definition AS ddefinition FROM %wn0.SenseXSynset.view% AS s INNER JOIN %SemLink.table% AS l ON s.synsetid = l.synset1id INNER JOIN %wn0.SenseXSynset.view% AS d ON l.synset2id = d.synsetid;
 wn1.SynsetXSemlinkXSynset.view=synsetsXsemlinksXsynsets
-wn1.SynsetXSemlinkXSynset.createview=CREATE OR REPLACE VIEW %wn1.SynsetXSemlinkXSynset.view% AS SELECT linkid,s.synsetid AS ssynsetid,s.definition AS sdefinition,d.synsetid AS dsynsetid,d.definition AS ddefinition FROM %Synset.table% AS s INNER JOIN %SemLink.table% AS l ON s.synsetid = l.synset1id INNER JOIN %Synset.table% AS d ON l.synset2id = d.synsetid;
+wn1.SynsetXSemlinkXSynset.createview=DROP VIEW IF EXISTS %wn1.SynsetXSemlinkXSynset.view%; CREATE VIEW %wn1.SynsetXSemlinkXSynset.view% AS SELECT linkid,s.synsetid AS ssynsetid,s.definition AS sdefinition,d.synsetid AS dsynsetid,d.definition AS ddefinition FROM %Synset.table% AS s INNER JOIN %SemLink.table% AS l ON s.synsetid = l.synset1id INNER JOIN %Synset.table% AS d ON l.synset2id = d.synsetid;
 wn1.SenseXLexlinkXSense.view=sensesXlexlinksXsenses
-wn1.SenseXLexlinkXSense.createview=CREATE OR REPLACE VIEW %wn1.SenseXLexlinkXSense.view% AS SELECT linkid,s.synsetid AS ssynsetid,s.wordid AS swordid,s.senseid AS ssenseid,s.casedwordid AS scasedwordid,s.sensenum AS ssensenum,s.lexid AS slexid,s.tagcount AS stagcount,s.sensekey AS ssensekey,s.pos AS spos,s.lexdomainid AS slexdomainid,s.definition AS sdefinition,d.synsetid AS dsynsetid,d.wordid AS dwordid,d.senseid AS dsenseid,d.casedwordid AS dcasedwordid,d.sensenum AS dsensenum,d.lexid AS dlexid,d.tagcount AS dtagcount,d.sensekey AS dsensekey,d.pos AS dpos,d.lexdomainid AS dlexdomainid,d.definition AS ddefinition FROM %wn0.SenseXSynset.view% AS s INNER JOIN %LexLink.table% AS l ON s.synsetid = l.synset1id AND s.wordid = l.word1id INNER JOIN %wn0.SenseXSynset.view% AS d ON l.synset2id = d.synsetid AND l.word2id = d.wordid;
+wn1.SenseXLexlinkXSense.createview=DROP VIEW IF EXISTS %wn1.SenseXLexlinkXSense.view%; CREATE VIEW %wn1.SenseXLexlinkXSense.view% AS SELECT linkid,s.synsetid AS ssynsetid,s.wordid AS swordid,s.senseid AS ssenseid,s.casedwordid AS scasedwordid,s.sensenum AS ssensenum,s.lexid AS slexid,s.tagcount AS stagcount,s.sensekey AS ssensekey,s.pos AS spos,s.lexdomainid AS slexdomainid,s.definition AS sdefinition,d.synsetid AS dsynsetid,d.wordid AS dwordid,d.senseid AS dsenseid,d.casedwordid AS dcasedwordid,d.sensenum AS dsensenum,d.lexid AS dlexid,d.tagcount AS dtagcount,d.sensekey AS dsensekey,d.pos AS dpos,d.lexdomainid AS dlexdomainid,d.definition AS ddefinition FROM %wn0.SenseXSynset.view% AS s INNER JOIN %LexLink.table% AS l ON s.synsetid = l.synset1id AND s.wordid = l.word1id INNER JOIN %wn0.SenseXSynset.view% AS d ON l.synset2id = d.synsetid AND l.word2id = d.wordid;
 wn1.Dict.view=dict
-wn1.Dict.createview=CREATE OR REPLACE VIEW %wn1.Dict.view% AS SELECT * FROM %Word.table% LEFT JOIN %Sense.table% s USING (wordid) LEFT JOIN %CasedWord.table% USING (wordid,casedwordid) LEFT JOIN %Synset.table% USING (synsetid) LEFT JOIN %wn0.Sampleset.view% USING (synsetid);
+wn1.Dict.createview=DROP VIEW IF EXISTS %wn1.Dict.view%; CREATE VIEW %wn1.Dict.view% AS SELECT * FROM %Word.table% LEFT JOIN %Sense.table% s USING (wordid) LEFT JOIN %CasedWord.table% USING (wordid,casedwordid) LEFT JOIN %Synset.table% USING (synsetid) LEFT JOIN %wn0.Sampleset.view% USING (synsetid);
 wn1.Morphology.view=morphology
-wn1.Morphology.createview=CREATE OR REPLACE VIEW %wn1.Morphology.view% AS SELECT * FROM %Word.table% INNER JOIN %MorphMap.table% USING (wordid) INNER JOIN %Morph.table% USING (morphid);
+wn1.Morphology.createview=DROP VIEW IF EXISTS %wn1.Morphology.view%; CREATE VIEW %wn1.Morphology.view% AS SELECT * FROM %Word.table% INNER JOIN %MorphMap.table% USING (wordid) INNER JOIN %Morph.table% USING (morphid);
 wn1.VerbsWithFrames.view=verbswithframes
-wn1.VerbsWithFrames.createview=CREATE OR REPLACE VIEW %wn1.VerbsWithFrames.view% AS SELECT * FROM %Sense.table% INNER JOIN %VFrameMap.table% USING (wordid,synsetid) INNER JOIN %VFrame.table% USING (frameid) LEFT JOIN %Word.table% USING (wordid) LEFT JOIN %Synset.table% USING (synsetid);
+wn1.VerbsWithFrames.createview=DROP VIEW IF EXISTS %wn1.VerbsWithFrames.view%; CREATE VIEW %wn1.VerbsWithFrames.view% AS SELECT * FROM %Sense.table% INNER JOIN %VFrameMap.table% USING (wordid,synsetid) INNER JOIN %VFrame.table% USING (frameid) LEFT JOIN %Word.table% USING (wordid) LEFT JOIN %Synset.table% USING (synsetid);
 wn1.AdjsWithPos.view=adjectiveswithpositions
-wn1.AdjsWithPos.createview=CREATE OR REPLACE VIEW %wn1.AdjsWithPos.view% AS SELECT * FROM %Sense.table% INNER JOIN %AdjPosition.table% USING (wordid,synsetid) LEFT JOIN %Word.table% USING (wordid) LEFT JOIN %Synset.table% USING (synsetid);
+wn1.AdjsWithPos.createview=DROP VIEW IF EXISTS %wn1.AdjsWithPos.view%; CREATE VIEW %wn1.AdjsWithPos.view% AS SELECT * FROM %Sense.table% INNER JOIN %AdjPosition.table% USING (wordid,synsetid) LEFT JOIN %Word.table% USING (wordid) LEFT JOIN %Synset.table% USING (synsetid);