| |
| CREATE TABLE IF NOT EXISTS transfer_tasks |
| ( |
| task_id INTEGER PRIMARY KEY AUTOINCREMENT, |
| source_node TEXT NOT NULL DEFAULT '{}', |
| target_node TEXT NOT NULL DEFAULT '{}', |
| source_path_list TEXT NOT NULL DEFAULT '[]', |
| target_path TEXT NOT NULL, |
| task_action TEXT NOT NULL, |
| status TEXT NOT NULL, |
| default_mode TEXT NOT NULL, |
| created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, |
| started_at TIMESTAMP, |
| completed_at TIMESTAMP, |
| created_by TEXT NOT NULL, |
| target_task_id INTEGER NOT NULL, |
| is_source_node BOOLEAN NOT NULL, |
| is_target_node BOOLEAN NOT NULL |
| ); |
|
|
| |
| CREATE TABLE IF NOT EXISTS file_transfers |
| ( |
| transfer_id INTEGER PRIMARY KEY AUTOINCREMENT, |
| task_id INTEGER NOT NULL, |
| src_file TEXT NOT NULL, |
| dst_file TEXT NOT NULL, |
| file_size INTEGER NOT NULL, |
| is_dir INTEGER NOT NULL DEFAULT 0, |
| status TEXT NOT NULL, |
| progress INTEGER DEFAULT 0, |
| message TEXT NOT NULL DEFAULT '', |
| created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, |
| started_at TIMESTAMP, |
| completed_at TIMESTAMP |
| ); |
|
|
