initSyncTables method

Future<void> initSyncTables({
  1. required String dbName,
})

Create the sync tables

Implementation

Future<void> initSyncTables({required String dbName}) async {
  final sql = """
            CREATE TABLE IF NOT EXISTS sync_data (id integer PRIMARY KEY AUTOINCREMENT NOT NULL,   tablename varchar(255) NOT NULL,  rowguid varchar(36) NOT NULL,  operation char(1) NOT NULL,  clientdate timestamp(128) NOT NULL);
            CREATE TABLE IF NOT EXISTS sync_details (clientid varchar(36) PRIMARY KEY NOT NULL, name varchar(255), useremail varchar(255) NOT NULL, userpassword varchar(255) NOT NULL, lastsync timestamp(128), accesstoken varchar(36), refreshtoken varchar(36), accesstokenexpiration timestamp(128));
            CREATE TABLE IF NOT EXISTS sync_encryption (secretkey String PRIMARY KEY NOT NULL);
        """;
  await execute(sql, dbName: dbName);
}