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

Alexander Nicolaysen Sørnes alex at thehandofagony.com
Wed Dec 12 15:26:46 CST 2007


application: Rename 'queued' to 'state'


Required SQL commands

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

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

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

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

ALTER TABLE appFamily DROP queued


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


More information about the wine-patches mailing list