mirror of https://github.com/mitsuhiko/flask.git
You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
20 lines
498 B
20 lines
498 B
-- Initialize the database. |
|
-- Drop any existing data and create empty tables. |
|
|
|
DROP TABLE IF EXISTS user; |
|
DROP TABLE IF EXISTS post; |
|
|
|
CREATE TABLE user ( |
|
id INTEGER PRIMARY KEY AUTOINCREMENT, |
|
username TEXT UNIQUE NOT NULL, |
|
password TEXT NOT NULL |
|
); |
|
|
|
CREATE TABLE post ( |
|
id INTEGER PRIMARY KEY AUTOINCREMENT, |
|
author_id INTEGER NOT NULL, |
|
created TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, |
|
title TEXT NOT NULL, |
|
body TEXT NOT NULL, |
|
FOREIGN KEY (author_id) REFERENCES user (id) |
|
);
|
|
|