d1-schema.sql

-- D1数据库初始化脚本
-- 这个脚本用于创建D1数据库表，不使用用户ID进行数据隔离

-- 创建memos表
CREATE TABLE IF NOT EXISTS memos (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  memo_id TEXT NOT NULL UNIQUE,
  content TEXT NOT NULL,
  tags TEXT DEFAULT '[]',
  backlinks TEXT DEFAULT '[]',
  audio_clips TEXT DEFAULT '[]',
  is_public INTEGER DEFAULT 0,
  created_at TEXT NOT NULL,
  updated_at TEXT NOT NULL
);

-- 创建user_settings表
CREATE TABLE IF NOT EXISTS user_settings (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  pinned_memos TEXT DEFAULT '[]',
  theme_color TEXT DEFAULT '#818CF8',
  dark_mode INTEGER DEFAULT 0,
  hitokoto_config TEXT DEFAULT '{"enabled":true,"types":["a","b","c","d","i","j","k"]}',
  font_config TEXT DEFAULT '{"selectedFont":"default"}',
  background_config TEXT DEFAULT '{"imageUrl":"","brightness":50,"blur":10}',
  avatar_config TEXT DEFAULT '{"imageUrl":""}',
  canvas_config TEXT DEFAULT NULL,
  music_config TEXT DEFAULT '{"enabled":true,"customSongs":[]}',
  s3_config TEXT DEFAULT '{"enabled":false,"endpoint":"","accessKeyId":"","secretAccessKey":"","bucket":"","region":"auto","publicUrl":"","provider":"r2"}',
  created_at TEXT DEFAULT CURRENT_TIMESTAMP,
  updated_at TEXT DEFAULT CURRENT_TIMESTAMP
);

-- 创建索引以提高查询性能
CREATE INDEX IF NOT EXISTS idx_memos_created_at ON memos(created_at);

-- 插入默认用户设置的示例（可选）
-- INSERT OR IGNORE INTO user_settings (pinned_memos, theme_color, dark_mode, hitokoto_config, font_config, background_config, created_at, updated_at)
-- VALUES ('[]', '#818CF8', 0, '{"enabled":true,"types":["a","b","c","d","i","j","k"]}', '{"selectedFont":"default"}', '{"imageUrl":"","brightness":50,"blur":10}', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);