Glacier/database/0001_init.sql

-- 0001: 系统基础表
-- 系统核心表前缀 g_（架构约定 docs/architecture.md §3.5）

CREATE TABLE IF NOT EXISTS g_settings (
    name VARCHAR(64) NOT NULL PRIMARY KEY,
    value TEXT NULL,
    updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

INSERT INTO g_settings (name, value) VALUES
    ('site.name', 'Glacier'),
    ('site.locale', 'zh-CN'),
    ('site.timezone', 'Asia/Shanghai')
ON DUPLICATE KEY UPDATE value = VALUES(value);