This is an automated email from the ASF dual-hosted git repository.
mxmanghi pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/tcl-rivet.git
The following commit(s) were added to refs/heads/master by this push:
new ed65a45 make session cache table columns larger
ed65a45 is described below
commit ed65a45774ebf86c604b5f8e96e1872265ceabdc
Author: Massimo Manghi <mxman...@apache.org>
AuthorDate: Mon Sep 6 18:43:39 2021 +0200
make session cache table columns larger
---
ChangeLog | 5 ++++-
rivet/packages/session/session-class.tcl | 3 +--
rivet/packages/session/session-create-mysql.sql | 6 +++---
rivet/packages/session/session-create-oracle.sql | 12 ++++++------
rivet/packages/session/session-create-sqlite.sql | 6 +++---
5 files changed, 17 insertions(+), 15 deletions(-)
diff --git a/ChangeLog b/ChangeLog
index 0858970..3934540 100644
--- a/ChangeLog
+++ b/ChangeLog
@@ -1,3 +1,6 @@
+2021-09-06 Massimo Manghi <mxman...@apache.org>
+ * rivet/packages/session/session-create-*.sql: making cache fields larger
+
2021-07-30 Massimo Manghi <mxman...@apache.org>
* src/mod_rivet_ng/TclWebapache.c: integrating the current scant Tcl error
info
returned by the various ::rivet::upload subcommands
@@ -15,7 +18,7 @@
2020-11-19 Massimo Manghi <mxman...@apache.org>
* rivet/packages/dio/dio.tcl,dio_Mysql.tcl: adding support for
connector specific client arguments
- * rivet/packages/form/form22.tcl: New from 2.2 package can be
+ * rivet/packages/form/form22.tcl: New form 2.2 package can be
configured to return HTML code instead of printing it to stdout
2020-11-02 Massimo Manghi <mxman...@apache.org>
diff --git a/rivet/packages/session/session-class.tcl
b/rivet/packages/session/session-class.tcl
index abc62fa..28fb3e1 100644
--- a/rivet/packages/session/session-class.tcl
+++ b/rivet/packages/session/session-class.tcl
@@ -1,7 +1,6 @@
#
# Session - Itcl object for web session management for Rivet
#
-# $Id$
#
# Copyright 2004 The Apache Software Foundation
@@ -476,7 +475,7 @@ package require Itcl
}
#
- # is_new_sesion - return a 1 if it's a new session, else a zero if there
+ # is_new_session - return a 1 if it's a new session, else a zero if there
# were one or more prior pages creating and/or using this session ID
#
method is_new_session {} {
diff --git a/rivet/packages/session/session-create-mysql.sql
b/rivet/packages/session/session-create-mysql.sql
index 0e79087..93fae67 100644
--- a/rivet/packages/session/session-create-mysql.sql
+++ b/rivet/packages/session/session-create-mysql.sql
@@ -18,9 +18,9 @@ create table rivet_session (
DROP TABLE IF EXISTS `rivet_session_cache`;
create table rivet_session_cache(
session_id varchar(128) default NULL,
- package_ varchar(64) default NULL,
- key_ varchar(128) default NULL,
- data varchar(255) default NULL,
+ package_ varchar(128) default NULL,
+ key_ varchar(256) default NULL,
+ data varchar(4096) default NULL,
UNIQUE KEY riv_sess_cache_ix( session_id, package_, key_ ),
KEY rivet_session_cache_idx (session_id),
diff --git a/rivet/packages/session/session-create-oracle.sql
b/rivet/packages/session/session-create-oracle.sql
index ad4b0d9..4d5b1b1 100644
--- a/rivet/packages/session/session-create-oracle.sql
+++ b/rivet/packages/session/session-create-oracle.sql
@@ -4,10 +4,10 @@
-- Arnulf
--
CREATE TABLE rivet_session
- (ip_address VARCHAR2(23) DEFAULT NULL,
+ (ip_address VARCHAR2(23) DEFAULT NULL,
session_start_time DATE DEFAULT NULL,
session_update_time DATE DEFAULT NULL,
- session_id VARCHAR2(50) NOT NULL
+ session_id VARCHAR2(64) NOT NULL
)
/
@@ -16,10 +16,10 @@ ALTER TABLE rivet_session ADD PRIMARY KEY (session_id)
/
CREATE TABLE rivet_session_cache
- (session_id VARCHAR2(50) DEFAULT NULL,
- package_ VARCHAR2(100) DEFAULT NULL,
- key_ VARCHAR2(50) DEFAULT NULL,
- data VARCHAR2(255) DEFAULT NULL
+ (session_id VARCHAR2(128) DEFAULT NULL,
+ package_ VARCHAR2(128) DEFAULT NULL,
+ key_ VARCHAR2(256) DEFAULT NULL,
+ data VARCHAR2(4096) DEFAULT NULL
)
/
diff --git a/rivet/packages/session/session-create-sqlite.sql
b/rivet/packages/session/session-create-sqlite.sql
index 36b1a3d..868cbce 100644
--- a/rivet/packages/session/session-create-sqlite.sql
+++ b/rivet/packages/session/session-create-sqlite.sql
@@ -7,9 +7,9 @@ CREATE TABLE rivet_session (
);
CREATE TABLE rivet_session_cache (
session_id varchar(128) default NULL PRIMARY KEY ON CONFLICT FAIL,
- package_ varchar(64) default NULL,
- key_ varchar(128) default NULL,
- data varchar(255) default NULL,
+ package_ varchar(128) default NULL,
+ key_ varchar(256) default NULL,
+ data varchar(4096) default NULL,
-- KEY rivet_session_cache_idx (session_id),
CONSTRAINT session_cleanup FOREIGN KEY (session_id) REFERENCES
rivet_session(session_id) ON DELETE CASCADE
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@tcl.apache.org
For additional commands, e-mail: commits-h...@tcl.apache.org
