storage/sql_migrations/README.md
This directory contains SQL schema migrations, run at startup of the node.
Refer to https://pressly.github.io/goose/ on how to write migrations.
Files should be named according to the following: `<number>_<table/feature name>.sql`.
For instance: `002_usecase_list.sql`. Each file should contain `-- +goose Up` and `-- +goose Down`
AVOID changing migrations in master (unless the migration breaks the node horribly) for those running a `master` version.
DO NOT alter migrations in a released version: it might break vendor deployments or cause data corruption.
DID and ID column length are set at 370 and 415 characters:
- domain names have a max length of 253
- `did:web:` has length 8
- for an additional path for did:web we could define max label length=63 + 1 (:)
- for the identifier a base64 encoded sha256 (44 chars) or uuid v4 (36 chars) would suffice (+1 for :)
- in bytes this is 1480 and 1660 bytes for a 4byte utf8 representation.