Differential D1723 Diff 7177 source/tools/rdb/src/schema.rs

Changeset View

Standalone View

source/tools/rdb/src/schema.rs

				table! {
				ddb_ip_bans (ddb_id) {
				ddb_id -> Unsigned<Bigint>,
				ddb_reason -> Varchar,
				ddb_ban_type -> Unsigned<Tinyint>,
				ddb_creation_date -> Unsigned<Bigint>,
				ddb_expiration_date -> Nullable<Unsigned<Bigint>>,
				ddb_ipv4_p0 -> Nullable<Unsigned<Tinyint>>,
				ddb_ipv4_p1 -> Nullable<Unsigned<Tinyint>>,
				ddb_ipv4_p2 -> Nullable<Unsigned<Tinyint>>,
				ddb_ipv4_p3 -> Nullable<Unsigned<Tinyint>>,
				ddb_ipv6_p0 -> Nullable<Unsigned<Smallint>>,
				ddb_ipv6_p1 -> Nullable<Unsigned<Smallint>>,
				ddb_ipv6_p2 -> Nullable<Unsigned<Smallint>>,
				ddb_ipv6_p3 -> Nullable<Unsigned<Smallint>>,
				ddb_ipv6_p4 -> Nullable<Unsigned<Smallint>>,
				ddb_ipv6_p5 -> Nullable<Unsigned<Smallint>>,
				ddb_ipv6_p6 -> Nullable<Unsigned<Smallint>>,
				ddb_ipv6_p7 -> Nullable<Unsigned<Smallint>>,
				}
				}

				table! {
				ddb_recent_registers (ddb_id) {
				ddb_id -> Unsigned<Bigint>,
				ddb_user_id -> Unsigned<Bigint>,
				ddb_register_time -> Unsigned<Bigint>,
				ddb_ipv4_p0 -> Nullable<Unsigned<Tinyint>>,
				ddb_ipv4_p1 -> Nullable<Unsigned<Tinyint>>,
				ddb_ipv4_p2 -> Nullable<Unsigned<Tinyint>>,
				ddb_ipv4_p3 -> Nullable<Unsigned<Tinyint>>,
				ddb_ipv6_p0 -> Nullable<Unsigned<Smallint>>,
				ddb_ipv6_p1 -> Nullable<Unsigned<Smallint>>,
				ddb_ipv6_p2 -> Nullable<Unsigned<Smallint>>,
				ddb_ipv6_p3 -> Nullable<Unsigned<Smallint>>,
				ddb_ipv6_p4 -> Nullable<Unsigned<Smallint>>,
				ddb_ipv6_p5 -> Nullable<Unsigned<Smallint>>,
				ddb_ipv6_p6 -> Nullable<Unsigned<Smallint>>,
				ddb_ipv6_p7 -> Nullable<Unsigned<Smallint>>,
				}
				}

				table! {
				ddb_replays (ddb_id) {
				ddb_id -> Unsigned<Bigint>,
				ddb_submitter_id -> Unsigned<Bigint>,
				ddb_title -> Varchar,
				ddb_submission_date -> Unsigned<Bigint>,
				ddb_msg_body -> Varchar,
				ddb_review_status -> Bit,
				ddb_timestamp_day -> Char,
				ddb_multiplayer -> Bool,
				ddb_rated_game -> Bool,
				ddb_players -> Varchar,
				ddb_map_name -> Varchar,
				ddb_size -> Unsigned<Smallint>,
				ddb_population -> Unsigned<Smallint>,
				ddb_duration -> Unsigned<Integer>,
				ddb_victory_condition -> Varchar,
				ddb_mods -> Varchar,
				ddb_engine_version -> Varchar,
				}
				}

				table! {
				ddb_users (ddb_id) {
				ddb_id -> Unsigned<Bigint>,
				ddb_username -> Varchar,
				ddb_salt -> Binary,
				ddb_password_hashed -> Blob,
				ddb_scrypt_log_n -> Bit,
				ddb_scrypt_r -> Bit,
				ddb_scrypt_p -> Bit,
				ddb_privilege_level -> Bit,
				}
				}

				table! {
				ddb_user_bans (ddb_id) {
				ddb_id -> Unsigned<Bigint>,
				ddb_reason -> Varchar,
				ddb_ban_type -> Unsigned<Tinyint>,
				ddb_creation_date -> Unsigned<Bigint>,
				ddb_expiration_date -> Nullable<Unsigned<Bigint>>,
				ddb_user_id -> Unsigned<Bigint>,
				}
				}

				allow_tables_to_appear_in_same_query!(
				ddb_ip_bans,
				ddb_recent_registers,
				ddb_replays,
				ddb_users,
				ddb_user_bans,
				);