aboutsummaryrefslogtreecommitdiff
path: root/schema.sql
blob: 23e4d7112b1db4b244aaed0b246ef0b40b8343e9 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
CREATE TABLE blog_entries (
    ID INTEGER PRIMARY KEY AUTOINCREMENT,
    timestamp INTEGER,
    slug TEXT UNIQUE NOT NULL,
    title TEXT,
    author TEXT,
    body TEXT);

CREATE TABLE users (
    username VARCHAR(20) PRIMARY KEY,
    password VARCHAR(255),
    display_name VARCHAR(255));