Creating of a Table

CreatingTable.kt

val queryForDatabase = """
            CREATE TABLE IF NOT EXISTS UpdatedTableProduct (idProduct TEXT PRIMARY KEY NOT NULL, name TEXT, nameClean TEXT, 
            description TEXT, discount INT, skuId TEXT, hasAddedToCart INT, opened INT, notified INT"""
database.execSQL(queryForDatabase)

val queryCopyDataBase = """
        INSERT OR REPLACE INTO UpdatedTableProduct (idProduct, name, nameClean, description, discount, 
        skuId, hasAddedToCart, opened, notified) 
        SELECT idProduct, name, nameClean, description, discount, 
        skuId, hasAddedToCart, opened, notified FROM Product"""

database.execSQL(queryCopyDataBase)
database.execSQL("DROP TABLE Product")
database.execSQL("ALTER TABLE UpdatedTableProduct RENAME TO Product")