company_user 1.4 KB

1234567891011121314151617181920212223
  1. <?php return array (
  2. 'time' => 1449933070,
  3. 'table' => 'company_user',
  4. 'create' => 'DROP TABLE IF EXISTS `company_user`;CREATE TABLE `company_user`(`id` INT(11) UNSIGNED AUTO_INCREMENT PRIMARY KEY NOT NULL COMMENT \'用户ID\',`company` INT(11) NOT NULL DEFAULT 0 COMMENT \'所属公司\',`username` VARCHAR(80) NOT NULL DEFAULT \'\' COMMENT \'用户名\',`auth` VARCHAR(500) NOT NULL DEFAULT \'\' COMMENT \'园区权限设置\',`nickname` VARCHAR(50) NOT NULL DEFAULT \'\' COMMENT \'用户昵称\',`mobile` VARCHAR(32) NOT NULL DEFAULT \'\' COMMENT \'手机号\',`password` VARCHAR(50) NOT NULL DEFAULT \'\' COMMENT \'密码\',`avatar` VARCHAR(150) NOT NULL DEFAULT \'\' COMMENT \'头像\',`weixin` VARCHAR(50) NOT NULL DEFAULT \'\' COMMENT \'微信号\',`level` TINYINT(1) NOT NULL DEFAULT \'1\' COMMENT \'用户等级\',`login_date` INT(11) NOT NULL DEFAULT 0 COMMENT \'最近登录\',`reg_date` INT(11) NOT NULL DEFAULT 0 COMMENT \'注册时间\',`bind` TINYINT(1) NOT NULL DEFAULT \'2\' COMMENT \'是否绑定手机\',`state` TINYINT(1) NOT NULL DEFAULT \'1\' COMMENT \'状态\',`cdate` INT(11) NOT NULL DEFAULT 0 COMMENT \'录入时间\')',
  5. 'struct' =>
  6. array (
  7. 'id' => 0,
  8. 'company' => 1,
  9. 'username' => 2,
  10. 'auth' => 3,
  11. 'nickname' => 4,
  12. 'mobile' => 5,
  13. 'password' => 6,
  14. 'avatar' => 7,
  15. 'weixin' => 8,
  16. 'level' => 9,
  17. 'login_date' => 10,
  18. 'reg_date' => 11,
  19. 'bind' => 12,
  20. 'state' => 13,
  21. 'cdate' => 14,
  22. ),
  23. );