Raphaël G. Git Repositories - zipcode/blob - zipcode.sql

   1 CREATE TABLE IF NOT EXISTS `zipcode` (
   2   `zipcode` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
   3   `city` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
   4   UNIQUE KEY `zipcode` (`zipcode`,`city`)
   5 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;