diff options
| author | Daniel García <[email protected]> | 2021-03-14 23:35:55 +0100 |
|---|---|---|
| committer | Daniel García <[email protected]> | 2021-03-14 23:35:55 +0100 |
| commit | 8da5b994828cedad67c2d32df8d89fa79749b04f (patch) | |
| tree | ca934afd7e3d13308e2627def452bf93f04adb5a /migrations/sqlite | |
| parent | 2969e87b5262b0c75d9298f8a2bf4a82336e918d (diff) | |
| download | vaultwarden-8da5b994828cedad67c2d32df8d89fa79749b04f.tar.gz vaultwarden-8da5b994828cedad67c2d32df8d89fa79749b04f.zip | |
Send API
Diffstat (limited to 'migrations/sqlite')
| -rw-r--r-- | migrations/sqlite/2021-03-11-190243_add_sends/down.sql | 1 | ||||
| -rw-r--r-- | migrations/sqlite/2021-03-11-190243_add_sends/up.sql | 25 |
2 files changed, 26 insertions, 0 deletions
diff --git a/migrations/sqlite/2021-03-11-190243_add_sends/down.sql b/migrations/sqlite/2021-03-11-190243_add_sends/down.sql new file mode 100644 index 00000000..b843b76a --- /dev/null +++ b/migrations/sqlite/2021-03-11-190243_add_sends/down.sql @@ -0,0 +1 @@ +DROP TABLE sends; diff --git a/migrations/sqlite/2021-03-11-190243_add_sends/up.sql b/migrations/sqlite/2021-03-11-190243_add_sends/up.sql new file mode 100644 index 00000000..0c1e17ba --- /dev/null +++ b/migrations/sqlite/2021-03-11-190243_add_sends/up.sql @@ -0,0 +1,25 @@ +CREATE TABLE sends ( + uuid TEXT NOT NULL PRIMARY KEY, + user_uuid TEXT REFERENCES users (uuid), + organization_uuid TEXT REFERENCES organizations (uuid), + + name TEXT NOT NULL, + notes TEXT, + + atype INTEGER NOT NULL, + data TEXT NOT NULL, + key TEXT NOT NULL, + password_hash BLOB, + password_salt BLOB, + password_iter INTEGER, + + max_access_count INTEGER, + access_count INTEGER NOT NULL, + + creation_date DATETIME NOT NULL, + revision_date DATETIME NOT NULL, + expiration_date DATETIME, + deletion_date DATETIME NOT NULL, + + disabled BOOLEAN NOT NULL +);
\ No newline at end of file |