main
|
Last change
on this file since 5b2dd1d was 3679996, checked in by GitHub <noreply@…>, 5 weeks ago |
|
Add files via upload
|
-
Property mode
set to
100644
|
|
File size:
408 bytes
|
| Line | |
|---|
| 1 | ALTER TABLE event_rsvp
|
|---|
| 2 | ADD CONSTRAINT chk_rsvp_status
|
|---|
| 3 | CHECK (status IN ('accepted', 'declined', 'pending'));
|
|---|
| 4 |
|
|---|
| 5 | ALTER TABLE attendance
|
|---|
| 6 | ADD CONSTRAINT chk_attendance_status
|
|---|
| 7 | CHECK (status IN ('attending', 'absent'));
|
|---|
| 8 |
|
|---|
| 9 | ALTER TABLE event_rsvp
|
|---|
| 10 | ADD CONSTRAINT uq_guest_event_rsvp
|
|---|
| 11 | UNIQUE (guest_id, event_id);
|
|---|
| 12 |
|
|---|
| 13 | ALTER TABLE attendance
|
|---|
| 14 | ADD CONSTRAINT uq_guest_event_attendance
|
|---|
| 15 | UNIQUE (guest_id, event_id); |
|---|
Note:
See
TracBrowser
for help on using the repository browser.
