PmWiki | V2 / RegEvents

V2.RegEvents History

Hide minor edits - Show changes to output

January 20, 2012, at 03:48 PM by shevett -

Changed line 6 from:

event_~~eventid~~ int(8) NOT NULL,

to:

event_eid int(8) NOT NULL,

Restore

January 20, 2012, at 03:11 PM by shevett -

Deleted line 0:

~~!!Description~~

Changed line 4 from:

CREATE TABLE reg_events (

to:

[@ CREATE TABLE reg_events (

Added lines 13-16:

@]

!!See Also
* [[V2/Scheduling]] - Scheduling home page

Restore

November 26, 2008, at 03:43 PM by dbs -

Changed lines 1-4 from:

!!~~Database~~ Schema

to:

!!Description
Defines the relationship between registrants and events they have signed up for. A mapping table.

!!Schema

Deleted lines 13-15:

!!Description
Defines the relationship between registrants and events they have signed up for. A mapping table.

Restore

November 26, 2008, at 03:34 PM by dbs -

Added lines 1-13:

!!Database Schema
CREATE TABLE reg_events (
event_rid int(8) NOT NULL,
event_eventid int(8) NOT NULL,
event_cid int(8) NOT NULL,
KEY eventsrid (event_rid),
CONSTRAINT `reg_events_ibfk_1` FOREIGN KEY (`event_rid`) REFERENCES `reg_master` (`master_rid`) ON DELETE CASCADE,
CONSTRAINT `reg_events_ibfk_1` FOREIGN KEY (`event_eventid`) REFERENCES `config_events` (`event_id`) ON DELETE CASCADE,
CONSTRAINT `reg_events_ibfk_1` FOREIGN KEY (`event_cid`) REFERENCES `con_detail` (`con_cid`) ON DELETE CASCADE
) TYPE=InnoDB;

!!Description
Defines the relationship between registrants and events they have signed up for. A mapping table.

Restore