Skip to Content
SQLDatabase Reset

Database Reset

Use these queries to completely drop all tables (you may need to change the prefix if you’ve customized it).

SQLite and H2 users can delete the db files in the prism folder.

🚫
This deletes all prism data! Only use during testing or complete server resets.
DROP FUNCTION IF EXISTS public.prism_create_activity;
DROP FUNCTION IF EXISTS public.prism_get_or_create_action;
DROP FUNCTION IF EXISTS public.prism_get_or_create_block;
DROP FUNCTION IF EXISTS public.prism_get_or_create_cause;
DROP FUNCTION IF EXISTS public.prism_get_or_create_entity_type;
DROP FUNCTION IF EXISTS public.prism_get_or_create_item;
DROP FUNCTION IF EXISTS public.prism_get_or_create_player;
DROP FUNCTION IF EXISTS public.prism_get_or_create_world;
 
DROP TABLE IF EXISTS prism_activities;
DROP TABLE IF EXISTS prism_actions;
DROP TABLE IF EXISTS prism_blocks;
DROP TABLE IF EXISTS prism_causes;
DROP TABLE IF EXISTS prism_entity_types;
DROP TABLE IF EXISTS prism_items;
DROP TABLE IF EXISTS prism_meta;
DROP TABLE IF EXISTS prism_players;
DROP TABLE IF EXISTS prism_worlds;
Last updated on
Troubleshooting