diff options
| author | Mike Macgirvin <mike@macgirvin.com> | 2010-07-05 03:34:42 -0700 |
|---|---|---|
| committer | Mike Macgirvin <mike@macgirvin.com> | 2010-07-05 03:34:42 -0700 |
| commit | 9f7ae0e95f89b964a098eaacdfd89ff25e05c615 (patch) | |
| tree | 0bfe8d04f4b11abdbea41fe9bf6e165eec8ebc4b /simplepie/db.sql | |
| parent | f5826105bfc514599b2c5b6692bca14ca4bc5d78 (diff) | |
| download | volse-hubzilla-9f7ae0e95f89b964a098eaacdfd89ff25e05c615.tar.gz volse-hubzilla-9f7ae0e95f89b964a098eaacdfd89ff25e05c615.tar.bz2 volse-hubzilla-9f7ae0e95f89b964a098eaacdfd89ff25e05c615.zip | |
Add simplepie
Diffstat (limited to 'simplepie/db.sql')
| -rw-r--r-- | simplepie/db.sql | 38 |
1 files changed, 38 insertions, 0 deletions
diff --git a/simplepie/db.sql b/simplepie/db.sql new file mode 100644 index 000000000..13f504c21 --- /dev/null +++ b/simplepie/db.sql @@ -0,0 +1,38 @@ +/* SQLite */ +CREATE TABLE cache_data ( + id TEXT NOT NULL, + items SMALLINT NOT NULL DEFAULT 0, + data BLOB NOT NULL, + mtime INTEGER UNSIGNED NOT NULL +); +CREATE UNIQUE INDEX id ON cache_data(id); + +CREATE TABLE items ( + feed_id TEXT NOT NULL, + id TEXT NOT NULL, + data TEXT NOT NULL, + posted INTEGER UNSIGNED NOT NULL +); +CREATE INDEX feed_id ON items(feed_id); + + +/* MySQL */ +CREATE TABLE `cache_data` ( + `id` TEXT CHARACTER SET utf8 NOT NULL, + `items` SMALLINT NOT NULL DEFAULT 0, + `data` BLOB NOT NULL, + `mtime` INT UNSIGNED NOT NULL, + UNIQUE ( + `id`(125) + ) +); + +CREATE TABLE `items` ( + `feed_id` TEXT CHARACTER SET utf8 NOT NULL, + `id` TEXT CHARACTER SET utf8 NOT NULL, + `data` TEXT CHARACTER SET utf8 NOT NULL, + `posted` INT UNSIGNED NOT NULL, + INDEX `feed_id` ( + `feed_id`(125) + ) +);
\ No newline at end of file |