entrouvert
/
publik-bi
Archived
17
0
Fork 0
Code Issues Pull Requests Releases Activity

3m: fix typo, exit on error

This commit is contained in:
Benjamin Dauvergne 2016-06-18 09:20:38 +02:00
parent b313b03884
commit ce235ceac8
1 changed files with 2 additions and 1 deletions
Show Stats Download Patch File Download Diff File Expand all files Collapse all files

3
3m/3m_prod.sql
View File

@ -1,3 +1,4 @@
\set ON_ERROR_STOP on
-- Clean
DROP TABLE IF EXISTS bi_form;
DROP TABLE IF EXISTS bi_status;
@ -162,7 +163,7 @@ CREATE TABLE bi_all_forms AS (
SELECT formdef_id || '-' || id AS id, backoffice_submission, 'espaces_verts' as form, receipt_time, status, pole_commune_ref FROM bi_espaces_verts);
CREATE TABLE bi_form AS (SELECT distinct(form) from bi_all_forms);
CREATE INDEX ON bi_form AS (form);
CREATE INDEX ON bi_form (form);
CREATE TABLE bi_status AS (SELECT distinct(status) from bi_all_forms);
CREATE INDEX ON bi_status (status);