[H2-commits] r1391 - humano2/trunk/core/schema/pgsql

[<sv...@de...>]

Author: pcamacho
Date: 2005-06-22 15:43:31 -0400 (Wed, 22 Jun 2005)
New Revision: 1391

Modified:
   humano2/trunk/core/schema/pgsql/pgsql-Beta6patch.sql
Log:
CHANGE: add patch for width and height property of pertinence.


Modified: humano2/trunk/core/schema/pgsql/pgsql-Beta6patch.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/pgsql/pgsql-Beta6patch.sql	2005-06-22 19:29=
:22 UTC (rev 1390)
+++ humano2/trunk/core/schema/pgsql/pgsql-Beta6patch.sql	2005-06-22 19:43=
:31 UTC (rev 1391)
@@ -1 +1,16 @@
-update "view"  set "where" =3D '34|8|{(''[DomainId]'',''10'')}|0|0' wher=
e id_entity =3D 1405
\ No newline at end of file
+update "view"  set "where" =3D '34|8|{(''[DomainId]'',''10'')}|0|0' wher=
e id_entity =3D 1405
+
+-- For the pertinence properties width and height
+alter table pertinence add column widthPertinence Integer;
+alter table pertinence add column heightPertinence Integer;
+insert into "entity"  ("id_entity","domainId","class","delDate","status"=
)  values (157,10,9,NULL,NULL);
+insert into "entity"  ("id_entity","domainId","class","delDate","status"=
)  values (158,10,9,NULL,NULL);
+
+INSERT INTO "attribute"  ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display")  VALUES (157,81,'widthP=
ertinence','width',0,'f','t','f','t','f','f','f','t',null);
+INSERT INTO "attribute"  ("id_entity","classId","sysAttName","attName","=
order","isObligatory","isActive","isSearchable","isEditable","isSelfLooku=
p","isPrimary","isUnique","protection","display")  VALUES (158,81,'height=
Pertinence','height',0,'f','t','f','t','f','f','f','t',null);
+INSERT INTO "numeric"  ("id_entity","decimals","max","min","default")  V=
ALUES (157,4,NULL,NULL,200); -- pertinence width
+INSERT INTO "numeric"  ("id_entity","decimals","max","min","default")  V=
ALUES (158,4,NULL,NULL,200); -- pertinence height
+
+
+
+