sonolus-server-cpp/data2.sql at main · SonolusHaniwa/sonolus-server-cpp · GitHub

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
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
CREATE TABLE Comment (
    name text,
    targetType text,
    targetName text,
    uid text,
    time int,
    content text
);
CREATE TABLE LikeTable (
    name text,
    targetType text,
    targetName text,
    uid text
);
CREATE TABLE Rating (
    name text,
    targetType text,
    targetName text,
    uid text,
    rating int
);
CREATE TABLE Record (
    id int,
    name text,
    type text,
    item int,
    replay int,
    player text,
    startTime int,
    saveTime int,
    duration float,
    inputOffset float,
    playAreaWidth int,
    playAreaHeight int,
    grade text,
    arcadeScore int,
    accuracyScore int,
    combo int,
    perfect int,
    great int,
    good int,
    miss int,
    totalCount int,
    isPrivate boolean,
    allowRank boolean,
    isRank boolean
);
CREATE TABLE Replay (
    id int,
    name text,
    version int,
    title text,
    subtitle text,
    author text,
    level int,
    data text,
    configuration text,
    tags text,
    description text,
    localization text,
    isPrivate boolean DEFAULT 0,
    isRank boolean DEFAULT 1,
    allowRank boolean DEFAULT 0
);
CREATE TABLE Room (
	id int,
	name text,
	version int,
	title text,
	subtitle text,
	master text,
	cover text,
	bgm text,
	preview text,
	tags text,
	localization text,
	creatorId text
);
CREATE TABLE UserProfile (
    id text,
    handle text,
    name text,
    avatarForegroundColor text,
    avatarBackgroundColor text,
    aboutMe text,
    socialLinks text,
    favorites text
);
CREATE TABLE UserSession (
    uid text,
    session text,
    expire int,
   	body text,
   	signature text
);