README
¶
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.
Documentation
Source Files