From 76bf892f9f52c0deee313a89929185e332877f85 Mon Sep 17 00:00:00 2001 From: redmatrix Date: Thu, 18 Feb 2016 00:20:08 -0800 Subject: iconfig - add sharing variable --- install/schema_postgres.sql | 2 ++ 1 file changed, 2 insertions(+) (limited to 'install/schema_postgres.sql') diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql index 2d9bffdec..964ca5966 100644 --- a/install/schema_postgres.sql +++ b/install/schema_postgres.sql @@ -544,11 +544,13 @@ CREATE TABLE "iconfig" ( "cat" text NOT NULL DEFAULT '', "k" text NOT NULL DEFAULT '', "v" text NOT NULL DEFAULT '', + "sharing" int NOT NULL DEFAULT '0', PRIMARY_KEY("id") ); create index "iconfig_iid" on iconfig ("iid"); create index "iconfig_cat" on iconfig ("cat"); create index "iconfig_k" on iconfig ("k"); +create index "iconfig_sharing" on iconfig ("sharing"); CREATE TABLE "issue" ( "issue_id" serial NOT NULL, "issue_created" timestamp NOT NULL DEFAULT '0001-01-01 00:00:00', -- cgit v1.2.3