| ps_promo | CREATE TABLE `ps_promo` (
  `id_promo` int(6) NOT NULL AUTO_INCREMENT,
  `id_manufacturer` int(6) NOT NULL,
  `date_effective` date NOT NULL,
  `date_expiry` date NOT NULL,
  `name` varchar(22) NOT NULL,
  `description` varchar(140) NOT NULL,
  `url` varchar(255) NOT NULL,
  `position_home` tinyint(4) NOT NULL,
  `position_trending` int(11) NOT NULL,
  `position_tv` tinyint(4) NOT NULL,
  `position_essential` tinyint(4) NOT NULL,
  `position_news` tinyint(4) NOT NULL,
  `position_tfg` tinyint(4) NOT NULL,
  `opens_new_tab` tinyint(2) NOT NULL,
  `picture_url` varchar(128) NOT NULL,
  `icon_url` varchar(128) NOT NULL,
  PRIMARY KEY (`id_promo`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8 |

| ps_promo_group | CREATE TABLE `ps_promo_group` (
  `id_promo` int(5) NOT NULL,
  `id_group` int(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |

| ps_customer_group | CREATE TABLE `ps_customer_group` (
  `id_customer` int(10) unsigned NOT NULL,
  `id_group` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id_customer`,`id_group`),
  KEY `customer_login` (`id_group`),
  KEY `id_customer` (`id_customer`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |