Fossil

Check-in [b063e40725]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Do not try to drop system tables when rebuilding a repository. Ticket [7c700d2f28838490].
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: b063e40725f0ef7d36345dab3d55e8245fe4b3b7
User & Date: drh 2010-06-23 11:54:38.000
Context
2010-06-23
11:58
Fix to a "help" message. No code changes. ... (check-in: b892572644 user: drh tags: trunk)
11:54
Do not try to drop system tables when rebuilding a repository. Ticket [7c700d2f28838490]. ... (check-in: b063e40725 user: drh tags: trunk)
11:48
Merge quickstart.wiki changes into the trunk. ... (check-in: c6cfa4ebc4 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to src/rebuild.c.
212
213
214
215
216
217
218

219
220
221
222
223
224
225
  for(;;){
    zTable = db_text(0,
       "SELECT name FROM sqlite_master"
       " WHERE type='table'"
       " AND name NOT IN ('blob','delta','rcvfrom','user',"
                         "'config','shun','private','reportfmt',"
                         "'concealed')"

    );
    if( zTable==0 ) break;
    db_multi_exec("DROP TABLE %Q", zTable);
    free(zTable);
  }
  db_multi_exec(zRepositorySchema2);
  ticket_create_table(0);







>







212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
  for(;;){
    zTable = db_text(0,
       "SELECT name FROM sqlite_master"
       " WHERE type='table'"
       " AND name NOT IN ('blob','delta','rcvfrom','user',"
                         "'config','shun','private','reportfmt',"
                         "'concealed')"
       " AND name NOT GLOB 'sqlite_*'"
    );
    if( zTable==0 ) break;
    db_multi_exec("DROP TABLE %Q", zTable);
    free(zTable);
  }
  db_multi_exec(zRepositorySchema2);
  ticket_create_table(0);