CREATE TABLE `client_template_assigned` (
  `assigned_template_id` bigint(20) NOT NULL auto_increment,
  `client_id` bigint(11) NOT NULL DEFAULT '0',
  `client_template_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`assigned_template_id`),
  KEY `client_id` (`client_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

ALTER TABLE `client` ADD `gender` enum('','m','f') NOT NULL DEFAULT '' AFTER `company_id`,
  ADD `locked` enum('n','y') NOT NULL DEFAULT 'n' AFTER `created_at`,
  ADD `canceled` enum('n','y') NOT NULL DEFAULT 'n' AFTER `locked`,
  ADD `tmp_data` mediumblob AFTER `canceled` ;