seentest.py

import sqlite3 as lite
import os

conn = lite.connect(os.path.join(os.path.expanduser('~/.phenny'), 'seen.db'))
c = conn.cursor()
    c.execute('''create table if not exists seen(
		nick		varchar(31) NOT NULL PRIMARY KEY,
		channel		varchar(31) NOT NULL,
		message		text,
		event		varchar(10) NOT NULL,
		time		time DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL,
    );''')