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 )