fix: change news image table to handle multiple images for each post

1 files changed, 2 insertions, 1 deletions

diff --git a/schema.sql b/schema.sql
index 88e1120..dc32e3e 100644
--- a/schema.sql
+++ b/schema.sql
@@ -13,7 +13,8 @@ CREATE TABLE IF NOT EXISTS news (
 );
 
 CREATE TABLE IF NOT EXISTS news_images (
-    news_id VARCHAR(255) NOT NULL PRIMARY KEY,
+    id INTEGER PRIMARY KEY AUTOINCREMENT,
+    news_id VARCHAR(255) NOT NULL,
     image_url TEXT NOT NULL,
     link_url TEXT,
     FOREIGN KEY (news_id) REFERENCES news(news_id) ON DELETE CASCADE