refactor(db): use drift/sqlite instead of isar

diff --git a/lib/db/drift/shared_database.dart b/lib/db/drift/shared_database.dart
deleted file mode 100644
index e83028d..0000000
--- a/lib/db/drift/shared_database.dart
+++ /dev/null
@@ -1,110 +0,0 @@
-import 'package:drift/drift.dart';
-import 'package:drift_flutter/drift_flutter.dart';
-import 'package:path/path.dart' as path;
-
-import '../../utilities/stack_file_system.dart';
-
-part 'shared_database.g.dart';
-
-abstract final class SharedDrift {
-  static bool _didInit = false;
-
-  static SharedDatabase? _db;
-
-  static SharedDatabase get() {
-    if (!_didInit) {
-      driftRuntimeOptions.dontWarnAboutMultipleDatabases = true;
-      _didInit = true;
-    }
-
-    return _db ??= SharedDatabase._();
-  }
-}
-
-class CakepayOrders extends Table {
-  TextColumn get orderId => text()();
-
-  @override
-  Set<Column> get primaryKey => {orderId};
-}
-
-class ShopinBitSettings extends Table {
-  // Single row table - always row 0
-  IntColumn get id => integer().withDefault(const Constant(0))();
-
-  BoolColumn get guidelinesAccepted =>
-      boolean().withDefault(const Constant(false))();
-  BoolColumn get setupComplete =>
-      boolean().withDefault(const Constant(false))();
-  TextColumn get displayName => text().nullable()();
-
-  @override
-  Set<Column> get primaryKey => {id};
-}
-
-@DriftAccessor(tables: [ShopinBitSettings])
-class ShopinBitSettingsDao extends DatabaseAccessor<SharedDatabase>
-    with _$ShopinBitSettingsDaoMixin {
-  ShopinBitSettingsDao(super.db);
-
-  Future<ShopinBitSetting> getSettings() async {
-    final ShopinBitSetting? row = await (select(
-      shopinBitSettings,
-    )..where((t) => t.id.equals(0))).getSingleOrNull();
-    if (row != null) return row;
-
-    return into(
-      shopinBitSettings,
-    ).insertReturning(ShopinBitSettingsCompanion.insert(id: const Value(0)));
-  }
-
-  Future<void> setGuidelinesAccepted(bool accepted) =>
-      _update(ShopinBitSettingsCompanion(guidelinesAccepted: Value(accepted)));
-
-  Future<void> setSetupComplete(bool complete) =>
-      _update(ShopinBitSettingsCompanion(setupComplete: Value(complete)));
-
-  Future<void> setDisplayName(String name) =>
-      _update(ShopinBitSettingsCompanion(displayName: Value(name)));
-
-  Future<void> _update(ShopinBitSettingsCompanion changes) async {
-    await getSettings(); // ensure row exists
-    await (update(
-      shopinBitSettings,
-    )..where((t) => t.id.equals(0))).write(changes);
-  }
-}
-
-@DriftDatabase(
-  tables: [CakepayOrders, ShopinBitSettings],
-  daos: [ShopinBitSettingsDao],
-)
-final class SharedDatabase extends _$SharedDatabase {
-  SharedDatabase._([QueryExecutor? executor])
-    : super(executor ?? _openConnection());
-
-  @override
-  int get schemaVersion => 2;
-
-  @override
-  MigrationStrategy get migration => MigrationStrategy(
-    onUpgrade: (m, from, to) async {
-      if (from == 1 && to == 2) {
-        await m.createTable(shopinBitSettings);
-      }
-    },
-  );
-
-  static QueryExecutor _openConnection() {
-    return driftDatabase(
-      name: "shared",
-      native: DriftNativeOptions(
-        shareAcrossIsolates: true,
-        databasePath: () async {
-          final dir = await StackFileSystem.applicationDriftDirectory();
-          return path.join(dir.path, "shared", "shared.db");
-        },
-      ),
-    );
-  }
-}
diff --git a/lib/db/drift/shared_database.g.dart b/lib/db/drift/shared_database.g.dart
deleted file mode 100644
index 9b7d8d7..0000000
--- a/lib/db/drift/shared_database.g.dart
+++ /dev/null
@@ -1,845 +0,0 @@
-// GENERATED CODE - DO NOT MODIFY BY HAND
-
-part of 'shared_database.dart';
-
-// ignore_for_file: type=lint
-mixin _$ShopinBitSettingsDaoMixin on DatabaseAccessor<SharedDatabase> {
-  $ShopinBitSettingsTable get shopinBitSettings =>
-      attachedDatabase.shopinBitSettings;
-  ShopinBitSettingsDaoManager get managers => ShopinBitSettingsDaoManager(this);
-}
-
-class ShopinBitSettingsDaoManager {
-  final _$ShopinBitSettingsDaoMixin _db;
-  ShopinBitSettingsDaoManager(this._db);
-  $$ShopinBitSettingsTableTableManager get shopinBitSettings =>
-      $$ShopinBitSettingsTableTableManager(
-        _db.attachedDatabase,
-        _db.shopinBitSettings,
-      );
-}
-
-class $CakepayOrdersTable extends CakepayOrders
-    with TableInfo<$CakepayOrdersTable, CakepayOrder> {
-  @override
-  final GeneratedDatabase attachedDatabase;
-  final String? _alias;
-  $CakepayOrdersTable(this.attachedDatabase, [this._alias]);
-  static const VerificationMeta _orderIdMeta = const VerificationMeta(
-    'orderId',
-  );
-  @override
-  late final GeneratedColumn<String> orderId = GeneratedColumn<String>(
-    'order_id',
-    aliasedName,
-    false,
-    type: DriftSqlType.string,
-    requiredDuringInsert: true,
-  );
-  @override
-  List<GeneratedColumn> get $columns => [orderId];
-  @override
-  String get aliasedName => _alias ?? actualTableName;
-  @override
-  String get actualTableName => $name;
-  static const String $name = 'cakepay_orders';
-  @override
-  VerificationContext validateIntegrity(
-    Insertable<CakepayOrder> instance, {
-    bool isInserting = false,
-  }) {
-    final context = VerificationContext();
-    final data = instance.toColumns(true);
-    if (data.containsKey('order_id')) {
-      context.handle(
-        _orderIdMeta,
-        orderId.isAcceptableOrUnknown(data['order_id']!, _orderIdMeta),
-      );
-    } else if (isInserting) {
-      context.missing(_orderIdMeta);
-    }
-    return context;
-  }
-
-  @override
-  Set<GeneratedColumn> get $primaryKey => {orderId};
-  @override
-  CakepayOrder map(Map<String, dynamic> data, {String? tablePrefix}) {
-    final effectivePrefix = tablePrefix != null ? '$tablePrefix.' : '';
-    return CakepayOrder(
-      orderId: attachedDatabase.typeMapping.read(
-        DriftSqlType.string,
-        data['${effectivePrefix}order_id'],
-      )!,
-    );
-  }
-
-  @override
-  $CakepayOrdersTable createAlias(String alias) {
-    return $CakepayOrdersTable(attachedDatabase, alias);
-  }
-}
-
-class CakepayOrder extends DataClass implements Insertable<CakepayOrder> {
-  final String orderId;
-  const CakepayOrder({required this.orderId});
-  @override
-  Map<String, Expression> toColumns(bool nullToAbsent) {
-    final map = <String, Expression>{};
-    map['order_id'] = Variable<String>(orderId);
-    return map;
-  }
-
-  CakepayOrdersCompanion toCompanion(bool nullToAbsent) {
-    return CakepayOrdersCompanion(orderId: Value(orderId));
-  }
-
-  factory CakepayOrder.fromJson(
-    Map<String, dynamic> json, {
-    ValueSerializer? serializer,
-  }) {
-    serializer ??= driftRuntimeOptions.defaultSerializer;
-    return CakepayOrder(orderId: serializer.fromJson<String>(json['orderId']));
-  }
-  @override
-  Map<String, dynamic> toJson({ValueSerializer? serializer}) {
-    serializer ??= driftRuntimeOptions.defaultSerializer;
-    return <String, dynamic>{'orderId': serializer.toJson<String>(orderId)};
-  }
-
-  CakepayOrder copyWith({String? orderId}) =>
-      CakepayOrder(orderId: orderId ?? this.orderId);
-  CakepayOrder copyWithCompanion(CakepayOrdersCompanion data) {
-    return CakepayOrder(
-      orderId: data.orderId.present ? data.orderId.value : this.orderId,
-    );
-  }
-
-  @override
-  String toString() {
-    return (StringBuffer('CakepayOrder(')
-          ..write('orderId: $orderId')
-          ..write(')'))
-        .toString();
-  }
-
-  @override
-  int get hashCode => orderId.hashCode;
-  @override
-  bool operator ==(Object other) =>
-      identical(this, other) ||
-      (other is CakepayOrder && other.orderId == this.orderId);
-}
-
-class CakepayOrdersCompanion extends UpdateCompanion<CakepayOrder> {
-  final Value<String> orderId;
-  final Value<int> rowid;
-  const CakepayOrdersCompanion({
-    this.orderId = const Value.absent(),
-    this.rowid = const Value.absent(),
-  });
-  CakepayOrdersCompanion.insert({
-    required String orderId,
-    this.rowid = const Value.absent(),
-  }) : orderId = Value(orderId);
-  static Insertable<CakepayOrder> custom({
-    Expression<String>? orderId,
-    Expression<int>? rowid,
-  }) {
-    return RawValuesInsertable({
-      if (orderId != null) 'order_id': orderId,
-      if (rowid != null) 'rowid': rowid,
-    });
-  }
-
-  CakepayOrdersCompanion copyWith({Value<String>? orderId, Value<int>? rowid}) {
-    return CakepayOrdersCompanion(
-      orderId: orderId ?? this.orderId,
-      rowid: rowid ?? this.rowid,
-    );
-  }
-
-  @override
-  Map<String, Expression> toColumns(bool nullToAbsent) {
-    final map = <String, Expression>{};
-    if (orderId.present) {
-      map['order_id'] = Variable<String>(orderId.value);
-    }
-    if (rowid.present) {
-      map['rowid'] = Variable<int>(rowid.value);
-    }
-    return map;
-  }
-
-  @override
-  String toString() {
-    return (StringBuffer('CakepayOrdersCompanion(')
-          ..write('orderId: $orderId, ')
-          ..write('rowid: $rowid')
-          ..write(')'))
-        .toString();
-  }
-}
-
-class $ShopinBitSettingsTable extends ShopinBitSettings
-    with TableInfo<$ShopinBitSettingsTable, ShopinBitSetting> {
-  @override
-  final GeneratedDatabase attachedDatabase;
-  final String? _alias;
-  $ShopinBitSettingsTable(this.attachedDatabase, [this._alias]);
-  static const VerificationMeta _idMeta = const VerificationMeta('id');
-  @override
-  late final GeneratedColumn<int> id = GeneratedColumn<int>(
-    'id',
-    aliasedName,
-    false,
-    type: DriftSqlType.int,
-    requiredDuringInsert: false,
-    defaultValue: const Constant(0),
-  );
-  static const VerificationMeta _guidelinesAcceptedMeta =
-      const VerificationMeta('guidelinesAccepted');
-  @override
-  late final GeneratedColumn<bool> guidelinesAccepted = GeneratedColumn<bool>(
-    'guidelines_accepted',
-    aliasedName,
-    false,
-    type: DriftSqlType.bool,
-    requiredDuringInsert: false,
-    defaultConstraints: GeneratedColumn.constraintIsAlways(
-      'CHECK ("guidelines_accepted" IN (0, 1))',
-    ),
-    defaultValue: const Constant(false),
-  );
-  static const VerificationMeta _setupCompleteMeta = const VerificationMeta(
-    'setupComplete',
-  );
-  @override
-  late final GeneratedColumn<bool> setupComplete = GeneratedColumn<bool>(
-    'setup_complete',
-    aliasedName,
-    false,
-    type: DriftSqlType.bool,
-    requiredDuringInsert: false,
-    defaultConstraints: GeneratedColumn.constraintIsAlways(
-      'CHECK ("setup_complete" IN (0, 1))',
-    ),
-    defaultValue: const Constant(false),
-  );
-  static const VerificationMeta _displayNameMeta = const VerificationMeta(
-    'displayName',
-  );
-  @override
-  late final GeneratedColumn<String> displayName = GeneratedColumn<String>(
-    'display_name',
-    aliasedName,
-    true,
-    type: DriftSqlType.string,
-    requiredDuringInsert: false,
-  );
-  @override
-  List<GeneratedColumn> get $columns => [
-    id,
-    guidelinesAccepted,
-    setupComplete,
-    displayName,
-  ];
-  @override
-  String get aliasedName => _alias ?? actualTableName;
-  @override
-  String get actualTableName => $name;
-  static const String $name = 'shopin_bit_settings';
-  @override
-  VerificationContext validateIntegrity(
-    Insertable<ShopinBitSetting> instance, {
-    bool isInserting = false,
-  }) {
-    final context = VerificationContext();
-    final data = instance.toColumns(true);
-    if (data.containsKey('id')) {
-      context.handle(_idMeta, id.isAcceptableOrUnknown(data['id']!, _idMeta));
-    }
-    if (data.containsKey('guidelines_accepted')) {
-      context.handle(
-        _guidelinesAcceptedMeta,
-        guidelinesAccepted.isAcceptableOrUnknown(
-          data['guidelines_accepted']!,
-          _guidelinesAcceptedMeta,
-        ),
-      );
-    }
-    if (data.containsKey('setup_complete')) {
-      context.handle(
-        _setupCompleteMeta,
-        setupComplete.isAcceptableOrUnknown(
-          data['setup_complete']!,
-          _setupCompleteMeta,
-        ),
-      );
-    }
-    if (data.containsKey('display_name')) {
-      context.handle(
-        _displayNameMeta,
-        displayName.isAcceptableOrUnknown(
-          data['display_name']!,
-          _displayNameMeta,
-        ),
-      );
-    }
-    return context;
-  }
-
-  @override
-  Set<GeneratedColumn> get $primaryKey => {id};
-  @override
-  ShopinBitSetting map(Map<String, dynamic> data, {String? tablePrefix}) {
-    final effectivePrefix = tablePrefix != null ? '$tablePrefix.' : '';
-    return ShopinBitSetting(
-      id: attachedDatabase.typeMapping.read(
-        DriftSqlType.int,
-        data['${effectivePrefix}id'],
-      )!,
-      guidelinesAccepted: attachedDatabase.typeMapping.read(
-        DriftSqlType.bool,
-        data['${effectivePrefix}guidelines_accepted'],
-      )!,
-      setupComplete: attachedDatabase.typeMapping.read(
-        DriftSqlType.bool,
-        data['${effectivePrefix}setup_complete'],
-      )!,
-      displayName: attachedDatabase.typeMapping.read(
-        DriftSqlType.string,
-        data['${effectivePrefix}display_name'],
-      ),
-    );
-  }
-
-  @override
-  $ShopinBitSettingsTable createAlias(String alias) {
-    return $ShopinBitSettingsTable(attachedDatabase, alias);
-  }
-}
-
-class ShopinBitSetting extends DataClass
-    implements Insertable<ShopinBitSetting> {
-  final int id;
-  final bool guidelinesAccepted;
-  final bool setupComplete;
-  final String? displayName;
-  const ShopinBitSetting({
-    required this.id,
-    required this.guidelinesAccepted,
-    required this.setupComplete,
-    this.displayName,
-  });
-  @override
-  Map<String, Expression> toColumns(bool nullToAbsent) {
-    final map = <String, Expression>{};
-    map['id'] = Variable<int>(id);
-    map['guidelines_accepted'] = Variable<bool>(guidelinesAccepted);
-    map['setup_complete'] = Variable<bool>(setupComplete);
-    if (!nullToAbsent || displayName != null) {
-      map['display_name'] = Variable<String>(displayName);
-    }
-    return map;
-  }
-
-  ShopinBitSettingsCompanion toCompanion(bool nullToAbsent) {
-    return ShopinBitSettingsCompanion(
-      id: Value(id),
-      guidelinesAccepted: Value(guidelinesAccepted),
-      setupComplete: Value(setupComplete),
-      displayName: displayName == null && nullToAbsent
-          ? const Value.absent()
-          : Value(displayName),
-    );
-  }
-
-  factory ShopinBitSetting.fromJson(
-    Map<String, dynamic> json, {
-    ValueSerializer? serializer,
-  }) {
-    serializer ??= driftRuntimeOptions.defaultSerializer;
-    return ShopinBitSetting(
-      id: serializer.fromJson<int>(json['id']),
-      guidelinesAccepted: serializer.fromJson<bool>(json['guidelinesAccepted']),
-      setupComplete: serializer.fromJson<bool>(json['setupComplete']),
-      displayName: serializer.fromJson<String?>(json['displayName']),
-    );
-  }
-  @override
-  Map<String, dynamic> toJson({ValueSerializer? serializer}) {
-    serializer ??= driftRuntimeOptions.defaultSerializer;
-    return <String, dynamic>{
-      'id': serializer.toJson<int>(id),
-      'guidelinesAccepted': serializer.toJson<bool>(guidelinesAccepted),
-      'setupComplete': serializer.toJson<bool>(setupComplete),
-      'displayName': serializer.toJson<String?>(displayName),
-    };
-  }
-
-  ShopinBitSetting copyWith({
-    int? id,
-    bool? guidelinesAccepted,
-    bool? setupComplete,
-    Value<String?> displayName = const Value.absent(),
-  }) => ShopinBitSetting(
-    id: id ?? this.id,
-    guidelinesAccepted: guidelinesAccepted ?? this.guidelinesAccepted,
-    setupComplete: setupComplete ?? this.setupComplete,
-    displayName: displayName.present ? displayName.value : this.displayName,
-  );
-  ShopinBitSetting copyWithCompanion(ShopinBitSettingsCompanion data) {
-    return ShopinBitSetting(
-      id: data.id.present ? data.id.value : this.id,
-      guidelinesAccepted: data.guidelinesAccepted.present
-          ? data.guidelinesAccepted.value
-          : this.guidelinesAccepted,
-      setupComplete: data.setupComplete.present
-          ? data.setupComplete.value
-          : this.setupComplete,
-      displayName: data.displayName.present
-          ? data.displayName.value
-          : this.displayName,
-    );
-  }
-
-  @override
-  String toString() {
-    return (StringBuffer('ShopinBitSetting(')
-          ..write('id: $id, ')
-          ..write('guidelinesAccepted: $guidelinesAccepted, ')
-          ..write('setupComplete: $setupComplete, ')
-          ..write('displayName: $displayName')
-          ..write(')'))
-        .toString();
-  }
-
-  @override
-  int get hashCode =>
-      Object.hash(id, guidelinesAccepted, setupComplete, displayName);
-  @override
-  bool operator ==(Object other) =>
-      identical(this, other) ||
-      (other is ShopinBitSetting &&
-          other.id == this.id &&
-          other.guidelinesAccepted == this.guidelinesAccepted &&
-          other.setupComplete == this.setupComplete &&
-          other.displayName == this.displayName);
-}
-
-class ShopinBitSettingsCompanion extends UpdateCompanion<ShopinBitSetting> {
-  final Value<int> id;
-  final Value<bool> guidelinesAccepted;
-  final Value<bool> setupComplete;
-  final Value<String?> displayName;
-  const ShopinBitSettingsCompanion({
-    this.id = const Value.absent(),
-    this.guidelinesAccepted = const Value.absent(),
-    this.setupComplete = const Value.absent(),
-    this.displayName = const Value.absent(),
-  });
-  ShopinBitSettingsCompanion.insert({
-    this.id = const Value.absent(),
-    this.guidelinesAccepted = const Value.absent(),
-    this.setupComplete = const Value.absent(),
-    this.displayName = const Value.absent(),
-  });
-  static Insertable<ShopinBitSetting> custom({
-    Expression<int>? id,
-    Expression<bool>? guidelinesAccepted,
-    Expression<bool>? setupComplete,
-    Expression<String>? displayName,
-  }) {
-    return RawValuesInsertable({
-      if (id != null) 'id': id,
-      if (guidelinesAccepted != null) 'guidelines_accepted': guidelinesAccepted,
-      if (setupComplete != null) 'setup_complete': setupComplete,
-      if (displayName != null) 'display_name': displayName,
-    });
-  }
-
-  ShopinBitSettingsCompanion copyWith({
-    Value<int>? id,
-    Value<bool>? guidelinesAccepted,
-    Value<bool>? setupComplete,
-    Value<String?>? displayName,
-  }) {
-    return ShopinBitSettingsCompanion(
-      id: id ?? this.id,
-      guidelinesAccepted: guidelinesAccepted ?? this.guidelinesAccepted,
-      setupComplete: setupComplete ?? this.setupComplete,
-      displayName: displayName ?? this.displayName,
-    );
-  }
-
-  @override
-  Map<String, Expression> toColumns(bool nullToAbsent) {
-    final map = <String, Expression>{};
-    if (id.present) {
-      map['id'] = Variable<int>(id.value);
-    }
-    if (guidelinesAccepted.present) {
-      map['guidelines_accepted'] = Variable<bool>(guidelinesAccepted.value);
-    }
-    if (setupComplete.present) {
-      map['setup_complete'] = Variable<bool>(setupComplete.value);
-    }
-    if (displayName.present) {
-      map['display_name'] = Variable<String>(displayName.value);
-    }
-    return map;
-  }
-
-  @override
-  String toString() {
-    return (StringBuffer('ShopinBitSettingsCompanion(')
-          ..write('id: $id, ')
-          ..write('guidelinesAccepted: $guidelinesAccepted, ')
-          ..write('setupComplete: $setupComplete, ')
-          ..write('displayName: $displayName')
-          ..write(')'))
-        .toString();
-  }
-}
-
-abstract class _$SharedDatabase extends GeneratedDatabase {
-  _$SharedDatabase(QueryExecutor e) : super(e);
-  $SharedDatabaseManager get managers => $SharedDatabaseManager(this);
-  late final $CakepayOrdersTable cakepayOrders = $CakepayOrdersTable(this);
-  late final $ShopinBitSettingsTable shopinBitSettings =
-      $ShopinBitSettingsTable(this);
-  late final ShopinBitSettingsDao shopinBitSettingsDao = ShopinBitSettingsDao(
-    this as SharedDatabase,
-  );
-  @override
-  Iterable<TableInfo<Table, Object?>> get allTables =>
-      allSchemaEntities.whereType<TableInfo<Table, Object?>>();
-  @override
-  List<DatabaseSchemaEntity> get allSchemaEntities => [
-    cakepayOrders,
-    shopinBitSettings,
-  ];
-}
-
-typedef $$CakepayOrdersTableCreateCompanionBuilder =
-    CakepayOrdersCompanion Function({
-      required String orderId,
-      Value<int> rowid,
-    });
-typedef $$CakepayOrdersTableUpdateCompanionBuilder =
-    CakepayOrdersCompanion Function({Value<String> orderId, Value<int> rowid});
-
-class $$CakepayOrdersTableFilterComposer
-    extends Composer<_$SharedDatabase, $CakepayOrdersTable> {
-  $$CakepayOrdersTableFilterComposer({
-    required super.$db,
-    required super.$table,
-    super.joinBuilder,
-    super.$addJoinBuilderToRootComposer,
-    super.$removeJoinBuilderFromRootComposer,
-  });
-  ColumnFilters<String> get orderId => $composableBuilder(
-    column: $table.orderId,
-    builder: (column) => ColumnFilters(column),
-  );
-}
-
-class $$CakepayOrdersTableOrderingComposer
-    extends Composer<_$SharedDatabase, $CakepayOrdersTable> {
-  $$CakepayOrdersTableOrderingComposer({
-    required super.$db,
-    required super.$table,
-    super.joinBuilder,
-    super.$addJoinBuilderToRootComposer,
-    super.$removeJoinBuilderFromRootComposer,
-  });
-  ColumnOrderings<String> get orderId => $composableBuilder(
-    column: $table.orderId,
-    builder: (column) => ColumnOrderings(column),
-  );
-}
-
-class $$CakepayOrdersTableAnnotationComposer
-    extends Composer<_$SharedDatabase, $CakepayOrdersTable> {
-  $$CakepayOrdersTableAnnotationComposer({
-    required super.$db,
-    required super.$table,
-    super.joinBuilder,
-    super.$addJoinBuilderToRootComposer,
-    super.$removeJoinBuilderFromRootComposer,
-  });
-  GeneratedColumn<String> get orderId =>
-      $composableBuilder(column: $table.orderId, builder: (column) => column);
-}
-
-class $$CakepayOrdersTableTableManager
-    extends
-        RootTableManager<
-          _$SharedDatabase,
-          $CakepayOrdersTable,
-          CakepayOrder,
-          $$CakepayOrdersTableFilterComposer,
-          $$CakepayOrdersTableOrderingComposer,
-          $$CakepayOrdersTableAnnotationComposer,
-          $$CakepayOrdersTableCreateCompanionBuilder,
-          $$CakepayOrdersTableUpdateCompanionBuilder,
-          (
-            CakepayOrder,
-            BaseReferences<_$SharedDatabase, $CakepayOrdersTable, CakepayOrder>,
-          ),
-          CakepayOrder,
-          PrefetchHooks Function()
-        > {
-  $$CakepayOrdersTableTableManager(
-    _$SharedDatabase db,
-    $CakepayOrdersTable table,
-  ) : super(
-        TableManagerState(
-          db: db,
-          table: table,
-          createFilteringComposer: () =>
-              $$CakepayOrdersTableFilterComposer($db: db, $table: table),
-          createOrderingComposer: () =>
-              $$CakepayOrdersTableOrderingComposer($db: db, $table: table),
-          createComputedFieldComposer: () =>
-              $$CakepayOrdersTableAnnotationComposer($db: db, $table: table),
-          updateCompanionCallback:
-              ({
-                Value<String> orderId = const Value.absent(),
-                Value<int> rowid = const Value.absent(),
-              }) => CakepayOrdersCompanion(orderId: orderId, rowid: rowid),
-          createCompanionCallback:
-              ({
-                required String orderId,
-                Value<int> rowid = const Value.absent(),
-              }) =>
-                  CakepayOrdersCompanion.insert(orderId: orderId, rowid: rowid),
-          withReferenceMapper: (p0) => p0
-              .map((e) => (e.readTable(table), BaseReferences(db, table, e)))
-              .toList(),
-          prefetchHooksCallback: null,
-        ),
-      );
-}
-
-typedef $$CakepayOrdersTableProcessedTableManager =
-    ProcessedTableManager<
-      _$SharedDatabase,
-      $CakepayOrdersTable,
-      CakepayOrder,
-      $$CakepayOrdersTableFilterComposer,
-      $$CakepayOrdersTableOrderingComposer,
-      $$CakepayOrdersTableAnnotationComposer,
-      $$CakepayOrdersTableCreateCompanionBuilder,
-      $$CakepayOrdersTableUpdateCompanionBuilder,
-      (
-        CakepayOrder,
-        BaseReferences<_$SharedDatabase, $CakepayOrdersTable, CakepayOrder>,
-      ),
-      CakepayOrder,
-      PrefetchHooks Function()
-    >;
-typedef $$ShopinBitSettingsTableCreateCompanionBuilder =
-    ShopinBitSettingsCompanion Function({
-      Value<int> id,
-      Value<bool> guidelinesAccepted,
-      Value<bool> setupComplete,
-      Value<String?> displayName,
-    });
-typedef $$ShopinBitSettingsTableUpdateCompanionBuilder =
-    ShopinBitSettingsCompanion Function({
-      Value<int> id,
-      Value<bool> guidelinesAccepted,
-      Value<bool> setupComplete,
-      Value<String?> displayName,
-    });
-
-class $$ShopinBitSettingsTableFilterComposer
-    extends Composer<_$SharedDatabase, $ShopinBitSettingsTable> {
-  $$ShopinBitSettingsTableFilterComposer({
-    required super.$db,
-    required super.$table,
-    super.joinBuilder,
-    super.$addJoinBuilderToRootComposer,
-    super.$removeJoinBuilderFromRootComposer,
-  });
-  ColumnFilters<int> get id => $composableBuilder(
-    column: $table.id,
-    builder: (column) => ColumnFilters(column),
-  );
-
-  ColumnFilters<bool> get guidelinesAccepted => $composableBuilder(
-    column: $table.guidelinesAccepted,
-    builder: (column) => ColumnFilters(column),
-  );
-
-  ColumnFilters<bool> get setupComplete => $composableBuilder(
-    column: $table.setupComplete,
-    builder: (column) => ColumnFilters(column),
-  );
-
-  ColumnFilters<String> get displayName => $composableBuilder(
-    column: $table.displayName,
-    builder: (column) => ColumnFilters(column),
-  );
-}
-
-class $$ShopinBitSettingsTableOrderingComposer
-    extends Composer<_$SharedDatabase, $ShopinBitSettingsTable> {
-  $$ShopinBitSettingsTableOrderingComposer({
-    required super.$db,
-    required super.$table,
-    super.joinBuilder,
-    super.$addJoinBuilderToRootComposer,
-    super.$removeJoinBuilderFromRootComposer,
-  });
-  ColumnOrderings<int> get id => $composableBuilder(
-    column: $table.id,
-    builder: (column) => ColumnOrderings(column),
-  );
-
-  ColumnOrderings<bool> get guidelinesAccepted => $composableBuilder(
-    column: $table.guidelinesAccepted,
-    builder: (column) => ColumnOrderings(column),
-  );
-
-  ColumnOrderings<bool> get setupComplete => $composableBuilder(
-    column: $table.setupComplete,
-    builder: (column) => ColumnOrderings(column),
-  );
-
-  ColumnOrderings<String> get displayName => $composableBuilder(
-    column: $table.displayName,
-    builder: (column) => ColumnOrderings(column),
-  );
-}
-
-class $$ShopinBitSettingsTableAnnotationComposer
-    extends Composer<_$SharedDatabase, $ShopinBitSettingsTable> {
-  $$ShopinBitSettingsTableAnnotationComposer({
-    required super.$db,
-    required super.$table,
-    super.joinBuilder,
-    super.$addJoinBuilderToRootComposer,
-    super.$removeJoinBuilderFromRootComposer,
-  });
-  GeneratedColumn<int> get id =>
-      $composableBuilder(column: $table.id, builder: (column) => column);
-
-  GeneratedColumn<bool> get guidelinesAccepted => $composableBuilder(
-    column: $table.guidelinesAccepted,
-    builder: (column) => column,
-  );
-
-  GeneratedColumn<bool> get setupComplete => $composableBuilder(
-    column: $table.setupComplete,
-    builder: (column) => column,
-  );
-
-  GeneratedColumn<String> get displayName => $composableBuilder(
-    column: $table.displayName,
-    builder: (column) => column,
-  );
-}
-
-class $$ShopinBitSettingsTableTableManager
-    extends
-        RootTableManager<
-          _$SharedDatabase,
-          $ShopinBitSettingsTable,
-          ShopinBitSetting,
-          $$ShopinBitSettingsTableFilterComposer,
-          $$ShopinBitSettingsTableOrderingComposer,
-          $$ShopinBitSettingsTableAnnotationComposer,
-          $$ShopinBitSettingsTableCreateCompanionBuilder,
-          $$ShopinBitSettingsTableUpdateCompanionBuilder,
-          (
-            ShopinBitSetting,
-            BaseReferences<
-              _$SharedDatabase,
-              $ShopinBitSettingsTable,
-              ShopinBitSetting
-            >,
-          ),
-          ShopinBitSetting,
-          PrefetchHooks Function()
-        > {
-  $$ShopinBitSettingsTableTableManager(
-    _$SharedDatabase db,
-    $ShopinBitSettingsTable table,
-  ) : super(
-        TableManagerState(
-          db: db,
-          table: table,
-          createFilteringComposer: () =>
-              $$ShopinBitSettingsTableFilterComposer($db: db, $table: table),
-          createOrderingComposer: () =>
-              $$ShopinBitSettingsTableOrderingComposer($db: db, $table: table),
-          createComputedFieldComposer: () =>
-              $$ShopinBitSettingsTableAnnotationComposer(
-                $db: db,
-                $table: table,
-              ),
-          updateCompanionCallback:
-              ({
-                Value<int> id = const Value.absent(),
-                Value<bool> guidelinesAccepted = const Value.absent(),
-                Value<bool> setupComplete = const Value.absent(),
-                Value<String?> displayName = const Value.absent(),
-              }) => ShopinBitSettingsCompanion(
-                id: id,
-                guidelinesAccepted: guidelinesAccepted,
-                setupComplete: setupComplete,
-                displayName: displayName,
-              ),
-          createCompanionCallback:
-              ({
-                Value<int> id = const Value.absent(),
-                Value<bool> guidelinesAccepted = const Value.absent(),
-                Value<bool> setupComplete = const Value.absent(),
-                Value<String?> displayName = const Value.absent(),
-              }) => ShopinBitSettingsCompanion.insert(
-                id: id,
-                guidelinesAccepted: guidelinesAccepted,
-                setupComplete: setupComplete,
-                displayName: displayName,
-              ),
-          withReferenceMapper: (p0) => p0
-              .map((e) => (e.readTable(table), BaseReferences(db, table, e)))
-              .toList(),
-          prefetchHooksCallback: null,
-        ),
-      );
-}
-
-typedef $$ShopinBitSettingsTableProcessedTableManager =
-    ProcessedTableManager<
-      _$SharedDatabase,
-      $ShopinBitSettingsTable,
-      ShopinBitSetting,
-      $$ShopinBitSettingsTableFilterComposer,
-      $$ShopinBitSettingsTableOrderingComposer,
-      $$ShopinBitSettingsTableAnnotationComposer,
-      $$ShopinBitSettingsTableCreateCompanionBuilder,
-      $$ShopinBitSettingsTableUpdateCompanionBuilder,
-      (
-        ShopinBitSetting,
-        BaseReferences<
-          _$SharedDatabase,
-          $ShopinBitSettingsTable,
-          ShopinBitSetting
-        >,
-      ),
-      ShopinBitSetting,
-      PrefetchHooks Function()
-    >;
-
-class $SharedDatabaseManager {
-  final _$SharedDatabase _db;
-  $SharedDatabaseManager(this._db);
-  $$CakepayOrdersTableTableManager get cakepayOrders =>
-      $$CakepayOrdersTableTableManager(_db, _db.cakepayOrders);
-  $$ShopinBitSettingsTableTableManager get shopinBitSettings =>
-      $$ShopinBitSettingsTableTableManager(_db, _db.shopinBitSettings);
-}
diff --git a/lib/db/drift/shared_db/shared_database.dart b/lib/db/drift/shared_db/shared_database.dart
new file mode 100644
index 0000000..fa6f94e
--- /dev/null
+++ b/lib/db/drift/shared_db/shared_database.dart
@@ -0,0 +1,95 @@
+import 'package:drift/drift.dart';
+import 'package:drift_flutter/drift_flutter.dart';
+import 'package:path/path.dart' as path;
+
+import '../../../models/shopinbit/shopinbit_order_model.dart'
+    show ShopInBitCategory, ShopInBitOrderStatus;
+import '../../../utilities/stack_file_system.dart';
+import 'tables/cakepay_orders.dart';
+import 'tables/shopin_bit_settings.dart';
+import 'tables/shopin_bit_tickets.dart';
+
+part 'shared_database.g.dart';
+
+abstract final class SharedDrift {
+  static bool _didInit = false;
+
+  static SharedDatabase? _db;
+
+  static SharedDatabase get() {
+    if (!_didInit) {
+      driftRuntimeOptions.dontWarnAboutMultipleDatabases = true;
+      _didInit = true;
+    }
+
+    return _db ??= SharedDatabase._();
+  }
+}
+
+@DriftDatabase(
+  tables: [CakepayOrders, ShopinBitSettings, ShopInBitTickets],
+  daos: [ShopinBitSettingsDao],
+)
+final class SharedDatabase extends _$SharedDatabase {
+  SharedDatabase._([QueryExecutor? executor])
+    : super(executor ?? _openConnection());
+
+  @override
+  int get schemaVersion => 2;
+
+  @override
+  MigrationStrategy get migration => MigrationStrategy(
+    onUpgrade: (m, from, to) async {
+      if (from == 1 && to == 2) {
+        await m.createTable(shopinBitSettings);
+        await m.createTable(shopInBitTickets);
+      }
+    },
+  );
+
+  static QueryExecutor _openConnection() {
+    return driftDatabase(
+      name: "shared",
+      native: DriftNativeOptions(
+        shareAcrossIsolates: true,
+        databasePath: () async {
+          final dir = await StackFileSystem.applicationDriftDirectory();
+          return path.join(dir.path, "shared", "shared.db");
+        },
+      ),
+    );
+  }
+}
+
+@DriftAccessor(tables: [ShopinBitSettings])
+class ShopinBitSettingsDao extends DatabaseAccessor<SharedDatabase>
+    with _$ShopinBitSettingsDaoMixin {
+  ShopinBitSettingsDao(super.db);
+
+  Future<ShopinBitSetting> getSettings() async {
+    final ShopinBitSetting? row = await (select(
+      shopinBitSettings,
+    )..where((t) => t.id.equals(0))).getSingleOrNull();
+    if (row != null) return row;
+
+    return into(
+      shopinBitSettings,
+    ).insertReturning(ShopinBitSettingsCompanion.insert(id: const Value(0)));
+  }
+
+  Future<void> setGuidelinesAccepted(bool accepted) =>
+      _update(ShopinBitSettingsCompanion(guidelinesAccepted: Value(accepted)));
+
+  Future<void> setSetupComplete(bool complete) =>
+      _update(ShopinBitSettingsCompanion(setupComplete: Value(complete)));
+
+  Future<void> setDisplayName(String name) =>
+      _update(ShopinBitSettingsCompanion(displayName: Value(name)));
+
+  Future<void> _update(ShopinBitSettingsCompanion changes) async {
+    await getSettings(); // ensure row exists
+    await (update(
+      shopinBitSettings,
+    )..where((t) => t.id.equals(0))).write(changes);
+  }
+}
diff --git a/lib/db/drift/shared_db/shared_database.g.dart b/lib/db/drift/shared_db/shared_database.g.dart
new file mode 100644
index 0000000..24a3c83
--- /dev/null
+++ b/lib/db/drift/shared_db/shared_database.g.dart
@@ -0,0 +1,2854 @@
+// GENERATED CODE - DO NOT MODIFY BY HAND
+
+part of 'shared_database.dart';
+
+// ignore_for_file: type=lint
+class $CakepayOrdersTable extends CakepayOrders
+    with TableInfo<$CakepayOrdersTable, CakepayOrder> {
+  @override
+  final GeneratedDatabase attachedDatabase;
+  final String? _alias;
+  $CakepayOrdersTable(this.attachedDatabase, [this._alias]);
+  static const VerificationMeta _orderIdMeta = const VerificationMeta(
+    'orderId',
+  );
+  @override
+  late final GeneratedColumn<String> orderId = GeneratedColumn<String>(
+    'order_id',
+    aliasedName,
+    false,
+    type: DriftSqlType.string,
+    requiredDuringInsert: true,
+  );
+  @override
+  List<GeneratedColumn> get $columns => [orderId];
+  @override
+  String get aliasedName => _alias ?? actualTableName;
+  @override
+  String get actualTableName => $name;
+  static const String $name = 'cakepay_orders';
+  @override
+  VerificationContext validateIntegrity(
+    Insertable<CakepayOrder> instance, {
+    bool isInserting = false,
+  }) {
+    final context = VerificationContext();
+    final data = instance.toColumns(true);
+    if (data.containsKey('order_id')) {
+      context.handle(
+        _orderIdMeta,
+        orderId.isAcceptableOrUnknown(data['order_id']!, _orderIdMeta),
+      );
+    } else if (isInserting) {
+      context.missing(_orderIdMeta);
+    }
+    return context;
+  }
+
+  @override
+  Set<GeneratedColumn> get $primaryKey => {orderId};
+  @override
+  CakepayOrder map(Map<String, dynamic> data, {String? tablePrefix}) {
+    final effectivePrefix = tablePrefix != null ? '$tablePrefix.' : '';
+    return CakepayOrder(
+      orderId: attachedDatabase.typeMapping.read(
+        DriftSqlType.string,
+        data['${effectivePrefix}order_id'],
+      )!,
+    );
+  }
+
+  @override
+  $CakepayOrdersTable createAlias(String alias) {
+    return $CakepayOrdersTable(attachedDatabase, alias);
+  }
+}
+
+class CakepayOrder extends DataClass implements Insertable<CakepayOrder> {
+  final String orderId;
+  const CakepayOrder({required this.orderId});
+  @override
+  Map<String, Expression> toColumns(bool nullToAbsent) {
+    final map = <String, Expression>{};
+    map['order_id'] = Variable<String>(orderId);
+    return map;
+  }
+
+  CakepayOrdersCompanion toCompanion(bool nullToAbsent) {
+    return CakepayOrdersCompanion(orderId: Value(orderId));
+  }
+
+  factory CakepayOrder.fromJson(
+    Map<String, dynamic> json, {
+    ValueSerializer? serializer,
+  }) {
+    serializer ??= driftRuntimeOptions.defaultSerializer;
+    return CakepayOrder(orderId: serializer.fromJson<String>(json['orderId']));
+  }
+  @override
+  Map<String, dynamic> toJson({ValueSerializer? serializer}) {
+    serializer ??= driftRuntimeOptions.defaultSerializer;
+    return <String, dynamic>{'orderId': serializer.toJson<String>(orderId)};
+  }
+
+  CakepayOrder copyWith({String? orderId}) =>
+      CakepayOrder(orderId: orderId ?? this.orderId);
+  CakepayOrder copyWithCompanion(CakepayOrdersCompanion data) {
+    return CakepayOrder(
+      orderId: data.orderId.present ? data.orderId.value : this.orderId,
+    );
+  }
+
+  @override
+  String toString() {
+    return (StringBuffer('CakepayOrder(')
+          ..write('orderId: $orderId')
+          ..write(')'))
+        .toString();
+  }
+
+  @override
+  int get hashCode => orderId.hashCode;
+  @override
+  bool operator ==(Object other) =>
+      identical(this, other) ||
+      (other is CakepayOrder && other.orderId == this.orderId);
+}
+
+class CakepayOrdersCompanion extends UpdateCompanion<CakepayOrder> {
+  final Value<String> orderId;
+  final Value<int> rowid;
+  const CakepayOrdersCompanion({
+    this.orderId = const Value.absent(),
+    this.rowid = const Value.absent(),
+  });
+  CakepayOrdersCompanion.insert({
+    required String orderId,
+    this.rowid = const Value.absent(),
+  }) : orderId = Value(orderId);
+  static Insertable<CakepayOrder> custom({
+    Expression<String>? orderId,
+    Expression<int>? rowid,
+  }) {
+    return RawValuesInsertable({
+      if (orderId != null) 'order_id': orderId,
+      if (rowid != null) 'rowid': rowid,
+    });
+  }
+
+  CakepayOrdersCompanion copyWith({Value<String>? orderId, Value<int>? rowid}) {
+    return CakepayOrdersCompanion(
+      orderId: orderId ?? this.orderId,
+      rowid: rowid ?? this.rowid,
+    );
+  }
+
+  @override
+  Map<String, Expression> toColumns(bool nullToAbsent) {
+    final map = <String, Expression>{};
+    if (orderId.present) {
+      map['order_id'] = Variable<String>(orderId.value);
+    }
+    if (rowid.present) {
+      map['rowid'] = Variable<int>(rowid.value);
+    }
+    return map;
+  }
+
+  @override
+  String toString() {
+    return (StringBuffer('CakepayOrdersCompanion(')
+          ..write('orderId: $orderId, ')
+          ..write('rowid: $rowid')
+          ..write(')'))
+        .toString();
+  }
+}
+
+class $ShopinBitSettingsTable extends ShopinBitSettings
+    with TableInfo<$ShopinBitSettingsTable, ShopinBitSetting> {
+  @override
+  final GeneratedDatabase attachedDatabase;
+  final String? _alias;
+  $ShopinBitSettingsTable(this.attachedDatabase, [this._alias]);
+  static const VerificationMeta _idMeta = const VerificationMeta('id');
+  @override
+  late final GeneratedColumn<int> id = GeneratedColumn<int>(
+    'id',
+    aliasedName,
+    false,
+    type: DriftSqlType.int,
+    requiredDuringInsert: false,
+    defaultValue: const Constant(0),
+  );
+  static const VerificationMeta _guidelinesAcceptedMeta =
+      const VerificationMeta('guidelinesAccepted');
+  @override
+  late final GeneratedColumn<bool> guidelinesAccepted = GeneratedColumn<bool>(
+    'guidelines_accepted',
+    aliasedName,
+    false,
+    type: DriftSqlType.bool,
+    requiredDuringInsert: false,
+    defaultConstraints: GeneratedColumn.constraintIsAlways(
+      'CHECK ("guidelines_accepted" IN (0, 1))',
+    ),
+    defaultValue: const Constant(false),
+  );
+  static const VerificationMeta _setupCompleteMeta = const VerificationMeta(
+    'setupComplete',
+  );
+  @override
+  late final GeneratedColumn<bool> setupComplete = GeneratedColumn<bool>(
+    'setup_complete',
+    aliasedName,
+    false,
+    type: DriftSqlType.bool,
+    requiredDuringInsert: false,
+    defaultConstraints: GeneratedColumn.constraintIsAlways(
+      'CHECK ("setup_complete" IN (0, 1))',
+    ),
+    defaultValue: const Constant(false),
+  );
+  static const VerificationMeta _displayNameMeta = const VerificationMeta(
+    'displayName',
+  );
+  @override
+  late final GeneratedColumn<String> displayName = GeneratedColumn<String>(
+    'display_name',
+    aliasedName,
+    true,
+    type: DriftSqlType.string,
+    requiredDuringInsert: false,
+  );
+  @override
+  List<GeneratedColumn> get $columns => [
+    id,
+    guidelinesAccepted,
+    setupComplete,
+    displayName,
+  ];
+  @override
+  String get aliasedName => _alias ?? actualTableName;
+  @override
+  String get actualTableName => $name;
+  static const String $name = 'shopin_bit_settings';
+  @override
+  VerificationContext validateIntegrity(
+    Insertable<ShopinBitSetting> instance, {
+    bool isInserting = false,
+  }) {
+    final context = VerificationContext();
+    final data = instance.toColumns(true);
+    if (data.containsKey('id')) {
+      context.handle(_idMeta, id.isAcceptableOrUnknown(data['id']!, _idMeta));
+    }
+    if (data.containsKey('guidelines_accepted')) {
+      context.handle(
+        _guidelinesAcceptedMeta,
+        guidelinesAccepted.isAcceptableOrUnknown(
+          data['guidelines_accepted']!,
+          _guidelinesAcceptedMeta,
+        ),
+      );
+    }
+    if (data.containsKey('setup_complete')) {
+      context.handle(
+        _setupCompleteMeta,
+        setupComplete.isAcceptableOrUnknown(
+          data['setup_complete']!,
+          _setupCompleteMeta,
+        ),
+      );
+    }
+    if (data.containsKey('display_name')) {
+      context.handle(
+        _displayNameMeta,
+        displayName.isAcceptableOrUnknown(
+          data['display_name']!,
+          _displayNameMeta,
+        ),
+      );
+    }
+    return context;
+  }
+
+  @override
+  Set<GeneratedColumn> get $primaryKey => {id};
+  @override
+  ShopinBitSetting map(Map<String, dynamic> data, {String? tablePrefix}) {
+    final effectivePrefix = tablePrefix != null ? '$tablePrefix.' : '';
+    return ShopinBitSetting(
+      id: attachedDatabase.typeMapping.read(
+        DriftSqlType.int,
+        data['${effectivePrefix}id'],
+      )!,
+      guidelinesAccepted: attachedDatabase.typeMapping.read(
+        DriftSqlType.bool,
+        data['${effectivePrefix}guidelines_accepted'],
+      )!,
+      setupComplete: attachedDatabase.typeMapping.read(
+        DriftSqlType.bool,
+        data['${effectivePrefix}setup_complete'],
+      )!,
+      displayName: attachedDatabase.typeMapping.read(
+        DriftSqlType.string,
+        data['${effectivePrefix}display_name'],
+      ),
+    );
+  }
+
+  @override
+  $ShopinBitSettingsTable createAlias(String alias) {
+    return $ShopinBitSettingsTable(attachedDatabase, alias);
+  }
+}
+
+class ShopinBitSetting extends DataClass
+    implements Insertable<ShopinBitSetting> {
+  final int id;
+  final bool guidelinesAccepted;
+  final bool setupComplete;
+  final String? displayName;
+  const ShopinBitSetting({
+    required this.id,
+    required this.guidelinesAccepted,
+    required this.setupComplete,
+    this.displayName,
+  });
+  @override
+  Map<String, Expression> toColumns(bool nullToAbsent) {
+    final map = <String, Expression>{};
+    map['id'] = Variable<int>(id);
+    map['guidelines_accepted'] = Variable<bool>(guidelinesAccepted);
+    map['setup_complete'] = Variable<bool>(setupComplete);
+    if (!nullToAbsent || displayName != null) {
+      map['display_name'] = Variable<String>(displayName);
+    }
+    return map;
+  }
+
+  ShopinBitSettingsCompanion toCompanion(bool nullToAbsent) {
+    return ShopinBitSettingsCompanion(
+      id: Value(id),
+      guidelinesAccepted: Value(guidelinesAccepted),
+      setupComplete: Value(setupComplete),
+      displayName: displayName == null && nullToAbsent
+          ? const Value.absent()
+          : Value(displayName),
+    );
+  }
+
+  factory ShopinBitSetting.fromJson(
+    Map<String, dynamic> json, {
+    ValueSerializer? serializer,
+  }) {
+    serializer ??= driftRuntimeOptions.defaultSerializer;
+    return ShopinBitSetting(
+      id: serializer.fromJson<int>(json['id']),
+      guidelinesAccepted: serializer.fromJson<bool>(json['guidelinesAccepted']),
+      setupComplete: serializer.fromJson<bool>(json['setupComplete']),
+      displayName: serializer.fromJson<String?>(json['displayName']),
+    );
+  }
+  @override
+  Map<String, dynamic> toJson({ValueSerializer? serializer}) {
+    serializer ??= driftRuntimeOptions.defaultSerializer;
+    return <String, dynamic>{
+      'id': serializer.toJson<int>(id),
+      'guidelinesAccepted': serializer.toJson<bool>(guidelinesAccepted),
+      'setupComplete': serializer.toJson<bool>(setupComplete),
+      'displayName': serializer.toJson<String?>(displayName),
+    };
+  }
+
+  ShopinBitSetting copyWith({
+    int? id,
+    bool? guidelinesAccepted,
+    bool? setupComplete,
+    Value<String?> displayName = const Value.absent(),
+  }) => ShopinBitSetting(
+    id: id ?? this.id,
+    guidelinesAccepted: guidelinesAccepted ?? this.guidelinesAccepted,
+    setupComplete: setupComplete ?? this.setupComplete,
+    displayName: displayName.present ? displayName.value : this.displayName,
+  );
+  ShopinBitSetting copyWithCompanion(ShopinBitSettingsCompanion data) {
+    return ShopinBitSetting(
+      id: data.id.present ? data.id.value : this.id,
+      guidelinesAccepted: data.guidelinesAccepted.present
+          ? data.guidelinesAccepted.value
+          : this.guidelinesAccepted,
+      setupComplete: data.setupComplete.present
+          ? data.setupComplete.value
+          : this.setupComplete,
+      displayName: data.displayName.present
+          ? data.displayName.value
+          : this.displayName,
+    );
+  }
+
+  @override
+  String toString() {
+    return (StringBuffer('ShopinBitSetting(')
+          ..write('id: $id, ')
+          ..write('guidelinesAccepted: $guidelinesAccepted, ')
+          ..write('setupComplete: $setupComplete, ')
+          ..write('displayName: $displayName')
+          ..write(')'))
+        .toString();
+  }
+
+  @override
+  int get hashCode =>
+      Object.hash(id, guidelinesAccepted, setupComplete, displayName);
+  @override
+  bool operator ==(Object other) =>
+      identical(this, other) ||
+      (other is ShopinBitSetting &&
+          other.id == this.id &&
+          other.guidelinesAccepted == this.guidelinesAccepted &&
+          other.setupComplete == this.setupComplete &&
+          other.displayName == this.displayName);
+}
+
+class ShopinBitSettingsCompanion extends UpdateCompanion<ShopinBitSetting> {
+  final Value<int> id;
+  final Value<bool> guidelinesAccepted;
+  final Value<bool> setupComplete;
+  final Value<String?> displayName;
+  const ShopinBitSettingsCompanion({
+    this.id = const Value.absent(),
+    this.guidelinesAccepted = const Value.absent(),
+    this.setupComplete = const Value.absent(),
+    this.displayName = const Value.absent(),
+  });
+  ShopinBitSettingsCompanion.insert({
+    this.id = const Value.absent(),
+    this.guidelinesAccepted = const Value.absent(),
+    this.setupComplete = const Value.absent(),
+    this.displayName = const Value.absent(),
+  });
+  static Insertable<ShopinBitSetting> custom({
+    Expression<int>? id,
+    Expression<bool>? guidelinesAccepted,
+    Expression<bool>? setupComplete,
+    Expression<String>? displayName,
+  }) {
+    return RawValuesInsertable({
+      if (id != null) 'id': id,
+      if (guidelinesAccepted != null) 'guidelines_accepted': guidelinesAccepted,
+      if (setupComplete != null) 'setup_complete': setupComplete,
+      if (displayName != null) 'display_name': displayName,
+    });
+  }
+
+  ShopinBitSettingsCompanion copyWith({
+    Value<int>? id,
+    Value<bool>? guidelinesAccepted,
+    Value<bool>? setupComplete,
+    Value<String?>? displayName,
+  }) {
+    return ShopinBitSettingsCompanion(
+      id: id ?? this.id,
+      guidelinesAccepted: guidelinesAccepted ?? this.guidelinesAccepted,
+      setupComplete: setupComplete ?? this.setupComplete,
+      displayName: displayName ?? this.displayName,
+    );
+  }
+
+  @override
+  Map<String, Expression> toColumns(bool nullToAbsent) {
+    final map = <String, Expression>{};
+    if (id.present) {
+      map['id'] = Variable<int>(id.value);
+    }
+    if (guidelinesAccepted.present) {
+      map['guidelines_accepted'] = Variable<bool>(guidelinesAccepted.value);
+    }
+    if (setupComplete.present) {
+      map['setup_complete'] = Variable<bool>(setupComplete.value);
+    }
+    if (displayName.present) {
+      map['display_name'] = Variable<String>(displayName.value);
+    }
+    return map;
+  }
+
+  @override
+  String toString() {
+    return (StringBuffer('ShopinBitSettingsCompanion(')
+          ..write('id: $id, ')
+          ..write('guidelinesAccepted: $guidelinesAccepted, ')
+          ..write('setupComplete: $setupComplete, ')
+          ..write('displayName: $displayName')
+          ..write(')'))
+        .toString();
+  }
+}
+
+class $ShopInBitTicketsTable extends ShopInBitTickets
+    with TableInfo<$ShopInBitTicketsTable, ShopInBitTicket> {
+  @override
+  final GeneratedDatabase attachedDatabase;
+  final String? _alias;
+  $ShopInBitTicketsTable(this.attachedDatabase, [this._alias]);
+  static const VerificationMeta _ticketIdMeta = const VerificationMeta(
+    'ticketId',
+  );
+  @override
+  late final GeneratedColumn<String> ticketId = GeneratedColumn<String>(
+    'ticket_id',
+    aliasedName,
+    false,
+    type: DriftSqlType.string,
+    requiredDuringInsert: true,
+  );
+  static const VerificationMeta _displayNameMeta = const VerificationMeta(
+    'displayName',
+  );
+  @override
+  late final GeneratedColumn<String> displayName = GeneratedColumn<String>(
+    'display_name',
+    aliasedName,
+    false,
+    type: DriftSqlType.string,
+    requiredDuringInsert: true,
+  );
+  @override
+  late final GeneratedColumnWithTypeConverter<ShopInBitCategory, int> category =
+      GeneratedColumn<int>(
+        'category',
+        aliasedName,
+        false,
+        type: DriftSqlType.int,
+        requiredDuringInsert: true,
+      ).withConverter<ShopInBitCategory>(
+        $ShopInBitTicketsTable.$convertercategory,
+      );
+  @override
+  late final GeneratedColumnWithTypeConverter<ShopInBitOrderStatus, int>
+  status =
+      GeneratedColumn<int>(
+        'status',
+        aliasedName,
+        false,
+        type: DriftSqlType.int,
+        requiredDuringInsert: true,
+      ).withConverter<ShopInBitOrderStatus>(
+        $ShopInBitTicketsTable.$converterstatus,
+      );
+  static const VerificationMeta _requestDescriptionMeta =
+      const VerificationMeta('requestDescription');
+  @override
+  late final GeneratedColumn<String> requestDescription =
+      GeneratedColumn<String>(
+        'request_description',
+        aliasedName,
+        false,
+        type: DriftSqlType.string,
+        requiredDuringInsert: true,
+      );
+  static const VerificationMeta _deliveryCountryMeta = const VerificationMeta(
+    'deliveryCountry',
+  );
+  @override
+  late final GeneratedColumn<String> deliveryCountry = GeneratedColumn<String>(
+    'delivery_country',
+    aliasedName,
+    false,
+    type: DriftSqlType.string,
+    requiredDuringInsert: true,
+  );
+  static const VerificationMeta _offerProductNameMeta = const VerificationMeta(
+    'offerProductName',
+  );
+  @override
+  late final GeneratedColumn<String> offerProductName = GeneratedColumn<String>(
+    'offer_product_name',
+    aliasedName,
+    true,
+    type: DriftSqlType.string,
+    requiredDuringInsert: false,
+  );
+  static const VerificationMeta _offerPriceMeta = const VerificationMeta(
+    'offerPrice',
+  );
+  @override
+  late final GeneratedColumn<String> offerPrice = GeneratedColumn<String>(
+    'offer_price',
+    aliasedName,
+    true,
+    type: DriftSqlType.string,
+    requiredDuringInsert: false,
+  );
+  static const VerificationMeta _shippingNameMeta = const VerificationMeta(
+    'shippingName',
+  );
+  @override
+  late final GeneratedColumn<String> shippingName = GeneratedColumn<String>(
+    'shipping_name',
+    aliasedName,
+    false,
+    type: DriftSqlType.string,
+    requiredDuringInsert: true,
+  );
+  static const VerificationMeta _shippingStreetMeta = const VerificationMeta(
+    'shippingStreet',
+  );
+  @override
+  late final GeneratedColumn<String> shippingStreet = GeneratedColumn<String>(
+    'shipping_street',
+    aliasedName,
+    false,
+    type: DriftSqlType.string,
+    requiredDuringInsert: true,
+  );
+  static const VerificationMeta _shippingCityMeta = const VerificationMeta(
+    'shippingCity',
+  );
+  @override
+  late final GeneratedColumn<String> shippingCity = GeneratedColumn<String>(
+    'shipping_city',
+    aliasedName,
+    false,
+    type: DriftSqlType.string,
+    requiredDuringInsert: true,
+  );
+  static const VerificationMeta _shippingPostalCodeMeta =
+      const VerificationMeta('shippingPostalCode');
+  @override
+  late final GeneratedColumn<String> shippingPostalCode =
+      GeneratedColumn<String>(
+        'shipping_postal_code',
+        aliasedName,
+        false,
+        type: DriftSqlType.string,
+        requiredDuringInsert: true,
+      );
+  static const VerificationMeta _shippingCountryMeta = const VerificationMeta(
+    'shippingCountry',
+  );
+  @override
+  late final GeneratedColumn<String> shippingCountry = GeneratedColumn<String>(
+    'shipping_country',
+    aliasedName,
+    false,
+    type: DriftSqlType.string,
+    requiredDuringInsert: true,
+  );
+  static const VerificationMeta _paymentMethodMeta = const VerificationMeta(
+    'paymentMethod',
+  );
+  @override
+  late final GeneratedColumn<String> paymentMethod = GeneratedColumn<String>(
+    'payment_method',
+    aliasedName,
+    true,
+    type: DriftSqlType.string,
+    requiredDuringInsert: false,
+  );
+  @override
+  late final GeneratedColumnWithTypeConverter<
+    List<ShopInBitTicketMessage>,
+    String
+  >
+  messages =
+      GeneratedColumn<String>(
+        'messages',
+        aliasedName,
+        false,
+        type: DriftSqlType.string,
+        requiredDuringInsert: true,
+      ).withConverter<List<ShopInBitTicketMessage>>(
+        $ShopInBitTicketsTable.$convertermessages,
+      );
+  static const VerificationMeta _createdAtMeta = const VerificationMeta(
+    'createdAt',
+  );
+  @override
+  late final GeneratedColumn<DateTime> createdAt = GeneratedColumn<DateTime>(
+    'created_at',
+    aliasedName,
+    false,
+    type: DriftSqlType.dateTime,
+    requiredDuringInsert: true,
+  );
+  static const VerificationMeta _apiTicketIdMeta = const VerificationMeta(
+    'apiTicketId',
+  );
+  @override
+  late final GeneratedColumn<int> apiTicketId = GeneratedColumn<int>(
+    'api_ticket_id',
+    aliasedName,
+    false,
+    type: DriftSqlType.int,
+    requiredDuringInsert: true,
+  );
+  static const VerificationMeta _carResearchInvoiceIdMeta =
+      const VerificationMeta('carResearchInvoiceId');
+  @override
+  late final GeneratedColumn<String> carResearchInvoiceId =
+      GeneratedColumn<String>(
+        'car_research_invoice_id',
+        aliasedName,
+        true,
+        type: DriftSqlType.string,
+        requiredDuringInsert: false,
+      );
+  static const VerificationMeta _feeTicketNumberMeta = const VerificationMeta(
+    'feeTicketNumber',
+  );
+  @override
+  late final GeneratedColumn<String> feeTicketNumber = GeneratedColumn<String>(
+    'fee_ticket_number',
+    aliasedName,
+    true,
+    type: DriftSqlType.string,
+    requiredDuringInsert: false,
+  );
+  static const VerificationMeta _needsCreateRequestMeta =
+      const VerificationMeta('needsCreateRequest');
+  @override
+  late final GeneratedColumn<bool> needsCreateRequest = GeneratedColumn<bool>(
+    'needs_create_request',
+    aliasedName,
+    false,
+    type: DriftSqlType.bool,
+    requiredDuringInsert: true,
+    defaultConstraints: GeneratedColumn.constraintIsAlways(
+      'CHECK ("needs_create_request" IN (0, 1))',
+    ),
+  );
+  static const VerificationMeta _isPendingPaymentMeta = const VerificationMeta(
+    'isPendingPayment',
+  );
+  @override
+  late final GeneratedColumn<bool> isPendingPayment = GeneratedColumn<bool>(
+    'is_pending_payment',
+    aliasedName,
+    false,
+    type: DriftSqlType.bool,
+    requiredDuringInsert: true,
+    defaultConstraints: GeneratedColumn.constraintIsAlways(
+      'CHECK ("is_pending_payment" IN (0, 1))',
+    ),
+  );
+  static const VerificationMeta _carResearchExpiresAtMeta =
+      const VerificationMeta('carResearchExpiresAt');
+  @override
+  late final GeneratedColumn<DateTime> carResearchExpiresAt =
+      GeneratedColumn<DateTime>(
+        'car_research_expires_at',
+        aliasedName,
+        true,
+        type: DriftSqlType.dateTime,
+        requiredDuringInsert: false,
+      );
+  static const VerificationMeta _carResearchPaymentLinksMeta =
+      const VerificationMeta('carResearchPaymentLinks');
+  @override
+  late final GeneratedColumn<String> carResearchPaymentLinks =
+      GeneratedColumn<String>(
+        'car_research_payment_links',
+        aliasedName,
+        true,
+        type: DriftSqlType.string,
+        requiredDuringInsert: false,
+      );
+  @override
+  List<GeneratedColumn> get $columns => [
+    ticketId,
+    displayName,
+    category,
+    status,
+    requestDescription,
+    deliveryCountry,
+    offerProductName,
+    offerPrice,
+    shippingName,
+    shippingStreet,
+    shippingCity,
+    shippingPostalCode,
+    shippingCountry,
+    paymentMethod,
+    messages,
+    createdAt,
+    apiTicketId,
+    carResearchInvoiceId,
+    feeTicketNumber,
+    needsCreateRequest,
+    isPendingPayment,
+    carResearchExpiresAt,
+    carResearchPaymentLinks,
+  ];
+  @override
+  String get aliasedName => _alias ?? actualTableName;
+  @override
+  String get actualTableName => $name;
+  static const String $name = 'shop_in_bit_tickets';
+  @override
+  VerificationContext validateIntegrity(
+    Insertable<ShopInBitTicket> instance, {
+    bool isInserting = false,
+  }) {
+    final context = VerificationContext();
+    final data = instance.toColumns(true);
+    if (data.containsKey('ticket_id')) {
+      context.handle(
+        _ticketIdMeta,
+        ticketId.isAcceptableOrUnknown(data['ticket_id']!, _ticketIdMeta),
+      );
+    } else if (isInserting) {
+      context.missing(_ticketIdMeta);
+    }
+    if (data.containsKey('display_name')) {
+      context.handle(
+        _displayNameMeta,
+        displayName.isAcceptableOrUnknown(
+          data['display_name']!,
+          _displayNameMeta,
+        ),
+      );
+    } else if (isInserting) {
+      context.missing(_displayNameMeta);
+    }
+    if (data.containsKey('request_description')) {
+      context.handle(
+        _requestDescriptionMeta,
+        requestDescription.isAcceptableOrUnknown(
+          data['request_description']!,
+          _requestDescriptionMeta,
+        ),
+      );
+    } else if (isInserting) {
+      context.missing(_requestDescriptionMeta);
+    }
+    if (data.containsKey('delivery_country')) {
+      context.handle(
+        _deliveryCountryMeta,
+        deliveryCountry.isAcceptableOrUnknown(
+          data['delivery_country']!,
+          _deliveryCountryMeta,
+        ),
+      );
+    } else if (isInserting) {
+      context.missing(_deliveryCountryMeta);
+    }
+    if (data.containsKey('offer_product_name')) {
+      context.handle(
+        _offerProductNameMeta,
+        offerProductName.isAcceptableOrUnknown(
+          data['offer_product_name']!,
+          _offerProductNameMeta,
+        ),
+      );
+    }
+    if (data.containsKey('offer_price')) {
+      context.handle(
+        _offerPriceMeta,
+        offerPrice.isAcceptableOrUnknown(data['offer_price']!, _offerPriceMeta),
+      );
+    }
+    if (data.containsKey('shipping_name')) {
+      context.handle(
+        _shippingNameMeta,
+        shippingName.isAcceptableOrUnknown(
+          data['shipping_name']!,
+          _shippingNameMeta,
+        ),
+      );
+    } else if (isInserting) {
+      context.missing(_shippingNameMeta);
+    }
+    if (data.containsKey('shipping_street')) {
+      context.handle(
+        _shippingStreetMeta,
+        shippingStreet.isAcceptableOrUnknown(
+          data['shipping_street']!,
+          _shippingStreetMeta,
+        ),
+      );
+    } else if (isInserting) {
+      context.missing(_shippingStreetMeta);
+    }
+    if (data.containsKey('shipping_city')) {
+      context.handle(
+        _shippingCityMeta,
+        shippingCity.isAcceptableOrUnknown(
+          data['shipping_city']!,
+          _shippingCityMeta,
+        ),
+      );
+    } else if (isInserting) {
+      context.missing(_shippingCityMeta);
+    }
+    if (data.containsKey('shipping_postal_code')) {
+      context.handle(
+        _shippingPostalCodeMeta,
+        shippingPostalCode.isAcceptableOrUnknown(
+          data['shipping_postal_code']!,
+          _shippingPostalCodeMeta,
+        ),
+      );
+    } else if (isInserting) {
+      context.missing(_shippingPostalCodeMeta);
+    }
+    if (data.containsKey('shipping_country')) {
+      context.handle(
+        _shippingCountryMeta,
+        shippingCountry.isAcceptableOrUnknown(
+          data['shipping_country']!,
+          _shippingCountryMeta,
+        ),
+      );
+    } else if (isInserting) {
+      context.missing(_shippingCountryMeta);
+    }
+    if (data.containsKey('payment_method')) {
+      context.handle(
+        _paymentMethodMeta,
+        paymentMethod.isAcceptableOrUnknown(
+          data['payment_method']!,
+          _paymentMethodMeta,
+        ),
+      );
+    }
+    if (data.containsKey('created_at')) {
+      context.handle(
+        _createdAtMeta,
+        createdAt.isAcceptableOrUnknown(data['created_at']!, _createdAtMeta),
+      );
+    } else if (isInserting) {
+      context.missing(_createdAtMeta);
+    }
+    if (data.containsKey('api_ticket_id')) {
+      context.handle(
+        _apiTicketIdMeta,
+        apiTicketId.isAcceptableOrUnknown(
+          data['api_ticket_id']!,
+          _apiTicketIdMeta,
+        ),
+      );
+    } else if (isInserting) {
+      context.missing(_apiTicketIdMeta);
+    }
+    if (data.containsKey('car_research_invoice_id')) {
+      context.handle(
+        _carResearchInvoiceIdMeta,
+        carResearchInvoiceId.isAcceptableOrUnknown(
+          data['car_research_invoice_id']!,
+          _carResearchInvoiceIdMeta,
+        ),
+      );
+    }
+    if (data.containsKey('fee_ticket_number')) {
+      context.handle(
+        _feeTicketNumberMeta,
+        feeTicketNumber.isAcceptableOrUnknown(
+          data['fee_ticket_number']!,
+          _feeTicketNumberMeta,
+        ),
+      );
+    }
+    if (data.containsKey('needs_create_request')) {
+      context.handle(
+        _needsCreateRequestMeta,
+        needsCreateRequest.isAcceptableOrUnknown(
+          data['needs_create_request']!,
+          _needsCreateRequestMeta,
+        ),
+      );
+    } else if (isInserting) {
+      context.missing(_needsCreateRequestMeta);
+    }
+    if (data.containsKey('is_pending_payment')) {
+      context.handle(
+        _isPendingPaymentMeta,
+        isPendingPayment.isAcceptableOrUnknown(
+          data['is_pending_payment']!,
+          _isPendingPaymentMeta,
+        ),
+      );
+    } else if (isInserting) {
+      context.missing(_isPendingPaymentMeta);
+    }
+    if (data.containsKey('car_research_expires_at')) {
+      context.handle(
+        _carResearchExpiresAtMeta,
+        carResearchExpiresAt.isAcceptableOrUnknown(
+          data['car_research_expires_at']!,
+          _carResearchExpiresAtMeta,
+        ),
+      );
+    }
+    if (data.containsKey('car_research_payment_links')) {
+      context.handle(
+        _carResearchPaymentLinksMeta,
+        carResearchPaymentLinks.isAcceptableOrUnknown(
+          data['car_research_payment_links']!,
+          _carResearchPaymentLinksMeta,
+        ),
+      );
+    }
+    return context;
+  }
+
+  @override
+  Set<GeneratedColumn> get $primaryKey => {ticketId};
+  @override
+  ShopInBitTicket map(Map<String, dynamic> data, {String? tablePrefix}) {
+    final effectivePrefix = tablePrefix != null ? '$tablePrefix.' : '';
+    return ShopInBitTicket(
+      ticketId: attachedDatabase.typeMapping.read(
+        DriftSqlType.string,
+        data['${effectivePrefix}ticket_id'],
+      )!,
+      displayName: attachedDatabase.typeMapping.read(
+        DriftSqlType.string,
+        data['${effectivePrefix}display_name'],
+      )!,
+      category: $ShopInBitTicketsTable.$convertercategory.fromSql(
+        attachedDatabase.typeMapping.read(
+          DriftSqlType.int,
+          data['${effectivePrefix}category'],
+        )!,
+      ),
+      status: $ShopInBitTicketsTable.$converterstatus.fromSql(
+        attachedDatabase.typeMapping.read(
+          DriftSqlType.int,
+          data['${effectivePrefix}status'],
+        )!,
+      ),
+      requestDescription: attachedDatabase.typeMapping.read(
+        DriftSqlType.string,
+        data['${effectivePrefix}request_description'],
+      )!,
+      deliveryCountry: attachedDatabase.typeMapping.read(
+        DriftSqlType.string,
+        data['${effectivePrefix}delivery_country'],
+      )!,
+      offerProductName: attachedDatabase.typeMapping.read(
+        DriftSqlType.string,
+        data['${effectivePrefix}offer_product_name'],
+      ),
+      offerPrice: attachedDatabase.typeMapping.read(
+        DriftSqlType.string,
+        data['${effectivePrefix}offer_price'],
+      ),
+      shippingName: attachedDatabase.typeMapping.read(
+        DriftSqlType.string,
+        data['${effectivePrefix}shipping_name'],
+      )!,
+      shippingStreet: attachedDatabase.typeMapping.read(
+        DriftSqlType.string,
+        data['${effectivePrefix}shipping_street'],
+      )!,
+      shippingCity: attachedDatabase.typeMapping.read(
+        DriftSqlType.string,
+        data['${effectivePrefix}shipping_city'],
+      )!,
+      shippingPostalCode: attachedDatabase.typeMapping.read(
+        DriftSqlType.string,
+        data['${effectivePrefix}shipping_postal_code'],
+      )!,
+      shippingCountry: attachedDatabase.typeMapping.read(
+        DriftSqlType.string,
+        data['${effectivePrefix}shipping_country'],
+      )!,
+      paymentMethod: attachedDatabase.typeMapping.read(
+        DriftSqlType.string,
+        data['${effectivePrefix}payment_method'],
+      ),
+      messages: $ShopInBitTicketsTable.$convertermessages.fromSql(
+        attachedDatabase.typeMapping.read(
+          DriftSqlType.string,
+          data['${effectivePrefix}messages'],
+        )!,
+      ),
+      createdAt: attachedDatabase.typeMapping.read(
+        DriftSqlType.dateTime,
+        data['${effectivePrefix}created_at'],
+      )!,
+      apiTicketId: attachedDatabase.typeMapping.read(
+        DriftSqlType.int,
+        data['${effectivePrefix}api_ticket_id'],
+      )!,
+      carResearchInvoiceId: attachedDatabase.typeMapping.read(
+        DriftSqlType.string,
+        data['${effectivePrefix}car_research_invoice_id'],
+      ),
+      feeTicketNumber: attachedDatabase.typeMapping.read(
+        DriftSqlType.string,
+        data['${effectivePrefix}fee_ticket_number'],
+      ),
+      needsCreateRequest: attachedDatabase.typeMapping.read(
+        DriftSqlType.bool,
+        data['${effectivePrefix}needs_create_request'],
+      )!,
+      isPendingPayment: attachedDatabase.typeMapping.read(
+        DriftSqlType.bool,
+        data['${effectivePrefix}is_pending_payment'],
+      )!,
+      carResearchExpiresAt: attachedDatabase.typeMapping.read(
+        DriftSqlType.dateTime,
+        data['${effectivePrefix}car_research_expires_at'],
+      ),
+      carResearchPaymentLinks: attachedDatabase.typeMapping.read(
+        DriftSqlType.string,
+        data['${effectivePrefix}car_research_payment_links'],
+      ),
+    );
+  }
+
+  @override
+  $ShopInBitTicketsTable createAlias(String alias) {
+    return $ShopInBitTicketsTable(attachedDatabase, alias);
+  }
+
+  static JsonTypeConverter2<ShopInBitCategory, int, int> $convertercategory =
+      const EnumIndexConverter<ShopInBitCategory>(ShopInBitCategory.values);
+  static JsonTypeConverter2<ShopInBitOrderStatus, int, int> $converterstatus =
+      const EnumIndexConverter<ShopInBitOrderStatus>(
+        ShopInBitOrderStatus.values,
+      );
+  static JsonTypeConverter2<List<ShopInBitTicketMessage>, String, List<dynamic>>
+  $convertermessages = const ShopInBitTicketMessagesConverter();
+}
+
+class ShopInBitTicket extends DataClass implements Insertable<ShopInBitTicket> {
+  final String ticketId;
+  final String displayName;
+  final ShopInBitCategory category;
+  final ShopInBitOrderStatus status;
+  final String requestDescription;
+  final String deliveryCountry;
+  final String? offerProductName;
+  final String? offerPrice;
+  final String shippingName;
+  final String shippingStreet;
+  final String shippingCity;
+  final String shippingPostalCode;
+  final String shippingCountry;
+  final String? paymentMethod;
+  final List<ShopInBitTicketMessage> messages;
+  final DateTime createdAt;
+  final int apiTicketId;
+  final String? carResearchInvoiceId;
+  final String? feeTicketNumber;
+  final bool needsCreateRequest;
+  final bool isPendingPayment;
+  final DateTime? carResearchExpiresAt;
+  final String? carResearchPaymentLinks;
+  const ShopInBitTicket({
+    required this.ticketId,
+    required this.displayName,
+    required this.category,
+    required this.status,
+    required this.requestDescription,
+    required this.deliveryCountry,
+    this.offerProductName,
+    this.offerPrice,
+    required this.shippingName,
+    required this.shippingStreet,
+    required this.shippingCity,
+    required this.shippingPostalCode,
+    required this.shippingCountry,
+    this.paymentMethod,
+    required this.messages,
+    required this.createdAt,
+    required this.apiTicketId,
+    this.carResearchInvoiceId,
+    this.feeTicketNumber,
+    required this.needsCreateRequest,
+    required this.isPendingPayment,
+    this.carResearchExpiresAt,
+    this.carResearchPaymentLinks,
+  });
+  @override
+  Map<String, Expression> toColumns(bool nullToAbsent) {
+    final map = <String, Expression>{};
+    map['ticket_id'] = Variable<String>(ticketId);
+    map['display_name'] = Variable<String>(displayName);
+    {
+      map['category'] = Variable<int>(
+        $ShopInBitTicketsTable.$convertercategory.toSql(category),
+      );
+    }
+    {
+      map['status'] = Variable<int>(
+        $ShopInBitTicketsTable.$converterstatus.toSql(status),
+      );
+    }
+    map['request_description'] = Variable<String>(requestDescription);
+    map['delivery_country'] = Variable<String>(deliveryCountry);
+    if (!nullToAbsent || offerProductName != null) {
+      map['offer_product_name'] = Variable<String>(offerProductName);
+    }
+    if (!nullToAbsent || offerPrice != null) {
+      map['offer_price'] = Variable<String>(offerPrice);
+    }
+    map['shipping_name'] = Variable<String>(shippingName);
+    map['shipping_street'] = Variable<String>(shippingStreet);
+    map['shipping_city'] = Variable<String>(shippingCity);
+    map['shipping_postal_code'] = Variable<String>(shippingPostalCode);
+    map['shipping_country'] = Variable<String>(shippingCountry);
+    if (!nullToAbsent || paymentMethod != null) {
+      map['payment_method'] = Variable<String>(paymentMethod);
+    }
+    {
+      map['messages'] = Variable<String>(
+        $ShopInBitTicketsTable.$convertermessages.toSql(messages),
+      );
+    }
+    map['created_at'] = Variable<DateTime>(createdAt);
+    map['api_ticket_id'] = Variable<int>(apiTicketId);
+    if (!nullToAbsent || carResearchInvoiceId != null) {
+      map['car_research_invoice_id'] = Variable<String>(carResearchInvoiceId);
+    }
+    if (!nullToAbsent || feeTicketNumber != null) {
+      map['fee_ticket_number'] = Variable<String>(feeTicketNumber);
+    }
+    map['needs_create_request'] = Variable<bool>(needsCreateRequest);
+    map['is_pending_payment'] = Variable<bool>(isPendingPayment);
+    if (!nullToAbsent || carResearchExpiresAt != null) {
+      map['car_research_expires_at'] = Variable<DateTime>(carResearchExpiresAt);
+    }
+    if (!nullToAbsent || carResearchPaymentLinks != null) {
+      map['car_research_payment_links'] = Variable<String>(
+        carResearchPaymentLinks,
+      );
+    }
+    return map;
+  }
+
+  ShopInBitTicketsCompanion toCompanion(bool nullToAbsent) {
+    return ShopInBitTicketsCompanion(
+      ticketId: Value(ticketId),
+      displayName: Value(displayName),
+      category: Value(category),
+      status: Value(status),
+      requestDescription: Value(requestDescription),
+      deliveryCountry: Value(deliveryCountry),
+      offerProductName: offerProductName == null && nullToAbsent
+          ? const Value.absent()
+          : Value(offerProductName),
+      offerPrice: offerPrice == null && nullToAbsent
+          ? const Value.absent()
+          : Value(offerPrice),
+      shippingName: Value(shippingName),
+      shippingStreet: Value(shippingStreet),
+      shippingCity: Value(shippingCity),
+      shippingPostalCode: Value(shippingPostalCode),
+      shippingCountry: Value(shippingCountry),
+      paymentMethod: paymentMethod == null && nullToAbsent
+          ? const Value.absent()
+          : Value(paymentMethod),
+      messages: Value(messages),
+      createdAt: Value(createdAt),
+      apiTicketId: Value(apiTicketId),
+      carResearchInvoiceId: carResearchInvoiceId == null && nullToAbsent
+          ? const Value.absent()
+          : Value(carResearchInvoiceId),
+      feeTicketNumber: feeTicketNumber == null && nullToAbsent
+          ? const Value.absent()
+          : Value(feeTicketNumber),
+      needsCreateRequest: Value(needsCreateRequest),
+      isPendingPayment: Value(isPendingPayment),
+      carResearchExpiresAt: carResearchExpiresAt == null && nullToAbsent
+          ? const Value.absent()
+          : Value(carResearchExpiresAt),
+      carResearchPaymentLinks: carResearchPaymentLinks == null && nullToAbsent
+          ? const Value.absent()
+          : Value(carResearchPaymentLinks),
+    );
+  }
+
+  factory ShopInBitTicket.fromJson(
+    Map<String, dynamic> json, {
+    ValueSerializer? serializer,
+  }) {
+    serializer ??= driftRuntimeOptions.defaultSerializer;
+    return ShopInBitTicket(
+      ticketId: serializer.fromJson<String>(json['ticketId']),
+      displayName: serializer.fromJson<String>(json['displayName']),
+      category: $ShopInBitTicketsTable.$convertercategory.fromJson(
+        serializer.fromJson<int>(json['category']),
+      ),
+      status: $ShopInBitTicketsTable.$converterstatus.fromJson(
+        serializer.fromJson<int>(json['status']),
+      ),
+      requestDescription: serializer.fromJson<String>(
+        json['requestDescription'],
+      ),
+      deliveryCountry: serializer.fromJson<String>(json['deliveryCountry']),
+      offerProductName: serializer.fromJson<String?>(json['offerProductName']),
+      offerPrice: serializer.fromJson<String?>(json['offerPrice']),
+      shippingName: serializer.fromJson<String>(json['shippingName']),
+      shippingStreet: serializer.fromJson<String>(json['shippingStreet']),
+      shippingCity: serializer.fromJson<String>(json['shippingCity']),
+      shippingPostalCode: serializer.fromJson<String>(
+        json['shippingPostalCode'],
+      ),
+      shippingCountry: serializer.fromJson<String>(json['shippingCountry']),
+      paymentMethod: serializer.fromJson<String?>(json['paymentMethod']),
+      messages: $ShopInBitTicketsTable.$convertermessages.fromJson(
+        serializer.fromJson<List<dynamic>>(json['messages']),
+      ),
+      createdAt: serializer.fromJson<DateTime>(json['createdAt']),
+      apiTicketId: serializer.fromJson<int>(json['apiTicketId']),
+      carResearchInvoiceId: serializer.fromJson<String?>(
+        json['carResearchInvoiceId'],
+      ),
+      feeTicketNumber: serializer.fromJson<String?>(json['feeTicketNumber']),
+      needsCreateRequest: serializer.fromJson<bool>(json['needsCreateRequest']),
+      isPendingPayment: serializer.fromJson<bool>(json['isPendingPayment']),
+      carResearchExpiresAt: serializer.fromJson<DateTime?>(
+        json['carResearchExpiresAt'],
+      ),
+      carResearchPaymentLinks: serializer.fromJson<String?>(
+        json['carResearchPaymentLinks'],
+      ),
+    );
+  }
+  @override
+  Map<String, dynamic> toJson({ValueSerializer? serializer}) {
+    serializer ??= driftRuntimeOptions.defaultSerializer;
+    return <String, dynamic>{
+      'ticketId': serializer.toJson<String>(ticketId),
+      'displayName': serializer.toJson<String>(displayName),
+      'category': serializer.toJson<int>(
+        $ShopInBitTicketsTable.$convertercategory.toJson(category),
+      ),
+      'status': serializer.toJson<int>(
+        $ShopInBitTicketsTable.$converterstatus.toJson(status),
+      ),
+      'requestDescription': serializer.toJson<String>(requestDescription),
+      'deliveryCountry': serializer.toJson<String>(deliveryCountry),
+      'offerProductName': serializer.toJson<String?>(offerProductName),
+      'offerPrice': serializer.toJson<String?>(offerPrice),
+      'shippingName': serializer.toJson<String>(shippingName),
+      'shippingStreet': serializer.toJson<String>(shippingStreet),
+      'shippingCity': serializer.toJson<String>(shippingCity),
+      'shippingPostalCode': serializer.toJson<String>(shippingPostalCode),
+      'shippingCountry': serializer.toJson<String>(shippingCountry),
+      'paymentMethod': serializer.toJson<String?>(paymentMethod),
+      'messages': serializer.toJson<List<dynamic>>(
+        $ShopInBitTicketsTable.$convertermessages.toJson(messages),
+      ),
+      'createdAt': serializer.toJson<DateTime>(createdAt),
+      'apiTicketId': serializer.toJson<int>(apiTicketId),
+      'carResearchInvoiceId': serializer.toJson<String?>(carResearchInvoiceId),
+      'feeTicketNumber': serializer.toJson<String?>(feeTicketNumber),
+      'needsCreateRequest': serializer.toJson<bool>(needsCreateRequest),
+      'isPendingPayment': serializer.toJson<bool>(isPendingPayment),
+      'carResearchExpiresAt': serializer.toJson<DateTime?>(
+        carResearchExpiresAt,
+      ),
+      'carResearchPaymentLinks': serializer.toJson<String?>(
+        carResearchPaymentLinks,
+      ),
+    };
+  }
+
+  ShopInBitTicket copyWith({
+    String? ticketId,
+    String? displayName,
+    ShopInBitCategory? category,
+    ShopInBitOrderStatus? status,
+    String? requestDescription,
+    String? deliveryCountry,
+    Value<String?> offerProductName = const Value.absent(),
+    Value<String?> offerPrice = const Value.absent(),
+    String? shippingName,
+    String? shippingStreet,
+    String? shippingCity,
+    String? shippingPostalCode,
+    String? shippingCountry,
+    Value<String?> paymentMethod = const Value.absent(),
+    List<ShopInBitTicketMessage>? messages,
+    DateTime? createdAt,
+    int? apiTicketId,
+    Value<String?> carResearchInvoiceId = const Value.absent(),
+    Value<String?> feeTicketNumber = const Value.absent(),
+    bool? needsCreateRequest,
+    bool? isPendingPayment,
+    Value<DateTime?> carResearchExpiresAt = const Value.absent(),
+    Value<String?> carResearchPaymentLinks = const Value.absent(),
+  }) => ShopInBitTicket(
+    ticketId: ticketId ?? this.ticketId,
+    displayName: displayName ?? this.displayName,
+    category: category ?? this.category,
+    status: status ?? this.status,
+    requestDescription: requestDescription ?? this.requestDescription,
+    deliveryCountry: deliveryCountry ?? this.deliveryCountry,
+    offerProductName: offerProductName.present
+        ? offerProductName.value
+        : this.offerProductName,
+    offerPrice: offerPrice.present ? offerPrice.value : this.offerPrice,
+    shippingName: shippingName ?? this.shippingName,
+    shippingStreet: shippingStreet ?? this.shippingStreet,
+    shippingCity: shippingCity ?? this.shippingCity,
+    shippingPostalCode: shippingPostalCode ?? this.shippingPostalCode,
+    shippingCountry: shippingCountry ?? this.shippingCountry,
+    paymentMethod: paymentMethod.present
+        ? paymentMethod.value
+        : this.paymentMethod,
+    messages: messages ?? this.messages,
+    createdAt: createdAt ?? this.createdAt,
+    apiTicketId: apiTicketId ?? this.apiTicketId,
+    carResearchInvoiceId: carResearchInvoiceId.present
+        ? carResearchInvoiceId.value
+        : this.carResearchInvoiceId,
+    feeTicketNumber: feeTicketNumber.present
+        ? feeTicketNumber.value
+        : this.feeTicketNumber,
+    needsCreateRequest: needsCreateRequest ?? this.needsCreateRequest,
+    isPendingPayment: isPendingPayment ?? this.isPendingPayment,
+    carResearchExpiresAt: carResearchExpiresAt.present
+        ? carResearchExpiresAt.value
+        : this.carResearchExpiresAt,
+    carResearchPaymentLinks: carResearchPaymentLinks.present
+        ? carResearchPaymentLinks.value
+        : this.carResearchPaymentLinks,
+  );
+  ShopInBitTicket copyWithCompanion(ShopInBitTicketsCompanion data) {
+    return ShopInBitTicket(
+      ticketId: data.ticketId.present ? data.ticketId.value : this.ticketId,
+      displayName: data.displayName.present
+          ? data.displayName.value
+          : this.displayName,
+      category: data.category.present ? data.category.value : this.category,
+      status: data.status.present ? data.status.value : this.status,
+      requestDescription: data.requestDescription.present
+          ? data.requestDescription.value
+          : this.requestDescription,
+      deliveryCountry: data.deliveryCountry.present
+          ? data.deliveryCountry.value
+          : this.deliveryCountry,
+      offerProductName: data.offerProductName.present
+          ? data.offerProductName.value
+          : this.offerProductName,
+      offerPrice: data.offerPrice.present
+          ? data.offerPrice.value
+          : this.offerPrice,
+      shippingName: data.shippingName.present
+          ? data.shippingName.value
+          : this.shippingName,
+      shippingStreet: data.shippingStreet.present
+          ? data.shippingStreet.value
+          : this.shippingStreet,
+      shippingCity: data.shippingCity.present
+          ? data.shippingCity.value
+          : this.shippingCity,
+      shippingPostalCode: data.shippingPostalCode.present
+          ? data.shippingPostalCode.value
+          : this.shippingPostalCode,
+      shippingCountry: data.shippingCountry.present
+          ? data.shippingCountry.value
+          : this.shippingCountry,
+      paymentMethod: data.paymentMethod.present
+          ? data.paymentMethod.value
+          : this.paymentMethod,
+      messages: data.messages.present ? data.messages.value : this.messages,
+      createdAt: data.createdAt.present ? data.createdAt.value : this.createdAt,
+      apiTicketId: data.apiTicketId.present
+          ? data.apiTicketId.value
+          : this.apiTicketId,
+      carResearchInvoiceId: data.carResearchInvoiceId.present
+          ? data.carResearchInvoiceId.value
+          : this.carResearchInvoiceId,
+      feeTicketNumber: data.feeTicketNumber.present
+          ? data.feeTicketNumber.value
+          : this.feeTicketNumber,
+      needsCreateRequest: data.needsCreateRequest.present
+          ? data.needsCreateRequest.value
+          : this.needsCreateRequest,
+      isPendingPayment: data.isPendingPayment.present
+          ? data.isPendingPayment.value
+          : this.isPendingPayment,
+      carResearchExpiresAt: data.carResearchExpiresAt.present
+          ? data.carResearchExpiresAt.value
+          : this.carResearchExpiresAt,
+      carResearchPaymentLinks: data.carResearchPaymentLinks.present
+          ? data.carResearchPaymentLinks.value
+          : this.carResearchPaymentLinks,
+    );
+  }
+
+  @override
+  String toString() {
+    return (StringBuffer('ShopInBitTicket(')
+          ..write('ticketId: $ticketId, ')
+          ..write('displayName: $displayName, ')
+          ..write('category: $category, ')
+          ..write('status: $status, ')
+          ..write('requestDescription: $requestDescription, ')
+          ..write('deliveryCountry: $deliveryCountry, ')
+          ..write('offerProductName: $offerProductName, ')
+          ..write('offerPrice: $offerPrice, ')
+          ..write('shippingName: $shippingName, ')
+          ..write('shippingStreet: $shippingStreet, ')
+          ..write('shippingCity: $shippingCity, ')
+          ..write('shippingPostalCode: $shippingPostalCode, ')
+          ..write('shippingCountry: $shippingCountry, ')
+          ..write('paymentMethod: $paymentMethod, ')
+          ..write('messages: $messages, ')
+          ..write('createdAt: $createdAt, ')
+          ..write('apiTicketId: $apiTicketId, ')
+          ..write('carResearchInvoiceId: $carResearchInvoiceId, ')
+          ..write('feeTicketNumber: $feeTicketNumber, ')
+          ..write('needsCreateRequest: $needsCreateRequest, ')
+          ..write('isPendingPayment: $isPendingPayment, ')
+          ..write('carResearchExpiresAt: $carResearchExpiresAt, ')
+          ..write('carResearchPaymentLinks: $carResearchPaymentLinks')
+          ..write(')'))
+        .toString();
+  }
+
+  @override
+  int get hashCode => Object.hashAll([
+    ticketId,
+    displayName,
+    category,
+    status,
+    requestDescription,
+    deliveryCountry,
+    offerProductName,
+    offerPrice,
+    shippingName,
+    shippingStreet,
+    shippingCity,
+    shippingPostalCode,
+    shippingCountry,
+    paymentMethod,
+    messages,
+    createdAt,
+    apiTicketId,
+    carResearchInvoiceId,
+    feeTicketNumber,
+    needsCreateRequest,
+    isPendingPayment,
+    carResearchExpiresAt,
+    carResearchPaymentLinks,
+  ]);
+  @override
+  bool operator ==(Object other) =>
+      identical(this, other) ||
+      (other is ShopInBitTicket &&
+          other.ticketId == this.ticketId &&
+          other.displayName == this.displayName &&
+          other.category == this.category &&
+          other.status == this.status &&
+          other.requestDescription == this.requestDescription &&
+          other.deliveryCountry == this.deliveryCountry &&
+          other.offerProductName == this.offerProductName &&
+          other.offerPrice == this.offerPrice &&
+          other.shippingName == this.shippingName &&
+          other.shippingStreet == this.shippingStreet &&
+          other.shippingCity == this.shippingCity &&
+          other.shippingPostalCode == this.shippingPostalCode &&
+          other.shippingCountry == this.shippingCountry &&
+          other.paymentMethod == this.paymentMethod &&
+          other.messages == this.messages &&
+          other.createdAt == this.createdAt &&
+          other.apiTicketId == this.apiTicketId &&
+          other.carResearchInvoiceId == this.carResearchInvoiceId &&
+          other.feeTicketNumber == this.feeTicketNumber &&
+          other.needsCreateRequest == this.needsCreateRequest &&
+          other.isPendingPayment == this.isPendingPayment &&
+          other.carResearchExpiresAt == this.carResearchExpiresAt &&
+          other.carResearchPaymentLinks == this.carResearchPaymentLinks);
+}
+
+class ShopInBitTicketsCompanion extends UpdateCompanion<ShopInBitTicket> {
+  final Value<String> ticketId;
+  final Value<String> displayName;
+  final Value<ShopInBitCategory> category;
+  final Value<ShopInBitOrderStatus> status;
+  final Value<String> requestDescription;
+  final Value<String> deliveryCountry;
+  final Value<String?> offerProductName;
+  final Value<String?> offerPrice;
+  final Value<String> shippingName;
+  final Value<String> shippingStreet;
+  final Value<String> shippingCity;
+  final Value<String> shippingPostalCode;
+  final Value<String> shippingCountry;
+  final Value<String?> paymentMethod;
+  final Value<List<ShopInBitTicketMessage>> messages;
+  final Value<DateTime> createdAt;
+  final Value<int> apiTicketId;
+  final Value<String?> carResearchInvoiceId;
+  final Value<String?> feeTicketNumber;
+  final Value<bool> needsCreateRequest;
+  final Value<bool> isPendingPayment;
+  final Value<DateTime?> carResearchExpiresAt;
+  final Value<String?> carResearchPaymentLinks;
+  final Value<int> rowid;
+  const ShopInBitTicketsCompanion({
+    this.ticketId = const Value.absent(),
+    this.displayName = const Value.absent(),
+    this.category = const Value.absent(),
+    this.status = const Value.absent(),
+    this.requestDescription = const Value.absent(),
+    this.deliveryCountry = const Value.absent(),
+    this.offerProductName = const Value.absent(),
+    this.offerPrice = const Value.absent(),
+    this.shippingName = const Value.absent(),
+    this.shippingStreet = const Value.absent(),
+    this.shippingCity = const Value.absent(),
+    this.shippingPostalCode = const Value.absent(),
+    this.shippingCountry = const Value.absent(),
+    this.paymentMethod = const Value.absent(),
+    this.messages = const Value.absent(),
+    this.createdAt = const Value.absent(),
+    this.apiTicketId = const Value.absent(),
+    this.carResearchInvoiceId = const Value.absent(),
+    this.feeTicketNumber = const Value.absent(),
+    this.needsCreateRequest = const Value.absent(),
+    this.isPendingPayment = const Value.absent(),
+    this.carResearchExpiresAt = const Value.absent(),
+    this.carResearchPaymentLinks = const Value.absent(),
+    this.rowid = const Value.absent(),
+  });
+  ShopInBitTicketsCompanion.insert({
+    required String ticketId,
+    required String displayName,
+    required ShopInBitCategory category,
+    required ShopInBitOrderStatus status,
+    required String requestDescription,
+    required String deliveryCountry,
+    this.offerProductName = const Value.absent(),
+    this.offerPrice = const Value.absent(),
+    required String shippingName,
+    required String shippingStreet,
+    required String shippingCity,
+    required String shippingPostalCode,
+    required String shippingCountry,
+    this.paymentMethod = const Value.absent(),
+    required List<ShopInBitTicketMessage> messages,
+    required DateTime createdAt,
+    required int apiTicketId,
+    this.carResearchInvoiceId = const Value.absent(),
+    this.feeTicketNumber = const Value.absent(),
+    required bool needsCreateRequest,
+    required bool isPendingPayment,
+    this.carResearchExpiresAt = const Value.absent(),
+    this.carResearchPaymentLinks = const Value.absent(),
+    this.rowid = const Value.absent(),
+  }) : ticketId = Value(ticketId),
+       displayName = Value(displayName),
+       category = Value(category),
+       status = Value(status),
+       requestDescription = Value(requestDescription),
+       deliveryCountry = Value(deliveryCountry),
+       shippingName = Value(shippingName),
+       shippingStreet = Value(shippingStreet),
+       shippingCity = Value(shippingCity),
+       shippingPostalCode = Value(shippingPostalCode),
+       shippingCountry = Value(shippingCountry),
+       messages = Value(messages),
+       createdAt = Value(createdAt),
+       apiTicketId = Value(apiTicketId),
+       needsCreateRequest = Value(needsCreateRequest),
+       isPendingPayment = Value(isPendingPayment);
+  static Insertable<ShopInBitTicket> custom({
+    Expression<String>? ticketId,
+    Expression<String>? displayName,
+    Expression<int>? category,
+    Expression<int>? status,
+    Expression<String>? requestDescription,
+    Expression<String>? deliveryCountry,
+    Expression<String>? offerProductName,
+    Expression<String>? offerPrice,
+    Expression<String>? shippingName,
+    Expression<String>? shippingStreet,
+    Expression<String>? shippingCity,
+    Expression<String>? shippingPostalCode,
+    Expression<String>? shippingCountry,
+    Expression<String>? paymentMethod,
+    Expression<String>? messages,
+    Expression<DateTime>? createdAt,
+    Expression<int>? apiTicketId,
+    Expression<String>? carResearchInvoiceId,
+    Expression<String>? feeTicketNumber,
+    Expression<bool>? needsCreateRequest,
+    Expression<bool>? isPendingPayment,
+    Expression<DateTime>? carResearchExpiresAt,
+    Expression<String>? carResearchPaymentLinks,
+    Expression<int>? rowid,
+  }) {
+    return RawValuesInsertable({
+      if (ticketId != null) 'ticket_id': ticketId,
+      if (displayName != null) 'display_name': displayName,
+      if (category != null) 'category': category,
+      if (status != null) 'status': status,
+      if (requestDescription != null) 'request_description': requestDescription,
+      if (deliveryCountry != null) 'delivery_country': deliveryCountry,
+      if (offerProductName != null) 'offer_product_name': offerProductName,
+      if (offerPrice != null) 'offer_price': offerPrice,
+      if (shippingName != null) 'shipping_name': shippingName,
+      if (shippingStreet != null) 'shipping_street': shippingStreet,
+      if (shippingCity != null) 'shipping_city': shippingCity,
+      if (shippingPostalCode != null)
+        'shipping_postal_code': shippingPostalCode,
+      if (shippingCountry != null) 'shipping_country': shippingCountry,
+      if (paymentMethod != null) 'payment_method': paymentMethod,
+      if (messages != null) 'messages': messages,
+      if (createdAt != null) 'created_at': createdAt,
+      if (apiTicketId != null) 'api_ticket_id': apiTicketId,
+      if (carResearchInvoiceId != null)
+        'car_research_invoice_id': carResearchInvoiceId,
+      if (feeTicketNumber != null) 'fee_ticket_number': feeTicketNumber,
+      if (needsCreateRequest != null)
+        'needs_create_request': needsCreateRequest,
+      if (isPendingPayment != null) 'is_pending_payment': isPendingPayment,
+      if (carResearchExpiresAt != null)
+        'car_research_expires_at': carResearchExpiresAt,
+      if (carResearchPaymentLinks != null)
+        'car_research_payment_links': carResearchPaymentLinks,
+      if (rowid != null) 'rowid': rowid,
+    });
+  }
+
+  ShopInBitTicketsCompanion copyWith({
+    Value<String>? ticketId,
+    Value<String>? displayName,
+    Value<ShopInBitCategory>? category,
+    Value<ShopInBitOrderStatus>? status,
+    Value<String>? requestDescription,
+    Value<String>? deliveryCountry,
+    Value<String?>? offerProductName,
+    Value<String?>? offerPrice,
+    Value<String>? shippingName,
+    Value<String>? shippingStreet,
+    Value<String>? shippingCity,
+    Value<String>? shippingPostalCode,
+    Value<String>? shippingCountry,
+    Value<String?>? paymentMethod,
+    Value<List<ShopInBitTicketMessage>>? messages,
+    Value<DateTime>? createdAt,
+    Value<int>? apiTicketId,
+    Value<String?>? carResearchInvoiceId,
+    Value<String?>? feeTicketNumber,
+    Value<bool>? needsCreateRequest,
+    Value<bool>? isPendingPayment,
+    Value<DateTime?>? carResearchExpiresAt,
+    Value<String?>? carResearchPaymentLinks,
+    Value<int>? rowid,
+  }) {
+    return ShopInBitTicketsCompanion(
+      ticketId: ticketId ?? this.ticketId,
+      displayName: displayName ?? this.displayName,
+      category: category ?? this.category,
+      status: status ?? this.status,
+      requestDescription: requestDescription ?? this.requestDescription,
+      deliveryCountry: deliveryCountry ?? this.deliveryCountry,
+      offerProductName: offerProductName ?? this.offerProductName,
+      offerPrice: offerPrice ?? this.offerPrice,
+      shippingName: shippingName ?? this.shippingName,
+      shippingStreet: shippingStreet ?? this.shippingStreet,
+      shippingCity: shippingCity ?? this.shippingCity,
+      shippingPostalCode: shippingPostalCode ?? this.shippingPostalCode,
+      shippingCountry: shippingCountry ?? this.shippingCountry,
+      paymentMethod: paymentMethod ?? this.paymentMethod,
+      messages: messages ?? this.messages,
+      createdAt: createdAt ?? this.createdAt,
+      apiTicketId: apiTicketId ?? this.apiTicketId,
+      carResearchInvoiceId: carResearchInvoiceId ?? this.carResearchInvoiceId,
+      feeTicketNumber: feeTicketNumber ?? this.feeTicketNumber,
+      needsCreateRequest: needsCreateRequest ?? this.needsCreateRequest,
+      isPendingPayment: isPendingPayment ?? this.isPendingPayment,
+      carResearchExpiresAt: carResearchExpiresAt ?? this.carResearchExpiresAt,
+      carResearchPaymentLinks:
+          carResearchPaymentLinks ?? this.carResearchPaymentLinks,
+      rowid: rowid ?? this.rowid,
+    );
+  }
+
+  @override
+  Map<String, Expression> toColumns(bool nullToAbsent) {
+    final map = <String, Expression>{};
+    if (ticketId.present) {
+      map['ticket_id'] = Variable<String>(ticketId.value);
+    }
+    if (displayName.present) {
+      map['display_name'] = Variable<String>(displayName.value);
+    }
+    if (category.present) {
+      map['category'] = Variable<int>(
+        $ShopInBitTicketsTable.$convertercategory.toSql(category.value),
+      );
+    }
+    if (status.present) {
+      map['status'] = Variable<int>(
+        $ShopInBitTicketsTable.$converterstatus.toSql(status.value),
+      );
+    }
+    if (requestDescription.present) {
+      map['request_description'] = Variable<String>(requestDescription.value);
+    }
+    if (deliveryCountry.present) {
+      map['delivery_country'] = Variable<String>(deliveryCountry.value);
+    }
+    if (offerProductName.present) {
+      map['offer_product_name'] = Variable<String>(offerProductName.value);
+    }
+    if (offerPrice.present) {
+      map['offer_price'] = Variable<String>(offerPrice.value);
+    }
+    if (shippingName.present) {
+      map['shipping_name'] = Variable<String>(shippingName.value);
+    }
+    if (shippingStreet.present) {
+      map['shipping_street'] = Variable<String>(shippingStreet.value);
+    }
+    if (shippingCity.present) {
+      map['shipping_city'] = Variable<String>(shippingCity.value);
+    }
+    if (shippingPostalCode.present) {
+      map['shipping_postal_code'] = Variable<String>(shippingPostalCode.value);
+    }
+    if (shippingCountry.present) {
+      map['shipping_country'] = Variable<String>(shippingCountry.value);
+    }
+    if (paymentMethod.present) {
+      map['payment_method'] = Variable<String>(paymentMethod.value);
+    }
+    if (messages.present) {
+      map['messages'] = Variable<String>(
+        $ShopInBitTicketsTable.$convertermessages.toSql(messages.value),
+      );
+    }
+    if (createdAt.present) {
+      map['created_at'] = Variable<DateTime>(createdAt.value);
+    }
+    if (apiTicketId.present) {
+      map['api_ticket_id'] = Variable<int>(apiTicketId.value);
+    }
+    if (carResearchInvoiceId.present) {
+      map['car_research_invoice_id'] = Variable<String>(
+        carResearchInvoiceId.value,
+      );
+    }
+    if (feeTicketNumber.present) {
+      map['fee_ticket_number'] = Variable<String>(feeTicketNumber.value);
+    }
+    if (needsCreateRequest.present) {
+      map['needs_create_request'] = Variable<bool>(needsCreateRequest.value);
+    }
+    if (isPendingPayment.present) {
+      map['is_pending_payment'] = Variable<bool>(isPendingPayment.value);
+    }
+    if (carResearchExpiresAt.present) {
+      map['car_research_expires_at'] = Variable<DateTime>(
+        carResearchExpiresAt.value,
+      );
+    }
+    if (carResearchPaymentLinks.present) {
+      map['car_research_payment_links'] = Variable<String>(
+        carResearchPaymentLinks.value,
+      );
+    }
+    if (rowid.present) {
+      map['rowid'] = Variable<int>(rowid.value);
+    }
+    return map;
+  }
+
+  @override
+  String toString() {
+    return (StringBuffer('ShopInBitTicketsCompanion(')
+          ..write('ticketId: $ticketId, ')
+          ..write('displayName: $displayName, ')
+          ..write('category: $category, ')
+          ..write('status: $status, ')
+          ..write('requestDescription: $requestDescription, ')
+          ..write('deliveryCountry: $deliveryCountry, ')
+          ..write('offerProductName: $offerProductName, ')
+          ..write('offerPrice: $offerPrice, ')
+          ..write('shippingName: $shippingName, ')
+          ..write('shippingStreet: $shippingStreet, ')
+          ..write('shippingCity: $shippingCity, ')
+          ..write('shippingPostalCode: $shippingPostalCode, ')
+          ..write('shippingCountry: $shippingCountry, ')
+          ..write('paymentMethod: $paymentMethod, ')
+          ..write('messages: $messages, ')
+          ..write('createdAt: $createdAt, ')
+          ..write('apiTicketId: $apiTicketId, ')
+          ..write('carResearchInvoiceId: $carResearchInvoiceId, ')
+          ..write('feeTicketNumber: $feeTicketNumber, ')
+          ..write('needsCreateRequest: $needsCreateRequest, ')
+          ..write('isPendingPayment: $isPendingPayment, ')
+          ..write('carResearchExpiresAt: $carResearchExpiresAt, ')
+          ..write('carResearchPaymentLinks: $carResearchPaymentLinks, ')
+          ..write('rowid: $rowid')
+          ..write(')'))
+        .toString();
+  }
+}
+
+abstract class _$SharedDatabase extends GeneratedDatabase {
+  _$SharedDatabase(QueryExecutor e) : super(e);
+  $SharedDatabaseManager get managers => $SharedDatabaseManager(this);
+  late final $CakepayOrdersTable cakepayOrders = $CakepayOrdersTable(this);
+  late final $ShopinBitSettingsTable shopinBitSettings =
+      $ShopinBitSettingsTable(this);
+  late final $ShopInBitTicketsTable shopInBitTickets = $ShopInBitTicketsTable(
+    this,
+  );
+  late final ShopinBitSettingsDao shopinBitSettingsDao = ShopinBitSettingsDao(
+    this as SharedDatabase,
+  );
+  @override
+  Iterable<TableInfo<Table, Object?>> get allTables =>
+      allSchemaEntities.whereType<TableInfo<Table, Object?>>();
+  @override
+  List<DatabaseSchemaEntity> get allSchemaEntities => [
+    cakepayOrders,
+    shopinBitSettings,
+    shopInBitTickets,
+  ];
+}
+
+typedef $$CakepayOrdersTableCreateCompanionBuilder =
+    CakepayOrdersCompanion Function({
+      required String orderId,
+      Value<int> rowid,
+    });
+typedef $$CakepayOrdersTableUpdateCompanionBuilder =
+    CakepayOrdersCompanion Function({Value<String> orderId, Value<int> rowid});
+
+class $$CakepayOrdersTableFilterComposer
+    extends Composer<_$SharedDatabase, $CakepayOrdersTable> {
+  $$CakepayOrdersTableFilterComposer({
+    required super.$db,
+    required super.$table,
+    super.joinBuilder,
+    super.$addJoinBuilderToRootComposer,
+    super.$removeJoinBuilderFromRootComposer,
+  });
+  ColumnFilters<String> get orderId => $composableBuilder(
+    column: $table.orderId,
+    builder: (column) => ColumnFilters(column),
+  );
+}
+
+class $$CakepayOrdersTableOrderingComposer
+    extends Composer<_$SharedDatabase, $CakepayOrdersTable> {
+  $$CakepayOrdersTableOrderingComposer({
+    required super.$db,
+    required super.$table,
+    super.joinBuilder,
+    super.$addJoinBuilderToRootComposer,
+    super.$removeJoinBuilderFromRootComposer,
+  });
+  ColumnOrderings<String> get orderId => $composableBuilder(
+    column: $table.orderId,
+    builder: (column) => ColumnOrderings(column),
+  );
+}
+
+class $$CakepayOrdersTableAnnotationComposer
+    extends Composer<_$SharedDatabase, $CakepayOrdersTable> {
+  $$CakepayOrdersTableAnnotationComposer({
+    required super.$db,
+    required super.$table,
+    super.joinBuilder,
+    super.$addJoinBuilderToRootComposer,
+    super.$removeJoinBuilderFromRootComposer,
+  });
+  GeneratedColumn<String> get orderId =>
+      $composableBuilder(column: $table.orderId, builder: (column) => column);
+}
+
+class $$CakepayOrdersTableTableManager
+    extends
+        RootTableManager<
+          _$SharedDatabase,
+          $CakepayOrdersTable,
+          CakepayOrder,
+          $$CakepayOrdersTableFilterComposer,
+          $$CakepayOrdersTableOrderingComposer,
+          $$CakepayOrdersTableAnnotationComposer,
+          $$CakepayOrdersTableCreateCompanionBuilder,
+          $$CakepayOrdersTableUpdateCompanionBuilder,
+          (
+            CakepayOrder,
+            BaseReferences<_$SharedDatabase, $CakepayOrdersTable, CakepayOrder>,
+          ),
+          CakepayOrder,
+          PrefetchHooks Function()
+        > {
+  $$CakepayOrdersTableTableManager(
+    _$SharedDatabase db,
+    $CakepayOrdersTable table,
+  ) : super(
+        TableManagerState(
+          db: db,
+          table: table,
+          createFilteringComposer: () =>
+              $$CakepayOrdersTableFilterComposer($db: db, $table: table),
+          createOrderingComposer: () =>
+              $$CakepayOrdersTableOrderingComposer($db: db, $table: table),
+          createComputedFieldComposer: () =>
+              $$CakepayOrdersTableAnnotationComposer($db: db, $table: table),
+          updateCompanionCallback:
+              ({
+                Value<String> orderId = const Value.absent(),
+                Value<int> rowid = const Value.absent(),
+              }) => CakepayOrdersCompanion(orderId: orderId, rowid: rowid),
+          createCompanionCallback:
+              ({
+                required String orderId,
+                Value<int> rowid = const Value.absent(),
+              }) =>
+                  CakepayOrdersCompanion.insert(orderId: orderId, rowid: rowid),
+          withReferenceMapper: (p0) => p0
+              .map((e) => (e.readTable(table), BaseReferences(db, table, e)))
+              .toList(),
+          prefetchHooksCallback: null,
+        ),
+      );
+}
+
+typedef $$CakepayOrdersTableProcessedTableManager =
+    ProcessedTableManager<
+      _$SharedDatabase,
+      $CakepayOrdersTable,
+      CakepayOrder,
+      $$CakepayOrdersTableFilterComposer,
+      $$CakepayOrdersTableOrderingComposer,
+      $$CakepayOrdersTableAnnotationComposer,
+      $$CakepayOrdersTableCreateCompanionBuilder,
+      $$CakepayOrdersTableUpdateCompanionBuilder,
+      (
+        CakepayOrder,
+        BaseReferences<_$SharedDatabase, $CakepayOrdersTable, CakepayOrder>,
+      ),
+      CakepayOrder,
+      PrefetchHooks Function()
+    >;
+typedef $$ShopinBitSettingsTableCreateCompanionBuilder =
+    ShopinBitSettingsCompanion Function({
+      Value<int> id,
+      Value<bool> guidelinesAccepted,
+      Value<bool> setupComplete,
+      Value<String?> displayName,
+    });
+typedef $$ShopinBitSettingsTableUpdateCompanionBuilder =
+    ShopinBitSettingsCompanion Function({
+      Value<int> id,
+      Value<bool> guidelinesAccepted,
+      Value<bool> setupComplete,
+      Value<String?> displayName,
+    });
+
+class $$ShopinBitSettingsTableFilterComposer
+    extends Composer<_$SharedDatabase, $ShopinBitSettingsTable> {
+  $$ShopinBitSettingsTableFilterComposer({
+    required super.$db,
+    required super.$table,
+    super.joinBuilder,
+    super.$addJoinBuilderToRootComposer,
+    super.$removeJoinBuilderFromRootComposer,
+  });
+  ColumnFilters<int> get id => $composableBuilder(
+    column: $table.id,
+    builder: (column) => ColumnFilters(column),
+  );
+
+  ColumnFilters<bool> get guidelinesAccepted => $composableBuilder(
+    column: $table.guidelinesAccepted,
+    builder: (column) => ColumnFilters(column),
+  );
+
+  ColumnFilters<bool> get setupComplete => $composableBuilder(
+    column: $table.setupComplete,
+    builder: (column) => ColumnFilters(column),
+  );
+
+  ColumnFilters<String> get displayName => $composableBuilder(
+    column: $table.displayName,
+    builder: (column) => ColumnFilters(column),
+  );
+}
+
+class $$ShopinBitSettingsTableOrderingComposer
+    extends Composer<_$SharedDatabase, $ShopinBitSettingsTable> {
+  $$ShopinBitSettingsTableOrderingComposer({
+    required super.$db,
+    required super.$table,
+    super.joinBuilder,
+    super.$addJoinBuilderToRootComposer,
+    super.$removeJoinBuilderFromRootComposer,
+  });
+  ColumnOrderings<int> get id => $composableBuilder(
+    column: $table.id,
+    builder: (column) => ColumnOrderings(column),
+  );
+
+  ColumnOrderings<bool> get guidelinesAccepted => $composableBuilder(
+    column: $table.guidelinesAccepted,
+    builder: (column) => ColumnOrderings(column),
+  );
+
+  ColumnOrderings<bool> get setupComplete => $composableBuilder(
+    column: $table.setupComplete,
+    builder: (column) => ColumnOrderings(column),
+  );
+
+  ColumnOrderings<String> get displayName => $composableBuilder(
+    column: $table.displayName,
+    builder: (column) => ColumnOrderings(column),
+  );
+}
+
+class $$ShopinBitSettingsTableAnnotationComposer
+    extends Composer<_$SharedDatabase, $ShopinBitSettingsTable> {
+  $$ShopinBitSettingsTableAnnotationComposer({
+    required super.$db,
+    required super.$table,
+    super.joinBuilder,
+    super.$addJoinBuilderToRootComposer,
+    super.$removeJoinBuilderFromRootComposer,
+  });
+  GeneratedColumn<int> get id =>
+      $composableBuilder(column: $table.id, builder: (column) => column);
+
+  GeneratedColumn<bool> get guidelinesAccepted => $composableBuilder(
+    column: $table.guidelinesAccepted,
+    builder: (column) => column,
+  );
+
+  GeneratedColumn<bool> get setupComplete => $composableBuilder(
+    column: $table.setupComplete,
+    builder: (column) => column,
+  );
+
+  GeneratedColumn<String> get displayName => $composableBuilder(
+    column: $table.displayName,
+    builder: (column) => column,
+  );
+}
+
+class $$ShopinBitSettingsTableTableManager
+    extends
+        RootTableManager<
+          _$SharedDatabase,
+          $ShopinBitSettingsTable,
+          ShopinBitSetting,
+          $$ShopinBitSettingsTableFilterComposer,
+          $$ShopinBitSettingsTableOrderingComposer,
+          $$ShopinBitSettingsTableAnnotationComposer,
+          $$ShopinBitSettingsTableCreateCompanionBuilder,
+          $$ShopinBitSettingsTableUpdateCompanionBuilder,
+          (
+            ShopinBitSetting,
+            BaseReferences<
+              _$SharedDatabase,
+              $ShopinBitSettingsTable,
+              ShopinBitSetting
+            >,
+          ),
+          ShopinBitSetting,
+          PrefetchHooks Function()
+        > {
+  $$ShopinBitSettingsTableTableManager(
+    _$SharedDatabase db,
+    $ShopinBitSettingsTable table,
+  ) : super(
+        TableManagerState(
+          db: db,
+          table: table,
+          createFilteringComposer: () =>
+              $$ShopinBitSettingsTableFilterComposer($db: db, $table: table),
+          createOrderingComposer: () =>
+              $$ShopinBitSettingsTableOrderingComposer($db: db, $table: table),
+          createComputedFieldComposer: () =>
+              $$ShopinBitSettingsTableAnnotationComposer(
+                $db: db,
+                $table: table,
+              ),
+          updateCompanionCallback:
+              ({
+                Value<int> id = const Value.absent(),
+                Value<bool> guidelinesAccepted = const Value.absent(),
+                Value<bool> setupComplete = const Value.absent(),
+                Value<String?> displayName = const Value.absent(),
+              }) => ShopinBitSettingsCompanion(
+                id: id,
+                guidelinesAccepted: guidelinesAccepted,
+                setupComplete: setupComplete,
+                displayName: displayName,
+              ),
+          createCompanionCallback:
+              ({
+                Value<int> id = const Value.absent(),
+                Value<bool> guidelinesAccepted = const Value.absent(),
+                Value<bool> setupComplete = const Value.absent(),
+                Value<String?> displayName = const Value.absent(),
+              }) => ShopinBitSettingsCompanion.insert(
+                id: id,
+                guidelinesAccepted: guidelinesAccepted,
+                setupComplete: setupComplete,
+                displayName: displayName,
+              ),
+          withReferenceMapper: (p0) => p0
+              .map((e) => (e.readTable(table), BaseReferences(db, table, e)))
+              .toList(),
+          prefetchHooksCallback: null,
+        ),
+      );
+}
+
+typedef $$ShopinBitSettingsTableProcessedTableManager =
+    ProcessedTableManager<
+      _$SharedDatabase,
+      $ShopinBitSettingsTable,
+      ShopinBitSetting,
+      $$ShopinBitSettingsTableFilterComposer,
+      $$ShopinBitSettingsTableOrderingComposer,
+      $$ShopinBitSettingsTableAnnotationComposer,
+      $$ShopinBitSettingsTableCreateCompanionBuilder,
+      $$ShopinBitSettingsTableUpdateCompanionBuilder,
+      (
+        ShopinBitSetting,
+        BaseReferences<
+          _$SharedDatabase,
+          $ShopinBitSettingsTable,
+          ShopinBitSetting
+        >,
+      ),
+      ShopinBitSetting,
+      PrefetchHooks Function()
+    >;
+typedef $$ShopInBitTicketsTableCreateCompanionBuilder =
+    ShopInBitTicketsCompanion Function({
+      required String ticketId,
+      required String displayName,
+      required ShopInBitCategory category,
+      required ShopInBitOrderStatus status,
+      required String requestDescription,
+      required String deliveryCountry,
+      Value<String?> offerProductName,
+      Value<String?> offerPrice,
+      required String shippingName,
+      required String shippingStreet,
+      required String shippingCity,
+      required String shippingPostalCode,
+      required String shippingCountry,
+      Value<String?> paymentMethod,
+      required List<ShopInBitTicketMessage> messages,
+      required DateTime createdAt,
+      required int apiTicketId,
+      Value<String?> carResearchInvoiceId,
+      Value<String?> feeTicketNumber,
+      required bool needsCreateRequest,
+      required bool isPendingPayment,
+      Value<DateTime?> carResearchExpiresAt,
+      Value<String?> carResearchPaymentLinks,
+      Value<int> rowid,
+    });
+typedef $$ShopInBitTicketsTableUpdateCompanionBuilder =
+    ShopInBitTicketsCompanion Function({
+      Value<String> ticketId,
+      Value<String> displayName,
+      Value<ShopInBitCategory> category,
+      Value<ShopInBitOrderStatus> status,
+      Value<String> requestDescription,
+      Value<String> deliveryCountry,
+      Value<String?> offerProductName,
+      Value<String?> offerPrice,
+      Value<String> shippingName,
+      Value<String> shippingStreet,
+      Value<String> shippingCity,
+      Value<String> shippingPostalCode,
+      Value<String> shippingCountry,
+      Value<String?> paymentMethod,
+      Value<List<ShopInBitTicketMessage>> messages,
+      Value<DateTime> createdAt,
+      Value<int> apiTicketId,
+      Value<String?> carResearchInvoiceId,
+      Value<String?> feeTicketNumber,
+      Value<bool> needsCreateRequest,
+      Value<bool> isPendingPayment,
+      Value<DateTime?> carResearchExpiresAt,
+      Value<String?> carResearchPaymentLinks,
+      Value<int> rowid,
+    });
+
+class $$ShopInBitTicketsTableFilterComposer
+    extends Composer<_$SharedDatabase, $ShopInBitTicketsTable> {
+  $$ShopInBitTicketsTableFilterComposer({
+    required super.$db,
+    required super.$table,
+    super.joinBuilder,
+    super.$addJoinBuilderToRootComposer,
+    super.$removeJoinBuilderFromRootComposer,
+  });
+  ColumnFilters<String> get ticketId => $composableBuilder(
+    column: $table.ticketId,
+    builder: (column) => ColumnFilters(column),
+  );
+
+  ColumnFilters<String> get displayName => $composableBuilder(
+    column: $table.displayName,
+    builder: (column) => ColumnFilters(column),
+  );
+
+  ColumnWithTypeConverterFilters<ShopInBitCategory, ShopInBitCategory, int>
+  get category => $composableBuilder(
+    column: $table.category,
+    builder: (column) => ColumnWithTypeConverterFilters(column),
+  );
+
+  ColumnWithTypeConverterFilters<
+    ShopInBitOrderStatus,
+    ShopInBitOrderStatus,
+    int
+  >
+  get status => $composableBuilder(
+    column: $table.status,
+    builder: (column) => ColumnWithTypeConverterFilters(column),
+  );
+
+  ColumnFilters<String> get requestDescription => $composableBuilder(
+    column: $table.requestDescription,
+    builder: (column) => ColumnFilters(column),
+  );
+
+  ColumnFilters<String> get deliveryCountry => $composableBuilder(
+    column: $table.deliveryCountry,
+    builder: (column) => ColumnFilters(column),
+  );
+
+  ColumnFilters<String> get offerProductName => $composableBuilder(
+    column: $table.offerProductName,
+    builder: (column) => ColumnFilters(column),
+  );
+
+  ColumnFilters<String> get offerPrice => $composableBuilder(
+    column: $table.offerPrice,
+    builder: (column) => ColumnFilters(column),
+  );
+
+  ColumnFilters<String> get shippingName => $composableBuilder(
+    column: $table.shippingName,
+    builder: (column) => ColumnFilters(column),
+  );
+
+  ColumnFilters<String> get shippingStreet => $composableBuilder(
+    column: $table.shippingStreet,
+    builder: (column) => ColumnFilters(column),
+  );
+
+  ColumnFilters<String> get shippingCity => $composableBuilder(
+    column: $table.shippingCity,
+    builder: (column) => ColumnFilters(column),
+  );
+
+  ColumnFilters<String> get shippingPostalCode => $composableBuilder(
+    column: $table.shippingPostalCode,
+    builder: (column) => ColumnFilters(column),
+  );
+
+  ColumnFilters<String> get shippingCountry => $composableBuilder(
+    column: $table.shippingCountry,
+    builder: (column) => ColumnFilters(column),
+  );
+
+  ColumnFilters<String> get paymentMethod => $composableBuilder(
+    column: $table.paymentMethod,
+    builder: (column) => ColumnFilters(column),
+  );
+
+  ColumnWithTypeConverterFilters<
+    List<ShopInBitTicketMessage>,
+    List<ShopInBitTicketMessage>,
+    String
+  >
+  get messages => $composableBuilder(
+    column: $table.messages,
+    builder: (column) => ColumnWithTypeConverterFilters(column),
+  );
+
+  ColumnFilters<DateTime> get createdAt => $composableBuilder(
+    column: $table.createdAt,
+    builder: (column) => ColumnFilters(column),
+  );
+
+  ColumnFilters<int> get apiTicketId => $composableBuilder(
+    column: $table.apiTicketId,
+    builder: (column) => ColumnFilters(column),
+  );
+
+  ColumnFilters<String> get carResearchInvoiceId => $composableBuilder(
+    column: $table.carResearchInvoiceId,
+    builder: (column) => ColumnFilters(column),
+  );
+
+  ColumnFilters<String> get feeTicketNumber => $composableBuilder(
+    column: $table.feeTicketNumber,
+    builder: (column) => ColumnFilters(column),
+  );
+
+  ColumnFilters<bool> get needsCreateRequest => $composableBuilder(
+    column: $table.needsCreateRequest,
+    builder: (column) => ColumnFilters(column),
+  );
+
+  ColumnFilters<bool> get isPendingPayment => $composableBuilder(
+    column: $table.isPendingPayment,
+    builder: (column) => ColumnFilters(column),
+  );
+
+  ColumnFilters<DateTime> get carResearchExpiresAt => $composableBuilder(
+    column: $table.carResearchExpiresAt,
+    builder: (column) => ColumnFilters(column),
+  );
+
+  ColumnFilters<String> get carResearchPaymentLinks => $composableBuilder(
+    column: $table.carResearchPaymentLinks,
+    builder: (column) => ColumnFilters(column),
+  );
+}
+
+class $$ShopInBitTicketsTableOrderingComposer
+    extends Composer<_$SharedDatabase, $ShopInBitTicketsTable> {
+  $$ShopInBitTicketsTableOrderingComposer({
+    required super.$db,
+    required super.$table,
+    super.joinBuilder,
+    super.$addJoinBuilderToRootComposer,
+    super.$removeJoinBuilderFromRootComposer,
+  });
+  ColumnOrderings<String> get ticketId => $composableBuilder(
+    column: $table.ticketId,
+    builder: (column) => ColumnOrderings(column),
+  );
+
+  ColumnOrderings<String> get displayName => $composableBuilder(
+    column: $table.displayName,
+    builder: (column) => ColumnOrderings(column),
+  );
+
+  ColumnOrderings<int> get category => $composableBuilder(
+    column: $table.category,
+    builder: (column) => ColumnOrderings(column),
+  );
+
+  ColumnOrderings<int> get status => $composableBuilder(
+    column: $table.status,
+    builder: (column) => ColumnOrderings(column),
+  );
+
+  ColumnOrderings<String> get requestDescription => $composableBuilder(
+    column: $table.requestDescription,
+    builder: (column) => ColumnOrderings(column),
+  );
+
+  ColumnOrderings<String> get deliveryCountry => $composableBuilder(
+    column: $table.deliveryCountry,
+    builder: (column) => ColumnOrderings(column),
+  );
+
+  ColumnOrderings<String> get offerProductName => $composableBuilder(
+    column: $table.offerProductName,
+    builder: (column) => ColumnOrderings(column),
+  );
+
+  ColumnOrderings<String> get offerPrice => $composableBuilder(
+    column: $table.offerPrice,
+    builder: (column) => ColumnOrderings(column),
+  );
+
+  ColumnOrderings<String> get shippingName => $composableBuilder(
+    column: $table.shippingName,
+    builder: (column) => ColumnOrderings(column),
+  );
+
+  ColumnOrderings<String> get shippingStreet => $composableBuilder(
+    column: $table.shippingStreet,
+    builder: (column) => ColumnOrderings(column),
+  );
+
+  ColumnOrderings<String> get shippingCity => $composableBuilder(
+    column: $table.shippingCity,
+    builder: (column) => ColumnOrderings(column),
+  );
+
+  ColumnOrderings<String> get shippingPostalCode => $composableBuilder(
+    column: $table.shippingPostalCode,
+    builder: (column) => ColumnOrderings(column),
+  );
+
+  ColumnOrderings<String> get shippingCountry => $composableBuilder(
+    column: $table.shippingCountry,
+    builder: (column) => ColumnOrderings(column),
+  );
+
+  ColumnOrderings<String> get paymentMethod => $composableBuilder(
+    column: $table.paymentMethod,
+    builder: (column) => ColumnOrderings(column),
+  );
+
+  ColumnOrderings<String> get messages => $composableBuilder(
+    column: $table.messages,
+    builder: (column) => ColumnOrderings(column),
+  );
+
+  ColumnOrderings<DateTime> get createdAt => $composableBuilder(
+    column: $table.createdAt,
+    builder: (column) => ColumnOrderings(column),
+  );
+
+  ColumnOrderings<int> get apiTicketId => $composableBuilder(
+    column: $table.apiTicketId,
+    builder: (column) => ColumnOrderings(column),
+  );
+
+  ColumnOrderings<String> get carResearchInvoiceId => $composableBuilder(
+    column: $table.carResearchInvoiceId,
+    builder: (column) => ColumnOrderings(column),
+  );
+
+  ColumnOrderings<String> get feeTicketNumber => $composableBuilder(
+    column: $table.feeTicketNumber,
+    builder: (column) => ColumnOrderings(column),
+  );
+
+  ColumnOrderings<bool> get needsCreateRequest => $composableBuilder(
+    column: $table.needsCreateRequest,
+    builder: (column) => ColumnOrderings(column),
+  );
+
+  ColumnOrderings<bool> get isPendingPayment => $composableBuilder(
+    column: $table.isPendingPayment,
+    builder: (column) => ColumnOrderings(column),
+  );
+
+  ColumnOrderings<DateTime> get carResearchExpiresAt => $composableBuilder(
+    column: $table.carResearchExpiresAt,
+    builder: (column) => ColumnOrderings(column),
+  );
+
+  ColumnOrderings<String> get carResearchPaymentLinks => $composableBuilder(
+    column: $table.carResearchPaymentLinks,
+    builder: (column) => ColumnOrderings(column),
+  );
+}
+
+class $$ShopInBitTicketsTableAnnotationComposer
+    extends Composer<_$SharedDatabase, $ShopInBitTicketsTable> {
+  $$ShopInBitTicketsTableAnnotationComposer({
+    required super.$db,
+    required super.$table,
+    super.joinBuilder,
+    super.$addJoinBuilderToRootComposer,
+    super.$removeJoinBuilderFromRootComposer,
+  });
+  GeneratedColumn<String> get ticketId =>
+      $composableBuilder(column: $table.ticketId, builder: (column) => column);
+
+  GeneratedColumn<String> get displayName => $composableBuilder(
+    column: $table.displayName,
+    builder: (column) => column,
+  );
+
+  GeneratedColumnWithTypeConverter<ShopInBitCategory, int> get category =>
+      $composableBuilder(column: $table.category, builder: (column) => column);
+
+  GeneratedColumnWithTypeConverter<ShopInBitOrderStatus, int> get status =>
+      $composableBuilder(column: $table.status, builder: (column) => column);
+
+  GeneratedColumn<String> get requestDescription => $composableBuilder(
+    column: $table.requestDescription,
+    builder: (column) => column,
+  );
+
+  GeneratedColumn<String> get deliveryCountry => $composableBuilder(
+    column: $table.deliveryCountry,
+    builder: (column) => column,
+  );
+
+  GeneratedColumn<String> get offerProductName => $composableBuilder(
+    column: $table.offerProductName,
+    builder: (column) => column,
+  );
+
+  GeneratedColumn<String> get offerPrice => $composableBuilder(
+    column: $table.offerPrice,
+    builder: (column) => column,
+  );
+
+  GeneratedColumn<String> get shippingName => $composableBuilder(
+    column: $table.shippingName,
+    builder: (column) => column,
+  );
+
+  GeneratedColumn<String> get shippingStreet => $composableBuilder(
+    column: $table.shippingStreet,
+    builder: (column) => column,
+  );
+
+  GeneratedColumn<String> get shippingCity => $composableBuilder(
+    column: $table.shippingCity,
+    builder: (column) => column,
+  );
+
+  GeneratedColumn<String> get shippingPostalCode => $composableBuilder(
+    column: $table.shippingPostalCode,
+    builder: (column) => column,
+  );
+
+  GeneratedColumn<String> get shippingCountry => $composableBuilder(
+    column: $table.shippingCountry,
+    builder: (column) => column,
+  );
+
+  GeneratedColumn<String> get paymentMethod => $composableBuilder(
+    column: $table.paymentMethod,
+    builder: (column) => column,
+  );
+
+  GeneratedColumnWithTypeConverter<List<ShopInBitTicketMessage>, String>
+  get messages =>
+      $composableBuilder(column: $table.messages, builder: (column) => column);
+
+  GeneratedColumn<DateTime> get createdAt =>
+      $composableBuilder(column: $table.createdAt, builder: (column) => column);
+
+  GeneratedColumn<int> get apiTicketId => $composableBuilder(
+    column: $table.apiTicketId,
+    builder: (column) => column,
+  );
+
+  GeneratedColumn<String> get carResearchInvoiceId => $composableBuilder(
+    column: $table.carResearchInvoiceId,
+    builder: (column) => column,
+  );
+
+  GeneratedColumn<String> get feeTicketNumber => $composableBuilder(
+    column: $table.feeTicketNumber,
+    builder: (column) => column,
+  );
+
+  GeneratedColumn<bool> get needsCreateRequest => $composableBuilder(
+    column: $table.needsCreateRequest,
+    builder: (column) => column,
+  );
+
+  GeneratedColumn<bool> get isPendingPayment => $composableBuilder(
+    column: $table.isPendingPayment,
+    builder: (column) => column,
+  );
+
+  GeneratedColumn<DateTime> get carResearchExpiresAt => $composableBuilder(
+    column: $table.carResearchExpiresAt,
+    builder: (column) => column,
+  );
+
+  GeneratedColumn<String> get carResearchPaymentLinks => $composableBuilder(
+    column: $table.carResearchPaymentLinks,
+    builder: (column) => column,
+  );
+}
+
+class $$ShopInBitTicketsTableTableManager
+    extends
+        RootTableManager<
+          _$SharedDatabase,
+          $ShopInBitTicketsTable,
+          ShopInBitTicket,
+          $$ShopInBitTicketsTableFilterComposer,
+          $$ShopInBitTicketsTableOrderingComposer,
+          $$ShopInBitTicketsTableAnnotationComposer,
+          $$ShopInBitTicketsTableCreateCompanionBuilder,
+          $$ShopInBitTicketsTableUpdateCompanionBuilder,
+          (
+            ShopInBitTicket,
+            BaseReferences<
+              _$SharedDatabase,
+              $ShopInBitTicketsTable,
+              ShopInBitTicket
+            >,
+          ),
+          ShopInBitTicket,
+          PrefetchHooks Function()
+        > {
+  $$ShopInBitTicketsTableTableManager(
+    _$SharedDatabase db,
+    $ShopInBitTicketsTable table,
+  ) : super(
+        TableManagerState(
+          db: db,
+          table: table,
+          createFilteringComposer: () =>
+              $$ShopInBitTicketsTableFilterComposer($db: db, $table: table),
+          createOrderingComposer: () =>
+              $$ShopInBitTicketsTableOrderingComposer($db: db, $table: table),
+          createComputedFieldComposer: () =>
+              $$ShopInBitTicketsTableAnnotationComposer($db: db, $table: table),
+          updateCompanionCallback:
+              ({
+                Value<String> ticketId = const Value.absent(),
+                Value<String> displayName = const Value.absent(),
+                Value<ShopInBitCategory> category = const Value.absent(),
+                Value<ShopInBitOrderStatus> status = const Value.absent(),
+                Value<String> requestDescription = const Value.absent(),
+                Value<String> deliveryCountry = const Value.absent(),
+                Value<String?> offerProductName = const Value.absent(),
+                Value<String?> offerPrice = const Value.absent(),
+                Value<String> shippingName = const Value.absent(),
+                Value<String> shippingStreet = const Value.absent(),
+                Value<String> shippingCity = const Value.absent(),
+                Value<String> shippingPostalCode = const Value.absent(),
+                Value<String> shippingCountry = const Value.absent(),
+                Value<String?> paymentMethod = const Value.absent(),
+                Value<List<ShopInBitTicketMessage>> messages =
+                    const Value.absent(),
+                Value<DateTime> createdAt = const Value.absent(),
+                Value<int> apiTicketId = const Value.absent(),
+                Value<String?> carResearchInvoiceId = const Value.absent(),
+                Value<String?> feeTicketNumber = const Value.absent(),
+                Value<bool> needsCreateRequest = const Value.absent(),
+                Value<bool> isPendingPayment = const Value.absent(),
+                Value<DateTime?> carResearchExpiresAt = const Value.absent(),
+                Value<String?> carResearchPaymentLinks = const Value.absent(),
+                Value<int> rowid = const Value.absent(),
+              }) => ShopInBitTicketsCompanion(
+                ticketId: ticketId,
+                displayName: displayName,
+                category: category,
+                status: status,
+                requestDescription: requestDescription,
+                deliveryCountry: deliveryCountry,
+                offerProductName: offerProductName,
+                offerPrice: offerPrice,
+                shippingName: shippingName,
+                shippingStreet: shippingStreet,
+                shippingCity: shippingCity,
+                shippingPostalCode: shippingPostalCode,
+                shippingCountry: shippingCountry,
+                paymentMethod: paymentMethod,
+                messages: messages,
+                createdAt: createdAt,
+                apiTicketId: apiTicketId,
+                carResearchInvoiceId: carResearchInvoiceId,
+                feeTicketNumber: feeTicketNumber,
+                needsCreateRequest: needsCreateRequest,
+                isPendingPayment: isPendingPayment,
+                carResearchExpiresAt: carResearchExpiresAt,
+                carResearchPaymentLinks: carResearchPaymentLinks,
+                rowid: rowid,
+              ),
+          createCompanionCallback:
+              ({
+                required String ticketId,
+                required String displayName,
+                required ShopInBitCategory category,
+                required ShopInBitOrderStatus status,
+                required String requestDescription,
+                required String deliveryCountry,
+                Value<String?> offerProductName = const Value.absent(),
+                Value<String?> offerPrice = const Value.absent(),
+                required String shippingName,
+                required String shippingStreet,
+                required String shippingCity,
+                required String shippingPostalCode,
+                required String shippingCountry,
+                Value<String?> paymentMethod = const Value.absent(),
+                required List<ShopInBitTicketMessage> messages,
+                required DateTime createdAt,
+                required int apiTicketId,
+                Value<String?> carResearchInvoiceId = const Value.absent(),
+                Value<String?> feeTicketNumber = const Value.absent(),
+                required bool needsCreateRequest,
+                required bool isPendingPayment,
+                Value<DateTime?> carResearchExpiresAt = const Value.absent(),
+                Value<String?> carResearchPaymentLinks = const Value.absent(),
+                Value<int> rowid = const Value.absent(),
+              }) => ShopInBitTicketsCompanion.insert(
+                ticketId: ticketId,
+                displayName: displayName,
+                category: category,
+                status: status,
+                requestDescription: requestDescription,
+                deliveryCountry: deliveryCountry,
+                offerProductName: offerProductName,
+                offerPrice: offerPrice,
+                shippingName: shippingName,
+                shippingStreet: shippingStreet,
+                shippingCity: shippingCity,
+                shippingPostalCode: shippingPostalCode,
+                shippingCountry: shippingCountry,
+                paymentMethod: paymentMethod,
+                messages: messages,
+                createdAt: createdAt,
+                apiTicketId: apiTicketId,
+                carResearchInvoiceId: carResearchInvoiceId,
+                feeTicketNumber: feeTicketNumber,
+                needsCreateRequest: needsCreateRequest,
+                isPendingPayment: isPendingPayment,
+                carResearchExpiresAt: carResearchExpiresAt,
+                carResearchPaymentLinks: carResearchPaymentLinks,
+                rowid: rowid,
+              ),
+          withReferenceMapper: (p0) => p0
+              .map((e) => (e.readTable(table), BaseReferences(db, table, e)))
+              .toList(),
+          prefetchHooksCallback: null,
+        ),
+      );
+}
+
+typedef $$ShopInBitTicketsTableProcessedTableManager =
+    ProcessedTableManager<
+      _$SharedDatabase,
+      $ShopInBitTicketsTable,
+      ShopInBitTicket,
+      $$ShopInBitTicketsTableFilterComposer,
+      $$ShopInBitTicketsTableOrderingComposer,
+      $$ShopInBitTicketsTableAnnotationComposer,
+      $$ShopInBitTicketsTableCreateCompanionBuilder,
+      $$ShopInBitTicketsTableUpdateCompanionBuilder,
+      (
+        ShopInBitTicket,
+        BaseReferences<
+          _$SharedDatabase,
+          $ShopInBitTicketsTable,
+          ShopInBitTicket
+        >,
+      ),
+      ShopInBitTicket,
+      PrefetchHooks Function()
+    >;
+
+class $SharedDatabaseManager {
+  final _$SharedDatabase _db;
+  $SharedDatabaseManager(this._db);
+  $$CakepayOrdersTableTableManager get cakepayOrders =>
+      $$CakepayOrdersTableTableManager(_db, _db.cakepayOrders);
+  $$ShopinBitSettingsTableTableManager get shopinBitSettings =>
+      $$ShopinBitSettingsTableTableManager(_db, _db.shopinBitSettings);
+  $$ShopInBitTicketsTableTableManager get shopInBitTickets =>
+      $$ShopInBitTicketsTableTableManager(_db, _db.shopInBitTickets);
+}
+
+mixin _$ShopinBitSettingsDaoMixin on DatabaseAccessor<SharedDatabase> {
+  $ShopinBitSettingsTable get shopinBitSettings =>
+      attachedDatabase.shopinBitSettings;
+  ShopinBitSettingsDaoManager get managers => ShopinBitSettingsDaoManager(this);
+}
+
+class ShopinBitSettingsDaoManager {
+  final _$ShopinBitSettingsDaoMixin _db;
+  ShopinBitSettingsDaoManager(this._db);
+  $$ShopinBitSettingsTableTableManager get shopinBitSettings =>
+      $$ShopinBitSettingsTableTableManager(
+        _db.attachedDatabase,
+        _db.shopinBitSettings,
+      );
+}
diff --git a/lib/db/drift/shared_db/tables/cakepay_orders.dart b/lib/db/drift/shared_db/tables/cakepay_orders.dart
new file mode 100644
index 0000000..8dc7f82
--- /dev/null
+++ b/lib/db/drift/shared_db/tables/cakepay_orders.dart
@@ -0,0 +1,8 @@
+import 'package:drift/drift.dart';
+
+class CakepayOrders extends Table {
+  TextColumn get orderId => text()();
+
+  @override
+  Set<Column> get primaryKey => {orderId};
+}
diff --git a/lib/db/drift/shared_db/tables/shopin_bit_settings.dart b/lib/db/drift/shared_db/tables/shopin_bit_settings.dart
new file mode 100644
index 0000000..e4c3253
--- /dev/null
+++ b/lib/db/drift/shared_db/tables/shopin_bit_settings.dart
@@ -0,0 +1,15 @@
+import 'package:drift/drift.dart';
+
+class ShopinBitSettings extends Table {
+  // Single row table - always row 0
+  IntColumn get id => integer().withDefault(const Constant(0))();
+
+  BoolColumn get guidelinesAccepted =>
+      boolean().withDefault(const Constant(false))();
+  BoolColumn get setupComplete =>
+      boolean().withDefault(const Constant(false))();
+  TextColumn get displayName => text().nullable()();
+
+  @override
+  Set<Column> get primaryKey => {id};
+}
diff --git a/lib/db/drift/shared_db/tables/shopin_bit_tickets.dart b/lib/db/drift/shared_db/tables/shopin_bit_tickets.dart
new file mode 100644
index 0000000..b8afcc9
--- /dev/null
+++ b/lib/db/drift/shared_db/tables/shopin_bit_tickets.dart
@@ -0,0 +1,112 @@
+import "dart:convert";
+
+import "package:drift/drift.dart";
+
+import '../../../../models/shopinbit/shopinbit_order_model.dart'
+    show ShopInBitCategory, ShopInBitOrderStatus;
+
+class ShopInBitTickets extends Table {
+  TextColumn get ticketId => text()();
+
+  TextColumn get displayName => text()();
+
+  IntColumn get category => intEnum<ShopInBitCategory>()();
+  IntColumn get status => intEnum<ShopInBitOrderStatus>()();
+
+  TextColumn get requestDescription => text()();
+  TextColumn get deliveryCountry => text()();
+  TextColumn get offerProductName => text().nullable()();
+  TextColumn get offerPrice => text().nullable()();
+
+  TextColumn get shippingName => text()();
+  TextColumn get shippingStreet => text()();
+  TextColumn get shippingCity => text()();
+  TextColumn get shippingPostalCode => text()();
+  TextColumn get shippingCountry => text()();
+
+  TextColumn get paymentMethod => text().nullable()();
+
+  TextColumn get messages =>
+      text().map(const ShopInBitTicketMessagesConverter())();
+
+  DateTimeColumn get createdAt => dateTime()();
+  IntColumn get apiTicketId => integer()();
+
+  // Car research retry support
+  TextColumn get carResearchInvoiceId => text().nullable()();
+  TextColumn get feeTicketNumber => text().nullable()();
+  BoolColumn get needsCreateRequest => boolean()();
+
+  // Car research resumable payment state
+  BoolColumn get isPendingPayment => boolean()();
+  DateTimeColumn get carResearchExpiresAt => dateTime().nullable()();
+  TextColumn get carResearchPaymentLinks => text().nullable()();
+
+  @override
+  Set<Column<Object>> get primaryKey => {ticketId};
+}
+
+class ShopInBitTicketMessage {
+  final String text;
+  final DateTime timestamp;
+  final bool isFromUser;
+
+  const ShopInBitTicketMessage({
+    required this.text,
+    required this.timestamp,
+    required this.isFromUser,
+  });
+
+  factory ShopInBitTicketMessage.fromJson(Map<String, dynamic> json) {
+    return ShopInBitTicketMessage(
+      text: json["text"] as String,
+      timestamp: DateTime.parse(json["timestamp"] as String),
+      isFromUser: json["isFromUser"] as bool,
+    );
+  }
+
+  Map<String, dynamic> toMap() {
+    return {
+      "text": text,
+      "timestamp": timestamp.toIso8601String(),
+      "isFromUser": isFromUser,
+    };
+  }
+
+  @override
+  String toString() => toMap().toString();
+}
+
+class ShopInBitTicketMessagesConverter
+    extends TypeConverter<List<ShopInBitTicketMessage>, String>
+    with
+        JsonTypeConverter2<
+          List<ShopInBitTicketMessage>,
+          String,
+          List<dynamic>
+        > {
+  const ShopInBitTicketMessagesConverter();
+
+  @override
+  List<ShopInBitTicketMessage> fromSql(String fromDb) {
+    final List<dynamic> decoded = jsonDecode(fromDb) as List<dynamic>;
+    return fromJson(decoded);
+  }
+
+  @override
+  String toSql(List<ShopInBitTicketMessage> value) {
+    return jsonEncode(toJson(value));
+  }
+
+  @override
+  List<ShopInBitTicketMessage> fromJson(List<dynamic> json) {
+    return json
+        .map((e) => ShopInBitTicketMessage.fromJson(e as Map<String, dynamic>))
+        .toList();
+  }
+
+  @override
+  List<dynamic> toJson(List<ShopInBitTicketMessage> value) {
+    return value.map((m) => m.toMap()).toList();
+  }
+}
diff --git a/lib/db/isar/main_db.dart b/lib/db/isar/main_db.dart
index 6c6a3e8..3b86d74 100644
--- a/lib/db/isar/main_db.dart
+++ b/lib/db/isar/main_db.dart
@@ -73,7 +73,6 @@ class MainDB {
         TokenWalletInfoSchema,
         FrostWalletInfoSchema,
         WalletSolanaTokenInfoSchema,
-        ShopInBitTicketSchema,
       ],
       directory: (await StackFileSystem.applicationIsarDirectory()).path,
       // inspector: kDebugMode,
