[PR #725] [MERGED] feat: db schema index update #722

New issue

Closed

opened 2026-02-26 21:32:40 +03:00 by kerem · 0 comments

kerem commented

2026-02-26 21:32:40 +03:00

Owner

📋 Pull Request Information

Original PR: https://github.com/dreamhunter2333/cloudflare_temp_email/pull/725
Author: @dreamhunter2333
Created: 9/15/2025
Status: ✅ Merged
Merged: 9/15/2025
Merged by: @dreamhunter2333

Base: main ← Head: feature/email

📝 Commits (2)

5aa5ef8 feat: db schema index update
697a250 feat: upgrade dependencies

📊 Changes

10 files changed (+1605 additions, -1580 deletions)

View changed files

📝 db/schema.sql (+7 -0)
📝 frontend/package.json (+5 -5)
📝 frontend/pnpm-lock.yaml (+599 -601)
📝 pages/package.json (+1 -1)
📝 vitepress-docs/package.json (+2 -2)
📝 vitepress-docs/pnpm-lock.yaml (+198 -198)
📝 worker/package.json (+7 -7)
📝 worker/pnpm-lock.yaml (+771 -764)
📝 worker/src/admin_api/db_api.ts (+14 -1)
📝 worker/src/constants.ts (+1 -1)

📄 Description

PR Type

Enhancement, Other

Description

Added new database indexes to improve query performance.
Updated database schema version from v0.0.1 to v0.0.2.
Enhanced database migration logic to handle query formatting.
Synchronized schema changes across SQL and TypeScript files.

Changes walkthrough 📝

Relevant files

Enhancement

db_api.ts `Add indexes and improve migration logic` worker/src/admin_api/db_api.ts Added new indexes for `created_at` and `updated_at` columns. Enhanced migration logic to clean and format queries.	+14/-1
schema.sql `Add indexes and synchronize schema` db/schema.sql Added new indexes for `created_at` and `updated_at` columns. Synchronized schema with TypeScript changes.	+7/-0

Configuration changes

constants.ts

Update database version constant

worker/src/constants.ts

Updated DB_VERSION constant from v0.0.1 to v0.0.2.

+1/-1

Need help?
Type /help how to ... in the comments thread for any questions about PR-Agent usage.
Check out the documentation for more information.

_{🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.}

## 📋 Pull Request Information **Original PR:** https://github.com/dreamhunter2333/cloudflare_temp_email/pull/725 **Author:** [@dreamhunter2333](https://github.com/dreamhunter2333) **Created:** 9/15/2025 **Status:** ✅ Merged **Merged:** 9/15/2025 **Merged by:** [@dreamhunter2333](https://github.com/dreamhunter2333) **Base:** `main` ← **Head:** `feature/email` --- ### 📝 Commits (2) - [`5aa5ef8`](https://github.com/dreamhunter2333/cloudflare_temp_email/commit/5aa5ef827bdb5c364d85fc5936b0926473707834) feat: db schema index update - [`697a250`](https://github.com/dreamhunter2333/cloudflare_temp_email/commit/697a2506cfa90e00cf01b66412f0bdb73fd891e4) feat: upgrade dependencies ### 📊 Changes **10 files changed** (+1605 additions, -1580 deletions) <details> <summary>View changed files</summary> 📝 `db/schema.sql` (+7 -0) 📝 `frontend/package.json` (+5 -5) 📝 `frontend/pnpm-lock.yaml` (+599 -601) 📝 `pages/package.json` (+1 -1) 📝 `vitepress-docs/package.json` (+2 -2) 📝 `vitepress-docs/pnpm-lock.yaml` (+198 -198) 📝 `worker/package.json` (+7 -7) 📝 `worker/pnpm-lock.yaml` (+771 -764) 📝 `worker/src/admin_api/db_api.ts` (+14 -1) 📝 `worker/src/constants.ts` (+1 -1) </details> ### 📄 Description ### **PR Type** Enhancement, Other ___ ### **Description** - Added new database indexes to improve query performance. - Updated database schema version from `v0.0.1` to `v0.0.2`. - Enhanced database migration logic to handle query formatting. - Synchronized schema changes across SQL and TypeScript files. ___ ### **Changes walkthrough** 📝 <table><thead><tr><th></th><th align="left">Relevant files</th></tr></thead><tbody><tr><td><strong>Enhancement</strong></td><td><table> <tr> <td> <details> <summary><strong>db_api.ts</strong><dd><code>Add indexes and improve migration logic</code>                                    </dd></summary> <hr> worker/src/admin_api/db_api.ts <li>Added new indexes for <code>created_at</code> and <code>updated_at</code> columns.<br> <li> Enhanced migration logic to clean and format queries. </details> </td> <td><a href="https://github.com/dreamhunter2333/cloudflare_temp_email/pull/725/files#diff-b2b74d448d9a04d5b6118262d99440206d6b342cb4955730aa50ed9f35923e4c">+14/-1</a>    </td> </tr> <tr> <td> <details> <summary><strong>schema.sql</strong><dd><code>Add indexes and synchronize schema</code>                                              </dd></summary> <hr> db/schema.sql <li>Added new indexes for <code>created_at</code> and <code>updated_at</code> columns.<br> <li> Synchronized schema with TypeScript changes. </details> </td> <td><a href="https://github.com/dreamhunter2333/cloudflare_temp_email/pull/725/files#diff-948c089a4de6325dd9a8f187fb0116272dedf46306023dce6d70b548e9f7539c">+7/-0</a>      </td> </tr> </table></td></tr><tr><td><strong>Configuration changes</strong></td><td><table> <tr> <td> <details> <summary><strong>constants.ts</strong><dd><code>Update database version constant</code>                                                  </dd></summary> <hr> worker/src/constants.ts - Updated `DB_VERSION` constant from `v0.0.1` to `v0.0.2`. </details> </td> <td><a href="https://github.com/dreamhunter2333/cloudflare_temp_email/pull/725/files#diff-cab08ba19c1499ed426fc4918a5613e22eb95c3427c7467ce330f5ee0d69d01e">+1/-1</a>      </td> </tr> </table></td></tr></tr></tbody></table> ___ > <details> <summary> Need help?</summary><li>Type <code>/help how to ...</code> in the comments thread for any questions about PR-Agent usage.</li><li>Check out the <a href="https://qodo-merge-docs.qodo.ai/usage-guide/">documentation</a> for more information.</li></details> --- <sub>🔄 This issue represents a GitHub Pull Request. It cannot be merged through Gitea due to API limitations.</sub>