asdfsdafs
Show More
@@ -1,30 +1,32 b'' | |||||
1 | """connect resources to alert_channels |
|
1 | """connect resources to alert_channels | |
2 |
|
2 | |||
3 | Revision ID: e9fcfbdd9498 |
|
3 | Revision ID: e9fcfbdd9498 | |
4 | Revises: 55b6e612672f |
|
4 | Revises: 55b6e612672f | |
5 | Create Date: 2018-02-28 13:52:50.717217 |
|
5 | Create Date: 2018-02-28 13:52:50.717217 | |
6 |
|
6 | |||
7 | """ |
|
7 | """ | |
8 |
|
8 | |||
9 | # revision identifiers, used by Alembic. |
|
9 | # revision identifiers, used by Alembic. | |
10 | revision = 'e9fcfbdd9498' |
|
10 | revision = 'e9fcfbdd9498' | |
11 | down_revision = '55b6e612672f' |
|
11 | down_revision = '55b6e612672f' | |
12 |
|
12 | |||
13 | from alembic import op |
|
13 | from alembic import op | |
14 | import sqlalchemy as sa |
|
14 | import sqlalchemy as sa | |
15 |
|
15 | |||
16 |
|
16 | |||
17 | def upgrade(): |
|
17 | def upgrade(): | |
18 | op.create_table( |
|
18 | op.create_table( | |
19 | 'channels_resources', |
|
19 | 'channels_resources', | |
20 | sa.Column('channel_pkey', sa.Integer, |
|
20 | sa.Column('channel_pkey', sa.Integer, | |
21 | sa.ForeignKey('alert_channels.pkey', |
|
21 | sa.ForeignKey('alert_channels.pkey', | |
22 |
ondelete='CASCADE', onupdate='CASCADE') |
|
22 | ondelete='CASCADE', onupdate='CASCADE'), | |
|
23 | primary_key=True), | |||
23 | sa.Column('resource_id', sa.Integer, |
|
24 | sa.Column('resource_id', sa.Integer, | |
24 | sa.ForeignKey('resources.resource_id', |
|
25 | sa.ForeignKey('resources.resource_id', | |
25 |
ondelete='CASCADE', onupdate='CASCADE') |
|
26 | ondelete='CASCADE', onupdate='CASCADE'), | |
|
27 | primary_key=True) | |||
26 | ) |
|
28 | ) | |
27 |
|
29 | |||
28 |
|
30 | |||
29 | def downgrade(): |
|
31 | def downgrade(): | |
30 | op.drop_table('channels_resources') |
|
32 | op.drop_table('channels_resources') |
General Comments 2
Auto status change to "Under Review"
Please use: https://github.com/Appenlight/appenlight to contribute :) Thanks !
You need to be logged in to leave comments.
Login now