INSERT INTO dosage_unit (`unit`, `code`, `symbol`)
VALUES
	('grams', 'GRM', 'g'),
    ('millilitres', 'MIL', 'ml'),
	('milligrams', 'MGRM', 'mg'),
	('unit', 'UNT', 'units');

INSERT INTO dosage_type (`code`, `type`, `dosage_unit_id`)
VALUES
	('TBT', 'Tablet', (SELECT `id` from `dosage_unit` where `code` = 'UNT')),
    ('CAP', 'Capsule',  (SELECT `id` from `dosage_unit` where `code` = 'UNT')),
	('SUS', 'Suspension',  (SELECT `id` from `dosage_unit` where `code` = 'MIL')),
	('INJ', 'Injection',  (SELECT `id` from `dosage_unit` where `code` = 'MIL')),
	('GEL', 'Gel',  (SELECT `id` from `dosage_unit` where `code` = 'MIL')),
	('DRP', 'Drops',  (SELECT `id` from `dosage_unit` where `code` = 'MIL')),
	('PWD', 'Powder',  (SELECT `id` from `dosage_unit` where `code` = 'GRM'));

INSERT INTO package_type (`code`, `type`)
VALUES
	('CNT', 'Container'),
    ('BTL', 'Bottle'),
	('BAG', 'Bag'),
	('SNG', 'Syringe'),
	('DBTL', 'Dropper Bottle'),
	('VAL', 'Vial');

/* Acetyl Cysteine */

INSERT INTO medicine (`name`, `description`, `barcode_prefix`, `active_ingredient`, `active_ingredient_nappy_code`, `schedule_status`)
VALUES
	('Acetyl Cysteine', '', 'ACY', 'N-Acetyl L-cysteine', '', 1);

INSERT INTO medicine_dosage_type (`default_price`, `additional_information`, `usage_instructions`, `storage_directions`, `special_instructions`, `dosage_strength`, `medicine_id`, `dosage_type_id`, `medicine_number`)
VALUES
	('0.965', 'Blue Capsules', 'Use as directed by practitioner', 'None', 'None', '250mg/capsule', (SELECT `id` from `medicine` where `name` = 'Acetyl Cysteine'), (SELECT `id` from `dosage_type` where `code` = 'CAP'), 'AC-250');

SET @medicineDosageTypeId = LAST_INSERT_ID();
INSERT INTO medicine_dosage_package_type (`contained_quantity`, `medicine_dosage_type_id`, `package_type_id`)
VALUES
	('100', @medicineDosageTypeId, (SELECT `id` from `package_type` where `code` = 'CNT'));

INSERT INTO medicine_dosage_type (`default_price`, `additional_information`, `usage_instructions`, `storage_directions`, `special_instructions`, `dosage_strength`, `medicine_id`, `dosage_type_id`, `medicine_number`)
VALUES
	('1.925', 'White Capsules', 'Use as directed by practitioner', 'None', 'None', '500mg/capsule', (SELECT `id` from `medicine` where `name` = 'Acetyl Cysteine'), (SELECT `id` from `dosage_type` where `code` = 'CAP'), 'AC-500');

SET @medicineDosageTypeId = LAST_INSERT_ID();
INSERT INTO medicine_dosage_package_type (`contained_quantity`, `medicine_dosage_type_id`, `package_type_id`)
VALUES
	('100', @medicineDosageTypeId, (SELECT `id` from `package_type` where `code` = 'CNT'));

/* Atipamezole */

INSERT INTO medicine (`name`, `description`, `barcode_prefix`, `active_ingredient`, `active_ingredient_nappy_code`, `schedule_status`)
VALUES
	('Atipamezole', '', 'ATI', 'Atipamezole', '', 0);

