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

  Switch to side-by-side view

--- a/glosslf/src/main/resources/org/wnsql/builder/glosslf/test.properties
+++ b/glosslf/src/main/resources/org/wnsql/builder/glosslf/test.properties
@@ -1,16 +1,16 @@
 GLFlf.table=glfs
-GLFlf.create=CREATE TABLE %GLFlf.table% (wordid INTEGER NOT NULL,synsetid INTEGER NOT NULL,lf TEXT NOT NULL,text TEXT NULL,issub BOOLEAN NOT NULL);
+GLFlf.create=CREATE TABLE IF NOT EXISTS %GLFlf.table% (wordid INTEGER NOT NULL,synsetid INTEGER NOT NULL,lf TEXT NOT NULL,text TEXT NULL,issub BOOLEAN NOT NULL);
 GLFlf.insert=INSERT INTO %GLFlf.table% (wordid,synsetid,lf,text,issub) VALUES (?,?,?,?,?);
-GLFlf.unq=CREATE UNIQUE INDEX unq_%GLFlf.table%_wordid_synsetid_lf_issub ON %GLFlf.table% (wordid,synsetid,lf,issub);
-GLFlf.no-unq=DROP INDEX unq_%GLFlf.table%_wordid_synsetid_lf_issub;
-GLFlf.index1=CREATE INDEX k_%GLFlf.table%_wordid ON %GLFlf.table% (wordid);
-GLFlf.no-index1=DROP INDEX k_%GLFlf.table%_wordid;
-GLFlf.index2=CREATE INDEX k_%GLFlf.table%_synsetid ON %GLFlf.table% (synsetid);
-GLFlf.no-index2=DROP INDEX k_%GLFlf.table%_synsetid;
-GLFlf.fk1=ALTER TABLE %GLFlf.table% ADD CONSTRAINT fk_%GLFlf.table%_wordid FOREIGN KEY (wordid) REFERENCES %Word.table% (wordid);
-GLFlf.no-fk1=ALTER TABLE %GLFlf.table% DROP CONSTRAINT fk_%GLFlf.table%_wordid CASCADE;
-GLFlf.fk2=ALTER TABLE %GLFlf.table% ADD CONSTRAINT fk_%GLFlf.table%_synsetid FOREIGN KEY (synsetid) REFERENCES %Synset.table% (synsetid);
-GLFlf.no-fk2=ALTER TABLE %GLFlf.table% DROP CONSTRAINT fk_%GLFlf.table%_synsetid CASCADE;
+GLFlf.unq=CREATE UNIQUE INDEX IF NOT EXISTS unq_%GLFlf.table%_wordid_synsetid_lf_issub ON %GLFlf.table% (wordid,synsetid,lf,issub);
+GLFlf.no-unq=DROP INDEX IF EXISTS unq_%GLFlf.table%_wordid_synsetid_lf_issub;
+GLFlf.index1=CREATE INDEX IF NOT EXISTS k_%GLFlf.table%_wordid ON %GLFlf.table% (wordid);
+GLFlf.no-index1=DROP INDEX IF EXISTS k_%GLFlf.table%_wordid;
+GLFlf.index2=CREATE INDEX IF NOT EXISTS k_%GLFlf.table%_synsetid ON %GLFlf.table% (synsetid);
+GLFlf.no-index2=DROP INDEX IF EXISTS k_%GLFlf.table%_synsetid;
+GLFlf.fk1=
+GLFlf.no-fk1=
+GLFlf.fk2=
+GLFlf.no-fk2=
 GLFlf.select=SELECT %GLFlf.table%.synsetid,%GLFlf.table%.wsd,%GLFlf.table%.text FROM %GLFlf.table% WHERE %GLFlf.table%.synsetid = ? AND %GLFlf.table%.lf = ? AND %GLFlf.table%.text = ?;
 GLFlf.select2=SELECT %GLFlf.table%.synsetid,%GLFlf.table%.wsd,%GLFlf.table%.text FROM %GLFlf.table% WHERE %GLFlf.table%.synsetid = ? AND %GLFlf.table%.lf = ? AND %GLFlf.table%.text IS NULL;