CheckAndRemind/initialization.sql

CREATE DATABASE remind;

CREATE TABLE IF NOT EXISTS config (
    id SERIAL PRIMARY KEY,
    execution_times INTEGER DEFAULT 0,
    task_name VARCHAR(255) NOT NULL,
    description VARCHAR(255) NOT NULL,
    target_url VARCHAR(255) NOT NULL,
    target_selector VARCHAR(255) NOT NULL,
    result_value VARCHAR(255) DEFAULT '',
    execution_time TIMESTAMP DEFAULT '9999-12-31 23:59:59',
    task_interval INTEGER DEFAULT 0,
    completion_time VARCHAR(255) DEFAULT '',
    logs TEXT DEFAULT ''
);

INSERT INTO config (
    execution_times, task_name, description, target_url, target_selector,
    result_value, execution_time, task_interval, completion_time, logs
) VALUES (
    0, '任务名称', '任务说明', '目标地址', '目标css选择器',
    '', '9999-12-31 23:59:59', 0, '', ''
);