diff options
| author | Jules Laplace <julescarbon@gmail.com> | 2020-06-02 16:09:59 +0200 |
|---|---|---|
| committer | Jules Laplace <julescarbon@gmail.com> | 2020-06-02 16:09:59 +0200 |
| commit | 2db55c3d261ddee52019bbd06dc5f6545db39c16 (patch) | |
| tree | 4afe164982b81ca8cbd239e9f08567e8ae7fb2cf /cli/app/sql/versions/202006011943_adding_database.py | |
| parent | 42d5e59335d97aa0cf165f2aedf8d04f60db9310 (diff) | |
form for making a new graph. add username field to db
Diffstat (limited to 'cli/app/sql/versions/202006011943_adding_database.py')
| -rw-r--r-- | cli/app/sql/versions/202006011943_adding_database.py | 66 |
1 files changed, 0 insertions, 66 deletions
diff --git a/cli/app/sql/versions/202006011943_adding_database.py b/cli/app/sql/versions/202006011943_adding_database.py deleted file mode 100644 index 4e5b0e6..0000000 --- a/cli/app/sql/versions/202006011943_adding_database.py +++ /dev/null @@ -1,66 +0,0 @@ -"""adding database - -Revision ID: 7acd0c82a048 -Revises: -Create Date: 2020-06-01 19:43:53.359855 - -""" -from alembic import op -import sqlalchemy as sa -import sqlalchemy_utc - - -# revision identifiers, used by Alembic. -revision = '7acd0c82a048' -down_revision = None -branch_labels = None -depends_on = None - - -def upgrade(): - # ### commands auto generated by Alembic - please adjust! ### - op.create_table('graph', - sa.Column('id', sa.Integer(), nullable=False), - sa.Column('path', sa.String(length=64, _expect_unicode=True), nullable=False), - sa.Column('title', sa.String(length=64, _expect_unicode=True), nullable=False), - sa.Column('description', sa.Text(_expect_unicode=True), nullable=False), - sa.Column('settings', sa.JSON(), nullable=True), - sa.Column('created_at', sqlalchemy_utc.sqltypes.UtcDateTime(timezone=True), nullable=True), - sa.Column('updated_at', sqlalchemy_utc.sqltypes.UtcDateTime(timezone=True), nullable=True), - sa.PrimaryKeyConstraint('id') - ) - op.create_table('page', - sa.Column('id', sa.Integer(), nullable=False), - sa.Column('graph_id', sa.Integer(), nullable=True), - sa.Column('path', sa.String(length=64, _expect_unicode=True), nullable=False), - sa.Column('title', sa.String(length=64, _expect_unicode=True), nullable=False), - sa.Column('description', sa.Text(_expect_unicode=True), nullable=False), - sa.Column('settings', sa.JSON(), nullable=True), - sa.Column('created_at', sqlalchemy_utc.sqltypes.UtcDateTime(timezone=True), nullable=True), - sa.Column('updated_at', sqlalchemy_utc.sqltypes.UtcDateTime(timezone=True), nullable=True), - sa.ForeignKeyConstraint(['graph_id'], ['graph.id'], ), - sa.PrimaryKeyConstraint('id') - ) - op.create_table('tile', - sa.Column('id', sa.Integer(), nullable=False), - sa.Column('graph_id', sa.Integer(), nullable=True), - sa.Column('page_id', sa.Integer(), nullable=True), - sa.Column('target_page_id', sa.Integer(), nullable=True), - sa.Column('type', sa.String(length=16, _expect_unicode=True), nullable=False), - sa.Column('settings', sa.JSON(), nullable=True), - sa.Column('created_at', sqlalchemy_utc.sqltypes.UtcDateTime(timezone=True), nullable=True), - sa.Column('updated_at', sqlalchemy_utc.sqltypes.UtcDateTime(timezone=True), nullable=True), - sa.ForeignKeyConstraint(['graph_id'], ['graph.id'], ), - sa.ForeignKeyConstraint(['page_id'], ['page.id'], ), - sa.ForeignKeyConstraint(['target_page_id'], ['page.id'], ), - sa.PrimaryKeyConstraint('id') - ) - # ### end Alembic commands ### - - -def downgrade(): - # ### commands auto generated by Alembic - please adjust! ### - op.drop_table('tile') - op.drop_table('page') - op.drop_table('graph') - # ### end Alembic commands ### |
