summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorkiffer <>2005-07-20 10:25:54 +0000
committerkiffer <>2005-07-20 10:25:54 +0000
commit4d3ca5b7150ee325cb12e9d015460910db773030 (patch)
tree1d920bd45cb0484b736dab06e011c306fc9d4938
parent5238b3353737d9fa1892bd74b80909750daf3505 (diff)
table layout (untested)
-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)