
CREATE TABLE IF NOT EXISTS `black_admin` (
  `uid` int(11) NOT NULL,
  `user` varchar(150) NOT NULL,
  `pass` varchar(150) NOT NULL,
  `last` datetime NOT NULL,
  `dlip` varchar(15) DEFAULT NULL,
  `active` int(1) DEFAULT NULL
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

INSERT INTO `black_admin` (`uid`, `user`, `pass`, `last`, `dlip`, `active`) VALUES
(1, 'admin', 'e10adc3949ba59abbe56e057f20f883e', '2020-08-29 20:07:38', '222.209.251.240', 1);


CREATE TABLE IF NOT EXISTS `black_config` (
  `k` varchar(255) NOT NULL DEFAULT '',
  `v` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


INSERT INTO `black_config` (`k`, `v`) VALUES
('sitename', '流量卡单号查询系统'),
('keywords', '流量卡,商家,运单号,物流信息,物流查询,顺丰,韵达'),
('description', '一个给流量卡商家提供客户查询系统网站！'),
('gonggao', '欢迎来到南国流量卡发货运单号查询平台！'),
('admin_qq', '918832149'),
('music', '5f48eff36a992');

CREATE TABLE IF NOT EXISTS `black_list` (
  `id` int(11) NOT NULL,
  `qq` text,
  `level` text NOT NULL,
  `date` datetime NOT NULL,
  `note` text COMMENT '快递单号'
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

ALTER TABLE `black_admin`
  ADD PRIMARY KEY (`uid`);

ALTER TABLE `black_config`
  ADD PRIMARY KEY (`k`(10));

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

ALTER TABLE `black_admin`
  MODIFY `uid` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;

ALTER TABLE `black_list`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;