41,7 → 41,8 |
comment text, |
mod_stamp timestamp, |
|
constraint apartments_prim primary key (id) |
constraint apartments_prim primary key (id), |
constraint apartments_name unique(name) |
); |
|
create table events |
91,7 → 92,9 |
comment text, |
mod_stamp timestamp, |
|
constraint event_apartments_prim primary key (event, apartment) |
constraint event_apartments_prim primary key (id), |
constraint event_apartments_event foreign key (event) references events(id), |
constraint event_apartments_apartment foreign key (apartment) references apartments(id) |
); |
|
create table event_acts |
102,7 → 105,9 |
comment text, |
mod_stamp timestamp, |
|
constraint event_acts_prim primary key (event, act) |
constraint event_acts_prim primary key (id), |
constraint event_acts_event foreign key (event) references events(id), |
constraint event_acts_act foreign key (act) references acts(id) |
); |
|
/* removed in this version |
161,5 → 166,7 |
comment text, |
mod_stamp timestamp, |
|
constraint participant_acts_prim primary key (participant, act) |
constraint participant_acts_prim primary key (id), |
constraint participant_acts_participant foreign key (participant) references participants(id), |
constraint participant_acts_act foreign key (act) references acts(id) |
); |