C#.NET通用权限管理DB2数据库上运行时,需要创建一些序列,脚本如下:
若您用到了DB2数据库直接运行这个脚本就可以了,不用每个都自己创建了。
create sequence SEQ_BASE_TABLECOLUMNS
as
bigint start with
1000000
increment by
1
minvalue
10000
maxvalue
99999999999999999
cycle cache
20
order;
create sequence SEQ_BASE_SEQUENCE as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_LOG as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_EXCEPTION as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_FILE as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_FOLDER as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_ITEMS as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_MESSAGE as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_MODULE as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_ORGANIZE as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_PARAMETER as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_PERMISSIONITEM as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_PERMISSIONSCOPE as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_PERMISSION as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_ROLE as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_STAFF as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_USERADDRESS as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_USERORGANIZE as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_USERROLE as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_USER as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_WORKFLOWACTIVITY as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_WORKFLOWCURRENT as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_WORKFLOWHISTORY as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_WORKFLOWPROCESS as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_SEQUENCE as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_LOG as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_EXCEPTION as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_FILE as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_FOLDER as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_ITEMS as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_MESSAGE as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_MODULE as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_ORGANIZE as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_PARAMETER as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_PERMISSIONITEM as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_PERMISSIONSCOPE as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_PERMISSION as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_ROLE as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_STAFF as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_USERADDRESS as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_USERORGANIZE as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_USERROLE as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_USER as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_WORKFLOWACTIVITY as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_WORKFLOWCURRENT as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_WORKFLOWHISTORY as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
create sequence SEQ_BASE_WORKFLOWPROCESS as bigint start with 1000000 increment by 1 minvalue 10000 maxvalue 99999999999999999 cycle cache 20 order;
本文转自 jirigala 51CTO博客,原文链接:http://blog.51cto.com/2347979/1197385,如需转载请自行联系原作者