diff options
| author | Christian Schneider | 2006-10-26 13:35:12 +0000 |
|---|---|---|
| committer | Christian Schneider | 2006-10-26 13:35:12 +0000 |
| commit | a5a19fd672bc0b8113d620669b557f17dccd343a (patch) | |
| tree | 876ba4fec8362ac2e9374f61b9b7f67fcd2b8e59 /urlcache/urlcache.sql | |
| download | itools-a5a19fd672bc0b8113d620669b557f17dccd343a.tar.gz itools-a5a19fd672bc0b8113d620669b557f17dccd343a.tar.bz2 itools-a5a19fd672bc0b8113d620669b557f17dccd343a.zip | |
Moved itools to live branch
Diffstat (limited to 'urlcache/urlcache.sql')
| -rw-r--r-- | urlcache/urlcache.sql | 14 |
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) +); |