alter table au_versions add client_id smallint not null
alter table au_versions add CONSTRAINT au_versions_pk primary key
(application_id, backupno, name, path, client_id)
I need to add not null column in db that then add primary key. But
when i run
alter table au_versions add client_id smallint not null
I have error.
Error: ALTER TABLE 'au_versions' failed. Default clause is required in
order to add non-NULL column 'client_id'.
How can I add not null column to db that then add primary key?
