blob: ce752efb03d124e50b01f35a56ab5f96e6aecb14 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
|
"""
Create resource_categories table
"""
from yoyo import step
__depends__ = {'20221108_02_wxTr9-create-privileges-table'}
steps = [
step(
"""
CREATE TABLE resource_categories(
resource_category_id TEXT PRIMARY KEY,
resource_category_key TEXT NOT NULL,
resource_category_description TEXT NOT NULL
) WITHOUT ROWID
""",
"DROP TABLE IF EXISTS resource_categories")
]
|
