mirror of
https://github.com/MikroWizard/mikroman.git
synced 2025-06-23 21:58:38 +02:00
19 lines
485 B
Python
19 lines
485 B
Python
|
|
# 029_user_group_perm.py
|
|
|
|
def migrate(migrator, database, fake=False, **kwargs):
|
|
|
|
migrator.sql("""CREATE TABLE user_group_perm_rel(
|
|
id serial PRIMARY KEY NOT NULL,
|
|
group_id serial REFERENCES device_groups(id),
|
|
user_id uuid REFERENCES users(id),
|
|
perm_id serial REFERENCES permissions(id),
|
|
UNIQUE(group_id, user_id)
|
|
)""")
|
|
|
|
|
|
|
|
def rollback(migrator, database, fake=False, **kwargs):
|
|
|
|
migrator.sql("""DROP TABLE user_group_perm_rel""")
|
|
|