|
From: <sv...@de...> - 2005-06-22 21:18:55
|
Author: marcelo
Date: 2005-06-22 17:19:02 -0400 (Wed, 22 Jun 2005)
New Revision: 1397
Modified:
humano2/trunk/core/schema/pgsql/pgsql-Beta6patch.sql
Log:
* Fixed Patch, had not placed column names within quotes to respect uppe=
rcase characters.
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 21:16=
:59 UTC (rev 1396)
+++ humano2/trunk/core/schema/pgsql/pgsql-Beta6patch.sql 2005-06-22 21:19=
:02 UTC (rev 1397)
@@ -1,8 +1,8 @@
update "view" set "where" =3D '34|8|{(''[DomainId]'',''10'')}|0|0' wher=
e id_entity =3D 1405;
=20
-- For the pertinence properties width and height
-alter table pertinence add column widthPertinence Integer;
-alter table pertinence add column heightPertinence Integer;
+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);
=20
|