aboutsummaryrefslogtreecommitdiffstats
path: root/install/schema_postgres.sql
diff options
context:
space:
mode:
authorMax Kostikov <max@kostikov.co>2018-09-27 23:46:58 +0200
committerMax Kostikov <max@kostikov.co>2018-09-27 23:46:58 +0200
commitbb3d908bcf89536b418b7fca517d03655c244df5 (patch)
treea0e226b4dd936bdf447257f1c9424fe733b3ffe6 /install/schema_postgres.sql
parent98b3946fca91fbacb662c14a1545e8eb1982ef3e (diff)
downloadvolse-hubzilla-bb3d908bcf89536b418b7fca517d03655c244df5.tar.gz
volse-hubzilla-bb3d908bcf89536b418b7fca517d03655c244df5.tar.bz2
volse-hubzilla-bb3d908bcf89536b418b7fca517d03655c244df5.zip
Update schema_postgres.sql
Diffstat (limited to 'install/schema_postgres.sql')
-rw-r--r--install/schema_postgres.sql18
1 files changed, 9 insertions, 9 deletions
diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql
index 7f118646e..cb4476628 100644
--- a/install/schema_postgres.sql
+++ b/install/schema_postgres.sql
@@ -434,18 +434,18 @@ create index "event_status_idx" on event ("event_status");
create index "event_sequence_idx" on event ("event_sequence");
create index "event_priority_idx" on event ("event_priority");
-CREATE TABLE "group_member" (
+CREATE TABLE "pgrp_member" (
"id" serial NOT NULL,
"uid" bigint NOT NULL,
"gid" bigint NOT NULL,
"xchan" text NOT NULL DEFAULT '',
PRIMARY KEY ("id")
);
-create index "groupmember_uid" on group_member ("uid");
-create index "groupmember_gid" on group_member ("gid");
-create index "groupmember_xchan" on group_member ("xchan");
+create index "groupmember_uid" on pgrp_member ("uid");
+create index "groupmember_gid" on pgrp_member ("gid");
+create index "groupmember_xchan" on pgrp_member ("xchan");
-CREATE TABLE "groups" (
+CREATE TABLE "pgrp" (
"id" serial NOT NULL,
"hash" text NOT NULL DEFAULT '',
"uid" bigint NOT NULL,
@@ -455,10 +455,10 @@ CREATE TABLE "groups" (
PRIMARY KEY ("id")
);
-create index "groups_uid_idx" on groups ("uid");
-create index "groups_visible_idx" on groups ("visible");
-create index "groups_deleted_idx" on groups ("deleted");
-create index "groups_hash_idx" on groups ("hash");
+create index "groups_uid_idx" on pgrp ("uid");
+create index "groups_visible_idx" on pgrp ("visible");
+create index "groups_deleted_idx" on pgrp ("deleted");
+create index "groups_hash_idx" on pgrp ("hash");
CREATE TABLE "hook" (
"id" serial NOT NULL,