eqeqwan21

new table and insert admin

Jul 19th, 2025
412
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.75 KB | None | 0 0
  1. CREATE TABLE `user` (
  2.   id            INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  3.   login         VARCHAR(64)         NOT NULL,
  4.   password_hash VARCHAR(255)            NOT NULL,
  5.   phone         VARCHAR(20)         NULL,
  6.   role          ENUM('admin','user') DEFAULT 'user',
  7.  
  8.   legit_ips     JSON NULL,
  9.   dev_token     VARCHAR(255)  NULL,
  10.  
  11.   created_at    DATETIME DEFAULT CURRENT_TIMESTAMP,
  12.   updated_at    DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  13.  
  14.   UNIQUE KEY uk_login (login),
  15.   INDEX ix_role  (role)
  16. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  17.  
  18. INSERT INTO user (login, password_hash, role, legit_ips)
  19. VALUES ('odmin',
  20.         '$2y$10$Zapji.VO3ejywwxBJxKA5OU.GtAGc11QskEuQxSlWxk3b2vG60aIC',
  21.         'admin',
  22.         JSON_ARRAY());
Advertisement
Add Comment
Please, Sign In to add comment