diff options
Diffstat (limited to 'doc/seen.sql')
-rw-r--r-- | doc/seen.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/doc/seen.sql b/doc/seen.sql new file mode 100644 index 0000000..f10e5d0 --- /dev/null +++ b/doc/seen.sql @@ -0,0 +1,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 +); |