1 alter table customers modify email varchar(150) not null
2 alter table users add unique (username)
3 alter table products add check (price > 0)
4 alter table orders alter status set default 'pending'
5 alter table employees add salary decimal(10,2) not null check (salary > 10000)
6 alter table employees drop foreign key department_id
alter table employees add foreign key (department_id) references departments(id) on delete cascade
7 alter table accounts drop check balance
8 alter table payments add unique (user_id transaction_id)
Top comments (0)