sql command.txt

CREATE SCHEMA `medikschema` ;

CREATE TABLE `medikschema`.`meditable` (
  `idmeditable` INT NOT NULL AUTO_INCREMENT,
  `nameMedi` VARCHAR(50) NOT NULL,
  `useMedi` VARCHAR(200) NOT NULL,
  `introMedi` VARCHAR(500) NOT NULL,
  `warnMedi` VARCHAR(400) NOT NULL,
  `takeMedi` VARCHAR(400) NOT NULL,
  `sideEffectMedi` VARCHAR(450) NOT NULL,
  `ifMissMedi` VARCHAR(300) NOT NULL,
  PRIMARY KEY (`idmeditable`),
  UNIQUE INDEX `idmeditable_UNIQUE` (`idmeditable` ASC) VISIBLE,
  UNIQUE INDEX `nameMedi_UNIQUE` (`nameMedi` ASC) VISIBLE);


INSERT INTO `medikschema`.`meditable` (`idmeditable`, `nameMedi`, `useMedi`, `introMedi`, `warnMedi`, `takeMedi`, `sideEffectMedi`, `ifMissMedi`) VALUES ('1', '1-Day', 'used to treat vaginal Candida (yeast) infections', 'Tioconazole is an antifungal medication that fights infections caused by fungus. 1-Day (for use in the vagina) is used to treat vaginal Candida (yeast) infections.', 'Follow all directions on your medicine label and package. Tell each of your healthcare providers about all your medical conditions, allergies, and all medicines you use.', 'This medicine is usually given as a single dose. You should notice some improvement in your symptoms after the 1-day treatment. It may take up to 7 days after using the 1-day dose before your symptoms go away completely.', 'signs of an allergic reaction: hives, difficult breathing, swelling of your face, lips, tongue, or throat. Call your doctor at once if you have new or worsening vaginal symptoms.', 'Since 1-Day is used as a single dose, it does not have a daily dosing schedule.');

INSERT INTO `medikschema`.`meditable` (`nameMedi`, `useMedi`, `introMedi`, `warnMedi`, `takeMedi`, `sideEffectMedi`, `ifMissMedi`) VALUES ('12 Hour Nasal', 'used for temporary relief of congestion in the nose caused by various conditions including the common cold, sinusitis, hay fever, and allergies', 'Oxymetazoline is a decongestant that shrinks blood vessels in the nasal passages. Dilated blood vessels can cause nasal congestion (stuffy nose). 12 Hour Nasal (for the nose) is for temporary relief of nasal congestion (stuffy nose) caused by allergies or the common cold.', 'Stop using 12 Hour Nasal and call your doctor at once if you have ongoing or worsening symptoms, or if you have severe burning or stinging in your nose after using the nasal spray', 'Use exactly as directed on the label, or as prescribed by your doctor.  Using the medication too long or too often may worsen your symptoms or cause nasal congestion to clear up and come back. Call your doctor if your symptoms do not improve after 3 days of treatment.', 'ongoing or worsening symptoms; severe burning or stinging in your nose after using the nasal spray; chest pain, fast or uneven heart rate; or severe headache, buzzing in your ears, anxiety, confusion, or feeling short of breath.', 'Use the missed dose as soon as you remember. Skip the missed dose if it is almost time for your next scheduled dose. Do not use extra medicine to make up the missed dose.');

INSERT INTO `medikschema`.`meditable` (`nameMedi`, `useMedi`, `introMedi`, `warnMedi`, `takeMedi`, `sideEffectMedi`, `ifMissMedi`) VALUES ('2 in 1 Dandruff', 'used to help control the symptoms of dandruff and seborrheic dermatitis of the scalp.', 'the Head and Shoulders, 2-in-1 range is specially formulated to have all the dandruff fighting power you expect, while combining the benefits of both shampoo and conditioner in one bottle.', 'In deciding to use a medicine, the risks of taking the medicine must be weighed against the good it will do. This is a decision you and your doctor will make.', 'Before applying this shampoo, wet the hair and scalp with lukewarm water. Apply enough shampoo to the scalp to work up a lather and rub in well, then rinse. Apply the shampoo again and rinse thoroughly.', 'Irritation of skin and Other side effects may also occur in some patients. If you notice any other effects, check with your healthcare professional.', 'If you miss a dose of this medicine, take it as soon as possible. However, if it is almost time for your next dose, skip the missed dose and go back to your regular dosing schedule. Do not double doses.');

