summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authordakkar <dakkar@luxion>2006-02-08 15:01:59 +0000
committerdakkar <dakkar@luxion>2006-02-08 15:01:59 +0000
commit4eaa34bf3545bfcda5f4065cf18de2efaac163b1 (patch)
treef2688c74feab930b8bf1b462eb66833f21282adb
parentmodel::dbic::plain (diff)
downloadIscrittiGroLUG-4eaa34bf3545bfcda5f4065cf18de2efaac163b1.tar.gz
IscrittiGroLUG-4eaa34bf3545bfcda5f4065cf18de2efaac163b1.tar.bz2
IscrittiGroLUG-4eaa34bf3545bfcda5f4065cf18de2efaac163b1.zip
schema database
git-svn-id: svn://luxion/repos/IscrittiGroLUG/trunk@167 fcb26f47-9200-0410-b104-b98ab5b095f3
-rw-r--r--GroLUG/sql/crea-tabelle.sql18
1 files changed, 18 insertions, 0 deletions
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
+);