CKaZ3tNu

1val queryForDatabase = """
2            CREATE TABLE IF NOT EXISTS UpdatedTableProduct (idProduct TEXT PRIMARY KEY NOT NULL, name TEXT, nameClean TEXT, 
3            description TEXT, discount INT, skuId TEXT, hasAddedToCart INT, opened INT, notified INT"""
4database.execSQL(queryForDatabase)
5
6val queryCopyDataBase = """
7        INSERT OR REPLACE INTO UpdatedTableProduct (idProduct, name, nameClean, description, discount, 
8        skuId, hasAddedToCart, opened, notified) 
9        SELECT idProduct, name, nameClean, description, discount, 
10        skuId, hasAddedToCart, opened, notified FROM Product"""
11
12database.execSQL(queryCopyDataBase)
13database.execSQL("DROP TABLE Product")
14database.execSQL("ALTER TABLE UpdatedTableProduct RENAME TO Product")