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

Diff of /dist/bin/sqlite-30-unconstrain.sql [68ae6b] .. [2e23dc] Maximize Restore

  Switch to side-by-side view

--- a/dist/bin/sqlite-30-unconstrain.sql
+++ b/dist/bin/sqlite-30-unconstrain.sql
@@ -1,3 +1,26 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
 DROP INDEX IF EXISTS k_adjpositions_synsetid;
 DROP INDEX IF EXISTS k_adjpositions_wordid;
 DROP INDEX IF EXISTS k_casedwords_wordid;
@@ -29,40 +52,80 @@
 DROP INDEX IF EXISTS unq_senses_senseid;
 DROP INDEX IF EXISTS unq_senses_sensekey;
 DROP INDEX IF EXISTS unq_words_lemma;
-DROP VIEW IF EXISTS samplesets; CREATE VIEW samplesets AS SELECT synsetid,GROUP_CONCAT(DISTINCT samples.sample,'|') AS sampleset FROM samples GROUP BY synsetid;
-DROP VIEW IF EXISTS sensesXsynsets; CREATE VIEW sensesXsynsets AS SELECT * FROM senses INNER JOIN synsets USING (synsetid);
-DROP VIEW IF EXISTS wordsXsenses; CREATE VIEW wordsXsenses AS SELECT * FROM words INNER JOIN senses USING (wordid);
-DROP VIEW IF EXISTS wordsXsensesXsynsets; CREATE VIEW wordsXsensesXsynsets AS SELECT * FROM words INNER JOIN senses USING (wordid) INNER JOIN synsets USING (synsetid);
-DROP VIEW IF EXISTS adjectiveswithpositions; CREATE VIEW adjectiveswithpositions AS SELECT * FROM senses INNER JOIN adjpositions USING (wordid,synsetid) LEFT JOIN words USING (wordid) LEFT JOIN synsets USING (synsetid);
-DROP VIEW IF EXISTS dict; CREATE VIEW dict AS SELECT * FROM words LEFT JOIN senses s USING (wordid) LEFT JOIN casedwords USING (wordid,casedwordid) LEFT JOIN synsets USING (synsetid) LEFT JOIN samplesets USING (synsetid);
-DROP VIEW IF EXISTS morphology; CREATE VIEW morphology AS SELECT * FROM words INNER JOIN morphmaps USING (wordid) INNER JOIN morphs USING (morphid);
-DROP VIEW IF EXISTS sensesXlexlinksXsenses; CREATE VIEW sensesXlexlinksXsenses AS SELECT linkid,s.synsetid AS ssynsetid,s.wordid AS swordid,s.senseid AS ssenseid,s.casedwordid AS scasedwordid,s.sensenum AS ssensenum,s.lexid AS slexid,s.tagcount AS stagcount,s.sensekey AS ssensekey,s.pos AS spos,s.lexdomainid AS slexdomainid,s.definition AS sdefinition,d.synsetid AS dsynsetid,d.wordid AS dwordid,d.senseid AS dsenseid,d.casedwordid AS dcasedwordid,d.sensenum AS dsensenum,d.lexid AS dlexid,d.tagcount AS dtagcount,d.sensekey AS dsensekey,d.pos AS dpos,d.lexdomainid AS dlexdomainid,d.definition AS ddefinition FROM sensesXsynsets AS s INNER JOIN lexlinks AS l ON s.synsetid = l.synset1id AND s.wordid = l.word1id INNER JOIN sensesXsynsets AS d ON l.synset2id = d.synsetid AND l.word2id = d.wordid;
-DROP VIEW IF EXISTS sensesXsemlinksXsenses; CREATE VIEW sensesXsemlinksXsenses AS SELECT linkid,s.synsetid AS ssynsetid,s.wordid AS swordid,s.senseid AS ssenseid,s.casedwordid AS scasedwordid,s.sensenum AS ssensenum,s.lexid AS slexid,s.tagcount AS stagcount,s.sensekey AS ssensekey,s.pos AS spos,s.lexdomainid AS slexdomainid,s.definition AS sdefinition,d.synsetid AS dsynsetid,d.wordid AS dwordid,d.senseid AS dsenseid,d.casedwordid AS dcasedwordid,d.sensenum AS dsensenum,d.lexid AS dlexid,d.tagcount AS dtagcount,d.sensekey AS dsensekey,d.pos AS dpos,d.lexdomainid AS dlexdomainid,d.definition AS ddefinition FROM sensesXsynsets AS s INNER JOIN semlinks AS l ON s.synsetid = l.synset1id INNER JOIN sensesXsynsets AS d ON l.synset2id = d.synsetid;
-DROP VIEW IF EXISTS synsetsXsemlinksXsynsets; CREATE VIEW synsetsXsemlinksXsynsets AS SELECT linkid,s.synsetid AS ssynsetid,s.definition AS sdefinition,d.synsetid AS dsynsetid,d.definition AS ddefinition FROM synsets AS s INNER JOIN semlinks AS l ON s.synsetid = l.synset1id INNER JOIN synsets AS d ON l.synset2id = d.synsetid;
-DROP VIEW IF EXISTS verbswithframes; CREATE VIEW verbswithframes AS SELECT * FROM senses INNER JOIN vframemaps USING (wordid,synsetid) INNER JOIN vframes USING (frameid) LEFT JOIN words USING (wordid) LEFT JOIN synsets USING (synsetid);
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
 DROP INDEX IF EXISTS k_senses20_synsetid;
 DROP INDEX IF EXISTS k_senses20_wordid;
 DROP INDEX IF EXISTS k_senses21_synsetid;
 DROP INDEX IF EXISTS k_senses21_wordid;
