diff options
| author | Friendika <info@friendika.com> | 2011-06-28 21:11:52 -0700 |
|---|---|---|
| committer | Friendika <info@friendika.com> | 2011-06-28 21:11:52 -0700 |
| commit | 0b221e8945ae785dc706d8ea9a9e8e25532c0096 (patch) | |
| tree | 52d4978006b028c24ee1feb3cf6ba2907a48c88f /simplepie/db.sql | |
| parent | 60caa0349416dad1a3a891e3c0e00d33d25d7a91 (diff) | |
| download | volse-hubzilla-0b221e8945ae785dc706d8ea9a9e8e25532c0096.tar.gz volse-hubzilla-0b221e8945ae785dc706d8ea9a9e8e25532c0096.tar.bz2 volse-hubzilla-0b221e8945ae785dc706d8ea9a9e8e25532c0096.zip | |
bug #96 move libraries to library - better alignment of like rotator
Diffstat (limited to 'simplepie/db.sql')
| -rw-r--r-- | simplepie/db.sql | 38 |
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 |