Constant Field Values

Contents

• com.djrapitops.*

com.djrapitops.*

com.djrapitops.plan.component.Component

Modifier and Type	Constant Field	Value
public static final char	AMPERSAND	'&'
public static final char	SECTION	'\u00a7'

com.djrapitops.plan.delivery.domain.mutators.ActivityIndex

Modifier and Type	Constant Field	Value
public static final double	ACTIVE	3.0
public static final double	IRREGULAR	1.0
public static final double	REGULAR	2.0
public static final double	VERY_ACTIVE	3.75

com.djrapitops.plan.delivery.rendering.json.Trend

Modifier and Type	Constant Field	Value
public static final boolean	REVERSED	true

com.djrapitops.plan.delivery.web.resolver.MimeType

Modifier and Type	Constant Field	Value
public static final String	CSS	"text/css"
public static final String	FAVICON	"image/x-icon"
public static final String	FONT_BYTESTREAM	"application/octet-stream"
public static final String	FONT_EOT	"application/vnd.ms-fontobject"
public static final String	FONT_TTF	"application/x-font-ttf"
public static final String	FONT_WOFF	"application/font-woff"
public static final String	FONT_WOFF2	"application/font-woff2"
public static final String	HTML	"text/html"
public static final String	IMAGE	"image/gif"
public static final String	JS	"text/javascript"
public static final String	JSON	"application/json"

com.djrapitops.plan.delivery.webserver.CacheStrategy

Modifier and Type	Constant Field	Value
public static final String	CACHE_IN_BROWSER	"max-age: 2592000"
public static final String	CHECK_ETAG	"no-cache"
public static final String	CHECK_ETAG_USER_SPECIFIC	"no-cache, private"

com.djrapitops.plan.delivery.webserver.resolver.StaticResourceResolver

Modifier and Type	Constant Field	Value
public static final String	PATH_REGEX	"^.*/(static)/.*"

com.djrapitops.plan.exceptions.database.DBOpException

Modifier and Type	Constant Field	Value
public static final String	CONSTRAINT_VIOLATION	"Constraint Violation"
public static final String	DUPLICATE_KEY	"Duplicate key"
public static final String	MODIFIED_SINCE_LAST_READ	"Modified since last read"

com.djrapitops.plan.extension.implementation.builder.ComponentDataValue

Modifier and Type	Constant Field	Value
public static final int	MAX_LENGTH	500

com.djrapitops.plan.extension.implementation.builder.StringDataValue

Modifier and Type	Constant Field	Value
public static final int	MAX_LENGTH	250

com.djrapitops.plan.gathering.afk.AFKTracker

Modifier and Type	Constant Field	Value
public static final long	IGNORES_AFK	-1L

com.djrapitops.plan.gathering.domain.GMTimes

Modifier and Type	Constant Field	Value
public static final String	ADVENTURE	"ADVENTURE"
public static final String	CREATIVE	"CREATIVE"
public static final String	SPECTATOR	"SPECTATOR"
public static final String	SURVIVAL	"SURVIVAL"

com.djrapitops.plan.storage.database.sql.building.Sql

Modifier and Type	Constant Field	Value
public static final String	AND	" AND "
public static final String	BOOL	"boolean"
public static final String	DELETE_FROM	"DELETE FROM "
public static final String	DISTINCT	"DISTINCT "
public static final String	DOUBLE	"double"
public static final String	FROM	" FROM "
public static final String	GROUP_BY	" GROUP BY "
public static final String	ID	"id"
public static final String	INNER_JOIN	" JOIN "
public static final String	INT	"integer"
public static final String	IS_NOT_NULL	" IS NOT NULL"
public static final String	IS_NULL	" IS NULL"
public static final String	LEFT_JOIN	" LEFT JOIN "
public static final String	LIMIT	" LIMIT "
public static final String	LONG	"bigint"
public static final String	OFFSET	" OFFSET "
public static final String	OR	" OR "
public static final String	ORDER_BY	" ORDER BY "
public static final String	P_UUID	"uuid"
public static final String	SELECT	"SELECT "
public static final String	TEXT	"TEXT"
public static final String	UNION	" UNION "
public static final String	UNION_ALL	" UNION ALL "
public static final String	WHERE	" WHERE "

com.djrapitops.plan.storage.database.sql.tables.AccessLogTable

