diff options
Diffstat (limited to 'database/database.pgsql')
-rw-r--r-- | database/database.pgsql | 21 |
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'; |