CREATE TABLE IF NOT EXISTS `customer` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `logo` varchar(350) NOT NULL,
  `prefix` varchar(255) NOT NULL,
  `current_store_above` tinyint(1) NOT NULL,
  `subdomain` varchar(255) NOT NULL,
  `header_background_colour` VARCHAR(7) NULL,
  `motd` VARCHAR(355) NULL,
  `status` varchar(10) NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `created` datetime DEFAULT NULL,
  `updated` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

