tech.aroma.cql.message_tables.cql Maven / Gradle / Ivy

Go to download
//Assumes the existence of a 'Aroma' Keyspace

CREATE TABLE IF NOT EXISTS Aroma.Messages
(
	message_id timeuuid,
	title text,
	body text,
	urgency text,
	time_created timestamp,
	time_received timestamp,
	hostname text,
	mac_address text,
	ip_address text,
	app_id uuid,
	app_name text,
	device_name text,

	PRIMARY KEY ((app_id), message_id)
)
WITH gc_grace_seconds=600
AND compaction =
{	'class' : 'DateTieredCompactionStrategy',
	'max_sstable_age_days' : '180'
 }
;

CREATE INDEX IF NOT EXISTS Messages_By_Title ON Aroma.Messages (title);

CREATE INDEX IF NOT EXISTS Messages_By_Hostname  ON Aroma.Messages (hostname);

CREATE INDEX IF NOT EXISTS Messages_By_Device_Name  ON Aroma.Messages (device_name);

CREATE TABLE IF NOT EXISTS Aroma.Messages_Rate_Limit
(
	app_id uuid,
	request_time timeuuid,

	PRIMARY KEY ((app_id), request_time)
)
WITH gc_grace_seconds=600
AND compaction =
{	'class' : 'DateTieredCompactionStrategy',
	'max_sstable_age_days' : '30'
 }
 ;

CREATE TABLE IF NOT EXISTS Aroma.Messages_Totals_By_App
(
	app_id uuid,
	total_messages counter,

	PRIMARY KEY (app_id)
);

CREATE TABLE IF NOT EXISTS Aroma.Messages_Totals_By_Title
(
	app_id uuid,
	title text,
	total_messages counter,

	PRIMARY KEY ((app_id), title)
);