[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