83 lines
3.2 KiB
Python
83 lines
3.2 KiB
Python
|
"""initial schema
|
||
|
|
|
||
|
|
Revision ID: 2bb981f6ee16
|
||
|
|
Revises:
|
||
|
|
Create Date: 2026-06-09
|
||
|
|
"""
|
||
|
|
from alembic import op
|
||
|
|
import sqlalchemy as sa
|
||
|
|
|
||
|
|
revision = "2bb981f6ee16"
|
||
|
|
down_revision = None
|
||
|
|
branch_labels = None
|
||
|
|
depends_on = None
|
||
|
|
|
||
|
|
|
||
|
|
def upgrade() -> None:
|
||
|
|
op.create_table(
|
||
|
|
"tunes",
|
||
|
|
sa.Column("id", sa.Integer(), primary_key=True, autoincrement=True, nullable=False),
|
||
|
|
sa.Column("name", sa.String(), nullable=True),
|
||
|
|
sa.Column("version", sa.String(), nullable=True),
|
||
|
|
sa.Column("key", sa.String(), nullable=True),
|
||
|
|
sa.Column("tune_id", sa.Integer(), nullable=True),
|
||
|
|
)
|
||
|
|
|
||
|
|
op.create_table(
|
||
|
|
"banjo",
|
||
|
|
sa.Column("id", sa.Integer(), primary_key=True, autoincrement=True, nullable=False),
|
||
|
|
sa.Column("tune_id", sa.Integer(), sa.ForeignKey("tunes.id", ondelete="CASCADE"), nullable=False),
|
||
|
|
sa.Column("learned_from", sa.String(), nullable=True),
|
||
|
|
sa.Column("date_learned", sa.Date(), nullable=True),
|
||
|
|
sa.Column("tuning", sa.String(), nullable=True),
|
||
|
|
sa.Column("callable", sa.Boolean(), nullable=True),
|
||
|
|
sa.Column("review", sa.Boolean(), nullable=True),
|
||
|
|
sa.Column("to_learn", sa.Boolean(), nullable=True),
|
||
|
|
sa.Column("difficulty", sa.String(), nullable=True),
|
||
|
|
sa.UniqueConstraint("tune_id", name="banjo_tune_id_unique"),
|
||
|
|
)
|
||
|
|
|
||
|
|
op.create_table(
|
||
|
|
"fiddle",
|
||
|
|
sa.Column("id", sa.Integer(), primary_key=True, autoincrement=True, nullable=False),
|
||
|
|
sa.Column("tune_id", sa.Integer(), sa.ForeignKey("tunes.id", ondelete="CASCADE"), nullable=False),
|
||
|
|
sa.Column("learned_from", sa.String(), nullable=True),
|
||
|
|
sa.Column("date_learned", sa.Date(), nullable=True),
|
||
|
|
sa.Column("tuning", sa.String(), nullable=True),
|
||
|
|
sa.Column("callable", sa.Boolean(), nullable=True),
|
||
|
|
sa.Column("review", sa.Boolean(), nullable=True),
|
||
|
|
sa.Column("to_learn", sa.Boolean(), nullable=True),
|
||
|
|
sa.Column("difficulty", sa.String(), nullable=True),
|
||
|
|
sa.UniqueConstraint("tune_id", name="fiddle_tune_id_unique"),
|
||
|
|
)
|
||
|
|
|
||
|
|
op.create_table(
|
||
|
|
"notes",
|
||
|
|
sa.Column("id", sa.Integer(), primary_key=True, autoincrement=True, nullable=False),
|
||
|
|
sa.Column("tune_id", sa.Integer(), sa.ForeignKey("tunes.id", ondelete="CASCADE"), nullable=True),
|
||
|
|
sa.Column("note", sa.String(), nullable=True),
|
||
|
|
)
|
||
|
|
|
||
|
|
op.create_table(
|
||
|
|
"references",
|
||
|
|
sa.Column("id", sa.Integer(), primary_key=True, autoincrement=True, nullable=False),
|
||
|
|
sa.Column("tune_id", sa.Integer(), sa.ForeignKey("tunes.id", ondelete="CASCADE"), nullable=True),
|
||
|
|
sa.Column("link", sa.String(), nullable=True),
|
||
|
|
sa.Column("site", sa.String(), nullable=True),
|
||
|
|
)
|
||
|
|
|
||
|
|
op.create_table(
|
||
|
|
"musicians",
|
||
|
|
sa.Column("name", sa.String(), primary_key=True, nullable=False),
|
||
|
|
sa.Column("reference_id", sa.Integer(), sa.ForeignKey("references.id", ondelete="CASCADE"), nullable=True),
|
||
|
|
)
|
||
|
|
|
||
|
|
|
||
|
|
def downgrade() -> None:
|
||
|
|
op.drop_table("musicians")
|
||
|
|
op.drop_table("references")
|
||
|
|
op.drop_table("notes")
|
||
|
|
op.drop_table("fiddle")
|
||
|
|
op.drop_table("banjo")
|
||
|
|
op.drop_table("tunes")
|