#author("2025-02-22T12:02:01+09:00","default:fujioka","fujioka") #author("2025-02-22T12:02:24+09:00","default:fujioka","fujioka") **rss_feeds(RSSフィード管理用) [#l8a9e7a5] CREATE TABLE rss_feeds ( id INT AUTO_INCREMENT PRIMARY KEY, feed_url VARCHAR(255) NOT NULL UNIQUE, category VARCHAR(50) NOT NULL COMMENT 'フィードのカテゴリ', active TINYINT(1) DEFAULT 1 COMMENT '1: 有効, 0: 無効', created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); **rss_articles(RSS記事データ用) [#w71f8e6a] CREATE TABLE rss_articles ( id INT AUTO_INCREMENT PRIMARY KEY, title VARCHAR(255) NOT NULL, link VARCHAR(255) NOT NULL UNIQUE, description TEXT NOT NULL, pub_date DATETIME NOT NULL, category VARCHAR(50) NOT NULL COMMENT '記事のカテゴリ', created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ); ---- RIGHT:Today : &counter(today); / Yesterday : &counter(yesterday); / Total : &counter(total);