CREATE TABLE ... LIKE ... - drop column without droping key with it

DROP TABLE IF EXISTS promotions;

CREATE TABLE `promotions` (

  id mediumint(6) unsigned NOT NULL AUTO_INCREMENT,

  `d_start` date NOT NULL,

  `d_end` date NOT NULL,

  `prioritet` char(3) NOT NULL,

  `buh_grp` tinyint(1) unsigned NOT NULL DEFAULT 1,

  `title` varchar(30) NOT NULL,

  `opisanie` text NOT NULL,

  `ts_created` datetime NOT NULL,

  `ts` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),

  PRIMARY KEY (`id`),

  UNIQUE KEY `d_start` (`d_start`,`d_end`,`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

ALTER TABLE promotions DROP PRIMARY KEY, DROP COLUMN `id`, DROP COLUMN ts_created, DROP COLUMN ts;