From 5faf29a0dc09f32d0f797c42a8933c726132051d Mon Sep 17 00:00:00 2001 From: dakkar Date: Thu, 9 Feb 2006 13:19:19 +0000 Subject: funziona il log su db git-svn-id: svn://luxion/repos/IscrittiGroLUG/trunk@174 fcb26f47-9200-0410-b104-b98ab5b095f3 --- GroLUG/sql/crea-tabelle.sql | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'GroLUG/sql') diff --git a/GroLUG/sql/crea-tabelle.sql b/GroLUG/sql/crea-tabelle.sql index 802c95a..4518948 100644 --- a/GroLUG/sql/crea-tabelle.sql +++ b/GroLUG/sql/crea-tabelle.sql @@ -1,6 +1,7 @@ drop table pagamenti; drop table iscritti; drop table sessioni; +drop table log; create table sessioni ( id char(72) primary key, @@ -8,6 +9,14 @@ create table sessioni ( expires int ); +create table log ( + id serial primary key, + time timestamp default now(), + loglevel varchar(255), + username varchar(255), + message text +); + create table iscritti ( id serial primary key, nome varchar(255) not null, -- cgit v1.2.3