twitter-juggler/create.sql

-- Creates the tweet database
-- Also: reference model for the application

CREATE TABLE IF NOT EXISTS posts (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    content TEXT NOT NULL,
    image TEXT,
    used INTEGER
);