diff options
Diffstat (limited to 'app/static/wordfreqapp_schema.sql')
| -rw-r--r-- | app/static/wordfreqapp_schema.sql | 12 |
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 ); |