Requêtes SQL Azure Studio

Migration V2->V3 (Lien vers la procédure) :

use master;
alter database quickeat set SINGLE_USER WITH ROLLBACK IMMEDIATE;
drop DATABASE quickeat;

Effacer la table contenant les Menus/Familles/Produits, etc... envoyés à la borne :

delete from Cart
delete from ProductCategory
delete from Category
delete from CustomValue
delete from CustomProduct
delete from Custom
delete from LinkedProduct
delete from MenuProduct
delete from Menu 
delete from ProductAllergen
delete from ReplacementProduct
delete from SuggestionProduct
delete from Product

Effacer complétement la BDD quickeat :

drop database quickeat

ATTENTION ! Cette requête effacera également le code de la licence. Pensez à le récupérer avant (le code de la licence se situe dans C:\ProgramData\openspot\borne\config.ini -> [hubos] -> terminal).