CREATE TABLE IF NOT EXISTS `mappoint` (
  `id` int(11) NOT NULL auto_increment,
  `town` varchar(255) NOT NULL,
  `type` varchar(100) NOT NULL,
  `mesto` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `adress` varchar(255) NOT NULL,
  `tags` varchar(255) NOT NULL,
  `cx` varchar(10) NOT NULL,
  `cy` varchar(10) NOT NULL,
  `user` varchar(255) NOT NULL,
  `view` int(2) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;

ALTER TABLE `topics` ADD `topic_undercut` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;

CREATE TABLE IF NOT EXISTS `files` (
`file_id` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
`file_name` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
`file_create_time` DATETIME NOT NULL ,
`file_size` INT( 11 ) UNSIGNED NOT NULL ,
`file_md5` VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`user_id` INT( 10 ) UNSIGNED NOT NULL ,
PRIMARY KEY ( `file_id` )
) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE `files` ADD UNIQUE (
`file_md5`
)