Diff of /legacy/src/main/resources/org/wnsql/builder/legacy/mysql.properties [6ff7b6] .. [68ae6b] Maximize Restore

  Switch to side-by-side view

--- a/legacy/src/main/resources/org/wnsql/builder/legacy/mysql.properties
+++ b/legacy/src/main/resources/org/wnsql/builder/legacy/mysql.properties
@@ -22,65 +22,64 @@
 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 = ?;
+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 = ?;
+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 = ?;
+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.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.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;
-
+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;