|
From: <sv...@de...> - 2005-06-22 19:43:25
|
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
+
+
+
+
|