DataBase Objects Created by Serenity on Default Migration

Following Database objects are created automatically when serenity runs its default migration

#	Tables	Triggers	Sequences	Indexes
1	EXCEPTIONS	EXCEPTIONS_SEQ_TRG	EXCEPTIONS_SEQ	PK_EXCEPTIONS
2	LANGUAGES	LANGUAGES_SEQ_TRG	LANGUAGES_SEQ	PK_LANGUAGES
3	ROLEPERMISSIONS	ROLEPERMISSIONS_SEQ_TRG	ROLEPERMISSIONS_SEQ	PK_ROLEPERMISSIONS
4	ROLES	ROLES_SEQ_TRG	ROLES_SEQ	PK_ROLES
5	USERPERMISSIONS	USERPERMISSIONS_SEQ_TRG	USERPERMISSIONS_SEQ	PK_USERPERMISSIONS
6	USERPREFERENCES	USERPREFERENCES_SEQ_TRG	USERPREFERENCES_SEQ	PK_USERPREFERENCES
7	USERROLES	USERROLES_SEQ_TRG	USERROLES_SEQ	PK_USERROLES
8	USERS	USERS_SEQ_TRG	USERS_SEQ	PK_USERS
9	VERSIONINFO

        

Moreover it also creates the following indexes.

SrNO.	Indexes
1	IX_EXCEPTIONS_APP_DEL_CRE
2	IX_EXCEPTIONS_GUID_APP_DEL_CRE
3	IX_EXCEPTIONS_HASH_APP_CRE_DEL
4	IX_USERPREF_UID_PREFTYPE_NAME
5	IX_USERROLES_ROLEID_USERID
6	SYS_IL0000083438C00005$$
7	SYS_IL0000083445C00014$$
8	SYS_IL0000083445C00016$$
9	SYS_IL0000083445C00018$$
10	UC_VERSION
11	UQ_ROLEPERM_ROLEID_PERMKEY
12	UQ_USERPERM_USERID_PERMKEY
13	UQ_USERROLES_USERID_ROLEID

Note: If we drop tables with cascade options, indexes and triggers will be dropped automatically. But we will need to drop the sequences.