ticket_return_tigger.sql

来自「该票务系统包括的功能有网上订票、历史订阅纪录查询、近期上映影片推荐和查询和统计报」· SQL 代码 · 共 9 行

create or replace trigger ticket_return_tigger before delete on bookRecord
referencing old as old
for each row
begin
	update ticket
	set sold = '0'
	where ticket_id = :old.ticket_id and sold='1';
end;