CREATE TABLE IF NOT EXISTS `newspaper_kat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `newspaper_paper` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `kat` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `text` mediumtext NOT NULL,
  `us` int(11) NOT NULL,
  `time` int(11) NOT NULL,
  `kolvo` int(11) NOT NULL DEFAULT '0',
  `scrin` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `newspaper_zaklad` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `paper` int(11) NOT NULL,
  `us` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
