can't add unique constraint on reg_id column because it's a TEXT field not VARCHAR on MySQL

bogdal / django-gcm

Google Cloud Messaging Server in Django

https://django-gcm.readthedocs.org

BSD 2-Clause "Simplified" License

98 stars 42 forks source link

can't add unique constraint on reg_id column because it's a TEXT field not VARCHAR on MySQL #14

Closed kenyee closed 10 years ago

kenyee commented 10 years ago

From the change 3 days ago but it only showed up today in our Jenkins builds :-(

Error in migration: vcm:0002_autochg_field_device_reg_idadd_unique_device_reg_id STDERR: FATAL ERROR - The following SQL query failed: ALTER TABLE gcm_device ADD CONSTRAINT gcm_device_reg_id_1d569ade4b517e81_uniq UNIQUE (reg_id) The error was: (1170, "BLOB/TEXT column 'reg_id' used in key specification without a key length")

I think it has to be turned into a varchar field first...

bogdal commented 10 years ago

Hi @kenyee. This was fixed in 1.0.4 version.