--   Copyright 2020 MSolution.IO
--
--   Licensed under the Apache License, Version 2.0 (the "License");
--   you may not use this file except in compliance with the License.
--   You may obtain a copy of the License at
--
--       http://www.apache.org/licenses/LICENSE-2.0
--
--   Unless required by applicable law or agreed to in writing, software
--   distributed under the License is distributed on an "AS IS" BASIS,
--   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
--   See the License for the specific language governing permissions and
--   limitations under the License.

ALTER TABLE user ADD account_type VARCHAR(255) NOT NULL DEFAULT "";
ALTER TABLE user DROP CONSTRAINT unique_email;
ALTER TABLE user ADD CONSTRAINT type_email_unique UNIQUE (email, account_type);
--   Copyright 2020 MSolution.IO
--
--   Licensed under the Apache License, Version 2.0 (the "License");
--   you may not use this file except in compliance with the License.
--   You may obtain a copy of the License at
--
--       http://www.apache.org/licenses/LICENSE-2.0
--
--   Unless required by applicable law or agreed to in writing, software
--   distributed under the License is distributed on an "AS IS" BASIS,
--   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
--   See the License for the specific language governing permissions and
--   limitations under the License.

ALTER TABLE user ADD account_type VARCHAR(255) NOT NULL DEFAULT "trackit";
ALTER TABLE user DROP CONSTRAINT unique_email;
ALTER TABLE user ADD CONSTRAINT type_email_unique UNIQUE (email, account_type);
Add default value for user.account_type field to trackit
Add default value for user.account_type field to trackit
