summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--tables.sql43
1 files changed, 43 insertions, 0 deletions
diff --git a/tables.sql b/tables.sql
new file mode 100644
index 0000000..6cb16ef
--- /dev/null
+++ b/tables.sql
@@ -0,0 +1,43 @@
1create table users (
2 id text,
3 nick text,
4
5 words integer,
6 lines integer,
7
8 lastlogin timestamp,
9 lasthost text
10)
11
12create table knowledge (
13 trigger text,
14 reply text,
15 hilfsverb text
16)
17
18create table words (
19 word text,
20 is_0r boolean,
21 is_action boolean
22)
23
24create table replies (
25 template text,
26 probability real
27)
28
29create table actions_0r (
30 template text,
31 probability real default 0.1
32)
33
34create table strings (
35 name text,
36 value text
37)
38
39create table nicknames (
40 from_nick text,
41 extension text,
42 probability real default 1
43)