diff options
| author | dakkar <dakkar@luxion> | 2006-02-09 13:19:19 +0000 |
|---|---|---|
| committer | dakkar <dakkar@luxion> | 2006-02-09 13:19:19 +0000 |
| commit | 5faf29a0dc09f32d0f797c42a8933c726132051d (patch) | |
| tree | 42d04cb8291bc3d8f64a52cd14e616b84c3decf6 /GroLUG/sql | |
| parent | messe a posto le URI, scheda iscritto (diff) | |
| download | IscrittiGroLUG-5faf29a0dc09f32d0f797c42a8933c726132051d.tar.gz IscrittiGroLUG-5faf29a0dc09f32d0f797c42a8933c726132051d.tar.bz2 IscrittiGroLUG-5faf29a0dc09f32d0f797c42a8933c726132051d.zip | |
funziona il log su db
git-svn-id: svn://luxion/repos/IscrittiGroLUG/trunk@174 fcb26f47-9200-0410-b104-b98ab5b095f3
Diffstat (limited to 'GroLUG/sql')
| -rw-r--r-- | GroLUG/sql/crea-tabelle.sql | 9 |
1 files changed, 9 insertions, 0 deletions
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, |