aboutsummaryrefslogtreecommitdiffstats
path: root/adenosine-pds/src/atp_db.sql
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@robocracy.org>2022-11-07 00:44:35 -0800
committerBryan Newbold <bnewbold@robocracy.org>2022-11-07 00:44:35 -0800
commit73bb6f114d3fe9233af4f9ab91c8fc2b09b3c6c0 (patch)
treee04adc0818f9089dc727af065683b9c110208643 /adenosine-pds/src/atp_db.sql
parent13b77ec75c5018f17048e2712ca83da3b4bb82dc (diff)
downloadadenosine-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.sql6
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') )
);