DROP TABLE IF EXISTS urlcache;

CREATE TABLE urlcache
(
	url		CHAR(255)	NOT NULL,
	updateinterval	INT		NOT NULL,
	lastupdate	INT		NOT NULL,
	nextupdate	INT		NOT NULL,
	contentmd5	CHAR(32)	NOT NULL,
	content		TEXT		NOT NULL,

	PRIMARY KEY	(url),
	KEY		(nextupdate)
);