[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

From: Dany De Bontridder
Subject: [Noalyss-commit] [noalyss] 01/04: add forgotten file
Date: Sun, 1 Dec 2019 16:12:57 -0500 (EST)

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 @@
+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 
+update user_filter set operation_filter = 'all' where operation_filter is  
+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 ;

reply via email to

[Prev in Thread] Current Thread [Next in Thread]