summaryrefslogtreecommitdiff
path: root/tables.sql
diff options
context:
space:
mode:
Diffstat (limited to 'tables.sql')
-rw-r--r--tables.sql22
1 files changed, 15 insertions, 7 deletions
diff --git a/tables.sql b/tables.sql
index 6cb16ef..acb9e8f 100644
--- a/tables.sql
+++ b/tables.sql
@@ -1,3 +1,11 @@
1drop table users;
2drop table knowledge;
3drop table words;
4drop table replies;
5drop table actions_0r;
6drop table strings;
7drop table nicknames;
8
1create table users ( 9create table users (
2 id text, 10 id text,
3 nick text, 11 nick text,
@@ -7,37 +15,37 @@ create table users (
7 15
8 lastlogin timestamp, 16 lastlogin timestamp,
9 lasthost text 17 lasthost text
10) 18);
11 19
12create table knowledge ( 20create table knowledge (
13 trigger text, 21 trigger text,
14 reply text, 22 reply text,
15 hilfsverb text 23 hilfsverb text
16) 24);
17 25
18create table words ( 26create table words (
19 word text, 27 word text,
20 is_0r boolean, 28 is_0r boolean,
21 is_action boolean 29 is_action boolean
22) 30);
23 31
24create table replies ( 32create table replies (
25 template text, 33 template text,
26 probability real 34 probability real
27) 35);
28 36
29create table actions_0r ( 37create table actions_0r (
30 template text, 38 template text,
31 probability real default 0.1 39 probability real default 0.1
32) 40);
33 41
34create table strings ( 42create table strings (
35 name text, 43 name text,
36 value text 44 value text
37) 45);
38 46
39create table nicknames ( 47create table nicknames (
40 from_nick text, 48 from_nick text,
41 extension text, 49 extension text,
42 probability real default 1 50 probability real default 1
43) 51);