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), |