[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;
- [Noalyss-commit] [noalyss] 08/34: Fix : the select range select also the hidden element, (continued)
- [Noalyss-commit] [noalyss] 08/34: Fix : the select range select also the hidden element, Dany De Bontridder, 2023/02/05
- [Noalyss-commit] [noalyss] 02/34: Fix bug : return void, Dany De Bontridder, 2023/02/05
- [Noalyss-commit] [noalyss] 16/34: Documentation, Dany De Bontridder, 2023/02/05
- [Noalyss-commit] [noalyss] 14/34: Improve security : replace $_POST by Http_Input, Dany De Bontridder, 2023/02/05
- [Noalyss-commit] [noalyss] 24/34: Bug #0002231: "Payée par" - date non prise en compte, Dany De Bontridder, 2023/02/05
- [Noalyss-commit] [noalyss] 29/34: Bug #0002219: Compatibilité PHP 8.2 , 8.1 , 8.0, Dany De Bontridder, 2023/02/05
- [Noalyss-commit] [noalyss] 31/34: Merge branch 'master' into devel, Dany De Bontridder, 2023/02/05
- [Noalyss-commit] [noalyss] 32/34: Cosmetic #0002204: CA : balance croisée double - affichage brouillon, Dany De Bontridder, 2023/02/05
- [Noalyss-commit] [noalyss] 18/34: Cosmetic : improve CSS for enrich text, Dany De Bontridder, 2023/02/05
- [Noalyss-commit] [noalyss] 25/34: Merge branch 'devel', Dany De Bontridder, 2023/02/05
- [Noalyss-commit] [noalyss] 22/34: improve code : sql : document table action_gestion,
Dany De Bontridder <=
- [Noalyss-commit] [noalyss] 23/34: Documentation ManageTable.js, Dany De Bontridder, 2023/02/05
- [Noalyss-commit] [noalyss] 30/34: Bug #0002219: Compatibilité PHP 8.2 , 8.1 , 8.0, Dany De Bontridder, 2023/02/05
- [Noalyss-commit] [noalyss] 33/34: Minimum PHP 7.4, Dany De Bontridder, 2023/02/05
- [Noalyss-commit] [noalyss] 20/34: Fix : if there is no stock there is an exception instead of a warning, Dany De Bontridder, 2023/02/05
- [Noalyss-commit] [noalyss] 27/34: Bug #0002206: CA - impossible de supprimer un poste analytique, Dany De Bontridder, 2023/02/05
- [Noalyss-commit] [noalyss] 11/34: NEW #0002205 Mode maintenance, Dany De Bontridder, 2023/02/05
- [Noalyss-commit] [noalyss] 12/34: Fix : generate_random_string returns always same value , due to a change in srand(), Dany De Bontridder, 2023/02/05
- [Noalyss-commit] [noalyss] 19/34: Documentation, Dany De Bontridder, 2023/02/05
- [Noalyss-commit] [noalyss] 34/34: esthetic and doc, Dany De Bontridder, 2023/02/05