github.com/ronaksoft/rony@v0.16.26-0.20230807065236-1743dbfe6959/internal/testEnv/pb/model/model.cql (about)

     1  
     2  
     3  CREATE TABLE IF NOT EXISTS tab_model_1 
     4  (
     5  	id  int,
     6  	shard_key  int,
     7  	enum  int,
     8  	sdata  blob,
     9  	PRIMARY KEY ((id), shard_key, enum)
    10  ) WITH CLUSTERING ORDER BY (shard_key ASC, enum ASC);
    11  
    12  CREATE MATERIALIZED VIEW IF NOT EXISTS view_model_1_customer_sort AS
    13  SELECT *
    14  FROM tab_model_1
    15  WHERE id IS NOT null
    16  AND shard_key IS NOT null
    17  AND enum IS NOT null
    18  PRIMARY KEY ((enum), shard_key, id) WITH CLUSTERING ORDER BY (shard_key ASC, id ASC);
    19  
    20  
    21  
    22  
    23  CREATE TABLE IF NOT EXISTS tab_model_2 
    24  (
    25  	id  bigint,
    26  	shard_key  int,
    27  	p_1  blob,
    28  	sdata  blob,
    29  	PRIMARY KEY ((id, shard_key), p_1)
    30  ) WITH CLUSTERING ORDER BY (p_1 DESC);
    31  
    32  CREATE MATERIALIZED VIEW IF NOT EXISTS view_model_2_p_1_shard_key_id AS
    33  SELECT *
    34  FROM tab_model_2
    35  WHERE id IS NOT null
    36  AND shard_key IS NOT null
    37  AND p_1 IS NOT null
    38  PRIMARY KEY ((p_1), shard_key, id) WITH CLUSTERING ORDER BY (shard_key ASC, id ASC);
    39  
    40  
    41  
    42  
    43  CREATE TABLE IF NOT EXISTS tab_model_3 
    44  (
    45  	id  bigint,
    46  	shard_key  int,
    47  	p_1  blob,
    48  	sdata  blob,
    49  	PRIMARY KEY ((id, shard_key), p_1)
    50  ) WITH CLUSTERING ORDER BY (p_1 DESC);
    51  
    52  CREATE MATERIALIZED VIEW IF NOT EXISTS view_model_3_p_1_shard_key_id AS
    53  SELECT *
    54  FROM tab_model_3
    55  WHERE id IS NOT null
    56  AND shard_key IS NOT null
    57  AND p_1 IS NOT null
    58  PRIMARY KEY ((p_1), shard_key, id) WITH CLUSTERING ORDER BY (shard_key ASC, id ASC);
    59  
    60  CREATE MATERIALIZED VIEW IF NOT EXISTS view_model_3_p_1_id_shard_key AS
    61  SELECT *
    62  FROM tab_model_3
    63  WHERE id IS NOT null
    64  AND shard_key IS NOT null
    65  AND p_1 IS NOT null
    66  PRIMARY KEY ((p_1), id, shard_key) WITH CLUSTERING ORDER BY (id ASC, shard_key ASC);
    67  
    68