1 - Delete the Sample Projects

First, for both cloud and on-premise customers, you need to delete all three sample projects using the Administration > View/Edit Projects page:

  1. Library Information System
  2. Sample Application One
  3. Sample Application Two

2 - Physically Delete the Sample Users

The next step will depend on whether you are cloud hosted or on-premise. For on-premise customers, you need to run these SQL commands to delete the sample users:

DELETE FROM TST_USER_PROFILE
WHERE USER_ID >= 2 AND USER_ID <= 13
GO
DELETE FROM TST_USER_COLLECTION_ENTRY
WHERE USER_ID >= 2 AND USER_ID <= 13
GO
DELETE FROM TST_USER_CONTACT
WHERE CREATOR_USER_ID >= 2 AND CREATOR_USER_ID <= 13
GO
DELETE FROM TST_USER_CONTACT
WHERE CONTACT_USER_ID >= 2 AND CONTACT_USER_ID <= 13
GO
DELETE FROM TST_DATA_SYNC_USER_MAPPING
WHERE USER_ID >= 2 AND USER_ID <= 13
GO
DELETE FROM TST_PROJECT_GROUP_USER
WHERE USER_ID >= 2 AND USER_ID <= 13
GO
DELETE FROM TST_PROJECT_USER
WHERE USER_ID >= 2 AND USER_ID <= 13
GO
DELETE FROM TST_USER
WHERE USER_ID >= 2 AND USER_ID <= 13
GO

For cloud customers, you need to just send in a support ticket to us and provide the URL of your Spira instance.