Skip to content

#7 Games: Database migration #9

@LukasZahradnik

Description

@LukasZahradnik

Add migration for games

  • Create upgrade.sql (create table, indices)
  • Create downgrade.sql(drop table, indices)

Table fields:

identifier (uuid)
white_player_ranking int
white_player_name string
black_player_ranking int
black_palyer_name int
result enum (http://www.saremba.de/chessgml/standards/pgn/pgn-complete.htm - result tag)
pgn string
played_at timestamp
created_at timestamp

Story: #7

Metadata

Metadata

Labels

No labels
No labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions