一覧へ戻る

create_animal.sql

CREATE TABLE IF NOT EXISTS animal (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    size INT NOT NULL,
    memo TEXT NULL
) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;