Change ID

[vague gale]

in astro db can I change the id to an 8 digit number?

[misty ginkgo]

You can do something like this:

// db/config.ts
import { column, defineDb, defineTable, sql } from 'astro:db';

export default defineDb({
  tables: {
    User: defineTable({
      id: column.text({ primaryKey: true, default: sql`uuid()` }),
      name
    }),
  },
});