microservices/sql/update/hisotry_sql/2023-06-13-001.sql

53 lines
4.0 KiB
SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

SET FOREIGN_KEY_CHECKS = 0;
DELETE
FROM
`ruoyi-gitlink`.sys_dict_data
WHERE
dict_type = 'gitlink_project_properties';
DELETE
FROM
`ruoyi-gitlink`.sys_dict_type
WHERE
dict_type = 'gitlink_project_properties';
DELETE
FROM
`ruoyi-gitlink`.sys_dict_data
WHERE
dict_type = 'member_audit_status';
DELETE
FROM
`ruoyi-gitlink`.sys_dict_type
WHERE
dict_type = 'member_audit_status';
INSERT INTO `ruoyi-gitlink`.`sys_dict_type` ( `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark` )
VALUES
( '专区会员审核状态', 'zone_member_audit_status', '0', 'admin', '2023-06-13 15:41:30', '', NULL, NULL );
INSERT INTO `ruoyi-gitlink`.`sys_dict_data` ( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark` )
VALUES
( 0, '未审核', '0', 'zone_member_audit_status', NULL, NULL, 'N', '0', 'admin', '2023-06-13 15:42:01', '', NULL, NULL );
INSERT INTO `ruoyi-gitlink`.`sys_dict_data` ( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark` )
VALUES
( 0, '审核通过', '1', 'zone_member_audit_status', NULL, NULL, 'N', '0', 'admin', '2023-06-13 15:42:09', '', NULL, NULL );
INSERT INTO `ruoyi-gitlink`.`sys_dict_data` ( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark` )
VALUES
( 0, '审核未通过', '2', 'zone_member_audit_status', NULL, NULL, 'N', '0', 'admin', '2023-06-13 15:42:28', '', NULL, NULL );
INSERT INTO `ruoyi-gitlink`.`sys_dict_type` ( `dict_name`, `dict_type`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark` )
VALUES
( 'GitLink项目属性', 'gitlink_project_properties', '0', 'admin', '2023-05-11 13:49:38', '', NULL, NULL );
INSERT INTO `ruoyi-gitlink`.`sys_dict_data` ( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark` )
VALUES
( 1, '点赞数', 'praises_count', 'gitlink_project_properties', NULL, 'default', 'N', '0', 'admin', '2023-05-11 13:51:04', 'admin', '2023-06-12 14:28:48', NULL );
INSERT INTO `ruoyi-gitlink`.`sys_dict_data` ( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark` )
VALUES
( 0, '项目标签', 'topics', 'gitlink_project_properties', NULL, 'default', 'N', '0', 'admin', '2023-05-11 13:51:09', 'admin', '2023-06-12 14:18:08', '小数点代表从前一个对象中取值开头为array代表获取的数据为数组类型将使用,对值进行拼接' );
INSERT INTO `ruoyi-gitlink`.`sys_dict_data` ( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark` )
VALUES
( 2, '项目语言', 'language', 'gitlink_project_properties', NULL, 'default', 'N', '0', 'admin', '2023-05-11 13:51:17', 'admin', '2023-06-12 14:29:16', NULL );
INSERT INTO `ruoyi-gitlink`.`sys_dict_data` ( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark` )
VALUES
( 1, '复刻数', 'forked_count', 'gitlink_project_properties', NULL, 'default', 'N', '0', 'admin', '2023-05-11 14:39:38', 'admin', '2023-06-12 14:28:44', NULL );
INSERT INTO `ruoyi-gitlink`.`sys_dict_data` ( `dict_sort`, `dict_label`, `dict_value`, `dict_type`, `css_class`, `list_class`, `is_default`, `status`, `create_by`, `create_time`, `update_by`, `update_time`, `remark` )
VALUES
( 3, '更新时间', 'time_ago', 'gitlink_project_properties', NULL, 'default', 'N', '0', 'admin', '2023-05-12 15:28:07', 'admin', '2023-06-12 14:29:41', NULL );
SET FOREIGN_KEY_CHECKS = 1;