You are viewing a plain text version of this content. The canonical link for it is here.
Posted to rivet-dev@tcl.apache.org by mx...@apache.org on 2012/10/29 14:34:53 UTC
svn commit: r1403284 - in /tcl/rivet/trunk: ChangeLog
rivet/packages/session/session-create-mysql.sql
rivet/packages/session/session-create-sqlite.sql
Author: mxmanghi
Date: Mon Oct 29 13:34:52 2012
New Revision: 1403284
URL: http://svn.apache.org/viewvc?rev=1403284&view=rev
Log:
* rivet/packages/session/[session-create-mysql.sql|session-create-sqlite.sql]: index
riv_sess_cache_ix had a incomplete unique key definition that missed the 'package_' column (fixes bug #54063)
Modified:
tcl/rivet/trunk/ChangeLog
tcl/rivet/trunk/rivet/packages/session/session-create-mysql.sql
tcl/rivet/trunk/rivet/packages/session/session-create-sqlite.sql
Modified: tcl/rivet/trunk/ChangeLog
URL: http://svn.apache.org/viewvc/tcl/rivet/trunk/ChangeLog?rev=1403284&r1=1403283&r2=1403284&view=diff
==============================================================================
--- tcl/rivet/trunk/ChangeLog (original)
+++ tcl/rivet/trunk/ChangeLog Mon Oct 29 13:34:52 2012
@@ -1,3 +1,7 @@
+2012-10-29 Massimo Manghi <mx...@apache.org>
+ * rivet/packages/session/[session-create-mysql.sql|session-create-sqlite.sql]: index
+ riv_sess_cache_ix had a incomplete unique key definition that missed the 'package_' column (fixes bug #54063)
+
2012-10-28 Massimo Manghi <mx...@apache.org>
* doc/xml/commands.xml: Manual entry for makeurl extented to clarify how the
protocol is determined.
Modified: tcl/rivet/trunk/rivet/packages/session/session-create-mysql.sql
URL: http://svn.apache.org/viewvc/tcl/rivet/trunk/rivet/packages/session/session-create-mysql.sql?rev=1403284&r1=1403283&r2=1403284&view=diff
==============================================================================
--- tcl/rivet/trunk/rivet/packages/session/session-create-mysql.sql (original)
+++ tcl/rivet/trunk/rivet/packages/session/session-create-mysql.sql Mon Oct 29 13:34:52 2012
@@ -8,21 +8,21 @@
DROP TABLE IF EXISTS `rivet_session`;
create table rivet_session (
- ip_address varchar(16) default NULL,
- session_start_time datetime default NULL,
- session_update_time datetime default NULL,
- session_id varchar(64) NOT NULL default '',
- PRIMARY KEY (session_id)
+ ip_address varchar(16) default NULL,
+ session_start_time datetime default NULL,
+ session_update_time datetime default NULL,
+ session_id varchar(64) NOT NULL default '',
+ PRIMARY KEY (session_id)
) ENGINE=INNODB;
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,
+ session_id varchar(128) default NULL,
+ package_ varchar(64) default NULL,
+ key_ varchar(128) default NULL,
+ data varchar(255) default NULL,
- UNIQUE KEY riv_sess_cache_ix( session_id, key_ ),
+ UNIQUE KEY riv_sess_cache_ix( session_id, package_, key_ ),
KEY rivet_session_cache_idx (session_id),
FOREIGN KEY (session_id) REFERENCES rivet_session(session_id) ON DELETE CASCADE
) ENGINE=INNODB;
Modified: tcl/rivet/trunk/rivet/packages/session/session-create-sqlite.sql
URL: http://svn.apache.org/viewvc/tcl/rivet/trunk/rivet/packages/session/session-create-sqlite.sql?rev=1403284&r1=1403283&r2=1403284&view=diff
==============================================================================
--- tcl/rivet/trunk/rivet/packages/session/session-create-sqlite.sql (original)
+++ tcl/rivet/trunk/rivet/packages/session/session-create-sqlite.sql Mon Oct 29 13:34:52 2012
@@ -14,4 +14,4 @@ CREATE TABLE rivet_session_cache (
-- KEY rivet_session_cache_idx (session_id),
CONSTRAINT session_cleanup FOREIGN KEY (session_id) REFERENCES rivet_session(session_id) ON DELETE CASCADE
);
-CREATE UNIQUE INDEX rvt_sess_cache_idx ON rivet_session_cache ( session_id, key_ );
+CREATE UNIQUE INDEX rvt_sess_cache_idx ON rivet_session_cache ( session_id, package_, key_ );
---------------------------------------------------------------------
To unsubscribe, e-mail: rivet-cvs-unsubscribe@tcl.apache.org
For additional commands, e-mail: rivet-cvs-help@tcl.apache.org