diff options
author | redmatrix <git@macgirvin.com> | 2016-02-29 19:31:52 -0800 |
---|---|---|
committer | redmatrix <git@macgirvin.com> | 2016-02-29 19:31:52 -0800 |
commit | be2b7c0b5f7f9b8080affbb4bc44c5adda18e82f (patch) | |
tree | 6dde06168b0df62044a3fdeaf2b4b9b649165d7a /install/schema_postgres.sql | |
parent | 44b2503572700ab24e7afad4637f62c413d3d489 (diff) | |
download | volse-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.sql | 13 |
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, |