[Summary view] [Print] [Text view]

   1  ALTER TABLE `{$NAMESPACE}_file`.`macro_transaction`
   2    ADD metadata LONGTEXT NOT NULL COLLATE utf8_bin;
   3  UPDATE `{$NAMESPACE}_file`.macro_transaction SET metadata = '{}'
   4    WHERE metadata = '';
   5  
   6  ALTER TABLE `{$NAMESPACE}_pholio`.`pholio_transaction`
   7    ADD metadata LONGTEXT NOT NULL COLLATE utf8_bin;
   8  UPDATE `{$NAMESPACE}_pholio`.pholio_transaction SET metadata = '{}'
   9    WHERE metadata = '';
  10  
  11  ALTER TABLE `{$NAMESPACE}_config`.`config_transaction`
  12    ADD metadata LONGTEXT NOT NULL COLLATE utf8_bin;
  13  UPDATE `{$NAMESPACE}_config`.config_transaction SET metadata = '{}'
  14    WHERE metadata = '';
  15  
  16  ALTER TABLE `{$NAMESPACE}_conpherence`.`conpherence_transaction`
  17    ADD metadata LONGTEXT NOT NULL COLLATE utf8_bin;
  18  UPDATE `{$NAMESPACE}_conpherence`.conpherence_transaction SET metadata = '{}'
  19    WHERE metadata = '';
  20  
  21  ALTER TABLE `{$NAMESPACE}_phlux`.`phlux_transaction`
  22    ADD metadata LONGTEXT NOT NULL COLLATE utf8_bin;
  23  UPDATE `{$NAMESPACE}_phlux`.phlux_transaction SET metadata = '{}'
  24    WHERE metadata = '';