blob: 63f16f7f2983cb2e56b86a988997c5f4f21e0378 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
/*
* This is how to create a factoid database
* Use this file like this:
* sqlite3 -batch data/envbot.db < doc/karma.sql
*
* If you use another table name, change below in
* both places
*/
DROP TABLE IF EXISTS karma;
CREATE TABLE karma (
target TEXT UNIQUE NOT NULL PRIMARY KEY,
rating INTEGER NOT NULL,
is_locked INTEGER NOT NULL DEFAULT 0
);
|