MigrationHacking

Check and optimize migrations since 2.8rc5

Anything posted on this page is untested hacks, and may/not do the right thing, use with extreme caution

---

pootle_store:0035 set_unit_source again

• needs looking at

pootle_store:0055 fill_source_wordcounts

• could be combined/squashed with pootle_store:0037

UPDATE `pootle_store_unit_source`
 INNER JOIN `pootle_store_unit`
   ON (`pootle_store_unit`.`id` = `pootle_store_unit_source`.`unit_id`)
 SET `pootle_store_unit_source`.`source_hash` = MD5(`pootle_store_unit`.`source_f`),
     `pootle_store_unit_source`.`source_length` = CHAR_LENGTH(`pootle_store_unit`.`source_f`)
 WHERE (`pootle_store_unit_source`.`source_wordcount` = 0);