Function create_key_value_table

apps/base/migrations/migrations_001.py:31–47

()

async def create_key_value_table():
    conn = connections.get("default")
    await conn.execute_script(
        """
        CREATE TABLE IF NOT EXISTS keyvalue
        (
            id         INTEGER                             not null
                primary key autoincrement,
            key        VARCHAR(255)                        not null
                unique,
            value      JSON,
            created_at TIMESTAMP default CURRENT_TIMESTAMP not null
        );
        CREATE INDEX IF NOT EXISTS idx_keyvalue_key_eab890
            on keyvalue (key);
    """
    )


async def migrate():