From 9d90c78beadd8f0e8e34ead2a8c2e37f2e10a934 Mon Sep 17 00:00:00 2001 From: erdgeist <> Date: Wed, 20 Jul 2005 14:47:59 +0000 Subject: semicola --- tables.sql | 22 +++++++++++++++------- 1 file changed, 15 insertions(+), 7 deletions(-) diff --git a/tables.sql b/tables.sql index 6cb16ef..acb9e8f 100644 --- a/tables.sql +++ b/tables.sql @@ -1,3 +1,11 @@ +drop table users; +drop table knowledge; +drop table words; +drop table replies; +drop table actions_0r; +drop table strings; +drop table nicknames; + create table users ( id text, nick text, @@ -7,37 +15,37 @@ create table users ( 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