 DROP TABLE IF EXISTS `insurance_company_client`;
 
 CREATE TABLE `insurance_company_client` (
-  `id` INTEGER NOT NULL AUTO_INCREMENT DEFAULT NOT NULL,
+  `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
   `company_name` VARCHAR(30) NULL DEFAULT NULL,
   `username` INTEGER NULL DEFAULT NULL,
   `password` VARCHAR(30) NULL DEFAULT NULL,

DROP TABLE IF EXISTS `medication`;

CREATE TABLE `medication` (
  `id` INTEGER NOT NULL AUTO_INCREMENT DEFAULT NOT NULL,
  `drug_name` VARCHAR(40) NULL DEFAULT NULL,
  `details` INTEGER NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
);

  `weight` INTEGER NULL DEFAULT NULL,
  `height` INTEGER NULL DEFAULT NULL,
  `blood_type` VARCHAR(2) NULL DEFAULT NULL,
  `photo_path` VARCHAR(500) DEFAULT NULL,
  PRIMARY KEY (`id`)
);

