[wp-trac] [WordPress Trac] #15332: dbDelta($query) - do not create view

[WordPress Trac]

#15332: dbDelta($query) - do not create view
----------------------------------------------+----------------------------
 Reporter:  christian_gnoth                   |       Owner:
     Type:  feature request                   |      Status:  reopened
 Priority:  normal                            |   Milestone:  Awaiting
Component:  Database                          |  Review
 Severity:  normal                            |     Version:  3.0.1
 Keywords:  reporter-feedback, needs-usecase  |  Resolution:
----------------------------------------------+----------------------------
Changes (by dd32):

 * milestone:   => Awaiting Review


Comment:

 All tickets need some kind of milestone.

 My thoughts: dbDelta is for table schema's, Do views have a table schema
 in the same sense as a table? Can you execute ALTER/etc on the view? If
 so, Then it should be treated the same.

 On the other hand, If views are as i remember them, then you'll need to
 hard-code the SQL regardless, as you need to drop/recreate the view to
 alter it..

 Setting to awaiting review pending punting or closing as out of the scope
 of the Table Schema dbDelta.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/15332#comment:9>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software