ALTER TABLE storeprofile
  ADD COLUMN `cnPrefix` varchar(10) NOT NULL DEFAULT '' AFTER `poPrefix`;
CREATE INDEX `cnPrefix` ON `storeprofile`(`cnPrefix`) USING BTREE;