@@ -82,13 +81,6 @@ class MainDB {
       maxSizeMiB: Platform.isWindows ? 1024 : 512,
     );
 
-    // Clear on schema mismatch; tickets are recoverable from the API.
-    try {
-      isar.shopInBitTickets.where().findAllSync();
-    } catch (_) {
-      await isar.writeTxn(() async => isar.shopInBitTickets.clear());
-    }
-
     return true;
   }
 
@@ -654,34 +646,4 @@ class MainDB {
       isar.writeTxn(() async {
         await isar.solContracts.putAll(tokens);
       });
-
-  // ========== ShopInBit tickets ===============================================
-
-  List<ShopInBitTicket> getShopInBitTickets() {
-    try {
-      return isar.shopInBitTickets.where().sortByCreatedAtDesc().findAllSync();
-    } catch (_) {
-      return [];
-    }
-  }
-
-  Future<int> putShopInBitTicket(ShopInBitTicket ticket) async {
-    try {
-      return await isar.writeTxn(() async {
-        return await isar.shopInBitTickets.put(ticket);
-      });
-    } catch (e) {
-      throw MainDBException("failed putShopInBitTicket", e);
-    }
-  }
-
-  Future<bool> deleteShopInBitTicket(String ticketId) async {
-    try {
-      return await isar.writeTxn(() async {
-        return await isar.shopInBitTickets.deleteByTicketId(ticketId);
-      });
-    } catch (e) {
-      throw MainDBException("failed deleteShopInBitTicket: $ticketId", e);
-    }
-  }
 }
