IPv6 端口转发联机软件 4to6

https://github.com/wangyu-/tinyPortMapper https://www.onlinedown.net/soft/110765.htm 两个工具都可以用,但难点不在这里,家庭路由器和光猫很少有对ipv6防火墙的管理设定,导致哪怕拿到了公网IP 也开不出端口,防火墙挡住了。o

windows 批处理同步系统时间

@echo off >NUL 2>&1 REG.exe query "HKU\S-1-5-19" || ( ECHO SET UAC = CreateObject^("Shell.Application"^) > "%TEMP%\Getadmin.vbs" ECHO UAC.ShellExecute "%~f0", "%1", "", "runas", 1 >> "%TEMP%\Getadmin.vbs" "%TEMP%\Getadmin.vbs" DEL /f /q "%TEMP%\Getadmin.vbs" 2>NUL Exit /b ) cd /d %~dp0 net stop w32time w32tm /unregister w32tm /register net start w32time w32tm /config /manualpeerlist:"ntp1.aliyun.com" /syncfromflags:manual /reliable:yes /update w32tm /resync ``

PostgreSQL 数据库建表设置主键自增字段

引用源 https://www.runoob.com/postgresql/postgresql-autoincrement.html MySQL 设置自动增长使用 AUTO_INCREMENT 例如 CREATE TABLE IF NOT EXISTS `runoob_tbl`( `runoob_id` INT UNSIGNED AUTO_INCREMENT, `runoob_title` VARCHAR(100) NOT NULL, `runoob_author` VARCHAR(40) NOT NULL, `submission_date` DATE, PRIMARY KEY ( `runoob_id` ) )ENGINE=InnoDB DEFAULT CHARSET=utf8; PostgreSQL对应使用三个关键字 SMALLSE