sql.txt

来自「ajax快速入门,主要讲解原理与部门实现」· 文本 代码 · 共 22 行

CREATE TABLE opml (
  ID int(11) NOT NULL auto_increment,
  Title varchar(255) NOT NULL,
  HtmlUrl varchar(255),
  Type varchar(255),
  XmlUrl varchar(255),
  LastDateTime varchar(19),
  PRIMARY KEY  (ID)
) TYPE=InnoDB;

CREATE TABLE rss (
  ID int(11) NOT NULL auto_increment,
  OpmlID int(11) NOT NULL,
  Title varchar(255) NOT NULL,
  Link varchar(255),
  Author varchar(255),
  PubDate varchar(255),
  Description text,
  PRIMARY KEY  (ID),
  KEY OpmlID (OpmlID),
  FOREIGN KEY (OpmlID) REFERENCES opml (ID) ON DELETE CASCADE ON UPDATE CASCADE
) TYPE=InnoDB;