aboutsummaryrefslogtreecommitdiff
path: root/src/schema.rs
diff options
context:
space:
mode:
Diffstat (limited to 'src/schema.rs')
-rw-r--r--src/schema.rs66
1 files changed, 66 insertions, 0 deletions
diff --git a/src/schema.rs b/src/schema.rs
new file mode 100644
index 0000000..2f0daba
--- /dev/null
+++ b/src/schema.rs
@@ -0,0 +1,66 @@
+table! {
+ users(userid) {
+ userid -> Serial,
+ email -> VarChar,
+ firstname -> VarChar,
+ lastname -> VarChar,
+ password -> VarChar,
+ joindate -> Date,
+ activated -> Bool,
+ }
+}
+table! {
+ activation_keys(code) {
+ code -> VarChar,
+ userid -> Serial,
+ }
+}
+table! {
+ games(gameid) {
+ gameid -> Serial,
+ title -> VarChar,
+ gametypeid -> Serial,
+ players -> SmallInt,
+ waitfor -> Integer,
+ lastturn -> Date,
+ gamestate -> Integer,
+ }
+}
+table! {
+ allegiances(gameid, userid) {
+ gameid -> Serial,
+ userid -> Serial,
+ allegiance -> VarChar,
+ ordernum -> SmallInt,
+ playing -> SmallInt,
+ }
+}
+table! {
+ regions(regionid) {
+ regionid -> Serial,
+ name -> VarChar,
+ abbreviation -> Char,
+ bonus -> Integer,
+ }
+}
+table! {
+ nationstates(nationid) {
+ nationid -> Serial,
+ regionid -> Serial,
+ name -> VarChar,
+ abbreviation -> Char,
+ }
+}
+table! {
+ borders(nationid, borderid) {
+ nationid -> Serial,
+ borderid -> Serial,
+ }
+}
+table! {
+ regions_nationstates(gameid, nationid) {
+ gameid -> Serial,
+ nationid -> Serial,
+ userid -> Serial,
+ }
+} \ No newline at end of file