table layout (untested)

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 @@
+create table users (
+        id              text,
+        nick            text,
+
+        words           integer,
+        lines           integer,
+
+        lastlogin       timestamp,
+        lasthost        text
+)
+
+create table knowledge (
+        trigger         text,
+        reply           text,
+        hilfsverb       text
+)
+
+create table words (
+        word            text,
+        is_0r           boolean,
+        is_action       boolean
+)
+
+create table replies (
+        template        text,
+        probability     real
+)
+
+create table actions_0r (
+        template        text,
+        probability     real default 0.1
+)
+
+create table strings (
+        name            text,
+        value           text
+)
+
+create table nicknames (
+        from_nick       text,
+        extension       text,
+        probability     real default 1
+)