create or replace trigger mvnforumWatch_trig_autoinc
before insert on mvnforumWatch
for each row
begin
if (:new.WatchID is null) then
select mvnforumWatch_seq.nextval into :new.WatchID from dual;
end if;
end;
create sequence MVNFORUMWATCH_SEQ
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1