Mariadb 分表，mariadb分表

Mariadb 分表，mariadb分表

CREATE TABLE `tablename` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL,
  `to_message_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `to_user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `news_id` int(10) UNSIGNED NOT NULL,
  `message` text NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MERGE union=(tablename_message1s,tablename_message2s,tablename_message3s,tablename_message4s,tablename_message5s,tablename_message6s,tablename_message7s,tablename_message8s,tablename_message9s,tablename_message10s) INSERT_METHOD=LAST DEFAULT CHARSET=utf8;

ALTER TABLE `tablename`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `tablename`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;