[Noalyss-commit] [noalyss] 194/323: Remove user_local_pref

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit 3609ac3107089c63b484967d2b9886a07072af7e
Author: Dany De Bontridder <address@hidden>
Date:   Sat Feb 10 22:53:09 2018 +0100

    Remove user_local_pref
---
 include/sql/mod1/data.sql | 4 ++--
 include/sql/mod1/make-sql | 3 +++
 include/sql/mod2/data.sql | 4 ++--
 include/sql/mod2/make-sql | 2 ++
 4 files changed, 9 insertions(+), 4 deletions(-)

diff --git a/include/sql/mod1/data.sql b/include/sql/mod1/data.sql
index d0e97cd..93ed724 100644
--- a/include/sql/mod1/data.sql
+++ b/include/sql/mod1/data.sql
@@ -2082,8 +2082,8 @@ SELECT 
pg_catalog.setval('user_sec_action_profile_ua_id_seq', 6, true);
 
 
 INSERT INTO version (val, v_description, v_date) VALUES (126, NULL, NULL);
-INSERT INTO version (val, v_description, v_date) VALUES (127, 'Add filter for 
search, inactive tag or ledger, type of operation, security', '2018-02-10 
22:35:44.080193');
-INSERT INTO version (val, v_description, v_date) VALUES (128, 'Add a view to 
manage VAT', '2018-02-10 22:35:45.034297');
+INSERT INTO version (val, v_description, v_date) VALUES (127, 'Add filter for 
search, inactive tag or ledger, type of operation, security', '2018-02-10 
22:46:38.653432');
+INSERT INTO version (val, v_description, v_date) VALUES (128, 'Add a view to 
manage VAT', '2018-02-10 22:46:39.22354');
 
 
 
diff --git a/include/sql/mod1/make-sql b/include/sql/mod1/make-sql
index fe91f0e..9f1c0a7 100755
--- a/include/sql/mod1/make-sql
+++ b/include/sql/mod1/make-sql
@@ -6,6 +6,9 @@
 
 export TEMPLATE=${DOMAIN}mod1
 
+psql -X $TEMPLATE -c "delete from user_local_pref"
+psql -X $TEMPLATE -c "delete from user_local_pref"
+
 pg_dump -O -U dany -s $TEMPLATE|grep -v "COMMENT ON SCHEMA public IS 'Standard 
public schema';" |sed "/^--/d" > schema.sql
 sed -i -e "/COMMENT ON EXTENSION/d" schema.sql
 sed -i -e "/CREATE EXTENSION/d" schema.sql
diff --git a/include/sql/mod2/data.sql b/include/sql/mod2/data.sql
index c46c6ad..9490052 100644
--- a/include/sql/mod2/data.sql
+++ b/include/sql/mod2/data.sql
@@ -1723,8 +1723,8 @@ SELECT 
pg_catalog.setval('user_sec_action_profile_ua_id_seq', 6, true);
 
 
 INSERT INTO version (val, v_description, v_date) VALUES (126, NULL, NULL);
-INSERT INTO version (val, v_description, v_date) VALUES (127, 'Add filter for 
search, inactive tag or ledger, type of operation, security', '2018-02-10 
22:35:58.431394');
-INSERT INTO version (val, v_description, v_date) VALUES (128, 'Add a view to 
manage VAT', '2018-02-10 22:35:59.308007');
+INSERT INTO version (val, v_description, v_date) VALUES (127, 'Add filter for 
search, inactive tag or ledger, type of operation, security', '2018-02-10 
22:46:49.270348');
+INSERT INTO version (val, v_description, v_date) VALUES (128, 'Add a view to 
manage VAT', '2018-02-10 22:46:49.93138');
 
 
 
diff --git a/include/sql/mod2/make-sql b/include/sql/mod2/make-sql
index aba1833..2ee7052 100755
--- a/include/sql/mod2/make-sql
+++ b/include/sql/mod2/make-sql
@@ -6,6 +6,8 @@
 
 export TEMPLATE=${DOMAIN}mod2
 
+psql -X $TEMPLATE -c "delete from user_local_pref"
+
 pg_dump -O -U dany -s $TEMPLATE|grep -v "COMMENT ON SCHEMA public IS 'Standard 
public schema';" |sed "/^--/d" > schema.sql
 sed -i -e "/COMMENT ON EXTENSION/d" schema.sql
 sed -i -e "/CREATE EXTENSION/d" schema.sql