Modifier and Type	Constant Field	Value
public static final String	FROM_IP	"from_ip"
public static final String	ID	"id"
public static final String	INSERT_NO_USER	"INSERT INTO plan_access_log (time,from_ip,request_method,request_uri,response_code) VALUES (?, ?, ?, ?, ?)"
public static final String	REQUEST_METHOD	"request_method"
public static final String	REQUEST_URI	"request_uri"
public static final String	RESPONSE_CODE	"response_code"
public static final String	TABLE_NAME	"plan_access_log"
public static final String	TIME	"time"

com.djrapitops.plan.storage.database.sql.tables.AllowlistBounceTable

Modifier and Type	Constant Field	Value
public static final String	ID	"id"
public static final String	INCREMENT_TIMES_STATEMENT	"UPDATE plan_allowlist_bounce SET times=times+1, last_bounce=? WHERE uuid=? AND server_id=(SELECT plan_servers.id FROM plan_servers WHERE plan_servers.uuid=? LIMIT 1)"
public static final String	INSERT_STATEMENT	"INSERT INTO plan_allowlist_bounce (uuid,name,server_id,times,last_bounce) VALUES (?,?,(SELECT plan_servers.id FROM plan_servers WHERE plan_servers.uuid=? LIMIT 1),?,?)"
public static final String	LAST_BOUNCE	"last_bounce"
public static final String	SERVER_ID	"server_id"
public static final String	TABLE_NAME	"plan_allowlist_bounce"
public static final String	TIMES	"times"
public static final String	USER_NAME	"name"
public static final String	UUID	"uuid"

com.djrapitops.plan.storage.database.sql.tables.CookieTable

Modifier and Type	Constant Field	Value
public static final String	COOKIE	"cookie"
public static final String	DELETE_ALL_STATEMENT	"DELETE FROM plan_cookies"
public static final String	DELETE_BY_COOKIE_STATEMENT	"DELETE FROM plan_cookies WHERE cookie=?"
public static final String	DELETE_BY_USER_STATEMENT	"DELETE FROM plan_cookies WHERE web_username=?"
public static final String	DELETE_OLDER_STATEMENT	"DELETE FROM plan_cookies WHERE expires<=?"
public static final String	EXPIRES	"expires"
public static final String	ID	"id"
public static final String	INSERT_STATEMENT	"INSERT INTO plan_cookies (web_username,cookie,expires,ip_address) VALUES (?,?,?,?)"
public static final String	IP_ADDRESS	"ip_address"
public static final String	TABLE_NAME	"plan_cookies"
public static final String	WEB_USERNAME	"web_username"

com.djrapitops.plan.storage.database.sql.tables.GeoInfoTable

Modifier and Type	Constant Field	Value
public static final String	GEOLOCATION	"geolocation"
public static final String	ID	"id"
public static final String	INSERT_STATEMENT	"INSERT INTO plan_geolocations (user_id,geolocation,last_used) VALUES ((SELECT plan_users.id FROM plan_users WHERE plan_users.uuid=? LIMIT 1), ?, ?)"
public static final String	LAST_USED	"last_used"
public static final String	TABLE_NAME	"plan_geolocations"
public static final String	UPDATE_STATEMENT	"UPDATE plan_geolocations SET last_used=? WHERE user_id=(SELECT plan_users.id FROM plan_users WHERE plan_users.uuid=? LIMIT 1) AND geolocation=?"
public static final String	USER_ID	"user_id"

com.djrapitops.plan.storage.database.sql.tables.JoinAddressTable

Modifier and Type	Constant Field	Value
public static final String	DEFAULT_VALUE_FOR_LOOKUP	"unknown"
public static final String	ID	"id"
public static final String	INSERT_STATEMENT	"INSERT INTO plan_join_address (join_address) VALUES (?)"
public static final String	JOIN_ADDRESS	"join_address"
public static final int	JOIN_ADDRESS_MAX_LENGTH	191
public static final String	SELECT_ID	"(SELECT id FROM plan_join_address WHERE join_address=?)"
public static final String	TABLE_NAME	"plan_join_address"

com.djrapitops.plan.storage.database.sql.tables.KillsTable

