Skip to content

Commit e79c6c7

Browse files
bcambelbcambel
committed
Cassandra Schema
1 parent aab8ff1 commit e79c6c7

File tree

1 file changed

+285
-0
lines changed

1 file changed

+285
-0
lines changed

‎schema.csql

Lines changed: 285 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,285 @@
1+
# Cassandra Schema
2+
3+
CREATE TABLE status_replies (
4+
KEY blob PRIMARY KEY
5+
) WITH
6+
comment='' AND
7+
comparator=varint AND
8+
read_repair_chance=0.100000 AND
9+
gc_grace_seconds=864000 AND
10+
default_validation=blob AND
11+
min_compaction_threshold=4 AND
12+
max_compaction_threshold=32 AND
13+
replicate_on_write='true' AND
14+
compaction_strategy_class='SizeTieredCompactionStrategy' AND
15+
compression_parameters:sstable_compression='SnappyCompressor';
16+
17+
CREATE TABLE status (
18+
KEY blob PRIMARY KEY
19+
) WITH
20+
comment='' AND
21+
comparator=blob AND
22+
read_repair_chance=0.100000 AND
23+
gc_grace_seconds=864000 AND
24+
default_validation=blob AND
25+
min_compaction_threshold=4 AND
26+
max_compaction_threshold=32 AND
27+
replicate_on_write='true' AND
28+
compaction_strategy_class='SizeTieredCompactionStrategy' AND
29+
compression_parameters:sstable_compression='SnappyCompressor';
30+
31+
CREATE TABLE channel_timeline (
32+
KEY blob PRIMARY KEY
33+
) WITH
34+
comment='' AND
35+
comparator=varint AND
36+
read_repair_chance=0.100000 AND
37+
gc_grace_seconds=864000 AND
38+
default_validation=blob AND
39+
min_compaction_threshold=4 AND
40+
max_compaction_threshold=32 AND
41+
replicate_on_write='true' AND
42+
compaction_strategy_class='SizeTieredCompactionStrategy' AND
43+
compression_parameters:sstable_compression='SnappyCompressor';
44+
45+
CREATE TABLE user_resweets (
46+
KEY blob PRIMARY KEY
47+
) WITH
48+
comment='' AND
49+
comparator=varint AND
50+
read_repair_chance=0.100000 AND
51+
gc_grace_seconds=864000 AND
52+
default_validation=blob AND
53+
min_compaction_threshold=4 AND
54+
max_compaction_threshold=32 AND
55+
replicate_on_write='true' AND
56+
compaction_strategy_class='SizeTieredCompactionStrategy' AND
57+
compression_parameters:sstable_compression='SnappyCompressor';
58+
59+
CREATE TABLE status_upvotes (
60+
KEY blob PRIMARY KEY
61+
) WITH
62+
comment='' AND
63+
comparator=varint AND
64+
read_repair_chance=0.100000 AND
65+
gc_grace_seconds=864000 AND
66+
default_validation=blob AND
67+
min_compaction_threshold=4 AND
68+
max_compaction_threshold=32 AND
69+
replicate_on_write='true' AND
70+
compaction_strategy_class='SizeTieredCompactionStrategy' AND
71+
compression_parameters:sstable_compression='SnappyCompressor';
72+
73+
CREATE TABLE user_downvotes (
74+
KEY blob PRIMARY KEY
75+
) WITH
76+
comment='' AND
77+
comparator=varint AND
78+
read_repair_chance=0.100000 AND
79+
gc_grace_seconds=864000 AND
80+
default_validation=blob AND
81+
min_compaction_threshold=4 AND
82+
max_compaction_threshold=32 AND
83+
replicate_on_write='true' AND
84+
compaction_strategy_class='SizeTieredCompactionStrategy' AND
85+
compression_parameters:sstable_compression='SnappyCompressor';
86+
87+
CREATE TABLE user_following (
88+
KEY blob PRIMARY KEY
89+
) WITH
90+
comment='' AND
91+
comparator=blob AND
92+
read_repair_chance=0.100000 AND
93+
gc_grace_seconds=864000 AND
94+
default_validation=blob AND
95+
min_compaction_threshold=4 AND
96+
max_compaction_threshold=32 AND
97+
replicate_on_write='true' AND
98+
compaction_strategy_class='SizeTieredCompactionStrategy' AND
99+
compression_parameters:sstable_compression='SnappyCompressor';
100+
101+
CREATE TABLE status_favs (
102+
KEY blob PRIMARY KEY
103+
) WITH
104+
comment='' AND
105+
comparator=varint AND
106+
read_repair_chance=0.100000 AND
107+
gc_grace_seconds=864000 AND
108+
default_validation=blob AND
109+
min_compaction_threshold=4 AND
110+
max_compaction_threshold=32 AND
111+
replicate_on_write='true' AND
112+
compaction_strategy_class='SizeTieredCompactionStrategy' AND
113+
compression_parameters:sstable_compression='SnappyCompressor';
114+
115+
CREATE TABLE status_resweets (
116+
KEY blob PRIMARY KEY
117+
) WITH
118+
comment='' AND
119+
comparator=varint AND
120+
read_repair_chance=0.100000 AND
121+
gc_grace_seconds=864000 AND
122+
default_validation=blob AND
123+
min_compaction_threshold=4 AND
124+
max_compaction_threshold=32 AND
125+
replicate_on_write='true' AND
126+
compaction_strategy_class='SizeTieredCompactionStrategy' AND
127+
compression_parameters:sstable_compression='SnappyCompressor';
128+
129+
CREATE TABLE user_following_timeline (
130+
KEY blob PRIMARY KEY
131+
) WITH
132+
comment='' AND
133+
comparator=varint AND
134+
read_repair_chance=0.100000 AND
135+
gc_grace_seconds=864000 AND
136+
default_validation=blob AND
137+
min_compaction_threshold=4 AND
138+
max_compaction_threshold=32 AND
139+
replicate_on_write='true' AND
140+
compaction_strategy_class='SizeTieredCompactionStrategy' AND
141+
compression_parameters:sstable_compression='SnappyCompressor';
142+
143+
CREATE TABLE counters (
144+
KEY blob PRIMARY KEY
145+
) WITH
146+
comment='' AND
147+
comparator=text AND
148+
read_repair_chance=0.100000 AND
149+
gc_grace_seconds=864000 AND
150+
default_validation=counter AND
151+
min_compaction_threshold=4 AND
152+
max_compaction_threshold=32 AND
153+
replicate_on_write='true' AND
154+
compaction_strategy_class='SizeTieredCompactionStrategy' AND
155+
compression_parameters:sstable_compression='SnappyCompressor';
156+
157+
CREATE TABLE user_replies (
158+
KEY blob PRIMARY KEY
159+
) WITH
160+
comment='' AND
161+
comparator=varint AND
162+
read_repair_chance=0.100000 AND
163+
gc_grace_seconds=864000 AND
164+
default_validation=blob AND
165+
min_compaction_threshold=4 AND
166+
max_compaction_threshold=32 AND
167+
replicate_on_write='true' AND
168+
compaction_strategy_class='SizeTieredCompactionStrategy' AND
169+
compression_parameters:sstable_compression='SnappyCompressor';
170+
171+
CREATE TABLE status_downvotes (
172+
KEY blob PRIMARY KEY
173+
) WITH
174+
comment='' AND
175+
comparator=varint AND
176+
read_repair_chance=0.100000 AND
177+
gc_grace_seconds=864000 AND
178+
default_validation=blob AND
179+
min_compaction_threshold=4 AND
180+
max_compaction_threshold=32 AND
181+
replicate_on_write='true' AND
182+
compaction_strategy_class='SizeTieredCompactionStrategy' AND
183+
compression_parameters:sstable_compression='SnappyCompressor';
184+
185+
CREATE TABLE user_upvotes (
186+
KEY blob PRIMARY KEY
187+
) WITH
188+
comment='' AND
189+
comparator=varint AND
190+
read_repair_chance=0.100000 AND
191+
gc_grace_seconds=864000 AND
192+
default_validation=blob AND
193+
min_compaction_threshold=4 AND
194+
max_compaction_threshold=32 AND
195+
replicate_on_write='true' AND
196+
compaction_strategy_class='SizeTieredCompactionStrategy' AND
197+
compression_parameters:sstable_compression='SnappyCompressor';
198+
199+
CREATE TABLE user_followers (
200+
KEY blob PRIMARY KEY
201+
) WITH
202+
comment='' AND
203+
comparator=blob AND
204+
read_repair_chance=0.100000 AND
205+
gc_grace_seconds=864000 AND
206+
default_validation=blob AND
207+
min_compaction_threshold=4 AND
208+
max_compaction_threshold=32 AND
209+
replicate_on_write='true' AND
210+
compaction_strategy_class='SizeTieredCompactionStrategy' AND
211+
compression_parameters:sstable_compression='SnappyCompressor';
212+
213+
CREATE TABLE user2 (
214+
KEY blob PRIMARY KEY,
215+
nick text,
216+
data blob
217+
) WITH
218+
comment='' AND
219+
comparator=ascii AND
220+
read_repair_chance=0.100000 AND
221+
gc_grace_seconds=864000 AND
222+
default_validation=blob AND
223+
min_compaction_threshold=4 AND
224+
max_compaction_threshold=32 AND
225+
replicate_on_write='true' AND
226+
compaction_strategy_class='SizeTieredCompactionStrategy' AND
227+
compression_parameters:sstable_compression='SnappyCompressor';
228+
229+
CREATE INDEX user2_nick_idx ON user2 (nick);
230+
231+
CREATE TABLE user_timeline (
232+
KEY blob PRIMARY KEY
233+
) WITH
234+
comment='' AND
235+
comparator=varint AND
236+
read_repair_chance=0.100000 AND
237+
gc_grace_seconds=864000 AND
238+
default_validation=blob AND
239+
min_compaction_threshold=4 AND
240+
max_compaction_threshold=32 AND
241+
replicate_on_write='true' AND
242+
compaction_strategy_class='SizeTieredCompactionStrategy' AND
243+
compression_parameters:sstable_compression='SnappyCompressor';
244+
245+
CREATE TABLE tweets (
246+
KEY blob PRIMARY KEY
247+
) WITH
248+
comment='' AND
249+
comparator=blob AND
250+
read_repair_chance=0.100000 AND
251+
gc_grace_seconds=864000 AND
252+
default_validation=blob AND
253+
min_compaction_threshold=4 AND
254+
max_compaction_threshold=32 AND
255+
replicate_on_write='true' AND
256+
compaction_strategy_class='SizeTieredCompactionStrategy' AND
257+
compression_parameters:sstable_compression='SnappyCompressor';
258+
259+
CREATE TABLE user (
260+
KEY blob PRIMARY KEY
261+
) WITH
262+
comment='' AND
263+
comparator=blob AND
264+
read_repair_chance=0.100000 AND
265+
gc_grace_seconds=864000 AND
266+
default_validation=blob AND
267+
min_compaction_threshold=4 AND
268+
max_compaction_threshold=32 AND
269+
replicate_on_write='true' AND
270+
compaction_strategy_class='SizeTieredCompactionStrategy' AND
271+
compression_parameters:sstable_compression='SnappyCompressor';
272+
273+
CREATE TABLE user_favs (
274+
KEY blob PRIMARY KEY
275+
) WITH
276+
comment='' AND
277+
comparator=varint AND
278+
read_repair_chance=0.100000 AND
279+
gc_grace_seconds=864000 AND
280+
default_validation=blob AND
281+
min_compaction_threshold=4 AND
282+
max_compaction_threshold=32 AND
283+
replicate_on_write='true' AND
284+
compaction_strategy_class='SizeTieredCompactionStrategy' AND
285+
compression_parameters:sstable_compression='SnappyCompressor';

0 commit comments

Comments
 (0)