|
From: <sv...@de...> - 2005-05-18 17:02:32
|
Author: marcelo Date: 2005-05-18 13:02:22 -0400 (Wed, 18 May 2005) New Revision: 1084 Added: humano2/branches/datareader/core/schema/mssql/mssql-2-formulas.sql humano2/branches/datareader/core/schema/mssql/mssql-3-view.sql Log: Added: humano2/branches/datareader/core/schema/mssql/mssql-2-formulas.sql =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D --- humano2/branches/datareader/core/schema/mssql/mssql-2-formulas.sql 20= 05-05-18 17:01:42 UTC (rev 1083) +++ humano2/branches/datareader/core/schema/mssql/mssql-2-formulas.sql 20= 05-05-18 17:02:22 UTC (rev 1084) @@ -0,0 +1,48 @@ +-- The Humano2 Business solution +-- Copyright (C) 2004,5 Humano2 Chile S.A. (http://www.humano2.com) +-- +-- This program is free software; you can redistribute it and/or modify +-- it under the terms of the GNU General Public License as published by +-- the Free Software Foundation; either version 2 of the License, or +-- (at your option) any later version. =20 +-- +-- $Id: mssql-2-formulas.sql 1082 2005-05-18 16:58:10Z marcelo $ + +CREATE TABLE formula ( + "id_entity" integer PRIMARY KEY, + "formula" text, + "attributeId" integer, + "orderFormula" integer,=20 + "formulaName" text, + "descFormula" text +); +set identity_insert entity on +INSERT INTO entity ("id_entity","domainId","class","delDate","status")=20 + VALUES (1001, 10, 2, NULL, NULL); +INSERT INTO entity ("id_entity","domainId","class","delDate","status") + VALUES (1002, 10, 13, NULL, NULL); +INSERT INTO entity ("id_entity","domainId","class","delDate","status") + VALUES (1003, 10, 81, NULL, NULL); +INSERT INTO entity ("id_entity","domainId","class","delDate","status") + VALUES (1004, 10, 9, NULL, NULL); +INSERT INTO entity ("id_entity","domainId","class","delDate","status") + VALUES (1005, 10, 13, NULL, NULL); +INSERT INTO entity ("id_entity","domainId","class","delDate","status") + VALUES (1006, 10, 13, NULL, NULL); +set identity_insert entity off + +INSERT INTO "class" VALUES (1001, 27, 'formula', 'formula', 3, 0, 0, NUL= L); + +INSERT INTO "attribute" VALUES (1002, 1001, 'formula', 'formula', 0.00, = 0, 1, 0, 1, 0, 1, 0, 0, NULL, 1, 0 ); +INSERT INTO "attribute" VALUES (1003, 1001, 'attributeId', 'attributeId'= , 0.00, 0, 1, 0, 0, 0, 0, 0, 0, NULL, 1, 0 ); +INSERT INTO "attribute" VALUES (1004, 1001, 'orderFormula', 'order', 0.0= 0, 0, 1, 0, 1, 0, 0, 0, 0, NULL, 1, 0); +INSERT INTO "attribute" VALUES (1005, 1001, 'formulaName', 'name', 0.00,= 0, 1, 0, 1, 0, 0, 0, 0, NULL, 1, 0); +INSERT INTO "attribute" VALUES (1006, 1001, 'descFormula', 'desciption',= 0.00, 0, 1, 0, 1, 0, 0, 0, 0, NULL, 1, 0); + +INSERT INTO "numeric" VALUES (1004, NULL, NULL, NULL, NULL); + +INSERT INTO "pertinence" VALUES (1003, 1003, 5, 'n:1', NULL, NULL,NULL); + +INSERT INTO "text" ("id_entity","rows","cols","isHtml") VALUES (1002, 5= , 40, 0); +INSERT INTO "text" ("id_entity","rows","cols","isHtml") VALUES (1005, 5= , 25, 0); +INSERT INTO "text" ("id_entity","rows","cols","isHtml") VALUES (1006, 5= , 25, 0); Added: humano2/branches/datareader/core/schema/mssql/mssql-3-view.sql =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D --- humano2/branches/datareader/core/schema/mssql/mssql-3-view.sql 2005-0= 5-18 17:01:42 UTC (rev 1083) +++ humano2/branches/datareader/core/schema/mssql/mssql-3-view.sql 2005-0= 5-18 17:02:22 UTC (rev 1084) @@ -0,0 +1,51 @@ +-- The Humano2 Business solution +-- Copyright (C) 2004,5 Humano2 Chile S.A. (http://www.humano2.com) +-- +-- This program is free software; you can redistribute it and/or modify +-- it under the terms of the GNU General Public License as published by +-- the Free Software Foundation; either version 2 of the License, or +-- (at your option) any later version. =20 +-- +-- $Id: mssql-3-view.sql 1082 2005-05-18 16:58:10Z marcelo $ + +CREATE TABLE "view" ( + id_entity integer PRIMARY KEY, + "columns" text, + "where" text, + "groupby" text, + "having" text, + "order" text, + "idClassView" integer, + "viewName" character varying(50) +); + +set identity_insert entity ON +INSERT INTO entity ("id_entity","domainId","class","delDate","status") V= ALUES (1011, 10, 2, NULL, NULL); +INSERT INTO entity ("id_entity","domainId","class","delDate","status") V= ALUES (1012, 10, 13, NULL, NULL); +INSERT INTO entity ("id_entity","domainId","class","delDate","status") V= ALUES (1013, 10, 13, NULL, NULL); +INSERT INTO entity ("id_entity","domainId","class","delDate","status") V= ALUES (1014, 10, 13, NULL, NULL); +INSERT INTO entity ("id_entity","domainId","class","delDate","status") V= ALUES (1015, 10, 13, NULL, NULL); +INSERT INTO entity ("id_entity","domainId","class","delDate","status") V= ALUES (1016, 10, 13, NULL, NULL); +INSERT INTO entity ("id_entity","domainId","class","delDate","status") V= ALUES (1017, 10, 81,NULL, NULL); +INSERT INTO entity ("id_entity","domainId","class","delDate","status") V= ALUES (1018, 10, 8, NULL, NULL); +set identity_insert entity Off + +INSERT INTO "class" VALUES (1011, 27, 'view', 'view', 3, 0, 0, NULL); + +INSERT INTO attribute VALUES (1012, 1011, 'columns', 'columns', 0.00, 0,= 1, 0, 1, 0, 0, 0, 0, NULL, 1, 0); +INSERT INTO attribute VALUES (1013, 1011, 'where', 'where', 0.00, 0, 1, = 0, 1, 0, 0, 0, 0, NULL, 1, 0); +INSERT INTO attribute VALUES (1014, 1011, 'groupby', 'groupby', 0.00, 0,= 1, 0, 1, 0, 0, 0, 0, NULL, 1, 0); +INSERT INTO attribute VALUES (1015, 1011, 'having', 'having', 0.00, 0, 1= , 0, 1, 0, 0, 0, 0, NULL, 1, 0); +INSERT INTO attribute VALUES (1016, 1011, 'order', 'order', 0.00, 0, 1, = 0, 1, 0, 0, 0, 0, NULL, 1, 0); +INSERT INTO attribute VALUES (1017, 1011, 'idClassView', 'class', 0.00, = 0, 1, 0, 0, 0, 0, 0, 0, NULL, 1, 0); +INSERT INTO attribute VALUES (1018, 1011, 'viewName', 'name', 0.00, 0, 1= , 0, 1, 0, 1, 0, 0, NULL, 1, 0); + +INSERT INTO pertinence VALUES (1017, 1017, 2, 'n:1', NULL, NULL, NULL); + +INSERT INTO "text" ("id_entity","rows","cols","isHtml") VALUES (1012,5= ,25,0); +INSERT INTO "text" ("id_entity","rows","cols","isHtml") VALUES (1013,5= ,25,0); +INSERT INTO "text" ("id_entity","rows","cols","isHtml") VALUES (1014,5= ,25,0); +INSERT INTO "text" ("id_entity","rows","cols","isHtml") VALUES (1015,5= ,25,0); +INSERT INTO "text" ("id_entity","rows","cols","isHtml") VALUES (1016,5= ,25,0); + +INSERT INTO textline VALUES (1018, NULL, NULL, NULL, NULL); |