Fossil SCM
Remove the synclog table when doing a "fossil scrub --verily".
Commit
94709e8ed24f09cebb62b75d0d01f142092d8d28ea38c5fb51fd2447d4d57599
Parent
06b3ace4ce190c5…
1 file changed
+3
-1
+3
-1
| --- src/rebuild.c | ||
| +++ src/rebuild.c | ||
| @@ -392,13 +392,14 @@ | ||
| 392 | 392 | " WHERE type='table'" |
| 393 | 393 | " AND name NOT IN ('admin_log', 'blob','delta','rcvfrom','user','alias'," |
| 394 | 394 | "'config','shun','private','reportfmt'," |
| 395 | 395 | "'concealed','accesslog','modreq'," |
| 396 | 396 | "'purgeevent','purgeitem','unversioned'," |
| 397 | - "'subscriber','pending_alert','chat')" | |
| 397 | + "'subscriber','pending_alert','chat','synclog')" | |
| 398 | 398 | " AND name NOT GLOB 'sqlite_*'" |
| 399 | 399 | " AND name NOT GLOB 'fx_*'" |
| 400 | + " AND name NOT GLOB 'ftsidx_*'" | |
| 400 | 401 | ); |
| 401 | 402 | while( db_step(&q)==SQLITE_ROW ){ |
| 402 | 403 | blob_appendf(&sql, "DROP TABLE IF EXISTS \"%w\";\n", db_column_text(&q,0)); |
| 403 | 404 | } |
| 404 | 405 | db_finalize(&q); |
| @@ -945,10 +946,11 @@ | ||
| 945 | 946 | "DROP TABLE IF EXISTS purgeevent;\n" |
| 946 | 947 | "DROP TABLE IF EXISTS purgeitem;\n" |
| 947 | 948 | "DROP TABLE IF EXISTS admin_log;\n" |
| 948 | 949 | "DROP TABLE IF EXISTS vcache;\n" |
| 949 | 950 | "DROP TABLE IF EXISTS chat;\n" |
| 951 | + "DROP TABLE IF EXISTS synclog;\n" | |
| 950 | 952 | ); |
| 951 | 953 | } |
| 952 | 954 | db_protect_pop(); |
| 953 | 955 | } |
| 954 | 956 | if( !bNeedRebuild ){ |
| 955 | 957 |
| --- src/rebuild.c | |
| +++ src/rebuild.c | |
| @@ -392,13 +392,14 @@ | |
| 392 | " WHERE type='table'" |
| 393 | " AND name NOT IN ('admin_log', 'blob','delta','rcvfrom','user','alias'," |
| 394 | "'config','shun','private','reportfmt'," |
| 395 | "'concealed','accesslog','modreq'," |
| 396 | "'purgeevent','purgeitem','unversioned'," |
| 397 | "'subscriber','pending_alert','chat')" |
| 398 | " AND name NOT GLOB 'sqlite_*'" |
| 399 | " AND name NOT GLOB 'fx_*'" |
| 400 | ); |
| 401 | while( db_step(&q)==SQLITE_ROW ){ |
| 402 | blob_appendf(&sql, "DROP TABLE IF EXISTS \"%w\";\n", db_column_text(&q,0)); |
| 403 | } |
| 404 | db_finalize(&q); |
| @@ -945,10 +946,11 @@ | |
| 945 | "DROP TABLE IF EXISTS purgeevent;\n" |
| 946 | "DROP TABLE IF EXISTS purgeitem;\n" |
| 947 | "DROP TABLE IF EXISTS admin_log;\n" |
| 948 | "DROP TABLE IF EXISTS vcache;\n" |
| 949 | "DROP TABLE IF EXISTS chat;\n" |
| 950 | ); |
| 951 | } |
| 952 | db_protect_pop(); |
| 953 | } |
| 954 | if( !bNeedRebuild ){ |
| 955 |
| --- src/rebuild.c | |
| +++ src/rebuild.c | |
| @@ -392,13 +392,14 @@ | |
| 392 | " WHERE type='table'" |
| 393 | " AND name NOT IN ('admin_log', 'blob','delta','rcvfrom','user','alias'," |
| 394 | "'config','shun','private','reportfmt'," |
| 395 | "'concealed','accesslog','modreq'," |
| 396 | "'purgeevent','purgeitem','unversioned'," |
| 397 | "'subscriber','pending_alert','chat','synclog')" |
| 398 | " AND name NOT GLOB 'sqlite_*'" |
| 399 | " AND name NOT GLOB 'fx_*'" |
| 400 | " AND name NOT GLOB 'ftsidx_*'" |
| 401 | ); |
| 402 | while( db_step(&q)==SQLITE_ROW ){ |
| 403 | blob_appendf(&sql, "DROP TABLE IF EXISTS \"%w\";\n", db_column_text(&q,0)); |
| 404 | } |
| 405 | db_finalize(&q); |
| @@ -945,10 +946,11 @@ | |
| 946 | "DROP TABLE IF EXISTS purgeevent;\n" |
| 947 | "DROP TABLE IF EXISTS purgeitem;\n" |
| 948 | "DROP TABLE IF EXISTS admin_log;\n" |
| 949 | "DROP TABLE IF EXISTS vcache;\n" |
| 950 | "DROP TABLE IF EXISTS chat;\n" |
| 951 | "DROP TABLE IF EXISTS synclog;\n" |
| 952 | ); |
| 953 | } |
| 954 | db_protect_pop(); |
| 955 | } |
| 956 | if( !bNeedRebuild ){ |
| 957 |