CREATE TRIGGER IF NOT EXISTS bank_accounts_rib_24_insert
BEFORE INSERT ON bank_accounts
WHEN NEW.rib IS NULL OR length(NEW.rib) <> 24 OR NEW.rib GLOB '*[^0-9]*'
BEGIN
  SELECT RAISE(ABORT, 'Le RIB doit contenir exactement 24 chiffres');
END;
--> statement-breakpoint
CREATE TRIGGER IF NOT EXISTS bank_accounts_rib_24_update
BEFORE UPDATE OF rib ON bank_accounts
WHEN NEW.rib IS NULL OR length(NEW.rib) <> 24 OR NEW.rib GLOB '*[^0-9]*'
BEGIN
  SELECT RAISE(ABORT, 'Le RIB doit contenir exactement 24 chiffres');
END;
--> statement-breakpoint
CREATE TRIGGER IF NOT EXISTS supplier_bank_accounts_rib_24_insert
BEFORE INSERT ON supplier_bank_accounts
WHEN length(NEW.rib) <> 24 OR NEW.rib GLOB '*[^0-9]*'
BEGIN
  SELECT RAISE(ABORT, 'Le RIB doit contenir exactement 24 chiffres');
END;
--> statement-breakpoint
CREATE TRIGGER IF NOT EXISTS supplier_bank_accounts_rib_24_update
BEFORE UPDATE OF rib ON supplier_bank_accounts
WHEN length(NEW.rib) <> 24 OR NEW.rib GLOB '*[^0-9]*'
BEGIN
  SELECT RAISE(ABORT, 'Le RIB doit contenir exactement 24 chiffres');
END;