[AppDB] Use sState for objectGetEntries[Count]()

Alexander Nicolaysen Sørnes alex at thehandofagony.com
Sun Jan 20 14:53:14 CST 2008


Use sState for objectGetEntries[Count]()


Required SQL:

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

UPDATE appData SET state = 'accepted' WHERE queued = 'false';

UPDATE appData SET state = 'queued' WHERE queued = 'true';

UPDATE appData SET state = 'rejected' WHERE queued = 'rejected';

ALTER TABLE appData DROP queued;


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

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

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

ALTER TABLE buglinks DROP queued;


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

UPDATE appMaintainers SET state = 'accepted' WHERE queued = 'false';

UPDATE appMaintainers SET state = 'queued' WHERE queued = 'true';

UPDATE appMaintainers SET state = 'pending' WHERE queued = 'pending';

ALTER TABLE appMaintainers DROP queued;



Alexander N. Sørnes
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0002-Use-sState-for-objectGetEntries-Count.patch
Type: text/x-diff
Size: 60101 bytes
Desc: not available
Url : http://www.winehq.org/pipermail/wine-patches/attachments/20080120/e898b240/attachment-0001.patch 


More information about the wine-patches mailing list