-- App audio player actions for legacy iOS audio player
-- Clustered by partition date and hour for optimal query performance
CREATE TRANSIENT TABLE IF NOT EXISTS {app_audio_actions_table_name} CLUSTER BY (p_date, p_hour)(
	ID NUMBER(38,0),
	EVENT_NAME VARCHAR(255),
	ACTION_NAME VARCHAR(255),
	CLIP_ID VARCHAR(255),
	USER_ID VARCHAR(255),
	ANONYMOUS_ID VARCHAR(255),
	PLAYLIST_ID VARCHAR(255),
	IS_USER_SONG_OWNER BOOLEAN,
	IS_PUBLIC BOOLEAN,
	IS_LIKED BOOLEAN,
	IS_DISLIKED BOOLEAN,
	SHARE_TYPE VARCHAR(255),
	IS_PLAYING BOOLEAN,
	IS_STREAMING BOOLEAN,
	ELAPSED_TIME NUMBER(38,0),
	TOTAL_TIME NUMBER(38,0),
	FROM_COMMAND_CENTER BOOLEAN,
	OMNIPLAYER_IS_EXPANDED BOOLEAN,
	CLIENT_TIMESTAMP VARCHAR(255),
	SERVER_TIMESTAMP VARCHAR(255),
	USER_AGENT VARCHAR(16777216),
	LOCALE VARCHAR(255),
	TIMEZONE VARCHAR(255),
	P_HOUR NUMBER(38,0),
	CLIENT_IP VARCHAR(255),
	APP_NAMESPACE VARCHAR(255),
	APP_VERSION VARCHAR(255),
	OS_NAME VARCHAR(255),
	OS_VERSION VARCHAR(255),
    P_DATE DATE
);