diff options
Diffstat (limited to 'schema.sql')
| -rw-r--r-- | schema.sql | 3 |
1 files changed, 2 insertions, 1 deletions
@@ -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 |
