diff options
| author | Joris | 2025-02-07 08:25:28 +0100 |
|---|---|---|
| committer | Joris | 2025-02-07 08:25:28 +0100 |
| commit | bfe4aa78d882b9d95bd1f954371136f3aa5c38c9 (patch) | |
| tree | 597f20035a42f4603d4a1c693a4c070ef00e112e /src/db/migration/03-sign-in-token.sql | |
| parent | fedb4e7c7ebf21619f89c29d011e288363a978e9 (diff) | |
Migrate database at startup
Diffstat (limited to 'src/db/migration/03-sign-in-token.sql')
| -rw-r--r-- | src/db/migration/03-sign-in-token.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/src/db/migration/03-sign-in-token.sql b/src/db/migration/03-sign-in-token.sql new file mode 100644 index 0000000..a3d8a13 --- /dev/null +++ b/src/db/migration/03-sign-in-token.sql @@ -0,0 +1,5 @@ +DROP TABLE sign_in; + +ALTER TABLE user ADD COLUMN "password" TEXT NOT NULL DEFAULT "password"; + +ALTER TABLE user ADD COLUMN "sign_in_token" TEXT NULL; |