From: Alan Knowles Date: Thu, 14 Jul 2016 05:35:02 +0000 (+0800) Subject: sql/Person.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=af10d53bb6bc73c58b4bbc9455f373009b4ba5c1 sql/Person.sql --- diff --git a/sql/Person.sql b/sql/Person.sql index 8805ee23..5f33ab61 100644 --- a/sql/Person.sql +++ b/sql/Person.sql @@ -88,6 +88,7 @@ alter table Person change role role varchar(254) NOT NULL DEFAULT ''; alter table Person change email email varchar(254) NOT NULL DEFAULT ''; ALTER TABLE Person ADD COLUMN authorize_md5 varchar(254) NOT NULL DEFAULT ''; +ALTER TABLE Person CHANGE COLUMN authorize_md5 authorize_md5 varchar(254) NOT NULL DEFAULT ''; ALTER TABLE Person ADD INDEX lookup_authorize_md5_active(authorize_md5, active);