File: schema.postgresql.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-- 526 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
8
9
10
11
12
13
 
-- Example PostgreSQL schema
  CREATE TABLE cached_feeds (
    id                SERIAL 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    timestamp default NULL,
    time_to_live      integer(10) default NULL,
    serialized        text default NULL
  );