CREATE SEQUENCE s_urlwildcard;
-- should be ezurlwildcard_id_tr
CREATE OR REPLACE TRIGGER ezurlwildcard_tr
BEFORE INSERT ON ezurlwildcard FOR EACH ROW WHEN (new.id IS NULL)
BEGIN
  SELECT s_urlwildcard.nextval INTO :new.id FROM dual;
END;

-- bad sequence name, trigger name and bad table!
CREATE SEQUENCE s_ezcobj_state;
CREATE OR REPLACE TRIGGER ezcobj_state_tr
BEFORE INSERT ON ezurlwildcard FOR EACH ROW WHEN (new.id IS NULL)
BEGIN
  SELECT s_ezcobj_state.nextval INTO :new.id FROM dual;
END;
/

-- bad sequence name and trigger name
CREATE SEQUENCE s_ezcobj_state_group;
CREATE OR REPLACE TRIGGER ezcobj_state_group_tr
BEFORE INSERT ON ezcobj_state_group FOR EACH ROW WHEN (new.id IS NULL)
BEGIN
  SELECT s_ezcobj_state_group.nextval INTO :new.id FROM dual;
END;
/

-- bad sequence name and trigger name
CREATE SEQUENCE s_ezurlalias_ml_incr;
CREATE OR REPLACE TRIGGER ezurlalias_ml_incr_tr
BEFORE INSERT ON ezurlalias_ml_incr FOR EACH ROW WHEN (new.id IS NULL)
BEGIN
  SELECT s_ezurlalias_ml_incr.nextval INTO :new.id FROM dual;
END;
/