A list of Sessions being held at an Event
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
) ENGINE=InnoDB DEFAULT CHARSET=latin1