Write session migration

Initialize migration file

npm run migrate create session-table

Write UP migration implementation

// Create session table
pgm.createTable('session', {
  sid: {
    type: 'varchar',
    primaryKey: true,
    notNull: true,
  },
  sess: {
    type: 'jsonb',
    notNull: true,
  },
  expire: {
    type: 'timestamp',
    notNull: true,
  },
});

// Index on expire for efficient cleanup of expired sessions
pgm.createIndex('session', 'expire');

Write DOWN Migration implementation

pgm.dropTable('session');

Run the migration

npm run migrate up

Next:
Write user migration