· 7 years ago · Sep 23, 2018, 09:48 AM
1ALTER TABLE users ADD COLUMN username text UNIQUE NOT NULL;
2
3CREATE TABLE IF NOT EXISTS authorities (
4 username text NOT NULL,
5 authority text NOT NULL,
6 constraint fk_authorities_users foreign key(username) references users(username)
7);