Modifier and Type	Constant Field	Value
public static final String	DATE	"date"
public static final String	ID	"id"
public static final String	INSERT_STATEMENT	"INSERT INTO plan_kills (session_id,killer_uuid,victim_uuid,server_uuid,date,weapon) VALUES ((SELECT plan_sessions.id FROM plan_sessions WHERE plan_sessions.user_id=(SELECT plan_users.id FROM plan_users WHERE plan_users.uuid=? LIMIT 1) AND plan_sessions.server_id=(SELECT plan_servers.id FROM plan_servers WHERE plan_servers.uuid=? LIMIT 1) AND session_start=? AND session_end=? LIMIT 1), ?, ?, ?, ?, ?)"
public static final String	KILLER_UUID	"killer_uuid"
public static final String	SERVER_UUID	"server_uuid"
public static final String	SESSION_ID	"session_id"
public static final String	TABLE_NAME	"plan_kills"
public static final String	VICTIM_UUID	"victim_uuid"
public static final String	WEAPON	"weapon"
public static final int	WEAPON_COLUMN_LENGTH	30

com.djrapitops.plan.storage.database.sql.tables.NicknamesTable

Modifier and Type	Constant Field	Value
public static final String	ID	"id"
public static final String	INSERT_STATEMENT	"INSERT INTO plan_nicknames (uuid,server_uuid,nickname,last_used) VALUES (?, ?, ?, ?)"
public static final String	LAST_USED	"last_used"
public static final String	NICKNAME	"nickname"
public static final String	SERVER_UUID	"server_uuid"
public static final String	TABLE_NAME	"plan_nicknames"
public static final String	UPDATE_STATEMENT	"UPDATE plan_nicknames SET last_used=? WHERE nickname=? AND uuid=? AND server_uuid=?"
public static final String	USER_UUID	"uuid"

com.djrapitops.plan.storage.database.sql.tables.PingTable

Modifier and Type	Constant Field	Value
public static final String	AVG_PING	"avg_ping"
public static final String	DATE	"date"
public static final String	ID	"id"
public static final String	INSERT_STATEMENT	"INSERT INTO plan_ping (user_id,server_id,date,min_ping,max_ping,avg_ping) VALUES ((SELECT plan_users.id FROM plan_users WHERE plan_users.uuid=? LIMIT 1),(SELECT plan_servers.id FROM plan_servers WHERE plan_servers.uuid=? LIMIT 1), ?, ?, ?, ?)"
public static final String	MAX_PING	"max_ping"
public static final String	MIN_PING	"min_ping"
public static final String	SERVER_ID	"server_id"
public static final String	TABLE_NAME	"plan_ping"
public static final String	USER_ID	"user_id"

com.djrapitops.plan.storage.database.sql.tables.PluginVersionTable

Modifier and Type	Constant Field	Value
public static final String	ID	"id"
public static final String	INSERT_STATEMENT	"INSERT INTO plan_plugin_versions (server_id,plugin_name,version,modified) VALUES ((SELECT plan_servers.id FROM plan_servers WHERE plan_servers.uuid=? LIMIT 1), ?, ?, ?)"
public static final int	MAX_NAME_LENGTH	100
public static final int	MAX_VERSION_LENGTH	255
public static final String	MODIFIED	"modified"
public static final String	PLUGIN_NAME	"plugin_name"
public static final String	SERVER_ID	"server_id"
public static final String	TABLE_NAME	"plan_plugin_versions"
public static final String	VERSION	"version"

com.djrapitops.plan.storage.database.sql.tables.ServerTable

Modifier and Type	Constant Field	Value
public static final String	ID	"id"
public static final String	INSTALLED	"is_installed"
public static final String	NAME	"name"
public static final String	PLAN_VERSION	"plan_version"
public static final String	PROXY	"is_proxy"
public static final String	SELECT_SERVER_ID	"(SELECT plan_servers.id FROM plan_servers WHERE plan_servers.uuid=? LIMIT 1)"
public static final String	SERVER_UUID	"uuid"
public static final String	TABLE_NAME	"plan_servers"
public static final String	WEB_ADDRESS	"web_address"

com.djrapitops.plan.storage.database.sql.tables.SessionsTable

