| 4,6 → 4,7 |
|---|
| |
| create sequence hibernate_sequence; |
| |
| /* removed in this version |
| create table participants |
| ( |
| id integer not null, |
| 17,6 → 18,7 |
|---|
| constraint participants_prim primary key (id), |
| constraint participants_email unique(email) |
| ); |
| */ |
| |
| create table events |
| ( |
| 69,12 → 71,12 |
|---|
| ( |
| id integer not null, |
| event integer not null, |
| apartments integer not null, |
| apartment integer not null, |
| distance decimal, |
| comment text, |
| mod_stamp timestamp, |
| |
| constraint event_apartments_prim primary key (event, apartments) |
| constraint event_apartments_prim primary key (event, apartment) |
| ); |
| |
| create table acts |
| 99,6 → 101,7 |
|---|
| constraint event_acts_prim primary key (event, act) |
| ); |
| |
| /* removed in this version |
| create table participant_events |
| ( |
| participant integer not null, |
| 111,12 → 114,41 |
|---|
| transport_comment integer, |
| free_sleep integer, |
| sleep_comment text, |
| payed char(1) default ' ', |
| comment text, |
| mod_stamp timestamp, |
| |
| constraint participant_events_prim primary key (participant, event) |
| ); |
| */ |
| |
| create table participants |
| ( |
| id integer not null, |
| ident varchar(255) not null, |
| nick varchar(255) not null, |
| email varchar(255) not null, |
| email_public char(1) default ' ', |
| name varchar(255), |
| phone varchar(255), |
| event integer not null, |
| persons integer, |
| from_zip varchar(10), |
| from_city varchar(10), |
| departure timestamp, |
| free_transport integer, |
| transport_comment text, |
| free_sleep integer, |
| sleep_comment text, |
| payed char(1) default ' ', |
| comment text, |
| private_comment text, |
| mod_stamp timestamp, |
| |
| constraint participants_prim primary key (id), |
| constraint participants_email unique(email) |
| ); |
| |
| create table participant_acts |
| ( |
| participant integer not null, |