/// SQL schema for the series_cover_page table
class SeriesCoverPageTable {
  SeriesCoverPageTable._();

  static const String tableName = 'series_cover_page';

  /// SQL statement to create the series_cover_page table
  static const String createTable = '''
    CREATE TABLE $tableName (
      series_feed_url TEXT PRIMARY KEY,
      first_page_is_cover INTEGER NOT NULL DEFAULT 1,
      created_at TEXT NOT NULL DEFAULT (datetime('now')),
      last_accessed_at TEXT NOT NULL DEFAULT (datetime('now'))
    )
  ''';

  /// SQL statement to drop the series_cover_page table
  static const String dropTable = 'DROP TABLE IF EXISTS $tableName';
}