certd/packages/ui/certd-server/db
xiaojunnuo 37f1f53b56 chore: 数据库同步 2025-09-14 00:40:38 +08:00
..
migration fix: 修复证书手动托管时新上传的证书无效的bug 2025-09-13 23:59:16 +08:00
migration-mysql chore: 数据库同步 2025-09-14 00:40:38 +08:00
migration-pg chore: 数据库同步 2025-09-14 00:40:38 +08:00
readme.md chore: plugin管理 2024-10-13 01:27:08 +08:00
transform.js chore: 数据库同步 2025-09-14 00:40:38 +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