lnbits-jitsi-extension/migrations.py at main · nochiel/lnbits-jitsi-extension · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
async def m006_initial(db):         # TODO(nochiel) Reset this to m001 when ready to PR.

    await db.execute(
            """
            CREATE TABLE jitsi.conferences (
                "name" TEXT NOT NULL,
                admin TEXT REFERENCES accounts(id),
                PRIMARY KEY(name, admin)
                );
            """
            )

    await db.execute(
            """
            CREATE TABLE jitsi.participants (
                id TEXT PRIMARY KEY,
                user TEXT REFERENCES accounts(id),
                conference TEXT REFERENCES 'jitsi.conferences(name)',
                wallet TEXT REFERENCES wallets(id)
                );
            """
            )