Guest User

Untitled

a guest
Jun 20th, 2018
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. ## code
  2. 368 CREATE TABLE `users` (
  3. 369 `id` int(11) NOT NULL auto_increment,
  4. 370 `email` varchar(40) default NULL,
  5. 371 `status` enum('ok','removed') NOT NULL default 'ok',
  6. 372 `password_encrypted` varchar(40) default NULL,
  7. 373 `first_name` varchar(255) default NULL,
  8. 374 `last_name` varchar(255) default NULL,
  9. 375 `timezone_name` varchar(255) default NULL,
  10. 376 `site_name` varchar(255) default NULL,
  11. 377 PRIMARY KEY (`id`),
  12. 378 KEY `email` (`email`),
  13. 379 KEY `password_encrypted` (`password_encrypted`),
  14. 380 KEY `first_name` (`first_name`,`last_name`),
  15. 381 KEY `site_name` (`site_name`)
  16. 382 ) ENGINE=InnoDB AUTO_INCREMENT=99 DEFAULT CHARSET=utf8;
  17.  
  18. ## error
  19. ERROR 1071 (42000) at line 368: Specified key was too long; max key length is 1000 bytes
Add Comment
Please, Sign In to add comment