/// SQL schema for the servers table
class ServersTable {
  ServersTable._();

  static const String tableName = 'servers';

  /// SQL statement to create the servers table
  static const String createTable = '''
    CREATE TABLE $tableName (
      id TEXT PRIMARY KEY,
      name TEXT NOT NULL,
      url TEXT NOT NULL,
      username TEXT,
      password TEXT,
      created_at INTEGER NOT NULL,
      last_synced_at INTEGER,
      software_type TEXT
    )
  ''';

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