-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathddl.cql
22 lines (17 loc) · 907 Bytes
/
ddl.cql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
-- Keyspace
CREATE KEYSPACE sample_keyspace
WITH replication = {'class': 'SimpleStrategy', 'replication_factor': '1'}
AND durable_writes = true;
-- User table
CREATE TABLE sample_keyspace.user (
cpf text,
name text,
domain text,
PRIMARY KEY (cpf));
INSERT INTO sample_keyspace.user(cpf,name,domain)VALUES ('41540790851','Julio','IT');
INSERT INTO sample_keyspace.user(cpf,name,domain) VALUES('41540790852','Teste','IT');
INSERT INTO sample_keyspace.user(cpf,name,domain) VALUES('41540790853','Teste3','IT');
INSERT INTO sample_keyspace.user(cpf,name,domain) VALUES('41540790854','Teste4','IT');
INSERT INTO sample_keyspace.user(cpf,name,domain) VALUES('41540790855','Teste5','IT');
INSERT INTO sample_keyspace.user(cpf,name,domain) VALUES('41540790856','Teste6','IT');
INSERT INTO sample_keyspace.user(cpf,name,domain) VALUES('41540790857','Teste7','IT');