github.com/dimeko/sapi@v0.0.0-20231115204413-952501e4268a/db/migrations/1_create_users.up.sql (about)

     1  CREATE TABLE IF NOT EXISTS users (
     2      id SERIAL NOT NULL PRIMARY KEY,
     3  	username VARCHAR ( 50 ) UNIQUE NOT NULL,
     4  	firstname VARCHAR ( 50 ) NOT NULL,
     5  	lastname VARCHAR ( 50 ) NOT NULL,
     6      created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(),
     7      updated_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
     8  )