summaryrefslogtreecommitdiff
path: root/GroLUG/sql
diff options
context:
space:
mode:
Diffstat (limited to 'GroLUG/sql')
-rw-r--r--GroLUG/sql/crea-tabelle.sql9
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,