4cffc3eb6f43e109452b5b52d1f760cf1ea6a981 jcasper Sun Jun 7 21:47:37 2026 -0700 Adjusting sessionDb and userDb IDs to be 64-bit in the code, since the database is now ready for it and we're crossing the threshold. refs #33554 diff --git src/hg/lib/cartDb.sql src/hg/lib/cartDb.sql index 4f92b53a963..3e7bd2b5d79 100644 --- src/hg/lib/cartDb.sql +++ src/hg/lib/cartDb.sql @@ -1,29 +1,29 @@ # cartDb.sql was originally generated by the autoSql program, which also # generated cartDb.c and cartDb.h. This creates the database representation of # an object which can be loaded and saved from RAM in a fairly # automatic way. #A simple id/contents pair for persistent storing of cart variables CREATE TABLE userDb ( - id integer unsigned not null auto_increment, # Cart ID + id bigint unsigned not null auto_increment, # Cart ID contents longblob not null, # Contents - encoded variables reserved tinyint not null, # True if a user (rather than session) cart firstUse DATETIME not null, # First time this was used lastUse DATETIME not null, # Last time this was used useCount int not null, # Number of times used sessionKey varchar(255) NOT NULL DEFAULT '', # Random key to protect session ids #Indices PRIMARY KEY(id) ); CREATE TABLE sessionDb ( - id integer unsigned not null auto_increment, # Cart ID + id bigint unsigned not null auto_increment, # Cart ID contents longblob not null, # Contents - encoded variables reserved tinyint not null, # True if a user (rather than session) cart firstUse DATETIME not null, # First time this was used lastUse DATETIME not null, # Last time this was used useCount int not null, # Number of times used sessionKey varchar(255) NOT NULL DEFAULT '', # Random key to protect session ids #Indices PRIMARY KEY(id) );