INSERT INTO medicine_dosage_type (`default_price`, `additional_information`, `usage_instructions`, `storage_directions`, `special_instructions`, `dosage_strength`, `medicine_id`, `dosage_type_id`, `medicine_number`)
VALUES
	('94.6', 'Clear Liquid', 'Use as directed by practitioner', 'None', 'None', '20mg/ml', (SELECT `id` from `medicine` where `name` = 'Atipamezole'), (SELECT `id` from `dosage_type` where `code` = 'INJ'), 'AT-20');

SET @medicineDosageTypeId = LAST_INSERT_ID();
INSERT INTO medicine_dosage_package_type (`contained_quantity`, `medicine_dosage_type_id`, `package_type_id`)
VALUES
	('10', @medicineDosageTypeId, (SELECT `id` from `package_type` where `code` = 'VAL'));


/* Azithromycin */

INSERT INTO medicine (`name`, `description`, `barcode_prefix`, `active_ingredient`, `active_ingredient_nappy_code`, `schedule_status`)
VALUES
	('Azithromycin', '', 'AZI', 'Azithromycin', '', 4);

INSERT INTO medicine_dosage_type (`default_price`, `additional_information`, `usage_instructions`, `storage_directions`, `special_instructions`, `dosage_strength`, `medicine_id`, `dosage_type_id`, `medicine_number`)
VALUES
	('6.6', 'Small white tablets with light brown spots', 'Use as directed by practitioner', 'None', 'None', '50mg/tablet', (SELECT `id` from `medicine` where `name` = 'Azithromycin'), (SELECT `id` from `dosage_type` where `code` = 'TBT'), 'AZ-50');

SET @medicineDosageTypeId = LAST_INSERT_ID();
INSERT INTO medicine_dosage_package_type (`contained_quantity`, `medicine_dosage_type_id`, `package_type_id`)
VALUES
	('50', @medicineDosageTypeId, (SELECT `id` from `package_type` where `code` = 'CNT'));


/* Acetylsalicylic Acid Rectal Gel  */

INSERT INTO medicine (`name`, `description`, `barcode_prefix`, `active_ingredient`, `active_ingredient_nappy_code`, `schedule_status`)
VALUES
	('Acetylsalicylic Acid Rectal Gel', '', 'ARG', 'Acetylsalicylic Acid', '', 3);

INSERT INTO medicine_dosage_type (`default_price`, `additional_information`, `usage_instructions`, `storage_directions`, `special_instructions`, `dosage_strength`, `medicine_id`, `dosage_type_id`, `medicine_number`)
VALUES
	('0.623', 'Opaque gel', 'Use as directed by practitioner', 'None', 'None', '20% m/v', (SELECT `id` from `medicine` where `name` = 'Acetylsalicylic Acid Rectal Gel'), (SELECT `id` from `dosage_type` where `code` = 'GEL'), 'AARG-20');

SET @medicineDosageTypeId = LAST_INSERT_ID();
INSERT INTO medicine_dosage_package_type (`contained_quantity`, `medicine_dosage_type_id`, `package_type_id`)
VALUES
	('60', @medicineDosageTypeId, (SELECT `id` from `package_type` where `code` = 'SNG'));


/* Aminocaproic Acid  */

INSERT INTO medicine (`name`, `description`, `barcode_prefix`, `active_ingredient`, `active_ingredient_nappy_code`, `schedule_status`)
VALUES
	('Aminocaproic Acid', '', 'AMCA', 'Aminocaproic Acid', '', 0);

INSERT INTO medicine_dosage_type (`default_price`, `additional_information`, `usage_instructions`, `storage_directions`, `special_instructions`, `dosage_strength`, `medicine_id`, `dosage_type_id`, `medicine_number`)
VALUES
	('0', 'Capsule', 'Use as directed by practitioner', 'None', 'None', '500mg/capsule', (SELECT `id` from `medicine` where `name` = 'Aminocaproic Acid'), (SELECT `id` from `dosage_type` where `code` = 'CAP'), 'AA-500');

