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

[Alexander Nicolaysen Sørnes]

testData: Rename 'queued' to 'state'


SQL commands:

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

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

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

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

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

ALTER TABLE testResults DROP queued



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