1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465 |
- var info = {
- groupId: "${project.groupId}",
- artifactId: "${project.artifactId}",
- version: "${project.version}",
- website: "https://github.com/hs-web/hsweb-framework/tree/master/hsweb-system/hsweb-system-organizational",
- author: "admin@hsweb.me",
- comment: "组织架构"
- };
- var versions = [
-
-
-
-
-
-
- ];
- var JDBCType = java.sql.JDBCType;
- function install(context) {
- var database = context.database;
- database.createOrAlter("s_organization")
- .addColumn().name("u_id").alias("id").comment("ID").jdbcType(java.sql.JDBCType.VARCHAR).length(32).primaryKey().commit()
- .addColumn().name("name_en").alias("nameEn").comment("名称(英文)").jdbcType(java.sql.JDBCType.VARCHAR).length(32).commit()
- .addColumn().name("leader").alias("leader").comment("机构负责人").jdbcType(java.sql.JDBCType.VARCHAR).length(256).commit()
- .addColumn().name("other_property").alias("otherProperty").comment("其他属性").jdbcType(java.sql.JDBCType.VARCHAR).length(32).commit()
- .comment("组织机构表").commit();
- database.createOrAlter("s_user")
- .addColumn().name("u_id").alias("id").comment("ID").jdbcType(java.sql.JDBCType.VARCHAR).length(32).primaryKey().commit()
- .addColumn().name("nick_name").alias("nickName").comment("昵称").jdbcType(java.sql.JDBCType.VARCHAR).length(32).commit()
- .comment("用户表").commit();
- }
- dependency.setup(info)
- .onInstall(install)
- .onUpgrade(function (context) {
- var upgrader = context.upgrader;
- upgrader.filter(versions)
- .upgrade(function (newVer) {
- newVer.upgrade(context);
- });
- })
- .onUninstall(function (context) {
- });
|