mirror of
https://github.com/MikroWizard/mikroman.git
synced 2025-06-21 12:28:59 +02:00
23 lines
639 B
Python
23 lines
639 B
Python
|
|
||
|
|
# 005_device_groups_devices_rel.py
|
||
|
|
|
||
|
|
def migrate(migrator, database, fake=False, **kwargs):
|
||
|
|
|
||
|
|
# an example class for demonstrating CRUD...
|
||
|
|
|
||
|
|
migrator.sql("""CREATE TABLE device_groups_devices_rel(
|
||
|
|
id serial PRIMARY KEY NOT NULL,
|
||
|
|
group_id serial REFERENCES device_groups(id),
|
||
|
|
device_id serial REFERENCES devices(id),
|
||
|
|
created timestamp not null default CURRENT_TIMESTAMP,
|
||
|
|
modified timestamp not null default CURRENT_TIMESTAMP,
|
||
|
|
UNIQUE(group_id, device_id)
|
||
|
|
)""")
|
||
|
|
|
||
|
|
|
||
|
|
|
||
|
|
def rollback(migrator, database, fake=False, **kwargs):
|
||
|
|
|
||
|
|
migrator.sql("""DROP TABLE device_groups_devices_rel""")
|
||
|
|
|