[Noalyss-commit] [noalyss] 196/219: Task #001381 : favori de filtre , table pour sauvegarder

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit b43e6400f9fb2f5478be4c3e82f96c4ca932513b
Author: Dany De Bontridder <address@hidden>
Date:   Sun Dec 10 14:21:47 2017 +0100

    Task #001381 : favori de filtre , table pour sauvegarder
---
 sql/upgrade.sql | 23 ++++++++++++++++++++++-
 1 file changed, 22 insertions(+), 1 deletion(-)

diff --git a/sql/upgrade.sql b/sql/upgrade.sql
index f606086..879e934 100644
--- a/sql/upgrade.sql
+++ b/sql/upgrade.sql
@@ -35,4 +35,25 @@ ALTER TABLE operation_analytique  ADD CONSTRAINT 
operation_analytique_fiche_id_f
 COMMENT ON COLUMN operation_analytique.f_id IS 'FK to fiche.f_id , used only 
with ODS';
 
 drop FUNCTION comptaproc.table_analytic_account(text,text);
-drop FUNCTION comptaproc.table_analytic_card(text,text);
\ No newline at end of file
+drop FUNCTION comptaproc.table_analytic_card(text,text);
+
+CREATE TABLE public.user_filter (
+       id bigserial,
+       login text NULL,
+       nb_jrn int4 NULL,
+       date_start varchar(10) NULL,
+       date_end varchar(10) NULL,
+       description text NULL,
+       amount_min numeric(20,4) NULL,
+       amount_max numeric(20,4) NULL,
+       qcode text NULL,
+       accounting text NULL,
+       r_jrn text NULL,
+       date_paid_start varchar(10) NULL,
+       date_paid_end varchar(10) NULL,
+       ledger_type varchar(5) NULL,
+       all_ledger int4 NULL,
+       filter_name text NOT NULL,
+       unpaid varchar NULL,
+       PRIMARY KEY (id)
+);