+ забыл SQL

Sanja v.2 06.02.2004 16:41 / 06.02.2004 16:49

#
#
# Структура таблицы `cityblog_rssitems`
#
# Creation: Окт 28 2003 г., 09:41
# Last update: Янв 30 2004 г., 17:36
# Last check: Янв 30 2004 г., 04:38
#

DROP TABLE IF EXISTS `cityblog_rssitems`;
CREATE TABLE `cityblog_rssitems` (
  `id` int(16) unsigned NOT NULL auto_increment,
  `feed_id` varchar(255) NOT NULL default '',
  `title` text,
  `link` varchar(255) NOT NULL default '/',
  `description` text NOT NULL,
  `pubdate` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`),
  KEY `id_2` (`id`)
) TYPE=MyISAM COMMENT='Items from RSS feeds' AUTO_INCREMENT=10896 ;

#
# Структура таблицы `cityblog_rsslist`
#
# Creation: Дек 03 2003 г., 15:36
# Last update: Янв 30 2004 г., 17:37
# Last check: Янв 30 2004 г., 04:38
#

DROP TABLE IF EXISTS `cityblog_rsslist`;
CREATE TABLE `cityblog_rsslist` (
  `uri` varchar(255) NOT NULL default '',
  `name` varchar(255) default NULL,
  `last_update` datetime NOT NULL default '0000-00-00 00:00:00',
  `is_enabled` enum('yes','no') NOT NULL default 'no',
  `min_refresh_period` tinyint(3) unsigned NOT NULL default '1',
  `hours_to_keep` int(16) unsigned NOT NULL default '24000',
  `allow_untaint` enum('yes','no') default 'no',
  PRIMARY KEY  (`uri`),
  UNIQUE KEY `uri` (`uri`),
  KEY `uri_2` (`uri`)
) TYPE=MyISAM COMMENT='RSS feeds to fetch';

#
# Дамп данных таблицы `cityblog_rsslist`
#

INSERT INTO `cityblog_rsslist` VALUES ('http://forum.gfk.ru/forum/rss.html', 'Forum.GfK.ru', '2002-01-21 16:29:31', 'no', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.parser.ru/_rss.html', 'Parser.ru Forum', '2004-01-30 17:03:16', 'yes', 1, 24000, 'no');
INSERT INTO `cityblog_rsslist` VALUES ('http://register.spectator.ru/txt/export.xml', 'Spectator.ru', '2004-01-30 16:45:05', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://p.moreover.com/cgi-local/page?index_marketing+rss', 'Moreover.com - Marketing', '2002-01-21 16:29:31', 'no', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.theregister.co.uk/tonys/slashdot.rdf', 'The Register', '2004-01-30 17:24:03', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.joelonsoftware.com/rss.xml', 'Joel On Software', '2004-01-30 17:36:29', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://jeremy.zawodny.com/blog/rss2.xml', 'Jeremy Zawodny', '2004-01-30 16:54:16', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.compulenta.ru/rss.xml', 'Компьюлента', '2002-01-21 16:29:31', 'no', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://blogs.gotdotnet.com/raymondc/blogxbrowsing.asmx/GetRss?', 'Got .NET', '2004-01-09 17:23:58', 'no', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.livejournal.com/users/avva/data/rss', 'Avva\'s LJ', '2004-01-30 17:03:13', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.livejournal.com/users/egoroff/data/rss', 'Egr\'s LJ', '2004-01-30 17:36:58', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.livejournal.com/community/ru_kitchen/data/rss', 'RU_KITCHEN\'s LJ', '2004-01-30 17:36:39', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.dashes.com/links/index.rdf', 'Anil\'s daily links', '2004-01-30 17:27:02', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.diveintomark.org/xml/blink.xml', 'Mark Pilgrim\'s links', '2004-01-30 17:03:30', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://partners.userland.com/nytRss/business.xml', 'NY Times: Business', '2002-01-21 16:29:31', 'no', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.scripting.com/rss.xml', 'ScriptingNews', '2004-01-30 17:12:03', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://mena.typepad.com/dollarshort/index.rdf', 'Not a dollar short', '2004-01-30 17:36:54', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.kuro5hin.org/backend.rdf', 'Kuro5hin', '2004-01-30 17:36:28', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.livejournal.com/community/msk_consumer/data/rss', 'MSK_CONSUMER', '2004-01-30 17:36:13', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.livejournal.com/community/6ap/data/rss/', 'LJ Бар comunity', '2004-01-30 16:42:09', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.livejournal.com/community/hse/data/rss', 'LJ HSE students comunity', '2004-01-30 17:03:24', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.livejournal.com/community/otdam_darom/data/rss/', 'LJ Otdam_darom comunity', '2004-01-30 17:00:18', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.livejournal.com/community/potrebitel/data/rss', 'LJ Potrebitel comunity', '2004-01-30 16:54:03', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.livejournal.com/community/ru_anecdote/data/rss', 'LJ ru_anecdote comunity', '2004-01-30 17:03:21', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.livejournal.com/community/avto_ru/data/rss', 'LJ avto_ru comunity', '2004-01-30 16:54:06', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.livejournal.com/community/ru_spam/data/rss', 'LJ ru_spam comunity', '2004-01-30 17:36:44', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.livejournal.com/community/ru_fitness/data/rss', 'LJ ru_fitness comunity', '2004-01-20 16:17:51', 'no', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.livejournal.com/community/ru_market/data/rss', 'LJ ru_market comunity', '2004-01-30 16:42:14', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.livejournal.com/community/ru_marketing/data/rss', 'LJ ru_marketing comunity', '2004-01-30 17:36:23', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.livejournal.com/community/ru_mobile/data/rss', 'LJ ru_mobile comunity', '2004-01-30 17:36:19', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.livejournal.com/community/ru_management/data/rss', 'LJ ru_management comunity', '2004-01-30 17:36:26', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.livejournal.com/community/ru_money/data/rss', 'LJ ru_money comunity', '2004-01-30 17:36:07', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.livejournal.com/community/yahoo_eu/data/rss', 'LJ Yahoo_eu comunity', '2004-01-30 16:42:04', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.livejournal.com/community/remont/data/rss', 'LJ Remont comunity', '2004-01-30 16:42:17', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://playmobile.ru/news/rss', 'PlayMobile.ru', '2004-01-30 16:42:23', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://alex.ezhiki.ru/txt/export.xml', 'alex.ezhiki.ru', '2004-01-30 17:24:04', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://ilyabirman.ru/meanwhile/rss/', 'IlyaBirman.ru', '2004-01-30 16:45:02', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://simon.incutio.com/syndicate/rss1.0', 'Simon Willison\'s weblog', '2004-01-30 17:24:10', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.livejournal.com/community/pictography/data/rss', 'LJ Pictography', '2004-01-30 16:54:13', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.livejournal.com/community/whitelight/data/rss', 'LJ Whitelight', '2004-01-30 17:36:50', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.livejournal.com/community/everyday_people/data/rss', 'LJ everyday_people', '2004-01-30 16:42:20', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.livejournal.com/community/color_theory/data/rss', 'LJ color_theory', '2004-01-30 17:36:37', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.livejournal.com/users/versionke/data/rss', 'LJ VersionKe', '2004-01-30 17:00:11', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.livejournal.com/users/pineapplemonade/data/rss', 'pineapplemonade', '2004-01-30 17:00:07', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://diveintomark.org/xml/rss.xml', 'Dive into Mark', '2004-01-30 16:54:08', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://bolk.exler.ru/txt/export.xml', 'BOLK\'s register', '2004-01-30 17:36:20', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://kuking.net/xml/kuking.xml', 'Kuking.ru', '0000-00-00 00:00:00', 'no', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.cooking.ru/yandex/daymenu.xml', 'Меню дня', '0000-00-00 00:00:00', 'no', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://xmlhack.ru/service/rss/xmlhack.rss', 'XML hack', '2003-11-28 11:11:57', 'no', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.livejournal.com/community/found_objects/data/rss', 'Found Objects LJ', '2004-01-30 17:36:32', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.groklaw.net/backend/GrokLaw.rdf', 'GROKLAW', '2004-01-30 17:03:27', 'yes', 1, 24000, 'yes');
INSERT INTO `cityblog_rsslist` VALUES ('http://www.daysleepersdesign.com/blog/index.xml', 'Бортовой Журнал', '2004-01-30 16:39:04', 'yes', 1, 24000, 'yes');

allow_untaint enum('yes','no') обозначает, можно ли доверять HTML-коду, пришеджему в entry RSS'а. Если гарантировано, что HTML будет чистый, мы его унтайнтим, если нет - оставляем как <html>

---