noalyss-commit
[Top][All Lists]
Advanced

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

[Noalyss-commit] [noalyss] 22/34: improve code : sql : document table ac


From: Dany De Bontridder
Subject: [Noalyss-commit] [noalyss] 22/34: improve code : sql : document table action_gestion
Date: Sun, 5 Feb 2023 04:41:42 -0500 (EST)

sparkyx pushed a commit to branch devel
in repository noalyss.

commit f00d5f8d515883dac6fe4bac88df9e5af7eb3a67
Author: sparkyx <danydb@noalyss.eu>
AuthorDate: Wed Jan 25 15:49:50 2023 +0100

    improve code : sql : document table action_gestion
---
 include/constant.php             |  2 +-
 include/sql/patch/upgrade183.sql | 13 +++++++++++++
 2 files changed, 14 insertions(+), 1 deletion(-)

diff --git a/include/constant.php b/include/constant.php
index 9b1e7bd4a..6cc75512c 100644
--- a/include/constant.php
+++ b/include/constant.php
@@ -116,7 +116,7 @@ if (!defined("NOALYSS_PACKAGE_REPOSITORY")) {
 if (!defined("SYSINFO_DISPLAY")) {
     define("SYSINFO_DISPLAY", TRUE);
 }
-define("DBVERSION", 183);
+define("DBVERSION", 184);
 define("MONO_DATABASE", 25);
 define("DBVERSIONREPO", 20);
 define('NOTFOUND', '--not found--');
diff --git a/include/sql/patch/upgrade183.sql b/include/sql/patch/upgrade183.sql
new file mode 100644
index 000000000..59a899c93
--- /dev/null
+++ b/include/sql/patch/upgrade183.sql
@@ -0,0 +1,13 @@
+begin;
+COMMENT ON COLUMN public.action_gestion.f_id_dest IS 'third party';
+COMMENT ON COLUMN public.action_gestion.ag_priority IS 'Low, medium, 
important';
+COMMENT ON COLUMN public.action_gestion.ag_dest IS 'is the profile which has 
to take care of this action';
+COMMENT ON COLUMN public.action_gestion.ag_owner IS 'is the owner of this 
action';
+COMMENT ON COLUMN public.action_gestion.ag_contact IS 'contact of the third 
part';
+COMMENT ON COLUMN public.action_gestion.ag_title IS 'title';
+COMMENT ON COLUMN public.action_gestion.ag_timestamp IS '';
+COMMENT ON COLUMN public.action_gestion.ag_ref IS 'its reference';
+COMMENT ON COLUMN public.action_gestion.ag_state IS 'state of the action same 
as document_state';
+
+insert into version (val,v_description) values (184,'document table 
action_gestion');
+commit;



reply via email to

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