Modifier and Type	Constant Field	Value
public static final String	AFK_TIME	"afk_time"
public static final String	DEATHS	"deaths"
public static final String	ID	"id"
public static final String	INSERT_STATEMENT	"INSERT INTO plan_sessions (user_id,session_start,session_end,deaths,mob_kills,afk_time,server_id,join_address_id) VALUES ((SELECT plan_users.id FROM plan_users WHERE plan_users.uuid=? LIMIT 1), ?, ?, ?, ?, ?, (SELECT plan_servers.id FROM plan_servers WHERE plan_servers.uuid=? LIMIT 1), (SELECT id FROM plan_join_address WHERE join_address=?))"
public static final String	JOIN_ADDRESS_ID	"join_address_id"
public static final String	MOB_KILLS	"mob_kills"
public static final String	SELECT_SESSION_ID_STATEMENT	"(SELECT plan_sessions.id FROM plan_sessions WHERE plan_sessions.user_id=(SELECT plan_users.id FROM plan_users WHERE plan_users.uuid=? LIMIT 1) AND plan_sessions.server_id=(SELECT plan_servers.id FROM plan_servers WHERE plan_servers.uuid=? LIMIT 1) AND session_start=? AND session_end=? LIMIT 1)"
public static final String	SERVER_ID	"server_id"
public static final String	SESSION_END	"session_end"
public static final String	SESSION_START	"session_start"
public static final String	TABLE_NAME	"plan_sessions"
public static final String	USER_ID	"user_id"

com.djrapitops.plan.storage.database.sql.tables.SettingsTable

Modifier and Type	Constant Field	Value
public static final String	CONFIG_CONTENT	"content"
public static final String	ID	"id"
public static final String	INSERT_STATEMENT	"INSERT INTO plan_settings (server_uuid,updated,content) VALUES (?,?,?)"
public static final String	SERVER_UUID	"server_uuid"
public static final String	TABLE_NAME	"plan_settings"
public static final String	UPDATE_STATEMENT	"UPDATE plan_settings SET content=?,updated=? WHERE server_uuid=? AND content!=?"
public static final String	UPDATED	"updated"

com.djrapitops.plan.storage.database.sql.tables.TPSTable

Modifier and Type	Constant Field	Value
public static final String	CHUNKS	"chunks_loaded"
public static final String	CPU_USAGE	"cpu_usage"
public static final String	DATE	"date"
public static final String	ENTITIES	"entities"
public static final String	FREE_DISK	"free_disk_space"
public static final String	ID	"id"
public static final String	INSERT_STATEMENT	"INSERT INTO plan_tps (server_id,date,tps,players_online,cpu_usage,ram_usage,entities,chunks_loaded,free_disk_space,mspt_average,mspt_95th_percentile) VALUES ((SELECT plan_servers.id FROM plan_servers WHERE plan_servers.uuid=? LIMIT 1),?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
public static final String	MSPT_95TH_PERCENTILE	"mspt_95th_percentile"
public static final String	MSPT_AVERAGE	"mspt_average"
public static final String	PLAYERS_ONLINE	"players_online"
public static final String	RAM_USAGE	"ram_usage"
public static final String	SERVER_ID	"server_id"
public static final String	TABLE_NAME	"plan_tps"
public static final String	TPS	"tps"

com.djrapitops.plan.storage.database.sql.tables.UserInfoTable

Modifier and Type	Constant Field	Value
public static final String	BANNED	"banned"
public static final String	ID	"id"
public static final String	INSERT_STATEMENT	"INSERT INTO plan_user_info (user_id,registered,server_id,banned,join_address,opped) VALUES ((SELECT plan_users.id FROM plan_users WHERE plan_users.uuid=? LIMIT 1), ?, (SELECT plan_servers.id FROM plan_servers WHERE plan_servers.uuid=? LIMIT 1), ?, ?, ?)"
public static final String	JOIN_ADDRESS	"join_address"
public static final String	OP	"opped"
public static final String	REGISTERED	"registered"
public static final String	SERVER_ID	"server_id"
public static final String	TABLE_NAME	"plan_user_info"
public static final String	USER_ID	"user_id"

com.djrapitops.plan.storage.database.sql.tables.UsersTable

Modifier and Type	Constant Field	Value
public static final String	ID	"id"
public static final String	REGISTERED	"registered"
public static final String	SELECT_USER_ID	"(SELECT plan_users.id FROM plan_users WHERE plan_users.uuid=? LIMIT 1)"
public static final String	TABLE_NAME	"plan_users"
public static final String	TIMES_KICKED	"times_kicked"
public static final String	USER_NAME	"name"
public static final String	USER_UUID	"uuid"

