blob: 2b55c2b9dd7ffdb69a702f4f4b75aeb1bcb49045 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
|
"""
Create 'generic_roles' table
The roles in this table will be template roles, defining some common roles that
can be used within the groups.
They could also be used to define system-level roles, though those will not be
provided to the "common" users.
"""
from yoyo import step
__depends__ = {'20221110_05_BaNtL-create-roles-table'}
steps = [
step(
"""
CREATE TABLE IF NOT EXISTS generic_roles(
role_id TEXT PRIMARY KEY,
role_name TEXT NOT NULL
) WITHOUT ROWID
""",
"DROP TABLE IF EXISTS generic_roles")
]
|
