• Home
• se.sundsvall
• dept44-example
• 5.0.1
• source code
• V1_1__add_pet_image_table.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.migration.V1_1__add_pet_image_table.sql Maven / Gradle / Ivy

create table pet_image (
    created datetime(6),
    id bigint not null auto_increment,
    modified datetime(6),
    pet_name_id bigint not null,
    file_name varchar(255),
    mime_type varchar(255),
    content longblob,
    primary key (id)
) engine=InnoDB;
   
alter table if exists pet_image 
   add constraint fk_pet_image_pet_name_id_pet_name_id 
   foreign key (pet_name_id) 
   references pet_name (id);