37 lines
1.3 KiB
SQL
37 lines
1.3 KiB
SQL
PRAGMA foreign_keys = ON;
|
|
|
|
UPDATE notebooks
|
|
SET
|
|
name = '工作项目',
|
|
slug = 'work-projects',
|
|
icon = 'notebook',
|
|
color = '#2563eb',
|
|
sort_order = 20,
|
|
updated_at = strftime('%Y-%m-%dT%H:%M:%fZ', 'now')
|
|
WHERE id = 'nb_projects'
|
|
AND is_deleted = 0;
|
|
|
|
INSERT INTO notebooks (id, parent_id, name, slug, icon, color, sort_order)
|
|
SELECT 'nb_projects', NULL, '工作项目', 'work-projects', 'notebook', '#2563eb', 20
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM notebooks WHERE id = 'nb_projects' OR slug = 'work-projects'
|
|
);
|
|
|
|
INSERT INTO notebooks (id, parent_id, name, slug, icon, color, sort_order)
|
|
SELECT 'nb_learning', NULL, '学习资料', 'learning-resources', 'notebook', '#7c3aed', 30
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM notebooks WHERE id = 'nb_learning' OR slug = 'learning-resources'
|
|
);
|
|
|
|
INSERT INTO notebooks (id, parent_id, name, slug, icon, color, sort_order)
|
|
SELECT 'nb_creative', NULL, '灵感创作', 'creative-ideas', 'notebook', '#db2777', 40
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM notebooks WHERE id = 'nb_creative' OR slug = 'creative-ideas'
|
|
);
|
|
|
|
INSERT INTO notebooks (id, parent_id, name, slug, icon, color, sort_order)
|
|
SELECT 'nb_personal', NULL, '生活个人', 'personal-life', 'notebook', '#ea580c', 50
|
|
WHERE NOT EXISTS (
|
|
SELECT 1 FROM notebooks WHERE id = 'nb_personal' OR slug = 'personal-life'
|
|
);
|