com.djrapitops.plan.storage.database.sql.tables.WorldTable

Modifier and Type	Constant Field	Value
public static final String	ID	"id"
public static final String	INSERT_STATEMENT	"INSERT INTO plan_worlds (world_name,server_uuid) VALUES (?, ?)"
public static final String	NAME	"world_name"
public static final String	SELECT_WORLD_ID_STATEMENT	"(SELECT plan_worlds.id FROM plan_worlds WHERE world_name=? AND plan_worlds.server_uuid=? LIMIT 1)"
public static final String	SERVER_UUID	"server_uuid"
public static final String	TABLE_NAME	"plan_worlds"

com.djrapitops.plan.storage.database.sql.tables.WorldTimesTable

Modifier and Type	Constant Field	Value
public static final String	ADVENTURE	"adventure_time"
public static final String	CREATIVE	"creative_time"
public static final String	ID	"id"
public static final String	INSERT_STATEMENT	"INSERT INTO plan_world_times (session_id,world_id,user_id,server_id,survival_time,creative_time,adventure_time,spectator_time) VALUES ( (SELECT plan_sessions.id FROM plan_sessions WHERE plan_sessions.user_id=(SELECT plan_users.id FROM plan_users WHERE plan_users.uuid=? LIMIT 1) AND plan_sessions.server_id=(SELECT plan_servers.id FROM plan_servers WHERE plan_servers.uuid=? LIMIT 1) AND session_start=? AND session_end=? LIMIT 1),(SELECT plan_worlds.id FROM plan_worlds WHERE world_name=? AND plan_worlds.server_uuid=? LIMIT 1),(SELECT plan_users.id FROM plan_users WHERE plan_users.uuid=? LIMIT 1),(SELECT plan_servers.id FROM plan_servers WHERE plan_servers.uuid=? LIMIT 1),?, ?, ?, ?)"
public static final String	SERVER_ID	"server_id"
public static final String	SESSION_ID	"session_id"
public static final String	SPECTATOR	"spectator_time"
public static final String	SURVIVAL	"survival_time"
public static final String	TABLE_NAME	"plan_world_times"
public static final String	USER_ID	"user_id"
public static final String	WORLD_ID	"world_id"

com.djrapitops.plan.storage.database.sql.tables.extension.ExtensionGroupsTable

Modifier and Type	Constant Field	Value
public static final String	GROUP_NAME	"group_name"
public static final String	ID	"id"
public static final String	PROVIDER_ID	"provider_id"
public static final String	TABLE_NAME	"plan_extension_groups"
public static final String	USER_UUID	"uuid"

com.djrapitops.plan.storage.database.sql.tables.extension.ExtensionIconTable

Modifier and Type	Constant Field	Value
public static final String	COLOR	"color"
public static final String	FAMILY	"family"
public static final String	ICON_NAME	"name"
public static final String	ID	"id"
public static final String	TABLE_NAME	"plan_extension_icons"

com.djrapitops.plan.storage.database.sql.tables.extension.ExtensionPlayerTableValueTable

Modifier and Type	Constant Field	Value
public static final String	ID	"id"
public static final String	TABLE_ID	"table_id"
public static final String	TABLE_NAME	"plan_extension_user_table_values"
public static final String	TABLE_ROW	"table_row"
public static final String	USER_UUID	"uuid"
public static final String	VALUE_1	"col_1_value"
public static final String	VALUE_2	"col_2_value"
public static final String	VALUE_3	"col_3_value"
public static final String	VALUE_4	"col_4_value"

com.djrapitops.plan.storage.database.sql.tables.extension.ExtensionPlayerValueTable

Modifier and Type	Constant Field	Value
public static final String	BOOLEAN_VALUE	"boolean_value"
public static final String	COMPONENT_VALUE	"component_value"
public static final String	DOUBLE_VALUE	"double_value"
public static final String	GROUP_VALUE	"group_value"
public static final String	ID	"id"
public static final String	LONG_VALUE	"long_value"
public static final String	PERCENTAGE_VALUE	"percentage_value"
public static final String	PROVIDER_ID	"provider_id"
public static final String	STRING_VALUE	"string_value"
public static final String	TABLE_NAME	"plan_extension_user_values"
public static final String	USER_UUID	"uuid"

com.djrapitops.plan.storage.database.sql.tables.extension.ExtensionPluginTable

