finance-watcher / sql / up / up.2.update_columns.sql
up.2.update_columns.sql
Raw
ALTER TABLE dashboard_user
ADD COLUMN email VARCHAR(256) NOT NULL DEFAULT '',
ADD COLUMN password VARCHAR(256) NOT NULL DEFAULT '',
ADD COLUMN last_login DATE;

ALTER TABLE business
ADD CONSTRAINT name_business_type_id UNIQUE (name, business_type_id);