[Summary view] [Print] [Text view]

   1  ALTER TABLE {$NAMESPACE}_conpherence.conpherence_thread
   2    ADD recentParticipantPHIDs LONGTEXT NOT NULL COLLATE utf8_bin AFTER title,
   3    ADD messageCount BIGINT UNSIGNED NOT NULL AFTER title;
   4  
   5  ALTER TABLE {$NAMESPACE}_conpherence.conpherence_participant
   6    ADD seenMessageCount BIGINT UNSIGNED NOT NULL AFTER behindTransactionPHID;