From ddf33e64c42236732d89614926ef28a864eea436 Mon Sep 17 00:00:00 2001
From: Hui Lan <lanhui@zjnu.edu.cn>
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

