Diff of /sumo/src/main/resources/org/wnsql/builder/sumo/test.properties [987195] .. [6ff7b6]  Maximize  Restore

Switch to side-by-side view

--- a/sumo/src/main/resources/org/wnsql/builder/sumo/test.properties
+++ b/sumo/src/main/resources/org/wnsql/builder/sumo/test.properties
@@ -1,65 +1,65 @@
 SUMOTerm.table=sumoterms
-SUMOTerm.create=CREATE TABLE %SUMOTerm.table% (sumoid INTEGER NOT NULL DEFAULT '0',sumoterm VARCHAR (128) NOT NULL,CONSTRAINT pk_%SUMOTerm.table% PRIMARY KEY (sumoid));
-SUMOTerm.pk=ALTER TABLE %SUMOTerm.table% ADD CONSTRAINT pk_%SUMOTerm.table% PRIMARY KEY (sumoid);
-SUMOTerm.no-pk=ALTER TABLE %SUMOTerm.table% DROP CONSTRAINT pk_%SUMOTerm.table% CASCADE;
-SUMOTerm.unq=CREATE UNIQUE INDEX unq_%SUMOTerm.table%_sumoterm ON %SUMOTerm.table% (sumoterm);
-SUMOTerm.no-unq=DROP INDEX unq_%SUMOTerm.table%_sumoterm;
+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 %SUMOTermAttr.table% (sumoid INTEGER NOT NULL DEFAULT '0',sumoattr VARCHAR (1) NOT NULL,CONSTRAINT pk_%SUMOTermAttr.table% PRIMARY KEY (sumoid,sumoattr));
-SUMOTermAttr.pk=ALTER TABLE %SUMOTermAttr.table% ADD CONSTRAINT pk_%SUMOTermAttr.table% PRIMARY KEY (sumoid,sumoattr);
-SUMOTermAttr.no-pk=ALTER TABLE %SUMOTermAttr.table% DROP CONSTRAINT pk_%SUMOTermAttr.table% CASCADE;
-SUMOTermAttr.fk1=ALTER TABLE %SUMOTermAttr.table% ADD CONSTRAINT fk_%SUMOTermAttr.table%_sumoid FOREIGN KEY (sumoid) REFERENCES %SUMOTerm.table% (sumoid);
-SUMOTermAttr.no-fk1=ALTER TABLE %SUMOTermAttr.table% DROP CONSTRAINT fk_%SUMOTermAttr.table%_sumoid CASCADE;
+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 %SUMOFile.table% (sumofileid INTEGER NOT NULL DEFAULT '0',sumofile VARCHAR (128) NOT NULL,sumoversion VARCHAR (5) DEFAULT NULL,sumodate TIMESTAMP DEFAULT NULL,CONSTRAINT pk_%SUMOFile.table% PRIMARY KEY (sumofileid));
-SUMOFile.pk=ALTER TABLE %SUMOFile.table% ADD CONSTRAINT pk_%SUMOFile.table% PRIMARY KEY (sumofileid);
-SUMOFile.no-pk=ALTER TABLE %SUMOFile.table% DROP CONSTRAINT pk_%SUMOFile.table% CASCADE;
-SUMOFile.unq=CREATE UNIQUE INDEX unq_%SUMOFile.table%_sumofile ON %SUMOFile.table% (sumofile);
-SUMOFile.no-unq=DROP INDEX unq_%SUMOFile.table%_sumofile;
+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 %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=ALTER TABLE %SUMOFormula.table% ADD CONSTRAINT pk_%SUMOFormula.table% PRIMARY KEY (formulaid);
-SUMOFormula.no-pk=ALTER TABLE %SUMOFormula.table% DROP CONSTRAINT pk_%SUMOFormula.table% CASCADE;
-SUMOFormula.index=CREATE INDEX k_%SUMOFormula.table%_formula ON %SUMOFormula.table% USING HASH (formula);
-SUMOFormula.no-index=DROP INDEX k_%SUMOFormula.table%_formula;
-SUMOFormula.fk1=ALTER TABLE %SUMOFormula.table% ADD CONSTRAINT fk_%SUMOFormula.table%_sumofileid FOREIGN KEY (sumofileid) REFERENCES %SUMOFile.table% (sumofileid);
-SUMOFormula.no-fk1=ALTER TABLE %SUMOFormula.table% DROP CONSTRAINT fk_%SUMOFormula.table%_sumofileid CASCADE;
+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 %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=ALTER TABLE %SUMOMap.table% ADD CONSTRAINT pk_%SUMOMap.table% PRIMARY KEY (synsetid);
-SUMOMap.no-pk=ALTER TABLE %SUMOMap.table% DROP CONSTRAINT pk_%SUMOMap.table% CASCADE;
-SUMOMap.index1=CREATE INDEX k_%SUMOMap.table%_sumoid ON %SUMOMap.table% (sumoid);
-SUMOMap.no-index1=DROP INDEX k_%SUMOMap.table%_sumoid;
-SUMOMap.index2=CREATE INDEX k_%SUMOMap.table%_sumownrel ON %SUMOMap.table% (sumownrel);
-SUMOMap.no-index2=DROP INDEX k_%SUMOMap.table%_sumownrel;
-SUMOMap.fk1=ALTER TABLE %SUMOMap.table% ADD CONSTRAINT fk_%SUMOMap.table%_synsetid FOREIGN KEY (synsetid) REFERENCES %Synset.table% (synsetid);
-SUMOMap.no-fk1=ALTER TABLE %SUMOMap.table% DROP CONSTRAINT fk_%SUMOMap.table%_synsetid CASCADE;
-SUMOMap.fk2=ALTER TABLE %SUMOMap.table% ADD CONSTRAINT fk_%SUMOMap.table%_sumoid FOREIGN KEY (sumoid) REFERENCES %SUMOTerm.table% (sumoid);
-SUMOMap.no-fk2=ALTER TABLE %SUMOMap.table% DROP CONSTRAINT fk_%SUMOMap.table%_sumoid CASCADE;
+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 %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=ALTER TABLE %SUMOParseMap.table% ADD CONSTRAINT pk_%SUMOParseMap.table% PRIMARY KEY (mapid);
-SUMOParseMap.no-pk=ALTER TABLE %SUMOParseMap.table% DROP CONSTRAINT pk_%SUMOParseMap.table% CASCADE;
-SUMOParseMap.index1=CREATE INDEX k_%SUMOParseMap.table%_formulaid ON %SUMOParseMap.table% (formulaid);
-SUMOParseMap.no-index1=DROP INDEX k_%SUMOParseMap.table%_formulaid;
-SUMOParseMap.index2=CREATE INDEX k_%SUMOParseMap.table%_sumoid ON %SUMOParseMap.table% (sumoid);
-SUMOParseMap.no-index2=DROP INDEX k_%SUMOParseMap.table%_sumoid;
-SUMOParseMap.index3=CREATE INDEX k_%SUMOParseMap.table%_sumoparsetype ON %SUMOParseMap.table% (sumoparsetype);
-SUMOParseMap.no-index3=DROP INDEX k_%SUMOParseMap.table%_sumoparsetype;
-SUMOParseMap.fk1=ALTER TABLE %SUMOParseMap.table% ADD CONSTRAINT fk_%SUMOParseMap.table%_formulaid FOREIGN KEY (formulaid) REFERENCES %SUMOFormula.table% (formulaid);
-SUMOParseMap.no-fk1=ALTER TABLE %SUMOParseMap.table% DROP CONSTRAINT fk_%SUMOParseMap.table%_formulaid CASCADE;
-SUMOParseMap.fk2=ALTER TABLE %SUMOParseMap.table% ADD CONSTRAINT fk_%SUMOParseMap.table%_sumoid FOREIGN KEY (sumoid) REFERENCES %SUMOTerm.table% (sumoid);
-SUMOParseMap.no-fk2=ALTER TABLE %SUMOParseMap.table% DROP CONSTRAINT fk_%SUMOParseMap.table%_sumoid CASCADE;
+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;
@@ -132,37 +132,37 @@
 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=CREATE OR REPLACE VIEW sumoarg0maps AS SELECT mapid,sumoid,formulaid FROM %SUMOParseMap.table% WHERE sumoparsetype = 'a' AND argnum = 0;
