add a column article_id to database table article.

1 files changed, 7 insertions, 5 deletions

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
 );