CREATE TABLE characters (
    id INTEGER NOT NULL PRIMARY KEY,
    name TEXT NOT NULL,
    alignment VARCHAR(30) NOT NULL DEFAULT ''
)