Page Comparison

CREATE TABLE sunbird_courses.user_coursesenrolments (
	    userid text,
	    batchid text,
	    active boolean,
	    addedby text,
	    certificates list<frozen<map<text, text>>>,
	    completedon timestamp,
	    completionpercentage int,
	    contentstatus map<text, int>,
	    courseid text,
	    datetime timestamp,
	    delta text,
	    enrolleddate text,
	    grade text,
	    lastreadcontentid text,
	    lastreadcontentstatus int,
	    progress int,
	    status int,
	    PRIMARY KEY (userid, courseid, batchid)
	) WITH CLUSTERING ORDER BY (batchid ASC)
	    AND bloom_filter_fp_chance = 0.01
	    AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
	    AND comment = ''
	    AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
	    AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
	    AND crc_check_chance = 1.0
	    AND dclocal_read_repair_chance = 0.1
	    AND default_time_to_live = 0
	    AND gc_grace_seconds = 864000
	    AND max_index_interval = 2048
	    AND memtable_flush_period_in_ms = 0
	    AND min_index_interval = 128
	    AND read_repair_chance = 0.0
	    AND speculative_retry = '99PERCENTILE';
	CREATE INDEX inx_ucs_status ON sunbird_courses.user_courses (status);
	CREATE TRIGGER batch_enrollment_trigger ON sunbird_courses.user_courses USING 'org.sunbird.cassandra.triggers.TransactionEventTrigger';