[Noalyss-commit] [noalyss] 01/04: add forgotten file

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit 3c5345062a4168c02c11e881832e2f44d2926073
Author: Dany De Bontridder <address@hidden>
Date:   Sat Nov 30 20:04:11 2019 +0100

    add forgotten file
---
 include/sql/patch/upgrade140.sql | 10 ++++++++++
 1 file changed, 10 insertions(+)

diff --git a/include/sql/patch/upgrade140.sql b/include/sql/patch/upgrade140.sql
new file mode 100644
index 0000000..6a2662c
--- /dev/null
+++ b/include/sql/patch/upgrade140.sql
@@ -0,0 +1,10 @@
+begin;
+alter table user_filter rename unpaid to operation_filter;
+alter table user_filter alter column operation_filter type  text;
+update user_filter set operation_filter = 'paid' where operation_filter is not 
null;
+update user_filter set operation_filter = 'all' where operation_filter is  
null;
+comment on column user_filter.operation_filter is 'Status of the operation  : 
paid, unpaid or all operation';
+alter table user_filter alter operation_filter set not null;
+
+insert into version (val,v_description) values (141,'Search filter with 
operation status');
+commit ;