aboutsummaryrefslogtreecommitdiffstats
path: root/install/schema_postgres.sql
diff options
context:
space:
mode:
authorredmatrix <git@macgirvin.com>2016-02-29 19:31:52 -0800
committerredmatrix <git@macgirvin.com>2016-02-29 19:31:52 -0800
commitbe2b7c0b5f7f9b8080affbb4bc44c5adda18e82f (patch)
tree6dde06168b0df62044a3fdeaf2b4b9b649165d7a /install/schema_postgres.sql
parent44b2503572700ab24e7afad4637f62c413d3d489 (diff)
downloadvolse-hubzilla-be2b7c0b5f7f9b8080affbb4bc44c5adda18e82f.tar.gz
volse-hubzilla-be2b7c0b5f7f9b8080affbb4bc44c5adda18e82f.tar.bz2
volse-hubzilla-be2b7c0b5f7f9b8080affbb4bc44c5adda18e82f.zip
abconfig
Diffstat (limited to 'install/schema_postgres.sql')
-rw-r--r--install/schema_postgres.sql13
1 files changed, 13 insertions, 0 deletions
diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql
index 3302ef6c0..0ff78e873 100644
--- a/install/schema_postgres.sql
+++ b/install/schema_postgres.sql
@@ -1,3 +1,16 @@
+CREATE TABLE "abconfig" (
+ "id" serial NOT NULL,
+ "chan" text NOT NULL,
+ "xchan" text NOT NULL,
+ "cat" text NOT NULL,
+ "k" text NOT NULL,
+ "v" text NOT NULL,
+ PRIMARY KEY ("id")
+);
+create index "abconfig_chan" on abconfig ("chan");
+create index "abconfig_xchan" on abconfig ("xchan");
+create index "abconfig_cat" on abconfig ("cat");
+create index "abconfig_k" on abconfig ("k");
CREATE TABLE "abook" (
"abook_id" serial NOT NULL,
"abook_account" bigint NOT NULL,