#9810: PostgreSQL updates by Adrian.

1 files changed, 21 insertions, 0 deletions

diff --git a/database/database.pgsql b/database/database.pgsql
index a4eaf9af4..d59fa6e6b 100644
--- a/database/database.pgsql
+++ b/database/database.pgsql
@@ -343,6 +343,21 @@ CREATE INDEX node_created ON node(created);
 CREATE INDEX node_changed ON node(changed);
 
 --
+-- Table structure for table `node_access`
+--
+
+CREATE TABLE node_access (
+  nid SERIAL,
+  gid integer NOT NULL default '0',
+  realm text NOT NULL default '',
+  grant_view smallint NOT NULL default '0',
+  grant_update smallint NOT NULL default '0',
+  grant_delete smallint NOT NULL default '0',
+  PRIMARY KEY  (nid,gid,realm)
+); 
+
+
+--
 -- Table structure for table 'node_counter'
 --
 
@@ -700,3 +715,9 @@ BEGIN
   RETURN random();
 END;
 ' LANGUAGE 'plpgsql';
+
+CREATE FUNCTION "concat"(text, text) RETURNS text AS '
+BEGIN
+  RETURN $1 || $2;
+END;
+' LANGUAGE 'plpgsql';