forked from Gitlink/microservices
53 lines
4.0 KiB
SQL
53 lines
4.0 KiB
SQL
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; |