aboutsummaryrefslogtreecommitdiffstats
path: root/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'schema.sql')
-rw-r--r--schema.sql3
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
send patches to the email below
yukais@pinapelz.com
include the subject [PATCH repo_name]
pinapelz.com
homepage