CREATE TABLE package
(
  package_id int NOT NULL,
  drug_id int,
  packageTypeId int,
  is_brand bit
);


ALTER TABLE drug ADD drug_id int NOT NULL;
ALTER TABLE drug DROP COLUMN id;
ALTER TABLE drug DROP COLUMN is_brand;
ALTER TABLE drug DROP COLUMN packageTypeId;
ALTER TABLE drug_image ADD package_id int;

