|
1
|
|
|
"""visit_log |
|
2
|
|
|
|
|
3
|
|
|
Revision ID: 1ad2b6fbcf22 |
|
4
|
|
|
Revises: 441c5a16ef8 |
|
5
|
|
|
Create Date: 2015-07-27 13:29:04.840631 |
|
6
|
|
|
|
|
7
|
|
|
""" |
|
8
|
|
|
|
|
9
|
|
|
import sqlalchemy as sa |
|
10
|
|
|
from alembic import op |
|
11
|
|
|
|
|
12
|
|
|
# revision identifiers, used by Alembic. |
|
13
|
|
|
revision = "1ad2b6fbcf22" |
|
14
|
|
|
down_revision = "441c5a16ef8" |
|
15
|
|
|
|
|
16
|
|
|
|
|
17
|
|
|
def upgrade(): |
|
18
|
|
|
op.create_table( |
|
19
|
|
|
"conceptscheme_visit_log", |
|
20
|
|
|
sa.Column("id", sa.Integer(), primary_key=True, autoincrement=True), |
|
21
|
|
|
sa.Column("conceptscheme_id", sa.String(), nullable=False), |
|
22
|
|
|
sa.Column("visited_at", sa.DateTime(), nullable=False), |
|
23
|
|
|
sa.Column("origin", sa.String, nullable=False), |
|
24
|
|
|
) |
|
25
|
|
|
op.create_table( |
|
26
|
|
|
"concept_visit_log", |
|
27
|
|
|
sa.Column("id", sa.Integer(), primary_key=True, autoincrement=True), |
|
28
|
|
|
sa.Column("concept_id", sa.Integer(), nullable=False), |
|
29
|
|
|
sa.Column("conceptscheme_id", sa.String(), nullable=False), |
|
30
|
|
|
sa.Column("visited_at", sa.DateTime(), nullable=False), |
|
31
|
|
|
sa.Column("origin", sa.String, nullable=False), |
|
32
|
|
|
) |
|
33
|
|
|
|
|
34
|
|
|
|
|
35
|
|
|
def downgrade(): |
|
36
|
|
|
op.drop_table("concept_visit_log") |
|
37
|
|
|
op.drop_table("conceptscheme_visit_log") |
|
38
|
|
|
|
OnroerendErfgoed /
atramhasis
