· 8 years ago · Apr 11, 2018, 04:12 AM
1CREATE KEYSPACE stonix WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '1'} AND durable_writes = true;
2
3
4CREATE TYPE stonix.name_change_history_element (
5 old_name text,
6 new_name text,
7 change_date frozen<tuple<timestamp, text>>
8);
9
10CREATE TYPE stonix.queueentry (
11 playername text,
12 weight int
13);
14
15CREATE TYPE stonix.setting (
16 id text,
17 context_id text,
18 translation_id text,
19 type text,
20 def text
21);
22
23CREATE TYPE stonix.statistic_entry (
24 id text,
25 def text,
26 group_id text,
27 translation_id text
28);
29
30CREATE TYPE stonix.statistic_group (
31 id text,
32 statistic_entries frozen<list<frozen<statistic_entry>>>,
33 translation_id text
34);
35
36CREATE TABLE stonix.purchases (
37 customer_id uuid,
38 date frozen<tuple<timestamp, text>>,
39 price decimal,
40 reason text,
41 trade_element_id text,
42 PRIMARY KEY (customer_id, date)
43) WITH CLUSTERING ORDER BY (date ASC)
44 AND bloom_filter_fp_chance = 0.01
45 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
46 AND comment = ''
47 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
48 AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
49 AND crc_check_chance = 1.0
50 AND dclocal_read_repair_chance = 0.1
51 AND default_time_to_live = 0
52 AND gc_grace_seconds = 864000
53 AND max_index_interval = 2048
54 AND memtable_flush_period_in_ms = 0
55 AND min_index_interval = 128
56 AND read_repair_chance = 0.0
57 AND speculative_retry = '99PERCENTILE';
58
59CREATE TABLE stonix.money (
60 customer_id uuid,
61 date frozen<tuple<timestamp, text>>,
62 op_type text,
63 amount decimal,
64 balance decimal,
65 reason text,
66 PRIMARY KEY (customer_id, date, op_type)
67) WITH CLUSTERING ORDER BY (date ASC, op_type ASC)
68 AND bloom_filter_fp_chance = 0.01
69 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
70 AND comment = ''
71 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
72 AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
73 AND crc_check_chance = 1.0
74 AND dclocal_read_repair_chance = 0.1
75 AND default_time_to_live = 0
76 AND gc_grace_seconds = 864000
77 AND max_index_interval = 2048
78 AND memtable_flush_period_in_ms = 0
79 AND min_index_interval = 128
80 AND read_repair_chance = 0.0
81 AND speculative_retry = '99PERCENTILE';
82
83CREATE TABLE stonix.web_payments (
84 payment_id bigint PRIMARY KEY,
85 amount decimal,
86 create_date frozen<tuple<timestamp, text>>,
87 currency_id text,
88 description text,
89 merchant_id text,
90 node_name text,
91 paid boolean,
92 payer_id uuid
93) WITH bloom_filter_fp_chance = 0.01
94 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
95 AND comment = ''
96 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
97 AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
98 AND crc_check_chance = 1.0
99 AND dclocal_read_repair_chance = 0.1
100 AND default_time_to_live = 0
101 AND gc_grace_seconds = 864000
102 AND max_index_interval = 2048
103 AND memtable_flush_period_in_ms = 0
104 AND min_index_interval = 128
105 AND read_repair_chance = 0.0
106 AND speculative_retry = '99PERCENTILE';
107
108CREATE TABLE stonix.per_server_permanent_restrictions (
109 target uuid,
110 server_type text,
111 game_name text,
112 game_type text,
113 type text,
114 date frozen<tuple<timestamp, text>>,
115 active boolean,
116 giver uuid,
117 reason text,
118 PRIMARY KEY (target, server_type, game_name, game_type, type, date)
119) WITH CLUSTERING ORDER BY (server_type ASC, game_name ASC, game_type ASC, type ASC, date ASC)
120 AND bloom_filter_fp_chance = 0.01
121 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
122 AND comment = ''
123 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
124 AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
125 AND crc_check_chance = 1.0
126 AND dclocal_read_repair_chance = 0.1
127 AND default_time_to_live = 0
128 AND gc_grace_seconds = 864000
129 AND max_index_interval = 2048
130 AND memtable_flush_period_in_ms = 0
131 AND min_index_interval = 128
132 AND read_repair_chance = 0.0
133 AND speculative_retry = '99PERCENTILE';
134
135CREATE TABLE stonix.permanent_restrictions (
136 target uuid,
137 type text,
138 date frozen<tuple<timestamp, text>>,
139 active boolean,
140 giver uuid,
141 reason text,
142 PRIMARY KEY (target, type, date)
143) WITH CLUSTERING ORDER BY (type ASC, date ASC)
144 AND bloom_filter_fp_chance = 0.01
145 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
146 AND comment = ''
147 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
148 AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
149 AND crc_check_chance = 1.0
150 AND dclocal_read_repair_chance = 0.1
151 AND default_time_to_live = 0
152 AND gc_grace_seconds = 864000
153 AND max_index_interval = 2048
154 AND memtable_flush_period_in_ms = 0
155 AND min_index_interval = 128
156 AND read_repair_chance = 0.0
157 AND speculative_retry = '99PERCENTILE';
158
159CREATE TABLE enot.accounts (
160 id uuid PRIMARY KEY,
161 answer text,
162 last_address inet,
163 last_join_time frozen<tuple<timestamp, text>>,
164 last_quit_time frozen<tuple<timestamp, text>>,
165 name text,
166 name_change_history frozen<list<frozen<name_change_history_element>>>,
167 password text,
168 question text,
169 register_time frozen<tuple<timestamp, text>>,
170 total_time_played duration,
171 vk_id int
172) WITH bloom_filter_fp_chance = 0.01
173 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
174 AND comment = ''
175 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
176 AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
177 AND crc_check_chance = 1.0
178 AND dclocal_read_repair_chance = 0.1
179 AND default_time_to_live = 0
180 AND gc_grace_seconds = 864000
181 AND max_index_interval = 2048
182 AND memtable_flush_period_in_ms = 0
183 AND min_index_interval = 128
184 AND read_repair_chance = 0.0
185 AND speculative_retry = '99PERCENTILE';
186
187
188
189
190CREATE TABLE stonix.player_stats (
191 game_id text,
192 user_id uuid,
193 statistic_table frozen<map<frozen<statistic_group>, frozen<map<frozen<statistic_entry>, text>>>>,
194 PRIMARY KEY (game_id, user_id)
195) WITH CLUSTERING ORDER BY (user_id ASC)
196 AND bloom_filter_fp_chance = 0.01
197 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
198 AND comment = ''
199 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
200 AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
201 AND crc_check_chance = 1.0
202 AND dclocal_read_repair_chance = 0.1
203 AND default_time_to_live = 0
204 AND gc_grace_seconds = 864000
205 AND max_index_interval = 2048
206 AND memtable_flush_period_in_ms = 0
207 AND min_index_interval = 128
208 AND read_repair_chance = 0.0
209 AND speculative_retry = '99PERCENTILE';
210
211CREATE TABLE stonix.settings_contexts (
212 id text PRIMARY KEY,
213 settings frozen<map<text, frozen<setting>>>
214) WITH bloom_filter_fp_chance = 0.01
215 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
216 AND comment = ''
217 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
218 AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
219 AND crc_check_chance = 1.0
220 AND dclocal_read_repair_chance = 0.1
221 AND default_time_to_live = 0
222 AND gc_grace_seconds = 864000
223 AND max_index_interval = 2048
224 AND memtable_flush_period_in_ms = 0
225 AND min_index_interval = 128
226 AND read_repair_chance = 0.0
227 AND speculative_retry = '99PERCENTILE';
228
229CREATE TABLE stonix.player_settings (
230 context_id text,
231 id uuid,
232 settings_values map<text, text>,
233 PRIMARY KEY (context_id, id)
234) WITH CLUSTERING ORDER BY (id ASC)
235 AND bloom_filter_fp_chance = 0.01
236 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
237 AND comment = ''
238 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
239 AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
240 AND crc_check_chance = 1.0
241 AND dclocal_read_repair_chance = 0.1
242 AND default_time_to_live = 0
243 AND gc_grace_seconds = 864000
244 AND max_index_interval = 2048
245 AND memtable_flush_period_in_ms = 0
246 AND min_index_interval = 128
247 AND read_repair_chance = 0.0
248 AND speculative_retry = '99PERCENTILE';
249
250CREATE TABLE stonix.server_group_temporal_restrictions (
251 target uuid,
252 server_type text,
253 type text,
254 date frozen<tuple<timestamp, text>>,
255 active boolean,
256 duration duration,
257 giver uuid,
258 reason text,
259 PRIMARY KEY (target, server_type, type, date)
260) WITH CLUSTERING ORDER BY (server_type ASC, type ASC, date ASC)
261 AND bloom_filter_fp_chance = 0.01
262 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
263 AND comment = ''
264 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
265 AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
266 AND crc_check_chance = 1.0
267 AND dclocal_read_repair_chance = 0.1
268 AND default_time_to_live = 0
269 AND gc_grace_seconds = 864000
270 AND max_index_interval = 2048
271 AND memtable_flush_period_in_ms = 0
272 AND min_index_interval = 128
273 AND read_repair_chance = 0.0
274 AND speculative_retry = '99PERCENTILE';
275
276CREATE TABLE stonix.game_purchases (
277 customer_id uuid,
278 game_id text,
279 date frozen<tuple<timestamp, text>>,
280 price decimal,
281 reason text,
282 trade_element_id text,
283 PRIMARY KEY (customer_id, game_id, date)
284) WITH CLUSTERING ORDER BY (game_id ASC, date ASC)
285 AND bloom_filter_fp_chance = 0.01
286 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
287 AND comment = ''
288 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
289 AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
290 AND crc_check_chance = 1.0
291 AND dclocal_read_repair_chance = 0.1
292 AND default_time_to_live = 0
293 AND gc_grace_seconds = 864000
294 AND max_index_interval = 2048
295 AND memtable_flush_period_in_ms = 0
296 AND min_index_interval = 128
297 AND read_repair_chance = 0.0
298 AND speculative_retry = '99PERCENTILE';
299
300CREATE TABLE stonix.game_purchase_items (
301 game_id text,
302 id text,
303 price decimal,
304 translation_id text,
305 PRIMARY KEY (game_id, id)
306) WITH CLUSTERING ORDER BY (id ASC)
307 AND bloom_filter_fp_chance = 0.01
308 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
309 AND comment = ''
310 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
311 AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
312 AND crc_check_chance = 1.0
313 AND dclocal_read_repair_chance = 0.1
314 AND default_time_to_live = 0
315 AND gc_grace_seconds = 864000
316 AND max_index_interval = 2048
317 AND memtable_flush_period_in_ms = 0
318 AND min_index_interval = 128
319 AND read_repair_chance = 0.0
320 AND speculative_retry = '99PERCENTILE';
321
322CREATE TABLE stonix.temporal_restrictions (
323 target uuid,
324 type text,
325 date frozen<tuple<timestamp, text>>,
326 active boolean,
327 duration duration,
328 giver uuid,
329 reason text,
330 PRIMARY KEY (target, type, date)
331) WITH CLUSTERING ORDER BY (type ASC, date ASC)
332 AND bloom_filter_fp_chance = 0.01
333 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
334 AND comment = ''
335 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
336 AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
337 AND crc_check_chance = 1.0
338 AND dclocal_read_repair_chance = 0.1
339 AND default_time_to_live = 0
340 AND gc_grace_seconds = 864000
341 AND max_index_interval = 2048
342 AND memtable_flush_period_in_ms = 0
343 AND min_index_interval = 128
344 AND read_repair_chance = 0.0
345 AND speculative_retry = '99PERCENTILE';
346
347CREATE TABLE stonix.server_group_permanent_restrictions (
348 target uuid,
349 server_type text,
350 type text,
351 date frozen<tuple<timestamp, text>>,
352 active boolean,
353 giver uuid,
354 reason text,
355 PRIMARY KEY (target, server_type, type, date)
356) WITH CLUSTERING ORDER BY (server_type ASC, type ASC, date ASC)
357 AND bloom_filter_fp_chance = 0.01
358 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
359 AND comment = ''
360 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
361 AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
362 AND crc_check_chance = 1.0
363 AND dclocal_read_repair_chance = 0.1
364 AND default_time_to_live = 0
365 AND gc_grace_seconds = 864000
366 AND max_index_interval = 2048
367 AND memtable_flush_period_in_ms = 0
368 AND min_index_interval = 128
369 AND read_repair_chance = 0.0
370 AND speculative_retry = '99PERCENTILE';
371
372CREATE TABLE stonix.translations (
373 id text PRIMARY KEY,
374 translations map<text, text>
375) WITH bloom_filter_fp_chance = 0.01
376 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
377 AND comment = ''
378 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
379 AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
380 AND crc_check_chance = 1.0
381 AND dclocal_read_repair_chance = 0.1
382 AND default_time_to_live = 0
383 AND gc_grace_seconds = 864000
384 AND max_index_interval = 2048
385 AND memtable_flush_period_in_ms = 0
386 AND min_index_interval = 128
387 AND read_repair_chance = 0.0
388 AND speculative_retry = '99PERCENTILE';
389
390CREATE TABLE stonix.purchase_items (
391 id text PRIMARY KEY,
392 price decimal,
393 translation_id text
394) WITH bloom_filter_fp_chance = 0.01
395 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
396 AND comment = ''
397 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
398 AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
399 AND crc_check_chance = 1.0
400 AND dclocal_read_repair_chance = 0.1
401 AND default_time_to_live = 0
402 AND gc_grace_seconds = 864000
403 AND max_index_interval = 2048
404 AND memtable_flush_period_in_ms = 0
405 AND min_index_interval = 128
406 AND read_repair_chance = 0.0
407 AND speculative_retry = '99PERCENTILE';
408
409CREATE TABLE stonix.web_paid_items (
410 name text PRIMARY KEY,
411 description text,
412 node_name text,
413 price decimal
414) WITH bloom_filter_fp_chance = 0.01
415 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
416 AND comment = ''
417 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
418 AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
419 AND crc_check_chance = 1.0
420 AND dclocal_read_repair_chance = 0.1
421 AND default_time_to_live = 0
422 AND gc_grace_seconds = 864000
423 AND max_index_interval = 2048
424 AND memtable_flush_period_in_ms = 0
425 AND min_index_interval = 128
426 AND read_repair_chance = 0.0
427 AND speculative_retry = '99PERCENTILE';
428
429CREATE TABLE enot.game_money (
430 customer_id uuid,
431 game_id text,
432 date frozen<tuple<timestamp, text>>,
433 op_type text,
434 amount decimal,
435 balance decimal,
436 reason text,
437 PRIMARY KEY (customer_id, game_id, date, op_type)
438) WITH CLUSTERING ORDER BY (game_id ASC, date ASC, op_type ASC)
439 AND bloom_filter_fp_chance = 0.01
440 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
441 AND comment = ''
442 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
443 AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
444 AND crc_check_chance = 1.0
445 AND dclocal_read_repair_chance = 0.1
446 AND default_time_to_live = 0
447 AND gc_grace_seconds = 864000
448 AND max_index_interval = 2048
449 AND memtable_flush_period_in_ms = 0
450 AND min_index_interval = 128
451 AND read_repair_chance = 0.0
452 AND speculative_retry = '99PERCENTILE';
453
454CREATE TABLE stonix.chatformats (
455 id text PRIMARY KEY,
456 format text,
457 prefix text,
458 suffix text
459) WITH bloom_filter_fp_chance = 0.01
460 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
461 AND comment = ''
462 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
463 AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
464 AND crc_check_chance = 1.0
465 AND dclocal_read_repair_chance = 0.1
466 AND default_time_to_live = 0
467 AND gc_grace_seconds = 864000
468 AND max_index_interval = 2048
469 AND memtable_flush_period_in_ms = 0
470 AND min_index_interval = 128
471 AND read_repair_chance = 0.0
472 AND speculative_retry = '99PERCENTILE';
473
474CREATE TABLE stonix.player_uuids (
475 name text PRIMARY KEY,
476 id uuid
477) WITH bloom_filter_fp_chance = 0.01
478 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
479 AND comment = ''
480 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
481 AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
482 AND crc_check_chance = 1.0
483 AND dclocal_read_repair_chance = 0.1
484 AND default_time_to_live = 0
485 AND gc_grace_seconds = 864000
486 AND max_index_interval = 2048
487 AND memtable_flush_period_in_ms = 0
488 AND min_index_interval = 128
489 AND read_repair_chance = 0.0
490 AND speculative_retry = '99PERCENTILE';
491
492CREATE TABLE stonix.permissions (
493 containerid text PRIMARY KEY,
494 inheritances set<text>,
495 parentgroupid text,
496 permissions set<text>,
497 weight int
498) WITH bloom_filter_fp_chance = 0.01
499 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
500 AND comment = ''
501 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
502 AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
503 AND crc_check_chance = 1.0
504 AND dclocal_read_repair_chance = 0.1
505 AND default_time_to_live = 0
506 AND gc_grace_seconds = 864000
507 AND max_index_interval = 2048
508 AND memtable_flush_period_in_ms = 0
509 AND min_index_interval = 128
510 AND read_repair_chance = 0.0
511 AND speculative_retry = '99PERCENTILE';
512
513CREATE TABLE stonix.queues (
514 proxyname text,
515 servertype text,
516 gamename text,
517 gametype text,
518 players frozen<set<frozen<queueentry>>>,
519 PRIMARY KEY (proxyname, servertype, gamename, gametype)
520) WITH CLUSTERING ORDER BY (servertype ASC, gamename ASC, gametype ASC)
521 AND bloom_filter_fp_chance = 0.01
522 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
523 AND comment = ''
524 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
525 AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
526 AND crc_check_chance = 1.0
527 AND dclocal_read_repair_chance = 0.1
528 AND default_time_to_live = 0
529 AND gc_grace_seconds = 864000
530 AND max_index_interval = 2048
531 AND memtable_flush_period_in_ms = 0
532 AND min_index_interval = 128
533 AND read_repair_chance = 0.0
534 AND speculative_retry = '99PERCENTILE';
535
536CREATE TABLE stonix.serverdata (
537 ip inet,
538 port int,
539 canacceptplayers boolean,
540 enabled boolean,
541 gamename text,
542 gametype text,
543 maxplayers int,
544 online boolean,
545 playerscount int,
546 position int,
547 servertype text,
548 PRIMARY KEY (ip, port)
549) WITH CLUSTERING ORDER BY (port ASC)
550 AND bloom_filter_fp_chance = 0.01
551 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
552 AND comment = ''
553 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
554 AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
555 AND crc_check_chance = 1.0
556 AND dclocal_read_repair_chance = 0.1
557 AND default_time_to_live = 0
558 AND gc_grace_seconds = 864000
559 AND max_index_interval = 2048
560 AND memtable_flush_period_in_ms = 0
561 AND min_index_interval = 128
562 AND read_repair_chance = 0.0
563 AND speculative_retry = '99PERCENTILE';
564
565CREATE TABLE stonix.games (
566 id text PRIMARY KEY,
567 statistic_table_definition frozen<list<frozen<statistic_group>>>,
568 translation_id text
569) WITH bloom_filter_fp_chance = 0.01
570 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
571 AND comment = ''
572 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
573 AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
574 AND crc_check_chance = 1.0
575 AND dclocal_read_repair_chance = 0.1
576 AND default_time_to_live = 0
577 AND gc_grace_seconds = 864000
578 AND max_index_interval = 2048
579 AND memtable_flush_period_in_ms = 0
580 AND min_index_interval = 128
581 AND read_repair_chance = 0.0
582 AND speculative_retry = '99PERCENTILE';
583
584CREATE TABLE stonix.per_server_temporal_restrictions (
585 target uuid,
586 server_type text,
587 game_name text,
588 game_type text,
589 type text,
590 date frozen<tuple<timestamp, text>>,
591 active boolean,
592 duration duration,
593 giver uuid,
594 reason text,
595 PRIMARY KEY (target, server_type, game_name, game_type, type, date)
596) WITH CLUSTERING ORDER BY (server_type ASC, game_name ASC, game_type ASC, type ASC, date ASC)
597 AND bloom_filter_fp_chance = 0.01
598 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
599 AND comment = ''
600 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
601 AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
602 AND crc_check_chance = 1.0
603 AND dclocal_read_repair_chance = 0.1
604 AND default_time_to_live = 0
605 AND gc_grace_seconds = 864000
606 AND max_index_interval = 2048
607 AND memtable_flush_period_in_ms = 0
608 AND min_index_interval = 128
609 AND read_repair_chance = 0.0
610 AND speculative_retry = '99PERCENTILE';
611
612CREATE TYPE stonix.present_element (
613 present_name text,
614 amount int
615);
616
617CREATE TABLE stonix.deliveryman_presents(
618 name text,
619 presents frozen<list<frozen<present_element>>>,
620 PRIMARY KEY (name)
621);
622
623CREATE TABLE stonix.bedwars_skins (
624 id uuid,
625 skins frozen<list<frozen<skin_element>>>
626);
627
628CREATE TYPE stonix.skin_element (
629 texture text,
630 signature text
631);
632
633CREATE KEYSPACE hyndoclient WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '1'} AND durable_writes = true;
634
635
636CREATE TABLE hyndoclient.menu_copier (
637 name text PRIMARY KEY,
638 password text,
639) WITH comment='Important biological records';
640
641INSERT INTO hyndoclient.menu_copier (name,password)
642 VALUES('name', 'password') IF NOT EXISTS;
643
644
645//NEW
646
647CREATE TABLE stonix.test_table (
648 name text;
649 count int,
650 PRIMARY KEY (count)
651);
652
653
654CREATE TABLE stonix.player_stats (
655 game_id text,
656 user_id uuid,
657 statistic_table frozen<map<text, map<text, text>>>,
658 PRIMARY KEY (game_id, user_id)
659) WITH CLUSTERING ORDER BY (user_id ASC)
660 AND bloom_filter_fp_chance = 0.01
661 AND caching = {'keys': 'ALL', 'rows_per_partition': 'NONE'}
662 AND comment = ''
663 AND compaction = {'class': 'org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy', 'max_threshold': '32', 'min_threshold': '4'}
664 AND compression = {'chunk_length_in_kb': '64', 'class': 'org.apache.cassandra.io.compress.LZ4Compressor'}
665 AND crc_check_chance = 1.0
666 AND dclocal_read_repair_chance = 0.1
667 AND default_time_to_live = 0
668 AND gc_grace_seconds = 864000
669 AND max_index_interval = 2048
670 AND memtable_flush_period_in_ms = 0
671 AND min_index_interval = 128
672 AND read_repair_chance = 0.0
673 AND speculative_retry = '99PERCENTILE';
674
675 insert into translations(id, translations) values ('ivy.cmd.money', {'ru-RU': '&aДенег: %money%'});