create_table.SQL

CREATE TABLE IF NOT EXISTS `BNoteBot_memo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userID` int(11) NOT NULL,
  `type` text,
  `memo` text,
  `file_id` text,
  `duration` int(11) NOT NULL DEFAULT '0',
  `timestamp` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `memo` (`memo`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 ;

CREATE TABLE IF NOT EXISTS `BNoteBot_reminder` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userID` int(11) NOT NULL,
  `memoid` int(11) NOT NULL,
  `timestamp` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 ;

CREATE TABLE IF NOT EXISTS `BNoteBot_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userID` text,
  `username` text,
  `name` text,
  `status` text,
  `lang` text,
  `invertmemodata` int(1) NOT NULL DEFAULT '0',
  `justwritemode` tinyint(1) NOT NULL DEFAULT '1',
  `timezone` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8mb4 ;

CREATE TABLE IF NOT EXISTS `BNoteBot_sentinline` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `memo_id` int(11) NOT NULL,
  `msg_id` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 ;