github.com/hzck/speedroute@v0.0.0-20201115191102-403b7d0e443f/db/migration/V1__Create_account_table.sql (about) 1 CREATE TABLE account ( 2 id SERIAL PRIMARY KEY, 3 username VARCHAR(30) UNIQUE NOT NULL, 4 password VARCHAR NOT NULL, 5 created TIMESTAMP NOT NULL, 6 last_updated TIMESTAMP NOT NULL 7 );