db.sql

来自「征服 Web2.0 快速入门(Java) 光盘源码」· SQL 代码 · 共 14 行

DROP TABLE IF EXISTS RSS;
CREATE TABLE  RSS (
  RSS_ID int(16) NOT NULL auto_increment,
  RSS_URL varchar(255) NOT NULL default '',
  RSS_LABEL varchar(255) NOT NULL default '',
  ACTIVE_STATUS varchar(4) NOT NULL default 'Y',
  PRIMARY KEY  (RSS_ID)
) TYPE=MyISAM ;

INSERT INTO RSS VALUES(1,'http://rss.sina.com.cn/news/allnews/sports.xml','Sports','Y');
INSERT INTO RSS VALUES(2,'http://rss.sina.com.cn/news/allnews/tech.xml','Technology','Y');
INSERT INTO RSS VALUES(3,'http://rss.sina.com.cn/news/allnews/finance.xml','Finance','Y');
INSERT INTO RSS VALUES(4,'http://rss.sina.com.cn/news/allnews/eladies.xml','Ladies','Y');
INSERT INTO RSS VALUES(5,'http://rss.sina.com.cn/news/allnews/ent.xml','Entertaiment','Y');