Advertisement
gaspan619

langkah2 membuat db di postgres

Dec 7th, 2019
153
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. langkah2 membuat db di postgres(unix):
  2. - psql postgres
  3. - CREATE ROLE genturadmin WITH LOGIN PASSWORD 'gentur';
  4. - ALTER ROLE genturadmin CREATEDB;
  5. - \q
  6. - psql postgres genturadmin
  7. - gentur
  8. - CREATE DATABASE message_app_db;
  9. - GRANT ALL PRIVILEGES ON DATABASE message_app_db to genturadmin;
  10.  
  11. cd ke dalam project
  12. - sequelize model:create --name User --attributes name:string,email:string,password:string,token:string
  13. - sequelize model:create --name Message --attributes sender_id:string,recipient_id:string,message_time:date,message_body:string,is_read:boolean
  14. - sequelize model:create --name Thread --attributes user_id:string,other_user_id:string
  15.  
  16. - npx sequelize-cli db:migrate
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement