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

Go to download

Show more of this group Show more artifacts with this name
Show all versions of homeautomation-spring-core Show documentation

HomeAutomation Spring implementation of the Core

The newest version!

create table if not exists device
(
    id           uuid not null
        constraint device_id_pk primary key,
    device_id    text not null,
    device_type  text not null,
    display_name text,
    constraint device_id_uk unique (device_id, device_type)
);