20190610-105124-1.sql 2.0 KB

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