Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ## code
- 368 CREATE TABLE `users` (
- 369 `id` int(11) NOT NULL auto_increment,
- 370 `email` varchar(40) default NULL,
- 371 `status` enum('ok','removed') NOT NULL default 'ok',
- 372 `password_encrypted` varchar(40) default NULL,
- 373 `first_name` varchar(255) default NULL,
- 374 `last_name` varchar(255) default NULL,
- 375 `timezone_name` varchar(255) default NULL,
- 376 `site_name` varchar(255) default NULL,
- 377 PRIMARY KEY (`id`),
- 378 KEY `email` (`email`),
- 379 KEY `password_encrypted` (`password_encrypted`),
- 380 KEY `first_name` (`first_name`,`last_name`),
- 381 KEY `site_name` (`site_name`)
- 382 ) ENGINE=InnoDB AUTO_INCREMENT=99 DEFAULT CHARSET=utf8;
- ## error
- 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