d1 数据库

建表

CREATE TABLE thoughts (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    title TEXT,
    content TEXT NOT NULL,
    mood INTEGER DEFAULT 0,
    is_pinned INTEGER DEFAULT 0,
    created_at INTEGER DEFAULT (datetime('now', 'localtime')),
    updated_at INTEGER DEFAULT (datetime('now', 'localtime'))
)




CREATE TABLE thoughts_new (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    title TEXT,
    content TEXT NOT NULL,
    mood INTEGER DEFAULT 0,
    is_pinned INTEGER DEFAULT 0,
    created_at INTEGER DEFAULT (strftime('%s','now','localtime')),
    updated_at INTEGER DEFAULT (strftime('%s','now','localtime'))
);

导出数据库

npx wrangler login

npx wrangler d1 list

wrangler d1 export DB_NAME --output=backup.sql

wrangler d1 execute DB_NAME --file=backup.sql

npx wrangler logout