SET @medicineDosageTypeId = LAST_INSERT_ID();
INSERT INTO medicine_dosage_package_type (`contained_quantity`, `medicine_dosage_type_id`, `package_type_id`)
VALUES
	('100', @medicineDosageTypeId, (SELECT `id` from `package_type` where `code` = 'CNT'));

/* Amlodipine  */

INSERT INTO medicine (`name`, `description`, `barcode_prefix`, `active_ingredient`, `active_ingredient_nappy_code`, `schedule_status`)
VALUES
	('Amlodipine', '', 'AMLO', 'Amlodipine', '', 0);

INSERT INTO medicine_dosage_type (`default_price`, `additional_information`, `usage_instructions`, `storage_directions`, `special_instructions`, `dosage_strength`, `medicine_id`, `dosage_type_id`, `medicine_number`)
VALUES
	('0', 'White Suspension', 'Use as directed by practitioner', 'None', 'None', '3mg/ml', (SELECT `id` from `medicine` where `name` = 'Amlodipine'), (SELECT `id` from `dosage_type` where `code` = 'SUS'), 'AMLO-3');

SET @medicineDosageTypeId = LAST_INSERT_ID();
INSERT INTO medicine_dosage_package_type (`contained_quantity`, `medicine_dosage_type_id`, `package_type_id`)
VALUES
	('50', @medicineDosageTypeId, (SELECT `id` from `package_type` where `code` = 'BTL'));

/* Amphotericin  */

INSERT INTO medicine (`name`, `description`, `barcode_prefix`, `active_ingredient`, `active_ingredient_nappy_code`, `schedule_status`)
VALUES
	('Amphotericin', '', 'AMPH', 'Amphotericin-B', '', 0);

INSERT INTO medicine_dosage_type (`default_price`, `additional_information`, `usage_instructions`, `storage_directions`, `special_instructions`, `dosage_strength`, `medicine_id`, `dosage_type_id`, `medicine_number`)
VALUES
	('1.65', 'Yellow Suspension', 'Use as directed by practitioner', 'None', 'None', '5mg/ml', (SELECT `id` from `medicine` where `name` = 'Amphotericin'), (SELECT `id` from `dosage_type` where `code` = 'SUS'), 'AMPH-5');

SET @medicineDosageTypeId = LAST_INSERT_ID();
INSERT INTO medicine_dosage_package_type (`contained_quantity`, `medicine_dosage_type_id`, `package_type_id`)
VALUES
	('100', @medicineDosageTypeId, (SELECT `id` from `package_type` where `code` = 'BTL'));

INSERT INTO medicine_dosage_type (`default_price`, `additional_information`, `usage_instructions`, `storage_directions`, `special_instructions`, `dosage_strength`, `medicine_id`, `dosage_type_id`, `medicine_number`)
VALUES
	('0', 'Yellow Suspension', 'Use as directed by practitioner', 'None', 'None', '25mg/ml', (SELECT `id` from `medicine` where `name` = 'Amphotericin'), (SELECT `id` from `dosage_type` where `code` = 'SUS'), 'AMPH-25');

SET @medicineDosageTypeId = LAST_INSERT_ID();
INSERT INTO medicine_dosage_package_type (`contained_quantity`, `medicine_dosage_type_id`, `package_type_id`)
VALUES
	('100', @medicineDosageTypeId, (SELECT `id` from `package_type` where `code` = 'BTL'));

/* Amoxycilin Ear Drops  */

INSERT INTO medicine (`name`, `description`, `barcode_prefix`, `active_ingredient`, `active_ingredient_nappy_code`, `schedule_status`)
VALUES
	('Amoxycilin Ear Drops', '', 'AED', 'Amoxycilin', '', 0);

INSERT INTO medicine_dosage_type (`default_price`, `additional_information`, `usage_instructions`, `storage_directions`, `special_instructions`, `dosage_strength`, `medicine_id`, `dosage_type_id`, `medicine_number`)
VALUES
	('2.3375', 'Liquid', 'Use as directed by practitioner', 'None', 'None', 'N/A', (SELECT `id` from `medicine` where `name` = 'Amoxycilin Ear Drops'), (SELECT `id` from `dosage_type` where `code` = 'DRP'), 'AED-1');

