33941-vm/db/migrations/002_create_horses_table.sql
2025-09-11 10:05:52 +00:00

9 lines
284 B
SQL

CREATE TABLE IF NOT EXISTS `horses` (
`id` INT AUTO_INCREMENT PRIMARY KEY,
`name` VARCHAR(100) NOT NULL,
`breed` VARCHAR(100) NOT NULL,
`description` TEXT,
`image_url` VARCHAR(255),
`created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;