diff options
Diffstat (limited to 'tables.sql')
-rw-r--r-- | tables.sql | 22 |
1 files changed, 15 insertions, 7 deletions
@@ -1,3 +1,11 @@ | |||
1 | drop table users; | ||
2 | drop table knowledge; | ||
3 | drop table words; | ||
4 | drop table replies; | ||
5 | drop table actions_0r; | ||
6 | drop table strings; | ||
7 | drop table nicknames; | ||
8 | |||
1 | create table users ( | 9 | create 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 | ||
12 | create table knowledge ( | 20 | create table knowledge ( |
13 | trigger text, | 21 | trigger text, |
14 | reply text, | 22 | reply text, |
15 | hilfsverb text | 23 | hilfsverb text |
16 | ) | 24 | ); |
17 | 25 | ||
18 | create table words ( | 26 | create 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 | ||
24 | create table replies ( | 32 | create table replies ( |
25 | template text, | 33 | template text, |
26 | probability real | 34 | probability real |
27 | ) | 35 | ); |
28 | 36 | ||
29 | create table actions_0r ( | 37 | create 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 | ||
34 | create table strings ( | 42 | create table strings ( |
35 | name text, | 43 | name text, |
36 | value text | 44 | value text |
37 | ) | 45 | ); |
38 | 46 | ||
39 | create table nicknames ( | 47 | create 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 | ); |