Modifier and Type	Constant Field	Value
public static final String	ICON_ID	"icon_id"
public static final String	ID	"id"
public static final String	LAST_UPDATED	"last_updated"
public static final String	PLUGIN_NAME	"name"
public static final String	SERVER_UUID	"server_uuid"
public static final String	STATEMENT_SELECT_PLUGIN_ID	"(SELECT id FROM plan_extension_plugins WHERE name=? AND server_uuid=? LIMIT 1)"
public static final String	TABLE_NAME	"plan_extension_plugins"

com.djrapitops.plan.storage.database.sql.tables.extension.ExtensionProviderTable

Modifier and Type	Constant Field	Value
public static final String	CONDITION	"condition_name"
public static final String	DESCRIPTION	"description"
public static final String	FORMAT_TYPE	"format_type"
public static final String	GROUPABLE	"groupable"
public static final String	HIDDEN	"hidden"
public static final String	ICON_ID	"icon_id"
public static final String	ID	"id"
public static final String	IS_PLAYER_NAME	"player_name"
public static final String	PLUGIN_ID	"plugin_id"
public static final String	PRIORITY	"priority"
public static final String	PROVIDED_CONDITION	"provided_condition"
public static final String	PROVIDER_NAME	"name"
public static final String	SHOW_IN_PLAYERS_TABLE	"show_in_players_table"
public static final String	STATEMENT_SELECT_PROVIDER_ID	"(SELECT id FROM plan_extension_providers WHERE name=? AND plugin_id=(SELECT id FROM plan_extension_plugins WHERE name=? AND server_uuid=? LIMIT 1) LIMIT 1)"
public static final String	TAB_ID	"tab_id"
public static final String	TABLE_NAME	"plan_extension_providers"
public static final String	TEXT	"text"

com.djrapitops.plan.storage.database.sql.tables.extension.ExtensionServerTableValueTable

Modifier and Type	Constant Field	Value
public static final String	ID	"id"
public static final String	SERVER_UUID	"uuid"
public static final String	TABLE_ID	"table_id"
public static final String	TABLE_NAME	"plan_extension_server_table_values"
public static final String	TABLE_ROW	"table_row"
public static final String	VALUE_1	"col_1_value"
public static final String	VALUE_2	"col_2_value"
public static final String	VALUE_3	"col_3_value"
public static final String	VALUE_4	"col_4_value"
public static final String	VALUE_5	"col_5_value"

com.djrapitops.plan.storage.database.sql.tables.extension.ExtensionServerValueTable

Modifier and Type	Constant Field	Value
public static final String	BOOLEAN_VALUE	"boolean_value"
public static final String	COMPONENT_VALUE	"component_value"
public static final String	DOUBLE_VALUE	"double_value"
public static final String	GROUP_VALUE	"group_value"
public static final String	ID	"id"
public static final String	LONG_VALUE	"long_value"
public static final String	PERCENTAGE_VALUE	"percentage_value"
public static final String	PROVIDER_ID	"provider_id"
public static final String	STRING_VALUE	"string_value"
public static final String	TABLE_NAME	"plan_extension_server_values"

com.djrapitops.plan.storage.database.sql.tables.extension.ExtensionTableProviderTable

Modifier and Type	Constant Field	Value
public static final String	COL_1	"col_1_name"
public static final String	COL_2	"col_2_name"
public static final String	COL_3	"col_3_name"
public static final String	COL_4	"col_4_name"
public static final String	COL_5	"col_5_name"
public static final String	COLOR	"color"
public static final String	CONDITION	"condition_name"
public static final String	FORMAT_1	"format_1"
public static final String	FORMAT_2	"format_2"
public static final String	FORMAT_3	"format_3"
public static final String	FORMAT_4	"format_4"
public static final String	FORMAT_5	"format_5"
public static final String	ICON_1_ID	"icon_1_id"
public static final String	ICON_2_ID	"icon_2_id"
public static final String	ICON_3_ID	"icon_3_id"
public static final String	ICON_4_ID	"icon_4_id"
public static final String	ICON_5_ID	"icon_5_id"
public static final String	ID	"id"
public static final String	PLUGIN_ID	"plugin_id"
public static final String	PROVIDER_NAME	"name"
public static final String	STATEMENT_SELECT_TABLE_ID	"(SELECT id FROM plan_extension_tables WHERE name=? AND plugin_id=(SELECT id FROM plan_extension_plugins WHERE name=? AND server_uuid=? LIMIT 1) LIMIT 1)"
public static final String	TAB_ID	"tab_id"
public static final String	TABLE_NAME	"plan_extension_tables"
public static final String	VALUES_FOR	"values_for"
public static final int	VALUES_FOR_PLAYER	0
public static final int	VALUES_FOR_SERVER	1

