aboutsummaryrefslogtreecommitdiffstats
path: root/simplepie/db.sql
diff options
context:
space:
mode:
Diffstat (limited to 'simplepie/db.sql')
-rw-r--r--simplepie/db.sql38
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