004_chat_json.sql 170 B

1234
  1. -- Convert any existing plain-text messages to JSON objects {"text": "..."}
  2. UPDATE order_messages
  3. SET message = JSON_OBJECT('text', message)
  4. WHERE message NOT LIKE '{%';