1d8785d66ed85fd0bff3ed301a7cd5a7692265c4 braney Wed Apr 8 13:05:43 2015 -0700 allow for different names for the sessionDb and userDb tables diff --git src/hg/lib/sessionDb.sql src/hg/lib/sessionDb.sql new file mode 100644 index 0000000..4f4676e --- /dev/null +++ src/hg/lib/sessionDb.sql @@ -0,0 +1,17 @@ +# sessionDb.sql was originally generated by the autoSql program, which also +# generated sessionDb.c and sessionDb.h. This creates the database representation of +# an object which can be loaded and saved from RAM in a fairly +# automatic way. + +#Session Database +CREATE TABLE sessionDb ( + id int(10) unsigned not null auto_increment, # auto-increment item ID + contents longblob not null, # encoded variables */ + reserved tinyint(4) not null, # currently always zero + firstUse datetime not null, # first time this was used + lastUse datetime not null, # last time this was used + useCount int(11) unsigned not null, # number of times used + sessionKey varchar(255) not null, # random key for session security + #Indices + PRIMARY KEY(id) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 MAX_ROWS=10000000 AVG_ROW_LENGTH=8655 PACK_KEYS=1;