ALTER TABLE `CAMERA` 
DROP FOREIGN KEY `fk_shutter_type`,
DROP FOREIGN KEY `fk_negative_size`,
DROP FOREIGN KEY `fk_mount`,
DROP FOREIGN KEY `fk_metering_type`,
DROP FOREIGN KEY `fk_manufacturer`,
DROP FOREIGN KEY `fk_format`,
DROP FOREIGN KEY `fk_focus_type`,
DROP FOREIGN KEY `fk_body_type`,
DROP FOREIGN KEY `fk_CAMERA_4`,
DROP FOREIGN KEY `fk_CAMERA_2`,
DROP FOREIGN KEY `fk_CAMERA_1`;
ALTER TABLE `CAMERA` 
DROP COLUMN `tripod`,
DROP COLUMN `dof_preview`,
DROP COLUMN `meter_max_ev`,
DROP COLUMN `meter_min_ev`,
DROP COLUMN `x_sync`,
DROP COLUMN `coldshoe`,
DROP COLUMN `hotshoe`,
DROP COLUMN `pc_sync`,
DROP COLUMN `flash_metering`,
DROP COLUMN `ext_flash`,
DROP COLUMN `int_flash_gn`,
DROP COLUMN `int_flash`,
DROP COLUMN `af_points`,
DROP COLUMN `max_iso`,
DROP COLUMN `min_iso`,
DROP COLUMN `time`,
DROP COLUMN `bulb`,
DROP COLUMN `max_shutter`,
DROP COLUMN `min_shutter`,
DROP COLUMN `battery_type`,
DROP COLUMN `battery_qty`,
DROP COLUMN `fixed_mount`,
DROP COLUMN `digital`,
DROP COLUMN `video`,
DROP COLUMN `continuous_fps`,
DROP COLUMN `power_drive`,
DROP COLUMN `viewfinder_coverage`,
DROP COLUMN `cable_release`,
DROP COLUMN `shutter_model`,
DROP COLUMN `shutter_type_id`,
DROP COLUMN `negative_size_id`,
DROP COLUMN `discontinued`,
DROP COLUMN `introduced`,
DROP COLUMN `weight`,
DROP COLUMN `body_type_id`,
DROP COLUMN `metering_type_id`,
DROP COLUMN `coupled_metering`,
DROP COLUMN `metering`,
DROP COLUMN `focus_type_id`,
DROP COLUMN `format_id`,
DROP COLUMN `mount_id`,
DROP COLUMN `model`,
DROP COLUMN `manufacturer_id`,
DROP INDEX `fk_CAMERA_4_idx` ,
DROP INDEX `fk_CAMERA_2_idx` ,
DROP INDEX `fk_CAMERA_1_idx` ,
DROP INDEX `fk_shutter_type_id` ,
DROP INDEX `fk_negative_size_id` ,
DROP INDEX `fk_metering_type` ,
DROP INDEX `fk_manufacturer` ,
DROP INDEX `fk_format` ,
DROP INDEX `fk_mount` ,
DROP INDEX `fk_focus_type` ,
DROP INDEX `body_type_id` ,
DROP INDEX `manufacturer_id` ;