/*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;