| 4,22 → 4,6 |
|---|
| |
| create sequence hibernate_sequence; |
| |
| /* removed in this version |
| create table participants |
| ( |
| id integer not null, |
| nick varchar(255) not null, |
| email varchar(255) not null, |
| name varchar(255), |
| phone varchar(255), |
| comment text, |
| mod_stamp timestamp, |
| |
| constraint participants_prim primary key (id), |
| constraint participants_email unique(email) |
| ); |
| */ |
| |
| create table acts |
| ( |
| id integer not null, |
| 69,21 → 53,6 |
|---|
| constraint events_name unique(name) |
| ); |
| |
| /* |
| create table event_files |
| ( |
| id integer not null, |
| event integer not null, |
| name varchar(255) not null, |
| data file, |
| type char(1), |
| comment text, |
| mod_stamp timestamp, |
| |
| constraint event_files_prim primary key (id) |
| ); |
| */ |
| |
| create table event_apartments |
| ( |
| id integer not null, |
| 111,27 → 80,6 |
|---|
| constraint event_acts_act foreign key (act) references acts(id) |
| ); |
| |
| /* removed in this version |
| create table participant_events |
| ( |
| participant integer not null, |
| event integer not null, |
| persons integer, |
| from_zip varchar(10), |
| from_city varchar(10), |
| departure datetime, |
| free_transport integer, |
| 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, |
| 151,8 → 99,9 |
|---|
| free_sleep integer, |
| sleep_comment text, |
| payed decimal, |
| comment text, |
| private_comment text, |
| comment text, -- editeable by participant and visible for anybody |
| protected_comment text, -- editeable by participant and visible for admins only |
| private_comment text, -- editeable by admin and visible for admins only |
| mod_stamp timestamp, |
| |
| constraint participants_prim primary key (id), |