Permalink
Browse files

Bug 643039: add mysql_engine to slavealloc model; r=lsblakk

  • Loading branch information...
djmitche committed Mar 19, 2011
1 parent ea30069 commit 569d8b3bf601b357f90d031348299ece731d4e8a
Showing with 11 additions and 0 deletions.
  1. +11 −0 lib/python/slavealloc/data/model.py
@@ -13,43 +13,51 @@
distros = sa.Table('distros', metadata,
sa.Column('distroid', sa.Integer, primary_key=True),
sa.Column('name', sa.Text, nullable=False),
+ mysql_engine="InnoDB",
)
datacenters = sa.Table('datacenters', metadata,
sa.Column('dcid', sa.Integer, primary_key=True),
sa.Column('name', sa.Text, nullable=False),
+ mysql_engine="InnoDB",
)
bitlengths = sa.Table('bitlengths', metadata,
sa.Column('bitsid', sa.Integer, primary_key=True),
sa.Column('name', sa.Text, nullable=False),
+ mysql_engine="InnoDB",
)
speeds = sa.Table('speeds', metadata,
sa.Column('speedid', sa.Integer, primary_key=True),
sa.Column('name', sa.Text, nullable=False),
+ mysql_engine="InnoDB",
)
purposes = sa.Table('purposes', metadata,
sa.Column('purposeid', sa.Integer, primary_key=True),
sa.Column('name', sa.Text, nullable=False),
+ mysql_engine="InnoDB",
)
trustlevels = sa.Table('trustlevels', metadata,
sa.Column('trustid', sa.Integer, primary_key=True),
sa.Column('name', sa.Text, nullable=False),
+ mysql_engine="InnoDB",
)
environments = sa.Table('environments', metadata,
sa.Column('envid', sa.Integer, primary_key=True),
sa.Column('name', sa.Text, nullable=False),
+ mysql_engine="InnoDB",
)
# pools
pools = sa.Table('pools', metadata,
sa.Column('poolid', sa.Integer, primary_key=True),
sa.Column('name', sa.Text, nullable=False),
+ mysql_engine="InnoDB",
)
# slave passwords, based on pool and distro
@@ -62,6 +70,7 @@
sa.Column('poolid', sa.Integer, sa.ForeignKey('pools.poolid'), nullable=False),
sa.Column('distroid', sa.Integer, sa.ForeignKey('distros.distroid')),
sa.Column('password', sa.Text, nullable=False),
+ mysql_engine="InnoDB",
)
# all slaves
@@ -89,6 +98,7 @@
# state
sa.Column('current_masterid', sa.Integer, sa.ForeignKey('masters.masterid')),
+ mysql_engine="InnoDB",
)
# masters
@@ -101,6 +111,7 @@
sa.Column('pb_port', sa.Integer, nullable=False),
sa.Column('dcid', sa.Integer, sa.ForeignKey('datacenters.dcid'), nullable=False),
sa.Column('poolid', sa.Integer, sa.ForeignKey('pools.poolid'), nullable=False),
+ mysql_engine="InnoDB",
)
# indices

0 comments on commit 569d8b3

Please sign in to comment.