[6ff7b6]: sumo / src / main / resources / org / wnsql / builder / sumo / test.properties Maximize Restore History

Download this file

test.properties    169 lines (155 with data), 17.8 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
 86
 87
 88
 89
 90
 91
 92
 93
 94
 95
 96
 97
 98
 99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
SUMOTerm.table=sumoterms
SUMOTerm.create=CREATE TABLE IF NOT EXISTS %SUMOTerm.table% (sumoid INTEGER NOT NULL DEFAULT '0',sumoterm VARCHAR (128) NOT NULL,CONSTRAINT pk_%SUMOTerm.table% PRIMARY KEY (sumoid));
SUMOTerm.pk=
SUMOTerm.no-pk=
SUMOTerm.unq=CREATE UNIQUE INDEX IF NOT EXISTS unq_%SUMOTerm.table%_sumoterm ON %SUMOTerm.table% (sumoterm);
SUMOTerm.no-unq=DROP INDEX IF EXISTS unq_%SUMOTerm.table%_sumoterm;
SUMOTerm.insert=INSERT INTO %SUMOTerm.table% (sumoid,sumoterm) VALUES (?,?);
SUMOTermAttr.table=sumotermattrs
SUMOTermAttr.create=CREATE TABLE IF NOT EXISTS %SUMOTermAttr.table% (sumoid INTEGER NOT NULL DEFAULT '0',sumoattr VARCHAR (1) NOT NULL,CONSTRAINT pk_%SUMOTermAttr.table% PRIMARY KEY (sumoid,sumoattr));
SUMOTermAttr.pk=
SUMOTermAttr.no-pk=
SUMOTermAttr.fk1=
SUMOTermAttr.no-fk1=
SUMOTermAttr.insert=INSERT INTO %SUMOTermAttr.table% (sumoid,sumoattr) VALUES (?,?);
SUMOFile.table=sumofiles
SUMOFile.create=CREATE TABLE IF NOT EXISTS %SUMOFile.table% (sumofileid INTEGER NOT NULL DEFAULT '0',sumofile VARCHAR (128) NOT NULL,sumoversion VARCHAR (5) DEFAULT NULL,sumodate INTEGER DEFAULT NULL,CONSTRAINT pk_%SUMOFile.table% PRIMARY KEY (sumofileid));
SUMOFile.pk=
SUMOFile.no-pk=
SUMOFile.unq=CREATE UNIQUE INDEX IF NOT EXISTS unq_%SUMOFile.table%_sumofile ON %SUMOFile.table% (sumofile);
SUMOFile.no-unq=DROP INDEX IF EXISTS unq_%SUMOFile.table%_sumofile;
SUMOFile.insert=INSERT INTO %SUMOFile.table% (sumofileid,sumofile,sumoversion,sumodate) VALUES (?,?,?,?);
SUMOFormula.table=sumoformulas
SUMOFormula.create=CREATE TABLE IF NOT EXISTS %SUMOFormula.table% (formulaid INTEGER NOT NULL DEFAULT '0',formula TEXT NOT NULL,sumofileid INTEGER NOT NULL DEFAULT '0',CONSTRAINT pk_%SUMOFormula.table% PRIMARY KEY (formulaid));
SUMOFormula.pk=
SUMOFormula.no-pk=
SUMOFormula.index=CREATE INDEX IF NOT EXISTS k_%SUMOFormula.table%_formula ON %SUMOFormula.table% (formula);
SUMOFormula.no-index=DROP INDEX IF EXISTS k_%SUMOFormula.table%_formula;
SUMOFormula.fk1=
SUMOFormula.no-fk1=
SUMOFormula.insert=INSERT INTO %SUMOFormula.table% (formulaid,formula,sumofileid) VALUES (?,?,?);
SUMOMap.table=sumomaps
SUMOMap.create=CREATE TABLE IF NOT EXISTS %SUMOMap.table% (synsetid INTEGER NOT NULL DEFAULT '0',sumoid INTEGER NOT NULL DEFAULT '0',sumownrel CHARACTER (1) NOT NULL,CONSTRAINT pk_%SUMOMap.table% PRIMARY KEY (synsetid));
SUMOMap.pk=
SUMOMap.no-pk=
SUMOMap.index1=CREATE INDEX IF NOT EXISTS k_%SUMOMap.table%_sumoid ON %SUMOMap.table% (sumoid);
SUMOMap.no-index1=DROP INDEX IF EXISTS k_%SUMOMap.table%_sumoid;
SUMOMap.index2=CREATE INDEX IF NOT EXISTS k_%SUMOMap.table%_sumownrel ON %SUMOMap.table% (sumownrel);
SUMOMap.no-index2=DROP INDEX IF EXISTS k_%SUMOMap.table%_sumownrel;
SUMOMap.fk1=
SUMOMap.no-fk1=
SUMOMap.fk2=
SUMOMap.no-fk2=
SUMOMap.insert=INSERT INTO %SUMOMap.table% (synsetid,sumoid,sumownrel) VALUES (?,?,?);
SUMOParseMap.table=sumoparsemaps
SUMOParseMap.create=CREATE TABLE IF NOT EXISTS %SUMOParseMap.table% (mapid INTEGER NOT NULL DEFAULT '0',formulaid INTEGER NOT NULL DEFAULT '0',sumoid INTEGER NOT NULL DEFAULT '0',sumoparsetype CHARACTER (1) NOT NULL,argnum SMALLINT NULL DEFAULT NULL,CONSTRAINT pk_%SUMOParseMap.table% PRIMARY KEY (mapid));
SUMOParseMap.pk=
SUMOParseMap.no-pk=
SUMOParseMap.index1=CREATE INDEX IF NOT EXISTS k_%SUMOParseMap.table%_formulaid ON %SUMOParseMap.table% (formulaid);
SUMOParseMap.no-index1=DROP INDEX IF EXISTS k_%SUMOParseMap.table%_formulaid;
SUMOParseMap.index2=CREATE INDEX IF NOT EXISTS k_%SUMOParseMap.table%_sumoid ON %SUMOParseMap.table% (sumoid);
SUMOParseMap.no-index2=DROP INDEX IF EXISTS k_%SUMOParseMap.table%_sumoid;
SUMOParseMap.index3=CREATE INDEX IF NOT EXISTS k_%SUMOParseMap.table%_sumoparsetype ON %SUMOParseMap.table% (sumoparsetype);
SUMOParseMap.no-index3=DROP INDEX IF EXISTS k_%SUMOParseMap.table%_sumoparsetype;
SUMOParseMap.fk1=
SUMOParseMap.no-fk1=
SUMOParseMap.fk2=
SUMOParseMap.no-fk2=
SUMOParseMap.insert=INSERT INTO %SUMOParseMap.table% (mapid,formulaid,sumoid,sumoparsetype,argnum) VALUES (?,?,?,?,?);
SUMOTermAttr.superclass.extend=INSERT INTO %SUMOTermAttr.table% (sumoid,sumoattr) SELECT s.sumoid,s.sumoattr FROM (SELECT DISTINCT sumosuperclassid AS sumoid,'C' AS sumoattr FROM %sumo1.SUMOSubclasses.view%) AS s LEFT OUTER JOIN %SUMOTermAttr.table% AS a ON s.sumoid=a.sumoid AND s.sumoattr=a.sumoattr WHERE a.sumoid IS NULL AND a.sumoattr IS NULL;
SUMOTermAttr.subclass.extend=INSERT INTO %SUMOTermAttr.table% (sumoid,sumoattr) SELECT s.sumoid,s.sumoattr FROM (SELECT DISTINCT sumoclassid AS sumoid,'c' AS sumoattr FROM %sumo1.SUMOSubclasses.view%) AS s LEFT OUTER JOIN %SUMOTermAttr.table% AS a ON s.sumoid=a.sumoid AND s.sumoattr=a.sumoattr WHERE a.sumoid IS NULL AND a.sumoattr IS NULL;
SUMOTermAttr.class.extend=INSERT INTO %SUMOTermAttr.table% (sumoid,sumoattr) SELECT s.sumoid,s.sumoattr FROM (SELECT DISTINCT sumoclassid AS sumoid,'c' AS sumoattr FROM %sumo1.SUMOInstances.view%) AS s LEFT OUTER JOIN %SUMOTermAttr.table% AS a ON s.sumoid=a.sumoid AND s.sumoattr=a.sumoattr WHERE a.sumoid IS NULL AND a.sumoattr IS NULL;
SUMOTermAttr.instance.extend=INSERT INTO %SUMOTermAttr.table% (sumoid,sumoattr) SELECT s.sumoid,s.sumoattr FROM (SELECT DISTINCT sumoinstanceid AS sumoid,'i' AS sumoattr FROM %sumo1.SUMOInstances.view%) AS s LEFT OUTER JOIN %SUMOTermAttr.table% AS a ON s.sumoid=a.sumoid AND s.sumoattr=a.sumoattr WHERE a.sumoid IS NULL AND a.sumoattr IS NULL;
SUMOTermAttr.superrelation.extend=INSERT INTO %SUMOTermAttr.table% (sumoid,sumoattr) SELECT s.sumoid,s.sumoattr FROM (SELECT DISTINCT sumosuperrelationid AS sumoid,'S' AS sumoattr FROM %sumo1.SUMOSubrelations.view%) AS s LEFT OUTER JOIN %SUMOTermAttr.table% AS a ON s.sumoid=a.sumoid AND s.sumoattr=a.sumoattr WHERE a.sumoid IS NULL AND a.sumoattr IS NULL;
SUMOTermAttr.subrelation.extend=INSERT INTO %SUMOTermAttr.table% (sumoid,sumoattr) SELECT s.sumoid,s.sumoattr FROM (SELECT DISTINCT sumorelationid AS sumoid,'s' AS sumoattr FROM %sumo1.SUMOSubrelations.view%) AS s LEFT OUTER JOIN %SUMOTermAttr.table% AS a ON s.sumoid=a.sumoid AND s.sumoattr=a.sumoattr WHERE a.sumoid IS NULL AND a.sumoattr IS NULL;
SUMOTermAttr.relationop.extend=INSERT INTO %SUMOTermAttr.table% (sumoid,sumoattr) SELECT s.sumoid,s.sumoattr FROM (SELECT DISTINCT sumoid,'@' AS sumoattr FROM %SUMOParseMap.table% WHERE sumoparsetype = 'a' AND argnum = 0) AS s LEFT OUTER JOIN %SUMOTermAttr.table% AS a ON s.sumoid=a.sumoid AND s.sumoattr=a.sumoattr WHERE a.sumoid IS NULL AND a.sumoattr IS NULL;
SUMOTermAttr.all.no-extend=DELETE FROM %SUMOTermAttr.table% WHERE sumoattr IN ('c','C','i','s','S','@');
SUMOTerm.instance.flatten0=ALTER TABLE %SUMOTerm.table% ADD COLUMN isinstance BOOLEAN;
SUMOTerm.subclass.flatten0=ALTER TABLE %SUMOTerm.table% ADD COLUMN issubclass BOOLEAN;
SUMOTerm.superclass.flatten0=ALTER TABLE %SUMOTerm.table% ADD COLUMN issuperclass BOOLEAN;
SUMOTerm.subrelation.flatten0=ALTER TABLE %SUMOTerm.table% ADD COLUMN issubrelation BOOLEAN;
SUMOTerm.superrelation.flatten0=ALTER TABLE %SUMOTerm.table% ADD COLUMN issuperrelation BOOLEAN;
SUMOTerm.relationop.flatten0=ALTER TABLE %SUMOTerm.table% ADD COLUMN isrelationop BOOLEAN;
SUMOTerm.function.flatten0=ALTER TABLE %SUMOTerm.table% ADD COLUMN isfunction BOOLEAN;
SUMOTerm.math.flatten0=ALTER TABLE %SUMOTerm.table% ADD COLUMN ismath BOOLEAN;
SUMOTerm.logical.flatten0=ALTER TABLE %SUMOTerm.table% ADD COLUMN islogical BOOLEAN;
SUMOTerm.comparisonop.flatten0=ALTER TABLE %SUMOTerm.table% ADD COLUMN iscomparisonop BOOLEAN;
SUMOTerm.quantifier.flatten0=ALTER TABLE %SUMOTerm.table% ADD COLUMN isquantifier BOOLEAN;
SUMOTerm.subclassofRelation.flatten0=ALTER TABLE %SUMOTerm.table% ADD COLUMN issubclassofRelation BOOLEAN;
SUMOTerm.subclassofPredicate.flatten0=ALTER TABLE %SUMOTerm.table% ADD COLUMN issubclassofPredicate BOOLEAN;
SUMOTerm.subclassofFunction.flatten0=ALTER TABLE %SUMOTerm.table% ADD COLUMN issubclassofFunction BOOLEAN;
SUMOTerm.subclassofAttribute.flatten0=ALTER TABLE %SUMOTerm.table% ADD COLUMN issubclassofAttribute BOOLEAN;
SUMOTerm.childofRelation.flatten0=ALTER TABLE %SUMOTerm.table% ADD COLUMN ischildofRelation BOOLEAN;
SUMOTerm.childofPredicate.flatten0=ALTER TABLE %SUMOTerm.table% ADD COLUMN ischildofPredicate BOOLEAN;
SUMOTerm.childofFunction.flatten0=ALTER TABLE %SUMOTerm.table% ADD COLUMN ischildofFunction BOOLEAN;
SUMOTerm.childofAttribute.flatten0=ALTER TABLE %SUMOTerm.table% ADD COLUMN ischildofAttribute BOOLEAN;
SUMOTerm.instance.no-flatten=ALTER TABLE %SUMOTerm.table% DROP COLUMN isinstance;
SUMOTerm.subclass.no-flatten=ALTER TABLE %SUMOTerm.table% DROP COLUMN issubclass;
SUMOTerm.superclass.no-flatten=ALTER TABLE %SUMOTerm.table% DROP COLUMN issuperclass;
SUMOTerm.subrelation.no-flatten=ALTER TABLE %SUMOTerm.table% DROP COLUMN issubrelation;
SUMOTerm.superrelation.no-flatten=ALTER TABLE %SUMOTerm.table% DROP COLUMN issuperrelation;
SUMOTerm.relationop.no-flatten=ALTER TABLE %SUMOTerm.table% DROP COLUMN isrelationop;
SUMOTerm.function.no-flatten=ALTER TABLE %SUMOTerm.table% DROP COLUMN isfunction;
SUMOTerm.math.no-flatten=ALTER TABLE %SUMOTerm.table% DROP COLUMN ismath;
SUMOTerm.logical.no-flatten=ALTER TABLE %SUMOTerm.table% DROP COLUMN islogical;
SUMOTerm.comparisonop.no-flatten=ALTER TABLE %SUMOTerm.table% DROP COLUMN iscomparisonop;
SUMOTerm.quantifier.no-flatten=ALTER TABLE %SUMOTerm.table% DROP COLUMN isquantifier;
SUMOTerm.subclassofRelation.no-flatten=ALTER TABLE %SUMOTerm.table% DROP COLUMN issubclassofRelation;
SUMOTerm.subclassofPredicate.no-flatten=ALTER TABLE %SUMOTerm.table% DROP COLUMN issubclassofPredicate;
SUMOTerm.subclassofFunction.no-flatten=ALTER TABLE %SUMOTerm.table% DROP COLUMN issubclassofFunction;
SUMOTerm.subclassofAttribute.no-flatten=ALTER TABLE %SUMOTerm.table% DROP COLUMN issubclassofAttribute;
SUMOTerm.childofRelation.no-flatten=ALTER TABLE %SUMOTerm.table% DROP COLUMN ischildofRelation;
SUMOTerm.childofPredicate.no-flatten=ALTER TABLE %SUMOTerm.table% DROP COLUMN ischildofPredicate;
SUMOTerm.childofFunction.no-flatten=ALTER TABLE %SUMOTerm.table% DROP COLUMN ischildofFunction;
SUMOTerm.childofAttribute.no-flatten=ALTER TABLE %SUMOTerm.table% DROP COLUMN ischildofAttribute;
SUMOTerm.instance.flatten1=UPDATE %SUMOTerm.table% SET isinstance = TRUE WHERE sumoid IN (SELECT sumoid FROM %SUMOTermAttr.table% WHERE sumoattr = 'i');
SUMOTerm.subclass.flatten1=UPDATE %SUMOTerm.table% SET issubclass = TRUE WHERE sumoid IN (SELECT sumoid FROM %SUMOTermAttr.table% WHERE sumoattr = 'c');
SUMOTerm.superclass.flatten1=UPDATE %SUMOTerm.table% SET issuperclass = TRUE WHERE sumoid IN (SELECT sumoid FROM %SUMOTermAttr.table% WHERE sumoattr = 'C');
SUMOTerm.subrelation.flatten1=UPDATE %SUMOTerm.table% SET issubrelation = TRUE WHERE sumoid IN (SELECT sumoid FROM %SUMOTermAttr.table% WHERE sumoattr = 's');
SUMOTerm.superrelation.flatten1=UPDATE %SUMOTerm.table% SET issuperrelation = TRUE WHERE sumoid IN (SELECT sumoid FROM %SUMOTermAttr.table% WHERE sumoattr = 'S');
SUMOTerm.relationop.flatten1=UPDATE %SUMOTerm.table% SET isrelationop = TRUE WHERE sumoid IN (SELECT sumoid FROM %SUMOTermAttr.table% WHERE sumoattr = '@');
SUMOTerm.function.flatten1=UPDATE %SUMOTerm.table% SET isfunction = TRUE WHERE sumoid IN (SELECT sumoid FROM %SUMOTermAttr.table% WHERE sumoattr = 'y');
SUMOTerm.math.flatten1=UPDATE %SUMOTerm.table% SET ismath = TRUE WHERE sumoid IN (SELECT sumoid FROM %SUMOTermAttr.table% WHERE sumoattr = 'm');
SUMOTerm.logical.flatten1=UPDATE %SUMOTerm.table% SET islogical = TRUE WHERE sumoid IN (SELECT sumoid FROM %SUMOTermAttr.table% WHERE sumoattr = 'l');
SUMOTerm.comparisonop.flatten1=UPDATE %SUMOTerm.table% SET iscomparisonop = TRUE WHERE sumoid IN (SELECT sumoid FROM %SUMOTermAttr.table% WHERE sumoattr = '~');
SUMOTerm.quantifier.flatten1=UPDATE %SUMOTerm.table% SET isquantifier = TRUE WHERE sumoid IN (SELECT sumoid FROM %SUMOTermAttr.table% WHERE sumoattr = 'q');
SUMOTerm.subclassofRelation.flatten1=UPDATE %SUMOTerm.table% SET issubclassofRelation = TRUE WHERE sumoid IN (SELECT sumoid FROM %SUMOTermAttr.table% WHERE sumoattr = 'R');
SUMOTerm.subclassofPredicate.flatten1=UPDATE %SUMOTerm.table% SET issubclassofPredicate = TRUE WHERE sumoid IN (SELECT sumoid FROM %SUMOTermAttr.table% WHERE sumoattr = 'P');
SUMOTerm.subclassofFunction.flatten1=UPDATE %SUMOTerm.table% SET issubclassofFunction = TRUE WHERE sumoid IN (SELECT sumoid FROM %SUMOTermAttr.table% WHERE sumoattr = 'F');
SUMOTerm.subclassofAttribute.flatten1=UPDATE %SUMOTerm.table% SET issubclassofAttribute = TRUE WHERE sumoid IN (SELECT sumoid FROM %SUMOTermAttr.table% WHERE sumoattr = 'A');
SUMOTerm.childofRelation.flatten1=UPDATE %SUMOTerm.table% SET ischildofRelation = TRUE WHERE sumoid IN (SELECT sumoid FROM %SUMOTermAttr.table% WHERE sumoattr = 'r');
SUMOTerm.childofPredicate.flatten1=UPDATE %SUMOTerm.table% SET ischildofPredicate = TRUE WHERE sumoid IN (SELECT sumoid FROM %SUMOTermAttr.table% WHERE sumoattr = 'p');
SUMOTerm.childofFunction.flatten1=UPDATE %SUMOTerm.table% SET ischildofFunction = TRUE WHERE sumoid IN (SELECT sumoid FROM %SUMOTermAttr.table% WHERE sumoattr = 'f');
SUMOTerm.childofAttribute.flatten1=UPDATE %SUMOTerm.table% SET ischildofAttribute = TRUE WHERE sumoid IN (SELECT sumoid FROM %SUMOTermAttr.table% WHERE sumoattr = 'a');
sumo0.SUMOArg0Map.view=sumoarg0maps
sumo0.SUMOArg0Map.createview=DROP VIEW IF EXISTS sumoarg0maps; CREATE VIEW sumoarg0maps AS SELECT mapid,sumoid,formulaid FROM %SUMOParseMap.table% WHERE sumoparsetype = 'a' AND argnum = 0;
sumo0.SUMOArg1Map.view=sumoarg1maps
sumo0.SUMOArg1Map.createview=DROP VIEW IF EXISTS sumoarg1maps; CREATE VIEW sumoarg1maps AS SELECT mapid,sumoid,formulaid FROM %SUMOParseMap.table% WHERE sumoparsetype = 'a' AND argnum = 1;
sumo0.SUMOArg2Map.view=sumoarg2maps
sumo0.SUMOArg2Map.createview=DROP VIEW IF EXISTS sumoarg2maps; CREATE VIEW sumoarg2maps AS SELECT mapid,sumoid,formulaid FROM %SUMOParseMap.table% WHERE sumoparsetype = 'a' AND argnum = 2;
sumo0.SUMOArg3Map.view=sumoarg3maps
sumo0.SUMOArg3Map.createview=DROP VIEW IF EXISTS sumoarg3maps; CREATE VIEW sumoarg3maps AS SELECT mapid,sumoid,formulaid FROM %SUMOParseMap.table% WHERE sumoparsetype = 'a' AND argnum = 3;
sumo0.SUMOSubclassFormulas.view=sumosubclassformulas
sumo0.SUMOSubclassFormulas.createview=DROP VIEW IF EXISTS %sumo0.SUMOSubclassFormulas.view%; CREATE VIEW %sumo0.SUMOSubclassFormulas.view% AS SELECT formulaid FROM %sumo0.SUMOArg0Map.view% WHERE sumoid = 1;
sumo0.SUMOSubrelationFormulas.view=sumosubrelationformulas
sumo0.SUMOSubrelationFormulas.createview=DROP VIEW IF EXISTS %sumo0.SUMOSubrelationFormulas.view%; CREATE VIEW %sumo0.SUMOSubrelationFormulas.view% AS SELECT formulaid FROM %sumo0.SUMOArg0Map.view% WHERE sumoid = 2;
sumo0.SUMOInstanceFormulas.view=sumoinstanceformulas
sumo0.SUMOInstanceFormulas.createview=DROP VIEW IF EXISTS %sumo0.SUMOInstanceFormulas.view%; CREATE VIEW %sumo0.SUMOInstanceFormulas.view% AS SELECT formulaid FROM %sumo0.SUMOArg0Map.view% WHERE sumoid = 3;
sumo0.SUMODisjointFormulas.view=sumodisjointformulas
sumo0.SUMODisjointFormulas.createview=DROP VIEW IF EXISTS %sumo0.SUMODisjointFormulas.view%; CREATE VIEW %sumo0.SUMODisjointFormulas.view% AS SELECT formulaid FROM %sumo0.SUMOArg0Map.view% WHERE sumoid = 4;
sumo0.SUMOPartitionFormulas.view=sumopartitionformulas
sumo0.SUMOPartitionFormulas.createview=DROP VIEW IF EXISTS %sumo0.SUMOPartitionFormulas.view%; CREATE VIEW %sumo0.SUMOPartitionFormulas.view% AS SELECT formulaid FROM %sumo0.SUMOArg0Map.view% WHERE sumoid = 6;
sumo0.SUMODomainFormulas.view=sumodomainformulas
sumo0.SUMODomainFormulas.createview=DROP VIEW IF EXISTS %sumo0.SUMODomainFormulas.view%; CREATE VIEW %sumo0.SUMODomainFormulas.view% AS SELECT formulaid FROM %sumo0.SUMOArg0Map.view% WHERE sumoid = 5;
sumo0.SUMORule.view=sumorules
sumo0.SUMORule.createview=DROP VIEW IF EXISTS %sumo0.SUMORule.view%; CREATE VIEW %sumo0.SUMORule.view% AS SELECT formulaid,formula,sumofileid FROM %SUMOFormula.table% INNER JOIN %SUMOParseMap.table% USING (formulaid) WHERE argnum = 0 AND (sumoid = 13 OR sumoid = 14);
sumo1.SUMORelations.view=sumorelations
sumo1.SUMORelations.createview=DROP VIEW IF EXISTS %sumo1.SUMORelations.view%; CREATE VIEW %sumo1.SUMORelations.view% AS SELECT sumoid FROM %sumo0.SUMOArg0Map.view% INNER JOIN %SUMOTerm.table% USING (sumoid) GROUP BY sumoid;
sumo1.SUMOSubclasses.view=sumosubclasses
sumo1.SUMOSubclasses.createview=DROP VIEW IF EXISTS %sumo1.SUMOSubclasses.view%; CREATE VIEW %sumo1.SUMOSubclasses.view% AS SELECT a1.sumoid AS sumoclassid, a2.sumoid AS sumosuperclassid,formulaid FROM %sumo0.SUMOSubclassFormulas.view% AS a0 INNER JOIN %sumo0.SUMOArg1Map.view% AS a1 USING (formulaid) INNER JOIN %sumo0.SUMOArg2Map.view% AS a2 USING (formulaid);
sumo1.SUMOSubrelations.view=sumosubrelations
sumo1.SUMOSubrelations.createview=DROP VIEW IF EXISTS %sumo1.SUMOSubrelations.view%; CREATE VIEW %sumo1.SUMOSubrelations.view% AS SELECT a1.sumoid AS sumorelationid, a2.sumoid AS sumosuperrelationid,formulaid FROM %sumo0.SUMOSubrelationFormulas.view% AS a0 INNER JOIN %sumo0.SUMOArg1Map.view% AS a1 USING (formulaid) INNER JOIN %sumo0.SUMOArg2Map.view% AS a2 USING (formulaid);
sumo1.SUMOInstances.view=sumoinstances
sumo1.SUMOInstances.createview=DROP VIEW IF EXISTS %sumo1.SUMOInstances.view%; CREATE VIEW %sumo1.SUMOInstances.view% AS SELECT a1.sumoid AS sumoinstanceid, a2.sumoid AS sumoclassid,formulaid FROM %sumo0.SUMOInstanceFormulas.view% AS a0 INNER JOIN %sumo0.SUMOArg1Map.view% AS a1 USING (formulaid) INNER JOIN %sumo0.SUMOArg2Map.view% AS a2 USING (formulaid);
sumo1.SUMODisjoints.view=sumodisjoints
sumo1.SUMODisjoints.createview=DROP VIEW IF EXISTS %sumo1.SUMODisjoints.view%; CREATE VIEW %sumo1.SUMODisjoints.view% AS SELECT a1.sumoid AS sumodisjoint1id, a2.sumoid AS sumodisjoint2id,formulaid FROM %sumo0.SUMODisjointFormulas.view% AS a0 INNER JOIN %sumo0.SUMOArg1Map.view% AS a1 USING (formulaid) INNER JOIN %sumo0.SUMOArg2Map.view% AS a2 USING (formulaid);