|
V2 /
ConfigSessionsV2.ConfigSessions HistoryHide minor edits - Show changes to output Changed line 21 from:
`session_status` enum('PROPOSED,'ACTIVE','CANCELLED') DEFAULT NULL, to:
`session_status` enum('PROPOSED','ACTIVE','CANCELLED') DEFAULT NULL, Changed line 1 from:
A list of to:
A list of Sessions being held at an Event Changed lines 4-26 from:
[@ CREATE TABLE `config_ `event_type` `event_end` timestamp NOT NULL DEFAULT `event `event_location` varchar(100) DEFAULT `event `event `event_owner` int(8) DEFAULT NULL, `event_lastupdated` timestamp NOT NULL DEFAULT `event KEY `indextype` KEY `config KEY `config CONSTRAINT `config to:
[@ CREATE TABLE `config_sessions` ( `session_id` int(8) NOT NULL AUTO_INCREMENT, `session_cid` int(8) NOT NULL DEFAULT '0', `session_title` varchar(20) DEFAULT NULL, `session_description` text, `session_notes` varchar(200) DEFAULT NULL, `session_tags` varchar(200) DEFAULT NULL, `session_department` int(8) NOT NULL DEFAULT '0', `session_category` int(8) NOT NULL DEFAULT '0', `session_room` int(8) NOT NULL DEFAULT '0', `session_start` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `session_end` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `session_duration` int(8) NOT NULL DEFAULT '0', `session_maxattendees` int(4) DEFAULT NULL, `session_detail` text, `session_cost` decimal(8,2) DEFAULT NULL, `session_owner` int(8) DEFAULT NULL, `session_status` enum('PROPOSED,'ACTIVE','CANCELLED') DEFAULT NULL, `session_public` tinyint(1) DEFAULT '0', `session_lastupdated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `session_lasteditedby` int(8) DEFAULT NULL, KEY `indexid` (`session_id`), KEY `indextype` (`session_cid`), KEY `config_sessions_ibfk_2` (`session_owner`), KEY `config_sessions_ibfk_3` (`session_lasteditedby`), CONSTRAINT `config_sessions_ibfk_1` FOREIGN KEY (`session_cid`) REFERENCES `con_detail` (`con_cid`) ON DELETE CASCADE, CONSTRAINT `config_sessions_ibfk_2` FOREIGN KEY (`session_owner`) REFERENCES `reg_master` (`master_rid`) ON DELETE SET NULL, CONSTRAINT `config_sessions_ibfk_3` FOREIGN KEY (`session_lasteditedby`) REFERENCES `reg_master` (`master_rid`) ON DELETE SET NULL Changed lines 4-27 from:
to:
[@ CREATE TABLE `config_events` ( `event_id` int(8) NOT NULL AUTO_INCREMENT, `event_cid` int(8) NOT NULL DEFAULT '0', `event_name` varchar(20) DEFAULT NULL, `event_description` varchar(100) DEFAULT NULL, `event_type` varchar(20) DEFAULT NULL, `event_category` varchar(20) DEFAULT NULL, `event_start` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `event_end` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `event_maxattendees` int(4) DEFAULT NULL, `event_location` varchar(100) DEFAULT NULL, `event_detail` text, `event_cost` decimal(8,2) DEFAULT NULL, `event_owner` int(8) DEFAULT NULL, `event_lastupdated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `event_lasteditedby` int(8) DEFAULT NULL, KEY `indexid` (`event_id`), KEY `indextype` (`event_cid`), KEY `config_events_ibfk_2` (`event_owner`), KEY `config_events_ibfk_3` (`event_lasteditedby`), CONSTRAINT `config_events_ibfk_1` FOREIGN KEY (`event_cid`) REFERENCES `con_detail` (`con_cid`) ON DELETE CASCADE, CONSTRAINT `config_events_ibfk_2` FOREIGN KEY (`event_owner`) REFERENCES `reg_master` (`master_rid`) ON DELETE SET NULL, CONSTRAINT `config_events_ibfk_3` FOREIGN KEY (`event_lasteditedby`) REFERENCES `reg_master` (`master_rid`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 Added lines 1-9:
A list of Events being held at an Event !!Schema [@ @] !!See Also * [[V2/Scheduling]] - Scheduling home page |