Avoid modifying tables with a trigger

0

I have a database where I am adding cards ... it would be something like this

tarjetas
identificador
fecha_expedicion
fecha_vencimiento
estado
saldo_actual

where state is Boolean that accepts 0s and 1s ... that is to say 0 inactive and 1 active, the point is that I do not know how to make a trigger that denies me the power to add balance to a card while it is inactive.

As a final note to add the card I decided to leave it inactive first, then activate it, so that nobody can use it while it is inactive ...

    
asked by Victor Gimenez 03.08.2017 в 14:36
source

0 answers