LinkBolt/database.sqlite at main · Extrevarqanze/LinkBolt · 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
SQLite format 3@  .���������[��
cW	[		��	����c##�tableuser_badgesuser_badgesCREATE TABLE user_badges (
    userId TEXT,
    badgeId TEXT,
    PRIMARY KEY(userId, badgeId),
    FOREIGN KEY(userId) REFERENCES users(id),
    FOREIGN KEY(badgeId) REFERENCES badges(id)
  )5I#indexsqlite_autoindex_user_badges_1user_badges~�WtablebadgesbadgesCREATE TABLE badges (
    id TEXT PRIMARY KEY,
    name TEXT,
    icon TEXT,
    description TEXT
  )+?indexsqlite_autoindex_badges_1badges��	tableguestbookguestbookCREATE TABLE guestbook (
    id TEXT PRIMARY KEY,
    profileId TEXT,
    authorName TEXT,
    message TEXT,
    createdAt INTEGER,
    status TEXT DEFAULT 'pending', -- 'pending', 'approved', 'spam'
    FOREIGN KEY(profileId) REFERENCES profiles(id)
  )1Eindexsqlite_autoindex_guestbook_1guestbookP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)��YtableanalyticsanalyticsCREATE TABLE analytics (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    profileId TEXT,
    timestamp INTEGER,
    type TEXT, -- 'view', 'click'
    ref TEXT,
    country TEXT,
    FOREIGN KEY(profileId) REFERENCES profiles(id)
  )�q	�9tablewidgetswidgets
CREATE TABLE widgets (
    id TEXT PRIMARY KEY,
    profileId TEXT,
    type TEXT,
    config TEXT,
    x INTEGER,
    y INTEGER,
    w INTEGER,
    h INTEGER,
    FOREIGN KEY(profileId) REFERENCES profiles(id)
  )-
Aindexsqlite_autoindex_widgets_1widgets�%%�mtableintegrationsintegrationsCREATE TABLE integrations (
    userId TEXT,
    platform TEXT,
    accessToken TEXT,
    refreshToken TEXT,
    lastFmUsername TEXT,
    updatedAt INTEGER,
    PRIMARY KEY(userId, platform),
    FOREIGN KEY(userId) REFERENCES users(id)
  )7K%indexsqlite_autoindex_integrations_1integrations	��UtableprofilesprofilesCREATE TABLE profiles (
    id TEXT PRIMARY KEY,
    userId TEXT,
    customUsername TEXT UNIQUE,
    displayName TEXT,
    bio TEXT,
    pfpOverride TEXT,
    backgroundType TEXT,
    backgroundValue TEXT,
    theme TEXT,
    badges TEXT,
    socials TEXT,
    layout TEXT,
    isDefault INTEGER DEFAULT 0,
    FOREIGN KEY(userId) REFERENCES users(id)
  )/Cindexsqlite_autoindex_profiles_2profiles/Cindexsqlite_autoindex_profiles_1profiles�b�#tableusersusersCREATE TABLE users (
    id TEXT PRIMARY KEY,
    discordId TEXT UNIQUE,
    username TEXT,
    discriminator TEXT,
    avatar TEXT,
    accessToken TEXT,
    refreshToken TEXT,
    createdAt INTEGER
  ))=indexsqlite_autoindex_users_2users)=indexsqlite_autoindex_users_1users