Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

[68ae6b]: legacy / src / main / resources / org / wnsql / builder / legacy / mysql.properties Maximize Restore History

Download this file

mysql.properties    86 lines (79 with data), 11.7 kB

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
LegacySense.table.base=senses
LegacySynset.table.base=synsets
LegacySynsetMap.table.base=synsetmaps
LegacySenseMap.table.base=sensemaps
LegacyComputedSenseMap.table.base=sensemaps
Legacy.view.base=legacy
LegacySynset.view.base=synsets
LegacySense$X$.table=%LegacySense.table.base%$X$
LegacySense$X$.create=CREATE TABLE IF NOT EXISTS %LegacySense$X$.table% (wordid INTEGER UNSIGNED NOT NULL DEFAULT '0',synsetid INTEGER UNSIGNED NOT NULL DEFAULT '0',pos ENUM ('n','v','a','r','s') NOT NULL,senseid INTEGER UNSIGNED NULL,sensenum SMALLINT UNSIGNED NOT NULL DEFAULT '0',sensekey VARCHAR (100) DEFAULT NULL,PRIMARY KEY (wordid,synsetid)) DEFAULT CHARSET=utf8;
LegacySense$X$.pk=ALTER TABLE %LegacySense$X$.table% ADD CONSTRAINT pk_%LegacySense$X$.table% PRIMARY KEY (wordid,synsetid);
LegacySense$X$.no-pk=ALTER TABLE %LegacySense$X$.table% DROP PRIMARY KEY;
LegacySense$X$.unq1=ALTER TABLE %LegacySense$X$.table% ADD CONSTRAINT unq_%LegacySense$X$.table%_senseid UNIQUE KEY (senseid);
LegacySense$X$.no-unq1=ALTER TABLE %LegacySense$X$.table% DROP INDEX unq_%LegacySense$X$.table%_senseid;
LegacySense$X$.unq2=ALTER TABLE %LegacySense$X$.table% ADD CONSTRAINT unq_%LegacySense$X$.table%_sensekey UNIQUE KEY (sensekey);
LegacySense$X$.no-unq2=ALTER TABLE %LegacySense$X$.table% DROP INDEX unq_%LegacySense$X$.table%_sensekey;
LegacySense$X$.index1=ALTER TABLE %LegacySense$X$.table% ADD INDEX k_%LegacySense$X$.table%_wordid (wordid);
LegacySense$X$.no-index1=ALTER TABLE %LegacySense$X$.table% DROP INDEX k_%LegacySense$X$.table%_wordid;
LegacySense$X$.index2=ALTER TABLE %LegacySense$X$.table% ADD INDEX k_%LegacySense$X$.table%_synsetid (synsetid);
LegacySense$X$.no-index2=ALTER TABLE %LegacySense$X$.table% DROP INDEX k_%LegacySense$X$.table%_synsetid;
LegacySense$X$.fk=ALTER TABLE %LegacySense$X$.table% ADD CONSTRAINT fk_%LegacySense$X$.table%_wordid FOREIGN KEY k_%LegacySense$X$.table%_wordid (wordid) REFERENCES %Word.table% (wordid);
LegacySense$X$.no-fk=ALTER TABLE %LegacySense$X$.table% DROP FOREIGN KEY fk_%LegacySense$X$.table%_wordid;
LegacySense$X$.insert=INSERT INTO %LegacySense$X$.table% (wordid,synsetid,pos,sensenum,senseid,sensekey) VALUES (?,?,?,?,?,?);
LegacySynsetMap$X$~$Y$.table=%LegacySynsetMap.table.base%$X$$Y$
LegacySynsetMap$X$~$Y$.create=CREATE TABLE IF NOT EXISTS %LegacySynsetMap$X$~$Y$.table% (synsetid INTEGER UNSIGNED NOT NULL,srcsynsetid INTEGER UNSIGNED NOT NULL,quality FLOAT NOT NULL,PRIMARY KEY (synsetid,srcsynsetid,quality)) DEFAULT CHARSET=utf8;
LegacySynsetMap$X$~$Y$.pk=ALTER TABLE %LegacySynsetMap$X$~$Y$.table% ADD CONSTRAINT pk_%LegacySynsetMap$X$~$Y$.table% PRIMARY KEY (synsetid,srcsynsetid,quality);
LegacySynsetMap$X$~$Y$.no-pk=ALTER TABLE %LegacySynsetMap$X$~$Y$.table% DROP PRIMARY KEY;
LegacySynsetMap$X$~$Y$.index1=ALTER TABLE %LegacySynsetMap$X$~$Y$.table% ADD INDEX k_%LegacySynsetMap$X$~$Y$.table%_synsetid (synsetid);
LegacySynsetMap$X$~$Y$.no-index1=ALTER TABLE %LegacySynsetMap$X$~$Y$.table% DROP INDEX k_%LegacySynsetMap$X$~$Y$.table%_synsetid;
LegacySynsetMap$X$~$Y$.index2=ALTER TABLE %LegacySynsetMap$X$~$Y$.table% ADD INDEX k_%LegacySynsetMap$X$~$Y$.table%_srcsynsetid (srcsynsetid);
LegacySynsetMap$X$~$Y$.no-index2=ALTER TABLE %LegacySynsetMap$X$~$Y$.table% DROP INDEX k_%LegacySynsetMap$X$~$Y$.table%_srcsynsetid;
LegacySynsetMap$X$~$Y$.fk=ALTER TABLE %LegacySynsetMap$X$~$Y$.table% ADD CONSTRAINT fk_%LegacySynsetMap$X$~$Y$.table%_synsetid FOREIGN KEY k_%LegacySynsetMap$X$~$Y$.table%_synsetid (synsetid) REFERENCES %Synset.table% (synsetid);
LegacySynsetMap$X$~$Y$.no-fk=ALTER TABLE %LegacySynsetMap$X$~$Y$.table% DROP FOREIGN KEY fk_%LegacySynsetMap$X$~$Y$.table%_synsetid;
LegacySynsetMap$X$~$Y$.insert=INSERT INTO %LegacySynsetMap$X$~$Y$.table% (synsetid,srcsynsetid,quality) VALUES (?,?,?);
LegacySynsetMap$X$~$Y$.select=SELECT synsetid,srcsynsetid,quality FROM %LegacySynsetMap$X$~$Y$.table% WHERE synsetid = ? AND srcsynsetid = ? AND quality = ?;
LegacySenseMap$X$~$Y$.table=%LegacySenseMap.table.base%$X$$Y$
LegacySenseMap$X$~$Y$.create=CREATE TABLE IF NOT EXISTS %LegacySenseMap$X$~$Y$.table% (wordid INTEGER UNSIGNED NOT NULL,synsetid INTEGER UNSIGNED NOT NULL,srcsynsetid INTEGER UNSIGNED NOT NULL,quality FLOAT NOT NULL,PRIMARY KEY (wordid,synsetid,srcsynsetid,quality)) DEFAULT CHARSET=utf8;
LegacySenseMap$X$~$Y$.pk=ALTER TABLE %LegacySenseMap$X$~$Y$.table% ADD CONSTRAINT pk_%LegacySenseMap$X$~$Y$.table% PRIMARY KEY (wordid,synsetid,srcsynsetid,quality);
LegacySenseMap$X$~$Y$.no-pk=ALTER TABLE %LegacySenseMap$X$~$Y$.table% DROP PRIMARY KEY;
LegacySenseMap$X$~$Y$.index1=ALTER TABLE %LegacySenseMap$X$~$Y$.table% ADD INDEX k_%LegacySenseMap$X$~$Y$.table%_wordid (wordid);
LegacySenseMap$X$~$Y$.no-index1=ALTER TABLE %LegacySenseMap$X$~$Y$.table% DROP INDEX k_%LegacySenseMap$X$~$Y$.table%_wordid;
LegacySenseMap$X$~$Y$.index2=ALTER TABLE %LegacySenseMap$X$~$Y$.table% ADD INDEX k_%LegacySenseMap$X$~$Y$.table%_synsetid (synsetid);
LegacySenseMap$X$~$Y$.no-index2=ALTER TABLE %LegacySenseMap$X$~$Y$.table% DROP INDEX k_%LegacySenseMap$X$~$Y$.table%_synsetid;
LegacySenseMap$X$~$Y$.index3=ALTER TABLE %LegacySenseMap$X$~$Y$.table% ADD INDEX k_%LegacySenseMap$X$~$Y$.table%_srcsynsetid (srcsynsetid);
LegacySenseMap$X$~$Y$.no-index3=ALTER TABLE %LegacySenseMap$X$~$Y$.table% DROP INDEX k_%LegacySenseMap$X$~$Y$.table%_srcsynsetid;
LegacySenseMap$X$~$Y$.fk1=ALTER TABLE %LegacySenseMap$X$~$Y$.table% ADD CONSTRAINT fk_%LegacySenseMap$X$~$Y$.table%_wordid FOREIGN KEY k_%LegacySenseMap$X$~$Y$.table%_wordid (wordid) REFERENCES %Word.table% (wordid);
LegacySenseMap$X$~$Y$.no-fk1=ALTER TABLE %LegacySenseMap$X$~$Y$.table% DROP FOREIGN KEY fk_%LegacySenseMap$X$~$Y$.table%_wordid;
LegacySenseMap$X$~$Y$.fk2=ALTER TABLE %LegacySenseMap$X$~$Y$.table% ADD CONSTRAINT fk_%LegacySenseMap$X$~$Y$.table%_synsetid FOREIGN KEY k_%LegacySenseMap$X$~$Y$.table%_synsetid (synsetid) REFERENCES %Synset.table% (synsetid);
LegacySenseMap$X$~$Y$.no-fk2=ALTER TABLE %LegacySenseMap$X$~$Y$.table% DROP FOREIGN KEY fk_%LegacySenseMap$X$~$Y$.table%_synsetid;
LegacySenseMap$X$~$Y$.insert=INSERT INTO %LegacySenseMap$X$~$Y$.table% (wordid,synsetid,srcsynsetid,quality) VALUES (?,?,?,?);
LegacySenseMap$X$~$Y$.select=SELECT wordid,synsetid,srcsynsetid,quality FROM %LegacySenseMap$X$~$Y$.table% WHERE wordid = ? AND synsetid = ? AND srcsynsetid = ? AND quality = ?;
LegacyComputedSenseMap$X$~$Y$.table=%LegacyComputedSenseMap.table.base%$X$$Y$
LegacyComputedSenseMap$X$~$Y$.create=CREATE TABLE IF NOT EXISTS %LegacyComputedSenseMap$X$~$Y$.table% (wordid INTEGER UNSIGNED NOT NULL,synsetid INTEGER UNSIGNED NOT NULL,srcsynsetid INTEGER UNSIGNED NOT NULL,quality FLOAT NOT NULL,PRIMARY KEY (wordid,synsetid,srcsynsetid,quality)) DEFAULT CHARSET=utf8;
LegacyComputedSenseMap$X$~$Y$.pk=ALTER TABLE %LegacyComputedSenseMap$X$~$Y$.table% ADD CONSTRAINT pk_%LegacyComputedSenseMap$X$~$Y$.table% PRIMARY KEY (wordid,synsetid,srcsynsetid,quality);
LegacyComputedSenseMap$X$~$Y$.no-pk=ALTER TABLE %LegacyComputedSenseMap$X$~$Y$.table% DROP PRIMARY KEY;
LegacyComputedSenseMap$X$~$Y$.index1=ALTER TABLE %LegacyComputedSenseMap$X$~$Y$.table% ADD INDEX k_%LegacyComputedSenseMap$X$~$Y$.table%_wordid (wordid);
LegacyComputedSenseMap$X$~$Y$.no-index1=ALTER TABLE %LegacyComputedSenseMap$X$~$Y$.table% DROP INDEX k_%LegacyComputedSenseMap$X$~$Y$.table%_wordid;
LegacyComputedSenseMap$X$~$Y$.index2=ALTER TABLE %LegacyComputedSenseMap$X$~$Y$.table% ADD INDEX k_%LegacyComputedSenseMap$X$~$Y$.table%_synsetid (synsetid);
LegacyComputedSenseMap$X$~$Y$.no-index2=ALTER TABLE %LegacyComputedSenseMap$X$~$Y$.table% DROP INDEX k_%LegacyComputedSenseMap$X$~$Y$.table%_synsetid;
LegacyComputedSenseMap$X$~$Y$.index3=ALTER TABLE %LegacyComputedSenseMap$X$~$Y$.table% ADD INDEX k_%LegacyComputedSenseMap$X$~$Y$.table%_srcsynsetid (srcsynsetid);
LegacyComputedSenseMap$X$~$Y$.no-index3=ALTER TABLE %LegacyComputedSenseMap$X$~$Y$.table% DROP INDEX k_%LegacyComputedSenseMap$X$~$Y$.table%_srcsynsetid;
LegacyComputedSenseMap$X$~$Y$.fk1=ALTER TABLE %LegacyComputedSenseMap$X$~$Y$.table% ADD CONSTRAINT fk_%LegacyComputedSenseMap$X$~$Y$.table%_wordid FOREIGN KEY k_%LegacyComputedSenseMap$X$~$Y$.table%_wordid (wordid) REFERENCES %Word.table% (wordid);
LegacyComputedSenseMap$X$~$Y$.no-fk1=ALTER TABLE %LegacyComputedSenseMap$X$~$Y$.table% DROP FOREIGN KEY fk_%LegacyComputedSenseMap$X$~$Y$.table%_wordid;
LegacyComputedSenseMap$X$~$Y$.fk2=ALTER TABLE %LegacyComputedSenseMap$X$~$Y$.table% ADD CONSTRAINT fk_%LegacyComputedSenseMap$X$~$Y$.table%_synsetid FOREIGN KEY k_%LegacyComputedSenseMap$X$~$Y$.table%_synsetid (synsetid) REFERENCES %Synset.table% (synsetid);
LegacyComputedSenseMap$X$~$Y$.no-fk2=ALTER TABLE %LegacyComputedSenseMap$X$~$Y$.table% DROP FOREIGN KEY fk_%LegacyComputedSenseMap$X$~$Y$.table%_synsetid;
LegacyComputedSenseMap$X$~$Y$.insert=INSERT INTO %LegacyComputedSenseMap$X$~$Y$.table% (wordid,synsetid,srcsynsetid,quality) VALUES (?,?,?,?);
LegacyComputedSenseMap$X$~$Y$.select=SELECT wordid,synsetid,srcsynsetid,quality FROM %LegacyComputedSenseMap$X$~$Y$.table% WHERE wordid = ? AND synsetid = ? AND srcsynsetid = ? AND quality = ?;
LegacyComputedSenseMap$X$~$Y$.select.all.synsetmaps=SELECT synsetid,srcsynsetid,quality FROM %LegacySynsetMap$X$~$Y$.table% WHERE synsetid <> srcsynsetid;
LegacyComputedSenseMap$X$~$Y$.select.senses=SELECT wordid,%LegacySense.table.base%$X$.synsetid,%LegacySense.table.base%$X$.sensekey,%LegacySense.table.base%$X$.senseid,%LegacySense.table.base%$Y$.synsetid,%LegacySense.table.base%$Y$.sensekey, %LegacySense.table.base%$Y$.senseid FROM %LegacySense.table.base%$X$ INNER JOIN %LegacySense.table.base%$Y$ USING (wordid) WHERE %LegacySense.table.base%$X$.synsetid = ? AND %LegacySense.table.base%$Y$.synsetid = ?;
LegacyXSense$X$.select=SELECT senseid FROM %LegacySense.table.base%$X$ WHERE wordid = ? AND synsetid = ?;
LegacyXSense$X$.max=SELECT MAX(senseid) FROM %LegacySense.table.base%$X$;
LegacyXSense$X$.insert=INSERT INTO %LegacySense.table.base%$X$ (wordid,synsetid,pos,sensenum,senseid,sensekey) VALUES (?,?,?,?,?,?);
legacy0.LegacySenseMap$X$~$Z$.view=%LegacySenseMap.table.base%$X$$Z$
legacy0.LegacySenseMap$X$~$Z$.createview=CREATE OR REPLACE VIEW %legacy0.LegacySenseMap$X$~$Z$.view% AS SELECT m1.wordid,m1.srcsynsetid,m2.synsetid,(m1.quality*m2.quality) AS quality FROM %LegacySenseMap.table.base%$X$~$Y$ m1 INNER JOIN %LegacySenseMap.table.base%$Y$~$Z$ m2 ON m1.wordid = m2.wordid AND m1.synsetid = m2.srcsynsetid;
legacy0.LegacySynsetMap$X$~$Z$.view=%LegacySynsetMap.table.base%$X$$Z$
legacy0.LegacySynsetMap$X$~$Z$.createview=CREATE OR REPLACE VIEW %legacy0.LegacySynsetMap$X$~$Z$.view% AS SELECT m1.srcsynsetid,m2.synsetid,(m1.quality*m2.quality) AS quality FROM %LegacySynsetMap.table.base%$X$~$Y$ m1 INNER JOIN %LegacySynsetMap.table.base%$Y$~$Z$ m2 ON m1.synsetid = m2.srcsynsetid;
legacy0.LegacySynset$X$.view=%LegacySynset.view.base%$X$
legacy0.LegacySynset$X$.createview=CREATE OR REPLACE VIEW %legacy0.LegacySynset$X$.view% AS SELECT DISTINCT srcsynsetid FROM %LegacySenseMap.table.base%$X$~$Y$;
legacy0.Legacy$X$.view=%Legacy.view.base%$X$
legacy0.Legacy$X$.createview=CREATE OR REPLACE VIEW %legacy0.Legacy$X$.view% AS SELECT s.wordid,lemma,m.quality,s.sensekey AS ssensekey,d.sensekey AS dsensekey,m.srcsynsetid AS ssynsetid,m.synsetid AS dsynsetid,d.senseid AS dsenseid,d.sensenum,d.lexid,d.tagcount,definition FROM %Sense.table%$X$ AS s INNER JOIN %LegacySenseMap.table.base%$X$~$Y$ m ON s.wordid = m.wordid AND s.synsetid = m.srcsynsetid INNER JOIN %Sense.table% AS d ON m.wordid = d.wordid AND m.synsetid = d.synsetid LEFT JOIN %Synset.table% AS y ON d.synsetid = y.synsetid LEFT JOIN %Word.table% AS w ON d.wordid = w.wordid;