From: Alan Knowles Date: Thu, 14 Jul 2016 05:34:48 +0000 (+0800) Subject: sql/Person.sql X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=commitdiff_plain;h=294b964a4a30d547517f5b3f2de7b431e9eebb29 sql/Person.sql --- diff --git a/sql/Person.sql b/sql/Person.sql index 6ba64701..8805ee23 100644 --- a/sql/Person.sql +++ b/sql/Person.sql @@ -87,7 +87,7 @@ alter table Person change column active active int(11) NOT NULL DEFAULT 1 ; 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 TEXT NOT NULL DEFAULT ''; +ALTER TABLE Person ADD COLUMN authorize_md5 varchar(254) NOT NULL DEFAULT ''; ALTER TABLE Person ADD INDEX lookup_authorize_md5_active(authorize_md5, active);