mirror of
https://github.com/danswer-ai/danswer.git
synced 2025-08-02 13:12:50 +02:00
58 lines
1.5 KiB
Python
58 lines
1.5 KiB
Python
"""delete_input_prompts
|
|
|
|
Revision ID: bf7a81109301
|
|
Revises: f7a894b06d02
|
|
Create Date: 2024-12-09 12:00:49.884228
|
|
|
|
"""
|
|
from alembic import op
|
|
import sqlalchemy as sa
|
|
import fastapi_users_db_sqlalchemy
|
|
|
|
|
|
# revision identifiers, used by Alembic.
|
|
revision = "bf7a81109301"
|
|
down_revision = "f7a894b06d02"
|
|
branch_labels = None
|
|
depends_on = None
|
|
|
|
|
|
def upgrade() -> None:
|
|
op.drop_table("inputprompt__user")
|
|
op.drop_table("inputprompt")
|
|
|
|
|
|
def downgrade() -> None:
|
|
op.create_table(
|
|
"inputprompt",
|
|
sa.Column("id", sa.Integer(), autoincrement=True, nullable=False),
|
|
sa.Column("prompt", sa.String(), nullable=False),
|
|
sa.Column("content", sa.String(), nullable=False),
|
|
sa.Column("active", sa.Boolean(), nullable=False),
|
|
sa.Column("is_public", sa.Boolean(), nullable=False),
|
|
sa.Column(
|
|
"user_id",
|
|
fastapi_users_db_sqlalchemy.generics.GUID(),
|
|
nullable=True,
|
|
),
|
|
sa.ForeignKeyConstraint(
|
|
["user_id"],
|
|
["user.id"],
|
|
),
|
|
sa.PrimaryKeyConstraint("id"),
|
|
)
|
|
op.create_table(
|
|
"inputprompt__user",
|
|
sa.Column("input_prompt_id", sa.Integer(), nullable=False),
|
|
sa.Column("user_id", sa.Integer(), nullable=False),
|
|
sa.ForeignKeyConstraint(
|
|
["input_prompt_id"],
|
|
["inputprompt.id"],
|
|
),
|
|
sa.ForeignKeyConstraint(
|
|
["user_id"],
|
|
["inputprompt.id"],
|
|
),
|
|
sa.PrimaryKeyConstraint("input_prompt_id", "user_id"),
|
|
)
|