CREATE TABLE `spr_medicament`(  
  `id` INT NOT NULL AUTO_INCREMENT,
  `tnshort_id` INT NOT NULL,
  `drugforma_id` INT NOT NULL,
  `alias` VARCHAR(500) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `idx_tnshort_form` (`tnshort_id`, `drugforma_id`)
) CHARSET=utf8 COLLATE=utf8_general_ci;

CREATE TABLE `spr_description` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `medicament_id` int(11) NOT NULL,
  `description` text COMMENT 'Состав согласно официальной инструкции',
  `composition` text COMMENT 'Состав',
  `short_description` varchar(2000) DEFAULT NULL,
  `testimony` text COMMENT 'Показания',
  `carefully` text COMMENT 'С осторожностью',
  `contraindications` text COMMENT 'Противопоказания',
  `storage` text,
  `newborns` tinyint(4) DEFAULT NULL,
  `baby3month` tinyint(4) DEFAULT NULL,
  `baby6month` tinyint(4) DEFAULT NULL,
  `baby9month` tinyint(4) DEFAULT NULL,
  `baby12month` tinyint(4) DEFAULT NULL,
  `baby3year` tinyint(4) DEFAULT NULL,
  `baby6year` tinyint(4) DEFAULT NULL,
  `baby10year` tinyint(4) DEFAULT NULL,
  `baby12year` tinyint(4) DEFAULT NULL,
  `baby14year` tinyint(4) DEFAULT NULL,
  `baby18year` tinyint(4) DEFAULT NULL,
  `grand60year` tinyint(4) DEFAULT NULL,
  `pregnancy` tinyint(4) DEFAULT NULL,
  `lactation` tinyint(4) DEFAULT NULL,
  `liver_disease` tinyint(4) DEFAULT NULL,
  `kidney_disease` tinyint(4) DEFAULT NULL,
  `diabetes` tinyint(4) DEFAULT NULL,
  `transport_management` tinyint(4) DEFAULT NULL,
  `bronchial_asthma` tinyint(4) DEFAULT NULL,
  `children` tinyint(1) DEFAULT '0',
  `adult` tinyint(1) DEFAULT '0',
  `oldman` tinyint(1) DEFAULT '0',
  `editstatus` tinyint(4) NOT NULL DEFAULT '1',
  `state` tinyint(1) NOT NULL DEFAULT '0',
  `pregnan` longtext,
  `transp` longtext,
  `qtt` longtext,
  `coop` longtext,
  `addef` longtext,
  `warn` longtext,
  `overdose` longtext,
  `geotar_datelastdocument` datetime DEFAULT NULL,
  `maction` longtext,
  `pharkin` longtext,
  `datelastedit` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;