This is an automated email from the ASF dual-hosted git repository.
aicam pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/texera.git
The following commit(s) were added to refs/heads/master by this push:
new 6d73a946ae chore: add time_log table to deployment/texera_ddl.sql
(#3671)
6d73a946ae is described below
commit 6d73a946ae792882d30121cbab55e3db5c91b0c4
Author: Jaeyun Kim <[email protected]>
AuthorDate: Mon Aug 18 06:53:42 2025 -0700
chore: add time_log table to deployment/texera_ddl.sql (#3671)
Since the texera_ddl.sql file under deployment did not have the time_log
table, this PR adds the SQL statement to the file. In addition, some
comments were added.
Closes #3624
---
core/scripts/sql/texera_ddl.sql | 1 +
deployment/k8s/texera-helmchart/files/texera_ddl.sql | 9 +++++++++
2 files changed, 10 insertions(+)
diff --git a/core/scripts/sql/texera_ddl.sql b/core/scripts/sql/texera_ddl.sql
index 62d531d7f4..7c6cf15c7c 100644
--- a/core/scripts/sql/texera_ddl.sql
+++ b/core/scripts/sql/texera_ddl.sql
@@ -350,6 +350,7 @@ CREATE TABLE IF NOT EXISTS site_settings
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
+-- time_log table
CREATE TABLE IF NOT EXISTS time_log
(
uid INT NOT NULL
diff --git a/deployment/k8s/texera-helmchart/files/texera_ddl.sql
b/deployment/k8s/texera-helmchart/files/texera_ddl.sql
index 0366adc4dd..d101eb527c 100644
--- a/deployment/k8s/texera-helmchart/files/texera_ddl.sql
+++ b/deployment/k8s/texera-helmchart/files/texera_ddl.sql
@@ -384,6 +384,15 @@ CREATE TABLE IF NOT EXISTS site_settings
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
+-- time_log table
+CREATE TABLE IF NOT EXISTS time_log
+(
+ uid INT NOT NULL
+ PRIMARY KEY
+ REFERENCES "user"(uid),
+ last_login TIMESTAMPTZ
+);
+
-- computing_unit_user_access table
CREATE TABLE IF NOT EXISTS computing_unit_user_access
(
