From ddf33e64c42236732d89614926ef28a864eea436 Mon Sep 17 00:00:00 2001 From: Hui Lan Date: Thu, 11 Feb 2021 15:03:46 +0800 Subject: add a column article_id to database table article. --- app/static/wordfreqapp_schema.sql | 12 +++++++----- 1 file changed, 7 insertions(+), 5 deletions(-) (limited to 'app/static/wordfreqapp_schema.sql') diff --git a/app/static/wordfreqapp_schema.sql b/app/static/wordfreqapp_schema.sql index 62ed51b..46236fc 100644 --- a/app/static/wordfreqapp_schema.sql +++ b/app/static/wordfreqapp_schema.sql @@ -1,8 +1,10 @@ CREATE TABLE user(name TEXT PRIMARY KEY, password TEXT, start_date TEXT, expiry_date TEXT); +CREATE TABLE sqlite_sequence(name,seq); CREATE TABLE IF NOT EXISTS "article" ( - `text` TEXT, - `source` TEXT, - `date` TEXT, - `level` TEXT, - `question` TEXT + "article_id" INTEGER PRIMARY KEY AUTOINCREMENT, + "text" TEXT, + "source" TEXT, + "date" TEXT, + "level" TEXT, + "question" TEXT ); -- cgit v1.2.1