All pastes #937520 Raw Edit

c

public sql v1 · immutable
·published 2008-03-11 01:03 UTC
rendered paste body
DELIMITER //DROP TRIGGER IF EXISTS tg_tournaments_teams_st;CREATE TRIGGER tg_tournaments_teams_st BEFORE INSERT ON tournaments_teamsFOR EACH ROW BEGIN  INSERT INTO tournaments_teams_st VALUES(null,NEW.tournament_id,NEW.team_id,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,now(),now());END//DELIMITER ;