1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
|
"""Initial migration
Revision ID: b9a10d5d63ce
Revises: None
Create Date: 2016-05-21 23:21:21.605076
"""
# revision identifiers, used by Alembic.
revision = "b9a10d5d63ce"
down_revision = None
from alembic import op
import sqlalchemy as sa
def upgrade():
### commands auto generated by Alembic - please adjust! ###
op.create_table(
"project",
sa.Column("id", sa.String(length=64), nullable=False),
sa.Column("name", sa.UnicodeText(), nullable=True),
sa.Column("password", sa.String(length=128), nullable=True),
sa.Column("contact_email", sa.String(length=128), nullable=True),
sa.PrimaryKeyConstraint("id"),
)
op.create_table(
"archive",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("project_id", sa.String(length=64), nullable=True),
sa.Column("name", sa.UnicodeText(), nullable=True),
sa.ForeignKeyConstraint(["project_id"], ["project.id"]),
sa.PrimaryKeyConstraint("id"),
)
op.create_table(
"person",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("project_id", sa.String(length=64), nullable=True),
sa.Column("name", sa.UnicodeText(), nullable=True),
sa.Column("activated", sa.Boolean(), nullable=True),
sa.ForeignKeyConstraint(["project_id"], ["project.id"]),
sa.PrimaryKeyConstraint("id"),
)
op.create_table(
"bill",
sa.Column("id", sa.Integer(), nullable=False),
sa.Column("payer_id", sa.Integer(), nullable=True),
sa.Column("amount", sa.Float(), nullable=True),
sa.Column("date", sa.Date(), nullable=True),
sa.Column("what", sa.UnicodeText(), nullable=True),
sa.Column("archive", sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(["archive"], ["archive.id"]),
sa.ForeignKeyConstraint(["payer_id"], ["person.id"]),
sa.PrimaryKeyConstraint("id"),
)
op.create_table(
"billowers",
sa.Column("bill_id", sa.Integer(), nullable=True),
sa.Column("person_id", sa.Integer(), nullable=True),
sa.ForeignKeyConstraint(["bill_id"], ["bill.id"]),
sa.ForeignKeyConstraint(["person_id"], ["person.id"]),
)
### end Alembic commands ###
def downgrade():
### commands auto generated by Alembic - please adjust! ###
op.drop_table("billowers")
op.drop_table("bill")
op.drop_table("person")
op.drop_table("archive")
op.drop_table("project")
### end Alembic commands ###
|
