Backend/migrations/00004_update_users.up.sql

10 lines
442 B
SQL

ALTER TABLE users
ADD COLUMN name TEXT NOT NULL DEFAULT '',
ADD COLUMN role TEXT NOT NULL DEFAULT '',
ADD COLUMN speciality TEXT NOT NULL DEFAULT '',
ADD COLUMN description TEXT NOT NULL DEFAULT '',
ADD COLUMN skills TEXT NOT NULL DEFAULT '',
ADD COLUMN avatar TEXT NOT NULL DEFAULT '',
ADD COLUMN joinDate TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
ADD COLUMN projects TEXT NOT NULL DEFAULT '',
ADD COLUMN motto TEXT NOT NULL DEFAULT '';