[AppDB] version: Rename 'queued' to 'state'

[Alexander Nicolaysen Sørnes]

version: Rename 'queued' to 'state'


ALTER TABLE appVersion ADD state 
ENUM( 'accepted', 'queued', 'rejected', 'pending' ) NOT NULL 
DEFAULT 'accepted';

UPDATE appVersion SET state = 'accepted' WHERE queued = 'false'

UPDATE appVersion SET state = 'queued' WHERE queued = 'true'

UPDATE appVersion SET state = 'rejected' WHERE queued = 'rejected'

UPDATE appVersion SET state = 'pending' WHERE queued = 'pending'

ALTER TABLE appVersion DROP queued


Alexander N. Sørnes
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0005-version-Rename-queued-to-state.patch
Type: text/x-diff
Size: 24018 bytes
Desc: not available
Url : http://www.winehq.org/pipermail/wine-patches/attachments/20071212/d0cb4ae7/attachment.patch