-DROP INDEX IF EXISTS k_sensemaps2021_synset2id;
+DROP INDEX IF EXISTS k_sensemaps2021_srcsynsetid;
 DROP INDEX IF EXISTS k_sensemaps2021_synsetid;
 DROP INDEX IF EXISTS k_sensemaps2021_wordid;
-DROP INDEX IF EXISTS k_sensemaps2130_synset2id;
+DROP INDEX IF EXISTS k_sensemaps2130_srcsynsetid;
 DROP INDEX IF EXISTS k_sensemaps2130_synsetid;
 DROP INDEX IF EXISTS k_sensemaps2130_wordid;
-DROP INDEX IF EXISTS k_synsetmaps2030_synset2id;
+DROP INDEX IF EXISTS k_synsetmaps2030_srcsynsetid;
 DROP INDEX IF EXISTS k_synsetmaps2030_synsetid;
-DROP INDEX IF EXISTS k_synsetmaps2130_synset2id;
+DROP INDEX IF EXISTS k_synsetmaps2130_srcsynsetid;
 DROP INDEX IF EXISTS k_synsetmaps2130_synsetid;
 DROP INDEX IF EXISTS unq_senses20_senseid;
 DROP INDEX IF EXISTS unq_senses20_sensekey;
 DROP INDEX IF EXISTS unq_senses21_senseid;
 DROP INDEX IF EXISTS unq_senses21_sensekey;
-DROP VIEW IF EXISTS legacy20; CREATE VIEW legacy20 AS SELECT s.wordid,lemma,m.quality,s.sensekey AS ssensekey,d.sensekey AS dsensekey,m.synset2id AS ssynsetid,m.synsetid AS dsynsetid,d.senseid AS dsenseid,d.sensenum,d.lexid,d.tagcount,definition FROM senses20 AS s INNER JOIN sensemaps2021 m ON s.wordid = m.wordid AND s.synsetid = m.synset2id INNER JOIN senses AS d ON m.wordid = d.wordid AND m.synsetid = d.synsetid LEFT JOIN synsets AS y ON d.synsetid = y.synsetid LEFT JOIN words AS w ON d.wordid = w.wordid;
-DROP VIEW IF EXISTS legacy21; CREATE VIEW legacy21 AS SELECT s.wordid,lemma,m.quality,s.sensekey AS ssensekey,d.sensekey AS dsensekey,m.synset2id AS ssynsetid,m.synsetid AS dsynsetid,d.senseid AS dsenseid,d.sensenum,d.lexid,d.tagcount,definition FROM senses21 AS s INNER JOIN sensemaps2130 m ON s.wordid = m.wordid AND s.synsetid = m.synset2id INNER JOIN senses AS d ON m.wordid = d.wordid AND m.synsetid = d.synsetid LEFT JOIN synsets AS y ON d.synsetid = y.synsetid LEFT JOIN words AS w ON d.wordid = w.wordid;
-DROP VIEW IF EXISTS sensemaps2030; CREATE VIEW sensemaps2030 AS SELECT m1.wordid,m1.synset2id,m2.synsetid, (m1.quality*m2.quality)/100 AS quality FROM sensemaps2021 m1 INNER JOIN sensemaps2130 m2 ON m1.wordid = m2.wordid AND m1.synsetid = m2.synset2id;
-DROP VIEW IF EXISTS synsets20; CREATE VIEW synsets20 AS SELECT DISTINCT synset2id FROM sensemaps2021;
-DROP VIEW IF EXISTS synsets21; CREATE VIEW synsets21 AS SELECT DISTINCT synset2id FROM sensemaps2130;
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
 DROP INDEX IF EXISTS k_vnclassmembers_classid;
 DROP INDEX IF EXISTS k_vnclassmembers_wordid;
 DROP INDEX IF EXISTS k_vnclassmembersenses_classid;
