1 files changed, 14 insertions, 0 deletions
diff --git a/urlcache/urlcache.sql b/urlcache/urlcache.sql
new file mode 100644
index 0000000..fcf8659
--- /dev/null
+++ b/urlcache/urlcache.sql
@@ -0,0 +1,14 @@
+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)
+);