From 4eaa34bf3545bfcda5f4065cf18de2efaac163b1 Mon Sep 17 00:00:00 2001
From: dakkar <dakkar@luxion>
Date: Wed, 8 Feb 2006 15:01:59 +0000
Subject: schema database

git-svn-id: svn://luxion/repos/IscrittiGroLUG/trunk@167 fcb26f47-9200-0410-b104-b98ab5b095f3
---
 GroLUG/sql/crea-tabelle.sql | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)
 create mode 100644 GroLUG/sql/crea-tabelle.sql

diff --git a/GroLUG/sql/crea-tabelle.sql b/GroLUG/sql/crea-tabelle.sql
new file mode 100644
index 0000000..6e57d95
--- /dev/null
+++ b/GroLUG/sql/crea-tabelle.sql
@@ -0,0 +1,18 @@
+drop table iscritti;
+drop table pagamenti;
+
+create table iscritti (
+ id serial primary key,
+ nome varchar(255) not null,
+ email varchar(255) unique not null,
+ note text
+);
+
+create table pagamenti (
+ id serial primary key,
+ iscritto integer not null references iscritti(id) on delete restrict,
+ data_pagamento date not null,
+ data_iscrizione date not null,
+ data_scadenza date not null,
+ prezzo numeric(2) not null
+);
-- 
cgit v1.2.3