[AppDB] - merge appMaintainerQueue into appMaintainers

[Chris Morgan]

We've already done the same for the other queues and its the right thing to do 
for the maintainer queue as well because it lets us flip a flag to 
queue/dequeue people, removes a table and lets us handle the maintainer data 
in a more uniform manner.

Apply the maintainer table alterations before using the patch if you want to 
test it out.

Testing appreciated Tony ;-)

Chris

-------------- next part --------------
A non-text attachment was scrubbed...
Name: merge_maintainer_queue.patch
Type: text/x-diff
Size: 18720 bytes
Desc: not available
Url : http://www.winehq.org/pipermail/wine-patches/attachments/20060713/3272735c/merge_maintainer_queue.patch
-------------- next part --------------
alter table appMaintainers add column maintainReason Text after userId;
alter table appMaintainers add column queued enum('true', 'false', 'rejected') not null default 'false';

# move the queued maintainers into the appMaintainers table
insert into appMaintainers(appId,versionId,userId,maintainReason,superMaintainer,submitTime, queued) select appId, versionId, 
userId, maintainReason, superMaintainer, submitTime, 'true' as queued from appMaintainerQueue

#remove the old table from the database
drop table appMaintainerQueue;