diff options
author | dakkar <dakkar@luxion> | 2006-02-08 15:01:59 +0000 |
---|---|---|
committer | dakkar <dakkar@luxion> | 2006-02-08 15:01:59 +0000 |
commit | 4eaa34bf3545bfcda5f4065cf18de2efaac163b1 (patch) | |
tree | f2688c74feab930b8bf1b462eb66833f21282adb /GroLUG | |
parent | model::dbic::plain (diff) | |
download | IscrittiGroLUG-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
Diffstat (limited to 'GroLUG')
-rw-r--r-- | GroLUG/sql/crea-tabelle.sql | 18 |
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 +); |