-
Notifications
You must be signed in to change notification settings - Fork 155
/
schema.txt
executable file
·57 lines (53 loc) · 2.48 KB
/
schema.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
create keyspace Twitter with
placement_strategy = 'org.apache.cassandra.locator.SimpleStrategy' AND
strategy_options = [{replication_factor:1}];
use Twitter;
create column family Users with comparator = 'UTF8Type';
create column family UserAudits with comparator = 'UTF8Type';
create column family UserCounters with comparator = 'UTF8Type' and
default_validation_class = CounterColumnType;
create column family UserCounterAggregates with column_type = 'Super'
and comparator = 'UTF8Type' and
subcomparator = 'UTF8Type' and
default_validation_class = CounterColumnType;
create column family UserRelationships with
comparator = 'UTF8Type' and
column_type = 'Super' and
subcomparator = 'TimeUUIDType';
create column family Usernames with comparator = 'UTF8Type';
create column family Statuses
with comparator = 'UTF8Type'
and column_metadata = [
{column_name: 'tags', validation_class: 'BytesType', index_type: 'KEYS'}
];
create column family StatusAudits with comparator = 'UTF8Type';
create column family StatusRelationships with
comparator = 'UTF8Type' and
column_type = 'Super' and
subcomparator = 'TimeUUIDType';
create column family Indexes with
comparator = 'UTF8Type' and
column_type = 'Super';
create column family TimelinishThings with
comparator = 'BytesType';
create keyspace Multiblog with
placement_strategy = 'org.apache.cassandra.locator.SimpleStrategy' AND
strategy_options = [{replication_factor:1}];
use Multiblog;
create column family Blogs with comparator = 'TimeUUIDType';
create column family Comments with comparator = 'TimeUUIDType';
create keyspace MultiblogLong with
placement_strategy = 'org.apache.cassandra.locator.SimpleStrategy' AND
strategy_options = [{replication_factor:1}];
use MultiblogLong;
create column family Blogs with comparator = 'LongType';
create column family Comments with comparator = 'LongType';
create keyspace TypeConversions with
placement_strategy = 'org.apache.cassandra.locator.SimpleStrategy' AND
strategy_options = [{replication_factor:1}];
use TypeConversions;
create column family UUIDColumnConversion with comparator = TimeUUIDType;
create column family SuperUUID with comparator = TimeUUIDType and column_type = Super;
create column family CompositeColumnConversion with comparator = 'CompositeType(IntegerType, UTF8Type)';
create column family DynamicComposite with comparator ='DynamicCompositeType
(a=>AsciiType,b=>BytesType,i=>IntegerType,x=>LexicalUUIDType,l=>LongType,t=>TimeUUIDType,s=>UTF8Type,u=>UUIDType)';