github.com/icyphox/x@v0.0.355-0.20220311094250-029bd783e8b8/popx/stub/migrations/source/20191100000002_requests.up.fizz (about)

     1  create_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  
    10  create_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  
    19  create_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  
    28  create_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  
    37  create_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  }