不区分大小写索引建立

drop index ems.sys_user_user_name;
create unique index   cclv_player_user_name     on ems.sys_user USING btree (LOWER(user_name));

字段不区分大小写

sudo tee /etc/yum.repos.d/pgdg-redhat-all.repo > /dev/null <<EOF
[pgdg-common]
name=PostgreSQL common RPMs for RHEL / Rocky \$releasever - \$basearch
baseurl=https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-\$releasever-\$basearch
enabled=1
gpgcheck=0

[pgdg14]
name=PostgreSQL 14 for RHEL / Rocky \$releasever - \$basearch
baseurl=https://download.postgresql.org/pub/repos/yum/14/redhat/rhel-\$releasever-\$basearch
enabled=1
gpgcheck=0
EOF




sudo dnf makecache -y

sudo tee /etc/yum.repos.d/pgdg-redhat-all.repo > /dev/null <<EOF
[pgdg-common]
name=PostgreSQL common RPMs for RHEL / Rocky $releasever - $basearch
baseurl=https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-$releasever-$basearch
enabled=1
gpgcheck=1

[pgdg14]
name=PostgreSQL 14 for RHEL / Rocky $releasever - $basearch
baseurl=https://download.postgresql.org/pub/repos/yum/14/redhat/rhel-$releasever-$basearch
enabled=1
gpgcheck=1
EOF

sudo dnf install -y postgresql14-contrib

sudo -u postgres psql -d cclv_data -c "CREATE EXTENSION IF NOT EXISTS citext;"

ALTER TABLE ems.sys_user 
ALTER COLUMN user_name TYPE citext USING user_name::citext;

https://www.bilibili.com/video/BV1ji4y1v7tw/?vd_source=9f0823ff116001b3a2b5ee6adadd2e2f
https://openwrt.org/docs/guide-developer/toolchain/install-buildsystem

https://github.com/jiay-shi/openwrt?tab=readme-ov-file
https://github.com/kiddin9/openwrt-packages
https://dl.openwrt.ai/23.05/packages/arm_cortex-a7/kiddin9/
https://github.com/kenzok8/openwrt-packages
git clone https://github.com/openwrt/openwrt 官方版本
git clone https://github.com/coolsnowwolf/lede lede版本
git clone -b 22.03 --single-branch https://github.com/Lienol/openwrt lienol版本
https://github.com/OldCoding/openwrt_packit_arm/blob/main/immo_diy.sh
https://www.right.com.cn/FORUM/thread-8378388-1-1.html

获取源码

sudo apt update && sudo apt install -y build-essential libncurses5-dev gawk git subversion libssl-dev gettext zlib1g-dev file wget unzip python3
git clone -b ipq60xx-devel_nss https://github.com/JiaY-shi/openwrt.git && cd openwrt

方案一

echo "src-git packages https://git.openwrt.org/feed/packages.git
src-git luci https://git.openwrt.org/project/luci.git
src-git routing https://git.openwrt.org/feed/routing.git
src-git nss_packages https://github.com/JiaY-shi/nss-packages.git;k6.6
src-git passwall https://github.com/xiaorouji/openwrt-passwall.git
src-git passwall_packages https://github.com/xiaorouji/openwrt-passwall-packages.git
" > feeds.conf.default 

拉取包

./scripts/feeds update  -a && ./scripts/feeds install -a
sed -i 's/192.168.1.1/192.168.8.1/g' ./package/base-files/files/bin/config_generate

补丁-1

cd /data/ && git clone https://github.com/OldCoding/openwrt_packit_arm.git
echo 'cp /data/openwrt_packit_arm/patches/* /data/openwrt/feeds/packages/net/shadowsocks-libev/patches' >patch.sh && chmod 777 *.sh
./patch.sh

补丁-2

在 menuconfig 中取消选择 dnsmasq 并选择 dnsmasq-full：
导航到 Base system -> dnsmasq
取消选择 dnsmasq
选择 dnsmasq-full

配置并编译

cd openwrt && rm tmp/ -rf && rm .config
make menuconfig
make V=s -j1

# 多线程编译
make -j$(nproc)