yvjia/db/sys_language.sql

/**
Source Server Version: 8.0.31
Source Database: backendsys
Date: 2023/05/23 17:09:22
*/

DROP TABLE IF EXISTS `sys_language`;
CREATE TABLE `sys_language` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    `language` VARCHAR(50) NOT NULL COMMENT '语言',
    `name` VARCHAR(50) NOT NULL COMMENT '语言名称',
    `is_default` TINYINT(1) DEFAULT '-1' COMMENT '是否默认(-1否, 1是)',
    `status` TINYINT(1) DEFAULT '-1' COMMENT '状态 (-1禁用, 1启用)'
) ENGINE=INNODB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COMMENT='系统语言表';

INSERT INTO sys_language(language, name, is_default, status) VALUES
    ('zh', '简体中文', 1, 1),
    ('zh-tw', '繁體中文', -1, 1),
    ('en', 'English', -1, 1)
;