File: schema.mysql.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 (14 lines) | stat: -rw-r--r-- 565 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
 
-- Example MySQL schema
  CREATE TABLE `cached_feeds` (
    `id`              int(10) unsigned NOT NULL auto_increment,
    `href`            varchar(255) default NULL,
    `title`           varchar(255) default NULL,
    `link`            varchar(255) default NULL,
    `feed_data`       longtext default NULL,
    `feed_data_type`  varchar(20) default NULL,
    `http_headers`    text default NULL,
    `last_retrieved`  datetime default NULL,
    `time_to_live`    int(10) unsigned NULL,
    `serialized`       longtext default NULL,
    PRIMARY KEY  (`id`)
  )