脚本:
CREATE OR REPLACE TRIGGER tri_news_eidit_confirm
AFTER UPDATE ON news_edit
for each row
BEGIN
/*如果审核权值=审核级数,新闻信息从新闻编辑移交给新闻表*/
if :new.ne_newsconfirmlever>0 and :new.ne_newslevernumber>=:new.ne_newsconfirmlever
and :new.ne_newsispublished=1 then
insert into news(n_newseditid,n_newsfloderid,n_newstitle
,n_newscontent,n_newsfrom,n_newshaspicture,
n_newshasmedia,n_newsfilename,n_newsfilepath
,n_newshasfile,n_newsgood,n_newsispublished)
select ne_id,ne_newsfloderid,ne_newstitle
,ne_newscontent,ne_newsfrom,ne_newshaspicture,ne_newshasmedia
,ne_newsfilename,ne_newsfilepath,ne_newshasfile
,ne_newsgood,ne_newsispublished
from news_edit where ne_id=:new.ne_id;
end if;end;
CREATE OR REPLACE TRIGGER tri_news_eidit_confirm
AFTER UPDATE ON news_edit
for each row
BEGIN
/*如果审核权值=审核级数,新闻信息从新闻编辑移交给新闻表*/
if :new.ne_newsconfirmlever>0 and :new.ne_newslevernumber>=:new.ne_newsconfirmlever
and :new.ne_newsispublished=1 then
insert into news(n_newseditid,n_newsfloderid,n_newstitle
,n_newscontent,n_newsfrom,n_newshaspicture,
n_newshasmedia,n_newsfilename,n_newsfilepath
,n_newshasfile,n_newsgood,n_newsispublished)
select ne_id,ne_newsfloderid,ne_newstitle
,ne_newscontent,ne_newsfrom,ne_newshaspicture,ne_newshasmedia
,ne_newsfilename,ne_newsfilepath,ne_newshasfile
,ne_newsgood,ne_newsispublished
from news_edit where ne_id=:new.ne_id;
end if;end;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货