-- ----------------------------- -- 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');