From 08af080a3f02a03b4f4543b3605d3d0d71da0d6d Mon Sep 17 00:00:00 2001 From: Brion Vibber Date: Sat, 2 Oct 2004 03:59:17 +0000 Subject: [PATCH] Add quick hacky defs for groups and user_groups tables to get pg wiki running again. Please somebody check over these (and the originals) --- maintenance/postgresql/pg_tables.sql | 15 +++++++++++++++ 1 file changed, 15 insertions(+) diff --git a/maintenance/postgresql/pg_tables.sql b/maintenance/postgresql/pg_tables.sql index 217440bc0c..c928889c9a 100644 --- a/maintenance/postgresql/pg_tables.sql +++ b/maintenance/postgresql/pg_tables.sql @@ -270,3 +270,18 @@ CREATE TABLE logging ( CREATE INDEX log_type_time ON logging USING btree (log_type, log_timestamp); CREATE INDEX log_user_time ON logging USING btree (log_user, log_timestamp); CREATE INDEX log_page_time ON logging USING btree (log_namespace, log_title, log_timestamp); + + +-- HACK HACK HACK +CREATE TABLE "group" ( + group_id integer PRIMARY KEY, + group_name varchar(50) NOT NULL, + group_description varchar(255) NOT NULL +); + +-- Relation table between user and groups +CREATE TABLE user_groups ( + user_id integer NOT NULL, + group_id integer NOT NULL, + PRIMARY KEY (user_id,group_id) +); -- 2.20.1