| |
109 |
109 |
|
| |
110 |
110 |
tStatement.Prepare(_T("CREATE TABLE subtask_scan(id BIGINT UNIQUE, current_index INT NOT NULL, is_running boolean NOT NULL, is_initialized boolean NOT NULL, total_size BIGINT NOT NULL, processed_size BIGINT NOT NULL, size_speed varchar(1024) NOT NULL, ") |
| |
111 |
111 |
_T("total_count BIGINT NOT NULL, processed_count BIGINT NOT NULL, count_speed varchar(1024) NOT NULL, ci_processed_size BIGINT NOT NULL, ci_total_size BIGINT NOT NULL, timer BIGINT NOT NULL, ") |
| |
112 |
112 |
_T("buffer_index INT NOT NULL, current_path varchar(32768) NOT NULL, ci_silent_resume boolean NOT NULL)")); |
| |
113 |
113 |
tStatement.Step(); |
| |
114 |
114 |
|
| |
115 |
115 |
tStatement.Prepare(_T("CREATE TABLE subtask_delete(id BIGINT UNIQUE, current_index INT NOT NULL, is_running boolean NOT NULL, is_initialized boolean NOT NULL, total_size BIGINT NOT NULL, processed_size BIGINT NOT NULL, size_speed varchar(1024) NOT NULL, ") |
| |
116 |
116 |
_T("total_count BIGINT NOT NULL, processed_count BIGINT NOT NULL, count_speed varchar(1024) NOT NULL, ci_processed_size BIGINT NOT NULL, ci_total_size BIGINT NOT NULL, timer BIGINT NOT NULL, ") |
| |
117 |
117 |
_T("buffer_index INT NOT NULL, current_path varchar(32768) NOT NULL, ci_silent_resume boolean NOT NULL)")); |
| |
118 |
118 |
tStatement.Step(); |
| |
119 |
119 |
|
| |
120 |
120 |
tStatement.Prepare(_T("CREATE TABLE subtask_copymove(id BIGINT UNIQUE, current_index INT NOT NULL, is_running boolean NOT NULL, is_initialized boolean NOT NULL, total_size BIGINT NOT NULL, processed_size BIGINT NOT NULL, size_speed varchar(1024) NOT NULL, ") |
| |
121 |
121 |
_T("total_count BIGINT NOT NULL, processed_count BIGINT NOT NULL, count_speed varchar(1024) NOT NULL, ci_processed_size BIGINT NOT NULL, ci_total_size BIGINT NOT NULL, timer BIGINT NOT NULL, ") |
| |
122 |
122 |
_T("buffer_index INT NOT NULL, current_path varchar(32768) NOT NULL, ci_silent_resume boolean NOT NULL)")); |
| |
123 |
123 |
tStatement.Step(); |
| |
124 |
124 |
|
| |
125 |
125 |
tStatement.Prepare(_T("CREATE TABLE feedback(id BIGINT UNIQUE, file_error INT NOT NULL, file_already_exists INT NOT NULL, not_enough_space INT NOT NULL, operation_finished INT NOT NULL, operation_error INT NOT NULL)")); |
| |
126 |
126 |
tStatement.Step(); |
| |
127 |
127 |
|
| |
128 |
128 |
|
| |
129 |
|
tVersion.SetVersion(5); |
| |
|
129 |
tVersion.SetVersion(6); |
| |
130 |
130 |
} |
| |
131 |
131 |
|
| |
132 |
132 |
void TSQLiteTaskSchema::Migrate_001_002(const sqlite::TSQLiteDatabasePtr& spDatabase, TSerializerVersion &tVersion) |
| |
133 |
133 |
{ |
| |
134 |
134 |
sqlite::TSQLiteStatement tStatement(spDatabase); |
| |
135 |
135 |
|
| |
136 |
136 |
tStatement.Prepare(_T("ALTER TABLE subtask_fastmove ADD COLUMN ci_silent_resume boolean NOT NULL DEFAULT false")); |
| |
137 |
137 |
tStatement.Step(); |
| |
138 |
138 |
tStatement.Prepare(_T("ALTER TABLE subtask_delete ADD COLUMN ci_silent_resume boolean NOT NULL DEFAULT false")); |
| |
139 |
139 |
tStatement.Step(); |
| |
140 |
140 |
tStatement.Prepare(_T("ALTER TABLE subtask_copymove ADD COLUMN ci_silent_resume boolean NOT NULL DEFAULT false")); |
| |
141 |
141 |
tStatement.Step(); |
| |
142 |
142 |
|
| |
143 |
143 |
tVersion.SetVersion(2); |
| |
144 |
144 |
} |
| |
145 |
145 |
|
| |
146 |
146 |
void TSQLiteTaskSchema::Migrate_002_003(const sqlite::TSQLiteDatabasePtr& spDatabase, TSerializerVersion &tVersion) |
| |
147 |
147 |
{ |
| |
148 |
148 |
sqlite::TSQLiteStatement tStatement(spDatabase); |
| |
149 |
149 |
|