migrations/initial.rb


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

require "sequel"

DB = Sequel.connect('sqlite:///tmp/bass-player.db')

DB.create_table(:songs) do
  primary_key :id
  String :title
  Integer :duration
  String :path

  foreign_key :song_id, :songs
end

DB.create_table(:parts) do
  primary_key :id
  String :name
  Integer :from
  Integer :to
  Integer :song_id
end