CREATE TABLE `app_errors` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `time` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `message` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `exception` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `address` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `application` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `state` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `version` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `release_date` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `method` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `unit` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `line_number` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `remote_addr` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `remote_host` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `url` text CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

CREATE TABLE `projekty` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `description` text CHARACTER SET utf8 NOT NULL,
  `link` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `image` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `finished` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
