diff options
author | Bryan Newbold <bnewbold@robocracy.org> | 2022-11-07 00:44:35 -0800 |
---|---|---|
committer | Bryan Newbold <bnewbold@robocracy.org> | 2022-11-07 00:44:35 -0800 |
commit | 73bb6f114d3fe9233af4f9ab91c8fc2b09b3c6c0 (patch) | |
tree | e04adc0818f9089dc727af065683b9c110208643 /adenosine-pds/src/atp_db.sql | |
parent | 13b77ec75c5018f17048e2712ca83da3b4bb82dc (diff) | |
download | adenosine-73bb6f114d3fe9233af4f9ab91c8fc2b09b3c6c0.tar.gz adenosine-73bb6f114d3fe9233af4f9ab91c8fc2b09b3c6c0.zip |
pds: update upstream lexicon details
Diffstat (limited to 'adenosine-pds/src/atp_db.sql')
-rw-r--r-- | adenosine-pds/src/atp_db.sql | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/adenosine-pds/src/atp_db.sql b/adenosine-pds/src/atp_db.sql index 350c9ef..b356abc 100644 --- a/adenosine-pds/src/atp_db.sql +++ b/adenosine-pds/src/atp_db.sql @@ -3,18 +3,18 @@ CREATE TABLE account( did TEXT PRIMARY KEY NOT NULL, - username TEXT NOT NULL, + handle TEXT NOT NULL, email TEXT NOT NULL, password_bcrypt TEXT NOT NULL, recovery_pubkey TEXT NOT NULL, created_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT ( DATETIME('now') ) ); -CREATE UNIQUE INDEX account_username_uniq_idx on account(lower(username)); +CREATE UNIQUE INDEX account_handle_uniq_idx on account(lower(handle)); CREATE UNIQUE INDEX account_email_uniq_idx on account(lower(email)); CREATE TABLE did_doc( did TEXT PRIMARY KEY NOT NULL, - -- TODO: username TEXT NOT NULL, + -- TODO: handle TEXT NOT NULL, doc_json TEXT NOT NULL, indexed_at TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT ( DATETIME('now') ) ); |