Minor changes.

git-svn-id: svn://svn.zabbix.com/trunk@2833 97f52cf1-0a1b-0410-bd0e-c28be96e8082

1 files changed, 12 insertions, 0 deletions

diff --git a/upgrades/dbpatches/1.1beta9_to_1.1beta10/postgresql/patch.sql b/upgrades/dbpatches/1.1beta9_to_1.1beta10/postgresql/patch.sql
index ef76f5dc..88634afe 100644
--- a/upgrades/dbpatches/1.1beta9_to_1.1beta10/postgresql/patch.sql
+++ b/upgrades/dbpatches/1.1beta9_to_1.1beta10/postgresql/patch.sql
@@ -32,3 +32,15 @@ CREATE TABLE items_applications (
 );
 
 alter table audit rename auditlog;
+
+alter table auditlog add resourcetype          int4          DEFAULT '0' NOT NULL;
+update auditlog set resourcetype=resource;
+alter table auditlog drop resource;
+
+alter table screens add hsize   int4  DEFAULT '1' NOT NULL;
+alter table screens add vsize   int4  DEFAULT '1' NOT NULL;
+update screens set hsize=cols;
+update screens set vsize=rows;
+alter table screens drop cols;
+alter table screens drop rows;
+