| Lines 1-4
          
      
      
        Link Here | 
          
            
              | 1 | ALTER TABLE search_field ADD COLUMN facet_order TINYINT(4) DEFAULT '0' AFTER weight; | 1 | ALTER TABLE search_field ADD COLUMN facet_order TINYINT(4) DEFAULT NULL AFTER weight; | 
        
          | 2 | UPDATE search_field SET facet_order=1 WHERE name='author'; | 2 | UPDATE search_field SET facet_order=1 WHERE name='author'; | 
        
          | 3 | UPDATE search_field SET facet_order=2 WHERE name='itype'; | 3 | UPDATE search_field SET facet_order=2 WHERE name='itype'; | 
        
          | 4 | UPDATE search_field SET facet_order=3 WHERE name='location'; | 4 | UPDATE search_field SET facet_order=3 WHERE name='location'; | 
            
              | 5 | -  |  |  |