# rustdesk-地址薄-asp.net

**Repository Path**: wanby/rustdesk-api

## Basic Information

- **Project Name**: rustdesk-地址薄-asp.net
- **Description**: 用于rustdesk的地址薄功能扩展
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 1
- **Forks**: 0
- **Created**: 2023-01-30
- **Last Updated**: 2023-06-11

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

修改 App_Code 文件夹中 DBHelper_MySql.cs 文件 数据库连接字符串
数据库使用mysql
数据库创建语句
DROP TABLE IF EXISTS `rustdesk_peers`;
CREATE TABLE `rustdesk_peers`  (
  `deviceid` bigint NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `uid` int UNSIGNED NOT NULL COMMENT '用户ID',
  `id` char(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '设备ID',
  `username` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '操作系统用户名',
  `hostname` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '操作系统名',
  `alias` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '别名',
  `platform` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '平台',
  `tags` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '标签',
  PRIMARY KEY (`deviceid`) USING BTREE,
  UNIQUE INDEX `uuid`(`id`, `uid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '远程设备表' ROW_FORMAT = Dynamic;

DROP TABLE IF EXISTS `rustdesk_tags`;
CREATE TABLE `rustdesk_tags`  (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'tagID',
  `uid` int UNSIGNED NOT NULL COMMENT '用户ID',
  `tag` char(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'tag名称',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `tag`(`tag`, `uid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = 'tags表' ROW_FORMAT = Dynamic;

DROP TABLE IF EXISTS `rustdesk_token`;
CREATE TABLE `rustdesk_token`  (
  `username` char(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
  `uid` int UNSIGNED NOT NULL COMMENT '用户ID',
  `id` char(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '设备码',
  `uuid` char(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '设备ID',
  `access_token` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '登录token',
  `login_time` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '登录时间',
  `expire_time` int NULL DEFAULT NULL COMMENT '过期时间',
  PRIMARY KEY (`access_token`) USING BTREE,
  UNIQUE INDEX `login_token`(`username`, `id`, `uuid`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '登录Token表' ROW_FORMAT = Dynamic;

DROP TABLE IF EXISTS `rustdesk_users`;
CREATE TABLE `rustdesk_users`  (
  `id` int UNSIGNED NOT NULL COMMENT '用户ID',
  `username` char(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
  `password` char(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
  `create_time` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '添加时间',
  `delete_time` int UNSIGNED NOT NULL DEFAULT 0 COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `username`(`username`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;

INSERT INTO `rustdesk_users` VALUES (1, 'admin', 'admin', 0, 0);

在rustdesk api服务器中填写：http://你部署的网站域名:网站端口/api/lg?s=