rtw

Adventure motorcycling trip planning app. Check it out at https://rtw.run.

rtw / server / pkg / user / schema
adds user low level database functions, id functions, abac database functions
scooter  ·  2025-07-14
a2567c8

002_index.sql

1-- +goose up
2-- +goose StatementBegin
3CREATE UNIQUE INDEX IF NOT EXISTS email_idx ON users(email);
4CREATE UNIQUE INDEX IF NOT EXISTS handle_idx ON users(handle);
5CREATE UNIQUE INDEX IF NOT EXISTS handle_norm_idx ON users(lower(handle));
6CREATE UNIQUE INDEX IF NOT EXISTS email_norm_idx on users(lower(email));
7-- +goose StatementEnd