-- =============================================
-- SIMPLE VERSION: ADD INACTIVITY TIMEOUT COLUMN
-- =============================================
-- Simple ALTER TABLE statement to add inactivity_timeout column
-- Use this if the above script doesn't work on your MySQL version

ALTER TABLE `db_store` 
ADD COLUMN `inactivity_timeout` int(11) DEFAULT 600 COMMENT 'Inactivity timeout in seconds (default 10 minutes = 600 seconds)';

-- Update existing records to have the default value
UPDATE `db_store` SET `inactivity_timeout` = 600 WHERE `inactivity_timeout` IS NULL;
