X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=sql%2Fcore_ip_access.sql;h=384816b5b8b08cfb5efcb96c6db87eccdfca70aa;hb=a180baaa979e194cf22b777dc5fab4246aca245c;hp=b857724a03abeec68fed09e4aecc2f0614f45404;hpb=f96bc4feb4f83b3be35c8f4c8a7d5839cd1e466b;p=Pman.Core diff --git a/sql/core_ip_access.sql b/sql/core_ip_access.sql index b857724a..384816b5 100644 --- a/sql/core_ip_access.sql +++ b/sql/core_ip_access.sql @@ -11,5 +11,6 @@ ALTER TABLE core_ip_access ADD COLUMN authorized_by INT(11) NOT NULL DEFAULT 0; ALTER TABLE core_ip_access ADD COLUMN authorized_key VARCHAR(254) NOT NULL DEFAULT ''; ALTER TABLE core_ip_access ADD COLUMN email VARCHAR(254) NOT NULL DEFAULT ''; ALTER TABLE core_ip_access ADD COLUMN expire_dt DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'; +ALTER TABLE core_ip_access ADD COLUMN user_agent VARCHAR(254) NOT NULL DEFAULT ''; ALTER TABLE core_ip_access ADD INDEX ip_status_lookup(ip, status); \ No newline at end of file