31 lines
1.2 KiB
SQL
31 lines
1.2 KiB
SQL
DROP TABLE IF EXISTS `user`;
|
|
|
|
CREATE TABLE `user` (
|
|
`user_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
|
|
`user_group_id` INT UNSIGNED NOT NULL DEFAULT 1,
|
|
`site_id` INT UNSIGNED NOT NULL DEFAULT 1,
|
|
`username` varchar(60) NOT NULL DEFAULT '',
|
|
`first_name` varchar(32) NOT NULL DEFAULT '',
|
|
`last_name` varchar(32) NOT NULL DEFAULT '',
|
|
`password` varchar(191) NOT NULL DEFAULT '',
|
|
`email` varchar(100) NOT NULL DEFAULT '',
|
|
`phone_number` varchar(32) NOT NULL DEFAULT '',
|
|
`url` varchar(100) NOT NULL DEFAULT '',
|
|
`status` INT UNSIGNED NOT NULL DEFAULT '0',
|
|
`display_name` varchar(250) NOT NULL DEFAULT '',
|
|
`avatar` varchar(250) NOT NULL DEFAULT '',
|
|
`cover` varchar(250) NOT NULL DEFAULT '',
|
|
`bio` text,
|
|
`token` varchar(32) NOT NULL DEFAULT '',
|
|
`secret` varchar(32) NOT NULL DEFAULT '',
|
|
-- `fields` text NOT NULL DEFAULT '',
|
|
`subscribe` tinyint NOT NULL DEFAULT 0,
|
|
`last_ip` varchar(40) NOT NULL DEFAULT '',
|
|
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
`updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
PRIMARY KEY (`user_id`),
|
|
KEY `username` (`username`),
|
|
KEY `email` (`email`),
|
|
KEY `created_at` (`created_at`)
|
|
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;
|