[19e22f]: glosslf / src / main / resources / org / wnsql / builder / glosslf / test.properties  Maximize  Restore  History

Download this file

19 lines (17 with data), 2.2 kB

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
GLFlf.table=glfs
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:





No, thanks