ios_sign/database/sql/admin_users.sql

CREATE TABLE `admin_users` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `username` varchar(255) NOT NULL COMMENT '用户名',
  `email` varchar(255) NOT NULL COMMENT '邮件',
  `mobile` varchar(11) DEFAULT NULL COMMENT '手机号码',
  `sex` smallint(3) NOT NULL DEFAULT 1 COMMENT '性别, 1为男,2为女',
  `password` varchar(60) NOT NULL COMMENT '密码',
  `remember_token` varchar(100) DEFAULT NULL COMMENT 'TOKEN',
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '创建时间',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '修改时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_username_unique` (`username`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT '管理用户表';