CREATE TABLE IF NOT EXISTS `sampleapp_sqlalias` (
  `alias` varchar(255) NOT NULL,
  `destination` varchar(255) NOT NULL,
  `code` smallint(5) unsigned DEFAULT NULL,
  `referentClass` VARCHAR(64) NULL DEFAULT NULL ,
  `referentId` INT(10) UNSIGNED NULL DEFAULT '0' ,
  UNIQUE KEY `alias` (`alias`),
  KEY `referent`(`referentClass`, `referentId`))
ENGINE=InnoDB
DEFAULT CHARSET=utf8;