@@ -104,13 +167,44 @@
 DROP INDEX IF EXISTS unq_vnselrestrs_selrestrs;
 DROP INDEX IF EXISTS unq_vnsemantics_semantics;
 DROP INDEX IF EXISTS unq_vnsyntaxes_syntax;
-DROP VIEW IF EXISTS verbnetframes; CREATE VIEW verbnetframes AS SELECT * FROM senses INNER JOIN vnframemaps USING (wordid,synsetid) INNER JOIN vnframes USING (frameid) INNER JOIN vnsyntaxes USING (syntaxid) INNER JOIN vnsemantics USING (semanticsid) INNER JOIN vnframenames USING (nameid) LEFT JOIN vnframesubnames USING (subnameid) LEFT JOIN vnexamplemaps USING (frameid) LEFT JOIN vnexamples USING (exampleid) INNER JOIN vnclasses USING (classid) LEFT JOIN words USING (wordid) LEFT JOIN synsets USING (synsetid);
-DROP VIEW IF EXISTS verbnetroles; CREATE VIEW verbnetroles AS SELECT * FROM senses INNER JOIN vnrolemaps USING (wordid,synsetid) INNER JOIN vnroles USING (roleid) INNER JOIN vnroletypes USING (roletypeid) LEFT JOIN vnselrestrs USING (selrestrsid) INNER JOIN vnclasses USING (classid) LEFT JOIN words USING (wordid) LEFT JOIN synsets USING (synsetid);
-DROP VIEW IF EXISTS verbnetrolesframes; CREATE VIEW verbnetrolesframes AS SELECT * FROM vnrolemaps INNER JOIN vnframemaps USING (wordid,synsetid,classid) INNER JOIN vnroles USING (roleid) INNER JOIN vnroletypes USING (roletypeid) LEFT JOIN vnselrestrs USING (selrestrsid) INNER JOIN vnframes USING (frameid) INNER JOIN vnsyntaxes USING (syntaxid) INNER JOIN vnsemantics USING (semanticsid) INNER JOIN vnframenames USING (nameid) LEFT JOIN vnframesubnames USING (subnameid) LEFT JOIN vnexamplemaps USING (frameid) LEFT JOIN vnexamples USING (exampleid) INNER JOIN vnclasses USING (classid) LEFT JOIN senses USING (wordid,synsetid) LEFT JOIN words USING (wordid) LEFT JOIN synsets USING (synsetid);
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
 DROP INDEX IF EXISTS k_bncs_wordid;
 DROP INDEX IF EXISTS k_bncconvtasks_wordid;
 DROP INDEX IF EXISTS k_bncimaginfs_wordid;
 DROP INDEX IF EXISTS k_bncspwrs_wordid;
+
+
+
+
+
+
+
+
+
+
 DROP INDEX IF EXISTS k_sumoformulas_formula;
 DROP INDEX IF EXISTS k_sumomaps_sumoid;
 DROP INDEX IF EXISTS k_sumomaps_sumownrel;
@@ -119,29 +213,25 @@
 DROP INDEX IF EXISTS k_sumoparsemaps_sumoparsetype;
 DROP INDEX IF EXISTS unq_sumofiles_sumofile;
 DROP INDEX IF EXISTS unq_sumoterms_sumoterm;
