certd/packages/ui/certd-server/db

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