com.djrapitops.plan.storage.database.sql.tables.extension.ExtensionTabTable

Modifier and Type	Constant Field	Value
public static final String	ELEMENT_ORDER	"element_order"
public static final String	ICON_ID	"icon_id"
public static final String	ID	"id"
public static final String	PLUGIN_ID	"plugin_id"
public static final String	STATEMENT_SELECT_TAB_ID	"(SELECT id FROM plan_extension_tabs WHERE name=? AND plugin_id=(SELECT id FROM plan_extension_plugins WHERE name=? AND server_uuid=? LIMIT 1) LIMIT 1)"
public static final String	TAB_NAME	"name"
public static final String	TAB_PRIORITY	"tab_priority"
public static final String	TABLE_NAME	"plan_extension_tabs"

com.djrapitops.plan.storage.database.sql.tables.webuser.SecurityTable

Modifier and Type	Constant Field	Value
public static final String	GROUP_ID	"group_id"
public static final String	ID	"id"
public static final String	INSERT_STATEMENT	"INSERT INTO plan_security (username,linked_to_uuid,salted_pass_hash,group_id) VALUES (?,?,?,(SELECT id FROM plan_web_group WHERE group_name=?))"
public static final String	LINKED_TO	"linked_to_uuid"
public static final String	SALT_PASSWORD_HASH	"salted_pass_hash"
public static final String	SELECT_ID_BY_USERNAME	"SELECT id FROM plan_security WHERE username=?"
public static final String	TABLE_NAME	"plan_security"
public static final String	USERNAME	"username"

com.djrapitops.plan.storage.database.sql.tables.webuser.WebGroupTable

Modifier and Type	Constant Field	Value
public static final String	ID	"id"
public static final String	INSERT_STATEMENT	"INSERT INTO plan_web_group (group_name) VALUES (?)"
public static final String	NAME	"group_name"
public static final String	SELECT_GROUP_ID	"SELECT id FROM plan_web_group WHERE group_name=?"
public static final String	TABLE_NAME	"plan_web_group"

com.djrapitops.plan.storage.database.sql.tables.webuser.WebGroupToPermissionTable

Modifier and Type	Constant Field	Value
public static final String	GROUP_ID	"group_id"
public static final String	ID	"id"
public static final String	INSERT_STATEMENT	"INSERT INTO plan_web_group_to_permission (group_id,permission_id) VALUES (?,?)"
public static final String	PERMISSION_ID	"permission_id"
public static final String	TABLE_NAME	"plan_web_group_to_permission"

com.djrapitops.plan.storage.database.sql.tables.webuser.WebPermissionTable

Modifier and Type	Constant Field	Value
public static final String	ID	"id"
public static final String	INSERT_STATEMENT	"INSERT INTO plan_web_permission (permission) VALUES (?)"
public static final String	PERMISSION	"permission"
public static final String	SELECT_PERMISSION_ID	"SELECT id FROM plan_web_permission WHERE permission=?"
public static final String	TABLE_NAME	"plan_web_permission"

com.djrapitops.plan.storage.database.sql.tables.webuser.WebUserPreferencesTable

Modifier and Type	Constant Field	Value
public static final String	DELETE_BY_WEB_USERNAME	"DELETE FROM plan_web_user_preferences WHERE web_user_id=(SELECT id FROM plan_security WHERE username=?)"
public static final String	ID	"id"
public static final String	INSERT_STATEMENT	"INSERT INTO plan_web_user_preferences (preferences,web_user_id) VALUES (?, (SELECT id FROM plan_security WHERE username=?))"
public static final String	PREFERENCES	"preferences"
public static final String	SELECT_BY_WEB_USERNAME	"SELECT preferences FROM plan_web_user_preferences WHERE web_user_id=(SELECT id FROM plan_security WHERE username=?)"
public static final String	TABLE_NAME	"plan_web_user_preferences"
public static final String	WEB_USER_ID	"web_user_id"