[H2-commits] r1080 - humano2/trunk/core/schema/mssql

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

Author: marijn
Date: 2005-05-18 11:20:22 -0400 (Wed, 18 May 2005)
New Revision: 1080

Added:
   humano2/trunk/core/schema/mssql/mssql-2-formulas.sql
   humano2/trunk/core/schema/mssql/mssql-3-view.sql
Removed:
   humano2/trunk/core/schema/mssql/msql-2-formulas.sql
   humano2/trunk/core/schema/mssql/msql-3-view.sql
Log:
Uniforming naming of files.

Deleted: humano2/trunk/core/schema/mssql/msql-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/trunk/core/schema/mssql/msql-2-formulas.sql	2005-05-18 13:30:=
22 UTC (rev 1079)
+++ humano2/trunk/core/schema/mssql/msql-2-formulas.sql	2005-05-18 15:20:=
22 UTC (rev 1080)
@@ -1,48 +0,0 @@
--- 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: pgsql-2-formulas.sql 946 2005-05-10 14:53:11Z marijn $
-
-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, 'f', 'f',=
 NULL);
-
-INSERT INTO "attribute" VALUES (1002, 1001, 'formula', 'formula', 0.00, =
'f', 't', 'f', 't', 'f', 't', 'f', 'f', NULL, 't', 0 );
-INSERT INTO "attribute" VALUES (1003, 1001, 'attributeId', 'attributeId'=
, 0.00, 'f', 't', 'f', 'f', 'f', 'f', 'f', 'f', NULL, 't', 0 );
-INSERT INTO "attribute" VALUES (1004, 1001, 'orderFormula', 'order', 0.0=
0, 'f', 't', 'f', 't', 'f', 'f', 'f', 'f', NULL, 't', 0);
-INSERT INTO "attribute" VALUES (1005, 1001, 'formulaName', 'name', 0.00,=
 'f', 't', 'f', 't', 'f', 'f', 'f', 'f', NULL, 't', 0);
-INSERT INTO "attribute" VALUES (1006, 1001, 'descFormula', 'desciption',=
 0.00, 'f', 't', 'f', 't', 'f', 'f', 'f', 'f', NULL, 't', 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, 'f');
-INSERT INTO "text"  ("id_entity","rows","cols","isHtml") VALUES (1005, 5=
, 25, 'f');
-INSERT INTO "text"  ("id_entity","rows","cols","isHtml") VALUES (1006, 5=
, 25, 'f');

Deleted: humano2/trunk/core/schema/mssql/msql-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/trunk/core/schema/mssql/msql-3-view.sql	2005-05-18 13:30:22 U=
TC (rev 1079)
+++ humano2/trunk/core/schema/mssql/msql-3-view.sql	2005-05-18 15:20:22 U=
TC (rev 1080)
@@ -1,51 +0,0 @@
--- 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: pgsql-3-view.sql 817 2005-05-06 00:49:38Z pcamacho $
-
-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, 'f', 'f', NULL)=
;
-
-INSERT INTO attribute VALUES (1012, 1011, 'columns', 'columns', 0.00, 'f=
', 't', 'f', 't', 'f', 'f', 'f', 'f', NULL, 't', 0);
-INSERT INTO attribute VALUES (1013, 1011, 'where', 'where', 0.00, 'f', '=
t', 'f', 't', 'f', 'f', 'f', 'f', NULL, 't', 0);
-INSERT INTO attribute VALUES (1014, 1011, 'groupby', 'groupby', 0.00, 'f=
', 't', 'f', 't', 'f', 'f', 'f', 'f', NULL, 't', 0);
-INSERT INTO attribute VALUES (1015, 1011, 'having', 'having', 0.00, 'f',=
 't', 'f', 't', 'f', 'f', 'f', 'f', NULL, 't', 0);
-INSERT INTO attribute VALUES (1016, 1011, 'order', 'order', 0.00, 'f', '=
t', 'f', 't', 'f', 'f', 'f', 'f', NULL, 't', 0);
-INSERT INTO attribute VALUES (1017, 1011, 'idClassView', 'class', 0.00, =
'f', 't', 'f', 'f', 'f', 'f', 'f', 'f', NULL, 't', 0);
-INSERT INTO attribute VALUES (1018, 1011, 'viewName', 'name', 0.00, 'f',=
 't', 'f', 't', 'f', 't', 'f', 'f', NULL, 't', 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,'f');
-INSERT INTO "text"  ("id_entity","rows","cols","isHtml")  VALUES (1013,5=
,25,'f');
-INSERT INTO "text"  ("id_entity","rows","cols","isHtml")  VALUES (1014,5=
,25,'f');
-INSERT INTO "text"  ("id_entity","rows","cols","isHtml")  VALUES (1015,5=
,25,'f');
-INSERT INTO "text"  ("id_entity","rows","cols","isHtml")  VALUES (1016,5=
,25,'f');
-
-INSERT INTO textline VALUES (1018, NULL, NULL, NULL, NULL);

Copied: humano2/trunk/core/schema/mssql/mssql-2-formulas.sql (from rev 10=
79, humano2/trunk/core/schema/mssql/msql-2-formulas.sql)

Copied: humano2/trunk/core/schema/mssql/mssql-3-view.sql (from rev 1079, =
humano2/trunk/core/schema/mssql/msql-3-view.sql)



