新增初始化脚本

zhou-hao · zhou-hao · commit c20bb218d855 · 2016-12-13T09:50:57.000+08:00
diff --git a/hsweb-web-oauth2/hsweb-web-oauth2-simple/src/main/resources/org/hsweb/start/scripts/initialize/initialize.groovy b/hsweb-web-oauth2/hsweb-web-oauth2-simple/src/main/resources/org/hsweb/start/scripts/initialize/initialize.groovy
@@ -0,0 +1,9 @@
+def s_modules = database.getTable("s_modules");
+
+def modules = [
+        [u_id: 'api', name: '接口管理', uri: '', icon: '', parent_id: '-1', remark: '', status: 1, optional: '["id":"M","text":"菜单可见"]', sort_index: 6]
+        , [u_id: 'oauth2-manager', name: '客户端管理', uri: 'admin/oauth2/list.html', icon: '', parent_id: 'api', remark: '', status: 1, optional: '[{"id":"enable","text":"启用"},{"id":"disable","text":"禁用"},{"id":"M","text":"菜单可见","checked":true},{"id":"R","text":"查询","checked":true},{"id":"C","text":"新增","checked":true},{"id":"U","text":"修改","checked":true},{"id":"D","text":"删除","checked":false}]', sort_index: 601]
+];
+for (module in modules) {
+    s_modules.createInsert().value(module).exec();
+}
diff --git a/hsweb-web-oauth2/hsweb-web-oauth2-simple/src/main/resources/org/hsweb/start/scripts/install/install.groovy b/hsweb-web-oauth2/hsweb-web-oauth2-simple/src/main/resources/org/hsweb/start/scripts/install/install.groovy
@@ -0,0 +1,22 @@
+import org.hsweb.ezorm.rdb.RDBDatabase
+
+import java.sql.JDBCType;
+
+database.createOrAlter("s_oauth2_access")
+        .addColumn().name("u_id").jdbcType(JDBCType.VARCHAR).length(32).notNull().primaryKey().comment("ID").commit()
+        .addColumn().name("client_id").jdbcType(JDBCType.VARCHAR).length(32).notNull().comment("客户端ID").commit()
+        .addColumn().name("user_id").jdbcType(JDBCType.VARCHAR).length(32).notNull().comment("用户ID").commit()
+        .addColumn().name("access_token").jdbcType(JDBCType.VARCHAR).length(128).notNull().comment("授权码").commit()
+        .addColumn().name("refresh_token").jdbcType(JDBCType.VARCHAR).length(128).notNull().comment("授权更新码").commit()
+        .addColumn().name("expire_in").number(32).notNull().comment("有效期").commit()
+        .addColumn().name("create_date").datetime().notNull().comment("创建日期").commit()
+        .comment("OAuth2授权信息").commit()
+
+database.createOrAlter("s_oauth2_client")
+        .addColumn().name("u_id").jdbcType(JDBCType.VARCHAR).length(32).notNull().primaryKey().comment("ID").commit()
+        .addColumn().name("user_id").jdbcType(JDBCType.VARCHAR).length(32).notNull().comment("用户ID").commit()
+        .addColumn().name("name").jdbcType(JDBCType.VARCHAR).length(128).comment("客户端名称").commit()
+        .addColumn().name("secret").jdbcType(JDBCType.VARCHAR).length(128).comment("密钥").commit()
+        .addColumn().name("comment").jdbcType(JDBCType.VARCHAR).length(512).comment("备注").commit()
+        .addColumn().name("status").integer().comment("状态").commit()
+        .comment("OAuth2客户端信息").commit()
