+def create_tables(engine):
+ metadata = MetaData()
+ columns=[]
+ columns.append(Column('public_id', Integer, primary_key=True))
+ columns.append(Column('path', String(2048), nullable=False))
+ columns.append(Column('active', Boolean, nullable=False, default=True))
+ public = Table('public', metadata, *columns, mysql_engine='InnoDB', sqlite_autoincrement=True)
+ # place an index on path
+ Index('idx_public_path', public.c.path, unique=True)
+ metadata.create_all(engine)
+ return metadata.sorted_tables