15 lines
914 B
SQL
15 lines
914 B
SQL
-- ============================================
|
|
-- Admin Service 数据库初始化 (PostgreSQL)
|
|
-- ============================================
|
|
|
|
-- 此文件用于在数据库首次创建时初始化必要的数据
|
|
-- 由 Prisma migrations 创建表结构后执行
|
|
|
|
-- 示例:插入初始版本记录(如果需要)
|
|
-- INSERT INTO "AppVersion" (id, platform, "versionCode", "versionName", "buildNumber", "downloadUrl", "fileSize", "fileSha256", changelog, "isEnabled", "isForceUpdate", "createdBy", "createdAt", "updatedAt")
|
|
-- VALUES ('initial-version-id', 'android', 1, '1.0.0', '1', 'https://example.com/app.apk', 10485760, 'e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855', 'Initial version', true, false, 'system', NOW(), NOW())
|
|
-- ON CONFLICT (id) DO NOTHING;
|
|
|
|
-- 注意:目前 admin-service 不需要初始数据
|
|
-- 此文件保留用于未来可能的初始化需求
|