File: schema.sqlite.sql

package info (click to toggle)
ruby-feedtools 0.2.29%2Bdfsg1-5
  • links: PTS, VCS
  • area: main
  • in suites: wheezy
  • size: 2,008 kB
  • sloc: ruby: 18,815; sql: 39; makefile: 13
file content (13 lines) | stat: -rw-r--r-- 518 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
8
9
10
11
12
13
 
-- Example Sqlite schema
  CREATE TABLE cached_feeds (
    id                INTEGER PRIMARY KEY NOT NULL,
    href              VARCHAR(255) DEFAULT NULL,
    title             VARCHAR(255) DEFAULT NULL,
    link              VARCHAR(255) DEFAULT NULL,
    feed_data         TEXT DEFAULT NULL,
    feed_data_type    VARCHAR(20) DEFAULT NULL,
    http_headers      TEXT DEFAULT NULL,
    last_retrieved    DATETIME DEFAULT NULL,
    time_to_live      INTEGER DEFAULT NULL,
    serialized        TEXT DEFAULT NULL
  );