diff options
-rw-r--r-- | apscheduler/jobstores/sqlalchemy.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/apscheduler/jobstores/sqlalchemy.py b/apscheduler/jobstores/sqlalchemy.py index 4e0c0e2..f8a3c15 100644 --- a/apscheduler/jobstores/sqlalchemy.py +++ b/apscheduler/jobstores/sqlalchemy.py @@ -44,10 +44,10 @@ class SQLAlchemyJobStore(BaseJobStore): else: raise ValueError('Need either "engine" or "url" defined') - # 767 = max key length in MySQL for InnoDB tables, 25 = precision that translates to an 8-byte float + # 191 = max key length in MySQL for InnoDB/utf8mb4 tables, 25 = precision that translates to an 8-byte float self.jobs_t = Table( tablename, metadata, - Column('id', Unicode(767, _warn_on_bytestring=False), primary_key=True), + Column('id', Unicode(191, _warn_on_bytestring=False), primary_key=True), Column('next_run_time', Float(25), index=True), Column('job_state', LargeBinary, nullable=False) ) |