diff options
| -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 | ); |
