Something went wrong. Try again.
a simple rss/atom interface
Something went wrong. Try again.
1.5 kB · 62 lines
SQL
at main
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263-- lmao sqlite doesn't support altering fk relationships inlineCREATE TABLE IF NOT EXISTS subscribe_new ( id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INTEGER NOT NULL, feed_id INTEGER NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (user_id) REFERENCES user (id), FOREIGN KEY (feed_id) REFERENCES feed (id));
CREATE TABLE IF NOT EXISTS saved_item_new ( id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INTEGER NOT NULL, item_url TEXT NOT NULL, item_title TEXT NOT NULL, archive_url TEXT NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, FOREIGN KEY (user_id) REFERENCES user (id));
-- Copy data from old tables to new tablesINSERT INTO subscribe_newSELECT id, user_id, feed_id, created_atFROM subscribe;
INSERT INTO saved_item_newSELECT id, user_id, item_url, item_title, archive_url, created_atFROM saved_item;
-- Drop old tablesDROP TABLE subscribe;
DROP TABLE saved_item;
-- Rename new tables to original namesALTER TABLE subscribe_newRENAME TO subscribe;
ALTER TABLE saved_item_newRENAME TO saved_item;
CREATE INDEX IF NOT EXISTS idx_subscribe_user_feed ON subscribe (user_id, feed_id);
CREATE INDEX IF NOT EXISTS idx_saved_item_user ON saved_item (user_id);
CREATE INDEX IF NOT EXISTS idx_saved_item_url ON saved_item (item_url);
CREATE INDEX IF NOT EXISTS idx_saved_item_created ON saved_item (created_at);