/*logonlog´´½¨ÐòÁÐ*/
|
create sequence dbsys_logonlog_ID_SEQ
|
minvalue 1
|
maxvalue 9999999999999999999999999999
|
start with 1
|
increment by 1
|
cache 20;
|
|
/*logonlog´´½¨´¥·¢Æ÷*/
|
create or replace trigger TRG_dbsys_logonlog_ID
|
before insert
|
on dbsys_logonlog
|
for each row
|
declare
|
-- local variables here
|
begin
|
SELECT dbsys_logonlog_ID_SEQ.NEXTVAL INTO:NEW.ID FROM DUAL;
|
end TRG_dbsys_logonlog_ID;
|
|
|
|
/*button´´½¨ÐòÁÐ*/
|
create sequence dbsys_button_ID_SEQ
|
minvalue 1
|
maxvalue 9999999999999999999999999999
|
start with 1
|
increment by 1
|
cache 20;
|
|
/*button´´½¨´¥·¢Æ÷*/
|
create or replace trigger TRG_dbsys_button_ID
|
before insert
|
on dbsys_button
|
for each row
|
declare
|
-- local variables here
|
begin
|
SELECT dbsys_button_ID_SEQ.NEXTVAL INTO:NEW.ID FROM DUAL;
|
end TRG_dbsys_button_ID;
|
|
|
/* items´´½¨ÐòÁÐ*/
|
create sequence dbsys_items_ID_SEQ
|
minvalue 1
|
maxvalue 9999999999999999999999999999
|
start with 1
|
increment by 1
|
cache 20;
|
|
/* items´´½¨´¥·¢Æ÷*/
|
create or replace trigger TRG_dbsys_items_ID
|
before insert
|
on dbsys_items
|
for each row
|
declare
|
-- local variables here
|
begin
|
SELECT dbsys_items_ID_SEQ.NEXTVAL INTO:NEW.ID FROM DUAL;
|
end TRG_dbsys_items_ID;
|
|
|
/* itemsdetail´´½¨ÐòÁÐ*/
|
create sequence dbsys_itemsdetail_ID_SEQ
|
minvalue 1
|
maxvalue 9999999999999999999999999999
|
start with 1
|
increment by 1
|
cache 20;
|
|
/* itemsdetail´´½¨´¥·¢Æ÷*/
|
create or replace trigger TRG_dbsys_itemsdetail_ID
|
before insert
|
on dbsys_itemsdetail
|
for each row
|
declare
|
-- local variables here
|
begin
|
SELECT dbsys_itemsdetail_ID_SEQ.NEXTVAL INTO:NEW.ID FROM DUAL;
|
end TRG_dbsys_itemsdetail_ID;
|
|
|
/* module´´½¨ÐòÁÐ*/
|
create sequence dbsys_module_ID_SEQ
|
minvalue 1
|
maxvalue 9999999999999999999999999999
|
start with 1
|
increment by 1
|
cache 20;
|
|
/* module´´½¨´¥·¢Æ÷*/
|
create or replace trigger TRG_dbsys_module_ID
|
before insert
|
on dbsys_module
|
for each row
|
declare
|
-- local variables here
|
begin
|
SELECT dbsys_module_ID_SEQ.NEXTVAL INTO:NEW.ID FROM DUAL;
|
end TRG_dbsys_module_ID;
|
|
|
/* organize´´½¨ÐòÁÐ*/
|
create sequence dbsys_organize_ID_SEQ
|
minvalue 1
|
maxvalue 9999999999999999999999999999
|
start with 1
|
increment by 1
|
cache 20;
|
|
/* organize´´½¨´¥·¢Æ÷*/
|
create or replace trigger TRG_dbsys_organize_ID
|
before insert
|
on dbsys_organize
|
for each row
|
declare
|
-- local variables here
|
begin
|
SELECT dbsys_organize_ID_SEQ.NEXTVAL INTO:NEW.ID FROM DUAL;
|
end TRG_dbsys_organize_ID;
|
|
|
/* role´´½¨ÐòÁÐ*/
|
create sequence dbsys_role_ID_SEQ
|
minvalue 1
|
maxvalue 9999999999999999999999999999
|
start with 1
|
increment by 1
|
cache 20;
|
|
/* role´´½¨´¥·¢Æ÷*/
|
create or replace trigger TRG_dbsys_role_ID
|
before insert
|
on dbsys_role
|
for each row
|
declare
|
-- local variables here
|
begin
|
SELECT dbsys_role_ID_SEQ.NEXTVAL INTO:NEW.ID FROM DUAL;
|
end TRG_dbsys_role_ID;
|
|
|
|
/* user´´½¨ÐòÁÐ*/
|
create sequence dbsys_user_ID_SEQ
|
minvalue 1
|
maxvalue 9999999999999999999999999999
|
start with 1
|
increment by 1
|
cache 20;
|
|
/* user´´½¨´¥·¢Æ÷*/
|
create or replace trigger TRG_dbsys_user_ID
|
before insert
|
on dbsys_user
|
for each row
|
declare
|
-- local variables here
|
begin
|
SELECT dbsys_user_ID_SEQ.NEXTVAL INTO:NEW.ID FROM DUAL;
|
end TRG_dbsys_user_ID;
|
