migrations/auth/20221108_02_wxTr9-create-privileges-table.py


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

"""
Create privileges table
"""

from yoyo import step

__depends__ = {'20221108_01_CoxYh-create-the-groups-table'}

steps = [
    step(
        """
        CREATE TABLE privileges(
            privilege_id TEXT PRIMARY KEY,
            privilege_name TEXT NOT NULL
        ) WITHOUT ROWID
        """,
         "DROP TABLE IF EXISTS privileges")
]