[Sprint/NuancedNumbat](chore): Added in moderation and reporting schema (CQL)
Request to merge chore/cql-schema-report into master
The source branch is 22 commits behind the target branch
0/5 threads resolved
added MR::Awaiting Review Squad::Yellow scoped labels
1538 AND gc_grace_seconds = 864000 1539 AND max_index_interval = 2048 1540 AND memtable_flush_period_in_ms = 0 1541 AND min_index_interval = 128 1542 AND read_repair_chance = 0.0 1543 AND speculative_retry = '99PERCENTILE'; 1544 1545 CREATE TABLE minds.moderation_summons ( 1546 report_urn text, 1547 jury_type text, 1548 juror_guid bigint, 1549 expires int, 1550 status text, 1551 PRIMARY KEY (report_urn, jury_type, juror_guid) 1552 ) WITH CLUSTERING ORDER BY (jury_type ASC, juror_guid ASC) 1553 AND bloom_filter_fp_chance = 0.01 
Ownerremove all after this line
1514 AND default_time_to_live = 0 1515 AND gc_grace_seconds = 864000 1516 AND max_index_interval = 2048 1517 AND memtable_flush_period_in_ms = 0 1518 AND min_index_interval = 128 1519 AND read_repair_chance = 0.0 1520 AND speculative_retry = '99PERCENTILE'; 1521 1522 CREATE TABLE minds.moderation_strikes ( 1523 user_guid bigint, 1524 reason_code tinyint, 1525 sub_reason_code decimal, 1526 timestamp timestamp, 1527 report_urn text, 1528 PRIMARY KEY (user_guid, reason_code, sub_reason_code, timestamp) 1529 ) WITH CLUSTERING ORDER BY (reason_code ASC, sub_reason_code ASC, timestamp ASC) - Owner
remove everything after this line
1491 AND crc_check_chance = 1.0 1492 AND dclocal_read_repair_chance = 0.1 1493 AND default_time_to_live = 0 1494 AND gc_grace_seconds = 864000 1495 AND max_index_interval = 2048 1496 AND memtable_flush_period_in_ms = 0 1497 AND min_index_interval = 128 1498 AND read_repair_chance = 0.0 1499 AND speculative_retry = '99PERCENTILE'; 1500 1501 CREATE MATERIALIZED VIEW minds.moderation_reports_by_state AS 1502 SELECT * 1503 FROM minds.moderation_reports 1504 WHERE state IS NOT NULL AND reason_code IS NOT NULL AND sub_reason_code IS NOT NULL AND timestamp IS NOT NULL 1505 PRIMARY KEY (state, timestamp, entity_urn, reason_code, sub_reason_code) 1506 WITH CLUSTERING ORDER BY (timestamp DESC, entity_urn ASC, reason_code ASC, sub_reason_code ASC) - Owner
remove everything after this line
1470 AND crc_check_chance = 1.0 1471 AND dclocal_read_repair_chance = 0.1 1472 AND default_time_to_live = 0 1473 AND gc_grace_seconds = 864000 1474 AND max_index_interval = 2048 1475 AND memtable_flush_period_in_ms = 0 1476 AND min_index_interval = 128 1477 AND read_repair_chance = 0.0 1478 AND speculative_retry = '99PERCENTILE'; 1479 1480 CREATE MATERIALIZED VIEW minds.moderation_reports_by_entity_owner_guid AS 1481 SELECT * 1482 FROM minds.moderation_reports 1483 WHERE entity_owner_guid IS NOT NULL AND reason_code IS NOT NULL AND sub_reason_code IS NOT NULL AND timestamp IS NOT NULL 1484 PRIMARY KEY (entity_owner_guid, timestamp, entity_urn, reason_code, sub_reason_code) 1485 WITH CLUSTERING ORDER BY (timestamp DESC, entity_urn ASC, reason_code ASC, sub_reason_code ASC) - Owner
remove everything after this line. keep WITH CLUSTERING ORDER
1449 CREATE TABLE minds.moderation_reports ( 1450 entity_urn text, 1451 reason_code tinyint, 1452 sub_reason_code decimal, 1453 timestamp timestamp, 1454 appeal_jury map<bigint, boolean>, 1455 appeal_note text, 1456 entity_owner_guid bigint, 1457 initial_jury map<bigint, boolean>, 1458 reports set<bigint>, 1459 state text, 1460 state_changes map<text, timestamp>, 1461 uphold boolean, 1462 user_hashes set<text>, 1463 PRIMARY KEY (entity_urn, reason_code, sub_reason_code, timestamp) 1464 ) WITH CLUSTERING ORDER BY (reason_code ASC, sub_reason_code ASC, timestamp DESC) - Owner
remove all after this line
added MR::Requires Changes scoped label and automatically removed MR::Awaiting Review label