Files
CoHaiSe/backend/crm/migrations/003_integrity_backstop.sql
Esiah 858d862fed
deploy / deploy (push) Canceled after 0s
feat: init repo
2026-11-10 19:56:03 +01:00

19 lines
695 B
SQL

ALTER TABLE users
ADD CONSTRAINT fk_users_role FOREIGN KEY (role_id) REFERENCES roles (id) ON DELETE RESTRICT,
ADD CONSTRAINT chk_users_names CHECK (CHAR_LENGTH(first_name) > 0 AND CHAR_LENGTH(last_name) > 0);
ALTER TABLE contacts
ADD CONSTRAINT chk_contacts_names CHECK (CHAR_LENGTH(first_name) > 0 AND CHAR_LENGTH(last_name) > 0);
ALTER TABLE organizations
ADD CONSTRAINT chk_organizations_name CHECK (CHAR_LENGTH(name) > 0);
ALTER TABLE deals
ADD CONSTRAINT chk_deals_title CHECK (CHAR_LENGTH(title) > 0);
ALTER TABLE tags
ADD CONSTRAINT chk_tags_name CHECK (CHAR_LENGTH(name) > 0);
ALTER TABLE pipeline_stages
ADD CONSTRAINT chk_stages_name CHECK (CHAR_LENGTH(name) > 0);