Revision 10976
Added by Aaron Marcuse-Kubitza over 10 years ago
| VegCore.my.sql | ||
|---|---|---|
| 182 | 182 |
`place` varbinary(767) DEFAULT NULL, |
| 183 | 183 |
`participants` varbinary(767) DEFAULT NULL, |
| 184 | 184 |
PRIMARY KEY (`id`), |
| 185 |
UNIQUE KEY `event_unique_within_parent` (`parent`,`name`), |
|
| 186 |
UNIQUE KEY `event_unique_within_place` (`place`,`date_range`,`participants`), |
|
| 185 | 187 |
KEY `fk_event_place1_idx` (`place`), |
| 186 | 188 |
KEY `fk_event1_idx` (`parent`), |
| 187 | 189 |
KEY `fk_event_party_list1_idx` (`participants`), |
Also available in: Unified diff
schemas/VegCore/VegCore.ERD.mwb: event: added event_unique_within_parent, event_unique_within_place unique indexes