60a1ffe088a649ec6910b3e8af830f00e36a8626 braney Wed Aug 28 12:48:25 2013 -0700 change dbList in hubStatus to be a blob instead of a varchar(255) diff --git src/hg/lib/hubStatus.sql src/hg/lib/hubStatus.sql index d9d474b..7d29e77 100644 --- src/hg/lib/hubStatus.sql +++ src/hg/lib/hubStatus.sql @@ -1,21 +1,21 @@ # hubStatus.sql was originally generated by the autoSql program, which also # generated hubStatus.c and hubStatus.h. This creates the database representation of # an object which can be loaded and saved from RAM in a fairly # automatic way. #Table of track data hub connection status. CREATE TABLE hubStatus ( id int unsigned not null auto_increment, # Auto-incrementing hub ID hubUrl longblob not null, # URL to hub.ra file shortLabel varchar(255) not null, # Hub short label. longLabel varchar(255) not null, # Hub long label. dbCount int unsigned not null, # Number of databases hub has data for. - dbList varchar(255) not null, # Comma separated list of databases. + dbList longblob not null, # Comma separated list of databases. status int unsigned not null, # 1 if private lastOkTime varchar(255) not null, # Time when hub last was ok lastNotOkTime varchar(255) not null, # Time when hub last was not ok errorMessage longblob not null, # If non-empty contains last error message from hub. If empty hub is ok. firstAdded varchar(255) not null, # Time when hub was first added #Indices PRIMARY KEY(id) );