INSERT INTO `medikschema`.`meditable` (`nameMedi`, `useMedi`, `introMedi`, `warnMedi`, `takeMedi`, `sideEffectMedi`, `ifMissMedi`) VALUES ('3M Skin and Nasal Antiseptic', 'used on the skin to treat or prevent skin infection in minor cuts, scrapes, or burns.', '3M Skin and Nasal Antiseptic is also used in a medical setting to help prevent infection and promote healing in skin wounds, pressure sores, or surgical incisions. Some forms of povidone iodine topical are used inside the mouth to provide temporary relief of minor mouth pain or irritation, sore throat, or canker sore pain.', 'Use exactly as directed on the label, or as prescribed by your doctor.', '3M Skin and Nasal Antiseptic is usually applied to the skin as needed. First clean the area to be treated. Shake 3M Skin and Nasal Antiseptic spray well just before each use. Allow the medicine to dry completely on the skin before applying a bandage. Do not apply a tight bandage.', 'swelling, pain, warmth, redness, oozing, or other signs of infection; blistering or crusting; or severe irritation, itching, or burning.', 'Skip the missed dose and use your next dose at the regular time. Do not use two doses at one time.');

INSERT INTO `medikschema`.`meditable` (`nameMedi`, `useMedi`, `introMedi`, `warnMedi`, `takeMedi`, `sideEffectMedi`, `ifMissMedi`) VALUES ('4-Way', 'used to treat nasal congestion and sinus pressure', 'Phenylephrine is a decongestant that shrinks blood vessels in the nasal passages. Dilated blood vessels can cause nasal congestion (stuffy nose). 4-Way is used to treat nasal congestion and sinus pressure caused by allergies, the common cold, or the flu. Phenylephrine may be used to treat congestion of the tubes that drain fluid from your inner ears, called the eustachian (yoo-STAY-shun) tubes.', 'Do not use 4-Way if you have used an MAO inhibitor in the past 14 days, such as isocarboxazid, linezolid, methylene blue injection, phenelzine, rasagiline, selegiline, or tranylcypromine.', 'Blow your nose gently. Keep your head upright and insert the tip of the bottle into one nostril. Press your other nostril closed with your finger. Then use the spray in your other nostril. Do not blow your nose for at least a few minutes after using the nasal spray. If the nasal spray has not been used for longer than 24 hours, prime it by spraying 1 or 2 times into a tissue.', 'severe sneezing, runny or stuffy nose, redness or swelling in your nose, or other worsening nasal symptoms (may be a sign of overuse of 4-Way), severe stinging, burning, or irritation inside your nose, severe dizziness, restless feeling, nervousness, or insomnia, mood changes, unusual thoughts or behavior, tremors or shaking', 'Since 4-Way is used when needed, you may not be on a dosing schedule. If you are on a schedule, use the missed dose as soon as you remember. Skip the missed dose if it is almost time for your next scheduled dose. Do not use extra medicine to make up the missed dose.');

INSERT INTO `medikschema`.`meditable` (`nameMedi`, `useMedi`, `introMedi`, `warnMedi`, `takeMedi`, `sideEffectMedi`, `ifMissMedi`) VALUES ('5 Benzagel Acne', 'used to treat acne and may be used for other skin conditions as determined by your doctor.', 'This medication is used to treat mild to moderate acne. It may be used in combination with other acne treatments. When applied to the skin, benzoyl peroxide works by reducing the amount of acne-causing bacteria and by causing the skin to dry and peel.Check the ingredients on the label even if you have used the product before. The manufacturer may have changed the ingredients. ', 'Tell your doctor if you have ever had any unusual or allergic reaction to this medicine or any other medicines. Also tell your health care professional if you have any other types of allergies, such as to foods, dyes, preservatives, or animals. For non-prescription products, read the label or package ingredients carefully.', 'This medicine is for use only on the skin. Do not use this medicine in or around the eyes or lips, or inside the nose, or on sensitive areas of the neck. Spread the medicine away from these areas when applying. If the medicine gets on these areas, wash with water at once. Do not use more of it and do not use it more often than recommended on the label.', 'Painful irritation of skin, including burning, blistering, crusting, itching, severe redness, or swelling and skin rash', 'If you miss a dose of this medicine, apply it as soon as possible. However, if it is almost time for your next dose, skip the missed dose and go back to your regular dosing schedule.');

and insert rest of the medicine info to the database....