search

alphagov / trade-tariff-backend

Enabling the population and distribution via API of UK Customs tariffs and duties
MIT License
7 stars 6 forks source link

Schema conflict #5

Closed saulius closed 12 years ago

saulius commented 12 years ago

Adjusting String field lengths so that indexes on older versions of MySQL (< 5.5) will get created.

Also, querying is supposedly more performant this way.

saulius commented 12 years ago

This becomes an issue on VMs where MySQL is at 5.1. Prod (RDS?), CI (MySQL v?) and MySQL >= 5.5 work just fine.

jabley commented 12 years ago

In the production environment, we should be running vanilla MySQL 5.5 or the Percona build, depending on what Web Ops are happiest with.