PHP Classes

File: SQL File

Recommend this page to a friend!
  Packages of Matthew Asham   Binkterm PHP   database/migrations/v1.9.0_add_service_column_to_user_sessions.sql   Download  
File: database/migrations/v1.9.0_add_service_column_to_user_sessions.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: 5 days ago
Size: 459 bytes
 

Contents

Class file image Download 
-- Migration: 1.9.0 - add service column to user sessions
-- Created: 2026-02-01 05:43:51

-- Add service column to track which service the user is logged into
ALTER TABLE user_sessions ADD COLUMN service VARCHAR(20) DEFAULT 'web' NOT NULL;

-- Create index for service lookups
CREATE INDEX idx_user_sessions_service ON user_sessions(service);

-- Update existing sessions to have 'web' service
UPDATE user_sessions SET service = 'web' WHERE service IS NULL;