noalyss-commit
[Top][All Lists]
Advanced

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

[Noalyss-commit] [noalyss] 14/16: Add column timestamp for table TOOL_UO


From: dwm
Subject: [Noalyss-commit] [noalyss] 14/16: Add column timestamp for table TOOL_UOS
Date: Tue, 27 May 2025 09:26:10 -0400 (EDT)

sparkyx pushed a commit to branch unstable
in repository noalyss.

commit 4d29bb45fa966cf3508afdfbb9a35f872b4cc3d7
Author: sparkyx <danydb@noalyss.eu>
AuthorDate: Thu May 22 00:05:06 2025 +0200

    Add column timestamp for table TOOL_UOS
---
 sql/upgrade.sql | 4 +++-
 1 file changed, 3 insertions(+), 1 deletion(-)

diff --git a/sql/upgrade.sql b/sql/upgrade.sql
index c7f275742..df477a929 100644
--- a/sql/upgrade.sql
+++ b/sql/upgrade.sql
@@ -7,4 +7,6 @@ update parm_appearance set a_value='#506cb8 ' where 
a_code='MENU1-SELECTED' and
 ALTER TABLE public.todo_list ALTER COLUMN tl_date drop NOT NULL;
 
 
-update menu_ref set me_javascript='bookmark.show(<DOSSIER>)' where 
me_code='BOOKMARK';
\ No newline at end of file
+update menu_ref set me_javascript='bookmark.show(<DOSSIER>)' where 
me_code='BOOKMARK';
+
+alter table tool_uos add created_date timestamp default now();



reply via email to

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