Error creating table: leads: Query Failed:
CREATE TABLE leads (`id` char(36) NOT NULL ,`date_entered` datetime NULL ,`date_modified` datetime NULL ,
`modified_user_id` char(36) NULL ,`created_by` char(36) NULL ,`description` text NULL ,
`deleted` bool DEFAULT '0' NULL ,`assigned_user_id` char(36) NULL ,`salutation` varchar(255) NULL ,`first_name` varchar(100) NULL ,
`last_name` varchar(100) NULL ,`title` varchar(100) NULL ,`photo` varchar(255) NULL ,`department` varchar(100) NULL ,
`do_not_call` bool DEFAULT '0' NULL ,`phone_home` varchar(100) NULL ,`phone_mobile` varchar(100) NULL ,
`phone_work` varchar(100) NULL ,`phone_other` varchar(100) NULL ,`phone_fax` varchar(100) NULL ,`lawful_basis` text(100) NULL ,
`date_reviewed` date NULL ,`lawful_basis_source` varchar(100) NULL ,`primary_address_street` varchar(150) NULL ,`primary_address_city` varchar(100) NULL ,`primary_address_state` varchar(100) NULL ,
`primary_address_postalcode` varchar(20) NULL ,`primary_address_country` varchar(255) NULL ,`alt_address_street` varchar(150) NULL ,`alt_address_city` varchar(100) NULL ,`alt_address_state` varchar(100) NULL ,`alt_address_postalcode` varchar(20) NULL ,`alt_address_country` varchar(255) NULL ,`assistant` varchar(75) NULL ,`assistant_phone` varchar(100) NULL ,`converted` bool DEFAULT '0' NULL ,`refered_by` varchar(100) NULL ,`lead_source` varchar(100) NULL ,`lead_source_description` text NULL ,`status` varchar(100) NULL ,`status_description` text NULL ,`reports_to_id` char(36) NULL ,`account_name` varchar(255) NULL ,`account_description` text NULL ,`contact_id` char(36) NULL ,`account_id` char(36) NULL ,`opportunity_id` char(36) NULL ,`opportunity_name` varchar(255) NULL ,`opportunity_amount` varchar(50) NULL ,`campaign_id` char(36) NULL ,`birthdate` date NULL ,`portal_name` varchar(255) NULL ,`portal_app` varchar(255) NULL ,`website` varchar(255) NULL ,
PRIMARY KEY (id), KEY idx_lead_acct_name_first (account_name, deleted), KEY idx_lead_last_first (last_name, first_name, deleted),
KEY idx_lead_del_stat (last_name, status, deleted, first_name), KEY idx_lead_opp_del (opportunity_id, deleted),
KEY idx_leads_acct_del (account_id, deleted), KEY idx_del_user (deleted, assigned_user_id),
KEY idx_lead_assigned (assigned_user_id), KEY idx_lead_contact (contact_id), KEY idx_reports_to (reports_to_id),
KEY idx_lead_phone_work (phone_work), KEY idx_leads_id_del (id, deleted))
CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci:
MySQL error 1071: Specified key was too long; max key length is 1000 bytes
Hi, welcome to the Community!