projects
/
platal.git
/ blob
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
history
|
raw
|
HEAD
Fixes bestalias update when two local_part are identical (Closes #1517).
[platal.git]
/
upgrade
/
1.1.1
/
05_xnet_accounts.sql
1
-- Disables non-activated xnet accounts.
2
3
UPDATE
accounts
AS
a
4
LEFT JOIN
register_pending_xnet
AS
r
ON
(
r.uid
=
a.uid
)
5
SET
a.
state
=
'disabled'
6
WHERE
a.
password IS NULL AND
a.
type
=
'xnet'
AND
r.hash
IS NULL
;
7
8
-- vim:set syntax=mysql: