-- Add Contract_Content_HTML column to Contract_Of_Employment table
-- This column will store the fully customized HTML content of the contract
-- including all edited headings, paragraphs, lists, and definitions

ALTER TABLE Contract_Of_Employment 
ADD COLUMN IF NOT EXISTS Contract_Content_HTML LONGTEXT NULL 
COMMENT 'Stores the customized HTML content of the contract with all contenteditable changes';

-- For MySQL versions that don't support IF NOT EXISTS:
-- ALTER TABLE Contract_Of_Employment 
-- ADD COLUMN Contract_Content_HTML LONGTEXT NULL 
-- COMMENT 'Stores the customized HTML content of the contract with all contenteditable changes';
