[Noalyss-commit] [noalyss] 08/10: Task #0001904: Previsions et budgets rewriting of forecast : missing SQL files

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit 3db26be289555dd5127f0a86212d4fbf77633251
Author: sparkyx <danydb@noalyss.eu>
AuthorDate: Thu Mar 25 17:48:10 2021 +0100

    Task #0001904: Previsions et budgets
    rewriting of forecast : missing SQL files
---
 include/constant.php                                | 2 +-
 sql/upgrade.sql => include/sql/patch/upgrade153.sql | 3 +++
 sql/upgrade.sql                                     | 2 --
 3 files changed, 4 insertions(+), 3 deletions(-)

diff --git a/include/constant.php b/include/constant.php
index 672e3de..0202670 100644
--- a/include/constant.php
+++ b/include/constant.php
@@ -110,7 +110,7 @@ if ( !defined ("NOALYSS_PACKAGE_REPOSITORY")) {
 if ( ! defined ("SYSINFO_DISPLAY")) {
     define ("SYSINFO_DISPLAY",TRUE);
 }
-define ("DBVERSION",153);
+define ("DBVERSION",154);
 define ("MONO_DATABASE",25);
 define ("DBVERSIONREPO",19);
 define ('NOTFOUND','--not found--');
diff --git a/sql/upgrade.sql b/include/sql/patch/upgrade153.sql
similarity index 54%
copy from sql/upgrade.sql
copy to include/sql/patch/upgrade153.sql
index fc4f704..03a2766 100644
--- a/sql/upgrade.sql
+++ b/include/sql/patch/upgrade153.sql
@@ -1,2 +1,5 @@
+begin ;
 alter table forecast_cat rename to forecast_category;
 alter table forecast_category  alter f_id set not null;
+insert into version (val,v_description) values (154,'Rewriting of FORECAST');
+commit;
\ No newline at end of file
diff --git a/sql/upgrade.sql b/sql/upgrade.sql
index fc4f704..e69de29 100644
--- a/sql/upgrade.sql
+++ b/sql/upgrade.sql
@@ -1,2 +0,0 @@
-alter table forecast_cat rename to forecast_category;
-alter table forecast_category  alter f_id set not null;