4e5eba3fb9816a979ca3acbb82e23c5a6d582142 braney Wed Nov 30 14:40:52 2011 -0800 add the hubPublic and hubStatus autoSql definitions diff --git src/hg/lib/hubPublic.sql src/hg/lib/hubPublic.sql new file mode 100644 index 0000000..a2d5c9c --- /dev/null +++ src/hg/lib/hubPublic.sql @@ -0,0 +1,16 @@ +# hubPublic.sql was originally generated by the autoSql program, which also +# generated hubPublic.c and hubPublic.h. This creates the database representation of +# an object which can be loaded and saved from RAM in a fairly +# automatic way. + +#Table of public track data hub connections. +CREATE TABLE hubPublic ( + 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. + registrationTime varchar(255) not null, # Time first registered + dbCount int unsigned not null, # Number of databases hub has data for. + dbList varchar(255) not null, # Comma separated list of databases. + #Indices + PRIMARY KEY(hubUrl(255)) +);