diff options
| author | Alex Pooley (@zuedev) <zuedev@gmail.com> | 2026-05-24 12:58:49 +0100 |
|---|---|---|
| committer | Alex Pooley (@zuedev) <zuedev@gmail.com> | 2026-05-24 12:58:49 +0100 |
| commit | e2066f51523ecba0f1991edd0c2b94f8f4cd1820 (patch) | |
| tree | 8aedfff6c5d321d612278b40002a8e8037105b08 /communities/174bg/174bg.net/better-auth_migrations | |
| parent | 7bcfcc53b2dcbfb6efc82524f7bd078b716fd27b (diff) | |
| download | unnamed-group-e2066f51523ecba0f1991edd0c2b94f8f4cd1820.tar unnamed-group-e2066f51523ecba0f1991edd0c2b94f8f4cd1820.tar.gz unnamed-group-e2066f51523ecba0f1991edd0c2b94f8f4cd1820.tar.bz2 unnamed-group-e2066f51523ecba0f1991edd0c2b94f8f4cd1820.tar.xz unnamed-group-e2066f51523ecba0f1991edd0c2b94f8f4cd1820.zip | |
shorten community subdirs
Diffstat (limited to 'communities/174bg/174bg.net/better-auth_migrations')
| -rw-r--r-- | communities/174bg/174bg.net/better-auth_migrations/2026-05-13T15-14-44.314Z.sql | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/communities/174bg/174bg.net/better-auth_migrations/2026-05-13T15-14-44.314Z.sql b/communities/174bg/174bg.net/better-auth_migrations/2026-05-13T15-14-44.314Z.sql new file mode 100644 index 0000000..5a2fae9 --- /dev/null +++ b/communities/174bg/174bg.net/better-auth_migrations/2026-05-13T15-14-44.314Z.sql @@ -0,0 +1,13 @@ +create table "user" ("id" text not null primary key, "name" text not null, "email" text not null unique, "emailVerified" boolean not null, "image" text, "createdAt" timestamptz default CURRENT_TIMESTAMP not null, "updatedAt" timestamptz default CURRENT_TIMESTAMP not null); + +create table "session" ("id" text not null primary key, "expiresAt" timestamptz not null, "token" text not null unique, "createdAt" timestamptz default CURRENT_TIMESTAMP not null, "updatedAt" timestamptz not null, "ipAddress" text, "userAgent" text, "userId" text not null references "user" ("id") on delete cascade); + +create table "account" ("id" text not null primary key, "accountId" text not null, "providerId" text not null, "userId" text not null references "user" ("id") on delete cascade, "accessToken" text, "refreshToken" text, "idToken" text, "accessTokenExpiresAt" timestamptz, "refreshTokenExpiresAt" timestamptz, "scope" text, "password" text, "createdAt" timestamptz default CURRENT_TIMESTAMP not null, "updatedAt" timestamptz not null); + +create table "verification" ("id" text not null primary key, "identifier" text not null, "value" text not null, "expiresAt" timestamptz not null, "createdAt" timestamptz default CURRENT_TIMESTAMP not null, "updatedAt" timestamptz default CURRENT_TIMESTAMP not null); + +create index "session_userId_idx" on "session" ("userId"); + +create index "account_userId_idx" on "account" ("userId"); + +create index "verification_identifier_idx" on "verification" ("identifier");
\ No newline at end of file |
