| 1 | exports.up = async function(knex, Promise) {
|
| 2 | await knex.schema.alterTable("content_values", table => {
|
| 3 | table.string("literal_lc");
|
| 4 | });
|
| 5 | // Copy values from literal to literal_lc as lowercase values
|
| 6 | await knex.schema.raw(
|
| 7 | "UPDATE content_values SET literal_lc = LOWER(literal)"
|
| 8 | );
|
| 9 | };
|
| 10 |
|
| 11 | exports.down = async function(knex, Promise) {
|
| 12 | await knex.schema.alterTable("content_values", table => {
|
| 13 | table.dropColumn("literal_lc");
|
| 14 | });
|
| 15 | };
|