SET @medicineDosageTypeId = LAST_INSERT_ID();
INSERT INTO medicine_dosage_package_type (`contained_quantity`, `medicine_dosage_type_id`, `package_type_id`)
VALUES
	('20', @medicineDosageTypeId, (SELECT `id` from `package_type` where `code` = 'DBTL'));

/* Arthrofocus Equine Powder  */

INSERT INTO medicine (`name`, `description`, `barcode_prefix`, `active_ingredient`, `active_ingredient_nappy_code`, `schedule_status`)
VALUES
	('Arthrofocus Equine Powder', '', 'AFEP', 'Misc', '', 0);

INSERT INTO medicine_dosage_type (`default_price`, `additional_information`, `usage_instructions`, `storage_directions`, `special_instructions`, `dosage_strength`, `medicine_id`, `dosage_type_id`, `medicine_number`)
VALUES
	('0', 'Powder', 'Use as directed by practitioner', 'None', 'None', 'N/A', (SELECT `id` from `medicine` where `name` = 'Arthrofocus Equine Powder'), (SELECT `id` from `dosage_type` where `code` = 'PWD'), 'AFEP-1');

SET @medicineDosageTypeId = LAST_INSERT_ID();
INSERT INTO medicine_dosage_package_type (`contained_quantity`, `medicine_dosage_type_id`, `package_type_id`)
VALUES
	('600', @medicineDosageTypeId, (SELECT `id` from `package_type` where `code` = 'CNT'));

/* ASU/HA  */

INSERT INTO medicine (`name`, `description`, `barcode_prefix`, `active_ingredient`, `active_ingredient_nappy_code`, `schedule_status`)
VALUES
	('ASU/HA', '', 'ASUHA', 'Avocado Soybean Unsaponifiables,Hyaluronic Acid', '', 2);

INSERT INTO medicine_dosage_type (`default_price`, `additional_information`, `usage_instructions`, `storage_directions`, `special_instructions`, `dosage_strength`, `medicine_id`, `dosage_type_id`, `medicine_number`)
VALUES
	('1.65', 'White Capsules', 'Use as directed by practitioner', 'None', 'None', 'N/A', (SELECT `id` from `medicine` where `name` = 'ASU/HA'), (SELECT `id` from `dosage_type` where `code` = 'CAP'), 'ASUHA-1');

SET @medicineDosageTypeId = LAST_INSERT_ID();
INSERT INTO medicine_dosage_package_type (`contained_quantity`, `medicine_dosage_type_id`, `package_type_id`)
VALUES
	('100', @medicineDosageTypeId, (SELECT `id` from `package_type` where `code` = 'CNT'));

/* Atenolol  */

INSERT INTO medicine (`name`, `description`, `barcode_prefix`, `active_ingredient`, `active_ingredient_nappy_code`, `schedule_status`)
VALUES
	('Atenolol', '', 'ATEN', 'Atenolol', '', 0);

INSERT INTO medicine_dosage_type (`default_price`, `additional_information`, `usage_instructions`, `storage_directions`, `special_instructions`, `dosage_strength`, `medicine_id`, `dosage_type_id`, `medicine_number`)
VALUES
	('2.75', 'White Suspension', 'Use as directed by practitioner', 'None', 'None', '5mg/ml', (SELECT `id` from `medicine` where `name` = 'Atenolol'), (SELECT `id` from `dosage_type` where `code` = 'SUS'), 'ATEN-5');

SET @medicineDosageTypeId = LAST_INSERT_ID();
INSERT INTO medicine_dosage_package_type (`contained_quantity`, `medicine_dosage_type_id`, `package_type_id`)
VALUES
	('30', @medicineDosageTypeId, (SELECT `id` from `package_type` where `code` = 'BTL'));

