1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65

#[cfg(feature = "plugin_auth")]
table! {
  role_permissions (role) {
      role -> Text,
      permission -> Text,
      created_at -> Timestamptz,
  }
}

#[cfg(feature = "plugin_auth")]
table! {
  user_permissions (user_id, permission) {
      user_id -> Int4,
      permission -> Text,
      created_at -> Timestamptz,
  }
}

#[cfg(feature = "plugin_auth")]
table! {
  user_roles (user_id, role) {
      user_id -> Int4,
      role -> Text,
      created_at -> Timestamptz,
  }
}

#[cfg(feature = "plugin_auth")]
table! {
  user_sessions (id) {
      id -> Int4,
      user_id -> Int4,
      refresh_token -> Text,
      device -> Nullable<Text>,
      created_at -> Timestamptz,
      updated_at -> Timestamptz,
  }
}

#[cfg(feature = "plugin_auth")]
table! {
  users (id) {
      id -> Int4,
      email -> Text,
      hash_password -> Text,
      activated -> Bool,
      created_at -> Timestamptz,
      updated_at -> Timestamptz,
  }
}

#[cfg(feature = "plugin_auth")]
joinable!(user_permissions -> users (user_id));
#[cfg(feature = "plugin_auth")]
joinable!(user_roles -> users (user_id));
#[cfg(feature = "plugin_auth")]
joinable!(user_sessions -> users (user_id));

allow_tables_to_appear_in_same_query!(
    role_permissions,
    user_permissions,
    user_roles,
    user_sessions,
    users,
);