Fossil SCM

Fix the "fossil scrub --verily" command so that it removes the purgeevent, purgeitem, and admin_log tables.

drh 2014-12-02 16:20 UTC DBP-workflow
Commit fa643f4b150ae48c8977d689d5f882fa8ea248a8
1 file changed +8 -4
+8 -4
--- src/rebuild.c
+++ src/rebuild.c
@@ -830,14 +830,18 @@
830830
"DELETE FROM config WHERE name GLOB 'skin:*';"
831831
"DELETE FROM config WHERE name GLOB 'subrepo:*';"
832832
);
833833
if( bVerily ){
834834
db_multi_exec(
835
- "DELETE FROM concealed;"
836
- "UPDATE rcvfrom SET ipaddr='unknown';"
837
- "DROP TABLE IF EXISTS accesslog;"
838
- "UPDATE user SET photo=NULL, info='';"
835
+ "DELETE FROM concealed;\n"
836
+ "UPDATE rcvfrom SET ipaddr='unknown';\n"
837
+ "DROP TABLE IF EXISTS accesslog;\n"
838
+ "UPDATE user SET photo=NULL, info='';\n"
839
+ "DROP TABLE IF EXISTS purgeevent;\n"
840
+ "DROP TABLE IF EXISTS purgeitem;\n"
841
+ "DROP TABLE IF EXISTS admin_log;\n"
842
+ "DROP TABLE IF EXISTS vcache;\n"
839843
);
840844
}
841845
}
842846
if( !bNeedRebuild ){
843847
db_end_transaction(0);
844848
--- src/rebuild.c
+++ src/rebuild.c
@@ -830,14 +830,18 @@
830 "DELETE FROM config WHERE name GLOB 'skin:*';"
831 "DELETE FROM config WHERE name GLOB 'subrepo:*';"
832 );
833 if( bVerily ){
834 db_multi_exec(
835 "DELETE FROM concealed;"
836 "UPDATE rcvfrom SET ipaddr='unknown';"
837 "DROP TABLE IF EXISTS accesslog;"
838 "UPDATE user SET photo=NULL, info='';"
 
 
 
 
839 );
840 }
841 }
842 if( !bNeedRebuild ){
843 db_end_transaction(0);
844
--- src/rebuild.c
+++ src/rebuild.c
@@ -830,14 +830,18 @@
830 "DELETE FROM config WHERE name GLOB 'skin:*';"
831 "DELETE FROM config WHERE name GLOB 'subrepo:*';"
832 );
833 if( bVerily ){
834 db_multi_exec(
835 "DELETE FROM concealed;\n"
836 "UPDATE rcvfrom SET ipaddr='unknown';\n"
837 "DROP TABLE IF EXISTS accesslog;\n"
838 "UPDATE user SET photo=NULL, info='';\n"
839 "DROP TABLE IF EXISTS purgeevent;\n"
840 "DROP TABLE IF EXISTS purgeitem;\n"
841 "DROP TABLE IF EXISTS admin_log;\n"
842 "DROP TABLE IF EXISTS vcache;\n"
843 );
844 }
845 }
846 if( !bNeedRebuild ){
847 db_end_transaction(0);
848

Keyboard Shortcuts

Open search /
Next entry (timeline) j
Previous entry (timeline) k
Open focused entry Enter
Show this help ?
Toggle theme Top nav button