doc/seen.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

/*
 * This is how to create a factoid database
 * Use this file like this:
 * sqlite3 -batch data/envbot.db < doc/seen.sql
 *
 * If you use another table name, change below in
 * both places
 */
DROP TABLE IF EXISTS seen;
CREATE TABLE seen (
	nick       TEXT UNIQUE NOT NULL PRIMARY KEY,
	channel    TEXT        NOT NULL,
	timestamp  TEXT        NOT NULL,
	message    TEXT        NOT NULL
);