123456789101112131415161718192021222324 |
- CREATE TABLE `sys_user` (
- `id` varchar(36) NOT NULL,
- `login_id` varchar(36) NOT NULL,
- `password` varchar(36) NOT NULL,
- `name` varchar(100) NOT NULL,
- `full_name` varchar(100) NOT NULL,
- `mobile` varchar(50) NOT NULL,
- `email` varchar(50) NOT NULL,
- `org_id` varchar(36) DEFAULT NULL,
- `gender` int(11) NOT NULL,
- `type` int(11) DEFAULT NULL,
- `status` int(11) DEFAULT NULL,
- `avatar` varchar(255) DEFAULT NULL,
- `domain` varchar(50) NOT NULL,
- `create_by` varchar(36) NOT NULL,
- `create_time` datetime NOT NULL,
- `last_update_by` varchar(36) NOT NULL,
- `last_update_time` bigint(20) NOT NULL,
- `del_flag` tinyint(2) NOT NULL DEFAULT '0',
- `temp_id` varchar(36) DEFAULT NULL,
- `temp_value` text,
- `address` varchar(500) DEFAULT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|