gammu_smsd_summary.sql

-- Get SMS summary from Gammu SMSD
-- from almost all content tables.

CREATE VIEW summary
AS
(
	SELECT
		'inbox' AS kind,
		ID AS id,
		ReceivingDateTime AS created,
		UpdatedInDB AS updated,
		SenderNumber AS number,
		TextDecoded AS content,
		Status AS status
	FROM inbox
)
UNION ALL
(
	SELECT
		'outbox' AS kind,
		ID AS id,
		SendingDateTime AS created,
		UpdatedInDB AS updated,
		DestinationNumber AS number,
		TextDecoded AS content,
		Status AS status
	FROM outbox
)
UNION ALL
(
	SELECT
		'sentitems' AS kind,
		ID AS id,
		SendingDateTime AS created,
		UpdatedInDB AS updated,
		DestinationNumber AS number,
		TextDecoded AS content,
		Status AS status
	FROM sentitems
)
ORDER BY
	created,
	updated
;