-DROP VIEW IF EXISTS sumoarg0maps; CREATE VIEW sumoarg0maps AS SELECT mapid,sumoid,formulaid FROM sumoparsemaps WHERE sumoparsetype = 'a' AND argnum = 0;
-DROP VIEW IF EXISTS sumoarg1maps; CREATE VIEW sumoarg1maps AS SELECT mapid,sumoid,formulaid FROM sumoparsemaps WHERE sumoparsetype = 'a' AND argnum = 1;
-DROP VIEW IF EXISTS sumoarg2maps; CREATE VIEW sumoarg2maps AS SELECT mapid,sumoid,formulaid FROM sumoparsemaps WHERE sumoparsetype = 'a' AND argnum = 2;
-DROP VIEW IF EXISTS sumoarg3maps; CREATE VIEW sumoarg3maps AS SELECT mapid,sumoid,formulaid FROM sumoparsemaps WHERE sumoparsetype = 'a' AND argnum = 3;
-DROP VIEW IF EXISTS sumodisjointformulas; CREATE VIEW sumodisjointformulas AS SELECT formulaid FROM sumoarg0maps WHERE sumoid = 4;
-DROP VIEW IF EXISTS sumodomainformulas; CREATE VIEW sumodomainformulas AS SELECT formulaid FROM sumoarg0maps WHERE sumoid = 5;
-DROP VIEW IF EXISTS sumoinstanceformulas; CREATE VIEW sumoinstanceformulas AS SELECT formulaid FROM sumoarg0maps WHERE sumoid = 3;
-DROP VIEW IF EXISTS sumopartitionformulas; CREATE VIEW sumopartitionformulas AS SELECT formulaid FROM sumoarg0maps WHERE sumoid = 6;
-DROP VIEW IF EXISTS sumorules; CREATE VIEW sumorules AS SELECT formulaid,formula,sumofileid FROM sumoformulas INNER JOIN sumoparsemaps USING (formulaid) WHERE argnum = 0 AND (sumoid = 13 OR sumoid = 14);
-DROP VIEW IF EXISTS sumosubclassformulas; CREATE VIEW sumosubclassformulas AS SELECT formulaid FROM sumoarg0maps WHERE sumoid = 1;
-DROP VIEW IF EXISTS sumosubrelationformulas; CREATE VIEW sumosubrelationformulas AS SELECT formulaid FROM sumoarg0maps WHERE sumoid = 2;
-DROP VIEW IF EXISTS sumodisjoints; CREATE VIEW sumodisjoints AS SELECT a1.sumoid AS sumodisjoint1id, a2.sumoid AS sumodisjoint2id,formulaid FROM sumodisjointformulas AS a0 INNER JOIN sumoarg1maps AS a1 USING (formulaid) INNER JOIN sumoarg2maps AS a2 USING (formulaid);
-DROP VIEW IF EXISTS sumoinstances; CREATE VIEW sumoinstances AS SELECT a1.sumoid AS sumoinstanceid, a2.sumoid AS sumoclassid,formulaid FROM sumoinstanceformulas AS a0 INNER JOIN sumoarg1maps AS a1 USING (formulaid) INNER JOIN sumoarg2maps AS a2 USING (formulaid);
-DROP VIEW IF EXISTS sumorelations; CREATE VIEW sumorelations AS SELECT sumoid FROM sumoarg0maps INNER JOIN sumoterms USING (sumoid) GROUP BY sumoid;
-DROP VIEW IF EXISTS sumosubclasses; CREATE VIEW sumosubclasses AS SELECT a1.sumoid AS sumoclassid, a2.sumoid AS sumosuperclassid,formulaid FROM sumosubclassformulas AS a0 INNER JOIN sumoarg1maps AS a1 USING (formulaid) INNER JOIN sumoarg2maps AS a2 USING (formulaid);
-DROP VIEW IF EXISTS sumosubrelations; CREATE VIEW sumosubrelations AS SELECT a1.sumoid AS sumorelationid, a2.sumoid AS sumosuperrelationid,formulaid FROM sumosubrelationformulas AS a0 INNER JOIN sumoarg1maps AS a1 USING (formulaid) INNER JOIN sumoarg2maps AS a2 USING (formulaid);
+
+
+
+
+
+
+
+
 DROP INDEX IF EXISTS k_xwnparselfts_synsetid;
 DROP INDEX IF EXISTS k_xwnwsds_synsetid;
 DROP INDEX IF EXISTS unq_xwnparselfts_synsetid_parse_lft;
 DROP INDEX IF EXISTS unq_xwnwsds_synsetid_wsd_text;
+
+
 DROP INDEX IF EXISTS k_glfs_synsetid;
 DROP INDEX IF EXISTS k_glfs_wordid;
 DROP INDEX IF EXISTS unq_glfs_wordid_synsetid_lf_issub;
+
+
 DROP INDEX IF EXISTS k_ilfs_synsetid;
 DROP INDEX IF EXISTS k_ilfs_wordid;
 DROP INDEX IF EXISTS unq_ilfs_wordid_synsetid_lf_prettylf;