[AppDB] Add initial un-delete support

Alexander Nicolaysen Sørnes alex at thehandofagony.com
Wed Dec 12 15:43:46 CST 2007


For distributions, vendors, applications, versions and test data.


The following SQL commands are required

ALTER TABLE appFamily CHANGE state state 
ENUM( 'accepted', 'queued', 'rejected', 'deleted' ) NOT NULL 
DEFAULT 'accepted'

ALTER TABLE appVersion CHANGE state state 
ENUM( 'accepted', 'queued', 'rejected', 'pending', 'deleted' ) NOT NULL 
DEFAULT 'accepted'

ALTER TABLE distributions CHANGE state state 
ENUM( 'accepted', 'queued', 'deleted' ) NOT NULL DEFAULT 'accepted'

ALTER TABLE testResults CHANGE state state 
ENUM( 'accepted', 'queued', 'rejected', 'pending', 'deleted' ) NOT NULL 
DEFAULT 'accepted'

ALTER TABLE vendor CHANGE state state ENUM( 'accepted', 'queued', 'deleted' )  
NOT NULL DEFAULT 'accepted'


Alexander N. Sørnes
-------------- next part --------------
A non-text attachment was scrubbed...
Name: 0007-Add-initial-un-delete-support.patch
Type: text/x-diff
Size: 40311 bytes
Desc: not available
Url : http://www.winehq.org/pipermail/wine-patches/attachments/20071212/d794f187/attachment-0001.patch 


More information about the wine-patches mailing list