[H2-commits] r1084 - humano2/branches/datareader/core/schema/mssql

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

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);



