10001__user.sql 920 B

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061
  1. INSERT INTO
  2. user (
  3. `id`,
  4. `username`,
  5. `role`,
  6. `email`,
  7. `nickname`,
  8. `password_hash`
  9. )
  10. VALUES
  11. (
  12. 101,
  13. 'memos-demo',
  14. 'HOST',
  15. 'demo@usememos.com',
  16. 'Derobot',
  17. -- raw password: secret
  18. '$2a$14$ajq8Q7fbtFRQvXpdCq7Jcuy.Rx1h/L4J60Otx.gyNLbAYctGMJ9tK'
  19. );
  20. INSERT INTO
  21. user (
  22. `id`,
  23. `username`,
  24. `role`,
  25. `email`,
  26. `nickname`,
  27. `password_hash`
  28. )
  29. VALUES
  30. (
  31. 102,
  32. 'jack',
  33. 'USER',
  34. 'jack@usememos.com',
  35. 'Jack',
  36. -- raw password: secret
  37. '$2a$14$ajq8Q7fbtFRQvXpdCq7Jcuy.Rx1h/L4J60Otx.gyNLbAYctGMJ9tK'
  38. );
  39. INSERT INTO
  40. user (
  41. `id`,
  42. `row_status`,
  43. `username`,
  44. `role`,
  45. `email`,
  46. `nickname`,
  47. `password_hash`
  48. )
  49. VALUES
  50. (
  51. 103,
  52. 'ARCHIVED',
  53. 'bob',
  54. 'USER',
  55. 'bob@usememos.com',
  56. 'Bob',
  57. -- raw password: secret
  58. '$2a$14$ajq8Q7fbtFRQvXpdCq7Jcuy.Rx1h/L4J60Otx.gyNLbAYctGMJ9tK'
  59. );