diff options
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, |