Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE `user` (
- id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
- login VARCHAR(64) NOT NULL,
- password_hash VARCHAR(255) NOT NULL,
- phone VARCHAR(20) NULL,
- role ENUM('admin','user') DEFAULT 'user',
- legit_ips JSON NULL,
- dev_token VARCHAR(255) NULL,
- created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
- updated_at DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
- UNIQUE KEY uk_login (login),
- INDEX ix_role (role)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
- INSERT INTO user (login, password_hash, role, legit_ips)
- VALUES ('odmin',
- '$2y$10$Zapji.VO3ejywwxBJxKA5OU.GtAGc11QskEuQxSlWxk3b2vG60aIC',
- 'admin',
- JSON_ARRAY());
Advertisement
Add Comment
Please, Sign In to add comment