[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