Database can't be create from scratch

josematiasrivero / mockupdd

2 stars 2 forks source link

Database can't be create from scratch #20

Open IvanPizhenko opened 7 years ago

IvanPizhenko commented 7 years ago

Getting error:

$ sudo config/scripts/recreateSchema.sh
Recreating schema
Executing initial-schema.sql
ERROR 1071 (42000) at line 7: Specified key was too long; max key length is 767 bytes

IvanPizhenko commented 7 years ago

decreasing varchar(255) to varchar(191) heave helped, however looks pretty strange that string used as keys. can the app use some bigint instead?