From cabd6c892cbce8c1483c46fe76ce3885cd5f9e41 Mon Sep 17 00:00:00 2001
From: Steven Wittens <steven@10.no-reply.drupal.org>
Date: Fri, 6 Aug 2004 09:49:25 +0000
Subject: #9810: PostgreSQL updates by Adrian.

---
 database/database.pgsql | 21 +++++++++++++++++++++
 1 file changed, 21 insertions(+)

(limited to 'database/database.pgsql')

diff --git a/database/database.pgsql b/database/database.pgsql
index a4eaf9af4..d59fa6e6b 100644
--- a/database/database.pgsql
+++ b/database/database.pgsql
@@ -342,6 +342,21 @@ CREATE INDEX node_promote_status_idx ON node (promote, status);
 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';
-- 
cgit v1.2.3