drop all primary keys

ALTER TABLE name
   DROP PRIMARY KEY

ALTER TABLE lookup_details
ADD CONSTRAINT FK_lookup_id
FOREIGN KEY (lookup_id) REFERENCES master_lookup(lookup_id);

ALTER TABLE lookup_details DROP FOREIGN KEY lookup_foreign_key

ALTER TABLE customer_info ADD CONSTRAINT FK_project_id
FOREIGN KEY (project_id) REFERENCES projects(project_id);

ALTER TABLE customer_info ADD CONSTRAINT FK_source_type_id
FOREIGN KEY (source_type_id) REFERENCES source_types(source_type_id);

ALTER TABLE customer_info ADD CONSTRAINT FK_enquiry_type_id
FOREIGN KEY (enquiry_type_id) REFERENCES enquiry_types(enquiry_type_id)

ALTER TABLE `enquiry_types` CHANGE `enquiry_type_id` `enquiry_type_id` INT(11) NOT NULL AUTO_INCREMENT;
ALTER TABLE `cust_addresses` CHANGE `address_id` `address_id` INT(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE customer_info ADD CONSTRAINT FK_address_id
FOREIGN KEY (address_id) REFERENCES cust_addresses(address_id)


ALTER TABLE `source_types` CHANGE `source_type_id` `source_type_id` INT(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE customer_add_info  ADD CONSTRAINT FK_customer_id

FOREIGN KEY (customer_id) REFERENCES customer_info(customer_id);

ALTER TABLE `banks` CHANGE `bank_id` `bank_id` INT(11) NOT NULL AUTO_INCREMENT;

ALTER TABLE customer_add_info ADD CONSTRAINT FK_hl_bank_id
FOREIGN KEY (hl_bank_id) REFERENCES banks(bank_id);


ALTER TABLE customer_property
   DROP PRIMARY KEY
   
   
   ALTER TABLE customer_property ADD CONSTRAINT FK_CP_project_id
FOREIGN KEY (project_id) REFERENCES projects(project_id)  
   ALTER TABLE `customer_property` CHANGE `project_id` `project_id` INT(11) NOT NULL COMMENT 'PROJECTS table;';
   
   ALTER TABLE customer_property ADD CONSTRAINT FK_CI_customer_id
FOREIGN KEY (customer_id) REFERENCES customer_info(customer_id)


ALTER TABLE block_number ADD CONSTRAINT FK_BN_project_id
FOREIGN KEY (project_id) REFERENCES projects(project_id)

ALTER TABLE cust_property_tax_info ADD CONSTRAINT FK_Cust_I_customer_id
FOREIGN KEY (customer_id) REFERENCES customer_info(customer_id)

ALTER TABLE cust_property_tax_info ADD CONSTRAINT FK_CP_property_id
FOREIGN KEY (property_id) REFERENCES customer_property(property_id)


**********************************************************
ALTER TABLE `customer_info`  ADD `old_cis_no` VARCHAR(150) NOT NULL  AFTER `cis_date`;
ALTER TABLE `cust_property_tax_info`  ADD `id` INT NOT NULL AUTO_INCREMENT  FIRST,  ADD   PRIMARY KEY  (`id`);
ALTER TABLE `customer_sms`  ADD `id` INT NOT NULL AUTO_INCREMENT  FIRST,  ADD   PRIMARY KEY  (`id`);
ALTER TABLE `customer_sms` CHANGE `sent_by` `sent_by` VARCHAR(150) NULL DEFAULT NULL, CHANGE `sent_date` `sent_date` DATE NULL DEFAULT NULL, CHANGE `message` `message` VARCHAR(200) NULL DEFAULT NULL;
ALTER TABLE `customer_housing_loan` ADD PRIMARY KEY(`house_loan_id`);
ALTER TABLE cust_property_payment_terms
   DROP PRIMARY KEY
 ALTER TABLE `cust_property_payment_terms` ADD PRIMARY KEY(`payment_id`);
 ALTER TABLE `cust_property_payment_terms` CHANGE `payment_id` `payment_id` INT(11) NOT NULL AUTO_INCREMENT COMMENT 'System generated';
 ALTER TABLE `customer_info`  ADD `active_flag` TINYINT(1) NOT NULL DEFAULT '1'  AFTER `old_cis_no`;
 ALTER TABLE `customer_info` CHANGE `mobile_num1` `mobile_num1` VARCHAR(25) NULL DEFAULT NULL COMMENT 'CONTACT_DTLS', CHANGE `mobile_num2` `mobile_num2` VARCHAR(25) NULL DEFAULT NULL COMMENT 'CONTACT_DTLS', CHANGE `work_phone_num` `work_phone_num` VARCHAR(25) NULL DEFAULT NULL COMMENT 'CONTACT_DTLS', CHANGE `home_phone_num` `home_phone_num` VARCHAR(25) NULL DEFAULT NULL COMMENT 'CONTACT_DTLS', CHANGE `fax` `fax` VARCHAR(25) NULL DEFAULT NULL COMMENT 'CONTACT_DTLS';
**********************************************************