-
Notifications
You must be signed in to change notification settings - Fork 1
Expand file tree
/
Copy pathseed.sql
More file actions
16 lines (13 loc) · 1.62 KB
/
seed.sql
File metadata and controls
16 lines (13 loc) · 1.62 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
USE posts;
INSERT INTO posts.`posts.users` (name,last_name,email,username,password,token,created_by,updated_by,deleted,createdAt,updatedAt)
VALUES ('user test admin','lastname test','admin@gmail.com','admin','$2b$10$NvoZjhvW4XDo/UDgfy0ZC.1zPtixonLGc7kv/YdIRtFwSP4AJfeqW','eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOjEsIm5hbWUiOiJ1c2VyIHRlc3QgYWRtaW4iLCJsYXN0X25hbWUiOiJsYXN0bmFtZSB0ZXN0IiwidXNlcm5hbWUiOiJhZG1pbiIsImVtYWlsIjoiYWRtaW5AZ21haWwuY29tIiwiaWF0IjoxNjE3MDQyMjczLCJleGQiOjE2MTcwNDk0NzMsImV4cCI6MTYxNzA0OTQ3M30.6ZxxyibrIShFB5zjLFmkxTgE7SoWUDs62oO738i8Bg8',1,NULL,0,'2021-03-29 18:23:57','2021-03-29 18:24:33');
INSERT INTO posts.`posts.permissions` (module,permission,user_id,description,created_by,updated_by,deleted,createdAt,updatedAt) VALUES
('users','create',1,'user can create new users',1,NULL,0,'2021-04-07 14:18:40','2021-04-07 14:18:40'),
('users','view',1,'user can view users',1,NULL,0,'2021-04-07 14:18:40','2021-04-07 14:18:40'),
('users','edit',1,'user can edit users',1,NULL,0,'2021-04-07 14:18:40','2021-04-07 14:18:40'),
('users','delete',1,'user can delete users',1,NULL,0,'2021-04-07 14:18:40','2021-04-07 14:18:40'),
('posts','create',1,'user can create posts',1,NULL,0,'2021-04-07 14:18:40','2021-04-07 14:18:40'),
('posts','edit',1,'user can edit posts',1,NULL,0,'2021-04-07 14:18:40','2021-04-07 14:18:40'),
('posts','view',1,'user can view posts',1,NULL,0,'2021-04-07 14:18:40','2021-04-07 14:18:40'),
('posts','delete',1,'user can delete posts',1,NULL,0,'2021-04-07 14:18:40','2021-04-07 14:18:40'),
('posts','review',1,'user can review posts',1,NULL,0,'2021-04-07 14:18:40','2021-04-07 14:18:40');