diff options
author | jeroenpraat <jeroenpraat@xs4all.nl> | 2016-03-01 22:09:06 +0100 |
---|---|---|
committer | jeroenpraat <jeroenpraat@xs4all.nl> | 2016-03-01 22:09:06 +0100 |
commit | 8b61e546fe488516fa3c5f37df80a68e346b84a9 (patch) | |
tree | 8af09fcff55cd613d5d2557a7c0956bd25a4afa3 /install/schema_postgres.sql | |
parent | 7206e8af3a943b0fb286f253ed3abbda2d2572b6 (diff) | |
parent | 7808689198601780041e022bf0698e559869f305 (diff) | |
download | volse-hubzilla-8b61e546fe488516fa3c5f37df80a68e346b84a9.tar.gz volse-hubzilla-8b61e546fe488516fa3c5f37df80a68e346b84a9.tar.bz2 volse-hubzilla-8b61e546fe488516fa3c5f37df80a68e346b84a9.zip |
Merge branch 'master' of https://github.com/redmatrix/hubzilla
Diffstat (limited to 'install/schema_postgres.sql')
-rw-r--r-- | install/schema_postgres.sql | 15 |
1 files changed, 14 insertions, 1 deletions
diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql index 3302ef6c0..a7cd5875c 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, @@ -547,7 +560,7 @@ CREATE TABLE "iconfig" ( "k" text NOT NULL DEFAULT '', "v" text NOT NULL DEFAULT '', "sharing" int NOT NULL DEFAULT '0', - PRIMARY_KEY("id") + PRIMARY KEY("id") ); create index "iconfig_iid" on iconfig ("iid"); create index "iconfig_cat" on iconfig ("cat"); |