/* Benazepril  */

INSERT INTO medicine (`name`, `description`, `barcode_prefix`, `active_ingredient`, `active_ingredient_nappy_code`, `schedule_status`)
VALUES
	('Benazepril', '', 'BEZE', 'Benazepril Hydrochloride', '', 0);

INSERT INTO medicine_dosage_type (`default_price`, `additional_information`, `usage_instructions`, `storage_directions`, `special_instructions`, `dosage_strength`, `medicine_id`, `dosage_type_id`, `medicine_number`)
VALUES
	('2.31', 'White Flat Tablets', 'Use as directed by practitioner', 'None', 'None', '20mg/tablet', (SELECT `id` from `medicine` where `name` = 'Benazepril'), (SELECT `id` from `dosage_type` where `code` = 'TBT'), 'BEZE-20');

SET @medicineDosageTypeId = LAST_INSERT_ID();
INSERT INTO medicine_dosage_package_type (`contained_quantity`, `medicine_dosage_type_id`, `package_type_id`)
VALUES
	('100', @medicineDosageTypeId, (SELECT `id` from `package_type` where `code` = 'CNT'));

INSERT INTO medicine_dosage_type (`default_price`, `additional_information`, `usage_instructions`, `storage_directions`, `special_instructions`, `dosage_strength`, `medicine_id`, `dosage_type_id`, `medicine_number`)
VALUES
	('2.09', 'White Cross Scored Tablets', 'Use as directed by practitioner', 'None', 'None', '5mg/tablet', (SELECT `id` from `medicine` where `name` = 'Benazepril'), (SELECT `id` from `dosage_type` where `code` = 'TBT'), 'BEZE-5');

SET @medicineDosageTypeId = LAST_INSERT_ID();
INSERT INTO medicine_dosage_package_type (`contained_quantity`, `medicine_dosage_type_id`, `package_type_id`)
VALUES
	('100', @medicineDosageTypeId, (SELECT `id` from `package_type` where `code` = 'CNT'));

/* Benazepril & Furosemide  */

INSERT INTO medicine (`name`, `description`, `barcode_prefix`, `active_ingredient`, `active_ingredient_nappy_code`, `schedule_status`)
VALUES
	('Benazepril & Furosemide', '', 'BEFU', 'Benazepril Hydrochloride,Furosemide', '', 0);

INSERT INTO medicine_dosage_type (`default_price`, `additional_information`, `usage_instructions`, `storage_directions`, `special_instructions`, `dosage_strength`, `medicine_id`, `dosage_type_id`, `medicine_number`)
VALUES
	('3.025', 'White Cross Scored Tablets', 'Use as directed by practitioner', 'None', 'None', '20mg/80mg per tablet', (SELECT `id` from `medicine` where `name` = 'Benazepril & Furosemide'), (SELECT `id` from `dosage_type` where `code` = 'TBT'), 'BEFU-20-80');

SET @medicineDosageTypeId = LAST_INSERT_ID();
INSERT INTO medicine_dosage_package_type (`contained_quantity`, `medicine_dosage_type_id`, `package_type_id`)
VALUES
	('100', @medicineDosageTypeId, (SELECT `id` from `package_type` where `code` = 'CNT'));

INSERT INTO medicine_dosage_type (`default_price`, `additional_information`, `usage_instructions`, `storage_directions`, `special_instructions`, `dosage_strength`, `medicine_id`, `dosage_type_id`, `medicine_number`)
VALUES
	('5', 'White Suspension', 'Use as directed by practitioner', 'None', 'None', '2.5mg/10mg', (SELECT `id` from `medicine` where `name` = 'Benazepril & Furosemide'), (SELECT `id` from `dosage_type` where `code` = 'SUS'), 'BEFU-2.5-10');

