TRUNCATE TABLE ADMIN_EVENT_ENTITY;
DROP TABLE ADMIN_EVENT_ENTITY;
TRUNCATE TABLE CLIENT;
TRUNCATE TABLE ADMIN_EVENT_ENTITY;
TRUNCATE TABLE REALM;
TRUNCATE TABLE USER_ENTITY;
TRUNCATE TABLE USER_FEDERATION_PROVIDER;
TRUNCATE TABLE USER_SESSION;


drop TABLE CLIENT ;
drop TABLE ADMIN_EVENT_ENTITY;
drop TABLE REALM;
drop TABLE USER_ENTITY;
drop TABLE USER_FEDERATION_PROVIDER;
drop TABLE USER_SESSION;

SET FOREIGN_KEY_CHECKS=0;
truncate TABLE REALM;
truncate TABLE CLIENT CASCADE;
drop TABLE REALM CASCADE;
drop TABLE CLIENT CASCADE;
SET FOREIGN_KEY_CHECKS=1;