sDpmVhRH

1CREATE_TABLE_USERS = """CREATE TABLE IF NOT EXISTS users (
2    `id` INTEGER PRIMARY KEY,
3    `user_id` INTEGER NOT NULL,
4    `message_id` INTEGER NOT NULL,
5    `like` SMALLINT DEFAULT 0,
6    `heart` SMALLINT DEFAULT 0,
7    `fire` SMALLINT DEFAULT 0,
8    `dislike` SMALLINT DEFAULT 0
9)"""
10
11GET_DATA = """
12SELECT message_id, SUM(`like`) AS `like`, SUM(heart) AS `heart`, SUM(fire) AS `fire`, SUM(dislike) 
13AS `dislike` FROM users AS u WHERE u.message_id = message_id GROUP BY message_id
14"""
15
16INSERT_DATA = "INSERT INTO users(user_id, message_id, `%s`) VALUES(%s, %s, 1)"
17
18