File: schema.postgresql.sql

package info (click to toggle)
libfeedtools-ruby 0.2.29%2Bdfsg1-4
  • links: PTS, VCS
  • area: main
  • in suites: squeeze
  • size: 2,004 kB
  • ctags: 1,385
  • sloc: ruby: 18,815; sql: 39; makefile: 6
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
  );