diff options
| author | Jokler <jokler@protonmail.com> | 2020-06-21 06:37:46 +0200 |
|---|---|---|
| committer | Jokler <jokler@protonmail.com> | 2020-06-21 06:37:46 +0200 |
| commit | e6468b012d5b33dd16992652da57f11dd5a6e82f (patch) | |
| tree | e89add440df79d4036b9b44d8c77ee6d69e67201 /src/schema.rs | |
| download | joklerpoints-master.tar.gz joklerpoints-master.zip | |
Diffstat (limited to 'src/schema.rs')
| -rw-r--r-- | src/schema.rs | 34 |
1 files changed, 34 insertions, 0 deletions
diff --git a/src/schema.rs b/src/schema.rs new file mode 100644 index 0000000..2855927 --- /dev/null +++ b/src/schema.rs @@ -0,0 +1,34 @@ +table! { + transactions (id) { + id -> Unsigned<Bigint>, + date -> Timestamp, + sender -> Unsigned<Bigint>, + receiver -> Unsigned<Bigint>, + amount -> Unsigned<Bigint>, + sender_balance -> Unsigned<Bigint>, + receiver_balance -> Unsigned<Bigint>, + purpose -> Varchar, + } +} + +table! { + passwords (id) { + id -> Unsigned<Bigint>, + hash -> Char, + } +} + +table! { + users (id) { + id -> Unsigned<Bigint>, + power_level -> Integer, + name -> Varchar, + created -> Timestamp, + balance -> Unsigned<Bigint>, + } +} + +joinable!(passwords -> users (id)); + +allow_tables_to_appear_in_same_query!(transactions, users,); +allow_tables_to_appear_in_same_query!(passwords, users,); |
