C#.NET通用权限管理在DB2数据库上运行的脚本参考 - 序列创建脚本参考-阿里云开发者社区

C#.NET通用权限管理在DB2数据库上运行的脚本参考 - 序列创建脚本参考

2017-11-15 920

版权

本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。

简介：

+关注继续查看

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;

本文转自jirigala_bao 51CTO博客，原文链接:http://blog.51cto.com/jirigala/812617