pawelgrimm/pomi

Set up SQL Database

Opened this issue · 2 comments

pawelgrimm commented

Acceptance criteria:

  • A working PostgreSQL database
  • A schema migration strategy
  • The following tables:
    • sessions: primary key id, foreign key [users] user_id, num start_unix, num end_unix, foreign key [projects] project_id, text description, bool edited, bool backfilled, gen: [duration, date, start_time, end_time]
    • users: id, varchar name, hash/auth_id
    • tasks: id, text title, todoist_id
pawelgrimm commented

Schema migration strategy:

  • set up a script in scripts.dokku.release to run DB migrations

http://dokku.viewdocs.io/dokku~v0.21.4/advanced-usage/deployment-tasks/

pawelgrimm commented

Let's make sure to use UUIDs as primary keys.