Subversion Repositories general

Compare Revisions

Ignore whitespace Rev 30 → Rev 31

/kickup/trunk/sql/00.tables.sql
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)
);