initializeDatabase static method

Implementation

static Future<void> initializeDatabase() async {
  _database = await openDatabase(
    join(
      await getDatabasesPath(),
      'my_database.db',
    ),
    onCreate: (db, version) async {
      await db.execute(
        "CREATE TABLE $userTableName(slno INTEGER PRIMARY KEY CHECK (slno = 1), uid TEXT, ext_id TEXT, name TEXT, email TEXT, phone TEXT, props TEXT)",
      );
      await db.execute(
        "CREATE TABLE $campaignTableName(campaignId TEXT PRIMARY KEY, details TEXT)",
      );
    },
    version: 1,
  );
  NLogger.d("dbInitialise");
}