+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=CREATE OR REPLACE VIEW sumoarg1maps AS SELECT mapid,sumoid,formulaid FROM %SUMOParseMap.table% WHERE sumoparsetype = 'a' AND argnum = 1;
+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=CREATE OR REPLACE VIEW sumoarg2maps AS SELECT mapid,sumoid,formulaid FROM %SUMOParseMap.table% WHERE sumoparsetype = 'a' AND argnum = 2;
+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=CREATE OR REPLACE VIEW sumoarg3maps AS SELECT mapid,sumoid,formulaid FROM %SUMOParseMap.table% WHERE sumoparsetype = 'a' AND argnum = 3;
+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=CREATE OR REPLACE VIEW %sumo0.SUMOSubclassFormulas.view% AS SELECT formulaid FROM %sumo0.SUMOArg0Map.view% WHERE sumoid = 1;
+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=CREATE OR REPLACE VIEW %sumo0.SUMOSubrelationFormulas.view% AS SELECT formulaid FROM %sumo0.SUMOArg0Map.view% WHERE sumoid = 2;
+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=CREATE OR REPLACE VIEW %sumo0.SUMOInstanceFormulas.view% AS SELECT formulaid FROM %sumo0.SUMOArg0Map.view% WHERE sumoid = 3;
+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=CREATE OR REPLACE VIEW %sumo0.SUMODisjointFormulas.view% AS SELECT formulaid FROM %sumo0.SUMOArg0Map.view% WHERE sumoid = 4;
+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=CREATE OR REPLACE VIEW %sumo0.SUMOPartitionFormulas.view% AS SELECT formulaid FROM %sumo0.SUMOArg0Map.view% WHERE sumoid = 6;
+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=CREATE OR REPLACE VIEW %sumo0.SUMODomainFormulas.view% AS SELECT formulaid FROM %sumo0.SUMOArg0Map.view% WHERE sumoid = 5;
+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=CREATE OR REPLACE 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);
+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=CREATE OR REPLACE VIEW %sumo1.SUMORelations.view% AS SELECT sumoid FROM %sumo0.SUMOArg0Map.view% INNER JOIN %SUMOTerm.table% USING (sumoid) GROUP BY sumoid;
+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=CREATE OR REPLACE 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.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=CREATE OR REPLACE 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.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=CREATE OR REPLACE 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.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=CREATE OR REPLACE 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);
+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);

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks