CREATE DATABASE `terme_demo`;

CREATE TABLE  `terme_demo`.`card` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `unique_id` int(10) unsigned NOT NULL default '0',
  `media_id` char(3) NOT NULL default '0',
  `guest_type_id` char(3) NOT NULL default '',
  `dis` int(10) unsigned NOT NULL default '0',
  `dt` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  KEY `Index_1` (`unique_id`),
  KEY `Index_2` (`dt`),
  KEY `FK_card_1` (`media_id`)
) ENGINE=MyISAM AUTO_INCREMENT=119 DEFAULT CHARSET=latin1;

CREATE TABLE  `terme_demo`.`card_service` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `card_id` int(10) unsigned NOT NULL default '0',
  `service_id` int(10) unsigned NOT NULL default '0',
  `date_from` datetime NOT NULL default '0000-00-00 00:00:00',
  `date_to` datetime NOT NULL default '0000-00-00 00:00:00',
  `dt` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`),
  KEY `Index_2` (`date_from`),
  KEY `Index_3` (`date_to`),
  KEY `Index_4` (`card_id`),
  KEY `Index_5` (`service_id`)
) ENGINE=MyISAM AUTO_INCREMENT=139 DEFAULT CHARSET=latin1;

CREATE TABLE  `terme_demo`.`card_data` (
  `card_id` int(10) unsigned NOT NULL default '0',
  `data_id` varchar(16) NOT NULL default '0',
  `value` varchar(45) NOT NULL default '',
  PRIMARY KEY  (`card_id`,`data_id`),
  KEY `Index_2` (`card_id`),
  KEY `Index_3` (`data_id`),
  KEY `Index_4` (`value`),
  KEY `Index_5` (`data_id`,`value`),
  KEY `Index_6` (`card_id`,`data_id`,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


select * from card, card_service
left join card_data on card_data.card_id = card.id