tsunami

log in
history

tsunami scripts

Luke Breuer
2008-03-27 14:33 UTC

new user
insert person (username, password_hash, email, input_person_fk) 
values ('<username,,>', pwdencrypt('<password,,>'), '<email,,>', 0)
update password
update person set password_hash = pwdencrypt_('<password,,>')
where username = '<username,,>'
fix item name
update item set name = replace(name, '_', ' ') where name like '%\_%' escape ''
restore update_date, update_count
update  o set
        o.update_date = r.update_date,
        o.update_count = r.update_count
from    Item o
inner join time_database_restore..item r on r.item_pk = o.item_pk