CREATE TABLE `promotion` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `text` varchar(140) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `external` tinyint DEFAULT 0,
  `age` int(2) DEFAULT NULL,
  `order` int(3) NOT NULL DEFAULT 0,
  `status` enum('PUBLISHED','ARCHIVED') DEFAULT 'PUBLISHED',
  `updated` datetime DEFAULT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;