CREATE TABLE `dreamlog` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `date` date NOT NULL default '0000-00-00',
  `from` time NOT NULL default '00:00:00',
  `till` time NOT NULL default '00:00:00',
  `seq` int(11) unsigned NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `content` text NOT NULL,
  `genre` enum('Science Fiction','Love','Sex','Thriller','Action','Adventure','Detective','Horror','Humor','Spiritual','Ordinary') NOT NULL default 'Ordinary',
  `rating` enum(':(',':|',':)',':D','O-)') NOT NULL default ':)',
  `characters` varchar(255) NOT NULL default '',
  `emotion` varchar(255) NOT NULL default '',
  `dreamsigns` set('thought','emotion','sensation','perception','ego action','character action','object action','ego form','character form','setting form','object form','ego role','character role','character place','object place','setting place','setting time','situation') NOT NULL default '',
  `luciditylevel` enum('none','half','complete') NOT NULL default 'none',
  `application` enum('Adventure & Fantasy','Overcoming Nightmares','Rehearsal','Creativity and Problem Solving','Healing','Transcendence') NOT NULL default 'Adventure & Fantasy',
  `technique` enum('DILD','MILD','WILD') NOT NULL default 'DILD',
  `comment` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `date` (`date`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ;