EMAIL API+UI+D1

D1=MAIL_DB CREATE TABLE IF NOT EXISTS accounts ( id TEXT PRIMARY KEY, address TEXT UNIQUE, password TEXT, quota INTEGER DEFAULT 40000000, used INTEGER DEFAULT 0, is_disabled INTEGER DEFAULT 0, is_deleted INTEGER DEFAULT 0, created_at TEXT, updated_at TEXT, expires_at TEXT ); CREATE TABLE IF NOT EXISTS messages ( id TEXT PRIMARY KEY, account_id TEXT, from_address TEXT, from_name TEXT, to_address TEXT, subject TEXT, text_content TEXT, html_content TEXT, intro TEXT, seen INTEGER DEFAULT 0, is_deleted INTEGER DEFAULT 0, has_attachments INTEGER DEFAULT 0, size INTEGER DEFAULT 0, created_at TEXT, updated_at TEXT, expires_at TEXT ); CREATE TABLE IF NOT EXISTS domains ( id TEXT PRIMARY KEY, domain TEXT UNIQUE, is_active INTEGER DEFAULT 1, created_at TEXT ); CREATE INDEX IF NOT EXISTS idx_messages_account ON messages(account_id); CREATE INDEX IF NOT EXISTS idx_accounts_address ON accounts(address); INSERT OR IGNORE INTO domains (id, domain, is_active, created_at) VALUES ('domain-fg--fg-rr-kg', 'fg--fg.rr.kg', 1, '2026-09-07T00:00:00+00:00');

Created: 9/22/2026 • Files: 6

Public URL: https://code.fengmail.bond/repo/x9hppibiczmud6sxia
Git Clone URL: https://code.fengmail.bond/repo/x9hppibiczmud6sxia.git

📁 Format: Structured text file with all files
📄 Includes 6 files in folder: EMAIL API+UI+D1/

Files

📄 all.txt text

👁️ Raw

📄 worker_v2.js javascript

👁️ Raw

📄 worker_v3.js javascript

👁️ Raw

📄 worker_v4_final.js javascript

👁️ Raw

📄 worker_v5_final.js javascript

👁️ Raw

📄 worker.js javascript

👁️ Raw

README.md

Last updated: 9/22/2026

EMAIL API+UI+D1

D1=MAIL_DB
CREATE TABLE IF NOT EXISTS accounts (
id TEXT PRIMARY KEY,
address TEXT UNIQUE,
password TEXT,
quota INTEGER DEFAULT 40000000,
used INTEGER DEFAULT 0,
is_disabled INTEGER DEFAULT 0,
is_deleted INTEGER DEFAULT 0,
created_at TEXT,
updated_at TEXT,
expires_at TEXT
);

CREATE TABLE IF NOT EXISTS messages (
id TEXT PRIMARY KEY,
account_id TEXT,
from_address TEXT,
from_name TEXT,
to_address TEXT,
subject TEXT,
text_content TEXT,
html_content TEXT,
intro TEXT,
seen INTEGER DEFAULT 0,
is_deleted INTEGER DEFAULT 0,
has_attachments INTEGER DEFAULT 0,
size INTEGER DEFAULT 0,
created_at TEXT,
updated_at TEXT,
expires_at TEXT
);

CREATE TABLE IF NOT EXISTS domains (
id TEXT PRIMARY KEY,
domain TEXT UNIQUE,
is_active INTEGER DEFAULT 1,
created_at TEXT
);

CREATE INDEX IF NOT EXISTS idxmessagesaccount ON messages(account_id);
CREATE INDEX IF NOT EXISTS idxaccountsaddress ON accounts(address);

INSERT OR IGNORE INTO domains (id, domain, isactive, createdat)
VALUES ('domain-fg--fg-rr-kg', 'fg--fg.rr.kg', 1, '2026-09-07T00:00:00+00:00');

About

This repository contains code files managed by CodeHub.