From 4d3ca5b7150ee325cb12e9d015460910db773030 Mon Sep 17 00:00:00 2001
From: kiffer <>
Date: Wed, 20 Jul 2005 10:25:54 +0000
Subject: table layout (untested)

---
 tables.sql | 43 +++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 43 insertions(+)
 create mode 100644 tables.sql

(limited to 'tables.sql')

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
+)
-- 
cgit v1.2.3

