# dwz

**Repository Path**: feegg/dwz

## Basic Information

- **Project Name**: dwz
- **Description**: 短链接项目
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2024-05-04
- **Last Updated**: 2024-08-18

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

转链接口convert.php
查链 receive.php


```$xslt
新建发号器表
CREATE TABLE sequence (
  id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  stub varchar(1) NOT NULL,
  timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (id),
  UNIQUE KEY idx_uniq_stub (stub)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT = '序号表';
新建长链接短链接映射表：
CREATE TABLE short_url_map (
    id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
    create_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    create_by VARCHAR(64) NOT NULL DEFAULT '' COMMENT '创建者',
    is_del tinyint UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否删除：0正常1删除',
    lurl varchar(2048) DEFAULT NULL COMMENT '长链接',
    md5 char(32) DEFAULT NULL COMMENT '长链接MD5',
    surl varchar(11) DEFAULT NULL COMMENT '短链接',
    PRIMARY KEY (id),
    INDEX(is_del),
    UNIQUE(md5),
    UNIQUE(surl)
)ENGINE=INNODB DEFAULT CHARSET=utf8mb4 COMMENT = '长短链映射表';
```


nginx层
```$xslt

 location ~ ^/dwz/(\w+)$
{
rewrite ^/dwz/(\w+)$ /dwz/api/receive.php?a=$1 last;
}

```