| 1234567891011121314151617181920212223242526272829303132333435363738394041 |
- -- -----------------------------
- -- Think MySQL Data Transfer
- --
- -- Host : 192.168.2.186
- -- Port : 3306
- -- Database : ds_cms
- --
- -- Part : #1
- -- Date : 2019-06-10 10:51:24
- -- -----------------------------
- SET FOREIGN_KEY_CHECKS = 0;
- -- -----------------------------
- -- Table structure for `bm_admin`
- -- -----------------------------
- DROP TABLE IF EXISTS `bm_admin`;
- CREATE TABLE `bm_admin` (
- `admin_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '管理员自增ID',
- `admin_name` varchar(20) NOT NULL COMMENT '管理员名称',
- `admin_password` varchar(32) NOT NULL COMMENT '管理员密码',
- `admin_add_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
- `admin_login_time` int(11) NOT NULL COMMENT '登录时间',
- `admin_login_num` int(11) NOT NULL COMMENT '登录次数',
- `admin_is_super` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否超级管理员',
- `admin_group_id` smallint(6) DEFAULT '0' COMMENT '权限组ID',
- `admin_pid` int(11) DEFAULT '0' COMMENT 'pid',
- `admin_status` tinyint(1) DEFAULT '1' COMMENT '状态1-是0否',
- PRIMARY KEY (`admin_id`)
- ) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=utf8 COMMENT='管理员表';
- -- -----------------------------
- -- Records of `bm_admin`
- -- -----------------------------
- INSERT INTO `bm_admin` VALUES ('1', 'admin', '7fef6171469e80d32c0559f88b377245', '0', '1560134914', '98', '1', '1', '', '1');
- INSERT INTO `bm_admin` VALUES ('2', 'dacheng', '7fef6171469e80d32c0559f88b377245', '1546416864', '1548230143', '10', '0', '3', '3', '1');
- INSERT INTO `bm_admin` VALUES ('3', '麦邦公司', '7fef6171469e80d32c0559f88b377245', '1546481266', '1548917242', '11', '0', '2', '0', '1');
- INSERT INTO `bm_admin` VALUES ('4', '帮麦公司', '7fef6171469e80d32c0559f88b377245', '1546824903', '1549871629', '3', '0', '2', '0', '1');
- INSERT INTO `bm_admin` VALUES ('19', '客服001', '7fef6171469e80d32c0559f88b377245', '0', '1551234292', '10', '0', '3', '4', '1');
- INSERT INTO `bm_admin` VALUES ('21', '测试公司', '7fef6171469e80d32c0559f88b377245', '1548315143', '1550130475', '2', '0', '2', '0', '1');
|