certd/packages/ui/certd-server/db
xiaojunnuo b97935299f chore: auto功能 数据库升级脚本 2025-07-14 23:46:24 +08:00
..
migration chore: auto功能 数据库升级脚本 2025-07-14 23:46:24 +08:00
migration-mysql chore: auto功能 数据库升级脚本 2025-07-14 23:46:24 +08:00
migration-pg chore: auto功能 数据库升级脚本 2025-07-14 23:46:24 +08:00
readme.md chore: plugin管理 2024-10-13 01:27:08 +08:00
transform.js chore: db transform text改成longtext 2025-01-06 09:39:44 +08:00

readme.md

sqlite与postgres不同点

sqlite: AUTOINCREAMENT postgresql: GENERATED BY DEFAULT AS IDENTITY

sqlite: datetime postgresql: timestamp

sqlite: update sqlite_sequence set seq = 1000 where name = 'sys_role' ; postgresql: select setval('sys_role_id_seq', 1000);

sqlite: "disabled" boolean DEFAULT (0) postgresql: "disabled" boolean DEFAULT (false)

sqlite: last_insert_rowid() postgresql: LASTVAL()

sqlite: integer postgresql: bigint