Loading

changes to: map_layers

  1. ALTER TABLE `dev_customer_support`.`map_layers`
  2. DROP FOREIGN KEY `contact-map_layers`;
  3. ALTER TABLE `dev_customer_support`.`map_layers`
  4. CHANGE COLUMN `contact_id` `contact_id` INT(11) NULL ,
  5. ADD COLUMN `staff_id` INT NULL AFTER `contact_id`,
  6. ADD COLUMN `application_id` INT NULL DEFAULT 0 AFTER `field_id`;
  7. ALTER TABLE `dev_customer_support`.`map_layers`
  8. ADD CONSTRAINT `contact-map_layers`
  9.   FOREIGN KEY (`contact_id`)
  10.   REFERENCES `dev_customer_support`.`contact` (`id_contact`)
  11.   ON DELETE NO ACTION
  12.   ON UPDATE NO ACTION;

Comments