diff options
Diffstat (limited to 'server/migrations')
| -rw-r--r-- | server/migrations/20220822142548_add-users-table.sql | 11 |
1 files changed, 7 insertions, 4 deletions
diff --git a/server/migrations/20220822142548_add-users-table.sql b/server/migrations/20220822142548_add-users-table.sql index 4798d7e..c9571ec 100644 --- a/server/migrations/20220822142548_add-users-table.sql +++ b/server/migrations/20220822142548_add-users-table.sql @@ -1,6 +1,9 @@ create table users ( - id serial unique, - email varchar(100) unique not null, - password varchar(100) not null, - is_staff boolean default false + id SERIAL PRIMARY KEY, + name VARCHAR(100), + email VARCHAR(100) UNIQUE NOT NULL, + username VARCHAR(100) UNIQUE NOT NULL, + password VARCHAR(100) NOT NULL, + avatar VARCHAR, + is_staff BOOLEAN DEFAULT false ); |