[AppDB] maintainer: Simplify SQL code

Alexander Nicolaysen Sørnes alex at thehandofagony.com
Tue Nov 6 08:30:41 CST 2007

Now that the new 'pending' state is introduced for maintainers we can simplify 
the SQL code.

The following commands must be run

UPDATE appMaintainers,appFamily SET appMaintainers.queued = 'pending' WHERE 
superMaintainer = '1' AND appMaintainers.appId = appFamily.appId AND 
appFamily.queued != 'false'

UPDATE appMaintainers,appVersion SET appMaintainers.queued = 'pending' WHERE 
superMaintainer = '0' AND appMaintainers.versionId = appVersion.versionId AND 
appVersion.queued != 'false'

Alexander N. Sørnes
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0001-maintainer-Simplify-SQL-code.patch
Type: text/x-diff
Size: 4522 bytes
Desc: not available
Url : http://www.winehq.org/pipermail/wine-patches/attachments/20071106/38da4470/attachment.patch 

More information about the wine-patches mailing list