1 // Copyright © 2018 Amdocs, Bell Canada, AT&T
3 // Licensed under the Apache License, Version 2.0 (the "License");
4 // you may not use this file except in compliance with the License.
5 // You may obtain a copy of the License at
7 // http://www.apache.org/licenses/LICENSE-2.0
9 // Unless required by applicable law or agreed to in writing, software
10 // distributed under the License is distributed on an "AS IS" BASIS,
11 // WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
12 // See the License for the specific language governing permissions and
13 // limitations under the License.
15 CREATE KEYSPACE IF NOT EXISTS portalsdk
17 'class' : 'SimpleStrategy',
18 'replication_factor': 1
20 AND DURABLE_WRITES = true;
23 CREATE TABLE portalsdk.spring_session (
24 primary_id text PRIMARY KEY,
27 last_access_time text,
28 max_inactive_interval text,
32 ) WITH bloom_filter_fp_chance = 0.01
33 AND caching = {'keys': 'ALL', 'rows_per_partition': '10'}
35 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
36 AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
37 AND crc_check_chance = 1.0
38 AND dclocal_read_repair_chance = 0.1
39 AND default_time_to_live = 0
40 AND gc_grace_seconds = 864000
41 AND max_index_interval = 2048
42 AND memtable_flush_period_in_ms = 0
43 AND min_index_interval = 128
44 AND read_repair_chance = 0.0
45 AND speculative_retry = '99PERCENTILE';
48 CREATE TABLE portalsdk.spring_session_attributes (
53 PRIMARY KEY (primary_id, attribute_name)
54 ) WITH CLUSTERING ORDER BY (attribute_name ASC)
55 AND bloom_filter_fp_chance = 0.01
56 AND caching = {'keys': 'ALL', 'rows_per_partition': '1'}
58 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
59 AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
60 AND crc_check_chance = 1.0
61 AND dclocal_read_repair_chance = 0.1
62 AND default_time_to_live = 0
63 AND gc_grace_seconds = 864000
64 AND max_index_interval = 2048
65 AND memtable_flush_period_in_ms = 0
66 AND min_index_interval = 128
67 AND read_repair_chance = 0.0
68 AND speculative_retry = '99PERCENTILE';