/*
 * A table for saving hostlist entries, selection counts, and etc.
 */

create sequence link_counter ;

create table hotlist (
	id		int not null ,		// The index counter
	count		int default 0 ,		// and the click counter
	added		datetime ,		// when it was added
	followed	datetime ,		// last time it was followed
	checked		datetime ,		// last time it was verified
	description	text ,			// What the link is to
	URL		text ,			// And how to get there
	primary key (id)
	) ;