DROP TABLE IF EXISTS `guest`;

CREATE TABLE `guest` (

  `id`         INT(10) UNSIGNED    NOT NULL AUTO_INCREMENT,

  `adm`        TINYINT(1)          NOT NULL DEFAULT '0',

  `time`       INT(10) UNSIGNED    NOT NULL DEFAULT '0',

  `user_id`    INT(10) UNSIGNED    NOT NULL DEFAULT '0',

  `name`       VARCHAR(25)         NOT NULL DEFAULT '',

  `text`       TEXT                NOT NULL,

  `ip`         BIGINT(11)          NOT NULL DEFAULT '0',

  `browser`    TINYTEXT            NOT NULL,

  `admin`      VARCHAR(25)         NOT NULL DEFAULT '',

  `otvet`      TEXT                NOT NULL,

  `otime`      INT(10) UNSIGNED    NOT NULL DEFAULT '0',

  `edit_who`   VARCHAR(20)         NOT NULL DEFAULT '',

  `edit_time`  INT(10) UNSIGNED    NOT NULL DEFAULT '0',

  `edit_count` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',

  PRIMARY KEY (`id`),

  KEY `time` (`time`),

  KEY `ip` (`ip`),

  KEY `adm` (`adm`)

)

  ENGINE = MyISAM

  DEFAULT CHARSET = utf8mb4;