Diff of /glosslf/src/main/resources/org/wnsql/builder/glosslf/test.properties [b947d4] .. [19e22f]  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,18 +1,18 @@
 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.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.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;
+GLFlf.create=CREATE TABLE IF NOT EXISTS %GLFlf.table% (wordid INTEGER UNSIGNED NOT NULL,synsetid INTEGER UNSIGNED NOT NULL,lf MEDIUMTEXT NOT NULL,`text` MEDIUMTEXT NULL,issub BOOLEAN NOT NULL) DEFAULT CHARSET=utf8;
+GLFlf.insert=INSERT INTO %GLFlf.table% (wordid,synsetid,lf,`text`,issub) VALUES (?,?,?,?,?);
+GLFlf.unq=ALTER TABLE %GLFlf.table% ADD CONSTRAINT unq_%GLFlf.table%_wordid_synsetid_lf_issub UNIQUE KEY (wordid,synsetid,lf (128),issub);
+GLFlf.no-unq=ALTER TABLE %GLFlf.table% DROP INDEX unq_%GLFlf.table%_wordid_synsetid_lf_issub;
+GLFlf.index1=ALTER TABLE %GLFlf.table% ADD INDEX k_%GLFlf.table%_wordid (wordid);
+GLFlf.no-index1=ALTER TABLE %GLFlf.table% DROP INDEX k_%GLFlf.table%_wordid;
+GLFlf.index2=ALTER TABLE %GLFlf.table% ADD INDEX k_%GLFlf.table%_synsetid (synsetid);
+GLFlf.no-index2=ALTER TABLE %GLFlf.table% DROP INDEX k_%GLFlf.table%_synsetid;
+GLFlf.fk1=ALTER TABLE %GLFlf.table% ADD CONSTRAINT fk_%GLFlf.table%_wordid FOREIGN KEY k_%GLFlf.table%_wordid (wordid) REFERENCES %Word.table% (wordid);
+GLFlf.no-fk1=ALTER TABLE %GLFlf.table% DROP FOREIGN KEY fk_%GLFlf.table%_wordid;
+GLFlf.fk2=ALTER TABLE %GLFlf.table% ADD CONSTRAINT fk_%GLFlf.table%_synsetid FOREIGN KEY k_%GLFlf.table%_synsetid (synsetid) REFERENCES %Synset.table% (synsetid);
+GLFlf.no-fk2=ALTER TABLE %GLFlf.table% DROP FOREIGN KEY fk_%GLFlf.table%_synsetid;
+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;
 
 GLFSense.select=SELECT wordid,synsetid,definition FROM %Word.table% LEFT JOIN %Sense.table% USING (wordid) LEFT JOIN %Synset.table% USING (synsetid) WHERE lemma = ? AND sensenum = ? AND pos = ?;
 GLFSense.select.adj=SELECT wordid,synsetid,definition FROM %Word.table% LEFT JOIN %Sense.table% USING (wordid) LEFT JOIN %Synset.table% USING (synsetid) WHERE lemma = ? AND sensenum = ? AND (pos = 'a' OR pos = 's');

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

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks