42 lines
3.0 KiB
SQL
42 lines
3.0 KiB
SQL
INSERT INTO `la_ai_config` (`name`, `value`, `remark`, `create_time`, `update_time`)
|
|
SELECT 'auto_comment_enabled', '1', 'Docker AI评论总开关', UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
|
|
WHERE NOT EXISTS (SELECT 1 FROM `la_ai_config` WHERE `name` = 'auto_comment_enabled');
|
|
|
|
INSERT INTO `la_ai_config` (`name`, `value`, `remark`, `create_time`, `update_time`)
|
|
SELECT 'auto_comment_user_pool_size', '100', 'Docker AI评论虚拟账号池数量', UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
|
|
WHERE NOT EXISTS (SELECT 1 FROM `la_ai_config` WHERE `name` = 'auto_comment_user_pool_size');
|
|
|
|
INSERT INTO `la_ai_config` (`name`, `value`, `remark`, `create_time`, `update_time`)
|
|
SELECT 'auto_comment_per_run', '50', 'Docker AI评论单轮投放上限', UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
|
|
WHERE NOT EXISTS (SELECT 1 FROM `la_ai_config` WHERE `name` = 'auto_comment_per_run');
|
|
|
|
INSERT INTO `la_ai_config` (`name`, `value`, `remark`, `create_time`, `update_time`)
|
|
SELECT 'auto_comment_daily_cap', '500', 'Docker AI评论每日成功上限', UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
|
|
WHERE NOT EXISTS (SELECT 1 FROM `la_ai_config` WHERE `name` = 'auto_comment_daily_cap');
|
|
|
|
INSERT INTO `la_ai_config` (`name`, `value`, `remark`, `create_time`, `update_time`)
|
|
SELECT 'auto_comment_concurrency', '4', 'Docker AI评论并发生成数', UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
|
|
WHERE NOT EXISTS (SELECT 1 FROM `la_ai_config` WHERE `name` = 'auto_comment_concurrency');
|
|
|
|
INSERT INTO `la_ai_config` (`name`, `value`, `remark`, `create_time`, `update_time`)
|
|
SELECT 'auto_comment_request_timeout', '180', 'Docker AI评论请求超时秒数', UNIX_TIMESTAMP(), UNIX_TIMESTAMP()
|
|
WHERE NOT EXISTS (SELECT 1 FROM `la_ai_config` WHERE `name` = 'auto_comment_request_timeout');
|
|
|
|
INSERT INTO `la_ai_config` (`name`, `value`, `remark`, `create_time`, `update_time`)
|
|
SELECT
|
|
'auto_comment_article_prompt',
|
|
'你是一名专业、克制、真实的体育资讯评论员。请根据给定资讯内容生成1条中文评论，要求自然、具体、像真实用户发言，评论长度控制在20到60字之间。不要输出标题、前缀、解释、表情、标签、项目符号，不要提及自己是AI，不要复述全文。',
|
|
'Docker AI资讯评论提示词',
|
|
UNIX_TIMESTAMP(),
|
|
UNIX_TIMESTAMP()
|
|
WHERE NOT EXISTS (SELECT 1 FROM `la_ai_config` WHERE `name` = 'auto_comment_article_prompt');
|
|
|
|
INSERT INTO `la_ai_config` (`name`, `value`, `remark`, `create_time`, `update_time`)
|
|
SELECT
|
|
'auto_comment_post_prompt',
|
|
'你是一名活跃在体育与彩票社区的真实用户。请根据给定帖子内容、标签和人物设定，生成1条中文评论。评论要像真实社区回复，长度控制在18到66字之间，允许带轻微情绪和立场，但不要辱骂、不要承诺收益、不要暴露自己是AI。只输出评论正文，不要加前缀、编号、表情或话题标签。',
|
|
'Docker AI帖子评论提示词',
|
|
UNIX_TIMESTAMP(),
|
|
UNIX_TIMESTAMP()
|
|
WHERE NOT EXISTS (SELECT 1 FROM `la_ai_config` WHERE `name` = 'auto_comment_post_prompt');
|