SET @medicineDosageTypeId = LAST_INSERT_ID();
INSERT INTO medicine_dosage_package_type (`contained_quantity`, `medicine_dosage_type_id`, `package_type_id`)
VALUES
	('30', @medicineDosageTypeId, (SELECT `id` from `package_type` where `code` = 'BTL'));

/* Bromhexine  */

INSERT INTO medicine (`name`, `description`, `barcode_prefix`, `active_ingredient`, `active_ingredient_nappy_code`, `schedule_status`)
VALUES
	('Bromhexine', '', 'BRHX', 'Bromhexine', '', 0);

INSERT INTO medicine_dosage_type (`default_price`, `additional_information`, `usage_instructions`, `storage_directions`, `special_instructions`, `dosage_strength`, `medicine_id`, `dosage_type_id`, `medicine_number`)
VALUES
	('0.4125', 'White Powder', 'Use as directed by practitioner', 'None', 'None', '1%', (SELECT `id` from `medicine` where `name` = 'Bromhexine'), (SELECT `id` from `dosage_type` where `code` = 'PWD'), 'BRHX-1');

SET @medicineDosageTypeId = LAST_INSERT_ID();
INSERT INTO medicine_dosage_package_type (`contained_quantity`, `medicine_dosage_type_id`, `package_type_id`)
VALUES
	('100', @medicineDosageTypeId, (SELECT `id` from `package_type` where `code` = 'CNT'));

INSERT INTO medicine_dosage_type (`default_price`, `additional_information`, `usage_instructions`, `storage_directions`, `special_instructions`, `dosage_strength`, `medicine_id`, `dosage_type_id`, `medicine_number`)
VALUES
	('0.861', 'White Suspension', 'Use as directed by practitioner', 'None', 'None', '20mg/ml', (SELECT `id` from `medicine` where `name` = 'Bromhexine'), (SELECT `id` from `dosage_type` where `code` = 'SUS'), 'BRHX-20');

SET @medicineDosageTypeId = LAST_INSERT_ID();
INSERT INTO medicine_dosage_package_type (`contained_quantity`, `medicine_dosage_type_id`, `package_type_id`)
VALUES
	('30', @medicineDosageTypeId, (SELECT `id` from `package_type` where `code` = 'BTL'));

SET @medicineDosageTypeId = LAST_INSERT_ID();
INSERT INTO medicine_dosage_package_type (`contained_quantity`, `medicine_dosage_type_id`, `package_type_id`)
VALUES
	('100', @medicineDosageTypeId, (SELECT `id` from `package_type` where `code` = 'BTL'));

INSERT INTO medicine_dosage_type (`default_price`, `additional_information`, `usage_instructions`, `storage_directions`, `special_instructions`, `dosage_strength`, `medicine_id`, `dosage_type_id`, `medicine_number`)
VALUES
	('1.881', 'White Cross Scored Tablets', 'Use as directed by practitioner', 'None', 'None', '25mg/tablet', (SELECT `id` from `medicine` where `name` = 'Bromhexine'), (SELECT `id` from `dosage_type` where `code` = 'TBT'), 'BRHX-25');

SET @medicineDosageTypeId = LAST_INSERT_ID();
INSERT INTO medicine_dosage_package_type (`contained_quantity`, `medicine_dosage_type_id`, `package_type_id`)
VALUES
	('100', @medicineDosageTypeId, (SELECT `id` from `package_type` where `code` = 'CNT'));

INSERT INTO medicine_dosage_type (`default_price`, `additional_information`, `usage_instructions`, `storage_directions`, `special_instructions`, `dosage_strength`, `medicine_id`, `dosage_type_id`, `medicine_number`)
VALUES
	('0.792', 'Light Brown Cross Scored Tablets', 'Use as directed by practitioner', 'None', 'None', '5mg/tablet', (SELECT `id` from `medicine` where `name` = 'Bromhexine'), (SELECT `id` from `dosage_type` where `code` = 'TBT'), 'BRHX-5');