diff --git a/lib/models/isar/models/isar_models.dart b/lib/models/isar/models/isar_models.dart
index 8206fc0..cf27091 100644
--- a/lib/models/isar/models/isar_models.dart
+++ b/lib/models/isar/models/isar_models.dart
@@ -17,6 +17,5 @@ export 'blockchain_data/utxo.dart';
 export 'ethereum/eth_contract.dart';
 export 'log.dart';
 export 'solana/sol_contract.dart';
-export 'shopinbit_ticket.dart';
 export 'transaction_note.dart';
 export '../../../wallets/isar/models/wallet_solana_token_info.dart';
diff --git a/lib/models/isar/models/shopinbit_ticket.dart b/lib/models/isar/models/shopinbit_ticket.dart
deleted file mode 100644
index 0a2ac53..0000000
--- a/lib/models/isar/models/shopinbit_ticket.dart
+++ /dev/null
@@ -1,51 +0,0 @@
-import 'package:isar_community/isar.dart';
-
-import '../../shopinbit/shopinbit_order_model.dart';
-
-part 'shopinbit_ticket.g.dart';
-
-@collection
-class ShopInBitTicket {
-  Id id = Isar.autoIncrement;
-
-  @Index(unique: true, replace: true)
-  late String ticketId;
-
-  late String displayName;
-  @enumerated
-  late ShopInBitCategory category;
-  @enumerated
-  late ShopInBitOrderStatus status;
-  late String requestDescription;
-  late String deliveryCountry;
-  late String? offerProductName;
-  late String? offerPrice;
-  late String shippingName;
-  late String shippingStreet;
-  late String shippingCity;
-  late String shippingPostalCode;
-  late String shippingCountry;
-  late String? paymentMethod;
-  late List<ShopInBitTicketMessage> messages;
-  late DateTime createdAt;
-  late int apiTicketId;
-
-  // Car research retry support
-  String? carResearchInvoiceId;
-  String? feeTicketNumber;
-  late bool needsCreateRequest;
-
-  // Car research resumable payment state
-  late bool isPendingPayment;
-  DateTime? carResearchExpiresAt;
-  String? carResearchPaymentLinks;
-}
-
-@embedded
-class ShopInBitTicketMessage {
-  late String text;
-  late DateTime timestamp;
-  late bool isFromUser;
-
-  ShopInBitTicketMessage();
-}
diff --git a/lib/models/isar/models/shopinbit_ticket.g.dart b/lib/models/isar/models/shopinbit_ticket.g.dart
deleted file mode 100644
index ecd600a..0000000
--- a/lib/models/isar/models/shopinbit_ticket.g.dart
+++ /dev/null
@@ -1,4651 +0,0 @@
-// GENERATED CODE - DO NOT MODIFY BY HAND
-
-part of 'shopinbit_ticket.dart';
-
-// **************************************************************************
-// IsarCollectionGenerator
-// **************************************************************************
-
-// coverage:ignore-file
-// ignore_for_file: duplicate_ignore, non_constant_identifier_names, constant_identifier_names, invalid_use_of_protected_member, unnecessary_cast, prefer_const_constructors, lines_longer_than_80_chars, require_trailing_commas, inference_failure_on_function_invocation, unnecessary_parenthesis, unnecessary_raw_strings, unnecessary_null_checks, join_return_with_assignment, prefer_final_locals, avoid_js_rounded_ints, avoid_positional_boolean_parameters, always_specify_types
-
-extension GetShopInBitTicketCollection on Isar {
-  IsarCollection<ShopInBitTicket> get shopInBitTickets => this.collection();
-}
-
-const ShopInBitTicketSchema = CollectionSchema(
-  name: r'ShopInBitTicket',
-  id: 1968691807160517649,
-  properties: {
-    r'apiTicketId': PropertySchema(
-      id: 0,
-      name: r'apiTicketId',
-      type: IsarType.long,
-    ),
-    r'carResearchExpiresAt': PropertySchema(
-      id: 1,
-      name: r'carResearchExpiresAt',
-      type: IsarType.dateTime,
-    ),
-    r'carResearchInvoiceId': PropertySchema(
-      id: 2,
-      name: r'carResearchInvoiceId',
-      type: IsarType.string,
-    ),
-    r'carResearchPaymentLinks': PropertySchema(
-      id: 3,
-      name: r'carResearchPaymentLinks',
-      type: IsarType.string,
-    ),
-    r'category': PropertySchema(
-      id: 4,
-      name: r'category',
-      type: IsarType.byte,
-      enumMap: _ShopInBitTicketcategoryEnumValueMap,
-    ),
-    r'createdAt': PropertySchema(
-      id: 5,
-      name: r'createdAt',
-      type: IsarType.dateTime,
-    ),
-    r'deliveryCountry': PropertySchema(
-      id: 6,
-      name: r'deliveryCountry',
-      type: IsarType.string,
-    ),
-    r'displayName': PropertySchema(
-      id: 7,
-      name: r'displayName',
-      type: IsarType.string,
-    ),
-    r'feeTicketNumber': PropertySchema(
-      id: 8,
-      name: r'feeTicketNumber',
-      type: IsarType.string,
-    ),
-    r'isPendingPayment': PropertySchema(
-      id: 9,
-      name: r'isPendingPayment',
-      type: IsarType.bool,
-    ),
-    r'messages': PropertySchema(
-      id: 10,
-      name: r'messages',
-      type: IsarType.objectList,
-
-      target: r'ShopInBitTicketMessage',
-    ),
-    r'needsCreateRequest': PropertySchema(
-      id: 11,
-      name: r'needsCreateRequest',
-      type: IsarType.bool,
-    ),
-    r'offerPrice': PropertySchema(
-      id: 12,
-      name: r'offerPrice',
-      type: IsarType.string,
-    ),
-    r'offerProductName': PropertySchema(
-      id: 13,
-      name: r'offerProductName',
-      type: IsarType.string,
-    ),
-    r'paymentMethod': PropertySchema(
-      id: 14,
-      name: r'paymentMethod',
-      type: IsarType.string,
-    ),
-    r'requestDescription': PropertySchema(
-      id: 15,
-      name: r'requestDescription',
-      type: IsarType.string,
-    ),
-    r'shippingCity': PropertySchema(
-      id: 16,
-      name: r'shippingCity',
-      type: IsarType.string,
-    ),
-    r'shippingCountry': PropertySchema(
-      id: 17,
-      name: r'shippingCountry',
-      type: IsarType.string,
-    ),
-    r'shippingName': PropertySchema(
-      id: 18,
-      name: r'shippingName',
-      type: IsarType.string,
-    ),
-    r'shippingPostalCode': PropertySchema(
-      id: 19,
-      name: r'shippingPostalCode',
-      type: IsarType.string,
-    ),
-    r'shippingStreet': PropertySchema(
-      id: 20,
-      name: r'shippingStreet',
-      type: IsarType.string,
-    ),
-    r'status': PropertySchema(
-      id: 21,
-      name: r'status',
-      type: IsarType.byte,
-      enumMap: _ShopInBitTicketstatusEnumValueMap,
-    ),
-    r'ticketId': PropertySchema(
-      id: 22,
-      name: r'ticketId',
-      type: IsarType.string,
-    ),
-  },
-
-  estimateSize: _shopInBitTicketEstimateSize,
-  serialize: _shopInBitTicketSerialize,
-  deserialize: _shopInBitTicketDeserialize,
-  deserializeProp: _shopInBitTicketDeserializeProp,
-  idName: r'id',
-  indexes: {
-    r'ticketId': IndexSchema(
-      id: -6483959237056329942,
-      name: r'ticketId',
-      unique: true,
-      replace: true,
-      properties: [
-        IndexPropertySchema(
-          name: r'ticketId',
-          type: IndexType.hash,
-          caseSensitive: true,
-        ),
-      ],
-    ),
-  },
-  links: {},
-  embeddedSchemas: {r'ShopInBitTicketMessage': ShopInBitTicketMessageSchema},
-
-  getId: _shopInBitTicketGetId,
-  getLinks: _shopInBitTicketGetLinks,
-  attach: _shopInBitTicketAttach,
-  version: '3.3.0-dev.2',
-);
-
-int _shopInBitTicketEstimateSize(
-  ShopInBitTicket object,
-  List<int> offsets,
-  Map<Type, List<int>> allOffsets,
-) {
-  var bytesCount = offsets.last;
-  {
-    final value = object.carResearchInvoiceId;
-    if (value != null) {
-      bytesCount += 3 + value.length * 3;
-    }
-  }
-  {
-    final value = object.carResearchPaymentLinks;
-    if (value != null) {
-      bytesCount += 3 + value.length * 3;
-    }
-  }
-  bytesCount += 3 + object.deliveryCountry.length * 3;
-  bytesCount += 3 + object.displayName.length * 3;
-  {
-    final value = object.feeTicketNumber;
-    if (value != null) {
-      bytesCount += 3 + value.length * 3;
-    }
-  }
-  bytesCount += 3 + object.messages.length * 3;
-  {
-    final offsets = allOffsets[ShopInBitTicketMessage]!;
-    for (var i = 0; i < object.messages.length; i++) {
-      final value = object.messages[i];
-      bytesCount += ShopInBitTicketMessageSchema.estimateSize(
-        value,
-        offsets,
-        allOffsets,
-      );
-    }
-  }
-  {
-    final value = object.offerPrice;
-    if (value != null) {
-      bytesCount += 3 + value.length * 3;
-    }
-  }
-  {
-    final value = object.offerProductName;
-    if (value != null) {
-      bytesCount += 3 + value.length * 3;
-    }
-  }
-  {
-    final value = object.paymentMethod;
-    if (value != null) {
-      bytesCount += 3 + value.length * 3;
-    }
-  }
-  bytesCount += 3 + object.requestDescription.length * 3;
-  bytesCount += 3 + object.shippingCity.length * 3;
-  bytesCount += 3 + object.shippingCountry.length * 3;
-  bytesCount += 3 + object.shippingName.length * 3;
-  bytesCount += 3 + object.shippingPostalCode.length * 3;
-  bytesCount += 3 + object.shippingStreet.length * 3;
-  bytesCount += 3 + object.ticketId.length * 3;
-  return bytesCount;
-}
-
-void _shopInBitTicketSerialize(
-  ShopInBitTicket object,
-  IsarWriter writer,
-  List<int> offsets,
-  Map<Type, List<int>> allOffsets,
-) {
-  writer.writeLong(offsets[0], object.apiTicketId);
-  writer.writeDateTime(offsets[1], object.carResearchExpiresAt);
-  writer.writeString(offsets[2], object.carResearchInvoiceId);
-  writer.writeString(offsets[3], object.carResearchPaymentLinks);
-  writer.writeByte(offsets[4], object.category.index);
-  writer.writeDateTime(offsets[5], object.createdAt);
-  writer.writeString(offsets[6], object.deliveryCountry);
-  writer.writeString(offsets[7], object.displayName);
-  writer.writeString(offsets[8], object.feeTicketNumber);
-  writer.writeBool(offsets[9], object.isPendingPayment);
-  writer.writeObjectList<ShopInBitTicketMessage>(
-    offsets[10],
-    allOffsets,
-    ShopInBitTicketMessageSchema.serialize,
-    object.messages,
-  );
-  writer.writeBool(offsets[11], object.needsCreateRequest);
-  writer.writeString(offsets[12], object.offerPrice);
-  writer.writeString(offsets[13], object.offerProductName);
-  writer.writeString(offsets[14], object.paymentMethod);
-  writer.writeString(offsets[15], object.requestDescription);
-  writer.writeString(offsets[16], object.shippingCity);
-  writer.writeString(offsets[17], object.shippingCountry);
-  writer.writeString(offsets[18], object.shippingName);
-  writer.writeString(offsets[19], object.shippingPostalCode);
-  writer.writeString(offsets[20], object.shippingStreet);
-  writer.writeByte(offsets[21], object.status.index);
-  writer.writeString(offsets[22], object.ticketId);
-}
-
-ShopInBitTicket _shopInBitTicketDeserialize(
-  Id id,
-  IsarReader reader,
-  List<int> offsets,
-  Map<Type, List<int>> allOffsets,
-) {
-  final object = ShopInBitTicket();
-  object.apiTicketId = reader.readLong(offsets[0]);
-  object.carResearchExpiresAt = reader.readDateTimeOrNull(offsets[1]);
-  object.carResearchInvoiceId = reader.readStringOrNull(offsets[2]);
-  object.carResearchPaymentLinks = reader.readStringOrNull(offsets[3]);
-  object.category =
-      _ShopInBitTicketcategoryValueEnumMap[reader.readByteOrNull(offsets[4])] ??
-      ShopInBitCategory.concierge;
-  object.createdAt = reader.readDateTime(offsets[5]);
-  object.deliveryCountry = reader.readString(offsets[6]);
-  object.displayName = reader.readString(offsets[7]);
-  object.feeTicketNumber = reader.readStringOrNull(offsets[8]);
-  object.id = id;
-  object.isPendingPayment = reader.readBool(offsets[9]);
-  object.messages =
-      reader.readObjectList<ShopInBitTicketMessage>(
-        offsets[10],
-        ShopInBitTicketMessageSchema.deserialize,
-        allOffsets,
-        ShopInBitTicketMessage(),
-      ) ??
-      [];
-  object.needsCreateRequest = reader.readBool(offsets[11]);
-  object.offerPrice = reader.readStringOrNull(offsets[12]);
-  object.offerProductName = reader.readStringOrNull(offsets[13]);
-  object.paymentMethod = reader.readStringOrNull(offsets[14]);
-  object.requestDescription = reader.readString(offsets[15]);
-  object.shippingCity = reader.readString(offsets[16]);
-  object.shippingCountry = reader.readString(offsets[17]);
-  object.shippingName = reader.readString(offsets[18]);
-  object.shippingPostalCode = reader.readString(offsets[19]);
-  object.shippingStreet = reader.readString(offsets[20]);
-  object.status =
-      _ShopInBitTicketstatusValueEnumMap[reader.readByteOrNull(offsets[21])] ??
-      ShopInBitOrderStatus.pending;
-  object.ticketId = reader.readString(offsets[22]);
-  return object;
-}
-
-P _shopInBitTicketDeserializeProp<P>(
-  IsarReader reader,
-  int propertyId,
-  int offset,
-  Map<Type, List<int>> allOffsets,
-) {
-  switch (propertyId) {
-    case 0:
-      return (reader.readLong(offset)) as P;
-    case 1:
-      return (reader.readDateTimeOrNull(offset)) as P;
-    case 2:
-      return (reader.readStringOrNull(offset)) as P;
-    case 3:
-      return (reader.readStringOrNull(offset)) as P;
-    case 4:
-      return (_ShopInBitTicketcategoryValueEnumMap[reader.readByteOrNull(
-                offset,
-              )] ??
-              ShopInBitCategory.concierge)
-          as P;
-    case 5:
-      return (reader.readDateTime(offset)) as P;
-    case 6:
-      return (reader.readString(offset)) as P;
-    case 7:
-      return (reader.readString(offset)) as P;
-    case 8:
-      return (reader.readStringOrNull(offset)) as P;
-    case 9:
-      return (reader.readBool(offset)) as P;
-    case 10:
-      return (reader.readObjectList<ShopInBitTicketMessage>(
-                offset,
-                ShopInBitTicketMessageSchema.deserialize,
-                allOffsets,
-                ShopInBitTicketMessage(),
-              ) ??
-              [])
-          as P;
-    case 11:
-      return (reader.readBool(offset)) as P;
-    case 12:
-      return (reader.readStringOrNull(offset)) as P;
-    case 13:
-      return (reader.readStringOrNull(offset)) as P;
-    case 14:
-      return (reader.readStringOrNull(offset)) as P;
-    case 15:
-      return (reader.readString(offset)) as P;
-    case 16:
-      return (reader.readString(offset)) as P;
-    case 17:
-      return (reader.readString(offset)) as P;
-    case 18:
-      return (reader.readString(offset)) as P;
-    case 19:
-      return (reader.readString(offset)) as P;
-    case 20:
-      return (reader.readString(offset)) as P;
-    case 21:
-      return (_ShopInBitTicketstatusValueEnumMap[reader.readByteOrNull(
-                offset,
-              )] ??
-              ShopInBitOrderStatus.pending)
-          as P;
-    case 22:
-      return (reader.readString(offset)) as P;
-    default:
-      throw IsarError('Unknown property with id $propertyId');
-  }
-}
-
-const _ShopInBitTicketcategoryEnumValueMap = {
-  'concierge': 0,
-  'travel': 1,
-  'car': 2,
-};
-const _ShopInBitTicketcategoryValueEnumMap = {
-  0: ShopInBitCategory.concierge,
-  1: ShopInBitCategory.travel,
-  2: ShopInBitCategory.car,
-};
-const _ShopInBitTicketstatusEnumValueMap = {
-  'pending': 0,
-  'reviewing': 1,
-  'offerAvailable': 2,
-  'accepted': 3,
-  'paymentPending': 4,
-  'paid': 5,
-  'shipping': 6,
-  'delivered': 7,
-  'closed': 8,
-  'cancelled': 9,
-  'refunded': 10,
-};
-const _ShopInBitTicketstatusValueEnumMap = {
-  0: ShopInBitOrderStatus.pending,
-  1: ShopInBitOrderStatus.reviewing,
-  2: ShopInBitOrderStatus.offerAvailable,
-  3: ShopInBitOrderStatus.accepted,
-  4: ShopInBitOrderStatus.paymentPending,
-  5: ShopInBitOrderStatus.paid,
-  6: ShopInBitOrderStatus.shipping,
-  7: ShopInBitOrderStatus.delivered,
-  8: ShopInBitOrderStatus.closed,
-  9: ShopInBitOrderStatus.cancelled,
-  10: ShopInBitOrderStatus.refunded,
-};
-
-Id _shopInBitTicketGetId(ShopInBitTicket object) {
-  return object.id;
-}
-
-List<IsarLinkBase<dynamic>> _shopInBitTicketGetLinks(ShopInBitTicket object) {
-  return [];
-}
-
-void _shopInBitTicketAttach(
-  IsarCollection<dynamic> col,
-  Id id,
-  ShopInBitTicket object,
-) {
-  object.id = id;
-}
-
-extension ShopInBitTicketByIndex on IsarCollection<ShopInBitTicket> {
-  Future<ShopInBitTicket?> getByTicketId(String ticketId) {
-    return getByIndex(r'ticketId', [ticketId]);
-  }
-
-  ShopInBitTicket? getByTicketIdSync(String ticketId) {
-    return getByIndexSync(r'ticketId', [ticketId]);
-  }
-
-  Future<bool> deleteByTicketId(String ticketId) {
-    return deleteByIndex(r'ticketId', [ticketId]);
-  }
-
-  bool deleteByTicketIdSync(String ticketId) {
-    return deleteByIndexSync(r'ticketId', [ticketId]);
-  }
-
-  Future<List<ShopInBitTicket?>> getAllByTicketId(List<String> ticketIdValues) {
-    final values = ticketIdValues.map((e) => [e]).toList();
-    return getAllByIndex(r'ticketId', values);
-  }
-
-  List<ShopInBitTicket?> getAllByTicketIdSync(List<String> ticketIdValues) {
-    final values = ticketIdValues.map((e) => [e]).toList();
-    return getAllByIndexSync(r'ticketId', values);
-  }
-
-  Future<int> deleteAllByTicketId(List<String> ticketIdValues) {
-    final values = ticketIdValues.map((e) => [e]).toList();
-    return deleteAllByIndex(r'ticketId', values);
-  }
-
-  int deleteAllByTicketIdSync(List<String> ticketIdValues) {
-    final values = ticketIdValues.map((e) => [e]).toList();
-    return deleteAllByIndexSync(r'ticketId', values);
-  }
-
-  Future<Id> putByTicketId(ShopInBitTicket object) {
-    return putByIndex(r'ticketId', object);
-  }
-
-  Id putByTicketIdSync(ShopInBitTicket object, {bool saveLinks = true}) {
-    return putByIndexSync(r'ticketId', object, saveLinks: saveLinks);
-  }
-
-  Future<List<Id>> putAllByTicketId(List<ShopInBitTicket> objects) {
-    return putAllByIndex(r'ticketId', objects);
-  }
-
-  List<Id> putAllByTicketIdSync(
-    List<ShopInBitTicket> objects, {
-    bool saveLinks = true,
-  }) {
-    return putAllByIndexSync(r'ticketId', objects, saveLinks: saveLinks);
-  }
-}
-
-extension ShopInBitTicketQueryWhereSort
-    on QueryBuilder<ShopInBitTicket, ShopInBitTicket, QWhere> {
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterWhere> anyId() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addWhereClause(const IdWhereClause.any());
-    });
-  }
-}
-
-extension ShopInBitTicketQueryWhere
-    on QueryBuilder<ShopInBitTicket, ShopInBitTicket, QWhereClause> {
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterWhereClause> idEqualTo(
-    Id id,
-  ) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addWhereClause(IdWhereClause.between(lower: id, upper: id));
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterWhereClause>
-  idNotEqualTo(Id id) {
-    return QueryBuilder.apply(this, (query) {
-      if (query.whereSort == Sort.asc) {
-        return query
-            .addWhereClause(
-              IdWhereClause.lessThan(upper: id, includeUpper: false),
-            )
-            .addWhereClause(
-              IdWhereClause.greaterThan(lower: id, includeLower: false),
-            );
-      } else {
-        return query
-            .addWhereClause(
-              IdWhereClause.greaterThan(lower: id, includeLower: false),
-            )
-            .addWhereClause(
-              IdWhereClause.lessThan(upper: id, includeUpper: false),
-            );
-      }
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterWhereClause>
-  idGreaterThan(Id id, {bool include = false}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addWhereClause(
-        IdWhereClause.greaterThan(lower: id, includeLower: include),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterWhereClause> idLessThan(
-    Id id, {
-    bool include = false,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addWhereClause(
-        IdWhereClause.lessThan(upper: id, includeUpper: include),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterWhereClause> idBetween(
-    Id lowerId,
-    Id upperId, {
-    bool includeLower = true,
-    bool includeUpper = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addWhereClause(
-        IdWhereClause.between(
-          lower: lowerId,
-          includeLower: includeLower,
-          upper: upperId,
-          includeUpper: includeUpper,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterWhereClause>
-  ticketIdEqualTo(String ticketId) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addWhereClause(
-        IndexWhereClause.equalTo(indexName: r'ticketId', value: [ticketId]),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterWhereClause>
-  ticketIdNotEqualTo(String ticketId) {
-    return QueryBuilder.apply(this, (query) {
-      if (query.whereSort == Sort.asc) {
-        return query
-            .addWhereClause(
-              IndexWhereClause.between(
-                indexName: r'ticketId',
-                lower: [],
-                upper: [ticketId],
-                includeUpper: false,
-              ),
-            )
-            .addWhereClause(
-              IndexWhereClause.between(
-                indexName: r'ticketId',
-                lower: [ticketId],
-                includeLower: false,
-                upper: [],
-              ),
-            );
-      } else {
-        return query
-            .addWhereClause(
-              IndexWhereClause.between(
-                indexName: r'ticketId',
-                lower: [ticketId],
-                includeLower: false,
-                upper: [],
-              ),
-            )
-            .addWhereClause(
-              IndexWhereClause.between(
-                indexName: r'ticketId',
-                lower: [],
-                upper: [ticketId],
-                includeUpper: false,
-              ),
-            );
-      }
-    });
-  }
-}
-
-extension ShopInBitTicketQueryFilter
-    on QueryBuilder<ShopInBitTicket, ShopInBitTicket, QFilterCondition> {
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  apiTicketIdEqualTo(int value) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(property: r'apiTicketId', value: value),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  apiTicketIdGreaterThan(int value, {bool include = false}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(
-          include: include,
-          property: r'apiTicketId',
-          value: value,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  apiTicketIdLessThan(int value, {bool include = false}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.lessThan(
-          include: include,
-          property: r'apiTicketId',
-          value: value,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  apiTicketIdBetween(
-    int lower,
-    int upper, {
-    bool includeLower = true,
-    bool includeUpper = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.between(
-          property: r'apiTicketId',
-          lower: lower,
-          includeLower: includeLower,
-          upper: upper,
-          includeUpper: includeUpper,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  carResearchExpiresAtIsNull() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        const FilterCondition.isNull(property: r'carResearchExpiresAt'),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  carResearchExpiresAtIsNotNull() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        const FilterCondition.isNotNull(property: r'carResearchExpiresAt'),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  carResearchExpiresAtEqualTo(DateTime? value) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(
-          property: r'carResearchExpiresAt',
-          value: value,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  carResearchExpiresAtGreaterThan(DateTime? value, {bool include = false}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(
-          include: include,
-          property: r'carResearchExpiresAt',
-          value: value,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  carResearchExpiresAtLessThan(DateTime? value, {bool include = false}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.lessThan(
-          include: include,
-          property: r'carResearchExpiresAt',
-          value: value,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  carResearchExpiresAtBetween(
-    DateTime? lower,
-    DateTime? upper, {
-    bool includeLower = true,
-    bool includeUpper = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.between(
-          property: r'carResearchExpiresAt',
-          lower: lower,
-          includeLower: includeLower,
-          upper: upper,
-          includeUpper: includeUpper,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  carResearchInvoiceIdIsNull() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        const FilterCondition.isNull(property: r'carResearchInvoiceId'),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  carResearchInvoiceIdIsNotNull() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        const FilterCondition.isNotNull(property: r'carResearchInvoiceId'),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  carResearchInvoiceIdEqualTo(String? value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(
-          property: r'carResearchInvoiceId',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  carResearchInvoiceIdGreaterThan(
-    String? value, {
-    bool include = false,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(
-          include: include,
-          property: r'carResearchInvoiceId',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  carResearchInvoiceIdLessThan(
-    String? value, {
-    bool include = false,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.lessThan(
-          include: include,
-          property: r'carResearchInvoiceId',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  carResearchInvoiceIdBetween(
-    String? lower,
-    String? upper, {
-    bool includeLower = true,
-    bool includeUpper = true,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.between(
-          property: r'carResearchInvoiceId',
-          lower: lower,
-          includeLower: includeLower,
-          upper: upper,
-          includeUpper: includeUpper,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  carResearchInvoiceIdStartsWith(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.startsWith(
-          property: r'carResearchInvoiceId',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  carResearchInvoiceIdEndsWith(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.endsWith(
-          property: r'carResearchInvoiceId',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  carResearchInvoiceIdContains(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.contains(
-          property: r'carResearchInvoiceId',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  carResearchInvoiceIdMatches(String pattern, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.matches(
-          property: r'carResearchInvoiceId',
-          wildcard: pattern,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  carResearchInvoiceIdIsEmpty() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(property: r'carResearchInvoiceId', value: ''),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  carResearchInvoiceIdIsNotEmpty() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(
-          property: r'carResearchInvoiceId',
-          value: '',
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  carResearchPaymentLinksIsNull() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        const FilterCondition.isNull(property: r'carResearchPaymentLinks'),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  carResearchPaymentLinksIsNotNull() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        const FilterCondition.isNotNull(property: r'carResearchPaymentLinks'),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  carResearchPaymentLinksEqualTo(String? value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(
-          property: r'carResearchPaymentLinks',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  carResearchPaymentLinksGreaterThan(
-    String? value, {
-    bool include = false,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(
-          include: include,
-          property: r'carResearchPaymentLinks',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  carResearchPaymentLinksLessThan(
-    String? value, {
-    bool include = false,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.lessThan(
-          include: include,
-          property: r'carResearchPaymentLinks',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  carResearchPaymentLinksBetween(
-    String? lower,
-    String? upper, {
-    bool includeLower = true,
-    bool includeUpper = true,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.between(
-          property: r'carResearchPaymentLinks',
-          lower: lower,
-          includeLower: includeLower,
-          upper: upper,
-          includeUpper: includeUpper,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  carResearchPaymentLinksStartsWith(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.startsWith(
-          property: r'carResearchPaymentLinks',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  carResearchPaymentLinksEndsWith(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.endsWith(
-          property: r'carResearchPaymentLinks',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  carResearchPaymentLinksContains(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.contains(
-          property: r'carResearchPaymentLinks',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  carResearchPaymentLinksMatches(String pattern, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.matches(
-          property: r'carResearchPaymentLinks',
-          wildcard: pattern,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  carResearchPaymentLinksIsEmpty() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(
-          property: r'carResearchPaymentLinks',
-          value: '',
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  carResearchPaymentLinksIsNotEmpty() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(
-          property: r'carResearchPaymentLinks',
-          value: '',
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  categoryEqualTo(ShopInBitCategory value) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(property: r'category', value: value),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  categoryGreaterThan(ShopInBitCategory value, {bool include = false}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(
-          include: include,
-          property: r'category',
-          value: value,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  categoryLessThan(ShopInBitCategory value, {bool include = false}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.lessThan(
-          include: include,
-          property: r'category',
-          value: value,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  categoryBetween(
-    ShopInBitCategory lower,
-    ShopInBitCategory upper, {
-    bool includeLower = true,
-    bool includeUpper = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.between(
-          property: r'category',
-          lower: lower,
-          includeLower: includeLower,
-          upper: upper,
-          includeUpper: includeUpper,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  createdAtEqualTo(DateTime value) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(property: r'createdAt', value: value),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  createdAtGreaterThan(DateTime value, {bool include = false}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(
-          include: include,
-          property: r'createdAt',
-          value: value,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  createdAtLessThan(DateTime value, {bool include = false}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.lessThan(
-          include: include,
-          property: r'createdAt',
-          value: value,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  createdAtBetween(
-    DateTime lower,
-    DateTime upper, {
-    bool includeLower = true,
-    bool includeUpper = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.between(
-          property: r'createdAt',
-          lower: lower,
-          includeLower: includeLower,
-          upper: upper,
-          includeUpper: includeUpper,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  deliveryCountryEqualTo(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(
-          property: r'deliveryCountry',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  deliveryCountryGreaterThan(
-    String value, {
-    bool include = false,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(
-          include: include,
-          property: r'deliveryCountry',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  deliveryCountryLessThan(
-    String value, {
-    bool include = false,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.lessThan(
-          include: include,
-          property: r'deliveryCountry',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  deliveryCountryBetween(
-    String lower,
-    String upper, {
-    bool includeLower = true,
-    bool includeUpper = true,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.between(
-          property: r'deliveryCountry',
-          lower: lower,
-          includeLower: includeLower,
-          upper: upper,
-          includeUpper: includeUpper,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  deliveryCountryStartsWith(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.startsWith(
-          property: r'deliveryCountry',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  deliveryCountryEndsWith(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.endsWith(
-          property: r'deliveryCountry',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  deliveryCountryContains(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.contains(
-          property: r'deliveryCountry',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  deliveryCountryMatches(String pattern, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.matches(
-          property: r'deliveryCountry',
-          wildcard: pattern,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  deliveryCountryIsEmpty() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(property: r'deliveryCountry', value: ''),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  deliveryCountryIsNotEmpty() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(property: r'deliveryCountry', value: ''),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  displayNameEqualTo(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(
-          property: r'displayName',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  displayNameGreaterThan(
-    String value, {
-    bool include = false,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(
-          include: include,
-          property: r'displayName',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  displayNameLessThan(
-    String value, {
-    bool include = false,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.lessThan(
-          include: include,
-          property: r'displayName',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  displayNameBetween(
-    String lower,
-    String upper, {
-    bool includeLower = true,
-    bool includeUpper = true,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.between(
-          property: r'displayName',
-          lower: lower,
-          includeLower: includeLower,
-          upper: upper,
-          includeUpper: includeUpper,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  displayNameStartsWith(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.startsWith(
-          property: r'displayName',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  displayNameEndsWith(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.endsWith(
-          property: r'displayName',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  displayNameContains(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.contains(
-          property: r'displayName',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  displayNameMatches(String pattern, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.matches(
-          property: r'displayName',
-          wildcard: pattern,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  displayNameIsEmpty() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(property: r'displayName', value: ''),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  displayNameIsNotEmpty() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(property: r'displayName', value: ''),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  feeTicketNumberIsNull() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        const FilterCondition.isNull(property: r'feeTicketNumber'),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  feeTicketNumberIsNotNull() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        const FilterCondition.isNotNull(property: r'feeTicketNumber'),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  feeTicketNumberEqualTo(String? value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(
-          property: r'feeTicketNumber',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  feeTicketNumberGreaterThan(
-    String? value, {
-    bool include = false,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(
-          include: include,
-          property: r'feeTicketNumber',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  feeTicketNumberLessThan(
-    String? value, {
-    bool include = false,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.lessThan(
-          include: include,
-          property: r'feeTicketNumber',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  feeTicketNumberBetween(
-    String? lower,
-    String? upper, {
-    bool includeLower = true,
-    bool includeUpper = true,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.between(
-          property: r'feeTicketNumber',
-          lower: lower,
-          includeLower: includeLower,
-          upper: upper,
-          includeUpper: includeUpper,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  feeTicketNumberStartsWith(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.startsWith(
-          property: r'feeTicketNumber',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  feeTicketNumberEndsWith(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.endsWith(
-          property: r'feeTicketNumber',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  feeTicketNumberContains(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.contains(
-          property: r'feeTicketNumber',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  feeTicketNumberMatches(String pattern, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.matches(
-          property: r'feeTicketNumber',
-          wildcard: pattern,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  feeTicketNumberIsEmpty() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(property: r'feeTicketNumber', value: ''),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  feeTicketNumberIsNotEmpty() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(property: r'feeTicketNumber', value: ''),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  idEqualTo(Id value) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(property: r'id', value: value),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  idGreaterThan(Id value, {bool include = false}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(
-          include: include,
-          property: r'id',
-          value: value,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  idLessThan(Id value, {bool include = false}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.lessThan(
-          include: include,
-          property: r'id',
-          value: value,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  idBetween(
-    Id lower,
-    Id upper, {
-    bool includeLower = true,
-    bool includeUpper = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.between(
-          property: r'id',
-          lower: lower,
-          includeLower: includeLower,
-          upper: upper,
-          includeUpper: includeUpper,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  isPendingPaymentEqualTo(bool value) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(property: r'isPendingPayment', value: value),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  messagesLengthEqualTo(int length) {
-    return QueryBuilder.apply(this, (query) {
-      return query.listLength(r'messages', length, true, length, true);
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  messagesIsEmpty() {
-    return QueryBuilder.apply(this, (query) {
-      return query.listLength(r'messages', 0, true, 0, true);
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  messagesIsNotEmpty() {
-    return QueryBuilder.apply(this, (query) {
-      return query.listLength(r'messages', 0, false, 999999, true);
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  messagesLengthLessThan(int length, {bool include = false}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.listLength(r'messages', 0, true, length, include);
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  messagesLengthGreaterThan(int length, {bool include = false}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.listLength(r'messages', length, include, 999999, true);
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  messagesLengthBetween(
-    int lower,
-    int upper, {
-    bool includeLower = true,
-    bool includeUpper = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.listLength(
-        r'messages',
-        lower,
-        includeLower,
-        upper,
-        includeUpper,
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  needsCreateRequestEqualTo(bool value) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(property: r'needsCreateRequest', value: value),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  offerPriceIsNull() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        const FilterCondition.isNull(property: r'offerPrice'),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  offerPriceIsNotNull() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        const FilterCondition.isNotNull(property: r'offerPrice'),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  offerPriceEqualTo(String? value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(
-          property: r'offerPrice',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  offerPriceGreaterThan(
-    String? value, {
-    bool include = false,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(
-          include: include,
-          property: r'offerPrice',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  offerPriceLessThan(
-    String? value, {
-    bool include = false,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.lessThan(
-          include: include,
-          property: r'offerPrice',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  offerPriceBetween(
-    String? lower,
-    String? upper, {
-    bool includeLower = true,
-    bool includeUpper = true,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.between(
-          property: r'offerPrice',
-          lower: lower,
-          includeLower: includeLower,
-          upper: upper,
-          includeUpper: includeUpper,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  offerPriceStartsWith(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.startsWith(
-          property: r'offerPrice',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  offerPriceEndsWith(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.endsWith(
-          property: r'offerPrice',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  offerPriceContains(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.contains(
-          property: r'offerPrice',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  offerPriceMatches(String pattern, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.matches(
-          property: r'offerPrice',
-          wildcard: pattern,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  offerPriceIsEmpty() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(property: r'offerPrice', value: ''),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  offerPriceIsNotEmpty() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(property: r'offerPrice', value: ''),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  offerProductNameIsNull() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        const FilterCondition.isNull(property: r'offerProductName'),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  offerProductNameIsNotNull() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        const FilterCondition.isNotNull(property: r'offerProductName'),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  offerProductNameEqualTo(String? value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(
-          property: r'offerProductName',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  offerProductNameGreaterThan(
-    String? value, {
-    bool include = false,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(
-          include: include,
-          property: r'offerProductName',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  offerProductNameLessThan(
-    String? value, {
-    bool include = false,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.lessThan(
-          include: include,
-          property: r'offerProductName',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  offerProductNameBetween(
-    String? lower,
-    String? upper, {
-    bool includeLower = true,
-    bool includeUpper = true,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.between(
-          property: r'offerProductName',
-          lower: lower,
-          includeLower: includeLower,
-          upper: upper,
-          includeUpper: includeUpper,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  offerProductNameStartsWith(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.startsWith(
-          property: r'offerProductName',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  offerProductNameEndsWith(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.endsWith(
-          property: r'offerProductName',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  offerProductNameContains(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.contains(
-          property: r'offerProductName',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  offerProductNameMatches(String pattern, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.matches(
-          property: r'offerProductName',
-          wildcard: pattern,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  offerProductNameIsEmpty() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(property: r'offerProductName', value: ''),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  offerProductNameIsNotEmpty() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(property: r'offerProductName', value: ''),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  paymentMethodIsNull() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        const FilterCondition.isNull(property: r'paymentMethod'),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  paymentMethodIsNotNull() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        const FilterCondition.isNotNull(property: r'paymentMethod'),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  paymentMethodEqualTo(String? value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(
-          property: r'paymentMethod',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  paymentMethodGreaterThan(
-    String? value, {
-    bool include = false,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(
-          include: include,
-          property: r'paymentMethod',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  paymentMethodLessThan(
-    String? value, {
-    bool include = false,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.lessThan(
-          include: include,
-          property: r'paymentMethod',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  paymentMethodBetween(
-    String? lower,
-    String? upper, {
-    bool includeLower = true,
-    bool includeUpper = true,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.between(
-          property: r'paymentMethod',
-          lower: lower,
-          includeLower: includeLower,
-          upper: upper,
-          includeUpper: includeUpper,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  paymentMethodStartsWith(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.startsWith(
-          property: r'paymentMethod',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  paymentMethodEndsWith(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.endsWith(
-          property: r'paymentMethod',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  paymentMethodContains(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.contains(
-          property: r'paymentMethod',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  paymentMethodMatches(String pattern, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.matches(
-          property: r'paymentMethod',
-          wildcard: pattern,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  paymentMethodIsEmpty() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(property: r'paymentMethod', value: ''),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  paymentMethodIsNotEmpty() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(property: r'paymentMethod', value: ''),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  requestDescriptionEqualTo(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(
-          property: r'requestDescription',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  requestDescriptionGreaterThan(
-    String value, {
-    bool include = false,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(
-          include: include,
-          property: r'requestDescription',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  requestDescriptionLessThan(
-    String value, {
-    bool include = false,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.lessThan(
-          include: include,
-          property: r'requestDescription',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  requestDescriptionBetween(
-    String lower,
-    String upper, {
-    bool includeLower = true,
-    bool includeUpper = true,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.between(
-          property: r'requestDescription',
-          lower: lower,
-          includeLower: includeLower,
-          upper: upper,
-          includeUpper: includeUpper,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  requestDescriptionStartsWith(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.startsWith(
-          property: r'requestDescription',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  requestDescriptionEndsWith(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.endsWith(
-          property: r'requestDescription',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  requestDescriptionContains(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.contains(
-          property: r'requestDescription',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  requestDescriptionMatches(String pattern, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.matches(
-          property: r'requestDescription',
-          wildcard: pattern,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  requestDescriptionIsEmpty() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(property: r'requestDescription', value: ''),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  requestDescriptionIsNotEmpty() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(property: r'requestDescription', value: ''),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingCityEqualTo(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(
-          property: r'shippingCity',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingCityGreaterThan(
-    String value, {
-    bool include = false,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(
-          include: include,
-          property: r'shippingCity',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingCityLessThan(
-    String value, {
-    bool include = false,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.lessThan(
-          include: include,
-          property: r'shippingCity',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingCityBetween(
-    String lower,
-    String upper, {
-    bool includeLower = true,
-    bool includeUpper = true,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.between(
-          property: r'shippingCity',
-          lower: lower,
-          includeLower: includeLower,
-          upper: upper,
-          includeUpper: includeUpper,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingCityStartsWith(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.startsWith(
-          property: r'shippingCity',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingCityEndsWith(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.endsWith(
-          property: r'shippingCity',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingCityContains(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.contains(
-          property: r'shippingCity',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingCityMatches(String pattern, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.matches(
-          property: r'shippingCity',
-          wildcard: pattern,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingCityIsEmpty() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(property: r'shippingCity', value: ''),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingCityIsNotEmpty() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(property: r'shippingCity', value: ''),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingCountryEqualTo(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(
-          property: r'shippingCountry',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingCountryGreaterThan(
-    String value, {
-    bool include = false,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(
-          include: include,
-          property: r'shippingCountry',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingCountryLessThan(
-    String value, {
-    bool include = false,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.lessThan(
-          include: include,
-          property: r'shippingCountry',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingCountryBetween(
-    String lower,
-    String upper, {
-    bool includeLower = true,
-    bool includeUpper = true,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.between(
-          property: r'shippingCountry',
-          lower: lower,
-          includeLower: includeLower,
-          upper: upper,
-          includeUpper: includeUpper,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingCountryStartsWith(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.startsWith(
-          property: r'shippingCountry',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingCountryEndsWith(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.endsWith(
-          property: r'shippingCountry',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingCountryContains(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.contains(
-          property: r'shippingCountry',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingCountryMatches(String pattern, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.matches(
-          property: r'shippingCountry',
-          wildcard: pattern,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingCountryIsEmpty() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(property: r'shippingCountry', value: ''),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingCountryIsNotEmpty() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(property: r'shippingCountry', value: ''),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingNameEqualTo(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(
-          property: r'shippingName',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingNameGreaterThan(
-    String value, {
-    bool include = false,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(
-          include: include,
-          property: r'shippingName',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingNameLessThan(
-    String value, {
-    bool include = false,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.lessThan(
-          include: include,
-          property: r'shippingName',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingNameBetween(
-    String lower,
-    String upper, {
-    bool includeLower = true,
-    bool includeUpper = true,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.between(
-          property: r'shippingName',
-          lower: lower,
-          includeLower: includeLower,
-          upper: upper,
-          includeUpper: includeUpper,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingNameStartsWith(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.startsWith(
-          property: r'shippingName',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingNameEndsWith(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.endsWith(
-          property: r'shippingName',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingNameContains(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.contains(
-          property: r'shippingName',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingNameMatches(String pattern, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.matches(
-          property: r'shippingName',
-          wildcard: pattern,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingNameIsEmpty() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(property: r'shippingName', value: ''),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingNameIsNotEmpty() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(property: r'shippingName', value: ''),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingPostalCodeEqualTo(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(
-          property: r'shippingPostalCode',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingPostalCodeGreaterThan(
-    String value, {
-    bool include = false,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(
-          include: include,
-          property: r'shippingPostalCode',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingPostalCodeLessThan(
-    String value, {
-    bool include = false,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.lessThan(
-          include: include,
-          property: r'shippingPostalCode',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingPostalCodeBetween(
-    String lower,
-    String upper, {
-    bool includeLower = true,
-    bool includeUpper = true,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.between(
-          property: r'shippingPostalCode',
-          lower: lower,
-          includeLower: includeLower,
-          upper: upper,
-          includeUpper: includeUpper,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingPostalCodeStartsWith(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.startsWith(
-          property: r'shippingPostalCode',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingPostalCodeEndsWith(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.endsWith(
-          property: r'shippingPostalCode',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingPostalCodeContains(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.contains(
-          property: r'shippingPostalCode',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingPostalCodeMatches(String pattern, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.matches(
-          property: r'shippingPostalCode',
-          wildcard: pattern,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingPostalCodeIsEmpty() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(property: r'shippingPostalCode', value: ''),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingPostalCodeIsNotEmpty() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(property: r'shippingPostalCode', value: ''),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingStreetEqualTo(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(
-          property: r'shippingStreet',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingStreetGreaterThan(
-    String value, {
-    bool include = false,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(
-          include: include,
-          property: r'shippingStreet',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingStreetLessThan(
-    String value, {
-    bool include = false,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.lessThan(
-          include: include,
-          property: r'shippingStreet',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingStreetBetween(
-    String lower,
-    String upper, {
-    bool includeLower = true,
-    bool includeUpper = true,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.between(
-          property: r'shippingStreet',
-          lower: lower,
-          includeLower: includeLower,
-          upper: upper,
-          includeUpper: includeUpper,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingStreetStartsWith(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.startsWith(
-          property: r'shippingStreet',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingStreetEndsWith(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.endsWith(
-          property: r'shippingStreet',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingStreetContains(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.contains(
-          property: r'shippingStreet',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingStreetMatches(String pattern, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.matches(
-          property: r'shippingStreet',
-          wildcard: pattern,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingStreetIsEmpty() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(property: r'shippingStreet', value: ''),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  shippingStreetIsNotEmpty() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(property: r'shippingStreet', value: ''),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  statusEqualTo(ShopInBitOrderStatus value) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(property: r'status', value: value),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  statusGreaterThan(ShopInBitOrderStatus value, {bool include = false}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(
-          include: include,
-          property: r'status',
-          value: value,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  statusLessThan(ShopInBitOrderStatus value, {bool include = false}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.lessThan(
-          include: include,
-          property: r'status',
-          value: value,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  statusBetween(
-    ShopInBitOrderStatus lower,
-    ShopInBitOrderStatus upper, {
-    bool includeLower = true,
-    bool includeUpper = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.between(
-          property: r'status',
-          lower: lower,
-          includeLower: includeLower,
-          upper: upper,
-          includeUpper: includeUpper,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  ticketIdEqualTo(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(
-          property: r'ticketId',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  ticketIdGreaterThan(
-    String value, {
-    bool include = false,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(
-          include: include,
-          property: r'ticketId',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  ticketIdLessThan(
-    String value, {
-    bool include = false,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.lessThan(
-          include: include,
-          property: r'ticketId',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  ticketIdBetween(
-    String lower,
-    String upper, {
-    bool includeLower = true,
-    bool includeUpper = true,
-    bool caseSensitive = true,
-  }) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.between(
-          property: r'ticketId',
-          lower: lower,
-          includeLower: includeLower,
-          upper: upper,
-          includeUpper: includeUpper,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  ticketIdStartsWith(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.startsWith(
-          property: r'ticketId',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  ticketIdEndsWith(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.endsWith(
-          property: r'ticketId',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  ticketIdContains(String value, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.contains(
-          property: r'ticketId',
-          value: value,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  ticketIdMatches(String pattern, {bool caseSensitive = true}) {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.matches(
-          property: r'ticketId',
-          wildcard: pattern,
-          caseSensitive: caseSensitive,
-        ),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  ticketIdIsEmpty() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.equalTo(property: r'ticketId', value: ''),
-      );
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  ticketIdIsNotEmpty() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addFilterCondition(
-        FilterCondition.greaterThan(property: r'ticketId', value: ''),
-      );
-    });
-  }
-}
-
-extension ShopInBitTicketQueryObject
-    on QueryBuilder<ShopInBitTicket, ShopInBitTicket, QFilterCondition> {
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterFilterCondition>
-  messagesElement(FilterQuery<ShopInBitTicketMessage> q) {
-    return QueryBuilder.apply(this, (query) {
-      return query.object(q, r'messages');
-    });
-  }
-}
-
-extension ShopInBitTicketQueryLinks
-    on QueryBuilder<ShopInBitTicket, ShopInBitTicket, QFilterCondition> {}
-
-extension ShopInBitTicketQuerySortBy
-    on QueryBuilder<ShopInBitTicket, ShopInBitTicket, QSortBy> {
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterSortBy>
-  sortByApiTicketId() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addSortBy(r'apiTicketId', Sort.asc);
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterSortBy>
-  sortByApiTicketIdDesc() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addSortBy(r'apiTicketId', Sort.desc);
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterSortBy>
-  sortByCarResearchExpiresAt() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addSortBy(r'carResearchExpiresAt', Sort.asc);
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterSortBy>
-  sortByCarResearchExpiresAtDesc() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addSortBy(r'carResearchExpiresAt', Sort.desc);
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterSortBy>
-  sortByCarResearchInvoiceId() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addSortBy(r'carResearchInvoiceId', Sort.asc);
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterSortBy>
-  sortByCarResearchInvoiceIdDesc() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addSortBy(r'carResearchInvoiceId', Sort.desc);
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterSortBy>
-  sortByCarResearchPaymentLinks() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addSortBy(r'carResearchPaymentLinks', Sort.asc);
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterSortBy>
-  sortByCarResearchPaymentLinksDesc() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addSortBy(r'carResearchPaymentLinks', Sort.desc);
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterSortBy>
-  sortByCategory() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addSortBy(r'category', Sort.asc);
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterSortBy>
-  sortByCategoryDesc() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addSortBy(r'category', Sort.desc);
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterSortBy>
-  sortByCreatedAt() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addSortBy(r'createdAt', Sort.asc);
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterSortBy>
-  sortByCreatedAtDesc() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addSortBy(r'createdAt', Sort.desc);
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterSortBy>
-  sortByDeliveryCountry() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addSortBy(r'deliveryCountry', Sort.asc);
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterSortBy>
-  sortByDeliveryCountryDesc() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addSortBy(r'deliveryCountry', Sort.desc);
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterSortBy>
-  sortByDisplayName() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addSortBy(r'displayName', Sort.asc);
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterSortBy>
-  sortByDisplayNameDesc() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addSortBy(r'displayName', Sort.desc);
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterSortBy>
-  sortByFeeTicketNumber() {
-    return QueryBuilder.apply(this, (query) {
-      return query.addSortBy(r'feeTicketNumber', Sort.asc);
-    });
-  }
-
-  QueryBuilder<ShopInBitTicket, ShopInBitTicket, QAfterSortBy>
-  sortByFeeTicketNumberDesc() {
-    return Qu