def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_column('sensor_attribute', 'measurement_pattern')
op.drop_column('power_supply_attribute', 'measurement_pattern')
op.drop_column('environment_sensor_attribute', 'measurement_pattern')
op.drop_column('controller_power_supply_attribute', 'measurement_pattern')
op.drop_column('controller_attribute', 'measurement_pattern')
op.create_table(
'energy_optimazation_target',
sa.Column('type',
mysql.ENUM(u'binary', u'continuous', u'integer',
u'discrete'),
server_default=sa.text(u"'continuous'"),
nullable=True),
sa.Column('unit', mysql.VARCHAR(length=36), nullable=True),
sa.Column('mean', mysql.FLOAT(), nullable=True),
sa.Column('deviation', mysql.FLOAT(), nullable=True),
sa.Column('max', mysql.FLOAT(), nullable=True),
sa.Column('min', mysql.FLOAT(), nullable=True),
sa.Column('differentiation_mean', mysql.FLOAT(), nullable=True),
sa.Column('differentiation_deviation', mysql.FLOAT(), nullable=True),
sa.Column('differentiation_max', mysql.FLOAT(), nullable=True),
sa.Column('differentiation_min', mysql.FLOAT(), nullable=True),
sa.Column('possible_values', mysql.JSON(), nullable=True),
sa.Column('datacenter_name', mysql.VARCHAR(length=36), nullable=False),
sa.Column('name', mysql.VARCHAR(length=36), nullable=False),
sa.Column('properties', mysql.JSON(), nullable=True),
sa.ForeignKeyConstraint(['datacenter_name'], [u'datacenter.name'],
name=u'energy_optimazation_target_ibfk_1',
onupdate=u'CASCADE',
ondelete=u'CASCADE'),
sa.PrimaryKeyConstraint('datacenter_name', 'name'),
mysql_default_charset=u'latin1',
mysql_engine=u'InnoDB')
class TableTweet(Base):
"""
Tweet Model
"""
__tablename__ = "tweet"
__table_args__ = {'extend_existing': True}
id = sa.Column('id', sa.Integer, primary_key=True)
t_tweet_id = sa.Column('tweet_id', sa.String(30), unique=True, nullable=False)
user_id = sa.Column('user_id', sa.Integer, sa.ForeignKey("user.id", ondelete="CASCADE"), nullable=False, default=-1)
text = sa.Column('text', sa.String(400), nullable=False, default="")
lang = sa.Column('lang', sa.String(10))
retweet_count = sa.Column('retweet_count', sa.Integer)
favorite_count = sa.Column('favorite_count', sa.Integer)
source = sa.Column('source', sa.String(50))
in_reply_to_status_id = sa.Column('in_reply_to_status_id', sa.String(30))
coordinates = sa.Column('coordinates', sadm.JSON())
place = sa.Column('place', sadm.JSON())
created_at = sa.Column("created_at", sa.DateTime)
updated_at = sa.Column("updated_at", sa.DateTime)
# children
user = relationship("TableUser", back_populates="tweet", uselist=False)
# parent
hashtag = relationship("TableHashTag", back_populates="tweet", cascade="all, delete-orphan")
entity_url = relationship("TableEntityUrl", back_populates="tweet", cascade="all, delete-orphan")
def __repr__(self):
return "<TableTweet(id={}, tweet_id={})>".format(self.id, self.t_tweet_id)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'results', sa.Column('id', sa.Integer(), nullable=False),
sa.Column('url', sa.String(), nullable=True),
sa.Column('result_all', mysql.JSON(), nullable=True),
sa.Column('result_no_stop_words', mysql.JSON(), nullable=True),
sa.PrimaryKeyConstraint('id'))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('auth_tokens',
sa.Column('id', mysql.VARCHAR(length=32), nullable=False),
sa.Column('expire_at', mysql.DATETIME(), nullable=False),
sa.Column('attempts',
mysql.INTEGER(display_width=11),
autoincrement=False,
nullable=True),
sa.Column('token_type',
mysql.ENUM('PIN', 'ACCESS', 'REFRESH'),
nullable=False),
sa.Column('is_black_listed',
mysql.TINYINT(display_width=1),
autoincrement=False,
nullable=False),
sa.Column('data', mysql.JSON(), nullable=False),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset='latin1',
mysql_engine='InnoDB')
op.create_table('ibm_tokens',
sa.Column('id', mysql.VARCHAR(length=40), nullable=False),
sa.Column('user_id',
mysql.VARCHAR(length=32),
nullable=False),
sa.ForeignKeyConstraint(['user_id'], ['users.id'],
name='ibm_tokens_ibfk_1'),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset='latin1',
mysql_engine='InnoDB')
op.create_table('devices',
sa.Column('id', mysql.VARCHAR(length=100), nullable=False),
sa.Column('finger_print',
mysql.VARCHAR(length=100),
nullable=False),
sa.Column('registered_at',
mysql.DATETIME(),
nullable=False),
sa.Column('device_info', mysql.JSON(), nullable=False),
sa.Column('session_token',
mysql.VARCHAR(length=32),
nullable=True),
sa.Column('status',
mysql.ENUM('trusted', 'untrusted'),
nullable=False),
sa.Column('user_id',
mysql.VARCHAR(length=32),
nullable=False),
sa.ForeignKeyConstraint(['user_id'], ['users.id'],
name='devices_ibfk_1'),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset='latin1',
mysql_engine='InnoDB')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'draftdata', sa.Column('name', sa.String(length=500), nullable=False),
sa.Column('drafted_by', sa.String(length=120), nullable=True),
sa.Column('target_role', mysql.JSON(), nullable=True),
sa.Column('wfdoc_name', sa.String(length=120), nullable=True),
sa.Column('draft_data', mysql.JSON(), nullable=True),
sa.ForeignKeyConstraint(
['wfdoc_name'],
['wfdoc.name'],
), sa.PrimaryKeyConstraint('name'), sa.UniqueConstraint('name'))
op.add_column(
'wfdoc', sa.Column('has_draft_for_roles', mysql.JSON(), nullable=True))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
'dat_declaration',
sa.Column('returns_cleared',
sa.Boolean(),
nullable=True,
comment='申报表是否已经清理'))
op.add_column(
'dat_tax_clearance_certificate',
sa.Column('cleared', sa.Boolean(), nullable=True,
comment='完税证明是否已经清理'))
op.alter_column('dat_tax_clearance_certificate',
'declare_month_end',
existing_type=mysql.INTEGER(display_width=11),
nullable=False,
existing_comment='申报月份不晚于')
op.alter_column('dat_tax_clearance_certificate',
'declare_month_start',
existing_type=mysql.INTEGER(display_width=11),
nullable=False,
existing_comment='申报月份不早于')
op.alter_column('dat_tax_clearance_certificate',
'declare_year',
existing_type=mysql.INTEGER(display_width=11),
nullable=False,
existing_comment='申报年限')
op.alter_column('dat_tax_clearance_certificate',
'file_path',
existing_type=mysql.JSON(),
nullable=False,
existing_comment='文件存储位置')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('Poem',
sa.Column('id',
mysql.INTEGER(display_width=11),
autoincrement=True,
nullable=False),
sa.Column('name', mysql.VARCHAR(length=256),
nullable=True),
sa.Column('content', mysql.JSON(), nullable=True),
sa.Column('author_id',
mysql.INTEGER(display_width=11),
autoincrement=False,
nullable=True),
sa.Column('time_created',
mysql.INTEGER(display_width=11),
autoincrement=False,
nullable=True),
sa.Column('time_removed',
mysql.INTEGER(display_width=11),
autoincrement=False,
nullable=True),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset='utf8',
mysql_engine='InnoDB')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('autotest_interface_testcase',
sa.Column('testcase_query', mysql.JSON(), nullable=True))
op.drop_column('autotest_system_setting', 'is_used')
op.add_column('autotest_testcasegroup',
sa.Column('runner_setting_id', sa.Integer(), nullable=True))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'articles', sa.Column('id',
mysql.BIGINT(unsigned=True),
nullable=False),
sa.Column('title', mysql.VARCHAR(length=255), nullable=False),
sa.Column('link', mysql.VARCHAR(length=768), nullable=False),
sa.Column('description', mysql.VARCHAR(length=255), nullable=False),
sa.Column('author', mysql.VARCHAR(length=255), nullable=False),
sa.Column('text_filepath', mysql.VARCHAR(length=255), nullable=False),
sa.Column('publication_date', mysql.TIMESTAMP(), nullable=False),
sa.Column('guid', mysql.VARCHAR(length=768), nullable=True),
sa.Column('atom_link', mysql.VARCHAR(length=768), nullable=True),
sa.Column('categories', mysql.JSON(), nullable=True),
sa.Column('image_url', mysql.VARCHAR(length=768), nullable=True),
sa.Column('credit', mysql.VARCHAR(length=255), nullable=True),
sa.Column('created_at',
mysql.TIMESTAMP(),
server_default=sa.text('CURRENT_TIMESTAMP'),
nullable=False),
sa.Column('updated_at',
mysql.TIMESTAMP(),
server_default=sa.text(
'CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'),
nullable=False), sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('atom_link'), sa.UniqueConstraint('guid'),
sa.UniqueConstraint('link'))
op.create_index(op.f('ix_articles_text_filepath'),
'articles', ['text_filepath'],
unique=False)
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_column('salt', 'state')
op.add_column(
'policies',
sa.Column('default_version',
mysql.INTEGER(display_width=11),
autoincrement=False,
nullable=True))
op.drop_column('policies', 'document')
op.create_table('policy_versions',
sa.Column('version_id',
mysql.INTEGER(display_width=11),
nullable=False),
sa.Column('policy_id',
mysql.INTEGER(display_width=11),
autoincrement=False,
nullable=True),
sa.Column('document', mysql.JSON(), nullable=True),
sa.Column('create_date', mysql.DATETIME(), nullable=True),
sa.Column('delete_date', mysql.DATETIME(), nullable=True),
sa.ForeignKeyConstraint(['policy_id'],
[u'policies.policy_id'],
name=u'policy_versions_ibfk_1'),
sa.PrimaryKeyConstraint('version_id'),
mysql_default_charset=u'utf8',
mysql_engine=u'InnoDB')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('notifications',
sa.Column('body', mysql.JSON(), nullable=True))
op.add_column('notifications',
sa.Column('created_at', mysql.DATETIME(), nullable=True))
op.add_column('notifications',
sa.Column('fire', sa.BOOLEAN(), nullable=True))
op.add_column('notifications',
sa.Column('from_user_id', sa.Integer(), nullable=True))
op.add_column(
'notifications',
sa.Column('read', sa.BOOLEAN(), server_default='0', nullable=True))
op.add_column('notifications',
sa.Column('to_user_id', sa.Integer(), nullable=True))
op.create_foreign_key(None,
'notifications',
'users', ['to_user_id'], ['id'],
onupdate='SET NULL',
ondelete='SET NULL')
op.create_foreign_key(None,
'notifications',
'users', ['from_user_id'], ['id'],
onupdate='SET NULL',
ondelete='SET NULL')
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
u'servers',
sa.Column('minion_id', mysql.VARCHAR(length=64), nullable=True))
op.add_column(u'servers',
sa.Column('pillar_content', mysql.JSON(), nullable=True))
op.drop_table('salt_hosts')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('departments',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('name', sa.String(length=60), nullable=True),
sa.Column('attributes', mysql.JSON(), nullable=True),
sa.PrimaryKeyConstraint('id')
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'wfdocaudit', sa.Column('name', sa.String(length=500), nullable=False),
sa.Column('wfdoc_name', sa.String(length=120), nullable=True),
sa.Column('username', sa.String(length=120), nullable=True),
sa.Column('email', sa.String(length=120), nullable=True),
sa.Column('time_stamp', sa.String(length=120), nullable=True),
sa.Column('client_address', sa.String(length=120), nullable=True),
sa.Column('org', sa.String(length=120), nullable=True),
sa.Column('orgunit', sa.String(length=120), nullable=True),
sa.Column('department', sa.String(length=120), nullable=True),
sa.Column('roles', mysql.JSON(), nullable=True),
sa.Column('data', mysql.JSON(), nullable=True),
sa.ForeignKeyConstraint(
['wfdoc_name'],
['wfdoc.name'],
), sa.PrimaryKeyConstraint('name'), sa.UniqueConstraint('name'))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('static_json',
sa.Column('name', mysql.VARCHAR(length=30), nullable=True),
sa.Column('json', mysql.JSON(), nullable=True),
mysql_default_charset='latin1',
mysql_engine='InnoDB'
)
op.drop_table('sidewalk_segment3')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column(
'datadocfield',
sa.Column('wfc_filter_to_roles', mysql.JSON(), nullable=True))
op.alter_column('datadocfield',
'wfc_filter',
existing_type=mysql.VARCHAR(length=120),
nullable=True)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('autotest_system_setting',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('key', sa.String(length=32), nullable=False),
sa.Column('type', sa.Integer(), nullable=False),
sa.Column('value', mysql.JSON(), nullable=True),
sa.Column('is_default', sa.Boolean(), nullable=True),
sa.Column('desc', sa.Text(), nullable=True),
sa.Column('is_active', sa.Boolean(), nullable=True),
sa.PrimaryKeyConstraint('id'), sa.UniqueConstraint('key'))
op.add_column('autotest_Interface',
sa.Column('interface_desc', sa.Text(), nullable=True))
op.add_column('autotest_Interface',
sa.Column('interface_query', mysql.JSON(), nullable=True))
op.add_column('autotest_interface_testcase',
sa.Column('testcase_query', mysql.JSON(), nullable=True))
op.add_column('autotest_testcasegroup',
sa.Column('runner_setting_id', sa.Integer(), nullable=True))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_constraint(None, 'runtime', type_='unique')
op.drop_column('runtime', 'spec_name')
op.drop_column('runtime', 'json_metadata_decoded')
op.drop_column('runtime', 'json_metadata')
op.drop_column('runtime', 'count_storage_functions')
op.drop_column('runtime', 'count_modules')
op.drop_column('runtime', 'count_events')
op.drop_column('runtime', 'count_call_functions')
op.drop_column('runtime', 'authoring_version')
op.drop_column('runtime', 'apis')
op.drop_column('data_block', 'logs')
op.create_table('metadata',
sa.Column('spec_version',
mysql.INTEGER(display_width=11),
autoincrement=False,
nullable=False),
sa.Column('json_metadata', mysql.JSON(), nullable=True),
sa.Column('json_metadata_decoded',
mysql.JSON(),
nullable=True),
sa.Column('count_call_functions',
mysql.INTEGER(display_width=11),
autoincrement=False,
nullable=False),
sa.Column('count_events',
mysql.INTEGER(display_width=11),
autoincrement=False,
nullable=False),
sa.Column('count_modules',
mysql.INTEGER(display_width=11),
autoincrement=False,
nullable=False),
sa.Column('count_storage_functions',
mysql.INTEGER(display_width=11),
autoincrement=False,
nullable=False),
sa.PrimaryKeyConstraint('spec_version'),
mysql_collate='utf8mb4_0900_ai_ci',
mysql_default_charset='utf8mb4',
mysql_engine='InnoDB')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('order',
sa.Column('id', sa.VARCHAR(length=255), nullable=False),
sa.Column('amount', mysql.JSON(), nullable=False),
sa.Column('username', sa.VARCHAR(length=225), nullable=False),
sa.Column('created_at', sa.TIMESTAMP(), nullable=True),
sa.Column('item_details', mysql.JSON(), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.create_table('payment',
sa.Column('payment_id', sa.VARCHAR(length=255), nullable=False),
sa.Column('amount', mysql.JSON(), nullable=False),
sa.Column('order_id', sa.VARCHAR(length=255), nullable=False),
sa.Column('payment_details', mysql.JSON(), nullable=False),
sa.Column('payment_status', sa.VARCHAR(length=225), nullable=False),
sa.Column('created_at', sa.TIMESTAMP(), nullable=True),
sa.ForeignKeyConstraint(['order_id'], ['order.id'], onupdate='CASCADE', ondelete='CASCADE'),
sa.PrimaryKeyConstraint('payment_id')
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('candidates',
sa.Column('user_id', sa.Integer(), nullable=False),
sa.Column('user_name', mysql.MEDIUMTEXT(), nullable=True),
sa.Column('user_registration',
sa.DateTime(),
nullable=True),
sa.Column('user_editcount', sa.Integer(), nullable=True),
sa.Column('candidate_status',
mysql.TINYTEXT(),
nullable=True),
sa.Column('invite_sent', mysql.TINYTEXT(), nullable=True),
sa.Column('created_at', sa.DateTime(), nullable=True),
sa.PrimaryKeyConstraint('user_id'),
mysql_charset='utf8',
mysql_collate='utf8_general_ci',
mysql_engine='InnoDB')
op.create_index(op.f('ix_candidates_created_at'),
'candidates', ['created_at'],
unique=False)
op.create_index(op.f('ix_candidates_user_registration'),
'candidates', ['user_registration'],
unique=False)
op.create_table(
'predictions', sa.Column('prediction_id', sa.Integer(),
nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('predicted_at', sa.DateTime(), nullable=True),
sa.Column('user_summary', mysql.JSON(), nullable=True),
sa.Column('scores', mysql.JSON(), nullable=True),
sa.Column('pred_min', sa.Float(), nullable=True),
sa.Column('newcomer_predictions', mysql.JSON(), nullable=True),
sa.Column('pred_error', mysql.MEDIUMTEXT(), nullable=True),
sa.PrimaryKeyConstraint('prediction_id'))
op.create_index(op.f('ix_predictions_predicted_at'),
'predictions', ['predicted_at'],
unique=False)
op.create_index(op.f('ix_predictions_user_id'),
'predictions', ['user_id'],
unique=False)
def create_new_tables():
op.create_table('account_types',
sa.Column('account_type_id', mysql.INTEGER(unsigned=True), nullable=False, autoincrement=True),
sa.Column('account_type', sa.String(length=100), nullable=False),
sa.PrimaryKeyConstraint('account_type_id')
)
op.create_index(op.f('ix_account_types_account_type'), 'account_types', ['account_type'], unique=True)
op.create_table('accounts_new',
sa.Column('account_id', mysql.INTEGER(unsigned=True), nullable=False),
sa.Column('account_name', sa.String(length=256), nullable=False),
sa.Column('account_type_id', mysql.INTEGER(unsigned=True), nullable=False),
sa.Column('contacts', mysql.JSON(), nullable=False),
sa.Column('enabled', mysql.SMALLINT(unsigned=True), nullable=False),
sa.Column('required_roles', mysql.JSON(), nullable=True),
sa.ForeignKeyConstraint(
('account_type_id',),
['account_types.account_type_id'],
name='fk_account_account_type_id',
ondelete='CASCADE'
),
sa.PrimaryKeyConstraint('account_id')
)
op.create_index(op.f('ix_accounts_new_account_name'), 'accounts_new', ['account_name'], unique=True)
op.create_index(op.f('ix_accounts_new_account_type_id'), 'accounts_new', ['account_type_id'], unique=False)
op.create_table('account_properties',
sa.Column('property_id', mysql.INTEGER(unsigned=True), nullable=False, autoincrement=True),
sa.Column('account_id', mysql.INTEGER(unsigned=True), nullable=False),
sa.Column('name', sa.String(length=50), nullable=False),
sa.Column('value', mysql.JSON(), nullable=False),
sa.ForeignKeyConstraint(
('account_id',),
['accounts_new.account_id'],
name='fk_account_properties_account_id',
ondelete='CASCADE'
),
sa.PrimaryKeyConstraint('property_id', 'account_id')
)
op.create_index(op.f('ix_account_properties_account_id'), 'account_properties', ['account_id'], unique=False)
op.create_index(op.f('ix_account_properties_name'), 'account_properties', ['name'], unique=False)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'guid_user',
sa.Column('id', sa.BigInteger(), nullable=False),
sa.Column('guid', UUIDType(), nullable=True),
sa.Column('name', sa.Unicode(length=255), nullable=False),
sa.Column('address', mysql.JSON(), nullable=True),
sa.PrimaryKeyConstraint('id'),
sa.UniqueConstraint('guid'),
)
op.create_index(op.f('ix_guid_user_id'), 'guid_user', ['id'], unique=False)
def load_dialect_impl(self, dialect: dialects) -> DialectType:
if dialect.name == 'postgresql':
return dialect.type_descriptor(postgresql.JSON())
elif dialect.name == 'mysql':
if 'JSON' in dialect.ischema_names:
return dialect.type_descriptor(mysql.JSON())
else:
return dialect.type_descriptor(
VARCHAR(self._MAX_VARCHAR_LIMIT)
)
else:
return dialect.type_descriptor(VARCHAR(self._MAX_VARCHAR_LIMIT))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('doctype',
sa.Column('name', sa.String(length=120), nullable=False),
sa.PrimaryKeyConstraint('name'),
sa.UniqueConstraint('name'))
op.create_table('wfstatus',
sa.Column('name', sa.String(length=120), nullable=False),
sa.PrimaryKeyConstraint('name'),
sa.UniqueConstraint('name'))
op.create_table(
'wfaction', sa.Column('name', sa.String(length=120), nullable=False),
sa.Column('assocated_doctype_name',
sa.String(length=120),
nullable=True),
sa.Column('need_prev_status', sa.String(length=120), nullable=False),
sa.Column('need_current_status', sa.String(length=120),
nullable=False),
sa.Column('leads_to_status', sa.String(length=120), nullable=False),
sa.Column('permitted_to_roles', mysql.JSON(), nullable=True),
sa.ForeignKeyConstraint(
['assocated_doctype_name'],
['doctype.name'],
), sa.PrimaryKeyConstraint('name'), sa.UniqueConstraint('name'))
op.create_table(
'wfdoc',
sa.Column('primvalue_of_docdata',
sa.String(length=500),
nullable=False),
sa.Column('assocated_doctype_name',
sa.String(length=120),
nullable=True),
sa.Column('prev_status', sa.String(length=120), nullable=True),
sa.Column('current_status', sa.String(length=120), nullable=True),
sa.Column('doc_data', mysql.JSON(), nullable=True),
sa.ForeignKeyConstraint(
['assocated_doctype_name'],
['doctype.name'],
), sa.PrimaryKeyConstraint('primvalue_of_docdata'),
sa.UniqueConstraint('primvalue_of_docdata'))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.drop_column('servers', 'pillar_content')
op.create_table('salt_pillars',
sa.Column('id', mysql.INTEGER(display_width=11), nullable=False),
sa.Column('priority', mysql.INTEGER(display_width=11), autoincrement=False, nullable=True),
sa.Column('pillar_content', mysql.JSON(), nullable=True),
sa.Column('server_instance_id', mysql.VARCHAR(length=64), nullable=True),
sa.ForeignKeyConstraint(['server_instance_id'], [u'servers.instance_id'], name=u'salt_pillars_ibfk_1'),
sa.PrimaryKeyConstraint('id'),
mysql_default_charset=u'utf8',
mysql_engine=u'InnoDB'
)
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'organization_archive',
sa.Column('uuid', mysql.VARCHAR(length=128), nullable=False),
sa.Column('name', mysql.VARCHAR(length=128), nullable=True),
sa.Column('org_id', mysql.VARCHAR(length=128), nullable=True),
sa.Column('org_type', mysql.VARCHAR(length=128), nullable=True),
sa.Column('origin', mysql.VARCHAR(length=128), nullable=True),
sa.Column('description', mysql.VARCHAR(length=1024), nullable=True),
sa.Column('short_description',
mysql.VARCHAR(length=1024),
nullable=True),
sa.Column('url', mysql.VARCHAR(length=512), nullable=True),
sa.Column('duns_no', mysql.VARCHAR(length=36), nullable=True),
sa.Column('contacts', mysql.JSON(), nullable=False),
sa.Column('assets', mysql.JSON(), nullable=False),
sa.Column('metadata_ipfs_uri',
mysql.VARCHAR(length=255),
nullable=True),
sa.Column('groups', mysql.JSON(), nullable=False),
sa.Column('org_state', mysql.JSON(), nullable=False),
sa.PrimaryKeyConstraint('uuid'))
def upgrade():
op.create_table(
'enforcements',
sa.Column('enforcement_id',
mysql.INTEGER(unsigned=True),
nullable=False,
autoincrement=True),
sa.Column('account_id', mysql.INTEGER(unsigned=True)),
sa.Column('resource_id', sa.String(length=256), nullable=False),
sa.Column('action', sa.String(length=64), nullable=False),
sa.Column('timestamp',
mysql.DATETIME(timezone=False),
default=func.now()), sa.Column('metrics', mysql.JSON()),
sa.PrimaryKeyConstraint('enforcement_id'))
def downgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.add_column('links',
sa.Column('brokenLinkList', mysql.JSON(), nullable=True))
op.drop_constraint(None, 'links', type_='foreignkey')
op.drop_index(op.f('ix_links_domain'), table_name='links')
op.alter_column('links',
'domain',
existing_type=mysql.VARCHAR(length=128),
nullable=True)
op.drop_column('links', 'last_check_result_id')
op.drop_column('links', 'broken_links')
op.drop_index(op.f('ix_results_domain'), table_name='results')
op.drop_table('results')
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table(
'holddoc', sa.Column('name', sa.String(length=500), nullable=False),
sa.Column('target_role', sa.String(length=120), nullable=True),
sa.Column('reason', sa.String(length=120), nullable=True),
sa.Column('wfdoc_name', sa.String(length=120), nullable=True),
sa.Column('prev_status', sa.String(length=120), nullable=True),
sa.Column('current_status', sa.String(length=120), nullable=True),
sa.Column('doc_data', mysql.JSON(), nullable=True),
sa.ForeignKeyConstraint(
['wfdoc_name'],
['wfdoc.name'],
), sa.PrimaryKeyConstraint('name'), sa.UniqueConstraint('name'))
def upgrade():
# ### commands auto generated by Alembic - please adjust! ###
op.create_table('life_style_answers',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('user_id', sa.Integer(), nullable=True),
sa.Column('answers', mysql.JSON(), nullable=True),
sa.ForeignKeyConstraint(['user_id'], ['users.id'], ondelete='CASCADE'),
sa.PrimaryKeyConstraint('id')
)
op.create_table('life_style_questions',
sa.Column('id', sa.Integer(), autoincrement=True, nullable=False),
sa.Column('questions', mysql.JSON(), nullable=True),
sa.PrimaryKeyConstraint('id')
)
op.drop_constraint('admins_ibfk_1', 'admins', type_='foreignkey')
op.create_foreign_key(None, 'admins', 'users', ['user_id'], ['id'], ondelete='CASCADE')
op.drop_constraint('terms_agreements_ibfk_2', 'terms_agreements', type_='foreignkey')
op.create_foreign_key(None, 'terms_agreements', 'users', ['user_id'], ['id'], ondelete='CASCADE')
op.drop_constraint('users_ibfk_5', 'users', type_='foreignkey')
op.drop_constraint('users_ibfk_2', 'users', type_='foreignkey')
op.drop_constraint('users_ibfk_3', 'users', type_='foreignkey')
op.create_foreign_key(None, 'users', 'oauth_kakao', ['oauth_kakao_id'], ['id'], ondelete='CASCADE')
op.create_foreign_key(None, 'users', 'oauth_naver', ['oauth_naver_id'], ['id'], ondelete='CASCADE')
op.create_foreign_key(None, 'users', 'oauth_google', ['oauth_google_id'], ['id'], ondelete='CASCADE')
