-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathcassandra-schema
29 lines (28 loc) · 1.01 KB
/
cassandra-schema
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
create keyspace dutycal with placement_strategy = 'org.apache.cassandra.locator.SimpleStrategy' and strategy_options = {replication_factor:1};
create column family events with comparator = 'AsciiType' and key_validation_class = 'AsciiType' and column_metadata = [
{column_name: title,
validation_class: UTF8Type},
{column_name: description,
validation_class: UTF8Type},
{column_name: owner,
validation_class: AsciiType,
index_type: 0,
index_name: events_owner_idx},
{column_name: start,
validation_class: DateType,
index_type: 0,
index_name: events_start_idx},
{column_name: end,
validation_class: DateType,
index_type: 0,
index_name: events_end_idx},
{column_name: required,
validation_class: BooleanType},
{column_name: week,
validation_class: LongType,
index_type: 0,
index_name: events_week_idx},
{column_name: reference,
validation_class: AsciiType},
{column_name: generatorID,
validation_class: BytesType}];