Function createApplicationMenu

main.js:2181–2367

()

      
      console.log('dateAdded column added and existing records updated');
    } else {
      console.log('dateAdded column already exists');
    }
    
    return true;
  } catch (error) {
    console.error('Error migrating dateAdded column:', error);
    return false;
  }
}

/** Add isNew column for "new until edited" badge; existing rows are not new. */
function migrateIsNewColumn() {
  try {
    console.log('Checking for isNew column migration...');
    const tableInfo = db.prepare('PRAGMA table_info(models)').all();
    const hasIsNew = tableInfo.some(col => col.name === 'isNew');
    if (!hasIsNew) {
      console.log('isNew column not found. Adding it...');
      db.prepare('ALTER TABLE models ADD COLUMN isNew INTEGER DEFAULT 1').run();
      db.prepare('UPDATE models SET isNew = 0').run();
      console.log('isNew column added; existing models marked as not new');
    } else {
      console.log('isNew column already exists');
    }
    return true;
  } catch (error) {
    console.error('Error migrating isNew column:', error);
    return false;
  }
}

/** Add rating (0-5) and favorite (0/1) columns for model engagement. */
function migrateRatingFavoriteColumns() {
  try {
    console.log('Checking for rating/favorite column migration...');
    const tableInfo = db.prepare('PRAGMA table_info(models)').all();
    const hasRating = tableInfo.some(col => col.name === 'rating');
    const hasFavorite = tableInfo.some(col => col.name === 'favorite');
    if (!hasRating) {
      console.log('rating column not found. Adding it...');
      db.prepare('ALTER TABLE models ADD COLUMN rating INTEGER DEFAULT 0').run();
      db.prepare('UPDATE models SET rating = 0 WHERE rating IS NULL').run();
    }
    if (!hasFavorite) {
      console.log('favorite column not found. Adding it...');
      db.prepare('ALTER TABLE models ADD COLUMN favorite INTEGER DEFAULT 0').run();
      db.prepare('UPDATE models SET favorite = 0 WHERE favorite IS NULL').run();
    }
    return true;
  } catch (error) {
    console.error('Error migrating rating/favorite columns:', error);
    return false;
  }
}

/** Zip bundle columns for grouped browsing (folder siblings are not bundled). */
function migrateBundleColumns() {