title: mysql #1071 - Specified key was too long; max key length is 767 bytes
body: <p>I am try to execute the below SQL and it is given the error above</p>
  
  <pre><code>    CREATE TABLE IF NOT EXISTS `oic_assemblyman_data` (
  `id` bigint( 100 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
  `firstname` varchar( 300 ) COLLATE utf8_unicode_ci NOT NULL ,
  `lastname` varchar( 300 ) COLLATE utf8_unicode_ci NOT NULL ,
  `email` varchar( 300 ) COLLATE utf8_unicode_ci DEFAULT NULL ,
  `phone` varchar( 300 ) COLLATE utf8_unicode_ci DEFAULT NULL ,
  `office_latitude` varchar( 20 ) COLLATE utf8_unicode_ci DEFAULT NULL ,
  `office_longitude` varchar( 20 ) COLLATE utf8_unicode_ci DEFAULT NULL ,
  `website_welcome_address` text COLLATE utf8_unicode_ci,
  `website_header_color` varchar( 15 ) COLLATE utf8_unicode_ci DEFAULT NULL ,
  `website_footer_color` varchar( 20 ) COLLATE utf8_unicode_ci DEFAULT NULL ,
  `about_yourself` text COLLATE utf8_unicode_ci NOT NULL ,
  `password` varchar( 100 ) COLLATE utf8_unicode_ci NOT NULL ,
  PRIMARY KEY ( `id` ) ,
  UNIQUE KEY `email` ( `email` )
  ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_unicode_ci;
  </code></pre>
  
  <p>Could someone point out what is causing the problem</p>