|
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 |
- |
|
|