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, 0 insertions, 38 deletions
diff --git a/simplepie/db.sql b/simplepie/db.sql
deleted file mode 100644
index 13f504c21..000000000
--- a/simplepie/db.sql
+++ /dev/null
@@ -1,38 +0,0 @@
-/* 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