Session Table Structure

-- 
-- Table structure for table `tbl_session`
-- 

CREATE TABLE `tbl_session` (
  `fld_id` bigint(10) unsigned NOT NULL auto_increment,
  `fld_session` varchar(100) NOT NULL,
  `fld_date` datetime NOT NULL,
  `fld_last_visit` datetime NOT NULL,
  `fld_user_id` int(10) unsigned NOT NULL,
  PRIMARY KEY  (`fld_id`),
  UNIQUE KEY `fld_session` (`fld_session`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `tbl_session_variable`
-- 

CREATE TABLE `tbl_session_variable` (
  `fld_id` bigint(20) unsigned NOT NULL auto_increment,
  `fld_session_id` bigint(20) unsigned NOT NULL,
  `fld_name` varchar(32) NOT NULL,
  `fld_value` text NOT NULL,
  `fld_date` datetime NOT NULL,
  `fld_user_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY  (`fld_id`),
  UNIQUE KEY `uniqueVariable` (`fld_session_id`,`fld_name`),
  KEY `fld_session_id` (`fld_session_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Constraints for dumped tables
-- 

-- 
-- Constraints for table `tbl_session_variable`
-- 
ALTER TABLE `tbl_session_variable`
  ADD CONSTRAINT `tbl_session_variable_ibfk_1` FOREIGN KEY (`fld_session_id`) REFERENCES `tbl_session` (`fld_id`) ON DELETE CASCADE ON UPDATE NO ACTION;