qrss-tools/qrss.sql

CREATE TABLE feeds (
  id integer primary key,
  text varchar,
  title varchar,
  description varchar,
  xmlUrl varchar,
  htmlUrl varchar,
  language varchar,
  copyrights varchar,
  author_name varchar,
  author_email varchar,
  author_uri varchar,
  webMaster varchar,
  pubdate varchar,
  lastBuildDate varchar,
  category varchar,
  contributor varchar,
  generator varchar,
  docs varchar,
  cloud_domain varchar,
  cloud_port varchar,
  cloud_path varchar,
  cloud_procedure varchar,
  cloud_protocal varchar,
  ttl integer,
  skipHours varchar,
  skipDays varchar,
  image blob,
  unread integer,
  newCount integer,
  currentNews integer,
  label varchar,
  undeleteCount integer,
  tags varchar,
  hasChildren integer default 0,
  parentId integer default 0,
  rowToParent integer,
  updateIntervalEnable int,
  updateInterval int,
  updateIntervalType varchar,
  updateOnStartup int,
  displayOnStartup int,
  markReadAfterSecondsEnable int,
  markReadAfterSeconds int,
  markReadInNewspaper int,
  markDisplayedOnSwitchingFeed int,
  markDisplayedOnClosingTab int,
  markDisplayedOnMinimize int,
  layout text,
  filter text,
  groupBy int,
  displayNews int,
  displayEmbeddedImages integer default 1,
  loadTypes text,
  openLinkOnEmptyContent int,
  columns text,
  sort text,
  sortType int,
  maximumToKeep int,
  maximumToKeepEnable int,
  maximumAgeOfNews int,
  maximumAgoOfNewEnable int,
  deleteReadNews int,
  neverDeleteUnreadNews int,
  neverDeleteStarredNews int,
  neverDeleteLabeledNews int,
  status text,
  created text,
  updated text,
  lastDisplayed text,
  f_Expanded integer default 1,
  flags text,
  authentication integer default 0,
  duplicateNewsMode integer default 0,
  typeFeed integer default 0,
  showNotification integer default 0,
  disableUpdate integer default 0,
  javaScriptEnable integer default 1,
  layoutDirection integer default 0
);

CREATE TABLE news (
  id integer primary key,
  feedId integer,
  guid varchar,
  guidislink varchar default 'true',
  description varchar,
  content varchar,
  title varchar,
  published varchar,
  modified varchar,
  received varchar,
  author_name varchar,
  author_uri varchar,
  author_email varchar,
  category varchar,
  label varchar,
  new integer default 1, -- actually "seen"
  read integer default 0, -- read/unread
  starred integer default 0,
  deleted integer default 0,
  attachment varchar,
  comments varchar,
  enclosure_length,
  enclosure_type,
  enclosure_url,
  source varchar,
  link_href varchar,
  link_enclosure varchar,
  link_related varchar,
  link_alternate varchar,
  contributor varchar,
  rights varchar,
  deleteDate varchar,
  feedParentId integer default 0
);