Skip to content
This repository has been archived by the owner on Apr 14, 2024. It is now read-only.

Remove id field from session_tokens #24

Open
wqyeo opened this issue Nov 20, 2023 · 1 comment
Open

Remove id field from session_tokens #24

wqyeo opened this issue Nov 20, 2023 · 1 comment
Labels
help wanted Extra attention is needed PostgreSQL: Function Related to a function in postgreSQL PostgreSQL: Table Related to a table in PostgreSQL PostgreSQL schema: user PostgreSQL "user" schema

Comments

@wqyeo
Copy link
Member

wqyeo commented Nov 20, 2023

Title,

remove the id field from session_tokens, and form a composite primary key with account_id and session_token instead.

Alternatively

Set session_token field as primary key, and index account_id.

@wqyeo wqyeo added PostgreSQL schema: user PostgreSQL "user" schema labels Nov 20, 2023
@wqyeo wqyeo added PostgreSQL: Function Related to a function in postgreSQL PostgreSQL: Table Related to a table in PostgreSQL labels Nov 22, 2023
@wqyeo wqyeo moved this from 🆕 New to 📋 Backlog in SingaDrive Project Nov 22, 2023
@wqyeo wqyeo added the help wanted Extra attention is needed label Nov 22, 2023
@wqyeo
Copy link
Member Author

wqyeo commented Nov 22, 2023

Welp, some functions rely on the id field of account_sessions to do joins and stuff, so...

DEAD

Willing to accept a PR if anyone wants to do this enhancement lol

@wqyeo wqyeo closed this as completed Nov 22, 2023
@wqyeo wqyeo reopened this Nov 22, 2023
@github-project-automation github-project-automation bot moved this from 📋 Backlog to ✅ Done in SingaDrive Project Nov 22, 2023
@github-project-automation github-project-automation bot moved this from ✅ Done to 🏗 In progress in SingaDrive Project Nov 22, 2023
@wqyeo wqyeo moved this from 🏗 In progress to 📋 Backlog in SingaDrive Project Nov 22, 2023
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
help wanted Extra attention is needed PostgreSQL: Function Related to a function in postgreSQL PostgreSQL: Table Related to a table in PostgreSQL PostgreSQL schema: user PostgreSQL "user" schema
Projects
No open projects
Status: 📋 Backlog
Development

No branches or pull requests

1 participant