...

Text file src/github.com/ory/x/popx/stub/migrations/source/20191100000002_requests.up.fizz

Documentation: github.com/ory/x/popx/stub/migrations/source

     1create_table("selfservice_login_requests") {
     2	t.Column("id", "uuid", {primary: true})
     3  t.Column("request_url", "string", {"size": 2048})
     4  t.Column("issued_at", "timestamp", { "default_raw": "CURRENT_TIMESTAMP" })
     5  t.Column("expires_at", "timestamp")
     6  t.Column("active_method", "string", {"size": 32})
     7  t.Column("csrf_token", "string")
     8}
     9
    10create_table("selfservice_login_request_methods") {
    11	t.Column("id", "uuid", {primary: true})
    12  t.Column("method", "string", {"size": 32})
    13  t.Column("selfservice_login_request_id", "uuid")
    14  t.Column("config", "json")
    15
    16  t.ForeignKey("selfservice_login_request_id", {"selfservice_login_requests": ["id"]}, {"on_delete": "cascade"})
    17}
    18
    19create_table("selfservice_registration_requests") {
    20	t.Column("id", "uuid", {primary: true})
    21  t.Column("request_url", "string", {"size": 2048})
    22  t.Column("issued_at", "timestamp", { "default_raw": "CURRENT_TIMESTAMP" })
    23  t.Column("expires_at", "timestamp")
    24  t.Column("active_method", "string", {"size": 32})
    25  t.Column("csrf_token", "string")
    26}
    27
    28create_table("selfservice_registration_request_methods") {
    29  t.Column("id", "uuid", {primary: true})
    30  t.Column("method", "string", {"size": 32})
    31  t.Column("selfservice_registration_request_id", "uuid")
    32  t.Column("config", "json")
    33
    34  t.ForeignKey("selfservice_registration_request_id", {"selfservice_registration_requests": ["id"]}, {"on_delete": "cascade"})
    35}
    36
    37create_table("selfservice_profile_management_requests") {
    38	t.Column("id", "uuid", {primary: true})
    39  t.Column("request_url", "string", {"size": 2048})
    40  t.Column("issued_at", "timestamp", { "default_raw": "CURRENT_TIMESTAMP" })
    41  t.Column("expires_at", "timestamp")
    42  t.Column("form", "json")
    43  t.Column("update_successful", "bool")
    44  t.Column("identity_id", "uuid")
    45
    46  t.ForeignKey("identity_id", {"identities": ["id"]}, {"on_delete": "cascade"})
    47}

View as plain text