aboutsummaryrefslogtreecommitdiffstats
path: root/install/schema_postgres.sql
diff options
context:
space:
mode:
authorMario Vavti <mario@mariovavti.com>2018-03-08 08:55:25 +0100
committerMario Vavti <mario@mariovavti.com>2018-03-08 08:55:25 +0100
commitf3a753bda603595fcff25a8e4fa9131e56872f57 (patch)
tree318837a058d3594c974e101c93af04cc6155a52b /install/schema_postgres.sql
parent17c102ebe115bd8272da830bf9523b691ce115ee (diff)
parent1700aedbed9050ca2eee621c04c29e5b34150bc5 (diff)
downloadvolse-hubzilla-f3a753bda603595fcff25a8e4fa9131e56872f57.tar.gz
volse-hubzilla-f3a753bda603595fcff25a8e4fa9131e56872f57.tar.bz2
volse-hubzilla-f3a753bda603595fcff25a8e4fa9131e56872f57.zip
Merge remote-tracking branch 'mike/master' into dev
Diffstat (limited to 'install/schema_postgres.sql')
-rw-r--r--install/schema_postgres.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql
index d8bbd89f4..a4f6e9253 100644
--- a/install/schema_postgres.sql
+++ b/install/schema_postgres.sql
@@ -963,11 +963,13 @@ CREATE TABLE "poll_elm" (
"pelm_desc" text NOT NULL,
"pelm_flags" bigint NOT NULL DEFAULT '0',
"pelm_result" float NOT NULL DEFAULT '0',
+ "pelm_order" numeric(6) NOT NULL DEFAULT '0',
PRIMARY KEY ("pelm_id")
);
create index "pelm_guid" on poll_elm ("pelm_guid");
create index "pelm_poll" on poll_elm ("pelm_poll");
create index "pelm_result" on poll_elm ("pelm_result");
+create index "pelm_order" on poll_elm ("pelm_order");
CREATE TABLE "profdef" (
"id" serial NOT NULL,