Fossil

Check-in [ef3562a116]
Login

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

Overview
Comment:When ALTER'ing mlink table, create "isaux" column as boolean.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: ef3562a1169b4fda107ba2fbb16cdd0d4f012441
User & Date: jan.nijtmans 2015-01-30 10:37:25.430
Context
2015-01-30
15:57
Update SQLite to the 3.8.8.2 release check-in: 703ec175b9 user: jan.nijtmans tags: trunk
10:37
When ALTER'ing mlink table, create "isaux" column as boolean. check-in: ef3562a116 user: jan.nijtmans tags: trunk
01:16
merge [clobber_fixer] to keep "clone" and "new|init" from overwriting an existing file when setting up a new repository check-in: 89c17a86e1 user: bch tags: trunk
Changes
Unified Diff Ignore Whitespace Patch
Changes to src/db.c.
1195
1196
1197
1198
1199
1200
1201
1202
1203
1204
1205
1206
1207
1208
1209
  ** can be removed in the future, once all users have upgraded to the
  ** 2015-01-24 or later schema.
  */
  if( !db_table_has_column("repository","mlink","isaux") ){
    db_begin_transaction();
    db_multi_exec(
      "ALTER TABLE %s.mlink ADD COLUMN pmid INTEGER DEFAULT 0;"
      "ALTER TABLE %s.mlink ADD COLUMN isaux INTEGER DEFAULT 0;",
      db_name("repository"), db_name("repository")
    );
    db_end_transaction(0);
  }
}

/*







|







1195
1196
1197
1198
1199
1200
1201
1202
1203
1204
1205
1206
1207
1208
1209
  ** can be removed in the future, once all users have upgraded to the
  ** 2015-01-24 or later schema.
  */
  if( !db_table_has_column("repository","mlink","isaux") ){
    db_begin_transaction();
    db_multi_exec(
      "ALTER TABLE %s.mlink ADD COLUMN pmid INTEGER DEFAULT 0;"
      "ALTER TABLE %s.mlink ADD COLUMN isaux BOOLEAN DEFAULT 0;",
      db_name("repository"), db_name("repository")
    );
    db_end_transaction(0);
  }
}

/*