diff options
Diffstat (limited to 'doc/factoids.sql')
-rw-r--r-- | doc/factoids.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/doc/factoids.sql b/doc/factoids.sql new file mode 100644 index 0000000..ecf2732 --- /dev/null +++ b/doc/factoids.sql @@ -0,0 +1,15 @@ +/* + * This is how to create a factoid database + * Use this file like this: + * sqlite3 -batch data/envbot.db < doc/factoids.sql + * + * If you use another table name, change below in + * both places + */ +DROP TABLE IF EXISTS factoids; +CREATE TABLE factoids ( + name TEXT UNIQUE NOT NULL PRIMARY KEY, + value TEXT NOT NULL, + who TEXT NOT NULL, + is_locked INTEGER NOT NULL DEFAULT 0 +); |