/*
|
* Copyright [2020-2030] [https://www.stylefeng.cn]
|
*
|
* Licensed under the Apache License, Version 2.0 (the "License");
|
* you may not use this file except in compliance with the License.
|
* You may obtain a copy of the License at
|
*
|
* http://www.apache.org/licenses/LICENSE-2.0
|
*
|
* Unless required by applicable law or agreed to in writing, software
|
* distributed under the License is distributed on an "AS IS" BASIS,
|
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
|
* See the License for the specific language governing permissions and
|
* limitations under the License.
|
*
|
* Guns采用APACHE LICENSE 2.0开源协议，您在使用过程中，需要注意以下几点：
|
*
|
* 1.请不要删除和修改根目录下的LICENSE文件。
|
* 2.请不要删除和修改Guns源码头部的版权声明。
|
* 3.请保留源码和相关描述文件的项目出处，作者声明等。
|
* 4.分发源码时候，请注明软件出处 https://gitee.com/stylefeng/guns
|
* 5.在修改包名，模块名称，项目代码等时，请注明软件出处 https://gitee.com/stylefeng/guns
|
* 6.若您的项目无法满足以上几点，可申请商业授权
|
*/
|
package cn.stylefeng.roses.kernel.dict.modular.sqladapter;
|
|
import cn.stylefeng.roses.kernel.db.api.sqladapter.AbstractSql;
|
import lombok.Getter;
|
|
/**
|
* 创建数据库的sql，可用在租户的创建
|
*
|
* @author fengshuonan
|
* @date 2019-07-16-13:06
|
*/
|
@Getter
|
public class DictSql extends AbstractSql {
|
|
@Override
|
protected String mysql() {
|
return "CREATE TABLE `sys_dict` (\n" +
|
" `dict_id` bigint(20) NOT NULL COMMENT '字典id',\n" +
|
" `dict_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '字典编码',\n" +
|
" `dict_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '字典名称',\n" +
|
" `dict_name_pinyin` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '字典名称首字母',\n" +
|
" `dict_encode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '字典编码',\n" +
|
" `dict_type_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '字典类型的编码',\n" +
|
" `dict_short_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '字典简称',\n" +
|
" `dict_short_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '字典简称的编码',\n" +
|
" `dict_parent_id` bigint(20) NOT NULL COMMENT '上级字典的id(如果没有上级字典id，则为-1)',\n" +
|
" `status_flag` tinyint(4) NOT NULL COMMENT '状态：(1-启用,2-禁用),参考 StatusEnum',\n" +
|
" `dict_sort` decimal(10,2) DEFAULT NULL COMMENT '排序，带小数点',\n" +
|
" `dict_pids` varchar(1000) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '父id集合',\n" +
|
" `del_flag` char(1) CHARACTER SET utf8 NOT NULL DEFAULT 'N' COMMENT '是否删除，Y-被删除，N-未删除',\n" +
|
" `create_time` datetime DEFAULT NULL COMMENT '创建时间',\n" +
|
" `create_user` bigint(20) DEFAULT NULL COMMENT '创建用户id',\n" +
|
" `update_time` datetime DEFAULT NULL COMMENT '修改时间',\n" +
|
" `update_user` bigint(20) DEFAULT NULL COMMENT '修改用户id',\n" +
|
" PRIMARY KEY (`dict_id`) USING BTREE\n" +
|
") ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='字典';";
|
}
|
|
@Override
|
protected String sqlServer() {
|
return "";
|
}
|
|
@Override
|
protected String pgSql() {
|
return "";
|
}
|
|
@Override
|
protected String oracle() {
|
return "";
|
}
|
}
|