SET @medicineDosageTypeId = LAST_INSERT_ID();
INSERT INTO medicine_dosage_package_type (`contained_quantity`, `medicine_dosage_type_id`, `package_type_id`)
VALUES
	('100', @medicineDosageTypeId, (SELECT `id` from `package_type` where `code` = 'CNT'));

INSERT INTO medicine_dosage_type (`default_price`, `additional_information`, `usage_instructions`, `storage_directions`, `special_instructions`, `dosage_strength`, `medicine_id`, `dosage_type_id`, `medicine_number`)
VALUES
	('0', 'Off White Cross Scored Tablets', 'Use as directed by practitioner', 'None', 'None', '75mg/tablet', (SELECT `id` from `medicine` where `name` = 'Bromhexine'), (SELECT `id` from `dosage_type` where `code` = 'TBT'), 'BRHX-75');

SET @medicineDosageTypeId = LAST_INSERT_ID();
INSERT INTO medicine_dosage_package_type (`contained_quantity`, `medicine_dosage_type_id`, `package_type_id`)
VALUES
	('50', @medicineDosageTypeId, (SELECT `id` from `package_type` where `code` = 'CNT'));


/* Budesonide */

INSERT INTO medicine (`name`, `description`, `barcode_prefix`, `active_ingredient`, `active_ingredient_nappy_code`, `schedule_status`)
VALUES
	('Budesonide', '', 'BUDE', 'Budesonide', '', 0);

INSERT INTO medicine_dosage_type (`default_price`, `additional_information`, `usage_instructions`, `storage_directions`, `special_instructions`, `dosage_strength`, `medicine_id`, `dosage_type_id`, `medicine_number`)
VALUES
	('2.068', 'Small White Tablets with Blue Spots', 'Use as directed by practitioner', 'None', 'None', '1mg/tablet', (SELECT `id` from `medicine` where `name` = 'Budesonide'), (SELECT `id` from `dosage_type` where `code` = 'TBT'), 'BUDE-1');

SET @medicineDosageTypeId = LAST_INSERT_ID();
INSERT INTO medicine_dosage_package_type (`contained_quantity`, `medicine_dosage_type_id`, `package_type_id`)
VALUES
	('100', @medicineDosageTypeId, (SELECT `id` from `package_type` where `code` = 'CNT'));

INSERT INTO medicine_dosage_type (`default_price`, `additional_information`, `usage_instructions`, `storage_directions`, `special_instructions`, `dosage_strength`, `medicine_id`, `dosage_type_id`, `medicine_number`)
VALUES
	('3.446', 'Suspension', 'Use as directed by practitioner', 'None', 'None', '1mg/ml', (SELECT `id` from `medicine` where `name` = 'Budesonide'), (SELECT `id` from `dosage_type` where `code` = 'SUS'), 'BUDE-1ml');

SET @medicineDosageTypeId = LAST_INSERT_ID();
INSERT INTO medicine_dosage_package_type (`contained_quantity`, `medicine_dosage_type_id`, `package_type_id`)
VALUES
	('30', @medicineDosageTypeId, (SELECT `id` from `package_type` where `code` = 'BTL'));

INSERT INTO medicine_dosage_type (`default_price`, `additional_information`, `usage_instructions`, `storage_directions`, `special_instructions`, `dosage_strength`, `medicine_id`, `dosage_type_id`, `medicine_number`)
VALUES
	('8.25', 'Suspension', 'Use as directed by practitioner', 'None', 'None', '15mg/ml', (SELECT `id` from `medicine` where `name` = 'Budesonide'), (SELECT `id` from `dosage_type` where `code` = 'SUS'), 'BUDE-15');

SET @medicineDosageTypeId = LAST_INSERT_ID();
INSERT INTO medicine_dosage_package_type (`contained_quantity`, `medicine_dosage_type_id`, `package_type_id`)
VALUES
	('60', @medicineDosageTypeId, (SELECT `id` from `package_type` where `code` = 'BTL'));