summaryrefslogtreecommitdiff
path: root/database/database.pgsql
diff options
context:
space:
mode:
Diffstat (limited to 'database/database.pgsql')
-rw-r--r--database/database.pgsql21
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';