-- Create document_categories table
CREATE TABLE IF NOT EXISTS `document_categories` (
  `id` INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  `name` VARCHAR(100) NOT NULL,
  `description` TEXT,
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Insert default categories
INSERT INTO `document_categories` (`name`, `description`) VALUES
('General', 'General documents and miscellaneous files'),
('Contracts', 'Contracts and agreements'),
('Invoices', 'Invoice documents and billing records'),
('Reports', 'Business reports and analytics'),
('Templates', 'Document templates and forms'),
('Policies', 'Company policies and procedures'),
('Presentations', 'Presentation files and slideshows'),
('Legal', 'Legal documents and compliance'),
('HR', 'Human resources documents'),
('Marketing', 'Marketing materials and assets');
