DopBan by Mazdan

-- ----------------------------
-- Table structure for `db_bancookie`
-- ----------------------------
DROP TABLE IF EXISTS `db_bancookie`;
CREATE TABLE `db_bancookie` (
  `serv` varchar(34) NOT NULL,
  `ident` varchar(64) NOT NULL,
  `bid` int(9) NOT NULL,
  `ts` int(16) NOT NULL,
  UNIQUE KEY `serv` (`serv`,`ident`,`bid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for `db_dyncookie`
-- ----------------------------
DROP TABLE IF EXISTS `db_dyncookie`;
CREATE TABLE `db_dyncookie` (
  `server` varchar(34) NOT NULL,
  `id` int(3) NOT NULL,
  `uid` int(9) NOT NULL,
  `ip` varchar(16) NOT NULL,
  `ident` varchar(64) NOT NULL,
  `identid` int(3) NOT NULL DEFAULT '0',
  `servertime` int(16) NOT NULL,
  `serversign` varchar(34) NOT NULL,
  `ts` int(16) NOT NULL,
  PRIMARY KEY (`server`,`id`,`identid`),
  KEY `serversign` (`serversign`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for `db_dyncookie2`
-- ----------------------------
DROP TABLE IF EXISTS `db_dyncookie2`;
CREATE TABLE `db_dyncookie2` (
  `server` varchar(34) NOT NULL,
  `id` int(3) NOT NULL,
  `uid` int(9) NOT NULL,
  `ip` varchar(16) NOT NULL,
  `ident` varchar(64) NOT NULL,
  `servertime` int(16) NOT NULL,
  `serversign` varchar(34) NOT NULL,
  `ts` int(16) NOT NULL,
  PRIMARY KEY (`server`,`id`),
  KEY `serversign` (`serversign`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;