PHP Classes

File: SQL File

Recommend this page to a friend!
  Packages of Matthew Asham   Binkterm PHP   database/migrations/v1.10.13.3_mrc_rooms_list_seen.sql   Download  
File: database/migrations/v1.10.13.3_mrc_rooms_list_seen.sql
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: Binkterm PHP
Bulletin board system based on the Web
Author: By
Last change:
Date: 1 month ago
Size: 207 bytes
 

Contents

Class file image Download 
-- Track when rooms are seen in MRC LIST responses

ALTER TABLE mrc_rooms
ADD COLUMN IF NOT EXISTS last_list_seen TIMESTAMP;

CREATE INDEX IF NOT EXISTS idx_mrc_rooms_list_seen ON mrc_rooms(last_list_seen);