MySql（二十八）--水平分表代码实现

 

DROP TABLE IF EXISTS `tbl_servers`;
CREATE TABLE `tbl_servers` (
  `uuid` int(11) NOT NULL AUTO_INCREMENT,
  `sid` varchar(10) NOT NULL,
  `ip` varchar(20) NOT NULL,
  `port` int(11) NOT NULL,
  `isMain` int(11) NOT NULL,
  `canRead` int(11) NOT NULL,
  `canWrite` int(11) NOT NULL,
  `state` varchar(20) NOT NULL,
  `equalsServers` varchar(100) NOT NULL,
  PRIMARY KEY (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `tbl_shards`;
CREATE TABLE `tbl_shards` (
  `uuid` int(11) NOT NULL AUTO_INCREMENT,
  `tblName` varchar(100) NOT NULL,
  `idBegin` int(11) NOT NULL,
  `idEnd` int(11) NOT NULL,
  `groupId` varchar(20) NOT NULL,
  `modNum` int(11) NOT NULL,
  PRIMARY KEY (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

DROP TABLE IF EXISTS `tbl_sharddetails`;
CREATE TABLE `tbl_sharddetails` (
  `uuid` int(11) NOT NULL AUTO_INCREMENT,
  `groupId` varchar(100) NOT NULL,
  `serverUuid` int(11) NOT NULL,
  `idBegin` int(11) NOT NULL,
  `idEnd` int(11) NOT NULL,
  `modValue` varchar(100) NOT NULL,
  `shardTblName` varchar(100) NOT NULL,
  PRIMARY KEY (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;