japp_flutter/lib/data/local/database_helper.dart

import 'package:sqflite/sqflite.dart';
import 'package:path/path.dart';

class DatabaseHelper {
  static const _databaseName = 'jay_world_app.db';
  static const _databaseVersion = 1;

  static const chllangetTable = 'challenges';
  static const columnId = 'id';
  static const columnTitle = 'title';
  // 其他字段...

  static Database? _database;

  Future<Database> get database async {
    if (_database != null) return _database!;
    _database = await _initDatabase();
    return _database!;
  }

  Future<Database> _initDatabase() async {
    final path = join(await getDatabasesPath(), _databaseName);
    return await openDatabase(
      path,
      version: _databaseVersion,
      onCreate: _onCreate,
    );
  }

  Future<void> _onCreate(Database db, int version) async {
    await db.execute('''
      CREATE TABLE $chllangetTable (
        $columnId INTEGER PRIMARY KEY AUTOINCREMENT,
        $columnTitle TEXT NOT NULL,
        description TEXT NOT NULL,
        startDate INTEGER NOT NULL,
        endDate INTEGER NOT NULL,
        participants INTEGER DEFAULT 0,
        completed INTEGER DEFAULT 0,
        difficulty TEXT NOT NULL
      );
    ''');
  }
}