-
Notifications
You must be signed in to change notification settings - Fork 6
/
db.cql
50 lines (41 loc) · 1.27 KB
/
db.cql
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
CREATE KEYSPACE chat
WITH replication = {'class':'SimpleStrategy', 'replication_factor' : 1};
CREATE TABLE chat.users(
id VARCHAR ,
username VARCHAR PRIMARY KEY
);
-- CREATE INDEX tb_users_id ON chat.users (id);
CREATE TABLE chat.room(
id VARCHAR ,
room_name VARCHAR PRIMARY KEY
);
-- CREATE INDEX tb_room_id ON chat.room (id);
CREATE TABLE chat.room_members(
room_name VARCHAR,
username VARCHAR,
PRIMARY KEY(room_name,username)
);
-- CREATE INDEX tb_room_members_roomid ON chat.room_members (room_name);
CREATE TABLE chat.user_mapping(
username VARCHAR PRIMARY KEY,
server_id VARCHAR
);
-- CREATE INDEX tb_user_mapping_userid ON chat.user_mapping (username);
CREATE TABLE chat.private_chat(
id VARCHAR PRIMARY KEY,
sender VARCHAR,
receiver VARCHAR ,
msg TEXT,
timestamp timestamp
);
CREATE INDEX tb_private_chat_TIMESTAMP ON chat.private_chat(timestamp);
CREATE INDEX tb_private_chat_SENDER ON chat.private_chat(sender);
CREATE TABLE chat.group_chat(
id VARCHAR PRIMARY KEY,
sender VARCHAR,
msg TEXT,
group VARCHAR,
timestamp timestamp
);
CREATE INDEX tb_group_chat_TIMSTAMP ON chat.group_chat(timestamp);
CREATE INDEX tb_group_chat_SENDER ON chat.group_chat(sender);