View | Details | Raw Unified | Return to bug 18235
Collapse All | Expand All

(-)a/installer/data/mysql/atomicupdate/bug_18235-add-search_field-facet_order.sql (-2 / +1 lines)
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
- 

Return to bug 18235