From 4b8bcabb852ccf109c7effefc2824e218f3274b7 Mon Sep 17 00:00:00 2001
From: garvinhicking <garvinhicking>
Date: Thu, 2 Nov 2006 11:34:15 +0000
Subject: [PATCH] Fix a pgsql update routine error, thanks to ads from the
 forums

---
 sql/db_update_1.1-alpha4_1.1-alpha5_postgres.sql | 4 ++++
 1 file changed, 4 insertions(+)
 create mode 100644 sql/db_update_1.1-alpha4_1.1-alpha5_postgres.sql

diff --git a/sql/db_update_1.1-alpha4_1.1-alpha5_postgres.sql b/sql/db_update_1.1-alpha4_1.1-alpha5_postgres.sql
new file mode 100644
index 0000000..38b5b49
--- /dev/null
+++ b/sql/db_update_1.1-alpha4_1.1-alpha5_postgres.sql
@@ -0,0 +1,4 @@
+ALTER TABLE {PREFIX}images ADD COLUMN realname varchar(255);
+ALTER TABLE {PREFIX}references ADD COLUMN type varchar(128);
+CREATE INDEX reftype_idx ON {PREFIX}references (type);
+
-- 
2.39.5