radionica3d/backend/migrations/007_portfolio_scans.sql

-- Migration 007: Portfolio 3D Scans
-- Create table for storing 3D scan bundles for the portfolio section

CREATE TABLE IF NOT EXISTS `portfolio_scans` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title_en` varchar(255) NOT NULL,
  `title_ru` varchar(255) NOT NULL,
  `title_me` varchar(255) NOT NULL,
  `title_ua` varchar(255) NOT NULL,
  `description_en` text DEFAULT NULL,
  `description_ru` text DEFAULT NULL,
  `description_me` text DEFAULT NULL,
  `description_ua` text DEFAULT NULL,
  `folder_name` varchar(255) NOT NULL,
  `frames_count` int(11) DEFAULT 48,
  `is_public` tinyint(1) DEFAULT 1,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;