https://ci.appveyor.com/project/BuchananGroup/hometesterclubdb/builds/35231189

I was expecting to have those scripts run to manipulate some date before or after the deployment but that didn't seem to work.
Do I need to specify anything else in the yaml file? I've attahed that yaml file and also the reference to the post ande pre deploy scripts.

PRE DEPLOYMENT script
IF (EXISTS (SELECT *
                 FROM INFORMATION_SCHEMA.TABLES
                 WHERE TABLE_SCHEMA = 'dbo'
                 AND TABLE_NAME = 'users'))
BEGIN
    --Do Stuff
    print('has users')
END
ELSE
    print('has NO users')

POST DEPLOYMENT SCRIPT
Select * from Users;