Unique constraint

How do I define a unique constraint that is not the primary key (aka alternate keys)? Converting from MariaDB…

id BIGINT PRIMARY KEY,
logonId VARCHAR(100) NOT NULL,
firstName VARCHAR(60),
middleName VARCHAR(40),
lastName VARCHAR(60),

UNIQUE IX_Users_LogonId (logonId),
UNIQUE IX_Users_Name (lastName, firstName, middleName)

In this use case, I have a primary key that is generated. Their logonId and name must be unique.

Hi @openstandards

Unfortunately we don’t support unique constraints right now. This is a trade off a fully distributed database :confused:

also see Unique Index · Issue #10279 · crate/crate · GitHub.