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/userDb.sql src/hg/lib/userDb.sql new file mode 100644 index 0000000..12e22ae --- /dev/null +++ src/hg/lib/userDb.sql @@ -0,0 +1,17 @@ +# userDb.sql was originally generated by the autoSql program, which also +# generated userDb.c and userDb.h. This creates the database representation of +# an object which can be loaded and saved from RAM in a fairly +# automatic way. + +#User Database +CREATE TABLE userDb ( + 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;