CREATE TABLE `libmags` (
  `mid` INT(11) NOT NULL AUTO_INCREMENT COMMENT 'Magazine ID',
  `class` CHAR(9) NOT NULL COMMENT 'журнал/газета',
  `title` VARCHAR(254) NOT NULL,
  `firstyear` INT(11) NOT NULL,
  `lastyear` INT(11) NOT NULL,
  `peryear` INT(11) NOT NULL DEFAULT '12',
  PRIMARY KEY (`mid`),
  UNIQUE KEY `title` (`title`),
  KEY `class` (`class`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;